Microsoft Ex

Worksheet:
Report Crea
Result: Solv
Solver Engin
Engine: GRG Nonline
Solution Time: 0.125
Iterations: 13 Subpro
Solver Optio
Max Time Unlimited,
Convergence 0.0001
Max Subproblems Un

Objective Ce
Final Value Original Value Name Cell
591000 0 TDC $E$54

Variable Cells
Integer Final Value Original Value Name Cell
Contin 17000 0 R1 C1 $C$45
Contin 15000 0 R1 C2 $D$45
Contin 0 0 R1 C3 $E$45
Contin 0 0 R1 C4 $F$45
Contin 0 0 R2 C1 $C$46
Contin 0 0 R2 C2 $D$46
Contin 0 0 R2 C3 $E$46
Contin 0 0 R2 C4 $F$46
Contin 0 0 R3 C1 $C$47
Contin 0 0 R3 C2 $D$47
Contin 19000 0 R3 C3 $E$47
Contin 22000 0 R3 C4 $F$47

Constraints
Slack Status Formula Cell Value Name Cell
45000 Not Binding $C$27<=$C$28 0 Total Recived /Ret R1 $C$27
62000 Not Binding $D$27<=$D$28 0 Total Recived /Ret R2 $D$27
35000 Not Binding $E$27<=$E$28 0 Total Recived /Ret R3 $E$27
0 Binding $C$49=$C$48 17000 Total R by Custmoer C1 $C$49
0 Binding $D$49=$D$48 15000 Total R by Custmoer C2 $D$49
0 Binding $E$49=$E$48 19000 Total R by Custmoer C3 $E$49
0 Binding $F$49=$F$48 22000 Total R by Custmoer C4 $F$49
 Microsoft Ex
Worksheet:
Report Crea
Result: Solv
Solver Engin
Engine: GRG Nonline
Solution Time: 0.015
Iterations: 0 Subprob
Solver Optio
Max Time Unlimited,
Convergence 0.0001
Max Subproblems Un

Objective Ce
Final Value Original Value Name Cell
591000 591000 TDC $E$54

Variable Cells
Integer Final Value Original Value Name Cell
Contin 17000 17000 R1 C1 $C$45
Contin 15000 15000 R1 C2 $D$45
Contin 0 0 R1 C3 $E$45
Contin 0 0 R1 C4 $F$45
Contin 0 0 R2 C1 $C$46
Contin 0 0 R2 C2 $D$46
Contin 0 0 R2 C3 $E$46
Contin 0 0 R2 C4 $F$46
Contin 0 0 R3 C1 $C$47
Contin 0 0 R3 C2 $D$47
Contin 19000 19000 R3 C3 $E$47
Contin 22000 22000 R3 C4 $F$47

Constraints
Slack Status Formula Cell Value Name Cell
45000 Not Binding $C$27<=$C$28 0 Total Recived /Ret R1 $C$27
62000 Not Binding $D$27<=$D$28 0 Total Recived /Ret R2 $D$27
35000 Not Binding $E$27<=$E$28 0 Total Recived /Ret R3 $E$27
0 Binding $C$49=$C$48 17000 Total R by Custmoer C1 $C$49
0 Binding $D$49=$D$48 15000 Total R by Custmoer C2 $D$49
0 Binding $E$49=$E$48 19000 Total R by Custmoer C3 $E$49
0 Binding $F$49=$F$48 22000 Total R by Custmoer C4 $F$49
 Ds/T R1 R2 R3 Capicty
F1 9 7 5 90000
F2 2 8 6 75000

C1 C2 C3 C4
F1 8 9 6 4
F2 9 5 3 2

C1 C2 C3 C4 Capicty
R1 8 7 5 4 45000
R2 2 3 1 2 62000
R3 6 5 8 9 35000
Demand 17000 15000 19000 22000

ans
Total
quant/Factroy
1- Ds/T R1 R2 R3 to reta
F1 0
F2 0
Total
Recived /Ret 0 0 0
Retalir/Capcity 45000 62000 35000

2- C1 C2 C3 C4 Total Q/F to Cust

F1 0
F2 0

Total Constrate
TQF1 0 90000
TQF2 0 75000

3- C1 C2 C3 C4 Total Out Total In

R1 17000 15000 0 0 32000 0
R2 0 0 0 0 0 0
R3 0 0 19000 22000 41000 0
Demand 17000 15000 19000 22000
Total R by
Custmoer 17000 15000 19000 22000

TDC
591000