PLEASE HELP!
Porta Com Simulation with 100 Trials $249 $400,000 $600,000 Selling Price per Unit Administrative Cost Advertising Cost Parts Cost (Uniform Distribution) Smallest Value Largest Value Direct Labor Cost $80 $100 Lower Upper Random No Probability Random No. Cost per Unit $43 $44 0.1 0.0 0.1 0.2 0.1 0.3 $45 Demand (Normal Distribution) $46 Mean $47 Standard Dev 0.4 0.3 0.7 0.2 0.7 0.9 15000 0.1 0.9 1.0 4500 $ Expected Dire ct Labor Cost = 45.00 Simulation Trials (1) (2) (3) (4) (5) (6) (7) (8) Random Direct Labor Random Parts Random First-Year Cost per Unit Cost per Unit Profit 611,296 (94,372 1,640,668 927,051 1,017,740 720,713 720,967 438,028 700,808 1,340,813 640,258.6 Trial Number Number Number Demand 0.909 $ 0.195 $ 0.574 $ 0.028 $ 0.848 $ 0.753 $ 0.822 $ 0.703 $ 0.560 $ 0.137 $ $ 15226 $ 7540 $ 23057 $ 15611 $ 18503 $ 15509 $ 15707 $ 13081 $ 15077 $ 19304 $ 14422.9 $ 0.385 45 98.17 0.520 2 0.528 45 83.90 0.049 91.47 3 0.037 0.587 43 0.963 0.554 45 80.56 96.95 95.05 96.44 94.07 91.19 82.74 0.087 43 0.782 5 0.098 0.024 96 43 0.545 97 43 0.562 98 0.392 45 0.335 99 0.670 45 0.507 100 0.381 45 0.831 Average 45.0 90.18 O O O O- O N This is the PortaCom simulation with 100 trials that was covered in the lecture. Suppose the following changes occur in the assumptions. - 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. Make the appropriate changes in the Excel sheet.. Do not change the given random numbers. Now, what are the a) mean profit (rounded to whole $) b) the probability of loss (in %) and c) value at risk (rounded to whole $)? Remember to give the absolute value. d) Is this more or less risky than the original example? Porta Com Simulation with 100 Trials $249 $400,000 $600,000 Selling Price per Unit Administrative Cost Advertising Cost Parts Cost (Uniform Distribution) Smallest Value Largest Value Direct Labor Cost $80 $100 Lower Upper Random No Probability Random No. Cost per Unit $43 $44 0.1 0.0 0.1 0.2 0.1 0.3 $45 Demand (Normal Distribution) $46 Mean $47 Standard Dev 0.4 0.3 0.7 0.2 0.7 0.9 15000 0.1 0.9 1.0 4500 $ Expected Dire ct Labor Cost = 45.00 Simulation Trials (1) (2) (3) (4) (5) (6) (7) (8) Random Direct Labor Random Parts Random First-Year Cost per Unit Cost per Unit Profit 611,296 (94,372 1,640,668 927,051 1,017,740 720,713 720,967 438,028 700,808 1,340,813 640,258.6 Trial Number Number Number Demand 0.909 $ 0.195 $ 0.574 $ 0.028 $ 0.848 $ 0.753 $ 0.822 $ 0.703 $ 0.560 $ 0.137 $ $ 15226 $ 7540 $ 23057 $ 15611 $ 18503 $ 15509 $ 15707 $ 13081 $ 15077 $ 19304 $ 14422.9 $ 0.385 45 98.17 0.520 2 0.528 45 83.90 0.049 91.47 3 0.037 0.587 43 0.963 0.554 45 80.56 96.95 95.05 96.44 94.07 91.19 82.74 0.087 43 0.782 5 0.098 0.024 96 43 0.545 97 43 0.562 98 0.392 45 0.335 99 0.670 45 0.507 100 0.381 45 0.831 Average 45.0 90.18 O O O O- O N This is the PortaCom simulation with 100 trials that was covered in the lecture. Suppose the following changes occur in the assumptions. - 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. Make the appropriate changes in the Excel sheet.. Do not change the given random numbers. Now, what are the a) mean profit (rounded to whole $) b) the probability of loss (in %) and c) value at risk (rounded to whole $)? Remember to give the absolute value. d) Is this more or less risky than the original example
