Question

In: Statistics and Probability

This assignment requires using the Excel add-in called Solver... 1. Can a linear programming problem have...

This assignment requires using the Excel add-in called Solver...

1. Can a linear programming problem have no solution? More than one solution? Explain.

2. To find the optimal solution to a linear optimization problem, do you have to examine all the points in the feasible region? Explain.

Solutions

Expert Solution

Linear Programming problem:

The problem given as optimize z=CX, subject to the constraints and non negativity restrictions.

For the LPP of two variables We can use Graphical method or simplex method.

Graphical method for solving LPP:

In the graphical method, we plot the equations by converting inequalities into equalities.

Then consider the feasible region of LPP.

1. No solution:

  When we do not have a feasible region then we have no solution.

Also, when the feasible region lie outside first quadrent then it have no solution.

e.g. a)

b)

2.More than one solution:

When we got two points having optimum solution, then we have more than one or infinite solution.

When two extreme points have optimum solution, the all the points lying on the line segment joining two extreme points are optimal points. Because there is convex combination.

e.g. maximize z=2x+5y; subject to  

3. Optimal solution

  To find optimal solution, without considering all the points in the feasible region, just considering the corner points or extreme points is sufficient.

Simplex Method

   For any number of variables simplex method is most efficient method.

In this we can directly obtain the solution.


Related Solutions

This assignment requires using the Excel add-in called Solver. A beverage can manufacturer makes three sizes...
This assignment requires using the Excel add-in called Solver. A beverage can manufacturer makes three sizes of soft drink cans—Small, Medium and Large. Production is limited by machine availability, with a combined maximum of 90 production hours per day, and the daily supply of metal, no more than 120 kg per day. The following table provides the details of the input needed to manufacture one batch of 100 cans for each size. 1. Develop a linear programming model to maximize...
This assignment requires using the Excel add-in called Solver. Sam manufacturing company produces two types of...
This assignment requires using the Excel add-in called Solver. Sam manufacturing company produces two types of tires: Economy tires and Premium tires. The manufacturing time and the profit contribution per tire are given in the following table. Answer the following assuming that the company is interested in maximizing the total profit contribution. What is the linear programming model for this problem? Develop a spreadsheet model and find the optimal solution using Excel Solver. How many tires of each model should...
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                                                     ...
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"...
Solve the following linear programming problem using Solver. Be sure to write in your optimal solution...
Solve the following linear programming problem using Solver. Be sure to write in your optimal solution below the problem. Max Z = 20X1 + 30X2 + 25X3 + 32X4 s.t. 4X1 + 8X2 + 5X3 + 6X4 ≤ 40 X1 + X2 ≥ 3 (X1 + X2) ≤ (X3 + X4) ?1 ?2 ≥ 3 2 X1 = __________ X2 = ___________ X3 = ___________ X4 = ___________ Z = ____________
Solve the following linear programming problem using Solver. Be sure to write in your optimal solution...
Solve the following linear programming problem using Solver. Be sure to write in your optimal solution below the problem. Max Z = 20X1 + 30X2 + 25X3 + 32X4 s.t. 4X1 + 8X2 + 5X3 + 6X4 ≤ 40 X1 + X2 ≥ 3 (X1 + X2) ≤ (X3 + X4) x1/x2 ≥ 3/2 X1 = __________X2 = ___________X3 = ___________X4 = ___________Z = ____________
Can you provide solution in the Excel using Solver for the below problem ? On Monday...
Can you provide solution in the Excel using Solver for the below problem ? On Monday morning, you have $3000 in cash on hand. For the next seven days, the following cash requirements must be met: Monday, $5000; Tuesday, $6000; Wednesday, $9000; Thursday, $2000; Friday, $7000; Saturday, $2000; Sunday, $3000. At the beginning of each day, you must decide how much money (if any) to withdraw from the bank. It costs $10 to make a withdrawal of any size. You...
Please solve using EXCEL SOLVER and show steps 1 – A company requires during the next...
Please solve using EXCEL SOLVER and show steps 1 – A company requires during the next four months, respectively, 50, 65, 100, and 70 units of a commodity (no backlogging is allowed). Production costs are $5, $8, $4, and $7 per unit during these months. The storage cost from one month to the next is $2 per unit (assessed on ending inventory). It is estimated that each unit on hand at the end of month 4 could be sold for...
The solution of a linear programming problem using Microsoft Excel typically involves the following three stages:...
The solution of a linear programming problem using Microsoft Excel typically involves the following three stages: a. formulating the problem, graphing the problem, and sensitivity analysis b. the changring cells, the target cells, and the constraints c. the inputs, the changing cells, and the outputs d. forumulating the problem, invoking Solver, and sensitivity analysis
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)
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT