**(b)** Use a two-way data table to show how profit changes as a function of the number of registered nonmembers and the no-show percentage of nonmembers. Vary the 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 [_____ ] to [_____ ] registered nonmembers.**(c) Consider three scenarios:**| | Base Case | Worst Case | Best Case ||----------------------------|-----------|------------|-----------|| % of Members Who Do Not Show | 25% | 50% | 12% || % of Nonmembers Who Do Not Show | 10% | 30% | 5% || Number of Nonmember Registrants | 140 | 135 | 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 $[_____ ]. **University of Cincinnati Center for Business Analytics**The University of Cincinnati Center for Business Analytics collaborates with industry partners on applied research and continuing education in business analytics. The center offers a quarterly Business Intelligence Symposium, featuring three speakers who discuss the real-world use of analytics. Each corporate member of the center (currently 10 members) receives thirteen free seats at each symposium. Nonmembers must pay $75 per person to attend, which includes breakfast, lunch, and free parking. Below are the costs associated with the event:- **Rental cost for the auditorium:** $150- **Registration Processing:** $8.50 per person- **Speaker Costs:** 3 speakers at $800 each = $2,400- **Continental Breakfast:** $4.00 per person- **Lunch:** $7.00 per person- **Parking:** $5.00 per person**Scenario (a):**The Center is considering a refund policy for no-shows. Members who do not attend will not receive a refund, but nonmembers who do not attend will be refunded 50% of their price. Develop a spreadsheet model calculating profit or loss based on the number of nonmember registrants, considering these historical no-show rates: 25% for members and 10% for nonmembers. Note that the center pays for catering based on the number of registrants, while parking is paid only for those who attend. Determine the profit if each corporate member uses their full allotment of tickets and 127 nonmembers register. Round your answers to two decimal places.Profit: $______**Scenario (b):**Utilize a two-way data table to show how profit varies with the number of registered nonmembers and the non-show percentage of nonmembers. Adjust the number of nonmember registrants from 80 to 160 in increments of 5 and the no-show percentage from 10% to 30% in increments of 2%. Identify the interval in which nonmember registrants break even if the no-show percentage is 22%.Breakeven occurs in the interval of _____ to _____ registered nonmembers.

“Since you have asked multiple questions and due to the time constraint & complexity, we will…

Answered: The Center for Business Analytics is…

Advanced Engineering Mathematics

10th Edition

ISBN:9780470458365

Author:Erwin Kreyszig

Publisher:Erwin Kreyszig

Chapter2: Second-order Linear Odes

Section: Chapter Questions

Problem 1RQ

See similar textbooks

Similar questions

