Syntha Lab RU

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.

Replenishment and stock cover For whom: Allocation planners and network managers who spread a new item without sales history.

Calculate on your data →

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

FieldUnitValue in the exampleMeaning
Batch, unitspcs1,000How many units of the new item arrived at the central warehouse. The example value is illustrative.
Central reserve for top-ups%20The 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, unitspcs12A 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 Apcs3The best stores. Grades can be taken from the clusters (storecluster). The example value is illustrative.
Weight of grade A×3How many times a grade A store gets more than a store of weight 1. The example value is illustrative.
Stores of grade Bpcs5Middle stores. The example value is illustrative.
Weight of grade B×2The weight of middle stores. The example value is illustrative.
Stores of grade Cpcs4Weak stores. The example value is illustrative.
Weight of grade C×1The weight of weak stores. The example value is illustrative.

How it is calculated

StepFormula
Poolbatch × (1 − 20%) = 800 units
Sum of weightsstores of the grade × weight, over three grades
Allocation per storepool × weight ÷ sum of weights, not below 12 units
Roundingdown, the remainder by the largest fractional remainder
Reservebatch − 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
Allocation by grade, units
Bar chart: Grade A 312, Grade B 348, Grade C 140, Reserve 2000100200300400Grade AGrade AUnits: 312312Grade BGrade BUnits: 348348Grade CGrade CUnits: 140140ReserveReserveUnits: 200200
Data as a table
MeasureUnits
Grade A312
Grade B348
Grade C140
Reserve200

Allocation by grade

GradeStoresWeightCalculated per storeAllocation per storeGrade total
A33104.3104312
B5269.669–70348
C4134.835140

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.

Terms used

Calculate on your data →