kindly provide full formulas !!!

Excel File Edit View Insert Format Tools Data Window Help 0.0 AutoSave CE BEU ExcelAssignment#1AA2211 Home Insert Draw Page Layout Formulas Data Review View Tell me F23 A C H 33 ou The actual demand for lawn mowers from a large GTA retail chain is shown below for 2020 Calculate the seasonal Index for last year for each of the four season. Use the seasonal Index to calculate the demand for each of the seasons for this coming year 41 Table) based on a WANNUAL demand of 11.000 lawnmowers. Use two decimal places for your seasonal factor 43 46 Year 2030 Sold Avenge Seasonal factor 45 46 W 110 47 2250 Sumo 2015 50 31 Table 2 Seasonal Factor Forecast Se 51 56 Sorin 55 Tall 57 75 Ready E esc Qa 1 1 2 3 $ 4. & 5 6 7 al Review View Tell me Calibri (Body) 12 v AA Paste BIU Wrap Text 9 IN . D31 Merge & Centre > fx A 39 40 Q The Actual demand for lawn mowers from a large GTA retail 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 12,000 lawnmowers. Use two decimal places for your seasonal factor 41 42 e 44 Last Year 2020 Seiten 45 Average Seasonal Factor Sold 1180 2350 3955 2075 Average Seasonal Factor Forecast 46 Winter 47 Soring CA 49 Full SO 51 Table 2 52 See 53 Winter 54 Spring Summer SE Fall 57 S8 59 GO 61 62 G3 64 65 66 67 70 71 72 Sheet2