It had been answered already, thank you 
Julie Leung, an employee of the Import Company, worked 172 hours during the month of January 2018. Her pay rate is $12.50 per hour, and her wages are subject to no deductions other than income taxes, El, and CPP. The overtime premium ls 50% and is applicable to any time greater than 160 hours per month Calculate her regular pay, overtime premium pay, gross pay, total deductions, and net pay. Use Payroll Katalities. Payrolles and Payroll liabilities to determine the E1, CPP and income tax deductions (assume claim code 1. Round the final unswers to 2 decimal places.) Click here to view the CPP Tables for 2018. Click here to view the El Tables for 2018. Regular pay Overtime premium pay Gross pay El deduction CPP deduction Income tax deduction Total deductions Net pay WART 06 73 310 2 2.15 Yi Employment Insurance Premiums Insurable Ewings Insurable Eamings E TA Erm TA 00 01 43.66 4427 91 1.50 02 44.28 4487 151 2.10 44.88 45.48 2.11 2.71 4549 48 08 2.72 3.31 46.09 46.68 3.32 3.91 46.60 47.28 882 452 07 47 29 47.89 4.53 5.12 47.90 45.49 49.09 75 76 89882889 Insure Earrings Te 6705 87.65 87.66 88.25 20 88,85 88.86 89.45 8840 30.00 90.60 9067 91.2 01.27 91.2 9241 EI ROM 145 146 147 148 1.49 150 151 1.52 153 om 11043 13103 131,03 132.24 1324 13344 13404 2.0 12 1323 111 13403 1344 135.34 35 222 20 00 78 79 BO 16 SI RO AR 2 SES 56.31 562 3391.87 3382.47 3380.00 312200 260 050 339740 3393 OY 339367 327 SOM 142500 305.61 M 332021 SS.OU 3325.81 3327 40 55.23 3359,34 3359.03 55.77 3327 41 3328.01 55.24 3359 44 3360 54 55.78 3328.02 3328,61 55.25 330.55 3361.14 55.70 2328.02 3320.21 361.15 336171 5580 (1) Note For insurable earnings above this amount determine the employee's El premium as follows: (1) Enter the employee's Insurable remuneration payable now (including, for example, insurable taxable benefits, bonuses, overtime, accumulated avertine retroactive pay increases and other insurable caring)..... (2) Multiply by: the premium rate for the year (3) El Premium for the pay period, step 1 times step 2 The maximum premium is $858 22. Stop deducting premiums when the employee reaches the maximum premium for the year 0.016 w 3 TO 305 30 T2 Pay ER 3200 SE ore 10 DS ROC CE POZE Canada Pension Plan Contributions Monthly (12 pay periods a year) Pay Pay From From 00 29166 00 306.11 291.67 291.96 306 31 29197 292 16 305.51 202.17 292,36 306.72 292.37 292 56 04 306.32 292 57 292.77 307.12 292.78 292.97 30732 292.98 293.17 3D7.52 2017 307,73 38 105 20 Det GPO 14 145 14 HAT TO BIT 14 75 20 18588X8888 1111 30 ERE 3067 30691 307.11 30731 307 51 307 12 3072 OF ME 21.00 2125 2145 361 21M 3220 322:26 3224 22 221 17 200 121.21 221.40 21:50 3214 322.00 37227 1.50 36.41 13681 19 IRE 13 24 1700 742 7542 727842 6242 663042 864842 859842 656842 6578.42 656342 659842 660842 0818.02 38242 68382 60482 52 7280 7243.43 72584 120.43 2270 7 720 5088.43 SOU 14 5098.42 237,60 5045 5918.42 27333 352843 5008.43 - 5108 42 236.18 1843 58242 273.82 643 5108 43 511042 238.65 5828.43 583842 27432 654843 5118 43 5128 42 239.17 583843 584042 274.81 8.95 43 512843 5138.42 239 67 5848.43 Sa58.42 275.31 1568.43 $138.43 514542 240.18 585843 56842 2.75.80 6578.43 5148.43 5158.42 240.66 5868.43 587842 276,30 658.43 5158.45 516842 241.15 5878.43 $888.42 276.79 6808 43 5166AS 517842 24165 588843 588542 277.29 6008.43 5178.43 5158 42 242.14 5808.43 5908 42 277.78 661843 51843 5158.42 24264 5908.43 5918.42 278.26 6624 51984 520842 243.13 5918.43 5928 42 278.77 663843 208,43 2435 SER S2 279.27 B-167 Employee's maximum CPP contribution for the year 2018 $2.593.80 the earnings te above this art follow the taction method in the past T400 Payroll Deductions Reis 302.47 3087 309.46 300 31045 310,95 31144 3114 3124 312.00 31342 22 42 70 4.11 344.61 145.10 3456 MOS 346.00 70 4708 S. 348.87 73100 7173 742 TASR 734143 4 314 11 Federal tax deductions Effective January 1, 2018 Monthly (12 pay periods a year) Also look up the tax deductions in the provincial table CC 2 CC4 CE CC Pay Fromess than 1146 1146 1154 1154 - 1162 1170 1178 1178 1186 1156 1194 1194 1202 1202 1210 (1) 148.35 149.45 150.55 151.70 152 80 153.95 155.05 156.15 CC 00 70 1.85 2.95 4.10 5.20 5.30 745 8.55 14947 15033 185260 15033 -15119 1865.05 15119-15205 1871.55 15205. 15291 1890.00 15291 - 15377 190250 15377 - 15463 1914.95 15463 15549 1927.40 15549 15635 1939.90 15.635 15721 1952.35 15721 - 15807 1954 85 15BOT 15893 1977.30 15893 15979 1989.75 15979 - 16065 2002.25 16005 16151 2014 70 171205 1724 50 1736.95 1749.45 1761.90 1774 40 1786 85 1799.30 1881.NO 1824 25 1636.75 1849.20 1861.65 1574,15 1703.00 1715.45 1727.90 17240 40 1752.85 1765.35 1777.80 1790.25 180275 1815.20 1827.70 1840.15 1852 60 105 10 1684.90 169735 170085 172290 1734 80 174726 1759.70 1772 20 1784.65 1797.15 18090 152205 183455 54700 1666.00 1679 30 169175 1704.20 171670 1729.15 1741.65 1754.10 1766.55 1779.05 1791.50 150000 1816:45 1280 E-24 1648.70 1661 20 1673.65 16.15 16060 171105 1723.58 1736.00 174850 1760 95 1773 40 1785.00 1798.35 1610 15 1630,65 1643. 10 1655.60 16605 1680 50 1693.00 170545 1717.95 1173040 1742.85 1755 35 1767.80 178030 17275 161255 1625.00 1637.50 1649.05 166245 1674.90 168735 1890.86 17.12.30 172480 1737.25 1749.70 176220 159.45 1578.40 1558.30 1608.95 1588 85 1570.75 1019.40 1601.30 1581.26 16310 102 1595.70 1644.35 M225 160818 1658.0 183675 2066 1669.30 1651.30 1833.10 161.75 106365 164560 167015 165895 1708.70 165860 1070.50 1718.15 1701.10 1683 173166 1713.55 1744.10 1726.00 1707 Pay CPP CPP 72 73 Pay ER 3206 3200 10 19126 To 2015 144 45 14 1980 10 311 2 WE 30630 3055 30671 3061 07/11 30731 PE 011 OME I see 20 15 2014 14 IM 14 IR Canada Pension Plan Contributions Monthly (12 pay periods a year) Pay Pay From TO CPP From 00 20160 .00 300 11 291.67 2010 01 30631 201.07 292.16 03 308 51 202.17 202.56 00 3002 292 37 29256 04 292.57 2027 307.12 202.18 2927 307 12 292.95 293.17 07 3072 2931 293 37 298 38 293 57 30793 293 78 293.58 08.15 10 29379 2030 .11 308 39 29399 204.18 12 24.10 2003 22 HE LE IN 78 To TT 18 70 1 SO 90 20 12 31 23 INI ** NE 1920 1269 61 307 72 2012 308.12 30832 308.52 DE CE 69 SITE 23 307 1226 22 3730 3232 we 31.00 3 LEEE 30853 308.74 15 30803 SO 30547 361 CE PVC 301 w CE 22 2729 2739 6510.45 307 0841 30 23 65142 2842 65382 M42 EFE 17 IDE 43 VELE 819 w EFUL CP 27432 6548 DY 300 314 30 SAN PWM FC IF TE 1842 YONA HT 3 6543 43 27531 27500 216.30 WY EWE WIRE LYS HE ET OVP I 5068.43 5078 A2 23.70 ST88 43 57142 BOTB:43 5042 23710 5743 5000 42 SOBAS 500842 2376 SON 48 1410 A2 500.43 5108:42 24.10 561843 3828 42 51043 511842 23.61 SAN 5128 42 21.11 503843 14 512045 513842 230 67 SBB 43 58542 515843 514542 240.16 SARA2 514543 5158 42 240 643 67842 515843 516842 24115 587843 6.42 516545 517842 241.5 S88.43 S42 5178.43 518842 24214 SB 5042 5084 24254 5188 243.13 51983 592 59186 43 5282 Employee's um CPP contribution for the year 2015 52.59330 (1) TEON Payed 304 130 11 HIE CA FREE GO RUE 277.29 212.70 21 T! DI C90 EF PE 603843 5198 42 VER B-167 Employment Insurance Premiums famige RA 01 .02 Insurable Earnings E. TA .00 90 .91 1.50 1.51 2.10 2.11 2.71 2.72 331 3.32 3.91 3.92 4.52 Insurable Earnings ER 43.68 44 27 46.28 4487 44.88 45.48 45.49 46 08 46.00 46.58 46.69 47 28 4729 47.89 1300 131.03 ta 19.24 21 219 9&82 889 Insurable Earning TA 87.05 87 88 87.66 88.25 88.26 88.00 45 0.06 20:07 00.66 30.67 0120 01.27 9150 73 74 75 76 77 78 79 30 131.00 13183 3223 103 30 134.00 04 1.45 14 147 141 142 1.50 151 10 NE 221 06 INS 3404 134.65 2:34 138 84 567 M 14 SE 330 091.21 331 3392.00 310000 119 3 392500 3325.60 5520 335754 3354.13 551 332561 3326,20 35.21 3358.14 33547 3320 21 3326.80 5522 335674 3. 332651 332740 8823 3950.93 55.77 3327 41 3326.01 5524 33 567 332 02 3526.61 5524 3560 55 311 55. 2017 (1) Note For insurable earning above this amount termine the employee's premium as follows: (1) Enter the employee's Insurable remuneration paysleding, toe example, lesurable ble benefits, bonis, vertine, unulated over time retroactive pay inces and other inte ringa). Multiply by the premium rate for the year El Premium for the pay period. step step 2 The maximum premium la 22 top desting ramme when play reaches the maximum premium for the year
