Managing spare parts presents numerous challenges, such as unexpected breakdowns, changing schedules, and inconsistent demand patterns. Traditional forecasting methods and manual approaches are ineffective in dealing with these complexities. To overcome these challenges, this blog outlines key strategies that prioritize service levels, utilize probabilistic methods to calculate reorder points, regularly adjust stocking policies, and implement a dedicated planning process to avoid excessive inventory. Explore these strategies to optimize spare parts inventory and improve operational efficiency.

Bottom Line Upfront

​1.Inventory Management is Risk Management.

2.Can’t manage risk well or at scale with subjective planning – Need to know service vs. cost.

3.It’s not supply & demand variability that are the problem – it’s how you handle it.

4.Spare parts have intermittent demand so traditional methods don’t work.

5.Rule of thumb approaches don’t account for demand variability and misallocate stock.

6.Use Service Level Driven Planning  (service vs. cost tradeoffs) to drive stock decisions.

7.Probabilistic approaches such as bootstrapping yield accurate estimates of reorder points.

8.Classify parts and assign service level targets by class.

9.Recalibrate often – thousands of parts have old, stale reorder points.

10.Repairable parts require special treatment.

Do Focus on the Real Root Causes

Intermittent Demand

• Slow moving, irregular or sporadic with a large percentage of zero values.
• Non-zero values are mixed in randomly – spikes are large and varied.
• Isn’t bell shaped (demand is not Normally distributed around the average.)
• At least 70% of a typical Utility’s parts are intermittently demanded.

Normal Demand

• Very few periods of zero demand (exception is seasonal parts.)
• Often exhibits trend, seasonal, or cyclical patterns.
• Lower levels of demand variability.
• Is bell-shaped (demand is Normally distributed around the average.)

Don’t rely on averages

• OK for determining typical usage over longer periods of time.
• Often forecasts more “accurately” than some advanced methods.
• But…insufficient for determining what to stock.

Don’t Buffer with Multiples of Averages

Example:  Two equally important parts so let’s treat them the same.
We’ll order more  when On Hand Inventory ≤ 2 x Avg Lead Time Demand.

Do use Service Level tradeoff curves to compute safety stock

Standard Normal Probabilities

OK for normal demand. Doesn’t work with intermittent demand!

Don’t use Normal (Bell Shaped) Distributions

• You’ll get the tradeoff curve wrong:

– e.g., You’ll target 95% but achieve 85%.

– e.g., You’ll target 99% but achieve 91%.

• This is a huge miss with costly implications:

– You’ll stock out more often than expected.

– You’ll start to add subjective buffers to compensate and then overstock.

– Lack of trust/second-guessing of outputs paralyzes planning.

Why Traditional Methods Fail on Intermittent Demand: 

Traditional Methods are not designed to address core issues in spare parts management.

Need: Probability distribution (not bell-shaped) of demand over variable lead time.

• Get: Prediction of average demand in each month, not a total over lead time.
• Get: Bolted-on model of variability, usually the Normal model, usually wrong.

Need: Exposure of tradeoffs between item availability and cost of inventory.

• Get: None of this; instead, get a lot of inconsistent, ad-hoc decisions.

Do use Statistical Bootstrapping to Predict the Distribution:

Then exploit the distribution to optimize stocking policies.

How does Bootstrapping Work?

24 Months of Historical Demand Data.

Bootstrap Scenarios for a 3-month Lead Time.

Bootstrapping Hits the Service Level Target with nearly 100% Accuracy!

• National Warehousing Operation.

Task: Forecast inventory stocking levels for 12,000 intermittently demanded SKUs at 95% & 99% service levels

Results:

At 95% service level, 95.23% did not stock out.

At 99% service level, 98.66% did not stock out.

This means you can rely on output to set expectations and confidently make targeted stock adjustments that lower inventory and increase service.

Set Target Service Levels According to Order Frequency & Size

Recalibrate Reorder Points Frequently

• Static ROPs cause excess and shortages.
• As lead time increases, so should the ROP and vice versa.
• As usage decreases, so should the ROP and vice versa.
• Longer you wait to recalibrate, the greater the imbalance.
• Mountains of parts ordered too soon or too late.
• Wastes buyers’ time placing the wrong orders.
• Breeds distrust in systems and forces data silos.

