This problem is based on problem 7.6-3 of chapter 7 of the Introduction to Operations Research, Hillier and Lieberman 11ed textbook. Refer to problem 7.6-3 in the textbook, fill in the blanks below, use SAS to solve the problem, and report the objective value and the optimal solution. Attach all the SAS outputs below.

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 deter-mine whether to go ahead with the development of the drink. If so, once the development is completed, the new drink would be mar-keted 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 mil-lion. 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). Ex-cluding 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 favor-able, (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 correspond-ing 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.

The decision variables are:

x₁: test market advertising

x₂₁: national campaign advertising if test market is very favorable

x₂₂: national campaign advertising if test market is barely favorable

x₂₃: national campaign advertising if test market is unfavorable

Maximize Z = ___ ( ___x₁ +___ x₂₁) + ___ ( ___x₁ +___ x₂₂) + ___ ( ___x₁) - 40

= ___x₁ +___ x₂₁ + ___ x₂₂) - 40

subject to

x₁ ___ 5

x₁ ____

x₁ + x₂₁ ___ ____

x₁ + x₂₂ ____

x₁ + x₂₂ ___ ____

x₁ + x₂₃ ____

and

x₁ 0, x₂₁ 0, x₂₂ 0, x₂₃ 0.