Use Solver to create a Sensitivity Report for question 15 at the end of Chapter 3, and answer the following questions: a. Is the solution degenerate?

* I believe the answer is no because there are no values of 0 for any of the RHS constraints?* b. Is the solution unique?

*I believe the answer is no because the coeffiecient objective does not have any values of zero for the allowed increase or decrease?* c. Explain the signs of the reduced costs for each of the decision variables. That is, considering the optimal value of each decision variable, why does the sign of its associated reduced cost make economic sense?

d. Suppose the cost per pound for Feed 3 increased by $3. Would the optimal solution change? Would the optimal objective function value change?

e. If the company could reduce any of the nutrient requirements, which one should it choose and why?

f. If the company could increase any of the nutrient requirements, which one should it choose and why?

I have already solved problem 15 (beef up ranch) and created the sensitivity report. See pictures. Also, I think I have the correct answers for a and b, but please let me know if I am wrong.

Beef-Up Ranch Nutrient (in ounces) per pound of feed Nutrient Feed 1 Feed 2 Feed 3 Available Req'd Pounds Req'd Ounces Max Ounces 3 2 4 98 4 64 128 A B 3 1 3 80 5 80 160 C 1 0 2 32 1 16 32 D 6 8 4 200 8 128 256 $2.50 $79.25 Cost per lb Pounds per cow per mo Max Available $2.00 15 $3.00 8.5 9.5 15 15 15 Allowable Increase Variable Cells Final Reduced Objective Cell Name Value Cost Coefficient $C$11 Pounds per cow per mo Feed : 15 -3.25 2 $D$11 Pounds per cow per mo Feed : 9.5 0 2.5 $E$11 Pounds per cow per mo Feed: 8.5 0 3 3.25 1E+30 4.5 Allowable Decrease 1E+30 1.5 6.5 Constraints Oo Cell Name $F$6 A Available $F$7 B Available $F$8 C Available $F$9 D Available $F$6 A Available $F$7 B Available $F$8 C Available $F$9 D Available Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease 98 128 1E+30 30 80 160 1E+30 80 32 -2.25 32 6.33333333 3.66666667 200 0 256 1E+30 56 98 0 64 34 1E+30 2.5 80 5.5 9 32 0 16 16 1E+30 200 128 72 1E+30 80 Oona