The following table summarizes the key facts about two products, A and B$,$ and the resources, Q$,$ R$,$ and S$,$ required to produce them.

Product A Product B

Unit Profit $$2,000$ $$3,000$

Resource Usage per Unit Produced

Product A Product B Amount of Resource Available

Resource Q $212$

Resource R $122$

Resource S $334$

Click here for the Excel Data File

All the assumptions of linear programming hold. Formulate and solve a linear programming model for this problem on a spreadsheet by using the Excel Solver.

Determine units to produce of each unit.

Note: Round your answers to $3$ decimal places.

Determine the total profit.

Note: Round your answer to $2$ decimal places.