Winkler Furniture manufactures two different types of chinacabinets A French Provincial model and a Danish Modern model. Eachcabinet produced must go through three departments: Carpentry,Painting and Finishing. The table provided gives all of theproduction times per cabinet produced and production capacities foreach operation per day along with net revenue per unit prodced.
The firm has a contract to produce a minimum of 60 cabinets perday. How many of each cabinet should the manufacturer make tomaximize daily revenue.
Please show how to set up in excel and how to get the answerusing solver in excel
