Days Inventory Outstanding (DIO)

August 31, 2024 Financial Statements

DIO estimates how many days of cost are held in average inventory and connects stock levels with the cash conversion cycle.

On this page

Days inventory outstanding (DIO) estimates how many days a company holds inventory before that cost is recognized in cost of goods sold. Also called days sales of inventory, days’ inventory on hand, or inventory days, DIO converts the relationship between average inventory and cost of goods sold into a time measure.

Key Takeaways

A common formula divides average inventory by cost of goods sold and multiplies by the days in the period.
DIO and inventory turnover are reciprocals when they use the same cost basis, period, and inventory population.
Lower DIO can release working capital, but it can also reflect understocking, write-downs, or supply risk.
A company-wide average can conceal obsolete goods, production bottlenecks, or product-level shortages.
DIO should be reviewed with margins, service levels, aging, commitments, and the full cash conversion cycle.

DIO Formula

\text{DIO} = \frac{\text{Average inventory at cost}}{\text{Cost of goods sold}}\times\text{Days in period}

Average inventory is commonly:

\text{Average inventory} = \frac{\text{Beginning inventory}+\text{Ending inventory}}{2}

An annual calculation may use 365 days, 360 days under a disclosed convention, or the actual number of fiscal-year days. A quarterly calculation should use quarterly COGS and the days in that quarter. Mixing annual COGS with a 90-day multiplier produces a period mismatch.

Average inventory and COGS should use a consistent accounting cost basis. Sales at retail value should not replace COGS unless the resulting metric is clearly labeled as a different sales-to-inventory measure.

Worked Example

Assume a company reports:

annual COGS: $12 million
beginning inventory: $1.8 million
ending inventory: $2.2 million

Average inventory equals $2.0 million. Using 365 days:

\text{DIO}=\frac{\$2.0\text{m}}{\$12.0\text{m}}\times365=60.8\text{ days}

The result indicates that average inventory equals about 61 days of annual COGS. It does not mean every item remains in stock for 61 days. Some products may sell immediately while obsolete items remain much longer.

Relationship to Inventory Turnover

When definitions align:

\text{DIO}\approx\frac{\text{Days in period}}{\text{Inventory turnover}}

The example’s inventory turnover is 6.0 times:

\frac{365}{6.0}=60.8\text{ days}

If one calculation uses ending inventory and the other uses average inventory, or one uses sales while the other uses COGS, the measures will not reconcile.

DIO in the Operating and Cash Cycles

DIO is the inventory component of the operating cycle:

\text{Operating cycle}=\text{DIO}+\text{DSO}

It also enters the cash conversion cycle:

\text{CCC}=\text{DIO}+\text{DSO}-\text{DPO}

Reducing DIO generally shortens the reported cycles, all else equal. The change is beneficial only if it does not create stockouts, production interruptions, excessive freight, supplier dependence, or lost sales.

Inventory Stages and DIO

Manufacturers often review raw-material, work-in-process, and finished-goods days separately. These diagnostic measures require matching flows:

raw materials should be related to material usage or another relevant consumption flow;
work in process should be related to production cost flowing through that stage; and
finished goods should be related to finished-goods cost of sales.

Dividing every inventory category by total COGS can be a rough approximation, but the resulting category days are not necessarily sequential durations and should not be added mechanically. Operational production and warehouse data provide a stronger stage analysis.

What Can Change DIO?

Possible cause	Evidence to check	Interpretation question
Demand weakened	Sales trend, orders, markdowns, aging	Is inventory becoming slow-moving?
Safety stock increased	Supplier lead times, service targets, disruption risk	Is the added resilience economically justified?
New capacity ramped	WIP, production schedule, utilization	Is inventory temporary startup investment?
Purchasing moved ahead	Commitments, order quantities, price expectations	Is the buildup deliberate or excessive?
Inventory was written down	Accounting notes, reserve changes	Did DIO improve mechanically after a loss?
Product mix changed	Category-level balances and COGS	Is the aggregate comparison still meaningful?

How to Evaluate DIO

Match inventory and COGS by scope, currency, and accounting basis.
Select a consistent day-count convention and period.
Use monthly or weekly averages when inventory is seasonal or volatile.
Compare with company history and close peers with similar products and supply chains.
Break the result into inventory stage, category, location, and age.
Review stockouts, backorders, lead times, markdowns, write-offs, and service levels.
Connect DIO with purchasing commitments, gross margin, and operating cash flow.

Common Mistakes and Limitations

Using sales instead of COGS: sales are not on the same cost basis as inventory.
Using a single closing balance: the result may reflect a seasonal reporting date.
Assuming DIO is literal shelf time: it is an accounting ratio, not item-level elapsed time.
Treating lower as always better: insufficient inventory can harm operations and customers.
Ignoring accounting policy: valuation methods and write-downs affect the denominator.
Missing inventory quality: old items can hide within a stable company-wide average.
Adding unmatched category days: raw-material, WIP, and finished-goods flows may differ.
Comparing unlike industries: product life, lead times, production cycles, and service targets vary.

Reporting and Source Documents

Inventory balances, cost methods, write-downs, and commitments may appear in the financial statements and notes. The SEC investor bulletin on reading a Form 10-K explains where to find statements, accounting policies, risks, and management discussion. Internal analysis should also use item aging, production-stage, purchasing, stockout, and warehouse data.

Inventory Turnover: Inventory velocity expressed as times per period.
Days Sales Outstanding: Customer-collection component of the operating cycle.
Days Payable Outstanding: Supplier-payment component subtracted in the cash conversion cycle.
Inventory Accounting: Valuation and recognition policies underlying the metric.
Working Capital: Operating investment tied up in current assets and liabilities.

FAQs

Is lower DIO always better?

No. Lower DIO can indicate efficient inventory use, but it can also reflect understocking, aggressive write-downs, or inadequate protection against supply disruption.

Is DIO the same as days sales of inventory?

They are commonly used as names for the same inventory-days concept. Check the actual formula because some sources may use different averages, periods, or sales-based inputs.

This page is educational and does not provide accounting, inventory-management, investment, or valuation advice.

Capital Turnover

DuPont Formula