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...

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.)