This Week on SCDigest:
Inventory Performance 2010
Supply Chain Graphic of the Week and Supply Chain by the Numbers
New Cartoon Caption Contest Starts 7/13!
SCDigest On-Target e-Magazine
This Week on "Distribution Digest"
Trivia  Feedback

Become a Sponsor
SCDigest Home Page  
  Newsletter Archives July 16, 2010 - Supply Chain Digest Newsletter

Featured Sponsor: Seegrid Corporation

your people. your processes. your robots.


Videocast Series:

Making Retail Smarter

Part IV: Building Consumer Goods and Retail Supply Chains That Are Lean, Green, Efficient, and Sustainable

Featuring Christopher Moose, Partner - IBM Business Consulting Services

Register Now!



Fulfilling the Promise of Multi-Channel Commerce

Multi Channel Operations (MCO) + Multi Channel Integration (MCI) Enables Seamless Multi Channel Commerce Experience

Featuring Guneet Paintal, Principal, SCM Practice at Infosys Technologies Ltd.

Register Now!


Videocast Series: Retail Supply Chain Best Practices

Part 2: What Makes Best-in-Class Retail Supply Chains?


Includes SCDigest Letter on On-Demand Software and New Total Cost of Ownership Calculator



This Week's Supply Chain News Bites
  - Only from SCDigest

Supply Chain Graphic of the Week: The 2010 Supply Chain Priority List


This Week’s Supply Chain by the Numbers for July 16, 2010: McDondald's Smoothie Supply Chain Needs Smoothing; More Truck Congestion Coming; Ocean Cargo Rate Tsunami; Import Warehouses Busy Too


New Cartoon Caption Contest

Starting July 13th!

Join The Fun!

See Full-Sized Cartoon and

Send In Your Entry Today!



Vote for the Top Cartoon

in the First Half of 2010


$50.00 AMEX Gift Card to the Winner



Last Chance! Place Your Vote

Each Week:

Global Supply Chain
Trends and Issues

Distribution/Material Handling

Weekly On-Target Newsletter
July 15, 2010 Edition

Help Us Pick the Top Supply Chain Cartoon for the First Half of 2010!


HolsteHolste's Blog: DCs Facing New Customer Service Challenges

Top Story: Thinking Sortation for Distribution? What it will the Costs Be?
Top Story: Diagnosing the Savings from Labor Management Systems

Visit Distribution Digest



What epic legal battle did parcel giant UPS win in 1975?

Click to find the answer below
Inventory Performance 2009

I had been very much looking forward to the annual CFO maazine/REL working capital report for 2010, which was released last month. The report released in June analyzes 2009 numbers.

The report looks at overall Working Capital performance across a few dozen industry sectors and hundreds of companies. We focus on the inventory numbers, which they calculate using Days Inventory Outstanding (DIO), which is combined with payables and receivables data to come up with a total Working Capital number.

I was intrigued about what the inventory numbers would look like in the strange year that was 2009. The overall inventory to sales ratio spiked early on in the recession, as it always does, but then companies started cutting inventories like mad, reducing SKU counts, and anything they could do drive cash out of inventories.

Gilmore Says:

"One thing to keep in mind is that all of this is based on year end numbers, so it doesn't really tell you how well industries and companies were able to sense and respond to the drop in demand early on."

What do you say?

Send us
your Feedback here

The overall Working Capital numbers make it clear why there was an inventory reduction imperative. According to CFO, "2009 was one of the worst years ever for corporate working capital performance, and certainly the worst that CFO has reported since it began keeping track of working capital trends more than a decade ago."

Average days working capital (DWC) for 1,000 of the largest U.S. public companies jumped by 8.2% last year, the study found.

Working Capital is something of a strange term, as it sounds like a good thing. But it isn't as defined here. Working capital in this context means what could be cash that could be invested, paid out to shareholderrs, etc. is instead tied up in inventories and accounts receivable.

The study as always measures DIO as:

Inventory/[total revenue/365]

As such, it is sort of the reverse of inventory turns, in that a higher DIO, all things being equal, means poorer inventory management performance, while a lower number signals improvement.

