The Short Payroll Project begins on page A-17 of your textbook. You will be completing the payroll cycle for two pay periods for Glo-Brite. 5. Before beginning the Short Payroll Project on page A-17, add the following employee to the payroll register: Woods, BethWoods biweekly salary is $1200. However, she only worked 9 days as of the Dec. 4 payroll date (72 hours). Therefore, you need to find her hourly pay and multiply by 72 hours to get her total pay for the December 4 pay period. 6. You are now ready to begin the December 4 payroll process. I have provided additional instructions below for each of the pay periods. DECEMBER 4 PAYROLL ADDITIONAL INFORMATION 1. Update the information for the following employees in the Payroll Register for the December 4 payroll (it is already updated in the Employees Earnings Record): Ford, Catherine $1280/biweekly pay Russell, Virginia $1260/biweekly pay Woods, Beth $1200/2 = $600/week $600/40 hrs. = $15/hour Biweekly pay = $15 * 72 = $1,080 2. On the following page is an image of how the Time Record and Regular Earnings columns in the Payroll Register should appear for the December 4 payroll. Ryans total hours are 79. However, he had 36 regular hours in the first week and 40 regular hours in the second week. Therefore, his regular hours are 76. The second week has 3 hours of overtime which will be recorded in the Overtime Hours column. . 3. Remember to complete the FIT, SIMPLE, UNION DUES, TAXABLE EARNINGS (OASDI, HI, SUTA, FUTA) and LABOR DISTRIBUTION columns of the Payroll Register. In order to complete the Taxable Earnings columns for SUTA and FUTA, you will need to check the earnings of each employee in the Employee Earnings Record to see if their cumulative earnings prior to this pay period have reached the maximum earnings for Pennsylvania SUTA (3.6785% on first $9,750 of gross earnings) and FUTA (.6% on first $7,000 of gross earnings). 4. You are instructed on page A-18 to increase Bonnos withholding allowances in the Employees Earnings Record before completing the next pay period. You will also need to change it in the Payroll Register. 5. You can leave the Check No. column blank in the Payroll Register. 6. Do not skip lines when posting to the ledger. If you do, the formulas that are already programmed into the spreadsheet will not recalculate properly. You will get VALUE in the cell where the balance should be. DECEMBER 14, VIRGINIA RUSSELL PAYROLL ADDITIONAL INFORMATION 1. Remember to transfer the amount of Virginia Russells net pay from the Cash account to the Payroll Cash Account. 2. You do not need to complete the Form W-2 as instructed on page A-19. DECEMBER 18, PAYROLL ADDITIONAL INFORMATION: 1. Payroll Register: a. Since you recorded Virginia Russells final pay on December 14, you will not record any pay for her in the December 18 payroll. 2. The Students hours total 67. However, the template was setup incorrectly with a total of 71 hours for the Student. Even though this is incorrect, enter 71 for the total hours for the Student. If you do not, then your check points will not show your answers as being correct. This is a publisher error that I hope they rectify in future editions of this textbook. 3. Remember to deduct for Group Insurance. You will need the Employee Earnings Record to calculate the amount of the deduction. For example, Bonnos deduction for Group Insurance will be $55,000/1000 * $.30 = $16.50. 4. In the OASDI Taxable Earnings column, ONeill is over the taxable wage base of $127,200. You will need to subtract his Cumulative Earnings after the December 4 pay period (found in the Employee Earnings Record) from $127,200 to find the amount of his wages that are subject to OASDI this pay period. 5. When completing the Check Points for the December 18 payroll and the Annual Payroll, you may be $.01 over due to an Excel issue. Therefore, if you are certain your answer is correct but it shows incorrect, add $.01 to your answer.