Do Plan Rotables (Repair Parts) Differently

Summary

1.Inventory Management is Risk Management.

2.Can’t manage risk well or at scale with subjective planning – Need to know service vs. cost.

3.It’s not supply & demand variability that are the problem – it’s how you handle it.

4.Spare parts have intermittent demand so traditional methods don’t work.

5.Rule of thumb approaches don’t account demand variability and misallocate stock.

6.Use Service Level Driven Planning  (service vs. cost tradeoffs) to drive stock decisions.

7.Probabilistic approaches such as bootstrapping yield accurate estimates of reorder points.

8.Classify parts and assign service level targets by class.

9.Recalibrate often – thousands of parts have old, stale reorder points.

10.Repairable parts require special treatment.

We often are asked, “Why is the software driving up the inventory?” The answer is that Smart isn’t driving it in either direction – the inputs are driving it, and those inputs are controlled by the users (or admins). Here are four things you can do to get the results you expect.

1. Confirm that your service level targets are commensurate with what you want for that item or group of items. Setting very high targets (95% or more) will likely drive inventory up if you have been coasting along at a lower level and are OK with being there. It’s possible you’ve never achieved the new higher service level but customers have not complained.  Figure out what service level has worked by evaluating historical reports on performance and set your targets accordingly. But keep in mind that competitors may beat you on item availability if you keep using your father’s service level targets.

2. Make sure your understanding of “service level” aligns with the software system’s definition. You may be measuring performance based on how often you ship within one week from receipt of the customer order, whereas the software is targeting reorder points based on your ability to ship right away, not within a week. Clearly the latter will require more inventory to hit the same “service level.” For instance, a 75% same-day service level may correspond to a 90% same-week service level. In this case, you are really comparing apples to oranges. If this is the reason for the excess stock, then determine what “same day” service level is needed to get you to your desired “same week” service level and enter that into the software. Using the less-stringent same-day target will drop the inventory, sometimes very significantly.

3. Evaluate the lead time inputs. We’ve seen instances in which lead times had been inflated to trick old software into producing desired results. Modern software tracks suppliers’ performance by recording their actual lead times over multiple orders, then it takes account of lead time variability in its simulations of daily operations. Watch out if your lead times are fixed at one value that was decided on in the distant past and isn’t current.

4. Check your demand signal. You have lots of historical transactions in your ERP system that can be used in many ways to determine the demand history. If you are using signals such as transfers, or you are not excluding returns, then you may be overstating demand. Spend a little time on defining “demand” in the way that makes most sense for your situation.

Every organization that runs equipment needs spare parts. All of them must cope with issues that are generic no matter what their business. Some of the problems, however, are industry specific. This post discusses one universal problem that manifested in a nuclear plant and one that is especially acute for any electric utility.

The Universal Problem of Data Quality

We often post about the benefits of converting parts usage data into smart inventory management decisions. Advanced probability modeling supports generation of realistic demand scenarios that feed into detailed Monte Carlo simulations that expose the consequences of decisions such as choices of Min and Max governing the replenishment of spares.

However, all that new and shiny analytical tech requires quality data as fuel for the analysis. For some public utilities of all kinds, record keeping is not a strong suit, so the raw material going into analysis can be corrupted and misleading. We recently chanced upon documentation of a stark example of this problem at a nuclear power plant (see Scala, ­­­­­­­Needy and Rajgopal: Decision making and tradeoffs in the management of spare parts inventory at utilities. American Association of Engineering Management, 30th ASEM National Conference, Springfield, MO. October 2009). Scala et al. documented the usage history of a critical part whose absence would result in either a facility de-rate or a shutdown. The plant’s usage record for that part spanned more than eight years of data. During that time, the official usage history reported nine events in which positive demand occurred with sizes ranging from one to six units each. There were also five events marked by negative demands (i.e., returns to warehouse) ranging from one to three units each. Careful sleuthing discovered that the true usage occurred in just two events, both with demand of two units. Obviously, calculating the best Min/Max values for this item requires accurate demand data.

