Eco case study two revision.

profileJambo
copy_of_eco_520case_study_2.xlsx
Home>Business & Finance homework help>Economics homework help>Eco case study two revision.

demand_1

q TFC TC AFC ATC market quantity Demand supply POINT ELASTICITY REVENUE MARGINAL REVENUE
0 0 0 0 0
1 110 110 110 110 100 670 40 40 3890 8
2 110 110 55 55 200 620 80 80 15890 4
3 110 110 36.6666666667 36.6666666667 300 570 120 120 35890 0
4 110 110 27.5 27.5 400 520 160 160 63890 -4
5 110 110 22 22 500 470 200 200 99890 -8
6 110 110 18.3333333333 18.3333333333 600 420 240 240 143890 -12
7 110 110 15.7142857143 15.7142857143 700 370 280 280 195890 -16
8 110 110 13.75 13.75 800 320 320 320 255890 -20
9 110 110 12.2222222222 12.2222222222 900 270 360 360 323890 -24
10 110 110 11 11 1000 220 400 400 399890 -28
11 110 110 10 10 1100 170 440 440 483890 -32
12 110 110 9.1666666667 9.1666666667 1200 120 480 480 575890 -36
13 110 110 8.4615384615 8.4615384615 1300 70 520 520 675890 -40
14 110 110 7.8571428571 7.8571428571 1400 20 560 560 783890 -44
15 110 110 7.3333333333 7.3333333333 1500 -30 600 600 899890 -48
16 110 110 6.875 6.875 1600 -80 640 640 1023890 -52
17 110 110 6.4705882353 6.4705882353 1700 -130 680 680 1155890 -56
18 110 110 6.1111111111 6.1111111111 1800 -180 720 720 1295890 -60
19 110 110 5.7894736842 5.7894736842 1900 -230 760 760 1443890 -64
20 110 110 5.5 5.5 2000 -280 800 800 1599890 -68

demand_2

q Market Quantity Market demand market supply TFC TC POINT ELASTICITY REVENUE MARGINAL REVENUE
0 0 0 0 0
1 100 670 81.63 110 110 4000 8053.27 8
2 200 620 163.27 110 110 8000 32543.06 4
3 300 570 244.90 110 110 12000 73359.39 0
4 400 520 326.53 110 110 16000 130502.24 -4
5 500 470 408.16 110 110 20000 203971.63 -8
6 600 420 489.80 110 110 24000 293767.55 -12
7 700 370 571.43 110 110 28000 399890.00 -16
8 800 320 653.06 110 110 32000 522338.98 -20
9 900 270 734.69 110 110 36000 661114.49 -24
10 1000 220 816.33 110 110 40000 816216.53 -28
11 1100 170 897.96 110 110 44000 987645.10 -32
12 1200 120 979.59 110 110 48000 1175400.20 -36
13 1300 70 1061.22 110 110 52000 1379481.84 -40
14 1400 20 1142.86 110 110 56000 1599890.00 -44
15 1500 -30 1224.49 110 110 60000 1836624.69 -48
16 1600 -80 1306.12 110 110 64000 2089685.92 -52
17 1700 -130 1387.76 110 110 68000 2359073.67 -56
18 1800 -180 1469.39 110 110 72000 2644787.96 -60
POINT ELASTICITY 0 100 200 300 400 500 600 700 800 900 1000 1100 1200 1300 1400 1500 1600 1700 1800 4000 8000 12000 16000 20000 24000 28000 32000 36000 40000 44000 48000 52000 56000 60000 64000 68000 72000 REVENUE 0 100 200 300 400 500 600 700 800 900 1000 1100 1200 1300 1400 1500 1600 1700 1800 8053.2653061224491 32543.061224489797 73359.387755102041 130502.24489795919 203971.63265306124 293767.55102040817 399890 522338.97959183675 661114.48979591834 816216.53061224497 987645.10204081633 1175400.2040816327 1379481.8367346937 1599890 1836624.6938775508 2089685.918367347 2359073.6734693879 2644787.9591836734 MARGINAL REVENUE 0 100 200 300 400 500 600 700 800 900 1000 1100 1200 1300 1400 1500 1600 1700 1800 8 4 0 -4 -8 -12 -16 -20 -24 -28 -32 -36 -40 -44 -48 -52 -56 -60

combined

q TFC TC AFC ATC market quantity Demand market 1 supply market 2 supply REVENUE MR
0 0 0 0 0 0
1 110 110 110 110 100 670 40 81.6326530612 3890 8
2 110 110 55 55 200 620 80 163.2653061224 15890 4
3 110 110 36.6666666667 36.6666666667 300 570 120 244.8979591837 35890 0
4 110 110 27.5 27.5 400 520 160 326.5306122449 63890 -4
5 110 110 22 22 500 470 200 408.1632653061 99890 -8
6 110 110 18.3333333333 18.3333333333 600 420 240 489.7959183673 143890 -12
7 110 110 15.7142857143 15.7142857143 700 370 280 571.4285714286 195890 -16
8 110 110 13.75 13.75 800 320 320 653.0612244898 255890 -20
9 110 110 12.2222222222 12.2222222222 900 270 360 734.693877551 323890 -24
10 110 110 11 11 1000 220 400 816.3265306122 399890 -28
11 110 110 10 10 1100 170 440 897.9591836735 483890 -32
12 110 110 9.1666666667 9.1666666667 1200 120 480 979.5918367347 575890 -36
13 110 110 8.4615384615 8.4615384615 1300 70 520 1061.2244897959 675890 -40
14 110 110 7.8571428571 7.8571428571 1400 20 560 1142.8571428571 783890 -44
15 110 110 7.3333333333 7.3333333333 1500 -30 600 1224.4897959184 899890 -48
16 110 110 6.875 6.875 1600 -80 640 1306.1224489796 1023890 -52
17 110 110 6.4705882353 6.4705882353 1700 -130 680 1387.7551020408 1155890 -56
18 110 110 6.1111111111 6.1111111111 1800 -180 720 1469.387755102 1295890 -60