Question: Considering the following excel sensitivity report: Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$12 Product 1= 0 7.5


Considering the following excel sensitivity report: Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$12 Product 1= 0 7.5 12 1E+30 7.5 $B$13 Product 2= 100 0 9 0.428571429 9 $B$14 Product 3= 0 13 16 1E+30 13 $B$15 Product 4= 0 0.5 11 1E+30 0.5 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $G$6 Process 1 (hrs) Usage 500 0 400 100 1E+30 $G$7 Process 2 (hrs) Usage 600 1.5 600 1E+30 120 $G$8 Process 3 (hrs) Usage 900 0 250 650 1E+30 $G$9 Process 4 (hrs) Usage 500 O 350 150 1E+30 which one of the following values of the "right hand side" of the first constraint (q1) would modify the current shadow price of this resource (remember: all of the other variables remain the same)? O 450 O 350 O 250 150 None of the above
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
