Leveraging ERP Planning BOMs with Smart IP&O to Forecast the Unforecastable

​In a highly configurable manufacturing environment, forecasting finished goods can become a complex and daunting task. The number of possible finished products will skyrocket when many components are interchangeable. A traditional MRP would force us to forecast every single finished product which can be unrealistic or even impossible. Several leading ERP solutions introduce the concept of the “Planning BOM”, which allows the use of forecasts at a higher level in the manufacturing process. In this article, we will discuss this functionality in ERP, and how you can take advantage of it with Smart Inventory Planning and Optimization (Smart IP&O) to get ahead of your demand in the face of this complexity.

Why Would I Need a Planning BOM?

Traditionally, each finished product or SKU would have a rigidly defined bill of materials. If we stock that product and want to plan around forecasted demand, we would forecast demand for those products and then feed MRP to blow this forecasted demand from the finished good level down to its components via the BOM.

Many companies, however, offer highly configurable products where customers can select options on the product they are buying. As an example, recall the last time you bought a personal computer. You chose a brand and model, but from there, you were likely presented with options: what speed of CPU do you want? How much RAM do you want? What kind of hard drive and how much space? If that business wants to have these computers ready and available to ship to you in a reasonable time, suddenly they are no longer just anticipating demand for that model—they must forecast that model for every type of CPU, for all quantities of RAM, for all types of hard drive, and all possible combinations of those as well! For some manufacturers, these configurations can compound to hundreds or thousands of possible finished good permutations.

Planning BOM emphasizing the large numbers of permutations Laptops Factory Components

There may be so many possible customizations that the demand at the finished product level is completely unforecastable in a traditional sense. Thousands of those computers may sell every year, but for each possible configuration, the demand may be extremely low and sporadic—perhaps certain combinations sell once and never again.

This often forces these companies to plan reorder points and safety stock levels mostly at the component level, while largely reacting to firm demand at the finished good level via MRP. While this is a valid approach, it lacks a systematic way to leverage forecasts that may account for anticipated future activity such as promotions, upcoming projects, or sales opportunities. Forecasting at the “configured” level is effectively impossible, and trying to weave in these forecast assumptions at the component level isn’t feasible either.

 

Planning BOM Explained

This is where Planning BOMs come in. Perhaps the sales team is working a big b2b opportunity for that model, or there’s a planned promotion for Cyber Monday. While trying to work in those assumptions for every possible configuration isn’t realistic, doing it at the model level is totally doable—and tremendously valuable.

The Planning BOM can use a forecast at a higher level and then blow demand down based on predefined proportions for its possible components. For example, the computer manufacturer may know that most people opt for 16GB of RAM, and far fewer opt for the upgrades to 32 or 64. The planning BOM allows the organization to (for example) blow 60% of the demand down to the 16GB option, 30% to the 32GB option, and 10% to the 64GB option. They could do the same for CPUs, hard drives, or any other customizations available.  

Planning BOM Explained with computer random access memory ram close hd

 

The business can now focus their forecast at this model level, leaving the Planning BOM to figure out the component mix. Clearly, defining these proportions requires some thought, but Planning BOMs effectively allow businesses to forecast what would otherwise be unforecastable.

 

The Importance of a Good Forecast

Of course, we still need a good forecast to load into an ERP system. As explained in this article, while ERP  can import a forecast, it often cannot generate one and when it does it tends to require a great deal of hard to use configurations that don’t often get revisited resulting in inaccurate forecasts.  It is therefore up to the business to come up with their own sets of forecasts, often manually produced in Excel. Forecasting manually generally presents a number of challenges, including but not limited to:

  • The inability to identify demand patterns like seasonality or trend
  • Overreliance on customer or sales forecasts
  • Lack of accuracy or performance tracking

No matter how well configured the MRP is with your carefully considered Planning BOMs, a poor forecast means poor MRP output and mistrust in the system—garbage in, garbage out. Continuing along with the “computer company” example, without a systematic way of capturing key demand patterns and/or domain knowledge in the forecast, MRP can never see it.

 

