Question 4 (25 points): Prof. Yunes's daughter, Lavinia, has come up with the brilliant idea of...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Question 4 (25 points): Prof. Yunes's daughter, Lavinia, has come up with the brilliant idea of having a GBSA beach luau by the Cape Florida lighthouse, and sweet talked the vice dean into providing transportation (attagirl!). Using her wits, she convinced you to be in charge of buying the wine. To save money, you found a supplier that sells wine in 12-bottle cases, and you are trying to decide whether to buy 12 or 14 cases. Each bottle costs $15 and can be sold at the cookout for $20. Leftover (unsold) wine bottles from the luau can be sold later at an upcoming happy hour on campus for $5 each. You estimate the demand for wine bottles at the luau to be normally distributed with a mean of 135, a standard deviation of 35, and truncated between 90 and 180 bottles (rounded to the nearest integer). Make cell B1 = 15 (unit cost), cell B2 = 20 (selling price), cell B3 = 5 (salvage price), cell B4 = 144 (first order size = 12 cases x 12/case = 144 bottles), and cell C4 - 168 (second order size 14 cases x 12/case = 168 bottles). = (a) Write down the formulas needed to calculate: the demand for wine bottles in B5; the number of bottles sold for each order size in B6 and C6; the number of bottles left over for each order size in B7 and C7; and the profit for each order size in B8 and C8. Run a single simulation to estimate the mean profit for each of the two order sizes. In addition, ask the simulation add-in to monitor cell B5 (the demand) as an information cell. Use 8675309 as your random number seed and perform 1,000 trials. (b) What is the mean profit and mean standard error for each order size? Compute the 90% confidence intervals in both cases. (c) What is the probability of losing money if you order 14 cases of wine? What is the 99% confidence interval around this probability? (d) If you order 12 cases of wine, how likely are you to run out of wine at the luau? (e) In these 1,000 simulated demand scenarios, how often was the 14-case order superior to the 12-case order in terms of profit? Question 4 (25 points): Prof. Yunes's daughter, Lavinia, has come up with the brilliant idea of having a GBSA beach luau by the Cape Florida lighthouse, and sweet talked the vice dean into providing transportation (attagirl!). Using her wits, she convinced you to be in charge of buying the wine. To save money, you found a supplier that sells wine in 12-bottle cases, and you are trying to decide whether to buy 12 or 14 cases. Each bottle costs $15 and can be sold at the cookout for $20. Leftover (unsold) wine bottles from the luau can be sold later at an upcoming happy hour on campus for $5 each. You estimate the demand for wine bottles at the luau to be normally distributed with a mean of 135, a standard deviation of 35, and truncated between 90 and 180 bottles (rounded to the nearest integer). Make cell B1 = 15 (unit cost), cell B2 = 20 (selling price), cell B3 = 5 (salvage price), cell B4 = 144 (first order size = 12 cases x 12/case = 144 bottles), and cell C4 - 168 (second order size 14 cases x 12/case = 168 bottles). = (a) Write down the formulas needed to calculate: the demand for wine bottles in B5; the number of bottles sold for each order size in B6 and C6; the number of bottles left over for each order size in B7 and C7; and the profit for each order size in B8 and C8. Run a single simulation to estimate the mean profit for each of the two order sizes. In addition, ask the simulation add-in to monitor cell B5 (the demand) as an information cell. Use 8675309 as your random number seed and perform 1,000 trials. (b) What is the mean profit and mean standard error for each order size? Compute the 90% confidence intervals in both cases. (c) What is the probability of losing money if you order 14 cases of wine? What is the 99% confidence interval around this probability? (d) If you order 12 cases of wine, how likely are you to run out of wine at the luau? (e) In these 1,000 simulated demand scenarios, how often was the 14-case order superior to the 12-case order in terms of profit?
Expert Answer:
Answer rating: 100% (QA)
a The formulas needed to calculate the demand for wine bottles B5 the number of bottles sold for eac... View the full answer
Related Book For
Project Management in Practice
ISBN: 978-1119385622
6th edition
Authors: Jack R. Meredith, Scott M. Shafer, Samuel J. Mantel, Jr., Margaret M. Sutton
Posted Date:
Students also viewed these mathematics questions
-
You are trying to decide whether to buy stock in Company X or Company Y. Both companies need $1000 capital investment and will earn $200 in good years (with probability 0.5) and $60 in bad years. The...
-
A company has come up with a new selection test and decides to try it out on some of its current workers before giving it to job applicants. A group of its current workers volunteered to take the...
-
The Cambridge Opera Association has come up with a unique door prize for its December (2013) fund-raising ball: Twenty door prizes will be distributed, each one a ticket entitling the bearer to...
-
A horizontal jet of water (at 10C) that is 6 cm in diameter and has a velocity of 20 m/s is deflected by the vane as shown. If the vane is moving at a rate of 7 m/s in the x-direction, what...
-
The following transactions were completed by Clark Management Company during the current fiscal year ended December 31: July 5. Received 70% of the $21,000 balance owed by Dockins Co., a bankrupt...
-
Rouse Petroleum has spent $205,000 to refine 62,000 gallons of petroleum distillate, which can be sold for $6.30 per gallon. Alternatively, Rouse can process the distillate further and produce 56,000...
-
10. ROLE REVERSAL Prepare a short-answer question in which an employee alleges that his discharge violated public policy, but you think a court would not agree.
-
Error Corrections you have been assigned to examine the financial statements of Zarle Company for the year ended December 31, 2010. You discover the following situations. 1. Depreciation of $3,200...
-
please answer correct. The comparative balance sheets for 2021 and 2020 and the statement of income for 2021 are given below for DU): Company. Additional information from Dufs accounting records is...
-
A construction company wants to determine the optimal replacement policy for the earth mover it owns. The company has a policy of not keeping an earth mover for more than five years, and has...
-
Briefly explain how the temptation stable analysis pattern supports its objectives.
-
List some of the related design patterns that are used in formulating the temptation stable pattern.
-
List three test cases to test the class members of the temptation pattern.
-
What type of capabilities and attributes do you use to achieve analysis? Describe each one of them.
-
What is analysis? List scenarios where you can use this term in your daily life.
-
E9-3 (Algo) Preparing a Flexible Budget Performance Report [LO 9-2] Gleason Guitars produces acoustic guitars. The table below contains budget and actual information for the month of June: (Indicate...
-
Consider the following cash flows in Table P5.5. (a) Calculate the payback period for each project. (b) Determine whether it is meaningful to calculate a payback period for project D. (c) Assuming...
-
Prepare a WBS using MSP with the steps that must be completed before Vern Toomey can contact outsourcing vendors. If Vern starts on August 1, 2016, how long will it take to get ready to contact...
-
A marketing analyst has investigated each of the four threats in Problem 22 in terms of NOT being able to ameliorate them and has come up with the following values (again, on a 7 point scale) for...
-
This project involves the landscaping of a building site?
-
Marathon Inc. estimates that it will be required to spend approximately \(\$ 40,000\) to remove an underground storage tank in 10 years that was constructed in 2020 for \(\$ 300,000\). The present...
-
The following information pertains to a fire insurance policy in effect during the calendar year 2020, covering Vail Company's inventory: Vail's inventory averages \(\$ 500,000\) uniformly throughout...
-
A manufacturer of household appliances has potential losses due to the discovery of a possible defect in one of its products. The occurrence of the loss is reasonably possible, and the costs can be...
Study smarter with the SolutionInn App