10. The Westchester County Superintendent of Education is responsible for assigning students to the three magnet...

10. The Westchester County Superintendent of Education is responsible for assigning students to the three magnet high schools in her county. She recognizes the need to bus a certain number of students, for several sectors of the county are beyond walking distance to a magnet school. The superintendent partitions the county into five geographic sectors as she attempts to establish a plan that will minimize the total number of student miles traveled by bus. She also recognizes that if a student happens to live in a certain sector and is assigned to the magnet high school in that sector, there is no need to bus him/her since he/she can walk to school. The three magnet schools are located in sectors B, C, and E. The accompanying table reflects the number of magnet high-school-age students living in each sector and the distance in miles from each sector to each school. Each Magnet High School has a capacity of 900 students. Set up the objective function and constraints of this problem, and solve using MS Excel. this question was answered need solver help