Weeks of Supply (WOS) is one of the most important KPIs in retail inventory planning. It measures how many weeks your current inventory will last at your current or forecasted rate of sale, and it's the foundation of sound replenishment decisions.
Unlike raw inventory counts, WOS tells you whether your stock levels are actually healthy. A retailer with 10,000 units in a warehouse could be dangerously overstocked or critically undersupplied, depending entirely on how fast those units sell. WOS solves that problem.
What Is Weeks of Supply (WOS)?
Weeks of Supply measures how long your current inventory will last at a given rate of sale. It provides a standardized way to evaluate inventory health across products and categories; making it easy to compare a fast-moving basic tee (thousands of units) with a slow-moving outerwear piece (dozens of units) using a single metric.
WOS gives you three things that raw inventory numbers cannot:
- A health signal — are you carrying too much or too little for your demand?
- A cross-category standard — compare inventory coverage across categories regardless of volume differences
- An action trigger — know exactly when to place a purchase order or push one out
How to Calculate Weeks of Supply
There are two primary WOS formulas. Which one to use depends on whether you have a demand forecast.
1. Basic Weeks of Supply Formula
Formula:
WOS = Beginning of Period (BOP) Inventory ÷ Weekly Rate of Sale (ROS)
Example:
You have 250 units of a Basic White T-Shirt on hand. Over the trailing 4 weeks, it sold an average of 50 units per week.
WOS = 250 ÷ 50 = 5 weeks
At current velocity, you have 5 weeks of supply. The question this raises immediately: is 5 weeks healthy for this item? The answer depends on your lead time, demand variability, and target service levels which we cover in the WOS target-setting section below.
Limitation: This formula assumes trailing sales are a reliable proxy for future demand. For stable, non-seasonal basics, that's often fine. For fashion items or anything with significant seasonality, it can lead you astray.
2. Forward Weeks of Supply (FWOS) Formula
Formula:
FWOS = BOP Inventory ÷ Forecasted Weekly Rate of Sale
Example:
Same 250 units, but your demand forecast shows sales accelerating to 60 units per week as you head into a seasonal peak.
FWOS = 250 ÷ 60 = 4.2 weeks
You actually have 4.2 weeks, not 5. That difference matters when your supplier lead time is 6 weeks.
FWOS is the more accurate and actionable metric for planning. It accounts for the seasonality and trend shifts that trailing averages miss. The tradeoff: it requires a forward-looking demand forecast, which adds complexity. Platforms like Toolio automate this, generating FWOS visibility in real time across your assortment.
Why practitioners still use basic WOS: It's fast to calculate with readily available data. It works well for replenishment planning on stable core items. Use FWOS whenever seasonality or trend shifts are relevant.
Weeks of Supply vs. Weeks on Hand: What's the Difference?
These two terms are often used interchangeably, but they measure fundamentally different things — and confusing them leads to bad reorder decisions.
Weeks of Supply (WOS) is forward-looking. It projects how long your inventory will last based on expected future demand. Use it for buying decisions and replenishment timing.
Weeks on Hand (WOH) is backward-looking. It tells you how long your current inventory would have lasted based on historical sales. Use it for performance analysis and inventory turn reviews.
The formula structures are identical; what differs is the demand figure you plug in:
For planning purposes, always default to WOS. WOH can mislead you during demand inflections — entering a peak season, for example, when historical sales are low but forecasted sales are surging.
Why Your Rate of Sale Calculation Might Be Wrong
One of the most common errors in WOS calculation is using a raw average ROS that's been depressed by stockout periods. If an item was out of stock for part of the window you're averaging across, your true demand is higher than your ROS suggests; sometimes significantly higher.
The problem:
Suppose you're calculating ROS over the trailing 8 weeks. Your item sold 200 units in that period, but it was out of stock for 2 of those weeks. A naive calculation gives you:
Raw ROS = 200 units ÷ 8 weeks = 25 units/week
But during the 6 weeks it was actually in stock, it sold 200 units:
Stockout-adjusted ROS = 200 units ÷ 6 in-stock weeks = 33 units/week
That's a 32% underestimate of real demand. If you use the raw ROS to calculate WOS, you'll think you have more coverage than you actually do and you'll consistently under-buy.
How to correct for it:
Always calculate ROS only over weeks where the item was in stock (units available > 0, or above a minimum threshold you define). Most modern inventory planning tools track in-stock rate and can apply this adjustment automatically. If you're doing this in a spreadsheet, filter your weekly sales data to exclude any week where ending inventory was zero.
The takeaway: the quality of your WOS is only as good as the quality of your ROS. An accurate, stockout-adjusted rate of sale is the foundation.
How Lead Time Should Anchor Your WOS Target
Your WOS target isn't just a planning preference — it must be grounded in your supply chain realities. The most actionable heuristic for setting a minimum WOS target is simple:
Your WOS should always equal or exceed your supplier lead time, plus a safety buffer.
If your supplier lead time is 8 weeks, your minimum WOS before placing a purchase order is not 8 weeks — it's 8 weeks plus a buffer for demand variability and supply uncertainty. A reasonable starting rule:
Minimum WOS Target = Lead Time + (Lead Time × 25% safety buffer)
For an 8-week lead time, that's approximately 10 weeks.
Why this matters in practice:
If your WOS drops to 7 weeks and your lead time is 8 weeks, you are already in a stockout scenario. No PO you place today will arrive before you run out of inventory. The WOS at which you place the order — your reorder point — needs to account for the entire replenishment cycle plus buffer stock.
This is why WOS targets are dynamic, not static. As lead times fluctuate (supplier delays, port congestion, seasonal constraints), your reorder triggers should adjust accordingly. A platform that gives you real-time WOS visibility tied to current lead time data makes this tractable at scale.
Practical example:
For items with high demand variability or critical promotional significance, increase the buffer. For stable, non-seasonal basics with reliable supplier delivery, you can operate with a tighter margin.
At What Level Should You Track Weeks of Supply?
WOS should be tracked at every level of your product hierarchy; each level tells you something different.
SKU level is where planning happens. An inventory planner should know the WOS for every core item and be monitoring deviations from target. The two action triggers are clear:
- WOS dropping below target → place or accelerate a PO (see: how open-to-buy planning works)
- WOS running above target → delay, reduce, or cancel an existing PO
Class, Department, and Division level helps you identify structural inventory problems. If a category's average WOS is running 20+ weeks against a 10-week target, you have a systematic over-buying problem, not just a single item issue.
Company level is the executive view. Tracking company-level WOS over time shows whether you are systematically over-inventoried, under-inventoried, or well-calibrated. It's also the first metric a CFO should look at when evaluating working capital efficiency.
The challenge: retailers with thousands of SKUs can't monitor every item manually. Technology that automates WOS tracking and surfaces exceptions, items deviating most from their targets, is what makes SKU-level planning tractable.
How to Set a Weeks of Supply Target
There is no universal WOS target. The right number for your item depends on four variables:
1. Demand Variability
How predictable is demand for this item? For basics and core replenishment items, demand is stable and forecasts are reliable, WOS targets can be tighter. For fashion items, trend-driven categories, or anything weather-sensitive, demand is harder to predict. If you're working with limited history on new items, see our guide on using selling history to build demand without starting from scratch. Higher demand variability → higher WOS target, to absorb forecast error.
2. Supply Variability
How reliable is your supplier? High lead time variability (frequent late shipments or short deliveries) means you need more buffer stock to absorb supply uncertainty. Higher supply variability → higher WOS target.
3. Cost of Carry
What does it cost you to hold each unit? Storage costs, depreciation, opportunity cost of capital — these all increase with higher inventory levels. Higher cost of carry → lower WOS target (holding too much is expensive).
4. Cost of Stockout
What happens when you run out? For standalone basics, it's a missed sale. For items bundled in promotional offers, a stockout on one SKU can kill a multi-item promotion. For key traffic drivers, it damages customer trust and brand loyalty. If you want to quantify what stockouts are actually costing you, see our guide to capturing missed sales with demand metrics. Higher cost of stockout → higher WOS target.
The directional logic:
The mathematically optimal target balances all four, effectively minimizing the sum of stockout cost and carrying cost. In practice, most retailers set targets heuristically based on product type and category norms, then refine them over time. The key is to have a target at all, and to monitor deviation from it systematically.
Weeks of Supply vs. Inventory Turn
Turn and WOS measure the same underlying reality from different directions. If you have existing turn targets, you can translate them directly to WOS. (For a full reference on retail math formulas including turn, sell-through, and margin metrics, see our retail math cheat sheet.)
Formula:
WOS = 52 ÷ Annual Inventory Turns
Or equivalently:
Annual Turns = 52 ÷ WOS
If your organization targets 4 inventory turns per year, your implied WOS target is 13 weeks. If you're running at 8 turns, your implied WOS is 6.5 weeks.
This is useful as a sanity check: do your item-level WOS targets, in aggregate, produce the turn performance your organization needs? If every item in a category has a 20-week WOS target but your category plan calls for 4 turns (13-week WOS), you have a structural mismatch. For a deeper look at turn and margin efficiency together, see our guide on how retailers should use GMROI.
WOS Benchmarks by Retail Category
The table below shows typical annual inventory turn rates by category and the implied WOS targets those turns produce. These are industry-level benchmarks; your specific targets will vary based on your supply chain, business model, and customer expectations.
Current benchmarks reflect continued efficiency pressure from inventory management technology and supply chain optimization, though category-level ranges have remained broadly consistent.
The key insight: WOS targets should be category-specific, not one-size-fits-all. A 13-week WOS target is perfectly reasonable for an apparel retailer and dangerously high for a grocer.
Managing WOS at Scale
Setting targets is the easy part. The operational challenge is monitoring WOS across thousands of SKUs in real time and responding fast enough to matter.
For most retailers, this means:
- Automated WOS calculation — updated daily as sales and receipts flow in, not weekly in a spreadsheet
- Exception-based alerting — surface only the items deviating from target, not the full SKU list
- Connected replenishment — WOS signals that tie directly to replenishment management and PO creation
- Forward visibility — FWOS that uses your demand forecast, not just trailing averages
Toolio's Item Planning module automates this entire workflow — calculating FWOS at the SKU level, generating exception reports, and enabling planners to adjust receipts from the same interface. If you've reached the point where managing this manually is too cumbersome, you might also find our free Excel item planning and replenishment template useful as a starting point before graduating to a dedicated platform.
