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

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Feb 01, 2023

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

LL Paste C24 Copy Format Painter Clipboard A 4 Name 5 6 October Payroll 7 H Cranston # 8 A Harrison 9 J

Payroll Accounting: Chapter 7: Comprehensive Projects-Paper-Based Versions One-Month Project NOTE! Templates

M B 26 p of 11/30/2018. Please note that no paychecks were distributed on 1/1/2018 (as these checks were

Pierre Sternberg Period 1st quarter 2nd quarter 3rd quarter October November Gross Earnings SO $0 $0 SO

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

To establish an employee earnings record for each of the companys four employees we need to fill in ... 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

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

Recommended Textbook for

Principles Of Cost Accounting

Authors: Edward J. Vanderbeck

15th Edition

978-0840037039, 0840037031

More Books

Students also viewed these Accounting questions

Question

★★★★★

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...

Answered: 1 week ago

Question

★★★★★

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...

Answered: 1 week ago

Question

★★★★★

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...

Answered: 1 week ago

Question

★★★★★

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...

Answered: 1 week ago

Question

★★★★★

A firm has expected free cash flows to the firm of $12 million annually which are expected to grow at 3.5% each year. It uses both debt and equity. The cost of equity is 13% and the after-tax cost of...

Answered: 1 week ago

Question

★★★★★

What operating system functions would you expect to find in the computer that is built in to control your automobile, and which functions would be omitted? Justify your answer.

Answered: 1 week ago

Question

★★★★★

With reference to Example 3.6, suppose that there are m different types of coupons and Jimmy buys r packs of cereals (with r Answered: 1 week ago

Answered: 1 week ago

Question

★★★★★

Rit Corporation paid $1,372,000 for a 30 percent interest in Tel Corporations outstanding voting stock on April 1, 2011. At December 31, 2010, Tel had net assets of $4,000,000 and only common stock...

Answered: 1 week ago

Question

★★★★★

You have found the following stock quote for RJW Enterprises, Incorporated, in the financial pages of todays newspaper. 52-WEEK STOCK (DIV) YLD % PE VOLUME 100s CLOSE NET CHANGE HI LO 127.98 77.81...

Answered: 1 week ago

Question

★★★★★

The following table contains data for a hypothetical economy: Consumer Expenditures $500 million Wages $650 million Investment Expenditures $200 million Interest Payments $100 million Government...

Answered: 1 week ago

Question

★★★★★

Evaluate the Riemann sum for f(x) = 0.9x1.6 sin(2x) over the interval [0,2] using four subintervals, taking the sample points to be midpoints.

Answered: 1 week ago

Question

★★★★★

Entrepreneur and firm founder Oscar Farinetti has said that Eataly's "informal style of communication shows how direct and approachable we are, just the way people like." A focus on customer...

Answered: 1 week ago

Question

★★★★★

Bank Organizer Printers Inc, produces luxury checkbooks with three checks and stubs per page. Each checkbook is designed for an individual customer and is ordered through the customers bank. The...

Answered: 1 week ago

Question

★★★★★

PA1 LO 10.1 Artisan Metalworks has a bottleneck in their production that occurs within the engraving department. Jamal Moore, the COO is considering hiring an extra worker, whose salary will be...

Answered: 1 week ago

Question

★★★★★

CASE STUDY Should Packing Be Postponed to the DC? Penang Electronics (PE) is a contract manufacturer that produces and packages private-label products for several retail chains, including Target,...

Answered: 1 week ago

Question

★★★★★

6/6/22, 10:45 AM 3.4.5 Practice: Higher or Lower? Apex Learning - Practice Assignment U.S. and Global Economics (2019) Practice Points Possible: 30 Name: Date: Choose one of the scenarios below and...

Answered: 1 week ago

Question

★★★★★

24.7. You have been appointed a project manager for a small software products company. Your job is to build a breakthrough product that combines virtual reality hardware with state-of-the- art...

Answered: 1 week ago

Question

★★★★★

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...

Answered: 1 week ago

Question

★★★★★

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:...

Answered: 1 week ago

Question

★★★★★

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...

Answered: 1 week ago

Question

★★★★★

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...

Answered: 1 week ago

Question

★★★★★

1.15. You have data for a population, from a census. Explain why descriptive statistics are helpful but inferential statistics are not needed.

Answered: 1 week ago

Question

★★★★★

47. Consider a situation in which you and a friend both must choose a number from the two numbers 1 and 2. The relevant payoffs are as follows: If you choose 1 and he chooses 1, If you choose 1 and...

Answered: 1 week ago

Question

★★★★★

1.11. The "Student survey" data file at definitely yes, probably yes, probably not, and www.siat.ufl.edu/~aa/social/data.hlml showsresponses of a class ofsocialscience graduate students at the...

Answered: 1 week ago

Previous Question Next Question