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.

Simulation Results

Set up a lookup table for the unit cost.

$($Type integers or decimals. Do not round. Use ascending order.$)$

$\backslash$table$[[$Unit Cost,Probability,Lower Limit,Upper Limit,$],[$$$400,0\mathrm{.}20,0,0\mathrm{.}20,$$$400$