Would you be able to calculate the net pays of the 10 emplooyees using this data please? Thank you.
Salaried Employees (Bi-Weekly) Canada Claim code (Prov and Fed) RRSP (% of wages or salary) Name Annual Salary Name Employee % Employer % John Jackie 47,800.00 John Jackie Michael Mcmillihan 51,240.00 Michael Mcmillihan A NW Zachary Zany 39,850.00 Zachary Zany - A D W N W W Thomas Trittu 58,000.00 Thomas Trittu Andrew Abraham Hourly Employees (Semi-Monthly) Barney Brigal UI A AMIUT AWN Name Rate of Pay Hours Overtime Claim Code (Prov and Fed) Charlie Choppin Andrew Abraham $ 17.25 0 Sandra Selanna Barney Brigal 18.13 13 Victoria Varinci oo Charlie Choppin 25.46 55 Yammi Yarkuza HW W N HA Sandra Selanna 12.18 88 o Victoria Varinci 31.29 45 o Bonuses (Paid on separate cheque) Yammi Yarkuza 17.50 80 7.25 Name Amount John Jackie $ 2,500.00 Employer paid benefits (monthly) Michael Mcmillihan 7,400.00 John Jackie Health 125.50 hary Zany 10,800.00 Dental 85.73 Vision 12.40 LTD 11.58 Allowances (Per month) STD 3.20 Name Type Amount/month Critical Illness 1.25 John Jackie Parking 125.00 0.83 Zachary Zany Parking 150.00 AD&D Barney Brigal chicle 275.00 Vehicle 325.00 Michael Mcmillinan Health 76.29 Victoria Varinci Dental 54.26 Vision 7.14 Vehicle Allowances (Current Pay) Total KM (Including current) LTD 8.50 Name Kilometers Payment 3.20 John Jackie 542 $ 314.36 4724 STD 3128 Critical Illness 1.25 Michael Mcmillihan 422 $ 244.76 AD&D 0.83 Thomas Trittu 312 $ 180.96 5725 Victoria Varinci 573 $ 332.34 2748 Victoria Varinci Health 142.59 Yammi Yarkuza 218 $ 126.44 5347 Dental 99.38 12.40 GTLI Vision LTD 11.58 Name Rate Multiplier Employee/Employer coverage STD 3.20 John Jackie 1.28 2.5X Annual Salary 50%/50% 1.25 Michael McMillihan 1.13 2X Annual Salary 50%/50% Critical Illness 1.75 3X Annual Salary 0%/100% AD&D 0.83 Zachary Zany Union Dues Name Union Dues (% of pay) Andrew Abraham 2% Barney Brigal 2% Charlie Choppin 2% Sandra Selanna 2% Victoria Varinci 2% Yammi Yarkuza 2%