Can i get the rest of this payroll problem done? I already have all of the hours filled out, I just need the FIT taxes put in and i have the accounts all set up but i do not have the numbers for them. Also, the Journal needs to be done as well. This is the new 2017 version.

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 20 Employees SIT Payable Cash 25 11 474.55 23 Payroll Cash Cash 12 11 12,107.67 474.55 12,107.67 Page 42 JOURNAL DATE 20-- Oct. Nov. DESCRIPTION POST. REF. DEBIT 23 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 Group Insurance Premiums Collected Union Dues Payable Payroll Cash 51 52 53 54 20.1 20.2 24 25 25.1 26 27 28 12 2,307.69 4,651.08 3,600.00 5,219.60 23 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,386.96 CREDIT 978.26 228.80 1,154.00 484.42 11.07 616.95 181.20 16.00 12,107.67 978.26 228.79 4.15 175.76 4 Employees SIT Payable Cash 25 11 484.42 6 Union Dues Payable Cash 28 11 32.00 484.42 32.00 Page 43 JOURNAL DATE 20-- Nov. DESCRIPTION 6 Payroll Cash Cash POST. REF. DEBIT 12 11 11,885.91 6 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,605.85 3,600.00 4,898.00 6 Payroll Taxes FICA Taxes Payable - OASDI FICA Taxes Payable - HI SUTA Taxes Payable - Employer 56 20.1 20.2 22 1,325.32 12 11 1,426.24 13 Payroll Cash Cash CREDIT 11,885.91 955.53 223.49 1,244.00 473.16 10.82 602.63 16.00 11,885.91 955.52 223.47 146.33 1,426.24 Page 44 JOURNAL DATE 20-- Nov. DESCRIPTION POST. REF. DEBIT 13 Office Salaries FICA Taxes Payable - OASDI FICA Taxes Payable - HI Employees FIT Payable Employees SIT Payable Employees SUTA Payable Employees CIT Payable Group Insurance Premiums Collected Payroll Cash 52 20.1 20.2 24 25 25.1 26 27 12 2,079.32 13 Payroll Taxes FICA Taxes Payable - OASDI FICA Taxes Payable - HI 56 20.1 20.2 159.07 16 FICA Taxes Payabe-OASDI FICA Taxes Payable-HI Employee FIT Payable Cash 20.1 20.2 24 11 3,873.17 905.85 2,278.00 16 Employee CIT Payable Cash 26 11 1,221.34 18 Employees SIT Payable Cash 25 11 537.00 20 Payroll Cash Cash 12 11 9,210.64 51 52 53 54 20.1 20.2 24 25 25.1 26 27 28 29 12 2,307.69 3,398.00 3,600.00 4,616.40 20 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 Employees SUTA Payable Union Dues Payable SIMPLE Contributions Payable Payroll Cash CREDIT 128.92 30.15 333.00 63.84 1.46 81.31 14.40 1,426.24 128.92 30.15 7,057.02 1,221.34 537.00 9,210.64 863.18 201.89 832.00 427.43 9.77 544.38 166.80 16.00 1,650.00 9,210.64 Page 45 JOURNAL DATE 20-- Nov. 20Dec. DESCRIPTION 20 Payroll Taxes FICA Taxes Payable - OASDI FICA Taxes Payable - HI SUTA Taxes Payable - Employer 3 Employee SIT Payable Cash 4 Payroll Cash Cash 4 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 Group Insurance Premiums Collected Union Dues Payable SIMPLE Contributions Payable Payroll Cash POST. REF. 56 20.1 20.2 22 DEBIT CREDIT 1,100.94 863.17 201.87 35.90 Page 46 JOURNAL DATE 20-- Dec. DESCRIPTION 4 Payroll Taxes FICA Taxes Payable - OASDI FICA Taxes Payable - HI FUTA Taxes Payable SUTA Taxes Payable - Employer 9 Union Dues Payable Cash 14 Payroll Cash Cash 14 Office Salries Exepense FICA Taxes Payable - OASDI FICA Taxes Payable - HI Employees SUTA Payable Employees SUTA Payable Payroll Cash 14 Payroll Taxes FICA Taxes Payable - OASDI FICA Taxes Payable - HI 15 Employees FIT Payable FICA Taxes Payable - OASDI FICA Taxes Payable - HI Cash 15 Employees SIT Payable Cash 18 Employees SIT Payable Cash 18 Group Insurance Premium Collected Cash 18 Payroll Cash Cash 18 Administrative Salaries Office Salaries POST. REF. DEBIT CREDIT Page 47 JOURNAL DATE 20-- DESCRIPTION POST. REF. DEBIT CREDIT Sales Salaries Plant Wages FICA Taxes Payable - OASDI FICA Taxes Payable - HI Employees FIT Payable Employees SIT Payable Employees SUTA Payable Employees CIT Payable Employees SUTA Payable Union Dues Payable SIMPLE Contributions Payable Payroll Cash 18 Payroll Taxes FICA Taxes Payable - OASDI FICA Taxes Payable - HI SUTA Taxes Payable - Employer FUTA Taxes Payable Jan - 6 Employee SIT Payable Cash 8 Union Dues Payable Cash 15 FICA Taxes Payable - OASDI FICA Taxes Payable - HI SUTA Taxes Payable - Employer Cash 15 Employee SIT Payable Cash ### ### ### ### Page 48 JOURNAL DATE 20-- DESCRIPTION Feb 1 FUTA Taxes Payable Cash 1 SUTA Taxes Payable - Employer Employees SUTA Payable Cash POST. REF. DEBIT CREDIT GENERAL LEDGER ACCOUNT: Checkpoints CASH ACCOUNT NO. 11 BALANCE POST. DATE ITEM REF. DEBIT CREDIT DEBIT 20-- Oct. Nov. 1 Balance 9 20 23 4 6 6 13 16 16 16 20 a J41 J41 J41 J42 J42 J43 J43 J44 J44 J44 J44 12,044.51 474.55 12,107.67 484.42 32.00 11,885.91 1,426.24 7,057.02 1,221.34 537.00 9,210.64 199,846.33 187,801.82 187,327.27 175,219.60 174,735.18 174,703.18 162,817.27 161,391.03 154,334.01 153,112.67 152,575.67 143,365.03 CREDIT Debit Credit Balance Balance Oct. 31, 20-- 175,219.60 Nov. 30, 20-- 143,365.03 Dec. 31, 20-- ACCOUNT: PAYROLL CASH ACCOUNT NO. 12 BALANCE POST. DATE ITEM REF. DEBIT J41 J41 J41 J42 J43 J43 J43 J44 J44 J44 12,044.51 CREDIT DEBIT 20-- Oct. Nov. 9 9 23 23 6 6 13 13 20 20 12,044.51 12,107.67 12,107.67 11,885.91 11,885.91 1,426.24 1,426.24 9,210.64 9,210.64 12,044.51 0.00 12,107.67 0.00 11,885.91 0.00 1,426.24 0.00 9,210.64 0.00 CREDIT Checkpoints Debit Credit Balance Balance Oct. 31, 20-0.00 Nov. 30, 20-0.00 Dec. 31, 20-- ACCOUNT: FICA TAXES PAYABLE - OASDI ACCOUNT NO. 20.1 BALANCE POST. DATE ITEM REF. DEBIT CREDIT 20-- Oct. Nov. 9 9 23 23 6 6 13 13 16 20 20 J41 J41 J42 J42 J43 J43 J44 J44 J44 J44 J45 958.33 958.32 978.26 978.26 955.53 955.52 128.92 128.92 3,873.17 863.18 863.17 DEBIT CREDIT Oct. 31, 20-Nov. 30, 20-958.33 Dec. 31, 20-1,916.65 2,894.91 3,873.17 4,828.70 5,784.22 5,913.14 6,042.06 2,168.89 3,032.07 3,895.24 Checkpoints Debit Balance Credit Balance 3,873.17 3,895.24 ACCOUNT: FICA TAXES PAYABLE - HI ACCOUNT NO. 20.2 BALANCE POST. DATE ITEM REF. DEBIT CREDIT 20-- Oct. Nov. 9 9 23 23 6 6 13 13 16 20 20 J41 J41 J42 J42 J43 J43 J44 J44 J44 J44 J45 224.14 224.12 228.80 228.79 223.49 223.47 30.15 30.15 905.85 201.89 201.87 DEBIT CREDIT Oct. 31, 20-Nov. 30, 20-224.14 Dec. 31, 20-448.26 677.06 905.85 1,129.34 1,352.81 1,382.96 1,413.11 507.26 709.15 911.02 Checkpoints Debit Balance Credit Balance 905.85 911.02 ACCOUNT: FUTA TAXES PAYABLE ACCOUNT NO. 21 BALANCE POST. DATE ITEM REF. DEBIT CREDIT 20-- Oct. 1 Balance 9 23 a J41 J42 22.91 4.15 DEBIT CREDIT Oct. 31, 20-Nov. 30, 20-392.94 Dec. 31, 20-415.85 420.00 Checkpoints Debit Balance Credit Balance 420.00 420.00 ACCOUNT: SUTA TAXES PAYABLE - EMPLOYER ACCOUNT NO. 22 BALANCE POST. DATE ITEM REF. DEBIT CREDIT 20-- Oct. Nov. 9 23 6 20 J41 J42 J43 J45 175.76 175.76 146.33 35.90 DEBIT CREDIT Oct. 31, 20-Nov. 30, 20-175.76 Dec. 31, 20-351.52 497.85 533.75 Checkpoints Debit Balance Credit Balance 351.52 533.75 ACCOUNT: EMPLOYEES FIT PAYABLE ACCOUNT NO. 24 BALANCE POST. DATE ITEM REF. DEBIT CREDIT 20-- Oct. Nov. 9 23 6 13 16 20 J41 J42 J43 J44 J44 J44 1,124.00 1,154.00 1,244.00 333.00 2,278.00 832.00 DEBIT CREDIT Oct. 31, 20-Nov. 30, 20-1,124.00 Dec. 31, 20-2,278.00 3,522.00 3,855.00 1,577.00 2,409.00 Checkpoints Debit Balance Credit Balance 2,278.00 2,409.00 ACCOUNT: EMPLOYEES SIT PAYABLE ACCOUNT NO. 25 BALANCE POST. DATE ITEM REF. DEBIT CREDIT 20-- Oct. Nov. 9 20 23 4 6 13 18 20 J41 J41 J42 J42 J43 J44 J44 J44 474.55 474.55 484.42 484.42 473.16 63.84 537.00 427.43 DEBIT CREDIT Oct. 31, 20-Nov. 30, 20-474.55 Dec. 31, 20-0.00 484.42 0.00 473.16 537.00 0.00 427.43 Checkpoints Debit Balance Credit Balance 484.42 427.43 ACCOUNT: EMPLOYEES SUTA PAYABLE ACCOUNT NO. 25.1 BALANCE POST. DATE ITEM REF. DEBIT CREDIT 20-- Oct. Nov. 9 23 6 13 20 J41 J42 J43 J44 J44 10.85 11.07 10.82 1.46 9.77 DEBIT Checkpoints Debit Balance CREDIT Oct. 31, 20-Nov. 30, 20-10.85 Dec. 31, 20-21.92 32.74 34.20 43.97 Credit Balance 21.92 43.97 ACCOUNT: EMPLOYEES CIT PAYABLE ACCOUNT NO. 26 BALANCE POST. DATE ITEM REF. DEBIT CREDIT 20-- Oct. Nov. 9 23 6 13 16 20 J41 J42 J43 J44 J44 J44 604.39 616.95 602.63 81.31 1,221.34 544.38 DEBIT CREDIT Oct. 31, 20-Nov. 30, 20-604.39 Dec. 31, 20-1,221.34 1,823.97 1,905.28 683.94 1,228.32 Checkpoints Debit Balance Credit Balance 1,221.34 1,228.32 ACCOUNT: GROUP INSURANCE PREMIUMS COLLECTED ACCOUNT NO. 27 BALANCE POST. DATE ITEM REF. DEBIT CREDIT 20-- Oct. Nov. 23 13 20 J42 J44 J44 181.20 14.40 166.80 DEBIT CREDIT Oct. 31, 20-Nov. 30, 20-181.20 Dec. 31, 20-195.60 362.40 Checkpoints Debit Balance Credit Balance 181.20 362.40 ACCOUNT: UNION DUES PAYABLE ACCOUNT NO. 28 BALANCE POST. DATE ITEM REF. DEBIT CREDIT 20-- Oct. Nov. 9 23 6 6 20 J41 J42 J42 J43 J44 16.00 16.00 32.00 16.00 16.00 DEBIT Checkpoints Debit Balance CREDIT Oct. 31, 20-Nov. 30, 20-16.00 Dec. 31, 20-32.00 0.00 16.00 32.00 Credit Balance 32.00 32.00 ACCOUNT: SIMPLE CONTRIBUTIONS PAYABLE ACCOUNT NO. 29 BALANCE POST. DATE ITEM REF. DEBIT CREDIT 20-- Nov. 20 J44 1,650.00 DEBIT CREDIT Oct. 31, 20-Nov. 30, 20-1,650.00 Dec. 31, 20-- Checkpoints Debit Balance Credit Balance 0.00 1,650.00 ACCOUNT: ADMINISTRATIVE SALARIES ACCOUNT NO. 51 BALANCE POST. DATE ITEM REF. DEBIT CREDIT DEBIT 20-- Oct. Nov. 1 Balance 9 23 6 20 a J41 J42 J43 J44 2,307.69 2,307.69 2,307.69 2,307.69 42,692.27 44,999.96 47,307.65 49,615.34 51,923.03 CREDIT Checkpoints Debit Credit Balance Balance Oct. 31, 20-- 47,307.65 Nov. 30, 20-- 51,923.03 Dec. 31, 20-- ACCOUNT: OFFICE SALARIES ACCOUNT NO. 52 BALANCE POST. DATE ITEM REF. DEBIT CREDIT DEBIT 20-- Oct. Nov. 1 Balance 9 23 6 13 20 a J41 J42 J43 J44 J44 4,651.08 4,651.08 4,605.85 2,079.32 3,398.00 28,350.00 33,001.08 37,652.16 42,258.01 44,337.33 47,735.33 CREDIT Checkpoints Debit Credit Balance Balance Oct. 31, 20-- 37,652.16 Nov. 30, 20-- 47,735.33 Dec. 31, 20-- ACCOUNT: SALES SALARIES ACCOUNT NO. 53 BALANCE POST. DATE ITEM REF. DEBIT CREDIT DEBIT 20-- Oct. Nov. 1 Balance 9 23 6 20 a J41 J42 J43 J44 3,600.00 3,600.00 3,600.00 3,600.00 28,525.00 32,125.00 35,725.00 39,325.00 42,925.00 CREDIT Checkpoints Debit Credit Balance Balance Oct. 31, 20-- 35,725.00 Nov. 30, 20-- 42,925.00 Dec. 31, 20-- ACCOUNT: PLANT WAGES ACCOUNT NO. 54 BALANCE POST. DATE ITEM REF. DEBIT CREDIT DEBIT 20-- Oct. Nov. 1 Balance 9 23 6 20 a J41 J42 J43 J44 4,898.00 5,219.60 4,898.00 4,616.40 42,657.30 47,555.30 52,774.90 57,672.90 62,289.30 CREDIT Checkpoints Debit Credit Balance Balance Oct. 31, 20-- 52,774.90 Nov. 30, 20-- 62,289.30 Dec. 31, 20-- ACCOUNT: PAYROLL TAXES ACCOUNT NO. 56 BALANCE POST. DATE ITEM REF. DEBIT CREDIT DEBIT 20-- Oct. Nov. 1 Balance 9 23 6 13 20 a J41 J42 J43 J44 J45 1,381.11 1,386.96 1,325.32 159.07 1,100.94 14,233.94 15,615.05 17,002.01 18,327.33 18,486.40 19,587.34 CREDIT Checkpoints Debit Credit Balance Balance Oct. 31, 20-- 17,002.01 Nov. 30, 20-- 19,587.34 Dec. 31, 20-- 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 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 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 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 TOTALS Payday, October 23, 20-- For Period Ending October 17, 20-Bonno, A. M 4 8 8 8 8 8 4 Ferguson, J. M 5 8 8 8 8 8 Ford, C. S 2 8 8 8 8 8 Mann, D. M 4 8 8 8 8 8 O'Neill, J. M 3 8 8 8 8 8 Russell, V. S 1 8 8 8 8 8 Ryan, N. M 4 8 8 8 8 8 Sokowski, T. M 2 8 8 8 8 8 (Student) S 1 8 8 8 8 4 Williams, R. S 0 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 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 TOTALS Payday, November 6, 20-- For Period Ending October 31, 20-Bonno, A. M 4 8 8 8 8 8 Ferguson, J. M 5 8 8 8 8 8 8 8 GLO-BRITE PAINT COMP 8 8 8 8 8 8 8 8 80 17.60 80 Amount Overtime Earnings Rate Per Hrs. Hour Amount Total Earnings OASDI 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 15,456.77 15,456.77 958.33 1,513.60 2,250.00 1,220.00 1,350.00 2,307.69 1,200.00 1,656.00 2,050.00 1,008.00 1,223.08 93.84 139.50 75.64 83.70 143.08 74.40 102.67 127.10 62.50 75.83 15,456.77 321.60 15,778.37 978.26 1,408.00 2,250.00 1,408.00 2,250.00 87.30 139.50 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 4 26.40 105.60 8 27.00 216.00 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 S M M S M S S S 2 0 3 2 4 2 1 0 Time Record S M 8 8 8 8 8 8 8 8 T W T 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 7 F S S M 8 8 8 8 8 8 6 8 8 8 8 8 4 8 8 8 Regular Earnings T W T 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 Rate Per F S Hrs. Hour 8 80 8 80 8 80 8 78 8 80 18.00 8 80 4 72 14.00 8 79 TOTALS Payday, November 13, 20-- For Period Ending November 14, 20-Williams, R. S 0 6 8 7 7 6 D D 8 TOTALS GLO-BRITE PAINT COMP 6 8 136 Overtime Earnings Rate Per Hrs. Hour Total Earnings 1,220.00 1,350.00 2,307.69 1,170.00 1,440.00 2,050.00 1,008.00 1,207.85 OASDI 75.64 83.70 143.08 72.54 89.28 127.10 62.50 74.89 15,411.54 15,411.54 955.53 2,079.32 2,079.32 128.92 2,079.32 2,079.32 128.92 Amount 1,220.00 1,350.00 2,307.69 1,170.00 1,440.00 2,050.00 1,008.00 1,207.85 Amount No. W/H Allow. NAME Marital Status PAYROLL REGISTER Time Record S M T W T 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. M 4 8 8 8 8 8 Ferguson, J. M 5 8 8 8 8 8 8 Ford, C. S 2 8 8 8 8 8 8 Mann, D. M 0 8 8 8 8 8 8 O'Neill, J. M 3 8 8 8 8 8 8 Russell, V. S 2 6 8 8 8 8 8 Ryan, N. M 4 8 8 8 8 8 8 Sokowski, T. S 2 8 8 8 8 8 8 (Student) S 1 8 8 8 8 4 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 64 17.60 80 80 80 80 78 80 18.00 80 72 14.00 TOTALS Payday, December 4, 20-- For Period Ending November 28, 20-Bonno, A. M 4 8 8 8 8 8 8 8 8 8 Ferguson, J. M 5 8 8 8 8 8 8 8 8 Ford, C. S 2 8 8 8 8 8 8 8 8 Mann, D. M 0 8 8 8 8 8 8 8 8 O'Neill, J. M 3 8 8 8 8 8 8 8 8 Russell, V. S 2 8 8 8 8 8 8 8 8 Ryan, N. M 4 8 8 8 4 8 9 10 8 Sokowski, T. S 2 8 8 8 8 8 8 8 8 (Student) S 1 8 8 8 4 8 8 8 8 Woods, B. S 1 0 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 76 18.00 80 72 14.00 72 TOTALS Payday, December 14, 20-- For Period Ending December 12, 20-Russell, V. S 2 8 8 8 8 8 8 TOTALS GLO-BRITE PAINT COMP 8 8 8 72 Amount Overtime Earnings Rate Per Hrs. Hour Amount Total Earnings OASDI 1,126.40 2,250.00 1,220.00 1,350.00 2,307.69 1,170.00 1,440.00 2,050.00 1,008.00 1,126.40 2,250.00 1,220.00 1,350.00 2,307.69 1,170.00 1,440.00 2,050.00 1,008.00 69.84 139.50 75.64 83.70 143.08 72.54 89.28 127.10 62.50 13,922.09 13,922.09 863.18 1,619.20 2,250.00 1,280.00 1,350.00 2,307.69 1,260.00 1,449.00 2,050.00 1,008.00 1,200.00 100.39 139.50 79.36 83.70 143.08 78.12 89.84 127.10 62.50 74.40 15,481.69 292.20 15,773.89 977.99 1,134.00 1,134.00 70.31 1,134.00 1,134.00 70.31 1,408.00 2,250.00 1,280.00 1,350.00 2,307.69 1,260.00 1,368.00 2,050.00 1,008.00 1,200.00 8 26.40 211.20 3 27.00 81.00 No. W/H Allow. NAME Marital Status PAYROLL REGISTER Time Record S M T W T Regular Earnings Rate Per F S S M T W T F S Hrs. Hour Payday, December 18, 20-- For Period Ending December 12, 20-Bonno, A. M 4 4 8 8 8 8 8 8 8 Ferguson, J. M 5 8 8 8 8 8 8 Ford, C. S 2 8 8 8 8 8 4 Mann, D. M 0 8 8 8 8 8 8 O'Neill, J. M 3 8 8 8 8 8 8 Ryan, N. M 4 8 9 9 9 9 10 Sokowski, T. S 2 8 8 8 8 8 8 (Student) S 1 8 8 7 8 4 4 Woods, B. S 1 8 8 8 8 8 8 Young, P. 8 8 8 8 8 8 TOTALS GLO-BRITE PAINT COMP 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 9 8 8 8 8 8 8 8 8 8 8 8 4 8 8 80 80 76 80 80 80 80 66 80 80 Amount 17.60 1,408.00 2,250.00 1,280.00 1,350.00 77,307.69 18.00 1,440.00 2,050.00 14.00 924.00 1,200.00 15.75 1,260.00 90,469.69 Overtime Earnings Rate Per Hrs. Hour 12 26.40 7 27.00 Amount Total Earnings OASDI 316.80 1,724.80 2,250.00 1,280.00 1,350.00 77,307.69 189.00 1,629.00 2,050.00 924.00 1,200.00 1,260.00 106.94 139.50 79.36 83.70 3,984.68 101.00 127.10 57.29 74.40 78.12 505.80 90,975.49 4,832.09 GLO-BRITE PAINT COMPANY 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 HI FIT SIT For Period Ending October 3, 20-20.42 46.00 43.23 32.63 136.00 69.08 17.69 107.00 37.45 19.58 40.00 41.45 33.46 191.00 70.85 17.40 127.00 36.84 20.88 50.00 44.21 29.73 176.00 62.94 14.62 97.00 30.95 17.73 154.00 37.55 224.14 1,124.00 474.55 Payday, October 23, 20-- For Period Ending October 17, 20-Bonno, A. 21.95 56.00 46.47 Ferguson, J. 32.63 136.00 69.08 Ford, C. 17.69 107.00 37.45 Mann, D. 19.58 40.00 41.45 O'Neill, J. 33.46 191.00 70.85 Russell, V. 17.40 127.00 36.84 Ryan, N. 24.01 70.00 50.84 Sokowski, T. 29.73 176.00 62.94 (Student) 14.62 97.00 30.95 Williams, R. 17.73 154.00 37.55 TOTALS 228.80 1,154.00 484.42 Payday, November 6, 20-- For Period Ending October 31, 20-Bonno, A. 20.42 46.00 43.23 Ferguson, J. 32.63 136.00 69.08 SUTA 0.99 1.58 0.85 0.95 1.62 0.84 1.01 1.44 0.71 0.86 10.85 1.06 1.58 0.85 0.95 1.62 0.84 1.16 1.44 0.71 0.86 11.07 0.99 1.58 GLO-BRITE PAINT COMPANY Deductions NAME Ford, C. Mann, D. O'Neill, J. Russell, V. Ryan, N. Sokowski, T. (Student) Williams, R. TOTALS HI 17.69 19.58 33.46 16.97 20.88 29.73 14.62 17.51 FIT 107.00 118.00 191.00 98.00 50.00 250.00 97.00 151.00 SIT 37.45 41.45 70.85 35.92 44.21 62.94 30.95 37.08 SUTA 0.85 0.95 1.62 0.82 1.01 1.44 0.71 0.85 223.49 1,244.00 473.16 10.82 Payday, November 13, 20-- For Period Ending November 14, 20-Williams, R. 30.15 333.00 63.84 1.46 TOTALS 30.15 333.00 63.84 1.46 GLO-BRITE PAINT COMPANY Deductions NAME HI FIT SIT SUTA Payday, November 20, 20-- For Period Ending November 14, 20-Bonno, A. 16.33 18.00 34.58 0.79 Ferguson, J. 32.63 64.00 69.08 1.58 Ford, C. 17.69 107.00 37.45 0.85 Mann, D. 19.58 82.00 41.45 0.95 O'Neill, J. 33.46 86.00 70.85 1.62 Russell, V. 16.97 98.00 35.92 0.82 Ryan, N. 20.88 30.00 44.21 1.01 Sokowski, T. 29.73 250.00 62.94 1.44 (Student) 14.62 97.00 30.95 0.71 TOTALS 201.89 832.00 427.43 Payday, December 4, 20-- For Period Ending November 28, 20-Bonno, A. 23.48 49.71 Ferguson, J. 32.63 64.00 69.08 Ford, C. 18.56 107.00 39.30 Mann, D. 19.58 82.00 41.45 O'Neill, J. 33.46 86.00 70.85 Russell, V. 18.27 98.00 38.68 Ryan, N. 21.01 44.48 Sokowski, T. 29.73 250.00 62.94 (Student) 14.62 97.00 30.95 Woods, B. 17.40 36.84 TOTALS 228.74 784.00 484.28 9.77 1.13 1.58 0.90 0.95 1.62 0.88 1.01 1.44 0.71 0.84 11.06 Payday, December 14, 20-- For Period Ending December 12, 20-Russell, V. 16.44 34.81 0.79 TOTALS 16.44 0.00 34.81 0.79 GLO-BRITE PAINT COMPANY Deductions NAME HI FIT SIT SUTA Payday, December 18, 20-- For Period Ending December 12, 20-Bonno, A. 25.01 52.95 1.21 Ferguson, J. 32.63 64.00 69.08 1.58 Ford, C. 18.56 107.00 39.30 0.90 Mann, D. 19.58 82.00 41.45 0.95 O'Neill, J. 1,120.96 2,373.35 54.12 Ryan, N. 23.62 50.01 1.14 Sokowski, T. 29.73 250.00 62.94 1.44 (Student) 13.40 28.37 0.65 Woods, B. 17.40 36.84 0.84 Young, P. 18.27 38.68 0.88 TOTALS 1,319.16 503.00 2,792.97 63.71 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 Union Ins. 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 672 673 674 675 676 677 678 679 680 681 0.00 Payday, October 23, 20-- For Period Ending October 17, 20-Bonno, A. 59.18 16.50 8.00 Ferguson, J. 87.98 26.40 Ford, C. 47.70 14.40 Mann, D. 52.79 15.90 O'Neill, J. 90.24 27.00 Russell, V. 46.92 14.10 Ryan, N. 64.75 16.80 8.00 Sokowski, T. 80.16 24.00 (Student) 39.41 11.70 Williams, R. 47.82 14.40 TOTALS 616.95 181.20 16.00 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 OASDI 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 HI 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 682 683 684 685 686 687 688 689 690 691 0.00 Payday, November 6, 20-- For Period Ending October 31, 20-Bonno, A. 55.06 8.00 Ferguson, J. 87.98 Amount Taxable Earnings 1,210.60 1,756.83 919.27 1,095.63 1,750.44 882.50 1,317.77 1,548.63 751.11 874.89 1,513.60 2,250.00 1,220.00 1,350.00 2,307.69 1,200.00 1,656.00 2,050.00 1,008.00 1,223.08 1,513.60 2,250.00 1,220.00 1,350.00 2,307.69 1,200.00 1,656.00 2,050.00 1,008.00 1,223.08 12,107.67 15,778.37 15,778.37 692 693 1,147.00 1,783.23 1,408.00 2,250.00 1,408.00 2,250.00 Labor Cost Distribution FUTA SUTA 700.00 1,350.00 1,220.00 1,350.00 Admin. Office 1,220.00 2,307.69 760.00 1,200.00 1,200.00 1,008.00 1,008.00 1,008.00 1,223.08 3,818.00 4,778.00 250.00 1,220.00 1,350.00 2,307.69 4,651.08 1,220.00 2,307.69 1,200.00 1,200.00 442.00 1,008.00 1,008.00 1,223.08 692.00 4,778.00 2,307.69 4,651.08 Deductions NAME Net Paid Ford, C. Mann, D. O'Neill, J. Russell, V. Ryan, N. Sokowski, T. (Student) Williams, R. CIT 47.70 52.79 90.24 45.75 56.31 80.16 39.41 47.23 TOTALS 602.63 Group Union Ins. Dues Ck. SIMPLE No. 694 695 696 697 8.00 698 699 700 701 0.00 16.00 0.00 Payday, November 13, 20-- For Period Ending November 14, 20-Williams, R. 81.31 14.40 702 TOTALS 81.31 14.40 0.00 0.00 Amount 933.67 1,033.53 1,777.44 900.00 1,170.31 1,498.63 762.81 879.29 Taxable Earnings OASDI 1,220.00 1,350.00 2,307.69 1,170.00 1,440.00 2,050.00 1,008.00 1,207.85 HI 1,220.00 1,350.00 2,307.69 1,170.00 1,440.00 2,050.00 1,008.00 1,207.85 11,885.91 15,411.54 15,411.54 1,426.24 2,079.32 2,079.32 1,426.24 2,079.32 2,079.32 FUTA Labor Cost Distribution SUTA 760.00 1,350.00 Admin. Office 1,220.00 2,307.69 0.00 860.00 1,170.00 1,008.00 1,008.00 1,207.85 3,978.00 2,307.69 4,605.85 2,079.32 0.00 0.00 0.00 2,079.32 Deductions NAME Net Paid CIT Group Union Ins. Dues Ck. SIMPLE No. Payday, November 20, 20-- For Period Ending November 14, 20-Bonno, A. 44.04 16.50 8.00 Ferguson, J. 87.98 26.40 500.00 Ford, C. 47.70 14.40 Mann, D. 52.79 15.90 250.00 O'Neill, J. 90.24 27.00 700.00 Russell, V. 45.75 14.10 Ryan, N. 56.31 16.80 8.00 200.00 Sokowski, T. 80.16 24.00 (Student) 39.41 11.70 TOTALS 544.38 166.80 16.00 1,650.00 Payday, December 4, 20-- For Period Ending November 28, 20-Bonno, A. 63.31 8.00 Ferguson, J. 87.98 26.40 500.00 Ford, C. 50.05 14.40 Mann, D. 52.79 15.90 250.00 O'Neill, J. 90.24 27.00 700.00 Russell, V. 49.27 14.10 Ryan, N. 56.66 8.00 200.00 Sokowski, T. 80.16 24.00 (Student) 39.41 Woods, B. 46.92 TOTALS 616.79 121.80 16.00 1,650.00 Payday, December 14, 20-- For Period Ending December 12, 20-Russell, V. 14.10 TOTALS 0.00 14.10 703 704 705 706 707 708 709 710 711 0.00 0.00 Amount 918.32 1,328.83 919.27 803.63 1,155.44 885.90 973.51 1,474.63 751.11 Taxable Earnings OASDI 1,126.40 2,250.00 1,220.00 1,350.00 2,307.69 1,170.00 1,440.00 2,050.00 1,008.00 HI 1,126.40 2,250.00 1,220.00 1,350.00 2,307.69 1,170.00 1,440.00 2,050.00 1,008.00 9,210.64 13,922.09 13,922.09 712 713 714 715 716 717 718 719 720 721 1,373.18 1,328.83 970.43 803.63 1,155.44 962.68 1,028.00 1,474.63 762.81 1,023.60 1,619.20 2,250.00 1,280.00 1,350.00 2,307.69 1,260.00 1,449.00 2,050.00 1,008.00 1,200.00 FUTA 997.55 1,134.00 1,134.00 997.55 1,134.00 1,134.00 SUTA Admin. Office 1,220.00 50.00 2,307.69 1,170.00 926.00 0.00 1,619.20 2,250.00 1,280.00 1,350.00 2,307.69 1,260.00 1,449.00 2,050.00 1,008.00 1,200.00 10,883.23 15,773.89 15,773.89 Labor Cost Distribution 976.00 1,008.00 2,307.69 3,398.00 1,280.00 50.00 2,307.69 1,260.00 926.00 0.00 976.00 1,008.00 2,307.69 3,548.00 1,134.00 0.00 0.00 0.00 1,134.00 Deductions NAME Net Paid CIT Group Union Ins. Dues Ck. SIMPLE No. Payday, December 18, 20-- For Period Ending December 12, 20-Bonno, A. 67.44 9.00 Ferguson, J. 87.98 500.00 Ford, C. 50.05 Mann, D. 52.79 250.00 O'Neill, J. 3,022.89 4,000.00 Ryan, N. 63.70 9.00 200.00 Sokowski, T. 80.16 (Student) 36.13 Woods, B. 46.92 Young, P. 49.27 11.60 TOTALS 3,557.33 0.00 29.60 4,950.00 Amount Taxable Earnings OASDI HI 722 1,462.25 723 1,355.23 724 984.83 725 819.53 726 62,751.69 727 1,180.53 728 1,498.63 729 788.16 730 1,023.60 1,063.18 316.80 1,724.80 0.00 2,250.00 0.00 1,280.00 0.00 1,350.00 0.00 77,307.69 189.00 1,629.00 0.00 2,050.00 0.00 924.00 0.00 1,200.00 72,927.63 505.80 89,715.49 FUTA Labor Cost Distribution SUTA Admin. Office 1,280.00 77,307.69 924.00 0.00 0.00 77,307.69 2,204.00 Labor Cost Distribution 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 Sales Plant Checkpoints For Period Ending October 3, 20-1,408.00 Total earnings 2,250.00 Net paid 1,350.00 1,440.00 2,050.00 3,600.00 4,898.00 Payday, October 23, 20-- For Period Ending October 17,Checkpoints 20-Bonno, A. 1,513.60 Total earnings Ferguson, J. 2,250.00 Net paid Ford, C. Mann, D. 1,350.00 O'Neill, J. Russell, V. Ryan, N. 1,656.00 Sokowski, T. 2,050.00 (Student) Williams, R. TOTALS 15,456.77 12,044.51 3,600.00 15,778.37 12,107.67 5,219.60 Payday, November 6, 20-- For Period Ending October 31,Checkpoints 20-Bonno, A. 1,408.00 Total earnings Ferguson, J. 2,250.00 Net paid 15,411.54 11,885.91 Labor Cost Distribution NAME Ford, C. Mann, D. O'Neill, J. Russell, V. Ryan, N. Sokowski, T. (Student) Williams, R. TOTALS Sales Plant 1,350.00 1,440.00 2,050.00 3,600.00 4,898.00 Payday, November 13, 20-- For Period Ending NovemberCheckpoints 14, 20-Williams, R. Total earnings Net paid TOTALS 0.00 0.00 2,079.32 1,426.24 Labor Cost Distribution NAME Sales Plant Payday, November 20, 20-- For Period Ending NovemberCheckpoints 14, 20-Bonno, A. 1,126.40 Total earnings Ferguson, J. 2,250.00 Net paid Ford, C. Mann, D. 1,350.00 O'Neill, J. Russell, V. Ryan, N. 1,440.00 Sokowski, T. 2,050.00 (Student) TOTALS 3,600.00 4,616.40 Checkpoints Payday, December 4, 20-- For Period Ending November 28, 20-Bonno, A. 1,619.20 Total earnings Ferguson, J. 2,250.00 Net paid Ford, C. Mann, D. 1,350.00 O'Neill, J. Russell, V. Ryan, N. 1,449.00 Sokowski, T. 2,050.00 (Student) Woods, B. TOTALS 3,600.00 5,118.20 Payday, December 14, 20-- For Period Ending DecemberCheckpoints 12, 20-Russell, V. Total earnings Net paid TOTALS 0.00 0.00 13,922.09 9,210.64 Labor Cost Distribution NAME Sales Plant Payday, December 18, 20-- For Period Ending DecemberCheckpoints 12, 20-Bonno, A. 1,724.80 Total earnings Ferguson, J. 2,250.00 Net paid Ford, C. Mann, D. 1,350.00 O'Neill, J. Ryan, N. 1,629.00 Sokowski, T. 2,050.00 (Student) Woods, B. Young, P. TOTALS 3,600.00 5,403.80 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 UNION DUES $55,000 --$.30/M $8 each pay NAME - LAST FIRST BONNO Anthony $ $ $ $ SALARY OTHER WEEKLY RAT HOURLY RAT 20___ PAYDAY REGULAR EARNINGS HRS. RATE AMOUNT 10/9 2 10/23 3 11/6 4 11/20 5 12/4 6 12/18 QTR. TOT. 80 80 80 64 80 80 464 HRS. RATE 10,293.40 1,408.00 1,408.00 1,408.00 1,126.40 1,408.00 1,408.00 8,166.40 18,459.80 YEAR-TO-DATE 1 OVERTIME EARNINGS 17.60 17.60 17.60 17.60 17.60 17.60 YR. TOT. 4 26.40 8 12 26.40 26.40 OVERTIME R CUMULATIVE EARNINGS AMOUNT 11,322.00 12,730.00 14,243.60 15,651.60 16,778.00 18,397.20 20,122.00 8,800.00 20,122.00 17.60 26.40 DEDUCTIONS 701.96 87.30 93.84 87.30 69.84 100.39 106.94 545.61 1,247.57 OTHER HI 164.17 20.42 21.95 20.42 16.33 23.48 25.01 127.61 291.78 FIT 810.00 46.00 56.00 46.00 18.00 SIT SUTA 347.59 43.23 46.47 43.23 34.58 49.71 52.95 270.17 617.76 OCCUPATION WORKS IN (STATE) Sales Sales Manager PA SEX M F x S.S. ACCOUNT NO. 000-00-8645 OTHER DEDUCTIONS INFORMATION NAME - LAST OTHER FERGUSON $ $ $ $ WEEKLY RAT HOURLY RAT $88,000 -- $.30/M OVERTIME R OVERTIME EARNINGS PAYDAY YEAR-TO-DATE 1 10/9 2 10/23 3 11/6 4 11/20 5 12/4 6 12/18 QTR. TOT. YR. TOT. CUMULATIVE EARNINGS HRS. 80 80 80 80 80 80 480 RATE AMOUNT 442.71 55.06 59.18 55.06 44.04 63.31 67.44 344.09 786.80 DEDUCTIONS 216.80 8.00 24.50 8.00 24.50 9.00 24.50 98.50 315.30 FIRST SALARY UNION DUES REGULAR EARNINGS SIMPLE Checkpoint DEPARTMENT 20___ CIT 7.93 0.99 1.06 0.99 0.79 1.13 1.21 6.17 14.10 Checkpoint GROUP INSURANCE 5 FICA OASDI 1,028.60 0.00 105.60 0.00 0.00 211.20 316.80 633.60 1,662.20 W/H ALLOW. HRS. RATE AMOUNT James 58,500 /yr. 1,125.00 28.13 W/H ALLOW. 5 DEDUCTIONS FICA OASDI OTHER HI FIT SIT SUTA CIT SIMPLE DEDUCTIONS 23,125.00 2,250.00 2,250.00 2,250.00 2,250.00 2,250.00 2,250.00 13,500.00 23,125.00 25,375.00 27,625.00 29,875.00 32,125.00 34,375.00 36,625.00 13,500.00 1,433.75 139.50 139.50 139.50 139.50 139.50 139.50 837.00 335.31 32.63 32.63 32.63 32.63 32.63 32.63 195.78 2,291.00 136.00 136.00 136.00 64.00 64.00 64.00 600.00 709.94 69.08 69.08 69.08 69.08 69.08 69.08 414.48 16.19 1.58 1.58 1.58 1.58 1.58 1.58 9.48 904.23 87.98 87.98 87.98 87.98 87.98 87.98 527.88 132.30 500.00 500.00 500.00 1,500.00 26.40 36,625.00 36,625.00 2,270.75 531.09 2,891.00 1,124.42 25.67 1,432.11 1,500.00 211.50 26.40 26.40 79.20 Checkpoint Checkpoint OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST M F Office Executive Secretary x PA 000-00-4567 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE FORD $ $ $ $ SALARY UNION DUES OTHER WEEKLY RAT HOURLY RAT $50,000--$.30/M 20___ OVERTIME R REGULAR EARNINGS OVERTIME EARNINGS PAYDAY EARNINGS HRS. RATE AMOUNT YEAR-TO-DATE 1 10/9 2 10/23 3 11/6 4 11/20 5 12/4 6 12/18 QTR. TOT. CUMULATIVE 80 80 80 80 80 80 480 YR. TOT. HRS. RATE AMOUNT Catherine 2,733.33 /mo. 640.00 16.00 24.00 2 DEDUCTIONS FICA OASDI OTHER HI FIT SIT SUTA CIT SIMPLE DEDUCTIONS 6,300.00 1,220.00 1,220.00 1,220.00 1,220.00 1,280.00 1,280.00 7,440.00 6,300.00 7,520.00 8,740.00 9,960.00 11,180.00 12,460.00 13,740.00 7,440.00 390.60 75.64 75.64 75.64 75.64 79.36 79.36 461.28 91.35 17.69 17.69 17.69 17.69 18.56 18.56 107.88 639.00 107.00 107.00 107.00 107.00 107.00 107.00 642.00 193.41 37.45 37.45 37.45 37.45 39.30 39.30 228.40 4.41 0.85 0.85 0.85 0.85 0.90 0.90 5.20 246.34 47.70 47.70 47.70 47.70 50.05 50.05 290.90 37.80 13,740.00 13,740.00 851.88 199.23 1,281.00 421.81 9.61 537.24 81.00 Checkpoint 14.40 14.40 14.40 43.20 Checkpoint OCCUPATION DEPARTMENT W/H ALLOW. WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST M F Sales Sales Representative x PA 000-00-9352 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE MANN $ $ $ $ SALARY UNION DUES OTHER WEEKLY RAT HOURLY RAT $53,000 -- $.30/M 20___ OVERTIME R 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 TR. TOT. CUMULATIVE 80 80 80 80 80 80 480 RATE AMOUNT 5,400.00 1,350.00 1,350.00 1,350.00 1,350.00 1,350.00 1,350.00 8,100.00 HRS. RATE AMOUNT W/H ALLOW. 0 DEDUCTIONS FICA OASDI 5,400.00 6,750.00 8,100.00 9,450.00 10,800.00 12,150.00 13,500.00 8,100.00 Dewey 2,925 /mo. 675.00 16.88 334.80 83.70 83.70 83.70 83.70 83.70 83.70 502.20 OTHER HI 78.30 19.58 19.58 19.58 19.58 19.58 19.58 117.48 FIT 332.00 40.00 40.00 118.00 82.00 82.00 82.00 444.00 SIT 165.78 41.45 41.45 41.45 41.45 41.45 41.45 248.70 SUTA 3.78 0.95 0.95 0.95 0.95 0.95 0.95 5.70 CIT 211.15 52.79 52.79 52.79 52.79 52.79 52.79 316.74 SIMPLE DEDUCTIONS 31.50 15.90 250.00 250.00 250.00 750.00 15.90 YR. TOT. 13,500.00 Checkpoint 13,500.00 837.00 195.78 776.00 414.48 9.48 527.89 750.00 Checkpoint OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST M F Administrative President x PA 000-00-1534 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE O'NEILL $ $ $ $ SALARY UNION DUES OTHER WEEKLY RAT HOURLY RAT $90,000 -- $.30/M 20___ OVERTIME R 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 YR. TOT. AMOUNT 3 DEDUCTIONS OASDI OTHER HI 42,692.27 44,999.96 47,307.65 49,615.34 51,923.03 54,230.72 131,538.41 88,846.14 2,646.92 619.04 143.08 33.46 143.08 33.46 143.08 33.46 143.08 33.46 143.08 33.46 3,984.68 1,120.96 4,700.08 1,288.26 131,538.41 131,538.41 7,347.00 1,907.30 80 80 80 80 80 80 480 TR. TOT. HRS. RATE FIT 6,116.00 191.00 191.00 191.00 86.00 86.00 SIT SUTA CIT SIMPLE DEDUCTIONS 1,310.65 70.85 70.85 70.85 70.85 70.85 2,373.35 2,727.60 29.88 1.62 1.62 1.62 1.62 1.62 54.12 62.22 1,669.35 90.24 90.24 90.24 90.24 90.24 3,022.89 3,474.09 700.00 700.00 700.00 2,100.00 27.00 4,038.25 92.10 5,143.44 2,100.00 283.50 Checkpoint 202.50 27.00 27.00 81.00 Checkpoint OCCUPATION DEPARTMENT W/H ALLOW. FICA 42,692.27 2,307.69 2,307.69 2,307.69 2,307.69 2,307.69 77,307.69 88,846.14 YEAR-TO-DATE 1 CUMULATIVE Joseph 60,000 /yr. 1,153.85 28.85 WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST 000-00-6337 RUSSELL FIRST M F Office Time Clerk x PA OTHER DEDUCTIONS INFORMATION GROUP INSURANCE $ $ $ $ SALARY UNION DUES OTHER WEEKLY RAT HOURLY RAT $49,000 -- $.30/M 20___ OVERTIME R 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 TR. TOT. CUMULATIVE 80 80 78 78 80 72 468 RATE AMOUNT 6,240.00 1,200.00 1,200.00 1,170.00 1,170.00 1,200.00 1,134.00 7,074.00 HRS. RATE AMOUNT W/H ALLOW. 2 DEDUCTIONS FICA OASDI 6,240.00 7,440.00 8,640.00 9,810.00 10,980.00 12,180.00 13,314.00 7,074.00 Virginia 2,730 /mo. 630.00 15.75 23.63 386.88 74.40 74.40 72.54 72.54 74.40 70.31 438.59 OTHER HI 90.48 17.40 17.40 16.97 16.97 17.40 16.44 102.58 FIT 642.00 127.00 127.00 98.00 98.00 127.00 577.00 SIT 191.56 36.84 36.84 35.92 35.92 36.84 0.00 182.36 SUTA 4.37 0.84 0.84 0.82 0.82 0.84 0.79 4.95 CIT 244.00 46.92 46.92 45.75 45.75 46.92 232.26 SIMPLE DEDUCTIONS 31.50 14.10 14.10 YR. TOT. 13,314.00 Checkpoint 13,314.00 825.47 193.06 1,219.00 373.92 9.32 476.26 Checkpoint OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST M F Plant Electrician x PA 000-00-1223 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE UNION DUES $56,000 -- $.30/M $8 each pay RYAN Norman $ $ $ $ SALARY OTHER WEEKLY RAT HOURLY RAT 20___ REGULAR EARNINGS OVERTIME EARNINGS PAYDAY HRS. 10/9 2 10/23 3 11/6 4 11/20 5 12/4 6 12/18 QTR. TOT. CUMULATIVE EARNINGS RATE AMOUNT 13,287.50 1,440.00 1,440.00 1,440.00 1,440.00 1,368.00 1,440.00 8,568.00 YEAR-TO-DATE 1 OVERTIME R 80 80 80 80 76 80 476 18.00 18.00 18.00 18.00 18.00 18.00 HRS. RATE 8 27.00 3 7 27.00 27.00 21,855.50 YR. TOT. Checkpoint OCCUPATION DEPARTMENT AMOUNT 4 DEDUCTIONS OASDI OTHER HI 14,685.30 16,125.30 17,781.30 19,221.30 20,661.30 22,110.30 23,739.30 9,054.00 910.49 89.28 102.67 89.28 89.28 89.84 101.00 561.35 212.94 20.88 24.01 20.88 20.88 21.01 23.62 131.28 1,883.80 23,739.30 1,471.84 344.22 9,054.00 23,739.30 SEX 18.00 27.00 FICA 1,397.80 0.00 216.00 0.00 0.00 81.00 189.00 486.00 WORKS IN (STATE) W/H ALLOW. FIT 1,070.00 50.00 70.00 50.00 30.00 SIT SUTA CIT SIMPLE DEDUCTIONS 450.84 44.21 50.84 44.21 44.21 44.48 50.01 277.96 10.28 1.01 1.16 1.01 1.01 1.01 1.14 6.34 574.22 56.31 64.75 56.31 56.31 56.66 63.70 354.04 200.00 200.00 200.00 600.00 235.70 8.00 24.80 8.00 24.80 9.00 24.80 99.40 728.80 16.62 928.26 600.00 335.10 Checkpoint S.S. ACCOUNT NO. NAME - LAST FIRST M F Plant Supervisor x PA 000-00-8832 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE SOKOWSKI Thomas $ $ $ $ SALARY UNION DUES OTHER WEEKLY RAT HOURLY RAT $80,000 -- $.30/M 20___ OVERTIME R 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 QTR. TOT. CUMULATIVE 80 80 80 80 80 80 480 RATE AMOUNT 16,650.00 2,050.00 2,050.00 2,050.00 2,050.00 2,050.00 2,050.00 12,300.00 HRS. RATE AMOUNT ALLOW. 2 DEDUCTIONS FICA OASDI 16,650.00 18,700.00 20,750.00 22,800.00 24,850.00 26,900.00 28,950.00 12,300.00 W/H 1,025.00 25.63 1,032.30 127.10 127.10 127.10 127.10 127.10 127.10 762.60 OTHER HI 241.43 29.73 29.73 29.73 29.73 29.73 29.73 178.38 FIT 2,002.00 176.00 176.00 250.00 250.00 250.00 250.00 1,352.00 SIT 511.16 62.94 62.94 62.94 62.94 62.94 62.94 377.64 SUTA 11.66 1.44 1.44 1.44 1.44 1.44 1.44 8.64 CIT 651.05 80.16 80.16 80.16 80.16 80.16 80.16 480.96 SIMPLE DEDUCTIONS 94.50 24.00 24.00 24.00 72.00 YR. TOT. 28,950.00 Checkpoint 28,950.00 1,794.90 419.81 3,354.00 888.80 20.30 1,132.01 Checkpoint 166.50 OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST M F Office Accounting Trainee PA Shooltz OTHER DEDUCTIONS INFORMATION GROUP INSURANCE Cameron $ $ $ $ SALARY UNION DUES OTHER WEEKLY RAT HOURLY RAT $39,000 -- $.30/M 20___ OVERTIME R REGULAR EARNINGS OVERTIME EARNINGS PAYDAY EARNINGS HRS. RATE AMOUNT YEAR-TO-DATE 1 10/9 2 10/23 3 11/6 4 11/20 5 12/4 6 12/18 QTR. TOT. CUMULATIVE 72 72 72 72 72 66 426 14.00 14.00 14.00 14.00 14.00 14.00 YR. TOT. HRS. RATE AMOUNT W/H ALLOW. 14.00 21.00 DEDUCTIONS FICA OASDI OTHER HI FIT SIT SUTA CIT SIMPLE DEDUCTIONS 5,550.00 1,008.00 1,008.00 1,008.00 1,008.00 1,008.00 924.00 5,964.00 5,550.00 6,558.00 7,566.00 8,574.00 9,582.00 10,590.00 11,514.00 5,964.00 344.10 62.50 62.50 62.50 62.50 62.50 57.29 369.79 80.48 14.62 14.62 14.62 14.62 14.62 13.40 86.50 409.00 97.00 97.00 97.00 97.00 97.00 97.00 582.00 170.38 30.95 30.95 30.95 30.95 30.95 28.37 183.12 3.89 0.71 0.71 0.71 0.71 0.71 0.65 4.20 217.02 39.41 39.41 39.41 39.41 39.41 36.13 233.18 32.40 11,514.00 11,514.00 713.89 166.98 991.00 353.50 8.09 450.20 67.50 Checkpoint 11.70 11.70 11.70 35.10 Checkpoint OCCUPATION DEPARTMENT 1 WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST 000-00-6741 WILLIAMS FIRST M F Office Programmer x PA OTHER DEDUCTIONS INFORMATION GROUP INSURANCE Ruth $ $ $ $ SALARY UNION DUES OTHER WEEKLY RAT HOURLY RAT $48,000 -- $.30/M 20___ OVERTIME R REGULAR EARNINGS OVERTIME EARNINGS PAYDAY EARNINGS HRS. 10/9 2 10/23 3 11/6 4 11/13 RATE AMOUNT HRS. RATE AMOUNT W/H ALLOW. 0 DEDUCTIONS FICA OASDI OTHER HI FIT SIT SUTA CIT SIMPLE DEDUCTIONS 10,260.00 1,223.08 1,223.08 1,207.85 2,079.32 10,260.00 11,483.08 12,706.16 13,914.01 15,993.33 636.12 75.83 75.83 74.89 128.92 148.77 17.73 17.73 17.51 30.15 1,606.00 154.00 154.00 151.00 333.00 314.98 37.55 37.55 37.08 63.84 7.18 0.86 0.86 0.85 1.46 401.19 47.82 47.82 47.23 81.31 59.40 80 80 79 136 375 5,733.33 5,733.33 355.47 83.12 792.00 176.02 4.03 224.18 28.80 YEAR-TO-DATE 1 CUMULATIVE 2,650 /mo. 611.54 15.29 22.94 14.40 14.40 5 6 QTR. TOT. YR. TOT. 15,993.33 Checkpoint 15,993.33 5,733.33 15,993.33 991.59 231.89 2,398.00 491.00 11.21 625.37 Checkpoint 88.20 4,069.71 OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST M F Office Programmer x PA 000-00-1587 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE Woods Beth $ $ $ $ SALARY UNION DUES OTHER WEEKLY RAT HOURLY RAT $47,000 -- $.30/M 20___ OVERTIME R REGULAR EARNINGS OVERTIME EARNINGS PAYDAY CUMULATIVE EARNINGS HRS. RATE AMOUNT HRS. RATE AMOUNT 2,600 /mo. 600.00 15.00 W/H ALLOW. 1 DEDUCTIONS FICA OASDI OTHER HI FIT SIT SUTA CIT SIMPLE DEDUCTIONS YEAR-TO-DATE 1 2 3 4 5 12/4 6 12/18 QTR. TOT. 72 80 152 15.00 15.00 YR. TOT. 1,080.00 1,200.00 2,280.00 1,080.00 2,280.00 2,280.00 66.96 74.40 141.36 15.66 17.40 33.06 33.16 36.84 70.00 0.76 0.84 1.60 42.23 46.92 89.15 2,280.00 2,280.00 141.36 33.06 70.00 1.60 89.15 Checkpoint Checkpoint OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST M F Sales Field Sales Representative x PA 000-00-6057 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE Young Paul $ $ $ $ SALARY UNION DUES OTHER WEEKLY RAT HOURLY RAT $49,000 -- $.30/M 20___ OVERTIME R REGULAR EARNINGS OVERTIME EARNINGS PAYDAY CUMULATIVE EARNINGS HRS. RATE AMOUNT HRS. RATE AMOUNT 2,730 /mo. 630.00 15.75 W/H ALLOW. 1 DEDUCTIONS FICA OASDI OTHER HI FIT SIT SUTA CIT SIMPLE DEDUCTIONS YEAR-TO-DATE 1 2 3 4 5 6 12/18 QTR. TOT. 80 80 15.75 1,260.00 1,260.00 1,260.00 1,260.00 78.12 78.12 18.27 18.27 38.68 38.68 0.88 0.88 49.27 49.27 9.60 9.60 YR. TOT. 1,260.00 Checkpoint 1,260.00 78.12 18.27 38.68 0.88 49.27 Checkpoint 9.60 OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST M F OTHER DEDUCTIONS INFORMATION GROUP INSURANCE $ $ $ $ SALARY UNION DUES OTHER WEEKLY RAT HOURLY RAT OVERTIME R 20___ REGULAR EARNINGS OVERTIME EARNINGS PAYDAY CUMULATIVE EARNINGS HRS. RATE AMOUNT HRS. RATE AMOUNT W/H ALLOW. DEDUCTIONS FICA OASDI OTHER HI FIT SIT SUTA CIT SIMPLE DEDUCTIONS YEAR-TO-DATE 1 2 3 4 5 6 QTR. TOT. YR. TOT. OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST M F OTHER DEDUCTIONS INFORMATION GROUP INSURANCE UNION DUES $ $ $ $ SALARY OTHER WEEKLY RAT HOURLY RAT OVERTIME R 20___ REGULAR EARNINGS OVERTIME EARNINGS PAYDAY EARNINGS HRS. YEAR-TO-DATE 1 2 3 4 5 6 QTR. TOT. YR. TOT. CUMULATIVE RATE AMOUNT HRS. RATE AMOUNT W/H ALLOW. DEDUCTIONS FICA OASDI OTHER HI FIT SIT SUTA CIT SIMPLE DEDUCTIONS MIDDLE Victor MARITAL STATUS M NET PAID CK. NO. AMOUNT 672 682 692 703 8,630.84 1,147.00 1,210.60 1,147.00 918.32 1,372.18 1,446.75 7,241.85 15,872.69 MIDDLE Claude MARITAL STATUS M NET PAID CK. NO. AMOUNT 673 683 693 704 713 17,302.28 1,783.23 1,756.83 1,783.23 1,328.83 1,355.23 1,328.83 9,336.18 26,638.46 MIDDLE Louise MARITAL STATUS S NET PAID CK. NO. AMOUNT 4,697.09 933.67 919.27 933.67 919.27 984.83 970.43 5,661.14 674 684 694 705 10,358.23 MIDDLE Wilson MARITAL STATUS M NET PAID CK. NO. AMOUNT 675 685 695 706 715 4,242.69 1,111.53 1,095.63 1,033.53 803.63 819.53 819.53 5,683.38 9,926.07 MIDDLE Tyler MARITAL STATUS M NET PAID CK. NO. AMOUNT 676 686 696 707 30,097.93 1,777.44 1,750.44 1,777.44 1,155.44 1,182.44 66,024.69 73,667.89 103,765.82 MIDDLE Aloise MARITAL STATUS S NET PAID CK. NO. AMOUNT 677 687 697 708 4,649.21 896.60 882.50 900.00 885.90 896.60 1,046.46 5,508.06 10,157.27 MIDDLE Allen MARITAL STATUS M NET PAID CK. NO. AMOUNT 678 688 698 709 11,220.83 1,170.31 1,317.77 1,170.31 973.51 1,027.00 1,164.73 6,823.63 18,044.46 MIDDLE James MARITAL STATUS S NET PAID CK. NO. AMOUNT 679 689 699 710 12,105.90 1,572.63 1,548.63 1,498.63 1,474.63 1,498.63 1,474.63 9,067.78 21,173.68 MIDDLE MARITAL STATUS S NET PAID CK. NO. AMOUNT 4,292.73 762.81 751.11 762.81 751.11 762.81 679.46 4,470.11 680 690 700 711 8,762.84 MIDDLE Virginia MARITAL STATUS S NET PAID CK. NO. AMOUNT 681 691 701 702 7,086.36 889.29 874.89 879.29 1,426.24 4,069.71 11,156.07 11,156.07 MIDDLE Anne MARITAL STATUS S NET PAID CK. NO. AMOUNT 921.23 1,023.60 1,944.83 1,944.83 MIDDLE Winston MARITAL STATUS S NET PAID CK. NO. AMOUNT 1,065.18 1,065.18 1,065.18 MIDDLE MARITAL STATUS NET PAID CK. NO. AMOUNT MIDDLE MARITAL STATUS NET PAID CK. NO. AMOUNT