Inventory Planning Becomes More Interesting

The Smart Forecaster

 Pursuing best practices in demand planning,

forecasting and inventory optimization

Taiichi Ohno of Toyota is credited with inventing Just-In-Time (JIT) manufacturing in the 1950s. JIT ensures that a manufacturer produces only what is needed, only when required, and only in the necessary amount. That innovation has since had major impacts, some good, some less so.

A recent New York Times article “How the World Ran out of Everything” describes some of the “less so” impacts.  For example, JIT has kept inventory costs very low improving return on assets.  This in turn is rewarded by Wall Street, so many companies have spent the last few decades reducing their inventories dramatically. Focused as they were on financials, many companies ignored the risks inherent in reducing inventories to the point that “lean” began to border on “emaciated.” Combined with increased globalization and new risks of supply interruption, stock-outs have abounded.

Some industries have gone too far, leaving them exposed to disruption. In a competition to get to the lowest cost, companies have inadvertently concentrated their risk, been interrupted by shortages of raw materials or components, and sometimes forced to halt assembly lines. Wall Street does not look kindly on production halts.

We all know that random events have added to the problem. First among them has been the Covid pandemic. As the pandemic has hindered factory operations and spread disarray in global shipping, many economies worldwide have been tormented by shortages of an immense range of goods — from computer chips to lumber to clothing.

The damage is compounded when more unexpected things go wrong. The Suez Canal Blockage is a prime example, obstructing the main trade route between Europe and Asia. Recently, cyberattacks have added another layer of disruption.

The reaction creates its own problems, just as the cyberattack on the Colonial Pipeline created gas shortages through panic buying. Suppliers start filling orders more slowly than usual. Manufacturers and distributors reverse course and increase inventories and diversify their suppliers to avoid future stockouts. Simply expanding warehouses may not deliver the solution, and the need to determine how much inventory to keep is more urgent every day.Manager In Warehouse With Inventory Management Software

So how can you execute a real-world plan for JIT inventory amidst all this risk and uncertainty? The foundation of your response is your corporate data. Uncertainty has two sources: supply and demand. You need the facts for both.

On the supply side, exploit the data you have on recent supplier lead times, which reflect the current turbulence. Don’t use average values when you can use probability distributions that reflect the full range of contingencies. Consider this comparison. Supplier A is now reliably filling orders in exactly 10 days. Supplier B also averages 10 days but does with a 78%/22% mix of 7 and 21 days. Both A and B have an average replenishment delay of 10 days, but the operational results they provide will be very different. You can only recognize this if you use probability models of inventory performance.

On the demand side, similar considerations apply. First, recognize that there may have been a major shift in the character of item demand (statisticians call this a “regime change”), so purge from your analysis any data that represent the “good old days.” Then, again, stop thinking in terms of averages. While the average demand is important, it is not a sufficient descriptor of the problem you face. Equally important is the volatility of demand. Volatility is the reason you keep inventory in the first place. If demand were completely predictable, you would have neither stockouts nor excess inventory. Just as you need to estimate the full probability distribution of replenishment lead times, you need the full distribution of demand values.

Once you understand the range of variability in both supply and demand, probabilistic forecasting will allow you to account for disruptions and unusual events. Software will convert your data on demand and lead times into huge numbers of scenarios representing how your next planning period might play out. Given those scenarios, the software can determine how best to meet your goals for such metrics as inventory costs and stockout rates. Using solutions such as Smart Inventory Optimization , you will confidently plan based on your targeted stockout risk with minimal inventory carrying cost. You may also consider letting the solution prescribe optimal service level targets by assessing the costs of additional inventory vs. stockout cost.

In inventory planning, as in science, we cannot escape the reality of uncertainty and the impact of unusual events. We must plan accordingly: using inventory optimization software helps you identify the least-cost service level. This creates a coherent, company-wide effort that combines visibility into current operations with mathematically correct assessments of future risks and conditions.

Inventory planning has become more “interesting” and requires a greater degree of risk awareness and agility. The right software can help.

 

Leave a Comment

Related Posts

Constructive Play with Digital Twins

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

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

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

