Jeremy Haller of Haller’s Pub & Brewery has compiled data describing the amount of different ingredients and labor resources needed to brew six different types of beers that the brewery makes. He also gathered financial information and estimated demand over a 26-week forecast horizon. These data are provided in the Haller’s Pub tab of the Excel file Chapter 13 Problem Data. The profits for each batch of each type of beer are:
Light Ale: $3,925.78
Golden Ale: $4,062.75
Freedom Wheat: $3,732.34
Berry Wheat: $3,704.49
Dark Ale: $3,905.79
Hearty Stout: $3,490.22
These values incorporate fixed overhead costs of $7,500 per batch. Use the data to validate the profit figures and develop a linear optimization model to maximize profit. Write a report to Mr. Haller explaining the results and sensitivity analysis information in language that he (a nonquantitative manager) can understand.