Articles on: View store plans

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.


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.


  1. Filter by the planogram type:
  • All (by default);
  • Basic;
  • Additional.


  1. Group the data:
  • By planograms;
  • By categories;
  • By brands;
  • By suppliers.


  1. 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.
Note! 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: 18/02/2025

Was this article helpful?

Share your feedback

Cancel

Thank you!