An oil and gas industry produces firm produces oil. The profit function for the firm is give as: profit = ($100-variable cost)*gallons oil sold-fixed cost

The current production rate is 5 million barrels per year. The firm can expand the production by conducting further stepwise exploration, adding I million or 2 million barrels per year with the following cost implications:

Scenarios	Capacity (barrel/year)	Fixed cost	Variable cost
Current	6 million	$ 10 million	$50 /barrel
Add 1 million	7 million	$16 million	$45 /barrel
Add 2 million	8 million	$20 million	$42 /barrel

Annual demand of oil is probabilistic with following distribution

Oil demand	Probability
4 million	0.1
5 million	0.2
6 million	0.3
7 million	0.3
8 million	0.4
9 million	0.4
10 million	0.2
12 million	0.1

Develop a spreadsheet profit model for each scenario, and average profit for each scenario (using same random number).