Allocation across stores
Allocation to stores: splitting an arriving batch between stores and the warehouse. The aim is to even out stock in weeks of sales across stores so fast ones do not empty and slow ones do not accumulate leftover. The decision is taken at every delivery.
Formula
Desired store stock = sales share × (allocatable + current stock); allocate = desired − current
How to read
Suppose a store gives 20% of sales, we allocate 500 units and the current balance is 40: desired stock 0.2 × (500 + 40) = 108, allocate 108 − 40 = 68 units. Good allocation evens out stock in weeks of sales, not in units.
Where it is discussed
Topics
- Revenue, profit and costs
- Stock and turnover
- Buying budget and cash
- Assortment and sizes
- Replenishment and stock cover
- Forecast and budget
- Production and import
- Cash and working capital
- Size runs, stores and range in season
- Marketing budget and testing impact
- Owner’s cash and management dashboard
- Capital, multi-brand and the planning cycle
Calculations
- Overheads by product and responsibility center: three allocation keys
- Buy budget allocation by marginal return
- Allocation of stock across stores
- Initial allocation of a new item without history
- Does moving stock between stores pay back
- Replenishment by size: what and how much to send to stores by size
- Landed cost by style: spreading the shipment
- Optimal marketing budget allocation across channels
- Allocating a stock among stores: by demand and limits against the proportional