Explore BrainMass

Linear Programming to Maximize Contribution Margin

See the attached file.

Find the optimal quantities to produce for product X, Y, and Z and the necessary quantities of labor and material

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


Solution Preview

I used Excel Solver to solve the problem. I have attached the Excel 97-2003 spreadsheet to this problem. The constraints ...

Solution Summary

Using Excel 97-2003 and Solver, this solution illustrates how to maximize the contribution margins on three products by using linear programming.