Question: The following is the Excel Solver output of Linear Programming Problem. Vanable Cells Find Valuo 0 27.5 0 Coll Namo $B$6 Activity 1 $C$6 Activity

The following is the Excel Solver output of Linear Programming Problem. Vanable Cells Find Valuo 0 27.5 0 Coll Namo $B$6 Activity 1 $C$6 Activity 2 $D$6 Activity 3 Reduced Cost 425 0.0 250 Objectvo Coofficiant 500 300 400 Allowablo Increase 1E+30 500 1E+30 Constraints Cell Name $E$2. Benefit A $E$3 Benefit B $E$4 Benefit C Final Value 110 110 137.5 Shadow Price 0 75 0 Constraint R.H. Side 60 110 80 Allowable Increase 50 1E+30 57.5 All questions are independent. (1.25* 8 = 10) a) What is the optimal objective function value for this problem? b) If the coefficient for Activity 2 in the objective function changes to $400 objective function value: c) If the coefficient for Activity 1 in the objective function changes to $50, objective function value: d) If the coefficient of Activity 2 in the objective function changes to $100, objective function value: e) If the right-hand side of Resource B changes to 80, then the objective fu value: 1) If the right-hand side of Resource C changes to 140, then the objective value: g) If the right-hand side of Resource C changes to 130, then the shadow p Resource C will be: h) If the objective coefficients of Activity 2 and Activity 3 are both decrease then the objective function value: The following is the Excel Solver output of Linear Programming Problem. Vanable Cells Find Valuo 0 27.5 0 Coll Namo $B$6 Activity 1 $C$6 Activity 2 $D$6 Activity 3 Reduced Cost 425 0.0 250 Objectvo Coofficiant 500 300 400 Allowablo Increase 1E+30 500 1E+30 Constraints Cell Name $E$2. Benefit A $E$3 Benefit B $E$4 Benefit C Final Value 110 110 137.5 Shadow Price 0 75 0 Constraint R.H. Side 60 110 80 Allowable Increase 50 1E+30 57.5 All questions are independent. (1.25* 8 = 10) a) What is the optimal objective function value for this problem? b) If the coefficient for Activity 2 in the objective function changes to $400 objective function value: c) If the coefficient for Activity 1 in the objective function changes to $50, objective function value: d) If the coefficient of Activity 2 in the objective function changes to $100, objective function value: e) If the right-hand side of Resource B changes to 80, then the objective fu value: 1) If the right-hand side of Resource C changes to 140, then the objective value: g) If the right-hand side of Resource C changes to 130, then the shadow p Resource C will be: h) If the objective coefficients of Activity 2 and Activity 3 are both decrease then the objective function value
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
