What days inventory outstanding measures
DIO is the average number of days a dollar of cost sits in inventory before it is sold. It carries exactly the same information as inventory turnover, expressed in the unit an operating team can act on. Nobody can be told to lift turnover from 6.0 to 6.5; everybody understands "take five days out of finished goods".
Days are also the unit that adds up. Inventory days plus receivable days minus payable days gives the cash conversion cycle, the number of days you must fund operations out of your own cash or a revolver. Ratios cannot be combined that way. Of the three legs, DIO is usually the largest and the most controllable: you cannot make a customer pay faster than their accounts-payable run, and stretching suppliers has a price, but you decide how much stock to hold.
Every day has a price, and it is easy to compute. One day of inventory equals one day of cost of goods sold, so a business with $7.8m of annual cost of sales carries $21,370 of cash in each day on the shelf. Take ten days out and you release $213,700 permanently, and stop paying carrying charges on it for as long as the business exists.
The formula, and the three places it goes wrong
Divide average inventory by cost of goods sold, then multiply by the days in the period. The middle step is what makes it intuitive: inventory ÷ COGS is the fraction of a year's cost sitting in the warehouse, and multiplying by 365 turns that fraction into days.
The denominator is cost of sales, not revenue. Inventory is carried at cost, so the flow that drains it must be at cost as well. Dividing by revenue understates DIO by exactly (1 − gross margin): at a 35% gross margin, a genuine 60-day book reads as 39 days. Screeners that publish "days sales of inventory" using revenue are computing something different, and the error grows with margin. If you only have purchases and inventory movements, build the cost figure with the cost of goods sold calculator.
The day count must match the period. Annual cost of sales against 30 days, or monthly cost of sales against 365, produces answers off by an order of magnitude. If you report DIO monthly, use monthly cost of sales and 30 days — or annualise the month by multiplying it by 12 and keeping 365. Both work; mixing them does not. The 360-day banker's year appears in loan covenants and makes DIO about 1.4% shorter.
The inventory figure must be complete and consistent. Include raw materials, work in progress and finished goods, because all three consume cash. Exclude consignment and vendor-managed stock you do not own, and exclude supplies you expense as incurred. Where inventory swings seasonally, average all 13 month-end balances instead of two dates, because a two-point average of a seasonal book can miss the period badly in either direction depending on where the two dates fall in the cycle. And under LIFO in an inflationary period, ending inventory is carried at old, low costs, so DIO reads shorter than an identical FIFO competitor's. Add back the disclosed LIFO reserve before comparing.
Worked example: a distributor with a 45-day target
A wholesale distributor reports cost of goods sold of $7,800,000 for the year and carries average inventory of $1,300,000. Its planning target is 45 days, and it prices carrying cost at 22% a year.
- Find one day of cost of sales. $7,800,000 ÷ 365 = $21,369.86 per day.
- Divide the stock by that daily figure. $1,300,000 ÷ $21,369.86 = 60.8 days of inventory outstanding.
- Check it the other way. $1,300,000 ÷ $7,800,000 = 0.16667 of a year; × 365 = 60.8 days. The routes always agree.
- Convert to turns. 365 ÷ 60.83 = 6.0 times a year.
- Measure the gap. 60.83 − 45 = 15.8 days above target.
- Price the gap. 15.83 × $21,369.86 = $338,356 of cash sitting in stock the plan says you do not need.
- Price the holding. The whole book costs $1,300,000 × 22% = $286,000 a year to own; the excess alone costs $338,356 × 22% = $74,438 a year.
Two things follow. First, the $338,356 is a one-off cash release that stays released — it does not have to be earned again next year. Second, the $74,438 is a recurring saving, and it is the number to put in front of a board, because it is a permanent margin improvement rather than a balance-sheet reshuffle. Together they usually dwarf whatever the purchasing team can negotiate on price for the same effort.
How to read DIO, and how to build a target instead of borrowing one
Read the level first, then the trend, then the gap to a target you built yourself.
The level tells you which risk dominates. Under about 30 days, financing cost is trivial and your exposure is service: stockouts, expedited freight and lost orders that appear in no ratio. Past about 120 days, the dominant risk is obsolescence and write-down to net realisable value, and no amount of interest-rate arithmetic captures it. Between those, carrying cost is the honest way to price the decision.
The trend is the more reliable signal, and it needs no external data. DIO rising while revenue grows means stock is outrunning sales, the classic precursor of a markdown cycle. Three consecutive quarters of increase deserve a SKU-level aging report rather than an explanation.
The target should be built from your own supply chain, not copied from a peer table. Three components make it up. Cycle stock averages half your order interval, so ordering monthly costs about 15 days on its own. Safety stock covers demand and lead-time variability at whatever service level you promise — size it properly with the safety stock calculator rather than guessing, because it scales with the square root of lead time, not linearly. In-transit stock counts whenever you take title at the supplier's dock. A distributor ordering monthly, holding two weeks of safety stock and owning goods in transit for a week has a structural floor of 15 + 14 + 7 = 36 days before a single slow-moving SKU is counted. If your DIO is 61 and your floor is 36, the 25-day gap is the part that is genuinely manageable — and it will be concentrated in a minority of SKUs, not spread evenly.
Sector context still matters, but get it from real filings rather than from a benchmark table. The ordering is intuitive — highly perishable goods turn in days, packaged consumer goods and fashion in weeks, industrial distribution in a couple of months, and capital equipment, furniture and jewellery can sit for the better part of a year — yet the useful figure is a specific competitor's, not a range. Take two numbers from a peer's filing, the cost-of-sales line and the inventory note, run them through this calculator, and you have their DIO on your own definition. Compare within your sector or not at all.
What cutting inventory days is worth per $1m of cost of sales
| Days removed | Cash released, one-off | Annual saving at 15% | at 22% | at 30% |
|---|---|---|---|---|
| 5 days | $13,699 | $2,055 | $3,014 | $4,110 |
| 10 days | $27,397 | $4,110 | $6,027 | $8,219 |
| 15 days | $41,096 | $6,164 | $9,041 | $12,329 |
| 20 days | $54,795 | $8,219 | $12,055 | $16,438 |
| 30 days | $82,192 | $12,329 | $18,082 | $24,658 |
The cash release happens once and stays released; the annual saving recurs. A distributor with $7.8m of cost of sales multiplies every cash figure by 7.8 — so ten days is $213,700 of cash and about $47,000 a year at a 22% carrying rate.
What makes up a carrying cost rate
| Component | Typical annual range | What drives it |
|---|---|---|
| Cost of capital | 6–14% | Your revolver rate or weighted average cost of capital |
| Space and occupancy | 2–6% | Rent, racking, utilities, refrigeration |
| Handling and labour | 1–4% | Put-away, moves, cycle counting |
| Insurance and property tax | 1–3% | Jurisdiction and commodity class |
| Shrink, damage, spoilage | 1–4% | Security, handling quality, shelf life |
| Obsolescence and markdown | 2–12% | Product life cycle and forecast error |
| Typical total | 18–30% | The six lines rarely sit at their extremes together |
The component ranges are not additive at their limits: take every low figure and you get 13%, take every high figure and you get 43%. No real operation sits at one end on all six lines at once, which is why the usable total clusters at 18% to 30%. Build your own rate from the general ledger where you can — obsolescence is the component that varies most and the one most often left out, which is why quoted rates run too low.
Mistakes that make DIO wrong
- Dividing by revenue instead of cost of goods sold. This understates DIO by (1 − gross margin) — a 60-day book reads as 39 days at a 35% margin.
- Mismatching the period and the day count. Monthly cost of sales against 365 days inflates DIO twelvefold. Annualise or use 30; never mix.
- Using a two-point average in a seasonal business. Average all 13 month-end balances, and say which method you used.
- Comparing a LIFO filer with a FIFO or IFRS peer. Add back the LIFO reserve first, or you are measuring an accounting election.
- Counting consignment or vendor-managed stock. It sits in your building but not on your balance sheet, and including it double-counts the supplier's investment.
- Setting the target from a benchmark table. Your floor is cycle stock plus safety stock plus in-transit. A target below that structural floor guarantees stockouts.
- Treating a falling DIO as unambiguously good. Check fill rate, back orders and expedited freight, because the cost of a stockout never appears in this ratio.
- Reading the average and ignoring the distribution. A 60-day average often means most SKUs turn quickly and a tail has not moved in two years — and the tail is where write-downs come from.
Where DIO fits among the other working-capital measures
DIO is one of four numbers that describe the same operating cycle, and each answers a different question.
Inventory turnover is DIO inverted. It is dimensionless, which makes it the form used in covenant packages, credit scoring and DuPont decompositions — use the inventory turnover calculator when you need the ratio form or the gross margin return on inventory investment.
Days sales outstanding is the receivables leg, and days payable outstanding is the funding your suppliers provide. Run the DSO calculator and the DPO calculator, then combine all three in the cash conversion cycle. A word of warning on the payables leg: stretching suppliers looks free and is not — giving up a 2/10 net 30 discount to hold the cash 20 extra days costs (2 ÷ 98) × (365 ÷ 20), about 37% a year, far more than any revolver.
Order quantity and safety stock are the levers, not the measures. The EOQ calculator trades ordering cost against holding cost to set how much you buy at a time; safety stock sets the buffer. Supplier lead time is the third lever and usually the most powerful, because it drives cycle stock and safety stock at once.
Working capital is where the money shows up. Inventory plus receivables minus payables is the cash your operations consume, and the working capital calculator puts a balance on it. A DIO improvement is the only one of the three legs you can execute without asking a customer or a supplier for anything.
Key terms
- Days inventory outstanding
- Average inventory divided by cost of sales per day. Also called days inventory on hand, days sales of inventory, or inventory days.
- Cycle stock
- The stock you hold purely because you order in batches. It averages half the order interval, so a monthly order cycle carries about 15 days.
- Safety stock
- The buffer that absorbs demand and lead-time variability at a chosen service level. It grows with the square root of lead time, not linearly.
- Carrying cost rate
- Annual cost of owning inventory as a percent of its value: capital, space, handling, insurance, tax, shrink and obsolescence. Commonly 18% to 30%.
- Net realisable value
- Estimated selling price less costs to complete and sell. Both US GAAP (ASC 330, Inventory) and IFRS (IAS 2, Inventories) write inventory down to it when cost is higher, which is what makes long-held stock expensive.
- LIFO reserve
- The disclosed gap between a LIFO company's reported inventory and what it would report on FIFO. Add it back before comparing DIO across filers.