What’s the difference, and why it matters for inventory planning.

Those new to the parts planning game are often confused by the many variations in the names of parts. This blog points out distinctions that do or do not have operational significance for someone managing a fleet of spare parts and how those differences impact inventory planning.

For instance, what is the difference between “spare” parts and “replacement” parts? In this case, the difference is their source. A spare part would be purchased from the equipment’s manufacturer, whereas a replacement part would be purchased from a different company. For someone managing a fleet of spares, the difference would be two different entries in their parts database: the source would be different, and the unit price would probably be different. It is possible that there would also be a difference in the useful life of the parts from the two sources. The “OEM” parts might be more durable than the cheaper “aftermarket” parts. (Now we have four different terms describing these parts.) These distinctions would be salient for optimizing an inventory of spares. Software that computes optimal reorder points and order quantities would arrive at different answers for parts with different unit costs and different rates of replacement.

Perhaps the largest distinction is between “consumable” and “repairable” or “rotable” parts. The key distinction between them is their cost. It is foolish to try to repair a stripped screw; just throw it out and use another one. But it is also foolish to throw out a $50,000 component if it can be repaired for $5,000. Optimizing the management of inventory for fleets of each type of part requires very different math. With consumables, the parts can be regarded as anonymous and interchangeable. With “rotatables”, each part must essentially be modeled individually. We treat each as cycling through states of “operational,” “under repair,” and “standby/spare.” Decisions about repairable parts are often handled by a capital budgeting process, and the salient analytical question is, “what should be the size of our spares pool?”

There are other distinctions that can be drawn among parts. Criticality is an important attribute. The consequences of part failure can range from “we can take our time to get a replacement” to “this is an emergency; get those machines back in action pronto”. When working out how to manage parts, we must always strike a balance between the benefits of having a larger stock of parts and the dollar costs. Criticality shifts the balance toward playing it safe with larger inventories. In turn, this dictates higher planning targets for part availability metrics such as service levels and fill rates, which will lead to larger reorder points and/or order quantities.

If you Google “types of spare parts”, you will discover other classifications and distinctions. From our perspective at Smart Software, the words matter less than the numbers associated with parts: unit costs, mean time before failure, mean time to repair and other technical inputs to our products that work out how to manage the parts for maximum benefit.

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.

“Regardless of how much effort is poured into training forecasters and developing elaborate forecast support systems, decision-makers will either modify or discard the predictions if they do not trust them.”  — Dilek Onkal, International Journal of Forecasting 38:3 (July-September 2022), p.802.

The words quoted above grabbed my attention and prompted this post. Those of a geekly persuasion, like your blogger, are inclined to think of forecasting as a statistical problem. While that is obviously true, those of a certain age, like your blogger, understand that forecasting is also a social activity and therefore has a large human component.

What Do You Trust?

There is a related dimension of trust: not who do you trust but what do you trust? By this, I mean both data and software.

Trust in Data

Trust in data underpins trust in the forecaster using the data. Most of our customers have their data in an ERP system. This data must be understood as a key corporate asset. For the data to be trustworthy, it must have the “three C’s”, i.e., it must be correct, complete, and current.

Correctness is obviously fundamental. We once had a customer who was implementing a new, strong forecasting process, but found the results completely at odds with their sense of what was happening in the business. It turned out that several of their data streams were incorrect by a factor of two, which is a huge error. Of course, this set back the implementation process until they could identify and correct all the gross errors in their demand data.

There is a less obvious point to be made about correctness. That is, data are random, so what you see now is not likely to be what you see next. Planning production based on the assumption that next week’s demand will be exactly the same as this week’s demand is clearly foolish, but classical formula-based forecasting models like the exponential smoothing mentioned above will project the same number throughout the forecast horizon. This is where scenario-based planning is essential for coping with the inevitable fluctuations in key variables such as customers’ demands and suppliers’ replenishment lead times.

