<h2>
<u>Disclamer:</u></h2>
As it ask to run simulations the values calculates will difer even if you follow the same step as I did.
Answer:
Mean Profit: $ 4,295
Probability of loss: 29.80%
As the product has a mean profit it will on average generate gains
but:
as the standard deviation of the simulation was $ 7,778.40
<u>we should not invest on the product as it is to variable</u>
<u>Explanation</u>:
We are going to use the =RAND() function of excel
which, generates a random number between 0 and 1
This will be done 1,000 times 500 for the variable cost
and 500 for the demand.
Then we copy and paste this numbers to get them fixed.
Then, we convert them into actual cost and demand in units considering their distribution
using excel dist.norm.inv
Now, with this values we solve for profit on each one.
<u></u>
FOr the complexity I attached the excel file as the plataform interface cannot handle large tables.
