Question: Please complete the payroll document using the directions that are attached IN EXCEL Turn this data range into a table of your choice Calculate Gross

Please complete the payroll document using the directions that are attached IN EXCEL

Turn this data range into a table of your choice Calculate Gross Pay = Hourse worked x Rate Calculate FICA Tax = Gross Pay x 7.65\% Calculate 401K amounts that the company is providing = Gross Pay x Column G Calculate Net Pay = Gross Pay - Medical insurance FICA Tax - 401K Company Calculate New Wage Increase = Raise increase %x Rate Calculate New Wage = Rate + New Wage Increase Calculate New Gross Pay = New wage x Hours Worked Create a total row at the bottom that shows total hours worked, Medical Insurance, Gross pay, FICA Tax, 401K Company, Net pay and New Gross Pay Create a pie chart of your choice that shows the breakdown of net pay for each employee Turn this data range into a table of your choice Calculate Gross Pay = Hourse worked x Rate Calculate FICA Tax = Gross Pay x 7.65\% Calculate 401K amounts that the company is providing = Gross Pay x Column G Calculate Net Pay = Gross Pay - Medical insurance FICA Tax - 401K Company Calculate New Wage Increase = Raise increase %x Rate Calculate New Wage = Rate + New Wage Increase Calculate New Gross Pay = New wage x Hours Worked Create a total row at the bottom that shows total hours worked, Medical Insurance, Gross pay, FICA Tax, 401K Company, Net pay and New Gross Pay Create a pie chart of your choice that shows the breakdown of net pay for each employee

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Please attach excel document with formulas answering questions on the picture. 1 Turn this data range into a table of your choice 2 Calculate Gross Pay = Hourse worked x Rate 3 Calculate FICA Tax =...

You are the Payroll Accountant for Olney Company, Inc., a small manufacturing firm located in Chalfont Boro, PA. Your manager, Director of Human Resources, is in the process of determining if and...

Excel Lab: Please complete this completely. Thanks 1. To successfully complete this assignment,I strongly recommend that you complete the Excel file in Excel Chapter 3 before you start this...

our supervisor met with Mr. Z and discussed his requirements in detail. At that meeting, they agreed on the following deliverables for your project. Document process activity using BPMN. After...

What are the answers to this Scenario: You are the Payroll Accountant for Olney Company. Has Steps 1- 4 Directions Scenario: You are the Payroll Accountant for Olney Company, Inc., a small...

Scenario: You are the Payroll Accountant for Olney Company, Inc., a small manufacturing firm located in Allentown, PA. Your manager, Director of Human Resources, is in the process of determining if...

Scenario: You are the Payroll Accountant for Olney Company, Inc., a small manufacturing firm located in PA. Your manager, Director of Human Resources, is in the process of determining if and when the...

Directions : Complete the payroll cycle using the template provided in Blackboard. Follow the steps outlined below to ensure you complete all required parts of the process. When completing this...

Telefonica, a spanish conglomerat, with 30% revenues in Spain, 20 % in Germany, 20% in Brazil, 15% Mexico and United States respectively is considering undergoing a merger with Amrica Mvil, the...

Why is identification of the real problem the first and most important step in the decision-making process? How does attribution theory explain mistakes that can be made as managers and employees...

6. Do I save for my vacations, or do I charge everything and take months paying off my credit card at high interest?

SIMAD UNIVERSITY Class: BACC25 Subject: Islamic Accounting Instructions: a) Follow The Instructions. Midterm Exam Instructor: All Ibrahim Date: 6-4-2022 b) You Have 1.5 Hrs. To Complete This Test. c)...

6. Assume you are in charge of establishing a training program for supervisors in administering discipline. Based on the supervisors potential role in the disciplinary process, formulate and discuss...

1. Wrongful Discharge. A reference is made in this chapter to a RAND study on the economic consequences of wrongful termination. Find an abstract of the study on RANDs Web site. What effect does the...

4. Seven Tests for Just Cause. A common test for determining whether just cause exists for imposing disciplinary actions was developed by arbitrator Carroll Daugherty in 1966. The standard is known...