| Microsoft Excel 11.0 Sensitivity Report | ||||
| Worksheet: [HOGSANDCOWS.xls]Sheet2 | ||||
| Report Created: 2/14/2006 1:59:35 PM | ||||
| Adjustable Cells | ||||
| Final | Reduced | |||
| Cell | Name | Value | Gradient | |
| $E$8 | NUMBER OF HOGS= <= | 200 | 0 | |
| $E$9 | NUMBER OF COWS= <= | 239.9999997 | 0 | |
| Constraints | ||||
| Final | Lagrange | |||
| Cell | Name | Value | Multiplier | |
| $A$6 | LHS | 200 | 9 | |
| $A$4 | LHS | 300 | 21 | |