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%.

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%

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