Current Liabilities and Contingencies (Please use Computer)

13.4 (L01) EXCEL (Payroll Tax Entries) The following is a payroll sheet for Otis Import Company for the month of Sep- ander 2017. The company is allowed a 1% unemployment compensation rate by the state; the federal unemployment tax rate sployee and employer on a maximum of $118,500. In addition, 1.45% is charged both employer and employee for an employee's we in excess of $118,500 per employee. Income Tax Withholding Unemployment Tax State Federal FICA Name B.D. Williams D. Raye K. Baker Lopez A. Daniels B. Kingston Earnings to Aug. 31 $ 6,800 6,500 7,600 13,600 107,000 112,000 September Earnings $ 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 Import Company. le) Make the entry to record the payment of the payroll liabilities created. Assume that the company pays all payroll liabil ities at the end of each month