Payroll Project Chapter 7 Appendix B from Payroll Accounting 2018 edition Bieg and Toland.

Anonymous
timer Asked: Dec 20th, 2018

Question description

I need help with Payroll Project chapter 7 appendix B from the book Payroll Accounting 2018 edition Bieg and Toland I will attatch the files for you that I had tried to work on. Thank You.

Excel Instructions 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 Oct. DEBIT 12 11 12,052.11 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 958.32 224.12 1,118.00 474.52 10.82 602.88 16.00 12,052.11 958.32 224.12 22.91 175.76 25 11 474.52 23 Payroll Cash Cash 12 11 12,115.26 DESCRIPTION 23 Administrative Salaries Office Salaries Sales Salaries Plant Wages FICA Taxes Payable - OASDI FICA Taxes Payable - HI POST. REF. 51 52 53 54 20.1 20.2 CREDIT 12,052.11 20 Employees SIT Payable Cash JOURNAL DATE 20-- POST. REF. 474.52 12,115.26 Page 42 DEBIT CREDIT 2,307.69 4,651.08 3,600.00 5,219.60 978.26 228.79 Employees FIT Payable Employees SIT Payable Employees SUTA Payable Employees CIT Payable Group Insurance Premiums Collected Union Dues Payable Payroll Cash 23 Payroll Taxes FICA Taxes Payable - OASDI FICA Taxes Payable - HI FUTA Taxes Payable SUTA Taxes Payable - Employer Nov. 56 20.1 20.2 21 22 1,148.00 484.40 11.04 615.42 181.20 16.00 12,115.26 1,386.96 978.26 228.79 4.15 175.76 4 Employees SIT Payable Cash 25 11 484.40 6 Union Dues Payable Cash 28 11 32.00 JOURNAL DATE 20-- Nov. 24 25 25.1 26 27 28 12 DESCRIPTION 6 Payroll Cash Cash POST. REF. 484.40 32.00 Page 43 DEBIT 12 11 11,893.52 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,343.71 12 11 1,428.46 13 Payroll Cash Cash CREDIT 11,893.52 955.52 223.47 1,238.00 473.13 10.79 601.11 16.00 11,893.52 955.52 223.47 164.72 1,428.46 JOURNAL DATE 20-- Nov. DESCRIPTION POST. REF. Page 44 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.16 905.82 2,266.00 16 Employee CIT Payable Cash 26 11 1,218.30 18 Employees SIT Payable Cash 25 11 536.97 20 Payroll Cash Cash 12 11 9,216.08 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 Group Insurance Premiums Collected Union Dues Payable SIMPLE Contributions Payable Payroll Cash CREDIT 128.92 30.15 331.00 63.84 1.46 81.10 14.40 1,428.46 128.92 30.15 7,044.98 1,218.30 536.97 9,216.08 863.17 201.87 828.00 427.41 9.75 543.02 166.80 16.00 1,650.00 9,216.08 JOURNAL DATE 20-- Nov. DESCRIPTION 20 Payroll Taxes FICA Taxes Payable - OASDI FICA Taxes Payable - HI SUTA Taxes Payable - Employer JOURNAL DATE 20-- DESCRIPTION POST. REF. 56 20.1 20.2 22 POST. REF. Page 45 DEBIT CREDIT 1,113.15 863.17 201.87 48.11 Page 46 DEBIT CREDIT JOURNAL DATE 20-- DESCRIPTION POST. REF. Page 47 DEBIT CREDIT JOURNAL DATE 20-- DESCRIPTION JOURNAL DATE 20-- DESCRIPTION POST. REF. POST. REF. Page 48 DEBIT CREDIT Page 49 DEBIT CREDIT JOURNAL DATE 20-- DESCRIPTION POST. REF. Page 50 DEBIT CREDIT Total debits and credits (calculated automatically): 124,528.68 124,528.68 Your debits and credits should be equal after each journal entry is complete Cumulative Journal Checkpoint Through Month Ending 58,644.96 124,528.47 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. 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,052.11 474.52 12,115.26 484.40 32.00 11,893.52 1,428.46 7,044.98 1,218.30 536.97 9,216.08 199,846.33 187,794.22 187,319.70 175,204.43 174,720.04 174,688.04 162,794.52 161,366.06 154,321.08 153,102.78 152,565.81 143,349.73 CREDIT Debit Balance Oct. 31, 20-- 175,204.58 Nov. 30, 20-- 143,349.95 Dec. 31, 20-- Credit Balance ACCOUNT: ACCOUNT NO. 12 PAYROLL CASH DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT 20-- Oct. Nov. 9 9 23 23 6 6 13 13 20 20 J41 J41 J41 J42 J43 J43 J43 J44 J44 J44 Checkpoints 12,052.11 12,052.11 12,115.26 12,115.26 11,893.52 11,893.52 1,428.46 1,428.46 9,216.08 9,216.08 12,052.11 0.00 12,115.26 0.00 11,893.52 0.00 1,428.46 0.00 9,216.08 0.00 CREDIT Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Debit Balance 0.00 0.00 Credit Balance ACCOUNT: ACCOUNT NO. 20.1 FICA TAXES PAYABLE - OASDI DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT CREDIT 20-- Oct. Nov. ACCOUNT: 9 9 23 23 6 6 13 13 16 20 20 J41 J41 J42 J42 J43 J43 J44 J44 J44 J44 J45 FICA TAXES PAYABLE - HI Checkpoints Debit Balance 958.32 958.32 978.26 978.26 955.52 955.52 128.92 128.92 3,873.16 863.17 863.17 958.32 1,916.64 2,894.90 3,873.16 4,828.67 5,784.19 5,913.11 6,042.02 2,168.87 3,032.04 3,895.21 ACCOUNT NO. 20.2 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance 3,873.17 3,895.24 Checkpoints DATE ITEM POST. REF. Debit Balance BALANCE DEBIT CREDIT DEBIT CREDIT 20-- Oct. Nov. ACCOUNT: 9 9 23 23 6 6 13 13 16 20 20 J41 J41 J42 J42 J43 J43 J44 J44 J44 J44 J45 224.12 224.12 228.79 228.79 223.47 223.47 30.15 30.15 905.82 201.87 201.87 ACCOUNT NO. 21 FUTA TAXES PAYABLE DATE ITEM 224.12 448.25 677.03 905.82 1,129.29 1,352.75 1,382.90 1,413.05 507.23 709.11 910.98 POST. REF. 1 Balance 9 23 a J41 J42 Checkpoints Debit Balance BALANCE DEBIT CREDIT DEBIT CREDIT 20-- Oct. Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- 22.91 4.15 392.94 415.85 420.00 Credit Balance 905.85 911.02 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance 420.00 420.00 ACCOUNT: ACCOUNT NO. 22 SUTA TAXES PAYABLE - EMPLOYER DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT CREDIT 20-- Oct. Nov. 9 23 6 20 J41 J42 J43 J45 Checkpoints Debit Balance 175.76 175.76 164.72 48.11 175.76 351.52 516.24 564.36 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance 351.52 564.35 ACCOUNT: ACCOUNT NO. 24 EMPLOYEES FIT PAYABLE DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT CREDIT 20-- Oct. Nov. 9 23 6 13 16 20 ACCOUNT: J41 J42 J43 J44 J44 J44 1,118.00 1,148.00 1,238.00 331.00 ITEM 1,118.00 2,266.00 3,504.00 3,835.00 1,569.00 2,397.00 2,266.00 828.00 POST. REF. BALANCE DEBIT CREDIT DEBIT CREDIT Nov. 9 20 23 4 6 13 18 20 J41 J41 J42 J42 J43 J44 J44 J44 474.52 474.52 484.40 484.40 473.13 63.84 536.97 427.41 474.52 0.00 484.40 0.00 473.13 536.97 0.00 427.41 Credit Balance 2,266.00 2,397.00 Checkpoints Debit Balance 20-- Oct. Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- ACCOUNT NO. 25 EMPLOYEES SIT PAYABLE DATE Checkpoints Debit Balance Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance 484.42 427.43 ACCOUNT: ACCOUNT NO. 25.1 EMPLOYEES SUTA PAYABLE DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT CREDIT 20-- Oct. Nov. ACCOUNT: 9 23 6 13 20 J41 J42 J43 J44 J44 10.82 11.04 10.79 1.46 9.75 10.82 21.86 32.65 34.11 43.85 ACCOUNT NO. 26 EMPLOYEES CIT PAYABLE POST. Checkpoints Debit Balance BALANCE Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance 21.92 43.97 Checkpoints Debit Balance Credit Balance DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT 20-- Oct. Nov. 9 23 6 13 16 20 ACCOUNT: J41 J42 J43 J44 J44 J44 602.88 615.42 601.11 81.10 1,218.30 543.02 ACCOUNT NO. 27 GROUP INSURANCE PREMIUMS COLLECTED DATE ITEM POST. REF. 602.88 1,218.30 1,819.41 1,900.51 682.21 1,225.23 23 13 20 J42 J44 J44 Checkpoints BALANCE DEBIT CREDIT DEBIT 181.20 14.40 166.80 1,218.32 1,225.24 Debit Balance CREDIT 20-- Oct. Nov. Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- 181.20 195.60 362.40 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance 181.20 362.40 ACCOUNT: ACCOUNT NO. 28 UNION DUES PAYABLE DATE ITEM POST. REF. Checkpoints Debit Balance BALANCE DEBIT CREDIT DEBIT CREDIT 20-- Oct. Nov. 9 23 6 6 20 ACCOUNT: J41 J42 J42 J43 J44 16.00 16.00 32.00 16.00 16.00 ACCOUNT NO. 29 SIMPLE CONTRIBUTIONS PAYABLE DATE ITEM 16.00 32.00 0.00 16.00 32.00 POST. REF. 20 J44 Checkpoints Debit Balance BALANCE DEBIT CREDIT DEBIT CREDIT 20-- Nov. Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- 1,650.00 1,650.00 Credit Balance 32.00 32.00 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance 0.00 1,650.00 ACCOUNT: ACCOUNT NO. 51 ADMINISTRATIVE SALARIES DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT 20-- Oct. Nov. 1 Balance 9 23 6 20 a J41 J42 J43 J44 Checkpoints 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 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Debit Balance 47,307.65 51,923.03 Credit Balance ACCOUNT: ACCOUNT NO. 52 OFFICE SALARIES DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT 20-- Oct. Nov. 1 Balance 9 23 6 13 20 a J41 J42 J43 J44 J44 Checkpoints 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 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Debit Balance 37,652.16 47,735.33 Credit Balance ACCOUNT: ACCOUNT NO. 53 SALES SALARIES DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT CREDIT 20-- Oct. Nov. ACCOUNT: a J41 J42 J43 J44 1 Balance 9 23 6 20 28,525.00 32,125.00 35,725.00 39,325.00 42,925.00 3,600.00 3,600.00 3,600.00 3,600.00 ITEM POST. REF. DEBIT CREDIT DEBIT 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 Credit Balance Checkpoints BALANCE 20-- Oct. Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- ACCOUNT NO. 54 PLANT WAGES DATE Checkpoints Debit Balance 35,725.00 42,925.00 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Debit Balance 52,774.90 62,289.30 Credit Balance ACCOUNT: ACCOUNT NO. 56 PAYROLL TAXES DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT 20-- Oct. Nov. 1 Balance 9 23 6 13 20 a J41 J42 J43 J44 J45 Checkpoints 1,381.11 1,386.96 1,343.71 159.07 1,113.15 14,289.12 15,670.23 17,057.19 18,400.89 18,559.96 19,673.11 CREDIT Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Debit Balance 17,057.19 19,673.12 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 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 Ford, C. S 2 8 8 8 8 8 Mann, D. M 0 8 8 8 8 8 8 8 8 8 GLO-BRITE PAINT COMP 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 80 17.60 80 80 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.32 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,220.00 1,350.00 1,408.00 2,250.00 1,220.00 1,350.00 87.30 139.50 75.64 83.70 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 O'Neill, J. Russell, V. Ryan, N. Sokowski, T. (Student) Williams, R. M S M S S S 3 2 4 2 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 7 8 6 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 4 8 80 78 80 18.00 80 72 14.00 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 6 8 136 2,307.69 1,170.00 1,440.00 2,050.00 1,008.00 1,207.85 2,307.69 1,170.00 1,440.00 2,050.00 1,008.00 1,207.85 143.08 72.54 89.28 127.10 62.50 74.89 15,411.54 15,411.54 955.52 2,079.32 2,079.32 128.92 2,079.32 2,079.32 128.92 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. M 2 8 8 8 8 8 8 8 8 (Student) S 1 8 8 8 4 8 8 8 8 Woods B S 1 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 80 80 80 80 80 79 80 72 72 17.60 18.00 14.00 15.00 TOTALS Payday, December 14, 20-- For Period Ending December 12, 20-Russell, V. S 2 8 8 8 8 8 8 8 8 8 152 15.75 TOTALS 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. M 2 8 8 8 8 8 8 (Student) S 1 8 8 7 8 4 4 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 4 80 80 76 80 80 80 80 67 17.60 16.00 18.00 14.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 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.17 1,619.20 2,250.00 1,280.00 1,350.00 2,307.70 1,260.00 1,422.00 2,050.00 1,008.00 1,080.00 100.39 139.50 79.36 83.70 143.08 78.12 88.16 127.10 62.50 66.96 15,415.70 211.20 15,626.90 968.87 2,394.00 2,394.00 148.43 2,394.00 2,394.00 148.43 1,724.80 2,250.00 1,216.00 1,350.00 2,307.70 1,629.00 2,050.00 938.00 106.94 139.50 75.39 83.70 4,667.17 101.00 127.10 58.16 1,408.00 2,250.00 1,280.00 1,350.00 2,307.70 1,260.00 1,422.00 2,050.00 1,008.00 1,080.00 1,408.00 2,250.00 1,216.00 1,350.00 2,307.70 1,440.00 2,050.00 938.00 8 26.40 211.20 12 26.40 316.80 7 27.00 189.00 Woods, B. Young, P. TOTALS S S 1 1 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 80 80 1,200.00 1,260.00 1,200.00 1,260.00 74.40 78.12 15,419.70 505.80 15,925.50 5,511.48 O-BRITE PAINT COMPANY Deductions HI FIT SIT SUTA 20.42 32.63 17.69 19.58 33.46 17.40 20.88 29.73 14.62 17.73 45.00 135.00 107.00 39.00 191.00 127.00 49.00 175.00 97.00 153.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 224.12 1,118.00 474.52 10.82 21.95 32.63 17.69 19.58 33.46 17.40 24.01 29.73 14.62 17.73 55.00 135.00 107.00 39.00 191.00 127.00 69.00 175.00 97.00 153.00 46.47 69.08 37.45 41.45 70.85 36.84 50.84 62.94 30.95 37.55 1.06 1.58 0.85 0.95 1.62 0.84 1.16 1.44 0.71 0.86 228.79 1,148.00 484.40 11.04 20.42 32.63 17.69 19.58 45.00 135.00 107.00 117.00 43.23 69.08 37.45 41.45 0.99 1.58 0.85 0.95 33.46 16.97 20.88 29.73 14.62 17.51 191.00 98.00 49.00 249.00 97.00 150.00 70.85 35.92 44.21 62.94 30.95 37.08 1.62 0.82 1.01 1.44 0.71 0.85 223.47 1,238.00 473.13 10.79 30.15 331.00 63.84 1.46 30.15 331.00 63.84 1.46 16.33 32.63 17.69 19.58 33.46 16.97 20.88 29.73 14.62 17.00 64.00 107.00 81.00 86.00 98.00 29.00 249.00 97.00 34.58 69.08 37.45 41.45 70.85 35.92 44.21 62.94 30.95 0.79 1.58 0.85 0.95 1.62 0.82 1.01 1.44 0.71 201.87 828.00 427.41 9.75 23.48 32.63 18.56 19.58 33.46 18.27 20.62 29.73 14.62 15.66 65.00 64.00 116.00 81.00 109.00 113.00 27.00 175.00 97.00 109.00 49.71 69.08 39.30 41.45 70.85 38.68 43.66 62.94 30.95 33.16 1.13 1.58 0.90 0.95 1.62 0.88 1.00 1.44 0.71 0.76 226.59 956.00 479.75 10.94 34.71 1.68 34.71 0.00 0.00 1.68 25.01 32.63 17.63 19.58 33.46 23.62 29.73 13.60 80.00 64.00 104.00 81.00 109.00 67.00 175.00 85.00 52.95 69.08 37.33 41.45 70.85 50.01 62.94 28.80 1.21 1.58 0.85 0.95 1.62 1.14 1.44 0.66 17.40 18.27 127.00 136.00 36.84 38.68 0.84 0.88 230.92 1,028.00 488.91 11.15 ctions Net Paid CIT Group Ins. 54.92 87.76 47.58 52.66 90.01 46.80 56.17 79.96 39.32 47.71 Union Dues 8.00 672 673 674 675 676 677 678 679 680 681 8.00 602.88 0.00 16.00 59.04 87.76 47.58 52.66 90.01 46.80 64.59 79.96 39.32 47.71 16.50 26.40 14.40 15.90 27.00 14.10 16.80 24.00 11.70 14.40 8.00 615.42 181.20 16.00 54.92 87.76 47.58 52.66 Ck. SIMPLE No. 0.00 682 683 684 685 686 687 688 689 690 691 8.00 8.00 0.00 692 693 694 695 Amount 1,148.16 1,784.47 933.78 1,112.68 1,777.68 896.72 1,171.46 1,573.85 762.92 890.40 Taxable Earnings OASDI 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 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,052.11 15,456.77 15,456.77 1,211.75 1,758.07 919.38 1,096.78 1,750.68 882.62 1,318.93 1,549.85 751.22 876.00 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,115.26 15,778.37 15,778.37 1,148.16 1,784.47 933.78 1,034.68 1,408.00 2,250.00 1,220.00 1,350.00 1,408.00 2,250.00 1,220.00 1,350.00 FUTA Labor Cost Distribution SUTA Admin. Office Sales Plant 1,408.00 2,250.00 700.00 1,350.00 1,220.00 1,350.00 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 1,513.60 2,250.00 250.00 1,220.00 1,350.00 1,220.00 1,350.00 2,307.69 1,200.00 1,200.00 1,656.00 2,050.00 442.00 1,008.00 692.00 4,778.00 1,008.00 1,223.08 2,307.69 4,651.08 3,600.00 5,219.60 1,408.00 2,250.00 1,010.00 1,350.00 1,220.00 1,350.00 90.01 45.63 56.17 79.96 39.32 47.11 696 697 698 699 700 701 8.00 601.11 0.00 81.10 14.40 81.10 14.40 16.00 0.00 702 0.00 0.00 1,777.68 900.12 1,171.46 1,499.85 762.92 880.41 2,307.69 1,170.00 1,440.00 2,050.00 1,008.00 1,207.85 2,307.69 1,170.00 1,440.00 2,050.00 1,008.00 1,207.85 11,893.52 15,411.54 15,411.54 1,428.46 2,079.32 2,079.32 1,428.46 2,079.32 2,079.32 2,307.69 1,110.00 1,170.00 1,440.00 2,050.00 1,008.00 0.00 4,478.00 1,008.00 1,207.85 2,307.69 4,605.85 3,600.00 4,898.00 2,079.32 0.00 0.00 0.00 2,079.32 0.00 0.00 43.93 87.76 47.58 52.66 90.01 45.63 56.17 79.96 39.32 16.50 26.40 14.40 15.90 27.00 14.10 16.80 24.00 11.70 543.02 166.80 63.16 87.76 49.93 52.66 90.01 49.15 55.46 79.96 39.32 42.13 609.52 8.00 8.00 16.00 1,650.00 8.00 8.00 0.00 703 500.00 704 705 250.00 706 700.00 707 708 200.00 709 710 711 712 500.00 713 714 250.00 715 700.00 716 717 200.00 718 719 720 721 16.00 1,650.00 14.70 722 0.00 14.70 0.00 67.27 87.76 47.43 52.66 90.01 63.54 79.96 36.59 20.24 26.33 14.23 15.80 27.00 19.06 23.99 11.00 8.00 8.00 0.00 723 500.00 724 725 250.00 726 700.00 727 200.00 728 729 730 919.43 1,329.07 919.38 804.78 1,155.68 886.02 974.66 1,475.85 751.22 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 9,216.08 13,922.09 13,922.09 1,308.33 1,355.47 975.96 820.68 1,159.69 961.90 978.10 1,573.85 762.92 812.33 1,126.40 2,250.00 1,220.00 300.00 1,350.00 2,307.69 1,170.00 1,440.00 2,050.00 1,008.00 0.00 1,308.00 1,619.20 2,250.00 1,280.00 1,350.00 2,307.70 1,260.00 1,422.00 2,050.00 1,008.00 1,080.00 1,619.20 2,250.00 1,280.00 1,350.00 2,307.70 1,260.00 1,422.00 2,050.00 1,008.00 1,080.00 1,080.00 168.00 1,080.00 10,709.23 15,626.90 15,626.90 1,080.00 1,248.00 0.00 0.00 1,008.00 2,307.69 3,398.00 3,600.00 4,616.40 1,619.20 2,250.00 1,280.00 1,350.00 2,307.70 1,260.00 1,422.00 2,050.00 1,008.00 1,080.00 2,307.70 4,628.00 3,600.00 5,091.20 2,194.48 2,194.48 0.00 0.00 1,363.18 1,329.14 919.13 804.88 -3,391.41 1,095.63 1,549.86 704.20 1,724.80 2,250.00 1,216.00 1,350.00 2,307.70 1,629.00 2,050.00 938.00 1,724.80 2,250.00 1,216.00 1,350.00 2,307.70 1,629.00 2,050.00 938.00 0.00 0.00 0.00 0.00 1,724.80 2,250.00 1,216.00 1,350.00 2,307.70 1,629.00 2,050.00 938.00 46.80 49.15 14.04 14.74 621.16 186.43 731 732 16.00 1,650.00 882.68 924.16 1,200.00 1,260.00 1,200.00 1,260.00 1,200.00 1,260.00 1,200.00 1,260.00 6,181.46 15,925.50 15,925.50 2,460.00 2,460.00 1,200.00 1,260.00 2,307.70 3,354.00 4,860.00 5,403.80 Checkpoints Total earnings Net paid 15,456.77 12,052.01 Checkpoints Total earnings Net paid 15,778.37 12,115.19 Checkpoints Total earnings Net paid 15,411.54 11,893.42 Checkpoints Total earnings Net paid 2,079.32 1,428.45 Checkpoints Total earnings Net paid 13,922.09 9,216.00 Checkpoints Total earnings Net paid Checkpoints Total earnings Net paid Checkpoints Total earnings Net paid 2,394.00 2,194.48 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 RATE HOURLY RATE 20___ PAYDAY REGULAR EARNINGS HRS. RATE YEAR-TO-DATE 1 2 3 4 5 6 80 80 80 64 10/9 10/23 11/6 11/20 12/4 12/18 17.60 17.60 17.60 17.60 AMOUNT OVERTIME EARNINGS HRS. RATE 10,293.40 1,408.00 1,408.00 1,408.00 1,126.40 4 26.40 OVERTIME RATE CUMULATIVE EARNINGS AMOUNT 11,322.00 12,730.00 14,243.60 15,651.60 16,778.00 17.60 26.40 FICA 701.96 87.30 93.84 87.30 69.84 OTHER HI 164.17 20.42 21.95 20.42 16.33 QTR. TOT. YR. TOT. FIT SIT 810.00 45.00 55.00 45.00 17.00 65.00 80.00 307.00 1,117.00 SUTA 347.59 43.23 46.47 43.23 34.58 OCCUPATION WORKS IN (STATE) Sales Sales Manager PA SEX M F x S.S. ACCOUNT NO. NAME - LAST FERGUSON OTHER WEEKLY RATE HOURLY RATE OVERTIME RATE OVERTIME EARNINGS PAYDAY YEAR-TO-DATE 1 10/9 2 10/23 3 11/6 4 11/20 5 12/4 6 12/18 CUMULATIVE EARNINGS 80 80 80 80 RATE AMOUNT HRS. RATE 23,125.00 2,250.00 2,250.00 2,250.00 2,250.00 AMOUNT 1,433.75 139.50 139.50 139.50 139.50 OTHER HI 335.31 32.63 32.63 32.63 32.63 FIT 2,291.00 135.00 135.00 135.00 64.00 SIT SUTA 709.94 69.08 69.08 69.08 69.08 16.19 1.58 1.58 1.58 1.58 YR. TOT. Checkpoint OCCUPATION Checkpoint WORKS IN (STATE) SEX 5 FICA OASDI 23,125.00 25,375.00 27,625.00 29,875.00 32,125.00 W/H ALLOW. DEDUCTIONS QTR. TOT. DEPARTMENT 216.80 8.00 24.50 8.00 24.50 James $ 58,500 /yr. $ 1,125.00 $ 28.13 $ SALARY UNION DUES $88,000 -- $.30/M HRS. 441.60 54.92 59.04 54.92 43.93 DEDUCTIONS FIRST 000-00-8645 OTHER DEDUCTIONS INFORMATION REGULAR EARNINGS SIMPLE Checkpoint DEPARTMENT 20___ CIT 7.93 0.99 1.06 0.99 0.79 Checkpoint GROUP INSURANCE 4 DEDUCTIONS OASDI 1,028.60 0.00 105.60 0.00 0.00 0.00 0.00 W/H ALLOW. S.S. ACCOUNT NO. NAME - LAST FIRST CIT 901.97 87.76 87.76 87.76 87.76 SIMPLE DEDUCTIONS 132.30 26.40 500.00 26.40 M F Office Executive Secretary x PA 000-00-4567 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE FORD $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $50,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 AMOUNT 80 80 80 80 6,300.00 7,520.00 8,740.00 9,960.00 11,180.00 W/H ALLOW. 2 DEDUCTIONS FICA OASDI 6,300.00 1,220.00 1,220.00 1,220.00 1,220.00 YEAR-TO-DATE 1 CUMULATIVE Catherine 2,733.33 /mo. 640.00 16.00 24.00 390.60 75.64 75.64 75.64 75.64 OTHER HI 91.35 17.69 17.69 17.69 17.69 FIT 639.00 107.00 107.00 107.00 107.00 SIT SUTA 193.41 37.45 37.45 37.45 37.45 4.41 0.85 0.85 0.85 0.85 CIT SIMPLE 245.73 47.58 47.58 47.58 47.58 DEDUCTIONS 37.80 14.40 14.40 QTR. TOT. YR. TOT. Checkpoint Checkpoint OCCUPATION DEPARTMENT 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 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 80 80 80 RATE AMOUNT HRS. RATE 5,400.00 1,350.00 1,350.00 1,350.00 1,350.00 AMOUNT W/H ALLOW. 0 DEDUCTIONS FICA OASDI 5,400.00 6,750.00 8,100.00 9,450.00 10,800.00 Dewey 2,925 /mo. 675.00 16.88 334.80 83.70 83.70 83.70 83.70 OTHER HI 78.30 19.58 19.58 19.58 19.58 FIT 332.00 39.00 39.00 117.00 81.00 SIT SUTA 165.78 41.45 41.45 41.45 41.45 3.78 0.95 0.95 0.95 0.95 CIT 210.62 52.66 52.66 52.66 52.66 SIMPLE 31.50 15.90 250.00 TR. TOT. YR. TOT. Checkpoint DEPARTMENT OCCUPATION Checkpoint WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST DEDUCTIONS 15.90 Administrative M F 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 EARNINGS HRS. RATE 10/9 2 10/23 3 11/6 4 11/20 5 12/4 6 12/18 AMOUNT HRS. RATE AMOUNT 80 80 80 80 42,692.27 44,999.96 47,307.65 49,615.34 51,923.03 W/H ALLOW. 3 DEDUCTIONS FICA OASDI 42,692.27 2,307.69 2,307.69 2,307.69 2,307.69 YEAR-TO-DATE 1 CUMULATIVE Joseph 60,000 /yr. 1,153.85 28.85 2,646.92 143.08 143.08 143.08 143.08 OTHER HI 619.04 33.46 33.46 33.46 33.46 FIT 6,116.00 191.00 191.00 191.00 86.00 SIT SUTA 1,310.65 70.85 70.85 70.85 70.85 29.88 1.62 1.62 1.62 1.62 CIT 1,665.17 90.01 90.01 90.01 90.01 SIMPLE DEDUCTIONS 202.50 27.00 700.00 27.00 4,667.17 TR. TOT. YR. TOT. Checkpoint Checkpoint OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST M F Office Time Clerk x PA 000-00-6337 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE RUSSELL $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $49,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 80 78 78 RATE AMOUNT HRS. RATE 6,240.00 1,200.00 1,200.00 1,170.00 1,170.00 AMOUNT W/H ALLOW. 2 DEDUCTIONS FICA OASDI 6,240.00 7,440.00 8,640.00 9,810.00 10,980.00 Virginia 2,730 /mo. 630.00 15.75 23.63 386.88 74.40 74.40 72.54 72.54 OTHER HI 90.48 17.40 17.40 16.97 16.97 FIT 642.00 127.00 127.00 98.00 98.00 SIT SUTA 191.56 36.84 36.84 35.92 35.92 4.37 0.84 0.84 0.82 0.82 CIT SIMPLE 243.38 46.80 46.80 45.63 45.63 TR. TOT. YR. TOT. Checkpoint DEPARTMENT OCCUPATION Checkpoint WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST DEDUCTIONS 31.50 14.10 14.10 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 RATE HOURLY RATE 20___ REGULAR EARNINGS OVERTIME EARNINGS PAYDAY RATE YEAR-TO-DATE 10/9 2 10/23 3 11/6 4 11/20 5 12/4 6 12/18 CUMULATIVE EARNINGS HRS. 1 OVERTIME RATE 80 80 80 80 18.00 18.00 18.00 18.00 AMOUNT 13,287.50 1,440.00 1,440.00 1,440.00 1,440.00 HRS. RATE 8 27.00 AMOUNT 14,685.30 16,125.30 17,781.30 19,221.30 20,661.30 18.00 27.00 4 DEDUCTIONS FICA OASDI 1,397.80 0.00 216.00 0.00 0.00 0.00 0.00 W/H ALLOW. 910.49 89.28 102.67 89.28 89.28 OTHER HI 212.94 20.88 24.01 20.88 20.88 FIT 1,070.00 49.00 69.00 49.00 29.00 SIT SUTA 450.84 44.21 50.84 44.21 44.21 10.28 1.01 1.16 1.01 1.01 CIT 572.79 56.17 64.59 56.17 56.17 SIMPLE 200.00 DEDUCTIONS 235.70 8.00 24.80 8.00 24.80 QTR. TOT. YR. TOT. Checkpoint Checkpoint OCCUPATION DEPARTMENT WORKS IN (STATE) SEX 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 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 80 80 80 RATE AMOUNT HRS. RATE 16,650.00 2,050.00 2,050.00 2,050.00 2,050.00 AMOUNT ALLOW. 2 DEDUCTIONS FICA OASDI 16,650.00 18,700.00 20,750.00 22,800.00 24,850.00 W/H 1,025.00 25.63 1,032.30 127.10 127.10 127.10 127.10 OTHER HI 241.43 29.73 29.73 29.73 29.73 FIT 2,002.00 175.00 175.00 249.00 249.00 SIT SUTA 511.16 62.94 62.94 62.94 62.94 11.66 1.44 1.44 1.44 1.44 CIT SIMPLE 649.42 79.96 79.96 79.96 79.96 QTR. TOT. YR. TOT. Checkpoint DEPARTMENT OCCUPATION Checkpoint WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST DEDUCTIONS 94.50 24.00 24.00 M F Office Accounting Trainee PA Student OTHER DEDUCTIONS INFORMATION GROUP INSURANCE $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $39,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 72 72 72 72 HRS. RATE AMOUNT 14.00 14.00 14.00 14.00 5,550.00 6,558.00 7,566.00 8,574.00 9,582.00 14.00 21.00 1 DEDUCTIONS FICA OASDI 5,550.00 1,008.00 1,008.00 1,008.00 1,008.00 YEAR-TO-DATE 1 CUMULATIVE W/H ALLOW. 344.10 62.50 62.50 62.50 62.50 OTHER HI 80.48 14.62 14.62 14.62 14.62 FIT 409.00 97.00 97.00 97.00 97.00 SIT SUTA 170.38 30.95 30.95 30.95 30.95 3.89 0.71 0.71 0.71 0.71 CIT SIMPLE 216.47 39.32 39.32 39.32 39.32 DEDUCTIONS 32.40 11.70 11.70 QTR. TOT. YR. TOT. Checkpoint Checkpoint OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST M F Office Programmer x PA 000-00-6741 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE WILLIAMS $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $48,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/13 CUMULATIVE 80 80 79 136 RATE AMOUNT HRS. RATE AMOUNT Ruth 2,650 /mo. 611.54 15.29 22.94 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 153.00 153.00 150.00 331.00 314.98 37.55 37.55 37.08 63.84 7.18 0.86 0.86 0.85 1.46 400.18 47.71 47.71 47.11 81.10 59.40 5,733.33 15,993.33 5,733.33 15,993.33 355.47 991.59 83.13 231.90 787.00 2,393.00 176.01 490.99 4.01 11.19 223.62 623.80 28.80 88.20 14.40 14.40 5 6 QTR. TOT. YR. TOT. 375 Checkpoint 5,733.33 15,993.33 Checkpoint 4,075.26 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 RATE HOURLY RATE $47,000 -- $.30/M 20___ OVERTIME RATE 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. YR. TOT. 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 UNION DUES Young Paul $ $ $ $ SALARY OTHER WEEKLY RATE HOURLY RATE $49,000 -- $.30/M 20___ REGULAR EARNINGS OVERTIME RATE 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 YEAR-TO-DATE 1 2 3 4 5 6 12/18 QTR. TOT. YR. TOT. Checkpoint Checkpoint DEDUCTIONS 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 RATE HOURLY RATE OVERTIME RATE 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 RATE HOURLY RATE OVERTIME RATE 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 8,631.95 1,148.16 1,211.75 1,148.16 919.43 672 682 692 703 MIDDLE Claude MARITAL STATUS M NET PAID CK. NO. AMOUNT 673 683 693 704 MIDDLE 17,304.54 1,784.47 1,758.07 1,784.47 1,329.07 Louise MARITAL STATUS S NET PAID CK. NO. AMOUNT 4,697.70 933.78 919.38 933.78 919.38 674 684 694 705 MIDDLE Wilson MARITAL STATUS M NET PAID CK. NO. AMOUNT 675 685 695 706 MIDDLE 4,243.22 1,112.68 1,096.78 1,034.68 804.78 Tyler MARITAL STATUS M NET PAID CK. NO. AMOUNT 676 686 696 707 30,102.11 1,777.68 1,750.68 1,777.68 1,155.68 MIDDLE Aloise MARITAL STATUS S NET PAID CK. NO. AMOUNT 677 687 697 708 MIDDLE 4,649.83 896.72 882.62 900.12 886.02 Allen MARITAL STATUS M NET PAID CK. NO. AMOUNT 678 688 698 709 11,222.26 1,171.46 1,318.93 1,171.46 974.66 MIDDLE James MARITAL STATUS S NET PAID CK. NO. AMOUNT 679 689 699 710 MIDDLE 12,107.53 1,573.85 1,549.85 1,499.85 1,475.85 MARITAL STATUS S NET PAID CK. NO. AMOUNT 4,293.28 762.92 751.22 762.92 751.22 680 690 700 711 MIDDLE Virginia MARITAL STATUS S NET PAID CK. NO. AMOUNT 681 691 701 702 7,087.37 890.40 876.00 880.41 1,428.46 4,075.28 11,162.65 11,162.63 MIDDLE Anne MARITAL STATUS S NET PAID CK. NO. AMOUNT MIDDLE Winston MARITAL STATUS S NET PAID CK. NO. AMOUNT MIDDLE MARITAL STATUS NET PAID CK. NO. AMOUNT MIDDLE MARITAL STATUS NET PAID CK. NO. AMOUNT

Tutor Answer

(Top Tutor) Studypool Tutor
School: New York University
Studypool has helped 1,244,100 students
flag Report DMCA
Similar Questions
Hot Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors