Question: 2 . 1 9 . The Oak Works is a family - owned business that makes handcrafted dining room tables and chairs. They obtain the
The Oak Works is a familyowned business that makes handcrafted dining room tables and chairs. They obtain the oak from a local tree farm, which ships them pounds of oak each month. Each table uses pounds of oak while each chair uses pounds of oak. The family builds all the furniture itself and has hours of labor available each month. Each table or chair requires six hours of labor. Each table nets Oak Works $ in profit, while each chair nets $ 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.
a Formulate and solve a linear programming model for this problem on a spreadsheet by using the Excel Solver.
AS b Use Analytic Solver to formulate and solve this model in a spreadsheet.
c Formulate this same model algebraically.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
