Days inventory outstanding (DIO) explained

What DIO and inventory turnover measure

When a distributor or manufacturer buys or builds inventory, cash leaves (or is tied up) before revenue is recognized. The asset sits on the balance sheet until a customer order ships. DIO answers: “At the current sales pace, how many days of cost of goods sold (COGS) are sitting in inventory?”

From the company’s perspective, lower DIO means faster inventory rotation — less cash trapped in the warehouse, lower obsolescence risk, and typically lower storage and handling cost per dollar sold. That is why DIO is added in the CCC formula: higher DIO lengthens the cycle and consumes cash. But “too low” DIO can mean stockouts, lost sales, and expedited freight — the art is matching inventory depth to demand variability and supplier lead times.

Inventory turnover flips the ratio: COGS divided by average inventory. Higher turnover means faster sales relative to stock on hand; lower turnover means inventory sits longer. Analysts use DIO for intuitive day comparisons and turnover when modeling annual cash cycles or DuPont-style decompositions with asset turnover.

Formulas and worked example

Standard DIO uses average inventory and cost of goods sold over the same period:

DIO = (Average Inventory ÷ COGS) × Days in Period

For a fiscal year, multiply by 365; for a quarter, multiply by 90. Use average inventory (beginning + ending ÷ 2) unless the company discloses a more precise daily average. When inventory is seasonal, trailing-twelve-month COGS and average inventory smooth quarter-end spikes.

Inventory Turnover = COGS ÷ Average Inventory

DIO and turnover are reciprocals scaled by days: DIO ≈ 365 ÷ Inventory Turnover on an annual basis. Turnover of 6× implies DIO ≈ 61 days.

Harbor Components Q4 2025 (simplified):

• Quarterly COGS: $96M
• Inventory beginning: $54M; ending: $50M → average $52M
• DIO = ($52M ÷ $96M) × 90 ≈ 49 days (annualized ~52 days on trailing-twelve-month basis reported in MD&A)

Prior-year DIO was 38 days on similar revenue mix — the expansion reflected deliberate safety-stock inflation and forecast bias after a 2024 chip shortage, not a structural shift to slower product lines.

DIO inside the cash conversion cycle

The cash conversion cycle combines inventory, receivables, and payables:

CCC = DIO + DSO − DPO

DIO is the first term because inventory is typically acquired (and cash committed or paid) before the customer pays. A one-day DIO reduction on $400M of annual COGS releases roughly $1.1M of cash (1 ÷ 365 × $400M).

Link DIO changes to the statement of cash flows: a decrease in inventory appears as a source of cash in operating activities even when net income is flat. Conversely, a DIO rise (inventory building faster than sales) consumes cash — a pattern that can make a growth quarter look weak on cash flow. Reconcile inventory movements with the working-capital line in free cash flow bridges. Pair DIO with DSO and DPO to see whether the full operating cycle improved or only one leg shifted.

For retailers and manufacturers, also watch inventory reserves and write-downs in footnotes — reported inventory may overstate economic value if obsolescence reserves lag reality. Cross-check against earnings quality signals when DIO rises but reserves are flat.

Sector benchmarks and context

Optimal DIO depends on product shelf life, supplier lead times, and business model:

Compare DIO to peer medians and to the company’s own five-year range. A distributor at 52 days when peers sit at 38 may be overstocked; a luxury brand at 120 days may be executing strategy. Always read MD&A for supply-chain commentary and any disclosed stockout or backorder rates — low DIO with chronic stockouts is not efficiency.

When falling DIO helps vs hurts

Healthy reasons DIO falls

• Demand forecasting and SKU rationalization — Harbor’s core fix: align safety stock to velocity tiers, not blanket buffers.
• Supplier lead-time improvement — shorter replenishment cycles justify lower on-hand targets.
• Warehouse network optimization — pooling slow movers into fewer DCs reduces duplicate safety stock.
• Write-downs and obsolescence cleanup — removes dead weight; DIO falls but may hit gross margin once (honest accounting).

Red flags when DIO falls

