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

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!