Syntha Lab RU

Planogram: slots, display stock, cover, turnover and the meters needed by category

For each category counts how many items fit on the display (slots), what stock stands on display, how many weeks of sales it covers, how fast it turns and how many meters are needed at the target cover. Shows the surplus and deficit of meters, how many can be moved, how often to replenish, revenue and margin per meter and the return on display stock (GMROI).

Full cost of the premises and display For whom: Category managers, merchandisers and retail directors who decide how many meters to give a category and how often to replenish the display.

Calculate on your data →

At a glance

What question does it answer?
Whether a category has enough room for its sales, for how many weeks of sales the display lasts, where to take meters from and where to give them, how often to replenish.
What data is needed?
Meters and items per meter by category: from a hall measurement.
How to read the result?
Example on the default values (5 categories, 50 meters): slots 462, display stock 416 units, cover overall 1.75 wk; surplus 10 m, deficit 4.6 m, movable 4.6 m. Display GMROI 34.62. Example on the default values: Selling slots on display: 462; Stock on display: 416 units; Display cover overall: 1.75 wk; Display turnover per year: 29.6 times. The figures are illustrative: enter your own to see your result.

Why and how to reason

Hall meters cost rent, so the argument “this category has too little room” must be turned into numbers. We start with slots: a meter of rail holds as many items as their size allows, and 10 meters of dresses at a density of 8 items per meter give 80 slots. But not all slots are filled, some air between items is unavoidable: at a fill of 90% there are 72 dresses on display. Next we compare stock with sales: if 70 dresses sell a week, the display lasts 72 ÷ 70 = 1.03 weeks and by evening the hangers are empty. The target cover says how many weeks of sales should stand on display (say 1.5). From this the meters needed: 70 × 1.5 ÷ (8 × 0.9) = 14.6 m, and there are 10, so a deficit of 4.6 m. For outerwear it is the opposite: 8.3 m are needed, 12 stand, a surplus of 3.7 m. Replenishment is counted like this: when the display falls to the threshold (40%), the other 60% is brought into the hall, and for dresses that is 1.6 replenishments a week.

When to use it

It fits when distributing meters between categories, revising the season planogram, opening a store and checking why a hit category has empty hangers. Do not use it as an order to rearrange the hall: a category may carry traffic or add-on sales, and the calculation does not see the back room and stock by size. Assumptions: sales for a normal week without periods of no stock, the same fill, density by item type. Test the move of meters in some stores.

How to read the result

First look at “Lowest cover”: dresses have 1.03 weeks against a target of 1.5, which is where sales are lost. Then “Meters in deficit” (4.6 m) and “Meters in surplus” (10 m): only the smaller of them can be moved, that is 4.6 m, leave the rest of the surplus or give it to those who grow. Revenue per meter is on average RUB 19,718 a week: compare categories in the table, accessories have only RUB 4,400 but the margin is high, so do not cut them by revenue. A display turnover of 29.6 times a year shows speed, not the quality of stock. Overall cover of 1.75 weeks can hide a deficit in one category with a surplus in another.

Common mistakes

A common error is entering one density per meter for all clothing types, which makes slots and cover wrong. Second: taking sales of a week with a promotion or without stock. Third: moving the whole surplus into the deficit category without a test and losing traffic. Fourth: confusing display stock with store stock: the calculation does not count the back room.

What data is needed?

  • Meters and items per meter by category: from a hall measurement.
  • Weekly sales without periods of no stock, price and margin excl. VAT.
  • Fill of slots, target cover and replenishment threshold: your rules.

Inputs

FieldUnitValue in the exampleMeaning
Fill of slots%90What share of slots is really occupied by items: empty places and air between items. From your own measurement, not the example: there is no single standard in Russia.
Target display coverweeks1.5For how many weeks of sales the display stock should last (the back room is not counted). Set by the category role; the example is illustrative.
Replenishment threshold%40At what share of the full display it is replenished. The higher the threshold, the more frequent the replenishment and the fewer empty hangers; the example is illustrative.

How it is calculated

StepFormula
Slotsmetres × items per metre
Display stockslots × fill
Coverstock ÷ weekly sales
Metres neededweekly sales × target cover ÷ (items per metre × fill)
Replenishments a weeksales ÷ (stock × (1 − threshold))

Worked numbers

Default values from the app; in the interactive version you enter your own.

Selling slots on display
462
Stock on display
416 units
Display cover overall
1.75 wk
Display turnover per year
29.6 times
Revenue per metre a week
19,718 ₽
Metres in surplus
10 m
Metres in deficit
4.6 m
Can be moved without losing cover
4.6 mThe smaller of the sum of surpluses and the sum of deficits: more cannot be moved without leaving the target cover.
Lowest cover
1.03 wk · Dresses
Highest cover
2.95 wk · Accessories
Replenishments a week across categories
4.7
Return on display stock (GMROI)
34.62×Annual display margin ÷ display stock at cost.
Display metres: actual and needed by category
Bar chart: Outerwear 12, Dresses 10, Trousers and jeans 14, Knitwear (stacks) 8, Accessories 6051015OuterwearOuterwearActual, m: 1212Needed, m: 8.38.3DressesDressesActual, m: 1010Needed, m: 14.614.6Trousers and jeansTrousers and jeansActual, m: 1414Needed, m: 13.913.9Knitwear (stacks)Knitwear (stacks)Actual, m: 88Needed, m: 4.84.8AccessoriesAccessoriesActual, m: 66Needed, m: 3.13.1m
  • Actual, m
  • Needed, m
Data as a table
MeasureActual, mNeeded, m
Outerwear128.3
Dresses1014.6
Trousers and jeans1413.9
Knitwear (stacks)84.8
Accessories63.1

Categories on display

CategoryMetresSlotsStock, unitsCover, wkTurnover a yearRevenue per metreMargin per metreMetres neededDifference, mReplenishments a wk
Outerwear127264.82.1624.122,500 ₽11,700 ₽8.33.70.8
Dresses1080721.0350.631,500 ₽17,325 ₽14.6−4.61.6
Trousers and jeans14126113.41.5134.418,750 ₽9,375 ₽13.90.11.1
Knitwear (stacks)8112100.82.5220.614,000 ₽7,560 ₽4.83.20.7
Accessories67264.82.9517.74,400 ₽2,728 ₽3.12.90.6

Cover is below the target for: Dresses. More metres or more frequent replenishment are needed; empty hangers in fast sizes lose sales.

The calculation shows where metres do not match sales but does not order moving them: a category may play a role in traffic or in the basket. Test a move in some stores with control stores. Cover is counted in display units and does not show cover by size.

Nuances and limits

  • Taking a single density per meter for all clothing types: slots are overstated or understated.
  • Taking sales of periods without stock: demand is understated, meters seem enough.
  • Moving all surpluses at once without a test: a category may affect traffic and basket.

Terms used

Calculate on your data →