Vizma
Book a demo
Inventory Management

Days Inventory Outstanding (DIO)

Average number of days inventory is held before being sold. In practice, the metric helps separate movement in an operating outcome from changes in volume, mix, or measurement scope.

Business context

Why Days Inventory Outstanding matters

Days Inventory Outstanding becomes decision-useful when teams can explain which input moved, where it moved, and whether the definition stayed stable.

Business question
What does Days Inventory Outstanding tell us about performance in the selected scope and period?
Teams that use it
Procurement, inventory, logistics, production, finance, and fulfilment teams.
Decisions it supports
Supplier management, stock policy, transport planning, production improvement, and service recovery.
Calculation

Days Inventory Outstanding formula

(Average Inventory ÷ Cost of Goods Sold) × 365

Formula components

Inventory
The consistently counted inventory included in the metric’s documented population and period.
Cost Of Goods Sold
The monetary amount assigned to cost of goods sold for the same scope and reporting period used by Days Inventory Outstanding.
Reporting period
The consistent day, week, month, quarter, or year covered by every input.

How to calculate Days Inventory Outstanding

  1. Define the business scope, reporting period, and the event or status that qualifies for Days Inventory Outstanding.
  2. Remove duplicates and exclusions according to the documented rule, while retaining a reconciliation count.
  3. Collect each input in the workbook formula from systems that use the same cut-off and unit.
  4. Apply (Average Inventory ÷ Cost of Goods Sold) × 365 and label the result with its period, unit, and relevant segment.
Worked example

Days Inventory Outstanding example

A fictional supply chain team calculates Days Inventory Outstanding for one agreed reporting period.

  1. Inventory = £160,000.
  2. Cost Of Goods Sold = 1,460,000.
  3. Days Inventory Outstanding = £160,000 ÷ 1,460,000 × 365 = 40.

Days Inventory Outstanding is 40.

The scaled result can now be compared with like-for-like periods that use the same denominator.

How to interpret the result

Compare Days Inventory Outstanding over a consistent cadence and break it down only by segments large enough to support a decision. Review the formula inputs beside the result so teams can distinguish a real operating shift from a denominator or mix effect.

There is no single target that fits every organisation. Interpretation depends on product type, network design, geography, supplier terms, service promise, seasonality, and measurement period. Document the comparison group before labelling a result strong or weak.

Common mistakes and limitations

Inconsistent scope
Changing the included business units, products, channels, or populations makes the trend look different even when underlying performance is unchanged.
Mismatched periods
Formula inputs from different cut-off dates or time windows do not describe one coherent result.
Reading the headline alone
A single value can hide offsetting movement across segments, volumes, or contributing formula components.
Assuming one universal target
A useful comparison depends on product type, network design, geography, supplier terms, service promise, seasonality, and measurement period; use like-for-like internal trends and clearly documented peer groups.
Inventory Turnover Measures how often inventory is sold and replaced in a given period. Carrying Cost of Inventory Total cost of holding inventory, including storage, insurance, and depreciation. Inventory Accuracy Rate Percentage of inventory records that match actual physical stock. Stockout Rate Percentage of inventory items that were out of stock when needed.

Turn metric definitions into answers your team can use.

Vizma helps teams understand and track business metrics using their data. Bring your Days Inventory Outstanding definition, underlying data, and reporting questions to a Vizma demo.

Book a demoExplore platform