Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

One - Month Project: Ellipses Corp.Ellipses Corp. is a small business that operates in Herndon, VA . The company is located at 1 0 Period

One-Month Project: Ellipses Corp.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 2023 these four individuals are employed by Ellipses Corp.:Ellipses Corp. EmployeesNameAddressSSNFederal W/HAllow.State W/HAllow.MaritalStatusHunter Cranston85 Southern Road Herndon, VA 20170111-11-111122MarriedAllison Harrison203A Pine Court Herndon, VA 20170777-77-777743MarriedJohn Parker212 Tradition Lane Herndon, VA 20170444-44-444411SinglePierre Sternberg41 Seward BoulevardHerndon, VA 20170333-33-3333N/AN/AMarriedPierre Sternberg was hired in November and his first day of work was Friday, November 17. On his W-4 Form Pierre checked box 2c and left sections 3 and 4 blank. Pierre files as married filing jointly on his tax return. Additionally, due to an economic downturn, Allison Harrison was laid off in mid-December. Her last day of work was Thursday, December 7.All employees of Ellipses Corp. work a regular 40-hour workweek (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 Thursday for the current week (which runs from Friday through Thursday, but employees never work on weekends). The SUTA tax rate for Ellipses Corp. is 3.1%, and the SUTA wage base in Virginia is $8,000.Earnings and voluntary deduction information for each of the four employees is as follows:Earnings and Voluntary DeductionsNameRegularWage RateAnnualSalaryWeekly 401(k)DeductionWeekly CharitableCont. Hunter Cranston$15/hourN/A6% of gross pay$5Allison Harrison$23/hourN/A5% of gross pay$5John ParkerN/A$203,000.20N/A$20Pierre SternbergN/A$112,000.201% of gross payN/AThe first 11 months of the year have passed, and all payroll-related activity has been accounted for as of 11/30/2023. 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 CranstonPeriodGross EarningsFederalIncome TaxStateIncome TaxSocial Security TaxMedicareTax401(k)DeductionCharitableCont.Q1$7,800$143$366.60$483.60$113.10$468$65Q2$7,800$143$366.60$483.60$113.10$468$65Q3$7,800$143$366.60$483.60$113.10$468$65October$2,400$44$112.80$148.80$34.80$144$20November$3,000$55$141.00$186.00$43.50$180$25Allison HarrisonPeriodGross EarningsFederalIncome TaxStateIncome TaxSocialSecurity TaxMedicareTax401(k)DeductionCharitableCont.Q1$11,960$338$568.10$741.52$173.42$598$65Q2$11,960$338$568.10$741.52$173.42$598$65Q3$11,960$338$568.10$741.52$173.42$598$65October$3,680$104$174.80$228.16$53.36$184$20November$4,600$130$218.50$285.20$66.70$230$25John ParkerPeriodGross EarningsFederalIncome TaxStateIncome TaxSocialSecurity TaxMedicareTax401(k)DeductionCharitableCont.Q1$50,750.05$10,182.51$2,537.47$3,146.52$735.93$0$260Q2$50,750.05$10,182.51$2,537.47$3,146.52$735.93$0$260Q3$50,750.05$10,182.51$2,537.47$3,146.52$735.93$0$260October$15,615.40$3,133.08$780.76$492.84$226.44$0$80November$19,519.25$3,916.35$975.95$0$283.05$0$100Pierre SternbergPeriodGross EarningsFederalIncome TaxStateIncome TaxSocialSecurity TaxMedicareTax401(k)DeductionCharitableCont.Q1$0$0$0$0$0$0$0Q2$0$0$0$0$0$0$0Q3$0$0$0$0$0$0$0October$0$0$0$0$0$0$0November$4,307.70$641.98$213.24$267.08$62.46$43.08$0All tax payments and filings are made on the due date. Based on the data provided, you will complete the following:Establish an employee earnings record for each of the companys four employees. Complete the top portion of each record.Establish and complete the payroll register for each weekly pay period in December. When calculating federal income tax withholding, use the withholding tables where possible and refer to the percentage method only when necessary. For simplicity, calculate the state income tax withholding as 5% of each employees taxable pay (which is the same as taxable pay for FWT). Recall that state income tax withholding would ordinarily be calculated using the applicable states withholding tables. Payroll checks are remitted to the employees in the same order (Cranston, Harrison, Parker, Sternberg) each pay period and are written from a bank account used solely for these payments. The first payroll check written in December is check #762.All charitable contributions are deemed to be made on the final day of each pay period. The following information will be required for the completion of these records for the two employees who are compensated via an hourly wage:

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting

Authors: John Hoggett, Lew Edwards, Evelyn Hogg, John Medlin, Matthew Tilling

8th Edition

1742466362, 978-1742466361

More Books

Students also viewed these Accounting questions