Employee Payroll Mr.

Tamal
Hours Worked Overtime Hours Pay Overtime Bonus Total Pay Jan Pay
Last Name First Name Hourly Wages 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 Jon $ 15.90 40 42 39 40 41 0 2 0 0 1 $ 636.00 $ 667.80 $ 620.10 $ 636.00 $ 651.90 $ - $ 15.90 $ - $ - $ 7.95 $ 636.00 $ 683.70 $ 620.10 $ 636.00 $ 659.85 $ 3,235.65
Howard Eric $ 14.65 42 41 45 38 39 2 1 5 0 0 $ 615.30 $ 600.65 $ 1,890.00 $ 556.70 $ 571.35 $ 14.65 $ 7.33 $ 36.63 $ - $ - $ 629.95 $ 607.98 $ 1,926.63 $ 556.70 $ 571.35 $ 4,292.60
Donald Sam $ 12.40 43 43 67 50 40 3 3 27 10 0 $ 533.20 $ 533.20 $ 2,881.00 $ 620.00 $ 496.00 $ 18.60 $ 18.60 $ 167.40 $ 62.00 $ - $ 551.80 $ 551.80 $ 3,048.40 $ 682.00 $ 496.00 $ 5,330.00
Tiwari Ram $ 19.44 44 40 68 43 41 4 0 28 3 1 $ 855.36 $ 777.60 $ 2,992.00 $ 835.92 $ 797.04 $ 38.88 $ - $ 272.16 $ 29.16 $ 21.50 $ 894.24 $ 777.60 $ 3,264.16 $ 865.08 $ 818.54 $ 6,619.62
Kumari Sita $ 14.56 33 36 53 45 45 0 0 13 5 5 $ 480.32 $ 523.98 $ 1,749.00 $ 654.98 $ 654.98 $ - $ - $ 94.61 $ 36.39 $ 112.50 $ 480.32 $ 523.98 $ 1,843.61 $ 691.36 $ 767.48 $ 4,306.74
Pratap Sachin $ 14.57 23 51 54 47 65 0 11 14 7 25 $ 335.18 $ 743.22 $ 1,242.00 $ 684.93 $ 947.25 $ - $ 80.15 $ 102.01 $ 51.01 $ 587.50 $ 335.18 $ 823.37 $ 1,344.01 $ 735.94 $ 1,534.75 $ 4,773.25
Ranjan Shyam $ 14.59 32 67 31 56 57 0 27 0 16 17 $ 466.91 $ 977.60 $ 992.00 $ 817.10 $ 831.69 $ - $ 196.98 $ - $ 116.73 $ 476.00 $ 466.91 $ 1,174.58 $ 992.00 $ 933.82 $ 1,307.69 $ 4,875.00
Pradhan Bhupesh $ 14.61 12 45 36 53 58 0 5 0 13 18 $ 175.31 $ 657.41 $ 432.00 $ 774.28 $ 847.32 $ - $ 36.52 $ - $ 94.96 $ 477.00 $ 175.31 $ 693.93 $ 432.00 $ 869.24 $ 1,324.32 $ 3,494.79
Kumar Aashish $ 14.63 31 55 60 59 59 0 15 20 19 19 $ 453.44 $ 804.49 $ 1,860.00 $ 862.99 $ 862.99 $ - $ 109.70 $ 146.27 $ 138.96 $ 560.50 $ 453.44 $ 914.19 $ 2,006.27 $ 1,001.95 $ 1,423.49 $ 5,799.34
Batha Jatin $ 14.65 29 39 45 64 45 0 0 5 24 5 $ 424.71 $ 571.16 $ 1,305.00 $ 937.28 $ 659.03 $ - $ - $ 36.61 $ 175.74 $ 160.00 $ 424.71 $ 571.16 $ 1,341.61 $ 1,113.02 $ 819.03 $ 4,269.52
Ghosh Sagar $ 14.66 27 43 33 66 47 0 3 0 26 7 $ 395.90 $ 630.51 $ 891.00 $ 967.76 $ 689.16 $ - $ 21.99 $ - $ 190.62 $ 231.00 $ 395.90 $ 652.50 $ 891.00 $ 1,158.38 $ 920.16 $ 4,017.94
Kumar Sandeep $ 14.68 23 38 55 42 49 0 0 15 2 9 $ 337.66 $ 557.88 $ 1,265.00 $ 616.60 $ 719.37 $ - $ - $ 110.11 $ 14.68 $ 189.00 $ 337.66 $ 557.88 $ 1,375.11 $ 631.28 $ 908.37 $ 3,810.30
Raj Saurav $ 14.70 34 40 66 60 40 0 0 26 20 0 $ 499.77 $ 587.96 $ 2,244.00 $ 881.94 $ 587.96 $ - $ - $ 191.09 $ 146.99 $ - $ 499.77 $ 587.96 $ 2,435.09 $ 1,028.93 $ 587.96 $ 5,139.70
Singh Shivam $ 14.72 38 50 33 51 34 0 10 0 11 0 $ 559.25 $ 735.85 $ 1,254.00 $ 750.57 $ 500.38 $ - $ 73.59 $ - $ 80.94 $ - $ 559.25 $ 809.44 $ 1,254.00 $ 831.51 $ 500.38 $ 3,954.57
Nandi Priya $ 14.74 11 51 50 55 36 0 11 10 15 0 $ 162.08 $ 751.49 $ 550.00 $ 810.43 $ 530.46 $ - $ 81.04 $ 73.68 $ 110.51 $ - $ 162.08 $ 832.53 $ 623.68 $ 920.94 $ 530.46 $ 3,069.69
Mohanty Priyanka $ 14.75 10 62 44 34 39 0 22 4 0 0 $ 147.53 $ 914.69 $ 440.00 $ 501.60 $ 575.37 $ - $ 162.28 $ 29.51 $ - $ - $ 147.53 $ 1,076.97 $ 469.51 $ 501.60 $ 575.37 $ 2,770.97
Paul Tamal $ 14.77 19 34 47 57 44 0 0 7 17 4 $ 280.65 $ 502.21 $ 893.00 $ 841.95 $ 649.92 $ - $ - $ 51.70 $ 125.55 $ 114.00 $ 280.65 $ 502.21 $ 944.70 $ 967.50 $ 763.92 $ 3,458.99

