Pattern 24 40 32 Waste
1 1 0 0 76
2 1 0 1 44
3 1 1 0 36
4 1 1 1 4
5 1 0 2 12
6 2 0 0 52
7 2 0 1 20
8 2 1 0 12
9 3 0 0 28
10 4 0 0 4
11 0 1 0 60
12 0 1 1 28
13 0 2 0 20
14 0 0 1 68
15 0 0 2 36
16 0 0 3 4
Microsoft Excel 9.0 Answer Report
Worksheet: [Book1]model
Report Created: 1/23/2007 5:46:08 AM
Target Cell (Min)
Cell Name Original Value Final Value
$R$2 OF LHS 308 308
Adjustable Cells
Cell Name Original Value Final Value
$B$3 Changing Cells x1 0 0
$C$3 Changing Cells x2 0 0
$D$3 Changing Cells x3 0 0
$E$3 Changing Cells x4 50 50
$F$3 Changing Cells x5 0 0
$G$3 Changing Cells x6 0 0
$H$3 Changing Cells x7 0 0
$I$3 Changing Cells x8 0 0
$J$3 Changing Cells x9 0 0
$K$3 Changing Cells x10 7 7
$L$3 Changing Cells x11 0 0
$M$3 Changing Cells x12 0 0
$N$3 Changing Cells x13 0 0
$O$3 Changing Cells x14 0 0
$P$3 Changing Cells x15 0 0
$Q$3 Changing Cells x16 20 20
Constraints
Cell Name Cell Value Formula Status Slack
$R$5 24in LHS 78 $R$5>=$T$5 Not Binding 3
$R$6 40in LHS 50 $R$6>=$T$6 Binding 0
$R$7 32in LHS 110 $R$7>=$T$7 Binding 0
$B$3 Changing Cells x1 0 $B$3=integer Binding 0
$C$3 Changing Cells x2 0 $C$3=integer Binding 0
$D$3 Changing Cells x3 0 $D$3=integer Binding 0
$E$3 Changing Cells x4 50 $E$3=integer Binding 0
$F$3 Changing Cells x5 0 $F$3=integer Binding 0
$G$3 Changing Cells x6 0 $G$3=integer Binding 0
$H$3 Changing Cells x7 0 $H$3=integer Binding 0
$I$3 Changing Cells x8 0 $I$3=integer Binding 0
$J$3 Changing Cells x9 0 $J$3=integer Binding 0
$K$3 Changing Cells x10 7 $K$3=integer Binding 0
$L$3 Changing Cells x11 0 $L$3=integer Binding 0
$M$3 Changing Cells x12 0 $M$3=integer Binding 0
$N$3 Changing Cells x13 0 $N$3=integer Binding 0
$O$3 Changing Cells x14 0 $O$3=integer Binding 0
$P$3 Changing Cells x15 0 $P$3=integer Binding 0
$Q$3 Changing Cells x16 20 $Q$3=integer Binding 0
Microsoft Excel 9.0 Answer Report
Worksheet: [Book1]model
Report Created: 1/23/2007 5:47:09 AM
Target Cell (Min)
Cell Name Original Value Final Value
$R$9 OF2 LHS 77 77
Adjustable Cells
Cell Name Original Value Final Value
$B$3 Changing Cells x1 0 0
$C$3 Changing Cells x2 0 0
$D$3 Changing Cells x3 0 0
$E$3 Changing Cells x4 50 48
$F$3 Changing Cells x5 0 1
$G$3 Changing Cells x6 0 0
$H$3 Changing Cells x7 0 1
$I$3 Changing Cells x8 0 0
$J$3 Changing Cells x9 0 0
$K$3 Changing Cells x10 7 6
$L$3 Changing Cells x11 0 0
$M$3 Changing Cells x12 0 2
$N$3 Changing Cells x13 0 0
$O$3 Changing Cells x14 0 0
$P$3 Changing Cells x15 0 0
$Q$3 Changing Cells x16 20 19
Constraints
Cell Name Cell Value Formula Status Slack
$R$5 24in LHS 75 $R$5>=$T$5 Binding 0
$R$6 40in LHS 50 $R$6>=$T$6 Binding 0
$R$7 32in LHS 110 $R$7>=$T$7 Binding 0
$B$3 Changing Cells x1 0 $B$3=integer Binding 0
$C$3 Changing Cells x2 0 $C$3=integer Binding 0
$D$3 Changing Cells x3 0 $D$3=integer Binding 0
$E$3 Changing Cells x4 48 $E$3=integer Binding 0
$F$3 Changing Cells x5 1 $F$3=integer Binding 0
$G$3 Changing Cells x6 0 $G$3=integer Binding 0
$H$3 Changing Cells x7 1 $H$3=integer Binding 0
$I$3 Changing Cells x8 0 $I$3=integer Binding 0
$J$3 Changing Cells x9 0 $J$3=integer Binding 0
$K$3 Changing Cells x10 6 $K$3=integer Binding 0
$L$3 Changing Cells x11 0 $L$3=integer Binding 0
$M$3 Changing Cells x12 2 $M$3=integer Binding 0
$N$3 Changing Cells x13 0 $N$3=integer Binding 0
$O$3 Changing Cells x14 0 $O$3=integer Binding 0
$P$3 Changing Cells x15 0 $P$3=integer Binding 0
$Q$3 Changing Cells x16 19 $Q$3=integer Binding 0
min x1 x2 x3 x4 x5 x6 x7 x8 x9 x10 x11 x12 x13 x14 x15 x16 LHS Relation RHS
OF 76 44 36 4 12 52 20 12 28 4 60 28 20 68 36 4 380
Changing Cells 0 0 2 48 1 0 0 0 0 6 0 0 0 0 0 20
24in 1 1 1 1 1 2 2 2 3 4 0 0 0 0 0 0 75 >= 75
40in 0 0 1 1 0 0 0 1 0 0 1 1 2 0 0 0 50 >= 50
32in 0 1 0 1 2 0 1 0 0 0 0 1 0 1 2 3 110 >= 110
OF2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 77
4 1 0 1 0 0
0 1 0 0 1 0
0 1 3 0 0 1
1 0.25 0 0.25 0 0
0 1 0 0 1 0
0 1 3 0 0 1
1 0 0 0.25 -0.25 0
0 1 0 0 1 0
0 0 3 0 -1 1
1 0 0 0.25 -0.25 0
0 1 0 0 1 0
0 0 1 0 -0.33333 0.333333