Stock and inventory helps businesses fulfill customer demand, but it can also tie up cash, storage capacity, and operational attention. Days Inventory Outstanding is a metric that turns the value of inventory into time: it estimates how many days inventory remains on hand before a business sells or uses it.

Also known as days sales in inventory, inventory days, or DIO inventory, the metric helps finance, warehouse, supply chain, and operations teams understand whether the current stock levels support the business or restrict cash flow. Used alongside inventory turnover, it can reveal slow-moving products, purchasing mismatches, seasonal exposure, and ways to optimize working capital.

What Is Days Inventory Outstanding?

Days Inventory Outstanding (DIO) measures the average number of days that a company holds inventory before selling it. Put simply, it estimates how long cash remains tied up in stock.

A company that buys raw materials, stores them, produces finished goods, and sells those goods can use DIO to understand the inventory portion of its cash conversion cycle. A lower DIO generally indicates that inventory moves faster. However, the right result depends on the industry, the type of inventory, supplier lead times, seasonal demand, customer service requirements, and supply-chain risk.

Days Inventory Outstanding may also be described using several similar terms:

Term Meaning
Days Inventory Outstanding Average number of days inventory is held before sale
Days Sales in Inventory Another common name for DIO
Days of Inventory General term for inventory days on hand
Inventory Days Shortened term for days sales in inventory
Days in Inventory Ratio Ratio that measures inventory holding time
DIO Inventory Common shorthand for Days Inventory Outstanding

Important: DIO is usually calculated using inventory value and cost of goods sold (COGS), not sales revenue. This keeps both parts of the calculation at cost and makes the result more consistent.

A DIO of 45, for example, means the business holds inventory for approximately 45 days on average before it is sold. But, and this is important, it does not mean that every product sells in exactly 45 days. Instead, it is an overall average that should be supported with SKU-level, category-level, location-level, and aging analysis.

The Days Inventory Outstanding Formula

The standard days of inventory outstanding formula is:

Days Inventory Outstanding = (Average Inventory ÷ Cost of Goods Sold) × Number of Days in the Period

For an annual calculation, use:

DIO = (Average Inventory ÷ Annual COGS) × 365

This is also the common days in inventory formula:

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

Another way to express the same calculation is:

Days Sales in Inventory = Average Inventory ÷ Average Daily Cost of Goods Sold

To calculate average daily COGS, use:

Average Daily COGS = Annual COGS ÷ 365

Both formulas should return the same result when you use the same inputs and reporting period.

Employee calculates Days Inventory Outstanding metric on computer

The Main Numbers You Need for DIO

To calculate days sales in inventory correctly, collect the following data for the same reporting period:

  • Beginning inventory: The inventory value at the start of the period.
  • Ending inventory: The inventory value at the end of the period.
  • Average inventory: The average value of inventory held during the period.
  • Cost of goods sold: The direct cost of the products sold during the period.
  • Number of days: Usually 365 for one year, or the exact number of days in a month, quarter, or custom period.

The standard average inventory formula is:

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

This method works well when inventory is relatively stable. If the business has strong seasonal demand, major purchases, or large inventory swings, it is better to calculate average inventory using monthly or weekly inventory balances.

The Inventory Turnover Version

You can also calculate Days Inventory Outstanding from inventory turnover.

Days Inventory Outstanding = 365 ÷ Inventory Turnover

The inventory turnover formula is:

Inventory Turnover = Cost of Goods Sold ÷ Average Inventory

This connection between the two metrics is important:

  1. Higher inventory turnover generally means fewer inventory days.
  2. Lower inventory turnover generally means more inventory days.

How To Calculate Days Sales in Inventory

The following example shows how to calculate days sales in inventory for a business over one year.

Assume a distributor has the following figures:

  • Beginning inventory: $180,000
  • Ending inventory: $220,000
  • Annual COGS: $1,825,000
  • Reporting period: 365 days

Step 1: Calculate Average Inventory

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

Average Inventory = ($180,000 + $220,000) ÷ 2

Average Inventory = $200,000

Step 2: Apply the Days Inventory Outstanding Formula

DIO = (Average Inventory ÷ Annual COGS) × 365

DIO = ($200,000 ÷ $1,825,000) × 365

DIO = 40 days

The company’s Days Inventory Outstanding is 40 days. On average, its inventory is held for 40 days before it is sold.

Step 3: Validate With Inventory Turnover

First, calculate inventory turnover:

Inventory Turnover = Annual COGS ÷ Average Inventory

Inventory Turnover = $1,825,000 ÷ $200,000

Inventory Turnover = 9.125 times per year

Next, calculate DIO using turnover:

Days Inventory Outstanding = 365 ÷ Inventory Turnover

Days Inventory Outstanding = 365 ÷ 9.125

Days Inventory Outstanding = 40 days

Both methods produce the same answer. This is a useful check when preparing financial reports, monthly performance reviews, or inventory dashboards.

