Need help on whole Excel Project

profileCookie21
Yup.xlsx
Home>Business & Finance homework help>Accounting homework help>Need help on whole Excel Project

Excel Instructions

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 not 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 26.48 but hold 26.475. If you want to use 26.48 you will need to use Excel's rounding function.
In order to tell Excel to round to the nearest whole penny you must enter the formula as: =round(17.65*1.5,2). This tells Excel to multiply 17.65 x 1.5,
then round to 2 decimals. Excel will now display and hold the amount as 26.48.
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.

Journal

JOURNAL Page 41
DATE DESCRIPTION POST. REF. DEBIT CREDIT
20--
Oct. 9 Payroll Cash 12 12,508.59
Cash 11 12,508.59
9 Administrative Salaries 51 2,307.69
Office Salaries 52 4,723.08
Sales Salaries 53 3,600.00
Plant Wages 54 4,898.00
FICA Taxes Payable - OASDI 20.1 962.79
FICA Taxes Payable - HI 20.2 225.18
Employees FIT Payable 24 740.00
Employees SIT Payable 25 476.76
Employees SUTA Payable 25.1 10.90
Employees CIT Payable 26 588.55
Union Dues Payable 28 16.00
Payroll Cash 12 12,508.59
9 Payroll Taxes 56 1,396.66
FICA Taxes Payable - OASDI 20.1 962.78
FICA Taxes Payable - HI 20.2 225.17
FUTA Taxes Payable 21 23.34
SUTA Taxes Payable - Employer 22 185.37
20 Employees SIT Payable 25 476.76
Cash 11 476.76
23 Payroll Cash 12 12,571.22
Cash 11 12,571.22
JOURNAL Page 42
DATE DESCRIPTION POST. REF. DEBIT CREDIT
20--
Oct. 23 Administrative Salaries 51 2,307.69
Office Salaries 52 4,723.08
Sales Salaries 53 3,600.00
Plant Wages 54 5,219.60
FICA Taxes Payable - OASDI 20.1 982.72
FICA Taxes Payable - HI 20.2 229.84
Employees FIT Payable 24 770.00
Employees SIT Payable 25 486.63
Employees SUTA Payable 25.1 11.12
Employees CIT Payable 26 600.74
Group Insurance Premiums Collected 27 182.10
Union Dues Payable 28 16.00
Payroll Cash 12 12,571.22
23 Payroll Taxes 56 1,401.64
FICA Taxes Payable - OASDI 20.1 982.72
FICA Taxes Payable - HI 20.2 229.83
FUTA Taxes Payable 21 3.72
SUTA Taxes Payable - Employer 22 185.37
Nov. 4 Employees SIT Payable 25 486.63
Cash 11 486.63
6 Union Dues Payable 28 32.00
Cash 11 32.00
JOURNAL Page 43
DATE DESCRIPTION POST. REF. DEBIT CREDIT
20--
Nov. 6 Payroll Cash 12 12,403.94
Cash 11 12,403.94
6 Administrative Salaries 51 2,307.69
Office Salaries 52 4,677.85
Sales Salaries 53 3,600.00
Plant Wages 54 4,898.00
FICA Taxes Payable - OASDI 20.1 959.99
FICA Taxes Payable - HI 20.2 224.53
Employees FIT Payable 24 806.00
Employees SIT Payable 25 475.37
Employees SUTA Payable 25.1 10.87
Employees CIT Payable 26 586.84
Union Dues Payable 28 16.00
Payroll Cash 12 12,403.94
6 Payroll Taxes 56 1,368.71
FICA Taxes Payable - OASDI 20.1 959.98
FICA Taxes Payable - HI 20.2 224.51
SUTA Taxes Payable - Employer 22 184.22
13 Payroll Cash 12 1,585.74
Cash 11 1,585.74
JOURNAL Page 44
DATE DESCRIPTION POST. REF. DEBIT CREDIT
20--
Nov. 13 Office Salaries 52 2,079.32
FICA Taxes Payable - OASDI 20.1 128.92
FICA Taxes Payable - HI 20.2 30.15
Employees FIT Payable 24 176.00
Employees SIT Payable 25 63.84
Employees SUTA Payable 25.1 1.46
Employees CIT Payable 26 78.81
Group Insurance Premiums Collected 27 14.40
Payroll Cash 12 1,585.74
13 Payroll Taxes 56 159.07
FICA Taxes Payable - OASDI 20.1 128.92
FICA Taxes Payable - HI 20.2 30.15
16 FICA Taxes Payabe-OASDI 20.1 3,891.01
FICA Taxes Payable-HI 20.2 910.02
Employee FIT Payable 24 1,510.00
Cash 11 6,311.03
16 Employee CIT Payable 26 1,189.29
Cash 11 1,189.29
18 Employees SIT Payable 25 539.21
Cash 11 539.21
20 Payroll Cash 12 9,593.97
Cash 11 9,593.97
20 Administrative Salaries 51 2,307.69
Office Salaries 52 3,470.00
Sales Salaries 53 3,600.00
Plant Wages 54 4,616.40
FICA Taxes Payable - OASDI 20.1 867.64
FICA Taxes Payable - HI 20.2 202.93
Employees FIT Payable 24 526.00
Employees SIT Payable 25 429.64
Employees SUTA Payable 25.1 9.82
Employees CIT Payable 26 530.39
Group Insurance Premiums Collected 27 167.70
Union Dues Payable 28 16.00
SIMPLE Contributions Payable 29 1,650.00
Payroll Cash 12 9,593.97
JOURNAL Page 45
DATE DESCRIPTION POST. REF. DEBIT CREDIT
20--
Nov. 20 Payroll Taxes 56 1,141.63
FICA Taxes Payable - OASDI 20.1 0.00 867.63
FICA Taxes Payable - HI 20.2 0.00 202.91
SUTA Taxes Payable - Employer 22 0.00 71.09
JOURNAL Page 46
DATE DESCRIPTION POST. REF. DEBIT CREDIT
20--
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
JOURNAL Page 47
DATE DESCRIPTION POST. REF. DEBIT CREDIT
20--
31-Jan 31-Dec 30-Nov 31-Oct
151,990.26 151,990.26 151,990.26 151,990.26
0.00 0.00 0.00 66,368.17
151,990.26 151,990.26 151,990.26 85,622.09
JOURNAL Page 48
DATE DESCRIPTION POST. REF. DEBIT CREDIT
20--
JOURNAL Page 49
DATE DESCRIPTION POST. REF. DEBIT CREDIT
20--
Dec. 31 administrative salaries expense 2,307.69
Office Salaries Expense 3,470.00
sales salaries expense 3,800.00
Plant Wages Expense 4,616.40
Cost of Goods sold 60,000.00
31 Rent Expense 12,000.00
Utilities Expense 3,500.00
Depreciation Expense 8,000.00
Supplies Expense 2,408.09
Marketing Expense 6,000.00
Insurance Expense 5,000.00
Repairs & Maintenance Expense 3,000.00
Interest Expense 2,000.00
Miscellaneous Expense 10,000.00
51,908.09
31 FICA Taxes Payable – OASDI 867.64
FICA Taxes Payable – HI 202.93
Employees FIT Payable 526.00
Employees SIT Payable 539.21
Employees SUTA Payable 25.00
Employees CIT Payable 1,189.29
Payroll Cash (net pay) 9,593.97
12,944.04
JOURNAL Page 50
DATE DESCRIPTION POST. REF. DEBIT CREDIT
20--
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Total debits and credits (calculated automatically): 126,102.18 151,990.26
Your debits and credits should be equal after each journal entry is complete
Cumulative Journal Checkpoint Through Month Ending
59,734.01 October 31, 20-- December 31, 20--
126,102.18 November 30, 20-- January 31, 20--

