1 000 Simulate this model for 50 trials and a production

Last updated: 4/22/2023

1 000 Simulate this model for 50 trials and a production quantity of 140 What is the average profit proposal and determine a distribution of profits using the provided discrete distributions for the unit cost demand and fixed costs Price is fixed at Click here to view the discrete distributions Click here to view a sample of 50 simulation trial results Set up a lookup table for the unit cost Type integers or decimals Do not round Use ascending order Unit Cost Probability Lower Limit Upper Limit 400 0 25 600 0 35 700 0 20 800 0 20 400 600 700 800 Discrete Distributions Unit Cost Probability 400 0 25 600 700 800 Demand 120 140 160 0 35 0 20 0 20 45 000 50 000 55 000 Probability 0 25 0 55 0 20 Fixed Costs Probability 0 25 0 50 0 25 X Simulation Results 42 000 29 000 1 000 42 000 9 000 14 000 42 000 39 000 17 000 19 000 47 000 9 000 19 000 19 000 29 000 3 000 27 000 19 000 3 000 19 000 Print 11 000 9 000 6 000 22 000 29 000 22 000 22 000 13 000 34 000 3 000 8 000 19 000 28 000 19 000 29 000 22 000 22 000 11 000 8 000 22 000 Done 11 000 6 000 13 000 22 000 19 000 27 000 17 000 17 000 13 000 6 000