Problem $1$:

International Productions performs Cats, the play. The average show sells $1,200$ tickets at $$45\mathrm{.}00$ a ticket. There are $100$ shows a year. Cats has a cast of $50,$ each earning an average of $$350\mathrm{.}00$ a show. The cast is paid after each show. The other variable expense is program printing cost of $$9\mathrm{.}50$ per guest. Annual fixed expense is $$255,000\mathrm{.}00.$

Questions:

$1.$ Calculate total revenue and total variable expenses for each show. $(5$ pts$)$

$2.$ How many show Cats must perform each year to break even? Show all of your calculations and answer the question in a complete sentence. $(10$ pts$)$

$3.$ Using contribution margin approach, calculate the number of shows needed each year to earn a profit of $$3,520,000\mathrm{.}00.$ Show your calculations and answer the question in a complete sentence. $(10$ pts$)$

Fill out excel sheet.