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. 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.
Expert Answer:
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
Related Book For
Posted Date:
Students also viewed these accounting questions
-
For each of the 20 top-grossing U.S. films made during the 1990s, file XR15043 lists the domestic gross ticket sales versus foreign gross ticket sales (both in millions of U.S. dollars). Determine...
-
Complete the requirements specified for each of the following independent situations. Instructions A. State the missing items identified by ?. 1. Net purchases + freight in = Cost of goods purchased...
-
1 What are the strategic objectives for each of the organisations involved? Provide a high-level benefits map to structure the objectives and necessary changes. 2 Who are the key stakeholders in such...
-
1. Resolve Class C 192.168.23.36 /27 2. Design DMZ minimumof 4 servers assigning an IP addressfor all devices 3. List and explain 4 primary servers that will be in the DMZ 4. Resolve Class C 192.168...
-
Job costing, unit cost, ending work in process. Raymond Company produces pipes for concert- quality organs. Each job is unique. In April 2009, it completed all outstanding orders, and then, in May...
-
Planned Change at the San Diego County Regional Airport Authority.Then answer the following three questions: When the transition team was formed, several team-building activities were held throughout...
-
A bank is considering extending loans to a population of four borrowers with identities A, B, C, and D. Borrowers A and B are of type 1, while C and D are of type 2. The bank cannot observe borrowers...
-
Variable costing versus absorption costing Lange Company incurred manufacturing overhead cost for the year as follows. The company produced 1,500 units and sold 1,000 of them at $180 per unit. Assume...
-
The measures of the interior angles of a quadrilateral are 2x + 10, 3x, 3x + 5, and 5x + 20. What is the measure of the largest angle? O A. 155 . 125 O C. 105 O D. 145
-
Find the capacitor voltage for t 0 for each of the circuits in Fig. 7.107. (a) (b) 3 2 12 v ( .) 4V 412 S F 6 A
-
A document stating that the bank will pay the depositor a guaranteed interest rate for money left on deposit for a specified period of time is a(n) Question 1 options: certificate of deposit. check....
-
What are the solutions of: 2x - 9x + 10?
-
1. In an ammonia synthesis process, heat integration is essential as there are hot streams to be cooled and cold streams to be heated. There are three process streams to be heat integrated. The...
-
You are bullish on Tesla. The current market price is $600. You have $30,000 of your own and you borrow $30,000 from your broker at an interest rate of 5% per year and invest $60,000 in the stock. a....
-
(a) Explain and correct the error in each of the following PHP code: (1) conn-mysql_connect("localhost","root",""); ()
-
In how many ways can the letters of the word GRADIENT be arranged so that two vowels are not placed together?" To solve this, we can use a combinatorial approach where we first arrange the consonants...
-
ABC an all equity firm has $40Mil shares outstanding. Its shares per value is $1 each. ABC shares are currently trading at $5. ABC issues a press statement saying it plans to borrow $40Mil and use...
-
The trade-off theory relies on the threat of financial distress. But why should a public corporation ever have to land in financial distress? According to the theory, the firm should operate at the...
-
The standard operating capacity of Tecate Manufacturing Co. is 1,000 units. A detailed study of the manufacturing data relating to the standard production cost of one product revealed the following:...
-
Using the data given for Cases 13 below, and assuming the use of the average cost method, compute the separate equivalent units of productionone for materials and one for labor and overheadunder each...
-
Georgia Gasket Company budgets 8,000 direct labor hours for the year. The total overhead budget is expected to amount to $20,000. The standard cost for a unit of the companys product estimates the...
-
Identify whether each of the following costs should be classified as product costs 399 (a) Manufacturing overhead. (d) Advertising expenses. (b) (c) Selling expenses. Administrative expenses. (e)...
-
Using the data in Q15, what are (a) the total cost of work in process and (b) the cost of goods manufactured? Data from in Q15 Jam Manufacturing Inc. has beginning work in process \($27,200\), direct...
-
Presented below are Hyde Company's monthly manufacturing cost data related to its personal computer products. Entei each cosl item in the following table placing an "X" undei the appropriate headings...
Study smarter with the SolutionInn App