1000 simulation trials in total on Excel file

(a) Compute profit (in \$) per unit for the base-case scenario. $ /unit (b) Compute profit (in \$) per unit for the worst-case scenario. $ /unit (c) Compute profit (in \$) per unit for the best-case scenario. $ /unit (d) Construct a simulation model to estimate the mean profit (in \$) per unit. (Use at least 1,000 trials. Round your answer to two decimal places.) $ (e) Why is the simulation approach to risk analysis preferable to generating a variety of what-if scenarios? Simulation will provide a distribution of the profit per unit values which can then be used to find the probability of an unacceptably low profit