must use excel if possible

Part 2: Problem 2 - age 49 Required: Similar to the requirements of Problem 1, prepare the payroll register and the journal entries for the week of July 29th - August 5th, 2021. Employee z -age 18 on July 28, 2021 -pay rate of $10.00/hr for 20 hours this week - claim code 1 Employee A -rate of $25.00/hr and worked 48 hours this week - CPP contributions to date are $3,150.00 and El deductions to date are $889.54 - claim code 5 Employee E - age 28 -pay rate of $17.50 per hour for 42 hours this week -claim code 1 Employee B - age 17 - Pay rate of $9.00/hr for 49 hours this week - claim code E Employee T - age 65 pay rate of $18.25/hr for 44 hours this week claim code 9