Implement a financial simulation model for a new product

Last updated: 4/23/2023

Implement a financial simulation model for a new product proposal and determine a distribution of profits using the provided discrete distributions for the unit cost demand and fixed costs Price is fixed at 1 000 Simulate this model for 50 trials and a production quantity of 140 What is the average profit 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 0 0 25 600 0 35 0 25 0 60 700 0 20 0 60 0 80 800 0 20 0 80 1 Set up a lookup table for the demand Type integers or decimals Do not round Use ascending order Demand Probability Lower Limit Upper Limit 120 0 25 140 0 55 160 0 20 fo 400 600 700 800 1 120 140 160 Simulation Results 42 000 20 000 1 000 47 000 42 000 9 000 9 000 19 000 14 000 19 000 42 000 29 000 39 000 3 000 17 000 27 000 19 000 19 000 3 000 19 000 Print 11 000 8 000 11 000 0 000 19 000 6 000 28 000 22 000 19 000 29 000 29 000 22 000 22 000 22 000 22 000 13 000 11 000 34 000 8 000 3 000 22 000 Done 6 000 13 000 22 000 19 000 27 000 17 000 17 000 13 000 6 000 1 X Piscrete Distributions Unit Cost Probability 0 25 0 35 0 20 0 20 400 600 700 800 Demand 120 140 160 Probability 0 25 0 55 0 20 Fixed Costs Probability 0 25 0 50 0 25 45 000 50 000 55 000