Continuing Payroll Problem, 28: 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 clerk'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 hourly rate or salary Time Card No. Employee Name Hourly Wage or Salary 11 Rob A. Mangino $18.50 per hour 12 Inga C. Flores 19.25 per hour 13 Carson S. Palmetto 17.00 per hour 21 Randy F. Waters 20.70 per hour 22 Cathy T. Krom 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 Ms. Carmen V. Ruppert prepares the time clerk's report for each pay period. Her report for the first week of operations is given below. *Note: All employees, except for Marshal Olney, are paid for hours worked beyond 40 at one and one-half times their regular hourly rate of pay. TIME CLERK'S REPORT NO. 1 For Period Ending January 8, 20-- Time Record Employee Time Worked Time Lost M ? W ? F S 11 8 8 8 8 8 40 12 8 8 8 8 10 8 50 13 8 542 8 8 9 9 38% 11 hrs, tardy 21 10 10 8 8 11 47 Rob A. Mangino Inga C. Flores Carson S. Palmetto Randy F. Waters Cathy T. Kroll Carmen V. Ruppert William M. Scott Sarah A. Wickman 22 8 8 8 8 8 40 31 8 8 8 8 8 1% 4114 32 8 8 8 8 8 40 33 8 8 8 8 8 40 51 Lucas T. Foley 8 8 8 8 9 4 45 99 Marshal W. Olney 8 8 8 8 8 40 Employee Payroll Register For Period Ending January 8, 20 - Regular Earnings Overtime Earnings No. W/H Allow. Hours Worked Rate per Hour Amount Hours Worked Rate per Hour Amount Total Earnings N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A Totals