Brooks City : My Essay Gram

Brooks City has three consolidated high schools, each with a capacity of 1,200 students. The school board has partitioned the city into five busing districtsnorth, south, east, west, and central each with different high school student populations. The three schools are located in the central, west, and south districts. Some students must be bused outside their districts, and the school board wants to minimize the total bus distance traveled by these students. The average distances from each district to the three schools and the total student population in each district are as follows:

Don't use plagiarized sources. Get Your Custom Essay on
Brooks City : My Essay Gram
Just from $13/Page
Order Essay

Distance/Miles

District          Central School       West School    South School    Student Population

North               8                                  11                    14                                700

South               12                                9                      0                                  300

East                 9                                  16                    10                                900

West                8                                  0                      9                                  600

Central             0                                  8                      12                                500

The school board wants to determine the number of students to bus from each district to each school to minimize the total busing miles traveled.

a. Formulate a linear programming model for this problem.

b. Solve the model by using the computer.

 

This is what i need help with and using Excel Solver. Can you help?

Due Friday.

Order your essay today and save 15% with the discount code: APRICOT

Order a unique copy of this paper

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
Top Academic Writers Ready to Help
with Your Research Proposal
error: Content is protected !!
Live Chat+1(405) 367-3611Email