Linear Programming (LP) A manager must decide on the mix of products two product

Question

Linear Programming (LP) A manager must decide on the mix of products two products, X and Y, to produce for the coming week. He can make a profit of $150 on product X and $125 and on product Y. Each product required two stages of production Product X requires: 3 min/unit for molding 2 min/unit for painting Product Y requires: 2 min/unit for molding 4 min/unit for painting The plant has weekly capacity of 600 minutes for molding, and 600 minutes for | painting. Develop a simple equation to represent the "objective function". Max f {} Create the equation for each constraint. input the above information and formulas into Microsoft Excel "Solver" Create and hand-in a print-out of your completed spreadsheet (with the calculated answers)

Explanation / Answer

The objective of the firm is to maximise profit

Max Z= 150x+125y

Because the profit from product x is $150 and from product y is $125

Subject to

3x+2y<=600 (Moiding COnstraint)

2x+4y<=600 (Painting Constraint)

x,y>=0

The solution to the problem is done through MS Excel solver is given below

Max Z 31875 Decision Variable x 150 y 75 Constraint 600 600 600 600

Related Questions

Navigate

• Browse (All)
• Browse L
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.