Budget Performance Report
Budget Performance Report Fiscal Year to Date 12/31/16 Exclude Rollup Account
Account
Account Description
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Budget - YTD % Used/ Transactions
Rec'd
Prior Year Total
Fund 01 - General Fund REVENUE 0400.401
Property Tax Revenue
3,162,500.00
.00
3,162,500.00
27,973.89
.00
3,186,939.65
(24,439.65)
101
3,254,992.57
0400.402
Property Tax Rev-Road & Bridge
375,000.00
.00
375,000.00
3,449.22
.00
357,161.29
17,838.71
95
385,492.10
0400.403
Property Tax Rev-Police Pension
1,100,000.00
.00
1,100,000.00
9,668.47
.00
1,101,142.15
(1,142.15)
100
948,548.76
0400.404
Property Tax Revenue-IMRF
575,000.00
.00
575,000.00
5,053.17
.00
575,655.27
(655.27)
100
575,525.65
0450.450
Home Rule Sales Tax
500,000.00
.00
500,000.00
50,948.81
.00
500,000.00
.00
100
.00
0450.451
Municipal Sales Tax
5,298,300.00
.00
5,298,300.00
426,737.24
.00
3,511,119.77
1,787,180.23
66
5,280,661.07
0450.452
Illinois Income Tax
3,320,000.00
.00
3,320,000.00
346,191.27
.00
2,591,773.41
728,226.59
78
4,218,243.70
0450.453
Replacement Tax
45,000.00
.00
45,000.00
2,063.04
.00
30,324.19
14,675.81
67
48,179.55
0450.455
Local Use Tax
775,000.00
.00
775,000.00
76,212.10
.00
605,403.04
169,596.96
78
918,416.43
0500.501
Amusement Tax
0500.503
Local Motor Fuel Tax
0550.551 0550.552 0550.553
Cigarette License
0550.554
Scavenger License
0550.558
Business License
0570.555
Building Permit
0570.556
Sign Permit
0570.557
5,000.00
.00
5,000.00
136.81
.00
4,709.30
290.70
94
7,581.85
850,000.00
.00
850,000.00
81,261.70
.00
617,817.14
232,182.86
73
897,403.82
Liquor License
90,000.00
.00
90,000.00
742.10
.00
100,253.05
(10,253.05)
111
91,455.26
Contractors License
35,000.00
.00
35,000.00
2,600.00
.00
31,250.00
3,750.00
89
48,000.00
5,000.00
.00
5,000.00
.00
.00
7,000.00
(2,000.00)
140
6,500.00
200.00
.00
200.00
.00
.00
100.00
100.00
50
100.00
30,000.00
.00
30,000.00
11,100.00
.00
29,763.00
237.00
99
35,125.00
850,000.00
.00
850,000.00
72,971.31
.00
702,615.64
147,384.36
83
983,447.97
5,000.00
.00
5,000.00
594.00
.00
4,655.00
345.00
93
4,442.00
Special Movement Permit
3,000.00
.00
3,000.00
390.00
.00
5,225.00
(2,225.00)
174
6,410.00
0570.560
Solicitors Permit
1,300.00
.00
1,300.00
35.00
.00
840.00
460.00
65
1,575.00
0600.601
Will County Court Fines
310,000.00
.00
310,000.00
21,296.98
.00
271,327.21
38,672.79
88
332,692.07
0600.602
Administrative Fines(P-Tickets)
150,000.00
.00
150,000.00
11,035.00
.00
92,800.05
57,199.95
62
139,091.06
0600.603
Asset Seizure-Non Federal
180,000.00
.00
180,000.00
.00
.00
94,171.49
85,828.51
52
80,128.29
0600.604
Alarm Fees
7,000.00
.00
7,000.00
(250.00)
.00
1,850.00
5,150.00
26
11,350.00
0600.605
Kendall County Court Fines
500.00
.00
500.00
153.29
.00
747.58
(247.58)
150
1,190.73
0600.607
Administrative Fines- Late Fee
10,000.00
.00
10,000.00
940.00
.00
6,210.00
3,790.00
62
14,985.00
0600.610
Alcohol Fines
100.00
.00
100.00
.00
.00
.00
100.00
0
.00
0600.630
Asset Seizure-Federal (Dept of Justice Equitable Share)
.00
.00
.00
.00
.00
40,962.12
(40,962.12)
+++
52,536.77
0620.655
Garbage Fee
3,840,000.00
.00
3,840,000.00
339,960.98
.00
2,976,427.94
863,572.06
78
3,621,236.53
0620.656
Garbage Penalties
45,000.00
.00
45,000.00
4,861.96
.00
37,402.24
7,597.76
83
51,025.10
0640.500
Engineering Services
15,000.00
.00
15,000.00
15,335.55
.00
33,590.05
(18,590.05)
224
25,782.07
0650.580
Child Safety Seats
100.00
.00
100.00
.00
.00
.00
100.00
0
.00
0650.651
Zoning Applications
10,000.00
.00
10,000.00
2,305.00
.00
9,420.00
580.00
94
23,187.00
0650.653
Accident Report Fees
4,000.00
.00
4,000.00
345.00
.00
2,730.00
1,270.00
68
4,490.00
0650.654
Copies-Maps & Ordinances
3,000.00
.00
3,000.00
245.00
.00
1,591.40
1,408.60
53
2,904.40
0650.670
Impound Fee
30,000.00
.00
30,000.00
1,250.00
.00
15,602.50
14,397.50
52
31,037.50
0650.815
Parking Lot Revenue
1,000.00
.00
1,000.00
.00
.00
1,732.00
(732.00)
173
4,550.00
0650.818
Tower Rent
39,172.00
.00
39,172.00
3,308.31
.00
26,466.48
12,705.52
68
39,783.66
0650.825
Rental Income
49,200.00
.00
49,200.00
2,100.00
.00
30,800.00
18,400.00
63
53,300.00
Run by Traci Pleckham on 01/19/2017 02:03:02 PM
Page 1 of 14
Budget Performance Report Fiscal Year to Date 12/31/16 Exclude Rollup Account
Account
Account Description
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Budget - YTD % Used/ Transactions
Rec'd
Prior Year Total
Fund 01 - General Fund REVENUE 0650.830
Rental-Community/Multi Room
0650.904
Special Detail/OT Reimbursement
3,000.00
.00
3,000.00
915.00
.00
2,931.75
68.25
98
5,217.50
40,000.00
.00
40,000.00
3,700.00
.00
56,491.43
(16,491.43)
141
49,402.83
0690.902
Water & Sewer Service Charge
0700.704
Bulletproof Vest Grant
250,000.00
.00
250,000.00
.00
.00
.00
250,000.00
0
250,000.00
3,000.00
.00
3,000.00
.00
.00
.00
3,000.00
0
0700.710
Tobacco Grant
6,851.33
2,600.00
.00
2,600.00
.00
.00
5,500.00
(2,900.00)
212
0700.717
Traffic Grant
2,750.00
30,000.00
.00
30,000.00
9,447.47
.00
29,431.46
568.54
98
30,741.70
0750.750 0750.751
AT&T Franchise Fees
250,000.00
.00
250,000.00
794.20
.00
168,152.91
81,847.09
67
260,501.76
Cable TV-Franchise Fees
450,000.00
.00
450,000.00
.00
.00
395,237.00
54,763.00
88
0800.800
Interest Income
490,849.89
15,000.00
.00
15,000.00
4,051.78
.00
45,507.33
(30,507.33)
303
0800.827
Unrealized Gain/Loss
35,784.97
.00
.00
.00
(1,415.47)
.00
(10,844.96)
10,844.96
+++
(2,163.24)
0800.830
Unrealized Gain/Loss IMET
0801.200
Event Sponsorship Program
0801.801
Reimbursement Police Training
0801.802
Amphitheater Rent
0801.807
Restitution Program
0801.812
Step-Basset Program
0801.822
Donation/Contribution
0803.000
Sales-Fixed Assets
0805.000
Other Reimbursements
0806.000
Other Receipts
0840.001
Liability Write off
0860.804 0860.819 0999.904
.00
.00
.00
766.01
.00
(2,204.51)
2,204.51
+++
8,280.84
4,000.00
.00
4,000.00
.00
.00
3,096.76
903.24
77
4,411.00
.00
.00
.00
.00
.00
.00
.00
+++
585.00
500.00
.00
500.00
50.00
.00
(50.00)
550.00
-10
500.00
.00
.00
.00
.00
.00
.00
.00
+++
500.00
500.00
.00
500.00
.00
.00
.00
500.00
0
.00
10,000.00
.00
10,000.00
9,771.98
.00
10,478.98
(478.98)
105
17,847.76
5,000.00
.00
5,000.00
.00
.00
2,694.00
2,306.00
54
.00
95,000.00
.00
95,000.00
3,002.00
.00
61,202.80
33,797.20
64
72,703.21
25,000.00
.00
25,000.00
620.00
.00
7,314.79
17,685.21
29
27,912.58
.00
.00
.00
.00
.00
.00
.00
+++
201,503.00
School Liaison Reimbursement
400,000.00
.00
400,000.00
.00
.00
218,177.67
181,822.33
55
411,490.22
HIDTA/Organized Crime Reimb
10,000.00
.00
10,000.00
.00
.00
8,546.27
1,453.73
85
13,379.06
Transfer From MFT
200,000.00
.00
200,000.00
.00
.00
.00
200,000.00
0
.00
0999.917
Transfer From TIF
50,000.00
.00
50,000.00
.00
.00
.00
50,000.00
0
50,000.00
0999.927
Transfer From Alcohol Enforc.
12,000.00
.00
12,000.00
.00
.00
.00
12,000.00
0
12,000.00
REVENUE TOTALS
$23,574,972.00
$0.00
$23,574,972.00
$1,552,718.17
$0.00
$18,609,241.64
$4,965,730.36
79%
$24,152,420.32
.00
.00
.00
.00
.00
.00
.00
+++
30,764.02
Division 94 - Contra Totals
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+++
$30,764.02
Unit 00 - Non-Departmental Totals
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+++
$30,764.02
3,452,192.00
.00
3,452,192.00
303,525.28
.00
2,116,098.18
1,336,093.82
61
3,342,144.98
.00
.00
.00
806.80
.00
806.80
(806.80)
+++
.00
$3,452,192.00
$0.00
$3,452,192.00
$304,332.08
$0.00
$2,116,904.98
$1,335,287.02
61%
$3,342,144.98
EXPENSE Unit 00 - Non-Departmental Division 94 - Contra 2020.001
Contra Insurance Account
Unit 04 - Administration/Finance Division 00 - Non-Divisional 8100
Fees to Refuse Hauler
9997
Bad Debt Expense Division 00 - Non-Divisional Totals
Run by Traci Pleckham on 01/19/2017 02:03:02 PM
Page 2 of 14
Budget Performance Report Fiscal Year to Date 12/31/16 Exclude Rollup Account
Account
Account Description
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Budget - YTD % Used/ Transactions
Rec'd
Prior Year Total
Fund 01 - General Fund EXPENSE Unit 04 - Administration/Finance Division 01 - Legislative Program 1000
Salaries-President
20,000.00
.00
20,000.00
1,666.67
.00
13,333.36
6,666.64
67
20,000.04
1002
Salaries-Elected Officials
25,000.00
.00
25,000.00
2,200.00
.00
16,800.00
8,200.00
67
21,700.00
1003
Salaries-Liquor Commissioner
1,500.00
.00
1,500.00
125.00
.00
1,000.00
500.00
67
1,500.00
1004
Salaries-Treasurer
2,500.00
.00
2,500.00
208.33
.00
1,666.64
833.36
67
2,499.96
2000
FICA
3,000.00
.00
3,000.00
241.86
.00
1,887.78
1,112.22
63
2,615.58
2001
Medicare
700.00
.00
700.00
56.56
.00
441.49
258.51
63
611.72
2010
IMRF
850.00
.00
850.00
67.50
.00
596.25
253.75
70
769.40
2020
Employee Insurance
150.00
.00
150.00
8.40
.00
65.10
84.90
43
98.70
3000
Travel/Training
10,000.00
.00
10,000.00
.00
.00
3,538.47
6,461.53
35
5,305.83
5010
Replacement Supplies
3,000.00
.00
3,000.00
.00
.00
.00
3,000.00
0
.00
5015
Dues & Subscriptions
35,000.00
.00
35,000.00
2,575.00
4,800.00
14,916.15
15,283.85
56
33,896.37
8070
Public Relations
150,000.00
.00
150,000.00
8,418.82
.00
61,181.75
88,818.25
41
56,241.64
8074
Cable TV
20,000.00
.00
20,000.00
3,480.00
8,705.00
13,055.00
(1,760.00)
109
13.33
8078
Economic Incentive Rebate
335,000.00
.00
335,000.00
.00
.00
.00
335,000.00
0
298,677.67
$606,700.00
$0.00
$606,700.00
$19,048.14
$13,505.00
$128,481.99
$464,713.01
23%
$443,930.24
Division 01 - Legislative Program Totals Division 02 - Administration Program 1005
Salaries-Full Time
679,926.00
.00
679,926.00
78,337.68
.00
473,364.96
206,561.04
70
666,169.43
1015
Salaries-Part Time
50,000.00
.00
50,000.00
4,296.54
.00
29,568.51
20,431.49
59
41,519.42
1800
Salaries-Overtime
1,500.00
.00
1,500.00
6.70
.00
190.67
1,309.33
13
372.34
2000
FICA
45,348.00
.00
45,348.00
2,985.53
.00
25,904.58
19,443.42
57
40,327.20
2001
Medicare
10,606.00
.00
10,606.00
1,189.09
.00
7,228.94
3,377.06
68
10,239.18
2010
IMRF
84,114.00
.00
84,114.00
9,257.85
.00
56,573.13
27,540.87
67
74,515.12
2020
Employee Insurance
105,852.00
.00
105,852.00
12,194.84
.00
73,704.78
32,147.22
70
97,625.93
2025
Deferred Comp. Contribution
24,000.00
.00
24,000.00
.00
.00
.00
24,000.00
0
22,438.03
3000
Travel/Training
15,000.00
.00
15,000.00
.00
.00
7,194.10
7,805.90
48
11,507.37
3015
IL Unemployment Insurance
7,000.00
.00
7,000.00
.00
.00
1,656.82
5,343.18
24
3,372.29
4000
Telephone/Internet
5,000.00
.00
5,000.00
365.54
.00
2,419.10
2,580.90
48
3,495.94
4005
Cellular Phones/Pagers
2,000.00
.00
2,000.00
179.32
.00
1,760.16
239.84
88
2,112.67
5005
Office Supplies/Postage
30,000.00
.00
30,000.00
2,228.44
.00
19,467.91
10,532.09
65
32,692.34
5015
Dues & Subscriptions
5,000.00
.00
5,000.00
320.00
.00
3,157.00
1,843.00
63
3,277.25
5020
Gas/Oil/Mileage/Carwash
9,500.00
.00
9,500.00
751.29
.00
5,505.34
3,994.66
58
7,703.90
8035
Maintenance Contracts/Lease
8,000.00
.00
8,000.00
1,318.00
.00
5,272.00
2,728.00
66
8,490.94
8045
Recording Fees
2,500.00
.00
2,500.00
38.75
.00
832.74
1,667.26
33
254.16
8050
Legal Notices
2,500.00
.00
2,500.00
236.50
.00
1,546.53
953.47
62
1,451.78
8065
Legal Fees
60,000.00
.00
60,000.00
.00
.00
20,419.25
39,580.75
34
33,700.86
8070
Public Relations
.00
.00
.00
.00
.00
201.66
(201.66)
+++
55.93
8135
Contractual Services
70,000.00
.00
70,000.00
12,754.39
.00
61,099.00
8,901.00
87
87,886.44
Run by Traci Pleckham on 01/19/2017 02:03:02 PM
Page 3 of 14
Budget Performance Report Fiscal Year to Date 12/31/16 Exclude Rollup Account
Account
Account Description
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Budget - YTD % Used/ Transactions
Rec'd
Prior Year Total
1,800.00
Fund 01 - General Fund EXPENSE Unit 04 - Administration/Finance Division 02 - Administration Program 8135.007
Tribute Memorial
.00
.00
.00
.00
.00
.00
.00
+++
8225
Engineering Fees
5,000.00
.00
5,000.00
2,283.20
.00
2,283.20
2,716.80
46
.00
9115
Office Furniture & Equipment
5,000.00
.00
5,000.00
.00
.00
3,965.08
1,034.92
79
1,474.76
9300
Contingencies Division 02 - Administration Program Totals
50,000.00
.00
50,000.00
.00
.00
11,500.00
38,500.00
23
36,483.28
$1,277,846.00
$0.00
$1,277,846.00
$128,743.66
$0.00
$814,815.46
$463,030.54
64%
$1,188,966.56
Division 03 - Community Relations Program 1005
Salaries-Full Time
97,225.00
.00
97,225.00
11,167.17
.00
66,912.26
30,312.74
69
94,785.54
2000
FICA
6,028.00
.00
6,028.00
652.28
.00
3,822.18
2,205.82
63
5,676.90
2001
Medicare
1,410.00
.00
1,410.00
152.56
.00
893.91
516.09
63
1,327.65
2010
IMRF
11,181.00
.00
11,181.00
1,256.31
.00
7,550.15
3,630.85
68
10,914.66
2020
Employee Insurance
19,919.00
.00
19,919.00
2,265.76
.00
13,469.90
6,449.10
68
17,614.89
2025
Deferred Comp. Contribution
4,000.00
.00
4,000.00
.00
.00
.00
4,000.00
0
3,515.82
3000
Travel/Training
1,500.00
.00
1,500.00
25.00
.00
142.50
1,357.50
10
164.21
4000
Telephone/Internet
500.00
.00
500.00
36.55
.00
241.90
258.10
48
327.96
5005
Office Supplies/Postage
2,000.00
.00
2,000.00
.00
.00
10.56
1,989.44
1
41.90
5015
Dues & Subscriptions
750.00
.00
750.00
.00
.00
525.00
225.00
70
135.50
5020
Gas/Oil/Mileage/Carwash
100.00
.00
100.00
.00
.00
.00
100.00
0
.00
8030
Server/Network Supplies
6,500.00
.00
6,500.00
.00
.00
.00
6,500.00
0
.00
8070
Public Relations
17,000.00
.00
17,000.00
2,301.37
.00
7,137.68
9,862.32
42
7,565.32
8071
Marketing and Promotions
2,500.00
.00
2,500.00
.00
.00
.00
2,500.00
0
1,200.00
8072
Settler's Park
8,500.00
.00
8,500.00
.00
.00
3,789.03
4,710.97
45
5,640.99
8135
Contractual Services
2,500.00
.00
2,500.00
.00
.00
.00
2,500.00
0
.00
$181,613.00
$0.00
$181,613.00
$17,857.00
$0.00
$104,495.07
$77,117.93
58%
$148,911.34
Division 03 - Community Relations Program Totals Division 04 - Facility Management Program 1005
Salaries-Full Time
32,865.00
.00
32,865.00
3,791.94
.00
23,381.40
9,483.60
71
32,855.54
1800
Salaries-Overtime
2,500.00
.00
2,500.00
1,067.71
.00
2,552.73
(52.73)
102
2,836.21
2000
FICA
2,193.00
.00
2,193.00
293.92
.00
1,546.31
646.69
71
2,121.91
2001
Medicare
513.00
.00
513.00
68.74
.00
361.69
151.31
71
496.28
2010
IMRF
4,067.00
.00
4,067.00
546.73
.00
2,917.65
1,149.35
72
4,036.28
2020
Employee Insurance
9,465.00
.00
9,465.00
1,133.76
.00
6,633.07
2,831.93
70
8,561.16
5000
Building Maintenance Supplies
7,000.00
.00
7,000.00
823.38
.00
4,254.67
2,745.33
61
5,084.22
8020
Building Maintenance
.00
.00
.00
.00
.00
.00
.00
+++
2,191.48
8135
Contractual Services
50,000.00
.00
50,000.00
3,236.10
.00
18,869.35
31,130.65
38
38,551.67
9105
Building Improvements Division 04 - Facility Management Program Totals
40,000.00
.00
40,000.00
.00
.00
.00
40,000.00
0
52,995.07
$148,603.00
$0.00
$148,603.00
$10,962.28
$0.00
$60,516.87
$88,086.13
41%
$149,729.82
181,654.00
.00
181,654.00
8,662.31
.00
94,335.47
87,318.53
52
174,346.84
Division 06 - Human Resources Program 1005
Salaries-Full Time
Run by Traci Pleckham on 01/19/2017 02:03:02 PM
Page 4 of 14
Budget Performance Report Fiscal Year to Date 12/31/16 Exclude Rollup Account
Account
Account Description
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Budget - YTD % Used/ Transactions
Rec'd
Prior Year Total
Fund 01 - General Fund EXPENSE Unit 04 - Administration/Finance Division 06 - Human Resources Program 1800
Salaries-Overtime
2000
FICA
500.00
.00
500.00
.00
.00
.00
500.00
0
.00
11,294.00
.00
11,294.00
291.30
.00
5,482.67
5,811.33
49
10,842.78
2001
Medicare
2010
IMRF
2,641.00
.00
2,641.00
68.13
.00
1,282.24
1,358.76
49
2,535.81
20,948.00
.00
20,948.00
974.51
.00
10,657.75
10,290.25
51
20,427.46
2020
Employee Insurance
2025
Deferred Comp. Contribution
39,020.00
.00
39,020.00
1,621.33
.00
17,030.87
21,989.13
44
24,373.36
7,200.00
.00
7,200.00
.00
.00
.00
7,200.00
0
3000
6,707.22
Travel/Training
6,000.00
.00
6,000.00
.00
.00
735.86
5,264.14
12
2,237.50
4000
Telephone/Internet
1,000.00
.00
1,000.00
73.11
.00
483.83
516.17
48
671.58
4005
Cellular Phones/Pagers
360.00
.00
360.00
.00
.00
120.00
240.00
33
360.00
5005
Office Supplies/Postage
1,500.00
.00
1,500.00
136.24
.00
615.79
884.21
41
901.82
5015
Dues & Subscriptions
3,200.00
.00
3,200.00
.00
.00
15.00
3,185.00
0
944.00
5020
Gas/Oil/Mileage/Carwash
1,400.00
.00
1,400.00
.00
.00
281.88
1,118.12
20
1,162.55
8070
Public Relations
12,000.00
.00
12,000.00
.00
.00
9,155.40
2,844.60
76
11,360.06
8071
Marketing and Promotions
300.00
.00
300.00
.00
.00
.00
300.00
0
.00
8135
Contractual Services
8,000.00
.00
8,000.00
1,622.50
.00
4,770.34
3,229.66
60
5,188.33
$297,017.00
$0.00
$297,017.00
$13,449.43
$0.00
$144,967.10
$152,049.90
49%
$262,059.31 221,230.80
Division 06 - Human Resources Program Totals Division 08 - IT Program 1005
Salaries-Full Time
223,829.00
.00
223,829.00
25,143.66
.00
153,126.29
70,702.71
68
1800
Salaries-Overtime
500.00
.00
500.00
.00
.00
178.60
321.40
36
.00
2000
FICA
13,877.00
.00
13,877.00
1,534.91
.00
9,293.65
4,583.35
67
13,385.87
2001
Medicare
3,246.00
.00
3,246.00
358.98
.00
2,173.52
1,072.48
67
3,130.55
2010
IMRF
25,740.00
.00
25,740.00
2,828.67
.00
17,246.86
8,493.14
67
25,241.42
2020
Employee Insurance
56,770.00
.00
56,770.00
4,729.71
.00
28,709.78
28,060.22
51
47,259.93
2025
Deferred Comp. Contribution
7,000.00
.00
7,000.00
.00
.00
.00
7,000.00
0
3,626.80
3000
Travel/Training
27,500.00
.00
27,500.00
436.80
13,760.00
4,388.81
9,351.19
66
8,995.30
4000
Telephone/Internet
500.00
.00
500.00
36.55
.00
241.89
258.11
48
327.96
4005
Cellular Phones/Pagers
1,840.00
.00
1,840.00
172.67
.00
1,202.79
637.21
65
2,084.58
5005
Office Supplies/Postage
1,400.00
.00
1,400.00
279.32
.00
474.70
925.30
34
923.54
5015
Dues & Subscriptions
400.00
.00
400.00
.00
.00
454.19
(54.19)
114
553.52
5020
Gas/Oil/Mileage/Carwash
400.00
.00
400.00
.00
.00
163.62
236.38
41
49.68
5095
Uniforms/Clothing
300.00
.00
300.00
.00
.00
.00
300.00
0
702.92
8030
Server/Network Supplies
8031
Software Licensing/Renewals
8135
Contractual Services
9111
Computers Division 08 - IT Program Totals
Run by Traci Pleckham on 01/19/2017 02:03:02 PM
32,850.00
.00
32,850.00
267.50
792.82
52,845.88
(20,788.70)
163
39,043.87
205,800.00
.00
205,800.00
26,983.55
16,283.56
208,445.49
(18,929.05)
109
191,734.01 12,761.10
8,550.00
.00
8,550.00
.00
.00
5,714.63
2,835.37
67
12,000.00
.00
12,000.00
.00
.00
2,377.52
9,622.48
20
11,069.74
$622,502.00
$0.00
$622,502.00
$62,772.32
$30,836.38
$487,038.22
$104,627.40
83%
$582,121.59
Page 5 of 14
Budget Performance Report Fiscal Year to Date 12/31/16 Exclude Rollup Account
Account
Account Description
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Budget - YTD % Used/ Transactions
Rec'd
Prior Year Total
Fund 01 - General Fund EXPENSE Unit 04 - Administration/Finance Division 99 - Transfers 9911
Transfer to Capital Improvements
.00
.00
.00
.00
.00
.00
.00
+++
2,378,289.00
Division 99 - Transfers Totals
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+++
$2,378,289.00
Unit 04 - Administration/Finance Totals
$6,586,473.00
$0.00
$6,586,473.00
$557,164.91
$44,341.38
$3,857,219.69
$2,684,911.93
59%
$8,496,152.84
Unit 05 - Police Department Division 02 - Administration Program 1005
Salaries-Full Time
293,527.00
.00
293,527.00
33,868.64
.00
205,476.16
88,050.84
70
291,464.17
1015
Salaries-Part Time
32,693.00
.00
32,693.00
1,891.76
.00
14,232.36
18,460.64
44
31,267.99
1800
Salaries-Overtime
3,500.00
.00
3,500.00
54.70
.00
797.03
2,702.97
23
978.28
2000
FICA
20,443.00
.00
20,443.00
1,273.74
.00
12,279.00
8,164.00
60
18,788.43
2001
Medicare
4,781.00
.00
4,781.00
506.07
.00
3,079.86
1,701.14
64
4,543.88
2010
IMRF
23,718.00
.00
23,718.00
2,314.89
.00
14,267.07
9,450.93
60
21,602.00
2020
Employee Insurance
65,734.00
.00
65,734.00
7,173.92
.00
43,406.93
22,327.07
66
61,577.18
2025
Deferred Comp. Contribution
8,000.00
.00
8,000.00
.00
.00
.00
8,000.00
0
7,601.11
3000
Travel/Training
10,150.00
.00
10,150.00
36.00
.00
2,550.36
7,599.64
25
5,022.79
3001
Education/School
12,000.00
.00
12,000.00
.00
.00
.00
12,000.00
0
2,000.00
3015
IL Unemployment Insurance
23,000.00
.00
23,000.00
.00
.00
7,977.50
15,022.50
35
17,243.86
4000
Telephone/Internet
1,610.00
.00
1,610.00
117.54
.00
791.42
818.58
49
1,082.45
4005
Cellular Phones/Pagers
1,200.00
.00
1,200.00
186.67
.00
701.82
498.18
58
1,117.11
5005
Office Supplies/Postage
11,950.00
.00
11,950.00
617.53
.00
3,228.79
8,721.21
27
5,103.38
5010
Replacement Supplies
1,700.00
.00
1,700.00
295.52
.00
(60.05)
1,760.05
-4
1,095.70
5015
Dues & Subscriptions
7,050.00
.00
7,050.00
.00
.00
2,980.00
4,070.00
42
4,280.00
5020
Gas/Oil/Mileage/Carwash
3,700.00
.00
3,700.00
155.52
.00
1,054.96
2,645.04
29
1,126.92
5095
Uniforms/Clothing
1,800.00
.00
1,800.00
579.08
.00
1,068.13
731.87
59
1,601.20
8035
Maintenance Contracts/Lease
7,190.00
.00
7,190.00
1,132.00
.00
4,152.00
3,038.00
58
6,104.15
8040
Custodian
70,000.00
.00
70,000.00
2,521.91
.00
24,151.54
45,848.46
35
78,776.98
8060
Vehicle Maintenance
2,500.00
.00
2,500.00
.00
.00
105.70
2,394.30
4
316.29
8135
Contractual Services
8,000.00
.00
8,000.00
501.00
.00
1,312.93
6,687.07
16
5,563.84
$614,246.00
$0.00
$614,246.00
$53,226.49
$0.00
$343,553.51
$270,692.49
56%
$568,257.71
Division 02 - Administration Program Totals Division 51 - Police Operations 1005
Salaries-Full Time
3,442,372.00
.00
3,442,372.00
393,506.20
.00
2,304,233.26
1,138,138.74
67
3,124,053.52
1800
Salaries-Overtime
380,000.00
.00
380,000.00
42,915.74
.00
195,575.27
184,424.73
51
376,622.49
2000
FICA
237,700.00
.00
237,700.00
24,482.73
.00
146,386.19
91,313.81
62
202,400.77
2001
Medicare
55,591.00
.00
55,591.00
6,230.93
.00
34,981.88
20,609.12
63
48,109.13
2010
IMRF
6,720.00
.00
6,720.00
726.93
.00
4,378.16
2,341.84
65
6,234.94
2011
Employer Pension Contributions
1,100,000.00
.00
1,100,000.00
9,668.47
.00
1,101,142.15
(1,142.15)
100
948,548.76
2020
Employee Insurance
579,738.00
.00
579,738.00
62,239.34
.00
367,973.67
211,764.33
63
512,322.55
2025
Deferred Comp. Contribution
85,000.00
.00
85,000.00
.00
.00
.00
85,000.00
0
80,676.15
Run by Traci Pleckham on 01/19/2017 02:03:02 PM
Page 6 of 14
Budget Performance Report Fiscal Year to Date 12/31/16 Exclude Rollup Account
Account
Account Description
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Budget - YTD % Used/ Transactions
Rec'd
Prior Year Total
Fund 01 - General Fund EXPENSE Unit 05 - Police Department Division 51 - Police Operations 3000
Travel/Training
48,916.00
.00
48,916.00
151.00
.00
20,635.06
28,280.94
42
39,387.80
4000
Telephone/Internet
29,070.00
.00
29,070.00
2,635.35
.00
15,606.41
13,463.59
54
24,054.83
4005
Cellular Phones/Pagers
6,300.00
.00
6,300.00
434.74
.00
3,086.94
3,213.06
49
5,791.88
5005
Office Supplies/Postage
13,000.00
.00
13,000.00
2,181.90
.00
7,017.85
5,982.15
54
11,384.89
5010
Replacement Supplies
15,500.00
.00
15,500.00
.00
.00
6,185.75
9,314.25
40
13,264.77
5015
Dues & Subscriptions
2,900.00
.00
2,900.00
.00
.00
929.00
1,971.00
32
1,893.00
5020
Gas/Oil/Mileage/Carwash
110,000.00
.00
110,000.00
5,738.32
.00
41,628.15
68,371.85
38
60,578.29
5068
K-9 Unit
4,000.00
.00
4,000.00
10.00
.00
1,946.21
2,053.79
49
5,195.30
5095
Uniforms/Clothing
35,000.00
.00
35,000.00
1,842.23
.00
17,779.18
17,220.82
51
34,251.79
5100
Ammunition/Weapons
25,000.00
.00
25,000.00
564.36
.00
11,012.22
13,987.78
44
26,300.41
5115.001
Traffic Programs
23,000.00
.00
23,000.00
930.00
.00
16,304.71
6,695.29
71
9,481.63
8003
Radio Maintenance
1,200.00
.00
1,200.00
.00
.00
272.00
928.00
23
.00
8035
Maintenance Contracts/Lease
9,542.00
.00
9,542.00
6,742.00
.00
9,718.00
(176.00)
102
6,937.00
8060
Vehicle Maintenance
46,000.00
.00
46,000.00
7,693.36
.00
44,496.91
1,503.09
97
42,543.12
8069
Bike Unit
2,000.00
.00
2,000.00
.00
.00
.00
2,000.00
0
1,536.82
8135
Contractual Services
.00
.00
.00
1,417.00
.00
13,978.92
(13,978.92)
+++
.00
8265
Contractual Services-Wescom
593,000.00
.00
593,000.00
47,070.13
.00
423,631.17
169,368.83
71
591,023.28
$6,851,549.00
$0.00
$6,851,549.00
$617,180.73
$0.00
$4,788,899.06
$2,062,649.94
70%
$6,172,593.12
Division 51 - Police Operations Totals Division 52 - Police Administration 1005
Salaries-Full Time
1,334,890.00
.00
1,334,890.00
150,501.19
.00
893,475.46
441,414.54
67
1,255,761.72
1800
Salaries-Overtime
128,000.00
.00
128,000.00
8,194.17
.00
78,956.35
49,043.65
62
119,924.62
2000
FICA
90,699.00
.00
90,699.00
8,911.96
.00
58,084.40
32,614.60
64
84,119.64
2001
Medicare
21,212.00
.00
21,212.00
2,302.89
.00
13,802.91
7,409.09
65
19,673.09
2020
Employee Insurance
212,634.00
.00
212,634.00
25,688.52
.00
152,252.74
60,381.26
72
196,175.41
2025
Deferred Comp. Contribution
40,000.00
.00
40,000.00
.00
.00
.00
40,000.00
0
40,169.63
3000
Travel/Training
11,740.00
.00
11,740.00
76.00
.00
13,075.62
(1,335.62)
111
12,820.56
4000
Telephone/Internet
2,070.00
.00
2,070.00
146.71
.00
979.10
1,090.90
47
1,365.52
4005
Cellular Phones/Pagers
11,280.00
.00
11,280.00
671.87
.00
4,679.98
6,600.02
41
8,945.48
5005
Office Supplies/Postage
10,000.00
.00
10,000.00
419.86
.00
3,104.82
6,895.18
31
5,014.00
5010
Replacement Supplies
5,000.00
.00
5,000.00
.00
.00
.00
5,000.00
0
4,422.85
5015
Dues & Subscriptions
4,070.00
.00
4,070.00
.00
.00
2,145.00
1,925.00
53
3,535.00
5020
Gas/Oil/Mileage/Carwash
29,000.00
.00
29,000.00
1,885.71
.00
13,334.19
15,665.81
46
19,023.55
5040.002
Crime Scene/Evidence Tech Supply
7,000.00
.00
7,000.00
.00
.00
3,673.82
3,326.18
52
4,381.92
5095
Uniforms/Clothing
8,950.00
.00
8,950.00
3,600.00
.00
8,880.89
69.11
99
12,751.59
5115.004
Community Programs-Explorer Program
2,500.00
.00
2,500.00
160.00
.00
2,492.77
7.23
100
1,455.22
8003
Radio Maintenance
500.00
.00
500.00
.00
.00
.00
500.00
0
.00
8035
Maintenance Contracts/Lease
8,920.00
.00
8,920.00
1,807.87
.00
3,499.77
5,420.23
39
3,669.04
Run by Traci Pleckham on 01/19/2017 02:03:02 PM
Page 7 of 14
Budget Performance Report Fiscal Year to Date 12/31/16 Exclude Rollup Account
Account
Account Description
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Budget - YTD % Used/ Transactions
Rec'd
Prior Year Total
Fund 01 - General Fund EXPENSE Unit 05 - Police Department Division 52 - Police Administration 8060
Vehicle Maintenance
15,250.00
.00
15,250.00
678.46
.00
6,542.69
8,707.31
43
11,793.39
8250
Background Check Services
2,500.00
.00
2,500.00
.00
.00
410.00
2,090.00
16
3,738.84
8268
Accreditation
8,070.00
.00
8,070.00
2,119.71
.00
8,436.68
(366.68)
105
4,065.00
$1,954,285.00
$0.00
$1,954,285.00
$207,164.92
$0.00
$1,267,827.19
$686,457.81
65%
$1,812,806.07 392,281.41
Division 52 - Police Administration Totals Division 53 - Police Records 1005
Salaries-Full Time
400,739.00
.00
400,739.00
46,239.38
.00
277,060.28
123,678.72
69
1800
Salaries-Overtime
6,000.00
.00
6,000.00
142.71
.00
5,751.53
248.47
96
3,368.57
2000
FICA
25,218.00
.00
25,218.00
2,798.95
.00
16,974.63
8,243.37
67
23,683.49
2001
Medicare
2010
IMRF
2020
Employee Insurance
2025
Deferred Comp. Contribution
3000
5,898.00
.00
5,898.00
659.73
.00
3,975.03
1,922.97
67
5,538.88
35,630.00
.00
35,630.00
3,792.42
.00
22,830.97
12,799.03
64
32,505.65
124,382.00
.00
124,382.00
13,977.70
.00
84,017.18
40,364.82
68
115,948.23
15,000.00
.00
15,000.00
.00
.00
.00
15,000.00
0
12,396.50
Travel/Training
2,100.00
.00
2,100.00
91.34
.00
1,447.94
652.06
69
2,025.16
4000
Telephone/Internet
2,070.00
.00
2,070.00
146.71
.00
979.10
1,090.90
47
1,365.52
5005
Office Supplies/Postage
13,450.00
.00
13,450.00
805.88
.00
4,028.47
9,421.53
30
9,485.89
5015
Dues & Subscriptions
425.00
.00
425.00
.00
.00
75.00
350.00
18
124.00
5095
Uniforms/Clothing
2,400.00
.00
2,400.00
702.31
.00
1,187.46
1,212.54
49
2,523.83
8035
Maintenance Contracts/Lease Division 53 - Police Records Totals
4,460.00
.00
4,460.00
360.00
.00
1,440.00
3,020.00
32
6,025.00
$637,772.00
$0.00
$637,772.00
$69,717.13
$0.00
$419,767.59
$218,004.41
66%
$607,272.13
Division 54 - Seizure/Forfeiture 5012
Asset Seizure/Forfeiture Expense Division 54 - Seizure/Forfeiture Totals
180,000.00
.00
180,000.00
32,480.50
120,221.00
112,505.71
(52,726.71)
129
137,908.02
$180,000.00
$0.00
$180,000.00
$32,480.50
$120,221.00
$112,505.71
($52,726.71)
129%
$137,908.02
32,513.00
.00
32,513.00
2,895.00
.00
34,472.50
(1,959.50)
106
35,418.75
2,016.00
.00
2,016.00
158.20
.00
1,963.03
52.97
97
2,120.05
471.00
.00
471.00
40.39
.00
466.28
4.72
99
500.03
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00
0
.00
$36,000.00
$0.00
$36,000.00
$3,093.59
$0.00
$36,901.81
($901.81)
103%
$38,038.83
Division 55 - Police Special Activities 1005.061
Salaries-Special Activities
2000
FICA
2001
Medicare
5045
Mobile Field Force Division 55 - Police Special Activities Totals Division 56 - Community Services
1005
Salaries-Full Time
559,103.00
.00
559,103.00
63,765.94
.00
384,138.15
174,964.85
69
523,444.08
1015
Salaries-Part Time
245,000.00
.00
245,000.00
22,319.25
.00
138,736.10
106,263.90
57
203,675.01
1800
Salaries-Overtime
30,000.00
.00
30,000.00
1,936.41
.00
21,839.38
8,160.62
73
30,883.91
2000
FICA
53,110.00
.00
53,110.00
5,195.82
.00
32,891.49
20,218.51
62
46,278.05
2001
Medicare
12,421.00
.00
12,421.00
1,252.64
.00
7,729.85
4,691.15
62
10,823.10
2010
IMRF
57,849.00
.00
57,849.00
5,403.95
.00
33,802.45
24,046.55
58
46,701.37
2020
Employee Insurance
100,609.00
.00
100,609.00
13,989.56
.00
80,884.56
19,724.44
80
93,887.50
2025
Deferred Comp. Contribution
7,500.00
.00
7,500.00
.00
.00
.00
7,500.00
0
6,882.84
Run by Traci Pleckham on 01/19/2017 02:03:02 PM
Page 8 of 14
Budget Performance Report Fiscal Year to Date 12/31/16 Exclude Rollup Account
Account
Account Description
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Budget - YTD % Used/ Transactions
Rec'd
Prior Year Total
Fund 01 - General Fund EXPENSE Unit 05 - Police Department Division 56 - Community Services 3000
Travel/Training
12,020.00
.00
12,020.00
15.00
.00
8,157.24
3,862.76
68
9,872.27
4000
Telephone/Internet
2,070.00
.00
2,070.00
146.71
.00
979.10
1,090.90
47
1,364.99
4005
Cellular Phones/Pagers
3,280.00
.00
3,280.00
211.39
.00
1,610.92
1,669.08
49
2,709.78
5005
Office Supplies/Postage
3,000.00
.00
3,000.00
294.36
.00
1,547.76
1,452.24
52
2,842.45
5010
Replacement Supplies
3,700.00
.00
3,700.00
172.10
.00
494.78
3,205.22
13
1,582.10
5015
Dues & Subscriptions
3,050.00
.00
3,050.00
50.00
.00
1,343.00
1,707.00
44
1,476.50
5020
Gas/Oil/Mileage/Carwash
25,000.00
.00
25,000.00
1,122.85
.00
10,046.19
14,953.81
40
14,963.16
5095
Uniforms/Clothing
6,700.00
.00
6,700.00
342.05
.00
5,685.39
1,014.61
85
11,607.13
5115.002
Community Programs
7,000.00
.00
7,000.00
872.00
.00
3,205.86
3,794.14
46
4,140.92
5115.003
Community Prog.-Alcohol/Tobacco
5,100.00
.00
5,100.00
.00
.00
120.30
4,979.70
2
76.49
8003
Radio Maintenance
50,000.00
.00
50,000.00
2,710.84
.00
21,138.84
28,861.16
42
33,052.59
8035
Maintenance Contracts/Lease
10,000.00
.00
10,000.00
147.00
.00
1,022.50
8,977.50
10
49.00
8060
Vehicle Maintenance
14,000.00
.00
14,000.00
3,451.61
.00
17,667.31
(3,667.31)
126
21,218.11
8245
D.A.R.E. Program
5,000.00
.00
5,000.00
.00
.00
1,983.00
3,017.00
40
4,828.54
8246
Shop with a Cop
4,000.00
.00
4,000.00
.00
.00
9,500.00
(5,500.00)
238
11,022.00
8266
Chaplaincy Program
1,752.97
8267
Animal Control Division 56 - Community Services Totals
4,600.00
.00
4,600.00
.00
.00
1,021.40
3,578.60
22
14,000.00
.00
14,000.00
.00
.00
5,940.00
8,060.00
42
7,130.00
$1,238,112.00
$0.00
$1,238,112.00
$123,399.48
$0.00
$791,485.57
$446,626.43
64%
$1,092,264.86
Division 57 - Court Services 1005
Salaries-Full Time
118,743.00
.00
118,743.00
13,701.15
.00
83,678.76
35,064.24
70
116,283.23
1015
Salaries-Part Time
46,253.00
.00
46,253.00
4,831.26
.00
29,260.23
16,992.77
63
43,771.89
1800
Salaries-Overtime
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00
0
.00
2000
FICA
10,292.00
.00
10,292.00
1,122.81
.00
6,811.32
3,480.68
66
9,618.38
2001
Medicare
2,407.00
.00
2,407.00
262.60
.00
1,592.99
814.01
66
2,249.44
2010
IMRF
19,920.00
.00
19,920.00
2,084.91
.00
12,750.68
7,169.32
64
18,149.46
2020
Employee Insurance
38,118.00
.00
38,118.00
4,586.80
.00
27,217.36
10,900.64
71
35,705.27
2025
Deferred Comp. Contribution
5,000.00
.00
5,000.00
.00
.00
.00
5,000.00
0
4,773.04
3000
Travel/Training
3,000.00
.00
3,000.00
50.00
.00
129.00
2,871.00
4
1,032.22
4000
Telephone/Internet
1,610.00
.00
1,610.00
117.51
.00
791.53
818.47
49
1,082.39
5005
Office Supplies/Postage
11,625.00
.00
11,625.00
751.58
.00
3,923.01
7,701.99
34
8,116.13
5015
Dues & Subscriptions
8,800.00
.00
8,800.00
458.95
.00
4,743.20
4,056.80
54
8,712.63
5095
Uniforms/Clothing
900.00
.00
900.00
177.99
.00
177.99
722.01
20
651.19
8035
Maintenance Contracts/Lease
1,920.00
.00
1,920.00
320.00
.00
1,280.00
640.00
67
1,693.00
8065
Legal Fees Division 57 - Court Services Totals
20,000.00
.00
20,000.00
300.00
4,000.00
2,322.50
13,677.50
32
3,325.00
$289,588.00
$0.00
$289,588.00
$28,765.56
$4,000.00
$174,678.57
$110,909.43
62%
$255,163.27
6,000.00
.00
6,000.00
.00
.00
1,909.83
4,090.17
32
967.18
Division 91 - Capital 9115
Office Furniture & Equipment
Run by Traci Pleckham on 01/19/2017 02:03:02 PM
Page 9 of 14
Budget Performance Report Fiscal Year to Date 12/31/16 Exclude Rollup Account
Account
Account Description
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Budget - YTD % Used/ Transactions
Rec'd
Prior Year Total
Fund 01 - General Fund EXPENSE Unit 05 - Police Department Division 91 - Capital 9120
Machinery and Equipment
42,780.00
.00
42,780.00
2,089.77
2,089.77
2,089.77
38,600.46
10
21,242.00
Division 91 - Capital Totals
$48,780.00
$0.00
$48,780.00
$2,089.77
$2,089.77
$3,999.60
$42,690.63
12%
$22,209.18
12,700.00
.00
12,700.00
588.40
.00
8,118.45
4,581.55
64
6,300.03
Division 93 - Contingencies Totals
$12,700.00
$0.00
$12,700.00
$588.40
$0.00
$8,118.45
$4,581.55
64%
$6,300.03
Unit 05 - Police Department Totals
$11,863,032.00
$0.00
$11,863,032.00
$1,137,706.57
$126,310.77
$7,947,737.06
$3,788,984.17
68%
$10,712,813.22
Division 93 - Contingencies 9300
Contingencies
Unit 07 - PEMA Division 07 - PEMA Program 1005
Salaries-Full Time
125,000.00
.00
125,000.00
13,931.46
.00
87,248.64
37,751.36
70
121,919.56
2000
FICA
7,750.00
.00
7,750.00
320.31
.00
4,746.03
3,003.97
61
7,408.46
2001
Medicare
1,813.00
.00
1,813.00
198.16
.00
1,233.21
579.79
68
1,747.38
2020
Employee Insurance
20,988.00
.00
20,988.00
2,265.76
.00
13,269.90
7,718.10
63
17,319.79
2025
Deferred Comp. Contribution
4,000.00
.00
4,000.00
.00
.00
.00
4,000.00
0
3,965.30
3000
Travel/Training
4,000.00
.00
4,000.00
25.00
.00
201.80
3,798.20
5
600.00
4000
Telephone/Internet
780.00
.00
780.00
447.25
.00
3,246.79
(2,466.79)
416
4,994.85
4005
Cellular Phones/Pagers
5,200.00
.00
5,200.00
294.12
.00
2,013.29
3,186.71
39
3,228.42
5005
Office Supplies/Postage
1,300.00
.00
1,300.00
.00
.00
302.76
997.24
23
619.91
5010
Replacement Supplies
11,000.00
.00
11,000.00
.00
.00
541.87
10,458.13
5
5,223.60
5015
Dues & Subscriptions
5020
Gas/Oil/Mileage/Carwash
5040
3,000.00
.00
3,000.00
.00
.00
1,557.27
1,442.73
52
2,328.50
12,000.00
.00
12,000.00
321.99
.00
3,468.59
8,531.41
29
5,907.43
Supplies/Hardware
2,000.00
.00
2,000.00
29.82
.00
75.81
1,924.19
4
439.38
5040.001
Supplies/Hardware-ESDA
2,000.00
.00
2,000.00
.00
.00
195.12
1,804.88
10
29.05
5095
Uniforms/Clothing
5,000.00
.00
5,000.00
20.24
.00
1,230.02
3,769.98
25
2,104.54
5110
Emergency Operation Center
5115
Police Public Relations
5120
Disaster Plan/Exercises/NIMS
8003
Radio Maintenance
8035
Maintenance Contracts/Lease
8060
Vehicle Maintenance
8069
Bike Unit
8125
Siren Maintenance
8135 8280
750.00
.00
750.00
.00
.00
.00
750.00
0
.00
2,000.00
.00
2,000.00
.00
.00
.00
2,000.00
0
22,000.00 783.67
3,000.00
.00
3,000.00
.00
.00
.00
3,000.00
0
10,000.00
.00
10,000.00
.00
(2,818.00)
3,017.99
9,800.01
2
.00
1,800.00
.00
1,800.00
217.53
.00
902.37
897.63
50
2,004.44
15,000.00
.00
15,000.00
1,479.45
.00
10,082.85
4,917.15
67
11,752.22
500.00
.00
500.00
.00
.00
.00
500.00
0
.00
20,000.00
.00
20,000.00
279.18
.00
7,687.64
12,312.36
38
9,322.22
Contractual Services
5,250.00
.00
5,250.00
.00
.00
.00
5,250.00
0
.00
Cadet Program
5,500.00
.00
5,500.00
.00
.00
2,153.47
3,346.53
39
3,644.34
8305
PEMA Search and Rescue
8,000.00
.00
8,000.00
.00
.00
.00
8,000.00
0
307.51
9115
Office Furniture & Equipment
2,000.00
.00
2,000.00
.00
.00
683.52
1,316.48
34
.00
9120
Machinery and Equipment
5,000.00
.00
5,000.00
.00
.00
474.99
4,525.01
9
1,734.52
9300
Contingencies
3,000.00
.00
3,000.00
.00
.00
19.09
2,980.91
1
898.44
Run by Traci Pleckham on 01/19/2017 02:03:02 PM
Page 10 of 14
Budget Performance Report Fiscal Year to Date 12/31/16 Exclude Rollup Account
Account
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions
Rec'd
Prior Year Total
Division 07 - PEMA Program Totals
$287,631.00
$0.00
$287,631.00
$19,830.27
($2,818.00)
$144,353.02
$146,095.98
49%
$230,283.53
Unit 07 - PEMA Totals
$287,631.00
$0.00
$287,631.00
$19,830.27
($2,818.00)
$144,353.02
$146,095.98
49%
$230,283.53
266,745.74
Account Description
Budget - YTD % Used/
Fund 01 - General Fund EXPENSE Unit 07 - PEMA
Unit 08 - Street Department Division 02 - Administration Program 1005
Salaries-Full Time
279,953.00
.00
279,953.00
31,179.79
.00
186,875.21
93,077.79
67
1015
Salaries-Part Time
.00
.00
.00
.00
.00
4,480.00
(4,480.00)
+++
.00
2000
FICA
17,360.00
.00
17,360.00
1,682.48
.00
11,226.39
6,133.61
65
16,112.88
2001
Medicare
4,060.00
.00
4,060.00
471.33
.00
2,783.47
1,276.53
69
3,835.21
2010
IMRF
32,195.00
.00
32,195.00
3,736.42
.00
21,761.78
10,433.22
68
30,944.29
2020
Employee Insurance
54,449.00
.00
54,449.00
6,374.90
.00
37,551.97
16,897.03
69
48,313.19
2025
Deferred Comp. Contribution
7,000.00
.00
7,000.00
.00
.00
.00
7,000.00
0
7,244.29
3000
Travel/Training
10,000.00
.00
10,000.00
.00
.00
7,472.41
2,527.59
75
7,900.85
3015
IL Unemployment Insurance
4,000.00
.00
4,000.00
.00
.00
1,645.02
2,354.98
41
3,226.35
4000
Telephone/Internet
15,000.00
.00
15,000.00
3,014.27
.00
13,845.83
1,154.17
92
18,337.63
4005
Cellular Phones/Pagers
7,000.00
.00
7,000.00
774.70
.00
4,249.29
2,750.71
61
7,841.04
5005
Office Supplies/Postage
2,500.00
.00
2,500.00
407.09
.00
1,663.75
836.25
67
2,279.71
5015
Dues & Subscriptions
3,000.00
.00
3,000.00
.00
.00
1,239.69
1,760.31
41
2,456.65
5020
Gas/Oil/Mileage/Carwash
300.00
.00
300.00
.00
.00
40.00
260.00
13
62.00
5040
Supplies/Hardware
500.00
.00
500.00
.00
.00
.00
500.00
0
.00
8003
Radio Maintenance
100.00
.00
100.00
.00
.00
.00
100.00
0
.00
8020
Building Maintenance
15,000.00
.00
15,000.00
496.75
.00
2,861.01
12,138.99
19
20,275.42
8050
Legal Notices
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00
0
337.58
8135
Contractual Services
.00
.00
.00
.00
.00
238.15
(238.15)
+++
624.52
$453,417.00
$0.00
$453,417.00
$48,137.73
$0.00
$297,933.97
$155,483.03
66%
$436,537.35
Division 02 - Administration Program Totals Division 60 - Street Maintenance Program 1005
Salaries-Full Time
718,000.00
.00
718,000.00
80,518.66
.00
497,856.78
220,143.22
69
706,707.73
1015
Salaries-Part Time
75,000.00
.00
75,000.00
1,360.00
.00
56,033.19
18,966.81
75
63,692.00
1800
Salaries-Overtime
80,000.00
.00
80,000.00
24,986.45
.00
80,215.79
(215.79)
100
86,809.19
2000
FICA
54,126.00
.00
54,126.00
6,241.04
.00
37,743.59
16,382.41
70
51,294.79
2001
Medicare
12,660.00
.00
12,660.00
1,459.58
.00
8,827.07
3,832.93
70
11,996.43
2010
IMRF
94,500.00
.00
94,500.00
11,404.56
.00
64,220.88
30,279.12
68
89,457.49
2020
Employee Insurance
167,141.00
.00
167,141.00
20,366.61
.00
125,254.85
41,886.15
75
164,733.79
2025
Deferred Comp. Contribution
4015
Electricity/Gas
5005 5010 5020 5040
19,900.00
.00
19,900.00
.00
.00
.00
19,900.00
0
18,734.50
290,000.00
.00
290,000.00
14,183.95
.00
101,057.20
188,942.80
35
318,227.20
Office Supplies/Postage
.00
.00
.00
49.00
.00
49.00
(49.00)
+++
.00
Replacement Supplies
.00
.00
.00
.00
.00
271.22
(271.22)
+++
.00
Gas/Oil/Mileage/Carwash
85,000.00
.00
85,000.00
1,007.58
.00
30,505.35
54,494.65
36
36,489.73
Supplies/Hardware
15,000.00
.00
15,000.00
541.66
.00
9,355.70
5,644.30
62
13,852.15
Run by Traci Pleckham on 01/19/2017 02:03:02 PM
Page 11 of 14
Budget Performance Report Fiscal Year to Date 12/31/16 Exclude Rollup Account
Account
Account Description
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Budget - YTD % Used/ Transactions
Rec'd
Prior Year Total
200,000.00
.00
200,000.00
45,832.07
.00
90,992.75
109,007.25
45
281,779.71
20,000.00
.00
20,000.00
5,223.10
.00
15,862.67
4,137.33
79
26,158.09
Fund 01 - General Fund EXPENSE Unit 08 - Street Department Division 60 - Street Maintenance Program 5040.003
Supplies/Hardware-Salt Purchase
5055
Street Sign Maintenance
5060
Aggregate Materials
4,000.00
.00
4,000.00
253.32
.00
639.56
3,360.44
16
3,959.90
5095
Uniforms/Clothing
9,000.00
.00
9,000.00
1,417.55
.00
5,670.47
3,329.53
63
10,512.31
8003
Radio Maintenance
8060
Vehicle Maintenance
8130
Street Light Maintenance
8131
Street Maintenance
8132
5,000.00
.00
5,000.00
.00
.00
1,618.60
3,381.40
32
2,883.80
35,000.00
.00
35,000.00
201.75
.00
13,858.75
21,141.25
40
33,721.60
90,000.00
.00
90,000.00
4,681.87
.00
49,608.45
40,391.55
55
116,110.32
130,000.00
.00
130,000.00
3,099.26
.00
53,911.14
76,088.86
41
132,611.04
Storm Sewer Improvements
10,000.00
.00
10,000.00
313.00
.00
890.85
9,109.15
9
10,798.05
8135
Contractual Services
90,000.00
.00
90,000.00
16,889.37
.00
98,021.50
(8,021.50)
109
81,072.28
8135.004
Snow Removal
280,000.00
.00
280,000.00
2,444.50
.00
2,482.13
277,517.87
1
143,542.76
8150
Sidewalk Maintenance
8160
Equipment Maintenance Division 60 - Street Maintenance Program Totals
5,000.00
.00
5,000.00
.00
.00
1,496.87
3,503.13
30
1,565.75
90,000.00
.00
90,000.00
4,728.13
.00
39,955.77
50,044.23
44
99,655.81
$2,579,327.00
$0.00
$2,579,327.00
$247,203.01
$0.00
$1,386,400.13
$1,192,926.87
54%
$2,506,366.42
Division 62 - Forestry Program 1005
Salaries-Full Time
76,660.00
.00
76,660.00
5,200.42
.00
36,573.09
40,086.91
48
64,225.69
1800
Salaries-Overtime
6,000.00
.00
6,000.00
352.23
.00
5,550.95
449.05
93
3,748.14
2000
FICA
5,125.00
.00
5,125.00
467.48
.00
2,673.61
2,451.39
52
4,338.19
2001
Medicare
1,199.00
.00
1,199.00
109.34
.00
625.28
573.72
52
1,014.49
2010
IMRF
8,816.00
.00
8,816.00
860.71
.00
4,985.09
3,830.91
57
8,171.30
2020
Employee Insurance
19,648.00
.00
19,648.00
791.83
.00
8,969.52
10,678.48
46
16,919.65
2025
Deferred Comp. Contribution
3,000.00
.00
3,000.00
.00
.00
.00
3,000.00
0
1,892.00
5015
Dues & Subscriptions
.00
.00
.00
.00
.00
565.00
(565.00)
+++
.00
5040
Supplies/Hardware
6,000.00
.00
6,000.00
118.98
.00
2,240.23
3,759.77
37
8,315.50
5095
Uniforms/Clothing
500.00
.00
500.00
.00
.00
.00
500.00
0
435.60
8135
Contractual Services
5,000.00
.00
5,000.00
.00
.00
1,198.15
3,801.85
24
5,770.00
8135.002
Tree Removal Division 62 - Forestry Program Totals
40,000.00
.00
40,000.00
1,738.00
.00
9,890.00
30,110.00
25
50,749.00
$171,948.00
$0.00
$171,948.00
$9,638.99
$0.00
$73,270.92
$98,677.08
43%
$165,579.56 179,082.56
Division 63 - Vehicle Maintenance Program 1005
Salaries-Full Time
181,100.00
.00
181,100.00
20,886.32
.00
127,315.48
53,784.52
70
1800
Salaries-Overtime
8,000.00
.00
8,000.00
1,529.13
.00
2,245.49
5,754.51
28
5,312.58
2000
FICA
11,724.00
.00
11,724.00
1,346.10
.00
7,651.04
4,072.96
65
10,944.43
2001
Medicare
2,741.00
.00
2,741.00
314.79
.00
1,789.35
951.65
65
2,559.64
2010
IMRF
21,250.00
.00
21,250.00
2,521.76
.00
14,575.69
6,674.31
69
21,066.93
2020
Employee Insurance
42,501.00
.00
42,501.00
4,419.50
.00
27,003.42
15,497.58
64
39,895.33
2025
Deferred Comp. Contribution
7,500.00
.00
7,500.00
.00
.00
.00
7,500.00
0
6,178.47
$274,816.00
$0.00
$274,816.00
$31,017.60
$0.00
$180,580.47
$94,235.53
66%
$265,039.94
Division 63 - Vehicle Maintenance Program Totals
Run by Traci Pleckham on 01/19/2017 02:03:02 PM
Page 12 of 14
Budget Performance Report Fiscal Year to Date 12/31/16 Exclude Rollup Account
Account
Account Description
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Budget - YTD % Used/ Transactions
Rec'd
Prior Year Total
$3,479,508.00
$0.00
$3,479,508.00
$335,997.33
$0.00
$1,938,185.49
$1,541,322.51
56%
$3,373,523.27
Fund 01 - General Fund EXPENSE Unit 08 - Street Department Totals Unit 09 - Community Development Division 20 - Planning Program 1005
Salaries-Full Time
360,000.00
.00
360,000.00
36,929.51
.00
178,629.18
181,370.82
50
252,076.02
1045
Salaries-Commissioner
4,000.00
.00
4,000.00
155.00
.00
1,685.00
2,315.00
42
2,640.00
1800
Salaries-Overtime
2,500.00
.00
2,500.00
305.49
.00
1,513.62
986.38
61
1,853.66
2000
FICA
22,723.00
.00
22,723.00
2,280.94
.00
10,997.21
11,725.79
48
15,884.11
2001
Medicare
5,315.00
.00
5,315.00
533.44
.00
2,571.95
2,743.05
48
3,714.80
2010
IMRF
43,500.00
.00
43,500.00
4,188.95
.00
20,288.55
23,211.45
47
29,399.02
2020
Employee Insurance
77,086.00
.00
77,086.00
6,984.97
.00
38,117.62
38,968.38
49
49,086.03
2025
Deferred Comp. Contribution
11,500.00
.00
11,500.00
.00
.00
.00
11,500.00
0
6,377.51
3000
Travel/Training
7,000.00
.00
7,000.00
25.00
.00
1,582.00
5,418.00
23
1,795.09
3015
IL Unemployment Insurance
1,000.00
.00
1,000.00
.00
.00
257.64
742.36
26
627.89
4000
Telephone/Internet
4,000.00
.00
4,000.00
182.77
.00
1,209.54
2,790.46
30
1,684.07
4005
Cellular Phones/Pagers
2,000.00
.00
2,000.00
72.98
.00
801.70
1,198.30
40
1,081.77
5005
Office Supplies/Postage
10,000.00
.00
10,000.00
1,379.38
.00
7,254.43
2,745.57
73
10,614.13
5015
Dues & Subscriptions
3,000.00
.00
3,000.00
285.00
.00
1,144.00
1,856.00
38
1,349.96
5020
Gas/Oil/Mileage/Carwash
750.00
.00
750.00
.00
.00
.00
750.00
0
.00
5065
Software
500.00
.00
500.00
.00
.00
.00
500.00
0
.00
8035
Maintenance Contracts/Lease
5,000.00
.00
5,000.00
100.00
.00
400.00
4,600.00
8
1,459.94
8060
Vehicle Maintenance
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00
0
.00
8065
Legal Fees
5,000.00
.00
5,000.00
.00
.00
2,012.75
2,987.25
40
253.50
8097
Special Projects and Programs
15,000.00
.00
15,000.00
833.33
.00
2,042.61
12,957.39
14
.00
8135
Contractual Services
35,000.00
.00
35,000.00
.00
.00
1,691.84
33,308.16
5
332.50
8225
Engineering Fees Division 20 - Planning Program Totals
10,000.00
.00
10,000.00
.00
.00
3,365.00
6,635.00
34
170.00
$625,874.00
$0.00
$625,874.00
$54,256.76
$0.00
$275,564.64
$350,309.36
44%
$380,400.00
Division 21 - Building Program 1005
Salaries-Full Time
399,000.00
.00
399,000.00
50,582.95
.00
290,852.66
108,147.34
73
350,093.17
1015
Salaries-Part Time
50,000.00
.00
50,000.00
.00
.00
7,710.79
42,289.21
15
51,348.86
1800
Salaries-Overtime
1,000.00
.00
1,000.00
11.77
.00
141.22
858.78
14
1,268.92
2000
FICA
27,900.00
.00
27,900.00
3,072.24
.00
17,964.37
9,935.63
64
24,268.26
2001
Medicare
6,525.00
.00
6,525.00
718.50
.00
4,201.33
2,323.67
64
5,675.69
2010
IMRF
52,875.00
.00
52,875.00
5,703.16
.00
33,598.64
19,276.36
64
42,564.50
2020
Employee Insurance
97,033.00
.00
97,033.00
11,564.72
.00
70,452.76
26,580.24
73
75,395.33
2025
Deferred Comp. Contribution
6,500.00
.00
6,500.00
.00
.00
.00
6,500.00
0
3,400.00
3000
Travel/Training
4,500.00
.00
4,500.00
.00
.00
3,337.96
1,162.04
74
3,648.00
3015
IL Unemployment Insurance
1,000.00
.00
1,000.00
.00
.00
515.30
484.70
52
940.58
4000
Telephone/Internet
1,500.00
.00
1,500.00
36.56
.00
241.91
1,258.09
16
343.03
4005
Cellular Phones/Pagers
4,000.00
.00
4,000.00
331.00
.00
1,967.19
2,032.81
49
4,350.18
Run by Traci Pleckham on 01/19/2017 02:03:02 PM
Page 13 of 14
Budget Performance Report Fiscal Year to Date 12/31/16 Exclude Rollup Account
Account
Account Description
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Budget - YTD % Used/ Transactions
Rec'd
Prior Year Total
Fund 01 - General Fund EXPENSE Unit 09 - Community Development Division 21 - Building Program 5005
Office Supplies/Postage
8,000.00
.00
8,000.00
363.71
.00
3,636.10
4,363.90
45
9,540.71
5015
Dues & Subscriptions
4,000.00
.00
4,000.00
.00
.00
.00
4,000.00
0
580.00
5020
Gas/Oil/Mileage/Carwash
1,000.00
.00
1,000.00
.00
.00
21.00
979.00
2
83.00
5095
Uniforms/Clothing
600.00
.00
600.00
.00
.00
125.00
475.00
21
.00
8097
Special Projects and Programs
500.00
.00
500.00
.00
.00
.00
500.00
0
.00
8135
Contractual Services
45,000.00
.00
45,000.00
5,036.00
7,036.00
6,601.17
31,362.83
30
35,247.05
8230
Ordinance Maintenance
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00
0
.00
Division 21 - Building Program Totals
$711,933.00
$0.00
$711,933.00
$77,420.61
$7,036.00
$441,367.40
$263,529.60
63%
$608,747.28
Unit 09 - Community Development Totals
$1,337,807.00
$0.00
$1,337,807.00
$131,677.37
$7,036.00
$716,932.04
$613,838.96
54%
$989,147.28
5,500.00
.00
5,500.00
69.00
.00
301.88
5,198.12
5
2,092.20
341.00
.00
341.00
4.28
.00
18.72
322.28
5
133.40
80.00
.00
80.00
1.00
.00
4.38
75.62
5
31.19
Unit 50 - Police Commission Division 02 - Administration Program 1015
Salaries-Part Time
2000
FICA
2001
Medicare
3000
Travel/Training
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00
0
.00
5005
Office Supplies/Postage
2,000.00
.00
2,000.00
.00
.00
132.80
1,867.20
7
884.38
5015
Dues & Subscriptions
375.00
8065
Legal Fees
8115
Police Testing/Hiring
600.00
.00
600.00
375.00
.00
375.00
225.00
62
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00
0
.00
10,000.00
.00
10,000.00
4,208.00
.00
4,327.55
5,672.45
43
4,113.50
Division 02 - Administration Program Totals
$20,521.00
$0.00
$20,521.00
$4,657.28
$0.00
$5,160.33
$15,360.67
25%
$7,629.67
Unit 50 - Police Commission Totals
$20,521.00
$0.00
$20,521.00
$4,657.28
$0.00
$5,160.33
$15,360.67
25%
$7,629.67
EXPENSE TOTALS
$23,574,972.00
$0.00
$23,574,972.00
$2,187,033.73
$174,870.15
$14,609,587.63
$8,790,514.22
63%
$23,840,313.83
REVENUE TOTALS
23,574,972.00
.00
23,574,972.00
1,552,718.17
.00
18,609,241.64
4,965,730.36
79%
24,152,420.32
EXPENSE TOTALS
23,574,972.00
.00
23,574,972.00
2,187,033.73
174,870.15
14,609,587.63
8,790,514.22
63%
23,840,313.83
Fund 01 - General Fund Totals
$0.00
$0.00
$0.00
($634,315.56)
($174,870.15)
$3,999,654.01
($3,824,783.86)
REVENUE TOTALS
23,574,972.00
.00
23,574,972.00
1,552,718.17
.00
18,609,241.64
4,965,730.36
79%
24,152,420.32
EXPENSE TOTALS
23,574,972.00
.00
23,574,972.00
2,187,033.73
174,870.15
14,609,587.63
8,790,514.22
63%
23,840,313.83
Grand Totals
$0.00
$0.00
$0.00
($634,315.56)
($174,870.15)
$3,999,654.01
($3,824,783.86)
Fund 01 - General Fund Totals
$312,106.49
Grand Totals
Run by Traci Pleckham on 01/19/2017 02:03:02 PM
$312,106.49
Page 14 of 14
Account
Account Description
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Budget - YTD % Used/ Transactions
Rec'd
Prior Year Total
Fund 01 - General Fund REVENUE 0400.401
Property Tax Revenue
3,162,500.00
.00
3,162,500.00
27,973.89
.00
3,186,939.65
(24,439.65)
101
3,254,992.57
0400.402
Property Tax Rev-Road & Bridge
375,000.00
.00
375,000.00
3,449.22
.00
357,161.29
17,838.71
95
385,492.10
0400.403
Property Tax Rev-Police Pension
1,100,000.00
.00
1,100,000.00
9,668.47
.00
1,101,142.15
(1,142.15)
100
948,548.76
0400.404
Property Tax Revenue-IMRF
575,000.00
.00
575,000.00
5,053.17
.00
575,655.27
(655.27)
100
575,525.65
0450.450
Home Rule Sales Tax
500,000.00
.00
500,000.00
50,948.81
.00
500,000.00
.00
100
.00
0450.451
Municipal Sales Tax
5,298,300.00
.00
5,298,300.00
426,737.24
.00
3,511,119.77
1,787,180.23
66
5,280,661.07
0450.452
Illinois Income Tax
3,320,000.00
.00
3,320,000.00
346,191.27
.00
2,591,773.41
728,226.59
78
4,218,243.70
0450.453
Replacement Tax
45,000.00
.00
45,000.00
2,063.04
.00
30,324.19
14,675.81
67
48,179.55
0450.455
Local Use Tax
775,000.00
.00
775,000.00
76,212.10
.00
605,403.04
169,596.96
78
918,416.43
0500.501
Amusement Tax
0500.503
Local Motor Fuel Tax
0550.551 0550.552 0550.553
Cigarette License
0550.554
Scavenger License
0550.558
Business License
0570.555
Building Permit
0570.556
Sign Permit
0570.557
5,000.00
.00
5,000.00
136.81
.00
4,709.30
290.70
94
7,581.85
850,000.00
.00
850,000.00
81,261.70
.00
617,817.14
232,182.86
73
897,403.82
Liquor License
90,000.00
.00
90,000.00
742.10
.00
100,253.05
(10,253.05)
111
91,455.26
Contractors License
35,000.00
.00
35,000.00
2,600.00
.00
31,250.00
3,750.00
89
48,000.00
5,000.00
.00
5,000.00
.00
.00
7,000.00
(2,000.00)
140
6,500.00
200.00
.00
200.00
.00
.00
100.00
100.00
50
100.00
30,000.00
.00
30,000.00
11,100.00
.00
29,763.00
237.00
99
35,125.00
850,000.00
.00
850,000.00
72,971.31
.00
702,615.64
147,384.36
83
983,447.97
5,000.00
.00
5,000.00
594.00
.00
4,655.00
345.00
93
4,442.00
Special Movement Permit
3,000.00
.00
3,000.00
390.00
.00
5,225.00
(2,225.00)
174
6,410.00
0570.560
Solicitors Permit
1,300.00
.00
1,300.00
35.00
.00
840.00
460.00
65
1,575.00
0600.601
Will County Court Fines
310,000.00
.00
310,000.00
21,296.98
.00
271,327.21
38,672.79
88
332,692.07
0600.602
Administrative Fines(P-Tickets)
150,000.00
.00
150,000.00
11,035.00
.00
92,800.05
57,199.95
62
139,091.06
0600.603
Asset Seizure-Non Federal
180,000.00
.00
180,000.00
.00
.00
94,171.49
85,828.51
52
80,128.29
0600.604
Alarm Fees
7,000.00
.00
7,000.00
(250.00)
.00
1,850.00
5,150.00
26
11,350.00
0600.605
Kendall County Court Fines
500.00
.00
500.00
153.29
.00
747.58
(247.58)
150
1,190.73
0600.607
Administrative Fines- Late Fee
10,000.00
.00
10,000.00
940.00
.00
6,210.00
3,790.00
62
14,985.00
0600.610
Alcohol Fines
100.00
.00
100.00
.00
.00
.00
100.00
0
.00
0600.630
Asset Seizure-Federal (Dept of Justice Equitable Share)
.00
.00
.00
.00
.00
40,962.12
(40,962.12)
+++
52,536.77
0620.655
Garbage Fee
3,840,000.00
.00
3,840,000.00
339,960.98
.00
2,976,427.94
863,572.06
78
3,621,236.53
0620.656
Garbage Penalties
45,000.00
.00
45,000.00
4,861.96
.00
37,402.24
7,597.76
83
51,025.10
0640.500
Engineering Services
15,000.00
.00
15,000.00
15,335.55
.00
33,590.05
(18,590.05)
224
25,782.07
0650.580
Child Safety Seats
100.00
.00
100.00
.00
.00
.00
100.00
0
.00
0650.651
Zoning Applications
10,000.00
.00
10,000.00
2,305.00
.00
9,420.00
580.00
94
23,187.00
0650.653
Accident Report Fees
4,000.00
.00
4,000.00
345.00
.00
2,730.00
1,270.00
68
4,490.00
0650.654
Copies-Maps & Ordinances
3,000.00
.00
3,000.00
245.00
.00
1,591.40
1,408.60
53
2,904.40
0650.670
Impound Fee
30,000.00
.00
30,000.00
1,250.00
.00
15,602.50
14,397.50
52
31,037.50
0650.815
Parking Lot Revenue
1,000.00
.00
1,000.00
.00
.00
1,732.00
(732.00)
173
4,550.00
0650.818
Tower Rent
39,172.00
.00
39,172.00
3,308.31
.00
26,466.48
12,705.52
68
39,783.66
0650.825
Rental Income
49,200.00
.00
49,200.00
2,100.00
.00
30,800.00
18,400.00
63
53,300.00
Run by Traci Pleckham on 01/19/2017 02:03:02 PM
Page 1 of 14
Budget Performance Report Fiscal Year to Date 12/31/16 Exclude Rollup Account
Account
Account Description
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Budget - YTD % Used/ Transactions
Rec'd
Prior Year Total
Fund 01 - General Fund REVENUE 0650.830
Rental-Community/Multi Room
0650.904
Special Detail/OT Reimbursement
3,000.00
.00
3,000.00
915.00
.00
2,931.75
68.25
98
5,217.50
40,000.00
.00
40,000.00
3,700.00
.00
56,491.43
(16,491.43)
141
49,402.83
0690.902
Water & Sewer Service Charge
0700.704
Bulletproof Vest Grant
250,000.00
.00
250,000.00
.00
.00
.00
250,000.00
0
250,000.00
3,000.00
.00
3,000.00
.00
.00
.00
3,000.00
0
0700.710
Tobacco Grant
6,851.33
2,600.00
.00
2,600.00
.00
.00
5,500.00
(2,900.00)
212
0700.717
Traffic Grant
2,750.00
30,000.00
.00
30,000.00
9,447.47
.00
29,431.46
568.54
98
30,741.70
0750.750 0750.751
AT&T Franchise Fees
250,000.00
.00
250,000.00
794.20
.00
168,152.91
81,847.09
67
260,501.76
Cable TV-Franchise Fees
450,000.00
.00
450,000.00
.00
.00
395,237.00
54,763.00
88
0800.800
Interest Income
490,849.89
15,000.00
.00
15,000.00
4,051.78
.00
45,507.33
(30,507.33)
303
0800.827
Unrealized Gain/Loss
35,784.97
.00
.00
.00
(1,415.47)
.00
(10,844.96)
10,844.96
+++
(2,163.24)
0800.830
Unrealized Gain/Loss IMET
0801.200
Event Sponsorship Program
0801.801
Reimbursement Police Training
0801.802
Amphitheater Rent
0801.807
Restitution Program
0801.812
Step-Basset Program
0801.822
Donation/Contribution
0803.000
Sales-Fixed Assets
0805.000
Other Reimbursements
0806.000
Other Receipts
0840.001
Liability Write off
0860.804 0860.819 0999.904
.00
.00
.00
766.01
.00
(2,204.51)
2,204.51
+++
8,280.84
4,000.00
.00
4,000.00
.00
.00
3,096.76
903.24
77
4,411.00
.00
.00
.00
.00
.00
.00
.00
+++
585.00
500.00
.00
500.00
50.00
.00
(50.00)
550.00
-10
500.00
.00
.00
.00
.00
.00
.00
.00
+++
500.00
500.00
.00
500.00
.00
.00
.00
500.00
0
.00
10,000.00
.00
10,000.00
9,771.98
.00
10,478.98
(478.98)
105
17,847.76
5,000.00
.00
5,000.00
.00
.00
2,694.00
2,306.00
54
.00
95,000.00
.00
95,000.00
3,002.00
.00
61,202.80
33,797.20
64
72,703.21
25,000.00
.00
25,000.00
620.00
.00
7,314.79
17,685.21
29
27,912.58
.00
.00
.00
.00
.00
.00
.00
+++
201,503.00
School Liaison Reimbursement
400,000.00
.00
400,000.00
.00
.00
218,177.67
181,822.33
55
411,490.22
HIDTA/Organized Crime Reimb
10,000.00
.00
10,000.00
.00
.00
8,546.27
1,453.73
85
13,379.06
Transfer From MFT
200,000.00
.00
200,000.00
.00
.00
.00
200,000.00
0
.00
0999.917
Transfer From TIF
50,000.00
.00
50,000.00
.00
.00
.00
50,000.00
0
50,000.00
0999.927
Transfer From Alcohol Enforc.
12,000.00
.00
12,000.00
.00
.00
.00
12,000.00
0
12,000.00
REVENUE TOTALS
$23,574,972.00
$0.00
$23,574,972.00
$1,552,718.17
$0.00
$18,609,241.64
$4,965,730.36
79%
$24,152,420.32
.00
.00
.00
.00
.00
.00
.00
+++
30,764.02
Division 94 - Contra Totals
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+++
$30,764.02
Unit 00 - Non-Departmental Totals
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+++
$30,764.02
3,452,192.00
.00
3,452,192.00
303,525.28
.00
2,116,098.18
1,336,093.82
61
3,342,144.98
.00
.00
.00
806.80
.00
806.80
(806.80)
+++
.00
$3,452,192.00
$0.00
$3,452,192.00
$304,332.08
$0.00
$2,116,904.98
$1,335,287.02
61%
$3,342,144.98
EXPENSE Unit 00 - Non-Departmental Division 94 - Contra 2020.001
Contra Insurance Account
Unit 04 - Administration/Finance Division 00 - Non-Divisional 8100
Fees to Refuse Hauler
9997
Bad Debt Expense Division 00 - Non-Divisional Totals
Run by Traci Pleckham on 01/19/2017 02:03:02 PM
Page 2 of 14
Budget Performance Report Fiscal Year to Date 12/31/16 Exclude Rollup Account
Account
Account Description
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Budget - YTD % Used/ Transactions
Rec'd
Prior Year Total
Fund 01 - General Fund EXPENSE Unit 04 - Administration/Finance Division 01 - Legislative Program 1000
Salaries-President
20,000.00
.00
20,000.00
1,666.67
.00
13,333.36
6,666.64
67
20,000.04
1002
Salaries-Elected Officials
25,000.00
.00
25,000.00
2,200.00
.00
16,800.00
8,200.00
67
21,700.00
1003
Salaries-Liquor Commissioner
1,500.00
.00
1,500.00
125.00
.00
1,000.00
500.00
67
1,500.00
1004
Salaries-Treasurer
2,500.00
.00
2,500.00
208.33
.00
1,666.64
833.36
67
2,499.96
2000
FICA
3,000.00
.00
3,000.00
241.86
.00
1,887.78
1,112.22
63
2,615.58
2001
Medicare
700.00
.00
700.00
56.56
.00
441.49
258.51
63
611.72
2010
IMRF
850.00
.00
850.00
67.50
.00
596.25
253.75
70
769.40
2020
Employee Insurance
150.00
.00
150.00
8.40
.00
65.10
84.90
43
98.70
3000
Travel/Training
10,000.00
.00
10,000.00
.00
.00
3,538.47
6,461.53
35
5,305.83
5010
Replacement Supplies
3,000.00
.00
3,000.00
.00
.00
.00
3,000.00
0
.00
5015
Dues & Subscriptions
35,000.00
.00
35,000.00
2,575.00
4,800.00
14,916.15
15,283.85
56
33,896.37
8070
Public Relations
150,000.00
.00
150,000.00
8,418.82
.00
61,181.75
88,818.25
41
56,241.64
8074
Cable TV
20,000.00
.00
20,000.00
3,480.00
8,705.00
13,055.00
(1,760.00)
109
13.33
8078
Economic Incentive Rebate
335,000.00
.00
335,000.00
.00
.00
.00
335,000.00
0
298,677.67
$606,700.00
$0.00
$606,700.00
$19,048.14
$13,505.00
$128,481.99
$464,713.01
23%
$443,930.24
Division 01 - Legislative Program Totals Division 02 - Administration Program 1005
Salaries-Full Time
679,926.00
.00
679,926.00
78,337.68
.00
473,364.96
206,561.04
70
666,169.43
1015
Salaries-Part Time
50,000.00
.00
50,000.00
4,296.54
.00
29,568.51
20,431.49
59
41,519.42
1800
Salaries-Overtime
1,500.00
.00
1,500.00
6.70
.00
190.67
1,309.33
13
372.34
2000
FICA
45,348.00
.00
45,348.00
2,985.53
.00
25,904.58
19,443.42
57
40,327.20
2001
Medicare
10,606.00
.00
10,606.00
1,189.09
.00
7,228.94
3,377.06
68
10,239.18
2010
IMRF
84,114.00
.00
84,114.00
9,257.85
.00
56,573.13
27,540.87
67
74,515.12
2020
Employee Insurance
105,852.00
.00
105,852.00
12,194.84
.00
73,704.78
32,147.22
70
97,625.93
2025
Deferred Comp. Contribution
24,000.00
.00
24,000.00
.00
.00
.00
24,000.00
0
22,438.03
3000
Travel/Training
15,000.00
.00
15,000.00
.00
.00
7,194.10
7,805.90
48
11,507.37
3015
IL Unemployment Insurance
7,000.00
.00
7,000.00
.00
.00
1,656.82
5,343.18
24
3,372.29
4000
Telephone/Internet
5,000.00
.00
5,000.00
365.54
.00
2,419.10
2,580.90
48
3,495.94
4005
Cellular Phones/Pagers
2,000.00
.00
2,000.00
179.32
.00
1,760.16
239.84
88
2,112.67
5005
Office Supplies/Postage
30,000.00
.00
30,000.00
2,228.44
.00
19,467.91
10,532.09
65
32,692.34
5015
Dues & Subscriptions
5,000.00
.00
5,000.00
320.00
.00
3,157.00
1,843.00
63
3,277.25
5020
Gas/Oil/Mileage/Carwash
9,500.00
.00
9,500.00
751.29
.00
5,505.34
3,994.66
58
7,703.90
8035
Maintenance Contracts/Lease
8,000.00
.00
8,000.00
1,318.00
.00
5,272.00
2,728.00
66
8,490.94
8045
Recording Fees
2,500.00
.00
2,500.00
38.75
.00
832.74
1,667.26
33
254.16
8050
Legal Notices
2,500.00
.00
2,500.00
236.50
.00
1,546.53
953.47
62
1,451.78
8065
Legal Fees
60,000.00
.00
60,000.00
.00
.00
20,419.25
39,580.75
34
33,700.86
8070
Public Relations
.00
.00
.00
.00
.00
201.66
(201.66)
+++
55.93
8135
Contractual Services
70,000.00
.00
70,000.00
12,754.39
.00
61,099.00
8,901.00
87
87,886.44
Run by Traci Pleckham on 01/19/2017 02:03:02 PM
Page 3 of 14
Budget Performance Report Fiscal Year to Date 12/31/16 Exclude Rollup Account
Account
Account Description
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Budget - YTD % Used/ Transactions
Rec'd
Prior Year Total
1,800.00
Fund 01 - General Fund EXPENSE Unit 04 - Administration/Finance Division 02 - Administration Program 8135.007
Tribute Memorial
.00
.00
.00
.00
.00
.00
.00
+++
8225
Engineering Fees
5,000.00
.00
5,000.00
2,283.20
.00
2,283.20
2,716.80
46
.00
9115
Office Furniture & Equipment
5,000.00
.00
5,000.00
.00
.00
3,965.08
1,034.92
79
1,474.76
9300
Contingencies Division 02 - Administration Program Totals
50,000.00
.00
50,000.00
.00
.00
11,500.00
38,500.00
23
36,483.28
$1,277,846.00
$0.00
$1,277,846.00
$128,743.66
$0.00
$814,815.46
$463,030.54
64%
$1,188,966.56
Division 03 - Community Relations Program 1005
Salaries-Full Time
97,225.00
.00
97,225.00
11,167.17
.00
66,912.26
30,312.74
69
94,785.54
2000
FICA
6,028.00
.00
6,028.00
652.28
.00
3,822.18
2,205.82
63
5,676.90
2001
Medicare
1,410.00
.00
1,410.00
152.56
.00
893.91
516.09
63
1,327.65
2010
IMRF
11,181.00
.00
11,181.00
1,256.31
.00
7,550.15
3,630.85
68
10,914.66
2020
Employee Insurance
19,919.00
.00
19,919.00
2,265.76
.00
13,469.90
6,449.10
68
17,614.89
2025
Deferred Comp. Contribution
4,000.00
.00
4,000.00
.00
.00
.00
4,000.00
0
3,515.82
3000
Travel/Training
1,500.00
.00
1,500.00
25.00
.00
142.50
1,357.50
10
164.21
4000
Telephone/Internet
500.00
.00
500.00
36.55
.00
241.90
258.10
48
327.96
5005
Office Supplies/Postage
2,000.00
.00
2,000.00
.00
.00
10.56
1,989.44
1
41.90
5015
Dues & Subscriptions
750.00
.00
750.00
.00
.00
525.00
225.00
70
135.50
5020
Gas/Oil/Mileage/Carwash
100.00
.00
100.00
.00
.00
.00
100.00
0
.00
8030
Server/Network Supplies
6,500.00
.00
6,500.00
.00
.00
.00
6,500.00
0
.00
8070
Public Relations
17,000.00
.00
17,000.00
2,301.37
.00
7,137.68
9,862.32
42
7,565.32
8071
Marketing and Promotions
2,500.00
.00
2,500.00
.00
.00
.00
2,500.00
0
1,200.00
8072
Settler's Park
8,500.00
.00
8,500.00
.00
.00
3,789.03
4,710.97
45
5,640.99
8135
Contractual Services
2,500.00
.00
2,500.00
.00
.00
.00
2,500.00
0
.00
$181,613.00
$0.00
$181,613.00
$17,857.00
$0.00
$104,495.07
$77,117.93
58%
$148,911.34
Division 03 - Community Relations Program Totals Division 04 - Facility Management Program 1005
Salaries-Full Time
32,865.00
.00
32,865.00
3,791.94
.00
23,381.40
9,483.60
71
32,855.54
1800
Salaries-Overtime
2,500.00
.00
2,500.00
1,067.71
.00
2,552.73
(52.73)
102
2,836.21
2000
FICA
2,193.00
.00
2,193.00
293.92
.00
1,546.31
646.69
71
2,121.91
2001
Medicare
513.00
.00
513.00
68.74
.00
361.69
151.31
71
496.28
2010
IMRF
4,067.00
.00
4,067.00
546.73
.00
2,917.65
1,149.35
72
4,036.28
2020
Employee Insurance
9,465.00
.00
9,465.00
1,133.76
.00
6,633.07
2,831.93
70
8,561.16
5000
Building Maintenance Supplies
7,000.00
.00
7,000.00
823.38
.00
4,254.67
2,745.33
61
5,084.22
8020
Building Maintenance
.00
.00
.00
.00
.00
.00
.00
+++
2,191.48
8135
Contractual Services
50,000.00
.00
50,000.00
3,236.10
.00
18,869.35
31,130.65
38
38,551.67
9105
Building Improvements Division 04 - Facility Management Program Totals
40,000.00
.00
40,000.00
.00
.00
.00
40,000.00
0
52,995.07
$148,603.00
$0.00
$148,603.00
$10,962.28
$0.00
$60,516.87
$88,086.13
41%
$149,729.82
181,654.00
.00
181,654.00
8,662.31
.00
94,335.47
87,318.53
52
174,346.84
Division 06 - Human Resources Program 1005
Salaries-Full Time
Run by Traci Pleckham on 01/19/2017 02:03:02 PM
Page 4 of 14
Budget Performance Report Fiscal Year to Date 12/31/16 Exclude Rollup Account
Account
Account Description
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Budget - YTD % Used/ Transactions
Rec'd
Prior Year Total
Fund 01 - General Fund EXPENSE Unit 04 - Administration/Finance Division 06 - Human Resources Program 1800
Salaries-Overtime
2000
FICA
500.00
.00
500.00
.00
.00
.00
500.00
0
.00
11,294.00
.00
11,294.00
291.30
.00
5,482.67
5,811.33
49
10,842.78
2001
Medicare
2010
IMRF
2,641.00
.00
2,641.00
68.13
.00
1,282.24
1,358.76
49
2,535.81
20,948.00
.00
20,948.00
974.51
.00
10,657.75
10,290.25
51
20,427.46
2020
Employee Insurance
2025
Deferred Comp. Contribution
39,020.00
.00
39,020.00
1,621.33
.00
17,030.87
21,989.13
44
24,373.36
7,200.00
.00
7,200.00
.00
.00
.00
7,200.00
0
3000
6,707.22
Travel/Training
6,000.00
.00
6,000.00
.00
.00
735.86
5,264.14
12
2,237.50
4000
Telephone/Internet
1,000.00
.00
1,000.00
73.11
.00
483.83
516.17
48
671.58
4005
Cellular Phones/Pagers
360.00
.00
360.00
.00
.00
120.00
240.00
33
360.00
5005
Office Supplies/Postage
1,500.00
.00
1,500.00
136.24
.00
615.79
884.21
41
901.82
5015
Dues & Subscriptions
3,200.00
.00
3,200.00
.00
.00
15.00
3,185.00
0
944.00
5020
Gas/Oil/Mileage/Carwash
1,400.00
.00
1,400.00
.00
.00
281.88
1,118.12
20
1,162.55
8070
Public Relations
12,000.00
.00
12,000.00
.00
.00
9,155.40
2,844.60
76
11,360.06
8071
Marketing and Promotions
300.00
.00
300.00
.00
.00
.00
300.00
0
.00
8135
Contractual Services
8,000.00
.00
8,000.00
1,622.50
.00
4,770.34
3,229.66
60
5,188.33
$297,017.00
$0.00
$297,017.00
$13,449.43
$0.00
$144,967.10
$152,049.90
49%
$262,059.31 221,230.80
Division 06 - Human Resources Program Totals Division 08 - IT Program 1005
Salaries-Full Time
223,829.00
.00
223,829.00
25,143.66
.00
153,126.29
70,702.71
68
1800
Salaries-Overtime
500.00
.00
500.00
.00
.00
178.60
321.40
36
.00
2000
FICA
13,877.00
.00
13,877.00
1,534.91
.00
9,293.65
4,583.35
67
13,385.87
2001
Medicare
3,246.00
.00
3,246.00
358.98
.00
2,173.52
1,072.48
67
3,130.55
2010
IMRF
25,740.00
.00
25,740.00
2,828.67
.00
17,246.86
8,493.14
67
25,241.42
2020
Employee Insurance
56,770.00
.00
56,770.00
4,729.71
.00
28,709.78
28,060.22
51
47,259.93
2025
Deferred Comp. Contribution
7,000.00
.00
7,000.00
.00
.00
.00
7,000.00
0
3,626.80
3000
Travel/Training
27,500.00
.00
27,500.00
436.80
13,760.00
4,388.81
9,351.19
66
8,995.30
4000
Telephone/Internet
500.00
.00
500.00
36.55
.00
241.89
258.11
48
327.96
4005
Cellular Phones/Pagers
1,840.00
.00
1,840.00
172.67
.00
1,202.79
637.21
65
2,084.58
5005
Office Supplies/Postage
1,400.00
.00
1,400.00
279.32
.00
474.70
925.30
34
923.54
5015
Dues & Subscriptions
400.00
.00
400.00
.00
.00
454.19
(54.19)
114
553.52
5020
Gas/Oil/Mileage/Carwash
400.00
.00
400.00
.00
.00
163.62
236.38
41
49.68
5095
Uniforms/Clothing
300.00
.00
300.00
.00
.00
.00
300.00
0
702.92
8030
Server/Network Supplies
8031
Software Licensing/Renewals
8135
Contractual Services
9111
Computers Division 08 - IT Program Totals
Run by Traci Pleckham on 01/19/2017 02:03:02 PM
32,850.00
.00
32,850.00
267.50
792.82
52,845.88
(20,788.70)
163
39,043.87
205,800.00
.00
205,800.00
26,983.55
16,283.56
208,445.49
(18,929.05)
109
191,734.01 12,761.10
8,550.00
.00
8,550.00
.00
.00
5,714.63
2,835.37
67
12,000.00
.00
12,000.00
.00
.00
2,377.52
9,622.48
20
11,069.74
$622,502.00
$0.00
$622,502.00
$62,772.32
$30,836.38
$487,038.22
$104,627.40
83%
$582,121.59
Page 5 of 14
Budget Performance Report Fiscal Year to Date 12/31/16 Exclude Rollup Account
Account
Account Description
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Budget - YTD % Used/ Transactions
Rec'd
Prior Year Total
Fund 01 - General Fund EXPENSE Unit 04 - Administration/Finance Division 99 - Transfers 9911
Transfer to Capital Improvements
.00
.00
.00
.00
.00
.00
.00
+++
2,378,289.00
Division 99 - Transfers Totals
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+++
$2,378,289.00
Unit 04 - Administration/Finance Totals
$6,586,473.00
$0.00
$6,586,473.00
$557,164.91
$44,341.38
$3,857,219.69
$2,684,911.93
59%
$8,496,152.84
Unit 05 - Police Department Division 02 - Administration Program 1005
Salaries-Full Time
293,527.00
.00
293,527.00
33,868.64
.00
205,476.16
88,050.84
70
291,464.17
1015
Salaries-Part Time
32,693.00
.00
32,693.00
1,891.76
.00
14,232.36
18,460.64
44
31,267.99
1800
Salaries-Overtime
3,500.00
.00
3,500.00
54.70
.00
797.03
2,702.97
23
978.28
2000
FICA
20,443.00
.00
20,443.00
1,273.74
.00
12,279.00
8,164.00
60
18,788.43
2001
Medicare
4,781.00
.00
4,781.00
506.07
.00
3,079.86
1,701.14
64
4,543.88
2010
IMRF
23,718.00
.00
23,718.00
2,314.89
.00
14,267.07
9,450.93
60
21,602.00
2020
Employee Insurance
65,734.00
.00
65,734.00
7,173.92
.00
43,406.93
22,327.07
66
61,577.18
2025
Deferred Comp. Contribution
8,000.00
.00
8,000.00
.00
.00
.00
8,000.00
0
7,601.11
3000
Travel/Training
10,150.00
.00
10,150.00
36.00
.00
2,550.36
7,599.64
25
5,022.79
3001
Education/School
12,000.00
.00
12,000.00
.00
.00
.00
12,000.00
0
2,000.00
3015
IL Unemployment Insurance
23,000.00
.00
23,000.00
.00
.00
7,977.50
15,022.50
35
17,243.86
4000
Telephone/Internet
1,610.00
.00
1,610.00
117.54
.00
791.42
818.58
49
1,082.45
4005
Cellular Phones/Pagers
1,200.00
.00
1,200.00
186.67
.00
701.82
498.18
58
1,117.11
5005
Office Supplies/Postage
11,950.00
.00
11,950.00
617.53
.00
3,228.79
8,721.21
27
5,103.38
5010
Replacement Supplies
1,700.00
.00
1,700.00
295.52
.00
(60.05)
1,760.05
-4
1,095.70
5015
Dues & Subscriptions
7,050.00
.00
7,050.00
.00
.00
2,980.00
4,070.00
42
4,280.00
5020
Gas/Oil/Mileage/Carwash
3,700.00
.00
3,700.00
155.52
.00
1,054.96
2,645.04
29
1,126.92
5095
Uniforms/Clothing
1,800.00
.00
1,800.00
579.08
.00
1,068.13
731.87
59
1,601.20
8035
Maintenance Contracts/Lease
7,190.00
.00
7,190.00
1,132.00
.00
4,152.00
3,038.00
58
6,104.15
8040
Custodian
70,000.00
.00
70,000.00
2,521.91
.00
24,151.54
45,848.46
35
78,776.98
8060
Vehicle Maintenance
2,500.00
.00
2,500.00
.00
.00
105.70
2,394.30
4
316.29
8135
Contractual Services
8,000.00
.00
8,000.00
501.00
.00
1,312.93
6,687.07
16
5,563.84
$614,246.00
$0.00
$614,246.00
$53,226.49
$0.00
$343,553.51
$270,692.49
56%
$568,257.71
Division 02 - Administration Program Totals Division 51 - Police Operations 1005
Salaries-Full Time
3,442,372.00
.00
3,442,372.00
393,506.20
.00
2,304,233.26
1,138,138.74
67
3,124,053.52
1800
Salaries-Overtime
380,000.00
.00
380,000.00
42,915.74
.00
195,575.27
184,424.73
51
376,622.49
2000
FICA
237,700.00
.00
237,700.00
24,482.73
.00
146,386.19
91,313.81
62
202,400.77
2001
Medicare
55,591.00
.00
55,591.00
6,230.93
.00
34,981.88
20,609.12
63
48,109.13
2010
IMRF
6,720.00
.00
6,720.00
726.93
.00
4,378.16
2,341.84
65
6,234.94
2011
Employer Pension Contributions
1,100,000.00
.00
1,100,000.00
9,668.47
.00
1,101,142.15
(1,142.15)
100
948,548.76
2020
Employee Insurance
579,738.00
.00
579,738.00
62,239.34
.00
367,973.67
211,764.33
63
512,322.55
2025
Deferred Comp. Contribution
85,000.00
.00
85,000.00
.00
.00
.00
85,000.00
0
80,676.15
Run by Traci Pleckham on 01/19/2017 02:03:02 PM
Page 6 of 14
Budget Performance Report Fiscal Year to Date 12/31/16 Exclude Rollup Account
Account
Account Description
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Budget - YTD % Used/ Transactions
Rec'd
Prior Year Total
Fund 01 - General Fund EXPENSE Unit 05 - Police Department Division 51 - Police Operations 3000
Travel/Training
48,916.00
.00
48,916.00
151.00
.00
20,635.06
28,280.94
42
39,387.80
4000
Telephone/Internet
29,070.00
.00
29,070.00
2,635.35
.00
15,606.41
13,463.59
54
24,054.83
4005
Cellular Phones/Pagers
6,300.00
.00
6,300.00
434.74
.00
3,086.94
3,213.06
49
5,791.88
5005
Office Supplies/Postage
13,000.00
.00
13,000.00
2,181.90
.00
7,017.85
5,982.15
54
11,384.89
5010
Replacement Supplies
15,500.00
.00
15,500.00
.00
.00
6,185.75
9,314.25
40
13,264.77
5015
Dues & Subscriptions
2,900.00
.00
2,900.00
.00
.00
929.00
1,971.00
32
1,893.00
5020
Gas/Oil/Mileage/Carwash
110,000.00
.00
110,000.00
5,738.32
.00
41,628.15
68,371.85
38
60,578.29
5068
K-9 Unit
4,000.00
.00
4,000.00
10.00
.00
1,946.21
2,053.79
49
5,195.30
5095
Uniforms/Clothing
35,000.00
.00
35,000.00
1,842.23
.00
17,779.18
17,220.82
51
34,251.79
5100
Ammunition/Weapons
25,000.00
.00
25,000.00
564.36
.00
11,012.22
13,987.78
44
26,300.41
5115.001
Traffic Programs
23,000.00
.00
23,000.00
930.00
.00
16,304.71
6,695.29
71
9,481.63
8003
Radio Maintenance
1,200.00
.00
1,200.00
.00
.00
272.00
928.00
23
.00
8035
Maintenance Contracts/Lease
9,542.00
.00
9,542.00
6,742.00
.00
9,718.00
(176.00)
102
6,937.00
8060
Vehicle Maintenance
46,000.00
.00
46,000.00
7,693.36
.00
44,496.91
1,503.09
97
42,543.12
8069
Bike Unit
2,000.00
.00
2,000.00
.00
.00
.00
2,000.00
0
1,536.82
8135
Contractual Services
.00
.00
.00
1,417.00
.00
13,978.92
(13,978.92)
+++
.00
8265
Contractual Services-Wescom
593,000.00
.00
593,000.00
47,070.13
.00
423,631.17
169,368.83
71
591,023.28
$6,851,549.00
$0.00
$6,851,549.00
$617,180.73
$0.00
$4,788,899.06
$2,062,649.94
70%
$6,172,593.12
Division 51 - Police Operations Totals Division 52 - Police Administration 1005
Salaries-Full Time
1,334,890.00
.00
1,334,890.00
150,501.19
.00
893,475.46
441,414.54
67
1,255,761.72
1800
Salaries-Overtime
128,000.00
.00
128,000.00
8,194.17
.00
78,956.35
49,043.65
62
119,924.62
2000
FICA
90,699.00
.00
90,699.00
8,911.96
.00
58,084.40
32,614.60
64
84,119.64
2001
Medicare
21,212.00
.00
21,212.00
2,302.89
.00
13,802.91
7,409.09
65
19,673.09
2020
Employee Insurance
212,634.00
.00
212,634.00
25,688.52
.00
152,252.74
60,381.26
72
196,175.41
2025
Deferred Comp. Contribution
40,000.00
.00
40,000.00
.00
.00
.00
40,000.00
0
40,169.63
3000
Travel/Training
11,740.00
.00
11,740.00
76.00
.00
13,075.62
(1,335.62)
111
12,820.56
4000
Telephone/Internet
2,070.00
.00
2,070.00
146.71
.00
979.10
1,090.90
47
1,365.52
4005
Cellular Phones/Pagers
11,280.00
.00
11,280.00
671.87
.00
4,679.98
6,600.02
41
8,945.48
5005
Office Supplies/Postage
10,000.00
.00
10,000.00
419.86
.00
3,104.82
6,895.18
31
5,014.00
5010
Replacement Supplies
5,000.00
.00
5,000.00
.00
.00
.00
5,000.00
0
4,422.85
5015
Dues & Subscriptions
4,070.00
.00
4,070.00
.00
.00
2,145.00
1,925.00
53
3,535.00
5020
Gas/Oil/Mileage/Carwash
29,000.00
.00
29,000.00
1,885.71
.00
13,334.19
15,665.81
46
19,023.55
5040.002
Crime Scene/Evidence Tech Supply
7,000.00
.00
7,000.00
.00
.00
3,673.82
3,326.18
52
4,381.92
5095
Uniforms/Clothing
8,950.00
.00
8,950.00
3,600.00
.00
8,880.89
69.11
99
12,751.59
5115.004
Community Programs-Explorer Program
2,500.00
.00
2,500.00
160.00
.00
2,492.77
7.23
100
1,455.22
8003
Radio Maintenance
500.00
.00
500.00
.00
.00
.00
500.00
0
.00
8035
Maintenance Contracts/Lease
8,920.00
.00
8,920.00
1,807.87
.00
3,499.77
5,420.23
39
3,669.04
Run by Traci Pleckham on 01/19/2017 02:03:02 PM
Page 7 of 14
Budget Performance Report Fiscal Year to Date 12/31/16 Exclude Rollup Account
Account
Account Description
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Budget - YTD % Used/ Transactions
Rec'd
Prior Year Total
Fund 01 - General Fund EXPENSE Unit 05 - Police Department Division 52 - Police Administration 8060
Vehicle Maintenance
15,250.00
.00
15,250.00
678.46
.00
6,542.69
8,707.31
43
11,793.39
8250
Background Check Services
2,500.00
.00
2,500.00
.00
.00
410.00
2,090.00
16
3,738.84
8268
Accreditation
8,070.00
.00
8,070.00
2,119.71
.00
8,436.68
(366.68)
105
4,065.00
$1,954,285.00
$0.00
$1,954,285.00
$207,164.92
$0.00
$1,267,827.19
$686,457.81
65%
$1,812,806.07 392,281.41
Division 52 - Police Administration Totals Division 53 - Police Records 1005
Salaries-Full Time
400,739.00
.00
400,739.00
46,239.38
.00
277,060.28
123,678.72
69
1800
Salaries-Overtime
6,000.00
.00
6,000.00
142.71
.00
5,751.53
248.47
96
3,368.57
2000
FICA
25,218.00
.00
25,218.00
2,798.95
.00
16,974.63
8,243.37
67
23,683.49
2001
Medicare
2010
IMRF
2020
Employee Insurance
2025
Deferred Comp. Contribution
3000
5,898.00
.00
5,898.00
659.73
.00
3,975.03
1,922.97
67
5,538.88
35,630.00
.00
35,630.00
3,792.42
.00
22,830.97
12,799.03
64
32,505.65
124,382.00
.00
124,382.00
13,977.70
.00
84,017.18
40,364.82
68
115,948.23
15,000.00
.00
15,000.00
.00
.00
.00
15,000.00
0
12,396.50
Travel/Training
2,100.00
.00
2,100.00
91.34
.00
1,447.94
652.06
69
2,025.16
4000
Telephone/Internet
2,070.00
.00
2,070.00
146.71
.00
979.10
1,090.90
47
1,365.52
5005
Office Supplies/Postage
13,450.00
.00
13,450.00
805.88
.00
4,028.47
9,421.53
30
9,485.89
5015
Dues & Subscriptions
425.00
.00
425.00
.00
.00
75.00
350.00
18
124.00
5095
Uniforms/Clothing
2,400.00
.00
2,400.00
702.31
.00
1,187.46
1,212.54
49
2,523.83
8035
Maintenance Contracts/Lease Division 53 - Police Records Totals
4,460.00
.00
4,460.00
360.00
.00
1,440.00
3,020.00
32
6,025.00
$637,772.00
$0.00
$637,772.00
$69,717.13
$0.00
$419,767.59
$218,004.41
66%
$607,272.13
Division 54 - Seizure/Forfeiture 5012
Asset Seizure/Forfeiture Expense Division 54 - Seizure/Forfeiture Totals
180,000.00
.00
180,000.00
32,480.50
120,221.00
112,505.71
(52,726.71)
129
137,908.02
$180,000.00
$0.00
$180,000.00
$32,480.50
$120,221.00
$112,505.71
($52,726.71)
129%
$137,908.02
32,513.00
.00
32,513.00
2,895.00
.00
34,472.50
(1,959.50)
106
35,418.75
2,016.00
.00
2,016.00
158.20
.00
1,963.03
52.97
97
2,120.05
471.00
.00
471.00
40.39
.00
466.28
4.72
99
500.03
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00
0
.00
$36,000.00
$0.00
$36,000.00
$3,093.59
$0.00
$36,901.81
($901.81)
103%
$38,038.83
Division 55 - Police Special Activities 1005.061
Salaries-Special Activities
2000
FICA
2001
Medicare
5045
Mobile Field Force Division 55 - Police Special Activities Totals Division 56 - Community Services
1005
Salaries-Full Time
559,103.00
.00
559,103.00
63,765.94
.00
384,138.15
174,964.85
69
523,444.08
1015
Salaries-Part Time
245,000.00
.00
245,000.00
22,319.25
.00
138,736.10
106,263.90
57
203,675.01
1800
Salaries-Overtime
30,000.00
.00
30,000.00
1,936.41
.00
21,839.38
8,160.62
73
30,883.91
2000
FICA
53,110.00
.00
53,110.00
5,195.82
.00
32,891.49
20,218.51
62
46,278.05
2001
Medicare
12,421.00
.00
12,421.00
1,252.64
.00
7,729.85
4,691.15
62
10,823.10
2010
IMRF
57,849.00
.00
57,849.00
5,403.95
.00
33,802.45
24,046.55
58
46,701.37
2020
Employee Insurance
100,609.00
.00
100,609.00
13,989.56
.00
80,884.56
19,724.44
80
93,887.50
2025
Deferred Comp. Contribution
7,500.00
.00
7,500.00
.00
.00
.00
7,500.00
0
6,882.84
Run by Traci Pleckham on 01/19/2017 02:03:02 PM
Page 8 of 14
Budget Performance Report Fiscal Year to Date 12/31/16 Exclude Rollup Account
Account
Account Description
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Budget - YTD % Used/ Transactions
Rec'd
Prior Year Total
Fund 01 - General Fund EXPENSE Unit 05 - Police Department Division 56 - Community Services 3000
Travel/Training
12,020.00
.00
12,020.00
15.00
.00
8,157.24
3,862.76
68
9,872.27
4000
Telephone/Internet
2,070.00
.00
2,070.00
146.71
.00
979.10
1,090.90
47
1,364.99
4005
Cellular Phones/Pagers
3,280.00
.00
3,280.00
211.39
.00
1,610.92
1,669.08
49
2,709.78
5005
Office Supplies/Postage
3,000.00
.00
3,000.00
294.36
.00
1,547.76
1,452.24
52
2,842.45
5010
Replacement Supplies
3,700.00
.00
3,700.00
172.10
.00
494.78
3,205.22
13
1,582.10
5015
Dues & Subscriptions
3,050.00
.00
3,050.00
50.00
.00
1,343.00
1,707.00
44
1,476.50
5020
Gas/Oil/Mileage/Carwash
25,000.00
.00
25,000.00
1,122.85
.00
10,046.19
14,953.81
40
14,963.16
5095
Uniforms/Clothing
6,700.00
.00
6,700.00
342.05
.00
5,685.39
1,014.61
85
11,607.13
5115.002
Community Programs
7,000.00
.00
7,000.00
872.00
.00
3,205.86
3,794.14
46
4,140.92
5115.003
Community Prog.-Alcohol/Tobacco
5,100.00
.00
5,100.00
.00
.00
120.30
4,979.70
2
76.49
8003
Radio Maintenance
50,000.00
.00
50,000.00
2,710.84
.00
21,138.84
28,861.16
42
33,052.59
8035
Maintenance Contracts/Lease
10,000.00
.00
10,000.00
147.00
.00
1,022.50
8,977.50
10
49.00
8060
Vehicle Maintenance
14,000.00
.00
14,000.00
3,451.61
.00
17,667.31
(3,667.31)
126
21,218.11
8245
D.A.R.E. Program
5,000.00
.00
5,000.00
.00
.00
1,983.00
3,017.00
40
4,828.54
8246
Shop with a Cop
4,000.00
.00
4,000.00
.00
.00
9,500.00
(5,500.00)
238
11,022.00
8266
Chaplaincy Program
1,752.97
8267
Animal Control Division 56 - Community Services Totals
4,600.00
.00
4,600.00
.00
.00
1,021.40
3,578.60
22
14,000.00
.00
14,000.00
.00
.00
5,940.00
8,060.00
42
7,130.00
$1,238,112.00
$0.00
$1,238,112.00
$123,399.48
$0.00
$791,485.57
$446,626.43
64%
$1,092,264.86
Division 57 - Court Services 1005
Salaries-Full Time
118,743.00
.00
118,743.00
13,701.15
.00
83,678.76
35,064.24
70
116,283.23
1015
Salaries-Part Time
46,253.00
.00
46,253.00
4,831.26
.00
29,260.23
16,992.77
63
43,771.89
1800
Salaries-Overtime
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00
0
.00
2000
FICA
10,292.00
.00
10,292.00
1,122.81
.00
6,811.32
3,480.68
66
9,618.38
2001
Medicare
2,407.00
.00
2,407.00
262.60
.00
1,592.99
814.01
66
2,249.44
2010
IMRF
19,920.00
.00
19,920.00
2,084.91
.00
12,750.68
7,169.32
64
18,149.46
2020
Employee Insurance
38,118.00
.00
38,118.00
4,586.80
.00
27,217.36
10,900.64
71
35,705.27
2025
Deferred Comp. Contribution
5,000.00
.00
5,000.00
.00
.00
.00
5,000.00
0
4,773.04
3000
Travel/Training
3,000.00
.00
3,000.00
50.00
.00
129.00
2,871.00
4
1,032.22
4000
Telephone/Internet
1,610.00
.00
1,610.00
117.51
.00
791.53
818.47
49
1,082.39
5005
Office Supplies/Postage
11,625.00
.00
11,625.00
751.58
.00
3,923.01
7,701.99
34
8,116.13
5015
Dues & Subscriptions
8,800.00
.00
8,800.00
458.95
.00
4,743.20
4,056.80
54
8,712.63
5095
Uniforms/Clothing
900.00
.00
900.00
177.99
.00
177.99
722.01
20
651.19
8035
Maintenance Contracts/Lease
1,920.00
.00
1,920.00
320.00
.00
1,280.00
640.00
67
1,693.00
8065
Legal Fees Division 57 - Court Services Totals
20,000.00
.00
20,000.00
300.00
4,000.00
2,322.50
13,677.50
32
3,325.00
$289,588.00
$0.00
$289,588.00
$28,765.56
$4,000.00
$174,678.57
$110,909.43
62%
$255,163.27
6,000.00
.00
6,000.00
.00
.00
1,909.83
4,090.17
32
967.18
Division 91 - Capital 9115
Office Furniture & Equipment
Run by Traci Pleckham on 01/19/2017 02:03:02 PM
Page 9 of 14
Budget Performance Report Fiscal Year to Date 12/31/16 Exclude Rollup Account
Account
Account Description
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Budget - YTD % Used/ Transactions
Rec'd
Prior Year Total
Fund 01 - General Fund EXPENSE Unit 05 - Police Department Division 91 - Capital 9120
Machinery and Equipment
42,780.00
.00
42,780.00
2,089.77
2,089.77
2,089.77
38,600.46
10
21,242.00
Division 91 - Capital Totals
$48,780.00
$0.00
$48,780.00
$2,089.77
$2,089.77
$3,999.60
$42,690.63
12%
$22,209.18
12,700.00
.00
12,700.00
588.40
.00
8,118.45
4,581.55
64
6,300.03
Division 93 - Contingencies Totals
$12,700.00
$0.00
$12,700.00
$588.40
$0.00
$8,118.45
$4,581.55
64%
$6,300.03
Unit 05 - Police Department Totals
$11,863,032.00
$0.00
$11,863,032.00
$1,137,706.57
$126,310.77
$7,947,737.06
$3,788,984.17
68%
$10,712,813.22
Division 93 - Contingencies 9300
Contingencies
Unit 07 - PEMA Division 07 - PEMA Program 1005
Salaries-Full Time
125,000.00
.00
125,000.00
13,931.46
.00
87,248.64
37,751.36
70
121,919.56
2000
FICA
7,750.00
.00
7,750.00
320.31
.00
4,746.03
3,003.97
61
7,408.46
2001
Medicare
1,813.00
.00
1,813.00
198.16
.00
1,233.21
579.79
68
1,747.38
2020
Employee Insurance
20,988.00
.00
20,988.00
2,265.76
.00
13,269.90
7,718.10
63
17,319.79
2025
Deferred Comp. Contribution
4,000.00
.00
4,000.00
.00
.00
.00
4,000.00
0
3,965.30
3000
Travel/Training
4,000.00
.00
4,000.00
25.00
.00
201.80
3,798.20
5
600.00
4000
Telephone/Internet
780.00
.00
780.00
447.25
.00
3,246.79
(2,466.79)
416
4,994.85
4005
Cellular Phones/Pagers
5,200.00
.00
5,200.00
294.12
.00
2,013.29
3,186.71
39
3,228.42
5005
Office Supplies/Postage
1,300.00
.00
1,300.00
.00
.00
302.76
997.24
23
619.91
5010
Replacement Supplies
11,000.00
.00
11,000.00
.00
.00
541.87
10,458.13
5
5,223.60
5015
Dues & Subscriptions
5020
Gas/Oil/Mileage/Carwash
5040
3,000.00
.00
3,000.00
.00
.00
1,557.27
1,442.73
52
2,328.50
12,000.00
.00
12,000.00
321.99
.00
3,468.59
8,531.41
29
5,907.43
Supplies/Hardware
2,000.00
.00
2,000.00
29.82
.00
75.81
1,924.19
4
439.38
5040.001
Supplies/Hardware-ESDA
2,000.00
.00
2,000.00
.00
.00
195.12
1,804.88
10
29.05
5095
Uniforms/Clothing
5,000.00
.00
5,000.00
20.24
.00
1,230.02
3,769.98
25
2,104.54
5110
Emergency Operation Center
5115
Police Public Relations
5120
Disaster Plan/Exercises/NIMS
8003
Radio Maintenance
8035
Maintenance Contracts/Lease
8060
Vehicle Maintenance
8069
Bike Unit
8125
Siren Maintenance
8135 8280
750.00
.00
750.00
.00
.00
.00
750.00
0
.00
2,000.00
.00
2,000.00
.00
.00
.00
2,000.00
0
22,000.00 783.67
3,000.00
.00
3,000.00
.00
.00
.00
3,000.00
0
10,000.00
.00
10,000.00
.00
(2,818.00)
3,017.99
9,800.01
2
.00
1,800.00
.00
1,800.00
217.53
.00
902.37
897.63
50
2,004.44
15,000.00
.00
15,000.00
1,479.45
.00
10,082.85
4,917.15
67
11,752.22
500.00
.00
500.00
.00
.00
.00
500.00
0
.00
20,000.00
.00
20,000.00
279.18
.00
7,687.64
12,312.36
38
9,322.22
Contractual Services
5,250.00
.00
5,250.00
.00
.00
.00
5,250.00
0
.00
Cadet Program
5,500.00
.00
5,500.00
.00
.00
2,153.47
3,346.53
39
3,644.34
8305
PEMA Search and Rescue
8,000.00
.00
8,000.00
.00
.00
.00
8,000.00
0
307.51
9115
Office Furniture & Equipment
2,000.00
.00
2,000.00
.00
.00
683.52
1,316.48
34
.00
9120
Machinery and Equipment
5,000.00
.00
5,000.00
.00
.00
474.99
4,525.01
9
1,734.52
9300
Contingencies
3,000.00
.00
3,000.00
.00
.00
19.09
2,980.91
1
898.44
Run by Traci Pleckham on 01/19/2017 02:03:02 PM
Page 10 of 14
Budget Performance Report Fiscal Year to Date 12/31/16 Exclude Rollup Account
Account
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions
Rec'd
Prior Year Total
Division 07 - PEMA Program Totals
$287,631.00
$0.00
$287,631.00
$19,830.27
($2,818.00)
$144,353.02
$146,095.98
49%
$230,283.53
Unit 07 - PEMA Totals
$287,631.00
$0.00
$287,631.00
$19,830.27
($2,818.00)
$144,353.02
$146,095.98
49%
$230,283.53
266,745.74
Account Description
Budget - YTD % Used/
Fund 01 - General Fund EXPENSE Unit 07 - PEMA
Unit 08 - Street Department Division 02 - Administration Program 1005
Salaries-Full Time
279,953.00
.00
279,953.00
31,179.79
.00
186,875.21
93,077.79
67
1015
Salaries-Part Time
.00
.00
.00
.00
.00
4,480.00
(4,480.00)
+++
.00
2000
FICA
17,360.00
.00
17,360.00
1,682.48
.00
11,226.39
6,133.61
65
16,112.88
2001
Medicare
4,060.00
.00
4,060.00
471.33
.00
2,783.47
1,276.53
69
3,835.21
2010
IMRF
32,195.00
.00
32,195.00
3,736.42
.00
21,761.78
10,433.22
68
30,944.29
2020
Employee Insurance
54,449.00
.00
54,449.00
6,374.90
.00
37,551.97
16,897.03
69
48,313.19
2025
Deferred Comp. Contribution
7,000.00
.00
7,000.00
.00
.00
.00
7,000.00
0
7,244.29
3000
Travel/Training
10,000.00
.00
10,000.00
.00
.00
7,472.41
2,527.59
75
7,900.85
3015
IL Unemployment Insurance
4,000.00
.00
4,000.00
.00
.00
1,645.02
2,354.98
41
3,226.35
4000
Telephone/Internet
15,000.00
.00
15,000.00
3,014.27
.00
13,845.83
1,154.17
92
18,337.63
4005
Cellular Phones/Pagers
7,000.00
.00
7,000.00
774.70
.00
4,249.29
2,750.71
61
7,841.04
5005
Office Supplies/Postage
2,500.00
.00
2,500.00
407.09
.00
1,663.75
836.25
67
2,279.71
5015
Dues & Subscriptions
3,000.00
.00
3,000.00
.00
.00
1,239.69
1,760.31
41
2,456.65
5020
Gas/Oil/Mileage/Carwash
300.00
.00
300.00
.00
.00
40.00
260.00
13
62.00
5040
Supplies/Hardware
500.00
.00
500.00
.00
.00
.00
500.00
0
.00
8003
Radio Maintenance
100.00
.00
100.00
.00
.00
.00
100.00
0
.00
8020
Building Maintenance
15,000.00
.00
15,000.00
496.75
.00
2,861.01
12,138.99
19
20,275.42
8050
Legal Notices
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00
0
337.58
8135
Contractual Services
.00
.00
.00
.00
.00
238.15
(238.15)
+++
624.52
$453,417.00
$0.00
$453,417.00
$48,137.73
$0.00
$297,933.97
$155,483.03
66%
$436,537.35
Division 02 - Administration Program Totals Division 60 - Street Maintenance Program 1005
Salaries-Full Time
718,000.00
.00
718,000.00
80,518.66
.00
497,856.78
220,143.22
69
706,707.73
1015
Salaries-Part Time
75,000.00
.00
75,000.00
1,360.00
.00
56,033.19
18,966.81
75
63,692.00
1800
Salaries-Overtime
80,000.00
.00
80,000.00
24,986.45
.00
80,215.79
(215.79)
100
86,809.19
2000
FICA
54,126.00
.00
54,126.00
6,241.04
.00
37,743.59
16,382.41
70
51,294.79
2001
Medicare
12,660.00
.00
12,660.00
1,459.58
.00
8,827.07
3,832.93
70
11,996.43
2010
IMRF
94,500.00
.00
94,500.00
11,404.56
.00
64,220.88
30,279.12
68
89,457.49
2020
Employee Insurance
167,141.00
.00
167,141.00
20,366.61
.00
125,254.85
41,886.15
75
164,733.79
2025
Deferred Comp. Contribution
4015
Electricity/Gas
5005 5010 5020 5040
19,900.00
.00
19,900.00
.00
.00
.00
19,900.00
0
18,734.50
290,000.00
.00
290,000.00
14,183.95
.00
101,057.20
188,942.80
35
318,227.20
Office Supplies/Postage
.00
.00
.00
49.00
.00
49.00
(49.00)
+++
.00
Replacement Supplies
.00
.00
.00
.00
.00
271.22
(271.22)
+++
.00
Gas/Oil/Mileage/Carwash
85,000.00
.00
85,000.00
1,007.58
.00
30,505.35
54,494.65
36
36,489.73
Supplies/Hardware
15,000.00
.00
15,000.00
541.66
.00
9,355.70
5,644.30
62
13,852.15
Run by Traci Pleckham on 01/19/2017 02:03:02 PM
Page 11 of 14
Budget Performance Report Fiscal Year to Date 12/31/16 Exclude Rollup Account
Account
Account Description
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Budget - YTD % Used/ Transactions
Rec'd
Prior Year Total
200,000.00
.00
200,000.00
45,832.07
.00
90,992.75
109,007.25
45
281,779.71
20,000.00
.00
20,000.00
5,223.10
.00
15,862.67
4,137.33
79
26,158.09
Fund 01 - General Fund EXPENSE Unit 08 - Street Department Division 60 - Street Maintenance Program 5040.003
Supplies/Hardware-Salt Purchase
5055
Street Sign Maintenance
5060
Aggregate Materials
4,000.00
.00
4,000.00
253.32
.00
639.56
3,360.44
16
3,959.90
5095
Uniforms/Clothing
9,000.00
.00
9,000.00
1,417.55
.00
5,670.47
3,329.53
63
10,512.31
8003
Radio Maintenance
8060
Vehicle Maintenance
8130
Street Light Maintenance
8131
Street Maintenance
8132
5,000.00
.00
5,000.00
.00
.00
1,618.60
3,381.40
32
2,883.80
35,000.00
.00
35,000.00
201.75
.00
13,858.75
21,141.25
40
33,721.60
90,000.00
.00
90,000.00
4,681.87
.00
49,608.45
40,391.55
55
116,110.32
130,000.00
.00
130,000.00
3,099.26
.00
53,911.14
76,088.86
41
132,611.04
Storm Sewer Improvements
10,000.00
.00
10,000.00
313.00
.00
890.85
9,109.15
9
10,798.05
8135
Contractual Services
90,000.00
.00
90,000.00
16,889.37
.00
98,021.50
(8,021.50)
109
81,072.28
8135.004
Snow Removal
280,000.00
.00
280,000.00
2,444.50
.00
2,482.13
277,517.87
1
143,542.76
8150
Sidewalk Maintenance
8160
Equipment Maintenance Division 60 - Street Maintenance Program Totals
5,000.00
.00
5,000.00
.00
.00
1,496.87
3,503.13
30
1,565.75
90,000.00
.00
90,000.00
4,728.13
.00
39,955.77
50,044.23
44
99,655.81
$2,579,327.00
$0.00
$2,579,327.00
$247,203.01
$0.00
$1,386,400.13
$1,192,926.87
54%
$2,506,366.42
Division 62 - Forestry Program 1005
Salaries-Full Time
76,660.00
.00
76,660.00
5,200.42
.00
36,573.09
40,086.91
48
64,225.69
1800
Salaries-Overtime
6,000.00
.00
6,000.00
352.23
.00
5,550.95
449.05
93
3,748.14
2000
FICA
5,125.00
.00
5,125.00
467.48
.00
2,673.61
2,451.39
52
4,338.19
2001
Medicare
1,199.00
.00
1,199.00
109.34
.00
625.28
573.72
52
1,014.49
2010
IMRF
8,816.00
.00
8,816.00
860.71
.00
4,985.09
3,830.91
57
8,171.30
2020
Employee Insurance
19,648.00
.00
19,648.00
791.83
.00
8,969.52
10,678.48
46
16,919.65
2025
Deferred Comp. Contribution
3,000.00
.00
3,000.00
.00
.00
.00
3,000.00
0
1,892.00
5015
Dues & Subscriptions
.00
.00
.00
.00
.00
565.00
(565.00)
+++
.00
5040
Supplies/Hardware
6,000.00
.00
6,000.00
118.98
.00
2,240.23
3,759.77
37
8,315.50
5095
Uniforms/Clothing
500.00
.00
500.00
.00
.00
.00
500.00
0
435.60
8135
Contractual Services
5,000.00
.00
5,000.00
.00
.00
1,198.15
3,801.85
24
5,770.00
8135.002
Tree Removal Division 62 - Forestry Program Totals
40,000.00
.00
40,000.00
1,738.00
.00
9,890.00
30,110.00
25
50,749.00
$171,948.00
$0.00
$171,948.00
$9,638.99
$0.00
$73,270.92
$98,677.08
43%
$165,579.56 179,082.56
Division 63 - Vehicle Maintenance Program 1005
Salaries-Full Time
181,100.00
.00
181,100.00
20,886.32
.00
127,315.48
53,784.52
70
1800
Salaries-Overtime
8,000.00
.00
8,000.00
1,529.13
.00
2,245.49
5,754.51
28
5,312.58
2000
FICA
11,724.00
.00
11,724.00
1,346.10
.00
7,651.04
4,072.96
65
10,944.43
2001
Medicare
2,741.00
.00
2,741.00
314.79
.00
1,789.35
951.65
65
2,559.64
2010
IMRF
21,250.00
.00
21,250.00
2,521.76
.00
14,575.69
6,674.31
69
21,066.93
2020
Employee Insurance
42,501.00
.00
42,501.00
4,419.50
.00
27,003.42
15,497.58
64
39,895.33
2025
Deferred Comp. Contribution
7,500.00
.00
7,500.00
.00
.00
.00
7,500.00
0
6,178.47
$274,816.00
$0.00
$274,816.00
$31,017.60
$0.00
$180,580.47
$94,235.53
66%
$265,039.94
Division 63 - Vehicle Maintenance Program Totals
Run by Traci Pleckham on 01/19/2017 02:03:02 PM
Page 12 of 14
Budget Performance Report Fiscal Year to Date 12/31/16 Exclude Rollup Account
Account
Account Description
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Budget - YTD % Used/ Transactions
Rec'd
Prior Year Total
$3,479,508.00
$0.00
$3,479,508.00
$335,997.33
$0.00
$1,938,185.49
$1,541,322.51
56%
$3,373,523.27
Fund 01 - General Fund EXPENSE Unit 08 - Street Department Totals Unit 09 - Community Development Division 20 - Planning Program 1005
Salaries-Full Time
360,000.00
.00
360,000.00
36,929.51
.00
178,629.18
181,370.82
50
252,076.02
1045
Salaries-Commissioner
4,000.00
.00
4,000.00
155.00
.00
1,685.00
2,315.00
42
2,640.00
1800
Salaries-Overtime
2,500.00
.00
2,500.00
305.49
.00
1,513.62
986.38
61
1,853.66
2000
FICA
22,723.00
.00
22,723.00
2,280.94
.00
10,997.21
11,725.79
48
15,884.11
2001
Medicare
5,315.00
.00
5,315.00
533.44
.00
2,571.95
2,743.05
48
3,714.80
2010
IMRF
43,500.00
.00
43,500.00
4,188.95
.00
20,288.55
23,211.45
47
29,399.02
2020
Employee Insurance
77,086.00
.00
77,086.00
6,984.97
.00
38,117.62
38,968.38
49
49,086.03
2025
Deferred Comp. Contribution
11,500.00
.00
11,500.00
.00
.00
.00
11,500.00
0
6,377.51
3000
Travel/Training
7,000.00
.00
7,000.00
25.00
.00
1,582.00
5,418.00
23
1,795.09
3015
IL Unemployment Insurance
1,000.00
.00
1,000.00
.00
.00
257.64
742.36
26
627.89
4000
Telephone/Internet
4,000.00
.00
4,000.00
182.77
.00
1,209.54
2,790.46
30
1,684.07
4005
Cellular Phones/Pagers
2,000.00
.00
2,000.00
72.98
.00
801.70
1,198.30
40
1,081.77
5005
Office Supplies/Postage
10,000.00
.00
10,000.00
1,379.38
.00
7,254.43
2,745.57
73
10,614.13
5015
Dues & Subscriptions
3,000.00
.00
3,000.00
285.00
.00
1,144.00
1,856.00
38
1,349.96
5020
Gas/Oil/Mileage/Carwash
750.00
.00
750.00
.00
.00
.00
750.00
0
.00
5065
Software
500.00
.00
500.00
.00
.00
.00
500.00
0
.00
8035
Maintenance Contracts/Lease
5,000.00
.00
5,000.00
100.00
.00
400.00
4,600.00
8
1,459.94
8060
Vehicle Maintenance
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00
0
.00
8065
Legal Fees
5,000.00
.00
5,000.00
.00
.00
2,012.75
2,987.25
40
253.50
8097
Special Projects and Programs
15,000.00
.00
15,000.00
833.33
.00
2,042.61
12,957.39
14
.00
8135
Contractual Services
35,000.00
.00
35,000.00
.00
.00
1,691.84
33,308.16
5
332.50
8225
Engineering Fees Division 20 - Planning Program Totals
10,000.00
.00
10,000.00
.00
.00
3,365.00
6,635.00
34
170.00
$625,874.00
$0.00
$625,874.00
$54,256.76
$0.00
$275,564.64
$350,309.36
44%
$380,400.00
Division 21 - Building Program 1005
Salaries-Full Time
399,000.00
.00
399,000.00
50,582.95
.00
290,852.66
108,147.34
73
350,093.17
1015
Salaries-Part Time
50,000.00
.00
50,000.00
.00
.00
7,710.79
42,289.21
15
51,348.86
1800
Salaries-Overtime
1,000.00
.00
1,000.00
11.77
.00
141.22
858.78
14
1,268.92
2000
FICA
27,900.00
.00
27,900.00
3,072.24
.00
17,964.37
9,935.63
64
24,268.26
2001
Medicare
6,525.00
.00
6,525.00
718.50
.00
4,201.33
2,323.67
64
5,675.69
2010
IMRF
52,875.00
.00
52,875.00
5,703.16
.00
33,598.64
19,276.36
64
42,564.50
2020
Employee Insurance
97,033.00
.00
97,033.00
11,564.72
.00
70,452.76
26,580.24
73
75,395.33
2025
Deferred Comp. Contribution
6,500.00
.00
6,500.00
.00
.00
.00
6,500.00
0
3,400.00
3000
Travel/Training
4,500.00
.00
4,500.00
.00
.00
3,337.96
1,162.04
74
3,648.00
3015
IL Unemployment Insurance
1,000.00
.00
1,000.00
.00
.00
515.30
484.70
52
940.58
4000
Telephone/Internet
1,500.00
.00
1,500.00
36.56
.00
241.91
1,258.09
16
343.03
4005
Cellular Phones/Pagers
4,000.00
.00
4,000.00
331.00
.00
1,967.19
2,032.81
49
4,350.18
Run by Traci Pleckham on 01/19/2017 02:03:02 PM
Page 13 of 14
Budget Performance Report Fiscal Year to Date 12/31/16 Exclude Rollup Account
Account
Account Description
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Budget - YTD % Used/ Transactions
Rec'd
Prior Year Total
Fund 01 - General Fund EXPENSE Unit 09 - Community Development Division 21 - Building Program 5005
Office Supplies/Postage
8,000.00
.00
8,000.00
363.71
.00
3,636.10
4,363.90
45
9,540.71
5015
Dues & Subscriptions
4,000.00
.00
4,000.00
.00
.00
.00
4,000.00
0
580.00
5020
Gas/Oil/Mileage/Carwash
1,000.00
.00
1,000.00
.00
.00
21.00
979.00
2
83.00
5095
Uniforms/Clothing
600.00
.00
600.00
.00
.00
125.00
475.00
21
.00
8097
Special Projects and Programs
500.00
.00
500.00
.00
.00
.00
500.00
0
.00
8135
Contractual Services
45,000.00
.00
45,000.00
5,036.00
7,036.00
6,601.17
31,362.83
30
35,247.05
8230
Ordinance Maintenance
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00
0
.00
Division 21 - Building Program Totals
$711,933.00
$0.00
$711,933.00
$77,420.61
$7,036.00
$441,367.40
$263,529.60
63%
$608,747.28
Unit 09 - Community Development Totals
$1,337,807.00
$0.00
$1,337,807.00
$131,677.37
$7,036.00
$716,932.04
$613,838.96
54%
$989,147.28
5,500.00
.00
5,500.00
69.00
.00
301.88
5,198.12
5
2,092.20
341.00
.00
341.00
4.28
.00
18.72
322.28
5
133.40
80.00
.00
80.00
1.00
.00
4.38
75.62
5
31.19
Unit 50 - Police Commission Division 02 - Administration Program 1015
Salaries-Part Time
2000
FICA
2001
Medicare
3000
Travel/Training
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00
0
.00
5005
Office Supplies/Postage
2,000.00
.00
2,000.00
.00
.00
132.80
1,867.20
7
884.38
5015
Dues & Subscriptions
375.00
8065
Legal Fees
8115
Police Testing/Hiring
600.00
.00
600.00
375.00
.00
375.00
225.00
62
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00
0
.00
10,000.00
.00
10,000.00
4,208.00
.00
4,327.55
5,672.45
43
4,113.50
Division 02 - Administration Program Totals
$20,521.00
$0.00
$20,521.00
$4,657.28
$0.00
$5,160.33
$15,360.67
25%
$7,629.67
Unit 50 - Police Commission Totals
$20,521.00
$0.00
$20,521.00
$4,657.28
$0.00
$5,160.33
$15,360.67
25%
$7,629.67
EXPENSE TOTALS
$23,574,972.00
$0.00
$23,574,972.00
$2,187,033.73
$174,870.15
$14,609,587.63
$8,790,514.22
63%
$23,840,313.83
REVENUE TOTALS
23,574,972.00
.00
23,574,972.00
1,552,718.17
.00
18,609,241.64
4,965,730.36
79%
24,152,420.32
EXPENSE TOTALS
23,574,972.00
.00
23,574,972.00
2,187,033.73
174,870.15
14,609,587.63
8,790,514.22
63%
23,840,313.83
Fund 01 - General Fund Totals
$0.00
$0.00
$0.00
($634,315.56)
($174,870.15)
$3,999,654.01
($3,824,783.86)
REVENUE TOTALS
23,574,972.00
.00
23,574,972.00
1,552,718.17
.00
18,609,241.64
4,965,730.36
79%
24,152,420.32
EXPENSE TOTALS
23,574,972.00
.00
23,574,972.00
2,187,033.73
174,870.15
14,609,587.63
8,790,514.22
63%
23,840,313.83
Grand Totals
$0.00
$0.00
$0.00
($634,315.56)
($174,870.15)
$3,999,654.01
($3,824,783.86)
Fund 01 - General Fund Totals
$312,106.49
Grand Totals
Run by Traci Pleckham on 01/19/2017 02:03:02 PM
$312,106.49
Page 14 of 14
