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: [email protected]
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)
Attachment:- Excel.xlsx