(a)The employees of The Fashion Factory completed the number of pieces indicated during the workweek ending June 30: P. Cardin 1,050 J. Woolly 1,040 T. Bloomer 1,065 R. Napp 1,035

(b)Calculate the gross pay for each employee using the following plan: First 500 pieces $0.50 each Next 300 pieces $0.60 each Next 200 pieces $0.70 each Over 1,000 pieces $0.90 each

(c)Complete the payroll using the payroll deduction tables illustrated in Figures 10.2, 10.3, 10.4, and 10.5. Assume all employees are Claim Code 1 for federal and provincial income tax purposes. (The Fashion Factory does not have a group health plan.) Total and balance the payroll record.

(d)Record the compound General Journal entry for this payroll on June 30.

(e)Record the General Journal entry on June 30 for the employer’s contributions to CPP and EI.

(f)Record the entry in the Cash Payments Journal to issue the payroll cheques on June 30. The first paycheque is #11.

(g)Record the entry in the Cash Payments Journal for the remittance to CRA on July 15. Issue cheque #29.

Figure10.2

Figure10.3

Figure 10.3

10.4

10.5

Instructions:

Complete Exercise 2 on page 189 using the deductions tables on Pages 178-182.

Complete this exercise in the Excel file Graded LP7.1 Assignment Payroll Record.xlsx. Look up the deductions based on the gross pay amounts provided. Calculate net pay, then total all columns. Prepare the general journal entries. Disregard the cash payments journal entries.

