Payroll Project Chapter 7

Anonymous
timer Asked: May 12th, 2018
account_balance_wallet $30

Question description

I need help with my payroll project. Chapter 7 from Payroll Accounting 2018 by Bieg and Toland. I have attached the excel files. Thank you.

Excel Instructions CAUTION: Read Appendix A for specific instructions relating to these templates. 1. Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear to the right of an incorrect answer. 2. A formula begins with an equals sign (=) and can consist of any of the following elements: Operators such as + (for addition), - (for subtraction), * (for multiplication), and / (for division). Cell references, including cell addresses such as B52, as well as named cells and ranges Values and text Worksheet functions (such as SUM) 3. You can enter a formula into a cell manually (typing it in) or by pointing to the cells. To enter a formula manually, follow these steps: Move the cell pointer to the cell that you want to hold the formula. Type an equals sign (=) to signal the fact that the cell contains a formula. Type the formula, then press Enter. 4. Rounding: These templates have been formatted to round numbers to either the nearest whole number or the nearest cent. For example, 17.65 x 1.5=26.475. The template will display and hold 26.48, not 26.475. There is no need to use Excel's rounding function. 5. Remember to save your work. When saving your workbook, Excel overwrites the previous copy of your file. You can save your work at any time. You can save the file to the current name, or you may want to keep multiple versions of your work by saving each successive version under a different name. To save to the current name, you can select File, Save from the menu bar or click on the disk icon in the standard toolbar. It is recommended that you save the file to a new name that identifies the file as yours, such as Chapter_7_long_version_Your_Name.xlsx To save under a different name, follow these steps: Select File, Save As to display the Save As Type drop-box, chose Excel Workbook (*.xlsx) Select the folder in which to store the workbook. Enter the new filename in the File name box. Click Save. Page 41 JOURNAL DATE 20-- Oct. DESCRIPTION 9 Payroll Cash Cash POST. REF. DEBIT 12 11 12,052.01 9 Administrative Salaries Office Salaries Sales Salaries Plant Wages FICA Taxes Payable - OASDI FICA Taxes Payable - HI Employees FIT Payable Employees SIT Payable Employees SUTA Payable Employees CIT Payable Union Dues Payable Payroll Cash 51 52 53 54 20.1 20.2 24 25 25.1 26 28 12 2,307.69 4,651.08 3,600.00 4,898.00 9 Payroll Taxes FICA Taxes Payable - OASDI FICA Taxes Payable - HI FUTA Taxes Payable SUTA Taxes Payable - Employer 56 20.1 20.2 21 22 1,381.11 CREDIT 12,052.01 958.33 224.14 1,118.00 474.55 10.85 602.89 16.00 12,052.01 958.32 224.12 22.91 175.76 20 Employees SIT Payable Cash 25 11 474.55 23 Payroll Cash Cash 12 11 12,115.19 474.55 12,115.19 Page 42 JOURNAL DATE 20-- Oct. Nov. DESCRIPTION POST. REF. DEBIT 23 Administrative Salaries Office Salaries Sales Salaries Plant Wages FICA Taxes Payable - OASDI FICA Taxes Payable - HI Employees FIT Payable Employees SIT Payable Employees SUTA Payable Employees CIT Payable Group Insurance Premiums Collected Union Dues Payable Payroll Cash 51 52 53 54 20.1 20.2 24 25 25.1 26 27 28 12 2,307.69 4,651.08 3,600.00 5,219.60 23 Payroll Taxes FICA Taxes Payable - OASDI FICA Taxes Payable - HI FUTA Taxes Payable SUTA Taxes Payable - Employer 56 20.1 20.2 21 22 1,386.96 CREDIT 978.26 228.80 1,148.00 484.42 11.07 615.43 181.20 16.00 12,115.19 978.26 228.79 4.15 175.76 4 Employees SIT Payable Cash 25 11 484.42 6 Union Dues Payable Cash 28 11 32.00 484.42 32.00 Page 43 JOURNAL DATE 20-- Nov. DESCRIPTION 6 Payroll Cash Cash POST. REF. DEBIT 12 11 11,893.42 6 Administrative Salaries Office Salaries Sales Salaries Plant Wages FICA Taxes Payable - OASDI FICA Taxes Payable - HI Employees FIT Payable Employees SIT Payable Employees SUTA Payable Employees CIT Payable Union Dues Payable Payroll Cash 51 52 53 54 20.1 20.2 24 25 25.1 26 28 12 2,307.69 4,605.85 3,600.00 4,898.00 6 Payroll Taxes FICA Taxes Payable - OASDI FICA Taxes Payable - HI SUTA Taxes Payable - Employer 56 20.1 20.2 22 1,343.71 12 11 1,428.45 13 Payroll Cash Cash CREDIT 11,893.42 955.53 223.49 1,238.00 473.16 10.82 601.12 16.00 11,893.42 955.52 223.47 164.72 1,428.45 Page 44 JOURNAL DATE 20-- Nov. DESCRIPTION POST. REF. DEBIT 13 Office Salaries FICA Taxes Payable - OASDI FICA Taxes Payable - HI Employees FIT Payable Employees SIT Payable Employees SUTA Payable Employees CIT Payable Group Insurance Premiums Collected Payroll Cash 52 20.1 20.2 24 25 25.1 26 27 12 2,079.32 13 Payroll Taxes FICA Taxes Payable - OASDI FICA Taxes Payable - HI 56 20.1 20.2 159.07 16 FICA Taxes Payabe-OASDI FICA Taxes Payable-HI Employee FIT Payable Cash 20.1 20.2 24 11 3,873.17 905.85 2,266.00 16 Employee CIT Payable Cash 26 11 1,218.32 18 Employees SIT Payable Cash 25 11 537.00 20 Payroll Cash Cash 12 11 9,216.00 51 52 53 54 20.1 20.2 24 25 25.1 26 27 28 29 12 2,307.69 3,398.00 3,600.00 4,616.40 20 Administrative Salaries Office Salaries Sales Salaries Plant Wages FICA Taxes Payable - OASDI FICA Taxes Payable - HI Employees FIT Payable Employees SIT Payable Employees SUTA Payable Employees CIT Payable Group Insurance Premiums Collected Union Dues Payable SIMPLE Contributions Payable Payroll Cash CREDIT 128.92 30.15 331.00 63.84 1.46 81.10 14.40 1,428.45 128.92 30.15 7,045.02 1,218.32 537.00 9,216.00 863.18 201.89 828.00 427.43 9.77 543.02 166.80 16.00 1,650.00 9,216.00 Page 45 JOURNAL DATE 20-- Nov. DESCRIPTION 20 Payroll Taxes FICA Taxes Payable - OASDI FICA Taxes Payable - HI SUTA Taxes Payable - Employer POST. REF. 56 20.1 20.2 22 DEBIT CREDIT 1,113.15 863.17 201.87 48.11 Page 46 JOURNAL DATE 20-- DESCRIPTION POST. REF. DEBIT CREDIT Page 47 JOURNAL DATE 20-- DESCRIPTION POST. REF. DEBIT CREDIT Page 48 JOURNAL DATE 20-- DESCRIPTION POST. REF. DEBIT CREDIT Page 49 JOURNAL DATE 20-- DESCRIPTION POST. REF. DEBIT CREDIT Page 50 JOURNAL DATE 20-- DESCRIPTION POST. REF. DEBIT CREDIT Total debits and credits (calculated automatically): 124,528.47 124,528.47 Your debits and credits should be equal after each journal entry is complete Cumulative Journal Checkpoint Through Month Ending 58,644.96 124,528.47 October 31, 20-November 30, 20-- December 31, 20-January 31, 20-- GENERAL LEDGER Checkpoints ACCOUNT: ACCOUNT NO. 11 CASH DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT 20-- Oct. Nov. 1 Balance 9 20 23 4 6 6 13 16 16 16 20 a J41 J41 J41 J42 J42 J43 J43 J44 J44 J44 J44 12,052.01 474.55 12,115.19 484.42 32.00 11,893.42 1,428.45 7,045.02 1,218.32 537.00 9,216.00 199,846.33 187,794.32 187,319.77 175,204.58 174,720.16 174,688.16 162,794.74 161,366.29 154,321.27 153,102.95 152,565.95 143,349.95 CREDIT Debit Balance Oct. 31, 20-- 175,204.58 Nov. 30, 20-- 143,349.95 Dec. 31, 20-- Credit Balance ACCOUNT: ACCOUNT NO. 12 PAYROLL CASH DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT 20-- Oct. Nov. 9 9 23 23 6 6 13 13 20 20 J41 J41 J41 J42 J43 J43 J43 J44 J44 J44 Checkpoints 12,052.01 12,052.01 12,115.19 12,115.19 11,893.42 11,893.42 1,428.45 1,428.45 9,216.00 9,216.00 12,052.01 0.00 12,115.19 0.00 11,893.42 0.00 1,428.45 0.00 9,216.00 0.00 CREDIT Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Debit Balance 0.00 0.00 Credit Balance ACCOUNT: ACCOUNT NO. 20.1 FICA TAXES PAYABLE - OASDI DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT CREDIT 20-- Oct. Nov. 9 9 23 23 6 6 13 13 16 20 20 J41 J41 J42 J42 J43 J43 J44 J44 J44 J44 J45 Checkpoints Debit Balance 958.33 958.32 978.26 978.26 955.53 955.52 128.92 128.92 3,873.17 863.18 863.17 958.33 1,916.65 2,894.91 3,873.17 4,828.70 5,784.22 5,913.14 6,042.06 2,168.89 3,032.07 3,895.24 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance 3,873.17 3,895.24 ACCOUNT: ACCOUNT NO. 20.2 FICA TAXES PAYABLE - HI DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT CREDIT 20-- Oct. Nov. 9 9 23 23 6 6 13 13 16 20 20 J41 J41 J42 J42 J43 J43 J44 J44 J44 J44 J45 Checkpoints Debit Balance 224.14 224.12 228.80 228.79 223.49 223.47 30.15 30.15 905.85 201.89 201.87 224.14 448.26 677.06 905.85 1,129.34 1,352.81 1,382.96 1,413.11 507.26 709.15 911.02 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance 905.85 911.02 ACCOUNT: ACCOUNT NO. 21 FUTA TAXES PAYABLE DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT CREDIT 20-- Oct. 1 Balance 9 23 a J41 J42 Checkpoints Debit Balance 22.91 4.15 392.94 415.85 420.00 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance 420.00 420.00 ACCOUNT: ACCOUNT NO. 22 SUTA TAXES PAYABLE - EMPLOYER DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT CREDIT 20-- Oct. Nov. 9 23 6 20 J41 J42 J43 J45 Checkpoints Debit Balance 175.76 175.76 164.72 48.11 175.76 351.52 516.24 564.35 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance 351.52 564.35 ACCOUNT: ACCOUNT NO. 24 EMPLOYEES FIT PAYABLE DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT CREDIT 20-- Oct. Nov. 9 23 6 13 16 20 J41 J42 J43 J44 J44 J44 Checkpoints Debit Balance 1,118.00 1,148.00 1,238.00 331.00 2,266.00 828.00 1,118.00 2,266.00 3,504.00 3,835.00 1,569.00 2,397.00 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance 2,266.00 2,397.00 ACCOUNT: ACCOUNT NO. 25 EMPLOYEES SIT PAYABLE DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT CREDIT 20-- Oct. Nov. 9 20 23 4 6 13 18 20 J41 J41 J42 J42 J43 J44 J44 J44 Checkpoints Debit Balance 474.55 474.55 484.42 484.42 473.16 63.84 537.00 427.43 474.55 0.00 484.42 0.00 473.16 537.00 0.00 427.43 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance 484.42 427.43 ACCOUNT: ACCOUNT NO. 25.1 EMPLOYEES SUTA PAYABLE DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT CREDIT 20-- Oct. Nov. 9 23 6 13 20 J41 J42 J43 J44 J44 Checkpoints Debit Balance 10.85 11.07 10.82 1.46 9.77 10.85 21.92 32.74 34.20 43.97 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance 21.92 43.97 ACCOUNT: ACCOUNT NO. 26 EMPLOYEES CIT PAYABLE DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT CREDIT 20-- Oct. Nov. 9 23 6 13 16 20 J41 J42 J43 J44 J44 J44 Checkpoints Debit Balance 602.89 615.43 601.12 81.10 1,218.32 543.02 602.89 1,218.32 1,819.44 1,900.54 682.22 1,225.24 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance 1,218.32 1,225.24 ACCOUNT: ACCOUNT NO. 27 GROUP INSURANCE PREMIUMS COLLECTED DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT CREDIT 20-- Oct. Nov. 23 13 20 J42 J44 J44 Checkpoints Debit Balance 181.20 14.40 166.80 181.20 195.60 362.40 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance 181.20 362.40 ACCOUNT: ACCOUNT NO. 28 UNION DUES PAYABLE DATE ITEM POST. REF. Checkpoints Debit Balance BALANCE DEBIT CREDIT DEBIT CREDIT 20-- Oct. Nov. 9 23 6 6 20 J41 J42 J42 J43 J44 16.00 16.00 32.00 16.00 16.00 16.00 32.00 0.00 16.00 32.00 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance 32.00 32.00 ACCOUNT: ACCOUNT NO. 29 SIMPLE CONTRIBUTIONS PAYABLE DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT CREDIT 20-- Nov. 20 J44 Checkpoints Debit Balance 1,650.00 1,650.00 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance 0.00 1,650.00 ACCOUNT: ACCOUNT NO. 51 ADMINISTRATIVE SALARIES DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT 20-- Oct. Nov. 1 Balance 9 23 6 20 a J41 J42 J43 J44 Checkpoints 2,307.69 2,307.69 2,307.69 2,307.69 42,692.27 44,999.96 47,307.65 49,615.34 51,923.03 CREDIT Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Debit Balance 47,307.65 51,923.03 Credit Balance ACCOUNT: ACCOUNT NO. 52 OFFICE SALARIES DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT 20-- Oct. Nov. 1 Balance 9 23 6 13 20 a J41 J42 J43 J44 J44 Checkpoints 4,651.08 4,651.08 4,605.85 2,079.32 3,398.00 28,350.00 33,001.08 37,652.16 42,258.01 44,337.33 47,735.33 CREDIT Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Debit Balance 37,652.16 47,735.33 Credit Balance ACCOUNT: ACCOUNT NO. 53 SALES SALARIES DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT 20-- Oct. Nov. 1 Balance 9 23 6 20 a J41 J42 J43 J44 Checkpoints 3,600.00 3,600.00 3,600.00 3,600.00 28,525.00 32,125.00 35,725.00 39,325.00 42,925.00 CREDIT Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Debit Balance 35,725.00 42,925.00 Credit Balance ACCOUNT: ACCOUNT NO. 54 PLANT WAGES DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT 20-- Oct. Nov. 1 Balance 9 23 6 20 a J41 J42 J43 J44 Checkpoints 4,898.00 5,219.60 4,898.00 4,616.40 42,657.30 47,555.30 52,774.90 57,672.90 62,289.30 CREDIT Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Debit Balance 52,774.90 62,289.30 Credit Balance ACCOUNT: ACCOUNT NO. 56 PAYROLL TAXES DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT 20-- Oct. Nov. 1 Balance 9 23 6 13 20 a J41 J42 J43 J44 J45 Checkpoints 1,381.11 1,386.96 1,343.71 159.07 1,113.15 14,289.12 15,670.23 17,057.19 18,400.90 18,559.97 19,673.12 CREDIT Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Debit Balance 17,057.19 19,673.12 Credit Balance Payday, October 9, 20-Bonno, A. Ferguson, J. Ford, C. Mann, D. O'Neill, J. Russell, V. Ryan, N. Sokowski, T. (Student) Williams, R. No. W/H Allow. NAME Marital Status PAYROLL REGISTER Time Record S M T W T Regular Earnings Rate Per F S S M T W T F S Hrs. Hour For Period Ending October 3, 20-M 4 8 8 8 8 8 M 5 8 8 8 8 8 S 2 8 8 8 8 8 M 4 8 8 8 8 8 M 3 8 8 8 8 8 S 1 8 8 8 8 8 M 4 8 8 8 8 8 M 2 8 8 8 8 8 S 1 8 8 8 8 4 S 0 8 8 D 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 4 8 80 17.60 80 80 80 80 80 80 18.00 80 72 14.00 80 TOTALS Payday, October 23, 20-- For Period Ending October 17, 20-Bonno, A. M 4 8 8 8 8 8 4 Ferguson, J. M 5 8 8 8 8 8 Ford, C. S 2 8 8 8 8 8 Mann, D. M 4 8 8 8 8 8 O'Neill, J. M 3 8 8 8 8 8 Russell, V. S 1 8 8 8 8 8 Ryan, N. M 4 8 8 8 8 8 Sokowski, T. M 2 8 8 8 8 8 (Student) S 1 8 8 8 8 4 Williams, R. S 0 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 4 8 80 17.60 80 80 80 80 80 80 18.00 80 72 14.00 80 TOTALS Payday, November 6, 20-- For Period Ending October 31, 20-Bonno, A. M 4 8 8 8 8 8 Ferguson, J. M 5 8 8 8 8 8 Ford, C. S 2 8 8 8 8 8 Mann, D. M 0 8 8 8 8 8 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 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 4 8 80 17.60 80 80 80 80 78 80 18.00 80 72 14.00 79 TOTALS 6 8 136 Overtime Earnings Rate Per Hrs. Hour Amount Deductions Total Earnings OASDI HI FIT SIT SUTA 1,408.00 2,250.00 1,220.00 1,350.00 2,307.69 1,200.00 1,440.00 2,050.00 1,008.00 1,223.08 1,408.00 2,250.00 1,220.00 1,350.00 2,307.69 1,200.00 1,440.00 2,050.00 1,008.00 1,223.08 87.30 139.50 75.64 83.70 143.08 74.40 89.28 127.10 62.50 75.83 20.42 32.63 17.69 19.58 33.46 17.40 20.88 29.73 14.62 17.73 45.00 135.00 107.00 39.00 191.00 127.00 49.00 175.00 97.00 153.00 43.23 69.08 37.45 41.45 70.85 36.84 44.21 62.94 30.95 37.55 0.99 1.58 0.85 0.95 1.62 0.84 1.01 1.44 0.71 0.86 15,456.77 15,456.77 958.33 224.14 1,118.00 474.55 10.85 1,513.60 2,250.00 1,220.00 1,350.00 2,307.69 1,200.00 1,656.00 2,050.00 1,008.00 1,223.08 93.84 139.50 75.64 83.70 143.08 74.40 102.67 127.10 62.50 75.83 21.95 32.63 17.69 19.58 33.46 17.40 24.01 29.73 14.62 17.73 55.00 135.00 107.00 39.00 191.00 127.00 69.00 175.00 97.00 153.00 46.47 69.08 37.45 41.45 70.85 36.84 50.84 62.94 30.95 37.55 1.06 1.58 0.85 0.95 1.62 0.84 1.16 1.44 0.71 0.86 15,778.37 978.26 228.80 1,148.00 484.42 11.07 1,408.00 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,207.85 1,408.00 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,207.85 87.30 139.50 75.64 83.70 143.08 72.54 89.28 127.10 62.50 74.89 20.42 32.63 17.69 19.58 33.46 16.97 20.88 29.73 14.62 17.51 45.00 135.00 107.00 117.00 191.00 98.00 49.00 249.00 97.00 150.00 43.23 69.08 37.45 41.45 70.85 35.92 44.21 62.94 30.95 37.08 0.99 1.58 0.85 0.95 1.62 0.82 1.01 1.44 0.71 0.85 15,411.54 15,411.54 955.53 223.49 1,238.00 473.16 10.82 2,079.32 2,079.32 128.92 30.15 331.00 63.84 1.46 2,079.32 2,079.32 128.92 30.15 331.00 63.84 1.46 1,408.00 2,250.00 1,220.00 1,350.00 2,307.69 1,200.00 1,440.00 2,050.00 1,008.00 1,223.08 15,456.77 Payday, November 13, 20-- For Period Ending November 14, 20-Williams, R. S 0 6 8 7 7 6 D D 8 TOTALS GLO-BRITE PAINT COMPANY 4 26.40 105.60 8 27.00 216.00 321.60 No. W/H Allow. NAME Marital Status PAYROLL REGISTER Time Record S M T W T Regular Earnings Rate Per F S S M T W T F S Hrs. Hour Payday, November 20, 20-- For Period Ending November 14, 20-Bonno, A. M 4 8 8 8 8 8 Ferguson, J. M 5 8 8 8 8 8 8 Ford, C. S 2 8 8 8 8 8 8 Mann, D. M 0 8 8 8 8 8 8 O'Neill, J. M 3 8 8 8 8 8 8 Russell, V. S 2 6 8 8 8 8 8 Ryan, N. M 4 8 8 8 8 8 8 Sokowski, T. S 2 8 8 8 8 8 8 (Student) S 1 8 8 8 8 4 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 4 64 17.60 80 80 80 80 78 80 18.00 80 72 14.00 TOTALS Payday, December 4, 20-- For Period Ending November 28, 20-Bonno, A. M 8 8 8 8 8 8 Ferguson, J. M Ford, C. S 8 8 8 8 8 Mann, D. M O'Neill, J. M Russell, V. S 8 8 8 8 8 Ryan, N. M 8 8 8 4 8 Sokowski, T. S (Student) S 8 8 8 4 8 Woods, B. S 8 8 8 8 8 8 8 8 80 8 8 8 8 80 8 8 8 8 8 8 8 8 80 76 8 8 8 8 8 8 4 8 72 72 TOTALS GLO-BRITE PAINT COMPANY Amount Overtime Earnings Rate Per Hrs. Hour Amount Deductions Total Earnings OASDI HI FIT SIT SUTA 1,126.40 2,250.00 1,220.00 1,350.00 2,307.69 1,170.00 1,440.00 2,050.00 1,008.00 1,126.40 2,250.00 1,220.00 1,350.00 2,307.69 1,170.00 1,440.00 2,050.00 1,008.00 69.84 139.50 75.64 83.70 143.08 72.54 89.28 127.10 62.50 16.33 32.63 17.69 19.58 33.46 16.97 20.88 29.73 14.62 17.00 64.00 107.00 81.00 86.00 98.00 29.00 249.00 97.00 34.58 69.08 37.45 41.45 70.85 35.92 44.21 62.94 30.95 0.79 1.58 0.85 0.95 1.62 0.82 1.01 1.44 0.71 13,922.09 13,922.09 863.18 201.89 828.00 427.43 9.77 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 4,663.00 1,923.40 20,580.00 6,289.69 43.97 143.54 3 Payday, December 14, 20-- For Period Ending December 12, 20-Russell, V. TOTALS Payday, December 18, 20-- For Period Ending December 12, 20-Bonno, A. Ferguson, J. Ford, C. Mann, D. O'Neill, J. Ryan, N. Sokowski, T. (Student) Woods, B. Young, P. TOTALS Quarter Totals Annual Totals 62,648.09 3,884.22 908.47 204,872.66 12,702.14 2,970.74 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 SIMPLE 0.00 16.00 615.43 181.20 16.00 601.12 0.00 16.00 81.10 14.40 0.00 672 673 674 675 676 677 678 679 680 681 1,148.14 1,784.45 933.79 1,112.66 1,777.67 896.72 1,171.45 1,573.83 762.90 890.40 1,408.00 2,250.00 1,220.00 1,350.00 2,307.69 1,200.00 1,440.00 2,050.00 1,008.00 1,223.08 1,408.00 2,250.00 1,220.00 1,350.00 2,307.69 1,200.00 1,440.00 2,050.00 1,008.00 1,223.08 12,052.01 15,456.77 15,456.77 HI FUTA SUTA Admin. Office Sales Plant 1,408.00 2,250.00 700.00 1,350.00 1,220.00 1,350.00 Total earnings Net paid 15,456.77 12,052.01 1,220.00 1,350.00 2,307.69 760.00 1,200.00 1,200.00 1,440.00 2,050.00 1,008.00 1,008.00 3,818.00 4,778.00 1,008.00 1,223.08 2,307.69 4,651.08 3,600.00 4,898.00 Checkpoints 0.00 1,211.74 1,758.05 919.39 1,096.76 1,750.67 882.62 1,318.93 1,549.83 751.20 876.00 1,513.60 2,250.00 1,220.00 1,350.00 2,307.69 1,200.00 1,656.00 2,050.00 1,008.00 1,223.08 1,513.60 2,250.00 1,220.00 1,350.00 2,307.69 1,200.00 1,656.00 2,050.00 1,008.00 1,223.08 12,115.19 15,778.37 15,778.37 1,513.60 2,250.00 250.00 1,220.00 1,350.00 Total earnings Net paid 15,778.37 12,115.19 1,220.00 1,350.00 2,307.69 1,200.00 1,200.00 1,656.00 2,050.00 442.00 1,008.00 692.00 4,778.00 1,008.00 1,223.08 2,307.69 4,651.08 3,600.00 5,219.60 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.10 14.40 TOTALS OASDI 682 683 684 685 686 687 688 689 690 691 Payday, November 6, 20-- For Period Ending October 31, 20-Bonno, A. 54.92 8.00 Ferguson, J. 87.76 Ford, C. 47.58 Mann, D. 52.66 O'Neill, J. 90.01 Russell, V. 45.63 Ryan, N. 56.17 8.00 Sokowski, T. 79.96 (Student) 39.32 Williams, R. 47.11 TOTALS Amount 0.00 Payday, October 23, 20-- For Period Ending October 17, 20-Bonno, A. 59.04 16.50 8.00 Ferguson, J. 87.76 26.40 Ford, C. 47.58 14.40 Mann, D. 52.66 15.90 O'Neill, J. 90.01 27.00 Russell, V. 46.80 14.10 Ryan, N. 64.59 16.80 8.00 Sokowski, T. 79.96 24.00 (Student) 39.32 11.70 Williams, R. 47.71 14.40 TOTALS Ck. No. Labor Cost Distribution Checkpoints For Period Ending October 3, 20-54.92 8.00 87.76 47.58 52.66 90.01 46.80 56.17 8.00 79.96 39.32 47.71 602.89 Taxable Earnings 0.00 1,148.14 1,784.45 933.79 1,034.66 1,777.67 900.12 1,171.45 1,499.83 762.90 880.41 1,408.00 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,207.85 1,408.00 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,207.85 11,893.42 15,411.54 15,411.54 1,408.00 2,250.00 1,010.00 1,350.00 Total earnings Net paid 15,411.54 11,893.42 1,220.00 1,350.00 2,307.69 1,110.00 1,170.00 1,440.00 2,050.00 1,008.00 0.00 4,478.00 1,008.00 1,207.85 2,307.69 4,605.85 3,600.00 4,898.00 Checkpoints 702 1,428.45 2,079.32 2,079.32 1,428.45 2,079.32 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,428.45 Deductions NAME Net Paid CIT Group Ins. Union Dues SIMPLE October 9, 20, 20--20--For 3, 20-Payday, November ForPeriod PeriodEnding EndingOctober November 14, 20-Bonno, A. 43.93 16.50 8.00 Ferguson, J. 87.76 26.40 500.00 Ford, C. 47.58 14.40 Mann, D. 52.66 15.90 250.00 O'Neill, J. 90.01 27.00 700.00 Russell, V. 45.63 14.10 Ryan, N. 56.17 16.80 8.00 200.00 Sokowski, T. 79.96 24.00 (Student) 39.32 11.70 TOTALS 543.02 166.80 16.00 1,650.00 Taxable Earnings Ck. No. Amount OASDI 703 704 705 706 707 708 709 710 711 919.43 1,329.05 919.39 804.76 1,155.67 886.02 974.65 1,475.83 751.20 1,126.40 2,250.00 1,220.00 1,350.00 2,307.69 1,170.00 1,440.00 2,050.00 1,008.00 1,126.40 2,250.00 1,220.00 1,350.00 2,307.69 1,170.00 1,440.00 2,050.00 1,008.00 9,216.00 13,922.09 13,922.09 HI FUTA Labor Cost Distribution SUTA Admin. Office Sales Plant Checkpoints 1,126.40 2,250.00 1,220.00 300.00 1,350.00 2,307.69 1,170.00 1,440.00 2,050.00 1,008.00 0.00 1,308.00 1,008.00 2,307.69 3,398.00 3,600.00 4,616.40 Checkpoints 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 0.00 0.00 0.00 0.00 Total earnings Net paid 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Checkpoints Payday, December 14, 20-- For Period Ending December 12, 20-Russell, V. TOTALS 0.00 0.00 0.00 0.00 Total earnings Net paid 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Checkpoints 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 Quarter Totals Annual Totals 0.00 0.00 0.00 0.00 2,443.56 362.40 64.00 1,650.00 7,990.89 1,292.80 208.00 1,650.00 Total earnings Net paid Total earnings Net paid 0.00 0.00 0.00 0.00 46,705.07 62,648.09 62,648.09 4,510.00 151,044.86 204,872.66 204,872.66 70,000.00 0.00 15,342.00 97,332.00 0.00 0.00 0.00 0.00 9,230.76 19,385.33 14,400.00 19,632.00 51,923.03 47,735.33 42,925.00 62,289.30 Checkpoints-Annual Total earnings Qtr's taxable OASDI earnings Total earnings for FIT Total earnings for SIT/CIT Total earnings for FUTA 13,922.09 9,216.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 NAME - LAST FIRST BONNO Anthony $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $55,000 --$.30/M 20___ PAYDAY HRS. RATE YEAR-TO-DATE 1 10/9 2 10/23 3 11/6 4 11/20 5 12/4 6 12/18 $8 each pay REGULAR EARNINGS 80 80 80 64 17.60 17.60 17.60 17.60 AMOUNT OVERTIME EARNINGS HRS. RATE 10,293.40 1,408.00 1,408.00 1,408.00 1,126.40 4 26.40 OVERTIME RATE CUMULATIVE EARNINGS AMOUNT 1,028.60 0.00 105.60 0.00 0.00 0.00 0.00 11,322.00 12,730.00 14,243.60 15,651.60 16,778.00 MIDDLE Victor 17.60 26.40 W/H MARITAL ALLOW. STATUS 4 M DEDUCTIONS FICA OASDI 701.96 87.30 93.84 87.30 69.84 HI 164.17 20.42 21.95 20.42 16.33 FIT SIT 810.00 45.00 55.00 45.00 17.00 347.59 43.23 46.47 43.23 34.58 NET PAID SUTA CIT 7.93 0.99 1.06 0.99 0.79 SIMPLE 441.60 54.92 59.04 54.92 43.93 OTHER CK. DEDUCTIONS NO. 216.80 8.00 24.50 8.00 24.50 AMOUNT 8,631.95 1,148.14 1,211.74 1,148.14 919.43 672 682 692 703 QTR. TOT. YR. TOT. Checkpoint Checkpoint DEPARTMENT OCCUPATION WORKS IN (STATE) Sales Sales Manager PA SEX M F x S.S. ACCOUNT NO. 000-00-8645 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE NAME - LAST FIRST FERGUSON $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $88,000 -- $.30/M 20___ REGULAR EARNINGS OVERTIME RATE OVERTIME EARNINGS PAYDAY EARNINGS HRS. YEAR-TO-DATE 1 10/9 2 10/23 3 11/6 4 11/20 5 12/4 6 12/18 CUMULATIVE 80 80 80 80 RATE AMOUNT HRS. RATE 23,125.00 2,250.00 2,250.00 2,250.00 2,250.00 23,125.00 25,375.00 27,625.00 29,875.00 32,125.00 James 58,500 /yr. 1,125.00 28.13 MARITAL ALLOW. STATUS 5 M NET PAID 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 135.00 135.00 135.00 64.00 SIT SUTA 709.94 69.08 69.08 69.08 69.08 QTR. TOT. YR. TOT. Checkpoint Claude W/H DEDUCTIONS OASDI AMOUNT MIDDLE Checkpoint 16.19 1.58 1.58 1.58 1.58 CIT 901.97 87.76 87.76 87.76 87.76 SIMPLE CK. DEDUCTIONS NO. AMOUNT 132.30 26.40 500.00 26.40 673 683 693 704 17,304.54 1,784.45 1,758.05 1,784.45 1,329.05 OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE M F Office Executive Secretary x PA 000-00-4567 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE FORD $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $50,000--$.30/M 20___ OVERTIME RATE REGULAR EARNINGS OVERTIME EARNINGS PAYDAY EARNINGS HRS. RATE AMOUNT 10/9 2 10/23 3 11/6 4 11/20 5 12/4 6 12/18 HRS. RATE 80 80 80 80 6,300.00 7,520.00 8,740.00 9,960.00 11,180.00 Louise W/H MARITAL ALLOW. STATUS 2 S DEDUCTIONS NET PAID FICA OASDI AMOUNT 6,300.00 1,220.00 1,220.00 1,220.00 1,220.00 YEAR-TO-DATE 1 CUMULATIVE Catherine 2,733.33 /mo. 640.00 16.00 24.00 390.60 75.64 75.64 75.64 75.64 OTHER HI FIT SIT 91.35 17.69 17.69 17.69 17.69 639.00 107.00 107.00 107.00 107.00 193.41 37.45 37.45 37.45 37.45 SUTA 4.41 0.85 0.85 0.85 0.85 CIT SIMPLE 245.73 47.58 47.58 47.58 47.58 CK. DEDUCTIONS NO. AMOUNT 37.80 4,697.70 933.79 919.39 933.79 919.39 674 684 694 705 14.40 14.40 QTR. TOT. YR. TOT. Checkpoint Checkpoint OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE M F Sales Sales Representative x PA 000-00-9352 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE MANN $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $53,000 -- $.30/M 20___ OVERTIME RATE REGULAR EARNINGS OVERTIME EARNINGS PAYDAY EARNINGS HRS. YEAR-TO-DATE 1 10/9 2 10/23 3 11/6 4 11/20 5 12/4 6 12/18 CUMULATIVE 80 80 80 80 80 RATE AMOUNT HRS. RATE 5,400.00 1,350.00 1,350.00 1,350.00 1,350.00 1,350.00 5,400.00 6,750.00 8,100.00 9,450.00 10,800.00 12,150.00 Wilson MARITAL ALLOW. STATUS 0 M NET PAID FICA 334.80 83.70 83.70 83.70 83.70 83.70 OTHER HI FIT SIT 78.30 19.58 19.58 19.58 19.58 19.58 332.00 39.00 39.00 117.00 81.00 81.00 165.78 41.45 41.45 41.45 41.45 41.45 SUTA 3.78 0.95 0.95 0.95 0.95 0.95 CIT 210.62 52.66 52.66 52.66 52.66 52.66 SIMPLE CK. DEDUCTIONS NO. AMOUNT 31.50 15.90 250.00 250.00 TR. TOT. YR. TOT. Checkpoint W/H DEDUCTIONS OASDI AMOUNT Dewey 2,925 /mo. 675.00 16.88 Checkpoint 15.90 675 685 695 706 4,243.22 1,112.66 1,096.76 1,034.66 804.76 820.66 OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST President x PA 000-00-1534 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE O'NEILL $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $90,000 -- $.30/M 20___ OVERTIME RATE REGULAR EARNINGS OVERTIME EARNINGS PAYDAY RATE 2 10/23 3 11/6 4 11/20 5 12/4 6 12/18 AMOUNT HRS. RATE 80 80 80 80 80 42,692.27 44,999.96 47,307.65 49,615.34 51,923.03 54,230.72 Joseph 60,000 /yr. 1,153.85 28.85 Tyler W/H MARITAL ALLOW. STATUS 3 M DEDUCTIONS NET PAID FICA OASDI AMOUNT 42,692.27 2,307.69 2,307.69 2,307.69 2,307.69 2,307.69 YEAR-TO-DATE 10/9 CUMULATIVE EARNINGS HRS. 1 MIDDLE M F Administrative 2,646.92 143.08 143.08 143.08 143.08 143.08 OTHER HI 619.04 33.46 33.46 33.46 33.46 33.46 FIT 6,116.00 191.00 191.00 191.00 86.00 86.00 SIT SUTA 1,310.65 70.85 70.85 70.85 70.85 70.85 29.88 1.62 1.62 1.62 1.62 1.62 CIT 1,665.17 90.01 90.01 90.01 90.01 90.01 SIMPLE CK. DEDUCTIONS NO. AMOUNT 202.50 676 686 696 707 27.00 700.00 700.00 27.00 30,102.11 1,777.67 1,750.67 1,777.67 1,155.67 1,182.67 TR. TOT. YR. TOT. Checkpoint Checkpoint OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE M F Office Time Clerk x PA 000-00-6337 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE RUSSELL $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $49,000 -- $.30/M 20___ OVERTIME RATE REGULAR EARNINGS OVERTIME EARNINGS PAYDAY EARNINGS HRS. YEAR-TO-DATE 1 10/9 2 10/23 3 11/6 4 11/20 5 12/4 6 12/14 CUMULATIVE 80 80 78 78 80 RATE AMOUNT HRS. RATE 6,240.00 1,200.00 1,200.00 1,170.00 1,170.00 1,260.00 6,240.00 7,440.00 8,640.00 9,810.00 10,980.00 12,240.00 Aloise MARITAL ALLOW. STATUS 2 S NET PAID FICA 386.88 74.40 74.40 72.54 72.54 78.12 OTHER HI FIT SIT 90.48 17.40 17.40 16.97 16.97 18.27 642.00 127.00 127.00 98.00 98.00 113.00 191.56 36.84 36.84 35.92 35.92 38.68 SUTA 4.37 0.84 0.84 0.82 0.82 0.88 CIT SIMPLE 243.38 46.80 46.80 45.63 45.63 49.15 TR. TOT. YR. TOT. Checkpoint W/H DEDUCTIONS OASDI AMOUNT Virginia 2,730 /mo. 630.00 15.75 23.63 Checkpoint CK. DEDUCTIONS NO. AMOUNT 31.50 14.10 14.10 677 687 697 708 4,649.83 896.72 882.62 900.12 886.02 961.90 OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE M F Plant Electrician x PA 000-00-1223 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE RYAN Norman $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $56,000 -- $.30/M 20___ $8 each pay REGULAR EARNINGS OVERTIME EARNINGS PAYDAY EARNINGS HRS. RATE YEAR-TO-DATE 1 10/9 2 10/23 3 11/6 4 11/20 5 12/4 6 12/18 OVERTIME RATE CUMULATIVE 80 80 80 80 76 18.00 18.00 18.00 18.00 18.00 AMOUNT 13,287.50 1,440.00 1,440.00 1,440.00 1,440.00 1,368.00 HRS. RATE 8 27.00 3 27.00 1,397.80 0.00 216.00 0.00 0.00 81.00 0.00 14,685.30 16,125.30 17,781.30 19,221.30 20,661.30 22,110.30 18.00 27.00 MARITAL ALLOW. STATUS 4 M DEDUCTIONS NET PAID FICA OASDI AMOUNT Allen W/H 910.49 89.28 102.67 89.28 89.28 89.84 OTHER HI 212.94 20.88 24.01 20.88 20.88 21.01 FIT 1,070.00 49.00 69.00 49.00 29.00 SIT SUTA 450.84 44.21 50.84 44.21 44.21 44.48 10.28 1.01 1.16 1.01 1.01 1.01 CIT 572.79 56.17 64.59 56.17 56.17 56.52 SIMPLE 200.00 CK. DEDUCTIONS NO. 235.70 8.00 24.80 8.00 24.80 AMOUNT 678 688 698 709 11,222.26 1,171.45 1,318.93 1,171.45 974.65 1,236.14 QTR. TOT. YR. TOT. Checkpoint Checkpoint OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE M F Plant Supervisor x PA 000-00-8832 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE SOKOWSKI Thomas $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $80,000 -- $.30/M 20___ REGULAR EARNINGS OVERTIME RATE OVERTIME EARNINGS PAYDAY EARNINGS HRS. YEAR-TO-DATE 1 10/9 2 10/23 3 11/6 4 11/20 5 12/4 6 12/18 CUMULATIVE 80 80 80 80 RATE AMOUNT HRS. RATE 16,650.00 2,050.00 2,050.00 2,050.00 2,050.00 16,650.00 18,700.00 20,750.00 22,800.00 24,850.00 1,025.00 25.63 STATUS 2 S NET PAID FICA 1,032.30 127.10 127.10 127.10 127.10 OTHER HI 241.43 29.73 29.73 29.73 29.73 FIT 2,002.00 175.00 175.00 249.00 249.00 SIT 511.16 62.94 62.94 62.94 62.94 SUTA 11.66 1.44 1.44 1.44 1.44 CIT SIMPLE 649.42 79.96 79.96 79.96 79.96 QTR. TOT. YR. TOT. Checkpoint MARITAL ALLOW. DEDUCTIONS OASDI AMOUNT James W/H Checkpoint CK. DEDUCTIONS NO. AMOUNT 94.50 24.00 24.00 679 689 699 710 12,107.53 1,573.83 1,549.83 1,499.83 1,475.83 OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE M F Office Accounting Trainee PA Student OTHER DEDUCTIONS INFORMATION GROUP INSURANCE $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $39,000 -- $.30/M 20___ OVERTIME RATE REGULAR EARNINGS OVERTIME EARNINGS PAYDAY EARNINGS HRS. RATE AMOUNT 10/9 2 10/23 3 11/6 4 11/20 5 12/4 6 12/18 72 72 72 72 HRS. RATE 14.00 14.00 14.00 14.00 5,550.00 6,558.00 7,566.00 8,574.00 9,582.00 MARITAL STATUS 1 S DEDUCTIONS NET PAID FICA OASDI AMOUNT 5,550.00 1,008.00 1,008.00 1,008.00 1,008.00 YEAR-TO-DATE 1 CUMULATIVE 14.00 21.00 W/H ALLOW. 344.10 62.50 62.50 62.50 62.50 OTHER HI FIT SIT 80.48 14.62 14.62 14.62 14.62 409.00 97.00 97.00 97.00 97.00 170.38 30.95 30.95 30.95 30.95 SUTA 3.89 0.71 0.71 0.71 0.71 CIT SIMPLE 216.47 39.32 39.32 39.32 39.32 CK. DEDUCTIONS NO. AMOUNT 32.40 4,293.28 762.90 751.20 762.90 751.20 680 690 700 711 11.70 11.70 QTR. TOT. YR. TOT. Checkpoint Checkpoint OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE M F Office Programmer x PA 000-00-6741 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE WILLIAMS $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $48,000 -- $.30/M 20___ REGULAR EARNINGS OVERTIME RATE OVERTIME EARNINGS PAYDAY EARNINGS HRS. YEAR-TO-DATE 1 10/9 2 10/23 3 11/6 4 11/13 CUMULATIVE 80 80 79 136 RATE AMOUNT HRS. RATE Virginia W/H MARITAL ALLOW. STATUS 0 S DEDUCTIONS NET PAID FICA OASDI AMOUNT Ruth 2,650 /mo. 611.54 15.29 22.94 OTHER HI FIT SIT SUTA CIT SIMPLE CK. DEDUCTIONS NO. AMOUNT 10,260.00 1,223.08 1,223.08 1,207.85 2,079.32 10,260.00 11,483.08 12,706.16 13,914.01 15,993.33 636.12 75.83 75.83 74.89 128.92 148.77 17.73 17.73 17.51 30.15 1,606.00 153.00 153.00 150.00 331.00 314.98 37.55 37.55 37.08 63.84 7.18 0.86 0.86 0.85 1.46 400.18 47.71 47.71 47.11 81.10 59.40 5,733.33 15,993.33 5,733.33 15,993.33 355.47 991.59 83.12 231.89 787.00 2,393.00 176.02 491.00 4.03 11.21 223.63 623.81 28.80 88.20 4,075.26 11,162.63 4,075.26 11,162.63 14.40 14.40 681 691 701 702 7,087.37 890.40 876.00 880.41 1,428.45 5 6 QTR. TOT. YR. TOT. 375 Checkpoint 5,733.33 15,993.33 Checkpoint 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 $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $47,000 -- $.30/M 20___ OVERTIME RATE REGULAR EARNINGS OVERTIME EARNINGS PAYDAY CUMULATIVE EARNINGS HRS. RATE AMOUNT HRS. RATE Anne W/H MARITAL ALLOW. STATUS 1 S DEDUCTIONS NET PAID FICA OASDI AMOUNT Beth 2,600 /mo. 600.00 15.00 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. YR. TOT. Checkpoint Checkpoint OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE M F Sales Field Sales Representative x PA 000-00-6057 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE UNION DUES Young Paul $ $ $ $ SALARY OTHER WEEKLY RATE HOURLY RATE $49,000 -- $.30/M 20___ REGULAR EARNINGS OVERTIME RATE OVERTIME EARNINGS PAYDAY CUMULATIVE EARNINGS HRS. RATE AMOUNT HRS. RATE AMOUNT Winston 2,730 /mo. 630.00 15.75 STATUS 1 S NET PAID FICA OASDI OTHER HI FIT SIT SUTA CIT SIMPLE 1 2 3 4 5 12/18 QTR. TOT. YR. TOT. Checkpoint MARITAL ALLOW. DEDUCTIONS YEAR-TO-DATE 6 W/H Checkpoint CK. DEDUCTIONS NO. AMOUNT OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE M F OTHER DEDUCTIONS INFORMATION GROUP INSURANCE $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE OVERTIME RATE 20___ REGULAR EARNINGS OVERTIME EARNINGS PAYDAY CUMULATIVE EARNINGS HRS. RATE AMOUNT HRS. RATE MARITAL STATUS DEDUCTIONS NET PAID FICA OASDI AMOUNT W/H ALLOW. 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 RATE HOURLY RATE OVERTIME RATE 20___ REGULAR EARNINGS OVERTIME EARNINGS PAYDAY EARNINGS HRS. YEAR-TO-DATE 1 2 3 4 5 6 QTR. TOT. YR. TOT. CUMULATIVE RATE AMOUNT HRS. RATE AMOUNT W/H MARITAL ALLOW. STATUS DEDUCTIONS NET PAID FICA OASDI OTHER HI FIT SIT SUTA CIT SIMPLE CK. DEDUCTIONS NO. AMOUNT

