# Integer Programming Problem: Transportation & Transshipment

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.

(see the attached file for more information)

© BrainMass Inc. brainmass.com October 10, 2019, 6:43 am ad1c9bdddfhttps://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.