SOLVETUTORMATH SOLVER

Instrument MI-02-170 · Finance

DIO Calculator

State average inventory and cost of goods sold. The instrument returns days inventory outstanding — how long stock sits before it turns into a sale.

Instrument MI-02-170
Sheet 1 OF 1
Rev A
Verified
Type 02 — Accounting SER. 2026-02170

Days inventory outstanding

48.67

DIO = average inventory ⁄ COGS × 365

The working Every figure verified twice
  1. dio = 80000 ⁄ 600000·365 = 48.67
Worksheet log
  1. No entries yet — change an input to log a scenario.

How this instrument works

Days inventory outstanding counts how many days, on average, a dollar of stock sits on the shelf or in the warehouse before it is sold and the sale is recorded through cost of goods sold. A retail buyer or plant operations manager tracks it because it turns an abstract inventory balance into a countable stretch of time — three weeks of stock, seven weeks, half a year — that a reorder schedule or a clearance decision can be sized against directly, unlike a raw dollar figure that says nothing about pace.

The formula divides average inventory by cost of goods sold rather than revenue, and that choice matters. Inventory sits on the books at what it cost the business to acquire or produce, not at the markup a customer eventually pays, so measuring it against COGS — itself a cost figure — keeps both sides of the ratio on the same basis. Averaging the beginning and ending balance rather than using a single snapshot smooths out the distortion a large shipment landing right before period-end would otherwise cause.

DIO says nothing about which items are moving and which are dead weight — a warehouse can average a healthy 40 days while half its shelf space holds stock that has not sold in a year, balanced out by fast-turning items at the other extreme. It is also the mirror image of the inventory turnover ratio, 365 divided by DIO, expressed in turns per year rather than days; retail teams that talk in turns and finance teams that talk in days are describing the identical stock, and mixing up which of the two numbers rose is a common misreading.

DIO=average inventoryCOGS×365DIO = \frac{\text{average inventory}}{\text{COGS}} \times 365
DIO — days inventory outstanding · average inventory — (beginning + ending inventory) ⁄ 2, valued at cost · COGS — cost of goods sold for the same period · 365 — days in the year, converting the ratio into a day count.
  • Enter Average inventory, $ — the typical value of stock on hand, ideally the beginning plus ending balance divided by two, valued at cost.
  • Enter Cost of goods sold, $/yr — the annual COGS figure from the income statement, not revenue.
  • Read Days inventory outstanding — how many days, on average, stock sits before it sells through.
  • Recalculate with a leaner or heavier inventory figure to see how many days a reorder cut or a clearance push would save.

Worked example — $80,000 of stock against $600,000 of COGS

A business carries Average inventory, $ of $80,000 against Cost of goods sold, $/yr of $600,000. Dividing 80,000 by 600,000 gives 0.1333333333, and multiplying by 365 days gives 48.6666666667 — Days inventory outstanding of roughly 48.67 days, meaning stock spends about seven weeks on the shelf before it sells through and is replaced.

Held against a typical grocery or fast-fashion retailer, where inventory can turn in two to three weeks, 48.67 days runs slow; held against a furniture showroom or an auto-parts distributor, the same figure would be tight. The number only means something next to a specific industry's own pace and a business's own trend line — a company whose DIO climbed from 35 to 48.67 over two quarters is building up stock faster than it is selling it, whatever the raw day count says by itself.

Questions

What counts as average inventory?

Average inventory is the beginning inventory balance plus the ending balance for the period, divided by two, valued at cost rather than at what the goods would sell for. Using a single snapshot instead, especially one taken right after a large shipment arrives or right before a seasonal clearance, can swing days inventory outstanding sharply without any real change in how fast stock actually turns.

Why does the formula use cost of goods sold instead of revenue?

Inventory is carried on the books at cost, and cost of goods sold is that same cost figure realized at the point of sale, so dividing one by the other keeps the ratio on a single, consistent basis. Substituting revenue in the denominator would fold in the retail markup, understating days inventory outstanding for any business with meaningful margin between what stock costs and what it sells for.

Is a lower days inventory outstanding always better?

Usually, but not without limit. A very low DIO can mean lean, well-managed stock, or it can mean the business keeps running out of popular items and turning away sales it could have made with a slightly deeper shelf. Compare the figure against the reorder lead time from suppliers — a DIO that dips below how long restocking takes risks stockouts, not efficiency.

How is DIO different from the inventory turnover ratio?

Inventory turnover is cost of goods sold divided by average inventory, expressed as a number of times per year rather than a day count — it is the reciprocal of this formula, so 365 divided by DIO gives turnover, and 365 divided by turnover gives DIO back. A DIO of 48.67 days corresponds to turnover of about 7.5 times a year; reporting one as though it moved the same direction as the other is the most common mix-up between the two metrics.

What is a typical days inventory outstanding?

There is no single normal figure — it depends heavily on the industry. Grocery chains and fast-fashion retailers often run under 30 days because stock is perishable or trend-driven; heavy equipment dealers and furniture retailers commonly run past 90 days because each unit is expensive and sells less often. Compare a business against its own history and close competitors, not a universal benchmark.

Does a rising DIO always mean inventory management is getting worse?

Not automatically — this instrument only shows the arithmetic effect of a changed inventory balance or COGS figure, not the cause behind it. A rising DIO ahead of a known seasonal peak, or during a deliberate stock-up before a supplier price increase, can be a planned decision rather than a warning sign; the same rise against flat sales more often signals slowing demand or aging stock.

References

Read this first: This instrument shows arithmetic, not advice. Real offers add fees, taxes and terms that vary by lender and place — verify the figures against your actual paperwork before deciding anything.