PSb 4-6 Populate a Payroll Register

Complete the remaining columns of the payroll register for the five employees whose information was provided in PSb 2-4, PSb 2-12, and PSb 3-8. All employees work in a state that does not require the withholding of disability insurance, and none of the employees files a tax return under married filing separately status. Additional information for each employee is provided below:

Jimmy Troffa earns $7.80/hour, and worked 41 hours during the most recent week. He makes a 401(k) retirement plan contribution of 9.0% of gross pay each period. Jimmy Troffa is married, and claims 3 withholding allowances for both the federal and state. Jimmy Troffa voluntarily deducts life insurance of $10 and a charitable contribution of $15 each pay period. His year-to-date taxable earning for Social Security tax, prior to the current pay period, are $71,300, and he is paid with check #0800.

Tyler Thomas earns $10.90/hour, and worked 45 hours during the most recent week. He participates in a cafeteria plan, to which he pays $75 each period. Tyler Thomas is single, claims 3 federal withholding allowances, and 2 state withholding allowances. Tyler Thomas voluntarily deducts a charitable contribution of $35 each pay period. His year-to-date taxable earning for Social Security tax, prior to the current pay period, are $117,750, and he is paid with check #0801.

Ryan Brown earns $14.60/hour, and worked 48 hours during the most recent week. He does not make any voluntary deductions each period. Ryan Brown is single, and claims 2 withholding allowances for both federal and state. His year-to-date taxable earning for Social Security tax, prior to the current pay period, are $22,400, and he is paid with check #0802.

Michael Kaminski earns $16.00/hour, and worked 55 hours during the most recent week. He makes a 403(b) retirement plan contribution of 10% of gross pay each period. Michael Kaminski is single, and claims 3 withholding allowance for both federal and state. Michael Kaminski voluntarily deducts life insurance of $30 each pay period. His year-to-date taxable earning for Social Security tax, prior to the current pay period, are $79,560, and he is paid with check #0803.

Tina Baldwin earns $17.10/hour, and worked 50 hours during the most recent week. She contributes $110 to a flexible spending account each period. Tina Baldwin is married, claims 4 federal withholding allowances, and 3 state withholding allowances. Tina Baldwin voluntarily deducts life insurance of $5 and a charitable contribution of $3 each pay period. Her year-to-date taxable earning for Social Security tax, prior to the current pay period, are $120,500, and she is paid with check #0804.

Notes:

For simplicity, all calculations throughout this exercise, both intermediate and final, should be rounded to two decimal places at each calculation.

pen Directions in Popup Window Payroll Register Pay Period 07/24/2016 07130/2016 Pay Date Eamings EmployeeRegular Regular Regular Overtime Overtme Overtime Total FWT SWT Socia MedicareVol. With. Check Net Pay Security Number Rate $11.70 $16.35 $8175 $517.75 $17.00 S22.14 $ $21.90 $175.20 S 759.20 74.00 S37.96 S $24.00 $360.00 S1,000.00 85.00 45.00 S $25.65 S256.50 S940.50 S36.00 S41.53 S Hours Rate EarningsHours Earnings Earnings Name Troffa, J Thomas, T 40 Brown, R 40 Kaminski, M 40 Baldwin, T 40 $7.80 $312.00 $10.90 436.005 514.60 584.008 $16.00 s640.00 15 S17.10 s684.00 10 40 $11.70 s 323.70 $14.73 $20.07 S4.69 Totals $2,656.00 $885.15 S3,54115 S212.00 S161.36 S pen Directions in Popup Window Payroll Register Pay Period 07/24/2016 07130/2016 Pay Date Eamings EmployeeRegular Regular Regular Overtime Overtme Overtime Total FWT SWT Socia MedicareVol. With. Check Net Pay Security Number Rate $11.70 $16.35 $8175 $517.75 $17.00 S22.14 $ $21.90 $175.20 S 759.20 74.00 S37.96 S $24.00 $360.00 S1,000.00 85.00 45.00 S $25.65 S256.50 S940.50 S36.00 S41.53 S Hours Rate EarningsHours Earnings Earnings Name Troffa, J Thomas, T 40 Brown, R 40 Kaminski, M 40 Baldwin, T 40 $7.80 $312.00 $10.90 436.005 514.60 584.008 $16.00 s640.00 15 S17.10 s684.00 10 40 $11.70 s 323.70 $14.73 $20.07 S4.69 Totals $2,656.00 $885.15 S3,54115 S212.00 S161.36 S