Chapter 7 payroll project solutions

I need help with this payroll project from Chapter 7. This is the book: Payroll Accounting, by Beig, Toland, edition 2018, 28th edition. I attached an excel template with the beginning filled out, and just need to fill out the rest.
Subject
Business Finance

School
Southeast Kentucky Community and Technical College

Question Description
I need this completed as soon as possible. It is actually due by midnight but I have asked for an extension. I have looked at the answers for the 2017 version but the numbers do not match up. I started this project and I a stuck and just need to finish it.Excel Instructions CAUTION: Read Appendix A for specific instructions relating to these templates. 1. Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear to the right of an incorrect answer. 2. A formula begins with an equals sign (=) and can consist of any of the following elements: Operators such as + (for addition), - (for subtraction), * (for multiplication), and / (for division). Cell references, including cell addresses such as B52, as well as named cells and ranges Values and text Worksheet functions (such as SUM) 3. You can enter a formula into a cell manually (typing it in) or by pointing to the cells. To enter a formula manually, follow these steps: Move the cell pointer to the cell that you want to hold the formula. Type an equals sign (=) to signal the fact that the cell contains a formula. Type the formula, then press Enter. 4. Rounding: These templates have been formatted to round numbers to either the nearest whole number or the nearest cent. For example, 17.65 x 1.5=26.475. The template will display and hold 26.48, not 26.475. There is no need to use Excel's rounding function. 5. Remember to save your work. When saving your workbook, Excel overwrites the previous copy of your file. You can save your work at any time. You can save the file to the current name, or you may want to keep multiple versions of your work by saving each successive version under a different name. To save to the current name, you can select File, Save from the menu bar or click on the disk icon in the standard toolbar. It is recommended that you save the file to a new name that identifies the file as yours, such as Chapter_7_long_version_Your_Name.xlsx To save under a different name, follow these steps: Select File, Save As to display the Save As Type drop-box, chose Excel Workbook (*.xlsx) Select the folder in which to store the workbook. Enter the new filename in the File name box. Click Save. Page 41 JOURNAL DATE 20-- Oct. DESCRIPTION 9 Payroll Cash Cash POST. REF. DEBIT 12 11 12,052.01 9 Administrative Salaries Office Salaries Sales Salaries Plant Wages FICA Taxes Payable - OASDI FICA Taxes Payable - HI Employees FIT Payable Employees SIT Payable Employees SUTA Payable Employees CIT Payable Union Dues Payable Payroll Cash 51 52 53 54 20.1 20.2 24 25 25.1 26 28 12 2,307.69 4,651.08 3,600.00 4,898.00 9 Payroll Taxes FICA Taxes Payable - OASDI FICA Taxes Payable - HI FUTA Taxes Payable SUTA Taxes Payable - Employer 56 20.1 20.2 21 22 1,381.11 CREDIT 12,052.01 958.33 224.14 1,118.00 474.55 10.85 602.89 16.00 12,052.01 958.32 224.12 22.91 175.76 20 Employees SIT Payable Cash 25 11 474.55 23 Payroll Cash Cash 12 11 12,115.19 474.55 12,115.19 Page 42 JOURNAL DATE 20-- Oct. Nov. DESCRIPTION POST. REF. DEBIT 23 Administrative Salaries Office Salaries Sales Salaries Plant Wages FICA Taxes Payable - OASDI FICA Taxes Payable - HI Employees FIT Payable Employees SIT Payable Employees SUTA Payable Employees CIT Payable Group Insurance Premiums Collected Union Dues Payable Payroll Cash 51 52 53 54 20.1 20.2 24 25 25.1 26 27 28 12 2,307.69 4,651.08 3,600.00 5,219.60 23 Payroll Taxes FICA Taxes Payable -