A furniture company manufactures tables and chairs. A table requires $45$ board$-$feet of wood, and a chair requires $20$ board$-$feet of wood. Wood can be purchased at a cost of $$1\mathrm{.}90$ per board$-$foot, and $25,000$ board$-$feet of wood are available for purchase. It takes$2\mathrm{.}5$ hours of skilled labor to manufacture an unfinished table or an unfinished chair. Then $3$ more hours of skilled labor will turn an unfinished table into a finished table, and $1\mathrm{.}5$ more hours of skilled labor will turn an unfinished chair into a finished chair. A total of $4500$ hours of skilled labor is available $($and have already been paid for$).$ All furniture produced can be sold at the following unit prices: an unfinished table, $$180$; a finished table, $$330$; an unfinished chair, $$130$; and a finished chair, $$200.$

a$.$ Determine how to maximize the company$$s profit from manufacturing tables and chairs. USE EXCEL SOLVER and the following template Manufacturing tables and chairs

Board feet required per unit

Cost per board foot

Labor hours per unfinished unit

Additional labor hours to finish

Unfinished

Finished

Table Chair

Numbers to produce

Number finished

Number sold unfinished

Total labor hours used

Labor hours available

Cost of wood

Revenues

Finished

Unfinished

Profit