The first employee's FIT needs to use the percentage method due to the high wage over the threshold for Wage Bracket Method. For the rest of the employees, the wage bracket method. Please use the 2017 tax tables, look for the appropriate chart based on the marital status and # of exemptions and assume the 2017 OASDI cap amount is 118,500 but the Employee and Employer OASDI rates are BOTH 6.2%.

Name:

The Names of the employees are listed on the following payroll register. Employees are paid weekly. The marital status and the

number of allowances claimed are shown on the payroll register, along with each employee's weekly salary, which remained the same all year

Complete the payroll register for the payroll period ending December, 19, the 51st weekly payday. The state income tax rate is 2% of total earnings,

the city income tax rate is 1.5% of the gross earnings, and the wage-bracket method is used for the Federal Income taxes

Q Search Sheet Payroll-Chapter-04-final (05.09.18)xlsx [Shared] Home Insert Draw Page Layout Formulas Data Revie View -Share Comments Ar al Cuistom sort Fird & Filler Select s-% , s conditional Former SCI" Insert Delete Format Insert l Forma Merge&Center :::: Furl"l,ling 8sTetle Styles AC AD AE D E G H K L M N O P HOGAN THRIFT SHOP AG AF 12 13 PAYROLL REGISTER December 19, 20 -. FOR PERIOD END NG 15 16 17 18 EMPLOYEE NAME 19 DEDUCTIONS MARIT AL NO. OF FICA TOTAL NET STATU WWH FIT S ALLOW EARNINGS DI HI PAY hn, Matthew 2,272.00 20 Smith, Jennifer 275.00 21 Bullen, Catherine 250.00 22 Matthews, Mary 23 Hadt, Bonnie 24 25 W 320.25 450.00 mp, Sean 560.50 ilson, Helen 475.50 26 Gleason, Jose 890.00 27 Totals 28 Compute the employer's FICA taxes for the pay period ending December 19 29 OASDI Taxes 30 OASDI taxable earnings 5.493.25 Hl Taxes Hl taxable earnings 31 OASDI taxes HI taxes 32 35 Student Work Area Instructor Comment/Grade Area 37 38 39 40 Matthew(OASDI)$2,272.00x 50 $113,600 +2,272 $115,872 (Not over the cap) 42 43 (FIT)Must use percentage method: 201.50+25%"(2272-77.9*3)-1626] 45 Excel instructions 4-3A Practice 4-5B + 142% Q Search Sheet Payroll-Chapter-04-final (05.09.18)xlsx [Shared] Home Insert Draw Page Layout Formulas Data Revie View -Share Comments Ar al Cuistom sort Fird & Filler Select s-% , s conditional Former SCI" Insert Delete Format Insert l Forma Merge&Center :::: Furl"l,ling 8sTetle Styles AC AD AE D E G H K L M N O P HOGAN THRIFT SHOP AG AF 12 13 PAYROLL REGISTER December 19, 20 -. FOR PERIOD END NG 15 16 17 18 EMPLOYEE NAME 19 DEDUCTIONS MARIT AL NO. OF FICA TOTAL NET STATU WWH FIT S ALLOW EARNINGS DI HI PAY hn, Matthew 2,272.00 20 Smith, Jennifer 275.00 21 Bullen, Catherine 250.00 22 Matthews, Mary 23 Hadt, Bonnie 24 25 W 320.25 450.00 mp, Sean 560.50 ilson, Helen 475.50 26 Gleason, Jose 890.00 27 Totals 28 Compute the employer's FICA taxes for the pay period ending December 19 29 OASDI Taxes 30 OASDI taxable earnings 5.493.25 Hl Taxes Hl taxable earnings 31 OASDI taxes HI taxes 32 35 Student Work Area Instructor Comment/Grade Area 37 38 39 40 Matthew(OASDI)$2,272.00x 50 $113,600 +2,272 $115,872 (Not over the cap) 42 43 (FIT)Must use percentage method: 201.50+25%"(2272-77.9*3)-1626] 45 Excel instructions 4-3A Practice 4-5B + 142%