Question: The sensitivity report provided below was generated using Excel Solver to determine the optimal solution to a linear program. Variable Cells Final Reduced Objective Allowable

The sensitivity report provided below was

The sensitivity report provided below was generated using Excel Solver to determine the optimal solution to a linear program. Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $A$1 0 4 13 1E+30 4 $B$1 0 1.5 1E+30 1.5 $C$1 75 0 18 1.2 18 24 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $D$3 300 4.5 300 400 71.4285714 $D$4 525 0 1E+30 $D$5 300 0 700 1E+30 400 400 125 What is the optimal value of the variable in cell A1? O4 13 Infinity QUESTION 12 What is the optimal objective value? 0 O 75 O 1350 None of the above

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!