Quarterly Cash donations (in thousands of dollars) at the SDA Mission for 2004-2006 were as shown in the following table.

Quarterly Cash donations (in thousands of dollars) at the SDA Mission for 2004-2006 were as shown in

the following table.

Period Value

1 242

2 282

3 254

4 345

5 253

6 290

7 262

8 352

9 270

10 286

11 271

12 378

a) Using a weighted moving average with three periods, determine the donations for period 13. Use 3, 2,

and 1 for the weights of the most recent, second most recent, and third most recent periods, respectively

b) Use exponential smoothing with a smoothing constant of 0.20 to forecast the donations (Assume that

last period's forecast for period 1 is equal to actual to begin the procedure(Ft1=Yt1). Which method do you think

is best? Is this an improvement over the weighted average- use MAD only ( Six marks)

c) Use regression analysis to estimate the line of best fit -use the manual method with the formulas

shown below. (Eight marks)