Determine the optimal mix of lager

Assignment Help Operation Management
Reference no: EM13808119

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

b) Conduct sensitivity analysis and interpret results.

Reference no: EM13808119

Questions Cloud

Being a leader module project-organizational change : The purpose of the Module Project is to apply the concepts and techniques of the module to the analysis of real-world situations or problems, and to critically evaluate different approaches to addressing such problems. It will also provide you wit..
Newtons law of cooling : write the temperature of a cooling body as an exponential function of time. Is Newton's Law of Cooling still widely accepted? Are there any substitutes?
Write an essay about hunger in africa : Write an essay that I want to write is about hunger in Africa ( three body paragraph ), ten sentences for each details.
Calculate the standard deviation of returns : Use the following information on states of the economy and stock returns to calculate the standard deviation of returns.
Determine the optimal mix of lager : Assuming a linear relationship, use Excel Solver to determine the optimal mix of Lager, Light and Ultralight that maximizesLutz Brewery's revenue.
What is the percentage change in price of bond : Both bond A and bond B have 7.6 percent coupons and are priced at par value. Bond A has 8 years to maturity, while bond B has 16 years to maturity. If interest rates suddenly rise by 2 percent, what is the percentage change in price of bond A and bon..
Advantages of selecting an internet-based architecture : Review the concept of supply chain management. Although R/Way offers services rather than products, could that concept apply to the design of R/Way's new system? If so, how? What would be the advantages of selecting an internet-based architecture f..
Sex ratios under different rearing temperatures : Use the standard "shorthand syntax" and specify the appropriate model, i.e. what is the response variable and what "effect" terms would be used and why.
Write a memo for your newly elected u.s. senator : What challenges exist or may emerge as a result of unclear pathways of command, control coordination, and convergence during disaster or incident response operations

Reviews

Write a Review

Operation Management Questions & Answers

  Information technology for purchasing-supply management

Discuss the implications of information technology for the Purchasing/Supply Management function. How has IT most helped Purchasing and Supply Management professionals carry out their responsibilities? Are there aspects of IT application that can pre..

  Prepare an implementation plan for change

Prepare an implementation plan for change that would enable Gar Finnvold to create a fully competitive computer service within two years. Review the list of possible interventions below as you develop an implementation plan for NCO.

  How would you respond by using these six steps in exhibit

She tells you she believes air quality in the building is bad and would like something to be done. How would you respond? Use the six steps in Exhibit 6.3 that are associated with effective decision making to help frame your answer.

  Calculate the first quarter interest

Your company invests $50,000 today at an annual interest rate of 4.00%. The interest is compounded quarterly. Calculate the first quarter interest, the total annual interest and the total account balance at the end of one year.

  Argue that the turing test is a strong and valid test

Argue that the Turing Test is a strong and valid test for human-like intelligence in machines. Propose a single modification that would provide the greatest improvement to the test.

  Operating decisions for process solutions

Solutions provides a computer-based document processing service

  Purchase the inventory-Present Accounts Payable

A certain company sells 500 units of inventory per day They purchase the inventory at a cost of $10 per unit They sell the inventory at a price of $25 per unit:

  A global market segment refers

A global market segment refers to _

  Aggregate production schedule for constant workforce

Shoney Video Concepts produces a line of video streaming servers that are linked to personal computers for storing movies. These devices have very fast access and large storage capacity.

  Describe zappos market offering and value proposition

Describe Zappos' market offering. What is Zappos' value proposition? How does it relate to its marketing offering? How does Zappos build long-term customer relationships?

  Determine the impact on the economy

Determine the impact on the economy if the central bank in the U.S. used inflation targeting. Explain your rationale.

  Find out the proportion of employees who either have mba

16 percent of the employees in an organization have managerial positions also 26 percent of the employees in the organization have MBA degrees. Also, 61 percent of the managers have MBA degrees. Utilizing the probability formulas, find out the pro..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd