BUSN 311 APUS Programming Statewide Landscape Design Excel Sheet

Report 1. Use The “CustData” Query to create a report that alphabetically lists all customers for Statewide. Include Customer ID, Last Name, First Name, customer type, contract type, & Contract number – Organize the report alphabetically by Customer name (Report Name – CustData)

Report 2. Use the “ContrTypeFinancials” Query to create a report that includes Customer ID, Contract number, Contract type, Contract amount, Contract profitability, Profit Generated – Organize the Report by contract type (All Landscape contracts first, then all Swimming Pool contracts following). Include an average contract amount, average contract profitability, and average Profit Generated at the end of each sub-group (Landscape and Swimming pool). What this provides is an analysis of the relative average contract amount, contract profitability and average profit generated during 2016 by type of contract (Landscaping and Swimming Pool installation) for the 2016 fiscal year (Report Name – ContrTypeFinancials)

Report 3. Use the “CustTypeFinancials” Query to create a report that includes Customer ID, Contract ID, Customer type (Commercial or Residential), Contract Amount ($), Contract Profitability (%), and profit Generated ($) – Organize the report by customer type (All Commercial first, then Residential). Include an average contract amount, average contract profitability, and average Profit Generated at the end of each sub-group (Commercial and Residential). What this provides is an analysis of the relative average contract amount, contract profitability and average profit generated during 2016 by type of customer (Commercial or Residential) for the 2016 fiscal year (Report Name – CustTypeFinancials)

Report 4. Modify the “2016 CustHistory” Query in order to create a report that includes Contract #, Customer Type, Repeat (yes or no), contract Amount ($) and Profit Generated ($) – Organize with “Yes Repeats” first, then “No Repeats” Insert a subtotal of Contract amount for the “Yes Repeat” sub-group and the “No Repeat” Subgroup. (Report Name – RepeatFinancials)

Report 5. Modify the “2016 CustHistory” Query in order to create a report that includes Contract #, Customer Type, Referral (yes or no), contract Amount ($) and Profit Generated ($) – Organize with “Yes Referrals” first, then “No Referrals” Insert a subtotal of the Contract amount for the “Yes Referral” sub-group and the “No Referral” Subgroup. (Report Name – ReferralFinancials).

