Days Inventory Outstanding Calculator: DIO in Days

Is a 60.83-day DIO healthy?

On the defaults — $150,000.00 of average inventory and $900,000.00 of cost of goods sold — the days inventory outstanding is 60.83 days. Days inventory outstanding is how many days, on average, stock sits before it sells — it turns the inventory on your balance sheet into a time measure. Typical DIO varies by industry: grocery and fast fashion often 20–40 days, general retail 40–70 days, manufacturing 60–120 days, car dealers and heavy machinery longer because each unit is expensive and slow to move. A DIO of 60.83 days sits at the top of the general-retail band and at the bottom of the manufacturing band — ordinary for a maker, long for a shop. A DIO that is too low can mean stockouts, lost sales and rushed reorders — the goal is a healthy DIO, not the shortest possible one.

Three things about the model are worth stating plainly. First, the days inventory outstanding is the average inventory divided by the cost of goods sold, times 365 — $150,000.00 ÷ $900,000.00 × 365 = 60.83 days. Second, the average inventory needed for a 100.00-day DIO is $246,575.34. And third, the cost of goods sold needed for a 100.00-day DIO is $547,500.00; all listed in Accuracy & limitations.

The worked example, line by line

Setup: $150,000.00 of average inventory, $900,000.00 of cost of goods sold, target DIO 100.00 days.

Line 1 — the days inventory outstanding. The days inventory outstanding is $150,000.00 ÷ $900,000.00 × 365 = 60.83 days.

Line 2 — the inventory the target needs. The average inventory needed for a 100.00-day DIO is 100.00 × $900,000.00 ÷ 365 = $246,575.34.

Line 3 — the costs the target needs. The cost of goods sold needed for a 100.00-day DIO is 365 × $150,000.00 ÷ 100.00 = $547,500.00.

Line 4 — the check. $150,000.00 ÷ $900,000.00 × 365 = 60.83 days, the days inventory outstanding; and 365 ÷ 60.83 = about 6 turns a year, the inventory turnover.

Every branch, checked

Cost of goods sold $1,200,000: Days inventory outstanding 45.63 days — With cost of goods sold of $1,200,000.00 the days inventory outstanding falls to 45.63 days — selling faster shortens the wait in stock.

Average inventory $300,000: Days inventory outstanding 121.67 days — With average inventory of $300,000.00 the days inventory outstanding doubles to 121.67 days — stock sitting on shelves ties cash up.

Cost of goods sold $600,000: Days inventory outstanding 91.25 days — With cost of goods sold of $600,000.00 the days inventory outstanding rises to 91.25 days — selling slower lengthens the wait in stock.

Average inventory $75,000: Days inventory outstanding 30.42 days — With average inventory of $75,000.00 the days inventory outstanding halves to 30.42 days — half the stock, half the wait.

Average inventory $0: Days inventory outstanding 0.00 days — With no inventory the days inventory outstanding is 0.00 days — there is nothing to sit on the shelf.

Cost of goods sold $2,700,000: Days inventory outstanding 20.28 days — With cost of goods sold of $2,700,000.00 the days inventory outstanding falls to 20.28 days — three times the sales, one third the wait.

What-if bars — average inventory halved, cost of goods sold doubled, average inventory doubled: average inventory halved to $75,000: days inventory outstanding 30.42 days; cost of goods sold doubled to $1,800,000: days inventory outstanding 30.42 days; average inventory doubled to $300,000: days inventory outstanding 121.67 days — Halving the inventory or doubling the cost of goods sold both cut the days inventory outstanding to 30.42 days; doubling the inventory doubles it to 121.67 days.

The reverses, worked backwards

Smallest whole-dollar average inventory for the DIO to reach 70.00 days: At the displayed $172,603 the figures are Days inventory outstanding 70.00 days; average inventory needed for the 70.00-day target $172,602.74; cost of goods sold needed for the 70.00-day target $900,001.36. At the displayed $172,603 the DIO is 70.00 days (unrounded 70.000106). At $172,602 the inventory is $1 short of the $172,603 needed — and the unrounded DIO is 69.999700, which displays as 70.00 days after rounding, so $172,603 is the smallest whole-dollar average inventory for the DIO to reach 70.00 days.

