A furniture company manufactures desks and chairs. Each desk uses four units of wood, and each chair uses three units of wood. A desk contributes $250 to profit, and a chair contributes $145. Marketing restrictions require that the number of chairs produced be at least four times the number of desks produced. There are 2000 units of wood available. a. Use Solver to maximize the companys profit. b. Confirm graphically that the solution in part a maximizes the companys profit. PLEASE SHOW THE COMPLETE STEPS TO GET THE GRAPH IN PART B USING THE PROVIDED TEMPLATE.

D7 x fx A 1 Manufacturing desks and chairs 3 Inputs 5 Unit margins 6 Wood usage per unit 8 Decisions 10 Units produced 12 Constraint on wood 13 16 Constraint on chairs 20 Objective to maximize 21 Profit 22 BOHNHGSAWN 11 14 15 17 18 19 23 24 25 # of desks produced is 125 # of chairs produced is 500 Maximum Profit is $103750 26 27 28 25 36 31 33 34 esc E15 B Desks $250 4 Desks 125 Wood used 2000 Chairs produced $103,750 4 0X @ C Chairs $145 3 Chairs 500 Co F2 Wood available 2000 Chairs required 0 20 D 80 F3 28