| Microsoft Excel 11.0 Answer Report | ||||||
| Worksheet: [Book1]Sheet1 | ||||||
| Report Created: 2/14/2006 1:47:18 PM | ||||||
| Target Cell (Max) | ||||||
| Cell | Name | Original Value | Final Value | |||
| $E$10 | TOTAL PROFIT= <= | 3,600 | 8,612 | |||
| Adjustable Cells | ||||||
| Cell | Name | Original Value | Final Value | |||
| $E$8 | NUMBER OF HOGS= <= | 200 | 176.4705882 | |||
| $E$9 | NUMBER OF COWS= <= | 0 | 247.0588235 | |||
| Constraints | ||||||
| Cell | Name | Cell Value | Formula | Status | Slack | |
| $A$4 | LHS | 300 | $A$4<=$F$4 | Binding | 0 | |
| $A$5 | LHS | 60 | $A$5<=$F$5 | Binding | 0 | |
| $A$6 | LHS | 176 | $A$6<=$F$6 | Not Binding | 23.52941181 | |