Smallest whole-dollar average inventory for the DIO to reach 90.00 days: At the displayed $221,918 the figures are Days inventory outstanding 90.00 days; average inventory needed for the 90.00-day target $221,917.81; cost of goods sold needed for the 90.00-day target $900,000.78. At the displayed $221,918 the DIO is 90.00 days (unrounded 90.000078). At $221,917 the inventory is $1 short of the $221,918 needed — and the unrounded DIO is 89.999672, which displays as 90.00 days after rounding, so $221,918 is the smallest whole-dollar average inventory for the DIO to reach 90.00 days.

Largest whole-dollar average inventory for the DIO to STAY at or below 50.00 days: At the displayed $123,287 the figures are Days inventory outstanding 50.00 days; average inventory needed for the 50.00-day target $123,287.67; cost of goods sold needed for the 50.00-day target $899,995.10. At the displayed $123,287 the DIO is 50.00 days (unrounded 49.999728). At $123,288 the inventory is $1 over the $123,287 allowed — and the unrounded DIO is 50.000133, which displays as 50.00 days after rounding, so $123,287 is the largest whole-dollar average inventory for the DIO to stay at or below 50.00 days.

Smallest whole-dollar cost of goods sold for the DIO to fall to 45.00 days or below: At the displayed $1,216,667 the figures are Days inventory outstanding 45.00 days; average inventory needed for the 45.00-day target $150,000.04; cost of goods sold needed for the 45.00-day target $1,216,666.67. At the displayed $1,216,667 the DIO is 45.00 days (unrounded 44.999988). At $1,216,666 the costs are $1 under the $1,216,667 needed — and the unrounded DIO is 45.000025, which displays as 45.00 days after rounding, so $1,216,667 is the smallest whole-dollar cost of goods sold for the DIO to fall to 45.00 days or below.

Largest whole-dollar cost of goods sold for the DIO to STAY at or above 75.00 days: At the displayed $730,000 the figures are Days inventory outstanding 75.00 days; average inventory needed for the 75.00-day target $150,000.00; cost of goods sold needed for the 75.00-day target $730,000.00. At the displayed $730,000 the DIO is 75.00 days (exactly 75.00). At $730,001 the costs are $1 over the $730,000 allowed — and the unrounded DIO is 74.999897, which displays as 75.00 days after rounding, so $730,000 is the largest whole-dollar cost of goods sold for the DIO to stay at or above 75.00 days.

Smallest whole-dollar average inventory for the DIO to reach 120.00 days: At the displayed $295,891 the figures are Days inventory outstanding 120.00 days; average inventory needed for the 120.00-day target $295,890.41; cost of goods sold needed for the 120.00-day target $900,001.79. At the displayed $295,891 the DIO is 120.00 days (unrounded 120.000239). At $295,890 the inventory is $1 short of the $295,891 needed — and the unrounded DIO is 119.999833, which displays as 120.00 days after rounding, so $295,891 is the smallest whole-dollar average inventory for the DIO to reach 120.00 days.

A warning about the neighbours: every neighbour above shows as the target when rounded to two decimals, but its unrounded DIO is a hair above or below the target. A lender underwriting on the unrounded DIO would still say no where the unrounded figure misses the line. The page prints the unrounded neighbour value in full so the rounding does not mislead you: 69.999700, 89.999672, 50.000133, 45.000025, 74.999897 and 119.999833.

What the defaults assume