Tutor Answer

Missmourine
School: Duke University

Attached.

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 answe
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. Fo
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
You can save the file to the current name, or you may want to keep multiple versions of your work by saving each successive versio
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_Nam
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.

opy of your file. You can save your work at any time.
ork by saving each successive version under a different name.

Page 41

JOURNAL
DATE

DESCRIPTION

POST.
REF.

DEBIT

CREDIT

20/10/2018

9 Payroll Cash
Cash

12
11

12,044.51

9 Administrative Salaries
Office Salaries
Sales Salaries
Plant Wages
FICA Taxes Payable - OASDI
FICA Taxes Payable - HI
Employees FIT Payable
Employees SIT Payable
Employees SUTA Payable
Employees CIT Payable
Union Dues Payable
Payroll Cash

51
52
53
54
20.1
20.2
24
25
25.1
26
28
12

2,307.69
4,651.08
3,600.00
4,898.00

9 Payroll Taxes
FICA Taxes Payable - OASDI
FICA Taxes Payable - HI
FUTA Taxes Payable
SUTA Taxes Payable - Employer

56
20.1
20.2
21
22

1,381.11

12,044.51

594.83
224.14
1.124.14
474.55
10.85
604.39
16.00
12,044.51

958.32
224.32
22.91
175.76

Page 42

