The Smart Forecaster

 Pursuing best practices in demand planning,

forecasting and inventory optimization

​As the world holds its breathe to see how the new corona virus (2019-nCOV) will play out, we cross our fingers for all those currently in quarantine or under treatment and pray that health authorities around the world will soon get the upper hand.

This short note is about one way your business can develop a plan to adjust to one of the likely fallouts from the virus: sudden increases in the time it takes to get inventory replenishment from suppliers. Supply chains around the world are being disrupted. If this happens to you, how can you react in a systematic way?

Reacting to Longer Lead Times

This is a problem that can be solved using advanced supply chain analytics. Presumably, you may have already used this technology to make good choices for the control parameters used in managing all your inventory items, e.g., values for Min and Max or Reorder Point and Order Quantity. The specific technical question addressed here is how to convert an increase in replenishment lead time to changes in those control parameters.

In general, longer lead times require fatter inventories if you want to maintain a high level of customer service. This general rule translates into larger values of Min and/or Max. How much larger depends critically on what new, longer lead time values will appear and their probabilities of occurring.

While many planning software systems assume a fixed lead time, the reality is that almost all lead times have some degree of randomness. Typically, ignoring that randomness increases stockout risk, so having a good estimate of the probability distribution of lead times is important. In normal times, your transactional data can be used to estimate that relationship. But sudden disruptions like 2019-nCOV create unprecedented situations in which you have to make educated guesses about what new delays you will see and how likely they are. We will assume here that you can imagine some such scenarios and want to figure out how to best respond to them.

An Example using Advanced Software

To illustrate this type of prospective planning, consider a hypothetical example. One item, a spare part, has an established pattern of replenishment lead times, with delays of 5, 10 and 15 days occurring with 15%, 70% and 15% probabilities, respectively. Given this distribution and a random demand averaging one unit every 5 days, values of Min = 5 and Max = 10 do a good job. Figure 1 shows a simulation of 10 years of daily operation under this scenario. Fill rate and service level are high, and stockouts are infrequent.

Now suppose that disruptions in the supply chain create a less favorable distribution of lead time, with a 50:50 mix of 15 and 30 days. Figure 2 shows how badly the current values of Min and Max perform in this new scenario. Fill rate and service level plummet due to frequent stockouts. Operating costs more than triple due to penalties for backorders. Only inventory investment (the average dollar value of stock on the shelf) seems to get better, but this happens only because so often there are backorders with nothing left on the shelf. The shift to longer lead times clearly requires new higher values of Min and Max.

Figure 3 shows how the system performs when the Min is increased from 5 to 10 and the Max from 10 to 15. This change compensates for the longer lead times, restoring the previous high levels of fill rate and service level. Inventory investment is necessarily greater, but operating costs are actually lower than before.

Summary

Changes in normal operating conditions require adjustments in the way inventory items are managed. One such change looming large on this date is the potential impact of the 2019-nCOV Corona virus on supply chains, with anticipated increases in replenishment lead times.

Changes in lead times require changes in inventory control parameters such as Min’s and Max’s. These changes are difficult to make with any confidence using pure guesswork. But with some estimate of the increase in lead times, you can use advanced software to learn how to make these adjustments with some confidence.

This note illustrates this point using simulations of the daily operation of an inventory control system.

Figure 1 Simulation of normal operations using current replenishment lead times, Min and Max

Figure 2 Simulation of abnormal operations using longer lead times and current Min and Max

Figure 3 Simulation of abnormal operations using longer lead times and revised Min and Max

Leave a Comment

Related Posts

Overcoming Uncertainty with Service and Inventory Optimization Technology

Overcoming Uncertainty with Service and Inventory Optimization Technology

In this blog, we will discuss today’s fast-paced and unpredictable market and the constant challenges businesses face in managing their inventory and service levels efficiently. The main subject of this discussion, rooted in the concept of “Probabilistic Inventory Optimization,” focuses on how modern technology can be leveraged to achieve optimal service and inventory targets amidst uncertainty. This approach not only addresses traditional inventory management issues but also offers a strategic edge in navigating the complexities of demand fluctuations and supply chain disruptions.

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.

The Cost of Spreadsheet Planning

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

Recent Posts

  • Overcoming Uncertainty with Service and Inventory Optimization TechnologyOvercoming Uncertainty with Service and Inventory Optimization Technology
    In this blog, we will discuss today's fast-paced and unpredictable market and the constant challenges businesses face in managing their inventory and service levels efficiently. The main subject of this discussion, rooted in the concept of "Probabilistic Inventory Optimization," focuses on how modern technology can be leveraged to achieve optimal service and inventory targets amidst uncertainty. This approach not only addresses traditional inventory management issues but also offers a strategic edge in navigating the complexities of demand fluctuations and supply chain disruptions. […]
  • Daily Demand Scenarios Smart 2Daily 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. […]
  • 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. […]
  • Learning from Inventory Models Software AILearning from Inventory Models
    In this video blog, the spotlight is on a critical aspect of inventory management: the analysis and interpretation of inventory data. The focus is specifically on a dataset from a public transit agency detailing spare parts for buses. […]
  • The methods of forecasting SoftwareThe Methods of Forecasting
    Demand planning and statistical forecasting software play a pivotal role in effective business management by incorporating features that significantly enhance forecasting accuracy. One key aspect involves the utilization of smoothing-based or extrapolative models, enabling businesses to quickly make predictions based solely on historical data. This foundation rooted in past performance is crucial for understanding trends and patterns, especially in variables like sales or product demand. Forecasting software goes beyond mere data analysis by allowing the blending of professional judgment with statistical forecasts, recognizing that forecasting is not a one-size-fits-all process. This flexibility enables businesses to incorporate human insights and industry knowledge into the forecasting model, ensuring a more nuanced and accurate prediction. […]

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

      There is a way your business can develop a plan to adjust increasing Demand. Cloud computing companies with unique server and hardware parts, e-commerce, online retailers, home and office supply companies, onsite furniture, power utilities, intensive assets maintenance or warehousing for water supply companies have increased their activity during the pandemic.Delivery service companies, cleaning services, liquor stores and canned or jarred goods warehouses, home improvement stores, gardening suppliers, yard care companies, hardware, kitchen and baking supplies stores, home furniture suppliers with high demand are facing stockouts, long lead times, inventory shortage costs, higher operating costs and ordering costs. Garages selling car parts and truck parts, pharmaceuticals, healthcare or medical supply manufacturers and safety product suppliers are dealing with increasing demand.