$4.$ Open the Solver and set an objective to maximize the Total Profit $($cell D$13)$ by changing the

Production Quantity for Model A $($cell B$5)$ and Model B $($cell C$5).$

$15.$ Add Solver integer constraints for the Production Quantity of Model A $($cell B$5)$ and Model B $($cell C$5)$

since they are manufactured in discrete units.

$16.$ Add a Solver constraint to prevent the total number of Labour Units used $($cell D$6)$ from exceeding

the maximum number of Labour Units available $($cell B$16).$

$17.$ Add a Solver constraint to prevent the total amount of Fibreglass Resin used $($cell D$7)$ from

exceeding the maximum amount available.

$18.$ Add a Solver constraint to prevent the total number of Aluminum Frameworks used $($cell D$8)$ from

exceeding the maximum number available.

$19.$ Run the Solver to solve for the solution. Select to keep the solution and generate an answer report.

$20.$ Move the worksheet generated by the Solver to the immediate right of the Maximize Production

Profit worksheet.