Question

In: Advanced Math

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

Solutions

Expert Solution

ANSWER:


Related Solutions

(High school busing problem) The Arden County, Maryland, superintendent of education is responsible for assigning students...
(High school busing problem) The Arden County, Maryland, superintendent of education is responsible for assigning students to the three high schools in his county. He recognizes the need to bus a certain number of students, for several sectors of the county are beyond walking distance to a school. The superintendent               partitions the county into three geographic sectors as he attempts to establish a plan that will minimize the total         number of student miles traveled by bus. He also...
During the course of a semester, 10 students in Mr. Smith’s class took three exams. Use...
During the course of a semester, 10 students in Mr. Smith’s class took three exams. Use Microsoft®Excel® to compute all the descriptive statistics for the following set of three test scores over the course of a semester. Which test had the highest average score? Which test had the smallest amount of variability? How would you interpret the differences between exams, and note the range, means, and standard deviations over time? Test 1 Test 2 Test 3 90 94 95 65...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT