How to Calculate Weeks of Supply: Formula, Adjustments, and What the Number Actually Tells You

Weeks of supply is one of the most cited inventory metrics in apparel operations, and one of the most frequently miscalculated. The formula is simple: total inventory on hand divided by average weekly sales. The number the formula produces is only as reliable as the data going into it, and for a brand running wholesale, DTC, and a 3PL simultaneously, the data quality problem is almost always the real issue.

From the cohort data across our install base, the pattern that shows up consistently is that brands carrying too many weeks of supply on slow movers are not doing so because they made bad buy decisions. They are doing so because the average weekly sales figure used in the calculation was pulled from a period that did not represent actual current demand, or because the on-hand inventory number included stock at the 3PL that had not been reconciled against recent returns. The calculation looked fine. The inputs were wrong.

Getting weeks of supply right is an inventory data problem before it is a planning problem.

What Is Weeks of Supply and Why Does It Matter?

Weeks of supply is the number of weeks it would take to deplete current inventory at the current rate of sales. The formula:

Weeks of Supply = Total Inventory On Hand / Average Weekly Sales

A result of 10 means current stock would last 10 weeks at the current sales pace. Whether 10 weeks is good or problematic depends on lead time and the demand profile of the product. A style with a 12-week reorder lead time and 10 weeks of supply needs a purchase order placed immediately. The same number for a style with a 4-week lead time in a slow period is fine.

The metric matters because it connects inventory position to cash position directly. Every unit sitting in a warehouse represents working capital. For a $15M brand running wholesale, DTC, and a 3PL, carrying 6 to 8 weeks of excess supply on slow-moving styles can tie up $150,000 to $300,000 in working capital that could fund the next production run. Those are not edge-case numbers. They are what shows up in planning reviews at brands that have grown past the point where informal inventory judgment is enough.

On the other side, running too lean on a fast-moving style heading into peak creates stockouts, wholesale chargebacks, and a 2 to 3% oversell rate during high-demand periods, outcomes that are both operational failures and revenue losses.

How to Calculate Weeks of Supply: The Formula

Weeks of Supply = Total Inventory On Hand / Average Weekly Sales

Worked example:

• On-hand units: 500
• Average weekly sales (trailing 8 weeks): 50 units/week
• Weeks of supply: 500 / 50 = 10 weeks

Two inputs. The challenge is in what each one requires.

Total inventory on hand must reflect actual current stock across every location: warehouse, 3PL, in-transit committed to no specific order, and any consignment locations. For a brand running multiple channels, on-hand stock in the system should reconcile with the 3PL’s WMS and the Shopify inventory pool at the time of calculation. If those three sources disagree, the weeks of supply number is wrong before the division happens.

Average weekly sales must be calculated against a time window that represents the upcoming demand profile, not just the most convenient trailing period. Using a trailing 12-week average for a product entering its peak selling season will understate expected velocity and produce a weeks of supply number that looks higher than the actual risk. The product sells faster than the formula assumes, stock runs out earlier than planned, and the next purchase order is already late.

How Do You Adjust Weeks of Supply for Seasonality and Promotions?

Static trailing averages are the most common source of weeks of supply errors in apparel. Apparel demand is not flat. It has seasonal peaks, promotional spikes, and clearance periods, and the sales average used in the formula needs to reflect whichever regime is coming next, not the one that just passed.

Seasonality adjustment: if spring/summer collections historically sell at 2x the baseline weekly rate during the March-June window, the average weekly sales figure for a product entering that window should reflect that multiplier, not the flat trailing average from October through February. The practical approach is to build a seasonal index by SKU or category based on prior-year sell-through data and apply it to the trailing average before running the formula.

Promotional adjustment: a marketing campaign or drop launch that historically drives 3x normal weekly velocity in the two weeks following launch should be reflected in the sales average for any stock held in anticipation of that drop. Inventory position and sales velocity need to be evaluated against the specific demand event ahead, not the general trend behind.

The inverse adjustment matters equally. After a peak period ends, carrying the peak-adjusted sales average forward will make weeks of supply look artificially low, which drives unnecessary reorders. Recalibrate back to baseline after each demand event and watch for the plateau.

What Are the Most Common Weeks of Supply Calculation Errors?

Stale inventory records. A cycle count that happened 10 days ago is not real-time inventory. Returns that have not been received back into the system, transfers in transit between the warehouse and the 3PL, and units that have been picked but not yet shipped all distort the on-hand number. For a brand processing significant volume through a 3PL, the reconciliation gap between the OMS and the WMS can represent several days of sales velocity.

