Refer to the spreadsheet above:

Recompute the Net Profit for the first five simulation trials if Gross Profit per Unit is changed to $40.00 and Shortage Cost per Unit is changed to $25.00.

Assuming that simulation trials are located in rows 16 through 315, give the Excel formulas for Mean Profit, Minimum Profit, Maximum Profit, and Service Level.

Using the original values for Holding Cost per Unit and Shortage Cost per Unit, would an increase in Replenishment Level to 100 units result in more or less Net Profit for the first five simulation trials? Explain your answer

Answer in Excel!