Dashboard, monitoring and plots

The dashboard provides an executive summary of the project’s outputs. The following indicators and graphs are included:

Scenario

  • All items. Total number of items.
  • Items to be priced. Number of items to be priced:
    • When the Update price variable is supplied in optimization data, this indicator is the number of items with Update price =1
    • When that variable is not suppled, all items are assumed to be optimized.

Data

  • Zero initial price. Number of items with a zero initial price.
  • Initial price below cost. Number of items with a reference price below the unit cost.
  • Zero cost. Number of items with zero unit cost.
  • With comp price. Number of items with a least one competition price.

Results

  • Priced. Number of items with a price recommendation, among items to be priced.
  • Not priced. Number of items without a price recommendation, among items to be priced.

New prices

  • Priced down. Number of items with a downward price recommendation, among items to be priced.
  • Price unchanged. Number of items with an unchanged price recommendation, among items to be priced.
  • Priced up. Number of items with an upward price recommendation, among items to be priced.
  • Price var. above 20%. Number of items with a recommended price variation (downward or upward) above 20% from the reference price, among items to be priced.
  • Price aligned on lower bound. Number of items with recommended price aligned on lower price bounds, among items to be priced.
  • Price aligned on unit cost. Number of items with recommended price aligned on unit cost, among items to be priced.
  • Price aligned on comp price. Number of items with recommended price aligned on the lowest competition price, among items to be priced.

Alignment with competition

  • Alignment on competition (number of items). Pie chart of recommended prices aligned with competition, by competitor.
  • Impact on prices (number of items). Pie chart of recommended prices – respectively down, up or unchanged.

The dashboard includes a summary table of results by item. Items can be selected by clicking on the dashboard's indicators. This table can be used for interactive price validation.

Objectives and prices over time

This tab offers two plots, for all categories or category by category:

  • the objective (turnover or total margin ) and quantity sold are ploted over time
  • reference prices and competition prices (if available) are plotted over time. Competitors can be selected, including mean competition price. Prices are means over the category or all categories.

The start and end dates can be adjusted.

Prices vs competition now

This graph is a snapshot of the latest competition and reference prices for all categories or by category. Each dot is an item. Competition prices are represented on the vertical axis and own (reference and if available optimal) prices on the vertical axis. The diagonal (where competition and reference prices are equal) is represented for convenience.

A/B testing

This tab reports on the current A/B test in the project.

Two histograms are provided for all categories, or by category:

  • Histogram of price elasticities; the vertical axis represents the frequency (the number of items).
  • Histogram of optimal price variations (price variations between the current reference price and the recommended optimal price, in %); the vertical axis represents the frequency (the number of items).

  • The plot on the left-hand panel shows the demand functions for the selected category. Each curve represents an item. The horizontal axis represents the price inclusive of taxes and the vertical axis the sold quantity.
  • The plot on right-hand side shows either the profit function (when the optimization module is activated and the objective is volume of margin maximization), or the turnover function (when the optimization module is not activated or when the objective is turnover maximization).

For each curve, both reference and optimal prices are shown if the latter are available.