read the question carefully before giving your answer. Only the techniques that you have learned in the course will be accepted! Q4. (20 pts). Given the Excel Solver output: a) Give the mathematical model. Notel: The isn't any free variable (urs) in the primal model. Note2: 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 Variable Cells 0 1350 Cell Name Original Value Final Value $B$3 $C$3 x2 x1 0 0 Integer 40 Contin 55 Contin Constraints Cell Name Cell Value Formula Status Slack $D$6 x1+2x2 150 $D$7 x1 40 $D$6-$F$6 $D$7 $F$8 Not Binding 35 Sensitivity Report Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$3 x1 $C$3 x2 40 0 20 1E+30 15 55 0 10 30 1E+30 Constraints Cell Name Value Price Final Shadow Constraint Allowable Allowable R.H. Side Increase Decrease $D$6 x1+2x2 150 $D$7 x1 40 $D$8 x2 55 550 150 1E+30 70 15 40 20 23 70 40 35 1E+30