NOTE!!!!!! THIS PROBLEM NEEDS TO BE SOLVED IN EXCEL USING THE SOLVER FUNCTION, HAND WRITTEN RESPONSES ARE NOT ACCEPTABLE.

PLEASE SOLVE THIS USING SOLVER IN EXCEL, PLEASE PROVIDE A SCREENSHOT OF THE EXCEL SHEET BEFORE USING THE SOLVER FUNCTION AND AFTER USING THE SOLVER FUNCTION SO THAT IT SHOWS WHAT IS CHANGING AND PLEASE PROVIDE SCREENSHOT OF WHAT TO PUT INTO SOLVER. THANK YOU

Product Mix Homework Problem Furnco manufactures desks and chairs. Each desk used 4 units of wood, and each chair used 3 units of wood. A desk contributes $40 to profit, and each chair contributes $25 to profit. Marketing restrictions require that the number of chairs produced be at least twice the number of desks produced. There are 20 units of wood available. Determine the mix of desks and chairs to produce in order to maximize profit. The optimal objective function value should be $180. Profit Information Chairs Contribution/unit Units produced Profit generated Production Data Chairs Wood/unit required Minimum ratio of chairs to desks Total units of wood used Number of chairs Wood Constraint Production Ratio Constraint Total Profit 0 Desks Desks X