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

  Proposed employment for curricular practical training

If you do work at restaurant for internship class... could you give me your opinion. I have 2 question. just your opinion. Describe the proposed employment for curricular practical training:

  How many units of product have to be sold in order to break

If the company sells at a price of $25, how many units of product have to be sold in order to break even? [algebraic approach only]. If the company sells 10,000 mops at the product price of $25, what will be the contribution to profit?

  Describe the difference in inputs and output between a pmo

Describe the difference in inputs and output between a PMO that is customer-focused vs. PMO that is oriented to enforcement of standards.

  Craft a job description for the position you wish to hire

Imagine a business that you would like to start and that it is at the stage of adding one or more employees. In a minimum of 2-3 pages, complete or answer the following- Craft a job description for the position you wish to hire.

  Use itsclosest petitors as the models for benchmarking

virginia rometty worked for IBM for more than years before she was named CEO. How do u think this experience affects her ability to plan, organizing lead, and control as CEO?Explain your answer.

  What information can aid the ability of a manager

what information can aid the ability of a manager to correctly identify areas that require improvement or could benefit from improvement in future planning for the business? explain why this information should be considered.

  Make a way foundation has run into a financial crisis

The Make a Way Foundation has run into a financial crisis. Halfway into their fiscal year, the financier has realized that the company has not put enough money aside to cover all of their costs for the children's summer expense project.

  Prepare a profit payoff table from transrail point of view

Given the information in (C) how muchwould a corportate spy be worth to Transrail to find out if Rail Freight will bid?

  What if the u.s. multinational were introducing these ideas

Would a U.S. MNC doing business in Germany find it easier to introduce these concepts into German operations, or would there be more receptivity to them back in the United States? Why? What if the U.S. multinational were introducing these ideas in..

  What do you think the biggest challenges are to a hpt

What do you think the biggest challenges are to a HPT professional in the Analysis phase of a project? Why?

  Could the hospital really perform this many operations

Elucidate how well will the new resources would be utilised relative to the current operations. Recalling the capacity of 12 surgeons also 5 operating rooms, could the hospital really perform this many operations.

  State trillo apparel company production warehouse move

Include appropriate reports from your final project plans to corroborate your overall report. You may also use diagrams, charts, and other visual aids to make your report more effective

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