Question: Variable cells Cell Name Final Value Reduced Cost Objective Coefficient Allowable Increase Allowable Decrease $B$6 Activity 1 3 0 30 23 17 $C$6 Activity 2

Variable cells

Cell Name Final Value Reduced Cost Objective Coefficient Allowable Increase Allowable Decrease
$B$6 Activity 1 3 0 30 23 17
$C$6 Activity 2 6 0 40 50 10
$D$6 Activity 3 0 7 20 7 1E+30

Constraints

Cell Name Final Value Shadow Price Constraint R.H. Side Allowable Increase Allowable Decrease
$E$2 Resource A 20 7.78 20 10 12.5
$E$3 Resource B 30 6 30 50 10
$E$4 Resource C 18 0 40 1E+30 22

1. If the coefficient for Activity 3 in the objective function changes to $30, then the objective function value:

will increase by $70.

is $0.

will increase by $30.

will remain the same.

will increase by an unknown amount.

2. Which parameter is most sensitive to an increase in its value?

The objective coefficient of Activity 1.

The objective coefficient of Activity 2.

The objective coefficient of Activity 3.

All of the choices are correct.

None of the choices is correct.

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 Finance Questions!