A furniture manufacturer produces two types of tables (country and contemporary) using three types of machines. The time

[answerhappygod]

A furniture manufacturer produces two types of tables (countryand contemporary) using three types of machines. The time requiredto produce the tables on each machine is given in the followingtable.
Country tables sell for $350 and contemporary tables sell for$450. Management has determined that at least 20% of the tablesmade should be country and at least 30% should be contemporary. Howmany of each type of table should the company produce if it wantsto maximize its revenue? (Let X1 bethe number of country tables to produceand X2 the number of contemporarytables to produce.)
(a) Formulate an LP model for this problem tomaximize revenue (in dollars).
Max: ____
Subject to Router: _______
Sander: _________
Polisher: ________
Minimum country tables: _____
Minimum contemporary tables: ______
X1, X2 ≥ 0
(b) Create a spreadsheet model for this problem andsolve it using Solver. What is the optimal solution? (Round youranswers to the nearest integer)
(X1, X2) = ________