Please answer in an Excel File because that is the requirement. And please show all the work in an Excel file so all the formulas used to get the answer NOT just the answer. $($Every piece of data must come from a formula to obtain the grade$).$ Thank you.

Question $3$

As spring approaches, John and Mary need to forecast the number of guests they will have in their trailer park. John's estimate is that in the new year they will have $900$ guests. In addition, below is the number of guests they have had over the last $3$ years.

Month $202120222023$ January $757874$ February $120123128$ March $125130134$ April $110113126$ May $646676$ June $825250$ July $526567$ August $905684$ September $607552$ October $515386$ November $647150$ December $798650$

$3\mathrm{.}1.$ Based on the data above, calculate the seasonal index for each month. Show results using $2$ decimal points.

$3\mathrm{.}2.$ Based on the data above and the seasonal index on question $3\mathrm{.}1$ above, calculate the seasonal volume by month for the new fiscal year. Show results using whole numbers.

$3\mathrm{.}3.$ Identify $3$ operational decisions that may be impacted by this forecast.