The University of Cincinnati Center for Business Analytics is an outreach center that collaborates with industry...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 corporate member of the center (there are currently 10) receives fourteen 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: Registration Processing: Speaker Costs: Continental Breakfast: Lunch: Parking: $150 $8.50 per person 3@$800 = $2,400 $4.00 per person $7.00 per person $5.00 per person (a) The Center for Business Analytics is considering a refund policy for no-shows. No refund would be given for members who do not attend, but nonmembers who do not attend will be refunded 50% of the price. Build a spreadsheet model that calculates a profit or loss based on the number of nonmember registrants. Account for the fact that, historically, 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 tickets and 127 nonmembers register? If required, round your answers to two decimal places. 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 corporate member of the center (there are currently 10) receives fourteen 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: Registration Processing: Speaker Costs: Continental Breakfast: Lunch: Parking: $150 $8.50 per person 3@$800 = $2,400 $4.00 per person $7.00 per person $5.00 per person (a) The Center for Business Analytics is considering a refund policy for no-shows. No refund would be given for members who do not attend, but nonmembers who do not attend will be refunded 50% of the price. Build a spreadsheet model that calculates a profit or loss based on the number of nonmember registrants. Account for the fact that, historically, 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 tickets and 127 nonmembers register? If required, round your answers to two decimal places.
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
Please complete the Web case that covers material discussed in this chapter at www.cengage.com/accounting/Gibson. Youll be using Thomson ONE Business School Edition, a powerful tool that combines a...
-
Four point charges are situated at the corners of a square with sides of length a, as in Figure. Find the expression for the resultant force on the positive chargeq. +9
-
Traffic control on the roads by lights where the timing mechanism operates irrespective of the intensity of traffic is an example of (a) Closed loop control (b) Under-damped control (c) Open loop...
-
Which interest rate, the face rate or the market rate, should be used when calculating the issue price of a bond? Why? (Appendix)
-
Gandolfi Construction Co. purchased a used CAT 336DL earth mover at a cost of $325,000 in January 2013. The companys estimated useful life of this heavy equipment is 10 years, and the estimated...
-
21: Find an equation of the tangent line to f (x) = 7 cos(x) at x = ?. (Let y = f (x) and express the equation of the tangent line in terms of y and x.) 111: Find an equation of the tangent line to f...
-
uiz 1 Problem 4: Scott Manufacturing's cost accountant has provided the following information for January operations. Direct materials $20 per unit Fixed manufacturing overhead costs $135,000 Sales...
-
During early 2008, the market sentiment and the credit crunch in the United States and worldwide created a lot of pressure on the liquidity of KMTB Finance Company. Even though short-term interest...
-
What is the The Review Stage of Audit? Explain.
-
What do you know aboutCommunicating with Those Charged with Governance(Advanced Audit and Assurance). Explain.
-
Explain Evaluation of Misstatements.(Advanced Audit and Assurance).
-
Write an essay on Audit Opinion & Audit Report. Explain FORMING AN OPINION AND REPORTING ON FINANCIAL STATEMENTS. (Advanced Audit and Assurance)
-
The lists data for 593 movies released in 2011. Obviously, some movies are simply more popular than others, but success in 2011, measured by 2011 gross or 2011 tickets sold, could also be influenced...
-
Is times interest earned meaningful for utilities? Why or why not?
-
Prepare a CVP graph (Learning Objective 2)} Use the information from the Bay Cruiseline Data Set. Draw a graph of Bay Cruiseline's CVP relationships. Include the sales revenue line, the fixed expense...
-
Interpret a CVP graph (Learning Objective 2)} Describe what each letter stands for in the CVP graph. D 300 200 F C G 150 H B A E The breakeven point is atunits and at J. dollars of sales.
-
Compute weighted-average contribution margin (Learning Objective 4) Use the information from the Bay Cruiseline Data Set. Suppose Bay Cruiseline decides to offer two types of dinner cruises: regular...
Study smarter with the SolutionInn App