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...
-
Harold Co. reported the following current-year purchases and sales data for its only product. Harold uses a perpetual inventory system. Determine the costs assigned to ending inventory and to cost of...
-
1. Identify possible causes that could explain Intertechs declining profitability. What steps can the Stadlens take to reverse this alarming trend? 2. What can the Stadlens do to manage their...
-
Show that the variance of a factorial effect in a $2^{k}$ design with $m$ replications is \[\frac{4 \sigma^{2}}{N}\] where $N=m \cdot 2^{k}$ and $\sigma^{2}$ is the variance of each outcome.
-
In the past, Arup Mukherjees tire dealership in Pensacola sold an average of 1,000 radials each year. In the past 2 years, 200 and 250, respectively, were sold in fall, 350 and 300 in winter, 150 and...
-
1. 2. The lessee makes a lease payment of $67,200 to the lessor for equipment in an operating lease transaction. Pharoah Company leases equipment from Noble Construction Inc. The present value of the...
-
The Alfredo Fragrance Company produces only one product, a perfume called Hint of Elegance. Hint of Elegance consists of two secret ingredients blended into an exclusive fragrance, which is marketed...
-
4. Implementing Gradient Descent. In this question you will implement gradient descent for an easy problem: convex quadratic functions. Consider the problem: min: f(x) = =Qx+qx. where Q is a...
-
At the beginning of the year, you had 20 widgets in inventory valued at $50 each. During the year, we purchased 50 more at $60 each. There were five still in inventory at the end of the year....
-
Tech Solutions is a consulting firm that uses a job - order costing system. Its direct materials consist of hardware and software that it purchases and installs on behalf of its clients. The firm s...
-
Hahn Company uses a job - order costing system. Its plantwide predetermined overhead rate uses direct labor - hours as the allocation base. The company pays its direct laborers $ 2 2 . 0 0 per hour....
-
White Company has two departments, Cutting and Finishing. The company uses a job - order costing system and computes a predetermined overhead rate in each department. The Cutting Department bases its...
-
Zhang incorporated her sole proprietorship by transferring inventory, a building, and land to the corporation in return for 1 0 0 percent of the corporation s stock. The property transferred to the...
-
Consider the following cash flows of the two mutually exclusive projects. Assume the discount rate for both projects is 8 percent. Year 0 1 2 3 Project A -1,500 750 1,250 270 Project B -3,300 2,050...
-
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...
-
The following financial information is available for Plummer SA. The weighted-average number of ordinary shares outstanding was 80,000 for 2024 and 100,000 for 2025. Instructions Calculate return on...
-
Gorton Ltd. has 30,000 shares of 10 par value ordinary shares outstanding when it announces a 2- for-1 share split. Before the split, the shares had a market price of 120 per share. After the split,...
-
The equity section of Ahab SA at December 31 is as follows. Instructions From a review of the equity section, as chief accountant, write a memo to the president of the company answering the following...
Study smarter with the SolutionInn App