Suppossing a linear relationship use excel solver to find

Assignment Help Operation Management

Reference no: EM13388034

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 maximizesLutz Brewery's revenue.

b) Conduct sensitivity analysis and interpret results.

Reference no: EM13388034

Questions Cloud

She purchased six dozen 72 eggs eight lbs of chocolate : mrs. moody sells cookies that she bakes in her kitchen and gives the profits to charities. she sells two types of

Suppose you can borrow 10 million or its yen equivalent : forward premium discount and interest rates differentialyen pound speseta1-month forward 5.45.7 -1.9-1.9 1.21.23-months

What generally accepted accounting principles dominate the : 1. what generally accepted accounting principles dominate the issue of asset valuation?2. discuss why healthcare

Describe the extent to which john woodenrsquos pyramid of : read the weekly assigned chapters and view the lectures before beginning the assignment.in the current business world

Suppossing a linear relationship use excel solver to find : lutz brewery brews three brands of beers lutz lager lutz light lutz ultralight. lager sells for 12 per barrel light

How much will the firms total revenues revenues from both : you are the manager of a firm that receives revenues of 50000 per year from product x and 90000 per year from product

What is a third-party payment system how does this payment : 1. why is the us health care system considered complex?2. how do health care organizations get paid? do

Find whether the good was the elastic or inelastic good and : provide an example of a product you have recently purchased in which the price changed. determine whether the good was

Formulate the problem to determine which houses should be : production planning department of graystar prefabricated homes company has to decide which types of homes to produce

User Account

All Pages