Statewide Landscape Design, LLC – 2016 Data
Customer Id
Customer
Type
4213 Commercial
3181 Residential
2771 Residential
3317 Residential
8817 Commercial
2289 Residential
2608 Commercial
8861 Commercial
7983 Commercial
1385 Residential
3218 Commercial
3812 Residential
8921 Commercial
7136 Commercial
1557 Commercial
4246 Residential
8373 Residential
2729 Commercial
2953 Commercial
3975 Commercial
2418 Residential
8657 Residential
8074 Commercial
5762 Residential
1461 Commercial
2192 Residential
3596 Commercial
6010 Commercial
2223 Residential
7352 Commercial
8164 Commercial
Contract
Number
Contract
Type(Landscape
Profitablity or Swimming
Contract Amount $
%
Pool)
69511 $
57657 $
51752 $
11675 $
53121 $
64533 $
69840 $
52517 $
96790 $
37542 $
59438 $
85903 $
21124 $
77031 $
69989 $
49463 $
40957 $
11697 $
51071 $
40435 $
12964 $
49884 $
53073 $
49925 $
54852 $
15127 $
30361 $
89562 $
96519 $
55155 $
60129 $
15,224
2,827
13,837
10,079
17,463
9,705
20,059
24,387
7,658
1,746
20,558
21,536
13,904
6,812
7,076
9,206
11,724
8,958
13,987
22,345
10,958
20,366
11,314
23,833
5,008
12,823
20,954
17,451
18,895
8,315
11,372
21 Swimming pool
22 Landscaping
15 Swimming pool
0 Swimming pool
9 Swimming pool
14 Landscaping
0 Swimming pool
-1 Swimming pool
15 Landscaping
7 Landscaping
12 Swimming pool
1 Swimming pool
22 Swimming pool
24 Landscaping
4 Landscaping
11 Swimming pool
21 Swimming pool
4 landscaping
19 Swimming pool
18 Swimming pool
16 Swimming pool
0 Swimming pool
22 Swimming pool
21 Swimming pool
16 Landscaping
7 Swimming pool
21 Swimming pool
13 Swimming pool
16 Swimming pool
5 Landscaping
2 Swimming pool
4195 Residential
7074 Commercial
5186 Residential
1069 Commercial
8747 Residential
6301 Residential
8747 Residential
4745 Residential
6232 Commercial
6362 Commercial
8749 Commercial
5118 Commercial
1784 Commercial
6069 Commercial
7378 Commercial
5892 Commercial
7820 Residential
5795 Residential
8851 Commercial
3606 Commercial
7879 Commercial
1711 Commercial
4181 Residential
2044 Residential
4598 Residential
6685 Commercial
7383 Residential
2075 Residential
3741 Commercial
5733 Commercial
2272 Residential
6830 Residential
2933 Residential
8090 Commercial
4969 Commercial
1907 Residential
6299 Commercial
22484 $
65548 $
39367 $
27870 $
28737 $
67668 $
52229 $
49347 $
71427 $
32480 $
16135 $
32227 $
65437 $
30221 $
39739 $
47096 $
79305 $
42293 $
42111 $
24637 $
91597 $
79680 $
32055 $
58647 $
83260 $
81221 $
84321 $
23324 $
45449 $
82579 $
60190 $
62453 $
28662 $
17655 $
64311 $
85311 $
47313 $
4,965
12,344
9,514
15,681
1,858
17,104
11,435
3,072
20,897
7,696
7,252
5,006
16,444
10,793
10,920
10,342
1,721
22,589
17,710
12,683
22,985
4,026
23,212
11,329
17,085
13,747
23,911
18,253
20,316
2,124
5,524
9,770
16,587
9,014
17,386
4,670
14,147
-1 Landscaping
22 Swimming pool
25 Swimming pool
23 Swimming pool
12 Landscaping
20 Swimming pool
12 Swimming pool
16 Landscaping
33 Swimming pool
12 Landscaping
14 Landscaping
5 Landscaping
15 Swimming pool
13 Swimming pool
22 Swimming pool
16 Swimming pool
13 Landscaping
11 Swimming pool
12 Swimming pool
18 Swimming pool
22 Swimming pool
-3 Landscaping
1 Swimming pool
-2 Swimming pool
36 Swimming pool
11 Swimming pool
11 Swimming pool
23 Swimming pool
19 Swimming pool
-2 Landscaping
11 Landscaping
14 Landscaping
22 Swimming pool
18 Landscaping
29 Swimming pool
12 landscaping
15 Swimming pool
2571 Residential
3999 Commercial
5849 Residential
5786 Commercial
3752 Residential
3430 Commercial
5873 Residential
5233 Commercial
3836 Residential
5812 Commercial
6993 Residential
5464 Commercial
2448 Residential
7912 Commercial
5565 Residential
1425 Residential
8468 Residential
3729 Residential
1674 Residential
8034 Residential
7554 Residential
7276 Residential
6239 Commercial
7716 Commercial
4511 Commercial
2238 Commercial
8970 Commercial
3172 Residential
5983 Commercial
1524 Commercial
2155 Commercial
6948 Residential
4213 Residential
4207 Residential
7661 Residential
4603 Commercial
6625 Residential
69436 $
57987 $
54733 $
29846 $
66835 $
69884 $
42674 $
64943 $
32982 $
56565 $
48092 $
39323 $
16777 $
54539 $
74813 $
80905 $
71120 $
37631 $
60954 $
87032 $
57678 $
41972 $
18910 $
20280 $
26378 $
20667 $
92027 $
44665 $
45763 $
36929 $
45558 $
10958 $
20383 $
48029 $
23636 $
54927 $
85941 $
16,057
24,188
20,262
7,392
22,536
19,472
14,190
5,400
23,918
6,657
3,700
2,662
2,118
4,185
14,978
6,783
13,032
14,642
11,830
16,928
23,765
21,347
14,357
15,056
16,453
18,298
14,763
12,092
7,999
9,236
13,652
3,654
2,768
11,383
20,029
9,415
22,082
31 Swimming pool
34 Swimming pool
-2 Swimming pool
30 Landscaping
22 Swimming pool
15 Swimming pool
17 Swimming pool
25 Landscaping
14 Swimming pool
13 Landscaping
14 Landscaping
23 Landscaping
15 Landscaping
23 Landscaping
14 Swimming pool
22 Landscaping
26 Swimming pool
25 Swimming pool
25 Swimming pool
23 Swimming pool
12 Swimming pool
18 Swimming pool
17 Swimming pool
25 Swimming pool
31 Swimming pool
14 Swimming pool
17 Swimming pool
11 Swimming pool
12 Landscaping
17 Landscaping
22 Swimming pool
25 Landscaping
11 Landscaping
22 Swimming pool
14 Swimming pool
19 Landscaping
31 Swimming pool
8371 Residential
8795 Residential
2452 Residential
3125 Commercial
2928 Commercial
3676 Commercial
7818 Commercial
5566 Commercial
8054 Commercial
2135 Commercial
1753 Commercial
1638 Commercial
6464 Residential
2144 Residential
6657 Residential
3133 Commercial
5466 Residential
8070 Commercial
4742 Residential
8568 Commercial
2334 Residential
6009 Commercial
5711 Residential
8029 Commercial
1819 Residential
2889 Residential
2835 Commercial
7478 Residential
6030 Commercial
2510 Residential
6816 Commercial
6765 Residential
1838 Commercial
5924 Residential
7475 Commercial
1636 Residential
3043 Commercial
57439 $
39992 $
85802 $
73035 $
81103 $
51532 $
20314 $
14385 $
88904 $
13679 $
86960 $
34841 $
61848 $
32441 $
52440 $
21918 $
42475 $
63840 $
62764 $
82275 $
44481 $
90733 $
28275 $
88229 $
74003 $
66175 $
35663 $
84262 $
79720 $
66229 $
45849 $
13318 $
13605 $
92880 $
64821 $
72654 $
80814 $
20,708
12,705
7,064
20,044
6,964
13,568
5,943
20,220
22,743
5,088
17,603
7,525
14,672
6,487
13,846
17,918
15,499
5,294
2,535
19,101
7,442
16,136
9,419
4,447
13,152
4,519
11,745
4,906
19,729
3,767
9,884
14,991
13,353
6,890
8,670
19,856
24,127
25 Swimming pool
21 Swimming pool
32 Landscaping
8 Swimming pool
33 Landscaping
20 Swimming pool
16 Landscaping
18 Swimming pool
40 Swimming pool
16 Landscaping
12 Swimming pool
15 Landscaping
13 Swimming pool
19 Landscaping
24 Swimming pool
23 Swimming pool
22 Swimming pool
4 Landscaping
14 Landscaping
31 Swimming pool
16 Landscaping
24 Swimming pool
11 Landscaping
21 Landscaping
18 Swimming pool
24 Landscaping
26 Swimming pool
25 Landscaping
19 Swimming pool
19 Landscaping
18 Landscaping
18 Swimming pool
21 Swimming pool
15 Landscaping
22 Landscaping
12 Swimming pool
12 Swimming pool
5563 Residential
1833 Commercial
5815 Commercial
4549 Commercial
1538 Commercial
6248 Residential
6509 Residential
3256 Residential
4185 Residential
1362 Residential
3335 Commercial
3468 Commercial
8156 Commercial
5608 Commercial
2497 Commercial
8997 Residential
1325 Residential
82757 $
48059 $
79631 $
68011 $
64651 $
40261 $
96538 $
53584 $
74803 $
92935 $
85717 $
82171 $
85756 $
39875 $
40769 $
40900 $
69039 $
24,093
13,362
19,553
3,935
23,220
2,211
6,428
8,197
9,656
20,022
18,616
7,933
21,951
6,665
7,433
13,129
7,226
29 Swimming pool
26 Swimming pool
22 Swimming pool
23 Landscaping
16 Swimming pool
13 Landscaping
19 Landscaping
21 Landscaping
11 Landscaping
13 Swimming pool
15 Swimming pool
25 Landscaping
18 Swimming pool
11 Landscaping
41 Landscaping
13 Swimming pool
19 Landscaping
Data
Profit
Generated
Job
1
In this worksheet tab (Customer_Contract type & Instr),
– Profit generated by Contract (insert in Column G3 – G 1
– Calculate the average profit Generated for all contract
– Calculate the average contract amount for all contract
2
Copy all rows and columns “A” through “G” to The “Con
Calculate the average sales and proft for each contract t
3
Copy all rows columns A through G to the”Customer Typ
Calculate the average sales and profit by customer type
4
Build a pivot Table & Chart of average contract amount
5
Build a pivot Table & Chart of the average Profit by Cust
6
After analyzing the data in these two pivot-tables and ch
strategies going forward. Insert in the designated area t
7
Create a Histogram of the Contract Amounts. Insert belo
Instructions
er_Contract type & Instr), Calculate the following:
(insert in Column G3 – G 162)
Generated for all contracts (insert in G162)
ct amount for all contracts (insert in D162)
” through “G” to The “Contract Type” worksheet Tab and sort by Contract type
d proft for each contract type – insert into a table on that worksheet
gh G to the”Customer Type” Worksheet tab and sort by Customer type, then
d profit by customer type – insert into a table on that worksheet
average contract amount by Customer type (rows) and Contract type (Columns) With Average Contract amounts see area be
the average Profit by Customer type (rows) and Contract type (Columns) With Average Contract profits see area below
se two pivot-tables and charts, explain the findings and draw conclusions for
rt in the designated area to the left
tract Amounts. Insert below in the designated area
Insert Pivot Table and Pivot Chart from Job 4 below
Insert Pivot Table and Pivot Chart from Job 5 below
Insert Histogram from Job 7 below
Instructions
ksheet Tab and sort by Contract type
a table on that worksheet
tab and sort by Customer type, then
ble on that worksheet
pe (rows) and Contract type (Columns) With Average Contract amounts see area below
s) and Contract type (Columns) With Average Contract profits see area below
e findings and draw conclusions for
ble and Pivot Chart from Job 4 below
ble and Pivot Chart from Job 5 below
Histogram from Job 7 below
Data Analysis & Conclusions From Job 6
& Conclusions From Job 6
Customer Id
City
State
FirstName LastName
4213
3181
2771
3317
8817
2289
2608
8861
7983
1385
3218
3812
8921
7136
1557
4246
8373
2729
2953
3975
2418
8657
8074
5762
1461
2192
3596
6010
2223
7352
8164
4195
7074
5186
1069
Holland
Saint Joseph
Holland
South Haven
Battle Creek
Lansing
Holland
Grand Haven
Saugatuck
Lansing
Grand Rapids
Kalamazoo
Grand Rapids
Kalamazoo
South Haven
Saint Joseph
Holland
Holland
Battle Creek
Saugatuck
Grand Rapids
East Grand Rapids
Lansing
Holland
Saint Joseph
Grand Rapids
Grand Rapids
Saugatuck
Kalamazoo
Saint Joseph
Lansing
East Grand Rapids
Holland
East Lansing
Rockford
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
Owen
Hawes
Melissa Caputo
Amol
Mehta
John
Weiss
Harry
Billings
Karen
O’Brien
Devin
Finnerty
Kathy
Rowe
Pam
Wallner
Alex
Engber
Charles Nowak
Michael Ingram
Rachel
Kirk
James
Blackhawk
Olivia
Pappas
Claire
Boucher
Hwan
Tang
Taylor
Wilson
Steve
Gorski
Lisa
Hall
Matthew Fraser
Jerome Smith
Henry
Goldberg
Amber
Ward
Christina Garrett
Jessica
Ropiak
Michael Faraci
Vanetta Walker
Rodrigo Valencia
Connor Riley
An
Kim
Sarah
Russell
Jan
Van Dousen
John
Williams
Cathy
DeSantis
Work Phone
Number
(775) 509-6681
(355) 460-6363
(967) 639-7530
(296) 934-8995
(482) 511-6489
(286) 644-5624
(448) 773-1753
(573) 134-5412
(640) 633-0286
(625) 027-7929
(496) 600-1241
(721) 542-5183
(720) 060-8454
(465) 355-8109
(796) 406-5104
(514) 171-0121
(530) 209-1353
(314) 319-8321
(827) 484-4867
(222) 765-1192
(441) 468-1509
(766) 967-5518
(796) 345-3199
(375) 671-0277
(629) 865-7893
(632) 037-9948
(630) 605-9450
(565) 646-3772
(611) 916-3768
(916) 304-9441
(997) 694-5882
(517) 549-8165
(955) 211-7229
(859) 070-4987
(799) 873-2214
8747
6301
8747
4745
6232
6362
8749
5118
1784
6069
7378
5892
7820
5795
8851
3606
7879
1711
4181
2044
4598
6685
7383
2075
3741
5733
2272
6830
2933
8090
4969
1907
6299
2571
3999
5849
5786
South Haven
Grand Rapids
Grand Rapids
Holland
Lansing
Grand Rapids
Saint Joseph
Battle Creek
Lansing
Battle Creek
Grand Rapids
Saugatuck
Saint Joseph
Holland
Lansing
Grand Rapids
Kalamazoo
Saint Joseph
Battle Creek
Grand Rapids
Holland
Lansing
Saint Joseph
Saugatuck
Grand Rapids
Battle Creek
Kalamazoo
Saint Joseph
Holland
Lansing
Saugatuck
Grand Rapids
Holland
Saint Joseph
East Grand Rapids
Grand Rapids
Lansing
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
Edward Phillips
Nancy
Belanger
Sam
Kervin
John
Forsythe
Adam
West
Brent
Collier
Carl
Sagan
Amber
Rose
Alicia
Montgomery
Charlene North
Charles Darwin
David
Roth
Damion Wilson
Everet
Climber
Forrest Gump
Frank
Englebeck
Francis
DuPree
Francine Knight
Zendia
Sparkle
Yolanda Summer
Walter
Massingale
William Slye
Bill
Cosby
Gordon Wetworth
Geraldine Wilson
Lavender Odier
lamont Frankfurt
Mary
Martineque
Mark
Spitz
Ophelia Offen
Oliver
Holmes
Oscar
Soza
Ralph
Cramdon
Rudy
Julianie
Rachael McAdams
Sam
Spade
Suzi
Price
(963) 134-0645
(566) 243-0122
(347) 704-4090
(906) 110-0779
(417) 385-4745
(894) 298-5906
(767) 390-9532
(841) 423-7811
(311) 732-1415
(283) 372-0384
(832) 090-1119
(885) 426-6954
(725) 595-4716
(223) 966-1528
(471) 915-3618
(770) 682-6395
(572) 838-5753
(497) 749-7856
(486) 802-9158
(691) 903-5756
(977) 604-0240
(868) 752-9787
(227) 585-9339
(548) 957-5233
(558) 726-1581
(525) 893-9585
(345) 848-3103
(973) 432-6561
(394) 836-1027
(552) 348-5410
(952) 220-0612
(947) 888-8669
(641) 705-9198
(601) 485-4573
(840) 457-9138
(532) 719-0308
(602) 749-3475
3752
3430
5873
5233
3836
5812
6993
5464
2448
7912
5565
1425
8468
3729
1674
8034
7554
7276
6239
7716
4511
2238
8970
3172
5983
1524
2155
6948
4213
4207
7661
4603
6625
8371
8795
2452
3125
Holland
Battle Creek
Saint Joseph
Grand Rapids
Kalamazoo
Holland
Saint Joseph
Saugatuck
East Grand Rapids
Saint Joseph
Battle Creek
Battle Creek
Grand Rapids
Rockford
Lansing
East Grand Rapids
Saint Joseph
Kalamazoo
Lansing
Holland
Saint Joseph
Grand Rapids
Grand Rapids
Saugatuck
Lansing
Battle Creek
East Grand Rapids
Saint Joseph
Lansing
Rockford
Saugatuck
Saint Joseph
Holland
Grand Rapids
Battle Creek
Kalamazoo
Lansing
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
Thomas Adams
Theresa McBride
Tommy Alden
Polly
Cracker
Patrick
Swazey
Rudolph Raindeer
Randy
Everest
Gerald
Price
Karl
Quicken
Kris
Caltran
Breanna Cook
Marie
Smith
Frederick Thomas
Heather Locklear
Harry
Belafonte
Opera
Singer
Angelina Jolie
Brad
Pitt
Micky
Mouse
Donald Duck
Oscar
DELorentis
Rock
Hudson
Charleton Heston
Colin
Ferrell
Fred
Astaire
Porky
Pig
Kermit
Frog
Lyle
Levitt
Adam
Sandler
John
Wayne
Jerry
Jones
Jennifer Lopez
Ruth
Buzzy
Clifford Roland
David
Best
George Bush
Donald Trump
(245) 322-5666
(944) 271-5155
(309) 900-9827
(267) 650-5545
(935) 868-7820
(561) 553-1647
(443) 943-0879
(536) 779-4063
(685) 425-8127
(757) 730-0355
(654) 986-0102
(523) 630-1077
(315) 980-9436
(601) 022-9045
(447) 254-5688
(277) 707-5220
(570) 792-2677
(972) 556-2218
(978) 361-0253
(410) 394-2003
(476) 192-0198
(420) 997-1502
(968) 077-8123
(517) 834-2342
(437) 057-8146
(873) 096-9410
(374) 143-1567
(580) 956-3051
(800) 836-2566
(667) 468-5582
(372) 074-2191
(300) 303-9333
(659) 922-0281
(866) 872-5623
(456) 022-1282
(636) 132-7804
(478) 671-3364
2928
3676
7818
5566
8054
2135
1753
1638
6464
2144
6657
3133
5466
8070
4742
8568
2334
6009
5711
8029
1819
2889
2835
7478
6030
2510
6816
6765
1838
5924
7475
1636
3043
5563
1833
5815
4549
Grand Rapids
Holland
East Grand Rapids
Saint Joseph
Rockford
Lansing
Grand Rapids
Battle Creek
East Grand Rapids
Saint Joseph
Kalamazoo
Saugatuck
Saint Joseph
Battle Creek
Holland
Grand Rapids
Rockford
Saint Joseph
Rockford
Lansing
East Grand Rapids
Grand Rapids
Holland
Rockford
Battle Creek
East Grand Rapids
Grand Rapids
Rockford
Saint Joseph
Grand Rapids
Holland
Kalamazoo
Lansing
Lansing
Grand Rapids
Grand Rapids
Kalamazoo
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
Dennis
Day
Milton
Burle
Missy
Piggy
Adrian
Barbeau
May
West
Polly
Anna
Suzane Sommers
Don
Rickles
Don
Knots
Marsha Harwell
Frederick Chopin
Martin
King
Coretta King
Buster
Crab
Johnny Cash
Waylan Jennings
Peter
Frampton
Roger
Rabbit
Sam
Wise
Shelly
Winters
Terri
North
Victor
Record
Walter
Payton
Windy
Weather
Arti
Johnson
Roland
Martin
Bing
Crosby
Everet
Lloyd
Lloyd
Darnell
David
Williams
Scott
Kinkead
Steve
North
Gary
Nadolny
Harvey
Korman
Harry
Prince
Henrietta GoodGirl
Jenifer
Marshal
(602) 795-7220
(688) 830-7114
(996) 176-2971
(838) 762-9065
(859) 162-4979
(337) 516-6154
(586) 607-0362
(591) 371-9067
(964) 404-1180
(284) 355-8037
(982) 394-3175
(843) 331-8159
(866) 255-3204
(469) 857-4889
(781) 489-2870
(745) 635-5141
(812) 691-2056
(418) 666-3331
(461) 524-2931
(786) 819-3638
(480) 949-1687
(253) 471-9576
(760) 628-2793
(242) 664-4943
(362) 037-7962
(745) 948-9830
(630) 735-9524
(273) 630-3691
(802) 910-3687
(712) 358-7790
(397) 581-6704
(493) 758-0160
(637) 998-4153
(969) 435-2798
(579) 801-6285
(996) 620-1430
(964) 520-4420
1538
6248
6509
3256
4185
1362
3335
3468
8156
5608
2497
8997
Battle Creek
Saint Joseph
Holland
East Grand Rapids
Grand Rapids
Battle Creek
Saint Joseph
Holland
Kalamazoo
Grand Rapids
Lansing
Grand Rapids
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
Thurgood Marshal
Jimmy
Carter
Mary
Contrary
Bob
Gibbs
Doris
Darnell
Bon
Jovi
Artimes Gordon
Annette Funicello
Paulo
Gambino
Polly
Dent
Crest
Fallen
Jimmy
Fallon
1325
Saint Joseph
MI
Summer
Breeze
(979) 171-1289
(970) 047-4886
(580) 067-1786
(579) 888-5311
(989) 320-2795
(317) 109-4838
(447) 596-4425
(561) 762-1218
(504) 262-7737
(572) 511-6130
(282) 718-5063
(743) 352-4538
(516) 021-3967
Repeat Customer
(Yes or No)
Referrel
(Yes or No)
Yes
No
no
No
no
Yes
no
No
Yes
No
Yes
Yes
Yes
No
Yes
No
Yes
No
no
No
Yes
No
no
Yes
Yes
No
no
No
Yes
No
no
Yes
Yes
No
Yes
No
Yes
No
Yes
No
no
No
Yes
No
no
Yes
no
No
no
No
Yes
No
Yes
No
Yes
Yes
Yes
No
no
No
no
No
Yes
No
Yes
No
no
No
no
Yes
no
No
Yes
No
Yes
No
Yes
No
Yes
No
no
No
no
Yes
no
No
Yes
No
Yes
No
Yes
No
Yes
Yes
no
No
no
Yes
no
Yes
no
No
no
No
Yes
No
Yes
No
Yes
No
Yes
No
no
No
no
Yes
no
No
no
Yes
Yes
No
Yes
No
Yes
No
no
No
Yes
Yes
Yes
No
no
No
Yes
No
Yes
No
no
Yes
Yes
No
no
No
no
No
Yes
No
Yes
Yes
no
No
Yes
No
Yes
No
no
No
Yes
Yes
Yes
No
no
No
Yes
Yes
Yes
Yes
no
No
Yes
No
Yes
No
no
Yes
Yes
No
Yes
Yes
no
No
no
Yes
no
No
Yes
No
Yes
No
no
Yes
no
No
Yes
No
Yes
No
no
No
Yes
No
no
Yes
Yes
No
Yes
No
no
No
Yes
No
no
No
Yes
Yes
no
No
Yes
No
no
No
Yes
Yes
no
No
Yes
No
no
No
Yes
Yes
no
No
Yes
No
no
No
Yes
Yes
no
No
Yes
No
no
No
no
Yes
Yes
No
Yes
No
no
No
Yes
Yes
Yes
No
no
No
Yes
No
Yes
Yes
no
No
Yes
No
no
No
Yes
Yes
no
No
Yes
No
Yes
Yes
no
Yes
Yes
No
no
No
Yes
Yes
no
No
Yes
Yes
Yes
No
no
No
Yes
No
Yes
Yes
no
No
Yes
No
Yes
No
no
Yes
Yes
No
Yes
No
no
No
Yes
Yes
no
no
Yes
No
Insert Pivot Table from Job 2 Below
ow
Insert Pivot Table from Job 3 Below
ow