Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

image text in transcribedimage text in transcribed

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

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction to Managerial Accounting

Authors: Peter C. Brewer, Ray H Garrison, Eric Noreen

8th edition

1259917061, 978-1259917066

Students also viewed these Accounting questions