Table for each employee and total the columns

Assignment Help Financial Accounting

Reference no: EM13761137

Mester Company has 9 employees. Fica Social Security taxes are 6.2% of the first $110,100 paid to each employee, and FICA Medicare taxes are 1.45% of gross pay. FUTA taxes are 0.8% and SUTA taxes are 5.4% of the first $7,000 paid to each emploee. Cumulative pay for the current year for each of its employees follows.
Steve S. $6,000
Tim V. $60,000
Brent G. $87,000
Christina S. $156,600
Kathleen K. $106,900
Michelle H. $110,100
Lori K. $116,600
Matt B. $36,800
Sankha B. $4,000

1. Prepare a table with the following column headings: Employee, Cumulative Pay, Pay subject to FICA Social Security Taxes, Pay subject to FICA Medicare Taxes, Pay subject to FUTA taxes, Pay subject to SUTA taxes. Compute the amounts in this table for each employee and total the columns. (Please show all work done to get each number)
2. For the company, compute each total for FICA social security taxes, FICA medicare taxes, FUTA taxes, and SUTA taxes. (remember to inclue in those totals any employee share of taxes that the company must collect)

Reference no: EM13761137

Questions Cloud

Fundamental concepts and principles in accounting : Identify and explain the fundamental concepts and principles in accounting, the components of the accounting equation, the primary financial accounting equation, and financial statements and reports.

Describe the target customer for the product : Describe the target customer for the product/service in terms of relevant characteristics that impact the marketing strategy, including location (how it should be reached) and buying habits.

Discuss the importance of disaster recovery : Discuss the importance of disaster recovery and/or business continuity planning with respect to maintaining the confidentiality, integrity, and availability of information and information systems

What are the two explanations of hayys origin : What is the point Ibn Tuffayl is trying to make with the blind child allegory (p. 97)? What is he trying to show or suggest? What are the two explanations of Hayy's origin? What is the difference between them?

Table for each employee and total the columns : 1. Prepare a table with the following column headings: Employee, Cumulative Pay, Pay subject to FICA Social Security Taxes, Pay subject to FICA Medicare Taxes, Pay subject to FUTA taxes, Pay subject to SUTA taxes. Compute the amounts in this table fo..

Describe the specific steps that your firm would : Define a business idea, preferably one that you create, that might work as a start-up firm in the United States. Your proposed firm should provide a particular product or service mainly to customers located outside the United States.

Create a table with headers : In the lookup workbook, create a table: with headers: Region, Metro, University, Employment, Enrollments 2. Build the table using direct sourcing from the appropriate tables to create this chart:

Applying theory to a practice problem : It is important to understand how borrowed theory can help you in your everyday environment as a nurse.

Paper about cyber security and identify assess and propose : Please refer to the latest document about cyber security and identify assess and propose: Risk related indicators and governance solutions, vulnerability assessment for cyber security

User Account

All Pages