[go: up one dir, main page]

0% found this document useful (0 votes)
35 views19 pages

Learning Excel FCC

The document shows employee payroll information for various weeks in January including name, hourly wage, hours worked, overtime hours, pay, overtime pay and total pay. It also includes maximum, minimum and average values for hours worked, pay and total pay. The last page shows results from various tests taken by employees and whether they would be fired or not based on failing a drug test.

Uploaded by

wvansh5051
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
35 views19 pages

Learning Excel FCC

The document shows employee payroll information for various weeks in January including name, hourly wage, hours worked, overtime hours, pay, overtime pay and total pay. It also includes maximum, minimum and average values for hours worked, pay and total pay. The last page shows results from various tests taken by employees and whether they would be fired or not based on failing a drug test.

Uploaded by

wvansh5051
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 19

Employee Payroll

House Worked Overtime hours Pay Overtime Pay total pay Jan Pay
Last Name First Name Hourly Wage 1-Jan 8-Jan 15-Jan 22-Jan 29-Jan 1-Jan 8-Jan 15-Jan 22-Jan 29-Jan 1-Jan 8-Jan 15-Jan 22-Jan 29-Jan 1-Jan 8-Jan 15-Jan 22-Jan 29-Jan 1-Jan 8-Jan 15-Jan 22-Jan 29-Jan
Kern Paul $ 20.00 29 33 33 31 32 0 0 0 0 0 $ 580.00 $ 660.00 $ 660.00 $ 620.00 $ 640.00 $ - $ - $ - $ - $ - $ 580.00 $ 660.00 $ 660.00 $ 620.00 $ 640.00 $ 3,160.00
Howard Brock $ 26.10 30 51 21 34 21 0 11 0 0 0 $ 783.00 $ 1,331.10 $ 548.10 $ 887.40 $ 548.10 $ - $ 143.55 $ - $ - $ - $ 783.00 $ 1,474.65 $ 548.10 $ 887.40 $ 548.10 $ 4,241.25
Donald Nancy $ 17.50 40 23 44 65 43 0 0 4 25 3 $ 700.00 $ 402.50 $ 770.00 $ 1,137.50 $ 752.50 $ - $ - $ 35.00 $ 218.75 $ 26.25 $ 700.00 $ 402.50 $ 805.00 $ 1,356.25 $ 778.75 $ 4,042.50
Smith Deren $ 21.70 50 50 54 87 54 10 10 14 47 14 $ 1,085.00 $ 1,085.00 $ 1,171.80 $ 1,887.90 $ 1,171.80 $ 108.50 $ 108.50 $ 151.90 $ 509.95 $ 151.90 $ 1,193.50 $ 1,193.50 $ 1,323.70 $ 2,397.85 $ 1,323.70 $ 7,432.25
Baker Bill $ 10.80 15 70 55 33 43 0 30 15 0 3 $ 162.00 $ 756.00 $ 594.00 $ 356.40 $ 464.40 $ - $ 162.00 $ 81.00 $ - $ 16.20 $ 162.00 $ 918.00 $ 675.00 $ 356.40 $ 480.60 $ 2,592.00
Young Olivia $ 12.40 33 99 56 21 55 0 59 16 0 15 $ 409.20 $ 1,227.60 $ 694.40 $ 260.40 $ 682.00 $ - $ 365.80 $ 99.20 $ - $ 93.00 $ 409.20 $ 1,593.40 $ 793.60 $ 260.40 $ 775.00 $ 3,831.60
Mann Trent $ 19.20 17 41 65 1 65 0 1 25 0 25 $ 326.40 $ 787.20 $ 1,248.00 $ 19.20 $ 1,248.00 $ - $ 9.60 $ 240.00 $ - $ 240.00 $ 326.40 $ 796.80 $ 1,488.00 $ 19.20 $ 1,488.00 $ 4,118.40
Rim John $ 23.00 15 22 44 33 22 0 0 4 0 0 $ 345.00 $ 506.00 $ 1,012.00 $ 759.00 $ 506.00 $ - $ - $ 46.00 $ - $ - $ 345.00 $ 506.00 $ 1,058.00 $ 759.00 $ 506.00 $ 3,174.00
Diana Rock $ 8.00 70 42 21 34 13 30 2 0 0 0 $ 560.00 $ 336.00 $ 168.00 $ 272.00 $ 104.00 $ 120.00 $ 8.00 $ - $ - $ - $ 680.00 $ 344.00 $ 168.00 $ 272.00 $ 104.00 $ 1,568.00