JOURNAL
DATE

DESCRIPTION

POST.
REF.

DEBIT

20/10/2018

23 Payroll Cash

12

12,o44.51

CREDIT

Cash

11

12,044.51

23 Adminstrative Salaries
Office Salaries
Sales Salaries
Plant Wages
FICA Taxes Payable - OASDI
FICA Taxes Payable - HI
Employees FIT Payable
Employees SIT Payable
Employees SUTA Payable
Employees CIT Payable
Group Insurance Premiums Collected
Union Dues Payable
Payroll Cash

51
52
53
54
20.1
20.2
24
25
25.1
26
27
28

2,307.69
4,651.08
3,600.00
4,898.00

23 Payroll Taxes
FICA Taxes Payable - OASDI
FUTA Taxes Payable -HI
FUTA Taxes Payable
SUTA Taxes Payable - Employer

56
20.1
20.2
21
22

1,281.14

608.35
210.03
1,021.00
444.68
11.59
568.96
165.90
16.00
12,044.00

898.05
210.03
51.60
121.46

Page 43

JOURNAL
DATE
20/11/2018

DESCRIPTION

Payroll Cash
6 Cash
Adminstrative 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

POST.
REF.

12
11
51
52
53
54
20.1
20.2
24
25
25.1
26
28
12

