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. c. Use SolverTable to see what happens to the decision variables and the total profit when the availability of wood varies from 1000 to 3000 in 100-unit increments. Based on your findings, how much would the company be willing to pay for each extra unit of wood over its current 2000 units? Using the temate below please show me the steps of getting the graph for part b.
A furniture company manufactures desks and chairs. Each desk uses four units

SHEHR22682888 119 X fx A 1 Manufacturing desks and chairs 2 3 Inputs 4 5 Unit margins 6 Wood usage per unit 7 8 Decisions 9 10 Units produced 12 Constraint on wood 15 16 Constraint on chairs 19 20 Objective to maximize 21 Profit 22 # of desks produced is 125 23 #of chairs produced is 500 Maximum Profit is $103750 24 25 11 13 14 Paste 17 18 26 27 28 29 30 31 32 31 34 35 36 37 38 30 Ready Calibri B I U 6 Desks $250 4 Desks 125 Wood used 2000 Chairs produced $103,750 Answer Report 1 26 05 V 11 C Chairs $145 3 Chairs 500 Sensitivity Report 1 ' ' V 1.A D Wood available 2000 Chairs required 1 C + 1 0 Answer Report 2 Sensitivity alt S

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!

Q:

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

Q:

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

Q:

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

Q:

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

Q:

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

Q:

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

Q:

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

Q:

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

Q:

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

Q:

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

Q:

Find the second derivative for each of the functions in Problem.

Q:

Class 1 self-assessment surveys and development of leadership talent" please respond to the following: debate the usefulness of self-assessment surveys to determine employees with high potential...

Q:

How much should be deposited today in a CD paying 6.5% compounded monthly in order to have $17,000 in the account in 10 years? Group of answer choices $8,874.78 $8,890.36 $9,056.34 $8,893.46

Q:

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