Problem
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.