Output | ATC | AFC | AVC | MC | TC | VC | FC |
1 | 160 | 120 | 40 | 40 | 160 | 40 | 120 |
2 | 95 | 60 | 35 | 30 | 190 | 70 | 120 |
3 | 70 | 40 | 30 | 20 | 210 | 90 | 120 |
4 | 55 | 30 | 25 | 10 | 220 | 100 | 120 |
5 | 47 | 24 | 23 | 15 | 235 | 115 | 120 |
6 | 43 | 20 | 23 | 23 | 258 | 138 | 120 |
Fixed cost = TC - VC
Eco 3020 HW 6 Name: 4. Use Excel and the data from problem "3." to construct...
Use Excel and the data below to construct 2 graphs. The first should contain the ATC, AVC, and MC curves. The second should contain FC, VC, and TC curves. Note, you will have to compute values for FC, VC, and TC. Please include these data points in your solutions Please include graphs (2) from Excel in answer. Output Average Total Cost Total Cost Average Fixed Cost Fixed Cost Average Variable Cost Variable Cost Marginal Cost 0 120 120 0 120...