3 4 5 6 7 8 9 10 11 12 13 14 15 16 A Q: Units Produced Logical Formula Excel Formula for 200 units > 0 100 200 300 400 500 600 700 800 900 1000 B TC:Total Cost TVC+TFC E TFC: AVC: ATC: Total TVC: AFC: Total Average Average Average Fixed Variable Fixed Variable Cost Cost Total Cost Cost Cost с 6000 6000 12000 6000 15000 6000 21000 6000 33000 6000 48000 6000 65000 6000 83000 6000 102000 6000 123000 6000 158000 6000 D 6000 9000 15000 27000 42000 59000 77000 96000 117000 152000 TFC/Q C8/A8 Infinity 60.0 30.0 20.0 15.0 12.0 10.0 8.6 7.5 6.7 6.0 F TVC/Q D8/A8 ΝΑ 60.0 45.0 50.0 67.5 84.0 98.3 110.0 120.0 130.0 152.0 G TC/Q or AFC+AVC B8/A8 or E8+F8 Infinity 120.0 75.0 70.0 82.5 96.0 108.3 118.6 127.5 136.7 158.0 H SMC : Short run Marginal Cost *Change in TC/ Change in Q NA (B8-B7)/(A8-A7) A8*300 60.0 30.0 60.0 120.0 150.0 170.0 180.0 190.0 210.0 350.0 *$300*Q TR: Total MR: Marginal TP: Total Revenue Revenue Profit J 0 30000 60000 90000 120000 150000 180000 210000 240000 270000 300000 *Change in TR/ Change in Q K ΝΑ TR-TC (18-17)/(A8-A7) 18-B8 L 69000 87000 102000 300.0 300.0 300.0 300.0 300.0 300.0 115000 300.0 127000 300.0 138000 300.0 147000 300.0 142000 AP: Average Profit TP/Q K8/A8 -6000 Infinity 18000 45000 180.0 225.0 230.0 217.5 204.0 191.7 181.4 172.5 163.3 142.0 or MP: Profit Margin *Change in TP/ Change in Q M MR-MC (K8-K7)/(A8-A7) or J8-H8 240.0 270.0 240.0 180.0 150.0 130.0 120.0 110.0 90.0 -50.0
Make a copy of your spreadsheet and double the fixed costs. How does this change your answer to question 2? Explain in detail.
Q TC TFC TVC AFC
0 6000 6000 Infinity infinity 0 -6000 infinity
100 12000 6000 6000 60.0 60.00 120.0 60.0 30000 300.0 18000 180.0 240.0
200 15000 6000 9000 30.0 45.0 75.0 30.0 60000 300.0 45000 225.0 270.0
300 21000 6000 15000 20.0 50.0 70.0 60.0 90000 300.0 69000 230.0 240.0
400 33000 6000 27000 15.0 67.5 82.5 120.0 120000 300.0 87000 217.5 180.0
500 48000 6000 42000 12.0 84.0 96.0 150.0 150000 300.0 102000 204.0 150.0
600 65000 6000 59000 10.0 98.3 108.3 170.0 180000 300.0 115000 191.7 130.0
700 83000 6000 77000 8.6 110.0 118.6 180.0 210000 300.0 127000 181.4 120.0
800 102000 6000 96000 7.5 120.0 127.5 190.0 240000 300.0 138000 172.5 110.0
900 123000 6000 117000 6.7 130.0 136.7 210.0 270000 300.0 147000 163.3 90.0
1000 158000 6000 152000 6.0 152.0 158.0 350.0 300000 300.0 142000 142.0 -50.0
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
Unlock instant AI solutions
Tap the button
to generate a solution
