6- Month Sales Analysis
$70,000.00
$60,000.00 June
May
Sales in Dollars
$50,000.00
$40,000.00 April
$30,000.00 March
$20,000.00 Feb
$10,000.00 Jan
$-
6-Month Sales Analysis
$70,000.00 Spencer
Tepp
$60,000.00
Sanchez
$50,000.00 Watson
$40,000.00 Cole
Lockett
$30,000.00
Jones
$20,000.00 Cole
$10,000.00 Banks
Keller
$-
Total
6-Month Sales Analysis , 5%
Keller, $467.95 , 5% Spencer, $422.40 , Tepp, $463.30
4%
Sanchez, $530.15 ,
5% Spencer
Banks, $1,309.65 ,
Tepp
13%
Sanchez
Watson, $1,339.30 ,
Watson
14%
Cole
Cole, $2,899.85 , Lockett
30% Cole, $1,308.90 ,
Jones
13%
Cole
Banks
Keller
Lockett, $559.45 ,
6%
Jones, $439.65 , 5%
Spencer
Tepp
Sanchez
Watson
Cole
Lockett
Jones
Cole
Banks
Keller
Pay Schedule
Employee Name Hourly Rate Regular Hours Overtime HoursGross Pay Tax Witholdings Net Pay
Jesse Spencer 8.25 36 5 $ 358.88 $ 118.43 $ 240.45
Veronica Tepp 8.25 35 7 $ 375.38 $ 123.87 $ 251.50
Jason Sanchez 8.25 33 8 $ 371.25 $ 122.51 $ 248.74
Noah Watson 8.25 40 5 $ 391.88 $ 129.32 $ 262.56
Lydia Cole 8.25 40 6 $ 404.25 $ 133.40 $ 270.85
Kimberly Lockett 8.25 36 7 $ 383.63 $ 126.60 $ 257.03
Tommy Jones 8.25 32 5 $ 325.88 $ 107.54 $ 218.34
Elizabeth Cole 8.25 40 8 $ 429.00 $ 141.57 $ 287.43
Jennifer Banks 8.25 38 6 $ 387.75 $ 127.96 $ 259.79
Candyce Keller 8.25 30 3 $ 284.63 $ 93.93 $ 190.70
Total 360 60 $ 3,712.50 $ 1,225.13 $ 2,487.38
Tax Witholding % 33%
OT Rate 1.5
Saving Club 5.00%
Years Worked 8
Payroll
Years Club Taxable
ID First Name Last Name Employed Status Benefit Elegible Contribution Gross Payroll Gross
1200 Jesse Spencer 5 Part No 0% $ 358.88 $ 358.88
1201 Veronica Tepp 3 Part No 0% $ 375.38 $ 375.38
1202 Jason Sanchez 9 Part Yes 5% $ 371.25 $ 352.69
1203 Noah Watson 10 Full Yes 5% $ 391.88 $ 372.28
1204 Lydia Cole 9 Full Yes 5% $ 404.25 $ 384.04
1205 Kimberly Lockett 6 Part No 0% $ 383.63 $ 383.63
1206 Tommy Jones 1 Part No 0% $ 325.88 $ 325.88
1207 Elizabeth Cole 10 Full Yes 5% $ 429.00 $ 407.55
1208 Jennifer Banks 9 Part Yes 5% $ 387.75 $ 368.36
1209 Candyce Keller 2 Part No 0% $ 284.63 $ 284.63
Sales Limit $ 1,500.00
Years Worked 5%
6-Month Sales Analysis
ID First Name Last Name Jan Feb March April May June Total Bonus
1200 Jesse Spencer $ 1,356.00 $ 1,456.00 $ 1,423.00 $ 1,512.00 $ 1,345.00 $ 1,356.00 $ 8,448.00 $ 422.40
1201 Veronica Tepp $ 1,500.00 $ 1,545.00 $ 1,543.00 $ 1,567.00 $ 1,521.00 $ 1,590.00 $ 9,266.00 $ 463.30
1202 Jason Sanchez $ 1,789.00 $ 1,734.00 $ 1,790.00 $ 1,778.00 $ 1,789.00 $ 1,723.00 $ 10,603.00 $ 530.15
1203 Noah Watson $ 4,467.00 $ 4,456.00 $ 4,478.00 $ 4,440.00 $ 4,478.00 $ 4,467.00 $ 26,786.00 $ 1,339.30
1204 Lydia Cole $ 4,356.00 $ 4,334.00 $ 4,389.00 $ 4,398.00 $ 4,356.00 $ 4,345.00 $ 26,178.00 $ 1,308.90
1205 Kimberly Lockett $ 1,856.00 $ 1,867.00 $ 1,878.00 $ 1,894.00 $ 1,838.00 $ 1,856.00 $ 11,189.00 $ 559.45
1206 Tommy Jones $ 1,456.00 $ 1,489.00 $ 1,478.00 $ 1,436.00 $ 1,478.00 $ 1,456.00 $ 8,793.00 $ 439.65
1207 Elizabeth Cole $ 9,689.00 $ 9,678.00 $ 9,638.00 $ 9,629.00 $ 9,674.00 $ 9,689.00 $ 57,997.00 $ 2,899.85
1208 Jennifer Banks $ 4,345.00 $ 4,398.00 $ 4,350.00 $ 4,387.00 $ 4,368.00 $ 4,345.00 $ 26,193.00 $ 1,309.65
1209 Candyce Keller $ 1,546.00 $ 1,549.00 $ 1,598.00 $ 1,536.00 $ 1,584.00 $ 1,546.00 $ 9,359.00 $ 467.95
Total $ 32,360.00 $ 32,506.00 $ 32,565.00 $ 32,577.00 $ 32,431.00 $ 32,373.00 $ 194,812.00 $ 9,740.60