Days Inventory Outstanding: Measuring How Fast Inventory Converts to Sales
Understand DIO calculation, benchmarking, and reduction strategies to free working capital and improve cash flow.
Key Takeaways
- •Days Inventory Outstanding (DIO) measures the average days inventory is held before sale
- •DIO is the most intuitive expression of inventory velocity—lower is better
- •DIO benchmarks vary by industry: grocery (20-30 days), retail (40-60), distribution (60-90)
- •Reducing DIO directly frees working capital and reduces carrying costs
- •DIO reduction must balance cash flow improvements against service level requirements
Days Inventory Outstanding (DIO) tells you, on average, how many days inventory sits in your warehouse before being sold. While inventory turnover gives you a ratio, DIO translates that into intuitive, actionable language: "How many days of inventory do I have on hand?"
As covered in our guide to Inventory Turnover Ratio, turnover and DIO are two views of the same metric. This guide focuses specifically on DIO: how to calculate it, benchmark it, and improve it.
365 Days
Per year
Lower DIO
Faster turns
Inventory Days
On hand
Working Capital
Cash freed
How to Calculate Days Inventory Outstanding
DIO is calculated by dividing 365 by your inventory turnover ratio, or by using the direct formula:
Days Inventory Outstanding Formula
Method 1: From Inventory Turnover
DIO = 365 / Inventory Turnover
If turnover is 6, DIO = 365 / 6 = 60.8 days
Method 2: Direct Calculation
DIO = (Average Inventory / COGS) x 365
Example Calculation
Annual COGS: $8,000,000
Average Inventory: $1,300,000
DIO: ($1,300,000 / $8,000,000) x 365 = 59.3 days
Interpretation
DIO of 59 days means your average inventory is held for 59 days before sale. At any given time, you have roughly 59 days of inventory on hand. This is approximately 2 months of inventory—a useful mental model for planning.
Industry Benchmarks for DIO
DIO benchmarks vary significantly by industry. What's excellent for one business may be problematic for another.
| Industry | Good DIO | Average DIO | Poor DIO |
|---|---|---|---|
| Grocery | < 20 days | 20-30 days | > 30 days |
| Consumer Goods | < 35 days | 35-50 days | > 50 days |
| Retail | < 45 days | 45-65 days | > 65 days |
| Distribution | < 60 days | 60-90 days | > 90 days |
| Manufacturing | < 60 days | 60-90 days | > 90 days |
| Industrial Parts | < 90 days | 90-150 days | > 150 days |
Within-Company Variation
Your overall DIO masks significant variation by product category. Fast-moving SKUs may have DIO under 30 days; slow movers may exceed 365 days. Track DIO by category and SKU to identify specific improvement opportunities.
Strategies for Reducing DIO
Reducing DIO means selling inventory faster. Here are proven strategies:
- Improve demand forecasting: Better forecasts allow lower safety stock. Use historical data, account for seasonality, and measure forecast accuracy.
- Optimize reorder points: Calculate data-driven reorder points based on lead time, demand variability, and service level targets.
- SKU rationalization: Discontinue slow-moving items. A smaller, faster catalog improves overall DIO.
- Reduce supplier lead times: Negotiate faster delivery. Shorter lead times mean less safety stock required.
- Increase inventory velocity: Faster receiving, picking, and shipping means less inventory needed for buffer.
- Implement promotional pricing: Strategic markdowns can move slow inventory faster than holding it indefinitely.
Impact on Cash Flow
Reducing DIO directly improves cash flow. Here's the math:
Working Capital Impact of DIO Reduction
Current state:
- Annual COGS: $10,000,000
- DIO: 90 days
- Average Inventory: ($10M / 365) x 90 = $2,466,000
After improvement:
- Target DIO: 70 days
- New Average Inventory: ($10M / 365) x 70 = $1,919,000
- Inventory reduction: $547,000
- Carrying cost savings (at 20%): $109,400/year
Don't Sacrifice Service
Reducing DIO should not come at the cost of stockouts. Lost sales from stockouts often exceed the carrying cost savings from lower inventory. Monitor fill rate alongside DIO.
Tracking DIO Effectively
DIO is most powerful when tracked at multiple levels of granularity:
Overall DIO
Company-wide DIO for executive reporting and trend analysis. Review monthly.
Category DIO
DIO by product category to identify problem areas. Review monthly.
SKU DIO
Individual SKU analysis for A-items. Flag items exceeding targets.
Aged Inventory
Inventory by age bucket (0-30, 31-60, 61-90, 90+) to identify obsolete stock.
Inventory & Working Capital
Complete guide to inventory finance
Inventory Turnover Ratio
The key efficiency metric
Inventory Carrying Costs
The true cost of holding stock
Obsolete Inventory
Prevention and write-down strategies
Ready to Reduce Your Days Inventory Outstanding?
Eagle Rock CFO helps companies analyze DIO, identify improvement opportunities, and implement strategies that balance working capital optimization with service levels.