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 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 five 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. Buil 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. 2288.25 (b) Use a two-way data table to show how profit changes as a function of number of registered nonmembers and the to-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: 85 to 90 registered nonmembers. % of Members Who Do Not Show % of Nonmembers Who Do Not Show Number of Nonmember Registrants Base Case Worst Case 25% 10% 130 50% 30% 100 Best Case 15% 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 $ 17085 The lowest profit is $ 6270 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 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 five 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. Buil 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. 2288.25 (b) Use a two-way data table to show how profit changes as a function of number of registered nonmembers and the to-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: 85 to 90 registered nonmembers. % of Members Who Do Not Show % of Nonmembers Who Do Not Show Number of Nonmember Registrants Base Case Worst Case 25% 10% 130 50% 30% 100 Best Case 15% 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 $ 17085 The lowest profit is $ 6270
Expert Answer:
Answer rating: 100% (QA)
Heres the breakdown for the Business Intelligence Symposium model and analysis Part a Profit Calculation Members Total members 10 Free seats per membe... View the full answer
Related Book For
Essentials of Business Analytics
ISBN: 978-1285187273
1st edition
Authors: Jeffrey Camm, James Cochran, Michael Fry, Jeffrey Ohlmann, David Anderson, Dennis Sweeney, Thomas Williams
Posted Date:
Students also viewed these accounting questions
-
Lindsay is the 100% shareholder of the ABC Corp, which was incorporated in 2010.Lindsay was informed by the company accountant that her corporation earned profit in the year 2020 but incurreed no...
-
On January 1, 2012, Wilmes Floral supplies borrowed $2,413 from Bower Financial Services. Wilmes Floral Supplies gave Bower a $2,500 note with a maturity date of December 31, 2013. The note specified...
-
Use the following transfer functions to find the steady-state response yss(t) to the given input function f(t). a. T(s) = Y(s)/F(s) = 10/((10s + l)(4s+ 1), f(t) = 10sin 0.2t b. T(s) = Y(s)/F(s) =...
-
NYI Corporation manufactures decorative window glass in two sequential departments. These data pertain to the month of August: Department 1 Direct Materials used for production Department 2 $ 5 5 , 0...
-
A two-stroke I.C. engine has (a) inlet and exhaust valves (b) inlet and exhaust ports (c) inlet, exhaust and transfer ports (d) only transfer ports
-
MFG Inc. has two alternative means of manufacturing its product. Process A has fixed costs of $21,000 per period and a variable cost of $6 per unit. Process B requires fixed costs of $45,000 per...
-
Assume that you have been asked to provide a position statement for your client to attend mediation in a family law case. The information in this case is the other parent who is the petitioner, Ms....
-
The figure in the popup window, a. The expected return. b. The standard deviation of the return. Note: Make sure to round all intermediate calculations to at least five decimal places. shows the...
-
5. Let A be the matrix A = 10 (a) Find the spaces C(AT) and N(A). 1 1 (b) Consider the underdetermined linear system X1 1116-0 4 X2 12 X3 Find the solution x = R that minimizes ||x||2.
-
Come up with your own scenario (state the products/industry) that illustrates a cannibalization rate of 27% and give me details of the different amounts of products sold in your scenario.
-
Today, accountants use accounting information technology to handle many transactions that were once manual and transactional in nature. However, some types of activities that accountants perform...
-
The following data were provided by Mystery Incorporated for the year ended December 31: Cost of Goods Sold Income Tax Expense Merchandise Sales (gross revenue) for Cash Merchandise Sales (gross...
-
1) If given the choice, which situation would you choose for a team of persons to lead, and why? a) All team members are star performers, who consistently perform above expectations b) Less than 50%...
-
Axillar Beauty Products Corporation is considering the production of a new conditioning shampoo which will require the purchase of new mixing machinery. The machinery will cost $375,000, is expected...
-
Illini Company, Inc. Balance Sheet as of 12/31/20X0 Assets Current Assets: Cash $1,500,000 Accounts receivable, net 18,000 Inventory 50,000 Total current assets 1,568,000 Equipment 90,000 Goodwill...
-
This exercise considers data from the Medical Expenditure Panel Survey (MEPS) described in Exercise 1.1 and Section 11.4. Our dependent variable consists of the number of outpatient (COUNTOP) visits....
-
This exercise considers the data described in the Section 13.2.2 ratemaking classification example using data in Table 13.3 Table 13.3 . a. Fit a gamma regression model using a log-link function with...
-
Verify that the Tweedie distribution is a member of the linear exponential family of distributions by checking equation (13.9). In particular, provide an expression for \(S(y, \phi)\) (note that...
Study smarter with the SolutionInn App