The Smart Forecaster

 Pursuing best practices in demand planning,

forecasting and inventory optimization

Demand planning takes time and effort. It’s worth the effort to the extent that it actually helps you make what you need when you need it.

But the job can be done well or poorly. We see many manufacturers stopping at the first level when they could easily go to the second level. And with a little more effort, they could go all the way to the third level, utilizing probabilistic modeling to convert demand planning results into an inventory optimization process.

The First Level

 

The first level is making a demand forecast using statistical methods. Figure 1 shows a first level effort: an item’s demand history (red line) and its expected 12-month forecast (green line).

 

 The first level: A forecast of expected demand over the next 12 months

 

The forecast is bare bones. It only projects expected demand ignoring that demand is volatile and will inevitably create forecast error. (This is another example of an important maxim: “The Average is Not the Answer”). The forecast is as likely to be too high as it is to be too low, and there is no indication of forecast uncertainty accompanying the forecast. This means the planner has no estimate of the risk associated with committing to the forecast. Still, this forecast does provide a rational basis for production planning, personal scheduling, and raw materials purchase. So, it’s much better than guessing.

The Second Level

 

The second level takes explicit account of forecast uncertainty. Figure 2 shows a second level effort, known as a “percentile forecast”.

Now we see an explicit indication of forecast uncertainty. The cyan line above the green forecast line represents the projected 90th percentile of monthly demand. That is, the demand in each future month has a 90% chance of falling at or below the cyan line. Put another way, there is a 10% chance of demand exceeding the cyan line in each month.

This analysis is much more useful because it supports risk management. If it is important to assure sufficient supply of this item, then it makes sense to produce to the 90th percentile instead of to the expected forecast. After all, it’s a coin flip as to whether the expected forecast will result in enough production to meet monthly demand. This second level forecast is, in effect, a rough substitute for a careful inventory management process.

 

A percentile forecast, where the cyan line estimates the 90th percentiles of monthly demand.

 

Figure 2. A percentile forecast, where the cyan line estimates the 90th percentiles of monthly demand.

Going All the Way to the Third Level

 

Best practice is the Third Level, which uses demand planning as a foundation for completing a second task: explicit inventory optimization. Figure 3 shows the fundamental plot for the efficient management of our finished good, assuming it has a 1 month production lead time.

 

Distribution of demand for finished good over its 1-month lead time

 

Figure 3 shows the utilization of probabilistic forecasting and how much draw-down in finished good inventory might take place over a one month production lead time. The uncertainty in demand is apparent in the spread of the possible demand, from a low of 0 to a high of 35, with 15 units being the most likely value. The vertical red line at 22 indicates the “reorder point“ (or “min” or “trigger value”) corresponding to keeping the chance of stocking out while waiting for replenishment to a low 5%. When inventory drops to 22 or below, it is time to order more. The Third Level uses probabilistic demand forecasting with full exposure of forecast uncertainty to efficiently manage the stock of the finished product.

To Sum Up

 

Forecasting the most likely demand for an item is a useful first step. It gets you halfway to where you want to be. But it provides an incomplete guide to planning because it ignores demand volatility and the forecast uncertainty that it creates. Adding a cushion to the demand forecast gets you further along, because it lessen the risk that a jump in demand will leave you short of product. This cushion can be calculated by probabilistic forecasting approaches that forecasts a high percentile of the distribution of future demand. And if you want to take one step further, you can feed forecasts of the demand distribution over a lead time to calculate reorder points (mins) to ensure that you have an acceptably low level of stock-out risk.

Given what modern forecasting technology can do for you, why would you want to stop halfway to your goal?

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

  • 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. […]
  • Smart Software Partnership with Sage for Inventory Optimization and Demand ForecastingSmart Software Announces Strategic Partnership with Sage for Inventory Optimization and Demand Forecasting
    Smart Software announces today their strategic partnership with Sage. This collaboration brings Smart IP&O (Inventory Planning and Optimization) into the latest cloud and on-premises versions of Sage X3, Sage 300, and Sage 100. […]
  • Head to Head Which Service Parts Inventory Policy is Best SoftwareHead to Head: Which Service Parts Inventory Policy is Best?
    Our customers have usually settled into one way to manage their service parts inventory. The professor in me would like to think that the chosen inventory policy was a reasoned choice among considered alternatives, but more likely it just sort of happened. Maybe the inventory honcho from long ago had a favorite and that choice stuck. Maybe somebody used an EAM or ERP system that offered only one choice. Perhaps there were some guesses made, based on the conditions at the time. […]
  • The Forecasting Process For Decision-MakersThe Forecasting Process for Decision-Makers
    In almost every business and industry, decision-makers need reliable forecasts of critical variables, such as sales, revenues, product demand, inventory levels, market share, expenses, and industry trends.Many kinds of people make these forecasts. Some are sophisticated technical analysts such as business economists and statisticians. Many others regard forecasting as an important part of their overall work: general managers, production planners, inventory control specialists, financial analysts, strategic planners, market researchers, and product and sales managers. Still, others seldom think of themselves as forecasters but often have to make forecasts on an intuitive, judgmental basis. […]
  • Success Story: Procon Pumps Uses Smart Demand Planner to Keep Business FlowingProcon Pumps Uses Smart Demand Planner to Keep Business Flowing
    Smart platform’s advanced analytics, and smooth integration with Procon’s ERP system led to accurate forecasts, and optimal inventory levels. […]

    Inventory Optimization for Manufacturers, Distributors, and MRO

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