Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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.2857Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started