Question 1: In the event of a disaster situation at Dublin, Virginia from weather, an accident, or terrorism, victims will be transported by emergency vehicles to three area hospitals: Montgomery Regional, Radford Memorial, and Lewis Galt. Montgomery Regional is (on average) 10 minutes away from Dublin, Radford Memorial is 20 minutes away, and Lewis Galt is 35 minutes away. Dublin City wants to analyze a hypothetical disaster situation in which there are 15 victims with different types of injuries. The emergency facilities at Montgomery Regional can accommodate, at most, 8 victims; Radford Memorial can handle 10 victims; and Lewis Galt can admit 7 victims. A priority has been assigned for each victim according to the hospital that would best treat that victims type of injury, as shown in the following table (where 1 reflects the best treatment).

Hospital Patient 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

Montgomery Reg. 1 1 2 2 2 1 3 3 3 1 3 3 2 1 3

Radford Memorial 2 2 3 3 1 3 3 1 1 1 3 3 2 2 3

Lewis Galt 3 3 1 1 3 2 1 2 2 2 1 1 1 2 1

For example, for victim 1s type of injury, the best hospital is Montgomery Regional, the next best is Radford Memorial, and Lewis Galt is the third best. (Hint: Decision variables can be of binary type.) a. Formulate and solve a linear programming model that will send the victims to the hospital best suited to administer to their specific injuries while keeping the average transport time to 22 minutes or less. b. Formulate and solve a linear programming model that will minimize the average transport time for victims while achieving an average hospital priority of at least 1.50 or better.

And please teach me how to put each of them into the Excel Sheets Please. Thank you.