Practical Tip: Always use the exact number of days in the period. For example, use 90, 91, or 92 days for a quarter rather than automatically multiplying by 365. Your inventory data, COGS data, and days in the formula must cover the same period.

How To Interpret Inventory Days Outstanding

A lower DIO often suggests that a business sells or uses inventory more quickly. This can improve cash flow, reduce storage expenses, and limit risks such as damage, expiration, obsolescence, theft, and markdowns.

However, low inventory days are not automatically positive, and high inventory days are not always negative.

DIO Situation Possible Meaning What To Investigate
DIO is falling Inventory is moving more quickly or stock levels are declining Higher demand, better forecasting, reduced purchases, stockouts
DIO is rising More inventory is held relative to COGS Slow sales, over-purchasing, demand declines, supplier requirements
DIO is stable Inventory levels and sales activity are consistent Whether the current level supports service and profitability goals
DIO is much lower than peers Lean inventory management or risk of stockouts Fill rates, backorders, lost sales, supplier lead-time reliability
DIO is much higher than peers Excess inventory or a different operating model Product mix, safety stock, seasonality, aging or obsolete items

The days in inventory ratio is most useful when businesses compare it over time and across operations:

  • Compare current DIO with prior months, quarters, and years.
  • Compare inventory days by warehouse, store, job site, department, or business unit.
  • Compare DIO with days inventory turnover.
  • Compare DIO with stockout rates, fill rates, order lead times, and forecast accuracy.
  • Compare DIO with inventory aging and obsolete stock reports.
  • Compare against businesses with similar inventory types and operating models.

Example: A grocery distributor may aim for significantly fewer inventory days than a manufacturer that stocks specialized replacement parts with long supplier lead times. A furniture retailer may naturally have more inventory days than a convenience store. The goal is not to copy another industry’s number; it is to find the inventory position that balances customer availability, cost, and cash flow.

Why DIO Matters for Cash Flow

Days Inventory Outstanding is a key working-capital metric because it shows how long a business’s cash remains invested in inventory.

The inventory cycle usually looks like this:

Cash → Inventory → Sale → Accounts Receivable → Cash

Before a company can collect payment from a customer, it often has to purchase or manufacture inventory, store it, and sell it. If stock remains in the warehouse for too long, the business has more money committed to inventory and less cash available for payroll, supplier payments, growth, repairs, marketing, or debt repayment.

A high DIO can increase:

  • The amount of cash tied up in stock.
  • Warehouse and storage costs.
  • Insurance, security, and handling expenses.
  • The risk of product damage or expiration.
  • The risk of obsolescence and markdowns.
  • The need for financing or short-term borrowing.

A lower DIO can improve cash availability, but only when inventory remains sufficient to fulfill customer orders. The objective is not to reduce inventory at all costs. Instead, the objective is to hold the right stock, in the right quantity, in the right location, at the right time.

Benefits of Tracking DIO Inventory

Tracking DIO inventory regularly can help businesses:

  • Identify slow-moving, aging, excess, or obsolete inventory.
  • Improve working-capital and cash-flow planning.
  • Detect purchasing levels that exceed real demand.
  • Improve replenishment rules and safety stock decisions.
  • Identify warehouses or locations with excess inventory.
  • Reduce storage and inventory carrying costs.
  • Support supplier negotiations around order quantities and delivery frequency.
  • Assess the effect of promotions, product launches, and seasonal buying.
  • Give finance leaders a clear view of how inventory affects cash.

For businesses that manage stock across several locations, a total company DIO may hide important local issues. One warehouse could be overstocked while another location experiences recurring shortages of the same item. This is why company-level DIO should be combined with location-level inventory reporting.

How To Improve Days Inventory Outstanding

Improving Days Inventory Outstanding is not simply about buying less inventory. Sustainable DIO improvement requires a better understanding of why stock is sitting unused or unsold.

Improve Demand Forecasting

Use historical sales, seasonality, customer orders, promotions, lead times, supplier performance, and market changes to forecast demand. Review the forecast by SKU, product group, and location, especially for high-value products, slow-moving items, and inventory with uncertain demand.

Forecasting should be updated regularly. A forecast that was accurate six months ago may become unreliable after a new customer contract, supplier disruption, price change, product launch, or shift in customer preferences.

Segment Inventory by Risk and Value

Not all inventory needs the same level of attention. ABC analysis helps teams focus control efforts where they have the greatest impact.

  • A items: High-value or business-critical inventory that needs frequent monitoring.
  • B items: Moderate-value inventory that can follow standard purchasing and replenishment rules.
  • C items: Lower-value inventory that can be managed with simpler controls.
  • Slow-moving items: Products that require special review, restricted purchasing, transfers, bundling, liquidation, or disposal plans.

This approach helps prevent operations teams from spending too much time on low-value stock while overlooking expensive items that create the largest working-capital risk.