The CFO report can be a bit confounding for supply chain watchers in that it often combines in the industry sectors very disparate companies, making the averages a little funny. As one example, in the Beverage sector, you have spirits Make Brown-Foreman with a 2009 DIO of 124 in the same grouping as Coca-Cola Bottling, with a DIO of 15.

Under Internet/Catalog retailing, travel web sites like Expedia, which has no inventory, are in the same mix with and the Home Shopping Network. Miners are mixed with steel producers, etc.

Oh well. Most sectors are not so confounded.

Below, is a list of the product-based sectors in the report, summarizing their DIO for the year and change from 2008 DIO levels:

  •  Aerospace and Defense:  48 (in 2009) from 49 in 2008
  •  Auto Parts and Components: 32 from 33
  •  Beverages: 25 from 23
  •  Biotech: 49 from 36
  •  Building Products: 41 from 40
  •  Chemicals: 53 from 50 
  •  Communications and Networkinf Equipment:  23 from 29
  •  Computers and Peripherals: 20 from 21
  •  Containers and Packaging: 42 from 43
  •  Electrical Equipment (e.g., Emerson Electric, AO Smith): 40 from 42
  •  Electrical Equipment, Instruments and Components (e.g., Corning, Avnet): 39 from 41
  •  Food and Staples Retailing (grocery and drug stores): 30 from 29
  •  Food Manufacturing: 40 from 44
  •  Healthcare Equipment and Supplies (e.g., Becton Dickenson, Stryker): 45, flat from 2008
  •  Household Durables (which unfortunately includes home builders as well as Whirlpool and others): 68 from 77
  •  Household Products (consumer package goods): 38 from 45
  •  Industrial Conglomerates (e.g., 3M, GE): 45 from 47
  •  Internet/Catalog Retail: 16 from 13
  •  Leisure Equipment, Toys (e.g., Mattel, Eastman Kodak): 37 from 39
  • Life Sciences (e.g., Bio-Rad, Thermo-Fisher Scientific): 40 from 39
  •  Machinery (e.g., Caterpillar, Illinois Tool Works): 54 from 57
  •  Metal and Mining: 70 from 57
  •  Multi-Line Retail (mass merchants and dept. stores): 56 from 58
  •  Office Electronics (a category of one – Xerox): 23 from 27
  •  Paper and Forest Products: 51 from 52
  •  Personal Products (e.g., Avon, Estee Lauder): 38 from 42
  •  Pharmaceuticals: 39 from 34
  •  Semiconductors and Equipment: 44 from 41
  •  Specialty Retail: Flat at 50
  •  Textiles, Apparel, Luxury Goods: 47 from 51
  •  Tobacco: 61 from 53
  •  Trading Companies and Distributors (e.g., Grainger, Kaman): 60 from 58

We also summarized the performance by sector from 2008 to 2009, from best to worst, as shown in the chart below (link to full size version of the chart below graphic. You can also find larger version on the web page link to this column below the Feedback button).

View Full Size Image (Click on it to Expand)

What does this all this mean? I am trying to figure that out myself. One thing to keep in mind is that all of this is based on year end numbers, so it doesn't really tell you how well industries and companies were able to sense and respond to the drop in demand early on - by year's end many had cut inventories ruthlessly.

The full CFO/REL report is available here:2010 working capital report.

We will do some additional analysis next week under the trends section of our On-Target newsletter. My quick reaction is that given the economic chaos, most companies and sectors performed pretty well, but would welcome your thoughts on this.

What's your reaction to the 2009 inventory numbers? Anything strike you? What further analysis needs done? Let us know your thoughts at the Feedback button below

Send an Email

Web Page/Printable Version of Column


Do you use an RSS reader? Do you have a MyYahoo! or personalized Google page?

For these and more you can have SCDigest delivered right to your personal pages, all week long.

You can subscribe to our RSS feeds in two ways:

  1. Copy our RSS link into your RSS reader - it's easy!

  2. Click on a button below to quickly add it to your favorite readers.

Feedback returns next week.



What epic legal battle did parcel giant UPS win in 1975?


Probably amazing to most today, in 1975 UPS finally won a 30-year legal battle with the US Post Office to offer delivery service in all 48 continental states.