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

Problem $3-5$In addition to uploading the solution in the solutions view, take a screenshot or PDF of the formula view and upload it as well.

You are required to provide a written answer to the specific questions asked, to show that you understand how to interpret the spreadsheet solution. Failure to do so will result in a deduction of $10$ points. An example of the written answer is: The number of units needed to breakeven is $10,000$ units and the breakeven dollar amount is $$50,000$

PLEASE ANSWER THIS IN EXCEL WITH THE FORMAT REQUIRED. ALSO, MAKE SURE YOU INCLUDE THE FORMULA VIEW I NEED TO ALSO UPLOAD

Thank you so much, I will vote you!