max $ 26.10 70.0 99.0 65.0 87.0 65.0 $ 1,085.00 $ 1,331.10 $ 1,248.00 $ 1,887.90 $ 1,248.00 $ 120.00 $ 365.80 $ 240.00 $ 509.95 $ 240.00 $ 1,193.50 $ 1,593.40 $ 1,488.00 $ 2,397.85 $ 1,488.00 $ 7,432.25
min $ 8.00 15.0 22.0 21.0 1.0 13.0 $ 162.00 $ 336.00 $ 168.00 $ 19.20 $ 104.00 $ - $ - $ - $ - $ - $ 162.00 $ 344.00 $ 168.00 $ 19.20 $ 104.00 $ 1,568.00
avg. $ 17.63 33.2 47.9 43.7 37.7 38.7 $ 550.07 $ 787.93 $ 762.92 $ 688.87 $ 679.64 $ 25.39 $ 88.61 $ 72.57 $ 80.97 $ 58.59 $ 575.46 $ 876.54 $ 835.49 $ 769.83 $ 738.24 $ 3,795.56
total 299 431 393 339 348 $ 4,950.60 $ 7,091.40 $ 6,866.30 $ 6,199.80 $ 6,116.80 $ 228.50 $ 797.45 $ 653.10 $ 728.70 $ 527.35 $ 5,179.10 $ 7,888.85 $ 7,519.40 $ 6,928.50 $ 6,644.15 $ 34,160.00
Company Philosophy Test

Company Philosophy Test


Financial Test

Financial Test
Safety Test

Safety Test
Drug Test
Gradebook
Max. Possibl 10 20 100 1
Last Name First Name
Kern Paul 5 4 66 1 50% 20% 66%
Howard Brock 6 5 45 0 60% 25% 45%
Donald Nancy 7 14 34 1 70% 70% 34%
Smith Deren 3 20 23 1 30% 100% 23%
Baker Bill 2 13 87 1 20% 65% 87%
Young Olivia 4 4 9 1 40% 20% 9%
Mann Trent 7 17 22 0 70% 85% 22%
Rim John 9 16 45 0 90% 80% 45%
Diana Rock 4 10 66 1 40% 50% 66%

Max. 9 20 87 1 90% 100% 87%


Min. 2 4 9 0 20% 20% 9%
Avg. 5.2 11.4 44.1 0.7 52% 57% 44%
Safety Test

Fire Employee?
10
9
Drug Test

8
7
6
5
100% 0% 4
0% 100% 3
100% 0% 2
100% 0% 1
100% 0%
0
100% 100% Paul Brock Nancy Deren Bill Olivia Trent
0% 100%
0% 100%
100% 0%
Company Philosophy Test
100% 25
0%
67% 20

15

10

0
Paul Brock Nancy Deren Bill Olivia Trent
Safety Test

Deren Bill Olivia Trent John Rock

ny Philosophy Test

ren Bill Olivia Trent John Rock


Career Decisions

Job Pay 3 Job Market 5 Enjoyment 4 My Talent 3


Broker 2 6 1 5 5 20 5 15
Data Analyst 3 9 3 15 2 8 1 3
Banker 5 15 2 10 4 16 4 12
Burger King Cashier 1 3 5 25 1 4 3 9
Software Developer 4 12 4 20 3 12 2 6
Schooling 1 Addition
3 3 49
4 4 39
1 1 54
5 5 46
2 2 52
Data
Last Name Sum of Sale Price Sum of Profit Sum of Commision 10%
Barns $ 6,003.50 $ 2,015.10 396.75
Hernandez $ 2,410.70 $ 1,021.60 193.81
Johnson $ 3,035.30 $ 1,084.10 209.45
Smith $ 5,661.10 $ 2,235.90 432.77
Total Result $ 17,110.60 $ 6,356.70 1232.78

