a E 1:: Sanotronics Simulation with 100 Trials This is the Sanotronics simulation with 100 trials that was covered in Data the lecture. Here, we want to illustrate how the results can change Selling Price per Unit $249 when different distributions are used for some of the random AdmfAdv Cost $1,000,000 variables. Suppose the following changes occur in the assumptions. Direct Labor Cost Part5 Cost [Uniform Distribution) - Parts cost follows a normal distribution with mean of $90 and Lower Bound $80 standard deviation of $10. LOW\" End Upper End Of , Demand now follows a uniform distribution between 7,500 and Probability Of llBWEI llBWEI Cost per Unit Upper Bound $100 30,000 units. 0'1 0'0 0'1 $43 Make the appropriate changes in the Excel sheet. Do not change the 0'2 0'1 0'3 $44 given random numbers. 04 0,3 0.7 $45 Demand [Normal Distribution) Now, what are the 0'2 0'7 0'9 $46 Mean 15000 a} mean profit [rounded to whole 5) :' 0'9 \"3 W S'anda'd De\" 450\" b] the probability of loss (in as.) and Expected Direct Labor CDSI : $ 45'00 c] value at risk (rounded to whole 5]? Remember to give the absolute . . . value. Slmulatlon TI'Ials d] Is this more or less risky than the original example? (1) ' (2) ' (3) ' (4) ' (5) ' (6) ' (7) ' (8) Radom Direct Labor Parts Cost per Radom FirstrYear Trial Number Cost per Unit Radom Number Unit Number Demand Prot 1 0,385 45 0,909 $ 98.17 0.520 15226 $ 611,296 2 0.528 45 0.195 $ 83.90 0.049 7540 $ (94,372} 3 0.037 43 0.574 $ 91.47 0.963 23057 $ 1,640,668 4 0.587 45 0.028 $ 80.56 0.554 15611 $ 927,051 5 0.087 43 0.848 $ 96.95 0.782 18503 $ 1,017,740 95 0.572 45 0.756 $ 95.13 0.066 8237 $ (103,176) 96 0.098 43 0.753 $ 95.05 0.545 15509 $ 720,713 97 0,024 43 0,822 $ 96.44 0.562 15707 $ 720,967 98 0,392 45 0,703 $ 94.07 0.335 13081 $ 438,028 99 0,670 45 0,560 $ 91.19 0.507 15077 $ 700,808 100 0,381 45 0,137 $ 82.74 0.831 19304 $ 1,340,813 Average 45.0 $ 9018 144229 35 6402586 Summary Statistics Sample Size 100 Mean Prot :8 640,259 Standard Deviation $ 515,687 Minimum Prot $ (531,541) Maximum Prot $ 1,969,156 Number of Losses 12 Probability of Loss 0,120 Prob(PrDt >= 500K) 059 5th Percentile VaR $ 71 492247575 149,225