Question

The University of Cincinnati Center for Analytics is organizing an event. The Center is sponsored by 15 Companies. Employees of these sponsor companies could register for the event, free of charge. 6 employees from each of the companies have registered. Registration fee for the general public is $90 per person. 135 individuals from the general public have registered to attend the event. All attendees receive breakfast, lunch and parking free of cost. The Caterer charges the Center, based on the total number of people registering. The Center pays the parking fee for only those who attend the event. Non-attendees who paid a Registration Fee will receive a 55% refund. On the day of the event, a total of 5 registrants from the sponsor companies do not show up. Also, there are 12 no-shows from among the general public registrants. (a) Build a spreadsheet model that calculates a profit or loss to the Center. (b) Create a two-way table to show how profit changes by number of public registrants and no-shows. Vary the number of general public registrants from 100 to 160 in increments of 10. Vary the number of no-shows among general public registrants from 10 to 20 in increments of 1. Other Information: Expenses incurred by the Center: Rental cost for the auditorium: $1,300 Processing cost (Badges, Brochures, Welcome desk, etc.): $10.50 per person registering Speaker Costs: 4 speakers at $1250 each Breakfast: $5.20 per person registering Lunch: $9.50 per person registering Coffee, Tea, Soft drinks: $2.40 per person attending Parking: $7.00 per person attending Refund to non-attendees: 55% of Registration fee received Fixed cost: $6,300 Registrant cost: $25.20

Answer 1