Report on Events Impacting the Supply and Demand of Oil

profileapetersen1974
Deliverable3Spreadsheet.xlsx

Sheet1

Quantity (miles of pipeline) Total Cost Total Fixed Cost Total Variable Cost Average Fixed Cost Average Variable Cost Marginal Cost
0 $ 5,000 $ 5,000
1,000 $ 11,573
2,000 $ 18,208
3,000 $ 29,267
4,000 $ 44,750
5,000 $ 64,657
6,000 $ 88,987
7,000 $ 117,740
8,000 $ 150,918
9,000 $ 188,518
10,000 $ 230,543
11,000 $ 276,991
12,000 $ 327,863
13,000 $ 383,159
14,000 $ 442,878
15,000 $ 507,021
16,000 $ 575,587
17,000 $ 648,577
18,000 $ 725,991
19,000 $ 807,828
20,000 $ 894,089
21,000 $ 984,774
22,000 $ 1,079,882
23,000 $ 1,179,414
24,000 $ 1,283,370
25,000 $ 1,391,749
26,000 $ 1,504,552
27,000 $ 1,621,778
28,000 $ 1,743,429
29,000 $ 1,869,502
30,000 $ 2,000,000