Variable cells 27 Final Value 3 Reduced Cost Objective Coefficient Allowable Increase 0 30 23 Cell Name $B$6 Activity 1 $C$6 Activity 2 $D$6 Activity 3 Constraints Allowable Decrease 17 10 6 50 40 20 0 -7 7 1E+30 Skipped Shadow Final Value Allowable Increase Price Constraint R.H. Side 20 10 Cell $E$2 $E$3 $E$4 Name Resource A Resource B Resource C 20 30 7.78 6 eBook Allowable Decrease 12.5 10 22 30 50 18 40 1E+30 References If the right-hand side of Resource A changes to 10, then the objective function value: Multiple Choice will decrease by $12.50. can only be discovered by resolving the problem. o will decrease by $77.80. O will remain the same. will decrease by $125. Final Value Reduced Cost Objective Coefficient 30 40 Allowable Decrease 17 Cell Name $B$6 Activity 1 $C$6 Activity 2 $D$6 Activity 3 Constraints 3 Allowable Increase 23 50 7 6 10 1E+30 0 -7 20 Final Value 20 Shadow Price 7.78 Constraint R.H. Sidel 20 Allowable Increase 10 Allowable Decrease 12.5 Cell $E$2 $E$3 $E$4 Name Resource A Resource B Resource C 30 6 10 30 40 50 1E+30 18 22 What is the optimal objective function value for this problem? Multiple Choice $7.78 $90 It cannot be determined from the given information. $240 $330