Question

In: Statistics and Probability

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

Solutions

Expert Solution

The setup is:

The formulas are:

The Solver parameters are:

The solution is:

The answer is:

x = 5

y = 6

Z = 43


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. Min 5x + 6y s.t. 3x...
Find the complete optimal solution to this linear programming problem. Min 5x + 6y s.t. 3x +   y >= 15 x + 2y >= 12 3x + 2y >= 24      x , y >= 0 PLEASE NOTE I AM USING EXCEL FOR THIS QUESTION PLEASE SHOW ALL WORK AND FORMULAS
Find the complete optimal solution to this linear programming problem. Min 5x + 6y s.t. 3x...
Find the complete optimal solution to this linear programming problem. Min 5x + 6y s.t. 3x +   y >= 15 x + 2y >= 12 3x + 2y >= 24      x , y >= 0 Find the complete optimal solution to this linear programming problem. Min 5x + 6y s.t. 3x +   y >= 15 x + 2y >= 12 3x + 2y >= 24      x , 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
Use the graphical method for linear programming to find the optimal solution for the following problem....
Use the graphical method for linear programming to find the optimal solution for the following problem. Maximize P = 4x + 5 y subject to 2x + 4y ≤ 12                 5x + 2y ≤ 10 and      x ≥ 0, y ≥ 0. graph the feasible region
The optimal solution of the linear programming problem is at the intersection of constraints 1 and...
The optimal solution of the linear programming problem is at the intersection of constraints 1 and 2. Please answer the following questions by using graphical sensitivity analysis. Max s.t. Max 2x1 + x2 s.t. 4x1 +1x2 ≤8 4x1 +3x2 ≤12 1x1 +2x2 ≤6 x1 , x2 ≥ 0 Over what range can the coefficient of x1 vary before the current solution is no longer optimal? Over what range can the coefficient of x2 vary before the current solution is no...
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
Consider the following linear programming problem: Min 2x+2y s.t. x+3y <= 12 3x+y>=13 x-y<=3 x,y>=0 a)...
Consider the following linear programming problem: Min 2x+2y s.t. x+3y <= 12 3x+y>=13 x-y<=3 x,y>=0 a) Find the optimal solution using the graphical solution procedure. b)      Find the value of the objective function at optimal solution. c)      Determine the amount of slack or surplus for each constraint. d)        Suppose the objective function is changed to mac 5A +2B. Find the optimal solution and the value of the objective function.
You are a manager that uses Excel to find the optimal solution to a linear programming...
You are a manager that uses Excel to find the optimal solution to a linear programming problem. Before implementing the solution, what should you do?
What is the difference between the optimal solution to a linear programming problem and the objective...
What is the difference between the optimal solution to a linear programming problem and the objective function value at the optimal solution? Use an example in your explanation
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT