Question 1 contains the actual values for 12 periods (listed in order, 1-12). In
ID: 3056712 • Letter: Q
Question
Question 1 contains the actual values for 12 periods (listed in order, 1-12). In Excel, create forecasts for periods 6-13 using each of the following methods: 5 period simple moving average; 4 period weighted moving average (0.63, 0.26, 0.08, 0.03); exponential smoothing (alpha = 0.23 and the forecast for period 5 = 53); linear regression with the equation based on all 12 periods; and quadratic regression with the equation based on all 12 periods. Round all numerical answers to two decimal places.
The actual values for 12 periods (shown in order) are:
(1) 45 (2) 52 (3) 48 (4) 59 (5) 55 (6) 54 (7) 64 (8) 59 (9) 72 (10) 66 (11) 67 (12) 78
(A) Using a 5 period simple moving average, the forecast for period 13 will be:
(B) Using the 4 period weighted moving average, the forecast for period 13 will be:
(C) With exponential smoothing, the forecast for period 13 will be:
(D) With linear regression, the forecast for period 13 will be:
(E) With quadratic regression, the forecast for period 13 will be:
(F) Considering only the forecasts for period 6-12, what is the lowest MAD value for any of the methods?
Explanation / Answer
(A) Using a 5 period simple moving average, the forecast for period 13 will be:
Forecast for period 13 = (59+72+66+67+78) / 5 = 68.4
(B) Using the 4 period weighted moving average, the forecast for period 13 will be:
Forecast for period 13 = 0.63*72 + 0.26*66 + 0.08*67 + 0.03*78 = 70.22
(C) With exponential smoothing, the forecast for period 13 will be:
Formula : St+1=0.23*yt+(1 - 0.23)*St ,t>0.
Here, S5 = 53.
S6 = 0.23*55 + (1-0.23)*53
S7 = 0.23*54 + (1-0.23)*S6 and so on. ]
Period
Values
5-period MA forecasts
Exponential Smoothing
1
45
2
52
3
48
4
59
5
55
53
6
54
51.8
53.46
7
64
53.6
53.5842
8
59
56
55.97983
9
72
58.2
56.67447
10
66
60.8
60.19934
11
64
63
61.53349
12
78
65
62.0981
13
67.8
65.76
(D) With linear regression, the forecast for period 13 will be:
Values = 2.486*period + 43.75
Putting Period = 13, we get the required value = 76.068
PS : We are directed to solve only the first question when multiple questions are posted or the first 4 parts when multiple parts of the same question are posted.
Period
Values
5-period MA forecasts
Exponential Smoothing
1
45
2
52
3
48
4
59
5
55
53
6
54
51.8
53.46
7
64
53.6
53.5842
8
59
56
55.97983
9
72
58.2
56.67447
10
66
60.8
60.19934
11
64
63
61.53349
12
78
65
62.0981
13
67.8
65.76
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.