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

The management of Brinkley Corporation is interested in using simulation to estimate the profit per unit for a new product. The

selling price for the product will be $$41$ per unit. Probability distributions for the purchase cost, the labor cost, and the

transportation 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:

Upper Bound: $

$($c$)$ Management believes that the project may not be sustainable if the profit per unit is less than $$5.$ Use simulation to estimate the probability that the profit per unit will be less than $$5.$ What is a $95\%$ confidence interval around this proportion?

Round your answers to one decimal of a percentage.

Lower Bound:

$\%$

Upper Bound:

$\%$