Transportation nodes - Excel solver
Not what you're looking for?
The blood bank wants to determine the least expensive way to transport available blood donations from Pittsburg and Staunton to hospitals in Charleston, Raonoke, Richmond, Norfolk, and Suffolk. The supply and demand for donated blood is shown in Figure 5.34 along with the unit cost of shipping along with each possible arc.
(a) Crease a spreadsheet model for this problem.
(b) What is the optimal solution?
(c) Suppose that no more than 1000 units of blood can be transported over any one arc. What is the optimal solution to this revised problem?
Purchase this Solution
Solution Summary
This provides an example of using Excel Solver to solve a transportation problem.
Purchase this Solution
Free BrainMass Quizzes
Probability Quiz
Some questions on probability
Multiplying Complex Numbers
This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.
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.
Exponential Expressions
In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.