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