Question

In: Statistics and Probability

Please use Excel and show steps!! Greentrop Pharmaceutical Products are the world leader in the area...

Please use Excel and show steps!! Greentrop Pharmaceutical Products are the world leader in the area of sleep aids. Its major product is “Dozealot”. The Research-and-Development Division has defined two alternatives to improve the quality of the product. These alternatives are simple reformulations of the product to minimize the side effects and to improve the product efficacy. To conduct an analysis, management has decided to consider the possible demands for the drug under each alternative. The following payoff table shows the projected profit in millions of dollars.If the decision maker knows nothing about the probabilities of three states of nature, what is the recommended decision using the optimistic, conservative, and minimax regret approaches?

Demand
Decision Alternatives Low Medium High
d1 $500 $350 $525
d2 $875 $300 $765

Solutions

Expert Solution

ANSWER:

In the problem, two quality improvment products d1 and d2 can be maufactured. Each of them will face three different evironment viz, low , medium and high. The demand are shown in dollar. Based on given figures, following decision tree has been developed.

-----------------------------------------------------------------------------------------------------------------

Answer (b): If probabilities of each alternatives are known, then decision maker can calculate expected value to determine, optimum product. But when probabilties are not known, he has to apply different methods of taking decision under uncertain evironment. They are-

Optimistic method: In this method, decision maker will assume that nature is always kind to him. So it will behave in a manner to optimize the demand. If decision maker select d1, then nature behaving optimistically will create high evironment where demand is highest i.e. $525. On the other hand, if he select strategy d2, then nature will recommend low evironment, so that optimum demand is $875. Now compare $525 and $875. Highest is $875. So d2 will be selected.

Note that here decision maker has first selected maximum payoff of each row. Then he has selected maximum of row maxima. Due to this reason, this principle is known as maximax.

Conservative: It is just opposite of first one. Here nature is expected to behave in a conservative manner. So it will create a situation, which will minimize his pay off. Thus decision maker will select minimum value of each row. Then from minimum row value best one is selected. It is known as maximin technique.

Minimum pay off of each row is $350 and $300. Among these two maximum value is $350. It is related with d1. So d1 is selected under Conservative method.

Minimax regret: It is also known as Savage method. Steps are-

1. First calculate regret value of each cell of two rows. It is the deviation of cell value from maximum value of the row. In row 1, maximum value is $525. Now first cell value is $500. So deviation is $525-$500=$25. It is known as regret value. Develop regret matrix first. It is shown below:

2.Here regret is like a loss that decision maker will suffer from optimum payoff. So he will try to minimize regret value. But nature ise xpected to behave in a conservative manner. It will always try to maximize regret value. If d1is selected, then nature will create medium, so that regret is highest for row 1. It is $175. Similarly for row 2, it is $575.

3. Finally, decision maker will select minimum of row maxima. It is $175. So d1 is selected.

THIS IS A 100% RIGHT ANSWER

SO PLEASE RATE ME POSITIVE

THANKS.


Related Solutions