Max $ 19.44 $ 44.00 $ 67.00 $ 68.00 $ 66.00 $ 65.00 $ 4.00 $ 27.00 $ 28.00 $ 26.00 $ 25.00 $ 855.36 $ 977.60 $ 2,992.00 $ 967.76 $ 947.25 $ 38.88 $ 196.98 $ 272.16 $ 190.62 $ 587.50 $ 894.24 $ 1,174.58 $ 3,264.16 $ 1,158.38 $ 1,534.75 $ 6,619.62
Min $ 12.40 $ 10.00 $ 34.00 $ 31.00 $ 34.00 $ 34.00 $ - $ - $ - $ - $ - $ 147.53 $ 502.21 $ 432.00 $ 501.60 $ 496.00 $ - $ - $ - $ - $ - $ 147.53 $ 502.21 $ 432.00 $ 501.60 $ 496.00 $ 2,770.97
Average $ 14.88 $ 28.88 $ 45.71 $ 48.59 $ 50.59 $ 45.82 $ 0.53 $ 6.47 $ 10.24 $ 11.06 $ 6.53 $ 432.86 $ 678.69 $ 1,382.36 $ 750.06 $ 680.72 $ 4.24 $ 47.30 $ 77.16 $ 80.84 $ 172.76 $ 437.10 $ 725.99 $ 1,459.52 $ 830.90 $ 853.48 $ 4,306.98
Total $ 253.01 $ 491.00 $ 777.00 $ 826.00 $ 860.00 $ 779.00 $ 9.00 $ 110.00 $ 174.00 $ 188.00 $ 111.00 $ 7,358.56 $ 11,537.68 $ 23,500.10 $ 12,751.01 $ 11,572.16 $ 72.13 $ 804.09 $ 1,311.76 $ 1,374.24 $ 2,936.95 $ 7,430.69 $ 12,341.76 $ 24,811.86 $ 14,125.25 $ 14,509.11 $ 73,218.66
 Company Philosophy Test

