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, $67,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%.

HELP! Every answer I've put is wrong for the blank questions. The (1) for July 31st does not mirror the (3) July 31st. I included my other answers to help but i only need to finish part 4.

Req 1 and 2 Reg 3 Reg 4 Using the above information, complete the below table and prepare the journal entries to record accrued payro payment of the net payroll for July. Total % Paid by Premium Premium Premium Employees Paid by Paid by Employees Employer Employee Medical Insurance Payable $ 15,500 40% $ 6,200 9,300 Employee Life Insurance Payable $ 12,500 40% $ 5,000 S 7,500 $ Date General Journal Debit Credit Record journal entry for accrued payroll, including employee deductions, for July. July 31 640,000 Sales salaries expense Office salaries expense 128,000 Employee fed. inc. taxes payable 192,000 Employee state inc. taxes payable 43,000 FICA-Social sec. taxes payable 47,616 FICAMedicare taxes payable 11,136 Employee medical insurance payable 6,200 Employee union dues payable 9,500 Salaries payable 453,548 Record the cash payment of salaries July Salaries payable 31 Cash 453,548 >> 453,548 Reg 1 and 2 Reg 3 Reg 4 Using the above information, complete the below table. Amounts Tax Subject to Tax Tax Rate State Unemployment Taxes Payable $ 67,000 5.4% Federal Unemployment Taxes Payable $ 67,000 0.6% Tax Amount S 3,618 S 402 Req 1 and 2 Reg 3 Reg 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%. No Credit Date July 31 Debit 62,772 1 General Journal Payroll taxes expense FICA-Social sec. taxes payable FICAMedicare taxes payable State unemployment taxes payable Federal unemployment taxes payable 47,616 11,136 3,618 402 2 July 31 16,800 Employee benefits expense Employee medical insurance payable Employee life insurance payable 9,300 7,500 3 July 31 3,618 402 192,000 State unemployment taxes payable Federal unemployment taxes payable Employee fed inc taxes payable Employee life insurance payable Employee medical insurance payable Employee state income taxes payable Employee union dues payable FICAMedicare taxes payable FICA-Social sec. taxes payable Cash