Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Excel Lab 1 : MODIFIED: FALL SEMESTER 2 0 2 3 TAB EMPLOYEES 1 . Clean up the Employee Name in tab EMPLOYEES to be
Excel Lab : MODIFIED: FALL SEMESTER
TAB "EMPLOYEES"
Clean up the Employee Name in tab "EMPLOYEES" to be incompliance with the format "Doe, John"
Break the Employee Name into First Name John and Last Name Doe please note that no middle names or initials should be included in either column
Create employee email address with format: FirstName.LastName@xyzcom
Highlight employees having hour rate more than $
TAB "PAYROLL"
Calculate Gross Earnings
Calculate Deduction amount Deduction amount HCSP Retirement k Health Insurance Dental Insurance Parking Remember that employees might not have all of those deduction types.
Calculate Withholding amount. Withholding amount State WH Federal WH Social Security Tax Medicare tax
Please put totals in for the columns in requirements use of the SUM function is recommended Your totals can appear at the top or bottom of the columns and should match the check figures provided.
Failure to include totals will result in the loss of points in accordance with the grading rubric.
Deduction Rate
Health Care Saving Plan HCSP of Gross amount
Retirement of Gross amount
Health Insurance F Family $ per pay period
Health Insurance S Single $ per pay period
Dental Insurance F Family $ per pay period
Dental Insurance S Single $ per pay period
Parking $ per pay period
Tax Withholding Rate
State of Gross Deduction
Federal of Gross Deduction
Social Security Tax of Gross HCSP Health Insurance Dental Insurance
Medicare Tax of Gross HCSP Health Insurance Dental Insurance
Step by Step Solution
There are 3 Steps involved in it
Step: 1
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