Company Philosophy Test

Financial Skills Test
Safety Test

Safety Test
Drug Test
GradeBook
Points Possible 10 20 100 1
Last Name First Name
Kern Jon 10 11 67 1 100% 55%
Howard Eric 9 20 88 0 90% 100%
Donald Sam 8 13 45 1 80% 65%
Tiwari Ram 6 14 90 1 60% 70%
Kumari Sita 5 17 96 1 50% 85%
Pratap Sachin 7 18 34 0 70% 90%
Ranjan Shyam 10 15 56 1 100% 75%
Pradhan Bhupesh 4 13 77 1 40% 65%
Kumar Aashish 9 12 89 1 90% 60%
Batha Jatin 8 11 45 0 80% 55%
Ghosh Sagar 3 10 59 1 30% 50%
Kumar Sandeep 4 18 63 0 40% 90%
Raj Saurav 6 15 71 1 60% 75%
Singh Shivam 8 9 31 1 80% 45%
Nandi Priya 10 11 77 1 100% 55%
Mohanty Priyanka 10 20 90 1 100% 100%
Paul Tamal 10 20 90 1 100% 100%

Max 10 20 96 1 100% 100%

Min 3 9 31 0 30% 45%
Average 7.470588235 14.5294118 68.705882 0.764706 75% 73%
Financial Skills Test

Fire Employee?
Drug Test

67% 100% FALSE

88% 0% TRUE Safety Test
45% 100% TRUE 12
90% 100% FALSE
96% 100% FALSE 10
34% 0% TRUE
8
56% 100% FALSE
77% 100% TRUE 6
89% 100% FALSE
4
45% 0% TRUE
59% 100% TRUE 2
63% 0% TRUE
0
71% 100% FALSE 10 9 8 6 5 7 10 4 9 8 3 4 6 8 10 10
31% 100% TRUE
Column C
77% 100% FALSE
90% 100% FALSE
90% 100% FALSE Company Philosophy Test
25

96% 100% 20
31% 0%
69% 76% 15

10

0
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 1

Column D

Financial Skills Test

120

100

80

60
 Financial Skills Test
120

100

80

60

40

20

0
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 1

Column E

Drug Test
1.2

0.8

0.6

0.4

0.2

0
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 1

Column F
 3 4 6 8 10 10 10

hy Test

11 12 13 14 15 16 17

Test
Test

11 12 13 14 15 16 17

11 12 13 14 15 16 17
Career Decisions [Link]

Job Pay 3 Job Market 5 Enjoyment 4 My Talent 3 Schooling 1 Total

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

Sum of all items $ 17,110.60

