Problem 1 The Hickory Cabinet and Furniture Company produces sofas, tables, and chairs. The plant uses three main resources to make furniture - wood, upholstery, and labor. The resource requirements for each piece of furniture and the total resources available weekly are as follows. Resource Requirements Wood (lb) Upholstery (yd) Labor (hr) Sofa Table 7 12 6 5 NA 9 Chair 4 7 5 Total Available Resources 2250 1000 240 The furniture is produced on a weekly basis and stored in the 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 $300 in profit, each table $200, and each chair $150. The company wants to know how many pieces of each type of furniture to make per week to maximize profit. The worksheet named "Hickory I" contains a template for solving this LP problem. a. (6 Points) In cells B4:D7, enter the resource requirement for each of the four constraints. b. (4 Points) In cells G4:G7, enter the appropriate resource limitation values. c. (4 Points) In cells E4:E7, use the "SUMPRODUCT" function to write a formula for the amount of each resource used. Be sure to reference the appropriate cells. d. (4 Points) In cells F4:F7, write the type of inequality associated with each constraint using either " ", or "=". e. (3 Points) In cells B10:D10, enter the profit coefficients for the objective function. f. (3 Point) In cell B13, use the Excel's built-in function named "SUMPRODUCT" to write a formula for the objective function. Be sure to reference the appropriate cells. g. (7 points) Setup Excel Solver to use it to solve the model for the maximum profit. Keep the optimal solution returned by Solver in the model. 1