(Production problem) 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 on this page 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.Formulate as an LP problem. Solve using an LP software program or spreadsheet.-

Use Solver to solve the problem. You need to have one Excel sheet with the problem setup (basically what you already did in Assignment #7 and another sheet with Solver solution. Refer to the attached Excel file for Solver examples. Do NOT answer the questions from the textbook.