Sum of items valued at more than $50 $ 16,088.40
Sum of items valued at $50 or less $ 1,022.20
Commision 10% for item
less than $50. 20% Sale
items more than $50. First Name Last Name Location
$ 8.02 Chalie Barns NM
$ 0.49 Juan Hernandez CA
$ 0.30 Doug Smith AZ
$ 31.60 Chalie Barns AZ
$ 0.50 Doug Smith AZ
$ 8.02 Doug Smith AZ
$ 0.50 Hellen Johnson NM
$ 0.49 Doug Smith NM
$ 0.50 Doug Smith AZ
$ 0.49 Juan Hernandez CO
$ 0.49 Juan Hernandez AZ
$ 8.40 Doug Smith NM
$ 0.30 Hellen Johnson CO
$ 31.60 Chalie Barns CA
$ 0.49 Hellen Johnson AZ
$ 0.30 Doug Smith CA
$ 12.80 Juan Hernandez NM
$ 0.50 Doug Smith CA
$ 0.30 Doug Smith CO
$ 0.30 Doug Smith NV
$ 0.50 Juan Hernandez CO
$ 0.49 Doug Smith UT
$ 0.50 Hellen Johnson NM
$ 0.30 Juan Hernandez UT
$ 0.49 Hellen Johnson NV
$ 0.50 Hellen Johnson NM
$ 0.50 Chalie Barns NV
$ 31.60 Chalie Barns AZ
$ 0.30 Juan Hernandez AZ
$ 8.40 Juan Hernandez NV
$ 0.50 Juan Hernandez CA
$ 0.49 Chalie Barns AZ
$ 8.02 Juan Hernandez CA
$ 0.49 Juan Hernandez CO
$ 0.30 Hellen Johnson CA
$ 0.30 Juan Hernandez NV
$ 7.00 Juan Hernandez NV
$ 0.30 Juan Hernandez NV
$ 0.49 Juan Hernandez CA
$ 0.50 Juan Hernandez AZ
$ 0.30 Chalie Barns NM
$ 31.60 Doug Smith NM
$ 12.80 Doug Smith CA
$ 0.49 Doug Smith CA
$ 31.60 Hellen Johnson AZ
$ 0.50 Juan Hernandez UT
$ 7.00 Hellen Johnson AZ
$ 31.60 Chalie Barns AZ
$ 0.30 Chalie Barns CO
$ 0.49 Chalie Barns AZ
$ 0.50 Doug Smith UT
$ 7.00 Doug Smith AZ
$ 12.80 Chalie Barns CA
$ 8.40 Doug Smith NV
$ 0.50 Juan Hernandez NV
$ 0.50 Doug Smith CA
$ 0.30 Juan Hernandez CA
$ 0.50 Hellen Johnson AZ
$ 12.80 Doug Smith AZ
$ 0.50 Doug Smith NV
$ 0.50 Doug Smith NV
$ 0.30 Chalie Barns AZ
$ 0.50 Doug Smith CA
$ 0.30 Hellen Johnson AZ
$ 0.30 Doug Smith NM
$ 0.49 Doug Smith NV
$ 0.49 Doug Smith UT
$ 0.50 Juan Hernandez CA
$ 0.50 Doug Smith AZ
$ 0.30 Hellen Johnson AZ
$ 0.50 Chalie Barns AZ
$ 0.50 Doug Smith NV
$ 7.00 Doug Smith CA
$ 0.49 Doug Smith AZ
$ 0.50 Hellen Johnson CA
$ 0.50 Juan Hernandez AZ
$ 8.02 Hellen Johnson AZ
$ 0.49 Juan Hernandez NV
$ 0.49 Juan Hernandez NM
$ 8.40 Doug Smith CA
$ 0.50 Doug Smith UT
$ 0.50 Chalie Barns CA
$ 0.50 Chalie Barns NV
$ 0.50 Chalie Barns AZ
$ 8.02 Doug Smith NV
$ 0.50 Hellen Johnson AZ
$ 0.30 Chalie Barns CA
$ 0.30 Chalie Barns NM
$ 0.50 Doug Smith NV
$ 0.49 Chalie Barns CA
$ 0.49 Hellen Johnson NV
$ 0.49 Doug Smith CA
$ 0.50 Juan Hernandez AZ
$ 0.50 Doug Smith CA
$ 0.30 Hellen Johnson AZ
$ 0.50 Doug Smith AZ
$ 0.30 Hellen Johnson NV
$ 0.49 Juan Hernandez NM
$ 0.49 Doug Smith CA
$ 0.50 Chalie Barns UT
$ 0.30 Doug Smith CA
$ 12.80 Juan Hernandez NV
$ 0.49 Juan Hernandez AZ
$ 0.49 Doug Smith NV
$ 0.30 Juan Hernandez AZ
$ 8.02 Juan Hernandez CA
$ 0.50 Hellen Johnson NM
$ 8.02 Doug Smith NV
$ 31.60 Juan Hernandez CA
$ 31.60 Hellen Johnson NV
$ 7.00 Hellen Johnson CA
$ 7.00 Doug Smith AZ if
$ 8.02 Chalie Barns CA Sumif
$ 12.80 Juan Hernandez AZ sort
$ 31.60 Chalie Barns AZ filter
$ 7.00 Doug Smith NV pivot tables
$ 31.60 Hellen Johnson NM pie chart
$ 8.02 Juan Hernandez CA
$ 12.80 Chalie Barns UT
$ 12.80 Doug Smith CA
$ 8.40 Doug Smith NV
$ 31.60 Doug Smith AZ
$ 8.02 Doug Smith NV
$ 8.40 Doug Smith AZ
$ 12.80 Doug Smith CA
$ 0.30 Doug Smith NM
$ 31.60 Chalie Barns NV
$ 7.00 Juan Hernandez CA
$ 8.02 Hellen Johnson NV
$ 8.40 Hellen Johnson CA
$ 0.30 Hellen Johnson AZ
$ 0.30 Hellen Johnson CA
$ 8.02 Chalie Barns AZ
$ 8.02 Doug Smith AZ
$ 31.60 Chalie Barns NV
$ 12.80 Doug Smith NM
$ 8.02 Juan Hernandez CA
$ 31.60 Chalie Barns UT
$ 8.40 Doug Smith CA
$ 8.40 Juan Hernandez NV
$ 0.30 Juan Hernandez AZ
$ 12.80 Juan Hernandez NV
$ 8.02 Hellen Johnson AZ
$ 12.80 Hellen Johnson CA
$ 8.40 Hellen Johnson NM
$ 31.60 Hellen Johnson NV
$ 8.02 Chalie Barns CA
$ 0.30 Doug Smith AZ
$ 31.60 Chalie Barns AZ
$ 12.80 Doug Smith UT
$ 12.80 Juan Hernandez CA
$ 8.40 Chalie Barns NV
$ 31.60 Doug Smith AZ
$ 8.02 Juan Hernandez NV
$ 8.40 Doug Smith AZ
$ 12.80 Doug Smith CA
$ 0.30 Doug Smith NM
$ 31.60 Chalie Barns NV
$ 7.00 Doug Smith CA
$ 8.02 Hellen Johnson NV
$ 8.40 Juan Hernandez CA
$ 0.30 Chalie Barns AZ
$ 0.30 Doug Smith CA
$ 8.02 Doug Smith AZ
$ 8.02 Doug Smith AZ
$ 31.60 Doug Smith NV
$ 12.80 Doug Smith NM
$ 8.02 Doug Smith CA
$ 31.60 Doug Smith UT
$ 8.40 Chalie Barns CA
$ 8.40 Juan Hernandez NV
if
Sumif
sort
filter
pivot tables
pie chart
 Make (Full Model (Full Manufact
Car ID Make Name) Model Name) ure Year Age Miles
TY14COR027 TY Toyota COR Corola 14 0 17,556.30
GM14CMR016 GM General Motors CMR Camero 14 0 14,289.60
FD13FCS009 FD Ford FCS Focus 13 1 27,637.10
FD13FCS010 FD Ford FCS Focus 13 1 27,534.80
FD13FCS012 FD Ford FCS Focus 13 1 22,521.60
HY13ELA052 HY hyundai ELA Elantra 13 1 22,188.50
HY13ELA051 HY hyundai ELA Elantra 13 1 20,223.90
TY12COR028 TY Toyota COR Corola 12 2 29,601.90
HO12CIV035 HO Honda CIV Civic 12 2 24,513.20
HO13CIV036 HO Honda CIV Civic 13 1 13,867.60
FD13FCS013 FD Ford FCS Focus 13 1 13,682.90
HY12ELA050 HY hyundai ELA Elantra 12 2 22,282.00
TY12CAM029 TY Toyota CAM Camrey 12 2 22,128.20
TY09CAM024 TY Toyota CAM Camrey 09 5 48,114.20
HO11CIV034 HO Honda CIV Civic 11 3 30,555.30
HY11ELA049 HY hyundai ELA Elantra 11 3 29,102.30
CR11PTC044 CR Chrysler PTC PT Cruiser 11 3 27,394.20
GM12CMR015 GM General Motors CMR Camero 12 2 19,421.10
FD12FCS011 FD Ford FCS Focus 12 2 19,341.70
HO10CIV033 HO Honda CIV Civic 10 4 33,477.20
HO14ODY041 HO Honda ODY Odyssey 14 0 3,708.10
GM10SLV017 GM General Motors SLV Silverdo 10 4 31,144.40
FD08MTG003 FD Ford MTG Mustang 08 6 44,946.50
CR04CAR047 CR Chrysler CAR Caravan 04 10 72,527.20
HO07ODY038 HO Honda ODY Odyssey 07 7 50,854.10
HO08ODY039 HO Honda ODY Odyssey 08 6 42,504.60
FD09FCS008 FD Ford FCS Focus 09 5 35,137.00
TY03COR026 TY Toyota COR Corola 03 11 73,444.40
HO05ODY037 HO Honda ODY Odyssey 05 9 60,389.50
TY96CAM020 TY Toyota CAM Camrey 96 18 114,660.60
CR04PTC042 CR Chrysler PTC PT Cruiser 04 10 64,542.00
FD06FCS007 FD Ford FCS Focus 06 8 52,229.50
TY00CAM022 TY Toyota CAM Camrey 00 14 85,928.00
FD08MTG004 FD Ford MTG Mustang 08 6 37,558.80
TY98CAM021 TY Toyota CAM Camrey 98 16 93,382.60
CR07PTC043 CR Chrysler PTC PT Cruiser 07 7 42,074.20
FD08MTG005 FD Ford MTG Mustang 08 6 36,438.50
GM00SLV019 GM General Motors SLV Silverdo 00 14 80,685.80
FD06FCS006 FD Ford FCS Focus 06 8 46,311.40
TY02CAM023 TY Toyota CAM Camrey 02 12 67,829.10
CR00CAR046 CR Chrysler CAR Caravan 00 14 77,243.10
HO99CIV030 HO Honda CIV Civic 99 15 82,374.00
FD06MTG002 FD Ford MTG Mustang 06 8 44,974.80
HO01CIV031 HO Honda CIV Civic 01 13 69,891.90
GM09CMR014 GM General Motors CMR Camero 09 5 28,464.80
TY02COR025 TY Toyota COR Corola 02 12 64,467.40
CR99CAR045 CR Chrysler CAR Caravan 99 15 79,420.60
HO01ODY040 HO Honda ODY Odyssey 01 13 68,658.90
GM98SLV018 GM General Motors SLV Silverdo 98 16 83,162.70
CR04CAR048 CR Chrysler CAR Caravan 04 10 52,699.40
HO10CIV032 HO Honda CIV Civic 10 4 22,573.00
FD06MTG001 FD Ford MTG Mustang 06 8 40,326.80

