Question: Build a linear program(LP) in Excel Assignments to Hospitals. The director of the Burtonville Civil Defense Agency has been ordered to draw up a disaster

Build a linear program(LP) in Excel

Assignments to Hospitals. The director of the Burtonville Civil Defense Agency has been ordered to draw up a disaster plan for assigning casualties to hospitals in the event of a serious earthquake. For simplicity, we will assume that casualties will occur at two points in the city and will be transported to three hospitals. It is estimated that there will be 300 casualties at point A and 200 at point B. Travel times from point A to hospitals 1,2 , and 3 are 25 , 15 , and 10 minutes, respectively; from point B they are 20,5 , and 15 minutes. Hospital capacities for emergency cases are 250, 150, and 150 patients. How should the victims be assigned to minimize the total time lost in transporting them

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

The director of Burtonsville Civil Defense Agency has been ordered to draw up a disaster plan for assigning casualties to hospitals in the event of a serious earthquake. For simplicity, we will...

Course Summary IS-200.b - ICS for Single Resources and Initial Action Incidents Lesson 1: Course Overview Course Welcome The Emergency Management Institute developed ICS 200, ICS for Single Resources...

ABC Ltd. is a manufacturer of two products, P1 and P2, that require four manufacturing operations: Cutting, Sewing, Finishing, and Packaging. A careful analysis of the manufacturing requirements...

answer part c and d please. a ABC Ltd. is a manufacturer of two products, P1 and P2, that require four manufacturing operations: Cutting, Sewing, Finishing, and Packaging. A careful analysis of the...

ABC Ltd. is a manufacturer of two products, P1 and P2, that require four manufacturing operations: Cutting, Sewing, Finishing, and Packaging. A careful analysis of the manufacturing requirements...

Build a Linear Program (LP) in Excel The Burtonville Municipal Power Company must produce 2000 megawatt-hours (mwh) of electricity each bour. Air pollution ordinances require it to keep emissions of...

Please, I need the graph drawn in a way I can copy to excel What is the optimal solution for this problem, i.e., what are the optimal x 1 and x 2values and the corresponding earnings level? Briefly...

Submitted to Management Science manuscript MS-0001-1922.65 Authors are encouraged to submit new papers to INFORMS journals by means of a style file template, which includes the journal title....

Week Day Q2) A production plant works 6 days a week, Monday through Saturday. Over the last past 3 weeks, the sales data has been recorded as follows: Sales 1 Monday 103 1 Tuesday 100 1 Wednesday 99...

Question 2 Consider the following linear program (LP): Max Z=-3*x + 4*y subject to -X + 2*x - X + y 1 y 2 y 4 x, y 0 Which of the following are true? Note: For these problems the LP is similar except...

2. A company is concerned about the length of time its customers are put on hold when they call. The company randomly selects 50 customer hold times (in minutes) as shown below: 0.6 4.6 5.6 6.3 6.8...

In a recent issue of the Wall Street Journal (or on www.wsj.com or an equivalent financial Website), locate the prices and yields on U.S. Treasury issues. For one bond selling above par and one...

Bonds that take cash flows from pools of mortgages and passes through to its holders the interest and principal payments are called direct real estate investments. real estate investment trusts....

2. The force of interest 8 is a function of time and at any time t, measured in years, is given by the formula: 8(t) = 0.02 +0.0020 8(t) = 0.03 +0.005t Osts5 5 st s 10 a) Calculate the discount...