Continuing Payroll Project: Prevosti Farms and Sugarhouse
Complete the Payroll Register for the February and March biweekly pay periods, assuming benefits went into effect as anticipated. Use the Wage Bracket Method Tables for Income Tax Withholding in Appendix C. Complete the General Journal entries as follows:
| February 10 | Journalize the employee pay. |
| February 10 | Journalize the employer payroll tax for the February 10 pay period. Use 5.4 percent SUTA and 0.6 percent FUTA. No employees will exceed the FUTA or SUTA wage base. |
| February 13 | Issue the employee pay. |
| February 24 | Journalize the employee pay. |
| February 24 | Journalize the employer payroll tax for the February 24 pay period. Use 5.4 percent SUTA and 0.6 percent FUTA. No employee will exceed the FUTA or SUTA wage base.page 343 |
| February 27 | Issue the employee pay. |
| March 10 | Journalize employee pay. |
| March 10 | Journalize employer payroll tax for the March 10 pay period. Use 5.4% SUTA and 0.6% FUTA. No employees will exceed the FUTA or SUTA wage base. |
| March 14 | Issue employee pay. |
| March 24 | Journalize employee pay. |
| March 24 | Journalize employer payroll tax for the March 24 pay period. Use 5.4% SUTA and 0.6% FUTA. No employees will exceed FUTA or SUTA wage base. |
| March 28 | Issue employee pay. |
The payroll registers are provided that you need to record the journal entries.
A B D R S 2 3 February 10 4 February 13 February 24 February 24 5 6 7 8 9 10 11 12 13 14 February 27 March 10 March 10 EFGHIJKLMNOPQ Journalize employer payroll tax for the February 12 pay period. Use 5.4% SUTA and 0.6% FUTA. No employees will exceed FUTA or SUTA wage base. Issue employee pay. Journalize employee pay. Journalize employer payroll tax for the February 24 pay period. Use 5.4% SUTA and 0.6% FUTA. No employees will exceed FUTA or SUTA wage base. Issue employee pay. Pay payroll taxes. Journalize employee pay. Journalize employer payroll tax for the March 10 pay period. Using 5.4% SUTA and .06 FUTA. No employees will exceed FUTA or SUTA wage base. Take into consideration the new benefits. Issue employee pay. Journalize employee pay. Journalize employer payroll tax for the March 24 pay period. Using 5.4% SUTA and .06 FUTA. No employees will exceed FUTA or SUTA wage base. Take into consideration the new benefits. Issue employee pay. Pay payroll taxes. 15 16 17 March 14 March 24 March 24 18 19 20 21 22 23 March 28 mployee pay.Pay payroll Date Description Post Ref. Debit Credit 24 251 26 2 27 3 28 4 29 5 30 31 21 32 10 11 12 13 14 15 16 339 34 10 35 11 36 12 37 13 38 14 39 15 40 16 41 17 42 18 43 19 44 20 45 21 46 22 47 23 48 24 17 18 19 20 21 22 23 24 25 26 27 28 49 25 50 26 51 27 52 28 53 29 54 BC 55 31 56 32 29 30 31 32 A B C D E FGHIJKLMNOPQRS T U V W X Y Z AA AB 1 Account: Cash 101 2 Balance 3 Date Description Post Ref. Debit Credit Debit Credit 4 1 26 0 00 5 2 2 6 3 3 7 4 4 8 5 5 9 6 6 10 7 11 203 Balance 12 Account: Employee Federal Income Tax Payable 13 14 Date Description Post Ref. 15 Debit Credit Debit Credit 2 2 16 17 18 3 3 4 5 5 19 20 6 21 204 Balance 22 Account: Social Security Tax Payable 23 24 Date Description Post Ref. 25 1 Debit Credit Debit Credit 2 2 26 27 3 3 28 4 4 5 5 29 30 6 6 31 7 7 8 32 8 33 9 34 10 9 10 205 Balance 35 36 Account: Medicare Tax Payable 37 38 Date Description 39 1 40 2. Post Ref. Debit Credit Debit Credit 1 2 41 3 3 42 4 4 43 5 5 6 6 44 45 7 7 46 8 8 47 9 9 48 10 10 49 206 Balance 50 Account: Employee State Income Tax Payable 51 52 Date Description Post Ref. 53 1 54 2 Debit Credit Debit Credit 2 3 3 55 56 57 4 5 5 58 59 60 Account: 401(k) Contributions Payable 208 61 Balance Date Description Post Ref. Debit Credit Debit Credit 62 63 1 64 2 2 65 3 3 4 4 66 67 5 5 68 6 6 69 A B D E FGHIJKLMNOPQRS T U V W X Y Z AA AB 209 69 70 Account: Health Insurance Payable 71 72 Date Description Post Ref. 73 1 Balance Debit Credit Debit Credit 1 74 2 2 3 3 4 4 75 76 77 78 5 61 210 79 80 Account: Salaries and Wages Payable 81 82 Date Description Post Ref. 83 1 Balance Debit Credit Debit Credit 2 2 84 85 86 3 3 4 4 87 5 5 88 6 6 89 7 90 8 211 Balance Post Ref. Debit Credit Debit Credit 1 2 3 91 92 Account: FUTA Tax Payable 93 94 Date Description 95 1 96 2 97 3 98 4 99 5 100 61 101 7 102 103 Account: SUTA Tax Payable 104 4 5 6 7 212 Balance 105 Date Description Post Ref. Debit Credit Debit Credit 2 2 3 3 106 107 108 109 110 111 112 4 4 5 5 6 6 7 514 113 114 Account: Payroll Taxes Expense 115 116 Date Description 117 1 Balance Post Ref. Debit Credit Debit Credit 1 118 2 2 3 3 119 120 121 4 4 5 5 122 6 6 515 Balance 123 124 Account: Salaries and Wages Expense 125 126 Date Description Post Ref. 127 1 128 2 Debit Credit Debit Credit 2 3 3 4 4 129 130 131 132 5 5 6 6 133 134 A B D E F G H Name Gross Hourly Rate Hours Worked 2/6 - 2/10 35 Towle $ 12.00 Long $ 12.50 40 Pay $420 ($12 * 35 hours) $531.25 ($12.50 * 35 hours + $12.50 * 1.5 * 5 hours) $225.75 ($10.50 * 20 hours + $10.50 * 1.5 * 1 hour) $653.90 ($34,000/(52 weeks * 35 hours per week) to get hourly rate * 35 hours) Shangraw $ 10.50 21 Success $ 18.68 35 Name Hourly Rate $ 12.00 $ 12.50 Hours Worked 2/2/13 -2/24 80 960 Towle Long 70 875 Gross Pay $960 ($12 * 80 hours) $875 ($12.50 * 70 hours) $451.50 ($10.50 * 40 hours + $10.50 * 1.5 * 2 hour) $1,335.71 ($34,000/(52 weeks * 35 hours per week) to get hourly rate * 70 hours) + ($18.68 *1 overtime hour * 1.5) Shangraw $ 10.50 42 451.5 Success $ 18.68 71 B F G H K L M N 0 P Q R S T U 1 2 P/R End Date / 3 Chock Date 4 Prevosti Falms and Sugarhouse 2/10/17 2/13/17 Company Name Educ Assist Nams Child Care ESA Life Ins. 5 6 Thomas Millen 7 Avery Towle 8 Charlie Long 9 Mary Shangraw 10 Kristen Lewis 11 Joe Schwartz 12 Toni Prevosti 13 Student Success 14 Houdly Rate. #er Period # Rcanlar # Ometime # Holiday Commis- MAS WH wave Hans Hous Hous sions M4 19.23077 35 S1 12.00000 35 M 2 12.50000 35 S SIL 10.50000 20 1 M3 17.58242 35 M 2 13.18681 35 150.00 M 5 24.72527 35 S 2 18.68132 35 Totals Gimee Esming 401(k) 673.08 20.19 420.00 21.00 531.25 10.63 225.75 6.77 615.38 24.62 611.54 30.58 865.38 51.92 653.85 13.08 4,596.23 178.79 Ser 125 155.00 100.00 155.00 100.00 155.00 100.00 155.00 100.00 1.020.00 Taxable Wagns for Tewable Lone-tomm Endeal Care WH FICA 497.89 518.08 299,00 320.00 365.62 376.25 118.98 125.75 435.76 460.38 480.96 511.54 658.46 710.38 540.77 553.85 3,397.443,576.23 United Way Cium 5.46 15 Name 16 Thomas Millen 17 Avery Towlo 18 Charlie Long 19 Mary Shangw 20 Kristen Lewis 21 Joe Schwartz 22 Toni Prevosti 23 Student Success 24 25 26 27 28 29 Taxable. Taxable. Gims Wagues for Wees for Federal Lamine Eleni WH FICA 673.08 497.89 518.08 420.00 299.00 320.00 5.00 531.25 365.62 376.25 225.75 118.98 125.75 615.38 435.76 460.38 611.54 480.96 $11.54 865.38 658.46 710.38 653.85 540.77 553.85 15.00 Totals 4,596.23 3,397.44 3.576.23 20.00 Social Securi Medicare State WIL Gumish: Tax WH Thx ment 32.12 7.51 17.68 19.84 4.64 10.61 23.33 12.98 7.80 1.82 4.22 28.54 6.68 15.47 31.72 7.42 17.07 44.04 23.38 34.34 19.20 221.73 51.86 120.61 Total Deductions Net Pry 232.50 440.58 161.09 258,91 207.40 323.85 120.61 105.14 230.31 385.07 186.79 424.75 284.64 580.74 189.65 464.20 1,612.99 2,983.24 Check No. 6628 6629 6630 6631 6632 6633 6634 6635 10.30 8.03 30 B C D E G H K M N 0 P a R T U 1 2 P/R End Date 3 Check Date 4 Prevosti Farms and Sugarhouse 2/24/17 2/27/17 Company Name Educ Child Care ESA Artist Life Ins 5 Name 6 Thomas Millen 7 Avery Towle 8 Charlie Long 9 Mary Shangra 10 Kristen Lewis 11 Joe Schwartz 12 Toni Prevosti 13 Student Success 14 Hourly Rare. # ar Period. MIS WAH C M 4 19.23077 S S 1 12.00000 M 2 12.50000 S 1 10.50000 M 3 17.58242 M 2 13.18681 M 5 24.72527 S 2 18.68132 #Reamlet overtime Halidey. Cammis. Gimss. Homes Homes Homes siens Famine 400 See 125 70 1.346.15 40.38 155.00 70 10 1.020.00 51.00 100.00 70 875.00 17.50 155.00 40 2 451.50 13.55 100.00 70 1,230.77 49.23 155.00 70 225.00 1,148.08 57.40 100.00 70 1,730.77 103.85 155.00 70 1,335.71 26.71 100.00 9,137.98 359.62 1,020.00 Texable Waves for Taxable. Long-term Eederal Wapa fas Cane WE EICA 1,150.77 1,191.15 869.00 920.00 702.50 720.00 337.95 351.50 1,026.54 1,075.77 990.68 1,048.08 1,471.92 1,575.77 1,209.00 1,235.71 7,758.36 8,117.98 Totals Inited Way Com Tuwahle Table Social Cimss. Wages for Wages for Esloral Security Ned. Sute W Cumish Eumingliederul WH WTICA WI W THX men: 1,346.15 1.150.771.191.15 19.00 73.85 17.27 40.85 1,020,00 869.00 920.00 76.00 57.04 13.34 30.85 875.00 702.50 720.00 7.00 44.64 10.44 24.94 451.50 33795 351.50 9.00 21.79 5.10 12.00 1.230.77 1,026,54 1.075.77 25.00 66.70 15.60 36.44 1,148.08 990 68 1,048.08 35.00 64.98 15.20 35.17 1,730.77 1.471.92 1,575.77 36.00 97.70 22.85 52.25 1.335.71 1.209.00 1,235,71 104.00 76.61 17.92 42.92 Totals 9.137.98 7.358.36 8,117.98 311.00 503.31 117.72 275.42 Total Deductions Net Phy 346.35 999.80 328.23 691.77 259.52 615.48 161.44 290.06 347.97 882.80 307.75 840.33 467.65 1,263.12 368.16 967.55 2,387.076,550.91 15 Name 16 Thomas Millen 17 Avery Towle 18 Charlie Long 19 Mary Shangra 20 Kristen Lewis 21 Joe Schwartz 22 Toni Prevosti 23 Student Success 24 25 25 27 28 29 30 31 Cheel la 6636 6637 6638 6639 6640 6641 6642 6643 9 A B D E F G H 1 J K L M N 0 P Q R S T U 1 2 3/10/17 Company Name Prevosti Farms and Sugarhouse P/R End Date Check Date 3 3/14/17 4 Taxable. Wages for Taxable. Federal Wages for W/H FICA # Regular Hours # Overtime # Holiday Hours Hours Commis- sions Gross. Earning 1,346.15 Educ Assist Long-term Care 401(k) Sec 125 Child Care ESA Life Ins. 70 40.38 70 10 Hourly Rate # or Period MIS WH wage M 4 19.23077 S 1 12.00000 M 2 12.50000 S 1 10.50000 M 3 17.58242 M 2 13.18681 M 5 24.72527 S 2 18.68132 1,020.00 875.00 155.00 100.00 155.00 100.00 70 40 5 Name 6 Thomas Millen 7 Avery Towle 8 Charlie Long 9 Mary Shangraw 10 Kristen Lewis 11 Joe Schwartz 12 Toni Prevosti 13 Student Success 14 2 70 51.00 17.50 13.55 49.23 57.40 103.85 26.71 359.62 451.50 1,230.77 1,148.08 1,730.77 1,335.71 9,137.98 1,150.77 869.00 702.50 337.95 1,026.54 990.68 1,471.92 1,209.00 7,758.36 70 1,191.15 920.00 720.00 351.50 1,075.77 1,048.08 1,575.77 1,235.71 8,117.98 225.00 155.00 100.00 155.00 100.00 1,020.00 70 70 Totals Taxable Taxable Wages for Wages for Federal Federal W/H FICA W/H Social Security Tax Garnish- Medicare WIH State WIH Tax Total Deductions ment em United Way Gym Net Day Check No 19.00 40.85 346.35 999.80 6644 691.77 73.85 57.04 44.64 21.79 Gross. Earning 1,346.15 1,020.00 875.00 451.50 1,230.77 1,148.08 1,730.77 1,335.71 9,137.98 17.27 13.34 10.44 5.10 30.85 24.94 15 Name 16 Thomas Millen 17 Avery Towle 18 Charlie Long 19 Mary Shangraw 20 Kristen Lewis 21 Joe Schwartz 22 Toni Prevosti 23 Student Success 24 6645 6646 6647 12.00 1,150.77 869.00 702.50 337.95 1,026.54 990.68 1,471.92 1,209.00 7,758.36 328.23 259.52 161.44 347.97 1,191.15 920.00 720.00 351.50 1,075.77 1,048.08 1,575.77 1,235.71 8,117.98 615.48 290.06 882.80 66.70 15.60 36.44 6648 76.00 7.00 9.00 25.00 35.00 36.00 104.00 311.00 15.20 35.17 840.33 6649 22.85 6650 64.98 97.70 76.61 503.31 307.75 467.65 368.16 2,587.07 52.25 42.92 275.42 17.92 117.72 1,263.12 967.55 6,550.91 6651 Totals 25 26 27 28 A B C D E F G H T j L M N o P Q R S T U 1 2 P/R End Date Check Date Prevosti Farms and Sugarhouse 3/24/17 3/28/17 Company Name 3 4 Taxable Wages for Taxable. Federal Wages for W/H FICA # Regular Hours # Overtime # Holiday Commis- Hours Hours sions Educ Assist Long-term Care Sec 125 Child Care ESA Life Ins. 70 Gross. Earning 1,346.15 1,020.00 875.00 401(k 40.38 51.00 1,191.15 155.00 100.00 1,150.77 869.00 70 10 Hourly Rate # ar Period M/S WH wage M 4 19.23077 S 1 12.00000 M 2. 12.50000 S 1 10.50000 M 3 17.58242 M 2 13.18681 M 5 24.72527 S 2 18.68132 920.00 720.00 70 155.00 702.50 17.50 13.55 40 2 451.50 100.00 337.95 5 Name 6 Thomas Millen 7 Avery Towle 8 Charlie Long 9 Mary Shangraw 10 Kristen Lewis 11 Joe Schwartz 12 Toni Prevosti 13 Student Success 14 351.50 70 155.00 100.00 70 225.00 49.23 57.40 103.85 1,230.77 1,148.08 1,730.77 1,335.71 9,137.98 70 155.00 1,026.54 990.68 1,471.92 1.209.00 7,758.36 1,075.77 1,048.08 1,575.77 1,235.71 8,117.98 70 100.00 26.71 359.62 Totals 1,020.00 Social Security Tax Garnish- Medicare W/H State W/H Tax Name ment United Way Gym Check No Gross Earning 1,346.15 1,020.00 875.00 Net Dax 999.80 73.85 17.27 40.85 6652 16 Thomas Millen 17 Avery Towle 18 Charlie Long 19 Mary Shangraw 20 Kristen Lewis 13.34 Total Deductions 346.35 328.23 259.52 161.44 6653 57.04 44.64 10.44 Taxable Taxable Wages for Wages for Federal Federal W/H FICA W/H 1,150.77 1,191.15 19.00 869.00 920.00 76.00 702.50 720.00 7.00 337.95 351.50 9.00 1,026.54 1,075.77 25.00 990.68 1,048.08 35.00 1,471.92 1,575.77 36.00 1,209.00 1,235.71 104.00 7,758.36 8,117.98 311.00 30.85 24.94 12.00 691.77 615.48 290.06 6654 451.50 21.79 5.10 6655 66.70 15.60 36.44 6656 882.80 840.33 21 Joe Schwartz 6657 1,230.77 1,148.08 1,730.77 1,335.71 9,137.98 22 Toni Prevosti 23 Student Success 6658 64.98 97.70 76.61 503.31 15.20 22.85 17.92 117.72 347.97 307.75 467.65 368.16 2,587.07 35.17 52.25 42.92 275.42 1,263.12 967.55 6,550.91 6659 Totals A B D R S 2 3 February 10 4 February 13 February 24 February 24 5 6 7 8 9 10 11 12 13 14 February 27 March 10 March 10 EFGHIJKLMNOPQ Journalize employer payroll tax for the February 12 pay period. Use 5.4% SUTA and 0.6% FUTA. No employees will exceed FUTA or SUTA wage base. Issue employee pay. Journalize employee pay. Journalize employer payroll tax for the February 24 pay period. Use 5.4% SUTA and 0.6% FUTA. No employees will exceed FUTA or SUTA wage base. Issue employee pay. Pay payroll taxes. Journalize employee pay. Journalize employer payroll tax for the March 10 pay period. Using 5.4% SUTA and .06 FUTA. No employees will exceed FUTA or SUTA wage base. Take into consideration the new benefits. Issue employee pay. Journalize employee pay. Journalize employer payroll tax for the March 24 pay period. Using 5.4% SUTA and .06 FUTA. No employees will exceed FUTA or SUTA wage base. Take into consideration the new benefits. Issue employee pay. Pay payroll taxes. 15 16 17 March 14 March 24 March 24 18 19 20 21 22 23 March 28 mployee pay.Pay payroll Date Description Post Ref. Debit Credit 24 251 26 2 27 3 28 4 29 5 30 31 21 32 10 11 12 13 14 15 16 339 34 10 35 11 36 12 37 13 38 14 39 15 40 16 41 17 42 18 43 19 44 20 45 21 46 22 47 23 48 24 17 18 19 20 21 22 23 24 25 26 27 28 49 25 50 26 51 27 52 28 53 29 54 BC 55 31 56 32 29 30 31 32 A B C D E FGHIJKLMNOPQRS T U V W X Y Z AA AB 1 Account: Cash 101 2 Balance 3 Date Description Post Ref. Debit Credit Debit Credit 4 1 26 0 00 5 2 2 6 3 3 7 4 4 8 5 5 9 6 6 10 7 11 203 Balance 12 Account: Employee Federal Income Tax Payable 13 14 Date Description Post Ref. 15 Debit Credit Debit Credit 2 2 16 17 18 3 3 4 5 5 19 20 6 21 204 Balance 22 Account: Social Security Tax Payable 23 24 Date Description Post Ref. 25 1 Debit Credit Debit Credit 2 2 26 27 3 3 28 4 4 5 5 29 30 6 6 31 7 7 8 32 8 33 9 34 10 9 10 205 Balance 35 36 Account: Medicare Tax Payable 37 38 Date Description 39 1 40 2. Post Ref. Debit Credit Debit Credit 1 2 41 3 3 42 4 4 43 5 5 6 6 44 45 7 7 46 8 8 47 9 9 48 10 10 49 206 Balance 50 Account: Employee State Income Tax Payable 51 52 Date Description Post Ref. 53 1 54 2 Debit Credit Debit Credit 2 3 3 55 56 57 4 5 5 58 59 60 Account: 401(k) Contributions Payable 208 61 Balance Date Description Post Ref. Debit Credit Debit Credit 62 63 1 64 2 2 65 3 3 4 4 66 67 5 5 68 6 6 69 A B D E FGHIJKLMNOPQRS T U V W X Y Z AA AB 209 69 70 Account: Health Insurance Payable 71 72 Date Description Post Ref. 73 1 Balance Debit Credit Debit Credit 1 74 2 2 3 3 4 4 75 76 77 78 5 61 210 79 80 Account: Salaries and Wages Payable 81 82 Date Description Post Ref. 83 1 Balance Debit Credit Debit Credit 2 2 84 85 86 3 3 4 4 87 5 5 88 6 6 89 7 90 8 211 Balance Post Ref. Debit Credit Debit Credit 1 2 3 91 92 Account: FUTA Tax Payable 93 94 Date Description 95 1 96 2 97 3 98 4 99 5 100 61 101 7 102 103 Account: SUTA Tax Payable 104 4 5 6 7 212 Balance 105 Date Description Post Ref. Debit Credit Debit Credit 2 2 3 3 106 107 108 109 110 111 112 4 4 5 5 6 6 7 514 113 114 Account: Payroll Taxes Expense 115 116 Date Description 117 1 Balance Post Ref. Debit Credit Debit Credit 1 118 2 2 3 3 119 120 121 4 4 5 5 122 6 6 515 Balance 123 124 Account: Salaries and Wages Expense 125 126 Date Description Post Ref. 127 1 128 2 Debit Credit Debit Credit 2 3 3 4 4 129 130 131 132 5 5 6 6 133 134 A B D E F G H Name Gross Hourly Rate Hours Worked 2/6 - 2/10 35 Towle $ 12.00 Long $ 12.50 40 Pay $420 ($12 * 35 hours) $531.25 ($12.50 * 35 hours + $12.50 * 1.5 * 5 hours) $225.75 ($10.50 * 20 hours + $10.50 * 1.5 * 1 hour) $653.90 ($34,000/(52 weeks * 35 hours per week) to get hourly rate * 35 hours) Shangraw $ 10.50 21 Success $ 18.68 35 Name Hourly Rate $ 12.00 $ 12.50 Hours Worked 2/2/13 -2/24 80 960 Towle Long 70 875 Gross Pay $960 ($12 * 80 hours) $875 ($12.50 * 70 hours) $451.50 ($10.50 * 40 hours + $10.50 * 1.5 * 2 hour) $1,335.71 ($34,000/(52 weeks * 35 hours per week) to get hourly rate * 70 hours) + ($18.68 *1 overtime hour * 1.5) Shangraw $ 10.50 42 451.5 Success $ 18.68 71 B F G H K L M N 0 P Q R S T U 1 2 P/R End Date / 3 Chock Date 4 Prevosti Falms and Sugarhouse 2/10/17 2/13/17 Company Name Educ Assist Nams Child Care ESA Life Ins. 5 6 Thomas Millen 7 Avery Towle 8 Charlie Long 9 Mary Shangraw 10 Kristen Lewis 11 Joe Schwartz 12 Toni Prevosti 13 Student Success 14 Houdly Rate. #er Period # Rcanlar # Ometime # Holiday Commis- MAS WH wave Hans Hous Hous sions M4 19.23077 35 S1 12.00000 35 M 2 12.50000 35 S SIL 10.50000 20 1 M3 17.58242 35 M 2 13.18681 35 150.00 M 5 24.72527 35 S 2 18.68132 35 Totals Gimee Esming 401(k) 673.08 20.19 420.00 21.00 531.25 10.63 225.75 6.77 615.38 24.62 611.54 30.58 865.38 51.92 653.85 13.08 4,596.23 178.79 Ser 125 155.00 100.00 155.00 100.00 155.00 100.00 155.00 100.00 1.020.00 Taxable Wagns for Tewable Lone-tomm Endeal Care WH FICA 497.89 518.08 299,00 320.00 365.62 376.25 118.98 125.75 435.76 460.38 480.96 511.54 658.46 710.38 540.77 553.85 3,397.443,576.23 United Way Cium 5.46 15 Name 16 Thomas Millen 17 Avery Towlo 18 Charlie Long 19 Mary Shangw 20 Kristen Lewis 21 Joe Schwartz 22 Toni Prevosti 23 Student Success 24 25 26 27 28 29 Taxable. Taxable. Gims Wagues for Wees for Federal Lamine Eleni WH FICA 673.08 497.89 518.08 420.00 299.00 320.00 5.00 531.25 365.62 376.25 225.75 118.98 125.75 615.38 435.76 460.38 611.54 480.96 $11.54 865.38 658.46 710.38 653.85 540.77 553.85 15.00 Totals 4,596.23 3,397.44 3.576.23 20.00 Social Securi Medicare State WIL Gumish: Tax WH Thx ment 32.12 7.51 17.68 19.84 4.64 10.61 23.33 12.98 7.80 1.82 4.22 28.54 6.68 15.47 31.72 7.42 17.07 44.04 23.38 34.34 19.20 221.73 51.86 120.61 Total Deductions Net Pry 232.50 440.58 161.09 258,91 207.40 323.85 120.61 105.14 230.31 385.07 186.79 424.75 284.64 580.74 189.65 464.20 1,612.99 2,983.24 Check No. 6628 6629 6630 6631 6632 6633 6634 6635 10.30 8.03 30 B C D E G H K M N 0 P a R T U 1 2 P/R End Date 3 Check Date 4 Prevosti Farms and Sugarhouse 2/24/17 2/27/17 Company Name Educ Child Care ESA Artist Life Ins 5 Name 6 Thomas Millen 7 Avery Towle 8 Charlie Long 9 Mary Shangra 10 Kristen Lewis 11 Joe Schwartz 12 Toni Prevosti 13 Student Success 14 Hourly Rare. # ar Period. MIS WAH C M 4 19.23077 S S 1 12.00000 M 2 12.50000 S 1 10.50000 M 3 17.58242 M 2 13.18681 M 5 24.72527 S 2 18.68132 #Reamlet overtime Halidey. Cammis. Gimss. Homes Homes Homes siens Famine 400 See 125 70 1.346.15 40.38 155.00 70 10 1.020.00 51.00 100.00 70 875.00 17.50 155.00 40 2 451.50 13.55 100.00 70 1,230.77 49.23 155.00 70 225.00 1,148.08 57.40 100.00 70 1,730.77 103.85 155.00 70 1,335.71 26.71 100.00 9,137.98 359.62 1,020.00 Texable Waves for Taxable. Long-term Eederal Wapa fas Cane WE EICA 1,150.77 1,191.15 869.00 920.00 702.50 720.00 337.95 351.50 1,026.54 1,075.77 990.68 1,048.08 1,471.92 1,575.77 1,209.00 1,235.71 7,758.36 8,117.98 Totals Inited Way Com Tuwahle Table Social Cimss. Wages for Wages for Esloral Security Ned. Sute W Cumish Eumingliederul WH WTICA WI W THX men: 1,346.15 1.150.771.191.15 19.00 73.85 17.27 40.85 1,020,00 869.00 920.00 76.00 57.04 13.34 30.85 875.00 702.50 720.00 7.00 44.64 10.44 24.94 451.50 33795 351.50 9.00 21.79 5.10 12.00 1.230.77 1,026,54 1.075.77 25.00 66.70 15.60 36.44 1,148.08 990 68 1,048.08 35.00 64.98 15.20 35.17 1,730.77 1.471.92 1,575.77 36.00 97.70 22.85 52.25 1.335.71 1.209.00 1,235,71 104.00 76.61 17.92 42.92 Totals 9.137.98 7.358.36 8,117.98 311.00 503.31 117.72 275.42 Total Deductions Net Phy 346.35 999.80 328.23 691.77 259.52 615.48 161.44 290.06 347.97 882.80 307.75 840.33 467.65 1,263.12 368.16 967.55 2,387.076,550.91 15 Name 16 Thomas Millen 17 Avery Towle 18 Charlie Long 19 Mary Shangra 20 Kristen Lewis 21 Joe Schwartz 22 Toni Prevosti 23 Student Success 24 25 25 27 28 29 30 31 Cheel la 6636 6637 6638 6639 6640 6641 6642 6643 9 A B D E F G H 1 J K L M N 0 P Q R S T U 1 2 3/10/17 Company Name Prevosti Farms and Sugarhouse P/R End Date Check Date 3 3/14/17 4 Taxable. Wages for Taxable. Federal Wages for W/H FICA # Regular Hours # Overtime # Holiday Hours Hours Commis- sions Gross. Earning 1,346.15 Educ Assist Long-term Care 401(k) Sec 125 Child Care ESA Life Ins. 70 40.38 70 10 Hourly Rate # or Period MIS WH wage M 4 19.23077 S 1 12.00000 M 2 12.50000 S 1 10.50000 M 3 17.58242 M 2 13.18681 M 5 24.72527 S 2 18.68132 1,020.00 875.00 155.00 100.00 155.00 100.00 70 40 5 Name 6 Thomas Millen 7 Avery Towle 8 Charlie Long 9 Mary Shangraw 10 Kristen Lewis 11 Joe Schwartz 12 Toni Prevosti 13 Student Success 14 2 70 51.00 17.50 13.55 49.23 57.40 103.85 26.71 359.62 451.50 1,230.77 1,148.08 1,730.77 1,335.71 9,137.98 1,150.77 869.00 702.50 337.95 1,026.54 990.68 1,471.92 1,209.00 7,758.36 70 1,191.15 920.00 720.00 351.50 1,075.77 1,048.08 1,575.77 1,235.71 8,117.98 225.00 155.00 100.00 155.00 100.00 1,020.00 70 70 Totals Taxable Taxable Wages for Wages for Federal Federal W/H FICA W/H Social Security Tax Garnish- Medicare WIH State WIH Tax Total Deductions ment em United Way Gym Net Day Check No 19.00 40.85 346.35 999.80 6644 691.77 73.85 57.04 44.64 21.79 Gross. Earning 1,346.15 1,020.00 875.00 451.50 1,230.77 1,148.08 1,730.77 1,335.71 9,137.98 17.27 13.34 10.44 5.10 30.85 24.94 15 Name 16 Thomas Millen 17 Avery Towle 18 Charlie Long 19 Mary Shangraw 20 Kristen Lewis 21 Joe Schwartz 22 Toni Prevosti 23 Student Success 24 6645 6646 6647 12.00 1,150.77 869.00 702.50 337.95 1,026.54 990.68 1,471.92 1,209.00 7,758.36 328.23 259.52 161.44 347.97 1,191.15 920.00 720.00 351.50 1,075.77 1,048.08 1,575.77 1,235.71 8,117.98 615.48 290.06 882.80 66.70 15.60 36.44 6648 76.00 7.00 9.00 25.00 35.00 36.00 104.00 311.00 15.20 35.17 840.33 6649 22.85 6650 64.98 97.70 76.61 503.31 307.75 467.65 368.16 2,587.07 52.25 42.92 275.42 17.92 117.72 1,263.12 967.55 6,550.91 6651 Totals 25 26 27 28 A B C D E F G H T j L M N o P Q R S T U 1 2 P/R End Date Check Date Prevosti Farms and Sugarhouse 3/24/17 3/28/17 Company Name 3 4 Taxable Wages for Taxable. Federal Wages for W/H FICA # Regular Hours # Overtime # Holiday Commis- Hours Hours sions Educ Assist Long-term Care Sec 125 Child Care ESA Life Ins. 70 Gross. Earning 1,346.15 1,020.00 875.00 401(k 40.38 51.00 1,191.15 155.00 100.00 1,150.77 869.00 70 10 Hourly Rate # ar Period M/S WH wage M 4 19.23077 S 1 12.00000 M 2. 12.50000 S 1 10.50000 M 3 17.58242 M 2 13.18681 M 5 24.72527 S 2 18.68132 920.00 720.00 70 155.00 702.50 17.50 13.55 40 2 451.50 100.00 337.95 5 Name 6 Thomas Millen 7 Avery Towle 8 Charlie Long 9 Mary Shangraw 10 Kristen Lewis 11 Joe Schwartz 12 Toni Prevosti 13 Student Success 14 351.50 70 155.00 100.00 70 225.00 49.23 57.40 103.85 1,230.77 1,148.08 1,730.77 1,335.71 9,137.98 70 155.00 1,026.54 990.68 1,471.92 1.209.00 7,758.36 1,075.77 1,048.08 1,575.77 1,235.71 8,117.98 70 100.00 26.71 359.62 Totals 1,020.00 Social Security Tax Garnish- Medicare W/H State W/H Tax Name ment United Way Gym Check No Gross Earning 1,346.15 1,020.00 875.00 Net Dax 999.80 73.85 17.27 40.85 6652 16 Thomas Millen 17 Avery Towle 18 Charlie Long 19 Mary Shangraw 20 Kristen Lewis 13.34 Total Deductions 346.35 328.23 259.52 161.44 6653 57.04 44.64 10.44 Taxable Taxable Wages for Wages for Federal Federal W/H FICA W/H 1,150.77 1,191.15 19.00 869.00 920.00 76.00 702.50 720.00 7.00 337.95 351.50 9.00 1,026.54 1,075.77 25.00 990.68 1,048.08 35.00 1,471.92 1,575.77 36.00 1,209.00 1,235.71 104.00 7,758.36 8,117.98 311.00 30.85 24.94 12.00 691.77 615.48 290.06 6654 451.50 21.79 5.10 6655 66.70 15.60 36.44 6656 882.80 840.33 21 Joe Schwartz 6657 1,230.77 1,148.08 1,730.77 1,335.71 9,137.98 22 Toni Prevosti 23 Student Success 6658 64.98 97.70 76.61 503.31 15.20 22.85 17.92 117.72 347.97 307.75 467.65 368.16 2,587.07 35.17 52.25 42.92 275.42 1,263.12 967.55 6,550.91 6659 Totals
