200 ABC city has 17 neighborhoods. The number of high school students in each neighborhood and the time required to drive from each neighborhood to each of the city's two high schools (North and South) are listed in the table below. (you can paste the table in Excel) Minutes to Minutes to Neighborhood Number of students South North 1 200 8 30 2 8 35 3 180 4 27 4 100 6 25 5 150 4 22 6 220 10 26 7 150 11 32 8 180 13 34 150 12 28 10 210 15 32 11 220 16 19 12 230 20 18 13 120 12 24 14 210 19 16 15 180 18 15 16 190 32 4 17 160 3 9 28 The City Board of Education needs to determine how to assign students to high schools. All students in a given neighborhood must be assigned to the same high school. The Board has set the following goals: Goal 1: Ensure that the difference in enrollment at the two high schools differs by at most 50. Goal 2: Ensure that average student travel time is at most 13 minutes. Goal 3: Ensure that at most 4% of the students must travel at least 25 minutes to school. Determine an optimal assignment of students to high schools (assume no priorities on the goals). 200 ABC city has 17 neighborhoods. The number of high school students in each neighborhood and the time required to drive from each neighborhood to each of the city's two high schools (North and South) are listed in the table below. (you can paste the table in Excel) Minutes to Minutes to Neighborhood Number of students South North 1 200 8 30 2 8 35 3 180 4 27 4 100 6 25 5 150 4 22 6 220 10 26 7 150 11 32 8 180 13 34 150 12 28 10 210 15 32 11 220 16 19 12 230 20 18 13 120 12 24 14 210 19 16 15 180 18 15 16 190 32 4 17 160 3 9 28 The City Board of Education needs to determine how to assign students to high schools. All students in a given neighborhood must be assigned to the same high school. The Board has set the following goals: Goal 1: Ensure that the difference in enrollment at the two high schools differs by at most 50. Goal 2: Ensure that average student travel time is at most 13 minutes. Goal 3: Ensure that at most 4% of the students must travel at least 25 minutes to school. Determine an optimal assignment of students to high schools (assume no priorities on the goals)