plz help me Create a payroll summary report for your employees for a pay period Pay Period:

Bi$-$weekly$(26)$ Pay period end date: $12$ January, $2024$ Pay Date: $19$ January, $2023$

Create a database of $10$ employees. All Employees are paid hourly Enter all basic

information for each employee

the fields should include $($not limited to$)$ Date of birth, date of hire, department,

salaried$/$hourly$,$ rate, address

Create a timesheet for $10$ employees for a two$-$weeks period: with sign$-$in and

sign$-$out time, calculate number of hours worked Province of employment: Ontario

Employees are required to take a $30$ minutes mandatory break if they work more

than $5$ hours in a day if an hourly employee works for more than $44$ hours in a

week, they will be paid $1\mathrm{.}5$ times the regular pay for the hour in excess or $44$ hours

after the $70$th birthday, the employees are not required to contribute to CPP$,$ if the

employee is between the age of $65$ and $70,$ CPP Contribution is optional. Anyone

who is not $18$ yet or collecting CPP Disability pension are not required to contribute

to CPP$.$ employees in the production department receives $3\mathrm{.}5\%$ premium pay with

their earning Use the simple tax calculation apply only Basic personal Amount,

CPP$,$ EI and Canada employment amount for Credit Calculate Pay period statutory

deductions, Remittance and Net pay for all employees Setup the excel template in

a way that you can use it for $2022,2023$ and $2024.$ you need to create a database

for this purpose $($Ontario and Federal only$)$ Use the appropriate rate for all the

years above.Put a disclaimer with all the calculated numbers to indicate that you

only used few variables for calculating the numbers taxes are calculated on taxable

income $($Apply progressive rate$)$ taxes are reduced by credit $(15\%$ federal, $5\mathrm{.}05\%$

Ontario$)$ Taxes are calculated on yearly income, $($annualize your pay period income

and after calculation, divide$)$ CPP Calculation, Earning,minus exemption $($pay period

exemption$),$apply rate,EI Premium calculation,Earning, apply rate,format the payroll

sheet so that it fits in one page, landscape, margin $1^{\text{'}\text{'}}(L,R,T,B)$ for every pay

period, deduction is made from employee earning $($Statutory and non$-$statutory$),$

and the employee only receives the net pay. Deduction is remitted to the

appropriate authority with properly matched amount by the employer The employer

has to match $100\%$ CPP Contribution and $140\%$ EI premium deducted from every

pay period using multiple sheets will help you manage better