1. Establish an employee earnings record for each of the company's four employees. Complete the top...

Transcribed Image Text:

1. Establish an employee earnings record for each of the company's four employees. Complete the top portion of each record. LL Paste C24 Copy Format Painter Clipboard A 4 Name 5 6 October Payroll 7 H Cranston # 8 A Harrison 9 J Parker 10 November Payroll 11 H Cranston 12 A Harrison 13 J Parker 14 P Sternberg 15 December Payroll 16 H Cranston 17 A Harrison 18 J Parker 19 P Sternberg 20 21 22 23 24 FWT 25 SS employee 26 SS employer 27 Med employee 28 Med employer 29 Deposits 30 31 32 F x Calibri BIU ✓ fx B C Earnings Inc Tax 2,256.00 3,496.00 15,615.40 2,820.00 4,370.00 19,519.25 2,132.31 -11-AA 2Wrap Text A Merge & Center - Font Payroll Registers Type here to search <11+12+C13 C14 72.00 132.00 3,395.44 90.00 165.00 4,244.30 228.94 TM D Earnings Tax 2,400.00 3,680.00 3,000.00 4,600.00 50,208.96 8,327.68 15,833.85 2,153.85 October November December Totals 3,599.44 4,728.24 376.96 604.74 376.96 604.74 314.60 424.48 424.48 314.60 4,982.56 6,786.68 Employee Earnings E 148.80 228.16 186.00 285.20 133.54 981.70 8,327.68 981.70 981.70 739.08 739.08 11,769.24 Journal O 9- Alignment F Earnings 2,400.00 3,680.00 15,615.40 Tax G Rprt Info 34.80 53.36 226.44 50,968.50 739.08 P 141 H 401K Accounting $-% 9%88 3,000.00 43.50 180.00 Book 4,600.00 66.70 230.00 Book 19,519.25 283.05 Book 2,153.85 31.23 21.54 Book Number I Source 144.00 Book 184.00 Book Book 199 J W F Dec. Earnings Record Dec. Earnings Record Dec. Earnings Record Dec. Earnings Record I Normal Conditional Format as Good Formatting Table- K T L Styles M 4 N Bad Neutral 0 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 dow 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. State W/H Allowances Name Hunter Cranston Allison Harrison John Parker Pierre Sternberg Name Hunter Cranston Allison Harrison John Parker Pierre Sternberg Address 85 Southern Road Herndon, VA 20170 203A Pine Court Herndon, VA 20170 41 Seward Boulevard Herndon, VA 20170 212 Tradition Lane Herndon, VA 20170 N/A Regular Wage Rate $15/hour N/A $23/hour Annual Salary N/A Social Security # 111-11-1111 N/A 777-77-7777 $203,000.20 $112,000.20 444-44-4444 333-33-3333 Federal W/H Allowances 2 4 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. 1 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. 1% of gross pay 2 Weekly 401(k) Deduction 6% of gross pay 5% of gross pay N/A 2 3 1 $5 $5 $20 N/A 2 Marital Status Married Weekly Charitable Contribution Married Single Married M B 26 p of 11/30/2018. Please note that no paychecks were distributed on 1/1/2018 (as these checks were written and The first 11 months of the year have passed, and all payroll-related activity has been properly accounted for as 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 months of October and November, is as follows, Hunter Cranston Period 1st quarter 2nd quarter 3rd quarter October November Period 1st quarter Allison Harrison October Gross Earnings November $7,800 $7,800 $7,800 $2,400 $3,000 2nd quarter $11,960 3rd quarter $11,960 $3,680 $4,600 John Parker Gross Earnings $11,960 Federal Income Tax $234 $234 $234 572 $90 Federal Income Tax $429 $429 $429 $132 $165 Gross Federal Earnings Income Tax Period 1st quarter 2nd quarter $50,750.05 $11,035.18 3rd quarter October November State Social Income Tax Security Tax Tax $366.60 $483.60 $366.60 $366.60 $112.80 $141 $568.10 $568.10 State Social Income Tax Security Tax $568.10 $174.80 $218,50 State Income Tax $483.60 5483.60 $148.80 $50,750.05 $11,035.18 $2,537.47 $2,537.47 $50,750.05 $11,035.18 $2,537.47 $15,615.40 $3,395.44 $780.76 $19,519.25 $4,244.30 $975.95 $186 $741.52 $741.52 $741.52 $228.16 $285.20 Social Security Tax $3,146.52 $3,146.52 $1,667.76 $0 50 Medicare $34.80 $43.50 $113.10 $468 $113.10 $468 $113.10 $468 $144 $180 553.36 One Morth Project 227 Medicare 401(k) Tax $173.42 $173.42 $173,42 $66.70 401(k) Deduction $735.93 $735.93 $735.93 $226,44 $283.05 Deduction $598 $598 $598 $184 $230 Medicare 401(k) Tax 50 50 SO $0 Charitable Cont. SO 565 $65 $65 $20 $25 Charitable Cont. $65 $65 Deduction Cont. $260 $260 $260 $80 $100 565 $20 $25 Charitable Pierre Sternberg Period 1st quarter 2nd quarter 3rd quarter October November Gross Earnings SO $0 $0 SO $2,153.85 Federal Income Tax $0 $0 $0 $0 $228.94 State Income Tax $0 $0 $0 $0 $106.62 Social Security Tax $0 $0 $0 $0 $133.54 Medicare Tax $0 $0 $0. $0 $31.23 401(k) Deduction Cont SO $0 $0 SO $21.54 Charitable 50 SO SO 50 SO Note that all tax payments and filings are made on the due date. Based on the data provided here, you will complete the following: 1. Establish an employee earnings record for each of the company's four employees. Complete the top portion. of each record. 1. Establish an employee earnings record for each of the company's four employees. Complete the top portion of each record. LL Paste C24 Copy Format Painter Clipboard A 4 Name 5 6 October Payroll 7 H Cranston # 8 A Harrison 9 J Parker 10 November Payroll 11 H Cranston 12 A Harrison 13 J Parker 14 P Sternberg 15 December Payroll 16 H Cranston 17 A Harrison 18 J Parker 19 P Sternberg 20 21 22 23 24 FWT 25 SS employee 26 SS employer 27 Med employee 28 Med employer 29 Deposits 30 31 32 F x Calibri BIU ✓ fx B C Earnings Inc Tax 2,256.00 3,496.00 15,615.40 2,820.00 4,370.00 19,519.25 2,132.31 -11-AA 2Wrap Text A Merge & Center - Font Payroll Registers Type here to search <11+12+C13 C14 72.00 132.00 3,395.44 90.00 165.00 4,244.30 228.94 TM D Earnings Tax 2,400.00 3,680.00 3,000.00 4,600.00 50,208.96 8,327.68 15,833.85 2,153.85 October November December Totals 3,599.44 4,728.24 376.96 604.74 376.96 604.74 314.60 424.48 424.48 314.60 4,982.56 6,786.68 Employee Earnings E 148.80 228.16 186.00 285.20 133.54 981.70 8,327.68 981.70 981.70 739.08 739.08 11,769.24 Journal O 9- Alignment F Earnings 2,400.00 3,680.00 15,615.40 Tax G Rprt Info 34.80 53.36 226.44 50,968.50 739.08 P 141 H 401K Accounting $-% 9%88 3,000.00 43.50 180.00 Book 4,600.00 66.70 230.00 Book 19,519.25 283.05 Book 2,153.85 31.23 21.54 Book Number I Source 144.00 Book 184.00 Book Book 199 J W F Dec. Earnings Record Dec. Earnings Record Dec. Earnings Record Dec. Earnings Record I Normal Conditional Format as Good Formatting Table- K T L Styles M 4 N Bad Neutral 0 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 dow 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. State W/H Allowances Name Hunter Cranston Allison Harrison John Parker Pierre Sternberg Name Hunter Cranston Allison Harrison John Parker Pierre Sternberg Address 85 Southern Road Herndon, VA 20170 203A Pine Court Herndon, VA 20170 41 Seward Boulevard Herndon, VA 20170 212 Tradition Lane Herndon, VA 20170 N/A Regular Wage Rate $15/hour N/A $23/hour Annual Salary N/A Social Security # 111-11-1111 N/A 777-77-7777 $203,000.20 $112,000.20 444-44-4444 333-33-3333 Federal W/H Allowances 2 4 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. 1 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. 1% of gross pay 2 Weekly 401(k) Deduction 6% of gross pay 5% of gross pay N/A 2 3 1 $5 $5 $20 N/A 2 Marital Status Married Weekly Charitable Contribution Married Single Married M B 26 p of 11/30/2018. Please note that no paychecks were distributed on 1/1/2018 (as these checks were written and The first 11 months of the year have passed, and all payroll-related activity has been properly accounted for as 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 months of October and November, is as follows, Hunter Cranston Period 1st quarter 2nd quarter 3rd quarter October November Period 1st quarter Allison Harrison October Gross Earnings November $7,800 $7,800 $7,800 $2,400 $3,000 2nd quarter $11,960 3rd quarter $11,960 $3,680 $4,600 John Parker Gross Earnings $11,960 Federal Income Tax $234 $234 $234 572 $90 Federal Income Tax $429 $429 $429 $132 $165 Gross Federal Earnings Income Tax Period 1st quarter 2nd quarter $50,750.05 $11,035.18 3rd quarter October November State Social Income Tax Security Tax Tax $366.60 $483.60 $366.60 $366.60 $112.80 $141 $568.10 $568.10 State Social Income Tax Security Tax $568.10 $174.80 $218,50 State Income Tax $483.60 5483.60 $148.80 $50,750.05 $11,035.18 $2,537.47 $2,537.47 $50,750.05 $11,035.18 $2,537.47 $15,615.40 $3,395.44 $780.76 $19,519.25 $4,244.30 $975.95 $186 $741.52 $741.52 $741.52 $228.16 $285.20 Social Security Tax $3,146.52 $3,146.52 $1,667.76 $0 50 Medicare $34.80 $43.50 $113.10 $468 $113.10 $468 $113.10 $468 $144 $180 553.36 One Morth Project 227 Medicare 401(k) Tax $173.42 $173.42 $173,42 $66.70 401(k) Deduction $735.93 $735.93 $735.93 $226,44 $283.05 Deduction $598 $598 $598 $184 $230 Medicare 401(k) Tax 50 50 SO $0 Charitable Cont. SO 565 $65 $65 $20 $25 Charitable Cont. $65 $65 Deduction Cont. $260 $260 $260 $80 $100 565 $20 $25 Charitable Pierre Sternberg Period 1st quarter 2nd quarter 3rd quarter October November Gross Earnings SO $0 $0 SO $2,153.85 Federal Income Tax $0 $0 $0 $0 $228.94 State Income Tax $0 $0 $0 $0 $106.62 Social Security Tax $0 $0 $0 $0 $133.54 Medicare Tax $0 $0 $0. $0 $31.23 401(k) Deduction Cont SO $0 $0 SO $21.54 Charitable 50 SO SO 50 SO Note that all tax payments and filings are made on the due date. Based on the data provided here, you will complete the following: 1. Establish an employee earnings record for each of the company's four employees. Complete the top portion. of each record.

Answer rating: 100% (QA)

To establish an employee earnings record for each of the companys four employees we need to fill in ... View the full answer