Explore BrainMass
Share

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.

    (see the attached file for more information)

    © BrainMass Inc. brainmass.com October 10, 2019, 6:43 am ad1c9bdddf
    https://brainmass.com/math/linear-programming/integer-programming-problem-transportation-transshipment-554111

    Attachments

    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