Just do Q4. Please explain step by step. Thank you.

The following monthly data are taken from Ramirez Company at July 31 Sales salaries, $640,000; Office salaries, $128,000; Federal income taxes withheld, $192.000, State income taxes withheld, $43,000, Social security taxes withheld, $47,616; Medicare taxes withheld, $11,136: Medical insurance premiums, $15,500; Life insurance premiums, $12,500; Union dues deducted, $9,500; and Salaries subject to unemployment taxes, $67000. The employee pays 40% of medical and life insurance premiums. Assume that FICA taxes are identical to those on employees and that SUTA taxes are 5.4% and FUTA taxes are 0.6%. 1. & 2. Using the above information, complete the below table and Prepare the journal entries to record accrued payroll and cash payment of the net payroll for July 3. Using the above information, complete the below table 4. Record the accrued employer payroll taxes and all other employer-paid expenses and the cash payment of all liabilities for July Complete this question by entering your answers in the tabs below Req 1 and 2 Req 3 Req 4 Record the accrued employer payroll taxes and all other employer-paid expenses and the cash payment of all liabilities for July-assume that FICA taxes are identical to those on employees and that SUTA taxes are 5.4% and FUTA taxes are 0.6% View transaction list View journal entry worksheet No Date General Debit July 31 Payroll taxes expense FICA-Medicare taxes payable FICA- Social sec taxes payable 11,136 47.616