Fillable Form 08182015 2. Pledge Of Allegiance 1. Call To Order (Village of Sugar Grove)

Fill Online, Printable, Fillable, Blank Form 08182015 2. Pledge Of Allegiance 1. Call To Order (Village of Sugar Grove) Form

Use Fill to complete blank online VILLAGE OF SUGAR GROVE (IL) pdf forms for free. Once completed you can sign your fillable form or send for signing. All forms are printable and downloadable.

Form 08182015 2. Pledge Of Allegiance 1. Call To Order (Village of Sugar Grove)

On average this form takes 70 minutes to complete

The Form 08182015 2. Pledge Of Allegiance 1. Call To Order (Village of Sugar Grove) form is 99 pages long and contains:

  • 0 signatures
  • 0 check-boxes
  • 280 other fields

Country of origin: US
File type: PDF

U.S.A. forms for Village of Sugar Grove

BROWSE VILLAGE OF SUGAR GROVE (IL) FORMS

Related forms
Fill has a huge library of thousands of forms all set up to be filled in easily and signed.
Fill in your chosen form
Sign the form using our drawing tool
Send to someone else to fill in and sign.
find another form
 
Village President
P. Sean Michels
Village Clerk
Cynthia Galbreath
Village Administrator
Brent M. Eichelberger
10 S. Municipal Drive
Sugar Grove, Illinois 60554
Phone: 630-466-4507
Fax: 630-466-4521
Village Trustees
Kevin Geary
Sean Herron
Mari Johnson
Ted Koch
Rick Montalto
David Paluch
August 18, 2015
Board Meeting
6:00 P.M.
1. Call to Order
2. Pledge of Allegiance
3. Roll Call
4. Public Hearing
a. None
5. Appointments and Presentations
a. None
6. Public Comment on Items Scheduled for Action
7. Consent Agenda
a. Approval: Minutes of the August 4, 2015 Meeting
b. Approval: Vouchers
c. Approval: Treasurer’s Report
8. General Business
a. Resolution: Waive the Competitive Bid Process and Approve the Purchase of a Tandem Dump Truck and
a Single Axle Dump Truck
b.
Discussion: Temporary Use Approval Process
9. New Business
a. None
10. Reports
a. Staff Reports
b. Trustee Reports
c. Presidents Report
11. Public Comments
12. Airport Report
13. Closed Session: Land Acquisition, Personnel, Litigation
14. Adjournment
Committee of the Whole
Cancelled
1
August 4, 2015
Village of Sugar Grove
6:00 PM
President Michels opened the meeting at 6:00 PM and asked that Trustee Herron lead the Pledge. The
roll was then called.
Present: President Michels, Trustee Koch, Trustee Herron, Trustee Paluch, Trustee Montalto,
Trustee Geary, and Trustee Johnson.
Quorum Established.
Also Present:
Administrator Eichelberger, Clerk Galbreath, Finance Director Chamberlin, Community Development
Director Magdziarz, Public Works Director Speciale.
APPOINTMENTS AND PRESENTATIONS
None.
PUBLIC HEARINGS
None
PUBLIC COMMENTS ON ITEMS SCHEDULED FOR ACTION
President Michels called for any public comments as no member of the public stepped forward and this
portion of the agenda was closed.
CONSENT AGENDA
a. Approval: Minutes of the July 21, 2015 Meeting
b. Approval: Vouchers
c. Resolution: Temporary Use – American Legion Bags Tournament
Trustee Johnson moved to approve the Consent Agenda. Trustee Geary seconded the motion.
President Michels then called for a roll call vote.
AYE: Montalto NAY: None ABSENT: None
Paluch
Johnson
Geary
Koch
Herron
Motion Carried.
2
August 4, 2015 Page 2 of 3
GENERAL BUSINESS
Ordinance Approving a Special Use – 769 Heartland
Ordinance Approving a Preliminary & Final PUD – 769 Heartland
Trustee Johnson moved to adopt an Ordinance Approving a Preliminary & Final PUD – 769
Heartland with original elevation (showing windows at top of building). Trustee Herron seconded the
motion. Community Development Director Magdziarz stated that the elevation presented to the Board at
the Committee of Whole meeting will be used and not the elevation presented in the packet. The
developer has agreed and the representative from Gleason architecture attested to the use of the original
design. Trustee Koch thanked CD Director and the Plan Commission for working to expediently on this
submittal and for paying attention to the details. The landscape and enclosure plans will add a lot to the
area. President Michels then called for a roll call vote.
AYE: Montalto NAY: None ABSENT:
Paluch
Johnson
Geary
Koch
Herron
Motion Carried.
Ordinance Approving a Special Use – 769 Heartland
Trustee Johnson moved to adopt an Ordinance Approving a Special Use – 769 Heartland. Trustee
Paluch seconded the motion. Trustee Geary questioned how a special use affects a property. It was
explained that a special use runs with the property and if a special use is abandoned or not used for a 6-
month time frame it is no longer valid. Trustee Paluch asked there would be any sales at the business.
CD Director answered only small incidental sales. President Michels then called for a roll call vote.
AYE: Montalto NAY: None ABSENT:
Paluch
Johnson
Geary
Koch
Herron
Motion Carried.
NEW BUSINESS
None.
REPORTS
President Michels asked about the Roundabout Progress. Public Works Director Speciale stated the
Round About is open and working well. There are still lights, signage and landscaping to be finished.
Trustee Koch asked about the growing sinkhole on the bikepath on Norris. Director Speciale stated it was
taken care of today.
Trustee Herron asked if the grass that grows along the curb line damages the roadways. Director
Speciale answered no hard damage. With weather like we had this summer/spring, it intensifies growth
such as this and unfortunately also due to weather PW resources are being used in other place, such as
mowing and tree trimming.
3
August 4, 2015 Page 3 of 3
Trustee Montalto asked about street sweeping and work at Mallard Point. Director Speciale asked that if
anyone sees a problem when street sweeping is being done to contact Public Works immediately so they
can look into it. It is hope that final restoration will be one in Mallard by the end of next week.
Trustee Koch stated that the opening ceremony at Corn Boil was very moving. All board members
present praised the Corn Boil and its seemingly great success this year.
President Michels stated that he has had the pleasure of meeting many of the young men that are part of
the Western Amateur and they are very polite.
PUBLIC COMMENTS
President Michels called for any public. Mrs. McCannon asked if the Board could purchase or has any
lights for the entrance park tree for the holidays. She will be working with other Citizens’ of the year to
make sure it is decorated this year. Staff will check to see if the Village has lights and if there is any
budgeted funds for lighting.
A tow truck operator asked the Board to please add him to the tow list. The Board stated they would
follow up on his request.
AIRPORT REPORT
None.
Meeting was adjourned at 6:35 p.m. by motion made by Trustee Geary seconded by Trustee Johnson, all
in attendance voted Aye in a Voice Vote.
Respectfully submitted, Cynthia L Galbreath, Clerk
4
TO:
FROM:
VILLAGE
OF
SUGAR
GROVE
BOARD
REPORT
VILLAGE PRESIDENT MICHELS & BOARD OF TRUSTEES
FINANCE
SUBJECT: APPROVAL OF VOUCHERS
AGENDA:
DATE:
ISSUE
AUGUST18, 2015 BOARD MEETING
AUGUST
14,2015
Approval
of
Vouchers
DISCUSSION
Vouchers for items purchased are submitted for payment and manual checks are noted
for ratification.
COST
Vouchers total $387,884.48 and manual checks total $0.00
RECOMMENDATION
Approval
of
vouchers totalling $387,884.48 and ratification
of
manual checks totaling
$0.00.
L:\F Data\FinanceDataData\Accounts Payable\Agenda History Cover-Current
Fo
rm.doc
5
DATE
:
08
/
14/15
TIME:
08
:
10:57
ID:
AP441000.WOW
INVOICE
ITEM
VILLAGE
OF
SUGAR
GROVE
DETAIL
BOARD
REPORT
INVOICES
DUE
ON/BEFORE
08
/
18
/
2015
INVOICE
#
VENDOR
#
DATE
#
DESCRIPTION
ACCOUNT
#
A0032
AMALGAMATED
BANK
OF
CHICAGO
080115A
08
/
01
/
15
01
W&S
/
2008A
BOND
FEES
50508004
02
8 / 1/
14-7
/
31
/
15
**
COMMENT
**
A0118
AT&T
630466452107-2015
07
/
25
/
15
01
IT
/
AT&T
7 /
25-8
/
24
01496502
02
ADM/
AT&T
7/25-8
/
24
01506502
03
PWIT
//
AT&T
7 /
25-8
/
24
50496502
04
W&S/
AT&T
7/25-8/24
50506502
05
FIN
/
AT&T
7 /
25-8
/
24
01566502
A0133
AURORA
PARCEL
SERVICE
0807151317
08
/
17
/
15
01
W&S
/ MARS-TRANSMITTERS
50596501
A0165
ALEXANDER CHEMICAL CORP
SCL10009932
07/29/15
01
W&S/DEPOSIT
WELL
10
50606607
SLS10035075
07
/
25
/
15
01
W&S/CHLORINE
WELL
10
50606607
A8037
AIRGAS
NORTH
CENTRAL
9929317699
07
/
31
/
15
01
W&S
/ CHEMICALS
50656607
PAGE: 1
P.O.
#
DUE
DATE
ITEM
AMT
08
/
18
/
15
450.00
INVOICE
TOTAL:
450.00
VENDOR
TOTAL:
450.00
08
/
18
/
15
50.00
34.50
49.99
35.55
34
.
50
INVOICE
TOTAL:
204.54
VENDOR
TOTAL:
204.54
08
/
18
/
15
64.90
INVOICE
TOTAL:
64
.
90
VENDOR
TOTAL:
64
.
90
08/18/15
-910.00
INVOICE
TOTAL:
-910.00
08
/
18
/
15
2,110.00
INVOICE
TOTAL:
2,110.00
VENDOR
TOTAL:
1,200.00
08
/
18
/
15
18.60
INVOICE
TOTAL:
18.60
VENDOR
TOTAL:
18.60
6
DATE:
08/14/15
TIME:
08:10:57
ID:
AP441000.WOW
INVOICE
#
VENDOR
#
B0202
BP
45073144
INVOICE
ITEM
DATE
#
DESCRIPTION
VILLAGE
OF
SUGAR
GROVE
DETAIL
BOARD
REPORT
INVOICES
DUE
ON/BEFORE
08
/
18
/20
15
ACCOUNT
#
08/06/15
01
POL/5902008993
6/6-7/5
GAS
02
ACCT
590-200-899-3
-
6/6-7/5
01516601
01556601
B0816
BETTER
BUSINESS
PLANNING
29931
29933FSA
29934HRA
08/01/15
01
FIN/HSA
ADMIN FEE -
AUG
2015
02
W&S/HSA ADMIN FEE -
AUG
2015
08
/0
1 /
15
01
FIN
/ FSA
ADMIN
FEE -
AUG
2015
02
W&S/FSA
ADMIN
FEE -
AUG
2015
08/01/15
01
FIN/HRA
ADMIN
FEE -
AUG
2015
02
W&S/HRA
ADMIN
FEE -
AUG
2015
B0817
BUILDERS
ASPHALT
15624
07
/22/1
5
01
S&P /
HOT
MIX ASPHALT
C0031
CINTAS
FIRE
PROTECTION CORP
F940011491
7
07/27/15
01
BM/10
MUNICIPAL
07-09
2015
F9400114918
07/27/15
01
BM/601
HEARTLAND
REPAIR
SRV
02
W&S/601
HEARTLAND
REPAIR
SRV
01566309
50506309
01566309
50506309
01566309
50506309
01536609
01546406
01546406
50596406
P.O
. #
DUE
DATE
08/18/15
INVOICE
TOTAL:
VENDOR
TOTAL:
08/18/15
INVOICE
TOTAL:
08/18/15
INVOICE
TOTAL:
08/18/15
INVOICE
TOTAL:
VENDOR
TOTAL:
08/18/15
INVOICE
TOTAL:
VENDOR
TOTAL:
08/18/15
INVOICE
TOTAL:
08/18/15
INVOICE
TOTAL:
VENDOR
TOTAL:
PAGE: 2
ITEM
AMT
3,069.70
53.97
3,123.67
3,123.67
16.16
16.17
32.33
12.00
12.00
24.00
8.75
8.75
17.50
73.83
161.20
161
.2
0
161.20
285.00
285.00
142.50
142.50
285.00
570.00
7
DATE:
08
/
14
/
15
TIME:
08
:
10:57
ID:
AP441000.WOW
INVOICE
ITEM
VILLAGE OF SUGAR
GROVE
DETAIL
BOARD
REPORT
INVOICES
DUE
ON
/ BEFORE
08
/
18
/
2015
INVOICE
#
VENDOR #
DATE #
DESCRIPTION
ACCOUNT
#
C0361
COM
ED
072715N
07
/
27
/
15
01
S&P/
7090127000
6 /
23-7
/
24
01536511
080515M
08
/
05
/
15
01
S&P/
0612101014
7 /
6-8
/ 4
01536511
0805150
08
/
05
/
15
01
S&P/
9369045017
7 /
6-8
/ 4
01536511
080615L
08
/
06
/
15
01
S&P /
0053059135
7 /
7-8
/ 5
01536511
C0362
COMMONWEAL
TH
EDISON
080715K
08
/
07
/
15
01
S /
9390162025
7 /
10-8
/ 6
50656511
80315
08
/
03
/
15
01
W/
0039152077
7 /
1-7
/
31
50606511
80315A
08
/
03
/
15
01
S /
0789114021
7 /
1-7
/
31
50656511
80315C
08/03
/
15
01
S /
1209054036
7 / 1 - 7 /
31
50656511
80315D
08
/
03
/
15
01
S /
1311106047
7/1-7
/
31
50656511
80315E
08
/
03
/
15
01
W/
1581052012
7 /
1-7
/
31
50606511
80315F
08
/
03
/
15
01
W/
1713098046
7 /
1-7
/
31
50606511
PAGE:
3
P . O. #
DUE
DATE ITEM
AMT
08
/
18
/
15
34.09
INVOICE
TOTAL:
34.09
08
/
18
/
15
2.89
INVOICE
TOTAL :
2.89
08
/
18
/
15
2.89
INVOICE
TOTAL: 2 .
89
08
/
18
/
15
116
.
10
INVOICE
TOTAL :
116.10
VENDOR
TOTAL:
155.97
08
/
18
/
15
170.83
INVOICE
TOTAL:
170
.
83
08
/
18
/
15
63.71
INVOICE
TOTAL:
63.71
08
/
18
/
15
80.79
INVOICE
TOTAL:
80.79
08
/
18
/
15
62.20
INVOICE
TOTAL:
62
.
20
08
/
18
/
15
129.51
INVOICE
TOTAL:
129
.
51
08
/
18
/
15
188.71
INVOICE
TOTAL:
188
.
71
08
/
18
/
15
184.85
IN
V
OICE
TOTAL:
184.85
8
DATE:
08
/
14
/
15
TIME:
08:10:57
ID:
AP441000.WOW
INVOICE
ITEM
VILLAGE
OF
SUGAR
GROVE
DETAIL
BOARD
REPORT
INVOICES
DUE
ON
/ BEFORE
08
/
18
/
2015
INVOICE
#
VENDOR
#
DATE
#
DESCRIPTION
ACCOUNT
#
C0362
COMMONWEALTH
EDISON
80315G
08
/
03
/
15
01
W/
2073094061
7 /
1-7
/
31
50606511
80315H
08/03
/
15
01
W/
2151031026
7 /
1-7
/
31
50606511
80315I
08
/
03
/
15
01
S/2295116015
7 /
1-7
/
31
50656511
80315J
08/03/15
01
W/2763123040
7/1-7/31
50606511
C0373
CRESCENT
ELECTRIC
SUPPLY
CO
S500827389.00
08
/
07
/
15
01
W&S
/
METER
SUPPLIES
50596603
C0384
COMPUTER
NETWORK
MGMT
.
LLC
150717
07
/
31
/
15
01
IT
/ UPDATE ,
MAINT,DESKTOP,SRVR
01496307
02
PWIT/
UPDATE,MAINT,DESKTOP,SRVR
50496307
03
PDIT/UPDATE,MAINT,DESKTOP,SRVR
01496307
C8038
COMPASS MINERALS AMERICA
71361113
07
/
28
/
15
01
W&S
/ SALT
WELL
#10
50606607
71362075
07
/
30
/
15
01
W&S
/ SALT
WELL
#10
50606607
PAGE
:
4
P.O.
#
DUE
DATE
ITEM
AMT
08
/
18
/
15
125.59
INVOICE
TOTAL:
125.59
08
/
18
/
15
181.48
INVOICE
TOTAL:
181.48
08
/
18
/
15
389.96
INVOICE
TOTAL:
389.96
08/18
/
15
218.48
INVOICE
TOTAL:
218.48
VENDOR
TOTAL:
1,796.11
08
/
18/15
71.04
INVOICE
TOTAL:
71.04
VENDOR
TOTAL:
71.04
08
/
18
/
15
407
.
00
407.00
198.00
INVOICE
TOTAL:
1,012.00
VENDOR
TOTAL:
1,012.00
08
/
18
/
15
2,875
.
10
INVOICE
TOTAL:
2,875
.
10
08
/
18
/
15
3,094.31
INVOICE
TOTAL:
3,094.31
VENDOR
TOTAL :
5,969.41
9
DATE:
08
/
14
/
15
TIME
:
08
:
10:57
ID:
AP441000.WOW
INVOICE
ITEM
VILLAGE
OF
SUGAR
GROVE
DETAIL
BOARD
REPORT
INVOICES
DUE
ON
/ BEFORE
08
/
18
/
2015
INVOICE
#
VENDOR #
DATE
#
DESCRIPTION
ACCOUNT
#
C8041
CLAESSON CARPET CLEANING
INC
19163
06
/
17
/
15
01
POL / CARPET CLEANING
01516309
D0409
DE
KANE
EQUIPMENT CORP
IA37893
07
/
30/15
01
S&P/ EQUIPMENT
REPAIR
PARTS
01536612
D0421
DREYER MEDICAL
CLINIC
27365858
06
/
18/15
01
POL
/
LIFT
TEST -
PP
01516306
27365859
06
/
18
/
15
01
POL / CHEST
XRAY
-
PP
01516309
27401136
06
/
18
/
15
01
POL / PRE
EMPLOYMENT
-
pp
01516306
D8026
DYNEGY
ENERGY
SERVICES
146638715081
08
/
10
/
15
01
W/
0022092002
ENERGY
7 /
7-8
/ 5
50606511
146638915081
08
/
04
/
15
01
W/
0399050054
ENERGY
7 /
1-7
/
30
50606511
146639015081
08
/
07
/
15
01
W/
5222138020
7 /
7-8
/ 4
50606511
E0004
JAMES ECKERT
PAGE: 5
P.O
. #
DUE
DATE
ITEM
AMT
08
/
18
/
15
125.98
INVOICE
TOTAL:
125
.
98
VENDOR
TOTAL:
125
.
98
08
/
18
/
15
94.89
INVOICE
TOTAL:
94.89
VENDOR
TOTAL:
94
.
89
08
/
18
/
15
80.00
INVOICE
TOTAL:
80.00
08
/
18
/
15
70.00
INVOICE
TOTAL:
70.00
08
/
18
/
15
297.00
INVOICE
TOTAL: 2
97
.
00
VENDOR
TOTAL:
447
.
00
08/18
/
15
1,436.95
INVOICE
TOTAL :
1,436
.
95
08
/
18
/
15
1,524.62
INVOICE
TOTAL: 1 ,
524
.
62
08
/
18
/
15
7,781.95
INVOICE
TOTAL:
7,781.95
VENDOR
TOTAL:
10,743.52
10
DATE:
08
/
14
/
15
TIME : 0 8 : 1 0 :
57
ID:
AP441000.WOW
INVOICE
#
VENDOR
#
E0004
JAMES ECKERT
080315
INVOICE
ITEM
DATE
#
DESCRIPTION
VILLAGE OF
SUGAR
GROVE
DETAIL
BOARD
REPORT
INVOICES
DUE
ON
/ BEFORE
08
/
18
/
2015
ACCOUNT
#
08
/
03
/
15
01
BD
/
PCOM
STIPEND-4
/
15
5 /
20
02
6 /
24
7 /
15
01576517
**
COMMENT
**
E001
2
RANDAL
ERICKSON
2015
802
08
/
03
/
15
01
CD
/
INSPECTIONS
7 /
20
- 8 / 2
01556309
E0533
BRENT
M.
EICHELBERGER
ICMA-ADVANCE
08
/
03
/
15
01
ADM
/
ICMA
CONF
9 /
26
- 9 /
30
/
15
01506208
F0013
41787361
41788531
41788962
F0604
263980-1
WRIGHT EXPRESS FSC
07
/
31
/
15
01
S&P/ GASOLINE - JULY
15
07
/
31
/
15
01
POL / GASOLINE - JULY
2015
07
/
31
/
15
01
W&S
/ GASOLINE - JULY
15
02
CD
/ GASOLINE - JULY
15
FIRST
PLACE RENTAL
INC.
01536601
01516601
50596601
01556601
07
/
22
/
15
01
S&P/ ROLLER VIBRTY 2
500
RIDE
ON
01536402
P .
O.
#
DUE
DATE
08
/
18
/
15
INVOICE
TOTAL :
VENDOR
TO
TAL:
08
/
18
/
15
INVOICE
TOTAL:
VENDOR
TOTAL :
08
/
18
/
15
INVOICE
TOTAL:
VENDOR
TOTAL:
08
/
18
/
15
INVOICE
TOTAL:
08
/
18
/
15
INVOICE
TOTAL:
08
/
18
/
15
INVOICE
TOTAL:
VENDOR
TOTAL:
08
/
18
/
15
INVOICE
TOTAL:
PAGE:
6
ITEM
AMT
100.00
100.
0 0
100.00
3,060.00
3,060.00
3,060.00
1 ,
500.00
1,500.00
1,500.00
1,389.73
1,389.73
1,105.01
1,105.01
1 ,
374.24
65.20
1,439.44
3'
934.
18
478
.
39
478.39
11
DATE:
08
/
14
/
15
TIME:
08
:
10
:
57
ID:
AP441000
.
WOW
INVOICE
ITEM
VILLAGE
OF
SUGAR
GROVE
DETAIL
BOARD
REPORT
INVOICES
DUE
ON
/ BEFORE
08
/
18
/
2015
INVOICE
#
VENDOR #
DATE
#
DESCRIPTION
ACCOUNT
#
F0604
FIRST
PLACE RENTAL
INC.
264575-1
08
/
06
/
15
01
S&P/ ROLLER VIBRTY
2500
RIDE
ON
01536402
F0608
FOX
METRO
WATER
RECLAMATION
2015
801
08
/
01
/
15
01
CD
/
WATER
INSP
JULY
1073
REDBUD
01556309
F0668
GARY
FENILI
08092015
08/09
/
15
01
POL /
ARMORY
SUPPLIES
01516603
F8031
FLATSO'S
TIRE
SHOP
INC
051815
05
/
18
/
15
01
W&S
/
GATOR
TIRES
50596403
G8006
CITY
OF
GENEVA
2016-00000019
08
/
03
/
15
01
POL /
TRI-COM
CENTRAL
DISPATCH
01516502
G8007
JOHN
GUDDENDORF
080315
08
/
03
/
15
01
BOARD
/ PLAN
COMM
STIPEND
01576517
02
4 /
15,5
/
20,6
/
24,7
/
15
**
COMMENT
**
PAGE: 7
P.O.
#
DUE
DATE
ITEM
AMT
08
/
18
/
15
243.19
INVOICE
TOTAL :
243.19
VENDOR
TOTAL:
721.58
08
/
18
/
15
20.00
INVOICE
TOTAL:
20.00
VENDOR
TOTAL:
20.00
08
/
18
/
15
50.50
INVOICE
TOTAL:
50.50
VENDOR
TOTAL:
50.50
08
/
18
/
15
305.00
INVOICE
TOTAL :
305.00
VENDOR
TOTAL:
305.00
08
/
18
/
15
34,870.75
INVOICE
TOTAL:
34,870.75
VENDOR
TOTAL :
34,870.75
08
/
18
/
15
100.00
INVOICE
TOTAL:
100.00
VENDOR
TOTAL:
100.00
12
DATE:
08
/
14
/
15
TIME
:
08
:
10:57
ID
:
AP441000.WOW
INVOICE
#
VENDOR
#
I0012
I LEAS
DUES4921
INVOICE
ITEM
DATE
#
DESCRIPTION
VILLAGE OF SUGAR
GROVE
DETAIL
BOARD
REPORT
INVOICES
DUE
ON
/ BEFORE
08
/
18
/
2015
ACCOUNT
#
07
/
01
/
15
01
POL /
2015
ANNUAL
MEMBERSHIP
DUE
01516208
I0037
INTERSTATE
BATTERY SYSTEM
9927
2
I0916
2 /
15
J1030
157380
157382
157388
15743
3
157453
07
/3
1 /
15
01
S&P/
AA
& D
BATTERIES
02
W&S
/ TRUCK
BATTERIES
ILLINOIS
DEPARTMENT
OF
08
/
07
/
15
01
STR
/
UNEMPLOYMENT
BENEFITS-RJ
02
EM
/
UNEMPLOYMENT
BENEFITS
-
RJ
03
WATER
/
UNEMPLOYMENT
BENEFITS-MR
JIMS
TRUCK
INSPECTION
&
REPAIR
07
/
31
/
15
01
W&S
/
INSPECTION
TRK
13
07/31
/
15
01
W&S
/
INSPECTION
TRK
11
07
/
31
/
15
01
S&P/
INSPECTION
TRK10
08
/
04
/
15
01
W&S
/
INSPECTION
TRLR
317
02
S&P/
INSPECTION
UNIT
9
08
/
05
/
15
01
W&S
/
INSPECTION
TRK
204
01536603
50596617
01536204
01546204
50596208
50596407
50596407
01536407
50596407
015364
07
50596407
PAGE: 8
P .
O.
#
DUE
DATE ITEM
AMT
08
/
18
/
15
120.00
INVOICE
TOTAL:
120.00
VENDOR
TOTAL:
120.00
08
/
18
/
15
38.49
38.49
INVOICE
TOTAL:
76.98
VENDOR
TOTAL:
76.98
08
/
18
/
15
812.00
348.00
2,130.00
INVOICE
TOTAL:
3,290.00
VENDOR
TOTAL:
3,290.00
08
/
18
/
15
26
.
00
INVOICE
TOTAL:
26.00
08/18
/
15
26.00
INVOICE
TOTAL:
26.00
08
/
18
/
15
26.00
IN
V
OICE
TOTAL:
26.00
08
/
18
/
15
25
.
00
26.00
INVOICE
TOTAL:
51.00
08
/
18
/
15
39.00
INVOICE
TOTAL:
39.00
13
DATE:
08
/
14
/
15
TIME:
08:10:58
ID:
AP441000.WOW
INVOICE
ITEM
VILLAGE
OF
SUGAR
GROVE
DETAIL
BOARD
REPORT
INVOICES
DUE
ON/BEFORE
08
/
18
/
2015
INVOICE
#
VENDOR
#
DATE
#
DESCRIPTION
ACCOUNT
#
J1030
JIMS
TRUCK
INSPECTION
&
REPAIR
157515
08
/
06
/
15
01
W&S
/
INSPECTION
TRK
303
50596407
K0017
KONICA MINOLTA PREMIER FINANCE
234198791
05
/
14
/
15
01
POL /
COPIES
THRU
4 /
15-5
/
14
01516403
234198837
05
/
14
/
15
01
ADM
/
COPIES
THRU
4 /
15-5
/
14
01506403
02
FIN
/
COPIES
THRU
4 /
15-5
/
14
01566403
03
UB
/
COPIES
THRU
4/15-5/14
50506403
04
BOARD
/
COPIES
THRU
4 /
15-5
/
14
01576403
283743920
07
/
27
/
15
01
ADM
/
COPIER
LEASE
AUG
15
01506402
02
UB
/
COPIER
LEASE
AUG
15
50506402
03
POL /
COPIER
LEASE
AUG
15
01516402
04
S&P/
COPIER
LEASE
AUG
15
01536402
05
EM
/
COPIER
LEASE
AUG
15
01546402
06
CD
/
COPIER
LEASE
AUG
15
01556402
07
W&S
/
COPIER
LEASE
AUG
15
50596402
Kll06
KANE
COUNTY
RECORDER
SGRV070215
07
/
02
/
15
01
CD
/
WEEDLIEN-5,6,7
LANDINGS
01556309
02
CD
/ WEEDLIEN-NWCORNER47 /
WHEELR
01556309
03
CD
/
WEEDLIEN-740,769,701HRTLND
01556309
04
CD
/ WEEDLIEN-51MCCANNON
01556309
05
CD
/
WEEDLIEN-215SRT47
01556309
SGRV
070815
07
/
08
/
15
01
W&S
/ W&SLIEN-206WPARKAVE D
50506309
P.O.
#
DUE
DATE
08
/
18
/
15
INVOICE
TOTAL:
VENDOR
TOTAL:
08
/
18
/
15
INVOICE
TOTAL:
08
/
18
/
15
INVOICE
TOTAL:
08
/
18
/
15
INVOICE
TOTAL:
VENDOR
TOTAL:
08
/
18
/
15
INVOICE
TOTAL:
08
/
18
/
15
INVOICE
TOTAL:
PAGE: 9
ITEM
AMT
51.00
51.00
219.00
118.59
118.59
14.14
14.15
104.52
14.14
146.95
127.02
42.43
95.73
39
.
78
5.30
185
.
62
34.47
530.35
795.89
141.00
47
.
00
141
.
00
47
. 0 0
47.00
423.00
47.00
47
.
00
14
DATE:
08
/
14
/
15
TIME:
08:10:58
ID:
AP441000.WOW
INVOICE
#
VENDOR
#
INVOICE
ITEM
DATE #
DESCRIPTION
VILLAGE
OF
SUGAR
GROVE
DETAIL
BOARD
REPORT
INVOICES
DUE
ON
/ BEFORE
08
/
18
/
2015
ACCOUNT
#
K1106
KANE
COUNTY
RECORDER
SGRV070915
07/09
/
15
01
CD
/ PRAIRIEGLENPUDORDINANCE
01556309
SGRV071415
07
/
14
/
15
01
CD
/ RT47NAMECHANGEORDINANCE
01556309
SGRV071515
07
/
15
/
15
01
W&S
/
W&SLIEN-1347
DORR
DR
50506309
K1117
KANELAND
SCHOOL
DISTRICT
#302
073115
L0005
34159907
L0011
080315
M0024
388226
07
/
31
/
15
01
REL
OF
IMPACT
FEES
JUL
15
02
REL
OF
LAND
CASH
JUL15
71002320
76002320
LAFARGE ELBURN LLC
HEIDI
LEND!
07
/
29
/
15
01
S&P/ 3 / 4"GRAVEL FOR
HF
STORM
DR
01536609
08
/
03
/
15
01
BOARD
/ PLAN
COMM
STIPEND-
02
4 /
15,5
/
20,6
/
24,7
/
15
01576517
**
COMMENT
**
MCHENRY
ANALYTICAL
WATER
07
/
30/15
01
W&S
/
WATER
SAMPLES IRON FLORIDE
50606311
02
W&S
/
WATER
SAMPLES NITRATE
50606311
P.O.
#
DUE
DATE
08
/
18
/
15
INVOICE
TOTAL:
08
/
18
/
15
INVOICE
TOTAL:
08
/
18
/
15
INVOICE
TOTAL :
VENDOR
TOTAL:
08
/
18
/
15
INVOICE
TOTAL:
VENDOR
TOTAL:
08
/
18
/
15
INVOICE
TOTAL:
VENDOR
TOTAL:
08
/
18
/
15
INVOICE
TOTAL :
VENDOR
TOTAL :
08
/
18
/
15
INVOICE
TOTAL:
PAGE
:
10
ITEM
AMT
82
.
00
82.00
47.00
47.00
47
.
00
47
.
00
646
.
00
7,810.62
6,670.76
14,481.38
14,481.38
128
.
43
128.43
128.43
100.00
100.00
100.00
90.00
12.00
102.00
15
DATE:
08
/
14
/
15
TIME:
08:10:58
ID:
AP441000.WOW
INVOICE
ITEM
VILLAGE OF
SUGAR
GROVE
DETAIL
BOARD
REPORT
INVOICES
DUE
ON
/ BEFORE 08 /
18
/
2015
INVOICE
#
VENDOR
# DATE #
DESCRIPTION
ACCOUNT
#
M0024
MCHENRY
ANALYTICAL
WATER
388330
07
/
31/15
01
W&S
/
MONTHLY
MGMTFEE
50606311
02
JULY2014-JUNE2015
**
COMMENT
**
M1316
MID AMERICAN
WATER
115773A
07
/
23
/
15
01
W&S
/
METER
WIRE MARKING PAING
50606603
115774A
07/28/15
01
W&S/CHECK VALVES
50606603
116064A
07
/
28
/
15
01
S&P/ DRAIN
TILE
FOR
HANNAFORD
01536603
Ml371
MICKEY,WILSON,WEILER,
53648
07
/
31
/
15
01
ADM
/ LEGAL
SERVICES
JULY
2015
01506301
53650
07
/
31
/
15
01
CD/LEGAL
SERVICES
JULY
2015
01556301
02
FIN/LEGAL
SERVICES
JULY
2015
01566301
03
W&S/LEGAL
SERVICES
JULY
2015
50506301
04
STR/ LEGAL
SERVICES
JULY
2015
01536301
05
ADM
/ LEGAL
SERVICES
JULY
2015
01506301
53651
07
/
31
/
15
01
POL / LEGAL
SERVICES
JULY
2015
01516301
53652
07
/
31
/
15
01
CD
/ LEGAL
SERVICES
JULY
2015
01536301
L__
---
-
--------
-----
---
------
P.O.
#
DUE
DATE
08
/
18/15
INVOICE
TOTAL:
VENDOR
TOTAL:
08
/
18
/
15
INVOICE
TOTAL:
08
/
18
/
15
INVOICE
TOTAL:
08
/
18
/
15
INVOICE
TOTAL:
VENDOR
TOTAL:
08
/
18
/
15
INVOICE
TOTAL:
08
/
18
/
15
INVOICE
TOTAL:
08
/
18
/
15
INVOICE
TOTAL:
08
/
18
/
15
INVOICE
TOTAL:
PAGE:
11
ITEM
AMT
290.00
290.00
392.00
556.00
556.00
1,848.00
1,848
.
00
20.00
20.00
2,424.00
628.11
628.11
1,035.00
82.50
82.50
90.00
330
.
00
1,620
.
00
855.00
855.00
30.00
30.00
16
DATE:
08
/
14
/
15
TIME:
08:10
:
58
ID:
AP441000.WOW
INVOICE
ITEM
VILLAGE
OF
SUGAR
GROVE
DETAIL
BOARD
REPORT
INVOICES
DUE
ON
/ BEFORE
08
/
18
/
2015
INVOICE
#
VENDOR
#
DATE
#
DESCRIPTION
ACCOUNT
#
M1371
MICKEY,WILSON,WEILER,
53653
07
/
31
/
15
01
CD
/ LEGAL
SERVICES
JULY
2015
35556301
53654
07
/
31
/
15
01
CD
/ LEGAL
SERVICES
JULY
2015
01556301
M1397
MIDWEST ENVIRONMENTAL
15-566
08
/
12
/
15
01
S&P /
AIR
QUALITY
TESTING-
33557003
02
AIRPORT HOUSE
**
COMMENT
**
M2225
METROPOLITAN MAYORS' CAUCUS
2015-248
06
/
30
/
15
01
BD
/ 20115-16METROMAYORCAUCUS
01576208
02
DUES
**
COMMENT
**
N1415
NICOR
GAS
070315
07
/
30/15
01
S/96-87-29-3490
4
6/29-7/29
50656510
072715
07
/
27
/
15
01
S/
06-77-26-3518
8 6/
24-7
/
27
50656510
00005
ORKIN
INC.
104320525
08
/
06
/
15
01
EM
/
MONTHLY
SRVC -
VH
01546406
----
---
---·-
--
-·--
-·
---------------
PAGE
:
12
P.O.
#
DUE
DATE
ITEM
AMT
08
/
18
/
15
12,986.08
INVOICE
TOTAL:
12,986.08
08
/
18
/
15
605.00
INVOICE
TOTAL:
605.00
VENDOR
TOTAL:
16,724
.
19
08
/
18
/
15
1,500.00
INVOICE
TOTAL:
1,500.00
VENDOR
TOTAL:
1,500.00
08
/
18
/
15
404.87
INVOICE
TOTAL:
404.87
VENDOR
TOTAL:
404.87
08
/
18/15
26
.
99
INVOICE
TOTAL:
26.99
08
/
18
/
15
27
.
59
INVOICE
TOTAL:
27.59
VENDOR
TOTAL:
54.58
08
/
18
/
15
67.56
INVOICE
TOTAL:
67.56
17
DATE:
08
/
14
/
15
TIME:
08:10:58
ID:
AP441000.WOW
INVOICE ITEM
VILLAGE
OF
SUGAR
GROVE
DETAIL
BOARD
REPORT
INVOICES
DUE
ON
/ BEFORE 08 /
18
/
2015
INVOICE
#
VENDOR
#
DATE
#
DESCRIPTION
ACCOUNT
#
00005
ORKIN
INC
.
104320526
08
/
06
/
15
01
EM
/
MONTHLY
SRVC -
PW
01546406
02
W&S
/
MONTHLY
SRVC -
PW
50596406
01502
IRV
OCHSENSCHLAGER
080315
08
/
03
/
15
01
BD
/
PCOM
STIPEND
- 4 /
15
5 /
20
7 /
15
01576517
01535
ORLEANS
RHIL
20141018
08 / 04 /
15
01
CD
/ REF
ESCROW
-
797
RIDGEVIEW
01002359
P0031
PROSHRED SECURITY
100060467
07
/
17
/
15
01
ADM
/ SHREDDING
SRVC-JULY15
01506
3
09
02
POL / SHREDDING
SRVC-JULY15
01516309
03
BRD
/ SHREDDING
SRVC-JULY15
01576309
04
FIN
/ SHREDDING
SRVC-JULY15
01566309
05
CD
/ SHREDDING
SRVC-JULY15
01556309
06
CD
/ SHREDDING
SRVC-JULY15
01556309
07
STR/ SHREDDING
SRVC-JULY15
01536309
08
WS
/ SHREDDING
SRVC-JULY15
50506309
09
PW
/ SHREDDING SRVC -
JULY15
50596309
P1625
PREFORM
TRAFFIC
CONTROL
SYSTEM
10257
08 / 03 /
15
01
S&P/
PAVEMENT
MARKING
01536405
PAGE:
13
P.O.
#
DUE
DATE
ITEM
AMT
08
/
18
/
15
51.78
51.
78
INVOICE TOTAL:
103.56
VENDOR
TOTAL:
171.12
08
/
18
/
15
75.00
INVOICE TOTAL:
75.00
VENDOR
TOTAL:
75.00
08
/
18
/
15
8,380
.
00
INVOICE TOTAL:
8,380
.
00
VENDOR
TOTAL:
8,380
.
00
08
/
18
/
15
12.5
0
12.50
12.50
12.50
5.00
7.50
12
.
50
12
.
50
12
.
50
INVOICE TOTAL:
100
.
00
VENDOR
TOTAL:
100.00
08
/
18
/
15
5,
8
23.63
INVOICE TOTAL:
5,823.63
VENDOR
TOTAL:
5,823.63
18
DATE:
08
/
14
/
15
TIME:
08
:
10
:
58
VILLAGE
OF
SUGAR
GROVE
DETAIL
BOARD
REPORT
ID:
AP441000
.
WOW
INVOICES
DUE
ON
/ BEFORE 08 /
18
/
2015
INVOICE
#
VENDOR
#
INVOICE
ITEM
DATE #
DESCRIPTION
P1636
POMP'S
TIRE
SERVICE,
INC
330059476
08
/
04
/
15
01
W&S
/
TIRES
TRK
#09
R1813
RICH'S
AUTO
SERVICE
07222015A
07
/
22
/
15
01
POL
/
REAR
BRAKE
PADS -
SQD
43
02
POL
/
TWO
REAR
BRAKE
ROTORS
03
POL
/
LABOR
RENEW
REAR BRAKES
04
1.5
HOURS
07312015
07
/
31
/
15
01
POL
/
ONE
SET
REAR
BRAKES
SQD
42
02
POL
/
TWO
REAR
BRAKE
ROTORS
03
SQD42
04
POL /
LABOR
REAR
BRAKES 1 . 5
HRS
R8119
ROSS MECHANICAL GROUP, INC
150917
08
/
04
/
15
01
BM
/ A/ C
AT
POL
STATION
R8121
RUSH
TRUCK
CENTER
OF
ILLINOIS
99063134
08
/
04
/
15
01
W&S
/
TRUCK
#204
S0003
SUGAR
GROVE
PUBLIC
LIBRARY
073115
07
/
31
/
15
01
REL
OF
IMPACT
FEES
JUL
15
ACCOUNT
#
01536407
01516407
01516407
01516407
**
COMMENT
**
01516407
01516407
**
COMMENT
**
01516407
01546406
50596617
72002331
P.O.
#
DUE
DATE
08
/
18
/
15
INVOICE TOTAL:
VENDOR
TOTAL:
08
/
18
/
15
INVOICE TOTAL :
08
/
18
/
15
INVOICE TOTAL:
VENDOR
TOTAL:
08
/
18
/
15
INVOICE TOTAL:
VENDOR
TOTAL:
08
/
18
/
15
IN
VOICE TOTAL:
VENDOR
TOTAL:
08
/
18
/
15
INVOICE TOTAL:
VENDOR
TOTAL:
PAGE:
14
ITEM
AMT
583.66
583.66
583
.
66
81.60
146.60
106.25
334
.
45
81.60
146.60
106.25
334.45
668.90
360
.
00
360.00
360.00
407.09
407.09
407
.
09
725.86
725.86
725.86
19
DATE
:
08
/
14
/
15
TIME:
08:10:58
ID:
AP441000.WOW
INVOICE
ITEM
VILLAGE
OF
SUGAR
GROVE
DETAIL
BOARD
REPORT
INVOICES
DUE
ON
/ BEFORE
08
/
18
/
2015
INVOICE
#
VENDOR
#
DATE
#
DESCRIPTION
ACCOUNT
#
S0047
SMITH
AMUNDSEN
LLC
475100
08
/
06
/
15
01
POL/ LEGAL
SERVICES
JULY
2015
01516301
475101
08
/
06
/
15
01
POL / LEGAL
SERVICES
JULY
2015
01516301
475103
08
/
06
/
15
01
POL/ LEGAL
SERVICES
JULY
2015
01516301
475320
08
/
06
/
15
01
POL / LEGAL
SERVICES
JULY
2015
01516301
475369
08
/
06
/
15
01
POL / LEGAL
SERVICES
JULY
2015
01516301
S1982
SUGAR
GROVE
FIRE
DISTRICT
073115
07
/
31
/
15
01
REL
OF
IMPACT FEES - JULY
2015
73002340
20140045
10
/
07
/
14
01
FIN
/ OUTSTANDING
FIRE
DIST
01003791
02
INV20140045
**
COMMENT
**
20140069
11
/
19
/
14
01
FIN
/ OUTSTANDING
FIRE
DIST
01003791
02
INV20140069
**
COMMENT
**
20150015
02
/
24
/
15
01
FIN
/ OUTSTANDING
FIRE
DIST
010037
91
02
INV20150015
**
COMMENT
**
S1994
SUGAR
GROVE
PARK
DISTRICT
PAGE:
15
P.O.
#
DUE
DATE
ITEM
AMT
08
/
18
/
15
80.00
INVOICE
TOTAL:
80.00
08
/
18
/
15
140
.
00
IN
V
OICE
TOTAL:
140.00
08
/
18
/
15
1,920.00
INVOICE
TOTAL:
1,920.00
08
/
18
/
15
8,442.85
INVOICE
TOTAL:
8,442
.
85
08
/
18
/
15
200.00
INVOICE
TOTAL :
200
.
00
VENDOR
TOTAL:
10,782.85
08
/
18
/
15
2,150
.
94
INVOICE
TOTAL :
2,150.94
08
/
18
/
15
-14.59
INVOICE
TOTAL:
-14.59
08
/
18
/
15
-9.72
INVOICE
TOTAL:
-9.72
08
/
18
/
15
-33.66
INVOICE
TOTAL:
-33.66
VENDOR
TOTAL:
2,092.97
20
DATE:
08
/
14
/
15
TIME :
08:10:58
ID:
AP441000.WOW
INVOICE
ITEM
VILLAGE
OF
SUGAR
GROVE
DETAIL
BOARD
REPORT
INVOICES
DUE
ON
/ BEFORE
08
/
18
/
2015
INVOICE
#
VENDOR
#
DATE
#
DESCRIPTION
ACCOUNT
#
S1994
SUGAR
GROVE
PARK
DISTRICT
073115
07
/
31
/
15
01
REL
OF
LAND
CASH
JUL
15
74002340
02
REL
OF OF
CAP IMPROV
FEE
JUL15
75002340
S8037
STREICHER'S
I1163650
07
/
31
/
15
01
POL
//
45
ACP
DUTY
TACTICAL HST
01516603
02
POL /
FREIGHT
01516603
S8040
REBECCA SABO
080315
08
/
03
/
15
01
BOARD
/ PLAN
COMM
STIPEND
01576517
02
4 /
15,
6 /
24
**
COMMENT
**
S8043
SUGAR
GROVE
ACE
825
/ 1
07
/
20/15
01
S&P/HARDWARE
01546603
851
/ 1
07
/
28
/
15
01
S&P/
RAKE
01536603
855
/ 1
07
/
30
/
15
01
W&S
/ PAINT&SUPPLIESFORLSDOOR
50656611
857
/ 1
07
/
30
/
15
01
POL / PADLOCK
1-1
/ 2
LAM
4
PK#3
01516613
FY15-TAX
08
/
13
/
15
01
FIN
/ SALES
TAX
REBATE
FY15
01003449
PAGE:
16
P.O.
II
DUE
DATE
ITEM
AMT
08
/
18
/
15
9,060.47
800.07
INVOICE
TOTAL:
9,860.54
VENDOR
TOTAL :
9,860.54
08
/
18
/
15
220.00
15.00
INVOICE
TOTAL:
235.00
VENDOR
TOTAL:
235.00
08
/
18/15
50.00
INVOICE
TOTAL:
50.00
VENDOR
TOTAL:
50.00
08
/
18/15
3 .
59
INVOICE
TOTAL :
3.59
08
/
18
/
15
16.99
INVOICE
TOTAL :
16
.
99
08
/
18
/
15
68
.
11
INVOICE
TOTAL :
68
.
11
08
/
18
/
15
47.98
INVOICE
TOTAL :
47.98
08
/
18
/
15
3,047.86
INVOICE
TOTAL:
3,047
.
86
VENDOR
TOTAL:
3,184.53
21
DATE:
08/14/15
TIME:
08:10:58
ID:
AP441000.WOW
INVOICE
#
VENDOR #
INVOICE
ITEM
DATE
#
DESCRIPTION
VILLAGE OF SUGAR
GROVE
DETAIL
BOARD
REPORT
INVOICES
DUE
ON/BEFORE
08/18/2015
ACCOUNT
#
S8046
SOURCE
ONE
OFFICE
PRODUCTS
395614
519792
519815
07/29/15
01
POL/VINYL
ENVELOPE
50
07/16/15
01
W&S/FILE
FOLDERS, GLUE
STICKS
02
S&P/
FILE
FOLDERS, GLUE
STICKS
07/17/15
01
ADM/PAPER,
BINDERS,
TAPE
02
FIN
/ PAPER,
BINDERS,
TAPE
03
W&S
/ PAPER,
BINDERS,
TAPE
01516613
50596613
01536613
01506613
01566613
50506613
T0001480
KRISTINA
GOODACRE
0253000087
08/11/15
01
W&S/FNL
W&S
REF
187
VALE
50001210
T0001587
FIDELITY
NATIONAL
TITLE
INSUR
2015
721
07/21/15
01
CD/REF
LEGAL&INCID COST
ESCROW
01002359
02
990
CHESTNUT
HILL
LN
LOT
36
**
COMMENT
**
T0001601
KEVIN HERRA
027000041100
08/03/15
01
W&S/FNL
W&SREF
993
JENNIFER
CT
50001210
T0012
THIRD MILLENNIUM
18452
07/31/15
01
W&S
/
PRINTING
MAILING
AUG
2015
50506309
P.O.
#
DUE
DATE
08/18/15
INVOICE
TOTAL:
08/18/15
INVOICE
TOTAL:
08/18/15
INVOICE
TOTAL:
VENDOR
TOTAL:
08/18/15
INVOICE TOTAL:
VENDOR
TOTAL:
08
/
18
/
15
INVOICE
TOTAL:
VENDOR
TOTAL:
08/18/15
INVOICE
TOTAL:
VENDOR
TOTAL:
08/18/15
INVOICE
TOTAL:
VENDOR
TOTAL:
PAGE:
17
ITEM
AMT
49.95
49.95
6.44
6.43
12.87
35.05
35.04
35.04
105.13
167.95
112.76
112.76
112
.7
6
212.50
212.50
212.50
270.18
270.18
270.18
754.40
754
.
40
754.40
22
DATE:
08
/
14
/
15
TIME:
08:10:58
ID
:
AP441000.WOW
INVOICE
ITEM
VILLAGE
OF
SUGAR
GROVE
DETAIL
BOARD
REPORT
INVOICES
DUE
ON
/ BEFORE
08
/
18
/
2015
INVOICE
#
VENDOR
#
DATE
#
DESCRIPTION
ACCOUNT
#
T0013
TRAFFIC
ANALYSIS &
DESIGN
INC
10946
07
/
31
/
15
01
S&P/
ENGR
SRVCES THRU 7 /
31
/
15-
35536303
02
GRAN
ART
**
COMMENT
**
03
S&P /
IDOT-11-99911
35536303
04
S&P/ KIMLEY-HORN
681
2
975
35536303
T8041
TRANSUNION
RISK
AND
08012015
08
/
01
/
15
01
POL/TLOXP
CHARGES -
6 /
1-30
/
15
01516309
T8044
TBS EXCAVATING,
INC
22450
07
/
29
/
15
01
S&P/
REMOVE
& REPLACE SIDEWALK
01536405
PAY
EST
2
06
/
20
/
15
01
W&S
/ SR
TO
MALLARD
POINT
W.M.
50717011
02
W&S
/ 10% RETAINAGE
50717011
U2146
USA BLUEBOOK
704163
07
/
22
/
15
01
W&S
/
TESTING
SUPPLIES
50606603
W0011
WASCO
LAWN
&
POWER
INC
191604
07
/
23
/
15
01
S&P/
MOWER
PARTS
01536612
PAGE:
18
P.O
. #
DUE
DATE ITEM
AMT
08
/
18
/
15
769.00
50,732
.
50
8,625
.
00
INVOICE
TOTAL:
60,126
.
50
VENDOR
TOTAL:
60,126.50
08
/
18
/
15
110.00
INVOICE
TOTAL:
110.00
VENDOR
TOTAL:
110.00
08
/
18
/
15
4,080
.
00
INVOICE
TOTAL:
4,080
.
00
08
/
18
/
15
106,216.19
-10,621.62
INVOICE
TOTAL:
95,594.57
VENDOR
TOTAL:
99,674
.
57
08
/
18
/
15
453.36
INVOICE
TOTAL:
453.36
VENDOR
TOTAL:
453.36
08
/
18
/
15
120.45
INVOICE
TOTAL:
120.45
VENDOR
TOTAL:
120.45
23
DATE:
08
/
14
/
15
TIME :
08:10:58
ID:
AP441000
.
WOW
INVOICE ITEM
VILLAGE OF
SUGAR
GROVE
DETAIL
BOARD
REPORT
INVOICES
DUE
ON
/ BEFORE 08 /
18
/
2015
INVOICE #
VENDOR
#
DATE
#
DESCRIPTION
ACCOUNT
#
W2306
WATER
SOLUTIONS
37195
07
/
30
/
15
01
W&S
/ WSU118
50606607
W2315
WASTE
MANAGEMENT
349117
2-
2011-2
08
/
01
/
15
01
REFUSE COLLECTION-JULY
2015
57506513
W8033 WILSON NURSERIES
080315
08
/
13
/
15
01
BOARD
/
PLAN
COMM
STIPEND
01576517
02
4 /
15,6
/
24,7
/
15
**
COMMENT
**
W8034
WAREHOUSE
DIRECT
2770356-0
07
/
29
/
15
01
POL/
COPY
PAPER
01516613
PAGE:
19
P.O.
#
DUE
DATE
ITEM
AMT
08
/
18
/
15
4,362.50
INVOICE
TOTAL :
4,362.50
VENDOR
TOTAL:
4,362.50
08
/
18
/
15
65,552.67
INVOICE TOTAL:
65
,
552.67
VENDOR
TOTAL:
65,552.67
08
/
18
/
15
75.00
INVOICE
TOTAL :
75.00
VENDOR
TOTAL:
75.00
08
/
18
/
15
88.50
INVOICE TOTAL:
88
.
50
VENDOR
TOTAL :
88
.
50
TOTAL ALL
INVOICES:
387,884
.
48
24
VILLAGE
OF
SUGAR
GROVE
BOARD
REPORT
TO: VILLAGE PRESIDENT & BOARD OF TRUSTEES
FROM: PAT CHAMBERLIN, FINANCE DIRECTOR
SUBJECT: MONTHLY TREASURER'S REPORT
AGENDA: AUGUST 18, 2015 REGULAR BOARD MEETING
DATE: AUGUST 13, 2015
ISSUE
Should the Village Board approve the July 2015 monthly Treasurer's report.
DISCUSSION
The Summarized Revenue & Expense Reports are attached (pages 1 - 8).
In
addition,
the Detailed Revenue
& Expense Reports are attached immediately following the
Summarized Reports (pages
9-
30). At July
31
, 2015 we are through 3 months
of
the
year (25.0%).
The General Fund revenues and expenditures are at 36.0% and 24.2%, respectively.
Revenues are higher than budget due to the receipt
of
property taxes; expenditures are
lower than budget as many expenditures are attributable to the prior fiscal year, for
which journal entries have already been made. The following expenditures have budget
or actual amounts over $5,000 and are higher than budget by 10% or more:
Budget Actual
% SQent
01-51-6209
Uniform Allowance
11
'130
4,000 36.0%
A
01-51-6309
Other Professional Svc. 12,053 5,649 46.9%
B
01-53-6105
Salaries - Seasonal
9,880
4,390 44.5%
c
01-53-6303
Engineering Services 6,900
5,884 85.3% D
01-53-6603
Specialized Supplies
5,500
2,192 39.9%
E
01-55-6104
Salaries - Part-Time
5,175
2,244 43.4%
F
01-55-6301
Legal Services
56,400
58,059 102.9% G
01-56-6307
I.S. Services
7,
171
5,577 77.8%
H
01-57-6208
Training
& Membership
7,849
3,870 49.4% I
01-57-6515
Public Relations
5,555
2,500 45.0% J
A Pol - This is due to the timing
of
payments for uniform allowance. This is a
budgeted item and account will not exceed
bu
dget.
L:
\F
Data
\F
inanceD ataData
\F
inance Repo
rt
s \ 20
15
-2016
\08-
1
8-
15
\ 0
8-
1
8-
15
TR.doc
25
B Pol - The timing
of
payments made for 2 budgeted items attribute for this
account being over budget for the accounting period. The account will continue
to
be monitored and
is
not expected to
be
over budget for the fiscal year.
C Str - This
is
a budgeted item and
is
due to the timing of the seasonal help for
property maintenance. This account
is
not expected to exceed the fiscal year
budget.
D
Str-
This
is
due to engineering work related to Right-of-Way Permits. This
is
an
unbudgeted item and the account
is
expected to exceed the budget for the fiscal
year.
E Str - This is due to Mosquito Abatement applications which
is
a seasonal
purchase. This account
is
not expected to exceed the fiscal year budget.
F CD - This
is
due to the increase
in
permit inspections. This expense
is
offset by
permit fee revenues.
G CD - This account
is
over budget due to on-going development litigation. The
account will continue
to
be monitored.
H Fin - This
is
due to the timing of payment for the Village's financial software
package. This
is
a budgeted item and the account
is
expected to remain under
budget for the fiscal year.
Board - This
is
due to timing
of
payment for Metro West Membership dues. This
is
a budgeted item and the account will not exceed budget for the fiscal year.
J Board - This
is
due to the timing
of
payment for the annual Corn Boil Firework
Donation. This is a budgeted item and the account
is
not expected to exceed
budget.
Please note that engineering invoices are paid approximately 2 months after services
are provided. Thus, engineering service accounts
in
the General Fund, Infrastructure
Fund, and Waterworks and Sewerage Fund will reflect a 2 month lag.
The General Capital Projects Fund revenues are at 20.5% and expenditures are at
8.5%. The expenditures are low due to budgeted projects for 140 Municipal still being
in
the developmental stages.
The Industrial TIF
#1
Fund revenues are at 40.6% and expenditures are at 1225.4%.
Expenditures are high due to unexpected Engineering costs related to the Dugan
Rd
LAFO project.
The Industrial TIF #2 Fund expenditures are at 3.2%. The expenditures are low due to
projects not starting yet this year.
The Infrastructure Capital Projects Fund revenues are at 50.9% and expenditures are
21
. 7%. Revenues are high due to the receipt
of
grant funds from the State.
The Debt Service Fund revenues are at 25.0% and the expenditures are at 11.3%.
The Waterworks and Sewerage Fund operating revenues and operating expenses are
at 16.7% and 24.5%, respectively. The capital revenues and expenses are at 19.2%
26
and 8.4%, respectively. The following expenses have budget or actual amounts over
$5,000 and are higher than budget by 10%
or
more:
50-50-6307 I.S Services
50-50-8002 Debt - Principal
50-50-8003
Debt-
Interest
50-71-8002
Debt-
Principal
50-71-8003 Debt
-Interest
50-72-6303 Engineering Services
Budget
10,311
664,342
142,245
50,000
93,625
20,000
Actual
5,577
332,761
51,857
50,000
47,313
7,538
%Spent
54.1%
50.1%
36.5%
100.0%
50.6%
37.7%
K
L
M
N
0
p
K Adm - This
is
due to the timing
of
payment for the Village's financial software
package. This is a budgeted item and the account is expected to remain under
budget for the fiscal year.
L Adm - This is high due to the timing
of
debt payments throughout the year and
will not exceed budget.
M Adm - This is high due to the timing
of
debt payments throughout the year and
will not exceed budget.
N Water Cap. - This due to the timing
of
scheduled debt payments. Payments are
complete for this fiscal year.
0 Water Cap.
-This
is high due to the timing
of
debt payments throughout the year
and will not exceed budget.
P Sewer Cap. - This is due to the progression
of
the Queens Gate sewer project
scheduled for this year. These are budgeted costs and account is not expected
to exceed budget.
The Refuse Fund revenues and expenses are at 16.6% and 15.9%, respectively. The
expenses are below expectations due to the timing
of
payments being made to Waste
Management.
Staff projected and included 50 residential and 3 commercial permits
in
the fiscal year
2015-
2016 Budget approved by the Village Board, which we will track throughout the
fiscal year and report on. As
of
August 13, 2015, 12
of
the residential and 1
of
the
commercial permits have been issued. The following accounts will be included
in
each
Treasurer's Report to reflect the revenues from building activity:
Budget
Actual
%Earned
01-00-3310
Building Permits 75,525
34,238 45.4%
01-00-3320
Cert
of
Occupancy Fees 5,300
1,100 20.8%
01-00-3330
Plan Review Fees 5,645
1,953 34.6%
01-00-3340
Reinspection Fees 3,472
1,615 46.6%
01-00-3350
Transition Fees 0
14,238 100.0%
01-00-3740
Zoning and Filing Fees
16,000
1,800 11.3%
01-00-3760
Review and Dev. Fees 109,420
31,738 29.1%
30-00-3850
Improvement Donations 120,456
16,343 13.6%
27
30-00-3851
Emerg Warn Device Fee
300 0
0.0%
30-00-3852
Life Safety-Police
3,458 200 5.8%
30-00-3853
Life Safety-Streets
3,458
360
10.5%
30-00-3856
Commercial Fee
0 0
0.0%
35-00-3854
Traffic Pre-emption Donate
0 0
0.0%
35-00-3855
Road Impact Fee
194,720
35,117
18.1%
50-00-3310
Meter Reinspections
728 85
11
.7%
50-00-3670
Meter Sales
28,925 4,942 17.1%
50-01-3651
Water Tap-On Fees
178,310
25,870
14.6%
50-01-3652
Sewer Tap-On Fees
21
,683
2,914 13.5%
50-01-3791
Fire Suppr Tap-On Fee
8,702
0
0.0%
COST
There are
no
direct costs associated with the monthly Treasurer's report.
RECOMMENDATION
That the Board approve the July 2015 monthly Treasurer's reports.
28
DATE:
08
/
13
/2
015
TIME:
08:35:48
ID
:
GL480000.WOW
DEPARTMENT
DESCRIPTION
REVENUES
REVENUES
TOTAL REVENUES
EXPENSES
INFORMATION TECHNOLOGY
ADMINISTRATION
POLICE
PUBLIC
WORKS-
STREET
DIVISION
BUILDING
MAINTENANCE
COMMUNITY DEVELOPMENT
FINANCE
BOARD
AND
COMMISSIONS
TOTAL
EXPENSES
TOTAL FUND REVENUES
TOTAL FUND
EXPENSES
SURPLUS
(DEFICIT)
FOR
FOR
VILLAGE OF SUGAR
GROVE
SUMMARIZED REVENUE & EXPENSE REPORT
FUND :
GENERAL
FUND
3
PERIODS
ENDING
JULY
31,
2015
%
JULY JULY
VARI-
BUDGET ACTUAL
ANCE
336,340.20
393,717.95
17.0
336,340.20
393,717.95
17.0
2,474.34
1,059.50
57.1
28,064.65
22,957.09
18.1
189,052
.
17
184,638.64
2.3
105,596.00
82,037.41
22.3
13,879
.64
10,186
.24
26.6
49,217
.10
84,246.19
(71.1)
12,699.76
10,247
.
51
19.3
6,989.74
13,251.11
(
89.
5)
FISCAL
YEAR
BUDGET
4,794,999.00
4,794,999.00
29,692.00
336,775.00
2,268,625.00
1,267,150.00
166,555.00
590,604.00
152
,396.00
83,876.00
PAGE: 1
F-YR:
16
FISCAL
%
YEAR-TO -DATE
VARI-
ACTUAL
ANCE
1,725,451.99
(64.
0)
1,725,451.99
(64
.
0)
2,500.00
91.5
74,513.26
77.8
593,734.10
73.8
211,252.69
83.3
38,714.94
76.7
199,242.91
66.2
40,887.53
73.1
19,778.48
76.4
-------------------------------------------------------------------------------------------------
407,973.40 408,623.69
(0
.1)
4,895,673.00
1,180,623.91
75
. 8
336,340.20
393,717.95
17.0
4,794,999.00
1,725,451.99
(64.
0)
407,973
.40
408,623.69
(0
.1)
4,895,673.00
1,180,623.91
75
. 8
(71,633.20)
(14,905.74)
(79.1)
(100,674.00)
544,828.08
(641.
1)
1
29
DATE:
08
/
13
/
2015
TIME:
08:35:48
ID:
GL480000.WOW
DEPARTMENT
DESCRIPTION
REVENUES
REVENUES
TOTAL REVENUES
EXPENSES
ADMINSTRATION
POLICE
PUBLIC
WORKS
STREETS
BUILDING
MAINTENANCE
COMMUNITY
DEVELOPMENT
FINANCE
TOTAL EXPENSES
TOTAL
FUND
REVENUES
TOTAL
FUND
EXPENSES
SURPLUS
(DEFICIT
)
FOR
FOR
VILLAGE
OF
SUGAR GROVE
SUMMARIZED REVENUE
& EXPENSE REPORT
FUND:
GENERAL
CAPITAL
PROJECTS
FUND
3 PERIODS ENDING
JULY
BUDGET
36,036
.
85
36
,
036
.
85
47,433.34
17,751
.
85
5,833.34
0.00
0.00
0 .
00
71,018.53
36,036
.
85
71,018.53
(34'
981.
68)
JULY
3
1,
JULY
ACTUAL
26,573
.
98
26,573
.
98
580
.
40
52,079.00
0.00
0.00
0.00
0 .
00
52,659.40
26,573
.
98
52,659
.
40
(26,085
.
42
)
2015
%
VARI-
ANCE
(26.
2 )
(26.
2 )
98.7
(
193.
3 )
100.0
0 . 0
0.0
0.0
25.8
(26.2)
25
. 8
(25
.
4)
FISCAL
YEAR
BUDGET
432,442
.
00
432,442
.
00
569,200
.
00
213
,
022.00
70
,
000.00
0.00
0.00
0.00
852
,
222.00
432,442
.
00
852,222.00
(419
,
780.
00)
PAGE: 2
F -
YR
:
16
FISCAL
YEAR-TO-DATE
ACTUAL
88,318.88
88,318.88
1,596
.
10
70,349.34
0.00
0 .
00
0 .
00
0.00
71
,
945
.
44
88,318.88
71,945.44
16
,
373.44
%
VARI-
ANCE
(79.
5 )
(79.
5 )
99
. 7
66
. 9
100.0
0 . 0
0.0
0.0
91.5
(79
.
5)
91.5
(103.9)
2
30
DATE:
08
/
13
/2
015
TIME:
08:35:48
ID:
GL480000.WOW
DEPARTMENT
DESCRIPTION
VILLAGE
OF
SUGAR
GROVE
SUMMARIZED
REVENUE
& EXPENSE REPORT
FOR
FUND: INDUSTRIAL
TIF
#1
FUND
FOR
3 PERIODS ENDING
JULY
31,
20
15
JULY
BUDGET
JULY
ACTUAL
%
VARI-
ANCE
FISCAL
YEAR
BUDGET
PAGE: 3
F-YR:
16
FISCAL
%
Y
EAR-TO-DATE
VARI-
ACTUAL
ANCE
----------------------------------------------------------------------------------------------------------------------------------------------------
REVENUES
REVENUES
TOTAL REVENUES
EXPENSES
PUBLIC
WORKS
STREETS
COMMUNITY
DEVELOPMENT
TOTAL EXPENSES
TOTAL
FUND
REVENUES
TOTAL
FUND
EXPENSES
SURPLUS
(DEFICIT)
2,964.00
0.00
100.0
68,835.00
27,901.16
(59.
4)
-------
--
----------------------------------------------------------------------------------------
2,964.00
0 .
00
22.92
0.00
3,338.84
31.25
100.0
100.0
(3
6.
3)
68,835.00
0
.00
27
5
.00
27,901.16
3,338.84
31.25
(59.
4)
100.0
88
.6
----------------
-----------------
---
--------------
-----------------------------------------------
22.92
2,964.00
22.92
2,941.08
3 ,
370.09
0.00
3,370.09
(3,370
.
09)
(4603
.
7)
100
. 0
(4603.
7)
(214.
5)
275.00
68,835.00
275
.
00
68,560
.
00
3,370.09
27,90
1.16
3,370.09
24,531.07
(1125.
4 )
(59.
4)
(1125.
4)
(64.
2)
3
31
DATE:
08/13/2015
TIME :
08:35:48
ID:
GL480000
.
WOW
DEPARTMENT
DESCRIPTION
VILLAGE
OF
SUGAR
GROVE
SUMMARIZED
REVENUE
& EXPENSE REPORT
FOR FUND: INDUSTRIAL
TIF
#2
FUND
FOR
3
PERIODS
ENDING JULY
31,
2015
JULY
BUDGET
JULY
ACTUAL
%
VARI-
ANCE
FISCAL
YEAR
BUDGET
PAGE: 4
F-YR:
16
FISCAL
%
YEAR-TO-DATE
VARI-
ACTUAL
ANCE
----------------------------------------------------------------------------------------------------------------------------------------------------
EXPENSES
COMMUNITY
DEVELOPMENT
4,022.94
1,236.00
69.2
48,275.00
1,506.00
96.8
----
------------------
---
------
---
------
--
---------------------
--------
----
----------------
------
TOTAL EXPENSES
4 ,
022.94
1,236
.00
69.2
48,275
.
00
1,506.00
96.8
4
32
DATE:
08/13/2015
TIME:
08:35:48
ID
:
GL480000.WOW
DEPARTMENT
DESCRIPTION
REVENUES
REVENUES
TOTAL
REVENUES
EXPENSES
MOTOR
FUEL
TAX
STREETS
DIVISION
BUILDING
& ZONING
TOTAL
EXPENSES
TOTAL FUND REVENUES
TOTAL FUND
EXPENSES
SURPLUS
(DEFICIT)
FOR
FOR
VILLAGE OF SUGAR GROVE
SUMMARIZED
RE
V
ENUE
& EXPENSE REPORT
FUND:
INFRASTRUCTURE
CAP
PROJ
FUND
3
PERIODS
ENDING
JULY
BUDGET
535,224.87
535,224.87
19,544.09
465,627.34
0.00
485,171.43
535,224.87
485,171.43
50,053.44
JULY
31,
JULY
ACTUAL
3,105,992.97
3,105,992.97
1,318.98
861,905.46
40,933.57
904,158.01
3,105,992.97
904,158.01
2,201,834.96
2015
%
VARI-
ANCE
480
. 3
480.3
93
. 2
(
85.
1)
100
.0
(86
.
3)
480.3
(
86.3)
4298.9
FISCAL
YEAR
BUDGET
6,422,698.00
6,422,698.00
234,529
.
00
5,587,528.00
0.00
5,822,057.00
6,422,698.00
5,822,057.00
600,641.00
PAGE:
5
F-YR:
16
FISCAL
YEAR-TO-DATE
ACTUAL
3,268,025.58
3,268,025.58
1,770.28
1,218,826.70
40,933.57
1,261,530.55
3,268,025.58
1,261,530.55
2,006,495.03
%
VARI-
ANCE
(4
9.
1 )
(49
.1)
99.2
78.1
100.0
78.3
(49
.1)
78.3
234.0
5
33
DATE:
08
/
13
/
2015
TIME:
08:35:48
ID:
GL480000.WOW
DEPARTMENT
DESCRIPTION
REVENUES
REVENUES
TOTAL REVENUES
EXPENSES
ADMINISTRATION
TOTAL EXPENSES
TOTAL
FUND
REVENUES
TOTAL
FUND
EXPENSES
SURPLUS
(DEFICIT)
FOR
FOR
VILLAGE OF SUGAR
GROVE
SUMMARIZED REVENUE & EXPENSE REPORT
FUND:
DEBT
SERVICE
FUND
3 PERIODS ENDING
JULY
BUDGET
75,915
.
26
75,915.26
75,944
.
01
75,944.01
75,915
.
26
75,944.01
(28.
75)
JULY
31,
JULY
ACTUAL
75,863.49
75,863.49
29,995
.
00
29,995
.
00
75,863.49
29,995
.
00
45,868.49
2015
\
VARI-
ANCE
0.0
0.0
60.5
60.5
0.0
60.5
(9642.5)
FISCAL
YEAR
BUDGET
910
,
983.00
910,983.00
911,328.00
911,328
.
00
910
,
983
.
00
911
,
328.00
(345
.
00)
PAGE: 6
F-YR:
16
FISCAL
YEAR-TO-DATE
ACTUAL
227
,
585.25
227,585.25
102,826
.
25
102,826.25
227,585.25
102,826.25
124
,
759
.
00
\
VARI-
ANCE
(75.0)
(75.0)
88.7
88.7
(75.0)
88.7
(6262.0)
6
34
DATE:
08
/
13
/
2015
TIME:
08
:
35:48
ID:
GL480000.WOW
DEPARTMENT
DESCRIPTION
REVENUES
OPERATING
REVENUES
CAPITAL
REVENUES
TOTAL
REVENUES
EXPENSES
INFORMATION TECHNOLOGY
ADMINISTRATION
PW
ADMINISTRATION
WATER
OPERATIONS
SEWER
OPERATIONS
WATER
CAPITAL
SEWER
CAPITAL
TOTAL
EXPENSES
TOTAL
FUND
REVENUES
TOTAL FUND
EXPENSES
SURPLUS
(DEFICIT)
FOR
FOR
VILLAGE
OF SUGAR
GROVE
SUMMARIZED REVENUE & EXPENSE REPORT
FUND:
WATERWORKS
& SEWERAGE FUND
3
PERIODS
ENDING
JULY
BUDGET
277,655.85
33,244.68
310,900
.
53
2,474.43
138
,
264.83
7 6 ,
290.53
50,962
.
72
12,003.46
326
,
968.77
8,333.34
615,298.08
310
,
900.53
615,298.08
(304,397
.
55)
JUL
Y
31
,
JULY
ACTUAL
12,070.91
20,283.54
32,354.45
1,059
.
49
60,354.25
52
,
052
.
33
32,938
.
26
1 ,
896
.
21
19,941.70
6,038
.
00
174,280.24
32,354.45
174,280.24
(141,925.79)
2015
%
VARI-
ANCE
(
95.
6)
(3
8.
9)
(
89.
5)
57
. 1
56
. 3
31.7
35.3
84
. 2
93.9
27.5
71
. 6
(
89
. 5 )
71.6
(5
3.
3)
FISCAL
YEAR
BUDGET
3,331
,
870.00
398,936.00
3,730
,
806.00
29,693
.
00
1,659,177.00
915
,
485.00
611
,
552
.
00
144,041.00
3 ,
923
,
625.00
100,000.00
7 ,
383,573
.
00
3,730,806
.
00
7,383
,
573.00
(3
,
652,767
.
00
)
PAGE : 9
F-YR:
16
FISCAL
YEAR-TO-DATE
ACTUAL
553,962
.
70
76,344
.
50
630,307.20
2
,279
.
97
578,031.18
185,109.40
56,031.61
2,829
.
49
328,940.01
7,538.00
1 ,
160,759.66
630
,
307.20
1,160,759.66
(530,452.46
)
%
VARI-
ANCE
(
83.3)
(
80.
8 )
(
83
. 1 )
92.
3
65
. 1
79.7
90
. 8
98.0
91.6
92
. 4
84
. 2
(
83.
1)
84.2
(
85.4)
7
35
DATE:
08
/
13/2015
TIME : 0 8 : 3 5 : 4 8
ID:
GL480000
.
WOW
VILLAGE OF
SUGAR
GROVE
SUMMARIZED
REVENUE
& EXPENSE REPORT
FOR FUND: REFUSE
FUND
FOR 3
PERIODS
ENDING
JULY
31,
2015
%
JULY
JULY
VARI-
DEPARTMENT
DESCRIPTION
BUDGET
ACTUAL
ANCE
REVENUES
REVENUES
TOTAL REVENUES
EXPENSES
ADMINISTRATION
TOTAL EXPENSES
TOTAL
FUND
REVENUES
TOTAL
FUND
EXPENSES
SURPLUS
(DEFICIT)
72,578.18
72,578.18
74,285.51
74,285.51
72,578.18
74,285.51
(1,707.33)
1,366.54
(98
.1)
1,366.54
(
98
.1)
68,803.65
7.3
68,803
.
65
7.3
1,366.54
(98.1)
68,803.65
7.3
(67,437.11)
3849
. 8
FISCAL
YEAR
BUDGET
870,938.00
870,938.00
891,426.00
891,426.00
870,938.00
891,426.00
(20,488.00)
PAGE:
10
F-YR:
16
FISCAL
%
YEAR-TO-DATE
VARI-
ACTUAL
ANCE
143,995.56
143,995
.
56
140,944.68
140,944.68
143,995.56
140,944
.68
3,050
.
88
(
83.4)
( 83
.4
)
84.1
84.1
(
83.4)
84.1
(114.
8)
8
36
DATE:
08
/
13
/
2015
TIME :
13:22:39
ID
:
GL470001
.
WOW
ACC
O
UNT
NUMBER
REVENUES
REVENUES
01-00-3110
01-00-3111
01-00-3112
01-00-3113
01-00-3114
01-00-3115
01-00-3150
01-00-3151
01-00-3162
01-00-3163
01-00-3164
01-00-3210
01-00-3250
01-00-3291
01-00-3310
01-00-3320
01-00-3330
01-00-3340
01-00-3350
01-00-3380
01-00-3390
01-00-3410
01-00-3420
01-00-3440
01-00-3449
01-00-3450
01-00-3451
01-00-3453
01-00-3460
01-00-3510
01-00-3520
01-00-3590
01-00-3740
01-00-3760
01-00-3761
01-00-3790
01-00-3791
01
-
00
-
3810
01-00-3811
01-00-3817
01-00-3818
01-00-3820
01-00-3830
DESCRIPTION
PROPERTY TAX - CORPORATE
PROPERTY
TAX
-
AUDIT
PROPERTY
TAX
-
LIABILITY
INSUR
PROPERTY
TAX
- I .
M.R
. F .
PROPERTY
TAX
-
SOCIAL
SECURITY
PROPERTY
TAX
-
STREET
LIGHTING
PROPERTY
TAX
-
POLICE
PROPERTY
TAX
-
POLICE
PENSION
UTILITY
TAX
-
ELECTRICITY
UTILITY
TAX
- NATURAL GAS
UTILITY
TAX
- TELECOMMUNICTION
LIQUOR
LICENSE
FRANCHISE
AGREEMENT
CONTRACTORS
LICENSE
BUILDING
PERMITS
CERTIFICATE
OF OCCUPANCY
FEES
PLAN REVIEW
FEES
REINSPECTION
FEES
TRANSITION
FEES
TOWING
FEES
OTHER
LICENSES,PERMITS
&
FEES
STATE
INCOME
TAX
REPLACEMENT
TAX
GRANTS
STATE
SALES
TAX
REBATE
STATE
SALES
TAX
STATE
USE
TAX
STATE
GAMES
LICENSES
ROAD
&
BRIDGE
TAX
COURT
FINES
FORFEITURES
OTHER
FINES
ZONING &
FILING
FEES
REVIEW & DEVELOPMENT
FEES
REIMBURSEMENT
CHARGES FOR
POLICE
SERVICES
OTHER CHARGES FOR
SERVICES
INTEREST
INCOME
INTEREST
INCOME -
CD
INTEREST
INCOME - MUNI BONDS
INTEREST
INCOME - US AGENCY
RENTAL
INCOME
DONATIONS
VILLAGE
OF SUGAR GROVE
DETAILED
REVENUE & EXPENSE REPORT
BUDGET VS . ACTUAL
WITH PERCENT VARIANCE
FOR 3
PERIODS
ENDING
JULY
31,
2015
FUND: GENERAL
FUND
JULY
BUDGET
32
,
435.00
623.00
2,749.00
1,385.00
8,737.00
2,515.00
5,988.00
11,581.00
24,737.42
9,788.59
21
,
539.59
1,566.67
5,395.42
3,125.00
6,293.75
441
.
67
470.42
289.34
0.00
3,333
.3
4
96
.
67
74,225
.
25
165
.
00
91.67
(1
,
416.67)
67,822.50
14,545.17
1,400
.
00
1,578.00
4,166.67
625.00
7,916.67
1,333.34
9,118.34
3,695.84
833.34
154
.1
7
1,283.34
2,328.34
0.00
0.00
0 .
00
0.00
JULY
ACTUAL
11,173
.9
1
142
.2
1
680.23
556.54
2,349
.
85
729.68
2,473.53
1,075.99
21,552
.
35
4,730.48
19,802.11
1,250
.
00
0 .
00
2,550
.
00
11,768.00
700.00
826
.
80
850.00
9,492.30
3 ,
500
.
00
515.00
161,276.54
348
.
97
0 .
00
0.00
71,772.35
16,623.54
0 .
00
549
.
73
6,847.74
0.00
4,050
.
00
0.00
15,498.50
1,630.00
10,000.00
436.29
10
7
.64
762
.
54
161.80
0 .
00
3 ,
590
.
00
0 .
00
%
VARI-
ANCE
(
65
.
5)
(77.1)
(75
.
2)
(59.
8)
(
73.
1)
(
70
.
9)
(58.6)
(
90
.
7)
(
12.
8)
(51
.6)
(8.
0)
(20.
2)
100.0
(
18.4)
86.9
58
. 4
75
. 7
193
. 7
100
. 0
5.0
432
. 7
117.2
111.5
100.0
100
. 0
5 . 8
14.2
100
.0
(
65.
1)
64.3
100.0
(48.
8)
100.0
69.9
(55
.
9)
1099
. 9
182.9
(
91.
6)
(67.
2)
100.0
0 . 0
100.0
0.0
FISCAL
YEAR
BUDGET
753,401.00
14,459.00
63,855
.
00
32,175.00
202,950.00
58,410
.
00
139,095.00
269,002
.
00
296,849.00
117,463.00
258,475.00
18
,800
.0
0
64,745
.
00
37,500.00
75,525.00
5,300
.
00
5 ,
645
.00
3,472.00
0 .
00
40,000.00
1,160.00
890,703.00
1,980.00
1,100.00
(17,000
.
00)
813,870.00
174,542.00
16,800
.
00
36,663.00
50
,000.00
7,500
.
00
95,000.00
16,000
.00
109,420
.
00
44,350
.
00
10,000.00
1
,850
.00
15,400
.
00
27,940.00
0.00
0.00
0 .
00
0.00
FISCAL
PAGE : 1
F-YR:
16
%
YEAR-TO
- DATE
VARI-
ACTUAL ANCE
472,525
.7
4
6,014.03
28,765.79
23,535.34
99
,
371.05
30,857.00
104,601.48
45,501.91
56,394.65
20
,
893
.
21
61,940
.
14
1,250
.
00
16,297
.
28
9,450.00
34,238.00
1,100.00
1 ,
952
.
80
1,615
.
00
14,238.45
4,982.50
1,335
.
00
306,462
.
64
773.76
0.00
0.00
187,406.45
49,621.42
2,818.67
18,892.72
14,500
.8
8
0 .
00
14,682.00
1,800.00
31
,
737
.
59
27,980
.
60
10,000.00
711.
2 9
287.92
2,269.89
800
.41
0 .
00
7,780.00
0.00
( 3
7.
2)
(58.
4)
(54.9)
(
26
.
8)
(51.0)
(47
.
1)
(24.8)
(
83.
0)
(
81.
0)
(82.2)
(76
.
0)
(
93.3
)
(
74
.
8)
(74
. 8 )
(54
.
6)
(
79
.2
)
(65
.
4)
(53.
4)
100
. 0
(
87
.
5)
15.0
(65.
5)
(60.
9)
100.0
100
. 0
(
76
.
9)
(
71
.
5)
(
83.2)
(48.
4)
(71
.
0)
100
. 0
(84
.
5)
(88.7)
(70
.
9)
(3
6 .
9)
0 . 0
(61.
5)
(
98
.
1)
(
91.
8)
100.0
0.0
100
. 0
0.0
9
37
DATE:
08
/
13
/
2015
TIME
:
13
:
22
:
39
ID:
GL470001
.
WOW
ACCOUNT
NUMBER
REVENUES
REVENUES
01-00-3840
01-00-3878
01-00
-3
879
01-00-3880
01-00-3881
01-00-3888
01-00-
3
890
01-00-3920
01-00-3990
DESCRIPTION
MAP
/ PLAN/ CODE CHARGES
GAIN
(LOSS)
- AGENCY
REALIZED
GAIN
(LOSS)
- AGENCY UNREAL
GAIN
(LOSS)
- MUNI
BOND
REAL
GAIN
(LOSS
) - MUNI
BOND
UNREAL
GAIN
(
LOSS)
- IMET
MISCELLANEOUS INCOME
PROCEEDS-CAPITAL
ASSET
SALE
INTERFUND OPERATING
TRANSFER
TOTAL REVENUES : REVENUES
INFORMATION TECHNOLOGY
EXPENSES
01-49-6307
01-49
-
6502
01-49-6613
I.S.
SERVICES
TELECOMMUNICATIONS
GENERAL
OFFICE
SUPPLIES
TOTAL
EXPENSES
: INFORMATION TECHNOLOGY
ADMINISTRATION
EXPENSES
01-50-6101
01-50-6201
01-50-6202
01-50-6204
01-50-6205
01-50-6206
01-50-6208
01-50-6209
01-50-6301
01-50
-
6306
01-50-6307
01-50-6309
01-50-6402
01-50-6403
01-50-6501
01-50
-
6502
01-50-6503
01-50
-
6504
01-50-6507
SALARIES
- REGULAR
MEDICAL/ DENTAL INSURANCE
GROUP
LIFE
INSURANCE
UNEMPLOYMENT COMPENSATION
SOCIAL
SECURITY
CONTRIBUTIONS
IMRF
CONTRIBUTIONS
TRAINING
& MEMBERSHIPS
UNIFORM
ALLOWANCE
LEGAL
SERVICES
MEDICAL
SER
V
ICES
I.
S.
SERVICES
OTHER
PROFESSIONAL
SERVICES
RENTAL
REPAIR
& MAINT .
SERV-EQUIPMENT
POSTAGE & DELIVERY
TELECOMMUNICATIONS
PUBLISHING
PRINTING
MILEAGE REIMBURSEMENT
VILLAGE
OF SUGAR GROVE
DETAILED
REVENUE & EXPENSE REPORT
BUDGET VS . ACTUAL
WITH PERCENT VARIANCE
FOR 3
PERIODS
ENDING
JULY
31
,
2015
FUND : GENERAL FUND
JULY
BUDGET
8.34
0 .
00
0 .
00
0 .
00
0.00
0.00
41.67
0.00
3,333.34
336
,
340.20
2 ,
426.00
45.00
3 .
34
2 ,
474.34
16,120
.
25
2 ,
362.75
14
.
00
16.09
1 ,
032.59
1 ,
515.34
382.84
8 .·
34
1,072
.
50
9 .
59
0.00
43.75
127.92
10.00
l.
67
159
.
34
0.00
0.00
181.25
JULY
ACTUAL
10
.
00
0 .
00
0.00
0 .
00
0.00
0.00
0 .
00
0.00
3,333.33
393,717.95
1,009
.
50
50.00
0.00
1,059.50
%
VARI-
ANCE
19.9
0.0
0.0
0 . 0
0.0
0.0
100.0
0.0
0 . 0
17.0
58.3
(11.1)
100
. 0
57
. 1
14,978.29
7.0
2,638
.
72
(11.6)
13.20
5.7
0 .
00
100.0
1,058
.
24
(2.4)
1,408
.
00
7.0
1,614.85
(321.8
)
0 .
00
100.0
500.00
53.3
0.00
100
. 0
0 .
00
0.0
12
.
50
71.4
127.82
0.0
21.42
(114.2)
0.00
100.0
304.82
(91.3)
0 .
00
0.0
0.00
0.0
279.23
(54
.
0)
FISCAL
YEAR
BUDGET
100.00
0 .
00
0.00
0.00
0.00
0 .
00
500
.
00
0 .
00
40,000.00
4,794,999.00
29,112
.
00
540.00
40
.
00
29,692
.
00
193
,
443.00
28,353.00
168
.
00
193.00
12,391
.
00
18,184
.
00
4,594.00
100.00
12
,
870.00
115.00
0 .
00
525.00
1,535.00
120
.
00
20.00
1 ,
912
.
00
0.00
0.00
2,175.00
FISCAL
PAGE : 2
F-YR
:
16
%
YEAR-TO-DATE
VARI-
ACTUAL ANCE
10.00
0 .
00
0 .
00
0 .
00
0 .
00
0.00
56
.
39
0.00
9,999
.
99
1 ,
725
,
451.99
2,360.00
140.00
0 .
00
2,500
.
00
52,186
.
72
8 ,
533.13
39
.
60
0.00
3,685.71
4,905
.
67
2,424.85
0.00
560.00
0 .
00
0.00
37.50
381
.
86
21.42
0.00
746.51
0 .
00
0 .
00
836
.
94
(
90
.
0)
0.0
0.0
0 . 0
0.0
0 . 0
(88.7)
0 . 0
(
75
. 0 )
(
64
.
0)
91
. 8
74
. 0
100
. 0
91.5
73.0
69.9
76
. 4
100.0
70.2
73.0
47.2
100.0
95.6
100.0
0.0
92.8
75
. 1
82.1
100.0
60.9
0.0
0.0
61.5
10
38
DATE:
08
/
13
/
2015
TIME:
13
:
22:39
ID
:
GL470001
.
WOW
ACCOUNT
NUMBER
ADMINISTRATION
EXPENSES
01-50-6508
01-50-6509
01-50-6514
01-50-6603
01-50-6604
01-50-6608
01-50-6613
01-50-7510
DESCRIPTION
RECEPTIONS
& ENTERTAINMENT
RECRUITMENT
INSURANCE PREMIUMS
SPECIALIZED
SUPPLIES
SAFETY
SUPPLIES
BOOKS &
PUBLICATIONS
GENERAL
OFFICE
SUPPLIES
DEPRECIATION
EXPENSE
- ADMIN
TOTAL EXPENSES :
ADMINISTRATION
POLICE
EXPENSES
01-51-6101
01-51-6102
01-51-6104
01-51-6105
01-51-6106
01-51-6201
01-51-6202
01-51-6204
01-51-6205
01-51-6206
01-51-6208
01-51-6209
01-51-6301
01-51-6306
01-51-6307
01-51-6309
01-51-6402
01-51-6403
01-51-6407
01-51-6500
01-51-6501
01-51-6502
01-51-6504
01-51-6507
01-51-6508
01-51-6509
01-51-6601
01-51-6603
01-51-6604
SALARIES
- REGULAR
SALARIES
-
OVERTIME
SALARIES
-
PART-TIME
SALARIES
- SEASONAL
POLICE
PENSION
MEDICAL/ DENTAL INSURANCE
GROUP
LIFE
INSURANCE
UNEMPLOYMENT
CONTRIBUTIONS
SOCIAL
SECURITY
CONTRIBUTIONS
IMRF
CONTRIBUTIONS
TRAINING
& MEMBERSHIPS
UNIFORM
ALLOWANCE
LEGAL
SERVICES
MEDICAL
SERVICES
I.
S.
SERVICES
OTHER
PROFESSIONAL
SERVICES
RENTAL
REPAIR
&
MAINT.
SERV-EQUIPMENT
REPAIR
&
MAINT.
SERV-VEHICLES
GENERAL
EQUIPMENT
POSTAGE &
DELIVERY
TELECOMMUNICATIONS
PRINTING
MILEAGE REIMBURSEMENT
RECEPTIONS
& ENTERTAINMENT
RECRUITMENT
FUELS
&
LUBRICANTS
SPECIALIZED
SUPPLIES
SAFETY
SUPPLIES
VILLAGE
OF
SUGAR GROVE
DETAILED
REVENUE & EXPENSE REPORT
BUDGET
VS.
ACTUAL WITH PERCENT VARIANCE
FOR 3
PERIODS
ENDING
JULY
31,
2015
FUND: GENERAL
FUND
JULY
BUDGET
0.00
0.00
4,900.00
0.00
0.00
85
.
59
20.84
0.00
28,064.65
76,769.42
11,279
.
67
12
,
139
.
75
0.00
22,416.84
18,515.92
95.67
88.09
7,664.50
0 .
00
732
.
92
927
.
50
6,533.34
67.67
1,013.17
1,004.42
97.34
1,359
.
17
2,500
.
00
333.34
120.42
14,260.17
106
.
25
0.00
12.50
0.00
2,835.00
1,193.75
16.67
JULY
ACTUAL
0.00
0.00
0 .
00
0.00
0.00
0.00
0.00
0.00
22,957
.
09
75,269
.
68
13,343.22
16,602.82
0 .
00
22,416
.
83
16,762.66
96.00
0 .
00
6,844
.
55
0.00
875.00
0.00
12,035.10
245.00
0.00
883.48
97.33
1,395
.
37
1,815.12
0.00
174
.
10
1,579.48
0.00
0.00
0.00
40.00
4,488.98
2,744.89
41.55
%
VARI-
ANCE
0.0
0.0
100.0
0.0
0.0
100.0
100
. 0
0 . 0
18.2
1.9
(
18
.
2)
(3
6.
7)
0.0
0 . 0
9 . 4
(
0.
3)
100
. 0
10.7
0 . 0
(
19.
3)
100.0
(84.
2)
(262.
0)
100.0
12
. 0
0.0
(2.
6)
27.4
100
. 0
(44.
5)
88.9
100.0
0.0
100.0
100.0
(58.3)
(129
.
9)
(149
.
2)
FISCAL
YEAR
BUDGET
0 .
00
0.00
58,800.00
0.00
0 .
00
1,027.00
250
.
00
0.00
336
,
775.00
921,233.00
135,356.00
145,677
.
00
0 .
00
269
,
002.00
222,191.00
1 ,
148.00
1,057.00
91,974.00
0.00
8,795.00
11,130
.
00
78,400.00
812
.
00
12,158.00
12,053.00
1,168
.
00
16,310
.
00
30,000
.
00
4,000.00
1,445.00
171,122.00
1,275
.
00
0 .
00
150.00
0 .
00
34,020.00
14,325.00
200.00
FISCAL
PAGE:
3
F-YR:
16
%
YEAR-TO-DATE
VARI-
ACTUAL ANCE
0.00
0.00
0.00
0 .
00
0 .
00
0 .
00
153.
3 5
0.00
74,513
.
26
259,748.88
44,180
.
58
49,619
.
89
0.00
67,250.49
50,975.46
288
.
00
0 .
00
22,983
.
51
0.00
2 ,
120.00
4,000
.
00
13,435.10
872.00
0 .
00
5,649.48
288.79
1,395
.
37
1,815.12
0.00
174.10
37,039.55
0 .
00
0.00
0.00
40.00
8,273
.5
4
3,041.89
41.55
0.0
0 . 0
100.0
0.0
0.0
100.0
38.6
0 . 0
77.8
71.8
67
. 3
65.9
0.0
75
. 0
77.0
74.9
100.0
75.0
0 . 0
75
. 9
64
. 0
82.8
(
7.
3)
100.0
53.1
75.2
91.4
93.9
100.0
87.9
78
. 3
100.0
0.0
100.0
100.0
75.6
78.7
79
. 2
11
39
DATE:
08/13/2015
TIME:
13:22:39
ID:
GL470001.WOW
ACCOUNT
NUMBER
POLICE
EXPENSES
01-51-6608
01-51-6613
01-51-6617
01-51-7010
01-51-7510
DESCRIPTION
BOOKS &
PUBLICATIONS
GENERAL
OFFICE
SUPPLIES
VEHICLES
MAINT .
SUPPLIES
TFR
TO
EQUIP
. REPLACE
FUND
DEPRECIATION
EXPENSE -
POLICE
TOTAL
EXPENSES
:
POLICE
PUBLIC
WORKS-
STREET
DIVISION
EXPENSES
01-53-6101
01-53-6102
01-53-6104
01-53-6105
01-53-6201
01-53-6202
01-53-6204
01-53-6205
01-53-6206
01-53-6208
01-53-6209
01-53-6301
01-53-6303
01-53-6306
01-53
-6
307
01-53-6309
01-53-6402
01-53-6403
01-53-6405
01-53-6407
01-53-6500
01-53-6501
01-53-6502
01-53-6503
01-53-6504
01-53-6507
01-53-6508
01-53-6509
01-53-6511
01-53-6516
01-53-6601
01-53-6603
SALARIES
- REGULAR
SALARIES
- OVERTIME
SALARIES-PART-TIME
SALARIES
- SEASONAL
MEDICAL/ DENTAL INSURANCE
GROUP
LIFE
INSURANCE
UNEMPLOYMENT
COMPENSATION
SOCIAL
SECURITY CONTRIBUTIONS
IMRF CONTRIBUTIONS
TRAINING
& MEMBERSHIPS
UNIFORM
ALLOWANCE
LEGAL
SERVICES
ENGINEERING
SERVICES
MEDICAL
SERVICES
I.S.
SERVICES
OTHER
PROFESSIONAL
SERVICES
RENTAL
REPAIR
& MAINT. SERV-EQUIPMENT
REPAIR
& MAINT . SERV-ROW
REPAIR
& MAINT.
SERV-VEHICLES
GENERAL EQUIPMENT
POSTAGE
& DELIVERY
TELECOMMUNICATIONS
PUBLISHING
PRINTING
MILEAGE REIMBURSEMENT
RECEPTIONS
& ENTERTAINMENT
RECRUITMENT
ELECTRICITY
EMPLOYEE
ACTIVITIES
FUELS
& LUBRICANTS
SPECIALIZED
SUPPLIES
VILLAGE
OF
SUGAR
GROVE
DETAILED
REVENUE & EXPENSE REPORT
BUDGET
VS.
ACTUAL WITH PERCENT VARIANCE
FOR 3
PERIODS
ENDING
JULY
31,
2015
FUND : GENERAL
FUND
JULY
BUDGET
33.34
233
.34
0.00
6,702.00
0.00
189,052.17
22,699.17
1,502.17
0.00
823
.
34
4,236.09
36.59
24.17
1,894.50
2,274.92
304.17
104.17
83.34
575.00
40.09
0.00
1,122
.
92
2
91.
59
308.09
3,552.00
1,666.67
0.00
14.59
263.59
12.50
16.67
2.09
16
.67
12.50
3,125.00
20.84
1,449.67
458.34
JULY
ACTUAL
0.00
185
.
48
0.00
6,702.00
0.00
184,638.64
18,119.50
880.44
0.00
1,490.00
3,596.51
32
.
00
0.00
1,519
.
59
1,781.75
10
.
00
646.00
15
.00
4,547
.
00
110.00
0.00
1,000.00
41.64
287
.
72
1,700.00
3,177.61
0.00
71
.
41
450
.
19
0.00
0.00
0.00
0 .
00
0.00
5,763.43
0.00
1,452
.
49
0.00
%
VARI-
ANCE
100.0
20.5
0.0
0.0
0
.0
2.3
20.1
41.3
0.0
(
80.
9)
15.1
12.5
100.0
19.7
21.6
96.7
(520.
1)
82
. 0
(
690.
7)
(
174
.
3)
0.0
10.9
85
. 7
6.6
52.1
(90
.6
)
0.0
(3
8
9.
4)
(
70.
7)
100.0
100.0
100.0
100.0
100.0
(84.
4)
100.0
(0
.1)
100.0
FISCAL
YEAR
BUDGET
400.00
2,800.00
0.00
80
,42
4.00
0.00
2,268,625.00
272,390.00
18,026.00
0.00
9,880.00
50,833
.
00
439.00
290.00
22,734.00
27,299
.
00
3,650.00
1,250.00
1,000.00
6,900.00
481.00
0.00
13,475.00
3,499.00
3,697
.
00
42,624.00
20,000.00
0.00
175.00
3,163.00
150.00
200.00
25.00
200.00
150.00
37,500.00
2
50
.00
17,396.00
5,500.00
FISCAL
PAGE : 4
F-YR:
16
%
YEAR-TO-DATE
VARI-
ACTUAL ANCE
0.00
394.80
0
.00
20,106.00
0.00
593
,
734
.
10
68,508.53
2,384.09
0 .
00
4,390.00
11,926.55
101
.
60
0
.0
0
5,586.87
6,659.64
32.50
646.00
547.50
5,883.75
110
.
00
0.00
1 ,
012.50
1,707.57
287.72
1,822.92
5,043
.
45
0.00
71.41
802.22
78.20
0
.0
0
0.00
56.66
0 .
00
5,813
.
79
0.00
2,469.80
2,192
.
17
100.0
85.9
0.0
75.0
0.0
73.8
74.8
86.7
0.0
55
. 5
76.5
76.8
100.0
75
. 4
75.6
99.1
48.3
45.2
14.7
77.1
0.0
92.4
51.2
92.2
95.7
74.7
0.0
59.1
74.6
47.8
100.0
100.0
71.6
100.0
84.5
100.0
85
. 8
60.1
12
40
DATE:
08
/
13
/
2015
TIME :
13:22
:
39
ID:
GL470001.WOW
ACCOUNT
NUMBER
DESCRIPTION
VILLAGE
OF
SUGAR
GROVE
DETAILED
REVENUE & EXPENSE REPORT
BUDGET
VS.
ACTUAL WITH PERCENT VARIANCE
FOR 3
PERIODS
ENDING
JULY
31,
2015
FUND : GENERAL FUND
JULY
BUDGET
JULY
ACTUAL
%
V
ARI-
ANCE
FISCAL
YEAR
BUDGET
FISCAL
PAGE
: 5
F-YR
:
16
%
YEAR-TO-DATE
VARI-
ACTUAL ANCE
-- -- --- --
------
-----------------------
---
-----
---------
-
------
---
------------
-
---------
-
---------
--
--------------------
---
-------------
---- -
PUBLIC
WORKS-
STREET
DIVISION
EXPENSES
01-53
-
6604
01-53
-
6606
01-5
3
-6608
01-53-6609
01-53
-
6610
01
-
53-6612
01-53
-
6613
01-53-6615
01-53-6617
01
-
53-7010
01-53-7510
01-53-900
3
SAFETY
SUPPLIES
LANDSCAPING
SUPPLIES
BOOKS &
PUBLICATIONS
ROADWAY
MAINTENANCE
SUPPLIES
TRAFFIC
CONTROL
SUPPLIES
EQUIPMENT MAINTENANCE
SUPPLIES
GENERAL
OFFICE
SUPPLIES
SNOW
&
ICE
CONTROL
SUPPLIES
VEHICLE
MAINT.
SUPPLIES
TFR
TO
EQUIP
. REPLACE
FUND
DEPRECIATION
EXPENSE -
STREETS
INTERFUND TRANSFER
TOTAL
EXPENSES
:
PUBLIC
WORKS-
STREET
DI
V
ISION
BUILDING
MAINTENANCE
EXPENSES
01-54-6101
01-54-6102
01-54-6104
01-54-6105
01-54-6201
01-54-6202
01-54-6204
01-54-6205
01-54-6206
01-54-6208
01-54-6209
01-54-6301
01-54-6306
01-54-6402
01-54-6403
01-54-6406
01-54-6407
01-54-6500
01-54-6502
01
-
54-6507
01-54-6510
01
-
54-6512
01-54-6516
01-54-6601
01-54-6602
SALARIES
- REGULAR
SALARIES
- OVERTIME
SALARIES
- PART - TIME
SALARIES
- SEASONAL
MEDICAL/ DENTAL INSURANCE
GROUP
LIFE
INSURANCE
UNEMPLOYMENT
COMPENSATION
SOCIAL
SECURITY CONTRIBUTIONS
IMRF CONTRIBUTIONS
TRAINING
& MEMBERSHIPS
UNIFORM
ALLOWANCE
LEGAL
SERVICES
MEDICAL
SERVICES
RENTAL
REPAIR
& MAINT. SERV-EQUIPMENT
REPAIR
& MAINT .
SER
V
-BUILDINGS
REPAIR
& MAINT .
SERV-VEHICLES
GENERAL EQUIPMENT
TELECOMMUNICATIONS
MILEAGE REIMBURSEMENT
NATURAL
GAS
WATER
& SEWER
EMPLOYEE
ACTIVITIES
FUELS & LUBRICANTS
CUSTODIAL
SUPPLIES
75.00
3 ,
808.34
20
.
84
1,208
.
34
1,250
.
00
333.34
50
.
00
27,081.92
1,458
.
34
11,195.09
0.00
12,183
.
34
105
,
596
.
00
6,127.00
378.34
0.00
0.00
1,262
.
67
11.09
6 .
50
495.50
611.50
41
.
67
25
.
00
0.00
5.25
48.25
224.50
2,397.50
0.00
41
.
67
132.
00
0.00
0 .
00
355
.
42
0 .
00
327.34
375.00
48.83
7,860
.
00
0 .
00
1,987
.
44
1,219
.
55
266
. 3 7
2 .
78
0.00
581
.
74
11,195
.
08
0 .
00
12,183.34
82,037.41
4,449
.
70
280
.
99
0 .
00
0.00
929.45
8.00
0.00
351.02
444.70
0.00
0.00
0 .
00
0 .
00
6 .
11
434.61
1,600
.
21
0.00
0.00
246.65
0.00
0.00
171.60
0.00
0.00
742
.
43
34
. 8
(106.3)
100.0
(64.
4)
2.4
20
. 0
94
. 4
100
. 0
60.1
0.0
0 . 0
0.0
22.3
2 7 . 3
25
. 7
0.0
0.0
26.3
27.8
100.0
29.1
27.2
100.0
100
. 0
0 . 0
100.0
87
. 3
(
93.
5)
33
. 2
0.0
100.0
(
86.
8)
0.0
0 . 0
51
. 7
0.0
100
. 0
(
97
.
9)
900.00
45,700.00
250
.
00
14
,
500
.
00
15,000
.
00
4 ,
000
.
00
600.00
324,983
.
00
17,500.00
134
'
341.00
0 .
00
146,200.00
1,267
,
150.00
73 ,
524
.
00
4,540.00
0.00
0.00
15,152
.
00
133
.
00
78.00
5,946
.
00
7,338
.
00
500.00
300
.
00
0 .
00
63
.
00
579.00
2 ,
694.00
28,770.00
0 .
00
500.00
1,584.00
0 .
00
0.00
4,265.00
0 .
00
3,928.00
4 ,
500.00
278.42
7,860
.
00
0 .
00
2 ,
507.44
1,219
.
55
30
2
.30
68.17
164
.
37
581.74
33
,
585
.
24
0.00
36,550.02
211,252.69
17,789
.
78
786.75
0.00
0.00
3,158
.
11
26.40
0.00
1 ,
380
.
98
1,746
.
21
0.00
0 .
00
0 .
00
0 .
00
16.71
799
.
61
9,125.30
0 .
00
0 .
00
506.57
0.00
0 .
00
469
.
98
0.00
0 .
00
742
.
43
69
. 0
82
. 8
100.0
82.7
91.8
92.4
88.6
99.9
96
. 6
75
. 0
0 . 0
75.0
83
. 3
75
. 8
82.6
0.0
0 . 0
79
. 1
80.1
100.0
76
. 7
76
. 2
100
. 0
100
. 0
0.0
100.0
97
. 1
70
. 3
68
. 2
0.0
100.0
68.0
0.0
0.0
88
. 9
0.0
100.0
83.
5
13
41
DATE:
08
/
13
/
2015
TIME:
13
:
22:
3 9
ID
:
GL470001.WOW
ACCOUNT
NUMBER
DESCRIPTION
BUILDING
MAINTENANCE
EXPENSES
01-54-6603
01-54
-
6604
01-54-6606
01-54-6608
01-54
-
6611
01-54-6613
01-54
-
66
1 7
01-54-7010
01-54
-
7510
SPECIALIZED
SUPPLIES
SAFETY
SUPPLIES
LANDSCAPING
SUPPLIES
BOOKS &
PUBLICATIONS
BUILDING
MATERIALS &
SUPPLIES
GENERAL
OFFICE
SUPPLIES
VEHICLE
MAINT.
SUPPLIES
TRANS.
TO
EQUIP
REPL.
FUND
DEPRECIATION
EXP-BLDG MAINT
TOTAL
EXPENSES:
BUILDING
MAINTENANCE
COMMUNITY DEVELOPMENT
EXPENSES
01-55-6101
01-55-6102
01-55
-
6104
01-55-6201
01
-
55
-
6202
01-55-6204
01-55-6205
01-55-6206
01-55-6208
01-55-6209
01-55-6301
01-55-6303
01-55-6306
01
-
55
-
6307
01-55-6309
01-55-6402
01-55
-
6403
01-55-6407
01-55
-
6500
01-55-6501
01-55-6502
01-55-6503
01-55-6504
01-55-6507
01-55-6508
01-55-6509
01-55-6601
01-55-6603
SALARIES
- REGULAR
SALARIES
- OVERTIME
SALARIES
-
PART-
TIME
MEDICAL/ DENTAL
INSURANCE
GROUP
LIFE
INSURANCE
UNEMPLOYMENT
COMPENSATION
SOCIAL
SECURITY
CONTRIBUTIONS
IMRF CONTRIBUTIONS
TRAINING
& MEMBERSHIPS
UNIFORM
ALLOWANCE
LEGAL
SERVICES
ENGINEERING
SERVICES
MEDICAL
SERVICES
I .
S.
SERVICES
OTHER
PROFESSIONAL
SERVICES
RENTAL
REPAIR
& MAINT.
SERV-EQUIP
REPAIR
& MAINT.
SERV-VEHICLES
GENERAL EQUIPMENT
POSTAGE
& DELIVERY
TELECOMMUNICATIONS
PUBLI SHING
PRINTING
MILEAGE REIMBURSEMENT
RECEPTIONS
& ENTERTAINMENT
RECRUITMENT
FUELS
& LUBRICANTS
SPECIALIZED
SUPPLIES
VILLAGE OF SUGAR GROVE
DETAILED
REVENUE & EXPENSE REPORT
BUDGET
VS.
ACTUAL WITH PERCENT VARIANCE
FOR 3
PERIODS
ENDING
JULY
31,
2015
FUND: GENERAL
FUND
JULY
BUDGET
108.34
37
.
50
125.00
0 .
00
164.59
12.50
83.34
482.17
0.00
13,879.64
22,884.09
20
.
75
431.25
4,364.34
34.00
23.34
1,785
.
25
2,153.09
302.50
25
.
00
4,700
.
00
6,400.00
19.25
29.17
4,699.59
188.25
62.50
125
.
00
16
.
67
33.34
235
.
00
108.34
62.50
2.09
25.00
0.00
81.09
8.
34
JULY
ACTUAL
0.00
16.67
0.00
0 .
00
21.93
0.00
0.00
482.17
0.00
10,186
.
24
21,016
.
00
0.00
455.28
4,716.39
32
.
00
0.00
1 ,
541.87
1,975.52
0.00
0 .
00
29,112
.
70
12,739.00
0 .
00
0.00
11,149
.
75
188
.
28
49.86
0.00
0.00
25.94
746.64
65.55
0.00
0 .
00
0.00
0 .
00
104.82
0 .
00
%
VARI-
ANCE
100.0
55.5
100.0
0.0
86.6
100.0
100.0
0 . 0
0 . 0
26
. 6
8.1
100.0
(5
.
5)
( 8 .
0)
5.8
100.0
13
. 6
8 . 2
100.0
100.0
(519.4)
(99.0)
100.0
100
. 0
(137.2)
0 . 0
20.2
100.0
100
. 0
22
. 2
(21
7.
7)
3
9.
5
100.0
100
. 0
100.0
0 . 0
(29
.
2)
100.0
FISCAL
YEAR
BUDGET
1,300
.
00
450.00
1,500
.
00
0 .
00
1,975.00
150
.
00
1,000.00
5,786
.
00
0.00
166,555
.
00
274,609.00
249
.
00
5,175.00
52,372.00
408.00
280
.
00
21,423
.
00
25,837.00
3,630.00
300.00
56,400.00
76,800.00
231.00
350.00
56,395
.
00
2,259.00
750
.
00
1,500
.
00
200
.
00
400
.
00
2,820.00
1 ,
300.00
750.00
25.00
300.00
0.00
973.00
100.00
FISCAL
PAGE : 6
F-YR:
16
%
YEAR-TO-DATE
VARI-
ACTUAL ANCE
681.00
16
.
67
0.00
0.00
21
.
93
0 .
00
0.00
1,446.51
0.00
38,714.94
73,338
.
76
0.00
2,243.88
14,971.79
96
.
00
0.00
5,429
.
70
6,893
.
89
245.00
0.00
58,059
.
40
18,629.50
0 .
00
0.00
16,116.25
559
.
52
77.17
0 .
00
0.00
25
.
94
1,352.21
148
.
35
0.00
0.00
56
.
66
0 .
00
104
.
82
0.00
47.6
96.3
100
. 0
0 . 0
98
. 8
100
. 0
100.0
75.0
0.0
76.7
73.2
100.0
56.6
71.4
76.4
100.0
74
. 6
73.3
93
. 2
100.0
( 2 .
9)
75.7
100.0
100.0
71.4
75.2
89.
7
100
. 0
100.0
93.5
52
. 0
88.5
100.0
100.0
81.1
0 . 0
89.2
100.0
14
42
DATE:
08
/
13
/
2015
TIME
: 1 3
:2
2
:39
ID
:
GL47
0001.WOW
ACCOUNT
NUMBER
DESCRIPTION
COMMUNITY DEVELOPMENT
EXPENSES
01-55-6604
01-55
-
6608
01-55-6613
01-55
-
7010
01-55-7510
01-55
-9
004
SAFETY
SUPPLIES
BOOKS &
PUBLICATIONS
GENERAL
OFFICE
SUPPLIES
TRANS.
TO
EQUIP
.
REPL
.
FUND
DEPRECIATION
EXP -
COM
DE
V
CONTINGENCY
TOTAL
EXPENSES
:
COMMUNITY
DEVELOPMENT
FINANCE
EXPENSES
01
-
56-6101
01-56-610
2
01-56-6104
01-56-6201
01-56-620
2
01-56-6204
01-56-6205
01-56-6206
01-56-6208
01
-
56-6209
01-56
-
6301
01-56-6302
01-56-6305
01-56-6306
01-5
6
-6307
01-56-6309
01
-
56-6402
01-56-6403
01-56-
6
501
01-56
-
6502
01-56
-
6503
01-56-6504
01-56-6507
01
-
56-6508
01-56-6509
01-56-6601
01-56-6603
01
-
56-6608
01-56-6613
01-56-6910
SALARIES
- REGULAR
SALARIES-OVERTIME
SALARIES-PART-TIME
MEDICAL/ DENTAL INSURANCE
GROUP
LIFE
INSURANCE
UNEMPLOYMENT
COMPENSATION
SOCIAL
SECURITY
CONTRIBUTIONS
IMRF CONTRIBUTIONS
TRAINING
& MEMBERSHIPS
UNIFORM
ALLOWANCE
LEGAL
SERVICES
AUDIT
SERVICES
FINANCIAL
SERVICES
MEDICAL
SERVICES
I . S .
SERVICES
OTHER
PROFESSIONAL
SERVICES
RENTAL
REPAIR
&
MAINT.
SER
V
-EQUIPMENT
POSTAGE &
DELIVERY
TELECOMMUNICATIONS
PUBLISHING
PRINTING
MILEAGE REIMBURSEMENT
RECEPTIONS
& ENTERTAINMENT
RECRUITMENT
FUEL
& LUBRICANTS
SPECIALIZED
SUPPLIES
BOOKS
AND
PUBLICATIONS
GENERAL
OFFICE
SUPPLIES
MISCELLANEOUS
TOTAL
EXPENSES:
FINANCE
VILLAGE
OF SUGAR
GROVE
DETAILED
REVENUE & EXPENSE REPORT
BUDGET VS . ACTUAL
WITH PERCENT VARIANCE
FOR 3
PERIODS
ENDING JULY
31
,
2015
FUND: GENERAL
FUND
JULY
BUDGET
8 .
34
33
.
34
83.34
272.34
0.00
0.00
49
,
217
.
10
7,033.84
0.00
631
.
09
1,408.92
8.50
7.00
586.34
661.17
170.34
8.34
0.00
1,012.50
0 .
00
14.59
597.59
79
.
50
1.
59
58.34
58
.
34
121.00
59.17
71.92
4.17
0 .
00
0.00
5.50
4.17
4 .
17
91.67
0.00
12,699
.
76
JULY
ACTUAL
0 .
00
0 .
00
54.26
272.33
0 .
00
0.00
84,246
.
19
6,460
.
80
0.00
427.28
1,425
.
39
8 .
00
0.00
500
.
90
607
.
32
0.00
0.00
0.00
0 .
00
0 .
00
0 .
00
0 .
00
1 7
4.42
1.
60
10
.
71
127
.
67
288.03
0.00
0.00
0.00
0 .
00
25.00
22
.
14
0.00
0 .
00
13.25
155.00
10,247.51
%
VARI-
ANCE
100.0
100.0
34.8
0.0
0 . 0
0 . 0
(
71.
1 )
8.1
0 . 0
32.2
(1.
1)
5.8
100
. 0
14.5
8.1
100
. 0
100
. 0
0 . 0
100
. 0
0.0
100
. 0
100.0
(119.
4)
( 0 .
6)
81.6
(118
.
8)
(138.
0)
100.0
100.0
100.0
0.0
100.0
(3
02.
5)
100
. 0
100.0
85.5
100
. 0
19.3
FISCAL
YEAR
BUDGET
100.00
400
.
00
1,
0
00
.
00
3,268
.
00
0 .
00
0.00
590,604
.
00
84,406.00
0 .
00
7 ,
573.00
16,907
.
00
102.00
84.00
7 ,
036
.
00
7,934.00
2,044
.
00
100
.
00
0 .
00
12,150.00
0.00
175
.
00
7 ,
171.00
954
.
00
19.00
700
.
00
7
00.00
1,452
.
00
710.00
863.00
50
.
00
0.00
0.00
66.00
50
.
00
50.00
1,100.00
0 .
00
152,396
.
00
FISCAL
PAGE : 7
F-YR:
16
%
YEAR-TO-DATE
V
ARI-
ACTUAL ANCE
0 .
00
0.00
77.08
816
.
99
0.
00
0.
0 0
199
,
242.91
22,546
.
16
0.00
1,901.07
4 ,
16
3.
85
24.00
0 .
00
1,
694
.
30
2 ,
119.36
1,061.11
0 .
00
0 .
00
0 .
00
0 .
00
0 .
00
5,577.04
348
.
24
1.
60
1
0.7
1
1
27.
6 7
591.12
0 .
00
234
.
66
0.00
0.00
25.00
22.14
0.00
0.00
284.50
155
.
00
40
,
887.53
100.0
100.0
92
.2
75
. 0
0 . 0
0 . 0
66.2
73.2
0.0
74.9
75
. 3
76.4
100.0
75
. 9
73.2
48
. 0
100
. 0
0.0
100
. 0
0.0
100.0
22
. 2
63.5
91.5
98.4
81.
7
59.2
100.0
72
. 8
100
. 0
0 . 0
100.0
66.4
100.0
100.0
74.1
100.0
73.1
15
43
DATE:
08
/
13
/
2015
TIME:
13:22:39
ID
:
GL470001
o
WOW
ACCOUNT
NUMBER
DESCRIPTION
BOARD
AND
COMMISSIONS
EXPENSES
01-57-6104
SALARIES-PART-TIME
01-57-6205
SOCIAL
SECURITY CONTRIBUTIONS
01-57-6206
IMRF CONTRIBUTIONS
01-57-6208
TRAINING
& MEMBERSHIPS
01-57-6209
UNIFORM
ALLOWANCE
01-57-6301
LEGAL SERV
ICES
0
1-57-6303
ENGINEERING
SERVICES
01-57-6306
MEDICAL
SERVICES
01-57-6307
IoS
o
SERVICES
01-57-6309
OTHER PROFESSIONAL
SERVICES
01-57-6403
REPAIR
& MAINT o SERV-EQUIPMENT
01-57-6500
GENERAL EQUIPMENT
01-57-6501
POSTAGE & DELIVERY
01-57-6502
TELECOMMUNICATIONS
01-57-6503
PUBLISHING
01-57-6504
PRINTING
01-57-6507
MILEAGE REIMBURSEMENT
01-57-6508
RECEPTIONS & ENTERTAINMENT
01-57-6515
PUBLIC
RELATIONS
01-57-6516
EMPLOYEE
ACTIVITIES
01-57-6517
PLAN COMMISSION
01-57-6518
POLICE
COMMISSION
01-57-6608
BOOKS
&
SUBSCRIPTIONS
01-57-6613
GENERAL
OFFICE
SUPPLIES
01-57-9003
INTERFUND TRANSFER
01-57-9004
CONTINGENCY
TOTAL EXPENSES :
BOARD
AND
COMMISSIONS
TOTAL
FUND
REVENUES
TOTAL
FUND
EXPENSES
FUND
SURPLUS
(DEFICIT}
VILLAGE OF
SUGAR
GROVE
DETAILED REVENUE & EXPENSE REPORT
BUDGET
VSo ACTUAL WITH PERCENT VARIANCE
FOR 3
PERIODS
ENDING JULY
31,
2015
FUND
: GENERAL
FUND
JULY
BUDGET
3,798o84
290o59
39o17
654
o
09
66067
Oo
OO
OoOO
OoOO
133o09
667o67
183o34
OoOO
8o34
60o00
12
o
50
16o67
OoOO
108o34
462
0
92
29
017
187050
233o34
OoOO
37o50
OoOO
OoOO
JULY
ACTUAL
9,627079
733o43
36o14
170000
OoOO
OoOO
OoOO
Oo
OO
OoOO
12050
OoOO
OoOO
5o
59
119091
32o50
OoOO
OoOO
Oo
OO
2 ,
500
o
00
OoOO
OoOO
OoOO
OoOO
13025
OoOO
OoOO
%
VARI-
ANCE
(
153
0 4}
(
152
0 3}
707
74o0
100o0
OoO
OoO
OoO
100o0
9801
10000
OoO
3209
(
99
0
8}
(160
0
0}
100
o0
OoO
10000
(440
0
0}
10000
100
00
10000
OoO
64o6
OoO
OoO
FISCAL
YEAR
BUDGET
45,586000
3,487o00
470000
7,849
o
00
800o00
OoOO
Oo
OO
OoOO
1,597000
8,012
0
00
2,200000
Oo
OO
100
o
00
720
o
00
150o00
200o00
OoOO
1,300000
5 ,
555
o
00
350
o
00
2,250o00
2,800
o
00
Oo
OO
450
o
00
OoOO
OoOO
FISCAL
PAGE: 8
F-YR
:
16
%
YEAR - TO-DATE
VARI-
ACTUAL
ANCE
10,589034
76
o7
799
0
22
77
o0
126
o
49
7300
3,870000
50o6
OoOO
100o0
Oo
OO
OoO
OoOO
OoO
OoOO
OoO
Oo
OO
10000
1 ,
716
0
94
78
05
5o24
9907
OoOO
OoO
5o
59
94
o4
119
o
91
83o3
32o50
7803
OoOO
10000
OoOO
OoO
Oo
OO
10000
2,500
0
00
55o0
OoOO
100
o0
Oo
OO
100
00
Oo
OO
100
o0
Oo
OO
OoO
13
o
25
97o0
Oo
OO
OoO
OoOO
OoO
----------
-
----------------
-
-------------------------
-
-----------------------------------
6,989
o
74
3
36,340
0
20
407,973
o
40
(71,
633
0
20}
13,251.11
393,717
o
95
408,623069
(14,905
o74}
(
89
0
5}
1700
(0
0
1}
(79
o1}
83,876000
4,794,999000
4,895,673
0
00
(100,674o00}
19,778
0
48
1 ,
725,451.99
1,180,623091
544,828
o
08
7604
(64
0
0}
7508
(641
o1}
16
44
DATE :
08
/
13
/ 2 0
15
TIME
:
13
:
22
:
39
ID:
GL470001
.
WOW
ACCOUNT
NUMBER
REVENUES
REVENUES
30-00-3440
30-00-3510
30-00-3
7
61
30-00-3810
30-00-3811
30-00-3817
30-00-3818
30-00
-
3819
30-00-3820
30-00-3850
30-00-3851
30-00-3852
30-00
-
3853
30
-
00-3856
3 0
-00-
3
878
30-00-3879
30-00-3880
30-00-3881
30-00-3885
30-
0
0-3886
30-00-
38
88
30-00-3890
30-00-3920
30-00-3930
30-00-3990
DESCRIPTION
GRANTS
COURT
FINES
REIMBURSEMENTS
INTEREST
INCOME
INTEREST
INCOME -
CD
INTEREST
INCOME - MUNI BONDS
INTEREST
INCOME - US AGENCY
INTEREST
INCOME -
BND
PROCEEDS
RENTAL INCOME
IMPROVEMENT DONATIONS
EMERGENCY WARNING
DEVICE
FEE
LIFE
SAFETY
POLICE
LIFE
SAFETY -
STREETS
COMMERCIAL
FEE
GAIN
(
LOSS)
- AGENCY
REALIZED
GAIN
(
LOSS)
- AGENCY UNREAL
GAIN
(
LOSS)
-
MUNI
BOND
REAL
GAIN
(
LOSS
) -
MUNI
BONDS UNREA
GAIN
(LOSS)
-
REALIZED
(BOND)
GAIN
(LOSS)
- UNREAL (
BOND
)
GAIN
(
LOSS)
- IMET
MISC
. INCOME
PROCEEDS
-
FIXED
ASSET
SALE
BOND
PROCEEDS
INTERFUND
TRANSFER
TOTAL
RE
V
ENUES:
REVENUES
ADMINSTRATION
EXPENSES
30-50-6301
30-50-6303
30-50-6304
30-50-6305
30-50-6309
30-50-7001
30-50-7002
30-50-7003
LEGAL
SER
V
ICES
ENGINEERING
SERVICES
ARCHITECTURAL
SERVICES
FINANCIAL
SERVICES
OTHER
PROFESSIONAL
SERVICES
LAND PURCHASE
VILLAGE
BUILDINGS
BUILDING
IMPROVEMENTS
TOTAL
EXPENSES:
ADMINSTRATION
VILLAGE
OF SUGAR GROVE
DETAILED
REVENUE & EXPENSE
REPORT
BUDGET
VS.
ACTUAL WITH PERCENT VARIANCE
FOR 3
PERIODS
ENDING
JULY
31,
2015
FUND : GENERAL
CAPITAL
PROJECTS
FUND
JULY
BUDGET
0.00
62.50
0.00
675
.
17
0.00
0 .
00
0.00
0.00
6,008.25
10,038.00
25.00
288.17
288.17
0.00
0.00
0 .
00
0.00
0.00
0 .
00
0 .
00
0 .
00
0.00
0.00
0.00
18,651.59
36,036.85
0.00
0.00
0 .
00
0 .
00
5,766
.
67
0.00
41,666.67
0.00
47,433.34
JULY
ACTUAL
0.00
317.30
0.00
100
.
28
1,270.88
269
.
65
0.00
0.00
3,072.72
2,891.57
0.00
0.00
0.00
0.00
0.00
0 .
00
0.00
0 .
00
0 .
00
0 .
00
0 .
00
0.00
0.00
0 .
00
18,651.58
26,573.98
0 .
00
0 .
00
0 .
00
0.00
0.00
0.00
580.40
0.00
580
.
40
%
VARI-
ANCE
0 . 0
407.6
0 . 0
(
85.
1)
100.0
100.0
0.0
0.0
(48.
8)
(71.1)
100
. 0
100.0
100.0
0 . 0
0.0
0.0
0 . 0
0 . 0
0 . 0
0.0
0.0
0 . 0
0 . 0
0 . 0
0 . 0
(26
.
2)
0.0
0.0
0.0
0.0
100.0
0.0
98
. 6
0.0
98
. 7
FISCAL
YEAR
BUDGET
0.00
750.00
0.00
8,102.00
0.00
0.00
0.00
0 .
00
72,099
.
00
120,456.00
300.00
3,458
.
00
3,458.00
0.00
0.00
0.00
0.00
0 .
00
0 .
00
0 .
00
0.
00
0.00
0 .
00
0 .
00
223,819
.
00
432,442.00
0.00
0.00
0 .
00
0 .
00
69
,
200
.
00
0 .
00
500,000.00
0.00
569,200.00
FISCAL
PAGE : 9
F-YR:
16
%
YEAR-
TO-DATE
V
ARI-
ACTUAL ANCE
0.00
788.30
0.00
337.47
3 ,
783.07
1,
3
34.00
0 .
00
0 .
00
9,218
.
16
16,343.14
0 .
00
2
00
.
00
3
60.00
0 .
00
0 .
00
0 .
00
0.00
0 .
00
0 .
00
0.00
0.00
0.00
0.00
0.00
55,954
.
74
88
,
318.88
0.00
0 .
00
0.00
0.00
0 .
00
0.00
1,596
.
10
0.00
1,596
.
10
0.0
5 . 1
0 . 0
(
95.8)
100
. 0
100.0
0 . 0
0.0
(87
.
2)
(86
.
4)
100.0
(94.
2 )
(
89
.
5)
0.0
0 . 0
0 . 0
0.0
0.0
0.0
0 . 0
0 . 0
0 . 0
0 . 0
0 . 0
(75
.
0)
(
79.5)
0 . 0
0.0
0.0
0 . 0
100
. 0
0 . 0
99.6
0.0
99
. 7
17
45
DATE:
08/13/2015
TIME:
13:22:39
ID:
GL470001.WOW
ACCOUNT
NUMBER
DESCRIPTION
VILLAGE OF SUGAR
GROVE
DETAILED REVENUE & EXPENSE REPORT
BUDGET
VS.
ACTUAL WITH PERCENT VARIANCE
FOR 3
PERIODS
ENDING JULY
31,
2015
FUND: GENERAL
CAPITAL
PROJECTS
FUND
JULY
BUDGET
JULY
ACTUAL
%
VARI-
ANCE
FISCAL
YEAR
BUDGET
FISCAL
PAGE:
10
F-YR:
16
%
YEAR-TO-DATE
VARI-
ACTUAL
ANCE
----------------------------------------------------
,
---------------------------------------------------------------------------------------
POLICE
EXPENSES
30-51-6301
30-51-6303
30-51-6304
30-51-6307
30-51-6309
30-51-7001
30-51-7003
30-51-7006
30-51-7007
30-51-9003
LEGAL
SERVICES
ENGINEERING
SERVICES
ARCHITECTURAL
SERVICES
I.S.
SERVICES
OTHER
PROFESSIONAL
SERVICES
LAND
ACQUISITION
BUILDING
IMPROVEMENTS
AUTOMOTIVE
EQUIPMENT
OTHER EQUIPMENT
& MACHINERY
INTERFUND TRANSFER
TOTAL
EXPENSES:
POLICE
PUBLIC
WORKS
STREETS
EXPENSES
30-53-6301
3
0-53-63
03
30-53-6309
30-53-6403
30-53-6501
30-53-6503
30-53-7001
30-53-7003
30-53-7006
30-53-7007
30-53-7008
30-53-9003
LEGAL
SERVICES
ENGINEERING
SERVICES
OTHER
PROFESSIONAL
SERVICES
REPAIR
& MAINT . SERV-EQUIPMNT
POSTAGE
ADVERTISING
LAND
ACQUISITION
BUILDING
IMPROVEMENTS
AUTOMOTIVE EQUIPMENT
OTHER EQUIPMENT
& MACHINERY
CAPITAL
IMPROVEMENTS
INTERFUND TRANSFER
TOTAL
EXPENSES:
PUBLIC
WORKS
STREETS
BUILDING
MAINTENANCE
EXPENSES
30-54-7006
AUTOMOTIVE EQUIPMENT
TOTAL
EXPENSES:
BUILDING
MAINTENANCE
COMMUNITY DEVELOPMENT
EXPENSES
30-55-7006
30-55-7007
AUTOMOTIVE EQUIPMENT
OTHER EQUIPMENT
& MACHINERY
0.00
0.00
0.00
0 .
00
0.00
0.00
0 .
00
8,283.34
333.34
9,135.17
17,751.85
5,833
.3
4
0.00
0 .
00
0
.0
0
0.00
0.00
0.00
0 .
00
0 .
00
0.00
0.00
0.00
5,833.34
0.00
0.00
0.00
0 .
00
0.00
0.0
0.00
0.0
0.00
0.0
0.00
0 . 0
0.00
0.0
0
.00
0.0
0.00
0.0
34,210.00
(313.
0)
8,733
.
83
(2520.1)
9,135.17
0 . 0
52,079.00
(193.3)
0.00
0.00
0.00
0 .
00
0.00
0.00
0.00
0.00
0.00
0 .
00
0.00
0.00
0.00
0.00
0.00
0 .
00
0.00
100.0
0.0
0.0
0 . 0
0.0
0.0
0.0
0.0
0.0
0 . 0
0.0
0 . 0
100
. 0
0.0
0.0
0.0
0 . 0
0.00
0.00
0.00
0.00
0.00
0 .
00
0.00
99,400.00
4,000.00
109,622.00
213,022.00
70,000.00
0 .
00
0.00
0.00
0.00
0.00
0.00
0.00
0 .
00
0.00
0.00
0.00
70,000.00
0.00
0.00
0 .
00
0.00
0.00
0.00
0.00
0.00
0 .
00
0.00
0.00
34,210
.
00
8,733.83
27,405
.
51
70
,
349.34
0 .
00
0 .
00
0.00
0 .
00
0.00
0.00
0.00
0.00
0 .
00
0.00
0.00
0 .
00
0 .
00
0.00
0.00
0 .
00
0.00
0.0
0.0
0.0
0.0
0
.0
0.0
0.0
65.5
(
118
.
3)
75.0
66.9
100.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
100.0
0.0
0 . 0
0.0
0.0
18
46
DATE:
08
/
13
/
2015
TIME :
13:22:39
ID
:
GL470001.WOW
ACCOUNT
NUMBER
DESCRIPTION
TOTAL EXPENSES:
COMMUNITY
DEVELOPMENT
FINANCE
EXPENSES
30-56-9003
INTERFUND TRANSFER
TOTAL EXPENSES : FINANCE
TOTAL
FUND
REVENUES
TOTAL
FUND
EXPENSES
FUND
SURPLUS
(DEFICIT)
VILLAGE
OF
SUGAR
GROVE
DETAILED REVENUE & EXPENSE REPORT
BUDGET
VS.
ACTUAL WITH PERCENT VARIANCE
FOR
3
PERIODS
ENDING JULY
31,
2015
FUND: GENERAL CAPITAL PROJECTS
FUND
JULY
BUDGET
0 .
00
0.00
0.00
36,036.85
71,018.53
(34,981.68)
JULY
ACTUAL
0.00
0.00
0.00
26,573.98
52,659.40
(26,085.42)
%
VARI-
ANCE
0 . 0
0.0
0.0
(26.
2)
25.8
(25.
4)
FISCAL
YEAR
BUDGET
0.00
0.00
0.00
432,442.00
852,222.00
(419,780.00)
FISCAL
PAGE:
11
F-YR:
16
%
YEAR-TO-DATE
VARI-
ACTUAL
0 .
00
0.00
0 .
00
88,318.88
71,945.44
16,373.44
ANCE
0.0
0.0
0.0
( 7
9.
5)
91.5
(
103
.
9)
19
47
DATE:
08
/
13/2015
TIME:
13
:2
2:39
ID:
GL470001
.
WOW
ACCOUNT
NUMBER
REVENUES
REVENUES
32-00-3110
32-00-3440
32-00-3810
DESCRIPTION
PROPERTY
TAX
- INCREMENT
GRANTS
INTEREST
INCOME
TOTAL
REVENUES: REVENUES
PUBLIC
WORKS
STREETS
EXPENSES
32-53-6301
32-53-6303
32-53-7008
LEGAL SERVICES
ENGINEERING
SERVICES
STREETS/
ROW
IMPROVEMENTS
TOTAL
EXPENSES:
PUBLIC
WORKS
STREETS
COMMUNITY
DEVELOPMENT
EXPENSES
32-55-6301
32-
55-6302
32-55-6303
32-55-6309
32-55-6403
32-55-6501
32-55-6503
LEGAL SERVICES
AUDIT SERVICES
ENGINEERING
SERVICES
OTHER PROFESSIONAL SERVICES
REPAIR
& MAINT. SERV-EQUIPMENT
POSTAGE & DELIVERY
PUBLISHING
TOTAL
EXPENSES:
COMMUNITY
DEVELOPMENT
TOTAL
FUND
REVENUES
TOTAL
FUND
EXPENSES
FUND
SURPLUS
(DEFICIT)
·-------
VILLAGE
OF
SUGAR
GROVE
DETAILED
REVENUE
& EXPENSE REPORT
BUDGET
VS.
ACTUAL WITH PERCENT VARIANCE
FOR 3 PERIODS ENDING JULY
31,
2015
FUND: INDUSTRIAL
TIF
#1
FUND
JULY
BUDGET
2,964
.
00
0.00
0.00
2,964
.
00
0.00
0.00
0 .
00
0.00
0.00
22.92
0.00
0.00
0.00
0.00
0.00
22.92
2,964.00
22.92
2,941.08
JULY
ACTUAL
0.00
0.00
0 .
00
0.00
0 .
00
_
3,338.84
0.00
3,338.84
0 .
00
0 .
00
31
.
25
0.00
0.00
0 .
00
0.00
31.25
%
VARI-
ANCE
100.0
0.0
0 . 0
100.0
0.0
100
. 0
0.0
100.0
0.0
100.0
100
. 0
0.0
0.0
0.0
0 . 0
(36.
3)
0.00
100.0
3,370
.
09
(4603.7)
(3'
370
.
09)
(2
14.
5)
FISCAL
YEAR
BUDGET
68,835.00
0.00
0.00
68,835.00
0.00
0.00
0.00
0.00
0.00
275.00
0.00
0.00
0.00
0.00
0.00
275.00
68,835.00
275.00
68,560.00
FISCAL
PAGE:
12
F-YR:
16
%
YEAR-TO-DATE
VARI-
ACTUAL
27,901.16
0.00
0.00
27,901.16
0.00
3,338.84
0.00
3,338.84
0.00
0.00
31.25
0.00
0.00
0.00
0.00
31.25
ANCE
(59.
4)
0.0
0.0
(59.
4)
0.0
100.0
0.0
100
.0
0.0
100.0
100
. 0
0.0
0.0
0.0
0.0
88.6
27,901.16
(59.4)
3,370
.
09
(1125.4)
24,531.07
(64.2)
20
48
DATE:
08
/
13
/
2015
TIME:
13:22:39
ID:
GL470001
.
WOW
ACCOUNT
NUMBER
DESCRIPTION
COMMUNITY
DEVELOPMENT
EXPENSES
33-55-6301
33-55-6302
33-55-6303
33-55-6309
33-55-6403
33-55-6501
33-55-6503
33-55-7003
LEGAL
SERVICES
AUDIT SERVICES
ENGINEERING SERVICES
OTHER
PROFESSIONAL
SERVICES
REPAIR
& MAINT . SERV-EQUIPMENT
POSTAGE & DELIVERY
PUBLISHING
BUILDING IMPROVEMENTS
TOTAL EXPENSES:
COMMUNITY
DEVELOPMENT
TOTAL
FUND
REVENUES
TOTAL
FUND
EXPENSES
FUND
SURPLUS
(DEFICIT
)
VILLAGE
OF
SUGAR
GROVE
DETAILED REVENUE & EXPENSE REPORT
BUDGET
VS.
ACTUAL
WITH PERCENT VARIANCE
FOR 3 PERIODS ENDING JULY
31,
2015
FUND: INDUSTRIAL
TIF
#2
FUND
JULY
BUDGET
166.67
22.92
166.67
333.34
0.00
0 .
00
0.00
3,333.34
4,022.94
0.00
4,022
.
94
(4,022.94)
JULY
ACTUAL
0.00
0 .
00
190.00
1 ,
046.00
0.00
0 .
00
0.00
0.00
1,236.00
0 .
00
1,236.00
(1,236.00)
%
VARI-
ANCE
100.0
100.0
(14.
0)
(213
.
7)
0 . 0
0.0
0.0
100.0
6
9.
2
0.0
6
9.
2
(69.
2)
FISCAL
YEAR
BUDGET
2 ,
000.00
275
.
00
2,000.00
4,000.00
0 .
00
0.00
0.00
40
,
000.00
48,275.00
0.00
48,275.00
(48,275
.
00)
FISCAL
PAGE:
13
F-YR:
16
%
YEAR-TO-DATE
VARI-
ACTUAL
270.00
0 .
00
190.00
1 ,
046.00
0
.00
0 .
00
0.00
0.00
1 ,
506
.
00
0 .
00
1,506.00
(1,506.00)
ANCE
86
. 5
100.0
90
. 5
73 . 8
0.0
0 . 0
0.0
100.0
96.8
0.0
96
. 8
(
96.8)
21
49
DATE:
08
/
13
/20
15
TIME
:
13:22:39
ID:
GL470001.WOW
ACCOUNT
NUMBER
REVENUES
REVENUES
35-00-3430
35-00-3440
35-00-3450
35-00-3453
35-00-3761
3
5-00-3810
35-00
-
3819
35-00-3830
35-00-3854
35-00-3855
35-00-3860
35-00
-
3888
35-00-3930
35-00-3990
DESCRIPTION
MOTOR
FUEL TAX
GRANTS
LOCAL
SALES
TAX
STATE
GAMES
LICENSES
REIMBURSEMENT
INTEREST
INCOME
INTEREST
INCOME -
BND
PROCEEDS
DONATIONS
TRAFFIC
PRE-EMPTION
DONATIONS
ROAD
IMPACT
FEE
PUBLIC
IMPROVEMENT
FEE
GAIN
(LOSS)
-
IMET
BOND
PROCEEDS
INTERFUND TRANSFER
TOTAL REVENUES: REVENUES
MOTOR
FUEL
TAX
EXPENSES
35-50-6303
35-50-6305
35-50-6503
35-50-7008
35-50-9003
ENGINEERING
SERVICES
FINANCIAL
SERVICES
ADVERTISING
STREETS/ROW
IMPROVEMENTS
INTERFUND TRANSFER
TOTAL
EXPENSES:
MOTOR
FUEL
TAX
STREETS
DIVISION
EXPENSES
35-53-6301
35-53-6303
35-53-6305
35-53-6309
35-53
-
6501
35-53-6503
35-53-7001
35-53-7008
35-53-9003
LEGAL
SERVICES
ENGINEERING
SERVICES
FINANCIAL
SERVICES
OTHER
PROFESSIONAL
SERVICES
POSTAGE & DEVLIVERY
ADVERTISING
LAND
ACQUISITION
STREETS/ROW
IMPROVEMENTS
INTERFUND TRANSFER
TOTAL
EXPENSES:
STREETS
DIVISION
VILLAGE
OF
SUGAR GROVE
DETAILED
REVENUE &
EXPENSE
REPORT
BUDGET
VS.
ACTUAL WITH PERCENT VARIANCE
FOR 3
PERIODS
ENDING
JULY
31,
2015
FUND: INFRASTRUCTURE CAP
PROJ
FUND
JULY
BUDGET
19,544
.0
9
436,272.84
44,414.59
0
.00
0
.00
125.00
0.00
0 .
00
0.00
16,226.67
6,458.34
0.00
0.00
12,183.34
JULY
ACTUAL
12,752.22
3,000,000.00
42,590.49
0.00
0 .
00
138.42
0.00
0.00
0.00
7,328.50
31,000.00
0.00
0 .
00
12,183.34
%
VARI-
ANCE
(34
.
7)
587.6
(4
.1)
0 . 0
0 . 0
10.7
0.0
0 . 0
0.0
(54
.
8)
380.0
0.0
0.0
0.0
FISCAL
YEAR
BUDGET
234,529.00
5,235,274
.00
532,975.00
0.00
0 .
00
1,500
.
00
0.00
0.00
0 .
00
194,720
.
00
77,500
.
00
0.00
0.00
146,200
.
00
FISCAL
PAGE :
14
F-YR
:
16
%
YEAR-TO-DATE
VARI-
ACTUAL ANCE
53,324.71
(
77.2)
3,000,000.00
(42.
7)
111,891.99
(
79.
0)
0.00
0.0
0.00
0.0
141.86
(90.5)
0.00
0.0
0.00
0.0
0 .
00
0.0
35,117.00
(
81.
9)
31,000
.
00
(60.
0)
0
.00
0.0
0 .
00
0.0
36,550
.
02
(75.
0)
---
-------------
----
-----------------
-------
------------------
-------------
--------------
535,224.87
3,105,992
.
97
480.3
6,422,698
.
00
3,268,025.58
(4
9.
1)
2,345
.2
5
1,318.98
43.7
28,143
.00
1,770
.28
93.7
0.00
0 .
00
0.0
0 .
00
0.00
0 . 0
0.00
0.00
0 . 0
0.00
0.00
0.0
17,198.84
0.00
100
. 0
206,386.00
0.00
100.0
0.00
0.00
0.0
0.00
0 .
00
0.0
19,544
.
09
1,318.98
93
. 2
234,529.00
1,770
.
28
99.2
0.00
0.00
0.0
0.00
0.00
0
.0
108,448.75
115,272
.
08
(
6.
2)
1,301,385
.
00
119,237
.
36
90.8
0.00
0.00
0.0
0.00
0.00
0.0
0.00
0.00
0 . 0
0.00
240.96
100.0
0
.00
0.33
100
. 0
0.00
0.33
100.0
0.00
0.00
0.0
0
.0
0
0.00
0.0
0 .
00
0.00
0.0
0.00
0.00
0 . 0
316,703.00
706,157
.47
(
122
.
9)
3,800,436
.00
977,921.31
74.2
40,475
.
59
40,475.58
0.0
485,707.00
121,426
.
74
75.0
465,627.34
861
,
905.46
(85
.
1)
5,587,528.00
1,218,826.70
78.1
22
50
DATE
: . 0
8/
13
/
2015
TIME : 13 :
22
: 3 9
ID
:
GL4
7
0001
.
WO
W
ACCOUNT
NUMBER
BUILDING & ZONING
EXPENSES
3
5-55-
6
301
35-55-6303
35-55-6305
35
-
55
-
6309
35
-
55
-6
503
DESCRIPTI
ON
LEGAL SERV
ICES
ENGINEERING
SERVICES
FINANCIAL
SERVICES
OTHER PROFESSIONAL SERV
ICES
ADVERTISING
TOTAL EXPENSES : BUILDING & ZONING
TOTAL
FUND
REVENUES
TOTAL
FUND
EXPENSES
FUND
SURPLUS (
DEFICIT
)
VILLAGE
OF
SUGAR
GROVE
DETAILED REVENUE & EXPENSE REPORT
BUDGET
V
S.
ACTUAL
WITH PERCENT VARIANCE
FOR 3 PERIODS ENDING JULY
31
,
2015
FUND: INFRASTRUCTURE
CAP
PROJ
FUND
JULY
BUDGET
0 .
00
0.00
0.00
0 .
00
0.
00
0.00
535,224
.
87
485,171.43
50,053.44
JULY
ACTUAL
0.00
40,933.57
0 .
00
0.00
0 .
00
40,933
.
57
3,105,992
.
97
904
,
158
.
01
2 ,
201,834
.
96
%
VARI-
ANCE
0.0
100
. 0
0 . 0
0.0
0.0
100.0
480.3
(86.3)
4298
. 9
FISCAL
YEAR
BUDGET
0.00
0.00
0 .
00
0 .
00
0 .
00
0.0
0
6,422,698
.
00
5,822
,
057
.
00
600,641
.
00
FISCAL
PAGE
:
15
F-YR
:
16
%
YEAR-TO-DATE
VARI-
ACTUAL
ANCE
0 .
00
40
,
933.57
0.00
0.00
0.00
40,933
.
57
3 ,
268,025
.
58
1,261
,
530
.
55
2,006
,
495.03
0 . 0
100.0
0 . 0
0.0
0 . 0
100
. 0
(49
.1)
78
. 3
234
. 0
23
51
DATE :
08
/
13
/2
015
TIME
:
13
:2
2:
39
ID:
GL4
70
0 0
1.W
OW
ACCO
UNT
NUMBER
REVENUES
REVENUES
41-00-3110
41
-
00
-
3810
41-00-3819
41-00-3888
41
-
00
-
3930
41-00-3940
4 1
-00
-
3990
TOTAL REVENUES :
ADMINISTRATION
EXPENSES
41-50-6305
41-50-8002
41
-
50
-
8003
41-50-8004
41-50-8007
TOTAL EXPENSES :
DESCRIPTION
PROPERTY
TAX
VILLAGE HALL
BOND
INTEREST
INCOME
INTEREST
- ACCRUED
INT
ON
BDS
GAIN
(LOSS)-
IMET UNREAL
BOND
PROCEEDS
BOND
PREMIUM
INTERFUND OPERATING TRANSFER
RE
VENUES
FINANCIAL
SERVICES
DEBT
-PRINCIPAL
DEBT -
INTEREST
FISCAL
AGENT FEES
PAYMENT
TO
ESCROW
AGENT
ADMINISTRATION
TOTAL
FUND
REVENUES
TOTAL
FUND
EXPENSES
FUND
SURPLUS (
DEFICIT
)
VILLAGE
OF
SUGAR
GROVE
DETAILED
RE
VENUE & EXPENSE REPORT
BUDGET
VS . ACTUAL WITH PERCENT VARIANCE
FOR 3
PERIODS
ENDING JULY
31
, 2
015
FUND
: DEBT
SERVICE
FUND
JULY
BUDGET
0.00
88
.
59
0 .
00
0 .
00
0 .
00
0 .
00
75,826
. 6 7
75,915
.
26
0 .
00
58,750.00
17,104
. 4 2
89.59
0 .
00
75,944
.
01
75,915
.
26
75,944
.
01
(28
.
75)
JUL
Y
ACTUAL
0.00
36.91
0.00
0.00
0.00
0.00
7
5,826.58
75,863
.
49
200.00
0 .
00
29,795
.
00
0.00
0.00
29
,
995.00
%
V
ARI
-
ANCE
0 . 0
(
58
.
3)
0 . 0
0 . 0
0.0
0.0
0 . 0
0 . 0
100
. 0
100.0
(74.1)
100.0
0 . 0
60
. 5
75,863
.
49
0.0
29
,
995
.
00
60
. 5
45,868
.
49
(9642
.
5)
FISCAL
YEAR
BUDGET
0.00
1 ,
063.00
0 .
00
0.00
0 .
00
0.00
909,920
.
00
910
,
983.00
0.00
705,000
.
00
205,253.00
1 ,
075
.
00
0 .
00
911,328.00
910,983.00
911
,
328
.
00
(
345
.
00)
FISCAL
PAGE:
16
F-YR
:
16
%
YEAR -
TO-DATE
V
ARI-
ACTUAL
ANCE
0.00
0.0
105.51
(
90
. 0 )
0.00
0 . 0
0 .
00
0.0
0.00
0 . 0
0 . 0 0
0.0
227
,
479.74
(
75.0)
22 7
,585.25
(
75.
0)
2
00
.
00
100.0
0 .
00
100.0
10
2,
626.25
50
. 0
0.00
100.0
0 .
00
0 . 0
102
,
826
.
25
8 8 . 7
22
7
,585.25
(75
.
0)
102,826
.
25
88
. 7
124,759
.
00
(6262.0)
24
52
DATE :
08
/
13
/
2015
TIME:
13:22
:
39
ID
:
GL470001.WOW
ACCOUNT
NUMBER
OPERATING REVENUES
REVENUES
50-00-3310
50-00-3530
50-00-3540
50-00-3590
50-00
-
3610
50-00-3620
50-00-3630
50-00-3670
50-00-3761
50-00-3791
50-00-3792
50-00-3810
50-00-3811
50-00-3817
50-00-3818
50-00-3819
50-00-3820
50-00-3830
50-00-3878
50-00-3879
50-00-3880
50-00-3881
50-00-3888
50-00-3890
50-00-3930
DESCRIPTION
BLDNG
PERMITS-METER
REINSPCTNS
WATER
PENALTIES
SEWER
PENALTIES
OTHER
FINES
WATER
SALES
SEWER SALES
ADMINISTRATIVE
FEE
METER
SALES
REIMBURSEMENT
WATER
- OTHER CHARGES
SEWER
- OTHER CHARGES
INTEREST
INCOME
INTEREST
INCOME -
CD
INTEREST
INCOME -
MUNI
BONDS
INTEREST
INCOME -
US
AGENCY
INTEREST
INCOME -
BND
PROCEEDS
RENTAL INCOME
DONATIONS
GAIN
(
LOSS)
- AGENCY
REALIZED
GAIN
(LOSS)
-
AGENCY
UNREAL
GAIN
(LOSS
) - MUNI
BONDS
REAL
GAIN
(LOSS)
- MUNI
BOND
UNREAL
GAIN
(LOSS)
- IMET
MISCELLANEOUS INCOME
LOAN /
BOND
PROCEEDS
TOTAL REVENUES : OPERATING REVENUES
CAPITAL
REVENUES
REVENUES
50-01-3651
50-01-3652
50-01-3761
50-01-3791
50-01-3930
50-01-3990
WATER
TAP-ON
FEES
SEWER
TAP-ON
FEES
REIMBURSEMENT
FIRE
SUPPRESSION
TAP-ON
FEES
LOAN /
BOND
PROCEEDS
INTERFUND TRANSFER
TOTAL REVENUES :
CAPITAL
REVENUES
INFORMATION TECHNOLOGY
EXPENSES
VILLAGE
OF
SUGAR
GROVE
DETAILED
REVENUE & EXPENSE REPORT
BUDGET VS . ACTUAL WITH PERCENT VARIANCE
FOR 3
PERIODS
ENDING
JULY
31,
2015
FUND:
WATERWORKS
& SEWERAGE
FUND
JULY
BUDGET
60
.
67
2,458.92
2 ,
203
.
25
0 .
00
140,508
.
50
125,899
.
00
0.00
2,410
. 4 2
32
.
50
0.00
967
.
75
1 ,
565.67
0 .
00
0 .
00
0.00
0 .
00
508.1
7
0.00
0.00
0 .
00
0.00
0.00
0 .
00
1,041
.
00
0.00
277,655.85
14,859
.
17
1,806
.
92
0.00
725.17
0.00
15,853.42
33,244
. 6 8
JULY
ACTUAL
85.00
2,827
.
78
2,568.73
0 .
00
601.93
268
.
78
0.00
1,915.00
30.00
0.00
0 .
00
192.48
1 ,
779
.
23
377.52
0.00
4.34
499.59
0 .
00
0 .
00
0.00
0 .
00
0 .
00
0 .
00
920
.
53
0.00
12
,
070.91
4,214.96
215.16
0.00
0 .
00
0.00
15,853.42
20,283
.
54
%
VARI-
ANCE
40
. 1
15
. 0
16.5
0 . 0
(99
.
5)
(
99
.
7)
0 . 0
(20
.
5)
(7
.
6)
0 . 0
100
. 0
(
87
.
7)
100.0
100.0
0.0
100
. 0
(
1.
6)
0.0
0.0
0.0
0 . 0
0 . 0
0.0
(
11.
5)
0.0
(
95
.
6)
(71.
6)
(88
.
0)
0.0
100.0
0 . 0
0 . 0
(3
8 .
9)
FISCAL
YEAR
BUDGET
72
8.
00
29,507
.
00
26,439
.
00
0.00
1,686
,
102
.
00
1,510,788.00
0 . 0 0
28,925.00
390
.
00
0 .
00
11
,
613
.
00
18,
7
88
.
00
0.00
0 .
00
0 .
00
0 .
00
6,098.00
0 .
00
0 .
00
0.00
0.00
0 .
00
0 .
00
12,492
.
00
0 .
00
3,331,870
.
00
178,310.00
21
,
683
.
00
0.00
8,702.00
0 .
00
190,241.00
398,936.00
FISCAL
PAGE:
19
F-YR
:
16
%
YEAR-TO-DATE
VARI-
ACTUAL
85.00
8,129.68
7 ,
478
.
78
0.00
274,227.21
245,442
.
11
0 .
00
4,942
.
00
105
.
00
0 .
00
1,927
.
00
653.60
5 ,
296
.
28
1,867
.
62
0 .
00
13
.
30
499.59
0 .
00
0 .
00
0.00
0 .
00
0.00
0.00
3 ,
295.53
0.00
553,962
.
70
25,869.92
2 ,
914.32
0.00
0.00
0.00
47
,
560.26
76
,
344.50
ANCE
(
88
.
3)
(
72.4)
(71.
7)
0.0
(83.7
)
(
83
.
7)
0.0
(82
.
9)
(73.0)
0 . 0
(
83.4)
(
96
. 5 )
100.0
100.0
0 . 0
100
. 0
(
91.
8)
0.0
0.0
0 . 0
0 . 0
0.0
0.0
(
73
. 6 )
0 . 0
(
83.3)
(85.
4)
(86.5)
0.0
100.0
0.0
(
75.0)
(
80.8)
25
53
DATE:
08
/
13
/
2015
TIME:
13:22:39
ID:
GL470001.WOW
ACCOUNT
NUMBER
DESCRIPTION
INFORMATION
TECHNOLOGY
EXPENSES
50-49-6307
50-49-6502
50-49
-
6613
I.S
.
SERVICES
TELECOMMUNICATIONS
GENERAL
OFFICE
SUPPLIES
TOTAL
EXPENSES
: INFORMATION TECHNOLOGY
ADMINISTRATION
EXPENSES
50-50-6101
50-50-6102
50-50-6104
50-50-6201
50-50-6202
50-50-6204
50-50-6205
50-50-6206
50
-
50-6208
50-50-6301
50-50-6302
50-50-6305
50-50-6306
50-50-6307
50-50-6309
50-50-6402
50-50-6403
50-50-6501
50-50-6502
50-50
-
6503
50-50-6504
50-50-6507
50-50-6509
50-50-6514
50-50-6518
50
-
50-6601
50-50-6603
50-50-6608
50-50-6613
50-50-7010
50-50-7011
50-50-7510
50-50-8002
50-50-8003
SALARIES
- REGULAR
SALARIES
- OVERTIME
SALARIES-PART-TIME
MEDICAL/ DENTAL INSURANCE
GROUP
LIFE
INSURANCE
UNEMPLOYMENT COMPENSATION
SOCIAL
SECURITY
CONTRIBUTIONS
IMRF
CONTRIBUTIONS
TRAINING
& MEMBERSHIPS
LEGAL
SERVICES
AUDIT
SERVICES
FINANCIAL
SERVICES
MEDICAL
SERVICES
I.S.
SERVICES
OTHER
PROFESSIONAL
SERVICES
RENTAL
REPAIR
& MAINT .
SERV-EQUIPMENT
POSTAGE &
DELIVERY
TELECOMMUNICATIONS
PUBLISHING
PRINTING
MILEAGE REIMBURSEMENT
RECRUITMENT
INSURANCE PREMIUMS
BAD DEBT EXPENSE -
PROC.
FEE
FUEL
& LUBRICANTS
SPECIALIZED
SUPPLIES
BOOKS &
PUBLICATIONS
GENERAL
OFFICE
SUPPLIES
TRANSFER
TO
EQUIP.
REPLACEMENT
TRANSFER
TO
INFRA
. REPLACEMENT
DEPRECIATION
EXPENSE
DEBT -
PRINCIPAL
DEBT -
INTEREST
VILLAGE
OF SUGAR GROVE
DETAILED
REVENUE &
EXPENSE
REPORT
BUDGET
VS.
ACTUAL WITH
PERCENT
VARIANCE
FOR 3
PERIODS
ENDING
JULY
31
,
2015
FUND:
WATERWORKS
& SEWERAGE FUND
JULY
BUDGET
2,426.09
45.00
3 .
34
2,474
.
43
9,739
.
42
0.00
1,846.75
1,864
.
00
11.50
9 .
75
864.09
915
.
50
170
.
34
166.67
1,012.50
0.00
10.00
859.25
1,666.50
46.50
105.00
1,605.42
180
.
00
2
9.
59
71.92
27.09
0.00
7,589.17
0.00
5.67
0.00
4.17
108
.
34
9,603
.
42
6,250.00
0.00
55'
361.
84
11,853.75
JULY
ACTUAL
1,009.50
49.99
0 .
00
1,059
.
49
8,941.05
0.00
1,856.89
2,146.56
10.80
0.00
783.71
840.44
0.00
0 .
00
0.00
0.00
0.00
0.00
1,542.01
46.43
85.65
1,606
.
40
286.36
0.00
47.28
31.
03
25.00
0.00
0.00
22.14
0.00
0 .
00
13
.
25
9,603.42
6,250.00
0 .
00
0.00
0.00
%
VARI-
ANCE
58.3
(11.
0)
100.0
57.1
8.2
0.0
(
0.
5)
(15.1)
6.0
100.0
9.3
8.2
100.0
100.0
100.0
0 . 0
100
. 0
100.0
7.4
0.1
18
. 4
0.0
(59.
0)
100
. 0
34.2
(14.5)
100.0
100.0
0.0
(290.
4)
0 . 0
100
. 0
87
. 7
0.0
0.0
0.0
100
. 0
100.0
FISCAL
YEAR
BUDGET
29,113
.
00
540.00
40.00
29,693.00
116,873
.
00
0 .
00
22,161.00
22,368.00
138
.
00
117.00
10,369
.
00
10
,
986.00
2,044
.
00
2,000.00
12,150.00
0 .
00
120.00
10,311.00
19,998
.
00
558
.
00
1,260.00
19,265.00
2,160
.
00
355
.
00
863.00
325
.
00
0 .
00
91,070.00
0 .
00
68.00
0 .
00
50.00
1,300.00
115,241.00
75,000.00
0.00
664,342.00
142,245
.
00
FISCAL
PAGE:
20
F-YR
:
16
%-
YEAR-TO-DATE
VARI
-
ACTUAL
2,140
.
00
139.97
0 .
00
2 ,
279.97
31,192
.
25
0 .
00
6,019
.
90
6,645
.
33
32
.
40
0.00
2,613
.
78
2,932.03
1,061
.
11
577
.
50
0 .
00
0.00
0 .
00
5,577.03
4,462
.
45
131.29
89.03
4,509
.
32
654
.
95
0.00
296
.
19
93
.
00
25
.
00
0.00
0.00
22.14
0 .
00
0 .
00
271.00
28,810
.
26
18,750
.
00
0.00
332,760.71
51,857.02
ANCE
92.6
74
. 0
100.0
92
. 3
73.3
0.0
72.8
70.2
76.
5
100.0
74.7
73.3
48
. 0
71.1
100.0
0 . 0
100
. 0
45
. 9
77.6
76
. 4
92.9
76.5
69.6
100.0
65.6
71
. 3
100.0
100.0
0.0
67.4
0.0
100
. 0
79
. 1
75.0
75.0
0.0
49.9
63.5
26
54
DATE:
08
/
13/2015
TIME:
13:22:39
ID
:
GL470001.WOW
ACCOUNT
NUMBER
ADMINISTRATION
EXPENSES
50-50-8004
50-50-8005
50-50-9003
DESCRIPTION
FISCAL
AGENT
FEES
AMORITIZATION-BOND
ISSUE
COSTS
INTERFUND
TRANSFERS
TOTAL
EXPENSES
:
ADMINISTRATION
PW
ADMINISTRATION
EXPENSES
50-59-6101
50-59-6102
50-59-6104
50-59-6105
50-59-6201
50-59-6202
50-59-6204
50-59-6205
50-59-6206
50-59-6208
50-59-6209
50-59-6301
50-59-6303
50-59-6306
50-59-6307
50-59-6309
50-59-6312
50-59-6313
50-59-6402
50-59-6403
50-59-6406
50-59-6407
50-59-6500
50-59-6501
50-59-6502
50-59-6503
50-59-6504
50-59-6507
50-59-6508
50-59-6509
50-59-6510
50-59-6512
50-59-6515
50-59
-6516
SALARIES
-
FULL-TIME
SALARIES
- OVERTIME
SALARIES
-
PART-TIME
SALARIES
- SEASONAL
MEDICAL/ DENTAL INSURANCE
GROUP
LIFE
INSURANCE
UNEMPLOYMENT COMPENSATION
SOCIAL
SECURITY
CONTRIBUTIONS
IMRF
CONTRIBUTIONS
TRAINING
& MEMBERSHIPS
UNIFORM ALLOWANCE
LEGAL
SERVICES
ENGINEERING
SERVICES
MEDICAL
SERVICES
I.S
.
SERVICES
OTHER
PROFESSIONAL
SERVICES
JULIE
SERVICES
SCADA
SERVICES
RENTAL
REPAIR
&
MAINT.
SERV-EQUIPMENT
REPAIR
& MAINT .
SERV-BUILDINGS
REPAIR
& MAINT
SERV-VEHICLES
GENERAL EQUIPMENT
POSTAGE
&
DELIVERY
TELECOMMUNICATIONS
PUBLISHING
PRINTING
MILEAGE REIMBURSEMENT
RECEPTIONS
& ENTERTAINMENT
RECRUITMENT
NATURAL
GAS
WATER
& SEWER
PUBLIC
RELATIONS
EMPLOYEE
ACTIVITIES
VILLAGE
OF SUGAR GROVE
DETAILED
REVENUE &
EXPENSE
REPORT
BUDGET
VS.
ACTUAL WITH PERCENT VARIANCE
FOR 3
PERIODS
ENDING
JULY
31,
2015
FUND:
WATERWORKS
& SEWERAGE FUND
JULY
BUDGET
70.84
0.00
26,215.84
138,264.83
36,898.67
3,937.84
0.00
823.34
7,836.75
59.50
40.84
3 ,
101.92
3,838.67
633.34
166.67
25.00
250.00
70.50
29.17
2,435.42
250.00
5,583.34
65.59
403.17
1
,349.
50
1,250.00
500.00
425.92
631.75
0.00
250.00
4.17
10.42
12.50
0.00
47.92
20.84
20.84
JULY
ACTUAL
0.00
0 .
00
26,215.83
60,354.25
30,247.60
1,918.52
0 .
00
1,440.00
6,776.70
48.00
0.00
2,461.37
3,022
.
93
90.00
425
.
00
0.00
138.50
200.00
0.00
0.00
0.00
0.00
37
.
13
36.46
1,077.41
204.00
0.00
0.00
1,071.73
0.00
0.00
0.00
0 .
00
0.00
0 .
00
48.97
0.00
0.00
%
VARI-
ANCE
100.0
0.0
0 . 0
56.3
18.0
51.2
0.0
(
74.
9)
13
. 5
19
. 3
100.0
20.6
21.2
85.7
(154.
9)
100.0
44.6
(183.
6)
100.0
100.0
100.0
100
.0
43.3
90.9
20.1
83.6
100.0
100.0
(
69.6)
0.0
100
. 0
100.0
100.0
100.0
0.0
(2
.1)
100.0
100
.0
FISCAL
YEAR
BUDGET
850.00
0.00
314,590.00
1,659,177.00
442
,
784.00
47,254.00
0.00
9,880.00
94,041
.
00
714.00
490.00
37,223.00
46,064.00
7,600
.
00
2,000.00
300.00
3,000
.
00
846.00
350.00
29,225.00
3,000.00
67,000.00
787
.
00
4,838.00
16,194
.
00
15,000.00
6,000.00
5,111.00
7,581
.
00
0 .
00
3,000.00
50.00
125
.
00
150.00
0.00
575.00
250.00
250.00
FISCAL
PAGE:
21
F-YR:
16
%
YEAR-TO-DATE
VARI-
ACTUAL ANCE
0.00
0.00
78,647
.
49
578,031.18
112
,
141.90
6,062.52
0.00
2,640
.
00
28,592.26
152.00
0
.0
0
8,809
.
47
11,050.26
596.92
425
.
00
0 .
00
138.50
290.00
0 .
00
7.50
0 .
00
0 .
00
106.07
420.34
2,998.27
652.66
0.00
187.95
1,850.51
0.00
2,739.00
0.00
56.66
0.00
0.00
126
.
53
0.00
0.00
100.0
0 . 0
75
. 0
65.1
74.6
87
. 1
0.0
73.2
69.6
78.7
100
. 0
76.3
76.0
92.1
78.7
100
. 0
95.3
65.7
100
. 0
99.9
100.0
100.0
86.5
91.3
81.4
95
. 6
100.0
96.3
75
. 5
0.0
8.7
100.0
54.6
100.0
0.0
77
. 9
100.0
100.0
27
55
DATE:
08/13/2015
TIME
:
13:22:39
ID:
GL470001.WOW
ACCOUNT
NUMBER
PW
ADMINISTRATION
EXPENSES
50-59-6601
50-59-6602
50-59-6603
50-59-6604
50-59-6608
50-59-6612
50-59-6613
50-59-6617
50-59-7004
DESCRIPTION
FUELS
& LUBRICANTS
CUSTODIAL
SUPPLIES
SPECIALIZED
SUPPLIES
/ TOOLS
SAFETY
SUPPLIES
BOOKS &
SUBSCRIPTIONS
EQUIPMENT MAINTENANCE
SUPPLIES
GENERAL
OFFICE
SUPPLIES
VEHICLE
MAINT.
SUPPLIES
OFFICE
EQUIPMENT & MACHINERY
TOTAL
EXPENSES:
PW
ADMINISTRATION
WATER
OPERATIONS
EXPENSES
50-60-6303
50-60-6309
50-60-6311
50-60-6402
50-60-6403
50-60-6406
50-60-6510
50-60-6511
50-60-6518
50-60-6603
50-60-6606
50-60-6607
50-60-6610
50-60-6611
50-60-6612
ENGINEERING
SERVICES
OTHER
PROFESSIONAL
SERVICES
IEPA
WATER
SAMPLING
RENTAL
REPAIR
& MAINT. SERV-EQUIPMENT
REPAIR
& MAINT .
SERV-BUILDING
NATURAL GAS
ELECTRICITY
BAD
DEBT EXPENSE -
WATER
SPECIALIZED
SUPPLIES
LANDSCAPING
SUPPLIES
CHEMICALS &
LAB
SUPPLIES
TRAFFIC
CONTROL
SUPPLIES
BUILDING
MATERIALS &
SUPPLIES
EQUIPMENT PARTS
TOTAL
EXPENSES:
WATER
OPERATIONS
SEWER OPERATIONS
EXPENSES
50-65-6309
50-65-6402
50-65-6403
50-65-6406
50-65-6510
50-65-6511
50-65-6518
OTHER
PROFESSIONAL
SERVICES
RENTAL
REPAIR
& MAINT . SERV-EQUIPMENT
REPAIR
& MAINT .
SERV-BUILDING
NATURAL GAS
ELECTRICITY
BAD
DEBT EXPENSE - SEWER
VILLAGE OF SUGAR
GROVE
DETAILED
REVENUE & EXPENSE REPORT
BUDGET VS . ACTUAL
WITH PERCENT VARIANCE
FOR 3
PERIODS
ENDING
JUL
Y
31,
2015
FUND:
WATERWORKS
& SEWERAGE
FUND
JULY
BUDGET
2,700.25
250.00
416.67
208.34
83.34
250
.
00
75.00
1,333.34
0.00
76,290.53
2,083.34
11,916.67
833.34
198.50
1,008.34
625.00
91.67
17,000.00
31.67
7,833.34
250.00
8,711.67
83.34
229.17
66.67
50,962.72
6,833.34
92.84
1,291.67
916.67
177.09
1,291.67
25.17
JULY
ACTUAL
%
VARI-
ANCE
1,554.40
42.4
742.41
(196.9)
0.00
100.0
57.46
72.4
0 .
00
100.0
0.00
100.0
12
.
30
83.6
441.44
66.8
0.00
0.0
52,052.33
0 .
00
30
.
00
508.00
0.00
0 .
00
360.00
54.63
16,206
.73
20.54
9,494.96
0.00
5,946.27
0.00
317
.
13
0 .
00
32,938
.
26
0.00
0.00
432
.
95
0.00
140.65
1,285.27
18.96
31.7
100.0
99.7
39.0
100.0
100.0
42.4
40.4
4.6
35.1
(21.
2)
100.0
31.7
100.0
(38.
3)
100
.0
35.3
100.0
100
. 0
66.4
100.0
20.5
0.5
24.6
FISCAL
YEAR
BUDGET
32,403.00
3,000.00
5,000.00
2
,500
.
00
1,000.00
3,000
.
00
900
.
00
16,000.00
0.00
915,485.00
25,000.00
143,000.00
10,000.00
2,382.00
12,100.00
7,500
.
00
1,100.00
204,000.00
380
.
00
94,000.00
3,000.00
104,540
.
00
1,000
.
00
2,750.00
800.00
611,552
.
00
82,000
.
00
1 ,
114
.00
15,500
.
00
11,000.00
2,125.00
15,500.00
302
.
00
FISCAL
PAGE:
22
F-YR:
16
%
YEAR-TO-DATE
VARI-
ACTUAL
2,873.62
742.41
561.55
287.05
0.00
38.72
30.71
531.02
0 .
00
185,109.40
0 .
00
30.00
771
.
00
0.00
271
.
42
360.00
107.39
31,506.44
110
.
40
10,926.58
0.00
11,499.19
0.00
449.19
0.00
56
,0
31.61
0 .
00
0.00
432.95
0 .
00
271.93
2,003.75
102
.
48
ANCE
91.1
75.2
88.7
88.5
100
. 0
98.7
96.5
96.6
0.0
79.7
100.0
99.9
92.2
100
.0
97.7
95.2
90.2
84.5
70.9
88.3
100.0
89.0
100.0
83.6
100.0
90.8
100
.0
100
. 0
97.2
100.0
87.2
87.0
66.0
28
56
DATE:
08
/
13
/
2015
TIME:
13:22
: 3 9
ID:
GL470001.WOW
ACCOUNT
NUMBER
DESCRIPTION
VILLAGE
OF
SUGAR
GROVE
DETAILED
REVENUE & EXPENSE REPORT
BUDGET
VS.
ACTUAL WITH PERCENT VARIANCE
FOR 3
PERIODS
ENDING JULY
31,
2015
FUND:
WATERWORKS
&
SEWERAGE
FUND
JULY
BUDGET
JULY
ACTUAL
%
VARI-
ANCE
FISCAL
YEAR
BUDGET
FISCAL
PAGE:
23
F-YR
:
16
%
YEAR-TO-DATE
VARI-
ACTUAL
ANCE
----------------------------------------------------------
--
--------------------------------------------------------------------------------
SEWER
OPERATIONS
EXPENSES
50-65
-
6603
50-65-6607
50-65-6611
50-65
-
6612
SPECIALIZED
SUPPLIES
/ TOOLS
CHEMICALS
&
LAB
SUPPLIES
BUILDING
MATERIALS &
SUPPLIES
EQUIPMENT PARTS
TOTAL
EXPENSES
: SEWER OPERATIONS
WATER
CAPITAL
EXPENSES
50-
7
1-6301
50-71
-
6303
50-71-6305
50-71-6309
50-71-7001
50-71-7003
50
-
71
-
7004
50-71-7006
50-71-7011
50-71-8002
50-
7 1 -
8003
LEGAL
SERVICES
ENGINEERING
SERVICES
FINANCIAL
SERVICES
OTHER
PROFESSIONAL
SERVICES
LAND
ACQUISITION
BUILDING
IMPROVEMENTS
OFFICE
MACHINERY & EQUIPMENT
AUTOMOTIVE EQUIPMENT
WATER
SYSTEM IMPROVEMENTS
DEBT -
PRINCIPAL
DEBT -
INTEREST
TOTAL
EXPENSES:
WATER
CAPITAL
SEWER
CAPITAL
EXPENSES
50
-
72-6303
50-72-6309
50-7
2-
7001
50-72
-
7006
50-72-7007
50-
7
2-7012
50-72
-
800
2
50-72-8003
ENGINEERING
SER
V
ICES
OTHER
PROFESSIONAL
SERVICES
LAND
AUTOMOTIVE EQUIPMENT
OTHER EQUIPMENT
& MACHINERY
SANITARY SEWER SYSTEM IMPROV.
DEBT -
PRINCIPAL
DEBT -
INTEREST
TOTAL EXPENSES : SEWER
CAPITAL
TOTAL
FUND
RE
VENUES
TOTAL
FUND
EXPENSES
FUND SURPLUS
(DEFICIT
)
833
.
34
250
.
00
41
.
67
250.00
12,003.46
0 .
00
34,708.34
0.00
0 .
00
0.00
0.00
0.00
0.00
280,291.67
4,166
.
67
7 ,
802.09
326
,
968
.
77
1,666
.
67
0.00
0 .
00
0 .
00
0.00
6,666
.
67
0 .
00
0 .
00
8,333.34
310,900
.
53
615
,
298
.
08
(
304,397
.
55
)
0.00
18
.
38
0 .
00
0 .
00
1,896
.
21
0.00
19,941
.
70
0 .
00
0.00
0.00
0 .
00
0.00
0.00
0.00
0.00
0.00
19,941.70
6,038.00
0 .
00
0 .
00
0 .
00
0 .
00
0 .
00
0.00
0.00
6,038.00
32
,
354.45
174,280
.
24
(141
,
925
.
79)
100
. 0
92
. 6
100.0
100.0
84
. 2
0.0
42
. 5
0.0
0.0
0.0
0.0
0 . 0
0 . 0
100.0
100.0
100.0
93
. 9
(262.
2)
0.0
0 . 0
0.0
0.0
100.0
0 . 0
0 . 0
27.5
(
89.5)
71.6
(53
.
3)
10,000
.
00
3,000
.
00
500.00
3,000
.
00
144
,
041.00
0.00
416,500
.
00
0.00
0 .
00
0.00
0.00
0 .
00
0.00
3,363,500
.
00
50
,
000
.
00
93
,
625.00
3,923
,
625.00
20,000
.
00
0 .
00
0.00
0.00
0 .
00
80,000
.
00
0 .
00
0 .
00
100
,
000.00
3,730,806
.
00
7,383,573.00
(3,652
,
76
7
.00)
0 .
00
18
.3
8
0.00
0.
00
2 ,
82
9
.49
0.00
50
,
500.
7 0
0.00
0 .
00
0 .
00
0.00
0 .
00
0.00
1 8
1,126
.
80
50,000.00
47
,
312.51
328,940.01
7,
538.00
0.00
0 .
00
0 .
00
0 .
00
0.00
0 .
00
0 .
00
7,538
.
00
630
,
307.20
1,160,759
.
66
(530'
452.
46
)
100.0
99
. 3
100.0
100.0
98.0
0.0
87.8
0.0
0 . 0
0.0
0 . 0
0.0
0.0
94.
6
0.0
4 9 . 4
91.6
62.3
0 . 0
0.0
0.0
0 . 0
100.0
0.0
0.0
92.4
(
83
.
1)
84.2
(
85.4)
29
57
DATE:
08
/
13
/
2015
TIME:
13
:
22:39
ID:
GL470001
.
WOW
ACCOUNT
NUMBER
REVENUES
REVENUES
57-00-3650
57-00-3690
57-00
-
3761
57-00-3810
DESCRIPTION
REFUSE
PENALTIES
REFUSE CHARGES
REIMBURSEMENT
INTEREST
INCOME
TOTAL REVENUES: REVENUES
ADMINISTRATION
EXPENSES
57-50-6513
57-50-6518
57-50-9003
REFUSE & RECYCLING COLLECTION
BAD
DEBT EXPENSE -
GARBAGE
INTERFUND TRANSFER
TOTAL EXPENSES : ADMINISTRATION
TOTAL
FUND
REVENUES
TOTAL
FUND
EXPENSES
FUND
SURPLUS
(DEFICIT)
VILLAGE
OF
SUGAR
GRO
VE
DETAILED
REVENUE
& EXPENSE REPORT
BUDGET
VS.
ACTUAL
WITH
PERCENT VARIANCE
FOR 3
PERIODS
ENDING JULY
31,
2015
FUND
: REFUSE
FUND
JULY
BUDGET
1,283
.
17
71,288
.
34
0.00
6 .
67
72,578
.
18
70,945.00
7.17
3 ,
333
.
34
74
,
285.51
72,578.18
74,285.51
(1,707.33)
JULY
ACTUAL
1,364.50
(1.
98)
0.00
4.02
1,366.54
%
VARI-
ANCE
6.3
(100.0)
0.0
( 3
9.
7 )
(98.1)
65,448
.
32
7.7
22.00
(206
.
8)
3,333
.
33
0.0
68,803
.
65
7.3
1,366.54
(
98.
1)
68,803.65
7.3
(67,437
. 1
1)
3849.8
FISCAL
YEAR
BUDGET
15,398.00
855,460.00
0 .
00
80.00
870,938.00
851
,
340.00
86.00
40,000.00
891,426.00
870
,
938
.
00
891,426.00
(20,488.00)
FISCAL
PAGE :
24
F-YR
:
16
%
YEAR-TO-DATE
VARI-
ACTUAL
4 ,
229.33
139,758
.
74
0.00
7 . 4 9
143,995.56
130
,
834.03
110
.
66
9 ,
999.99
140
,
944.68
143
,
995.56
140
,
944
.
68
3,050.88
ANCE
(72.5)
(83.6)
0 . 0
(
90.
6)
(83.
4)
84.6
(28
.
6)
75.0
84.1
( 83 .
4)
84.1
(114.
8)
30
58
VILLAGE OF SUGAR GROVE
BOARD REPORT
TO: VILLAGE PRESIDENT & BOARD OF TRUSTEES
FROM: ANTHONY SPECIALE, DIRECTOR OF PUBLIC WORKS
GEOFF PAYTON, STREETS & PROPERTIES SUPERVISOR
SUBJECT: APPROVAL: PURCHASE OF REPLACEMENT TANDEM AXLE AND
SINGLE AXLE DUMP TRUCKS
AGENDA: AUGUST 18, 2015 REGULAR BOARD MEETING
DATE: AUGUST 12, 2015
ISSUE
Should the Village Board approve the purchase of a replacement tandem axle and
replacement single axle dump trucks.
DISCUSSION
The Fiscal Year Ending 2015 budget included funds to purchase two replacement
Dump Trucks for Streets & Properties. However, due to a delay in the State of Illinois
releasing the pricing for state bid purchases, the purchase was not finalized prior to the
end of FYE 2015. The funds were not carried over to FYE 2016; however, they are still
available in the Capital Fund.
Two tandem axle plow trucks are overdue for replacement, a 2000 International and a
2002 International, both with wing plows and would be used as a trade in towards the
new Mack Tandem Axle and Mack Single Axle dump trucks. The value of the trucks on
trade are $18,000.00 and $22,000.00 respectively. Both replacement dumps would be
equipped with a snow plow, wing plow and a v-box salt spreader. These trucks also
include electronic spreader and plow control equipment to increase the efficiency of
snow control operations.
The replacement trucks will be purchased through the Illinois State Tollway Pricing
contract from CIT Group Inc. The cost of the replacement dump trucks are $179,227.26
for the Tandem Axel and $152,031.47 for the Single Axle for a total of $331,258.73.
Staff conducted a survey of truck dealerships to compare the trade in price and is
confident with the $40,000.00 trade in from CIT Group, Inc. and believe this price is
consistent with the fair market value. Staff recommends the Village Board waive the
competitive bid process and approve the purchase of the two replacement dump trucks
from CIT Group, Inc.
59
COST
The cost of the Replacement Dump Trucks with snow removal equipment is
$331,258.73 minus trade of two International dumps. The funds were not carried over
to FYE 2016; however, the funds are still available. The purchase would be made from
the Streets Capital Projects Fund, account number 30-53-7006: Automotive Equipment
RECOMMENDATION
That the Village Board waives the bidding process and approve Resolution #
20150818PW1 authorizing the purchase of two dump trucks with snow removal
equipment utilizing the CMS Illinois Tollway Pricing contract in the not to exceed amount
of $331,258.73 from the CIT Group Inc.
60
RESOLUTION NO. 20150818PW1
VILLAGE OF SUGAR GROVE, KANE COUNTY, ILLINOIS
RESOLUTION AUTHORIZING PURCHASE OF TWO REPLACEMENT DUMP TRUCKS
WITH SNOW REMOVAL EQUIPMENT FROM CIT GROUP INC.
WHEREAS, the Village of Sugar Grove Board of Trustees find that it is in the best interest
of the Village to engage the services of CIT Group Inc. for the purchase of two replacement dump
trucks with snow removal equipment, and to execute an agreement;
NOW, THEREFORE, BE IT RESOLVED by the President and Board of Trustees of the
Village of Sugar Grove, Kane County, Illinois, as follows:
The Director of Public Works is hereby authorized to execute an agreement between CIT
Group Inc. and the Village of Sugar Grove for the purchase of two replacement dump trucks
with snow removal equipment said agreement on behalf of the Village and to take such
further actions as are necessary to fulfill the terms of said agreement.
Passed by the President and Board of Trustees of the Village of Sugar Grove, Kane County,
Illinois, at a regular meeting thereof held on the 18th day of August, 2015.
P. Sean Michels
President of the Board of Trustees
of the Village of Sugar Grove, Kane
County, Illinois
ATTEST:
Cynthia L. Galbreath
Clerk, Village of Sugar Grove
Aye Nay Absent Abstain
Trustee Kevin M. Geary
Trustee Sean Herron
Trustee Mari Johnson
Trustee Ted Koch
Trustee Rick Montalto
Trustee David Paluch
61
VILLAGE OF SUGAR GROVE
BOARD REPORT
TO: VILLAGE PRESIDENT & BOARD OF TRUSTEES
FROM: WALTER MAGDZIARZ, COMMUNITY DEVELOPMENT DIRECTOR
SUBJECT: DISCUSSION: TEMPORARY USE APPROVAL PROCESS UPDATE
AGENDA: JULY 21, 2015 VILLAGE BOARD COMMITTEE OF THE WHOLE MEETING
DATE: AUGUST 14, 2015
ISSUE
Should the Village Board consider changing the approval of all temporary use applications from
a legislative process to an administrative process.
DISCUSSION
The Committee of the Whole last discussed this topic on July 21 and directed staff to begin
preparing the process for transforming the temporary uses and special events approval process
into an administrative process.
At present, temporary uses are approved both administratively and legislatively in Sugar Grove
as prescribed in the Zoning Ordinance. Temporary uses that are approved administratively are
limited in number and have specific criteria to meet in order to qualify for administrative
approval. The Zoning Ordinance sets forth requirements for the application, findings, and
authorizes conditions of approval. Additionally, there are special events that occur in the Village
that are not regulated by the Zoning Ordinance contributing to the confusion the public has
concerning the permit requirements.
Additionally, there have been instances in the past of a local business or charitable organization
desiring to hold a temporary or special event submitting applications for a temporary use permit
with insufficient time to review and obtain Village Board approval. This has caused a mild level
of consternation among Village staff and the Village Board, and is extremely frustrating for the
permit applicant.
In order to be responsive to special event applicants, Village staff believes it is necessary to
expedite the application review process. Since various departments are involved in the review
of temporary use applications, we believe the objectives of public health, safety and general
welfare can be adequately covered. Many communities in the area already review similar
applications administratively.
In just the past 24 months, the Village has responded to temporary use applications for such
purposes as: the American Legion bags tournament and poker run; Cystic Fibrosis cycling
event; Tour de Cure cycling event (American Diabetes Association); Pure Pikemi a marathon
event on the Virgil Gilman Trail; Rocky’s Do Jo anniversary; model home sales offices at Prairie
Glen and Meadowridge Villas to name just a few.
64
2
The review time for special event applications varies widely among the communities surveyed.
Most are between 21 and 30 days but a few allowed as much as 90 days to review the
applications. Block parties, generally, are treated differently from other special events and the
review time was in the neighborhood of 7 to 10 days.
Most communities provide an appeal process for applications that are denied and the corporate
authorities function as the appeal board in these instances and make the final decision.
In the course of developing the administrative procedures for special event permits we found two
common practices that may be of interest to the Village Board: establishing a tiered permit
system, and charging special event sponsors for Village services. The tiered application process
recognizes not all special events are the same and some consideration is needed to differentiate
the major event with attractions from a block party.
Generally, communities do not charge an application fee for the special event permit (Aurora
being the exception), but permit fees were collected for temporary signs, building permits, liquor
permits, health department permits, or other amusement permits or licenses associated with the
special event.
Nearly all of the communities surveyed charged special event sponsors for Village equipment
and services used during the operation of the special event. Not every special event requires
municipal services but those that do get billed in most communities. Services such as patrolling
the premises, traffic control, street barricades, posting and removing temporary no parking
signs, and the like are typical billed services.
The review process envisions an ad hoc special events committee composed of representatives
from Village departments (and the Fire Department in selected instances) reviewing the
application and making recommendations to a “special events coordinator” who is responsible
for approving or denying the application based on the committee’s recommendation. In every
community surveyed the “special events coordinator” is the Village manager or administrator
who is authorized to designate an individual to perform the function of “special events
coordinator.”
ATTACHMENTS
Special Event application requirements and procedures outline
COSTS
There are no costs associated with the discussion.
RECOMMENDATION
If the Board has any interest in the tiered application approach and reimbursement requirement,
the Board should communicate its preference to staff to include in the proposed
temporary/special event application requirements and procedures.
65
3
Temporary/Special Event Application
Requirements & Procedures
Objective: Separate temporary uses as they relate to zoning regulations from temporary
events staged or sponsored by community groups, businesses or residents and in the
process make the application process for special events an administrative rather than a
legislative process.
The process will be codified and the general outline is shaping up like this:
1 PURPOSE
2 SPECIAL EVENT PERMIT REQUIRED
3: DEFINITIONS
4: PERMIT REQUIRED; EXCEPTIONS e.g. private events at a residence;
funeral processions; groundbreaking ceremonies; events held in a
permanent structure designed for that event, i.e., a sports event in
a stadium
5: PERMIT APPLICATION
6: APPLICATION REVIEW; PERMIT ISSUANCE
7: PERMIT DENIAL: RIGHT TO APPEAL
8: EMERGENCY REVOCATION
9: PERMIT REQUIREMENTS AND CONDITIONS; INSURANCE AND
PAYMENT FOR ADDITIONAL VILLAGE SERVICES
10: ADDITIONAL STANDARDS AND CRITERIA
A: SOUND AMPLIFYING DEVICES
B: SALE AND CONSUMPTION OF ALCOHOLIC LIQUOR
C: SPONSOR RESPONSIBLE FOR CONDUCT OF SPECIAL EVENT
D: SPECIAL EVENTS COSPONSORED BY THE VILLAGE
E. VENDOR REQUIREMENTS
11: INTERPRETATION
66
Village of Sugar Grove
Public Works Department
MEMORANDUM
August 14, 2015
TO: Village President and Board of Trustees
FROM: Anthony Speciale, Public Works Director
RE: PUBLIC WORKS DEPARTMENT STAFF REPORT
The following is a short summary of current projects that the Public Works Department is
addressing:
Meetings:
On August 7, 2015 Brad Merkel and I attended the pre-construction meeting for the
Queensgate Sanitary Sewer Improvements project. The project scope, materials and
completion schedule were discussed. The project began August 10, 2015 and is expected
to be substantially complete this week.
Streets & Properties:
IL 47 / I-88 Interchange Project
The contract for Phase I engineering was awarded to Graef USA Inc. at the December
22, 2015 Special Board Meeting. Phase I engineering is expected to take approximately
36 months. Approval of Phase I from IDOT, the Tollway and the FHWA will also be
obtained. Public Meeting #1 was held at Waubonsee Community College on July 29,
2015. Work on Phase I is continuing.
The Community Advisory Group Meeting #1 will be held on Tuesday, September 1, 2015
at Waubonsee Community College. The purpose of the first CAG Meeting is to introduce
the Community Advisory Group (CAG) members to their role in the Context Sensitive
Solutions (CSS) Process.
IL47 / Bliss Road / Wheeler Road
Engineering Enterprises, Inc. was selected for Phase I and Phase II engineering. The
Phase I and Phase II agreements were approved at the February 4, 2014 Board Meeting.
The revised IDS has been submitted, the environmental study and soil borings have been
completed. Coordination with IDOT and Kane County is on-going. Phase II is nearing
completion.
Dugan Road / Granart Road Roundabout Project:
The bid opening for this project was held August 4, 2014. The Contract was awarded to
Geneva Construction at the August 5, 2014 Board Meeting. The signs are substantially
67
complete, surface course paving and permanent striping has been completed. The
roundabout will remain open to Local Traffic Only until August 21, 2015. At that time, the
detour will be removed.
Denny Road LAFO:
This project was approved at the February 3, 2015 Board meeting. The project consists
of using STP funds to complete an overlay on Denny Road from Pinecrest Drive to Bliss
Road. EEI is working on Phase I engineering. Construction is expected to take place in
Spring / Summer 2016.
2015 MFT / Road Program:
This program was approved at the December 22, 2014 Special Board meeting. The
contracts were opened on March 26, 2015 and awarded at the April 7, 2015 Board
meeting.
The resurfacing of Heartland Drive, Waubonsee Drive, Calkins Drive and Grove Street
was awarded to Geneva Construction. A pre-construction meeting was held June 16,
2015 for the resurfacing. Paving was completed on Grove Street and Calkins Drive
August 7, 2015. Paving on Heartland Drive was completed August 13, 2015. Site
restoration and pavement markings are the remaining items to complete.
The crack sealing portion of the program was awarded to Behm Pavement Maintenance.
Crack sealing was completed on June 29, 2015.
Black Walnut Trails Unit 7 and 8 Sidewalk Improvements:
This project bid opening was held May 11, 2015. The project was awarded to Triggi
Construction at the May 19, 2015 Board. The project is being funded by Letter of Credit
money secured from these two units. A preconstruction meeting was held July 10, 2015.
Construction begin the week of July 20, 2015 and was completed on August 12, 2015.
Minor grading issues on one of the lots will be completed in the near future.
Pavement Marking Program:
This project was awarded at the May 5, 2015 Board Meeting. Pavement marking will be
completed on Capitol Drive, E. Park Avenue, W. Park Avenue, Merrill Road, Esker Drive
School Zone and Hankes Road (if budget allows). The paperwork was submitted May 15,
2015 and painting started July 13, 2015.The project was completed August 6, 2015.
Airport House Demolition:
This project was awarded to G Snow Excavating at the July 21, 2015 Board Meeting.
Demolition began on July 30, 2015. The structure has been removed, the well has been
capped and the septic has been abandoned. Site restoration is still in need. This project
is expected to be completed by August 28, 2015.
Mosquito Abatement:
Larvacide applications to catch basins was completed the week of June 8, 2015. Staff is
continuing to monitor the catch basins for mosquito activity. With the extremely wet start
to summer, a second treatment will be completed as the weather conditions are favorable
for mosquito breeding. The materials have arrived and the second application is expected
to be completed by August 21, 2015.
68
Utilities:
Settlers Ridge to Mallard Water Main Project:
Bid’s for this project where opened on March 31, 2015 awarded at the April 7, 2015 Board
Meeting. A pre-construction meeting was held April 16, 2015 to discuss the project scope
and schedule. The directional boring of Prairie Street and the railroad tracks was
completed on May 22, 2015. The project is complete.
Fays Lane and Sugar Lane Water Main Projects:
A Pre-Construction meeting was held July 24, 2015. Work is scheduled to begin at Fay’s
Lane on August 17, 2015.
Settlers Ridge to Prestbury Water Main Project:
The Design Engineering Contract was approved at the April 7, 2015 Board Meeting.
Topography will begin the third week of April. Updates will be given as they become
available.
Windstone Sanitary Sewer Project
The contract was awarded to Stark & Son Trenching at the July 21, 2015 Board Meeting.
This project is 75% complete with only restoration remaining.
Windstone Lift Station Siding Project
This project is complete.
Staff collected monthly water samples as required by the IEPA.
Staff completed 202 JULIE Locates in August to date.
69
FINANCE DEPARTMENT STAFF REPORT
TO: VILLAGE PRESIDENT & BOARD OF TRUSTEES
FROM: PAT CHAMBERLIN
DATE: AUGUST 13, 2015
Staff currently working on:
Participated in a meeting and conference call with Mark Bushhouse from Williams
Architects to review the final layout for the new Village Hall. There were a few minor
changes that still need to be made. The layout of the building and the mechanicals of the
building were discussed.
Currently working on the budget document so that the Village can receive the
Distinguished Budget Presentation Award for the ninth year in a row. There are several
schedules and documents that will be updated to reflect changes since the last budget
document was prepared.
Staff is currently working on audit schedules for the upcoming audit. The auditors are at
Village Hall the week of August 10. The final audit report will be completed the end of
September with a presentation of the audit to the Village Board the second week in
October.
July July
2015 2014
Totalnumberof
waterandsew eraccounts 4,216 4,173
Totalgarbage
accountsbilled 3,141 3,099
Numberofmetersread 4,165 4,122
Waterusage* 19,903 20,938
Se w erusage* 18,658 19,950
*1,000'sofgallons
70
Download
Save PDF to desktop
Email
Email completed PDF
Send for Signing
Email for others to sign
Print
Print document
Choose a Field
Click on a field and
select the person that should complete it
Want to add a signature?
You can add a signature field
and assign it to someone else
to sign
Choose a Field
Click on a field and
select the person that should complete it

Form 08182015 2. Pledge Of Allegiance 1. Call To Order (Village of Sugar Grove)

This document is locked as it has been sent for signing.

You have successfully completed this document.

Other parties need to complete fields in the document. You will recieve an email notification when the document has been completed by all parties.

This document has been signed by all parties.

Completed 9 August 2020

Message

View Audit Log
Print With Audit Log
Duplicate Document