ID Address From To Emply Gender
55 12 72 37 23 f
28 9 28 13.9 4f
29 4 19 9.6 10 f
55 17 72 36.1 2f
21 2 20 9.6 0f
55 8 283 77.4 11 f
45 4 48 25 7f
32 0 28 14.2 2f
42 9 109 54 20 f
40 12 117 59.8 19 f
36 6 39 19.2 0f
26 6 28 14 1f
41 19 70 35.1 17 f
64 36 102 49 22 f
38 17 43 20.9 11 f
46 6 31 16.2 15 f
29 4 19 9.6 10 f
55 17 72 36.1 2f
21 2 20 9.6 0f
55 8 283 77.4 11 f
45 4 48 25 7f
32 0 28 14.2 2f
42 9 109 54 20 f
40 12 117 59.8 19 f
36 6 39 19.2 0f
56 29 153 76 35 m
24 4 26 13 0m
25 2 23 11.3 5m
45 9 76 37.3 13 m
44 17 144 72.1 23 m
46 20 75 37.1 29 m
41 10 26 13 8m
34 0 89 44.4 12 m
28 9 55 28.2 1m
35 8 70 35.4 9m
21 1 37 18.4 0m
42 13 53 25.9 6m
65 17 42 21.3 24 m
52 5 83 40.9 24 m
51 17 148 73.7 10 m
44 1 29 14.3 5m
49 11 40 20.1 8m
39 8 60 30.2 11 m
53 8 78 38.3 17 m
34 0 89 44.4 12 m
28 9 55 28.2 1m
35 8 70 35.4 9m
21 1 37 18.4 0m
42 13 53 25.9 6m
65 17 42 21.3 24 m
52 5 83 40.9 24 m
51 17 148 73.7 10 m
Fabrikam, Inc.
December Property Sales
Percentage Days on
Agent List Price Sale Price Difference
Difference Market
Richard Carey $ 290,000 $ 275,000 $ 15,000 5.2% 60
David Ortiz $ 129,000 $ 125,000 $ 4,000 3.1% 75
Kim Akers $ 225,000 $ 209,000 $ 16,000 7.1% 25
Nicole Carson $ 259,500 $ 258,000 $ 1,500 0.6% 39
Ryan Calafato $ 155,000 $ 145,700 $ 9,300 6.0% 75
David Ortiz $ 200,000 $ 189,500 $ 10,500 5.3% 45
Richard Carey $ 375,000 $ 359,500 $ 15,500 4.1% 90
Ryan Calafato $ 180,000 $ 175,000 $ 5,000 2.8% 45
Ryan Calafato $ 260,000 $ 250,000 $ 10,000 3.8% 65
Nicole Carson $ 200,000 $ 195,600 $ 4,400 2.2% 76
David Ortiz $ 205,000 $ 200,000 $ 5,000 2.4% 80
Kim Akers $ 315,000 $ 305,600 $ 9,400 3.0% 90
Total Sales $ 2,793,500 $ 2,687,900 $ 105,600
Sales by year
Year Total Sales
2014 800 20000
18000
2015 540
16000
2016 930
14000
2017 11600 12000
2018 13700 10000
2019 18400 8000
6000
4000
2000
0
2014 2015 2016 2017 2018 2019
year
Column J
2018 2019
Fourth Coffee: Annual Sales (in thousands)
Products 2014 2015 2016 2017 2018 Average
Coffee and Espresso $ 802 $ 950 $ 1,015 $ 1,050 $ 1,385 53.03%
Bakery $ 352 $ 325 $ 302 $ 250 $ 150 14.06%
Coffee Accessories $ 15 $ 75 $ 280 $ 402 $ 658 14.58%
Packaged Coffee/Tea $ 191 $ 190 $ 195 $ 198 $ 188 9.81%
Deli $ 215 $ 178 $ 52 $ 190 $ 202 8.53%
Total Sales $ 1,575 $ 1,718 $ 1,844 $ 2,090 $ 2,583
Fourth Coffee: Annual Sales
$1,300
$900
$500
$100
2014 2015 2016 2017 2018
Cof- $802 $950 $1,015 $1,050 $1,385
fee
and
Espre
sso
Bak- $352 $325 $302 $250 $150
ery
Cof- $15 $75 Year
$280 $402 $658
fee
Ac-
ces-
sorie
s
Pack $191 $190 $195 $198 $188
aged
Cof-
fee/
Tea
Deli $215 $178 $52 $190 $202
Coffee and
Bakery
Coffee Acc
Packaged
Deli
Coffee and Espresso
Bakery
Coffee Accessories
Packaged Coffee/Tea
Deli
