Question: 1 pts Using the Sensitivity Analysis Report below, if the company could obtain either additional Resource 1 or Resource 3, which one should they choose

1 pts Using the Sensitivity Analysis Report
1 pts Using the Sensitivity Analysis Report
1 pts Using the Sensitivity Analysis Report below, if the company could obtain either additional Resource 1 or Resource 3, which one should they choose and how much would the objective function change (assuming additional quantities cost the same as usual? Adjustable Cells Final Reduced Objective Allowable Value Cost Coefficient Increase Allowable Decrease 75 9 1 1 Cell Name Solution $B$12 Product 1 Solution $C$12 Product 2 Solution $D$12 Product 3 0 -15 9 1.5 1E+30 75 0 3 0.6 Constraints Final Shadow Constraint Allowable Value Price R.H. Side Increase Allowable Decrease 600 1.5 600 150 SO 5250 600 1E430 75 Cell Name Resource 1 $B$15 LHS $B$16 Resource 2 LHS $8517 Resource 3 LHS Resource 4 SB$18 LHS 3750 480 1E30 105 150 1.5 150 7,89473684230 600 1.5 600 150 50 5250 600 1E+30 75 $B$15 LHS Resource 2 $B$16 LHS Resource 3 $B17 LHS Resource 4 $B$18 LHS 3750 480 1E+30 105 150 1.5 150 7.89473684230 150 units of Resource for $225 increased roht 150 units of Resource for $225 de 7.89 unity of R3511 7.89 units of source for Sot The shadow price for Resources 1 and 3 $1.50 so either would benefit the company equally

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!