Question

In: Operations Management

The optimal solution to the following problem is: Max X+Y2 S.T. X2+Y2 <= 200 X-Y <=...

The optimal solution to the following problem is:

Max X+Y2

S.T.

X2+Y2 <= 200

X-Y <= 20

3Y2-X <= 50

X = 5.34, Y=4.29

X = 13.37, Y=4.59

X = 11.31, Y=3.14

X = 13.31, Y=3.14

Solutions

Expert Solution

Answer: X = 13.37, Y=4.59

Explanation:

This is a nonlinear programming problem. I have used excel solver to get the solution.

The solver is an excel plug in which can be installed form excel options. After installation, it is available in the data segment of the excel sheet. Once installed and launched, the parameters can be added

Spreadsheet Model along with formula:

Adding Parameters to Solver:

1st: Enter Green highlighted cell (objective function) in the set objective field

2nd: Select Max

3rd: Enter the yellow cells (decision variables) in the by changing variable cells field

4th: In constraints, click on add, enter the blue cells in the dialogue box which appears.

On the left area (cell reference), enter the left side values, select relationships in the middle, and in the right enter the right side values of the inequality signs. Similarly, repeat for the next constraints by clicking on the add button. Then click ok to go back to the parameters part.

5th; Select GRG Nonlinear in solving method (usually selected by default)

6th: Click solve

Solution:

The solution in the yellow cells is the optimal values of X and Y (answer to the question)


Related Solutions

What's the optimal solution to this linear programming problem? Max 2X + 3Y s.t.   4X +  ...
What's the optimal solution to this linear programming problem? Max 2X + 3Y s.t.   4X +   9Y ≤ 72 10X + 11Y ≤ 110 17X +   9Y ≤ 153           X, Y ≥ 0
Find the complete optimal solution to this linear programming problem. Max 5x + 3y s.t. 2x...
Find the complete optimal solution to this linear programming problem. Max 5x + 3y s.t. 2x + 3y <=30 2x + 5y <= 40 6x - 5y <= 0      x , y >= 0 I AM USING EXCEL FOR THIS QUESTION PLEASE SHOW ALL WORK AND FORMULAS, THANK YOU
Find the optimal values of x and y using the graphical solution method: Max x +...
Find the optimal values of x and y using the graphical solution method: Max x + 5y subject to: x + y ≤ 5 2x + y ≤ 8 x + 2y ≤ 8 x ≥ 0, y ≥ 0
For the following linear programming problem, determine the optimal solution by the graphical solution method Max...
For the following linear programming problem, determine the optimal solution by the graphical solution method Max -x + 2y s.t. 6x - 2y <= 3 -2x + 3y <= 6     x +   y <= 3         x, y >= 0
Given the set A = {(x, y) ∈ R2 | x2 + y2 < 1 and...
Given the set A = {(x, y) ∈ R2 | x2 + y2 < 1 and y ≥ 0}. Draw sketches of cl A, int A, ∂A, (cl(Ac))c, the limit points of A, and the isolated points of A. Try to be clear about what the sketch is describing. (The answer does not depend on whether one uses the Euclidean distance or the taxi distance on R2.)
Given the linear program Max 3x+4y s.t. -x+2y≤8 x+2y≤12 2x+y≤16 x,y≥0 a. Write the problem in...
Given the linear program Max 3x+4y s.t. -x+2y≤8 x+2y≤12 2x+y≤16 x,y≥0 a. Write the problem in standard form. Identify slack/surplus variables. b. List all the extreme points. You must write down the values for x and y for each extreme point. c. Find the optimal solution by comparing the extreme points. d. What are the values of the three slack/surplus variables at the optimal solution?
Let x,y ∈ R3 such that x = (x1,x2,x3) and y = (y1,y2,y3) determine if <x,y>=...
Let x,y ∈ R3 such that x = (x1,x2,x3) and y = (y1,y2,y3) determine if <x,y>= x1y1+2x2y2+3x3y3    is an inner product
Find and classify all the extrema of the function f(x; y) = Exp(-x2 -y2 )*(x2 +...
Find and classify all the extrema of the function f(x; y) = Exp(-x2 -y2 )*(x2 + 2y2).
Solve the following problems using the two phase method: max 3x1 + x2 S.t. x1 −...
Solve the following problems using the two phase method: max 3x1 + x2 S.t. x1 − x2 ≤ −1 −x1 − x2 ≤ −3 2x1 + x2 ≤ 4 x1, x2 ≥ 0 Please show all steps
Using the following data... (a) Fill in the table: X Y X2 Y2 XY 8 5...
Using the following data... (a) Fill in the table: X Y X2 Y2 XY 8 5 4 3 9 7 7 6 5 6 ΣX = ΣY = ΣX2 = ΣY2 = ΣXY = (b) Compute the degrees of freedom and determine the critical value of r for α = 0.05 (two-tails). df = r-critical =   (c) Compute SSX, SSY, SP, and the Pearson correlation (r). (Use 3 decimals) SSX = SSY = SP = r = (d) What decision...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT