Conduct sensitivity analysis and interpret results

Assignment Help Operation Management

Reference no: EM131953396

Problems: What if Analysis

Version 1 Lutz Brewery brews three brands of beers: Lutz Lager, Lutz Light, Lutz Ultralight. Lager sells for $12 per barrel, Light sells for $10 and Ultralight sells for $14 per barrel.

Producing a barrel of Lager requires 8 pounds of corn and 4 pounds of hops. Producing a barrel of Light requires 2 pounds of corn, 6 pounds of rice, and 3 pounds of hops. Producing a barrel of Ultralight requires 1 pounds of corn, 8 pounds of rice, and 2 pounds of hops.

The brewery has 5000 pounds of corn, 3000 pounds of rice, and 4000 pounds of hops.

To supply demand from established customers, Lutz brewery should produce at least 200 barrels of each product.

a) Assuming a linear relationship, use Excel Solver to determine the optimal mix of Lager, Light and Ultralight that maximizes Lutz Brewery's revenue.

b) Conduct sensitivity analysis and interpret results.

Reference no: EM131953396

Questions Cloud

What is the difference between theory and model : Why and how the particular model you selected would be effective in promoting a "Clean Water" initiative in a third world country.

What is the social system of indonesia : What is the social system of Indonesia and what does this mean for hiring and staffing policies such as working conditions, labor unions, and healthcare?

Prepare a graph of quarterly revenue received : FNSACC503 - Manage budgets and forecasts - Use the cash budget to prepare a graph of quarterly revenue received, payments made and closing cash position

Discuss the place objectives and distribution arrangements : Discuss the Place objectives and distribution arrangements that are appropriate for the following products (indicate any special assumptions

Conduct sensitivity analysis and interpret results : Assuming a linear relationship, use Excel Solver to determine the optimal mix of Lager, Light and Ultralight that maximizes Lutz Brewery's revenue.

Which areas require further analysis and investigation : Which areas require further analysis and investigation?

What is the difference between leaders and managers : 1. What is the difference between leaders and managers? 2. Why do we need leaders?

How paul and constantine become co-founders in christianity : How do Paul and Constantine become co-founders in Christianity? Discuss each specifically and with detail to their life and teachings.

How the strategy is used and rate the effectiveness : Formulate an overview of how the strategy is used and rate its effectiveness. Argue whether the strategy is still relevant and effective in present day.

User Account

All Pages