Inventory Turnover and Days of Inventory (DIO): Turning the Number Into a Decision

Inventory turnover is cost of goods sold divided by average inventory, and days of inventory (DIO) is its inverse scaled to the period: average inventory divided by daily cost of goods sold. Both show one fact: how many days, on average, inventory capital stays in the warehouse. Unlike the cash conversion cycle, it measures only one component, which makes it a sharper diagnostic tool for inventory.

The problem with the total number is that it hides the mix. An overall DIO of 60 days may be built from items at 10 days and items at 300 days. Looking only at the average, you cannot see which items are holding capital hostage or which are thinly covered and exposed to stockouts. The first diagnostic step is breaking the number down by ABC class, product category, warehouse and inventory type (raw material, work in process, finished goods).

The comparison baseline matters a great deal. Comparing an organization's DIO with an industry average without normalizing for business model (make-to-order or make-to-stock), supply chain length and seasonality is misleading. The most valid comparisons are your own trend over time and comparisons between similar items inside your own range. Targets based on a 'competitor's number' without that normalization usually backfire.

A calculation point: do not take average inventory from just two points (start and end of the year). With seasonal patterns that average can be far from reality; monthly or weekly averages are much more accurate. Also measure against cost of goods sold, not revenue, so margin and pricing do not enter the metric and the number reflects only physical flow and inventory value.

To turn the number into a decision, split DIO conceptually into three parts: cycle stock (due to order size), safety stock (due to uncertainty) and excess or dead stock (more than needed). Only the third is pure waste and can be reduced without service risk. The first is controlled through order-size decisions, the second through safety stock policy and improvements in forecasting and lead time.

Finding dead stock starts with a simple rule: items with no consumption over a defined period (say 6 to 12 months, depending on the industry), or with coverage many times the supply horizon. Record a specific decision for each: discounted sale, return to supplier, alternative use, or accounting write-off. Without a decision, the dead-stock list is just a permanent report.

A common mistake is cutting inventory uniformly across the portfolio. That approach often creates shortages on sensitive items while real dead stock stays untouched. Another is measuring supply chain managers by DIO alone, which rewards cutting inventory at the expense of service level. DIO should be viewed together with OTIF or fill rate to keep the balance.

A practical starting point: compute DIO for each ABC class and product category, identify the top three items by capital tied up in dead stock, and obtain a written decision with owner and deadline for each by the next S&OP meeting. What distinguishes this from a general DIO report is that it ends in action, not another number on a dashboard.