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.

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.

a$.$ Determine units to produce of each unit.

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

$\backslash$table$[[,$Product A$,$Product B$],[$Unit to produce,,$]]$

b$.$ Determine the total profit.

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

Total profit