Days of Inventory on Hand (DIO): Formula, Benchmarks and How to Lower It

Days of inventory on hand (DIO) is the average number of days it takes to sell your current stock. The formula is average inventory divided by cost of goods sold, times 365: DIO = (average inventory ÷ COGS) × 365. A lower number means stock moves faster and less cash sits on the shelf; a higher number means slower-moving inventory and more tied-up cash. It is the same information as inventory turnover, expressed in days instead of times per year, and for most operators the days version is easier to act on.

If your turnover is 6 times a year, your DIO is about 61 days: on average, a unit sits for two months before it sells. Whether that is good or bad depends entirely on what you sell, which is why the benchmark matters as much as the math.

What is days of inventory on hand?

Days of inventory on hand, also called days sales of inventory (DSI) or days inventory outstanding (DIO), is a liquidity ratio that tells you how long your inventory lasts at your current rate of sales. It answers a simple operator question: if I stopped buying today, how many days until I run out? It converts an abstract turnover figure into a number of days you can compare against your supplier lead times and your cash cycle.

How do you calculate days of inventory on hand?

Two equivalent formulas get you there. Use whichever inputs you have clean:

DIO = (average inventory ÷ COGS) × 365

DIO = 365 ÷ inventory turnover ratio

Average inventory is usually (beginning inventory + ending inventory) ÷ 2 for the period. COGS is the cost of the goods you actually sold, not revenue. Using revenue instead of COGS is the single most common mistake and it understates DIO, because revenue includes your margin.

A worked example

A retailer holds $250,000 of average inventory and reports $1,500,000 in COGS for the year.

Input	Value
Average inventory	$250,000
Annual COGS	$1,500,000
Inventory turnover	6.0 times
Days of inventory on hand	~61 days

($250,000 ÷ $1,500,000) × 365 = 60.8 days. So this retailer holds about two months of stock. If their suppliers deliver in three weeks, that is comfortable. If suppliers deliver in a week, 61 days is probably more cash on the shelf than the business needs.

What is a good days of inventory on hand?

There is no universal target; the right DIO depends on your industry, margins and lead times. Grocery and fresh food run very low because product spoils. Apparel and general retail sit in the middle. Heavy equipment and slow-turning specialty goods run high by design. The table below shows rough ballparks, not rules.

Sector	Typical DIO	Why
Grocery / perishables	~15 to 30 days	Spoilage forces fast turns
General / apparel retail	~40 to 80 days	Seasonality and assortment depth
Electronics / DTC brands	~50 to 90 days	Obsolescence risk vs supply lead times
Industrial / heavy goods	~90 to 180 days	Long lead times, high unit value

The useful move is not chasing a benchmark but watching your own DIO trend and comparing it SKU by SKU. A blended company-wide DIO of 61 days can hide fast movers turning every two weeks and dead stock that has not moved in a year. The average lies; the distribution tells the truth.

Why does days of inventory on hand matter?

DIO is really a cash number wearing an operations costume. Every day a unit sits on the shelf is a day your cash is trapped in it instead of funding faster-moving stock, paying down debt or covering payroll. It also forms one leg of the cash conversion cycle, alongside how long it takes to collect from customers, which is why finance teams that shorten the time it takes to get paid and operators who shorten DIO are solving two halves of the same working-capital problem.

The cash conversion cycle is DIO plus days sales outstanding minus days payable outstanding. Cut DIO from 61 to 45 days on $1.5M of COGS and you free roughly $66,000 of cash, without selling a single extra unit. That is the real reason the ratio is worth tracking.

How do you reduce days of inventory on hand?

1. Buy to actual demand, not to feel safe

The biggest lever is ordering the quantity demand justifies on the lead time your supplier actually delivers. That is a forecasting and reorder point problem: tighter reorder points mean less average inventory, which lowers DIO directly.

2. Right-size the slow tail

Run an ABC analysis and look hardest at the C items and dead stock inflating your average. Clearing dead stock that will never sell at full price both frees cash now and drops your DIO immediately.

3. Order smaller and more often

Bulk buying looks cheap per unit but parks cash and raises DIO. Balancing that trade-off is exactly what the economic order quantity formula is for: it finds the order size that minimizes total cost, which usually means leaner, more frequent orders than instinct suggests.

4. Make it a per-SKU habit, not a quarterly report

DIO computed once a quarter for the whole company is a lagging indicator. Computed per SKU and watched weekly, it becomes an early warning system for the items quietly turning into dead stock. That continuous, per-SKU view is what demand forecasting software and inventory control software are built to give you.

Days of inventory on hand vs inventory turnover

They are the same measurement inverted. Turnover tells you how many times a year you sell through your stock; DIO tells you how many days one cycle takes. Turnover of 6 equals DIO of about 61 days. Analysts often prefer turnover for comparing companies; operators usually prefer DIO because "we hold 61 days of stock" is easier to weigh against "our supplier takes 21 days to deliver." For the full picture of the same ratio, see our guide to the inventory turnover ratio.

Computing DIO per SKU, watching it trend, and catching the items whose days on hand have quietly ballooned past their lead time is a continuous job, not a one-time spreadsheet. Our live stock scan reads your rows and returns per-SKU verdicts on cover and slow movers, so the stock quietly trapping the most cash is the stock you see first.