Business Analytics Center is an outreach center that collaborates with industry partners on applied research and continuing education in business analytics. One of the programs offered by the Center is a quarterly Business Intelligence Symposium. Each symposium features three speakers on the real-world use of analytics. Each corporate member of the center (there are currently ten) receives five free seats (including member) to each symposium. Nonmembers wishing to attend must pay $75 per person. Each attendee receives breakfast, lunch, and free parking. The following are the costs incurred for putting on this event:

Rental cost for the auditorium

$150

Registration processing

$8.50 per person

Speaker costs

3/$800=$2,400

Continental breakfast

$4.00 per person

Lunch

$7.00 per person

Parking

$5.00 per person

(In excel form , could you please explain how to get the total variable cost for nonmembers)

Build a spreadsheet model that calculates a profit or loss based on the number of nonmember registrants.

Use Goal Seek to find the number of nonmember registrants that will make the event break even.