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 ten 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. 2,288.25 (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 (c) Consider three scenarios: to registered nonmembers. Base Case Worst Case Best Case % of Members Who Do Not Show % of Nonmembers Who Do Not Show Number of Nonmember Registrants 25% 10% 130 50% 30% 120 12% 4% 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 $ The lowest profit is $ 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 ten 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. 2,288.25 (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 (c) Consider three scenarios: to registered nonmembers. Base Case Worst Case Best Case % of Members Who Do Not Show % of Nonmembers Who Do Not Show Number of Nonmember Registrants 25% 10% 130 50% 30% 120 12% 4% 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 $ The lowest profit is $
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
Aryan company's budgeted operating for 2021 are as follows Sales 22000 UNTTS Sales price per unit$20 Variable Manufacturing capacity 30,000 Manufacturing cost per unit$5.20 Selling cost$1.50 Fixed...
-
In your opinion, will delivery and white glove service be popular among consumers?
-
Peter and Blair recently reviewed their future retirement income and expense projections. They hope to retire in 25 years and anticipate they will need funding for an additional 16 years. They...
-
a. Firm A has a margin of 14%, sales of $640,000, and ROI of 18%. Calculate the firm's average total assets. b. Firm B has net income of $72,000, asset turnover of 1.40, and average total assets of...
-
With reference to Exercise 10.12, show that 2X 1 is also an unbiased estimator of k, and find the efficiency of this estimator relative to the one of part (b) of Exercise 10.12 for (a) n = 2; (b) n...
-
Terry Underwood purchased a 15-year-old compact car with 10,000 miles for his teenage son who recently received his license. Which of the following auto insurance coverage's should be included in the...
-
Utah Banks bid price for Canadian dollars is $.7938 and its ask price is $.81. What is the bid/ask percentage spread?
-
On May 5, 2014, Christy purchased and placed in service a hotel. The hotel cost $10.8 million. Calculate Christy's cost recovery deductions for 2014 and for 2024.
-
On January 2, 2019, the French company R exported goods to the American company S, at $ 0 0 0 $ 40 A dollar, the agreement spends the following 1. That the American company pays in cash 40% of the...
-
If you manage inventory with your company what level of safety stock do you aim for. If not what do you think of amazon's blanket recommendation of 4 weeks of inventory should it be more or less?
-
How much does your leg shorten when you stand on it? Calculate the change in length of the upper leg bone when a 65.0 kg person supports 57.0 kg of their mass on it, assuming the bone to be...
-
As we have seen, one of the roles that the post-sale confusion doctrine plays is to protect the status and exclusivity of luxury brands. As one judge described it, "I f the prestige of carrying a bag...
-
Deanne contracts with Leonard to paint her barn in two weeks. If Leonard breaches the contract, Deanne can elect the remedy of damages or the remedy of injunctive relief to prevent Leonard from...
-
Reference: https://annas-archive.org/slow_download/8fe4de22412036999d259570a74bc2e8/0/0#:~:text=URL%20to%20download%3A-,download%20now.,-%F0%9F%9A%80%20To%20get%20faster "Download now." Much has been...
-
Discuss the advantages of using NoSQL databases over relational databases. Discuss why NoSQL databases have not replaced relational databases all together.?
-
One year ago, you purchased 200 shares of QMC Industries stock at a price of $18.97 a share. The stock pays a annual dividend of $1.42 per share. Today, you sold all of your shares for $17.86 per...
-
(a) With not more than 300 words, examine why Malaysia missed its 2020 targets to divert 40% of waste from landfills and increase recycling rates to 22%. (10 marks) b) Why arent Malaysian recycling?...
-
English Bay Beach Company manufactures suntan lotion, called Surtan, in 11 -ounce plastic bottles. Surtan is sold in a competitive market. As a result, management is very cost-conscious. Surtan is...
-
Jessica Company manufactures bicycles and tricycles. For both products, mate- rials are added at the beginning of the production process, and conversion costs are in- curred uniformly. Jessica...
-
International Hotels operates many hotels throughout the world. One of its hotels is facing difficult times because several new competing hotels are opening. To accommodate its flight personnel, Air...
Study smarter with the SolutionInn App