Question

Employer's Taxes on 8/25 payroll Pay Taxes 0.6% Net FICA FICA FUTA $7,000 cap 2.15% SUTA $7,000 cap 8% Pension Plan Total Tax Expense Health Insurance 75 МС Name Chee Dali Kiesha Marie Trey YTD Earnings Gross Pay through 8/18 $ 204,000 $ 132,500 $ 54,200 $ 26,508 $ 5,580 Totals Employees' Earnings for week ended 8/25 Withholdings (deductions from gross) Federal 3% 6.2% Income Tax State $137,700 cap 1.45% With- Income FICA FICA Health holding Tax SS MC Insurance 2,100.00 210.00 164.50 75.00 1,000.00 165.00 322.40 79.75 75.00 205.00 55.20 114.08 26.68 75.00 192.00 51.60 24.94 75.00 126.00 44.40 91.76 21.46 75.00 3,623.00 526.20 634.88 317.33 375.00 Gross Pay 7,000.00 5,500.00 1,840.00 1,720.00 1,480.00 17.540.00 4,450.50 164.50 3,857.85 322.40 79.15 1,364.04 114.0% 26.08 1,269.82 106.64 24.94 1,121.38 91-76 21.46 12,063.59634.6 31733 75 75 75 75 375.00 . Amounts in green were assinnment #111

How do I fill out the rest of this table

Answer 1

A B C I J K O P 2 1 L M N Employer's Taxes on 8/25 payroll Taxes mono Total D ion Tax 6 7 8 9 10 11 12 13 Pay YTD Earnings Gross Pay Name through 8/18 Gross Pay Chee $ 204,000 $ 7,000.00 Dali $ 132,500 $ 5,500.00 Kiesha $ 54,200 $ 1,840.00 Marie $ 26,508 $ 1,720.00 Trey $ 5,580 $ 1,480.00 Totals $17,540.00 D E G H Employee's Earnings for week ended 8/25 Withholdings (deduction from gross) Federal 3% 6.20% Income Tax State $137,700 cap 1.45% With Income FICA FICA Health holding Tax SS MC Insurance $2,100.00 $210.00 $ - $164.50 $ 75.00 $1,000.00 $165.00 $ 322.40 $ 79.75 $ 75.00 $ 205.00 $ 55.20 $ 114.08 $ 26.68 $ 75.00 $ 192.00 $ 51.60 $ 106.64 $ 24.94 $ 75.00 $ 126.00 $ 44.40 $ 91.76 $ 21.46 $ 75.00 $3,623.00 $526.20 $ 634.88 $317.33 $375.00 Net FICA FICA Pay SS M C $ 4,450.50 $ - $164.50 $ 3,857.85 $322.40 $ 79.75 $ 1,364.04 $114.08 $ 26.68 $ 1,269.82 $106.64 $ 24.94 $ 1,121.38 $ 91.76 $ 21.46 $12,063.59 $634.88 $317.33 0.60% 2.15% 8% SUTA Health Pension $7,000 CAP $7,000 CAP Insurance Plan $ - $ 75.00 $ 560.00 $ - $ - $ 75.00 $ 440.00 $ - $ - $ 75.00 $ 147.20 $ - $ - $ 75.00 $ 137.60 $ 8.88 $ 31.82 $ 75.00 $ 118.40 $ 8.88 $ 31.82 $375.00 $1,403.20 Expense $ 799.50 $ 917.15 $ 362.96 $ 344.18 $ 347.32 $2,771.11

A в с ук N O P Employer's Taxes on 8/25 payroll Pay Taxes YTD Earnings 0.006 0.0215 0.08 Total Gross Pay FICA FICA FUTA SUTA T Health Pension Tax Name through 8/18 Gross Pay SSI MC $7,000 CAP $7,000 CAP Insurance Plan Expense Chee 204000 7000 =F7 =G7 =IF(B7>7000,0,07*0.6%) =IF(B7>7000,0,07*2.15%) 75 =C7*8% =SUM(J7:07) Dali 132500 5500 =F8 =G8 =IF(B8>7000,0,C8*0.6%) =IF(B8>7000,0,08*2.15%) 75 =C8*8% =SUM(18:08) Kiesha 54200 1840 =F9 =G9 =IF(B9>7000,0,C9*0.6%) =IF(B9>7000,0,C9*2.15%) 75 =C9*8% =SUM(J9:09) Marie 26508 1720 =F10 =G10 =IF(B10>7000,0,C10*0.6%) =IF(B10>7000,0,C10*2.15%) 75 =C10*8% =SUM(J10:010) Trey 5580 1480 =F11 =G11 =IF(B11>7000,0,C11*0.6%) =IF(B11>7000,0,C11*2.15% 75 =C11*8% =SUM(J11:011) Totals =SUM(C7:C11) =SUM(J7:J11) =SUM(K7:K11) =SUM(L7:L11) =SUM(M7:M11) 1=SUM(N7:N11) I=SUM(07:011) =SUM(P7:P11) | 9 11 12 13

If you have any doubts ask in comments section

Do rate the answer