$1$ In each spreadsheet, enter data only in the cells highlighted in grey.

$2$ Relevant data is provided in the handout.

$3$ Upload this completed workbook to the designated assignment folder in eConestoga

$4$ All submissions must take place before the due date and time.

Tax brackets and rates Annual salary

# of pay periods $2424242424$

Federal Tax rates for $2021$ Tax year: Tax bracket Each pay period This pay period

Tax Rate Taxable Annual Income Allocation to each bracket #

$15\%$ $$49,0201$ $$2,042\mathrm{.}501$

$20\mathrm{.}5\%$$$49,021$up to $$98,040,$ and $2$ $$2,042\mathrm{.}462$

$26\%$$$98,041$up to $$151,978,$ and $3$ $$2,247\mathrm{.}383$

$29\%$$$151,979$up to $$216,511,$ and $4$ $$2,688\mathrm{.}834$

$33\%$$$216,512$and up $55$

Tax amount calculation

Bracket Rate

$115\mathrm{.}0\%$

Pay period Semi$-$monthly $220\mathrm{.}5\%$

# of periods $/$year $24326\mathrm{.}0\%$

$429\mathrm{.}0\%$

$533\%$

Total

Provincial Taxes Shahid Mariya Gracyn Jun Jerry

Tax brackets and rates Annual salary

# of pay periods $2424242424$

Provincial Tax rates for $2021$ Tax year: Tax bracket Each pay period This pay period

Tax Rate Taxable Annual Income Allocation to each bracket #

$5\mathrm{.}00\%$First $$45,142,$ and $1$ $$1,880\mathrm{.}921$

$9\mathrm{.}00\%$Over $$45,143$ up to $$90,287,$ and $2$ $$1,881\mathrm{.}002$

$11\mathrm{.}16\%$Over $$90,288$up to $$150,000,$ and $3$ $$2,488\mathrm{.}003$

$12\mathrm{.}16\%$ Over $$150,001$up to $$220,000,$ and $4$ $$2,916\mathrm{.}634$

$13\mathrm{.}16\%$Over $$220,001$and up $55$

Tax amount calculation

Bracket Rate

$15\mathrm{.}00\%$

$29\mathrm{.}00\%$

Pay period Semi$-$monthly $311\mathrm{.}16\%$

# of periods $/$year $24412\mathrm{.}16\%$

$513\mathrm{.}16\%$

Total $-----$

Employee Annual Salary This pay period EI maxed EI amt. employee EI amt. employer Data

Shahid Rate

Mariya EI employee $1\mathrm{.}58\%$

Gracyn EI employer $2\mathrm{.}21\%$

Jun Annual pay periods $24$

Jerry

$00$

Employee Gross earnings this pay period Fed tax Prov Tax CPP EI Net Pay

Shahid

Mariya

Gracyn

Jun

Jerry

Total

Employee Gross earnings this pay period CPP $-$ emp EI $-$emp Payroll Cost

Shahid

Mariya

Gracyn

Jun

Jerry

Total

Benefit name Cost Total Reason