Days Inventory Outstanding (DIO): Turning Stock Into Cash Faster

Days inventory outstanding (DIO) is the average number of days a company holds inventory before selling it. It converts the dollars sitting in stock into a number of days of sales, which makes it easy to compare periods, products and competitors. A lower DIO means stock turns into cash faster; a rising DIO often signals overbuying, weak forecasts or slow-moving items. DIO is one of the three components of the cash conversion cycle and, for product companies, usually the largest lever in cash flow management.

The DIO formula

DIO = (Average inventory / Cost of goods sold) × Days in period

Inventory is carried at cost, so the denominator is cost of goods sold (COGS), not revenue. Use the average of opening and closing inventory where you can, especially for seasonal businesses, and use a day count that matches the period: 365 for a year, 90 for a quarter.

DIO is the inverse of inventory turnover:

Inventory turnover = COGS / Average inventory
DIO = Days in period / Inventory turnover

Worked example

A hypothetical company has average inventory of $360,000 and annual COGS of $2,160,000.

• Inventory turnover = $2,160,000 / $360,000 = 6.0 turns per year
• DIO = 365 / 6.0 = 60.8 days

On average, the company's stock sits for about two months before it is sold. Each day of DIO is worth the daily cost of goods sold: $2,160,000 / 365 = $5,918. Taking 10 days out of DIO would release roughly $59,178 of cash.

What is inside your inventory days

A single DIO number blends several different reasons for holding stock. Breaking inventory into its parts shows what can and cannot be changed.

Suppose the $360,000 average inventory splits as follows.

This view changes the conversation. About 17 of the 61 days are excess and slow-moving stock that should not be there at all. Cutting that bucket in half would free $50,000, or about 8.4 days of DIO ($50,000 / $5,918), without touching service levels. Reducing cycle stock, in contrast, requires changing order policies, and reducing safety stock requires better forecasts or shorter lead times. The distinction between those components is developed in demand planning and inventory optimization.

What drives DIO up

• Forecast bias. If forecasts are consistently too high, you buy too much.
• Large minimum order quantities and long lead times. They force larger or earlier buys.
• Blanket safety stock rules. A flat "four weeks of cover" ignores that some items are stable and others volatile.
• Product proliferation. More SKUs spread the same demand over more items, raising total stock.
• Slow decision-making on slow movers. Items that stop selling stay on the books.
• Pre-buying for price breaks or tariffs. It can pay off, but should be evaluated against carrying cost.
• Poor visibility. Stock held in several locations may be ordered again unnecessarily.
• Growth and seasonality. Building ahead of a peak raises DIO temporarily.

The cost of holding inventory

Cash tied up in stock has a cost beyond the interest on borrowing: storage, insurance, handling, shrinkage, obsolescence and the opportunity cost of money. Many companies use an annual carrying cost rate as a planning assumption. For illustration, assume 25 percent a year. On the $50,000 of excess stock above, the carrying cost would be $12,500 a year ($50,000 × 0.25). Use your own figure, built from your actual costs, rather than a generic one.

How to reduce DIO

1. Clean up the excess first

List every item by value and by months of cover based on forecast demand. Items with far more than a year of cover, or with no recent sales, are candidates for markdown, bundling, return to supplier, liquidation or donation. Quantify the cash recovered, and the loss relative to book value, so decisions are explicit.

2. Segment by importance

An ABC classification ranks items by their share of sales or cost. The few "A" items deserve close attention, tighter forecasts and lower safety stock targets; the long tail of "C" items may be managed with simpler rules or discontinued. Applying the same policy to everything wastes effort and cash.

3. Set safety stock using variability

Replace blanket days-of-cover rules with safety stock based on demand variability, lead time variability and the service level you want. Stable items need less. The method is explained in the supply planning articles of this site, starting with demand planning and inventory optimization.

4. Improve forecast accuracy and reduce bias

Track forecast error and bias by item family. Forecasts that are consistently too high add to DIO; consistently too low cause stockouts. Correcting bias often releases more cash than improving random error.

5. Revisit order quantities and lead times

Ask whether minimum order quantities are contractual or habitual. Compare the cost of ordering more often against the cost of holding more stock. Shortening lead times, for example through a closer supplier or faster shipping on selected items, lowers both pipeline and safety stock.

6. Control new product and promotional buys

Launches and promotions create a large share of excess stock. Set buy quantities from scenario forecasts, stage orders where possible and agree in advance what happens to leftovers.

7. Align purchasing with cash

Link the purchase plan to the cash forecast. If buys are scheduled with their payment dates, you can see the cash cost of each order. See how to build a cash flow forecast you will actually use.

DIO versus service level

Lower DIO is only good if you can still fill orders. Stockouts cost sales, customer goodwill and sometimes shelf placement. Set DIO targets by item class, with service level goals attached. A reduction in DIO that comes from better forecasts and faster replenishment is healthy. One that comes from running lean on stock for fast sellers is not.

DIO for different types of business

Use these as qualitative guides and compare yourself to your own history and close peers. For manufacturers, calculate DIO separately for raw materials, work in process and finished goods to see where the days build up.

Tracking DIO

Calculate DIO monthly using average inventory and trailing COGS. Chart it with the cash conversion cycle and note the cause of every major move. Show DIO by product category and by location, not only in total. Add the metric to your cash dashboard alongside days sales outstanding and days payable outstanding.

Where to go next

DIO is one of three levers. For a program that combines inventory, receivables and payables, see working capital optimization: 12 strategies that free up cash. If you sell online and buy from overseas suppliers, the inventory cycle is usually your biggest cash driver, a case covered in working capital management for ecommerce and DTC brands.

Common mistakes

• Using revenue instead of COGS in the formula.
• Using ending inventory only for seasonal businesses.
• Cutting inventory across the board without regard to service level.
• Ignoring in-transit inventory that is owned but not on the shelf.
• Treating obsolete stock as an asset at full book value.
• Focusing on DIO without fixing the forecast that drives purchasing.

FAQs

What is days inventory outstanding?

DIO is the average number of days a company holds inventory before it is sold. It equals average inventory divided by cost of goods sold, multiplied by the days in the period.

What is a good DIO?

It depends on the industry, lead times and service levels. Compare with your own trend and similar companies. A lower DIO is better when service levels hold.

How is DIO related to inventory turnover?

They are two views of the same thing. DIO equals the days in the period divided by inventory turnover. A turnover of 6 per year corresponds to a DIO of about 61 days.

How can I lower DIO quickly?

Start with excess and slow-moving stock, then fix forecast bias, order quantities and safety stock. Quick wins come from clearing items with no near-term demand.

Does lowering DIO always improve cash?

Yes for the cash tied up in stock, but only if sales and service are not harmed. Lost sales from stockouts can outweigh the savings.