π¦ Days Inventory Outstanding Calculator
How long your inventory sits before it sells.
Days inventory outstanding
Estimates for planning only, not financial advice.
Days inventory outstanding (DIO) tells you how many days, on average, inventory sits before it is sold. The formula is average inventory divided by cost of goods sold, times 365. A DIO of 73 means stock turns into sales roughly every 73 days. Lower is usually better, because every day of DIO is a day of cash locked on the shelf instead of funding growth.
How to Use This Calculator
Enter average inventory for the period, ideally the average of beginning and ending inventory, and the annual cost of goods sold from the income statement. The calculator returns DIO in days plus inventory turns per year, which is the same idea expressed as a frequency.
Find average inventory: add beginning and ending inventory for the year and divide by two. Using a single quarter-end balance can distort the result for seasonal businesses.
Enter annual COGS, the cost of what was actually sold, not what was purchased. COGS lives on the income statement.
Read DIO in days and the turns figure. Compare against your own prior years and direct competitors, not against unrelated industries.
The DIO Formula
DIO is one third of the cash conversion cycle, alongside days sales outstanding and days payable outstanding. The three together describe how long cash is tied up between paying suppliers and collecting from customers. A retailer that cuts DIO from 73 to 60 days frees 13 days of COGS as cash, which for a $2.1 million COGS business is about $75,000 back in the bank.
Worked Example
A wholesaler carries average inventory of $420,000 with annual COGS of $2,100,000. DIO = (420,000 / 2,100,000) x 365 = 73.0 days, or about 5.0 inventory turns per year. If management trims average inventory to $340,000 without hurting sales, DIO falls to 59.1 days and roughly $80,000 of cash is released. That is the real prize behind the ratio: not the number itself, but the working capital it frees up.
DIO by Industry: What Normal Looks Like
Industry context decides whether a DIO is healthy or alarming. Fresh-food grocers turn stock in days; a DIO of 10 would be a crisis for them. Auto dealers typically sit near 60 to 70 days because cars are expensive and slow-moving. Industrial distributors often run 90 to 120, and luxury goods or heavy equipment can exceed 180 without anything being wrong. The ratio only means something against the right peer group, so pull two or three direct competitors and compare before judging.
Business model shifts move DIO more than operations do. A retailer moving from wholesale to direct-to-consumer usually sees DIO rise, since it now holds the stock its distributors used to carry. A manufacturer outsourcing production often sees DIO fall as raw-material and work-in-progress balances leave the balance sheet. When DIO jumps, ask first whether the model changed, and only then whether operations slipped. The number reports the symptom; the story behind it is where the decision lives.
Cutting DIO Without Causing Stockouts
The fear that stops most DIO reductions is the stockout: cut too deep and shelves go bare. The fix is segmenting inventory by velocity. Fast movers get tighter reorder points and smaller, more frequent orders; slow movers get cut hard or dropped. ABC analysis formalizes this: the 20 percent of SKUs driving 80 percent of sales deserve safety stock, while the long tail of C-items is where cash hides. Most businesses find they can cut DIO 15 to 20 percent purely from the C-items without touching availability of what actually sells. Start with a 90-day review of every SKU's turns; the worst performers are usually obvious within an hour of looking at the data.
What Counts as a Good DIO
Good is relative to the business model. Grocery chains run DIO under 15 days because milk spoils. Car dealers sit near 60 to 70. Heavy equipment makers can exceed 150. Judge the number three ways: against your own trend, against direct competitors, and against the cash it represents.
| DIO trend | Likely meaning |
|---|---|
| Falling while sales grow | Tighter operations, cash freed up |
| Rising while sales are flat | Overstocking or slowing demand, watch for write-downs |
| Rising with sales | Normal growth stocking, confirm turns hold steady |
| Sudden spike | Possible obsolete stock or a big bulk buy, dig into the detail |
Common Mistakes
Using sales instead of COGS in the denominator is the most frequent error; sales include margin, so it understates DIO. Using a single period-end inventory figure instead of an average is second, and it punishes seasonal businesses unfairly. If you want the full working-capital picture, run the other two legs with our days sales outstanding calculator and days payable outstanding calculator, then check the damage to returns with our ROI calculator when excess stock forces markdowns.
Estimates for planning only, not financial advice.
Frequently Asked Questions
What is days inventory outstanding?
Days inventory outstanding (DIO) measures how many days inventory sits before being sold, calculated as average inventory divided by COGS times 365. It is one of the three components of the cash conversion cycle and a direct read on working capital efficiency.
How do you calculate DIO?
Divide average inventory by annual cost of goods sold, then multiply by 365. With $420,000 average inventory and $2,100,000 COGS, DIO is 73 days. Use the average of beginning and ending inventory for the most accurate result.
What is a good DIO?
It depends on the industry. Grocers run under 15 days, general retailers 40 to 80, and heavy manufacturers over 100. Compare against your own history and direct competitors rather than a universal target.
Is a lower DIO always better?
Usually, but not always. Extremely low DIO can mean stockouts and lost sales if shelves go bare. The sweet spot balances cash tied up in stock against having enough on hand to meet demand reliably.
What is the difference between DIO and inventory turnover?
They are reciprocals of the same idea. Inventory turnover is COGS divided by average inventory, expressed as turns per year. DIO is 365 divided by that turnover, expressed in days. This calculator shows both.
Should I use COGS or sales in the DIO formula?
COGS. Inventory is carried at cost, so the denominator must be cost-based too. Using sales inflates the denominator with margin and understates DIO, making inventory look more efficient than it is.
How does DIO affect cash flow?
Every day of DIO is a day of cash locked in stock. Cutting DIO from 73 to 60 days on $2.1 million of COGS frees about $75,000 of cash. That is why lenders and buyers watch DIO closely during due diligence.
Why is my DIO rising?
Common causes: over-ordering, slowing sales, product mix shifting toward slower items, or obsolete stock that is not selling at all. A rising DIO with flat sales is an early warning of future write-downs.
How does DIO fit into the cash conversion cycle?
The cash conversion cycle equals DIO plus days sales outstanding minus days payable outstanding. DIO measures the inventory leg: the time between receiving goods and selling them. Shortening any leg shortens the cycle.
Can DIO be negative?
Effectively no for the ratio itself, since inventory cannot be negative. Some businesses like Dell famously ran near-zero or negative cash conversion cycles by collecting from customers before paying suppliers, but DIO itself stays at or above zero.