Mike Gilliland: The BFD

Our ability to forecast was met with increasing skepticism in 2010 – and this is a good thing.  A decade ago, the thrill of technological innovation provided hope that more data, bigger computers, and fancier models would one day solve all our forecasting problems.  Yet we now have more data, bigger computers, and fancier models than ever before – and our forecasting challenges remain.  Is there no hope?

While we’ve acquired a healthy skepticism this past year, we’ve also come to recognize that some things are forecastable to a reasonable degree of accuracy – and some things are not (at least not to the degree of accuracy desired).  For behaviors that are amenable to statistical forecasting methods, we can focus on automatic model building, and the overall efficiency of our forecasting process. 

Methods like Forecast Value Added analysis allow us to streamline our forecasting efforts by identifying the waste and non-value adding activities in our process.  (The goal being to generate forecasts as accurate as they can reasonably be expected to be, and doing this as efficiently as possible.)  Sales and Operations Planning, with growing adoption and better execution, helps mesh a demand forecast with supply capabilities.  Visibility to demand/supply imbalance, provided through S&OP, lets management act in ways that are most beneficial to the health of the organization – by better (and more profitably) serving its customers.

For behaviors that are not amenable to statistical forecasting methods, recognition of this “unforecastability” is a key first step.  We wisely do not apply super-human efforts to forecast Heads or Tails in the tossing of a fair coin, because we recognize the randomness and our inability to improve upon a simple guess.  In the business world, when we cannot expect an accurate forecast of customer demand behavior, there are still many things we can do so solve the business problem.  These “alternative approaches” just may not involve forecasting.

Supply chain re-engineering is a well-recognized method for reducing an organization’s reliance on highly accurate forecasts.  When a supply chain is more flexible and responsive, it can react to demand as it occurs.  Postponement strategies, where final configuration or packaging of finished product is delayed until the demand signal is received, is one way to accomplish this.

Demand smoothing is an approach for reducing volatility in demand patterns.  Organizational policies and practices, like the quarter end “push,” or ill-designed pricing or promotional activities, can create demand behavior that is more erratic – and therefore more difficult to forecast.  The demand smoothing approach looks for ways to encourage more stable, more forecastable, and (likely) more profitable demand from your customers.

Finally, the pruning of extremely low volume items can lead to surprising growth for the products that remain.  All organizations eventually have their dead weight – those aging products near the end of their lifecycle, or newer products that never caught on.  Rather that encumbering the sales force, ordering systems, warehouse pallet spaces, planning systems, and (most costly) management time dealing with such products, it is often best to just get rid of them.  A CPG manufacturer was able to cut 25% of its product portfolio that accounted for only 0.5% of total sales the previous 12 months.  An apparel manufacturer found that 50% of its items account for only 1% of sales.  A simple Pareto chart (ranking items by volume or revenue) can reveal the opportunity at your organization.

The growing recognition of the limits of forecasting can lead to benefits in two ways.  For the “forecastable” products, attention can be focused on automation and efficiency of the forecasting process – and not wasting effort pursuing unachievable levels of accuracy.  For “unforecastable” products, alternative approaches can help solve the business problem without reliance on better forecasts.  Just because we are forecasters does not mean we can solve every business problem “if we just had a better model.”  As forecasters we can help organizational performance by bringing these issues to management, and guiding them to the right decisions.

Mike is author of The Business Forecasting Deal, serves on the IBF Advisory Board, and moderates IBF’s annual Demand Management Forum at the spring Best Practices Conference (this year in Dallas, May 4-6, 2011).  His blog The Business Forecasting Deal helps expose the myths, the frauds, and the worst practices in business forecasting, while providing practical solutions to its most vexing problems.