Scribd Logo
Upload

Welcome to Scribd!

  • 191 views

    Home Test

    Uploaded by

    Selina Chen
    This document contains payroll information for multiple employees, including names, addresses, salary and deduction information. It also includes tables of annual tax withholding amounts for Social Security, Medicare, federal, state and local income taxes, and state unemployment taxes. The tables provide totals for each tax withholding for the given pay periods.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Home Test

    Uploaded by

    Selina Chen
    191 views22 pages
    This document contains payroll information for multiple employees, including names, addresses, salary and deduction information. It also includes tables of annual tax withholding amounts for Social Security, Medicare, federal, state and local income taxes, and state unemployment taxes. The tables provide totals for each tax withholding for the given pay periods.

    Original Description:

    Chapter 4

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains payroll information for multiple employees, including names, addresses, salary and deduction information. It also includes tables of annual tax withholding amounts for Social Security, Medicare, federal, state and local income taxes, and state unemployment taxes. The tables provide totals for each tax withholding for the given pay periods.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    191 views22 pages

    Home Test

    Uploaded by

    Selina Chen
    This document contains payroll information for multiple employees, including names, addresses, salary and deduction information. It also includes tables of annual tax withholding amounts for Social Security, Medicare, federal, state and local income taxes, and state unemployment taxes. The tables provide totals for each tax withholding for the given pay periods.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 22

    300

    FIC 0
    OASDI 6.20% -18.6
    HI 1.45% -4.35
    SI 0.01 -3

    274.05

    Table of Allowance Values for 2018

    Weekly 79.8 Biweekly 159.60 Semimonthly


    Quarterly 1,037.50 Semiannual 2,075.00 Annual
    172.90 Monthly 345.80
    4,150.00 Daily/Misc. 16.00
    M1 WEEKLY 1,610.00 -79.80 1,530.20 588.00 36.60 0.12 149.66
    S0 BIWEEKLY 825.00 0.00 825.00 509.00 36.70 0.12 74.62
    M0 QUART 9,630.00 0.00 9,630.00 7,650.00 476.20 0.12 713.80
    S8 SEMIMO 925.00 -1,382.20 -457.20 0.00
    S0 MONTHLY 2,875.00 0.00 2,875.00 1,102.00 79.40 0.12 292.16
    SALARY ALLOW VALUE B-C CK % Table
    S2 WKLY 675 159.60 515.40 254.00 18.30 0.12 49.67
    S3 WKLY 1960 239.40 1,720.60 1,658.00 271.08 0.24 286.10
    M1 BI-WK 1775 159.60 1,615.40 1,177.00 73.30 0.12 125.91
    M1 BI-MO 2580 172.90 2,407.10 1,275.00 79.40 0.12 215.25
    M4 MO 5380 1,383.20 3,996.80 2,550.00 158.70 0.12 332.32

    2610 0.00 2,610.00 1,767.00 185.62 0.22 371.08

    Table of Allowance Values for 2018

    Weekly 79.8 Biweekly 159.60 Semimonth 172.90 Monthly 345.80


    Quarterly 1,037.50 Semiannual 2,075.00 Annual 4,150.00 Daily/Misc. 16.00
    wage bracket
    50.00
    must use percentage method
    126.00
    215.00
    331.00
    WEEKLY 51 OASDI HI FIT SIT CIT
    SALARY WEEK 6.2% 1.45% 79.8/ 2% 1.5% NET
    S1 2524 128,724.00 0.00 36.60 459.77 50.48 37.86 1,939.292
    M3 275 14,025.00 17.05 3.99 0.00 5.50 4.13 244.338
    M3 250 12,750.00 15.50 3.63 0.00 5.00 3.75 222.125
    M5 320.25 16,332.75 19.86 4.64 0.00 6.41 4.80 284.542
    S1 450 22,950.00 27.90 6.53 33.00 9.00 6.75 366.825
    M1 560.5 28,585.50 34.75 8.13 26.00 11.21 8.41 472.004
    S0 475.5 24,250.50 29.48 6.89 45.00 9.51 7.13 377.490
    S2 890 45,390.00 55.18 12.91 76.00 17.80 13.35 714.765

    5745.250 199.718 83.306 639.770 114.905 86.179 4621.381


    rounded
    1939.29
    244.34
    222.13
    284.54
    366.83
    472
    377.49
    714.77

    4621.390
    salary 46910
    bonus 200

    200 200
    ----------------------------= ---------------------------- 306.0444
    1-0.22-0.062-0.0145-0.05 0.6535

    306.04
    FIT 22% 67.3288
    OASDI 6.20% 18.97448
    HI 1.45% 4.43758
    UT TAX 5% 15.302
    HSA 401K PRETAX OASDI HI FIT
    SINGLE, 4 ALLOW 6.20% 1.45%
    WEEKLY 930 20 100 830 57.66 13.485 71
    401K 100
    HSA 20
    MATCH 20
    SALARY SUPP TOTAL OASDI HI Supp tax Wage Brak FIT SIT
    8% 6.20% 1.45% 22.00% 1%
    S0 5000 4800.00 9800.00 607.60 142.10 1056.00 693.86 1749.86 98.00
    S1 2750 2640.00 5390.00 334.18 78.16 580.80 235.00 815.80 53.90
    M2 520 2163.20 2683.20 166.36 38.91 475.90 14.00 489.90 26.83
    S3 465 1934.40 2399.40 148.76 34.79 425.57 15.00 440.57 23.99
    M5 380 1580.80 1960.80 121.57 28.43 347.78 0.00 347.78 19.61
    S1 350 1456.00 1806.00 111.97 26.19 320.32 21.00 341.32 18.06
    M5 575 2392.00 2967.00 183.95 43.02 526.24 0.00 526.24 29.67
    M4 425 1768.00 2193.00 135.97 31.80 388.96 0.00 388.96 21.93

    10,465.00 18,734.40 29,199.40 1,810.36 423.39 4,121.57 978.86 5,100.43 291.99


    CIT Net
    1%
    98.00 7104.440 5996.22
    53.90 4054.065 4054.06
    26.83 1934.367 1934.37
    23.99 1727.290 1727.30
    19.61 1423.807 1423.80
    18.06 1290.401 1290.40
    29.67 2154.445 2154.45
    21.93 1592.416 1592.41

    291.99 21,281.23 20,173.01


    holiday bonus 100
    state 2.8%

    100 100
    ------------------------- equal --------------------- equal 148.04
    1-0.22-0.062-0.0145-0.028 0.6755

    NET 100*0.6755
    OASDI HI FIT STATE 2.3%
    6.20% 1.45% WAGE BRAK
    AGE 48 829 51.4 12.02 46 19.07 700.510
    M2
    WKLY 829 588.62 36.49415 8.534923 21 13.53815 509.048
    SALARY 43108
    SIMPLE ER 3% 375
    EE CONT 240.3846
    Oct Nov Dec
    4,18 pay 1,15,29 pay 13,27 pay
    ER OASDI 1159.40 1351.74 2027.61 1351.74
    EE OASDI 1159.40
    ER HI 271.15
    EE HI 271.15
    FIT 1870.00

    4731.10 4731.09

    Fed Dep Liability each pay 675.87


    SIT 1309
    Company Information:
    Address:4800 River Road, Philadelphia, PA 19113-5548
    Pennsylvania state identification number:00-0-1066
    Federal identification number: 00-0000972
    Philadelphia identification number:0001895

    Income Tax Information:

    The wage-bracket method is used to determine federal income tax withholding. Calculate the annual fede
    income tax withheld by using the weekly wage-bracket table and multiply the answer by 52. The other ta
    withheld are shown below.
    Employee Data Payroll Data
    Randy A. Kellison Single, 1 allowance
    54 Gradison Place $715 per week /FIT 64
    Philadelphia, PA 19113-4054 SS#: 000-00-4310
    Deduction for 401(k) plan: $50/week

    Employee Data Payroll Data


    Ralph I. Volpe Married, 1 allowance
    56 Andrews Court, Apt. 7 $785 per week /FIT 50
    Philadelphia, PA 19103-3356 SS#: 000-00-8804
    Dependent care payment: $950
    $70/week—401(k)
    Employee Data Payroll Data
    Randi A. Myer Single, 0 allowances
    770 Camac Street $885 per week/ FIT 101
    Philadelphia, PA 19101-3770 SS#: 000-00-3316
    Union dues withheld: $102

    Employee Data Payroll Data


    Kenneth T. Ford Married, 7 allowances
    338 North Side Avenue $1,350 per week / FIT 61
    Philadelphia, PA 19130-6638 SS#: 000-00-6839
    Cost of group-term life insurance
    exceeding $50,000: $262.75*
    $100/week—401(k)
    Employee Data Payroll Data
    Chrissy C. Carman Married, 3 allowances
    4900 Gladwynne Terrace $820 per week / FIT 36
    Philadelphia, PA 19127-0049 SS#: 000-00-5771
    Union dues withheld: $102

    Employee Data Payroll Data


    Hal B. Zuber Single, 1 allowance
    480-A Hopkinson Tower $790 per week / FIT 74
    Philadelphia, PA 19101-3301 SS#: 000-00-8703
    Educational assistance payments
    (job-required): $675
    $50/week—401(k)

    *The cost of excess group-term life insurance is added to gross wages for federal income tax, Social Secur
    withhold OASDI and HI tax on these amounts but are not required to withhold federal income tax. The co
    state and local taxes; therefore, it is not subject to those taxes (See Figure 4.7).

    **State unemployment tax withheld for Pennsylvania labeled as PA SUI on Form W-2 Box 14.
    Telephone number: (215) 555-0017 Fax number: (215) 555-0010

    e tax withholding. Calculate the annual federal


    and multiply the answer by 52. The other taxes

    Annual Taxes Withheld SS tax medicare tstate tax local


    Social security tax withheld $2,305.16 $17,248.57 4,034.33 8,532.68 10,813.40
    Medicare tax withheld 539.24
    State income tax withheld 1,141.40
    Local income tax withheld 1,446.64
    State unemployment tax withheld** 22.36 Box 14
    Annual Taxes Withheld
    Social security tax withheld 2,530.84
    Medicare tax withheld 591.76
    State income tax withheld 1,253.20
    Local income tax withheld 1,588.08
    State unemployment tax withheld** 24.44
    Annual Taxes Withheld
    Social security tax withheld 2,853.24
    Medicare tax withheld 667.16
    State income tax withheld 1,412.84
    Local income tax withheld 1,790.36
    State unemployment tax withheld** 27.56
    Annual Taxes Withheld
    Social security tax withheld 4,368.69
    Medicare tax withheld 1,021.97
    State income tax withheld 2,155.40
    Local income tax withheld 2,731.04

    State unemployment tax withheld** 42.12


    Annual Taxes Withheld
    Social security tax withheld 2,643.68
    Medicare tax withheld 618.28
    State income tax withheld 1,308.84
    Local income tax withheld 1,658.80
    State unemployment tax withheld** 25.48
    Annual Taxes Withheld
    Social security tax withheld 2,546.96
    Medicare tax withheld 595.92
    State income tax withheld 1,261.00
    Local income tax withheld 1,598.48
    State unemployment tax withheld** 24.44

    s wages for federal income tax, Social Security, and Medicare. Employers
    uired to withhold federal income tax. The cost is not added to gross wages for
    (See Figure 4.7).

    as PA SUI on Form W-2 Box 14.


    unempl
    166.4
    monthly
    M4 10325
    allowance 345.8
    41 S 2 8 7.5 8 9 8 5.5 46

    32 M 5 8 10 10 9 8½ 4 40
    63 M 0 8 8 8 8 8 ... 40

    54 S 1 9 8 10 8 8 4 47

    45 M 2 10 8 8 9 8 4.5 47.5

    16 S 0 8 9 10 9 8 4 48

    7 S 1 5 6 8 8 8 4 39

    28 M 3 8 8 8 8 8 ... 40

    49 M 0 8 9 8 8 9 6 48

    10 S 1 8 8 0 9 10 5 40
    OT PAY TOTAL PAY OASDI HI FIT SIT
    0.06 0.01 0.020
    12 480 108.000 588.00 36.46 8.53 39 11.76 492.25 504.01

    S 1,600.00 1600.00 99.20 23.20 32.00 1600


    13 520 520.00 32.24 7.54 34 10.40 435.82 446.22

    12 480 126.000 606.00 37.57 8.79 51 12.12 496.52 508.64

    12.5 500 140.630 640.63 39.72 9.29 26 12.81 552.81 565.62

    12.75 510 153.040 663.04 41.11 9.61 68 13.26 544.28

    12 468 468.00 29.02 6.79 34 9.36 398.19

    12 480 480.00 29.76 6.96 2 9.60 441.28

    12 480 144.000 624.00 38.69 9.05 40 12.48 536.26

    S 1450 1450.00 89.90 21.03 29.00 1450

    6968.00 671.670 7639.67 473.66 110.78 152.793 6994.50

    You might also like