Demand Forecasting Excel Exercise NEE (2.xlsx - Excel Sign in File Formulas Data Review View Help Tell me what you want to do 2. Share AutoSum Home Insert Page Layout X Out Calibr Copy - Format Painter BIU- - 12 - Wrap Text Custom Accents Accenth 47 O FA Insert Delete format Paste A Merge & Center - Comma [0] Conditional Format as comma Formatting - Table Styles Clear - Sort & Find & Filter - Select Eding Font Mignment Number Calls D28 f A B D E E F H 1 ) K L M M N 22 23 24 25 26 27 Q2 ) For each of the forecasts and demand below, a) calculate the Mean Absolute Deviation, b) Mean Squared Error and c) Mean Absolute Percent Error. (3 marks) *Use the ABS formula for Absolute Value. week Error (e) Abs e e12 Abs e/A 100% 28 24 29 30 24 31 1 2 2 3 4 5 Demand 102 83 53 65 79 81 Forecast 97 87 47 68 80 79 6 32 33 34 35 36 MAD MSE = MAPE = 37 38 39 40 Q3 ) The actual demand for bagels from a large GTA retail chain is shown below for 2020. a) Calculate the Seasonal Index for last year for each of the four seasons. (2 marks) b) Use the seasonal Index from table # 1 (2020) to calculate the demand for each of the seasons for this year Table #2 (2021) based on a new ANNUAL demand of 10,250 bagels. (2 marks) 41 42 43 Instructions NEE Ready 1204 A4 (1) # 11:26 PM 2021-02-12