Last verified · v1.0

Calculator · finance

Days Inventory Outstanding (Dio) Calculator

Calculate Days Inventory Outstanding (DIO) to measure how many days a company holds inventory before selling it, using COGS and average inventory values.

FreeInstantNo signupOpen source

Inputs

Beginning Inventory

Ending Inventory

Cost of Goods Sold (COGS)

Days in Period

Use Average Inventory

Days Inventory Outstanding

—

Get a plain-English breakdown of your result with practical next steps.

Days Inventory Outstanding—days

The formula

How the
result is
computed.

What Is Days Inventory Outstanding (DIO)?

Days Inventory Outstanding (DIO) — also called Days Sales of Inventory (DSI) or inventory days — measures how many days a company holds its inventory before selling it. A lower DIO signals efficient inventory management and faster cash conversion, while a higher DIO may indicate overstocking, slow-moving goods, or supply chain bottlenecks. Finance teams, supply chain managers, and investors use DIO to benchmark operational performance against industry peers and historical trends.

The DIO Formula

The standard formula for calculating DIO is:

DIO = (Average Inventory ÷ Cost of Goods Sold) × Days in Period

Where Average Inventory is computed as:

Average Inventory = (Beginning Inventory + Ending Inventory) ÷ 2

Average Inventory: Smooths out period-start and period-end balances to reduce distortion from seasonal swings.
Cost of Goods Sold (COGS): The total direct cost of producing goods sold during the period, drawn from the income statement.
Days in Period: Typically 365 for annual analysis, 90 for quarterly, or 30 for monthly evaluations.

Using Ending Inventory vs. Average Inventory

Some analysts substitute ending inventory for average inventory when inventory levels remain relatively stable throughout the period. However, for businesses with pronounced seasonality — such as retailers whose holiday stock can triple normal levels — using average inventory produces a more reliable DIO figure. The Days Sales in Inventory academic framework recommends average inventory for all but the most stable inventory profiles.

Derivation and the Cash Conversion Cycle

DIO is a foundational component of the Cash Conversion Cycle (CCC), which quantifies how efficiently a company converts operational investments into cash. According to Investopedia's guide to the Cash Conversion Cycle, the full formula is:

CCC = DIO + DSO − DPO

Where DSO is Days Sales Outstanding (time to collect receivables after a sale) and DPO is Days Payable Outstanding (time the company takes to pay suppliers). Minimizing CCC — and therefore DIO — directly reduces working capital requirements and improves free cash flow.

Step-by-Step Calculation Example

Consider a mid-size electronics retailer with these annual figures:

Beginning Inventory: $1,200,000
Ending Inventory: $1,600,000
Cost of Goods Sold: $9,500,000
Days in Period: 365

Step 1 — Calculate Average Inventory: ($1,200,000 + $1,600,000) ÷ 2 = $1,400,000

Step 2 — Apply the DIO Formula: ($1,400,000 ÷ $9,500,000) × 365 = 53.8 days

The retailer turns its inventory approximately every 54 days. Compared to the consumer electronics industry average of roughly 50–65 days, this result falls within a healthy range. If DIO climbed above 80 days in a subsequent period, management would investigate potential overbuying or declining demand signals.

Industry Benchmarks

DIO varies dramatically across sectors. Grocery chains typically post a DIO of 14–21 days owing to perishable goods and high turnover. Automotive dealerships average 45–60 days, while aerospace and defense manufacturers can exceed 150 days due to complex production cycles and long-lead-time components. Research published in Drivers of the Cash Conversion Cycle in Retail confirms that inventory efficiency ranks among the strongest predictors of retail profitability. Financial management resources from Michigan State University Open Books further classify DIO as a critical activity ratio for evaluating operational efficiency in any asset-intensive business.

Interpreting and Acting on DIO Results

A steadily declining DIO across reporting periods typically signals improving supply chain efficiency and tighter demand forecasting. A rising DIO demands context: strategic pre-purchasing ahead of tariff increases or supply disruptions may legitimately inflate inventory, while weak consumer demand and poor assortment planning represent risk factors. Best practice is to compare DIO against three reference points: (1) the same company one year prior, (2) direct competitors, and (3) the broader industry average. A DIO materially higher than all three reference points warrants an immediate operational review of purchasing, forecasting, and markdown strategies.

Reference

Frequently asked questions

What is a good Days Inventory Outstanding (DIO) number?

A good DIO depends heavily on the industry. Grocery retailers aim for 14–21 days, general merchandise retailers target 30–60 days, and manufacturers often accept 60–100+ days. The most meaningful benchmark is comparison against direct competitors and the company's own historical trend. A declining DIO quarter-over-quarter generally indicates improving inventory efficiency, regardless of the absolute number.

How does Days Inventory Outstanding affect cash flow?

DIO directly impacts working capital. Every additional day of inventory ties up cash that could otherwise fund operations, debt repayment, or investment. For example, a company with $10 million in annual COGS reducing its DIO from 60 to 45 days frees approximately $411,000 in cash. Lowering DIO shortens the Cash Conversion Cycle, improving liquidity without requiring additional external financing.

What is the difference between DIO and the inventory turnover ratio?

Inventory turnover ratio measures how many times a company sells through its entire inventory in a period (COGS divided by Average Inventory), while DIO converts that ratio into days (365 divided by Inventory Turnover). An inventory turnover of 8 equals a DIO of approximately 45.6 days. Both metrics measure the same efficiency concept; DIO is simply more intuitive for operational planning and working capital forecasting.

Should average inventory or ending inventory be used in the DIO formula?

Average inventory — the mean of beginning and ending balances — is preferred for most analyses because it reduces distortion from seasonal spikes or unusual period-end inventory positions. Ending inventory alone may be appropriate when inventory levels are highly stable. For companies with strong seasonality, such as holiday-driven retailers, using ending inventory can understate or overstate the true holding period by 20–40%, making average inventory the safer and more accurate choice.

How does DIO relate to the Cash Conversion Cycle (CCC)?

DIO is the first of three components in the Cash Conversion Cycle: CCC = DIO + DSO minus DPO. DIO represents the time inventory sits on hand before being sold, DSO measures how long it takes to collect payment after the sale, and DPO reflects how long the company delays paying its own suppliers. Reducing DIO is typically the highest-leverage action a company can take to shorten its CCC and reduce working capital requirements.

What are common strategies to reduce Days Inventory Outstanding?

Common strategies to reduce DIO include implementing just-in-time (JIT) inventory replenishment, improving demand forecasting accuracy using historical sales data and predictive analytics, rationalizing SKU counts to eliminate slow-moving items, negotiating shorter lead times with suppliers, and deploying dynamic pricing to clear aging stock. Even a 10-day DIO reduction for a business with $50 million in annual COGS releases roughly $1.37 million in working capital, making inventory optimization a high-ROI operational initiative.