Bottom Line Strategies for Spare Parts Planning

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

Bottom Line strategies for Spare Parts Planning Causes

Intermittent Demand

Bottom Line strategies for Spare Parts Planning 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.

Bottom Line strategies for Spare Parts Planning 4

 

Normal Demand

Bottom Line strategies for Spare Parts Planning Intermittent 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.)

Bottom Line strategies for Spare Parts Planning 5

Don’t rely on averages

Bottom Line strategies for Spare Parts Planning 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.

Bottom Line strategies for Spare Parts Planning Multiple Averages

 

Do use Service Level tradeoff curves to compute safety stock

Bottom Line strategies for Spare Parts Planning Service Level

Standard Normal Probabilities

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

Bottom Line strategies for Spare Parts Planning Standard Probabilities

 

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.

Bottom Line strategies for Spare Parts Planning Predict Distribution

 

How does Bootstrapping Work?

24 Months of Historical Demand Data.

Bottom Line strategies for Spare Parts Planning Bootstrapping 1

Bootstrap Scenarios for a 3-month Lead Time.

Bottom Line strategies for Spare Parts Planning Bootstrapping 2

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

Set Target Service Levels According to Order Frequency

 

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.

Recalibrate Reorder Points Frequently

Do Plan Rotables (Repair Parts) Differently

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.

 

Spare Parts Planning Software solutions

Smart IP&O’s service parts forecasting software uses a unique empirical probabilistic forecasting approach that is engineered for intermittent demand. For consumable spare parts, our patented and APICS award winning method rapidly generates tens of thousands of demand scenarios without relying on the assumptions about the nature of demand distributions implicit in traditional forecasting methods. The result is highly accurate estimates of safety stock, reorder points, and service levels, which leads to higher service levels and lower inventory costs. For repairable spare parts, Smart’s Repair and Return Module accurately simulates the processes of part breakdown and repair. It predicts downtime, service levels, and inventory costs associated with the current rotating spare parts pool. Planners will know how many spares to stock to achieve short- and long-term service level requirements and, in operational settings, whether to wait for repairs to be completed and returned to service or to purchase additional service spares from suppliers, avoiding unnecessary buying and equipment downtime.

Contact us to learn more how this functionality has helped our customers in the MRO, Field Service, Utility, Mining, and Public Transportation sectors to optimize their inventory. You can also download the Whitepaper here.

 

 

White Paper: What you Need to know about Forecasting and Planning Service Parts

 

This paper describes Smart Software’s patented methodology for forecasting demand, safety stocks, and reorder points on items such as service parts and components with intermittent demand, and provides several examples of customer success.

 

    Scenario-based Forecasting vs. Equations

    Why Scenario-based planning helps planners better manage risk and create better outcomes.

    If you are reading this, you are probably a supply chain professional with responsibilities for demand forecasting, inventory management or both. If you live in the 21st century, you use software of some kind to help you do your job. But what, fundamentally, does your software do for you?

    Traditionally, software has served as a delivery vehicle for equations. Even if you decided early on in life that you and equations don’t get along, they can still do something for you, and you can live with them—provided some software keeps all that math at a safe distance away.

    This is fine, as far as it goes. But we at Smart Software think you would do better by trading in your equations for scenarios. Most often, the point of an equation is to give “the answer”, typically in the form of a number, as in “next month’s demand for SKUxxx will be 105 units.” Results like these are helpful, but incomplete.

    Forecasting can be thought of as a computing problem, but it is more helpful to think of it as an exercise in risk management. The equation’s forecast of 105 units does not include any indication of the uncertainty in the forecast, though there is always some. It does not help you think about plausible contingencies: what if demand is for more than 105 units? What if it’s for fewer than 105? Could it get as high as 130 or as low as 80? Is 80 even remotely likely?

    This is where scenario-based analysis shows its advantage. One definition of “scenario” is “a postulated sequence of events.” Our definition is more extensive: a scenario is “a postulated sequence of events and their associated probabilities of happening.” Scenarios are the ultimate what-if planning tool. Forecasting by equation will predict a demand for 105 units. Scenario forecasting produces a bundle of possible demand figures, some more likely and others less so. If there are few or no scenarios as low as 80, you can let that contingency go.

    Plus-or-Minus How Much?

    Those who are better versed in equation-based forecasting might protest that equation-based software sometimes provides indications of the “plus or minus” of a forecast, complete with a bell-shaped curve indicating the relative likelihood of various contingencies. However, when you see a perfect bell-shaped distribution, you know you are being asked to rely on a theoretical assumption that is only sometimes valid.

    Scenario forecasts do not rely on that assumption.  In fact, they need not rely on any pre-conceived mathematical assumption whose main selling point is that it simplifies analysis. You don’t need a simplified analysis–you need a realistic analysis based on facts.

    Cutting-edge software produces scenario forecasts, not just for demand planning but also for inventory management. Demand is a key input to inventory software, along with supplier behavior as reflected in replenishment lead times. Both demand and supply need to be forecasted if you want to see the consequences of, for instance, choosing a reorder point of 15 and an order quantity of 25.

    Inventory systems are what is called “path sensitive”, meaning that any particular sequence of demand values will yield different performance than the same demand values in a different order. For example, if all your highest demand periods come bunched up, one after another, you’ll have much more difficulty keeping stocked than if the same high demand periods are spaced apart with time to restock in between. Scenarios reflect these differences in sufficient detail to yield average performance metrics reflective of the various contingencies inherent in uncertain demand.

    Figure 1 illustrates the difference between an equation-based forecast and forecast scenarios.  The green cells hold 10 months of demand for a spare part. The blue cells hold an equation-based forecast that calls for average demand of 1.5 units in months 11, 12 and 13. The pistachio-colored cells hold eight scenario forecasts, though in practice our software would generate tens of thousands of scenarios. Now, the scenarios also average out to 1.5 units per month, but they go further and display the wide variety of ways that the next three months could play out. For instance, reading vertically, the monthly demand could range from 0 to 3. Reading horizontally, the three-month totals could range from 0 to 6, compared to the equation-based estimate of 4.5. Continuing with this toy example, if you have 5 units on hand and the replenishment lead time is greater than 3 months, the equation-based model says you will be ok over the next 3 months, but the scenario-based results say you have 1 chance in 8 (12.5%) chance of stocking out. Equivalently, you have an 87.5% service level. If the part is critical and you are aiming for a 95% service level, you are at risk of missing your item availability goal.

    Scenario based Forecasting vs Equations hd2

    Figure 1: Comparing equation-based and scenario-based forecasts

     

    Summary

    Remember, equation-based forecasting gives you information, but shallow information. Scenario-based forecasting can tell you not just what result is most likely but also how reliable any of a variety of predictions are—and this allows you to bring your judgment to bear on balancing risk and stocking expenses—all automated to scale to a vast catalog of items.