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 savings retirement.

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 employee	Hours worked	Hourly wage	Weekly salary	Withdrawal payment	Union payment
Juan del Pueblo	43	$8.50		$21.93	$15
Ramonita Ramrez	41	11.50		37.12	Manager, does not pay a fee.
Brenda Montalvo	55		$1,100	88.00	Manager, does not pay a fee.
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	Manager, does not pay a fee.