Construct a simulation model to estimate the average profit per unit.

What is a $95\%$ confidence interval around this average?

THE UPPER BOUND $ is$?$

$($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 $w$ estimated as follows:

$\backslash$table$[[\backslash$table$[[$Procurement$],[$Cost $($$$)]],$Probability,$\backslash$table$[[$Labor$],[$Cost $($$$)]],$Probability,$\backslash$table$[[$Transportation$],[$Cost $($$$)]],$Probability$],[10,0\mathrm{.}25,20,0\mathrm{.}10,3,0\mathrm{.}75],[11,0\mathrm{.}45,22,0\mathrm{.}25,5,0\mathrm{.}25],[12,0\mathrm{.}30,24,0\mathrm{.}35,,],[,,25,0\mathrm{.}30,,]]$

$$7\mathrm{.}17$

$$6\mathrm{.}93$

$$7\mathrm{.}93$