Question: A School of Business Analytics Center holds an annual Business workshop. The workshop features two guest speakers on the real-world use of analytics. The
A School of Business Analytics Center holds an annual Business workshop. The workshop features two guest speakers on the real-world use of analytics. The corporate sponsor member of the center (there are seven corporate members in total) receives four seats (including the member) to the workshop. Nonmembers wishing to attend must pay $100 per person. Each attendee receives breakfast, lunch, and free parking. The following are the costs for putting on this event: Rental cost for the auditorium Registration processing Speaker costs Continental breakfast Lunch Parking $300 $10 per person 2 * $1000 = $2000 $5 per person $10 per person $10 per person After building a spreadsheet model that calculates a profit or loss based on the number of nonn per registrants, use Go Se to find the number of mber registrants that will make the event break even
Step by Step Solution
3.42 Rating (165 Votes )
There are 3 Steps involved in it
To solve this problem using Goal Seek in a spreadsheet you need to calculate the number of nonmember ... View full answer

Get step-by-step solutions from verified subject matter experts