Question

In: Statistics and Probability

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

Solutions

Expert Solution

By using EXCEL

Initially enter the variable values and the formulas as below:

And then use solver to enter the problem:

Where we get

So the solution is x=6, y=3

I hope it helps..

If you have any doubts please comment and please don't dislike.

PLEASE GIVE ME A LIKE. ITS VERY IMPORTANT FOR ME.


Related Solutions

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
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
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
Solve the linear programming problem by the method of corners. Maximize P = 5x + 6y    ...
Solve the linear programming problem by the method of corners. Maximize P = 5x + 6y     subject to   x + y ≤ 10 3x + y ≥ 12 −2x + 3y ≥ 8 x ≥ 0, y ≥ 0  
Solve the linear programming problem by the method of corners. Maximize P = 3x + 6y    ...
Solve the linear programming problem by the method of corners. Maximize P = 3x + 6y     subject to   x + y ≤ 10 3x + y ≥ 12 −2x + 3y ≥ 13 x ≥ 0, y ≥ 0   The maximum is P = ? at (x, y) = ( ? ),
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...
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
1. The optimal solution of the linear programming problem is at the intersection of constraints 1...
1. 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 2x1 + x2 s.t. 4x1 +1x2 ≤8 4x1 +3x2 ≤12   1x1 +2x2 ≤6 x1 , x2 ≥ 0 A. Over what range can the coefficient of x1 vary before the current solution is no longer optimal? B. Over what range can the coefficient of x2 vary before the current solution is...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT