In: Economics
Quantity | Total Cost | Total Fixed Cost | Total Variable Cost | Average Fixed Cost | Average Total Cost | Average Variable Cost | Marginal Cost |
0 | 30 | ||||||
1 | 75 | ||||||
2 | 150 | ||||||
3 | 255 | ||||||
4 | 380 | ||||||
5 | 525 | ||||||
6 | 680 | ||||||
7 | 840 | ||||||
8 | 1010 | ||||||
9 | 1200 |
Given the quantity and total cost, calculate for total fixed cost, total variable cost, average fixed cost, average total cost, average variable cost, and marginal cost.
Excel formulas would be nice but not required.
Total Fixed Cost = 30
Total Variable Cost = Total Cost - Total Fixed Cost
Average Fixed Cost = Total Fixed Cost/Quantity
Average Total Cost = Total Cost /Quantity
Average Variable Cost = Total Variable Cost/Quantity
Marginal Cost = Change in Total Cost/Change in Quantity
Quantity |
Total Cost |
Total Fixed Cost |
Total Variable Cost |
Average Fixed Cost |
Average Total Cost |
Average Variable Cost |
Marginal Cost |
0 |
30 |
30 |
0 |
||||
1 |
75 |
30 |
45 |
30.00 |
75.00 |
45.00 |
45 |
2 |
150 |
30 |
120 |
15.00 |
75.00 |
60.00 |
75 |
3 |
255 |
30 |
225 |
10.00 |
85.00 |
75.00 |
105 |
4 |
380 |
30 |
350 |
7.50 |
95.00 |
87.50 |
125 |
5 |
525 |
30 |
495 |
6.00 |
105.00 |
99.00 |
145 |
6 |
680 |
30 |
650 |
5.00 |
113.33 |
108.33 |
155 |
7 |
840 |
30 |
810 |
4.29 |
120.00 |
115.71 |
160 |
8 |
1010 |
30 |
980 |
3.75 |
126.25 |
122.50 |
170 |
9 |
1200 |
30 |
1170 |
3.33 |
133.33 |
130.00 |
190 |