Please finish the following questions using Excel with appropriate formulas;

Q1. Solver

The ABC Furniture Company produces sofas, tables, and chairs at its plant in Greensboro, North Carolina. The plant uses three main resources to make furniturewood, 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.