*****PLEASE DO IT ON EXCEL*****

PRACTICE EXERCISE 5 The following information is taken from the payroll records of Letzelter Manufacturing on June 30. Gross PayProduction Department $18,700 General Office 5,200 23,900 Deductions: Federal income tax $3,068 Provincial income tax 2,046 CPP 717 EI 574 Company Pension 478 RSP Contributions 4,000 Medical Plan 239 Canada Savings Bonds 850 Union Dues 748 12,720 Total Net Pay $11,180 (a)Record a compound General Journal entry for the payroll on June 30. (b)Record a compound General Journal entry for the employers contributions to CPP, EI, company pension, and medical plan on June 30: CPP and EI as usual company pension and medical plan on an equal basis (c)Record entries in the Cash Payments Journal for: the issuance of the paycheques on June 30 the remittance to ManuLife on June 30 for the company pension plan, RSP contributions, and the medical plan the payment on June 30 to Canadian Trust for the Canada Savings Bonds contributions the remittance of the union dues on June 30 the remittance of income tax, CPP, and EI to Canada Revenue Agency on July 14 Supplementary Exercises EXERCISE 10-1: Open file SE-10-1. Complete the payroll record by looking up payroll deductions; then complete the general journal entries. EXERCISE 10-2: Open file SE-10-2. Complete the journal entries for payroll by looking up the payroll deductions.

Figure 10.1Payroll Time Card

10.2

