Please use excel Solver to answer this question and show all constraints used. Thank you!

Use the template 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?

District North South East West Central School capacity 500 Students assigned 0 Time = Bus Travel Time (mins): District North South East West Central Addison Beeks 0 400 0 12 26 18 29 15 mins Area Student Students Canfield Daley population assigned 370 0 310 320 220 280 Area 450 0 Addison Beeks Canfield 23 35 15 21 20 22 24 35 10 23 400 0 Daley 17 27 31 10 16 0 0 0 0 District North South East West Central School capacity 500 Students assigned 0 Time = Bus Travel Time (mins): District North South East West Central Addison Beeks 0 400 0 12 26 18 29 15 mins Area Student Students Canfield Daley population assigned 370 0 310 320 220 280 Area 450 0 Addison Beeks Canfield 23 35 15 21 20 22 24 35 10 23 400 0 Daley 17 27 31 10 16 0 0 0 0