What Is Weeks of Supply? Formula, Uses, and Limitations

Weeks of Supply The estimated number of weeks current inventory will last based on expected demand. Weeks of Supply expresses inventory as a time-based buffer: given current on‑hand stock and an expected weekly demand rate, how many weeks will that stock cover?

Use this metric to translate units or dollars of inventory into a planning horizon. Planners, buyers, and warehouse managers use Weeks of Supply to set reorder points, compare buffer levels between SKUs, and communicate inventory in time units that align with lead times and promotional calendars.

How It’s Calculated

Compute Weeks of Supply with a straightforward ratio. First decide the demand measure (units per week, cases per week, or dollars per week). Then divide the current inventory by that weekly demand.

• Formula: Weeks of Supply = Current On‑Hand Inventory ÷ Average Weekly Demand.
• Example: If you have 3,000 units on hand and expect 500 units/week, Weeks of Supply = 3,000 ÷ 500 = 6 weeks.
• Alternate basis: Use sell‑through data (shipped to customer) when channel demand differs from warehouse picks.

What The Metric Covers

Weeks of Supply converts inventory to a time horizon. It captures the relationship between stock quantity and expected consumption for a given planning period. It does not, by itself, include incoming receipts, safety stock targets, or the variability of demand and lead time—the metric is a snapshot based on the inputs you choose.

Why It Matters For Fulfillment

Time‑based inventory measures are easier for teams to act on than abstract counts. Purchasing can compare lead times to Weeks of Supply to decide whether to expedite. Warehouse managers can stage stock for picking based on weeks of coverage (short‑coverage SKUs closer to pick faces). Sales and operations can see how promotions or order surges will deplete stock in weeks rather than units.

How It Varies And What To Watch For

• Demand window: Using a short historical window (one week) picks up noise; using long windows smooths seasonality but can hide recent trends.
• Unit vs. dollar basis: High‑value, low‑unit SKUs may mislead if you mix units and dollars—keep the demand basis consistent.
• Seasonality: Weeks of Supply before a seasonal peak will understate the risk of stockouts unless demand is adjusted upward.
• Lead time alignment: Compare Weeks of Supply to supplier lead times expressed in weeks for reorder logic.

Who Uses It And When

Buyers use Weeks of Supply to set order frequency; planners use it to size safety stock; operations use it for slotting and replenishment cadence. It’s most useful when aligned with procurement cadence (weekly receiving vs. monthly shipments) and when teams agree on the demand baseline.

Practical Example

A 3PL holds 12,000 cases of a SKU. Historical outbound is 2,000 cases per week. Weeks of Supply = 12,000 ÷ 2,000 = 6 weeks. The supplier lead time is 8 weeks. Even with six weeks on hand, the buyer must place an order now to avoid stockout because replenishment lead time exceeds coverage. Warehouse operations might label the SKU as “replenish now” and prioritize staging for outbound while procurement initiates supplier scheduling.

Tips For Reliable Use

• Normalize demand: Use the same demand definition across SKUs (e.g., average weekly shipped units over the last 12 weeks) to keep comparisons meaningful.
• Adjust for promotions: Model expected uplift weeks ahead of promotional windows rather than relying on historical averages.
• Combine with variability metrics: Use service level, lead time variance, and safety stock formulas together with Weeks of Supply to quantify stockout risk.
• Review cadence: Recalculate weekly or after major receipts/shipments—this metric changes every time stock or demand forecasts change.

In short, the Weeks of Supply metric translates inventory into the number of weeks current stock will cover at a chosen weekly demand rate. It’s simple, actionable, and most valuable when used consistently alongside lead time and variability measures to drive purchasing, replenishment, and staging decisions.