Assignment 1 additoonal doc

profileakrofi
assignment_1.xlsx

Option 1-solutions

Option#1 Qd Constant P A Px I M Solution
Est.Coeff. -5,200 -42 0.20 20 5.20 0.25
Var.Values 500 10,000 600 5,500 5,000
Qd= -5,200 -21,000 2,000 12,000 28,600 1,250 17,650
Qd= -5,200 -42P 43,850
Demand Function Qd= 38,650 -42P
Price Values= 38,650 -42 100 200 300 400 500 600
Qd= 17,650 34,450 30,250 26,050 21,850 17,650 13,450
Ed= -1.1898016997
Ea= 0.1133
Epx= 0.6799
Ei= 1.6204
Em= 0.0708
Qs= 5200 45P = Qd = 38650 -42P
Equilibrium= 87P = 33450
P = 384.48 cents
Qs = 5200 + 45P = 22502
Qd = 38650 -42P = 22502
Qeq = 22502 Peq= $ 3.8448 or 384.48cents
units per unit
Price Values= 100 200 300 400 500 600
Qd= 34,450 30,250 26,050 21,850 17,650 13,450
Qd= 38,650 -42
Qs= 5200 45
Qs= 9,700 14,200 18,700 23,200 27,700 32,200

Sheet1

Option#1 Qd Constant P A Px I M Solution
Est.Coeff. -5,200 -42 0.20 20 5.20 0.25
Var.Values 5 10,000 6 5,500 5,000
Qd= -5,200 -210 2,000 120 28,600 1,250 26,560
Qd= -5,200 -42P 31,970
Demand Function Qd= 26,770 -42P
Price Values= 38,650 -42 1 2 3 4 5 6
Qd= 38,440 38,608 38,566 38,524 38,482 38,440 38,398
Ed= -0.0054630593
Ea= 0.0520
Epx= 0.0031
Ei= 0.7440
Em= 0.0325
Qs= 5200 45P = Qd = 38650 -42P
Equilibrium= 87P = 33450
P = 384.48 cents
Qs = 5200 + 45P = 22502
Qd = 38650 -42P = 22502
Qeq = 22502 Peq= $ 3.8448 or 384.48cents
units per unit
Price Values= 100 200 300 400 500 600
Qd= 34,450 30,250 26,050 21,850 17,650 13,450
Qd= 38,650 -42
Qs= 5200 45
Qs= 9,700 14,200 18,700 23,200 27,700 32,200