Create an excel sheet answer to the below. Also find a sample excel sheet to draft the answer.

11. The manager of a municipal ice rink is concerned that the flow of patrons will not be sufficient to maintain the long-standing policy of keeping the rink on a self-supporting basis. Revenues come mainly from the hourly rental of ice time (the city has set that at $2.50 per hour per person) and skate rental ($1.50 per pair). The average ice time per patron over the last three years has been about 1.5 hours. Approximately half the patrons rent skates. Salaries, scheduled maintenance, and other overhead expenditures amount to $94,500 per year; these costs do not vary with the number of patrons. Costs that vary with the number of patrons (direct maintenance and supplies) are estimated to be $1.80 per patron hour. The number of patrons has been averaging 85,000 per year for the last three years. Is the manager right to be concerned? Variables Unit price per person hour 6 price for rentals average ice time # of patrons renting patrons/year 5 1 100 1000 rate Revenue Total revenue from ice time Total revenue from rentals Total revenue 6,000 5001 6,500 Costs Fixed Cost Variable Cost (per patron hour) 4,000 3,0001 3 Total Cost 7,000 Profit/Loss -5001