Tell me what you want to do 23 Wrap Text Normal Merge Center - $ - % ) Conditional Format as Good Formatting Table Calibri AA BIU...A Genera . Incert Delete Format Copy Format Painter Clipboard Font Styles cao Employee Earnings Record Name Allison Harrison Marital Status Address 203A Pine Court Fed. Withholding Allow. Herndon, VA 20170 State Withholding Allow 777-77-7777 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 Retirement Contribution Medicare Tax Gross Pay Charitable contribution Life Insurance Additional Withholding Check Number $ 44,160.00 $ 1,584.00 $ 2,097.60 $ 2,737.92 $ 640.32 $ 2.208.00 34,652.16 Accumulated earnings 12/7/18 $ 23.00 12/14/18 $ 23.00 12/21/18 $ 23.00 12/28/18 $ 23.00 $ 240.00 $ 20.00 $ 20.00 $ 20.00 $ 20.00 YTD Totals $ 44,160.00 $ 1,584.00 $ 2,097.60 $ 2,737.92 610.32$ 2,208.00 $ $ 320,00 $ $ 34,652.16 Payroll Registers Employee Earnings Journal Rprt Info Ready Type here to search The above dates are weekly stalt uates. Nec end dates and associated pay dates. Keep in mind that tax liability and payment amounts are determined based on the weekly pay dates. 3. Complete the employee earnings records for December for each of the four employees. Divide the voluntary deductions from the payroll register appropriately across the associated columns within the employee earnings records. If directed to do so by your instructor, record the necessary journal entries for each pay period. Templates needed to complete these exercises are included in the Student Exercise Files download for this course Ellipses Corp is a small business that arerates in Herndon VA The company is located at 10 Period Lane, Herndon, VA 20170. Its federal Employer Identification Number is 77-7777777, and its president, who signs all tax forms, is John Parker (telephone 571.5550073) The company does not wish to name a third-party designee on forms During 2018 four individuals are employed by Ellipses Corp. These employees are as follows. Name Address Social Security Federal W/H Allowances State W/H Allowances Marital Status Hunter Cranston 8S Southern Road Herndon, VA 20170 111-11-1111 Married Allison Harrison 203A Pine Court Herndon, VA 20170 777-77-7777 Married John Parker 212 Tradition Lane Herndon, VA 20170 444-44-4444 Single Pierre Sternberg 41 Seward Boulevard Herndon VA 20170 333-33-3333 Married Note that Pierre Sternberg was hired in November, and his first day of work was Monday, November 26. Additionally, due to an economic downturn, Allison Harrison was laid off in mid-December, with her last day of work on Friday, December 14. All employees of Ellipses Corp. work a regular 40 hour workweek (thus all hours worked over 40 in a given week are overtime hours), receive overtime pay at a rate of 1.5 times the regular wage rate, and are paid weekly on Friday for the current week (which runs from Saturday through Friday, although employees never work on weekends). The SUTA tax rate applicable to Ellipses Corp. is 3.1%, while the SUTA wage base in Virginia is $8,000. Earnings and voluntary deduction information for each of the four employees is as follows. Name Regular Wage Rate Annual Salary Weekly 401(k) Deduction Weekly Charitable Contribution Hunter Cranston $15/hour NA 6% of gross pay $5 Allison Harrison $23/hour N/A 5% of gross pay John Parker $5 N/A 5203,000 20 N/A $20 Pierre Sternberg NA $112,000 20 15 of gross pay N/A Summarized information for the 941: AN Soc Sec Medicare FWT Earnings Federal Inc Tax Soc Sec Earnings Medicare Earnings 4 Name Tax 101K Source 148.80 72.00 132.00 3,395.44 42,400.00 3,680.00 228.16 2,400.00 3,680.00 15,615.40 34.80 53.36 226.44 144.00 Book 184.00 Book Book 3,000.00 4,600.00 186.00 1 285.20 6 October Payroll 7 H Cranston 2,256.00 8 A Harrison 3,496.00 9 ) Parker 15,615.40 10 November Payroll 11 H Cranston 2,820.00 12 A Harrison 4,370.00 13 Parker 19,519.25 14 P Sternberg 2,132.31 15 December Payroll 16 H Cranston 17 A Harrison 18 J Parker 19 P Sternberg 50,208.96 90.00 165.00 4,244.30 228.94 3,000.00 4,600.00 19,519.25 2,153.85 43.50 66.70 283.05 31.23 180.00 Book 230.00 Book Book 21.54 Book 2,153.85 133.54 Dec. Earnings Record Dec. Earnings Record Dec. Earnings Record Dec. Earnings Record 8,327.68 15,833.85 9 81.70 50,968.50 739.08 Totals 22 October November December 24 FWT 3,599.44 4,728.24 25 SS employee 376.96 604.74 26 SS employer 376.96 604.74 27 Med employee 314.60 424.48 28 Med employer 314.60 424.48 29 Deposits 4,982.56 6,786.68 Payroll Registers Employee Earnings 8,327.68 981.70 981.70 739.08 739.08 11,769.24 Journal Rprt Info Ready na Awi P Tune horo te Tell me what you want to do 23 Wrap Text Normal Merge Center - $ - % ) Conditional Format as Good Formatting Table Calibri AA BIU...A Genera . Incert Delete Format Copy Format Painter Clipboard Font Styles cao Employee Earnings Record Name Allison Harrison Marital Status Address 203A Pine Court Fed. Withholding Allow. Herndon, VA 20170 State Withholding Allow 777-77-7777 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 Retirement Contribution Medicare Tax Gross Pay Charitable contribution Life Insurance Additional Withholding Check Number $ 44,160.00 $ 1,584.00 $ 2,097.60 $ 2,737.92 $ 640.32 $ 2.208.00 34,652.16 Accumulated earnings 12/7/18 $ 23.00 12/14/18 $ 23.00 12/21/18 $ 23.00 12/28/18 $ 23.00 $ 240.00 $ 20.00 $ 20.00 $ 20.00 $ 20.00 YTD Totals $ 44,160.00 $ 1,584.00 $ 2,097.60 $ 2,737.92 610.32$ 2,208.00 $ $ 320,00 $ $ 34,652.16 Payroll Registers Employee Earnings Journal Rprt Info Ready Type here to search The above dates are weekly stalt uates. Nec end dates and associated pay dates. Keep in mind that tax liability and payment amounts are determined based on the weekly pay dates. 3. Complete the employee earnings records for December for each of the four employees. Divide the voluntary deductions from the payroll register appropriately across the associated columns within the employee earnings records. If directed to do so by your instructor, record the necessary journal entries for each pay period. Templates needed to complete these exercises are included in the Student Exercise Files download for this course Ellipses Corp is a small business that arerates in Herndon VA The company is located at 10 Period Lane, Herndon, VA 20170. Its federal Employer Identification Number is 77-7777777, and its president, who signs all tax forms, is John Parker (telephone 571.5550073) The company does not wish to name a third-party designee on forms During 2018 four individuals are employed by Ellipses Corp. These employees are as follows. Name Address Social Security Federal W/H Allowances State W/H Allowances Marital Status Hunter Cranston 8S Southern Road Herndon, VA 20170 111-11-1111 Married Allison Harrison 203A Pine Court Herndon, VA 20170 777-77-7777 Married John Parker 212 Tradition Lane Herndon, VA 20170 444-44-4444 Single Pierre Sternberg 41 Seward Boulevard Herndon VA 20170 333-33-3333 Married Note that Pierre Sternberg was hired in November, and his first day of work was Monday, November 26. Additionally, due to an economic downturn, Allison Harrison was laid off in mid-December, with her last day of work on Friday, December 14. All employees of Ellipses Corp. work a regular 40 hour workweek (thus all hours worked over 40 in a given week are overtime hours), receive overtime pay at a rate of 1.5 times the regular wage rate, and are paid weekly on Friday for the current week (which runs from Saturday through Friday, although employees never work on weekends). The SUTA tax rate applicable to Ellipses Corp. is 3.1%, while the SUTA wage base in Virginia is $8,000. Earnings and voluntary deduction information for each of the four employees is as follows. Name Regular Wage Rate Annual Salary Weekly 401(k) Deduction Weekly Charitable Contribution Hunter Cranston $15/hour NA 6% of gross pay $5 Allison Harrison $23/hour N/A 5% of gross pay John Parker $5 N/A 5203,000 20 N/A $20 Pierre Sternberg NA $112,000 20 15 of gross pay N/A Summarized information for the 941: AN Soc Sec Medicare FWT Earnings Federal Inc Tax Soc Sec Earnings Medicare Earnings 4 Name Tax 101K Source 148.80 72.00 132.00 3,395.44 42,400.00 3,680.00 228.16 2,400.00 3,680.00 15,615.40 34.80 53.36 226.44 144.00 Book 184.00 Book Book 3,000.00 4,600.00 186.00 1 285.20 6 October Payroll 7 H Cranston 2,256.00 8 A Harrison 3,496.00 9 ) Parker 15,615.40 10 November Payroll 11 H Cranston 2,820.00 12 A Harrison 4,370.00 13 Parker 19,519.25 14 P Sternberg 2,132.31 15 December Payroll 16 H Cranston 17 A Harrison 18 J Parker 19 P Sternberg 50,208.96 90.00 165.00 4,244.30 228.94 3,000.00 4,600.00 19,519.25 2,153.85 43.50 66.70 283.05 31.23 180.00 Book 230.00 Book Book 21.54 Book 2,153.85 133.54 Dec. Earnings Record Dec. Earnings Record Dec. Earnings Record Dec. Earnings Record 8,327.68 15,833.85 9 81.70 50,968.50 739.08 Totals 22 October November December 24 FWT 3,599.44 4,728.24 25 SS employee 376.96 604.74 26 SS employer 376.96 604.74 27 Med employee 314.60 424.48 28 Med employer 314.60 424.48 29 Deposits 4,982.56 6,786.68 Payroll Registers Employee Earnings 8,327.68 981.70 981.70 739.08 739.08 11,769.24 Journal Rprt Info Ready na Awi P Tune horo te