Winkler Furniture manufactures two different types of china cabinets: a French Provincial model and a Danish Modern model. Each cabinet produced must go through three departments: carpentry, painting, and finishing. The table below contains all relevant information concerning production times per cabinet produced and production capacities for each operation per day, along with net revenue per unit produced. The firm has a contract with an Indiana distributor to produce a minimum of 300 of each cabinet per week (or 60 cabinets per day). Owner Bob Winkler would like to determine a product mix to maximize his daily revenue.
(a) Formulate as an LP problem.
(b) Solve using an LP software program or spreadsheet *(need formulas)*
Cabinet Style Carpentry (Hours/Cabinet) Painting (Hours/Cabinet) Finishing (Hours/Cabinet) Net Revenue per Cabinet ($) French Provincial 3 1.5 .75 28 Danish Modern 2 1 .75 25 Dept. capacity (hrs) 360 200 125 Let X 1 = the number of French Provincial cabinets produced each day X 2 = the number of Danish Modern cabinets produced each day.