ProcurementAlert.com » DIO: A more accurate way to measure efficiency

DIO: A more accurate way to measure efficiency

November 11, 2008 by Charlie Walker
Posted in: Procurement costs, Procurement trends, Purchasing decisions, Special Report, Supply chain efficiency


2008 has been a topsy-turvy ride for most U.S. businesses, which has made it increasingly difficult to gauge just how well you’re doing (or not doing).

Transportation and fuel surcharges went from through-the-roof back to ground level. Shipping rates are all over the map.

So, short of wetting a finger and putting it into the wind, how can you get an accurate measure of where you stand?

At least one new report is using a stat called Days Inventory Outstanding (DIO). (The metric is being championed by CFO magazine and REL, part of the Hackett Group.)

Many inventory operations measure progress by tracking the number of inventory turns in a given time. This is almost the opposite of that.

How it works: Take your company’s year-end inventory level, divide that by total revenue, then multiply that figure by 365. The result is how many days’ worth of sales your company, on average, holds in inventory.

Why is this measure taking on more significance?

It’s the growing emphasis on “supply chain finance,” and the overall role and impact inventory has on your company’s bottom line.

Suppose you do calculate your DIO. How do you compare with other businesses?

  • communications/network equipment: DIO down from 37 to 32 days (15%)
  • consumer packaged goods: DIO up from 40 to 42 (5%)
  • containers and packaging: DIO up 43 to 46 (6%)
  • department stores/mass merchants: DIO up from 62 to 64 (4%)
  • electronics: DIO down from 45 to 42 (8%)
  • food and drug retailing: DIO up from 27 to 29 (8%)
  • internet and catalog retail: DIO down from 20 to 19 (4%)
  • life sciences/medical devices: DIO down from 43 to 41 (4%)
  • metals industry: DIO down from 52 to 49 (5%)
  • pharmaceutical industry: DIO down from 45 to 41 (9%)
  • restaurants: DIO up from 5.5 to 5.8 (5%)
  • specialty retailers: DIO down from 54 to 52 (4%), and
  • wireless/cell phone industry: DIO down from 11 to 9 (16%)
  • Share/Bookmark

Tags: , , ,

3 Responses to “DIO: A more accurate way to measure efficiency”

  1. Mark Says:

    We use the same formula, but we value our inventory at cost, so instead of using yearly revenue we use our yearly cost of goods sold to get a true apples to apples look.

    Mark A. Fabiani
    Controller
    McDanel Advanced Ceramic Technologies

  2. David Brook Says:

    In the calculation of Days In Inventory

    the Inventory divided by Sales should be Multiplied by 365 not Divided by 365 to arrive at how many days in sales the inventory represents.
    (Reader was correct; formula has been corrected. Thanks, David!)

  3. inventory tracking devices | Digg hot tags Says:

    [...] Vote DIO: A more accurate way to measure efficiency [...]


advertisement


advertisement