Please help me fill out the payroll register!

CHAPTER 9 - PAYROLL REGISTER Instructions In this assignment, you will be preparing a time record and payroll register for the employees of Pancakes Unlimited, Inc for the week ending December 12, 2020. You will need to know the following information in order to prepare the time record and payroll register: . . There are 6 employees as listed on the Time Record. Their martial status and withholding allowances as claimed on the W-4 are listed on the Time Record. The employees work on a Sunday - Saturday schedule. The employees are paid weekly on the Friday following the close of the pay week. For example, our pay week ends Saturday, December 12th, therefore they are paid on Friday, December 18h 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 6th 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. Tuesday Thursday Friday Name Brown, D. Davis, H. Garcia, F. Johnson, B. Jones, E. Monday 8 8 8 8 9 Wednesday 8 9 8 7 8 9 8 8 8 9 8 9 8 8 10 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 Columns I and J, making sure to pay attention to the wage base (if necessary). Calculate Social Security and Medicare based off the amounts entered Columns I and J. late 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. TIME RECORD - PANCAKES UNLIMITED Time Record Regular Earnings Overtime Earnings Rate Per Earnings Amount Hrs. Hour Amount for Period 4 33.00 840,00 880.00 960.00 940.00 1,010.00 0.00 840.00 132.00 1,012.00 0.00 960.00 70.50 1,010.50 0.0011.010.00 2 35.25 Rate Per NAME 2 S M T W T F S Hrs. Hour Payday, December 18, 2020 For Period Ending December 12, 2020 6 Brown, D. M 4 4 8 8 8 8 8 8 8 40 21.00 7 Davis, H. M 5 8 8 8 8 8 8 40 22.00 8 Garcia, F. S 2 8 8 8 8 8 40 24.00 9 Johnson, B. M 4 8 8 7 8 9 8 7 9 40 23.50 10 Jones, E. , M 3 8 8 8 8 8 40 25.25 11 12 Richardson, M. s 4 13 TOTALS 14 15 16 17 18 19 Time Record Payroll Regster Withholdings Fables 2,550.00 7,180.00 2,550.00 7,180.00 BCDEF L M N 0 PO PAYROLL REGISTER - PANCAKES UNLIMITED FICA Taxable Earnings Deductions S.S Med S.S. Med FIT SIT Health Ing. Net Pay 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Previous Earnings Cumulative NAME 3 Earrings for Parod Earrings Payday, December 18, 2020 Far Parod Ending December 12, 2020 6 Brown, D. M4 41,160.00 840.00 42,000.00 7 Davis, H. MS 49,598.00 1,012.00 50,600,00 8 Garcia, F. S2 2 47,040.00 960.00 48,000.00 9 Johnson, B. M4 49,514.50 1,010.50 50.525.00 10 Jones, E M3 49,490.00 1,010,00 50.500,00 11 12 Richardson, M S4 124,950.00 2,550.00 127,500.00 11 TOTALS 4,832.50 241.625.00 14 15 16 17 75 19 20 21 22 22 24 25 26 28 Time Record Payroll Register withholdings Tables Payroll Period Weekly Biweekly Semimonthly Monthly Quarterly Semiannually Annualy Daily or miscellaneous (each day of the payrol period) One 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 1-WEEKLY Payroll Period 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 (a) SINGLE person including head of household (b) MARRIED person the amount of wages Nih The amount of income tax e amount of wages The amount of income tax withholding aliowance is to withhold withholding allowances to withholdis Not Over 571 $0 Not over 2220 Over But not over of excess over over But not over 254 $0.00 plus 10% of excess over $71 S7: $2225588 $0.00 plus 10% -3922 $254 --$815 $18.30 pus 12% --S254 $588 -$1.711 $36.60 plus 12% S588 5815 --$1.658 $85.62 plus 22 -$815 $1,711 -$3.395 $171.36 plus 22% -$1,711 $1,650 -53.100 $271 0e plus 249 -51.658 $3.395 -$8,280 $541 84 plus 249 $3,395 $3100 $3,917 $617.16 plus 32% $3,100 $6280 57,914 $1,234 24 plus 323 56,280 $3917 -$9.687 $878. 60 plus 35% ---$3.917 57,914 -$11.761 $1,757 12 plus 399 -$7,914 $9.087 $2898.10 plus 379 -59.687 $11.261 $3103.57 plus 379 -$11.781 Time Record Payroll Register Withholdings Tables 4 Ready CHAPTER 9 - PAYROLL REGISTER Instructions In this assignment, you will be preparing a time record and payroll register for the employees of Pancakes Unlimited, Inc for the week ending December 12, 2020. You will need to know the following information in order to prepare the time record and payroll register: . . There are 6 employees as listed on the Time Record. Their martial status and withholding allowances as claimed on the W-4 are listed on the Time Record. The employees work on a Sunday - Saturday schedule. The employees are paid weekly on the Friday following the close of the pay week. For example, our pay week ends Saturday, December 12th, therefore they are paid on Friday, December 18h 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 6th 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. Tuesday Thursday Friday Name Brown, D. Davis, H. Garcia, F. Johnson, B. Jones, E. Monday 8 8 8 8 9 Wednesday 8 9 8 7 8 9 8 8 8 9 8 9 8 8 10 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 Columns I and J, making sure to pay attention to the wage base (if necessary). Calculate Social Security and Medicare based off the amounts entered Columns I and J. late 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. TIME RECORD - PANCAKES UNLIMITED Time Record Regular Earnings Overtime Earnings Rate Per Earnings Amount Hrs. Hour Amount for Period 4 33.00 840,00 880.00 960.00 940.00 1,010.00 0.00 840.00 132.00 1,012.00 0.00 960.00 70.50 1,010.50 0.0011.010.00 2 35.25 Rate Per NAME 2 S M T W T F S Hrs. Hour Payday, December 18, 2020 For Period Ending December 12, 2020 6 Brown, D. M 4 4 8 8 8 8 8 8 8 40 21.00 7 Davis, H. M 5 8 8 8 8 8 8 40 22.00 8 Garcia, F. S 2 8 8 8 8 8 40 24.00 9 Johnson, B. M 4 8 8 7 8 9 8 7 9 40 23.50 10 Jones, E. , M 3 8 8 8 8 8 40 25.25 11 12 Richardson, M. s 4 13 TOTALS 14 15 16 17 18 19 Time Record Payroll Regster Withholdings Fables 2,550.00 7,180.00 2,550.00 7,180.00 BCDEF L M N 0 PO PAYROLL REGISTER - PANCAKES UNLIMITED FICA Taxable Earnings Deductions S.S Med S.S. Med FIT SIT Health Ing. Net Pay 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Previous Earnings Cumulative NAME 3 Earrings for Parod Earrings Payday, December 18, 2020 Far Parod Ending December 12, 2020 6 Brown, D. M4 41,160.00 840.00 42,000.00 7 Davis, H. MS 49,598.00 1,012.00 50,600,00 8 Garcia, F. S2 2 47,040.00 960.00 48,000.00 9 Johnson, B. M4 49,514.50 1,010.50 50.525.00 10 Jones, E M3 49,490.00 1,010,00 50.500,00 11 12 Richardson, M S4 124,950.00 2,550.00 127,500.00 11 TOTALS 4,832.50 241.625.00 14 15 16 17 75 19 20 21 22 22 24 25 26 28 Time Record Payroll Register withholdings Tables Payroll Period Weekly Biweekly Semimonthly Monthly Quarterly Semiannually Annualy Daily or miscellaneous (each day of the payrol period) One 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 1-WEEKLY Payroll Period 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 (a) SINGLE person including head of household (b) MARRIED person the amount of wages Nih The amount of income tax e amount of wages The amount of income tax withholding aliowance is to withhold withholding allowances to withholdis Not Over 571 $0 Not over 2220 Over But not over of excess over over But not over 254 $0.00 plus 10% of excess over $71 S7: $2225588 $0.00 plus 10% -3922 $254 --$815 $18.30 pus 12% --S254 $588 -$1.711 $36.60 plus 12% S588 5815 --$1.658 $85.62 plus 22 -$815 $1,711 -$3.395 $171.36 plus 22% -$1,711 $1,650 -53.100 $271 0e plus 249 -51.658 $3.395 -$8,280 $541 84 plus 249 $3,395 $3100 $3,917 $617.16 plus 32% $3,100 $6280 57,914 $1,234 24 plus 323 56,280 $3917 -$9.687 $878. 60 plus 35% ---$3.917 57,914 -$11.761 $1,757 12 plus 399 -$7,914 $9.087 $2898.10 plus 379 -59.687 $11.261 $3103.57 plus 379 -$11.781 Time Record Payroll Register Withholdings Tables 4 Ready