Description
If you're really good at excel this shouldn't be hard. Ill send you my saved excel sheet, whereI have done 1st step of the work. You just have to continue with the instructions and complete the following Excel Sheet. I've uploaded all the instructions and the excel sheet.
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Sorry for late response. I'm through with the work. Uploading in a moment.
Attached.
1
Sales Code
MGR
AM
PT
SP
SA
SC
2
Sales Titles
Manager
Assistance Manager
sales Assistance
sales partner
Sales associate
Sales Consultant
3
4
5
Hourl Wage
Hourly Quota
Commision Rate
$25.50
$300.00
5.25%
$22.50
$240.00
4.20%
$11.50
$120.00
2.63%
$16.00
$120.00
2.63%
$13.50
$180.00
3.94%
$18.00
$210.00
3.15%
Sales Code
MGR
AM
PT
SP
SA
SC
Sales Titles
Manager
Assistance Manager
sales Assistance
sales partner
Sales associate
Sales Consultant
Hourl Wage
25.5
22.5
11.5
16
13.5
18
Hourly Quota
Commision Rate
$375.00
7.88%
$300.00
6.30%
$150.00
3.95%
$150.00
3.95%
$225.00
5.91%
$262.50
4.73%
Associate
Macro
Brick
Blake
Boles
Bourque
Craddock
Crane
Crouse
Deyoe
Duarte
Dubben
Duck
Student
Film
Freeman
Gauger
Harp
Hauch
Henning
Hornback
Huang
Hughes
Hulsman
Jwang
Ketty
Lax
Len
Lessert
Mall
Mazza
McMath
Monac
Montague
Nigel
Pike
Plumber
Pomales
Pomura
Porterfield
Reyes
Rodman
Roselius
Sales
Code
AM
PT
SA
SA
AM
PT
SC
SP
PT
SC
PT
SA
MGR
SP
SP
PT
SC
PT
SP
AM
PT
SC
SP
AM
PT
SP
SP
SA
SC
AM
PT
SP
SP
SA
SA
PT
SP
SC
SP
AM
PT
SA
Category
Specialty
Specialty
Accessories
Tools & Shop
Fluids
Replacement parts
Performance
Performance
Specialty
Performance
Accessories
Performance
Replacement parts
Accessories
Tools & Shop
Clearance
Replacement parts
Replacement parts
Accessories
Tools & Shop
Replacement parts
Accessories
Performance
Clearance
Performance
Tools & Shop
Fluids
Fluids
Tools & Shop
Replacement parts
Tools & Shop
Specialty
Specialty
Fluids
Specialty
Clearance
Fluids
Fluids
Replacement parts
Performance
Specialty
Fluids
Store
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Sales
$ 4,500.00
$ 10,065.23
$
456.76
$
450.98
$
650.75
$
250.78
$ 1,500.00
$
$
500.00
$ 1,502.98
$
$
873.08
$ 4,500.67
$
356.26
$ 1,500.25
$
250.00
$ 1,469.78
$ 7,502.03
$
$
890.47
$
$ 1,000.00
$ 1,100.00
$ 1,202.02
$
199.99
$
802.46
$
50.00
$ 1,502.96
$
$ 2,500.00
$
$ 2,200.00
$
$
196.89
$
$
250.75
$
850.63
$
251.36
$
$ 3,399.00
$ 1,546.78
$ 1,908.00
Hours
Worked
8
8
2.5
3
6
4
4
0
4
4
0
5
5
7.5
5
4
5
2
0
8
0
5
6
12
4
8
8
4
0
12
0
5
0
1
0
2
6.5
3
0
12
8
8
Base Pay
$ 180.00
$ 92.00
$ 33.75
$ 40.50
$ 135.00
$ 46.00
$ 72.00
$
$ 46.00
$ 72.00
$
$ 67.50
$ 127.50
$ 120.00
$ 80.00
$ 46.00
$ 90.00
$ 23.00
$
$ 180.00
$
$ 90.00
$ 96.00
$ 270.00
$ 46.00
$ 128.00
$ 128.00
$ 54.00
$
$ 270.00
$
$ 80.00
$
$ 13.50
$
$ 23.00
$ 104.00
$ 54.00
$
$ 270.00
$ 92.00
$ 108.00
Ruaz
Schoemann
Stanton
Stephens
Stone
Vandrey
Walker
Watts
Wilson
Zeon
Argentine
Box
Bing
Bolyard
Bourque
Crad
Cronk
Course
Keyoe
Muarte
Gibb
Lucky
Sims
Fiddes
Beeman
Auger
Harpole
Linch
Ben
Hornel
Hall
Huxly
Hull
Wang
Ketakea
Ladder
Lenfestey
Less
Mallouf
Mass
Math
Manny
Montty
North
Picazo
Plumbtree
Pom
SA
SA
SP
PT
AM
SA
SA
SP
SP
SC
AM
PT
SA
SA
AM
PT
SC
SP
SC
SA
PT
SA
MGR
SP
SP
SC
PT
SC
SP
AM
PT
PT
SP
AM
PT
SP
SC
SA
SC
AM
PT
SP
SP
SA
SA
PT
SA
Specialty
Clearance
Clearance
Clearance
Accessories
Clearance
Specialty
Clearance
Replacement parts
Accessories
Specialty
Specialty
Accessories
Tools & Shop
Fluids
Replacement parts
Performance
Performance
Specialty
Performance
Accessories
Performance
Replacement parts
Accessories
Tools & Shop
Clearance
Replacement parts
Replacement parts
Accessories
Tools & Shop
Replacement parts
Accessories
Performance
Clearance
Performance
Tools & Shop
Fluids
Fluids
Tools & Shop
Replacement parts
Tools & Shop
Specialty
Specialty
Fluids
Specialty
Clearance
Fluids
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
2,159.69
821.36
345.96
1,766.00
234.45
2,225.00
3,500.00
10,065.23
456.76
450.98
650.75
250.78
1,500.00
500.00
1,402.98
873.08
4,500.67
356.26
1,500.25
250.00
1,469.78
7,502.03
890.47
-
12
0
7
2
10
0
0
6.5
0
8
7
7
4.5
4
5
3
3
0
3
3
0
4
4
6.5
4
5
4
3
0
9
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
162.00
112.00
23.00
225.00
104.00
144.00
157.50
80.50
60.75
54.00
112.50
34.50
54.00
54.00
40.50
54.00
102.00
104.00
64.00
90.00
46.00
54.00
202.50
-
Pommy
Porter
Ray
Rodden
Rose
Rual
Schmidt
Stanly
Steph
Stonebull
Vandyke
Walk
Water
Wilow
Yule
Total
Average
Minimum
Maximum
PT
SC
AM
SC
PT
SA
SA
SP
PT
AM
SA
SA
SA
SP
SC
Fluids
Replacement parts
Performance
Specialty
Fluids
Specialty
Clearance
Clearance
Clearance
Accessories
Clearance
Specialty
Clearance
Replacement parts
Accessories
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
99,853.34
99,853.34
99,853.34
99,853.34
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
314.00
314.00
314.00
314.00
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
-
$ 5,412.50
$ 5,412.50
$ 5,412.50
$ 5,412.50
Hourly
Quota
240
120
180
180
240
120
210
120
120
210
120
180
300
120
120
120
210
120
120
240
120
210
120
240
120
120
120
180
210
240
120
120
120
180
180
120
120
210
120
240
120
180
Quote*HrsWorked
1920
960
450
540
1440
480
840
0
480
840
0
900
1500
900
600
480
1050
240
0
1920
0
1050
720
2880
480
960
960
720
0
2880
0
600
0
180
0
240
780
630
0
2880
960
1440
Commission Max-Sales-forStep-CalcRate
commission
Commission
$
0.0420
2580.00
$
0.0263
9105.23
$
0.0394
6.76
$
0.0394
-89.02
$
0.0420
-789.25
$
0.0263
-229.22
$
0.0315
660.00
$
0.0263
0.00
$
0.0263
20.00
$
0.0315
662.98
$
0.0263
0.00
$
0.0394
-26.92
$
0.0525
3000.67
$
0.0263
-543.74
$
0.0263
900.25
$
0.0263
-230.00
$
0.0315
419.78
$
0.0263
7262.03
$
0.0263
0.00
$
0.0420
-1029.53
$
0.0263
0.00
$
0.0315
-50.00
$
0.0263
380.00
$
0.0420
-1677.98
$
0.0263
-280.01
$
0.0263
-157.54
$
0.0263
-910.00
$
0.0394
782.96
$
0.0315
0.00
$
0.0420
-380.00
$
0.0263
0.00
$
0.0263
1600.00
$
0.0263
0.00
$
0.0394
16.89
$
0.0394
0.00
$
0.0263
10.75
$
0.0263
70.63
$
0.0315
-378.64
$
0.0263
0.00
$
0.0420
519.00
$
0.0263
586.78
$
0.0394
468.00
108.36
239.47
0.27
0.00
0.00
0.00
20.79
0.00
0.53
20.88
0.00
0.00
157.54
0.00
23.68
0.00
13.22
190.99
0.00
0.00
0.00
0.00
9.99
0.00
0.00
0.00
0.00
30.85
0.00
0.00
0.00
42.08
0.00
0.67
0.00
0.28
1.86
0.00
0.00
21.80
15.43
18.44
Nested Calc
Commission
$
108.36
$
239.47
$
0.27
$
$
$
$
20.79
$
$
0.53
$
20.88
$
$
$
157.54
$
$
23.68
$
$
13.22
$
190.99
$
$
$
$
$
9.99
$
$
$
$
$
30.85
$
$
$
$
42.08
$
$
0.67
$
$
0.28
$
1.86
$
$
$
21.80
$
15.43
$
18.44
180
180
120
120
240
180
180
120
120
210
240
120
180
180
240
120
210
120
210
180
120
180
300
120
120
210
120
210
120
240
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
2160
0
840
240
2400
0
0
780
0
1680
1680
840
810
720
1200
360
630
0
630
540
0
720
1200
780
480
1050
480
630
0
2160
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
0.0394
0.0394
0.0263
0.0263
0.0420
0.0394
0.0394
0.0263
0.0263
0.0315
0.0420
0.0263
0.0394
0.0394
0.0420
0.0263
0.0315
0.0263
0.0315
0.0394
0.0263
0.0394
0.0525
0.0263
0.0263
0.0315
0.0263
0.0315
0.0263
0.0420
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
-0.31
0.00
-18.64
105.96
-634.00
0.00
0.00
-545.55
0.00
545.00
1820.00
9225.23
-353.24
-269.02
-549.25
-109.22
870.00
0.00
-130.00
862.98
0.00
153.08
3300.67
-423.74
1020.25
-800.00
989.78
6872.03
0.00
-1269.53
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0.00
0.00
0.00
2.79
0.00
0.00
0.00
0.00
0.00
17.17
76.44
242.62
0.00
0.00
0.00
0.00
27.41
0.00
0.00
34.00
0.00
6.03
173.29
0.00
26.83
0.00
26.03
216.47
0.00
0.00
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
2.79
17.17
76.44
242.62
27.41
34.00
6.03
173.29
26.83
26.03
216.47
-
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
12,090.00
12,090.00
12,090.00
12,090.00
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
56,910.00
56,910.00
56,910.00
56,910.00
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
2.36
2.36
2.36
2.36
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
42,943.34
42,943.34
42,943.34
42,943.34
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1,766.19
1,766.19
1,766.19
1,766.19
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
1,766.19
1,766.19
1,766.19
1,766.19
Wages to Sales
Ratio
6.41%
3.29%
7.45%
8.98%
20.75%
18.34%
6.19%
9.31%
6.18%
7.73%
6.33%
33.68%
6.91%
18.40%
7.02%
2.85%
20.21%
9.00%
9.64%
22.46%
23.00%
15.95%
256.00%
5.65%
10.80%
5.55%
7.19%
9.29%
12.44%
21.48%
8.58%
6.95%
6.63%
Gross Pay
$
288.36
$
331.47
$
34.02
$
40.50
$
135.00
$
46.00
$
92.79
$
$
46.53
$
92.88
$
$
67.50
$
285.04
$
120.00
$
103.68
$
46.00
$
103.22
$
213.99
$
$
180.00
$
$
90.00
$
105.99
$
270.00
$
46.00
$
128.00
$
128.00
$
84.85
$
$
270.00
$
$
122.08
$
$
14.17
$
$
23.28
$
105.86
$
54.00
$
$
291.80
$
107.43
$
126.44
Days
Worked
Quota
Met
1
1
1
1
1
1
1
0
1
1
0
1
1
1
1
1
1
1
0
1
0
1
1
1
1
1
1
1
0
1
0
1
0
1
0
1
1
1
0
1
1
1
1
1
1
0
0
0
1
0
1
1
0
0
1
0
1
0
1
1
0
0
0
0
1
0
0
0
0
1
0
0
0
1
0
1
0
1
1
0
0
1
1
1
Proposed Proposed
Proposed
Hourly
Commission
Nested Calc
Quota
Rate
Commission
$ 300.00
0.0630
132.30
$ 150.00
0.0395
349.73
$ 225.00
0.0591
$ 225.00
0.0591
$ 300.00
0.0630
$ 150.00
0.0395
$ 262.50
0.0473
21.26
$ 150.00
0.0395
$ 150.00
0.0395
$ 262.50
0.0473
21.40
$ 150.00
0.0395
$ 225.00
0.0591
$ 375.00
0.0788
206.77
$ 150.00
0.0395
$ 150.00
0.0395
29.60
$ 150.00
0.0395
$ 262.50
0.0473
7.43
$ 150.00
0.0395
284.12
$ 150.00
0.0395
$ 300.00
0.0630
$ 150.00
0.0395
$ 262.50
0.0473
$ 150.00
0.0395
7.89
$ 300.00
0.0630
$ 150.00
0.0395
$ 150.00
0.0395
$ 150.00
0.0395
$ 225.00
0.0591
35.63
$ 262.50
0.0473
$ 300.00
0.0630
$ 150.00
0.0395
$ 150.00
0.0395
57.20
$ 150.00
0.0395
$ 225.00
0.0591
$ 225.00
0.0591
$ 150.00
0.0395
$ 150.00
0.0395
$ 262.50
0.0473
$ 150.00
0.0395
$ 300.00
0.0630
$ 150.00
0.0395
13.68
$ 225.00
0.0591
6.38
7.50% $
$
13.64% $
7.45% $
12.74% $
$
$
44.36% $
$
7.24% $
6.68% $
3.21% $
13.30% $
11.97% $
17.29% $
13.76% $
5.43% $
$
10.80% $
5.31% $
$
6.88% $
6.12% $
29.19% $
6.05% $
36.00% $
4.90% $
3.61% $
$
22.74% $
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
162.00
112.00
25.79
225.00
104.00
161.17
233.94
323.12
60.75
54.00
112.50
34.50
81.41
54.00
74.50
60.03
275.29
104.00
90.83
90.00
72.03
270.47
202.50
-
1
0
1
1
1
0
0
1
0
1
1
1
1
1
1
1
1
0
1
1
0
1
1
1
1
1
1
1
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
1
1
1
0
0
0
0
1
0
0
1
0
1
1
0
1
0
1
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
225.00
225.00
150.00
150.00
300.00
225.00
225.00
150.00
150.00
262.50
300.00
150.00
225.00
225.00
300.00
150.00
262.50
150.00
262.50
225.00
150.00
225.00
375.00
150.00
150.00
262.50
150.00
262.50
150.00
300.00
150.00
150.00
150.00
300.00
150.00
150.00
262.50
225.00
262.50
300.00
150.00
150.00
150.00
225.00
225.00
150.00
225.00
0.0591
0.0591
0.0395
0.0395
0.0630
0.0591
0.0591
0.0395
0.0395
0.0473
0.0630
0.0395
0.0591
0.0591
0.0630
0.0395
0.0473
0.0395
0.0473
0.0591
0.0395
0.0591
0.0788
0.0395
0.0395
0.0473
0.0395
0.0473
0.0395
0.0630
0.0395
0.0395
0.0395
0.0630
0.0395
0.0395
0.0473
0.0591
0.0473
0.0630
0.0395
0.0395
0.0395
0.0591
0.0591
0.0395
0.0591
1.81
5.91
88.20
355.65
33.67
43.02
236.30
35.51
34.31
317.26
-
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
7,178.69
7,178.69
7,178.69
7,178.69
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
150.00
262.50
300.00
262.50
150.00
225.00
225.00
150.00
150.00
300.00
225.00
225.00
225.00
150.00
262.50
0.0395
0.0473
0.0630
0.0473
0.0395
0.0591
0.0591
0.0395
0.0395
0.0630
0.0591
0.0591
0.0591
0.0395
0.0473
-
Differences
Between
Commissions
23.94
110.27
(0.27)
0.47
(0.53)
0.52
49.24
5.92
(5.79)
93.13
(2.10)
4.79
15.12
(0.67)
(0.28)
(1.86)
(21.80)
(1.75)
(12.06)
(0.97)
(11.26)
11.76
113.03
6.26
9.02
(6.03)
63.02
8.68
8.28
100.79
-
-
Associate
Macro
Brick
Blake
Boles
Bourque
Craddock
Crane
Crouse
Deyoe
Duarte
Dubben
Duck
Student
Film
Freeman
Gauger
Harp
Hauch
Henning
Hornback
Huang
Hughes
Hulsman
Jwang
Ketty
Lax
Len
Lessert
Mall
Mazza
McMath
Monac
Montague
Nigel
Pike
Plumber
Pomales
Pomura
Porterfield
Reyes
Rodman
Roselius
Sales
Code
AM
PT
SA
SA
AM
PT
SC
SP
PT
SC
PT
SA
MGR
SP
SP
PT
SC
PT
SP
AM
PT
SC
SP
AM
PT
SP
SP
SA
SC
AM
PT
SP
SP
SA
SA
PT
SP
SC
SP
AM
PT
SA
Category Store
Sales
Specialty Town West $ 2,725.25
Specialty Town West $
AccessoriesTown West $ 1,318.97
Tools & Shop
Town West $
943.17
Fluids
Town West $
686.57
Replacement
Town
parts
West $ 4,502.33
Performance
Town West $
Performance
Town West $
649.27
Specialty Town West $
Performance
Town West $
AccessoriesTown West $
556.00
Performance
Town West $ 2,798.88
Replacement
Town
parts
West $ 4,925.96
AccessoriesTown West $ 1,900.54
Tools & Shop
Town West $
891.19
Clearance Town West $
Replacement
Town
parts
West $ 3,228.87
Replacement
Town
parts
West $ 1,251.02
AccessoriesTown West $ 1,788.34
Tools & Shop
Town West $ 2,654.44
Replacement
Town
parts
West $
AccessoriesTown West $
375.52
Performance
Town West $
474.44
Clearance Town West $
Performance
Town West $
650.45
Tools & Shop
Town West $ 3,789.21
Fluids
Town West $
133.98
Fluids
Town West $ 4,114.09
Tools & Shop
Town West $ 1,195.42
Replacement
Town
parts
West $
Tools & Shop
Town West $ 1,745.90
Specialty Town West $ 2,822.50
Specialty Town West $
657.56
Fluids
Town West $ 1,398.88
Specialty Town West $
Clearance Town West $
Fluids
Town West $ 3,519.79
Fluids
Town West $ 3,810.02
Replacement
Town
parts
West $ 9,768.68
Performance
Town West $ 1,047.66
Specialty Town West $
Fluids
Town West $
-
Hours
Worked
6
0
6
6
7
4
0
8
0
0
4
5
8
9
5
0
4
4
7
8
0
4
2
0
4
8
8
6
4
0
2
6
8
6
0
0
4
5
6
5
0
0
Base Pay
$ 135.00
$
$
81.00
$
81.00
$ 157.50
$
46.00
$
$ 128.00
$
$
$
46.00
$
67.50
$ 204.00
$ 144.00
$
80.00
$
$
72.00
$
46.00
$ 112.00
$ 180.00
$
$
72.00
$
32.00
$
$
46.00
$ 128.00
$ 128.00
$
81.00
$
72.00
$
$
23.00
$
96.00
$ 128.00
$
81.00
$
$
$
64.00
$
90.00
$
96.00
$ 112.50
$
$
-
Nested Calc
Commission
$
53.98
$
$
9.42
$
$
$
105.79
$
$
$
$
$
2.00
$
74.82
$
132.61
$
21.58
$
7.66
$
$
75.25
$
20.28
$
24.94
$
30.85
$
$
$
6.17
$
$
4.48
$
74.41
$
$
119.54
$
11.20
$
$
39.61
$
55.30
$
$
12.56
$
$
$
79.95
$
86.94
$
237.98
$
$
$
-
Ruaz
Schoemann
Stanton
Stephens
Stone
Vandrey
Walker
Watts
Wilson
Zeon
Argentine
Box
Bing
Bolyard
Bourque
Crad
Cronk
Course
Keyoe
Muarte
Gibb
Lucky
Sims
Fiddes
Beeman
Auger
Harpole
Linch
Ben
Hornel
Hall
Huxly
Hull
Wang
Ketakea
Ladder
Lenfestey
Less
Mallouf
Mass
Math
Manny
Montty
North
Picazo
Plumbtree
Pom
SA
SA
SP
PT
AM
SA
SA
SP
SP
SC
AM
PT
SA
SA
AM
PT
SC
SP
SC
SA
PT
SA
MGR
SP
SP
SC
PT
SC
SP
AM
PT
PT
SP
AM
PT
SP
SC
SA
SC
AM
PT
SP
SP
SA
SA
PT
SA
Specialty Town West $
Clearance Town West $
Clearance Town West $
Clearance Town West $
AccessoriesTown West $
Clearance Town West $
Specialty Town West $
Clearance Town West $
Replacement
Town
parts
West $
AccessoriesTown West $
Specialty Town East $
Specialty Town East $
AccessoriesTown East $
Tools & Shop
Town East $
Fluids
Town East $
Replacement
Town
parts
East $
Performance
Town East $
Performance
Town East $
Specialty Town East $
Performance
Town East $
AccessoriesTown East $
Performance
Town East $
Replacement
Town
parts
East $
AccessoriesTown East $
Tools & Shop
Town East $
Clearance Town East $
Replacement
Town
parts
East $
Replacement
Town
parts
East $
AccessoriesTown East $
Tools & Shop
Town East $
Replacement
Town
parts
East $
AccessoriesTown East $
Performance
Town East $
Clearance Town East $
Performance
Town East $
Tools & Shop
Town East $
Fluids
Town East $
Fluids
Town East $
Tools & Shop
Town East $
Replacement
Town
parts
East $
Tools & Shop
Town East $
Specialty Town East $
Specialty Town East $
Fluids
Town East $
Specialty Town East $
Clearance Town East $
Fluids
Town East $
1,532.87
664.32
1,486.22
2,719.75
1,994.48
2,127.32
1,725.25
1,318.97
943.17
686.57
4,502.33
649.27
556.00
1,798.88
4,925.96
1,900.54
891.19
3,228.87
1,251.02
1,788.34
2,654.44
375.52
474.44
350.45
3,789.21
133.98
4,114.09
1,195.42
1,745.90
2,822.50
657.56
1,398.88
3,519.79
5
8
5
0
0
6
8
8
2
0
5
0
5
5
6
3.5
0
7
0
0
3.5
6
7
8
4
0
3
3
6
7
0
3
2
0
4
8
7
6
3
0
2
6
8
5
0
0
4
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
67.50
108.00
80.00
81.00
108.00
128.00
32.00
112.50
67.50
67.50
135.00
40.25
112.00
40.25
81.00
178.50
128.00
64.00
34.50
54.00
96.00
157.50
34.50
32.00
46.00
128.00
126.00
81.00
54.00
23.00
96.00
128.00
67.50
54.00
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
24.94
23.31
64.61
21.85
30.70
22.06
16.51
1.70
107.37
3.58
28.32
148.36
24.74
10.81
75.45
19.56
28.10
40.93
0.41
6.17
74.41
119.54
17.81
39.61
55.30
19.66
110.31
Pommy
Porter
Ray
Rodden
Rose
Rual
Schmidt
Stanly
Steph
Stonebull
Vandyke
Walk
Water
Wilow
Yule
TOTAL
Avg
Min
Max
PT
SC
AM
SC
PT
SA
SA
SP
PT
AM
SA
SA
SA
SP
SC
Fluids
Town East
Replacement
Town
parts
East
Performance
Town East
Specialty Town East
Fluids
Town East
Specialty Town East
Clearance Town East
Clearance Town East
Clearance Town East
AccessoriesTown East
Clearance Town East
Specialty Town East
Clearance Town East
Replacement
Town
parts
East
AccessoriesTown East
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
2,810.02
6,76...