Analysis of laid out products
The "Analysis of laid out products" report allows to thoroughly analyze products laid out on stores planograms. This tool helps to visualize key metrics in the form of color highlighting to quickly identify which equipment is the most efficient or need to be optimized.
When setting up the report, the planograms on the store plan are highlighted in different colors depending on the value of the selected metric:
Saturated color – the highest values of the metric.
Transparent (almost white) color – values close to zero.
This allows you to visually determine the effectiveness of each planogram.
To enable the diagram, click on the icon in the upper right corner of the store plan:
The diagram shows the rating of the planograms according to the selected metric in the settings.
To customize the report:
Select one of the metrics:
Linear meters of equipment;
Linear meters of layout;
Products quantity;
Planogram fullness, % (by default);
Turnover per linear meter of equipment;
Profit per linear meter of equipment;
Turnover efficiency ratio;
Profit efficiency ratio.
Filter by the planogram type:
All (by default);
Basic;
Additional.
Group the data:
By planograms;
By categories;
By brands;
By suppliers.
Set up columns display
The report allows you to analyze a wide range of metrics, including:
Product name
Planogram name
Planogram type
Planogram category
Laid out product category
Article
Product type
Barcode
Category
Brand
Supplier
Planogram fullness, %
Planogram fullness = Linear meters of layout / Linear meters of equipment.
Facings qty
The sum of product facings from all shelves of the planogram.
Recommended facings qty
The values are taken from the RecommendedFaces table. If the table is not filled in, the result is "-" by default.
Product stock on the shelf, pcs./kg
The total quantity of the products on the planogram.
For packaged products:
Product stock on the shelf = Facings qty Placement depth Placement height.
For bulk products:
Product stock on the shelf = package weight or “1” if package weight was not set.
Product stock on the shelf, days
Displays how many days the displayed product will last. Stock on the shelf = Stock, pcs / Average number of product sales per day.
Note! If the product did not have any sales, then “0” is displayed. For bulk products = Product stock on the shelf * 1. Average sales qty per day is calculated for the selected period.
Stock quantity
Stock of the laid out product on the planogram at the end of the selected period.
Linear meters of layout
For packaged product or bulk product in package:
Linear meters of layout = Product width * Facings quantity.
For bulk products in a box:
Linear meters of layout = Box length - Wall thickness.
Share of layout from equipment
Displays the share of the product layout from the equipment throughout the store. Share of layout from equipment = (Linear meters of layout * 100) / Linear meters of equipment on which the product is placed.
Turnover
Revenue from sales of the product for the selected period.
Turnover per linear m. of equipment
Turnover per linear m. of equipment = Product’s turnover for the selected period / Linear meters of equipment on which the product is placed.
Turnover per linear m. of layout
Turnover per linear m. of layout = Product’s turnover for the selected period / Product’s linear meters of the layout.
Turnover share of planogram, %
Turnover share of planogram, % = (Product’s turnover for the selected period / the sum of turnover of the products placed on the planograms where the product is located) * 100.
Turnover efficiency ratio
Turnover efficiency ratio = Turnover share of planogram, % / Share of layout from equipment.
Profit
The difference between the revenue from the sale of the product (turnover) and the cost price for the selected period.
Profit per linear m. of equipment
Profit per linear m. of equipment = Product’s profit for the selected period / Linear meters of equipment on which the product is placed.
Profit per linear m. of layout
Profit per linear m. of layout = Product’s profit for the selected period / Product’s linear meters of the layout.
Profit share of planogram, %
Profit share of planogram, % = (Product’s profit for the selected period / the sum of profit of the products placed on the planograms where the product is located) * 100
Profit efficiency ratio
Profit efficiency ratio = Profit share of planogram, % / Share of layout from equipment.
Sales qty
Product’s sales quantity for the selected period.
Receipts qty
The number of unique occurrences of the product in the receipts for the selected period.
Average sales qty per day
Average sales qty per day = Product’s sales quantity for the selected period / Days quantity in the selected period.
How does the report work?
When setting up the report, the planograms on the store plan are highlighted in different colors depending on the value of the selected metric:
Saturated color – the highest values of the metric.
Transparent (almost white) color – values close to zero.
This allows you to visually determine the effectiveness of each planogram.
To enable the diagram, click on the icon in the upper right corner of the store plan:
The diagram shows the rating of the planograms according to the selected metric in the settings.
Report settings
To customize the report:
Select one of the metrics:
Linear meters of equipment;
Linear meters of layout;
Products quantity;
Planogram fullness, % (by default);
Turnover per linear meter of equipment;
Profit per linear meter of equipment;
Turnover efficiency ratio;
Profit efficiency ratio.
Filter by the planogram type:
All (by default);
Basic;
Additional.
Group the data:
By planograms;
By categories;
By brands;
By suppliers.
Set up columns display
Available metrics for analysis
The report allows you to analyze a wide range of metrics, including:
Product attributes
Product name
Planogram name
Planogram type
Planogram category
Laid out product category
Article
Product type
Barcode
Category
Brand
Supplier
Layout indicators
Planogram fullness, %
Planogram fullness = Linear meters of layout / Linear meters of equipment.
Facings qty
The sum of product facings from all shelves of the planogram.
Recommended facings qty
The values are taken from the RecommendedFaces table. If the table is not filled in, the result is "-" by default.
Product stock on the shelf, pcs./kg
The total quantity of the products on the planogram.
For packaged products:
Product stock on the shelf = Facings qty Placement depth Placement height.
For bulk products:
Product stock on the shelf = package weight or “1” if package weight was not set.
Product stock on the shelf, days
Displays how many days the displayed product will last. Stock on the shelf = Stock, pcs / Average number of product sales per day.
Note! If the product did not have any sales, then “0” is displayed. For bulk products = Product stock on the shelf * 1. Average sales qty per day is calculated for the selected period.
Stock quantity
Stock of the laid out product on the planogram at the end of the selected period.
Linear meters of layout
For packaged product or bulk product in package:
Linear meters of layout = Product width * Facings quantity.
For bulk products in a box:
Linear meters of layout = Box length - Wall thickness.
Share of layout from equipment
Displays the share of the product layout from the equipment throughout the store. Share of layout from equipment = (Linear meters of layout * 100) / Linear meters of equipment on which the product is placed.
Sales indicators
Turnover
Revenue from sales of the product for the selected period.
Turnover per linear m. of equipment
Turnover per linear m. of equipment = Product’s turnover for the selected period / Linear meters of equipment on which the product is placed.
Turnover per linear m. of layout
Turnover per linear m. of layout = Product’s turnover for the selected period / Product’s linear meters of the layout.
Turnover share of planogram, %
Turnover share of planogram, % = (Product’s turnover for the selected period / the sum of turnover of the products placed on the planograms where the product is located) * 100.
Turnover efficiency ratio
Turnover efficiency ratio = Turnover share of planogram, % / Share of layout from equipment.
Profit
The difference between the revenue from the sale of the product (turnover) and the cost price for the selected period.
Profit per linear m. of equipment
Profit per linear m. of equipment = Product’s profit for the selected period / Linear meters of equipment on which the product is placed.
Profit per linear m. of layout
Profit per linear m. of layout = Product’s profit for the selected period / Product’s linear meters of the layout.
Profit share of planogram, %
Profit share of planogram, % = (Product’s profit for the selected period / the sum of profit of the products placed on the planograms where the product is located) * 100
Profit efficiency ratio
Profit efficiency ratio = Profit share of planogram, % / Share of layout from equipment.
Sales qty
Product’s sales quantity for the selected period.
Receipts qty
The number of unique occurrences of the product in the receipts for the selected period.
Average sales qty per day
Average sales qty per day = Product’s sales quantity for the selected period / Days quantity in the selected period.
Updated on: 16/01/2025
Thank you!