Please solve this

L18 X V fx A B C D E F G H ZO 10 27 11 2340 28 12 2310 29 30 Q2 For each of the forecasts and demand below, calculate the Mean Absolute Deviation, 31 Mean Squared Error and Mean Absolute Percent Error. 32 Use the ABS formula for Absolute Value. NOTE: Use formulas for each calculation. 33 Round each answer to one decimal place. 34 35 MAD MSE MAPE 36 Week Demand Forecast Error (e) Abs e e^2 Abs e/A 37 585 590 38 N 560 600 39 545 600 40 610 600 41 590 600 42 560 580 43 MAD 44 MSE 45 MAPE 46 47 Q3 The Actual demand for snow blowers from a large GTA retail chain is shown below for 2021. 48 Calculate the Seasonal Index for last year for each of the four seasons. 49 Use the seasonal Index to calculate the demand for each of the seasons for this coming year ( Table 50 #2) based on a new ANNUAL demand of 5500 snowblowers. Use two decimal places for your seasonal factor. Your final forecasts must be in whole numbers. 51 52 Last Year 2021 53 Season Sold Average Seasonal Index 54 Winter 1510 55 Spring 1305 56 Summer 760 57 Fal 1125 58 59 Assignment 1 + Rea