The Michaels Company has eight employees that are paid the follow amounts before taxes and other deductions for Dec. $2022$

a$.$

Required

Using the Tax Table above, determine the take home pay after deductions for each employee using the rates presented below

Also calculate the amount of Employment Taxes paid by the company

Note: You must create table by using Excel Functions

Use the following information for further "hints".

b$.$

Required

Using the journal entries on p$.9-17$ as a guide, complete the journal entry for salaries expense and withholding for the totals

computed above

Using the journal entries on p$.9-17$ as a guide, complete the journal entry for payroll Taxes.