CR Chrysler CAM Camrey

FD Ford CAR Caravan
GM General Motors CIV Civic
HO Honda CMR Camero
HY hyundai COR Corola
TY Toyota ELA Elantra
FCS Focus
MTG Mustang
ODY Odyssey
PTC PT Cruiser
SLV Silverdo
 Warantee
Miles / Year Color Driver Miles Covered? New Car ID
35,112.60 Blue Praulty 100000 Y TY14CORBLU027
28,579.20 White Torrens 100000 Y GM14CMRWHI016 Age of the
18,424.73 Black Smith 75000 Y FD13FCSBLA009 140,000.00
18,356.53 White Praulty 75000 Y FD13FCSWHI010
120,000.00
15,014.40 Black Vizzini 75000 Y FD13FCSBLA012
14,792.33 Blue Ewenty 100000 Y HY13ELABLU052 100,000.00

Miles Driven
13,482.60 Black Praulty 100000 Y HY13ELABLA051 80,000.00
11,840.76 Black Santos 100000 Y TY12CORBLA028
60,000.00
9,805.28 Black Hulinski 75000 Y HO12CIVBLA035
9,245.07 Black Chan 75000 Y HO13CIVBLA036 40,000.00
9,121.93 Black Rodriguez 75000 Y FD13FCSBLA013 20,000.00
8,912.80 Blue McCall 100000 Y HY12ELABLU050
-
8,851.28 Blue Chan 100000 Y TY12CAMBLU029 0 2 4 6
8,748.04 White Howard 100000 Y TY09CAMWHI024
Age of the car(Years)
8,730.09 Black Lyon 75000 Y HO11CIVBLA034
8,314.94 Black Torrens 100000 Y HY11ELABLA049
7,826.91 Black Vizzini 75000 Y CR11PTCBLA044
7,768.44 Black Bard 100000 Y GM12CMRBLA015
7,736.68 White Yousef 75000 Y FD12FCSWHI011
7,439.38 Black Swartz 75000 Y HO10CIVBLA033
7,416.20 Black McCall 100000 Y HO14ODYBLA041
6,920.98 Black Hulinski 100000 Y GM10SLVBLA017
6,914.85 Green Lyon 50000 Y FD08MTGGRE003
6,907.35 White Bard 75000 Y CR04CARWHI047
6,780.55 Black Swartz 100000 Y HO07ODYBLA038
6,539.17 White Rodriguez 100000 Y HO08ODYWHI039
6,388.55 Black Howard 75000 Y FD09FCSBLA008
6,386.47 Black Gaul 100000 Y TY03CORBLA026
6,356.79 White Howard 100000 Y HO05ODYWHI037
6,197.87 Green Chan 100000 Not covered TY96CAMGRE020
6,146.86 Blue Smith 75000 Y CR04PTCBLU042
6,144.65 Green Lyon 75000 Y FD06FCSGRE007
5,926.07 Green Ewenty 100000 Y TY00CAMGRE022
5,778.28 Black Jones 50000 Y FD08MTGBLA004
5,659.55 Black Swartz 100000 Y TY98CAMBLA021
5,609.89 Green Gaul 75000 Y CR07PTCGRE043
5,605.92 White Smith 50000 Y FD08MTGWHI005
5,564.54 Blue Vizzini 100000 Y GM00SLVBLU019
5,448.40 Green Ewenty 75000 Y FD06FCSGRE006
5,426.33 Black Smith 100000 Y TY02CAMBLA023
5,327.11 Black Jones 75000 Not covered CR00CARBLA046
5,314.45 White Rodriguez 75000 Not covered HO99CIVWHI030
5,291.15 White McCall 50000 Y FD06MTGWHI002
5,177.18 Blue Jones 75000 Y HO01CIVBLU031
5,175.42 White Santos 100000 Y GM09CMRWHI014
5,157.39 Red Gaul 100000 Y TY02CORRED025
5,123.91 Green Hulinski 75000 Not covered CR99CARGRE045
5,085.84 Black Smith 100000 Y HO01ODYBLA040
5,040.16 Black Santos 100000 Y GM98SLVBLA018
5,018.99 Red Bard 75000 Y CR04CARRED048
5,016.22 Blue Torrens 75000 Y HO10CIVBLU032
4,744.33 Black Smith 50000 Y FD06MTGBLA001
 Age of the car(Years)
