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
Chapter12: Current Liabilities
Section: Chapter Questions
Problem 14EB: In EB13, you prepared the journal entries for Janet Evanovich, an employee of Marc Associates. You...
Related questions
Question
![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.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F3b530802-e2f1-4388-9194-56bfbdd24d99%2Fd35091d2-ac23-4c2e-908f-979b7b669fd9%2Fd1gs6no_processed.png&w=3840&q=75)
Transcribed Image Text: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.
![401(k) Contributions
Period Ending February 14, 20--
Employee No.
Gross Pay
Employee %
4568
$2,150.00
3%
4321
1,088.00
2%
3257
2,840.00
5%
3921
2,010.00
1%
3415
2,166.00
2%
3401
3,455.00
3%
4563
1,920.00
4%
Employee
Amount
Employer
Amount
Total Amount](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F3b530802-e2f1-4388-9194-56bfbdd24d99%2Fd35091d2-ac23-4c2e-908f-979b7b669fd9%2Fl652uu_processed.png&w=3840&q=75)
Transcribed Image Text:401(k) Contributions
Period Ending February 14, 20--
Employee No.
Gross Pay
Employee %
4568
$2,150.00
3%
4321
1,088.00
2%
3257
2,840.00
5%
3921
2,010.00
1%
3415
2,166.00
2%
3401
3,455.00
3%
4563
1,920.00
4%
Employee
Amount
Employer
Amount
Total Amount
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 3 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
![PAYROLL ACCT., 2019 ED.(LL)-TEXT](https://www.bartleby.com/isbn_cover_images/9781337619783/9781337619783_smallCoverImage.gif)
![Individual Income Taxes](https://www.bartleby.com/isbn_cover_images/9780357109731/9780357109731_smallCoverImage.gif)
Individual Income Taxes
Accounting
ISBN:
9780357109731
Author:
Hoffman
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
![PAYROLL ACCT., 2019 ED.(LL)-TEXT](https://www.bartleby.com/isbn_cover_images/9781337619783/9781337619783_smallCoverImage.gif)
![Individual Income Taxes](https://www.bartleby.com/isbn_cover_images/9780357109731/9780357109731_smallCoverImage.gif)
Individual Income Taxes
Accounting
ISBN:
9780357109731
Author:
Hoffman
Publisher:
CENGAGE LEARNING - CONSIGNMENT