WEEK ENDING January 8 20 NO. 103 NAME Ronald Davies Morning IN Noon Noon IN OUT Night OUT Extra IN Extra OUT TOTAL HOURS M 7:55 12:00 12:29 4:30 5:00 7:02 8 + 2 8:00 12:00 12:30 4:30 8 3 8:01 12:01 12:30 8 8:00 12:00 12:30 4:31 4:30 4:30 8 F 7:58 12:00 12:28 8 s HRS. TOTAL TIME 40 + 2 = 42 RATE 15.00 / 22.50 TOTAL WAGES FOR WEEK $ 645.00 Federal tax deductions Effective January 1, 2017 Weekly (52 pay periods a year) Also look up the tax deductions in the provincial table Pay From less than CCO CC 5 CC 6 CC 7 CC 8 CC 9 CC 10 597 605 613 .80 - 589 597 605 613 621 629 637 645 653 661 669 009 677 685 693 701 709 717 725 733 CC 1 46.65 47.75 48.90 50.00 51.10 52.25 53.35 54.50 55.60 56.75 621 629 637 645 653 661 669 677 685 693 701 709 717 was 725 733 741 - 749 757 765 773 781 789 22 797 805 813 821 829 10 837 845 853 CC 4 30.60 31.75 32.85 33.95 35.10 36.20 37.35 38.45 39.55 40.70 41.80 42.95 44.05 45.20 46.30 10.30 47.40 48.55 49.65 50.80 si 51.90 53.05 3.0 54.15 55.25 . 56.40 741 80.20 81.30 82.45 83.55 84.70 85.80 86.95 88.05 89.15 90.30 91.40 2. 92.55 93.65 94.75 os 95.90 97.00 GOS 98.15 99.25 100.40 101.50 102.60 103.75 104.85 106.00 107.10 107.10 108.20 100.20 109.35 110.45 111.60 112.70 113.85 114.95 1 os 1 16.05 117.20 118.30 119.45 120.55 122.00 123.60 125.15 126.70 128.25 129.80 131.40 132.95 134.50 136.05 137.65 120 139.20 Sing 110.75 142.30 143.90 145.50 147.05 148.65 24.20 25.30 26.45 27.55 28.70 29.80 30.90 32.05 33.15 34.30 35.40 36.50 0. 37.65 38.75 39.90 41.00 12 42.15 25 43.25 44.35 25 45.50 NEN 46.60 47.75 48.85 50.00 51.10 . 52.20 . 53.35 . 54.45 14.09 55.60 56.70 749 757 765 773 781 789 797 805 813 821 829 - 837 845 853 861 869 877 885 893 901 909 917 925 933 941 949 957 965 973 981 CC 2 43.45 44.55 45.65 46.80 47.20 49.05 50.15 51.30 52.40 53.50 54.65 55.75 . 90.9 56.90 58.00 59.10 60.25 61.35 62.50 63.60 64.75 65.85 66.95 68.10 0. 69.20 70.35 1922 71.45 [ 72.60 73.70 74.80 75.95 75 OS -- 77.05 20 78.20 79.30 80.40 81.55 82.65 83.80 85.25 86.80 88.35 89.95 91.50 93.05 9-1.60 96.15 97.75 99.30 100.85 os 102.40 104.00 105.55 107.15 108.70 110.30 111.30 57.85 58.95 60.10 61.20 62.35 6345 63.45 455 64.55 65.70 66.80 os 67.95 69.05 70.20 71.30 72.40 73.55 74.65 17.00 75.80 9.0V 76.90 78.05 79.15 80.25 On 81.40 82.50 83.65 84.75 85.85 87.00 88.45 90.00 91.55 93.15 94.70 96.25 97.80 99.40 100.95 102.50 104.05 IN . 107.20 108.75 110.35 111.90 113.50 115.10 CC 3 37.00 38.15 39.25 40.40 41.50 42.60 43.75 44.85 46.00 47.10 48.25 49.35 195 50,45 51.60 52.70 5270 53.95 53.85 SOS 54.95 561 56.10 57.20 5720 58.30 59.45 ASS 60.55 61.70 62.80 watery 63.90 24 65.05 66.15 67.30 68.40 69.55 70.65 -,- 71.75 72.90 74.00 75.15 76.25 - - 77.35 78.85 80.40 81.95 83.50 85.10 86.65 88.20 89.75 91.30 92.90 94.45 96.00 es 97.55 99.15 100.70 102.30 103.90 105.45 17.80 18.90 20.00 21.15 22.25 23.40 24.50 25.65 -2.0 26.75 2785 29.00 30.10 31.25 32.35 22 33.15 34.60 35.70 COS 36.85 37.95 20 39.10 10.20 41.30 42.45 14.1 43.55 44.70 " 45.80 46.95 48.05 405 49.15 50.30 son SA 51.40 52.55 53.65 54.75 55.90 57.00 58.15 59.60 61.15 62.70 64.30 65.85 67.40 68.95 70.50 72.10 73.65 75.20 76.75 78.35 79.90 81.50 83.05 84.65 86.25 11.35 12.50 13.60 14.75 15.85 16.95 18.10 19.20 20,35 21.45 22.60 23.70 24.80 25.95 19.95 325 27.05 28.20 29.30 30.45 nas 31.55 32.65 33.80 34.90 36,05 37.15 2.02 38.25 10:22 39.40 3919 40.50 41.65 42.75 320 43.90 45.00 46,10 47.25 48.35 49.50 50.60 51.70 53.20 54.75 56.30 57.85 59.45 61.00 62.55 64.10 65.65 67.25 68.80 68 2 70.35 71.90 73.50 5 as 75.05 7665 76.65 78.25 79,80 57.50 2014 58.65 30.0 59.75 60.85 62.00 Wa 63.10 64.25 6525 65.35 66.50 KA 67.60 68.70 69.85 70.95 72.40 74.00 75.55 77.10 78.65 80.25 4.95 6.10 7.20 8.30 9.45 10.55 11.70 12.80 co 13.90 15.05 16.15 17.30 . 18.40 10.40 19.55 20.65 21 21.75 22.00 22.90 24.00 25.15 26 2 27.40 28.50 29.60 30.75 31.85 31:02 33.00 34.10 35.20 36.35 303 37.45 38.60 20 39.70 10.85 41.95 43.05 44.20 15.30 16.75 48.35 19.90 51.45 53.00 54.60 56.15 57.70 59.25 60.80 62.40 AQs 63.95 65.50 67.10 68.65 1.90 3.05 4.15 5.25 6.40 7.50 8.65 9.75 10.85 12.00 13.10 14.25 12 15.35 16.50 17.60 18.70 19.85 20.95 22.10 23.20 24.35 25.45 2012 26.55 27.70 27.70 28.80 200s 29.95 310 31.05 32.15 33.30 34.40 35.55 36.65 BE 37.80 38.90 40.35 41.90 43.50 45.05 46.60 48.15 49.70 51.30 52.85 54.40 55.95 5255 57.55 som 59.10 60.65 62.25 63.85 65.40 67.00 - 1.10 2.20 3.35 4.45 5.60 2.00 6.70 7.80 OS 8.95 TS 10.05 110 11.20 12:30 13.45 14.55 15.65 16.80 0.00 17.90 19.05 20.15 21.30 22.40 23.50 24.65 25 25.75 26.90 20 28.00 29.10 30.25 31.35 32.50 33.95 35.50 37.05 38.65 40.20 41.75 43.30 44.85 46.45 48.00 49.55 51 51.10 52.70 54.25 ses 55.85 57.40 59.00 861 869 877 885 893 901 909 917 925 933 941 949 957 965 973 981 57.80 soos 58.95 60.05 61.20 . 62.30 63.45 64.55 66.00 67.55 69.15 70.70 72.25 73.80 75.35 76.95 78.50 80.05 81.60 83.20 84.75 86.30 87.90 89.50 91.05 92.65 - - 81.80 83.35 84.90 86.45 pos 88.05 89.60 91.15 - 92.75 94.30 95.90 97.45 99.05 989 989 997 1005 1013 997 1005 1013 1021 70.25 71.80 73.40 1021 1029 60.60