Forward Weeks of Supply (FWOS) Formula
How apparel planners calculate forward weeks of supply, why FWOS beats WOS at demand inflection points, and when to use each.
What Forward Weeks of Supply measures
Forward weeks of supply is the number of weeks of inventory remaining at the forecasted sales rate, not the trailing average. It is the WOS variant that works around demand inflection points — holiday ramps, product launches, post-peak declines.
FWOS = On-Hand Units ÷ Forecasted Average Weekly Unit SalesThe only input difference from WOS is the denominator: forecast replaces trailing average.
Worked apparel example
A DTC brand has 520 units on hand of a fleece going into October. The trailing 4-week average is 20 units/week — slow summer tail. The forecast for the next four weeks, built off prior-year plus trend, is 55 units/week as the cold-weather curve kicks in.
WOS = 520 ÷ 20 = 26.0 weeks (alarming — triggers a markdown) FWOS = 520 ÷ 55 = 9.5 weeks (healthy — triggers a chase discussion instead)
The trailing-average WOS would have driven a markdown on inventory that is about to be in heavy demand. FWOS catches it.
9.5 forward weeks of supply — balanced against forecast.
Benchmark ranges
Same bands as WOS. The difference is not in the ranges — it is in which version of the number you should trust at a given moment in the season.
When to use FWOS over WOS
| Situation | Use | Why | |---|---|---| | Stable mid-season | WOS | Trailing velocity is a reliable signal | | Pre-peak ramp (holiday, season launch) | FWOS | Trailing will understate forward demand | | Post-peak decline | FWOS | Trailing will overstate forward demand | | New product launch | FWOS only | No trailing history exists | | Promo-driven spike | WOS (trailing ex-promo) | Don't project promo velocity forward |
Failure modes we see
FWOS skipped because the forecast is "guesswork." Planners fall back on trailing WOS because it is objective. At inflection points, that objectivity is wrong. A defensible forecast — even a rough one — beats a precise trailing average that does not match reality.
Specific patterns:
- No forecast at the WOS grain. Forecast lives at department level; WOS lives at style × size. Brands cannot FWOS without forecast depth.
- Forecast never updated. Pre-season forecast frozen into the plan; no re-forecast as in-season reads come back. Week 4 actuals should re-shape the Week 5–12 forecast.
- Single forecast scenario. FWOS on the median forecast only, with no low/high scenarios, hides the range of outcomes.
How RetailNorthstar handles FWOS
Forecast runs at the style × size × channel × door grain that WOS and FWOS require. The system auto-switches dashboards between trailing WOS and FWOS based on season phase — so planners see the relevant number without having to toggle manually.
The planner's instinct at inflection points is usually right — "this is not representative." FWOS makes that instinct rigorous. It is not a replacement for WOS; it is the correct variant to use at the six to ten weeks per season where trailing averages mislead.
Related formulas
- Weeks of Supply — the trailing-average version
- Sell-Through Rate — the underlying velocity signal
- Open-to-Buy — FWOS drives chase OTB availability
See how RetailNorthstar auto-selects WOS vs FWOS based on season phase and forecast confidence.
Book a Demo →Frequently asked about Forward Weeks of Supply (FWOS)
What is the FWOS formula?
FWOS = On-Hand Units ÷ Forecasted Average Weekly Unit Sales. The only difference from standard WOS is the denominator — forecast replaces trailing average.
When is FWOS better than WOS?
At demand inflection points. Pre-peak ramps (holiday, seasonal launch), post-peak declines, and new product launches all distort trailing velocity. Trailing WOS tells you what was; FWOS tells you what will be.
Can I use FWOS without a sophisticated forecast?
Yes. Even a rough forecast — prior-year same-period plus trend — produces a more useful FWOS than a misleading trailing WOS at inflection. A defensible forecast beats an objectively wrong trailing average.
Should I replace WOS with FWOS everywhere?
No. WOS works fine in stable mid-season stretches where trailing velocity is reliable. The best systems auto-switch between WOS and FWOS based on season phase and forecast confidence.