What Is Days Of Supply? Formula, Interpretation, And Example

Days of Supply is an estimate of how many days current inventory will last at the expected sales rate. It translates inventory quantities into a time horizon — telling a warehouse manager, merchant, or fulfillment operator how many days’ worth of demand can be covered without replenishment.

Used at SKU, category, or facility level, the metric supports reorder planning, safety-stock sizing, and performance monitoring. Calculated correctly, it complements inventory turns and lead-time metrics to form a decision set for purchasing, production, and shipping. Misinterpreted, it can hide seasonality, SKU-level variability, and slow-moving stock.

How Days Of Supply Is Calculated

The basic formula is:

Days of Supply = (Inventory On Hand) ÷ (Average Daily Usage)

Where:

• Inventory On Hand: The physical or system-recorded quantity available to sell or fulfill, often measured at the beginning of the day or a reporting period.
• Average Daily Usage: The expected units sold or consumed per day, usually calculated over a recent historical window (e.g., last 30, 90, or 365 days) or from demand forecasts.

Choose the averaging window that matches your business rhythm: fast-moving consumer goods often use 7–30 days; seasonal products may use 90 days or rolling annual forecasts to smooth spikes.

Common Calculation Variations

• Ending Inventory vs. Average Inventory: Some teams use period-ending inventory, others use average inventory across the period to reduce day-to-day noise.
• Gross vs. Net Usage: Gross usage counts all units sold; net usage subtracts returns, cancellations, or internal consumption.
• Rolling vs. Fixed Window: Rolling averages update continuously; fixed windows compare the same period year-over-year for seasonality adjustments.

Why Days Of Supply Matters For E‑commerce

For e‑commerce operations, Days of Supply converts SKU counts into an operationally meaningful timeframe. It helps decide when to reorder, which SKUs need promotion to reduce excess stock, and how to position inventory across fulfillment centers to meet promised delivery windows.

It also feeds automated reorder policies in WMS or ERP systems: when Days of Supply falls below a threshold, a replenishment action is triggered. For 3PLs and multi-channel merchants, Days of Supply per facility guides transfers between warehouses to reduce fulfillment lead time and shipping costs.

Practical Example

Assume a fashion retailer has 1,200 units of a bestselling T‑shirt at Warehouse A and average daily sales of 80 units. Days of Supply = 1,200 ÷ 80 = 15 days. If lead time from the supplier is 21 days, Warehouse A is understocked relative to that lead time and needs a reorder or an expedited transfer.

Limitations And Pitfalls

• Label:Seasonality Can Skew Averages. Short averaging windows may understate future demand during peak seasons; long windows may mask recent trends.
• Label:Aggregated Views Hide SKU Risk. Facility-level Days of Supply can look healthy while critical SKUs are at zero days.
• Label:Lead Time And Variability Aren’t Included. Days of Supply doesn’t account for supplier reliability or shipment delays; combine with lead-time variance when planning.

Tips For Accurate Use

• Label:Calculate At The SKU–Location Level. Use SKU-by-warehouse Days of Supply to identify stockouts and overages precisely.
• Label:Use Forecasted Demand When Appropriate. For promotions or new launches, substitute forecasted daily usage instead of historical averages.
• Label:Blend Metrics. Monitor Days of Supply alongside turns, stockout rates, and lead-time performance for balanced decisions.

In short, the Days of Supply metric converts inventory counts into a time-based indicator useful for reorder decisions, allocation, and performance monitoring; accurate inputs and SKU-level analysis make it actionable rather than misleading.