Q1 Use the Historical demand data below to calculate THREE forecasts. 1) 3 Period Simple moving average 2)3 Period Weighted moving average using weights of .5,3,-2 and 3) Exponential Smoothing forecast using an Alpha of 3. and a Week 3 forecast of 600 units. SMA 3 Period WMA .6, 3.1 EXP SM Alpha25 625 Week 1 2 3 4 5 6 7 8 9 10 11 12 Demand 425 491 620 605 530 480 455 545 590 510 600 580 Q2 For each of the forecasts and demand below, calculate the Mean Absolute Deviation, Mean Squared Error and Mean Absolute Percent Error. Use the ABS formula for Absolute Value. NOTE: Use formulas for each calculation. MAD Abse MSE ^2 Error (el MAPE Abs e/A week 1 2 3 4 Demand 82 77 68 65 75 80 Forecast 80 82 60 75 85 90 5 6 93 The Actual demand for Snowboards from a large GTA retail chain is shown below for 2019. Calculate the Seasonal Index for last year for each of the four seasons. Use the seasonal Index to calculate the demand for each of the seasons for this coming Average Seasonal Factor Last Year 2019 Season Winter Spring Summer Fall Sold 3300 2275 1150 2195 Average Seasonal Factor Forecast Table 2 Season Winter Spring Summer Fall