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

2. Calculate each employee's gross salary. 3. Calculate the amount of Social Security and Medicare withholding. 4. Calculate each employee's net pay. 5. Wage the entry to register the payroll.

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

Nombre del empleado	Horas trabajadas	Salario por hora	Salario semanal	Pago de retiro	Pago de unin
Juan del Pueblo	43	$8.50		$21.93	$15
Ramonita Ramrez	41	11.50		37.12	Gerencial, no paga cuota.
Brenda Montalvo	55		$1,100	88.00	Gerencial, no paga cuota.
Camilo Monge	40	7.25		23.02	15
Jorge Emmanueli	46	25.00		92.00	15
Mariel Estrada	60	10.00		48.00	15
Emanuel Reyes	40	8.00		25.60	15
Ernesto Ramrez	40	8.25		26.40	15
Daniela Morales	38	10.75		32.68	15
ngel Carrasquillo	43		860	68.80	Gerencial, no paga cuota.