AutoSave OFF Home Insert Draw Calibri (Body) Poste v Page Layout Formulas Datal Review View Tell...

Transcribed Image Text:

AutoSave OFF Home Insert Draw Calibri (Body) Poste v Page Layout Formulas Datal Review View Tell me v 11 ' ' Wras Text G A Merge & Center B I U v fx B 1 F28 : x A 2 3 5 D Philo Kvetch & Company Philo Kvetch & Company has three employees who, in 2022, are paid weekly as follows: G H 7 8 Philo Kvetch M. Bezle 9 Dicky Debit Gross pay 4,600.00 2,600.00 700.00 10 11 The company is responsible for the following payroll taxes: 12 13 14 15 16 Social security Medicare Federal Unemployment 17 State unemployment 18 Family leave Rate 6.20% $ 1.45% none 0.60% $ Ceiling 147,000 Gross pay 7,000 Gross pay 4.00% $ 12,000 Gross pay 0.511% $ 423.71 Tax per year 19 20 Assuming there are FOUR payrolls in January calculate: 21 22 1 The company's social security expense for the month of January 23 24 2 The company's medicare expense for the month of January 25 26 9 The company's federal unemployment expense for the month of January 27 28 4 The company's state unemployment expense for the month of January 29 30 31 32 33 Weekly withholdings to be used for questions 5-7 34 35 36 Federal withholding 37 38 State withholding Disability Philo Kvetch M.Bezde Dicky Debit 828.00 286.00 35.00 331.00 114.40 14.00 0.60 0.60 0.60 39 40 5 11 42 43 6 14 Assuming the withholdings listed above along with other mandatory withholdings calculate the net pay for Assuming the withholdings listed above along with other mandatory withholdings calculate the net pay for Philo Kvetch M. Bezde for week #1 for week #1 Problem #12 Ready Problem #13 101 #5 Assignment W Share Comments General v $%9 00 Cell Conditional Format Formatting as Table Styles Insert Delete Format Sort & v Filter Find & Select Analyze Data Answers 1 2 3 4 5 6 K L M N P Q R S T L 100% AutoSave OFF Home Insert Draw Calibri (Body) Poste v Page Layout Formulas Datal Review View Tell me v 11 ' ' Wras Text G A Merge & Center B I U v fx B 1 F28 : x A 2 3 5 D Philo Kvetch & Company Philo Kvetch & Company has three employees who, in 2022, are paid weekly as follows: G H 7 8 Philo Kvetch M. Bezle 9 Dicky Debit Gross pay 4,600.00 2,600.00 700.00 10 11 The company is responsible for the following payroll taxes: 12 13 14 15 16 Social security Medicare Federal Unemployment 17 State unemployment 18 Family leave Rate 6.20% $ 1.45% none 0.60% $ Ceiling 147,000 Gross pay 7,000 Gross pay 4.00% $ 12,000 Gross pay 0.511% $ 423.71 Tax per year 19 20 Assuming there are FOUR payrolls in January calculate: 21 22 1 The company's social security expense for the month of January 23 24 2 The company's medicare expense for the month of January 25 26 9 The company's federal unemployment expense for the month of January 27 28 4 The company's state unemployment expense for the month of January 29 30 31 32 33 Weekly withholdings to be used for questions 5-7 34 35 36 Federal withholding 37 38 State withholding Disability Philo Kvetch M.Bezde Dicky Debit 828.00 286.00 35.00 331.00 114.40 14.00 0.60 0.60 0.60 39 40 5 11 42 43 6 14 Assuming the withholdings listed above along with other mandatory withholdings calculate the net pay for Assuming the withholdings listed above along with other mandatory withholdings calculate the net pay for Philo Kvetch M. Bezde for week #1 for week #1 Problem #12 Ready Problem #13 101 #5 Assignment W Share Comments General v $%9 00 Cell Conditional Format Formatting as Table Styles Insert Delete Format Sort & v Filter Find & Select Analyze Data Answers 1 2 3 4 5 6 K L M N P Q R S T L 100%