Excess Stock & DIO — Multi-SKU, from CSV
DIO is stock on hand divided by average daily demand from the last 6 months. Set your healthy stock cover in days, run the analysis, and see which items sit above it and how much cash that excess represents.
Calculated locally in your browser. No server uploads.
Read the DIO & excess stock guide
Analysis parameters
Days of stock on hand per item: up to green is Healthy. Anything above green counts as excess stock and is labelled Excess; above amber it is Severe excess (red). Stock with no demand at all is shown as No demand. Defaults: 90 days (one quarter of cover) and 180 days.
Methodology & Guide
How DIO and excess inventory value are calculated, with a worked example.
Formula breakdown
Days inventory outstanding:
DIO = Stock Qty ÷ ( Avg Monthly Demand ÷ 30 )
Excess beyond the healthy (green) days of cover:
Excess Qty = max( 0 , Stock Qty − Daily Demand × Green Days ) Excess Value = Excess Qty × Unit Cost
Status (default thresholds 90 / 180 days):
Healthy: DIO ≤ 90 Excess: DIO ≤ 180 Severe excess: DIO > 180
- DIO
- Days of inventory outstanding: how many days today's stock lasts at the recent sales rate.
- Avg Monthly Demand
- Last 6 months of sales from the Operations CSV ÷ 6.
- Green Days
- Your healthy stock-cover limit (default 90 days).
- Excess Qty
- Units above the healthy level; shortfalls count as 0, never negative.
Worked example: a slow-moving packaging item
An item has 3,000 units on hand, sold 3,600 units in the last 6 months and costs 8.00 per unit. Thresholds are the defaults: 90 days healthy, 180 days before excess becomes severe.
- Average monthly demand = 3,600 ÷ 6 = 600 units; daily demand = 600 ÷ 30 = 20 units.
- DIO = 3,000 ÷ 20 = 150 days → between 90 and 180, so the status is Excess (not yet Severe excess).
- Healthy stock = 20 × 90 = 1,800 units.
- Excess Qty = 3,000 − 1,800 = 1,200 units.
- Excess Value = 1,200 × 8.00 = 9,600.
9,600 of cash is tied up above the healthy level. Pausing replenishment for about two months (1,200 ÷ 20 = 60 days) would bring it back to Healthy.
Quick FAQs
What is a good DIO for inventory?
It depends on the business: fast-moving consumer goods often run 30–60 days, spare parts and industrial supplies much longer. The 90 / 180-day defaults are a starting point — set the thresholds to the stock cover you actually plan for.
Why does an item show 'No demand'?
It has stock but no sales in the last 6 months, so days of cover cannot be calculated. DIO is reported as 0 instead of infinity, and all of its stock counts as excess because there is no demand to cover.
Can a shortage on one item offset excess on another?
No. Items below the healthy level count as 0 excess rather than a negative number, so a stockout never hides real surplus elsewhere and total excess value is not understated.
Full derivations, data safeguards and the privacy architecture are on the Methodology & Formulas page.