BLAND.XLS Bland Brewery Production Problem
WITH RANGE NAMES
Product: Ale Beer Total
Barrels to Produce: 12 28 Profit:
Profit per Barrel: $13 $23 $800
Product Ingredient Requirements
Total Quantity
Ingredients: Ale Beer Usage Available:
Corn (lbs) 5 15 480 <= 480
Hops (ozs) 4 4 160 <= 160
Malt (lbs) 35 20 980 <= 1190