Could someone help me with this problem please!

Instructions Hourly Wage/Salary Report Time Clerk's Report Payroll Register Instructions Continuing Payroll Problem, 2A: Chapter 2 Kipley Company is a small manufacturing firm located in Pittsburgh, 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. Assume that the first payday for kipley Company is January 14 for the workweek ending January 8 (Saturday). You are being asked to complete Kipley's Payroll Register for the pay period ending January 8, 20--, Ms. Glenda B. Robey prepares the Time Clerk's Report for each pay period. This along with the Hourly Wage/Salary Report is provided. Requirement: 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 Hourly Wage/Salary Report Kipley's Hourly Wage/Salary Report is provided below, listing each employee's assigned time card number as well as their individual hourly rate or salary. Time Card No. Employee Name 11 Fran M. Carson 13 21 Hourly Wage or Salary $17.50 per hour 17.25 per hour 18.10 per hour 17.90 per hour 19.75 per hour 515 per week 2,700 per month 3,350 per month 2,510 per month 52,000 per year William A. Wilson Harry T. Utley Lawrence R. Fife Lucy K. Smith Gretchen R. Fay Glenda B. Robey Thomas K. Schork Barbara T. Hardy Carson C. Kipley 31 32 33 51 99 Time Clerk's Report Time Clerk's Report Time Clerk's Report Ms. Glenda B. Robey 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 Carson Kipley, 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 Time M T W T. F Worked Lost Fran M. Carson 8 co 8 40 12. colo William A. Wilson 8 00 00 00 8 cococo co 00 48 13 Harry T. Utley 512 8 3712 21/2 hrs. tardy 21 Lawrence R. Fife 10 10 8 8 46 22 Lucy K. Smith 8 8 8 40 31 Gretchen R. Fay 8 8 8 8 8 114 4114 32 Glenda B. Robey 8 8 8 8 8 40 33 Thomas K. Schork 8 8 8. 8 8 40 51 Barbara T. Hardy 8 8 ca 8 8 44 99 Carson C. Kipley 8 co 8 8 40 Payroll Register Payroll Register This is the first task to completing Kipley Company's payroll register. Complete the steps outlined below: 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. If an amount box does not require an entry, leave it blank or enter "0". If required, round your intermediate calculations to the nearest cent and use the rounded amounts in subsequent computations. Round fraction values to the nearest two decimal places, e.g. 11/2 to 1.50. KIPLEY COMPANY, INC