Initial allocation of a new item without history
Spreads the first batch of a new item across stores of three grades with a central reserve for top-ups: the grade weight, the minimum display, rounding by the largest remainder. Shows the allocation per store and the actual reserve.
At a glance
- What question does it answer?
- How much to give each store and how much to keep in the central reserve for top-ups.
- What data is needed?
- The batch size and the reserve share.
- How to read the result?
- Compare the actual reserve with the planned one: if it is lower the minimum display absorbed the pool. Example on the default values: Pool to allocate, units: 800; Allocated to stores, units: 800; Actual central reserve, units: 200; Reserve of the batch, %: 20%. The figures are illustrative: enter your own to see your result.
Why and how to reason
A new item has no history, so it is spread by the weights of store grades and a part is kept for top-ups. In the example the batch is 1,000 units, the reserve 20%, grades of 3, 5 and 4 stores with weights 3, 2, 1: the calculation is 104.3, 69.6 and 34.8 units per store, 800 are allocated, the reserve is 200 units.
When to use it
Apply at the first shipment of a new item; top-ups by the sales of the first weeks are run by replenishment (replen), this is not it.
How to read the result
Compare the actual reserve with the planned one and the minimum allocation with the minimum display.
Common mistakes
Everything is spread at once, everyone gets the same, the minimum display is ignored.
What data is needed?
- The batch size and the reserve share.
- The number of stores by grade and the weights.
- The minimum display.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Batch, units | pcs | 1,000 | How many units of the new item arrived at the central warehouse. The example value is illustrative. |
| Central reserve for top-ups | % | 20 | The share of the batch that is not spread at once: a stock for top-ups by actual sales. Higher for remote regions. The example value is illustrative. |
| Minimum display per store, units | pcs | 12 | A store is not given less than this: otherwise the item does not look right. If the pool is short the reserve shrinks. The example value is illustrative. |
| Stores of grade A | pcs | 3 | The best stores. Grades can be taken from the clusters (storecluster). The example value is illustrative. |
| Weight of grade A | × | 3 | How many times a grade A store gets more than a store of weight 1. The example value is illustrative. |
| Stores of grade B | pcs | 5 | Middle stores. The example value is illustrative. |
| Weight of grade B | × | 2 | The weight of middle stores. The example value is illustrative. |
| Stores of grade C | pcs | 4 | Weak stores. The example value is illustrative. |
| Weight of grade C | × | 1 | The weight of weak stores. The example value is illustrative. |
How it is calculated
| Step | Formula |
|---|---|
| Pool | batch × (1 − 20%) = 800 units |
| Sum of weights | stores of the grade × weight, over three grades |
| Allocation per store | pool × weight ÷ sum of weights, not below 12 units |
| Rounding | down, the remainder by the largest fractional remainder |
| Reserve | batch − sum of allocations |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Pool to allocate, units
- 800
- Allocated to stores, units
- 800
- Actual central reserve, units
- 200
- Reserve of the batch, %
- 20 %
- Calculated allocation to a grade A store, units
- 104.3
- Calculated allocation to a grade B store, units
- 69.6
- Calculated allocation to a grade C store, units
- 34.8
- Minimum allocation to a store, units
- 35
Data as a table
| Measure | Units |
|---|---|
| Grade A | 312 |
| Grade B | 348 |
| Grade C | 140 |
| Reserve | 200 |
Allocation by grade
| Grade | Stores | Weight | Calculated per store | Allocation per store | Grade total |
|---|---|---|---|---|---|
| A | 3 | 3 | 104.3 | 104 | 312 |
| B | 5 | 2 | 69.6 | 69–70 | 348 |
| C | 4 | 1 | 34.8 | 35 | 140 |
Units left after rounding down go to the stores with the largest fractional remainder; on a tie the stores of the grade with the larger weight get them first.
What to do with the result: ship the allocation, keep the reserve at the central warehouse and top up by the sales of the first weeks (replen); for remote stores set a larger reserve because of the delivery time.
A typical mistake: spreading everything at once and being left without stock for top-ups; giving everyone the same; ignoring the minimum display.
Nuances and limits
- Spreading everything at once.
- Giving everyone the same.
- Ignoring the minimum display.