Mathematics - Linear Programming : Optimal Solution
Not what you're looking for?
Please see attached for data.
Brooks City has three consolidated high schools, each with a capacity of 1,300 students. The school board has partitioned the city into five busing districts each with different high school 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:
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. Hint: You have 5 sources and 3 destinations, giving you 5x3 = 15 possible paths.
a.) Linear programming model showing the objective function and all 8 constraints, with each constraint labeled.
b.) A copy and paste of the computer solution window.
Purchase this Solution
Solution Summary
A Complete, Neat and Step-by-step Solution is provided in the attached Excel file.
Solution Preview
This model was solved using Excel Solver. Therefore, the computer printout ...
Purchase this Solution
Free BrainMass Quizzes
Geometry - Real Life Application Problems
Understanding of how geometry applies to in real-world contexts
Know Your Linear Equations
Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.
Solving quadratic inequalities
This quiz test you on how well you are familiar with solving quadratic inequalities.
Multiplying Complex Numbers
This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.
Exponential Expressions
In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.