Network design problem using Excel Solver (USE Simplex LP in the solver)

*****HI, I HAVE ALREADY SOLVED S11.17 WITH SOLVER USING EXCEL, PLEASE REFER TO SECOND SCREENSHOT. I NEED S11.18 SOLVED (FIRST SCREENSHOT), WHICH IS A CONTINUATION OF S11.17 -- PLEASE SOLVE USING EXCEL SOLVER WITH SIMPLEX LP*******

s11.17. Maryville has built a new elementary school so that the town now has a total of four schools-Addison, Beeks, Canfield, and Daley. 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-north, south, east, west, and central. The average bus travel time from each district to each school is shown as follows: TRAVEL TIME (MIN) DISTRICT ADDISON BEEKS CANFIELD DALEY STUDENT POPULATION North 12 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 Determine the number of children that should be assigned from each district to each school in order to minimize total student travel time. ANSWER S11.18. In Problem S11.17, the school board has determined that it does not want any of the schools to be overly crowded compared with the other schools. It would like to assign students from each district to each school so that enrollments are evenly balanced between the four schools. However, the school board is concerned that this might significantly increase travel time. Determine the number of students to be assigned from each district to each school such that school enrollments are evenly balanced. Does this new solution appear to significantly increase travel time per student? A B D E F G H J 1 District North South East West Central School capacity Students assigned Addison 270 0 130 0 0 400 Area Beeks 0 300 0 0 100 400 Canfield 0 10 190 0 0 200 Daley 0 0 0 220 180 400 Student Students population assigned 270 270 310 310 320 320 220 220 280 280 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Time = 20550 mins Bus Travel Time (mins): District North South East West Central Addison 12 26 18 29 15 Area Beeks 23 15 20 24 10 Canfield 35 21 22 35 23 Daley 17 27 31 10 16