,000.00

,000.00

,000.00

,000.00

,000.00

,000.00

,000.00

-
0 2 4 6 8 10 12 14 16 18 20

Age of the car(Years) Linear (Age of the car(Years))

Driver Sum of Miles
Bard 144,647.70
Chan 150,656.40
Ewenty 154,427.90 Total
Gaul 179,986.00 2500000
Howard 143,640.70
2000000
Hulinski 135,078.20
Jones 184,693.80 1500000
Lyon 127,731.30
1000000
McCall 70,964.90
Praulty 65,315.00 500000
Rodriguez 138,561.50
0
Santos 141,229.40 rd han nty aul ard ski nes yon Call ulty uez tos ith rtz ens zini sef sult
Ba C we G ow ulin Jo L c a g n m a r z u e
Smith 305,432.40 E H H M Pr dri Sa S Sw Tor Vi Yo l R
R o ta
Swartz 177,713.90 To
Torrens 65,964.90 Sum of Miles
Vizzini 130,601.60
Yousef 19,341.70
Total Result 2,335,987.30
tz ens zini sef ult
rr iz ou es
To V Y al R
t
To
Last Name Sum of Sale Price
Barns $ 6,003.50 Total
Hernandez $ 2,410.70
Johnson $ 3,035.30
Smith $ 5,661.10
$6,003.50
Total Result $ 17,110.60
$2,410.70
$17,110.60
$3,035.30

$5,661.10

Barns Hernandez Johnson Smith Total Result

ult