Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please Provide step by step how to do this on excel TAB EMPLOYEES 1. Clean up the Employee Name in tab EMPLOYEES to be incompliance
Please Provide step by step how to do this on excel
TAB "EMPLOYEES" | |||||||||||||||||
1. Clean up the Employee Name in tab "EMPLOYEES" to be incompliance with the format "Doe,John" | |||||||||||||||||
2. Break the Employee Name into First Name (John) and Last Name (Doe) | |||||||||||||||||
3. Create employee email address with format: FirstName.LastName@xyz.com | |||||||||||||||||
4. Highlight employees having hour rate more than $60 | |||||||||||||||||
TAB "PAYROLL" | |||||||||||||||||
5. Calculate Gross Earnings (Gross = hourly rate x [regular hour + Vacation + Sick Leave]) | |||||||||||||||||
6. Calculate Deduction amount (Deduction amount = HCSP + Retirement + 401(k) + Health Insurance + Dental Insurance + Parking). Remember that employees might not have all of those deduction type. | |||||||||||||||||
7. Calculate Withholding amount. (Withholding amount = State WH + Federal WH + Social Security Tax + Medicare tax)
|
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