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