Transcribed Image Text:

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 589 597 605 . 613 621 CAN 629 637 645 653 661 669 009 677 685 689 693 201 701 700 709 717 725 732 733 741 773 781 199 789 797 813 813 921 821 9:30 829 017 837 016 845 853 861 8.60 869 JONE 877 . 200 885 893 901 909 917 925 933 941 949 - - 989 997 1005 1013 1021 . ▾ . - 805 - 805 . . - 749 757 765 - 773 781 For . . - - . . . - 957 965 973 981 - . 597 605 613 621 - 629 The 637 Y 645 653 661 MORE 669 971 677 685 693 701 709 717 105 725 www 733 741 741 10 749 2011 757 765 789 192 797 805 813 821 829 977 837 ass 845 Des 853 861 Pen 869 S 877 20. 885 S 893 901 909 T 917 925 933 941 949 www 957 965 973 net 981 989 997 1005 1013 1021 1029 CC 0 80.20 81.30 82.45 83.55 APERT 84.70 MONTANA 85.80 86.95 88.05 89.15 90.30 91.40 91.40 92.55 S 93.65 94.75 05.00 95.90 97.00 09 15 98.15 99.25 100.40 in 101.50 102.60 103.75 104.85 106.00 107.10 107:10 108.20 109.35 110.45 111.60 112.70 117.05 113.85 114.05 114.95 116.05 116.05 MOS 117.20 11016 118.30 119.45 120.55 MAV 122.00 CASION 123.60 LEXMAY 125.15 www.ca 126,70 FO 128.25 COLL 129.80 131.40 STEROWN 132.95 w 134.50 136.05 137.65 139.20 140 75 140.75 14220 142.30 143.90 145.50 147.05 148.65 CC 1 46.65 47.75 48.90 20 50.00 www 51.10 BROW 52.25 S 53.35 Sam 54.50 BON 55.60 OPON 56.75 37.85 S 58.95 60.10 60.10 61.20 61.20 62 25 62.35 63.45 64.55 65.70 65.70 66.90 66.80 17.05 67.95 Com 69.05 70.20 71.30 11:30 72.40 73.55 13:33 74.65 75.80 15.80 76.90 78.05 70 15 79.15 20 35 80.25 21:46 81.40 02.50 82.50 orde 83.65 W 84.75 ANDRO 85.85 ERFOR 87.00 COP 88.45 90.00 91.55 AMA 93.15 Au 94.70 96.25 PE 97.80 www 99.40 Spaty 100.95 102.50 104.05. 105.60 10.0 107.20 100 75 108.75 110.35 111.90 113.50 115.10 CC 2 43.45 44.55 45.65 46.80 NEGR 47.90 TRAINA 49.05 METO 50.15 51.30 SALAM 52.40 53.50 54.65 20 55.75 03:0 56.90 58.00 59.10 60.25 61.25 61.35 6210 62.50 63.60 63.60 66.75 64.75 65 05 65.85 66.95 68.10 69.20 09.20 70.35 10:33 71.45 71.45 72.60 73.70 74.80 75.95 77.05 79 20 78.20 30.10 79.30 80.40 L 81.55 82.65 83.80 85.25 2 86.80 boo 88.35 CE 89.95 91.50 93.05 Borgar 94.60 96.15 97.75 99.30 100.85 102 50 102.40 104.00 104.00 ** 105.55 107.15 108.70 110.30 111.90 CC 3 37.00 38.15 39.25 40.40 Pen 41.50 42.60 43.75 44.85 FOT 46.00 ONLINE 47.10 S 48.25 49.35 50.45 30.43 51.60 52.70 53.85 54.95 56 10 56.10 57. 20 57.20 10:30 58.30 59.45 60.55 61.70 62.80 V2.00 63.90 05:30 65.05 09.09 66.15 DORD 67.30 68.40 69.55 70.65 70.65 71 75 71.75 1000 72.90 M 74.00 MAXON 75.15 V 76.25 77.35 78.85 V 80.40 81.95 83.50 85.10 86.65 88.20 V 89.75 91.30 92.90 94.45 06.00 07.55 97.55 mnie 99.15 100.70 102.30 103.90 105.45 CC 4 30.60 31.75 32.85 33.95 Bese 35.10 PUN 36.20 37.35 B 38.45 CA 39.55 P 40.70 41.80 D 42.95 44.05 44.00 45.20 46.30 47.40 48.55 40.65 49.65 50 80 50.80 2100 51.90 PER 53.05 SAIS 54.15 55.25 56.40 30:10 57.50 SECON 58.65 30.03 59.75 39.13 60.85 62.00 63.10 66.25 64.25 65 25 65.35 16.50 66.50 to 67.60 como 68.70 69.85 FRAN 70.95 Le 72.40 VEN 74.00 75.55 TORPA 77.10. K 78.65 1000 80.25 81.80 83.35 B www 84.90 86.45 29 05 88.05 90 60 89.60 SPONS 91.15 02.75 92.75 94.30 95.90 97.45 99.05 CC 5 24.20 25.30 26.45 27.55 WAEN 28,70 WANDE 29.80 L 30.90 32.05 33.15 CHOCO 34.30 35.40 PAS 36.50 37.65 57.69 38.75 59:90 39.90 41.00 42.15 42.15 12.25 43.25 MIS 44.35 48.50 45.50 1600 46.60 12 47.75 48.85 50.00 51.10 21:10 52.20 32:20 53.35 53.33 34.45 55.60 56.70 37.80 57.80 se os 58.95 10.05 60.05 6130 61.20 6220 62.30 63.45 64.55 SUPER 66.00 SER 67.55 2000 69.15 CON 70.70 NGUY 72.25 73.80 Me 75.35 Meme 76.95 78.50 80.05 81.60 83.20 0475 84.75 86.30 87.90 89.50 91.05 92.65 CC 6 17.80 18.90 20.00 21.15 3000 22.25 www 23.40 SCHOO 24.50 25.65 26.75 Dok 27.85 DEVICE 29.00 FAVOR 30.10 31.25 32.35 33.45 34.60 35.70 26.05 36.85 17.08 37.95 2010 39.10 40.20 41.30 42.45 42.43 43.55 www 44.70 45.80 46.95 48.05 40-15 49.15 50 20 50.30 51:40 51.40 52.55 52.55 52.66 53.65 54.75 15.00 55.90 T 57.00 NEW 58.15 S 59.60 K 61.15 V 62.70 www 64.30 Sa 65.85 67.40 ESCU 68.95 70.50 TE 72.10 73.65 75.20 76.75 70. 25 78.35 79.90 81.50 83.05 84.65 86.25 CC 7 11.35 12.50 13.60 14.75 PO 15.85 16.95 18.10 19.20 thev 20.35 S 21.45 B 22.60 ken 23.70 24.80 24.80 25.95 23.95 27.05 39.30 28.20 201 29.30 20.45 30.45 21.55 31.55 22.65 32.65 TO 33.80 34.90 36.05 31.03 37.15 38.25 39.40 40.50 41.65 42.75 42.00 43.90 16.00 45.00 16 46.10 MAY 47.25 48.35 49.50 50,60 KIKIN 51.70 FOX 53.20 K 54.75 B 56.30 www. 57.85 PE 59.45 61.00 62.55 64.10 65.65 67.25 68 80 68.80 70.25 70.35 71.90 2 73.50 NE DE 75.05 76.65 78.25 79.80 CC 8 4.95 6.10 7.20 MEN 8.30 B 9.45 Tes 10.55 11.70 12.80 12:00 13.90 DOMIN 15.05 16.15 S 17.30 18.40 19.55 19:55 20.65 21.75 21.75 22.00 22.90 24.00 24.00 25.15 26.25 27.40 28.50 29.60 30.75 20:13 31.03 31.85 33.00 34.10 35.20 36.35 37.45 20 60 38.60 30 20 39.70 1000 40.85 www 41.95 14.06 43.05 ww 44.20 45.30 46.75 B 48.35 2000 49.90 w 51.45 20240 53.00 54.60 56.15 57.70 59.25 60.80 62.40 63.95 63.95 65.50 65.50 67.10 67.10 68.65 70.25 71.80 73.40 CC 9 .80 1.90 3.05 4.15 5.25 6.40 7.50 RON 8.65 TERE 9.75 BA 10.85 12.00 13.10 14.25 15 25 15.35 1650 16.50 17.60 18.70 19.85 20.95 22.10 23.201 24.35 E3%D 25.45 26.55 27.70 28.80 29.95 31.05 22.15 32.15 72 20 33.30 200 34.40 *** 35.55 26.65 36.65 Pro 37.80 38.90 200 40.35 W 41.90 P 43.50 www 45.05 MODE 46.60 CAT 48.15 49.70 BONG 51.30 52.85 54.40 55.95 57.55 57.55 en in 59.10 ence 60.65 62.25 63.85 65.40 67.00 CC 10 1.10 2.20 3.35 4.45 5.60 6.70 7,80 8.95 10.05 11.20 11.20 12.30 12.30 leve 13.45 14.55 15.65 16.80 17.90 1790 19.05 19:09 20.15 20.10 21.30 21:50 22.40 23.50 24.65 25.75 25.75 76.00 26.90 w 30.00 28.00 29.10 BOHN 30.25 W 31.35 32.50 20 33.95 KUA 35.50 B 37.05 38.65 40.20 PEN 41.75 200 43.30 Bo 44.85 w 46.45 PA 48.00 49.55 5110 51.10 1220 52.70 A 54.25 55.85 57.40 59.00 60.60 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 589 597 605 . 613 621 CAN 629 637 645 653 661 669 009 677 685 689 693 201 701 700 709 717 725 732 733 741 773 781 199 789 797 813 813 921 821 9:30 829 017 837 016 845 853 861 8.60 869 JONE 877 . 200 885 893 901 909 917 925 933 941 949 - - 989 997 1005 1013 1021 . ▾ . - 805 - 805 . . - 749 757 765 - 773 781 For . . - - . . . - 957 965 973 981 - . 597 605 613 621 - 629 The 637 Y 645 653 661 MORE 669 971 677 685 693 701 709 717 105 725 www 733 741 741 10 749 2011 757 765 789 192 797 805 813 821 829 977 837 ass 845 Des 853 861 Pen 869 S 877 20. 885 S 893 901 909 T 917 925 933 941 949 www 957 965 973 net 981 989 997 1005 1013 1021 1029 CC 0 80.20 81.30 82.45 83.55 APERT 84.70 MONTANA 85.80 86.95 88.05 89.15 90.30 91.40 91.40 92.55 S 93.65 94.75 05.00 95.90 97.00 09 15 98.15 99.25 100.40 in 101.50 102.60 103.75 104.85 106.00 107.10 107:10 108.20 109.35 110.45 111.60 112.70 117.05 113.85 114.05 114.95 116.05 116.05 MOS 117.20 11016 118.30 119.45 120.55 MAV 122.00 CASION 123.60 LEXMAY 125.15 www.ca 126,70 FO 128.25 COLL 129.80 131.40 STEROWN 132.95 w 134.50 136.05 137.65 139.20 140 75 140.75 14220 142.30 143.90 145.50 147.05 148.65 CC 1 46.65 47.75 48.90 20 50.00 www 51.10 BROW 52.25 S 53.35 Sam 54.50 BON 55.60 OPON 56.75 37.85 S 58.95 60.10 60.10 61.20 61.20 62 25 62.35 63.45 64.55 65.70 65.70 66.90 66.80 17.05 67.95 Com 69.05 70.20 71.30 11:30 72.40 73.55 13:33 74.65 75.80 15.80 76.90 78.05 70 15 79.15 20 35 80.25 21:46 81.40 02.50 82.50 orde 83.65 W 84.75 ANDRO 85.85 ERFOR 87.00 COP 88.45 90.00 91.55 AMA 93.15 Au 94.70 96.25 PE 97.80 www 99.40 Spaty 100.95 102.50 104.05. 105.60 10.0 107.20 100 75 108.75 110.35 111.90 113.50 115.10 CC 2 43.45 44.55 45.65 46.80 NEGR 47.90 TRAINA 49.05 METO 50.15 51.30 SALAM 52.40 53.50 54.65 20 55.75 03:0 56.90 58.00 59.10 60.25 61.25 61.35 6210 62.50 63.60 63.60 66.75 64.75 65 05 65.85 66.95 68.10 69.20 09.20 70.35 10:33 71.45 71.45 72.60 73.70 74.80 75.95 77.05 79 20 78.20 30.10 79.30 80.40 L 81.55 82.65 83.80 85.25 2 86.80 boo 88.35 CE 89.95 91.50 93.05 Borgar 94.60 96.15 97.75 99.30 100.85 102 50 102.40 104.00 104.00 ** 105.55 107.15 108.70 110.30 111.90 CC 3 37.00 38.15 39.25 40.40 Pen 41.50 42.60 43.75 44.85 FOT 46.00 ONLINE 47.10 S 48.25 49.35 50.45 30.43 51.60 52.70 53.85 54.95 56 10 56.10 57. 20 57.20 10:30 58.30 59.45 60.55 61.70 62.80 V2.00 63.90 05:30 65.05 09.09 66.15 DORD 67.30 68.40 69.55 70.65 70.65 71 75 71.75 1000 72.90 M 74.00 MAXON 75.15 V 76.25 77.35 78.85 V 80.40 81.95 83.50 85.10 86.65 88.20 V 89.75 91.30 92.90 94.45 06.00 07.55 97.55 mnie 99.15 100.70 102.30 103.90 105.45 CC 4 30.60 31.75 32.85 33.95 Bese 35.10 PUN 36.20 37.35 B 38.45 CA 39.55 P 40.70 41.80 D 42.95 44.05 44.00 45.20 46.30 47.40 48.55 40.65 49.65 50 80 50.80 2100 51.90 PER 53.05 SAIS 54.15 55.25 56.40 30:10 57.50 SECON 58.65 30.03 59.75 39.13 60.85 62.00 63.10 66.25 64.25 65 25 65.35 16.50 66.50 to 67.60 como 68.70 69.85 FRAN 70.95 Le 72.40 VEN 74.00 75.55 TORPA 77.10. K 78.65 1000 80.25 81.80 83.35 B www 84.90 86.45 29 05 88.05 90 60 89.60 SPONS 91.15 02.75 92.75 94.30 95.90 97.45 99.05 CC 5 24.20 25.30 26.45 27.55 WAEN 28,70 WANDE 29.80 L 30.90 32.05 33.15 CHOCO 34.30 35.40 PAS 36.50 37.65 57.69 38.75 59:90 39.90 41.00 42.15 42.15 12.25 43.25 MIS 44.35 48.50 45.50 1600 46.60 12 47.75 48.85 50.00 51.10 21:10 52.20 32:20 53.35 53.33 34.45 55.60 56.70 37.80 57.80 se os 58.95 10.05 60.05 6130 61.20 6220 62.30 63.45 64.55 SUPER 66.00 SER 67.55 2000 69.15 CON 70.70 NGUY 72.25 73.80 Me 75.35 Meme 76.95 78.50 80.05 81.60 83.20 0475 84.75 86.30 87.90 89.50 91.05 92.65 CC 6 17.80 18.90 20.00 21.15 3000 22.25 www 23.40 SCHOO 24.50 25.65 26.75 Dok 27.85 DEVICE 29.00 FAVOR 30.10 31.25 32.35 33.45 34.60 35.70 26.05 36.85 17.08 37.95 2010 39.10 40.20 41.30 42.45 42.43 43.55 www 44.70 45.80 46.95 48.05 40-15 49.15 50 20 50.30 51:40 51.40 52.55 52.55 52.66 53.65 54.75 15.00 55.90 T 57.00 NEW 58.15 S 59.60 K 61.15 V 62.70 www 64.30 Sa 65.85 67.40 ESCU 68.95 70.50 TE 72.10 73.65 75.20 76.75 70. 25 78.35 79.90 81.50 83.05 84.65 86.25 CC 7 11.35 12.50 13.60 14.75 PO 15.85 16.95 18.10 19.20 thev 20.35 S 21.45 B 22.60 ken 23.70 24.80 24.80 25.95 23.95 27.05 39.30 28.20 201 29.30 20.45 30.45 21.55 31.55 22.65 32.65 TO 33.80 34.90 36.05 31.03 37.15 38.25 39.40 40.50 41.65 42.75 42.00 43.90 16.00 45.00 16 46.10 MAY 47.25 48.35 49.50 50,60 KIKIN 51.70 FOX 53.20 K 54.75 B 56.30 www. 57.85 PE 59.45 61.00 62.55 64.10 65.65 67.25 68 80 68.80 70.25 70.35 71.90 2 73.50 NE DE 75.05 76.65 78.25 79.80 CC 8 4.95 6.10 7.20 MEN 8.30 B 9.45 Tes 10.55 11.70 12.80 12:00 13.90 DOMIN 15.05 16.15 S 17.30 18.40 19.55 19:55 20.65 21.75 21.75 22.00 22.90 24.00 24.00 25.15 26.25 27.40 28.50 29.60 30.75 20:13 31.03 31.85 33.00 34.10 35.20 36.35 37.45 20 60 38.60 30 20 39.70 1000 40.85 www 41.95 14.06 43.05 ww 44.20 45.30 46.75 B 48.35 2000 49.90 w 51.45 20240 53.00 54.60 56.15 57.70 59.25 60.80 62.40 63.95 63.95 65.50 65.50 67.10 67.10 68.65 70.25 71.80 73.40 CC 9 .80 1.90 3.05 4.15 5.25 6.40 7.50 RON 8.65 TERE 9.75 BA 10.85 12.00 13.10 14.25 15 25 15.35 1650 16.50 17.60 18.70 19.85 20.95 22.10 23.201 24.35 E3%D 25.45 26.55 27.70 28.80 29.95 31.05 22.15 32.15 72 20 33.30 200 34.40 *** 35.55 26.65 36.65 Pro 37.80 38.90 200 40.35 W 41.90 P 43.50 www 45.05 MODE 46.60 CAT 48.15 49.70 BONG 51.30 52.85 54.40 55.95 57.55 57.55 en in 59.10 ence 60.65 62.25 63.85 65.40 67.00 CC 10 1.10 2.20 3.35 4.45 5.60 6.70 7,80 8.95 10.05 11.20 11.20 12.30 12.30 leve 13.45 14.55 15.65 16.80 17.90 1790 19.05 19:09 20.15 20.10 21.30 21:50 22.40 23.50 24.65 25.75 25.75 76.00 26.90 w 30.00 28.00 29.10 BOHN 30.25 W 31.35 32.50 20 33.95 KUA 35.50 B 37.05 38.65 40.20 PEN 41.75 200 43.30 Bo 44.85 w 46.45 PA 48.00 49.55 5110 51.10 1220 52.70 A 54.25 55.85 57.40 59.00 60.60