Load the Solver add$-$in if it is not already loaded. Set the objective to calculate the highest Net Profit possible.

Use the units sold as changing variable cells.

Use the Limitations section of the spreadsheet model to set constraint for raw materials $($The raw materials consumed mu be less than or equal to the raw materials available$).$ Use cell references to set constraints.

Set a constraint for labor hours. Use cell references to set constraints.