A furniture maker sells three dissimilar styles of cabinets including an Italian Model a French Country Model and a Caribbean model. Each cabinet produced should go through three departments- carpentry, painting and finishing. The table contains each relevant info concerning production times (hours per cabinet), production capacities for each operation per day and profit ($ per unit). The owner has a responsibility to deliver a minimum of 60 cabinets in each style to a furniture distributor. He would like to regulate the product mix that maximize his daily profit. Formulate the problem as an LP model and solve using excel-
Table-
Cabinet Style Carpentry Painting Finishing Profit
Italian 3.00 1.50 .75 $72
French 2.25 1.00 .75 $65
Caribbean 2.50 1.25 .85 $78
Available Hours 1,360 700 430