You are the Democratic campaign manager for the state of Indiana. There are 15 cities in the

Question:

You are the Democratic campaign manager for the state of Indiana. There are 15 cities in the state of Indiana.

The numbers of Democrats and Republican voters in these cities (in thousands) are listed in the file P08_37.xlsx. The Democrats control the state legislature, so they can redistrict as they wish. There will be eight congressional districts. Each city must be assigned in its entirety to a single district. Each district must contain between 150,000 and 250,000 voters.

Use Evolutionary Solver to assign voters to districts in a way that maximizes the number of districts that will vote Democratic. (Hint: You might find it convenient to use the SUMIF function. This function was used frequently in Chapter 5.)

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Practical Management Science, Revised

ISBN: 9781118373439

3rd Edition

Authors: Wayne L Winston, S. Christian Albright

Question Posted: