What Are Days of Inventory and How To Calculate Them

Days of Inventory measures how many days current inventory can meet forecasted demand; formally: "The estimated number of days current inventory can support forecasted demand." This metric expresses inventory as a time window, turning stock levels into an operational planning number warehouses and fulfillment centers can use to align purchasing, labor, and shipping plans.

Keep the calculation simple and repeatable so it becomes a live KPI in your warehouse management system. The most common calculation uses average inventory and average daily usage over a consistent period — monthly or rolling 90 days — to smooth spikes from seasonality or promotions.

How To Calculate Days Of Inventory

Two equivalent formulas are used in practice depending on the data available:

• Formula (inventory days): Days of Inventory = (Average Inventory / Forecasted Daily Demand).
• Formula (turnover-based): Days of Inventory = 365 / Inventory Turnover (when using annual turnover).

Step-by-step example using the first formula: if your SKU pool holds an average of 12,000 units and your forecasted daily demand is 400 units, Days of Inventory = 12,000 / 400 = 30 days. Use SKU-level calculations to aggregate into a weighted facility-level DOI.

Data Choices And Practical Considerations

How you calculate "average inventory" and "forecasted demand" materially changes the result.

• Average Inventory: Use beginning and ending inventory for the period or a daily/weekly average to smooth variance.
• Forecasted Daily Demand: Use rolling forecasts tied to sales channels (e‑commerce vs wholesale) rather than last-period sales when demand is volatile.
• Period Consistency: Match the inventory averaging window with the demand horizon to avoid misleading DOI (e.g., 90-day average inventory with 90-day demand).

Why Days Of Inventory Matters

Expressing inventory in days makes stock levels actionable. Operations, procurement, and finance interpret a DOI number differently but can take the same actions: adjust reorder points, prioritize replenishment, and manage cash tied up in stock. For fulfillment centers, DOI links directly to service levels and the probability of stockouts.

Common Pitfalls And How To Avoid Them

• Label:Mis-specified demand: Using historic sales during an outlier event (big promotion) will distort DOI; use adjusted forecasts.
• Label:Average inventory mismatch: Short averaging windows show noise; long windows hide trends—pick a window that matches your business cycle.
• Label:SKU aggregation errors: Summing SKU-level DOIs without weighting by value or volume can mislead—weight by forecasted demand or inventory value when reporting facility-level DOI.

Operational Example

A mid-size e-commerce fulfillment center calculates SKU-level DOI weekly. They use a 60-day rolling average inventory and a 30-day rolling forecasted daily demand. For slow-moving seasonal SKUs the team enforces a minimum DOI (safety stock in days) to cover supplier lead time plus a buffer; for fast movers they set a maximum DOI to limit working capital and reduce pick congestion.

In short, the Days of Inventory metric — "The estimated number of days current inventory can support forecasted demand." — translates stock quantities into planning time. Use consistent data windows, calculate at SKU level, and combine DOI with turnover and service-level targets to make procurement and fulfillment decisions that balance service and cost.