Distribution Days Calculator

Distribution days, known in accounting as days inventory outstanding (DIO), measures how long your stock sits in the warehouse before it sells: the average number of days inventory is held before it converts into sales. Enter your beginning and ending inventory and your cost of goods sold, and this calculator returns your DIO in days, your inventory turnover, and your COGS per day, with sector benchmarks below so you can judge the number against businesses like yours.

Quick Answer

How to use the days inventory outstanding calculator

You need three figures from statements you already have: inventory at the start and end of the period, and cost of goods sold for the same period. The calculator averages the inventory and returns three linked results.

The days inventory outstanding formula

Three short formulas do all the work, each using figures from a named statement.

Beginning and ending inventory come from the balance sheet. Inventory is a snapshot at a moment in time, and a single snapshot is easily distorted: a business that stocks up before a busy season, or runs stock down before a year-end count, looks different on that one day than across the period. Averaging opening and closing values smooths that swing, which is why the formula uses average inventory rather than the ending figure alone. Monthly balances are better still where available.

COGS comes from the income statement for the same period: the direct cost of the goods actually sold, not the price customers paid. Inventory is also recorded at cost, so COGS is its like-for-like partner: dividing it by price-based revenue mixes two measures, an error the mistakes section sizes up.

Days in period is the length of the window the COGS covers: 365 for a year, 90 for a quarter, 30 for a month. Nothing in the formula forces a year, and a quarterly DIO compares directly with an annual one because both are expressed in days.

DIO also travels under two other names: days sales of inventory (DSI) and days in inventory. All three describe the same calculation and result, so a benchmark quoted as DSI can be compared with your DIO directly, as long as the period and COGS basis match.

Worked example: a mid-size retailer's year

A retailer opened the year holding $240,000 of stock and closed it holding $260,000, with COGS of $1,825,000 across 365 days: the figures pre-filled in the calculator above.

The two routes agree, as they must: DIO and turnover are reciprocals scaled by the period length. A turnover of 7.30x means the retailer sold through its average stock just over seven times in the year, and 365 / 7.30 leaves 50 days per cycle.

The same method works for a shorter window. In one quarter, a smaller business opens with $28,000 of inventory and closes with $32,000, so average inventory is ($28,000 + $32,000) / 2 = $30,000. Quarterly COGS is $120,000 over 90 days: DIO = ($30,000 / $120,000) x 90 = 22.50 days, turnover = $120,000 / $30,000 = 4.00x, and COGS per day = $120,000 / 90 = $1,333.33.

What is a good DIO? Benchmarks by industry

There is no single good DIO. Stock dangerously slow for fresh food is normal for industrial spares, where a part may wait months for the machine it fits.

The chart, drawn by range midpoint, shows how far apart normal practice sits by sector.

Use these ranges two ways. First, compare your figure with your own sector: a DIO of 50 days sits inside e-commerce fulfilment and pharma distribution, above the FMCG range, and well below anything industrial. Second, compare it with your own past: a DIO creeping up quarter after quarter signals slowing sales, overbuying, or ageing stock. Lower is not automatically better: cutting stock until shelves empty loses sales. The target is the lowest DIO that still keeps the products people want in stock.

DIO and the cash conversion cycle

DIO is one third of the cash conversion cycle, which measures how long cash is tied up in operations before sales bring it back:

DIO is the days cash sits in stock. DSO, days sales outstanding, is the days customers take to pay after a sale. DPO, days payable outstanding, is the days the business takes to pay its suppliers, subtracted because supplier credit hands some of the waiting back. A retailer with DIO 50 days, DSO 20 days and DPO 35 days has a cycle of 35 days.

Each day of DIO ties up one day of COGS in cash. In the worked example, COGS per day is $5,000, so cutting DIO by 10 days frees about $50,000 of cash (10 x $5,000) without selling a single extra unit. Two close cousins complete the picture: the days of supply calculator asks how long current inventory lasts at the current rate of use, and the days of cash on hand calculator measures how long the money in the bank covers daily spending.

