Consumer Demand Forecasting: Popular Techniques, Part 4: Selecting the Optimal Method


Rating: 3 vote(s)
Author: Eyal Eckhaus, posted on 6/25/2010
, in category "Logistics"
Views: this article has been read 37856 times
Abstract:
There is a wide variety of forecasting techniques. How do we choose among them? This article introduces the topic and focuses on the mean absolute deviation (MAD) method, providing some numerical examples.
There is a wide variety of forecasting techniques. How do we choose among them? This article introduces the topic and focuses on the mean absolute deviation (MAD) method, providing some numerical examples.
1. Selecting the optimal method
Forecast evaluation is an important part of forecasting exercises, and selecting the optimal forecasting method depends on the case, such that a method appropriate for forecasting in one situation may be inappropriate in another. The decision should be based on factors such as forecast accuracy, cost, analyst expertise, software availability, the properties of the series being forecasted, the way the forecast will be used, and more [1].
For example, the moving average can be suited for a static demand level with irregular pattern and for C Pareto class items; regression analysis is suitable for a continuous trend with irregular pattern; and the exponential model is suitable for variable demand, gradual changing level, and slowmoving spares items [2].
2. Measure the forecast accuracy
The optimal forecasting method is often selected by accuracy [1]. Forecasts almost always have an error component, where the usual assessment procedure is to compare the forecast demand to actual demand as soon as it is known [3].
There are different methods to use as criteria for forecasting model selection. These include mean square error (MSE), mean absolute deviation (MAD), mean absolute percentage error (MAPE) [4, 5], mean absolute relative deviation (MARD), and fraction of accurate prediction (FAP) [6].
This article will describe the MAD technique, which is user friendly, easy to understand, and a good measure in practice [2], though when using MAD it may be beneficial to also compute an error measure of bias, such as mean error (ME), which provides the direction of error [7].
3. Mean absolute deviation (MAD)
MAD is a simple assessment of demand pattern variance, and is calculated as follows[2]: Mad = sum of absolute deviations from mean/ number of periods included in the sum. It is best explained by examples, as follows.
3.1 Moving average
Table 2 from article [9], demonstrate a moving average of 3 previous observations. By checking another amount of observations, forecast accuracy can be compared by MAD, as illustrated in Table 1, using two moving averages: 3 and 4 previous observations.
Table 1: Example of three and four moving averages, with MAD testing
Month  Demand (thousands)  Moving average of 3 previous observations  Absolute deviations from mean, 3 previous observation  Moving Average of 4 previous observations  Absolute deviations from mean, 4 previous observation 
1 
18 




2 
23 




3 
33 




4 
27 
24.67 
2.33 


5 
21 
27.67 
6.67 
25.25 
4.25 
6 
26 
27.00 
1.00 
26 
0 
7 
44 
24.67 
19.33 
26.75 
17.25 
8 
32 
30.33 
1.67 
29.5 
2.5 
9 
21 
34.00 
13.00 
30.75 
9.75 
10 
35 
32.33 
2.67 
30.75 
4.25 
11 
36 
29.33 
6.67 
33 
3 
MAD 


6.67 

5.86 
*
Editor's Note: generate your own moving average forecasts and MAD assessments
here
The example above illustrates a better result for a 4period moving average, indicated by MAD. The same way, the moving period may be increased in order to examine the optimal timeframe for the moving average technique.
3.2 Weighted moving average
Given Table 3 from [9], let’s check the number of observations that best measures accuracy.
Table 2: Example of three and four weighted moving averages, with MAD testing.
Month  Demand (thousands)  Weight  Demand × Weight  Moving average of 3 previous observations  Absolute deviations from mean, 3 previous observation  Moving Average of 4 previous observations  Absolute deviations from mean, 4 previous observation 
1 
18 
0.9 
16.2 




2 
23 
0.91 
20.93 




3 
33 
0.92 
30.36 




4 
27 
0.93 
25.11 
22.50 
4.50 


5 
21 
0.94 
19.74 
25.47 
4.47 
23.15 
27.00 
6 
26 
0.95 
24.7 
25.07 
0.93 
0.93 
2.15 
7 
44 
0.96 
42.24 
23.18 
20.82 
24.98 
1.97 
8 
32 
0.97 
31.04 
28.89 
3.11 
27.95 
19.02 
9 
21 
0.98 
20.58 
32.66 
11.66 
29.43 
4.05 
10 
35 
0.99 
34.65 
31.29 
3.71 
29.64 
8.43 
11 
36 
1 
36 
28.76 
7.24 
32.13 
5.36 
MAD 




7.06 

9.71 
The example above demonstrates a better result for a 3period moving average, indicated by MAD. The same way, the moving period may be increased in order to obtain the optimal timeframe for the moving average technique.
When comparing the two examples above, the unweighted moving average seems to be better. Therefore, the weight assigned may be changed to achieve a better result.
3.3 Exponential smoothing
Article [8], provides an example for exponential smoothing forecast with α=1. By choosing different values for α forecast accuracy may be compared with MAD as follows.
Table 3 contains the demand values from Table 2, and measures exponential smoothing forecast with three α values.
Table 3: Measuring exponential smoothing forecast with three α values
Month  Demand (thousands)  Forecast α=0.1  ForecastDemand  Forecast α=0.2  Forecast Demand  Forecast α=0.3  ForecastDemand 
1 
18 
18.00 

18.00 

18.00 

