Explore BrainMass

Transportation problem solving using excel solver

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

The Southern Rail Company ships coal by rail from three coal mines to meet the demand requirements of four coal depots. The following table shows the distances from the mines to the various depots and the availabilities and requirements for coal. Determine the best shipment of coal cars to minimize the total miles traveled by the cars.

TO: Columbia, Albany, Springfield, Pleasatanburg Supply cars

FROM: Parris 50 30 60 70 35

Butler 20 80 10 90 60

Century 100 40 80 30 25

Demand for cars 30 45 25 20

© BrainMass Inc. brainmass.com October 25, 2018, 9:31 am ad1c9bdddf

Solution Summary

Using excel solver, a transportation problem is solved.

See Also This Related BrainMass Solution

Transportation Model linear programming model. Need help setting up problem for Excel solver.

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.

View Full Posting Details