Allen is in a business of making chairs, tables, and desks. He sells each chair for $140,
table for $145, and desk for $120. Each chair, table, and desk consumes 10, 12 and 15
square feet of lumber; 1.5, 2, and 2.5 hours of labor, and finally 4, 6, and 7 pounds of
screws, respectively. He needs to deliver at most 800 chairs, at most 800 tables, and
at least 460 desks. He has a total of 13,500 square feet of lumber, 2,200 hours of
labor, and 5,000 pounds of screws.
Question 1
What is the value of the objective function after running the problem through Excel's
Solver?
