Complete the remaining columns of the payroll register for the five employees whose information was provided...

Transcribed Image Text:

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-10. 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 $142,050, 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 $143,600, 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. Pay Period Pay Date Employee Name Troffa, J Thomas, T Brown, R Kaminski, M Baldwin, T Totals: 40 40 07/18/2021 40 40 40 07/24/2021 Earnings Regular Regular Regular Overtime Overtime Overtime Hours Rate Earnings Hours Rate Earnings $7.80 $10.90 $14.60 $16.00 $17.10 $ $ $312.00 1 $436.00 5 8 $584.00 $640.00 $684.00 $ $ $2,656.00 15 10 $11.70 $16.35 $21.90 $24.00 $25.65 $ $ Payroll Register $11.70 $81.75 $175.20 $360.00 $256.50 $ $ $885.15 Total Earnings $ $ $3,541.15 - FWT $14.73 $ $323.70 $517.75 $12.00 $22.14 $ $759.20 $58.00 $37.96 $ $1,000.00 $66.00 $45.00 $ $940.50 $26.00 $41.53 $ $ $ $161.36 $ S S $162.00 SWT $ $ Deductions Social Security Medicare S $ $ $ $ $ $ $ Vol. With. $25.00 $110.00 $ $30.00 $118.00 $ $ $ Check Number 0800 S $ $ 0803 S 0804 S $ $ S 0801 0802 Net Pay 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-10. 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 $142,050, 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 $143,600, 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. Pay Period Pay Date Employee Name Troffa, J Thomas, T Brown, R Kaminski, M Baldwin, T Totals: 40 40 07/18/2021 40 40 40 07/24/2021 Earnings Regular Regular Regular Overtime Overtime Overtime Hours Rate Earnings Hours Rate Earnings $7.80 $10.90 $14.60 $16.00 $17.10 $ $ $312.00 1 $436.00 5 8 $584.00 $640.00 $684.00 $ $ $2,656.00 15 10 $11.70 $16.35 $21.90 $24.00 $25.65 $ $ Payroll Register $11.70 $81.75 $175.20 $360.00 $256.50 $ $ $885.15 Total Earnings $ $ $3,541.15 - FWT $14.73 $ $323.70 $517.75 $12.00 $22.14 $ $759.20 $58.00 $37.96 $ $1,000.00 $66.00 $45.00 $ $940.50 $26.00 $41.53 $ $ $ $161.36 $ S S $162.00 SWT $ $ Deductions Social Security Medicare S $ $ $ $ $ $ $ Vol. With. $25.00 $110.00 $ $30.00 $118.00 $ $ $ Check Number 0800 S $ $ 0803 S 0804 S $ $ S 0801 0802 Net Pay