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 schoolsAddison, 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 densitynorth, 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.