Question: please help with excel!!!! I need the objective function and constraints as well as the total number of student miles traveled by bus minimized. And

please help with excel!!!!
I need the objective function and constraints as well as the total number of student miles traveled by bus minimized. And how many stufents on each bus.
please help with excel!!!!I need the objective function and constraints as well

The Arden County, Maryland, superintendent of education is responsible for assigning students to the three high 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 into five geographic sectors as he attempts to establish a plan that will minimize the total number of student miles traveled by bus. He also reeognizes 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 him because he can walk to school. The three schools are located in sectors B, C, and E. The accompanying table reflects the number of high-school-age students living in each sector and the distance in miles from each sector to each school. Each high school has a capacity of 900 students. a) Set up the objective function and constraints of this problem using linear programming so that the total number of student miles traveled by bus is minimized. b) Solve the

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!