Continuing Payroll Problem, 2B: Chapter 2 Olney Company, Inc. is a small manufacturing firm located in Newtown, Pennsylvania. The company has a workforce of both hourly and salaried employees. Each employee is paid for hours actually worked during each week, with the time worked being recorded in quarter- hour increments. The standard workweek consists of 40 hours, with all employees being paid time and one-half for any hours worked beyond the 40 regular hours. Wages are paid every Friday, with one week's pay being held back by the company. Thus, the first payday for Olney Company is January 14 for the workweek ending January 8 (Saturday). The Payroll Register for the pay period ending January 8, 20-- will be completed by you. Ms. Carmen V. Ruppert prepares the time derk's report for each pay period, which is provided on the Time Clerk's Report page. Also, the Hourly wage/Salary Report is provided. Requirements: 1. Record the regular hours and the overtime hours worked for each employee, using the time clerk's report as your reference, 2. Complete the Regular Earnings columns (Rate per hour and Amount) for hourly employees. For only hourly employees that worked overtime, complete the Overtime Earnings columns (Rate per Hour and Amount). For salaried workers, complete the Regular Earnings column and show the hourly overtime rate and earnings only if overtime was worked. 3. Record the Total Earnings for each employee by adding the Regular Earnings and the Overtime Earnings. Hourly Wage/Salary Report The Hourly Wage/Salary Report is provided below which lists each employee, their assigned time card number and their individual hou rate or salary. Time Card No. Employee Name Hourly wage or Salary 11 Rob A. Mangino $18.50 per hour 12 Inga G. Flores 19.25 per hour 13 Carson S. Palmetto 17.80 per hour 21 Randy F. Waters 20.70 per hour 22 Cathy T. Kroll 23.80 per hour 31 Carmen V. Ruppert 800 per week 32 William M. Scott 780 per week 33 Sarah A. Wickman 3,500 per month 51 LUCAS T. Foley 4,500 per month 99 Marshal W. Olney 78,000 per year TIME CLERK'S REPORT NO. 1 For Period Ending January 8, 20-- Time Record Employee Time Time Worked M T w T F S Lost 11 8 8 8 co 8 40 12 8 8 8 8 10 8 50 13 Rob A. Mangino Inga C. Flores Carson S. Palmetto Randy F. Waters Cathy T. Kroll 8 51 8 8 382 1% hrs. tardy 9 11 21 10 10 8 8 - 47 22 8 8 8 8 8 - 40 31 Carmen V. Ruppert 8 8 8 8 8 144 41% 32 William M. Scott 8 8 8 8 on 40 33 Sarah A. Wickman 8 8 8 8 8 40 51 Lucas T. Foley 00 8 8 8 9 45 99 Marshal W. Olney OP 8 8 8 8 40 Time Card No. Name Filing Status No. W/H Allow. Name Hours Worked Rate per Hour Amount Hours Worked Rate per Hour 11 Mangino, R. S N/A 12 Flores, S N/A 13 Palmetto, MF) N/A 21 Waters, MF N/A 22 Kroll, S N/A 31 Ruppert, ) NA 32 Scott, W MED N/A 33 Wickman, s S N/A 51 Foley, I MA N/A 99 Olney, M MF3 N/A Rate per Hour Amount Total Earnings $ N/A N/A *** Totals