Instruction: Given the table below, complete the missing cell values applying the Exponential Smoothing method of forecasting and Mean Absolute Deviation. Answer also the other 3 related questions below the table. Numbers with decimals should take 2 decimal places. (.2 mark for each box or question)

Quarter	Actual Tonnage Unloaded	Forecast for = .2	Absolute Deviation for = .2	Forecast for = .5	Absolute Deviation for = .5
1	180	175	5.00	175	5.00
2	180				2.50
3	185	176.8	8.20	178.8	6.25
4	170	178.4	8.44	181.9	11.88
5	180	176.8	3.25	175.9	4.06
6	190	177.4	12.60	178.0	12.03
7	170	179.9	9.92	184.0	13.98
8	185	177.9	7.06	177.0	8.01
		Sum of absolute deviation =

Additional questions:

1.

What is the MAD for = .2?

Your answer:

Computation/solution:

Your final computed value:

2.

What is the MAD for = .5?

Your answer:

Computation/solution:

Your final computed value:

3.

Which smoothing constant would you prefer?