predict Vs React

BeBe1985
BusinessReportPresentationExcel.xlsx
Home>Business & Finance homework help>predict Vs React

October 2014

Sales Consultant ID SC Last name SC First Name State Tax Type Total Contracts Total Sales Total Cancellations
35353356 Rucco Adriano F NY W2 10 $30,291.00 1
66464667 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,255.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
41107218 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,242.00 0
26356778 Dimit Enrique FL W2 1 $555.00 0
26457518 Hansen Vanessa NY W2 9 $80,000.00 0
26520168 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