Set Better Reorder Points

Reorder points should reflect actual demand during supplier lead time, plus a suitable amount of safety stock.

A simple reorder point formula is:

Reorder Point = (Average Daily Demand × Lead Time in Days) + Safety Stock

If a business uses outdated demand assumptions, unrealistic lead times, or excessive safety stock, it may accumulate more inventory than it needs. If reorder points are too low, the business may reduce DIO but create frequent stockouts and missed sales.

Reduce Excess and Obsolete Stock

Set up a recurring process to review inventory with low movement, declining demand, expiry risk, or high carrying costs. Actions may include:

  • Pausing replenishment for specific SKUs.
  • Returning eligible stock to suppliers.
  • Transferring inventory between warehouses, stores, or job sites.
  • Bundling slow-moving items with faster-selling products.
  • Offering controlled promotions or discounts.
  • Repairing, repurposing, recycling, or disposing of unusable materials.
  • Writing off genuinely obsolete stock accurately and promptly.

The earlier a team identifies slow-moving stock, the more options it has to recover value. Waiting until inventory becomes fully obsolete often leads to unnecessary losses.

Use Inventory Data in Daily Operations

Inventory improvement depends on clean, current data. Teams need visibility into quantities, locations, usage history, item condition, ownership, reorder levels, supplier information, and stock movements.

Spreadsheets can help at the beginning, but they become difficult to maintain when inventory is distributed across warehouses, departments, job sites, service vehicles, or teams.

This is where a centralized inventory management software such as Timly can support better operational control. Timly helps organizations document and track equipment, tools, materials, locations, and inventory movements in one place. With stronger visibility over where inventory is located and how it is used, teams can make more informed purchasing, replenishment, and redistribution decisions.

Timly is especially helpful for businesses that manage inventory across multiple operational locations. Instead of relying on fragmented spreadsheets or manual stock checks, teams can build a clearer inventory record and use it to support more accurate DIO inventory reporting.

Build a Healthier Inventory Cycle

Days Inventory Outstanding is not just an accounting formula. In addition to the formula, it also connects procurement, sales, warehouse operations, production, customer service, and cash flow in one understandable metric.

A dependable days inventory outstanding calculation starts with accurate inventory values, consistent COGS data, and a reporting period that matches both figures. The most valuable insight comes from watching trends over time: Is DIO increasing? Which products or locations are causing the change? Is the increase intentional because of seasonality, or is it caused by slower demand, over-purchasing, poor forecasting, or obsolete inventory?

The strongest businesses do not use DIO alone. They evaluate inventory days alongside inventory turnover, aging reports, stockouts, fill rates, forecast accuracy, supplier lead times, and cash-flow requirements.

With a platform such as Timly supporting inventory visibility, inventory accuracy, and operational documentation, teams can move from reactive stock management to more timely, data-based decisions. That can help reduce unnecessary inventory, protect service levels, and free up cash for the parts of the business that need it most.

FAQs About Days Inventory Outstanding

There is no single good Days Inventory Outstanding ratio for every business. The appropriate level depends on the industry, product life cycle, demand volatility, supplier lead times, customer expectations, and seasonality. A healthy DIO is one that supports customer service without creating unnecessary storage costs, obsolete inventory, or avoidable cash constraints.

The most useful comparison is usually against your own previous performance and similar businesses with comparable inventory models.

Yes. Days Inventory Outstanding, days sales in inventory, days of inventory, inventory days, and the days in inventory ratio generally describe the same concept: the average number of days inventory remains on hand before it is sold or consumed.

The standard calculation is:

Days Inventory Outstanding = (Average Inventory ÷ Cost of Goods Sold) × Number of Days in the Period

To calculate days sales in inventory using turnover, use this formula:

Days Sales in Inventory = 365 ÷ Inventory Turnover

For example, if annual inventory turnover is 10:

Days Sales in Inventory = 365 ÷ 10

Days Sales in Inventory = 36.5 days

This means the business holds inventory for approximately 36.5 days on average.

Average inventory is generally the better choice because it reflects inventory levels throughout the reporting period.

Use this formula:

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

Using only ending inventory can be useful for a quick estimate, but it may distort the DIO result if inventory changed significantly during the period. This is especially important for seasonal businesses, companies making large purchases, or organizations with fluctuating demand.

An increasing DIO means that inventory is being held longer relative to COGS. Possible causes include:

  • Slower sales or declining customer demand.
  • Excess purchasing or large supplier order minimums.
  • Forecasting errors.
  • Higher safety-stock levels.
  • Discontinued or outdated products.
  • Inventory located in the wrong warehouse or job site.
  • Production delays.
  • High return rates.
  • Delayed promotions or product launches.

To find the cause, review DIO by SKU, product category, warehouse, inventory age, and supplier. A company-wide DIO figure can identify the problem, but detailed inventory data is needed to diagnose and solve it.