Maryville has built a new elementary school so that the town now has a total of four schools. Each has a capacity of 400 students. The city wants to assign children to schools so that their travel time by bus is as short as possible. It has partitioned the town into five districts conforming to population density. The average bus trave time from each district to each school is shown below. Determine the number of children that should be assigned from each district to each school in order to minimize total student travel time. Aroa Addison Beeks Canfield Daley Students assigned District North South East West Central School capactyl Students assigned Time Student population 370 310 320 220 280 500 400 450 400 mans Bus Travel Time (mins): District North South East West Central Area Addison 12 26 18 29 15 Beeks 23 15 20 24 10 Canfield 35 21 22 35 23 Daley 17 27 31 10 16 2) Complete problem #2 (10 pts). Using the same template as before create a new worksheet and alter the problem based on the new constraint. The school district has determined that it does not want any of the schools to be overly crowded compared with the other schools. It would like to balance enrollments between the four schools. However, the concern is that this might significantly increase travel time. Determine the number of students to be assigned to each school so that enrollments are evenly balanced. Does this new solution appear to significantly increase travel time per student? Answer the question, What was the impact on time given this new constraint? Maryville has built a new elementary school so that the town now has a total of four schools. Each has a capacity of 400 students. The city wants to assign children to schools so that their travel time by bus is as short as possible. It has partitioned the town into five districts conforming to population density. The average bus trave time from each district to each school is shown below. Determine the number of children that should be assigned from each district to each school in order to minimize total student travel time. Aroa Addison Beeks Canfield Daley Students assigned District North South East West Central School capactyl Students assigned Time Student population 370 310 320 220 280 500 400 450 400 mans Bus Travel Time (mins): District North South East West Central Area Addison 12 26 18 29 15 Beeks 23 15 20 24 10 Canfield 35 21 22 35 23 Daley 17 27 31 10 16 2) Complete problem #2 (10 pts). Using the same template as before create a new worksheet and alter the problem based on the new constraint. The school district has determined that it does not want any of the schools to be overly crowded compared with the other schools. It would like to balance enrollments between the four schools. However, the concern is that this might significantly increase travel time. Determine the number of students to be assigned to each school so that enrollments are evenly balanced. Does this new solution appear to significantly increase travel time per student? Answer the question, What was the impact on time given this new constraint