This is payroll liabilities. Create a payroll register worksheet with this information. The first image is the problem. The second image is the work that I have been doing so far.

Process lass week's payroll for one of your favorite clients. Today is August 8, 2021. The employees listed below are paid weekly and the first pay period August 1 - 7 just ended. INSERT a new worksheet in this file named 1. Payroll and complete the payroll register started below to calculate gross wages, social social security and medicare tax withholdings, health insurance deduction if applicable and net pay for each employee on this payroll. If the employee participates in the company's health insurance plan, the required deduction is 5 percent of their current gross wages. Finish processing payroll by adding all of the journal entries management will need to record the occurance and payment of payroll in the rows below the payroll register. Payroll Register Pay Period: August 1 - 7, 2021 Pay Date August 9, 2021 Social Security Wage Base: $ 146,700.00 State Income Year-to-date Federal Income Tax Health Employee No. Employee Name Gross Wages Hourly Rate Hours Worked Tax Withholding Withholding Insurance? 1 Todd Bertuzzi $ 98,994.00 S 117.85 30 530.33 159.10 Y 2 Dylan Larkin 27,092.80 24.19 40 S 145.14 S 43.54 Y 3 Filip Zadina S 23,940.00 S 28.50 30 S 128.25 S 38.48 N 4 Danny Dekeyser 15,190.00 S 15.50 35 81.38 S 24.41 N Filip Hronek 24,920.00 S 22.25 40 133.50 S 40.05 Alex Nedeljkovic 164,640.00 S 147.00 40 882.00 S 264.60 YSocial Security Tax Rate: 6.20% Union Dues monthly withholding amount 45.00 Social Security Base Amount: $ 146,700.00 U* If Y, the employee is a member of the Union. Medicare Tax Rate: 1.45% Medicare Base Amount: S 1. PAYROLL REGISTER Pay Period: December 1 - 7, 2021 Pay Date: August 9, 2021 NOVEMBER DECEMBER Social Federal Security Medicare Union Health Employee Health Year-to-date Hours Income Tax | Withholdi | Withholdi Dues Insurance Emp. No. Last Name Insurance Gross Wages Hourly Rate Worked Gross Wages Withholding ng ng Deduction Premium Net Pay 1 Bertuzzi Y $ 98,994.00 S 117.85 30 $ 3,535.50 S 530.33 S S $ 125.00 $ 2,880.17 Larkin Y $ 27,092.80 S 24.19 40 967.60 S 145.14 S $ 125.00 S 697.46 3 Zadina N $ 23,940.00 S 28.50 30 to 855.00 S 128.25 S 5 125.00 601.75 4 Dekeyser N $ 15,190.00 S 15.50 35 542.50 S 81.38 S $ 125.00 336.12 5 Hronek $ 24,920.00 S 22.25 40 890.00 S 133.50 S $ 125.00 631.50 6 Nedeljkovic Y $ 164,620.00 S 147.00 40 S 5,880.00 S 882.00 S $ 125.00 $ 4,873.00 Totals $ 354,756.80 S 355.29 215 $ 12,670.60 $ 1,900.60 S S $ 750.00 $ 10,020.00