Question: Please attach the excel file with explanation. 3. A linear programming model is given as follows: MinimizeZ=5.2x1+2.5x2+6.0x3Subjectto3x1+2x2+2x3200x1+x2+x3x10.42x1x2+x30.2x1x2+x3x1,x2,x30 (a) Solve the problem by using the computer.

Please attach the excel file with explanation.
3. A linear programming model is given as follows: MinimizeZ=5.2x1+2.5x2+6.0x3Subjectto3x1+2x2+2x3200x1+x2+x3x10.42x1x2+x30.2x1x2+x3x1,x2,x30 (a) Solve the problem by using the computer. What are the minimum Z and the optimal point? (b) Obtain the values of the slack/surplus variables at the optimal solution in (a) (c) Identify the sensitivity range of the objective function coefficient of x2. (d) Identify the sensitivity range of the value of the 1st resource constraint (right-hand side). (e) Identify the sensitivity range of the value of the 3rd resource constraint (right-hand side). (f) which of the following makes the model infeasible? (Choose one) i. Increase of the coefficient of x1 on the objective function to 2000 ii. Decrease of the coefficient of x1 on the 1st constraint to -5 iii. Addition of a new constraint, x1+2x2+3x3100 iv. Removal of the non-negativity constraints for x1,x2,x3 v. None
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
