Weeks of supply
Units on hand ÷ weekly units sold
Forward-looking runway in weeks. Best matched to a markdown calendar, since price periods are usually planned in weeks.
Weeks of supply = units on hand ÷ average weekly units sold. If a style has 500 units on hand and is selling 50 units a week, weeks of supply is 500 ÷ 50 = 10 weeks. That number only means something next to the weeks actually remaining in the selling window.
If 10 weeks are left in the season, that style is exactly on pace — the stock and the calendar run out together. If only 6 weeks are left, weeks of supply (10) exceeds weeks remaining (6): the current price will not clear the stock, and a markdown should move earlier rather than wait for a worse read next week.
Units on hand ÷ weekly units sold
At current pace over 10 weeks left
On-hand minus projected units sold
At or below target ending stock
Weeks of supply compared with weeks left in the season
Use a trailing 2-4 week average for a current-pace read, or your planned weekly rate for a forward-looking projection into the next price period.
Trailing weeks of supply uses recent actual sales and answers "where do we stand today." Forward-looking weeks of supply substitutes the planned weekly rate for the next price period — the rate your markdown schedule assumes — and answers "will this plan actually clear the stock." Run both: a gap between them means the plan is assuming a lift that hasn't shown up yet.
| Units on hand | Units / week | Weeks of supply | Weeks left | Read |
|---|---|---|---|---|
| 500 | 50 | 10.0 wks | 10 wks | On pace |
| 500 | 35 | 14.3 wks | 10 wks | Behind — pull the break forward |
| 500 | 20 | 25.0 wks | 10 wks | Badly behind — break now and deeper |
| 500 | 80 | 6.3 wks | 10 wks | Ahead — delay or soften the break |
| 500 | 0 | ∞ | 10 wks | Stalled — investigate before pricing |
Related velocity metrics
All three describe the same underlying pace, at different time scales and directions.
Units on hand ÷ weekly units sold
Forward-looking runway in weeks. Best matched to a markdown calendar, since price periods are usually planned in weeks.
Units on hand ÷ average daily units sold
The same idea expressed in days instead of weeks — multiply weeks of supply by 7 to convert between them.
Units or $ sold ÷ average inventory, over a season or year
A backward-looking rate for a full period, not a point-in-time runway. High turnover and a high current weeks of supply can coexist if pace just slowed.
The weekly percentage that feeds directly into the weeks-of-supply denominator.
The backward-looking counterpart to a point-in-time weeks-of-supply read.
Turning a weeks-of-supply gap into an actual markdown decision date.
Weeks of supply that's too low is a buying signal, not a markdown signal.
Answers
Enter your remaining units and weekly pace once, then plan price breaks across every remaining week of the season.
Free, no sign-up, with CSV export and a shareable link. Pro ($29/mo) saves named season plans, imports inventory CSVs, and prints a decision memo.