8-10(High school busing problem)The Arden County, Maryland, superintendent of education is responsible for assigning students to thethreehigh schools in his county. He recognizes the need to bus a certain number of students, for several sectors of the county are beyond walking distance to a school. The superintendent partitions the county intofivegeographic sectors as he attempts to establish a plan that will minimize the total number of student miles traveled by bus. He also recognizes that if a student happens to live in a certain sector and is assigned to the high school in that sector, there is no need to bus that student because he or she can walk to school. The three schools are located in sectors B, C, and E.

The following table reflects the number of high-school-age students living in each sector and the busing distance in miles from each sector to each school: Distance to school

Sector School sector B School Sector C School Sector E Number of Students

A 5 8 6 700

B 0 4 12 500

C 4 0 7 100

D 7 2 5 800

E 12 7 0 400

2500

Each high school has a capacity of 900 students. Set up the objective function and constraints of this problem using LP so that the total number of student miles traveled by bus is minimized. Then solve the problem.

I need to plug this into Excel Solver as well.