Q1

Use the below data to calculate the below and match it to the appropriate answer.

a) 4-month weighted forecast for period 13, using weights of .40 for the most recent period, .30 for the following most recent, .20 for the next, and .10 for the next. (5 Marks)

b) 3-month forecast for period 13 (5 Marks)

c) Exponential Smoothing using a forecast for period 1 of 1658 and a= 0.15 (5 Marks)

Period	Actual	forecast
1	1811	1658
2	1297
3	1111
4	1335
5	1592
6	1562
7	1494
8	1595
9	1730
10	1442
11	1607
12	1420

Using the exponential smoothing forecast in the last question, calculate forecasting errors and match below to the corresponding answers.

a) MAD

b) MAPE

c) TS

d) MSE

Note you are still using the same data in question 1. In case you haven't saved the calculations, below is the data.

Period	Actual	forecast
1	1811	1658
2	1297
3	1111
4	1335
5	1592
6	1562
7	1494
8	1595
9	1730
10	1442
11	1607
12	1420