What Is Days of Supply? Formula, Example, and How to Calculate It

Days of Supply An estimate of how many days current inventory will support expected demand. It expresses inventory levels in time units rather than units or dollars, answering: with the stock on hand today, how many days can operations continue at forecasted demand before replenishment is required.

Viewed from operations and finance perspectives, Days of Supply is both a planning and a monitoring metric. Planners use it to set reorder points and safety-stock policies; warehouse supervisors use it to prioritize replenishment and detect overstocks or stockouts early. The metric links physical inventory (pallets, cases, or units) with demand forecasts and cadence — daily pick rates in a fulfillment center or weekly consumption for a production line.

What The Metric Covers

Days of Supply translates inventory on hand into a time horizon and typically covers:

• On-Hand Inventory: Physical stock available for use or sale (excluding damaged or quarantined items).
• Demand Rate: Expected average usage or sales over a chosen period (daily, weekly).
• Forecast Horizon: The time unit used to express days (commonly days or business days).

Why It Matters

Days of Supply gives teams a simple, operationally meaningful view of inventory health. Rather than working with abstract counts or dollars, managers see how long stock will last at the current consumption rate. That visibility supports:

• Reorder Timing: Avoid stockouts by aligning orders to when inventory will dip below required days of supply.
• Working Capital Management: Reduce excess inventory that ties up cash by identifying slow-moving SKUs with high days of supply.
• Service-Level Planning: Choose target days of supply to meet customer service goals under lead-time variability.

How It Is Calculated

The most common formula expressed in days uses average daily demand:

Days of Supply = On-Hand Inventory ÷ Average Daily Demand

Practical calculation steps:

• Step 1 — Define On-Hand: Use available, salable inventory for the SKU or product family.
• Step 2 — Choose Demand Period: Use historical shipment/sales data to compute average daily demand (e.g., last 30 or 90 days).
• Step 3 — Compute: Divide on-hand units by average daily demand to yield days.

Example: A fulfillment center has 2,400 units of SKU A on hand. Historical average daily picks for SKU A are 80 units/day. Days of Supply = 2,400 ÷ 80 = 30 days.

How Calculation Choices Affect The Result

Days of Supply is sensitive to the demand window and how you count inventory. Common variations:

• Rolling Average vs Period Average: A 7-day rolling average responds faster to demand spikes than a 90-day average, which smooths seasonality.
• Net vs Gross Inventory: Subtract allocated, reserved, or damaged stock if those units aren’t available for fulfillment.
• Business Days vs Calendar Days: Use business days for manufacturing lines that don’t run weekends; use calendar days for retail operations open daily.

Who Should Track It

Days of Supply is relevant across roles:

• Warehouse Managers: For scheduling replenishment, labor planning, and dock activity.
• Merchants/Buyers: To set reorder points and purchase cadence with suppliers.
• Planners/Forecasting Teams: To tune safety stock and lead-time buffers.
• Finance: For working-capital and inventory turn analyses.

Practical Example

Scenario: A 3PL holds three SKUs for an e-commerce merchant. SKU X sells steadily at 40 units/day, SKU Y is seasonal with an average of 8 units/day (but 30 in peak months), SKU Z is intermittent at 2 units/day. The 3PL calculates days of supply weekly using a 30-day moving average and flags SKUs with less than 14 days for expedited reorder and SKUs with more than 90 days for inventory review. With this policy, SKU X at 1,200 units on hand → 30 days (no action). SKU Y at 240 units → 30 days but flagged for seasonality review. SKU Z at 300 units → 150 days (consider promotions or return to merchant to reduce holding cost).

Tips For Reliable Use

• Align Demand Window With Business Cycle: Use longer averages for seasonal products; short windows for fast-moving SKUs.
• Exclude Unusable Inventory: Don’t count quarantined or reserved units as on-hand for calculation purposes.
• Segment SKUs: Set different target days of supply for fast movers, slow movers, and critical spares.
• Combine With Lead-Time Data: Use days of supply plus supplier lead time to set reorder points: Reorder Point = Daily Demand × (Lead Time + Safety Days).

In short, the Days of Supply metric converts inventory into a time view that aligns operations, purchasing, and finance. When calculated consistently and interpreted with demand patterns and lead times, it’s a practical tool for avoiding stockouts and reducing excess inventory.