Syntha Lab RU

Replenishment by size: what and how much to send to stores by size

From the stock, the goods in transit and the sales of each “store × size” cell calculates the target stock in weeks of cover with a minimum display, the need rounded up to the pack multiple and distributes the limited warehouse across sizes: cells with the lowest cover first. Shows how much to send and what the warehouse lacks.

Working with stock: transfers, top-up, defects, prices, order entry For whom: Category managers, chain and logistics directors, allocation analysts.

Calculate on your data →

At a glance

What question does it answer?
What and how much to send to stores by size from a limited warehouse.
What data is needed?
Cells “store × size”: stock, in transit, sales over the window; the warehouse by size.
How to read the result?
On the example of 6 cells the need with the multiple is 44 units and 42 can be sent from the warehouse: size L is limited to 4 units of the 6 needed, 2 units go to a reorder. Cover rises from 0.9 to 3.2 weeks, empty cells were 2 and became 0. The warehouse goes first to the cells with the lowest cover. Example on the default values: Cells in the calculation: 6; Need with the multiple: 44 pcs; Send from the warehouse: 42 pcs; Missing in the warehouse (to buy): 2 pcs. The figures are illustrative: enter your own to see your result.

Why and how to reason

Replenishment answers “what and how much to send to each store”, and the answer is built on sizes: an empty “store × size” cell is a lost sale, an excess cell is frozen money. For each cell we compute speed: sold in the window ÷ weeks in the window. Cell target = max (minimum display, speed × target cover, rounded up). Need = target − stock − in transit, rounded up to the pack multiple. In the example the window is 4 weeks, cover 3 weeks. “Central, S”: sold 8, speed 2 a week, target 6, stock 1, need 5, with a multiple of 2 that is 6. The warehouse is limited: if a size is not enough for all, cells with the lowest cover are served first. Size L: need 6, warehouse 4, short by 2. Average cover rises from 0.9 to 3.2 weeks, empty cells go from 2 to 0.

When to use it

It is meant for daily or weekly replenishment of a chain and before shipping to an online shop. It suits retail with several points and a size matrix. It does not suit unique pieces or the first allocation of a new collection: it has no sales history. Assumptions: sales speed in the window continues; cover in weeks is set by you; warehouse stock by size is known; goods in transit are already counted.

How to read the result

Compare “send from warehouse” with “need including multiples”: the difference is what the warehouse lacks, that is, a list for reorder or redistribution between stores. Cover before and after shows how filled the cells are. Empty cells after shipping are either a warehouse shortage or no sales. Do not send goods where there are no sales: the minimum display target must be deliberate. Check that the pack multiple does not create a surplus for small stores. The decision: how much and where to send today. Repeat the calculation regularly: a store’s size profile changes faster than it seems.

Common mistakes

Taking a one-week window: speed is noisy. Ignoring goods in transit and getting a double shipment. Setting minimum display above reasonable for small stores: goods will sit for “fear of an empty shelf”. Another mistake: counting sizes without noting that one size sells in the store and another only online.

What data is needed?

  • Cells “store × size”: stock, in transit, sales over the window; the warehouse by size.
  • Rules: the sales window, the target cover in weeks, the minimum display, the sending multiple.

Inputs

FieldUnitValue in the exampleMeaning
Sales window in the tableweeks4Over how many weeks the sales of a cell are given.
Target stock coverweeks3How many weeks of sales a cell should cover after sending. You set it; there is no single standard in Russia. The default is set for apparel; for footwear, accessories and children’s pick a set above the form or enter your own data.
Minimum display per cellpcs2We do not leave fewer units of a size in a store than this. The default is set for apparel; for footwear, accessories and children’s pick a set above the form or enter your own data.
Sending multiplepcs2We send multiples of this number (a pair, a pack). The need is rounded up, the warehouse stock is counted down.

How it is calculated

StepFormula
Sales a weeksold in the window ÷ weeks of the window
Cell targetthe larger of (minimum display, sales a week × target cover, rounded up)
Need(target − stock − in transit), rounded up to the multiple
Shipmentthe need, but not more than the warehouse for the size (rounded down to the multiple); cells by ascending cover

Worked numbers

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

Cells in the calculation
6
Need with the multiple
44 pcs
Send from the warehouse
42 pcs
Missing in the warehouse (to buy)
2 pcs
Empty cells in stores before sending
2
Empty cells after sending
0
Cover in weeks before sending
0.9
Cover in weeks after sending
3.2
Left in the warehouse
2 pcs

What to send by cell

CellStock and in transitSales a weekCover, weeksTarget, pcsNeedSend
Center · S120.5666
Center · M350.6151212
Center · L01.50564
Mega · M260.3181616
Mega · L515300
Mega · S632944

The warehouse is divided from the lowest cover to the highest within each size. Top-up does not replace a buying decision: the missing part (if any) goes to a reorder or an order.

The names of the algorithm and the metrics (top-up, replenishment, rebalancing) in your company may differ. Sales over a short window are noisy: for rare sizes take a longer window.

Nuances and limits

  • Taking a too short sales window: rare sizes give noise.
  • Ignoring goods in transit: a cell will get too much.
  • There is no single cover standard in Russia: you set the target.

Terms used

Calculate on your data →