Please help solve parts d and f. Please give me correct and direct answers only and show steps on how to use it in Microsoft Excel Solver. THANK YOU!

(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 of the profit per unit values which can then be used to find of an unacceptably low profi answer to three decimal places.)