| 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 | ||