I attached a file
ACCT 1130 – Payroll Accounting Project Complete the Payroll Project using the following Steps: STEP #1: Download the Excel spreadsheet and immediately save it by replacing the words “Your_Name” with your First_Last name. Leave all other words in the file name. STEP #2: Review the Excel spreadsheet. It contains all of the information and templates you need to complete the Spring 2021 Payroll Project for ACCT 1130. Review all tabs carefully to understand the information being given to you. Company Information: Harbor, Inc. is a small business that operates in Woodstock, VT. The company is located at 14 The Greenway, Woodstock, VT 05091. Its Federal Employer Identification Number is 33-3333333, and its president, who signs all tax forms, is Melanie Blair (telephone #802-555-6853). The company does not wish to name a third-party designee on forms. During 2020 five individuals are employed by Harbor, Inc. These employees are as follows: Employee Name Employee Address Employee Social Security # Federal W/H Allowances Marital Status Cindy Nix 2819 East 3rd Street, Woodstock, VT 05091 123-45-6789 1 Single Jackson Tate 5514 Hwy. 301, Apt. #203, Chester, VT 05074 987-65-4321 2 Married Joint Melanie Blair 234 Lester Road, Woodstock VT 05093 432-98-7654 2 Single Lois Campbell 28 Chamblee Street, Woodstock, VT 05091 666-55-4444 2020 W-4 Sections 2,3,4 are blank Married Joint Your Name 1031 Burlington Street, Woodstock, VT 05091 111-22-5555 2020 W-4 Sections 2&4 are blank Single Notes: · Lois Campbell was hired in September, and her first day of work was Monday, September 21. On her 2020 W-4 Form Lois left sections 2, 3, and 4 blank. Lois files as married filing jointly on her tax return. · Cindy Nix was laid off in late November, with her last day of work on Friday, November 20. · Employees Nix and Tate work a regular 40-hour workweek while Employee "Your Name" works a regular 35-hour workweek. All hours in excess of an employee's regular work hours are considered overtime. Overtime is paid at 1.5 times the regular wage rate and employees are paid weekly on Sunday for the most recent week which runs Monday through Sunday. Employees do not work on weekends. · The first 3 quarters of the year have passed, and all payroll-related activity has been properly accounted for as of 9/30/2020. You will find the quarterly payroll data on each employee's EER. Wage, Salary, and Voluntary Deductions for Employees: Employee 4th Qtr Section 125 401(k) Charitable Contributions RegularWage Rate Annual Salary Cindy Nix $0/pay period Same as previous $10/pay period $14/hour Jackson Tate $0/pay period Same as previous $5/pay period $18/hour Melanie Blair $0/pay period Same as previous $15/pay period $262,000.44 Lois Campbell $0/pay period Same as previous $0/pay period $94,000.40 Your Name $50/pay period Same as previous $0/pay period $17/hour Weekly Hours Worked during the 4th Quarter: Week # of Qtr 4 Weekly Start Date Paycheck Date Cindy Nix Jackson Tate Your Name 1 September 28, 2020 October 4, 2020 40.0 44.0 35.0 2 October 5, 2020 October 11, 2020 42.0 37.0 37.5 3 October 12, 2020 October 18, 2020 38.0 40.0 39.0 4 October 19, 2020 October 25, 2020 40.0 46.5 35.0 5 October 26, 2020 November 1, 2020 43.5 42.0 36.0 6 November 2, 2020 November 8, 2020 40.0 45.0 37.0 7 November 9, 2020 November 15, 2020 39.0 40.0 40.0 8 November 16, 2020 November 22, 2020 41.0 34.5 36.0 9 November 23, 2020 November 29, 2020 0.0 40.0 38.5 10 November 30, 2020 December 6, 2020 0.0 41.0 37.0 11 December 7, 2020 December 13, 2020 0.0 43.5 35.0 12 December 14, 2020 December 20, 2020 0.0 42.5 35.0 13 December 21, 2020 December 27, 2020 0.0 40.0 37.0 Note: Tax Liability and payment amounts are determined based on the weekly pay dates. Step #3: Using the data given in the information from the first 3 quarters, complete the EER for each employee for the 4th quarter payroll periods. When calculating the FIT withholdings, use the Tax Tables when possible and the Percentage Method as necessary. Calculate the State Income Tax Withholding as 5% of the wages taxable for Federal withholdings. Keep all earnings and deductions at the same level as they were in the first 3 quarters, except where Section 125 deductions start during the 4th quarter. (See table above.) After recording all of the 4th quarter payroll information, your check figures for the EER's are as follows: Employee Name Y-T-D Net Pay Y-T-D Gross Pay Nix $19,408.37 $26,414.50 Tate $29,836.97 $37,948.50 Blair $173,082.51 $262,000.44 Campbell $19,557.02 $25,307.80 Your Name $21,437.39 $29,150.46 Step #4: After the EER for each employee is correct based on the check figures above, complete each of the 13 Payroll Registers for each pay period based on the data from the EER on each date. (Minor rounding differences (less than $.09) are expected and can be ignored.) NOTE: Do not move forward with the project until your check figures match the above numbers. If you move forward with incorrect data, your Project Grade will be a maximum of 35%. After completing all of the 4th quarter PRRs, the total Net Pay for each PRR should match the check figures as follows: Date Net Pay 10/4/2020 $6,383.53 10/11/2020 $6,310.85 10/18/2020 $6,326.85 10/25/2020 $6,401.45 11/1/2020 $6,385.42 11/8/2020 $6,409.18 11/15/2020 $6,358.18 11/22/2020 $6,234.24 11/29/2020 $5,926.51 12/6/2020 $5,918.39 12/13/2020 $5,931.20 12/20/2020 $5,911.64 12/27/2020 $5,898.83 Step #5: After the PRR for each period is correct based on the check figures above, complete the 13 Payroll Payment Journal Entries on the next tab. (Minor rounding differences (less than $.09) are expected and can be ignored.) Step #6: Complete the Medicare Calculation Sheet on the next tab. Step #7: Complete the FUTA/SUTA Calculation Sheet on the next tab. Remember that all employees except Campbell have already met the threshold for maximum wages for FUTA/SUTA taxes. The SUTA tax rate applicable to Harbor, Inc. is 2.5%, while the SUTA wage base in Vermont is $16,100. Based on your calculations and your Payroll records already completed, complete the Employee Payroll Taxes Journal entries on the next tab. Step #8: Review the 3rd Quarter 941 calculations on the next tab, and then complete the 941 calculations for the 4th quarter on the following tab. Once this sheet is completed, you can complete the Tax Payment Journal Entries on the next tab. Step #9: Complete IRS Form 941 for the 4th Quarter. Step #10: Complete the Form 940 Calculations on the next tab. Step #11: Complete IRS Form 940 for 2020. (Hint: since your FUTA taxes are so low, you have not made any payments during 2020.) Step #12: Complete the FUTA Journal Entry and the SUTA Tax Calculation on the next 2 tabs. Step #13: Fill in the 4th quarter numbers for each employee on the W-2 Calculation Sheet. Once this is done, the W-3 calculation sheet will automatically be populated with the numbers needed for the W-3 Form. Step #14: Complete IRS Form W-2 for each employee and the IRS Form W-3 for Harbor, Inc.