Micro Econ for Expert_Julia

profilek.eali
group_5_diamonds_1.xlsx

Sheet1

Deliverable 1 and Deliverable 2
Production of diamonds per month Production of gold per month Market Price of a diamond (in KD) Quantity demanded per month (thousands) Quantity supplied per month (thousands) Quantity demanded per month (new) Quantity supplied per month (new)
A 0 12000 2425 7 1
B 1000 10000 2450 6 2
C 2000 8000 2475 5 3
D 3000 6000 2500 4 4
E 4000 4000 2525 3 5
F 5000 2000 2550 2 6
G 6000 0 2575 1 7
Final Deliverable (all values are in KD)
Quantity Price Total Revenue Fixed Cost Variable Cost Total Cost Average Fixed Cost Average Variable Cost Average Total Cost Marginal Revenue Marginal Cost Profit
0 10000 0 5000 0
10 9990 99900 75000
20 9980 199600 140000
30 9970 299100 220000
40 9960 398400 310000
50 9950 497500 409500
60 9940 596400 510000
70 9930 695100 620000
80 9920 793600 740000
90 9910 891900 870000

Sheet2

Sheet3