The Oak Works is a family-owned business that makes handcrafted dining room tabl

Question

The Oak Works is a family-owned business that makes handcrafted dining room tables and chairs. They obtain the oak from the local tree farm, which ships them 1600 pounds of oak each month. Each table uses 50 pounds of oak while each chair uses 25 pounds of oak. The family builds all the furniture itself and has 360 hours of labor available each month. Each table or chair requires six hours of labor. Each table nets Oak Works $400 in profit, while each chair nets $100 in profit. Since chairs are often sold with the tables, they want to produce at least twice as many chairs as tables.

The Oak Works would like to decide how many tables and chairs to produce so as to maximize profit. Formulate and solve a linear programming model for this problem on a spreadsheet by using the Excel Solver.

a) How many tables and chairs will The Oak Works produce?

b) What is the company's maximum profit?

Explanation / Answer

here let number of tables and chairs are x and y:

50x+25y <=1600

y>=2x

maximize 400x+100y

x,y >=0

solving abve in excel solver:

number of tables x =16

number of chairs y=32

b)

company's maximum profit =400*16+100*32=9600

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.