Microsoft Excel 11.0 Sensitivity Report |
|
|
Worksheet:
[Chicken optimum Product Selection.xls]Sheet1 |
Report
Created: 4/18/2006 2:59:35 PM |
|
|
Adjustable
Cells |
|
|
|
|
Final |
Reduced |
|
|
Cell |
Name |
Value |
Gradient |
|
|
$C$22 |
Whole Whole |
200 |
0 |
|
|
$C$23 |
Half Whole |
0 |
0 |
|
|
$C$24 |
Breast Whole |
1600 |
0 |
|
|
$C$25 |
Legs Whole |
1600 |
0 |
|
|
$C$26 |
Wings Whole |
1600 |
0 |
|
|
$C$27 |
Backs Whole |
800 |
0 |
|
|
Constraints |
|
|
|
|
Final |
Lagrange |
|
|
Cell |
Name |
Value |
Multiplier |
|
|
$A$4 |
|
1000 |
0.600000024 |
|
|
$A$5 |
|
1000 |
0.560000002 |
|
|
$A$6 |
|
1000 |
0.159999996 |
|
|
$A$7 |
|
1000 |
0.050000001 |
|
|
$A$13 |
|
800 |
0 |
|
|
$A$8 |
|
200 |
-0.169999976 |
|
|
$A$9 |
|
0 |
-0.035000607 |
|
|
$A$10 |
|
1600 |
0 |
|
|
$A$11 |
|
1600 |
0 |
|
|
$A$12 |
|
1600 |
0 |
|
|
|
|
|
|
|
|