Chapter 7 payroll project solutions 2015

I have a payroll project I would like some help on. The beginning is filled out and the rest has to be completed based on following the instructions from:
Payroll Accounting 2017, 27th Ed. Bieg & Toland. Cengage. LL + CNOW: 9781337734769
I have included some instructions but it would be easier if you have access to the book
I have also included the Excel sheets. The excel program has checkpoints that will tell you if the answer is wrong. I am currently struggling with this. I understand this is a time consuming project and will pay for someone's time. If one portion is incorrect, the rest will end out wrong as well.
Start of Project: Nov 1: The first payroll in October covered the two workweeks that ended on September 26 and October 3. This payroll transaction has been entered for you in the payroll register, the employees' earnings records, the general journal, and the general ledger. By reviewing the calculations of the wages and deductions in the payroll register and the posting of the information to the employees' earnings records, you can see the procedure to be followed each payday. Observe the following rules in computing earnings each pay period: 1. 2. 3. 4. 5. 6. Do not make any deduction from an employee's earnings if the employee loses less than 15 minutes of time in any day. Time lost that exceeds 15 minutes is rounded to the nearest quarter-hour and deducted. If the time lost by an employee is not to be deducted, the time clerk will make a notation to that effect on the Time Clerk's Report. In completing the time record columns of the payroll register for all workers, you should place an 8 in the day column for each full day worked (refer to page PR-2). If an employee works less than a full day, show the actual hours for which the employee will be paid. In the case of an employee who begins work during a pay period, compute the earnings by paying the employees their weekly rate for any full week worked. For any partial week, compute the earnings for that week by multiplying the hours worked by the hourly rate of pay. If time lost is to be deducted from a salaried employee's pay, the employee's pay must be determined by multiplying the actual hours worked for that week by the hourly rate. If hours are missed but no pay is deducted, include those hours in the Time Record columns on the payroll register. The following schedule shows the weekly and hourly wage rates of the salaried employees: Plant workers (Bonno and Ryan), other than supervisors, are employed on an hourly basis. Compute the wages by multiplying the number of hours worked during the pay period by the employee's hourly rate. The information needed and the sequence of steps that are completed for the payroll are presented in the following discussion. The time clerk prepared Time Clerk's Report Nos. 38 and 39 from the time cards used by the employees for these workweeks. Inasmuch as the president, sales manager, sales representatives, and supervisors do not ring in and out on the time clock, their records are not included in the time clerks report, but their salaries must be included in the payroll. ① The following schedule shows the hourly wage rates of the three hourly employees used in preparing the payroll register for the payday on October 9. Pay Points Tax calculations are to be taken to three decimal places and then rounded to two places.