Purchase Solution

Transportation Optimization Problem

Not what you're looking for?

Ask Custom Question

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

Attachments
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 ...

Solution provided by:
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