Articles on: View planograms

Discrete / Continuous Distribution (Planograms)

Discrete distribution


Discrete distribution divides products into 4 groups depending on the selected metric, with the results displayed in colors on the planogram:


  • Red: 0-10%
  • Blue: 10-50%
  • Yellow: 50-90%
  • Green: 90-100%


Enter the needed values in the Distribution Groups column to set the desired group boundaries. This allows you to adapt the classification to the needs of your analysis.


Continuous distribution


In a continuous distribution, products are highlighted in the same color with different saturations. The higher the value of the metric, the greater the color saturation.


The metrics by which the distribution is formed:

  • Turnover (by default)
  • **Sales qty **
  • Receipts quantity
  • **Profit **
  • **Stock qty **
  • **Stocks price **
  • **Price **
  • **Turnover per linear meter of equipment **
  • Profit per linear meter of equipment


How the distribution is formed


In order to make better use of PlanoHero analytics, let's look at the main stages of distribution formation for analysing the effectiveness of planograms.


1 Stage: Calculate metrics for products within the planogram


At the first stage, for each product included in the planogram, the main metrics for the selected period are calculated. This data is the basis for further analysis:

  • Turnover
    Total revenue received from the sale of products for the period.
  • Profit
    The difference between the turnover and the cost of products.
  • Receipts qty
    The number of unique receipts in which the product was mentioned.
  • Sales qty
    Total number of units sold during the period.


2 Stage: Formation of planogram rating


After the value of the selected metric is formed, a rating is created for each planogram according to the following principle:

  1. Defining the most successful planogram
    The planogram with the best score is selected as the base and is taken as 100%.
  2. Comparison of other planograms
    All other planograms receive a percentage value relative to the most successful one.


For example, if planogram A has a turnover of 10,000 (100%) and planogram B has a turnover of 8,000, its rating will be 80%.


Important! Keep in mind that PlanoHero does not track which shelf a was sold from. Therefore, if one product is placed in several planograms and was sold during the specified period, its sales are taken into account in all planograms where it is present. Example:Coca-Cola is located on three planograms and 5 units were sold during the period. These 5 sales are recorded simultaneously in all three planograms.


How are metrics calculated in discrete analysis?


The main subject of the analysis is the share, which is used to evaluate various aspects of the store's performance.


The shares of turnover, number of sales, number of receipts, and profit from the planogram are calculated using the following formula:


*y = (y1100) / y2 **


where:
y - the share to be found (turnover, number of sales, profit, etc.)
y1 - the value of the metric from which the share is to be found
y2 - the sum of the values of the corresponding metric (y1) of all products in the planogram


*Calculation example: *
Determine the profit share of the product "Water X" from the planogram:
*y1 - is the profit for the selected period for the product "Water X" *
*y2 - is the sum of the profits of all products in the planogram for the selected period. *
The share of profit of the product "Water X" from the planogram= (480 * 100) / 4338= 11%


Important! Round the result to two decimal places.


Table with metrics


A table with data for the selected period is displayed at the bottom of the page. It contains the following metrics:


  • **Product name **
  • Article
  • Turnover
    The amount of cash receipts from product sales for the selected period in the selected store.
  • Average turnover
    The arithmetic average of the turnover in all active store plans where the product is displayed. The metric is available only if the product is used in the library planogram.
  • Turnover share of planogram
    Turnover share of planogram = (Product turnover × 100) / Sum of turnovers of all products on the planogram.
  • Average share of turnover from planogram
    Average share of turnover from planogram = (Average product turnover × 100) / Sum of turnovers of all products on the planogram.
  • Turnover per linear m. of layout
    Turnover per linear m. of layout = Products turnover / Linear meters of display.
  • **Average turnover per layout linear meter m. **
  • Sales qty
    The sum of the number of sales of the product on the planogram for the selected period.
  • Average quantity of sales
  • Sales qty share of planogram
    Sales qty share of planogram = (Number of product sales × 100) / Sum of the number of sales of all products per planogram.
  • **Average share of sales from the planogram **
  • Receipts qty
    The total number of sales receipts (excluding the number of return receipts) for the selected period.
    Receipts qty= (Number of product receipts × 100) / Sum of the number of receipts of all products on the planogram.
  • Average receipts quantity
  • **Receipts qty share of planogram **
  • Average share of the receipts quantity from the planogram
  • Profit
    The difference between the cash proceeds from the sale of products (turnover) and the cost of products.
  • **Average profit **
  • Profit share of planogram
    Profit share from the planogram = (Product profit / Sum of profits of the products on the planogram) × 100.
  • Average profit share from the planogram
  • Profit per linear m. of layout
    Profit per linear m. of layout = Product profit / Square meters of display.
  • **Average profit per layout linear meter m. **
  • Stock qty
    The sum of the stock of all the products set out in the planogram at the end of the specified period.
  • Stock qty share of planogram
    Stock qty share of planogram = (Quantity of product balances × 100%) / Sum of the number of balances of all products in the planogram.
  • Stocks price
    Stocks price = Cost price of products × Quantity of balances.


Updated on: 19/02/2025

Was this article helpful?

Share your feedback

Cancel

Thank you!