Question: Please show the steps clearly Given the Excel Solver output: a) Give the mathematical model. Notel: The isn't any free variable (urs) in the primal

Please show the steps clearly Given the Excel

Please show the steps clearly Given the Excel

Please show the steps clearly Given the Excel

Please show the steps clearly

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 b) Give the dual of the LP that you find in part (a). Note3: Don't multiply a by -1 to change the sign of the constraint of the primal model before find c) Give the dual optimal solution (w* and y* values) based on the Excel Solve (Don't attempt to solve it!) Answer Report Objective Cell (Max) Cell Name Original Value Final Value $D$4 0 1350 Variable Cells Cell Name Original Value Final Value $B$3 x1 0 40 $C$3 x2 Integer Contin Contin Constraints Cell Name $D$6 X1+2x2 Status Slack Cell Value 150 Formula SD$6-SFS6 Binding Variable Cells Cell Name Original Value Final Value $B$3 X1 0 40 $C$3 X2 0 55 Integer Contin Contin Constraints Cell Name $D$6 X1+2x2 $D$7 x1 $D$8 x2 Cell Value 150 Formula Status Slack $D$6=$F$6 Binding $D$7=$F$8 Not Binding 35 40 55 Sensitivity Report Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$3 x1 40 1E+30 $C$3 x2 55 30 Constraints Final Shadow - Constraint Allowable. Allowable Cell Name Value RH. Side Decrease $D$6 X1+2x2 CO x 1 Cell Nama CV $D$6 X1+232150 $D$7 x1 40 $D$8 Formula Slack SO$6-$F$6 Binding 0 $D$7c=$F$7 Binding 0 $D$$=$F$8 Not Binding 35 55 Sensitivity Report Varlable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$3 1E+30 $C$3 55 0 10 1E+30 20 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $D$6 x1+2x2 150 1 E+30 $D$7 $D$8 1E+30 5 70 15 20

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!