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 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 20Step 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
