Question

In: Statistics and Probability

2. Solve the following LP problem graphically; confirm your results using Solver in MS Excel. Maximize...

2. Solve the following LP problem graphically; confirm your results using Solver in MS Excel.
Maximize profit = 20x1 + 10x2
Subject to: 5x1 + 4x2 ≤ 250
2x1 + 5x2 ≤ 150
x1, x2 ≥ 0

Solutions

Expert Solution

Here the 1st constraint is 5x1+4x2<=250

Take x2 = 0 and so 5x1 = 250 or x1 = 50.

Now take x1 = 0 and so 4x2 = 250 or x2 = 62.5

Thus for the 1st constraint the line will have points - 50 and 62.5 for x1 and x2

The 2nd constraint is 2x1+5x2<=150

Take x2 = 0 and so 2x1 = 150 and x1 = 75

Now take x1 = 0 and so 5x2 = 150 and x2 = 30.

Thus for the 2nd constraint the line will have points - 75 and 30 for x1 and x2.

We plot both lines on a graph and then determine the feasible region. The feasible region is shaded and the corner points are - A, B, C and D

A = (0,0), B = (0,30), C = (40,15) and D = (50,0)

At A value of objective function = 20*0+10*0 = 0. At B it is 20*0+10*30 = 300. At C it is 20*40 + 10*15 = 950 and at D it is 20*50+10*0 = 1000

Thus profit (or the objective function) is maximized at x1 = 50 and x2 = 0 and the value of the maximized profit (objective function) is 1000.

The graph is attached below:


Related Solutions

Solve the following LP problem using the Solver in MS Excel. A farmer wants to customize...
Solve the following LP problem using the Solver in MS Excel. A farmer wants to customize his fertilizer for his current crop. He can buy plant food mix A and plant food mix B. Each cubic yard of food A contains 20 pounds of phosphoric acid, 30 pounds of nitrogen and 5 pounds of potash. Each cubic yard of food B contains 10 pounds of phosphoric acid, 30 pounds of nitrogen and 10 pounds of potash. He requires a minimum...
Solve the following LP problem using the Solver in MS Excel.   A municipality has two incinerators...
Solve the following LP problem using the Solver in MS Excel.   A municipality has two incinerators for burning trash . Incinerator A costs $3 .80 per ton of trash to operate, and has a capacity of 28 tons per day . Incinerator B costs $4 .25 per ton to operate, and has a capacity of 30 tons per day . The municipality produces over 100 tons of trash per day, and all trash not burned in the incinerators must be...
1. Solve the following integer optimization model by using Excel Solver: Maximize Z = 5x1 +...
1. Solve the following integer optimization model by using Excel Solver: Maximize Z = 5x1 + 6x2 Subject to 3x1 + 4x2 < 10 4x1 + 2x2 < 15      x1, x2 > 0 and integer Please show how to use the excel solver as well as steps. :)
How to solve using Excel Solver: This is an assignment problem with 10 applicants and 5...
How to solve using Excel Solver: This is an assignment problem with 10 applicants and 5 positions. Determine the optimal assignments that Brenda Last should make. Use the data to determine the optimal assignments, but do not complete questions in the last two paragraphs of the text Formulate a linear programming model for this problem. List the objective function (minimize or maximize) and all model constraints. Solve problem using MS Excel’s Solver Hint: Use the “integer” constraint Highlight the "winning"...
Required: Formulate and solve the LP Relaxation of the problem. Solve it graphically, and round down...
Required: Formulate and solve the LP Relaxation of the problem. Solve it graphically, and round down to find a feasible solution. Explain/show what excel parameters and cells should be entered into the excel to come up with the answer. Consider the following all-integer linear program: ??? 10?1 + 3?2 ?.?. 6?1 + 7?2 ≤ 40 3?1 + 1?2 ≤ 11 ?1,?2 ≥ 0 and integer
Solve the following problem with Excel Solver: (Leave no cells blank - be certain to enter...
Solve the following problem with Excel Solver: (Leave no cells blank - be certain to enter "0" wherever required. Do not round intermediate calculations. Round your answers to 2 decimal places.) Maximize Z = 8X + 17Y. 8X + 14Y ≤ 143          Resource A 1X + 2Y ≤ 75          Resource B 3Y ≤ 12          Resource C   Decision for X      Decision for Y      Total profit $                  Resources Used   Resource A        Resource B        Resource C...
SOLVE THE FOLLOWING 2 LINEAR PROGRAMMING PROBLEMS USING EXCEL AND THE SOLVER ADD-IN. PLEASE SHOW ME...
SOLVE THE FOLLOWING 2 LINEAR PROGRAMMING PROBLEMS USING EXCEL AND THE SOLVER ADD-IN. PLEASE SHOW ME ALL THE EXCEL STEPS. PROBLEM #1:   Maximize Z = $60X + $90Y                             Subject to:   60X + 30Y >= 1,500                                                     100X + 100Y <= 6,000                                                                              Y >= 30                                                                           X, Y >= 0 PROBLEM #2: Minimize Z = $3,000X + $1,000Y                              Subject to:   60X + 20Y >= 1,200                                                         10X + 10Y >= 400                                                     ...
Solve the following linear programming problem by solver. Maximize Z = 7 x1 + 5 x2...
Solve the following linear programming problem by solver. Maximize Z = 7 x1 + 5 x2 + 5 x3 subject to x1 + x2 + x3 <= 25 2 x1 + x2 + x3 <= 40 x1 + x2          <= 25                    x3 <= 6 x1, x2, x3 >= 0 (non-negativity conditions)
Quantitative Methods in BUSN Solve this problem using Excel Solver 1. Devos Inc. is building a...
Quantitative Methods in BUSN Solve this problem using Excel Solver 1. Devos Inc. is building a hotel. It will have 4 kinds of rooms: suites where customers can smoke, suites that are non-smoking, budget rooms where the customers can smoke, and budget rooms that are non-smoking. When we build the hotel, we need to plan for how many rooms of each type we should have. The following are requirements for the hotel: We want to figure out how many rooms...
Consider the following linear programming problem, and find the solution graphically in excel.                         Maximize &nbs
Consider the following linear programming problem, and find the solution graphically in excel.                         Maximize                     4X + 10Y                         Subject to:                    3X + 4Y <= 480                                                             4X + 2Y <= 360                                                             2X + 3Y >= 90                                                             all variables >= 0
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT