rrent Liabilities and Contingencies P13.4 (LO 1) Excel (Payroll Tax Entries) The following is a payroll sheet for Otis Imports for the month of September 2020. The company is allowed a 1% unemployment compensation rate by the state; the federal unemployment tax rate is 0.8% and the maximum for both is $7,000. Assume a 10% federal income tax rate for all employees and a 7.65% FICA tax on employee and employer on a maximum of $128,400. In addition, 1.45% is charged both employer and employee for an employee's wages in excess of $128,400 per employee. Unemployment Tax State Federal Earnings Name to Aug. 31 B.D. Williams $ 6,800 D. Raye 6,500 K. Baker 7,600 F. Lopez 13,600 A. Daniels 116,900 B. Kingston 121,900 Income September Tax Earnings Withholding FICA 800 700 1,100 1,900 13,000 16,000 Instructions a. Complete the payroll sheet and make the necessary entry to record the payment of the payroll. b. Make the entry to record the payroll tax expenses of Otis Imports. c. Make the entry to record the payment of the payroll liabilities created. Assume that the company pays all payroll liabilities at the end of each month