$($All answers were generated using $1,000$ trials and native Excel functionality.$)$ units, with $4,000$ units the most likely.

The data has been collected in the Microsoft Excel file below. Download the spreadsheet and perform the required analysis to answer the questions below. Generate trials on a new worksheet.

Download spreadsheet madeira$-$c$591$cb$.$xIsx

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

$\backslash$table$[[$$$1,],[$$$,300,000],[$$$,20,000]]$

a beta parameter of $2.$ Construct a simulation model to estimate the average profit and the probability that the project will result in a loss. Round your answers to the nearest whole number.

Average Profit

Probability of a Loss

$ $3$

$\%$

c$.$ What is your recommendation regarding whether to launch the product?

The average profit is $$ and the probability of a loss is greater $$ than $10\%.$ Thus, Madeira Computing $$

$$ want to launch the product if they have low risk tolerance.