Determining the haller pub-brewery

Reference no: EM131939356

Haller's Pub & Brewery

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.

Reference no: EM131939356

Questions Cloud

Units of inventory does company order in one shipment : How many units of inventory does the company order in one shipment?

Determine how he can best invest the money : Develop a linear optimization model to determine how he can best invest the money and meet his financial obligations.

Develop a plan that could be used to introduce : Develop a plan that could be used to introduce and utilize the tools and techniques into the workplace.

Compute cost of retained earnings : Compute the cost of retained earnings (Ke). If a $3 flotation cost is involved, compute the cost of new common stock (Kn).

Determining the haller pub-brewery : Jeremy Haller of Haller's Pub & Brewery has compiled data describing the amount of different ingredients and labor resources needed to brew six different

Describe specific qualitative methods and tools : Describe specific qualitative methods and tools that could be used within your discipline to gather data. Include your rationale.

Discuss the two main functions of foreign exchange market : Discuss the two main functions of the foreign exchange market. Analyze, in detail, the relationship between money supply and inflation.

What is the role of the national labor relations board : Under the National Labor Relations Act (NLRA), provide a real world example of how the act guides the activities of unions and employers.

What is the conditional probability of getting the sum : A pair of fair dice is rolled. What is the conditional probability of getting the sum of 5, given that one of the dice is even?

User Account

All Pages