Completeness is the second requirement for data to be trusted. Our software ultimately gets much of its value from exposing the links between operational decisions (e.g., selecting the reorder points governing replenishment of stock) and business-related metrics like inventory costs. Yet often implementation of forecasting software is delayed because item demand information is available someplace, but holding, ordering and/or shortage costs are not.  Or, to cite another recent example, a customer was able to properly size only half their inventory of spares for reparable parts because nobody had been tracking when the other half was breaking down, meaning there was no information on mean time before failure (MTBF), meaning it was not possible to model the breakdown behavior of half the fleet of reparable spares.

Finally, the currency of data matters. As the speed of business increases and company planning cycles drop from a quarterly or monthly tempo to a weekly or daily tempo, it becomes desirable to exploit the agility provided by overnight uploads of daily transactional data into the cloud. This allows high-frequency adjustments of forecasts and/or inventory control parameters for items that experience high volatility and sudden shifts in demand. The fresher the data, the more trustworthy the analysis.

Trust in Demand Forecasting Software

Even with high-quality data, forecasters must still trust the analytical software that processes the data. This trust must extend to both the software itself and to the computational environment in which it functions.

If forecasters used on-premises software, they must rely on their own IT departments to safeguard the data and keep it available for use. If they wish instead to exploit the power of cloud-based analytics, customers must trust their confidential information to their software vendors. Professional-level software, such as ours, justifies customers’ trust through SOC 2 certification. SOC 2 certification was developed by the American Institute of CPAs and defines criteria for managing customer data based on five “trust service principles”—security, availability, processing integrity, confidentiality, and privacy.

What about the software itself? What is needed to make it trustworthy? The main criteria here are the correctness of algorithms and functional reliability. If the vendor has a professional program development process, there will be little chance that the software ends up computing the wrong numbers because of a programming error. And if the vendor has a rigorous quality assurance process, there will be little chance that the software will crash just when the forecaster is on deadline or must deal with a pop-up analysis for a special situation.

Summary

To be useful, forecasters and their forecasts must be trusted by decision-makers. That trust depends on characteristics of forecasters and their processes and communication. It also depends on the quality of the data and software used in creating the forecasts.

Read the 1st part of this Blog “Who do you Trust” here: https://smartcorp.com/forecasting/the-role-of-trust-in-the-demand-forecasting-process-part-1-who/

“Regardless of how much effort is poured into training forecasters and developing elaborate forecast support systems, decision-makers will either modify or discard the predictions if they do not trust them.”  — Dilek Onkal, International Journal of Forecasting 38:3 (July-September 2022), p.802.

The words quoted above grabbed my attention and prompted this post. Those of a geekly persuasion, like your blogger, are inclined to think of forecasting as a statistical problem. While that is obviously true, those of a certain age, like your blogger, understand that forecasting is also a social activity and therefore has a large human component.

Who Do You Trust?

Trust is always a two-way street, but let’s stay on the demand forecaster’s side. What characteristics of and actions by forecasters and demand planners build trust in their work? The above quoted Professor Onkal reviewed academic research on this topic going back to 2006. She summarized results from practitioner surveys that identified key trust factors related to forecaster characteristics, forecasting process, and forecasting communication.

Forecaster characteristics

Key to building trust among the users of forecasts are perceptions of forecaster and demand planner competence and objectivity. Competence has a mathematical component, but many managers confuse computer skills with analytic skills, so users of forecasting software can usually clear this hurdle. However, since the two are not the same, it pays dividends to absorb your vendor’s training and learn not just the math but the lingo of your forecasting software. In my observation, trust can also be increased by showing knowledge of the company’s business.

Objectivity is also a key to trustworthiness. It may be uncomfortable for the forecaster to be put in the middle of occasional departmental squabbles, but those will come up and must be handled with tact. Squabbles? Well, silos exist and tilt in different directions. Sales departments favor higher demand forecasts that drive production increases, so that they never have to say “Sorry, we are fresh out of that.” Inventory managers are wary of high demand forecasts, because “excess enthusiasm” can leave them holding the bag, sitting on bloated inventory.

