Microsoft Excel 12.0 Answer Report
Worksheet: [LancasterBrewery.xlsx]Lancaster
Report Created: 15.12.2008 10:57:29
Target Cell (Max)
Cell Name Original Value Final Value
$F$5 Profit per Barrel: Profit: £1,080 £1,080
Adjustable Cells
Cell Name Original Value Final Value
$C$4 Barrels to Produce: Blonde 18 18
$D$4 Barrels to Produce: Red 24 24
Constraints
Cell Name Cell Value Formula Status Slack
$E$10 Corn (lbs) Usage 360 $E$10=0 Not Binding 18
$D$4 Barrels to Produce: Red 24 $D$4>=0 Not Binding 24
Microsoft Excel 12.0 Sensitivity Report
Worksheet: [LancasterBrewery.xlsx]Lancaster
Report Created: 15.12.2008 10:57:42
Adjustable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$C$4 Barrels to Produce: Blonde 18 0 20 40 10
$D$4 Barrels to Produce: Red 24 0 30 30 20
Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$E$10 Corn (lbs) Usage 360 0 500 1E+30 140
$E$11 Hops (ozs) Usage 60 6 60 11.66666667 30
$E$12 Malt (lbs) Usage 900 1 900 900 350
Lancaster Brewery Production Problem
Product: Blonde Red Total
Barrels to Produce: 18 24 Profit:
Profit per Barrel: £20 £30 £1,080
Product Ingredient Requirements
Total Quantity
Ingredients Blonde Red Usage Available
Corn (lbs) 20 360 500
Hops (ozs) 2 1 60 60
Malt (lbs) 10 30 900 900