The University of Cincinnati Center for Business Analytics 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 attendee is charged $75 to attend (this is revenue). 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 (one-time)

Registration processing: $8.50 per person

Speaker costs: $2400 (one-time)

Continental breakfast: $4.00 per person

Lunch: $7.00 per person

Parking: $5.00 per person

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

b. The symposium organizers want to understand the possible levels of profit based upon different levels of attendance. Use a one-way data table to test profit levels for attendance of 50, 60, 70, 80, 90, 100, 110, and 120.

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