Excel Questions 5 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 al

Excel Questions 5 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 al

Click here to Order a Custom answer to this Question from our writers. It’s fast and plagiarism-free.

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

Place your order now for a similar assignment and have exceptional work written by one of our experts, guaranteeing you an A result.

Need an Essay Written?

This sample is available to anyone. If you want a unique paper order it from one of our professional writers.

Get help with your academic paper right away

Quality & Timely Delivery

Free Editing & Plagiarism Check

Security, Privacy & Confidentiality