You are the Democratic campaign manager for the state of Indiana. There are 15 fairly large cities in the state of Indiana. The numbers of Democrats and Republican voters in these cities (in...

You are the Democratic campaign manager for the state of Indiana. There are 15 fairly large 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: The SUMIF function is useful.)