Sales Forecasting A Practical Guide Author:Mark Blessington Millions of sales forecasts are made by hundreds of thousands of people every year. Forecasts are made for every product and sales territory in the world at least annually. Then there are are various aggregations, from product to product line to division or from territory to district to region. Employees and managers from multiple departments (e... more ».g., sales, marketing, finance, manufacturing) are often involved.
Sales Forecasting is a practical guide for beginning and intermediate sales forecasters. The book breaks new ground and is designed around the learning curve. The author's experience in day trading, along with decades of sales and marketing consulting, taught him the essential ingredients of sales forecasting. These are provided in Part 1 of the book.
The first and most important skill is error measurement. The author makes a clear declaration about the best method and demonstrates its use throughout the book. The book does not use complex formulas. Instead, it is designed around the sales forecasting learning curve.
The sad truth is that few forecasters have any formal education or training on the subject. Part of this is because most forecasting books use numerous complex formulas, which are arcane, intimidating and off-putting. Another reason is that sales forecasters are encouraged to place too much trust in forecasting software by vendors who tend to make exaggerated and unsubstantiated claims about forecasting accuracy. The second skill is testing, and the author demonstrates how to divide historical sales data into in- and out-samples, calibrate models on the in-sample, and assess model accuracy by forecasting the out-sample. The third and fourth skills are avoiding linear extensions and mastering exponential smoothing. Part 1 is concluded with a description of the whole forecasting process and what is called "five-step forecasting." Part 2 moves into intermediate forecasting. Leading software packages are assessed through the author's research. Very little is published on forecasting software assessment, so this chapter plays an important role. Then ARIMA and ARIMAX are taught and demonstrated through multiple examples. These two methods, combined with exponential smoothing, form the foundation of intermediate forecasting. Perhaps the most exciting chapters in Part 2 involve aggregation. This is a rapidly growing field. The author identifies some important gaps in the area, then fills them with his own research. Anyone involved in sales forecasting can benefit from these important findings. A chapter is dedicated to demonstrating the application of sound forecasting techniques to product planning and quota setting. It becomes quite clear that traditional methods generate far more error than the sales forecasting techniques taught in this book. The author also examines the topic of handicapping, or determining how much confidence to place on a forecast. He introduces the concept of "true confidence ranges" and also demonstrates the application of Bayesian probabilities to sales forecasting. To conclude the book, the author explores economic forecasting and closes with a discussion of common forecasting pitfalls to be avoided at all costs.« less