Weeks of supply
For how many weeks the remainder lasts at the current sales pace.
Formula
Remaining ÷ average weekly sales
How to read
If higher than the weeks left in the season, the remainder will not sell without action.
Where it is discussed
Topics
- Buying budget and cash
- Season, price and discounts
- Assortment and sizes
- Replenishment and stock cover
- Collection and range
- Size runs, stores and range in season
- Working with stock: transfers, top-up, defects, prices, order entry
- The planning calendar
- KPI dictionary and common definitions
- Data model of standard reports
Calculations
- Open-to-buy (OTB) for the season
- Buying budget by category and weeks of supply
- Merchandise plan traffic light
- Weekly receipts from target weeks of supply (WOS)
- Season sell-through pace and leftover risk
- Post-season review by category
- Control week: full-price sell-through
- Allocation of stock across stores
- Size-run completeness and core sizes
- Does moving stock between stores pay back
- Replenishment by size: what and how much to send to stores by size
Documents
- Open-to-buy budget (OTB)
- Merchandise stock balance
- Stock turnover and dead stock
- Retail math by segment: IMU, MMU, markdowns, sell-through, GMROI, turnover
- Safety stock, service level and newsvendor: how much to hold and how much to order
- Markdown mathematics: steps, leftovers, timing and liquidation
- Warehouse and data: capacity for the peak, stock and sales reconciliation, returns, RFID and slotting