How to reduce days inventory outstanding

DIO falls when stock moves faster, or less of it is held for the same sales. Four standard levers do most of the work.

Forecast demand more carefully. Most excess stock is bought against a guess that proved too optimistic. Ordering against recent sales by product, adjusted for seasonality in your own records, removes that overbuying.

Order smaller amounts, more often. The same annual volume bought in monthly lots instead of quarterly lots lowers the average holding between deliveries, and DIO follows it down.

Clear aged stock deliberately. Slow lines do not fix themselves. Discounting, bundling or returning ageing stock converts it back into cash and stops the reorder habit that created it.

Shorten supplier lead times. Long lead times force large safety stocks: every order must cover weeks of uncertain demand. A supplier delivering in five days instead of fifteen lets you hold less cover for the same protection.

Every lever trades against service level, stated plainly: hold less stock and, sooner or later, a customer will ask for something that is not there. The honest goal is a deliberate balance: enough stock to serve demand reliably, and no more. Cutting DIO by starving bestsellers is not an improvement; cutting it by removing stock nobody buys is.

Common mistakes that wreck the DIO number

DIO is a simple formula, which means its errors are simple too. Four of them account for most wrong results.

Using revenue instead of COGS. Revenue is COGS plus gross margin, so swapping it in inflates turnover and shrinks DIO by exactly the margin. WarehouseOps documents the distortion: at a 30% gross margin, a business genuinely turning stock 3.5 times a year reports 5.0 turns when revenue is used, because 3.5 / 0.7 = 5.0. DIO looks a third healthier than it is, and decisions get made on the flattering number.

Using a year-end snapshot instead of an average. Ending inventory alone reflects one day, often a deliberately unusual one: stock run down before a count, or built up before a peak. An unusually low figure flatters DIO; an unusually high one alarms. Averaging beginning and ending values is the minimum correction, and monthly balances are better where records allow.

Mismatching the periods. Quarterly COGS against an annual day count, or a full year of COGS against one quarter's inventory, produces a number with no meaning. Inventory, COGS and days must all describe the same period: an easy error when figures come from different reports, and the first thing to check.

Averaging across unlike product classes. A single DIO for a business stocking both fresh food and hardware blends a 10 day cycle with a 120 day cycle into a figure describing neither. Calculate DIO by category where the mix is wide. On the cost side, the distribution cost calculator shows what holding and moving that stock costs, which decides how much a high DIO in one category actually matters.

This page changed: from distribution intervals to DIO

An honest note about this page's history. Until October 2026, this calculator measured something different: the average interval between distributions, worked out as the period divided by the number of distributions. Every established source, however, uses distribution days for days inventory outstanding, the metric this page now calculates, so the page was rebuilt to the standard meaning on 2026-10-21.

If you came looking for the payout or dispatch interval, the distribution frequency calculator is the right tool for how often distributions happen and the gaps between them.

What competing calculators miss

The calculators sharing this page's exact name, including BraveCalculator, CalculatorsHub and CalculatorGek, define distribution days correctly as DIO, but stop short in ways that matter.

They make you pre-average the inventory. Each takes average inventory as a single input, so the (beginning + ending) / 2 step, the one most likely to be skipped or done with a year-end snapshot, is left to you. This calculator averages beginning and ending inventory in the tool.

Two of them hard-code 365 days. A fixed year makes quarterly and monthly DIO impossible, and a quarterly figure forced through a 365 day formula is simply wrong. This calculator accepts any period length.

They return DIO and nothing else. None shows inventory turnover, though it is one division away, and none shows COGS per day, the figure that converts DIO into cash. This calculator returns all three outputs from the same inputs.

None of them benchmarks the result. A DIO of 50 days is good, bad or ordinary depending entirely on the sector, yet the rivals leave the number unjudged. The sourced benchmark table above is what turns a calculation into a decision.

Frequently Asked Questions

Add This Calculator to Your Website

References