PSb 4-6 Populate a Payroll Register

Complete the remaining columns of the payroll register for the five employees whose information was provided in PSa 2-4, PSa 2-12, and PSa 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:

1. 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.
2. 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 $127,650, and he is paid with check #0801.
3. 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.
4. 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.
5. 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 $129,200, 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.