Hi could you please answer this question as soon as possible, i'm doing a timed test at the moment,

The following monthly data are taken from Ramirez Company at July 31: Sales salaries, $380,000; Office salaries, $76,000; Federal income taxes withheld, $114,000; State income taxes withheld, $25,500; Social security taxes withheld, $28,272; Medicare taxes withheld, $6,612; Medical insurance premiums, $9,000; Life insurance premiums, $6,000; Union dues deducted, $3,000; and Salaries subject to unemployment taxes, $54,000. 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- assume that FICA taxes are identical to those on employees and that SUTA taxes are 5.4% and FUTA taxes are 0.6%