Sometimes the forecaster becomes a de facto referee, and in this role must display overt signs of objectivity. That can mean first recognizing that every management decision involves tradeoffs of good things against other good things, e.g., product availability versus lean operations, and then helping the parties strike a painful but tolerable balance by surfacing the links between operational decisions and the key performance metrics that matter to folks like Chief Financial Officers.

The Forecasting process

The forecasting process can be thought of as having three phases: data inputs, calculations, and outputs. Actions can be taken to increase trust in each phase.

Regarding inputs:

Trust can be increased if obviously relevant inputs are at least acknowledged if not directly used in calculations. Thus, factors like social media sentiment and regional sales managers’ gut instincts can be legitimate parts of a forecast consensus process. However, objectivity requires that these putative predictors of profit be tested objectively. For instance, a professional-grade forecasting process may well include subjective adjustment to statistical forecasts but must then also assess whether the adjustments actually end up improving accuracy, not just making some people feel listened to.

Regarding the second phase, calculations:

The forecaster will be trusted to the extent that they are able to deploy more than one way to calculate forecasts and then articulate a good reason why they chose the method eventually used. In addition, the forecaster should be able to explain in accessible language how even complicated techniques do their job. It is difficult to put trust in a “black box” method that is so opaque as to be inscrutable. The importance of explainability is amplified by the fact of life that the forecaster’s superior must themselves in turn be able to justify the choice of technique to their supervisor.

For instance, exponential smoothing uses this equation: S(t) = αX(t)+(1-α)S(t-1). Many forecasters are familiar with this equation, but many forecast users are not. There is a story that explains the equation in terms of averaging irrelevant “noise” in an item’s demand history and the need to strike a balance between smoothing out noise and being able to react to sudden shifts in the level of demand. The forecaster who can tell that story will be more credible. (My own version of that story uses phrases from sports, i.e., “head fakes” and “jukes”. Finding folksy analogs appropriate to your specific audience always pays dividends.)

A final point: best practice demands that any forecast be accompanied by an honest assessment of its uncertainty. A forecaster who tries to build trust by being overly specific (“Sales next quarter will be 12,184 units”) will always fail. A forecaster who says “Sales next quarter will have a 90% chance of falling between 12,000 and 12,300 units” will be both correct more often and  also more helpful to decision makers. After all, forecasting is essentially a job of risk management, so the decision maker is best served by knowing the risks.

Forecasting communication:

Finally, consider the third phase, communication of forecast results. Research suggests that continual communication with forecast users builds trust. It avoids those horrible, deflating moments when a nicely formatted report is shot down because of some fatal flaw that could have been foreseen: “This is no good because you didn’t take account of X, Y or Z” or “We really wanted you to present results rolled up to the top of the product hierarchies (or by sales region or by product line or…)”.

Even when everybody is aligned as to what is expected, trust is enhanced by presenting results using well-crafted graphics, with massive numerical tables provided for backup but not as the main way of communicating results. My experience has been that, just as a meeting-control device, a graph is usually much better than a large numerical table. With a graph, everybody’s attention is focused on the same thing and many aspects of the analysis are immediately (and literally) visible. With a table of results, the table of participants often splinters into side conversations in which each voice is focused on different pieces of the table.

Onkal summarizes the research this way: “Take-aways for those who make forecasts and those who use them converge around clarity of communication as well as perceptions of competence and integrity.”

What Do You Trust?

There is a related dimension of trust: not who do you trust but what do you trust? By this I mean both data and software….  Read the 2nd part of this Blog “What do you Trust” here  https://smartcorp.com/forecasting/the-role-of-trust-in-the-demand-forecasting-process-part-2-what/

