Question: Variable cells Reduced Cost Cell Name $B$6 Activity 1 $C$6 Activity 2 $D$6 Activity 3 Constraints Final Value 3 6 B Objective Coefficient 30 40

 Variable cells Reduced Cost Cell Name $B$6 Activity 1 $C$6 Activity
2 $D$6 Activity 3 Constraints Final Value 3 6 B Objective Coefficient
30 40 20 Allowable Increase Allowable Decrease 23 17 50 10 7
1E+30 -7 Cell SE$2 SES3 SE54 Name Resource A Resource B Resource

Variable cells Reduced Cost Cell Name $B$6 Activity 1 $C$6 Activity 2 $D$6 Activity 3 Constraints Final Value 3 6 B Objective Coefficient 30 40 20 Allowable Increase Allowable Decrease 23 17 50 10 7 1E+30 -7 Cell SE$2 SES3 SE54 Name Resource A Resource B Resource Final Value 20 30 18 Shadow Price 7.78 6 Constraint R.H. Side 20 30 40 Allowable Increase 18 5e 1E +30 Allowable Decrease 12.5 10 22 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 Variable cells Reduced Cost Final Value 3 6 Celi Name $B$6 Activity 1 $C$6 Activity 2 $D$6 Activity 3 Constraints Objective Coefficient 30 40 20 23 Allowable Increase Allowable Decrease 17 10 7 1E +30 a 50 -7 Cell SE$2 SE$3 $E$4 Name Resource A Resource B Resource Final Value 20 30 18 Shadow Price 7.78 6 Constraint R.H. Side 20 30 40 Allowable Increase 10 se 1E+30 Allowable Decrease 12.5 10 22 If the coefficient of Activity in the objective function changes to $10, therr the original solution remains optimal. the problem must be resolved to find the optimal solution the shadow price is valid the shadow price is not valid None of the above

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!