Question: Given the below table generated by Excel Solver's sensitivity analysis: What will happen to the objective value if the Steel availability is increased by 12
Given the below table generated by Excel Solver's sensitivity analysis: What will happen to the objective value if the Steel availability is increased by 12 tons? Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $G$10 Heating time (minutes) 300 0 400 1E 30 100 $G$11 Steel Availability (tons) 400 2 400 200 50 $G$12 Wood Availability (tons) 500 0 600 1E 30 100 $G$13 Packaging time (minutes) 700 3 700 300 200 Question 1 options: Objective value will decrease by 400 We need the variable cells table to determine what will happen to the objective value Objective value will increase by 24 Objective value will decrease by 24 We do not know what will happen to the objective value Objective value will increase by 2 Objective value will increase by 400 Objective value will remain the same Objective value will decrease by 2
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
