This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: location decision.) Potential Location Cost (in $1,000) Neighborhoods within Three Miles A 60 1,7,8 B 150 2,3,9 C 110 3,5,6,9,10 D 140 1,4,7 E 90 3,5,6,9 F 50 5,7,8,10 G 80 1,7,8 H 130 2,3,9 I 170 5,6,9,10 The data in the first and third columns of the above table can be restated in terms of neighborhoods and potential locations within three miles of each neighborhood as in the following table (we will see that this second way of stating the data is helpful for constructing the Excel Solver model). Neighborhood Potential Locations within Three Miles 1 A,D,G 2 B,H 3 B,C,E,H 4 D 5 C,E,F,I 6 C,E,I 7 A,D,F,G 8 A,F,G 9 10 B,E,H,I C,F,I Where should the task force recommend recycling centers be located if they wish to provide convenient access to all neighborhoods at a minimum cost? What is the objective (target cell)? What are the decisions (changing cells)? What are the constraints?...
View Full Document
This note was uploaded on 10/16/2011 for the course OM 368 taught by Professor Morrice during the Spring '11 term at University of Texas at Austin.
- Spring '11