For tax purposes, assume that the maximum taxable earnings are $$118,500$ for Social Security and $$7,000$ for the unemployment tax and that all earnings are taxable for Medicare. For the payroll register for the month of November for Shelby, Inc., determine the taxable earnings for each employee. If an amount is zero, enter $"0".$

$\backslash$table$[[$NAME$,\backslash$table$[[$BEGINNING$],[$CUMULATIVE$],[$EARNINGS$]],\backslash$table$[[$TOTAL$],[$EARNINGS$]],\backslash$table$[[$ENDING$],[$CUMULATIVE$],[$EARNINGS$]],$TAXABLE EARNINGS$],[$UNEMPLOYMENT$,$SOCIAL SECURITY,MEDICARE$],[$Axton$,$ C$.,109,798\mathrm{.}00,10,668,00,120,466\mathrm{.}00,0|||,,],[$Edgar$,$ E$.,145,398\mathrm{.}00,19,392\mathrm{.}00,164,790\mathrm{.}00,0,0,],[$Gorman$,$ L$.,36,979\mathrm{.}00,3,041,00,40,020\mathrm{.}00,0,,],[$Jolson$,$ R$.,24,149\mathrm{.}00,2,440,00,26,589,00,0$ V$,,],[$Nixel$,$ P$.,6,813\mathrm{.}00,2,214\mathrm{.}00,9,027\mathrm{.}00,,,]]$

Feedback

Theck My Work

First, make sure that the amount of beginning Cumulative Earnings plus the total earnings for this pay period do not exceed the maximum amount for Social Security. If they do$,$ only multiply the percentage times the amount that brings you to the naximum amount. For example:

Beginning cumulative amount $=$$$110,450\mathrm{.}00$ and the current earnings $=$$$5,320\mathrm{.}00.$ This would bring the ending cumulative amount to $$115,770\mathrm{.}00$ which puts you over the maximum for Social Security Taxable earnings. To find out how much to tax, you would take the $($maximum taxable earnings amount$)$ $$118,500\mathrm{.}00-$$$110,450\mathrm{.}00($Beginning Cumulative Earnings$)=$$$8,050\mathrm{.}00($The part of current earnings that are taxable earnings$).$

The same applies to the unemployment amount. Only use the difference to figure your taxable earnings.