Please use excel solver and show all work

The ABC Furniture Company produces sofas, tables, and chairs at its plant in Greensboro, North Carolina. 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 Furniture Product Wood (lb) Upholstery (yd) Labor (hour) Sofa 6 10 5 Table 5 0 3 Chair 4 3 1 Total available resources 2020 1100 1080 The furniture is produced on a weekly basis and stored in a warehouse until the end of the week, when it is shipped out, however the warehouse has limited capacity of storing furniture. The warehouse can hold 600 pieces of table or chair, or 200 pieces of sofa (That is to say, a sofa takes up three times as much space as a table or chair). Each sofa earns $400 in profit, each table, $290, and each chair, $180. The company wants to know how many pieces of each type of furniture to make per week in order to maximize profit