Payroll record

1. Prepare the New Pharmacy payroll record with the following columns: employee name, number of hours worked, hourly wage, gross weekly wage, social security discount, Medicare discount, amount of state taxes and retirement savings.

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. Journalize 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:

Name of the Hours hourly Weekly Withdrawal Union employee worked wage salary payment payment Juan del 44 $8.50 $21.93 $15 Pueblo Ramonita 42 11.50 37.12 Managerial, Ramirez does not pay a fee Brenda 52 $1,100 88.00 Managerial, Montalvo does not pay a fee. Camilo Monge 40 7.25 23.02 15 Jorge 49 25.00 92.00 15 Emmanueli Mariel Estrada 60 10.00 48.00 15 Emanuel 40 8.00 25.60 15 Reyes Ernesto 45 8.25 26.40 15 Ramirez Daniela 38 10.75 32.68 15 Morales Angel 43 860 68.80 Managerial, Carrasquillo does not pay a fee