Suppose a linear relationship use excel solver to find out

Reference no: EM13476159

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

Questions Cloud

Explain the history or background of the illness including : 1.explain the history or background of the illness including myths misconceptions and past treatments.2.describe the

What steps if any should be taken to increase fossil fuel : what steps if any should be taken to increase fossil fuel energy supplies? are there ecologically sound paths to

One way to make renewable energy sources more market share : one way to make renewable energy sources more market share is to create new market rules through an ecological

The united states tried to solve the indian problem by : the united states tried to solve the indian problem by eliminating the indians. do you agree or disagree with this

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

Analyze the reliability credibility and validity of the : objective of the assignment evaluate arguments for validity.bulllocate an article about a controversial subject where

What is the name of the sculpture you have chosen to write : using 200 - 250 words answer the following about duane hansons woman eating 1971 1. what is the name of the sculpture

Scholars have often characterized british democracy as : 1.list and briefly describe the 3 main impacts that federalism has upon the conduct of elections in the united

On page 118 of your textbook is a picture of the sculpture : 1 on page 118 of your textbook is a picture of the sculpture pietagrave by michelangelo. as we have studied

User Account

All Pages