Retail & CX metrics glossary
Days of inventory tells you how long your stock will last. Here is how to calculate it — and what it can't tell you.
Days inventory outstanding (DIO) — also called days sales of inventory (DSI) or simply days of inventory — measures how many days your current stock would last at the current pace of cost of sales. It answers the buyer's most practical question: if I stopped purchasing today, how long before the shelves go empty? A DIO of 60 means roughly two months of merchandise sitting in stores and warehouses, already paid for or committed.
DIO is the mirror image of inventory turnover: the same information expressed in days instead of times per year (DIO = 365 ÷ turnover). Finance teams read turnover; buyers and operators think in days, because days map directly onto lead times, replenishment cycles and open-to-buy decisions. Every day of inventory is working capital parked on a shelf — which is why DIO sits at the heart of the cash conversion cycle. This page covers the formula, a working calculator, honest benchmarks by segment, and the structural blind spot every inventory report shares.
DIO — Days of inventory (DSI)
DIO = (average inventory ÷ COGS) × 365
average inventory = typically (beginning + ending inventory) ÷ 2, valued at cost · COGS = annual cost of goods sold — the cost of the merchandise actually sold · 365 = days in the period; use 90 for a quarterly COGS figure
Days of inventory calculator
A fashion retailer holds an average inventory of $600,000 at cost and posts an annual COGS of $2.4 million. DIO = (600,000 ÷ 2,400,000) × 365 ≈ 91 days — about three months of stock. That is normal for apparel, alarming for grocery: the number only means something against the segment and against your own supplier lead times.
What is a good number of days of inventory?
Typical days vary enormously by category, driven by perishability, seasonality and supply-chain length. As a rough map from public industry aggregates:
| Grocery & supermarkets | 20–35 days |
|---|---|
| Pharmacy & drugstores | 30–60 days |
| Consumer electronics | 45–75 days |
| Fashion & apparel | 90–150 days |
| Furniture & home | 100–180 days |
Ranges compiled from public financial aggregates of listed retailers — treat as orientation, not targets; assortment depth, import lead times and seasonality move the number more than operational discipline alone.
DIO vs inventory turnover vs coverage: when to use each
DIO and inventory turnover are the same measurement in different units — DIO = 365 ÷ turnover, so a turnover of 6 is a DIO of about 61 days. Use turnover when comparing efficiency across years, banners or competitors (finance language); use DIO when making operating decisions, because days compare directly against supplier lead times and replenishment cycles. A 45-day DIO against a 60-day import lead time is an immediate red flag that no turnover ratio makes visible at a glance.
Coverage (days or weeks of supply) is the forward-looking cousin: instead of dividing by historical COGS, planners divide current stock by forecast demand, usually at SKU or store level. DIO tells you how heavy the past made you; coverage tells you whether next month is protected. Mature retail planning uses both — DIO on the executive dashboard for capital efficiency, coverage in the replenishment engine to decide what to buy this week.
How to reduce days of inventory without causing stockouts
Cutting inventory blindly trades carrying cost for lost sales, and lost sales are usually more expensive. The durable path starts with ABC analysis: the long tail of C items typically holds a disproportionate share of the days while producing little revenue — trim depth there first. Then align purchasing with sell-out rather than sell-in: buying to the supplier's calendar instead of the customer's demand is the single most common cause of bloated DIO.
Structural levers follow: shorten replenishment cycles (smaller, more frequent orders shrink the average stock a store needs), calculate safety stock from demand variability instead of guessing it, and enforce markdown discipline so aged merchandise leaves before it fossilizes into permanent days. Every one of these reduces average inventory — the numerator — without touching the sales pace that protects you from stockouts.
The blind spot: high days don't tell you why the product isn't selling
DIO is an aggregate of outcomes, and two very different failures produce the identical number. A product bought wrong — wrong style, wrong price point, wrong season — accumulates days because customers reject it. A perfectly good product that no salesperson ever offers on the floor accumulates the same days for the opposite reason: customers never got the chance to accept it. The inventory report cannot distinguish a buying mistake from a selling omission.
That distinction changes everything about the fix. The first case calls for markdowns and a better open-to-buy; the second calls for work on the sales conversation itself — what gets demonstrated, suggested and attached when a customer is standing in the store. Chains routinely discount merchandise that was never offered, paying margin to solve a problem the buying team didn't create. Before writing down slow stock, it is worth knowing whether the floor ever actually sold it.
The report shows the days. We show why the stock isn't moving.
Cognifyze captures the in-person sales interaction itself — with consent, without identifying any individual shopper — and reveals the half of DIO that no inventory system sees: which products are actually offered in the conversation, which are demonstrated, and which sit at 120 days simply because nobody on the floor ever mentions them. A census of interactions, not a guess from the stockroom.
In measured deployments, making the interaction visible moved same-store conversion from 51.5% to 79.5% (+28pp, p<0.001), with 383% ROI and payback in 1.4 months.
Find out which slow movers were never offered — book an executive diagnostic.
Related metrics and guides
Days of inventory — frequently asked questions
What is a good DIO for retail?
It depends almost entirely on the category: 20–35 days is healthy for grocery, while 90–150 days is normal for fashion and over 100 for furniture. Compare against your segment and, more importantly, against your own trend — a DIO drifting up quarter after quarter signals buying outpacing selling regardless of the absolute level.
What is the difference between DIO, DSI and days of inventory?
None — days inventory outstanding (DIO), days sales of inventory (DSI) and days of inventory are three names for the same metric: average inventory divided by COGS, multiplied by the days in the period. Finance texts prefer DIO or DSI; retail operators usually just say days or coverage.
How is DIO related to inventory turnover?
They are exact inverses: DIO = 365 ÷ inventory turnover, and turnover = 365 ÷ DIO. A turnover of 12 means about 30 days of inventory; a turnover of 4 means about 91 days. Improving one automatically improves the other — they are one lever, not two.
Should I use COGS or revenue in the DIO formula?
Use COGS. Inventory is carried at cost, so dividing by revenue mixes cost and retail valuations and understates your true days — the higher your margin, the bigger the distortion. If only revenue is available, the result is a rough proxy at best; keep the valuation consistent on both sides of the division.
Is a lower DIO always better?
No. Below a certain point, fewer days means stockouts, broken size runs and lost sales — and a lost sale usually costs more than a month of carrying cost. The goal is the minimum days that still protect service level given your lead times and demand variability, which is exactly what safety stock is calculated for.