Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hi, I am working on a linear programming problem and generated the following sensitivity report. I am wondering how to answer the questions that go
Hi, I am working on a linear programming problem and generated the following sensitivity report. I am wondering how to answer the questions that go along with the sensitivity report. Thank you
No. Row name St Activity Slack Marginal Lower bound Upper bound Activity range Obj coef obj value at Limiting range break point variable 1 c_1_Vitamins BS 27.97004 -7.97004 2 20.00000 +Inf 30.63731 27.97004 .09625 +Inf 5.63993 raisins +Inf 2 c_1_Minerals BS 10.07913 -.07913 10.00000 +Inf 10.60259 9.35579 -.49045 .66667 3.38878 raisins 15.05155 walnuts 3 c_1_Protein_ NL 15.00000 15.00000 +Inf 14.68083 22.29375 -. 17769 +Inf 8.27542 C_1_Minerals_ 9.62812 seeds . 17769 4 c_1_Calories NL 600.00000 600.00000 +Inf 591.67391 6436.500ee -.00764 +Inf 8.26848 c_1_Minerals_ 52.95000 flakes .00764 5 c_e_ONE_VAR_CONSTANT NS 1.00000 1.00000 1.00000 - Inf +Inf 8.33213 ONE_VAR_CONSTANT 8.33213 +Inf GLPK 4.65 - SENSITIVITY ANALYSIS REPORT Page 2 No. Column name St Activity Obj coef Marginal Lower bound Upper bound Activity range obj coef obj value at Limiting range break point variable 1 flakes BS 1.35589 3.00000 . 15eee +Inf 2.10938 1.25907 1.2800e 5.65161 6.00000 c_1_Protein_ 11.92742 raisins 2 pecans NL . 15000 7 7.00000 4.35124 . 1500e +Inf .13600 .58545 2.64876 +Inf 8.27122 c_1_Minerals_ 10.22687 seeds 3 raisins NL . 15000 5 5.00000 .84917 . 15000 +Inf . 10430 .45233 4.15083 +Inf 8.29332 c_1_Minerals 8.58886 seeds 4 seeds BS .39112 4.00000 . 1500e +Inf 12.45000 -2.61194 .30cea 5.06477 6.88500 c_1_Calories_ 8.74858 raisins 5 walnuts NL . 15000 6.00000 2.eeeee . 15000 +Inf -.64700 . 17638 4.00000 +Inf 6.73812 c_1_Vitamins 8.38488 C_1_Minerals 6 ONE_VAR_CONSTANT BS 1.00000 1.00000 1.00000 -Inf +Inf -Inf +Inf +Inf 1. Suppose that the cost per pound for pecans increases to $9. What is the optimal solution now? What is the optimal value? 2. Suppose that the cost per pound for pecans decreases to $4. What is the optimal solution now? What is the optimal value? 3. Suppose that the cost per pound for pecans decreases to $2. What is the optimal solution now? What is the optimal value? 4. Suppose that the cost per pound for flakes increases to $7. What is the optimal solution now? What is the optimal value? 5. Suppose that the cost per pound for flakes increases to $3.50. What is the optimal solution now? What is the optimal value? 6. Suppose that the cost per pound for flakes decreases to $1.50. What is the optimal solution now? What is the optimal value? 7. Suppose that the cost per pound for flakes decreases to $1.00. What is the optimal solution now? What is the optimal value? 8. Suppose we drop the restriction on the amount of grams of minerals required. What is the optimal solution now? What is the optimal value? 9. Suppose we raise the restriction on the amount of grams of minerals required to 11. What is the optimal solution now? What is the optimal value? 10. Suppose we raise the restriction on the amount of grams of protein required to 17. What is the optimal solution now? What is the optimal value? No. Row name St Activity Slack Marginal Lower bound Upper bound Activity range Obj coef obj value at Limiting range break point variable 1 c_1_Vitamins BS 27.97004 -7.97004 2 20.00000 +Inf 30.63731 27.97004 .09625 +Inf 5.63993 raisins +Inf 2 c_1_Minerals BS 10.07913 -.07913 10.00000 +Inf 10.60259 9.35579 -.49045 .66667 3.38878 raisins 15.05155 walnuts 3 c_1_Protein_ NL 15.00000 15.00000 +Inf 14.68083 22.29375 -. 17769 +Inf 8.27542 C_1_Minerals_ 9.62812 seeds . 17769 4 c_1_Calories NL 600.00000 600.00000 +Inf 591.67391 6436.500ee -.00764 +Inf 8.26848 c_1_Minerals_ 52.95000 flakes .00764 5 c_e_ONE_VAR_CONSTANT NS 1.00000 1.00000 1.00000 - Inf +Inf 8.33213 ONE_VAR_CONSTANT 8.33213 +Inf GLPK 4.65 - SENSITIVITY ANALYSIS REPORT Page 2 No. Column name St Activity Obj coef Marginal Lower bound Upper bound Activity range obj coef obj value at Limiting range break point variable 1 flakes BS 1.35589 3.00000 . 15eee +Inf 2.10938 1.25907 1.2800e 5.65161 6.00000 c_1_Protein_ 11.92742 raisins 2 pecans NL . 15000 7 7.00000 4.35124 . 1500e +Inf .13600 .58545 2.64876 +Inf 8.27122 c_1_Minerals_ 10.22687 seeds 3 raisins NL . 15000 5 5.00000 .84917 . 15000 +Inf . 10430 .45233 4.15083 +Inf 8.29332 c_1_Minerals 8.58886 seeds 4 seeds BS .39112 4.00000 . 1500e +Inf 12.45000 -2.61194 .30cea 5.06477 6.88500 c_1_Calories_ 8.74858 raisins 5 walnuts NL . 15000 6.00000 2.eeeee . 15000 +Inf -.64700 . 17638 4.00000 +Inf 6.73812 c_1_Vitamins 8.38488 C_1_Minerals 6 ONE_VAR_CONSTANT BS 1.00000 1.00000 1.00000 -Inf +Inf -Inf +Inf +Inf 1. Suppose that the cost per pound for pecans increases to $9. What is the optimal solution now? What is the optimal value? 2. Suppose that the cost per pound for pecans decreases to $4. What is the optimal solution now? What is the optimal value? 3. Suppose that the cost per pound for pecans decreases to $2. What is the optimal solution now? What is the optimal value? 4. Suppose that the cost per pound for flakes increases to $7. What is the optimal solution now? What is the optimal value? 5. Suppose that the cost per pound for flakes increases to $3.50. What is the optimal solution now? What is the optimal value? 6. Suppose that the cost per pound for flakes decreases to $1.50. What is the optimal solution now? What is the optimal value? 7. Suppose that the cost per pound for flakes decreases to $1.00. What is the optimal solution now? What is the optimal value? 8. Suppose we drop the restriction on the amount of grams of minerals required. What is the optimal solution now? What is the optimal value? 9. Suppose we raise the restriction on the amount of grams of minerals required to 11. What is the optimal solution now? What is the optimal value? 10. Suppose we raise the restriction on the amount of grams of protein required to 17. What is the optimal solution now? What is the optimal valueStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started