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 2020 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 2020. Note that the final week of the year (beginning on December 21, 2020) is a full workweek (the 52nd workweek of 2020).

Notes:

• For simplicity, all calculations throughout this exercise, both intermediate and final, should be rounded to two decimal places at each calculation.
• Tip!: Recall that the Additional Withholding amount for Michael Sierra is comprised of flexible spending account contributions. You should consider whether these are taxable when completing the necessary forms and calculations.
• 

Pay Period 12/13/2020 12/17/2020 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 $84.54 $58.10 $72.04 $16.85 $32.00 092 $898.47 Bell, C 40 $7.30 $292.00 11.5 $10.95 $125.93 $417.93 $15.00 $19.64 $25.91 $6.06 $47.08 093 $304.24 1 Alexander, D n/a n/a $4,050.00 n/a n/a $4,050.00 $725.46 $178.20 $ $81.23 $506.00 094 $2,559.11 Sierra, M n/a n/a $2,450.00 n/a n/a $2,450.00 $242.68 $120.00 $148.80 $34.80 $75.00 095 $1,828.72 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Totals $7,912.00 $167.93 $8.079.93 $1,067.68 $375.94 $246.75 $138.94 $660.08 $5,590.54 Employee Earnings Record Name Zachary Fox Marital Status Married Address Fed. Withholding Allow. n/a 1483 Independence Road Durham, NC 27701 State Withholding Allow n/a SS# 121-21-2121 Earnings Deductions 40 $28.00 $1,120.00 $42.00 $1,162.00 $84.54 $58.10 $72.04 $16.85 $15.00 $10.00 $7.00 092 $898.47 12/17/2020 MMDD/YYYY MMDD/YYYY $42.00 $ $ $ IS IS $ $ S $ $ IS Employee Earnings Record Name Calvin Bell Marital Status Single Address Fed. Withholding Allow. 2 2222 Sacker Place Durham, NC 27701 State Withholding Allow 1 #SS 500-00-0000 Earnings Deductions Pay Period Ending Regular Hours Worked Regular Pay Rate Regular Wages Overtime Hours Worked Overtime Pay Rate & Overtime Wages & Federal Withholding Tax State Withholding Tax Gross Pay Social Security Tax 8 Medicare Tax IS Retirement Contribution Life Insurance 8 Charitable Contribution 8 Additional Withholding Check Number Net Pay 12/17/2020 S292.00 11.5 $10.95 $125.93 $417.93 $15.00 $25.91 $25.08 $15.00 1093 $303.24 MMDD/YYYY MMDD/YYYY Employee Earnings Record Name Michael Sierra Marital Status Married Address Fed. Withholding Allow 4 200 Mississippi Road Durham, NC 27701 State Withholding Allow. 3 SS# 232-32-3232 Earnings Deductions Pay Period Ending Regular Hours Worked Regular Pay Rate Regular Wages Overtime Hours Worked Overtime Pay Rate Overtime Wages Federal Withholding Tax State Withholding Tax Social Security Tax 8 Medicare Tax Retirement Contribution Gross Pay Charitable Contribution 8 Life Insurance & Additional Withholding Check Number Net Pay n/a In/a S2,450.00 In/a Ina S2 450.00 5242.68 $120.00 $148.80 $34 80 $20.00 $5.00 1095 $1,828.72 . 12/17/2020 MMDD/YYYY A Employee Earnings Record Name Calvin Bell Marital Status Single Address Fed. Withholding Allow. 2 2222 Sacker Place Durham, NC 27701 State Withholding Allow. 1 SS# 500-00-0000 Earnings Deductions Pay Period Ending 333 Regular Hours Worked SBS Regular Pay Rate Regular Wages 33 Overtime Hours Worked 233ROvertime Pay Rate ollOvertime Wages Federal Withholding Tax BMC State Withholding Tax Social Security Tax Medicare Tax CSSS Retirement Contribution Life Insurance Charitable Contribution 99 Additional Withholding Check Number 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 n/a n/a n/a n/a n/a n/a n/a $ 1,637.09 $ 5,433.09 $ 195.00 $ 255.32 $ 336.83 $ 78.78 $ 326.04S $ 1,637.09$ 5,433.09 $ 195.00 $ 255.32S 336.83$ 78.78 S 326.04S $ 1,637.09 $ 5,433.09 $ 195.00 $ 255.32 $ 336.83 $ 78.78 $ 326.04S $ 1,259.30 $ 4,179.30 $ 150.00 $ 196,40 $ 259.10 $ 60.60 $ 250.80S $ 195,00 $ 91.00 $ 195,00 S 91.00 $ 195.00$ 91.00 $ 150.00 $ 70.00 $ 3,955.12 $ 3,955.12 $ 3,955.12 $ 3,042.40 Employee Earnings Record Marital Status Name David Alexander Single Address 1 1 Freedom Blvd. Durham, NC 27701 Fed. Withholding Allow. State Withholding Allow. 1 55# 454-54-5454 Earnings Deductions 2Pay Period Ending 3333 Regular Hours Worked U SEBB Regular Pay Rate Regular Wages S33 Overtime Hours Worked 3 3 3 3 overtime Pay Rate Overtime Wages Federal Withholding Tax State Withholding Tax Socia Security Tax Life Insurance la Medicare Tax Retirement Contribution gaCharitable Contribution Additional Withholding Check Number S 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter n/a n/a n/a na na na na nda $ 52,650.00 $ 52,650.00 $ 52,650.00 $ 40,500.00 n/a n/a n/a n/a uten $ 52,650.00 S 9,430.98 $ 2,316.60 $3,264.30 $ 763.49 $ 6,318.00 $ $ 52,650.00 $ 9,430.98 $ 2,316.60 $ 3,264.30 $ 763.49 $ 6,318.00 $ $ 52,650.00 $ 9,430.98 S 2.316.60 $ 2,008.80 $763.49 $ 6,318.00 S $ 40,500.00 $ 7,254.60 $ 1,782.00 S $ 587.30 $4,860.00 $ $ 260.00 $ $ 260.00 S $260.00 S $ 200.00 $ S 30.296.63 $ 30,296.63 S 31,552.13 S 25,816.10 - n/a na 5 $ - Employee Earnings Record Name Michael Sierra Marital Status Married Address Fed. Withholding Allow. 4 200 Mississippi Road Durham, NC 27701 State Withholding Allow. 3 SS# 232-32-3232 Earnings Deductions Pay Period Ending SIR Regular Hours Worked SISISIS Regular Pay Rate Sala Regular Wages BBBB Overtime Hours Worked BBB Overtime Pay Rate Overtime Wages A Federal Withholding Tax State Withholding Tax lo Social Security Tax 99 Medicare Tax Retirement Contribution 818 18 Life Insurance lalala Charitable Contribution lella Additional Withholding Check Number n/a 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter n/a n/a n/a n/a n/a n/a na n/a $ 31,850.00 $ 31,850.00 $ 31,850.00 $ 24,500.00 n/a n/a n/a n/a $ $ $ $ $ 31,850.00 $ 3.154.84$ 1,560.00 $ 1,934.40 $452.40 $ $ 31,850.00 $ 3,154.84$ 1,560.00 $ 1,934.40 $452.40 $ $ 31,850.00$ 3,154.84$ 1,560.00 $ 1,934.40 $452.40$ $ 24,500.00 $ 2,426.80 $ 1,200.00 $ 1,488.00$ 348.00 $ $ 260.00 $ 65.00 $ 650.00 $ 260.00 $ 65,00 $ 650.00 $ 260,00 $ 65,00 S 650.00 $ 200.00 $ 50.00 $ 500.00 $ 23,773.36 $ 23,773.36 $ 23,773.36 $ 18,287.20 - - Pay Period 12/13/2020 12/17/2020 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 $84.54 $58.10 $72.04 $16.85 $32.00 092 $898.47 Bell, C 40 $7.30 $292.00 11.5 $10.95 $125.93 $417.93 $15.00 $19.64 $25.91 $6.06 $47.08 093 $304.24 1 Alexander, D n/a n/a $4,050.00 n/a n/a $4,050.00 $725.46 $178.20 $ $81.23 $506.00 094 $2,559.11 Sierra, M n/a n/a $2,450.00 n/a n/a $2,450.00 $242.68 $120.00 $148.80 $34.80 $75.00 095 $1,828.72 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Totals $7,912.00 $167.93 $8.079.93 $1,067.68 $375.94 $246.75 $138.94 $660.08 $5,590.54 Employee Earnings Record Name Zachary Fox Marital Status Married Address Fed. Withholding Allow. n/a 1483 Independence Road Durham, NC 27701 State Withholding Allow n/a SS# 121-21-2121 Earnings Deductions 40 $28.00 $1,120.00 $42.00 $1,162.00 $84.54 $58.10 $72.04 $16.85 $15.00 $10.00 $7.00 092 $898.47 12/17/2020 MMDD/YYYY MMDD/YYYY $42.00 $ $ $ IS IS $ $ S $ $ IS Employee Earnings Record Name Calvin Bell Marital Status Single Address Fed. Withholding Allow. 2 2222 Sacker Place Durham, NC 27701 State Withholding Allow 1 #SS 500-00-0000 Earnings Deductions Pay Period Ending Regular Hours Worked Regular Pay Rate Regular Wages Overtime Hours Worked Overtime Pay Rate & Overtime Wages & Federal Withholding Tax State Withholding Tax Gross Pay Social Security Tax 8 Medicare Tax IS Retirement Contribution Life Insurance 8 Charitable Contribution 8 Additional Withholding Check Number Net Pay 12/17/2020 S292.00 11.5 $10.95 $125.93 $417.93 $15.00 $25.91 $25.08 $15.00 1093 $303.24 MMDD/YYYY MMDD/YYYY Employee Earnings Record Name Michael Sierra Marital Status Married Address Fed. Withholding Allow 4 200 Mississippi Road Durham, NC 27701 State Withholding Allow. 3 SS# 232-32-3232 Earnings Deductions Pay Period Ending Regular Hours Worked Regular Pay Rate Regular Wages Overtime Hours Worked Overtime Pay Rate Overtime Wages Federal Withholding Tax State Withholding Tax Social Security Tax 8 Medicare Tax Retirement Contribution Gross Pay Charitable Contribution 8 Life Insurance & Additional Withholding Check Number Net Pay n/a In/a S2,450.00 In/a Ina S2 450.00 5242.68 $120.00 $148.80 $34 80 $20.00 $5.00 1095 $1,828.72 . 12/17/2020 MMDD/YYYY A Employee Earnings Record Name Calvin Bell Marital Status Single Address Fed. Withholding Allow. 2 2222 Sacker Place Durham, NC 27701 State Withholding Allow. 1 SS# 500-00-0000 Earnings Deductions Pay Period Ending 333 Regular Hours Worked SBS Regular Pay Rate Regular Wages 33 Overtime Hours Worked 233ROvertime Pay Rate ollOvertime Wages Federal Withholding Tax BMC State Withholding Tax Social Security Tax Medicare Tax CSSS Retirement Contribution Life Insurance Charitable Contribution 99 Additional Withholding Check Number 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 n/a n/a n/a n/a n/a n/a n/a $ 1,637.09 $ 5,433.09 $ 195.00 $ 255.32 $ 336.83 $ 78.78 $ 326.04S $ 1,637.09$ 5,433.09 $ 195.00 $ 255.32S 336.83$ 78.78 S 326.04S $ 1,637.09 $ 5,433.09 $ 195.00 $ 255.32 $ 336.83 $ 78.78 $ 326.04S $ 1,259.30 $ 4,179.30 $ 150.00 $ 196,40 $ 259.10 $ 60.60 $ 250.80S $ 195,00 $ 91.00 $ 195,00 S 91.00 $ 195.00$ 91.00 $ 150.00 $ 70.00 $ 3,955.12 $ 3,955.12 $ 3,955.12 $ 3,042.40 Employee Earnings Record Marital Status Name David Alexander Single Address 1 1 Freedom Blvd. Durham, NC 27701 Fed. Withholding Allow. State Withholding Allow. 1 55# 454-54-5454 Earnings Deductions 2Pay Period Ending 3333 Regular Hours Worked U SEBB Regular Pay Rate Regular Wages S33 Overtime Hours Worked 3 3 3 3 overtime Pay Rate Overtime Wages Federal Withholding Tax State Withholding Tax Socia Security Tax Life Insurance la Medicare Tax Retirement Contribution gaCharitable Contribution Additional Withholding Check Number S 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter n/a n/a n/a na na na na nda $ 52,650.00 $ 52,650.00 $ 52,650.00 $ 40,500.00 n/a n/a n/a n/a uten $ 52,650.00 S 9,430.98 $ 2,316.60 $3,264.30 $ 763.49 $ 6,318.00 $ $ 52,650.00 $ 9,430.98 $ 2,316.60 $ 3,264.30 $ 763.49 $ 6,318.00 $ $ 52,650.00 $ 9,430.98 S 2.316.60 $ 2,008.80 $763.49 $ 6,318.00 S $ 40,500.00 $ 7,254.60 $ 1,782.00 S $ 587.30 $4,860.00 $ $ 260.00 $ $ 260.00 S $260.00 S $ 200.00 $ S 30.296.63 $ 30,296.63 S 31,552.13 S 25,816.10 - n/a na 5 $ - Employee Earnings Record Name Michael Sierra Marital Status Married Address Fed. Withholding Allow. 4 200 Mississippi Road Durham, NC 27701 State Withholding Allow. 3 SS# 232-32-3232 Earnings Deductions Pay Period Ending SIR Regular Hours Worked SISISIS Regular Pay Rate Sala Regular Wages BBBB Overtime Hours Worked BBB Overtime Pay Rate Overtime Wages A Federal Withholding Tax State Withholding Tax lo Social Security Tax 99 Medicare Tax Retirement Contribution 818 18 Life Insurance lalala Charitable Contribution lella Additional Withholding Check Number n/a 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter n/a n/a n/a n/a n/a n/a na n/a $ 31,850.00 $ 31,850.00 $ 31,850.00 $ 24,500.00 n/a n/a n/a n/a $ $ $ $ $ 31,850.00 $ 3.154.84$ 1,560.00 $ 1,934.40 $452.40 $ $ 31,850.00 $ 3,154.84$ 1,560.00 $ 1,934.40 $452.40 $ $ 31,850.00$ 3,154.84$ 1,560.00 $ 1,934.40 $452.40$ $ 24,500.00 $ 2,426.80 $ 1,200.00 $ 1,488.00$ 348.00 $ $ 260.00 $ 65.00 $ 650.00 $ 260.00 $ 65,00 $ 650.00 $ 260,00 $ 65,00 S 650.00 $ 200.00 $ 50.00 $ 500.00 $ 23,773.36 $ 23,773.36 $ 23,773.36 $ 18,287.20