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:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/664e6bdb1253b_451664e6bdb0be3f.jpg)
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 thirteen 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. 9525 (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 22%? Breakeven appears in the interval of 3,874.50 to 160 registered nonmembers. (c) Consider three scenarios: % of Members Who Do Not Show % of Nonmembers Who Do Not Show Number of Nonmember Registrants Base Case 25% 10% 140 Worst Case 50% 30% 135 Best Case 12% 5% 150 All other inputs are the same as in part (a). Use Scenario Manager to generate a summary report that gives the profit for each of these three scenarios. What is the highest profit? What is the lowest profit? If required, round your answers to two decimal places. For subtractive or negative numbers use a minus sign. The highest profit is $ 3580 The lowest profit is $ 425 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 thirteen 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. 9525 (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 22%? Breakeven appears in the interval of 3,874.50 to 160 registered nonmembers. (c) Consider three scenarios: % of Members Who Do Not Show % of Nonmembers Who Do Not Show Number of Nonmember Registrants Base Case 25% 10% 140 Worst Case 50% 30% 135 Best Case 12% 5% 150 All other inputs are the same as in part (a). Use Scenario Manager to generate a summary report that gives the profit for each of these three scenarios. What is the highest profit? What is the lowest profit? If required, round your answers to two decimal places. For subtractive or negative numbers use a minus sign. The highest profit is $ 3580 The lowest profit is $ 425
Expert Answer:
Answer rating: 100% (QA)
Lets go through the questions one by one a Calculate the Profit Given Data Rental Cost for Auditorium 150 Registration Processing per Person 850 Speak... View the full answer
Posted Date:
Students also viewed these finance questions
-
Find the direction cosines and angles of, and demonstrate that the sum of the squares of the direction cosines is 1. u = 5i + 3j - k
-
Are the following models linear in the parameters? If not, is there any way to make them linear-in-parameter (LIP) models? a. b. B1 B2X,
-
Select the correct answer for each of the following questions. 1. The primary focus in accounting and reporting for governmental funds is on: a. Income determination. b. Flow of financial resources....
-
Discuss the value of a feasibility study and the information included in its nonfinancial sections. LO1
-
MediaForum has three operating groups: Games, News, and Documentaries. In May, the company incurred $24,000,000 of joint cost for facilities and administration. May revenues and separate production...
-
Fabricators Ltd has been facing a lean financial spell for the past two years. Profits have been declining steadily and results of the preceding year showed total losses amounting to Sh.2000000; the...
-
Company is a small but growing manufacturer of telecommunications equipment. The company has no sales force of its own; rather, it relies completely on independent sales agents to market its...
-
If you initially deposit $10,000 and contribute $1,000 per month for five years to a plan in order to accumulate $100,000, what rate of return will be required to make this happen?
-
Altoids Company started business by acquiring \(\$ 60,000\) cash from the issue of common stock on January 1,2011 . The cash acquired was immediately used to purchase equipment for \(\$ 60,000\) that...
-
Sea Corp purchased the business Beta Resources for \(\$ 200,000\) cash and assumed all liabilities at the date of purchase. Beta's books showed tangible assets of \(\$ 150,000\), liabilities of \(\$...
-
Explain whether each of the following are considered taxable income. a. $10,000 payment for illegal services b. $500 Chicago Blackhawks tickets received in exchange for maintenance performed on your...
-
Mountain Coal paid \(\$ 450,000\) to acquire a mine with 22,500 tons of coal reserves. The following statements model reflects Mountain's financial condition just prior to purchasing the coal...
-
Cross Co. issued a \(\$ 50,000\) face value discount note to First Bank on June 1, 2011. The note had a 6 percent discount rate and a one-year term to maturity. Required Prepare general journal...
-
13 40 points What are at least four challenges facing Caribbean small island developing states
-
Find the reduced echelon form of each of the matrices given in Problems 120. c 1 26 + 4
-
For the following activities and their associated resources, identify the following: (1) a cost driver, (2) flexible resources, and (3) committed resources. Also, label each resource as one of the...
-
Penny Davis runs the Shear Beauty Salon near a college campus. Several months ago, Penny used some unused space at the back of the salon and bought two used tanning beds. She hired a receptionist and...
-
Deepa Dalal opened a free-standing radiology clinic. She had anticipated that the costs for the radiological tests would be primarily fixed, but she found that costs increased with the number of...
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App