Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

this is what I'm working on Part 1 - October 23rd Payroll; In the PR social security taxable earnings s/b = gross earnings; FUTA and

image text in transcribed

this is what I'm working on Part 1 - October 23rd Payroll; In the PR social security taxable earnings s/b = gross earnings; FUTA and SUTA taxable earnings are incorrect (s/b 860 and 3480, respectively). In the GJ the payroll taxes are incorrect for both FUTA and SUTA (s/b 5.16 and 128.01, respectively). Associated errors in the GL. Part 2 - November 6th Payroll and Special Williams Payroll; In the PR your taxable earnings for FUTA and SUTA are incorrect(s/b 370 and 2012.94, respectively) In the GJ SUTA and FUTA employer taxes are incorrect, the SIT payment on 11/4 s/b for 444.70 and the payments for SIT and CIT between 11/15 and 11/18 are missing. Associated errors in the GL, including significant errors in cash, OASDI, and departmental salaries.

,also off a little on dec 4th &18th fit taxes. Thanks, John

image text in transcribed Excel Instructions using Excel 2010: 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 11,097.25 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 3,353.08 3,600.00 4,902.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 CREDIT 1,231.14 11,097.25 878.09 205.37 965.00 434.82 9.94 556.30 16.00 11,097.25 878.09 205.36 19.68 128.01 20 SIT Taxes Payable Cash 25 11 434.82 23 Payroll Cash Cash 12 11,173.89 23 Administrative Salaries Office Salaries Sales Salaries Plant Wages FICA Taxes Payable - OASDI FICA Taxes Payable - HI 434.82 11,173.89 51 52 53 54 20.1 20.2 2,307.69 3,353.08 3,600.00 5,518.00 898.05 210.04 Page 42 JOURNAL DATE 20-- DESCRIPTION POST. REF. Employees FIT Payable Employees SIT Payable Employees SUTA Payable Employees CIT Payable Union Dues Payable Group Insurance Payable Payroll Cash Nov 24 25 25.1 26 28 27 12 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 DEBIT CREDIT 997.00 444.70 10.16 568.95 16.00 165.90 11,173.89 1,240.89 898.05 210.03 2.22 130.59 4 SIT Taxes Payable Cash 25 11 564.79 6 Union Dues Payable Cash 28 11 32.00 12 11 2,079.32 52 20.1 20.2 2,079.32 13 Payroll Cash Cash 13 Office Salaries FICA Taxes Payable - OASDI FICA Taxes Payable - HI 564.79 32.00 2,079.32 128.92 30.15 Page 43 JOURNAL DATE 20-- DESCRIPTION POST. REF. DEBIT Employees FIT Payable Employees SIT Payable Employees SUTA Payable Employees CIT Payable Group Insurance Payable Payroll Cash 13 Payroll Taxes FICA Taxes Payable -OASDI FICA Taxes Payable - HI 56 20.1 20.2 159.07 16 FICA Taxes Payable -OASDI FICA Taxes Payable - HI Employees FIT Payable Cash Dec 24 25 25.1 26 27 12 20.1 20.2 24 11 CREDIT 340.00 63.84 1.46 81.68 14.40 2,079.32 3,552.28 830.80 1,962.00 128.92 30.15 6,345.08 3 SIT Taxes Payable Cash 25 11 508.54 9 Union Dues Payable Cash 28 11 32.00 14 Payroll Taxes Payable Cash 56 11 508.54 32.00 Page 44 JOURNAL DATE 20-- DESCRIPTION 14 Payroll Taxes FICA Taxes Payable -OASDI FICA Taxes Payable - HI 15 15 18 18 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 GENERAL LEDGER ACCOUNT: Checkpoints CASH DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT CREDIT 20-- Oct. Nov Dec 1 Balance 9 23 4 6 13 16 3 9 ACCOUNT: a J41 J41 J41 J41 J41 J41 J41 J41 11,097.25 11,093.56 564.79 32.00 2,079.32 6,345.08 508.54 32.00 PAYROLL CASH DATE ITEM Nov 9 9 23 23 13 13 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Checkpoints ACCOUNT NO. 12 POST. REF. J41 J41 J41 J41 J41 Debit Balance BALANCE DEBIT CREDIT 11,097.25 11,097.25 11,173.89 11,173.89 2,079.32 2,079.32 Credit Balance 0.00 0.00 199,846.33 188,749.08 177,655.52 177,090.73 177,058.73 174,979.41 168,634.33 168,125.79 168,093.79 DEBIT 20-- Oct. Debit Balance ACCOUNT NO. 11 11,097.25 0.00 11,173.89 0.00 2,079.32 0.00 CREDIT Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance 0.00 0.00 ACCOUNT: FICA TAXES PAYABLE - OASDI DATE ITEM ACCOUNT NO. 20.1 POST. REF. BALANCE DEBIT CREDIT DEBIT CREDIT 20-- Oct. Nov 9 9 23 23 13 13 16 J41 J41 J41 J41 J41 J41 J41 878.09 878.09 898.05 898.05 128.92 128.92 3,552.28 878.09 1,756.18 2,654.23 3,552.28 3,681.20 3,810.12 257.84 Checkpoints Debit Credit Balance Balance Oct. 31, 20-0.00 3,552.28 Nov. 30, 20-0.00 Dec. 31, 20-- ACCOUNT: FICA TAXES PAYABLE - HI DATE ITEM ACCOUNT NO. 20.2 POST. REF. BALANCE DEBIT CREDIT DEBIT CREDIT 20-- Oct. Nov 9 9 23 23 13 13 16 J41 J41 J41 J41 J41 J41 J41 205.37 205.36 210.04 210.03 30.15 30.15 830.80 205.37 410.73 620.77 830.80 860.95 891.10 60.30 Checkpoints Debit Credit Balance Balance Oct. 31, 20-0.00 830.80 Nov. 30, 20-Dec. 31, 20-- ACCOUNT: FUTA TAXES PAYABLE DATE ITEM POST. REF. Debit Balance BALANCE DEBIT CREDIT DEBIT CREDIT 20-- Oct. 1 Balance 9 23 Checkpoints ACCOUNT NO. 21 a J41 J41 19.68 2.22 392.94 412.62 414.84 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance ACCOUNT: SUTA TAXES PAYABLE - EMPLOYER DATE ITEM POST. REF. Debit Balance BALANCE DEBIT CREDIT DEBIT CREDIT 20-- Oct. Nov 9 23 Checkpoints ACCOUNT NO. 22 J41 J41 128.01 130.59 128.01 258.60 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance ACCOUNT: EMPLOYEES FIT PAYABLE DATE ITEM ACCOUNT NO. 24 POST. REF. BALANCE DEBIT CREDIT DEBIT CREDIT 20-- Oct. Nov 9 23 13 16 J41 J41 J41 J41 965.00 997.00 340.00 1,962.00 965.00 1,962.00 2,302.00 340.00 Checkpoints Debit Credit Balance Balance Oct. 31, 20-0.00 1,962.00 Nov. 30, 20-Dec. 31, 20-- ACCOUNT: DATE EMPLOYEES SIT PAYABLE ITEM ACCOUNT NO. 25 POST. REF. BALANCE DEBIT CREDIT DEBIT CREDIT 20-- Oct. Nov Dec 9 20 SIT Taxes Payable 23 4 20 3 J41 J41 J41 J41 J41 J41 434.82 434.82 444.70 444.70 508.54 508.54 434.82 0.00 444.70 0.00 508.54 0.00 Checkpoints Debit Credit Balance Balance Oct. 31, 20-0.00 Nov. 30, 20-0.00 Dec. 31, 20-- ACCOUNT: EMPLOYEES SUTA PAYABLE DATE ITEM POST. REF. Debit Balance BALANCE DEBIT CREDIT DEBIT CREDIT 20-- Oct. Nov 9 23 13 Checkpoints ACCOUNT NO. 25.1 J41 J41 9.94 10.16 1.46 9.94 20.10 21.56 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance ACCOUNT: EMPLOYEES CIT PAYABLE DATE ITEM POST. REF. Debit Balance BALANCE DEBIT CREDIT DEBIT CREDIT 20-- Oct. Nov 9 23 13 Checkpoints ACCOUNT NO. 26 J41 J41 J41 556.30 568.95 81.68 556.30 1,125.25 1,206.93 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance ACCOUNT: GROUP INSURANCE PREMIUMS COLLECTED DATE ITEM POST. REF. Debit Balance BALANCE DEBIT CREDIT DEBIT CREDIT 20-- Nov 23 13 27 27 Checkpoints ACCOUNT NO. 27 165.90 14.40 165.90 180.30 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance ACCOUNT: UNION DUES PAYABLE DATE ITEM Checkpoints ACCOUNT NO. 28 POST. REF. Debit Balance BALANCE DEBIT CREDIT DEBIT CREDIT 20-- Oct. Nov 9 23 6 J41 J41 J41 16.00 16.00 32.00 16.00 32.00 0.00 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- 0.00 Credit Balance 32.00 ACCOUNT: DATE 20-- SIMPLE CONTRIBUTIONS PAYABLE ITEM Checkpoints ACCOUNT NO. 29 POST. REF. Debit Balance BALANCE DEBIT CREDIT DEBIT CREDIT Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance ACCOUNT: ADMINISTRATIVE SALARIES DATE ITEM POST. REF. 1 Balance 9 23 a J41 Debit Balance BALANCE DEBIT CREDIT DEBIT 20-- Oct. Checkpoints ACCOUNT NO. 51 2,307.69 2,307.69 42,692.27 44,999.96 47,307.65 CREDIT Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance ACCOUNT: OFFICE SALARIES DATE ITEM POST. REF. Nov 1 Balance 9 23 13 a J41 Debit Balance BALANCE DEBIT CREDIT DEBIT 20-- Oct. Checkpoints ACCOUNT NO. 52 3,353.08 3,353.08 2,079.32 28,350.00 31,703.08 35,056.16 37,135.48 CREDIT Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance ACCOUNT: SALES SALARIES DATE ITEM POST. REF. 1 Balance 9 23 a J41 Debit Balance BALANCE DEBIT CREDIT DEBIT 20-- Oct. Checkpoints ACCOUNT NO. 53 3,600.00 3,600.00 28,525.00 32,125.00 35,725.00 CREDIT Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance ACCOUNT: PLANT WAGES DATE ITEM POST. REF. 1 Balance 9 23 a J41 Debit Balance BALANCE DEBIT CREDIT DEBIT 20-- Oct. Checkpoints ACCOUNT NO. 54 4,902.00 5,518.00 42,657.30 47,559.30 53,077.30 CREDIT Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance ACCOUNT: PAYROLL TAXES DATE ITEM POST. REF. DEBIT Nov 1 Balance 9 23 13 a J41 J41 J41 1,231.14 1,240.89 159.07 Debit Balance BALANCE CREDIT DEBIT 20-- Oct. Checkpoints ACCOUNT NO. 56 14,013.23 15,244.37 16,485.26 16,644.33 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 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.65 80 80 80 80 80 80 18.00 80 72 7.50 80 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.65 80 80 80 80 80 80 18.00 80 72 7.50 80 Rate Per Hrs. Hour Amount Deductions Total Earnings OASDI HI FIT SIT SUTA 1,412.00 2,250.00 900.00 1,350.00 2,307.69 690.00 1,440.00 2,050.00 540.00 1,223.08 1,412.00 2,250.00 900.00 1,350.00 2,307.69 690.00 1,440.00 2,050.00 540.00 1,223.08 87.54 139.50 55.80 83.70 143.08 42.78 89.28 127.10 33.48 75.83 20.47 32.63 13.05 19.58 33.46 10.01 20.88 29.73 7.83 17.73 49.00 143.00 62.00 43.00 197.00 51.00 53.00 180.00 32.00 155.00 43.35 69.08 27.63 41.45 70.85 21.18 44.21 62.94 16.58 37.55 0.99 1.58 0.63 0.95 1.62 0.48 1.01 1.44 0.38 0.86 14,162.77 878.09 205.37 965.00 434.82 9.94 1,517.92 2,250.00 900.00 1,350.00 2,307.69 690.00 1,656.00 2,050.00 540.00 1,223.08 94.11 139.50 55.80 83.70 143.08 42.78 102.67 127.10 33.48 75.83 22.01 32.63 13.05 19.58 33.46 10.01 24.01 29.73 7.83 17.73 59.00 143.00 62.00 43.00 197.00 51.00 75.00 180.00 32.00 155.00 46.60 69.08 27.63 41.45 70.85 21.18 50.84 62.94 16.58 37.55 1.06 1.58 0.63 0.95 1.62 0.48 1.16 1.44 0.38 0.86 321.92 14,484.69 898.05 210.04 997.00 444.70 10.16 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.65 80 80 80 80 78 80 18.00 80 72 7.50 79 1,412.00 2,250.00 900.00 1,350.00 2,307.69 672.94 1,440.00 2,050.00 540.00 1,207.85 1,412.00 2,250.00 900.00 1,350.00 2,307.69 672.94 1,440.00 2,050.00 540.00 1,207.85 87.54 139.50 55.80 83.70 143.08 41.72 89.28 127.10 33.48 74.89 20.47 32.63 13.05 19.58 33.46 9.76 20.88 29.73 7.83 17.51 49.00 143.00 62.00 120.00 197.00 29.00 53.00 260.00 32.00 152.00 43.35 69.08 27.63 41.45 70.85 20.66 44.21 62.94 16.58 37.08 0.99 1.58 0.63 0.95 1.62 0.47 1.01 1.44 0.38 0.85 TOTALS 14,130.48 14,130.48 876.09 204.90 1,097.00 433.83 9.92 Payday, November 13, 20-- For Period Ending November 14, 20-Williams, R. s 0 6 8 7 7 6 D D 8 6 8 56 D Discharged TOTALS 2,079.32 2,079.32 128.92 30.15 332.98 63.84 1.46 2,079.32 2,079.32 128.92 30.15 332.98 63.84 1.46 1,412.00 2,250.00 900.00 1,350.00 2,307.69 690.00 1,440.00 2,050.00 540.00 1,223.08 4 26.48 105.92 8 27.00 216.00 14,162.77 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 O'Neill, J. m 3 8 8 8 8 8 Russell, V. s 2 8 8 8 8 6 Ryan, N. m 4 8 8 8 8 8 Sokowski, T. s 2 8 8 8 8 8 (Student) s 1 8 8 8 8 4 Williams, R. s 0 8 8 8 7 8 Amount Overtime Earnings 14,162.77 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. D 2 4 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 GLO-BRITE PAINT COMPANY 27.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, November 20, 20-- For Period Ending November 14, 20-Bonno, A. m 4 8 8 8 8 8 0 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 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 4 64 17.65 80 80 80 80 78 80 18.00 80 72 7.50 Amount Total Earnings OASDI HI FIT SIT SUTA 8 8 8 D 72 TOTALS 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 92 17.65 80 80 80 80 87 18.00 80 71 7.50 80 80 1,129.60 2,250.00 900.00 1,350.00 2,307.69 672.94 1,440.00 2,050.00 540.00 1,129.60 2,250.00 900.00 1,350.00 2,307.69 672.94 1,440.00 2,050.00 540.00 70.04 139.50 55.80 83.70 143.08 41.72 89.28 127.10 33.48 16.38 32.63 13.05 19.58 33.46 9.76 20.88 29.73 7.83 21.00 68.00 62.00 84.00 92.00 29.00 33.00 260.00 32.00 34.68 69.08 27.63 41.45 70.85 20.66 44.21 62.94 16.58 0.79 1.58 0.63 0.95 1.62 0.47 1.01 1.44 0.38 12,640.23 783.70 183.30 681.00 388.08 8.87 1,694.40 2,250.00 960.00 1,350.00 2,307.69 750.00 1,449.00 2,050.00 540.00 1,080.00 105.05 139.50 59.52 83.70 143.08 46.50 89.84 127.10 33.48 66.96 24.57 32.63 13.92 19.58 33.46 10.88 21.01 29.73 7.83 15.66 62.00 68.00 71.00 84.00 92.00 38.00 33.00 260.00 32.00 134.00 52.02 69.08 29.47 41.45 70.85 23.03 44.48 62.94 16.58 33.16 1.19 1.58 0.67 0.95 1.62 0.53 1.01 1.44 0.38 0.76 363.40 14,431.09 894.73 209.27 874.00 443.06 10.13 1,425.16 1,425.16 88.36 20.66 0.00 1.00 1,425.16 88 17.65 80 80 80 80 80 79 18.00 80 72 7.50 72 TOTALS TOTALS Rate Per Hrs. Hour Deductions 14,067.69 Payday, December 4, 20-- For Period Ending November 28, 20-Bonno, A. m 5 8 8 8 8 8 8 8 8 8 H 8 Ferguson, J. m 5 8 8 8 8 8 8 8 8 H 8 Ford, C. s 2 8 8 8 8 8 8 8 8 H 8 Mann, D. m 0 8 8 8 8 8 8 8 8 H 8 O'Neill, J. m 3 8 8 8 8 8 8 8 8 H 8 Russell, V. s 2 8 8 8 8 8 8 8 8 H 8 Ryan, N. m 4 8 8 8 4 8 9 10 8 H 8 Sokowski, T. s 2 8 8 8 8 8 8 8 8 H 8 (Student) s 1 8 8 8 4 8 8 8 8 H 4 Woods, B. s 0 0 8 8 8 8 8 8 8 H 8 Payday, December 18, 20-- For Period Ending December 12, 20-Bonno, A. m 5 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 8 Mann, D. m 0 8 8 8 8 8 8 O'Neill, J. m 4 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 0 8 8 8 8 8 8 Young, P. s 1 8 8 8 8 8 8 Amount Overtime Earnings 12,640.23 TOTALS Payday, December 14, 20-- For Period Ending December 12, 20-Russell, V. s 2 8 8 8 8 8 8 GLO-BRITE PAINT COMPANY 1,425.16 88.36 20.66 0.00 1.00 1,835.60 113.81 2,250.00 139.50 960.00 59.52 1,350.00 83.70 62,307.69 3,687.08 189.00 1,629.00 101.00 2,050.00 127.10 532.50 33.02 1,200.00 74.40 807.70 50.08 26.62 32.63 13.92 19.58 903.46 23.62 29.73 7.72 17.40 11.71 80.00 56.35 68.00 69.08 71.00 29.47 84.00 41.45 20,712.20 1,912.85 51.00 50.01 260.00 62.94 30.00 16.35 152.00 36.84 69.00 24.80 1.28 1.58 0.67 0.95 43.62 1.14 1.44 0.37 0.84 0.57 612.60 74,922.49 4,469.21 1,086.39 21,577.20 2,300.14 52.46 1,412.00 2,250.00 960.00 1,350.00 2,307.69 750.00 1,368.00 2,050.00 540.00 1,080.00 1,412.00 2,250.00 960.00 1,350.00 62,307.69 1,440.00 2,050.00 532.50 1,200.00 807.70 74,309.89 8 35.30 282.40 3 27.00 81.00 12 35.30 7 27.00 423.60 0.00 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. 0.00 16.00 672 673 674 675 676 677 678 679 680 681 568.95 165.90 16.00 555.03 0.00 16.00 FUTA SUTA Admin. Office Sales Plant 1,147.19 1,775.83 705.54 1,108.29 1,771.03 537.45 1,167.06 1,568.27 428.52 888.07 1,412.00 2,250.00 900.00 1,350.00 2,307.69 690.00 1,440.00 2,050.00 540.00 1,223.08 1,412.00 2,250.00 900.00 1,350.00 2,307.69 690.00 1,440.00 2,050.00 540.00 1,223.08 1,412.00 2,250.00 700.00 1,350.00 900.00 1,350.00 Total earnings Net paid 14,162.77 11,097.25 900.00 1,350.00 2,307.69 690.00 690.00 690.00 1,440.00 2,050.00 540.00 540.00 540.00 1,223.08 14,162.77 3,280.00 3,480.00 2,307.69 3,353.08 3,600.00 4,902.00 1,517.92 1,749.43 900.00 1,350.00 2,307.69 690.00 1,656.00 2,050.00 540.00 1,223.08 1,517.92 1,749.43 900.00 1,350.00 2,307.69 690.00 1,656.00 2,050.00 540.00 1,223.08 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 370.00 0.00 0.00 0.00 400.00 400.00 0.00 879.96 0.00 0.00 1,870.00 0.00 1,412.00 11,173.89 13,984.12 13,984.12 370.00 3,549.96 Checkpoints 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.46 8.00 Ferguson, J. 88.38 Ford, C. 35.35 Mann, D. 53.03 O'Neill, J. 90.65 Russell, V. 26.43 Ryan, N. 56.56 8.00 Sokowski, T. 80.52 (Student) 21.21 Williams, R. 47.44 TOTALS HI 11,097.25 14,162.77 0.00 Payday, October 23, 20-- For Period Ending October 17, 20-Bonno, A. 59.62 16.50 8.00 Ferguson, J. 88.38 26.40 Ford, C. 35.35 10.50 Mann, D. 53.03 15.90 O'Neill, J. 90.65 27.00 Russell, V. 27.10 8.10 Ryan, N. 65.05 16.80 8.00 Sokowski, T. 80.52 24.00 (Student) 21.21 6.30 Williams, R. 48.04 14.40 TOTALS OASDI Labor Cost Distribution Checkpoints For Period Ending October 3, 20-55.46 8.00 88.38 35.35 53.03 90.65 27.10 56.56 8.00 80.52 21.21 48.04 556.30 Amount Taxable Earnings 1,211.02 1,749.43 695.04 1,092.39 1,744.03 529.35 1,312.47 1,544.27 422.22 873.67 2,250.00 Total earnings Net paid 14,484.69 11,173.89 900.00 1,350.00 2,307.00 690.00 1,656.00 2,050.00 540.00 1,223.08 2,307.00 3,353.08 3,600.00 5,118.00 Checkpoints 692 693 694 695 696 697 698 699 700 701 0.00 Payday, November 13, 20-- For Period Ending November 14, 20-Williams, R. 81.68 14.40 702 D TOTALS 81.68 14.40 0.00 0.00 1,147.19 1,775.83 705.54 1,031.29 1,771.03 544.90 1,167.06 1,488.27 428.52 878.08 1,412.00 2,250.00 900.00 1,350.00 2,307.69 672.94 1,440.00 2,050.00 540.00 1,207.85 1,412.00 2,250.00 900.00 1,350.00 2,307.69 672.94 1,440.00 2,050.00 540.00 1,207.85 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 207.02 0.00 0.00 1,330.00 0.00 10,937.71 14,130.48 14,130.48 0.00 1,537.02 1,412.00 2,250.00 Total earnings Net paid 14,130.48 10,937.71 900.00 1,350.00 2,307.00 690.00 1,440.00 2,050.00 540.00 1,207.85 2,307.00 3,337.85 3,600.00 4,902.00 Checkpoints 1,425.89 2,079.32 2,079.32 0.00 0.00 2,079.32 1,425.89 2,079.32 2,079.32 0.00 0.00 0.00 2,079.32 Total earnings Net paid 0.00 0.00 2,079.32 1,418.87 Deductions NAME Net Paid CIT Group Ins. Union Dues Ck. SIMPLE No. Payday, November 20, 20-- For Period Ending November 14, 20-Bonno, A. 44.37 16.50 8.00 Ferguson, J. 88.38 26.40 500.00 Ford, C. 35.35 10.50 Mann, D. 53.03 15.90 250.00 O'Neill, J. 90.65 27.00 700.00 Russell, V. 26.43 8.10 Ryan, N. 56.56 16.80 8.00 200.00 Sokowski, T. 80.52 24.00 (Student) 21.21 6.30 TOTALS 496.50 151.50 TOTALS 566.86 0.00 0.00 8.70 0.00 Payday, December 18, 20-- For Period Ending December 12, 20-Bonno, A. 72.10 16.50 9.00 Ferguson, J. 88.38 26.40 500.00 Ford, C. 37.71 11.10 Mann, D. 53.03 15.90 250.00 O'Neill, J. 2,447.45 27.00 4,000.00 Ryan, N. 63.99 16.80 9.00 200.00 Sokowski, T. 80.52 24.00 (Student) 20.92 6.30 Woods, B. 47.14 14.10 Young, P. 31.73 9.60 TOTALS 2,942.97 167.70 18.00 4,950.00 FUTA SUTA Admin. Office Sales Plant 917.84 1,324.43 695.04 801.39 1,149.03 536.80 970.26 1,464.27 422.22 1,129.60 2,250.00 900.00 1,350.00 2,307.69 672.94 1,440.00 2,050.00 540.00 1,129.60 2,250.00 900.00 1,350.00 2,307.69 672.94 1,440.00 2,050.00 540.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 790.00 Total earnings Net paid 2,307.69 12,640.23 0.00 790.00 2,307.69 1,212.94 3,600.00 3,490.00 1,694.40 2,250.00 960.00 1,350.00 2,307.69 750.00 1,449.00 2,050.00 540.00 1,080.00 1,694.40 2,250.00 960.00 1,350.00 2,307.69 750.00 1,449.00 2,050.00 540.00 1,080.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 9,767.04 14,431.09 14,431.09 0.00 0.00 0.00 0.00 1,425.16 0.00 1,425.16 2,250.00 12,640.23 8,281.28 1,350.00 672.94 1,440.00 2,050.00 540.00 Checkpoints 712 713 714 715 716 717 718 719 720 721 16.00 1,650.00 0.00 HI 8,281.28 12,640.23 Payday, December 14, 20-- For Period Ending December 12, 20-Russell, V. 8.70 0.00 722 TOTALS OASDI Labor Cost Distribution Checkpoints 703 704 705 706 707 708 709 710 711 16.00 1,650.00 Payday, December 4, 20-- For Period Ending November 28, 20-Bonno, A. 66.56 8.00 Ferguson, J. 88.38 500.00 Ford, C. 37.71 Mann, D. 53.03 250.00 O'Neill, J. 90.65 700.00 Russell, V. 29.46 Ryan, N. 56.92 8.00 200.00 Sokowski, T. 80.52 (Student) 21.21 Woods, B. 42.42 Amount Taxable Earnings 1,375.01 1,350.83 747.71 817.29 1,176.03 601.60 994.74 1,488.27 428.52 787.04 Total earnings Net paid 2,250.00 14,431.09 1,350.00 2,307.69 1,440.00 2,050.00 540.00 1,080.00 2,307.69 1,620.00 3,600.00 3,490.00 Checkpoints 1,306.44 88.36 1,306.44 88.36 0.00 0.00 0.00 723 1,459.94 1,835.60 724 1,324.43 2,250.00 725 736.61 960.00 726 801.39 1,350.00 727 28,574.03 62,307.69 728 1,112.44 1,629.00 729 1,464.27 2,050.00 730 417.82 532.50 731 857.28 1,200.00 732 610.21 807.70 1,835.60 2,250.00 960.00 1,350.00 62,307.69 1,629.00 2,050.00 532.50 1,200.00 807.70 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 37,358.42 74,922.49 74,922.49 0.00 0.00 Total earnings Net paid 0.00 0.00 Checkpoints Total earnings Net paid 0.00 0.00 0.00 0.00 1,425.16 1,306.44 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 RAT HOURLY RATE $55,000 --$.30/M 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 88 92 484 OVERTIME EARNINGS HRS. RATE 10,293.40 1,412.00 1,412.00 1,412.00 1,129.60 1,553.20 1,623.80 8,542.60 18,836.00 YEAR-TO-DATE 1 $9 Union Dues 17.65 17.65 17.65 17.65 17.65 17.65 YR. TOT. 4 26.48 8 12 35.30 35.30 OVERTIME R CUMULATIVE EARNINGS AMOUNT 11,322.00 12,734.00 14,251.92 15,663.92 16,793.52 18,629.12 20,676.52 9,354.52 20,676.52 17.65 26.48 OCCUPATION WORKS IN (STATE) Sales Sales Manager PA 701.96 87.54 94.11 87.54 70.04 113.81 126.94 579.98 1,281.94 164.17 20.47 22.01 20.47 16.38 26.62 29.69 135.64 299.81 SEX M F x S.S. ACCOUNT NO. 000-00-8645 FIT SIT 810.00 49.00 49.00 49.00 21.00 62.00 80.00 310.00 1,120.00 SUTA 347.59 43.35 46.60 43.35 34.68 56.35 62.86 287.19 634.78 NAME - LAST UNION DUES FERGUSON $ $ $ $ OTHER WEEKLY RAT 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 80 80 80 80 80 80 480 28.13 28.13 28.13 28.13 28.13 AMOUNT HRS. RATE 23,125.00 2,250.00 2,250.00 2,250.00 2,250.00 2,250.00 2,250.00 13,500.00 36,625.00 Checkpoint CIT 7.93 0.99 1.06 0.99 0.79 1.28 1.43 6.54 14.47 SIMPLE 444.73 55.46 59.62 55.46 44.37 72.10 80.42 367.43 812.16 CK. DEDUCTIONS NO. 216.80 8.00 24.50 8.00 24.50 8.00 25.50 98.50 315.30 FIRST SALARY $88,000 -- $.30/M RATE M NET PAID OTHER HI HOURLY RATE HRS. 5 FICA OTHER DEDUCTIONS INFORMATION REGULAR EARNINGS STATUS AMOUNT 672 682 692 703 712 723 8,628.82 1,147.19 1,221.02 1,147.19 917.84 1,495.44 1,640.56 7,569.24 16,198.06 Checkpoint DEPARTMENT 20___ MARITAL ALLOW. Checkpoint GROUP INSURANCE Victor W/H DEDUCTIONS OASDI 1,028.60 0.00 105.92 0.00 0.00 282.40 423.60 811.92 1,840.52 MIDDLE AMOUNT James 58,500 /yr. 1,125.00 28.13 Claude W/H MARITAL ALLOW. STATUS 5 M DEDUCTIONS NET PAID FICA OASDI 23,125.00 25,375.00 27,625.00 29,875.00 32,125.00 34,375.00 36,625.00 13,500.00 36,625.00 MIDDLE 1,433.75 139.50 139.50 139.50 139.50 139.50 139.50 837.00 2,270.75 OTHER HI 335.31 32.63 32.63 32.63 32.63 32.63 32.63 195.78 531.09 FIT 2,291.00 143.00 143.00 143.00 48.00 68.00 68.00 613.00 2,904.00 SIT SUTA 709.94 69.08 69.08 69.08 69.08 69.08 69.08 414.48 1,124.42 Checkpoint 16.19 1.58 1.58 1.58 1.58 1.58 1.58 9.48 25.67 CIT 908.35 88.38 88.38 88.38 88.38 88.38 88.38 530.28 1,438.63 SIMPLE CK. DEDUCTIONS NO. AMOUNT 132.30 26.40 500.00 500.00 500.00 1,500.00 1,500.00 26.40 26.40 79.20 211.50 673 683 693 704 713 724 17,298.16 1,775.83 1,749.43 1,775.83 1,344.43 1,350.83 1,324.43 9,320.78 26,618.94 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 RAT HOURLY RATE $37,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 QTR. TOT. 80 80 80 80 80 80 480 HRS. RATE AMOUNT 11.25 11.25 12.00 12.00 12.00 YR. TOT. 6,300.00 7,200.00 8,100.00 9,000.00 9,960.00 10,920.00 11,880.00 5,580.00 11,880.00 MARITAL ALLOW. STATUS 2 S NET PAID FICA 390.60 55.80 55.80 55.80 59.52 59.52 59.52 345.96 736.56 OTHER HI 91.35 13.05 13.05 13.05 13.92 13.92 13.92 80.91 172.26 FIT 639.00 62.00 62.00 62.00 71.00 71.00 71.00 399.00 1,038.00 SIT SUTA 193.41 27.63 27.63 27.63 29.47 29.47 29.47 171.30 364.71 4.41 0.63 0.63 0.63 0.67 0.67 0.67 3.90 8.31 Checkpoint CIT SIMPLE CK. DEDUCTIONS NO. 247.46 35.35 35.35 35.35 37.71 37.71 37.71 219.18 466.64 AMOUNT 37.80 4,695.97 705.54 695.04 705.54 736.61 747.71 736.61 4,327.05 9,023.02 674 684 694 705 714 725 10.50 11.10 11.10 32.70 70.50 Checkpoint OCCUPATION DEPARTMENT Louise W/H DEDUCTIONS OASDI 6,300.00 900.00 900.00 900.00 960.00 960.00 960.00 5,580.00 11,880.00 YEAR-TO-DATE 1 CUMULATIVE Catherine 2,085 /mo. 480.00 12.00 18.00 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 RAT HOURLY RATE $53,000 -- $.30/M 20___ OVERTIME R 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 R. TOT. R. TOT. CUMULATIVE 80 80 80 80 80 80 480 16.88 16.88 16.88 16.88 16.88 AMOUNT HRS. RATE 5,400.00 1,350.00 1,350.00 1,350.00 1,350.00 1,350.00 1,350.00 8,100.00 13,500.00 Checkpoint AMOUNT Wilson W/H MARITAL ALLOW. STATUS 0 M DEDUCTIONS NET PAID 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 13,500.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 837.00 OTHER HI 78.30 19.58 19.58 19.58 19.58 19.58 19.58 117.48 195.78 FIT 332.00 43.00 43.00 120.00 84.00 84.00 84.00 458.00 790.00 SIT 165.78 41.45 41.45 41.45 41.45 41.45 41.45 248.70 414.48 SUTA 3.78 0.95 0.95 0.95 0.95 0.95 0.95 5.70 9.48 CIT 212.11 53.03 53.03 53.03 53.03 53.03 53.03 318.18 530.29 SIMPLE CK. DEDUCTIONS NO. AMOUNT 31.50 15.90 250.00 250.00 250.00 750.00 750.00 Checkpoint 15.90 15.90 47.70 79.20 675 685 695 706 715 726 4,241.73 1,108.29 1,092.39 1,031.29 801.39 817.29 801.39 5,652.04 9,893.77 OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST Administrative President x PA 000-00-1534 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE O'NEILL $ $ $ $ SALARY UNION DUES OTHER WEEKLY RAT HOURLY RATE $90,000 -- $.30/M 20___ OVERTIME R REGULAR EARNINGS OVERTIME EARNINGS PAYDAY RATE YEAR-TO-DATE 10/23 3 11/6 4 11/20 5 12/4 6 80 80 80 80 80 80 480 10/9 2 12/18 R. TOT. CUMULATIVE EARNINGS HRS. 1 MIDDLE M F 28.85 28.85 28.85 28.28 28.28 R. TOT. AMOUNT HRS. RATE AMOUNT 42,692.27 44,999.96 47,307.65 49,615.34 51,923.03 54,230.72 116,538.41 73,846.14 116,538.41 MARITAL ALLOW. STATUS 3 M NET PAID FICA OTHER HI 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,687.08 903.46 4,402.48 1,070.76 7,049.40 1,689.80 FIT 6,116.00 197.00 197.00 197.00 92.00 92.00 20,712.20 21,487.20 27,603.20 SIT SUTA 1,310.65 70.85 70.85 70.85 70.85 70.85 1,912.85 2,267.10 3,577.75 29.88 1.62 1.62 1.62 1.62 1.62 43.62 51.72 81.60 Checkpoint CIT 1,676.95 90.65 90.65 90.65 90.65 90.65 2,447.45 2,900.70 4,577.65 SIMPLE CK. DEDUCTIONS NO. AMOUNT 202.50 676 686 696 707 716 727 27.00 700.00 700.00 4,000.00 5,400.00 5,400.00 27.00 27.00 81.00 283.50 30,090.33 1,771.03 1,744.03 1,771.03 1,149.03 1,176.03 28,574.03 36,185.18 66,275.51 Checkpoint OCCUPATION DEPARTMENT Tyler W/H DEDUCTIONS OASDI 42,692.27 2,307.69 2,307.69 2,307.69 2,307.69 2,307.69 62,307.69 73,846.14 116,538.41 Joseph 60,000 /yr. 1,153.85 28.85 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 RAT HOURLY RATE $29,000 -- $.30/M 20___ OVERTIME R 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/14 R. TOT. R. TOT. CUMULATIVE 80 80 78 78 80 72 468 8.63 8.63 9.38 9.39 9.38 AMOUNT HRS. RATE 6,240.00 690.00 690.04 672.94 731.44 750.00 1,425.16 4,959.58 11,199.58 Checkpoint AMOUNT Aloise W/H MARITAL ALLOW. STATUS 2 S DEDUCTIONS NET PAID FICA OASDI 6,240.00 6,930.00 7,620.04 8,292.98 9,024.42 9,774.42 11,199.58 4,959.58 11,199.58 Virginia 1,625 /mo. 375.00 9.38 14.07 386.88 42.78 42.78 41.72 45.35 46.50 88.36 307.49 694.37 OTHER HI 90.48 10.01 10.01 9.76 10.61 10.88 20.66 71.93 162.41 FIT 642.00 51.00 51.00 29.00 35.00 38.00 140.00 344.00 986.00 SIT 191.56 21.18 21.18 20.66 22.46 23.03 0.00 108.51 300.07 SUTA 4.37 0.48 0.48 0.47 0.51 0.53 1.00 3.47 7.84 CIT SIMPLE 245.11 27.10 27.10 26.43 28.73 29.46 138.82 383.93 Checkpoint CK. DEDUCTIONS NO. AMOUNT 31.50 8.10 8.70 8.70 25.50 57.00 677 687 607 708 717 722 4,648.10 537.45 529.39 544.90 580.08 601.60 1,166.44 3,959.86 8,607.96 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 RAT HOURLY RATE $56,000 -- $.30/M 20___ $9 Union Dues REGULAR EARNINGS OVERTIME EARNINGS PAYDAY EARNINGS HRS. 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 21,855.50 YEAR-TO-DATE 1 10/9 2 10/23 3 11/6 4 11/20 5 12/4 6 12/18 QTR. TOT. OVERTIME R CUMULATIVE 80 80 80 80 76 80 476 18.00 18.00 18.00 18.00 18.00 18.00 YR. TOT. HRS. RATE 8 27.00 3 7 27.00 27.00 AMOUNT 14,685.30 16,125.30 17,781.30 19,221.30 20,661.30 22,110.30 23,739.30 9,054.00 23,739.30 ALLOW. 18.00 27.00 STATUS 4 M NET PAID FICA 910.49 89.28 102.67 89.28 89.28 89.84 101.00 561.35 1,471.84 OTHER HI 212.94 20.88 24.01 20.88 20.88 21.01 23.62 131.28 344.22 FIT 1,070.00 53.00 49.00 53.00 25.00 33.00 51.00 264.00 1,334.00 SIT SUTA 450.84 44.21 50.84 44.21 44.21 44.48 50.01 277.96 728.80 10.28 1.01 1.16 1.01 1.01 1.01 1.14 6.34 16.62 Checkpoint CIT 576.84 56.56 65.05 56.56 56.56 56.92 63.99 355.64 932.48 SIMPLE 200.00 200.00 200.00 600.00 600.00 CK. DEDUCTIONS NO. 235.70 8.00 24.80 8.00 24.80 8.00 25.80 99.40 335.10 AMOUNT 678 688 698 709 718 728 11,218.21 1,167.06 1,338.47 1,167.06 978.26 994.74 1,112.44 6,758.03 17,976.24 Checkpoint OCCUPATION DEPARTMENT MARITAL DEDUCTIONS OASDI 1,397.80 0.00 216.00 0.00 0.00 81.00 189.00 486.00 1,883.80 Allen W/H WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST 000-00-8832 FIRST SOKOWSKI MIDDLE M F Plant Supervisor x PA OTHER DEDUCTIONS INFORMATION GROUP INSURANCE Thomas $ $ $ $ SALARY UNION DUES OTHER WEEKLY RAT HOURLY RATE $80,000 -- $.30/M 20___ OVERTIME R 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 QTR. TOT. YR. TOT. CUMULATIVE 80 80 25.63 80 25.63 80 25.63 80 25,63 80 25.63 480 AMOUNT HRS. RATE 16,650.00 2,050.00 2,050.00 2,050.00 2,050.00 2,050.00 2,050.00 12,300.00 28,950.00 Checkpoint AMOUNT MARITAL ALLOW. 1,025.00 25.63 STATUS 2 S DEDUCTIONS NET PAID 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 28,950.00 James W/H 1,032.30 127.10 127.10 127.10 127.10 127.10 127.10 762.60 1,794.90 OTHER HI 241.43 29.73 29.73 29.73 29.73 29.73 29.73 178.38 419.81 FIT 2,002.00 180.00 180.00 260.00 260.00 260.00 260.00 1,400.00 3,402.00 SIT 511.16 62.94 62.94 62.94 62.94 62.94 62.94 377.64 888.80 SUTA 11.66 1.44 1.44 1.44 1.44 1.44 1.44 8.64 20.30 CIT SIMPLE 654.01 80.52 80.52 80.52 80.52 80.52 80.52 483.12 1,137.13 Checkpoint CK. DEDUCTIONS NO. AMOUNT 94.50 24.00 24.00 24.00 72.00 166.50 679 689 699 710 719 729 12,102.94 1,568.27 1,544.27 1,488.27 1,464.27 1,488.27 1,464.27 9,017.62 21,120.56 OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE M F Office Accounting Trainee X PA 006-77-6667 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE Student BETTY $ $ $ $ SALARY UNION DUES OTHER WEEKLY RAT HOURLY RATE $21,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 QTR. TOT. 72 72 72 72 72 71 431 HRS. RATE AMOUNT 7.50 7.50 7.50 7.50 7.50 7.50 YR. TOT. 5,550.00 6,090.00 6,630.00 7,170.00 7,710.00 8,250.00 8,782.50 3,232.50 8,782.50 ALLOW. 7.50 11.25 STATUS 1 S NET PAID FICA 344.10 33.48 33.48 33.48 33.48 33.48 33.02 200.42 544.52 OTHER HI 80.48 7.83 7.83 7.83 7.83 7.83 7.72 46.87 127.35 FIT 409.00 32.00 32.00 32.00 32.00 32.00 30.00 190.00 599.00 SIT SUTA 170.38 16.58 16.58 16.58 16.58 16.58 16.35 99.25 269.63 3.89 0.38 0.38 0.38 0.38 0.38 0.37 2.27 6.16 Checkpoint CIT SIMPLE 218.00 21.21 21.21 21.21 21.21 21.21 20.92 126.97 344.97 CK. DEDUCTIONS NO. AMOUNT 32.40 4,291.75 428.52 422.22 428.52 422.22 428.52 -205.88 1,924.12 6,215.87 680 690 700 711 720 730 6.30 6.30 630.00 642.60 675.00 Checkpoint OCCUPATION DEPARTMENT MARITAL DEDUCTIONS OASDI 5,550.00 540.00 540.00 540.00 540.00 540.00 532.50 3,232.50 8,782.50 YEAR-TO-DATE 1 CUMULATIVE L W/H WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST 000-00-6741 FIRST WILLIAMS MIDDLE M F Office Programmer x PA OTHER DEDUCTIONS INFORMATION GROUP INSURANCE Ruth $ $ $ $ SALARY UNION DUES OTHER WEEKLY RAT HOURLY RATE $48,000 -- $.30/M 20___ OVERTIME R REGULAR EARNINGS OVERTIME EARNINGS PAYDAY EARNINGS HRS. RATE YEAR-TO-DATE 1 10/9 2 10/23 3 11/6 4 11/13 CUMULATIVE 80 80 79 56 15.29 15.29 15.29 AMOUNT HRS. RATE AMOUNT Virginia 2,650 /mo. 611.54 15.29 22.94 W/H MARITAL ALLOW. STATUS 0 S DEDUCTIONS NET PAID FICA OASDI OTHER HI FIT SIT SUTA CIT 10,260.00 1,223.08 1,223.20 1,207.85 2,079.32 10,260.00 11,483.08 12,706.28 13,914.13 15,993.45 636.12 75.83 75.84 74.89 128.92 148.77 17.73 17.74 17.51 30.15 1,606.00 155.00 155.00 152.00 325.00 314.98 37.55 37.55 37.08 63.84 7.18 0.86 0.86 0.85 1.46 403.01 48.04 48.05 47.44 81.68 5,733.45 15,993.45 5,733.45 15,993.45 355.48 991.60 83.13 231.90 787.00 2,393.00 176.02 491.00 4.03 11.21 SIMPLE 225.21 628.22 CK. DEDUCTIONS NO. AMOUNT 59.40 14.40 681 691 701 722 7,084.54 888.07 873.76 878.08 1,448.27 5 6 QTR. TOT. YR. TOT. 295 Checkpoint Checkpoint 4,088.18 11,172.72 OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE M F Office Programmer x PA 000-00-1587 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE Woods Beth $ $ $ $ SALARY UNION DUES OTHER WEEKLY RAT HOURLY RATE 47,000-- .30/m 20___ OVERTIME R REGULAR EARNINGS OVERTIME EARNINGS PAYDAY CUMULATIVE EARNINGS HRS. RATE AMOUNT HRS. RATE AMOUNT Anne 2,600 600.00 15.00 22.50 W/H MARITAL ALLOW. STATUS 1 S DEDUCTIONS NET PAID FICA OASDI OTHER HI FIT SIT SUTA CIT SIMPLE CK. DEDUCTIONS NO. AMOUNT YEAR-TO-DATE 1 2 3 4 5 12/4 6 12/18 QTR. TOT. 72 80 152 15.00 15.00 1,080.00 1,200.00 2,280.00 2,280.00 YR. TOT. 1,080.00 2,280.00 2,280.00 2,280.00 66.96 74.40 141.36 141.36 15.66 17.40 33.06 33.06 134.00 152.00 286.00 286.00 33.16 36.84 70.00 70.00 0.76 0.84 1.60 1.60 Checkpoint 721 731 14.10 14.10 14.10 787.04 857.28 1,644.32 1,644.32 Checkpoint OCCUPATION DEPARTMENT 42.42 47.14 89.56 89.56 WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE M F Sales Representative/training x PA 000-00-6057 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE Young Paul $ $ $ $ SALARY UNION DUES OTHER WEEKLY RAT HOURLY RATE 32,000--.30/m 20___ OVERTIME R REGULAR EARNINGS OVERTIME EARNINGS PAYDAY CUMULATIVE EARNINGS HRS. RATE AMOUNT HRS. RATE AMOUNT Winston 1,750 403.85 10.10 15.15 W/H MARITAL ALLOW. STATUS 1 S DEDUCTIONS NET PAID FICA OASDI OTHER HI FIT SIT SUTA CIT SIMPLE CK. DEDUCTIONS NO. AMOUNT YEAR-TO-DATE 1 2 3 4 5 6 12/18 QTR. TOT. YR. TOT. 80 80 10.10 807.70 807.70 807.70 Checkpoint 807.70 807.70 807.70 50.08 50.08 50.08 11.71 11.71 11.71 69.00 69.00 69.00 24.80 24.80 24.80 0.57 0.57 0.57 31.73 31.73 31.73 Checkpoint 9.60 9.60 9.60 732 610.21 610.21 610.21 OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST 000-00-1502 FIRST Zimmerman MIDDLE M F Time Clerk x PA OTHER DEDUCTIONS INFORMATION GROUP INSURANCE $ $ $ $ SALARY UNION DUES OTHER WEEKLY RAT HOURLY RATE $26,000--.30/m 20___ OVERTIME R REGULAR EARNINGS OVERTIME EARNINGS PAYDAY CUMULATIVE EARNINGS HRS. RATE AMOUNT HRS. RATE AMOUNT Richard 1,430 330.00 8.25 Lloyd W/H MARITAL ALLOW. STATUS 1 m DEDUCTIONS NET PAID FICA OASDI OTHER HI FIT SIT SUTA CIT SIMPLE CK. DEDUCTIONS NO. AMOUNT 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 MIDDLE M F OTHER DEDUCTIONS INFORMATION GROUP INSURANCE UNION DUES $ $ $ $ SALARY OTHER WEEKLY RAT HOURLY RATE 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 MARITAL ALLOW. STATUS DEDUCTIONS NET PAID FICA OASDI OTHER HI FIT SIT SUTA CIT SIMPLE CK. DEDUCTIONS NO. AMOUNT

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intermediate Accounting

Authors: Donald E. Kieso, Jerry J. Weygandt, And Terry D. Warfield

13th Edition

9780470374948, 470423684, 470374942, 978-0470423684

Students also viewed these Accounting questions