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

Call an Audible to Proactively Counter Supply Chain Noise

Call an Audible to Proactively Counter Supply Chain Noise

You know the situation: You work out the best way to manage each inventory item by computing the proper reorder points and replenishment targets, then average demand increases or decreases, or demand volatility changes, or suppliers’ lead times change, or your own costs change.

Recent Posts

  • Epicor Prophet 21 with Forecasting Inventory PlanningExtend Epicor Prophet 21 with Smart IP&O’s Forecasting & Dynamic Reorder Point Planning
    Smart Inventory Planning & Optimization (Smart IP&O) can help with inventory ordering functionality in Epicor P21, reduce inventory, minimize stockouts and restore your organization’s trust by providing robust predictive analytics, consensus-based forecasting, and what-if scenario planning. […]
  • Supply Chain Math large-scale decision-making analyticsSupply Chain Math: Don’t Bring a Knife to a Gunfight
    Math and the supply chain go hand and hand. As supply chains grow, increasing complexity will drive companies to look for ways to manage large-scale decision-making. Math is a fact of life for anyone in inventory management and demand forecasting who is hoping to remain competitive in the modern world. Read our article to learn more. […]
  • Mature bearded mechanic in uniform examining the machine and repairing it in factoryService Parts Planning: Planning for consumable parts vs. Repairable Parts
    When deciding on the right stocking parameters for spare and replacement parts, it is important to distinguish between consumable and repairable servoce parts. These differences are often overlooked by inventory planning software and can result in incorrect estimates of what to stock. Different approaches are required when planning for consumables vs. repairable service parts. […]
  • Four Common Mistakes when Planning Replenishment TargetsFour Common Mistakes when Planning Replenishment Targets
    How often do you recalibrate your stocking policies? Why? Learn how to avoid key mistakes when planning replenishment targets by automating the process, recalibrating parts, using targeting forecasting methods, and reviewing exceptions. […]
  • Smart Software is pleased to introduce our series of webinars, offered exclusively for Epicor Users.Extend Epicor Kinetic’s Forecasting & Min/Max Planning with Smart IP&O
    Epicor Kinetic can manage replenishment by suggesting what to order and when via reorder point-based inventory policies. The problem is that the ERP system requires that the user either manually specify these reorder points, or use a rudimentary “rule of thumb” approach based on daily averages. In this article, we will review the inventory ordering functionality in Epicor Kinetic, explain its limitations, and summarize how to reduce inventory, and minimize stockouts by providing the robust predictive functionality that is missing in Epicor. […]

    Inventory Optimization for Manufacturers, Distributors, and MRO

    • Blanket Orders Smart Software Demand and Inventory Planning HDBlanket Orders
      Our customers are great teachers who have always helped us bridge the gap between textbook theory and practical application. A prime example happened over twenty years ago, when we were introduced to the phenomenon of intermittent demand, which is common among spare parts but rare among the finished goods managed by our original customers working in sales and marketing. This revelation soon led to our preeminent position as vendors of software for managing inventories of spare parts. Our latest bit of schooling concerns “blanket orders.” […]
    • Hand placing pieces to build an arrowProbabilistic Forecasting for Intermittent Demand
      The New Forecasting Technology derives from Probabilistic Forecasting, a statistical method that accurately forecasts both average product demand per period and customer service level inventory requirements. […]
    • Engineering to Order at Kratos Space – Making Parts Availability a Strategic Advantage
      The Kratos Space group within National Security technology innovator Kratos Defense & Security Solutions, Inc., produces COTS s software and component products for space communications - Making Parts Availability a Strategic Advantage […]
    • wooden-figures-of-people-and-a-magnet-team-management-warehouse inventoryManaging the Inventory of Promoted Items
      In a previous post, I discussed one of the thornier problems demand planners sometimes face: working with product demand data characterized by what statisticians call skewness—a situation that can necessitate costly inventory investments. This sort of problematic data is found in several different scenarios. In at least one, the combination of intermittent demand and very effective sales promotions, the problem lends itself to an effective solution. […]