DEBIT

CREDIT

12,044.51
12,044.51
2,307.69

3,320.79
3,600.00
4,898.00
593.48
204.89
1,146.00
433.81
11.30
555.05
16.00
12.044.51

may

6 Payroll Taxes
FICA Taxes Payable - OASDI
FICA Taxes Payable - HI
FUTA Taxes Payable
SUTA Taxes Payable - Employer

56
20.1
20.2
21
22

2,281.14
876.09
204.89
22.20
34.07

Page 44

JOURNAL
DATE

DESCRIPTION

POST.
REF.

DEBIT

CREDIT

20/11/2018

13 Payroll Cash
Cash
Office Salaries
FICA Taxes Payable - OASDI
FICA Taxes Payable - HI
Employees FIT Payable
Employees SIT Payable

12
11

2,079.32

52
20.1
20.2
24
25

2,079.32

2,079.32

87.33
30.15
308.00
63.84

Employees SUTA Payable
Employees CIT Payable
Group Insurance Premiums Collected
Payroll Cash
13 Payroll Taxes
FICA Taxes Payable - OASDI
FUTA Taxes Payable -HI

25.1
26
27
12
56
20.1
20.2

1.66
81.68
14.40
2,079.32
159.07
128.92
30.15

Page 45

JOURNAL
DATE