Extend ERP  with Smart IP&O

Smart IP&O is designed to extend your ERP system with a number of integrated demand planning and inventory optimization solutions. For example, it can generate statistical forecasts automatically for large numbers of items, allows for intuitive forecast adjustments, tracks forecast accuracy, and ultimately allows you to generate true consensus-based forecasts to better anticipate the needs of your customers.

Thanks to highly flexible product hierarchies, Smart IP&O is perfectly suited to forecasting at the Planning BOM level so you can capture key patterns and incorporate business knowledge at the levels that matter most. Furthermore you can analyze and deploy optimal safety stock levels at any level of your BOM.

 

 

Constructive Play with Digital Twins

Those of you who track hot topics will be familiar with the term “digital twin.” Those who have been too busy with work may want to read on and catch up.

What is a digital twin?

While there are several definitions of digital twin, here’s one that works well:

A digital twin is a dynamic virtual copy of a physical asset, process, system, or environment that looks like and behaves identically to its real-world counterpart. A digital twin ingests data and replicates processes so you can predict possible performance outcomes and issues that the real-world product might undergo. [Source: Unity.com]. For additional background, you might go to Mckinsey.com.

What is the difference between a digital twin (hereafter DT) and a model? Primarily, a DT gets connected to real-time data to maintain the model as an up-to-the-minute representation of the system you are working with.

Our current products might be called “slow-motion DT’s” because they are usually used with non-real-time data (though not stale data, since it is updated overnight) and applied to problems like planning the next quarter’s raw material buys or setting inventory parameters for a month or longer.

Are people using digital twins in my industry?

My impression is that the penetration of DT’s may be highest in the aerospace and nuclear industries. Most of our customers are elsewhere: in manufacturing, distribution, and public utilities such as transportation and power. Soon we’ll be offering new products that come closer to the strict definition of a DT that is connected intimately to the system it represents.

DT Preview

Most users of Smart Inventory Optimization (SIO) run the application periodically, typically monthly. SIO analyzes current demand for inventory items and recent supplier lead times, converting these into demand and supply scenarios, respectively. Then users either interactively (for individual items) or automatically (at scale) set inventory control parameters that will provide the long-term average performance they want, balancing the competing goals of minimizing inventory while guaranteeing a sufficient level of item availability.

Smart Supply Planner (SSP) operates in a more immediate way to react to contingencies. Any day could bring an anomalous order that spikes up demand, such as when a new customer places a surprising initial stocking order. Or a key supplier could experience a problem at its factory and be forced to delay shipment of your planned replenishment orders. In the long run, these contingencies average out and justify the recommendations coming out of SIO. However, SSP will give you a way to react in the short run to seize opportunities or dodge bullets.

At its core, SSP operates like SIO in that it is scenario driven. The differences are that it uses short planning horizons and uses real-time initial conditions as the basis for its simulations of inventory system performance. Then it will provide real-time recommendations for interventions that offset the disruption caused by the contingencies. These would include cancelling or expediting replenishment orders.

Summary

Digital twins let you try out plans “in silico” before you implement them in the factory or warehouse. At their core are mathematical models of your operation but connected to real-time data. They provide a “digital sandbox” in which you can try out ideas and get immediate predictions of how well they will work. Much more than a spreadsheet, DT’s will soon be the key tool in your inventory planning toolbox.

 

Are You Playing the Inventory Guessing Game?

Some companies invest in software to help them manage their inventory, whether it’s spare parts or finished goods. But a surprising number of others play the Inventory Guessing Game every day, trusting to an imagined “Golden Gut” or to plain luck to set their inventory control parameters. But what kind of results do you expect with that approach?

How good are you at intuiting the right values? This blog post challenges you to guess the best Min and Max values for a notional inventory item. We’ll show you its demand history, give you a few relevant facts, then you can pick Min and Max values and see how well they would work. Ready?

