|
It is not enough to have Excel Solver generate the
results and the answer sheet; you need to understand what the results show.
·
In this example, the report shows that the minimum cost for this
transportation problem is $7,900.
· It also tells
us that Plant 1 will ship all 100 units of its supply to Customer 1.
· Plant 2 will
ship 200 units to Customer 2, and 100 units to Customer 3.
·
Plant 3 will ship 200 units to Customer
1 and 100 units to Customer 3.
|
|
Microsoft Excel 10.0
Answer Report
|
|
|
|
|
|
|
|
|
|
Target Cell (Min)
|
|
|
|
|
|
|
Cell
|
Name
|
Original Value
|
Final Value
|
|
|
|
|
$L$4
|
Obj Fun Answer
|
0
|
7900
|
|
|
|
|
|
|
|
|
|
|
|
Adjustable Cells
|
|
|
|
|
|
|
Cell
|
Name
|
Original Value
|
Final Value
|
|
|
|
|
$B$2
|
Var Values x11
|
0
|
100
|
|
|
|
|
$C$2
|
Var Values x12
|
0
|
0
|
|
|
|
|
$D$2
|
Var Values x13
|
0
|
0
|
|
|
|
|
$E$2
|
Var Values x21
|
0
|
0
|
|
|
|
|
$F$2
|
Var Values x22
|
0
|
200
|
|
|
|
|
$G$2
|
Var Values x23
|
0
|
100
|
|
|
|
|
$H$2
|
Var Values x31
|
0
|
200
|
|
|
|
|
$I$2
|
Var Values x32
|
0
|
0
|
|
|
|
|
$J$2
|
Var Values x33
|
0
|
100
|
|
|
|
|
|
|
|
|
|
|
|
Constraints
|
|
|
|
|
|
|
Cell
|
Name
|
Cell Value
|
Formula
|
Status
|
Slack
|
|
|
$L$5
|
S.T. Answer
|
100
|
$L$5<=$N$5
|
Binding
|
0
|
|
|
$L$6
|
Answer
|
300
|
$L$6<=$N$6
|
Binding
|
0
|
|
|
$L$7
|
Answer
|
300
|
$L$7<=$N$7
|
Binding
|
0
|
|
|
$L$8
|
Answer
|
300
|
$L$8=$N$8
|
Not Binding
|
0
|
|
|
$L$9
|
Answer
|
200
|
$L$9=$N$9
|
Not Binding
|
0
|
|
|
$L$10
|
Answer
|
200
|
$L$10=$N$10
|
Not Binding
|
0
|
|