Payroll accounting chapter 7 project solutions

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. ② The entry required for each employee is recorded in the payroll register. The names of all employees are listed in alphabetical order, including yours as “Student.” The fold-out payroll register forms needed to complete this project are in the Payroll Register (pages PR-3, PR-3, and PR-4). No deduction has been made for the time lost by Williams. Thus, the total number of hours (80) for which payment was made is recorded in the Regular Earnings Hours column of the payroll register. However, a notation of the time lost (D) was made in the Time Record column. When posting to Williams's earnings record, 80 hours is recorded in the Regular Earnings Hours column (no deduction for the time lost). In computing the federal income taxes to be withheld, the wage-bracket tables in Tax Table B. Pay Points Use tax tables for biweekly payroll period. Each payday, $8 was deducted from the earnings of the two plant workers for union dues (Bonno and Ryan). Payroll check numbers were assigned beginning with check no. 672. In the Labor Cost Distribution columns at the extreme right of the payroll register, each employee's gross earnings were recorded in the column that identifies the department in which the employee regularly works. The totals of the Labor Cost Distribution columns provide the amounts to be charged to the appropriate salary and wage expense accounts and aid department managers and supervisors in comparing the actual labor costs with the budgeted amounts. Once the net pay of each employee was computed, all the amount columns in the payroll register were footed, proved, and ruled. ③ An entry was made in the journal transferring from the regular cash account to the payroll cash account the amount of the check issued to Payroll to cover the net amount of the payroll; next, the entry was posted.