Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Handbook On Corporate Governance In Financial Institutions

Authors: Christine A. Mallin

1st Edition

1784711780, 978-1784711788

More Books

Students also viewed these Finance questions