Payroll project.

I need help with this payroll project from Chapter 7. This is the book: Payroll Accounting, by Beig, Toland, edition 2017.

I attached an excel template with the beginning filled out, and just need to fill out the rest.

 

Unformatted Attachment Preview

Excel Instructions using Excel 2010 or 2013: CAUTION: Read Appendix B for specific instructions relating to these templates. 1. Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear to the right of an incorrect answer. 2. A formula begins with an equals sign (=) and can consist of any of the following elements: Operators such as + (for addition), – (for subtraction), * (for multiplication), and / (for division). Cell references, including cell addresses such as B52, as well as named cells and ranges Values and text Worksheet functions (such as SUM) 3. You can enter a formula into a cell manually (typing it in) or by pointing to the cells. To enter a formula manually, follow these steps: Move the cell pointer to the cell that you want to hold the formula. Type an equals sign (=) to signal the fact that the cell contains a formula. Type the formula, then press Enter. 4. Rounding: These templates have been formatted to round numbers to either the nearest whole number or the nearest cent. For example, 17.65 x 1.5=26.475. The template will display and hold 26.48, not 26.475. There is no need to use Excel’s rounding function. 5. Remember to save your work. When saving your workbook, Excel overwrites the previous copy of your file. You can save your work at any time. You can save the file to the current name, or you may want to keep multiple versions of your work by saving each successive version under a different name. To save to the current name, you can select File, Save from the menu bar or click on the disk icon in the standard toolbar. It is recommended that you save the file to a new name that identifies the file as yours, such as Chapter_7_long_version_Your_Name.xlsx To save under a different name, follow these steps: Select File, Save As to display the Save As Type drop-box, chose Excel Workbook (*.xlsx) Select the folder in which to store the workbook. Enter the new filename in the File name box. Click Save. Page 41 JOURNAL DATE 20– Oct. DESCRIPTION 9 Payroll Cash Cash POST. REF. DEBIT 12 11 12.044,51 9 Administrative Salaries Office Salaries Sales Salaries Plant Wages FICA Taxes Payable – OASDI FICA Taxes Payable – HI Employees FIT Payable Employees SIT Payable Employees SUTA Payable Employees CIT Payable Union Dues Payable Payroll Cash 51 52 53 54 20,1 20,2 24 25 25,1 26 28 12 2.307,69 4.651,08 3.600,00 4.898,00 9 Payroll Taxes FICA Taxes Payable – OASDI FICA Taxes Payable – HI FUTA Taxes Payable SUTA Taxes Payable – Employer 56 20,1 20,2 21 22 1.381,11 CREDIT 12.044,51 958,33 224,14 1.124,00 474,55 10,85 604,39 16,00 12.044,51 958,32 224,12 22,91 175,76 Page 42 JOURNAL DATE 20– DESCRIPTION POST. REF. DEBIT CREDIT Page 43 JOURNAL DATE 20– DESCRIPTION POST. REF. DEBIT CREDIT Page 44 JOURNAL DATE 20– DESCRIPTION POST. REF. DEBIT CREDIT Page 45 JOURNAL DATE 20– DESCRIPTION POST. REF. DEBIT CREDIT Page 46 JOURNAL DATE 20– DESCRIPTION POST. REF. DEBIT CREDIT Page 47 JOURNAL DATE 20– DESCRIPTION POST. REF. DEBIT CREDIT Page 48 JOURNAL DATE 20– DESCRIPTION POST. REF. DEBIT CREDIT Page 49 JOURNAL DATE 20– DESCRIPTION POST. REF. DEBIT CREDIT Page 50 JOURNAL DATE 20– DESCRIPTION POST. REF. DEBIT CREDIT Total debits and credits (calculated automatically): 28.882,39 28.882,39 Your debits and credits should be equal after each journal entry is complete Cumulative Journal Checkpoint Through Month Ending October 31, 20-November 30, 20– December 31, 20-January 31, 20– GENERAL LEDGER Checkpoints ACCOUNT: ACCOUNT NO. 11 CASH DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT 20– Oct. 1 Balance 9 a J41 199.846,33 12.044,51 187.801,82 CREDIT Debit Balance Oct. 31, 20-Nov. 30, 20-Dec. 31, 20– Credit Balance ACCOUNT: ACCOUNT NO. 12 PAYROLL CASH DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT 20– Oct. 9 9 J41 J41 Checkpoints Debit Balance 12.044,51 12.044,51 12.044,51 0,00 CREDIT Oct. 31, 20-Nov. 30, 20-Dec. 31, 20– Credit Balance ACCOUNT: ACCOUNT NO. 20.1 FICA TAXES PAYABLE – OASDI DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT CREDIT 20– Oct. 9 9 J41 J41 Checkpoints Debit Balance 958,33 958,32 958,33 1.916,65 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20– Credit Balance ACCOUNT: ACCOUNT NO. 20.2 FICA TAXES PAYABLE – HI DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT CREDIT 20– Oct. 9 9 J41 J41 Checkpoints Debit Balance 224,14 224,12 224,14 448,26 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20– Credit Balance ACCOUNT: ACCOUNT NO. 21 FUTA TAXES PAYABLE DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT CREDIT 20– Oct. 1 Balance 9 a J41 Checkpoints Debit Balance 22,91 392,94 415,85 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20– Credit Balance ACCOUNT: ACCOUNT NO. 22 SUTA TAXES PAYABLE – EMPLOYER DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT CREDIT 20– Oct. 9 J41 Checkpoints Debit Balance 175,76 175,76 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20– Credit Balance ACCOUNT: ACCOUNT NO. 24 EMPLOYEES FIT PAYABLE DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT CREDIT 20– Oct. 9 J41 Checkpoints Debit Balance 1.124,00 1.124,00 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20– Credit Balance ACCOUNT: ACCOUNT NO. 25 EMPLOYEES SIT PAYABLE DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT CREDIT 20– Oct. 9 J41 Checkpoints Debit Balance 474,55 474,55 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20– Credit Balance ACCOUNT: ACCOUNT NO. 25.1 EMPLOYEES SUTA PAYABLE DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT CREDIT 20– Oct. 9 J41 Checkpoints Debit Balance 10,85 10,85 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20– Credit Balance ACCOUNT: ACCOUNT NO. 26 EMPLOYEES CIT PAYABLE DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT CREDIT 20– Oct. 9 J41 Checkpoints Debit Balance 604,39 604,39 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20– Credit Balance ACCOUNT: DATE 20– ACCOUNT NO. 27 GROUP INSURANCE PREMIUMS COLLECTED ITEM POST. REF. Checkpoints Debit Balance BALANCE DEBIT CREDIT DEBIT CREDIT Oct. 31, 20-Nov. 30, 20-Dec. 31, 20– Credit Balance ACCOUNT: ACCOUNT NO. 28 UNION DUES PAYABLE DATE ITEM POST. REF. Checkpoints Debit Balance BALANCE DEBIT CREDIT DEBIT CREDIT 20– Oct. 9 J41 16,00 16,00 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20– Credit Balance ACCOUNT: DATE 20– ACCOUNT NO. 29 SIMPLE CONTRIBUTIONS PAYABLE ITEM POST. REF. Checkpoints Debit Balance BALANCE DEBIT CREDIT DEBIT CREDIT Oct. 31, 20-Nov. 30, 20-Dec. 31, 20– Credit Balance ACCOUNT: ACCOUNT NO. 51 ADMINISTRATIVE SALARIES DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT 20– Oct. 1 Balance 9 a J41 Checkpoints Debit Balance 2.307,69 42.692,27 44.999,96 CREDIT Oct. 31, 20-Nov. 30, 20-Dec. 31, 20– Credit Balance ACCOUNT: ACCOUNT NO. 52 OFFICE SALARIES DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT 20– Oct. 1 Balance 9 a J41 Checkpoints Debit Balance 4.651,08 28.350,00 33.001,08 CREDIT Oct. 31, 20-Nov. 30, 20-Dec. 31, 20– Credit Balance ACCOUNT: ACCOUNT NO. 53 SALES SALARIES DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT 20– Oct. 1 Balance 9 a J41 Checkpoints Debit Balance 3.600,00 28.525,00 32.125,00 CREDIT Oct. 31, 20-Nov. 30, 20-Dec. 31, 20– Credit Balance ACCOUNT: ACCOUNT NO. 54 PLANT WAGES DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT 20– Oct. 1 Balance 9 a J41 Checkpoints Debit Balance 4.898,00 42.657,30 47.555,30 CREDIT Oct. 31, 20-Nov. 30, 20-Dec. 31, 20– Credit Balance ACCOUNT: ACCOUNT NO. 56 PAYROLL TAXES DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT 20– Oct. 1 Balance 9 a J41 Checkpoints Debit Balance 1.381,11 14.233,94 15.615,05 CREDIT Oct. 31, 20-Nov. 30, 20-Dec. 31, 20– Credit Balance Payday, October 9, 20-Bonno, A. Ferguson, J. Ford, C. Mann, D. O’Neill, J. Russell, V. Ryan, N. Sokowski, T. (Student) Williams, R. No. W/H Allow. NAME Marital Status PAYROLL REGISTER Time Record S M T W T 8 8 8 8 8 8 8 8 8 8 TOTALS Payday, October 23, 20– For Period Ending October 17, 20-Bonno, A. Ferguson, J. Ford, C. Mann, D. O’Neill, J. Russell, V. Ryan, N. Sokowski, T. (Student) Williams, R. TOTALS Payday, November 6, 20– For Period Ending October 31, 20-Bonno, A. Ferguson, J. Ford, C. Mann, D. O’Neill, J. Russell, V. Ryan, N. Sokowski, T. (Student) Williams, R. TOTALS Payday, November 13, 20– For Period Ending November 14, 20-Williams, R. TOTALS Regular Earnings Rate Per F S S M T W T F S Hrs. Hour For Period Ending October 3, 20-M 4 8 8 8 8 8 M 5 8 8 8 8 8 S 2 8 8 8 8 8 M 4 8 8 8 8 8 M 3 8 8 8 8 8 S 1 8 8 8 8 8 M 4 8 8 8 8 8 M 2 8 8 8 8 8 S 1 8 8 8 8 4 S 0 8 8 D 8 8 GLO-BRITE PAINT COMPANY 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 4 8 80 17,60 80 80 80 80 80 80 18,00 80 72 14,00 80 Amount Overtime Earnings Rate Per Hrs. Hour Amount Deductions Total Earnings OASDI HI FIT SIT SUTA 1.408,00 2.250,00 1.220,00 1.350,00 2.307,69 1.200,00 1.440,00 2.050,00 1.008,00 1.223,08 1.408,00 2.250,00 1.220,00 1.350,00 2.307,69 1.200,00 1.440,00 2.050,00 1.008,00 1.223,08 87,30 139,50 75,64 83,70 143,08 74,40 89,28 127,10 62,50 75,83 20,42 32,63 17,69 19,58 33,46 17,40 20,88 29,73 14,62 17,73 46,00 136,00 107,00 40,00 191,00 127,00 50,00 176,00 97,00 154,00 43,23 69,08 37,45 41,45 70,85 36,84 44,21 62,94 30,95 37,55 0,99 1,58 0,85 0,95 1,62 0,84 1,01 1,44 0,71 0,86 15.456,77 15.456,77 958,33 224,14 1.124,00 474,55 10,85 No. W/H Allow. NAME Marital Status PAYROLL REGISTER Time Record S M T W T TOTALS Payday, December 4, 20– For Period Ending November 28, 20-Bonno, A. Ferguson, J. Ford, C. Mann, D. O’Neill, J. Russell, V. Ryan, N. Sokowski, T. (Student) Woods, B. TOTALS Payday, December 14, 20– For Period Ending December 12, 20-Russell, V. TOTALS Payday, December 18, 20– For Period Ending December 12, 20-Bonno, A. Ferguson, J. Ford, C. Mann, D. O’Neill, J. Ryan, N. Sokowski, T. (Student) Woods, B. Young, P. TOTALS Regular Earnings Rate Per F S S M T W T F S Hrs. Hour Payday, November 20, 20– For Period Ending November 14, 20-Bonno, A. Ferguson, J. Ford, C. Mann, D. O’Neill, J. Russell, V. Ryan, N. Sokowski, T. (Student) GLO-BRITE PAINT COMPANY Amount Overtime Earnings Rate Per Hrs. Hour Amount Deductions Total Earnings OASDI HI FIT SIT SUTA Deductions NAME Payday, October 9, 20-Bonno, A. Ferguson, J. Ford, C. Mann, D. O’Neill, J. Russell, V. Ryan, N. Sokowski, T. (Student) Williams, R. TOTALS Net Paid CIT Group Ins. Union Dues Ck. SIMPLE No. For Period Ending October 3, 20-55,06 8,00 87,98 47,70 52,79 90,24 46,92 56,31 8,00 80,16 39,41 47,82 604,39 0,00 16,00 0,00 Payday, October 23, 20– For Period Ending October 17, 20-Bonno, A. Ferguson, J. Ford, C. Mann, D. O’Neill, J. Russell, V. Ryan, N. Sokowski, T. (Student) Williams, R. Taxable Earnings Amount OASDI HI 1.147,00 1.783,23 933,67 1.111,53 1.777,44 896,60 1.170,31 1.572,63 762,81 889,29 1.408,00 2.250,00 1.220,00 1.350,00 2.307,69 1.200,00 1.440,00 2.050,00 1.008,00 1.223,08 1.408,00 2.250,00 1.220,00 1.350,00 2.307,69 1.200,00 1.440,00 2.050,00 1.008,00 1.223,08 12.044,51 15.456,77 15.456,77 FUTA Labor Cost Distribution SUTA Admin. Office Sales Plant Checkpoints 672 673 674 675 676 677 678 679 680 681 1.408,00 2.250,00 700,00 1.350,00 1.220,00 1.350,00 Total earnings Net paid 1.220,00 1.350,00 2.307,69 760,00 1.200,00 1.200,00 1.440,00 2.050,00 1.008,00 1.008,00 3.818,00 4.778,00 1.008,00 1.223,08 2.307,69 4.651,08 3.600,00 4.898,00 Checkpoints Total earnings Net paid TOTALS Payday, November 6, 20– For Period Ending October 31, 20-Bonno, A. Ferguson, J. Ford, C. Mann, D. O’Neill, J. Russell, V. Ryan, N. Sokowski, T. (Student) Williams, R. Checkpoints Total earnings Net paid TOTALS Payday, November 13, 20– For Period Ending November 14, 20-Williams, R. TOTALS Checkpoints Total earnings Net paid 15.456,77 12.044,51 Deductions NAME Net Paid CIT Group Ins. Union Dues Ck. SIMPLE No. October 9, 20, 20–20–For 3, 20-Payday, November ForPeriod PeriodEnding EndingOctober November 14, 20-Bonno, A. Ferguson, J. Ford, C. Mann, D. O’Neill, J. Russell, V. Ryan, N. Sokowski, T. (Student) Amount Taxable Earnings OASDI HI FUTA Labor Cost Distribution SUTA Admin. Office Sales Plant Checkpoints Total earnings Net paid TOTALS Payday, December 4, 20– For Period Ending November 28, 20-Bonno, A. Ferguson, J. Ford, C. Mann, D. O’Neill, J. Russell, V. Ryan, N. Sokowski, T. (Student) Woods, B. Checkpoints Total earnings Net paid TOTALS Payday, December 14, 20– For Period Ending December 12, 20-Russell, V. Checkpoints Total earnings Net paid TOTALS Payday, December 18, 20– For Period Ending December 12, 20-Bonno, A. Ferguson, J. Ford, C. Mann, D. O’Neill, J. Ryan, N. Sokowski, T. (Student) Woods, B. Young, P. TOTALS Checkpoints Total earnings Net paid DEPARTMENT OCCUPATION WORKS IN (STATE) Plant Mixer Operator PA SEX M F x S.S. ACCOUNT NO. 000-00-3481 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE NAME – LAST FIRST BONNO Anthony $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $55,000 –$.30/M 20___ PAYDAY HRS. RATE YEAR-TO-DATE 1 10/9 2 10/23 3 11/6 4 11/20 5 12/4 6 12/18 $8 each pay REGULAR EARNINGS 80 17,60 AMOUNT OVERTIME EARNINGS HRS. RATE 10.293,40 1.408,00 OVERTIME RATE CUMULATIVE EARNINGS AMOUNT 1.028,60 0.00 0.00 0.00 0.00 0.00 0.00 11.322,00 12.730,00 MIDDLE Victor 17,60 26,40 W/H MARITAL ALLOW. STATUS 4 M DEDUCTIONS FICA OASDI 701,96 87,30 HI 164,17 20,42 FIT SIT 810,00 46,00 347,59 43,23 NET PAID SUTA CIT 7,93 0,99 SIMPLE 442,71 55,06 OTHER CK. DEDUCTIONS NO. 216,80 8,00 AMOUNT 8.630,84 1.147,00 672 QTR. TOT. YR. TOT. Checkpoint Checkpoint DEPARTMENT OCCUPATION WORKS IN (STATE) Sales Sales Manager PA SEX M F x S.S. ACCOUNT NO. 000-00-8645 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE NAME – LAST FIRST FERGUSON $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $88,000 — $.30/M 20___ REGULAR EARNINGS OVERTIME RATE OVERTIME EARNINGS PAYDAY EARNINGS HRS. YEAR-TO-DATE 1 10/9 2 10/23 3 11/6 4 11/20 5 12/4 6 12/18 CUMULATIVE 80 RATE AMOUNT HRS. RATE 23.125,00 2.250,00 23.125,00 25.375,00 James 58.500 /yr. 1.125,00 28,13 MARITAL ALLOW. STATUS 5 M NET PAID FICA 1.433,75 139,50 OTHER HI 335,31 32,63 FIT 2.291,00 136,00 SIT SUTA 709,94 69,08 QTR. TOT. YR. TOT. Checkpoint Claude W/H DEDUCTIONS OASDI AMOUNT MIDDLE Checkpoint 16,19 1,58 CIT 904,23 87,98 SIMPLE CK. DEDUCTIONS NO. AMOUNT 132,30 673 17.302,28 1.783,23 OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME – LAST FIRST MIDDLE M F Office Executive Secretary x PA 000-00-4567 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE FORD $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $48,000–$.30/M 20___ OVERTIME RATE REGULAR EARNINGS OVERTIME EARNINGS PAYDAY EARNINGS HRS. RATE AMOUNT 10/9 2 10/23 3 11/6 4 11/20 5 12/4 6 12/18 HRS. RATE 80 6.300,00 7.520,00 Louise W/H MARITAL ALLOW. STATUS 2 S DEDUCTIONS NET PAID FICA OASDI AMOUNT 6.300,00 1.220,00 YEAR-TO-DATE 1 CUMULATIVE Catherine 2.643,33 /mo. 610,00 15,25 22,88 390,60 75,64 OTHER HI FIT SIT 91,35 17,69 639,00 107,00 193,41 37,45 SUTA 4,41 0,85 CIT SIMPLE 246,34 47,70 CK. DEDUCTIONS NO. AMOUNT 37,80 4.697,09 933,67 674 QTR. TOT. YR. TOT. Checkpoint Checkpoint OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME – LAST FIRST MIDDLE M F Sales Sales Representative x PA 000-00-9352 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE MANN $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $53,000 — $.30/M 20___ OVERTIME RATE REGULAR EARNINGS OVERTIME EARNINGS PAYDAY EARNINGS HRS. YEAR-TO-DATE 1 10/9 2 10/23 3 11/6 4 11/20 5 12/4 6 12/18 CUMULATIVE 80 RATE AMOUNT HRS. RATE 5.400,00 1.350,00 5.400,00 6.750,00 Wilson MARITAL ALLOW. STATUS 4 M NET PAID FICA 334,80 83,70 OTHER HI FIT SIT 78,30 19,58 332,00 40,00 165,78 41,45 SUTA 3,78 0,95 CIT SIMPLE 211,15 52,79 TR. TOT. YR. TOT. Checkpoint W/H DEDUCTIONS OASDI AMOUNT Dewey 2.925 /mo. 675,00 16,88 Checkpoint CK. DEDUCTIONS NO. AMOUNT 31,50 675 4.242,69 1.111,53 OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME – LAST FIRST President x PA 000-00-1534 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE O’NEILL $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $90,000 — $.30/M 20___ OVERTIME RATE REGULAR EARNINGS OVERTIME EARNINGS PAYDAY RATE 2 10/23 3 11/6 4 11/20 5 12/4 6 12/18 AMOUNT HRS. RATE 80 42.692,27 44.999,96 Joseph 60.000 /yr. 1.153,85 28,85 Tyler W/H MARITAL ALLOW. STATUS 3 M DEDUCTIONS NET PAID FICA OASDI AMOUNT 42.692,27 2.307,69 YEAR-TO-DATE 10/9 CUMULATIVE EARNINGS HRS. 1 MIDDLE M F Administrative 2.646,92 143,08 OTHER HI 619,04 33,46 FIT 6.116,00 191,00 SIT SUTA 1.310,65 70,85 29,88 1,62 CIT SIMPLE 1.669,35 90,24 CK. DEDUCTIONS NO. AMOUNT 202,50 676 30.097,93 1.777,44 TR. TOT. YR. TOT. Checkpoint Checkpoint OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME – LAST FIRST MIDDLE M F Office Time Clerk x PA 000-00-6337 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE RUSSELL $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $47,000 — $.30/M 20___ OVERTIME RATE REGULAR EARNINGS OVERTIME EARNINGS PAYDAY EARNINGS HRS. YEAR-TO-DATE 1 10/9 2 10/23 3 11/6 4 11/20 5 12/4 6 12/14 CUMULATIVE 80 RATE AMOUNT HRS. RATE 6.240,00 1.200,00 6.240,00 7.440,00 Aloise MARITAL ALLOW. STATUS 1 S NET PAID FICA 386,88 74,40 OTHER HI FIT SIT 90,48 17,40 642,00 127,00 191,56 36,84 SUTA 4,37 0,84 CIT SIMPLE 244,00 46,92 TR. TOT. YR. TOT. Checkpoint W/H DEDUCTIONS OASDI AMOUNT Virginia 2.600 /mo. 600,00 15,00 22,50 Checkpoint CK. DEDUCTIONS NO. AMOUNT 31,50 677 4.649,21 896,60 OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME – LAST FIRST MIDDLE M F Plant Electrician x PA 000-00-1223 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE RYAN Norman $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $56,000 — $.30/M 20___ $8 each pay REGULAR EARNINGS OVERTIME EARNINGS PAYDAY EARNINGS HRS. RATE YEAR-TO-DATE 1 10/9 2 10/23 3 11/6 4 11/20 5 12/4 6 12/18 OVERTIME RATE CUMULATIVE 80 18,00 AMOUNT HRS. RATE 13.287,50 1.440,00 1.397,80 0.00 0.00 0.00 0.00 0.00 0.00 14.685,30 16.125,30 18,00 27,00 MARITAL ALLOW. STATUS 4 M DEDUCTIONS NET PAID FICA OASDI AMOUNT Allen W/H 910,49 89,28 OTHER HI 212,94 20,88 FIT 1.070,00 50,00 SIT SUTA 450,84 44,21 10,28 1,01 CIT SIMPLE 574,22 56,31 CK. DEDUCTIONS NO. 235,70 8,00 AMOUNT 678 11.220,83 1.170,31 QTR. TOT. YR. TOT. Checkpoint Checkpoint OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME – LAST FIRST MIDDLE M F Plant Supervisor x PA 000-00-8832 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE SOKOWSKI Thomas $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $80,000 — $.30/M 20___ REGULAR EARNINGS OVERTIME RATE OVERTIME EARNINGS PAYDAY EARNINGS HRS. YEAR-TO-DATE 1 10/9 2 10/23 3 11/6 4 11/20 5 12/4 6 12/18 CUMULATIVE 80 RATE AMOUNT HRS. RATE 16.650,00 2.050,00 16.650,00 18.700,00 1.025,00 25,63 STATUS 2 M NET PAID FICA 1.032,30 127,10 OTHER HI 241,43 29,73 FIT 2.002,00 176,00 SIT 511,16 62,94 SUTA 11,66 1,44 CIT SIMPLE 651,05 80,16 QTR. TOT. YR. TOT. Checkpoint MARITAL ALLOW. DEDUCTIONS OASDI AMOUNT James W/H Checkpoint CK. DEDUCTIONS NO. AMOUNT 94,50 679 12.105,90 1.572,63 OCCUPATION …