ABC analysis
With the help of ABC analysis, you can analyse the products on the equipment according to the degree of profitability for the chain.
ABC analysis divides products into three groups based on four metrics: Turnover, Profit, Sales qty and Receipts qty:
Products in Group A — the most profitable.
Products in Group B — intermediate products.
Products in Group C — the least profitable.
For the selected period, the data on the products in the planogram are collected according to the selected metric, for example, turnover. The products are then sorted in descending order of value.
Products that account for 80% of the total value of the metric belong to group A (the most profitable). The next 15% of products form Group B, and the last 5% form Group C.
In order to change the boundaries of the distribution groups, you need to go to the report settings (the button on the right of the toolbar) and enter the desired values in the appropriate fields in the Distribution groups column. This will allow you to redefine which group each product belongs to depending on its metric.
To change the color of a group, just click on the color opposite the group and choose from the palette or enter a hex code.
To change the period for which the report is generated, click on the Period field. By default, the analysis includes the last 30 days.
To change the metric for which the report will be displayed, click on the Display drop-down box in the lower left part. By default, the ABC distribution by turnover is displayed.
To download the report in Excel format, click on the corresponding button in the upper right corner.
To configure the display of metrics (columns) in the report, click on the corresponding icon at the top right of the table.
The report allows you to analyse a wide range of metrics, including:
Product name
Article
Product type
Packaged or weight
Turnover
The amount of cash receipts from sales of products for the selected period.
Average turnover
The average amount of turnover received during the selected period.
Turnover ABC
Displays the products' belonging by turnover in relation to the established ABC distribution groups.
Turnover ABC = (Turnover of products * 100) \ Turnover of all products on the planogram
ABC by average turnover
The arithmetic mean of ABC turnover for the selected period.
Profit
The difference between cash proceeds from the sale of products (turnover) and the cost of products.
Average profit
Profit ABC
Reflects affiliation of the product to profit in relation to the established ABC distribution groups.
ABC in terms of average profit
Receipts quantity
The total number of sales receipts (excluding the number of return receipts) for the selected period.
Average receipts quantity
Receipts qty ABC
Displays to which group (A, B or C) the product belongs depending on its quantity of receipts quantity relative to the set ABC distribution settings.
ABC by average receipts quantity
Sales qty
Shows how many times a certain product or products from a certain category were sold during the selected period.
Average quantity of sales
Sales qty ABC
Displays which group (A, B, or C) the product belongs to, depending on its sales quantity relative to the set ABC distribution settings.
ABC by average sales
Product stock on the shelf, pcs./kg
The total quantity of the products on the planogram.
For packaged products:
Number of cases х Depth of layout х Height of layout.
For weighted products:
Weight of the package or "1" if the weight of the package is not specified.
ABC analysis divides products into three groups based on four metrics: Turnover, Profit, Sales qty and Receipts qty:
Products in Group A — the most profitable.
Products in Group B — intermediate products.
Products in Group C — the least profitable.
How the product rating is formed according to the selected metric
For the selected period, the data on the products in the planogram are collected according to the selected metric, for example, turnover. The products are then sorted in descending order of value.
Products that account for 80% of the total value of the metric belong to group A (the most profitable). The next 15% of products form Group B, and the last 5% form Group C.
Customise the report
In order to change the boundaries of the distribution groups, you need to go to the report settings (the button on the right of the toolbar) and enter the desired values in the appropriate fields in the Distribution groups column. This will allow you to redefine which group each product belongs to depending on its metric.
To change the color of a group, just click on the color opposite the group and choose from the palette or enter a hex code.
To change the period for which the report is generated, click on the Period field. By default, the analysis includes the last 30 days.
To change the metric for which the report will be displayed, click on the Display drop-down box in the lower left part. By default, the ABC distribution by turnover is displayed.
To download the report in Excel format, click on the corresponding button in the upper right corner.
To configure the display of metrics (columns) in the report, click on the corresponding icon at the top right of the table.
Available metrics for analysis
The report allows you to analyse a wide range of metrics, including:
Product name
Article
Product type
Packaged or weight
Turnover
The amount of cash receipts from sales of products for the selected period.
Average turnover
The average amount of turnover received during the selected period.
Turnover ABC
Displays the products' belonging by turnover in relation to the established ABC distribution groups.
Turnover ABC = (Turnover of products * 100) \ Turnover of all products on the planogram
ABC by average turnover
The arithmetic mean of ABC turnover for the selected period.
Profit
The difference between cash proceeds from the sale of products (turnover) and the cost of products.
Average profit
Profit ABC
Reflects affiliation of the product to profit in relation to the established ABC distribution groups.
ABC in terms of average profit
Receipts quantity
The total number of sales receipts (excluding the number of return receipts) for the selected period.
Average receipts quantity
Receipts qty ABC
Displays to which group (A, B or C) the product belongs depending on its quantity of receipts quantity relative to the set ABC distribution settings.
ABC by average receipts quantity
Sales qty
Shows how many times a certain product or products from a certain category were sold during the selected period.
Average quantity of sales
Sales qty ABC
Displays which group (A, B, or C) the product belongs to, depending on its sales quantity relative to the set ABC distribution settings.
ABC by average sales
Product stock on the shelf, pcs./kg
The total quantity of the products on the planogram.
For packaged products:
Number of cases х Depth of layout х Height of layout.
For weighted products:
Weight of the package or "1" if the weight of the package is not specified.
Updated on: 16/01/2025
Thank you!