Placid Platz Problem - Solved

# Placid Platz Problem - Solved - Objective Minimize total...

This preview shows pages 1–2. Sign up to view the full content.

Objective: Minimize total cost (in \$1,000) 410.0000000385 Cost of locating a recycling center at a potential location Potential Location A B C D E F G H I Cost (in \$1,000) 60 150 110 140 90 50 80 130 170 Which neighborhoods are serviced by which potential recycling centers location? Potential Location Neighborhood A B C D E F G H I 1 1 1 1 2 1 1 3 1 1 1 1 4 1 5 1 1 1 1 6 1 1 1 7 1 1 1 1 8 1 1 1 9 1 1 1 1 1 10 1 1 1 Decision: Which locations to use for recycling centers Potential Location A B C D E F G H I Location used as a recycling location (0=No,1=Yes) 0 0 0 1 1 1 0 1 0 Constraints that each neighborhood must be covered by at least on recycling center Neighborhood Actual # of Centers Servicing Required # of Centers Servicing 1 1 1 2 1.0000000003 1 3 2.0000000003 1 4 1 1 5 2 1 6 1 1 7 2 1 8 1 1 9 2.0000000003 1 10 1 1

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Microsoft Excel 12.0 Answer Report Worksheet: [New Placid Platz Problem Solution.xlsx]Sheet1 Report Created: 9/12/2011 10:30:39 PM Target Cell (Min) Cell Name Original Value Final Value
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 2

Placid Platz Problem - Solved - Objective Minimize total...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online