Question

2. You gathered the following data from time cards and individual employee earnings records. Your tasks are as follows: a. On December 5, 201X, prepare a payroll register for this biweekly payroll. b. Calculate the employer taxes of FICA OASDI, FICA Medicare, FUTA, and SUTA. Biweekly Salary Department Allowance and Employee Marital Status Alvin, John S-3 Gale, Nicki S-1 Malone, Jeff S-2 Seaver, Paul S-1 Cumulative Earnings Before This Payroll $37,400 47,500 64,800 4,600 $1,510 2,040 2,080 810 Check No. 30 31 32 Production Office Production Office 33 Assume the following:

Answer 1

WN - Employee 4. Alvin, John 5 Gale, Nicki 6 Malone, Jeff 7 Seaver, Paul 8 Total $ $ $ $ $ Salary 1,510.00 2,040.00 2,080.00 810.00 6,440.00 J K L M N O Payroll Register for this biweekly payroll Federal State FICA FICA Union Net Income Tax Income Tax OASDI Medicare Dues Pay $ 674.00 $ 45.30 $ 93.62 $ 21.90 $ 18.00 $ 657.19 $ 651.00 $ 61.20 $ 126.48 $ 29.58 $ 18.00 $ 1,153.74 $ 953.00 $ 62.40 $ 128.96 $ 30.16 $ 18.00 $ 887.48 $ 165.00 $ 24.30 $ 50.22 $11.75 $ 18.00 $ 540.74 $ 2,443.00 $ 193.20 $ 399.28 $ 93.38 $ 72.00 $3,239.14 10 11 Employee 12 13 Alvin, John 14 Gale, Nicki 15 Malone, Jeff 16 Seaver, Paul 17 Total 18 Cummulative Salary Earnings $ 37,400.00 $1,510.00 $ 47,500.00 $2,040.00 $ 64,800.00 $2,080.00 $ 4,600.00 $ 810.00 $6,440.00 Employer Taxes FICA FICA Payroll SUTA FUTA OASDI Medicare Expenses $ 93.62 $ 21.90 $ - $ - $ 115.52 $ 126.48 $ 29.58 $ - $ - $ 156.06 $ 128.96 $ 30.16 $ - $ - $ 159.12 $ 50.22 $ 11.75 $ 43.74 $ 6.48 $ 112.19 $ 399.28 $ 93.38 $ 43.74 $ 6.48 $ 542.88

sta J K M NO 1 Payroll Register for this biweekly payroll Federal State FICA FICA Union Net ? Employee Salary 3 Income Tax Income Tax OASDI Medicare Dues Pay 4. Alvin, John 1510 =B26 =14*$C$12 =14*$C$10 =14*$C$11. =$D$13 =14-SUM(J4:N4) 5 Gale, Nicki 2040 =C26 1=15*$C$12 =15*$C$10 =15*$C$11 =$D$13 =15-SUM(J5:N5) 6 Malone, Jeff 2080 =D26 =16*$C$12 =16*$C$10 =16*$C$11 =$D$13 =16-SUM(J6:N6) 7 Seaver, Paul 810 =E26 =17*$C$12 1=17*$C$10 1-17* =17*$C$11 1 =$D$13 =17-SUM(J7:N7) 8 Total =SUM(14:17) =SUM(J4:17) =SUM(K4:K7) =SUM(L4:L 7) =SUM(M4:M7) =SUM(N4:N7) =SUM(04:07) 9 Employer Taxes 11 Cummulative I FICA FICA Payroll Employee Salary SUTA FUTA 12 | Earnings OASDI Medicare Expenses 13 Alvin, John 37400 1510 =J13*$C$10 =J13*$C$11 =IF(113>7000,0,313*$C$14) =IF(113>7000,0,313*$C$15) =SUM(K13:N13) 14 Gale, Nicki 47500 2040 =J14*$C$10 =J14*$C$11 =IF(114>7000,0.J14*$C$14) =IF(114>7000,0.J14*$C$15) =SUM(K14:N14) 15 Malone, Jeff 64800 2080 =J15*$C$10 =J15*$C$11 =IF(115>7000,0,J15*$C$14) =IF(115>7000,0,J15*$C$15) =SUM(K15:N15) 16 Seaver, Paul 4600 810 =J16*$C$10 =J16*$C$11 =IF(116>7000,0,J16*$C$14) =IF(116>7000,0,J16*$C$15) =SUM(K16:N16) 17 Total =SUM(J13:116) =SUM(K13:K16) =SUM(L 13:L16) =SUM(M13:M16) =SUM(N13:N16) =SUM(013:016) 10 18

F 1 А В Allowance and Cummulative Earnings Biweekly 2 Employee Marital Status Before this payroll Salary 3 Alvin, John S-3 37,400 $ 1,510 4. Gale, Nicki S-1 47,500 $ 2,040 5 Malone, Jeff S-2 64,800 $ 2,080 6 Seaver, Paul S-1 $ 4,600 $ 810 C heck No. Dept. 30 Production 31 Office 32 Production 33 Office Employer and Employee Deductions Deductions Tax Rate Earnings 10 FICA OASDI 6.20% $ 106,800 11 FICA Medicare 1.45% all earnings 12 State income tax 3% of gross pay 13 Union Dues $ 18 Biweekly 14 SUTA 5.40% $ 7,000 15 FUTA 0.80% $ 7,000 16 Federal income tax 18 Employee Alvin, John Gale, Nicki Malone, Jeff Seaver, Paul 19 Salary $ 1,510 $ 2,040 $ 2,080 $ 810 20 At least $ 1,500 $ 2,040 $ 2,080 $ 800 21 But less $ 5,120 $ 2,060 $ 2,100 $ 820 22 S-O $ 208 $ 343 $ 353 $ 93 23 S-1 177 $ 308$ 318$ 72 24 S-2 $ 155 / $ 282 | 25 S-3 $ 134 26 Total $ 674 $ 651 $ 953 $ 165 27

If you have any doubts ask in comments section

Do rate the answer