The manager of a municipal ice rink is concerned that the flow of patrons may 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 which is set by the city and skate rental (i.e., a certain share of patrons rent skates). The manager knows the average ice time per patron over the last 3 years. Salaries, scheduled maintenance, and other overhead expenditures are also know these costs do not vary with the number of patrons. Costs that vary with the number of patrons are estimated in $ per patron hour. The manager would like to know the number of patrons required to break-even, i.e., where total revenues equals to total cost. In your Excel file, you have information about the following:

Hourly rental rate which is expressed in $ per hour per patron

Skate rental which is expressed in $ per pair

Hours spent at ice rink expressed in hours per patron

Share of patrons renting skates, e.g., 0.25 means that 25% of patrons rent their skates

Overhead expressed in $ per year

Variable Cost expressed in $ per patron

Average number of patrons per year which is the average number of patrons over the last 5 years.

Calculate the following assuming the average number of patrons per year:

1. Total revenue from patrons using the ice rink

2. Total revenue from skate rental

3. Total revenue (ice rink use and skate rental)

4. Total variable cost

5. Total cost (overhead plus variable cost)

6. Profit or loss (total revenue-total cost)

What is the number of patrons necessary to break even (i.e., to make neither profit not loss). Should the manager be concerned given the current number of users?