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.

Payroll Register

Pay Period

Pay Date

	Earnings							Deductions
Employee Name	Regular Hours	Regular Rate	Regular Earnings	Overtime Hours	Overtime Rate	Overtime Earnings	Total Earnings	FWT	SWT	Social Security	Medicare	Vol. With.	Check Number	Net Pay
1	40	7.80	312	1	11.70	11.70	323.70	0	14.73				0800
2	40	10.90	436	5	16.35	81.75	517.75	13	22.14				0801
3	40	14.60	584	8	21.90	175.20	759.20	59	37096				0802
4	40	16.00	640	15	24	360	1000	68	45				0803
5	40	684	684	10	25.65	256.50	940.50	29	41.53				0804
Totals: