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.

The inventory KPIs to track alongside days on hand

Days on hand tells you how long stock lasts, not whether it earns its keep or whether you are running out. The inventory KPIs that matter most are turnover, days of inventory on hand, sell-through, stockout rate, GMROI, carrying cost and inventory accuracy. Watch them as a small set, per SKU, rather than one company-wide number once a quarter.

KPI	Formula	What it tells you
Inventory turnover	COGS ÷ average inventory	How many times a year you sell through stock
Days of inventory on hand	365 ÷ turnover	How many days one cycle of stock lasts
Sell-through rate	Units sold ÷ units received × 100	What share of a delivery actually sold
Stockout rate	Out-of-stock SKUs ÷ total SKUs × 100	How often you fail to fill demand
GMROI	Gross margin ÷ average inventory cost	Gross profit earned per dollar of inventory
Carrying cost %	Annual holding cost ÷ average inventory value × 100	What it costs to hold your stock
Inventory accuracy	Counted units matching records ÷ total counted × 100	Whether your data can be trusted

Which inventory KPI matters most?

If you can only track one, track turnover (or its mirror, days on hand), because it captures both sides of the balance: too slow and cash sits in dead stock, too fast and you stock out. It is a trailing average, though, so pair it with stockout rate to catch the fast movers it hides, and with GMROI so a high-turning product sold at thin margin does not look like a winner.

How do you calculate GMROI?

GMROI (gross margin return on investment) is gross margin dollars divided by average inventory at cost. It tells you how many dollars of gross profit each dollar of stock earned over the period. Take a category with $480,000 in sales and $300,000 in cost of goods sold, so $180,000 of gross margin, and inventory at cost of $70,000 at the start of the year and $50,000 at the end, so $60,000 on average. GMROI is $180,000 ÷ $60,000 = 3.0. Keep both halves at cost and over the same window; putting retail value in the denominator is the most common way people inflate it.

What is a good GMROI?

Anything above 1.0 earns more gross margin than the stock costs to hold, which is the floor. In US general merchandise retail the usual rule of thumb is 3.2 or better. Grocery and other fast, thin-margin categories can be healthy at 2 to 3, while jewelry and furniture often run below 2 and still make money on margin per unit. Compare a category against itself over time before you compare it with an industry figure.

There are three levers: raise margin, sell the same stock faster, or hold less stock for the same sales. The third is usually the quickest win and it is a buying-accuracy problem, because an over-bought item with a long lead time parks cash for months and drags GMROI down even when it sells at full price. Right-sizing each buy takes a real read on every item's demand, which is what per-SKU demand forecasting software gives you.

Why track stockout and sell-through rates?

Days on hand and turnover look backward at stock you already sold. Stockout rate and sell-through look at demand you may be missing. A rising stockout rate often sits next to a healthy average DIO, because a few SKUs are starved while others pile up. Sell-through, the share of a delivery that sells in a set window, tells you whether you bought the right quantity in the first place.

How often should you review inventory KPIs?

Review the operational KPIs (stockout rate, reorder signals) weekly and the financial ones (turnover, DIO, GMROI, carrying cost) monthly, always with a per-SKU view underneath. All of them depend on accurate counts, which is why cycle counting sits underneath any KPI set worth trusting.

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.