Explore BrainMass

# Integer Programming Problem: Transportation & Transshipment

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

Part 1 Transportation
The following network describes a transportation scenario in which there are four sources A, B, C, and D; and there are three destinations P, Q, and R. (The numbers next to each arrow represents the cost of transporting one unit from that particular source to the destination located at the other end of that arrow).

Part 2 Transshipment)
By including intermediary distribution centers X and Y as shown below and using the given network, will the company save money in its transportation costs compared to the results obtained in part 1? Need assistance solving the problem by using Excel, and find the optimal cost.

https://brainmass.com/math/linear-programming/integer-programming-problem-transportation-transshipment-554111

#### Solution Preview

** Please see the attached an excel file with the solutions of transportation and transshipment on separate worksheets as well as a 7 page long word file with step by step explanations of formulations and solutions to both problems ...

#### Solution Summary

This solution provides an excel file with the solutions of transportation and transshipment on separate worksheets as well as a 7 page long word file with step by step explanations of formulations and solutions to both problems.

\$2.19