| BLAND.XLS | Bland Brewery Production Problem | ||||||
| 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 | |||