Question: This is output from a MINIMIZATION problem. I want to remind you that when Excel reports dual variables (shadow prices), the shadow price = (Objective

This is output from a MINIMIZATION problem. I want to remind you that when Excel reports dual variables (shadow prices), the shadow price = (Objective value AFTER right hand side change of +1) (Objective value BEFORE RHS change). Excel does not care if the problem is a maximization or a minimization when reporting dual variables (unlike some other solvers).

Answer this question with respect to Test 4 Output posted in Canvas. Which of the following statements is true?

Group of answer choices

If the right hand side for constraint 1 is changed to 241 and the problem is re-solved, the new optimal solution value is 411.5.

If the right hand side for constraint 2 is changed to 4 and the problem is re-solved, the new optimal solution value is -17.

In the original optimal solution, X1 = 40 and X2 = 40.

If the right hand side of constraint 2 is changed to 102, the new optimal solution value is 408. This can be inferred from the dual variable for constraint 2.

This is output from a MINIMIZATION problem. I

Objective = Minimize (-1*X1) + (-2*x2). X1 OBJ X2 3 VAR--> VALUES 6 -15 MINIMIZE RHS RHS CONSTRAINTS Constraint 1 Constraint 2 Constraint 3 1 = Microsoft Excel 14.0 Sensitivity Report Worksheet: (TEST2-OUTPUT1-SUMMER14.xlsx]OUTPUT2 Report Created: 7/21/2014 6:46:48 PM Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $E$2 VAR--> X1 3 0 -1 3 1E+30 $F$2 VAR--> X26 0 -2 2 1E+30 Constraints Cell Name $K$10

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!