• Your task is to prepare/calculate monthly payroll, based on the data provided. The attached excel sheet has a data for 6 months (January – June 2019). To prepare payroll for the next 6 months (July to December), increase 10% salary/hourly rate and 15% in the monthly hours (only for the employee paid on hourly rates) Calculate Payroll including Federal Tax, Provincial Tax, EI and CPP.

 

Personal Information							Pay Information			Hours Worked
Employee No.	Status	Employee's Name	City	Province	Postel Code	Claim Code	Pay Type (S = Salary / H = Hourly)	Hourly Rate	Salary Per Pay (Annual salary divided by # of pays)	From Jul-19 to Dec-19)
001	Active	Francoise Rautenstrauch	Toronto	ON	M4C 3Y1	5	S	$ -	$ 4,166.67	NA
002	Active	Kendra Loud	Toronto	ON	M6P 2V5	1	H	$ 15.00	$ -	160, 150, 130, 120, 150, 120
003	Active	Hannah Edmison	Noth York	ON	M2J 3W5	1	S	$ -	$ 3,333.33	NA
004	Active	Queenie Kramarczyk	Burlington	ON	L7R 3Y8	5	H	$ 20.00	$ -	123, 147, 187, 125, 160, 130
005	Active	Lea Steinhaus	Mississauga	ON	L5C 1L3	5	H	$ 18.00	$ -	145, 155, 132, 123, 151, 125

• 
  
  • 
    
    •