please answer this question asap

NOTE: Show and use excel formulas for each and all calculations and round to two decimals Q 1 Use the Historical demand data below to calculate THREE forecasts. [3 marks] a] 3 Period Simple moving average b] 3 Period Weighted moving average using weights of .55J .3' .15 c] Exponential Smoothing forecast using an Alpha of .2. and a Week 3 forecast of 600 units. Week Demand 3 Period SMA WMA .55,.3,.15 EXP 5M a = .2 11-25 491 520 6-00 605 530 430 11-55 545 590 LDODHmm-lh-LUMli Q 2 For each of the forecasts and demand belowJ calculate the Mean Absolute Deviation, Mean Squared Error and Mean Absolute Percent Error. Use the ABS formula for Absolute Value. [3 marks] Q 2 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. [3 marks] week Demand Forecast Error [e] Abs e e"2 Abs efA'100% 1 32 77 2 77 82 3 53 55 4 55 63 5 75 80 5 8'0 75 MAD = MSE = MAPE = Q 3 The Actual demand for skis from a large GTA retail chain is shown below for 2019. [4 marks] a] Calculate the Seasonal Index {or last year {or each oi the {our seasons. b] Use the seasonal Index from table 1 to calculate the demand for each of the seasons for this coming year I Table #2] based on a new ANNUAL demand of 10,000 snowboards. ast Year 2019 This Year 2020 lllI lllI MAD = MSE = MAPE = Q 3 The Actual demand for skis from a large GTA retail chain is shown below for 2019. [4 marks] a] Calculate the Seasonal Index for last year for each of the four seasons. b] Use the seasonal Index from table 1 to calculate the demand for each of the seasons for this coming year I Table #2] based on a new ANNUAL demand of 10,000 snowboards. ast Year 2019 3250 Seasonal Index This Year 2020 mm __ __ __ __