Exponential Smoothing "Problem", please submit the Excel Formula as well, Thank you.

. B D E F G K L M N O Q R S T 1 2 Period Sales 3 1 20 4 2 21 Use 3-period moving average and exponentioal smoothing technique to forecast demand for period 16. For exponentioal smoothing use a = .9 and a = .5. Then by using MAD or MAPE see which technique gives more accurate stimation. 5 3 22 6 4 19 7 5 8 6 21.5 22.8 20.75 9 7 10 8 23 11 9 22.9 10 18 12 13 11 19 14 12 17 15 13 16.8 14 14 16 17 15 13.9 18 16 19 17 20 21 22 23 24 25