Transportation Model and Linear Programming
Not what you're looking for?
Need help with the following problem, am stuck trying to set it up correctly. Can you help with the objective function and constraints, also the formulas for solver.
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 students 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 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 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.
If each high school has a capacity of 900 students. Set up and solve Arden County's problem as a transportation model
Distance to School in Miles
Sector Sector B Sector C 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
Purchase this Solution
Solution Summary
This posting contains solution to following problem on assignment method solved using transportation model in an attached Excel spreadsheet.
Purchase this Solution
Free BrainMass Quizzes
Exponential Expressions
In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.
Solving quadratic inequalities
This quiz test you on how well you are familiar with solving quadratic inequalities.
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.
Graphs and Functions
This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.