Inventory Days = Average Inventory ÷ (COGS ÷ 365)
Inventory Days measures how long inventory stays in storage before being sold, helping you assess inventory efficiency and optimize working capital management.
Days Inventory Outstanding (DIO), also known as Days Sales of Inventory (DSI), measures the average number of days a company holds inventory before selling it. This key efficiency metric indicates how quickly a business converts its inventory into sales and ultimately into cash flow.
A lower DIO generally indicates efficient inventory management and faster turnover, while a higher DIO may suggest overstocking, slow-moving products, or declining demand. However, optimal DIO varies significantly by industry - grocery stores may target 10-15 days while heavy equipment manufacturers might operate efficiently at 90+ days.
The Days Inventory Outstanding formula relates your average inventory value to your cost of goods sold (COGS) and converts it to a time period.
DIO Formula
DIO = (Average Inventory / COGS) x 365 days. This shows how many days worth of COGS is currently held in inventory. Some analysts use 360 days for simplicity.
Average Inventory
Calculated as (Beginning Inventory + Ending Inventory) / 2. Using average inventory smooths out seasonal fluctuations and provides a more accurate picture.
Cost of Goods Sold (COGS)
The direct costs of producing goods sold during the period. Found on the income statement. Using COGS (not sales) ensures consistency since inventory is valued at cost.
Optimal DIO varies widely by industry due to differences in product shelf life, production cycles, and business models. Compare your DIO to industry peers rather than absolute standards.
Grocery / Perishables
Target: 10-20 days. Short shelf life demands rapid turnover. Fresh products may turn over in just 2-5 days.
Retail / E-commerce
Target: 30-60 days. Fast fashion may be lower (20-30), while general merchandise averages 45-60 days.
Manufacturing
Target: 60-90 days. Longer production cycles and raw material buffers require more inventory on hand.
Heavy Equipment
Target: 90-180 days. Long sales cycles, custom orders, and high-value items justify higher inventory periods.
Demand Forecasting
Use historical data, market trends, and predictive analytics to better match inventory levels to expected demand. Accurate forecasting reduces both stockouts and excess inventory.
Just-In-Time (JIT) Inventory
Reduce inventory holdings by coordinating deliveries closely with production or sales needs. Requires reliable suppliers and efficient logistics but can dramatically reduce DIO.
SKU Rationalization
Analyze sales data to identify slow-moving items. Discontinue or discount stagnant inventory and focus on products with healthy turnover rates.
What is the difference between DIO and inventory turnover?
They are inversely related. Inventory Turnover = COGS / Average Inventory (times per year). DIO = 365 / Inventory Turnover (days). A turnover of 6x equals approximately 61 days DIO.
Is a lower DIO always better?
Not necessarily. Extremely low DIO may indicate insufficient inventory, risking stockouts and lost sales. The goal is finding the optimal balance between carrying costs and service levels.
How does DIO relate to the cash conversion cycle?
DIO is one component of the Cash Conversion Cycle (CCC). CCC = DIO + Days Sales Outstanding - Days Payables Outstanding. It measures how long cash is tied up in operations.
Should I use beginning, ending, or average inventory?
Average inventory is preferred as it accounts for fluctuations during the period. For seasonal businesses, consider using a 12-month average or quarterly averages for more accuracy.