​In this video blog, we explore the critical roles of Descriptive, Predictive, and Prescriptive Analytics in inventory management, highlighting their essential contributions to driving supply chain optimization through strategic foresight and insightful data analysis.

​These analytics foster a dynamic, responsive, and efficient inventory management ecosystem by enabling inventory managers to monitor current operations, anticipate future developments, and formulate optimal responses. We’ll walk you through how Descriptive Analytics keeps you informed about current operations, Predictive Analytics helps you anticipate future demands, and Prescriptive Analytics guides your strategic decisions for maximum efficiency and cost-effectiveness.

By the end of the video, you’ll have a solid understanding of how to leverage these analytics to enhance your inventory management strategies. These are not just tools but a new way of thinking about and approaching inventory optimization with the support of modern software.

“Business is war” may be an overdone metaphor but it’s not without validity. Like the “Bomber Gap” and the “Missile Gap,” worries about falling behind the competition, and the resulting threat of annihilation, always lurk in the minds of business executives, If they don’t, they should, because not all gaps are imaginary (the Bomber Gap and the Missile Gap were shown to not exist between the US and the USSR, but the 1980’s gap between Japanese and American productivity was all too real). The difference between paranoia and justified concern is converting fear into facts. This post is about organizing your attention toward possible gaps in your company’s supply chain analytics.

Surveillance Gaps

The US Army has a saying: “Time spent on reconnaissance is never wasted.” Now and then, our Smart Forecaster blog has a post that helps you get your head on a swivel to see what’s going on around you. An example is our post on digital twins, which is a hot topic throughout the engineering world.  To recap: using demand and supply simulations to probe for weaknesses in your inventory plan is a form of supply chain reconnaissance.  Closing this surveillance gap enables businesses to take corrective action before an actual problem emerges.

Situational Awareness Gaps

A military commander needs to keep track of what is available for use and how well it is being used. The reports available in Smart Operational Analytics keep you current on your inventory counts, your forecasting accuracy, your suppliers’ responsiveness, and trends in these and other operational areas.  You’ll know exactly where you stand on a variety of supply chain KPIs such as service level, fill rates, and inventory turns.  You’ll know whether actual performance is aligned with planned performance and whether the inventory plan (i.e., what to order, when, from whom, and why) is being adhered to or ignored.

Agility Gaps

The business environment can change rapidly. All it takes is a tanker stuck sideways in the Suez Canal, a few anti-ship ballistic missiles in the Red Sea, or a region-wide weather event. These catastrophes may fall as much on your competitors’ heads as on yours, but which of you is agile enough to react first? Exception reporting in Demand Planner and Smart Operational Analytics can detect major changes in the character of demand so you can quickly filter out obsolete demand data before they poison all your calculations for demand forecasts or inventory optimization. Smart Demand Planner can give advance warning of a pending increase or decrease in demand. Smart Inventory Optimization can help you adjust your inventory replenishment tactics to reflect these shifts in demand.

Innovation Gaps

Whether you refer to your competition as “The Other Guys” or “Everybody Else” or something unprintable, the ones you have to worry about are the ones always looking for an edge. When you choose Smart as your partner, we’ll give you that edge with innovative but field proven predictive solutions.  Smart Software has been innovating predictive modeling since birth over 40 years ago.

• Our first products introduced multiple technical innovations: assessment of forecast quality by looking into the future not the past; automatic selection of the best among a set of competing methodologies, exploiting the graphics in the first PCs to allow easy management overrides of statistical forecasts.

• Later we invented and patented a radically different approach to forecasting the intermittent demand that is characteristic of both spare parts and big-ticket durable goods. Our technology was patented, received multiple awards for dramatically improving the management of inventory.  The solution is now a field proven approach used by many leading businesses in service parts, MRO, aftermarket parts, and field service.

• More recently, Smart’s cloud platform for demand forecasting, predictive modeling, inventory optimization, and analytics, takes all relevant data otherwise locked in your ERP or EAM systems, external files, and other disparate data sources, organizes it in the Smart Data Pipeline, structures it into our common data model, and processes it in our AWS cloud.  Smart uses the power of our patented probabilistic demand simulations in Smart Inventory Optimization to stress test and optimize the rules you use to manage each of your inventory items.

It’s my job, along with my cofounder Dr. Nelson Hartunian, our data science team, and academic consultants, to continue to push the envelope of supply chain analytics and bring the benefits back to you by continuously rolling out new versions of our products so you don’t get stuck in an innovation gap – or any of the others.

​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.

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.  

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.

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.

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.]

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=13¹. Did you get the right answer, or something close²? 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… Smart³.

¹ 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.

² 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.

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

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.

Figure 1: Some sample reports in graphical form