| Microsoft Excel 7.0 Answer Report | ||||||
| Worksheet: [BLAND.XLS]BLAND | ||||||
| Report Created: 6/21/96 10:18 | ||||||
| Target Cell (Max) | ||||||
| Cell | Name | Original Value | Final Value | |||
| $F$5 | Profit per Barrel: Profit: | $800 | $800 | |||
| Adjustable Cells | ||||||
| Cell | Name | Original Value | Final Value | |||
| $C$4 | Barrels to Produce: Ale | 12 | 12 | |||
| $D$4 | Barrels to Produce: Beer | 28 | 28 | |||
| Constraints | ||||||
| Cell | Name | Cell Value | Formula | Status | Slack | |
| $E$10 | Corn (lbs) Usage | 480 | $E$10<=$G$10 | Binding | 0 | |
| $E$11 | Hops (ozs) Usage | 160 | $E$11<=$G$11 | Binding | 0 | |
| $E$12 | Malt (lbs) Usage | 980 | $E$12<=$G$12 | Not Binding | 210 | |
| $C$4 | Barrels to Produce: Ale | 12 | $C$4>=0 | Not Binding | 12 | |
| $D$4 | Barrels to Produce: Beer | 28 | $D$4>=0 | Not Binding | 28 | |