Enclose please find TemplateI am having trouble in the Taxable earnings for SUTA and FUTA on the payroll earnings I am not sure how to calculate those.
payroll_project.xlsx
payroll_project.xlsx
Unformatted Attachment Preview
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,291.11
9 Administrative Salaries
Office Salaries
Sales Salaries
Plant Wages
FICA Taxes Payable – OASDI
FICA Taxes Payable – HI
Employees FIT Payable
Employees SIT Payable
Employees SUTA Payable
Employees CIT Payable
Union Dues Payable
Payroll Cash
51
52
53
54
20.1
20.2
24
25
25.1
26
28
12
2,307.69
4,651.08
3,600.00
4,898.00
9 Payroll Taxes
FICA Taxes Payable – OASDI
FICA Taxes Payable – HI
FUTA Taxes Payable
SUTA Taxes Payable – Employer
56
20.1
20.2
21
22
1,381.61
20 Employees SIT payable
Cash
CREDIT
12,291.11
958.33
224.14
882.00
474.55
9.25
601.39
16.00
12,291.11
958.32
224.12
22.91
176.26
474.55
474.55
Page 42
JOURNAL
DATE
20–
October
October
October
Nov
DESCRIPTION
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
Union Dues Payable
Payroll Cash
23 Payroll Taxes
FICA Taxes Payable – OASDI
FICA Taxes Payable – HI
FUTA Taxes Payable
SUTA Taxes Payable – Employer
4
Employees SIT Payable
Cash
Union dues payable
Cash
POST.
REF.
DEBIT
CREDIT
12,533.54
12,533.54
2,307.69
4,651.08
3,600.00
5,219.60
978.26
228.80
914.00
484.42
9.45
613.90
16.00
12,533.54
1,387.47
978.26
228.80
4.15
176.26
484.42
484.42
36.00
36.00
Page 43
JOURNAL
DATE
20–
November
DESCRIPTION
6 Payroll Cash
Cash
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
POST.
REF.
DEBIT
CREDIT
13,134.57
13,134.57
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
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):
72,958.41
72,958.41
Your debits and credits should be equal after each journal entry is complete
Cumulative Journal Checkpoint Through Month Ending
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
4
a
J41
J41
J42
J42
12,291.11
474.55
12,533.54
484.42
32.00
199,846.33
187,555.22
187,080.67
174,547.13
174,062.71
174,030.71
CREDIT
Debit
Balance
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20–
Credit
Balance
ACCOUNT:
ACCOUNT NO. 12
PAYROLL CASH
DATE
ITEM
POST.
REF.
BALANCE
DEBIT
CREDIT
DEBIT
20–
Oct.
9
9
23
23
J41
J41
J42
J42
Checkpoints
Debit
Balance
12,291.11
12,291.11
12,533.54
12,533.54
12,291.11
0.00
12,533.54
0.00
CREDIT
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20–
Credit
Balance
ACCOUNT:
ACCOUNT NO. 20.1
FICA TAXES PAYABLE – OASDI
DATE
ITEM
POST.
REF.
BALANCE
DEBIT
CREDIT
DEBIT
CREDIT
20–
Oct.
Oct.
9
9
23
J41
J41
J42
Checkpoints
Debit
Balance
958.33
958.32
978.26
958.33
1,916.65
2,894.91
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20–
Credit
Balance
ACCOUNT:
ACCOUNT NO. 20.2
FICA TAXES PAYABLE – HI
DATE
ITEM
POST.
REF.
BALANCE
DEBIT
CREDIT
DEBIT
CREDIT
20–
Oct.
9
9
23
J41
J41
J42
Checkpoints
Debit
Balance
224.14
224.12
228.80
224.14
448.26
677.06
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20–
Credit
Balance
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
ACCOUNT:
ACCOUNT NO. 22
SUTA TAXES PAYABLE – EMPLOYER
DATE
ITEM
POST.
REF.
BALANCE
DEBIT
CREDIT
DEBIT
CREDIT
20–
Oct.
9
23
J41
J42
Checkpoints
Debit
Balance
176.26
176.26
176.26
352.52
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20–
Credit
Balance
ACCOUNT:
ACCOUNT NO. 24
EMPLOYEES FIT PAYABLE
DATE
ITEM
POST.
REF.
BALANCE
DEBIT
CREDIT
DEBIT
CREDIT
20–
Oct.
9
23
J41
J42
Checkpoints
Debit
Balance
882.00
914.00
882.00
1,796.00
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20–
Credit
Balance
ACCOUNT:
ACCOUNT NO. 25
EMPLOYEES SIT PAYABLE
DATE
ITEM
POST.
REF.
BALANCE
DEBIT
CREDIT
DEBIT
CREDIT
20–
Oct.
Nov
9
20
23
4
J41
J41
J42
J42
Checkpoints
Debit
Balance
474.55
474.55
484.42
484.42
474.55
0.00
484.42
0.00
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20–
Credit
Balance
484.42
ACCOUNT:
ACCOUNT NO. 25.1
EMPLOYEES SUTA PAYABLE
DATE
ITEM
POST.
REF.
BALANCE
DEBIT
CREDIT
DEBIT
CREDIT
20–
Oct.
9
23
J41
J42
Checkpoints
Debit
Balance
9.25
9.45
9.25
18.70
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20–
Credit
Balance
ACCOUNT:
ACCOUNT NO. 26
EMPLOYEES CIT PAYABLE
DATE
ITEM
POST.
REF.
BALANCE
DEBIT
CREDIT
DEBIT
CREDIT
20–
Oct.
9
23
J41
J42
Checkpoints
Debit
Balance
601.39
613.90
601.39
1,215.29
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20–
Credit
Balance
ACCOUNT:
DATE
20–
ACCOUNT NO. 27
GROUP INSURANCE PREMIUMS COLLECTED
ITEM
POST.
REF.
Checkpoints
Debit
Balance
BALANCE
DEBIT
CREDIT
DEBIT
CREDIT
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20–
Credit
Balance
ACCOUNT:
ACCOUNT NO. 28
UNION DUES PAYABLE
DATE
ITEM
POST.
REF.
Checkpoints
Debit
Balance
BALANCE
DEBIT
CREDIT
DEBIT
CREDIT
20–
Oct.
Nov
9
23
4
J41
J42
16.00
16.00
32.00
16.00
32.00
0.00
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20–
Credit
Balance
ACCOUNT:
DATE
20–
ACCOUNT NO. 29
SIMPLE CONTRIBUTIONS PAYABLE
ITEM
POST.
REF.
Checkpoints
Debit
Balance
BALANCE
DEBIT
CREDIT
DEBIT
CREDIT
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20–
Credit
Balance
ACCOUNT:
ACCOUNT NO. 51
ADMINISTRATIVE SALARIES
DATE
ITEM
POST.
REF.
BALANCE
DEBIT
CREDIT
DEBIT
20–
Oct.
1 Balance
9
23
a
J41
J42
Checkpoints
Debit
Balance
2,307.69
2,307.69
42,692.27
44,999.96
47,307.65
CREDIT
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20–
Credit
Balance
ACCOUNT:
ACCOUNT NO. 52
OFFICE SALARIES
DATE
ITEM
POST.
REF.
BALANCE
DEBIT
CREDIT
DEBIT
20–
Oct.
1 Balance
9
23
a
J41
J42
Checkpoints
Debit
Balance
4,651.08
4,651.08
28,350.00
33,001.08
37,652.16
CREDIT
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20–
Credit
Balance
ACCOUNT:
ACCOUNT NO. 53
SALES SALARIES
DATE
ITEM
POST.
REF.
BALANCE
DEBIT
CREDIT
DEBIT
20–
Oct.
1 Balance
9
23
a
J41
J42
Checkpoints
Debit
Balance
3,600.00
3,600.00
28,525.00
32,125.00
35,725.00
CREDIT
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20–
Credit
Balance
ACCOUNT:
ACCOUNT NO. 54
PLANT WAGES
DATE
ITEM
POST.
REF.
BALANCE
DEBIT
CREDIT
DEBIT
20–
Oct.
1 Balance
9
23
a
J41
J42
Checkpoints
Debit
Balance
4,898.00
5,219.60
42,657.30
47,555.30
52,774.90
CREDIT
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20–
Credit
Balance
ACCOUNT:
ACCOUNT NO. 56
PAYROLL TAXES
DATE
ITEM
POST.
REF.
BALANCE
DEBIT
CREDIT
DEBIT
20–
Oct.
1 Balance
9
a
J41
J42
Checkpoints
Debit
Balance
1,381.61
1,387.47
14,353.07
15,734.68
17,122.15
CREDIT
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20–
Credit
Balance
Payday, October 9, 20-Bonno, A.
Ferguson, J.
Ford, C.
Mann, D.
O’Neill, J.
Russell, V.
Ryan, N.
Sokowski, T.
(Student)
Williams, R.
No. W/H Allow.
NAME
Marital Status
PAYROLL REGISTER
Time Record
S M T W T
GLO-BRITE PAINT COMPANY
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
4 8 8 8 8
Mann, D.
M 4
8 8 8 8 8
O’Neill, J.
M 3
8 8 8 8 8
Russell, V.
S 1
8 8 8 8 8
Ryan, N.
M 4
8 8 8 8 8
Sokowski, T.
M 2
8 8 8 8 8
(Student)
S 1
8 8 8 8 4
Williams, R.
S 0
8 8 8 8 8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
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
84 17.60
80
80
80
80
80
88 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
TOTALS
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
4
8
80
80
80
80
80
78
80
80
72
79
17.60
15.00
18.00
14.00
15.29
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
33.00
107.00
85.00
27.00
152.00
102.00
35.00
140.00
78.00
123.00
43.23
69.08
37.45
41.45
70.85
36.84
44.21
62.94
30.95
37.55
0.84
1.35
0.73
0.81
1.38
0.72
0.86
1.23
0.60
0.73
15,456.77
15,456.77
958.33
224.14
882.00
474.55
9.25
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
43.00
107.00
85.00
27.00
152.00
102.00
57.00
140.00
78.00
123.00
46.47
69.08
37.45
41.45
70.85
36.84
50.84
62.94
30.95
37.55
0.91
1.35
0.73
0.81
1.38
0.72
0.99
1.23
0.60
0.73
15,778.37
978.26
228.80
914.00
484.42
9.45
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.91
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.91
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
43.23
69.08
37.45
41.45
70.85
35.92
44.21
62.94
30.95
37.08
0.84
1.35
0.73
0.81
1.38
0.70
0.86
1.23
0.60
0.72
15,411.60
15,411.60
955.53
223.49
0.00
473.16
9.22
0.00
0.00
0.00
0.00
0.00
0.00
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
8
8
8
8
8
8
8
8
8
8
Overtime Earnings
4 26.40
105.60
8 27.00
216.00
321.60
Payday, November 13, 20– For Period Ending November 14, 20-Williams, R.
S 0
TOTALS
No. W/H Allow.
NAME
Marital Status
PAYROLL REGISTER
Time Record
S M T W T
GLO-BRITE PAINT COMPANY
Regular Earnings
Rate
Per
F S S M T W T F S Hrs. Hour
Amount
Overtime Earnings
Rate
Per
Hrs. Hour
Amount
Deductions
Total
Earnings
OASDI
HI
FIT
SIT
SUTA
Payday, November 20, 20– For Period Ending November 14, 20-Bonno, A.
M 4
Ferguson, J.
M 5
Ford, C.
S 2
Mann, D.
M 4
O’Neill, J.
M 3
Russell, V.
S 1
Ryan, N.
M 4
Sokowski, T.
M 2
(Student)
S 1
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
0.00
0.00
0.00
0.00
0.00
1,796.00 1,432.13
17,713.00 5,798.42
27.92
113.26
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
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
46,646.74 2,892.12
676.43
188,871.31 11,710.04 2,738.70
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
672
673
674
675
676
677
678
679
680
681
0.00
613.90
0.00
16.00
682
683
684
685
686
687
688
689
690
691
0.00
599.63
0.00
16.00
HI
FUTA
SUTA
Admin.
Office
Sales
Plant
1,160.43
1,812.90
956.02
1,124.94
1,817.13
921.95
1,185.74
1,609.24
782.11
920.65
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,291.11
15,456.77
15,456.77
1,240.54
1,812.90
956.02
1,124.94
1,817.13
921.95
1,348.06
1,609.24
782.11
920.65
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,533.54
15,778.37
15,778.37
1,193.43
1,919.90
1,041.02
1,151.94
1,969.13
998.35
1,220.74
1,749.24
860.11
1,030.71
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.91
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.91
13,134.57
15,411.60
15,411.60
1,408.00
2,250.00
700.00
1,350.00
1,220.00
1,350.00
1,220.00
1,350.00
2,307.69
760.00
1,200.00
1,200.00
1,440.00
2,050.00
1,008.00
1,008.00
3,818.00
4,778.00
1,008.00
1,223.08
2,307.69
4,651.08
3,600.00
4,898.00
1,513.60
2,250.00
250.00
1,220.00
1,350.00
0.00
0.00
0.00
Total earnings
Net paid
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
692
693
694
695
696
697
698
699
670
671
0.00
1,408.60
2,250.00
40.00
550.00
0.00
Total earnings
Net paid
1,220.00
1,350.00
2,307.69
190.00
1,170.00
1,440.00
2,050.00
1,008.00
0.00
1,788.00
1,008.00
1,207.91
2,307.69
4,605.91
3,600.00
4,898.60
Checkpoints
Payday, November 13, 20– For Period Ending November 14, 20-Williams, R.
TOTALS
Total earnings
Net paid
Checkpoints
Payday, November 6, 20– For Period Ending October 31, 20-Bonno, A.
54.78
8.00
Ferguson, J.
87.54
Ford, C.
47.47
Mann, D.
52.52
O’Neill, J.
89.79
Russell, V.
45.52
Ryan, N.
56.03
8.00
Sokowski, T.
79.76
(Student)
39.22
Williams, R.
47.00
TOTALS
OASDI
Checkpoints
Payday, October 23, 20– For Period Ending October 17, 20-Bonno, A.
58.89
8.00
Ferguson, J.
87.54
Ford, C.
47.47
Mann, D.
52.52
O’Neill, J.
89.79
Russell, V.
46.69
Ryan, N.
64.43
8.00
Sokowski, T.
79.76
(Student)
39.22
Williams, R.
47.59
TOTALS
Amount
Labor Cost Distribution
Checkpoints
For Period Ending October 3, 20-54.78
8.00
87.54
47.47
52.52
89.79
46.69
56.03
8.00
79.76
39.22
47.59
601.39
Ck.
No.
Taxable Earnings
Total earnings
Net paid
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
15,456.77
12,291.11
Deductions
NAME
Net Paid
CIT
Group
Ins.
Union
Dues
SIMPLE
Ck.
No.
Taxable Earnings
Amount
OASDI
HI
FUTA
Labor Cost Distribution
SUTA
Admin.
Office
Sales
Plant
Checkpoints
October 9, 20,
20–20–For
3, 20-Payday, November
ForPeriod
PeriodEnding
EndingOctober
November
14, 20-Bonno, A.
Ferguson, J.
Ford, C.
Mann, D.
O’Neill, J.
Russell, V.
Ryan, N.
Sokowski, T.
(Student)
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 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
1,814.92
7,348.45
0.00
0.00
0.00 48.00
930.40 192.00
0.00
0.00
0.00
Total earnings
Net paid
0.00
0.00
0.00
0.00
37,959.22 46,646.74 46,646.74
4,510.00
142,327.04 188,871.31 188,871.31 70,000.00
0.00
11,344.00
94,834.00
0.00
0.00
0.00
0.00
6,923.07 13,908.07 10,800.00 15,016.20
49,615.34 42,258.07 39,325.00 57,673.50
Checkpoints-Annual
Total earnings
Qtr’s taxable OASDI earnings
Total earnings for FIT
Total earnings for SIT/CIT
Total earnings for FUTA
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
17.60
17.60
17.60
AMOUNT
OVERTIME EARNINGS
HRS. RATE
10,293.40
1,408.00
1,408.00
1,408.00
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
MIDDLE
Victor
17.60
26.40
W/H
MARITAL
ALLOW.
STATUS
4
M
DEDUCTIONS
FICA
OASDI
701.96
87.30
93.84
87.30
HI
164.17
20.42
21.95
20.42
FIT
SIT
810.00
33.00
43.00
347.59
43.23
46.47
43.23
NET PAID
SUTA
CIT
6.79
0.84
0.91
0.84
SIMPLE
440.51
54.78
58.89
54.78
OTHER
CK.
DEDUCTIONS NO.
216.80
8.00
8.00
AMOUNT
8,634.18
1,160.43
1,240.54
1,201.43
672
682
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
OVERTI …
Purchase answer to see full
attachment
