Create a spreadsheet model for this problem and solve it using Solver. How many of each type of table should the company produce if it wants to maximize revenue? Round your answers to two decimal places, if necessary.

$405\mathrm{.}80$ Country, $173\mathrm{.}91$ Contemporary

cA furniture manufacturer produces two types of tables $($country and col

of machines. The time required to produce the tables on each machine

Total Machine Time

Machine

Router

Sander

Polisher

Country Contemporary

Available per Week

$1\mathrm{.}5$

$2\mathrm{.}0$

$3\mathrm{.}0$

$2\mathrm{.}5$

$4\mathrm{.}5$

$1,000$

$2,000$

$1\mathrm{.}5$

$1,500$

Country tables sell for $$350$ and contemporary tables sell for $$450.$ Ma

at least $20\%$ of the tables made should be country and at least $30\%$ st

a$.$ Select the correct LP model for this problem.

Let X$1$ represent Number of country tables to produce.

Let X$2$ represent Number of contemporary tables to produce..

What is the maximum revenue for the optimal solution?