Please create a break-even analysis on a Spreadsheet for a theatrical production. Please advise how many tickets must be sold to break even and what are the variable costs for the production?

500 seats in the theatre

There will be 3 shows: Two on Saturday and one on a Sunday afternoon.

The ticket price is $35 per person.

During the month of January, the company put on 6 shows total which were for two weekends.

Here are all costs associated with the production for the month of January.

Theatre rental- $3000 for all six shows for both weekends

Advertising- $600 for all six shows on both weekends

Salary and payroll-$3000 for all six shows for both weekends

Insurance- $2000 for all six shows for both weekends

Food for Crew and Artists- $500 for all six shows for both weekends

Costume and Makeup- $1,000 for all six shows for both weekends

Miscellaneous-$200 for all six shows for both weekends

Computer and Video Equipment- $1000 for all six shows for both weekends

Set Design- $5000 for all six shows for both weekends which will last all year.

Legal Expenses- $2000 for the month of January.

Please use the break-even point formula: BEP = FC / (P - AVC)

Thank you for your help!