Macro-Managing Your MRO Inventory

Either way, the end result is the same: inventory gets out of control over time and some difficult decisions have to be made. Often those decisions are made with no strategy or overarching goal other than cutting inventory as quickly as possible, and no real understanding of the impact they cause on production or reliability. The results actually can be counterproductive, leaving operations exposed to critical material shortages and significant production delays.

part2

Whether in steady state or crisis mode, trying to control inventory by micro-managing it at the item level is not the right approach. The need to support maintenance and operations has to be properly balanced with the responsibility to minimize the costs associated with carrying that investment. A top-down approach that starts by macro-managing your inventory produces a more integrated strategy that results in less total costs to the company.

The first question to answer is: “How much inventory do I have?” If you are in a position in the organization where the storeroom reports to, you should know. You are the steward of those resources and it’s your responsibility to manage them effectively. If you don’t know what you have, that responsibility will be difficult, if not impossible, to carry out.

The next question to answer is: “How much inventory should I have?” This is a tougher question to answer, but it’s much better to determine that target yourself than to be told by someone else who has no direct responsibility for the inventory on a day-to-day basis.

There are a couple of ways to estimate how much inventory you should have. The more preferred way is turnover, which is a ratio of dollars issued to dollars of inventory. Turnover directly relates your level of inventory to the level of demand for that inventory. Best-in-class targets for turnover in an MRO environment are between 2.0 to 3.0 turns per year.

Turnover is most effectively improved through better management of the storeroom investment, but most organizations will find that even modest improvements in the metric would require eliminating so much inventory that the results could be catastrophic!

Achieving or approaching best-in-class inventory benchmarks almost always requires a number of carefully developed strategies and tactics implemented concurrently over a significant period of time. To help determine which approaches will be most effective for your organization, it is helpful to start with the steps below:

1. Identify Obsolete Material

Almost every MRO storeroom has some parts that are for equipment no longer in service, have been redesigned, or are otherwise unusable. Any items found to be obsolete should be flagged in the system and physically segregated.

2. Identify Excess Inventory

Excess inventory is stock of usable materials that exceeds short-term anticipated requirements. For most items, the highest the inventory should ever go is the sum of the reorder point plus the reorder quantity. Excess is simply the amount of on hand inventory above that highest expected level.

3. Prioritize the Active Inventory

An ABC analysis will determine the items that have the greatest impact on service and investment, thereby identifying the ones that you should spend the most time on. Make sure to exclude anything identified as obsolete.

4. Establish a Baseline

A baseline profile uses the results of the above activities to depict a high-level view of the current state of your inventory. It shows the amount of investment tied up in obsolete and excess material. It also shows how inventory is distributed by activity level and how quickly materials are turning over at an aggregate level. Figure 1 is an example of a baseline profile taken from an actual case study.

Figure 1: Baseline inventory profile

Once you understand the makeup of your inventory, you can determine which tactics are most likely to reduce your inventory without adversely affecting service.

Start by eliminating any obsolete materials. They have no impact on service, but depending on your carrying costs, can be expensive to keep. You may need to lessen the impact on bottom-line plant results by establishing a monthly scrap budget and spreading the expense over a period of time, but determine the best way to dispose of it (scrap it, recycle it, sell it, donate it) and get rid of it as soon as possible so it’s out of your inventory.

Evaluate excess inventory, starting with the highest values first. Each item needs to be reviewed to determine the cause of the excess and the right course of action. For any item that is overstocked, specific action plans should be developed to scrap, sell, use up, or otherwise eliminate the excess inventory. As these plans are executed, the associated value of the excess material should come out of your inventory.

Next, review your stocking plans, starting with the “A” items that have the greatest investment. By definition, these items are more active and, therefore, can be managed more aggressively. Lowering the reorder point will reduce average inventory, but it also impacts service. Lowering the reorder quantity increases reorder frequency, but also reduces average inventory levels without impacting service. Making changes to stocking plans on “B” and “C” items will help as well, but generally have far less impact.

Look for items that don’t need to be in inventory at all. Materials for preventive maintenance (PM), such as lubricants and filters, should be identified on standard PM job plans and demand for these items can be predicted based on the frequency of the PM. Some material requirements can be anticipated based on predictive maintenance (PdM) technologies. Work on non-critical assets can be planned and scheduled and the materials ordered as needed.

Try to establish consignment or vendor stocking arrangements to get other items out of inventory, but still assure adequate supply. These arrangements significantly reduce the lead time and also increase turnover since they are issued through the storeroom, but don’t get reported in the inventory.

Look for potential free issue materials. These are typically low value/high volume items, such as fasteners, fittings and consumable materials where usage doesn’t need to be tracked. They are usually expensed at the time of purchase so the on hand balances don’t need to be maintained and, therefore, the value of the material does not show up in the storeroom investment.

With these plans in place, it should be possible to establish target inventory levels, which can be translated into revised turnover goals. The updated inventory profile in Figure 2 shows how the client in the case study estimated the impact of its inventory management activities.

Reducing the investment by almost 1/4 was only expected to improve turnover by about a third, but eliminating nearly $2.5 million of inventory would still be a significant achievement.

Figure 2: Estimated impact of inventory management activities

As the client reviewed individual items, progress was monitored each week, as shown in Figure 3.

Figure 3: Monitoring weekly progress

Within three months, the client was able to realize nearly its entire goal by prudently, yet aggressively, following the aforementioned steps. In fact, having achieved its initial target of $2.49 million, the client went on to identify an additional $1 million of material that it believed could be removed over the next 12 months.

By successfully macro-managing inventory, this client was able to meet – and exceed – its inventory reduction target, improve its turnover and significantly reduce its carrying costs with no appreciable impact on service.

Doug Wallace, CPIM, is a Senior Consultant and Materials Management Subject Matter Expert for Life Cycle Engineering (LCE). In addition to his materials management expertise, Doug is knowledgeable in planning and scheduling and operator care best practices. He is also certified in Prosci’s Change Management methodology. www.lce.com