Sum of Sale Price

Last Name
Barns
Hernandez
Smith Barns Johnson
33% 35% Smith

JohnsonHernandez
18% 14%
Month Txn. Number Product Code Product Description Store Cost Sale Price Profit Commision 10%
Mar 1,041 2499 8 ft Hose $ 6.20 $ 9.20 $ 3.00 0.3
April 1,049 2499 8 ft Hose $ 6.20 $ 9.20 $ 3.00 0.3
May 1,062 2499 8 ft Hose $ 6.20 $ 9.20 $ 3.00 0.3
June 1,087 2499 8 ft Hose $ 6.20 $ 9.20 $ 3.00 0.3
June 1,088 2499 8 ft Hose $ 6.20 $ 9.20 $ 3.00 0.3
Jan 1,003 2499 8 ft Hose $ 6.20 $ 9.20 $ 3.00 0.3
Jan 1,016 2499 8 ft Hose $ 6.20 $ 9.20 $ 3.00 0.3
Feb 1,019 2499 8 ft Hose $ 6.20 $ 9.20 $ 3.00 0.3
Feb 1,020 2499 8 ft Hose $ 6.20 $ 9.20 $ 3.00 0.3
May 1,065 2499 8 ft Hose $ 6.20 $ 9.20 $ 3.00 0.3
July 1,101 2499 8 ft Hose $ 6.20 $ 9.20 $ 3.00 0.3
Mar 1,035 2499 8 ft Hose $ 6.20 $ 9.20 $ 3.00 0.3
May 1,064 2499 8 ft Hose $ 6.20 $ 9.20 $ 3.00 0.3
May 1,070 2499 8 ft Hose $ 6.20 $ 9.20 $ 3.00 0.3
June 1,095 2499 8 ft Hose $ 6.20 $ 9.20 $ 3.00 0.3
Feb 1,029 2499 8 ft Hose $ 6.20 $ 9.20 $ 3.00 0.3
Mar 1,036 2499 8 ft Hose $ 6.20 $ 9.20 $ 3.00 0.3
Mar 1,038 2499 8 ft Hose $ 6.20 $ 9.20 $ 3.00 0.3
April 1,057 2499 8 ft Hose $ 6.20 $ 9.20 $ 3.00 0.3
July 1,105 2499 8 ft Hose $ 6.20 $ 9.20 $ 3.00 0.3
Nov 1,162 9212 1 Gal Muratic Acid $ 4.00 $ 7.00 $ 3.00 0.3
Aug 1,126 9212 1 Gal Muratic Acid $ 4.00 $ 7.00 $ 3.00 0.3
Sept 1,148 9212 1 Gal Muratic Acid $ 4.00 $ 7.00 $ 3.00 0.3
Oct 1,157 9212 1 Gal Muratic Acid $ 4.00 $ 7.00 $ 3.00 0.3
Nov 1,163 9212 1 Gal Muratic Acid $ 4.00 $ 7.00 $ 3.00 0.3
Jan 1,013 9212 1 Gal Muratic Acid $ 4.00 $ 7.00 $ 3.00 0.3
June 1,097 9212 1 Gal Muratic Acid $ 4.00 $ 7.00 $ 3.00 0.3
Aug 1,131 9212 1 Gal Muratic Acid $ 4.00 $ 7.00 $ 3.00 0.3
Aug 1,132 9212 1 Gal Muratic Acid $ 4.00 $ 7.00 $ 3.00 0.3
Feb 1,024 9212 1 Gal Muratic Acid $ 4.00 $ 7.00 $ 3.00 0.3
Aug 1,141 9212 1 Gal Muratic Acid $ 4.00 $ 7.00 $ 3.00 0.3
Feb 1,032 2877 Net $ 11.40 $ 16.30 $ 4.90 0.49
April 1,050 2877 Net $ 11.40 $ 16.30 $ 4.90 0.49
June 1,090 2877 Net $ 11.40 $ 16.30 $ 4.90 0.49
Jan 1,008 2877 Net $ 11.40 $ 16.30 $ 4.90 0.49
Feb 1,022 2877 Net $ 11.40 $ 16.30 $ 4.90 0.49
Mar 1,044 2877 Net $ 11.40 $ 16.30 $ 4.90 0.49
May 1,066 2877 Net $ 11.40 $ 16.30 $ 4.90 0.49
May 1,067 2877 Net $ 11.40 $ 16.30 $ 4.90 0.49
May 1,074 2877 Net $ 11.40 $ 16.30 $ 4.90 0.49
June 1,092 2877 Net $ 11.40 $ 16.30 $ 4.90 0.49
July 1,099 2877 Net $ 11.40 $ 16.30 $ 4.90 0.49
July 1,104 2877 Net $ 11.40 $ 16.30 $ 4.90 0.49
Jan 1,015 2877 Net $ 11.40 $ 16.30 $ 4.90 0.49
Feb 1,025 2877 Net $ 11.40 $ 16.30 $ 4.90 0.49
June 1,091 2877 Net $ 11.40 $ 16.30 $ 4.90 0.49
Jan 1,002 2877 Net $ 11.40 $ 16.30 $ 4.90 0.49
Jan 1,010 2877 Net $ 11.40 $ 16.30 $ 4.90 0.49
Jan 1,011 2877 Net $ 11.40 $ 16.30 $ 4.90 0.49
Feb 1,034 2877 Net $ 11.40 $ 16.30 $ 4.90 0.49
Mar 1,039 2877 Net $ 11.40 $ 16.30 $ 4.90 0.49
May 1,078 2877 Net $ 11.40 $ 16.30 $ 4.90 0.49
June 1,079 2877 Net $ 11.40 $ 16.30 $ 4.90 0.49
June 1,098 2877 Net $ 11.40 $ 16.30 $ 4.90 0.49
July 1,103 2877 Net $ 11.40 $ 16.30 $ 4.90 0.49
Feb 1,027 6119 Algea Killer 8 oz $ 9.00 $ 14.00 $ 5.00 0.5
May 1,071 1109 Chlorine Test Kit $ 3.00 $ 8.00 $ 5.00 0.5
June 1,082 1109 Chlorine Test Kit $ 3.00 $ 8.00 $ 5.00 0.5
June 1,083 1109 Chlorine Test Kit $ 3.00 $ 8.00 $ 5.00 0.5
June 1,084 6119 Algea Killer 8 oz $ 9.00 $ 14.00 $ 5.00 0.5
July 1,100 6119 Algea Killer 8 oz $ 9.00 $ 14.00 $ 5.00 0.5
Jan 1,005 1109 Chlorine Test Kit $ 3.00 $ 8.00 $ 5.00 0.5
Jan 1,009 1109 Chlorine Test Kit $ 3.00 $ 8.00 $ 5.00 0.5
Feb 1,018 1109 Chlorine Test Kit $ 3.00 $ 8.00 $ 5.00 0.5
April 1,051 6119 Algea Killer 8 oz $ 9.00 $ 14.00 $ 5.00 0.5
April 1,056 1109 Chlorine Test Kit $ 3.00 $ 8.00 $ 5.00 0.5
April 1,060 6119 Algea Killer 8 oz $ 9.00 $ 14.00 $ 5.00 0.5
May 1,061 1109 Chlorine Test Kit $ 3.00 $ 8.00 $ 5.00 0.5
May 1,063 1109 Chlorine Test Kit $ 3.00 $ 8.00 $ 5.00 0.5
May 1,069 1109 Chlorine Test Kit $ 3.00 $ 8.00 $ 5.00 0.5
May 1,072 1109 Chlorine Test Kit $ 3.00 $ 8.00 $ 5.00 0.5
June 1,081 6119 Algea Killer 8 oz $ 9.00 $ 14.00 $ 5.00 0.5
June 1,089 6119 Algea Killer 8 oz $ 9.00 $ 14.00 $ 5.00 0.5
June 1,094 6119 Algea Killer 8 oz $ 9.00 $ 14.00 $ 5.00 0.5
June 1,096 6119 Algea Killer 8 oz $ 9.00 $ 14.00 $ 5.00 0.5
Jan 1,007 1109 Chlorine Test Kit $ 3.00 $ 8.00 $ 5.00 0.5
Feb 1,023 1109 Chlorine Test Kit $ 3.00 $ 8.00 $ 5.00 0.5
Feb 1,026 6119 Algea Killer 8 oz $ 9.00 $ 14.00 $ 5.00 0.5
April 1,058 6119 Algea Killer 8 oz $ 9.00 $ 14.00 $ 5.00 0.5
May 1,075 1109 Chlorine Test Kit $ 3.00 $ 8.00 $ 5.00 0.5
June 1,086 1109 Chlorine Test Kit $ 3.00 $ 8.00 $ 5.00 0.5
July 1,107 1109 Chlorine Test Kit $ 3.00 $ 8.00 $ 5.00 0.5
Feb 1,021 1109 Chlorine Test Kit $ 3.00 $ 8.00 $ 5.00 0.5
Feb 1,031 1109 Chlorine Test Kit $ 3.00 $ 8.00 $ 5.00 0.5
Mar 1,040 1109 Chlorine Test Kit $ 3.00 $ 8.00 $ 5.00 0.5
Mar 1,046 6119 Algea Killer 8 oz $ 9.00 $ 14.00 $ 5.00 0.5
April 1,055 6119 Algea Killer 8 oz $ 9.00 $ 14.00 $ 5.00 0.5
May 1,068 6119 Algea Killer 8 oz $ 9.00 $ 14.00 $ 5.00 0.5
May 1,076 1109 Chlorine Test Kit $ 3.00 $ 8.00 $ 5.00 0.5
June 1,093 6119 Algea Killer 8 oz $ 9.00 $ 14.00 $ 5.00 0.5
April 1,052 6622 5 Gal Chlorine $ 42.00 $ 77.00 $ 35.00 7
May 1,073 6622 5 Gal Chlorine $ 42.00 $ 77.00 $ 35.00 7
July 1,112 6622 5 Gal Chlorine $ 42.00 $ 77.00 $ 35.00 7
July 1,116 6622 5 Gal Chlorine $ 42.00 $ 77.00 $ 35.00 7
Nov 1,159 6622 5 Gal Chlorine $ 42.00 $ 77.00 $ 35.00 7
Mar 1,047 6622 5 Gal Chlorine $ 42.00 $ 77.00 $ 35.00 7
July 1,111 6622 5 Gal Chlorine $ 42.00 $ 77.00 $ 35.00 7
Mar 1,037 6622 5 Gal Chlorine $ 42.00 $ 77.00 $ 35.00 7
Aug 1,128 6622 5 Gal Chlorine $ 42.00 $ 77.00 $ 35.00 7
Jan 1,001 9822 Pool Cover $ 58.30 $ 98.40 $ 40.10 8.02
July 1,113 9822 Pool Cover $ 58.30 $ 98.40 $ 40.10 8.02
Aug 1,133 9822 Pool Cover $ 58.30 $ 98.40 $ 40.10 8.02
Sept 1,147 9822 Pool Cover $ 58.30 $ 98.40 $ 40.10 8.02
Jan 1,006 9822 Pool Cover $ 58.30 $ 98.40 $ 40.10 8.02
June 1,085 9822 Pool Cover $ 58.30 $ 98.40 $ 40.10 8.02
July 1,108 9822 Pool Cover $ 58.30 $ 98.40 $ 40.10 8.02
July 1,123 9822 Pool Cover $ 58.30 $ 98.40 $ 40.10 8.02
Aug 1,134 9822 Pool Cover $ 58.30 $ 98.40 $ 40.10 8.02
Nov 1,164 9822 Pool Cover $ 58.30 $ 98.40 $ 40.10 8.02
Nov 1,165 9822 Pool Cover $ 58.30 $ 98.40 $ 40.10 8.02
Dec 1,168 9822 Pool Cover $ 58.30 $ 98.40 $ 40.10 8.02
May 1,077 9822 Pool Cover $ 58.30 $ 98.40 $ 40.10 8.02
Aug 1,129 9822 Pool Cover $ 58.30 $ 98.40 $ 40.10 8.02
Sept 1,143 9822 Pool Cover $ 58.30 $ 98.40 $ 40.10 8.02
Nov 1,160 9822 Pool Cover $ 58.30 $ 98.40 $ 40.10 8.02
Feb 1,033 9822 Pool Cover $ 58.30 $ 98.40 $ 40.10 8.02
July 1,106 9822 Pool Cover $ 58.30 $ 98.40 $ 40.10 8.02
July 1,118 9822 Pool Cover $ 58.30 $ 98.40 $ 40.10 8.02
Aug 1,137 9822 Pool Cover $ 58.30 $ 98.40 $ 40.10 8.02
Oct 1,154 9822 Pool Cover $ 58.30 $ 98.40 $ 40.10 8.02
Oct 1,152 4421 Skimmer $ 45.00 $ 87.00 $ 42.00 8.4
Dec 1,170 4421 Skimmer $ 45.00 $ 87.00 $ 42.00 8.4
Jan 1,012 4421 Skimmer $ 45.00 $ 87.00 $ 42.00 8.4
April 1,054 4421 Skimmer $ 45.00 $ 87.00 $ 42.00 8.4
June 1,080 4421 Skimmer $ 45.00 $ 87.00 $ 42.00 8.4
July 1,121 4421 Skimmer $ 45.00 $ 87.00 $ 42.00 8.4
July 1,124 4421 Skimmer $ 45.00 $ 87.00 $ 42.00 8.4
Aug 1,139 4421 Skimmer $ 45.00 $ 87.00 $ 42.00 8.4
Oct 1,155 4421 Skimmer $ 45.00 $ 87.00 $ 42.00 8.4
Aug 1,130 4421 Skimmer $ 45.00 $ 87.00 $ 42.00 8.4
Sept 1,145 4421 Skimmer $ 45.00 $ 87.00 $ 42.00 8.4
Feb 1,030 4421 Skimmer $ 45.00 $ 87.00 $ 42.00 8.4
Aug 1,140 4421 Skimmer $ 45.00 $ 87.00 $ 42.00 8.4
Nov 1,161 4421 Skimmer $ 45.00 $ 87.00 $ 42.00 8.4
Dec 1,171 4421 Skimmer $ 45.00 $ 87.00 $ 42.00 8.4
April 1,053 2242 AutoVac $ 60.00 $ 124.00 $ 64.00 12.8
July 1,119 2242 AutoVac $ 60.00 $ 124.00 $ 64.00 12.8
Mar 1,043 2242 AutoVac $ 60.00 $ 124.00 $ 64.00 12.8
April 1,059 2242 AutoVac $ 60.00 $ 124.00 $ 64.00 12.8
July 1,120 2242 AutoVac $ 60.00 $ 124.00 $ 64.00 12.8
Aug 1,125 2242 AutoVac $ 60.00 $ 124.00 $ 64.00 12.8
Aug 1,136 2242 AutoVac $ 60.00 $ 124.00 $ 64.00 12.8
Oct 1,150 2242 AutoVac $ 60.00 $ 124.00 $ 64.00 12.8
Oct 1,156 2242 AutoVac $ 60.00 $ 124.00 $ 64.00 12.8
Dec 1,167 2242 AutoVac $ 60.00 $ 124.00 $ 64.00 12.8
Sept 1,144 2242 AutoVac $ 60.00 $ 124.00 $ 64.00 12.8
Feb 1,017 2242 AutoVac $ 60.00 $ 124.00 $ 64.00 12.8
July 1,102 2242 AutoVac $ 60.00 $ 124.00 $ 64.00 12.8
July 1,114 2242 AutoVac $ 60.00 $ 124.00 $ 64.00 12.8
Sept 1,142 2242 AutoVac $ 60.00 $ 124.00 $ 64.00 12.8
Oct 1,151 2242 AutoVac $ 60.00 $ 124.00 $ 64.00 12.8
Jan 1,004 8722 Water Pump $ 344.00 $ 502.00 $ 158.00 31.6
Jan 1,014 8722 Water Pump $ 344.00 $ 502.00 $ 158.00 31.6
Feb 1,028 8722 Water Pump $ 344.00 $ 502.00 $ 158.00 31.6
Mar 1,048 8722 Water Pump $ 344.00 $ 502.00 $ 158.00 31.6
July 1,115 8722 Water Pump $ 344.00 $ 502.00 $ 158.00 31.6
Aug 1,127 8722 Water Pump $ 344.00 $ 502.00 $ 158.00 31.6
Aug 1,135 8722 Water Pump $ 344.00 $ 502.00 $ 158.00 31.6
Aug 1,138 8722 Water Pump $ 344.00 $ 502.00 $ 158.00 31.6
Sept 1,149 8722 Water Pump $ 344.00 $ 502.00 $ 158.00 31.6
Nov 1,158 8722 Water Pump $ 344.00 $ 502.00 $ 158.00 31.6
Mar 1,042 8722 Water Pump $ 344.00 $ 502.00 $ 158.00 31.6
July 1,122 8722 Water Pump $ 344.00 $ 502.00 $ 158.00 31.6
Oct 1,153 8722 Water Pump $ 344.00 $ 502.00 $ 158.00 31.6
Nov 1,166 8722 Water Pump $ 344.00 $ 502.00 $ 158.00 31.6
Dec 1,169 8722 Water Pump $ 344.00 $ 502.00 $ 158.00 31.6
Mar 1,045 8722 Water Pump $ 344.00 $ 502.00 $ 158.00 31.6
July 1,110 8722 Water Pump $ 344.00 $ 502.00 $ 158.00 31.6
July 1,117 8722 Water Pump $ 344.00 $ 502.00 $ 158.00 31.6
Sept 1,146 8722 Water Pump $ 344.00 $ 502.00 $ 158.00 31.6
July 1,109 8722 Water Pump $ 344.00 $ 502.00 $ 158.00 31.6