2 
23 
18.00 
5.00 
18.00 
5.00 
18.00 
5.00 
3 
33 
18.50 
14.50 
19.00 
14.00 
19.50 
13.50 
4 
27 
19.95 
7.05 
21.80 
5.20 
23.55 
3.45 
5 
21 
20.66 
0.34 
22.84 
1.84 
24.59 
3.58 
6 
26 
20.69 
5.31 
22.47 
3.53 
23.51 
2.49 
7 
44 
21.22 
22.78 
23.18 
20.82 
24.26 
19.74 
8 
32 
23.50 
8.50 
27.34 
4.66 
30.18 
1.82 
9 
21 
24.35 
3.35 
28.27 
7.27 
30.73 
9.73 
10 
35 
24.01 
10.99 
26.82 
8.18 
27.81 
7.19 
11 
36 
25.11 
10.89 
28.46 
7.54 
29.97 
6.03 
MAD 


8.87 

7.80 

7.25 
Table 3 demonstrates a better result for α=0.3, as indicated by MAD. The same way, the exponential smoothing forecast may be measured with different values for α.
From the three examples, the simple moving average of four previous observations appears to provide the best results.
4. Summary
There is a wide range of forecasting methods, and techniques to choose from, some of which require statistical knowledge and expertise. The article presented the topic and provided some indepth numerical examples for the mean absolute deviation method, a common and easy to understand technique.
This is the forth in the article set of forecasting techniques:
Part 1 introduces the demand forecasting issue, and demonstrated the weighted and unweighted moving average technique
Part 2 demonstrates the simple exponential smoothing technique.
Part 3 presents regression analysis.
4.1 Some thoughts on processes and leadership responsibility
Forecasting is used in many domains. Today’s competitive environment forces organizations to excel in their domain, and continuously innovate and advance with the aid of technology [10]. The success of companies in implementing promising strategies and new tactics [11, 12], largely depends not only on efficient processes [13], but also on leadership and management style [1416]. Organization’s leadership and the Top Management Team (TMT) is responsible to work culture in the organization, giving room for social interactions [17], affecting workers happiness [18], which in turn may also affect the company’s stock price [19].
Bibliography
 Chatfield, C., TimeSeries Forecasting 2000: Chapman and Hall/CRC. Chapter 6.
 Wild, T., Best practices in inventory management 1997: Chapters 6,10. Wiley publication.
 Lawrence, F.B., Closing the logistics loop: A tutorial. Production and Inventory Management Journal, 1999. 40(1): p. 4351.
 Teunter, R.H. and L. Duncan., Forecasting intermittent demand: a comparative study.The Journal of the Operational Research Society, 2009. 60(3): p. 321329.
 Swanson, N.R. and T. Zeng., Choosing among competing econometric forecasts: Regressionbased forecast combination using model selection. Journal of Forecasting, 2001. 20(6): p. 425440.
 Lee, J.C. and S.L. Tsao, On estimation and prediction procedures for AR(1) models with power transformation. Journal of Forecasting, 1993. 12(6): p. 499.
 Sanders, N.R., Measuring forecast accuracy: Some practical suggestions. Production and Inventory Management Journal, 1997. 38(1): p. 4346.
 Eckhaus, E. (2010, June 25). Consumer Demand Forecasting: Popular Techniques, Part 2: Exponential Smoothing. Retrieved June 25, 2010 from http://www.purchasesmarter.com/articles/120
 Eckhaus, E. (2010, June 24). Consumer Demand Forecasting: Popular Techniques, Part 1: Weighted and Unweighted Moving Average. Retrieved June 24, 2010 from http://www.purchasesmarter.com/articles/118
 Eckhaus, E., Towards tourism business change. Review of International Comparative Management / Revista De Management Comparat International, 2017. 18(3): p. 274286.
 Eckhaus, E., G. Klein, and J. Kantor, Experiential learning in management education. Business, Management and Education, 2017. 15(1): p. 4256.
 Eckhaus, E., Barter trade exchange to the rescue of the tourism and travel industry. Journal of Shipping and Ocean Engineering, 2011. 1(2): p. 133140.
 Eckhaus, E., K. Kogan, and Y. Pearlman, Enhancing strategic supply decisions by estimating suppliers’ marginal costs. Journal of Supply Chain Management 2013. 49(4): p. 96107
 Eckhaus, E., A shift in leadership. Academy of Strategic Management Journal, 2017. 16(1): p. 1931.
 Eckhaus, E. and Z. Sheaffer, Managerial hubris detection: the case of Enron. Risk Management, 2018: Published online at https://doi.org/10.1057/s4128301800370
 Klein, G. and E. Eckhaus, Sensemaking and sensegiving as predicting organizational crisis. Risk Management, 2017. 19(3): p. 225244.
 Batia, B.H. and Eckhaus, E, The different impact of personal social capital and intraorganizational SC: The Enron case study. International Journal of Organization Theory & Behavior, 2018. 21(1): p. 2847.
 Eckhaus, E., Measurement of Organizational Happiness, In J. Kantola, T. Barath, & S. Nazir (Eds.), Advances in Human Factors, Business Management and Leadership. AHFE 2017. Advances in Intelligent Systems and Computing (Vol. 594, pp. 266278). Cham: Springer International Publishing.
 Eckhaus, E., Corporate transformational leadership's effect on financial performance. Journal of Leadership, Accountability and Ethics, 2016. 13(1): p. 90102
copyright © Purchasesmarter.com. All rights reserved. The material may not be published, rewritten, broadcast, or redistributed. Any reproduction in whole or part by and individuals or organizations will be held liable for copyright infringement to the full extent of the law.
Rate