New Exercise Bank Content Qu$.05-05$

The following table summarizes the key facts about two products, A and B$,$

and the resources, $Q,R,$ and $S,$ required to produce them.

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.

a$.$ Determine units to produce of each unit product A and $B.$

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

b$.$ Determine the total profit.

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