Question: Please follow the below shown method to solve the answer. Below is an example of a similar question which is solved. Solve the following optimization

Please follow the below shown method to solve the answer. Below is an example of a similar question which is solved.


Solve the following optimization problem via Excel SOLVER. Maximize: P = 4x + 3y - 2 Subject to constraints: 2x + 2y +z0, y> 0. (Hence z is unrestricted). Initial Table: Variables Values Coefficients x O 4 v O 3 O 1 Profit 0 Constraint x z 1 2 0 -5 1 y 2 4 2 1 Value Limit 0 130 310 0 30 0 100 s/sle 130 -310 -30 -100 0 1 Optimal Table: Variables Values Coefficients 4.285714 25.714286 4 3 70 - 1 Profit 24.286 Constraint z 1 2 X 2 0 -5 1 Value Limit 130 130 312.86 310 30 30 100 s/sle 0 2.85714 0 0 2 3 4 100 Conclusion: Hence: x=4.2857.., y=25.7142.., and z=70 is the optimal solution. Note also that (s1=0, u2=2.8571.., and u3=0). Corresponding optimal value of P is 24.2857. Solve the following optimization problem via Excel SOLVER. Maximize: P = 4x + 3y - 2 Subject to constraints: 2x + 2y +z0, y> 0. (Hence z is unrestricted). Initial Table: Variables Values Coefficients x O 4 v O 3 O 1 Profit 0 Constraint x z 1 2 0 -5 1 y 2 4 2 1 Value Limit 0 130 310 0 30 0 100 s/sle 130 -310 -30 -100 0 1 Optimal Table: Variables Values Coefficients 4.285714 25.714286 4 3 70 - 1 Profit 24.286 Constraint z 1 2 X 2 0 -5 1 Value Limit 130 130 312.86 310 30 30 100 s/sle 0 2.85714 0 0 2 3 4 100 Conclusion: Hence: x=4.2857.., y=25.7142.., and z=70 is the optimal solution. Note also that (s1=0, u2=2.8571.., and u3=0). Corresponding optimal value of P is 24.2857
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
