Days Inventory Outstanding Calculator

Days Inventory Outstanding (DIO) tells you how many days, on average, a dollar sits on the shelf as inventory before it turns into a sale. Same underlying idea as Inventory Turnover, just flipped around — instead of "how many times a year," it's "how many days at a time."

Some people find days more intuitive than a ratio, and that's really the whole reason DIO exists alongside turnover. "Our inventory sits for 73 days" lands differently in a planning meeting than "we turn 5 times a year," even though they're the same number wearing different clothes. DIO also slots directly into thecash conversion cycle — the stretch of time between paying a supplier and collecting cash from a customer — which is why finance teams track it as closely as operations does.

Lower DIO generally means capital moves faster and obsolescence risk is lower. Higher DIO means more cash tied up sitting on shelves. Neither is universally "correct" — a jewelry store and a grocery chain will have wildly different normal ranges, and that's fine.

It's Inventory Turnover's formula, inverted and stretched across a 365-day year. In fact, the two convert into each other directly:

• Inventory Turnover = 365 / DIO
• DIO = 365 / Inventory Turnover

A DIO of 73 days and a turnover of 5.0 times per year are the exact same fact about the business, just phrased two different ways.

Scenario: Retail distribution center
Average inventory: $100,000
Annual COGS: $500,000

On average, inventory sits 73 days in the warehouse before being sold — roughly 2.4 months, or about 5 times through the whole cycle per year (matching an Inventory Turnover of 5.0).

Now say this distribution center tightens up its ordering and gets average inventory down to $60,000 without touching COGS:

That's nearly a month less capital sitting on the shelf, for the same sales volume — the kind of improvement that shows up directly in cash flow, not just in an inventory report.

DIO carries the same assumptions as Inventory Turnover, because it's built from the same two inputs: COGS and average inventory need to cover the same period, and that average needs to actually represent the period rather than one unusual snapshot.

Where it gets misleading is seasonality. A retailer that stocks up hard for the holidays and sells it all down in December will show a very different DIO in a Q4 snapshot than in a Q2 one — an annual average can flatten both into a number that doesn't describe either season well. If your business has real peaks and valleys, calculate DIO by quarter or month, not just once a year.

It's also worth remembering DIO is a lagging, backward-looking number — it tells you what already happened, not what's about to. A big incoming order that hasn't shipped yet won't show up until next period's calculation.

Reporting DIO and Turnover as if they're independent facts.They're the same number, just inverted. Showing both in the same deck without tying them together just invites someone to ask why they don't match up.

Ignoring seasonality. A single annual DIO on a seasonal business averages away the exact swings you'd want to see. Break it out by quarter if your inventory really does move in waves.

Treating a low DIO as unambiguously good. Fast turnover can mean sharp inventory management — or it can mean you're chronically understocked and losing sales you're not even measuring. Check stockout rates alongside DIO before declaring victory.

Comparing DIO across mismatched businesses. A 73-day DIO is unremarkable for a general retailer and alarmingly slow for a grocery chain. Benchmark within your own category.

Forgetting DIO is a trailing indicator. It tells you what already happened to inventory over the measured period — it won't warn you about a slowdown that's only just starting.

The DIO range table above is a reasonable starting point, but the honest benchmark is your own category and your own history. A DIO of 73 days is normal for general retail, slow for e-commerce or grocery, and fast for furniture or industrial equipment. Track the trend over time within your own business — a rising DIO with flat COGS is usually the earlier, clearer warning sign than any external comparison.

Once you know how long inventory sits, act on it:

1. Put a dollar figure on it — Carrying Cost turns "73 days" into an actual annual cost.
2. Break it down by tier — check DIO within your A/B/C categories, not just as one blended number.
3. Tighten the cycle — Cycle Stock and EOQ both influence average inventory, and average inventory is half the DIO formula.

• Inventory TurnoverThe same metric, expressed as a ratio instead of days.
• Carrying CostSee what all those extra days on the shelf are actually costing.
• ABC AnalysisCheck DIO within a value tier, not just across the whole catalog.
• Cycle StockSee how much of that average inventory is just normal order cycling.

Books:

• Financial Intelligence by Karen Berman and Joe Knight (cash conversion cycle context)
• Supply Chain Management: Strategy, Planning, and Operationby Sunil Chopra

Standards & curricula:

• APICS (ASCM) CSCP certification curriculum

Online courses:

• Coursera: "Supply Chain Management" (Michigan State University)

General references for further study, not endorsements — verify course availability and content directly with the provider.