DESCRIPTION

POST.
REF.

DEBIT

CREDIT

20/12/2018

20 Payroll Cash
Cash
Adminstrative Salaries

12
11

8,265.88

51

2,307.69

8,265.88

Office Salaries
Sales Salaries
Plant Wages
FICA Taxes Payable - OASDI
FICA Taxes Payable - HI
Employees FIT Payable
Employees SIT Payable
Employees SUTA Payable
Employees CIT Payable
Group Insurance Premiums Collected
Union Dues Payable
SIMPLE Contributions Payable
Payroll Cash
20 Payroll Taxes
FICA Taxes Payable - OASDI
FUTA Taxes Payable -HI
FUTA Taxes Payable
SUTA Taxes Payable - Employer

52
53
54
20.1
20.2
24
25
25.1
26
27
28
29
12

2,112.94
3,600.00
4,619.60

56
20.1
20.2
21
22

986.97

530.89
183.28
9.48
388.06
10.11
496.51
15.50
16.00
1,650.00
8,265.88

783.69
183.28
0.00
20.00

Page 46

JOURNAL

DATE

DESCRIPTION

POST.
REF.

DEBIT

CREDIT

20/6/2018

4 Payroll Cash
Cash
4 Adminstrative 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
SIMPLE Contributions Payable
Payroll Cash
Payroll Taxes

