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.