# Question: The Royal Cola Company is considering developing a special new

The Royal Cola Company is considering developing a special new carbonated drink to add to its standard product line of drinks for a couple years or so (after which it probably would be replaced by another special drink). However, it is unclear whether the new drink would be profitable, so analysis is needed to determine whether to go ahead with the development of the drink. If so, once the development is completed, the new drink would be marketed in a small regional test market to assess how popular the drink would become. If the test market suggests that the drink should become profitable, it then would be marketed nationally.

Here are the relevant data. The cost of developing the drink and then arranging to test it in the test market is estimated to be $40 million. A total budget of $100 million has been allocated to advertising the drink in both the test market and nationally (if it goes national). A minimum of $5 million is needed for advertising in the test market and the maximum allowed for this purpose would be $10 million, which would leave between $90 million and $95 million for national advertising. To simplify the analysis, sales in either the test market or nationally is assumed to be proportional to the level of advertising there (while recognizing that the rate of additional sales would fall off after the amount of advertising reaches a saturation level). Excluding the fixed cost of $40 million, the net profit in the test market is expected to be half the level of advertising.

To further simplify the analysis, the outcome of testing the drink in the test market would fall into just three categories: (1) very favorable, (2) barely favorable, (3) unfavorable. The probabilities of these outcomes are estimated to be 0.25, 0.25, and 0.50, respectively. If the outcome were very favorable, the net profit after going national would be expected to be about twice the level of advertising. The corresponding net profit if the outcome were barely favorable would be about 0.2 times the level of advertising. If the outcome were unfavorable, the drink would be dropped and so would not be marketed nationally.

Use stochastic programming with recourse to formulate a model for this problem. Assuming the company should go ahead with developing the drink, solve the model to determine how much advertising should be done in the test market and then how much advertising should be done nationally (if any) under each of the three possible outcomes in the test market. Finally, calculate the expected value (in the statistical sense) of the total net profit from the drink, including the fixed cost if the company goes ahead with developing the drink, where the company should indeed go ahead only if the expected total net profit is positive.

Here are the relevant data. The cost of developing the drink and then arranging to test it in the test market is estimated to be $40 million. A total budget of $100 million has been allocated to advertising the drink in both the test market and nationally (if it goes national). A minimum of $5 million is needed for advertising in the test market and the maximum allowed for this purpose would be $10 million, which would leave between $90 million and $95 million for national advertising. To simplify the analysis, sales in either the test market or nationally is assumed to be proportional to the level of advertising there (while recognizing that the rate of additional sales would fall off after the amount of advertising reaches a saturation level). Excluding the fixed cost of $40 million, the net profit in the test market is expected to be half the level of advertising.

To further simplify the analysis, the outcome of testing the drink in the test market would fall into just three categories: (1) very favorable, (2) barely favorable, (3) unfavorable. The probabilities of these outcomes are estimated to be 0.25, 0.25, and 0.50, respectively. If the outcome were very favorable, the net profit after going national would be expected to be about twice the level of advertising. The corresponding net profit if the outcome were barely favorable would be about 0.2 times the level of advertising. If the outcome were unfavorable, the drink would be dropped and so would not be marketed nationally.

Use stochastic programming with recourse to formulate a model for this problem. Assuming the company should go ahead with developing the drink, solve the model to determine how much advertising should be done in the test market and then how much advertising should be done nationally (if any) under each of the three possible outcomes in the test market. Finally, calculate the expected value (in the statistical sense) of the total net profit from the drink, including the fixed cost if the company goes ahead with developing the drink, where the company should indeed go ahead only if the expected total net profit is positive.

## Answer to relevant Questions

Consider the following problem. Minimize Z = 5x1 + c2x2, Subject to and x1 ≥ 0, x2 ≥ 0, where x1 represents the level of activity 1 and x2 represents the level of activity 2. The values of c2, a12, and a22 have not been ...After setting goals for how much the sales of three products should increase as a result of an upcoming advertising campaign, the management of the Profit & Gambit Co. now wants to explore the trade-off between advertising ...Consider the following problem. Maximize Z = x1 – x2, Subject to and x1 ≥ 0, x2 ≥ 0, (a) Solve this problem graphically. (b) Use the dual simplex method manually to solve this problem. (c) Trace graphically the path ...Use the upper bound technique manually to solve the following problem. Maximize Z = 2x1 + 3x2 – 2x3 + 5x4, subject to and Starting from the initial trial solution (x1, x2) = (2, 2), use your IOR Tutorial to apply 15 iterations of the interior-point algorithm presented in Sec. 8.4 to the Wyndor Glass Co. problem presented in Sec. 3.1. Also draw ...Post your question