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