The Challenge

Figure 1 shows the daily demand history of the item. The average demand is 2 units per day. Replenishment lead time is a constant 10 days (which is unrealistic but works in your favor). Orders that cannot be filled immediately from stock cannot be backordered and are lost. You want to achieve at least an 80% fill rate, but not at any cost. You also want to minimize the average number of units on hand while still achieving at least an 80% fill rate. What Min and Max values would produce an 80% fill rate with the lowest average number of units on hand? [Record your answers for checking later. The solution appears below at the end of the article.]

Are You Playing the Inventory Guessing Game-1

Computing the Best Min and Max Values

The way to determine the best values is to use a digital twin, also known as a Monte Carlo simulation. The analysis creates a multitude of demand scenarios and passes them through the mathematical logic of the inventory control system to see what values will be taken on by key performance indicators (KPI’s).

We built a digital twin for this problem and systematically exercised it with 1,085 pairs of Min and Max values. For each pair, we simulated 365 days of operation a total of 100 times. Then we averaged the results to assess the performance of the Min/Max pair in terms of two KPI’s: fill rate and average on hand inventory.

Figure 2 shows the results. The inherent tradeoff between inventory size and fill rate is clear in the figure: if you want a higher fill rate, you have to accept a larger inventory. However, at each level of inventory there is a range of fill rates, so the game is to find the Min/Max pair that yields the highest fill rate for any given size inventory.

A different way to interpret Figure 2 is to focus on the dashed green line marking the target 80% fill rate. There are many Min/Max pairs that can hit near the 80% target, but they differ in inventory size from about 6 to about 8 units. Figure 3 zooms in on that region of Figure 2 to show  quite a number of Min/Max pairs that are competitive.

We sorted the results of all 1,085 simulations to identify what economists call the efficient frontier. The efficient frontier is the set of most efficient Min/Max pairs to exploit the tradeoff between fill rate and units on hand. That is, it is a list of Min/Max pairs that provide the least cost way to achieve any desired fill rate, not just 80%. Figure 4 shows the efficient frontier for this problem. Moving from left to right, you can read off the lowest price you would have to pay (as measured by average inventory size) to achieve any target fill rate. For example, to achieve a 90% fill rate, you would have to carry an average inventory of about 10 units.

Figures 2, 3, and 4 show results for various Min/Max pairs but do not display the values of Min and Max behind each point. Table 1 displays all the simulation data: the values of Min, Max, average units on hand and fill rate. The answer to the guessing game is highlighted in the first line of the table: Min=7 and Max=131. Did you get the right answer, or something close2? Did you maybe get onto the efficient frontier?

Conclusions

Maybe you got lucky, or maybe you do indeed have a Golden Gut, but it’s more likely you didn’t get the right answer, and it’s even more likely you didn’t even try. Figuring out the right answer is extremely difficult without using the digital twin. Guessing is unprofessional.

One step up from guessing is “guess and see”, in which you implement your guess and then wait a while (months?) to see if you like the results. That tactic is at least “scientific”, but it is inefficient.

Now consider the effort to work out the best (Min,Max) pairs for thousands of items. At that scale, there is even less justification for playing the Inventory Guessing Game. The right answer is to play it… Smart3.

1 This answer has a bonus, in that it achieves a bit more than 80% fill rate at a lower average inventory size than the Min/Max combination that hit exactly 80%. In other words, (7,13) is on the efficient frontier.

2 Because these results come from a simulation instead of an exact mathematical equation, there is a certain margin of error associated with each estimated fill rate and inventory level. However, because the average results were based on 100 simulations each 365 days long, the margins of error are small. Across all experiments, the average standard errors in fill rate and mean inventory were, respectively, only 0.009% and 0.129 units.

3 In case you didn’t know this, one of the founders of Smart Software was … Charlie Smart.

Are You Playing the Inventory Guessing Game-111

Are You Playing the Inventory Guessing Game-Table 1

 