12
11

9,737.33

51
52
53
54
20.1
20.2
24
25
25.1
26
28
29
12

2,307.69
3,330.00
3,600.00
5,193.40

56

9,737.33

606.11
209.25
1,200.00
443.03
11.54
557.83
16.00
1,650.00
9,737.33
928.49

FICA Taxes Payable - OASDI
FUTA Taxes Payable -HI
FUTA Taxes Payable
SUTA Taxes Payable - Employer

20.1
20.2
21
22

603.71
209.25
64.80
50.73

Page 47

JOURNAL
DATE

DESCRIPTION

POST.
REF.

DEBIT

CREDIT

20/12/2018

14 Payroll Cash
Cash
14 Office Salaries
FICA Taxes Payable - OASDI
FICA Taxes Payable - HI
Employees SUTA Payable
Group Insurance Premiums Collected

12
11

1,425.16

52
20.1
20.2
25.1
27

1,425.16

1,425.16

59.86
20.66
1.14
8.70

Page 48

JOURNAL
DATE

DESCRIPTION

POST.
REF.

DEBIT

CREDIT

20/01/2018

18 Payroll Cash
Cash

12
11

48,169.93

Adminstrative Salaries
Office Salaries
Sales Salaries
Plant Wages
FICA Taxes Payable - OASDI
FICA Taxes Payable - HI
Employees FIT Payable
Employees SIT Payable
Employees SUTA Payable
Employees CIT Payable
Group Insurance Premiums Collected
Union Dues Payable
SIMPLE Contributions Payable
Payroll Cash

