Microsoft Excel 12.0 Answer Report
Worksheet: [Strategy A.xlsx]Model
Report Created: 9/6/2010 12:22:38 PM
Target Cell (Max)
Cell Name Original Value Final Value
$I$15 GAINA 2.375 2.375
Adjustable Cells
Cell Name Original Value Final Value
$D$15 PA1 0.875 0.875
$E$15 PA2 0.000 0.000
$F$15 PA3 0.125 0.125
$G$15 GAINA 2.375 2.375
Constraints
Cell Name Cell Value Formula Status Slack
$I$8 EG(b1) ≥ GAINA 1.75 $I$8>=$K$8 Not Binding 1.75
$I$9 EG(b2) ≥ GAINA 0.00 $I$9>=$K$9 Binding 0.00
$I$10 EG(b3) ≥ GAINA 0.00 $I$10>=$K$10 Binding 0.00
$I$11 ∑(PAi) = 1 1.00 $I$11=$K$11 Not Binding 0
Microsoft Excel 12.0 Sensitivity Report
Worksheet: [Strategy A.xlsx]Model
Report Created: 9/6/2010 12:22:38 PM
Adjustable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$D$15 PA1 0.875 0.000 0 3 0.2
$E$15 PA2 0.000 -0.250 0 0.25 1E+30
$F$15 PA3 0.125 0.000 0 1 3
$G$15 GAINA 2.375 0.000 1 1E+30 1
Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$I$8 EG(b1) ≥ GAINA 1.75 0.000 0 1.75 1E+30
$I$9 EG(b2) ≥ GAINA 0.00 -0.375 0 1 7
$I$10 EG(b3) ≥ GAINA 0.00 -0.625 0 3.8 1
$I$11 ∑(PAi) = 1 1.00 2.375 1 1E+30 1
A B C D E F G H
1 Strategy A
2 Decision Variables
3 Objective Function: PA1 PA2 PA3 GAINA
4 Coefficients 1
5
6
7 Constraint Definitions: Coefficients
8 EG(b1) ≥ GAINA 4 -1 5 -1
9 EG(b2) ≥ GAINA 3 4 -2 -1
10 EG(b3) ≥ GAINA 2 1 5 -1
11 ∑(PAi) = 1 1 1 1
12
13
14 Solver Calculations: PA1 PA2 PA3 GAINA
15 0.875 0.000 0.125 2.375
I J K
1
2
3
4
5
6
7 Operator Limit
8 1.75 ≥ 0
9 0.00 ≥ 0
10 0.00 ≥ 0
11 1.00 = 1
12
13
14 GAINA
15 2.375