Demand Forecasting Excel Exercise NEE (2.xlsx - Excel Sign in File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do 2. Share AutoSum Calibr - 12 -A Wrap Text Custom Accents Accenth FA Insert Delete format 47 O Copy - Format Painter Peste BIU. A Merge & Center - Comma [0] Conditional Format as comma Formatting Table Styles Clear Sort & Find & Filter - Select - fort Mignment Number Calls Eding 028 f A B D E F G H 1 K L M N 37 MAPE = 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 Average Seasonal Index Seasonal Index Forecast This Year 2021 Season Winter Spring Summer Fall 44 Last Year 2020 45 Season Sold 46 Winter 1245 47 Spring 2220 48 Summer 3120 49 Fall 2940 50 51 52 53 54 55 56 57 58 Instructions NEE Ready + 1209 w 4) *1# 11:29 PM 2021-02-12 F