A B C D E F G 18 Random Variable Cost Random 19 Trial Number per Unit Number Demand Profit 20 1 0.005 0.853 21 2 0.969 0.630 22 3 0.385 0.253 23 4 0.556 0.225 24 5 0.965 0.643 25 6 0.537 0.241 26 7 0.268 0.345 27 8 0.604 0.280 28 9 0.301 0.052 29 10 0.243 0.873 515 496 0.409 0.655 516 497 0.544 0.458 517 498 0.200 0.822 518 499 0.452 0.468 519 500 0.758 0.453 520 521 Average #DIV/O! #DIV/O! #DIV/O! 522 523 524A A B c D | E l F G l H I I l J 1 Acme A Summary Statistics Bin 3_ Selling Price per Unit $50 -80000 4_ Fixed Cost $100,000 Sample Size 440000 5_ Mean Prot -20000 6_ Variable Cost (Uniform Distribution] Standard Deviation 0 7_ Lower bound $20 Minimum Prot 20000 8_ Upper bound $30 Maximum Prot 40000 9* Count of Losses 60000 10 Probability of Loss 80000 1 Demand [Normal Distribution] Value at risk (at 5%] 100000 EMean 5000 120000 E Standard Dev 1200 140000 11 180000 11 180000 16 Simulation Trials (Selling price - Unit VC) Dmd - FC 11' (1) ' (2) ' (3) ' (4) ' (5) '