HomeMy WebLinkAbout3. Monthly Financial Report & Approve Bills 06/16/2015Village of Mount Prospect
Mount Prospect, Illinois
INTEROFFICE MEMORANDUM
TO: VILLAGE PRESIDENT AND BOARD OF TRUSTEES
FINANCE COMMISSION
FROM: FINANCE DIRECTOR
DATE: JUNE 12, 2015
SUBJECT: MONTHLY FINANCIAL REPORT — MAY 2015
Attached hereto are the cash position and investment statements of the Village for the month
ended May 31, 2015. 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 April 30 was $45.4
million. During May, cash receipts totaled $4,605,281. In addition investment income for the
month was $1,453 and interfund activity totaled $48,754. Reductions to cash and cash
equivalents during May totaled $6,334,245. Of this amount, payments to vendors were
$5,051,372 and employee payroll and related expenses were $1,273,715. Other disbursement
totaled $9,158. Cash and cash equivalents at May 31 were $43.8 million.
Monthly Financial Report — May 2015
June 12, 2015
Page 2
Investments in the Governmental and Enterprise Funds at May 31 were $6.1 million. There was
no investment activity during the month of May.
Total cash and investments for Governmental and Enterprise Funds at April 30 were
$51,569,603. Cash and investments at May 31 totaled $49,890,846. This was a decrease of
$1,678,757 for the month.
Trust and Agency Funds - Cash and cash equivalents at April 30 was $4.3 million. During
May, cash receipts totaled $204,389. In addition investment income was $136,966. There was
a net decrease in cash due to investment activities of $308,542. Reductions to cash and cash
equivalents during May totaled $832,880. Of this amount, payments to vendors were $196,834,
employee payroll and related expenses were $610.429, and payments related to the flexible
spending program totaled $25,617. Checks voided during the month totaled $33,908. Cash
and cash equivalents at May 31 were $3.4 million.
Total investments at May 31 were $115,811,684, an increase of $558,839 from April 30.
Investment income was $250,297 with a net transfer in from investment activities totaling
$308,542 accounted for the change.
Total cash and investments for Trust and Agency Funds at April 30 were $119,506,701. Cash
and investments at May 31 totaled $119,250,626. This is a decrease of $256,075 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. Activity for the General Fund is highlighted below.
General Fund — Cash and cash equivalents at April 30 totaled $10,863,414. During May, cash
receipts totaled $2,628,639 and investment income was $229. Significant cash receipts
included sales and income taxes.
Sales tax revenues for the month totaled $1,089,992. Of this amount, $1,007,698 was
generated from the 1% state portion while $82,294 was generated from the .25% home rule
portion. Sales taxes received in May are for February sales as there is a three-month lag in
getting this distribution from the state. May 2015 receipts were 14.2% above the prior year.
Monthly Financial Report — May 2015
June 12, 2015
Page 3
State income tax receipts for May totaling $287,201 was for March. May 2015 receipts are
4.8% below the prior year. The state continues to be 2-3 months delinquent in making these
remittances to the Village. The state is currently $1.3 million (2 months) in arrears in
remitting income taxes to the Village.
Disbursements from the General Fund for May included payments to vendors of $1,103,863,
payments for employee wages and benefits of $1,121,116 and other adjustments totaled
$10,041. Interfund transfers of $658,653 for health premiums and vehicle lease and
maintenance payments were also made during the month.
Cash and cash equivalents at May 31 were $10,598,609. There were no investments in the
General Fund at May 31.
Statement of Investments (page 3)
This report provides a breakdown of investments by trust and agency funds and governmental
and enterprise funds. The report also provides a fund -by -fund breakdown of the investments.
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,
Galliard, Segall Bryant and Mesirow Financial. Segall Bryant holds approximately half of the
fixed income investments for the two pension funds while Galliard 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 funds also
invest a small amount in international stocks. Each year the investment mix is evaluated for
optimal diversification to meet pension fund investment policy goals and objectives. Equity
investments held by the Police Pension Fund are managed by Sawyer Falduto Asset
Management. Below is a breakdown of how the pension fund portfolios are invested.
Maturity Purchase Financial
Date Date Institution
POLICE PENSION FUND (070)
Various Various Wells Fargo
Various Various Various
FIRE PENSION FUND (071)
Various Various Wells Fargo
Various Various Various
TOTAL TRUST AND AGENCY FUND INVESTMENTS
Investment
CUSIP/
Interest
Market
Description
Acct 9
Rate %
Value
Wells Fargo Investments
Various
Various
$ 23,602,933.95
Mutual Fund Investments
Various
Various
35,635,902.42
59,238,836.37
Wells Fargo Investments Various Various 20,303,631.51
Mutual Fund Investments Various Various 36,269,216.59
56,572,848.10
$ 115,811,684.47
Monthly Financial Report — May 2015
June 12, 2015
Page 4
Investment of the Village's pension funds is governed by an Investment Policy adopted by each
Pension Board.
Government and Enterprise Funds - Investments for the governmental and agency funds are
typically made up of Certificates of Deposit. At May 31 there was a total of $6.1 million invested
in CD's. These CD's are investing proceeds of the 2013 flood control bond issue. Other
surplus funds in the governmental and enterprise funds have been placed in interest bearing
money market accounts.
Maturity
Purchase
Financial
Investment
CUSIP/
Date
Date
Institution
Description
FDIC /I
Net Yield
Parch Price
FLOOD CONTROL CONSTRUCTION FUND -f6241
06/15/15
01/05/15
Landmark Community Bank, TN
Certificate of Deposit
34982
0.123%
249,800.00
06/15/15
01/05/15
Farmers St Bank Waterloo, IA
Certificate of Deposit
12855
0.123%
249,800.00
06/15/15
01/05/15
Corner Stone Bank, MO
Certificate of Deposit
9388
0.120%
249,000.00
06/15/15
01/05/15
Texas Capital Bank, TX
Certificate of Deposit
34383
0.120%
249,800.00
06/15/15
01/05/15
The First, NA, ME
Certificate of Deposit
4256
0.124%
249,800.00
06/15/15
01/05/15
Banco Popular North America, IL
Certificate of Deposit
34967
0.120%
82,800.00
06/15/15
01/05/15
Banco Popular North America, IL
Certificate of Deposit
34967
0.120%
84,000.00
06/15/15
01/05/15
Banco Popular North America, IL
Certificate of Deposit
34967
0.120%
83,000.00
06/15/15
01/05/15
West Alliance/Torrey Pines, CA
Certificate of Deposit
57512
0.120%
249,800.00
07/08/15
01/09/15
0.3% - Bank of India CD
Certificate of Deposit
06278CJ89
0.253%
249,057.30
07/13/15
01/13/15
0.4% - Bank of Baroda CD
Certificate of Deposit
06062AB81
0.201%
249,246.06
07/15/15
01/05/15
Bank of China, NY
Certificate of Deposit
33653
0.216%
249,700.00
07/15/15
01/05/15
Bridgewater Bank, MN
Certificate of Deposit
58210
0.216%
249,700.00
07/15/15
01/05/15
Foothills Bank & Trust, TN
Certificate of Deposit
58591
0.203%
249,500.00
07/15/15
01/05/15
Modern Bank Nat'l Assoc, NY
Certificate of Deposit
22398
0.203%
249,500.00
07/15/15
01/05/15
Seaside Nat'l Bank & Trust, FL
Certificate of Deposit
58328
0.210%
249,500.00
08/17/15
01/05/15
ONB Bank and Trust Co, OK
Certificate of Deposit
35348
0.209%
249,400.00
08/17/15
01/05/15
Bank Leumi USA, NY
Certificate of Deposit
19842
0.200%
249,400.00
08/17/15
01/05/15
Orrstown Bank, PA
Certificate of Deposit
713
0.200%
249,400.00
08/17/15
01/05/15
Private Bank- MI, MI
Certificate of Deposit
224
0.206%
249,400.00
09/15/15
01/05/15
Bank of the Ozarks, AR
Certificate of Deposit
110
0.262%
249,500.00
09/15/15
01/05/15
Onewest Bank, NA, CA
Certificate of Deposit
58978
0.310%
249,400.00
09/15/15
01/05/15
CDB Bank -NY,NY
Certificate of Deposit
19977
0.243%
249,200.00
09/15/15
01/05/15
Enerbank USA, UT
Certificate of Deposit
57293
0.250%
249,300.00
10/15/15
01/05/15
United Texas Bank, TX
Certificate of Deposit
26626
0.343%
249,300.00
10/15/15
01/05/15
Affiliated Bank. TX
Certificate of Deposit
34885
0.343%
249,300.00
10/15/15
01/05/15
Royal Business Bank, CA
Certificate of Deposit
58816
0.303%
150,000.00
6,137,603.36
TOTAL GOVERNMENTAL AND ENTERPRISE FUNDS
$ 6,137,603.36
Conclusion
As mentioned earlier, this cash position report is intended to provide a snapshot of the Village's
cash position as of a particular month end date. This report has been able to provide trend
information helping in cash management duties, maximizing investment earnings while ensuring
availability of funds to meet the Village's commitments. The cash position report will continue to
be provided to the Village Board and Finance Commission on a monthly basis.
David O. Erb
Finance Director
VILLAGE OF MOUNT PROSPECT
Preliminary Cash and Investment Position Report - All Funds
For the Month Ended May 31, 2015
GOVERNMENTAL AND ENTERPRISE FUNDS
Balance at April 30, 2015
Cash receipts
Investment income
Transfers from investments to cash
Transfers to investments from cash
Interfund activity
Disbursements:
Accounts payable
Payroll
Other
Balance at May 31, 2015
Cash and Cash Total Cash and
Equivalents Investments Investments
$ 45,431,999.36 $ 6,137,603.36 $ 51,569,602.72
4,605,281.29 4,605,281.29
1,453.03 1,453.03
48,754.01 48,754.01
(5, 051, 372.13) (5, 051, 372.13)
(1,273,714.96) (1,273,714.96)
(9,158.23) (9,158.23)
$ 43,.753,242.37 $ 6,137,603.36 $ 49,890,845.73
TRUST AND AGENCY FUNDS *
Cash and Cash Total Cash and
Equivalents Investments Investments
Balance at April 30, 2015 $ 4,253,856.11 $ 115,252,844.75 $ 119,506,700.86
Cash receipts
204,388.69
Investment income (loss)
136,966.02 250,296.91
Transfers from investments to cash
2,604,620.85 (2,604,620.85)
Transfers to investments from cash
(2,913,163.66) 2,913,163.66
Interfund activity
(48,754.01)
Disbursements:
Accounts payable
Payroll
Flex spending
Other
Balance at May 31, 2015
(196,833.99)
(610,429.01)
(25,616.79)
33,907.55
204,388.69
387,262.93
(48,754.01)
(196,833.99)
(610,429.01)
(25,616.79)
33, 907.55
$ 3,438,941.76 $ 115,811„684.47 $ 119,250,626.23
* Assets are restricted in purpose and do not represent discretionary assets of the government.
1
F-
U U
W
a
U)
O
w
DL
z
z
O
LL
O
W
J
J
i
r- co U) WCC7 O N (d& 1
Y 69O W NOen rr(n
J,.. )c00 d'CNO 'r o
Id- LO w ro cm v In <t 00 c
~ ®i dm (D cqr cv (v
(~pr Nm((00 L
NN
O c) Ci Lo Ci I co o'
OIC F'W0 (3LLq M. h C
z < z O� M N, M
L W Q
r zU..
r
z O a
W
Q r M Co Lo (O m O r Ql C
QZ LU CD 00 NCMO Ma Nr
F- Q U O M W (Q C\ (DCt) LU
J jj75 MO CO d°M0 ON C
Z) W' O z 'rr 0(0O S (D I C
W LLJa. (1 CV c
ii
W
(Da)M
r -m
eo m''.
r
5(n
Fe
MCV O
m co'
ONMr
d' W
" V CV
r
C
On v�
67 W LO
mN�
LO
r-
r M
c
O W
mom
Via'
u
z
rre0
FJ�j
<r eo
No
r
W LL
(n 'T
O
`g
`
F0
Z
d
GF,
Q
NWo
Wwry"
a
Jz.
<D
+
—CO d'
co
M (V
aOLLO
r
zLL
0)mIT
Mvin
N
OW
u
W
U
M N
m
h
¢W-
z >I
O'
q
(n
W,
W
co
M m
m
I
Cn
10
e
M d'
nv0
LO
a, LO
�n
mco(ry
C,
d
Cli
LU z
LO N
CDN
C
O
zLLLO
W
W d v
cn
a
co
M m
er
a
HOd
�(Q�
(0
a
O_
a O J
CMO m
M
IX
U W L',
M
h
CL
r
r
Cfl
W
tr N N
M'
U
(-i m r`
o
a
(n
p
� N
m
a
W
zLL
Lb
114-m
r
0
ca[
W
p
61�
M r d`
W O
Qi
C,
N O CO
m
r'- O
10 r
CC
Q? C/)
o N
LOO
O m
U Z p,
UOS
W W Z
0 0
N
m N
(ac
U) w LL'�-'
V
d
Cr.
I
�
mr`N
wo
(m®
cr
ci000i
' N®
" Loc']
a
®p
MN
d' (O N
W IT
n9 O
rO
4-_ W
c
CL
a
M 00
WO
co
cc
q✓
(0 N
LO r
L O
a
z
O N
c
Wv
(7
(F}
O1 N
N c
z CN
W n N C1
J C N N
N
CF m ai E c2 U
W L IE'c_ o- nm
= m C N rn N N U
l6 vn C p C C C C
Q 9 n y, _ o
UGL)aci aQ)i0Ei(D(U jo
�.�
N O N N N N y m t�q w
UmU.S c0000 ul
mov, oI 0' w,
m Lo a) r`
(00 L(00 cam- (W.r �
r° ro Ui ai
M 00
m w
cy
.- as
to CO r r of
-t r` r w
m
v,
N
W
PSD
In
69
d0- O V n
co 00 m
Iq
co L r
00
OS O W O
r �
m
COO (00 W
r ml
ro
co to a)
0
a n
tD
N
W
d'
CN
N
(D
N
m (o to
Cl) M to
0 0 w
co (o j
� m
O
Ca (O (3
4A
O
M
T
0
m
(o i
P
(19
J
N
O s
CO I
N 1
7
vi
i
O' Z
Ln i
O I
O
a)
U7
O
I
f9- Z
F 1
z
W
L
N m ;
! 1
STATEMENT OF INVESTMENTS
As of May 31, 2015
Maturity Purchase Financial
Date Date Institution
1 11 1 1# 1 t1 1 1 1
06/15/15
01/05/15
Landmark Community Bank, TN
06/15/15
01/05/15
Farmers St Bank Waterloo, [A
06/15/15
01/05/15
Comer Stone Bank, MO
06/15/15
01/05/15
Texas Capital Bank, TX
06/15/15
01/05/15
The First, NA, ME
06/15/15
01/05/15
Banco Popular North America, M
06/15/15
01/05/15
Banco Popular North America, IL
06/15/15
01/05/15
Banco Popular North America, IL
06/15/15
01/05/15
West Alliance/Torrey Pines, CA
07/08/15
01/09/15
0.3% - Bank of India CD
07/13/15
01/13/15
04% - Bank of Baroda CD
07/15/15
01/05/15
Bank of China, NY
07/15/15
01/05/15
Bridgewater Bank, MN
07/15/15
01/05/15
Foothills Bank & Trust, TN
07/15/15
01/05/15
Modem Bank Nat'l Assoc, NY
07/15/15
01/05/15
Seaside Nat'l Bank & Trust, FL
08/17/15
01/05/15
ONB Bank and Trust Co, OK
08/17/15
01/05/15
Bank Leumi USA, NY
08/17/15
01/05/15
Orrstown Bank, PA
08/17/15
01/05/15
Private Bank - MI, MI
09/15/15
01/05/15
Bank of the Ozarks, AR
09/15/15
01/05/15
Onewest Bank, NA, CA
09/15/15
01/05/15
IDB Bank - NY, NY
09/15/15
01/05/15
Enerbank USA, UT
10/15/15
01/05/15
United Texas Bank, TX
10/15/15
01/05/15
Affiliated Bank. TX
10/15/15
01/05/15
Royal Business Bank, CA
Maturity Purchase Financial
Date Date Institution
POLICE PENSION FUND (0701
Various Various Wells Fargo
Various Various Various
FIRE PENSION FUND (071)
Various Various Wells Fargo
Various Various Various
Investment
CUSIP/
Acct #
Rate %
Description
FDIC #
Net Yield
Purch Price
Certificate of Deposit
34982
0.123%
249,800.00
Certificate of Deposit
12855
0123%
249,800.00
Certificate of Deposit
9388
0.120%
249,000.00
Certificate of Deposit
34383
0,120%
249,800.00
Certificate of deposit
4256
0.124%
249,800.00
Certificate of Deposit
34967
0.120%
82,800.00
Certificate of Deposit
34967
0.120%
84,000.00
Certificate of Deposit
34967
0,120%
83,000.00
Certificate of Deposit
57512
0.120%
249,800,00
Certificate of Deposit
06278CJ89
0.253%
249,057.30
Certificate of Deposit
06062AB81
0.201%
249,246.06
Certificate of Deposit
33653
0.216%
249,700.00
Certificate of Deposit
58210
0.216%
249,700.00
Certificate of Deposit
58591
0.203%
249,500.00
Certificate of Deposit
22398
0.203%
249,500.00
Certificate of Deposit
58328
0„210%
249,500.00
Certificate of Deposit
35348
0.209%
249,400.00
Certificate of Deposit
19842
0.200%
249,400.00
Certificate of Deposit
713
0.200%
249,400.00
Certificate of Deposit
224
0.206%
249,400.00
Certificate of Deposit
110
0.262%
249,500„00
Certificate of Deposit
58978
0.310%
249,400.00
Certificate of Deposit
19977
0,243%
249,200.00
Certificate of Deposit
57293
0.250%
249,300.00
Certificate of Deposit
26626
0.343%
249,300.00
Certificate of Deposit
34885
0.343%
249,300.00
Certificate of Deposit
58816
0.303%
150,000.00
TRUST AND AGENCY FUNDS *
Investment
Description
Wells Fargo Investments
Mutual Fund Investments
Wells Fargo Investments
Mutual Fund Investments
* Assets are restricted in purpose and do not represent discretionary assets of the government.
CUSIP/
Interest
Acct #
Rate %
Various
Various
Various
Various
Various Various
Various Various
6,137,603.36
$ 6,137,603.36
Market
Value
$ 23,602,933.95
35,635,902.42
59,238,836.37
20,303,631.51
36,269,216.59
56,572,848.10
$ 115,811,684.47
1
Revenue Budget
by Account
Classification
Report
Through 05/31/15
Prior Fiscal
Year Activity Included
Summary Listing
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD % used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions Rec'd Prior Year YTD
Fund 001 - General Fund
REVENUE
Property Taxes
15,427,500.00
.00
15,427,500.00
38,931.16
.00
7,828,567.15
7,598,932.85 51 7,405,136.89
Other Taxes
7,457,566.00
.00
7,457,566.00
734,668.28
.00
2,209,107.49
5,248,458.51 30 2,202,510.74
Licenses, Permits & Fees
1,256,000.00
.00
1,256,000.00
99,217.50
.00
622,153.74
633,846.26 50 879,866.23
Intergovernmental Revenue
20,123,200.00
2,404.00
20,125,604.00
1,505,191.50
.00
4,155,403.40
15,970,200.60 21 3,792,434.95
Charges For Services
1,633,223.00
.00
1,633,223.00
145,136.05
.00
615,604.58
1,017,618.42 38 567,925.87
Fines & Forfeits
439,000.00
.00
439,000.00
44,677.53
.00
182,976.54
256,023.46 42 157,590.06
Investment Income
5,918.00
.00
5,918.00
2,570.63
.00
5,289.29
628.71 89 2,074.68
Reimbursements
220,000.00
.00
220,000.00
24,328.71
.00
84,223.06
135,776.94 38 223,258.79
Other Revenue
236,000.00
.00
236,000.00
16,882.59
.00
133,071.37
102,928.63 56 129,487.06
Other Financing Sources
20,000.00
.00
20,000.00
.00
.00
20,000.00
.00 100 .00
REVENUE TOTALS $46,818,407.00
$2,404.00
$46,820,811.00
$2,611,603.95
$0.00
$15,856,396.62
$30,964,414.38 34% $15,360,285.27
Fund 001 - General Fund Totals $46,818,407.00
$2,404.00
$46,820,811.00
$2,611,603.95
$0.00
$15,856,396.62
$30,964,414.38 $15,360,285.27
1
2
Revenue Budget
by Account
Classification
Report
Through 05/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD % used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions Rec'd Prior Year YTD
Fund 002 - Debt Service Fund
REVENUE
Property Taxes
2,254,000.00
.00
2,254,000.00
11,301.49
.00
1,141,748.98
1,112,251.02 51 1,148,492.33
Other Taxes
988,508.00
.00
988,508.00
60,459.28
.00
128,127.70
860,380.30 13 132,668.88
Intergovernmental Revenue
42,773.00
1,568,856.00
1,611,629.00
21,782.35
.00
228,710.35
1,382,918.65 14 21,927.64
Investment Income
100.00
.00
100.00
24.16
.00
39.48
60.52 39 26.48
Other Revenue
.00
.00
.00
.00
.00
.00
.00 +++ .00
Other Financing Sources
.00
.00
.00
.00
.00
.00
.00 +++ 3,231.19
REVENUE TOTALS
$3,285,381.00
$1,568,856.00
$4,854,237.00
$93,567.28
$0.00
$1,498,626.51
$3,355,610.49 31% $1,306,346.52
Fund 002 - Debt Service Fund Totals
$3,285,381.00
$1,568,856.00
$4,854,237.00
$93,567.28
$0.00
$1,498,626.51
$3,355,610.49 $1,306,346.52
2
3
Revenue Budget
by Account
Classification
Report
Through 05/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD % used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions Rec'd Prior Year YTD
Fund 020 - Capital Improvement Fund
REVENUE
Other Taxes
1,246,000.00
.00
1,246,000.00
76,180.19
.00
161,444.07
1,084,555.93 13 156,460.39
Intergovernmental Revenue
.00
.00
.00
.00
.00
47,273.72
(47,273.72) +++ .00
Investment Income
1,000.00
.00
1,000.00
30.93
.00
125.25
874.75 13 258.41
Reimbursements
.00
.00
.00
.00
.00
.00
.00 +++ .00
Other Revenue
20,000.00
.00
20,000.00
.00
.00
22,000.00
(2,000.00) 110 89,970.00
Other Financing Sources
.00
.00
.00
.00
.00
.00
.00 +++ .00
REVENUE TOTALS
$1,267,000.00
$0.00
$1,267,000.00
$76,211.12
$0.00
$230,843.04
$1,036,156.96 18% $246,688.80
Fund 020 - Capital Improvement Fund Totals
$1,267,000.00
$0.00
$1,267,000.00
$76,211.12
$0.00
$230,843.04
$1,036,156.96 $246,688.80
3
Revenue Budget by Account Classification
Report
Through 05/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Fund 022 - Downtown Redevelopment Construct
REVENUE
Property Taxes
2,709,000.00
.00
2,709,000.00
8,190.19
.00
1,252,518.99
1,456,481.01
46
1,252,091.23
Investment Income
500.00
.00
500.00
33.90
.00
66.42
433.58
13
162.12
Reimbursements
.00
.00
.00
.00
.00
.00
.00
+++
.00
Other Revenue
.00
.00
.00
.00
.00
.00
.00
+++
.00
Other Financing Sources
.00
.00
.00
.00
.00
.00
.00
+++
.00
REVENUE TOTALS
$2,709,500.00
$0.00
$2,709,500.00
$8,224.09
$0.00
$1,252,585.41
$1,456,914.59
46%
$1,252,253.35
Fund 022 -Downtown Redevelopment Construct Tote,
$2,709,500.00
$0.00
$2,709,500.00
$8,224.09
$0.00
$1,252,585.41
$1,456,914.59
$1,252,253.35
W
5
Revenue Budget
by Account
Classification
Report
Through 05/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD % used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions Rec'd Prior Year YTD
Fund 023 - Street Improvement Construc Fund
REVENUE
Other Taxes
2,056,000.00
.00
2,056,000.00
137,291.37
.00
396,606.69
1,659,393.31 19 404,786.20
Licenses, Permits & Fees
1,540,000.00
.00
1,540,000.00
109,975.50
.00
1,309,421.50
230,578.50 85 903,293.25
Intergovernmental Revenue
.00
.00
.00
.00
.00
.00
.00 +++ .00
Fines & Forfeits
.00
.00
.00
.00
.00
.00
.00 +++ .00
Investment Income
100.00
.00
100.00
135.82
.00
624.18
(524.18) 624 2,549.72
Reimbursements
.00
.00
.00
.00
.00
.00
.00 +++ .00
Other Revenue
6,000.00
.00
6,000.00
18,686.20
.00
27,630.12
(21,630.12) 461 28,395.48
Other Financing Sources
.00
.00
.00
.00
.00
.00
.00 +++ 6,540,700.82
REVENUE TOTALS
$3,602,100.00
$0.00
$3,602,100.00
$266,088.89
$0.00
$1,734,282.49
$1,867,817.51 48% $7,879,725.47
Fund 023 - Street Improvement Construc Fund Totals
$3,602,100.00
$0.00
$3,602,100.00
$266,088.89
$0.00
$1,734,282.49
$1,867,817.51 $7,879,725.47
5
s
Revenue Budget
by Account
Classification
Report
Through 05/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD % used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions Rec'd Prior Year YTD
Fund 024 - Flood Control Construction Fund
REVENUE
Other Taxes
357,000.00
.00
357,000.00
21,834.89
.00
46,273.36
310,726.64 13 36,348.54
Intergovernmental Revenue
.00
.00
.00
.00
.00
.00
.00 +++ .00
Charges For Services
.00
.00
.00
.00
.00
.00
.00 +++ .00
Investment Income
1,100.00
.00
1,100.00
1,351.02
.00
6,397.41
(5,297.41) 582 5,377.09
Reimbursements
.00
.00
.00
.00
.00
.00
.00 +++ .00
Other Financing Sources
.00
.00
.00
.00
.00
.00
.00 +++ .00
REVENUE TOTALS
$358,100.00
$0.00
$358,100.00
$23,185.91
$0.00
$52,670.77
$305,429.23 15% $41,725.63
Fund 024 - Flood Control Construction Fund Totals
$358,100.00
$0.00
$358,100.00
$23,185.91
$0.00
$52,670.77
$305,429.23 $41,725.63
s
7
Revenue Budget
by Account
Classification
Report
Through 05/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD % used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions Rec'd Prior Year YTD
Fund 040 - Refuse Disposal Fund
REVENUE
Property Taxes
.00
.00
.00
.00
.00
.00
.00 +++ 176,176.34
Charges For Services
3,549,000.00
.00
3,549,000.00
237,888.13
.00
1,356,497.54
2,192,502.46 38 1,125,772.56
Fines & Forfeits
24,000.00
.00
24,000.00
1,875.24
.00
15,261.37
8,738.63 64 11,162.33
Investment Income
500.00
.00
500.00
12.24
.00
73.99
426.01 15 332.02
Reimbursements
1,000.00
.00
1,000.00
1,074.00
.00
2,369.52
(1,369.52) 237 .00
Other Revenue
371,500.00
.00
371,500.00
77,284.09
.00
143,762.97
227,737.03 39 122,829.02
REVENUE TOTALS
$3,946,000.00
$0.00
$3,946,000.00
$318,133.70
$0.00
$1,517,965.39
$2,428,034.61 38% $1,436,272.27
Fund 040 - Refuse Disposal Fund Totals
$3,946,000.00
$0.00
$3,946,000.00
$318,133.70
$0.00
$1,517,965.39
$2,428,034.61 $1,436,272.27
7
Revenue Budget
by Account
Classification
Report
Through 05/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD % used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions Rec'd Prior Year YTD
Fund 041 - Motor Fuel Tax Fund
REVENUE
Intergovernmental Revenue
1,320,000.00
.00
1,320,000.00
125,981.35
.00
401,408.97
918,591.03 30 660,142.51
Investment Income
200.00
.00
200.00
19.29
.00
79.18
120.82 40 9.48
Reimbursements
11,000.00
.00
11,000.00
1,219.80
.00
4,508.63
6,491.37 41 6,870.77
REVENUE TOTALS
$1,331,200.00
$0.00
$1,331,200.00
$127,220.44
$0.00
$405,996.78
$925,203.22 30% $667,022.76
Fund 041 - Motor Fuel Tax Fund Totals
$1,331,200.00
$0.00
$1,331,200.00
$127,220.44
$0.00
$405,996.78
$925,203.22 $667,022.76
Revenue Budget by Account Classification
Report
Through 05/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Fund 042 - Cmmty Development Block Grant
REVENUE
Intergovernmental Revenue
339,264.00
.00
339,264.00
.00
.00
.00
339,264.00 0
.00
Investment Income
.00
.00
.00
.00
.00
.00
.00 +++
.00
Other Revenue
80,000.00
.00
80,000.00
12,785.50
.00
37,390.50
42,609.50 47
49,631.52
REVENUE TOTALS
$419,264.00
$0.00
$419,264.00
$12,785.50
$0.00
$37,390.50
$381,873.50 9%
$49,631.52
Fund 042 - Cmmty Development Block Grant Totals
$419,264.00
$0.00
$419,264.00
$12,785.50
$0.00
$37,390.50
$381,873.50
$49,631.52
I
10
Revenue Budget
by Account
Classification
Report
Through 05/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget
Amended Current Month
YTD YTD
Budget - YTD % used/
Account Classification
Budget
Amendments
Budget Transactions
Encumbrances Transactions
Transactions Rec'd Prior Year YTD
Fund 043 - Asset Seizure Fund
REVENUE
Fines & Forfeits
2,000.00
.00
2,000.00 358.80
.00 358.80
1,641.20 18 .00
Investment Income
100.00
.00
100.00 1.47
.00 6.42
93.58 6 7.86
REVENUE TOTALS
$2,100.00
$0.00
$2,100.00 $360.27
$0.00 $365.22
$1,734.78 17% $7.86
Fund 043 - Asset Seizure Fund Totals
$2,100.00
$0.00
$2,100.00 $360.27
$0.00 $365.22
$1,734.78 $7.86
10
Revenue Budget
by Account
Classification
Report
Through 05/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget
Amended Current Month
YTD YTD
Budget - YTD % used/
Account Classification
Budget
Amendments
Budget Transactions
Encumbrances Transactions
Transactions Rec'd Prior Year YTD
Fund 044 - Federal Equitable Share Funds
REVENUE
Fines & Forfeits
100.00
.00
100.00 .00
.00 .00
100.00 0 24,637.80
Investment Income
100.00
.00
100.00 .84
.00 4.69
95.31 5 9.20
REVENUE TOTALS
$200.00
$0.00
$200.00 $0.84
$0.00 $4.69
$195.31 2% $24,647.00
Fund 044 -Federal Equitable Share Funds Totals
$200.00
$0.00
$200.00 $0.84
$0.00 $4.69
$195.31 $24,647.00
12
Revenue Budget
by Account
Classification
Report
Through 05/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget
Amended Current Month
YTD YTD
Budget - YTD % used/
Account Classification
Budget
Amendments
Budget Transactions
Encumbrances Transactions
Transactions Rec'd Prior Year YTD
Fund 045 - DUI Fine Fund
REVENUE
Fines & Forfeits
20,000.00
.00
20,000.00 .00
.00 8,841.39
11,158.61 44 9,579.73
Investment Income
100.00
.00
100.00 2.32
.00 13.18
86.82 13 21.10
REVENUE TOTALS
$20,100.00
$0.00
$20,100.00 $2.32
$0.00 $8,854.57
$11,245.43 44% $9,600.83
Fund 045 - DUI Fine Fund Totals
$20,100.00
$0.00
$20,100.00 $2.32
$0.00 $8,854.57
$11,245.43 $9,600.83
12
Revenue Budget by Account Classification
Report
Through 05/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Fund 046 - Foreign Fire Tax Board Fund
REVENUE
Other Taxes
70,000.00
.00
70,000.00
.00
.00
.00
70,000.00
0
.00
Investment Income
100.00
.00
100.00
6.20
.00
29.34
70.66
29
57.17
Other Revenue
.00
.00
.00
.00
.00
.00
.00
+++
.00
Other Financing Sources
.00
.00
.00
.00
.00
.00
.00
+++
.00
REVENUE TOTALS
$70,100.00
$0.00
$70,100.00
$6.20
$0.00
$29.34
$70,070.66
0%
$57.17
Fund 046 -Foreign Fire Tax Board Fund Totals
$70,100.00
$0.00
$70,100.00
$6.20
$0.00
$29.34
$70,070.66
$57.17
13
Revenue Budget by Account Classification
Report
Through 05/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Fund 048 - Business District Fund
REVENUE
Other Taxes
1,021,000.00
.00
1,021,000.00
72,298.19
.00
277,601.43
743,398.57 27
238,749.41
Investment Income
.00
.00
.00
14.28
.00
36.79
(36.79) +++
16.65
Other Financing Sources
.00
.00
.00
.00
.00
.00
.00 +++
.00
REVENUE TOTALS
$1,021,000.00
$0.00
$1,021,000.00
$72,312.47
$0.00
$277,638.22
$743,361.78 27%
$238,766.06
Fund 048 - Business District Fund Totals
$1,021,000.00
$0.00
$1,021,000.00
$72,312.47
$0.00
$277,638.22
$743,361.78
$238,766.06
14
Account Classification
Fund 050 -Water and Sewer Fund
REVENUE
Property Taxes
Licenses, Permits & Fees
Charges For Services
Fines & Forfeits
Investment Income
Reimbursements
Other Revenue
Other Financing Sources
Revenue Budget by Account Classification
Report
Through 05/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
1,530,000.00
9,800.00
.00
1,530,000.00
52,820.55
(4,685.45) .00
18, 000.00
1,454.33
.00
18, 000.00
34,597.52
1,880.00 .00
13,789,000.00
.00
.00
13,789,000.00
998,438.48 .00
118,000.00
.00
118,000.00
8,554.17 .00
2,100.00
.00
2,100.00
125.48 .00
500.00
.00
500.00
.00 .00
72,000.00
.00
72,000.00
4,562.96 .00
.00
.00
.00
.00 .00
REVENUE TOTALS $15,529,600.00
Fund 050 -Water and Sewer Fund Totals $15,529,600.00
(1,232.84) 1,531,232.84
8,200.00
9,800.00
4,885,655.97
8,903,344.03
52,820.55
65,179.45
645.67
1,454.33
.00
500.00
34,597.52
37,402.48
.00
.00
0
812,372.67
46
6,760.00
35
4,650,989.48
45
44,367.56
31
829.30
0
(131.00)
48
29,536.53
+++
.00
$0.00 $15,529,600.00 $1,008,875.64 $0.00 $4,980,686.87 $10,548,913.13 32% $5,544,724.54
$0.00 $15,529,600.00 $1,008,875.64
15
$0.00 $4,980,686.87 $10,548,913.13 $5,544,724.54
Revenue Budget by Account Classification
Report
Through 05/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Fund 051 - Village Parking System Fund
REVENUE
Other Taxes
.00
.00
.00
.00
.00
.00
.00
+++
1,255.71
Charges For Services
124,000.00
.00
124,000.00
9,378.35
.00
59,679.23
64,320.77
48
56,363.86
Investment Income
100.00
.00
100.00
5.65
.00
25.45
74.55
25
46.71
Other Revenue
6,600.00
.00
6,600.00
.00
.00
2,200.00
4,400.00
33
2,750.00
Other Financing Sources
.00
.00
.00
.00
.00
.00
.00
+++
.00
REVENUE TOTALS
$130,700.00
$0.00
$130,700.00
$9,384.00
$0.00
$61,904.68
$68,795.32
47%
$60,416.28
Fund 051 - Village Parking System Fund Totals
$130,700.00
$0.00
$130,700.00
$9,384.00
$0.00
$61,904.68
$68,795.32
$60,416.28
16
17
Revenue Budget
by Account
Classification
Report
Through 05/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD % used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions Rec'd Prior Year YTD
Fund 052 - Parking System Revenue Fund
REVENUE
Other Taxes
100,000.00
.00
100,000.00
6,113.98
.00
12,956.99
87,043.01 13 11,301.32
Intergovernmental Revenue
.00
.00
.00
.00
.00
.00
.00 +++ .00
Charges For Services
119,000.00
.00
119,000.00
9,603.37
.00
48,552.98
70,447.02 41 46,358.10
Investment Income
.00
.00
.00
.00
.00
.00
.00 +++ .00
Other Revenue
.00
.00
.00
.00
.00
.00
.00 +++ .00
Other Financing Sources
.00
.00
.00
.00
.00
.00
.00 +++ .00
REVENUE TOTALS
$219,000.00
$0.00
$219,000.00
$15,717.35
$0.00
$61,509.97
$157,490.03 28% $57,659.42
Fund 052 - Parking System Revenue Fund Totals
$219,000.00
$0.00
$219,000.00
$15,717.35
$0.00
$61,509.97
$157,490.03 $57,659.42
17
18
Revenue Budget
by Account
Classification
Report
Through 05/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD % used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions Rec'd Prior Year YTD
Fund 060 - Vehicle Maintenance Fund
REVENUE
Charges For Services
2,157,889.00
.00
2,157,889.00
179,824.09
.00
899,120.45
1,258,768.55 42 890,965.35
Investment Income
600.00
.00
600.00
31.24
.00
132.95
467.05 22 239.92
Other Revenue
.00
.00
.00
.00
.00
200.00
(200.00) +++ .00
REVENUE TOTALS
$2,158,489.00
$0.00
$2,158,489.00
$179,855.33
$0.00
$899,453.40
$1,259,035.60 42% $891,205.27
Fund 060 - Vehicle Maintenance Fund Totals
$2,158,489.00
$0.00
$2,158,489.00
$179,855.33
$0.00
$899,453.40
$1,259,035.60 $891,205.27
18
Revenue Budget by Account Classification
Report
Through 05/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Fund 061 - Vehicle Replacement Fund
REVENUE
Charges For Services
1,380,500.00
.00
1,380,500.00
115,041.68
.00
575,208.40
805,291.60
42
560,958.40
Fines & Forfeits
11,150.00
.00
11,150.00
1,479.36
.00
3,317.72
7,832.28
30
4,200.00
Investment Income
7,200.00
.00
7,200.00
366.10
.00
1,637.33
5,562.67
23
3,095.33
Other Revenue
.00
.00
.00
.00
.00
.00
.00
+++
.00
Other Financing Sources
.00
.00
.00
.00
.00
9,002.00
(9,002.00)
+++
31,554.47
REVENUE TOTAL'
$1,398,850.00
$0.00
$1,398,850.00
$116,887.14
$0.00
$589,165.45
$809,684.55
42%
$599,808.20
Fund 061 - Vehicle Replacement Fund Tots ,
$1,398,850.00
$0.00
$1,398,850.00
$116,887.14
$0.00
$589,165.45
$809,684.55
$599,808.20
19
Revenue Budget by Account Classification
Report
Through 05/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Fund 062 - Computer Replacement Fund
REVENUE
Charges For Services
272,307.00
.00
272,307.00
22,692.25
.00
113,461.25
158,845.75 42
9,620.00
Investment Income
1,000.00
.00
1,000.00
42.76
.00
189.55
810.45 19
312.52
Other Financing Sources
.00
.00
.00
.00
.00
.00
.00 +++
.00
REVENUE TOTALS
$273,307.00
$0.00
$273,307.00
$22,735.01
$0.00
$113,650.80
$159,656.20 42%
$9,932.52
Fund 062 - Computer Replacement Fund Totals
$273,307.00
$0.00
$273,307.00
$22,735.01
$0.00
$113,650.80
$159,656.20
$9,932.52
20
Revenue Budget by Account Classification
Report
Through 05/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Fund 063 - Risk Management Fund
REVENUE
Charges For Services
6,513,826.00
.00
6,513,826.00
473,271.33
.00
2,719,295.10
3,794,530.90
42
2,796,747.53
Investment Income
3,000.00
.00
3,000.00
104.36
.00
473.28
2,526.72
16
963.88
Reimbursements
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00
0
.00
Other Revenue
1,463,700.00
.00
1,463,700.00
106,270.89
.00
542,522.83
921,177.17
37
567,891.61
REVENUE TOTALS
$7,981,526.00
$0.00
$7,981,526.00
$579,646.58
$0.00
$3,262,291.21
$4,719,234.79
41%
$3,365,603.02
Fund 063 - Risk Management Fund Totals
$7,981,526.00
$0.00
$7,981,526.00
$579,646.58
$0.00
$3,262,291.21
$4,719,234.79
$3,365,603.02
21
22
Revenue Budget
by Account
Classification
Report
Through 05/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD % used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions Rec'd Prior Year YTD
Fund 070 - Police Pension Fund
REVENUE
Charges For Services
.00
.00
.00
.00
.00
.00
.00 +++ .00
Investment Income
4,382,800.00
.00
4,382,800.00
401,740.88
.00
1,791,369.58
2,591,430.42 41 1,659,800.57
Other Revenue
3,743,175.00
.00
3,743,175.00
67,733.13
.00
1,814,133.08
1,929,041.92 48 1,734,617.94
REVENUE TOTALS
$8,125,975.00
$0.00
$8,125,975.00
$469,474.01
$0.00
$3,605,502.66
$4,520,472.34 44% $3,394,418.51
Fund 070 - Police Pension Fund Totals
$8,125,975.00
$0.00
$8,125,975.00
$469,474.01
$0.00
$3,605,502.66
$4,520,472.34 $3,394,418.51
22
23
Revenue Budget
by Account
Classification
Report
Through 05/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD % used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions Rec'd Prior Year YTD
Fund 071 - Fire Pension Fund
REVENUE
Investment Income
4,250,500.00
.00
4,250,500.00
(11,792.23)
.00
1,716,539.01
2,533,960.99 40 1,207,841.82
Other Revenue
3,151,125.00
.00
3,151,125.00
52,082.60
.00
1,514,311.69
1,636,813.31 48 1,519,984.27
REVENUE TOTALS
$7,401,625.00
$0.00
$7,401,625.00
$40,290.37
$0.00
$3,230,850.70
$4,170,774.30 44% $2,727,826.09
Fund 071 - Fire Pension Fund Totals
$7,401,625.00
$0.00
$7,401,625.00
$40,290.37
$0.00
$3,230,850.70
$4,170,774.30 $2,727,826.09
Grand Totals
$108,069,524.00
$1,571,260.00
$109,640,784.00
$6,052,568.41
$0.00
$39,678,665.29
$69,962,118.71 $45,164,624.36
23
1
Expense Budget
by Account
Classification
Report
Through 05/31/15
Prior Fiscal
Year Activity Included
Summary Listing
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD % used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions Rec'd Prior Year YTD
Fund 001 - General Fund
EXPENSE
Personal Services, Scheduled Salaries & Wages
24,232,037.00
.00
24,232,037.00
1,745,385.37
.00
8,730,098.75
15,501,938.25 36 8,961,371.79
Employee Benefits
12,235,287.00
.00
12,235,287.00
552,903.22
.00
5,623,940.62
6,611,346.38 46 5,620,293.95
Other Employee Costs
440,543.00
(2,100.00)
438,443.00
24,773.64
7,263.54
158,784.40
272,395.06 38 137,758.94
Pension Benefits
46,456.00
.00
46,456.00
3,871.28
.00
19,356.40
27,099.60 42 19,291.80
Contractual Services
7,528,869.00
9,578.00
7,538,447.00
607,377.39
524,070.87
2,854,065.54
4,160,310.59 45 2,831,565.70
Utilities
271,939.00
.00
271,939.00
5,634.06
.00
58,495.03
213,443.97 22 63,367.71
Insurance
415,398.00
.00
415,398.00
34,575.02
.00
172,822.58
242,575.42 42 146,065.90
Commodities & Supplies
641,996.00
8,698.00
650,694.00
49,788.90
57,648.56
180,474.01
412,571.43 37 193,217.23
Other Expenditures
11,140.00
.00
11,140.00
.00
.00
.00
11,140.00 0 .00
Building Improvements
10,200.00
.00
10,200.00
437.95
570.00
5,497.46
4,132.54 59 1,083.52
Office Equipment
33,520.00
17,400.00
50,920.00
1,009.67
7,553.26
3,770.82
39,595.92 22 6,376.17
Other Equipment
184,199.00
4,240.00
188,439.00
19,952.17
7,313.08
59,589.08
121,536.84 36 60,151.78
Distribution Systems
100,000.00
.00
100,000.00
.00
81,191.00
7,037.21
11,771.79 88 .00
Infrastructure
666,823.00
.00
666,823.00
5,756.65
239,074.30
27,148.20
400,600.50 40 104,977.10
Interfund Transfers
.00
.00
.00
.00
.00
.00
.00 +++ .00
EXPENSE TOTALS
$46,818,407.00
$37,816.00
$46,856,223.00
$3,051,465.32
$924,684.61
$17,901,080.10
$28,030,458.29 40% $18,145,521.59
Fund 001 - General Fund Totals
$46,818,407.00
$37,816.00
$46,856,223.00
$3,051,465.32
$924,684.61
$17,901,080.10
$28,030,458.29 $18,145,521.59
1
2
Expense Budget
by Account
Classification
Report
Through 05/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD % used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions Rec'd Prior Year YTD
Fund 002 - Debt Service Fund
EXPENSE
Contractual Services
.00
.00
.00
.00
.00
.00
.00 +++ .00
Other Expenditures
.00
.00
.00
.00
.00
.00
.00 +++ .00
Bond Principal
1,893,913.00
1,155,000.00
3,048,913.00
.00
.00
37,046.10
3,011,866.90 1 162,132.16
Interest Expense
1,382,571.00
413,356.00
1,795,927.00
888,790.63
.00
892,120.82
903,806.18 50 756,545.55
Bank & Fiscal Fees
2,312.00
500.00
2,812.00
.00
.00
3,037.14
(225.14) 108 1,258.20
Interfund Transfers
.00
.00
.00
.00
.00
.00
.00 +++ .00
Other Financing Uses
.00
.00
.00
.00
.00
.00
.00 +++ .00
EXPENSE TOTALS
$3,278,796.00
$1,568,856.00
$4,847,652.00
$888,790.63
$0.00
$932,204.06
$3,915,447.94 19% $919,935.91
Fund 002 - Debt Service Fund Totals
$3,278,796.00
$1,568,856.00
$4,847,652.00
$888,790.63
$0.00
$932,204.06
$3,915,447.94 $919,935.91
2
3
Expense Budget
by Account
Classification
Report
Through 05/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD % used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions Rec'd Prior Year YTD
Fund 020 - Capital Improvement Fund
EXPENSE
Contractual Services
.00
.00
.00
.00
.00
.00
.00 +++ .00
Other Expenditures
.00
.00
.00
.00
.00
.00
.00 +++ .00
Land Improvements
350,000.00
236,250.00
586,250.00
.00
.00
2,039.40
584,210.60 0 .00
Building Improvements
896,000.00
502,440.00
1,398,440.00
300.00
458,132.76
92,406.42
847,900.82 39 27,261.60
Office Equipment
.00
.00
.00
.00
.00
.00
.00 +++ .00
Motor Equipment
.00
.00
.00
.00
.00
.00
.00 +++ .00
Other Equipment
486,747.00
52,118.00
538,865.00
10,603.91
.00
86,876.21
451,988.79 16 121,938.63
Infrastructure
503,000.00
284,861.00
787,861.00
25,464.95
284,185.44
53,555.21
450,120.35 43 27,539.06
Interfund Transfers
.00
.00
.00
.00
.00
.00
.00 +++ .00
EXPENSE TOTALS
$2,235,747.00
$1,075,669.00
$3,311,416.00
$36,368.86
$742,318.20
$234,877.24
$2,334,220.56 30% $176,739.29
Fund 020 - Capital Improvement Fund Totals
$2,235,747.00
$1,075,669.00
$3,311,416.00
$36,368.86
$742,318.20
$234,877.24
$2,334,220.56 $176,739.29
3
W
Expense Budget
by Account
Classification
Report
Through 05/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD % used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions Rec'd Prior Year YTD
Fund 022 - Downtown Redevelopment Construct
EXPENSE
Contractual Services
109,201.00
.00
109,201.00
8,672.37
84,367.17
29,963.94
(5,130.11) 105 12,643.26
Utilities
.00
.00
.00
.00
.00
.00
.00 +++ .00
Other Expenditures
3,306,969.00
.00
3,306,969.00
23,091.29
.00
27,339.64
3,279,629.36 1 57,858.93
Infrastructure
342,285.00
3,675.00
345,960.00
.00
332,042.99
.00
13,917.01 96 9,240.00
Bond Principal
.00
.00
.00
.00
.00
.00
.00 +++ .00
Interest Expense
.00
.00
.00
.00
.00
.00
.00 +++ .00
Interfund Transfers
.00
.00
.00
.00
.00
.00
.00 +++ .00
EXPENSE TOTALS
$3,758,455.00
$3,675.00
$3,762,130.00
$31,763.66
$416,410.16
$57,303.58
$3,288,416.26 13% $79,742.19
Fund 022 - Downtown Redevelopment Construct Tota
$3,758,455.00
$3,675.00
$3,762,130.00
$31,763.66
$416,410.16
$57,303.58
$3,288,416.26 $79,742.19
W
5
Expense Budget
by Account
Classification
Report
Through 05/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD % used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions Rec'd Prior Year YTD
Fund 023 - Street Improvement Construc Fund
EXPENSE
Contractual Services
107,000.00
.00
107,000.00
1,032.00
88,884.00
1,032.00
17,084.00 84 40,700.82
Infrastructure
4,715,000.00
2,041,886.00
6,756,886.00
984,039.46
4,970,150.06
1,015,810.60
770,925.34 89 1,753,194.52
Interfund Transfers
.00
.00
.00
.00
.00
.00
.00 +++ .00
EXPENSE TOTALS
$4,822,000.00
$2,041,886.00
$6,863,886.00
$985,071.46
$5,059,034.06
$1,016,842.60
$788,009.34 89% $1,793,895.34
Fund 023 - Street Improvement Construc Fund Totals
$4,822,000.00
$2,041,886.00
$6,863,886.00
$985,071.46
$5,059,034.06
$1,016,842.60
$788,009.34 $1,793,895.34
5
I
Expense Budget
by Account
Classification
Report
Through 05/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD % used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions Rec'd Prior Year YTD
Fund 024 - Flood Control Construction Fund
EXPENSE
Contractual Services
12,000.00
.00
12,000.00
.00
.00
.00
12,000.00 0 .00
Utilities
2,300.00
.00
2,300.00
.00
.00
1,062.94
1,237.06 46 915.87
Commodities & Supplies
5,000.00
.00
5,000.00
.00
.00
.00
5,000.00 0 .00
Other Expenditures
5,100.00
.00
5,100.00
.00
.00
.00
5,100.00 0 .00
Other Equipment
.00
.00
.00
.00
.00
.00
.00 +++ .00
Infrastructure
9,779,960.00
868,591.00
10,648,551.00
119,584.61
7,971,934.09
858,229.04
1,818,387.87 83 179,020.21
EXPENSE TOTALS
$9,804,360.00
$868,591.00
$10,672,951.00
$119,584.61
$7,971,934.09
$859,291.98
$1,841,724.93 83% $179,936.08
Fund 024 - Flood Control Construction Fund Totals
$9,804,360.00
$868,591.00
$10,672,951.00
$119,584.61
$7,971,934.09
$859,291.98
$1,841,724.93 $179,936.08
I
7
Expense Budget
by Account
Classification
Report
Through 05/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD % used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions Rec'd Prior Year YTD
Fund 040 - Refuse Disposal Fund
EXPENSE
Personal Services, Scheduled Salaries & Wages
236,644.00
.00
236,644.00
18,140.16
.00
95,115.89
141,528.11 40 101,017.80
Employee Benefits
110,436.00
.00
110,436.00
8,555.53
.00
46,334.53
64,101.47 42 44,516.58
Other Employee Costs
1,248.00
.00
1,248.00
.00
.00
.00
1,248.00 0 1,095.00
Contractual Services
4,294,934.00
4,742.00
4,299,676.00
363,849.27
13,952.15
1,541,973.11
2,743,750.74 36 1,535,236.70
Utilities
447.00
.00
447.00
22.30
.00
94.73
352.27 21 101.69
Insurance
31,809.00
.00
31,809.00
2,650.75
.00
13,253.75
18,555.25 42 11,933.35
Commodities & Supplies
38,446.00
.00
38,446.00
1,360.80
.00
11,966.21
26,479.79 31 10,453.54
EXPENSE TOTALS
$4,713,964.00
$4,742.00
$4,718,706.00
$394,578.81
$13,952.15
$1,708,738.22
$2,996,015.63 37% $1,704,354.66
Fund 040 - Refuse Disposal Fund Totals
$4,713,964.00
$4,742.00
$4,718,706.00
$394,578.81
$13,952.15
$1,708,738.22
$2,996,015.63 $1,704,354.66
7
Expense Budget by Account Classification
Report
Through 05/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Fund 041 - Motor Fuel Tax Fund
EXPENSE
Contractual Services
284,686.00
.00
284,686.00
16,634.69
145,286.89
26,391.20
113,007.91
60
68,834.23
Utilities
156,060.00
.00
156,060.00
31,215.24
.00
68,118.60
87,941.40
44
73,478.93
Commodities & Supplies
453,209.00
.00
453,209.00
.00
127,207.88
177,324.24
148,676.88
67
216,890.32
Building Improvements
600,000.00
.00
600,000.00
.00
.00
.00
600,000.00
0
.00
Infrastructure
663,000.00
.00
663,000.00
16,099.25
101,138.37
31,632.82
530,228.81
20
10,056.62
EXPENSE TOTALS
$2,156,955.00
$0.00
$2,156,955.00
$63,949.18
$373,633.14
$303,466.86
$1,479,855.00
31%
$369,260.10
Fund 041 - Motor Fuel Tax Fund Totals
$2,156,955.00
$0.00
$2,156,955.00
$63,949.18
$373,633.14
$303,466.86
$1,479,855.00
$369,260.10
m
Expense Budget
by Account
Classification
Report
Through 05/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD % used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions Rec'd Prior Year YTD
Fund 042 - Cmmty Development Block Grant
EXPENSE
Personal Services, Scheduled Salaries & Wages
48,783.00
.00
48,783.00
3,749.99
.00
16,764.24
32,018.76 34 15,903.88
Employee Benefits
25,491.00
.00
25,491.00
2,094.20
.00
10,094.62
15,396.38 40 10,283.48
Other Employee Costs
1,040.00
.00
1,040.00
.00
.00
47.50
992.50 5 151.70
Contractual Services
154,430.00
.00
154,430.00
432.14
24,759.00
18,137.51
111,533.49 28 51,344.44
Commodities & Supplies
520.00
.00
520.00
.00
.00
.00
520.00 0 .00
Other Expenditures
189,000.00
.00
189,000.00
160.00
.00
7,802.50
181,197.50 4 1,820.00
Land Improvements
.00
.00
.00
.00
.00
.00
.00 +++ .00
Building Improvements
.00
.00
.00
.00
.00
.00
.00 +++ .00
Infrastructure
.00
.00
.00
.00
.00
.00
.00 +++ .00
EXPENSE TOTALS
$419,264.00
$0.00
$419,264.00
$6,436.33
$24,759.00
$52,846.37
$341,658.63 19% $79,503.50
Fund 042 - Cmmty Development Block Grant Totals
$419,264.00
$0.00
$419,264.00
$6,436.33
$24,759.00
$52,846.37
$341,658.63 $79,503.50
m
10
Expense Budget
by Account
Classification
Report
Through 05/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD % used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions Rec'd Prior Year YTD
Fund 043 - Asset Seizure Fund
EXPENSE
Other Employee Costs
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00 0 .00
Contractual Services
3,000.00
.00
3,000.00
2,000.00
.00
2,000.00
1,000.00 67 1,500.00
Other Equipment
15,000.00
.00
15,000.00
566.00
.00
2,389.63
12,610.37 16 1,642.29
EXPENSE TOTALS
$19,000.00
$0.00
$19,000.00
$2,566.00
$0.00
$4,389.63
$14,610.37 23% $3,142.29
Fund 043 - Asset Seizure Fund Totals
$19,000.00
$0.00
$19,000.00
$2,566.00
$0.00
$4,389.63
$14,610.37 $3,142.29
10
Expense Budget by Account Classification
Report
Through 05/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Fund 044 - Federal Equitable Share Funds
EXPENSE
Contractual Services
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00 0
.00
Building Improvements
.00
.00
.00
.00
.00
.00
.00 +++
.00
Other Equipment
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00 0
.00
EXPENSE TOTALS
$2,000.00
$0.00
$2,000.00
$0.00
$0.00
$0.00
$2,000.00 0%
$0.00
Fund 044 -Federal Equitable Share Funds Totals
$2,000.00
$0.00
$2,000.00
$0.00
$0.00
$0.00
$2,000.00
$0.00
Expense Budget by Account Classification
Report
Through 05/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Fund 045 - DUI Fine Fund
EXPENSE
Other Employee Costs
Contractual Services
Other Equipment
Interfund Transfers
1,000.00
.00
1,000.00
465.30
.00
465.30
534.70
47
.00
.00
.00
.00
.00
.00
.00
.00
+++
.00
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00
0
95.99
.00
.00
.00
.00
.00
.00
.00
+++
.00
EXPENSE TOTALS $2,000.00
$0.00
$2,000.00
$465.30
$0.00
$465.30
$1,534.70
23%
$95.99
Fund 045 - DUI Fine Fund Totals $2,000.00
$0.00
$2,000.00
$465.30
$0.00
$465.30
$1,534.70
$95.99
12
Expense Budget by Account Classification
Report
Through 05/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Fund 046 - Foreign Fire Tax Board Fund
EXPENSE
Contractual Services
10,000.00
.00
10,000.00
(11.05)
.00
7,422.88
2,577.12
74
3,946.60
Insurance
500.00
.00
500.00
.00
.00
.00
500.00
0
.00
Commodities & Supplies
5,000.00
.00
5,000.00
444.26
.00
444.26
4,555.74
9
211.65
Other Equipment
15,000.00
.00
15,000.00
.00
.00
31,488.86
(16,488.86)
210
11,688.00
EXPENSE TOTALS
$30,500.00
$0.00
$30,500.00
$433.21
$0.00
$39,356.00
($8,856.00)
129%
$15,846.25
Fund 046 -Foreign Fire Tax Board Fund Totals
$30,500.00
$0.00
$30,500.00
$433.21
$0.00
$39,356.00
($8,856.00)
$15,846.25
13
14
Expense Budget
by Account
Classification
Report
Through 05/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget Amended Current Month
YTD YTD
Budget - YTD % used/
Account Classification
Budget
Amendments Budget Transactions
Encumbrances Transactions
Transactions Rec'd Prior Year YTD
Fund 048 - Business District Fund
EXPENSE
Bond Principal
.00
.00 .00 .00
.00 .00
.00 +++ .00
Interest Expense
1,021,000.00
.00 1,021,000.00 89,473.25
.00 205,325.75
815,674.25 20 .00
EXPENSE TOTALS
$1,021,000.00
$0.00 $1,021,000.00 $89,473.25
$0.00 $205,325.75
$815,674.25 20% $0.00
Fund 048 - Business District Fund Totals
$1,021,000.00
$0.00 $1,021,000.00 $89,473.25
$0.00 $205,325.75
$815,674.25 $0.00
14
Account Classification
Adopted
Budget
Expense Budget
Budget Amended Current Month
Amendments Budget Transactions
by Account Classification
Report
Through 05/31/15
Prior Fiscal Year Activity Included
Summary Listing
YTD YTD Budget - YTD % used/
Encumbrances Transactions Transactions Rec'd Prior Year YTD
Fund 050 -Water and Sewer Fund
EXPENSE
Personal Services, Scheduled Salaries & Wages
2,006,058.00
.00
2,006,058.00
137,031.35
.00
760,838.31
1,245,219.69 38 817,511.08
Employee Benefits
772,177.00
.00
772,177.00
57,220.44
.00
324,527.85
447,649.15 42 321,888.01
Other Employee Costs
37,393.00
.00
37,393.00
3,243.97
440.54
10,293.96
26,658.50 29 13,603.89
Contractual Services
8,650,244.00
140,210.00
8,790,454.00
701,967.62
380,475.05
2,822,274.92
5,587,704.03 36 2,719,007.86
Utilities
160,913.00
.00
160,913.00
11,679.77
.00
46,171.23
114,741.77 29 42,046.46
Insurance
101,312.00
.00
101,312.00
8,484.33
.00
42,379.98
58,932.02 42 33,530.80
Commodities & Supplies
293,516.00
.00
293,516.00
18,180.52
63,686.24
87,479.97
142,349.79 52 69,327.06
Other Expenditures
.00
.00
.00
.00
.00
.00
.00 +++ .00
Building Improvements
65,000.00
37,225.00
102,225.00
350.00
94,712.56
725.00
6,787.44 93 .00
Office Equipment
3,930.00
.00
3,930.00
.00
.00
.00
3,930.00 0 .00
Other Equipment
1,173,744.00
1,546,434.00
2,720,178.00
44,953.83
1,326,752.74
422,021.73
971,403.53 64 81,180.00
Distribution Systems
2,300,500.00
620,279.00
2,920,779.00
203,804.68
1,709,680.60
308,313.01
902,785.39 69 29,661.99
Infrastructure
.00
.00
.00
.00
.00
.00
.00 +++ .00
Bond Principal
.00
.00
.00
.00
.00
.00
.00 +++ .00
Interest Expense
.00
.00
.00
.00
.00
.00
.00 +++ .00
Interfund Transfers
.00
.00
.00
.00
.00
.00
.00 +++ .00
EXPENSE TOTALS
$15,564,787.00
$2,344,148.00
$17,908,935.00
$1,186,916.51
$3,575,747.73
$4,825,025.96
$9,508,161.31 47% $4,127,757.15
Fund 050 -Water and Sewer Fund Totals
$15,564,787.00
$2,344,148.00
$17,908,935.00
$1,186,916.51
$3,575,747.73
$4,825,025.96
$9,508,161.31 $4,127,757.15
15
16
Expense Budget
by Account
Classification
Report
Through 05/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD % used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions Rec'd Prior Year YTD
Fund 051 - Village Parking System Fund
EXPENSE
Personal Services, Scheduled Salaries & Wages
35,175.00
.00
35,175.00
2,525.98
.00
13,091.59
22,083.41 37 14,931.57
Employee Benefits
17,353.00
.00
17,353.00
1,292.38
.00
6,551.51
10,801.49 38 6,308.21
Contractual Services
94,382.00
.00
94,382.00
4,200.25
6,974.54
25,747.36
61,660.10 35 25,973.75
Insurance
2,156.00
.00
2,156.00
179.67
.00
898.35
1,257.65 42 489.60
Commodities & Supplies
520.00
.00
520.00
.00
.00
.00
520.00 0 .00
Other Expenditures
.00
.00
.00
.00
.00
.00
.00 +++ .00
Building Improvements
7,074.00
.00
7,074.00
.00
3,500.00
.00
3,574.00 49 .00
Infrastructure
153,500.00
.00
153,500.00
.00
.00
.00
153,500.00 0 .00
Interfund Transfers
.00
.00
.00
.00
.00
.00
.00 +++ .00
EXPENSE TOTALS
$310,160.00
$0.00
$310,160.00
$8,198.28
$10,474.54
$46,288.81
$253,396.65 18% $47,703.13
Fund 051 - Village Parking System Fund Totals
$310,160.00
$0.00
$310,160.00
$8,198.28
$10,474.54
$46,288.81
$253,396.65 $47,703.13
16
17
Expense Budget
by Account
Classification
Report
Through 05/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD % used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions Rec'd Prior Year YTD
Fund 052 - Parking System Revenue Fund
EXPENSE
Personal Services, Scheduled Salaries & Wages
25,830.00
.00
25,830.00
1,859.59
.00
9,596.99
16,233.01 37 10,802.32
Employee Benefits
13,024.00
.00
13,024.00
957.51
.00
4,845.42
8,178.58 37 4,686.15
Contractual Services
114,325.00
.00
114,325.00
9,786.53
17,803.08
34,617.12
61,904.80 46 33,693.13
Utilities
10,733.00
.00
10,733.00
347.43
.00
2,468.16
8,264.84 23 2,678.84
Insurance
1,757.00
.00
1,757.00
146.42
.00
732.10
1,024.90 42 585.85
Commodities & Supplies
9,974.00
.00
9,974.00
.00
.00
639.29
9,334.71 6 6,195.65
Other Expenditures
.00
.00
.00
.00
.00
.00
.00 +++ .00
Building Improvements
75,000.00
.00
75,000.00
.00
.00
.00
75,000.00 0 .00
Infrastructure
.00
.00
.00
.00
.00
.00
.00 +++ .00
Interfund Transfers
.00
.00
.00
.00
.00
.00
.00 +++ .00
EXPENSE TOTALS
$250,643.00
$0.00
$250,643.00
$13,097.48
$17,803.08
$52,899.08
$179,940.84 28% $58,641.94
Fund 052 - Parking System Revenue Fund Totals
$250,643.00
$0.00
$250,643.00
$13,097.48
$17,803.08
$52,899.08
$179,940.84 $58,641.94
17
18
Expense Budget
by Account
Classification
Report
Through 05/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD % used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions Rec'd Prior Year YTD
Fund 060 - Vehicle Maintenance Fund
EXPENSE
Personal Services, Scheduled Salaries & Wages
951,226.00
.00
951,226.00
71,224.99
.00
372,253.46
578,972.54 39 395,104.64
Employee Benefits
379,364.00
.00
379,364.00
27,805.88
.00
145,188.63
234,175.37 38 151,935.26
Other Employee Costs
2,408.00
.00
2,408.00
141.00
.00
561.33
1,846.67 23 684.00
Contractual Services
102,813.00
12,844.00
115,657.00
5,586.25
21,260.39
38,338.74
56,057.87 52 29,582.39
Utilities
3,132.00
.00
3,132.00
55.75
.00
1,137.04
1,994.96 36 778.28
Commodities & Supplies
735,223.00
26,295.00
761,518.00
40,187.42
193,050.89
232,072.39
336,394.72 56 300,330.00
Other Expenditures
.00
.00
.00
.00
.00
.00
.00 +++ .00
Office Equipment
567.00
.00
567.00
.00
.00
.00
567.00 0 132.99
Other Equipment
20,165.00
.00
20,165.00
.00
16,523.95
55.83
3,585.22 82 350.00
EXPENSE TOTALS
$2,194,898.00
$39,139.00
$2,234,037.00
$145,001.29
$230,835.23
$789,607.42
$1,213,594.35 46% $878,897.56
Fund 060 - Vehicle Maintenance Fund Totals
$2,194,898.00
$39,139.00
$2,234,037.00
$145,001.29
$230,835.23
$789,607.42
$1,213,594.35 $878,897.56
18
Expense Budget by Account Classification
Report
Through 05/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Fund 061 - Vehicle Replacement Fund
EXPENSE
Other Expenditures
.00
.00
.00
.00
.00
.00
.00 +++
.00
Motor Equipment
909,000.00
273,406.00
1,182,406.00
13,997.87
563,491.63
36,808.14
582,106.23 51
723,828.10
Interfund Transfers
.00
.00
.00
.00
.00
.00
.00 +++
.00
EXPENSE TOTALS
$909,000.00
$273,406.00
$1,182,406.00
$13,997.87
$563,491.63
$36,808.14
$582,106.23 51%
$723,828.10
Fund 061 - Vehicle Replacement Fund Totals
$909,000.00
$273,406.00
$1,182,406.00
$13,997.87
$563,491.63
$36,808.14
$582,106.23
$723,828.10
19
Expense Budget by Account Classification
Report
Through 05/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Fund 062 - Computer Replacement Fund
EXPENSE
Other Expenditures
Office Equipment
EXPENSE TOTALS
Fund 062 - Computer Replacement Fund Totals
.00 .00 .00 .00 .00 .00 .00 +++ .00
429,380.00 .00 429,380.00 20,689.98 505.00 56,368.76 372,506.24 13 55,687.15
$429,380.00 $0.00 $429,380.00 $20,689.98 $505.00 $56,368.76 $372,506.24 13% $55,687.15
$429,380.00 $0.00 $429,380.00 $20,689.98 $505.00 $56,368.76 $372,506.24
20
$55,687.15
Expense Budget by Account Classification
Report
Through 05/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Fund 063 - Risk Management Fund
EXPENSE
Contractual Services
25,000.00
.00
25,000.00
7,700.00
.00
12,150.00
12,850.00
49
10,300.00
Insurance
7,889,896.00
.00
7,889,896.00
647,051.40
.00
3,542,976.89
4,346,919.11
45
3,345,036.57
Other Equipment
165,000.00
.00
165,000.00
.00
.00
.00
165,000.00
0
.00
Infrastructure
.00
.00
.00
.00
.00
.00
.00
+++
.00
Interfund Transfers
.00
.00
.00
.00
.00
.00
.00
+++
.00
EXPENSE TOTALS
$8,079,896.00
$0.00
$8,079,896.00
$654,751.40
$0.00
$3,555,126.89
$4,524,769.11
44%
$3,355,336.57
Fund 063 - Risk Management Fund Totals
$8,079,896.00
$0.00
$8,079,896.00
$654,751.40
$0.00
$3,555,126.89
$4,524,769.11
$3,355,336.57
21
22
Expense Budget
by Account
Classification
Report
Through 05/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD % used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions Rec'd Prior Year YTD
Fund 070 - Police Pension Fund
EXPENSE
Pension Benefits
4,472,170.00
.00
4,472,170.00
399,514.48
.00
1,882,023.25
2,590,146.75 42 1,628,771.20
Contractual Services
154,100.00
.00
154,100.00
4,860.48
.00
30,782.67
123,317.33 20 37,411.39
Insurance
15,000.00
.00
15,000.00
.00
.00
.00
15,000.00 0 .00
Commodities & Supplies
100.00
.00
100.00
.00
.00
.00
100.00 0 .00
Other Expenditures
12,000.00
.00
12,000.00
8,000.00
.00
8,350.00
3,650.00 70 8,250.00
Office Equipment
.00
.00
.00
.00
.00
.00
.00 +++ .00
EXPENSE TOTALS
$4,653,370.00
$0.00
$4,653,370.00
$412,374.96
$0.00
$1,921,155.92
$2,732,214.08 41% $1,674,432.59
Fund 070 - Police Pension Fund Totals
$4,653,370.00
$0.00
$4,653,370.00
$412,374.96
$0.00
$1,921,155.92
$2,732,214.08 $1,674,432.59
22
Expense Budget by Account Classification
Report
Through 05/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Fund 071 - Fire Pension Fund
EXPENSE
Pension Benefits
4,334,168.00
.00
4,334,168.00
371,617.77
.00
1,857,469.62
2,476,698.38
43
1,723,570.43
Contractual Services
136,100.00
.00
136,100.00
4,670.51
.00
40,643.25
95,456.75
30
44,419.94
Insurance
15,000.00
.00
15,000.00
.00
.00
.00
15,000.00
0
.00
Commodities & Supplies
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00
0
.00
Other Expenditures
12,000.00
.00
12,000.00
8,000.00
.00
8,000.00
4,000.00
67
8,000.00
EXPENSE TOTALS
$4,498,268.00
$0.00
$4,498,268.00
$384,288.28
$0.00
$1,906,112.87
$2,592,155.13
42%
$1,775,990.37
Fund 071 - Fire Pension Fund Totals
$4,498,268.00
$0.00
$4,498,268.00
$384,288.28
$0.00
$1,906,112.87
$2,592,155.13
$1,775,990.37
Grand Totals $115,972,850.00 $8,257,928.00 $124,230,778.00 $8,510,262.67 $19,925,582.62 $36,505,581.54 $67,799,613.84 $36,166,247.75
23
Fund Vendor Name
VILLAGE OF MOUNT PROSPECT
List of Bills
May 28 - June 10, 2015
Invoice Description
001 General Fund
ACS State & Local Government Solutions
Illinois State Disbursement Unit
Air One Equipment, Inc.
2 Cycle Fuel
2015 SCBA Compressor Maint./ Quarterly Air Test
2015 SCBA Compressor Maint./ Quarterly Air Test
Alexian Brothers Medical Center
Pre-Employment Testing - T. Gruensfelder & M. Mazurek
Pre Employment Testing - L. Seitz-Marzano
Pre-Employment Testing - P. Schroeder
Pre-Employment Testing - M. Blesic & J. Caccavallo
Alport, Daniel K
Transfer Stamp Rebate
American Landscaping Inc.
Professional Services
Grass cutting, board window paint-2 N. Main
Grass cutting - 2 N. Main
Anderson Pest Solutions
June pest control for the CCC
Andres Medical Billing, Ltd.
Ambulance Billing - April 2015
Aramark Uniform Services, Inc.
Uniform cleaning and rental for Public Works employees
Uniform Cleaning and Rental
Uniform cleaning and rental for Public Works employees
Uniform Cleaning and Rental
ARC Document Solutions, LLC
Equipment Maintenance
Arteaga, Julia
Reimbursement for training supplies and parking
Arthur Weiler, Inc.
Parkway Tree Removals
AT & T
Service 5/16/15 - 6/15/15
Avanti Cafe & Sandwich Bar, Inc.
Food for Lambel's Promotion
B & H Photo/video
Camera & lighting supplies
Baldini, Carol
Reimbursement for United Way luncheon
Bedco Mechanical
HVAC Repairs
HVAC Repairs
Repair pulleys on Reznor unit at Police & Fire building
Repair to RTU #2 at Village Hall - check phase monitor
Berg, Christopher
Reimburse training expenses: Bike Response Team 05/06-08/15
Bertolucci, Alexander D
Collective Bargaining Simulation Seminar - 5/18-5/20/15 - Lodging
Brancato Landscaping, Inc.
Parkway Tree Planting
Busse's Flowers & Gifts
Gifts & Flowers
Capital One National Association
Costco Purchase 4/28/15 - 5/19/15
Caravello, Eric
Transfer Stamp Rebate
Central Continental Bakery
Training Supplies
Century Cleaners
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Chief Supply Corp.
Disposable emergency blankets
CL Graphics, Inc.
Printing of 2014 Annual Report
Clifford-Wald & Co., Inc. - A KIP Company
Engineering Supplies
Engineering Supplies
Engineering Supplies
Community College District 502
Register S. Santi for training course 05/11/15
Conrad Polygraph, Incorporated
Ellenbecker & Wnek Polygraph
Constellation NewEnergy, Inc.
Electrical Service Delivery
Electrical Service Delivery
Cooney, William J.
ICSC ReCon - 05/17-05/21 - registration, lodging, airfair, meals, taxi
APA Conference - 04/17-04/23 - registration, lodging, airfair, meals, taxi
Costar Realty Information, Inc.
Costar Services
Crystal Court Shopping Center
July rent for the CCC
Crystal Maintenance Services Corp.
Janitorial services at 8 buildings for the month of June
D.J.'s Scuba Locker
BCD (Buoyancy control Device)
Gear bags (2)
D.J.'s Scuba Locker
Dry Suit
Page 1 of 9
Amount
6,332.45
84.00
135.00
453.00
138.00
104.00
69.00
173.00
1,206.00
566.00
788.00
182.00
48.00
6,977.95
100.34
100.34
100.34
100.34
62.00
55.00
19,985.15
2,774.90
434.75
698.89
30.00
2,754.15
1,284.65
460.00
115.00
24.00
165.39
20,105.80
41.00
2,231.42
1,430.00
70.83
14.13
14.58
13.68
23.15
23.68
20.50
14.13
12.75
19.58
14.58
549.00
1,419.20
116.38
900.00
90.00
95.00
320.00
31.05
31.11
1,894.20
2,512.84
542.09
5,914.97
7,187.24
599.96
151.98
1,698.38
Fund
VILLAGE OF MOUNT PROSPECT
List of Bills
May 28 - June 10, 2015
Vendor Name
Invoice Description
Amount
Hayes/Open Water Dive/5.19/22/28.2015
440.00
Hayes- Peterson-Sch lenbecker/E RD 1/6.9.15
1,425.00
Dennison Leafblad, Deborah
Freelance Camera
300.00
Dimitrov, Dimitar
Refund Overpayment Police Ticket #C58997
25.00
Elite Remodeling Group, Inc.
Garnishment
142.22
Ellis Systems Corp
Maintenance agreement for Lektriever Series 8C
725.00
Eterno, David G.
May Billing
487.50
Eterno, Michael
Reimburse expenses: Lodging for LEIM conference for T. Griffin
640.12
Reimburse expenses: Lodging for IACP LEIM conference 05/17-20/15
640.12
Reimburse expenses: IACP LEIM Conference 05/17-21/15
88.00
Experian
Background checks - May, 2015
78.20
Factory Cleaning Equipment, Inc.
Equipment Maintenance
670.75
Part For Floor Scrubber -Station 14
157.82
Federal Express Corp
Shipping Expenses
20.31
Fifth Third Bank
Credit Card
5.00
Fire Pension Fund
Fire Pension
26,278.42
G & J Associates, Inc.
Banners for Fridays on the Green 2015
717.70
Summer Event 2015 Lobby Display Board
108.90
Gambino Landscaping and Brick Paving, Inc.
Sprinkler maintenance
112.25
Graceland College Center for Prof. Dev.
Training Expenses
149.00
Grainger Inc.
Maintenance and repair supplies
130.02
Repair Maintenance Supplies
409.95
Graybar Electric Co.
Streetlight Equipment
1,848.49
GreatAmerica Financial Services Corporation
Office equipment
149.47
Griffin, Timothy
Reimburse expenses: IACP LEIM Conf. 05/17-21/15 - meals & check-in fees
138.00
Reimburse expenses: SMIP training course 05/31-06/18/15 - airfair fees
29.04
Reimburse expenses: SMIP training course 05/31-06/18/15 - airfair fees
253.10
GTNL Group LLC
Food for Fridays on the Green 2015 - Emerson's
220.00
Guardian
Emp. Dental Plan June 2015
9,655.22
Halverson, Brian R.
EMS Licensing Reimbursement -Halverson
40.00
Harford, Michelle M.
Marketing MP Dish N Out Experience MP Fridays on Green 2015
1,260.00
HD Supply Const Supply Ltd
Engineering Supplies
813.10
Healy Asphalt Company,llc.
Streets Patching Materials
55.12
Streets Patching Materials
117.13
Streets Patching Materials
78.44
Streets Patching Materials
76.32
Asphalt materials used for street patching
79.50
Asphalt materials used for street patching
30.21
Streets Patching Materials
89.57
Streets Patching Materials
72.08
Streets Patching Materials
78.44
Asphalt materials used for street patching
80.03
Home Depot U.S.A., Inc.
Home Depot Statement -May 2015
151.74
Homer Tree Care, Inc.
Tree Removals
1,040.00
Tree Removals
493.00
Hoskinson, Thomas
Reimburse expenses: ET supplies
95.00
Hozian, Stephan P
Refund Overpayment Police Ticket #P3940571
20.00
ICMA Retirement Trust - 457
ICMA 457 (flat percent)
21,307.52
Illinois American Water Company
Private Fire Service 6/2/15 - 7/1/15
33.84
Illinois Assn. of Chiefs of Police
Register T. Janowick for Annual ILACP Conference
360.00
Illinois City/county Mgmt Assoc. (ilcma)
Strahl registration
241.75
Bertolucci membership
141.25
Illinois Department of Revenue
IL State Withholding
73.87
IL State Withholding
31,769.39
Illinois Fire Inspectors Association
2015 Dues -Loomis -Fire Investigators Strike Force
75.00
Illinois Landscape Contractors Assoc.
Membership Dues
395.00
Illinois State Police
Pre -Employment Testing - M. Mazurek, J. Caccavallo & M. Blesic
89.25
Infor Public Sector, Inc.
Hansen Quarterly Support
11,980.90
Internal Revenue Service
Federal Withholding
458.45
Federal Withholding
375.95
Federal Withholding
206,789.48
International Union of Operating Engineers
UOE PW Membership Dues
1,028.77
Jarog, Lynn M.
Travel & Meeting Expenses
147.85
Jem Metro Inc
Refund Building Fee Permit #15-0675 (1550 Dempster St)
50.00
John M. Bruns
Survey for 1112 N. Elmhurst Rd.
650.00
K. Fish Color LLC
Forestry Flowers
782.20
Forestry Flowers
1,764.20
Karlstedt Landscape Group, Inc.
Parkway sod restoration
248.68
Karr, Gerald
Refund for 2015 Spring Tree Planting Program
300.00
Kerstein, June
Reimbursement Food Exp - May 2015 Blood Drive
28.28
Page 2 of 9
Fund
VILLAGE OF MOUNT PROSPECT
List of Bills
May 28 - June 10, 2015
Vendor Name
Invoice Description
Amount
Kidd, Daniel
Reimburse training expenses: IDEOA conference 04/22-24/15
64.00
Klein, Thorpe and Jenkins, Ltd.
April Billing
48,814.98
Kowalczyk, Michele
Supplies for Dawson's Retirement
79.99
Kramer Tree Specialists
Grounds Maintenance
820.00
Grounds Maintenance
820.00
Tree Trimming
11,819.00
Tree Trimming
414.00
Lacey, Joy
Transfer Stamp Rebate
1,230.00
LAFORCE, INC.
New lock for Fire Station 13 back door
960.00
Mazursky, Shelby
Other Equipment
730.00
Mcmaster-carr Supply Co.
Other Equipment
145.92
McVeigh -Cushing, Cathleen A.
Edit Library Life May
600.00
Menard Inc.
Engineering Supplies
77.68
Metro Federal Credit Union
MP Fire Local 4119 Dues
2,239.38
Metropolitan Alliance - Police
MP Police Association Dues
1,349.50
Meyer Laboratory, Inc.
Custodial supplies used in all buildings
1,198.43
Micro Tech Systems, Inc.
Other Equipment
178.95
Middleton, Joan
GMIS Illinois meeting - 05/08/15
29.50
Milieu Design LLC
Landscape Maintenance
2,616.65
Mobile Print Inc.
Business Cards & Memo Pads - Dave Erb
85.77
Notepads/Business Cards (Lambel, Kowalczyk, Schuman)
121.73
Motion Ind. Inc.
Salt Spreader Parts
480.28
Mount Prospect Paint, Inc.
Maintenance and repair supplies
91.90
Maintenance and repair supplies
121.41
Maintenance and repair supplies
20.99
Maintenance and repair supplies
45.95
Maintenance and repair supplies
55.99
Maintenance and repair supplies
39.99
Maintenance and repair supplies
45.95
Maintenance and repair supplies
40.99
Maintenance and repair supplies
48.58
Murray and Trettel Inc.
Professional Services
2,100.00
Nationwide Mutual Insurance Company
Nationwide 457 (flat percent)
12,208.20
NCPERS Group Life Ins.
IMRF Life Ins - Elected Official
657.60
Neopost USA Inc.
Postage Machine Replenishment
3,000.00
NICOR
Natural Gas Consumption
31.93
Natural Gas Consumption
37.04
Natural Gas Consumption
37.54
Northern Illinois Funeral Service Inc.
Remains removal: 1530 W. Dempster #305 (J. Glombowski)
300.00
Remains removal: 702 Hackberry (J. Mischke)
405.00
Northern Illinois Police Alarm System
Language line - April, 2015 (#15-4919)
41.60
Northwest Central Dispatch System
July 2015 - Member Assessment
55,795.54
Northwest Suburban United Way
United Way
153.86
Novak, Todd
2015 Fire Uniform Allowance
103.90
Numbers Automation Inc
Annual maintenance agreement: Admin. shredder
150.00
Pacific Telemanagement Services
Period 6/1/15 - 6/30/15
78.00
Paddock Publications, Inc.
Bid Notice
106.65
Peterson, Bradley
2015 Fire Uniform Allowance
309.50
Petty Cash
Petty Cash -VMO - March, April, May 2015
405.45
Petty Cash May 2015
122.31
Picardi, James
Open House Supplies
12.30
Police Pension Fund
Police Pension
36,926.30
Quill Corporation
Office Supplies
129.99
Rebel's Trophies, Inc.
4 Service Plaques & 1 Resolution Plaque
460.00
Redlin, Ronald
2015 Fire Uniform Allowance
224.61
Rock River Arms Inc.
Weapons - PD Operations
1,570.00
Schlau, Steve
HVAC Repairs
3,058.00
Schuman, Jennifer
Cake for Lambel's Promotion
65.99
Schwan Inc
Refund Overpayment Police Ticket #P3939973
30.00
Schwandt, Alan
CDL Reimbursement
30.00
Secretary of State
A997344 - S-25 - 2015 License Plate Sticker Renewal
101.00
A997343 -1-30 - 2015 License Plate Sticker Renewal
101.00
Page 3 of 9
VILLAGE OF MOUNT PROSPECT
List of Bills
May 28 - June 10, 2015
Fund Vendor Name
Invoice Description
Amount
Secretary of State
A997342- 1-29-2015 License Plate Sticker Renewal
101.00
H511755- 1-28-2015 License Plate Sticker Renewal
101.00
A997340 -1-24 - 2015 License Plate Sticker Renewal
101.00
A997346 -1-23 - 2015 License Plate Sticker Renewal
101.00
A997345 -1-22 - 2015 License Plate Sticker Renewal
101.00
SHI International Corp.
iPad/Case for PD D/C
84.00
iPad/Case for PD D/C
550.00
Sid Tool Co., Inc.
Sign Making Materials
428.03
Sikich LLP
Professional Services Rendered through 4/30/15
15,750.00
Standard Equipment Company
2725 tachometer for aux engine
314.85
2738 fill tube
102.33
4504 A/C drier
225.71
4504 A/C expansion valve
127.37
State of Illinois
Internet Service
1,111.25
Stephen A. Laser Assoc.,p.c.
Pre-employment testing - J. Mattix
550.00
Systems Forms, Inc.
Printing Rental Inspection Forms
201.45
T.P.1.
Building Inspections
27,373.00
Tabic, Miron
Rebate Sidewalk Shared Program
312.50
Thanopoulos, Marianthi
Dinner Sister Cities Commission Meeting 5-21-15
13.10
Lunch Marketing Meeting MECO June 2015
34.64
The Carroll -Keller Group
Leading & Managing Through Change Workshop - 6/3/2015
4,400.00
The Sign Palace, Inc.
Replacement Street Furniture
2,025.00
Equipment
675.00
Theodore Polygraph Service Inc.
Pre -Employment Testing- M. Blesic
175.00
Third Millennium Assoc.inc.
Post Lock Box Fulfillment
17,632.64
Vehicle Follow-up Mailing
3,450.00
Thompson Elevator Inspections
Elevator Inspections
1,295.00
Elevator Inspections
148.00
Elevator Inspections
2,147.00
Elevator Inspections
150.00
Township of Maine
Two Maine Township agency directories
10.00
TransUnion Risk and Alternative Data Solutions Inc
Background checks - May, 2015
110.25
Tree Care Industry Association
Subscription renewal
24.95
United Health Care
Refund for Ambulance Service - 4/6/15
92.49
United Maintenance Company, Inc.
Special Events
1,347.00
VCG Uniform
Hamann Initial Issue
1,589.90
Verizon Wireless Services LLC
Cellular Service & Equipment Charges - April 20 -May 19
7,187.64
Village of Mount Prospect
Flex - Medical
9,620.51
Warehouse Direct
Cash Register Receipt Paper
65.32
Wide Open West
WOW Internet services
65.36
W ISCTF
Garnishment
542.48
Wisconsin Department of Revenue
WI State Withholding
438.17
Wulbecker, Jeffrey
Open House Supplies
73.90
Z Search Recruiting, Inc.
Photography- Elected Officials' Reception 5515
400.00
Photography - Zarnek - Public Works Open House 2015
250.00
Zaloudek, Ron
Rebate Sidewalk Shared Program
875.00
001 General Fund Total
$
721,025.42
002 Debt Service Fund
Bank of New York Mellon
2009 GO Bond Interest Payment
$
208,631.25
2009B GO Bond Interest Payment
39,175.00
2014 GO Bond Interest
89,625.00
2013 GO Bond Interest Payment
184,978.13
2009C GO Bond Interest Payment
67,136.25
Glenview State Bank
2012 Installment Note Interest Payment
10,647.00
J.P. Morgan Chase Bank N.A.
2011B GO Bond Interest Payment
54,873.00
2012 GO Bond Interest Payment
27,047.50
Library 2011A Bond Interest Payment
15,968.75
Wells Fargo Bank
Library 2006 Bond Interest Payment
190,708.75
002 Debt Service Fund Total
$
888,790.63
020 Capital Improvement Fund
Business Office Systems, Inc.
Office Furniture
$
8,373.00
Office Furniture
6,969.00
CS2 Design Group, LLC
Professional services overseeing HVAC construction phase
2,036.53
Northwest Central 9-1-1 System
Motorola Subscriber Financing - June 2015
10,603.91
Shawn Martin McGovern
Kitchen Backsplash and Install for Station 13
1,882.00
020 Capital Improvement Fund Total
$
29,864.44
Page 4 of 9
VILLAGE OF MOUNT PROSPECT
List of Bills
May 28 - June 10, 2015
Fund Vendor Name Invoice Descrintion Amount
022 Downtown Redevelopment Construction Fund
Milieu Design LLC
Landscape Maintenance
$
6,338.17
Tetra Tech, Inc.
Tetra Tech Services
5,473.51
022 Downtown Redevelopment Construction Fund Total
$
11,811.68
023 Street Improvement Construction Fund
Alley, Donna & Dennis
Refund Vehicle License Fee
$
40.00
Arrow Road Construction
Street Resurfacing
512,803.37
Bredemann, Arnie
Refund Overpayment Vehicle Sticker Fee
20.00
Henquinet, Rich
Refund Vehicle License Fee
40.00
McGovern, Miroslawa
Refund Overpayment Vehicle Sticker Fee
25.00
Quality Blacktop LLC
Retainage Release from 2014
3,794.30
Retainage Release from 2014
1,310.40
Shaw Jr., Warner
Refund Overpayment Vehicle Sticker Fee
25.00
023 Street Improvement Construction Fund Total
$
518,058.07
024 Flood Control Construction Fund
A Lamp Concrete
Isabella Drainage Improvements Project
$
311,365.47
Burns & Mcdonnell Engineering Co.
Engineering Service
23,166.83
Engineering Service
43,714.33
Constellation NewEnergy, Inc.
Electrical Service Delivery
90.53
Electrical Service Delivery
85.45
024 Flood Control Construction Fund Total
$
378,422.61
040 Refuse Disposal Fund
ARC Disposal Company
Refuse Disposal Program
$
923.79
AT&T
Service 5/16/15 - 6/15/15
15.44
Griffin, James
Refund for Refuse Bins
25.00
Groot Industries, Inc.
Refuse Disposal Program
533.53
ICMA Retirement Trust - 457
ICMA 457 (flat percent)
71.81
Illinois Department of Revenue
IL State Withholding
331.28
Internal Revenue Service
Federal Withholding
3,120.34
International Union of Operating Engineers
UOE PW Membership Dues
99.25
Nationwide Mutual Insurance Company
Nationwide 457 (flat percent)
235.48
NCPERS Group Life Ins.
IMRF Life Ins - Elected Official
17.60
Village of Mount Prospect
Flex - Medical
71.88
040 Refuse Disposal Fund Total
$
5,445.40
041 Motor Fuel Tax Fund
Commonwealth Edison
Electrical Service Delivery
$
762.29
Electrical Service Delivery
685.51
Electrical Service Delivery
971.71
Constellation NewEnergy, Inc.
Electrical Service Delivery
10,853.53
Electrical Service Delivery
233.50
Electrical Service Delivery
326.32
Electrical Service Delivery
57.09
Electrical Service Delivery
1,933.85
Electrical Service Delivery
230.23
Electrical Service Delivery
92.68
Electrical Service Delivery
106.50
Electrical Service Delivery
112.91
Electrical Service Delivery
96.65
Electrical Service Delivery
46.94
Electrical Service Delivery
98.36
Electrical Service Delivery
67.00
Electrical Service Delivery
137.76
Gewalt Hamilton Assoc.
Engineering Services
6,735.28
V3 Companies
Traffic Signal Replacement
4,106.50
041 Motor Fuel Tax Fund Total
$
27,654.61
042 Community Development Block Grant
Arthur Weiler, Inc.
Parkway Tree Planting
$
5,567.00
ICMA Retirement Trust - 457
ICMA 457 (flat percent)
450.00
Illinois Department of Revenue
IL State Withholding
68.59
Internal Revenue Service
Federal Withholding
589.88
Village of Mount Prospect
Flex - Medical
31.25
042 Community Development Block Grant Total
$
6,706.72
050 Water and Sewer Fund
Page 5 of 9
VILLAGE OF MOUNT PROSPECT
List of Bills
May 28 - June 10, 2015
Fund Vendor Name
Invoice Description
Amount
Addison Building Material Co.
Maintenance and repair supplies
$
7.27
Repair Maintenance Supplies
8.69
American Water Works Assoc.
Repair Maintenance Supplies
329.00
Angela Beal
Utility Refund - 2833 Briarwood Dr
69.58
APWA-IPSI
Travel and Meeting Expenses
695.00
Aramark Uniform Services, Inc.
Uniform cleaning and rental for Public Works employees
100.34
Uniform Cleaning and Rental
100.34
Uniform cleaning and rental for Public Works employees
100.34
Uniform Cleaning and Rental
100.34
AT&T
Service 5/16/15 - 6/15/15
1,030.45
Baxter & Woodman, Inc.
Professional Services
12,955.00
Professional Services
1,170.00
SCADA Wireless
1,874.50
Flow Monitoring
5,692.02
Capital One National Association
Costco Purchase 4/28/15 - 5/19/15
354.14
Central Continental Bakery
Other Employee Expenses
44.55
Century Cleaners
Uniform Cleaning
14.12
Uniform Cleaning
14.57
Uniform Cleaning
13.67
Uniform Cleaning
23.15
Uniform Cleaning
23.67
Uniform Cleaning
20.50
Uniform Cleaning
14.12
Uniform Cleaning
12.75
Uniform Cleaning
19.57
Uniform Cleaning
14.57
Charles L. Pierce
Utility Refund - 1406 Chestnut Dr
8.66
Cheryl Trunda
Utility Refund - 322 Marcella Rd
1,500.00
Commonwealth Edison
Emergency Generators
8,543.81
Daniel Phillips
Utility Refund - 602 S Maple St
39.76
Edward Schafer
Utility Refund - 2836 Briarwood Dr
761.05
Eunseo Cho
Utility Refund - 610 St Cecilia Dr
10.60
Filippo Citrano
Utility Refund - 501 Russel St
179.80
Gabe Martinez
Utility Refund - 607 W Rand Rd
56.79
Grainger Inc.
Repair Maintenance Supplies
50.50
Repair Maintenance Supplies
161.20
Hach Company
Water Treatment Chemicals
855.03
HBK Water Meter Service
Water Meter Installations
6,913.25
ICMA Retirement Trust - 457
ICMA 457 (flat percent)
1,292.01
Illinois Department of Revenue
IL State Withholding
2,610.69
Internal Revenue Service
Federal Withholding
21,799.79
International Union of Operating Engineers
UOE PW Membership Dues
990.49
Jennifer LJackolin
Utility Refund - 401 Larkdale Ln
1,200.00
John Kosmatka
Utility Refund - 220 S Mt Prospect Rd
1.72
Joseph Paglini
Utility Refund - 907 S Emerson St
301.83
Karlstedt Landscape Group, Inc.
Parkway sod restoration
2,347.17
Layne Christensen Company
Deep Well Oiler Improvements
6,689.00
Milieu Design LLC
Landscape Maintenance
3,120.18
M U N I PLY LLC.
AMR System
12,955.00
Nationwide Mutual Insurance Company
Nationwide 457 (flat percent)
420.89
NCPERS Group Life Ins.
IMRF Life Ins - Elected Official
52.80
Northwest Suburban United Way
United Way
21.00
Paddock Publications, Inc.
Bid Notice
72.90
Quality Blacktop LLC
Retainage Release from 2014
2,195.80
Red Wing Shoe Store
Safety Shoe Purchase
157.49
Richard Zigante (trust)
Utility Refund - 107 Fairview Ave
46.08
Sikich LLP
Professional Services Rendered through 4/30/15
5,250.00
Smith Ecological Systems, Inc.
Water Treatment Chemicals
589.30
The Ups Store
Shipping Expenses
16.52
Shipping Expenses
13.50
United States Postal Service
Caller/Reserve Service #4297 (6/30/15 - 6/30/16)
1,132.00
Verizon Wireless Services LLC
Cellular Service & Equipment Charges - April 20 -May 19
597.79
Village of Mount Prospect
Flex - Medical
715.02
Visu-sewer of Illinois, LLC.
Combined Sewer Improvements
21,649.83
Combined Sewer Improvements
76,882.14
Warehouse Direct
Office Supplies
58.34
050 Water and Sewer Fund Total
$
207,061.98
051 Village Parking System Fund
Crystal Maintenance Services Corp.
Janitorial services at 8 buildings for the month of June
$
330.23
Page 6 of 9
VILLAGE OF MOUNT PROSPECT
List of Bills
May 28 - June 10, 2015
Fund Vendor Name
Invoice Description
Amount
Elite Remodeling Group, Inc.
Garnishment
78.19
ICMA Retirement Trust - 457
ICMA 457 (flat percent)
8.99
Illinois Department of Revenue
IL State Withholding
40.72
Internal Revenue Service
Federal Withholding
326.47
International Union of Operating Engineers
UOE PW Membership Dues
15.21
Nationwide Mutual Insurance Company
Nationwide 457 (flat percent)
9.95
NCPERS Group Life Ins.
IMRF Life Ins - Elected Official
4.40
Petty Cash
Petty Cash May 2015
2.00
Village of Mount Prospect
Flex - Medical
34.64
051 Village Parking System Fund Total
3.60
$ 850.80
052 Parking System Revenue Fund
Crystal Maintenance Services Corp.
Janitorial services at 8 buildings for the month of June
$
252.53
Elite Remodeling Group, Inc.
Garnishment
64.02
ICMA Retirement Trust - 457
ICMA 457 (flat percent)
6.02
Illinois Department of Revenue
IL State Withholding
29.96
Internal Revenue Service
Federal Withholding
239.67
International Union of Operating Engineers
UOE PW Membership Dues
10.17
Nationwide Mutual Insurance Company
Nationwide 457 (flat percent)
6.66
NCPERS Group Life Ins.
IMRF Life Ins - Elected Official
3.60
NICOR
Natural Gas Consumption
66.50
Petty Cash
Petty Cash May 2015
10.00
Village of Mount Prospect
Flex - Medical
27.44
052 Parking System Revenue Fund Total
$
716.57
060 Vehicle Maintenance Fund
Arlington Heights Ford
526 Vacuum pump
$
173.25
526 engine belts
113.34
P-3 instrument cluster
354.65
Police CV air bag Jewels
25.28
AT&T
Service 5/16/15 - 6/15/15
38.59
Atlas First Access, LLC
Vehicle Maintenance Supplies
419.83
BP
Gas Purchased 5/20/15
161.29
Chicago Parts & Sound Llc
P-5 front brake rotors
139.96
Police Crown Vic brake rotors
215.92
Police Crown Vic A/C accumulator, brake fluid & P-37 front brake
352.63
EJ Equipment
Equipment Maintenance and Repair
195.84
General Parts Inc.
4514 rear glass shocks
40.54
A/C dye and brake lube
120.29
Global Emergency Products
530 A/C condenser fans and turn signal switch
769.23
ICMA Retirement Trust - 457
ICMA 457 (flat percent)
1,137.63
Illinois Department of Revenue
IL State Withholding
1,220.18
Inland Power Group Inc.
Air and transmission filters
432.22
Internal Revenue Service
Federal Withholding
10,213.82
International Union of Operating Engineers
UOE PW Membership Dues
474.38
Interstate Battery
Battery
87.95
Leach Enterprises, Inc.
Vehicle Maintenance Supplies
80.35
Mcmaster-carr Supply Co.
Rubber bumpers, grommets and sealing washers
50.36
Vehicle Maintenance Supplies
66.34
Morton Grove Automotive
2727 alternator
185.00
Napa -Heights Automotive Supply
Trailer wire adapters
25.36
Headlight bulbs
27.24
307 Pinion seal and spacer
12.98
NCPERS Group Life Ins.
IMRF Life Ins - Elected Official
48.00
Northwest Suburban United Way
United Way
4.00
Palatine Oil, Inc.
8,003 gallons gasoline
18,584.65
Precision Service & Parts
P-39 A/C line
114.51
P-18 front brake calipers
158.84
526 idler pulley
33.79
P-1 water pump and idler pulley
103.45
Ronco Industrial Supply
Vehicle Maintenance Supplies
93.60
Vehicle Maintenance Supplies
78.78
Rush Truck Centers of Illinois, Inc.
Power steering filters
126.40
Vehicle Maintenance Supplies
(63.84)
2728 throttle cable
59.56
2753 OEM Rear brake shoes, drums and chambers
1,243.72
2753 rear brake shields
74.44
Terrace Supply Company
Gas Tank Rental
23.80
Gas Tank Rental
26.35
Equipment Rental
26.04
Page 7 of 9
VILLAGE OF MOUNT PROSPECT
List of Bills
May 28 - June 10, 2015
Fund Vendor Name
Invoice Description
Amount
Gas Rental
36.07
$
Acettylene and oxygen gas
91.75
Vehicle Maintenance Supplies
98.59
063 Risk Management Fund
Vehicle Maintenance Supplies
42.02
Open House Supplies
574.25
$
Vehicle Maintenance Supplies
58.00
New Fire 515, Siren repair from Accident 5/4 -Chrome siren grill
Torch acetylene and oxygen gas
166.70
Intergovernmental Per.ben.coop
Vehicle Maintenance Supplies
42.50
496,291.84
Vehicle Maintenance Supplies
129.69
$
Vehicle Maintenance Supplies
69.00
Verizon Wireless Services LLC
Cellular Service & Equipment Charges - April 20 -May 19
376.52
Village of Mount Prospect
Flex - Medical
350.02
Warehouse Direct
Office Supplies
58.35
West Side Tractor Sales
John Deere oil, fuel and air filters
253.15
Wholesale Direct Inc.
Vehicle Maintenance Supplies
40.08
060 Vehicle Maintenance Fund Total
Annual Evaluation & Examination - J. Czarnecki (2/25/15)
$ 40,257.23
061 Vehicle Replacement Fund
Foster Coach Sales Inc.
Equipment for Fire Dept. Vehicles
$
159.64
061 Vehicle Replacement Fund Total
$
159.64
063 Risk Management Fund
Arthur J. Gallagher Rms, Inc.
Excess Workers Compensation (Audit Additional Premium)
$
3,847.00
Global Emergency Products
New Fire 515, Siren repair from Accident 5/4 -Chrome siren grill
316.41
Intergovernmental Per.ben.coop
IPBC - June 2015
496,291.84
063 Risk Management Fund Total
$
500,455.25
070 Police Pension Fund
Internal Revenue Service
Federal Withholding
$
48,106.60
Lauterbach & Amen, LLP
Pension Services Administration - April 2015
1,315.00
Pension Services Administration -January 2015
1,315.00
William C. Malik, M.D.
Annual Evaluation & Examination - J. Czarnecki (2/25/15)
650.00
Annual Evaluation & Examination - J.Favia (2/25/15)
650.00
070 Police Pension Fund Total
$
52,036.60
071 Fire Pension Fund
Internal Revenue Service
Federal Withholding
$
44,018.87
Lauterbach & Amen, LLP
Pension Services Administration - April 2015
1,500.00
Pension Services Administration -January 2015
1,500.00
071 Fire Pension Fund Total
$
47,018.87
073 Escrow Deposit Fund
Capps Plumbing and Sewer Inc
Refund Escrow Permit # 15-0748 (308 N Emerson St)
$
125.00
Carlson, Stephan
Refund Escrow Permit # 15-0300 (624 George St)
200.00
Citgo Petroleum Corp
Refund Escrow Permit # 14-2194 (2316 Terminal Dr)
125.00
Cull, Joanne M
Refund Escrow Permit # 15-0448 (905 Burning Bush Ln)
200.00
Devlin, Catherine
Refund Escrow Permit # 14-2536 (204 N Main St)
100.00
EI Sombrero Restaurant
Refund Escrow Permit # 15-0550 (1100 S Elmhurst Rd)
125.00
Espinoza Twin Brothers Landscaping Inc
Refund Escrow Permit #15-0697 (613 St Cecilia Dr)
200.00
Four Seasons Heating and A/C
Refund Escrow Permit # 14-2077 (1108 W Busse Ave)
75.00
Refund Escrow Permit # 14-2555 (620 Albion Ln)
75.00
Refund Escrow Permit # 15-0761 (204 N Main St)
125.00
Heidorn, Richard
Refund Escrow Permit # 15-0355 (1747 Wood Ln)
125.00
Hempelman, James
Refund Escrow Permit # 15-0432 (305 S Albert St)
200.00
Highland Park Electric
Refund Escrow Permit # 15-0428 (1408 Park Dr)
125.00
Home Depot
Refund Escrow Permit # 14-1086 (16 Hi Lusi Ave)
300.00
Jem Metro Inc
Refund Escrow Permit # 15-0675 (1550 Dempster St)
125.00
JRC Construction
Refund Escrow Permit # 14-1719 (19 N Emerson St)
600.00
Kim, Jingu
Refund Escrow Permit # 14-0634 (122 S Wille St)
300.00
Kunstman, Mary E
Refund Escrow Permit # 14-1892 (801 S Deborah Ln)
200.00
Lakes Venture LLC
Refund Escrow Permit # 13-1034 (211 W Rand Rd)
25,000.00
LaPelusa Home Improvement Inc
Refund Escrow Permit # 14-2170 (501 S Wille St)
500.00
Naper Lawn Works Inc
Refund Escrow Permit # 15-0328 (805 Hi Lusi Ave)
200.00
Perma Seal Basement Systems
Refund Escrow Permit # 15-0531 (1322 W Central Rd)
125.00
Petlicki, Rebecca
Refund Escrow Permit # 15-0124 (502 S Main St)
350.00
Professional Paving & Concrete
Refund Escrow Permit # 14-2351 (920 N Elmhurst Rd)
125.00
RDR Remodeling Inc
Refund Escrow Permit # 14-1555 (526 Hill St)
75.00
Roto Rooter
Refund Escrow Permit # 15-0708 (800 Deborah Ln)
125.00
Runde, Terrance
Refund Escrow Permit # 15-0463 (1222 W Robin Ln)
200.00
Sandquist, Helmut R
Refund Escrow Permit # 14-2511 (1914 E Ivy Ln)
125.00
Page 8 of 9
Fund Vendor Name
Sankovich, Charles & Mary Ann
Third District Circuit Court
Wolak, Cathy A
073 Escrow Deposit Fund Total
Grand Total
VILLAGE OF MOUNT PROSPECT
List of Bills
May 28 - June 10, 2015
Invoice Descri
Refund Escrow Permit # 15-0455 (400 S I Oka Ave)
Bond Check 5/28/15
Bond Check 6/2/15
Bond Check 6/4/15
Bond Check 6/9/15
Refund Escrow Permit # 15-0226 (711 Na Wa Ta Ave)
Page 9 of 9
Amount
200.00
700.00
900.00
1,305.00
525.00
150.00
33,930.00
$ 3,470,266.52