Generate a scenario summary report using the cell references for Total Production Cost and Net Profit.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 a constraint for raw materials $($The ray materials consumed must be less than or equal to the raw materials avallable$),$ Use cell references to set constraints.Set a constraint for labor hours, Use cell references to set constraints.Set a constraint for maximum production capability, Units sold $($B$4)$ must be less than or equal to maximum capability per week $($B$7),$ Use cell references to set constrainte, Solve the problem. Generate the Answer Report and Keep Solver Solutien,