The defaults are $150,000.00 of average inventory, $900,000.00 of cost of goods sold and a target DIO of 100.00 days — Days inventory outstanding 60.83 days; average inventory needed for the 100.00-day target $246,575.34; cost of goods sold needed for the 100.00-day target $547,500.00. With Cost of goods sold $1,200,000, Days inventory outstanding 45.63 days. With Average inventory $300,000, Days inventory outstanding 121.67 days. With Cost of goods sold $600,000, Days inventory outstanding 91.25 days. With Average inventory $75,000, Days inventory outstanding 30.42 days. With Average inventory $0, Days inventory outstanding 0.00 days. With Cost of goods sold $2,700,000, Days inventory outstanding 20.28 days. With What-if bars — average inventory halved, cost of goods sold doubled, average inventory doubled, average inventory halved to $75,000: days inventory outstanding 30.42 days; cost of goods sold doubled to $1,800,000: days inventory outstanding 30.42 days; average inventory doubled to $300,000: days inventory outstanding 121.67 days. With Average inventory $0, Days inventory outstanding 0.00 days. With Cost of goods sold $0, Days inventory outstanding — (undefined: no cost of goods sold to divide by). With Average inventory $295,890, Days inventory outstanding 120.00 days. With Average inventory $100,000, cost of goods sold $600,000, Days inventory outstanding 60.83 days. With Average inventory $201,575, Days inventory outstanding 81.75 days. With Average inventory $123,288, Days inventory outstanding 50.00 days. With DIO bars, average inventory $50,000: days inventory outstanding 20.28 days; average inventory $400,000: days inventory outstanding 162.22 days; cost of goods sold $450,000: days inventory outstanding 121.67 days; cost of goods sold $3,600,000: days inventory outstanding 15.21 days.

A note on the rounding: with average inventory of $295,890 the unrounded DIO is 119.999833, which rounds half-up to 120.00 days — but it is still below the 120-day line. With average inventory of $123,288 the unrounded DIO is 50.000133, which rounds half-up to 50.00 days — but it is just above the 50-day line. With average inventory of $201,575 the unrounded DIO is 81.749861, which rounds to 81.75 days. With average inventory of $100,000 and cost of goods sold of $600,000 the unrounded DIO is 60.833333, which rounds to 60.83 days. The page prints the unrounded values so the rounding does not mislead you.

Output · formula · meaning

Who uses this

• The small-business owner checking the year: they learn $150,000.00 of average inventory on $900,000.00 of cost of goods sold gives 60.83 days in stock — and they check the $172,603 reverse to see the smallest inventory for a 70.00-day DIO.
• The retailer whose shelves are full: they learn doubling the inventory doubles the DIO to 121.67 days — and they check the $123,287 reverse to see the largest inventory that stays at or below 50.00 days.
• The manufacturer whose stock is slow: they learn a DIO of 121.67 days means cash is parked in the warehouse — and they check the $1,216,667 reverse to see the cost of goods sold that pulls the DIO to 45.00 days or below.
• The grocer running lean: they learn a DIO near 20.28 days is normal when stock turns fast — and they check the $730,000 reverse to see the largest cost of goods sold that keeps the DIO at or above 75.00 days.

Accuracy & limitations

The math is first-principles: the days inventory outstanding is the average inventory divided by the cost of goods sold, times 365; the average inventory needed at the target is target days × cost of goods sold ÷ 365; the cost of goods sold needed at the target is 365 × average inventory ÷ target days — all rounded to two decimals half-up. The reverses are judged on the UNROUNDED DIO: a neighbour one dollar short or over shows as the target when rounded to two decimals, but its unrounded DIO is above or below the target, so it does not meet the bar — the page prints the unrounded neighbour value in full. What the model cannot do is judge the business: use average inventory, never closing inventory alone, because a single snapshot misleads when stock levels swing through the year; use cost of goods sold, never revenue, because revenue includes your markup and the markup was never sitting on the shelf; the average is (opening + closing) ÷ 2, a simple average that hides swings inside the period; with cost of goods sold of $0 the DIO is undefined — the calculator shows “—” with a note, never Infinity or NaN; a DIO that is too low can mean stockouts, lost sales and rushed reorders — the goal is a healthy DIO, not the shortest possible one; and the same DIO means different things by industry, so compare within an industry, not across them. DIO and inventory turnover are the same idea two ways: turnover is 365 divided by DIO, so a 60.83-day DIO is about 6 turns a year. Use it to see how long your stock sits — then read the rest of the statements.

Frequently asked questions