Question: Using the Sensitivity Analysis Report below, what is the optimal objective function value for this problem? Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name
Using the Sensitivity Analysis Report below, what is the optimal objective function value for this problem?
| Adjustable Cells | |||||||||
| Final | Reduced | Objective | Allowable | Allowable | |||||
| Cell | Name | Value | Cost | Coefficient | Increase | Decrease | |||
| $B$12 | Solution Product 1 | 75 | 0 | 9 | 1 | 1 | |||
| $C$12 | Solution Product 2 | 0 | -1.5 | 9 | 1.5 | 1E+30 | |||
| $D$12 | Solution Product 3 | 75 | 0 | 6 | 3 | 0.6 | |||
| Constraints | |||||||||
| Final | Shadow | Constraint | Allowable | Allowable | |||||
| Cell | Name | Value | Price | R.H. Side | Increase | Decrease | |||
| $B$15 | Resource 1 LHS | 600 | 1.5 | 600 | 150 | 50 | |||
| $B$16 | Resource 2 LHS | 525 | 0 | 600 | 1E+30 | 75 | |||
| $B$17 | Resource 3 LHS | 375 | 0 | 480 | 1E+30 | 105 | |||
| $B$18 | Resource 4 LHS | 150 | 1.5 | 150 | 7.894736842 | 30 | |||
| a. | $450 | |
| b. | $675 | |
| c. | $1125 | |
| d. | $112.5 | |
| e. | $1575 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
