Truth in Forecasting—Practical Advice at Year’s End

The Smart Forecaster

Pursuing best practices in demand planning,

forecasting and inventory optimization

At year’s end, we are often caught up in thinking and planning for the coming year. Did 2013 turn out the way you expected? Will 2014 be dramatically different? Are there other factors—things we are planning to do; things we think our competitors might do; outside forces like changing taste, demographics or economics—that might change the course of business in the coming year?

Most companies that do a formal forecast start out with a statistical projection of past sales patterns into the future. Your forecast model should detect and characterize any seasonality inherent in your markets and include that in the projection. But that’s just the first step.

The next thing to consider is product lifecycle. Nearly all products go through a predictable cycle of introduction, acceptance and growth, maturity (demand levels off) and finally decline to obsolescence. These cycles can be as short as weeks or as long as decades. Clothing fashions and consumer electronics would be on the shorter end of the scale, while products like plumbing fixtures and construction equipment would experience longer cycles. In specialized situations like bus fleet management, entire fleets may be replaced over defined transition periods. In any case, the demand forecast should be adjusted to reflect increasing or decreasing demand according to the product’s position in its lifecycle.

Now comes the hardest part—predicting the unpredictable. In general, the future is likely to look a lot like the recent past in a similarity to Newton’s first law of motion: a body in motion tends to stay in motion unless acted upon by an external force. But it’s those external forces that can send your carefully calculated forecast right into the gutter. A competitor might slash their prices to take away some of your market share. New technologies might obsolete your product before the end of its expected life span. Changing tastes or new regulations might stop sales in their tracks.

But good things might happen as well. You might be the one to slash prices or improve your product and take away a competitor’s business. Your product may catch the fancy of the market and sales will skyrocket. A competitor may abandon the business or go bankrupt, leaving you with more opportunity.

Should you plan for these kinds of things? Certainly, to the extent that you can. You may know when you’ll run promotions or phase in the next product line. But the future, by nature, is uncertain. History and your business knowledge of the past lay the foundation for your view of the future. Statistically-based tools can help you create a risk-adjusted forecast, with safety stock recommendations that correspond with the level of risk you are willing to take. Beyond this, your key to success is agility—the ability to adapt to changing conditions. Prepare the best forecast you can, build your plans around that forecast—then monitor sales and market conditions closely and continuously. Look for early warning that things may be going in a direction other than you predicted.

You must be willing to recognize and adapt to changing conditions—in other words, don’t fall in love with your forecast and ignore evidence that it may be wrong. Pride of authorship in this case can be deadly to the business.

It is also important to have contingency plans in place so you will be prepared to make the necessary changes to procurement, production and inventory to respond to the new estimate of demand. The best tools for this are the shortest possible lead times (both production and supplier), good supplier relationships and a clear view of the world and your markets.

Forecasting is difficult mainly because people know it is likely to be wrong and nobody likes to be publicly and visibly wrong. Nevertheless, a good forecast is necessary to position the resources necessary to satisfy customer demands. Just be open to the first signs of change and be prepared to react quickly and decisively.

Dave Turbide, CFPIM, CIRM, CSCP, CMfgE is a New Hampshire-based independent consultant and freelance writer. He can be reached via e-mail at dave at daveturbide dot com.

Leave a Comment

Related Posts

7 Digital Transformations for Utilities that will Boost MRO Performance

7 Digital Transformations for Utilities that will Boost MRO Performance

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.

Do your statistical forecasts suffer from the wiggle effect?

Do your statistical forecasts suffer from the wiggle effect?

What is the wiggle effect? It’s when your statistical forecast incorrectly predicts the ups and downs observed in your demand history when there really isn’t a pattern. It’s important to make sure your forecasts don’t wiggle unless there is a real pattern. Here is a transcript from a recent customer where this issue was discussed:

Recent Posts

  • professional technician engineer planning spare parts in industrial manufacturing factory,Prepare your spare parts planning for unexpected shocks
    In today's unpredictable business climate, we do have to worry about supply chain disruptions, long lead times, rising interest rates, and volatile demand. With all these challenges, it's never been more vital for organizations to accurately forecast parts usage, stocking levels, and to optimize replenishment policies such as reorder points, safety stocks, and order quantities. In this blog, we'll explore how companies can leverage innovative solutions like inventory optimization and parts forecasting software that utilize machine learning algorithms, probabilistic forecasting, and analytics to stay ahead of the curve and protect their supply chains from unexpected shocks. […]
  • Uncover data facts and improve inventory performanceUncover data facts and improve inventory performance
    The best inventory planning processes rely on statistical analysis to uncover relevant facts about the data. 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. […]
  • Electricity problems. Repairman is working indoors with Software for spare partsElectric Utilities’ Problems with Spare Parts
    Every organization that runs equipment needs spare parts. All of them must cope with issues that are generic no matter what their business. Some of the problems, however, are industry specific. This post discusses one universal problem that manifested in a nuclear plant and one that is especially acute for any electric utility. […]
  • Correlation vs Causation Relevant to your demand planning businessCorrelation vs Causation: Is This Relevant to Your Job?
    Outside of work, you may have heard the famous dictum “Correlation is not causation.” It may sound like a piece of theoretical fluff that, though involved in a recent Noble Prize in economics, isn’t relevant to your work as a demand planner. Is so, you may be only partially correct. […]
  • Downtown Miami skyline panorama and with software guided lights on at duskSmart Software Customer, Arizona Public Service to Present at USMA 2023
    Smart Software CEO and APS Inventory & Logistics Manager to present USMA 2023 Session on APS supply chain transformation project and the role of inventory optimization technology in their new process. […]

    Inventory Optimization for Manufacturers, Distributors, and MRO

    • professional technician engineer planning spare parts in industrial manufacturing factory,Prepare your spare parts planning for unexpected shocks
      In today's unpredictable business climate, we do have to worry about supply chain disruptions, long lead times, rising interest rates, and volatile demand. With all these challenges, it's never been more vital for organizations to accurately forecast parts usage, stocking levels, and to optimize replenishment policies such as reorder points, safety stocks, and order quantities. In this blog, we'll explore how companies can leverage innovative solutions like inventory optimization and parts forecasting software that utilize machine learning algorithms, probabilistic forecasting, and analytics to stay ahead of the curve and protect their supply chains from unexpected shocks. […]
    • Electricity problems. Repairman is working indoors with Software for spare partsElectric Utilities’ Problems with Spare Parts
      Every organization that runs equipment needs spare parts. All of them must cope with issues that are generic no matter what their business. Some of the problems, however, are industry specific. This post discusses one universal problem that manifested in a nuclear plant and one that is especially acute for any electric utility. […]
    • Worker maintenance industrial machine robotic Forecasting Spare PartsHow to Forecast Spare Parts with Low Usage
      What do you do when you are forecasting an intermittently demanded item, such as a spare part, with an average demand of less than one unit per month? Most of the time, the demand is zero, but the part is significant in a business sense; it can’t be ignored and must be forecasted to be sure you have adequate stock. […]
    • Spare Parts, Replacement Parts, Rotables, and Aftermarket PartsSpare Parts, Replacement Parts, Rotables, and Aftermarket Parts
      Those new to the parts planning game are often confused by the many variations in the names of parts. This blog points out distinctions that do or do not have operational significance for someone managing a fleet of spare parts and how those differences impact inventory planning. […]