Transportation Optimization Problem
Not what you're looking for?
Steel mills in three cities produce the following amounts of steel weekly
location weekly production (tons)
Ashville 210
Birmingham 150
columbus 320
these mills supply steel to four cities where manufacturing plants have the following demand
city weekly demand
Detroit 130
St Louis 180
chicago 70
Norfolk 240
shipping costs ($) per ton of steel are as follows
detroit st louis chicago norfolk
Ashville $9 14 18 16
birmingham 8 11 16 7
columbus 12 16 22 10
Because of the strike shipments are prohibited form birmingham to chicago. Use linear programming in excel to determine the best
shipping schedule.
Please fill the answers into the following table (number of tons to be shipped form each mill to the four cities
detroit st. louis chicago norfolk
Ashville
birmingham
columbus
Purchase this Solution
Solution Summary
The expert examines the transportation optimization problem.
Solution Preview
Steel mills in three cities produce the following amounts of steel weekly
location weekly production (tons)
Ashville 210
Birmingham 150
columbus 320
these mills supply steel to four cities where manufacturing plants have the following demand
city weekly demand
Detroit 130
St Louis 180
chicago 70
Norfolk 240
shipping costs ($) per ton of steel are as follows ...
Education
- BE, Bangalore University, India
- MS, University of Wisconsin-Madison
Recent Feedback
- "Your explanation to the answers were very helpful."
- "What does 1 and 0 means in the repair column?"
- "Went through all of the formulas, excellent work! This really helped me!"
- "try others as well please"
- "Thank you, this helped a lot. I was not sure how to plug in those numbers to a formula. This was a great help. Now I have to figure out how to explain cost of capital is used in net present value analysis, and how cost of capital is used in net present value analysis. This stuff gets confusing."
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.
Graphs and Functions
This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.
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.
Geometry - Real Life Application Problems
Understanding of how geometry applies to in real-world contexts