A B C D E F G H 1 Sanotronics Simulation with 100 Trials 2 3 Data 4 Selling Price per Unit $249 5 AdmiAdv Cost $1,000,000 6 7 Direct Labor Cost Parts Cost {Normal Distribution) 8 Mean $90 9 Lower End of Upper End of Probability Interval Interval Cost per Unit Standrard Deviation $10 10 0.1 0.0 0.1 $43 1.1 0.2 0.1 0.3 $44 12 0.4 0.3 0.7 $45 Demand (Uniform Distribution} 13 0.2 0.7 0.9 $46 Lower Bound 7500 14 0.1 0.9 1.0 $47 Up -r Bound 30000 15 Expected Direct Labor Cost = ' 45.00 16 17 Simulation Trials 18 19 (1) i2) (3) (4} = 100 mil 10 0.15 $17,000 11 Demand (Normal Distribution) 0.35 $19,000 12 Mear 20,000 0.30 $20,000 13 Standard Dev 30,000 0.20 $22,000 14 15 16 17 18 Simulation Trials (Selling price - Unit VC) *Dmd - Fixed Production Cost 19 (1) (2) (3) (4 (5) (6 (7) (8 20 Random Random Trial Random Number Fixed prodctuion Cost Number Unit Variable Cost Number Demand Profit 21 1 0.957 0.611 0.652 22 0.040 0.443 0.331 C N 23 0.757 0.970 0.154 24 4 0.807 0.253 0.883 25 5 0.798 0.191 0.600 26 6 0.854 0.495 0. 192 27 7 0.697 0.696 0.373 28 8 0.796 0.441 0.909 29 9 0.951 0.968 0.461 30 10 0.936 0.140 0.175 1016 996 0.245 0.569 0.075 1017 997 0.976 0.509 0.985 1018 998 0.785 0.580 0.777 1019 999 0.568 0.091 0.421 1020 1000 0.855 0.229 0.936Question 1 1) What is the direct labor cost per unit for trial 1? Enter answer without $ sign 88032.67 Question 2 2)What is the parts cost per unit for trial 1?Enter your answer without $ sign Answer: 19000 Question 3 3) What is the demand for trial 1? Answer: 136530.12 Question 4 4) What is the mean profit? Enter your answer without the $ sign and rounded up to 2 decimal places. Answer: 639077.88 Question 5 5) What is the maximum profit? Enter your answer as a whole number (no decimal places) What is the probability of loss (in %) ? Answer for blank # 1: 131580 Answer for blank # 2: 11 Question 6 6) What is the value at risk (rounded to whole $)? Answer: 15244 0 / 2 points 0 / 2 points 0 / 2 points 0 / 3 points 0 / 6 points 0 / 2 points Question 8 O / 2 points 8) What is the demand for trial 1? Answer: 136530.12 Question 9 0 / 2 points 9) What is the mean profit from the simulation? (round up to 2 decimal places and do not include the $ sign) Answer: 639077.88 Question 10 0 / 2 points 10) What is the standard deviation of profit? (round up to 2 decimal places and do not include $ sign) Answer: 427006.97