Reference no: EM132403727
Exercise
Statement
The file P 06 92.xlsx lists the distances between 21 U.S. cities. We want to locate liver transplant centers in a subset of these 21 cities.
How many centers are needed, and in which cities should they be located so that residents of all cities are with in 800 miles of a transplant center? (The model must be linear.)
• We know that a transplant center is sometimes filled to capacity. With this in mind, we would like every one to be relatively close to two transplant centers. How many centers are needed, and in which cities should the centers be located, in order to ensure that residents of all cities are within 800 miles of two transplant centers? (Again, the model must belinear.)
• The file P0692.xlsx also lists the number of people(in millions) livingin each city's metropolitan area.
Where should we locate three transplant centers to maximize the number of people within 800 miles of a transplant center?
Description
You must deliver a model of the problem and solution of the problem in
• An Excel spreadsheet that solves the problem using solver(u opensolver). The spreadsheet must be very well structured and designed, following the book recommendation (Practical management science sixth editionWayne L Winston, S Christian Albright) pleaseyou must use color code to differentiate the cells in which we have input values, decision variables, and output values.
• A summary document(two to three pages) that includes the algebraic model that you have introduced with its decisión variables, explaining the restriction and results obtained of the model
Attachment:- P06 92.rar