1. Establish an employee earnings record for each of the company's four employees. Complete the top...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. Establish an employee earnings record for each of the company's four employees. Complete the top portion of each record. 2. Establish and complete the payroll register for each weekly pay period during December. When calculating federal income tax withholding, use the withholding tables where possible, and refer to the percentage method only when necessary. Note that as of December 8, Hunter Cranston requests that his federal withholding allowances increase from two to three (Ellipses Corp. makes this change). Additionally, for simplicity, calculate the state income tax withholding as 5% of each employee's taxable pay (which is the same as taxable pay for FWT). Recall that state income tax withholding would ordinarily be calculated using the applicable state's 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 that is used solely for these payments. The first payroll check written in December is check #762. Note that 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. L us One-Month Project 227 en 21 months of the year have passed, and all payroll-related activity has been properly accounted for as 2018 Pinase note that no paychecks were distributed on 1/1/2018 (as these checks were written and mbed on 12/31/2017 instead), resulting in the distribution of checks on 13 pay dates during the first mall data for each of the four employees for the first three quarters of the year, as well as for the the of October and November, is as follows. Hunter Cranston Period Gross Earnings $7.800 Federal State Social Income Tax Income Tax Security Tax Medicare 401(k) Tax Deduction Charitable Cont $234 $366.60 548360 $113.10 $468 $65 er $7.800 $234 $366.60 $483.60 $113.10 5468 $65 ater $7.800 $234 $366.60 $483.60 $113.10 $468 565 $2.400 572 $112.80 $148.80 $34.80 $144 $20 verder $3,000 590 $141 $186 $43.50 $180 $25 Allison Harrison Gross Period Earnings Federal tricome Tax State Social Medicare 401(k) Charitable Income Tax Security Tax Tax Deduction Cont. parter $11,960 $429 $568.10 $741.52 $173.42 $598 $65 der $11,960 $429 $568.10 $741.52 $173.42 $598 565 tlarid 30er $11.960 $429 $568.10 $741.52 $173.42 5598 565 Genober $3,680 $132 $174.80 $228.16 $53.36 $184 $20 erber $4,600 $165 $218.50 $285.20 $66.70 $230 $25 John Parker Gross Federal State Social Medicare 401(k) Charitable Period Earnings Income Tax Income Tax Security Tax Tax Deduction Cont. arter $50,750.05 $11,035.18 $2,537.47 53,146.52 $735.93 50 $260 Quarter $50,750.05 $11,035.18 $2,537.47 $3,146.52 $735.93 50 $260 $50,750.05 $11,035.18 $2,537 47 $1,667.76 $735.93 $0 $260 October $226.44 50 580 $15,615.40 $3,395.44 $780.76 50 ember $19,519.25 $4,244.30 $975.95 $283.05 $0 $100 50 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 Identication Number is 71-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. Dusing 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 85 Southern Road 111-11-1111 2 Married Herndon, VA 20170 Allison Harrison 203A Pine Court Herndon, VA 20170 777-77-7777 4 Married John Parker 212 Tradition Lane Herndon, VA 20170 444-44-4444 1 1 Single Pierre Sternberg 41 Seward Boulevard Herndon, VA 20170 333-33-3333 2 2 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 N/A 6% of gross pay $5 Allison Harrison $23/hour N/A 5% of gross pay $5 John Parker N/A $203,000.20 N/A $20 Pierre Sternberg N/A $112,000.20 1% of gross pay N/A Pierre Sternberg mprehensive Projects-Paper-Based versions Period Gross Earnings Federal State Social Medicare Income Tax Income Tax Security Tax Tax 401(k) Deduction Cont Charitable 1st quarter $0 $0 50 SO 2nd quarter $0 SO $0 50 88 50 50 50 50 S0 3rd quarter SO $0 $0 50 50 October $0 $0 $0 50 $0 88 50 50 November $2,153.85 $228.94 $106.62 $133.54 $31.23 $21.54 50 1. Establish an employee earnings record for each of the company's four employees. Complete the top portion of each record. 2. Establish and complete the payroll register for each weekly pay period during December. When calculating federal income tax withholding, use the withholding tables where possible, and refer to the percentage method only when necessary. Note that as of December 8, Hunter Cranston requests that his federal withholding allowances increase from two to three (Ellipses Corp. makes this change). Additionally, for simplicity, calculate the state income tax withholding as 5% of each employee's taxable pay (which is the same as taxable pay for FWT). Recall that state income tax withholding would ordinarily be calculated using the applicable state's 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 that is used solely for these payments. The first payroll check written in December is check #762. Note that 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. L us One-Month Project 227 en 21 months of the year have passed, and all payroll-related activity has been properly accounted for as 2018 Pinase note that no paychecks were distributed on 1/1/2018 (as these checks were written and mbed on 12/31/2017 instead), resulting in the distribution of checks on 13 pay dates during the first mall data for each of the four employees for the first three quarters of the year, as well as for the the of October and November, is as follows. Hunter Cranston Period Gross Earnings $7.800 Federal State Social Income Tax Income Tax Security Tax Medicare 401(k) Tax Deduction Charitable Cont $234 $366.60 548360 $113.10 $468 $65 er $7.800 $234 $366.60 $483.60 $113.10 5468 $65 ater $7.800 $234 $366.60 $483.60 $113.10 $468 565 $2.400 572 $112.80 $148.80 $34.80 $144 $20 verder $3,000 590 $141 $186 $43.50 $180 $25 Allison Harrison Gross Period Earnings Federal tricome Tax State Social Medicare 401(k) Charitable Income Tax Security Tax Tax Deduction Cont. parter $11,960 $429 $568.10 $741.52 $173.42 $598 $65 der $11,960 $429 $568.10 $741.52 $173.42 $598 565 tlarid 30er $11.960 $429 $568.10 $741.52 $173.42 5598 565 Genober $3,680 $132 $174.80 $228.16 $53.36 $184 $20 erber $4,600 $165 $218.50 $285.20 $66.70 $230 $25 John Parker Gross Federal State Social Medicare 401(k) Charitable Period Earnings Income Tax Income Tax Security Tax Tax Deduction Cont. arter $50,750.05 $11,035.18 $2,537.47 53,146.52 $735.93 50 $260 Quarter $50,750.05 $11,035.18 $2,537.47 $3,146.52 $735.93 50 $260 $50,750.05 $11,035.18 $2,537 47 $1,667.76 $735.93 $0 $260 October $226.44 50 580 $15,615.40 $3,395.44 $780.76 50 ember $19,519.25 $4,244.30 $975.95 $283.05 $0 $100 50 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 Identication Number is 71-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. Dusing 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 85 Southern Road 111-11-1111 2 Married Herndon, VA 20170 Allison Harrison 203A Pine Court Herndon, VA 20170 777-77-7777 4 Married John Parker 212 Tradition Lane Herndon, VA 20170 444-44-4444 1 1 Single Pierre Sternberg 41 Seward Boulevard Herndon, VA 20170 333-33-3333 2 2 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 N/A 6% of gross pay $5 Allison Harrison $23/hour N/A 5% of gross pay $5 John Parker N/A $203,000.20 N/A $20 Pierre Sternberg N/A $112,000.20 1% of gross pay N/A Pierre Sternberg mprehensive Projects-Paper-Based versions Period Gross Earnings Federal State Social Medicare Income Tax Income Tax Security Tax Tax 401(k) Deduction Cont Charitable 1st quarter $0 $0 50 SO 2nd quarter $0 SO $0 50 88 50 50 50 50 S0 3rd quarter SO $0 $0 50 50 October $0 $0 $0 50 $0 88 50 50 November $2,153.85 $228.94 $106.62 $133.54 $31.23 $21.54 50
Expert Answer:
Answer rating: 100% (QA)
Here are the payroll records and registers for Ellipses Corp for the given payroll periods in December Hunter Cranston Payroll Record Period 1 1281214 ... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
The unadjusted trial balance and the adjustment data for Robin Training Institute are given below along with adjusting entry information. Robin Training Institute Unadjusted Trial Balance as at 31...
-
Suppose a bank in the island republic of Banana Land, known as Banana Bank has $20 million in reserves, $80 million in loans, $10 million in securities, $100 million in deposits and $10 million in...
-
10 1 Journalize the following transactions for Bigelow Company for the month of October. 31 Oct Stockholders invest cash in the company in exchange for common stock. 5 Oct The company buys a delivery...
-
Assume a passenger dies aboard an international flight, and that there was no defibrillator aboard the aircraft that might have been used to revive him. Do you think the failure to have a...
-
Briefly explain what inflation targeting is and list the five (5) main elements related to it. Then discuss the three advantages and three (3) disadvantages of this type of monetary policy strategy.
-
Identify the asset class for each of the following: (a) supplies, (b) office equipment, (c) inventory, (d) land for future expansion, and (e) trucks used in operations.
-
A local government has five federal grants. Expenditures amounted to $2,000,000 during the year, as follows: Type A HUD grant, new and never audited.........$600,000 HHS grant, audited last year, no...
-
Researchers collect continuous data with values ranging from 0-100. In the analysis phase of their research they decide to categorize the values in different ways. Given the way the researchers are...
-
Which of the following is a positive reason for learning chemistry? (a) Chemistry is relevant to daily life (b) Chemistry offers career opportunities (c) Chemistry studies interesting topics (d)...
-
If you want to save $60,000 for a down payment on a home in 7 years, assuming an interest rate of 4.7 percent compounded annually, how much money do you need to save each month?
-
Write a free verse poem Free verse is non-rhyming andnon-metered, meaning youre free from the rules of a metered formlike a haiku or sonnet. Instead of making your lines fit a rhymescheme or metered...
-
Umar wants to buy Derek's house. The purchase price is $900,000 and there is an outstanding mortgage in favour of Scotiabank in the amount of $400,000. Umar has $600,000 in savings to put towards the...
-
An MRI technician moves her hand from a region of very low magnetic field strength into an MRI scanner's 2.00 T field with her fingers pointing in the direction of the field.
-
What is wrong with the statements being made in relation toNorse mythology? 7) With Selvig\'s help, he is freed and resigns himself to exileon Earth as he develops a romance with Jane. Loki discovers...
-
Provide a specific example of a device that contains at least one simple machine. Identify the simple machine and the task for which it was used. Note: You may use any of the simple machines, except...
-
1. Identify 6 characteristics of critical thinking concepts and approaches? 2. Identify 3 limitations of workplace policies and procedures {100-150wordss} 3. What is the key legislation relating to...
-
How does the organizational structure of an MNC influence its strategy implementation?
-
What criteria must be met for a unit of activity within the factory to qualify as a cost center?
-
The sales department of S. Miller Manufacturing Company has forecast sales for its single product to be 20,000 units for the month of June, with three-quarters of the sales expected in the East...
-
What are factory overhead expenses, and what distinguishes them from other manufacturing costs? What other terms are used to describe factory overhead expenses?
-
Sota Company has the following production data for April: units transferred out 40,000, and ending work in process 5,000 units that are 100% complete for materials and 40% complete for conversion...
-
Motta Company has the following production data for April: units started and completed 40,000, and ending work in process 5,000 units that are 100% complete for materials and 40% complete for...
-
That 25 -cent postcard in the gift shop may soon become a thing of the past. RogueSheeps postage application is giving the traditional postcard a run for its money, as it allows users to send a...
Study smarter with the SolutionInn App