1. For this discussion, please describe geospatial analytics. What applications can benefit by using geospatial analytics? Discuss the value provided by geospatial analytics.
2. A. How do retailers use Geospatial Analysis?
Don't use plagiarized sources. Get Your Custom Essay on
predict Vs React
Just from $13/Page
2. B Comment on “Using Demographic Data to Analyze Price vs. Volume”
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 2 |
>October 2
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
| 4 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
| Sales Consultant ID |
|
|
|
|
|
|
| SC Last name |
|
|
|
| SC First Name |
|
|
| State |
|
|
| Tax Type |
|
|
|
| Total Contracts |
|
|
|
| Total Sales |
|
|
|
| Total Cancellations |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 3 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 5 |
353356
|
|
|
|
|
|
|
| Rucco |
|
|
|
|
| Adriano F |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| NY |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| W2 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 10 |
$30,2
|
|
|
|
|
|
|
|
|
|
|
|
|
| 9 |
1.00
1
| 6646466
|
|
|
|
|
|
|
|
|
| 7 |
|
|
|
|
|
|
|
| Wiare |
|
|
|
|
| Carol P. |
|
| GA |
W2 4
| $39,999.00 |
0
|
|
| 57575758 |
|
|
|
|
|
|
|
| Frank |
|
|
|
|
| Benjamin |
|
|
|
|
|
|
|
|
|
|
|
|
|
| FL |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 1099 |
|
|
|
|
|
|
|
|
| 11 |
| $92,829.00 |
1
|
|
| 75265980 |
|
|
|
|
|
|
|
| Manuter |
|
|
|
|
| Victor |
NY W2 4
$44,
|
| 25 |
5.00
2
|
|
| 83748200 |
|
|
|
|
|
|
|
| Travas |
|
|
|
|
| Francisco A |
|
| TX |
1099 0
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| $0.00 |
0
|
|
|
|
|
|
| 26354410 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Smith |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Debbie |
FL 1099 5
|
|
|
|
|
|
| $20,100.00 |
1
|
|
| 33407197 |
|
|
|
|
|
|
|
| Heston |
|
|
|
|
| Kelly L |
|
|
|
|
|
|
| AR |
1099 0
| $7,881.00 |
0
|
|
| 40278386 |
|
|
|
|
|
|
|
| Nova |
|
|
|
|
| Jeremy S |
AR 1099 1
|
|
|
|
|
|
|
|
|
|
|
|
| $10,000.00 |
0
|
|
| 411072
|
|
|
| 18 |
|
|
|
|
|
|
|
| Buster |
|
|
|
|
| Jacqueline M |
|
| MS |
1099 11
| $83,641.00 |
5
|
|
| 26150025 |
|
|
|
|
|
|
|
| Jones |
|
|
|
|
| Jennifer |
NY W2
|
|
|
|
|
|
|
|
| 13 |
$0.00 13
26354410 Smith Debbie FL 1099 0 $0.00 0
26354410 Smith Debbie FL 1099 7
| $44,
| 24 |
2.00
0
|
|
| 26356778 |
|
|
|
|
|
|
|
| Dimit |
|
|
|
|
| Enrique |
FL W2 1
| $555.00 |
0
|
|
| 26457518 |
|
|
|
|
|
|
|
| Hansen |
|
|
|
|
| Vanessa |
NY W2 9
| $80,000.00 |
0
| 26520
|
|
|
|
|
|
|
|
|
|
|
| 16 |
8
|
|
|
|
|
|
|
| Vega |
|
|
|
|
| William |
NY W2 10
| $45,000.00 |
0
|
|
| 26526109 |
|
|
|
|
|
|
|
| Periter |
|
|
|
|
| Eugene |
NY W2 25
| $54,535.00 |
0
|
|
| 12658262 |
|
|
|
|
|
|
|
| Wearever |
|
|
|
|
| Erick |
NY W2 9
| $24,222.00 |
0
|
|
| 26161204 |
|
|
|
|
|
|
|
| Uarlike |
|
|
|
|
| Yaniri A |
NY W2 4
$
|
|
|
| 14 |
,344.00
0
|
| 26531823 |
|
|
|
|
| Nayen |
|
|
| Alicia |
| IL |
W2 1
| $6,566.00 |
0
|
|
| 33011618 |
|
|
|
|
|
|
|
| Kite |
|
|
|
|
| David N |
|
|
|
|
| KY |
1099 1
| $250.00 |
0
|
|
| 33255099 |
|
|
|
|
|
|
|
| York |
|
|
|
|
| Alex V |
NY W2 16
| $50,000.00 |
1
|
|
| 33233704 |
|
|
|
|
|
|
|
| Amisher |
|
|
|
|
| Aisha T |
NY 1099 0
| $321.00 |
0
|
| 43207148 |
|
|
|
|
| Bush |
|
|
| Douglas B |
AR 1099 3
| $600.00 |
0
|
|
| 26325752 |
|
|
|
|
|
|
|
| Regan |
|
|
|
|
| Andres A |
NY W2 13
| $72,990.00 |
0
|
|
|
|
|
|
|
| 26621106 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Justin |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Micah Rae |
|
|
|
|
|
|
| LA |
W2 7
| $35,000.00 |
0
26621106 Justin Micah Rae LA W2 10
|
|
|
|
| $87,382.00 |
1
|
|
| 33135393 |
|
|
|
|
|
|
|
| Williams |
|
|
|
|
| Clarence P |
KY 1099 9
| $21,222.00 |
0
November 2014
Sales Consultant ID SC Last name SC First Name State Tax Type Total Contracts SC Last name Total Sales Total Cancellations
26354410 Smith Debbie FL 1099 5 Amisher $0.00 1
33407197 Heston Kelly L AR 1099 0 Bush $0.00 0
40278386 Nova Jeremy S AR 1099 1 Buster
|
|
|
|
|
| $4,000.00 |
0
41107218 Buster Jacqueline M MS 1099 4 Dimit
|
|
|
|
|
|
|
|
|
|
|
| $5,000.00 |
0
33011618 Kite David N KY 1099 1 Frank
|
|
|
|
|
|
|
|
| $500.00 |
0
33255099 York Alex V NY W2 9 Hansen
|
|
| $1,010.00 |
1
|
| 66464667 |
Wiare Carol P. GA W2 1 Heston $0.00 0
|
| 35353356 |
Rucco Adriano F NY W2 3 Jones $0.00 0
|
| 26520168 |
Vega William NY W2 2 Justin $87,382.00 0
|
| 26152889 |
Smith Debbie FL 1099 14 Justin
|
|
|
|
|
|
|
|
|
|
| $1,000.00 |
13
26356778 Dimit Enrique FL W2 1 Kite
|
|
|
|
|
| $900.00 |
0
26354410 Smith Debbie FL 1099 7 Manuter $20,100.00 0
26531823 Nayen Alicia IL W2 1 Nayen
|
|
| $3,000.00 |
0
33233704 Amisher Aisha T NY 1099 0 Nova $10,000.00 0
43207148 Bush Douglas B AR 1099 3 Periter
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| $20,000.00 |
0
26526109 Periter Eugene NY W2 16 Regan $20,000.00 0
26457518 Hansen Vanessa NY W2 2 Rucco
|
|
|
|
|
| $10,300.00 |
0
12658262 Wearever Erick NY W2 2 Smith $20,100.00 0
75265980 Manuter Victor NY W2 4 Smith $1,000.00 1
57575758 Frank Benjamin FL 1099 11 Smith $500.00 10
26161204 Uarlike Yaniri A NY W2 4 Travas $0.00 0
83748200 Travas Francisco A TX 1099 0 Uarlike $10,000.00 0
26621106 Justin Micah Rae LA W2 10 Vega $5,000.00 1
26150025 Jones Jennifer NY W2 5 Wearever
|
|
| $211.00 |
5
33135393 Williams Clarence P KY 1099 7 Wiare
|
|
| $550.00 |
0
26325752 Regan Andres A NY W2 5 Williams $20,000.00 0
26621106 Justin Micah Rae LA W2 2 York
|
|
|
|
|
| $30,000.00 |
0
December 2014
Sales Consultant ID SC Last name SC First Name State Tax Type Total Contracts SC Last name Total Sales Total Cancellations
26354410 Smith Debbie FL 1099 0 Amisher $0.00 0
40278386 Nova Jeremy S AR 1099 5 Buster $4,000.00 3
26621106 Justin Micah Rae LA W2 10 Dimit $5,000.00 10
66464667 Wiare Carol P. GA W2 9 Frank
|
|
| $2,000.00 |
3
41107218 Buster Jacqueline M MS 1099 3 Hansen
|
|
|
|
|
|
|
|
| $7,000.00 |
0
26354410 Smith Debbie FL 1099 1 Heston $0.00 0
57575758 Frank Benjamin FL 1099 9 Jones $7,000.00 5
26621106 Justin Micah Rae LA W2 1 Justin $0.00 0
83748200 Travas Francisco A TX 1099 0 Justin $1,000.00 0
26150025 Jones Jennifer NY W2 18 Justin $0.00 5
26152889 Smith Debbie FL 1099 14 Justin $0.00 13
26621106 Justin Micah Rae LA W2 11 Kite $900.00 11
26526109 Periter Eugene NY W2 16 Manuter $20,000.00 0
26161204 Uarlike Yaniri A NY W2 4 Nova $10,000.00 0
33255099 York Alex V NY W2 9 Periter $20,000.00 1
26520168 Vega William NY W2 0 Regan $20,000.00 0
35353356 Rucco Adriano F NY W2 3 Rucco $10,300.00 0
26457518 Hansen Vanessa NY W2 18 Smith $0.00 10
75265980 Manuter Victor NY W2 16 Smith $500.00 0
33407197 Heston Kelly L AR 1099 0 Smith $1,000.00 0
33011618 Kite David N KY 1099 2 Travas $0.00 0
26325752 Regan Andres A NY W2 16 Uarlike $10,000.00 0
26356778 Dimit Enrique FL W2 1 Vega $5,000.00 0
33135393 Williams Clarence P KY 1099 7 Wearever $20,000.00 0
33233704 Amisher Aisha T NY 1099 1 Wiare $7,000.00 0
26621106 Justin Micah Rae LA W2 2 Williams $20,000.00 2
12658262 Wearever Erick NY W2 16 York $30,000.00 0
Oct-Dec 2014
|
| Sales System Number |
| Date of Sale |
Month |
SC Last name SC First Name
| Office |
Total Contracts Total Sales Total Cancellations
315320-2014111 |
| 10/3/14 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 10/1/14 |
Amisher Aisha T
|
| BRONX |
0 $321.00 0
Outliers |
| 265980-2014111 |
10/3/14
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 11/1/14 |
Amisher Aisha T BRONX 0 $0.00 0
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 12/1/14 |
Amisher Aisha T BRONX 1 $0.00 0
10/1/14 Bush Douglas B
|
|
|
|
|
|
|
| Arkansas |
3 $600.00 0
Minimum Contracts Not Met |
Minimum Sales Requirement Not Met |
Maximum per Contract Exceeded |
11/1/14 Bush Douglas B Arkansas 3 $0.00 0 3 4 1
10/1/14 Buster Jacqueline M
|
|
| Tri-State |
11 $83,641.00 5
Aisha Amisher,
| Kelly Heston |
, Franciso Travas
Douglas Bush,
| David Kite |
,
Erick Wearever |
, Aisha Amisher
Victor Manuter |
11/1/14 Buster Jacqueline M Tri-State 4 $4,000.00 0 Kelly Heston David Kite
12/1/14 Buster Jacqueline M Tri-State 3 $4,000.00 0
| Francisco Travas |
Erick Wearever
|
| 265801-2014111 |
10/1/14 10/1/14 Dimit Enrique
|
|
|
|
|
|
|
|
|
|
|
|
|
| MIAMI |
1 $555.00 0
11/1/14 Dimit Enrique MIAMI 1 $5,000.00 0
| Incorrect Reporting practices |
265801-2014111 10/1/14 12/1/14 Dimit Enrique MIAMI 1 $5,000.00 0
10/1/14 Frank Benjamin MIAMI 11 $92,829.00 1
| Total Sales vs. Contracts |
Multiple sets of data reported |
High Cancellations |
| 399053-2014111 |
10/10/14 |
11/1/14 Frank Benjamin MIAMI 11 $500.00 10 3 2 5
12/1/14 Frank Benjamin MIAMI 9 $2,000.00 5
|
| Kelly Heston,
| Jennifer Jones |
,
William Vega |
| Micah Justin |
,
| Debbie Smith |
Jennifer Jones,
| Micah Justin, Debbie Smith |
, Benjamin Frank, Vanessa Hansen
10/1/14 Hansen Vanessa
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| MANHATTAN |
9 $80,000.00 0 Micah Justin
| 329247-2014111 |
10/5/14 |
11/1/14 Hansen Vanessa MANHATTAN 2 $1,010.00 0 Kelly Heston, Jennifer Jones, William Vega Micah Justin, Debbie Smith Debbie Smith
12/1/14 Hansen Vanessa MANHATTAN 18 $7,000.00 10 Jennifer Jones Debbie Smith
10/1/14 Heston Kelly L Arkansas 0 $7,881.00 0 William Vega
11/1/14 Heston Kelly L Arkansas 0 $0.00 0
12/1/14 Heston Kelly L Arkansas 0 $0.00 0
10/1/14 Jones Jennifer MANHATTAN 13 $0.00 13
| 407197-2014111 |
10/11/14 |
11/1/14 Jones Jennifer MANHATTAN 5 $0.00 5
| 407886-2014111 |
10/12/14 |
12/1/14 Jones Jennifer MANHATTAN 18 $7,000.00 5
Non-Compliant |
Compliant Consultants |
Trending towards non-compliance |
10/1/14 Justin Micah Rae
|
|
|
|
|
|
|
| NEW ORLEANS |
7 $35,000.00 0 10 24
10/1/14 Justin Micah Rae NEW ORLEANS 10 $87,382.00 1
11/1/14 Justin Micah Rae NEW ORLEANS 2 $1,000.00 0
11/1/14 Justin Micah Rae NEW ORLEANS 10 $87,382.00 1
12/1/14 Justin Micah Rae NEW ORLEANS 1 $1,000.00 0
12/1/14 Justin Micah Rae NEW ORLEANS 2 $0.00 2
12/1/14 Justin Micah Rae NEW ORLEANS 10 $0.00 10
12/1/14 Justin Micah Rae NEW ORLEANS 11 $0.00 11
| 410718-2014111 |
10/13/14 |
10/1/14 Kite David N
|
|
|
|
| LOUISVILLE |
1 $250.00 0
11/1/14 Kite David N LOUISVILLE 1 $900.00 0
12/1/14 Kite David N LOUISVILLE 2 $900.00 0
10/1/14 Manuter Victor MANHATTAN 4
| $44,255.00 |
2
11/1/14 Manuter Victor MANHATTAN 4 $20,100.00 1
12/1/14 Manuter Victor MANHATTAN 16 $20,000.00 0
10/1/14 Nayen Alicia
|
| CHICAGO |
1 $6,566.00 0
| 265005-2014111 |
10/14/14 |
11/1/14 Nayen Alicia CHICAGO 1 $3,000.00 0
10/1/14 Nova Jeremy S Arkansas 1 $10,000.00 0
| 265288-2014111 |
|
|
|
|
| 10/20/14 |
11/1/14 Nova Jeremy S Arkansas 1 $10,000.00 0
| 265440-2014111 |
10/20/14 12/1/14 Nova Jeremy S Arkansas 5 $10,000.00 3
10/1/14 Periter Eugene MANHATTAN 25 $54,535.00 0
11/1/14 Periter Eugene MANHATTAN 16 $20,000.00 0
12/1/14 Periter Eugene MANHATTAN 16 $20,000.00 0
| 265778-2014111 |
10/20/14 10/1/14 Regan Andres A MANHATTAN 13 $72,990.00 0
11/1/14 Regan Andres A MANHATTAN 5 $20,000.00 0
12/1/14 Regan Andres A MANHATTAN 16 $20,000.00 0
10/1/14 Rucco Adriano F MANHATTAN 10
| $30,291.00 |
1
11/1/14 Rucco Adriano F MANHATTAN 3 $10,300.00 0
| 265758-2014111 |
10/20/14 12/1/14 Rucco Adriano F MANHATTAN 3 $10,300.00 0
| 265068-2014111 |
10/20/14 10/1/14 Smith Debbie MIAMI 0 $0.00 0
10/1/14 Smith Debbie MIAMI 5 $20,100.00 1
10/1/14 Smith Debbie MIAMI 7
| $44,242.00 |
0
| 266104-2014111 |
|
| 10/25/14 |
11/1/14 Smith Debbie MIAMI 5 $20,100.00 1
| 265862-2014111 |
10/25/14 11/1/14 Smith Debbie MIAMI 7 $500.00 0
11/1/14 Smith Debbie MIAMI 14 $1,000.00 13
12/1/14 Smith Debbie MIAMI 0 $0.00 0
| 265609-2014111 |
10/20/14 12/1/14 Smith Debbie MIAMI 1 $500.00 0
12/1/14 Smith Debbie MIAMI 14 $1,000.00 13
| 332509-2014111 |
| 10/26/14 |
10/1/14 Travas Francisco A
|
| EL PASO |
0 $0.00 0
| 265823-2014111 |
10/25/14 11/1/14 Travas Francisco A EL PASO 0 $0.00 0
| 330618-2014111 |
10/26/14 12/1/14 Travas Francisco A EL PASO 0 $0.00 0
10/1/14 Uarlike Yaniri A MANHATTAN 4
| $14,344.00 |
0
11/1/14 Uarlike Yaniri A MANHATTAN 4 $10,000.00 0
12/1/14 Uarlike Yaniri A MANHATTAN 4 $10,000.00 0
| 407148-2014111 |
| 10/28/14 |
10/1/14 Vega William MANHATTAN 10 $45,000.00 0
| 333704-2014111 |
10/28/14 11/1/14 Vega William MANHATTAN 2 $5,000.00 0
| 265848-2014111 |
|
| 10/30/14 |
12/1/14 Vega William MANHATTAN 0 $5,000.00 0
| 265752-2014111 |
10/30/14 10/1/14 Wearever Erick MANHATTAN 9 $24,222.00 0
11/1/14 Wearever Erick MANHATTAN 2 $211.00 0
12/1/14 Wearever Erick MANHATTAN 16 $20,000.00 0
10/1/14 Wiare Carol P.
|
|
| ATLANTA |
4 $39,999.00 0
11/1/14 Wiare Carol P. ATLANTA 1 $550.00 0
12/1/14 Wiare Carol P. ATLANTA 9 $7,000.00 3
10/1/14 Williams Clarence P LOUISVILLE 9 $21,222.00 0
11/1/14 Williams Clarence P LOUISVILLE 7 $20,000.00 0
| 266106-2014111 |
10/30/14 12/1/14 Williams Clarence P LOUISVILLE 7 $20,000.00 0
10/1/14 York Alex V MANHATTAN 16 $50,000.00 1
11/1/14 York Alex V MANHATTAN 9 $30,000.00 1
| 331393-2014111 |
10/31/14 |
12/1/14 York Alex V MANHATTAN 9 $30,000.00 1
Outliers
[CELLRANGE], [VALUE]
[CELLRANGE], [VALUE]
[CELLRANGE], [VALUE]
Minimum Contracts Not Met Minimum Sales Requirement Not Met Maximum per Contract Exceeded 3 4 1 Aisha Amisher, Kelly Heston, Franciso Travas Douglas Bush, David Kite, Erick Wearever, Aisha Amisher Victor Manuter
Compliant vs. Non-Compliant Consultants
Non-Compliant Compliant Consultants 10 24
Total Sales vs. Contracts Multiple sets of data reported High Cancellations 3 2 5 Total Sales vs. Contracts Multiple sets of data reported High Cancellations 0 0 0
Module Explanation
| Columns to Keep |
| Reasons |
Sales Consultant ID
| Helps to separate the sales made by the same consultant on different dates. |
SC Last name
|
| Helps to identify the consultant |
SC First Name Helps to identify the consultant
Tax Type
| Helps to differentiate between consultants with employers and the self employed |
Total Contracts
| Helps to Identify the number of clients |
Total Sales
| Gives the amount of income for each consultants for contracts that were accepted |
Total Cancellations
| It is Subtracted from the total contracts to get the number of contracts accepted |
State
| Policy may vary from state to another |
| Column to delete |
Reasons
Sales System Number
| Does not affect the policy |
Date of Sale
| The month a sale occurred is sufficient |
| Extract Date |
Not useful at all |
Office
| Policy does not depend on the location |
| Region |
Policy does not depend on the regional location |
| Territory |
Policy does not depend on the territorial location |
modified data
SC Last name
| November Sales |
December Sales |
Amisher $0.00 $0.00
Bush $0.00 $4,000.00
Buster $4,000.00 $5,000.00
Dimit $5,000.00 $2,000.00
Frank $500.00 $7,000.00
Hansen $1,010.00 $0.00
Heston $0.00 $7,000.00
Jones $0.00 $0.00
Justin $87,382.00 $1,000.00
Justin $1,000.00 $0.00
Kite $900.00 $0.00
Manuter $20,100.00 $900.00
Nayen $3,000.00 $20,000.00
Nova $10,000.00 $10,000.00
Periter $20,000.00 $20,000.00
Regan $20,000.00 $20,000.00
Rucco $10,300.00 $10,300.00
Smith $20,100.00 $0.00
Smith $1,000.00 $500.00
Smith $500.00 $1,000.00
Travas $0.00 $0.00
Uarlike $10,000.00 $10,000.00
Vega $5,000.00 $5,000.00
Wearever $211.00 $20,000.00
Wiare $550.00 $7,000.00
Williams $20,000.00 $20,000.00
York $30,000.00 $30,000.00
November Sales Amisher Bush Buster Dimit Frank Hansen Heston Jones Justin Justin Kite Manuter Nayen Nova Periter Regan Rucco Smith Smith Smith Travas Uarlike Vega Wearever Wiare Williams York 0 0 4000 5000 500 1010 0 0 87382 1000 900 20100 3000 10000 20000 20000 10300 20100 1000 500 0 10000 5000 211 550 20000 30000 December Sales Amisher Bush Buster Dimit Frank Hansen Heston Jones Justin Justin Kite Manuter Nayen Nova Periter Regan Rucco Smith Smith Smith Travas Uarlike Vega Wearever Wiare Williams York 0 4000 5000 2000 7000 0 7000 0 1000 0 0 900 20000 10000 20000 20000 10300 0 500 1000 0 10000 5000 20000 7000 20000 30000
Business Report Presentation
Module 05 Project
OUTLIERS and Sales consultants trending towards noncompliance
This data is provided for sales and outliers consultants trending towards noncompliance. The orange line shows the number of contracts entered by sales consultants and blue line shows number of cancellation.
2
Total Contracts 265801-2014111 332509-2014111 266106-2014111 266106-2014111 410718-2014111 407886-2014111 16 16 16 16 10 11 Total Cancellations 265801-2014111 332509-2014111 266106-2014111 266106-2014111 410718-2014111 407886-2014111 0 0 0 0 10 11
Outliers
I this graph the outstanding performers were shown. All of the sales consultants id numbers are mentioned below and all of them have got 16 contracts without any red line which mean non of their contract is cancelled
3
Total Contracts 265801-2014111 332509-2014111 266106-2014111 266106-2014111 16 16 16 16 Total Cancellations 265801-2014111 332509-2014111 266106-2014111 266106-2014111 0 0 0 0
Sales consultants trending towards noncompliance
In this graph only the consultants with high cancellation rate are mentioned. All of the contracts entered into, were cancelled.
4
Total Contracts 410718-2014111 407886-2014111 10 11 Total Cancellations 410718-2014111 407886-2014111 10 11
