Days Inventory Outstanding Calculator

It depends heavily on category. Grocery and convenience: 18 to 26 days. Health and beauty: 37 to 61 days. Consumer electronics: 37 to 61 days. Apparel: 61 to 91 days. Home improvement: 61 to 91 days. Furniture: 91 to 183 days. Jewelry and luxury: 122 to 365 days. Off-price and discount: 37 to 61 days. The Inventory Turnover Benchmarks page carries the full table by vertical, and the Inventory Turnover Benchmarks Guide (PDF) covers the tactics that move each one.

They are the same measurement in different units. DIO = 365 / Turnover. A 6x turnover = 61 days DIO. A 12x turnover = 30 days DIO. Same operational story. Operators typically prefer DIO because it maps directly onto reorder cadence and lead time. Finance often prefers turnover because it maps onto GMROI. Report whichever unit your audience thinks in. The Inventory Turnover Calculator is the ratio-first view of the same math.

DIO is expressed in days (DIO = 365 / turnover). Weeks of Supply is the same idea in weeks (WOS = 52 / turnover). A 60-day DIO = 8.6 weeks of supply. Weeks of Supply is the unit most retail buying teams plan in because open-to-buy calendars work in weeks. DIO is the unit finance and DC operations tend to prefer because it maps onto the cash conversion cycle and lead-time math.

Always COGS. Using net sales in the denominator shrinks DIO by the markup rate. A retailer with 50 percent gross margin who uses sales instead of COGS reports DIO roughly 50 percent lower than reality. Finance runs its own calculation, the numbers do not reconcile, and the meeting turns into a math argument. Both numerator and denominator must be at cost. If your ERP reports inventory at retail, apply the cost complement before running the calculation.

Cash Conversion Cycle (CCC) = DIO + DSO (Days Sales Outstanding) - DPO (Days Payable Outstanding). DIO is the piece operators actually control. DSO is largely a function of channel mix (retail has near-zero DSO because customers pay at checkout, wholesale has 30 to 60 day terms). DPO depends on supplier negotiation. For most retail businesses, shrinking DIO is the single most impactful lever on the cash conversion cycle, because it is both the largest bucket and the one most under operational control.

Yes, and this is the failure mode retailers underweight. Very low DIO often signals chronic stockouts on top sellers. Days look impressive in finance dashboards because inventory is artificially low, but lost sales hide in the COGS numerator because sales that never happened never generate cost of goods. Always pair DIO with in-stock percent, sell-through and service level metrics. A 15-day DIO with 4 percent stockouts on A items is worse than a 25-day DIO with 0.5 percent stockouts. Size service levels through the Safety Stock Calculator rather than by intuition.

Average inventory for a SKU on an EOQ policy is roughly EOQ / 2. Smaller EOQ, lower DIO. Larger EOQ, higher DIO. This is the most mechanical lever available for moving DIO on purpose. When category-level DIO is above the benchmark and the drivers are structural (order cost too high, holding cost understated), the fix is smaller EOQ. But cutting EOQ alone without revisiting service levels creates more stockout windows, so the two decisions have to move together.

It scales linearly with COGS. Working capital released = (DIO reduction / 365) × COGS. On $730,000 of COGS, shrinking DIO by 10 days releases (10 / 365) × 730,000 = $20,000. On $10 million of COGS, the same 10-day improvement releases $273,972. On $100 million of COGS it releases $2.74 million. This is why finance teams at larger retailers push DIO harder than smaller ones. This calculator returns the exact number in the "Cash Freed if DIO Improves by 10 Days" secondary output.

SKU rationalization. Most assortments carry a long tail of C-class items consuming warehouse cash without contributing meaningful sales. Run ABC classification, prune the bottom decile aggressively, and DIO usually shrinks within one full replenishment cycle. The second-fastest lever is right-sizing safety stock through service-level math instead of flat weeks-of-supply rules. Both approaches are covered in more depth in the Inventory Management Best Practices guide.

Monthly, on a rolling 12-month basis to control for seasonality. Point-in-time DIO computed from quarter-end balances is often misleading in seasonal categories because the ending balance may be inflated (pre-holiday build) or depleted (post-holiday clearance). Rolling 12 or monthly-average denominators produce a number that reflects operating reality rather than accounting-cutoff noise. Category leaders should see a rolling-12 DIO number in the weekly review pack alongside in-stock percent and turn.