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
Camp. 1 Camp. 2 Camp. 3 Total
Penalty Over Under Weighted Sum
Millions of Dollars Spent 13.33 0 41.67 55 Weights Goal Goal of Deviations
>= <= Goal 1 1 1.67%
10 55 Goal 2 1
Deviations
Constraints
Goals
1
2
3
4
5
6
7
8
9
10
11
12
13
A B C D E F G H I J K L M N
Unit Contribution of Product
Product Product Product Level Amount Amount Balance
1 2 3 Achieved Goal Over Under (Level-Over+Under) Goal
Goal 1 (Total Profit) 20 15 25 375 Max
Goal 2 (Employment Level) 6 4 5 75 =50 25 0 50.000 = 50
Goal 3 (Earnings Next Year) 8 7 5 75 >= 75 0 0 75.000 = 75
Product Product Product
1 2 3 Over Under Measure of
Production Rate 0 0 15 Benefit Goal Goal Performance
Goal 1 225
Goal 2 -6 -6
Goal 3 -3
Deviations
Constraints
Goals
Level Achieved
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
A B C D E F G H I J K L M N O P Q R
Dewright Co. Goal Programming (Weighted)
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 (Profit) 12 915 125 >= 125 0 0 125 =125 Balance M6:M8
Goal 2 (Employment) 5 3 4 48.333333 = 40 8.33333 0 40 =40 Deviations J6:K8
Goal 3 (Investment) 5 7 8 55 <= 55 0 0 55 =55 Goal H6:H8
LevelAchieved F6:F8
PenaltyWeights J13:K15
Product 1 Product 2 Product 3
Penalty Over Under Weighted Sum UnitsProduced C12:E12
Units Produced 8.333333333 0 1.666666667 Weights Goal Goal of Deviations
WeightedSumOfDeviations
M13
Profit 7 8.333333333
Employment 1 4
Investment 3
Deviations
Constraints
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
A B C D E F G H I J K L M N O P Q R
Dewright Co. Goal Programming (Weighted)
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 (Profit) 12 915 140 >= 140 0 0 140 =140 Balance M6:M8
Goal 2 (Employment) 5 3 4 58.333 = 40 18.333 0 40 =40 Deviations J6:K8
Goal 3 (Investment) 5 7 8 58.333 <= 55 3.333 0 55 =55 Goal H6:H8
LevelAchieved F6:F8
PenaltyWeights J13:K15
Product 1 Product 2 Product 3
Penalty Over Under Weighted Sum UnitsProduced C12:E12
Units Produced 11.667 0 0 Weights Goal Goal of Deviations
WeightedSumOfDeviations
M13
Profit 5 46.667
Employment 2 4
Investment 3
Deviations
Constraints
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
A B C D E F G H I J K L M N O P Q R
Dewright Co. Goal Programming (Weighted)
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 (Profit) 12 915 140 >= 140 0 0 140 =140 Balance M6:M8
Goal 2 (Employment) 5 3 4 58.333 = 40 18.333 0 40 =40 Deviations J6:K8
Goal 3 (Investment) 5 7 8 58.333 <= 55 3.333 0 55 =55 Goal H6:H8
LevelAchieved F6:F8
PenaltyWeights J13:K15
Product 1 Product 2 Product 3
Penalty Over Under Weighted Sum UnitsProduced C12:E12
Units Produced 11.667 0 0 Weights Goal Goal of Deviations
WeightedSumOfDeviations
M13
Profit 7 28.333
Employment 1 4
Investment 3
Deviations
Constraints
1
2
3
4
5
6
7
8
9
10
11
12
13
A B C D E F G H I J K L M N
Contribution per 1000 Acres Level Amount Amount Balance
Crop 1 Crop 2 Crop 3 Achieved Goal Over Under (Level-Over+Under) Goal
Goal 1 (Foreign Capital) $3,000 $5,000 $4,000 $58,333,333 >= $70,000,000 $0 $11,666,667 $70,000,000 =$70,000,000
Goal 2 (Citizens Fed) 150 75 100 1,750,000 >= 1,750,000 0 0 1,750,000 =1,750,000
Goal 3 (Citizens Employed) 10 15 12 183,333 =200,000 016,667 200,000 =200,000
Crop 1 Crop 2 Crop 3 Total
Penalty Over Under Weighted Sum
Thousands of Acres Planted 8,333 6,667 015,000 Weights Goal Goal of Deviations
<= Goal 1 0.01 133,333
15,000 Goal 2 1
Goal 3 1 1
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
Contribution per 1000 Acres Level Amount Amount Balance
Crop 1 Crop 2 Crop 3 Achieved Goal Over Under (Level-Over+Under) Goal
Goal 1 (Citizens Employed) 10 15 12 210,000 >= 200,000 10,000 0 200,000 = 200,000
Goal 2 (Foreign Capital) $3,000 $5,000 $4,000 $70,000,000 >= $70,000,000 $0 $0 $70,000,000 = $70,000,000
Goal 3 (Citizens Fed) 150 75 100 1,050,000 >= 1,750,000 0 700,000 1,750,000 = 1,750,000
Goal 4 (Citizens Employed) 10 15 12 210,000 <= 200,000 10,000 0 200,000 = 200,000
Minimize Under Goal 1
Crop 1 Crop 2 Crop 3 Total
Thousands of Acres Planted 0 14,000 0 14,000 <= 15,000
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
Contribution per 1000 Acres Level Amount Amount Balance
Crop 1 Crop 2 Crop 3 Achieved Goal Over Under (Level-Over+Under) Goal
Goal 1 (Citizens Employed) 10 15 12 212,500 >= 200,000 12,500 0 200,000 = 200,000
Goal 2 (Foreign Capital) $3,000 $5,000 $4,000 $70,000,000 >= $70,000,000 $0 $0 $70,000,000 = $70,000,000
Goal 3 (Citizens Fed) 150 75 100 1,312,500 >= 1,750,000 0 437,500 1,750,000 = 1,750,000
Goal 4 (Citizens Employed) 10 15 12 212,500 <= 200,000 12,500 0 200,000 = 200,000
Minimize Under Goal 3
Crop 1 Crop 2 Crop 3 Total (Under Goal 1 = 0)
Thousands of Acres Planted 2,500 12,500 0 15,000 <= 15,000 (Under Goal 2 = 0)
Deviations
Constraints
Goals
1
2
3
4
5
6
7
8
9
10
11
12
A B C D E F G H I J K L M N
Contribution per 1000 Acres Level Amount Amount Balance
Crop 1 Crop 2 Crop 3 Achieved Goal Over Under (Level-Over+Under) Goal
Goal 1 (Citizens Employed) 10 15 12 212,500 >= 200,000 12,500 0 200,000 = 200,000
Goal 2 (Foreign Capital) $3,000 $5,000 $4,000 $70,000,000 >= $70,000,000 $0 $0 $70,000,000 = $70,000,000
Goal 3 (Citizens Fed) 150 75 100 1,312,500 >= 1,750,000 0 437,500 1,750,000 = 1,750,000
Goal 4 (Citizens Employed) 10 15 12 212,500 <= 200,000 12,500 0 200,000 = 200,000
Minimize Over Goal 4
Crop 1 Crop 2 Crop 3 Total (Under Goal 1 = 0)
Thousands of Acres Planted 2,500 12,500 0 15,000 <= 15,000 (Under Goal 2 = 0)
(Under Goal 3 = 437,500)
Deviations
Constraints
Goals
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
Minimize Over Goal 1
Movers Property Sales
Entertainmen
Utility Level Limit
LI Tax Burden 20% 600 400 50 100 2,000
MI Tax Burden 20% 800 350 100 120 2,070 <= 2,500
HI Tax Burden 40% 1,200 250 120 80 1,930 <= 2,300
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
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 1 >= 1 0 0 1 = 1
Goal 3 (Potential Movers) 760 250 78 76 1,662 <= 1,500 162 0 1,500 = 1,500
Potential Minimize Under Goal 2
Movers Property Sales
Entertainmen
Utility Level Limit (Over Goal 1 = 0)
LI Tax Burden 20% 600 400 50 100 2,000
MI Tax Burden 20% 800 350 100 120 2,090 <= 2,500
HI Tax Burden 40% 1,200 250 120 80 2,110 <= 2,300
Total 6,200 >= 6,000
1
<=
Tax Rate (Percent) 1 3 0 2
<=
3
$thousands per 1% Tax
Deviations
Constraints
Goals
$thousands per 1% Tax