ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
In Lusk's (2010) model, the change in egg demand associated with the publication of a given number of articles depends on the weekly expenditures on eggs for the location in question. To use the tool, make a copy of the spreadsheet and go to cell B4 and choose an estimated expenditure value for a sample city or input another number.
2
3
4
Input Change in Number of Articles1
5
Input Total Weekly Expenditures on EggsSan Francisco: 1300000
6
7
Change in egg demand also depends on the price elasticities of supply and demand for each type of egg. Carman (2012) suggests egg demand elasticity values between -0.2 and -0.1. However, Lusk (2010) finds that demand for cage-free, organic, and other eggs is much more elastic, with values from -1.07 to -2.979. Sumner et al. (2011) propose trying egg supply elasticity values between 5 and 10, though Chavas and Johnson (1981) estimate a much lower long-run supply elasticity of 0.942.
8
9
10
Cage-FreeOtherOrganicConventionalOverall
11
Input Price per Egg0.3140.2910.3780.211
12
Input Supply Elasticity7.57.57.57.5
13
Input Demand Elasticity-0.15-0.15-0.15-0.15
14
15
Initial Change in Quantity of Eggs Demanded2127.381196-563.58180211423.274327-4782.001443-1794.927722
16
Final Change in Quantity of Eggs Per Week2085.667839-552.53117861395.366987-4688.236709-1759.733061
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100