B Selling Price Type $ 157,500 Commercial $ 88,800 Commercial 67,875 Commercial $ 53,938 Commercial 2,989,500...

Transcribed Image Text:

B Selling Price Type $ 157,500 Commercial $ 88,800 Commercial 67,875 Commercial $ 53,938 Commercial 2,989,500 Commercial 2,027,375 Commercial 505,000 Commercial 242,500 Land 236,300 Commercial 127,250 Residential 108,125 Commercial 100,000 Land 98,750 Residential 64,400 Residential 62,719 Commercial 51,359 Commercial 44,258 Land $ $ 3,014,750 Commercial 717,000 Commercial 585,000 Commercial 288,422 Commercial 272,625 Land 204,469 Land 83,625 Residential 49,831 Commercial 47,500 Residential 536,844 Commercial 81,117 Commercial 50,158 Commercial 45,680 Land 41,875 Commercial 403,500 Commercial 368,938 Commercial 365,060 Land 287,000 Commercial 275,000 Residential Commercial 1 Month 2 October 3 January 4 November 5 November 6 October 7 November 8 January 9 January 10 January 11 October 12 November 13 October 14 November $ 15 January $ 16 November $ 17 December $ 18 January $ 19 October 34 November 35 October 36 January 37 October 38 December ssssssssss $ $ $ $ $ $ $ $ 20 January $ 21 October $ 22 December $ 23 November $ 24 December 25 November $ 26 December $ 27 November $ 28 December $ 29 January $ 30 December $ 31 January 32 December $ 33 October $ ՄԴ Դ Դ Դ Դ Դ ՄԴ $ 218,000 D Realtor David Pullen David Pullen David Pullen David Pullen David Willis David Willis David Willis David Willis David Willis David Willis David Willis David Willis David Willis David Willis David Willis David Willis David Willis Hal Keefer Hal Keefer Hal Keefer Hal Keefer Hal Keefer Hal Keefer Hal Keefer Hal Keefer Hal Keefer Jon Dolan Jon Dolan Jon Dolan Jon Dolan Jon Dolan Arturo James Arturo James Arturo James Arturo James Arturo James Arturo James E RealtorID F County 101 McDowell 101 Rutherford 101 Buncombe 101 Rutherford 102 Buncombe 102 Henderson 102 McDowell 102 McDowell 102 Polk 102 Polk 102 Buncombe 102 Polk 102 McDowell 102 Henderson 102 Buncombe 102 Polk 102 Henderson 103 Rutherford 103 Cleveland 103 Rutherford 103 Cleveland 103 Rutherford 103 Cleveland 103 Polk 103 McDowell 103 Cleveland 104 McDowell 104 Buncombe 104 Buncombe 104 Buncombe 104 Buncombe 105 Buncombe 105 McDowell 105 Rutherford 105 Buncombe 105 Henderson 105 Buncombe 39 October 40 November 41 January 42 December 43 January 44 January 45 December 46 January 47 October 62 January 63 December 64 January 65 January 66 October 67 November 68 November 69 November 70 November 71 January 72 January 73 December ssssssss 74 January 75 November 76 October $ $ $ $ $ $ $ 48 January $ 49 December $ 50 January $ 51 November $ 52 January 53 January 54 October 55 November 56 November 57 November 58 December 59 October 60 November 61 November $ $ ՄԴ Դ Դ Դ Դ Դ Դ Դ Դ Դ Դ Մ $ $ 43,750 Residential $ 445,000 Commercial $ ԱԴ Դ Դ Դ Դ Դ Դ Դ Դ Դ Դ Դ B $ $ с 214,500 Residential 98,156 Commercial 176,250 Commercial 118,650 Residential 60,559 Residential 59,663 Residential 50,279 Land $ $ 47,270 Commercial $ 2,671,500 Commercial 697,875 Commercial 202,530 Land 80,633 Commercial 79,325 Land 67,500 Residential 54,539 Land 66,000 Residential 57,031 Commercial 44,916 Residential 22,000 Land 950,000 Commercial 164,211 Commercial 151,500 Residential 102,105 Residential 60,316 Commercial 48,516 Residential 245,000 Commercial 70,000 Land 69,375 Residential 55,000 Commercial 50,906 Land 47,344 Land 354,600 Land 45,453 Residential $ 1,150,000 Residential $ 1,033,688 Land 221,750 Commercial D Arturo James Arturo James Arturo James Arturo James Arturo James Arturo James Marcus Jackson Marcus Jackson Marcus Jackson Marcus Jackson Marcus Jackson Marcus Jackson Marcus Jackson Megan Cooper Megan Cooper Megan Cooper Megan Cooper Megan Cooper Megan Cooper Megan Cooper Melanie Aaron Melanie Aaron Melanie Aaron Melanie Aaron Melanie Aaron Melanie Aaron Melanie Aaron Eun Jung Bae Eun Jung Bae Eun Jung Bae Eun Jung Bae Eun Jung Bae Eun Jung Bae Eun Jung Bae Eun Jung Bae Mitch Davis Mitch Davis Mitch Davis E F 105 McDowell 105 Buncombe 105 Buncombe 105 Buncombe 105 Henderson 105 Polk 106 Henderson 106 Buncombe 106 Cleveland 106 Rutherford 106 Polk 106 Buncombe 106 Polk 107 Buncombe 107 Buncombe 107 Rutherford 107 Polk 107 Henderson 107 Henderson 107 Buncombe 108 Rutherford 108 Cleveland 108 Polk 108 Buncombe 108 Buncombe 108 Rutherford 108 Buncombe 109 Henderson 109 Buncombe 109 Henderson 109 Cleveland 109 Cleveland 109 Polk 109 McDowell 109 Buncombe 110 Rutherford 110 Cleveland 110 Polk $ 221,750 Commercial $ 197,300 Residential 122,234 Residential 95,750 Residential 42,840 Commercial 312,500 Residential 163,500 Commercial 156,313 Commercial 130,875 Commercial 121,265 Residential 95,000 Land 85,438 Commercial 74,063 Commercial 69,078 Commercial Commercial 1,355,750 970,500 Commercial 505,250 Commercial 486,800 Commercial 76 October 77 October 78 December $ $ 79 October 80 January $ 81 October $ 82 January $ 83 November $ 84 November $ 85 November $ 86 January $ 87 November $ 88 November $ 89 December $ 90 October $ 91 October $ 92 October $ 93 January $ $ 94 January 95 January $ 96 November $ 97 November $ 98 November $ 99 January $ 100 December $ 138,150 Land 129,000 Residential 61,813 Residential 54,688 Commercial 46,969 Residential 41,420 Commercial 40,938 Land Mitch Davis Mitch Davis Mitch Davis Mitch Davis Mitch Davis Nicole Ashby Nicole Ashby Nicole Ashby Nicole Ashby Nicole Ashby Nicole Ashby Nicole Ashby Nicole Ashby Nicole Ashby Pete Jacobs Pete Jacobs Pete Jacobs Pete Jacobs Pete Jacobs Pete Jacobs Pete Jacobs Pete Jacobs Pete Jacobs Pete Jacobs Pete Jacobs 110 Polk 110 Henderson 110 Buncombe 110 Polk 110 Cleveland 111 McDowell 111 McDowell 111 Henderson 111 Buncombe 111 McDowell 111 Buncombe 111 Henderson 111 Buncombe 111 Polk 112 Cleveland 112 Buncombe 112 Cleveland 112 Polk 112 Cleveland 112 Buncombe 112 Buncombe 112 Polk 112 Rutherford 112 Polk 112 Henderson B Selling Price Type $ 157,500 Commercial $ 88,800 Commercial 67,875 Commercial $ 53,938 Commercial 2,989,500 Commercial 2,027,375 Commercial 505,000 Commercial 242,500 Land 236,300 Commercial 127,250 Residential 108,125 Commercial 100,000 Land 98,750 Residential 64,400 Residential 62,719 Commercial 51,359 Commercial 44,258 Land $ $ 3,014,750 Commercial 717,000 Commercial 585,000 Commercial 288,422 Commercial 272,625 Land 204,469 Land 83,625 Residential 49,831 Commercial 47,500 Residential 536,844 Commercial 81,117 Commercial 50,158 Commercial 45,680 Land 41,875 Commercial 403,500 Commercial 368,938 Commercial 365,060 Land 287,000 Commercial 275,000 Residential Commercial 1 Month 2 October 3 January 4 November 5 November 6 October 7 November 8 January 9 January 10 January 11 October 12 November 13 October 14 November $ 15 January $ 16 November $ 17 December $ 18 January $ 19 October 34 November 35 October 36 January 37 October 38 December ssssssssss $ $ $ $ $ $ $ $ 20 January $ 21 October $ 22 December $ 23 November $ 24 December 25 November $ 26 December $ 27 November $ 28 December $ 29 January $ 30 December $ 31 January 32 December $ 33 October $ ՄԴ Դ Դ Դ Դ Դ ՄԴ $ 218,000 D Realtor David Pullen David Pullen David Pullen David Pullen David Willis David Willis David Willis David Willis David Willis David Willis David Willis David Willis David Willis David Willis David Willis David Willis David Willis Hal Keefer Hal Keefer Hal Keefer Hal Keefer Hal Keefer Hal Keefer Hal Keefer Hal Keefer Hal Keefer Jon Dolan Jon Dolan Jon Dolan Jon Dolan Jon Dolan Arturo James Arturo James Arturo James Arturo James Arturo James Arturo James E RealtorID F County 101 McDowell 101 Rutherford 101 Buncombe 101 Rutherford 102 Buncombe 102 Henderson 102 McDowell 102 McDowell 102 Polk 102 Polk 102 Buncombe 102 Polk 102 McDowell 102 Henderson 102 Buncombe 102 Polk 102 Henderson 103 Rutherford 103 Cleveland 103 Rutherford 103 Cleveland 103 Rutherford 103 Cleveland 103 Polk 103 McDowell 103 Cleveland 104 McDowell 104 Buncombe 104 Buncombe 104 Buncombe 104 Buncombe 105 Buncombe 105 McDowell 105 Rutherford 105 Buncombe 105 Henderson 105 Buncombe 39 October 40 November 41 January 42 December 43 January 44 January 45 December 46 January 47 October 62 January 63 December 64 January 65 January 66 October 67 November 68 November 69 November 70 November 71 January 72 January 73 December ssssssss 74 January 75 November 76 October $ $ $ $ $ $ $ 48 January $ 49 December $ 50 January $ 51 November $ 52 January 53 January 54 October 55 November 56 November 57 November 58 December 59 October 60 November 61 November $ $ ՄԴ Դ Դ Դ Դ Դ Դ Դ Դ Դ Դ Մ $ $ 43,750 Residential $ 445,000 Commercial $ ԱԴ Դ Դ Դ Դ Դ Դ Դ Դ Դ Դ Դ B $ $ с 214,500 Residential 98,156 Commercial 176,250 Commercial 118,650 Residential 60,559 Residential 59,663 Residential 50,279 Land $ $ 47,270 Commercial $ 2,671,500 Commercial 697,875 Commercial 202,530 Land 80,633 Commercial 79,325 Land 67,500 Residential 54,539 Land 66,000 Residential 57,031 Commercial 44,916 Residential 22,000 Land 950,000 Commercial 164,211 Commercial 151,500 Residential 102,105 Residential 60,316 Commercial 48,516 Residential 245,000 Commercial 70,000 Land 69,375 Residential 55,000 Commercial 50,906 Land 47,344 Land 354,600 Land 45,453 Residential $ 1,150,000 Residential $ 1,033,688 Land 221,750 Commercial D Arturo James Arturo James Arturo James Arturo James Arturo James Arturo James Marcus Jackson Marcus Jackson Marcus Jackson Marcus Jackson Marcus Jackson Marcus Jackson Marcus Jackson Megan Cooper Megan Cooper Megan Cooper Megan Cooper Megan Cooper Megan Cooper Megan Cooper Melanie Aaron Melanie Aaron Melanie Aaron Melanie Aaron Melanie Aaron Melanie Aaron Melanie Aaron Eun Jung Bae Eun Jung Bae Eun Jung Bae Eun Jung Bae Eun Jung Bae Eun Jung Bae Eun Jung Bae Eun Jung Bae Mitch Davis Mitch Davis Mitch Davis E F 105 McDowell 105 Buncombe 105 Buncombe 105 Buncombe 105 Henderson 105 Polk 106 Henderson 106 Buncombe 106 Cleveland 106 Rutherford 106 Polk 106 Buncombe 106 Polk 107 Buncombe 107 Buncombe 107 Rutherford 107 Polk 107 Henderson 107 Henderson 107 Buncombe 108 Rutherford 108 Cleveland 108 Polk 108 Buncombe 108 Buncombe 108 Rutherford 108 Buncombe 109 Henderson 109 Buncombe 109 Henderson 109 Cleveland 109 Cleveland 109 Polk 109 McDowell 109 Buncombe 110 Rutherford 110 Cleveland 110 Polk $ 221,750 Commercial $ 197,300 Residential 122,234 Residential 95,750 Residential 42,840 Commercial 312,500 Residential 163,500 Commercial 156,313 Commercial 130,875 Commercial 121,265 Residential 95,000 Land 85,438 Commercial 74,063 Commercial 69,078 Commercial Commercial 1,355,750 970,500 Commercial 505,250 Commercial 486,800 Commercial 76 October 77 October 78 December $ $ 79 October 80 January $ 81 October $ 82 January $ 83 November $ 84 November $ 85 November $ 86 January $ 87 November $ 88 November $ 89 December $ 90 October $ 91 October $ 92 October $ 93 January $ $ 94 January 95 January $ 96 November $ 97 November $ 98 November $ 99 January $ 100 December $ 138,150 Land 129,000 Residential 61,813 Residential 54,688 Commercial 46,969 Residential 41,420 Commercial 40,938 Land Mitch Davis Mitch Davis Mitch Davis Mitch Davis Mitch Davis Nicole Ashby Nicole Ashby Nicole Ashby Nicole Ashby Nicole Ashby Nicole Ashby Nicole Ashby Nicole Ashby Nicole Ashby Pete Jacobs Pete Jacobs Pete Jacobs Pete Jacobs Pete Jacobs Pete Jacobs Pete Jacobs Pete Jacobs Pete Jacobs Pete Jacobs Pete Jacobs 110 Polk 110 Henderson 110 Buncombe 110 Polk 110 Cleveland 111 McDowell 111 McDowell 111 Henderson 111 Buncombe 111 McDowell 111 Buncombe 111 Henderson 111 Buncombe 111 Polk 112 Cleveland 112 Buncombe 112 Cleveland 112 Polk 112 Cleveland 112 Buncombe 112 Buncombe 112 Polk 112 Rutherford 112 Polk 112 Henderson

Answer rating: 100% (QA)

Answer a Using PivotTable calculate the cumulative sales for each realtor during the fourmon... View the full answer