TIME RECORD - PANCAKES UNLIMITED M Time Record Regular Earnings Overtime Earnings ari tal St Rate Rate Earnings at Per Per for NAME us SMTWTFS|Hrs. Hour Amount Hrs. Hour Amount Period day, December 18, 2020 For Period Ending December 12, 2020 wn, D. M 4 88888 40|| 21.00 840.00 031.501 0.00 840.00 M5 888 88 40|| 22.00 880.00 4 33.00 132.00 1,012.00 ia, F. S 2 88888 40 24.00 960.00 0 36.000 0.00 960.00 M4 8 87 | 8 9 40|| 23.50 940.00 235.25 70.50 1,010.50 M3 8888 8 40 25.25|| 1,010.00 0|| 37.88 0.00 1,010.00 S, H. son, B. S 4 ardson, M. TALS 2,550.00 7,180.00 2,550.00 7,180.00 PAYROLL REGISTER - PANCAKES UNLIMITED Deductions S.S. Med. FIT SIT Health Ins.Net Pay M IFICA Taxable Earning ari tal St Earnings at Previous for Cumulative NAME us Earnings Period Earnings S.S. Med. Payday, December 18, 2020 For Period Ending December 12, 2020 Brown, D. M 4 41,160.00 840.00 42,000.00 Davis, H. . 5 49,588.00 1,012.00 50,600.00 Garcia, F. S| 2 47,040.00 960.00 48,000.00 Johnson, B. . 4 49,514.50 1,010.50 50,525.00 Jones, E. M3 49,490.00 1,010,00 50,500.00 S Richardson, M. TOTALS 4 124,950.00 2,550.00 127,500.00 4,832.50||241,625.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Payroll Period Weekly Biweekly Semimonthly Monthly Quarterly Semiannually Annually Daily or miscellaneous (each day of the payroll period) Une Withholding Allowance $ 79.80 159.60 172.90 345.80 1,037.50 2,075.00 4,150.00 16.00 Percentage Method Tables for Income Tax Withholding (For Wages Paid in 2018) TABLE 1WEEKLY Payroll Period (a) SINGLE person (including head of household) (b) MARRIED person- If the amount of wages If the amount of wages (after subtracting The amount of income tax (after subtracting The amount of income tax withholding allowances) is: to withhold is: withholding allowances) is: to withhold is: Not over $71 SO Not over $222 SO Over- But not over- of excess over-Over- But not over- of excess over- $71 -$254 $0.00 plus 10% -$71 S222 -$588 $0.00 plus 10% -$222 $254 $815 $18.30 plus 12% -$254 $588 -$1,711 $36.60 plus 12% -$588 $815 -$1,658 .. $85.62 plus 22% -$815 $1,711 -$3,395 $171.36 plus 22% -$1.711 $1,658 -$3,100 $271.08 plus 24% - $1,658 $3,395 -$6,280 $541.84 plus 24% -$3,395 $3,100 -$3.917 .. $617.16 plus 32% -$3.100 $6.280 -$7,914.. $1,234.24 plus 32% -$6.280 $3,917 -$9.687 S878.60 plus 35% -$3.917 $7.914 -$11,761 $1,757.12 plus 35% - $7,914 $9,687 $2,898.10 plus 37% -$9.687 $11,761 $3,103.57 plus 37% -$11,761 Five employees are paid on an hourly basis. If an employee works over 40 hours in a week, they are to be paid time-and-a-half. The 5th employee, Richardson, M. is a salaried manager that earns the same amount each week. Pancakes Unlimited uses the Percentage Method for calculating federal income tax withheld. Use Table 9.2 in your textbook (page 256 in the printed book). Pancakes Unlimited is located in North Carolina and the state income tax rate for all employees is 5.25%. For health insurance, if an employee claims married", $200 is withheld from their paycheck. If the employee claims "single", $100 is withheld from their paycheck. Step 1: If not already on the Time Record tab, navigate there. Prepare the Time Record for the employees of Pancakes Unlimited for the Week Ending December 12, 2020 using the information from the table below. Make sure to record any overtime hours in the overtime columns and not the regular pay columns Also, don't forget Richardson, M. is salaried and will not show any hours. Monday Tuesday Wednesday Thursday Friday Brown, D. 8 Davis, H. 9 Garcia, F. Johnson, B. 7 Jones, E. 8 Name 8 8 8 8 9 8 8 8 8 10 8 9 8 9 8 8 8 8 8 8 Step 2: Navigate to the Payroll Register tab. You will see Previous Earnings already filled in for "Previous Pay Periods", as well as "Earnings for Period" for each employee. The total of these two numbers added together should equal "Cumulative Earnings". Enter the amount of FICA taxable earnings for each employee in Columnsland), making sure to pay attention to the wage base (if necessary). Calculate Social Security and Medicare based off the amounts entered in Columns I and J. Calculate Federal Income Tax to withhold using the percentage method as discussed in the book (also copied on the Withholdings Tables tab). Calculate State income Tax and Health Insurance to withhold based on the amounts stated above. Finally, calculate Net Pay for each employee