HomeMy WebLinkAbout4. Bills 05/03/2011Mount Prospc
Village of Mount Prospect
Mount Prospect, Illinois
INTEROFFICE MEMORANDUM
TO: VILLAGE PRESIDENT AND BOARD OF TRUSTEES
FINANCE COMMISSION
FROM: FINANCE DIRECTOR
DATE: APRIL 29, 2011
SUBJECT: MONTHLY FINANCIAL REPORT — MARCH 2011
Attached hereto are the cash position and investment statements of the Village for the month ended
March 31, 2011. These statements provide a snapshot of the Village's cash position as of the
month end date noted and are intended to supplement the budget revenue and expenditure
summary and listing of bills you receive. The first statement presents the Village's cash position
broken down by governmental and enterprise funds and trust and agency funds. The second
statement presents the Village's cash position by fund type. The third statement presents the list of
investments again broken down by governmental and enterprise funds and trust and agency funds.
It is important to note that although we have included the trust and agency funds in the cash position
report, these are not funds accessible for Village operations. They are restricted for pension and
escrow funding only. Please read the summary that follows for further detail on the cash position of
the Village.
Cash and Investment Position Report — All Funds (page 1)
This report provides a detailed summary of cash and investments for the Village broken out by
governmental and enterprise funds and trust and agency funds. Governmental funds include the
General Fund, Special Revenue Funds, Debt Service Funds, Capital Project Funds and Internal
Service Funds. The Enterprise Funds consist of the Water and Sewer Fund and two (2) Parking
Funds.
Trust funds include the Village's two public safety pensions (Police and Firefighters') while the
agency funds include the Escrow Deposit, Flexcomp Escrow, Special Service Area and Library
Bonds Escrow Funds. The Escrow Deposit Fund accounts for refundable deposits held by the
Village to ensure completion of public improvements. The Flexcomp Escrow Fund accounts for
employee payroll deductions pursuant to a Section 125 flexible compensation plan. The Special
Service Area Fund and Library Bonds Escrow Fund account for the accumulation of monies for debt
service payments.
Governmental and Enterprise Funds - Cash and cash equivalents at February 28 were $24.6
million. During March, cash receipts totaled $7,652,160.14. In addition investment income for the
month was $3,347.74. Reductions to cash and cash equivalents during March totaled
$7,331,306.95. Of this amount, payments to vendors were $5,381,124.98, employee payroll and
related expenses were $1,950,181.97. There was also a net increase in cash due to year -end
adjustments of $154,813.65. Cash and cash equivalents at March 31 increased to $25.1 million.
Monthly Financial Report - March 2011
April 29, 2011
Page 2
There were no funds held in investments during the month of March. Funds were held in cash
money market accounts that currently earn competitive rates of interest.
Total cash and investments for Governmental and Enterprise Funds at February 28 were
$24,644,703.29. Cash and investments at March 31 totaled $25,123,717.87. This is an increase of
$479,014.58 for the month. The increase is primarily due to the receipt of the first installment of
2010 property taxes.
Trust and Agency Funds - Cash and cash equivalents at February 28 were $7.2 million. During
March, cash receipts totaled $888,031.61. In addition investment income for the month was
$27,803.15. There was also a net decrease in cash due to investment activities of $1,327,349.25.
Reductions to cash and cash equivalents during March totaled $756,439.09. Of this amount,
payments to vendors were $191,083.10 employee payroll and related expenses were $494,537.23,
and payments related to the flexible spending program totaled $55,116.70. There were also other
adjustments totaling $15,702.06. Cash and cash equivalents at March 31 were $6.0 million.
Total investments at March 31 were $84,591,262.57, an increase of $3,463,803.72 from February
28. There were investment income of $2,136,454.47 and a net transfer in totaling $1,327,349.25
that accounted for the change.
Total cash and investments for Trust and Agency Funds at February 28 were $88,338,472.50.
Cash and investments at March 31 totaled $90,634,322.64. This is an increase of $2,295,850.14
from the prior month.
Summary of Cash Activity by Fund Type (page 2)
This report provides a breakdown of the cash activity for the month broken down by fund type. This
breakdown is useful in identifying where the activity (receipts and disbursements) is occurring.
There are times during the year when activity in certain funds such as the capital improvement and
special revenue funds is higher than normal. This will distort the financial picture of some of the
other components of the governmental funds such as the General Fund which tends to be more
level and predictable in terms of spending and receipt of revenue. Each month the report will
provide further explanation on the activity of the General Fund, the Village's primary operating fund.
The report will also provide additional information on fund types that experienced higher than normal
activity for the month. Activity for the General Fund is highlighted below.
General Fund - Cash and cash equivalents at February 28 totaled $5,252,630.58. During March,
cash receipts totaled $3,985,558.81 and investment income was $2,795.14. Significant cash
receipts included property taxes, sales taxes and vehicle stickers.
The initial receipts of the first installment of 2010 Property taxes were seen during March. A
total of $1,997,740.36 was received in the General Fund during the month. This represents
roughly 21.3% of the total budget.
Sales tax revenues for the month totaled $1,087,301. Of this amount, $970,858 was generated
from the 1% state portion while $116,443 was generated from the .25% home rule portion.
Sales taxes received in' March are for December sales. There is a normal three -month lag in
getting this distribution from the state.
Monthly Financial Report — March 2011
April 29, 2011
Page 3
Vehicle Stickers went on sale February 1 for the 2011 -2012 license period. Total receipts for
March were $301,194. The total budget for this line item is $1,405,000. We are at 38.9% of the
total budget. A majority of the sticker sales will occur in April with the April 30 deadline required.
Disbursements from the General Fund for March included payments to vendors of $1,694,129.55,
payments for employee wages and benefits of $1,567,157.59 and other adjustments of $11,023.51.
Cash and cash equivalents at March 31 were $5,968,673.88. There were no investments in the
General Fund at March 31.
Statement of Investments (page 3)
This report provides a breakdown of investments by governmental and enterprise funds and trust
and agency funds. The report also provides a fund -by fund breakdown of the investments.
Government and Enterprise Funds - Investments for the governmental and agency funds are
typically made up of Certificates of Deposit. At March 31 there were no CD's placed at any bank.
This is due to the extremely low interest rates being offered. Money instead has been placed in
interest bearing money market accounts
Trust and Agency Funds — The investments for the trust and agency funds are made up of
certificates of deposits, fixed income investments and equity mutual funds. CD's (if any) held in the
Escrow Deposit Fund will generally have maturities of between 30 and 120 days. Most of the
reserves for this fund are invested in the more liquid money market account due to the nature of the
deposit. Escrow refunds are processed two times per month.
Investments for the Police and Firefighter Pension Funds consist of various fixed income securities
as well as equity mutual fund accounts. Wells Fargo is the third -party holder of the fixed income
securities. The funds are managed by three investment management firms, Capital Gains, Segall
Bryant and Mesirow Financial. Segall Bryant holds approximately half of the fixed income
investments for the two pension funds while Capital Gains and Mesirow manage the balance of
fixed income investments for these two funds. Each manager maintains a small portion of their
portfolio in cash to help facilitate liquidity and trading.
Investments in equities consist of mutual funds spread across various sectors (small, mid and large -
cap stocks) as well as investment philosophies (value, core and growth). The pension funds also
have a small portion of their portfolio invested in international stocks. Each year the investment mix
is evaluated for optimal diversification to meet the pension funds investment policy goals and
objectives. Below is a breakdown of how the pension fund portfolios are invested.
Monthly Financial Report — March 2011
April 29, 2011
Page 4
Maturity Purchase Financial Investment
Date Date Institution Description
POLICE PENSION FUND (070)
Various Various Wells Fargo
Various Various Various
Wells Fargo Investments
Mutual Fund Investments
FIRE PENSION FUND (071)
Various Various Wells Fargo
Various Various Various
Wells Fargo Investments
Mutual Fund Investments
CUSIP/
Interest
Market
Acct #
Rate %
Value
Various
Various
21,428,522.01
Various
Various
21,703,513.74
43,132,035.75
Various Various
Various Various
TOTAL TRUST AND AGENCY FUND INVESTMENTS
" Assets are restricted in purpose and do not represent discretionary assets of the government.
21,428,475.81
20,030,751.01
41,459,226.82
$ 84,591,262.57
Investment of the Village's pension funds is governed by an Investment Policy adopted by each
Pension Board. The policy was last amended in 2011.
Conclusion
This cash position report is intended to provide a snapshot of the Village's cash position as of a
particular month end date. With this information we are now able to analyze trend information to
help in cash management duties, maximizing investment earnings while ensuring availability of
funds to meet the Village's commitments.
David O. Erb
Finance Director
WACCTUreasurer's Report\201 1 \Monthly Financial Report\Monthly Cash Position Report - March 2010.doc
VILLAGE OF MOUNT PROSPECT
Preliminary Cash and Investment Position Report - All Funds
For the Month Ended March, 2011
GOVERNMENTAL AND ENTERPRISE FUNDS
Cash and Cash
Equivalents Investments
Balance at February 28, 2011 $ 24,644,703.29 $ -
Cash receipts 7,652,160.14
Investment income 3,347.74
Transfers from investments to cash -
Transfers to investments from cash -
Interfund activity -
Disbursements:
Accounts payable (5,381,124.98)
Payroll (1,950,181.97)
Other 154,813.65
Balance at March 31, 2011 $ 25,123,717.87
Total Cash and
Investments
$ 24,644,703.29
7,652,160.14
3,347.74
(5,381,124.98)
(1,950,181.97)
154.813.65
$ - $ 25,123, 717.87
TRUST AND AGENCY FUNDS *
Cash and Cash
Equivalents
Balance at February 28, 2011 $ 7,211,013.65
Investments
Total Cash and
Investments
$ 81,127,458.85 $ 88,338,472.50
Cash receipts 888,031.61 888,031.61
Investment income (loss) 27,803.15 2,136,454.47 2,164,257.62
Transfers from investments to cash 572,298.24 (572,298.24) -
Transfers to investments from cash (1,899,647.49) 1,899,647.49 -
Interfund activity -
Disbursements
Accounts payable (191,083.10) (191,083.10)
Payroll (494,537.23) (494,537.23)
Flex spending (55,116.70) (55,116.70)
2010 Adjustments (15,702.06) (15,702.06)
Balance at March 31, 2011 $ 6,043,060.07 $ 84,591,262.57 $ 90,634,322.64
* Assets are restricted in purpose and do not represent discretionary assets of the government
1
2
V LO O V rn
W O O W
q
N LO
r
o r W N V
0 r N O
O
W r
tf)
OHO W r
W
r
r V
N
O
J D) LI') W V
Q r N O
_ O
r r N
r
r
M W
D) N
(D
N
V'
O
F- LO O r N M
0 N V M r D)
O) LO V N
T LO V r
(D
(fl
co 7
LO M
o
co
F- W In Ln W
`-� Lf')
W r
LO
N
co r
N LO
r
N r
T �t
V
W
LL
r
g
(f1
fRl
tO
L'7 O LO
D)
O
u) >- V ON
N N
'7
et
U)
Z
' W
0
O LO clj r co
W
~CD
O
r� O
O Lr)
V
Z
Nrs-
OD
W a
��
LL
W N r
N_
N
O Q
Z
W
Vi
Q
V O O V O)
r M M
W
N LO
r
u)
0
Z
N (D O N CI'
0 u) co "r Lo W r
r N W
to r r
LO
V
W r
r 'R
LO
N
r
r
Q
Z W Z (D O O D1 V
o Cl) W
LI)
D) (D
O
F
a () O O M W N O
v Ln O
LO
W N
N
O
J co LO r N M
W cf)
LO V Cl)
co
N
D
N r N r W
z
Z W r LO W
O V
.-
r
r
LO M
W r
m
UI
co
M
_2
LL CL Ln
-
'�'
,-
v c
0
0
v;
(n
W V V
v)
F-
(2 N r r
(D M O
W
fb
> co O r
.
Cl)
N
^
r
O (D V
r M
x
r W
W
r
r
5 m
C7 w z V
V o —
Cl)
M
LO
J Z V LO
LO LO W
O o
O co
w W
N
N
0
O
Z
Q t»
cn
u r v) CD
0
W N fD
N
N
c)"T
J Z O W 6
v�
Z W W m ul
O rl v
Lo
L
W W O�
m W
I- U M N
N
r (D
V
to
V*
W
Z > m
v
r-
n
m
u)
to
F- o
W a N
cD
W ( V
O— C (
(
(
d C-
co
�2 — co N
V O D)
co
m
M
UJ
x (n U') V
O O
o LO co
V r
r
W
h
o0
n -a U
z
W
CD
F L LL L
LO m
F u- M
N
N
V r
V
7
:3 U N
w
(n
Z
W
O a o
F
e»
w
u Nw
a
w m t
O U
x
F
r r
o rn
Lp
m
w O
C)
W
D) W
o
< r
o
c6 o
(D
o
(D
0
Z �
� v
v LMD
E =
z
a -z a))
w W
w
E
Q
U
>
L
n LL
Q
L' W .-
a
m
ai
z (»
(n
w
w W D
O
V
v
i
i
m
cc)
>
Of 0 V r
V
r
n d
E
CO Z V co
r
n `
N
oo V
LL
N
T
m
r >
Us
6r a
I
O L O r
N 0 0
O
O p
r (,�
lA (p
M
M
J W co V V
1
I-- w
O
V W '7
M
Uz0 LI) -
rn v IT
r
N
W w
N 2
WM
U) L>J u- 6) (D
r` u)
V
m
CO
N
N
EPr
to
U
0 W V
u) O
W
W
Z LD W
LD In lD
Lo
W
OJ C
O co LO . . .
M r tT
M
Ln
W co u') m
N
r
ti
J (D Ln r
Q N
O cN--
W
W
cD
O
w L 000
w N LA
V (D
L1) (D
(
to
w d
fA
Z LO co
r
u)
L6
LU
(7 es
vs a
a
� C
m
W O
F-
O
z
Z
w
a o
5
J �
N 42
n
w C
N
> E
a o o
Y N
Z
w
a
C N
N (1 m
aL N
C
W U E
A O E C
N N N N
U
F a C C
= N
N
N m ..+ C O
a a o
E C C C
C
Z p
p
E
y N
s �,
U
w m w w
E E E
W a
rnC
O)u c
5
Q
m
Q
i E d C
a T m
m f N „
C
J U)
C L N
O D
C1
W .� 2
F N
C C
m rn m m m
a >
5 9
o rn w L.
> 6 7
Q
m
UmU UHF �N000
W
!V
?U�:2
O
F
O
F-
2
VILLAGE OF MOUNT PROSPECT
STATEMENT OF INVESTMENTS
As of March 31, 2011
GOVERNMENTAL AND ENTERPRISE FUNDS
Maturity Purchase Financial Investment CUSIP/
Date Date Institution Description Acct # _
As of March 31, 2011, there were no certificates of deposit held by the Governmental and Enterprise Funds.
Weighted
Avg Yield
* Assets are restricted in purpose and do not represent discretionary assets of the government.
Interest
Market
Value
3
TRUST AND AGENCY
FUNDS
Maturity Purchase Financial
Investment
CUSIP/
Interest
Market Weighted
Date Date Institution
Description
Acct #
Rate %
Value Avg Yield
POLICE PENSION FUND (070)
Various Various Wells Fargo
Wells Fargo Investments
Various
Various
21,428,522.01
Various Various Various
Mutual Fund Investments
Various
Various
21,703,513.74
43,132,035.75
FIRE PENSION FUND (071)
Various Various Wells Fargo
Wells Fargo Investments
Various
Various
21,428,475.81
Various Various Various
Mutual Fund Investments
Various
Various
20,030,751.01
41,459,226.82
TOTAL TRUST AND AGENCY FUND INVESTMENTS
$84,591,262.57
* Assets are restricted in purpose and do not represent discretionary assets of the government.
Interest
Market
Value
3
VILLAGE OF MOUNT PROSPECT
List of Bills
April 14 -April 27, 2011
Fund Vendor
Description
Amount
001- General Fund
Acs Government Systems, Inc.
Firehouse Training 4/14 - Chris Onjack
$ 100.00
Active Alarm Company, Inc.
Fire Alarm Monitoring
79.50
Aerex Pest Control Services, Inc.
Annual Pest Control
30.00
Aerex Pest Control Services, Inc.
Annual Pest Control
35.00
Aerex Pest Control Services, Inc.
Annual Pest Control
40.00
Aerex Pest Control Services, Inc.
Annual Pest Control
30.00
Aerex Pest Control Services, Inc.
Annual Pest Control
30.00
Aerex Pest Control Services, Inc.
Annual Pest Control
30.00
Air One Equipment, Inc.
1044FSW Faceshield White
183.00
Air One Equipment, Inc.
Hem Patch
70.00
Airgas North Central
Oxygen and Cylinder Rental
176.20
Airgas North Central
Oxygen & Cylinder Rental
65.64
Airgas North Central
Oxygen & Cylinder Rental
319.58
Airgas North Central
Oxygen & Cylinder Rental
84.95
Alexian Brothers Medical Center
Pre - employment testing Yousif
69.00
Alexian Brothers Medical Center
Pre - employment Testing Seth Westberg
158.00
American Future Systems, Inc.
Subscription Renewal
255.60
American Landscaping Inc.
Grounds Maintenance Service
6,212.50
American Landscaping Inc.
Shrub /Flower Replacement
830.00
American Public Works Assoc.
Open House Supplies
715.00
ARC Disposal Company
Refuse Disposal Program
2,515.87
Armor Systems Corporation
Commission for March, 2011
26.67
Association of Police Social Workers
Membership dues for Kimberly Sheagren
40.00
Association of Police Social Workers
Membership dues for Nina Persino
40.00
AT&T
Service 4/7/11 - 5/6/11
633.65
AT&T
Service 4/10/11 - 5/9/11
2,337.06
AT & T
AT & T Long Distance 3/1/11- 3/31/11
887.00
Basic Fire Protection Inc.
Extinguisher Repair
79.55
Bedco Mechanical
2011 HVAC Maintenance
357.95
Bedco Mechanical
Building Maintenance HVAC Repairs
4,657.60
Beth Ellen Clem
Ballet Recital Camera Work
300.00
Burrell, Steve
Reimburse expenses
99.95
Busse's Flowers & Gifts
Floral Arrangement/ Ricker, Ruth
63.50
Busse's Flowers & Gifts
Memorial flowers
88.50
Cathleen A. McVeigh- Cushing
Edit of April Library Life
350.00
CDW Government, Inc.
Smartnet renewals
1,670.00
CDW Government, Inc.
DVI -D to DVI -I adapters
44.04
Century Cleaners
Uniform Cleaning
8.90
Century Cleaners
Uniform Cleaning
13.35
Century Cleaners
Uniform Cleaning
24.48
Century Cleaners
Uniform Cleaning
15.57
Century Cleaners
Uniform Cleaning
1335
Century Cleaners
Uniform Cleaning
22.25
Century Cleaners
Uniform Cleaning
24.48
Century Cleaners
Uniform Cleaning
8.90
Chicago Comm. Service, Inc.
Maintenance agreement May, June, July, 2011
1,923.30
Chicago Metro Chapter Apwa
Training
70.00
Chicago Metro Chapter Apwa
Training
170.00
Chicago Tribune
Chicago Tribune Subscription 4/22/11- 7/21/11
74.75
CL Graphics, Inc.
Spring Newsletter 2011 printing
9,813.00
CL Graphics, Inc.
Spring Newsletter 2011 mailing
350.00
Commonwealth Edison
Electrical Service Delivery
22.46
Commonwealth Edison
Electrical Service Delivery
21.97
Commonwealth Edison
Electrical Service Delivery
21.97
Cook County Recorder of Deeds
Replenish CCRD On Line Account
1,000.00
Costar Realty Information, Inc.
ED Site Software
454.58
DJ.'s Scuba Locker
Repaired Yellow Mustange Suit & Boots
50.00
David G. Eterno
Adjudication legal fees
375.00
Davidsmeyer Bus Service, Inc.
Transportation to Marriott - Mentor program
287.00
Deborah Dennison Leafblad
Ballet Recital Camera Work
300.00
DupageTopsoil Inc.
Semi Pulverized Topsoil Delivered
765.00
Dupage Topsoil Inc.
Semi Pulverized Topsoil Delivered
255.00
Edith Gomez
Refund Vehicle License #16444
36.00
Elizabeth A. Pope
4/14/11 Payroll Checks
923.08
Experian
Background checks - March, 2011
77.48
Fifth Third Bank
March /April Statement
447.00
Page 1 of 7
VILLAGE OF MOUNT PROSPECT
List of Bills
April 14 - April 27, 2011
Fund Vendor
Description
Amount
Fire Pension Fund
4/14/11 Payroll Checks
21,217.28
Foster Coach Sales Inc.
10" Trumpet
99.14
Frank Tolgyesi
Reimburse expenses
40.00
Gall's, Inc.
Flex cuffs
123.99
Garelli Wong & Associates, Inc.
Jasman Mahone 3/28/11- 4/1/11
826.50
Garvey's Office Products
Office Supplies
47.76
Gierman and Associates, Inc.
Bond fee for Notary Renewal - Carol Baldini
30.00
Gil Hebard Guns, Inc.
Ammunition
12,600.00
Grainger Inc.
Coat Rack, Single Holds 36 Garments
296.82
Grainger Inc.
Light Pole Banners
183.50
Heart Printing Inc.
Sympathy cards & envelopes
297.50
Henricksen & Company, Inc.
Maintenance and repair supplies
105.00
Henricksen & Company, Inc.
Building Maintenance
75.00
Homer Tree Care, Inc.
Parkway Tree Removal
1,288.00
Howard Elder
Flag Repair /Purchase
74.22
Howard Elder
Flag Repair /Purchase
472.97
ID Network, Inc.
Annual service maintenance for Palm Livescan System
10,047.00
Illinois American Water Company
Service 3/9/11- 4/11/11
271.12
Illinois Department of Revenue
4/14/11 Manual Check Andler
38.85
Illinois Fire Inspectors Association
Residential Fire Sprinkler Summit- W. Schroeder, 6/3/11
20.00
Illinois Municipal League
Subscription
15.00
Illinois State Police
Fingerprinting fees for Liquor Licenses
34.25
Illinois State Police
Background Check Parmar and Sprow
68.50
Illinois State Toll Hwy Authority
Indiana toll charges
7.06
Initial Tropical Plants Inc.
Annual Service /Maintenance
1,135.80
Inlander Brothers Inc
Custodial Supplies
339.66
Inlander Brothers Inc
Custodial Supplies
1,051.05
Inlander Brothers Inc
Custodial Supplies
196.06
Inlander Brothers Inc
Custodial Supplies
325.94
Inlander Brothers Inc
Custodial Supplies
42.61
Internal Revenue Service
4/14/11 Manual Check Andler
297.59
International Code Council, Inc.
Governmental Membership Dues for William Schroeder
225.00
International Union of Operating Engineers
4/14/11 Payroll Checks
471.75
International Union of Operating Engineers
4/14/11 Payroll Checks
1,051.15
Irvana Wilks
Mayors cellular bill
45.00
J.G. Uniforms, Inc.
Uniform supplies: R. LaBarbera
100.67
Jeffrey Schmitz
Reimburse expenses
38.25
John Dahlberg
Reimburse expenses
242.59
John Rivard
Clothing Allowance
150.00
Journal & Topics Newspapers
Newspaper Renewal
28.00
Journal & Topics Newspapers
Subscription 3/1/2011- 3/1/2012
28.00
Journal & Topics Newspapers
Subscription renewal
28.00
Journal & Topics Newspapers
Legal Notices for Planning & Zoning
126.96
Journal & Topics Newspapers
Legal Notices for Planning & Zoning
126.96
Journal & Topics Newspapers
Legal Notices for Planning & Zoning
138.00
Journal & Topics Newspapers
Legal Notices for Planning & Zoning
138.00
1QH- Normal Development, LLC.
Lodging for Training conference
352.80
JQH- Normal Development, LLC.
Lodging for Training conference
352.80
Judith Balazs
CDL Reimbursement
30.00
June Kerstein
Reimb March 2011 Food Exp & April 2011 Phone Bill
64.84
Kathleen W. Bono,csr,ltd.
court reporter liquor hearing
179.00
Kenneth Miller
Refund Overpayment vehicle License
24.00
Kim J Kidd
Refund Duplicate Vehicle License
36.00
Kone, Inc.
Elevator Maintenance
289.00
Kramer Tree Specialists
Grounds Maintenance
520.00
Kramer Tree Specialists
Grounds Maintenance
520.00
Kramer Tree Specialists
Grounds Maintenance
520.00
L & B Business Services Inc.
3 LITHXL -055F Lithium STD Battery
22.50
Lab Safety Supply
Rainsuit Pants for Employee "Go Kit"
69.05
Lab Safety Supply
Rainsuit Coat for Employee "Go Kit"
33.19
Lands' End Business Outfitters
Fleece Pullover for Employee "Go Kit"
43.95
Landscape Forms, Inc.
Street furniture and materials
1,884.60
Larry Heinrich
Clothing Allowance
150.00
Lechner and Sons
Uniform Rental & Cleaning
113.74
Lechner and Sons
Uniform Rental & Cleaning
113.74
Lexisnexis Risk Data Management Inc.
Background checks - March, 2011
104.75
login /iacp Net
Quarterly payment for IACP Net
275.00
Page 2 of 7
VILLAGE OF MOUNT PROSPECT
List of Bills
April 14 -April 27, 2011
Fund
Vendor
Description
Amount
Logsdon Stationers
Office Supplies
127.84
Margaret Evans
Reimburse Exp: Traffic Crash Investigation 1 & 2
309.00
Mark Weger
Reimburse training expenses
35.00
Mary Kay Tixier
Refund Vehicle License
36.00
Matt Lawrie
Clothing Allowance
137.65
McDonald's Corporation
Prisoner meals - March, 2011
296.80
Menards
Lobby Broom & Dust Pan
17.99
Menards
Plated Round Rods 6FT
13.92
Menards
Small Tools
27.52
Metro Federal Credit Union
4/14/11 Payroll Checks
2,357.40
Metropolitan Alliance - Police
4/14/11 Payroll Checks
1,190.50
Metropolitan Fire Chiefs Assoc
Registration/ Wisniewski Annual Symposium
40.00
Metropolitan Mayors Caucus
2011 Metropolitan Mayors Caucus Gala
200.00
Meyer Laboratory, Inc.
Custodial Supplies
(17.74)
Meyer Laboratory, Inc.
Custodial Supplies
84.27
Michael Meister
Reimburse expenses
79.00
Michael Wagner & Sons, Inc.
Maintenance and repair supplies
28.68
Mount Prospect Historical Soc.
2011 Budget Allocation - May 2011
3,333.33
Neenah Foundry Company
Tree Grates
(235.00)
Neenah Foundry Company
Tree Grates
6,264.28
Neopost USA Inc.
Postage Machine Replenishment - 04/15/11
3,000.00
Nextel Communications
[4] air cards
159.96
Nextel Communications
Wireless cards /service
239.94
Nick Licari
Clothing Allowance
150.00
Nite Lite Signs & Balloons Inc.
Equipment Rental
425.00
Northeastern III. Pub. Safety Trng.
Registration/ Redlin Tactics/ Strategy I April & May
400.00
Northeastern III. Pub. Safety Trng.
Training registration
450.00
Northern Illinois Emergency Management Consortium
Membership/ Malcolm 2011
30.00
Northern Illinois Police Alarm System
Language Line
43.00
Northshore University Healthsystem
Pre - employment testing
816.00
Northshore University Healthsystem
Pre - employment testing
17.00
Northwest Electrical Supply
Maintenance and repair supplies
37.97
Northwest Electrical Supply
Maintenance and repair supplies
140.14
Northwest Police Academy
Seminar registration
100.00
Northwest Suburban United Way
4/14/11 Payroll Checks
248.28
Old Town School of Folk Music
Deposit for Downtown Block Party Entertainment
750.00
Overhead Garage Door, Inc.
Building Maintenance
258.70
Pacific Telemanagement Services
Service 5/1/11 - 5/31/11
78.00
Paddock Publications, Inc.
Bid Notice
27.00
Paddock Publications, Inc.
Bid Notice
29.70
Paddock Publications, Inc.
Bid Notice
31.05
Paddock Publications, Inc.
Bid Notice
37.80
Petty Cash
Petty Cash 2011
82.10
Police Pension Fund
4/14/11 Payroll Checks
26,671.50
Powell Tree Care, Inc.
Stump Removal
9,126.40
Powell Tree Care, Inc.
Stump Removal
5,912.24
Powell Tree Care, Inc.
Stump Removal
3,016.77
Proforma Customized Graphics
Misc. Supplies
128.22
Reed Tyler
Refund Overpayment Police Ticket #P3907793
10.00
Richard Geerling
Refund Overpayment Vehicle License
24.00
Richard Reichart
Consultation/ Lambel
500.00
Robert Etchingham
Reimburse expenses fortraining
24.00
Robert M. Foss
Pencils
264.66
Sandra M. Clark
Reimbursement
15.43
Sandra M. Clark
Reimbursement
150.00
Schweizer Emblem Company
Insignia patches
225.00
Sound Incorporated
Monthly Fee for Telephone Support
828.83
Sound Incorporated
Maintenance Contract for Phone /Server Connections
72.00
Stanley Security Solutions, Inc.
Office Supplies
44.67
Staples Contract & Commercial, Inc.
Training supplies
29.99
Staples Contract & Commercial, Inc.
Office Supplies
17.49
Steve Olson
Re -issue Stale Dated Check #1856
35.00
Stevens & Associates, Inc.
Course registration for G. Sill
499.00
Sumitomo Electric Carbide
Refund Vehicle License
36.00
Symbolarts, LLC.
Uniform badges
1,940.00
Symbolarts, LLC.
Badges
280.00
T.P.I.
Building Inspections
13,032.00
Page 3 of 7
Fund
Tammie Shteyn
Third Millennium Assoc.inc.
Thomas A. Clinger
Thompson Elevator Inspections
Thompson Elevator Inspections
Thompson Elevator Inspections
Timothy Ryan
Tweedie, Bart
United Healthcare
United Healthcare
USA Bluebook
USA Bluebook
USA Mobility Wireless, Inc.
Village of Mount Prospect
Village of Mount Prospect
Village of Mount Prospect
Village of Mount Prospect
Village of Mount Prospect
Virginia Huber
Vision Internet Providers, Inc.
Von Briesen & Roper,s.c.
Warehouse Direct
Warehouse Direct
Warehouse Direct
Warehouse Direct
Warehouse Direct
West Publishing Corporation
Wide Open West
William J. Cooney
William W. Stenzel
W ISCTF
Worldpoint Ecc, Inc.
Total: 001- General Fund
002 - Debt Service Fund
Illinois EPA
Total: 002 - Debt Service Fund
Vendor
020 - Capital Improvement Fund
Active Transportation Alliance, NFP
Laurus Technologies, Inc.
New World Systems Corporation
New World Systems Corporation
Total: 020 - Capital Improvement Fund
021- Series 2009 Construction Fund
Advanced Communications, Inc.
Dell Marketing L.P.
Total: 021 - Series 2009 Construction Fund
022 - Downtown Redevelopment Construction Fund
Cook County Government
Total: 022 - Downtown Redevelopment Construction Fund
023 - Street Improvement Construction Fund
Christopher B. Burke Engineering Ltd
Desman, Inc.
Total: 023 - Street Improvement Construciton Fund
040 - Refuse Disposal Fund
ARC Disposal Company
AT &T
AT &T
Schaefer Systems International, Inc.
Standard Equipment Company
Total: 040 - Refuse Disposal Fund
VILLAGE OF MOUNT PROSPECT
List of Bills
April 14 - April 27, 2011
Mentor Program Supplies
2nd vehicle sticker mailing
Videotaped Retirement Party for Retirees
Elevator Inspections
Elevator Inspections
Elevator Inspections
Reimburse expenses
Reimburse training expenses
Administration Fees - February
Administration Fees - March
Engineering supplies
Engineering supplies
Pager rental /service
4/14/11 Payroll Checks
4/14/11 Payroll Checks
April Pension Payroll EFT's
April Penson Payroll Checks
Service 2/25/11 - 4/1/11
Refund Vehicle License
programming & graphic production
Professional Services 2/16/11 & 2/28/11
CLI Badge P/S Laser #92365
Office Supplies Tape, Envelopes, Scissors, Clock Other
Credit for Return 5392 Ave Refill Name Tags
Office Supplies
Office supplies
Subscription renewal
Internet service from WOW
Reimbursement
TSR data analysis
4/14/11 Payroll Checks
AED Course Completio Card, CPR Mask Trainer
L17- 0856/2011
Bike Plan - February Expenses
PF1 Server Replacement
ERP - Installation Services and Travel Time
ERP - Travel Expenses (CD Trip 2/28 -3/4)
A/V Systems for the EOC
Computer for the EOC
The Return of Surplus Incremental Revenues
Engineering Services
Parking Lot Improvements
Refuse Disposal Program
Service 4/10/11 - 5/9/11
AT & T Long Distance 3/1/11- 3/31/11
Recycling Carts
Sweeper Broom Replacement
Page 4 of 7
Amount
90.92
2,089.59
500.00
150.00
225.00
111.00
109.32
24.00
696.75
700.75
(7.95)
197.43
25.56
24,526.70
13,189.86
490.22
413.67
5.00
36.00
83.65
195.00
41.54
193.05
(26.80)
192.19
8.59
357.48
72.99
1,040.42
5,000.00
542.48
282.65
$ 237,897.98
$ 19,644.42
$ 19,644.42
$ 1,353.44
35,252.86
8,970.00
910.09
$ 46,486.39
$ 41,178.55
2,123.61
$ 43,302.16
$ 1,098,255.00
$ 1,098,255.00
$ 3,334.95
3,100.00
$ 6,434.95
$ 197,251.26
12.70
4.93
6,981.00
1,305.00
$ 205,554.89
VILLAGE OF MOUNT PROSPECT
List of Bills
April 14 - April 27, 2011
Fund Vendor
Description
Amount
041- Motor Fuel Tax Fund
Cook County Government
Traffic Signal Maintenance
$
2,740.50
Gewalt Hamilton Assoc.
Engineering Services
4,500.00
Gewalt Hamilton Assoc.
Pedestrian Signal Improvement Project
8,291.00
Commonwealth Edison
Electrical Service Delivery
13,976.40
Meade Electric Co. Inc.
2011 Traffic Signal Maintenance
1,976.00
V3 Companies
Engineering Services
4,500.00
Total: 041- Motor Fuel Tax Fund
$
35,983.90
050 - Water and Sewer Fund
1stAyd Corp.
Maintenance & Repair Supplies
$
920.29
Abbott Rubber Co., Inc.
Small Tools
30.00
Addison Building Material Co.
Maintenance & Repair Supplies
116.44
Addison Building Material Co.
Maintenance & Repair Supplies
7.47
Addison Building Material Co.
Wire Band 9/16 x 1- 1/16'; 3/4 Barb Poly Insert
3.36
Addison Building Material Co.
Maintenance & Repair Supplies
92.32
Addison Building Material Co.
Maintenance & Repair Supplies
87.52
Alexian Brothers Medical Center
DOT Drug/Acohol Screen
490.00
Alpha Terra Science Inc
Training
1,750.00
American Water Works Assoc.
Training Supplies
52.50
American Water Works Assoc.
Membership Renewal
75.00
American Waterworks Assoc.
Training
100.00
AT&T
Service 4/10/10 - 5/9/11
413.82
AT & T
Service 4/10/11 - 5/9/11
526.90
AT & T
Service 4/10/11 - 5/9/11
847.98
AT & T
AT & T Long Distance 3/1/11- 3/31/11
328.78
Badger Meter Inc
Connect Software Agreement
989.04
Bank of New York Mellon
JAWA - March 2011
323,777.00
Barnes Group
Hydrant Repair Supplies and Materials
260.93
Burns & Mcdonnell Engineering Co.
Professional Services
1,708.80
Burns & Mcdonnell Engineering Co.
Professional Services
2,275.00
Century Cleaners
Uniform Cleaning
8.90
Century Cleaners
Uniform Cleaning
13.35
Century Cleaners
Uniform Cleaning
24.47
Century Cleaners
Uniform Cleaning
15.58
Century Cleaners
Uniform Cleaning
13.35
Century Cleaners
Uniform Cleaning
22.25
Century Cleaners
Uniform Cleaning
24.47
Century Cleaners
Uniform Cleaning
8.90
Corrpro Companies, Inc.
Tank Design Engineering
4,200.00
DJK Contractors, Inc.
Equipment Maintenance and Repair
327.50
Exelon Corporation
Electrical Service Delivery
443.08
Exelon Corporation
Electrical Service Delivery
4,769.10
Federal Express Corp
Shipping Charges
75.74
Federal Express Corp
Shipping Charges
27.46
HBK Water Meter Service
Water Meter Install /Bldg Inspection /Meter Testing
119.00
HBK Water Meter Service
Water Meter Install /Bldg Inspection /Meter Testing
1,500.20
HBK Water Meter Service
Water Meter Install /Bldg Inspection /Meter Testing
1,945.20
Julie, Inc.
Annual Service Charge forJulie Locate Tickets
6,085.98
Lechner and Sons
Uniform Rental & Cleaning
113.75
Lechner and Sons
Uniform Rental & Cleaning
113.75
Leonard J Tomaszewski
Refund Final Water Bill #50301
10.95
Martam Construction
Excavation and removal of fire hydrant
2,200.00
Martam Construction
Contractual Hauling
2,810.40
Meyer Laboratory, Inc.
Custodial Supplies
(2.47)
Meyer Laboratory, Inc.
Custodial Supplies
11.73
National Power Rodding Corp.
Sewer Maintenance
3,500.00
Paddock Publications, Inc.
Bid Notice
78.30
Paddock Publications, Inc.
Bid Notice
60.75
Paddock Publications, Inc.
Bid Notice
98.55
Paddock Publications, Inc.
Bid Notice
86.40
Proforma Customized Graphics
Misc. Supplies
128.21
Redwood Apartment Partners
Refund Final Water Bill #920007
10.95
Shelby Mazursky
Open House Posters
195.00
Staples Contract & Commercial, Inc.
Office Supplies
118.10
Suburban Laboratories, Inc.
Annual [EPA- Required Water Sample Testing
124.50
Suburban Laboratories, Inc.
Annual IEPA- Required Water Sample Testing
192.75
Page 5 of 7
VILLAGE OF MOUNT PROSPECT
List of Bills
April 14 -April 27, 2011
Fund Vendor
Description
Amount
Tank Industry Consultants, Inc.
Professional Services
2,726.10
Tank Industry Consultants, Inc.
Professional Services
1,677.60
Third Millennium Assoc.inc.
March 2011 Utility Billing
1,228.19
Tnemec Co. Inc
Hydrant Supplies
159.31
Wachovia Mortgage
Refund Overpayment Water #559401
40.16
Total: 050 - Water and Sewer Fund
$
370,160.66
052 - Parking System Revenue Fund
Commonwealth Edison
Electrical Service Delivery
$
135.01
Commonwealth Edison
Electrical Service Delivery
381.46
Village of Mount Prospect
Service 2/28/11- 4/1/11
25.07
Total: 052 - Parking System Revenue Fund
$
541.54
Fund: 060 - Vehicle Maintenance Fund
American Public Works Assoc.
Training
$
175.00
Arlington Heights Ford
Rear brake pads
99.94
Arlington Heights Ford
Rear brake pads
49.97
Arlington Heights Ford
Oil cooler lines
227.47
Arlington Heights Ford
321 master window switch.
50.16
AT&T
Service 4/10/11 - 5/9/11
31.79
AT&T
AT & T Long Distance 3/1/11- 3/31/11
12.31
Barnes Group
Bolts
50.11
Busse Car Wash, Inc.
Car washes
1,072.50
Catching Fluidpower
Vehicle Maintenance Supplies
106.13
Certified Fleet Services, Inc.
Vehicle Maintenance Supplies
2,249.26
Certified Fleet Services, Inc.
Vehicle Maintenance Supplies
49.52
Hoskins Chevrolet, Inc.
Vehicle Maintenance Supplies
549.50
Hoskins Chevrolet, Inc.
P -5 door hinge kit
97.50
Interstate Battery
Vehicle Maintenance Supplies
539.70
Just Tires
Vehicle Maintenance Supplies
203.00
Just Tires
Vehicle Maintenance Supplies
1,218.00
Just Tires
Vehicle Maintenance Supplies
566.00
Mccann Industries, Inc.
Vehicle Maintenance Supplies
80.22
Municipal Fleet Managers Assoc
Registration Fee
75.00
Municipal Fleet Managers Assoc
Training
40.00
Napa - Heights Automotive Supply
Cabin filter for 2732
21.57
Napa - Heights Automotive Supply
530 rear work light bulbs
109.20
Napa - Heights Automotive Supply
Oil filters
34.24
Napa - Heights Automotive Supply
Fuel filters
41.04
Napa - Heights Automotive Supply
Oil filters & gaskets
155.88
Napa - Heights Automotive Supply
2732 fuel line connector
6.57
Napa - Heights Automotive Supply
Brake cleaner and lube
256.71
Napa - Heights Automotive Supply
6 qts oil
19.74
Napa- Heights Automotive Supply
A/C dye -R134
22.95
Overhead Material Handling II., Inc.
Equipment Maintenance
345.80
Pomp's Tire Service, Inc.
6 new International tires
2,643.06
Pomp's Tire Service, Inc.
Equipment Maintenance
30.00
Prairie International Truck Sales
2723 antenna
15.53
Precision Service & Parts
OEM Impala wiper blades
58.52
Precision Service & Parts
Vehicle Maintenance Supplies
106.24
Precision Service & Parts
2713 OEM oxygen sensor
38.00
Precision Service & Parts
Vehicle Maintenance Supplies
229.92
Precision Service & Parts
Vehicle Maintenance Supplies
43.40
Precision Service & Parts
Vehicle Maintenance Supplies
243.63
Precision Service & Parts
Vehicle Maintenance Supplies
557.10
Precision Service & Parts
Vehicle Maintenance Supplies
153.73
Rayco Sign Supply
Equipment Maintenance Supplies
89.50
Ronco Industrial Supply
Portable fuel tank pump
205.97
Solvent Systems Int'I. Inc.
Equipment
185.64
Terrace Supply Company
Helium gas purchase
94.30
Wholesale Direct Inc.
Tools
37.48
Wholesale Direct Inc.
Vehicle Maintenance Supplies
94.85
Zeigler Chevrolet - Schaumburg LLC
Vehicle Maintenance Supplies
48.75
Total: 060 - Vehicle Maintenance Fund
$
13,432.40
061- Vehicle Replacement Fund
EJ Equipment
New Vehicles
$
10,682.80
Page 6 of 7
VILLAGE OF MOUNT PROSPECT
List of Bills
April 14 -April 27, 2011
Fund Vendor
Lindco Equipment Sales, Inc.
Total: 061- Vehicle Replacement Fund
062 - Computer Replacement Fund
Dell Marketing L.P.
Laurus Technologies, Inc.
Total: 062 - Computer Replacement Fund
063 - Risk Management Fund
Gab Robins N.a., Inc. - Citibank
Graybar Electric Co.
Graybar Electric Co.
Intergovernmental Per.ben.coop
Parkside Auto Body Inc
State Farm Mutual Automobile Insurance Company
Total: 063 - Risk Management Fund
070 - Police Pension Fund
Village of Mount Prospect
Village of Mount Prospect
Total: 070 - Police Pension Fund
071- Fire Pension Fund
Capital Gains Inc.
Village of Mount Prospect
Village of Mount Prospect
Total: 071- Fire Pension Fund
072 - Flexcomp Escrow Fund
Guardian
Total: 072 - Flexcomp Escrow Fund
073 - Escrow Deposit Fund
Brian Dirsmith
Duane Blanton Plumbing Sewer & Drainage Inc
Flush Sewer & Drainage Inc
Flush Sewer & Drainage Inc
Frank W Whitecotton
Hansen's Landscaping
Ibbotson Heating Co
J & 5 Plumbing Inc
JNL Climate Control Inc
Kirk Sneeden
Luis & Olga Garay
Matthew Savard
Mount Prospect Public Library
MT Prospect Heating & A/C Co Inc
Plumb -Rite PLMG Sewer & Drain Inc
Plumg -Rite PLMG Sewer & Drain Inc
Ruth L Cram
Steve Haynes
Third District Circuit Court
Third District Circuit Court
Third District Circuit Court
Third District Circuit Court
TJM Sewer
Wayne Gordon
Total: 073 - Escrow Deposit Fund
Grand Total:
Description
$
Amount
New Vehicles
$
485.19
Refund Escrow Permit # 11 -0235
$
11,167.99
Replacement Websense Server
$
4,017.88
PF1 Server Replacement
5,936.01
Refund Escrow Permit # 11 -0313
$
9,953.89
Liability Claims - April
$
16,222.05
Streetlight Knockdown - Report 11 -02167
194.44
Credit
(4.44)
IPBC - April 2011
462,578.97
Repair #T -40
695.60
Auto Liability Claim #13 -E19 -402
2,425.39
$ 482,112.01
April Pension Payroll ETF's $ 34,423.84
April Police Pension Payroll 17,033.88
$ 51,457.72
Investment Management Services $ 2,159.00
April Pension Payroll ETF's 34,728.65
April Fire Pension Payroll 11,083.59
$ 47,971.24
Emp Dental Plan May 2011
$
7,947.91
$
7,947.91
Refund Escrow Permit # 11 -0235
$
125.00
Refund Escrow Permit # 10 -2821
125.00
Refund Escrow Permit # 11 -0331
125.00
Refund Escrow Permit # 11 -0313
75.00
Refund Escrow Permit # 11 -0024
150.00
Refund Escrow Permit # 09 -2110
150.00
Refund Escrow Permit# 11 -0359
125.00
Refund escrow Permit # 10 -2919
125.00
Refund Escrow Permit# 10 -2888
75.00
Refund Escrow Permit# 10 -1607
325.00
Refund Escrow Permit# 11 -0343
125.00
Refund Escrow Permit# 11 -0194
125.00
PPRT 3Rd Allocation of 2011
9,960.98
Refund Escrow Permit# 11 -0298
25.00
Refund Escrow Permit# 11 -0318
125.00
Refund Escrow Permit# 10 -2820
125.00
Refund Escrow Permit # 11 -0329
75.00
Refund Escrow Permit # 10 -2652
200.00
Bond Check 4/14/11
1,400.00
Bond Check 4/19/11
1,470.00
Bond Check 4/21/11
1,110.00
Bond Check 4/26/11
5,520.00
Refund Escrow Permit # 11 -0324
125.00
Refund Escrow Permit # 10 -0916
800.00
$ 22,585.98
Page 7 of 7
$ 2,710,891.03