Direct to the Brain of the Boss – Inventory Analytics and Reporting

I’ll start with a confession: I’m an algorithm guy. My heart lives in the “engine room” of our software, where lightning-fast calculations zip back and forth across the AWS cloud, generating demand and supply scenarios used to guide important decisions about demand forecasting and inventory management.

But I recognize that the target of all that beautiful, furious calculation is the brain of the boss, the person responsible for making sure that customer demand is satisfied in the most efficient and profitable way. So, this blog is about Smart Operational Analytics (SOA), which creates reports for management. Or, as they are called in the military, sit-reps.

All the calculations guided by the planners using our software ultimately get distilled into the SOA reports for management. The reports focus on five areas: inventory analysis, inventory performance, inventory trending, supplier performance, and demand anomalies.

Inventory Analysis

These reports keep tabs on current inventory levels and identify areas that need improvement. The focus is on current inventory counts and their status (on hand, in transit, in quarantine), inventory turns, and excesses vs shortages.

Inventory Performance

These reports track Key Performance Indicators (KPIs) such as Fill Rates, Service Levels, and inventory Costs. The analytic calculations elsewhere in the software guide you toward achieving your KPI targets by calculating Key Performance Predictions (KPPs) based on recommended settings for, e.g., reorder points and order quantities. But sometimes surprises occur, or operating policies are not executed as recommended, so there will always be some slippage between KPPs and KPIs.

Inventory Trending

Knowing where things stand today is important, but seeing where things are trending is also valuable. These reports reveal trends in item demand, stockout events, average days on hand, average time to ship, and more.

Supplier Performance

Your company cannot perform at its best if your suppliers are dragging you down. These reports monitor supplier performance in terms of the accuracy and promptness of filling replenishment orders. Where you have multiple suppliers for the same item, they let you compare them.

Demand Anomalies

Your entire inventory system is demand driven, and all inventory control parameters are computed after modeling item demand. So if something odd is happening on the demand side, you must be vigilant and prepare to recalculate things like mins and maxes for items that are starting to act in odd ways.

Summary

The end point for all the massive calculations in our software is the dashboard showing management what’s going on, what’s next, and where to focus attention. Smart Inventory Analytics is the part of our software ecosystem aimed at your company’s C-Suite.

 Smart Reporting Studio Inventory Management Supply Software

Figure 1: Some sample reports in graphical form

 

You Need to Team up with the Algorithms

Over forty years ago, Smart Software consisted of three friends working to start a company in a church basement. Today, our team has expanded to operate from multiple locations across Massachusetts, New Hampshire and Texas, with team members in England, Spain, Armenia and India. Like many of you in your jobs,  we have found ways to make distributed teams work for us and for you.

This note is about a different kind of teamwork: the collaboration between you and our software that happens at your fingertips. I often write about the software itself and what goes on “under the hood”. This time, my subject is how you should best team up with the software.

Our software suite, Smart Inventory Planning and Optimization (Smart IP&O™) is capable of massively detailed calculations of future demand and the inventory control parameters (e.g., reorder points and order quantities) that would most effectively manage that demand. But your input is required to make the most of all that power. You need to team up with the algorithms.

That interaction can take several forms. You can start by simply assessing how you are doing now. The report writing functions in Smart IP&O (Smart Operational Analytics™) can collate and analyze all your transactional data to measure your Key Performance Indicators (KPIs), both financial (e.g., inventory investment) and operational (e.g., fill rates).

The next step might be to use SIO (Smart Inventory Optimization™), the inventory analytics within SIP&O, to play “what-if” games with the software. For example, you might ask “What if we reduced the order quantity on item 1234 from 50 to 40?” The software grinds the numbers to let you know how that would play out, then you react. This can be useful, but what if you have 50,000 items to consider? You would want to do what-if games for a few critical items, but not all of them.

