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 demand.

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

Set up a lookup table for the fixed costs.

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

Fixed Costs Probability Lower Limit Upper Limit

Suppose a Monte Carlo simulation using these lookup tables generated the $50$ trial results in the problem st

The average profit is $

$($Round to the nearest dollar as needed.$)$

Discrete Distributions