In Smart Software’s forty-plus years of providing forecasting software, we’ve met many people who find themselves, perhaps surprisingly, becoming demand forecasters. This blog is aimed primarily at those fortunate individuals who are about to start this adventure (though seasoned pros may enjoy the refresher).

Welcome to the field! Good forecasting can make a big difference to your company’s performance, whether you are forecasting to support sales, marketing, production, inventory, or finance.

There is a lot of math and statistics underlying demand forecasting methods, so your assignment suggests that you are not one of those math-phobic people who would rather be poets. Luckily, if you are feeling a bit shaky and not yet healed from your high school geometry class, a lot of the math is built into forecasting software, so your first job is to leave the math for later while you get a view of the big picture. It is indeed a big picture, but let’s isolate few of the ideas that will most help you succeed.

1. Demand Forecasting is a team sport. Even in a small company, the demand planner is part of a team, with some folks bringing the data, some bringing the tech, and some bringing the business judgment. In a well-run business, your job will never be to simply feed some data into a program and send out a forecast report. Many companies have adopted a process called Sales and Operations Planning (S&OP) in which your forecast will be used to kick off a meeting to make certain judgments (e.g., Should we assume this trend will continue? Will it be worse to under-forecast or over-forecast?) and to blend extra information into the final forecast (e.g., sales force input, business intelligence on competitors’ moves, promotions). The implication for you is that your skills at listening and communicating will be important to your success.

2. Statistical Forecasting engines need good fuel. Historical data is the fuel used by statistical forecasting programs, so bad or missing or delayed data can degrade your work product. Your job will implicitly include a quality control aspect, and you must keep a keen eye on the data that are supplied to you. Along the way, it is a good idea to make the IT people your friends.

3. Your name is on your forecasts. Like it or not, if I send forecasts up the chain of command, they get labeled as “Tom’s forecasts.” I must be prepared to own those numbers. To earn my seat at the table, I must be able to explain what data my forecasts were based on, how they were calculated, why I used Method A instead of Method B to do the calculations, and especially how firm or squishy they are. Here honesty is important. No forecast can reasonably be expected to be perfectly accurate, but not all managers can be expected to be perfectly reasonable. If you’re unlucky, your management will think that your reports of forecast uncertainty suggest either ignorance or incompetence. In truth, they indicate professionalism. I have no useful advice about how best to manage such managers, but I can warn you about them. It’s up to you to educate those who use your forecasts. The best managers will appreciate that.

4. Leave your spreadsheets behind. It’s not uncommon for someone to be promoted to forecaster because they were great with Excel. Unless you are with an unusually small company, the scale of modern corporate forecasting overwhelms what you can handle with spreadsheets. The increasing speed of business compounds the problem: the sleepy tempo of annual and quarterly planning meetings is rapidly giving way to weekly or even daily re-forecasts as conditions change. So, be prepared to lean on a professional vendor of modern, scalable cloud-based demand planning and statistical forecasting software for training and support.

5. Think visually. It will be very useful, both in deciding how to generate demand forecasts and in presenting them to management, so take advantage of the visualization capabilities built into forecasting software. As I noted above, in today’s high-frequency business world, the data you work with can change rapidly, so what you did last month may not be the right thing to do this month. Literally keep an eye on your data by making simple plots, like “timeplots” that show things like trend or seasonality or (especially) changes in trend or seasonality or anomalies that must be dealt with. Similarly, supplementing tables of forecasts with graphs comparing current forecasts to prior forecasts to actuals can be very helpful in an S&OP process. For example, timeplots showing past values, forecasted values, and “forecast intervals” indicating the objective uncertainty in the forecasts provide a solid basis for your team to fully appreciate the message in your forecasts.

That’s enough for now. As a person who’s taught in universities for half a century, I’m inclined to start into the statistical side of forecasting, but I’ll save that for another time. The five tips above should be helpful to you as you grow into a key part of your corporate planning team. Welcome to the game!