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
- Spring '11
- Harshad number, Neighbourhood, Three miles, recycling centers, Placid Platz