| Microsoft Excel 11.0 Sensitivity Report | |||||||
| Worksheet: [Book1]Sheet1 | |||||||
| Report Created: 2/14/2006 1:47:18 PM | |||||||
| Adjustable Cells | |||||||
| Final | Reduced | Objective | Allowable | Allowable | |||
| Cell | Name | Value | Cost | Coefficient | Increase | Decrease | |
| $E$8 | NUMBER OF HOGS= <= | 176.4705882 | 0 | 18 | 25.99999998 | 11.4 | |
| $E$9 | NUMBER OF COWS= <= | 247.0588235 | 0 | 22 | 38 | 13 | |
| Constraints | |||||||
| Final | Shadow | Constraint | Allowable | Allowable | |||
| Cell | Name | Value | Price | R.H. Side | Increase | Decrease | |
| $A$4 | LHS | 300 | 15 | 300 | 1E+30 | 40.00000006 | |
| $A$5 | LHS | 60 | 67 | 60 | 4.000000007 | 1E+30 | |
| $A$6 | LHS | 176 | 0 | 200 | 1E+30 | 23.52941181 | |