DIO Calculator - Days Inventory Outstanding
Enter your beginning inventory, ending inventory, cost of goods sold (COGS), and the number of days in the period to calculate Days Inventory Outstanding (DIO). You also get average inventory, inventory turnover ratio, and a worked breakdown showing exactly how the result was reached. The calculator works for annual, quarterly, or any custom period.
What is Days Inventory Outstanding (DIO)?
Days Inventory Outstanding (DIO) measures the average number of days a company holds its inventory before converting it to revenue through a sale. A lower DIO means the company turns over stock quickly, keeps less cash tied up in warehouses, and generally faces lower carrying costs such as storage, insurance, and spoilage. A higher DIO means inventory sits longer, which can signal weak demand, excess purchasing, or deliberately large safety stock in capital-intensive industries. DIO is part of the trio of activity ratios - alongside Days Sales Outstanding (DSO) and Days Payable Outstanding (DPO) - that together make up the Cash Conversion Cycle (CCC = DIO + DSO - DPO). A lower CCC means a company converts its investments in inventory and receivables back into cash more quickly.
DIO formula and how to calculate it
The most common formula is: DIO = (Average Inventory / COGS) x Days in Period. Average inventory is the mean of the opening and closing balances for the period: (Beginning Inventory + Ending Inventory) / 2. COGS is taken from the income statement for the same period, and the number of days is typically 365 for annual data, 91 for a calendar quarter, or any custom length. An equivalent approach uses the inventory turnover ratio: DIO = Days in Period / Inventory Turnover, where Inventory Turnover = COGS / Average Inventory. Both methods produce the same result. Some analysts use ending inventory alone when a beginning balance is unavailable, which is a reasonable approximation for stable businesses but can distort results when stock levels change sharply.
How to interpret your DIO and benchmark it
There is no universal "good" DIO because the optimal value depends entirely on the business model. A grocery retailer with a DIO above 25 days may have a spoilage problem, while an aerospace manufacturer with a DIO below 90 days might be understocking expensive components. The most useful comparison is the same company over several periods to spot trends, or against direct competitors reporting under the same accounting standards. A rising DIO over time often signals accumulating slow-moving stock or a demand shortfall and deserves close attention. A falling DIO can reflect better supply-chain discipline or, less favourably, a risk of stockouts. Pair DIO with gross margin: a company with a high DIO but strong margins may be holding premium, slow-moving items strategically.
Reducing DIO - practical levers
Companies that want to lower their DIO typically focus on four areas. First, demand forecasting: better prediction of what will sell, when, reduces over-ordering and the build-up of dead stock. Second, supplier lead times: negotiating shorter or more frequent deliveries allows smaller, just-in-time orders rather than large safety buffers. Third, SKU rationalisation: regularly culling slow-moving lines reduces the long tail of inventory that inflates the average holding period. Fourth, pricing and promotions: marking down aged stock releases cash even at thinner margins and is usually better than writing it off. Each additional day of DIO reduction frees up working capital equal to one day of COGS, which this calculator shows directly in the daily COGS output.
Typical DIO ranges by industry
| Industry | Typical DIO | Key driver |
|---|---|---|
| Grocery / food retail | 10 - 25 days | Perishability forces rapid turnover |
| Electronics retail | 30 - 45 days | High value, risk of obsolescence |
| Apparel / fashion | 60 - 120 days | Seasonal buying cycles |
| Automotive | 40 - 70 days | Dealer lot management |
| General manufacturing | 60 - 100 days | Production lead times |
| Heavy machinery | 90 - 180 days | Long build cycles, custom orders |
| Pharmaceutical | 120 - 180 days | Regulatory and shelf-life requirements |
| Industrial distribution | 50 - 100 days | Breadth of SKU catalogue |
These are approximate benchmarks. Always compare within the same industry and accounting period. Data varies by source and year.
Frequently asked questions
What is a good DIO?
It depends on the industry. Grocery and food retailers typically aim for 10-25 days because perishables spoil quickly. Electronics and general retail often run 30-60 days. Manufacturers and distributors routinely see 60-180 days due to production lead times and large component orders. The most meaningful benchmark is a direct competitor in the same sector, or the company's own historical trend.
Is a lower DIO always better?
Usually, but not always. A lower DIO frees cash and reduces storage costs, which is almost always positive. However, an extremely low DIO can indicate the company is running lean on safety stock, risking stockouts that disrupt sales and damage customer relationships. The goal is the lowest DIO consistent with maintaining reliable product availability.
What is the difference between DIO and inventory turnover?
Inventory turnover measures how many times a company cycles through its full inventory in a period (COGS / average inventory). DIO converts that ratio into days (period length / turnover). They carry identical information - a turnover of 5x over 365 days equals a DIO of 73 days. DIO is often more intuitive because it speaks directly in days rather than a ratio.
Should I use beginning, ending, or average inventory?
Average inventory is the standard choice because it smooths out any large swing in stock levels between the start and end of the period. If a company builds inventory heading into the holiday season, the ending balance alone would overstate the true average. Use ending inventory only when the beginning balance is unavailable, and note the limitation when presenting the result.
How does DIO connect to the Cash Conversion Cycle?
The Cash Conversion Cycle (CCC) measures the total number of days between paying suppliers for inventory and collecting cash from customers. CCC = DIO + DSO - DPO, where DSO is Days Sales Outstanding (how long to collect receivables) and DPO is Days Payable Outstanding (how long before you pay suppliers). DIO is typically the largest single component, so improving inventory management has an outsized effect on the overall CCC and therefore on free cash flow.
Can DIO be used for service companies?
DIO is designed for businesses that carry physical inventory and report a cost of goods sold figure. Service firms, software companies, and financial institutions do not maintain a traditional inventory balance, so DIO is not applicable. For companies with a mix of products and services, calculate DIO using only the product-related COGS and inventory lines if they are reported separately.