Hint$($s$)$

Check My Work

$($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 $$43$ per unit. Probability distributions for the purchase cost, the labor cost, and the transportation cost are 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,,]]$

$($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.

$\backslash$table$[[$Best$-$case profit,$],[$Worst$-$case profit,$