1. Prepare the New Pharmacy payroll record with the following columns: employee name, number of...

70.2K

Verified Solution

Question

Accounting

image

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. Make 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: Withdrawal Hours worked Hourly wage Weekly salary payment Union payment Name of the employee Juan del Pueblo Ramonita Ramrez 43 $8.50 $21.93 $15 41 11.50 37.12 Manager, does 55 $1,100 not pay a fee. Manager, does 88.00 not pay a fee. 23.02 151 40 7.25 46 25.00 92.00 15 Brenda Montalvo Camilo Monge Jorge Emmanueli Mariel Estrada Emanuel Reyes Ernesto Ramrez 60 10.00 48.00 15 40 8.00 25.60 15 40 8.251 26.40 151 Daniela Morales 38 10.75 32.68 15 ngel Carrasquillo 43 860 68.80 Manager, does not pay a fee. 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. Make 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: Withdrawal Hours worked Hourly wage Weekly salary payment Union payment Name of the employee Juan del Pueblo Ramonita Ramrez 43 $8.50 $21.93 $15 41 11.50 37.12 Manager, does 55 $1,100 not pay a fee. Manager, does 88.00 not pay a fee. 23.02 151 40 7.25 46 25.00 92.00 15 Brenda Montalvo Camilo Monge Jorge Emmanueli Mariel Estrada Emanuel Reyes Ernesto Ramrez 60 10.00 48.00 15 40 8.00 25.60 15 40 8.251 26.40 151 Daniela Morales 38 10.75 32.68 15 ngel Carrasquillo 43 860 68.80 Manager, does not pay a fee

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students