General Ledger

GENERAL LEDGER
Checkpoints
ACCOUNT: CASH ACCOUNT NO. 11 Debit Credit
Balance Balance
POST. BALANCE Oct. 31, 20-- 174,289.76
DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Nov. 30, 20-- 142,147.95
20-- Dec. 31, 20--
Oct. 1 Balance a 199,846.33
9 J41 12,508.59 187,337.74
20 J41 476.76 186,860.98
23 J41 12,571.22 174,289.76
Nov. 4 J42 486.63 173,803.13
6 J42 32.00 173,771.13
6 J43 12,403.94 161,367.19
13 J43 1,585.74 159,781.45
16 J44 6,311.03 153,470.42
16 J44 1,189.29 152,281.13
16 J44 539.21 151,741.92
20 J44 9,593.97 142,147.95
ACCOUNT: PAYROLL CASH ACCOUNT NO. 12 Checkpoints
Debit Credit
POST. BALANCE Balance Balance
DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20-- 0.00
20-- Nov. 30, 20-- 0.00
Oct. 9 J41 12,508.59 12,508.59 Dec. 31, 20-- 0.00
9 J41 12,508.59 0.00
23 J41 12,571.22 12,571.22
23 J42 12,571.22 0.00
Nov. 6 J43 12,403.94 12,403.94
6 J43 12,403.94 -0.00
13 J43 1,585.74 1,585.74
13 J44 1,585.74 -0.00
20 J44 9,593.97 9,593.97
20 J44 9,593.97 -0.00
ACCOUNT: FICA TAXES PAYABLE - OASDI ACCOUNT NO. 20.1 Checkpoints
Debit Credit
POST. BALANCE Balance Balance
DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20-- 0.00 3,891.01
20-- Nov. 30, 20-- 0.00 3,913.08
Oct. 9 J41 962.79 962.79 Dec. 31, 20-- 0.00
9 J41 962.78 1,925.57
23 J42 982.72 2,908.29
23 J42 982.72 3,891.01
Nov. 6 J43 959.99 4,851.00
6 J43 959.98 5,810.98
13 J44 128.92 5,939.90
13 J44 128.92 6,068.82
16 J44 3,891.01 2,177.81
20 J44 867.64 3,045.45
20 J45 867.63 3,913.08
ACCOUNT: FICA TAXES PAYABLE - HI ACCOUNT NO. 20.2 Checkpoints
Debit Credit
POST. BALANCE Balance Balance
DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20-- 0.00 910.02
20-- Nov. 30, 20-- 0.00 915.18
Oct. 9 J41 225.18 225.18 Dec. 31, 20-- 0.00
9 J41 225.17 450.35
23 J42 229.84 680.19
23 J42 229.83 910.02
Nov. 6 J43 224.53 1,134.55
6 J43 224.51 1,359.06
13 J44 30.15 1,389.21
13 J44 30.15 1,419.36
16 J44 910.02 509.34
20 J44 202.93 712.27
20 J45 202.91 915.18
ACCOUNT: FUTA TAXES PAYABLE ACCOUNT NO. 21 Checkpoints
Debit Credit
POST. BALANCE Balance Balance
DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20-- 0.00 420.00
20-- Nov. 30, 20-- 0.00 420.00
Oct. 1 Balance a 392.94 Dec. 31, 20-- 0.00
9 J41 23.34 416.28
23 J42 3.72 420.00
ACCOUNT: SUTA TAXES PAYABLE - EMPLOYER ACCOUNT NO. 22 Checkpoints
Debit Credit
POST. BALANCE Balance Balance
DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20-- 0.00 370.74
20-- Nov. 30, 20-- 0.00 626.05
Oct. 9 J41 185.37 185.37 Dec. 31, 20-- 0.00
23 J42 185.37 370.74
Nov. 6 J43 184.22 554.96
20 J45 71.09 626.05
ACCOUNT: EMPLOYEES FIT PAYABLE ACCOUNT NO. 24 Checkpoints
Debit Credit
POST. BALANCE Balance Balance
DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20-- 0.00 1,510.00
20-- Nov. 30, 20-- 0.00 1,508.00
Oct. 9 J41 740.00 740.00 Dec. 31, 20-- 0.00
23 J42 770.00 1,510.00
Nov. 6 J43 806.00 2,316.00
13 J44 176.00 2,492.00
16 J44 1,510.00 982.00
20 J44 526.00 1,508.00
ACCOUNT: EMPLOYEES SIT PAYABLE ACCOUNT NO. 25 Checkpoints
Debit Credit
POST. BALANCE Balance Balance
DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20-- 0.00 486.63
20-- Nov. 30, 20-- 0.00 429.64
Oct. 9 J41 476.76 476.76 Dec. 31, 20-- 0.00
20 J41 476.76 0.00
23 J42 486.63 486.63
Nov. 4 J42 486.63 0.00
6 J43 475.37 475.37
13 J44 63.84 539.21
18 J44 539.21 0.00
20 J44 429.64 429.64
ACCOUNT: EMPLOYEES SUTA PAYABLE ACCOUNT NO. 25.1 Checkpoints
Debit Credit
POST. BALANCE Balance Balance
DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20-- 0.00 22.02
20-- Nov. 30, 20-- 0.00 44.17
Oct. 9 J41 10.90 10.90 Dec. 31, 20-- 0.00
23 J42 11.12 22.02
Nov. 6 J43 10.87 32.89
13 J44 1.46 34.35
20 J44 9.82 44.17
ACCOUNT: EMPLOYEES CIT PAYABLE ACCOUNT NO. 26 Checkpoints
Debit Credit
POST. BALANCE Balance Balance
DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20-- 0.00 1,189.29
20-- Nov. 30, 20-- 0.00 1,196.04
Oct. 9 J41 588.55 588.55 Dec. 31, 20-- 0.00
23 J42 600.74 1,189.29
Nov. 6 J43 586.84 1,776.13
13 J44 78.81 1,854.94
16 J44 1,189.29 665.65
20 J44 530.39 1,196.04
ACCOUNT: GROUP INSURANCE PREMIUMS COLLECTED ACCOUNT NO. 27 Checkpoints
Debit Credit
POST. BALANCE Balance Balance
DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20-- 0.00 182.10
20-- Nov. 30, 20-- 0.00 364.20
Oct. 23 J42 182.10 182.10 Dec. 31, 20-- 0.00
Nov. 13 J44 14.40 196.50
20 J44 167.70 364.20
ACCOUNT: UNION DUES PAYABLE ACCOUNT NO. 28 Checkpoints
Debit Credit
POST. BALANCE Balance Balance
DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20-- 0.00 32.00
20-- Nov. 30, 20-- 0.00 32.00
Oct. 9 J41 16.00 16.00 Dec. 31, 20-- 0.00
23 J42 16.00 32.00
Nov. 6 J42 32.00 0.00
6 J43 16.00 16.00
20 J44 16.00 32.00
ACCOUNT: SIMPLE CONTRIBUTIONS PAYABLE ACCOUNT NO. 29 Checkpoints
Debit Credit
POST. BALANCE Balance Balance
DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20-- 0.00 0.00
20-- Nov. 30, 20-- 0.00 1,650.00
Nov. 20 J44 1,650.00 1,650.00 Dec. 31, 20-- 0.00
ACCOUNT: ADMINISTRATIVE SALARIES ACCOUNT NO. 51 Checkpoints
Debit Credit
POST. BALANCE Balance Balance
DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20-- 47,307.65 0.00
20-- Nov. 30, 20-- 51,923.03 0.00
Oct. 1 Balance a 42,692.27 Dec. 31, 20-- 0.00
9 J41 2,307.69 44,999.96
23 J42 2,307.69 47,307.65
Nov. 6 J43 2,307.69 49,615.34
20 J44 2,307.69 51,923.03
ACCOUNT: OFFICE SALARIES ACCOUNT NO. 52 Checkpoints
Debit Credit
POST. BALANCE Balance Balance
DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20-- 37,796.16 0.00
20-- Nov. 30, 20-- 48,023.33 0.00
Oct. 1 Balance a 28,350.00 Dec. 31, 20-- 0.00
9 J41 4,723.08 33,073.08
23 J42 4,723.08 37,796.16
Nov. 6 J43 4,677.85 42,474.01
13 J44 2,079.32 44,553.33
20 J44 3,470.00 48,023.33
Dec 31
ACCOUNT: SALES SALARIES ACCOUNT NO. 53 Checkpoints
Debit Credit
POST. BALANCE Balance Balance
DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20-- 35,725.00 0.00
20-- Nov. 30, 20-- 42,925.00 0.00
Oct. 1 Balance a 28,525.00 Dec. 31, 20-- 0.00
9 J41 3,600.00 32,125.00
23 J42 3,600.00 35,725.00
Nov. 6 J43 3,600.00 39,325.00
20 J44 3,600.00 42,925.00
Dec 31
ACCOUNT: PLANT WAGES ACCOUNT NO. 54 Checkpoints
Debit Credit
POST. BALANCE Balance Balance
DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20-- 52,774.90 0.00
20-- Nov. 30, 20-- 62,289.30 0.00
Oct. 1 Balance a 42,657.30 Dec. 31, 20-- 0.00
9 J41 4,898.00 47,555.30
23 J42 5,219.60 52,774.90
Nov. 6 J43 4,898.00 57,672.90
20 J44 4,616.40 62,289.30
Dec 7 J45 5,218.50 67,507.80
21 J46 4,899.70 72,407.50
31 J47 5,005.20 77,412.70
ACCOUNT: PAYROLL TAXES ACCOUNT NO. 56 Checkpoints
Debit Credit
POST. BALANCE Balance Balance
DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20-- 17,262.41 0.00
20-- Nov. 30, 20-- 19,931.82 0.00
Oct. 1 Balance a 14,464.11 Dec. 31, 20-- 0.00
9 J41 1,396.66 15,860.77
23 J42 1,401.64 17,262.41
Nov. 6 J43 1,368.71 18,631.12
13 J44 159.07 18,790.19
20 J45 1,141.63 19,931.82
Dec 31 J46 1,350.00 21,281.82

