Question 01

Using the following information prepare the pays of the three employees for the period of pay which finished on January 22^nd 2019. The salaries are payed on January 29^th 2019.

Name of the employee	Time rate /week	Hours worked	Normal hours	Hours with wages raised to 50%
Duval Eric	15.00$/hour	45	40	5
Gigure Mathieu	850.00$/wee	-	40	-
Tousignant Andre	25.00$/hour	38	35	3

EXCEL spreadsheet: acct2payrollworksheet, the Summary of the wages of January 2019.

Use the tables 2019 (52 periods of pay per year) to find the deductions on the wages of the employee and do the calculations.

For the 3 employees:

Code 1 for the federal

Codes A for the provincial

EXCEL spreadsheet: from the summary of wages fill the State of the handing-over to the governments. Fill the boxes corresponding to deductions of the employee and do the calculations for the contributions of the employer.

Work to do:

a) Enter information on the worked time of each employee in the cards of each employee.

b) Calculate the wages of each and find each salary deductions using income tax tables of provincial and federal 2019.

c) use the Excel spreadsheet attached (sheet Summarized of the wages) and enter the amounts and do the totals.

d) Prepare the salary journal entries to record these amounts in the accounts of the General Ledger of the company, use the Excel spreadsheet here attached. These writings are to record the deduction of the employees. All accounts touched by these transactions.

e) Determine the contributions of the employer using the Excel spreadsheet and to make the totals.

f) prepare the salary journal entries to record the contributions of the employer.

g) record the journal entries of this pay in the accounts of the General Ledger of the company, use the Excel spreadsheet (sheet General Ledger).