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:
Defining the most successful planogram
The planogram with the best score is selected as the base and is taken as 100%.
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 = (y1*100) / 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: 17/01/2025