Forecasting: Moving Averages, Exponential Smoothing
A. Use 5 period moving average (MA n=5) to compute the forecasts of sales for months 6 to 20 and a 7 period moving average (MA n=7) to compute forecasts for months 8 to 20.
b. Use an exponential smoothing approach with a smoothing constant alpha =0.2 to forecast sales for month 2 to 20. Change alpha to 0.1. Does this make the forecast better or worse? (calculate the MSD and compare their MSD Explain. Assume that the forecast for month 2 is 22 (same as first month's sales)
c. Find alpha that minimizes the MSD. (using solver)
Data:
Month Sales
1 22
2 21
3 24
4 30
5 25
6 25
7 33
8 40
9 36
10 39
11 50
12 55
13 44
14 48
15 55
16 47
17 61
18 58
19 55
20 60
Please see the attached file for full problem description including data chart.
© BrainMass Inc. brainmass.com February 24, 2021, 2:30 pm ad1c9bdddfhttps://brainmass.com/statistics/central-tendency/forecasting-moving-averages-exponential-smoothing-24924
Solution Summary
Forecasts using moving average, exponential smoothing and finds alpha that minimizes the MSD.