Solve the attached problems in an Excel spreadsheet with a separate tab for each problem.
Need it in an hour and half
The answer are also in Chegg
Qs 1. Solve the following LP problem and perform sensitivity analysis:
Maximize P = 3x + 15y
subject to :
2x + 4y ≤ 12
5x + 2y ≤ 10
and x ≥ 0, y ≥ 0.
Qs 2. Solve the following LP problem and perform sensitivity analysis:
Minimize C = 12x + 4y
subject to :
2x + 4y ≥ 12
5x + 2y ≥ 10
and x ≥ 0, y ≥ 0.
Qs 3. The production planner for Fine Coffees, Inc. produces two coffee blends: American (A) and British (B). He can only get 300 pounds of Colombian beans per week and 200 pounds of Dominican beans per week. Each pound of American blend coffee requires 12 ounces of Colombian beans and 4 ounces of Dominican beans, while a pound of British blend coffee uses 8 ounces of each type of bean. Profits for the American blend are $2.00 per pound, and profits for the British blend are $1.00 per pound. The goal of Fine Coffees, Inc. is to maximize profits. Solve the LP problem in Excel and also perform sensitivity analysis.
Qs 4 Solve the following transportation problem to minimize the cost.
TRANSPORTAION COST PER UNIT
|
From/To Boston Chicago St Louis Lexington Supply |
|
Cleveland 3 2 7 6 <= 5000 |
|
Bedford 7 5 2 3 <= 6000 |
|
York 2 5 4 5 <= 2500 |
|
= = = = |
|
Demand 6000 4000 2000 1500 |
Qs 5. Consider the following algebraic formulation of a cos-benefit-trade-off problems involving three benefits, where the decisions to be made are the levels of four activities:
Minimize cost C = 2A1 + A2 – A3 + 3A4
Subject to:
Benefit 1: 3A1 + 2A2 – 2A3 + 5A4 >= 80
Benefit 2: A1 – A2 + A4 >= 10
Benefit 3: A1 +A2 – A3 + 2A4 >= 30
A1, A2, A3 >= 0
