Question
1. The George Mason University School of Business Analytics Center is an outreach center that collaborates with industry partners on applied research and continuing education
1. The George Mason University School of 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 speaker costs $800. Each corporate member of the center (there are currently 10 corporate members) receives five free admission (including the member). Assumer all the members as well as their guests come to the symposium. The members and their guests do not pay the admission fee. Only the nonmember pays $75 admission fee per person. The $75 admission fee is only revenue resource that the center makes. The following are the costs incurred to the Center for the event: Speaker cost $800 per speaker Rental cost for the auditorium $150 Registration cost $8.50 per person(member & non member) Continental breakfast $4.00 per person(member & non member) Lunch $7.00 per person(member & non member) Parking $5.00 per person(member & non member) 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 needs the event to be break even. please show every step on the excel sheet.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started