Please do the following points:

 

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.

Set a constraint for labor hours.

Set a constraint for maximum production capability.

Solve the problem. Generate the Answer Report and Keep Solver Solution.

 

Scenario SummaryCurrent Values:Best CaseWorst CaseMost LikelyChanging Cells:$B$4100200100150$B$5$30.00 $30.00 $25.00 $25.00Hourly_Wages2018$15.00 $15.00 $20.00 $15.00Result Cells:Prod_Cost$375.00 $750.00 $500.00 $562.50$B$22$2,625 $5,250 $2,000 $3,188Notes:Current Values column represents values of changing cells atTme Scenario Summary Report was created.Changing cells for eachscenario are highlighted in gray.

Attachments:

• 1494203839-Visockis_exploring_e06_grader_Capstone _Start.xlsx