Johnny Canuk's Friendly Pub employs a bartender and four servers

Below are the hours worked and pay rates for these employees for the week ended August $31,2022$

Employees are paid on September $12,2022$

$\backslash$table$[[$Employee Name,Hours,$\backslash$table$[[$Hourly$],[$Rate$]],\{$

$\backslash$table$[[$Controlled$],[$Tips$]]\},$Deductions$],[,$me Tax,,CPP$,,$EI$],[$Kerri Einarson,$43,$$$32\mathrm{.}00,,,$$$,275\mathrm{.}00,$$$,75\mathrm{.}00,$$$,23\mathrm{.}00],[$Brad Gushue,$46,$$$17\mathrm{.}00,$$$,250\mathrm{.}00,$$$,172\mathrm{.}00,$$$,60\mathrm{.}00,$$$,17\mathrm{.}00],[$Glenn Howard,$48,$$$17\mathrm{.}00,$$$,425\mathrm{.}00,$$$,240\mathrm{.}00,$$$,70\mathrm{.}00,$$$,20\mathrm{.}00],[$Rachel Homan,$40,$$$18\mathrm{.}00,$$$,305\mathrm{.}00,$$$,155\mathrm{.}00,$$$,55\mathrm{.}00,$$$,16\mathrm{.}00],[$Chelsea Carey,$40,$$$19\mathrm{.}00,$$$,600\mathrm{.}00,$$$,252\mathrm{.}00,$$$,75\mathrm{.}00,$$$,22\mathrm{.}00]]$

All employees are paid $1\mathrm{.}5$ times their hourly wage for hours worked in excess of $40$ hours per week.

WSIB rate is $$1\mathrm{.}32$ per $$100$ of payroll and is submitted at the end of the following month Vacation pay is $4\%$

Company portion of CPP is equal to employee deduction

Company portion of El cost is equal to $1\mathrm{.}4$ times employee deduction

Revenue Canada withholdings are remitted on the $15$th of the following month

REQUIRED:

Calculate the net pay for each employee

Calcuate the amount to be remitted to Revenue Canada

Calculate the total company cost of payroll and the percentage of the payroll cost to gross pay

Journalize :

the payroll

the payroll taxes

the WSIB assessment

the vacation pay

the payment to the employees

the payment to Revenue Canada

the payment to WSIB