In: Operations Management
The Hamilton Company manufactures two products: X and Y. Contribution margin per unit is determined as follows:
Product X Product Y
Revenue........................................... $130................. $80
Variable Costs................................... .$70................. $38
Contribution margin............................ $60................. $42
Total demand for X is 16,000 units and for Y is 8,000 units. Machine hours are a scarce resource. 42,000 machine hours are available during the year. Product X requires 6 machine hours per unit, while Product Y requires 3 machine hours per unit. How many units of X and Y should Hamilton Company produce?
Hi,
Please find the answer as below.
If you like the answer, please up vote. It will encourage me to contribute more.
I have used excel solver to solve the problem. I have attached the screenshot of input data, formulas and constraints used along with the solution.
Here, objective function is to maximize the contribution margin.
Hence, Hamilton company shoulf produce 3000 Units of Product X and 8000 units of product Y to maximize the contribution margin,
Find the calculation as below.
1. Screenshot of Input Data
2. Screenshot of Formulas used
3. Screenshot of Constraints used
4. Screenshot of Optimum solution