need this complete by Sunday midnight. please show all work in excel format.

Payroll Procedures-Comprehensive Problem Requirements: 1. Complete the Weekly Payroll Register for Loop Sand Company located in Ohio. Note: Use the federal withholding tax tables in the back of your book to determine federal and use the Ohio withholding tables in the chapter 4 lecture notes for the state income taxes. Assume all wages are taxable for FIT, OASDI, State Income Tax, FUTA and SUTA. Use 3% as your SUTA rate. Name Kendale, David Engle, Olive Hudson, Frank Totals Employee Data Marital # of w/h Status allowances Married 2 Single 1 Married 4 Entry to Journalize the payment of the wages: Accounts Entry to Record the employer payroll taxes: Entry to Record the 941 deposit: Hours Regular Rate $15.90 $15.60 $22.00 Regular 40 32 40 Overtime 2 3 0 Debit Earnings Regular Credit Total Overtime Earnings Federal Inc. Tax FICA OASDI Deductions FICA State HI Inc. Tax Dental Ins. Total withholding Deductions $20.00 0 $10.00 Net Pay