CPP 6-1 Complete 4th Quarter and Year-End Payroll Reporting (#1)

Calculate total federal income tax, Social Security tax, and Medicare tax for the 4th quarter. Assume that Zachary Fox earns the same amount for each of the final three weeks of the year (the only weeks in 2019 during which he worked) and that Calvin Bell earned the same amount during each of the 52 weeks of the year. Further assume that no changes to voluntary deductions were requested by any employee during 2019. Note that the final week of the year (beginning on December 23, 2019) is a full workweek (the 52nd workweek of 2019).

Notes:For simplicity, all calculations throughout this exercise, both intermediate and final, should be rounded to two decimal places at each calculation.

FWT Social Security Medicare Fox $ $ Bell $ $ Alexander $ $ Sierra $ $ $ $ Name Employee Earnings Record Marital Status Married Fed. Withholding Allow State Withholding Allow. Zachary Fox 1483 Independence Road Durham, NC 27701 121-21-2121 Address 4 SS= Earnings Deductions Pay Period Ending Regular Hours Worked 8 Regular Pay Rate Regular Wages Overtime Hours Worked 8 Overtime Pay Rate 8 Overtime Wages 8 Federal Withholding Tax State Withholding Tax 2 Social Security Tax Gross Pay & Medicare Tax Retirement Contribution 8 Life Insurance 8 Charitable Contribution Additional Withholding Check Number Net Pay 12/15/2019 40 $28.00 1 $58.10 $7.00 092 $916.01 $1,120.00 S $42.00 s $1,162.00 $ $67.00 Is $16.85 Is $15.00 Is $10.00 Is MMDOMY $ $ s 1s s IS IS MMDOMY $ IS Is IS Is IS s $ $ IS $ IS Is IS MMDOMY Is IS Is Is Is Is Is Is s IS s IS Is Is MMODITY S IS Is IS Is IS Is Is IS Is IS IS IS MMDOMY s s $ s Is s Is Is IS s S IS IS Is MMDOMY IS S s IS $ IS Is IS S S IS IS IS S Payroll Register Pay Period 12/15/2019 12/19/2019 Pay Date Earnings Deductions Employee Regular Regular Overtime Overtime Overtime Total FWT SWT Social Medicare Vol. With Check Net Pay Regular Earnings Name Hours Rate Hours Rate Earnings Earnings Security Number Fox, Z 40 $28.00 $1,120.00 1 $42.00 $42.00 $1,162.00 $67.00 $58.10 $72.04 $16.85 $32.00 092 $916.01 Bell , C 40 $7.30 $292.00 11.5 $10.95 $125.93 $417.93 $16.00 $19.64 $25.91 $6.06 $47.08 093 $303.24 Alexander, D n/a n/a $4,050.00 n/a n/a $4,050.00 $731.96 $178.20 $ $81.23 $506.00 094 $2,552.61 Sierra, M n/a n/a $2,450.00 n/a n/a $2,450.00 $247.70 $120.00 $148.80 $34.80 $75.00 095 $1,823.70 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Totals: $7,912.00 $167.93 $8,079.93 $1,062.66 $375.94 $246.75 $138.94 $660.08 $5,595.56 These employee earnings records display year-to-date earnings prior to the current pay period. Therefore the "4th Quarter" row excludes the final three weeks of the year (the current pay period, and the subsequent two pay periods). Note that the current pay period is the first pay period for Zachary Fox (SSN 121-21-2121, address: 1483 Independence Road, Durham, NC 27701); therefore, his employee earnings record is not provided, as it contains no previous earnings information Employee Earnings Record Name Calvin Bell Marital Status Single Address 2 2222 Sacker Place Durham, NC 27701 Fed. Withholding Allow. State Withholding Allow. 1 SSH 500-00-0000 Earnings Deductions ay Period Ending Regular Pay Rate Wages vertime Hours Worked Overtime Pay Rate vertime Wages ederal Withholding State Withholding Tax ife Insurance aritable Contribution iross Pay deitional Withholding Check Number n/a n/a 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter n/a n/a n/a n/a n/a n/a n/a n/a $ 3,796.00 $ 3,796.00 $ 3,796.00 $ 2,920.00 n/a $ 1,637.09 S 5,433.09 S 208.00 S 255.32 $ 336.83 $ 78.78 S 326.04S n/a $ 1,637.09 $ 5,433.09 $ 208.00 $ 255.32 $ 336.83 $ 78.78 $ 326.04S n/a $ 1,637.09 $ 5,433.09 $ 208.00 $ 255.32 $ 336.83 $ 78.78 $ 326.04 n/a $ 1,259.30 S 4,179.30 $ 160.00 $ 196.40 $ 259.10 $ 60.60 $ 250.80$ $ 195.00$ 91.00 $ 195.00 $ 91.00 $ 195.00$ 91.00 $ 150.00 $ 70.00 $ 3,942.12 $ 3,942.12 $ 3,942.12 $ 3,032.40 n/a n/a Employee Earnings Record Name David Alexander Single Address 1 Freedom Blvd. Durham, NC 27701 Marital Status Fed. Withholding Allow. State Withholding Allow. 1 1 SSH 454-54-5454 Earnings Deductions Period Ending egular Hours Worked Regular Pay Rate egular Wages Overtime Wages Federal Withholding Tax e Withholding 1 al Security Tax fosse Medicare Tax Check Number - - 1st Quarter n/a 2nd Quarter n/a 3rd Quarter n/a 4th Quarter n/a n/a n/a n/a n/a $ 52,650.00 n/a $ 52,650.00 n/a $ 52,650.00 n/a $ 40,500.00 n/a n/a n/a n/a n/a $ $ S $ $ 52,650.00 $ 9,515.48$ 2,316.60 $ 3.264.30 $ 763.49 $ 6,318.00 S $ 52,650.00$ 9,515.48$ 2,316.60 $ 3,264.30 $763.49 $ 6,318.00 S $ 52,650.00 S 9.515.48S 2,316.60 $ 1.711.20 S 763.49 $ 6,318.00 S $ 40,500.00 $ 7,319.60 $ 1,782.00 $ $ 587.30 $ 4,860.00 $ $ 260.00 $ $ 260.00 $ $ 260.00 $ 200.00 $ $ 30,212.13 $ 30,212.13 $ 31,765.23 $ 25,751.10 Name Employee Earnings Record Marital Status Fed. Withholding Allow. State Withholding Allow. Married Michael Sierra 200 Mississippi Road Durham, NC 27701 Address 4 3 SSH 232-32-3232 Earnings Deductions ay Period Ending 333 Regular Hours Worked Regular Pay Rate tegular Wages time Hours Overtime Pay Rate Overtime Wages ederal Withholding Tax State Withholding Tax Gross Pay ocial Security Tax Medicare Tax etirement Contribution Check Number - 1st Quarter n/a 2nd Quarter n/a 3rd Quarter n/a 4th Quarter n/a n/a n/a n/a n/a $ 31,850.00 $ 31,850.00 $ 31,850.00 $ 24,500.00 n/a n/a n/a n/a n/a $ n/a $ n/a $ n/a $ $ 31,850.00 $ 3,220.10 S 1,560.00 $ 1,934.40 $452.40 $ 31,850.00$ 3,220.10 $ 1.560.00 $ 1,934.40 $452.40 $ $ 31,850.00 $3,220.10 $ 1.560.00 $ 1,934.40 $452.40$ $ 24,500.00 $ 2,477.00 $ 1,200.00 $ 1,488.00 $ 348.00 $ $260.00 $65.00 $ 650.00 $ 260.00 $ 65.00 $ 650.00 $ 260.00 $ 65.00 $ 650.00 $ 200.00 $ 50.00 500.00 $ 23,708.10 $ 23,708.10 $ 23,708.10 $ 18,237.00 - FWT Social Security Medicare Fox $ $ Bell $ $ Alexander $ $ Sierra $ $ $ $ Name Employee Earnings Record Marital Status Married Fed. Withholding Allow State Withholding Allow. Zachary Fox 1483 Independence Road Durham, NC 27701 121-21-2121 Address 4 SS= Earnings Deductions Pay Period Ending Regular Hours Worked 8 Regular Pay Rate Regular Wages Overtime Hours Worked 8 Overtime Pay Rate 8 Overtime Wages 8 Federal Withholding Tax State Withholding Tax 2 Social Security Tax Gross Pay & Medicare Tax Retirement Contribution 8 Life Insurance 8 Charitable Contribution Additional Withholding Check Number Net Pay 12/15/2019 40 $28.00 1 $58.10 $7.00 092 $916.01 $1,120.00 S $42.00 s $1,162.00 $ $67.00 Is $16.85 Is $15.00 Is $10.00 Is MMDOMY $ $ s 1s s IS IS MMDOMY $ IS Is IS Is IS s $ $ IS $ IS Is IS MMDOMY Is IS Is Is Is Is Is Is s IS s IS Is Is MMODITY S IS Is IS Is IS Is Is IS Is IS IS IS MMDOMY s s $ s Is s Is Is IS s S IS IS Is MMDOMY IS S s IS $ IS Is IS S S IS IS IS S Payroll Register Pay Period 12/15/2019 12/19/2019 Pay Date Earnings Deductions Employee Regular Regular Overtime Overtime Overtime Total FWT SWT Social Medicare Vol. With Check Net Pay Regular Earnings Name Hours Rate Hours Rate Earnings Earnings Security Number Fox, Z 40 $28.00 $1,120.00 1 $42.00 $42.00 $1,162.00 $67.00 $58.10 $72.04 $16.85 $32.00 092 $916.01 Bell , C 40 $7.30 $292.00 11.5 $10.95 $125.93 $417.93 $16.00 $19.64 $25.91 $6.06 $47.08 093 $303.24 Alexander, D n/a n/a $4,050.00 n/a n/a $4,050.00 $731.96 $178.20 $ $81.23 $506.00 094 $2,552.61 Sierra, M n/a n/a $2,450.00 n/a n/a $2,450.00 $247.70 $120.00 $148.80 $34.80 $75.00 095 $1,823.70 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Totals: $7,912.00 $167.93 $8,079.93 $1,062.66 $375.94 $246.75 $138.94 $660.08 $5,595.56 These employee earnings records display year-to-date earnings prior to the current pay period. Therefore the "4th Quarter" row excludes the final three weeks of the year (the current pay period, and the subsequent two pay periods). Note that the current pay period is the first pay period for Zachary Fox (SSN 121-21-2121, address: 1483 Independence Road, Durham, NC 27701); therefore, his employee earnings record is not provided, as it contains no previous earnings information Employee Earnings Record Name Calvin Bell Marital Status Single Address 2 2222 Sacker Place Durham, NC 27701 Fed. Withholding Allow. State Withholding Allow. 1 SSH 500-00-0000 Earnings Deductions ay Period Ending Regular Pay Rate Wages vertime Hours Worked Overtime Pay Rate vertime Wages ederal Withholding State Withholding Tax ife Insurance aritable Contribution iross Pay deitional Withholding Check Number n/a n/a 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter n/a n/a n/a n/a n/a n/a n/a n/a $ 3,796.00 $ 3,796.00 $ 3,796.00 $ 2,920.00 n/a $ 1,637.09 S 5,433.09 S 208.00 S 255.32 $ 336.83 $ 78.78 S 326.04S n/a $ 1,637.09 $ 5,433.09 $ 208.00 $ 255.32 $ 336.83 $ 78.78 $ 326.04S n/a $ 1,637.09 $ 5,433.09 $ 208.00 $ 255.32 $ 336.83 $ 78.78 $ 326.04 n/a $ 1,259.30 S 4,179.30 $ 160.00 $ 196.40 $ 259.10 $ 60.60 $ 250.80$ $ 195.00$ 91.00 $ 195.00 $ 91.00 $ 195.00$ 91.00 $ 150.00 $ 70.00 $ 3,942.12 $ 3,942.12 $ 3,942.12 $ 3,032.40 n/a n/a Employee Earnings Record Name David Alexander Single Address 1 Freedom Blvd. Durham, NC 27701 Marital Status Fed. Withholding Allow. State Withholding Allow. 1 1 SSH 454-54-5454 Earnings Deductions Period Ending egular Hours Worked Regular Pay Rate egular Wages Overtime Wages Federal Withholding Tax e Withholding 1 al Security Tax fosse Medicare Tax Check Number - - 1st Quarter n/a 2nd Quarter n/a 3rd Quarter n/a 4th Quarter n/a n/a n/a n/a n/a $ 52,650.00 n/a $ 52,650.00 n/a $ 52,650.00 n/a $ 40,500.00 n/a n/a n/a n/a n/a $ $ S $ $ 52,650.00 $ 9,515.48$ 2,316.60 $ 3.264.30 $ 763.49 $ 6,318.00 S $ 52,650.00$ 9,515.48$ 2,316.60 $ 3,264.30 $763.49 $ 6,318.00 S $ 52,650.00 S 9.515.48S 2,316.60 $ 1.711.20 S 763.49 $ 6,318.00 S $ 40,500.00 $ 7,319.60 $ 1,782.00 $ $ 587.30 $ 4,860.00 $ $ 260.00 $ $ 260.00 $ $ 260.00 $ 200.00 $ $ 30,212.13 $ 30,212.13 $ 31,765.23 $ 25,751.10 Name Employee Earnings Record Marital Status Fed. Withholding Allow. State Withholding Allow. Married Michael Sierra 200 Mississippi Road Durham, NC 27701 Address 4 3 SSH 232-32-3232 Earnings Deductions ay Period Ending 333 Regular Hours Worked Regular Pay Rate tegular Wages time Hours Overtime Pay Rate Overtime Wages ederal Withholding Tax State Withholding Tax Gross Pay ocial Security Tax Medicare Tax etirement Contribution Check Number - 1st Quarter n/a 2nd Quarter n/a 3rd Quarter n/a 4th Quarter n/a n/a n/a n/a n/a $ 31,850.00 $ 31,850.00 $ 31,850.00 $ 24,500.00 n/a n/a n/a n/a n/a $ n/a $ n/a $ n/a $ $ 31,850.00 $ 3,220.10 S 1,560.00 $ 1,934.40 $452.40 $ 31,850.00$ 3,220.10 $ 1.560.00 $ 1,934.40 $452.40 $ $ 31,850.00 $3,220.10 $ 1.560.00 $ 1,934.40 $452.40$ $ 24,500.00 $ 2,477.00 $ 1,200.00 $ 1,488.00 $ 348.00 $ $260.00 $65.00 $ 650.00 $ 260.00 $ 65.00 $ 650.00 $ 260.00 $ 65.00 $ 650.00 $ 200.00 $ 50.00 500.00 $ 23,708.10 $ 23,708.10 $ 23,708.10 $ 18,237.00