Consider the Special Products break even analysis spreadsheet shown below.

Special Products Co. Break-Even Analysis
		Data			Results
	Unit Revenue	$2,000 $10,000,000 $1,000 30000		Total Revenue	$60,000,000
	Fixed Cost			Total Fixed Cost	$10,000,000
	Marginal Cost			Total Variable Cost	$30,000,000
	Sales Forecast			Profit (Loss)	$20,000,000
	Production Quantity	30000		Break-Even Point	10,000

The production manager has decided to order a production run of Q=35000. Use simulation to find the distribution of profit given the following random inputs:

The fixed cost varies uniformly between 9 and 11 million dollars. The marginal cost is normally distributed with a mean of $1000 and a standard deviation of $200. The Sales Forecast is triangularly distributed with a minimum of 20000, a most likely value of 30,000 and an upper limit of 40000. All variables are continuous. Dont round to integer values.

Use 1000 iterations and find the mean and the 90^th percentile of the profit distribution and the probability of a loss. Include the histogram of Profit in your response.