Cost Analysis Report
djprse
Deliverable3Spreadsheet.xlsxSheet1
| 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 |
&"Helvetica,Regular"&12&K000000&P
