GenZ is a family restaurant run by Robert family. Robert, his wife and two daughter runs the restaurant and they don't take any salary themselves. They hire part time employee to help them when very busy. Due to the work pressure, Julia, Robert's daughter forgot to make the remittance for November payroll. Actual remittance was sent on $27$th December. The restaurant makes regular remittance.

the last pay pay day is $27$th December, they make bi$-$weekly payments to their employees. all employees Federal and ON CC is $1.$ They will not reach maximum for CPP and EI with this pay. $4\%$ vacation payment is paid with every pay period earning

Calculate statutory deduction and net pay for the employees listed for December $27$ Pay period. Add their information to the payroll record. Determine amount to remit to CRA.

Assume that the remittance will be made on time for this pay period.

Calculate non$-$compliance penalty if any.

Prepare an organized Payroll record for all employees to reflect their payment for the whole year.

Prepare T$4$ and T$4$ summary for all employees.

Show all calculations

upload all T$4$ and T$4$ summary to Canvas

$($No Zip file, upload the original

All payroll related information are provided below:

Employee Information

$800123457$ Liam Brown

$71$ Ellesmere Road, Toronto, ON M$1$R $4$C$2$

$800120453$ Lucas Campbell

$1201$ Kingston Road, Scarborough, ON M$1$N $1$P$1$

$803120450$ Ethan Cloutier

$55$ Oakworth Crescent, Toronto ON M$1$K $3$T$7$

$813120458$ Ava Boucher

$59$ Valhalla Blvd$,$ Toronto ON M$1$N $3$B$3$

$813129459$ Noah Beaulieu

$9$ landseer Road, Toronto ON$,$ M$1$K $3$A$7$

$813119450$ Benjamin Adams

$309-1398$ Birchmount Road, Scarborough, ON M$1$P $2$E$2$

$873119457$ Jack Belanger

$7-21$ Peard Road, Toronto ON M$481$T$7$

$873111454$ Charlotte Green

$308$ Kingswood Road, Toronto, ON M$4$E $3$N$8$

earning vacation pay CPP EI Tax Total Ded Net Pay

Liam $24$ Oct, $2023$ $$900\mathrm{.}00$ $$36\mathrm{.}00$ $$47\mathrm{.}68$ $$15\mathrm{.}26$ $$73\mathrm{.}42$ $$136\mathrm{.}36$ $$799\mathrm{.}64$

$2$ Jan, $2023$ $$833\mathrm{.}33$ $$33\mathrm{.}33$ $$43\mathrm{.}56$ $$14\mathrm{.}13$ $$46\mathrm{.}87$ $$104\mathrm{.}55$ $$762\mathrm{.}11$

$20$ Dec, $2023$ $$1,166\mathrm{.}67$ $$46\mathrm{.}67$ $$64\mathrm{.}18$ $$19\mathrm{.}78$ $$126\mathrm{.}51$ $$210\mathrm{.}47$ $$1,002\mathrm{.}87$

$06$ Dec, $2023$ $$1,666\mathrm{.}67$ $$66\mathrm{.}67$ $$95\mathrm{.}12$ $$28\mathrm{.}25$ $$228\mathrm{.}95$ $$352\mathrm{.}33$ $$1,381\mathrm{.}01$

$09$ Nov, $2023$ $$1,800\mathrm{.}00$ $$72\mathrm{.}00$ $$103\mathrm{.}37$ $$30\mathrm{.}51$ $$264\mathrm{.}37$ $$398\mathrm{.}26$ $$1,473\mathrm{.}74$

$22$ Nov, $2023$ $$2,000\mathrm{.}00$ $$80\mathrm{.}00$ $$115\mathrm{.}75$ $$33\mathrm{.}90$ $$319\mathrm{.}77$ $$469\mathrm{.}42$ $$1,610\mathrm{.}58$

$$8,366\mathrm{.}67$ $$334\mathrm{.}67$ $$469\mathrm{.}67$ $$141\mathrm{.}83$ $$1,059\mathrm{.}89$ $$1,671\mathrm{.}39$ $$7,029\mathrm{.}95$

Lucas $10$ Oct, $202330012$ $$10\mathrm{.}55$ $$5\mathrm{.}090$ $$15\mathrm{.}64$ $$296\mathrm{.}36$

Ethan $10$ Oct, $202340016$ $$16\mathrm{.}74$ $$6\mathrm{.}780$ $$23\mathrm{.}52$ $$392\mathrm{.}48$

Ava $22$ Aug, $202357022\mathrm{.}8$ $$27\mathrm{.}26$ $$9\mathrm{.}660$ $$36\mathrm{.}92$ $$555\mathrm{.}88$

$17$ Jul, $2023667\mathrm{.}526\mathrm{.}7$ $$33\mathrm{.}30$ $$11\mathrm{.}329\mathrm{.}95$ $$54\mathrm{.}56$ $$639\mathrm{.}64$

$08$ Aug, $2023528\mathrm{.}7521\mathrm{.}15$ $$24\mathrm{.}71$ $$8\mathrm{.}960$ $$33\mathrm{.}67$ $$516\mathrm{.}23$

$1766\mathrm{.}2570\mathrm{.}65$ $$85\mathrm{.}27$ $$29\mathrm{.}949\mathrm{.}95$ $$125\mathrm{.}16$ $$1,711\mathrm{.}74$

Noah $09$ Nov, $202360024$ $$29\mathrm{.}12$ $$10\mathrm{.}170$ $$39\mathrm{.}29$ $$584\mathrm{.}71$

$24$ Oct, $202372529$ $$36\mathrm{.}85$ $$12\mathrm{.}2923\mathrm{.}87$ $$73\mathrm{.}01$ $$680\mathrm{.}99$

$10$ Oct, $202330012$ $$10\mathrm{.}55$ $$5\mathrm{.}090$ $$15\mathrm{.}64$ $$296\mathrm{.}36$

$19$ Dec, $202350020$ $$22\mathrm{.}93$ $$8\mathrm{.}480$ $$31\mathrm{.}41$ $$488\mathrm{.}59$

$06$ Dec, $202350020$ $$22\mathrm{.}93$ $$8\mathrm{.}480$ $$31\mathrm{.}41$ $$488\mathrm{.}59$

$22$ Nov, $202360024$ $$29\mathrm{.}12$ $$10\mathrm{.}170$ $$39\mathrm{.}29$ $$584\mathrm{.}71$

$3225129$ $$151\mathrm{.}51$ $$54\mathrm{.}6723\mathrm{.}87$ $$230\mathrm{.}05$ $$3,123\mathrm{.}95$

Benjamin $22$ Aug, $20232008$ $$4\mathrm{.}37$ $$3\mathrm{.}390$ $$7\mathrm{.}76$ $$200\mathrm{.}24$

Jack $10$ Oct, $202330012$ $$10\mathrm{.}55$ $$5\mathrm{.}090$ $$15\mathrm{.}64$ $$296\mathrm{.}36$

Charlotte $17$ Jul, $202360024$ $$29\mathrm{.}12$ $$10\mathrm{.}170$ $$39\mathrm{.}29$ $$584\mathrm{.}71$

$08$ Aug, $2023386\mathrm{.}2515\mathrm{.}45$ $$15\mathrm{.}89$ $$6\mathrm{.}550$ $$22\mathrm{.}44$ $$379\mathrm{.}26$

$986\mathrm{.}2539\mathrm{.}45$ $$45\mathrm{.}01$ $$16\mathrm{.}720$ $$61\mathrm{.}73$ $$963\mathrm{.}97$

December $27$ Pay day:

Hours worked

Hourly Rate $1$st week $2$nd week

Lucas $$17\mathrm{.}251615$

Ethan $$19\mathrm{.}504710$

Benjamin $$25\mathrm{.}001245$

Jack $$18\mathrm{.}002048$

Charlotte $$22\mathrm{.}002216$