The Super Cola Company must decide whether or not to introdu

The Super Cola Company must decide whether or not to introduce a new diet softdrink. Management feels that if it does introduce the diet soda it will yield a profit of $1.25 million if sales are around 100 million, a profit of $200,000 if sales are around 60 million, or it will lose $1.85 million if sales are only around 1 million bottles. If Super Cola does not market the new diet soda, it will suffer a loss of $600,000. a. Construct a payoff table for this problem on excel b. Construct a regret (opportunity loss) table for this problem on excel

Solution