The University of Cincinnati Center for Business Analytics is an outreach center
ID: 2339204 • Letter: T
Question
The University of Cincinnati Center for Business Analytics 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 of the corporate members of the center (there are currently 10) receives nine free seats to each symposium. Nonmembers wishing to attend must pay $75 per person. Each attendee receives breakfast, lunch, and free parking. The following are the costs incurred for putting on this event:
Rental cost for the auditorium: $150 Registration Processing: $8.50 per person Speaker Costs: 3@$800 $2,400 Continental Breakfast: $4.00 per person Lunch: $7.00 per person Parking: $5.00 per person The University of Cincinnati Center for Business Analytics 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 Bus ness Intellioence Symposium. Each symposium features three speakers on the real-world use of analytics. Each of the corporate members of the center (there are currently 10) receives nine free seats to each symposium. Nonmembers wishing to attend must pay $75 per person. Each tendee receives breakfast, lunch, and free parking. The following are the costs incurred for putting on this event: Rental cost for the auditorlum: S150 Registration Processing: Speaker Costs: 3$8MI Continental Breakfact: Lunch Parking: $8.50 per person $2,40 $a.aa par persan $7.00 per persun $5.00 per person a The Center l r Bu ness Analytics s considering a refund policy or no shows. No re und 1 be ven for mern ers ti do not attend but for n mer bers ho do not attend 50% of the price will be re unded. Build a spreadsheet model in Excel that ca ulates a profit 0r loss based on the number o non ne be re strants. Extend the model you developed tor the Business ntelligence Symposium to account for the tact that historical 25% of members who registered do not show and 10% of registered nonmembers do not attend. The center pays the caterer for breakfast and lunch based on the number of registrants (not the number of attendees). However, the center only pays for parking for those who attend. What is the profit if each corporate member registers their full allotment of üickets and 127 nonmembers register? If required, rournd your answes t aces twa decimal p (b) Use a two-way data table to show how profit changes as a function of number of registered nonmembers and the no-show percentage of nonmembers, Vary number of nonmember registrants from 80 to 160 In Increments of 5 and the percentage of nonmember no- shows from 10% to 30% in increments of 2%. In which interval of nonmember registrants does breakeven occur if the percentage of nonmember no-shows is 2296? Breakeven appears in the interval ol Lo number cf registered nonnembers.Explanation / Answer
Non Member 127 Corporate Members 10 9 Less: 10% do not show 12.7 Total Tickets alloted to members 90 Total Non members attended 114.3 Less: 25% do not show 22.5 Rate per ticket $75 Total Members Attended 67.5 Income $8,572.50 Less: 50% of 25% not attended $476.25 Net Income $8,096.25 Less: rental Cost $150 Registration Processing $1,844.50 Speaker Cost $2,400 Continental Breakfast $868 Lunch $1,519 Parking $909 Profit $405.75
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.