Solve the attached problems in an Excel spreadsheet with a separate tab for each problem. Need it in an hour and half The ans
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
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
