# formulating a linear programming model and solving using Excel

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 ad1c9bdddfhttps://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.