Proposal to Build a Pipeline
apetersen1974
Deliverable7Spreadsheet.xlsxSheet1
| PRICE | QUANTITY (in millions) | TOTAL REVENUE | MARGINAL REVENUE | TOTAL COST (in millions) | TOTAL FIXED COST (in millions) | TOTAL VARIABLE COST (in million) | AVERAGE TOTAL COST | AVERAGE VARIABLE COST | MARGINAL COST |
| 89 | 0 | $0.00 | $0.00 | $1.72 | |||||
| 82.7 | 1 | $82.70 | $82.70 | $29.19 | |||||
| 76.4 | 2 | $152.80 | $70.10 | $59.11 | |||||
| 70.1 | 3 | $210.30 | $57.50 | $89.76 | |||||
| 63.8 | 4 | $255.20 | $44.90 | $121.15 | |||||
| 57.5 | 5 | $287.50 | $32.30 | $153.28 | |||||
| 51.2 | 6 | $307.20 | $19.70 | $186.13 | |||||
| 44.9 | 7 | $314.30 | $7.10 | $219.72 | |||||
| 38.6 | 8 | $308.80 | -$5.50 | $254.05 | |||||
| 32.3 | 9 | $290.70 | -$18.10 | $289.11 | |||||
| 26 | 10 | $260.00 | -$30.70 | $324.90 |
