Please Show Excel Solution

2 Period Sales 3 1 20 Use 3-period moving average and exponential smoothing techniques to forecast demand for period 16. For exponential smoothing technique use (Alfa) a = 0.8 and (alfa) a = 0.5 (2 points). 1 2 21 3 21 Finally, see which forecast is more accurate by using Mean absolute deviation (MAD) or MAPE techniques (1 Points). 4 19 5 7 5 21.5 3 6 22.8 Correct formula & wrong answer 3 7 20.75 0 8 23 The rubric Correct answer Wrong formula or no attempt 3-period moving average 1 point point = 0.8 0.5 point point 0.5 point 0.5 point 0 1 9 22.9 2 10 18 0.25 point 0 3 19 0.25 point a = 0.5 0 17 4 5 16.8 6 AAAAA 14 13.9 7 8 9 0 1 2 3 4 5 6 7 8