me Insert Draw Page Layout ' ab Wrap Text == Calibri (Body) Gene v 11 X IG Merge & Center = = v $ Paste a. Av BIU v Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? 40 XV fx A G B 1 C D E H F 2 13 24 Jun Jul 1125 960 Aug Sep Oct Nov Dec 1023 956 945 1035 1200 25 26 27 28 29 30 31 32 33 34 35 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 36 Error(e) Absolute Error MSE enz MAPE Abs e/A 37 28 39 40 41 42 43 Week 1 2 3 4 5 Demand 556 598 625 615 690 610 Forecast 500 550 650 600 700 650 6 ANSWER 44 45 46 Q3 The Actual demand for portable BBQs from a large GTA Camping Goods chain is shown below for 2020. 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 year (Table #2) based on a new ANNUAL demand of 2500 BBQs. Use two decimal places for your seasonal factor. Round your final forecasts to whole numbers. 47 48 49 50 51 Last Year 2020 Sold Average Seasonal Factor Season 52 53 Winter 54 Spring 55 Summer 56 Fall 57 58 Table 2 650 520 650 420 Averaze Sheet2 Seasonal Factor + Forecast Ready esc LG BI U A