A11 X V fx Write a few sentences below to summarize your results: A B C D E F G H K L M N O P 1 Main City has four elementary schools (Addison, Beeks, Canfield, Daley) and Bus Travel Time: 2 each school has a capacity of 400 students. Children need to be assigned to Area Student 3 schools so that their travel time (by bus) is as short as possible. District Addison Beeks Canfield Daley population 4 Housing in the town is clusted into 5 neighborhoods (North, South, East, West, North 12 23 35 17 250 5 and Central); average travel time between each of the neighborhoods and the South 26 15 21 27 340 6 schools is shows in the table at the right. East 18 20 22 31 310 West 29 24 35 10 210 8 Using a spreadsheet model and Solver, determine the number of children that should Central 15 10 23 16 290 9 be assigned from each district to each school to minimize total student travel time. 10 11 Write a few sentences below to summarize your results: 12 13 14 15 16 17