John has been asked to determine whether the $$22\mathrm{.}50$ cost of tickets for the community dinner theater will allow the group to achieve break$-$even and whether the $175-$seating capacity is adequate.

The cost for each performance of a $10-$performance run is $$2,500.$ The facility rental cost for the entire $10$ performances is $$10,000.$

Drinks and parking are extra charges and have their own price and variable costs, as shown below:

ITEM ESTIMATED SALES SELLING

PRICE $($ P $)$ VARIABLE

COST $($ V $)$

Tickets with dinner $175$ $$22\mathrm{.}50$ $$10\mathrm{.}50$

Drinks $175$ $$5\mathrm{.}00$ $$1\mathrm{.}75$

Parking $100$ $$5\mathrm{.}00$ $$2\mathrm{.}00$

Question $1$Answer

a$.$

$$51,750$

b$.$

$$53,130$

c$.$

$$57,975$

d$.$

$$62,724$

make excel sheet for solutions please