Linear or Integer Programming problem using Excel QM, POM, or Solver

LP4 Seminar Problem

As Operations Manager, you would like to know which product mix needs to be manufactured. The firm manufactures two models of the trans catheter aortic valve replacement system: the system which is equipped with 23 mm valves and the system which is equipped 29 mm valves.

The expected profit for 23mm system is $300 per unit, while profit for 29mm system is $360 per unit. The firm utilizes aortic valves bought from an external supplier. There is a supply restriction for both of 23 mm and 29mm valves. The current suppler of valves cannot supply more than 300 units of 23 mm valves per week and no more than 600 units of 29 mm valves per week.

The manufacturing time for one 23 mm aortic valve system is 2 hours per week. The manufacturing time for one 29 mm aortic valve system is 2.4 hours per week. There are 1550 hours of total manufacturing time available per week. Determine how many units of 23 mm aortic valve system and 29 mm aortic valve system the firm needs to manufacture per week to maximize profit.

Hint: Set up and solve the problem as Linear or Integer Programming problem using Excel QM, POM, or Solver.

You may also like