Problem:
Using Excel, please solve the follwing:
The Hickory Cabinet and Furnituire 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:
Wood (lb) Upolstery(yr) Labor(hr)
Sofa 7 12 6
Table 5 --- 9
Chair 4 7 5
Total Available resources 2,250 1,000 240
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.