1. Prepare the Payroll Record for the New Pharmacy 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. Calculates the gross salary of each employee. 3. Calculates the amount of Social Security and Medicare withholding. 4. Calculates the net pay of each employee. 5. Journal the entry to record the payroll. The New Pharmacy pays for overtime hours on a one-and-a-half-time. It does not pay overtime to employees who are paid for pay. The company has 10 employees and the information on the hours worked is as follows: Employee name Juan del Pueblo Hours worked 43 Hourly wage $8.50 Weekly wage ----- Withdrawal payment $21.93 Union payment $15 Employee name: Ramonita Ramirez Hours worked: 41 Hourly wage: $11.50 Weekly wage: ------- Withdrawal payment: $31.12 Union payment: Management, does not pay fee. Employee name: Brenda montalvo Hours worked: 55 Hourly wage: ---- Weekly wage: $1,100 Withdrawal payment: $88 Union payment: Management, does not pay fee. Employee name: Camilo Monge Hours worked: 40 Hourly wage: $7.25 Weekly wage: Withdrawal payment Union payment: $23.02 Employee name: Jorge Emmanueli Hours worked: 46 Hourly wage: $25 Weekly wage: Withdrawal payment: $92 Union payment: 15 Employee name: Mariel Estrada Hours worked: 60 Hourly wage: $10 Weekly wage: Withdrawal payment: 48 Union payment: 15 Employee name: Emannuel Reyes Hours worked: 40 Hourly wage: 8 Weekly wage: Withdrawal payment: 25.60 Union payment: 15 Employee name: Ernesto Ramirez Hours worked: 40 Hourly wage: 8.25 Weekly wage: Withdrawal payment: 26.40 Union payment: 15 Employee name: Daniela Morales Hours worked: 38 Hourly wage: 10.75 Weekly wage: Withdrawal payment: 32.68 Union payment: 15 Employee name: Angel carrasquillo Hours worked: 43 Hourly wage: Weekly wage: 860 Withdrawal payment: 68.80 Union payment: management, does not pay fee. Social segurity tax (6% Medicare tax 1.5% Unemployed tax 1.5% Federal unemploment .80%