Wrong sales window. The trailing 4-week average and the trailing 12-week average can produce weeks of supply numbers that differ by 30 to 50% for a product with any demand variation. Neither is categorically right. The right window is the one that best represents the expected demand pattern for the period ahead. Most apparel planning teams use a blend: a trailing 8-week average adjusted for any known seasonal or promotional factor.

Ignoring channel allocation. A brand running both wholesale and DTC against a shared inventory pool needs to account for committed wholesale orders when calculating available-to-sell inventory. If 200 of the 500 units on hand are allocated to confirmed wholesale orders, the effective available inventory for DTC purposes is 300, not 500. Running the formula against gross on-hand inventory without netting down committed allocations gives a false picture of how much coverage is actually available for each channel.

Missing the 3PL. Brands that manage inventory at a third-party logistics partner often run with a lag between what the 3PL shows and what the OMS shows. If the reconciliation between those two systems is weekly rather than continuous, the weeks of supply number is always slightly wrong. During peak periods, a one-week reconciliation gap can be significant enough to change a reorder decision.

How Do You Use Weeks of Supply to Make Reorder Decisions?

Setting a target weeks of supply range per SKU is the practical way to use the metric operationally. The target should reflect lead time plus a safety buffer for variability.

For a style with a 10-week lead time and moderate demand variability, a target range of 12 to 16 weeks of supply is defensible: 10 weeks to receive the order plus 2 to 6 weeks of buffer. When current weeks of supply drops below 12, a purchase order should be placed. When current weeks of supply exceeds 16, excess stock needs to be addressed, markdown, promotional push, or delayed production.

For a style with a 4-week lead time and stable demand, a target range of 6 to 8 weeks may be appropriate. For a style in clearance, the target is simply zero: no more reorders, move the remaining stock.

The trigger point for a reorder only works if inventory and sales data update continuously. If the calculation is run once a week from a Monday-morning export, the actual trigger point was passed on Wednesday, the purchase order goes out the following Monday, and the style runs short for 4 days before the order is placed. Over a season with multiple styles and multiple reorder cycles, those gaps compound into stockouts, lost wholesale fill rate, and chargebacks.

How Does Weeks of Supply Connect to Inventory Truth?

At a brand that has grown past about $10M to $20M in revenue, informal inventory judgment stops being reliable. The SKU count is too high, the channels are too numerous, and the velocity differences between styles are too wide for any planning team to hold in their heads. This is the point where inventory truth either holds or starts to break down.

Inventory truth breaking down is Breakpoint 3 in the 6 Breakpoints framework: teams lose confidence in stock numbers across channels and locations. The oversell rate climbs, reconciliation becomes a weekly meeting rather than a background process, and planners start adding manual buffers to compensate for data they do not trust. Those buffers represent excess stock. That excess stock is working capital sitting idle.

The weeks of supply formula is a useful operational tool when the inputs are reliable. When they are not, when inventory records drift from reality due to unreconciled returns, 3PL sync delays, or duplicate records from a Shopify-to-OMS integration, the calculation produces a false confidence number that drives bad decisions.

For a $15M brand running wholesale, DTC, and a 3PL, the reconciliation work to maintain clean inventory inputs to this formula takes 6 to 9 hours per week when done manually across spreadsheets and system exports. That time is not producing insight. It is just maintaining the condition required for one metric to be accurate.

What This Means for an Apparel Operations Team

Weeks of supply is a planning metric, not a reporting trophy. The number matters because reorder decisions, markdown decisions, and production commitments all follow from it. Getting it right requires connected inventory and sales data, not a better formula.

The practical standard for an apparel operations team running multiple channels:

Inventory on hand should reconcile with the 3PL and the OMS at least daily. Average weekly sales should be updated weekly and adjusted for any upcoming seasonal or promotional factors. Committed wholesale allocations should be netted from on-hand before the formula runs. And the weeks of supply calculation should run by SKU, not just by product family, because velocity differences between colorways and sizes are real and material to reorder decisions.

Teams that treat weeks of supply as a weekly check-in metric, calculated manually from stale exports, consistently find themselves either over-bought on slow movers or under-stocked on fast ones. The root cause is not the formula. It is the disconnected data underneath it.

Inventory management systems that connect sales velocity, on-hand stock, purchase orders, and channel allocations in one place do not eliminate the planning judgment required to use weeks of supply well. They do eliminate the reconciliation work that currently consumes the planning team’s time before the calculation can even begin.

If your team is spending meaningful time each week reconciling inventory data before running this metric, the Inventory Truth Scorecard can help identify where the confidence gaps are and what they are costing.