Linear Programming to Maximize Contribution Margin
Not what you're looking for?
See the attached file.
Find the optimal quantities to produce for product X, Y, and Z and the necessary quantities of labor and material
Products
X Y Z
Labor Hrs 5 4 2
Material A lbs. 2 2 .5
Material B lbs 1 0 2
-I'm given a budget of $11,980 for production of the three products. Currently, the company has a contractual obligation for at least 85 units of product Y per week to one of its major customers.
-In order to produce its products, the company needs two materials, material A and B.
-Material A costs $4 per pound, as does material B. Labor costs $8 per hour.
-Product X sells for $122 a unit, product Y sells for $115 per unit, and product Z sells for $76 a unit.
I like to know the quantity of each product to be produced, how much labor will be needed and the amount of each material to purchase to maximize contribution margins.
Linear Programming problem
Purchase this Solution
Solution Summary
Using Excel 97-2003 and Solver, this solution illustrates how to maximize the contribution margins on three products by using linear programming.
Solution Preview
I used Excel Solver to solve the problem. I have attached the Excel 97-2003 spreadsheet to this problem. The constraints ...
Purchase this Solution
Free BrainMass Quizzes
Paradigms and Frameworks of Management Research
This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.
Business Ethics Awareness Strategy
This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.
Understanding Management
This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.
Academic Reading and Writing: Critical Thinking
Importance of Critical Thinking
Operations Management
This quiz tests a student's knowledge about Operations Management