Which strategy is best for super cola

Assignment Help Operation Management

Reference no: EM131750879

The Super Cola Company must decide whether or not to introduce a new diet soft drink. Management feels that if it does introduce the diet soda it will yield a profit of 1.25 million if sales are 100 million, a profit of 300,000 if sales are 50 million, or it will lose 1.75 million if sales are only 1 million bottles. If super Cola does not market the new diet soda it will suffer a loss of 450,000. TO be done in excel a. Construct a payoff table for this problem b. construct a regret (opportunity loss) table for this problem. c. An internal marketing research study has found P (100 million in sales)=1/3; P(50 million in sales)=1/2; p(1 million in sales)=1/6. Should super cola introduce the new diet soda based on expected profits? d. Based on expected opportunity losses, which strategy is best for super cola? e. What is the EVPI (expected value of perfect info) f. A consulting firm can perform a more thorough study for 300,000. Should management have this study performed. g if the conditional probablities are .75 .15 and .10 for the three states, what would b the expected value of sample information. (EVSI) Formulas in excel.

Reference no: EM131750879

Questions Cloud

Material delay-employee absences : For the past month, a plant that has an effective capacity of 6,400 has made only 5,000 hammers per day because of material delay, employee absences,

What are the shortcomings of your identified regulations : What are the benefits and shortcomings of your identified regulations? Which of these shortcomings have an effect on the quality and the cost of health care ser

What is swifty payout ratio : Assume that all balance sheet amounts represent average balance figures. What is Swifty's payout ratio

What might an integrated supply chain look like : What might an integrated supply chain look like for a financial services company such as an insurance provider or a bank?

Which strategy is best for super cola : Super Cola Company must decide whether or not to introduce a new diet soft drink. Based on expected opportunity losses, which strategy is best for super cola?

What is the economic order quantity : The Alpha Corporation's demand for a particular raw material is constant at 5,000 units per 90-day period. Fixed ordering costs are $60 and holding costs.

Discuss cash and cash equivalents : Identify the Note that discusses 'Cash and cash equivalents' and summarize it

What strategy would you employ to mitigate the fallout : What strategy(ies) would you employ to mitigate the fallout from it?

What made the given issue important to you : Prepare a paper on this article/video in which you explain why you chose it. What made this issue important to you?

User Account

All Pages