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.

ABC classes

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.

  1. Average monthly demand = 3,600 ÷ 6 = 600 units; daily demand = 600 ÷ 30 = 20 units.
  2. DIO = 3,000 ÷ 20 = 150 days → between 90 and 180, so the status is Excess (not yet Severe excess).
  3. Healthy stock = 20 × 90 = 1,800 units.
  4. Excess Qty = 3,000 − 1,800 = 1,200 units.
  5. 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.