Excel answe please

Network design problem using Excel Solver (USE Simplex LP in the solver) Canton has built a new elementary school so that the town now has a total of four schools-Addison Beeks, Canfield, and Daley. The school wants to assign children to schools so that their travel time by bus is as short as possible. The school has partitioned the town into five districts conforming to population Ds density-north, south east, west, and central. The average bus travel time from each district to each school is shown as follows: Addison Beeks Canfield Daley Student Population North 17 23 35 17 270 South 26 15 21 27 310 East 18 20 22 31 320 West 29 24 35 10 220 Central 15 10 23 16 280 School capacity 300 400 300 400 Determine the number of children that should be assigned from each district to each school in order to minimize total student travel time