question 3. complete the employer earnings records for December for each of the four employees. Divide the voluntary deductions...

WARNING! The above dates are weekly start dates. Refer to a calendar to determine the weekly 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. 226 Payroll Accounting Chapter 7: Comprehensive Projects-Paper-Based Versions One-Month Project NOTE! Templates needed to complete these exercises are included in the Student Exercise Files downinad for this course Ellipses Corp. is a small business that operates 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-555-0073). 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. Social Federal W/H Allowances State W/H Name Marital Status Address Security Allowances Hunter Cranston 85 Southern Road Herndon, VA 20170 111-11-1111 2 Married Allison Harrison 203A Pine Court 777-77-7777 4 3 Married Herndon, VA 20170 John Parker 212 Tradition Lane 444-44-4444 1 Single 1 Herndon, VA 20170 41 Seward Boulevard Herndon, VA 20170 Pierre Stermberg 333-33-3333 Married 2 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 ina 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 Weekly Charitable Contribution Weekly 401(k) Deduction te Regular Wage Rate Annual Salary Name 6% of gross pay $5 N/A $15/hour Hunter Cranston 5% of gross pay $5 N/A Ore $23/hour Allison Harrison $20 N/A $203,000.20 Nou N/A John Parker N/A 1% of gross pay $112,000.20 N/A Pierre Sternberg The first 11 months of the year have passed, and all payroll-related activity has been properly accounted for as of 11/30/2018. Please note that no paychecks were distributed on 1/1/2018 (as these checks wese written and distributed on 12/31/2017 instead), resulting in the distribution of checks on 13 pay dates during the first quarter, Payroll data for each of the four employees for the first three quarters of the year, as well as for the one-Mo e 227 months of October and November, is as follows. Hunter Cranston Federal Gross State Income T Social Security Tax Earnings Income Tax Medicare 4010) Period Charitable Deduction Cont Tax $234 $7,800 1st quarter $366.60 $483.60 $113.10 $468 $234 $7,800 $366.60 $66 2nd quarter $483.60 $113.10 $468 S65 $7,800 $234 $366.60 3rd arter $483.60 $113,10 $468 $65 $2,400 $72 $112.80 October $148.80 $34.80 $144 $20 $90 $3,000 $141 November $186 $43.50 $180 $25 Allison Harrison Medicare 401(k) Gross Federal State Income Tax Social Security Tax Charitable Deduction Cont Earnings Income Tax Tax Period $741,52 $173.42 $568.10 $598 $65 $11,960 $429 1st quarter $598 $741.52 $173.42 $65 $568.10 2nd quarter $11,960 $429 $173.42 $598 $65 $741.52 $568.10 3nd quarter $11,960 $429 $20 $184 $53.36 $228.16 October $174.80 $132 $3,680 $25 $230 $66.70 $285.20 November $218.50 $4,600 $165 John Parker Charitable 401(k) Medicare Social Gross State Deduction Cont. Federal Period Earnings Income Tax Security Tax Tax Income Tax $260 $735.93 1st quarter $3,146.52 $50,750.05 $2,537.47 $11,035.18 $260 50 $735.93 2nd quarter $3,146.52 $50,750.05 $2,537.47 $11,035.18 $260 S0 3rd quarter $735.93 $1,667.76 $50,750.05 $11,035.18 $2,537.47 $80 $0 October $226.44 $0 $15,615.40 $780.76 $100 $3,395.44 S0 November $283.05 $0 $19,519.25 $975.95 $4,244.30 30 aloe ccounting Chapter 7: Comprehensive Projects-Paper-Based Versions Pierre Sternberg Gross 401(k) Deduction Cont Charitable Federal Medicare Social State Period Earnings Income Tax ax Security Tax Income Tax 1st quarter $0 $0 $0 S0 SO $0 2nd quarter 50 S0 $0 So $0 $0 3rd quarter $0 $0 $0 $0 s0 S0 $0 S0 S0 October $0 $0 $0 $0 S0 $0 $21.54 November $2,153.85 $31.23 $228.94 $133.54 $106.62 Note that all tax payments and filings are made on the due date. Based on the data provided here, you will complete the following Betakl: 1 30 La Copy Calibri e Wrap Text Accounting Norm Paste A B IU Conditional Format as Gooc Formatting Table E Merge & Center % Format Painter Clipboard Font Alignment Number C24 -C11+C12+C13+C14 A C D E F G J K L M 4 Name Earnings Earnings Inc Tax Earnings x x 401K Source 5 6 October Payroll 7 H Cranston 2,256.00 72.00 2,400.00 148.80 2,400.00 34.80 144.00 Book 8 A Harrison 9 J Parker 10 November Payroll 3,496.00 132.00 3,680.00 3,680.00 184.00 Book 228.16 53.36 15,615.40 3,395.44 15,615.40 226.44 Book 11 H Cranston 2,820.00 90.00 3,000.00 186.00 3,000.00 43.50 180.00 Book 12 A Harrison 4,370.00 165.00 4,600.00 230.00 Book 285.20 4,600.00 66.70 13 J Parker 14 P Sternberg 15 December Payroll 16 H Cranston 19,519.25 4,244.30 19,519.25 Book 283.05 2,132.31 228.94 2,153.85 133.54 2,153.85 31.23 21.54 Book Dec. Earnings Record Dec. Earnings Record 17 A Harrison 18 J Parker 19 P Sternberg Dec. Earnings Record Dec. Earnings Record 20 50,208.96 8,327.68 15,833.85 981.70 50,968.50 739.08 21 22 23 October November December Totals 24 FWT 25 SS employee 26 SS employer 27 Med employee 28 Med employer 29 Deposits 3,599.44 4,728.24 8,327.68 376.96 604.74 981.70 376.96 604.74 981.70 314.60 424.48 739.08 314.60 424.48 739.08 4,982.56 6,786.68 11,769.24 30 31 32 Payroll Registers Journal Employee Earnings Rprt Info Type here to search W 99 ce Wrap Text Accounting Lb Copy Paste BIU A E Merge & Center Format Painter $.% 8 Conditional Format as Formatting Table Clipboard Font Alignment Number C24 C11+C12+ C13+C14 A B D E F G H K L 4 Name Earnings Inc Tax Earnings Earnings 401K Source 5 6 October Payroll 7 H Cranston 2,256.00 72.00 2,400.00 148.80 2,400.00 34.80 144.00 Book 8 A Harrison 9 J Parker 10 November Payroll 3,496.00 132.00 3,680.00 228.16 3,680.00 184.00 Book 53.36 15,615.40 3,395.44 15.615.40 226.44 Book 11 H Cranston 2,820.00 90.00 3,000.00 186.00 180.00 Book 3,000.00 43.50 12 A Harrison 4,370.00 165.00 4,600.00 4,600.00 285.20 230.00 Book 66.70 13 J Parker 19,519.25 4,244.30 19,519.25 283.05 Book 14 P Sternberg 15 December Payroll 2,132.31 228.94 2,153.85 133.54 2,153.85 21.54 Book 31.23 16 H Cranston 17 A Harrison Dec. Earnings Record Dec. Earnings Record 18 J Parker 19 P Sternberg Dec. Earnings Record Dec. Earnings Record 20 50,208.96 8,327.68 15,833.85 981.70 50,968.50 739.08 21 22 23 October November December Totals 24 FWT 25 SS employee 26 SS employer 27 Med employee 28 Med employer 29 Deposits 30 3,599.44 4,728.24 8,327.68 981.70 604.74 376.96 604.74 376.96 981.70 314.60 424.48 739.08 314.60 424.48 739.08 4,982.56 6,786.68 11,769.24 31 32 Payroll Registers Employee Earnings Journal Rprt Info Type here to search 99+