I have an excel homework I need help with. Here is the instructions and excel sheet needed.

Office Accounting Chapter 7 & 8 Written Test Directions: Part I. The payroll clerk of XYZ Company gathered the following data from the individual employee earnings records. Your task is to complete a payroll register on March 30. Employee Allowance & Marital Status Eric Wood John Doe Susie Que S-0 S-3 S-1 Cumulative Earnings Before This Payroll $5,600 $50,000 $101,000 Biweekly Salary $800 $2,000 $2,080 Check No. Department 29 30 31 Factory Factory Office Assume the following: 1. 2. 3. 4. 5. 6. FICA OASDI is 6.2% on $106,800; FICA Medicare is 1.45% on all earnings. State income tax rate is 5%. The SUTA tax rate is 5.4% on the first $7,000. The FUTA tax rate is .8% on the first $7,000 of earnings. Each employee contributes $25 biweekly for union dues. Eric and John work in the factory while Susie is the manager and considered to work in the office. Part II. a. Using the same account title headings from the payroll register, prepare the general journal entry to record the March 30 payroll. b. Journalize the entry to record the employer's payroll tax expense for March 30 payroll. c. Journalize the entry to record the payment of the March 30 payroll on April 10. d. Journalize the entry to record the payment of the federal taxes on April 15