Chat with us, powered by LiveChat Business Report Presentation | acewriters
+1(978)310-4246 credencewriters@gmail.com
  

1)The first of objective of this week’s deliverable is to provide Robert M. Lopez with a business report presentation of your findings.Use the modified spreadsheet that you submitted in Module 04 for this deliverable.-ATTACHED Your report should visually identify:OutliersSales consultants trending towards noncomplianceUsing the Excel spreadsheet as input. Create a visual representation of the data. Use the visual representation of the data in a 2-3 slide PowerPoint of your findings.2) The second objective of this week’s deliverable is to provide Robert M. Lopez with an executive summary of your findings.In a 2 page paper, APA formatted with references and citations, summarize your findings. Give proof for your analysis. Within your paper, explain the process you did to come up with the findings. Based on the findings, provide business recommendations to Mr. Lopez.
_module_04__102717.xlsx

Unformatted Attachment Preview

Sales System Number
265801-2014111
265801-2014111
315320-2014111
265980-2014111
329247-2014111
399053-2014111
407197-2014111
407886-2014111
410718-2014111
265005-2014111
265288-2014111
265440-2014111
265778-2014111
265758-2014111
265068-2014111
265609-2014111
265862-2014111
266104-2014111
265823-2014111
330618-2014111
332509-2014111
333704-2014111
407148-2014111
265752-2014111
265848-2014111
266106-2014111
331393-2014111
Date of Sale
Extract Date
Sales Consultant ID
10/1/2014
11/1/2014
12658262
10/1/2014
11/1/2014
26150025
10/3/2014
11/1/2014
26152889
10/3/2014
11/1/2014
26161204
10/5/2014
11/1/2014
26325752
10/10/2014
11/1/2014
26354410
10/11/2014
11/1/2014
26354410
10/12/2014
11/1/2014
26356778
10/13/2014
11/1/2014
26457518
10/14/2014
11/1/2014
26520168
10/20/2014
11/1/2014
26526109
10/20/2014
11/1/2014
26621106
10/20/2014
11/1/2014
26621106
10/20/2014
11/1/2014
26621106
10/20/2014
11/1/2014
26621106
10/20/2014
11/1/2014
33011618
10/25/2014
11/1/2014
33135393
10/25/2014
11/1/2014
33233704
10/25/2014
11/1/2014
33255099
10/26/2014
11/1/2014
33407197
10/26/2014
11/1/2014
35353356
10/28/2014
11/1/2014
40278386
10/28/2014
11/1/2014
41107218
10/30/2014
11/1/2014
57575758
10/30/2014
11/1/2014
66464667
10/30/2014
11/1/2014
75265980
10/31/2014
11/1/2014
83748200
Territory
DOWNSTATE NEW YORK
DOWNSTATE NEW YORK
DOWNSTATE NEW YORK
DOWNSTATE NEW YORK
SOUTH FLORIDA
SOUTH FLORIDA
SOUTH FLORIDA
SOUTH FLORIDA
DOWNSTATE NEW YORK
DOWNSTATE NEW YORK
DOWNSTATE NEW YORK
ILLINOIS
LOUISIANA
LOUISIANA
KENTUCKY
KENTUCKY
DOWNSTATE NEW YORK
DOWNSTATE NEW YORK
ARKANSAS
DOWNSTATE NEW YORK
ARKANSAS
MISSISSIPPI
ARKANSAS
SOUTH FLORIDA
ATLANTA-NORTH GEORGIA
DOWNSTATE NEW YORK
SAN ANTONIO
Tax Type
W2
W2
W2
W2
1099
1099
1099
W2
W2
W2
W2
W2
W2
W2
1099
1099
1099
W2
1099
W2
1099
1099
1099
1099
W2
W2
1099
Total Contracts
9
13
4
13
5
0
7
1
9
10
25
1
10
7
1
9
0
16
0
10
1
11
3
11
4
4
0
184
October 2014
Total Sales
Total Cancellations
Total Contracts
$24,222.00
0
2
$0.00
13
5
$14,344.00
0
14
$72,990.00
0
4
$20,100.00
1
5
$0.00
0
5
$44,242.00
0
7
$555.00
0
1
$80,000.00
0
2
$45,000.00
0
2
$54,535.00
0
16
$6,566.00
0
1
$87,382.00
1
10
$35,000.00
0
2
$250.00
0
1
$21,222.00
0
7
$321.00
0
0
$50,000.00
1
9
$7,881.00
0
0
$30,291.00
1
3
$10,000.00
0
1
$83,641.00
5
4
$600.00
0
3
$92,829.00
1
11
$39,999.00
0
1
$44,255.00
2
4
$0.00
0
0
866225
25
120
November 2014
Total Sales
$211.00
$0.00
$1,000.00
$10,000.00
$20,000.00
$20,100.00
$500.00
$5,000.00
$1,010.00
$5,000.00
$20,000.00
$3,000.00
$87,382.00
$1,000.00
$900.00
$20,000.00
$0.00
$30,000.00
$0.00
$10,300.00
$10,000.00
$4,000.00
$0.00
$500.00
$550.00
$20,100.00
$0.00
270553
November 2014
Total Cancellations
0
5
13
0
0
1
0
0
0
0
0
0
1
0
0
0
0
1
0
0
0
0
0
10
0
1
0
32
Total Contracts
16
18
14
4
16
0
1
1
18
0
16
11
10
2
1
2
7
1
9
0
3
5
3
9
9
16
0
192
December 2014
Total Sales Total Cancellations
$20,000.00
0
$7,000.00
5
$1,000.00
13
$10,000.00
0
$20,000.00
0
$0.00
0
$500.00
0
$5,000.00
0
$7,000.00
10
$5,000.00
0
$20,000.00
0
$0.00
11
$0.00
10
$0.00
2
$1,000.00
0
$900.00
0
$20,000.00
0
$0.00
0
$30,000.00
1
$0.00
0
$10,300.00
0
$10,000.00
3
$4,000.00
0
$2,000.00
5
$7,000.00
3
$20,000.00
0
$0.00
0
200700
63
Total
Sales Consultant Cancellations
ID
in October
2014
12658262
0
26150025
13
26152889
0
26161204
0
26325752
1
26354410
0
26354410
0
26356778
0
26457518
0
26520168
0
26526109
0
26621106
0
26621106
1
26621106
0
26621106
0
33011618
0
33135393
0
33233704
1
33255099
0
33407197
1
35353356
0
40278386
5
41107218
0
57575758
1
66464667
0
75265980
2
83748200
0
Total
Total
Cancellations Cancellations
in November in December
2014
2014
0
0
5
5
13
13
0
0
0
0
1
0
0
0
0
0
0
10
0
0
0
0
0
11
1
10
0
2
0
0
0
0
0
0
1
0
0
1
0
0
0
0
0
3
0
0
10
5
0
3
1
0
0
0
Total Cancellations in October 20
5
13
5
13
0
13
0
0
Total Cancellations
Cancellations in October 2014
Total Cancellations in November 2014
Total Cancellations in December 2014
5
10
0
1
0
1
0
0
0
0
3
0
11
10
0
0
0
1
1
2
0
0
0
0
0
1
1
10
5
1
0
0
1
0
0
1
3
0
0
1
2
ecember 2014
0

Purchase answer to see full
attachment

error: Content is protected !!