Question: 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

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

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 $400 to profit, and a chair contributes $250....

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

Please Help! How do I fill out this table?? 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 $400 to...

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

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 $400 to profit, a chair contributes $250. Marketing...

This week, we will practice applying concepts from Chapters 1 3 - 1 4 . Submit a Word document with your responses and be sure to also attach any relevant Excel files with your submission. Chapter 1...

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

Suppose we have a 2D array M: } } { a) Write an algorithm to traverse this array and make a pair of brackets : Hint: [), {}, () b) Write a separate logic in a form of algorithm, as you get a bracket...

Study the following Minitab output. What statistical test was being computed by Minitab? What are the results of this analysis? Mann-Whitney Test and CI Point estimate for ETA1-ETA2 is -8.000 95.7...

4 Write in words what each inequality means. Part a is done for you. 7

a=2 b= 0 c= 2 d=0 e=0 f=9 g=3 5. Draw the Network diagram for the following project. Estimate the Earliest start time and Latest finish time for each activity. If every day it cost 200 rials for this...