Budget Performance Report
Budget Performance Report Fiscal Year to Date 01/31/18 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
.00
.00
3,238,346.82
(78,346.82)
102
0400.402
Property Tax Rev-Road & Bridge
375,000.00
.00
375,000.00
.00
.00
362,940.98
12,059.02
97
357,161.29
0400.403
Property Tax Rev-Police Pension
1,370,000.00
.00
1,370,000.00
.00
.00
1,364,479.09
5,520.91
100
1,101,142.15
0400.404
Property Tax Revenue-IMRF
575,000.00
.00
575,000.00
.00
.00
573,025.75
1,974.25
100
575,655.27
0450.450
Home Rule Sales Tax
500,000.00
.00
500,000.00
.00
.00
500,000.00
.00
100
.00
0450.451
Municipal Sales Tax
5,400,000.00
.00
5,400,000.00
463,682.83
.00
4,113,784.91
1,286,215.09
76
5,354,048.49
0450.452
Illinois Income Tax
3,550,000.00
.00
3,550,000.00
300,781.21
.00
3,202,284.03
347,715.97
90
3,741,387.32
0450.453
Replacement Tax
45,000.00
.00
45,000.00
5,885.17
.00
34,809.19
10,190.81
77
56,644.71
0450.454
Replacement Tax-Library
.00
.00
.00
1,729.42
.00
1,729.42
(1,729.42)
+++
.00
0450.455
Local Use Tax
875,000.00
.00
875,000.00
86,448.31
.00
724,581.18
150,418.82
83
974,197.53
0500.500
Hotel/Motel Tax
.00
.00
.00
416.63
.00
1,438.30
(1,438.30)
+++
198.71
0500.501
Amusement Tax
5,000.00
.00
5,000.00
1,635.14
.00
4,945.33
54.67
99
9,892.85
0500.503
Local Motor Fuel Tax
930,000.00
.00
930,000.00
94,411.99
.00
816,289.60
113,710.40
88
959,052.15
0550.551
Liquor License
100,000.00
.00
100,000.00
1,200.00
.00
103,258.01
(3,258.01)
103
103,568.00
0550.552
Contractors License
35,000.00
.00
35,000.00
2,600.00
.00
37,450.00
(2,450.00)
107
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
4,312.50
.00
36,600.00
(1,600.00)
105
37,788.00
0570.555
Building Permit
925,000.00
.00
925,000.00
43,496.80
.00
638,511.97
286,488.03
69
952,316.60
0570.556
Sign Permit
5,000.00
.00
5,000.00
434.00
.00
3,385.00
1,615.00
68
7,763.00
0570.557
Special Movement Permit
5,000.00
.00
5,000.00
3,680.00
.00
16,730.00
(11,730.00)
335
8,630.00
0570.560
Solicitors Permit
1,000.00
.00
1,000.00
140.00
.00
1,715.00
(715.00)
172
1,785.00
0600.601
County Court Fines
325,000.00
.00
325,000.00
25,547.22
.00
274,966.69
50,033.31
85
367,797.10
0600.602
Administrative Fines(P-Tickets)
130,000.00
.00
130,000.00
8,445.00
.00
86,510.00
43,490.00
67
135,528.00
0600.603
Asset Seizure-Non Federal
225,000.00
.00
225,000.00
.00
.00
10,250.99
214,749.01
5
100,189.55
0600.604
Alarm Fees
7,000.00
.00
7,000.00
.00
.00
3,050.00
3,950.00
44
2,025.00
0600.605
Kendall County Court Fines
1,000.00
.00
1,000.00
277.94
.00
2,059.78
(1,059.78)
206
1,165.84
0600.607
Administrative Fines- Late Fee
10,000.00
.00
10,000.00
700.00
.00
5,775.00
4,225.00
58
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
.00
.00
.00
.00
.00
.00
.00
+++
921.38
4,112,315.00
.00
4,112,315.00
353,293.07
.00
3,452,663.07
659,651.93
84
3,992,763.21
Garbage Penalties
50,000.00
.00
50,000.00
4,707.24
.00
42,113.03
7,886.97
84
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
80.00
.00
9,707.88
292.12
97
13,162.00
Accident Report Fees
4,000.00
.00
4,000.00
550.00
.00
4,580.00
(580.00)
114
4,585.00
Copies-Maps & Ordinances
3,000.00
.00
3,000.00
140.25
.00
1,989.70
1,010.30
66
2,366.70
30,000.00
.00
30,000.00
2,250.00
.00
19,500.00
10,500.00
65
22,852.50
Run by Colleen Thornton on 02/21/2018 02:32:35 PM
Page 1 of 27
Budget Performance Report Fiscal Year to Date 01/31/18 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.815
Parking Lot Revenue
2,000.00
.00
2,000.00
.00
.00
1,950.00
50.00
98
4,532.00
0650.818
Tower Rent
50,000.00
.00
50,000.00
3,400.17
.00
32,696.79
17,303.21
65
38,191.41
0650.825
Rental Income
50,000.00
.00
50,000.00
4,100.00
.00
36,900.00
13,100.00
74
45,100.00
0650.830
Rental-Community/Multi Room
3,000.00
.00
3,000.00
243.75
.00
3,343.75
(343.75)
111
4,546.75
0650.904
Special Detail/OT Reimbursement
45,000.00
.00
45,000.00
3,375.00
.00
112,640.40
(67,640.40)
250
68,278.93
0690.902
Water & Sewer Service Charge
250,000.00
.00
250,000.00
.00
.00
125,000.00
125,000.00
50
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
.00
.00
1,520.86
1,479.14
51
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,287.54
.00
13,590.96
16,409.04
45
15,038.66
0750.750
AT&T Franchise Fees
250,000.00
.00
250,000.00
624.13
.00
132,657.15
117,342.85
53
209,381.47
0750.751
Cable TV-Franchise Fees
480,000.00
.00
480,000.00
.00
.00
396,082.08
83,917.92
83
533,615.95
0800.800
Interest Income
35,000.00
.00
35,000.00
7,187.71
.00
68,198.85
(33,198.85)
195
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
.00
.00
(8,896.42)
8,896.42
+++
(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
(4,053.37)
.00
(4,578.33)
4,578.33
+++
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
250.00
.00
1,325.00
(825.00)
265
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
1,386.00
.00
16,996.29
(6,996.29)
170
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
6,810.22
.00
193,707.46
(113,707.46)
242
86,085.15
25,000.00
.00
25,000.00
2,518.18
.00
13,246.64
11,753.36
53
13,218.83
.00
.00
.00
.00
.00
.00
.00
+++
151,127.00
School Liaison Reimbursement
400,000.00
.00
400,000.00
106,635.60
.00
345,593.63
54,406.37
86
431,372.53
HIDTA/Organized Crime Reimb
10,000.00
.00
10,000.00
1,756.00
.00
9,954.39
45.61
100
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
$1,543,365.65
$0.00
$21,226,763.60
$3,557,551.40
86%
$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)
EXPENSE Unit 00 - Non-Departmental Division 94 - Contra 2020.001
Contra Insurance Account
Run by Colleen Thornton on 02/21/2018 02:32:35 PM
Page 2 of 27
Budget Performance Report Fiscal Year to Date 01/31/18 Exclude Rollup Account
Account
Account Description
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Budget - YTD % Used/ Transactions
3,808,325.00
.00
3,808,325.00
315,677.32
.00
2,520,188.52
.00
.00
.00
.00
.00
.00
$3,808,325.00
$0.00
$3,808,325.00
$315,677.32
$0.00
Rec'd
Prior Year Total
1,288,136.48
66
3,669,782.29
.00
+++
134,093.16
$2,520,188.52
$1,288,136.48
66%
$3,803,875.45
Fund 01 - General Fund EXPENSE Unit 04 - Administration/Finance Division 00 - Non-Divisional 8100
Fees to Refuse Hauler
9997
Bad Debt Expense Division 00 - Non-Divisional Totals Division 01 - Legislative Program
1000
Salaries-President
24,000.00
.00
24,000.00
2,000.00
.00
17,666.67
6,333.33
74
20,000.04
1002
Salaries-Elected Officials
25,000.00
.00
25,000.00
1,600.00
.00
19,100.00
5,900.00
76
24,100.00
1003
Salaries-Liquor Commissioner
1,500.00
.00
1,500.00
125.00
.00
1,125.00
375.00
75
1,500.00
1004
Salaries-Treasurer
2,500.00
.00
2,500.00
208.33
.00
1,874.97
625.03
75
2,499.96
2000
FICA
3,300.00
.00
3,300.00
230.23
.00
2,345.26
954.74
71
2,783.06
2001
Medicare
780.00
.00
780.00
53.84
.00
548.48
231.52
70
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
102.90
47.10
69
92.40
3000
Travel/Training
10,000.00
.00
10,000.00
.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
14,856.15
20,143.85
42
38,761.37
8070
Public Relations
115,000.00
.00
115,000.00
124.39
.00
47,082.14
67,917.86
41
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
23,343.18
.00
99,928.04
75,071.96
57
36,007.59
$406,130.00
$0.00
$406,130.00
$27,697.57
$0.00
$209,854.49
$196,275.51
52%
$262,248.35
Division 01 - Legislative Program Totals Division 02 - Administration Program 1005
Salaries-Full Time
710,000.00
.00
710,000.00
58,775.82
.00
551,991.97
158,008.03
78
688,352.30
1015
Salaries-Part Time
50,000.00
.00
50,000.00
3,406.66
.00
40,385.89
9,614.11
81
45,065.94
1800
Salaries-Overtime
1,000.00
.00
1,000.00
87.82
.00
2,502.98
(1,502.98)
250
339.33
2000
FICA
47,500.00
.00
47,500.00
3,811.23
.00
32,576.34
14,923.66
69
40,632.69
2001
Medicare
11,000.00
.00
11,000.00
891.35
.00
8,502.07
2,497.93
77
10,673.40
2010
IMRF
84,000.00
.00
84,000.00
6,897.83
.00
65,671.31
18,328.69
78
83,197.55
2020
Employee Insurance
109,000.00
.00
109,000.00
7,783.59
.00
80,101.89
28,898.11
73
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
308.00
.00
5,467.39
9,532.61
36
9,487.79
3015
IL Unemployment Insurance
7,000.00
.00
7,000.00
.00
.00
1,867.02
5,132.98
27
3,505.77
4000
Telephone/Internet
5,000.00
.00
5,000.00
345.08
.00
3,567.27
1,432.73
71
4,094.28
4005
Cellular Phones/Pagers
2,500.00
.00
2,500.00
156.73
.00
1,629.49
870.51
65
3,004.18
5005
Office Supplies/Postage
30,000.00
.00
30,000.00
2,108.84
1,080.00
22,700.00
6,220.00
79
30,162.77
5015
Dues & Subscriptions
5,000.00
.00
5,000.00
.00
.00
3,238.95
1,761.05
65
4,072.00
5020
Gas/Oil/Mileage/Carwash
9,500.00
.00
9,500.00
600.00
.00
5,911.15
3,588.85
62
8,259.64
8035
Maintenance Contracts/Lease
8,000.00
.00
8,000.00
659.00
.00
5,272.00
2,728.00
66
7,908.00
8045
Recording Fees
2,000.00
.00
2,000.00
182.00
.00
182.00
1,818.00
9
1,379.49
Run by Colleen Thornton on 02/21/2018 02:32:35 PM
Page 3 of 27
Budget Performance Report Fiscal Year to Date 01/31/18 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 8050
Legal Notices
2,500.00
.00
2,500.00
386.80
.00
2,031.59
468.41
81
1,600.28
8065
Legal Fees
50,000.00
.00
50,000.00
7,530.00
.00
23,620.00
26,380.00
47
30,735.50
8135
Contractual Services
75,000.00
.00
75,000.00
2,108.27
.00
38,079.47
36,920.53
51
85,320.19
8135.008
Settlement Charges
.00
.00
.00
.48
.00
.48
(.48)
+++
.00
8225
Engineering Fees
5,000.00
.00
5,000.00
.00
.00
.00
5,000.00
0
2,283.20
9115
Office Furniture & Equipment
9300
Contingencies Division 02 - Administration Program Totals
5,000.00
.00
5,000.00
.00
4.21
640.84
4,354.95
13
4,632.33
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
$96,039.50
$1,084.21
$895,940.10
$406,975.69
69%
$1,209,847.95
Division 03 - Community Relations Program 1005
Salaries-Full Time
101,000.00
.00
101,000.00
7,630.88
.00
76,215.75
24,784.25
75
96,782.14
2000
FICA
6,200.00
.00
6,200.00
433.21
.00
4,261.99
1,938.01
69
5,592.49
2001
Medicare
1,450.00
.00
1,450.00
101.32
.00
996.76
453.24
69
1,307.94
2010
IMRF
11,500.00
.00
11,500.00
847.80
.00
8,476.00
3,024.00
74
11,059.04
2020
Employee Insurance
20,700.00
.00
20,700.00
1,615.65
.00
16,045.04
4,654.96
78
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
95.00
1,405.00
6
142.50
4000
Telephone/Internet
500.00
.00
500.00
34.51
.00
356.73
143.27
71
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
1,316.00
(566.00)
175
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
8,096.45
8,903.55
48
8,157.09
8071
Marketing and Promotions
2,500.00
.00
2,500.00
.00
.00
500.00
2,000.00
20
.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
336.00
.00
336.00
2,164.00
13
.00
$180,450.00
$0.00
$180,450.00
$11,041.87
$0.00
$121,513.11
$58,936.89
67%
$151,044.29
Division 04 - Facility Management Program 1005
Salaries-Full Time
50,000.00
.00
50,000.00
3,384.11
.00
34,167.99
15,832.01
68
33,936.93
1800
Salaries-Overtime
2,500.00
.00
2,500.00
1,061.39
.00
3,052.82
(552.82)
122
1,705.28
2000
FICA
3,300.00
.00
3,300.00
265.26
.00
2,216.86
1,083.14
67
2,245.20
2001
Medicare
800.00
.00
800.00
62.05
.00
518.52
281.48
65
525.16
2010
IMRF
5,500.00
.00
5,500.00
493.91
.00
4,128.75
1,371.25
75
4,221.28
2020
Employee Insurance
14,000.00
.00
14,000.00
1,181.16
.00
9,451.51
4,548.49
68
9,199.52
5000
Building Supplies
7,500.00
.00
7,500.00
.00
.00
8,842.01
(1,342.01)
118
9,970.18
8135
Contractual Services
40,000.00
.00
40,000.00
.00
.00
27,870.19
12,129.81
70
32,624.35
9105
Building Improvements Division 04 - Facility Management Program Totals
Run by Colleen Thornton on 02/21/2018 02:32:35 PM
40,000.00
.00
40,000.00
.00
.00
27,782.89
12,217.11
69
.00
$163,600.00
$0.00
$163,600.00
$6,447.88
$0.00
$118,031.54
$45,568.46
72%
$94,427.90
Page 4 of 27
Budget Performance Report Fiscal Year to Date 01/31/18 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
126,395.64
38,604.36
77
1800
Salaries-Overtime
500.00
.00
500.00
.00
.00
.00
500.00
0
.00
2000
FICA
10,500.00
.00
10,500.00
734.06
.00
7,464.46
3,035.54
71
8,014.37
2001
Medicare
2,500.00
.00
2,500.00
171.67
.00
1,745.72
754.28
70
1,874.33
2010
IMRF
19,000.00
.00
19,000.00
1,378.52
.00
14,041.89
4,958.11
74
15,421.82
2020
Employee Insurance
43,500.00
.00
43,500.00
2,900.74
.00
28,648.65
14,851.35
66
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
.00
.00
4,063.67
2,436.33
63
4,493.94
4000
Telephone/Internet
1,000.00
.00
1,000.00
69.02
.00
713.43
286.57
71
818.87
4005
Cellular Phones/Pagers
600.00
.00
600.00
54.85
.00
328.74
271.26
55
120.00
5005
Office Supplies/Postage
1,500.00
.00
1,500.00
58.54
.00
515.96
984.04
34
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
303.46
1,096.54
22
281.88
8070
Public Relations
12,000.00
.00
12,000.00
.00
.00
6,151.14
5,848.86
51
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
924.00
.00
3,003.24
4,996.76
38
6,462.99
$282,500.00
$0.00
$282,500.00
$18,699.24
$0.00
$193,595.00
$88,905.00
69%
$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
185,539.51
54,460.49
77
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
11,255.86
3,744.14
75
13,700.47
2001
Medicare
3,500.00
.00
3,500.00
259.94
.00
2,632.40
867.60
75
3,204.13
2010
IMRF
28,000.00
.00
28,000.00
2,036.70
.00
20,580.00
7,420.00
74
25,141.33
2020
Employee Insurance
56,000.00
.00
56,000.00
3,276.81
.00
32,406.56
23,593.44
58
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
9,571.88
4,928.12
66
19,185.65
4000
Telephone/Internet
500.00
.00
500.00
34.51
.00
356.73
143.27
71
409.42
4005
Cellular Phones/Pagers
2,340.00
.00
2,340.00
192.74
.00
1,570.32
769.68
67
2,211.40
5005
Office Supplies/Postage
1,400.00
.00
1,400.00
.00
.00
874.86
525.14
62
1,424.65
5015
Dues & Subscriptions
700.00
.00
700.00
85.00
.00
484.00
216.00
69
539.19
5020
Gas/Oil/Mileage/Carwash
400.00
.00
400.00
.00
.00
506.40
(106.40)
127
275.49
5095
Uniforms/Clothing
300.00
.00
300.00
.00
.00
302.82
(2.82)
101
.00
8030
Server/Network Supplies
47,900.00
.00
47,900.00
30,043.05
.00
44,720.16
3,179.84
93
33,660.64
8031
Software Licensing/Renewals
255,380.00
.00
255,380.00
8,203.68
8,268.89
198,040.56
49,070.55
81
220,551.71
8135
Contractual Services
17,880.00
.00
17,880.00
5,006.99
5,100.00
10,791.96
1,988.04
89
8,366.46
9111
Computers
12,000.00
.00
12,000.00
.00
.00
7,267.53
4,732.47
61
10,469.04
$703,300.00
$0.00
$703,300.00
$68,583.32
$13,368.89
$526,901.55
$163,029.56
77%
$609,814.39
Division 08 - IT Program Totals
Run by Colleen Thornton on 02/21/2018 02:32:35 PM
Page 5 of 27
Budget Performance Report Fiscal Year to Date 01/31/18 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
$544,186.70
$14,453.10
$4,586,024.31
$2,247,827.59
67%
$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
232,485.22
82,514.78
74
302,896.76
1015
Salaries-Part Time
26,296.00
.00
26,296.00
2,267.28
.00
24,725.39
1,570.61
94
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,482.43
.00
14,902.09
6,443.91
70
18,486.24
2001
Medicare
5,000.00
.00
5,000.00
346.71
.00
3,562.71
1,437.29
71
4,531.54
2010
IMRF
23,375.00
.00
23,375.00
1,635.31
.00
16,559.16
6,815.84
71
21,038.04
2020
Employee Insurance
66,780.00
.00
66,780.00
5,177.23
.00
51,041.27
15,738.73
76
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
445.00
.00
1,440.41
8,534.59
14
3,887.92
3001
Education/School
6,000.00
.00
6,000.00
.00
.00
493.67
5,506.33
8
433.15
3015
IL Unemployment Insurance
20,000.00
.00
20,000.00
.00
.00
9,152.37
10,847.63
46
17,278.91
4000
Telephone/Internet
605.00
.00
605.00
94.17
.00
1,034.11
(429.11)
171
1,282.86
4005
Cellular Phones/Pagers
1,644.00
.00
1,644.00
54.85
.00
474.71
1,169.29
29
996.63
5005
Office Supplies/Postage
11,950.00
.00
11,950.00
718.97
.00
2,866.66
9,083.34
24
5,051.83
5010
Replacement Supplies
3,500.00
.00
3,500.00
37.01
.00
707.33
2,792.67
20
707.23
5015
Dues & Subscriptions
7,050.00
.00
7,050.00
285.00
.00
3,045.03
4,004.97
43
3,771.67
5020
Gas/Oil/Mileage/Carwash
3,700.00
.00
3,700.00
1.91
.00
544.23
3,155.77
15
1,342.51
5095
Uniforms/Clothing
1,800.00
.00
1,800.00
.00
.00
1,439.85
360.15
80
2,345.25
8035
Maintenance Contracts/Lease
7,190.00
.00
7,190.00
380.00
.00
4,175.02
3,014.98
58
6,709.70
8040
Custodian
70,000.00
.00
70,000.00
765.61
.00
27,308.81
42,691.19
39
52,222.70
8060
Vehicle Maintenance
2,500.00
.00
2,500.00
.00
.00
21.84
2,478.16
1
1,340.12
8135
Contractual Services
8,000.00
.00
8,000.00
530.00
.00
2,104.72
5,895.28
26
5,465.40
$622,711.00
$0.00
$622,711.00
$37,086.44
$0.00
$398,420.99
$224,290.01
64%
$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
284,149.95
.00
2,748,310.87
1,169,985.13
70
1015
Salaries-Part Time
.00
.00
.00
17,560.65
.00
190,588.10
(190,588.10)
+++
.00
1800
Salaries-Overtime
380,000.00
.00
380,000.00
28,950.11
.00
272,761.59
107,238.41
72
263,296.45
2000
FICA
266,494.00
.00
266,494.00
20,061.67
.00
192,884.66
73,609.34
72
214,599.36
2001
Medicare
62,325.00
.00
62,325.00
4,691.88
.00
45,396.11
16,928.89
73
50,934.89
2010
IMRF
54,538.00
.00
54,538.00
3,241.66
.00
32,675.22
21,862.78
60
6,289.04
2011
Employer Pension Contributions
1,370,000.00
.00
1,370,000.00
.00
.00
1,364,479.09
5,520.91
100
1,101,142.15
2020
Employee Insurance
630,739.00
.00
630,739.00
45,170.44
.00
453,569.78
177,169.22
72
528,506.74
Run by Colleen Thornton on 02/21/2018 02:32:35 PM
Page 6 of 27
Budget Performance Report Fiscal Year to Date 01/31/18 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
432.00
.00
27,176.53
18,923.47
59
35,571.37
4000
Telephone/Internet
27,180.00
.00
27,180.00
810.67
.00
15,390.78
11,789.22
57
24,799.44
4005
Cellular Phones/Pagers
6,564.00
.00
6,564.00
429.74
.00
3,635.82
2,928.18
55
5,005.24
5005
Office Supplies/Postage
13,000.00
.00
13,000.00
264.77
.00
8,403.38
4,596.62
65
13,298.15
5010
Replacement Supplies
17,000.00
.00
17,000.00
71.00
.00
7,774.70
9,225.30
46
15,849.82
5015
Dues & Subscriptions
3,400.00
.00
3,400.00
205.00
.00
767.50
2,632.50
23
1,388.16
5020
Gas/Oil/Mileage/Carwash
100,000.00
.00
100,000.00
133.95
.00
50,300.37
49,699.63
50
63,832.78
5068
K-9 Unit
4,000.00
.00
4,000.00
65.50
.00
3,864.90
135.10
97
4,513.66
5095
Uniforms/Clothing
33,850.00
.00
33,850.00
915.73
.00
25,270.47
8,579.53
75
32,245.78
5100
Ammunition/Weapons
28,000.00
.00
28,000.00
2,256.42
.00
10,809.08
17,190.92
39
25,790.93
5115.001
Traffic Programs
23,000.00
.00
23,000.00
.00
.00
11,885.68
11,114.32
52
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
8,096.00
.00
11,568.00
(176.00)
102
11,702.00
8060
Vehicle Maintenance
65,000.00
.00
65,000.00
1,017.14
.00
39,024.77
25,975.23
60
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
.00
.00
435,148.02
157,851.98
73
564,841.56
8267
Animal Control
14,000.00
.00
14,000.00
850.00
.00
5,360.00
8,640.00
38
.00
$7,771,878.00
$0.00
$7,771,878.00
$419,374.28
$0.00
$5,970,924.24
$1,800,953.76
77%
$6,489,435.16
Division 51 - Police Operations Totals Division 52 - Police Administration 1005
Salaries-Full Time
859,940.00
.00
859,940.00
71,000.94
.00
732,899.44
127,040.56
85
1,290,355.79
1800
Salaries-Overtime
113,000.00
.00
113,000.00
6,482.67
.00
67,371.49
45,628.51
60
94,858.97
2000
FICA
60,322.00
.00
60,322.00
4,659.21
.00
48,544.86
11,777.14
80
84,083.97
2001
Medicare
14,108.00
.00
14,108.00
1,089.66
.00
11,353.24
2,754.76
80
19,883.44
2020
Employee Insurance
152,801.00
.00
152,801.00
12,907.77
.00
131,763.64
21,037.36
86
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
30.00
.00
7,424.59
6,175.41
55
12,631.90
4000
Telephone/Internet
780.00
.00
780.00
121.08
.00
1,293.66
(513.66)
166
1,593.21
4005
Cellular Phones/Pagers
5,544.00
.00
5,544.00
831.70
.00
5,498.27
45.73
99
7,514.02
5005
Office Supplies/Postage
8,500.00
.00
8,500.00
223.91
.00
1,681.91
6,818.09
20
5,293.77
5010
Replacement Supplies
12,000.00
.00
12,000.00
1,234.65
.00
3,867.70
8,132.30
32
269.21
5015
Dues & Subscriptions
4,070.00
.00
4,070.00
95.00
.00
2,095.00
1,975.00
51
3,511.66
5020
Gas/Oil/Mileage/Carwash
29,000.00
.00
29,000.00
57.94
.00
9,675.64
19,324.36
33
20,479.50
5040.002
Crime Scene/Evidence Tech Supply
10,800.00
.00
10,800.00
.00
2,373.75
7,536.79
889.46
92
7,337.69
5095
Uniforms/Clothing
5,300.00
.00
5,300.00
.00
.00
5,624.29
(324.29)
106
10,061.29
5115.004
Community Programs-Explorer Program
2,500.00
.00
2,500.00
142.60
.00
7,114.14
(4,614.14)
285
4,368.54
Run by Colleen Thornton on 02/21/2018 02:32:35 PM
Page 7 of 27
Budget Performance Report Fiscal Year to Date 01/31/18 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
710.00
.00
2,724.59
6,195.41
31
4,047.80
15,500.00
.00
15,500.00
202.00
.00
6,986.62
8,513.38
45
12,012.78
.00
.00
.00
.00
.00
540.00
(540.00)
+++
.00
2,500.00
.00
2,500.00
148.60
.00
1,016.05
1,483.95
41
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
$99,937.73
$2,373.75
$1,059,606.92
$297,774.33
78%
$1,838,973.48 401,677.79
Division 53 - Police Records 1005
Salaries-Full Time
463,022.00
.00
463,022.00
28,747.27
.00
338,903.32
124,118.68
73
1015
Salaries-Part Time
.00
.00
.00
1,620.06
.00
12,565.86
(12,565.86)
+++
.00
1800
Salaries-Overtime
6,000.00
.00
6,000.00
62.50
.00
4,687.46
1,312.54
78
10,112.29
2000
FICA
29,079.00
.00
29,079.00
1,829.35
.00
21,676.68
7,402.32
75
24,805.18
2001
Medicare
6,801.00
.00
6,801.00
427.82
.00
5,069.52
1,731.48
75
5,806.35
2010
IMRF
31,086.00
.00
31,086.00
2,418.72
.00
24,369.65
6,716.35
78
33,212.62
2020
Employee Insurance
129,686.00
.00
129,686.00
6,885.83
.00
80,525.05
49,160.95
62
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
.00
.00
1,741.13
358.87
83
1,796.60
4000
Telephone/Internet
780.00
.00
780.00
121.08
.00
1,293.66
(513.66)
166
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
491.27
12.68
6,470.85
6,966.47
48
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
20.95
.00
1,460.41
939.59
61
1,610.86
8035
Maintenance Contracts/Lease Division 53 - Police Records Totals
4,460.00
.00
4,460.00
180.00
.00
2,865.00
1,595.00
64
2,160.00
$705,633.00
$0.00
$705,633.00
$42,804.85
$12.68
$501,628.59
$203,991.73
71%
$617,070.11
Division 54 - Seizure/Forfeiture 5012
Asset Seizure/Forfeiture Expense Division 54 - Seizure/Forfeiture Totals
225,000.00
.00
225,000.00
44,553.00
14,275.00
59,421.08
151,303.92
33
156,826.56
$225,000.00
$0.00
$225,000.00
$44,553.00
$14,275.00
$59,421.08
$151,303.92
33%
$156,826.56
32,513.00
.00
32,513.00
1,293.75
.00
77,862.50
(45,349.50)
239
46,555.00
2,016.00
.00
2,016.00
76.83
.00
4,709.08
(2,693.08)
234
2,621.16
471.00
.00
471.00
17.97
.00
1,103.03
(632.03)
234
620.25
1,000.00
.00
1,000.00
201.14
.00
201.14
798.86
20
.00
$36,000.00
$0.00
$36,000.00
$1,589.69
$0.00
$83,875.75
($47,875.75)
233%
$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.56
.00
492,187.43
281,148.57
64
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
794.53
.00
33,179.65
(8,179.65)
133
28,729.30
Run by Colleen Thornton on 02/21/2018 02:32:35 PM
Page 8 of 27
Budget Performance Report Fiscal Year to Date 01/31/18 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,023.44
.00
32,177.45
17,319.55
65
47,859.97
2001
Medicare
11,576.00
.00
11,576.00
707.09
.00
7,569.39
4,006.61
65
11,230.53
2010
IMRF
5,534.00
.00
5,534.00
406.18
.00
5,005.63
528.37
90
49,461.85
2020
Employee Insurance
141,293.00
.00
141,293.00
9,448.51
.00
91,999.86
49,293.14
65
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
45.00
.00
10,243.42
1,436.58
88
10,133.37
780.00
.00
780.00
121.08
.00
1,293.65
(513.65)
166
1,593.21
6,744.00
.00
6,744.00
221.57
.00
1,811.97
4,932.03
27
2,758.96
3,400.00
.00
3,400.00
30.00
.00
1,005.97
2,394.03
30
2,897.50
Replacement Supplies
5,200.00
.00
5,200.00
.00
.00
282.22
4,917.78
5
751.72
5015
Dues & Subscriptions
1,900.00
.00
1,900.00
95.00
.00
135.00
1,765.00
7
1,903.67
5020
Gas/Oil/Mileage/Carwash
16,000.00
.00
16,000.00
24.63
.00
5,172.56
10,827.44
32
14,877.92
5095
Uniforms/Clothing
5,500.00
.00
5,500.00
.00
.00
5,637.89
(137.89)
103
5,956.72
5115.002
Community Programs
8,200.00
.00
8,200.00
.00
.00
3,854.84
4,345.16
47
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
1,821.62
3,463.39
19,514.99
21
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
153.00
.00
2,699.64
11,300.36
19
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
13,500.00
(3,500.00)
135
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
$64,847.59
$1,821.62
$712,066.24
$424,432.14
63%
$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
96,880.07
27,119.93
78
121,358.68
1015
Salaries-Part Time
47,410.00
.00
47,410.00
1,690.51
.00
18,353.01
29,056.99
39
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
672.73
.00
6,892.94
3,655.06
65
9,694.79
2001
Medicare
2,467.00
.00
2,467.00
157.33
.00
1,612.06
854.94
65
2,267.33
2010
IMRF
20,415.00
.00
20,415.00
1,264.76
.00
12,838.17
7,576.83
63
18,053.80
2020
Employee Insurance
43,998.00
.00
43,998.00
3,079.67
.00
31,137.29
12,860.71
71
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
167.89
2,832.11
6
161.00
4000
Telephone/Internet
605.00
.00
605.00
94.16
.00
998.99
(393.99)
165
1,282.91
5005
Office Supplies/Postage
10,000.00
.00
10,000.00
871.93
.00
4,654.77
5,345.23
47
8,745.16
5015
Dues & Subscriptions
9,000.00
.00
9,000.00
647.93
.00
6,018.51
2,981.49
67
8,151.47
5095
Uniforms/Clothing
900.00
.00
900.00
.00
.00
294.35
605.65
33
563.88
Run by Colleen Thornton on 02/21/2018 02:32:35 PM
Page 9 of 27
Budget Performance Report Fiscal Year to Date 01/31/18 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
160.00
.00
1,280.00
640.00
67
27,500.00
.00
27,500.00
.00
.00
12,189.00
15,311.00
44
8,405.05
$308,263.00
$0.00
$308,263.00
$18,332.33
$0.00
$193,427.39
$114,835.61
63%
$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
3,982.48
.00
103,801.82
3,978.18
96
13,396.15
Division 91 - Capital Totals
$118,780.00
$0.00
$118,780.00
$3,982.48
$0.00
$103,801.82
$14,978.18
87%
$19,260.06
13,700.00
.00
13,700.00
522.75
.00
7,958.84
5,741.16
58
13,887.78
Division 93 - Contingencies Totals
$13,700.00
$0.00
$13,700.00
$522.75
$0.00
$7,958.84
$5,741.16
58%
$13,887.78
Unit 05 - Police Department Totals
$12,300,040.00
$0.00
$12,300,040.00
$733,031.14
$18,483.05
$9,091,131.86
$3,190,425.09
74%
$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
98,949.74
32,250.26
75
124,512.43
2000
FICA
7,750.00
.00
7,750.00
572.60
.00
5,966.84
1,783.16
77
7,126.33
2001
Medicare
1,813.00
.00
1,813.00
133.92
.00
1,395.47
417.53
77
1,789.90
2020
Employee Insurance
24,336.00
.00
24,336.00
1,615.65
.00
15,845.04
8,490.96
65
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
.00
.00
700.48
3,299.52
18
571.80
4000
Telephone/Internet
5,400.00
.00
5,400.00
461.70
.00
4,923.35
476.65
91
5,346.74
4005
Cellular Phones/Pagers
5,200.00
.00
5,200.00
101.88
.00
1,860.89
3,339.11
36
3,450.61
5005
Office Supplies/Postage
1,300.00
.00
1,300.00
.00
.00
45.86
1,254.14
4
302.76
5010
Replacement Supplies
11,000.00
.00
11,000.00
.00
.00
1,572.79
9,427.21
14
1,472.80
5015
Dues & Subscriptions
5020
Gas/Oil/Mileage/Carwash
5040
4,000.00
.00
4,000.00
.00
.00
1,954.32
2,045.68
49
1,909.57
12,000.00
.00
12,000.00
11.48
.00
3,911.99
8,088.01
33
5,235.57
Supplies/Hardware
2,000.00
.00
2,000.00
69.71
.00
554.50
1,445.50
28
181.75
5040.001
Supplies/Hardware-ESDA
2,000.00
.00
2,000.00
251.98
.00
343.67
1,656.33
17
616.99
5095
Uniforms/Clothing
5,000.00
.00
5,000.00
.00
.00
1,746.10
3,253.90
35
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
.00
.00
907.36
14,092.64
6
7,175.99
8020
Building Maintenance
5,000.00
.00
5,000.00
.00
.00
783.36
4,216.64
16
.00
8035
Maintenance Contracts/Lease
1,800.00
.00
1,800.00
100.00
.00
895.02
904.98
50
1,311.79
8060
Vehicle Maintenance
15,000.00
.00
15,000.00
3,156.25
.00
12,189.76
2,810.24
81
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
.00
.00
7,580.28
12,419.72
38
9,555.57
Run by Colleen Thornton on 02/21/2018 02:32:35 PM
Page 10 of 27
Budget Performance Report Fiscal Year to Date 01/31/18 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
.00
.00
1,315.00
3,935.00
25
740.00
8280
Cadet Program
5,500.00
.00
5,500.00
.00
.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
173.99
.00
173.99
1,826.01
9
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
.00
.00
1,305.07
1,694.93
44
1,160.09
Division 07 - PEMA Program Totals
$312,799.00
$0.00
$312,799.00
$16,169.00
$0.00
$166,481.76
$146,317.24
53%
$226,615.29
Unit 07 - PEMA Totals
$312,799.00
$0.00
$312,799.00
$16,169.00
$0.00
$166,481.76
$146,317.24
53%
$226,615.29
288,000.00
.00
288,000.00
21,836.53
.00
218,421.51
69,578.49
76
272,912.32
18,000.00
.00
18,000.00
1,401.88
.00
13,368.68
4,631.32
74
16,762.99
4,200.00
.00
4,200.00
327.85
.00
3,238.11
961.89
77
4,078.42
Unit 08 - Street Department Division 02 - Administration Program 1005
Salaries-Full Time
2000
FICA
2001
Medicare
2010
IMRF
33,000.00
.00
33,000.00
2,588.54
.00
25,132.86
7,867.14
76
31,772.74
2020
Employee Insurance
59,500.00
.00
59,500.00
4,362.13
.00
42,970.19
16,529.81
72
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
.00
.00
6,116.93
3,883.07
61
9,710.16
3015
IL Unemployment Insurance
4,000.00
.00
4,000.00
.00
.00
2,336.95
1,663.05
58
3,651.67
4000
Telephone/Internet
19,000.00
.00
19,000.00
2,211.24
.00
20,400.86
(1,400.86)
107
22,890.54
4005
Cellular Phones/Pagers
8,500.00
.00
8,500.00
628.02
.00
5,182.05
3,317.95
61
7,348.00
5005
Office Supplies/Postage
2,500.00
.00
2,500.00
301.18
.00
2,092.41
407.59
84
3,583.27
5015
Dues & Subscriptions
3,000.00
.00
3,000.00
.00
.00
1,737.53
1,262.47
58
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
486.34
.00
6,547.51
13,452.49
33
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
$34,143.71
$0.00
$347,745.58
$132,354.42
72%
$442,804.96 721,757.32
Division 60 - Street Maintenance Program 1005
Salaries-Full Time
810,000.00
.00
810,000.00
59,931.58
.00
604,279.09
205,720.91
75
1015
Salaries-Part Time
75,000.00
.00
75,000.00
.00
.00
77,016.35
(2,016.35)
103
62,433.19
1800
Salaries-Overtime
85,000.00
.00
85,000.00
23,743.54
.00
92,595.39
(7,595.39)
109
106,835.87
2000
FICA
59,000.00
.00
59,000.00
4,781.59
.00
45,555.31
13,444.69
77
52,747.13
2001
Medicare
14,000.00
.00
14,000.00
1,118.27
.00
10,654.09
3,345.91
76
12,335.88
2010
IMRF
94,000.00
.00
94,000.00
8,838.69
.00
76,078.39
17,921.61
81
91,864.26
2020
Employee Insurance
193,000.00
.00
193,000.00
15,436.80
.00
150,064.91
42,935.09
78
173,326.22
2025
Deferred Comp. Contribution
20,000.00
.00
20,000.00
.00
.00
.00
20,000.00
0
21,869.39
Run by Colleen Thornton on 02/21/2018 02:32:35 PM
Page 11 of 27
Budget Performance Report Fiscal Year to Date 01/31/18 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 4015
Electricity/Gas
290,000.00
.00
290,000.00
1,498.91
.00
94,210.78
195,789.22
32
257,109.86
5020
Gas/Oil/Mileage/Carwash
70,000.00
.00
70,000.00
29.53
.00
11,580.85
58,419.15
17
53,294.62
5040
Supplies/Hardware
15,000.00
.00
15,000.00
947.45
.00
7,396.76
7,603.24
49
11,680.86
5040.003
Supplies/Hardware-Salt Purchase
280,000.00
.00
280,000.00
92,873.70
.00
92,873.70
187,126.30
33
232,040.61
5055
Street Sign Maintenance
25,000.00
.00
25,000.00
3,305.65
.00
27,615.13
(2,615.13)
110
29,485.95
5060
Aggregate Materials
4,000.00
.00
4,000.00
692.36
.00
4,464.47
(464.47)
112
5,239.80
5095
Uniforms/Clothing
10,000.00
.00
10,000.00
606.14
.00
5,646.92
4,353.08
56
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
2,616.22
.00
20,231.28
14,768.72
58
25,636.77
95,000.00
.00
95,000.00
10,905.30
.00
54,357.16
40,642.84
57
113,358.45
130,000.00
.00
130,000.00
4,029.32
.00
18,997.38
111,002.62
15
115,168.49
Storm Sewer Improvements
10,000.00
.00
10,000.00
.00
.00
11,414.18
(1,414.18)
114
1,490.85
8135
Contractual Services
90,000.00
.00
90,000.00
3,230.75
.00
61,631.61
28,368.39
68
108,462.32
8135.004
Snow Removal
280,000.00
.00
280,000.00
46,839.50
.00
46,839.50
233,160.50
17
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
12,100.54
.00
47,290.67
47,709.33
50
77,487.55
$2,789,000.00
$0.00
$2,789,000.00
$293,525.84
$0.00
$1,560,793.92
$1,228,206.08
56%
$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,544.55
.00
54,963.39
23,036.61
70
49,732.95
1800
Salaries-Overtime
6,000.00
.00
6,000.00
.00
.00
5,945.17
54.83
99
6,677.22
2000
FICA
5,500.00
.00
5,500.00
495.82
.00
3,888.69
1,611.31
71
3,634.67
2001
Medicare
1,300.00
.00
1,300.00
115.96
.00
909.46
390.54
70
850.03
2010
IMRF
9,000.00
.00
9,000.00
911.10
.00
7,183.02
1,816.98
80
6,753.55
2020
Employee Insurance
17,000.00
.00
17,000.00
1,062.14
.00
11,205.60
5,794.40
66
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
686.27
.00
5,710.91
2,289.09
71
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
120.00
.00
10,716.59
(5,716.59)
214
3,911.55
8135.002
Tree Removal Division 62 - Forestry Program Totals
45,000.00
.00
45,000.00
.00
.00
11,008.50
33,991.50
24
11,865.00
$178,300.00
$0.00
$178,300.00
$8,935.84
$0.00
$111,531.33
$66,768.67
63%
$103,094.78 186,524.95
Division 63 - Vehicle Maintenance Program 1005
Salaries-Full Time
193,000.00
.00
193,000.00
14,764.51
.00
147,359.76
45,640.24
76
1800
Salaries-Overtime
8,000.00
.00
8,000.00
1,636.44
.00
6,360.60
1,639.40
80
3,205.27
2000
FICA
12,500.00
.00
12,500.00
970.31
.00
9,078.75
3,421.25
73
11,275.14
2001
Medicare
3,000.00
.00
3,000.00
226.93
.00
2,123.23
876.77
71
2,636.92
2010
IMRF
22,000.00
.00
22,000.00
1,822.15
.00
17,050.81
4,949.19
78
21,386.55
2020
Employee Insurance
40,500.00
.00
40,500.00
3,039.00
.00
30,120.72
10,379.28
74
37,236.34
Run by Colleen Thornton on 02/21/2018 02:32:35 PM
Page 12 of 27
Budget Performance Report Fiscal Year to Date 01/31/18 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 63 - Vehicle Maintenance Program 2025
7,500.00
.00
7,500.00
.00
.00
.00
7,500.00
0
6,216.05
Division 63 - Vehicle Maintenance Program Totals
Deferred Comp. Contribution
$286,500.00
$0.00
$286,500.00
$22,459.34
$0.00
$212,093.87
$74,406.13
74%
$268,481.22
Unit 08 - Street Department Totals
$3,733,900.00
$0.00
$3,733,900.00
$359,064.73
$0.00
$2,232,164.70
$1,501,735.30
60%
$3,271,155.94
Unit 09 - Community Development Division 20 - Planning Program 1005
Salaries-Full Time
315,000.00
.00
315,000.00
26,159.48
.00
260,910.43
54,089.57
83
283,526.27
1045
Salaries-Commissioner
4,000.00
.00
4,000.00
130.00
.00
1,990.00
2,010.00
50
2,845.00
1800
Salaries-Overtime
2,500.00
.00
2,500.00
.00
.00
1,683.51
816.49
67
2,460.20
2000
FICA
20,000.00
.00
20,000.00
1,582.68
.00
15,975.25
4,024.75
80
17,019.71
2001
Medicare
4,700.00
.00
4,700.00
370.14
.00
3,736.11
963.89
79
3,980.48
2010
IMRF
35,000.00
.00
35,000.00
2,906.32
.00
29,174.54
5,825.46
83
31,198.33
2020
Employee Insurance
70,500.00
.00
70,500.00
5,854.05
.00
58,253.56
12,246.44
83
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
615.00
.00
3,675.64
3,324.36
53
2,567.00
3015
IL Unemployment Insurance
1,000.00
.00
1,000.00
.00
.00
406.91
593.09
41
639.03
4000
Telephone/Internet
3,000.00
.00
3,000.00
172.54
.00
1,815.70
1,184.30
61
2,047.16
4005
Cellular Phones/Pagers
1,800.00
.00
1,800.00
72.98
.00
583.83
1,216.17
32
1,166.60
5005
Office Supplies/Postage
10,500.00
.00
10,500.00
1,035.95
.00
9,598.49
901.51
91
11,811.79
5015
Dues & Subscriptions
3,000.00
.00
3,000.00
605.00
.00
4,791.67
(1,791.67)
160
3,393.54
5020
Gas/Oil/Mileage/Carwash
750.00
.00
750.00
.00
.00
47.60
702.40
6
.00
8035
Maintenance Contracts/Lease
3,500.00
.00
3,500.00
50.00
.00
400.00
3,100.00
11
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
78.50
.00
2,566.93
2,433.07
51
2,354.00
8097
Special Projects and Programs
15,000.00
.00
15,000.00
.00
.00
15,150.09
(150.09)
101
3,709.27
8135
Contractual Services
35,000.00
.00
35,000.00
.00
.00
1,919.00
33,081.00
5
1,691.84
8225
Engineering Fees
10,000.00
.00
10,000.00
.00
.00
4,108.75
5,891.25
41
4,446.24
$560,750.00
$0.00
$560,750.00
$39,632.64
$0.00
$416,788.01
$143,961.99
74%
$430,572.70
Division 20 - Planning Program Totals Division 21 - Building Program 1005
Salaries-Full Time
633,000.00
.00
633,000.00
44,466.17
.00
446,560.78
186,439.22
71
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
129.81
.00
609.37
4,390.63
12
141.22
2000
FICA
39,800.00
.00
39,800.00
2,652.45
.00
26,670.60
13,129.40
67
26,488.50
2001
Medicare
2010
IMRF
2020
Employee Insurance
2025
Deferred Comp. Contribution
3000
Travel/Training
Run by Colleen Thornton on 02/21/2018 02:32:35 PM
9,300.00
.00
9,300.00
620.34
.00
6,237.50
3,062.50
67
6,194.87
70,000.00
.00
70,000.00
4,965.74
.00
49,744.36
20,255.64
71
49,417.95
157,000.00
.00
157,000.00
11,893.97
.00
113,445.63
43,554.37
72
97,663.77
7,000.00
.00
7,000.00
.00
.00
.00
7,000.00
0
8,256.62
7,500.00
.00
7,500.00
61.39
.00
9,336.69
(1,836.69)
124
8,511.01
Page 13 of 27
Budget Performance Report Fiscal Year to Date 01/31/18 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,000.00
Fund 01 - General Fund EXPENSE Unit 09 - Community Development Division 21 - Building Program 3015
IL Unemployment Insurance
1,500.00
.00
1,500.00
.00
.00
795.90
704.10
53
4000
Telephone/Internet
1,500.00
.00
1,500.00
34.50
.00
420.87
1,079.13
28
409.44
4005
Cellular Phones/Pagers
6,000.00
.00
6,000.00
311.54
.00
2,490.75
3,509.25
42
3,500.04
5005
Office Supplies/Postage
13,000.00
.00
13,000.00
393.55
12.68
6,279.21
6,708.11
48
7,111.69
5015
Dues & Subscriptions
4,000.00
.00
4,000.00
145.00
.00
199.00
3,801.00
5
520.00
5020
Gas/Oil/Mileage/Carwash
1,000.00
.00
1,000.00
152.61
.00
767.39
232.61
77
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
.00
.00
1,529.00
(1,529.00)
+++
.00
46,500.00
.00
46,500.00
.00
.00
1,445.50
45,054.50
3
7,589.70
Division 21 - Building Program Totals
$1,008,000.00
$0.00
$1,008,000.00
$65,827.07
$12.68
$666,682.55
$341,304.77
66%
$655,541.31
Unit 09 - Community Development Totals
$1,568,750.00
$0.00
$1,568,750.00
$105,459.71
$12.68
$1,083,470.56
$485,266.76
69%
$1,086,114.01
5,500.00
.00
5,500.00
104.35
.00
1,363.28
4,136.72
25
681.34
341.00
.00
341.00
6.47
.00
84.53
256.47
25
35.36
80.00
.00
80.00
1.51
.00
19.76
60.24
25
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
375.00
225.00
62
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00
0
.00
10,000.00
.00
10,000.00
2,502.00
.00
7,873.50
2,126.50
79
8,037.55
Division 02 - Administration Program Totals
$20,521.00
$0.00
$20,521.00
$2,614.33
$0.00
$10,182.23
$10,338.77
50%
$9,270.33
Unit 50 - Police Commission Totals
$20,521.00
$0.00
$20,521.00
$2,614.33
$0.00
$10,182.23
$10,338.77
50%
$9,270.33
EXPENSE TOTALS
$24,784,315.00
$0.00
$24,784,315.00
$1,760,525.61
$32,948.83
$17,169,455.42
$7,581,910.75
69%
$24,076,613.56
REVENUE TOTALS
24,784,315.00
.00
24,784,315.00
1,543,365.65
.00
21,226,763.60
3,557,551.40
86%
24,282,991.21
EXPENSE TOTALS
24,784,315.00
.00
24,784,315.00
1,760,525.61
32,948.83
17,169,455.42
7,581,910.75
69%
24,076,613.56
Fund 01 - General Fund Totals
$0.00
$0.00
$0.00
($217,159.96)
($32,948.83)
$4,057,308.18
($4,024,359.35)
1,775,000.00
.00
1,775,000.00
148,371.32
.00
1,324,366.06
450,633.94
75
35,000.00
.00
35,000.00
2,210.00
.00
15,180.00
19,820.00
43
52,325.00
115
446,840.00 427,123.50
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
13,374.25
.00
323,233.03
(43,233.03)
0570.852
Sewer Connection Fee
280,000.00
.00
280,000.00
12,335.00
.00
214,851.50
65,148.50
77
0570.859
Sewer By-Pass Fee
8,000.00
.00
8,000.00
1,075.00
.00
8,385.00
(385.00)
105
12,040.00
0620.672
Water Sales
9,350,000.00
.00
9,350,000.00
685,404.44
.00
7,894,607.35
1,455,392.65
84
9,316,320.32
Run by Colleen Thornton on 02/21/2018 02:32:35 PM
1,745,967.81
Page 14 of 27
Budget Performance Report Fiscal Year to Date 01/31/18 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 REVENUE 0620.673
Water Penalty
0620.674
Sewer Sales
85,000.00
.00
85,000.00
7,636.07
.00
81,829.32
3,170.68
96
100,004.20
4,250,000.00
.00
4,250,000.00
324,163.16
.00
3,489,538.24
760,461.76
82
4,335,795.38
0620.675 0620.676
Sewer Penalty
45,000.00
.00
45,000.00
3,514.83
.00
36,780.59
8,219.41
82
47,432.36
Capital Charge
1,130,000.00
.00
1,130,000.00
88,701.19
.00
946,344.82
183,655.18
84
1,204,238.08
0620.677 0800.800
Capital Charge Penalty
15,000.00
.00
15,000.00
1,148.03
.00
10,466.46
4,533.54
70
15,006.20
Interest Income
24,382.00
.00
24,382.00
5,186.19
.00
49,918.80
(25,536.80)
205
0800.827
44,480.79
Unrealized Gain/Loss
.00
.00
.00
.00
.00
(5,233.72)
5,233.72
+++
(3,038.26)
0800.830
Unrealized Gain/Loss IMET
.00
.00
.00
(10,821.97)
.00
(12,261.68)
12,261.68
+++
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
468.00
.00
2,473.00
(1,973.00)
495
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
.00
.00
31,218.93
(6,218.93)
125
22,796.09
$17,302,882.00
$0.00
$17,302,882.00
$1,282,765.51
$0.00
$14,416,318.60
$2,886,563.40
83%
$18,177,763.03
245,000.00
.00
245,000.00
21,493.48
.00
213,684.67
31,315.33
87
236,158.35
15,200.00
.00
15,200.00
1,376.33
.00
13,013.19
2,186.81
86
14,288.25
3,600.00
.00
3,600.00
321.91
.00
3,124.89
475.11
87
3,456.90
87
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,524.58
.00
24,480.63
3,519.37
2020
Employee Insurance
46,000.00
.00
46,000.00
3,673.60
.00
36,144.46
9,855.54
79
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
152.00
.00
2,554.13
4,445.87
36
2,707.65
3015
IL Unemployment Insurance
2,500.00
.00
2,500.00
.00
.00
784.93
1,715.07
31
1,705.58
4000
Telephone/Internet
5,600.00
.00
5,600.00
472.24
.00
4,668.78
931.22
83
4,665.28
4005
Cellular Phones/Pagers
3,000.00
.00
3,000.00
315.58
.00
2,681.20
318.80
89
4,152.66
5005
Office Supplies/Postage
26,000.00
.00
26,000.00
2,650.86
.00
22,112.24
3,887.76
85
33,547.92
5015
Dues & Subscriptions
1,400.00
.00
1,400.00
83.00
.00
496.90
903.10
35
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
34.80
4.23
1,020.13
(524.36)
205
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 8135.008
800.00
.00
800.00
351.49
.00
423.99
376.01
53
1,384.07
150,000.00
.00
150,000.00
4,159.50
.00
47,657.03
102,342.97
32
131,727.54
8,000.00
.00
8,000.00
431.79
.00
8,586.80
(586.80)
107
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
Contractual Services
27,000.00
.00
27,000.00
2,538.77
.00
17,081.16
9,918.84
63
42,194.59
Settlement Charges
.00
.00
.00
.12
.00
.12
(.12)
+++
.00
Run by Colleen Thornton on 02/21/2018 02:32:35 PM
Page 15 of 27
Budget Performance Report Fiscal Year to Date 01/31/18 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
139.64
360.36
28
4,000.00
.00
4,000.00
2,042.76
.00
7,341.33
(3,341.33)
184
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
62,500.00
62,500.00
50
125,000.00
Transfer to Debt Service
244,825.00
.00
244,825.00
.00
.00
244,825.00
.00
100
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
$42,622.81
$4.23
$713,397.22
$244,523.55
74%
$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.27
.00
244,596.77
165,403.23
60
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
6,974.24
.00
32,609.52
2,390.48
93
31,515.55
2000
FICA
29,000.00
.00
29,000.00
1,844.75
.00
16,894.19
12,105.81
58
26,731.62
2001
Medicare
6,800.00
.00
6,800.00
431.44
.00
3,984.80
2,815.20
59
6,299.58
2010
IMRF
53,000.00
.00
53,000.00
3,376.18
.00
30,175.20
22,824.80
57
47,881.94
2020
Employee Insurance
70,975.00
.00
70,975.00
4,638.89
.00
44,440.01
26,534.99
63
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
734.59
.00
7,506.34
1,493.66
83
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
9,281.31
.00
51,527.82
88,472.18
37
123,565.62
5005
Office Supplies/Postage
2,000.00
.00
2,000.00
.00
.00
154.79
1,845.21
8
199.91
5010
Replacement Supplies
5,000.00
.00
5,000.00
24.37
.00
2,961.13
2,038.87
59
7,017.40
5020
Gas/Oil/Mileage/Carwash
15,000.00
.00
15,000.00
753.95
.00
7,683.14
7,316.86
51
8,602.27
5040
Supplies/Hardware
4,000.00
.00
4,000.00
797.03
.00
6,858.40
(2,858.40)
171
5,485.05
5070
Chemicals
5,500.00
.00
5,500.00
.00
.00
4,149.38
1,350.62
75
5,379.54
5095
Uniforms/Clothing
2,000.00
.00
2,000.00
131.35
.00
1,331.24
668.76
67
5,327.56
8020
Building Maintenance
4,000.00
.00
4,000.00
72.75
.00
404.32
3,595.68
10
2,772.26
8060
Vehicle Maintenance
6,500.00
.00
6,500.00
.00
.00
3,458.42
3,041.58
53
6,089.99
8135
Contractual Services
40,000.00
.00
40,000.00
11,038.59
7,071.90
25,140.86
7,787.24
81
53,499.34
8135.003
Lake Michigan Water Purchase
8,403,000.00
.00
8,403,000.00
.00
.00
5,762,634.88
2,640,365.12
69
8,471,988.46
8160
Equipment Maintenance
9,000.00
.00
9,000.00
1,936.85
.00
11,199.66
(2,199.66)
124
12,096.38
8185
System Maintenance
44,000.00
.00
44,000.00
2,034.00
4,964.28
5,468.24
33,567.48
24
49,419.05
8194
Water/Fire Hydrant
20,000.00
.00
20,000.00
.00
.00
18,977.27
1,022.73
95
19,074.73
8200
EPA Analytical
16,000.00
.00
16,000.00
.00
.00
9,961.37
6,038.63
62
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 02/21/2018 02:32:35 PM
244,825.00
.00
244,825.00
.00
.00
244,825.00
.00
100
242,725.00
$9,604,100.00
$0.00
$9,604,100.00
$68,564.56
$12,036.18
$6,545,702.33
$3,046,361.49
68%
$8,295,068.12
Page 16 of 27
Budget Performance Report Fiscal Year to Date 01/31/18 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
$111,187.37
$12,040.41
$7,259,099.55
$3,290,885.04
69%
$12,358,091.95
245,000.00
.00
245,000.00
18,335.10
.00
183,559.77
61,440.23
75
235,196.83
15,200.00
.00
15,200.00
1,173.50
.00
11,132.61
4,067.39
73
14,291.42
3,600.00
.00
3,600.00
274.43
.00
2,684.56
915.44
75
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,154.06
.00
21,033.33
6,966.67
75
27,356.16
2020
Employee Insurance
46,000.00
.00
46,000.00
2,910.98
.00
28,896.05
17,103.95
63
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
.00
.00
4,969.13
7,030.87
41
5,191.84
3015
IL Unemployment Insurance
2,500.00
.00
2,500.00
.00
.00
522.92
1,977.08
21
1,705.54
4000
Telephone/Internet
9,000.00
.00
9,000.00
734.59
.00
8,844.61
155.39
98
11,908.89
4005
Cellular Phones/Pagers
3,500.00
.00
3,500.00
184.62
.00
1,751.12
1,748.88
50
2,973.50
5005
Office Supplies/Postage
25,000.00
.00
25,000.00
2,803.66
.00
21,042.92
3,957.08
84
31,332.15
5015
Dues & Subscriptions
68,200.00
.00
68,200.00
.00
.00
64,376.89
3,823.11
94
60,535.73
5020
Gas/Oil/Mileage/Carwash
1,000.00
.00
1,000.00
.00
.00
30.00
970.00
3
299.18
5040
Supplies/Hardware
2,500.00
.00
2,500.00
403.17
4.23
1,026.93
1,468.84
41
510.72
8020
Building Maintenance
15,000.00
.00
15,000.00
598.17
.00
11,215.62
3,784.38
75
17,449.12
8065
Legal Fees
8135
Contractual Services
8135.008
Settlement Charges
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,074.25
.00
13,362.37
16,637.63
45
39,619.85 .00
.00
.00
.00
.12
.00
.12
(.12)
+++
2,000.00
.00
2,000.00
360.44
.00
952.43
1,047.57
48
.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
384,000.00
(344,160.00)
964
340,500.00
2013 Refunding-2004A Bond (Interest)
384,000.00
.00
384,000.00
.00
.00
39,840.00
344,160.00
10
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
62,500.00
62,500.00
50
125,000.00
9905
Transfer to Debt Service
244,825.00
.00
244,825.00
.00
.00
244,825.00
.00
100
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
$31,007.09
$4.23
$1,107,206.46
$216,454.31
84%
$1,280,217.34
Division 02 - Administration Program Totals
Run by Colleen Thornton on 02/21/2018 02:32:35 PM
Page 17 of 27
Budget Performance Report Fiscal Year to Date 01/31/18 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 1005
Salaries-Full Time
385,000.00
.00
385,000.00
28,071.29
.00
285,647.23
99,352.77
74
410,779.62
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
5,282.23
.00
23,823.98
6,176.02
79
26,852.08
2000
FICA
26,500.00
.00
26,500.00
1,953.79
.00
18,862.43
7,637.57
71
27,242.55
2001
Medicare
6,500.00
.00
6,500.00
456.89
.00
4,441.75
2,058.25
68
6,414.31
2010
IMRF
46,000.00
.00
46,000.00
3,594.08
.00
33,759.21
12,240.79
73
48,877.78
2020
Employee Insurance
56,000.00
.00
56,000.00
4,053.62
.00
40,445.83
15,554.17
72
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,784.00
.00
18,570.83
3,429.17
84
19,797.10
4015
Electricity/Gas
525,000.00
.00
525,000.00
37,213.58
.00
305,298.58
219,701.42
58
519,785.43
5005
Office Supplies/Postage
4,500.00
.00
4,500.00
.00
.00
362.60
4,137.40
8
841.27
5010
Replacement Supplies
1,500.00
.00
1,500.00
47.58
.00
2,445.77
(945.77)
163
2,084.97
5020
Gas/Oil/Mileage/Carwash
13,000.00
.00
13,000.00
29.55
.00
7,292.37
5,707.63
56
8,249.45
5040
Supplies/Hardware
10,000.00
.00
10,000.00
473.86
.00
7,196.68
2,803.32
72
10,856.84
5070
Chemicals
115,000.00
.00
115,000.00
10,323.17
4,081.83
64,283.95
46,634.22
59
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
72.00
.00
1,606.50
16,393.50
9
1,971.00
5095
Uniforms/Clothing
5,000.00
.00
5,000.00
348.95
.00
3,496.17
1,503.83
70
8,908.79
8060
Vehicle Maintenance
8,000.00
.00
8,000.00
.00
.00
9,076.45
(1,076.45)
113
3,473.22
8135
Contractual Services
160,000.00
.00
160,000.00
51,326.60
.00
118,426.54
41,573.46
74
214,685.35
8160
Equipment Maintenance
20,000.00
.00
20,000.00
2,289.18
.00
16,082.92
3,917.08
80
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
3,985.29
.00
22,042.48
102,957.52
18
55,506.10
9905
Transfer to Debt Service
244,825.00
.00
244,825.00
.00
.00
244,825.00
.00
100
242,725.00
Division 40 - Sewer Treatment Program Totals
$1,850,825.00
$0.00
$1,850,825.00
$151,305.66
$4,081.83
$1,236,746.83
$609,996.34
67%
$1,838,136.11
Unit 11 - Sewer Department Totals
$3,174,490.00
$0.00
$3,174,490.00
$182,312.75
$4,086.06
$2,343,953.29
$826,450.65
74%
$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
88,133.61
11,866.39
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
175.00
.00
202,398.75
(202,398.75)
+++
56,524.82
8135
Contractual Services
210,000.00
.00
210,000.00
.00
.00
13,918.00
196,082.00
7
.00
8225
Engineering Fees
150,000.00
.00
150,000.00
30,628.72
.00
85,118.08
64,881.92
57
40,152.25
9120
Machinery and Equipment
.00
.00
.00
.00
.00
5,996.80
(5,996.80)
+++
12,894.14
9125
Vehicles
180,000.00
.00
180,000.00
.00
.00
156,835.00
23,165.00
87
.00
Run by Colleen Thornton on 02/21/2018 02:32:35 PM
Page 18 of 27
Budget Performance Report Fiscal Year to Date 01/31/18 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
$830,000.00
$0.00
$830,000.00
$30,803.72
$0.00
$552,400.24
$277,599.76
67%
$1,402,943.55
Fund 02 - Water and Sewer Fund EXPENSE Unit 12 - Utility Expansion Division 91 - Capital Totals Division 92 - Bonds 9200.012
2013 Refunding-2004A Bond (Principal)
896,000.00
.00
896,000.00
.00
.00
896,000.00
.00
100
794,500.00
9200.013
2013 Refunding-2004A Bond (Interest)
92,960.00
.00
92,960.00
.00
.00
92,960.00
.00
100
100,337.50
9200.014
2013 Refunding-2004B Bond (Principal)
375,000.00
.00
375,000.00
.00
.00
375,000.00
.00
100
365,000.00
9200.015
2013 Refunding-2004B Bond (Interest)
38,650.00
.00
38,650.00
.00
.00
38,650.00
.00
100
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
.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
.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
157,419.46
999.54
99
155,470.01
9201.002
IEPA Loan (Interest)
30,588.00
.00
30,588.00
.00
.00
30,587.64
.36
100
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
$0.00
$0.00
$1,867,992.10
$868,374.90
68%
$415,530.68
Unit 12 - Utility Expansion Totals
$3,566,367.00
$0.00
$3,566,367.00
$30,803.72
$0.00
$2,420,392.34
$1,145,974.66
68%
$1,818,474.23
EXPENSE TOTALS
$17,302,882.00
$0.00
$17,302,882.00
$324,303.84
$16,126.47
$12,023,445.18
$5,263,310.35
70%
$17,294,919.63
REVENUE TOTALS
17,302,882.00
.00
17,302,882.00
1,282,765.51
.00
14,416,318.60
2,886,563.40
83%
18,177,763.03
EXPENSE TOTALS
17,302,882.00
.00
17,302,882.00
324,303.84
16,126.47
12,023,445.18
5,263,310.35
70%
17,294,919.63
Fund 02 - Water and Sewer Fund Totals
$0.00
$0.00
$0.00
$958,461.67
($16,126.47)
$2,392,873.42
($2,376,746.95)
Fund 02 - Water and Sewer Fund Totals
$882,843.40
Fund 03 - Capital Replacement Fund REVENUE 0800.800
Interest Income
.00
.00
.00
2,137.84
.00
20,793.76
(20,793.76)
+++
0800.826
Realized Gain/Loss On Investment
.00
.00
.00
.00
.00
.00
.00
+++
12.64
0800.827
Unrealized Gain/Loss
.00
.00
.00
.00
.00
(2,536.51)
2,536.51
+++
(9,699.66)
$0.00
$0.00
$0.00
$2,137.84
$0.00
$18,257.25
($18,257.25)
+++
$14,602.22
REVENUE TOTALS
.00
.00
.00
2,137.84
.00
18,257.25
(18,257.25)
+++
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,137.84
$0.00
$18,257.25
($18,257.25)
1,150,000.00
.00
1,150,000.00
87,460.07
.00
812,761.95
337,238.05
71
1,105,593.51
5,000.00
.00
5,000.00
3,167.76
.00
26,821.85
(21,821.85)
536
15,410.91
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
Run by Colleen Thornton on 02/21/2018 02:32:35 PM
Page 19 of 27
Budget Performance Report Fiscal Year to Date 01/31/18 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
$1,155,000.00
$0.00
$1,155,000.00
$90,627.83
$0.00
$839,583.80
$315,416.20
73%
$1,121,004.42
1,005,000.00
.00
1,005,000.00
4,556.52
.00
1,038,056.85
(33,056.85)
103
863,120.29
Division 91 - Capital Totals
$1,005,000.00
$0.00
$1,005,000.00
$4,556.52
$0.00
$1,038,056.85
($33,056.85)
103%
$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
$4,556.52
$0.00
$1,038,056.85
$116,943.15
90%
$863,120.29
EXPENSE TOTALS
$1,155,000.00
$0.00
$1,155,000.00
$4,556.52
$0.00
$1,038,056.85
$116,943.15
90%
$863,120.29
REVENUE TOTALS
1,155,000.00
.00
1,155,000.00
90,627.83
.00
839,583.80
315,416.20
73%
1,121,004.42
EXPENSE TOTALS
1,155,000.00
.00
1,155,000.00
4,556.52
.00
1,038,056.85
116,943.15
90%
Fund 04 - Motor Fuel Tax Totals
$0.00
$0.00
$0.00
$86,071.31
$0.00
($198,473.05)
$198,473.05
112,600.00
.00
112,600.00
.00
.00
118,518.93
(5,918.93)
105
500.00
.00
500.00
2.48
.00
6,279.45
(5,779.45)
1256
797.83
979,300.00
.00
979,300.00
.00
.00
979,300.00
.00
100
970,900.00
Account Description
Budget - YTD % Used/
Fund 04 - Motor Fuel Tax EXPENSE Unit 00 - Non-Departmental Division 91 - Capital 9150
Street Improvements 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
2,023,992.04
12,132.96
99
2,032,264.47
$3,128,525.00
$0.00
$3,128,525.00
$2.48
$0.00
$3,128,090.42
$434.58
100%
$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
755,000.00
.00
100
9200.021
2007 Bond (Interest)
42,475.00
.00
42,475.00
.00
.00
42,475.00
.00
100
75,100.00
9200.024
2009 Refunding Bond (Principal)
100,000.00
.00
100,000.00
.00
.00
100,000.00
.00
100
100,000.00
9200.025
2009 Refunding Bond (Interest)
12,600.00
.00
12,600.00
.00
.00
12,600.00
.00
100
16,100.00
9200.026
2010 Bond (Principal)
750,000.00
.00
750,000.00
.00
.00
750,000.00
.00
100
720,000.00
9200.027
2010 Bond (Interest)
229,300.00
.00
229,300.00
.00
.00
229,300.00
.00
100
250,900.00
9200.028
2012 Refunding Bond (Principal)
660,000.00
.00
660,000.00
.00
.00
660,000.00
.00
100
645,000.00
9200.029
2012 Refunding Bond (Interest)
175,200.00
.00
175,200.00
.00
.00
175,200.00
.00
100
188,100.00
9200.030
2014 Refunding- 2007 Bond (Principal)
130,000.00
.00
130,000.00
.00
.00
130,000.00
.00
100
125,000.00
9200.031
2014 Refunding- 2007 Bond (Interest)
273,450.00
.00
273,450.00
.00
.00
273,450.00
.00
100
275,950.00
Division 92 - Bonds Totals
$3,128,025.00
$0.00
$3,128,025.00
$0.00
$0.00
$3,128,025.00
$0.00
100%
$3,121,150.00
Unit 00 - Non-Departmental Totals
$3,128,025.00
$0.00
$3,128,025.00
$0.00
$0.00
$3,128,025.00
$0.00
100%
$3,121,150.00
EXPENSE TOTALS
$3,128,025.00
$0.00
$3,128,025.00
$0.00
$0.00
$3,128,025.00
$0.00
100%
$3,121,150.00
Run by Colleen Thornton on 02/21/2018 02:32:35 PM
Page 20 of 27
Budget Performance Report Fiscal Year to Date 01/31/18 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
2.48
.00
3,128,090.42
434.58
100%
3,121,176.12
EXPENSE TOTALS
3,128,025.00
.00
3,128,025.00
.00
.00
3,128,025.00
.00
100%
3,121,150.00
Fund 05 - Bond and Interest Fund Totals
$500.00
$0.00
$500.00
$2.48
$0.00
$65.42
$434.58
625,000.00
.00
625,000.00
.00
.00
623,114.32
1,885.68
100
621,534.63
100.00
.00
100.00
318.99
.00
1,380.97
(1,280.97)
1381
164.54
.00
.00
.00
.00
.00
.00
.00
+++
55.00
$625,100.00
$0.00
$625,100.00
$318.99
$0.00
$624,495.29
$604.71
100%
$621,754.17
500.00
.00
500.00
.00
.00
336.00
164.00
67
336.00
280,000.00
.00
280,000.00
.00
.00
156,425.00
123,575.00
56
268,633.00
Account Description
Budget - YTD % Used/
Fund 05 - Bond and Interest Fund Totals
$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
$0.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
$0.00
$0.00
$378,101.00
$246,999.00
60%
$594,821.00
EXPENSE TOTALS
$625,100.00
$0.00
$625,100.00
$0.00
$0.00
$378,101.00
$246,999.00
60%
$594,821.00
REVENUE TOTALS
625,100.00
.00
625,100.00
318.99
.00
624,495.29
604.71
100%
621,754.17
EXPENSE TOTALS
625,100.00
.00
625,100.00
.00
.00
378,101.00
246,999.00
60%
594,821.00
Fund 07 - Tort Immunity Fund Totals
$0.00
$0.00
$0.00
$318.99
$0.00
$246,394.29
($246,394.29)
42,000.00
.00
42,000.00
.00
.00
42,273.77
(273.77)
101
50.00
.00
50.00
17.36
.00
178.07
(128.07)
356
72.05
REVENUE TOTALS
$42,050.00
$0.00
$42,050.00
$17.36
$0.00
$42,451.84
($401.84)
101%
$42,323.83
42,000.00
.00
42,000.00
.00
.00
35,875.00
6,125.00
85
39,142.00
Division 00 - Non-Divisional Totals
$42,000.00
$0.00
$42,000.00
$0.00
$0.00
$35,875.00
$6,125.00
85%
$39,142.00
Unit 00 - Non-Departmental Totals
$42,000.00
$0.00
$42,000.00
$0.00
$0.00
$35,875.00
$6,125.00
85%
$39,142.00
EXPENSE TOTALS
$42,000.00
$0.00
$42,000.00
$0.00
$0.00
$35,875.00
$6,125.00
85%
$39,142.00
REVENUE TOTALS
42,050.00
.00
42,050.00
17.36
.00
42,451.84
(401.84)
101%
42,323.83
EXPENSE TOTALS
42,000.00
.00
42,000.00
.00
.00
35,875.00
6,125.00
85%
39,142.00
Fund 08 - Audit Fund Totals
$50.00
$0.00
$50.00
$17.36
$0.00
$6,576.84
($6,526.84)
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 02/21/2018 02:32:35 PM
$3,181.83
Page 21 of 27
Budget Performance Report Fiscal Year to Date 01/31/18 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
84.13
.00
1,056,445.07
(556,445.07)
211
784,139.57
0800.824
Realized Gain/Loss-SawyerFalduto
.00
.00
.00
.00
.00
96,495.70
(96,495.70)
+++
(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,109,655.92
(1,109,655.92)
+++
1,646,913.00
0818.000
Employee Contributions
575,000.00
.00
575,000.00
.00
.00
342,244.39
232,755.61
60
509,526.26
0819.000
Employer Contributions
1,370,000.00
.00
1,370,000.00
.00
.00
1,364,479.09
5,520.91
100
1,101,142.15
$2,920,000.00
$0.00
$2,920,000.00
$84.13
$0.00
$3,969,320.17
($1,049,320.17)
136%
$3,974,855.25
5,000.00
.00
5,000.00
.00
.00
3,197.25
1,802.75
64
4,169.95
500.00
.00
500.00
.00
.00
.00
500.00
0
.00
(240.25)
104
5,560.27 32,081.70
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
5,740.25
8135
Contractual Services
30,000.00
.00
30,000.00
3,635.00
.00
24,754.60
5,245.40
83
8137
Investment Expense
85,000.00
.00
85,000.00
.00
.00
48,523.00
36,477.00
57
87,300.00
8330
Pension Payments
485,000.00
.00
485,000.00
41,444.93
.00
368,590.29
116,409.71
76
442,742.40
Division 00 - Non-Divisional Totals
$611,000.00
$0.00
$611,000.00
$45,079.93
$0.00
$450,805.39
$160,194.61
74%
$571,854.32
Unit 00 - Non-Departmental Totals
$611,000.00
$0.00
$611,000.00
$45,079.93
$0.00
$450,805.39
$160,194.61
74%
$571,854.32
EXPENSE TOTALS
$611,000.00
$0.00
$611,000.00
$45,079.93
$0.00
$450,805.39
$160,194.61
74%
$571,854.32
REVENUE TOTALS
2,920,000.00
.00
2,920,000.00
84.13
.00
3,969,320.17
(1,049,320.17)
136%
3,974,855.25
EXPENSE TOTALS
611,000.00
.00
611,000.00
45,079.93
.00
450,805.39
160,194.61
74%
Fund 10 - Police Pension Fund Totals
$2,309,000.00
$0.00
$2,309,000.00
($44,995.80)
$0.00
$3,518,514.78
($1,209,514.78)
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
296,787.16
.00
2,149,129.48
750,870.52
74
3,492,459.42
0500.502
Utility Tax
2,800,000.00
.00
2,800,000.00
256,786.98
.00
2,044,177.80
755,822.20
73
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
.00
.00
3,897.91
1,102.09
78
10,030.89
0650.670
Impound Fee
30,000.00
.00
30,000.00
2,250.00
.00
19,500.00
10,500.00
65
22,852.50
0650.673
Daily Storage Fee for Impound
5,000.00
.00
5,000.00
130.00
.00
990.00
4,010.00
20
1,475.00
0650.675
Red Light Fines
255,000.00
.00
255,000.00
30,500.39
.00
302,000.00
(47,000.00)
118
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
12,569.57
.00
91,874.65
(59,988.65)
288
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
311,801.75
.00
668,175.57
5,131,824.43
12
95,942.30
Run by Colleen Thornton on 02/21/2018 02:32:35 PM
Page 22 of 27
Budget Performance Report Fiscal Year to Date 01/31/18 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
.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
$910,825.85
$0.00
$5,279,920.41
$8,791,204.59
38%
$10,258,977.98
110,000.00
.00
110,000.00
18,424.92
.00
64,645.18
45,354.82
59
110,742.39
Division 00 - Non-Divisional Totals
$110,000.00
$0.00
$110,000.00
$18,424.92
$0.00
$64,645.18
$45,354.82
59%
$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
168,012.00
31,988.00
84
279,983.00
8225
Engineering Fees
100,000.00
.00
100,000.00
.00
.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
.00
.00
322,660.69
177,339.31
65
163,591.79
9120.005
Machinery and Equipment-Police
225,000.00
.00
225,000.00
1,725.00
11,068.22
176,319.80
37,611.98
83
231,378.31
9120.008
Machinery and Equipment-Public Works
325,000.00
.00
325,000.00
165,644.00
.00
270,905.77
54,094.23
83
303,607.42
9152.001
Street Lights-Replacement
125,000.00
.00
125,000.00
.00
124,473.00
.00
527.00
100
74,735.42
9152.002
School Beacon Upgrades
5,000.00
.00
5,000.00
.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
.00
.00
60,156.02
29,843.98
67
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
25,362.83
.00
625,654.70
5,174,345.30
11
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
14,719.56
.00
14,719.56
410,280.44
3
.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
.00
.00
115,855.00
9,145.00
93
74,678.34
9165
Roadway Improvements
1,000,000.00
.00
1,000,000.00
.00
.00
1,047,173.84
(47,173.84)
105
485,235.47
9165.009
143rd St. Extension Phase 2
1,400,000.00
.00
1,400,000.00
31,327.31
.00
181,435.08
1,218,564.92
13
711,301.02
9165.019
I-55 Interchange Design
320,000.00
.00
320,000.00
.00
.00
170,287.42
149,712.58
53
33,290.79
9165.028
Renwick Corridor
70,000.00
.00
70,000.00
290.00
.00
15,777.54
54,222.46
23
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
19,289.01
.00
562,135.33
117,864.67
83
263,729.61
9165.031
Village Green
130,000.00
.00
130,000.00
6,063.75
.00
19,815.24
110,184.76
15
2,642.63
$11,925,000.00
$0.00
$11,925,000.00
$264,421.46
$139,008.22
$3,848,713.84
$7,937,277.94
33%
$3,495,786.37
2,036,125.00
.00
2,036,125.00
.00
.00
2,023,992.04
12,132.96
99
2,032,264.47
Division 91 - Capital Totals Division 99 - Transfers 9905
Transfer to Debt Service
Run by Colleen Thornton on 02/21/2018 02:32:35 PM
Page 23 of 27
Budget Performance Report Fiscal Year to Date 01/31/18 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
$2,023,992.04
$12,132.96
99%
$2,032,264.47
Unit 00 - Non-Departmental Totals
$14,071,125.00
$0.00
$14,071,125.00
$282,846.38
$139,008.22
$5,937,351.06
$7,994,765.72
43%
$5,638,793.23
EXPENSE TOTALS
$14,071,125.00
$0.00
$14,071,125.00
$282,846.38
$139,008.22
$5,937,351.06
$7,994,765.72
43%
$5,638,793.23
REVENUE TOTALS
14,071,125.00
.00
14,071,125.00
910,825.85
.00
5,279,920.41
8,791,204.59
38%
10,258,977.98
EXPENSE TOTALS
14,071,125.00
.00
14,071,125.00
282,846.38
139,008.22
5,937,351.06
7,994,765.72
43%
Fund 11 - Capital Improvement Fund Totals
$0.00
$0.00
$0.00
$627,979.47
($139,008.22)
($657,430.65)
$796,438.87
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
17.31
.00
66.39
(46.39)
332
44.93
20,000.00
.00
20,000.00
.00
.00
22,319.53
(2,319.53)
112
18,294.57
REVENUE TOTALS
$20,020.00
$0.00
$20,020.00
$17.31
$0.00
$22,385.92
($2,365.92)
112%
$18,339.50
20,000.00
.00
20,000.00
299.99
.00
5,342.44
14,657.56
27
21,529.69
Division 00 - Non-Divisional Totals
$20,000.00
$0.00
$20,000.00
$299.99
$0.00
$5,342.44
$14,657.56
27%
$21,529.69
Unit 00 - Non-Departmental Totals
$20,000.00
$0.00
$20,000.00
$299.99
$0.00
$5,342.44
$14,657.56
27%
$21,529.69
EXPENSE TOTALS
$20,000.00
$0.00
$20,000.00
$299.99
$0.00
$5,342.44
$14,657.56
27%
$21,529.69
REVENUE TOTALS
20,020.00
.00
20,020.00
17.31
.00
22,385.92
(2,365.92)
112%
18,339.50
EXPENSE TOTALS
20,000.00
.00
20,000.00
299.99
.00
5,342.44
14,657.56
27%
Fund 14 - D.A.R.E. Fund Totals
$20.00
$0.00
$20.00
($282.68)
$0.00
$17,043.48
($17,023.48)
745,000.00
.00
745,000.00
.00
.00
718,508.33
26,491.67
96
2,000.00
.00
2,000.00
469.57
.00
6,340.29
(4,340.29)
317
5,190.49
REVENUE TOTALS
$747,000.00
$0.00
$747,000.00
$469.57
$0.00
$724,848.62
$22,151.38
97%
$742,112.55
.00
.00
.00
.00
.00
359.40
(359.40)
+++
.00
Division 00 - Non-Divisional Totals
$0.00
$0.00
$0.00
$0.00
$0.00
$359.40
($359.40)
+++
$0.00
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
736,922.06
EXPENSE Unit 00 - Non-Departmental Division 00 - Non-Divisional 8135
Contractual Services Division 91 - Capital
8135
Contractual Services
450,000.00
.00
450,000.00
117,047.62
.00
754,058.93
(304,058.93)
168
429,675.92
9199
Facade Improvements
125,000.00
.00
125,000.00
.00
.00
127,118.46
(2,118.46)
102
157,162.33
Run by Colleen Thornton on 02/21/2018 02:32:35 PM
Page 24 of 27
Budget Performance Report Fiscal Year to Date 01/31/18 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
$575,000.00
$0.00
$575,000.00
$117,047.62
$0.00
$881,177.39
($306,177.39)
153%
$586,838.25
Fund 17 - Tax Increment Financing Fund EXPENSE Unit 00 - Non-Departmental Division 91 - Capital Totals Division 99 - Transfers 9901
Transfer to General
9911
Transfer to Capital Improvements
50,000.00
.00
50,000.00
.00
.00
.00
50,000.00
0
.00
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
$117,047.62
$0.00
$881,536.79
$243,463.21
78%
$1,086,838.25
EXPENSE TOTALS
$1,125,000.00
$0.00
$1,125,000.00
$117,047.62
$0.00
$881,536.79
$243,463.21
78%
$1,086,838.25
REVENUE TOTALS
747,000.00
.00
747,000.00
469.57
.00
724,848.62
22,151.38
97%
742,112.55
EXPENSE TOTALS
1,125,000.00
.00
1,125,000.00
117,047.62
.00
881,536.79
243,463.21
78%
1,086,838.25
Fund 17 - Tax Increment Financing Fund Totals
($378,000.00)
$0.00
($378,000.00)
($116,578.05)
$0.00
($156,688.17)
($221,311.83)
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
100.00
.00
1,040.00
(1,040.00)
+++
0800.800
Interest Income
.00
.00
.00
2.57
.00
17.40
(17.40)
+++
950.00 9.11
REVENUE TOTALS
$0.00
$0.00
$0.00
$102.57
$0.00
$1,057.40
($1,057.40)
+++
$959.11
.00
.00
.00
280.00
.00
700.00
(700.00)
+++
1,015.00
Division 00 - Non-Divisional Totals
$0.00
$0.00
$0.00
$280.00
$0.00
$700.00
($700.00)
+++
$1,015.00
Unit 00 - Non-Departmental Totals
$0.00
$0.00
$0.00
$280.00
$0.00
$700.00
($700.00)
+++
$1,015.00
EXPENSE TOTALS
$0.00
$0.00
$0.00
$280.00
$0.00
$700.00
($700.00)
+++
$1,015.00
REVENUE TOTALS
.00
.00
.00
102.57
.00
1,057.40
(1,057.40)
+++
959.11
EXPENSE TOTALS
.00
.00
.00
280.00
.00
700.00
(700.00)
+++
1,015.00
Fund 26 - Sex Offender's Registration Fund Totals
$0.00
$0.00
$0.00
($177.43)
$0.00
$357.40
($357.40)
15,000.00
.00
15,000.00
1,650.00
.00
11,492.00
3,508.00
77
100.00
.00
100.00
53.93
.00
369.98
(269.98)
370
207.30
$15,100.00
$0.00
$15,100.00
$1,703.93
$0.00
$11,861.98
$3,238.02
79%
$16,852.30
20,000.00
.00
20,000.00
.00
.00
.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 REVENUE TOTALS
16,645.00
EXPENSE Unit 00 - Non-Departmental Division 99 - Transfers 9901
Transfer to General
Run by Colleen Thornton on 02/21/2018 02:32:35 PM
Page 25 of 27
Budget Performance Report Fiscal Year to Date 01/31/18 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 27 - Alcohol Enforcement Fund EXPENSE Unit 00 - Non-Departmental 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 TOTALS
$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
1,703.93
.00
11,861.98
3,238.02
79%
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)
$1,703.93
$0.00
$11,861.98
($16,761.98)
Fund 27 - Alcohol Enforcement Fund Totals
$4,852.30
Fund 28 - Drug Enforcement Fund REVENUE 0600.611
Drug Fines
.00
.00
.00
969.00
.00
1,277.00
(1,277.00)
+++
0800.800
Interest Income
.00
.00
.00
41.74
.00
303.95
(303.95)
+++
172.97
$0.00
$0.00
$0.00
$1,010.74
$0.00
$1,580.95
($1,580.95)
+++
$920.97
REVENUE TOTALS
.00
.00
.00
1,010.74
.00
1,580.95
(1,580.95)
+++
920.97
EXPENSE TOTALS
.00
.00
.00
.00
.00
.00
.00
+++
Fund 28 - Drug Enforcement Fund Totals
$0.00
$0.00
$0.00
$1,010.74
$0.00
$1,580.95
($1,580.95)
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
3,065.00
.00
26,052.00
(26,052.00)
+++
32,454.00
0800.800
Interest Income
.00
.00
.00
196.70
.00
1,349.47
(1,349.47)
+++
650.77
0805.000
Other Reimbursements
.00
.00
.00
7,450.00
.00
7,450.00
(7,450.00)
+++
.00
$0.00
$0.00
$0.00
$10,711.70
$0.00
$34,851.47
($34,851.47)
+++
$33,104.77
REVENUE TOTALS
.00
.00
.00
10,711.70
.00
34,851.47
(34,851.47)
+++
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
$10,711.70
$0.00
$34,851.47
($34,851.47)
REVENUE TOTALS Fund 29 - Police Vehicle Replacement Fund Totals
.00 $33,104.77
Fund 40 - PEMA Fund REVENUE 0800.800
Interest Income
.00
.00
.00
21.08
.00
147.79
(147.79)
+++
80.73
0801.822
Donation/Contribution
.00
.00
.00
.00
.00
3,000.00
(3,000.00)
+++
4,757.69
$0.00
$0.00
$0.00
$21.08
$0.00
$3,147.79
($3,147.79)
+++
$4,838.42
.00
.00
.00
.00
.00
2,347.00
(2,347.00)
+++
.00
REVENUE TOTALS EXPENSE Unit 00 - Non-Departmental Division 00 - Non-Divisional 9140
PEMA Fundraising
Run by Colleen Thornton on 02/21/2018 02:32:35 PM
Page 26 of 27
Budget Performance Report Fiscal Year to Date 01/31/18 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 40 - PEMA Fund EXPENSE Unit 00 - Non-Departmental 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
REVENUE TOTALS
.00
.00
.00
21.08
.00
3,147.79
(3,147.79)
+++
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
$21.08
$0.00
$800.79
($800.79)
REVENUE TOTALS
64,811,117.00
.00
64,811,117.00
3,844,182.54
.00
50,344,935.51
14,466,181.49
78%
62,432,575.85
EXPENSE TOTALS
62,884,447.00
.00
62,884,447.00
2,534,939.89
188,083.52
41,051,041.13
21,645,322.35
66%
53,321,796.97
Grand Totals
$1,926,670.00
$0.00
$1,926,670.00
$1,309,242.65
($188,083.52)
$9,293,894.38
($7,179,140.86)
Fund 40 - PEMA Fund Totals .00 $4,838.42
Grand Totals
Run by Colleen Thornton on 02/21/2018 02:32:35 PM
$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
.00
.00
3,238,346.82
(78,346.82)
102
0400.402
Property Tax Rev-Road & Bridge
375,000.00
.00
375,000.00
.00
.00
362,940.98
12,059.02
97
357,161.29
0400.403
Property Tax Rev-Police Pension
1,370,000.00
.00
1,370,000.00
.00
.00
1,364,479.09
5,520.91
100
1,101,142.15
0400.404
Property Tax Revenue-IMRF
575,000.00
.00
575,000.00
.00
.00
573,025.75
1,974.25
100
575,655.27
0450.450
Home Rule Sales Tax
500,000.00
.00
500,000.00
.00
.00
500,000.00
.00
100
.00
0450.451
Municipal Sales Tax
5,400,000.00
.00
5,400,000.00
463,682.83
.00
4,113,784.91
1,286,215.09
76
5,354,048.49
0450.452
Illinois Income Tax
3,550,000.00
.00
3,550,000.00
300,781.21
.00
3,202,284.03
347,715.97
90
3,741,387.32
0450.453
Replacement Tax
45,000.00
.00
45,000.00
5,885.17
.00
34,809.19
10,190.81
77
56,644.71
0450.454
Replacement Tax-Library
.00
.00
.00
1,729.42
.00
1,729.42
(1,729.42)
+++
.00
0450.455
Local Use Tax
875,000.00
.00
875,000.00
86,448.31
.00
724,581.18
150,418.82
83
974,197.53
0500.500
Hotel/Motel Tax
.00
.00
.00
416.63
.00
1,438.30
(1,438.30)
+++
198.71
0500.501
Amusement Tax
5,000.00
.00
5,000.00
1,635.14
.00
4,945.33
54.67
99
9,892.85
0500.503
Local Motor Fuel Tax
930,000.00
.00
930,000.00
94,411.99
.00
816,289.60
113,710.40
88
959,052.15
0550.551
Liquor License
100,000.00
.00
100,000.00
1,200.00
.00
103,258.01
(3,258.01)
103
103,568.00
0550.552
Contractors License
35,000.00
.00
35,000.00
2,600.00
.00
37,450.00
(2,450.00)
107
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
4,312.50
.00
36,600.00
(1,600.00)
105
37,788.00
0570.555
Building Permit
925,000.00
.00
925,000.00
43,496.80
.00
638,511.97
286,488.03
69
952,316.60
0570.556
Sign Permit
5,000.00
.00
5,000.00
434.00
.00
3,385.00
1,615.00
68
7,763.00
0570.557
Special Movement Permit
5,000.00
.00
5,000.00
3,680.00
.00
16,730.00
(11,730.00)
335
8,630.00
0570.560
Solicitors Permit
1,000.00
.00
1,000.00
140.00
.00
1,715.00
(715.00)
172
1,785.00
0600.601
County Court Fines
325,000.00
.00
325,000.00
25,547.22
.00
274,966.69
50,033.31
85
367,797.10
0600.602
Administrative Fines(P-Tickets)
130,000.00
.00
130,000.00
8,445.00
.00
86,510.00
43,490.00
67
135,528.00
0600.603
Asset Seizure-Non Federal
225,000.00
.00
225,000.00
.00
.00
10,250.99
214,749.01
5
100,189.55
0600.604
Alarm Fees
7,000.00
.00
7,000.00
.00
.00
3,050.00
3,950.00
44
2,025.00
0600.605
Kendall County Court Fines
1,000.00
.00
1,000.00
277.94
.00
2,059.78
(1,059.78)
206
1,165.84
0600.607
Administrative Fines- Late Fee
10,000.00
.00
10,000.00
700.00
.00
5,775.00
4,225.00
58
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
.00
.00
.00
.00
.00
.00
.00
+++
921.38
4,112,315.00
.00
4,112,315.00
353,293.07
.00
3,452,663.07
659,651.93
84
3,992,763.21
Garbage Penalties
50,000.00
.00
50,000.00
4,707.24
.00
42,113.03
7,886.97
84
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
80.00
.00
9,707.88
292.12
97
13,162.00
Accident Report Fees
4,000.00
.00
4,000.00
550.00
.00
4,580.00
(580.00)
114
4,585.00
Copies-Maps & Ordinances
3,000.00
.00
3,000.00
140.25
.00
1,989.70
1,010.30
66
2,366.70
30,000.00
.00
30,000.00
2,250.00
.00
19,500.00
10,500.00
65
22,852.50
Run by Colleen Thornton on 02/21/2018 02:32:35 PM
Page 1 of 27
Budget Performance Report Fiscal Year to Date 01/31/18 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.815
Parking Lot Revenue
2,000.00
.00
2,000.00
.00
.00
1,950.00
50.00
98
4,532.00
0650.818
Tower Rent
50,000.00
.00
50,000.00
3,400.17
.00
32,696.79
17,303.21
65
38,191.41
0650.825
Rental Income
50,000.00
.00
50,000.00
4,100.00
.00
36,900.00
13,100.00
74
45,100.00
0650.830
Rental-Community/Multi Room
3,000.00
.00
3,000.00
243.75
.00
3,343.75
(343.75)
111
4,546.75
0650.904
Special Detail/OT Reimbursement
45,000.00
.00
45,000.00
3,375.00
.00
112,640.40
(67,640.40)
250
68,278.93
0690.902
Water & Sewer Service Charge
250,000.00
.00
250,000.00
.00
.00
125,000.00
125,000.00
50
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
.00
.00
1,520.86
1,479.14
51
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,287.54
.00
13,590.96
16,409.04
45
15,038.66
0750.750
AT&T Franchise Fees
250,000.00
.00
250,000.00
624.13
.00
132,657.15
117,342.85
53
209,381.47
0750.751
Cable TV-Franchise Fees
480,000.00
.00
480,000.00
.00
.00
396,082.08
83,917.92
83
533,615.95
0800.800
Interest Income
35,000.00
.00
35,000.00
7,187.71
.00
68,198.85
(33,198.85)
195
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
.00
.00
(8,896.42)
8,896.42
+++
(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
(4,053.37)
.00
(4,578.33)
4,578.33
+++
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
250.00
.00
1,325.00
(825.00)
265
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
1,386.00
.00
16,996.29
(6,996.29)
170
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
6,810.22
.00
193,707.46
(113,707.46)
242
86,085.15
25,000.00
.00
25,000.00
2,518.18
.00
13,246.64
11,753.36
53
13,218.83
.00
.00
.00
.00
.00
.00
.00
+++
151,127.00
School Liaison Reimbursement
400,000.00
.00
400,000.00
106,635.60
.00
345,593.63
54,406.37
86
431,372.53
HIDTA/Organized Crime Reimb
10,000.00
.00
10,000.00
1,756.00
.00
9,954.39
45.61
100
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
$1,543,365.65
$0.00
$21,226,763.60
$3,557,551.40
86%
$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)
EXPENSE Unit 00 - Non-Departmental Division 94 - Contra 2020.001
Contra Insurance Account
Run by Colleen Thornton on 02/21/2018 02:32:35 PM
Page 2 of 27
Budget Performance Report Fiscal Year to Date 01/31/18 Exclude Rollup Account
Account
Account Description
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Budget - YTD % Used/ Transactions
3,808,325.00
.00
3,808,325.00
315,677.32
.00
2,520,188.52
.00
.00
.00
.00
.00
.00
$3,808,325.00
$0.00
$3,808,325.00
$315,677.32
$0.00
Rec'd
Prior Year Total
1,288,136.48
66
3,669,782.29
.00
+++
134,093.16
$2,520,188.52
$1,288,136.48
66%
$3,803,875.45
Fund 01 - General Fund EXPENSE Unit 04 - Administration/Finance Division 00 - Non-Divisional 8100
Fees to Refuse Hauler
9997
Bad Debt Expense Division 00 - Non-Divisional Totals Division 01 - Legislative Program
1000
Salaries-President
24,000.00
.00
24,000.00
2,000.00
.00
17,666.67
6,333.33
74
20,000.04
1002
Salaries-Elected Officials
25,000.00
.00
25,000.00
1,600.00
.00
19,100.00
5,900.00
76
24,100.00
1003
Salaries-Liquor Commissioner
1,500.00
.00
1,500.00
125.00
.00
1,125.00
375.00
75
1,500.00
1004
Salaries-Treasurer
2,500.00
.00
2,500.00
208.33
.00
1,874.97
625.03
75
2,499.96
2000
FICA
3,300.00
.00
3,300.00
230.23
.00
2,345.26
954.74
71
2,783.06
2001
Medicare
780.00
.00
780.00
53.84
.00
548.48
231.52
70
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
102.90
47.10
69
92.40
3000
Travel/Training
10,000.00
.00
10,000.00
.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
14,856.15
20,143.85
42
38,761.37
8070
Public Relations
115,000.00
.00
115,000.00
124.39
.00
47,082.14
67,917.86
41
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
23,343.18
.00
99,928.04
75,071.96
57
36,007.59
$406,130.00
$0.00
$406,130.00
$27,697.57
$0.00
$209,854.49
$196,275.51
52%
$262,248.35
Division 01 - Legislative Program Totals Division 02 - Administration Program 1005
Salaries-Full Time
710,000.00
.00
710,000.00
58,775.82
.00
551,991.97
158,008.03
78
688,352.30
1015
Salaries-Part Time
50,000.00
.00
50,000.00
3,406.66
.00
40,385.89
9,614.11
81
45,065.94
1800
Salaries-Overtime
1,000.00
.00
1,000.00
87.82
.00
2,502.98
(1,502.98)
250
339.33
2000
FICA
47,500.00
.00
47,500.00
3,811.23
.00
32,576.34
14,923.66
69
40,632.69
2001
Medicare
11,000.00
.00
11,000.00
891.35
.00
8,502.07
2,497.93
77
10,673.40
2010
IMRF
84,000.00
.00
84,000.00
6,897.83
.00
65,671.31
18,328.69
78
83,197.55
2020
Employee Insurance
109,000.00
.00
109,000.00
7,783.59
.00
80,101.89
28,898.11
73
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
308.00
.00
5,467.39
9,532.61
36
9,487.79
3015
IL Unemployment Insurance
7,000.00
.00
7,000.00
.00
.00
1,867.02
5,132.98
27
3,505.77
4000
Telephone/Internet
5,000.00
.00
5,000.00
345.08
.00
3,567.27
1,432.73
71
4,094.28
4005
Cellular Phones/Pagers
2,500.00
.00
2,500.00
156.73
.00
1,629.49
870.51
65
3,004.18
5005
Office Supplies/Postage
30,000.00
.00
30,000.00
2,108.84
1,080.00
22,700.00
6,220.00
79
30,162.77
5015
Dues & Subscriptions
5,000.00
.00
5,000.00
.00
.00
3,238.95
1,761.05
65
4,072.00
5020
Gas/Oil/Mileage/Carwash
9,500.00
.00
9,500.00
600.00
.00
5,911.15
3,588.85
62
8,259.64
8035
Maintenance Contracts/Lease
8,000.00
.00
8,000.00
659.00
.00
5,272.00
2,728.00
66
7,908.00
8045
Recording Fees
2,000.00
.00
2,000.00
182.00
.00
182.00
1,818.00
9
1,379.49
Run by Colleen Thornton on 02/21/2018 02:32:35 PM
Page 3 of 27
Budget Performance Report Fiscal Year to Date 01/31/18 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 8050
Legal Notices
2,500.00
.00
2,500.00
386.80
.00
2,031.59
468.41
81
1,600.28
8065
Legal Fees
50,000.00
.00
50,000.00
7,530.00
.00
23,620.00
26,380.00
47
30,735.50
8135
Contractual Services
75,000.00
.00
75,000.00
2,108.27
.00
38,079.47
36,920.53
51
85,320.19
8135.008
Settlement Charges
.00
.00
.00
.48
.00
.48
(.48)
+++
.00
8225
Engineering Fees
5,000.00
.00
5,000.00
.00
.00
.00
5,000.00
0
2,283.20
9115
Office Furniture & Equipment
9300
Contingencies Division 02 - Administration Program Totals
5,000.00
.00
5,000.00
.00
4.21
640.84
4,354.95
13
4,632.33
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
$96,039.50
$1,084.21
$895,940.10
$406,975.69
69%
$1,209,847.95
Division 03 - Community Relations Program 1005
Salaries-Full Time
101,000.00
.00
101,000.00
7,630.88
.00
76,215.75
24,784.25
75
96,782.14
2000
FICA
6,200.00
.00
6,200.00
433.21
.00
4,261.99
1,938.01
69
5,592.49
2001
Medicare
1,450.00
.00
1,450.00
101.32
.00
996.76
453.24
69
1,307.94
2010
IMRF
11,500.00
.00
11,500.00
847.80
.00
8,476.00
3,024.00
74
11,059.04
2020
Employee Insurance
20,700.00
.00
20,700.00
1,615.65
.00
16,045.04
4,654.96
78
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
95.00
1,405.00
6
142.50
4000
Telephone/Internet
500.00
.00
500.00
34.51
.00
356.73
143.27
71
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
1,316.00
(566.00)
175
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
8,096.45
8,903.55
48
8,157.09
8071
Marketing and Promotions
2,500.00
.00
2,500.00
.00
.00
500.00
2,000.00
20
.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
336.00
.00
336.00
2,164.00
13
.00
$180,450.00
$0.00
$180,450.00
$11,041.87
$0.00
$121,513.11
$58,936.89
67%
$151,044.29
Division 04 - Facility Management Program 1005
Salaries-Full Time
50,000.00
.00
50,000.00
3,384.11
.00
34,167.99
15,832.01
68
33,936.93
1800
Salaries-Overtime
2,500.00
.00
2,500.00
1,061.39
.00
3,052.82
(552.82)
122
1,705.28
2000
FICA
3,300.00
.00
3,300.00
265.26
.00
2,216.86
1,083.14
67
2,245.20
2001
Medicare
800.00
.00
800.00
62.05
.00
518.52
281.48
65
525.16
2010
IMRF
5,500.00
.00
5,500.00
493.91
.00
4,128.75
1,371.25
75
4,221.28
2020
Employee Insurance
14,000.00
.00
14,000.00
1,181.16
.00
9,451.51
4,548.49
68
9,199.52
5000
Building Supplies
7,500.00
.00
7,500.00
.00
.00
8,842.01
(1,342.01)
118
9,970.18
8135
Contractual Services
40,000.00
.00
40,000.00
.00
.00
27,870.19
12,129.81
70
32,624.35
9105
Building Improvements Division 04 - Facility Management Program Totals
Run by Colleen Thornton on 02/21/2018 02:32:35 PM
40,000.00
.00
40,000.00
.00
.00
27,782.89
12,217.11
69
.00
$163,600.00
$0.00
$163,600.00
$6,447.88
$0.00
$118,031.54
$45,568.46
72%
$94,427.90
Page 4 of 27
Budget Performance Report Fiscal Year to Date 01/31/18 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
126,395.64
38,604.36
77
1800
Salaries-Overtime
500.00
.00
500.00
.00
.00
.00
500.00
0
.00
2000
FICA
10,500.00
.00
10,500.00
734.06
.00
7,464.46
3,035.54
71
8,014.37
2001
Medicare
2,500.00
.00
2,500.00
171.67
.00
1,745.72
754.28
70
1,874.33
2010
IMRF
19,000.00
.00
19,000.00
1,378.52
.00
14,041.89
4,958.11
74
15,421.82
2020
Employee Insurance
43,500.00
.00
43,500.00
2,900.74
.00
28,648.65
14,851.35
66
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
.00
.00
4,063.67
2,436.33
63
4,493.94
4000
Telephone/Internet
1,000.00
.00
1,000.00
69.02
.00
713.43
286.57
71
818.87
4005
Cellular Phones/Pagers
600.00
.00
600.00
54.85
.00
328.74
271.26
55
120.00
5005
Office Supplies/Postage
1,500.00
.00
1,500.00
58.54
.00
515.96
984.04
34
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
303.46
1,096.54
22
281.88
8070
Public Relations
12,000.00
.00
12,000.00
.00
.00
6,151.14
5,848.86
51
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
924.00
.00
3,003.24
4,996.76
38
6,462.99
$282,500.00
$0.00
$282,500.00
$18,699.24
$0.00
$193,595.00
$88,905.00
69%
$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
185,539.51
54,460.49
77
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
11,255.86
3,744.14
75
13,700.47
2001
Medicare
3,500.00
.00
3,500.00
259.94
.00
2,632.40
867.60
75
3,204.13
2010
IMRF
28,000.00
.00
28,000.00
2,036.70
.00
20,580.00
7,420.00
74
25,141.33
2020
Employee Insurance
56,000.00
.00
56,000.00
3,276.81
.00
32,406.56
23,593.44
58
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
9,571.88
4,928.12
66
19,185.65
4000
Telephone/Internet
500.00
.00
500.00
34.51
.00
356.73
143.27
71
409.42
4005
Cellular Phones/Pagers
2,340.00
.00
2,340.00
192.74
.00
1,570.32
769.68
67
2,211.40
5005
Office Supplies/Postage
1,400.00
.00
1,400.00
.00
.00
874.86
525.14
62
1,424.65
5015
Dues & Subscriptions
700.00
.00
700.00
85.00
.00
484.00
216.00
69
539.19
5020
Gas/Oil/Mileage/Carwash
400.00
.00
400.00
.00
.00
506.40
(106.40)
127
275.49
5095
Uniforms/Clothing
300.00
.00
300.00
.00
.00
302.82
(2.82)
101
.00
8030
Server/Network Supplies
47,900.00
.00
47,900.00
30,043.05
.00
44,720.16
3,179.84
93
33,660.64
8031
Software Licensing/Renewals
255,380.00
.00
255,380.00
8,203.68
8,268.89
198,040.56
49,070.55
81
220,551.71
8135
Contractual Services
17,880.00
.00
17,880.00
5,006.99
5,100.00
10,791.96
1,988.04
89
8,366.46
9111
Computers
12,000.00
.00
12,000.00
.00
.00
7,267.53
4,732.47
61
10,469.04
$703,300.00
$0.00
$703,300.00
$68,583.32
$13,368.89
$526,901.55
$163,029.56
77%
$609,814.39
Division 08 - IT Program Totals
Run by Colleen Thornton on 02/21/2018 02:32:35 PM
Page 5 of 27
Budget Performance Report Fiscal Year to Date 01/31/18 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
$544,186.70
$14,453.10
$4,586,024.31
$2,247,827.59
67%
$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
232,485.22
82,514.78
74
302,896.76
1015
Salaries-Part Time
26,296.00
.00
26,296.00
2,267.28
.00
24,725.39
1,570.61
94
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,482.43
.00
14,902.09
6,443.91
70
18,486.24
2001
Medicare
5,000.00
.00
5,000.00
346.71
.00
3,562.71
1,437.29
71
4,531.54
2010
IMRF
23,375.00
.00
23,375.00
1,635.31
.00
16,559.16
6,815.84
71
21,038.04
2020
Employee Insurance
66,780.00
.00
66,780.00
5,177.23
.00
51,041.27
15,738.73
76
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
445.00
.00
1,440.41
8,534.59
14
3,887.92
3001
Education/School
6,000.00
.00
6,000.00
.00
.00
493.67
5,506.33
8
433.15
3015
IL Unemployment Insurance
20,000.00
.00
20,000.00
.00
.00
9,152.37
10,847.63
46
17,278.91
4000
Telephone/Internet
605.00
.00
605.00
94.17
.00
1,034.11
(429.11)
171
1,282.86
4005
Cellular Phones/Pagers
1,644.00
.00
1,644.00
54.85
.00
474.71
1,169.29
29
996.63
5005
Office Supplies/Postage
11,950.00
.00
11,950.00
718.97
.00
2,866.66
9,083.34
24
5,051.83
5010
Replacement Supplies
3,500.00
.00
3,500.00
37.01
.00
707.33
2,792.67
20
707.23
5015
Dues & Subscriptions
7,050.00
.00
7,050.00
285.00
.00
3,045.03
4,004.97
43
3,771.67
5020
Gas/Oil/Mileage/Carwash
3,700.00
.00
3,700.00
1.91
.00
544.23
3,155.77
15
1,342.51
5095
Uniforms/Clothing
1,800.00
.00
1,800.00
.00
.00
1,439.85
360.15
80
2,345.25
8035
Maintenance Contracts/Lease
7,190.00
.00
7,190.00
380.00
.00
4,175.02
3,014.98
58
6,709.70
8040
Custodian
70,000.00
.00
70,000.00
765.61
.00
27,308.81
42,691.19
39
52,222.70
8060
Vehicle Maintenance
2,500.00
.00
2,500.00
.00
.00
21.84
2,478.16
1
1,340.12
8135
Contractual Services
8,000.00
.00
8,000.00
530.00
.00
2,104.72
5,895.28
26
5,465.40
$622,711.00
$0.00
$622,711.00
$37,086.44
$0.00
$398,420.99
$224,290.01
64%
$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
284,149.95
.00
2,748,310.87
1,169,985.13
70
1015
Salaries-Part Time
.00
.00
.00
17,560.65
.00
190,588.10
(190,588.10)
+++
.00
1800
Salaries-Overtime
380,000.00
.00
380,000.00
28,950.11
.00
272,761.59
107,238.41
72
263,296.45
2000
FICA
266,494.00
.00
266,494.00
20,061.67
.00
192,884.66
73,609.34
72
214,599.36
2001
Medicare
62,325.00
.00
62,325.00
4,691.88
.00
45,396.11
16,928.89
73
50,934.89
2010
IMRF
54,538.00
.00
54,538.00
3,241.66
.00
32,675.22
21,862.78
60
6,289.04
2011
Employer Pension Contributions
1,370,000.00
.00
1,370,000.00
.00
.00
1,364,479.09
5,520.91
100
1,101,142.15
2020
Employee Insurance
630,739.00
.00
630,739.00
45,170.44
.00
453,569.78
177,169.22
72
528,506.74
Run by Colleen Thornton on 02/21/2018 02:32:35 PM
Page 6 of 27
Budget Performance Report Fiscal Year to Date 01/31/18 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
432.00
.00
27,176.53
18,923.47
59
35,571.37
4000
Telephone/Internet
27,180.00
.00
27,180.00
810.67
.00
15,390.78
11,789.22
57
24,799.44
4005
Cellular Phones/Pagers
6,564.00
.00
6,564.00
429.74
.00
3,635.82
2,928.18
55
5,005.24
5005
Office Supplies/Postage
13,000.00
.00
13,000.00
264.77
.00
8,403.38
4,596.62
65
13,298.15
5010
Replacement Supplies
17,000.00
.00
17,000.00
71.00
.00
7,774.70
9,225.30
46
15,849.82
5015
Dues & Subscriptions
3,400.00
.00
3,400.00
205.00
.00
767.50
2,632.50
23
1,388.16
5020
Gas/Oil/Mileage/Carwash
100,000.00
.00
100,000.00
133.95
.00
50,300.37
49,699.63
50
63,832.78
5068
K-9 Unit
4,000.00
.00
4,000.00
65.50
.00
3,864.90
135.10
97
4,513.66
5095
Uniforms/Clothing
33,850.00
.00
33,850.00
915.73
.00
25,270.47
8,579.53
75
32,245.78
5100
Ammunition/Weapons
28,000.00
.00
28,000.00
2,256.42
.00
10,809.08
17,190.92
39
25,790.93
5115.001
Traffic Programs
23,000.00
.00
23,000.00
.00
.00
11,885.68
11,114.32
52
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
8,096.00
.00
11,568.00
(176.00)
102
11,702.00
8060
Vehicle Maintenance
65,000.00
.00
65,000.00
1,017.14
.00
39,024.77
25,975.23
60
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
.00
.00
435,148.02
157,851.98
73
564,841.56
8267
Animal Control
14,000.00
.00
14,000.00
850.00
.00
5,360.00
8,640.00
38
.00
$7,771,878.00
$0.00
$7,771,878.00
$419,374.28
$0.00
$5,970,924.24
$1,800,953.76
77%
$6,489,435.16
Division 51 - Police Operations Totals Division 52 - Police Administration 1005
Salaries-Full Time
859,940.00
.00
859,940.00
71,000.94
.00
732,899.44
127,040.56
85
1,290,355.79
1800
Salaries-Overtime
113,000.00
.00
113,000.00
6,482.67
.00
67,371.49
45,628.51
60
94,858.97
2000
FICA
60,322.00
.00
60,322.00
4,659.21
.00
48,544.86
11,777.14
80
84,083.97
2001
Medicare
14,108.00
.00
14,108.00
1,089.66
.00
11,353.24
2,754.76
80
19,883.44
2020
Employee Insurance
152,801.00
.00
152,801.00
12,907.77
.00
131,763.64
21,037.36
86
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
30.00
.00
7,424.59
6,175.41
55
12,631.90
4000
Telephone/Internet
780.00
.00
780.00
121.08
.00
1,293.66
(513.66)
166
1,593.21
4005
Cellular Phones/Pagers
5,544.00
.00
5,544.00
831.70
.00
5,498.27
45.73
99
7,514.02
5005
Office Supplies/Postage
8,500.00
.00
8,500.00
223.91
.00
1,681.91
6,818.09
20
5,293.77
5010
Replacement Supplies
12,000.00
.00
12,000.00
1,234.65
.00
3,867.70
8,132.30
32
269.21
5015
Dues & Subscriptions
4,070.00
.00
4,070.00
95.00
.00
2,095.00
1,975.00
51
3,511.66
5020
Gas/Oil/Mileage/Carwash
29,000.00
.00
29,000.00
57.94
.00
9,675.64
19,324.36
33
20,479.50
5040.002
Crime Scene/Evidence Tech Supply
10,800.00
.00
10,800.00
.00
2,373.75
7,536.79
889.46
92
7,337.69
5095
Uniforms/Clothing
5,300.00
.00
5,300.00
.00
.00
5,624.29
(324.29)
106
10,061.29
5115.004
Community Programs-Explorer Program
2,500.00
.00
2,500.00
142.60
.00
7,114.14
(4,614.14)
285
4,368.54
Run by Colleen Thornton on 02/21/2018 02:32:35 PM
Page 7 of 27
Budget Performance Report Fiscal Year to Date 01/31/18 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
710.00
.00
2,724.59
6,195.41
31
4,047.80
15,500.00
.00
15,500.00
202.00
.00
6,986.62
8,513.38
45
12,012.78
.00
.00
.00
.00
.00
540.00
(540.00)
+++
.00
2,500.00
.00
2,500.00
148.60
.00
1,016.05
1,483.95
41
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
$99,937.73
$2,373.75
$1,059,606.92
$297,774.33
78%
$1,838,973.48 401,677.79
Division 53 - Police Records 1005
Salaries-Full Time
463,022.00
.00
463,022.00
28,747.27
.00
338,903.32
124,118.68
73
1015
Salaries-Part Time
.00
.00
.00
1,620.06
.00
12,565.86
(12,565.86)
+++
.00
1800
Salaries-Overtime
6,000.00
.00
6,000.00
62.50
.00
4,687.46
1,312.54
78
10,112.29
2000
FICA
29,079.00
.00
29,079.00
1,829.35
.00
21,676.68
7,402.32
75
24,805.18
2001
Medicare
6,801.00
.00
6,801.00
427.82
.00
5,069.52
1,731.48
75
5,806.35
2010
IMRF
31,086.00
.00
31,086.00
2,418.72
.00
24,369.65
6,716.35
78
33,212.62
2020
Employee Insurance
129,686.00
.00
129,686.00
6,885.83
.00
80,525.05
49,160.95
62
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
.00
.00
1,741.13
358.87
83
1,796.60
4000
Telephone/Internet
780.00
.00
780.00
121.08
.00
1,293.66
(513.66)
166
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
491.27
12.68
6,470.85
6,966.47
48
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
20.95
.00
1,460.41
939.59
61
1,610.86
8035
Maintenance Contracts/Lease Division 53 - Police Records Totals
4,460.00
.00
4,460.00
180.00
.00
2,865.00
1,595.00
64
2,160.00
$705,633.00
$0.00
$705,633.00
$42,804.85
$12.68
$501,628.59
$203,991.73
71%
$617,070.11
Division 54 - Seizure/Forfeiture 5012
Asset Seizure/Forfeiture Expense Division 54 - Seizure/Forfeiture Totals
225,000.00
.00
225,000.00
44,553.00
14,275.00
59,421.08
151,303.92
33
156,826.56
$225,000.00
$0.00
$225,000.00
$44,553.00
$14,275.00
$59,421.08
$151,303.92
33%
$156,826.56
32,513.00
.00
32,513.00
1,293.75
.00
77,862.50
(45,349.50)
239
46,555.00
2,016.00
.00
2,016.00
76.83
.00
4,709.08
(2,693.08)
234
2,621.16
471.00
.00
471.00
17.97
.00
1,103.03
(632.03)
234
620.25
1,000.00
.00
1,000.00
201.14
.00
201.14
798.86
20
.00
$36,000.00
$0.00
$36,000.00
$1,589.69
$0.00
$83,875.75
($47,875.75)
233%
$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.56
.00
492,187.43
281,148.57
64
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
794.53
.00
33,179.65
(8,179.65)
133
28,729.30
Run by Colleen Thornton on 02/21/2018 02:32:35 PM
Page 8 of 27
Budget Performance Report Fiscal Year to Date 01/31/18 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,023.44
.00
32,177.45
17,319.55
65
47,859.97
2001
Medicare
11,576.00
.00
11,576.00
707.09
.00
7,569.39
4,006.61
65
11,230.53
2010
IMRF
5,534.00
.00
5,534.00
406.18
.00
5,005.63
528.37
90
49,461.85
2020
Employee Insurance
141,293.00
.00
141,293.00
9,448.51
.00
91,999.86
49,293.14
65
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
45.00
.00
10,243.42
1,436.58
88
10,133.37
780.00
.00
780.00
121.08
.00
1,293.65
(513.65)
166
1,593.21
6,744.00
.00
6,744.00
221.57
.00
1,811.97
4,932.03
27
2,758.96
3,400.00
.00
3,400.00
30.00
.00
1,005.97
2,394.03
30
2,897.50
Replacement Supplies
5,200.00
.00
5,200.00
.00
.00
282.22
4,917.78
5
751.72
5015
Dues & Subscriptions
1,900.00
.00
1,900.00
95.00
.00
135.00
1,765.00
7
1,903.67
5020
Gas/Oil/Mileage/Carwash
16,000.00
.00
16,000.00
24.63
.00
5,172.56
10,827.44
32
14,877.92
5095
Uniforms/Clothing
5,500.00
.00
5,500.00
.00
.00
5,637.89
(137.89)
103
5,956.72
5115.002
Community Programs
8,200.00
.00
8,200.00
.00
.00
3,854.84
4,345.16
47
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
1,821.62
3,463.39
19,514.99
21
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
153.00
.00
2,699.64
11,300.36
19
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
13,500.00
(3,500.00)
135
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
$64,847.59
$1,821.62
$712,066.24
$424,432.14
63%
$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
96,880.07
27,119.93
78
121,358.68
1015
Salaries-Part Time
47,410.00
.00
47,410.00
1,690.51
.00
18,353.01
29,056.99
39
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
672.73
.00
6,892.94
3,655.06
65
9,694.79
2001
Medicare
2,467.00
.00
2,467.00
157.33
.00
1,612.06
854.94
65
2,267.33
2010
IMRF
20,415.00
.00
20,415.00
1,264.76
.00
12,838.17
7,576.83
63
18,053.80
2020
Employee Insurance
43,998.00
.00
43,998.00
3,079.67
.00
31,137.29
12,860.71
71
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
167.89
2,832.11
6
161.00
4000
Telephone/Internet
605.00
.00
605.00
94.16
.00
998.99
(393.99)
165
1,282.91
5005
Office Supplies/Postage
10,000.00
.00
10,000.00
871.93
.00
4,654.77
5,345.23
47
8,745.16
5015
Dues & Subscriptions
9,000.00
.00
9,000.00
647.93
.00
6,018.51
2,981.49
67
8,151.47
5095
Uniforms/Clothing
900.00
.00
900.00
.00
.00
294.35
605.65
33
563.88
Run by Colleen Thornton on 02/21/2018 02:32:35 PM
Page 9 of 27
Budget Performance Report Fiscal Year to Date 01/31/18 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
160.00
.00
1,280.00
640.00
67
27,500.00
.00
27,500.00
.00
.00
12,189.00
15,311.00
44
8,405.05
$308,263.00
$0.00
$308,263.00
$18,332.33
$0.00
$193,427.39
$114,835.61
63%
$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
3,982.48
.00
103,801.82
3,978.18
96
13,396.15
Division 91 - Capital Totals
$118,780.00
$0.00
$118,780.00
$3,982.48
$0.00
$103,801.82
$14,978.18
87%
$19,260.06
13,700.00
.00
13,700.00
522.75
.00
7,958.84
5,741.16
58
13,887.78
Division 93 - Contingencies Totals
$13,700.00
$0.00
$13,700.00
$522.75
$0.00
$7,958.84
$5,741.16
58%
$13,887.78
Unit 05 - Police Department Totals
$12,300,040.00
$0.00
$12,300,040.00
$733,031.14
$18,483.05
$9,091,131.86
$3,190,425.09
74%
$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
98,949.74
32,250.26
75
124,512.43
2000
FICA
7,750.00
.00
7,750.00
572.60
.00
5,966.84
1,783.16
77
7,126.33
2001
Medicare
1,813.00
.00
1,813.00
133.92
.00
1,395.47
417.53
77
1,789.90
2020
Employee Insurance
24,336.00
.00
24,336.00
1,615.65
.00
15,845.04
8,490.96
65
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
.00
.00
700.48
3,299.52
18
571.80
4000
Telephone/Internet
5,400.00
.00
5,400.00
461.70
.00
4,923.35
476.65
91
5,346.74
4005
Cellular Phones/Pagers
5,200.00
.00
5,200.00
101.88
.00
1,860.89
3,339.11
36
3,450.61
5005
Office Supplies/Postage
1,300.00
.00
1,300.00
.00
.00
45.86
1,254.14
4
302.76
5010
Replacement Supplies
11,000.00
.00
11,000.00
.00
.00
1,572.79
9,427.21
14
1,472.80
5015
Dues & Subscriptions
5020
Gas/Oil/Mileage/Carwash
5040
4,000.00
.00
4,000.00
.00
.00
1,954.32
2,045.68
49
1,909.57
12,000.00
.00
12,000.00
11.48
.00
3,911.99
8,088.01
33
5,235.57
Supplies/Hardware
2,000.00
.00
2,000.00
69.71
.00
554.50
1,445.50
28
181.75
5040.001
Supplies/Hardware-ESDA
2,000.00
.00
2,000.00
251.98
.00
343.67
1,656.33
17
616.99
5095
Uniforms/Clothing
5,000.00
.00
5,000.00
.00
.00
1,746.10
3,253.90
35
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
.00
.00
907.36
14,092.64
6
7,175.99
8020
Building Maintenance
5,000.00
.00
5,000.00
.00
.00
783.36
4,216.64
16
.00
8035
Maintenance Contracts/Lease
1,800.00
.00
1,800.00
100.00
.00
895.02
904.98
50
1,311.79
8060
Vehicle Maintenance
15,000.00
.00
15,000.00
3,156.25
.00
12,189.76
2,810.24
81
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
.00
.00
7,580.28
12,419.72
38
9,555.57
Run by Colleen Thornton on 02/21/2018 02:32:35 PM
Page 10 of 27
Budget Performance Report Fiscal Year to Date 01/31/18 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
.00
.00
1,315.00
3,935.00
25
740.00
8280
Cadet Program
5,500.00
.00
5,500.00
.00
.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
173.99
.00
173.99
1,826.01
9
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
.00
.00
1,305.07
1,694.93
44
1,160.09
Division 07 - PEMA Program Totals
$312,799.00
$0.00
$312,799.00
$16,169.00
$0.00
$166,481.76
$146,317.24
53%
$226,615.29
Unit 07 - PEMA Totals
$312,799.00
$0.00
$312,799.00
$16,169.00
$0.00
$166,481.76
$146,317.24
53%
$226,615.29
288,000.00
.00
288,000.00
21,836.53
.00
218,421.51
69,578.49
76
272,912.32
18,000.00
.00
18,000.00
1,401.88
.00
13,368.68
4,631.32
74
16,762.99
4,200.00
.00
4,200.00
327.85
.00
3,238.11
961.89
77
4,078.42
Unit 08 - Street Department Division 02 - Administration Program 1005
Salaries-Full Time
2000
FICA
2001
Medicare
2010
IMRF
33,000.00
.00
33,000.00
2,588.54
.00
25,132.86
7,867.14
76
31,772.74
2020
Employee Insurance
59,500.00
.00
59,500.00
4,362.13
.00
42,970.19
16,529.81
72
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
.00
.00
6,116.93
3,883.07
61
9,710.16
3015
IL Unemployment Insurance
4,000.00
.00
4,000.00
.00
.00
2,336.95
1,663.05
58
3,651.67
4000
Telephone/Internet
19,000.00
.00
19,000.00
2,211.24
.00
20,400.86
(1,400.86)
107
22,890.54
4005
Cellular Phones/Pagers
8,500.00
.00
8,500.00
628.02
.00
5,182.05
3,317.95
61
7,348.00
5005
Office Supplies/Postage
2,500.00
.00
2,500.00
301.18
.00
2,092.41
407.59
84
3,583.27
5015
Dues & Subscriptions
3,000.00
.00
3,000.00
.00
.00
1,737.53
1,262.47
58
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
486.34
.00
6,547.51
13,452.49
33
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
$34,143.71
$0.00
$347,745.58
$132,354.42
72%
$442,804.96 721,757.32
Division 60 - Street Maintenance Program 1005
Salaries-Full Time
810,000.00
.00
810,000.00
59,931.58
.00
604,279.09
205,720.91
75
1015
Salaries-Part Time
75,000.00
.00
75,000.00
.00
.00
77,016.35
(2,016.35)
103
62,433.19
1800
Salaries-Overtime
85,000.00
.00
85,000.00
23,743.54
.00
92,595.39
(7,595.39)
109
106,835.87
2000
FICA
59,000.00
.00
59,000.00
4,781.59
.00
45,555.31
13,444.69
77
52,747.13
2001
Medicare
14,000.00
.00
14,000.00
1,118.27
.00
10,654.09
3,345.91
76
12,335.88
2010
IMRF
94,000.00
.00
94,000.00
8,838.69
.00
76,078.39
17,921.61
81
91,864.26
2020
Employee Insurance
193,000.00
.00
193,000.00
15,436.80
.00
150,064.91
42,935.09
78
173,326.22
2025
Deferred Comp. Contribution
20,000.00
.00
20,000.00
.00
.00
.00
20,000.00
0
21,869.39
Run by Colleen Thornton on 02/21/2018 02:32:35 PM
Page 11 of 27
Budget Performance Report Fiscal Year to Date 01/31/18 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 4015
Electricity/Gas
290,000.00
.00
290,000.00
1,498.91
.00
94,210.78
195,789.22
32
257,109.86
5020
Gas/Oil/Mileage/Carwash
70,000.00
.00
70,000.00
29.53
.00
11,580.85
58,419.15
17
53,294.62
5040
Supplies/Hardware
15,000.00
.00
15,000.00
947.45
.00
7,396.76
7,603.24
49
11,680.86
5040.003
Supplies/Hardware-Salt Purchase
280,000.00
.00
280,000.00
92,873.70
.00
92,873.70
187,126.30
33
232,040.61
5055
Street Sign Maintenance
25,000.00
.00
25,000.00
3,305.65
.00
27,615.13
(2,615.13)
110
29,485.95
5060
Aggregate Materials
4,000.00
.00
4,000.00
692.36
.00
4,464.47
(464.47)
112
5,239.80
5095
Uniforms/Clothing
10,000.00
.00
10,000.00
606.14
.00
5,646.92
4,353.08
56
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
2,616.22
.00
20,231.28
14,768.72
58
25,636.77
95,000.00
.00
95,000.00
10,905.30
.00
54,357.16
40,642.84
57
113,358.45
130,000.00
.00
130,000.00
4,029.32
.00
18,997.38
111,002.62
15
115,168.49
Storm Sewer Improvements
10,000.00
.00
10,000.00
.00
.00
11,414.18
(1,414.18)
114
1,490.85
8135
Contractual Services
90,000.00
.00
90,000.00
3,230.75
.00
61,631.61
28,368.39
68
108,462.32
8135.004
Snow Removal
280,000.00
.00
280,000.00
46,839.50
.00
46,839.50
233,160.50
17
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
12,100.54
.00
47,290.67
47,709.33
50
77,487.55
$2,789,000.00
$0.00
$2,789,000.00
$293,525.84
$0.00
$1,560,793.92
$1,228,206.08
56%
$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,544.55
.00
54,963.39
23,036.61
70
49,732.95
1800
Salaries-Overtime
6,000.00
.00
6,000.00
.00
.00
5,945.17
54.83
99
6,677.22
2000
FICA
5,500.00
.00
5,500.00
495.82
.00
3,888.69
1,611.31
71
3,634.67
2001
Medicare
1,300.00
.00
1,300.00
115.96
.00
909.46
390.54
70
850.03
2010
IMRF
9,000.00
.00
9,000.00
911.10
.00
7,183.02
1,816.98
80
6,753.55
2020
Employee Insurance
17,000.00
.00
17,000.00
1,062.14
.00
11,205.60
5,794.40
66
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
686.27
.00
5,710.91
2,289.09
71
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
120.00
.00
10,716.59
(5,716.59)
214
3,911.55
8135.002
Tree Removal Division 62 - Forestry Program Totals
45,000.00
.00
45,000.00
.00
.00
11,008.50
33,991.50
24
11,865.00
$178,300.00
$0.00
$178,300.00
$8,935.84
$0.00
$111,531.33
$66,768.67
63%
$103,094.78 186,524.95
Division 63 - Vehicle Maintenance Program 1005
Salaries-Full Time
193,000.00
.00
193,000.00
14,764.51
.00
147,359.76
45,640.24
76
1800
Salaries-Overtime
8,000.00
.00
8,000.00
1,636.44
.00
6,360.60
1,639.40
80
3,205.27
2000
FICA
12,500.00
.00
12,500.00
970.31
.00
9,078.75
3,421.25
73
11,275.14
2001
Medicare
3,000.00
.00
3,000.00
226.93
.00
2,123.23
876.77
71
2,636.92
2010
IMRF
22,000.00
.00
22,000.00
1,822.15
.00
17,050.81
4,949.19
78
21,386.55
2020
Employee Insurance
40,500.00
.00
40,500.00
3,039.00
.00
30,120.72
10,379.28
74
37,236.34
Run by Colleen Thornton on 02/21/2018 02:32:35 PM
Page 12 of 27
Budget Performance Report Fiscal Year to Date 01/31/18 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 63 - Vehicle Maintenance Program 2025
7,500.00
.00
7,500.00
.00
.00
.00
7,500.00
0
6,216.05
Division 63 - Vehicle Maintenance Program Totals
Deferred Comp. Contribution
$286,500.00
$0.00
$286,500.00
$22,459.34
$0.00
$212,093.87
$74,406.13
74%
$268,481.22
Unit 08 - Street Department Totals
$3,733,900.00
$0.00
$3,733,900.00
$359,064.73
$0.00
$2,232,164.70
$1,501,735.30
60%
$3,271,155.94
Unit 09 - Community Development Division 20 - Planning Program 1005
Salaries-Full Time
315,000.00
.00
315,000.00
26,159.48
.00
260,910.43
54,089.57
83
283,526.27
1045
Salaries-Commissioner
4,000.00
.00
4,000.00
130.00
.00
1,990.00
2,010.00
50
2,845.00
1800
Salaries-Overtime
2,500.00
.00
2,500.00
.00
.00
1,683.51
816.49
67
2,460.20
2000
FICA
20,000.00
.00
20,000.00
1,582.68
.00
15,975.25
4,024.75
80
17,019.71
2001
Medicare
4,700.00
.00
4,700.00
370.14
.00
3,736.11
963.89
79
3,980.48
2010
IMRF
35,000.00
.00
35,000.00
2,906.32
.00
29,174.54
5,825.46
83
31,198.33
2020
Employee Insurance
70,500.00
.00
70,500.00
5,854.05
.00
58,253.56
12,246.44
83
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
615.00
.00
3,675.64
3,324.36
53
2,567.00
3015
IL Unemployment Insurance
1,000.00
.00
1,000.00
.00
.00
406.91
593.09
41
639.03
4000
Telephone/Internet
3,000.00
.00
3,000.00
172.54
.00
1,815.70
1,184.30
61
2,047.16
4005
Cellular Phones/Pagers
1,800.00
.00
1,800.00
72.98
.00
583.83
1,216.17
32
1,166.60
5005
Office Supplies/Postage
10,500.00
.00
10,500.00
1,035.95
.00
9,598.49
901.51
91
11,811.79
5015
Dues & Subscriptions
3,000.00
.00
3,000.00
605.00
.00
4,791.67
(1,791.67)
160
3,393.54
5020
Gas/Oil/Mileage/Carwash
750.00
.00
750.00
.00
.00
47.60
702.40
6
.00
8035
Maintenance Contracts/Lease
3,500.00
.00
3,500.00
50.00
.00
400.00
3,100.00
11
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
78.50
.00
2,566.93
2,433.07
51
2,354.00
8097
Special Projects and Programs
15,000.00
.00
15,000.00
.00
.00
15,150.09
(150.09)
101
3,709.27
8135
Contractual Services
35,000.00
.00
35,000.00
.00
.00
1,919.00
33,081.00
5
1,691.84
8225
Engineering Fees
10,000.00
.00
10,000.00
.00
.00
4,108.75
5,891.25
41
4,446.24
$560,750.00
$0.00
$560,750.00
$39,632.64
$0.00
$416,788.01
$143,961.99
74%
$430,572.70
Division 20 - Planning Program Totals Division 21 - Building Program 1005
Salaries-Full Time
633,000.00
.00
633,000.00
44,466.17
.00
446,560.78
186,439.22
71
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
129.81
.00
609.37
4,390.63
12
141.22
2000
FICA
39,800.00
.00
39,800.00
2,652.45
.00
26,670.60
13,129.40
67
26,488.50
2001
Medicare
2010
IMRF
2020
Employee Insurance
2025
Deferred Comp. Contribution
3000
Travel/Training
Run by Colleen Thornton on 02/21/2018 02:32:35 PM
9,300.00
.00
9,300.00
620.34
.00
6,237.50
3,062.50
67
6,194.87
70,000.00
.00
70,000.00
4,965.74
.00
49,744.36
20,255.64
71
49,417.95
157,000.00
.00
157,000.00
11,893.97
.00
113,445.63
43,554.37
72
97,663.77
7,000.00
.00
7,000.00
.00
.00
.00
7,000.00
0
8,256.62
7,500.00
.00
7,500.00
61.39
.00
9,336.69
(1,836.69)
124
8,511.01
Page 13 of 27
Budget Performance Report Fiscal Year to Date 01/31/18 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,000.00
Fund 01 - General Fund EXPENSE Unit 09 - Community Development Division 21 - Building Program 3015
IL Unemployment Insurance
1,500.00
.00
1,500.00
.00
.00
795.90
704.10
53
4000
Telephone/Internet
1,500.00
.00
1,500.00
34.50
.00
420.87
1,079.13
28
409.44
4005
Cellular Phones/Pagers
6,000.00
.00
6,000.00
311.54
.00
2,490.75
3,509.25
42
3,500.04
5005
Office Supplies/Postage
13,000.00
.00
13,000.00
393.55
12.68
6,279.21
6,708.11
48
7,111.69
5015
Dues & Subscriptions
4,000.00
.00
4,000.00
145.00
.00
199.00
3,801.00
5
520.00
5020
Gas/Oil/Mileage/Carwash
1,000.00
.00
1,000.00
152.61
.00
767.39
232.61
77
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
.00
.00
1,529.00
(1,529.00)
+++
.00
46,500.00
.00
46,500.00
.00
.00
1,445.50
45,054.50
3
7,589.70
Division 21 - Building Program Totals
$1,008,000.00
$0.00
$1,008,000.00
$65,827.07
$12.68
$666,682.55
$341,304.77
66%
$655,541.31
Unit 09 - Community Development Totals
$1,568,750.00
$0.00
$1,568,750.00
$105,459.71
$12.68
$1,083,470.56
$485,266.76
69%
$1,086,114.01
5,500.00
.00
5,500.00
104.35
.00
1,363.28
4,136.72
25
681.34
341.00
.00
341.00
6.47
.00
84.53
256.47
25
35.36
80.00
.00
80.00
1.51
.00
19.76
60.24
25
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
375.00
225.00
62
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00
0
.00
10,000.00
.00
10,000.00
2,502.00
.00
7,873.50
2,126.50
79
8,037.55
Division 02 - Administration Program Totals
$20,521.00
$0.00
$20,521.00
$2,614.33
$0.00
$10,182.23
$10,338.77
50%
$9,270.33
Unit 50 - Police Commission Totals
$20,521.00
$0.00
$20,521.00
$2,614.33
$0.00
$10,182.23
$10,338.77
50%
$9,270.33
EXPENSE TOTALS
$24,784,315.00
$0.00
$24,784,315.00
$1,760,525.61
$32,948.83
$17,169,455.42
$7,581,910.75
69%
$24,076,613.56
REVENUE TOTALS
24,784,315.00
.00
24,784,315.00
1,543,365.65
.00
21,226,763.60
3,557,551.40
86%
24,282,991.21
EXPENSE TOTALS
24,784,315.00
.00
24,784,315.00
1,760,525.61
32,948.83
17,169,455.42
7,581,910.75
69%
24,076,613.56
Fund 01 - General Fund Totals
$0.00
$0.00
$0.00
($217,159.96)
($32,948.83)
$4,057,308.18
($4,024,359.35)
1,775,000.00
.00
1,775,000.00
148,371.32
.00
1,324,366.06
450,633.94
75
35,000.00
.00
35,000.00
2,210.00
.00
15,180.00
19,820.00
43
52,325.00
115
446,840.00 427,123.50
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
13,374.25
.00
323,233.03
(43,233.03)
0570.852
Sewer Connection Fee
280,000.00
.00
280,000.00
12,335.00
.00
214,851.50
65,148.50
77
0570.859
Sewer By-Pass Fee
8,000.00
.00
8,000.00
1,075.00
.00
8,385.00
(385.00)
105
12,040.00
0620.672
Water Sales
9,350,000.00
.00
9,350,000.00
685,404.44
.00
7,894,607.35
1,455,392.65
84
9,316,320.32
Run by Colleen Thornton on 02/21/2018 02:32:35 PM
1,745,967.81
Page 14 of 27
Budget Performance Report Fiscal Year to Date 01/31/18 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 REVENUE 0620.673
Water Penalty
0620.674
Sewer Sales
85,000.00
.00
85,000.00
7,636.07
.00
81,829.32
3,170.68
96
100,004.20
4,250,000.00
.00
4,250,000.00
324,163.16
.00
3,489,538.24
760,461.76
82
4,335,795.38
0620.675 0620.676
Sewer Penalty
45,000.00
.00
45,000.00
3,514.83
.00
36,780.59
8,219.41
82
47,432.36
Capital Charge
1,130,000.00
.00
1,130,000.00
88,701.19
.00
946,344.82
183,655.18
84
1,204,238.08
0620.677 0800.800
Capital Charge Penalty
15,000.00
.00
15,000.00
1,148.03
.00
10,466.46
4,533.54
70
15,006.20
Interest Income
24,382.00
.00
24,382.00
5,186.19
.00
49,918.80
(25,536.80)
205
0800.827
44,480.79
Unrealized Gain/Loss
.00
.00
.00
.00
.00
(5,233.72)
5,233.72
+++
(3,038.26)
0800.830
Unrealized Gain/Loss IMET
.00
.00
.00
(10,821.97)
.00
(12,261.68)
12,261.68
+++
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
468.00
.00
2,473.00
(1,973.00)
495
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
.00
.00
31,218.93
(6,218.93)
125
22,796.09
$17,302,882.00
$0.00
$17,302,882.00
$1,282,765.51
$0.00
$14,416,318.60
$2,886,563.40
83%
$18,177,763.03
245,000.00
.00
245,000.00
21,493.48
.00
213,684.67
31,315.33
87
236,158.35
15,200.00
.00
15,200.00
1,376.33
.00
13,013.19
2,186.81
86
14,288.25
3,600.00
.00
3,600.00
321.91
.00
3,124.89
475.11
87
3,456.90
87
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,524.58
.00
24,480.63
3,519.37
2020
Employee Insurance
46,000.00
.00
46,000.00
3,673.60
.00
36,144.46
9,855.54
79
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
152.00
.00
2,554.13
4,445.87
36
2,707.65
3015
IL Unemployment Insurance
2,500.00
.00
2,500.00
.00
.00
784.93
1,715.07
31
1,705.58
4000
Telephone/Internet
5,600.00
.00
5,600.00
472.24
.00
4,668.78
931.22
83
4,665.28
4005
Cellular Phones/Pagers
3,000.00
.00
3,000.00
315.58
.00
2,681.20
318.80
89
4,152.66
5005
Office Supplies/Postage
26,000.00
.00
26,000.00
2,650.86
.00
22,112.24
3,887.76
85
33,547.92
5015
Dues & Subscriptions
1,400.00
.00
1,400.00
83.00
.00
496.90
903.10
35
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
34.80
4.23
1,020.13
(524.36)
205
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 8135.008
800.00
.00
800.00
351.49
.00
423.99
376.01
53
1,384.07
150,000.00
.00
150,000.00
4,159.50
.00
47,657.03
102,342.97
32
131,727.54
8,000.00
.00
8,000.00
431.79
.00
8,586.80
(586.80)
107
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
Contractual Services
27,000.00
.00
27,000.00
2,538.77
.00
17,081.16
9,918.84
63
42,194.59
Settlement Charges
.00
.00
.00
.12
.00
.12
(.12)
+++
.00
Run by Colleen Thornton on 02/21/2018 02:32:35 PM
Page 15 of 27
Budget Performance Report Fiscal Year to Date 01/31/18 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
139.64
360.36
28
4,000.00
.00
4,000.00
2,042.76
.00
7,341.33
(3,341.33)
184
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
62,500.00
62,500.00
50
125,000.00
Transfer to Debt Service
244,825.00
.00
244,825.00
.00
.00
244,825.00
.00
100
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
$42,622.81
$4.23
$713,397.22
$244,523.55
74%
$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.27
.00
244,596.77
165,403.23
60
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
6,974.24
.00
32,609.52
2,390.48
93
31,515.55
2000
FICA
29,000.00
.00
29,000.00
1,844.75
.00
16,894.19
12,105.81
58
26,731.62
2001
Medicare
6,800.00
.00
6,800.00
431.44
.00
3,984.80
2,815.20
59
6,299.58
2010
IMRF
53,000.00
.00
53,000.00
3,376.18
.00
30,175.20
22,824.80
57
47,881.94
2020
Employee Insurance
70,975.00
.00
70,975.00
4,638.89
.00
44,440.01
26,534.99
63
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
734.59
.00
7,506.34
1,493.66
83
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
9,281.31
.00
51,527.82
88,472.18
37
123,565.62
5005
Office Supplies/Postage
2,000.00
.00
2,000.00
.00
.00
154.79
1,845.21
8
199.91
5010
Replacement Supplies
5,000.00
.00
5,000.00
24.37
.00
2,961.13
2,038.87
59
7,017.40
5020
Gas/Oil/Mileage/Carwash
15,000.00
.00
15,000.00
753.95
.00
7,683.14
7,316.86
51
8,602.27
5040
Supplies/Hardware
4,000.00
.00
4,000.00
797.03
.00
6,858.40
(2,858.40)
171
5,485.05
5070
Chemicals
5,500.00
.00
5,500.00
.00
.00
4,149.38
1,350.62
75
5,379.54
5095
Uniforms/Clothing
2,000.00
.00
2,000.00
131.35
.00
1,331.24
668.76
67
5,327.56
8020
Building Maintenance
4,000.00
.00
4,000.00
72.75
.00
404.32
3,595.68
10
2,772.26
8060
Vehicle Maintenance
6,500.00
.00
6,500.00
.00
.00
3,458.42
3,041.58
53
6,089.99
8135
Contractual Services
40,000.00
.00
40,000.00
11,038.59
7,071.90
25,140.86
7,787.24
81
53,499.34
8135.003
Lake Michigan Water Purchase
8,403,000.00
.00
8,403,000.00
.00
.00
5,762,634.88
2,640,365.12
69
8,471,988.46
8160
Equipment Maintenance
9,000.00
.00
9,000.00
1,936.85
.00
11,199.66
(2,199.66)
124
12,096.38
8185
System Maintenance
44,000.00
.00
44,000.00
2,034.00
4,964.28
5,468.24
33,567.48
24
49,419.05
8194
Water/Fire Hydrant
20,000.00
.00
20,000.00
.00
.00
18,977.27
1,022.73
95
19,074.73
8200
EPA Analytical
16,000.00
.00
16,000.00
.00
.00
9,961.37
6,038.63
62
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 02/21/2018 02:32:35 PM
244,825.00
.00
244,825.00
.00
.00
244,825.00
.00
100
242,725.00
$9,604,100.00
$0.00
$9,604,100.00
$68,564.56
$12,036.18
$6,545,702.33
$3,046,361.49
68%
$8,295,068.12
Page 16 of 27
Budget Performance Report Fiscal Year to Date 01/31/18 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
$111,187.37
$12,040.41
$7,259,099.55
$3,290,885.04
69%
$12,358,091.95
245,000.00
.00
245,000.00
18,335.10
.00
183,559.77
61,440.23
75
235,196.83
15,200.00
.00
15,200.00
1,173.50
.00
11,132.61
4,067.39
73
14,291.42
3,600.00
.00
3,600.00
274.43
.00
2,684.56
915.44
75
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,154.06
.00
21,033.33
6,966.67
75
27,356.16
2020
Employee Insurance
46,000.00
.00
46,000.00
2,910.98
.00
28,896.05
17,103.95
63
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
.00
.00
4,969.13
7,030.87
41
5,191.84
3015
IL Unemployment Insurance
2,500.00
.00
2,500.00
.00
.00
522.92
1,977.08
21
1,705.54
4000
Telephone/Internet
9,000.00
.00
9,000.00
734.59
.00
8,844.61
155.39
98
11,908.89
4005
Cellular Phones/Pagers
3,500.00
.00
3,500.00
184.62
.00
1,751.12
1,748.88
50
2,973.50
5005
Office Supplies/Postage
25,000.00
.00
25,000.00
2,803.66
.00
21,042.92
3,957.08
84
31,332.15
5015
Dues & Subscriptions
68,200.00
.00
68,200.00
.00
.00
64,376.89
3,823.11
94
60,535.73
5020
Gas/Oil/Mileage/Carwash
1,000.00
.00
1,000.00
.00
.00
30.00
970.00
3
299.18
5040
Supplies/Hardware
2,500.00
.00
2,500.00
403.17
4.23
1,026.93
1,468.84
41
510.72
8020
Building Maintenance
15,000.00
.00
15,000.00
598.17
.00
11,215.62
3,784.38
75
17,449.12
8065
Legal Fees
8135
Contractual Services
8135.008
Settlement Charges
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,074.25
.00
13,362.37
16,637.63
45
39,619.85 .00
.00
.00
.00
.12
.00
.12
(.12)
+++
2,000.00
.00
2,000.00
360.44
.00
952.43
1,047.57
48
.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
384,000.00
(344,160.00)
964
340,500.00
2013 Refunding-2004A Bond (Interest)
384,000.00
.00
384,000.00
.00
.00
39,840.00
344,160.00
10
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
62,500.00
62,500.00
50
125,000.00
9905
Transfer to Debt Service
244,825.00
.00
244,825.00
.00
.00
244,825.00
.00
100
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
$31,007.09
$4.23
$1,107,206.46
$216,454.31
84%
$1,280,217.34
Division 02 - Administration Program Totals
Run by Colleen Thornton on 02/21/2018 02:32:35 PM
Page 17 of 27
Budget Performance Report Fiscal Year to Date 01/31/18 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 1005
Salaries-Full Time
385,000.00
.00
385,000.00
28,071.29
.00
285,647.23
99,352.77
74
410,779.62
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
5,282.23
.00
23,823.98
6,176.02
79
26,852.08
2000
FICA
26,500.00
.00
26,500.00
1,953.79
.00
18,862.43
7,637.57
71
27,242.55
2001
Medicare
6,500.00
.00
6,500.00
456.89
.00
4,441.75
2,058.25
68
6,414.31
2010
IMRF
46,000.00
.00
46,000.00
3,594.08
.00
33,759.21
12,240.79
73
48,877.78
2020
Employee Insurance
56,000.00
.00
56,000.00
4,053.62
.00
40,445.83
15,554.17
72
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,784.00
.00
18,570.83
3,429.17
84
19,797.10
4015
Electricity/Gas
525,000.00
.00
525,000.00
37,213.58
.00
305,298.58
219,701.42
58
519,785.43
5005
Office Supplies/Postage
4,500.00
.00
4,500.00
.00
.00
362.60
4,137.40
8
841.27
5010
Replacement Supplies
1,500.00
.00
1,500.00
47.58
.00
2,445.77
(945.77)
163
2,084.97
5020
Gas/Oil/Mileage/Carwash
13,000.00
.00
13,000.00
29.55
.00
7,292.37
5,707.63
56
8,249.45
5040
Supplies/Hardware
10,000.00
.00
10,000.00
473.86
.00
7,196.68
2,803.32
72
10,856.84
5070
Chemicals
115,000.00
.00
115,000.00
10,323.17
4,081.83
64,283.95
46,634.22
59
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
72.00
.00
1,606.50
16,393.50
9
1,971.00
5095
Uniforms/Clothing
5,000.00
.00
5,000.00
348.95
.00
3,496.17
1,503.83
70
8,908.79
8060
Vehicle Maintenance
8,000.00
.00
8,000.00
.00
.00
9,076.45
(1,076.45)
113
3,473.22
8135
Contractual Services
160,000.00
.00
160,000.00
51,326.60
.00
118,426.54
41,573.46
74
214,685.35
8160
Equipment Maintenance
20,000.00
.00
20,000.00
2,289.18
.00
16,082.92
3,917.08
80
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
3,985.29
.00
22,042.48
102,957.52
18
55,506.10
9905
Transfer to Debt Service
244,825.00
.00
244,825.00
.00
.00
244,825.00
.00
100
242,725.00
Division 40 - Sewer Treatment Program Totals
$1,850,825.00
$0.00
$1,850,825.00
$151,305.66
$4,081.83
$1,236,746.83
$609,996.34
67%
$1,838,136.11
Unit 11 - Sewer Department Totals
$3,174,490.00
$0.00
$3,174,490.00
$182,312.75
$4,086.06
$2,343,953.29
$826,450.65
74%
$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
88,133.61
11,866.39
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
175.00
.00
202,398.75
(202,398.75)
+++
56,524.82
8135
Contractual Services
210,000.00
.00
210,000.00
.00
.00
13,918.00
196,082.00
7
.00
8225
Engineering Fees
150,000.00
.00
150,000.00
30,628.72
.00
85,118.08
64,881.92
57
40,152.25
9120
Machinery and Equipment
.00
.00
.00
.00
.00
5,996.80
(5,996.80)
+++
12,894.14
9125
Vehicles
180,000.00
.00
180,000.00
.00
.00
156,835.00
23,165.00
87
.00
Run by Colleen Thornton on 02/21/2018 02:32:35 PM
Page 18 of 27
Budget Performance Report Fiscal Year to Date 01/31/18 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
$830,000.00
$0.00
$830,000.00
$30,803.72
$0.00
$552,400.24
$277,599.76
67%
$1,402,943.55
Fund 02 - Water and Sewer Fund EXPENSE Unit 12 - Utility Expansion Division 91 - Capital Totals Division 92 - Bonds 9200.012
2013 Refunding-2004A Bond (Principal)
896,000.00
.00
896,000.00
.00
.00
896,000.00
.00
100
794,500.00
9200.013
2013 Refunding-2004A Bond (Interest)
92,960.00
.00
92,960.00
.00
.00
92,960.00
.00
100
100,337.50
9200.014
2013 Refunding-2004B Bond (Principal)
375,000.00
.00
375,000.00
.00
.00
375,000.00
.00
100
365,000.00
9200.015
2013 Refunding-2004B Bond (Interest)
38,650.00
.00
38,650.00
.00
.00
38,650.00
.00
100
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
.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
.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
157,419.46
999.54
99
155,470.01
9201.002
IEPA Loan (Interest)
30,588.00
.00
30,588.00
.00
.00
30,587.64
.36
100
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
$0.00
$0.00
$1,867,992.10
$868,374.90
68%
$415,530.68
Unit 12 - Utility Expansion Totals
$3,566,367.00
$0.00
$3,566,367.00
$30,803.72
$0.00
$2,420,392.34
$1,145,974.66
68%
$1,818,474.23
EXPENSE TOTALS
$17,302,882.00
$0.00
$17,302,882.00
$324,303.84
$16,126.47
$12,023,445.18
$5,263,310.35
70%
$17,294,919.63
REVENUE TOTALS
17,302,882.00
.00
17,302,882.00
1,282,765.51
.00
14,416,318.60
2,886,563.40
83%
18,177,763.03
EXPENSE TOTALS
17,302,882.00
.00
17,302,882.00
324,303.84
16,126.47
12,023,445.18
5,263,310.35
70%
17,294,919.63
Fund 02 - Water and Sewer Fund Totals
$0.00
$0.00
$0.00
$958,461.67
($16,126.47)
$2,392,873.42
($2,376,746.95)
Fund 02 - Water and Sewer Fund Totals
$882,843.40
Fund 03 - Capital Replacement Fund REVENUE 0800.800
Interest Income
.00
.00
.00
2,137.84
.00
20,793.76
(20,793.76)
+++
0800.826
Realized Gain/Loss On Investment
.00
.00
.00
.00
.00
.00
.00
+++
12.64
0800.827
Unrealized Gain/Loss
.00
.00
.00
.00
.00
(2,536.51)
2,536.51
+++
(9,699.66)
$0.00
$0.00
$0.00
$2,137.84
$0.00
$18,257.25
($18,257.25)
+++
$14,602.22
REVENUE TOTALS
.00
.00
.00
2,137.84
.00
18,257.25
(18,257.25)
+++
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,137.84
$0.00
$18,257.25
($18,257.25)
1,150,000.00
.00
1,150,000.00
87,460.07
.00
812,761.95
337,238.05
71
1,105,593.51
5,000.00
.00
5,000.00
3,167.76
.00
26,821.85
(21,821.85)
536
15,410.91
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
Run by Colleen Thornton on 02/21/2018 02:32:35 PM
Page 19 of 27
Budget Performance Report Fiscal Year to Date 01/31/18 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
$1,155,000.00
$0.00
$1,155,000.00
$90,627.83
$0.00
$839,583.80
$315,416.20
73%
$1,121,004.42
1,005,000.00
.00
1,005,000.00
4,556.52
.00
1,038,056.85
(33,056.85)
103
863,120.29
Division 91 - Capital Totals
$1,005,000.00
$0.00
$1,005,000.00
$4,556.52
$0.00
$1,038,056.85
($33,056.85)
103%
$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
$4,556.52
$0.00
$1,038,056.85
$116,943.15
90%
$863,120.29
EXPENSE TOTALS
$1,155,000.00
$0.00
$1,155,000.00
$4,556.52
$0.00
$1,038,056.85
$116,943.15
90%
$863,120.29
REVENUE TOTALS
1,155,000.00
.00
1,155,000.00
90,627.83
.00
839,583.80
315,416.20
73%
1,121,004.42
EXPENSE TOTALS
1,155,000.00
.00
1,155,000.00
4,556.52
.00
1,038,056.85
116,943.15
90%
Fund 04 - Motor Fuel Tax Totals
$0.00
$0.00
$0.00
$86,071.31
$0.00
($198,473.05)
$198,473.05
112,600.00
.00
112,600.00
.00
.00
118,518.93
(5,918.93)
105
500.00
.00
500.00
2.48
.00
6,279.45
(5,779.45)
1256
797.83
979,300.00
.00
979,300.00
.00
.00
979,300.00
.00
100
970,900.00
Account Description
Budget - YTD % Used/
Fund 04 - Motor Fuel Tax EXPENSE Unit 00 - Non-Departmental Division 91 - Capital 9150
Street Improvements 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
2,023,992.04
12,132.96
99
2,032,264.47
$3,128,525.00
$0.00
$3,128,525.00
$2.48
$0.00
$3,128,090.42
$434.58
100%
$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
755,000.00
.00
100
9200.021
2007 Bond (Interest)
42,475.00
.00
42,475.00
.00
.00
42,475.00
.00
100
75,100.00
9200.024
2009 Refunding Bond (Principal)
100,000.00
.00
100,000.00
.00
.00
100,000.00
.00
100
100,000.00
9200.025
2009 Refunding Bond (Interest)
12,600.00
.00
12,600.00
.00
.00
12,600.00
.00
100
16,100.00
9200.026
2010 Bond (Principal)
750,000.00
.00
750,000.00
.00
.00
750,000.00
.00
100
720,000.00
9200.027
2010 Bond (Interest)
229,300.00
.00
229,300.00
.00
.00
229,300.00
.00
100
250,900.00
9200.028
2012 Refunding Bond (Principal)
660,000.00
.00
660,000.00
.00
.00
660,000.00
.00
100
645,000.00
9200.029
2012 Refunding Bond (Interest)
175,200.00
.00
175,200.00
.00
.00
175,200.00
.00
100
188,100.00
9200.030
2014 Refunding- 2007 Bond (Principal)
130,000.00
.00
130,000.00
.00
.00
130,000.00
.00
100
125,000.00
9200.031
2014 Refunding- 2007 Bond (Interest)
273,450.00
.00
273,450.00
.00
.00
273,450.00
.00
100
275,950.00
Division 92 - Bonds Totals
$3,128,025.00
$0.00
$3,128,025.00
$0.00
$0.00
$3,128,025.00
$0.00
100%
$3,121,150.00
Unit 00 - Non-Departmental Totals
$3,128,025.00
$0.00
$3,128,025.00
$0.00
$0.00
$3,128,025.00
$0.00
100%
$3,121,150.00
EXPENSE TOTALS
$3,128,025.00
$0.00
$3,128,025.00
$0.00
$0.00
$3,128,025.00
$0.00
100%
$3,121,150.00
Run by Colleen Thornton on 02/21/2018 02:32:35 PM
Page 20 of 27
Budget Performance Report Fiscal Year to Date 01/31/18 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
2.48
.00
3,128,090.42
434.58
100%
3,121,176.12
EXPENSE TOTALS
3,128,025.00
.00
3,128,025.00
.00
.00
3,128,025.00
.00
100%
3,121,150.00
Fund 05 - Bond and Interest Fund Totals
$500.00
$0.00
$500.00
$2.48
$0.00
$65.42
$434.58
625,000.00
.00
625,000.00
.00
.00
623,114.32
1,885.68
100
621,534.63
100.00
.00
100.00
318.99
.00
1,380.97
(1,280.97)
1381
164.54
.00
.00
.00
.00
.00
.00
.00
+++
55.00
$625,100.00
$0.00
$625,100.00
$318.99
$0.00
$624,495.29
$604.71
100%
$621,754.17
500.00
.00
500.00
.00
.00
336.00
164.00
67
336.00
280,000.00
.00
280,000.00
.00
.00
156,425.00
123,575.00
56
268,633.00
Account Description
Budget - YTD % Used/
Fund 05 - Bond and Interest Fund Totals
$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
$0.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
$0.00
$0.00
$378,101.00
$246,999.00
60%
$594,821.00
EXPENSE TOTALS
$625,100.00
$0.00
$625,100.00
$0.00
$0.00
$378,101.00
$246,999.00
60%
$594,821.00
REVENUE TOTALS
625,100.00
.00
625,100.00
318.99
.00
624,495.29
604.71
100%
621,754.17
EXPENSE TOTALS
625,100.00
.00
625,100.00
.00
.00
378,101.00
246,999.00
60%
594,821.00
Fund 07 - Tort Immunity Fund Totals
$0.00
$0.00
$0.00
$318.99
$0.00
$246,394.29
($246,394.29)
42,000.00
.00
42,000.00
.00
.00
42,273.77
(273.77)
101
50.00
.00
50.00
17.36
.00
178.07
(128.07)
356
72.05
REVENUE TOTALS
$42,050.00
$0.00
$42,050.00
$17.36
$0.00
$42,451.84
($401.84)
101%
$42,323.83
42,000.00
.00
42,000.00
.00
.00
35,875.00
6,125.00
85
39,142.00
Division 00 - Non-Divisional Totals
$42,000.00
$0.00
$42,000.00
$0.00
$0.00
$35,875.00
$6,125.00
85%
$39,142.00
Unit 00 - Non-Departmental Totals
$42,000.00
$0.00
$42,000.00
$0.00
$0.00
$35,875.00
$6,125.00
85%
$39,142.00
EXPENSE TOTALS
$42,000.00
$0.00
$42,000.00
$0.00
$0.00
$35,875.00
$6,125.00
85%
$39,142.00
REVENUE TOTALS
42,050.00
.00
42,050.00
17.36
.00
42,451.84
(401.84)
101%
42,323.83
EXPENSE TOTALS
42,000.00
.00
42,000.00
.00
.00
35,875.00
6,125.00
85%
39,142.00
Fund 08 - Audit Fund Totals
$50.00
$0.00
$50.00
$17.36
$0.00
$6,576.84
($6,526.84)
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 02/21/2018 02:32:35 PM
$3,181.83
Page 21 of 27
Budget Performance Report Fiscal Year to Date 01/31/18 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
84.13
.00
1,056,445.07
(556,445.07)
211
784,139.57
0800.824
Realized Gain/Loss-SawyerFalduto
.00
.00
.00
.00
.00
96,495.70
(96,495.70)
+++
(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,109,655.92
(1,109,655.92)
+++
1,646,913.00
0818.000
Employee Contributions
575,000.00
.00
575,000.00
.00
.00
342,244.39
232,755.61
60
509,526.26
0819.000
Employer Contributions
1,370,000.00
.00
1,370,000.00
.00
.00
1,364,479.09
5,520.91
100
1,101,142.15
$2,920,000.00
$0.00
$2,920,000.00
$84.13
$0.00
$3,969,320.17
($1,049,320.17)
136%
$3,974,855.25
5,000.00
.00
5,000.00
.00
.00
3,197.25
1,802.75
64
4,169.95
500.00
.00
500.00
.00
.00
.00
500.00
0
.00
(240.25)
104
5,560.27 32,081.70
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
5,740.25
8135
Contractual Services
30,000.00
.00
30,000.00
3,635.00
.00
24,754.60
5,245.40
83
8137
Investment Expense
85,000.00
.00
85,000.00
.00
.00
48,523.00
36,477.00
57
87,300.00
8330
Pension Payments
485,000.00
.00
485,000.00
41,444.93
.00
368,590.29
116,409.71
76
442,742.40
Division 00 - Non-Divisional Totals
$611,000.00
$0.00
$611,000.00
$45,079.93
$0.00
$450,805.39
$160,194.61
74%
$571,854.32
Unit 00 - Non-Departmental Totals
$611,000.00
$0.00
$611,000.00
$45,079.93
$0.00
$450,805.39
$160,194.61
74%
$571,854.32
EXPENSE TOTALS
$611,000.00
$0.00
$611,000.00
$45,079.93
$0.00
$450,805.39
$160,194.61
74%
$571,854.32
REVENUE TOTALS
2,920,000.00
.00
2,920,000.00
84.13
.00
3,969,320.17
(1,049,320.17)
136%
3,974,855.25
EXPENSE TOTALS
611,000.00
.00
611,000.00
45,079.93
.00
450,805.39
160,194.61
74%
Fund 10 - Police Pension Fund Totals
$2,309,000.00
$0.00
$2,309,000.00
($44,995.80)
$0.00
$3,518,514.78
($1,209,514.78)
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
296,787.16
.00
2,149,129.48
750,870.52
74
3,492,459.42
0500.502
Utility Tax
2,800,000.00
.00
2,800,000.00
256,786.98
.00
2,044,177.80
755,822.20
73
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
.00
.00
3,897.91
1,102.09
78
10,030.89
0650.670
Impound Fee
30,000.00
.00
30,000.00
2,250.00
.00
19,500.00
10,500.00
65
22,852.50
0650.673
Daily Storage Fee for Impound
5,000.00
.00
5,000.00
130.00
.00
990.00
4,010.00
20
1,475.00
0650.675
Red Light Fines
255,000.00
.00
255,000.00
30,500.39
.00
302,000.00
(47,000.00)
118
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
12,569.57
.00
91,874.65
(59,988.65)
288
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
311,801.75
.00
668,175.57
5,131,824.43
12
95,942.30
Run by Colleen Thornton on 02/21/2018 02:32:35 PM
Page 22 of 27
Budget Performance Report Fiscal Year to Date 01/31/18 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
.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
$910,825.85
$0.00
$5,279,920.41
$8,791,204.59
38%
$10,258,977.98
110,000.00
.00
110,000.00
18,424.92
.00
64,645.18
45,354.82
59
110,742.39
Division 00 - Non-Divisional Totals
$110,000.00
$0.00
$110,000.00
$18,424.92
$0.00
$64,645.18
$45,354.82
59%
$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
168,012.00
31,988.00
84
279,983.00
8225
Engineering Fees
100,000.00
.00
100,000.00
.00
.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
.00
.00
322,660.69
177,339.31
65
163,591.79
9120.005
Machinery and Equipment-Police
225,000.00
.00
225,000.00
1,725.00
11,068.22
176,319.80
37,611.98
83
231,378.31
9120.008
Machinery and Equipment-Public Works
325,000.00
.00
325,000.00
165,644.00
.00
270,905.77
54,094.23
83
303,607.42
9152.001
Street Lights-Replacement
125,000.00
.00
125,000.00
.00
124,473.00
.00
527.00
100
74,735.42
9152.002
School Beacon Upgrades
5,000.00
.00
5,000.00
.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
.00
.00
60,156.02
29,843.98
67
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
25,362.83
.00
625,654.70
5,174,345.30
11
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
14,719.56
.00
14,719.56
410,280.44
3
.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
.00
.00
115,855.00
9,145.00
93
74,678.34
9165
Roadway Improvements
1,000,000.00
.00
1,000,000.00
.00
.00
1,047,173.84
(47,173.84)
105
485,235.47
9165.009
143rd St. Extension Phase 2
1,400,000.00
.00
1,400,000.00
31,327.31
.00
181,435.08
1,218,564.92
13
711,301.02
9165.019
I-55 Interchange Design
320,000.00
.00
320,000.00
.00
.00
170,287.42
149,712.58
53
33,290.79
9165.028
Renwick Corridor
70,000.00
.00
70,000.00
290.00
.00
15,777.54
54,222.46
23
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
19,289.01
.00
562,135.33
117,864.67
83
263,729.61
9165.031
Village Green
130,000.00
.00
130,000.00
6,063.75
.00
19,815.24
110,184.76
15
2,642.63
$11,925,000.00
$0.00
$11,925,000.00
$264,421.46
$139,008.22
$3,848,713.84
$7,937,277.94
33%
$3,495,786.37
2,036,125.00
.00
2,036,125.00
.00
.00
2,023,992.04
12,132.96
99
2,032,264.47
Division 91 - Capital Totals Division 99 - Transfers 9905
Transfer to Debt Service
Run by Colleen Thornton on 02/21/2018 02:32:35 PM
Page 23 of 27
Budget Performance Report Fiscal Year to Date 01/31/18 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
$2,023,992.04
$12,132.96
99%
$2,032,264.47
Unit 00 - Non-Departmental Totals
$14,071,125.00
$0.00
$14,071,125.00
$282,846.38
$139,008.22
$5,937,351.06
$7,994,765.72
43%
$5,638,793.23
EXPENSE TOTALS
$14,071,125.00
$0.00
$14,071,125.00
$282,846.38
$139,008.22
$5,937,351.06
$7,994,765.72
43%
$5,638,793.23
REVENUE TOTALS
14,071,125.00
.00
14,071,125.00
910,825.85
.00
5,279,920.41
8,791,204.59
38%
10,258,977.98
EXPENSE TOTALS
14,071,125.00
.00
14,071,125.00
282,846.38
139,008.22
5,937,351.06
7,994,765.72
43%
Fund 11 - Capital Improvement Fund Totals
$0.00
$0.00
$0.00
$627,979.47
($139,008.22)
($657,430.65)
$796,438.87
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
17.31
.00
66.39
(46.39)
332
44.93
20,000.00
.00
20,000.00
.00
.00
22,319.53
(2,319.53)
112
18,294.57
REVENUE TOTALS
$20,020.00
$0.00
$20,020.00
$17.31
$0.00
$22,385.92
($2,365.92)
112%
$18,339.50
20,000.00
.00
20,000.00
299.99
.00
5,342.44
14,657.56
27
21,529.69
Division 00 - Non-Divisional Totals
$20,000.00
$0.00
$20,000.00
$299.99
$0.00
$5,342.44
$14,657.56
27%
$21,529.69
Unit 00 - Non-Departmental Totals
$20,000.00
$0.00
$20,000.00
$299.99
$0.00
$5,342.44
$14,657.56
27%
$21,529.69
EXPENSE TOTALS
$20,000.00
$0.00
$20,000.00
$299.99
$0.00
$5,342.44
$14,657.56
27%
$21,529.69
REVENUE TOTALS
20,020.00
.00
20,020.00
17.31
.00
22,385.92
(2,365.92)
112%
18,339.50
EXPENSE TOTALS
20,000.00
.00
20,000.00
299.99
.00
5,342.44
14,657.56
27%
Fund 14 - D.A.R.E. Fund Totals
$20.00
$0.00
$20.00
($282.68)
$0.00
$17,043.48
($17,023.48)
745,000.00
.00
745,000.00
.00
.00
718,508.33
26,491.67
96
2,000.00
.00
2,000.00
469.57
.00
6,340.29
(4,340.29)
317
5,190.49
REVENUE TOTALS
$747,000.00
$0.00
$747,000.00
$469.57
$0.00
$724,848.62
$22,151.38
97%
$742,112.55
.00
.00
.00
.00
.00
359.40
(359.40)
+++
.00
Division 00 - Non-Divisional Totals
$0.00
$0.00
$0.00
$0.00
$0.00
$359.40
($359.40)
+++
$0.00
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
736,922.06
EXPENSE Unit 00 - Non-Departmental Division 00 - Non-Divisional 8135
Contractual Services Division 91 - Capital
8135
Contractual Services
450,000.00
.00
450,000.00
117,047.62
.00
754,058.93
(304,058.93)
168
429,675.92
9199
Facade Improvements
125,000.00
.00
125,000.00
.00
.00
127,118.46
(2,118.46)
102
157,162.33
Run by Colleen Thornton on 02/21/2018 02:32:35 PM
Page 24 of 27
Budget Performance Report Fiscal Year to Date 01/31/18 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
$575,000.00
$0.00
$575,000.00
$117,047.62
$0.00
$881,177.39
($306,177.39)
153%
$586,838.25
Fund 17 - Tax Increment Financing Fund EXPENSE Unit 00 - Non-Departmental Division 91 - Capital Totals Division 99 - Transfers 9901
Transfer to General
9911
Transfer to Capital Improvements
50,000.00
.00
50,000.00
.00
.00
.00
50,000.00
0
.00
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
$117,047.62
$0.00
$881,536.79
$243,463.21
78%
$1,086,838.25
EXPENSE TOTALS
$1,125,000.00
$0.00
$1,125,000.00
$117,047.62
$0.00
$881,536.79
$243,463.21
78%
$1,086,838.25
REVENUE TOTALS
747,000.00
.00
747,000.00
469.57
.00
724,848.62
22,151.38
97%
742,112.55
EXPENSE TOTALS
1,125,000.00
.00
1,125,000.00
117,047.62
.00
881,536.79
243,463.21
78%
1,086,838.25
Fund 17 - Tax Increment Financing Fund Totals
($378,000.00)
$0.00
($378,000.00)
($116,578.05)
$0.00
($156,688.17)
($221,311.83)
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
100.00
.00
1,040.00
(1,040.00)
+++
0800.800
Interest Income
.00
.00
.00
2.57
.00
17.40
(17.40)
+++
950.00 9.11
REVENUE TOTALS
$0.00
$0.00
$0.00
$102.57
$0.00
$1,057.40
($1,057.40)
+++
$959.11
.00
.00
.00
280.00
.00
700.00
(700.00)
+++
1,015.00
Division 00 - Non-Divisional Totals
$0.00
$0.00
$0.00
$280.00
$0.00
$700.00
($700.00)
+++
$1,015.00
Unit 00 - Non-Departmental Totals
$0.00
$0.00
$0.00
$280.00
$0.00
$700.00
($700.00)
+++
$1,015.00
EXPENSE TOTALS
$0.00
$0.00
$0.00
$280.00
$0.00
$700.00
($700.00)
+++
$1,015.00
REVENUE TOTALS
.00
.00
.00
102.57
.00
1,057.40
(1,057.40)
+++
959.11
EXPENSE TOTALS
.00
.00
.00
280.00
.00
700.00
(700.00)
+++
1,015.00
Fund 26 - Sex Offender's Registration Fund Totals
$0.00
$0.00
$0.00
($177.43)
$0.00
$357.40
($357.40)
15,000.00
.00
15,000.00
1,650.00
.00
11,492.00
3,508.00
77
100.00
.00
100.00
53.93
.00
369.98
(269.98)
370
207.30
$15,100.00
$0.00
$15,100.00
$1,703.93
$0.00
$11,861.98
$3,238.02
79%
$16,852.30
20,000.00
.00
20,000.00
.00
.00
.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 REVENUE TOTALS
16,645.00
EXPENSE Unit 00 - Non-Departmental Division 99 - Transfers 9901
Transfer to General
Run by Colleen Thornton on 02/21/2018 02:32:35 PM
Page 25 of 27
Budget Performance Report Fiscal Year to Date 01/31/18 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 27 - Alcohol Enforcement Fund EXPENSE Unit 00 - Non-Departmental 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 TOTALS
$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
1,703.93
.00
11,861.98
3,238.02
79%
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)
$1,703.93
$0.00
$11,861.98
($16,761.98)
Fund 27 - Alcohol Enforcement Fund Totals
$4,852.30
Fund 28 - Drug Enforcement Fund REVENUE 0600.611
Drug Fines
.00
.00
.00
969.00
.00
1,277.00
(1,277.00)
+++
0800.800
Interest Income
.00
.00
.00
41.74
.00
303.95
(303.95)
+++
172.97
$0.00
$0.00
$0.00
$1,010.74
$0.00
$1,580.95
($1,580.95)
+++
$920.97
REVENUE TOTALS
.00
.00
.00
1,010.74
.00
1,580.95
(1,580.95)
+++
920.97
EXPENSE TOTALS
.00
.00
.00
.00
.00
.00
.00
+++
Fund 28 - Drug Enforcement Fund Totals
$0.00
$0.00
$0.00
$1,010.74
$0.00
$1,580.95
($1,580.95)
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
3,065.00
.00
26,052.00
(26,052.00)
+++
32,454.00
0800.800
Interest Income
.00
.00
.00
196.70
.00
1,349.47
(1,349.47)
+++
650.77
0805.000
Other Reimbursements
.00
.00
.00
7,450.00
.00
7,450.00
(7,450.00)
+++
.00
$0.00
$0.00
$0.00
$10,711.70
$0.00
$34,851.47
($34,851.47)
+++
$33,104.77
REVENUE TOTALS
.00
.00
.00
10,711.70
.00
34,851.47
(34,851.47)
+++
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
$10,711.70
$0.00
$34,851.47
($34,851.47)
REVENUE TOTALS Fund 29 - Police Vehicle Replacement Fund Totals
.00 $33,104.77
Fund 40 - PEMA Fund REVENUE 0800.800
Interest Income
.00
.00
.00
21.08
.00
147.79
(147.79)
+++
80.73
0801.822
Donation/Contribution
.00
.00
.00
.00
.00
3,000.00
(3,000.00)
+++
4,757.69
$0.00
$0.00
$0.00
$21.08
$0.00
$3,147.79
($3,147.79)
+++
$4,838.42
.00
.00
.00
.00
.00
2,347.00
(2,347.00)
+++
.00
REVENUE TOTALS EXPENSE Unit 00 - Non-Departmental Division 00 - Non-Divisional 9140
PEMA Fundraising
Run by Colleen Thornton on 02/21/2018 02:32:35 PM
Page 26 of 27
Budget Performance Report Fiscal Year to Date 01/31/18 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 40 - PEMA Fund EXPENSE Unit 00 - Non-Departmental 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
REVENUE TOTALS
.00
.00
.00
21.08
.00
3,147.79
(3,147.79)
+++
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
$21.08
$0.00
$800.79
($800.79)
REVENUE TOTALS
64,811,117.00
.00
64,811,117.00
3,844,182.54
.00
50,344,935.51
14,466,181.49
78%
62,432,575.85
EXPENSE TOTALS
62,884,447.00
.00
62,884,447.00
2,534,939.89
188,083.52
41,051,041.13
21,645,322.35
66%
53,321,796.97
Grand Totals
$1,926,670.00
$0.00
$1,926,670.00
$1,309,242.65
($188,083.52)
$9,293,894.38
($7,179,140.86)
Fund 40 - PEMA Fund Totals .00 $4,838.42
Grand Totals
Run by Colleen Thornton on 02/21/2018 02:32:35 PM
$9,110,778.88
Page 27 of 27
