Weeks of Supply Calculator

Calculate how many weeks your current inventory will cover based on average weekly usage. Ideal for medium-term supply planning.

About the Weeks of Supply Calculator

Weeks of supply (WOS) measures how many weeks your current inventory will last at the present rate of weekly consumption. While days of supply is preferred for fast-moving items, many supply chain planners find weeks of supply more practical for medium- and long-lead-time products, seasonal planning, and executive-level inventory reporting.

The formula is simply average inventory divided by average weekly usage. A WOS of 4 means you have roughly one month of stock coverage. Most businesses target WOS between 2 and 8 weeks, depending on lead times, demand variability, and service level requirements.

Enter your average inventory and average weekly usage to compute your weeks of supply, along with the equivalent days of supply for detailed planning.

Supply-chain managers, warehouse operators, and shipping coordinators rely on precise weeks of supply data to maintain efficiency and control costs across complex distribution networks. Revisit this calculator whenever conditions change to keep your logistics plans aligned with real-world performance.

Why Use This Weeks of Supply Calculator?

Weeks of supply puts inventory levels into a human-friendly time frame that aligns with weekly planning cycles, S&OP meetings, and supplier order schedules. It is the preferred coverage metric in industries with weekly or bi-weekly replenishment cadences, such as retail, CPG, and wholesale distribution. Real-time recalculation lets you model different scenarios quickly, ensuring your logistics decisions are backed by accurate, up-to-date numbers.

How to Use This Calculator

  1. Enter the average inventory on hand (in units or dollars).
  2. Enter the average weekly usage or demand.
  3. Review the calculated weeks of supply.
  4. Compare WOS against your lead time in weeks to check coverage adequacy.
  5. Identify SKUs with WOS significantly above target for potential reduction.
  6. Track WOS trends weekly in your S&OP dashboard.

Formula

Weeks of Supply = Average Inventory / Average Weekly Usage Days of Supply = WOS × 7 Where: Average Inventory = on-hand stock (units or $) Average Weekly Usage = units sold or consumed per week

Example Calculation

Result: WOS = 5.0 weeks

Weeks of Supply = 5,000 units / 1,000 units per week = 5.0 weeks. At the current consumption rate, you have five full weeks of inventory coverage before stock runs out.

Tips & Best Practices

WOS in Executive Reporting

Weeks of supply is a staple of executive dashboards because it conveys inventory health in an immediately understandable time unit. CFOs look at WOS to assess working capital efficiency. VPs of Supply Chain use it to identify categories needing attention.

Forward-Looking WOS

Instead of dividing by historical weekly usage, advanced planners divide by forecasted weekly demand. This gives a forward-looking WOS that accounts for anticipated promotions, seasonal shifts, or demand trends, providing a more accurate picture of future coverage.

WOS Targets by Category

Set differentiated WOS targets by ABC class or product lifecycle stage. A-items may target 2-3 weeks, B-items 4-5 weeks, and C-items 6-8 weeks. New product launches may start with higher WOS until demand stabilizes.

Reducing WOS Without Stockouts

The key is to reduce the numerator (average inventory) without proportionally affecting service. Tactics include smaller, more frequent orders, better forecasting to reduce safety stock, vendor-managed inventory, and cross-docking programs that move goods through the DC faster.

Frequently Asked Questions

What is weeks of supply?

Weeks of supply is the number of weeks your current inventory will last at the current weekly consumption rate. It is the weekly counterpart of days of supply and a standard metric in S&OP processes.

What is a good WOS target?

It varies by industry and item. Fast-moving consumer goods aim for 2-4 weeks, while specialty items with long lead times may target 6-10 weeks. Set targets relative to lead time and demand variability.

How does WOS relate to days of supply?

WOS = DOS / 7. If you have 35 days of supply, that is 5 weeks. Choose whichever metric suits your planning cadence and audience.

Should I include safety stock in the inventory figure?

Yes, include total on-hand inventory. Safety stock is part of your physical stock and contributes to coverage. Some planners also compute WOS excluding safety stock to see available coverage beyond the buffer.

How do I calculate average weekly usage?

Sum units sold or consumed over a representative period (typically 4-12 weeks) and divide by the number of weeks. Filter out anomalies like promotion spikes for a more stable average.

Can WOS be misleading?

Yes, if demand is highly seasonal. In the off-season, WOS appears high because weekly usage is low, even though you may be building stock for a peak season. Always interpret WOS in the demand context.

How do I reduce WOS without hurting service?

Improve demand forecasting, reduce supplier lead times, order more frequently in smaller quantities, and tighten safety stock calculations. Each strategy reduces average inventory relative to consumption.

Is WOS used in S&OP meetings?

WOS is one of the most common metrics in Sales & Operations Planning. It provides a simple, actionable view of inventory health that bridges the gap between supply chain detail and executive-level strategy.

Related Pages