51
52
53
54
20.1
20.2
24
25
25.1
26
27
28
29
12

62,307.69
2,692.50
4,407.70
5,514.60

Payroll Taxes
FICA Taxes Payable - OASDI
FUTA Taxes Payable -HI

56
20.1
20.2

4,208.79

48,169.93

2,876.33
1,086.38
6,372.99
2,102.46
59.94
2,690.05
167.70
18.00
4,950.00
48,169.93

3,341.02
781.37

FUTA Taxes Payable
SUTA Taxes Payable - Employer

21
22

12.05
74.35

Page 49

JOURNAL
DATE
5/6/2018

DESCRIPTION

POST.
REF.

DEBIT

CREDIT

Page 50

JOURNAL
DATE
20--

DESCRIPTION

POST.
REF.

DEBIT

CREDIT

Total debits and credits (calculated automatically):

26,752.88

Your debits and credits should be equal after each journal entry is complete

Cumulative Journal Checkpoint Through Month Ending
April 31, 20-May 30, 20--

June 31, 20-July 31, 20--

26,752.88

m

GENERAL LEDGER
ACCOUNT:

ACCOUNT NO. 11

CASH

DATE

ITEM

POST.
REF.

BALANCE

DEBIT

CREDIT

DEBIT

CREDIT

Nov. 30, 20--

