1: Break-even Analysis for Ice Skate Rink (25 points) 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

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)

Parameter Value

Hourly rental rate 4.85

Skate rental 2.45

Hours spent at ice rink 1.5

Share of patrons renting skates 0.5

Overhead 91200

Variable cost 4.35

Average number of patrons per year 23976