In: Advanced Math
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