Budget Performance Report
Budget Performance Report Fiscal Year to Date 10/31/17 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,186,939.65
Fund 01 - General Fund REVENUE 0400.401
Property Tax Revenue
3,160,000.00
.00
3,160,000.00
299,855.92
.00
3,182,823.85
(22,823.85)
101
0400.402
Property Tax Rev-Road & Bridge
375,000.00
.00
375,000.00
35,239.40
.00
357,385.87
17,614.13
95
357,161.29
0400.403
Property Tax Rev-Police Pension
1,370,000.00
.00
1,370,000.00
126,352.87
.00
1,341,083.21
28,916.79
98
1,101,142.15
0400.404
Property Tax Revenue-IMRF
575,000.00
.00
575,000.00
53,060.93
.00
563,200.71
11,799.29
98
575,655.27
0450.450
Home Rule Sales Tax
500,000.00
.00
500,000.00
66,853.43
.00
392,718.13
107,281.87
79
.00
0450.451
Municipal Sales Tax
5,400,000.00
.00
5,400,000.00
466,308.05
.00
2,700,654.94
2,699,345.06
50
5,354,048.49
0450.452
Illinois Income Tax
3,550,000.00
.00
3,550,000.00
311,496.01
.00
2,460,687.03
1,089,312.97
69
3,741,387.32
0450.453
Replacement Tax
45,000.00
.00
45,000.00
.00
.00
21,796.84
23,203.16
48
56,644.71
0450.455
Local Use Tax
875,000.00
.00
875,000.00
77,673.33
.00
468,475.61
406,524.39
54
974,197.53
0500.500
Hotel/Motel Tax
.00
.00
.00
.00
.00
432.67
(432.67)
+++
198.71
0500.501
Amusement Tax
5,000.00
.00
5,000.00
1,545.82
.00
3,310.19
1,689.81
66
9,892.85
0500.503
Local Motor Fuel Tax
930,000.00
.00
930,000.00
89,260.33
.00
538,591.87
391,408.13
58
959,052.15
0550.551
Liquor License
100,000.00
.00
100,000.00
1,362.40
.00
99,772.01
227.99
100
103,568.00
0550.552
Contractors License
35,000.00
.00
35,000.00
4,150.00
.00
29,850.00
5,150.00
85
47,200.00
0550.553
Cigarette License
5,000.00
.00
5,000.00
.00
.00
6,250.00
(1,250.00)
125
7,000.00
0550.554
Scavenger License
200.00
.00
200.00
.00
.00
100.00
100.00
50
100.00
0550.558
Business License
35,000.00
.00
35,000.00
10,037.50
.00
12,462.50
22,537.50
36
37,788.00
0570.555
Building Permit
925,000.00
.00
925,000.00
105,651.13
.00
516,554.96
408,445.04
56
952,316.60
0570.556
Sign Permit
5,000.00
.00
5,000.00
440.00
.00
2,223.00
2,777.00
44
7,763.00
0570.557
Special Movement Permit
5,000.00
.00
5,000.00
1,225.00
.00
10,085.00
(5,085.00)
202
8,630.00
0570.560
Solicitors Permit
1,000.00
.00
1,000.00
245.00
.00
1,330.00
(330.00)
133
1,785.00
0600.601
County Court Fines
325,000.00
.00
325,000.00
19,276.31
.00
199,409.47
125,590.53
61
367,797.10
0600.602
Administrative Fines(P-Tickets)
130,000.00
.00
130,000.00
10,420.00
.00
60,110.00
69,890.00
46
135,528.00
0600.603
Asset Seizure-Non Federal
225,000.00
.00
225,000.00
1,775.00
.00
7,095.56
217,904.44
3
100,189.55
0600.604
Alarm Fees
7,000.00
.00
7,000.00
450.00
.00
800.00
6,200.00
11
2,025.00
0600.605
Kendall County Court Fines
1,000.00
.00
1,000.00
283.68
.00
1,173.56
(173.56)
117
1,165.84
0600.607
Administrative Fines- Late Fee
10,000.00
.00
10,000.00
380.00
.00
3,465.00
6,535.00
35
9,960.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
14,687.81
(14,687.81)
+++
44,741.22
0600.632
Asset Seizure-Federal (U.S. Treasury Equitable Share)
0620.655
Garbage Fee
0620.656 0640.500 0650.580
Child Safety Seats
0650.651
Zoning Applications
0650.653 0650.654 0650.670
Impound Fee
0650.815
Parking Lot Revenue
.00
.00
.00
.00
.00
.00
.00
+++
921.38
4,112,315.00
.00
4,112,315.00
343,532.52
.00
2,402,014.65
1,710,300.35
58
3,992,763.21
Garbage Penalties
50,000.00
.00
50,000.00
4,850.82
.00
27,949.73
22,050.27
56
55,335.52
Engineering Services
25,000.00
.00
25,000.00
.00
.00
13,375.32
11,624.68
54
33,590.05
100.00
.00
100.00
.00
.00
.00
100.00
0
.00
10,000.00
.00
10,000.00
.00
.00
8,237.88
1,762.12
82
13,162.00
Accident Report Fees
4,000.00
.00
4,000.00
565.00
.00
2,950.00
1,050.00
74
4,585.00
Copies-Maps & Ordinances
3,000.00
.00
3,000.00
252.00
.00
1,423.10
1,576.90
47
2,366.70
30,000.00
.00
30,000.00
2,250.00
.00
13,000.00
17,000.00
43
22,852.50
2,000.00
.00
2,000.00
900.00
.00
1,950.00
50.00
98
4,532.00
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
Page 1 of 27
Budget Performance Report Fiscal Year to Date 10/31/17 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.818
Tower Rent
50,000.00
.00
50,000.00
3,400.17
.00
22,496.28
27,503.72
45
38,191.41
0650.825
Rental Income
50,000.00
.00
50,000.00
4,100.00
.00
24,600.00
25,400.00
49
45,100.00
0650.830
Rental-Community/Multi Room
3,000.00
.00
3,000.00
97.50
.00
1,620.00
1,380.00
54
4,546.75
0650.904
Special Detail/OT Reimbursement
45,000.00
.00
45,000.00
35,368.75
.00
79,867.90
(34,867.90)
177
68,278.93
0690.902
Water & Sewer Service Charge
250,000.00
.00
250,000.00
.00
.00
.00
250,000.00
0
250,000.00
0700.650
Grant Revenue
.00
.00
.00
.00
.00
.00
.00
+++
17,545.00
0700.704
Bulletproof Vest Grant
3,000.00
.00
3,000.00
380.02
.00
380.02
2,619.98
13
3,414.82
0700.710
Tobacco Grant
2,600.00
.00
2,600.00
.00
.00
.00
2,600.00
0
2,750.00
0700.717
Traffic Grant
30,000.00
.00
30,000.00
2,583.62
.00
6,661.97
23,338.03
22
15,038.66
0750.750
AT&T Franchise Fees
250,000.00
.00
250,000.00
649.80
.00
91,677.50
158,322.50
37
209,381.47
0750.751
Cable TV-Franchise Fees
480,000.00
.00
480,000.00
.00
.00
260,691.40
219,308.60
54
533,615.95
0800.800
Interest Income
35,000.00
.00
35,000.00
6,645.84
.00
41,526.66
(6,526.66)
119
88,416.33
0800.826
Realized Gain/Loss On Investment
.00
.00
.00
.00
.00
.00
.00
+++
16.75
0800.827
Unrealized Gain/Loss
.00
.00
.00
190.75
.00
(2,614.83)
2,614.83
+++
(12,136.23)
0800.830
Unrealized Gain/Loss IMET
0801.200
Event Sponsorship Program
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
(994.22)
.00
2,763.53
(2,763.53)
+++
2,391.19
4,000.00
.00
4,000.00
.00
.00
3,450.25
549.75
86
4,096.76
500.00
.00
500.00
.00
.00
1,075.00
(575.00)
215
200.00
.00
.00
.00
.00
.00
.00
.00
+++
9,700.00
500.00
.00
500.00
.00
.00
.00
500.00
0
.00
10,000.00
.00
10,000.00
4,546.29
.00
7,945.29
2,054.71
79
16,376.74
5,000.00
.00
5,000.00
.00
.00
7,500.00
(2,500.00)
150
3,769.00
80,000.00
.00
80,000.00
1,526.00
.00
179,087.31
(99,087.31)
224
86,085.15
25,000.00
.00
25,000.00
6,848.25
.00
9,827.25
15,172.75
39
13,218.83
.00
.00
.00
.00
.00
.00
.00
+++
151,127.00
School Liaison Reimbursement
400,000.00
.00
400,000.00
119,965.55
.00
238,958.03
161,041.97
60
431,372.53
HIDTA/Organized Crime Reimb
10,000.00
.00
10,000.00
.00
.00
5,037.59
4,962.41
50
14,508.38
Transfer From MFT
150,000.00
.00
150,000.00
.00
.00
.00
150,000.00
0
.00
0999.917
Transfer From TIF
50,000.00
.00
50,000.00
.00
.00
.00
50,000.00
0
.00
0999.927
Transfer From Alcohol Enforc.
20,000.00
.00
20,000.00
.00
.00
.00
20,000.00
0
12,000.00
REVENUE TOTALS
$24,784,315.00
$0.00
$24,784,315.00
$2,221,000.77
$0.00
$16,449,981.62
$8,334,333.38
66%
$24,282,991.21
.00
.00
.00
.00
.00
.00
.00
+++
(178,389.69)
Division 94 - Contra Totals
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+++
($178,389.69)
Unit 00 - Non-Departmental Totals
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+++
($178,389.69)
3,808,325.00
.00
3,808,325.00
315,085.24
.00
1,573,970.67
2,234,354.33
41
3,669,782.29
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
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
Page 2 of 27
Budget Performance Report Fiscal Year to Date 10/31/17 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 00 - Non-Divisional 9997
Bad Debt Expense Division 00 - Non-Divisional Totals
.00
.00
.00
.00
.00
.00
.00
+++
134,093.16
$3,808,325.00
$0.00
$3,808,325.00
$315,085.24
$0.00
$1,573,970.67
$2,234,354.33
41%
$3,803,875.45
Division 01 - Legislative Program 1000
Salaries-President
24,000.00
.00
24,000.00
2,000.00
.00
11,666.67
12,333.33
49
20,000.04
1002
Salaries-Elected Officials
25,000.00
.00
25,000.00
1,600.00
.00
12,400.00
12,600.00
50
24,100.00
1003
Salaries-Liquor Commissioner
1,500.00
.00
1,500.00
125.00
.00
750.00
750.00
50
1,500.00
1004
Salaries-Treasurer
2,500.00
.00
2,500.00
208.33
.00
1,249.98
1,250.02
50
2,499.96
2000
FICA
3,300.00
.00
3,300.00
230.54
.00
1,536.16
1,763.84
47
2,783.06
2001
Medicare
780.00
.00
780.00
53.92
.00
359.26
420.74
46
650.87
2010
IMRF
900.00
.00
900.00
.00
.00
232.89
667.11
26
862.41
2020
Employee Insurance
150.00
.00
150.00
12.60
.00
65.10
84.90
43
92.40
3000
Travel/Training
10,000.00
.00
10,000.00
3,347.00
.00
4,972.00
5,028.00
50
3,844.07
5010
Replacement Supplies
3,000.00
.00
3,000.00
.00
.00
.00
3,000.00
0
85.17
5015
Dues & Subscriptions
35,000.00
.00
35,000.00
.00
.00
12,081.15
22,918.85
35
38,761.37
8070
Public Relations
115,000.00
.00
115,000.00
7,808.55
.00
35,843.75
79,156.25
31
113,975.36
8074
Cable TV
10,000.00
.00
10,000.00
.00
.00
19.99
9,980.01
0
17,086.05
8078
Economic Incentive Rebate
175,000.00
.00
175,000.00
45,633.30
.00
76,584.86
98,415.14
44
36,007.59
$406,130.00
$0.00
$406,130.00
$61,019.24
$0.00
$157,761.81
$248,368.19
39%
$262,248.35
Division 01 - Legislative Program Totals Division 02 - Administration Program 1005
Salaries-Full Time
710,000.00
.00
710,000.00
51,737.50
.00
355,688.49
354,311.51
50
688,352.30
1015
Salaries-Part Time
50,000.00
.00
50,000.00
4,638.76
.00
26,537.97
23,462.03
53
45,065.94
1800
Salaries-Overtime
1,000.00
.00
1,000.00
287.55
.00
2,257.18
(1,257.18)
226
339.33
2000
FICA
47,500.00
.00
47,500.00
2,623.44
.00
22,256.78
25,243.22
47
40,632.69
2001
Medicare
11,000.00
.00
11,000.00
810.17
.00
5,498.54
5,501.46
50
10,673.40
2010
IMRF
84,000.00
.00
84,000.00
6,222.01
.00
42,466.90
41,533.10
51
83,197.55
2020
Employee Insurance
109,000.00
.00
109,000.00
7,333.30
.00
52,943.26
56,056.74
49
102,070.61
2025
Deferred Comp. Contribution
25,000.00
.00
25,000.00
.00
.00
.00
25,000.00
0
24,320.71
3000
Travel/Training
15,000.00
.00
15,000.00
209.30
.00
4,343.22
10,656.78
29
9,487.79
3015
IL Unemployment Insurance
7,000.00
.00
7,000.00
900.30
.00
1,867.02
5,132.98
27
3,505.77
4000
Telephone/Internet
5,000.00
.00
5,000.00
335.04
.00
2,547.41
2,452.59
51
4,094.28
4005
Cellular Phones/Pagers
2,500.00
.00
2,500.00
156.49
.00
1,159.30
1,340.70
46
3,004.18
5005
Office Supplies/Postage
30,000.00
.00
30,000.00
2,452.94
.00
14,221.49
15,778.51
47
30,162.77
5015
Dues & Subscriptions
5,000.00
.00
5,000.00
505.00
.00
2,845.00
2,155.00
57
4,072.00
5020
Gas/Oil/Mileage/Carwash
9,500.00
.00
9,500.00
600.00
.00
4,003.82
5,496.18
42
8,259.64
8035
Maintenance Contracts/Lease
8,000.00
.00
8,000.00
.00
.00
3,295.00
4,705.00
41
7,908.00
8045
Recording Fees
2,000.00
.00
2,000.00
.00
.00
.00
2,000.00
0
1,379.49
8050
Legal Notices
2,500.00
.00
2,500.00
.00
.00
349.41
2,150.59
14
1,600.28
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
Page 3 of 27
Budget Performance Report Fiscal Year to Date 10/31/17 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 02 - Administration Program 8065
Legal Fees
50,000.00
.00
50,000.00
.00
.00
6,114.00
43,886.00
12
30,735.50
8135
Contractual Services
75,000.00
.00
75,000.00
10,368.39
.00
29,854.32
45,145.68
40
85,320.19
8225
Engineering Fees
5,000.00
.00
5,000.00
.00
.00
.00
5,000.00
0
2,283.20
9115
Office Furniture & Equipment
5,000.00
.00
5,000.00
.00
.00
189.67
4,810.33
4
4,632.33
9300
Contingencies
45,000.00
.00
45,000.00
.00
.00
.00
45,000.00
0
18,750.00
$1,304,000.00
$0.00
$1,304,000.00
$89,180.19
$0.00
$578,438.78
$725,561.22
44%
$1,209,847.95
Division 02 - Administration Program Totals Division 03 - Community Relations Program 1005
Salaries-Full Time
101,000.00
.00
101,000.00
7,630.88
.00
49,507.67
51,492.33
49
96,782.14
2000
FICA
6,200.00
.00
6,200.00
424.38
.00
2,767.82
3,432.18
45
5,592.49
2001
Medicare
1,450.00
.00
1,450.00
99.25
.00
647.31
802.69
45
1,307.94
2010
IMRF
11,500.00
.00
11,500.00
846.26
.00
5,512.55
5,987.45
48
11,059.04
2020
Employee Insurance
20,700.00
.00
20,700.00
1,615.65
.00
10,390.75
10,309.25
50
18,563.15
2025
Deferred Comp. Contribution
4,000.00
.00
4,000.00
.00
.00
.00
4,000.00
0
3,561.20
3000
Travel/Training
1,500.00
.00
1,500.00
.00
.00
189.00
1,311.00
13
142.50
4000
Telephone/Internet
500.00
.00
500.00
33.50
.00
254.74
245.26
51
409.43
5005
Office Supplies/Postage
750.00
.00
750.00
.00
.00
17.13
732.87
2
81.28
5015
Dues & Subscriptions
750.00
.00
750.00
.00
.00
916.00
(166.00)
122
525.00
5020
Gas/Oil/Mileage/Carwash
100.00
.00
100.00
.00
.00
.00
100.00
0
.00
8030
Server/Network Supplies
2,500.00
.00
2,500.00
.00
.00
.00
2,500.00
0
.00
8070
Public Relations
17,000.00
.00
17,000.00
42.50
.00
5,631.44
11,368.56
33
8,157.09
8071
Marketing and Promotions
2,500.00
.00
2,500.00
.00
.00
.00
2,500.00
0
.00
8072
Settler's Park
7,500.00
.00
7,500.00
.00
.00
4,800.26
2,699.74
64
4,863.03
8135
Contractual Services Division 03 - Community Relations Program Totals
2,500.00
.00
2,500.00
.00
.00
.00
2,500.00
0
.00
$180,450.00
$0.00
$180,450.00
$10,692.42
$0.00
$80,634.67
$99,815.33
45%
$151,044.29
Division 04 - Facility Management Program 1005
Salaries-Full Time
50,000.00
.00
50,000.00
3,827.00
.00
23,165.92
26,834.08
46
33,936.93
1800
Salaries-Overtime
2,500.00
.00
2,500.00
160.34
.00
1,266.55
1,233.45
51
1,705.28
2000
FICA
3,300.00
.00
3,300.00
237.07
.00
1,454.96
1,845.04
44
2,245.20
2001
Medicare
800.00
.00
800.00
55.44
.00
340.29
459.71
43
525.16
2010
IMRF
5,500.00
.00
5,500.00
442.20
.00
2,709.59
2,790.41
49
4,221.28
2020
Employee Insurance
14,000.00
.00
14,000.00
1,066.04
.00
6,175.29
7,824.71
44
9,199.52
5000
Building Maintenance Supplies
7,500.00
.00
7,500.00
987.49
.00
5,534.62
1,965.38
74
9,970.18
5005
Office Supplies/Postage
.00
.00
.00
278.00
.00
278.00
(278.00)
+++
.00
8135
Contractual Services
40,000.00
.00
40,000.00
2,390.00
.00
16,274.13
23,725.87
41
32,624.35
9105
Building Improvements Division 04 - Facility Management Program Totals
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
40,000.00
.00
40,000.00
27,337.40
.00
27,536.40
12,463.60
69
.00
$163,600.00
$0.00
$163,600.00
$36,780.98
$0.00
$84,735.75
$78,864.25
52%
$94,427.90
Page 4 of 27
Budget Performance Report Fiscal Year to Date 10/31/17 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
135,412.15
Fund 01 - General Fund EXPENSE Unit 04 - Administration/Finance Division 06 - Human Resources Program 1005
Salaries-Full Time
165,000.00
.00
165,000.00
12,407.84
.00
80,697.24
84,302.76
49
1800
Salaries-Overtime
500.00
.00
500.00
.00
.00
.00
500.00
0
.00
2000
FICA
10,500.00
.00
10,500.00
729.79
.00
4,765.11
5,734.89
45
8,014.37
2001
Medicare
2,500.00
.00
2,500.00
170.68
.00
1,114.42
1,385.58
45
1,874.33
2010
IMRF
19,000.00
.00
19,000.00
1,376.02
.00
8,971.46
10,028.54
47
15,421.82
2020
Employee Insurance
43,500.00
.00
43,500.00
2,900.74
.00
18,497.03
25,002.97
43
25,578.42
2025
Deferred Comp. Contribution
7,000.00
.00
7,000.00
.00
.00
.00
7,000.00
0
2,894.80
3000
Travel/Training
6,500.00
.00
6,500.00
75.00
.00
4,788.82
1,711.18
74
4,493.94
4000
Telephone/Internet
1,000.00
.00
1,000.00
67.01
.00
509.46
490.54
51
818.87
4005
Cellular Phones/Pagers
600.00
.00
600.00
54.73
.00
164.19
435.81
27
120.00
5005
Office Supplies/Postage
1,500.00
.00
1,500.00
.00
.00
280.40
1,219.60
19
968.66
5015
Dues & Subscriptions
3,200.00
.00
3,200.00
.00
.00
219.00
2,981.00
7
613.00
5020
Gas/Oil/Mileage/Carwash
1,400.00
.00
1,400.00
.00
.00
.00
1,400.00
0
281.88
8070
Public Relations
12,000.00
.00
12,000.00
310.91
.00
3,075.08
8,924.92
26
10,627.42
8071
Marketing and Promotions
8135
Contractual Services Division 06 - Human Resources Program Totals
300.00
.00
300.00
.00
.00
.00
300.00
0
.00
8,000.00
.00
8,000.00
653.44
.00
1,879.44
6,120.56
23
6,462.99
$282,500.00
$0.00
$282,500.00
$18,746.16
$0.00
$124,961.65
$157,538.35
44%
$213,582.65 222,850.22
Division 08 - IT Program 1005
Salaries-Full Time
240,000.00
.00
240,000.00
18,332.34
.00
118,684.01
121,315.99
49
1800
Salaries-Overtime
500.00
.00
500.00
.00
.00
.00
500.00
0
178.60
2000
FICA
15,000.00
.00
15,000.00
1,111.56
.00
7,198.47
7,801.53
48
13,700.47
2001
Medicare
3,500.00
.00
3,500.00
259.95
.00
1,683.52
1,816.48
48
3,204.13
2010
IMRF
28,000.00
.00
28,000.00
2,033.06
.00
13,162.07
14,837.93
47
25,141.33
2020
Employee Insurance
56,000.00
.00
56,000.00
3,276.81
.00
20,939.18
35,060.82
37
39,121.10
2025
Deferred Comp. Contribution
7,000.00
.00
7,000.00
.00
.00
.00
7,000.00
0
8,524.89
3000
Travel/Training
14,500.00
.00
14,500.00
.00
.00
7,284.05
7,215.95
50
19,185.65
4000
Telephone/Internet
500.00
.00
500.00
33.50
.00
254.74
245.26
51
409.42
4005
Cellular Phones/Pagers
2,340.00
.00
2,340.00
192.50
.00
992.10
1,347.90
42
2,211.40
5005
Office Supplies/Postage
1,400.00
.00
1,400.00
83.90
.00
741.41
658.59
53
1,424.65
5015
Dues & Subscriptions
700.00
.00
700.00
99.00
.00
399.00
301.00
57
539.19
5020
Gas/Oil/Mileage/Carwash
400.00
.00
400.00
55.66
.00
379.08
20.92
95
275.49
5095
Uniforms/Clothing
300.00
.00
300.00
146.00
.00
302.82
(2.82)
101
.00
8030
Server/Network Supplies
47,900.00
.00
47,900.00
1,595.79
.00
10,475.69
37,424.31
22
33,660.64
8031
Software Licensing/Renewals
255,380.00
.00
255,380.00
89,074.46
13,647.43
171,695.07
70,037.50
73
220,551.71
8135
Contractual Services
17,880.00
.00
17,880.00
865.99
5,100.00
5,655.99
7,124.01
60
8,366.46
9111
Computers
12,000.00
.00
12,000.00
2,191.70
191.46
7,076.07
4,732.47
61
10,469.04
$703,300.00
$0.00
$703,300.00
$119,352.22
$18,938.89
$366,923.27
$317,437.84
55%
$609,814.39
Division 08 - IT Program Totals
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
Page 5 of 27
Budget Performance Report Fiscal Year to Date 10/31/17 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,189,567.00
Division 99 - Transfers Totals
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+++
$2,189,567.00
Unit 04 - Administration/Finance Totals
$6,848,305.00
$0.00
$6,848,305.00
$650,856.45
$18,938.89
$2,967,426.60
$3,861,939.51
44%
$8,534,407.98
Unit 05 - Police Department Division 02 - Administration Program 1005
Salaries-Full Time
315,000.00
.00
315,000.00
22,864.96
.00
152,457.91
162,542.09
48
302,896.76
1015
Salaries-Part Time
26,296.00
.00
26,296.00
2,561.35
.00
15,808.06
10,487.94
60
19,966.37
1800
Salaries-Overtime
3,000.00
.00
3,000.00
.00
.00
336.39
2,663.61
11
818.91
2000
FICA
21,346.00
.00
21,346.00
1,504.10
.00
9,979.00
11,367.00
47
18,486.24
2001
Medicare
5,000.00
.00
5,000.00
351.77
.00
2,333.81
2,666.19
47
4,531.54
2010
IMRF
23,375.00
.00
23,375.00
1,664.99
.00
10,734.01
12,640.99
46
21,038.04
2020
Employee Insurance
66,780.00
.00
66,780.00
5,177.23
.00
32,923.39
33,856.61
49
59,861.95
2025
Deferred Comp. Contribution
8,000.00
.00
8,000.00
.00
.00
.00
8,000.00
0
5,939.74
3000
Travel/Training
9,975.00
.00
9,975.00
328.57
.00
832.50
9,142.50
8
3,887.92
3001
Education/School
6,000.00
.00
6,000.00
.00
.00
.00
6,000.00
0
433.15
3015
IL Unemployment Insurance
20,000.00
.00
20,000.00
4,646.19
.00
9,152.37
10,847.63
46
17,278.91
4000
Telephone/Internet
605.00
.00
605.00
156.76
.00
718.09
(113.09)
119
1,282.86
4005
Cellular Phones/Pagers
1,644.00
.00
1,644.00
54.73
.00
310.16
1,333.84
19
996.63
5005
Office Supplies/Postage
11,950.00
.00
11,950.00
300.77
.00
1,769.23
10,180.77
15
5,051.83
5010
Replacement Supplies
3,500.00
.00
3,500.00
162.01
.00
368.90
3,131.10
11
707.23
5015
Dues & Subscriptions
7,050.00
.00
7,050.00
875.00
.00
2,720.03
4,329.97
39
3,771.67
5020
Gas/Oil/Mileage/Carwash
3,700.00
.00
3,700.00
151.26
.00
389.79
3,310.21
11
1,342.51
5095
Uniforms/Clothing
1,800.00
.00
1,800.00
193.74
.00
1,422.90
377.10
79
2,345.25
8035
Maintenance Contracts/Lease
7,190.00
.00
7,190.00
.00
.00
2,246.35
4,943.65
31
6,709.70
8040
Custodian
70,000.00
.00
70,000.00
7,295.71
.00
18,786.87
51,213.13
27
52,222.70
8060
Vehicle Maintenance
2,500.00
.00
2,500.00
123.96
.00
123.96
2,376.04
5
1,340.12
8135
Contractual Services
8,000.00
.00
8,000.00
.00
.00
827.99
7,172.01
10
5,465.40
$622,711.00
$0.00
$622,711.00
$48,413.10
$0.00
$264,241.71
$358,469.29
42%
$536,375.43 3,329,739.76
Division 02 - Administration Program Totals Division 51 - Police Operations 1005
Salaries-Full Time
3,918,296.00
.00
3,918,296.00
267,133.26
.00
1,761,061.82
2,157,234.18
45
1015
Salaries-Part Time
.00
.00
.00
23,279.35
.00
122,883.51
(122,883.51)
+++
.00
1800
Salaries-Overtime
380,000.00
.00
380,000.00
24,582.72
.00
171,688.56
208,311.44
45
263,296.45
2000
FICA
266,494.00
.00
266,494.00
19,105.50
.00
124,078.56
142,415.44
47
214,599.36
2001
Medicare
62,325.00
.00
62,325.00
4,468.25
.00
29,018.46
33,306.54
47
50,934.89
2010
IMRF
54,538.00
.00
54,538.00
3,853.69
.00
20,930.39
33,607.61
38
6,289.04
2011
Employer Pension Contributions
1,370,000.00
.00
1,370,000.00
126,352.87
.00
1,341,083.21
28,916.79
98
1,101,142.15
2020
Employee Insurance
630,739.00
.00
630,739.00
45,620.52
.00
294,762.56
335,976.44
47
528,506.74
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
Page 6 of 27
Budget Performance Report Fiscal Year to Date 10/31/17 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 2025
Deferred Comp. Contribution
85,000.00
.00
85,000.00
.00
.00
.00
85,000.00
0
91,161.55
3000
Travel/Training
46,100.00
.00
46,100.00
829.10
.00
21,970.15
24,129.85
48
35,571.37
4000
Telephone/Internet
27,180.00
.00
27,180.00
3,269.15
.00
10,622.37
16,557.63
39
24,799.44
4005
Cellular Phones/Pagers
6,564.00
.00
6,564.00
517.29
.00
2,346.23
4,217.77
36
5,005.24
5005
Office Supplies/Postage
13,000.00
.00
13,000.00
531.67
.00
4,218.13
8,781.87
32
13,298.15
5010
Replacement Supplies
17,000.00
.00
17,000.00
684.08
.00
5,390.96
11,609.04
32
15,849.82
5015
Dues & Subscriptions
3,400.00
.00
3,400.00
.00
.00
110.00
3,290.00
3
1,388.16
5020
Gas/Oil/Mileage/Carwash
100,000.00
.00
100,000.00
7,620.92
.00
38,241.80
61,758.20
38
63,832.78
5068
K-9 Unit
4,000.00
.00
4,000.00
326.70
.00
1,586.99
2,413.01
40
4,513.66
5095
Uniforms/Clothing
33,850.00
.00
33,850.00
3,305.77
.00
19,061.96
14,788.04
56
32,245.78
5100
Ammunition/Weapons
28,000.00
.00
28,000.00
.00
.00
6,419.43
21,580.57
23
25,790.93
5115.001
Traffic Programs
23,000.00
.00
23,000.00
1,161.24
.00
9,484.35
13,515.65
41
21,124.26
8003
Radio Maintenance
2,000.00
.00
2,000.00
.00
.00
1,000.00
1,000.00
50
272.00
8035
Maintenance Contracts/Lease
11,392.00
.00
11,392.00
.00
.00
2,480.00
8,912.00
22
11,702.00
8060
Vehicle Maintenance
65,000.00
.00
65,000.00
2,577.31
.00
26,274.94
38,725.06
40
68,997.15
8069
Bike Unit
2,000.00
.00
2,000.00
.00
.00
399.90
1,600.10
20
.00
8135
Contractual Services
15,000.00
.00
15,000.00
.00
.00
12,478.92
2,521.08
83
14,532.92
8265
Contractual Services-Wescom
593,000.00
.00
593,000.00
47,844.83
.00
287,518.98
305,481.02
48
564,841.56
8267
Animal Control
14,000.00
.00
14,000.00
1,800.00
.00
2,800.00
11,200.00
20
.00
$7,771,878.00
$0.00
$7,771,878.00
$584,864.22
$0.00
$4,317,912.18
$3,453,965.82
56%
$6,489,435.16
Division 51 - Police Operations Totals Division 52 - Police Administration 1005
Salaries-Full Time
859,940.00
.00
859,940.00
70,626.36
.00
478,999.15
380,940.85
56
1,290,355.79
1800
Salaries-Overtime
113,000.00
.00
113,000.00
9,802.18
.00
44,516.15
68,483.85
39
94,858.97
2000
FICA
60,322.00
.00
60,322.00
4,852.11
.00
31,728.96
28,593.04
53
84,083.97
2001
Medicare
14,108.00
.00
14,108.00
1,134.77
.00
7,420.48
6,687.52
53
19,883.44
2020
Employee Insurance
152,801.00
.00
152,801.00
12,907.77
.00
86,640.81
66,160.19
57
210,770.17
2025
Deferred Comp. Contribution
32,000.00
.00
32,000.00
.00
.00
.00
32,000.00
0
40,467.84
3000
Travel/Training
13,600.00
.00
13,600.00
365.00
.00
5,314.08
8,285.92
39
12,631.90
4000
Telephone/Internet
780.00
.00
780.00
196.27
.00
896.47
(116.47)
115
1,593.21
4005
Cellular Phones/Pagers
5,544.00
.00
5,544.00
630.55
.00
3,154.12
2,389.88
57
7,514.02
5005
Office Supplies/Postage
8,500.00
.00
8,500.00
263.18
.00
1,102.07
7,397.93
13
5,293.77
5010
Replacement Supplies
12,000.00
.00
12,000.00
.00
.00
238.00
11,762.00
2
269.21
5015
Dues & Subscriptions
4,070.00
.00
4,070.00
.00
.00
2,000.00
2,070.00
49
3,511.66
5020
Gas/Oil/Mileage/Carwash
29,000.00
.00
29,000.00
1,282.27
.00
7,385.02
21,614.98
25
20,479.50
5040.002
Crime Scene/Evidence Tech Supply
10,800.00
.00
10,800.00
802.26
.00
6,433.45
4,366.55
60
7,337.69
5095
Uniforms/Clothing
5,300.00
.00
5,300.00
106.97
.00
3,056.25
2,243.75
58
10,061.29
5115.004
Community Programs-Explorer Program
2,500.00
.00
2,500.00
212.50
.00
6,209.34
(3,709.34)
248
4,368.54
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
Page 7 of 27
Budget Performance Report Fiscal Year to Date 10/31/17 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 8003
Radio Maintenance
8035
Maintenance Contracts/Lease
8060
Vehicle Maintenance
8246
Shop with a Cop
8250
Background Check Services
8268
Accreditation Division 52 - Police Administration Totals
500.00
.00
500.00
.00
.00
.00
500.00
0
.00
8,920.00
.00
8,920.00
.00
.00
1,464.59
7,455.41
16
4,047.80
15,500.00
.00
15,500.00
1,446.98
.00
5,882.88
9,617.12
38
12,012.78
.00
.00
.00
540.00
.00
540.00
(540.00)
+++
.00
2,500.00
.00
2,500.00
129.80
.00
573.35
1,926.65
23
995.25
8,070.00
.00
8,070.00
.00
.00
4,595.00
3,475.00
57
8,436.68
$1,359,755.00
$0.00
$1,359,755.00
$105,298.97
$0.00
$698,150.17
$661,604.83
51%
$1,838,973.48 401,677.79
Division 53 - Police Records 1005
Salaries-Full Time
463,022.00
.00
463,022.00
36,061.08
.00
234,622.47
228,399.53
51
1015
Salaries-Part Time
.00
.00
.00
2,658.56
.00
5,192.50
(5,192.50)
+++
.00
1800
Salaries-Overtime
6,000.00
.00
6,000.00
920.94
.00
5,833.19
166.81
97
10,112.29
2000
FICA
29,079.00
.00
29,079.00
2,386.66
.00
14,891.19
14,187.81
51
24,805.18
2001
Medicare
6,801.00
.00
6,801.00
558.19
.00
3,482.62
3,318.38
51
5,806.35
2010
IMRF
31,086.00
.00
31,086.00
2,527.70
.00
15,724.96
15,361.04
51
33,212.62
2020
Employee Insurance
129,686.00
.00
129,686.00
8,425.18
.00
55,656.91
74,029.09
43
115,825.74
2025
Deferred Comp. Contribution
15,000.00
.00
15,000.00
.00
.00
.00
15,000.00
0
11,003.04
3000
Travel/Training
2,100.00
.00
2,100.00
453.87
.00
1,741.13
358.87
83
1,796.60
4000
Telephone/Internet
780.00
.00
780.00
196.27
.00
896.47
(116.47)
115
1,593.19
4005
Cellular Phones/Pagers
1,344.00
.00
1,344.00
.00
.00
.00
1,344.00
0
.00
5005
Office Supplies/Postage
13,450.00
.00
13,450.00
460.17
.00
2,704.51
10,745.49
20
7,379.78
5015
Dues & Subscriptions
425.00
.00
425.00
.00
.00
.00
425.00
0
86.67
5095
Uniforms/Clothing
2,400.00
.00
2,400.00
70.00
.00
1,112.88
1,287.12
46
1,610.86
8035
Maintenance Contracts/Lease Division 53 - Police Records Totals
4,460.00
.00
4,460.00
1,425.00
.00
2,325.00
2,135.00
52
2,160.00
$705,633.00
$0.00
$705,633.00
$56,143.62
$0.00
$344,183.83
$361,449.17
49%
$617,070.11
Division 54 - Seizure/Forfeiture 5012
Asset Seizure/Forfeiture Expense Division 54 - Seizure/Forfeiture Totals
225,000.00
.00
225,000.00
1,385.00
.00
9,583.08
215,416.92
4
156,826.56
$225,000.00
$0.00
$225,000.00
$1,385.00
$0.00
$9,583.08
$215,416.92
4%
$156,826.56
32,513.00
.00
32,513.00
33,522.50
.00
63,627.50
(31,114.50)
196
46,555.00
2,016.00
.00
2,016.00
2,032.31
.00
3,854.56
(1,838.56)
191
2,621.16
471.00
.00
471.00
475.30
.00
901.49
(430.49)
191
620.25
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00
0
.00
$36,000.00
$0.00
$36,000.00
$36,030.11
$0.00
$68,383.55
($32,383.55)
190%
$49,796.41
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
773,336.00
.00
773,336.00
49,777.57
.00
314,219.68
459,116.32
41
556,142.29
1015
Salaries-Part Time
.00
.00
.00
.00
.00
.00
.00
+++
210,280.16
1800
Salaries-Overtime
25,000.00
.00
25,000.00
5,858.72
.00
23,042.44
1,957.56
92
28,729.30
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
Page 8 of 27
Budget Performance Report Fiscal Year to Date 10/31/17 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 2000
FICA
49,497.00
.00
49,497.00
3,346.66
.00
21,037.23
28,459.77
43
47,859.97
2001
Medicare
11,576.00
.00
11,576.00
782.68
.00
4,919.96
6,656.04
43
11,230.53
2010
IMRF
5,534.00
.00
5,534.00
409.26
.00
3,585.80
1,948.20
65
49,461.85
2020
Employee Insurance
141,293.00
.00
141,293.00
9,448.51
.00
58,983.47
82,309.53
42
113,185.46
2025
Deferred Comp. Contribution
3000
Travel/Training
4000
Telephone/Internet
4005
Cellular Phones/Pagers
5005
Office Supplies/Postage
5010
7,500.00
.00
7,500.00
.00
.00
.00
7,500.00
0
5,100.00
11,680.00
.00
11,680.00
500.64
.00
8,822.46
2,857.54
76
10,133.37
780.00
.00
780.00
196.27
.00
896.46
(116.46)
115
1,593.21
6,744.00
.00
6,744.00
227.91
.00
1,144.14
5,599.86
17
2,758.96
3,400.00
.00
3,400.00
280.96
.00
638.63
2,761.37
19
2,897.50
Replacement Supplies
5,200.00
.00
5,200.00
21.53
.00
62.50
5,137.50
1
751.72
5015
Dues & Subscriptions
1,900.00
.00
1,900.00
.00
.00
.00
1,900.00
0
1,903.67
5020
Gas/Oil/Mileage/Carwash
16,000.00
.00
16,000.00
937.16
.00
3,612.56
12,387.44
23
14,877.92
5095
Uniforms/Clothing
5,500.00
.00
5,500.00
2,252.62
.00
4,138.81
1,361.19
75
5,956.72
5115.002
Community Programs
8,200.00
.00
8,200.00
.00
.00
3,555.20
4,644.80
43
3,589.54
5115.003
Community Prog.-Alcohol/Tobacco
4,600.00
.00
4,600.00
.00
.00
83.48
4,516.52
2
144.58
8003
Radio Maintenance
24,800.00
.00
24,800.00
.00
.00
2,263.39
22,536.61
9
33,761.09
8035
Maintenance Contracts/Lease
8060
Vehicle Maintenance
8245 8246 8266
Chaplaincy Program
8267
Animal Control
2,180.00
.00
2,180.00
.00
.00
.00
2,180.00
0
1,022.50
14,000.00
.00
14,000.00
205.29
.00
1,571.92
12,428.08
11
22,653.41
D.A.R.E. Program
5,000.00
.00
5,000.00
.00
.00
442.50
4,557.50
9
1,983.00
Shop with a Cop
10,000.00
.00
10,000.00
.00
.00
.00
10,000.00
0
9,500.00
4,600.00
.00
4,600.00
.00
.00
320.30
4,279.70
7
2,654.67
.00
.00
.00
.00
.00
.00
.00
+++
7,140.00
$1,138,320.00
$0.00
$1,138,320.00
$74,245.78
$0.00
$453,340.93
$684,979.07
40%
$1,145,311.42
Division 56 - Community Services Totals Division 57 - Court Services 1005
Salaries-Full Time
124,000.00
.00
124,000.00
9,693.31
.00
62,953.48
61,046.52
51
121,358.68
1015
Salaries-Part Time
47,410.00
.00
47,410.00
1,900.36
.00
12,045.67
35,364.33
25
37,461.41
1800
Salaries-Overtime
1,000.00
.00
1,000.00
.00
.00
110.34
889.66
11
.00
2000
FICA
10,548.00
.00
10,548.00
688.84
.00
4,503.18
6,044.82
43
9,694.79
2001
Medicare
2,467.00
.00
2,467.00
161.10
.00
1,053.17
1,413.83
43
2,267.33
2010
IMRF
20,415.00
.00
20,415.00
1,285.73
.00
8,373.96
12,041.04
41
18,053.80
2020
Employee Insurance
43,998.00
.00
43,998.00
3,079.67
.00
20,359.90
23,638.10
46
37,630.45
2025
Deferred Comp. Contribution
5,500.00
.00
5,500.00
.00
.00
.00
5,500.00
0
4,807.36
3000
Travel/Training
3,000.00
.00
3,000.00
.00
.00
.00
3,000.00
0
161.00
4000
Telephone/Internet
605.00
.00
605.00
138.27
.00
699.55
(94.55)
116
1,282.91
5005
Office Supplies/Postage
10,000.00
.00
10,000.00
812.31
.00
3,078.73
6,921.27
31
8,745.16
5015
Dues & Subscriptions
9,000.00
.00
9,000.00
457.93
.00
3,684.72
5,315.28
41
8,151.47
5095
Uniforms/Clothing
900.00
.00
900.00
.00
.00
241.68
658.32
27
563.88
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
Page 9 of 27
Budget Performance Report Fiscal Year to Date 10/31/17 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,920.00
Fund 01 - General Fund EXPENSE Unit 05 - Police Department Division 57 - Court Services 8035
Maintenance Contracts/Lease
8065
Legal Fees Division 57 - Court Services Totals
1,920.00
.00
1,920.00
.00
.00
800.00
1,120.00
42
27,500.00
.00
27,500.00
300.00
.00
11,525.00
15,975.00
42
8,405.05
$308,263.00
$0.00
$308,263.00
$18,517.52
$0.00
$129,429.38
$178,833.62
42%
$260,503.29
Division 91 - Capital 9115
Office Furniture & Equipment
9120
Machinery and Equipment
11,000.00
.00
11,000.00
.00
.00
.00
11,000.00
0
5,863.91
107,780.00
.00
107,780.00
97,203.40
2,615.94
97,203.40
7,960.66
93
13,396.15
Division 91 - Capital Totals
$118,780.00
$0.00
$118,780.00
$97,203.40
$2,615.94
$97,203.40
$18,960.66
84%
$19,260.06
13,700.00
.00
13,700.00
812.01
.00
5,474.46
8,225.54
40
13,887.78
Division 93 - Contingencies Totals
$13,700.00
$0.00
$13,700.00
$812.01
$0.00
$5,474.46
$8,225.54
40%
$13,887.78
Unit 05 - Police Department Totals
$12,300,040.00
$0.00
$12,300,040.00
$1,022,913.73
$2,615.94
$6,387,902.69
$5,909,521.37
52%
$11,127,439.70
Division 93 - Contingencies 9300
Contingencies
Unit 07 - PEMA Division 07 - PEMA Program 1005
Salaries-Full Time
131,200.00
.00
131,200.00
9,519.84
.00
65,630.30
65,569.70
50
124,512.43
2000
FICA
7,750.00
.00
7,750.00
572.61
.00
3,959.97
3,790.03
51
7,126.33
2001
Medicare
1,813.00
.00
1,813.00
133.92
.00
926.12
886.88
51
1,789.90
2020
Employee Insurance
24,336.00
.00
24,336.00
1,615.65
.00
10,190.75
14,145.25
42
18,319.18
2025
Deferred Comp. Contribution
4,000.00
.00
4,000.00
.00
.00
.00
4,000.00
0
4,021.91
3000
Travel/Training
4,000.00
.00
4,000.00
158.20
.00
625.48
3,374.52
16
571.80
4000
Telephone/Internet
5,400.00
.00
5,400.00
460.99
.00
3,539.43
1,860.57
66
5,346.74
4005
Cellular Phones/Pagers
5,200.00
.00
5,200.00
266.11
.00
1,168.56
4,031.44
22
3,450.61
5005
Office Supplies/Postage
1,300.00
.00
1,300.00
17.88
.00
45.86
1,254.14
4
302.76
5010
Replacement Supplies
11,000.00
.00
11,000.00
.00
.00
1,496.29
9,503.71
14
1,472.80
5015
Dues & Subscriptions
5020
Gas/Oil/Mileage/Carwash
5040
4,000.00
.00
4,000.00
190.00
.00
1,904.00
2,096.00
48
1,909.57
12,000.00
.00
12,000.00
588.38
.00
3,318.07
8,681.93
28
5,235.57
Supplies/Hardware
2,000.00
.00
2,000.00
51.64
.00
422.01
1,577.99
21
181.75
5040.001
Supplies/Hardware-ESDA
2,000.00
.00
2,000.00
.00
.00
91.69
1,908.31
5
616.99
5095
Uniforms/Clothing
5,000.00
.00
5,000.00
859.24
.00
1,559.46
3,440.54
31
4,074.52
5110
Emergency Operation Center
750.00
.00
750.00
.00
.00
.00
750.00
0
.00
5115
Police Public Relations
2,000.00
.00
2,000.00
.00
.00
.00
2,000.00
0
.00
5120
Disaster Plan/Exercises/NIMS
3,000.00
.00
3,000.00
.00
.00
.00
3,000.00
0
26.24
8003
Radio Maintenance
15,000.00
.00
15,000.00
907.36
.00
907.36
14,092.64
6
7,175.99
8020
Building Maintenance
5,000.00
.00
5,000.00
783.36
.00
783.36
4,216.64
16
.00
8035
Maintenance Contracts/Lease
1,800.00
.00
1,800.00
.00
.00
589.50
1,210.50
33
1,311.79
8060
Vehicle Maintenance
15,000.00
.00
15,000.00
1,428.77
.00
7,407.90
7,592.10
49
19,361.46
8069
Bike Unit
500.00
.00
500.00
.00
.00
16.26
483.74
3
.00
8125
Siren Maintenance
20,000.00
.00
20,000.00
537.07
.00
1,407.07
18,592.93
7
9,555.57
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
Page 10 of 27
Budget Performance Report Fiscal Year to Date 10/31/17 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 07 - PEMA Division 07 - PEMA Program 8135
Contractual Services
5,250.00
.00
5,250.00
242.00
.00
1,295.00
3,955.00
25
740.00
8280
Cadet Program
5,500.00
.00
5,500.00
1,544.62
.00
1,544.62
3,955.38
28
2,153.47
8305
PEMA Search and Rescue
8,000.00
.00
8,000.00
.00
.00
.00
8,000.00
0
.00
9115
Office Furniture & Equipment
2,000.00
.00
2,000.00
.00
.00
.00
2,000.00
0
683.52
9120
Machinery and Equipment
5,000.00
.00
5,000.00
.00
.00
.00
5,000.00
0
5,514.30
9300
Contingencies
3,000.00
.00
3,000.00
840.00
.00
840.00
2,160.00
28
1,160.09
Division 07 - PEMA Program Totals
$312,799.00
$0.00
$312,799.00
$20,717.64
$0.00
$109,669.06
$203,129.94
35%
$226,615.29
Unit 07 - PEMA Totals
$312,799.00
$0.00
$312,799.00
$20,717.64
$0.00
$109,669.06
$203,129.94
35%
$226,615.29
272,912.32
Unit 08 - Street Department Division 02 - Administration Program 1005
Salaries-Full Time
288,000.00
.00
288,000.00
21,836.55
.00
141,913.71
146,086.29
49
1015
Salaries-Part Time
.00
.00
.00
.00
.00
328.00
(328.00)
+++
.00
2000
FICA
18,000.00
.00
18,000.00
1,344.55
.00
8,959.80
9,040.20
50
16,762.99
2001
Medicare
4,200.00
.00
4,200.00
314.43
.00
2,095.43
2,104.57
50
4,078.42
2010
IMRF
33,000.00
.00
33,000.00
2,482.68
.00
16,118.42
16,881.58
49
31,772.74
2020
Employee Insurance
59,500.00
.00
59,500.00
4,362.13
.00
27,704.09
31,795.91
47
51,855.39
2025
Deferred Comp. Contribution
8,500.00
.00
8,500.00
.00
.00
.00
8,500.00
0
8,716.04
3000
Travel/Training
10,000.00
.00
10,000.00
486.41
.00
2,197.24
7,802.76
22
9,710.16
3015
IL Unemployment Insurance
4,000.00
.00
4,000.00
.00
.00
.00
4,000.00
0
3,651.67
4000
Telephone/Internet
19,000.00
.00
19,000.00
2,121.44
.00
13,945.87
5,054.13
73
22,890.54
4005
Cellular Phones/Pagers
8,500.00
.00
8,500.00
637.80
.00
3,288.45
5,211.55
39
7,348.00
5005
Office Supplies/Postage
2,500.00
.00
2,500.00
279.05
.00
1,434.39
1,065.61
57
3,583.27
5015
Dues & Subscriptions
3,000.00
.00
3,000.00
.00
.00
831.00
2,169.00
28
2,967.53
5020
Gas/Oil/Mileage/Carwash
300.00
.00
300.00
.00
.00
.00
300.00
0
80.00
5040
Supplies/Hardware
500.00
.00
500.00
.00
.00
199.99
300.01
40
.00
8003
Radio Maintenance
100.00
.00
100.00
.00
.00
.00
100.00
0
.00
8020
Building Maintenance
20,000.00
.00
20,000.00
1,403.99
.00
4,618.10
15,381.90
23
6,475.89
8050
Legal Notices Division 02 - Administration Program Totals
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00
0
.00
$480,100.00
$0.00
$480,100.00
$35,269.03
$0.00
$223,634.49
$256,465.51
47%
$442,804.96 721,757.32
Division 60 - Street Maintenance Program 1005
Salaries-Full Time
810,000.00
.00
810,000.00
61,664.31
.00
395,386.37
414,613.63
49
1015
Salaries-Part Time
75,000.00
.00
75,000.00
1,394.00
.00
76,688.35
(1,688.35)
102
62,433.19
1800
Salaries-Overtime
85,000.00
.00
85,000.00
7,599.37
.00
46,741.45
38,258.55
55
106,835.87
2000
FICA
59,000.00
.00
59,000.00
4,187.39
.00
30,800.93
28,199.07
52
52,747.13
2001
Medicare
14,000.00
.00
14,000.00
979.41
.00
7,203.53
6,796.47
51
12,335.88
2010
IMRF
94,000.00
.00
94,000.00
7,620.35
.00
48,741.71
45,258.29
52
91,864.26
2020
Employee Insurance
193,000.00
.00
193,000.00
15,561.44
.00
98,379.54
94,620.46
51
173,326.22
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
Page 11 of 27
Budget Performance Report Fiscal Year to Date 10/31/17 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 08 - Street Department Division 60 - Street Maintenance Program 2025
Deferred Comp. Contribution
4015
Electricity/Gas
20,000.00
.00
20,000.00
.00
.00
.00
20,000.00
0
21,869.39
290,000.00
.00
290,000.00
2,085.07
.00
49,602.77
240,397.23
17
257,109.86
5020 5040
Gas/Oil/Mileage/Carwash
70,000.00
.00
70,000.00
25,071.72
.00
14,317.79
55,682.21
20
53,294.62
Supplies/Hardware
15,000.00
.00
15,000.00
722.36
.00
4,219.63
10,780.37
28
5040.003
Supplies/Hardware-Salt Purchase
11,680.86
280,000.00
.00
280,000.00
.00
.00
.00
280,000.00
0
232,040.61
5055
Street Sign Maintenance
5060
Aggregate Materials
25,000.00
.00
25,000.00
2,301.75
4,931.45
12,012.46
8,056.09
68
29,485.95
4,000.00
.00
4,000.00
.00
.00
1,524.13
2,475.87
38
5095
Uniforms/Clothing
5,239.80
10,000.00
.00
10,000.00
415.34
.00
3,316.63
6,683.37
33
10,439.49
8003
Radio Maintenance
8060
Vehicle Maintenance
8130
Street Light Maintenance
8131
Street Maintenance
8132
5,000.00
.00
5,000.00
.00
.00
.00
5,000.00
0
1,692.10
35,000.00
.00
35,000.00
713.08
.00
4,532.91
30,467.09
13
25,636.77
95,000.00
.00
95,000.00
2,354.58
.00
37,421.86
57,578.14
39
113,358.45
130,000.00
.00
130,000.00
865.64
.00
13,056.83
116,943.17
10
115,168.49
Storm Sewer Improvements
10,000.00
.00
10,000.00
5,044.12
.00
10,478.18
(478.18)
105
1,490.85
8135
Contractual Services
90,000.00
.00
90,000.00
9,253.66
.00
56,277.56
33,722.44
63
108,462.32
8135.004
Snow Removal
280,000.00
.00
280,000.00
.00
.00
.00
280,000.00
0
169,521.13
8150
Sidewalk Maintenance
5,000.00
.00
5,000.00
.00
.00
.00
5,000.00
0
1,496.87
8160
Equipment Maintenance
95,000.00
.00
95,000.00
4,110.68
.00
26,427.71
68,572.29
28
77,487.55
$2,789,000.00
$0.00
$2,789,000.00
$151,944.27
$4,931.45
$937,130.34
$1,846,938.21
34%
$2,456,774.98
Division 60 - Street Maintenance Program Totals Division 62 - Forestry Program 1005
Salaries-Full Time
78,000.00
.00
78,000.00
5,645.54
.00
35,037.56
42,962.44
45
49,732.95
1800
Salaries-Overtime
6,000.00
.00
6,000.00
708.31
.00
5,434.83
565.17
91
6,677.22
2000
FICA
5,500.00
.00
5,500.00
380.33
.00
2,438.39
3,061.61
44
3,634.67
2001
Medicare
1,300.00
.00
1,300.00
88.96
.00
570.28
729.72
44
850.03
2010
IMRF
9,000.00
.00
9,000.00
704.64
.00
4,509.44
4,490.56
50
6,753.55
2020
Employee Insurance
17,000.00
.00
17,000.00
1,179.66
.00
7,429.90
9,570.10
44
11,056.90
2025
Deferred Comp. Contribution
3,000.00
.00
3,000.00
.00
.00
.00
3,000.00
0
1,817.40
5040
Supplies/Hardware
8,000.00
.00
8,000.00
10.99
.00
3,650.07
4,349.93
46
6,795.51
5095
Uniforms/Clothing
500.00
.00
500.00
.00
.00
.00
500.00
0
.00
8135
Contractual Services
5,000.00
.00
5,000.00
1,775.00
.00
7,090.00
(2,090.00)
142
3,911.55
8135.002
Tree Removal Division 62 - Forestry Program Totals
45,000.00
.00
45,000.00
9,100.00
.00
9,100.00
35,900.00
20
11,865.00
$178,300.00
$0.00
$178,300.00
$19,593.43
$0.00
$75,260.47
$103,039.53
42%
$103,094.78 186,524.95
Division 63 - Vehicle Maintenance Program 1005
Salaries-Full Time
193,000.00
.00
193,000.00
14,764.50
.00
95,684.00
97,316.00
50
1800
Salaries-Overtime
8,000.00
.00
8,000.00
2,084.23
.00
3,268.16
4,731.84
41
3,205.27
2000
FICA
12,500.00
.00
12,500.00
998.04
.00
5,840.63
6,659.37
47
11,275.14
2001
Medicare
3,000.00
.00
3,000.00
233.39
.00
1,365.92
1,634.08
46
2,636.92
2010
IMRF
22,000.00
.00
22,000.00
1,868.53
.00
10,973.76
11,026.24
50
21,386.55
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
Page 12 of 27
Budget Performance Report Fiscal Year to Date 10/31/17 Exclude Rollup Account
Account
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions
Rec'd
Prior Year Total
40,500.00
.00
40,500.00
3,039.00
.00
19,485.55
21,014.45
48
37,236.34
7,500.00
.00
7,500.00
.00
.00
.00
7,500.00
0
6,216.05
Division 63 - Vehicle Maintenance Program Totals
$286,500.00
$0.00
$286,500.00
$22,987.69
$0.00
$136,618.02
$149,881.98
48%
$268,481.22
Unit 08 - Street Department Totals
$3,733,900.00
$0.00
$3,733,900.00
$229,794.42
$4,931.45
$1,372,643.32
$2,356,325.23
37%
$3,271,155.94
Account Description
Budget - YTD % Used/
Fund 01 - General Fund EXPENSE Unit 08 - Street Department Division 63 - Vehicle Maintenance Program 2020
Employee Insurance
2025
Deferred Comp. Contribution
Unit 09 - Community Development Division 20 - Planning Program 1005
Salaries-Full Time
315,000.00
.00
315,000.00
26,159.48
.00
169,352.25
145,647.75
54
283,526.27
1045
Salaries-Commissioner
4,000.00
.00
4,000.00
285.00
.00
1,420.00
2,580.00
36
2,845.00
1800
Salaries-Overtime
2,500.00
.00
2,500.00
154.98
.00
1,407.99
1,092.01
56
2,460.20
2000
FICA
20,000.00
.00
20,000.00
1,601.90
.00
10,409.75
9,590.25
52
17,019.71
2001
Medicare
4,700.00
.00
4,700.00
374.62
.00
2,434.53
2,265.47
52
3,980.48
2010
IMRF
35,000.00
.00
35,000.00
2,918.27
.00
18,981.63
16,018.37
54
31,198.33
2020
Employee Insurance
70,500.00
.00
70,500.00
5,856.15
.00
37,735.76
32,764.24
54
51,716.24
2025
Deferred Comp. Contribution
12,000.00
.00
12,000.00
.00
.00
.00
12,000.00
0
3,400.00
3000
Travel/Training
7,000.00
.00
7,000.00
199.29
.00
2,103.34
4,896.66
30
2,567.00
3015
IL Unemployment Insurance
1,000.00
.00
1,000.00
176.05
.00
406.91
593.09
41
639.03
4000
Telephone/Internet
3,000.00
.00
3,000.00
167.52
.00
1,305.77
1,694.23
44
2,047.16
4005
Cellular Phones/Pagers
1,800.00
.00
1,800.00
72.98
.00
364.90
1,435.10
20
1,166.60
5005
Office Supplies/Postage
10,500.00
.00
10,500.00
1,001.24
.00
6,093.27
4,406.73
58
11,811.79
5015
Dues & Subscriptions
3,000.00
.00
3,000.00
.00
.00
1,979.00
1,021.00
66
3,393.54
5020
Gas/Oil/Mileage/Carwash
750.00
.00
750.00
47.60
.00
47.60
702.40
6
.00
8035
Maintenance Contracts/Lease
3,500.00
.00
3,500.00
.00
.00
250.00
3,250.00
7
600.00
8060
Vehicle Maintenance
1,500.00
.00
1,500.00
.00
.00
.00
1,500.00
0
.00
8065
Legal Fees
5,000.00
.00
5,000.00
236.18
.00
236.18
4,763.82
5
2,354.00
8097
Special Projects and Programs
15,000.00
.00
15,000.00
6,708.75
.00
14,343.75
656.25
96
3,709.27
8135
Contractual Services
35,000.00
.00
35,000.00
252.00
.00
1,919.00
33,081.00
5
1,691.84
8225
Engineering Fees
10,000.00
.00
10,000.00
850.00
.00
2,657.50
7,342.50
27
4,446.24
$560,750.00
$0.00
$560,750.00
$47,062.01
$0.00
$273,449.13
$287,300.87
49%
$430,572.70
Division 20 - Planning Program Totals Division 21 - Building Program 1005
Salaries-Full Time
633,000.00
.00
633,000.00
44,740.95
.00
290,242.23
342,757.77
46
431,841.31
1015
Salaries-Part Time
5,000.00
.00
5,000.00
.00
.00
.00
5,000.00
0
6,363.51
1800
Salaries-Overtime
5,000.00
.00
5,000.00
.00
.00
479.56
4,520.44
10
141.22
2000
FICA
39,800.00
.00
39,800.00
2,657.92
.00
17,375.09
22,424.91
44
26,488.50
2001
Medicare
2010
IMRF
2020
Employee Insurance
2025
Deferred Comp. Contribution
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
9,300.00
.00
9,300.00
621.60
.00
4,063.55
5,236.45
44
6,194.87
70,000.00
.00
70,000.00
4,972.87
.00
32,351.99
37,648.01
46
49,417.95
157,000.00
.00
157,000.00
11,893.97
.00
71,871.10
85,128.90
46
97,663.77
7,000.00
.00
7,000.00
.00
.00
.00
7,000.00
0
8,256.62
Page 13 of 27
Budget Performance Report Fiscal Year to Date 10/31/17 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 3000
Travel/Training
7,500.00
.00
7,500.00
2,433.88
.00
4,340.64
3,159.36
58
8,511.01
3015
IL Unemployment Insurance
1,500.00
.00
1,500.00
385.42
.00
795.90
704.10
53
1,000.00
4000
Telephone/Internet
1,500.00
.00
1,500.00
33.51
.00
318.90
1,181.10
21
409.44
4005
Cellular Phones/Pagers
6,000.00
.00
6,000.00
311.22
.00
1,556.13
4,443.87
26
3,500.04
5005
Office Supplies/Postage
13,000.00
.00
13,000.00
1,237.52
.00
3,130.02
9,869.98
24
7,111.69
5015
Dues & Subscriptions
4,000.00
.00
4,000.00
.00
.00
54.00
3,946.00
1
520.00
5020
Gas/Oil/Mileage/Carwash
1,000.00
.00
1,000.00
70.33
.00
275.18
724.82
28
32.00
5095
Uniforms/Clothing
900.00
.00
900.00
.00
.00
150.00
750.00
17
499.68
8045
Recording Fees
8135
Contractual Services
.00
.00
.00
339.75
.00
789.25
(789.25)
+++
.00
46,500.00
.00
46,500.00
.00
.00
1,045.50
45,454.50
2
7,589.70
Division 21 - Building Program Totals
$1,008,000.00
$0.00
$1,008,000.00
$69,698.94
$0.00
$428,839.04
$579,160.96
43%
$655,541.31
Unit 09 - Community Development Totals
$1,568,750.00
$0.00
$1,568,750.00
$116,760.95
$0.00
$702,288.17
$866,461.83
45%
$1,086,114.01
5,500.00
.00
5,500.00
189.73
.00
841.52
4,658.48
15
681.34
341.00
.00
341.00
11.77
.00
52.18
288.82
15
35.36
80.00
.00
80.00
2.75
.00
12.19
67.81
15
8.28
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
466.16
1,533.84
23
132.80
5015
Dues & Subscriptions
375.00
8065
Legal Fees
8115
Police Testing/Hiring
600.00
.00
600.00
.00
.00
.00
600.00
0
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00
0
.00
10,000.00
.00
10,000.00
.00
.00
.00
10,000.00
0
8,037.55
Division 02 - Administration Program Totals
$20,521.00
$0.00
$20,521.00
$204.25
$0.00
$1,372.05
$19,148.95
7%
$9,270.33
Unit 50 - Police Commission Totals
$20,521.00
$0.00
$20,521.00
$204.25
$0.00
$1,372.05
$19,148.95
7%
$9,270.33
EXPENSE TOTALS
$24,784,315.00
$0.00
$24,784,315.00
$2,041,247.44
$26,486.28
$11,541,301.89
$13,216,526.83
47%
$24,076,613.56
REVENUE TOTALS
24,784,315.00
.00
24,784,315.00
2,221,000.77
.00
16,449,981.62
8,334,333.38
66%
24,282,991.21
EXPENSE TOTALS
24,784,315.00
.00
24,784,315.00
2,041,247.44
26,486.28
11,541,301.89
13,216,526.83
47%
24,076,613.56
Fund 01 - General Fund Totals
$0.00
$0.00
$0.00
$179,753.33
($26,486.28)
$4,908,679.73
($4,882,193.45)
1,775,000.00
.00
1,775,000.00
148,548.33
.00
872,619.69
902,380.31
49
35,000.00
.00
35,000.00
1,760.00
.00
11,660.00
23,340.00
33
52,325.00
Fund 01 - General Fund Totals
$206,377.65
Fund 02 - Water and Sewer Fund REVENUE 0450.450
Home Rule Sales Tax
0570.850
Meter Sales
0570.851
Water Connection Fee
280,000.00
.00
280,000.00
29,807.75
.00
267,863.78
12,136.22
96
446,840.00
0570.852
Sewer Connection Fee
280,000.00
.00
280,000.00
35,343.00
.00
176,743.50
103,256.50
63
427,123.50
0570.859
Sewer By-Pass Fee
8,000.00
.00
8,000.00
3,010.00
.00
6,665.00
1,335.00
83
12,040.00
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
1,745,967.81
Page 14 of 27
Budget Performance Report Fiscal Year to Date 10/31/17 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
9,350,000.00
.00
9,350,000.00
978,369.79
.00
5,668,207.29
3,681,792.71
61
9,316,320.32
85,000.00
.00
85,000.00
10,384.90
.00
55,441.23
29,558.77
65
100,004.20
4,250,000.00
.00
4,250,000.00
431,270.28
.00
2,476,229.24
1,773,770.76
58
4,335,795.38
Fund 02 - Water and Sewer Fund REVENUE 0620.672
Water Sales
0620.673
Water Penalty
0620.674
Sewer Sales
0620.675
Sewer Penalty
45,000.00
.00
45,000.00
4,553.28
.00
24,777.39
20,222.61
55
47,432.36
0620.676
Capital Charge
1,130,000.00
.00
1,130,000.00
95,339.30
.00
666,807.46
463,192.54
59
1,204,238.08
0620.677
Capital Charge Penalty
15,000.00
.00
15,000.00
1,183.97
.00
6,958.19
8,041.81
46
15,006.20
0800.800
Interest Income
24,382.00
.00
24,382.00
5,527.12
.00
33,054.46
(8,672.46)
136
44,480.79
0800.827
Unrealized Gain/Loss
.00
.00
.00
291.56
.00
(1,698.82)
1,698.82
+++
(3,038.26)
0800.830
Unrealized Gain/Loss IMET
.00
.00
.00
(2,654.45)
.00
7,340.47
(7,340.47)
+++
6,309.48
0801.822
Donation/Contribution
.00
.00
.00
.00
.00
.00
.00
+++
389,353.00
0803.001
Sale of Scrap
500.00
.00
500.00
.00
.00
1,470.00
(970.00)
294
1,055.00
0805.000
Other Reimbursements
.00
.00
.00
.00
.00
4,620.90
(4,620.90)
+++
13,714.08
0806.000
Other Receipts REVENUE TOTALS
25,000.00
.00
25,000.00
2,990.00
.00
10,935.13
14,064.87
44
22,796.09
$17,302,882.00
$0.00
$17,302,882.00
$1,745,724.83
$0.00
$10,289,694.91
$7,013,187.09
59%
$18,177,763.03
245,000.00
.00
245,000.00
21,493.52
.00
138,457.42
106,542.58
57
236,158.35
15,200.00
.00
15,200.00
1,334.47
.00
8,587.46
6,612.54
56
14,288.25
3,600.00
.00
3,600.00
312.11
.00
2,008.54
1,591.46
56
3,456.90
56
27,342.55
EXPENSE Unit 10 - Water Department Division 02 - Administration Program 1005
Salaries-Full Time
2000
FICA
2001
Medicare
2010
IMRF
28,000.00
.00
28,000.00
2,446.36
.00
15,732.88
12,267.12
2020
Employee Insurance
46,000.00
.00
46,000.00
3,673.60
.00
23,318.63
22,681.37
51
36,257.21
2020.001
Contra Insurance Account
.00
.00
.00
.00
.00
.00
.00
+++
(31,480.53)
2025
Deferred Comp. Contribution
10,000.00
.00
10,000.00
.00
.00
.00
10,000.00
0
8,028.22
3000
Travel/Training
7,000.00
.00
7,000.00
86.19
.00
1,903.53
5,096.47
27
2,707.65
3015
IL Unemployment Insurance
2,500.00
.00
2,500.00
1,569.54
.00
3,121.88
(621.88)
125
1,705.58
4000
Telephone/Internet
5,600.00
.00
5,600.00
450.26
.00
3,300.18
2,299.82
59
4,665.28
4005
Cellular Phones/Pagers
3,000.00
.00
3,000.00
365.58
.00
1,687.14
1,312.86
56
4,152.66
5005
Office Supplies/Postage
26,000.00
.00
26,000.00
2,331.89
.00
14,075.43
11,924.57
54
33,547.92
5015
Dues & Subscriptions
1,400.00
.00
1,400.00
.00
.00
372.40
1,027.60
27
1,457.61
5020
Gas/Oil/Mileage/Carwash
500.00
.00
500.00
.00
.00
.00
500.00
0
521.81
5040
Supplies/Hardware
500.00
.00
500.00
.00
.00
222.54
277.46
45
525.44
5065
Software
2,000.00
.00
2,000.00
.00
.00
.00
2,000.00
0
1,893.15
5075
Sand & Gravel
5080
Water Meters
8020
Building Maintenance
8050
Legal Notices
8065
Legal Fees
8135
Contractual Services
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
800.00
.00
800.00
.00
.00
72.50
727.50
9
1,384.07
150,000.00
.00
150,000.00
3,255.35
.00
25,842.25
124,157.75
17
131,727.54
8,000.00
.00
8,000.00
1,601.14
.00
6,701.06
1,298.94
84
4,921.44
500.00
.00
500.00
.00
.00
.00
500.00
0
.00
1,000.00
.00
1,000.00
.00
.00
76.00
924.00
8
292.00
27,000.00
.00
27,000.00
1,261.97
.00
10,463.76
16,536.24
39
42,194.59
Page 15 of 27
Budget Performance Report Fiscal Year to Date 10/31/17 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
125.55
Fund 02 - Water and Sewer Fund EXPENSE Unit 10 - Water Department Division 02 - Administration Program 8160
Equipment Maintenance
8225
Engineering Fees
500.00
.00
500.00
.00
.00
132.79
367.21
27
4,000.00
.00
4,000.00
.00
.00
1,248.52
2,751.48
31
9330
Change in IMRF Net Pension Liability GASB 68
.00
.00
.00
.00
.00
.00
.00
.00
+++
16,126.00
9401 9905
Administrative Service Charge
125,000.00
.00
125,000.00
.00
.00
.00
125,000.00
0
125,000.00
Transfer to Debt Service
244,825.00
.00
244,825.00
.00
.00
122,412.50
122,412.50
50
9997
Bad Debt Expense
242,725.00
.00
.00
.00
.00
.00
.00
.00
+++
3,424.31
$957,925.00
$0.00
$957,925.00
$40,181.98
$0.00
$379,737.41
$578,187.59
40%
$913,148.55
Division 02 - Administration Program Totals Division 30 - Water Distribution Program 1005
Salaries-Full Time
410,000.00
.00
410,000.00
24,494.25
.00
158,866.87
251,133.13
39
403,796.20
1015
Salaries-Part Time
14,000.00
.00
14,000.00
.00
.00
8,759.58
5,240.42
63
15,649.72
1800
Salaries-Overtime
35,000.00
.00
35,000.00
3,361.14
.00
15,423.22
19,576.78
44
31,515.55
2000
FICA
29,000.00
.00
29,000.00
1,661.83
.00
10,989.84
18,010.16
38
26,731.62
2001
Medicare
6,800.00
.00
6,800.00
388.64
.00
2,570.15
4,229.85
38
6,299.58
2010
IMRF
53,000.00
.00
53,000.00
3,043.12
.00
19,106.24
33,893.76
36
47,881.94
2020
Employee Insurance
70,975.00
.00
70,975.00
4,638.89
.00
28,251.02
42,723.98
40
63,113.21
2025
Deferred Comp. Contribution
15,000.00
.00
15,000.00
.00
.00
.00
15,000.00
0
15,502.28
4000
Telephone/Internet
9,000.00
.00
9,000.00
723.64
.00
5,331.16
3,668.84
59
7,888.21
4005
Cellular Phones/Pagers
500.00
.00
500.00
.00
.00
.00
500.00
0
151.75
4015
Electricity/Gas
140,000.00
.00
140,000.00
235.21
.00
6,544.97
133,455.03
5
123,565.62
5005
Office Supplies/Postage
2,000.00
.00
2,000.00
25.67
.00
140.33
1,859.67
7
199.91
5010
Replacement Supplies
5,000.00
.00
5,000.00
.00
.00
1,600.00
3,400.00
32
7,017.40
5020
Gas/Oil/Mileage/Carwash
15,000.00
.00
15,000.00
488.89
.00
5,086.83
9,913.17
34
8,602.27
5040
Supplies/Hardware
4,000.00
.00
4,000.00
512.85
.00
3,636.93
363.07
91
5,485.05
5070
Chemicals
5,500.00
.00
5,500.00
1,215.00
.00
2,430.00
3,070.00
44
5,379.54
5095
Uniforms/Clothing
2,000.00
.00
2,000.00
102.17
.00
542.35
1,457.65
27
5,327.56
8020
Building Maintenance
4,000.00
.00
4,000.00
33.49
.00
331.57
3,668.43
8
2,772.26
8060
Vehicle Maintenance
6,500.00
.00
6,500.00
(54.48)
.00
2,388.06
4,111.94
37
6,089.99
8135
Contractual Services
40,000.00
.00
40,000.00
7,665.66
7,071.90
12,197.24
20,730.86
48
53,499.34
8135.003
Lake Michigan Water Purchase
8,403,000.00
.00
8,403,000.00
1,748,746.11
.00
4,345,015.82
4,057,984.18
52
8,471,988.46
8160
Equipment Maintenance
9,000.00
.00
9,000.00
499.95
.00
537.05
8,462.95
6
12,096.38
8185
System Maintenance
44,000.00
.00
44,000.00
.00
.00
605.91
43,394.09
1
49,419.05
8194
Water/Fire Hydrant
20,000.00
.00
20,000.00
5,189.27
.00
5,189.27
14,810.73
26
19,074.73
8200
EPA Analytical
16,000.00
.00
16,000.00
80.00
.00
9,761.37
6,238.63
61
11,034.66
9305
Capitalized Assets-Cap Outlay
.00
.00
.00
.00
.00
.00
.00
+++
(1,347,739.16)
9905
Transfer to Debt Service Division 30 - Water Distribution Program Totals
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
244,825.00
.00
244,825.00
.00
.00
122,412.50
122,412.50
50
242,725.00
$9,604,100.00
$0.00
$9,604,100.00
$1,803,051.30
$7,071.90
$4,767,718.28
$4,829,309.82
50%
$8,295,068.12
Page 16 of 27
Budget Performance Report Fiscal Year to Date 10/31/17 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,110,638.97
Fund 02 - Water and Sewer Fund EXPENSE Unit 10 - Water Department Division 93 - Contingencies 9303
Depreciation
.00
.00
.00
.00
.00
.00
.00
+++
9307
Amortization Expense
.00
.00
.00
.00
.00
.00
.00
+++
39,236.31
Division 93 - Contingencies Totals
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+++
$3,149,875.28
Unit 10 - Water Department Totals
$10,562,025.00
$0.00
$10,562,025.00
$1,843,233.28
$7,071.90
$5,147,455.69
$5,407,497.41
49%
$12,358,091.95
245,000.00
.00
245,000.00
18,335.06
.00
119,386.96
125,613.04
49
235,196.83
15,200.00
.00
15,200.00
1,130.34
.00
7,410.32
7,789.68
49
14,291.42
3,600.00
.00
3,600.00
264.33
.00
1,732.92
1,867.08
48
3,456.80
Unit 11 - Sewer Department Division 02 - Administration Program 1005
Salaries-Full Time
2000
FICA
2001
Medicare
2010
IMRF
28,000.00
.00
28,000.00
2,072.05
.00
13,574.14
14,425.86
48
27,356.16
2020
Employee Insurance
46,000.00
.00
46,000.00
2,910.98
.00
18,734.17
27,265.83
41
35,824.58
2025
Deferred Comp. Contribution
10,000.00
.00
10,000.00
.00
.00
.00
10,000.00
0
7,723.21
3000
Travel/Training
12,000.00
.00
12,000.00
724.09
.00
2,947.62
9,052.38
25
5,191.84
3015
IL Unemployment Insurance
2,500.00
.00
2,500.00
256.00
.00
522.92
1,977.08
21
1,705.54
4000
Telephone/Internet
9,000.00
.00
9,000.00
723.64
.00
6,669.43
2,330.57
74
11,908.89
4005
Cellular Phones/Pagers
3,500.00
.00
3,500.00
227.71
.00
1,117.87
2,382.13
32
2,973.50
5005
Office Supplies/Postage
25,000.00
.00
25,000.00
2,331.39
.00
13,430.05
11,569.95
54
31,332.15
5015
Dues & Subscriptions
68,200.00
.00
68,200.00
27,012.58
.00
62,180.98
6,019.02
91
60,535.73
5020
Gas/Oil/Mileage/Carwash
1,000.00
.00
1,000.00
30.00
.00
30.00
970.00
3
299.18
5040
Supplies/Hardware
2,500.00
.00
2,500.00
.00
.00
82.63
2,417.37
3
510.72
8020
Building Maintenance
15,000.00
.00
15,000.00
1,672.27
.00
8,533.92
6,466.08
57
17,449.12
8065
Legal Fees
8135
Contractual Services
8160
Equipment Maintenance
8225
Engineering Fees
9200.012 9200.013 9200.018
1,500.00
.00
1,500.00
.00
.00
76.00
1,424.00
5
172.00
30,000.00
.00
30,000.00
1,262.21
.00
8,209.27
21,790.73
27
39,619.85
2,000.00
.00
2,000.00
272.85
.00
591.99
1,408.01
30
.00
10,000.00
.00
10,000.00
.00
.00
564.08
9,435.92
6
10,186.12
2013 Refunding-2004A Bond (Principal)
39,840.00
.00
39,840.00
.00
.00
.00
39,840.00
0
340,500.00
2013 Refunding-2004A Bond (Interest)
384,000.00
.00
384,000.00
.00
.00
19,920.00
364,080.00
5
46,650.00
2005B Bond (Principal)
.00
.00
.00
.00
.00
.00
.00
+++
30,000.00
9200.019
2005B Bond (Interest)
.00
.00
.00
.00
.00
.00
.00
+++
1,162.00
9299
Contra Debt Expense
.00
.00
.00
.00
.00
.00
.00
+++
(30,000.00)
9330
Change in IMRF Net Pension Liability GASB 68
.00
.00
.00
.00
.00
.00
.00
+++
16,126.00
9401
Administrative Service Charge
125,000.00
.00
125,000.00
.00
.00
.00
125,000.00
0
125,000.00
9905
Transfer to Debt Service
244,825.00
.00
244,825.00
.00
.00
122,412.50
122,412.50
50
242,725.00
9997
Bad Debt Expense
.00
.00
.00
.00
.00
.00
.00
+++
2,320.70
$1,323,665.00
$0.00
$1,323,665.00
$59,225.50
$0.00
$408,127.77
$915,537.23
31%
$1,280,217.34
385,000.00
.00
385,000.00
28,071.29
.00
187,397.78
197,602.22
49
410,779.62
Division 02 - Administration Program Totals Division 40 - Sewer Treatment Program 1005
Salaries-Full Time
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
Page 17 of 27
Budget Performance Report Fiscal Year to Date 10/31/17 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 02 - Water and Sewer Fund EXPENSE Unit 11 - Sewer Department Division 40 - Sewer Treatment Program 1015
Salaries-Part Time
10,000.00
.00
10,000.00
.00
.00
8,759.56
1,240.44
88
15,649.65
1800
Salaries-Overtime
30,000.00
.00
30,000.00
1,288.90
.00
12,028.04
17,971.96
40
26,852.08
2000
FICA
26,500.00
.00
26,500.00
1,760.74
.00
12,503.76
13,996.24
47
27,242.55
2001
Medicare
6,500.00
.00
6,500.00
411.82
.00
2,924.24
3,575.76
45
6,414.31
2010
IMRF
46,000.00
.00
46,000.00
3,222.84
.00
21,870.71
24,129.29
48
48,877.78
2020
Employee Insurance
56,000.00
.00
56,000.00
4,053.62
.00
26,260.48
29,739.52
47
60,441.24
2025
Deferred Comp. Contribution
13,500.00
.00
13,500.00
.00
.00
.00
13,500.00
0
13,026.76
4000
Telephone/Internet
22,000.00
.00
22,000.00
1,768.88
.00
13,265.38
8,734.62
60
19,797.10
4015
Electricity/Gas
525,000.00
.00
525,000.00
306.22
.00
114,767.01
410,232.99
22
519,785.43
5005
Office Supplies/Postage
4,500.00
.00
4,500.00
25.66
.00
238.13
4,261.87
5
841.27
5010
Replacement Supplies
1,500.00
.00
1,500.00
227.28
.00
1,462.94
37.06
98
2,084.97
5020
Gas/Oil/Mileage/Carwash
13,000.00
.00
13,000.00
426.90
.00
3,913.44
9,086.56
30
8,249.45
5040
Supplies/Hardware
10,000.00
.00
10,000.00
1,117.92
.00
4,673.01
5,326.99
47
10,856.84
5070
Chemicals
115,000.00
.00
115,000.00
8,505.31
.00
37,782.55
77,217.45
33
112,021.46
5075
Sand & Gravel
500.00
.00
500.00
.00
.00
.00
500.00
0
253.33
5085
Industrial Flow Monitor
18,000.00
.00
18,000.00
256.50
.00
1,188.00
16,812.00
7
1,971.00
5095
Uniforms/Clothing
5,000.00
.00
5,000.00
415.37
.00
2,220.70
2,779.30
44
8,908.79
8060
Vehicle Maintenance
8,000.00
.00
8,000.00
810.82
.00
7,281.52
718.48
91
3,473.22
8135
Contractual Services
160,000.00
.00
160,000.00
1,799.76
.00
57,341.47
102,658.53
36
214,685.35
8160
Equipment Maintenance
20,000.00
.00
20,000.00
3,688.34
.00
8,708.58
11,291.42
44
22,091.88
8160.002
Maintenance-James Street
5,000.00
.00
5,000.00
.00
.00
.00
5,000.00
0
5,600.93
8185
System Maintenance
125,000.00
.00
125,000.00
859.58
2,982.65
13,375.04
108,642.31
13
55,506.10
9905
Transfer to Debt Service
244,825.00
.00
244,825.00
.00
.00
122,412.50
122,412.50
50
242,725.00
Division 40 - Sewer Treatment Program Totals
$1,850,825.00
$0.00
$1,850,825.00
$59,017.75
$2,982.65
$660,374.84
$1,187,467.51
36%
$1,838,136.11
Unit 11 - Sewer Department Totals
$3,174,490.00
$0.00
$3,174,490.00
$118,243.25
$2,982.65
$1,068,502.61
$2,103,004.74
34%
$3,118,353.45
Unit 12 - Utility Expansion Division 91 - Capital 8133.002
Scada Improvements
20,000.00
.00
20,000.00
.00
.00
.00
20,000.00
0
2,158.00
8133.003
Route 30 Water main
.00
.00
.00
.00
.00
.00
.00
+++
269,614.46
8133.004
Rt 30 Water main-Kuusakoski to Tower 2
100,000.00
.00
100,000.00
.00
.00
87,610.85
12,389.15
88
840,469.88
8134.001
Lift Station Improvements
170,000.00
.00
170,000.00
.00
.00
.00
170,000.00
0
181,130.00
8134.002
Pump Station Improvements
.00
.00
.00
199,890.00
.00
200,712.50
(200,712.50)
+++
56,524.82
8135
Contractual Services
210,000.00
.00
210,000.00
.00
.00
.00
210,000.00
0
.00
8225
Engineering Fees
150,000.00
.00
150,000.00
3,985.95
.00
29,931.48
120,068.52
20
40,152.25
9120
Machinery and Equipment
12,894.14
9125
Vehicles Division 91 - Capital Totals
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
.00
.00
.00
.00
.00
5,996.80
(5,996.80)
+++
180,000.00
.00
180,000.00
39,490.00
.00
39,490.00
140,510.00
22
.00
$830,000.00
$0.00
$830,000.00
$243,365.95
$0.00
$363,741.63
$466,258.37
44%
$1,402,943.55
Page 18 of 27
Budget Performance Report Fiscal Year to Date 10/31/17 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 02 - Water and Sewer Fund EXPENSE Unit 12 - Utility Expansion Division 92 - Bonds 9200.012
2013 Refunding-2004A Bond (Principal)
896,000.00
.00
896,000.00
.00
.00
.00
896,000.00
0
794,500.00
9200.013
2013 Refunding-2004A Bond (Interest)
92,960.00
.00
92,960.00
.00
.00
46,480.00
46,480.00
50
100,337.50
9200.014
2013 Refunding-2004B Bond (Principal)
375,000.00
.00
375,000.00
.00
.00
.00
375,000.00
0
365,000.00
9200.015
2013 Refunding-2004B Bond (Interest)
38,650.00
.00
38,650.00
.00
.00
19,325.00
19,325.00
50
43,212.50
9200.018
2005B Bond (Principal)
.00
.00
.00
.00
.00
.00
.00
+++
70,000.00
9200.019
2005B Bond (Interest)
.00
.00
.00
.00
.00
.00
.00
+++
1,259.87
9200.022
2008 Bond (Principal)
500,000.00
.00
500,000.00
.00
.00
.00
500,000.00
0
450,000.00
9200.023
2008 Bond (Interest)
25,000.00
.00
25,000.00
12,500.00
.00
12,500.00
12,500.00
50
47,862.49
9200.032
2015 Refunding-2008 Bond (Principal)
90,000.00
.00
90,000.00
.00
.00
.00
90,000.00
0
90,000.00
9200.033
2015 Refunding-2008 Bond (Interest)
529,750.00
.00
529,750.00
264,875.00
.00
264,875.00
264,875.00
50
531,550.00
9201.001
IEPA Loan (Principal)
158,419.00
.00
158,419.00
.00
.00
78,464.53
79,954.47
50
155,470.01
9201.002
IEPA Loan (Interest)
30,588.00
.00
30,588.00
.00
.00
15,539.02
15,048.98
51
31,808.32
9299
Contra Debt Expense
.00
.00
.00
.00
.00
.00
.00
+++
(2,265,470.01)
Division 92 - Bonds Totals
$2,736,367.00
$0.00
$2,736,367.00
$277,375.00
$0.00
$437,183.55
$2,299,183.45
16%
$415,530.68
Unit 12 - Utility Expansion Totals
$3,566,367.00
$0.00
$3,566,367.00
$520,740.95
$0.00
$800,925.18
$2,765,441.82
22%
$1,818,474.23
EXPENSE TOTALS
$17,302,882.00
$0.00
$17,302,882.00
$2,482,217.48
$10,054.55
$7,016,883.48
$10,275,943.97
41%
$17,294,919.63
REVENUE TOTALS
17,302,882.00
.00
17,302,882.00
1,745,724.83
.00
10,289,694.91
7,013,187.09
59%
18,177,763.03
EXPENSE TOTALS
17,302,882.00
.00
17,302,882.00
2,482,217.48
10,054.55
7,016,883.48
10,275,943.97
41%
17,294,919.63
Fund 02 - Water and Sewer Fund Totals
$0.00
$0.00
$0.00
($736,492.65)
($10,054.55)
$3,272,811.43
($3,262,756.88)
Fund 02 - Water and Sewer Fund Totals
$882,843.40
Fund 03 - Capital Replacement Fund REVENUE 0800.800
Interest Income
.00
.00
.00
2,242.61
.00
13,235.50
(13,235.50)
+++
0800.826
Realized Gain/Loss On Investment
.00
.00
.00
.00
.00
.00
.00
+++
12.64
0800.827
Unrealized Gain/Loss
.00
.00
.00
92.37
.00
(611.99)
611.99
+++
(9,699.66)
$0.00
$0.00
$0.00
$2,334.98
$0.00
$12,623.51
($12,623.51)
+++
$14,602.22
REVENUE TOTALS
.00
.00
.00
2,334.98
.00
12,623.51
(12,623.51)
+++
14,602.22
EXPENSE TOTALS
.00
.00
.00
.00
.00
.00
.00
+++
Fund 03 - Capital Replacement Fund Totals
$0.00
$0.00
$0.00
$2,334.98
$0.00
$12,623.51
($12,623.51)
1,150,000.00
.00
1,150,000.00
126,497.47
.00
548,711.49
601,288.51
48
5,000.00
.00
5,000.00
3,357.53
.00
16,802.51
(11,802.51)
336
15,410.91
$1,155,000.00
$0.00
$1,155,000.00
$129,855.00
$0.00
$565,514.00
$589,486.00
49%
$1,121,004.42
REVENUE TOTALS
24,289.24
Fund 03 - Capital Replacement Fund Totals .00 $14,602.22
Fund 04 - Motor Fuel Tax REVENUE 0450.457
MFT Entitlements
0800.800
Interest Income REVENUE TOTALS
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
1,105,593.51
Page 19 of 27
Budget Performance Report Fiscal Year to Date 10/31/17 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 04 - Motor Fuel Tax EXPENSE Unit 00 - Non-Departmental Division 91 - Capital 9150
Street Improvements
1,005,000.00
.00
1,005,000.00
3,317.30
.00
(72,219.93)
1,077,219.93
-7
863,120.29
Division 91 - Capital Totals
$1,005,000.00
$0.00
$1,005,000.00
$3,317.30
$0.00
($72,219.93)
$1,077,219.93
-7%
$863,120.29
150,000.00
.00
150,000.00
.00
.00
.00
150,000.00
0
.00
Division 99 - Transfers Totals
$150,000.00
$0.00
$150,000.00
$0.00
$0.00
$0.00
$150,000.00
0%
$0.00
Unit 00 - Non-Departmental Totals
$1,155,000.00
$0.00
$1,155,000.00
$3,317.30
$0.00
($72,219.93)
$1,227,219.93
-6%
$863,120.29
EXPENSE TOTALS
$1,155,000.00
$0.00
$1,155,000.00
$3,317.30
$0.00
($72,219.93)
$1,227,219.93
-6%
$863,120.29
REVENUE TOTALS
1,155,000.00
.00
1,155,000.00
129,855.00
.00
565,514.00
589,486.00
49%
1,121,004.42
EXPENSE TOTALS
1,155,000.00
.00
1,155,000.00
3,317.30
.00
(72,219.93)
1,227,219.93
-6%
Fund 04 - Motor Fuel Tax Totals
$0.00
$0.00
$0.00
$126,537.70
$0.00
$637,733.93
($637,733.93)
112,600.00
.00
112,600.00
10,978.12
.00
116,486.16
(3,886.16)
103
500.00
.00
500.00
1,275.40
.00
4,898.31
(4,398.31)
980
797.83
979,300.00
.00
979,300.00
.00
.00
489,650.00
489,650.00
50
970,900.00
Division 99 - Transfers 9901
Transfer to General
Fund 04 - Motor Fuel Tax Totals 863,120.29 $257,884.13
Fund 05 - Bond and Interest Fund REVENUE 0400.401
Property Tax Revenue
0800.800
Interest Income
0999.902
Transfer From Water and Sewer
0999.911
Transfer From Capital REVENUE TOTALS
117,213.82
2,036,125.00
.00
2,036,125.00
.00
.00
1,018,062.50
1,018,062.50
50
2,032,264.47
$3,128,525.00
$0.00
$3,128,525.00
$12,253.52
$0.00
$1,629,096.97
$1,499,428.03
52%
$3,121,176.12
725,000.00
EXPENSE Unit 00 - Non-Departmental Division 92 - Bonds 9200.020
2007 Bond (Principal)
755,000.00
.00
755,000.00
.00
.00
.00
755,000.00
0
9200.021
2007 Bond (Interest)
42,475.00
.00
42,475.00
.00
.00
21,237.50
21,237.50
50
75,100.00
9200.024
2009 Refunding Bond (Principal)
100,000.00
.00
100,000.00
.00
.00
.00
100,000.00
0
100,000.00
9200.025
2009 Refunding Bond (Interest)
12,600.00
.00
12,600.00
.00
.00
6,300.00
6,300.00
50
16,100.00
9200.026
2010 Bond (Principal)
750,000.00
.00
750,000.00
.00
.00
.00
750,000.00
0
720,000.00
9200.027
2010 Bond (Interest)
229,300.00
.00
229,300.00
.00
.00
114,650.00
114,650.00
50
250,900.00
9200.028
2012 Refunding Bond (Principal)
660,000.00
.00
660,000.00
.00
.00
.00
660,000.00
0
645,000.00
9200.029
2012 Refunding Bond (Interest)
175,200.00
.00
175,200.00
.00
.00
87,600.00
87,600.00
50
188,100.00
9200.030
2014 Refunding- 2007 Bond (Principal)
130,000.00
.00
130,000.00
.00
.00
.00
130,000.00
0
125,000.00
9200.031
2014 Refunding- 2007 Bond (Interest)
273,450.00
.00
273,450.00
.00
.00
136,725.00
136,725.00
50
275,950.00
Division 92 - Bonds Totals
$3,128,025.00
$0.00
$3,128,025.00
$0.00
$0.00
$366,512.50
$2,761,512.50
12%
$3,121,150.00
Unit 00 - Non-Departmental Totals
$3,128,025.00
$0.00
$3,128,025.00
$0.00
$0.00
$366,512.50
$2,761,512.50
12%
$3,121,150.00
EXPENSE TOTALS
$3,128,025.00
$0.00
$3,128,025.00
$0.00
$0.00
$366,512.50
$2,761,512.50
12%
$3,121,150.00
Fund 05 - Bond and Interest Fund Totals
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
Page 20 of 27
Budget Performance Report Fiscal Year to Date 10/31/17 Exclude Rollup Account
Account
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions
Rec'd
Prior Year Total
REVENUE TOTALS
3,128,525.00
.00
3,128,525.00
12,253.52
.00
1,629,096.97
1,499,428.03
52%
3,121,176.12
EXPENSE TOTALS
3,128,025.00
.00
3,128,025.00
.00
.00
366,512.50
2,761,512.50
12%
3,121,150.00
Fund 05 - Bond and Interest Fund Totals
$500.00
$0.00
$500.00
$12,253.52
$0.00
$1,262,584.47
($1,262,084.47)
625,000.00
.00
625,000.00
57,698.98
.00
612,430.46
12,569.54
98
621,534.63
100.00
.00
100.00
275.77
.00
422.60
(322.60)
423
164.54
.00
.00
.00
.00
.00
.00
.00
+++
55.00
$625,100.00
$0.00
$625,100.00
$57,974.75
$0.00
$612,853.06
$12,246.94
98%
$621,754.17
500.00
.00
500.00
.00
.00
336.00
164.00
67
336.00
280,000.00
.00
280,000.00
500.00
.00
156,425.00
123,575.00
56
268,633.00
Account Description
Budget - YTD % Used/
$26.12
Fund 07 - Tort Immunity Fund REVENUE 0400.401
Property Tax Revenue
0800.800
Interest Income
0805.000
Other Reimbursements REVENUE TOTALS
EXPENSE Unit 00 - Non-Departmental Division 00 - Non-Divisional 8275
Bond-Treasurer
8300
Commercial Umbrella Liability
8310
Workman's Compensation Ins.
344,600.00
.00
344,600.00
.00
.00
221,340.00
123,260.00
64
325,852.00
Division 00 - Non-Divisional Totals
$625,100.00
$0.00
$625,100.00
$500.00
$0.00
$378,101.00
$246,999.00
60%
$594,821.00
Unit 00 - Non-Departmental Totals
$625,100.00
$0.00
$625,100.00
$500.00
$0.00
$378,101.00
$246,999.00
60%
$594,821.00
EXPENSE TOTALS
$625,100.00
$0.00
$625,100.00
$500.00
$0.00
$378,101.00
$246,999.00
60%
$594,821.00
REVENUE TOTALS
625,100.00
.00
625,100.00
57,974.75
.00
612,853.06
12,246.94
98%
621,754.17
EXPENSE TOTALS
625,100.00
.00
625,100.00
500.00
.00
378,101.00
246,999.00
60%
594,821.00
Fund 07 - Tort Immunity Fund Totals
$0.00
$0.00
$0.00
$57,474.75
$0.00
$234,752.06
($234,752.06)
42,000.00
.00
42,000.00
3,914.68
.00
41,548.90
451.10
99
50.00
.00
50.00
23.44
.00
118.44
(68.44)
237
72.05
REVENUE TOTALS
$42,050.00
$0.00
$42,050.00
$3,938.12
$0.00
$41,667.34
$382.66
99%
$42,323.83
42,000.00
.00
42,000.00
24,100.00
.00
29,425.00
12,575.00
70
39,142.00
Division 00 - Non-Divisional Totals
$42,000.00
$0.00
$42,000.00
$24,100.00
$0.00
$29,425.00
$12,575.00
70%
$39,142.00
Unit 00 - Non-Departmental Totals
$42,000.00
$0.00
$42,000.00
$24,100.00
$0.00
$29,425.00
$12,575.00
70%
$39,142.00
EXPENSE TOTALS
$42,000.00
$0.00
$42,000.00
$24,100.00
$0.00
$29,425.00
$12,575.00
70%
$39,142.00
REVENUE TOTALS
42,050.00
.00
42,050.00
3,938.12
.00
41,667.34
382.66
99%
42,323.83
EXPENSE TOTALS
42,000.00
.00
42,000.00
24,100.00
.00
29,425.00
12,575.00
70%
39,142.00
Fund 08 - Audit Fund Totals
$50.00
$0.00
$50.00
($20,161.88)
$0.00
$12,242.34
($12,192.34)
Fund 07 - Tort Immunity Fund Totals
$26,933.17
Fund 08 - Audit Fund REVENUE 0400.401
Property Tax Revenue
0800.800
Interest Income
42,251.78
EXPENSE Unit 00 - Non-Departmental Division 00 - Non-Divisional 8315
Audit Village
Fund 08 - Audit Fund Totals
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
$3,181.83
Page 21 of 27
Budget Performance Report Fiscal Year to Date 10/31/17 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 10 - Police Pension Fund REVENUE 0800.800
Interest Income
500,000.00
.00
500,000.00
74.28
.00
201,065.94
298,934.06
40
784,139.57
0800.824
Realized Gain/Loss-SawyerFalduto
.00
.00
.00
.00
.00
(4,895.19)
4,895.19
+++
(66,865.73)
0800.826
Realized Gain/Loss On Investment
175,000.00
.00
175,000.00
.00
.00
.00
175,000.00
0
.00
0800.827
Unrealized Gain/Loss
300,000.00
.00
300,000.00
.00
.00
.00
300,000.00
0
.00
0800.829
Unrealized Gain/Loss Sawyer/Fald
.00
.00
.00
.00
.00
1,140,174.11
(1,140,174.11)
+++
1,646,913.00
0818.000
Employee Contributions
575,000.00
.00
575,000.00
.00
.00
221,213.77
353,786.23
38
509,526.26
0819.000
Employer Contributions
1,370,000.00
.00
1,370,000.00
126,352.87
.00
1,341,083.21
28,916.79
98
1,101,142.15
$2,920,000.00
$0.00
$2,920,000.00
$126,427.15
$0.00
$2,898,641.84
$21,358.16
99%
$3,974,855.25
5,000.00
.00
5,000.00
1,672.97
.00
1,672.97
3,327.03
33
4,169.95
500.00
.00
500.00
.00
.00
.00
500.00
0
.00
REVENUE TOTALS EXPENSE Unit 00 - Non-Departmental Division 00 - Non-Divisional 3000
Travel/Training
5005
Office Supplies/Postage
5015
Dues & Subscriptions
5,500.00
.00
5,500.00
.00
.00
4,945.25
554.75
90
5,560.27
8135
Contractual Services
30,000.00
.00
30,000.00
.00
.00
16,215.78
13,784.22
54
32,081.70
8137
Investment Expense
85,000.00
.00
85,000.00
.00
.00
23,726.00
61,274.00
28
87,300.00
8330
Pension Payments
485,000.00
.00
485,000.00
40,893.17
.00
245,359.02
239,640.98
51
442,742.40
Division 00 - Non-Divisional Totals
$611,000.00
$0.00
$611,000.00
$42,566.14
$0.00
$291,919.02
$319,080.98
48%
$571,854.32
Unit 00 - Non-Departmental Totals
$611,000.00
$0.00
$611,000.00
$42,566.14
$0.00
$291,919.02
$319,080.98
48%
$571,854.32
EXPENSE TOTALS
$611,000.00
$0.00
$611,000.00
$42,566.14
$0.00
$291,919.02
$319,080.98
48%
$571,854.32
REVENUE TOTALS
2,920,000.00
.00
2,920,000.00
126,427.15
.00
2,898,641.84
21,358.16
99%
3,974,855.25
EXPENSE TOTALS
611,000.00
.00
611,000.00
42,566.14
.00
291,919.02
319,080.98
48%
Fund 10 - Police Pension Fund Totals
$2,309,000.00
$0.00
$2,309,000.00
$83,861.01
$0.00
$2,606,722.82
($297,722.82)
Fund 10 - Police Pension Fund Totals 571,854.32 $3,403,000.93
Fund 11 - Capital Improvement Fund REVENUE 0450.450
Home Rule Sales Tax
2,900,000.00
.00
2,900,000.00
230,287.79
.00
1,352,783.08
1,547,216.92
47
3,492,459.42
0500.502
Utility Tax
2,800,000.00
.00
2,800,000.00
187,675.59
.00
1,331,635.77
1,468,364.23
48
2,915,444.66
0570.856
Bike Path Fee
500.00
.00
500.00
.00
.00
.00
500.00
0
.00
0570.876
Recapture Fee
5,000.00
.00
5,000.00
932.52
.00
1,865.04
3,134.96
37
10,030.89
0650.670
Impound Fee
30,000.00
.00
30,000.00
2,250.00
.00
13,000.00
17,000.00
43
22,852.50
0650.673
Daily Storage Fee for Impound
5,000.00
.00
5,000.00
.00
.00
860.00
4,140.00
17
1,475.00
0650.675
Red Light Fines
255,000.00
.00
255,000.00
38,700.00
.00
213,400.00
41,600.00
84
348,306.07
0700.100
STP Grant(143rd St)
1,233,739.00
.00
1,233,739.00
.00
.00
.00
1,233,739.00
0
593,863.73
0700.650
Grant Revenue
500,000.00
.00
500,000.00
.00
.00
.00
500,000.00
0
49,471.07
0800.800
Interest Income
31,886.00
.00
31,886.00
11,124.07
.00
56,205.41
(24,319.41)
176
39,065.34
0803.000
Sales-Fixed Assets
5,000.00
.00
5,000.00
.00
.00
.00
5,000.00
0
.00
0805.000
Other Reimbursements
5,800,000.00
.00
5,800,000.00
.00
.00
135,258.36
5,664,741.64
2
95,942.30
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
Page 22 of 27
Budget Performance Report Fiscal Year to Date 10/31/17 Exclude Rollup Account
Account
Account Description
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Budget - YTD % Used/ Transactions
5,000.00
.00
5,000.00
25.00
.00
175.00
4,825.00
4
500.00
.00
.00
.00
.00
.00
.00
.00
+++
2,189,567.00
Rec'd
Prior Year Total
Fund 11 - Capital Improvement Fund REVENUE 0806.000
Other Receipts
0999.901
Transfer From General
0999.917
Transfer From TIF
500,000.00
.00
500,000.00
.00
.00
.00
500,000.00
0
500,000.00
REVENUE TOTALS
$14,071,125.00
$0.00
$14,071,125.00
$470,994.97
$0.00
$3,105,182.66
$10,965,942.34
22%
$10,258,977.98
110,000.00
.00
110,000.00
9,190.00
.00
36,875.57
73,124.43
34
110,742.39
Division 00 - Non-Divisional Totals
$110,000.00
$0.00
$110,000.00
$9,190.00
$0.00
$36,875.57
$73,124.43
34%
$110,742.39
EXPENSE Unit 00 - Non-Departmental Division 00 - Non-Divisional 8135
Contractual Services Division 91 - Capital
8135.006
Emerald Ash Borer
200,000.00
.00
200,000.00
.00
.00
.00
200,000.00
0
279,983.00
8225
Engineering Fees
100,000.00
.00
100,000.00
1,837.50
.00
18,344.46
81,655.54
18
106,348.64
9105
Building Improvements
200,000.00
.00
200,000.00
.00
.00
68,700.50
131,299.50
34
96,014.15
9105.005
Building Improvements-Police
.00
.00
.00
.00
.00
.00
.00
+++
32.47
9107.002
127th St-Plfd/Naperville Rd
100,000.00
.00
100,000.00
.00
.00
.00
100,000.00
0
.00
9107.004
Rt 30 and 143rd
10,000.00
.00
10,000.00
.00
.00
.00
10,000.00
0
.00
9112
Sidewalk Curb & Bikepath Replace
500,000.00
.00
500,000.00
1,828.51
.00
158,991.02
341,008.98
32
163,591.79
9120.005
Machinery and Equipment-Police
225,000.00
.00
225,000.00
21,246.32
.00
171,805.75
53,194.25
76
231,378.31
9120.008
Machinery and Equipment-Public Works
325,000.00
.00
325,000.00
9,567.35
9,410.53
15,455.24
300,134.23
8
303,607.42
9152.001
Street Lights-Replacement
125,000.00
.00
125,000.00
.00
.00
.00
125,000.00
0
74,735.42
9152.002
School Beacon Upgrades
5,000.00
.00
5,000.00
3,467.00
3,467.00
3,467.00
(1,934.00)
139
.00
9152.003
PCI Pavement Inspection
.00
.00
.00
.00
.00
.00
.00
+++
73,975.00
9152.004
Settler's Park-Campus Refresh
90,000.00
.00
90,000.00
291.70
.00
291.70
89,708.30
0
168,834.15
9152.005
Ft. Beggs Street Lighting
.00
.00
.00
.00
.00
.00
.00
+++
205,829.84
9152.006
PACE Park-N-Ride
5,800,000.00
.00
5,800,000.00
.00
.00
135,258.36
5,664,741.64
2
99,187.41
9152.007
Gateway Signage
50,000.00
.00
50,000.00
.00
.00
.00
50,000.00
0
.00
9155
Bridge Repairs & Reconstruction
425,000.00
.00
425,000.00
.00
.00
.00
425,000.00
0
.00
9156
Storm & Drainage Improvements
45,000.00
.00
45,000.00
.00
.00
7,293.89
37,706.11
16
9,685.86
9164
Pavement Patching
125,000.00
.00
125,000.00
(115,855.00)
.00
115,855.00
9,145.00
93
74,678.34
9165
Roadway Improvements
1,000,000.00
.00
1,000,000.00
946,021.73
.00
929,838.91
70,161.09
93
485,235.47
9165.009
143rd St. Extension Phase 2
1,400,000.00
.00
1,400,000.00
.00
.00
53,881.37
1,346,118.63
4
711,301.02
9165.019
I-55 Interchange Design
320,000.00
.00
320,000.00
89,549.18
.00
132,878.74
187,121.26
42
33,290.79
9165.028
Renwick Corridor
70,000.00
.00
70,000.00
.00
.00
14,809.21
55,190.79
21
7,122.85
9165.029
Rt 30 Reconstruction-Village Portion
.00
.00
.00
.00
.00
.00
.00
+++
104,582.20
9165.030
127th-Heggs to Meadow
680,000.00
.00
680,000.00
.00
.00
198,873.00
481,127.00
29
263,729.61
9165.031
Village Green
130,000.00
.00
130,000.00
974.74
.00
11,510.06
118,489.94
9
2,642.63
$11,925,000.00
$0.00
$11,925,000.00
$958,929.03
$12,877.53
$2,037,254.21
$9,874,868.26
17%
$3,495,786.37
2,036,125.00
.00
2,036,125.00
.00
.00
1,018,062.50
1,018,062.50
50
2,032,264.47
Division 91 - Capital Totals Division 99 - Transfers 9905
Transfer to Debt Service
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
Page 23 of 27
Budget Performance Report Fiscal Year to Date 10/31/17 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 11 - Capital Improvement Fund EXPENSE Unit 00 - Non-Departmental Division 99 - Transfers Totals
$2,036,125.00
$0.00
$2,036,125.00
$0.00
$0.00
$1,018,062.50
$1,018,062.50
50%
$2,032,264.47
Unit 00 - Non-Departmental Totals
$14,071,125.00
$0.00
$14,071,125.00
$968,119.03
$12,877.53
$3,092,192.28
$10,966,055.19
22%
$5,638,793.23
EXPENSE TOTALS
$14,071,125.00
$0.00
$14,071,125.00
$968,119.03
$12,877.53
$3,092,192.28
$10,966,055.19
22%
$5,638,793.23
REVENUE TOTALS
14,071,125.00
.00
14,071,125.00
470,994.97
.00
3,105,182.66
10,965,942.34
22%
10,258,977.98
EXPENSE TOTALS
14,071,125.00
.00
14,071,125.00
968,119.03
12,877.53
3,092,192.28
10,966,055.19
22%
Fund 11 - Capital Improvement Fund Totals
$0.00
$0.00
$0.00
($497,124.06)
($12,877.53)
$12,990.38
($112.85)
Fund 11 - Capital Improvement Fund Totals 5,638,793.23 $4,620,184.75
Fund 14 - D.A.R.E. Fund REVENUE 0800.800
Interest Income
0801.840
DARE Contribution
20.00
.00
20.00
5.37
.00
15.46
4.54
77
44.93
20,000.00
.00
20,000.00
17,529.53
.00
21,940.53
(1,940.53)
110
18,294.57
REVENUE TOTALS
$20,020.00
$0.00
$20,020.00
$17,534.90
$0.00
$21,955.99
($1,935.99)
110%
$18,339.50
20,000.00
.00
20,000.00
770.22
.00
2,731.22
17,268.78
14
21,529.69
Division 00 - Non-Divisional Totals
$20,000.00
$0.00
$20,000.00
$770.22
$0.00
$2,731.22
$17,268.78
14%
$21,529.69
Unit 00 - Non-Departmental Totals
$20,000.00
$0.00
$20,000.00
$770.22
$0.00
$2,731.22
$17,268.78
14%
$21,529.69
EXPENSE TOTALS
$20,000.00
$0.00
$20,000.00
$770.22
$0.00
$2,731.22
$17,268.78
14%
$21,529.69
REVENUE TOTALS
20,020.00
.00
20,020.00
17,534.90
.00
21,955.99
(1,935.99)
110%
18,339.50
EXPENSE TOTALS
20,000.00
.00
20,000.00
770.22
.00
2,731.22
17,268.78
14%
Fund 14 - D.A.R.E. Fund Totals
$20.00
$0.00
$20.00
$16,764.68
$0.00
$19,224.77
($19,204.77)
745,000.00
.00
745,000.00
64,081.52
.00
672,905.99
72,094.01
90
2,000.00
.00
2,000.00
1,079.52
.00
4,342.20
(2,342.20)
217
5,190.49
$747,000.00
$0.00
$747,000.00
$65,161.04
$0.00
$677,248.19
$69,751.81
91%
$742,112.55
429,675.92
EXPENSE Unit 00 - Non-Departmental Division 00 - Non-Divisional 8245
D.A.R.E. Program
Fund 14 - D.A.R.E. Fund Totals 21,529.69 ($3,190.19)
Fund 17 - Tax Increment Financing Fund REVENUE 0400.401
Property Tax Revenue
0800.800
Interest Income REVENUE TOTALS
736,922.06
EXPENSE Unit 00 - Non-Departmental Division 91 - Capital 8135
Contractual Services
450,000.00
.00
450,000.00
3,078.55
.00
64,964.15
385,035.85
14
9199
Facade Improvements
125,000.00
.00
125,000.00
70,196.65
.00
96,393.58
28,606.42
77
157,162.33
$575,000.00
$0.00
$575,000.00
$73,275.20
$0.00
$161,357.73
$413,642.27
28%
$586,838.25
50,000.00
.00
50,000.00
.00
.00
.00
50,000.00
0
.00
Division 91 - Capital Totals Division 99 - Transfers 9901
Transfer to General
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
Page 24 of 27
Budget Performance Report Fiscal Year to Date 10/31/17 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 17 - Tax Increment Financing Fund EXPENSE Unit 00 - Non-Departmental Division 99 - Transfers 9911
Transfer to Capital Improvements
500,000.00
.00
500,000.00
.00
.00
.00
500,000.00
0
500,000.00
Division 99 - Transfers Totals
$550,000.00
$0.00
$550,000.00
$0.00
$0.00
$0.00
$550,000.00
0%
$500,000.00
Unit 00 - Non-Departmental Totals
$1,125,000.00
$0.00
$1,125,000.00
$73,275.20
$0.00
$161,357.73
$963,642.27
14%
$1,086,838.25
EXPENSE TOTALS
$1,125,000.00
$0.00
$1,125,000.00
$73,275.20
$0.00
$161,357.73
$963,642.27
14%
$1,086,838.25
REVENUE TOTALS
747,000.00
.00
747,000.00
65,161.04
.00
677,248.19
69,751.81
91%
742,112.55
EXPENSE TOTALS
1,125,000.00
.00
1,125,000.00
73,275.20
.00
161,357.73
963,642.27
14%
1,086,838.25
Fund 17 - Tax Increment Financing Fund Totals
($378,000.00)
$0.00
($378,000.00)
($8,114.16)
$0.00
$515,890.46
($893,890.46)
Fund 17 - Tax Increment Financing Fund Totals
($344,725.70)
Fund 26 - Sex Offender's Registration Fund REVENUE 0600.606
Sex Offenders Registration
.00
.00
.00
110.00
.00
610.00
(610.00)
+++
0800.800
Interest Income
.00
.00
.00
2.24
.00
9.62
(9.62)
+++
950.00 9.11
REVENUE TOTALS
$0.00
$0.00
$0.00
$112.24
$0.00
$619.62
($619.62)
+++
$959.11
.00
.00
.00
210.00
.00
420.00
(420.00)
+++
1,015.00
Division 00 - Non-Divisional Totals
$0.00
$0.00
$0.00
$210.00
$0.00
$420.00
($420.00)
+++
$1,015.00
Unit 00 - Non-Departmental Totals
$0.00
$0.00
$0.00
$210.00
$0.00
$420.00
($420.00)
+++
$1,015.00
EXPENSE TOTALS
$0.00
$0.00
$0.00
$210.00
$0.00
$420.00
($420.00)
+++
$1,015.00
REVENUE TOTALS
.00
.00
.00
112.24
.00
619.62
(619.62)
+++
959.11
EXPENSE TOTALS
.00
.00
.00
210.00
.00
420.00
(420.00)
+++
1,015.00
Fund 26 - Sex Offender's Registration Fund Totals
$0.00
$0.00
$0.00
($97.76)
$0.00
$199.62
($199.62)
15,000.00
.00
15,000.00
.00
.00
7,992.00
7,008.00
53
100.00
.00
100.00
48.05
.00
208.33
(108.33)
208
207.30
REVENUE TOTALS
$15,100.00
$0.00
$15,100.00
$48.05
$0.00
$8,200.33
$6,899.67
54%
$16,852.30
20,000.00
.00
20,000.00
.00
.00
.00
20,000.00
0
12,000.00
Division 99 - Transfers Totals
$20,000.00
$0.00
$20,000.00
$0.00
$0.00
$0.00
$20,000.00
0%
$12,000.00
Unit 00 - Non-Departmental Totals
$20,000.00
$0.00
$20,000.00
$0.00
$0.00
$0.00
$20,000.00
0%
$12,000.00
EXPENSE Unit 00 - Non-Departmental Division 00 - Non-Divisional 9290
Sex Offender's Registration Fee
Fund 26 - Sex Offender's Registration Fund Totals
($55.89)
Fund 27 - Alcohol Enforcement Fund REVENUE 0600.610
Alcohol Fines
0800.800
Interest Income
16,645.00
EXPENSE Unit 00 - Non-Departmental Division 99 - Transfers 9901
Transfer to General
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
Page 25 of 27
Budget Performance Report Fiscal Year to Date 10/31/17 Exclude Rollup Account
Account
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions
Rec'd
Prior Year Total
$20,000.00
$0.00
$20,000.00
$0.00
$0.00
$0.00
$20,000.00
0%
$12,000.00
REVENUE TOTALS
15,100.00
.00
15,100.00
48.05
.00
8,200.33
6,899.67
54%
16,852.30
EXPENSE TOTALS
20,000.00
.00
20,000.00
.00
.00
.00
20,000.00
0%
12,000.00
Fund 27 - Alcohol Enforcement Fund Totals
($4,900.00)
$0.00
($4,900.00)
$48.05
$0.00
$8,200.33
($13,100.33)
Account Description
Budget - YTD % Used/
Fund 27 - Alcohol Enforcement Fund EXPENSE TOTALS Fund 27 - Alcohol Enforcement Fund Totals
$4,852.30
Fund 28 - Drug Enforcement Fund REVENUE 0600.611
Drug Fines
.00
.00
.00
.00
.00
308.00
(308.00)
+++
0800.800
Interest Income
.00
.00
.00
38.75
.00
177.25
(177.25)
+++
172.97
$0.00
$0.00
$0.00
$38.75
$0.00
$485.25
($485.25)
+++
$920.97
REVENUE TOTALS
.00
.00
.00
38.75
.00
485.25
(485.25)
+++
920.97
EXPENSE TOTALS
.00
.00
.00
.00
.00
.00
.00
+++
Fund 28 - Drug Enforcement Fund Totals
$0.00
$0.00
$0.00
$38.75
$0.00
$485.25
($485.25)
REVENUE TOTALS
748.00
Fund 28 - Drug Enforcement Fund Totals .00 $920.97
Fund 29 - Police Vehicle Replacement Fund REVENUE 0600.612
Vehicle Replacement-Will
.00
.00
.00
2,380.00
.00
18,642.00
(18,642.00)
+++
0800.800
Interest Income
.00
.00
.00
172.36
.00
764.76
(764.76)
+++
650.77
$0.00
$0.00
$0.00
$2,552.36
$0.00
$19,406.76
($19,406.76)
+++
$33,104.77
REVENUE TOTALS
.00
.00
.00
2,552.36
.00
19,406.76
(19,406.76)
+++
33,104.77
EXPENSE TOTALS
.00
.00
.00
.00
.00
.00
.00
+++
Fund 29 - Police Vehicle Replacement Fund Totals
$0.00
$0.00
$0.00
$2,552.36
$0.00
$19,406.76
($19,406.76)
REVENUE TOTALS
32,454.00
Fund 29 - Police Vehicle Replacement Fund Totals .00 $33,104.77
Fund 40 - PEMA Fund REVENUE 0800.800
Interest Income
.00
.00
.00
17.05
.00
84.91
(84.91)
+++
80.73
0801.822
Donation/Contribution
.00
.00
.00
.00
.00
500.00
(500.00)
+++
4,757.69
REVENUE TOTALS
$0.00
$0.00
$0.00
$17.05
$0.00
$584.91
($584.91)
+++
$4,838.42
.00
.00
.00
.00
.00
2,347.00
(2,347.00)
+++
.00
Division 00 - Non-Divisional Totals
$0.00
$0.00
$0.00
$0.00
$0.00
$2,347.00
($2,347.00)
+++
$0.00
Unit 00 - Non-Departmental Totals
$0.00
$0.00
$0.00
$0.00
$0.00
$2,347.00
($2,347.00)
+++
$0.00
EXPENSE TOTALS
$0.00
$0.00
$0.00
$0.00
$0.00
$2,347.00
($2,347.00)
+++
$0.00
EXPENSE Unit 00 - Non-Departmental Division 00 - Non-Divisional 9140
PEMA Fundraising
Fund 40 - PEMA Fund Totals
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
Page 26 of 27
Budget Performance Report Fiscal Year to Date 10/31/17 Exclude Rollup Account
Account
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions
Rec'd
Prior Year Total
REVENUE TOTALS
.00
.00
.00
17.05
.00
584.91
(584.91)
+++
4,838.42
EXPENSE TOTALS
.00
.00
.00
.00
.00
2,347.00
(2,347.00)
+++
Fund 40 - PEMA Fund Totals
$0.00
$0.00
$0.00
$17.05
$0.00
($1,762.09)
$1,762.09
REVENUE TOTALS
64,811,117.00
.00
64,811,117.00
4,855,968.48
.00
36,333,756.96
28,477,360.04
56%
62,432,575.85
EXPENSE TOTALS
62,884,447.00
.00
62,884,447.00
5,636,322.81
49,418.36
22,810,971.19
40,024,057.45
36%
53,321,796.97
Grand Totals
$1,926,670.00
$0.00
$1,926,670.00
($780,354.33)
($49,418.36)
$13,522,785.77
($11,546,697.41)
Account Description
Budget - YTD % Used/
.00 $4,838.42
Grand Totals
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
$9,110,778.88
Page 27 of 27
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,186,939.65
Fund 01 - General Fund REVENUE 0400.401
Property Tax Revenue
3,160,000.00
.00
3,160,000.00
299,855.92
.00
3,182,823.85
(22,823.85)
101
0400.402
Property Tax Rev-Road & Bridge
375,000.00
.00
375,000.00
35,239.40
.00
357,385.87
17,614.13
95
357,161.29
0400.403
Property Tax Rev-Police Pension
1,370,000.00
.00
1,370,000.00
126,352.87
.00
1,341,083.21
28,916.79
98
1,101,142.15
0400.404
Property Tax Revenue-IMRF
575,000.00
.00
575,000.00
53,060.93
.00
563,200.71
11,799.29
98
575,655.27
0450.450
Home Rule Sales Tax
500,000.00
.00
500,000.00
66,853.43
.00
392,718.13
107,281.87
79
.00
0450.451
Municipal Sales Tax
5,400,000.00
.00
5,400,000.00
466,308.05
.00
2,700,654.94
2,699,345.06
50
5,354,048.49
0450.452
Illinois Income Tax
3,550,000.00
.00
3,550,000.00
311,496.01
.00
2,460,687.03
1,089,312.97
69
3,741,387.32
0450.453
Replacement Tax
45,000.00
.00
45,000.00
.00
.00
21,796.84
23,203.16
48
56,644.71
0450.455
Local Use Tax
875,000.00
.00
875,000.00
77,673.33
.00
468,475.61
406,524.39
54
974,197.53
0500.500
Hotel/Motel Tax
.00
.00
.00
.00
.00
432.67
(432.67)
+++
198.71
0500.501
Amusement Tax
5,000.00
.00
5,000.00
1,545.82
.00
3,310.19
1,689.81
66
9,892.85
0500.503
Local Motor Fuel Tax
930,000.00
.00
930,000.00
89,260.33
.00
538,591.87
391,408.13
58
959,052.15
0550.551
Liquor License
100,000.00
.00
100,000.00
1,362.40
.00
99,772.01
227.99
100
103,568.00
0550.552
Contractors License
35,000.00
.00
35,000.00
4,150.00
.00
29,850.00
5,150.00
85
47,200.00
0550.553
Cigarette License
5,000.00
.00
5,000.00
.00
.00
6,250.00
(1,250.00)
125
7,000.00
0550.554
Scavenger License
200.00
.00
200.00
.00
.00
100.00
100.00
50
100.00
0550.558
Business License
35,000.00
.00
35,000.00
10,037.50
.00
12,462.50
22,537.50
36
37,788.00
0570.555
Building Permit
925,000.00
.00
925,000.00
105,651.13
.00
516,554.96
408,445.04
56
952,316.60
0570.556
Sign Permit
5,000.00
.00
5,000.00
440.00
.00
2,223.00
2,777.00
44
7,763.00
0570.557
Special Movement Permit
5,000.00
.00
5,000.00
1,225.00
.00
10,085.00
(5,085.00)
202
8,630.00
0570.560
Solicitors Permit
1,000.00
.00
1,000.00
245.00
.00
1,330.00
(330.00)
133
1,785.00
0600.601
County Court Fines
325,000.00
.00
325,000.00
19,276.31
.00
199,409.47
125,590.53
61
367,797.10
0600.602
Administrative Fines(P-Tickets)
130,000.00
.00
130,000.00
10,420.00
.00
60,110.00
69,890.00
46
135,528.00
0600.603
Asset Seizure-Non Federal
225,000.00
.00
225,000.00
1,775.00
.00
7,095.56
217,904.44
3
100,189.55
0600.604
Alarm Fees
7,000.00
.00
7,000.00
450.00
.00
800.00
6,200.00
11
2,025.00
0600.605
Kendall County Court Fines
1,000.00
.00
1,000.00
283.68
.00
1,173.56
(173.56)
117
1,165.84
0600.607
Administrative Fines- Late Fee
10,000.00
.00
10,000.00
380.00
.00
3,465.00
6,535.00
35
9,960.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
14,687.81
(14,687.81)
+++
44,741.22
0600.632
Asset Seizure-Federal (U.S. Treasury Equitable Share)
0620.655
Garbage Fee
0620.656 0640.500 0650.580
Child Safety Seats
0650.651
Zoning Applications
0650.653 0650.654 0650.670
Impound Fee
0650.815
Parking Lot Revenue
.00
.00
.00
.00
.00
.00
.00
+++
921.38
4,112,315.00
.00
4,112,315.00
343,532.52
.00
2,402,014.65
1,710,300.35
58
3,992,763.21
Garbage Penalties
50,000.00
.00
50,000.00
4,850.82
.00
27,949.73
22,050.27
56
55,335.52
Engineering Services
25,000.00
.00
25,000.00
.00
.00
13,375.32
11,624.68
54
33,590.05
100.00
.00
100.00
.00
.00
.00
100.00
0
.00
10,000.00
.00
10,000.00
.00
.00
8,237.88
1,762.12
82
13,162.00
Accident Report Fees
4,000.00
.00
4,000.00
565.00
.00
2,950.00
1,050.00
74
4,585.00
Copies-Maps & Ordinances
3,000.00
.00
3,000.00
252.00
.00
1,423.10
1,576.90
47
2,366.70
30,000.00
.00
30,000.00
2,250.00
.00
13,000.00
17,000.00
43
22,852.50
2,000.00
.00
2,000.00
900.00
.00
1,950.00
50.00
98
4,532.00
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
Page 1 of 27
Budget Performance Report Fiscal Year to Date 10/31/17 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.818
Tower Rent
50,000.00
.00
50,000.00
3,400.17
.00
22,496.28
27,503.72
45
38,191.41
0650.825
Rental Income
50,000.00
.00
50,000.00
4,100.00
.00
24,600.00
25,400.00
49
45,100.00
0650.830
Rental-Community/Multi Room
3,000.00
.00
3,000.00
97.50
.00
1,620.00
1,380.00
54
4,546.75
0650.904
Special Detail/OT Reimbursement
45,000.00
.00
45,000.00
35,368.75
.00
79,867.90
(34,867.90)
177
68,278.93
0690.902
Water & Sewer Service Charge
250,000.00
.00
250,000.00
.00
.00
.00
250,000.00
0
250,000.00
0700.650
Grant Revenue
.00
.00
.00
.00
.00
.00
.00
+++
17,545.00
0700.704
Bulletproof Vest Grant
3,000.00
.00
3,000.00
380.02
.00
380.02
2,619.98
13
3,414.82
0700.710
Tobacco Grant
2,600.00
.00
2,600.00
.00
.00
.00
2,600.00
0
2,750.00
0700.717
Traffic Grant
30,000.00
.00
30,000.00
2,583.62
.00
6,661.97
23,338.03
22
15,038.66
0750.750
AT&T Franchise Fees
250,000.00
.00
250,000.00
649.80
.00
91,677.50
158,322.50
37
209,381.47
0750.751
Cable TV-Franchise Fees
480,000.00
.00
480,000.00
.00
.00
260,691.40
219,308.60
54
533,615.95
0800.800
Interest Income
35,000.00
.00
35,000.00
6,645.84
.00
41,526.66
(6,526.66)
119
88,416.33
0800.826
Realized Gain/Loss On Investment
.00
.00
.00
.00
.00
.00
.00
+++
16.75
0800.827
Unrealized Gain/Loss
.00
.00
.00
190.75
.00
(2,614.83)
2,614.83
+++
(12,136.23)
0800.830
Unrealized Gain/Loss IMET
0801.200
Event Sponsorship Program
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
(994.22)
.00
2,763.53
(2,763.53)
+++
2,391.19
4,000.00
.00
4,000.00
.00
.00
3,450.25
549.75
86
4,096.76
500.00
.00
500.00
.00
.00
1,075.00
(575.00)
215
200.00
.00
.00
.00
.00
.00
.00
.00
+++
9,700.00
500.00
.00
500.00
.00
.00
.00
500.00
0
.00
10,000.00
.00
10,000.00
4,546.29
.00
7,945.29
2,054.71
79
16,376.74
5,000.00
.00
5,000.00
.00
.00
7,500.00
(2,500.00)
150
3,769.00
80,000.00
.00
80,000.00
1,526.00
.00
179,087.31
(99,087.31)
224
86,085.15
25,000.00
.00
25,000.00
6,848.25
.00
9,827.25
15,172.75
39
13,218.83
.00
.00
.00
.00
.00
.00
.00
+++
151,127.00
School Liaison Reimbursement
400,000.00
.00
400,000.00
119,965.55
.00
238,958.03
161,041.97
60
431,372.53
HIDTA/Organized Crime Reimb
10,000.00
.00
10,000.00
.00
.00
5,037.59
4,962.41
50
14,508.38
Transfer From MFT
150,000.00
.00
150,000.00
.00
.00
.00
150,000.00
0
.00
0999.917
Transfer From TIF
50,000.00
.00
50,000.00
.00
.00
.00
50,000.00
0
.00
0999.927
Transfer From Alcohol Enforc.
20,000.00
.00
20,000.00
.00
.00
.00
20,000.00
0
12,000.00
REVENUE TOTALS
$24,784,315.00
$0.00
$24,784,315.00
$2,221,000.77
$0.00
$16,449,981.62
$8,334,333.38
66%
$24,282,991.21
.00
.00
.00
.00
.00
.00
.00
+++
(178,389.69)
Division 94 - Contra Totals
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+++
($178,389.69)
Unit 00 - Non-Departmental Totals
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+++
($178,389.69)
3,808,325.00
.00
3,808,325.00
315,085.24
.00
1,573,970.67
2,234,354.33
41
3,669,782.29
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
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
Page 2 of 27
Budget Performance Report Fiscal Year to Date 10/31/17 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 00 - Non-Divisional 9997
Bad Debt Expense Division 00 - Non-Divisional Totals
.00
.00
.00
.00
.00
.00
.00
+++
134,093.16
$3,808,325.00
$0.00
$3,808,325.00
$315,085.24
$0.00
$1,573,970.67
$2,234,354.33
41%
$3,803,875.45
Division 01 - Legislative Program 1000
Salaries-President
24,000.00
.00
24,000.00
2,000.00
.00
11,666.67
12,333.33
49
20,000.04
1002
Salaries-Elected Officials
25,000.00
.00
25,000.00
1,600.00
.00
12,400.00
12,600.00
50
24,100.00
1003
Salaries-Liquor Commissioner
1,500.00
.00
1,500.00
125.00
.00
750.00
750.00
50
1,500.00
1004
Salaries-Treasurer
2,500.00
.00
2,500.00
208.33
.00
1,249.98
1,250.02
50
2,499.96
2000
FICA
3,300.00
.00
3,300.00
230.54
.00
1,536.16
1,763.84
47
2,783.06
2001
Medicare
780.00
.00
780.00
53.92
.00
359.26
420.74
46
650.87
2010
IMRF
900.00
.00
900.00
.00
.00
232.89
667.11
26
862.41
2020
Employee Insurance
150.00
.00
150.00
12.60
.00
65.10
84.90
43
92.40
3000
Travel/Training
10,000.00
.00
10,000.00
3,347.00
.00
4,972.00
5,028.00
50
3,844.07
5010
Replacement Supplies
3,000.00
.00
3,000.00
.00
.00
.00
3,000.00
0
85.17
5015
Dues & Subscriptions
35,000.00
.00
35,000.00
.00
.00
12,081.15
22,918.85
35
38,761.37
8070
Public Relations
115,000.00
.00
115,000.00
7,808.55
.00
35,843.75
79,156.25
31
113,975.36
8074
Cable TV
10,000.00
.00
10,000.00
.00
.00
19.99
9,980.01
0
17,086.05
8078
Economic Incentive Rebate
175,000.00
.00
175,000.00
45,633.30
.00
76,584.86
98,415.14
44
36,007.59
$406,130.00
$0.00
$406,130.00
$61,019.24
$0.00
$157,761.81
$248,368.19
39%
$262,248.35
Division 01 - Legislative Program Totals Division 02 - Administration Program 1005
Salaries-Full Time
710,000.00
.00
710,000.00
51,737.50
.00
355,688.49
354,311.51
50
688,352.30
1015
Salaries-Part Time
50,000.00
.00
50,000.00
4,638.76
.00
26,537.97
23,462.03
53
45,065.94
1800
Salaries-Overtime
1,000.00
.00
1,000.00
287.55
.00
2,257.18
(1,257.18)
226
339.33
2000
FICA
47,500.00
.00
47,500.00
2,623.44
.00
22,256.78
25,243.22
47
40,632.69
2001
Medicare
11,000.00
.00
11,000.00
810.17
.00
5,498.54
5,501.46
50
10,673.40
2010
IMRF
84,000.00
.00
84,000.00
6,222.01
.00
42,466.90
41,533.10
51
83,197.55
2020
Employee Insurance
109,000.00
.00
109,000.00
7,333.30
.00
52,943.26
56,056.74
49
102,070.61
2025
Deferred Comp. Contribution
25,000.00
.00
25,000.00
.00
.00
.00
25,000.00
0
24,320.71
3000
Travel/Training
15,000.00
.00
15,000.00
209.30
.00
4,343.22
10,656.78
29
9,487.79
3015
IL Unemployment Insurance
7,000.00
.00
7,000.00
900.30
.00
1,867.02
5,132.98
27
3,505.77
4000
Telephone/Internet
5,000.00
.00
5,000.00
335.04
.00
2,547.41
2,452.59
51
4,094.28
4005
Cellular Phones/Pagers
2,500.00
.00
2,500.00
156.49
.00
1,159.30
1,340.70
46
3,004.18
5005
Office Supplies/Postage
30,000.00
.00
30,000.00
2,452.94
.00
14,221.49
15,778.51
47
30,162.77
5015
Dues & Subscriptions
5,000.00
.00
5,000.00
505.00
.00
2,845.00
2,155.00
57
4,072.00
5020
Gas/Oil/Mileage/Carwash
9,500.00
.00
9,500.00
600.00
.00
4,003.82
5,496.18
42
8,259.64
8035
Maintenance Contracts/Lease
8,000.00
.00
8,000.00
.00
.00
3,295.00
4,705.00
41
7,908.00
8045
Recording Fees
2,000.00
.00
2,000.00
.00
.00
.00
2,000.00
0
1,379.49
8050
Legal Notices
2,500.00
.00
2,500.00
.00
.00
349.41
2,150.59
14
1,600.28
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
Page 3 of 27
Budget Performance Report Fiscal Year to Date 10/31/17 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 02 - Administration Program 8065
Legal Fees
50,000.00
.00
50,000.00
.00
.00
6,114.00
43,886.00
12
30,735.50
8135
Contractual Services
75,000.00
.00
75,000.00
10,368.39
.00
29,854.32
45,145.68
40
85,320.19
8225
Engineering Fees
5,000.00
.00
5,000.00
.00
.00
.00
5,000.00
0
2,283.20
9115
Office Furniture & Equipment
5,000.00
.00
5,000.00
.00
.00
189.67
4,810.33
4
4,632.33
9300
Contingencies
45,000.00
.00
45,000.00
.00
.00
.00
45,000.00
0
18,750.00
$1,304,000.00
$0.00
$1,304,000.00
$89,180.19
$0.00
$578,438.78
$725,561.22
44%
$1,209,847.95
Division 02 - Administration Program Totals Division 03 - Community Relations Program 1005
Salaries-Full Time
101,000.00
.00
101,000.00
7,630.88
.00
49,507.67
51,492.33
49
96,782.14
2000
FICA
6,200.00
.00
6,200.00
424.38
.00
2,767.82
3,432.18
45
5,592.49
2001
Medicare
1,450.00
.00
1,450.00
99.25
.00
647.31
802.69
45
1,307.94
2010
IMRF
11,500.00
.00
11,500.00
846.26
.00
5,512.55
5,987.45
48
11,059.04
2020
Employee Insurance
20,700.00
.00
20,700.00
1,615.65
.00
10,390.75
10,309.25
50
18,563.15
2025
Deferred Comp. Contribution
4,000.00
.00
4,000.00
.00
.00
.00
4,000.00
0
3,561.20
3000
Travel/Training
1,500.00
.00
1,500.00
.00
.00
189.00
1,311.00
13
142.50
4000
Telephone/Internet
500.00
.00
500.00
33.50
.00
254.74
245.26
51
409.43
5005
Office Supplies/Postage
750.00
.00
750.00
.00
.00
17.13
732.87
2
81.28
5015
Dues & Subscriptions
750.00
.00
750.00
.00
.00
916.00
(166.00)
122
525.00
5020
Gas/Oil/Mileage/Carwash
100.00
.00
100.00
.00
.00
.00
100.00
0
.00
8030
Server/Network Supplies
2,500.00
.00
2,500.00
.00
.00
.00
2,500.00
0
.00
8070
Public Relations
17,000.00
.00
17,000.00
42.50
.00
5,631.44
11,368.56
33
8,157.09
8071
Marketing and Promotions
2,500.00
.00
2,500.00
.00
.00
.00
2,500.00
0
.00
8072
Settler's Park
7,500.00
.00
7,500.00
.00
.00
4,800.26
2,699.74
64
4,863.03
8135
Contractual Services Division 03 - Community Relations Program Totals
2,500.00
.00
2,500.00
.00
.00
.00
2,500.00
0
.00
$180,450.00
$0.00
$180,450.00
$10,692.42
$0.00
$80,634.67
$99,815.33
45%
$151,044.29
Division 04 - Facility Management Program 1005
Salaries-Full Time
50,000.00
.00
50,000.00
3,827.00
.00
23,165.92
26,834.08
46
33,936.93
1800
Salaries-Overtime
2,500.00
.00
2,500.00
160.34
.00
1,266.55
1,233.45
51
1,705.28
2000
FICA
3,300.00
.00
3,300.00
237.07
.00
1,454.96
1,845.04
44
2,245.20
2001
Medicare
800.00
.00
800.00
55.44
.00
340.29
459.71
43
525.16
2010
IMRF
5,500.00
.00
5,500.00
442.20
.00
2,709.59
2,790.41
49
4,221.28
2020
Employee Insurance
14,000.00
.00
14,000.00
1,066.04
.00
6,175.29
7,824.71
44
9,199.52
5000
Building Maintenance Supplies
7,500.00
.00
7,500.00
987.49
.00
5,534.62
1,965.38
74
9,970.18
5005
Office Supplies/Postage
.00
.00
.00
278.00
.00
278.00
(278.00)
+++
.00
8135
Contractual Services
40,000.00
.00
40,000.00
2,390.00
.00
16,274.13
23,725.87
41
32,624.35
9105
Building Improvements Division 04 - Facility Management Program Totals
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
40,000.00
.00
40,000.00
27,337.40
.00
27,536.40
12,463.60
69
.00
$163,600.00
$0.00
$163,600.00
$36,780.98
$0.00
$84,735.75
$78,864.25
52%
$94,427.90
Page 4 of 27
Budget Performance Report Fiscal Year to Date 10/31/17 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
135,412.15
Fund 01 - General Fund EXPENSE Unit 04 - Administration/Finance Division 06 - Human Resources Program 1005
Salaries-Full Time
165,000.00
.00
165,000.00
12,407.84
.00
80,697.24
84,302.76
49
1800
Salaries-Overtime
500.00
.00
500.00
.00
.00
.00
500.00
0
.00
2000
FICA
10,500.00
.00
10,500.00
729.79
.00
4,765.11
5,734.89
45
8,014.37
2001
Medicare
2,500.00
.00
2,500.00
170.68
.00
1,114.42
1,385.58
45
1,874.33
2010
IMRF
19,000.00
.00
19,000.00
1,376.02
.00
8,971.46
10,028.54
47
15,421.82
2020
Employee Insurance
43,500.00
.00
43,500.00
2,900.74
.00
18,497.03
25,002.97
43
25,578.42
2025
Deferred Comp. Contribution
7,000.00
.00
7,000.00
.00
.00
.00
7,000.00
0
2,894.80
3000
Travel/Training
6,500.00
.00
6,500.00
75.00
.00
4,788.82
1,711.18
74
4,493.94
4000
Telephone/Internet
1,000.00
.00
1,000.00
67.01
.00
509.46
490.54
51
818.87
4005
Cellular Phones/Pagers
600.00
.00
600.00
54.73
.00
164.19
435.81
27
120.00
5005
Office Supplies/Postage
1,500.00
.00
1,500.00
.00
.00
280.40
1,219.60
19
968.66
5015
Dues & Subscriptions
3,200.00
.00
3,200.00
.00
.00
219.00
2,981.00
7
613.00
5020
Gas/Oil/Mileage/Carwash
1,400.00
.00
1,400.00
.00
.00
.00
1,400.00
0
281.88
8070
Public Relations
12,000.00
.00
12,000.00
310.91
.00
3,075.08
8,924.92
26
10,627.42
8071
Marketing and Promotions
8135
Contractual Services Division 06 - Human Resources Program Totals
300.00
.00
300.00
.00
.00
.00
300.00
0
.00
8,000.00
.00
8,000.00
653.44
.00
1,879.44
6,120.56
23
6,462.99
$282,500.00
$0.00
$282,500.00
$18,746.16
$0.00
$124,961.65
$157,538.35
44%
$213,582.65 222,850.22
Division 08 - IT Program 1005
Salaries-Full Time
240,000.00
.00
240,000.00
18,332.34
.00
118,684.01
121,315.99
49
1800
Salaries-Overtime
500.00
.00
500.00
.00
.00
.00
500.00
0
178.60
2000
FICA
15,000.00
.00
15,000.00
1,111.56
.00
7,198.47
7,801.53
48
13,700.47
2001
Medicare
3,500.00
.00
3,500.00
259.95
.00
1,683.52
1,816.48
48
3,204.13
2010
IMRF
28,000.00
.00
28,000.00
2,033.06
.00
13,162.07
14,837.93
47
25,141.33
2020
Employee Insurance
56,000.00
.00
56,000.00
3,276.81
.00
20,939.18
35,060.82
37
39,121.10
2025
Deferred Comp. Contribution
7,000.00
.00
7,000.00
.00
.00
.00
7,000.00
0
8,524.89
3000
Travel/Training
14,500.00
.00
14,500.00
.00
.00
7,284.05
7,215.95
50
19,185.65
4000
Telephone/Internet
500.00
.00
500.00
33.50
.00
254.74
245.26
51
409.42
4005
Cellular Phones/Pagers
2,340.00
.00
2,340.00
192.50
.00
992.10
1,347.90
42
2,211.40
5005
Office Supplies/Postage
1,400.00
.00
1,400.00
83.90
.00
741.41
658.59
53
1,424.65
5015
Dues & Subscriptions
700.00
.00
700.00
99.00
.00
399.00
301.00
57
539.19
5020
Gas/Oil/Mileage/Carwash
400.00
.00
400.00
55.66
.00
379.08
20.92
95
275.49
5095
Uniforms/Clothing
300.00
.00
300.00
146.00
.00
302.82
(2.82)
101
.00
8030
Server/Network Supplies
47,900.00
.00
47,900.00
1,595.79
.00
10,475.69
37,424.31
22
33,660.64
8031
Software Licensing/Renewals
255,380.00
.00
255,380.00
89,074.46
13,647.43
171,695.07
70,037.50
73
220,551.71
8135
Contractual Services
17,880.00
.00
17,880.00
865.99
5,100.00
5,655.99
7,124.01
60
8,366.46
9111
Computers
12,000.00
.00
12,000.00
2,191.70
191.46
7,076.07
4,732.47
61
10,469.04
$703,300.00
$0.00
$703,300.00
$119,352.22
$18,938.89
$366,923.27
$317,437.84
55%
$609,814.39
Division 08 - IT Program Totals
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
Page 5 of 27
Budget Performance Report Fiscal Year to Date 10/31/17 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,189,567.00
Division 99 - Transfers Totals
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+++
$2,189,567.00
Unit 04 - Administration/Finance Totals
$6,848,305.00
$0.00
$6,848,305.00
$650,856.45
$18,938.89
$2,967,426.60
$3,861,939.51
44%
$8,534,407.98
Unit 05 - Police Department Division 02 - Administration Program 1005
Salaries-Full Time
315,000.00
.00
315,000.00
22,864.96
.00
152,457.91
162,542.09
48
302,896.76
1015
Salaries-Part Time
26,296.00
.00
26,296.00
2,561.35
.00
15,808.06
10,487.94
60
19,966.37
1800
Salaries-Overtime
3,000.00
.00
3,000.00
.00
.00
336.39
2,663.61
11
818.91
2000
FICA
21,346.00
.00
21,346.00
1,504.10
.00
9,979.00
11,367.00
47
18,486.24
2001
Medicare
5,000.00
.00
5,000.00
351.77
.00
2,333.81
2,666.19
47
4,531.54
2010
IMRF
23,375.00
.00
23,375.00
1,664.99
.00
10,734.01
12,640.99
46
21,038.04
2020
Employee Insurance
66,780.00
.00
66,780.00
5,177.23
.00
32,923.39
33,856.61
49
59,861.95
2025
Deferred Comp. Contribution
8,000.00
.00
8,000.00
.00
.00
.00
8,000.00
0
5,939.74
3000
Travel/Training
9,975.00
.00
9,975.00
328.57
.00
832.50
9,142.50
8
3,887.92
3001
Education/School
6,000.00
.00
6,000.00
.00
.00
.00
6,000.00
0
433.15
3015
IL Unemployment Insurance
20,000.00
.00
20,000.00
4,646.19
.00
9,152.37
10,847.63
46
17,278.91
4000
Telephone/Internet
605.00
.00
605.00
156.76
.00
718.09
(113.09)
119
1,282.86
4005
Cellular Phones/Pagers
1,644.00
.00
1,644.00
54.73
.00
310.16
1,333.84
19
996.63
5005
Office Supplies/Postage
11,950.00
.00
11,950.00
300.77
.00
1,769.23
10,180.77
15
5,051.83
5010
Replacement Supplies
3,500.00
.00
3,500.00
162.01
.00
368.90
3,131.10
11
707.23
5015
Dues & Subscriptions
7,050.00
.00
7,050.00
875.00
.00
2,720.03
4,329.97
39
3,771.67
5020
Gas/Oil/Mileage/Carwash
3,700.00
.00
3,700.00
151.26
.00
389.79
3,310.21
11
1,342.51
5095
Uniforms/Clothing
1,800.00
.00
1,800.00
193.74
.00
1,422.90
377.10
79
2,345.25
8035
Maintenance Contracts/Lease
7,190.00
.00
7,190.00
.00
.00
2,246.35
4,943.65
31
6,709.70
8040
Custodian
70,000.00
.00
70,000.00
7,295.71
.00
18,786.87
51,213.13
27
52,222.70
8060
Vehicle Maintenance
2,500.00
.00
2,500.00
123.96
.00
123.96
2,376.04
5
1,340.12
8135
Contractual Services
8,000.00
.00
8,000.00
.00
.00
827.99
7,172.01
10
5,465.40
$622,711.00
$0.00
$622,711.00
$48,413.10
$0.00
$264,241.71
$358,469.29
42%
$536,375.43 3,329,739.76
Division 02 - Administration Program Totals Division 51 - Police Operations 1005
Salaries-Full Time
3,918,296.00
.00
3,918,296.00
267,133.26
.00
1,761,061.82
2,157,234.18
45
1015
Salaries-Part Time
.00
.00
.00
23,279.35
.00
122,883.51
(122,883.51)
+++
.00
1800
Salaries-Overtime
380,000.00
.00
380,000.00
24,582.72
.00
171,688.56
208,311.44
45
263,296.45
2000
FICA
266,494.00
.00
266,494.00
19,105.50
.00
124,078.56
142,415.44
47
214,599.36
2001
Medicare
62,325.00
.00
62,325.00
4,468.25
.00
29,018.46
33,306.54
47
50,934.89
2010
IMRF
54,538.00
.00
54,538.00
3,853.69
.00
20,930.39
33,607.61
38
6,289.04
2011
Employer Pension Contributions
1,370,000.00
.00
1,370,000.00
126,352.87
.00
1,341,083.21
28,916.79
98
1,101,142.15
2020
Employee Insurance
630,739.00
.00
630,739.00
45,620.52
.00
294,762.56
335,976.44
47
528,506.74
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
Page 6 of 27
Budget Performance Report Fiscal Year to Date 10/31/17 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 2025
Deferred Comp. Contribution
85,000.00
.00
85,000.00
.00
.00
.00
85,000.00
0
91,161.55
3000
Travel/Training
46,100.00
.00
46,100.00
829.10
.00
21,970.15
24,129.85
48
35,571.37
4000
Telephone/Internet
27,180.00
.00
27,180.00
3,269.15
.00
10,622.37
16,557.63
39
24,799.44
4005
Cellular Phones/Pagers
6,564.00
.00
6,564.00
517.29
.00
2,346.23
4,217.77
36
5,005.24
5005
Office Supplies/Postage
13,000.00
.00
13,000.00
531.67
.00
4,218.13
8,781.87
32
13,298.15
5010
Replacement Supplies
17,000.00
.00
17,000.00
684.08
.00
5,390.96
11,609.04
32
15,849.82
5015
Dues & Subscriptions
3,400.00
.00
3,400.00
.00
.00
110.00
3,290.00
3
1,388.16
5020
Gas/Oil/Mileage/Carwash
100,000.00
.00
100,000.00
7,620.92
.00
38,241.80
61,758.20
38
63,832.78
5068
K-9 Unit
4,000.00
.00
4,000.00
326.70
.00
1,586.99
2,413.01
40
4,513.66
5095
Uniforms/Clothing
33,850.00
.00
33,850.00
3,305.77
.00
19,061.96
14,788.04
56
32,245.78
5100
Ammunition/Weapons
28,000.00
.00
28,000.00
.00
.00
6,419.43
21,580.57
23
25,790.93
5115.001
Traffic Programs
23,000.00
.00
23,000.00
1,161.24
.00
9,484.35
13,515.65
41
21,124.26
8003
Radio Maintenance
2,000.00
.00
2,000.00
.00
.00
1,000.00
1,000.00
50
272.00
8035
Maintenance Contracts/Lease
11,392.00
.00
11,392.00
.00
.00
2,480.00
8,912.00
22
11,702.00
8060
Vehicle Maintenance
65,000.00
.00
65,000.00
2,577.31
.00
26,274.94
38,725.06
40
68,997.15
8069
Bike Unit
2,000.00
.00
2,000.00
.00
.00
399.90
1,600.10
20
.00
8135
Contractual Services
15,000.00
.00
15,000.00
.00
.00
12,478.92
2,521.08
83
14,532.92
8265
Contractual Services-Wescom
593,000.00
.00
593,000.00
47,844.83
.00
287,518.98
305,481.02
48
564,841.56
8267
Animal Control
14,000.00
.00
14,000.00
1,800.00
.00
2,800.00
11,200.00
20
.00
$7,771,878.00
$0.00
$7,771,878.00
$584,864.22
$0.00
$4,317,912.18
$3,453,965.82
56%
$6,489,435.16
Division 51 - Police Operations Totals Division 52 - Police Administration 1005
Salaries-Full Time
859,940.00
.00
859,940.00
70,626.36
.00
478,999.15
380,940.85
56
1,290,355.79
1800
Salaries-Overtime
113,000.00
.00
113,000.00
9,802.18
.00
44,516.15
68,483.85
39
94,858.97
2000
FICA
60,322.00
.00
60,322.00
4,852.11
.00
31,728.96
28,593.04
53
84,083.97
2001
Medicare
14,108.00
.00
14,108.00
1,134.77
.00
7,420.48
6,687.52
53
19,883.44
2020
Employee Insurance
152,801.00
.00
152,801.00
12,907.77
.00
86,640.81
66,160.19
57
210,770.17
2025
Deferred Comp. Contribution
32,000.00
.00
32,000.00
.00
.00
.00
32,000.00
0
40,467.84
3000
Travel/Training
13,600.00
.00
13,600.00
365.00
.00
5,314.08
8,285.92
39
12,631.90
4000
Telephone/Internet
780.00
.00
780.00
196.27
.00
896.47
(116.47)
115
1,593.21
4005
Cellular Phones/Pagers
5,544.00
.00
5,544.00
630.55
.00
3,154.12
2,389.88
57
7,514.02
5005
Office Supplies/Postage
8,500.00
.00
8,500.00
263.18
.00
1,102.07
7,397.93
13
5,293.77
5010
Replacement Supplies
12,000.00
.00
12,000.00
.00
.00
238.00
11,762.00
2
269.21
5015
Dues & Subscriptions
4,070.00
.00
4,070.00
.00
.00
2,000.00
2,070.00
49
3,511.66
5020
Gas/Oil/Mileage/Carwash
29,000.00
.00
29,000.00
1,282.27
.00
7,385.02
21,614.98
25
20,479.50
5040.002
Crime Scene/Evidence Tech Supply
10,800.00
.00
10,800.00
802.26
.00
6,433.45
4,366.55
60
7,337.69
5095
Uniforms/Clothing
5,300.00
.00
5,300.00
106.97
.00
3,056.25
2,243.75
58
10,061.29
5115.004
Community Programs-Explorer Program
2,500.00
.00
2,500.00
212.50
.00
6,209.34
(3,709.34)
248
4,368.54
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
Page 7 of 27
Budget Performance Report Fiscal Year to Date 10/31/17 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 8003
Radio Maintenance
8035
Maintenance Contracts/Lease
8060
Vehicle Maintenance
8246
Shop with a Cop
8250
Background Check Services
8268
Accreditation Division 52 - Police Administration Totals
500.00
.00
500.00
.00
.00
.00
500.00
0
.00
8,920.00
.00
8,920.00
.00
.00
1,464.59
7,455.41
16
4,047.80
15,500.00
.00
15,500.00
1,446.98
.00
5,882.88
9,617.12
38
12,012.78
.00
.00
.00
540.00
.00
540.00
(540.00)
+++
.00
2,500.00
.00
2,500.00
129.80
.00
573.35
1,926.65
23
995.25
8,070.00
.00
8,070.00
.00
.00
4,595.00
3,475.00
57
8,436.68
$1,359,755.00
$0.00
$1,359,755.00
$105,298.97
$0.00
$698,150.17
$661,604.83
51%
$1,838,973.48 401,677.79
Division 53 - Police Records 1005
Salaries-Full Time
463,022.00
.00
463,022.00
36,061.08
.00
234,622.47
228,399.53
51
1015
Salaries-Part Time
.00
.00
.00
2,658.56
.00
5,192.50
(5,192.50)
+++
.00
1800
Salaries-Overtime
6,000.00
.00
6,000.00
920.94
.00
5,833.19
166.81
97
10,112.29
2000
FICA
29,079.00
.00
29,079.00
2,386.66
.00
14,891.19
14,187.81
51
24,805.18
2001
Medicare
6,801.00
.00
6,801.00
558.19
.00
3,482.62
3,318.38
51
5,806.35
2010
IMRF
31,086.00
.00
31,086.00
2,527.70
.00
15,724.96
15,361.04
51
33,212.62
2020
Employee Insurance
129,686.00
.00
129,686.00
8,425.18
.00
55,656.91
74,029.09
43
115,825.74
2025
Deferred Comp. Contribution
15,000.00
.00
15,000.00
.00
.00
.00
15,000.00
0
11,003.04
3000
Travel/Training
2,100.00
.00
2,100.00
453.87
.00
1,741.13
358.87
83
1,796.60
4000
Telephone/Internet
780.00
.00
780.00
196.27
.00
896.47
(116.47)
115
1,593.19
4005
Cellular Phones/Pagers
1,344.00
.00
1,344.00
.00
.00
.00
1,344.00
0
.00
5005
Office Supplies/Postage
13,450.00
.00
13,450.00
460.17
.00
2,704.51
10,745.49
20
7,379.78
5015
Dues & Subscriptions
425.00
.00
425.00
.00
.00
.00
425.00
0
86.67
5095
Uniforms/Clothing
2,400.00
.00
2,400.00
70.00
.00
1,112.88
1,287.12
46
1,610.86
8035
Maintenance Contracts/Lease Division 53 - Police Records Totals
4,460.00
.00
4,460.00
1,425.00
.00
2,325.00
2,135.00
52
2,160.00
$705,633.00
$0.00
$705,633.00
$56,143.62
$0.00
$344,183.83
$361,449.17
49%
$617,070.11
Division 54 - Seizure/Forfeiture 5012
Asset Seizure/Forfeiture Expense Division 54 - Seizure/Forfeiture Totals
225,000.00
.00
225,000.00
1,385.00
.00
9,583.08
215,416.92
4
156,826.56
$225,000.00
$0.00
$225,000.00
$1,385.00
$0.00
$9,583.08
$215,416.92
4%
$156,826.56
32,513.00
.00
32,513.00
33,522.50
.00
63,627.50
(31,114.50)
196
46,555.00
2,016.00
.00
2,016.00
2,032.31
.00
3,854.56
(1,838.56)
191
2,621.16
471.00
.00
471.00
475.30
.00
901.49
(430.49)
191
620.25
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00
0
.00
$36,000.00
$0.00
$36,000.00
$36,030.11
$0.00
$68,383.55
($32,383.55)
190%
$49,796.41
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
773,336.00
.00
773,336.00
49,777.57
.00
314,219.68
459,116.32
41
556,142.29
1015
Salaries-Part Time
.00
.00
.00
.00
.00
.00
.00
+++
210,280.16
1800
Salaries-Overtime
25,000.00
.00
25,000.00
5,858.72
.00
23,042.44
1,957.56
92
28,729.30
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
Page 8 of 27
Budget Performance Report Fiscal Year to Date 10/31/17 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 2000
FICA
49,497.00
.00
49,497.00
3,346.66
.00
21,037.23
28,459.77
43
47,859.97
2001
Medicare
11,576.00
.00
11,576.00
782.68
.00
4,919.96
6,656.04
43
11,230.53
2010
IMRF
5,534.00
.00
5,534.00
409.26
.00
3,585.80
1,948.20
65
49,461.85
2020
Employee Insurance
141,293.00
.00
141,293.00
9,448.51
.00
58,983.47
82,309.53
42
113,185.46
2025
Deferred Comp. Contribution
3000
Travel/Training
4000
Telephone/Internet
4005
Cellular Phones/Pagers
5005
Office Supplies/Postage
5010
7,500.00
.00
7,500.00
.00
.00
.00
7,500.00
0
5,100.00
11,680.00
.00
11,680.00
500.64
.00
8,822.46
2,857.54
76
10,133.37
780.00
.00
780.00
196.27
.00
896.46
(116.46)
115
1,593.21
6,744.00
.00
6,744.00
227.91
.00
1,144.14
5,599.86
17
2,758.96
3,400.00
.00
3,400.00
280.96
.00
638.63
2,761.37
19
2,897.50
Replacement Supplies
5,200.00
.00
5,200.00
21.53
.00
62.50
5,137.50
1
751.72
5015
Dues & Subscriptions
1,900.00
.00
1,900.00
.00
.00
.00
1,900.00
0
1,903.67
5020
Gas/Oil/Mileage/Carwash
16,000.00
.00
16,000.00
937.16
.00
3,612.56
12,387.44
23
14,877.92
5095
Uniforms/Clothing
5,500.00
.00
5,500.00
2,252.62
.00
4,138.81
1,361.19
75
5,956.72
5115.002
Community Programs
8,200.00
.00
8,200.00
.00
.00
3,555.20
4,644.80
43
3,589.54
5115.003
Community Prog.-Alcohol/Tobacco
4,600.00
.00
4,600.00
.00
.00
83.48
4,516.52
2
144.58
8003
Radio Maintenance
24,800.00
.00
24,800.00
.00
.00
2,263.39
22,536.61
9
33,761.09
8035
Maintenance Contracts/Lease
8060
Vehicle Maintenance
8245 8246 8266
Chaplaincy Program
8267
Animal Control
2,180.00
.00
2,180.00
.00
.00
.00
2,180.00
0
1,022.50
14,000.00
.00
14,000.00
205.29
.00
1,571.92
12,428.08
11
22,653.41
D.A.R.E. Program
5,000.00
.00
5,000.00
.00
.00
442.50
4,557.50
9
1,983.00
Shop with a Cop
10,000.00
.00
10,000.00
.00
.00
.00
10,000.00
0
9,500.00
4,600.00
.00
4,600.00
.00
.00
320.30
4,279.70
7
2,654.67
.00
.00
.00
.00
.00
.00
.00
+++
7,140.00
$1,138,320.00
$0.00
$1,138,320.00
$74,245.78
$0.00
$453,340.93
$684,979.07
40%
$1,145,311.42
Division 56 - Community Services Totals Division 57 - Court Services 1005
Salaries-Full Time
124,000.00
.00
124,000.00
9,693.31
.00
62,953.48
61,046.52
51
121,358.68
1015
Salaries-Part Time
47,410.00
.00
47,410.00
1,900.36
.00
12,045.67
35,364.33
25
37,461.41
1800
Salaries-Overtime
1,000.00
.00
1,000.00
.00
.00
110.34
889.66
11
.00
2000
FICA
10,548.00
.00
10,548.00
688.84
.00
4,503.18
6,044.82
43
9,694.79
2001
Medicare
2,467.00
.00
2,467.00
161.10
.00
1,053.17
1,413.83
43
2,267.33
2010
IMRF
20,415.00
.00
20,415.00
1,285.73
.00
8,373.96
12,041.04
41
18,053.80
2020
Employee Insurance
43,998.00
.00
43,998.00
3,079.67
.00
20,359.90
23,638.10
46
37,630.45
2025
Deferred Comp. Contribution
5,500.00
.00
5,500.00
.00
.00
.00
5,500.00
0
4,807.36
3000
Travel/Training
3,000.00
.00
3,000.00
.00
.00
.00
3,000.00
0
161.00
4000
Telephone/Internet
605.00
.00
605.00
138.27
.00
699.55
(94.55)
116
1,282.91
5005
Office Supplies/Postage
10,000.00
.00
10,000.00
812.31
.00
3,078.73
6,921.27
31
8,745.16
5015
Dues & Subscriptions
9,000.00
.00
9,000.00
457.93
.00
3,684.72
5,315.28
41
8,151.47
5095
Uniforms/Clothing
900.00
.00
900.00
.00
.00
241.68
658.32
27
563.88
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
Page 9 of 27
Budget Performance Report Fiscal Year to Date 10/31/17 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,920.00
Fund 01 - General Fund EXPENSE Unit 05 - Police Department Division 57 - Court Services 8035
Maintenance Contracts/Lease
8065
Legal Fees Division 57 - Court Services Totals
1,920.00
.00
1,920.00
.00
.00
800.00
1,120.00
42
27,500.00
.00
27,500.00
300.00
.00
11,525.00
15,975.00
42
8,405.05
$308,263.00
$0.00
$308,263.00
$18,517.52
$0.00
$129,429.38
$178,833.62
42%
$260,503.29
Division 91 - Capital 9115
Office Furniture & Equipment
9120
Machinery and Equipment
11,000.00
.00
11,000.00
.00
.00
.00
11,000.00
0
5,863.91
107,780.00
.00
107,780.00
97,203.40
2,615.94
97,203.40
7,960.66
93
13,396.15
Division 91 - Capital Totals
$118,780.00
$0.00
$118,780.00
$97,203.40
$2,615.94
$97,203.40
$18,960.66
84%
$19,260.06
13,700.00
.00
13,700.00
812.01
.00
5,474.46
8,225.54
40
13,887.78
Division 93 - Contingencies Totals
$13,700.00
$0.00
$13,700.00
$812.01
$0.00
$5,474.46
$8,225.54
40%
$13,887.78
Unit 05 - Police Department Totals
$12,300,040.00
$0.00
$12,300,040.00
$1,022,913.73
$2,615.94
$6,387,902.69
$5,909,521.37
52%
$11,127,439.70
Division 93 - Contingencies 9300
Contingencies
Unit 07 - PEMA Division 07 - PEMA Program 1005
Salaries-Full Time
131,200.00
.00
131,200.00
9,519.84
.00
65,630.30
65,569.70
50
124,512.43
2000
FICA
7,750.00
.00
7,750.00
572.61
.00
3,959.97
3,790.03
51
7,126.33
2001
Medicare
1,813.00
.00
1,813.00
133.92
.00
926.12
886.88
51
1,789.90
2020
Employee Insurance
24,336.00
.00
24,336.00
1,615.65
.00
10,190.75
14,145.25
42
18,319.18
2025
Deferred Comp. Contribution
4,000.00
.00
4,000.00
.00
.00
.00
4,000.00
0
4,021.91
3000
Travel/Training
4,000.00
.00
4,000.00
158.20
.00
625.48
3,374.52
16
571.80
4000
Telephone/Internet
5,400.00
.00
5,400.00
460.99
.00
3,539.43
1,860.57
66
5,346.74
4005
Cellular Phones/Pagers
5,200.00
.00
5,200.00
266.11
.00
1,168.56
4,031.44
22
3,450.61
5005
Office Supplies/Postage
1,300.00
.00
1,300.00
17.88
.00
45.86
1,254.14
4
302.76
5010
Replacement Supplies
11,000.00
.00
11,000.00
.00
.00
1,496.29
9,503.71
14
1,472.80
5015
Dues & Subscriptions
5020
Gas/Oil/Mileage/Carwash
5040
4,000.00
.00
4,000.00
190.00
.00
1,904.00
2,096.00
48
1,909.57
12,000.00
.00
12,000.00
588.38
.00
3,318.07
8,681.93
28
5,235.57
Supplies/Hardware
2,000.00
.00
2,000.00
51.64
.00
422.01
1,577.99
21
181.75
5040.001
Supplies/Hardware-ESDA
2,000.00
.00
2,000.00
.00
.00
91.69
1,908.31
5
616.99
5095
Uniforms/Clothing
5,000.00
.00
5,000.00
859.24
.00
1,559.46
3,440.54
31
4,074.52
5110
Emergency Operation Center
750.00
.00
750.00
.00
.00
.00
750.00
0
.00
5115
Police Public Relations
2,000.00
.00
2,000.00
.00
.00
.00
2,000.00
0
.00
5120
Disaster Plan/Exercises/NIMS
3,000.00
.00
3,000.00
.00
.00
.00
3,000.00
0
26.24
8003
Radio Maintenance
15,000.00
.00
15,000.00
907.36
.00
907.36
14,092.64
6
7,175.99
8020
Building Maintenance
5,000.00
.00
5,000.00
783.36
.00
783.36
4,216.64
16
.00
8035
Maintenance Contracts/Lease
1,800.00
.00
1,800.00
.00
.00
589.50
1,210.50
33
1,311.79
8060
Vehicle Maintenance
15,000.00
.00
15,000.00
1,428.77
.00
7,407.90
7,592.10
49
19,361.46
8069
Bike Unit
500.00
.00
500.00
.00
.00
16.26
483.74
3
.00
8125
Siren Maintenance
20,000.00
.00
20,000.00
537.07
.00
1,407.07
18,592.93
7
9,555.57
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
Page 10 of 27
Budget Performance Report Fiscal Year to Date 10/31/17 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 07 - PEMA Division 07 - PEMA Program 8135
Contractual Services
5,250.00
.00
5,250.00
242.00
.00
1,295.00
3,955.00
25
740.00
8280
Cadet Program
5,500.00
.00
5,500.00
1,544.62
.00
1,544.62
3,955.38
28
2,153.47
8305
PEMA Search and Rescue
8,000.00
.00
8,000.00
.00
.00
.00
8,000.00
0
.00
9115
Office Furniture & Equipment
2,000.00
.00
2,000.00
.00
.00
.00
2,000.00
0
683.52
9120
Machinery and Equipment
5,000.00
.00
5,000.00
.00
.00
.00
5,000.00
0
5,514.30
9300
Contingencies
3,000.00
.00
3,000.00
840.00
.00
840.00
2,160.00
28
1,160.09
Division 07 - PEMA Program Totals
$312,799.00
$0.00
$312,799.00
$20,717.64
$0.00
$109,669.06
$203,129.94
35%
$226,615.29
Unit 07 - PEMA Totals
$312,799.00
$0.00
$312,799.00
$20,717.64
$0.00
$109,669.06
$203,129.94
35%
$226,615.29
272,912.32
Unit 08 - Street Department Division 02 - Administration Program 1005
Salaries-Full Time
288,000.00
.00
288,000.00
21,836.55
.00
141,913.71
146,086.29
49
1015
Salaries-Part Time
.00
.00
.00
.00
.00
328.00
(328.00)
+++
.00
2000
FICA
18,000.00
.00
18,000.00
1,344.55
.00
8,959.80
9,040.20
50
16,762.99
2001
Medicare
4,200.00
.00
4,200.00
314.43
.00
2,095.43
2,104.57
50
4,078.42
2010
IMRF
33,000.00
.00
33,000.00
2,482.68
.00
16,118.42
16,881.58
49
31,772.74
2020
Employee Insurance
59,500.00
.00
59,500.00
4,362.13
.00
27,704.09
31,795.91
47
51,855.39
2025
Deferred Comp. Contribution
8,500.00
.00
8,500.00
.00
.00
.00
8,500.00
0
8,716.04
3000
Travel/Training
10,000.00
.00
10,000.00
486.41
.00
2,197.24
7,802.76
22
9,710.16
3015
IL Unemployment Insurance
4,000.00
.00
4,000.00
.00
.00
.00
4,000.00
0
3,651.67
4000
Telephone/Internet
19,000.00
.00
19,000.00
2,121.44
.00
13,945.87
5,054.13
73
22,890.54
4005
Cellular Phones/Pagers
8,500.00
.00
8,500.00
637.80
.00
3,288.45
5,211.55
39
7,348.00
5005
Office Supplies/Postage
2,500.00
.00
2,500.00
279.05
.00
1,434.39
1,065.61
57
3,583.27
5015
Dues & Subscriptions
3,000.00
.00
3,000.00
.00
.00
831.00
2,169.00
28
2,967.53
5020
Gas/Oil/Mileage/Carwash
300.00
.00
300.00
.00
.00
.00
300.00
0
80.00
5040
Supplies/Hardware
500.00
.00
500.00
.00
.00
199.99
300.01
40
.00
8003
Radio Maintenance
100.00
.00
100.00
.00
.00
.00
100.00
0
.00
8020
Building Maintenance
20,000.00
.00
20,000.00
1,403.99
.00
4,618.10
15,381.90
23
6,475.89
8050
Legal Notices Division 02 - Administration Program Totals
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00
0
.00
$480,100.00
$0.00
$480,100.00
$35,269.03
$0.00
$223,634.49
$256,465.51
47%
$442,804.96 721,757.32
Division 60 - Street Maintenance Program 1005
Salaries-Full Time
810,000.00
.00
810,000.00
61,664.31
.00
395,386.37
414,613.63
49
1015
Salaries-Part Time
75,000.00
.00
75,000.00
1,394.00
.00
76,688.35
(1,688.35)
102
62,433.19
1800
Salaries-Overtime
85,000.00
.00
85,000.00
7,599.37
.00
46,741.45
38,258.55
55
106,835.87
2000
FICA
59,000.00
.00
59,000.00
4,187.39
.00
30,800.93
28,199.07
52
52,747.13
2001
Medicare
14,000.00
.00
14,000.00
979.41
.00
7,203.53
6,796.47
51
12,335.88
2010
IMRF
94,000.00
.00
94,000.00
7,620.35
.00
48,741.71
45,258.29
52
91,864.26
2020
Employee Insurance
193,000.00
.00
193,000.00
15,561.44
.00
98,379.54
94,620.46
51
173,326.22
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
Page 11 of 27
Budget Performance Report Fiscal Year to Date 10/31/17 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 08 - Street Department Division 60 - Street Maintenance Program 2025
Deferred Comp. Contribution
4015
Electricity/Gas
20,000.00
.00
20,000.00
.00
.00
.00
20,000.00
0
21,869.39
290,000.00
.00
290,000.00
2,085.07
.00
49,602.77
240,397.23
17
257,109.86
5020 5040
Gas/Oil/Mileage/Carwash
70,000.00
.00
70,000.00
25,071.72
.00
14,317.79
55,682.21
20
53,294.62
Supplies/Hardware
15,000.00
.00
15,000.00
722.36
.00
4,219.63
10,780.37
28
5040.003
Supplies/Hardware-Salt Purchase
11,680.86
280,000.00
.00
280,000.00
.00
.00
.00
280,000.00
0
232,040.61
5055
Street Sign Maintenance
5060
Aggregate Materials
25,000.00
.00
25,000.00
2,301.75
4,931.45
12,012.46
8,056.09
68
29,485.95
4,000.00
.00
4,000.00
.00
.00
1,524.13
2,475.87
38
5095
Uniforms/Clothing
5,239.80
10,000.00
.00
10,000.00
415.34
.00
3,316.63
6,683.37
33
10,439.49
8003
Radio Maintenance
8060
Vehicle Maintenance
8130
Street Light Maintenance
8131
Street Maintenance
8132
5,000.00
.00
5,000.00
.00
.00
.00
5,000.00
0
1,692.10
35,000.00
.00
35,000.00
713.08
.00
4,532.91
30,467.09
13
25,636.77
95,000.00
.00
95,000.00
2,354.58
.00
37,421.86
57,578.14
39
113,358.45
130,000.00
.00
130,000.00
865.64
.00
13,056.83
116,943.17
10
115,168.49
Storm Sewer Improvements
10,000.00
.00
10,000.00
5,044.12
.00
10,478.18
(478.18)
105
1,490.85
8135
Contractual Services
90,000.00
.00
90,000.00
9,253.66
.00
56,277.56
33,722.44
63
108,462.32
8135.004
Snow Removal
280,000.00
.00
280,000.00
.00
.00
.00
280,000.00
0
169,521.13
8150
Sidewalk Maintenance
5,000.00
.00
5,000.00
.00
.00
.00
5,000.00
0
1,496.87
8160
Equipment Maintenance
95,000.00
.00
95,000.00
4,110.68
.00
26,427.71
68,572.29
28
77,487.55
$2,789,000.00
$0.00
$2,789,000.00
$151,944.27
$4,931.45
$937,130.34
$1,846,938.21
34%
$2,456,774.98
Division 60 - Street Maintenance Program Totals Division 62 - Forestry Program 1005
Salaries-Full Time
78,000.00
.00
78,000.00
5,645.54
.00
35,037.56
42,962.44
45
49,732.95
1800
Salaries-Overtime
6,000.00
.00
6,000.00
708.31
.00
5,434.83
565.17
91
6,677.22
2000
FICA
5,500.00
.00
5,500.00
380.33
.00
2,438.39
3,061.61
44
3,634.67
2001
Medicare
1,300.00
.00
1,300.00
88.96
.00
570.28
729.72
44
850.03
2010
IMRF
9,000.00
.00
9,000.00
704.64
.00
4,509.44
4,490.56
50
6,753.55
2020
Employee Insurance
17,000.00
.00
17,000.00
1,179.66
.00
7,429.90
9,570.10
44
11,056.90
2025
Deferred Comp. Contribution
3,000.00
.00
3,000.00
.00
.00
.00
3,000.00
0
1,817.40
5040
Supplies/Hardware
8,000.00
.00
8,000.00
10.99
.00
3,650.07
4,349.93
46
6,795.51
5095
Uniforms/Clothing
500.00
.00
500.00
.00
.00
.00
500.00
0
.00
8135
Contractual Services
5,000.00
.00
5,000.00
1,775.00
.00
7,090.00
(2,090.00)
142
3,911.55
8135.002
Tree Removal Division 62 - Forestry Program Totals
45,000.00
.00
45,000.00
9,100.00
.00
9,100.00
35,900.00
20
11,865.00
$178,300.00
$0.00
$178,300.00
$19,593.43
$0.00
$75,260.47
$103,039.53
42%
$103,094.78 186,524.95
Division 63 - Vehicle Maintenance Program 1005
Salaries-Full Time
193,000.00
.00
193,000.00
14,764.50
.00
95,684.00
97,316.00
50
1800
Salaries-Overtime
8,000.00
.00
8,000.00
2,084.23
.00
3,268.16
4,731.84
41
3,205.27
2000
FICA
12,500.00
.00
12,500.00
998.04
.00
5,840.63
6,659.37
47
11,275.14
2001
Medicare
3,000.00
.00
3,000.00
233.39
.00
1,365.92
1,634.08
46
2,636.92
2010
IMRF
22,000.00
.00
22,000.00
1,868.53
.00
10,973.76
11,026.24
50
21,386.55
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
Page 12 of 27
Budget Performance Report Fiscal Year to Date 10/31/17 Exclude Rollup Account
Account
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions
Rec'd
Prior Year Total
40,500.00
.00
40,500.00
3,039.00
.00
19,485.55
21,014.45
48
37,236.34
7,500.00
.00
7,500.00
.00
.00
.00
7,500.00
0
6,216.05
Division 63 - Vehicle Maintenance Program Totals
$286,500.00
$0.00
$286,500.00
$22,987.69
$0.00
$136,618.02
$149,881.98
48%
$268,481.22
Unit 08 - Street Department Totals
$3,733,900.00
$0.00
$3,733,900.00
$229,794.42
$4,931.45
$1,372,643.32
$2,356,325.23
37%
$3,271,155.94
Account Description
Budget - YTD % Used/
Fund 01 - General Fund EXPENSE Unit 08 - Street Department Division 63 - Vehicle Maintenance Program 2020
Employee Insurance
2025
Deferred Comp. Contribution
Unit 09 - Community Development Division 20 - Planning Program 1005
Salaries-Full Time
315,000.00
.00
315,000.00
26,159.48
.00
169,352.25
145,647.75
54
283,526.27
1045
Salaries-Commissioner
4,000.00
.00
4,000.00
285.00
.00
1,420.00
2,580.00
36
2,845.00
1800
Salaries-Overtime
2,500.00
.00
2,500.00
154.98
.00
1,407.99
1,092.01
56
2,460.20
2000
FICA
20,000.00
.00
20,000.00
1,601.90
.00
10,409.75
9,590.25
52
17,019.71
2001
Medicare
4,700.00
.00
4,700.00
374.62
.00
2,434.53
2,265.47
52
3,980.48
2010
IMRF
35,000.00
.00
35,000.00
2,918.27
.00
18,981.63
16,018.37
54
31,198.33
2020
Employee Insurance
70,500.00
.00
70,500.00
5,856.15
.00
37,735.76
32,764.24
54
51,716.24
2025
Deferred Comp. Contribution
12,000.00
.00
12,000.00
.00
.00
.00
12,000.00
0
3,400.00
3000
Travel/Training
7,000.00
.00
7,000.00
199.29
.00
2,103.34
4,896.66
30
2,567.00
3015
IL Unemployment Insurance
1,000.00
.00
1,000.00
176.05
.00
406.91
593.09
41
639.03
4000
Telephone/Internet
3,000.00
.00
3,000.00
167.52
.00
1,305.77
1,694.23
44
2,047.16
4005
Cellular Phones/Pagers
1,800.00
.00
1,800.00
72.98
.00
364.90
1,435.10
20
1,166.60
5005
Office Supplies/Postage
10,500.00
.00
10,500.00
1,001.24
.00
6,093.27
4,406.73
58
11,811.79
5015
Dues & Subscriptions
3,000.00
.00
3,000.00
.00
.00
1,979.00
1,021.00
66
3,393.54
5020
Gas/Oil/Mileage/Carwash
750.00
.00
750.00
47.60
.00
47.60
702.40
6
.00
8035
Maintenance Contracts/Lease
3,500.00
.00
3,500.00
.00
.00
250.00
3,250.00
7
600.00
8060
Vehicle Maintenance
1,500.00
.00
1,500.00
.00
.00
.00
1,500.00
0
.00
8065
Legal Fees
5,000.00
.00
5,000.00
236.18
.00
236.18
4,763.82
5
2,354.00
8097
Special Projects and Programs
15,000.00
.00
15,000.00
6,708.75
.00
14,343.75
656.25
96
3,709.27
8135
Contractual Services
35,000.00
.00
35,000.00
252.00
.00
1,919.00
33,081.00
5
1,691.84
8225
Engineering Fees
10,000.00
.00
10,000.00
850.00
.00
2,657.50
7,342.50
27
4,446.24
$560,750.00
$0.00
$560,750.00
$47,062.01
$0.00
$273,449.13
$287,300.87
49%
$430,572.70
Division 20 - Planning Program Totals Division 21 - Building Program 1005
Salaries-Full Time
633,000.00
.00
633,000.00
44,740.95
.00
290,242.23
342,757.77
46
431,841.31
1015
Salaries-Part Time
5,000.00
.00
5,000.00
.00
.00
.00
5,000.00
0
6,363.51
1800
Salaries-Overtime
5,000.00
.00
5,000.00
.00
.00
479.56
4,520.44
10
141.22
2000
FICA
39,800.00
.00
39,800.00
2,657.92
.00
17,375.09
22,424.91
44
26,488.50
2001
Medicare
2010
IMRF
2020
Employee Insurance
2025
Deferred Comp. Contribution
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
9,300.00
.00
9,300.00
621.60
.00
4,063.55
5,236.45
44
6,194.87
70,000.00
.00
70,000.00
4,972.87
.00
32,351.99
37,648.01
46
49,417.95
157,000.00
.00
157,000.00
11,893.97
.00
71,871.10
85,128.90
46
97,663.77
7,000.00
.00
7,000.00
.00
.00
.00
7,000.00
0
8,256.62
Page 13 of 27
Budget Performance Report Fiscal Year to Date 10/31/17 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 3000
Travel/Training
7,500.00
.00
7,500.00
2,433.88
.00
4,340.64
3,159.36
58
8,511.01
3015
IL Unemployment Insurance
1,500.00
.00
1,500.00
385.42
.00
795.90
704.10
53
1,000.00
4000
Telephone/Internet
1,500.00
.00
1,500.00
33.51
.00
318.90
1,181.10
21
409.44
4005
Cellular Phones/Pagers
6,000.00
.00
6,000.00
311.22
.00
1,556.13
4,443.87
26
3,500.04
5005
Office Supplies/Postage
13,000.00
.00
13,000.00
1,237.52
.00
3,130.02
9,869.98
24
7,111.69
5015
Dues & Subscriptions
4,000.00
.00
4,000.00
.00
.00
54.00
3,946.00
1
520.00
5020
Gas/Oil/Mileage/Carwash
1,000.00
.00
1,000.00
70.33
.00
275.18
724.82
28
32.00
5095
Uniforms/Clothing
900.00
.00
900.00
.00
.00
150.00
750.00
17
499.68
8045
Recording Fees
8135
Contractual Services
.00
.00
.00
339.75
.00
789.25
(789.25)
+++
.00
46,500.00
.00
46,500.00
.00
.00
1,045.50
45,454.50
2
7,589.70
Division 21 - Building Program Totals
$1,008,000.00
$0.00
$1,008,000.00
$69,698.94
$0.00
$428,839.04
$579,160.96
43%
$655,541.31
Unit 09 - Community Development Totals
$1,568,750.00
$0.00
$1,568,750.00
$116,760.95
$0.00
$702,288.17
$866,461.83
45%
$1,086,114.01
5,500.00
.00
5,500.00
189.73
.00
841.52
4,658.48
15
681.34
341.00
.00
341.00
11.77
.00
52.18
288.82
15
35.36
80.00
.00
80.00
2.75
.00
12.19
67.81
15
8.28
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
466.16
1,533.84
23
132.80
5015
Dues & Subscriptions
375.00
8065
Legal Fees
8115
Police Testing/Hiring
600.00
.00
600.00
.00
.00
.00
600.00
0
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00
0
.00
10,000.00
.00
10,000.00
.00
.00
.00
10,000.00
0
8,037.55
Division 02 - Administration Program Totals
$20,521.00
$0.00
$20,521.00
$204.25
$0.00
$1,372.05
$19,148.95
7%
$9,270.33
Unit 50 - Police Commission Totals
$20,521.00
$0.00
$20,521.00
$204.25
$0.00
$1,372.05
$19,148.95
7%
$9,270.33
EXPENSE TOTALS
$24,784,315.00
$0.00
$24,784,315.00
$2,041,247.44
$26,486.28
$11,541,301.89
$13,216,526.83
47%
$24,076,613.56
REVENUE TOTALS
24,784,315.00
.00
24,784,315.00
2,221,000.77
.00
16,449,981.62
8,334,333.38
66%
24,282,991.21
EXPENSE TOTALS
24,784,315.00
.00
24,784,315.00
2,041,247.44
26,486.28
11,541,301.89
13,216,526.83
47%
24,076,613.56
Fund 01 - General Fund Totals
$0.00
$0.00
$0.00
$179,753.33
($26,486.28)
$4,908,679.73
($4,882,193.45)
1,775,000.00
.00
1,775,000.00
148,548.33
.00
872,619.69
902,380.31
49
35,000.00
.00
35,000.00
1,760.00
.00
11,660.00
23,340.00
33
52,325.00
Fund 01 - General Fund Totals
$206,377.65
Fund 02 - Water and Sewer Fund REVENUE 0450.450
Home Rule Sales Tax
0570.850
Meter Sales
0570.851
Water Connection Fee
280,000.00
.00
280,000.00
29,807.75
.00
267,863.78
12,136.22
96
446,840.00
0570.852
Sewer Connection Fee
280,000.00
.00
280,000.00
35,343.00
.00
176,743.50
103,256.50
63
427,123.50
0570.859
Sewer By-Pass Fee
8,000.00
.00
8,000.00
3,010.00
.00
6,665.00
1,335.00
83
12,040.00
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
1,745,967.81
Page 14 of 27
Budget Performance Report Fiscal Year to Date 10/31/17 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
9,350,000.00
.00
9,350,000.00
978,369.79
.00
5,668,207.29
3,681,792.71
61
9,316,320.32
85,000.00
.00
85,000.00
10,384.90
.00
55,441.23
29,558.77
65
100,004.20
4,250,000.00
.00
4,250,000.00
431,270.28
.00
2,476,229.24
1,773,770.76
58
4,335,795.38
Fund 02 - Water and Sewer Fund REVENUE 0620.672
Water Sales
0620.673
Water Penalty
0620.674
Sewer Sales
0620.675
Sewer Penalty
45,000.00
.00
45,000.00
4,553.28
.00
24,777.39
20,222.61
55
47,432.36
0620.676
Capital Charge
1,130,000.00
.00
1,130,000.00
95,339.30
.00
666,807.46
463,192.54
59
1,204,238.08
0620.677
Capital Charge Penalty
15,000.00
.00
15,000.00
1,183.97
.00
6,958.19
8,041.81
46
15,006.20
0800.800
Interest Income
24,382.00
.00
24,382.00
5,527.12
.00
33,054.46
(8,672.46)
136
44,480.79
0800.827
Unrealized Gain/Loss
.00
.00
.00
291.56
.00
(1,698.82)
1,698.82
+++
(3,038.26)
0800.830
Unrealized Gain/Loss IMET
.00
.00
.00
(2,654.45)
.00
7,340.47
(7,340.47)
+++
6,309.48
0801.822
Donation/Contribution
.00
.00
.00
.00
.00
.00
.00
+++
389,353.00
0803.001
Sale of Scrap
500.00
.00
500.00
.00
.00
1,470.00
(970.00)
294
1,055.00
0805.000
Other Reimbursements
.00
.00
.00
.00
.00
4,620.90
(4,620.90)
+++
13,714.08
0806.000
Other Receipts REVENUE TOTALS
25,000.00
.00
25,000.00
2,990.00
.00
10,935.13
14,064.87
44
22,796.09
$17,302,882.00
$0.00
$17,302,882.00
$1,745,724.83
$0.00
$10,289,694.91
$7,013,187.09
59%
$18,177,763.03
245,000.00
.00
245,000.00
21,493.52
.00
138,457.42
106,542.58
57
236,158.35
15,200.00
.00
15,200.00
1,334.47
.00
8,587.46
6,612.54
56
14,288.25
3,600.00
.00
3,600.00
312.11
.00
2,008.54
1,591.46
56
3,456.90
56
27,342.55
EXPENSE Unit 10 - Water Department Division 02 - Administration Program 1005
Salaries-Full Time
2000
FICA
2001
Medicare
2010
IMRF
28,000.00
.00
28,000.00
2,446.36
.00
15,732.88
12,267.12
2020
Employee Insurance
46,000.00
.00
46,000.00
3,673.60
.00
23,318.63
22,681.37
51
36,257.21
2020.001
Contra Insurance Account
.00
.00
.00
.00
.00
.00
.00
+++
(31,480.53)
2025
Deferred Comp. Contribution
10,000.00
.00
10,000.00
.00
.00
.00
10,000.00
0
8,028.22
3000
Travel/Training
7,000.00
.00
7,000.00
86.19
.00
1,903.53
5,096.47
27
2,707.65
3015
IL Unemployment Insurance
2,500.00
.00
2,500.00
1,569.54
.00
3,121.88
(621.88)
125
1,705.58
4000
Telephone/Internet
5,600.00
.00
5,600.00
450.26
.00
3,300.18
2,299.82
59
4,665.28
4005
Cellular Phones/Pagers
3,000.00
.00
3,000.00
365.58
.00
1,687.14
1,312.86
56
4,152.66
5005
Office Supplies/Postage
26,000.00
.00
26,000.00
2,331.89
.00
14,075.43
11,924.57
54
33,547.92
5015
Dues & Subscriptions
1,400.00
.00
1,400.00
.00
.00
372.40
1,027.60
27
1,457.61
5020
Gas/Oil/Mileage/Carwash
500.00
.00
500.00
.00
.00
.00
500.00
0
521.81
5040
Supplies/Hardware
500.00
.00
500.00
.00
.00
222.54
277.46
45
525.44
5065
Software
2,000.00
.00
2,000.00
.00
.00
.00
2,000.00
0
1,893.15
5075
Sand & Gravel
5080
Water Meters
8020
Building Maintenance
8050
Legal Notices
8065
Legal Fees
8135
Contractual Services
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
800.00
.00
800.00
.00
.00
72.50
727.50
9
1,384.07
150,000.00
.00
150,000.00
3,255.35
.00
25,842.25
124,157.75
17
131,727.54
8,000.00
.00
8,000.00
1,601.14
.00
6,701.06
1,298.94
84
4,921.44
500.00
.00
500.00
.00
.00
.00
500.00
0
.00
1,000.00
.00
1,000.00
.00
.00
76.00
924.00
8
292.00
27,000.00
.00
27,000.00
1,261.97
.00
10,463.76
16,536.24
39
42,194.59
Page 15 of 27
Budget Performance Report Fiscal Year to Date 10/31/17 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
125.55
Fund 02 - Water and Sewer Fund EXPENSE Unit 10 - Water Department Division 02 - Administration Program 8160
Equipment Maintenance
8225
Engineering Fees
500.00
.00
500.00
.00
.00
132.79
367.21
27
4,000.00
.00
4,000.00
.00
.00
1,248.52
2,751.48
31
9330
Change in IMRF Net Pension Liability GASB 68
.00
.00
.00
.00
.00
.00
.00
.00
+++
16,126.00
9401 9905
Administrative Service Charge
125,000.00
.00
125,000.00
.00
.00
.00
125,000.00
0
125,000.00
Transfer to Debt Service
244,825.00
.00
244,825.00
.00
.00
122,412.50
122,412.50
50
9997
Bad Debt Expense
242,725.00
.00
.00
.00
.00
.00
.00
.00
+++
3,424.31
$957,925.00
$0.00
$957,925.00
$40,181.98
$0.00
$379,737.41
$578,187.59
40%
$913,148.55
Division 02 - Administration Program Totals Division 30 - Water Distribution Program 1005
Salaries-Full Time
410,000.00
.00
410,000.00
24,494.25
.00
158,866.87
251,133.13
39
403,796.20
1015
Salaries-Part Time
14,000.00
.00
14,000.00
.00
.00
8,759.58
5,240.42
63
15,649.72
1800
Salaries-Overtime
35,000.00
.00
35,000.00
3,361.14
.00
15,423.22
19,576.78
44
31,515.55
2000
FICA
29,000.00
.00
29,000.00
1,661.83
.00
10,989.84
18,010.16
38
26,731.62
2001
Medicare
6,800.00
.00
6,800.00
388.64
.00
2,570.15
4,229.85
38
6,299.58
2010
IMRF
53,000.00
.00
53,000.00
3,043.12
.00
19,106.24
33,893.76
36
47,881.94
2020
Employee Insurance
70,975.00
.00
70,975.00
4,638.89
.00
28,251.02
42,723.98
40
63,113.21
2025
Deferred Comp. Contribution
15,000.00
.00
15,000.00
.00
.00
.00
15,000.00
0
15,502.28
4000
Telephone/Internet
9,000.00
.00
9,000.00
723.64
.00
5,331.16
3,668.84
59
7,888.21
4005
Cellular Phones/Pagers
500.00
.00
500.00
.00
.00
.00
500.00
0
151.75
4015
Electricity/Gas
140,000.00
.00
140,000.00
235.21
.00
6,544.97
133,455.03
5
123,565.62
5005
Office Supplies/Postage
2,000.00
.00
2,000.00
25.67
.00
140.33
1,859.67
7
199.91
5010
Replacement Supplies
5,000.00
.00
5,000.00
.00
.00
1,600.00
3,400.00
32
7,017.40
5020
Gas/Oil/Mileage/Carwash
15,000.00
.00
15,000.00
488.89
.00
5,086.83
9,913.17
34
8,602.27
5040
Supplies/Hardware
4,000.00
.00
4,000.00
512.85
.00
3,636.93
363.07
91
5,485.05
5070
Chemicals
5,500.00
.00
5,500.00
1,215.00
.00
2,430.00
3,070.00
44
5,379.54
5095
Uniforms/Clothing
2,000.00
.00
2,000.00
102.17
.00
542.35
1,457.65
27
5,327.56
8020
Building Maintenance
4,000.00
.00
4,000.00
33.49
.00
331.57
3,668.43
8
2,772.26
8060
Vehicle Maintenance
6,500.00
.00
6,500.00
(54.48)
.00
2,388.06
4,111.94
37
6,089.99
8135
Contractual Services
40,000.00
.00
40,000.00
7,665.66
7,071.90
12,197.24
20,730.86
48
53,499.34
8135.003
Lake Michigan Water Purchase
8,403,000.00
.00
8,403,000.00
1,748,746.11
.00
4,345,015.82
4,057,984.18
52
8,471,988.46
8160
Equipment Maintenance
9,000.00
.00
9,000.00
499.95
.00
537.05
8,462.95
6
12,096.38
8185
System Maintenance
44,000.00
.00
44,000.00
.00
.00
605.91
43,394.09
1
49,419.05
8194
Water/Fire Hydrant
20,000.00
.00
20,000.00
5,189.27
.00
5,189.27
14,810.73
26
19,074.73
8200
EPA Analytical
16,000.00
.00
16,000.00
80.00
.00
9,761.37
6,238.63
61
11,034.66
9305
Capitalized Assets-Cap Outlay
.00
.00
.00
.00
.00
.00
.00
+++
(1,347,739.16)
9905
Transfer to Debt Service Division 30 - Water Distribution Program Totals
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
244,825.00
.00
244,825.00
.00
.00
122,412.50
122,412.50
50
242,725.00
$9,604,100.00
$0.00
$9,604,100.00
$1,803,051.30
$7,071.90
$4,767,718.28
$4,829,309.82
50%
$8,295,068.12
Page 16 of 27
Budget Performance Report Fiscal Year to Date 10/31/17 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,110,638.97
Fund 02 - Water and Sewer Fund EXPENSE Unit 10 - Water Department Division 93 - Contingencies 9303
Depreciation
.00
.00
.00
.00
.00
.00
.00
+++
9307
Amortization Expense
.00
.00
.00
.00
.00
.00
.00
+++
39,236.31
Division 93 - Contingencies Totals
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+++
$3,149,875.28
Unit 10 - Water Department Totals
$10,562,025.00
$0.00
$10,562,025.00
$1,843,233.28
$7,071.90
$5,147,455.69
$5,407,497.41
49%
$12,358,091.95
245,000.00
.00
245,000.00
18,335.06
.00
119,386.96
125,613.04
49
235,196.83
15,200.00
.00
15,200.00
1,130.34
.00
7,410.32
7,789.68
49
14,291.42
3,600.00
.00
3,600.00
264.33
.00
1,732.92
1,867.08
48
3,456.80
Unit 11 - Sewer Department Division 02 - Administration Program 1005
Salaries-Full Time
2000
FICA
2001
Medicare
2010
IMRF
28,000.00
.00
28,000.00
2,072.05
.00
13,574.14
14,425.86
48
27,356.16
2020
Employee Insurance
46,000.00
.00
46,000.00
2,910.98
.00
18,734.17
27,265.83
41
35,824.58
2025
Deferred Comp. Contribution
10,000.00
.00
10,000.00
.00
.00
.00
10,000.00
0
7,723.21
3000
Travel/Training
12,000.00
.00
12,000.00
724.09
.00
2,947.62
9,052.38
25
5,191.84
3015
IL Unemployment Insurance
2,500.00
.00
2,500.00
256.00
.00
522.92
1,977.08
21
1,705.54
4000
Telephone/Internet
9,000.00
.00
9,000.00
723.64
.00
6,669.43
2,330.57
74
11,908.89
4005
Cellular Phones/Pagers
3,500.00
.00
3,500.00
227.71
.00
1,117.87
2,382.13
32
2,973.50
5005
Office Supplies/Postage
25,000.00
.00
25,000.00
2,331.39
.00
13,430.05
11,569.95
54
31,332.15
5015
Dues & Subscriptions
68,200.00
.00
68,200.00
27,012.58
.00
62,180.98
6,019.02
91
60,535.73
5020
Gas/Oil/Mileage/Carwash
1,000.00
.00
1,000.00
30.00
.00
30.00
970.00
3
299.18
5040
Supplies/Hardware
2,500.00
.00
2,500.00
.00
.00
82.63
2,417.37
3
510.72
8020
Building Maintenance
15,000.00
.00
15,000.00
1,672.27
.00
8,533.92
6,466.08
57
17,449.12
8065
Legal Fees
8135
Contractual Services
8160
Equipment Maintenance
8225
Engineering Fees
9200.012 9200.013 9200.018
1,500.00
.00
1,500.00
.00
.00
76.00
1,424.00
5
172.00
30,000.00
.00
30,000.00
1,262.21
.00
8,209.27
21,790.73
27
39,619.85
2,000.00
.00
2,000.00
272.85
.00
591.99
1,408.01
30
.00
10,000.00
.00
10,000.00
.00
.00
564.08
9,435.92
6
10,186.12
2013 Refunding-2004A Bond (Principal)
39,840.00
.00
39,840.00
.00
.00
.00
39,840.00
0
340,500.00
2013 Refunding-2004A Bond (Interest)
384,000.00
.00
384,000.00
.00
.00
19,920.00
364,080.00
5
46,650.00
2005B Bond (Principal)
.00
.00
.00
.00
.00
.00
.00
+++
30,000.00
9200.019
2005B Bond (Interest)
.00
.00
.00
.00
.00
.00
.00
+++
1,162.00
9299
Contra Debt Expense
.00
.00
.00
.00
.00
.00
.00
+++
(30,000.00)
9330
Change in IMRF Net Pension Liability GASB 68
.00
.00
.00
.00
.00
.00
.00
+++
16,126.00
9401
Administrative Service Charge
125,000.00
.00
125,000.00
.00
.00
.00
125,000.00
0
125,000.00
9905
Transfer to Debt Service
244,825.00
.00
244,825.00
.00
.00
122,412.50
122,412.50
50
242,725.00
9997
Bad Debt Expense
.00
.00
.00
.00
.00
.00
.00
+++
2,320.70
$1,323,665.00
$0.00
$1,323,665.00
$59,225.50
$0.00
$408,127.77
$915,537.23
31%
$1,280,217.34
385,000.00
.00
385,000.00
28,071.29
.00
187,397.78
197,602.22
49
410,779.62
Division 02 - Administration Program Totals Division 40 - Sewer Treatment Program 1005
Salaries-Full Time
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
Page 17 of 27
Budget Performance Report Fiscal Year to Date 10/31/17 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 02 - Water and Sewer Fund EXPENSE Unit 11 - Sewer Department Division 40 - Sewer Treatment Program 1015
Salaries-Part Time
10,000.00
.00
10,000.00
.00
.00
8,759.56
1,240.44
88
15,649.65
1800
Salaries-Overtime
30,000.00
.00
30,000.00
1,288.90
.00
12,028.04
17,971.96
40
26,852.08
2000
FICA
26,500.00
.00
26,500.00
1,760.74
.00
12,503.76
13,996.24
47
27,242.55
2001
Medicare
6,500.00
.00
6,500.00
411.82
.00
2,924.24
3,575.76
45
6,414.31
2010
IMRF
46,000.00
.00
46,000.00
3,222.84
.00
21,870.71
24,129.29
48
48,877.78
2020
Employee Insurance
56,000.00
.00
56,000.00
4,053.62
.00
26,260.48
29,739.52
47
60,441.24
2025
Deferred Comp. Contribution
13,500.00
.00
13,500.00
.00
.00
.00
13,500.00
0
13,026.76
4000
Telephone/Internet
22,000.00
.00
22,000.00
1,768.88
.00
13,265.38
8,734.62
60
19,797.10
4015
Electricity/Gas
525,000.00
.00
525,000.00
306.22
.00
114,767.01
410,232.99
22
519,785.43
5005
Office Supplies/Postage
4,500.00
.00
4,500.00
25.66
.00
238.13
4,261.87
5
841.27
5010
Replacement Supplies
1,500.00
.00
1,500.00
227.28
.00
1,462.94
37.06
98
2,084.97
5020
Gas/Oil/Mileage/Carwash
13,000.00
.00
13,000.00
426.90
.00
3,913.44
9,086.56
30
8,249.45
5040
Supplies/Hardware
10,000.00
.00
10,000.00
1,117.92
.00
4,673.01
5,326.99
47
10,856.84
5070
Chemicals
115,000.00
.00
115,000.00
8,505.31
.00
37,782.55
77,217.45
33
112,021.46
5075
Sand & Gravel
500.00
.00
500.00
.00
.00
.00
500.00
0
253.33
5085
Industrial Flow Monitor
18,000.00
.00
18,000.00
256.50
.00
1,188.00
16,812.00
7
1,971.00
5095
Uniforms/Clothing
5,000.00
.00
5,000.00
415.37
.00
2,220.70
2,779.30
44
8,908.79
8060
Vehicle Maintenance
8,000.00
.00
8,000.00
810.82
.00
7,281.52
718.48
91
3,473.22
8135
Contractual Services
160,000.00
.00
160,000.00
1,799.76
.00
57,341.47
102,658.53
36
214,685.35
8160
Equipment Maintenance
20,000.00
.00
20,000.00
3,688.34
.00
8,708.58
11,291.42
44
22,091.88
8160.002
Maintenance-James Street
5,000.00
.00
5,000.00
.00
.00
.00
5,000.00
0
5,600.93
8185
System Maintenance
125,000.00
.00
125,000.00
859.58
2,982.65
13,375.04
108,642.31
13
55,506.10
9905
Transfer to Debt Service
244,825.00
.00
244,825.00
.00
.00
122,412.50
122,412.50
50
242,725.00
Division 40 - Sewer Treatment Program Totals
$1,850,825.00
$0.00
$1,850,825.00
$59,017.75
$2,982.65
$660,374.84
$1,187,467.51
36%
$1,838,136.11
Unit 11 - Sewer Department Totals
$3,174,490.00
$0.00
$3,174,490.00
$118,243.25
$2,982.65
$1,068,502.61
$2,103,004.74
34%
$3,118,353.45
Unit 12 - Utility Expansion Division 91 - Capital 8133.002
Scada Improvements
20,000.00
.00
20,000.00
.00
.00
.00
20,000.00
0
2,158.00
8133.003
Route 30 Water main
.00
.00
.00
.00
.00
.00
.00
+++
269,614.46
8133.004
Rt 30 Water main-Kuusakoski to Tower 2
100,000.00
.00
100,000.00
.00
.00
87,610.85
12,389.15
88
840,469.88
8134.001
Lift Station Improvements
170,000.00
.00
170,000.00
.00
.00
.00
170,000.00
0
181,130.00
8134.002
Pump Station Improvements
.00
.00
.00
199,890.00
.00
200,712.50
(200,712.50)
+++
56,524.82
8135
Contractual Services
210,000.00
.00
210,000.00
.00
.00
.00
210,000.00
0
.00
8225
Engineering Fees
150,000.00
.00
150,000.00
3,985.95
.00
29,931.48
120,068.52
20
40,152.25
9120
Machinery and Equipment
12,894.14
9125
Vehicles Division 91 - Capital Totals
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
.00
.00
.00
.00
.00
5,996.80
(5,996.80)
+++
180,000.00
.00
180,000.00
39,490.00
.00
39,490.00
140,510.00
22
.00
$830,000.00
$0.00
$830,000.00
$243,365.95
$0.00
$363,741.63
$466,258.37
44%
$1,402,943.55
Page 18 of 27
Budget Performance Report Fiscal Year to Date 10/31/17 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 02 - Water and Sewer Fund EXPENSE Unit 12 - Utility Expansion Division 92 - Bonds 9200.012
2013 Refunding-2004A Bond (Principal)
896,000.00
.00
896,000.00
.00
.00
.00
896,000.00
0
794,500.00
9200.013
2013 Refunding-2004A Bond (Interest)
92,960.00
.00
92,960.00
.00
.00
46,480.00
46,480.00
50
100,337.50
9200.014
2013 Refunding-2004B Bond (Principal)
375,000.00
.00
375,000.00
.00
.00
.00
375,000.00
0
365,000.00
9200.015
2013 Refunding-2004B Bond (Interest)
38,650.00
.00
38,650.00
.00
.00
19,325.00
19,325.00
50
43,212.50
9200.018
2005B Bond (Principal)
.00
.00
.00
.00
.00
.00
.00
+++
70,000.00
9200.019
2005B Bond (Interest)
.00
.00
.00
.00
.00
.00
.00
+++
1,259.87
9200.022
2008 Bond (Principal)
500,000.00
.00
500,000.00
.00
.00
.00
500,000.00
0
450,000.00
9200.023
2008 Bond (Interest)
25,000.00
.00
25,000.00
12,500.00
.00
12,500.00
12,500.00
50
47,862.49
9200.032
2015 Refunding-2008 Bond (Principal)
90,000.00
.00
90,000.00
.00
.00
.00
90,000.00
0
90,000.00
9200.033
2015 Refunding-2008 Bond (Interest)
529,750.00
.00
529,750.00
264,875.00
.00
264,875.00
264,875.00
50
531,550.00
9201.001
IEPA Loan (Principal)
158,419.00
.00
158,419.00
.00
.00
78,464.53
79,954.47
50
155,470.01
9201.002
IEPA Loan (Interest)
30,588.00
.00
30,588.00
.00
.00
15,539.02
15,048.98
51
31,808.32
9299
Contra Debt Expense
.00
.00
.00
.00
.00
.00
.00
+++
(2,265,470.01)
Division 92 - Bonds Totals
$2,736,367.00
$0.00
$2,736,367.00
$277,375.00
$0.00
$437,183.55
$2,299,183.45
16%
$415,530.68
Unit 12 - Utility Expansion Totals
$3,566,367.00
$0.00
$3,566,367.00
$520,740.95
$0.00
$800,925.18
$2,765,441.82
22%
$1,818,474.23
EXPENSE TOTALS
$17,302,882.00
$0.00
$17,302,882.00
$2,482,217.48
$10,054.55
$7,016,883.48
$10,275,943.97
41%
$17,294,919.63
REVENUE TOTALS
17,302,882.00
.00
17,302,882.00
1,745,724.83
.00
10,289,694.91
7,013,187.09
59%
18,177,763.03
EXPENSE TOTALS
17,302,882.00
.00
17,302,882.00
2,482,217.48
10,054.55
7,016,883.48
10,275,943.97
41%
17,294,919.63
Fund 02 - Water and Sewer Fund Totals
$0.00
$0.00
$0.00
($736,492.65)
($10,054.55)
$3,272,811.43
($3,262,756.88)
Fund 02 - Water and Sewer Fund Totals
$882,843.40
Fund 03 - Capital Replacement Fund REVENUE 0800.800
Interest Income
.00
.00
.00
2,242.61
.00
13,235.50
(13,235.50)
+++
0800.826
Realized Gain/Loss On Investment
.00
.00
.00
.00
.00
.00
.00
+++
12.64
0800.827
Unrealized Gain/Loss
.00
.00
.00
92.37
.00
(611.99)
611.99
+++
(9,699.66)
$0.00
$0.00
$0.00
$2,334.98
$0.00
$12,623.51
($12,623.51)
+++
$14,602.22
REVENUE TOTALS
.00
.00
.00
2,334.98
.00
12,623.51
(12,623.51)
+++
14,602.22
EXPENSE TOTALS
.00
.00
.00
.00
.00
.00
.00
+++
Fund 03 - Capital Replacement Fund Totals
$0.00
$0.00
$0.00
$2,334.98
$0.00
$12,623.51
($12,623.51)
1,150,000.00
.00
1,150,000.00
126,497.47
.00
548,711.49
601,288.51
48
5,000.00
.00
5,000.00
3,357.53
.00
16,802.51
(11,802.51)
336
15,410.91
$1,155,000.00
$0.00
$1,155,000.00
$129,855.00
$0.00
$565,514.00
$589,486.00
49%
$1,121,004.42
REVENUE TOTALS
24,289.24
Fund 03 - Capital Replacement Fund Totals .00 $14,602.22
Fund 04 - Motor Fuel Tax REVENUE 0450.457
MFT Entitlements
0800.800
Interest Income REVENUE TOTALS
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
1,105,593.51
Page 19 of 27
Budget Performance Report Fiscal Year to Date 10/31/17 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 04 - Motor Fuel Tax EXPENSE Unit 00 - Non-Departmental Division 91 - Capital 9150
Street Improvements
1,005,000.00
.00
1,005,000.00
3,317.30
.00
(72,219.93)
1,077,219.93
-7
863,120.29
Division 91 - Capital Totals
$1,005,000.00
$0.00
$1,005,000.00
$3,317.30
$0.00
($72,219.93)
$1,077,219.93
-7%
$863,120.29
150,000.00
.00
150,000.00
.00
.00
.00
150,000.00
0
.00
Division 99 - Transfers Totals
$150,000.00
$0.00
$150,000.00
$0.00
$0.00
$0.00
$150,000.00
0%
$0.00
Unit 00 - Non-Departmental Totals
$1,155,000.00
$0.00
$1,155,000.00
$3,317.30
$0.00
($72,219.93)
$1,227,219.93
-6%
$863,120.29
EXPENSE TOTALS
$1,155,000.00
$0.00
$1,155,000.00
$3,317.30
$0.00
($72,219.93)
$1,227,219.93
-6%
$863,120.29
REVENUE TOTALS
1,155,000.00
.00
1,155,000.00
129,855.00
.00
565,514.00
589,486.00
49%
1,121,004.42
EXPENSE TOTALS
1,155,000.00
.00
1,155,000.00
3,317.30
.00
(72,219.93)
1,227,219.93
-6%
Fund 04 - Motor Fuel Tax Totals
$0.00
$0.00
$0.00
$126,537.70
$0.00
$637,733.93
($637,733.93)
112,600.00
.00
112,600.00
10,978.12
.00
116,486.16
(3,886.16)
103
500.00
.00
500.00
1,275.40
.00
4,898.31
(4,398.31)
980
797.83
979,300.00
.00
979,300.00
.00
.00
489,650.00
489,650.00
50
970,900.00
Division 99 - Transfers 9901
Transfer to General
Fund 04 - Motor Fuel Tax Totals 863,120.29 $257,884.13
Fund 05 - Bond and Interest Fund REVENUE 0400.401
Property Tax Revenue
0800.800
Interest Income
0999.902
Transfer From Water and Sewer
0999.911
Transfer From Capital REVENUE TOTALS
117,213.82
2,036,125.00
.00
2,036,125.00
.00
.00
1,018,062.50
1,018,062.50
50
2,032,264.47
$3,128,525.00
$0.00
$3,128,525.00
$12,253.52
$0.00
$1,629,096.97
$1,499,428.03
52%
$3,121,176.12
725,000.00
EXPENSE Unit 00 - Non-Departmental Division 92 - Bonds 9200.020
2007 Bond (Principal)
755,000.00
.00
755,000.00
.00
.00
.00
755,000.00
0
9200.021
2007 Bond (Interest)
42,475.00
.00
42,475.00
.00
.00
21,237.50
21,237.50
50
75,100.00
9200.024
2009 Refunding Bond (Principal)
100,000.00
.00
100,000.00
.00
.00
.00
100,000.00
0
100,000.00
9200.025
2009 Refunding Bond (Interest)
12,600.00
.00
12,600.00
.00
.00
6,300.00
6,300.00
50
16,100.00
9200.026
2010 Bond (Principal)
750,000.00
.00
750,000.00
.00
.00
.00
750,000.00
0
720,000.00
9200.027
2010 Bond (Interest)
229,300.00
.00
229,300.00
.00
.00
114,650.00
114,650.00
50
250,900.00
9200.028
2012 Refunding Bond (Principal)
660,000.00
.00
660,000.00
.00
.00
.00
660,000.00
0
645,000.00
9200.029
2012 Refunding Bond (Interest)
175,200.00
.00
175,200.00
.00
.00
87,600.00
87,600.00
50
188,100.00
9200.030
2014 Refunding- 2007 Bond (Principal)
130,000.00
.00
130,000.00
.00
.00
.00
130,000.00
0
125,000.00
9200.031
2014 Refunding- 2007 Bond (Interest)
273,450.00
.00
273,450.00
.00
.00
136,725.00
136,725.00
50
275,950.00
Division 92 - Bonds Totals
$3,128,025.00
$0.00
$3,128,025.00
$0.00
$0.00
$366,512.50
$2,761,512.50
12%
$3,121,150.00
Unit 00 - Non-Departmental Totals
$3,128,025.00
$0.00
$3,128,025.00
$0.00
$0.00
$366,512.50
$2,761,512.50
12%
$3,121,150.00
EXPENSE TOTALS
$3,128,025.00
$0.00
$3,128,025.00
$0.00
$0.00
$366,512.50
$2,761,512.50
12%
$3,121,150.00
Fund 05 - Bond and Interest Fund Totals
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
Page 20 of 27
Budget Performance Report Fiscal Year to Date 10/31/17 Exclude Rollup Account
Account
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions
Rec'd
Prior Year Total
REVENUE TOTALS
3,128,525.00
.00
3,128,525.00
12,253.52
.00
1,629,096.97
1,499,428.03
52%
3,121,176.12
EXPENSE TOTALS
3,128,025.00
.00
3,128,025.00
.00
.00
366,512.50
2,761,512.50
12%
3,121,150.00
Fund 05 - Bond and Interest Fund Totals
$500.00
$0.00
$500.00
$12,253.52
$0.00
$1,262,584.47
($1,262,084.47)
625,000.00
.00
625,000.00
57,698.98
.00
612,430.46
12,569.54
98
621,534.63
100.00
.00
100.00
275.77
.00
422.60
(322.60)
423
164.54
.00
.00
.00
.00
.00
.00
.00
+++
55.00
$625,100.00
$0.00
$625,100.00
$57,974.75
$0.00
$612,853.06
$12,246.94
98%
$621,754.17
500.00
.00
500.00
.00
.00
336.00
164.00
67
336.00
280,000.00
.00
280,000.00
500.00
.00
156,425.00
123,575.00
56
268,633.00
Account Description
Budget - YTD % Used/
$26.12
Fund 07 - Tort Immunity Fund REVENUE 0400.401
Property Tax Revenue
0800.800
Interest Income
0805.000
Other Reimbursements REVENUE TOTALS
EXPENSE Unit 00 - Non-Departmental Division 00 - Non-Divisional 8275
Bond-Treasurer
8300
Commercial Umbrella Liability
8310
Workman's Compensation Ins.
344,600.00
.00
344,600.00
.00
.00
221,340.00
123,260.00
64
325,852.00
Division 00 - Non-Divisional Totals
$625,100.00
$0.00
$625,100.00
$500.00
$0.00
$378,101.00
$246,999.00
60%
$594,821.00
Unit 00 - Non-Departmental Totals
$625,100.00
$0.00
$625,100.00
$500.00
$0.00
$378,101.00
$246,999.00
60%
$594,821.00
EXPENSE TOTALS
$625,100.00
$0.00
$625,100.00
$500.00
$0.00
$378,101.00
$246,999.00
60%
$594,821.00
REVENUE TOTALS
625,100.00
.00
625,100.00
57,974.75
.00
612,853.06
12,246.94
98%
621,754.17
EXPENSE TOTALS
625,100.00
.00
625,100.00
500.00
.00
378,101.00
246,999.00
60%
594,821.00
Fund 07 - Tort Immunity Fund Totals
$0.00
$0.00
$0.00
$57,474.75
$0.00
$234,752.06
($234,752.06)
42,000.00
.00
42,000.00
3,914.68
.00
41,548.90
451.10
99
50.00
.00
50.00
23.44
.00
118.44
(68.44)
237
72.05
REVENUE TOTALS
$42,050.00
$0.00
$42,050.00
$3,938.12
$0.00
$41,667.34
$382.66
99%
$42,323.83
42,000.00
.00
42,000.00
24,100.00
.00
29,425.00
12,575.00
70
39,142.00
Division 00 - Non-Divisional Totals
$42,000.00
$0.00
$42,000.00
$24,100.00
$0.00
$29,425.00
$12,575.00
70%
$39,142.00
Unit 00 - Non-Departmental Totals
$42,000.00
$0.00
$42,000.00
$24,100.00
$0.00
$29,425.00
$12,575.00
70%
$39,142.00
EXPENSE TOTALS
$42,000.00
$0.00
$42,000.00
$24,100.00
$0.00
$29,425.00
$12,575.00
70%
$39,142.00
REVENUE TOTALS
42,050.00
.00
42,050.00
3,938.12
.00
41,667.34
382.66
99%
42,323.83
EXPENSE TOTALS
42,000.00
.00
42,000.00
24,100.00
.00
29,425.00
12,575.00
70%
39,142.00
Fund 08 - Audit Fund Totals
$50.00
$0.00
$50.00
($20,161.88)
$0.00
$12,242.34
($12,192.34)
Fund 07 - Tort Immunity Fund Totals
$26,933.17
Fund 08 - Audit Fund REVENUE 0400.401
Property Tax Revenue
0800.800
Interest Income
42,251.78
EXPENSE Unit 00 - Non-Departmental Division 00 - Non-Divisional 8315
Audit Village
Fund 08 - Audit Fund Totals
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
$3,181.83
Page 21 of 27
Budget Performance Report Fiscal Year to Date 10/31/17 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 10 - Police Pension Fund REVENUE 0800.800
Interest Income
500,000.00
.00
500,000.00
74.28
.00
201,065.94
298,934.06
40
784,139.57
0800.824
Realized Gain/Loss-SawyerFalduto
.00
.00
.00
.00
.00
(4,895.19)
4,895.19
+++
(66,865.73)
0800.826
Realized Gain/Loss On Investment
175,000.00
.00
175,000.00
.00
.00
.00
175,000.00
0
.00
0800.827
Unrealized Gain/Loss
300,000.00
.00
300,000.00
.00
.00
.00
300,000.00
0
.00
0800.829
Unrealized Gain/Loss Sawyer/Fald
.00
.00
.00
.00
.00
1,140,174.11
(1,140,174.11)
+++
1,646,913.00
0818.000
Employee Contributions
575,000.00
.00
575,000.00
.00
.00
221,213.77
353,786.23
38
509,526.26
0819.000
Employer Contributions
1,370,000.00
.00
1,370,000.00
126,352.87
.00
1,341,083.21
28,916.79
98
1,101,142.15
$2,920,000.00
$0.00
$2,920,000.00
$126,427.15
$0.00
$2,898,641.84
$21,358.16
99%
$3,974,855.25
5,000.00
.00
5,000.00
1,672.97
.00
1,672.97
3,327.03
33
4,169.95
500.00
.00
500.00
.00
.00
.00
500.00
0
.00
REVENUE TOTALS EXPENSE Unit 00 - Non-Departmental Division 00 - Non-Divisional 3000
Travel/Training
5005
Office Supplies/Postage
5015
Dues & Subscriptions
5,500.00
.00
5,500.00
.00
.00
4,945.25
554.75
90
5,560.27
8135
Contractual Services
30,000.00
.00
30,000.00
.00
.00
16,215.78
13,784.22
54
32,081.70
8137
Investment Expense
85,000.00
.00
85,000.00
.00
.00
23,726.00
61,274.00
28
87,300.00
8330
Pension Payments
485,000.00
.00
485,000.00
40,893.17
.00
245,359.02
239,640.98
51
442,742.40
Division 00 - Non-Divisional Totals
$611,000.00
$0.00
$611,000.00
$42,566.14
$0.00
$291,919.02
$319,080.98
48%
$571,854.32
Unit 00 - Non-Departmental Totals
$611,000.00
$0.00
$611,000.00
$42,566.14
$0.00
$291,919.02
$319,080.98
48%
$571,854.32
EXPENSE TOTALS
$611,000.00
$0.00
$611,000.00
$42,566.14
$0.00
$291,919.02
$319,080.98
48%
$571,854.32
REVENUE TOTALS
2,920,000.00
.00
2,920,000.00
126,427.15
.00
2,898,641.84
21,358.16
99%
3,974,855.25
EXPENSE TOTALS
611,000.00
.00
611,000.00
42,566.14
.00
291,919.02
319,080.98
48%
Fund 10 - Police Pension Fund Totals
$2,309,000.00
$0.00
$2,309,000.00
$83,861.01
$0.00
$2,606,722.82
($297,722.82)
Fund 10 - Police Pension Fund Totals 571,854.32 $3,403,000.93
Fund 11 - Capital Improvement Fund REVENUE 0450.450
Home Rule Sales Tax
2,900,000.00
.00
2,900,000.00
230,287.79
.00
1,352,783.08
1,547,216.92
47
3,492,459.42
0500.502
Utility Tax
2,800,000.00
.00
2,800,000.00
187,675.59
.00
1,331,635.77
1,468,364.23
48
2,915,444.66
0570.856
Bike Path Fee
500.00
.00
500.00
.00
.00
.00
500.00
0
.00
0570.876
Recapture Fee
5,000.00
.00
5,000.00
932.52
.00
1,865.04
3,134.96
37
10,030.89
0650.670
Impound Fee
30,000.00
.00
30,000.00
2,250.00
.00
13,000.00
17,000.00
43
22,852.50
0650.673
Daily Storage Fee for Impound
5,000.00
.00
5,000.00
.00
.00
860.00
4,140.00
17
1,475.00
0650.675
Red Light Fines
255,000.00
.00
255,000.00
38,700.00
.00
213,400.00
41,600.00
84
348,306.07
0700.100
STP Grant(143rd St)
1,233,739.00
.00
1,233,739.00
.00
.00
.00
1,233,739.00
0
593,863.73
0700.650
Grant Revenue
500,000.00
.00
500,000.00
.00
.00
.00
500,000.00
0
49,471.07
0800.800
Interest Income
31,886.00
.00
31,886.00
11,124.07
.00
56,205.41
(24,319.41)
176
39,065.34
0803.000
Sales-Fixed Assets
5,000.00
.00
5,000.00
.00
.00
.00
5,000.00
0
.00
0805.000
Other Reimbursements
5,800,000.00
.00
5,800,000.00
.00
.00
135,258.36
5,664,741.64
2
95,942.30
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
Page 22 of 27
Budget Performance Report Fiscal Year to Date 10/31/17 Exclude Rollup Account
Account
Account Description
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Budget - YTD % Used/ Transactions
5,000.00
.00
5,000.00
25.00
.00
175.00
4,825.00
4
500.00
.00
.00
.00
.00
.00
.00
.00
+++
2,189,567.00
Rec'd
Prior Year Total
Fund 11 - Capital Improvement Fund REVENUE 0806.000
Other Receipts
0999.901
Transfer From General
0999.917
Transfer From TIF
500,000.00
.00
500,000.00
.00
.00
.00
500,000.00
0
500,000.00
REVENUE TOTALS
$14,071,125.00
$0.00
$14,071,125.00
$470,994.97
$0.00
$3,105,182.66
$10,965,942.34
22%
$10,258,977.98
110,000.00
.00
110,000.00
9,190.00
.00
36,875.57
73,124.43
34
110,742.39
Division 00 - Non-Divisional Totals
$110,000.00
$0.00
$110,000.00
$9,190.00
$0.00
$36,875.57
$73,124.43
34%
$110,742.39
EXPENSE Unit 00 - Non-Departmental Division 00 - Non-Divisional 8135
Contractual Services Division 91 - Capital
8135.006
Emerald Ash Borer
200,000.00
.00
200,000.00
.00
.00
.00
200,000.00
0
279,983.00
8225
Engineering Fees
100,000.00
.00
100,000.00
1,837.50
.00
18,344.46
81,655.54
18
106,348.64
9105
Building Improvements
200,000.00
.00
200,000.00
.00
.00
68,700.50
131,299.50
34
96,014.15
9105.005
Building Improvements-Police
.00
.00
.00
.00
.00
.00
.00
+++
32.47
9107.002
127th St-Plfd/Naperville Rd
100,000.00
.00
100,000.00
.00
.00
.00
100,000.00
0
.00
9107.004
Rt 30 and 143rd
10,000.00
.00
10,000.00
.00
.00
.00
10,000.00
0
.00
9112
Sidewalk Curb & Bikepath Replace
500,000.00
.00
500,000.00
1,828.51
.00
158,991.02
341,008.98
32
163,591.79
9120.005
Machinery and Equipment-Police
225,000.00
.00
225,000.00
21,246.32
.00
171,805.75
53,194.25
76
231,378.31
9120.008
Machinery and Equipment-Public Works
325,000.00
.00
325,000.00
9,567.35
9,410.53
15,455.24
300,134.23
8
303,607.42
9152.001
Street Lights-Replacement
125,000.00
.00
125,000.00
.00
.00
.00
125,000.00
0
74,735.42
9152.002
School Beacon Upgrades
5,000.00
.00
5,000.00
3,467.00
3,467.00
3,467.00
(1,934.00)
139
.00
9152.003
PCI Pavement Inspection
.00
.00
.00
.00
.00
.00
.00
+++
73,975.00
9152.004
Settler's Park-Campus Refresh
90,000.00
.00
90,000.00
291.70
.00
291.70
89,708.30
0
168,834.15
9152.005
Ft. Beggs Street Lighting
.00
.00
.00
.00
.00
.00
.00
+++
205,829.84
9152.006
PACE Park-N-Ride
5,800,000.00
.00
5,800,000.00
.00
.00
135,258.36
5,664,741.64
2
99,187.41
9152.007
Gateway Signage
50,000.00
.00
50,000.00
.00
.00
.00
50,000.00
0
.00
9155
Bridge Repairs & Reconstruction
425,000.00
.00
425,000.00
.00
.00
.00
425,000.00
0
.00
9156
Storm & Drainage Improvements
45,000.00
.00
45,000.00
.00
.00
7,293.89
37,706.11
16
9,685.86
9164
Pavement Patching
125,000.00
.00
125,000.00
(115,855.00)
.00
115,855.00
9,145.00
93
74,678.34
9165
Roadway Improvements
1,000,000.00
.00
1,000,000.00
946,021.73
.00
929,838.91
70,161.09
93
485,235.47
9165.009
143rd St. Extension Phase 2
1,400,000.00
.00
1,400,000.00
.00
.00
53,881.37
1,346,118.63
4
711,301.02
9165.019
I-55 Interchange Design
320,000.00
.00
320,000.00
89,549.18
.00
132,878.74
187,121.26
42
33,290.79
9165.028
Renwick Corridor
70,000.00
.00
70,000.00
.00
.00
14,809.21
55,190.79
21
7,122.85
9165.029
Rt 30 Reconstruction-Village Portion
.00
.00
.00
.00
.00
.00
.00
+++
104,582.20
9165.030
127th-Heggs to Meadow
680,000.00
.00
680,000.00
.00
.00
198,873.00
481,127.00
29
263,729.61
9165.031
Village Green
130,000.00
.00
130,000.00
974.74
.00
11,510.06
118,489.94
9
2,642.63
$11,925,000.00
$0.00
$11,925,000.00
$958,929.03
$12,877.53
$2,037,254.21
$9,874,868.26
17%
$3,495,786.37
2,036,125.00
.00
2,036,125.00
.00
.00
1,018,062.50
1,018,062.50
50
2,032,264.47
Division 91 - Capital Totals Division 99 - Transfers 9905
Transfer to Debt Service
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
Page 23 of 27
Budget Performance Report Fiscal Year to Date 10/31/17 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 11 - Capital Improvement Fund EXPENSE Unit 00 - Non-Departmental Division 99 - Transfers Totals
$2,036,125.00
$0.00
$2,036,125.00
$0.00
$0.00
$1,018,062.50
$1,018,062.50
50%
$2,032,264.47
Unit 00 - Non-Departmental Totals
$14,071,125.00
$0.00
$14,071,125.00
$968,119.03
$12,877.53
$3,092,192.28
$10,966,055.19
22%
$5,638,793.23
EXPENSE TOTALS
$14,071,125.00
$0.00
$14,071,125.00
$968,119.03
$12,877.53
$3,092,192.28
$10,966,055.19
22%
$5,638,793.23
REVENUE TOTALS
14,071,125.00
.00
14,071,125.00
470,994.97
.00
3,105,182.66
10,965,942.34
22%
10,258,977.98
EXPENSE TOTALS
14,071,125.00
.00
14,071,125.00
968,119.03
12,877.53
3,092,192.28
10,966,055.19
22%
Fund 11 - Capital Improvement Fund Totals
$0.00
$0.00
$0.00
($497,124.06)
($12,877.53)
$12,990.38
($112.85)
Fund 11 - Capital Improvement Fund Totals 5,638,793.23 $4,620,184.75
Fund 14 - D.A.R.E. Fund REVENUE 0800.800
Interest Income
0801.840
DARE Contribution
20.00
.00
20.00
5.37
.00
15.46
4.54
77
44.93
20,000.00
.00
20,000.00
17,529.53
.00
21,940.53
(1,940.53)
110
18,294.57
REVENUE TOTALS
$20,020.00
$0.00
$20,020.00
$17,534.90
$0.00
$21,955.99
($1,935.99)
110%
$18,339.50
20,000.00
.00
20,000.00
770.22
.00
2,731.22
17,268.78
14
21,529.69
Division 00 - Non-Divisional Totals
$20,000.00
$0.00
$20,000.00
$770.22
$0.00
$2,731.22
$17,268.78
14%
$21,529.69
Unit 00 - Non-Departmental Totals
$20,000.00
$0.00
$20,000.00
$770.22
$0.00
$2,731.22
$17,268.78
14%
$21,529.69
EXPENSE TOTALS
$20,000.00
$0.00
$20,000.00
$770.22
$0.00
$2,731.22
$17,268.78
14%
$21,529.69
REVENUE TOTALS
20,020.00
.00
20,020.00
17,534.90
.00
21,955.99
(1,935.99)
110%
18,339.50
EXPENSE TOTALS
20,000.00
.00
20,000.00
770.22
.00
2,731.22
17,268.78
14%
Fund 14 - D.A.R.E. Fund Totals
$20.00
$0.00
$20.00
$16,764.68
$0.00
$19,224.77
($19,204.77)
745,000.00
.00
745,000.00
64,081.52
.00
672,905.99
72,094.01
90
2,000.00
.00
2,000.00
1,079.52
.00
4,342.20
(2,342.20)
217
5,190.49
$747,000.00
$0.00
$747,000.00
$65,161.04
$0.00
$677,248.19
$69,751.81
91%
$742,112.55
429,675.92
EXPENSE Unit 00 - Non-Departmental Division 00 - Non-Divisional 8245
D.A.R.E. Program
Fund 14 - D.A.R.E. Fund Totals 21,529.69 ($3,190.19)
Fund 17 - Tax Increment Financing Fund REVENUE 0400.401
Property Tax Revenue
0800.800
Interest Income REVENUE TOTALS
736,922.06
EXPENSE Unit 00 - Non-Departmental Division 91 - Capital 8135
Contractual Services
450,000.00
.00
450,000.00
3,078.55
.00
64,964.15
385,035.85
14
9199
Facade Improvements
125,000.00
.00
125,000.00
70,196.65
.00
96,393.58
28,606.42
77
157,162.33
$575,000.00
$0.00
$575,000.00
$73,275.20
$0.00
$161,357.73
$413,642.27
28%
$586,838.25
50,000.00
.00
50,000.00
.00
.00
.00
50,000.00
0
.00
Division 91 - Capital Totals Division 99 - Transfers 9901
Transfer to General
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
Page 24 of 27
Budget Performance Report Fiscal Year to Date 10/31/17 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 17 - Tax Increment Financing Fund EXPENSE Unit 00 - Non-Departmental Division 99 - Transfers 9911
Transfer to Capital Improvements
500,000.00
.00
500,000.00
.00
.00
.00
500,000.00
0
500,000.00
Division 99 - Transfers Totals
$550,000.00
$0.00
$550,000.00
$0.00
$0.00
$0.00
$550,000.00
0%
$500,000.00
Unit 00 - Non-Departmental Totals
$1,125,000.00
$0.00
$1,125,000.00
$73,275.20
$0.00
$161,357.73
$963,642.27
14%
$1,086,838.25
EXPENSE TOTALS
$1,125,000.00
$0.00
$1,125,000.00
$73,275.20
$0.00
$161,357.73
$963,642.27
14%
$1,086,838.25
REVENUE TOTALS
747,000.00
.00
747,000.00
65,161.04
.00
677,248.19
69,751.81
91%
742,112.55
EXPENSE TOTALS
1,125,000.00
.00
1,125,000.00
73,275.20
.00
161,357.73
963,642.27
14%
1,086,838.25
Fund 17 - Tax Increment Financing Fund Totals
($378,000.00)
$0.00
($378,000.00)
($8,114.16)
$0.00
$515,890.46
($893,890.46)
Fund 17 - Tax Increment Financing Fund Totals
($344,725.70)
Fund 26 - Sex Offender's Registration Fund REVENUE 0600.606
Sex Offenders Registration
.00
.00
.00
110.00
.00
610.00
(610.00)
+++
0800.800
Interest Income
.00
.00
.00
2.24
.00
9.62
(9.62)
+++
950.00 9.11
REVENUE TOTALS
$0.00
$0.00
$0.00
$112.24
$0.00
$619.62
($619.62)
+++
$959.11
.00
.00
.00
210.00
.00
420.00
(420.00)
+++
1,015.00
Division 00 - Non-Divisional Totals
$0.00
$0.00
$0.00
$210.00
$0.00
$420.00
($420.00)
+++
$1,015.00
Unit 00 - Non-Departmental Totals
$0.00
$0.00
$0.00
$210.00
$0.00
$420.00
($420.00)
+++
$1,015.00
EXPENSE TOTALS
$0.00
$0.00
$0.00
$210.00
$0.00
$420.00
($420.00)
+++
$1,015.00
REVENUE TOTALS
.00
.00
.00
112.24
.00
619.62
(619.62)
+++
959.11
EXPENSE TOTALS
.00
.00
.00
210.00
.00
420.00
(420.00)
+++
1,015.00
Fund 26 - Sex Offender's Registration Fund Totals
$0.00
$0.00
$0.00
($97.76)
$0.00
$199.62
($199.62)
15,000.00
.00
15,000.00
.00
.00
7,992.00
7,008.00
53
100.00
.00
100.00
48.05
.00
208.33
(108.33)
208
207.30
REVENUE TOTALS
$15,100.00
$0.00
$15,100.00
$48.05
$0.00
$8,200.33
$6,899.67
54%
$16,852.30
20,000.00
.00
20,000.00
.00
.00
.00
20,000.00
0
12,000.00
Division 99 - Transfers Totals
$20,000.00
$0.00
$20,000.00
$0.00
$0.00
$0.00
$20,000.00
0%
$12,000.00
Unit 00 - Non-Departmental Totals
$20,000.00
$0.00
$20,000.00
$0.00
$0.00
$0.00
$20,000.00
0%
$12,000.00
EXPENSE Unit 00 - Non-Departmental Division 00 - Non-Divisional 9290
Sex Offender's Registration Fee
Fund 26 - Sex Offender's Registration Fund Totals
($55.89)
Fund 27 - Alcohol Enforcement Fund REVENUE 0600.610
Alcohol Fines
0800.800
Interest Income
16,645.00
EXPENSE Unit 00 - Non-Departmental Division 99 - Transfers 9901
Transfer to General
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
Page 25 of 27
Budget Performance Report Fiscal Year to Date 10/31/17 Exclude Rollup Account
Account
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions
Rec'd
Prior Year Total
$20,000.00
$0.00
$20,000.00
$0.00
$0.00
$0.00
$20,000.00
0%
$12,000.00
REVENUE TOTALS
15,100.00
.00
15,100.00
48.05
.00
8,200.33
6,899.67
54%
16,852.30
EXPENSE TOTALS
20,000.00
.00
20,000.00
.00
.00
.00
20,000.00
0%
12,000.00
Fund 27 - Alcohol Enforcement Fund Totals
($4,900.00)
$0.00
($4,900.00)
$48.05
$0.00
$8,200.33
($13,100.33)
Account Description
Budget - YTD % Used/
Fund 27 - Alcohol Enforcement Fund EXPENSE TOTALS Fund 27 - Alcohol Enforcement Fund Totals
$4,852.30
Fund 28 - Drug Enforcement Fund REVENUE 0600.611
Drug Fines
.00
.00
.00
.00
.00
308.00
(308.00)
+++
0800.800
Interest Income
.00
.00
.00
38.75
.00
177.25
(177.25)
+++
172.97
$0.00
$0.00
$0.00
$38.75
$0.00
$485.25
($485.25)
+++
$920.97
REVENUE TOTALS
.00
.00
.00
38.75
.00
485.25
(485.25)
+++
920.97
EXPENSE TOTALS
.00
.00
.00
.00
.00
.00
.00
+++
Fund 28 - Drug Enforcement Fund Totals
$0.00
$0.00
$0.00
$38.75
$0.00
$485.25
($485.25)
REVENUE TOTALS
748.00
Fund 28 - Drug Enforcement Fund Totals .00 $920.97
Fund 29 - Police Vehicle Replacement Fund REVENUE 0600.612
Vehicle Replacement-Will
.00
.00
.00
2,380.00
.00
18,642.00
(18,642.00)
+++
0800.800
Interest Income
.00
.00
.00
172.36
.00
764.76
(764.76)
+++
650.77
$0.00
$0.00
$0.00
$2,552.36
$0.00
$19,406.76
($19,406.76)
+++
$33,104.77
REVENUE TOTALS
.00
.00
.00
2,552.36
.00
19,406.76
(19,406.76)
+++
33,104.77
EXPENSE TOTALS
.00
.00
.00
.00
.00
.00
.00
+++
Fund 29 - Police Vehicle Replacement Fund Totals
$0.00
$0.00
$0.00
$2,552.36
$0.00
$19,406.76
($19,406.76)
REVENUE TOTALS
32,454.00
Fund 29 - Police Vehicle Replacement Fund Totals .00 $33,104.77
Fund 40 - PEMA Fund REVENUE 0800.800
Interest Income
.00
.00
.00
17.05
.00
84.91
(84.91)
+++
80.73
0801.822
Donation/Contribution
.00
.00
.00
.00
.00
500.00
(500.00)
+++
4,757.69
REVENUE TOTALS
$0.00
$0.00
$0.00
$17.05
$0.00
$584.91
($584.91)
+++
$4,838.42
.00
.00
.00
.00
.00
2,347.00
(2,347.00)
+++
.00
Division 00 - Non-Divisional Totals
$0.00
$0.00
$0.00
$0.00
$0.00
$2,347.00
($2,347.00)
+++
$0.00
Unit 00 - Non-Departmental Totals
$0.00
$0.00
$0.00
$0.00
$0.00
$2,347.00
($2,347.00)
+++
$0.00
EXPENSE TOTALS
$0.00
$0.00
$0.00
$0.00
$0.00
$2,347.00
($2,347.00)
+++
$0.00
EXPENSE Unit 00 - Non-Departmental Division 00 - Non-Divisional 9140
PEMA Fundraising
Fund 40 - PEMA Fund Totals
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
Page 26 of 27
Budget Performance Report Fiscal Year to Date 10/31/17 Exclude Rollup Account
Account
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions
Rec'd
Prior Year Total
REVENUE TOTALS
.00
.00
.00
17.05
.00
584.91
(584.91)
+++
4,838.42
EXPENSE TOTALS
.00
.00
.00
.00
.00
2,347.00
(2,347.00)
+++
Fund 40 - PEMA Fund Totals
$0.00
$0.00
$0.00
$17.05
$0.00
($1,762.09)
$1,762.09
REVENUE TOTALS
64,811,117.00
.00
64,811,117.00
4,855,968.48
.00
36,333,756.96
28,477,360.04
56%
62,432,575.85
EXPENSE TOTALS
62,884,447.00
.00
62,884,447.00
5,636,322.81
49,418.36
22,810,971.19
40,024,057.45
36%
53,321,796.97
Grand Totals
$1,926,670.00
$0.00
$1,926,670.00
($780,354.33)
($49,418.36)
$13,522,785.77
($11,546,697.41)
Account Description
Budget - YTD % Used/
.00 $4,838.42
Grand Totals
Run by Colleen Thornton on 11/15/2017 11:59:05 AM
$9,110,778.88
Page 27 of 27
