Question: Please read the question carefully before giving your answer. Only the techniques that you have learned in the course will be accepted! 04. (20 pts)

Please read the question carefully before giving

Please read the question carefully before giving your answer. Only the techniques that you have learned in the course will be accepted! 04. (20 pts) Given the Excel Solver output: a) Give the mathematical model. Notel: The isn't any free variable (urs) in the primal model. Note: If a constraint is binding, then assign the sign of the constraint as equality. b) Give the dual of the LP that you find in part (a). Note3: Don't multiply a constraint by -1 to change the sign of the constraint of the primal model before finding the dual. c) Give the dual optimal solution (w* and y* values) based on the Excel Solver output. (Don't attempt to solve it!) Answer Report Objective Cell (Max) Cell Name Original Value Final Value $D$4 0 19.33333333 Variable Cells Cell Name Original Value Final Value Integer $B$3 x1 04.666666667 Contin $C$3 x2 0 0.666666667 Contin Constraints Cell Name $D$6 x1+2x2 $D$7 x1-x2 $D$8 2x1+x2 0 Cell Value Formula Status Slack 6 $D$6=$F$6 Binding 4 $D$7>=$F$7 Not Binding 1 10 $D$8=$F$8 Binding 0 Sensitivity Report Variable Cells Final Reduced Cost Cell Name Value $B$3 x1 4.666666667 $C$3 x2 0.666666667 Objective Allowable Allowable Coefficient Increase Decrease 4 1E+30 1E+30 1 1E+30 1E+30 0 0 Constraints Final Value Cell Name $D$6 x1+2x2 $D$7 x1-x2 $D$8 2x1+x2 Shadow Price 6 -0.666666667 4 0 10 2.333333333 Constraint Allowable Allowable R.H. Side Increase Decrease 6 1 1 3 1 1E+30 10 2 1

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!