Question: Please answer 4-15 and explain how you got your answer. 4-15 Consider the Whole Food Nutrition Center diet problem example discussed in Section 3.7 (page

Please answer 4-15 and explain how you got yourPlease answer 4-15 and explain how you got yourPlease answer 4-15 and explain how you got your answer.

4-15 Consider the Whole Food Nutrition Center diet problem example discussed in Section 3.7 (page 89) of Chapter 3. Use the Sensitivity Report for this LP model (shown in Screenshot 4-8 on page 150) to answer the following questions. Each question is independent of the others. (a) What is the impact if the daily allowance for protein can be reduced to 2.9 units? (b) Whole Food believes the unit price of grain A could be 5% overestimated and the unit price of grain B could be 10% underestimated. If these turn out to be true, what is the new optimal solu- tion and optimal total cost? What is the impact if the reduction in the daily allowance for protein in (a) requires Whole Food to simultaneously increase the daily allowance of riboflavin to 2.20 units? Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$5 Number of pounds Grain A 0.025 0.000 0.330 0.063 1E+30 $C$5 Number of pounds Grain B 0.050 0.000 0.470 1E+30 0.190 $D$5 Number of pounds Grain C 0.050 0.000 0.380 1E+30 0.073 Constraints Cell Name $E$8 Protein $E$9 Riboflavin SE$10 Phosphorus SE$11 Magnesium $E$12 Total Mix Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease 3.000 0.038 3.000 0.000 0.250 2.350 0.000 2.000 0.350 1E+30 1.000 0.088 1.000 0.018 0.000 0.425 0.000 0.425 0.000 1E+30 0.125 -1.210 0.125 0.004 0.000

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!