• DIO down but revenue down faster — destocking because demand collapsed, not because operations improved.
• Channel stuffing — inventory shipped to distributors that cannot sell through; company DIO falls while channel inventory rises.
• LIFO liquidation — accounting-driven COGS dip inflates turnover artificially; read inventory turnover footnotes for LIFO/FIFO effects.
• Rising stockouts and lost sales — fill-rate metrics deteriorate; customers switch suppliers.
• DIO down but gross margin compressing — fire-sale clearance of obsolete stock masks operational weakness.

Red flags when DIO rises

• DIO up while revenue growth slows — classic overproduction or demand miss; inventory building into a soft market.
• Obsolescence reserves flat while DIO climbs — reported inventory may be overstated.
• CCC lengthening despite DPO extension — inventory and/or receivables may be absorbing any payables benefit.

Harbor Components refactor: 52 days back to 38

Harbor’s planners had set a global 21-day safety-stock overlay on every SKU after a 2024 connector shortage — including C-class items that turned twice a year. Regional DCs duplicated the same slow movers “just in case,” and no one retired the rule when lead times normalized. Week 1–3: ABC analysis on 12-month velocity; identified 18% of SKUs carrying 63% of inventory dollars at <2 turns annually. Month 2: replaced blanket safety stock with tiered targets (A: 7 days, B: 14 days, C: 28 days) and consolidated C-class into two hubs. Month 3–4: ran promotional bundles on three obsolete connector families; took a $2.1M write-down rather than carrying them another year. Month 5–6: tied planner bonuses to DIO and fill-rate jointly — not fill-rate alone.

Outcomes: DIO 52 → 38 days, $14M working capital released, stockout rate rose only 40 bps (within tolerance), and operating cash flow exceeded net income for the first time in three quarters. Gross margin dipped 60 bps in Q1 2026 from the write-down but recovered by Q2 as clearance ended. Finance modeled the program as NPV-positive versus drawing on a revolver at 8.5%.

Technique decision table

Common pitfalls

• Using point-in-time inventory instead of average — year-end builds for tax or display can distort a single snapshot.
• Wrong denominator — COGS for inventory-intensive businesses; not revenue (overstates turnover for low-margin distributors).
• Ignoring work-in-progress and raw materials — manufacturing DIO should include all inventory stages disclosed in the 10-K.
• Treating lower DIO as always good — chronic stockouts destroy revenue; pair with service-level metrics.
• Comparing grocery to aerospace — DIO norms differ radically by supply chain and product life.
• Missing LIFO/FIFO distortion — accounting method changes can move DIO without operational change.
• Currency translation — multinational inventory swings from FX can mimic velocity changes.
• Off-balance-sheet consignment — economic inventory may exceed reported inventory when vendors hold stock at customer sites.

Investor checklist

• Calculate DIO and inventory turnover with average inventory each quarter.
• Plot DIO against revenue growth — flag divergence > 5 days year over year.
• Read inventory, obsolescence reserve, and LIFO/FIFO footnotes in 10-K / 10-Q.
• Reconcile inventory change to operating cash flow working-capital line.
• Benchmark against two direct peers in the same distribution or manufacturing model.
• Compute CCC with DIO, DSO, and DPO — check whether total cycle improved.
• Scan MD&A for stockout, backorder, and supply-chain commentary.
• Check channel inventory and sell-through if the company uses distributors.
• Evaluate gross margin alongside DIO — clearance and write-downs tell a story.
• Model one-day DIO reduction impact on FCF before crediting management for cost cuts alone.

Key takeaways

• DIO converts inventory into holding time in days — the stock-efficiency leg of the cash conversion cycle.
• Lower DIO usually frees cash — but only when service levels and obsolescence risk stay controlled.
• Rising DIO can drain cash even when earnings look fine — Harbor tied up $14M in preventable safety stock.
• Channel stuffing and LIFO liquidation can fake improvement — read footnotes and sell-through data.
• Always pair DIO with CCC, cash flow, gross margin, and peer benchmarks — one ratio alone misleads.

Related reading

• Cash conversion cycle explained — DIO + DSO − DPO and negative CCC models
• Inventory turnover ratio explained — turnover formula, LIFO/FIFO traps, and sector benchmarks
• Days payable outstanding (DPO) explained — the payables leg of working capital
• Days sales outstanding (DSO) explained — the receivables leg of working capital