• Payroll record

NO INFORMATION MISSING !!!

1. Make the New Pharmacy payroll recordwith the following columns: employee name, number of hours worked, hourly wage, weekly gross wage, social security discount, Medicare discount, amount of state taxes and savings of retirement.
2. Calculate the gross salary of each employee.
3. Calculate the amount withholding from Social Security and Medicare.
4. Calculate the net pay for each employee.
5. Jornalize the entry to record the payroll.

The New Pharmacy pays for overtime hours and a half. It does not pay overtime to employees who are paid by salary. The company has 10 employees and the information on the hours worked is as follows:

Employee Name Hours Worked Hourly Salary Weekly Salary Retirement Pay Union Pay

Juan del Pueblo 45 $ 8.50 $ 21.93 $ 15

Ramonita Ramrez 42 11.50 37.12 Manager, no fee.

Brenda Montalvo 50 $ 1,100 88.00 Manager, no fee.

Camilo Monge 43 7.25 23.02 15

Jorge Emmanueli 42 25.00 92.00 15

Mariel Estrada 50 10.00 48.00 15

Emanuel Reyes 38 8.00 25.60 15

Ernesto Ramrez 45 8.25 26.40 15

Daniela Morales 39 10.75 32.68 15

ngel Carrasquillo 40 860 68.80 Manager, does not pay a fee.

RUBRIC:

1. Correctly prepare the payroll record with the indicated columns as requested, demonstrating a thorough understanding of the required procedure.
2. Correctly calculates the gross salary of each employee, demonstrating a thorough understanding of the required procedure.
3. Correctly calculates the amount of Social Security and Medicare withholding, demonstrating a thorough understanding of the required procedure.
4. Correctly calculates the net pay for each employee, demonstrating a thorough understanding of the required procedure.
5. Correctly records the entry to record the payroll, demonstrating a thorough understanding of the required procedure.