The real power comes with using the automatic optimization capability in SIO. Here you can team with the algorithms at scale. Using your business judgement, you can create “groups”, i.e., collections of items that share some critical features. For example, you might create a group for “critical spare parts for electric utility customers” consisting of 1,200 parts. Then again calling on your business judgement, you could specify what item availability standard should apply to all the items in that group (e.g., “at least 95% chance of not stocking out in a year”). Now the software can take over and automatically work out the best reorder points and order quantities for every one of those items to achieve your required item availability at the lowest possible total cost. And that, dear reader, is powerful teamwork.

 

 

How Are We Doing? KPI’s and KPP’s

Dealing with the day-to-day of inventory management can keep you busy. There’s the usual rhythm of ordering, receiving, forecasting and planning, and moving things around in the warehouse. Then there are the frenetic times – shortages, expedites, last-minute calls to find new suppliers.

All this activity works against taking a moment to see how you’re doing. But you know you have to get your head up now and then to see where you’re heading. For that, your inventory software should show you metrics – and not just one, but a full set of metrics or KPI’s – Key Performance Indicators.

Multiple Metrics

Depending on your role in your organization, different metrics will have different salience. If you are on the finance side of the house, inventory investment may be top of mind: how much cash is tied up in inventory? If you’re on the sales side, item availability may be top of mind: what’s the chance that I can say “yes” to an order? If you’re responsible for replenishment, how many PO’s will your people have to cut in the next quarter?

Availability Metrics

Let’s circle back to item availability. How do you put a number on that? The two most used availability metrics are “service level” and “fill rate.” What’s the difference? It’s the difference between saying “We had an earthquake yesterday” and saying, “We had an earthquake yesterday, and it was a 6.4 on the Richter scale.” Service level records the frequency of stockouts no matter their size; fill rate reflects their severity. The two can seem to point in opposite directions, which causes some confusion. You can have a good service level, say 90%, but have an embarrassing fill rate, say 50%. Or vice versa. What makes them different is the distribution of demand sizes. For instance, if the distribution is very skewed, so most demands are small but some are huge, you might get the 90%/50% split mentioned above. If your focus is on how often you have to backorder, service level is more relevant. If your worry is how big an overnight expedite can get, the fill rate is more relevant.

One Graph to Rule them All

A graph of on-hand inventory can provide the basis for calculating multiple KPI’s. Consider Figure 1, which plots on-hand each day for a year. This plot has information needed to calculate multiple metrics: inventory investment, service level, fill rate, reorder rate and other metrics.

Key performace indicators and paramenters for inventory management

Inventory investment: The average height of the graph when above zero, when multiplied by unit cost of the inventory item, gives quarterly dollar value.

Service level: The fraction of inventory cycles that end above zero is the service level. Inventory cycles are marked by the up movements occasioned by the arrival of replenishment orders.

Fill rate: The amount by which inventory drops below zero and how long it stays there combine to determine fill rate.

In this case, the average number of units on hand was 10.74, the service level was 54%, and the fill rate was 91%.

 

KPI’s and KPP’s

In the over forty years since we founded Smart Software, I have never seen a customer produce a plot like Figure 1.  Those who are further along in their development do produce and pay attention to reports listing their KPI’s in tabular form, but they don’t look at such a graph. Nevertheless, that graph has value for developing insight into the random rhythms of inventory as it rises and falls.

Where it is especially useful is prospectively. Given market volatility, key variables like supplier lead times, average demand, and demand variability all shift over time. This implies that key control parameters like reorder points and order quantities must adjust to these shifts. For instance, if a supplier says they’ll have to increase their average lead time by 2 days, this will impact your metrics negatively, and you may need to increase your reorder point to compensate. But increase it by how much?

Here is where modern inventory software comes in. It will let you propose an adjustment and then see how things will play out. Plots like Figure 1 let you see and get a feel for the new regime. And the plots can be analyzed to compute KPP’s – Key Performance Predictions.

KPP’s help take the guesswork out of adjustments. You can simulate what will happen to your KPI’s if you change them in response to changes in your operating environment – and how bad things will get if you make no changes.