Weeks of supply
A forward-looking measure: current available units ÷ forecast weekly sales (if there is no forecast, average sales of the last 4–8 weeks). It looks ahead on today’s stock; the historical measure on average stock is “Days of inventory”
- Formula
A forward-looking measure: current available units ÷ forecast weekly sales (if there is no forecast, average sales of the last 4–8 weeks). It looks ahead on today’s stock; the historical measure on average stock is “Days of inventory”- Unit
- weeks
- Aggregation rule
- Ratio of sums
- Source system
- Warehouse and stock system; POS: receipts
- Owning role
- Category manager / merchandising analyst
- Frequency
- Weekly
Passport
- Grain
- SKU × warehouse × date; the slice total adds up in units
- Numerator
- Current available units
- Denominator
- Forecast weekly sales, units
- At zero or no data
- Forecast is 0: show “no sales forecast”, not infinity.
- Limits
- A forward-looking measure on current stock. Stock is available stock (no reserve or defects); count transit only if it is recorded so. The historical counterpart on average stock is “Days of inventory”.
- Check example
- Available units: 1800; Forecast weekly sales, units: 450.
a/b. Result: 4.0 weeks - Related metrics
Version 1.0 · valid from 2026-11-16 · checked 2026-11-16
Related pages
- Term: Weeks of supply
- Calculation: Days of inventory and excess stock
Definition
For how many weeks the remainder lasts at the current sales pace.
If higher than the weeks left in the season, the remainder will not sell without action.