Enter the Problem into Excel
|
The Transportation Problem |
|||||||||||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Var Names |
X11 |
X12 |
X13 |
X21 |
X22 |
X23 |
X31 |
X32 |
X33 |
|
Answer |
|
Constraint |
|
Var Values |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Obj Fun |
6 |
1 |
4 |
14 |
5 |
8 |
20 |
14 |
15 |
|
0 |
|
|
|
S.T. |
1 |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
|
0 |
<= |
100 |
|
|
0 |
0 |
0 |
1 |
1 |
1 |
0 |
0 |
0 |
|
0 |
<= |
300 |
|
|
0 |
0 |
0 |
0 |
0 |
0 |
1 |
1 |
1 |
|
0 |
<= |
300 |
|
|
1 |
0 |
0 |
1 |
0 |
0 |
1 |
0 |
0 |
|
0 |
= |
300 |
|
|
0 |
1 |
0 |
0 |
1 |
0 |
0 |
1 |
0 |
|
0 |
= |
200 |
|
|
0 |
0 |
1 |
0 |
0 |
1 |
0 |
0 |
1 |
|
0 |
= |
200 |
1. Enter the variable names as labels across the top (Row 3 as the problem is set up here).
2. Enter ‘0’ as the starting value for each variable. Solver will change these values. Because we will be working these variable values as a group, we can simplify our work by giving this group or ‘range’ of cells a name.
3. Name the cell range for the variable values (B4-J4 as set up here) “variables.” This will make it easier to reference these cells in later calculations.
4. Enter the coefficients for the objective function and each constraint.
5. Enter the calculations for the cells in the ‘Answer’ column.