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.

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:

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

2. Filter by the planogram type:

• All (by default);
• Basic;
• Additional.

3. Group the data:

• By planograms;
• By categories;
• By brands;
• By suppliers.

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

Reflects quantity of days the laid out product will be available for.

__For packaged products: __

Product stock on the shelf, days = Product stock on the shelf, pcs. / Average sales qty per day.

For bulk products:

Product stock on the shelf, days = Package weight / Average sales qty per day or Product stock on the shelf if the product is laid out in the box.

• 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: 18/02/2025