Merge & Center $ - % Conditional Format Cell Formatting as Table Styles IMA D E F Problem #6 Two Books Accounting Services has three employees who, in 2020, are paid weekly as follows: Gross pay Philo Kvetch M. Bezzle Dicky Debit 4,650.00 2,550.00 600.00 The company is responsible for the following payroll taxes: $ Social security Medicare Federal Unemployment State unemployment Family leave Rate 6.20% 1.45% 0.60% 4.00% 0.270% Ceiling 137,700 Gross pay none 7,000 Gross pay 11,600 Gross pay 196.72 Tax per year $ $ $ Assuming there are FOUR payrolls in January calculate: B Merge A Center De $ % Conditional Format Cell Formatting as Table Styles IN A B C D E F 57 The company's social security expense for the month of January 58 The company's medicare expense for the month of January 59 The company's federal unemployment expense for the month of January 60 The company's state unemployment expense for the month of January Weekly withholdings to be used for questions 61 - 63 M. Bezzle Federal withholding State withholding Disability Philo Kvetch 837.00 335.00 280.50 112.20 0.60 Dicky Debit 30.00 12.00 0.60 0.60 61 Assuming the withholdings listed above along with other mandatory withholdings calculate the net pay for M. Bezzle for week #1 Acuminate withholdinalisted above and with other mandataithholding Sheet Calibri (Body) 11 A A LB Wrap Text III lili General BIU v Merge & Center $ %, 00 A B D E 62 Assuming the withholdings listed above along with other mandatory withholdings calculate the net pay for Philo Kvetch for week #1 63 Assuming the withholdings listed above along with other mandatory withholdings calculate the net pay for Philo Kvetch for week #52 64 Calculate the total amount of social security tax withheld from M. Bezzle for the entire year (52 paychecks). 65 Calculate the total amount of social security tax withheld from Philo Kvetch for the entire year (52 paychecks). +