1
2
3
4
5
6
9
A B C D E F
0 Starting
<= Point x* Profit*
1
2
3
4
5
6
A B
0
<=
1
2
3
4
5
6
9
A B C D E F
0 Starting
<= Point x* Profit*
1
2
3
4
5
6
A B
0
1
2
3
4
5
6
7
8
9
A B C D E F G H I J K L M N O P
City Democrat Republican Total District
1152 62 214 1<= 3<= 10 Min District Population 150
1
2
3
4
5
6
7
8
9
A B C D E F G H I J K L M N O
Beating the Market (Evolutionary Solver)
Beat Market
Quarter Year DIS BA GE PG MCD Return Market? (NYSE) Range Name Cells
Q4 2008 -24.97% -25.05% -35.26% -10.73% 1.68% -18.86% Yes -23.57% BeatMarket? J4:J27
Q3 2008 -1.63% -12.19% -3.17% 15.33% 10.42% 1.75% Yes -13.02% Market K4:K27
1
2
3
4
5
6
7
8
9
A B C D E F G H I J K L M N O
Beating the Market (Evolutionary Solver)
Beat Zero
Quarter Year DIS BA GE PG MCD Return Zero? Return Range Name Cells
Q4 2008 -24.97% -25.05% -35.26% -10.73% 1.68% 1.68% Yes 0.00% BeatMarket? J4:J27
Q3 2008 -1.63% -12.19% -3.17% 15.33% 10.42% 10.42% Yes 0.00% Market K4:K27
1
2
3
4
5
6
7
8
9
A B C D E F G H I J K L M N O
Beating the Market (Evolutionary Solver)
Beat Ten
Quarter Year DIS BA GE PG MCD Return Ten? Return Range Name Cells
Q4 2008 -24.97% -25.05% -35.26% -10.73% 1.68% 1.68% No 10.00% BeatMarket? J4:J27
Q3 2008 -1.63% -12.19% -3.17% 15.33% 10.42% 10.42% Yes 10.00% Market K4:K27
1
2
3
9
A B C D E F G H I J
Wyndor Glass Co. Product-Mix Problem
Doors Windows Range Name Cells
1
2
3
4
5
6
7
8
9
A B C D E F G H I J
Wyndor Glass Co. Product-Mix Problem
Doors Windows Range Name Cells
Unit Profit $300 $500 HoursAvailable G7:G9
Hours Hours HoursUsed E7:E9
Used Available HoursUsedPerUnitProduced C7:D9
Hours Used Per Unit Produced