The Average is Not the Answer

The Smart Forecaster

Pursuing best practices in demand planning,

forecasting and inventory optimization

Fluctuations in an inventory supply chain are inevitable. Randomness, which can be a source of confusion and frustration, guarantees it. A ship carrying goods from China may be delayed by a storm at sea. A sudden upswing in demand one day can wipe out inventory in a single day, leaving you unable to meet the next day’s demand. Randomness creates frictions that make it hard to do your job.

At first blush, it sometimes seems best to respond to randomness with the ostrich approach: head buried in the sand. You can settle on a prediction and proceed on the assumption that the prediction will always be spot on. The flaw in that approach is that it ignores statistical methods that allow us to make use of a wealth of knowledge about our knowledge itself—how confident we can be in our predictions, and what breadth of possibilities confront us. The efficient approach to tackling the problems that stem from randomness is not to ignore uncertainty, but to embrace it with eyes open.

As a fundamental tenet of Smart Software’s approach to forecasting, we will always provide you with an assessment of the level of uncertainty in forecasts. If you are expecting nothing more than an absolute figure—the demand for widgets in February will be 120 units—you may dismiss the added element of uncertainty as a negative, or lose faith in a forecast you had hoped would be definite. But we argue for what we consider the adult approach; you need to know what you are risking when you commit to a forecast and premise your decision-making upon it.

Your forecasts can have big consequences that go beyond inventory stocking levels. They can determine your raw materials needs or staffing levels—forecasts drive many important resource allocation decisions. If you have too much faith in the most likely outcome, without also specifically considering just how likely it is, you aren’t really understanding the risks you face, and you may put yourself in a precarious position.

The need to make fully informed decisions forces us to see, in a forecast, the plus/minus range of results with a certain likelihood of occurring. In the specific case of forecasts that are going into inventory systems, this is an important part of deliberately planning for contingencies. This is how you determine not only the inventory you need to maintain in order to satisfy typical demand, but also the additional inventory you need on hand to deal with most unexpected outcomes.

This importance only increases when you are trying to maintain a reliable store of critical spare parts. Between the cost of stocking additional inventory, and accounting for the degree of reliability in your forecasts, there is a balance that crystallizes when an airplane that you need in the air is grounded—because you don’t have the replacement for a damaged part.

(While stocking extra inventory relies on the high end of the uncertainty range, if cash flow is tight, it’s the low end of the range that becomes important. Treasury-minded users find value in this other side of uncertainty in scenarios where even minimal overstocking can be more of a problem than a missed sales opportunity, for example. Reliable information about the lowest likely outcomes pays off at this time.)

Inventory theory says that you need to think about the outer ends of likely possibilities and prepare to cope with more scenarios than just what is most likely. Randomness is a reality that can’t be ignored. The average is not the answer.

Thomas Willemain, PhD, co-founded Smart Software and currently serves as Senior Vice President for Research. Dr. Willemain also serves as Professor Emeritus of Industrial and Systems Engineering at Rensselaer Polytechnic Institute and as a member of the research staff at the Center for Computing Sciences, Institute for Defense Analyses.

Leave a Comment

Related Posts

Looking for Trouble in Your Inventory Data

Looking for Trouble in Your Inventory Data

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.

Can Randomness be an Ally in the Forecasting Battle?

Can Randomness be an Ally in the Forecasting Battle?

When we try to understand the complex world of logistics, randomness plays a pivotal role. This introduces an interesting paradox: In a reality where precision and certainty are prized, could the unpredictable nature of supply and demand actually serve as a strategic ally?
The quest for accurate forecasts is not just an academic exercise; it’s a critical component of operational success across numerous industries. For demand planners who must anticipate product demand, the ramifications of getting it right—or wrong—are critical. Hence, recognizing and harnessing the power of randomness isn’t merely a theoretical exercise; it’s a necessity for resilience and adaptability in an ever-changing environment.

The Objectives in Forecasting

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

Recent Posts

  • Epicor AI Forecasting and Inventory Technology Combined with Planner Knowledge for InsightsSmart Software to Present at Epicor Insights 2024
    Smart Software will present at this year's Epicor Insights event in Nashville. If you plan to attend this year, please join us at booth #13 or #501, and learn more about Epicor Smart Inventory Planning and Optimization. . […]
  • Looking for Trouble in Your Inventory DataLooking for Trouble in Your Inventory Data
    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. […]
  • BAF Case Study SIOP planning Distribution CenterBig Ass Fans Turns to Smart Software as Demand Heats Up
    Big Ass Fans is the best-selling big fan manufacturer in the world, delivering comfort to spaces where comfort seems impossible. BAF had a problem: how to reliably plan production to meet demand. BAF was experiencing a gap between bookings forecasts vs. shipments, and this was impacting revenue and customer satisfaction BAF turned to Smart Software for help. […]
  • 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. […]
  • Randomness can be an Ally in the Forecasting BattleCan Randomness be an Ally in the Forecasting Battle?
    When we try to understand the complex world of logistics, randomness plays a pivotal role. This introduces an interesting paradox: In a reality where precision and certainty are prized, could the unpredictable nature of supply and demand actually serve as a strategic ally? The quest for accurate forecasts is not just an academic exercise; it's a critical component of operational success across numerous industries. For demand planners who must anticipate product demand, the ramifications of getting it right—or wrong—are critical. Hence, recognizing and harnessing the power of randomness isn't merely a theoretical exercise; it’s a necessity for resilience and adaptability in an ever-changing environment. […]

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