Network flow model and spreadsheet model
Not what you're looking for?
Hello,
I have attached the powerpoint for this problem.
Problem 27.
Union Express has 60 tons of cargo that need to be shipped from Boston to Dallas. The shipping capacity on each of the routes Union Express planes fly each night is shown on the table below.
Nightly Flights Segments Capacity in Tons
Boston to Baltimore 30
Boston to Pittsburgh 25
Boston to Cincinnati 35
Baltimore to Atlanta 10
Baltimore to Cincinnati 5
Pittsburgh to Atlanta 15
Pittsburgh to Chicago 20
Cincinnati to Chicago 15
Cincinnati to Memphis 5
Atlanta to Memphis 25
Atlanta to Dallas 10
Chicago to Memphis 20
Chicago to Dallas 15
Memphis to Dallas 30
Memphis to Chicago 15
Will Union Express be able to move all 60 tons from Boston to Dallas in one night?
a) Draw a network flow model foe the problem and solve it
b) Create a spreadsheet model for this problem in Excel and solve it
c) What is the maximum flow for this network?
Purchase this Solution
Solution Summary
This provides an example of using a network flow model and a spreadsheet model to solve a linear programming problem.
Purchase this Solution
Free BrainMass Quizzes
Solving quadratic inequalities
This quiz test you on how well you are familiar with solving quadratic inequalities.
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.
Exponential Expressions
In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.
Graphs and Functions
This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.
Multiplying Complex Numbers
This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.