$($All answers were generated using $1,000$ trials and native Excel functionality.$)$

cost are estimated as follows:

$($a$)$ Develop a what$-$if spreadsheet model computing profit for this product in the base$-$case, worst$-$case, and best$-$case scenarios.

If your answer is negative, use minus sign.

Best$-$case profit :

Worst$-$case profit :

Base$-$case profit $

$($b$)$ Construct a simulation model to estimate the average profit per unit. What is a $95\%$ confidence interval around this average?

Round your answers to two decimal places.

Lower Bound: s

Upper Bound: $

Round your answers to one decimal of a percentage.

Lower Bound:

Upper Bound: