1. What-if Analysis- Data Table and Scenario Manager

The Center for Analytics is organizing a symposium. The Symposium is sponsored by 15 Companies.

Employees of these Sponsor companies could register for the symposium, 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 symposium.

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 Parking fee for only those who attend the symposium.

Non-attendees who paid a Registration Fee will receive a 55% refund.

On the day of the symposium, 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

If required, round your answers to two decimal places.

(b) Make 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.