Uncover data facts and improve inventory performance

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.

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

Daily Demand Scenarios

Daily Demand Scenarios

In this Videoblog, we will explain how time series forecasting has emerged as a pivotal tool, particularly at the daily level, which Smart Software has been pioneering since its inception over forty years ago. The evolution of business practices from annual to more refined temporal increments like monthly and now daily data analysis illustrates a significant shift in operational strategies.

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.

Recent Posts

  • The Importance of Clear Service Level Definitions in Inventory ManagementThe Importance of Clear Service Level Definitions in Inventory Management
    Inventory optimization software that supports what-if analysis will expose the tradeoff of stockouts vs. excess costs of varying service level targets. But first it is important to identify how “service levels” is interpreted, measured, and reported. This will avoid miscommunication and the false sense of security that can develop when less stringent definitions are used. Clearly defining how service level is calculated puts all stakeholders on the same page. This facilitates better decision-making. […]
  • Future-Proofing Utilities. Advanced Analytics for Supply Chain OptimizationFuture-Proofing Utilities: Advanced Analytics for Supply Chain Optimization
    Utilities in the electrical, natural gas, urban water, and telecommunications fields are all asset-intensive and reliant on physical infrastructure that must be properly maintained, updated, and upgraded over time. Maximizing asset uptime and the reliability of physical infrastructure demands effective inventory management, spare parts forecasting, and supplier management. A utility that executes these processes effectively will outperform its peers, provide better returns for its investors and higher service levels for its customers, while reducing its environmental impact. […]
  • The Cost of Doing nothing with your inventory Planning SystemsThe Cost of Spreadsheet Planning
    Companies that depend on spreadsheets for demand planning, forecasting, and inventory management are often constrained by the spreadsheet’s inherent limitations. This post examines the drawbacks of traditional inventory management approaches caused by spreadsheets and their associated costs, contrasting these with the significant benefits gained from embracing state-of-the-art planning technologies. […]
  • Simple Inventory Optimization is Good Except When It Isn’t FHDSimple is Good, Except When It Isn’t
    In this blog, we are steering the conversation towards the transformative potential of technology in inventory management. The discussion centers around the limitations of simple thinking in managing inventory control processes and the necessity of adopting systematic software solutions. […]
  • Leveraging Epicor Kinetic Planning BOMs with Smart IP&O to Forecast Accurately HDLeveraging Epicor Kinetic Planning BOMs with Smart IP&O to Forecast Accurately
    In this blog, we explore how leveraging Epicor Kinetic Planning BOMs with Smart IP&O can transform your approach to forecasting in a highly configurable manufacturing environment. Discover how Smart, a cutting-edge AI-driven demand planning and inventory optimization solution, can simplify the complexities of predicting finished goods demand, especially when dealing with interchangeable components. Learn how Planning BOMs and advanced forecasting techniques enable businesses to anticipate customer needs more accurately, ensuring operational efficiency and staying ahead in a competitive market. […]

    Inventory Optimization for Manufacturers, Distributors, and MRO

    • Future-Proofing Utilities. Advanced Analytics for Supply Chain OptimizationFuture-Proofing Utilities: Advanced Analytics for Supply Chain Optimization
      Utilities in the electrical, natural gas, urban water, and telecommunications fields are all asset-intensive and reliant on physical infrastructure that must be properly maintained, updated, and upgraded over time. Maximizing asset uptime and the reliability of physical infrastructure demands effective inventory management, spare parts forecasting, and supplier management. A utility that executes these processes effectively will outperform its peers, provide better returns for its investors and higher service levels for its customers, while reducing its environmental impact. […]
    • Centering Act Spare Parts Timing Pricing and ReliabilityCentering Act: Spare Parts Timing, Pricing, and Reliability
      In this article, we'll walk you through the process of crafting a spare parts inventory plan that prioritizes availability metrics such as service levels and fill rates while ensuring cost efficiency. We'll focus on an approach to inventory planning called Service Level-Driven Inventory Optimization. Next, we'll discuss how to determine what parts you should include in your inventory and those that might not be necessary. Lastly, we'll explore ways to enhance your service-level-driven inventory plan consistently. […]
    • 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. […]

      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

      Daily Demand Scenarios

      Daily Demand Scenarios

      In this Videoblog, we will explain how time series forecasting has emerged as a pivotal tool, particularly at the daily level, which Smart Software has been pioneering since its inception over forty years ago. The evolution of business practices from annual to more refined temporal increments like monthly and now daily data analysis illustrates a significant shift in operational strategies.

      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.

      Recent Posts

      • The Importance of Clear Service Level Definitions in Inventory ManagementThe Importance of Clear Service Level Definitions in Inventory Management
        Inventory optimization software that supports what-if analysis will expose the tradeoff of stockouts vs. excess costs of varying service level targets. But first it is important to identify how “service levels” is interpreted, measured, and reported. This will avoid miscommunication and the false sense of security that can develop when less stringent definitions are used. Clearly defining how service level is calculated puts all stakeholders on the same page. This facilitates better decision-making. […]
      • Future-Proofing Utilities. Advanced Analytics for Supply Chain OptimizationFuture-Proofing Utilities: Advanced Analytics for Supply Chain Optimization
        Utilities in the electrical, natural gas, urban water, and telecommunications fields are all asset-intensive and reliant on physical infrastructure that must be properly maintained, updated, and upgraded over time. Maximizing asset uptime and the reliability of physical infrastructure demands effective inventory management, spare parts forecasting, and supplier management. A utility that executes these processes effectively will outperform its peers, provide better returns for its investors and higher service levels for its customers, while reducing its environmental impact. […]
      • The Cost of Doing nothing with your inventory Planning SystemsThe Cost of Spreadsheet Planning
        Companies that depend on spreadsheets for demand planning, forecasting, and inventory management are often constrained by the spreadsheet’s inherent limitations. This post examines the drawbacks of traditional inventory management approaches caused by spreadsheets and their associated costs, contrasting these with the significant benefits gained from embracing state-of-the-art planning technologies. […]
      • Simple Inventory Optimization is Good Except When It Isn’t FHDSimple is Good, Except When It Isn’t
        In this blog, we are steering the conversation towards the transformative potential of technology in inventory management. The discussion centers around the limitations of simple thinking in managing inventory control processes and the necessity of adopting systematic software solutions. […]
      • Leveraging Epicor Kinetic Planning BOMs with Smart IP&O to Forecast Accurately HDLeveraging Epicor Kinetic Planning BOMs with Smart IP&O to Forecast Accurately
        In this blog, we explore how leveraging Epicor Kinetic Planning BOMs with Smart IP&O can transform your approach to forecasting in a highly configurable manufacturing environment. Discover how Smart, a cutting-edge AI-driven demand planning and inventory optimization solution, can simplify the complexities of predicting finished goods demand, especially when dealing with interchangeable components. Learn how Planning BOMs and advanced forecasting techniques enable businesses to anticipate customer needs more accurately, ensuring operational efficiency and staying ahead in a competitive market. […]

        Inventory Optimization for Manufacturers, Distributors, and MRO

        • Future-Proofing Utilities. Advanced Analytics for Supply Chain OptimizationFuture-Proofing Utilities: Advanced Analytics for Supply Chain Optimization
          Utilities in the electrical, natural gas, urban water, and telecommunications fields are all asset-intensive and reliant on physical infrastructure that must be properly maintained, updated, and upgraded over time. Maximizing asset uptime and the reliability of physical infrastructure demands effective inventory management, spare parts forecasting, and supplier management. A utility that executes these processes effectively will outperform its peers, provide better returns for its investors and higher service levels for its customers, while reducing its environmental impact. […]
        • Centering Act Spare Parts Timing Pricing and ReliabilityCentering Act: Spare Parts Timing, Pricing, and Reliability
          In this article, we'll walk you through the process of crafting a spare parts inventory plan that prioritizes availability metrics such as service levels and fill rates while ensuring cost efficiency. We'll focus on an approach to inventory planning called Service Level-Driven Inventory Optimization. Next, we'll discuss how to determine what parts you should include in your inventory and those that might not be necessary. Lastly, we'll explore ways to enhance your service-level-driven inventory plan consistently. […]
        • 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. […]