Payroll Register

PAYROLL REGISTER GLO-BRITE PAINT COMPANY
Filing Status No. W/H Allow. Time Record Regular Earnings Overtime Earnings Total Earnings Deductions Net Paid Taxable Earnings Labor Cost Distribution
NAME S M T W T F S S M T W T F S Hrs. Rate Per Hour Amount Hrs. Rate Per Hour Amount OASDI HI FIT SIT SUTA CIT Group Ins. Union Dues SIMPLE Ck. No. Amount OASDI HI FUTA SUTA Admin. Office Sales Plant
Payday, October 9, 20-- For Period Ending October 3, 20-- Checkpoints
Bonno, A. MFJ N/A 8 8 8 8 8 8 8 8 8 8 80 17.60 1,408.00 1,408.00 87.30 20.42 34.00 43.23 0.99 53.36 8.00 672 1,160.70 1,408.00 1,408.00 1,408.00 Total earnings 15,528.77
Ferguson, J. MFJ N/A 8 8 8 8 8 8 8 8 8 8 80 2,250.00 2,250.00 139.50 32.63 127.00 69.08 1.58 85.28 673 1,794.93 2,250.00 2,250.00 2,250.00 Net paid 12,508.59
Ford, C. S N/A 8 8 8 8 8 8 8 8 8 8 80 1,220.00 1,220.00 75.64 17.69 75.00 37.45 0.85 46.24 674 967.13 1,220.00 1,220.00 700.00 1,220.00 1,220.00
Mann, K. MFJ N/A 8 8 8 8 8 8 8 8 8 8 80 1,350.00 1,350.00 83.70 19.58 28.00 41.45 0.95 51.17 675 1,125.15 1,350.00 1,350.00 1,350.00 1,350.00 1,350.00
O'Neill, J. MFJ N/A 8 8 8 8 8 8 8 8 8 8 80 2,307.69 2,307.69 143.08 33.46 131.00 70.85 1.62 87.46 676 1,840.22 2,307.69 2,307.69 2,307.69
Russell, S. S N/A 8 8 8 8 8 8 8 8 8 8 80 1,200.00 1,200.00 74.40 17.40 73.00 36.84 0.84 45.48 677 952.04 1,200.00 1,200.00 760.00 1,200.00 1,200.00
Ryan, J. MFJ N/A 8 8 8 8 8 8 8 8 8 8 80 18.00 1,440.00 1,440.00 89.28 20.88 38.00 44.21 1.01 54.58 8.00 678 1,184.04 1,440.00 1,440.00 1,440.00
Sokowski, T. MFJ N/A 8 8 8 8 8 8 8 8 8 8 80 2,050.00 2,050.00 127.10 29.73 101.00 62.94 1.44 77.70 679 1,650.09 2,050.00 2,050.00 2,050.00
(Student) S N/A 8 8 8 8 4 8 8 8 8 4 72 15.00 1,080.00 1,080.00 66.96 15.66 58.00 33.16 0.76 40.93 680 864.53 1,080.00 1,080.00 1,080.00 1,080.00 1,080.00
Williams, R. S N/A 8 8 D 8 8 8 8 8 8 8 80 1,223.08 1,223.08 75.83 17.73 75.00 37.55 0.86 46.35 681 969.76 1,223.08 1,223.08 1,223.08
TOTALS 15,528.77 15,528.77 962.79 225.18 740.00 476.76 10.90 588.55 0.00 16.00 0.00 12,508.59 15,528.77 15,528.77 3,890.00 4,850.00 2,307.69 4,723.08 3,600.00 4,898.00
Payday, October 23, 20-- For Period Ending October 17, 20-- Checkpoints
Bonno, A. MFJ N/A 8 8 8 8 8 4 8 8 8 8 8 80 17.60 1,408.00 4 26.40 105.60 1,513.60 93.84 21.95 44.00 46.47 1.06 57.37 16.50 8.00 682 1,224.41 1,513.60 1,513.60 1,513.60 Total earnings 15,850.37
Ferguson, J. MFJ N/A 8 8 8 8 8 8 8 8 8 8 80 2,250.00 2,250.00 139.50 32.63 127.00 69.08 1.58 85.28 26.40 683 1,768.53 2,250.00 2,250.00 2,250.00 Net paid 12,571.22
Ford, C. S N/A 8 8 8 8 8 8 8 8 8 8 80 1,220.00 1,220.00 75.64 17.69 75.00 37.45 0.85 46.24 14.40 684 952.73 1,220.00 1,220.00 1,220.00 1,220.00
Mann, K MFJ N/A 8 8 8 8 8 8 8 8 8 8 80 1,350.00 1,350.00 83.70 19.58 28.00 41.45 0.95 51.17 15.90 685 1,109.25 1,350.00 1,350.00 250.00 1,350.00 1,350.00
O'Neill, J. MFJ N/A 8 8 8 8 8 8 8 8 8 8 80 2,307.69 2,307.69 143.08 33.46 131.00 70.85 1.62 87.46 27.00 686 1,813.22 2,307.69 2,307.69 2,307.69
Russell, S. S N/A 8 8 8 8 8 8 8 8 8 8 80 1,200.00 1,200.00 74.40 17.40 73.00 36.84 0.84 45.48 14.10 687 937.94 1,200.00 1,200.00 1,200.00 1,200.00
Ryan, J. MFJ N/A 8 8 8 8 8 8 8 8 8 8 8 80 18.00 1,440.00 8 27.00 216.00 1,656.00 102.67 24.01 58.00 50.84 1.16 62.76 16.80 8.00 688 1,331.76 1,656.00 1,656.00 1,656.00
Sokowski, T. MFJ N/A 8 8 8 8 8 8 8 8 8 8 80 2,050.00 2,050.00 127.10 29.73 101.00 62.94 1.44 77.70 24.00 689 1,626.09 2,050.00 2,050.00 2,050.00
(Student) S N/A 8 8 8 8 4 8 8 8 8 4 72 15.00 1,080.00 1,080.00 66.96 15.66 58.00 33.16 0.76 40.93 12.60 690 851.93 1,080.00 1,080.00 370.00 1,080.00 1,080.00
Williams, R. S N/A 8 8 8 8 8 8 8 8 8 8 80 1,223.08 1,223.08 75.83 17.73 75.00 37.55 0.86 46.35 14.40 691 955.36 1,223.08 1,223.08 1,223.08
TOTALS 15,528.77 321.60 15,850.37 982.72 229.84 770.00 486.63 11.12 600.74 182.10 16.00 0.00 12,571.22 15,850.37 15,850.37 620.00 4,850.00 2,307.69 4,723.08 3,600.00 5,219.60
Payday, November 6, 20-- For Period Ending October 31, 20-- Checkpoints
Bonno, A. MFJ N/A 8 8 8 8 8 8 8 8 8 8 80 17.60 1,408.00 1,408.00 87.30 20.42 34.00 43.23 0.99 53.36 8.00 692 1,160.70 1,408.00 1,408.00 1,408.00 Total earnings 15,483.54
Ferguson, J. MFJ N/A 8 8 8 8 8 8 8 8 8 8 80 2,250.00 2,250.00 139.50 32.63 127.00 69.08 1.58 85.28 693 1,794.93 2,250.00 2,250.00 2,250.00 Net paid 12,403.94
Ford, C. S N/A 8 8 8 8 8 8 8 8 8 8 80 1,220.00 1,220.00 75.64 17.69 75.00 37.45 0.85 46.24 694 967.13 1,220.00 1,220.00 1,220.00 1,220.00
Mann, K MFJ N/A 8 8 8 8 8 8 8 8 8 8 80 1,350.00 1,350.00 83.70 19.58 28.00 41.45 0.95 51.17 695 1,125.15 1,350.00 1,350.00 1,350.00 1,350.00
O'Neill, J. MFJ N/A 8 8 8 8 8 8 8 8 8 8 80 2,307.69 2,307.69 143.08 33.46 131.00 70.85 1.62 87.46 696 1,840.22 2,307.69 2,307.69 2,307.69
Russell, S. S N/A 8 8 8 8 6 8 8 8 8 8 78 1,170.00 1,170.00 72.54 16.97 68.00 35.92 0.82 44.34 697 931.41 1,170.00 1,170.00 1,170.00 1,170.00
Ryan, J. MFJ N/A 8 8 8 8 8 8 8 8 8 8 80 18.00 1,440.00 1,440.00 89.28 20.88 38.00 44.21 1.01 54.58 8.00 698 1,184.04 1,440.00 1,440.00 1,440.00
Sokowski, T. S N/A 8 8 8 8 8 8 8 8 8 8 80 2,050.00 2,050.00 127.10 29.73 174.00 62.94 1.44 77.70 699 1,577.09 2,050.00 2,050.00 2,050.00
(Student) S N/A 8 8 8 8 4 8 8 8 8 4 72 15.00 1,080.00 1,080.00 66.96 15.66 58.00 33.16 0.76 40.93 700 864.53 1,080.00 1,080.00 1,080.00 1,080.00
Williams, R. S N/A 8 8 8 7 8 8 8 8 8 8 79 1,207.85 1,207.85 74.89 17.51 73.00 37.08 0.85 45.78 701 958.74 1,207.85 1,207.85 1,207.85
TOTALS 15,483.54 15,483.54 959.99 224.53 806.00 475.37 10.87 586.84 0.00 16.00 0.00 12,403.94 15,483.54 15,483.54 0.00 4,820.00 2,307.69 4,677.85 3,600.00 4,898.00
Payday, November 13, 20-- For Period Ending November 14, 20-- Checkpoints
Williams, R. S N/A 6 8 7 7 6 D D 8 6 8 136 2,079.32 2,079.32 128.92 30.15 176.00 63.84 1.46 78.81 14.40 702 1,585.74 2,079.32 2,079.32 2,079.32 Total earnings 2,079.32
Net paid 1,585.74
TOTALS 2,079.32 2,079.32 128.92 30.15 176.00 63.84 1.46 78.81 14.40 0.00 0.00 1,585.74 2,079.32 2,079.32 0.00 0.00 0.00 2,079.32 0.00 0.00
Payday, November 20, 20-- For Period Ending November 14, 20-- Checkpoints
Bonno, A. MFJ N/A 8 8 8 8 8 8 8 8 64 17.60 1,126.40 1,126.40 69.84 16.33 7.00 34.58 0.79 42.69 16.50 8.00 703 930.67 1,126.40 1,126.40 1,126.40 Total earnings 13,994.09
Ferguson, J. MFJ N/A 8 8 8 8 8 8 8 8 8 8 80 2,250.00 2,250.00 139.50 32.63 68.00 69.08 1.58 85.28 26.40 500.00 704 1,327.53 2,250.00 2,250.00 2,250.00 Net paid 9,593.97
Ford, C. S N/A 8 8 8 8 8 8 8 8 8 8 80 1,220.00 1,220.00 75.64 17.69 75.00 37.45 0.85 46.24 14.40 705 952.73 1,220.00 1,220.00 40.00 1,220.00
Mann, K MFJ N/A 8 8 8 8 8 8 8 8 8 8 80 1,350.00 1,350.00 83.70 19.58 4.00 41.45 0.95 51.17 15.90 250.00 706 883.25 1,350.00 1,350.00 550.00 1,350.00
O'Neill, J. MFJ N/A 8 8 8 8 8 8 8 8 8 8 80 2,307.69 2,307.69 143.08 33.46 54.00 70.85 1.62 87.46 27.00 700.00 707 1,190.22 2,307.69 2,307.69 2,307.69
Russell, S. S N/A 6 8 8 8 8 8 8 8 8 8 78 1,170.00 1,170.00 72.54 16.97 68.00 35.92 0.82 44.34 14.10 708 917.31 1,170.00 1,170.00 190.00 1,170.00
Ryan, J. MFJ N/A 8 8 8 8 8 8 8 8 8 8 80 18.00 1,440.00 1,440.00 89.28 20.88 18.00 44.21 1.01 54.58 16.80 8.00 200.00 709 987.24 1,440.00 1,440.00 1,440.00
Sokowski, T. S N/A 8 8 8 8 8 8 8 8 8 8 80 2,050.00 2,050.00 127.10 29.73 174.00 62.94 1.44 77.70 24.00 710 1,553.09 2,050.00 2,050.00 2,050.00
(Student) S N/A 8 8 8 8 4 8 8 8 8 4 72 15.00 1,080.00 1,080.00 66.96 15.66 58.00 33.16 0.76 40.93 12.60 711 851.93 1,080.00 1,080.00 1,080.00 1,080.00
TOTALS 13,994.09 13,994.09 867.64 202.93 526.00 429.64 9.82 530.39 167.70 16.00 1,650.00 9,593.97 13,994.09 13,994.09 0.00 1,860.00 2,307.69 3,470.00 3,600.00 4,616.40
Payday, December 4, 20-- For Period Ending November 28, 20-- Checkpoints
Bonno, A. MFJ N/A 8 8 8 8 8 8 8 8 60.11 60.11 3.73 0.87 1.85 0.04 2.28 51.34 Total earnings
Ferguson, J. MFJ N/A 8 8 8 8 8 8 8 8 87.32 87.32 5.41 1.27 2.68 0.06 3.31 74.59 Net paid
Ford, C. S N/A 8 8 8 8 8 8 8 8 44.71 44.71 2.77 0.65 1.37 0.03 1.69 38.20
Mann, K MFJ N/A 8 8 8 8 8 8 8 8
O'Neill, J. MFJ N/A 8 8 8 8 8 8 8 8
Russell, S. S N/A 8 8 8 8 8 8 8 8
Ryan, J. MFJ N/A 8 8 8 8 8 8 8 8
Sokowski, T. S N/A 8 8 8 8 8 8 8 8
(Student) S N/A 8 8 8 8 8 8 8 8
Woods, B. S N/A 8 8 8 8 8 8 8 8
8 8 8 8 8 8 8 8
8 8 8 8 8 8 8 8
TOTALS 192.14 192.14 11.91 2.79 0.00 5.90 0.13 7.28 0.00 0.00 0.00 164.13 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Payday, December 14, 20-- For Period Ending December 12, 20-- Checkpoints
Russell, S. S N/A Total earnings
Net paid
TOTALS 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Payday, December 18, 20-- For Period Ending December 12, 20-- Checkpoints
Bonno, A. MFJ N/A 71.04 16.50 87.54 5.43 1.27 2.69 0.06 3.32 16.50 58.27 Total earnings
Ferguson, J. MFJ N/A 87.32 26.40 113.72 7.05 1.65 3.49 0.08 4.31 26.40 70.74 Net paid
Ford, C. S N/A 47.19 47.19 2.93 0.68 1.45 0.03 1.79 40.31
Mann, K MFJ N/A 52.39 52.39 3.25 0.76 1.61 0.04 1.99 44.74
O'Neill, J. MFJ N/A 89.56 89.56 6,713.16 1.30 2.75 0.06 3.39 -6,631.10
Ryan, J. MFJ N/A 65.22 65.22 4.04 0.95 2.00 0.05 2.47 55.71
Sokowski, T. S N/A 79.56 79.56 4.93 1.15 2.44 0.06 3.02 67.96
(Student) S N/A Checkpoints-Annual
Woods, B. S N/A Total earnings
Young, P. S N/A Qtr's taxable OASDI earnings
Total earnings for FIT
Total earnings for SIT/CIT
Total earnings for FUTA 73,540.00
TOTALS 492.28 42.90 535.18 6,740.79 7.76 0.00 16.43 0.38 20.29 42.90 0.00 0.00 -6,293.37 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
QTR 63,663.41 10,654.76 923.18 3,018.00 1,954.57 44.68 2,412.90 407.10 64.00 1,650.00 42,534.22 62,936.09 62,936.09 4,510.00 16,380.00 9,230.76 19,673.33 14,400.00 19,632.00
YEAR 205,887.98 19,472.68 2,985.45 18,935.00 6,320.86 144.25 7,803.22 1,337.50 208.00 1,650.00 147,031.02 205,160.66 205,160.66 70,000.00 99,870.00 72,407.50

