Company Payroll
Sales Limit $ 15,000.00
Bonus 5%
ID First Name Last Name January February March
600 Vicky Li $ 2,543.00 $ 1,254.00 $ 5,632.00
601 Isabelle Lin $ 6,542.00 $ 3,621.00 $ 7,534.00
602 Tommy Cheng $ 1,253.00 $ 4,512.00 $ 2,156.00
603 Heather Smith $ 1,452.00 $ 1,123.00 $ 3,254.00
604 Allen Tang $ 2,653.00 $ 2,530.00 $ 8,567.00
605 Locki Liu $ 8,547.00 $ 5,841.00 $ 6,511.00
606 Miao Miao $ 3,214.00 $ 6,700.00 $ 5,210.00
y Payroll
April May June Total Bonus
$ 8,562.00 $ 3,621.00 $ 5,846.00 $ 27,458.00 $ 1,372.90
$ 3,571.00 $ 3,146.00 $ 5,417.00 $ 29,831.00 $ 1,491.55
$ 3,568.00 $ 3,658.00 $ 7,538.00 $ 22,685.00 $ 1,134.25
$ 2,253.00 $ 4,485.00 $ 1,020.00 $ 13,587.00 $ -
$ 4,500.00 $ 1,200.00 $ 1,311.00 $ 20,761.00 $ 1,038.05
$ 3,421.00 $ 6,514.00 $ 8,312.00 $ 39,146.00 $ 1,957.30
$ 8,650.00 $ 4,130.00 $ 7,520.00 $ 35,424.00 $ 1,771.20
Company Payroll
Employee Name Status Years Worked Health Care Retirement
Vicky Full Time 5 Yes Ret
Isabelle Full Time 6 Yes Ret
Tommy Part Time 7 No
Heather Full Time 10 Yes Ret
Allen Part Time 3 No
Locki Full Time 2 No Ret
Miao Part Time 4 No
Total 37.00
Full Time 4 Vacation $ 200.00
Part Time 3 Vision Dental $ 20.00
Years Worked 5
Company Payroll
Vacation Dental Vision 5
$ 1,000.00 $ 20.00
$ 1,200.00 $ 20.00
$ 1,400.00 $ -
$ 2,000.00 $ 20.00
$ - $ -
$ - $ -
$ - $ -
$ 5,600.00 $ 60.00
Company Payroll
Employee Name Hourly Rate Regular Hours Overtime Hours Gross Pay
Vicky $ 24.50 40.00 5.00 $ 987.50
Isabelle $ 18.90 40.00 6.00 $ 765.00
Tommy $ 16.75 40.00 7.00 $ 680.50
Heather $ 17.25 40.00 10.00 $ 705.00
Allen $ 19.50 40.00 3.00 $ 784.50
Locki $ 16.25 40.00 2.00 $ 653.00
Miao $ 9.50 40.00 4.00 $ 386.00
Total 280.00 37.00 $ 4,961.50
Tax Witholding % 33%
OT Rate 1.5
Company Payroll
Tax Withholding Net Pay
$ 325.88 $ 661.63
$ 252.45 $ 512.55
$ 224.57 $ 455.94
$ 232.65 $ 472.35
$ 258.89 $ 525.62
$ 215.49 $ 437.51
$ 127.38 $ 258.62
$ 1,637.30 $ 3,324.21