Show me the money: an MRO inventory analysis

Mary Cenedese
Tags: inventory management, supply chain
You don’t have to be a genius to recognize that a lot of money is tied up in MRO inventory … especially if your business requires the use of capital-intensive equipment. Literally millions of dollars are tied up in spare parts for day-to-day plant maintenance, repair and operations.

Historically, no one ever really “owned” inventory, so stocking another item “just in case” had very few, if any, repercussions. Inventory was often seen as a necessary evil of doing business. The term “inventory management” was almost an oxymoron. There were few procedures for setting up an item, no standard structure or format. Item information was written in the manner of each individual … first onto cards, which were later transcribed into a computer system. More often than not, there were no stock review processes. The only management of inventory came with its annual physical count undertaken for financial reporting purposes.

Typically over time, stores inventory grew … and grew … and grew … to the point where the numbers were just too big to ignore. That’s when inventory gets the attention of management: when the numbers are just too large to ignore any longer. After all, that’s real money tied up in parts. Good money … paid out to suppliers … for maintenance workers’ peace of mind.

The ironic thing is that maintenance workers do not often have much confidence in stores inventory. They do not trust that parts are really there in the quantities stated, or that they are still usable. They might even keep a private cache of parts hidden somewhere for their own use. Or they might bypass stores altogether and just order the part directly from the supplier. These scenarios are real and they add further to costs.

When a formal inventory review is undertaken, it is often found that, unfortunately, many item descriptions are inadequate, with spelling errors or missing manufacturer names and/or part numbers. Often, the part descriptions are unrecognizable by a tradesperson.

Before any inventory analysis can take place, inventory item description data must first be cleansed. Any sort of benchmarking activity requires that you know your starting point (i.e. what you currently have on hand).

Once data has been cleansed, duplicate items are typically found ranging from 5 percent to 15 percent within a given site. The percentage of commonality of items across multi-site companies can range as high as 25 percent.

Inventory can then be sorted into typical commodity groups: bearings; industrial supplies; electrical; instrumentation; fluid power; and pipes, valves and fittings. Commodity groups can then be segmented into categories: required active, excess active and inactive.

Required active inventory includes commonly used parts that must be stocked.



Excess active inventory is the overstock of required active items (i.e too much of a good thing).

Inactive items can be further segmented into: critical spares, slow-moving and obsolete materials. Critical spares are items essential for the business to run. Stocking out would significantly impact production quality, safety or costs. Slow-moving inventory includes parts with long lead times, parts which might affect plant efficiency, “recommended spare parts” for a piece of equipment or “emotional” inventory (i.e. parts that are kept to satisfy risk aversion).

Optimization or rationalization of each inventory category is serious business and can return serious dollars.

It’s typical to find that required active inventory ranges from 25 to 30 percent. Excess active inventory ranges from 10 to 20 percent. And, inactive inventory ranges from 50 to 60 percent of inventory, of which critical spares represent 15 to 20 percent of inventory, slow-moving inventory represent 20 to 25 percent and obsolete items represent 15 percent of inventory.

The opportunity for savings predominantly comes through the elimination of duplicate items and the rationalization of excess active and slow-moving inventory. These items can be used down through attrition, sold back to the supplier for credit, or sold to a third party for cash. Obsolete items may also offer some opportunity for generating cash.

Let’s look at a case study example to illustrate typical findings when an MRO inventory analysis is performed.

A multi-site manufacturer with 11 locations decided to undertake a pilot inventory analysis project at only its four sites in Wisconsin. If the project created enough value, then it would be extended across the entire organization.

MRO data was cleansed consecutively for all four sites. Item descriptions were standardized into a noun/modifier format, using industry nomenclature. A corporate catalog was created, consolidating all items from the four sites.

Site by site, the cleansed data was first sorted for duplicate identification, then it was segmented by commodity group into categories and analyzed by usage and supplier.

The results were impressive enough to attract the remaining sites:
• Duplicate items represented approximately 9 percent of inventory. Item bins were consolidated. It was determined that the overstock would be used down through attrition.

• Approximately 20 percent of inventory items were found to be at excess stocking levels (excess active). They were returned to the supplier for credit, yielding cash savings of $1.1 million.

• Obsolete materials were identified and disposed of, generating $100,000 in cash.

• A long-term plan was designed to address slow-moving inventory items to determine the value/life of the part and its appropriate stocking level.

• And at the same time, the company decided to share highly valued spares within the regional area, further reducing stocking levels at all four locations.

With a return of more than $1.2 million, the pilot project was deemed a success and plans are currently under way to implement MRO inventory analyses at each of the remaining sites.

MRO inventory ties up a lot of money for capital-intensive, multi-site manufacturers. It takes a proper inventory analysis project to reveal the opportunities for transforming some of that inventory into cash. With a little effort, you too can turn your necessary evil into a corporate good.

About the author:
Mary Cenedese is the marketing and sales manager for Supply Chain Experts, an inventory management consulting group based in Tillsonburg, Ontario. For more information, visit www.imaltd.com or call 519-688-3805.


About the Author