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.
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
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Sales window in the table | weeks | 4 | Over how many weeks the sales of a cell are given. |
| Target stock cover | weeks | 3 | How 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 cell | pcs | 2 | We 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 multiple | pcs | 2 | We send multiples of this number (a pair, a pack). The need is rounded up, the warehouse stock is counted down. |
How it is calculated
| Step | Formula |
|---|---|
| Sales a week | sold in the window ÷ weeks of the window |
| Cell target | the larger of (minimum display, sales a week × target cover, rounded up) |
| Need | (target − stock − in transit), rounded up to the multiple |
| Shipment | the 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
| Cell | Stock and in transit | Sales a week | Cover, weeks | Target, pcs | Need | Send |
|---|---|---|---|---|---|---|
| Center · S | 1 | 2 | 0.5 | 6 | 6 | 6 |
| Center · M | 3 | 5 | 0.6 | 15 | 12 | 12 |
| Center · L | 0 | 1.5 | 0 | 5 | 6 | 4 |
| Mega · M | 2 | 6 | 0.3 | 18 | 16 | 16 |
| Mega · L | 5 | 1 | 5 | 3 | 0 | 0 |
| Mega · S | 6 | 3 | 2 | 9 | 4 | 4 |
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.