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)

~ 35% (

Quarter

1

2

3

5

6

7

8

Actual Tonnage

Unloaded

180

180

185

170

180

190

170

185

Forecast for

a = .2

175

176.8

178.4

176.8

177.4

179.9

177.9

Sum of absolute deviation

Absolute Deviation

for a = .2

5.00

8.20

8.44

3.25

12.60

9.92

7.06

Forecast for

a = .5

175

178.8

181.9

175.9

178.0

184.0

177.0

Absolute Deviation

for a = .5

5.00

2.50

6.25

11.88

4.06

12.03

13.98

8.01

Additional questions:

1. What is the MAD for a = .2?

Your answer:

Computation/solution:

Your final computed value:

2. What is the MAD for a = .5?

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) Additional questions: 1. What is the MAD for a=,2 ? Your answer: Computation/solution: Your final computed value 2. What is the MAD for a=.5