Calculate gross earnings and calculate deduction amount

Assignment Help Financial Accounting

Reference no: EM13310398

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

Reference no: EM13310398

Questions Cloud

Compute the kinetic energy of the alpha particle : The isotope 226 Ra Alpha decays. its measured atomic mass is 226.02541 amu, the daughter nucleus has a mass of 222.01758 amu and helium has atomic mass 4.0026 amu. calculate the kinetic energy of the alpha particle

Determine the required mass of c and the length of the cable : if D has a mass of 600 kg, determine the required mass of C, the maximum sag h of the cable, and the length of the cable between the pulleys A and B. The Beam has a mass per unit length of 50 kg/m.

Brief description of the project objectives : Development of new software to address green computing for internal use and potential sale to other organizations.

Determine the fossil age : An archaeologist uses carbon dating to find the age of some ancient fossils. Determine the fossil age

Calculate gross earnings and calculate deduction amount : Calculate Gross Earnings and calculate Deduction amount and calculate Withholding amount

What is the maximum external pull in each of the 4 gears : If a tractor with 23-hp, a max speed of 3.6 mph in 1st gear and an effieiciency of 92% is operated operated down a 4% slope and the rolling resistance is 80 lb/ton, what is the maximum external pull in each of the 4 gears.

Professionalism and ethics in accounting : Professionalism and ethics in accounting and the history of accounting.

What is the total energy of the atom : If we imagine an electron as orbiting the proton, with the orbit of radius 5 x 10 ^-11 m, what is the total energy of the atom

Find out the ph of an hf solution : Determine the pH of an HF solution of each of the following concentrations: a) 4.60 x 10^-2 b) 2.30 x 10^-2

User Account

All Pages