Weeks of supply calculator

Weeks of supply (WOS) = units on hand ÷ average weekly units sold. It is the single number that turns a sell-through rate into a runway: how many weeks the current stock lasts at the current pace, compared with how many weeks you actually have left before the season ends.

Weeks of supply formula and worked example

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.

Weeks of supply calculator

Weeks of supply
11.1 wks

Units on hand ÷ weekly units sold

Units projected to sell
450

At current pace over 10 weeks left

Projected ending units
50

On-hand minus projected units sold

Gap vs target ending stock
+0 units

At or below target ending stock

Verdict
Behind pace

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.

Forward-looking WOS: trailing sales vs planned sales

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.

Weeks of supply against a fixed 10-week runway (500 units on hand)
Units on handUnits / weekWeeks of supplyWeeks leftRead
5005010.0 wks10 wksOn pace
5003514.3 wks10 wksBehind — pull the break forward
5002025.0 wks10 wksBadly behind — break now and deeper
500806.3 wks10 wksAhead — delay or soften the break
500010 wksStalled — investigate before pricing

Related velocity metrics

Weeks of supply vs days of inventory vs turnover

All three describe the same underlying pace, at different time scales and directions.

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.

Days of inventory

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.

Inventory turnover

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.

Keep planning

Answers

Weeks of supply questions

Turn a weeks-of-supply gap into a full markdown schedule

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.

Open the markdown planner