Complete the following tasks mentioned in the "complete the following tasks" excel spreadsheet. Update the other spreadsheets in regards to each task and fill them out with the correct informations and calculations...:

Employee Subledger:

General Ledger:

Complete the following Tasks 1. Received approved payroll time card for Rodney Johnson for the pay period ended November 30, 2021. Rodney worked 88 regular hours and 10.50 hours of overtime. Samuel Mayo is a salaried employee. Pay rates are on the Pay Rate History Schedule (separate tab in this spreadsheet). Complete the payroll journal entries for Samuel Mayo and Rodney Johnson. Check No. 902 was issued to Mayo, No. 903 to Johnson dated November 30, 2021. Hourly employees receive time and a half for overtime. Federal income taxes for the period are $512.23 for Samual Mayo and $112.42 for Rodney Johnson. FICA is 7.65% of Gross Pay (6.20% for Social Security Tax on wages up to $142,800 and 1.45% for Medicare Tax). Be sure to update the employee subledger, including the cumulative annual total for 2018 . Payroll checks are drawn on the regular bank account. Be sure to Reference the check numbers in the cash disbursement journal. 2. Use the SUM function in Excel to foot the totals for each column in the payroll journal. Cross-foot the totals to verify that net pay equals gross pay minus deduction. 3 Post the column totals to the appropriate general ledger account and update each general ledger account balance. Place a posting reference check mark [X] under each column total in the journal. 4 At the end of the month, the company needs to record payroll taxes for the month. Record the payroll tax accruals for November in the general journal and post the entry to the general ledger. The company needs to match FICA taxes paid by the employees. The company needs to pay federal and state unemployment taxes (FUTA) and (SUTA) on the first $7,000 of gross wages paid to covered employees. The FUTA rate is 0.6% (0.006) and the SUTA rate is 2.7% (0.027). Note: Only one employee has earned less than $7,000. PAY RATE HISTORY Pay Rate Time Unit Filing Status Withholding Allowances Effective Date Approved By Samuel S. Mayo $4,100.00 $4,300.00 semimonthly semimonthly M M 2 2 1/1/20 1/1/21 SSM SSM Rodney C. Johnson $13.50 hourly S 1 9/15/21 SSM Soc.Sec.No. Phone No. 458-37-8299 (214) 454-7811 Employee's Name Home Address Employed Date of Birth Rodney C. Johnson 2745 Poco Mas Drive, Dallas, TX 75247 Date of Termination Occupation Forklift Operator 9/15/18 2/6/87 DATE Period Ending Paid 10-1-21 Balance forward HOURS WORKED Regular Overtime Hours Hours Gross Pay 1,188.00 Federal Income Tax 103.67 F.I.C.A. 90.88 Net Pay 993.45 88.00 88.00 5.50 9.75 10-15-21 10-15-18 10-31-21 10-30-18 Cumulative Annual Total 11-15-21 11-13-18 1,299.38 1,385.44 3,872.81 1,456.31 99.40 105.99 296.27 111.41 105.48 107.69 316.84 115.07 1,094.49 1,171.76 3,259.70 1,229.83 88.00 13.25 PAYROLL JOURNAL NOVEMBER 2021 Subs Ck. Regular Hours Date EARNINGS Overtime Overtime Gross Pay Hours Pay G/L 40500 4,300.00 13.25 268.31 1,456.31 Post Ref DEDUCTIONS F.I.C.A. Fed.Inc. Tax G/L 20600 G/L 20300 328.95 512.23 111.41 115.07 Regular Pay 4,300.00 1,188.00 Employee 15 Samual Mayo 30 Rodney Johnson PAYMENT Net Pay G/L 10100 3,458.82 1,229.83 No. Nov. 856 Nov. 88.00 857 CASH DISBURSEMENTS JOURNAL NOVEMBER 2021 Check Date No. Description 15-Nov 856-857 See Payroll Journal CREDIT Cash Purch. Disc. G/L 10100 G/L 30700 A/P - G/L 20100 Subs. A/C# Amt. DEBIT Freight-in G/L 30800 Other G/L A/C# Amt. Post Post GENERAL JOURNAL NOVEMBER 2021 ACCT. NO. DATE EXPLANATION POST DEBIT CREDIT Journal Debit Credit 1,460.23 20600 - F.I.C.A. TAXES PAYABLE Oct. 1 Balance Forward Oct. 31 Oct. 31 F.I.C.A. Withheld Oct. 31 Employer's Tax Nov. 30 CD PR G CD Balance 1,460.23 0.00 840.38 1,680.76 0.00 840.38 840.38 1,680.76 Journal Debit Credit 40500 - WAGES AND SALARIES EXP. Oct. 1 Balance Forward Oct. 31 Debit Balance 100,281.22 111,266.60 PR 10,985.38 Journal Debit Credit 40600 - PAYROLL TAX EXPENSE Oct. 1 Balance Forward Oct. 31 Debit Balance 8,161.52 9,090.50 G 928.98 Complete the following Tasks 1. Received approved payroll time card for Rodney Johnson for the pay period ended November 30, 2021. Rodney worked 88 regular hours and 10.50 hours of overtime. Samuel Mayo is a salaried employee. Pay rates are on the Pay Rate History Schedule (separate tab in this spreadsheet). Complete the payroll journal entries for Samuel Mayo and Rodney Johnson. Check No. 902 was issued to Mayo, No. 903 to Johnson dated November 30, 2021. Hourly employees receive time and a half for overtime. Federal income taxes for the period are $512.23 for Samual Mayo and $112.42 for Rodney Johnson. FICA is 7.65% of Gross Pay (6.20% for Social Security Tax on wages up to $142,800 and 1.45% for Medicare Tax). Be sure to update the employee subledger, including the cumulative annual total for 2018 . Payroll checks are drawn on the regular bank account. Be sure to Reference the check numbers in the cash disbursement journal. 2. Use the SUM function in Excel to foot the totals for each column in the payroll journal. Cross-foot the totals to verify that net pay equals gross pay minus deduction. 3 Post the column totals to the appropriate general ledger account and update each general ledger account balance. Place a posting reference check mark [X] under each column total in the journal. 4 At the end of the month, the company needs to record payroll taxes for the month. Record the payroll tax accruals for November in the general journal and post the entry to the general ledger. The company needs to match FICA taxes paid by the employees. The company needs to pay federal and state unemployment taxes (FUTA) and (SUTA) on the first $7,000 of gross wages paid to covered employees. The FUTA rate is 0.6% (0.006) and the SUTA rate is 2.7% (0.027). Note: Only one employee has earned less than $7,000. PAY RATE HISTORY Pay Rate Time Unit Filing Status Withholding Allowances Effective Date Approved By Samuel S. Mayo $4,100.00 $4,300.00 semimonthly semimonthly M M 2 2 1/1/20 1/1/21 SSM SSM Rodney C. Johnson $13.50 hourly S 1 9/15/21 SSM Soc.Sec.No. Phone No. 458-37-8299 (214) 454-7811 Employee's Name Home Address Employed Date of Birth Rodney C. Johnson 2745 Poco Mas Drive, Dallas, TX 75247 Date of Termination Occupation Forklift Operator 9/15/18 2/6/87 DATE Period Ending Paid 10-1-21 Balance forward HOURS WORKED Regular Overtime Hours Hours Gross Pay 1,188.00 Federal Income Tax 103.67 F.I.C.A. 90.88 Net Pay 993.45 88.00 88.00 5.50 9.75 10-15-21 10-15-18 10-31-21 10-30-18 Cumulative Annual Total 11-15-21 11-13-18 1,299.38 1,385.44 3,872.81 1,456.31 99.40 105.99 296.27 111.41 105.48 107.69 316.84 115.07 1,094.49 1,171.76 3,259.70 1,229.83 88.00 13.25 PAYROLL JOURNAL NOVEMBER 2021 Subs Ck. Regular Hours Date EARNINGS Overtime Overtime Gross Pay Hours Pay G/L 40500 4,300.00 13.25 268.31 1,456.31 Post Ref DEDUCTIONS F.I.C.A. Fed.Inc. Tax G/L 20600 G/L 20300 328.95 512.23 111.41 115.07 Regular Pay 4,300.00 1,188.00 Employee 15 Samual Mayo 30 Rodney Johnson PAYMENT Net Pay G/L 10100 3,458.82 1,229.83 No. Nov. 856 Nov. 88.00 857 CASH DISBURSEMENTS JOURNAL NOVEMBER 2021 Check Date No. Description 15-Nov 856-857 See Payroll Journal CREDIT Cash Purch. Disc. G/L 10100 G/L 30700 A/P - G/L 20100 Subs. A/C# Amt. DEBIT Freight-in G/L 30800 Other G/L A/C# Amt. Post Post GENERAL JOURNAL NOVEMBER 2021 ACCT. NO. DATE EXPLANATION POST DEBIT CREDIT Journal Debit Credit 1,460.23 20600 - F.I.C.A. TAXES PAYABLE Oct. 1 Balance Forward Oct. 31 Oct. 31 F.I.C.A. Withheld Oct. 31 Employer's Tax Nov. 30 CD PR G CD Balance 1,460.23 0.00 840.38 1,680.76 0.00 840.38 840.38 1,680.76 Journal Debit Credit 40500 - WAGES AND SALARIES EXP. Oct. 1 Balance Forward Oct. 31 Debit Balance 100,281.22 111,266.60 PR 10,985.38 Journal Debit Credit 40600 - PAYROLL TAX EXPENSE Oct. 1 Balance Forward Oct. 31 Debit Balance 8,161.52 9,090.50 G 928.98