Employees' Earnings Records

DEPARTMENT OCCUPATION WORKS IN (STATE) S.S. ACCOUNT NO. N/AME - LAST FIRST MIDDLE
Plant Mixer Operator PA 000-00-3481 BONNO Anthony Victor
OTHER DEDUCTIONS INFORMATION SALARY $ W/H FILING
GROUP INSURANCE UNION DUES OTHER WEEKLY RATE $ ALLOW. STATUS
$55,000 --$.30/M $8 each pay HOURLY RATE $ 17.60 N/A MFJ
OVERTIME RATE $ 26.40 M
20___ REGULAR EARNINGS OVERTIME EARNINGS CUMULATIVE DEDUCTIONS NET PAID F
PAYDAY HRS. RATE AMOUNT HRS. RATE AMOUNT EARNINGS FICA FIT SIT SUTA CIT SIMPLE OTHER CK.
OASDI HI DEDUCTIONS NO. AMOUNT
YEAR-TO-DATE 10,293.40 1,028.60 11,322.00 701.96 164.17 810.00 347.59 7.93 429.10 216.80 8,644.45
1 10/9 80 17.60 1,408.00 0.00 12,730.00 87.30 20.42 34.00 43.23 0.99 53.36 8.00 672 1,160.70
2 10/23 80 17.60 1,408.00 4 26.40 105.60 14,243.60 93.84 21.95 44.00 46.47 1.06 57.37 24.50 682 1,224.41
3 11/6 80 17.60 1,408.00 0.00 15,651.60 87.30 20.42 34.00 43.23 0.99 53.36 8.00 692 1,160.70
4 11/20 64 17.60 1,126.40 0.00 16,778.00 69.84 16.33 7.00 34.58 0.79 42.69 24.50 703 930.67
5 12/4 17.60 0.00 247.30 692
6 12/18 17.60 0.00 195.73 703
QTR. TOT. 508.03
YR. TOT. 724.83
Checkpoint 8,976.00 Checkpoint
DEPARTMENT OCCUPATION WORKS IN (STATE) S.S. ACCOUNT NO. N/AME - LAST FIRST MIDDLE
Sales Sales Manager PA 000-00-8645 FERGUSON Jamie Hadi
OTHER DEDUCTIONS INFORMATION SALARY $ 58,500 /yr. W/H FILING
GROUP INSURANCE UNION DUES OTHER WEEKLY RATE $ 1,125.00 ALLOW. STATUS
$88,000 -- $.30/M HOURLY RATE $ 28.13 N/A MFJ
OVERTIME RATE $
20___ REGULAR EARNINGS OVERTIME EARNINGS CUMULATIVE DEDUCTIONS NET PAID
PAYDAY HRS. RATE AMOUNT HRS. RATE AMOUNT EARNINGS FICA FIT SIT SUTA CIT SIMPLE OTHER CK.
OASDI HI DEDUCTIONS NO. AMOUNT
YEAR-TO-DATE 23,125.00 23,125.00 1,433.75 335.31 2,291.00 709.94 16.19 876.44 132.30 17,330.07
1 10/9 80 2,250.00 25,375.00 139.50 32.63 127.00 69.08 1.58 85.28 673 1,794.93
2 10/23 80 2,250.00 27,625.00 139.50 32.63 127.00 69.08 1.58 85.28 26.40 683 1,768.53
3 11/6 80 2,250.00 29,875.00 139.50 32.63 127.00 69.08 1.58 85.28 693 1,794.93
4 11/20 80 2,250.00 32,125.00 139.50 32.63 68.00 69.08 1.58 85.28 500.00 26.40 704 1,327.53
5 12/4 2,250.00 34,375.00 26.40 2,223.60
6 12/18 2,250.00 36,625.00 26.40 2,223.60
QTR. TOT. 13,500.00 13,500.00 130.52 276.32 6.32 341.12 105.60 11,133.12
YR. TOT. 36,625.00 36,625.00 465.83 986.26 22.51 1,217.56 237.90 28,463.19
Checkpoint 13,500.00 36,625.00 Checkpoint
DEPARTMENT OCCUPATION WORKS IN (STATE) S.S. ACCOUNT NO. N/AME - LAST FIRST MIDDLE
Office Administrative Assistant PA 000-00-4567 FORD Catherine Louise
OTHER DEDUCTIONS INFORMATION SALARY $ 2,733.33 /mo. W/H FILING
GROUP INSURANCE UNION DUES OTHER WEEKLY RATE $ 640.00 ALLOW. STATUS
$50,000--$.30/M HOURLY RATE $ 16.00 N/A S
OVERTIME RATE $ 24.00
20___ REGULAR EARNINGS OVERTIME EARNINGS CUMULATIVE DEDUCTIONS NET PAID
PAYDAY HRS. RATE AMOUNT HRS. RATE AMOUNT EARNINGS FICA FIT SIT SUTA CIT SIMPLE OTHER CK.
OASDI HI DEDUCTIONS NO. AMOUNT
YEAR-TO-DATE 6,300.00 6,300.00 390.60 91.35 639.00 193.41 4.41 238.77 37.80 4,704.66
1 10/9 80 1,220.00 7,520.00 75.64 17.69 75.00 37.45 0.85 46.24 674 967.13
2 10/23 80 1,220.00 8,740.00 75.64 17.69 75.00 37.45 0.85 46.24 14.40 684 952.73
3 11/6 80 1,220.00 9,960.00 75.64 17.69 75.00 37.45 0.85 46.24 694 967.13
4 11/20 80 1,220.00 11,180.00 75.64 17.69 75.00 37.45 0.85 46.24 14.40 705 952.73
5 12/4 1,220.00 12,400.00 1,220.00
6 12/18 1,220.00 13,620.00 1,220.00
QTR. TOT. 7,320.00 7,320.00 302.56 70.76 149.80 3.40 184.96 6,279.72
YR. TOT. 13,620.00 13,620.00 693.16 162.11 343.21 7.81 423.73 10,984.38
Checkpoint Checkpoint
DEPARTMENT OCCUPATION WORKS IN (STATE) S.S. ACCOUNT NO. N/AME - LAST FIRST MIDDLE
Sales Sales Representative PA 000-00-9352 MANN Kari Casey
OTHER DEDUCTIONS INFORMATION SALARY $ 2,925 /mo. W/H FILING
GROUP INSURANCE UNION DUES OTHER WEEKLY RATE $ 675.00 ALLOW. STATUS
$53,000 -- $.30/M HOURLY RATE $ 16.88 N/A MFJ
OVERTIME RATE $
20___ REGULAR EARNINGS OVERTIME EARNINGS CUMULATIVE DEDUCTIONS NET PAID
PAYDAY HRS. RATE AMOUNT HRS. RATE AMOUNT EARNINGS FICA FIT SIT SUTA CIT SIMPLE OTHER CK.
OASDI HI DEDUCTIONS NO. AMOUNT
YEAR-TO-DATE 5,400.00 5,400.00 334.80 78.30 332.00 165.78 3.78 204.66 31.50 4,249.18
1 10/9 80 1,350.00 6,750.00 83.70 19.58 28.00 41.45 0.95 51.17 675 1,125.15
2 10/23 80 1,350.00 8,100.00 83.70 19.58 28.00 41.45 0.95 51.17 15.90 685 1,109.25
3 11/6 80 1,350.00 9,450.00 83.70 19.58 28.00 41.45 0.95 51.17 695 1,125.15
4 11/20 80 1,350.00 10,800.00 83.70 19.58 4.00 41.45 0.95 51.17 250.00 15.90 706 883.25
5 12/4 1,350.00 12,150.00 250.00 715 1,100.00
6 12/18 1,350.00 13,500.00 250.00 726 1,100.00
QTR. TOT. 8,100.00 8,100.00 334.80 78.32 165.80 3.80 204.68 750.00 6,442.80
YR. TOT. 13,500.00 13,500.00 669.60 156.62 331.58 7.58 409.34 750.00 10,691.98
Checkpoint 8,100.00 13,500.00 Checkpoint
DEPARTMENT OCCUPATION WORKS IN (STATE) S.S. ACCOUNT NO. N/AME - LAST FIRST MIDDLE
Admini- strative President PA 000-00-1534 O'NEILL Joseph Tyler
OTHER DEDUCTIONS INFORMATION SALARY $ 60,000 /yr. W/H FILING
GROUP INSURANCE UNION DUES OTHER BI-WEEKLY RATE $ 2,307.69 ALLOW. STATUS
$90,000 -- $.30/M HOURLY RATE $ N/A MFJ
OVERTIME RATE $
20___ REGULAR EARNINGS OVERTIME EARNINGS CUMULATIVE DEDUCTIONS NET PAID
PAYDAY HRS. RATE AMOUNT HRS. RATE AMOUNT EARNINGS FICA FIT SIT SUTA CIT SIMPLE OTHER CK.
OASDI HI DEDUCTIONS NO. AMOUNT
YEAR-TO-DATE 42,692.27 42,692.27 2,646.92 619.04 6,116.00 1,310.65 29.88 1,618.04 202.50 30,149.24
1 10/9 80 2,307.69 44,999.96 143.08 33.46 131.00 70.85 1.62 87.46 676 1,840.22
2 10/23 80 2,307.69 47,307.65 143.08 33.46 131.00 70.85 1.62 87.46 27.00 686 1,813.22
3 11/6 80 2,307.69 49,615.34 143.08 33.46 131.00 70.85 1.62 87.46 696 1,840.22
4 11/20 80 2,307.69 51,923.03 143.08 33.46 54.00 70.85 1.62 87.46 700.00 27.00 707 1,190.22
5 12/4 2,307.69 54,230.72 2,307.69
6 12/18 2,307.69 56,538.41 6,713.16 -4,405.47
QTR. TOT. 13,846.14 13,846.14 7,285.48 133.84 283.40 6.48 349.84 4,586.10
YR. TOT. 56,538.41 56,538.41 9,932.40 752.88 1,594.05 36.36 1,967.88 34,735.34
Checkpoint Checkpoint
DEPARTMENT OCCUPATION WORKS IN (STATE) S.S. ACCOUNT NO. N/AME - LAST FIRST MIDDLE
Office Time Clerk PA 000-00-6337 RUSSELL Serdar Parker
OTHER DEDUCTIONS INFORMATION SALARY $ 2,730 /mo. W/H FILING
GROUP INSURANCE UNION DUES OTHER WEEKLY RATE $ 630.00 ALLOW. STATUS
$49,000 -- $.30/M HOURLY RATE $ 15.75 N/A S
OVERTIME RATE $ 23.63
20___ REGULAR EARNINGS OVERTIME EARNINGS CUMULATIVE DEDUCTIONS NET PAID
PAYDAY HRS. RATE AMOUNT HRS. RATE AMOUNT EARNINGS FICA FIT SIT SUTA CIT SIMPLE OTHER CK.
OASDI HI DEDUCTIONS NO. AMOUNT
YEAR-TO-DATE 6,240.00 6,240.00 386.88 90.48 642.00 191.56 4.37 236.50 31.50 4,656.71
1 10/9 80 1,200.00 7,440.00 74.40 17.40 73.00 36.84 0.84 45.48 677 952.04
2 10/23 80 1,200.00 8,640.00 74.40 17.40 73.00 36.84 0.84 45.48 14.10 687 937.94
3 11/6 78 1,170.00 9,810.00 72.54 16.97 68.00 35.92 0.82 44.34 697 931.41
4 11/20 78 1,170.00 10,980.00 72.54 16.97 68.00 35.92 0.82 44.34 14.10 708 917.31
5 12/4 1,170.00 12,150.00 1,170.00
6 12/14 1,170.00 13,320.00 0.00 1,170.00
QTR. TOT. 7,080.00 7,080.00 293.88 68.74 282.00 145.52 3.32 179.64 6,078.70
YR. TOT. 13,320.00 13,320.00 680.76 159.22 924.00 337.08 7.69 416.14 10,735.41
Checkpoint Checkpoint
DEPARTMENT OCCUPATION WORKS IN (STATE) S.S. ACCOUNT NO. N/AME - LAST FIRST MIDDLE
Plant Electrician PA 000-00-1223 RYAN Jeri Mischa
OTHER DEDUCTIONS INFORMATION SALARY $ W/H FILING
GROUP INSURANCE UNION DUES OTHER WEEKLY RATE $ ALLOW. STATUS
$56,000 -- $.30/M $8 each pay HOURLY RATE $ 18.00 N/A MFJ
OVERTIME RATE $ 27.00
20___ REGULAR EARNINGS OVERTIME EARNINGS CUMULATIVE DEDUCTIONS NET PAID
PAYDAY HRS. RATE AMOUNT HRS. RATE AMOUNT EARNINGS FICA FIT SIT SUTA CIT SIMPLE OTHER CK.
OASDI HI DEDUCTIONS NO. AMOUNT
YEAR-TO-DATE 13,287.50 1,397.80 14,685.30 910.49 212.94 1,070.00 450.84 10.28 556.57 235.70 11,238.48
1 10/9 80 18.00 1,440.00 0.00 16,125.30 89.28 20.88 38.00 44.21 1.01 54.58 8.00 678 1,184.04
2 10/23 80 18.00 1,440.00 8 27.00 216.00 17,781.30 102.67 24.01 58.00 50.84 1.16 62.76 24.80 688 1,331.76
3 11/6 80 18.00 1,440.00 0.00 19,221.30 89.28 20.88 38.00 44.21 1.01 54.58 8.00 698 1,184.04
4 11/20 80 18.00 1,440.00 0.00 20,661.30 89.28 20.88 18.00 44.21 1.01 54.58 200.00 24.80 709 987.24
5 12/4 80 18.00 1,440.00 0.00 22,101.30 89.28 20.88 44.21 1.01 54.58 8.00 1,222.04
6 12/18 80 18.00 1,440.00 0.00 23,541.30 89.28 20.88 44.21 1.01 54.58 24.80 1,205.24
QTR. TOT. 480 8,640.00 216.00 8,856.00 549.07 128.41 271.89 6.21 335.66 98.40 7,114.36
YR. TOT. 21,927.50 1,613.80 23,541.30 1,459.56 341.35 722.73 16.49 892.23 334.10 18,352.84
Checkpoint Checkpoint
DEPARTMENT OCCUPATION WORKS IN (STATE) S.S. ACCOUNT NO. N/AME - LAST FIRST MIDDLE
Plant Supervisor PA 000-00-8832 SOKOWSKI Thomas James
OTHER DEDUCTIONS INFORMATION SALARY $ W/H FILING
GROUP INSURANCE UNION DUES OTHER WEEKLY RATE $ 1,025.00 ALLOW. STATUS
$80,000 -- $.30/M HOURLY RATE $ 25.63 N/A S
OVERTIME RATE $
20___ REGULAR EARNINGS OVERTIME EARNINGS CUMULATIVE DEDUCTIONS NET PAID
PAYDAY HRS. RATE AMOUNT HRS. RATE AMOUNT EARNINGS FICA FIT SIT SUTA CIT SIMPLE OTHER CK.
OASDI HI DEDUCTIONS NO. AMOUNT
YEAR-TO-DATE 16,650.00 16,650.00 1,032.30 241.43 2,002.00 511.16 11.66 631.04 94.50 12,125.91
1 10/9 80 2,050.00 18,700.00 127.10 29.73 101.00 62.94 1.44 77.70 679 1,650.09
2 10/23 80 2,050.00 20,750.00 127.10 29.73 101.00 62.94 1.44 77.70 24.00 689 1,626.09
3 11/6 80 2,050.00 22,800.00 127.10 29.73 174.00 62.94 1.44 77.70 699 1,577.09
4 11/20 80 2,050.00 24,850.00 127.10 29.73 174.00 62.94 1.44 77.70 24.00 710 1,553.09
5 12/4 2,050.00 26,900.00 2,050.00
6 12/18 4,100.00 31,000.00 4,100.00
QTR. TOT. 14,350.00 14,350.00 508.40 118.92 251.76 5.76 310.80 12,556.36
YR. TOT. 31,000.00 31,000.00 1,540.70 360.35 762.92 17.42 941.84 24,682.27
Checkpoint Checkpoint
DEPARTMENT OCCUPATION WORKS IN (STATE) S.S. ACCOUNT NO. N/AME - LAST FIRST MIDDLE
Office Accounting Trainee PA Student
OTHER DEDUCTIONS INFORMATION SALARY $ W/H FILING
GROUP INSURANCE UNION DUES OTHER WEEKLY RATE $ ALLOW. STATUS
$42,000 -- $.30/M HOURLY RATE $ 15.00 N/A S
OVERTIME RATE $ 22.50
20___ REGULAR EARNINGS OVERTIME EARNINGS CUMULATIVE DEDUCTIONS NET PAID
PAYDAY HRS. RATE AMOUNT HRS. RATE AMOUNT EARNINGS FICA FIT SIT SUTA CIT SIMPLE OTHER CK.
OASDI HI DEDUCTIONS NO. AMOUNT
YEAR-TO-DATE 5,550.00 5,550.00 344.10 80.48 409.00 170.38 3.89 210.35 32.40 4,299.40
1 10/9 72 15.00 1,080.00 6,630.00 66.96 15.66 58.00 33.16 0.76 40.93 680 864.53
2 10/23 72 15.00 1,080.00 7,710.00 66.96 15.66 58.00 33.16 0.76 40.93 12.60 690 851.93
3 11/6 72 15.00 1,080.00 8,790.00 66.96 15.66 58.00 33.16 0.76 40.93 700 864.53
4 11/20 72 15.00 1,080.00 9,870.00 66.96 15.66 58.00 33.16 0.76 40.93 12.60 711 851.93
5 12/4
6 12/18
QTR. TOT.
YR. TOT.
Checkpoint Checkpoint
DEPARTMENT OCCUPATION WORKS IN (STATE) S.S. ACCOUNT NO. N/AME - LAST FIRST MIDDLE
Office Programmer PA 000-00-6741 WILLIAMS Ruth Virginia
OTHER DEDUCTIONS INFORMATION SALARY $ 2,650 /mo. W/H FILING
GROUP INSURANCE UNION DUES OTHER WEEKLY RATE $ 611.54 ALLOW. STATUS
$48,000 -- $.30/M HOURLY RATE $ 15.29 N/A S
OVERTIME RATE $ 22.94
20___ REGULAR EARNINGS OVERTIME EARNINGS CUMULATIVE DEDUCTIONS NET PAID
PAYDAY HRS. RATE AMOUNT HRS. RATE AMOUNT EARNINGS FICA FIT SIT SUTA CIT SIMPLE OTHER CK.
OASDI HI DEDUCTIONS NO. AMOUNT
YEAR-TO-DATE 10,260.00 10,260.00 636.12 148.77 1,606.00 314.98 7.18 388.85 59.40 7,098.70
1 10/9 80 1,223.08 11,483.08 75.83 17.73 75.00 37.55 0.86 46.35 681 969.76
2 10/23 80 1,223.08 12,706.16 75.83 17.73 75.00 37.55 0.86 46.35 14.40 691 955.36
3 11/6 79 1,207.85 13,914.01 74.89 17.51 73.00 37.08 0.85 45.78 701 958.74
4 11/13 136 2,079.32 15,993.33 128.92 30.15 176.00 63.84 1.46 78.81 14.40 702 1,585.74
5
6
QTR. TOT. 375 5,733.33 5,733.33 355.47 83.12 399.00 176.02 4.03 217.29 28.80 4,469.60
YR. TOT. 15,993.33 15,993.33 991.59 231.89 2,005.00 491.00 11.21 606.14 88.20 11,568.30
Checkpoint 5,733.33 15,993.33 Checkpoint 4,469.60 11,568.30
DEPARTMENT OCCUPATION WORKS IN (STATE) S.S. ACCOUNT NO. N/AME - LAST FIRST MIDDLE
Office Programmer PA 000-00-1587 Woods Beth Anne
OTHER DEDUCTIONS INFORMATION SALARY $ 2,600 /mo. W/H FILING
GROUP INSURANCE UNION DUES OTHER WEEKLY RATE $ 600.00 ALLOW. STATUS
$47,000 -- $.30/M HOURLY RATE $ 15.00 N/A S
OVERTIME RATE $
20___ REGULAR EARNINGS OVERTIME EARNINGS CUMULATIVE DEDUCTIONS NET PAID
PAYDAY HRS. RATE AMOUNT HRS. RATE AMOUNT EARNINGS FICA FIT SIT SUTA CIT SIMPLE OTHER CK.
OASDI HI DEDUCTIONS NO. AMOUNT
YEAR-TO-DATE
1
2
3
4
5 12/4 1,200.00 1,200.00 1,200.00
6 12/18 1,200.00 2,400.00 1,200.00
QTR. TOT. 2,400.00 2,400.00 0.00 0.00 0.00 0.00 0.00 2,400.00
YR. TOT. 2,400.00 2,400.00 0.00 0.00 0.00 0.00 0.00 2,400.00
Checkpoint Checkpoint
DEPARTMENT OCCUPATION WORKS IN (STATE) S.S. ACCOUNT NO. N/AME - LAST FIRST MIDDLE
Sales Field Sales Representative PA 000-00-6057 Young Paul Winston
OTHER DEDUCTIONS INFORMATION SALARY $ 2,730 /mo. W/H FILING
GROUP INSURANCE UNION DUES OTHER WEEKLY RATE $ 630.00 ALLOW. STATUS
$49,000 -- $.30/M HOURLY RATE $ 15.75 N/A S
OVERTIME RATE $
20___ REGULAR EARNINGS OVERTIME EARNINGS CUMULATIVE DEDUCTIONS NET PAID
PAYDAY HRS. RATE AMOUNT HRS. RATE AMOUNT EARNINGS FICA FIT SIT SUTA CIT SIMPLE OTHER CK.
OASDI HI DEDUCTIONS NO. AMOUNT
YEAR-TO-DATE
1
2
3
4
5
6 12/18 1,260.00 1,260.00 1,260.00
QTR. TOT. 1,260.00 1,260.00 0.00 0.00 0.00 0.00 0.00 1,260.00
YR. TOT. 1,260.00 1,260.00 0.00 0.00 0.00 0.00 0.00 1,260.00
Checkpoint 1,260.00 1,260.00 Checkpoint
DEPARTMENT OCCUPATION WORKS IN (STATE) S.S. ACCOUNT NO. N/AME - LAST FIRST MIDDLE
OTHER DEDUCTIONS INFORMATION SALARY $ W/H FILING
GROUP INSURANCE UNION DUES OTHER WEEKLY RATE $ ALLOW. STATUS
HOURLY RATE $
OVERTIME RATE $
20___ REGULAR EARNINGS OVERTIME EARNINGS CUMULATIVE DEDUCTIONS NET PAID
PAYDAY HRS. RATE AMOUNT HRS. RATE AMOUNT EARNINGS FICA FIT SIT SUTA CIT SIMPLE OTHER CK.
OASDI HI DEDUCTIONS NO. AMOUNT
YEAR-TO-DATE
1
2
3
4
5
6
QTR. TOT.
YR. TOT.
DEPARTMENT OCCUPATION WORKS IN (STATE) S.S. ACCOUNT NO. N/AME - LAST FIRST MIDDLE
OTHER DEDUCTIONS INFORMATION SALARY $ W/H FILING
GROUP INSURANCE UNION DUES OTHER WEEKLY RATE $ ALLOW. STATUS
HOURLY RATE $
OVERTIME RATE $
20___ REGULAR EARNINGS OVERTIME EARNINGS CUMULATIVE DEDUCTIONS NET PAID
PAYDAY HRS. RATE AMOUNT HRS. RATE AMOUNT EARNINGS FICA FIT SIT SUTA CIT SIMPLE OTHER CK.
OASDI HI DEDUCTIONS NO. AMOUNT
YEAR-TO-DATE
1
2
3
4
5
6
QTR. TOT.
YR. TOT.