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

Name of the employee	Time rate /week	Hours worked	Normal hours	Hours with wages raised to 50%
Duval Eric	16.00$/hour	42	40	2
Giguère Mathieu	750.00$/week	-	40	-
Tousignant Andre	23.00$/hour	40	40

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

Use the tables 2021 (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 2021.

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).

Answer rating: 100% (QA)

Payroll WorkSheet A B C D E F G H I J K L M N O P Q R S V Sr No Name of the Employee Time RateWeek i... View the full answer