# Linear Programming

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.

https://brainmass.com/business/operations-research/linear-programming-84466

#### Solution Summary

Provides solution to linear programming problem using Excel Solver.