Health Care Systems of Florida (HCSF) is planning to build a number of new emergency-care clinics in
Question:
Health Care Systems of Florida (HCSF) is planning to build a number of new emergency-care clinics in central Florida. HCSF management has divided a map of the area into seven regions. They want to locate the emergency centers so that all seven regions will be conveniently served by at least one facility. Five possible sites are available for constructing the new facilities. The regions that can be served conveniently by each site are indicated by X in the following table:
a. Formulate an ILP problem to determine which sites should be selected so as to provide convenient service to all locations in the least costly manner.
b. Implement your model in a spreadsheet and solve it.
c. What is the optimalsolution?
Step by Step Answer:
Spreadsheet Modeling & Decision Analysis A Practical Introduction to Management Science
ISBN: 978-0324656633
5th edition
Authors: Cliff T. Ragsdale