Weeks of Supply: Definition and How To Calculate It

Weeks of Supply is an inventory metric that estimates how many weeks current inventory will last at an expected sales or usage rate. It converts stock levels and forecasted demand into a simple time-based horizon that retail managers use to plan replenishment, assess assortment health, and flag slow-moving SKUs.

At its simplest, Weeks of Supply answers a practical question: given what you have on the shelf or in the backroom and how fast it sells, how many weeks can you continue selling before you run out? Because it normalizes inventory to time, the metric is useful across product lines and store formats — from a fast-moving grocery SKU to a seasonal apparel style with short selling windows.

How To Calculate Weeks Of Supply

The basic formula is straightforward:

Weeks of Supply = On‑Hand Inventory ÷ Average Weekly Usage

Where:

• On‑Hand Inventory: Physical units available for sale or committed to fulfill orders (exclude damaged or quarantined units).
• Average Weekly Usage: The historical or forecasted weekly sales or demand for the SKU, preferably smoothed across an appropriate time window (e.g., 4, 13, or 52 weeks depending on seasonality).

Example: A store has 120 units of a SKU and average weekly sales of 30 units. Weeks of Supply = 120 ÷ 30 = 4 weeks.

Choosing The Right Demand Window

How you measure average weekly usage changes the result and its usefulness:

• Short window (4 weeks): Captures very recent trends and promotions, useful for high‑velocity items.
• Intermediate window (13 weeks): Balances short-term volatility and seasonal patterns; common in retail planning cycles.
• Long window (52 weeks): Smooths seasonality and is better for staples or slow movers.

Why Weeks Of Supply Matters

Weeks of Supply gives non‑technical stakeholders an intuitive view of inventory health: it’s easier to act on “3 weeks” than on a raw unit count. Use cases include:

• Replenishment planning: Decide when to reorder and how large replenishment should be based on target weeks of cover.
• Assortment review: Identify overstocked SKUs with high weeks of supply or understocked SKUs with very low weeks of supply.
• Promotions and markdowns: Decide if a SKU needs price action to reduce excessive weeks of supply within a selling window.

How Weeks Of Supply Varies Across Retail Contexts

Expect different benchmarks depending on product category, lead time, and selling rhythm. For example:

• Grocery staples: Typically low weeks of supply (1–3 weeks) due to high turns and short shelf life.
• Apparel: Seasonal styles may target lower weeks of supply during the season but require higher pre‑season cover to launch ranges.
• Electronics: May accept slightly higher weeks of supply (4–12 weeks) because of supplier lead times and slower turnover.

Limitations And Common Pitfalls

Weeks of Supply simplifies decision‑making but has limitations managers must watch for:

• Demand volatility: Sudden demand spikes or stockouts will make historical averages misleading.
• Ignoring lead time: Weeks of supply does not include supplier lead time — combine it with reorder point and safety stock calculations for ordering.
• Data quality: Inaccurate on‑hand counts, returns, or unrecorded shrinkage distort the metric.

Practical Tips For Retailers

To use Weeks of Supply effectively in store and central operations:

• Segment SKUs: Apply tailored target weeks of supply by category, velocity band, and seasonality.
• Blend demand signals: Use a weighted average of recent and longer-term demand when sales are trending.
• Combine metrics: Monitor inventory turns and days of supply alongside weeks of supply for a fuller view.
• Automate calculations: Let your WMS or inventory system recalc weeks of supply daily and flag exceptions for review.

In short, the Weeks of Supply metric converts inventory quantities and expected demand into an actionable time horizon. When calculated with clean data and the right demand window, it helps buyers and store managers balance availability against capital and space constraints.