Date of Sale
Sales Consultant ID
10/1/2014
35353356
10/1/2014
66464667
10/3/2014
57575758
10/3/2014
75265980
10/5/2014
83748200
10/10/2014
26354410
10/11/2014
33407197
10/12/2014
40278386
10/13/2014
41107218
10/14/2014
26150025
10/20/2014
26354410
10/20/2014
26354410
10/20/2014
26356778
10/20/2014
26457518
10/20/2014
26520168
10/20/2014
26526109
10/25/2014
12658262
10/25/2014
26161204
10/25/2014
26531823
10/26/2014
33011618
10/26/2014
33255099
10/28/2014
33233704
10/28/2014
43207148
10/30/2014
26325752
10/30/2014
26621106
10/30/2014
26621106
10/31/2014
33135393
SC Last name
Rucco
Wiare
Frank
Manuter
Travas
Smith
Heston
Nova
Buster
Jones
Smith
Smith
Dimit
Hansen
Vega
Periter
Wearever
Uarlike
Nayen
Kite
York
Amisher
Bush
Regan
Justin
Justin
Williams
SC First Name
Adriano F
Carol P.
Benjamin
Victor
Francisco A
Debbie
Kelly L
Jeremy S
Jacqueline M
Jennifer
Debbie
Debbie
Enrique
Vanessa
William
Eugene
Erick
Yaniri A
Alicia
David N
Alex V
Aisha T
Douglas B
Andres A
Micah Rae
Micah Rae
Clarence P
State
NY
GA
FL
NY
TX
FL
AR
AR
MS
NY
FL
FL
FL
NY
NY
NY
NY
NY
IL
KY
NY
NY
AR
NY
LA
LA
KY
Office
MANHATTAN
ATLANTA
MIAMI
MANHATTAN
EL PASO
MIAMI
Arkansas
Arkansas
Tri-State
MANHATTAN
MIAMI
MIAMI
MIAMI
MANHATTAN
MANHATTAN
MANHATTAN
MANHATTAN
MANHATTAN
CHICAGO
LOUISVILLE
MANHATTAN
BRONX
Arkansas
MANHATTAN
NEW ORLEANS
NEW ORLEANS
LOUISVILLE
Region
NORTH
SOUTH
FL/HI
NORTH
SOUTH
FL/HI
SOUTHWEST
SOUTHWEST
SOUTHWEST
NORTH
FL/HI
FL/HI
FL/HI
NORTH
NORTH
NORTH
NORTH
NORTH
NORTH
SOUTH
NORTH
NORTH
SOUTHWEST
NORTH
SOUTH
SOUTH
SOUTH
Territory
Total Contracts
DOWNSTATE NEW YORK
ATLANTA-NORTH GEORGIA
SOUTH FLORIDA
DOWNSTATE NEW YORK
SAN ANTONIO
SOUTH FLORIDA
ARKANSAS
ARKANSAS
MISSISSIPPI
DOWNSTATE NEW YORK
SOUTH FLORIDA
SOUTH FLORIDA
SOUTH FLORIDA
DOWNSTATE NEW YORK
DOWNSTATE NEW YORK
DOWNSTATE NEW YORK
DOWNSTATE NEW YORK
DOWNSTATE NEW YORK
ILLINOIS
KENTUCKY
DOWNSTATE NEW YORK
DOWNSTATE NEW YORK
ARKANSAS
DOWNSTATE NEW YORK
LOUISIANA
LOUISIANA
KENTUCKY
10
4
11
4
0
5
0
1
11
13
0
7
1
9
10
25
9
4
1
1
16
0
3
13
7
10
9
Total Sales
Total Cancellations
$30,291.00
1
$39,999.00
0
$92,829.00
1
$44,255.00
2
$0.00
0
$20,100.00
1
$7,881.00
0
$10,000.00
0
$83,641.00
5
$0.00
13
$0.00
0
$44,242.00
0
$555.00
0
$80,000.00
0
$45,000.00
0
$54,535.00
0
$24,222.00
0
$14,344.00
0
$6,566.00
0
$250.00
0
$50,000.00
1
$321.00
0
$600.00
0
$72,990.00
0
$35,000.00
0
$87,382.00
1
$21,222.00
0
Date of Sale
Sales Consultant IDSC Last nameSC First Name
State
11/1/2014
26354410 Smith
Debbie
FL
11/2/2014
33407197 Heston
Kelly L
AR
11/2/2014
40278386 Nova
Jeremy S AR
11/2/2014
41107218 Buster
Jacqueline MMS
11/3/2014
33011618 Kite
David N
KY
11/4/2014
33255099 York
Alex V
NY
11/5/2014
66464667 Wiare
Carol P.
GA
11/5/2014
35353356 Rucco
Adriano F NY
11/5/2014
26520168 Vega
William
NY
11/5/2014
26152889 Smith
Debbie
FL
11/6/2014
26356778 Dimit
Enrique
FL
11/7/2014
26354410 Smith
Debbie
FL
11/8/2014
26531823 Nayen
Alicia
IL
11/10/2014
33233704 Amisher
Aisha T
NY
11/10/2014
43207148 Bush
Douglas B AR
11/11/2014
26526109 Periter
Eugene
NY
11/12/2014
26457518 Hansen
Vanessa
NY
11/13/2014
12658262 Wearever Erick
NY
11/15/2014
75265980 Manuter Victor
NY
11/16/2014
57575758 Frank
Benjamin FL
11/17/2014
26161204 Uarlike
Yaniri A
NY
11/23/2014
83748200 Travas
Francisco A TX
11/27/2014
26621106 Justin
Micah Rae LA
11/29/2014
26150025 Jones
Jennifer
NY
11/29/2014
33135393 Williams
Clarence P KY
11/30/2014
26325752 Regan
Andres A NY
11/30/2014
26621106 Justin
Micah Rae LA
Office
Region
Territory
MIAMI
FL/HI
SOUTH FLORIDA
Arkansas SOUTHWESTARKANSAS
Arkansas SOUTHWESTARKANSAS
Tri-State
SOUTHWESTMISSISSIPPI
LOUISVILLE SOUTH
KENTUCKY
MANHATTANNORTH
DOWNSTATE NEW YORK
ATLANTA SOUTH
ATLANTA-NORTH GEORGIA
MANHATTANNORTH
DOWNSTATE NEW YORK
MANHATTANNORTH
DOWNSTATE NEW YORK
MIAMI
FL/HI
SOUTH FLORIDA
MIAMI
FL/HI
SOUTH FLORIDA
MIAMI
FL/HI
SOUTH FLORIDA
CHICAGO NORTH
ILLINOIS
BRONX
NORTH
DOWNSTATE NEW YORK
Arkansas SOUTHWESTARKANSAS
MANHATTANNORTH
DOWNSTATE NEW YORK
MANHATTANNORTH
DOWNSTATE NEW YORK
MANHATTANNORTH
DOWNSTATE NEW YORK
MANHATTANNORTH
DOWNSTATE NEW YORK
MIAMI
FL/HI
SOUTH FLORIDA
MANHATTANNORTH
DOWNSTATE NEW YORK
EL PASO
SOUTH
SAN ANTONIO
NEW ORLEANS
SOUTH
LOUISIANA
MANHATTANNORTH
DOWNSTATE NEW YORK
LOUISVILLE SOUTH
KENTUCKY
MANHATTANNORTH
DOWNSTATE NEW YORK
NEW ORLEANS
SOUTH
LOUISIANA
Total Contracts
Total Sales
5
0
1
4
1
9
1
3
2
14
1
7
1
0
3
16
2
2
4
11
4
0
10
5
7
5
2
Total Cancellations
$20,100.00
$0.00
$10,000.00
$4,000.00
$900.00
$30,000.00
$550.00
$10,300.00
$5,000.00
$1,000.00
$5,000.00
$500.00
$3,000.00
$0.00
$0.00
$20,000.00
$1,010.00
$211.00
$20,100.00
$500.00
$10,000.00
$0.00
$87,382.00
$0.00
$20,000.00
$20,000.00
$1,000.00
1
0
0
0
0
1
0
0
0
13
0
0
0
0
0
0
0
0
1
10
0
0
1
5
0
0
0
Date of Sale
Sales Consultant IDSC Last name
12/1/2014
26354410 Smith
12/1/2014
40278386 Nova
12/1/2014
26621106 Justin
12/2/2014
66464667 Wiare
12/3/2014
41107218 Buster
12/3/2014
26354410 Smith
12/4/2014
57575758 Frank
12/5/2014
26621106 Justin
12/6/2014
83748200 Travas
12/6/2014
26150025 Jones
12/7/2014
26152889 Smith
12/8/2014
26621106 Justin
12/9/2014
26526109 Periter
12/9/2014
26161204 Uarlike
12/10/2014
33255099 York
12/11/2014
26520168 Vega
12/12/2014
35353356 Rucco
12/13/2014
26457518 Hansen
12/14/2014
75265980 Manuter
12/15/2014
33407197 Heston
12/19/2014
33011618 Kite
12/20/2014
26325752 Regan
12/21/2014
26356778 Dimit
12/22/2014
33135393 Williams
12/23/2014
33233704 Amisher
12/24/2014
26621106 Justin
12/30/2014
12658262 Wearever
SC First Name
Debbie
Jeremy S
Micah Rae
Carol P.
Jacqueline M
Debbie
Benjamin
Micah Rae
Francisco A
Jennifer
Debbie
Micah Rae
Eugene
Yaniri A
Alex V
William
Adriano F
Vanessa
Victor
Kelly L
David N
Andres A
Enrique
Clarence P
Aisha T
Micah Rae
Erick
State
FL
AR
LA
GA
MS
FL
FL
LA
TX
NY
FL
LA
NY
NY
NY
NY
NY
NY
NY
AR
KY
NY
FL
KY
NY
LA
NY
Office
MIAMI
Arkansas
NEW ORLEANS
ATLANTA
Tri-State
MIAMI
MIAMI
NEW ORLEANS
EL PASO
MANHATTAN
MIAMI
NEW ORLEANS
MANHATTAN
MANHATTAN
MANHATTAN
MANHATTAN
MANHATTAN
MANHATTAN
MANHATTAN
Arkansas
LOUISVILLE
MANHATTAN
MIAMI
LOUISVILLE
BRONX
NEW ORLEANS
MANHATTAN
Region
FL/HI
SOUTHWEST
SOUTH
SOUTH
SOUTHWEST
FL/HI
FL/HI
SOUTH
SOUTH
NORTH
FL/HI
SOUTH
NORTH
NORTH
NORTH
NORTH
NORTH
NORTH
NORTH
SOUTHWEST
SOUTH
NORTH
FL/HI
SOUTH
NORTH
SOUTH
NORTH
Territory
Total Contracts Total Sales
Total Cancellations
SOUTH FLORIDA
0
$0.00
0
ARKANSAS
5
$10,000.00
3
LOUISIANA
10
$0.00
10
ATLANTA-NORTH GEORGIA
9
$7,000.00
3
MISSISSIPPI
3
$4,000.00
0
SOUTH FLORIDA
1
$500.00
0
SOUTH FLORIDA
9
$2,000.00
5
LOUISIANA
1
$1,000.00
0
SAN ANTONIO
0
$0.00
0
DOWNSTATE NEW YORK
18
$7,000.00
5
SOUTH FLORIDA
14
$1,000.00
13
LOUISIANA
11
$0.00
11
DOWNSTATE NEW YORK
16
$20,000.00
0
DOWNSTATE NEW YORK
4
$10,000.00
0
DOWNSTATE NEW YORK
9
$30,000.00
1
DOWNSTATE NEW YORK
0
$5,000.00
0
DOWNSTATE NEW YORK
3
$10,300.00
0
DOWNSTATE NEW YORK
18
$7,000.00
10
DOWNSTATE NEW YORK
16
$20,000.00
0
ARKANSAS
0
$0.00
0
KENTUCKY
2
$900.00
0
DOWNSTATE NEW YORK
16
$20,000.00
0
SOUTH FLORIDA
1
$5,000.00
0
KENTUCKY
7
$20,000.00
0
DOWNSTATE NEW YORK
1
$0.00
0
LOUISIANA
2
$0.00
2
DOWNSTATE NEW YORK
16
$20,000.00
0
Deleted Columns
1. Sales system number.
2. Extract date.
3. Tax Type.
The columns will be deleted because analaysis on to be made on sales consultants will be done without using the
results.These fields will not be relevant when consultants information is not considered.
Remaining Columns
The remaining columns are related directly with the consultants in one way or another.These fields are important
data in terms of regions,consultant name,date of sale,total contratcs ,sales or even cancellations made.These data
sales consultants to maintain and others to do away with in regards to profitability of the business.
e done without using them and without affecting the final output
hese fields are important as they can be used in pivot tables in analysing
lations made.These data will be utilized in making decisions on which
business.
Date of Sale
Sales Consultant ID
10/1/2014
35353356
10/1/2014
66464667
10/3/2014
57575758
10/3/2014
75265980
10/5/2014
83748200
10/10/2014
26354410
10/11/2014
33407197
10/12/2014
40278386
10/13/2014
41107218
10/14/2014
26150025
10/20/2014
26354410
10/20/2014
26354410
10/20/2014
26356778
10/20/2014
26457518
10/20/2014
26520168
10/20/2014
26526109
10/25/2014
12658262
10/25/2014
26161204
10/25/2014
26531823
10/26/2014
33011618
10/26/2014
33255099
10/28/2014
33233704
10/28/2014
43207148
10/30/2014
26325752
10/30/2014
26621106
10/30/2014
26621106
10/31/2014
33135393
SC Last name
Rucco
Wiare
Frank
Manuter
Travas
Smith
Heston
Nova
Buster
Jones
Smith
Smith
Dimit
Hansen
Vega
Periter
Wearever
Uarlike
Nayen
Kite
York
Amisher
Bush
Regan
Justin
Justin
Williams
SC First Name
Adriano F
Carol P.
Benjamin
Victor
Francisco A
Debbie
Kelly L
Jeremy S
Jacqueline M
Jennifer
Debbie
Debbie
Enrique
Vanessa
William
Eugene
Erick
Yaniri A
Alicia
David N
Alex V
Aisha T
Douglas B
Andres A
Micah Rae
Micah Rae
Clarence P
State
NY
GA
FL
NY
TX
FL
AR
AR
MS
NY
FL
FL
FL
NY
NY
NY
NY
NY
IL
KY
NY
NY
AR
NY
LA
LA
KY
Office
MANHATTAN
ATLANTA
MIAMI
MANHATTAN
EL PASO
MIAMI
Arkansas
Arkansas
Tri-State
MANHATTAN
MIAMI
MIAMI
MIAMI
MANHATTAN
MANHATTAN
MANHATTAN
MANHATTAN
MANHATTAN
CHICAGO
LOUISVILLE
MANHATTAN
BRONX
Arkansas
MANHATTAN
NEW ORLEANS
NEW ORLEANS
LOUISVILLE
Region
NORTH
SOUTH
FL/HI
NORTH
SOUTH
FL/HI
SOUTHWEST
SOUTHWEST
SOUTHWEST
NORTH
FL/HI
FL/HI
FL/HI
NORTH
NORTH
NORTH
NORTH
NORTH
NORTH
SOUTH
NORTH
NORTH
SOUTHWEST
NORTH
SOUTH
SOUTH
SOUTH
Territory
Total Contracts
DOWNSTATE NEW YORK
ATLANTA-NORTH GEORGIA
SOUTH FLORIDA
DOWNSTATE NEW YORK
SAN ANTONIO
SOUTH FLORIDA
ARKANSAS
ARKANSAS
MISSISSIPPI
DOWNSTATE NEW YORK
SOUTH FLORIDA
SOUTH FLORIDA
SOUTH FLORIDA
DOWNSTATE NEW YORK
DOWNSTATE NEW YORK
DOWNSTATE NEW YORK
DOWNSTATE NEW YORK
DOWNSTATE NEW YORK
ILLINOIS
KENTUCKY
DOWNSTATE NEW YORK
DOWNSTATE NEW YORK
ARKANSAS
DOWNSTATE NEW YORK
LOUISIANA
LOUISIANA
KENTUCKY
10
4
11
4
0
5
0
1
11
13
0
7
1
9
10
25
9
4
1
1
16
0
3
13
7
10
9
Total Sales
Total Cancellations
$30,291.00
1
$39,999.00
0
$92,829.00
1
$44,255.00
2
$0.00
0
$20,100.00
1
$7,881.00
0
$10,000.00
0
$83,641.00
5
$0.00
13
$0.00
0
$44,242.00
0
$555.00
0
$80,000.00
0
$45,000.00
0
$54,535.00
0
$24,222.00
0
$14,344.00
0
$6,566.00
0
$250.00
0
$50,000.00
1
$321.00
0
$600.00
0
$72,990.00
0
$35,000.00
0
$87,382.00
1
$21,222.00
0
Date of Sale
Sales Consultant IDSC Last nameSC First Name
State
11/1/2014
26354410 Smith
Debbie
FL
11/2/2014
33407197 Heston
Kelly L
AR
11/2/2014
40278386 Nova
Jeremy S AR
11/2/2014
41107218 Buster
Jacqueline MMS
11/3/2014
33011618 Kite
David N
KY
11/4/2014
33255099 York
Alex V
NY
11/5/2014
66464667 Wiare
Carol P.
GA
11/5/2014
35353356 Rucco
Adriano F NY
11/5/2014
26520168 Vega
William
NY
11/5/2014
26152889 Smith
Debbie
FL
11/6/2014
26356778 Dimit
Enrique
FL
11/7/2014
26354410 Smith
Debbie
FL
11/8/2014
26531823 Nayen
Alicia
IL
11/10/2014
33233704 Amisher
Aisha T
NY
11/10/2014
43207148 Bush
Douglas B AR
11/11/2014
26526109 Periter
Eugene
NY
11/12/2014
26457518 Hansen
Vanessa
NY
11/13/2014
12658262 Wearever Erick
NY
11/15/2014
75265980 Manuter Victor
NY
11/16/2014
57575758 Frank
Benjamin FL
11/17/2014
26161204 Uarlike
Yaniri A
NY
11/23/2014
83748200 Travas
Francisco A TX
11/27/2014
26621106 Justin
Micah Rae LA
11/29/2014
26150025 Jones
Jennifer
NY
11/29/2014
33135393 Williams
Clarence P KY
11/30/2014
26325752 Regan
Andres A NY
11/30/2014
26621106 Justin
Micah Rae LA
Office
Region
Territory
MIAMI
FL/HI
SOUTH FLORIDA
Arkansas SOUTHWESTARKANSAS
Arkansas SOUTHWESTARKANSAS
Tri-State
SOUTHWESTMISSISSIPPI
LOUISVILLE SOUTH
KENTUCKY
MANHATTANNORTH
DOWNSTATE NEW YORK
ATLANTA SOUTH
ATLANTA-NORTH GEORGIA
MANHATTANNORTH
DOWNSTATE NEW YORK
MANHATTANNORTH
DOWNSTATE NEW YORK
MIAMI
FL/HI
SOUTH FLORIDA
MIAMI
FL/HI
SOUTH FLORIDA
MIAMI
FL/HI
SOUTH FLORIDA
CHICAGO NORTH
ILLINOIS
BRONX
NORTH
DOWNSTATE NEW YORK
Arkansas SOUTHWESTARKANSAS
MANHATTANNORTH
DOWNSTATE NEW YORK
MANHATTANNORTH
DOWNSTATE NEW YORK
MANHATTANNORTH
DOWNSTATE NEW YORK
MANHATTANNORTH
DOWNSTATE NEW YORK
MIAMI
FL/HI
SOUTH FLORIDA
MANHATTANNORTH
DOWNSTATE NEW YORK
EL PASO
SOUTH
SAN ANTONIO
NEW ORLEANS
SOUTH
LOUISIANA
MANHATTANNORTH
DOWNSTATE NEW YORK
LOUISVILLE SOUTH
KENTUCKY
MANHATTANNORTH
DOWNSTATE NEW YORK
NEW ORLEANS
SOUTH
LOUISIANA
Total Contracts
Total Sales
5
0
1
4
1
9
1
3
2
14
1
7
1
0
3
16
2
2
4
11
4
0
10
5
7
5
2
Total Cancellations
$20,100.00
$0.00
$10,000.00
$4,000.00
$900.00
$30,000.00
$550.00
$10,300.00
$5,000.00
$1,000.00
$5,000.00
$500.00
$3,000.00
$0.00
$0.00
$20,000.00
$1,010.00
$211.00
$20,100.00
$500.00
$10,000.00
$0.00
$87,382.00
$0.00
$20,000.00
$20,000.00
$1,000.00
1
0
0
0
0
1
0
0
0
13
0
0
0
0
0
0
0
0
1
10
0
0
1
5
0
0
0
Date of Sale
Sales Consultant IDSC Last name
12/1/2014
26354410 Smith
12/1/2014
40278386 Nova
12/1/2014
26621106 Justin
12/2/2014
66464667 Wiare
12/3/2014
41107218 Buster
12/3/2014
26354410 Smith
12/4/2014
57575758 Frank
12/5/2014
26621106 Justin
12/6/2014
83748200 Travas
12/6/2014
26150025 Jones
12/7/2014
26152889 Smith
12/8/2014
26621106 Justin
12/9/2014
26526109 Periter
12/9/2014
26161204 Uarlike
12/10/2014
33255099 York
12/11/2014
26520168 Vega
12/12/2014
35353356 Rucco
12/13/2014
26457518 Hansen
12/14/2014
75265980 Manuter
12/15/2014
33407197 Heston
12/19/2014
33011618 Kite
12/20/2014
26325752 Regan
12/21/2014
26356778 Dimit
12/22/2014
33135393 Williams
12/23/2014
33233704 Amisher
12/24/2014
26621106 Justin
12/30/2014
12658262 Wearever
SC First Name
Debbie
Jeremy S
Micah Rae
Carol P.
Jacqueline M
Debbie
Benjamin
Micah Rae
Francisco A
Jennifer
Debbie
Micah Rae
Eugene
Yaniri A
Alex V
William
Adriano F
Vanessa
Victor
Kelly L
David N
Andres A
Enrique
Clarence P
Aisha T
Micah Rae
Erick
State
FL
AR
LA
GA
MS
FL
FL
LA
TX
NY
FL
LA
NY
NY
NY
NY
NY
NY
NY
AR
KY
NY
FL
KY
NY
LA
NY
Office
MIAMI
Arkansas
NEW ORLEANS
ATLANTA
Tri-State
MIAMI
MIAMI
NEW ORLEANS
EL PASO
MANHATTAN
MIAMI
NEW ORLEANS
MANHATTAN
MANHATTAN
MANHATTAN
MANHATTAN
MANHATTAN
MANHATTAN
MANHATTAN
Arkansas
LOUISVILLE
MANHATTAN
MIAMI
LOUISVILLE
BRONX
NEW ORLEANS
MANHATTAN
Region
FL/HI
SOUTHWEST
SOUTH
SOUTH
SOUTHWEST
FL/HI
FL/HI
SOUTH
SOUTH
NORTH
FL/HI
SOUTH
NORTH
NORTH
NORTH
NORTH
NORTH
NORTH
NORTH
SOUTHWEST
SOUTH
NORTH
FL/HI
SOUTH
NORTH
SOUTH
NORTH
Territory
Total Contracts Total Sales
Total Cancellations
SOUTH FLORIDA
0
$0.00
0
ARKANSAS
5
$10,000.00
3
LOUISIANA
10
$0.00
10
ATLANTA-NORTH GEORGIA
9
$7,000.00
3
MISSISSIPPI
3
$4,000.00
0
SOUTH FLORIDA
1
$500.00
0
SOUTH FLORIDA
9
$2,000.00
5
LOUISIANA
1
$1,000.00
0
SAN ANTONIO
0
$0.00
0
DOWNSTATE NEW YORK
18
$7,000.00
5
SOUTH FLORIDA
14
$1,000.00
13
LOUISIANA
11
$0.00
11
DOWNSTATE NEW YORK
16
$20,000.00
0
DOWNSTATE NEW YORK
4
$10,000.00
0
DOWNSTATE NEW YORK
9
$30,000.00
1
DOWNSTATE NEW YORK
0
$5,000.00
0
DOWNSTATE NEW YORK
3
$10,300.00
0
DOWNSTATE NEW YORK
18
$7,000.00
10
DOWNSTATE NEW YORK
16
$20,000.00
0
ARKANSAS
0
$0.00
0
KENTUCKY
2
$900.00
0
DOWNSTATE NEW YORK
16
$20,000.00
0
SOUTH FLORIDA
1
$5,000.00
0
KENTUCKY
7
$20,000.00
0
DOWNSTATE NEW YORK
1
$0.00
0
LOUISIANA
2
$0.00
2
DOWNSTATE NEW YORK
16
$20,000.00
0
Deleted Columns
1. Sales system number.
2. Extract date.
3. Tax Type.
The columns will be deleted because analaysis on to be made on sales consultants will be done without using the
results.These fields will not be relevant when consultants information is not considered.
Remaining Columns
The remaining columns are related directly with the consultants in one way or another.These fields are important
data in terms of regions,consultant name,date of sale,total contratcs ,sales or even cancellations made.These data
sales consultants to maintain and others to do away with in regards to profitability of the business.
e done without using them and without affecting the final output
hese fields are important as they can be used in pivot tables in analysing
lations made.These data will be utilized in making decisions on which
business.
Running head: SALES CONSULTANTS’ DATA ANALYSIS
1
Sales Consultants’ Data Analysis
Desmond Fulton
Rasmussen College
Author Note
This paper is being submitted on December 1 ,2019 for Sarah Dixon Introduction to Business
Analysis and Intelligence
SALES CONSULTANTS’ DATA ANALYSIS
2
Sales Consultants’ Data Analysis
The collected information during the whole period signified the following impressions:
There was a general decrease in the total sales made by the sales consultants. In October the
personnel achieved their highest sales which then gradually reduced in November and further
went down in December.
The total number of cancellations shifted upwards irregularly. In October, the total writeoffs totaled to 25; in November, the number rose to 32, and by December, it was 63. However,
the maximum number of cancellations a single consultant recorded in a month at 13. Out of the
three months, FL/HI region had the highest number of cancellations twice i.e., in November and
December.
The highest number of contracts always came from the North region. The sales consultant
who still managed this was Periter Eugene.
At least three or more Sales consultants failed to make any sales for a month. In October, they
were three, five in November and seven in December. The total number kept rising with time.
Travis Francisco A from San Antonio, Heston Kelly L from Arkansas, and Amisher
Aisha T from Downstate were consultants who showed a lack of emphasis on compliance
(Gebelein, 1989). As consultants, their duty is to champion the products and services of the
company by corresponding them to consumers’ wants (Homburg and Giering, 2001). They are
charged with the responsibility of ensuring the company remains sustainable and competitive in
the market (Furnham and Fudge, 2008). The three of them failed to achieve any sales for at least
SALES CONSULTANTS’ DATA ANALYSIS
two consecutive months. They exhibited poor skills in attaining goals and creating new
opportunities.
References
Furnham, A., & Fudge, C. (2008). The five-factor model of personality and sales performance.
Journal of Individual Differences, 29(1), 11-16.
Gebelein, S. H. (1989). Profile of an internal consultant: roles and skills for building client
confidence. Training & Development Journal, 43(3), 52-59.
Homburg, C., & Giering, A. (2001). Personal characteristics as moderators of the relationship
between customer satisfaction and loyalty—an empirical analysis. Psychology &
Marketing, 18(1), 43-66.
3
Purchase answer to see full
attachment