Suppose Interactive Brokers developed new software to increase their speed of execution rating. If the new software is able to increase their speed of execution rating from the current value of 2.5 to the average speed of execution rating for the other 10 brokerage firms that were surveyed, what value would you predict for the overall satisfaction rating
What is business analytics? Briefly describe the domain of the major fields of business analytics databases and data warehousing, descriptive, predictive, and prescriptive analytics.
AssignmentYou have just been hired as the new general manager of Golfino’s, an Italian restaurant inside of the Wild Weeds Country Club in Mobile, Alabama. The owners of Golfino’s lease the space from the country club. As the GM, your owners would like you to create a market segmentation profile on all of the country club members and their food and beverage activity from the last year. The country club board of directors has agreed to give you this information, as well as their age, sex, and income.â€¢John Dunn: ?F&B activity: $2,000?Age: 62?Gender: Male?Income: $265,000?Home city: Mobile, Alabamaâ€¢Debbie Dell: ?F&B activity: $20,000?Age: 48?Gender: Female?Income: $265,000?Home city: Mobile, Alabamaâ€¢Will Stanley: ?F&B activity: $48,000?Age: 22?Gender: Male?Income: $200,000?Home city: Mobile, Alabamaâ€¢Ian Woodrow: ?F&B activity: $8,000?Age: 56?Gender: Male?Income: $1,200,000?Home city: Mobile,…
After post-graduate study, Mike found a job as HR analyst in London. Thecompany is currently recruiting Chief Marketing Officer. The HR departmentrecently sent out a knowledge test to the applicants after the initial CVscreening. At this stage of selection, the company does not invite the lowestscoring 30% (the opposite is the highest 70%.) back for the next face-to-faceinterview. According to the historical data, the test scores on this test arenormally distributed and has a mean of 70 with standard deviation of 10. a.What mark (to the nearest whole number) must a candidate achieve inorder to secure an interview? Show your workings.b. Explain the characteristics of standard normal distribution and normaldistribution, respectively.
The Dow Jones Industrial Average (DJIA) and the Standard & Poors 500 (S&P500) indexes are used as measures of overall movement in the stock market. The DJIA is based on the price movements of 30 large companies; the S&P 500 is an index composed of 500 stocks. Some say the S&P is a better measure of stock market performance because it is broader based. The closing prices for the DJIA and S&P500 for 20 weeks starting on 9/9/2005 are included in cells E1 to G21. The DJIA data is in cells F1 to F21 and the data for S&P 500 is in cells G1 to G21. Both data sets have labels in first row. Develop the estimated regression equation using DJIA as the independent variable. Place output in cell H1 Is the relationship between DJIA and S&P500 significant using alpha .05? Did the estimated regression equation provide a good fit? (explain) Suppose that the closing price for DJIA is 11,000. Estimate the closing price for the S&P500 Date…
A mobile phone distributor company has recently entered the phone assembling business. They want to study the sales trends in a certain area. From their past record of the distribution business, they know the volume of their annual sales in the Saddar area of Karachi city depends on the total income of all the earners in the area. The sales figures for past 10 years are shown in the following table. If the total income of all earners in Saddar is PKR 20 billion, what would be the predicted value of the company sales? Company's Sales (Billion rupees) Total Income in Saddar Area (Billion rupees) 11 0.7 15 1.1 16 0.4 13 0.9 18 1.0 21 1.2 22 1.5
suppose 15 percent of the computers in some university labs are defective
The new business venture, Best-In-World, has been manufacturing technology devices for over 20 years and is considering adding a new technology device to its music line. They have an established reputation for building quality devices, but they are rather novice in the music industry. The Chief Innovation and Design Officer, Julie Naugle-Hall, is tasked with hiring a marketing firm to conduct a survey to determine the feasibility and demand for their new music device. The follow decision table illustrates the potential payoffs for a high demand, moderate demand and low demand for the new music device. The decision will be whether to start production on this new device in small scale, large scale or not at all. Alternatives Answer Small-scale production Large-scale production No production Probabilities Decision Table High Demand 850,000 1,700,000 0 0.20 State of Nature Moderate Demand 300,000 700,000 0 0.50 Low Demand -700,000 -1,000,000 0 0.30 Step 3 of 3: How much should Julie be…
Twenty percent of anthropology majors were offered a starting salary greater than .
Over the years the U.S. grocery distribution and sales industry has grown. Today, the total industry sales are in the billions of dollars. Major retailers, such as Walmart and Target, added food to complement their merchandise sales and Amazon recently purchased Whole Foods. For many companies, forecasts of industry sales are necessary information to plan for short- and long-term decisions. Using the total U.S. grocery store annual sales in millions of dollars (https://www.census.gov/retail/index.html#mrts) in the following table, respond to the following items.
The new business venture, Best-In-World, has been manufacturing technology devices for over 20 years and is considering adding a new technology device to its music line. They have an established reputation for building quality devices, but they are rather novice in the music industry. The Chief Innovation and Design Officer, Julie Naugle-Hall, is tasked with hiring a marketing firm to conduct a survey to determine the feasibility and demand for their new music device. The follow decision table illustrates the potential payoffs for a high demand, moderate demand and low demand for the new music device. The decision will be whether to start production on this new device in small scale, large scale or not at all, Alternatives Answer Small-scale production Large-scale production No production Probabilities Step 1 of 3: Calculate the EMV for each alternative. Decision Table High Demand 900,000 1,500,000 0 0.25 EMV (small-scale) = = S EMV (large-scale) = = $ EMV (no production) = S State of…

Recommended textbooks for you

Advanced Engineering Mathematics

Advanced Math

ISBN:

9780470458365

Author:

Erwin Kreyszig

Publisher:

Wiley, John & Sons, Incorporated

Numerical Methods for Engineers

Advanced Math

ISBN:

9780073397924

Author:

Steven C. Chapra Dr., Raymond P. Canale

Publisher:

McGraw-Hill Education

Introductory Mathematics for Engineering Applicat…

Advanced Math

ISBN:

9781118141809

Author:

Nathan Klingbeil

Publisher:

WILEY

Advanced Engineering Mathematics

Advanced Math

ISBN:

9780470458365

Author:

Erwin Kreyszig

Publisher:

Wiley, John & Sons, Incorporated

Numerical Methods for Engineers

Advanced Math

ISBN:

9780073397924

Author:

Steven C. Chapra Dr., Raymond P. Canale

Publisher:

McGraw-Hill Education

Introductory Mathematics for Engineering Applicat…

Advanced Math

ISBN:

9781118141809

Author:

Nathan Klingbeil

Publisher:

WILEY

Mathematics For Machine Technology

Advanced Math

ISBN:

9781337798310

Author:

Peterson, John.

Publisher:

Cengage Learning,

Basic Technical Mathematics

Advanced Math

ISBN:

9780134437705

Author:

Washington

Publisher:

PEARSON

Topology

Advanced Math

ISBN:

9780134689517

Author:

Munkres, James R.

Publisher:

Pearson,

SEE MORE TEXTBOOKS