1. All forecasts should be rounded to an integer number (regular rounding). Use Excel to do your computations. Each part of the problem should be on a different Excel Sheet/Tab.

Part (a) Use the 6-period moving average method to forecast for these data and for the first six months of the third year. Compute MSD/E, MAD, MAPE, and Bias.

Month (t)	Model 3 A(t)
1	148
2	125
3	78
4	53
5	25
6	29
7	9
8	68
9	84
10	110
11	147
12	120
13	147
14	109
15	96
16	70
17	42
18	36
19	34
20	28
21	71
22	102
23	103
24	144