The Special Problem of Health and Safety

In the context of “regular” businesses, shortages of spare parts can damage both current revenue and future revenue (related to reputation as a reliable supplier). For an electric utility, however, Scala et al. noted a much greater level of consequence attached to stockouts of spare parts. These include not only a heightened financial and reputational risk but also risks to health and safety: “Ramifications of not having a part in stock include the possibility of having to reduce output or quite possibly, even a plant shut down. From a more long-term perspective, doing so might interrupt the critical service of power to residential, commercial, and/or industrial customers, while damaging the company’s reputation, reliability, and profitability. An electric utility makes and sells only one product: electricity. Losing the ability to sell electricity can be seriously damaging to the company’s bottom line as well its long-term viability.”

All the more reason for electric utilities to be leaders rather than laggards in the deployment of the most advanced probability models for demand forecasting and inventory optimization.

The best inventory planning processes rely on statistical analysis to uncover relevant facts about the data. For instance:

1. The range of demand values and supplier lead times to expect.
2. The most likely values of item demand and supplier lead time.
3. The full probability distributions of item demand and supplier lead time.

If you reach the third level, you have the facts required to answer important operational questions, additional questions such as:

1. Exactly how much extra stock is needed to improve service levels by 5%?
2. What will happen to on-time-delivery if inventory is reduced by 5%?
3. Will either of the above changes generate a positive financial return?
4. More generally, what service level target and associated inventory level is most profitable?

When you have the facts and add your business knowledge, you can make more informed stocking decisions that will generate significant returns. You’ll also set proper expectations with internal and external stakeholders, ensuring there are fewer unwelcome surprises.

When managing service parts, you don’t know what will break and when because part failures are random and sudden. As a result, demand patterns are most often extremely intermittent and lack significant trend or seasonal structure. The number of part-by-location combinations is often in the hundreds of thousands, so it’s not feasible to manually review demand for individual parts. Nevertheless, it is much more straightforward to implement a planning and forecasting system to support spare parts planning than you might think.

This conclusion is informed by hundreds of software implementations we’ve directed over the years. Customers managing spare parts and service parts (the latter for internal consumption/MRO), and to a lesser degree aftermarket parts (for resale to installed bases), have consistently implemented our parts planning software faster than their peers in manufacturing and distribution.

The primary reason is the role in manufacturing and distribution of business knowledge about what might happen in the future. In a traditional B2B manufacturing and distribution environment, there are customers and sales and marketing teams selling to those customers. There are sales goals, revenue expectations, and budgets. This means there is a lot of business knowledge about what will be purchased, what will be promoted, whose opinions need to be accounted for. A complex planning loop is required. In contrast, when managing spare parts, you have a maintenance team that fixes equipment when it breaks. Though there are often maintenance schedules for guidance, what is needed beyond a standard list of consumable parts is often unknown until a maintenance person is on-site. In other words, there just isn’t the same sort of business knowledge available to parts planners when making stocking decisions.

Yes, that is a disadvantage, but it also has an upside: there is no need to produce a period-by-period consensus demand forecast with all the work that requires. When planning spare parts, you can usually skip many steps required for a typical manufacturer, distributor, or retailer. These skippable steps include:  

1. Building forecasts at different levels of the business, such as product family or region.
2. Sharing the demand forecast with sales, marketing, and customers.
3. Reviewing forecast overrides from sales, marketing, and customers.
4. Agreeing on a consensus forecast that combines statistics and business knowledge.
5. Measuring “forecast value add” to determine if overrides make the forecast more accurate.
6. Adjusting the demand forecast for known future promotions.
7. Accounting for cannibalization (i.e., if I sell more of product A, I’ll sell less of product B).

Freed from a consensus-building process, spare parts planners and inventory managers can rely directly on their software to predict usage and the required stocking policies. If they have access to a field-proven solution that addresses intermittent demand, they can quickly “go live” with more accurate demand forecasts and estimates of reorder points, safety stocks, and order suggestions.  Their attention can be focused on getting accurate usage and supplier lead time data. The “political” part of the job can be limited to obtaining organization consensus on service level targets and inventory budgets.

​