More Using
Solver
|
|
Once you have completed
entering the necessary information in the ‘Solver Parameters’ dialog, it
should look similar to this. |
||
|
3. We also need to set our variables to be >= 0. |
|||
|
· We could enter this as another constraint (as shown). |
|||
|
· Or we can have solver enforce this limitation by setting the Solver Options. When working on problems for MAT121, you should always set the options. |
|||
|
|
|||
|
|
|||
|
4. Click the “Solve” Button. Note that your worksheet has now changed as shown below. |
|||
|
|
|
The Transportation Problem |
|
|
|
|
|
|
|
|
|
|
|||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Var Names |
X11 |
X12 |
X13 |
X21 |
X22 |
X23 |
X31 |
X32 |
X33 |
|
Answer |
|
Constraint |
|
Var Values |
100 |
0 |
0 |
0 |
200 |
100 |
200 |
0 |
100 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Obj Fun |
6 |
1 |
4 |
14 |
5 |
8 |
20 |
14 |
15 |
|
7900 |
|
|
|
S.T. |
1 |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
|
100 |
<= |
100 |
|
|
0 |
0 |
0 |
1 |
1 |
1 |
0 |
0 |
0 |
|
300 |
<= |
300 |
|
|
0 |
0 |
0 |
0 |
0 |
0 |
1 |
1 |
1 |
|
300 |
<= |
300 |
|
|
1 |
0 |
0 |
1 |
0 |
0 |
1 |
0 |
0 |
|
300 |
= |
300 |
|
|
0 |
1 |
0 |
0 |
1 |
0 |
0 |
1 |
0 |
|
200 |
= |
200 |
|
|
0 |
0 |
1 |
0 |
0 |
1 |
0 |
0 |
1 |
|
200 |
= |
200 |