Sanotronics Simulation with 100 Trials This is the Sanotronics simulation with 100 trials that was covered in the lecture. Here, we want to illustrate how the Data results can change when different distributions are used for some of the random variables. Selling Price per Unit $249 Suppose the following changes occur in the assumptions. Adm/Adv Cost $1,000,000 Parts cost follows a normal distribution with mean of $90 and standard deviation of $10. - Demand now follows a uniform distribution between 7,500 and 30,000 units. Direct Labor Cost Parts Cost (Normal Distribution) The appropriate changes have been made in the Excel sheet. Do not change the given random numbers. Mean $90 Round all answers up to 2 decimal places. Lower End of 1) What is the direct labor cost per unit for trial 17 Probability Interval Upper End of Interval Cost per Unit Standrard Deviation $10 2) What is the parts cost per unit for trial 1? 0.1 0.0 0.1 $43 3) What is the demand for trial 17 0.2 0.1 0.3 $44 4) What is the mean profit? 0.4 0.3 0.7 $45 Demand (Uniform Distribution) 5) What is the maximum profit? 0.2 0.7 0.9 $46 Lower Bound 7500 5) What is the probability of loss (in %) ? 0.1 0.9 1.0 $47 Upper Bound 30000 6) What is the value at risk (rounded to whole $)? Remember to give the absolute value. $ 7) Is this more or less risky than the original example solved in class? Expected Direct Labor Cost = 45.00 Simulation Trials (1) (2) (3) (4) (5) (6) (7) (8) Direct Labor Cost Radom First-Year Trial Radom Number per Unit Radom Number Parts Cost per Unit Number Demand Profit 1 0.385 0.909 0.520 0.52 0.19 0.049 0.037 0.574 0.963 0.587 0.028 0.554 0.087 0.848 0.782 0.572 0.756 0.066 0.098 0.753 0.545 0.024 0.827 0.562 0,392 0.703 0.335 0.670 0.560 0.507 0.381 0.137 0.831