20--

Oct.

Nov

Dec

a

1 Balance
9
9
23
23
6
6
13
16
16
18
20
3
4
9
15
15
15
15
18

ACCOUNT:

J41
J41
J41
J42
J42
J43
J43
J44
J44
J44
J44
J45
J45
J46
J46
J46
J46
J46
J46

12,044.51
434.82
11,438.16
444.60
32.00
11,169.15
1,492.26
5,817.11
1,126.26
497.67
8,265.88
388.08
9,737.33
32.00
6,239.04
1,132.24
443.03
8.70
48,169.93

ACCOUNT NO. 12

PAYROLL CASH

DATE

ITEM

199,846.33
187,801.82
187,367.00
175,928.84
175,484.24
175,452.24
164,283.09
162,790.83
156,973.72
155,847.46
155,349.79
147,083.91
146,695.83
136,958.50
136,926.50
130,687.46
129,555.22
129,112.19
129,103.49
80,933.56

POST.
REF.

BALANCE

DEBIT

CREDIT

DEBIT

Oct.

Nov

CREDIT

Nov. 30, 20--

20--

9
9
23
23
6
6
13
13

J41
J41
J42
J42
J43
J43
J44
J44

12,044.51
12,044.51
11,348.16
11,348.16
11,169.15
11,169.15
2,079.32
2,079.32

12,044.51
0.00
11,348.16
0.00
11,169.15
0.00
2,079.32
0.00

Dec

20
20
4
4
14
14
18
18

ACCOUNT:

J45
J45
J46
J46
J47
J47
J48
J48

8,265.88
8,265.88
9,737.33
9,737.33
1,425.16
1,425.16
48,169.93
48,169.93

ACCOUNT NO. 20.1

FICA TAXES PAYABLE - OASDI

DATE

ITEM

8,265.88
0.00
9,737.33
0.00
1,425.16
0.00
48,169.93
0.00

POST.
REF.

BALANCE

DEBIT

CREDIT

DEBIT

CREDIT

Nov. 30, 20--

20--

Oct.

Nov

Dec

9
9
23
23
6
6
13
13
20
20
4
4
14
18
18

J41
J41
J42
J42
J43
J43
J44
J44
J45
J45
J46
J46
J47
J48
J48

594.83
878.09
608.35
898.05
593.48
876.09
87.33
128.92
530.89
783.69
606.11
603.71
59.86
2,876.33
3,341.02

...

flag Report DMCA
Review

Anonymous
Wow this is really good.... didn't expect it. Sweet!!!!

Similar Questions
Hot Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors