1. Business
2. Operations Research
3. 84466

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

Using Excel, please solve the following:

The Hickory Cabinet and Furniture Company produces sofas, tables, and chairs at its plant in Greensboro, N.C.. The plant uses three main resources to make furniture- wood, upholstery, and labor. The resource requirements for each piece are as follows:

(See chart in attached file)

The furniture is produced weekly and is stored in a warehouse until the end of the week, when it is shipped out. The warehouse has a total capacity of 650 pieces of furniture. Each sofa earns $400 profit, each table $275, and each chair $190. The company wants to know how many pieces of each type of furniture to make each week to maximize profit.

a) Formulate a linear programming model for this problem.
b) Solve the model using the computer.