PLEASE USE THE SAMPLE TEMPLATE THAT I PROVIDE HERE. I REPEAT PLEASE USE THE SAMPLE TEMPLATE THAT I PROVIDE HERE. DO NOT ANSWER IF IT IS NOT WITH THE TEMPLATE THAT I PROVIDED.

5. 3-5 A furniture maker sells three different styles of cabinets, including an Italian model, a French Country model, and a Caribbean model. Each cabinet produced must go through three departments: carpentry, painting, and finishing. The table at the top of this page contains all relevant information concerning production times (hours per cabinet), production capacities for each operation per day, and profit ($ per unit). The owner has an obligation to deliver a minimum of 60 cabinets in each style to a furniture distributor. He would like to determine the product mix that maximizes his daily profit. Formulate the problem as an LP model and solve using Excel Table for Problem 3-5 Cabinet Style Carpentry Painting Finishing Profit Italian 3.00 1.50 0.75 $72 French 2 25 1.00 0.75 $65 Caribbean 250 1.25 0.85 $78 Available hours 1,360 700 430 D E F G H A 1 Problem 3-5 2. 3 4 Number of units 5 Profit 6 Constraints: 7 8 9 10 11 12 13 14 LHS Sign RHS