Purchase Solution

Transportation problem: Excel solver

Not what you're looking for?

Ask Custom Question

Having real problems setting up transportation problems in Excel's Solver. Please help with objective function, constraints, formulas, etc. Spreadsheet would be wonderful soI can see how to do it!

The Krampf Lines Railway Company specializes in coal handling. On Friday APril 13, Krampf needed empty coal cars to be moved from three locations (Morgantown, Youngstown, and Pittsburgh) to four other locations. (Mill Valley, Coal Town, Junction City, and Limeburg). Using a railway city-to-city distance chart, the dispatcher constructs a mileage table for the preceding towns, as shown in the table. The table also shows the availablilities and requirements. Find the best shipment of coal cars to minimize the total miles traveled by the cars.

See attachment for table.

Attachments
Purchase this Solution

Solution Summary

This posting contains solution to following problem on transportation using excel solver.

Purchase this Solution


Free BrainMass Quizzes
Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts

Graphs and Functions

This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.

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.

Multiplying Complex Numbers

This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.