PLEASE SHOW HOW TO SOLVE IN EXCEL SHOW STEPS Refer to the Johnson Filtration problem introduced...
PLEASE SHOW HOW TO SOLVE IN EXCEL SHOW STEPS Refer to the Johnson Filtration problem introduced in this section. Suppose that in addition to information on the number of months since the machine was serviced and whether a mechanical or an electrical repair was necessary, the managers obtained a list showing which repairperson performed the service. The revised data follow. Repair Time in Hours Months Since Last Service Type of Repair Repairperson 2.9 2 Electrical Dave Newton 3 6 Mechanical...
SHOW STEPS IN EXCEL PLEASE Consider the following data on price ($) and the overall score...
SHOW STEPS IN EXCEL PLEASE Consider the following data on price ($) and the overall score for six stereo headphones tested by a certain magazine. The overall score is based on sound quality and effectiveness of ambient noise reduction. Scores range from 0 (lowest) to 100 (highest). Brand Price ($) Score A 180 76 B 150 71 C 95 61 D 70 58 E 70 40 F 35 24 (a) The estimated regression equation for this data is ŷ =...
PLEASE EXPLAIN STEPS AND SOLUTIONS ( NO EXCEL ) Polk Products is considering an investment project...
PLEASE EXPLAIN STEPS AND SOLUTIONS ( NO EXCEL ) Polk Products is considering an investment project with the following cash flows (in 000s): Year 0 Year 1 Year 2 Year 3 Cashflow -100 90 90 30 The company has a 10% cost of capital. What is the payback period for the project? What is the discounted payback period for the project? What is the IRR for the project? What is the NPV for the project? What is the MIRR for...
Please solve A, B, and C. Please use excel. Please show work. Thank you. A. Use...
Please solve A, B, and C. Please use excel. Please show work. Thank you. A. Use the stocks of Apple, SAP, IBM, Oracle, and Amazon Download the historical data of weekly stock prices and S&P 500 index prices from year 2017-2019 on the website of yahoo finance and save it on an excel file. B. Use a different sheet to save the market adjusted prices of Apple, SAP, IBM, Oracle, and Amazon t and the index. For each stock, compute...
***Excel is required to solve this problem. Please use excel and show all formulas used in...
***Excel is required to solve this problem. Please use excel and show all formulas used in each cell I would really appreciate the work*** Three-Stage FCFE Model: Biomet Inc., designs, manufactures and markets reconstructive and trauma devices, and reported earnings per share of $0.56 in 1993, on which it paid no dividends. (It had revenues per share in 1993 of $2.91). It had capital expenditures of $0.13 per share in 1993 and depreciation in the same year of $0.08 per...
Please could you show full steps and no excel please Miss M had R100,000 to invest...
Please could you show full steps and no excel please Miss M had R100,000 to invest in the financial market. She chose to invest R10,000 in Asset A, which returned 12.0%; R40,000 in Asset B which returned 15.0%; R20,000 in Asset C which returned –5.0%, and the remaining in Asset D which returned 5%. The correlation between the assets are ρAB = 0.75, ρAC = 0.35, ρAD = 1, ρBC = –0.5, ρBD = 0.25, and ρCD = -1. The...
Please explain your answers and use Excel to show the excel formula you used to get...
Please explain your answers and use Excel to show the excel formula you used to get your solution. 6. A manufacturing process produces connecting rods whose diameter is normally distributed with mean 1.495 cm and standard deviation .05 cm. In what range will the “middle 80%” of the diameters lie? What about the “middle 98%”?
PLEASE COMPLETE IN EXCEL AND SHOW ALL STEPS AND EXCELL EQUATIONS USED In our class example,...
PLEASE COMPLETE IN EXCEL AND SHOW ALL STEPS AND EXCELL EQUATIONS USED In our class example, I simplified the “annuity” prize option by assuming level, equal annual payments. Actually, this annuity prize option us now on an annuitized prize payment schedule with 30 beginning of year payments that start at a lower amount with each successive payment being 5% higher than the previous annual payment. The sum of these 30 annuitized payments equal the announced estimated jackpot amount with a...
Please if you could do each problem, and show steps for excel! Thank you! You will...
Please if you could do each problem, and show steps for excel! Thank you! You will graduate in a few years and start working and it’s never too early to start planning for your retirement and other financial events. Let’s fast forward to the beginning of your career. Here’s some assumptions to help you get started. Your starting annual salary will be $60,000. You plan to work for 43 years before retiring. You expect your salary to grow at an...
Please solve using EXCEL SOLVER and show steps 1 – A company requires during the next...
Please solve using EXCEL SOLVER and show steps 1 – A company requires during the next four months, respectively, 50, 65, 100, and 70 units of a commodity (no backlogging is allowed). Production costs are $5, $8, $4, and $7 per unit during these months. The storage cost from one month to the next is $2 per unit (assessed on ending inventory). It is estimated that each unit on hand at the end of month 4 could be sold for...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT