December: QUESTION 1

1. Enter Net Pay from the Payroll Register for Young for the December 18 payday.

QUESTION 2

1. Enter the debit amount to Union Dues Payable from the December 9 entry in the Journal.

QUESTION 3

1. Enter the amount from Box 2 from the Form for Transaction No. 24.

QUESTION 4

1. Enter the balance as of the end of December 18 for FUTA Taxes Payable from the General Ledger.

QUESTION 5

1. Enter Ford's Cumulative Earnings as of the end of the year from the Employees' Earnings Records.

QUESTION 6

1. Enter the Amount of Deposit from the Form for Transaction No. 25.

QUESTION 7

1. Enter Net Pay from the Payroll Register for Bonno for the December 4 payday.

QUESTION 8

1. Enter Net Pay from the Payroll Register for Ferguson for the December 4 payday.

QUESTION 9

1. Enter Net Pay from the Payroll Register for Ford for the December 4 payday.

QUESTION 10

1. Enter Net Pay from the Payroll Register for Mann for the December 4 payday.

QUESTION 11

1. Enter Net Pay from the Payroll Register for O'Neill for the December 4 payday.

QUESTION 12

1. Enter Net Pay from the Payroll Register for Russell for the December 14 payday.

QUESTION 13

1. Enter Net Pay from the Payroll Register for Sokowski for the December 18 payday.

QUESTION 14

1. Enter Net Pay from the Payroll Register for Student for the December 18 payday.

QUESTION 15

1. Enter Net Pay from the Payroll Register for Woods for the December 18 payday.

January: QUESTION 1

1. Enter the debit amount to Employees SIT Payable for the January 6 entry in the Journal.

QUESTION 2

1. Enter the debit amount to Union Dues Payable for the January 8 entry in the Journal.

QUESTION 3

1. Enter the credit amount to Cash from the first January 15 entry in the Journal.

QUESTION 4

1. Enter the debit amount to Employees CIT Payable from the second January 15 entry in the Journal.

QUESTION 5

