Spare parts forecasting accuracy is driven by the validity of the premise and the data that is used in the analysis, not the sophistication of the modeling
Making predictions is hard, especially if they are about the future!
This is a variant of a quote that is attributed to the physicist Niels Bohr, baseball manager ‘Yogi” Berra, writer Mark Twain, and various others. While the origin of this quote may be in dispute, surely the issue that it raises is not. What happened in the past is not necessarily an indicator of the future (now I sound like a financial services ad!)
In the world of spare parts management, spare parts forecasting is often like a game of Whack-a-mole. For those that don’t know (or don’t care to admit they remember), Whack-a-mole was an arcade game, developed in the 1970’s, where a mole would pop up through one of several holes and the object was to ‘whack’ the mole with a hammer. Promoting cruelty to animals? Perhaps. Unnecessarily violent? Sure. A model of the way that many companies seem to approach spare parts inventory management? Absolutely!
Think of the mole as demand for a spare part and the player like the hapless storekeeper. In this context the game is an analogy where demand (the mole) is unpredictable and all the storekeeper can do is react to what comes up next. Sound familiar?
The problem, of course, is that essentially all spare parts inventory stocking problems are really spare parts forecasting problems. This is because the very essence of spare parts inventory management is determining the most appropriate level of inventory to hold, to service the expected future demand for that inventory, based on the expected supply constraints. Thus, all inventory management requires a forecast of both demand AND supply in order to establish the buffer that needs to be held to match these two factors.
When most demand is based on (apparently) random failure events, as with MRO and spare parts, then demand, almost by definition, is impossible to forecast. A bit like that little mole sticking its head out of the hole. So, how do you make spare parts forecasting work?
Spare Parts Forecasting
All spare parts forecasting methods can be grouped into one of two classes: either, extrapolation of historical data or causal and predictive models
Extrapolation of historical data is a fancy way of saying that you take whatever happens in the past and assume that it will happen again in the future. The approach for doing this can vary from the simplistic to the highly sophisticated but importantly all historical data methods are based on the premise that the future can be predicted by looking at the past. Something that we know to rarely be true.
The methods employed are typically quantitative and because of this they can appear to be rigorous. However, the accuracy achieved is driven by both the validity of the fundamental premise, that is, can the future of that part be predicted by looking at the past, and the quality of the data that is used in the analysis, not the sophistication of the modelling.
On the other hand, causal or predictive methods can be either quantitative or qualitative.
A quantitative approach might rely on forecasts of future planned activities (such as planned maintenance) and the expected usage of the part in each activity.
A qualitative approach might rely on the opinions of people involved in using and procuring the parts. For example, let’s say that a maintenance team member wants to have a spare part stocked and the decision on how many to stock is based on their opinion of how many to stock. This is a qualitative predictive method and is not an appropriate way to determine stock levels. Unfortunately, the natural conservatism of maintenance personnel typically results in significant overstocking.
It is this aspect of causal or predictive methods that often makes people think that all such approaches are less accurate than historic data driven approaches. However, this is not the case because, with spare parts inventory, causal approaches and the use of forward-looking information is more appropriate for deciding future inventory holdings than relying on the extrapolation of history. The key is to ensure that the basis of decision making is more robust and consensus-driven than just ‘today’s opinion’.
Which Spare Parts Forecasting Method to Use?
The choice of which forecasting method to use should be determined by the situation and the information the forecaster can access.
— The rest of this article is only visible to logged-in members —
SparePartsKnowHow.com members can also download a white paper on spare parts forecasting at the Operations section of the Resource Library.
Ready to achieve more?Follow these 3 steps
Full public access to this article expires on June 27th.