An excel spreadsheet must be use to complete the following activity: You work for a small business. The company offers employees a 401k plan. The company matches employee contributions to the plan up to 3 percent of the employee's gross pay. 1. Find each employee's contribution to a 401(k) account by multiplying the employee's gross pay by the contribution percentage. Find the employer's matching contribution and the total contribution amount for each employee. The employees are listed by employee number. 2. Find the employer's total contribution for all employees

An excel spreadsheet must be use to complete the following activity: You work for a small business. The company offers employees a 401k plan. The company matches employee contributions to the plan up to 3 percent of the employee's gross pay. 1. Find each employee's contribution to a 401(k) account by multiplying the employee's gross pay by the contribution percentage. Find the employer's matching contribution and the total contribution amount for each employee. The employees are listed by employee number. 2. Find the employer's total contribution for all employees

Principles of Accounting Volume 1

19th Edition

ISBN:9781947172685

Author:OpenStax

Publisher:OpenStax

Chapter12: Current Liabilities

Section: Chapter Questions

Problem 14EB: In EB13, you prepared the journal entries for Janet Evanovich, an employee of Marc Associates. You...

See similar textbooks

Similar questions

After evaluating the information provided by the employees of La Nueva Era bookstore: Determine the amounts that must be reported in the employees' W2.Calculate the Social Security and Medicare payment that the employer must make.Calculate the state unemployment that the employer must pay at the rate of 6% of the first $ 10,000 the employee earns.Make the entries to the wage related to the debts contracted with the different agencies in contributions by the employer. Employee Name Weekly salary Retirement payment Juan del Pueblo $1,250.00 $21.93 Ramonita Ramírez $950.00 $37.12 Brenda Montalvo $1,100.00 $88.00 Camilo Monge $590.00 $23.02 Jorge Emmanueli $860.00 $92.00 Mariel Estrada $1,020.00 $48.00 Emanuel Reyes $750.00 $25.60 Ernesto Ramírez $640.00 $26.40 Daniela Morales $1,000.00 $32.68 Ángel Carrasquillo $860.00 $68.80
Exercise 9-11 (Algo) Computing payroll taxes LO P2, P3 Mest Company has nine employees. FICA Social Security taxes are 6.2% of the first $137,700 paid to each employee, and FICA Medicare taxes are 1.45% of gross pay. FUTA taxes are 0.6% and SUTA taxes are 5.4 % of the first $7,000 paid to each employee. Cumulative pay for the current year for each of its employees follows. Employee Ken S Tim V Steve S Cumulative Pay $ 5,200 44,400 91,000 Employee Ken S Tim V Complete this question by entering your answers in the tabs below. Required A Compute the amounts in this table for each employee. Pay Subject to FICA Social Security Steve S Julie W Michael M Zach R Christina S Kitty O John W Totals a. Compute the amounts in this table for each employee. b. For the company, compute each total for FICA Social Security taxes, FICA Medicare taxes, FUTA taxes, and SUTA taxes. Hint Remember to include in those totals any employee share of taxes that the company must collect. Required B Employee Julie W…
A companny has an employee with a 5000 salary. Knowing that the Social Security rate is 29%, Health Insurance 12 %, Salary tax rate 10, establish the net salary to be paid to the employee. (Please don't use decimals in your answen). Answer
Audrey Martin and Beth James are partners in the Country Gift Shop, which employs the individuals listed below. Paychecks are distributed every Friday to all employees. Based on the information given, compute the amounts listed below for a weekly payroll period. Hint: It is important to ascertain whether a person's wages are considered wages or drawings. If an amount is zero, enter "0". Round your answers to the nearest cent. OASDI Taxable Name and Position Zena Vertin, Office Nicole Norge, Sales Bob Mert, Delivery Audrey Martin, Partner Beth James, Partner Totals Employer's OASDI Tax Employer's HI Tax Salary $720 per week 1,410 per month 485 per week 465 per week 465 per week $ Earnings $ OASDI Tax HI Taxable Earnings $ HI Tax
Supermarket Caridad offers its employees vacation benefits and contributes a 2% contribution to a 401K. The employees had total wages of $ 125,000 and vacation benefits of $ 28,460. Calculate how much the employer contributes for the 401k.Make the wage entries related to vacation pay.Make the wage entries related to the 401K contribution.
Supermercado Caridad offers its employees vacation benefits and contributes a 2% contribution to a 401K. Employees had total wages of $ 125,000 and vacation benefits of $ 28,460. Calculate how much the employer contributes for the 401k. Make the wage entries related to vacation pay. Make the wage entries related to the 401K contribution.
Think of a business you would want or most likely to up. Using the following format, list down the names of your employees (7 only) and compute for total pay.
Your company just hired a Junior Financial analyst with a net salary of 18,000 Dh / month. The company agreed to offer a retirement scheme for the employee, where both the employer and employee contribute 6% of the gross salary to CIMR (Retirement scheme). Prepare a payslip indicating: 1. Gross Salary 2. CNSS (Social Security): both employee and employer shares 3. AMO (Mandatory insurance): both employee and employer shares 4. CIMR (Retirement scheme): both employee and employer shares 5. What is the total cost incurred by the company?
Saleem Enterprises is a graphic design company. The accountant needs to prepare the relative journal entries to determine items related to salaries, deductions, and contributions. a) On May 31, Saleem Enterprises had gross pay for employees of $49,000. Total employee contributions to the retirement savings plan is $1,700. The appropriate deduction rates are provided. Record the entry for salaries expense on May 31. Federal income tax rate 9.00% State income tax rate 6.00% FICA 7.65% FUTA 0.60% ISUTA 5.40% Do not enter dollar signs or commas in the input boxes. Round your answer to 2 decimal places. For transactions with more than one debit, enter the debit accounts in alphabetical order. For transactions with more than one credit, enter the credit accounts in alphabetical order. Date Account Title and Explanation Debit Credit May 31 Record salaries and deductions b) Using the data from above and assuming Saleem Enterprises contributes the same amount toward the employee retirement…
Claude Lopez is the president of Zebra Antiques. His employee, Dwight Francis, is due a raise. Dwight's current benefit analysis is as follows: Yearly Benefit Costs Medical insurance Dental insurance Life insurance AD&D Short-term disability Long-term disability 401(k) Social Security Medicare Tuition reimbursement Total yearly benefit costs (employer) Employee's annual salary. The Total value of employee's compensation Required: Compute the benefit analysis assuming: Company Cost (Current) $ 8,000.00 120.00 300.00 150.00 60.00 30.00 750.00 3,018.16 705.86 $ 2,000.00 $ 15,134.02 50,000.00 $ 65,134.02 Employee Cost (Current) $ 1,200.00 120.00 0 0 0 0 1,500.00 3,018.16 705.86 0 • 3 percent increase in pay. • Dwight will increase his 401(k) contribution to 8 percent with a company match of 50 percent up to 6 percent of the employee's annual salary. • 15 percent increase in medical and dental insurance premiums. (Round your answers to 2 decimal places.)
· Prepare and use a payroll register including Social Security and Medicare withholdings. Use =IF and =ROUND to design the Social Security tax and union dues formulas. Record journal entries for payroll, employer's tax liability, and payment of payroll taxes. Identify behavior patterns among payroll taxes over time. Alter the worksheet to include an additional employee. Create a chart showing the percentage of an employee's gross pay that is withheld for taxes and other such deductions, and how much is left over as net pay. PROBLEM DATA Reno Graphics has five employees, and they are paid at the end of each month. Payroll data for November are as follows: Employee Jones Miller Smith Williams Zlotorzynski Gross Pay for November $9,000 1,530 1,210 12,000 4,200 Federal Income Tax Withheld $1,948 137 89 Cumulative Gross Pay at October 31 $? 15,570 6,550 2,788 661 Other information (using 2011 rates) is as follows: a. Social security taxes are 4.2% of monthly gross pay up to a cumulative…
To determine how much to deduct from the gross pay of Jason Parker, an employee of Jensen Ltd., one would look at the earnings record. O Form TD1. O payroll register. O Form T4.