Question: Solve this question with using excel (spreadsheets) with detailed explanations and show the excel formulas and solutions steps. (PS: Table also can be reach in

Solve this question with using excel (spreadsheets) with detailed explanations and show the excel formulas and solutions steps.

Solve this question with using excel

Solve this question with using excel

(PS: Table also can be reach in book "Optimization Modeling with Spreadsheets" at page 289-290)

11. Locating Emergency Service Bases The Southeast Emergency Management Agency is planning to establish a number of helicopter bases in a hurricane-prone part of the country. There are 25 sites under consideration, but the agency has funds to install only three bases. Using a specialized map, the agency has identified counties that can be served from each site in less than 15 minutes of response time. (This response time is considered the maximum desired for the purposes of servicing life-and-death emergencies that might follow a hurricane.) The data describing the potential sites consist of a census list and an accessibility matrix. The census list gives the population of each county. The accessibility matrix contains a 1 as its (k,j) th element if county k can be serviced from a base at site j within 15 minutes. At present, the agency has funds to install just three of the bases, and it wishes to maximize the population served by the bases. At which sites should the bases be established and what is the corresponding population served

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!