1. Enter the Amount of Deposit from the form for Transaction No. 33.

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 DESCRIPTION POST. REF. DEBIT CREDIT 20-- Oct. 9 Payroll Cash Cash 12 11 12,045.44 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,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 1,381.42 12,045.44 958.57 224.19 1,125.00 474.67 10.85 606.05 16.00 12,045.44 958.57 224.18 22.91 175.76 Page 42 JOURNAL DATE DESCRIPTION POST. REF. DEBIT CREDIT 20-- Oct 23 Payroll Cash Cash 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 Taxes 23 Payroll Taxes FICA Taxes Payable - OASDI FICA Taxes Payable - HI FUTA Taxes Payable SUTA Taxes Payable - Employer 12,108.81 12,108.81 2,307.69 4,651.08 3,600.00 5,223.92 978.53 228.86 1,155.00 484.55 11.07 618.67 181.20 16.00 12,108.81 1,387.29 978.53 228.85 4.15 175.76 Page 43 JOURNAL DATE 20-- Nov DESCRIPTION POST. REF. DEBIT CREDIT Page 44 JOURNAL DATE 20-- DESCRIPTION POST. REF. DEBIT CREDIT Page 45 JOURNAL DATE 20-- DESCRIPTION POST. REF. DEBIT CREDIT Page 46 JOURNAL DATE 20-- DESCRIPTION POST. REF. DEBIT CREDIT Page 47 JOURNAL DATE DESCRIPTION POST. REF. DEBIT CREDIT 20-- ### ### ### ### Page 48 JOURNAL DATE 20-- DESCRIPTION POST. REF. DEBIT CREDIT GENERAL LEDGER ACCOUNT: Checkpoints CASH ACCOUNT NO. 11 BALANCE POST. DATE ITEM REF. DEBIT CREDIT DEBIT 20-- Oct. 1 Balance 9 20 23 a J41 J41 J41 199,846.33 12,045.44 187,800.89 474.67 187,326.22 12,108.81 175,217.41 CREDIT Debit Credit Balance Balance Oct. 31, 20-- 175,217.41 Nov. 30, 20-Dec. 31, 20-- ACCOUNT: PAYROLL CASH ACCOUNT NO. 12 BALANCE POST. DATE ITEM REF. DEBIT J41 J41 J41 J41 12,045.44 CREDIT DEBIT 20-- Oct. 9 9 23 23 12,045.44 12,108.81 12,108.81 12,045.44 0.00 12,108.81 0.00 CREDIT Checkpoints Debit Credit Balance Balance Oct. 31, 20-0.00 Nov. 30, 20-Dec. 31, 20-- ACCOUNT: FICA TAXES PAYABLE - OASDI ITEM REF. DEBIT CREDIT DEBIT CREDIT 20-- Oct. 9 9 23 23 J41 J41 J41 J41 Debit Balance BALANCE POST. DATE Checkpoints ACCOUNT NO. 20.1 958.57 958.57 978.53 978.53 958.57 1,917.14 2,895.67 3,874.20 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance 3,874.20 ACCOUNT: FICA TAXES PAYABLE - HI ITEM REF. DEBIT CREDIT DEBIT CREDIT 20-- Oct. 9 9 23 23 J41 J41 J41 J41 Debit Balance BALANCE POST. DATE Checkpoints ACCOUNT NO. 20.2 224.19 224.18 228.86 228.85 224.19 448.37 677.23 906.08 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance 906.08 ACCOUNT: FUTA TAXES PAYABLE ITEM REF. DEBIT CREDIT DEBIT CREDIT 20-- Oct. 1 Balance 9 23 a J41 J42 Debit Balance BALANCE POST. DATE Checkpoints ACCOUNT NO. 21 22.91 4.15 392.94 415.85 420.00 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance 420.00 ACCOUNT: SUTA TAXES PAYABLE - EMPLOYER ITEM REF. DEBIT CREDIT DEBIT CREDIT 20-- Oct. 9 23 J41 J42 Debit Balance BALANCE POST. DATE Checkpoints ACCOUNT NO. 22 175.76 175.76 175.76 351.52 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance 351.52 ACCOUNT: EMPLOYEES FIT PAYABLE ITEM REF. DEBIT CREDIT DEBIT CREDIT 20-- Oct. 9 23 J41 J42 Debit Balance BALANCE POST. DATE Checkpoints ACCOUNT NO. 24 1,125.00 1,155.00 1,125.00 2,280.00 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance 2,280.00 ACCOUNT: EMPLOYEES SIT PAYABLE ITEM REF. DEBIT CREDIT DEBIT CREDIT 20-- Oct. 9 20 23 J41 J41 J42 Debit Balance BALANCE POST. DATE Checkpoints ACCOUNT NO. 25 474.67 474.67 484.55 474.67 0.00 484.55 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance 484.55 ACCOUNT: EMPLOYEES SUTA PAYABLE ITEM REF. Debit Balance BALANCE POST. DATE DEBIT CREDIT DEBIT CREDIT 20-- Oct. 9 23 J41 Checkpoints ACCOUNT NO. 25.1 10.85 11.07 10.85 21.92 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance 21.92 ACCOUNT: EMPLOYEES CIT PAYABLE ITEM REF. DEBIT CREDIT DEBIT CREDIT 20-- Oct. 9 23 J41 Debit Balance BALANCE POST. DATE Checkpoints ACCOUNT NO. 26 606.05 618.67 606.05 1,224.72 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance 1,224.72 ACCOUNT: GROUP INSURANCE PREMIUMS COLLECTED ITEM REF. DEBIT CREDIT DEBIT CREDIT 20-- Oct 23 J42 Debit Balance BALANCE POST. DATE Checkpoints ACCOUNT NO. 27 181.20 181.20 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance 181.20 ACCOUNT: UNION DUES PAYABLE ITEM REF. Debit Balance BALANCE POST. DATE Checkpoints ACCOUNT NO. 28 DEBIT CREDIT DEBIT CREDIT 20-- Oct. 9 23 J41 16.00 16.00 16.00 32.00 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance 32.00 ACCOUNT: SIMPLE CONTRIBUTIONS PAYABLE 20-- ITEM REF. Debit Balance BALANCE POST. DATE Checkpoints ACCOUNT NO. 29 DEBIT CREDIT DEBIT CREDIT Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance ACCOUNT: ADMINISTRATIVE SALARIES ACCOUNT NO. 51 BALANCE POST. DATE ITEM REF. DEBIT CREDIT DEBIT 20-- Oct. 1 Balance 9 23 a J41 J41 2,307.69 2,307.69 42,692.27 44,999.96 47,307.65 CREDIT Checkpoints Debit Credit Balance Balance Oct. 31, 20-- 47,307.65 Nov. 30, 20-Dec. 31, 20-- ACCOUNT: OFFICE SALARIES ACCOUNT NO. 52 BALANCE POST. DATE ITEM REF. DEBIT CREDIT DEBIT 20-- Oct. 1 Balance 9 23 a J41 J41 4,651.08 4,651.08 28,350.00 33,001.08 37,652.16 CREDIT Checkpoints Debit Credit Balance Balance Oct. 31, 20-- 37,652.16 Nov. 30, 20-Dec. 31, 20-- ACCOUNT: SALES SALARIES ACCOUNT NO. 53 BALANCE POST. DATE ITEM REF. DEBIT CREDIT DEBIT 20-- Oct. 1 Balance 9 23 a J41 3,600.00 3,600.00 28,525.00 32,125.00 35,725.00 CREDIT Checkpoints Debit Credit Balance Balance Oct. 31, 20-- 35,725.00 Nov. 30, 20-Dec. 31, 20-- ACCOUNT: PLANT WAGES ACCOUNT NO. 54 BALANCE POST. DATE ITEM REF. DEBIT CREDIT DEBIT 20-- Oct. 1 Balance 9 23 a J41 4,902.00 5,223.92 42,657.30 47,559.30 52,783.22 CREDIT Checkpoints Debit Credit Balance Balance Oct. 31, 20-- 52,783.22 Nov. 30, 20-Dec. 31, 20-- ACCOUNT: PAYROLL TAXES ACCOUNT NO. 56 BALANCE POST. DATE ITEM REF. DEBIT CREDIT DEBIT 20-- Oct. 1 Balance 9 23 a J41 J41 1,381.42 1,387.29 14,123.59 15,505.01 16,892.30 CREDIT Checkpoints Debit Credit Balance Balance Oct. 31, 20-- 16,892.30 Nov. 30, 20-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.65 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.65 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 8 8 8 GLO-BRITE PAINT COMP 8 8 8 8 8 8 8 8 8 8 8 8 80 17.65 80 80 Amount Overtime Earnings Rate Per Hrs. Hour Amount Total Earnings OASDI 1,412.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,412.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.54 139.50 75.64 83.70 143.08 74.40 89.28 127.10 62.50 75.83 15,460.77 15,460.77 958.57 1,517.92 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 94.11 139.50 75.64 83.70 143.08 74.40 102.67 127.10 62.50 75.83 15,460.77 321.92 15,782.69 978.53 1,412.00 2,250.00 1,220.00 1,412.00 2,250.00 1,220.00 87.54 139.50 75.64 1,412.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.48 105.92 8 27.00 216.00 Mann, D. O'Neill, J. Russell, V. Ryan, N. Sokowski, T. (Student) Williams, R. No. W/H Allow. NAME Marital Status PAYROLL REGISTER M M S M M S S 4 3 1 4 2 1 0 Time Record S M 8 8 6 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 7 F S S M 8 8 8 8 8 8 8 8 8 8 4 8 8 8 Regular Earnings T 8 8 8 8 8 8 8 Rate Per W T F S Hrs. Hour 8 8 8 80 8 8 8 80 8 8 8 78 8 8 8 80 18.00 8 8 8 80 8 8 4 72 14.00 8 8 8 79 TOTALS Payday, November 13, 20-- For Period Ending November 14, 20-Williams, R. S 0 TOTALS GLO-BRITE PAINT COMP 136 Overtime Earnings Rate Per Hrs. Hour Total Earnings 1,350.00 2,307.69 1,170.00 1,440.00 2,050.00 1,008.00 1,207.85 OASDI 83.70 143.08 72.54 89.28 127.10 62.50 74.89 15,415.54 15,415.54 955.77 2,079.32 2,079.32 128.92 2,079.32 2,079.32 128.92 Amount 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 TOTALS Payday, December 4, 20-- For Period Ending November 28, 20-Bonno, A. Ferguson, J. Ford, C. Mann, D. O'Neill, J. Russell, V. Ryan, N. Sokowski, T. (Student) Woods, B. TOTALS Payday, December 14, 20-- For Period Ending December 12, 20-Russell, V. TOTALS 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 4 8 8 8 8 8 8 O'Neill, J. M 3 8 8 8 8 8 8 Russell, V. S 1 6 8 8 8 8 8 Ryan, N. M 4 8 8 8 8 8 8 Sokowski, T. M 2 8 8 8 8 8 8 (Student) S 1 8 8 8 8 4 8 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 8 8 8 8 8 8 8 8 8 4 64 17.65 80 80 80 80 78 80 18.00 80 72 14.00 Amount Overtime Earnings Rate Per Hrs. Hour Amount Total Earnings OASDI 1,129.60 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,129.60 2,250.00 1,220.00 1,350.00 2,307.69 1,170.00 1,440.00 2,050.00 1,008.00 70.04 139.50 75.64 83.70 143.08 72.54 89.28 127.10 62.50 13,925.29 13,925.29 863.38 No. W/H Allow. NAME Marital Status PAYROLL REGISTER Time Record S M T W T TOTALS 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. Ferguson, J. Ford, C. Mann, D. O'Neill, J. Ryan, N. Sokowski, T. (Student) Woods, B. Young, P. GLO-BRITE PAINT COMP Amount Overtime Earnings Rate Per Hrs. Hour Amount Total Earnings OASDI 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.47 46.00 43.35 32.63 137.00 69.08 17.69 107.00 37.45 19.58 40.00 41.45 33.46 192.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 153.00 37.55 224.19 1,125.00 474.67 Payday, October 23, 20-- For Period Ending October 17, 20-Bonno, A. 22.01 56.00 46.60 Ferguson, J. 32.63 137.00 69.08 Ford, C. 17.69 107.00 37.45 Mann, D. 19.58 40.00 41.45 O'Neill, J. 33.46 192.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 153.00 37.55 TOTALS 228.86 1,155.00 484.55 Payday, November 6, 20-- For Period Ending October 31, 20-Bonno, A. 20.47 46.00 43.35 Ferguson, J. 32.63 137.00 69.08 Ford, C. 17.69 107.00 37.45 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 0.85 GLO-BRITE PAINT COMPANY Deductions NAME Mann, D. O'Neill, J. Russell, V. Ryan, N. Sokowski, T. (Student) Williams, R. TOTALS HI 19.58 33.46 16.97 20.88 29.73 14.62 17.51 FIT 117.00 192.00 98.00 50.00 252.00 97.00 150.00 SIT 41.45 70.85 35.92 44.21 62.94 30.95 37.08 SUTA 0.95 1.62 0.82 1.01 1.44 0.71 0.85 223.54 1,246.00 473.28 10.82 Payday, November 13, 20-- For Period Ending November 14, 20-Williams, R. 30.15 334.00 63.84 1.46 TOTALS 30.15 334.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.38 18.00 34.68 0.79 Ferguson, J. 32.63 65.00 69.08 1.58 Ford, C. 17.69 107.00 37.45 0.85 Mann, D. 19.58 81.00 41.45 0.95 O'Neill, J. 33.46 87.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 252.00 62.94 1.44 (Student) 14.62 97.00 30.95 0.71 TOTALS 201.94 835.00 427.53 Payday, December 4, 20-- For Period Ending November 28, 20-Bonno, A. Ferguson, J. Ford, C. Mann, D. O'Neill, J. Russell, V. Ryan, N. Sokowski, T. (Student) Woods, B. TOTALS Payday, December 14, 20-- For Period Ending December 12, 20-Russell, V. TOTALS 9.77 GLO-BRITE PAINT COMPANY Deductions NAME HI FIT SIT SUTA Payday, December 18, 20-- For Period Ending December 12, 20-Bonno, A. Ferguson, J. Ford, C. Mann, D. O'Neill, J. Ryan, N. Sokowski, T. (Student) Woods, B. Young, P. TOTALS Deductions NAME Payday, October 9, 20-Bonno, A. Ferguson, J. Ford, C. Mann, D. O'Neill, J. Russell, V. Ryan, N. Sokowski, T. (Student) Williams, R. TOTALS Net Paid CIT Group Ins. Union Dues Ck. SIMPLE No. For Period Ending October 3, 20-55.35 8.00 88.20 47.82 52.92 90.46 47.04 56.45 8.00 80.36 39.51 47.94 606.05 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.50 16.50 8.00 Ferguson, J. 88.20 26.40 Ford, C. 47.82 14.40 Mann, D. 52.92 15.90 O'Neill, J. 90.46 27.00 Russell, V. 47.04 14.10 Ryan, N. 64.92 16.80 8.00 Sokowski, T. 80.36 24.00 (Student) 39.51 11.70 Williams, R. 47.94 14.40 TOTALS 618.67 181.20 16.00 0.00 Payday, November 6, 20-- For Period Ending October 31, 20-Bonno, A. 55.35 8.00 Ferguson, J. 88.20 Ford, C. 47.82 682 683 684 685 686 687 688 689 690 691 Amount 1,150.30 1,782.01 933.55 1,111.40 1,776.22 896.48 1,170.17 1,572.43 762.71 890.17 Taxable Earnings OASDI HI 1,412.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,412.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,045.44 15,460.77 15,460.77 1,214.14 1,755.61 919.15 1,095.50 1,749.22 882.38 1,317.60 1,548.43 751.01 875.77 1,517.92 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,517.92 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,108.81 15,782.69 15,782.69 1,150.30 1,782.01 933.55 1,412.00 2,250.00 1,220.00 1,412.00 2,250.00 1,220.00 Labor Cost Distribution FUTA SUTA Admin. Office 700.00 1,350.00 1,220.00 1,350.00 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 2,307.69 4,651.08 1,220.00 250.00 1,220.00 1,350.00 1,220.00 2,307.69 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 260.00 1,220.00 Deductions NAME Net Paid Mann, D. O'Neill, J. Russell, V. Ryan, N. Sokowski, T. (Student) Williams, R. CIT 52.92 90.46 45.86 56.45 80.36 39.51 47.35 TOTALS 604.28 Group Ins. Union Dues Ck. SIMPLE No. 8.00 0.00 16.00 0.00 Payday, November 13, 20-- For Period Ending November 14, 20-Williams, R. 81.51 14.40 TOTALS 81.51 14.40 0.00 0.00 Amount 1,034.40 1,776.22 899.89 1,170.17 1,496.43 762.71 880.17 Taxable Earnings OASDI 1,350.00 2,307.69 1,170.00 1,440.00 2,050.00 1,008.00 1,207.85 HI 1,350.00 2,307.69 1,170.00 1,440.00 2,050.00 1,008.00 1,207.85 11,885.85 15,415.54 15,415.54 1,425.04 2,079.32 2,079.32 1,425.04 2,079.32 2,079.32 FUTA Labor Cost Distribution SUTA 900.00 Admin. Office 2,307.69 0.00 360.00 1,170.00 1,008.00 1,008.00 1,207.85 2,528.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 Ins. Union Dues Ck. SIMPLE No. Payday, November 20, 20-- For Period Ending November 14, 20-Bonno, A. 44.28 16.50 8.00 Ferguson, J. 88.20 26.40 500.00 Ford, C. 47.82 14.40 Mann, D. 52.92 15.90 250.00 O'Neill, J. 90.46 27.00 700.00 Russell, V. 45.86 14.10 Ryan, N. 56.45 16.80 8.00 200.00 Sokowski, T. 80.36 24.00 (Student) 39.51 11.70 TOTALS 545.86 166.80 16.00 1,650.00 Payday, December 4, 20-- For Period Ending November 28, 20-Bonno, A. Ferguson, J. Ford, C. Mann, D. O'Neill, J. Russell, V. Ryan, N. Sokowski, T. (Student) Woods, B. TOTALS Payday, December 14, 20-- For Period Ending December 12, 20-Russell, V. TOTALS Amount 920.93 1,327.61 919.15 804.50 1,154.22 885.79 973.37 1,472.43 751.01 Taxable Earnings OASDI HI 1,129.60 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,129.60 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,209.01 13,925.29 13,925.29 FUTA Labor Cost Distribution SUTA Admin. Office 1,220.00 2,307.69 1,170.00 0.00 426.00 1,008.00 426.00 2,307.69 3,398.00 Deductions NAME Net Paid CIT Group Ins. Union Dues Ck. SIMPLE No. Payday, December 18, 20-- For Period Ending December 12, 20-Bonno, A. Ferguson, J. Ford, C. Mann, D. O'Neill, J. Ryan, N. Sokowski, T. (Student) Woods, B. Young, P. TOTALS Amount Taxable Earnings OASDI HI FUTA Labor Cost Distribution SUTA Admin. Office 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,412.00 Total earnings 2,250.00 Net paid 1,350.00 1,440.00 2,050.00 3,600.00 4,902.00 Payday, October 23, 20-- For Period Ending October 17,Checkpoints 20-Bonno, A. 1,517.92 Total earnings Ferguson, J. 2,250.00 Net paid Ford, C. Mann, D. 1,350.00 O'Neill, J. Russell, V. Ryan, N. 1,548.00 Sokowski, T. 2,050.00 (Student) Williams, R. TOTALS 3,600.00 5,115.92 Payday, November 6, 20-- For Period Ending October 31,Checkpoints 20-Bonno, A. 1,412.00 Total earnings Ferguson, J. 2,250.00 Net paid Ford, C. 15,460.77 12,045.44 Labor Cost Distribution NAME Mann, D. O'Neill, J. Russell, V. Ryan, N. Sokowski, T. (Student) Williams, R. TOTALS Sales 1,350.00 Plant 1,440.00 2,050.00 3,600.00 4,902.00 Payday, November 13, 20-- For Period Ending NovemberCheckpoints 14, 20-Williams, R. Total earnings Net paid TOTALS 0.00 0.00 Labor Cost Distribution NAME Sales Plant Payday, November 20, 20-- For Period Ending NovemberCheckpoints 14, 20-Bonno, A. 1,129.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,440.00 Sokowski, T. 2,050.00 (Student) TOTALS 3,600.00 4,619.60 Payday, December 4, 20-- For Period Ending November Checkpoints 28, 20-Bonno, A. Total earnings Ferguson, J. Net paid Ford, C. Mann, D. O'Neill, J. Russell, V. Ryan, N. Sokowski, T. (Student) Woods, B. TOTALS Payday, December 14, 20-- For Period Ending DecemberCheckpoints 12, 20-Russell, V. Total earnings Net paid TOTALS Labor Cost Distribution NAME Sales Plant Payday, December 18, 20-- For Period Ending DecemberCheckpoints 12, 20-Bonno, A. Total earnings Ferguson, J. Net paid Ford, C. Mann, D. O'Neill, J. Ryan, N. Sokowski, T. (Student) Woods, B. Young, P. TOTALS 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 AMOUNT 10/9 2 10/23 3 11/6 4 11/20 5 12/4 6 12/18 80 80 HRS. RATE 10,293.40 1,412.00 1,412.00 YEAR-TO-DATE 1 OVERTIME EARNINGS 17.65 17.65 4 26.48 OVERTIME R CUMULATIVE EARNINGS AMOUNT 11,322.00 12,734.00 14,251.92 17.65 26.48 4 DEDUCTIONS FICA OASDI 1,028.60 0.00 105.92 0.00 0.00 0.00 0.00 W/H ALLOW. 701.96 87.54 94.11 OTHER HI 164.17 20.47 22.01 FIT SIT 810.00 46.00 56.00 SUTA 347.59 43.35 46.60 CIT 7.93 0.99 1.06 SIMPLE 443.82 55.35 59.50 DEDUCTIONS 216.80 8.00 24.50 QTR. TOT. YR. TOT. Checkpoint Checkpoint DEPARTMENT OCCUPATION WORKS IN (STATE) Sales Sales Manager PA SEX M F x S.S. ACCOUNT NO. 000-00-8645 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE NAME - LAST FIRST FERGUSON $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $88,000 -- $.30/M 20___ 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 CUMULATIVE 80 80 80 80 RATE AMOUNT HRS. RATE 23,125.00 2,250.00 2,250.00 2,250.00 2,250.00 AMOUNT 5 FICA 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 137.00 137.00 SIT SUTA 709.94 69.08 69.08 69.08 69.08 QTR. TOT. YR. TOT. Checkpoint W/H ALLOW. DEDUCTIONS OASDI 23,125.00 25,375.00 27,625.00 29,875.00 32,125.00 James 58,500 /yr. 1,125.00 28.13 Checkpoint 16.19 1.58 1.58 1.58 1.58 CIT 906.50 88.20 88.20 88.20 88.20 SIMPLE DEDUCTIONS 132.30 26.40 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 RATE HOURLY RATE $48,000--$.30/M 20___ OVERTIME R REGULAR EARNINGS OVERTIME EARNINGS CUMULATIVE PAYDAY EARNINGS HRS. RATE AMOUNT 1 10/9 2 10/23 3 11/6 4 11/20 5 12/4 6 12/18 HRS. RATE AMOUNT 80 80 6,300.00 7,520.00 8,740.00 W/H ALLOW. 2 DEDUCTIONS FICA OASDI 6,300.00 1,220.00 1,220.00 YEAR-TO-DATE Catherine 2,643.33 /mo. 610.00 15.25 22.88 390.60 75.64 75.64 OTHER HI 91.35 17.69 17.69 FIT 639.00 107.00 107.00 SIT SUTA 193.41 37.45 37.45 4.41 0.85 0.85 CIT SIMPLE DEDUCTIONS 246.96 47.82 47.82 37.80 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 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. YR. TOT. CUMULATIVE 80 80 RATE AMOUNT 5,400.00 1,350.00 1,350.00 HRS. RATE AMOUNT W/H ALLOW. 4 DEDUCTIONS FICA OASDI 5,400.00 6,750.00 8,100.00 Dewey 2,925 /mo. 675.00 16.88 334.80 83.70 83.70 OTHER HI 78.30 19.58 19.58 FIT 332.00 40.00 40.00 SIT 165.78 41.45 41.45 SUTA 3.78 0.95 0.95 CIT 211.68 52.92 52.92 SIMPLE DEDUCTIONS 31.50 15.90 Checkpoint 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 RATE HOURLY RATE $90,000 -- $.30/M 20___ OVERTIME R REGULAR EARNINGS OVERTIME EARNINGS CUMULATIVE PAYDAY EARNINGS HRS. RATE AMOUNT 1 10/9 2 10/23 3 11/6 4 11/20 5 12/4 6 12/18 HRS. RATE AMOUNT 80 80 42,692.27 44,999.96 47,307.65 W/H ALLOW. 3 DEDUCTIONS FICA OASDI 42,692.27 2,307.69 2,307.69 YEAR-TO-DATE Joseph 60,000 /yr. 1,153.85 28.85 2,646.92 143.08 143.08 OTHER HI 619.04 33.46 33.46 FIT 6,116.00 192.00 192.00 SIT SUTA 1,310.65 70.85 70.85 29.88 1.62 1.62 CIT SIMPLE 1,673.54 90.46 90.46 DEDUCTIONS 202.50 27.00 TR. TOT. YR. TOT. Checkpoint Checkpoint OCCUPATION DEPARTMENT 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 RATE HOURLY RATE $47,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. YR. TOT. CUMULATIVE 80 80 RATE AMOUNT 6,240.00 1,200.00 1,200.00 HRS. RATE AMOUNT W/H ALLOW. 1 DEDUCTIONS FICA OASDI 6,240.00 7,440.00 8,640.00 Virginia 2,600 /mo. 600.00 15.00 22.50 386.88 74.40 74.40 OTHER HI 90.48 17.40 17.40 FIT 642.00 127.00 127.00 SIT 191.56 36.84 36.84 SUTA 4.37 0.84 0.84 CIT 244.61 47.04 47.04 SIMPLE DEDUCTIONS 31.50 14.10 Checkpoint 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 RYAN Norman $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $56,000 -- $.30/M 20___ $8 each pay REGULAR EARNINGS OVERTIME EARNINGS OVERTIME R CUMULATIVE PAYDAY EARNINGS HRS. RATE AMOUNT 13,287.50 1,440.00 1,440.00 YEAR-TO-DATE 1 10/9 2 10/23 3 11/6 4 11/20 5 12/4 6 12/18 80 80 18.00 18.00 HRS. RATE 8 27.00 AMOUNT 14,685.30 16,125.30 17,781.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 OTHER HI 212.94 20.88 24.01 FIT 1,070.00 50.00 70.00 SIT SUTA 450.84 44.21 50.84 10.28 1.01 1.16 CIT SIMPLE 575.66 56.45 64.92 DEDUCTIONS 235.70 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___ 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. YR. TOT. CUMULATIVE 80 80 RATE AMOUNT 16,650.00 2,050.00 2,050.00 HRS. RATE AMOUNT ALLOW. 2 DEDUCTIONS FICA OASDI 16,650.00 18,700.00 20,750.00 W/H 1,025.00 25.63 1,032.30 127.10 127.10 OTHER HI 241.43 29.73 29.73 FIT 2,002.00 176.00 176.00 SIT 511.16 62.94 62.94 SUTA 11.66 1.44 1.44 CIT 652.68 80.36 80.36 SIMPLE DEDUCTIONS 94.50 24.00 Checkpoint Checkpoint OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST 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 R REGULAR EARNINGS OVERTIME EARNINGS CUMULATIVE PAYDAY EARNINGS HRS. RATE AMOUNT 1 10/9 2 10/23 3 11/6 4 11/20 5 12/4 6 12/18 72 72 HRS. RATE AMOUNT 14.00 14.00 5,550.00 6,558.00 7,566.00 14.00 21.00 1 DEDUCTIONS FICA OASDI 5,550.00 1,008.00 1,008.00 YEAR-TO-DATE W/H ALLOW. 344.10 62.50 62.50 OTHER HI 80.48 14.62 14.62 FIT 409.00 97.00 97.00 SIT SUTA 170.38 30.95 30.95 3.89 0.71 0.71 CIT SIMPLE DEDUCTIONS 217.56 39.51 39.51 32.40 11.70 QTR. TOT. YR. TOT. Checkpoint Checkpoint OCCUPATION DEPARTMENT 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 RATE HOURLY RATE $48,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/13 5 6 QTR. TOT. YR. TOT. CUMULATIVE 80 80 RATE AMOUNT 10,260.00 1,223.08 1,223.08 HRS. RATE AMOUNT W/H ALLOW. 0 DEDUCTIONS FICA OASDI 10,260.00 11,483.08 12,706.16 2,650 /mo. 611.54 15.29 22.94 636.12 75.83 75.83 OTHER HI 148.77 17.73 17.73 FIT 1,606.00 153.00 153.00 SIT 314.98 37.55 37.55 SUTA 7.18 0.86 0.86 CIT 402.19 47.94 47.94 SIMPLE DEDUCTIONS 59.40 14.40 Checkpoint Checkpoint 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 R 20___ REGULAR EARNINGS OVERTIME EARNINGS CUMULATIVE PAYDAY 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 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 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE OVERTIME R 20___ REGULAR EARNINGS OVERTIME EARNINGS PAYDAY EARNINGS HRS. YEAR-TO-DATE 1 2 3 4 5 6 12/18 QTR. TOT. YR. TOT. CUMULATIVE RATE AMOUNT HRS. RATE AMOUNT W/H ALLOW. DEDUCTIONS FICA OASDI OTHER HI FIT SIT SUTA CIT SIMPLE DEDUCTIONS Checkpoint Checkpoint 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 R 20___ REGULAR EARNINGS OVERTIME EARNINGS CUMULATIVE PAYDAY EARNINGS HRS. RATE AMOUNT HRS. RATE AMOUNT /mo. 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 $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE 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 ALLOW. DEDUCTIONS FICA OASDI OTHER HI FIT SIT SUTA CIT SIMPLE DEDUCTIONS MIDDLE Victor MARITAL STATUS M NET PAID CK. NO. AMOUNT 8,629.73 1,150.30 1,214.14 672 682 MIDDLE Claude MARITAL STATUS M NET PAID CK. NO. AMOUNT 673 683 17,300.01 1,782.01 1,755.61 1,919.01 1,919.01 MIDDLE Louise MARITAL STATUS S NET PAID CK. NO. AMOUNT 4,696.47 933.55 919.15 674 684 MIDDLE Wilson MARITAL STATUS M NET PAID CK. NO. AMOUNT 675 685 4,242.16 1,111.40 1,095.50 MIDDLE Tyler MARITAL STATUS M NET PAID CK. NO. AMOUNT 676 686 30,093.74 1,776.22 1,749.22 MIDDLE Aloise MARITAL STATUS S NET PAID CK. NO. AMOUNT 677 687 4,648.60 896.48 882.38 MIDDLE Allen MARITAL STATUS M NET PAID CK. NO. AMOUNT 678 688 11,219.39 1,170.17 1,317.60 MIDDLE James MARITAL STATUS M NET PAID CK. NO. AMOUNT 679 689 12,104.27 1,572.43 1,548.43 MIDDLE MARITAL STATUS S NET PAID CK. NO. AMOUNT 4,292.19 762.71 751.01 680 690 MIDDLE Virginia MARITAL STATUS S NET PAID CK. NO. AMOUNT 681 691 7,085.36 890.17 875.77 MIDDLE MARITAL STATUS NET PAID CK. NO. AMOUNT MIDDLE MARITAL STATUS NET PAID CK. NO. AMOUNT MIDDLE MARITAL STATUS NET PAID CK. NO. AMOUNT MIDDLE MARITAL STATUS NET PAID CK. NO. AMOUNT 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 DESCRIPTION POST. REF. DEBIT CREDIT 20-- Oct. 9 Payroll Cash Cash 12 11 12,045.44 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,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 1,381.42 12,045.44 958.57 224.19 1,125.00 474.67 10.85 606.05 16.00 12,045.44 958.57 224.18 22.91 175.76 Page 42 JOURNAL DATE DESCRIPTION POST. REF. DEBIT CREDIT 20-- Oct 23 Payroll Cash Cash 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 Taxes 23 Payroll Taxes FICA Taxes Payable - OASDI FICA Taxes Payable - HI FUTA Taxes Payable SUTA Taxes Payable - Employer 12,108.81 12,108.81 2,307.69 4,651.08 3,600.00 5,223.92 978.53 228.86 1,155.00 484.55 11.07 618.67 181.20 16.00 12,108.81 1,387.29 978.53 228.85 4.15 175.76 Page 43 JOURNAL DATE 20-- Nov DESCRIPTION POST. REF. DEBIT CREDIT Page 44 JOURNAL DATE 20-- DESCRIPTION POST. REF. DEBIT CREDIT Page 45 JOURNAL DATE DESCRIPTION POST. REF. DEBIT CREDIT 20-- JAN 6 Employees SIT payable 6 Employees SIT payable 6 cash 8 Union Due 8 cash 15 FICA Payable(HI) FICA Payable(OASDI) cash 15 CIT Payable CIT Payable Cash 15 Taxes cash 1 1 1 2 2 3 3 247.34 418.29 330.84 5,327.39 4 4 315.82 534.08 5 5 15.98 665.63 32.00 32.00 5,658.23 849.08 15.98 Page 46 JOURNAL DATE 20-- DESCRIPTION POST. REF. DEBIT CREDIT Page 47 JOURNAL DATE DESCRIPTION POST. REF. DEBIT CREDIT 20-- ### ### ### ### Page 48 JOURNAL DATE 20-- DESCRIPTION POST. REF. DEBIT CREDIT GENERAL LEDGER ACCOUNT: Checkpoints CASH ACCOUNT NO. 11 BALANCE POST. DATE ITEM REF. DEBIT CREDIT DEBIT 20-- Oct. 1 Balance 9 20 23 a J41 J41 J41 199,846.33 12,045.44 187,800.89 474.67 187,326.22 12,108.81 175,217.41 CREDIT Debit Credit Balance Balance Oct. 31, 20-- 175,217.41 Nov. 30, 20-Dec. 31, 20-- ACCOUNT: PAYROLL CASH ACCOUNT NO. 12 BALANCE POST. DATE ITEM REF. DEBIT J41 J41 J41 J41 12,045.44 CREDIT DEBIT 20-- Oct. 9 9 23 23 12,045.44 12,108.81 12,108.81 12,045.44 0.00 12,108.81 0.00 CREDIT Checkpoints Debit Credit Balance Balance Oct. 31, 20-0.00 Nov. 30, 20-Dec. 31, 20-- ACCOUNT: FICA TAXES PAYABLE - OASDI ITEM REF. DEBIT CREDIT DEBIT CREDIT 20-- Oct. 9 9 23 23 J41 J41 J41 J41 Debit Balance BALANCE POST. DATE Checkpoints ACCOUNT NO. 20.1 958.57 958.57 978.53 978.53 958.57 1,917.14 2,895.67 3,874.20 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance 3,874.20 ACCOUNT: FICA TAXES PAYABLE - HI ITEM REF. DEBIT CREDIT DEBIT CREDIT 20-- Oct. 9 9 23 23 J41 J41 J41 J41 Debit Balance BALANCE POST. DATE Checkpoints ACCOUNT NO. 20.2 224.19 224.18 228.86 228.85 224.19 448.37 677.23 906.08 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance 906.08 ACCOUNT: FUTA TAXES PAYABLE ITEM REF. DEBIT CREDIT DEBIT CREDIT 20-- Oct. 1 Balance 9 23 a J41 J42 Debit Balance BALANCE POST. DATE Checkpoints ACCOUNT NO. 21 22.91 4.15 392.94 415.85 420.00 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance 420.00 ACCOUNT: SUTA TAXES PAYABLE - EMPLOYER ITEM REF. DEBIT CREDIT DEBIT CREDIT 20-- Oct. 9 23 J41 J42 Debit Balance BALANCE POST. DATE Checkpoints ACCOUNT NO. 22 175.76 175.76 175.76 351.52 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance 351.52 ACCOUNT: EMPLOYEES FIT PAYABLE ITEM REF. DEBIT CREDIT DEBIT CREDIT 20-- Oct. 9 23 J41 J42 Debit Balance BALANCE POST. DATE Checkpoints ACCOUNT NO. 24 1,125.00 1,155.00 1,125.00 2,280.00 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance 2,280.00 ACCOUNT: EMPLOYEES SIT PAYABLE ITEM REF. DEBIT CREDIT DEBIT CREDIT 20-- Oct. 9 20 23 J41 J41 J42 Debit Balance BALANCE POST. DATE Checkpoints ACCOUNT NO. 25 474.67 474.67 484.55 474.67 0.00 484.55 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance 484.55 ACCOUNT: EMPLOYEES SUTA PAYABLE ITEM REF. Debit Balance BALANCE POST. DATE DEBIT CREDIT DEBIT CREDIT 20-- Oct. 9 23 J41 Checkpoints ACCOUNT NO. 25.1 10.85 11.07 10.85 21.92 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance 21.92 ACCOUNT: EMPLOYEES CIT PAYABLE ITEM REF. DEBIT CREDIT DEBIT CREDIT 20-- Oct. 9 23 J41 Debit Balance BALANCE POST. DATE Checkpoints ACCOUNT NO. 26 606.05 618.67 606.05 1,224.72 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance 1,224.72 ACCOUNT: GROUP INSURANCE PREMIUMS COLLECTED ITEM REF. DEBIT CREDIT DEBIT CREDIT 20-- Oct 23 J42 Debit Balance BALANCE POST. DATE Checkpoints ACCOUNT NO. 27 181.20 181.20 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance 181.20 ACCOUNT: UNION DUES PAYABLE ITEM REF. Debit Balance BALANCE POST. DATE Checkpoints ACCOUNT NO. 28 DEBIT CREDIT DEBIT CREDIT 20-- Oct. 9 23 J41 16.00 16.00 16.00 32.00 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance 32.00 ACCOUNT: SIMPLE CONTRIBUTIONS PAYABLE 20-- ITEM REF. Debit Balance BALANCE POST. DATE Checkpoints ACCOUNT NO. 29 DEBIT CREDIT DEBIT CREDIT Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance ACCOUNT: ADMINISTRATIVE SALARIES ACCOUNT NO. 51 BALANCE POST. DATE ITEM REF. DEBIT CREDIT DEBIT 20-- Oct. 1 Balance 9 23 a J41 J41 2,307.69 2,307.69 42,692.27 44,999.96 47,307.65 CREDIT Checkpoints Debit Credit Balance Balance Oct. 31, 20-- 47,307.65 Nov. 30, 20-Dec. 31, 20-- ACCOUNT: OFFICE SALARIES ACCOUNT NO. 52 BALANCE POST. DATE ITEM REF. DEBIT CREDIT DEBIT 20-- Oct. 1 Balance 9 23 a J41 J41 4,651.08 4,651.08 28,350.00 33,001.08 37,652.16 CREDIT Checkpoints Debit Credit Balance Balance Oct. 31, 20-- 37,652.16 Nov. 30, 20-Dec. 31, 20-- ACCOUNT: SALES SALARIES ACCOUNT NO. 53 BALANCE POST. DATE ITEM REF. DEBIT CREDIT DEBIT 20-- Oct. 1 Balance 9 23 a J41 3,600.00 3,600.00 28,525.00 32,125.00 35,725.00 CREDIT Checkpoints Debit Credit Balance Balance Oct. 31, 20-- 35,725.00 Nov. 30, 20-Dec. 31, 20-- ACCOUNT: PLANT WAGES ACCOUNT NO. 54 BALANCE POST. DATE ITEM REF. DEBIT CREDIT DEBIT 20-- Oct. 1 Balance 9 23 a J41 4,902.00 5,223.92 42,657.30 47,559.30 52,783.22 CREDIT Checkpoints Debit Credit Balance Balance Oct. 31, 20-- 52,783.22 Nov. 30, 20-Dec. 31, 20-- ACCOUNT: PAYROLL TAXES ACCOUNT NO. 56 BALANCE POST. DATE ITEM REF. DEBIT CREDIT DEBIT 20-- Oct. 1 Balance 9 23 a J41 J41 1,381.42 1,387.29 14,123.59 15,505.01 16,892.30 CREDIT Checkpoints Debit Credit Balance Balance Oct. 31, 20-- 16,892.30 Nov. 30, 20-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.65 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.65 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 8 8 8 GLO-BRITE PAINT COMP 8 8 8 8 8 8 8 8 8 8 8 8 80 17.65 80 80 Amount Overtime Earnings Rate Per Hrs. Hour Amount Total Earnings OASDI 1,412.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,412.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.54 139.50 75.64 83.70 143.08 74.40 89.28 127.10 62.50 75.83 15,460.77 15,460.77 958.57 1,517.92 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 94.11 139.50 75.64 83.70 143.08 74.40 102.67 127.10 62.50 75.83 15,460.77 321.92 15,782.69 978.53 1,412.00 2,250.00 1,220.00 1,412.00 2,250.00 1,220.00 87.54 139.50 75.64 1,412.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.48 105.92 8 27.00 216.00 Mann, D. O'Neill, J. Russell, V. Ryan, N. Sokowski, T. (Student) Williams, R. No. W/H Allow. NAME Marital Status PAYROLL REGISTER M M S M M S S 4 3 1 4 2 1 0 Time Record S M 8 8 6 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 7 F S S M 8 8 8 8 8 8 8 8 8 8 4 8 8 8 Regular Earnings T 8 8 8 8 8 8 8 Rate Per W T F S Hrs. Hour 8 8 8 80 8 8 8 80 8 8 8 78 8 8 8 80 18.00 8 8 8 80 8 8 4 72 14.00 8 8 8 79 TOTALS Payday, November 13, 20-- For Period Ending November 14, 20-Williams, R. S 0 TOTALS GLO-BRITE PAINT COMP 136 Overtime Earnings Rate Per Hrs. Hour Total Earnings 1,350.00 2,307.69 1,170.00 1,440.00 2,050.00 1,008.00 1,207.85 OASDI 83.70 143.08 72.54 89.28 127.10 62.50 74.89 15,415.54 15,415.54 955.77 2,079.32 2,079.32 128.92 2,079.32 2,079.32 128.92 Amount 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 4 8 8 8 8 8 8 O'Neill, J. M 3 8 8 8 8 8 8 Russell, V. S 1 6 8 8 8 8 8 Ryan, N. M 4 8 8 8 8 8 8 Sokowski, T. M 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.65 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. Ferguson, J. Ford, C. Mann, D. O'Neill, J. Russell, V. Ryan, N. Sokowski, T. (Student) Woods, B. TOTALS Payday, December 14, 20-- For Period Ending December 12, 20-Russell, V. TOTALS GLO-BRITE PAINT COMP 40 17.65 40 40 40 40 40 36 18.00 40 36 14.00 32 Amount Overtime Earnings Rate Per Hrs. Hour Amount Total Earnings OASDI 1,129.60 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,129.60 2,250.00 1,220.00 1,350.00 2,307.69 1,170.00 1,440.00 2,050.00 1,008.00 70.04 139.50 75.64 83.70 143.08 72.54 89.28 127.10 62.50 13,925.29 13,925.29 863.38 706.00 1,125.00 610.00 675.00 1,153.50 585.00 648.00 1,025.00 504.00 1,025.00 706.00 1,125.00 610.00 675.00 1,153.50 585.00 648.00 1,025.00 504.00 1,025.00 43.77 69.75 37.82 41.85 71.52 36.27 40.18 63.55 31.25 63.55 8,056.50 8,056.50 499.51 1,134.00 1,260.00 2,394.00 1,134.00 1,260.00 2,394.00 70.31 70.31 No. W/H Allow. NAME Marital Status PAYROLL REGISTER Time Record S M T W T TOTALS 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. Ferguson, J. Ford, C. Mann, D. O'Neill, J. Ryan, N. Sokowski, T. (Student) Woods, B. Young, P. GLO-BRITE PAINT COMP 48 17.65 48 36 48 48 43 18.00 48 32 14.00 40 40 F S S M T W T F S HRS Amount Overtime Earnings Rate Per Hrs. Hour Amount Total Earnings OASDI 847.20 2,250.00 1,220.00 1,350.00 2,307.69 774.00 1,170.00 448.00 2,050.00 1,207.85 847.20 2,250.00 1,220.00 1,350.00 2,307.69 774.00 1,170.00 448.00 2,050.00 1,207.85 52.53 139.50 75.64 83.70 4,056.22 47.99 72.54 27.78 127.10 74.89 13,624.74 13,624.74 4,757.89 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.47 46.00 43.35 32.63 137.00 69.08 17.69 107.00 37.45 19.58 40.00 41.45 33.46 192.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 153.00 37.55 224.19 1,125.00 474.67 Payday, October 23, 20-- For Period Ending October 17, 20-Bonno, A. 22.01 56.00 46.60 Ferguson, J. 32.63 137.00 69.08 Ford, C. 17.69 107.00 37.45 Mann, D. 19.58 40.00 41.45 O'Neill, J. 33.46 192.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 153.00 37.55 TOTALS 228.86 1,155.00 484.55 Payday, November 6, 20-- For Period Ending October 31, 20-Bonno, A. 20.47 46.00 43.35 Ferguson, J. 32.63 137.00 69.08 Ford, C. 17.69 107.00 37.45 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 0.85 GLO-BRITE PAINT COMPANY Deductions NAME Mann, D. O'Neill, J. Russell, V. Ryan, N. Sokowski, T. (Student) Williams, R. TOTALS HI 19.58 33.46 16.97 20.88 29.73 14.62 17.51 FIT 117.00 192.00 98.00 50.00 252.00 97.00 150.00 SIT 41.45 70.85 35.92 44.21 62.94 30.95 37.08 SUTA 0.95 1.62 0.82 1.01 1.44 0.71 0.85 223.54 1,246.00 473.28 10.82 Payday, November 13, 20-- For Period Ending November 14, 20-Williams, R. 30.15 334.00 63.84 1.46 TOTALS 30.15 334.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.38 18.00 34.68 0.79 Ferguson, J. 32.63 65.00 69.08 1.58 Ford, C. 17.69 107.00 37.45 0.85 Mann, D. 19.58 81.00 41.45 0.95 O'Neill, J. 33.46 87.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 252.00 62.94 1.44 (Student) 14.62 97.00 30.95 0.71 TOTALS 201.94 835.00 427.53 Payday, December 4, 20-- For Period Ending November 28, 20-Bonno, A. 10.24 21.67 Ferguson, J. 16.31 34.54 Ford, C. 8.85 18.73 Mann, D. 9.79 20.72 O'Neill, J. 16.73 35.41 Russell, V. 8.48 17.96 Ryan, N. 9.40 19.89 Sokowski, T. 14.86 31.47 (Student) 7.31 15.47 Woods, B. 14.86 31.47 TOTALS 116.83 0.00 247.33 9.77 0.49 0.79 0.43 0.47 0.81 0.41 0.45 0.72 0.35 0.72 5.64 Payday, December 14, 20-- For Period Ending December 12, 20-Russell, V. 16.44 0.79 TOTALS 16.44 0.00 0.00 0.79 GLO-BRITE PAINT COMPANY Deductions NAME HI FIT SIT SUTA Payday, December 18, 20-- For Period Ending December 12, 20-Bonno, A. 12.28 26.01 0.59 Ferguson, J. 32.63 69.08 1.58 Ford, C. 17.69 37.45 0.85 Mann, D. 19.58 41.45 0.95 O'Neill, J. 33.46 70.85 1.62 Ryan, N. 11.22 23.76 0.54 Sokowski, T. 16.97 35.92 0.82 (Student) 6.50 13.75 0.31 Woods, B. 29.73 62.94 1.44 Young, P. 17.51 37.08 0.85 TOTALS 197.57 0.00 418.29 9.55 Deductions NAME Payday, October 9, 20-Bonno, A. Ferguson, J. Ford, C. Mann, D. O'Neill, J. Russell, V. Ryan, N. Sokowski, T. (Student) Williams, R. TOTALS Net Paid CIT Group Ins. Union Dues Ck. SIMPLE No. For Period Ending October 3, 20-55.35 8.00 88.20 47.82 52.92 90.46 47.04 56.45 8.00 80.36 39.51 47.94 606.05 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.50 16.50 8.00 Ferguson, J. 88.20 26.40 Ford, C. 47.82 14.40 Mann, D. 52.92 15.90 O'Neill, J. 90.46 27.00 Russell, V. 47.04 14.10 Ryan, N. 64.92 16.80 8.00 Sokowski, T. 80.36 24.00 (Student) 39.51 11.70 Williams, R. 47.94 14.40 TOTALS 618.67 181.20 16.00 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.35 8.00 Ferguson, J. 88.20 Ford, C. 47.82 692 693 694 Amount 1,150.30 1,782.01 933.55 1,111.40 1,776.22 896.48 1,170.17 1,572.43 762.71 890.17 Taxable Earnings OASDI HI 1,412.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,412.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,045.44 15,460.77 15,460.77 1,214.14 1,755.61 919.15 1,095.50 1,749.22 882.38 1,317.60 1,548.43 751.01 875.77 1,517.92 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,517.92 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,108.81 15,782.69 15,782.69 1,150.30 1,782.01 933.55 1,412.00 2,250.00 1,220.00 1,412.00 2,250.00 1,220.00 Labor Cost Distribution FUTA SUTA Admin. Office 700.00 1,350.00 1,220.00 1,350.00 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 2,307.69 4,651.08 1,220.00 250.00 1,220.00 1,350.00 1,220.00 2,307.69 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 260.00 1,220.00 Deductions NAME Net Paid Mann, D. O'Neill, J. Russell, V. Ryan, N. Sokowski, T. (Student) Williams, R. CIT 52.92 90.46 45.86 56.45 80.36 39.51 47.35 TOTALS 604.28 Group Ins. 0.00 Union Dues Ck. SIMPLE No. 696 697 698 8.00 699 700 701 702 16.00 0.00 Payday, November 13, 20-- For Period Ending November 14, 20-Williams, R. 81.51 14.40 703 TOTALS 81.51 14.40 0.00 0.00 Amount 1,034.40 1,776.22 899.89 1,170.17 1,496.43 762.71 880.17 Taxable Earnings OASDI 1,350.00 2,307.69 1,170.00 1,440.00 2,050.00 1,008.00 1,207.85 HI 1,350.00 2,307.69 1,170.00 1,440.00 2,050.00 1,008.00 1,207.85 11,885.85 15,415.54 15,415.54 1,425.04 2,079.32 2,079.32 1,425.04 2,079.32 2,079.32 FUTA Labor Cost Distribution SUTA 900.00 Admin. Office 2,307.69 0.00 360.00 1,170.00 1,008.00 1,008.00 1,207.85 2,528.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 Ins. Union Dues Ck. SIMPLE No. Payday, November 20, 20-- For Period Ending November 14, 20-Bonno, A. 44.28 16.50 8.00 Ferguson, J. 88.20 26.40 500.00 Ford, C. 47.82 14.40 Mann, D. 52.92 15.90 250.00 O'Neill, J. 90.46 27.00 700.00 Russell, V. 45.86 14.10 Ryan, N. 56.45 16.80 8.00 200.00 Sokowski, T. 80.36 24.00 (Student) 39.51 11.70 TOTALS 545.86 166.80 16.00 1,650.00 Payday, December 4, 20-- For Period Ending November 28, 20-Bonno, A. 27.68 Ferguson, J. 44.10 Ford, C. 23.91 Mann, D. 26.46 O'Neill, J. 45.22 Russell, V. 22.93 Ryan, N. 25.40 Sokowski, T. 40.18 (Student) 19.76 Woods, B. 40.18 TOTALS 315.82 0.00 0.00 0.00 Payday, December 14, 20-- For Period Ending December 12, 20-Russell, V. TOTALS 0.00 0.00 0.00 0.00 Amount 920.93 1,327.61 919.15 804.50 1,154.22 885.79 973.37 1,472.43 751.01 Taxable Earnings OASDI HI FUTA 1,129.60 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,129.60 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,209.01 13,925.29 13,925.29 Labor Cost Distribution SUTA Admin. Office 1,220.00 2,307.69 1,170.00 426.00 1,008.00 0.00 426.00 2,307.69 3,398.00 602.15 959.51 520.26 575.71 983.81 498.95 552.68 874.22 429.86 874.22 706.00 1,125.00 610.00 675.00 1,153.00 585.00 648.00 1,025.00 504.00 1,025.00 706.00 1,125.00 610.00 675.00 1,153.00 585.00 648.00 1,025.00 504.00 1,025.00 6,871.37 8,056.00 8,056.00 0.00 0.00 0.00 0.00 1,046.46 1,260.00 2,306.46 0.00 0.00 0.00 0.00 0.00 0.00 Deductions NAME Net Paid CIT Group Ins. Union Dues Ck. SIMPLE No. Payday, December 18, 20-- For Period Ending December 12, 20-Bonno, A. 33.21 8.00 Ferguson, J. 88.20 Ford, C. 47.82 Mann, D. 52.92 O'Neill, J. 90.46 Ryan, N. 30.34 8.00 Sokowski, T. 45.86 (Student) 17.56 Woods, B. 80.36 Young, P. 47.35 TOTALS 534.08 0.00 16.00 0.00 Taxable Earnings Amount OASDI HI FUTA 714.58 1,919.01 1,040.55 1,151.40 -1,944.92 652.15 997.89 382.10 1,748.43 1,030.17 847.20 2,250.00 1,220.00 1,350.00 2,307.69 774.00 1,170.00 448.00 2,050.00 1,207.00 847.20 2,250.00 1,220.00 1,350.00 2,307.69 774.00 1,170.00 448.00 2,050.00 1,207.00 0.00 0.00 0.00 0.00 7,691.36 13,623.89 13,623.89 0.00 Labor Cost Distribution SUTA 0.00 Admin. 0.00 Office 0.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,412.00 Total earnings 2,250.00 Net paid 1,350.00 1,440.00 2,050.00 3,600.00 4,902.00 Payday, October 23, 20-- For Period Ending October 17,Checkpoints 20-Bonno, A. 1,517.92 Total earnings Ferguson, J. 2,250.00 Net paid Ford, C. Mann, D. 1,350.00 O'Neill, J. Russell, V. Ryan, N. 1,548.00 Sokowski, T. 2,050.00 (Student) Williams, R. TOTALS 3,600.00 5,115.92 Payday, November 6, 20-- For Period Ending October 31,Checkpoints 20-Bonno, A. 1,412.00 Total earnings Ferguson, J. 2,250.00 Net paid Ford, C. 15,460.77 12,045.44 Labor Cost Distribution NAME Mann, D. O'Neill, J. Russell, V. Ryan, N. Sokowski, T. (Student) Williams, R. TOTALS Sales 1,350.00 Plant 1,440.00 2,050.00 3,600.00 4,902.00 Payday, November 13, 20-- For Period Ending NovemberCheckpoints 14, 20-Williams, R. Total earnings Net paid TOTALS 0.00 0.00 Labor Cost Distribution NAME Sales Plant Payday, November 20, 20-- For Period Ending NovemberCheckpoints 14, 20-Bonno, A. 1,129.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,440.00 Sokowski, T. 2,050.00 (Student) TOTALS 3,600.00 4,619.60 Payday, December 4, 20-- For Period Ending November Checkpoints 28, 20-Bonno, A. Total earnings Ferguson, J. Net paid Ford, C. Mann, D. O'Neill, J. Russell, V. Ryan, N. Sokowski, T. (Student) Woods, B. TOTALS 0.00 0.00 Payday, December 14, 20-- For Period Ending DecemberCheckpoints 12, 20-Russell, V. Total earnings Net paid TOTALS 0.00 0.00 Labor Cost Distribution NAME Sales Plant Payday, December 18, 20-- For Period Ending DecemberCheckpoints 12, 20-Bonno, A. Total earnings Ferguson, J. Net paid Ford, C. Mann, D. O'Neill, J. Ryan, N. Sokowski, T. (Student) Woods, B. Young, P. TOTALS 0.00 0.00 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 AMOUNT 10/9 2 10/23 3 11/6 4 11/20 5 12/4 6 12/18 QTR. TOT. 80 80 17.65 17.65 40 200 17.65 HRS. RATE 10,293.40 1,412.00 1,412.00 YEAR-TO-DATE 1 OVERTIME EARNINGS 4 26.48 706.00 3,530.00 13,823.40 YR. TOT. OVERTIME R CUMULATIVE EARNINGS AMOUNT 17.65 26.48 DEDUCTIONS OTHER HI 11,322.00 12,734.00 14,251.92 701.96 87.54 94.11 164.17 20.47 22.01 #VALUE! 3,635.92 #VALUE! 43.77 225.42 927.38 10.24 52.72 216.89 FIT SIT 810.00 46.00 56.00 SUTA 7.93 0.99 1.06 443.82 55.35 59.50 21.67 111.62 459.21 0.49 2.54 10.47 27.68 142.53 586.35 OCCUPATION WORKS IN (STATE) Sales Sales Manager PA SEX M F x S.S. ACCOUNT NO. 000-00-8645 OTHER DEDUCTIONS INFORMATION NAME - LAST FERGUSON $ $ $ $ OTHER WEEKLY RATE HOURLY RATE $88,000 -- $.30/M OVERTIME R OVERTIME EARNINGS PAYDAY HRS. 1 10/9 2 10/23 3 11/6 4 11/20 5 12/4 6 12/18 QTR. TOT. YR. TOT. CUMULATIVE EARNINGS YEAR-TO-DATE 80 80 80 80 80 80 480 RATE 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 DEDUCTIONS 216.80 8.00 24.50 FIRST SALARY UNION DUES REGULAR EARNINGS SIMPLE Checkpoint DEPARTMENT 20___ CIT 347.59 43.35 46.60 Checkpoint GROUP INSURANCE 4 FICA OASDI 1,028.60 0.00 105.92 0.00 0.00 0.00 0.00 105.92 1,134.52 W/H ALLOW. AMOUNT W/H ALLOW. 5 DEDUCTIONS 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 James 58,500 /yr. 1,125.00 28.13 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 137.00 137.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 906.50 88.20 88.20 88.20 88.20 88.20 88.20 529.20 1,435.70 SIMPLE DEDUCTIONS 132.30 26.40 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 RATE HOURLY RATE $48,000--$.30/M 20___ OVERTIME R REGULAR EARNINGS OVERTIME EARNINGS CUMULATIVE PAYDAY EARNINGS HRS. RATE AMOUNT 1 10/9 2 10/23 3 11/6 4 11/20 5 12/4 6 12/18 QTR. TOT. HRS. RATE AMOUNT 80 80 80 80 40 36 396 YR. TOT. 6,300.00 7,520.00 8,740.00 9,960.00 11,180.00 11,790.00 13,010.00 6,710.00 13,010.00 2 FICA 390.60 75.64 75.64 75.64 75.64 37.82 75.64 416.02 806.62 OTHER HI 91.35 17.69 17.69 17.69 17.69 8.85 17.69 97.30 188.65 FIT 639.00 107.00 107.00 SIT SUTA 193.41 37.45 37.45 37.45 37.45 18.73 37.45 205.98 399.39 4.41 0.85 0.85 0.85 0.85 0.43 0.85 4.68 9.09 Checkpoint CIT SIMPLE DEDUCTIONS 246.96 47.82 47.82 47.82 47.82 23.91 47.82 263.01 509.97 37.80 14.40 Checkpoint OCCUPATION DEPARTMENT W/H ALLOW. DEDUCTIONS OASDI 6,300.00 1,220.00 1,220.00 1,220.00 1,220.00 610.00 1,220.00 6,710.00 13,010.00 YEAR-TO-DATE Catherine 2,643.33 /mo. 610.00 15.25 22.88 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 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. YR. TOT. CUMULATIVE 80 80 80 80 40 48 408 RATE AMOUNT 5,400.00 1,350.00 1,350.00 1,350.00 1,350.00 675.00 1,350.00 7,425.00 12,825.00 HRS. RATE AMOUNT W/H ALLOW. 4 DEDUCTIONS FICA OASDI 5,400.00 6,750.00 8,100.00 9,450.00 10,800.00 11,475.00 12,825.00 7,425.00 12,825.00 Dewey 2,925 /mo. 675.00 16.88 334.80 83.70 83.70 83.70 83.70 41.85 83.70 460.35 795.15 OTHER HI 78.30 19.58 19.58 19.58 19.58 9.79 19.58 107.69 185.99 FIT 332.00 40.00 40.00 SIT 165.78 41.45 41.45 41.45 41.45 20.72 41.45 227.97 393.75 SUTA 3.78 0.95 0.95 0.95 0.95 0.47 0.95 5.22 9.00 CIT 211.68 52.92 52.92 52.92 52.92 26.46 52.92 291.06 502.74 SIMPLE DEDUCTIONS 31.50 15.90 Checkpoint 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 RATE HOURLY RATE $90,000 -- $.30/M 20___ OVERTIME R REGULAR EARNINGS OVERTIME EARNINGS CUMULATIVE PAYDAY EARNINGS HRS. RATE AMOUNT 1 10/9 2 10/23 3 11/6 4 11/20 5 12/4 6 12/18 80 80 80 80 40 48 408 TR. TOT. HRS. RATE AMOUNT YR. TOT. 42,692.27 44,999.96 47,307.65 49,615.34 51,923.03 53,076.88 55,384.57 12,692.30 55,384.57 3 FICA 2,646.92 143.08 143.08 143.08 143.08 71.54 4,056.22 4,700.08 7,347.00 OTHER HI 619.04 33.46 33.46 33.46 33.46 16.73 33.46 184.03 803.07 FIT 6,116.00 192.00 192.00 SIT SUTA 1,310.65 70.85 70.85 70.85 70.85 35.42 70.85 389.67 1,700.32 29.88 1.62 1.62 1.62 1.62 0.81 1.62 8.91 38.79 Checkpoint CIT SIMPLE 1,673.54 90.46 90.46 90.46 90.46 45.23 90.46 497.53 2,171.07 DEDUCTIONS 202.50 27.00 Checkpoint OCCUPATION DEPARTMENT W/H ALLOW. DEDUCTIONS OASDI 42,692.27 2,307.69 2,307.69 2,307.69 2,307.69 1,153.85 2,307.69 12,692.30 55,384.57 YEAR-TO-DATE 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 RATE HOURLY RATE $47,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. YR. TOT. CUMULATIVE 80 80 78 78 40 RATE AMOUNT 6,240.00 1,200.00 1,200.00 1,170.00 1,170.00 585.00 2,394.00 7,719.00 13,959.00 HRS. RATE AMOUNT W/H ALLOW. 1 DEDUCTIONS FICA OASDI 6,240.00 7,440.00 8,640.00 9,810.00 10,980.00 11,565.00 13,959.00 7,719.00 13,959.00 Virginia 2,600 /mo. 600.00 15.00 22.50 386.88 74.40 74.40 72.54 72.54 36.27 330.15 717.03 OTHER HI 90.48 17.40 17.40 16.97 16.97 8.48 34.71 111.93 202.41 FIT 642.00 127.00 127.00 254.00 896.00 SIT 191.56 36.84 36.84 35.92 35.92 17.96 0.00 163.48 355.04 SUTA 4.37 0.84 0.84 0.82 0.82 0.41 1.68 5.41 9.78 CIT 244.61 47.04 47.04 45.86 45.86 22.93 208.73 453.34 SIMPLE DEDUCTIONS 31.50 14.10 Checkpoint 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 RYAN Norman $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $56,000 -- $.30/M 20___ $8 each pay REGULAR EARNINGS OVERTIME EARNINGS OVERTIME R CUMULATIVE PAYDAY EARNINGS HRS. RATE AMOUNT 13,287.50 1,440.00 1,440.00 YEAR-TO-DATE 1 10/9 2 10/23 3 11/6 4 11/20 5 12/4 6 12/18 80 80 18.00 18.00 HRS. RATE 8 27.00 AMOUNT 14,685.30 16,125.30 17,781.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 OTHER HI 212.94 20.88 24.01 FIT 1,070.00 50.00 70.00 SIT SUTA 450.84 44.21 50.84 10.28 1.01 1.16 CIT SIMPLE 575.66 56.45 64.92 DEDUCTIONS 235.70 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___ 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. YR. TOT. CUMULATIVE 80 80 48 208 RATE AMOUNT HRS. RATE AMOUNT W/H 1,025.00 25.63