In this blog, the spotlight is cast on the software that creates reports for management, the silent hero that translates the beauty of furious calculations into actionable reports. Watch as the calculations, intricately guided by planners utilizing our software, seamlessly converge into Smart Operational Analytics (SOA) reports, dividing five key areas: inventory analysis, inventory performance, inventory trending, supplier performance, and demand anomalies.

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

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

Dealing with the day-to-day of inventory management can keep you busy. 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.

Recent Posts

  • Finding Your Spot on the Inventory Tradeoff CurveFinding Your Spot on the Inventory Tradeoff Curve
    This video blog holds essential insights for those working with the complexities of inventory management. The session focuses on striking the right balance within the inventory tradeoff curve, inviting viewers to understand the deep-seated importance of this equilibrium. […]
  • Why MRO Businesses Need Add-on Service Parts Planning & Inventory SoftwareWhy MRO Businesses Need Add-on Service Parts Planning & Inventory Software
    MRO organizations exist in a wide range of industries, including public transit, electrical utilities, wastewater, hydro power, aviation, and mining. To get their work done, MRO professionals use Enterprise Asset Management (EAM) and Enterprise Resource Planning (ERP) systems. These systems are designed to do a lot of jobs. Given their features, cost, and extensive implementation requirements, there is an assumption that EAM and ERP systems can do it all. In this post, we summarize the need for add-on software that addresses specialized analytics for inventory optimization, forecasting, and service parts planning. […]
  • Descriptive, Predictive, and Prescriptive AnalyticsThe Three Types of Supply Chain Analytics
    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. […]
  • Warning Signs that You Have a Supply Chain Analytics GapWarning Signs that You Have a Supply Chain Analytics Gap
    “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. […]
  • The Objectives in ForecastingThe Objectives in Forecasting
    A forecast is a prediction about the value of a time series variable at some time in the future. For instance, one might want to estimate next month’s sales or demand for a product item. A time series is a sequence of numbers recorded at equally spaced time intervals; for example, unit sales recorded every month. The objectives you pursue when you forecast depend on the nature of your job and your business. Every forecast is uncertain; in fact, there is a range of possible values for any variable you forecast. Values near the middle of this range have a higher likelihood of actually occurring, while values at the extremes of the range are less likely to occur. […]

    Inventory Optimization for Manufacturers, Distributors, and MRO

    • Why MRO Businesses Need Add-on Service Parts Planning & Inventory SoftwareWhy MRO Businesses Need Add-on Service Parts Planning & Inventory Software
      MRO organizations exist in a wide range of industries, including public transit, electrical utilities, wastewater, hydro power, aviation, and mining. To get their work done, MRO professionals use Enterprise Asset Management (EAM) and Enterprise Resource Planning (ERP) systems. These systems are designed to do a lot of jobs. Given their features, cost, and extensive implementation requirements, there is an assumption that EAM and ERP systems can do it all. In this post, we summarize the need for add-on software that addresses specialized analytics for inventory optimization, forecasting, and service parts planning. […]
    • Spare-parts-demand-forecasting-a-different-perspective-for-planning-service-partsThe Forecast Matters, but Maybe Not the Way You Think
      True or false: The forecast doesn't matter to spare parts inventory management. At first glance, this statement seems obviously false. After all, forecasts are crucial for planning stock levels, right? It depends on what you mean by a “forecast”. If you mean an old-school single-number forecast (“demand for item CX218b will be 3 units next week and 6 units the week after”), then no. If you broaden the meaning of forecast to include a probability distribution taking account of uncertainties in both demand and supply, then yes. […]
    • Whyt MRO Businesses Should Care about Excess InventoryWhy MRO Businesses Should Care About Excess Inventory
      Do MRO companies genuinely prioritize reducing excess spare parts inventory? From an organizational standpoint, our experience suggests not necessarily. Boardroom discussions typically revolve around expanding fleets, acquiring new customers, meeting service level agreements (SLAs), modernizing infrastructure, and maximizing uptime. In industries where assets supported by spare parts cost hundreds of millions or generate significant revenue (e.g., mining or oil & gas), the value of the inventory just doesn’t raise any eyebrows, and organizations tend to overlook massive amounts of excessive inventory. […]
    • Top Differences between Inventory Planning for Finished Goods and for MRO and Spare PartsTop Differences Between Inventory Planning for Finished Goods and for MRO and Spare Parts
      In today’s competitive business landscape, companies are constantly seeking ways to improve their operational efficiency and drive increased revenue. Optimizing service parts management is an often-overlooked aspect that can have a significant financial impact. Companies can improve overall efficiency and generate significant financial returns by effectively managing spare parts inventory. This article will explore the economic implications of optimized service parts management and how investing in Inventory Optimization and Demand Planning Software can provide a competitive advantage. […]

      Redefine Exceptions and Fine Tune Planning to Address Uncertainty

      The Smart Forecaster

       Pursuing best practices in demand planning,

      forecasting and inventory optimization

      Inventory Planning from the Perspective of a Physicist

      In a perfect world, Just in Time (JIT) would be the appropriate solution for inventory management. If you can exactly predict what you need and where you need it and your suppliers can get what you need without delay, then you do not need to maintain much inventory locally.  But as the saying goes from famous pugilist Mike Tyson, “everyone has a plan until they get punched in the mouth.” And the latest punch in the mouth for the global supply chain was last week’s Suez Canal Blockage that held up $9.6B in trade costing an estimated $6.7M per minute[1].  Disruptions from these and similar events should be modeled and accounted for in your planning.

      The assumption that you can exactly predict the future was apparent in Isaac Newton’s laws. Since the 1920’s with the introduction of quantum physics, uncertainty became fundamental to our understanding of nature. Uncertainty is built into fundamental reality.  So too should it be built into Supply and Demand Planning processes.  Yet too often, black swan events such as the Suez Canal blockage are often thought of as anomalies and as a result, discounted when planning. It is not enough to look back in hindsight and proclaim that it should have been expected. Something needs to be done about addressing the occurrence of other such events in the future and planning stocking levels accordingly.

      We must move beyond the “thin tailed distribution” thinking where extreme outcomes are discounted and plan for “fat tails.”  So how do we execute a real-world JIT plan when it comes to planning inventory? To do this, the first step is to estimate the realistic lead time to obtain an item. However, estimation is difficult due to lead time uncertainty.  Using actual supplier lead times in your company database and external data, you can develop a distribution of possible future lead times and demands within those lead times. Probabilistic forecasting will allow you to account for disruptions and unusual events by not limiting your estimates to what has been observed solely on your own short-term demand and lead time data.  You’ll be able to generate possible outcomes with associated probabilities for each occurrence.

      Once you have an estimate of the lead time and demand distribution, you can then specify the service level you need to have for that part. Using solutions such as Smart Inventory Optimization (SIO), you will be able confidently stock based on the targeted stock-out risk with minimal inventory carrying cost. You may also consider letting the solution prescribe optimal service level targets by assessing the costs of additional inventory vs. cost of stockout.

      Finally, as I have already noted, we need to accept that we can never eliminate all uncertainty. As a physicist, I have always been intrigued by the fact that, even at the most basic levels of reality as we understand it today, there is still uncertainty. Albert Einstein believed in certainty (determinism) in physical law.  If he were an inventory manager, he might have argued for JIT because he believed physical laws should allow perfect predictability. He famously said, “God does not play with dice.”  Or could it be possible that the universe we exist in was a “black swan” event in a prior “multi-verse” that produced a particular kind of universe that allowed us to exist.

      In inventory planning, as in science, we cannot escape the reality of uncertainty and the impact of unusual events.  We must plan accordingly.

       

      [1] https://www.bbc.com/news/business-56559073#:~:text=Looking%20at%20the%20bigger%20picture,0.2%20to%200.4%20percentage%20points.

      Leave a Comment

      Related Posts

      Constructive Play with Digital Twins

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

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

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

      In this blog, the spotlight is cast on the software that creates reports for management, the silent hero that translates the beauty of furious calculations into actionable reports. Watch as the calculations, intricately guided by planners utilizing our software, seamlessly converge into Smart Operational Analytics (SOA) reports, dividing five key areas: inventory analysis, inventory performance, inventory trending, supplier performance, and demand anomalies.

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

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

      Dealing with the day-to-day of inventory management can keep you busy. 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.

      Recent Posts

      • Finding Your Spot on the Inventory Tradeoff CurveFinding Your Spot on the Inventory Tradeoff Curve
        This video blog holds essential insights for those working with the complexities of inventory management. The session focuses on striking the right balance within the inventory tradeoff curve, inviting viewers to understand the deep-seated importance of this equilibrium. […]
      • Why MRO Businesses Need Add-on Service Parts Planning & Inventory SoftwareWhy MRO Businesses Need Add-on Service Parts Planning & Inventory Software
        MRO organizations exist in a wide range of industries, including public transit, electrical utilities, wastewater, hydro power, aviation, and mining. To get their work done, MRO professionals use Enterprise Asset Management (EAM) and Enterprise Resource Planning (ERP) systems. These systems are designed to do a lot of jobs. Given their features, cost, and extensive implementation requirements, there is an assumption that EAM and ERP systems can do it all. In this post, we summarize the need for add-on software that addresses specialized analytics for inventory optimization, forecasting, and service parts planning. […]
      • Descriptive, Predictive, and Prescriptive AnalyticsThe Three Types of Supply Chain Analytics
        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. […]
      • Warning Signs that You Have a Supply Chain Analytics GapWarning Signs that You Have a Supply Chain Analytics Gap
        “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. […]
      • The Objectives in ForecastingThe Objectives in Forecasting
        A forecast is a prediction about the value of a time series variable at some time in the future. For instance, one might want to estimate next month’s sales or demand for a product item. A time series is a sequence of numbers recorded at equally spaced time intervals; for example, unit sales recorded every month. The objectives you pursue when you forecast depend on the nature of your job and your business. Every forecast is uncertain; in fact, there is a range of possible values for any variable you forecast. Values near the middle of this range have a higher likelihood of actually occurring, while values at the extremes of the range are less likely to occur. […]

        Inventory Optimization for Manufacturers, Distributors, and MRO

        • Why MRO Businesses Need Add-on Service Parts Planning & Inventory SoftwareWhy MRO Businesses Need Add-on Service Parts Planning & Inventory Software
          MRO organizations exist in a wide range of industries, including public transit, electrical utilities, wastewater, hydro power, aviation, and mining. To get their work done, MRO professionals use Enterprise Asset Management (EAM) and Enterprise Resource Planning (ERP) systems. These systems are designed to do a lot of jobs. Given their features, cost, and extensive implementation requirements, there is an assumption that EAM and ERP systems can do it all. In this post, we summarize the need for add-on software that addresses specialized analytics for inventory optimization, forecasting, and service parts planning. […]
        • Spare-parts-demand-forecasting-a-different-perspective-for-planning-service-partsThe Forecast Matters, but Maybe Not the Way You Think
          True or false: The forecast doesn't matter to spare parts inventory management. At first glance, this statement seems obviously false. After all, forecasts are crucial for planning stock levels, right? It depends on what you mean by a “forecast”. If you mean an old-school single-number forecast (“demand for item CX218b will be 3 units next week and 6 units the week after”), then no. If you broaden the meaning of forecast to include a probability distribution taking account of uncertainties in both demand and supply, then yes. […]
        • Whyt MRO Businesses Should Care about Excess InventoryWhy MRO Businesses Should Care About Excess Inventory
          Do MRO companies genuinely prioritize reducing excess spare parts inventory? From an organizational standpoint, our experience suggests not necessarily. Boardroom discussions typically revolve around expanding fleets, acquiring new customers, meeting service level agreements (SLAs), modernizing infrastructure, and maximizing uptime. In industries where assets supported by spare parts cost hundreds of millions or generate significant revenue (e.g., mining or oil & gas), the value of the inventory just doesn’t raise any eyebrows, and organizations tend to overlook massive amounts of excessive inventory. […]
        • Top Differences between Inventory Planning for Finished Goods and for MRO and Spare PartsTop Differences Between Inventory Planning for Finished Goods and for MRO and Spare Parts
          In today’s competitive business landscape, companies are constantly seeking ways to improve their operational efficiency and drive increased revenue. Optimizing service parts management is an often-overlooked aspect that can have a significant financial impact. Companies can improve overall efficiency and generate significant financial returns by effectively managing spare parts inventory. This article will explore the economic implications of optimized service parts management and how investing in Inventory Optimization and Demand Planning Software can provide a competitive advantage. […]