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 1
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 tons?
Constraints
Final
Shadow
Constraint
Allowable
Allowable
Cell
Name
Value
Price
RH Side
Increase
Decrease
$G$
Heating time minutes
E
$G$
Steel Availability tons
$G$
Wood Availability tons
E
$G$
Packaging time minutes
Question options:
We need the variable cells table to determine what will happen to the objective value
Objective value will decrease by
Objective value will increase by
Objective value will decrease by
We do not know what will happen to the objective value
Objective value will increase by
Objective value will increase by
Objective value will remain the same
Objective value will decrease by
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
