1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
A B C D E F G H I J K L M N O P
Level Amount Amount Balance
Property Sales
Entertainmen
Utility Achieved Goal Over Under (Level-Over+Under) Goal
Goal 1 (Low Income Tax) 600 400 50 100 1,933 <= 2,000 0 67 2,000 = 2,000
Goal 2 (Property Tax) 1 0 0 0 1 >= 1 0 0 1 = 1
Goal 3 (Potential Movers) 760 250 78 76 1,611 <= 1,500 111 0 1,500 = 1,500
Potential
Minimize Over Goal 3
Movers Property Sales
Entertainmen
Utility Level Limit (Amount Over Goal 1 = 0)
LI Tax Burden 20% 600 400 50 100 1,933 (Amount Under Goal 2 = 0)
MI Tax Burden 20% 800 350 100 120 2,010 <= 2,500
HI Tax Burden 40% 1,200 250 120 80 2,057 <= 2,300
Total 6,000 >= 6,000
1
<=
Tax Rate (Percent) 1 3 0 1.33
<=
3
$thousands per 1% Tax
Deviations
Constraints
Goals
$thousands per 1% Tax
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
A B C D E F G H I J K L M N O P
Level Amount Amount Balance
Property Sales
Entertainmen
Utility Achieved Goal Over Under (Level-Over+Under) Goal
Goal 1 (Low Income Tax) 600 400 50 100 2,000 <= 2,000 0 0 2,000 = 2,000
Goal 2 (Property Tax) 1 0 0 0 0.75 >= 1 0 0.25 1 = 1
Goal 3 (Potential Movers) 760 250 78 76 1,586 <= 1,500 86 0 1,500 = 1,500
Potential Penalty Amount Amount Weighted Sum
Movers Property Sales
Entertainmen
Utility Level Limit Weights Over Under of Deviations
LI Tax Burden 20% 600 400 50 100 2,000 Goal 1 1 0 109
MI Tax Burden 20% 800 350 100 120 2,070 <= 2,500 Goal 2 0 90
HI Tax Burden 40% 1,200 250 120 80 1,930 <= 2,300 Goal 3 1 0
Total 6,000 >= 6,000
1
<=
Tax Rate (Percent) 0.75 3 0 3.5
<=
3
$thousands per 1% Tax
Deviations
Constraints
Goals
$thousands per 1% Tax
1
2
3
4
5
6
7
8
9
10
11
A B C D E F G H I J K L M N
Market Share per $million
Ad Ad Ad Level Amount Amount Balance
Camp. 1 Camp. 2 Camp. 3 Achieved Goal Over Under (Level-Over+Under) Goal
Goal 1 (M. Share of Prod. 1) 0.5% 0.2% 15.0% >= 15% 0.0% 0.0% 15% =15%
Goal 2 (M. Share of Prod. 2) 0.3% 0.2% 2.00% >= 10% 0.0% 8.00% 10% =10%
Ad Ad Ad Minimize Under Goal 1
Camp. 1 Camp. 2 Camp. 3 Total
Millions of Dollars Spent 26 010 36
>= <=
10 55
Deviations
Constraints
Goals
1
2
3
4
5
6
7
8
9
10
11
A B C D E F G H I J K L M N
Market Share per $million
Ad Ad Ad Level Amount Amount Balance
Camp. 1 Camp. 2 Camp. 3 Achieved Goal Over Under (Level-Over+Under) Goal
Goal 1 (M. Share of Prod. 1) 0.5% 0.2% 15.0% >= 15% 0.0% 0.0% 15% =15%
Goal 2 (M. Share of Prod. 2) 0.3% 0.2% 8.33% >= 10% 0.0% 1.67% 10% =10%
Ad Ad Ad Minimize Under Goal 2
Camp. 1 Camp. 2 Camp. 3 Total (Under Goal 1 = 0%)
Millions of Dollars Spent 13.3333 0 41.6667 55
>= <=
10 55
Deviations
Constraints
Goals
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
A B C D E F G H I J K L M N O P Q R
Dewright Co. Goal Programming (Preemptive Priority 1: Minimize Under Goal 1 + Over Goal 1)
Goals Range Name Cells
Contribution per Unit Produced Level Amount Amount Balance AmountOver J6:J8
Product 1 Product 2 Product 3 Achieved Goal Over Under (Level – Over + Under) Goal AmountUnder K6:K8
Goal 1 (Employment) 5 3 4 40 =40 0 0 40 =40 Balance M6:M8
Goal 2 (Investment) 5 7 8 61.481 <= 55 6.481 0 55 =55 Deviations J6:K8
Goal 3 (Profit) 12 915 125 >= 125 0 0 125 =125 Goal H6:H8
LevelAchieved F6:F8
Over + Under Goal 1 0 OverGoal1 J6
Product 1 Product 2 Product 3 OverGoal2 J7
Units Produced 3.704 0 5.370 OverGoal3 J8
UnderGoal1 K6
UnderGoal2 K7
UnderGoal3 K8
UnitsProduced C12:E12
Deviations
Constraints
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
A B C D E F G H I J K L M N O P Q R
Dewright Co. Goal Programming (Preemptive Priority 2: Minimize Over Goal 2)
Goals Range Name Cells
Contribution per Unit Produced Level Amount Amount Balance AmountOver J6:J8
Product 1 Product 2 Product 3 Achieved Goal Over Under (Level – Over + Under) Goal AmountUnder K6:K8
Goal 1 (Employment) 5 3 4 40 =40 0 0 40 =40 Balance M6:M8
Goal 2 (Investment) 5 7 8 55 <= 55 0 0 55 =55 Deviations J6:K8
Goal 3 (Profit) 12 915 116.25 >= 125 0 8.75 125 =125 Goal H6:H8
LevelAchieved F6:F8
Minimize Over Goal 2 OverGoal1 J6
Product 1 Product 2 Product 3 (Over Goal 1 = 0) OverGoal2 J7
Units Produced 5 0 3.75 (Under Goal 1 = 0) OverGoal3 J8
UnderGoal1 K6
UnderGoal2 K7
UnderGoal3 K8
UnitsProduced C12:E12
Deviations
Constraints
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
A B C D E F G H I J K L M N O P Q R
Dewright Co. Goal Programming (Preemptive Priority 3: Minimize Under Goal 3)
Goals Range Name Cells
Contribution per Unit Produced Level Amount Amount Balance AmountOver J6:J8
Product 1 Product 2 Product 3 Achieved Goal Over Under (Level – Over + Under) Goal AmountUnder K6:K8
Goal 1 (Employment) 5 3 4 40 =40 0 0 40 =40 Balance M6:M8
Goal 2 (Investment) 5 7 8 55 <= 55 0 0 55 =55 Deviations J6:K8
Goal 3 (Profit) 12 915 116.25 >= 125 0 8.75 125 =125 Goal H6:H8
LevelAchieved F6:F8
Minimize Under Goal 3
OverGoal1 J6
Product 1 Product 2 Product 3 (Over Goal 1 = 0) OverGoal2 J7
Units Produced 5 0 3.75 (Under Goal 1 = 0) OverGoal3 J8
(Over Goal 2 = 0) UnderGoal1 K6
UnderGoal2 K7
UnderGoal3 K8
UnitsProduced C12:E12
Deviations
Constraints
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
A B C D E F G H I J K L M
Fraction Total in Estimated Number Percent
GMAT Under 30 Over 30 Over 30 Admits Group That Enter of Admits
High Men 720 120 32 21.1% 152 <= 152 91.2 That Enter
High Women 720 28 4 12.5% 32 <= 32 19.2 60%
Medium Men 670 104 56 35.0% 128 <= 160 76.8
Medium Women 670 32 32 50.0% 64 <= 64 38.4
Low Men 620 40 40 50.0% 24 <= 80 14.4
Low Women 620 32 48 60.0% 0 <= 80 0
Level Amount Amount Balance
Achieved Goal Over Under (Level-Over+Under) Goal
Goal 1 (# of Students) 240 >= 240 0 0 240 =240
Goal 2 (GMAT Score) 165600 >= 165600 690 times (# Students) 0 0 165,600 = 165,600
Goal 3 (Women) 57.60 >= 60 25% times (# Students) 0 2.4 60.00 = 60.00
Goal 4 (At Least 30) 74.88 >= 96 0 21.12 96 =96
Minimize Under Goal 1
Deviations
Constraints
Goals
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
A B C D E F G H I J K L M
Fraction Total in Estimated Number Percent
GMAT Under 30 Over 30 Over 30 Admits Group That Enter of Admits
High Men 720 120 32 21.1% 136 <= 152 81.6 That Enter
High Women 720 28 4 12.5% 32 <= 32 19.2 60%
Medium Men 670 104 56 35.0% 160 <= 160 96
Medium Women 670 32 32 50.0% 64 <= 64 38.4
Low Men 620 40 40 50.0% 4 <= 80 2.4
Low Women 620 32 48 60.0% 4 <= 80 2.4
Level Amount Amount Balance
Achieved Goal Over Under (Level-Over+Under) Goal
Goal 1 (# of Students) 240 >= 240 0 0 240 =240
Goal 2 (GMAT Score) 165600 >= 165600 690 times (# Students) 0 0 165600 =165600
Goal 3 (Women) 60.00 >= 60 25% times (# Students) 0 0 60 =60
Goal 4 (At Least 30) 75.01895 >= 96 0 20.9811 96 =96
Minimize Under Goal 3
(Under Goal 1 = 0)
(Under Goal 2 = 0)
Deviations
Constraints
Goals
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
A B C D E F G H I J K L M
Fraction Total in Estimated Number Percent
GMAT Under 30 Over 30 Over 30 Admits Group That Enter of Admits
High Men 720 120 32 21.1% 152 <= 152 91.2 That Enter
High Women 720 28 4 12.5% 32 <= 32 19.2 60%
Medium Men 670 104 56 35.0% 160 <= 160 96
Medium Women 670 32 32 50.0% 64 <= 64 38.4
Low Men 620 40 40 50.0% 0 <= 80 0
Low Women 620 32 48 60.0% 14.86 <= 80 8.914285714
Level Amount Amount Balance
Achieved Goal Over Under (Level-Over+Under) Goal
Goal 1 (# of Students) 253.7143 >= 240 13.71 0 240 =240
Goal 2 (GMAT Score) 175062.9 >= 175062.9 690 times (# Students) 0 0 175,063 = 175,063
Goal 3 (Women) 66.51 >= 63.42857 25% times (# Students) 3.08571 0 63.43 = 63.43
Goal 4 (At Least 30) 79.74857 >= 96 0 16.25 96 =96
Minimize Under Goal 4
(Under Goal 1 = 0)
(Under Goal 2 = 0)
(Under Goal 3 = 0)
Deviations
Constraints
Goals