Explore BrainMass
Share

Explore BrainMass

    formulating a linear programming model and solving using Excel

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

    Consider the following transportation problem:

    To(cost)
    From 1 2 3 Supply
    A $6 $9 $100 130
    B 12 3 5 70
    C 4 8 11 100
    Demand 80 110 60

    Formulate this problem as a linear programming model and solve it by using the computer (Excel spreadsheet and Solver parameter)

    © BrainMass Inc. brainmass.com October 10, 2019, 7:32 am ad1c9bdddf
    https://brainmass.com/math/optimization/formulating-linear-programming-model-solving-excel-585859

    Solution Preview

    Please see the attached file for the complete solution.
    First, the model is:

    Let a, b, c, d, e, f, g, h and i be values of cells 1-9 respectively.

    We want minimize Z=6a+9b+7c+12d+3e+5f+4g+8h+11i

    Subject ...

    Solution Summary

    The solution gives detailed steps on formulating a linear programming model and solving it by using Excel Solver.

    $2.19