Q4. Calculate the ME for each forecast technique. Which forecast(s) tend to underpredict?

Your answer:

Q6. Use Solver to find the optimal alpha, how does alphs impact the forecast accuracy of exponential smoothing?
Your answer:

A B D E F Month Demand Four-Period Moving Average Exponential Smoothing Alpha 0.14 1 2 30 33 1 2 3 4 5 6 3 34 4 41 5 54 7 6 47 49 8 9 7 8 33 9 52 10 47 11 10 11 12 13 14 15 12 13 14 39 58 55 37 16 47 15 16 17 37 18 17 50 19 18 43 20 19 47 20 47 21 30 22 40 21 22 23 24 25 26 23 39 39 24 25 Morth Morth Demand en period Demand Last period Simple Hverage Moving average Exponential smoothing alpha 0.7 Historical sales data from period 1 to period 36 20 1 2 3 4 5 5 7 B 9 10 11 12 13 19 20 37 17 19 30 25 34 an 43 22 3 28 30 20 50 34 15 16 17 18 19 20 21 22 10 31 D 5 10 40 42 3 24 25 26 27 28 29 30 31 41 46 40 4F 48 48 -16 64 33 50 58 50 45 96 27 ME MAD