sum of all items $ 17,110.60


sum of all items > $50 $ 16,088.40
sum of all items <=$ 50 $ 1,022.20
Last
First Name Name
Chalie Barns
Chalie Barns
Chalie Barns
Chalie Barns
Chalie Barns
Doug Smith
Doug Smith
Doug Smith
Doug Smith
Doug Smith
Doug Smith
Hellen Johnson
Hellen Johnson
Hellen Johnson
Hellen Johnson
Juan Hernandez
Juan Hernandez
Juan Hernandez
Juan Hernandez
Juan Hernandez
Chalie Barns
Doug Smith
Doug Smith
Doug Smith
Doug Smith
Hellen Johnson
Hellen Johnson
Hellen Johnson
Hellen Johnson
Juan Hernandez
Juan Hernandez
Chalie Barns
Chalie Barns
Chalie Barns
Doug Smith
Doug Smith
Doug Smith
Doug Smith
Doug Smith
Doug Smith
Doug Smith
Doug Smith
Doug Smith
Hellen Johnson
Hellen Johnson
Hellen Johnson
Juan Hernandez
Juan Hernandez
Juan Hernandez
Juan Hernandez
Juan Hernandez
Juan Hernandez
Juan Hernandez
Juan Hernandez
Juan Hernandez
Chalie Barns
Chalie Barns
Chalie Barns
Chalie Barns
Chalie Barns
Chalie Barns
Doug Smith
Doug Smith
Doug Smith
Doug Smith
Doug Smith
Doug Smith
Doug Smith
Doug Smith
Doug Smith
Doug Smith
Doug Smith
Doug Smith
Doug Smith
Doug Smith
Hellen Johnson
Hellen Johnson
Hellen Johnson
Hellen Johnson
Hellen Johnson
Hellen Johnson
Hellen Johnson
Juan Hernandez
Juan Hernandez
Juan Hernandez
Juan Hernandez
Juan Hernandez
Juan Hernandez
Juan Hernandez
Juan Hernandez
Doug Smith
Doug Smith
Doug Smith
Doug Smith
Doug Smith
Hellen Johnson
Hellen Johnson
Juan Hernandez
Juan Hernandez
Chalie Barns
Chalie Barns
Chalie Barns
Chalie Barns
Doug Smith
Doug Smith
Doug Smith
Doug Smith
Doug Smith
Doug Smith
Doug Smith
Doug Smith
Hellen Johnson
Hellen Johnson
Hellen Johnson
Hellen Johnson
Juan Hernandez
Juan Hernandez
Juan Hernandez
Juan Hernandez
Juan Hernandez
Chalie Barns
Chalie Barns
Doug Smith
Doug Smith
Doug Smith
Doug Smith
Doug Smith
Doug Smith
Doug Smith
Hellen Johnson
Hellen Johnson
Juan Hernandez
Juan Hernandez
Juan Hernandez
Juan Hernandez
Chalie Barns
Chalie Barns
Doug Smith
Doug Smith
Doug Smith
Doug Smith
Doug Smith
Doug Smith
Doug Smith
Doug Smith
Hellen Johnson
Juan Hernandez
Juan Hernandez
Juan Hernandez
Juan Hernandez
Juan Hernandez
Chalie Barns
Chalie Barns
Chalie Barns
Chalie Barns
Chalie Barns
Chalie Barns
Chalie Barns
Chalie Barns
Chalie Barns
Chalie Barns
Doug Smith
Doug Smith
Doug Smith
Doug Smith
Doug Smith
Hellen Johnson
Hellen Johnson
Hellen Johnson
Hellen Johnson
Juan Hernandez
Car ID Make Make (Full Model Model (FulManufacturAge Miles Miles / YeaColor
FD06MTG001 40326.8 Black
FD06MTG002 44974.8 White
FD08MTG003 44946.5 Green
FD08MTG004 37558.8 Black
FD08MTG005 36438.5 White
FDO6FCS006 46311.4 Green
FD06FCS007 52229.5 Green
FD09FCS008 35137 Black
FD13FCS009 27637.1 Black
FD13FCS010 27534.8 White
FD12FCS011 19341.7 White
FD13FCS012 22521.6 Black
FD13FCS013 13682.9 Black
GMO9CMR014 28464.8 White
GM12CMR015 19421.1 Black
GM14CMR016 14289.6 White
GM10SLV017 31144.4 Black
GM98SLV018 83162.7 Black
GM00SLV019 80685.8 Blue
TY96CAM020 114660.6 Green
TY98CAM021 93382.6 Black
TY00CAM022 85928 Green
TY02CAM023 67829.1 Black
TY09CAM024 48114.2 White
TY02COR025 64467.4 Red
TY03COR026 73444.4 Black
TY14COR027 17556.3 Blue
TY12COR028 29601.9 Black
TY12CAM029 22128.2 Blue
HO99CIV030 82374 White
HO01CIV031 69891.9 Blue
HO10CIV032 22573 Blue
HO10CIV033 33477.2 Black
HO11CIV034 30555.3 Black
HO12CIV035 24513.2 Black
HO13CIV036 13867.6 Black
HOO5ODY037 60389.5 White
HO07ODY038 50854.1 Black
HO08ODY039 42504.6 White
HO010ODY040 68658.9 Black
HO14ODY041 3708.1 Black
CR04PTC042 64542 Blue
CR07PTC043 42074.2 Green
CR11PTC044 27394.2 Black
CR99CAR045 79420.6 Green
CR00CAR046 77243.1 Black
CR04CAR047 72527.2 White
CR04CAR048 52699.4 Red
HY11ELA049 29102.3 Black
HY12ELA050 22282 Blue
HY13ELA051 20223.9 Black
HY13ELA052 22188.5 Blue
Driver Warantee Miles
Smith 50000
McCall 50000
Lyon 50000
Jones 50000
Smith 50000
Ewenty 75000
Lyon 75000
Howard 75000
Smith 75000
Praulty 75000
Yousef 75000
Vizzini 75000
Rodriguez 75000
Santos 100000
Bard 100000
Torrens 100000
Hulinski 100000
Santos 100000
Vizzini 100000
Chan 100000
Swartz 100000
Ewenty 100000
Smith 100000
Howard 100000
Gaul 100000
Gaul 100000
Praulty 100000
Santos 100000
Chan 100000
Rodriguez 75000
Jones 75000
Torrens 75000
Swartz 75000
Lyon 75000
Hulinski 75000
Chan 75000
Howard 100000
Swartz 100000
Rodriguez 100000
Smith 100000
McCall 100000
Smith 75000
Gaul 75000
Vizzini 75000
Hulinski 75000
Jones 75000
Bard 75000
Bard 75000
Torrens 100000
McCall 100000
Praulty 100000
Ewenty 100000

You might also like