The Days Inventory Outstanding calculator estimates how many days, on average, inventory remains on hand before it is sold. Enter beginning inventory, ending inventory, cost of goods sold, and the accounting period to calculate both average inventory and DIO.
DIO is also called inventory days or days in inventory. It measures how much inventory you hold relative to the cost of goods sold—not how long customers take to pay you.
How to use the DIO calculator
- Enter Beginning Inventory: Use the inventory value at the start of the accounting period.
- Enter Ending Inventory: Use the inventory value at the end of that same period.
- Enter Cost of Goods Sold: Use total COGS for the period, not sales revenue or inventory purchases.
- Enter the Accounting Period: Specify the number of days covered by your figures. For example, use 365 for a non-leap calendar year or the actual number of days in a quarter.
- Review the results: The calculator returns Average Inventory in dollars and Days Inventory Outstanding in days. You do not need to calculate or enter average inventory yourself.
Keep the inputs consistent: Inventory and COGS should be measured at cost, in the same currency and scale, and for the same business or product group. Do not combine quarterly COGS with a 365-day accounting period.
COGS and the accounting period must be positive for a meaningful standard calculation. When COGS is zero, DIO is undefined because the formula divides by zero; it does not mean inventory sells instantly.
Days inventory outstanding formula
The calculator first finds the simple average of beginning and ending inventory:
Average Inventory = (Beginning Inventory + Ending Inventory) ÷ 2
It then applies the days in inventory formula:
DIO = (Average Inventory ÷ Cost of Goods Sold) × Days in the Accounting Period
Equivalently, DIO is average inventory divided by average daily COGS. Using COGS rather than sales revenue keeps both sides of the calculation on a cost basis.
Worked example: calculating annual inventory days
Suppose a distributor reports the following figures:
| Input | Value |
|---|---|
| Beginning inventory | $100,000 |
| Ending inventory | $150,000 |
| Cost of goods sold | $625,000 |
| Accounting period | 365 days |
Average Inventory = ($100,000 + $150,000) ÷ 2 = $125,000
DIO = ($125,000 ÷ $625,000) × 365 = 73 days
The business holds inventory equivalent to approximately 73 days of COGS at the period's average selling rate. This is an aggregate estimate, not proof that every item spends exactly 73 days in storage.
How to interpret your DIO result
A lower DIO means less inventory is held relative to COGS. A higher DIO means more inventory is held relative to COGS. Neither result, by itself, establishes whether inventory management is effective.
- A falling DIO may reflect faster sales, smaller replenishment orders, or shorter production cycles. Check whether stockouts or backorders are also increasing.
- A rising DIO may indicate slower demand, excess stock, or production delays. It can also reflect a planned seasonal buildup or additional safety stock.
- DIO above the accounting period is mathematically possible. It occurs when average inventory exceeds the entire period's COGS and suggests slow turnover relative to stock held.
What is a good days inventory outstanding figure?
There is no universal target. Perishable goods, replacement parts, and products with long manufacturing cycles require different inventory policies. Compare your result with your own history and with businesses that have similar products, production cycles, and accounting practices.
For seasonal businesses, compare the same quarter or month across years rather than treating a pre-holiday stock buildup as equivalent to a quiet-season balance. Pair DIO with service measures such as product availability and order fulfillment to avoid improving the ratio at customers' expense.
How DIO relates to inventory turnover
Inventory turnover measures how many times inventory is sold and replaced during a period. Using the same average inventory, COGS, and period:
Inventory Turnover = COGS ÷ Average Inventory
DIO = Days in the Accounting Period ÷ Inventory Turnover
In the example above, turnover is $625,000 ÷ $125,000 = 5 times per year, so DIO is 365 ÷ 5 = 73 days.
Use DIO to guide inventory decisions
Use the result to decide where to investigate, rather than applying an across-the-board inventory reduction.
- Separate fast- and slow-moving products: Calculate DIO by category when matching inventory and COGS data are available. A company-wide average can conceal obsolete stock in one category and shortages in another.
- Review replenishment policies: Examine order quantities, minimum purchase commitments, supplier lead times, and safety stock before reducing orders.
- Check demand assumptions: Compare purchasing plans with recent sales, promotions, and seasonal patterns. Investigate persistent differences between forecasts and actual demand.
- Evaluate slow-stock promotions carefully: Discounts may help sell aging inventory, but assess the margin impact rather than judging success only by a lower DIO.
Translate a DIO target into an inventory estimate
At an unchanged COGS rate, you can estimate the average inventory associated with a target DIO:
Target Average Inventory = (Period COGS ÷ Period Days) × Target DIO
For the distributor above, a 60-day target implies average inventory of ($625,000 ÷ 365) × 60, or approximately $102,740. That is about $22,260 less than its current $125,000 average.
This difference estimates a potential reduction in capital tied up in inventory—not additional profit or guaranteed cash savings. Achieving it depends on purchasing, sales, supplier terms, and maintaining sufficient stock.
Important limitations of the calculation
- Two balances may miss fluctuations: The calculator averages only beginning and ending inventory. A large mid-period buildup may not appear in either balance. Review monthly or weekly balances separately if inventory is volatile.
- DIO does not measure individual item age: Use inventory aging reports to identify stock that has been sitting unsold for unusually long periods.
- It is backward-looking: Historical COGS may not represent future demand, so DIO is not necessarily the number of days your current stock will last.
- Accounting changes can affect the result: Write-downs, costing methods, and changes in product mix can alter inventory or COGS without an equivalent improvement in physical stock movement.
- Inventory sales are not cash collection: DIO excludes customer payment delays and supplier payment timing. Use broader working-capital measures to assess the full cash cycle.
Build a customized inventory savings calculator
Inventory software providers and supply-chain consultants can use Calcopolis to build an inventory savings calculator for their websites. Let visitors explore how a lower average inventory balance could affect carrying costs, using clearly stated assumptions.
Related calculators and financial checks
These calculators help turn an inventory-days result into a broader operational analysis:
- Inventory Turnover Ratio: Express the same inventory relationship as the number of stock turns during a period.
- Cash Conversion Cycle: Combine inventory days with customer collection and supplier payment timing.
- Economic Order Quantity: Explore order sizes that balance ordering and inventory holding costs under the model's assumptions.
For additional financial context:
- Liquidity: Compare Working Capital, the Current Ratio, and the Quick Ratio (Acid-Test) to assess short-term resources, including and excluding inventory.
- Profitability: Review Return on Assets (ROA) and Return on Equity (ROE) alongside DIO; faster turnover alone does not establish stronger earnings.
- Financing: Use the Debt-to-Equity Ratio to examine funding structure separately from inventory efficiency.
- Sales planning: Use Break-Even Analysis when evaluating whether sales volumes and margins cover costs.