Name: Please submit this spreadsheet with your answers to Canvas. This assignment will be due on Nov 8 Go to the first tab (Data), you have the mouthly sales data from the previous 36 months and are trying generate the most accurate forecast for period 37 Q1. Simply looking at the graph of the histrical sales data (without any calculation), do you identift any pattern (trend/seasonality/cyclicality)? Your answer: Q2. Simply looking at the graph of the histrical sales data (without any calculation), do you think using simple average will give you an accurate forecast? Your answer: Q3. Please generate the forecast for period 37 by implementing four forecasting techniques (last period, simple average, three-period moving average, and exponential smoothing with alpha = 0.7) Last period forecast: Simple average forecast (start the forecast in period 3): Your answer: Three-period moving average: 2 3 Exponential smoothing (alpha = 0.7): Q4. Calculate the ME for each forecast technique. Which forecast(s) tend to underpredict? 4 Your answer: 5 Q5. Calculate the MAD for each forecast technique. Which forecast(s) tend to generate the most accurate forecast? Your answer: Q6. Use Solver to find the optimal alpha, how does alphs impact the forecast accuracy of exponential smoothing? 3 Your answer: 7 Month Demand Last period Simple average Moving average Exponential smoothing alpha 0.7 1 2 19 20 37 Historical sales data from period 1 to period 36 3 70 4 17 19 5 60 6 7 8 50 9 30 25 34 33 22 32 43 32 40 10 11 12 13 14 15 30 28 28 mmhly 50 20 16 17 18 10 19 0 0 5 10 15 20 25 30 35 40 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 34 44 31 38 42 40 42 60 46 45 46 48 46 64 47 50 58 53 60 45 ME MAD