Question
Can anyone help with all 5 questions/problems? All information is listed below. One-month Project -- The project focuses on Ellipses Corporation which begins on Page
Can anyone help with all 5 questions/problems? All information is listed below.
One-month Project -- The project focuses on Ellipses Corporation which begins on Page 226. You will complete payroll-related tasks for the month of December and will then finalize year-end reporting. All forms and documents needed for this problem are located under Handouts/Chapter 7 Final Payroll Project Documents. Read pages 226 -229. These pages will give you information regarding the payroll records and general information regarding the companys employees as well as what needs to be done.
1--- Establish an employee earnings record for each of the companys four employees. Complete the top portion of each record at this time. I have included the accumulated earnings for each employee prior to the month of December. Locate the earnings records in the Final Project Template worksheet.
2---Complete the payroll register for each weekly pay period during December. You will need to complete five payroll registers (12/1, 12/8, 12/15, 12/22, 12/29). Locate the payroll registers in the Final Project Template worksheet.
3---Complete the employee earnings records for the month of December for each of the four employees. Earnings records are located in the Final Project Template worksheet. Record the necessary journal entries for each pay period. Locate the journal in the Final Project Template worksheet.
4---Complete Form 941 for the 4th quarter Form 941 is located under Chapter 6 Final Payroll Project Documents. There is an excel summarized Information sheet for the 941. This report is located in the Final Project Template worksheet under Rprt Info-941. Once you add your December earnings information in this report, you will have the needed information to complete Form 941 at your fingertips. You will need to upload Form 941 separately under coursework. You do not have to record the necessary journal entries associated with Form 941.
5---Complete Copy A of Form W-2 for each of the four employees. W-2 forms are located under Chapter 6 Final Payroll Project Documents. You will need to do a file save as four times in order to complete a W-2 for each employee. You only have to complete the first document (Copy A) for each employee.
One-Month Project 11 mo s of Octe Cran included in the Studen NOTE! Templates needed to complete these exercises are for this course Corp. is a small business that operates in Herndon, VA. The Hierndon, VA 20170. Its federal Employer Identification N all tax forms,is John Parker (telephone #571-555-003er is 77 company is located at 10 Perin 3). The company does not wish to designee on forms. Durng 2017 our indiriduals are employed by Ellpses Corp. These employes ars Federal W/H State wH Social Security Allowances Allowances Name Parker Cranston 85 Southern Road Herndon, VA 20170 777-77-7777 4 Allison Harrison 203A Pine Court Herndon, VA 20170 Allison Ha 444-44-4444 ohnPrkerHermdon. er 212 Tradition Lane Herndon, VA 20170 Singe period 1st quarter 2nd quarter ard quarter 41 Seward Boulevard Herndon, VA 20170 333-33-3333 2 Pierre Stermberg Note that Pierre Sternberg was hired in November, and his first day of work was Monday, November 27 Additionally, due to an economic downturn, Allison Harrison was laid off in mid-December, with ber last day work on Friday, December 15. October sorp work a regular 40-hour workweek chus week are overtime hours), receive overtime pay at a rate of 1.5 times the regular wage rate, and are pad wtesr John Parl on Friday for the current week (which runs from Saturday through Friday, although emploges peve wen work onweekends TheSUTAtax rate applicable to Ellipses Corp. is 3.1%, while the SUTAwagebasei vrgn.? 8,000. Earnings and ist quarte nd quarte rd quarte Regular Wage Rate Annual Weekly 40 Weekly Charitable Parker Cranston $15/hour Allison Harrison $23 hour ohn Parker Pierre Sternberg N/A Salary Deduction N/A N/A $203,000.20 N/A $112,000.20 | 1% of gross pay Contribution $5 $5 $20 N/A 6% of gross pay 5% of gross pay N/A One-Month Project 11 mo s of Octe Cran included in the Studen NOTE! Templates needed to complete these exercises are for this course Corp. is a small business that operates in Herndon, VA. The Hierndon, VA 20170. Its federal Employer Identification N all tax forms,is John Parker (telephone #571-555-003er is 77 company is located at 10 Perin 3). The company does not wish to designee on forms. Durng 2017 our indiriduals are employed by Ellpses Corp. These employes ars Federal W/H State wH Social Security Allowances Allowances Name Parker Cranston 85 Southern Road Herndon, VA 20170 777-77-7777 4 Allison Harrison 203A Pine Court Herndon, VA 20170 Allison Ha 444-44-4444 ohnPrkerHermdon. er 212 Tradition Lane Herndon, VA 20170 Singe period 1st quarter 2nd quarter ard quarter 41 Seward Boulevard Herndon, VA 20170 333-33-3333 2 Pierre Stermberg Note that Pierre Sternberg was hired in November, and his first day of work was Monday, November 27 Additionally, due to an economic downturn, Allison Harrison was laid off in mid-December, with ber last day work on Friday, December 15. October sorp work a regular 40-hour workweek chus week are overtime hours), receive overtime pay at a rate of 1.5 times the regular wage rate, and are pad wtesr John Parl on Friday for the current week (which runs from Saturday through Friday, although emploges peve wen work onweekends TheSUTAtax rate applicable to Ellipses Corp. is 3.1%, while the SUTAwagebasei vrgn.? 8,000. Earnings and ist quarte nd quarte rd quarte Regular Wage Rate Annual Weekly 40 Weekly Charitable Parker Cranston $15/hour Allison Harrison $23 hour ohn Parker Pierre Sternberg N/A Salary Deduction N/A N/A $203,000.20 N/A $112,000.20 | 1% of gross pay Contribution $5 $5 $20 N/A 6% of gross pay 5% of gross pay N/AStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started