What DIO measures
Days Inventory Outstanding (DIO), also called days inventory on hand, expresses your stock as a number of days of demand. Instead of asking "how many units do we hold?", it asks "how long would this stock last at the current rate of sale?"—which makes items with very different pack sizes and prices directly comparable.
The classic finance formula uses annual figures:
For day-to-day portfolio management, the same idea is applied per SKU using units and recent demand:
where average daily demand comes from a recent demand window (for example, the last 6 months of sales divided by the number of days in that window). An item holding 300 units with average daily demand of 2 units has 150 days of stock.
Why high DIO traps working capital
Every unit on the shelf is cash that has already been spent but not yet recovered through a sale. When days of stock climb far beyond what lead time and safety stock require, that cash sits idle: it cannot fund faster-moving lines, negotiate better supplier terms, or invest elsewhere in the business.
High DIO also compounds quietly. The longer stock sits, the more it costs to keep—and the higher the chance it never sells at full value. Reducing excess stock converts that trapped value back into available working capital without needing new sales.
Defining excess inventory thresholds
Excess is not an absolute number—it is stock beyond the cover you consider healthy for your business. A practical approach is to set two thresholds in days of cover:
| Band | Meaning | Typical action |
|---|---|---|
| Healthy | Days of stock at or below your green threshold (for example 90 days—about one quarter of cover). | No action; normal replenishment. |
| Excess | Above the green threshold but below the amber one (for example 90–180 days). | Pause reorders, run promotions, bundle or discount to burn down. |
| Severe excess | Above the amber threshold (for example over 180 days). | Escalate: aggressive clearance, returns to supplier, or write-down review. |
| No demand | Stock on hand with no recorded demand in the window. | Dead-stock candidate: liquidate, return, or dispose. |
Only the units above your healthy threshold count as excess. The value of that excess is simply:
The hidden costs of carrying dead stock
Excess stock costs more than its purchase price. Annual carrying cost is commonly estimated at 15–30% of inventory value, built up from:
- Storage: warehouse space, handling, insurance and utilities scale with the volume you hold.
- Depreciation and obsolescence: slow stock ages, goes out of date, gets damaged, or is overtaken by newer versions—often ending in write-downs.
- Opportunity cost: the return that same cash could have earned elsewhere is the largest and least visible component.
At a 20% carrying cost, every 100,000 of excess stock quietly costs about 20,000 per year to keep—before any write-down.
How the StockLogic tool applies this
The Excess Stock & DIO tool calculates days of stock per SKU from your stock-on-hand figures and the last 6 months of demand, then compares each item against your green and amber thresholds (defaults: 90 and 180 days). It values the excess at unit cost, estimates annual holding cost at your chosen carrying-cost percentage (default 20%), and can filter the analysis by ABC class or a minimum value threshold.
Everything runs locally in your browser on your CSV—up to 1,000 SKUs per upload—with no server uploads. For the wider calculation reference, see Methodology & Formulas.