HomeMy WebLinkAbout3. Monthly Financial Report & Approve Bills 06/17/2014Village of Mount Prospect
Mount Prospect, Illinois
INTEROFFICE MEMORANDUM
TO: VILLAGE PRESIDENT AND BOARD OF TRUSTEES
FINANCE COMMISSION
FROM: FINANCE DIRECTOR
DATE: JUNE 13, 2014
SUBJECT MONTHLY FINANCIAL REPORT — MAY 2014
Attached hereto are the cash position and investment statements of the Village for the month
ended May 31, 2014. 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 (Pape 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 $39.4
million. During May, cash receipts totaled $4,753,415. In addition investment income for the
month was $1,797 and transfers from investments to cash totaled $7,592,171. Reductions to
cash and cash equivalents during May totaled $7,682,802. Of this amount, payments to vendors
were $6,394,918 and employee payroll and related expenses were $1,279,308. Other
disbursement totaled $8,576. Cash and cash equivalents at May 31 were $44.1 million.
Monthly Financial Report — May 2014
June 13, 2014
Page 2
Investments in the Governmental and Enterprise Funds at April 30 were $15.7 million. CD's
that matured during May totaled $7,592,171. Proceeds were returned to cash. CD's in the
Governmental and Enterprise Funds reside in the Street and Flood Control Funds and were
purchased using proceeds from the Series 2013 and Series 2014 bond issues. The maturity
dates of the CD's are laddered to match the expected payout schedule of the underlying flood
control and street resurfacing work. Total investments at May 31 were $8,078,285.
Total cash and investments for Governmental and Enterprise Funds at April 30 were
$55,042,866. Cash and investments at May 31 totaled $52,170,227. This is a decrease of
$2,872,639 for the month.
Trust and Agency Funds - Cash and cash equivalents at April 30 was $6.0 million. During
May, cash receipts totaled $199,712. In addition investment income was $34,996. There was
also a net increase in cash due to investment activities of $345,402. Reductions to cash and
cash equivalents during May totaled $794,414. Of this amount, payments to vendors were
$232,887, employee payroll and related expenses were $542,301, and payments related to the
flexible spending program totaled $17,289. Cash and cash equivalents at May 31 were $5.8
million.
Total investments at May 31 were $107,217,799, an increase of $762,049 from April 30.
Investment income was $1,107,452 while net transfer out totaling $345,403 accounted for the
change.
Total cash and investments for Trust and Agency Funds at April 30 were $112,478,962. Cash
and investments at May 31 totaled $112,973,927. This is an increase of $494,965 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 $9,597,294. During May, cash
receipts totaled $2,498,944 and investment income was $130. Significant cash receipts
included sales and income taxes.
Sales tax revenues for the month totaled $954,328. Of this amount, $869,800 was
generated from the 1 % state portion while $84,528 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.
Monthly Financial Report — May 2014
June 13, 2014
Page 3
State income tax receipts for May totaling $301,664 was for March. The state continues to
be 2 -3 months delinquent in making these remittances to the Village. The state is currently
$1.4 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,240,154,
payments for employee wages and benefits of $1,127,140 and other adjustments totaled
$8,576. Interfund transfers of $831,515 for health premiums and vehicle lease and
maintenance payments were also made during the month.
Cash and cash equivalents at May 31 were $8,888,984. There were no investments in the
General Fund at May 31.
Statement of Investments (Pacies 3-4)
This report provides a breakdown of investments by governmental and enterprise funds and
trust and agency funds. The report also provides a fund -by fund breakdown of the investments.
Government and Enterprise Funds - The investments for the governmental and agency funds
are made up solely of certificates of deposit. - Certificates of deposit have maturities of between
56 and 331 days from date of purchase and are currently placed with several banks through our
financial advisor, PMA. A detailed listing of the CD's currently held can be found on pages three
and four of the financials following this summary write -up.
Return on the portfolio of CD's range from 10 to 35 basis points. The portfolio return remains
low on all types of investments available to municipalities (typically certificate of deposits,
money market- accounts and short-term treasuries).
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 pension
funds also have a small portion of their portfolio invested in international stocks. Each year the
investment mix is evaluated for optimal diversification to meet the pension funds investment
policy goals and objectives. 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.
Monthly Financial Report — May 2014
June 13, 2014
Page 4
Maturity Purchase Financial
Date Date Institution
POLICE PENSION FUND (070)
Various Various Wells Fargo
Various Various Various
Investment
CUSIP/
Interest
Market
Description
Acct #
Rate %
Value
Wells Fargo Investments
Various
Various
$ 22,600,184.55
Mutual Fund Investments
Various
Various
32,226,741.72
54,826,926.27
FIRE PENSION FUND (071)
Various Various Wells Fargo
Various Various Various
TOTAL TRUST AND AGENCY FUND INVESTMENTS
Wells Fargo Investments Various Various 20,059,919.80
Mutual Fund Investments Various Various 32,330,953.29
52,390,873.09
$ 107,217,799.36
Investment of the Village's pension funds is governed by an Investment Policy adopted by each
Pension Board. The investment policy for both the pension funds was updated in January 2011.
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. Over time, this report will be able to provide
trend information to help in cash management duties, maximizing investment earnings while
ensuring availability of funds to meet the Village's commitments.
David O. Erb
Finance Director
VILLAGE OF MOUNT PROSPECT
Preliminary Cash and Investment Position Report - All Funds
For the Month Ended May 31, 2014
GOVERNMENTAL AND ENTERPRISE FUNDS
TRUST AND AGENCY FUNDS *
Cash and Cash
Equivalents
Balance at April 30, 2014 $ 6,023,212.35
Investments
$ 106,455,749.56
Cash receipts
Cash and Cash
Investment income (loss)
Total Cash and
Transfers from investments to cash
Equivalents
Investments
Investments
Balance at April 30, 2014
$ 39,374,581.12
$ 15,668,285.08
$ 55,042,866.20
Cash receipts
4,753,414.65
4,753,414.65
Investment income
1,796.53
2,171.04
3,967.57
Transfers from investments to cash
7,592,171.04
(7,592,171.04)
-
Transfers to investments from cash
-
-
-
Interfund activity
52,780.53
52,780.53
Disbursements:
Accounts payable
(6,394,917.94)
(6,394,917.94)
Payroll
(1,279,308.05)
(1,279,308.05)
Other
(8,575.51)
8 „5(� 75.51
Balance at May 31, 2014
$ 44,091,942.37
$ 8,078,285.08
$ 52,170,227.45
TRUST AND AGENCY FUNDS *
Cash and Cash
Equivalents
Balance at April 30, 2014 $ 6,023,212.35
Investments
$ 106,455,749.56
Cash receipts
199,712.44
Investment income (loss)
34,995.75 1,107,452.35
Transfers from investments to cash
4,011,686.30 (4,011,686.30)
Transfers to investments from cash
(3,666,283.75) 3,666,283.75
Interfund activity
(52,780.53)
Disbursements:
Accounts payable
Payroll
Flex spending
Other
Balance at May 31, 2014
(232,887.42)
(542,300.68)
(17,289.12)
(1,937.47)
Total Cash and
Investments
$ 112,478,961.91
199,712.44
1,142,448.10
(52,780.53)
(232, 887.42)
(542,300.68)
(17,289.12)
(1,937.47)
$ 5,756,127.87 $ 107,217,799.36 $ 112,973,927.23
* Assets are restricted in purpose and do not represent discretionary assets of the government.
1
N
VILLAGE OF MOUNT PROSPECT
Summary of Cash Activity by Fund Type
For the Month Ended May 31, 2014
INVESTMENTS
Certificates of deposit - - 3 8,078,285.08 - _ 8,078,285.08 - - 8,078,285.08
Wells Fargo investments - _ - - g 42,660,104.35 - 42,660,104.35
Mutual fund investments - Q m - - - 64.557,69 - 64,557,695.01
Total investments - - 8 078,285.08 - 8,078,285.08 107,217.799.36 115,296,084.44
TOTAL CASH AND INVESTMENTS S 8,888,984.01 $$ 3.231,616.17 $ 5071,901.31 $ 22,742,471.58 $ 6,218,919.60 $ 10,580,334.58 $ 52,170,227.45 $111,463,037.57 $ 1,510,889.66 $165,144,154.68
* Assets are restricted in purpose and do not represent discretionary assets of the government.
GOVERNMENTAL AND ENTERPRISE FUNDS
TRUST AND AGENCY FUNDS *
SPECIAL
CAPITAL
TOTAL GOVT.
FIRE AND
OTHER TRUST
REVENUE
DEBT SERVICE PROJECTS
ENTERPRISE
INTERNAL
AND ENTERPRISE
POLICE
AND AGENCY
GENERAL FUND
FUNDS
FUNDS FUNDS
FUNDS
SERVICE FUNDS
FUNDS
PENSIONS
FUNDS
TOTAL
CASH 8: CASH EQUIVALENTS
Beginning balance
$ 9,597,294.04 $
2,768,270.52
$ 1,163,695.99 $ 8,519,516.96
$ 6,257,751.06
$ 11,068,052.55
$ 39,374,581.12
$ 4,506,464.06
$ 1,516,748.29
$ 45,397,793.47
Cash receipts
2,498,943.96
643,260.30
94,244.56 374,805.71
942,312.19
199,847.93
4,753,414.65
117,015.96
82,696.48
4,953,127.09
Investment income
129.95
74.71
9.29 578.76
147.63
856.19
1,796.53
34,828.17
167.58
36,792.28
Transfers from investments
Transfers to investments
-
-
- 7,592,171.04
-
-
7,592,171.04
4,011,686.30
-
11,603,857.34
Interfund
(831,514.66)
_
235,059.64
-
- _
(169,064.42)
818,299.97
52,780.53
(3,666,283.75)
(40,166.53)
-
(12,614.00)
(3,666,283.75)
(0.00)
Disbursements - other
(8,575.51)
-
- Y
_
_
(8,575.51)
_
(1,937.47)
(10,512.98)
Disbursements - flexible spending
-
-
-
-
-
-
-
(17,289.12)
(17,289.12)
Disbursements - payroll
(1,127,140.18)
(12,270.36)
- _
(93,316.23)
(46,581.28)
(1,279,308.05)
(542,300.68)
-
(1,821,608.73)
Disbursements - accounts payable
(1,240,153.59) (402,778.64)
(750,048.53) (1,822,885.97)
(718,910.43)
(1,460,140.78)
(6,394,917.94)
176,005.32)
(56,882.10)
(6,627,80536)
Ending balance
8,888,984.01
3,231.616.17
507,901.31 14,664.186.50
6,218,919.60
10,580,334.58
44,091,942.37
4,245,236.21
1,510,889.66
49,848,070.24
INVESTMENTS
Certificates of deposit - - 3 8,078,285.08 - _ 8,078,285.08 - - 8,078,285.08
Wells Fargo investments - _ - - g 42,660,104.35 - 42,660,104.35
Mutual fund investments - Q m - - - 64.557,69 - 64,557,695.01
Total investments - - 8 078,285.08 - 8,078,285.08 107,217.799.36 115,296,084.44
TOTAL CASH AND INVESTMENTS S 8,888,984.01 $$ 3.231,616.17 $ 5071,901.31 $ 22,742,471.58 $ 6,218,919.60 $ 10,580,334.58 $ 52,170,227.45 $111,463,037.57 $ 1,510,889.66 $165,144,154.68
* Assets are restricted in purpose and do not represent discretionary assets of the government.
VILLAGE OF MOUNT PROSPECT
STATEMENT OF INVESTMENTS
As of May 31, 2014
GOVERNMENTAL AND ENTERPRISE FUNDS
Maturity
Purchase
Financial
Investment
CUSIP/
Interest
Market
Date
Date
Institution
Description
FDIC #
Rate %
Value
POLICE PENSION FUND (070)
STREET IMPROVEMENT CONSTRUCTION FUND (23)
Various
08/01/14
02/05/14
Citizens Community Bank, VA
Certificate of Deposit
35326
0.140%
249,800.00
08/12/14
02/12/14
Compass Bank
Certificate of Deposit
N/A
0.150%
240,000.00
08/14/14
02/14/14
Bank ofBaroda
Certificate of Deposit
N/A
0.150%
249,185.08
09/02/14
02/05/14
Bar Harbor Bank & Trust, ME
Certificate of Deposit
11971
0.154%
95,000.00
833,985.08
FLOOD CONTROL CONSTRUCTION FUND (024)
07/01/14
01/22/14
Citibank - IIVIMA Term, IL
Certificate of Deposit
7213
0.100%
1,500,000.00
07/22/14
01/21/14
Bank of Virginia, VA
Certificate of Deposit
57627
0.151%
249,800.00
08/01/14
01/22/14
Citibank -IMMA Term, IL
Certificate of Deposit
7213
0.120%
1,750,000.00
09/02/14
01/22/14
Citibank -IMMA Term, IL
Certificate of Deposit
7213
0.120%
500,000.00
09/18/14
01/21/14
Banco Popular North Amer, IL
Certificate of Deposit
34967
0.120%
84,000.00
09/18/14
01/21/14
Banco Popular North Amer, IL
Certificate of Deposit
34967
0.120%
83,000.00
09/18/14
01/21/14
Banco Popular North Amer, IL
Certificate of Deposit
34967
0.120%
82,700.00
09/18/14
01/21/14
Essex Bank, VA
Certificate of Deposit
8675
0.120%
249,800.00
09/18/14
01/21/14
Landmark Community Bank, TN
Certificate of Deposit
34982
0.121%
249,700.00
09/18/14
01/21/14
Orrstown Bank, PA
Certificate of Deposit
713
0.120%
249,700.00
10/20/14
01/21/14
Bank Leumi USA, NY
Certificate of Deposit
19842
0.150%
249,700.00
10/20/14
01/21/14
Cole Taylor Bank (N), IL
Certificate of Deposit
22599
0.200%
249,600.00
10/20/14
01/21/14
IDB Bank, NY
Certificate of Deposit
19977
0.151%
249,700.00
10/20/14
01/21/14
Republic Bank of Chicago, IL
Certificate of Deposit
19333
0.150%
249,700.00
11/18/14
01/21/14
Bank of China, NY
Certificate of Deposit
33653
0.207%
249,200.00
11/18/14
01/21/14
Bank of Houston, TX
Certificate of Deposit
57965
0.150%
249,600.00
11/18/14
01/21/14
State Bank of India, NY
Certificate of Deposit
33682
0.159%
249,600.00
12/18/14
01/21/14
Far East National Bank, CA
Certificate of Deposit
21851
0.350%
249,200.00
12/18/14
01/21114
Onewest Bank FSB, CA
Certificate of Deposit
58978
0.300%
249,300.00
7,244,300.00
TOTAL GOVERNMENTAL AND ENTERPRISE FUNDS $ 8,078,285.08
TRUST AND AGENCY FUNDS *
Maturity
Purchase
Financial
Investment
CUSIP/
Interest
Market
Date
Date
Institution
Description
Acct #
Rate %
Value
POLICE PENSION FUND (070)
Various
Various
Wells Fargo
Wells Fargo Investments
Various
Various
$ 22,600,184.55
Various
Various
Various
Mutual Fund Investments
Various
Various
32,226,741.72
54,826,926.27
FIRE PENSION FUND (071)
Various Various Wells Fargo
Various Various Various
TOTAL TRUST AND AGENCY FUND INVESTMENTS
Wells Fargo Investments Various Various 20,059,919.80
Mutual Fund Investments Various Various 32,330,953.29
52,,390,873.09
$ 107,217,799.36
* Assets are restricted in purpose and do not represent discretionary assets of the government.
3
VILLAGE OF MOUNT PROSPECT
BUDGET REVENUE
EXPENDITURE SUMMARIES
May 01— May 31, 2014
Revenue Budget by Account Classification
Report
Accoun Classification
Fund 001 - General Fund
REVENUE
Property Taxes
Other Taxes
Licenses, Permits & Fees
Intergovernmental Revenue
Charges For Services
Fines & Forfeits
Investment Income
Reimbursements
Other Revenue
Other Financing Sources
Through 05/31/14
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD
14,674,466.00
.00
14,674,466.00
38,053.56
100
7,405,136.89
7,269,329.11
50
6,490,450.25
8,241,500.00
.00
8,241,500.00
767,878.91
.00
2,202,510.74
6,038,989.26
27
1,859,070.08
1,621,000.00
.00
1,621,000.00
128,030.89
.00
879,866.23
741,133.77
54
1,866,936.62
18,083,100.00
.00
18,083,100.00
1,301,421.44
.00
3,792,434.95
14,290,665.05
21
3,466,066.67
1,516,000.00
.00
1,516,000.00
134,169.62
.00
567,925.87
948,074.13
37
561,748.55
491,000.00
.00
491,000.00
55,890.89
.00
157,590.06
333,409.94
32
216,838.03
22,500.00
.00
22,500.00
293.95
.00
2,074.68
20,425.32
9
6,518.66
226,000.00
.00
226,000.00
26,411.84
.00
223,258.79
2,741.21
99
106,677.86
918,500.00
.00
918,500.00
19,281.49
.00
129,487.06
789,012.94
14
111,170.23
20,000.00
.
20,
. 0 0
.00
.00
20,000.00
0
. 00
REVENUE TOTALS $45,814,066.00 $0.00 $45,814,066.00 $2,471,432.59 $0.00 $15,360,285.27 $30,453,780.73 34% $14,685,476.95
Fund 001 - General Fund Totals $45,814,066.00 $0.00 $45,814,066.00 $2,471,432.59 $0.00 $15,360,285.27 $30,453,780.73 $14,685,476.95
N
Revenue Budget by Account Classification
Report
Through 05/31/14
Prior Fiscal Year Activity Included
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,237,000.00
,00
2,237,000.00
5,967.10
.00
1,148,492.33
1,088,507.67
51
896,965.17
Other Taxes
1,056,532.00
.00
1,056,532.00
66,349.82
.00
132,668.88
923,863.12
13
89,677.66
Intergovernmental Revenue
43,005.00
.00
43,005.00
21,927.64
.00
21,927.64
21,077.36
51
21,573.21
Investment income
400.00
.00
400.00
9.29
.00
26.48
373.52
7
67.63
Other Financing Sources
.00
.00
.00
.00
.00
3,231.1
(
...
.
REVENUE TOTALS
$3,336,937.00
$0.00
$3,336,937.00
$94,253.85
$0.00
$1,306,346.52
$2,030,590.48
39%
$1, 008,283.67
Fund 002 - Debt Service Fund Totals
$3,336,937.00
$0.00
$3,336,937.00
$94,253.85
$0.00
$1,306,346.52
$2,030,590.48
$1,008,283.67
Account Classiflcation
Fund 020 - Capital Improvement Fund
REVENUE
Revenue Budget by Account Classification
Report
Through 05/31/14
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Other Taxes
1,246,000.00
.00
1,246,000.00
78,248.33
.00
156,460.39
1,089,539.61
13
154,456.41
Intergovernmental Revenue
.00
.00
AO
00
.00
.00
.00
+ ++
.00
Investment Income
1,000.00
.00
1,000.00
42.83
.00
258.41
741.59
26
342.77
Reimbursements
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Other Revenue
10,000.00
.00
10,000.00
24,474.00
.00
89,970.00
(79,970.00)
900
191,890.00
Other Financing Sources
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
REVENUE TOTALS
$1,257,000.00
$0.00
$1,257,000.00
$102,765.16
$0.00
$246,688.80
$1,010,311.20
20%
$346,689.18
Fund 020 - Capital Improvement Fund Totals
$1,257,000.00
$0.00
$1,257,000.00
$102,765.16
$0.00
$246,688.80
$1,010,311.20
$346,689.18
w
Ab
Revenue Budget
by Account
Classification
Report
Through 05/31/14
Prior Fiscal Year Activity Included
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - '(TD % used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
T
Tran Recd Prior Year YTD
Fund 021 - Series 2009 Construction Fund
REVENUE
Intergovernmental Revenue
.00
.00
.00
.00
.00
.00
.00 +++ .00
investment Income
.00
.00
.00
.00
.00
.00
.00 + ++ 6.00
Other Revenue
.00
.00
.00
.00
.00
.00
.00 + ++ .00
Other Financirig Sources
.00
.00
.00
.00
.00
.00
.00 + ++ .00
REVENUE TOTALS
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$().00 + ++ $6.0
Fund 021 - Series 2009 Construction Fund Totals
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00 $6.00
Revenue Budget by Account Classification
Report
Account Classlfication
Adopted Budget Amended Current Month YTD
Budget Amendments B Tr Encumbrances
Through 05/31/14
Prior Fiscal Year Activity Included
YTD Budget - YTD % used/
Transactions Transactions Recd Prior Year YTD
Fund 022 - Downtown Redevelop Construct
REVENUE
Property Taxes
2,671,000.00
.00
2,671,000.00
9,435.89
.00
1,252,091.23
1,418,908.77
47
1,320,375.00
Investment Income
1,000.00
.00
1,000.00
30.85
.00
162.12
837.88
16
317.66
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,672,000.00
$0.00
$2,672,000.00
$9,466.74
$0.00
$1,252,253.35
$1,419,746.65
47%
$1,320,692.66
Fund 022 - Downtown Redevelop Construct Totals
$2,672,000.00
$0.00
$2,672,000.00
$9,466.74
$0.00
$1,252,253.35
$1,419,746.65
$1,320,692.66
to
0)
Revenue Budget by Account Classification
Report
Through 05/31/14
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Fund 023 - Street Improvement Construc Fund
REVENUE
Other Taxes
2,057,000.00
.00
2,057,000.00
141,448.01
.00
404,786.20
1,652,213.80
20
285,918.86
Licenses, Permits & Fees
1,045,000.00
100
1,045,000.00
84,855.75
.00
903,293.25
141,706.75
86
.00
Intergovernmental Revenue
.00
.00
.00
.00
00
.00
.00
...
3,611.52
Investment Income
100.00
.00
100.00
568.01
.00
2,549.72
(2,449.72)
2550
39.78
Reimbursements
.00
.00
.00
.00
.00
.00
...
.00
Other Revenue
6,000.00
.00
6,000.00
18,165.25
.00
28,395.48
(22,395.48)
473
9,448.09
Other Financing Sources
6,500,000.00
.00
6,500,000.00
.00
.00
6,540,700.82
(40,700.82)
101
.00
REVENUE TOTALS
$9,608,100.00
$0.00
$9,608,100.00
$245,037.02
$0.00
$7,879,725.47
$1,728,374.53
82%
$299,018.25
Fund 023 - Street Improvement Construc Fund Totals
$9,608,100.00
$0.00
$9,608,100.00
$245,037.02
$0.00
$7,879,725.47
$1,728,374.53
$299,018.25
Revenue Budget by Account Classification
Report
Account Classification
Fund 024 - Flood Control Construction Fund
REVENUE
Through 05/31/14
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD
Other Taxes
289,468.00
.00
289,468.00
18,178.48
.00
36,348.54
253,119.46
13
78,387.23
Intergovernmental Revenue
'00
.00
.00
.00
.00
.00
.00
...
.00
Charges For Services
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Investment Income
500.00
.00
500.00
1,14181
.00
5,377.09
(4,877.09)
1075
1,682.14
Reimbursements
00
.00
.00
.00
.00
.00
.00
+ ++
.00
Other Financing Sources
.00
.00
.0 0
.00
.00
.00
.00
...
.00
REVENUE TOTALS
$ 289,968.00
$0.00
$289,968.00
$19,322.29
$0.00
$41,725.63
$248,242.37
14%
$80,069.37
Fund 024 - Flood Control Construction Fund Totals
$289,968.00
$0.00
$289,968.00
$19,322.29
$0.00
$41,725.63
$248,24237
$84,064.37
00
Revenue Budget by Account Classification
Report
Account Classification
Fund 040 - Refuse Disposal Fund
REVENUE
Through 05/31/14
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month YTD YTD Budget -'ffD % used/
Budget Amendments Budget Transactions Encumbrances Transactons Transactions Recd Prior Year YTD
Property Taxes
342,000.00
.00
342,000.00
(114.44)
.00
176,176.34
165,823.66
52
955,150.98
Charges For Services
2,900,000.00
100
2,900,000.00
200,179.45
.00
1,125,748.80
1,774,251.20
39
834,582.17
Fines 8, Forfeits
25,000.00
.00
25,000.00
1,653.88
.00
11,162.33
13,837.67
45
7,111.66
Investment Income
500.00
.00
500.00
53.69
,00
332.02
167.98
66
226.20
Reimbursements
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Other Revenue
359,000.00
.00
359,000.00
80,251.95
.00
122,829.02
236,170.98
34
127,0
REVENUE TOTALS $3,626,500.00
$0.00
$3,626,500.00
$282,024.73
$0.00
$1,436,248.51
$2,190,251.49
40%
$1,924,118.
Fund 040 - Refuse Disposal Fund Totals $3,626,500.00
$0.00
$3,626,500.00
$282,024.73
$0.00
$1,436,248.51
$2,190,251.49
$1,924,118.23
Account Classification
Revenue Budget by Account Classification
Report
Through 05/31/14
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Fund 041 - Motor Fuel Tax Fund
REVENUE
Intergovernmentai Revenue
1,290,000.00
.00
1,290,000.00
344,200,10
.00
660,142.51
629,857.49
51 405,761.50
Investment Income
100.00
.00
100.00
1.95
.00
9.48
90.52
9 86.16
Reimbursements
6,000.00
,00
6,000.00
.00
.00
6,870.77
(870.77)
115 1,782.51
REVENUE TOTALS
$1,296,100.00
$0.00
$1,296,100.00
$344,202.05
$0.00
$667,022.76
$629,077.24
51% $407,630.17
Fund 041 - Motor Fuel Tax Fund Totals
$1,296,100.00
$0.00
$1,296,100.00
$344,202.05
$0.00
$667,022.76
$624,077.24
$407,630.17
%0
r
CD
Revenue Budget by Account Classification
Report
Account Classification
Adopted Budget Amended Current Month YTD
Budget Amendments Budget Transactions Encumbrances
Through 05/31/14
Prior Fiscal Year Activity Included
YTD Budget - YTD % used/
Transactions Transactions Rec'd Prior Year YTD
Fund 042 - Cmmty Development Block Grant
REVENUE
Intergovernmental Revenue
293,202.00
97,171.00
390,373.00
.00
.00
.00
390,37:3.00 0
3,415.23
TnvestrnLnt Income
.00
.00
.00
.00
.00
.00
.00 ...
.00
Other Revenue
60,000.00
.00
60,000.00
7,346.00
.00
49,631.52
10,368.48 83
53,086.18
REVENUE TOTALS
$353,202.00
$97,171.00
$450,373.00
$7,346.00
$0.00
$49,631.52
$400,741.48 11%
$56,501.41
Fund 042 - Cmmty Development Block Grant Totals
$353,202.00
$97,171.00
$450,373.00
$7,346.00
$0.00
$49,631.52
$400,741.48
$56,501.41
Revenue Budget by Account Classification
Report
Account Classification
Fund 043 - Asset Seizure Fund
REVENUE
Through 05/31/14
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD
Fines & Forfeits 2,000.00
.00
2,000.00
.00
.00
.00
2,000.00 0
4,238.27
Investment Income 100.00
.00
100.00
.93
.00
7.86
92.14 8
5.39
REVENUE TOTALS $2,100.00
$0.00
$2,100.00
$0.93
$0.00
$7.86
$2,092.14 0%
$4,243.66
Fund 043 - Asset Seizure Fund Totals $2,100.00
$0.00
$2,100.00
$0.93
$0.00
$7.86
$2,092.14
$4,243.66
r
r
N
Revenue Budget
by Account
Classification
Report
Through 05/31/14
Prior Fiscal Year Activity Included
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 0 - DEA Shared Funds Fund
REVENUE
Fines & Forfeits
100.00
.00
100.00 .00
.00 24,637.80
(24,537.80) 24638 ,00
Investment Income
100.00
.00
100.00 2.07
.00 9.20
90.80 9 4.24
REVENUE TOTALS
$200.00
$0.00
$200.00 $2.07
$0.00 $24,647.00
($24,447.00) 12324% $4.24
Fund G44 - DEA Shared Funds Fund Totals
$200.00
$0.00
$200.00 $2.07
$0.00 $24,647.00
($24,447.00) $4.24
Revenue Budget by Account Classification
Report
Account Classification
Adopted Budget Amended Current Month YTD
Budget Amendments Budget Transactlons Encumbrances
Through 05/31/14
Prior Fiscal Year Activity Included
YTD Budget - YTD % used/
Transactions Transactions Recd Prior Year YTD
Fund 0415 - DIlI Fine Fund
REVENUE
Fines & Forfeits
Investment Income
20,000.00
.00
20,000.00
3,149.75
.00
9,579.73
10,420.27 48
9,348.71
100.00
. 0 0
100.00
110
.00
21.10
78.90 21
.00
REVENUE TOTALS $20,10.00
$0.00
$ 20,100.00
$3,152.85
$100
$9,800.83
$10,499.17 48%
$9,348.71
Fund 0415 - DUI Fine Fund Totals $20,100.00
$0.00
$20,100.00
$3,152.85
$0.00
$9,600.83
$10,499.17
$9,348.71
r
w
Revenue Budget by Account Classification
Report
Account Classification
Fund 046 - Foreign Fire Tax Board Fund
REVENUE
Through 05/31/14
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Redd Prior Year YTD
Other Taxes
70,000.00
.00
70,000.00
.00
.00
.00
70,000.00
0
.00
Investment income
1,000.00
.00
1,000.00
9.04
.00
57.17
942.83
6
.00
Other Revenue
.00
.00
.00
.00
.00
.00
...
45.00
Other Financing Sources
.00
.00
.00
.00
.00
.00
.00
...
.00
REVENUE TOTALS
$71,000.00
$0.00
$71,000.00
$9.04
$0.00
$57.17
$70,942.83
0%
$45.00
Fund 046 - Foreign Fire Tax Board Fund Totals
$71,000.00
$0.00
$71,000.00
$9.04
$0.00
$57.17
$70,942.83
$45.00
Revenue Budget by Account Classification
Report
Account Cl
Fund 047 - Justice Assistance Grant Fund
REVENUE
Through 05/31/14
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactons Rec'd Prlor Year YTD
Intergovernmental Revenue .00
.00
.00
.00
.00
.00
.00 + ++
00
Investment Income . 00
.00
.00
.00
.00
.00
.00 + ++
.
REVENUE TOTALS $0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00 +++
$0.00
Fund 047 - Justice Assistance Grant Fund Totals $0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
r
In
r
a,
Revenue Budget by Account Classification
Fund 048 - Business District Fund
REVENUE
Other Taxes 943,000.00
.00
943,000.00
71,789.63
.00
238,749.41
704,250.59
25 200,842.60
Investment Income 100.00
.00
100.00
3.73
.00
16.65
83.35
17 52.62
Other Financing Sources .00
.00
.00
.00
.00
.00
.00
... .00
REVENUE TOTALS $943,100.00
$0.00
$943,100.00
$71,793.36
$0.00
$238,766.06
$704,333.94
25% $200,895.22
Fund 048 - Business District Fund Totals $943,100.00
$0.00
$943,100.00
$71,793.36
$0.00
$238,766.06
$704,333.94
$200,895.22
Revenue Budget by Account Classification
Report
A ccoun t Classification
Fund 050 -Water and Sewer Fund
REVENUE
Through 05/31/14
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Property Taxes
1,530,000.00
.00
1,530,000.00
3,538.27
.00
812,372.67
717,627.33
53
811,214.86
Licenses, Permits & Fees
17,000.00
.00
17,000.00
1,650.00
.00
6,760.00
10,240.00
40
7,320.00
Charges For Services
12,711,000.00
.00
12,711,000.00
917,583.54
.00
4,650,989.48
8,060,010.52
37
4,681,409.32
Fines & Forfeits
100,000.00
.00
100,000.00
8,530.56
.00
44,367.56
55,632.44
44
50,943.37
Investment Income
1,100.00
.00
1,100.00
139.85
.00
829.30
270.70
75
457.99
Reimbursements
1,000.00
.00
1,000.00
.00
.00
(131.00)
1,131.00
-13
9,014.52
Other Revenue
25,000.00
.00
25,000.00
4,660.22
.00
29,536.53
(4,536.53)
118
1,016.35
Other Financing Sources
.00
.00
. 00
.00
.00
.00
.00
+ ++
.00
REVENUE TOTALS
$14,385,100.00
$0.00
$ 14,38 5, 100.00
$936,102.44
$0.00
$5,544,724.54
$8,840,375.46
39%
$5,561,376.41
Fund 0511- Water and Sewer Fund Totals
$14,385,100.00
$0.00
$14,385,100.00
$936,102.44
$0.00
$5,544,724.54
$8,840,375.46
$5,561,376.41
r
J
F-
00
Revenue Budget by Account Classification
Fund 051 - Village Parking System Fund
REVENUE
Other Taxes
10,000.00
.00
10,000.00
628.00
.00
1,255.71
8,744.29
13
1,360.85
Charges For Services
115,000.00
.00
115,000.00
11,041.40
.00
56,363.86
58,6311.14
49
54,197.95
Investment Income
100.00
.00
100.00
7.78
.00
46.71
53.29
47
13.35
Other Revenue
6,600.00
.00
6,600.00
550.00
.00
2,750.00
3,850.00
42
2,750.00
Other Financing Sources
.00
.00
.00
.00
,00
.0
.0
...
.
REVENUE TOTALS
$131,700.00
$0.00
$131,700.00
$12,227.18
$0.00
$60,416.28
$71,283.72
46%
$ 58,322.15
Fund 051 - Village Parking System Fund Totals
$131,700.00
$0.00
$131,700.00
$12,227.18
$0.00
$60,416.28
$71,28:3.72
$58,322.15
Revenue Budget by Account Classification
Report
A cco unt C
Fund 052 - Parking System Revenue Fund
REVENUE
Through 05/31/14
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD
Other Taxes
90,000.00
.00
90,000.00
5,651.97
.00
11,301.32
78,698.68
13
12,247.64
Intergovernmental Revenue
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Charges For Services
112,000.00
.00
112,000.00
11,775.18
.00
46,358.10
65,641.90
41
45,630.99
investment Income
100.00
.00
100.00
.00
.00
.00
100.00
0
1.62
Other Revenue
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Other Financing Sources
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
REVENUE TOTALS
$202,100.00
$0.00
$20 2,100.00
$17,427.15
$0.00
$57,659.42
$144,440.58
29%
$57,880.25
Fund 052 - Parking System Revenue Fund Totals
$202,100.00
$0.00
$202,100.00
$17,427.15
$0.00
$57,659.42
$144,440.58
$57,880.25
P-
%0
N
O
Revenue Budget by Account Classification
Report
Account Classification
Through 05/31/14
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month YTD YTD Budget -'YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Fund 060 - Vehicle Maintenance Fund
REVENUE
Charges For Services
2,138,317.00
.00
2,138,317.00
178,193.07
,00
890,965.35
1,247,351.65
42 913,880.50
Investment Income
.00
.00
.00
44.50
.00
239.92
(239.92)
... 211.89
Other Revenue
.00
.00
.00
.00
.00
.00
.00
... 138.40
REVENUE TOTALS
$2,138,317.00
$0.00
$2,138,317.00
$178,237.57
$0.00
$891,205.27
$1,247,111.73
42% $914,23
Fund 060 - Vehicle Maintenance Fund Totals
$2,138,317.00
$0.00
$2,138,317.00
$178,237.57
$0.00
$891,205.27
$1,247,111.73
$914,230.79
Revenue Budget by Account Classification
Report
Account Classification
Through 05/31/14
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendm Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Fund 061 - Vehicle Replacement Fund
REVENUE
Charges For Services
1,346,300.00
.00
1,346,300.00
112,191.68
.00
560,958.40
785,341.60
42
581,916.70
Fines & Forfeits
10,000.00
.00
10,000.00
3,000.00
.00
4,200.00
5,800.00
42
4,220.00
Investment Uncome
5,000.00
.00
5,000.00
567.56
.00
3,095.33
1,904.67
62
2,375.00
Other Revenue
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Other Financing Sources
60,000.00
.00
60,000.00
.00
.00
31,554.47
28,445.53
53
16,974.24
REVENUE TOTALS
$1,421,300.00
$0.00
$1,421,300.00
$115,759.24
$0.00
$599,808.20
$821,491.80
42%
$605,485.94
Fund 861 - Vehicle Replacement Fund Totals
$1,421,300.00
$0.00
$1,421,300.00
$115,759.24
$0.00
$599,808.20
$821,491.80
$605,485.94
N
r
N
N
Revenue Budget by Account Classification
Report
Through 05/31/14
Prior Fiscal Year Activity Included
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD
% used/
Account Classification
Budget
Amendments
Budge
Transaction
Encumbrances
Transactions
Transactions
Recd
Prior Year YTD
Fund 062 -Computer Replacement Fund
REVENUE
Charges For Services
23,088.00
.00
23,088.00
1,924.00
.00
9,620.00
13,468.00
42
.00
Investment Income
1,000.00
.00
1,000.00
61.00
.00
312.52
687.48
31
298.65
Other Financing Sources
.00
.00
.00
.0
.0
. 00
.00
+ ++
.00
REVENUE TOTALS
$24,088.00
$0.00
$24,088.00
$1,985.00
$ 0.00
$9,932.52
$14,
41%
$298.65
Fund 062 . Computer Replacement Fund Totais
$24,088.00
$0.00
$24,088.00
$1,985.00
$0.00
$9,932.52
$14,155.48
$298.65
Revenue Budget by Account Classification
Report
Through 05/31/14
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD
Fund 063 -Risk Management Fund
REVENUE
Charges For Services
6,456,273.00
.00
6,456,273.00
613,494.61
.00
2,796,747.53
3,659,525.47
43
2,466,673.12
Investment Income
2,000.00
.00
2,000.00
183.13
.00
963.88
1,036.12
48
697.66
Reimbursements
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00
0
.00
Other Revenue
1,357,600.00
.00
1,357,600.00
123,046.52
.00
567,891.61
789,708.39
42
540,201.03
REVENUE TOTALS
$7,816,873.00
$0.40
$7,816,8
$736,724.26
$0.00
$3,365,603.02
$4,451,26198
43%
$3,007,571.81
Fund 063 - Risk Management Fund Totals
$7,816,873.00
$0.00
$7,816,873.00
$736,724.26
$0.00
$3,365,603.02
$4,451,269.98
$3,007,571.81
N
W
N
.P
Revenue Budget by Account Classification
Report
Account Classification
Fund 070 w Police Pension Fund
REVENUE
Through 05/31/14
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD
Charges For Services .00
.00
.00
.00
.00
.00
.00
+ ++ .00
Investment Income 3,415,900.00
.00
3,415,900.00
918,605.36
.00
1,659,800.57
1,756,099.43
49 3,076,041.44
Other Revenue 3,742,224.00
.00
3,742,224.00
66,068.43
.00
1,734,617.94
2,007,606.06
46 1,655,130.68
REVENUE TOTALS 7 158 124.00
$ , ,
$0.00
$7,158,124.00
$984,673.79
$0.00
$3,394,418.51
$3,763,705.49
47% $4,731,1
Fund 070 - Police Pension Fund Totals $7,158,124.00
$0.00
$7,158,124.00
$984,673.79
$0.00
$3,394,418.51
$3,763,705.49
$4,731,172.12
Revenue Budget by Account Classification
Report
Through 05/31/14
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions
Recd
Prior Year YTD
Fund 071- Fire pension Fund
REVENUE
.Investment Income
3,165,200.00
.00
3,165,200.00
210,777.33
.00
1,207,841.82
1,957,358.18
38
2,084,276.69
Other Revenue
3,079,042.00
. 00
3,079,042.00
50,947.53
.00
1,519,984.27
1,559,057.73
49
1,440,589.77
REVENUE TOTALS
$6,244,242.00
$0.00
$6,244,242.00
$261,724.86
$0.00
$2,727,826.09
$3,5!6,415.91
44%
$3,524,866.46
Fund 071 - Fire Pension Fund Totals
$6,244,242.00
$0.00
$6,244,242.00
$261,724.86
$0.00
$2,727,826.09
$3,516,415.91
$3,524,866.46
Grand Totals $108,812,217.00 $97,171.00 $108,909,388.00 $6,895,670.17 $0.00 $45,164,600.60 $63,744,787.40 $38,804,22730
N
Ln
Expense Budget by Account Classification
Report
Account Classiflcation
Adopted Budget Amended Current Month YTD
Budget Amendments Budget Transactions Encumbrances
Through 05/31/14
Prior Fiscal Year Activity Included
YTD Budget - YTD % used/
Transactions Transactions Redd Prior Year YTD
Fund 001 - General Fund
EXPENSE
Personal Services, Scheduled Salaries & Wages
23,919,744.00
.00
23,919,744.00
1,750,190.43
.00
8,961,371.79
14,958,372.21
37
8,627,595.85
Employee Benefits
12,344,314.00
.00
12,344,314.00
523,540.52
.00
5,620,293.95
6,724,020.05
46
5,294,558.96
Other Employee Costs
415,005.00
(1,000.00)
414,005.00
40,102.54
8,180.39
137,758.94
268,065.67
35
113,649.59
Pension Benefits
46,301.00
.00
46,301.00
3,858.36
.00
19,291.80
27,009.20
42
19,229.05
Contractual Services
7,001,321.00
134,548.00
7,135,869.00
612,933.15
605,037.45
2,831,565.70
3,699,265.85
48
2,993,968.81
Utilities
262,282.00
.00
262,282.00
7,338.53
.00
63,367.71
198,914.29
24
61,843.47
Insurance
350,519.00
.00
350,519.00
29,203.70
.00
146,065.90
204,453.10
42
143,802.41
Commodities & Supplies
627,855.00
61,600.00
689,455.00
50,323.24
76,567.35
193,217.23
419,670.42
39
182,918.52
Other Expenditures
11,080.00
.00
11,080.00
.00
.00
.00
11,080.00
0
.00
Building Improvements
10,000.00
.00
10,000.00
54.61
.00
1,083.52
8,916.48
11
5,712.43
Office Equipment
49,730.00
.00
49,730.00
2,379.57
.00
6,376.17
43,353.83
13
1,407.02
Other Equipment
165,123.00
3,100.00
168,223.00
14,595.65
21,809.70
60,151.78
86,261.52
49
14,025.08
Distribution Systems
100,000.00
.00
100,000.00
.00
.00
.00
100,000.00
0
.00
Infrastructure
510,792.00
3,400.00
514,192.00
78,914.70
217,247.79
104,977.10
191,967.11
63
125,925.21
Interfund Transfers
.00
.00
.00
.00
.00
.00
.00
...
EXPENSE TOTALS
$45,814,066.00
$201,648.00
$46,015,714.00
$3,113,435.00
$928,842.68
$18,145,521.59
$26,941,349.73
41%
$17,584,636.40
Fund 001 - General Fund Totals
$45,814,066.00
$201,648.00
$46,015,714.00
$3,113,435.00
$928,842.68
$18,145,521.59
$26,941,349.73
$17,584,636.40
I.-
N
Expense Budget by ,Account Classification
Report
Account Classification
Fund 002 - Debt Service Fund
EXPENSE
Through 05/31/14
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD
Contractual Services
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Other Expenditures
.00
.00
.00
.00
.00
.00
.00
...
.00
Bond Principal
1,532,587.00
.00
1,532,587.00
.00
.00
162,13116
1,370,454.84
11
175,980.85
Interest Expense
1,793,429.00
.00
1,793,429.00
750,048.53
.00
756,545.55
1,036,883.45
42
334,860.25
Bank & Fiscal Fees
2,484.00
.00
2,484.00
.00
.00
1,258.20
1,225.80
51
428.00
Interfund Transfers
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Other Financing Uses
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
EXPENSE TOTALS $3,328,500.00
$0.00
$3,328,500.00
$750,048.53
$0.00
$919,935.91
$2,408,564.09
28%
$511,269.10
Fund 002 - Debt Service Fund Totals $3,328,500.00
$0.00
$3,328,500.00
$750,048.53
$0.00
$919,935.91
$2,408,564.09
$511,269.10
Expense Budget by Account Classification
w
Report
Through 05/31/14
Prior Fiscal Year Activity Included
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD % used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions Recd Prior Year YTD
Fund 020 - Capital Improvement Fund
EXPENSE
Contractual Services
.00
.00
.00
.00
.00
.00
.00 + ++ 19,132.60
Other Expenditures
.00
.00
.00
.00
.00
.00
100 + ++ .00
Land Improvements
240,000.00
.00
240,000.00
.00
.00
.00
240,000.00 0 .00
Building Improvements
637,000.00
73,600.00
710,600.00
500.00
135,738.57
27,261.60
547,599.83 23 73,052.64
Office Equipment
.00
.00
.00
.00
.00
.00
.00 + ++ .00
Motor Equipment
.00
.00
.00
.00
.00
.00
.00 + ++ .00
Other Equipment
304,247.00
16,600.00
320,847.00
75,60191
.00
121,938.63
198,908.37 38 67,117.30
Infrastructure
515,000.00
104,400.00
619,400.00
19,934.06
15,943.83
27,539.06
575,917.11 7 1,748.59
Interfund Transfers
. 00
.00
.00
.00
.00
.00
.00 ... .00
EXPENSE TOTALS
$1,696,247.00
$19
$1,890,847.00
$96,037.97
$151,682.40
$176,739.29
$1,562,425.31 17% $161,051>13
Fund 020 -Capital Improvement Fund 'Totals
$1,696,247.00
$194,600.00
$1,890,847.00
$96,037.97
$151,682.40
$176,73919
$1,562,425.31 $161,051.13
w
Expense Budget by Account Classification
Report
Through 05/31/14
Prior Fiscal Year Activity Included
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 021 - Series 2009 Construction Fund
EXPENSE
Contractual Services
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Building Improvements
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Office Equipment
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Other Equipment
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Interfund Transfers
.00
.00
.00
.00
.00
.00
.
+ ++
.00
EXPENSE TOTALS
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+ ++
$ 0.00
Fund 021 - Series 2009 Construction Fund Totals
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
Expense Budget by Account Classification
Report
Account Classification
Adapted Budget Amended Current Month YTD
Budget Amendments Budget Transactions Encumbrances
Through 05/31/14
Prior Fiscal Year Activity Included
YTD Budget - YTD % used/
Transactions Transactions Recd Prior Year YTD
Rind 022 - Downtown Redevelop Construct
EXPENSE
Contractual Services
203,040.00
.00
203,040.00
6,450.38
119,354.37
12,643.26
71,042.37
65
12,522.16
Utilities
.00
.00
.00
.00
.00
.00
.00
+ ++
00
Other Expenditures
2,803,922.00
60,000.00
2,863,922.00
25,000.00
.00
57,858.93
2,806,063.07
2
25,053.44
Infrastructure
115,000.00
240,000.00
355,000.00
.00
3,67500
9,240.00
342,085.00
4
.00
Bond Principal
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Interest Expense
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Interfund Transfers
.0 0
.00
.00
.00
.00
.00
.00
+ ++
.00
EXPENSE TOTALS
$ 3,121,962.00
$300,000.00
$3,421,962.00
$31,450.38
$123,029.37
$79,742.19
$3,219,190.44
6%
$37,575.60
Fund 022 -Downtown Redevelop Construct Totals
$3,121,962.00
$300,000.00
$3,421,962.00
$31,450.36
$123,029437
$79,742.19
$3,219,190.44
$37,575,60
rr
rAI
Expense Budget by Account Classification
TV
Report
Through 05/31/14
Prior Fiscal Year Activity Included
Adopted
Budget
Amended
Current Month
YTD
YTD Budget - YTD % used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions Transactions Recd Prior Year YTD
Fund 023 - Street Improvement Construc Fund
EXPENSE
Contractual Services
30,600.00
41,000.00
71,600.00
.00
30,597.00
40,700.82 302.18 100 .00
Infrastructure
9,943,280.00
.00
9,943,280.00
1,285,092.01
7,239,198.91
1,753,194.52 950,886.57 90 13,069.29
Interfund Transfers
.00
..00
.00
.00
.00
.00 .00 + ++ .00
EXPENSE TOTALS $9,973,880.00 $41,000.00 $10,014,880.00 $1,285,092.01 $7,269,795.91 $1,793,895.34 $951,188.75 91% $13,069.29
Fund 023 - Street Improvement Construc Fund Totals $9,973,880.00 $41,000.00 $10,014,880.00 $1,285,092.01 $7,269,795.91 $1,793,895.34 $951,188.75 $13,069.29
Expense Budget by Account Classification
J
Report
Through 05/31/14
Prior Fiscal Year Activity Included
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD % used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions Recd Prior Year YTD
Fund 024 -Flood Control Construction Furst
EXPENSE
Contractual Services
.00
.00
.00
.00
.00
.00
.00 + ++ .00
Utilities
1,000.00
.00
1,000.00
176.80
.00
915.87
84.13 92 .00
Other Expenditures
5,000.00
.00
5,000.00
.00
.00
.00
5,000.00 0 1,000.00
Other Equipment
.00
.00
.00
.00
.00
.00
.00 + ++ 00
Infrastructure
10,805,000.00
83,800.00
10,888,800.00
38,127.21
216,837.66
179,020.21
10,492,942.13 4 80,048.36
EXPENSE TOTALS
$10,811,000.00
$83,800.00
$10,894,800.00
$38,304.01
$216,837.66
$179,936.08
$10,498,026.26 4% $81,048.36
Fund 024 - Flood Control Construction Fund Totals
$10,811,000.00
$83,800.00
$10,894,800.00
$38,304.01
$216,837.66
$179,936.08
$10,498,026.26 $81,048.36
J
OD
Expense Budget by Account Classification
MVJ=3 « M
Personal Services, Scheduled Salaries & Wages
231,735.00
.00
231,735.00
16,773.25
.00
101,017.80
130,717.20
44
92,338.86
Employee Benefits
75,057.00
.00
75,057.00
7,851.55
.00
44,516.58
30,540.42
59
54,451.39
Other Employee Costs
1,224.00
.00
1,224.00
.00
.00
1,095.00
129.00
89
.00
Contractual Servlces
4,157,884.00
.00
4,157,884.00
361,714.57
4,816.61
1,535,236.70
2,617,830.69
37
1,553,723.18
Utilities
438.00
.00
438.00
.82
.00
101.69
336.31
23
123.58
Insurance
28,640.00
28,640.00
2,386.67
.00
11,933.35
16,706.65
42
11,766.25
Commodities & Supplies
31,295.00
.00
31,295.00
175.35
.00
10,453.54
20,841.46
33
3,185.38
EXPENSE TOTALS
$4,526,273.00
$0.00
$4,526,273.00
$388,902.21
$4,816.61
$1,704,354.66
$2,817,101.73
38%
$1,715,588.64
Fund 040 - Refuse Disposal Fund Totals
$4,526,273.00
$0.00
$4,526,273.00
$388,902.21
$4,816,61
$1,704,354.66
$2,817,101.73
$1,715,588.64
Expense Budget by Account Classification
Report
Account Classification
Adopted Budget Amended Current Month YTD
Budget Amendments Budget Transactions Encumbrances
Through 05/31/14
Prior Fiscal Year Activity Included
YTD Budget - YTD % used/
Transactions Transactions Rec'd Prior Year YTD
Fund 441- Motor Fuel Tax Fund
EXPENSE
Contractual Services
204,104.00
75,000.00
279,104.00
8,158.70
135,593.66
68,834.23
74,676.11
73
17,960.31
Utilities
153,000.00
.00
153,000.00
14,179.54
.00
73,478.93
79,521.07
48
56,785.51
Commodities & Supplies
284,796.00
.00
284,796.00
.00
26,944.69
216,890.32
40,960.99
86
147,195.10
Infrastructure
9 1 0, 000.00
5,000.00
915,000.00
.00
.00
10,056.62
904,943.38
1
499,277.00
EXPENSE TOTALS
$1,551,900.00
$80,000.00
$1,631,900.00
$22,338.24
$162,538.35
$369,260.10
$1,100,101.55
33%
$721,217.92
Fund 041 - Motor Fuel Tax Fund Totals
$1,551,900.00
$80,000.00
$1,631,900.F}0
$22,338.24
$162,538.35
$369,260.10
$1,100,101.55
$721,217.92
ko
Expense Budget by Account Classification
Report
Through 05/31/14
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions
Redd
Prior Year YTD
Fund 042 - Cmmty Development Block Grant
EXPENSE
Personal Services, 5cheduled Salaries & Wages
47,930.00
.00
47,930.00
3,279.16
.00
15,903.88
32,026.12
33
15,753.23
Employee Benefits
26,222.00
.00
26,222.00
2,073.40
.00
10,283.48
15,938.52
39
9,881.91
Other Employee Costs
1,020.00
.00
1,020.00
26.70
.00
151.70
868.30
is
350.50
Contractual Services
97,520.00
23,250.00
120,770.00
27,333.83
.00
51,344.44
69,425.56
43
2,111.57
Commodities & Supplies
510.00
.00
510.00
.00
.00
.00
510.00
0
111.37
Other Expenditures
160,000.00
73,921.00
233,921.00
.00
.00
1,820.00
232,101.00
1
34,812.60
Land Improvements
.00
.00
.00
.00
.00
.00
.00
...
.00
Building ImprovernenLq
.00
.00
.00
.00
.00
.00
.00
...
.00
Infrastructure
20,000.00
.00
20,000.00
.00
.00
.00
20,000.00
0
.00
EXPENSE TOTALS
$353,202.00
$97,171.00
$450,373.00
$32,713.09
$0.00
$79,503.50
$370,869.50
18%
$63,021.18
Fund 042 - Cm mty Development Block rant Totals
$353,202.00
$97,171.00
$450,373.00
$32,713.09
$0.00
$79,503.50
$370,869.50
$63,021.18
Expense Budget by Account Classification
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
.00
.00
1,500.00
1,500.00 50
.00
Other Equipment 15,000.00
.00
15,000.00
.00
.00
1,642.29
13,357.71 11
3,915.00
EXPENSE TOTALS $ 19, 0 00.00
$0.00
$19,000.00
$0.00
$0.00
$3,142.29
$15,857.71 17
$3,915.00
Fund 043 - Asset Seizure Fund Totals $19,000.00
$0.00
$13,000.00
$0.00
$0.04
$3,142.29
$15,857.71
$3,915.00
r
r
F-
NJ
Expense Budget by Account Classification
Report
Account Classification
Adopted Budget Amended Current Month YTD
Budget Amendments Budget Transactions Encumbrances
Through 05/31/14
Prior Fiscal Year Activity Included
YTD Budget - YTD % used/
Transactions Transactions Rec'd Prior Year YTD
Fund 044 - DEA Shared Funds Fund
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
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 0 44 - DEA Shared Funds Fund 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
Account Classification
Adopted Budget Amended Current Month YTD
Budget Amendments Budget Transactions Encumbrances
Through 05/31/14
Prior Fiscal Year Activity Included
YTD Budget - YTD % used/
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
.00
.00
.00
1,000.00
0
.00
.00
.00
AO
.00
.00
.00
100
+ ++
2,187.50
10,000.00
.00
10,000.00
.00
2,671.31
95.99
7,232.70
28
3,595.00
100
.00
.00
.00
.00
.00
.00
+ ++
.00
EXPENSE TOTALS $ 1 1, 000. 0 0
$0.00
$11,00
$0.00 — -
$2,671.31
$95,99
$8,232.70
25%
$5,782.50
Fund 045 - DUZ Fine Fund Totals $11,000.00
$0.00
$11,000.00
$0.00
$2,671.31
$95.99
$8,23230
$5,762.50
r
w
r
.P..
Expense Budget
by Account
Classification
Report
Through 05/31/14
_
Prior Fiscal Year Activity Included
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD % used/
Account ClassiFlcatlon
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions Rec'd Prior Year YTD
Fund 046 -Foreign Fire Tax Beard Fund
EXPENSE
Contractual Services
10,000.00
.00
10,000.00
852.49
.00
3,946.60
6,053.40 39 2,938.44
Insurance
500.00
.00
500.00
.00
.00
.00
500.00 0 .00
Commodities & Supplies
5,000.00
..00
5,000.00
.00
.00
211.65
4,788.35 4 1,304.24
Other Equipment
15,000.00
.00
15,000.00
.00
.00
11,688.00
3,312.00 78 9,077.00
EXPENSE TOTALS
$30,500.00
$0.00
$30,500.00
$852.49
$0.00
$15,846.25
$14,653.75 52% $13,319.68
Fund 046 -Foreign Fire Tax Board Fund Totals
$30,500.00
$0.00
$30,500.00
$852.49
$0.00
$15,846.25
$14,65:3.75 $13,319.68
Expense Budget by Account Classification
Report
Account Classification
Fund 047 - Justice Assistance Grant Fund
EXPENSE
Through 05/31/14
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD
Commodities & Supplies
.00
.00
.00
.00
.00
.00
.00
...
.00
Other Expenditures
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Office Equipment
.00
.00
.00
.00
.00
.00
.00
...
.00
Other Equipment
.00
.00
.00
.00
.00
.00
.00
+ ++
122.40
Interfund Transfers
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
EXPENSE TOTALS
$0.
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+ ++
$122.40
Fund 047 - Justice Assistance Grant Fund Totals
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$122.40
r
rn
Expense Budget by Account Classification
Report
XMIJ
Through 05/31/14
Prior Fiscal Year Activity Included
Adapted
Budget
Amended
Current Month
YTD
YTD Budget - YTD % used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions Transactions Rec'd Prior Year YTD
Fund 0468 - Business District Fund
EXPENSE
Bond Principal
00
.00
.00
.00
.00
.00 .00 + ++ .00
Interest Expense
923,100.00
.00
923,100.00
.00
.00
.00 923,100.00 0 637,231.78
EXPENSE TOTALS
$923,100.00
$0.00
$923,100.00
$0.00
$0.00
$0.00 $923,100.00 0% $637,231.78
Fund 048 - Business District Fund Totals
$923,100.00
$0.00
$923,100.00
$0.00
$0.00
$0.00 $923,100.00 $637,231,78
Expense Budget by Account Classification
Report
Account Classification
Fund 050 - Water and Sewer Fund
EXPENSE
Through 05/31/14
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Personal Services, Scheduled Salaries & Wages
1,952,664.00
.00
1,952,664.00
139,304.90
.00
817,511.08
1,135,152.92
42
728,662.55
Employee Benefits
787,893.00
.00
787,893.00
56,586.35
.00
321,888.01
466,004.99
41
310,494.43
Other Employee Costs
36,660.00
.00
36,660.00
2,319.12
1,732.39
13,603.89
21,323.72
42
7,456.46
Contractual Services
7,457,412.00
32,500.00
7,489,912.00
696,519.53
346,708.44
2,719,007.86
4,424,195.70
41
2,300,613.10
Utilities
157,758.00
.00
157,758.00
8,443.80
.00
42,046.46
115,711.54
27
40,213.49
Insurance
80,474.00
.00
80,474.00
6,706.16
.00
33,530.80
46,943.20
42
33,076.25
Commodities & Supplies
295,722.00
.00
295,722.00
7,842.37
45,816.85
69,327.06
180,578.09
39
51,441.20
Other Expenditures
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Building Improvements
42,500.00
.00
42,500.00
.00
4,250.00
.00
38,250.00
10
.00
Office Equipment
1,370.00
.00
1,370.00
.00
.00
.00
1,370.00
0
.00
Other Equipment
1,244,200.00
1,563,500.00
2,807,700.00
45,152.11
2,157,037.85
81,180.00
569,482.15
80
80,876.41
Distribution Systems
2,075,000.00
581,500.00
2,656,500.00
16,665.78
1,177,077.02
29,661.99
1,449,760.99
45
196,979.02
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
.0
. 00
.00
.00
+ ++
.00
EXPENSE TOTALS
$14,131,653.00
$2,177,500.00
$16,309,15100
$979,540.12
$3,732,622.55
$4,127,757.15
$8,448,773.30
48%
$3,749,812.91
Fund 050. Water and Sewer Fund Totals
$14,131,65100
$2,177,500.00
$16,309,153.00
$979,54{1.22
$3,732,622.55
$4,127,757.15
$8,448,773.30
$3,749,812.91
F-
-_j
OD
Expense Budget by Account Classification
;] i Is] - I
Account Classification
Adopted Budget Amended Current Month YTD
Budget Amendments Budget Transactions Encumbrances
Through 05/31/14
Prior Fiscal Year Activity Included
YTD Budget - YTD % used/
Transactions Transactions Redd Prior Year YTD
Fund 051 - Village Parking System Fund
EXPENSE
Personal Services, Scheduled Salaries & Wages
35,788.00
.00
35,788.00
2,679.00
.00
14,931.57
20,856.43
42
8,727.38
Employee Benefits
17,796.00
.00
17,796.00
1,199.58
.00
6,308.21
11,487.79
35
3,678.41
Contractual Services
91,055.00
.00
91,055.00
4,313.40
6,149.86
25,973.75
58,931.39
35
35,673.54
RISUI'anCe
1,175.00
.00
1,175.00
97.92
.00
489.60
685.40
42
482.50
Commodities & Supplies
510.00
510.00
.00
.00
.00
510.00
0
.00
Other Expenditures
.00
.00
.00
.00
.00
.00
.00
...
.00
Building Improvements
6,936.00
.00
6,936.00
.00
2,750.80
.00
4,185.20
40
.00
Infrastructure
153,500.00
.00
153,500.00
.00
46,749.20
.00
106,750.80
30
875.00
Interfund Transfers
.00
.00
.00
.00
.00
.00
.00
...
.00
EXPENSE TOTALS
$306,760.00
$0.00
$306,760.00
$8,289.90
$55,649.86
$47,703.13
$203,407.01
34%
$49,436.83
Fund 051 - Village Parking System FundTotals
$306,760.00
$0.00
$306,760.00
$8,289.90
$55,649.86
$47,703.13
$203,407.01
$49,436.83
Expense Budget by Account Classification
Fund 052 - Parking System Revenue Fund
EXPENSE
Personal Services, Scheduled Salaries & Wages
28,598.00
.00
28,598.00
1,958.17
.00
10,802.32
17,795.68
38
15,893.71
Employee Benefits
13,772.00
.00
13,772.00
896.18
.00
4,686.15
9,085.85
34
8,105.04
Contractual Services
110,954.00
.00
110,954.00
6,738.98
4,573.79
33,693.13
72,687.08
34
33,949.45
Utilities
10,523.00
.00
10,523.00
124.26
.00
2,678.84
7,844.16
25
2,461.07
Insurance
1,406.00
.00
1,406.00
117.17
.00
585.85
820.15
42
577.90
Cornmoditles &- Supplies
9,779.00
.00
9,779.00
1,019.21
.00
6,195.65
3,583.35
63
2,030.43
Other Expenditures
.00
.00
.00
.00
.00
.00
.00
...
.00
Building Improver
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
100
...
.00
EXPENSE TOTALS
$250,032.00
$0.00
$250,032.00
$10,853,97
$4,573.79
$58,641.94
$186,816,27
25%
$63,017.60
Fund 052 - Parking System Revenue Fund Totals
$250,032.00
$0.00
$250,032.00
$10,853.97
$ 4 ,573.79
$58,641.94
$186,816.27
$63,017.60
F-
LD
N
O
Expense Budget by Account Classification
111
Account Classification
Fund 060 - Vehicle Maintenance Fund
EXPENSE
Through 05/31/14
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Personal Services, Scheduled Salaries & Wages
940,529.00
.00
940,529.00
70,162.90
.00
395,104.64
545,424.36
42
348,844.08
Employee Benefits
384,627.00
.00
384,627.00
27,517.23
.00
151,935.26
232,691.74
40
149,967.34
Other Employee Costs
2,361.00
.00
2,361.00
135.00
.00
684.00
1,677.00
29
740.00
Contractual Services
100,738.00
.00
100,738.00
6,992.38
16,142.64
29,582.39
55,012.97
45
34,594.02
Utilities
3,070.00
.00
3,070.00
2.06
.00
778.28
2,291.72
25
1,608.56
Commodities & Supplies
701,081.00
.00
701,081.00
49,313.57
100,004.87
300,330.00
300,746.13
57
267,327.86
Other Expenditures
.00
.00
.00
.00
AO
.00
.00
+ ++
.00
Office Equipment
556.00
.00
556.00
.00
.00
132.99
423.01
24
.00
Other Equipment
19,770.00
.00
19,770.00
.00
15,365.14
350.00
4,054.86
79
.00
EXPENSE T(TALS
2,152,732.00
$O.GD
$2,152,732.00
$154,123.14
$131,512.65
$878,8
$1,142,321,79
47
$803,081.85
Fund 060 - Vehicle Maintenance Fund Totals
$2,152,732.00
$0.00
$2,152,732.00
$154,123.14
$131,512.65
$878,897.56
$1,142,321.79
$803,081.86
Expense Budget by Account Classification
Account Classification
Fund 061 - Vehicle Replacement Fund
EXPENSE
Through 05/31/14
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD
Other Expenditures ,00
.00
.00
.00
.00
.00
100 + ++
.00
Motor Equipment 1,614,000.00
163,700.00
1,777,700.00
699,677.04
795,117.50
723,828.10
258,754.40 85
36,150.64
Tnterfund Transfers . 00
.00
.00
.00
.00
.00
.00 + ++
.00
EXPENSE TOTALS $1,614,000.00
$ 163,700.00
$1,777,700.00
$699,677.04
$795,117.50
$723,828.10
$258,754.40 85%
$36,150.64
Fund 061 - Vehicle Replacement Fund Totals $1,614,000.00
$163,700.00
$1,777,700.00
$699,677.04
$795,117.50
$723,828.10
$258,754.40
$36,150.64
N
r
Expense Budget by Account Classification
Accoun Classification
Fund 062 - Computer Replacement Fund
EXPENSE
Through 05/31/14
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactlons Encumbrances Transactlons Transactions Rec'd Prior Year YTD
Other Expenditures .00
.00
.00
.00
.00
.00
.00 + ++
.00
Office Equipment 247,480.00
.00
247,480.00
.00
.00
55,687.15
191,792.85 23
39,536.97
EXPENSE TOTALS $247,480.00
$0.00
$247,480.00
$0.00
$0.00
$55,687.15
$191,792.85 23%
$39,536.
Fund 062 - Computer Replacement Fund Totals $247,480.00
p p
$0,00
$247 480.00
,
$0.00
$0.00
$55,687.15
$191,792.85
$39,536.97
Expense Budget by Account Classification
Report
Acc C
Fund 063 - Risk Management Fund
EXPENSE
Through 05/31/14
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD
Contractual Services
27,000.00
.00
27,000.00
10,300.00
.00
10,300.00
16,700.00
38
10,950.00
Insurance
7,812,938.00
.00
7,812,938.00
646,617.58
.00
3,345,036.57
4,467,901.43
43
3,142,777.80
Other Equipment
5,000.00
.00
5,000.00
.00
.00
.00
5,000.00
0
2,140.90
Infrastructure
.00
.00
.00
.00
.00
.00
.00
+++
.00
Interfund Transfers
.00
. 00
.00
.00
.00
.00
.00
+ ++
.00
EXPENSE TOTALS
$7,844,938.00
$0. 00
$7,844,938.00
$656,917.58
$0.00
$3,355,336.57
$4,489,601,43
43%
$3,155,868.70
Fund 063 -Risk Management Fund Totals
$7,844,938.00
$0.00
$7,844,938.00
$656,917.58
$0.00
$3,355,336.57
$4,489,601.43
$3,155,868.70
N
W
Expense Budget by Account Classification
Report
0210MM
Adopted Budget Amended Current Month YTD
Budget Amendments Budget Transactions Encumbrances
Through 05/31/14
Prior Fiscal Year Activity Included
YTD Budget - YTD % used/
Transactions Transactions Rec'd Prior Year YTD
Fund 070 - Police Pension Fund
EXPENSE
Penslon Benefits
3,937,366.00
.00
3,937,366.00
327,495.88
.00
1,628,771.20
2,308,594.80
41
1,595,629.96
Contractual Services
135,350.00
.00
135,350.00
24,435.39
.00
37,411.39
97,938.61
28
28,167.60
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,250.00
3,750.00
69
9,338.95
Office Equipment
.00
.00
.00
.00
.00
.00
.00
...
.00
EXPENSE TOTALS
$4,099,816.00
$0.00
$4,099,816.00
$359,931.27
$0.00
$1,674,432.59
$2,425,383.41
41%
$1,633,136.51
Fund 070 - Police Pension Fund Totals
$4,099,816.00
$0.00
$4,099,816.00
$359,931.27
$0.00
$1,674,432.59
$2,425,383.41
$1,633,136.51
Expense Budget by Account Classification
Report
Account Classification
Adopted Budget Amended Current Month YTD
Budget Amendments Budget Transactions Encumbrances
Through 05/31/14
Friar Fiscal Year Activity Included
YTD Budget - YTD % used/
Transactions Transactions Recd Prior Year YTD
Fund 071 -Fire Pensions Fond
EXPENSE
Pension Benefits
4,021,161.00
.00
4,021,161.00
384,785.60
.00
1,723,570.43
2,297,590.57
43
1,606,075.74
Contractual Services
124,600.00
.00
124,600.00
5,755.66
.00
44,419.94
80,180.06
36
36,068.32
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
32.22
Otfier Expenditures
12,000.00
.00
12,000.
8,000.00
.00
8,000.00
4,000.00
67
8,025.00
EXPENSE TOTALS
$4,173,7
$0.00
$4,173,761.00
$398,541.26
$0.00
$1,775,990.37
$2,397,770.63
43%
$1,650,201.28
Fund 071 - Fire Pension Fund'Totals
$4,173,761.00
$0.
$ 4,173,761.00
$398,541.26
$0.00
$1,775,990.37
$2,397,770.63
$1,650,201.28
Grand Totals $116,983,802.00 $3,339,419.O0 $120,323,221.00 $9,027,048.21 $13,579,690.64 $36,166,247,75 $70,577,282.61 $32,729,042.28
N
In
VILLAGE OF MOUNT PROSPECT
List of Bills
May 29 - June 11, 2014
Fund Vendor Name Invoice Description Amount
001 General Fund
A & J Sewer Service Triple basin cleaning at Fire Station 12 $ 305.00
Page 1 of 11
Equipment Maintenance and Repair
305.00
Triple basin cleaning at Public Works
405.00
Triple basin cleaning at Fire Station 14
305.00
Equipment Maintenance and Repair
305.00
Abbott Rubber Co., Inc.
Salt Spreader Parts
429.00
Salt Spreader Parts
(269.72)
Ablis, Julius
Refund Overpayment Vehicle License Fee
18.00
ABT Electronics
Maintenance and repair supplies
288.00
ACS State & Local Government Solutions
Illinois State Disbursement Unit
3,379.60
Addison Building Material Co.
Other Equipment
51.42
Alexian Brothers Medical Center
Professional Services
345.00
Professional Services
345.00
Drug /Alcohol Screening
69.00
Ali, Alyssa
Host Inside the Park
300.00
Amer Reprographics Co Llc
Equipment Maintenance
62.00
American Arborist Supplies
Other Equipment
242.66
American Building Services
Maintenance & Repair Supplies
530.00
American Landscaping Inc.
Professional Services
270.00
Grass cutting - 21 N. Lancaster
210.00
Flower Maintenance
285.00
Flower Maintenance
285.00
Anderson Pest Solutions
June pest control for the CCC
48.00
Andres Medical Billing, Ltd.
Ambulance Billing - May 2014
5,504.55
APWA -IPSI
Travel and Meeting Expenses
695.00
Travel and Meeting Expenses
695.00
Aramark Uniform Services, Inc.
Uniform Cleaning and Rental
116.22
Uniform rental and cleaning for all public works employees
116.22
Uniform cleaning and rental for all public works employees
116.22
Arlington Power Equipment
Other Equipment
49.99
AT&T
Service 5/16/14 - 6/15/14
712.98
Service 5/16/14 - 6/15/14
341.65
B & H Industries
Other Equipment
64.63
Office Supplies
106.58
B & H Photo /video
Flat Screen TV
216.99
Video Supplies
570.03
Balazs, Judith
Other supplies
42.70
Bald Eagle Window Cleaning
Window cleaning services at all buildings for May
2,000.00
Baldini, Carol
Reimbursement for expenses at the MRC Region V Conference
22.29
Bedco Mechanical
Bi- monthly service to all HVAC units at all buildings
2,033.30
Building Maintenance and Repair
402.50
Replace refrigerant in HVAC system at the Village Hall
993.80
Bella Flowers & Greenhouse, Inc.
Forestry Tree /Bush /Flower Replacement
4,722.20
Beth Ellen Clem
Camera work for ballet and tap and jazz recitals
600.00
Busse's Flowers & Gifts
Get Well Arrangement
80.00
Nurses appreciation week - flowers for Seleen
35.00
Sympathy Arrangement
90.00
Flowers & Gifts
60.00
Capital One National Association
Costco Purchased 4/30/14 - 5/22/14
2,864.92
Carlsbad Manufacturing Corporation
Other Equipment
3,602.39
Forestry Equipment
2,490.15
Other Equipment
781.05
Carranza, Jorge
Replacement Check # 782012 (9/11/13)
40.00
CDW Government, Inc.
Windows 8.1 Pro Licenses
6,097.00
Century Cleaners
Uniform Cleaning
16.40
Uniform Cleaning
14.58
Uniform Cleaning
14.13
Uniform Cleaning
39.00
Uniform Cleaning
12.75
Page 1 of 11
VILLAGE OF MOUNT PROSPECT
List of Bills
May 29 - June 11, 2014
Fund Vendor Name
Invoice Descriotion
Amount
Century Cleaners
Uniform Cleaning
10.03
Uniform Cleaning
12.30
Uniform Cleaning
20.48
Uniform Cleaning
10.48
Uniform Cleaning
14.58
Uniform Cleaning
14.13
Uniform Cleaning
23.30
Uniform Cleaning
22.75
Uniform Cleaning
12.30
Uniform Cleaning
20.48
Uniform Cleaning
33.78
Uniform Cleaning
12.30
Chem -wise Ecological Pest Mgmt Inc
Pest control services at Public Works for May
215.00
Chicago Metro Chapter Apwa
Travel and Meeting Expenses
180.00
Travel and Meeting Expenses
120.00
Training Expenses
284.34
Comcast
Xfinity internet 06/11- 07/10/14
68.95
Community College District 502
Training courses for various officers
696.00
Conrad Polygraph, Incorporated
Romano Polygraph
160.00
Consery F /S, Inc.
Grounds Maintenance Supplies
1,499.53
Constellation NewEnergy, Inc.
Electrical Service Delivery
29.37
Electrical Service Delivery
29.37
Cook County Recorder of Deeds
Recording
286.00
County of Lake, Illinois
Register L. Schaps for training course 07/11/14
30.00
Crystal Court Shopping Center
July rent for the Community Connection Ctr
5,723.03
Crystal Maintenance Services Corp.
Cleaning Services at all public buildings for the month of June
7,181.81
Dahlgren, Alec
Safety Shoe Allowance
130.79
Data Management Incorporated
TimeClock Plus Annual Support
988.20
Davidsmeyer Bus Service, Inc.
Bus for CFSF
313.76
De Lage Landen Financial Services, Inc.
Copier Lease Payment
1,690.20
CCC Contract Charge
260.55
Dempsey, Emily C
Refund Overpayment Police Ticket # P3934198
10.00
Dennison Leafblad, Deborah
Camera work for tap and jazz recitals
450.00
Department of the Army National Guard USPFO
Use of Marseilles training center for firearms training
57.00
Dix, Kenneth S.
2014 Fire Uniform Allowance
46.73
East, James
2014 Fire Uniform Allowance
125.00
Ehret, Jonathan
Safety Shoe Allowance
180.00
Elite Remodeling Group, Inc.
Garnishment
142.22
Equipment Management Company
Extrication equipment
2,433.00
Eterno, David G.
Legal
337.50
Experian
Employment testing: background checks (April & May)
77.72
Federal Express Corp
Shipping costs
132.76
Fire Pension Fund
Fire Pension
26,375.69
Firefighter Behavioral Health Alliance
Saving Those Who Save Others Workshop
3,285.00
Fleck's Landscaping
Plow Damage Seeding Contract
222.00
Gambino Landscaping and Brick Paving, Inc.
Contractual Sprinkler Maintenance
2,164.38
Contractual Sprinkler Maintenance
677.25
Garvey's Office Products
Office Supplies
(79.99)
Office Supplies
85.93
Guardian
Emp. Dental Plan June 2014
9,083.58
Hall Signs, Inc.
Sign Making Material
942.00
Hart, Vincent J
Refund Overpayment Police Ticket # P3934201
10.00
HD Supply Waterworks, Ltd.
Other Equipment
810.00
Healy Asphalt Company,llc.
Asphalt patching material used to repair streets
2,092.80
Street Patching Materials
57.42
Asphalt materials used for street patching
1,152.00
Asphalt materials used for street patching
104.91
Asphalt materials used for street patching
414.81
Asphalt materials used for street patching
254.40
Asphalt materials used for street patching
173.26
Asphalt materials used for street patching
808.34
Street Patching Materials
138.11
Asphalt materials used for street patching
68.32
Page 2 of 11
VILLAGE OF MOUNT PROSPECT
List of Bills
May 29 - June 11, 2014
Fund Vendor Name
Invoice Descriotion
Amount
Heinking, Jill
Reimbursement for expenses from MRC Region V Conference
22.27
Hoefert, Paul
Travel and Meeting Expenses
35.00
Home Depot U.S.A., Inc.
Maintenance and repair supplies
483.43
Building Materials for Training Props
25.84
Homer Tree Care, Inc.
Tree Removals
2,807.10
Tree Removals
1,055.45
Tree Removals
435.00
Tree Removals
9,354.29
Tree Removals
9,770.55
Grounds Maintenance
762.50
ICMA Retirement Trust - 457
ICMA 457 (flat percent)
20,438.08
Illinois American Water Company
Private Fire Service 5/31/14- 7/1/14
33.84
Illinois City /county Mgmt Assoc. (ilcma)
Membership Fees
188.00
Janonis ILCMA membership dues
402.00
Illinois Convenience & Safety Corp
Fridays on the Green 2014 Bus Shelter Posters
320.00
Illinois Department of Revenue
IL State Withholding
71.56
IL State Withholding
40.33
Monthly Payroll May 2014
71.56
IL State Withholding
43,160.24
Garnishment II
154.93
Illinois Public Health Assoc
Reg fee for Carol Baldini - Integrated Public Health Summit
100.00
Reg. fee for Jill Heinking - Integrated Public Health Summit
100.00
Illinois State Police
Romano Fingerprinting
31.50
IMRF
IMRF
156,624.43
Infor (US), Inc.
Hansen - Laserfiche Interface
193.00
Infor Public Sector, Inc.
Quarterly Maintenance Fee
11,700.00
Insty - prints of Palatine, Inc.
Pocket SOPs
296.25
Internal Revenue Service
Federal Withholding
464.70
Federal Withholding
426.77
Federal Withholding
330.89
Retiree Pension May 2014
464.70
Monthly Payroll May 2014
426.77
Federal Withholding
209,995.71
International Union of Operating Engineers
IUOE PW Membership Dues
1,028.52
Intoximeters, Inc.
Mouthpieces for breath machines
133.00
ISA
Travel and Meeting Expenses
222.00
Travel and Meeting Expenses
445.00
Janowick, Timothy
Reimburse expenses: Sgts' exam process
60.36
K. Fish Color LLC
Forestry Tree /Bush /Flower Replacement
1,224.00
Karlstedt Landscape Group, Inc.
Parkway Restoration
824.60
Kathleen W. Bono,csr,ltd.
Court Reporter Attendance & Original Transcript
729.40
Kerstein, June
Reimbursement - Food Expense 5/1/14
28.83
Kone, Inc.
Elevator Maintenance agreement for Fire Station 14 - March bill
300.58
Kramer Tree Specialists
Tree Trimming
4,664.00
Parkway Stump Removals
6,921.00
Parkway Stump Removals
19,149.90
Parkway Stump Removals
8,409.60
Parkway Stump Removals
3,070.35
Parkway Stump Removals
12,208.95
Parkway Stump Removals
22,194.20
Tree Trimming
6,850.00
Lands' End Business Outfitters
Credit - Scherbaum Returned Items
(41.03)
Clothing - Garcia
114.40
Clothing - Massani
129.95
Uniforms purchased for Public Works employees
771.76
Uniforms purchased for Public Works employees
149.62
Lauterbach & Amen, LLP
Professional Services - Audit of the Financial Statements
22,650.00
Life Assist
Mega Movers, Drug Locks
396.48
Lollino, Vito & Carmela
Rebate Transfer Stamp
390.00
Malcolm, John
2014 Fire Uniform Allowance
459.25
Mcmaster -carr Supply Co.
Maintenance and repair supplies
799.94
McVeigh- Cushing, Cathleen A.
Edit of Library Life program
550.00
Menards
Maintenance and repair supplies
10.00
Page 3 of 11
VILLAGE OF MOUNT PROSPECT
List of Bills
May 29 - June 11, 2014
Fund Vendor Name
Invoice Description
Amount
Menards
Maintenance and repair supplies
23.00
Metro Federal Credit Union
MP Fire Local 4119 Dues
2,318.11
Metropolitan Alliance - Police
MP Police Association Dues
1,347.50
Michael Wagner & Sons, Inc.
Equipment Maintenance and Repair
249.84
Equipment Maintenance and Repair
67.50
Minarcik, Anthony L.
2014 Fire Uniform Allowance
124.99
Mobile Print Inc.
Business Cards - Roels, Scherbaum
75.66
Business Cards - Massani, Beckner
108.64
Stickers for CPU / Oberweis event
108.64
Fridays On The Green 2014 Concerts Posters
123.19
Fridays on Green Concerts 2014 Rackcards
509.25
Mount Prospect Paint, Inc.
Equipment Maintenance and Repair
73.57
Maintenance and repair supplies
297.94
Maintenance and repair supplies
70.69
Maintenance and repair supplies
15.12
Murray and Trettel Inc.
Weather Severe Weather Warning for Heavy Rains, High Winds, Hall
2,100.00
Muthusamy, Saminathan
Refund Vehicle License Fee
36.00
Nationwide Mutual Insurance Company
Nationwide 457 (flat percent)
13,441.39
NATOA
registration for National NATOA Conference
575.00
NCPERS Group Life Ins.
IMRF Life Insurance
665.60
NICOR
Natural Gas Consumption
44.08
Natural Gas Consumption
53.70
Natural Gas Consumption
44.96
Natural Gas Consumption
465.38
Natural Gas Consumption
2,064.31
Natural Gas Consumption
1,503.02
Northern Illinois Police Alarm System
Annual NIPAS meeting 05/21/14
125.00
Northshore University Healthsystem
Medical exam: D. 011ech
431.00
Northwest Central Dispatch System
July 2014 - Member Assessment
56,811.12
Northwest Suburban United Way
United Way
257.14
Pacific Telemanagement Services
Service 6/1/14 - 6/30/14
78.00
Paddock Publications, Inc.
Bid Notice
74.25
Papke, Benjamin
CDL Reimbursement
30.00
Paul Conway Shields, Inc.
Retirement Gift for Chief Semkiu
87.89
Pentegra Systems
Repairs to the Village Board Room Equipment
635.50
Performance Battery Group, Inc.
Maintenance and repair supplies
450.00
Peterson, Bradley
2014 Fire Uniform Allowance
125.00
Petty Cash
Police Department Petty Cash 5/28/14
177.63
Petty Cash May 2014
29.71
Petty Cash
218.11
Petty Cash -June 2014
20.52
Petty Cash -FD- May 2014
21.77
Increase VMO Petty Cash
500.00
Police Pension Fund
Police Pension
37,356.59
Proforma Customized Graphics
PW Supplies
314.40
Promos 911, Inc.
Custom Sticker Badges
538.42
Ravenswood Special Events, Inc.
Block Party 2014 Events Entertainment and Management
14,325.00
Red Wing Shoe Store
Safety Shoe Allowance
157.49
Russi, Charles
Refund Overpayment Police Ticket # 3934417
36.00
Russo Power Equipment
Other Equipment
107.88
Sadowski, Jill
Safety Shoe Allowance
118.00
Safe Kids Worldwide
CPS recertification for B. Arciszewski
50.00
Secretary of State
A997345 -1 -22 - 2014 License Plate Sticker Renewal
101.00
A997346 -1 -23 - 2014 License Plate Sticker Renewal
101.00
A997340 -1-24 - 2014 License Plate Sticker Renewal
101.00
H511755 -1-28 - 2014 License Plate Sticker Renewal
101.00
A997342 -1 -29 - 2014 License Plate Sticker Renewal
101.00
A997343 -1 -30 - 2014 License Plate Sticker Renewal
101.00
A997344 - S -25 - 2014 License Plate Sticker Renewal
101.00
Shaw Industries, Inc.
New flooring tiles to be used Public Works
39,583.95
SHI International Corp.
iPad cover for Mayor
88.00
iPad for Mayor
468.00
Smartnet Renewals
1,659.80
Page 4 of 11
VILLAGE OF MOUNT PROSPECT
List of Bills
May 29 - June 11, 2014
Fund Vendor Name
Invoice Description
Amount
Shwier, Julie D
Refund Overpayment Police Ticket # P3933836
10.00
Signs By Tomorrow
Special Events Supplies
575.00
Sister Cities International
Sister Cities 2014 Membership
680.00
Sogo, Tetsuya
Refund Overpayment Vehicle License Fee
49.00
Solano, Celina
Refund Police Ticket # P3932798
30.00
Stanard & Associates, Inc.
New Hire Testing for Ciabattari and Wysong
750.00
Standard Equipment Company
Sweeper dirt shoes
350.82
4502 Water fill hose
274.11
Staples Contract & Commercial, Inc.
Office Supplies
11.55
State of Illinois
Monthly Internet Fees
1,166.25
Steiner Electric Company
Street light supplies
92.00
Stephen A. Laser Assoc.,p.c.
Pre - employment testing: 0. Saric
550.00
Stockwood Inc.
Fridays Concerts on the Green Beatolution 2014
800.00
Swat, Kevin
2014 Fire Uniform Allowance
84.98
Systems Forms, Inc.
Specialty Printing Paper for Brochure
57.00
Printing of 2,743 permit folders
3,127.79
#10 Custom Window Envelopes
885.56
T.P.I.
Building Inspections
23,415.50
Taves, Rochelle
Safety Shoe Allowance
135.43
Taylor Rental Center
Maintenance and repair supplies
171.92
Maintenance and repair supplies
149.67
The Manfred Group, LLC
Professional Services
200.00
The Ups Store
Shipping Expenses
181.28
Thomas, Jeffrey Joseph
SCBA Identification Tags
854.00
Thompson Elevator Inspections
Elevator Inspections
2,812.00
Elevator Inspections
3,183.00
Elevator Inspections
185.00
Elevator Inspections
75.00
Elevator Inspections
150.00
TransUnion Risk and Alternative Data Solutions Inc
Background checks - May, 2014
110.50
U.S. Bank Equipment Finance, Inc.
P.W. Copy 1 Contract Payment #31862
167.50
Fire Sta. #12 Tag #31906 Contract Payment
138.78
VCG Uniform
Body armor: 0. Saric
800.00
Body armor: P. Hernandez
800.00
Vena, Joseph B.
2014 Fire Uniform Allowance
350.50
Verizon Wireless Services LLC
Cellular Service & Equipment Charges
5,996.83
Village of Mount Prospect
Flex - Medical
8,773.77
Period 3/26/14 - 5/2/14
5.50
Village of Romeoville
Registration K. Laurinaitis, Rope Ops, 5/12 -5/16 2014
430.00
Wal -Mart Community
Maintenance and repair supplies
112.20
Warehouse Direct
Office Supplies
205.29
Pens, Flair Pens, Envelopes
123.76
Return paper, wrong size
(23.10)
Wisconsin Department of Revenue
WI State Withholding
412.95
WISCTF
Garnishment
542.48
Zac, Rebecca
Reimburse expenses: CPS recertification
50.00
001 General Fund Total
$ 945,524.55
002 Debt Service Fund
Bank of New York Mellon
2009 GO Bond Interest Payment
$ 208,631.25
2009B GO Bond Interest Payment
42,862.50
2009C GO Bond Interest Payment
67,511.25
2013 GO Bond Interest Payment
268,218.28
2014 GO Bond Interest Payment
61,327.50
Glenview State Bank
GO Installment Note 2012 Interest Payment
11,261.25
J.P. Morgan Chase Bank N.A.
Village Refunding Series 2011B Interest Payment
63,189.00
Village Refunding Series 2012 Interest Payment
27,047.50
002 Debt Service Fund Total
$ 750,048.53
020 Capital Improvement Fund
Equipment Management Company Extrication equipment $ 65,000.00
EWS Consultants, Inc. Design /Consultation Services 500.00
Northwest Central 9 -1 -1 System Motorola Subscriber Financing - June 2014 10,603.91
Page 5 of 11
VILLAGE OF MOUNT PROSPECT
List of Bills
May 29 - June 11, 2014
Fund Vendor Name Invoice Description Amount
Shaw Industries, Inc. New flooring tiles to be used Public Works 47,663.03
Utility Dynamics Corp. Street Light Improvements 8,605.10
020 Capital Improvement Fund Total $ 132,372.04
023 Street Improvement Construction Fund
ARC Disposal Company
Street Resurfacing Disposal
$
11,147.30
Arrow Road Construction
2014 Street Resurfacing
Huffman, William W.
1,169,265.00
Baxter & Woodman, Inc.
Traffic Improvements
ICMA 457 (flat percent)
1,215.00
Patel, Prakashbhai
Refund Street Resurfacing Program
95.98
620.00
Proforma Customized Graphics
RIB Bags
Internal Revenue Service
2,034.87
023 Street Improvement Construction Fund Total
Paddock Publications, Inc.
$
1,184,282.17
024 Flood Control Construction Fund
CDBG -1st Qtr Subrecipient
2,250.00
Burns & Mcdonnell Engineering Co.
Engineering Services
$
28,527.80
Constellation NewEnergy, Inc.
Electrical Service Delivery
176.80
024 Flood Control Construction Fund Total
$
28,704.60
040 Refuse Disposal Fund
ARC Disposal Company
Street Resurfacing Disposal
$
316.02
AT&T
Service 5/16/14 - 6/15/14
3.97
ICMA Retirement Trust - 457
ICMA 457 (flat percent)
45.65
Illinois Department of Revenue
IL State Withholding
432.46
IMRF
IMRF
2,792.74
Infor (US), Inc.
Hansen - Laserfiche Interface
64.46
Internal Revenue Service
Federal Withholding
3,016.13
International Union of Operating Engineers
IUOE PW Membership Dues
99.23
Nationwide Mutual Insurance Company
Nationwide 457 (flat percent)
110.00
NCPERS Group Life Ins.
IMRF Life Insurance
17.60
Northwest Suburban United Way
United Way
3.85
Village of Mount Prospect
Flex - Medical
79.38
040 Refuse Disposal Fund Total
$
6,981.49
041 Motor Fuel Tax Fund
Constellation NewEnergy, Inc.
Electrical Service Delivery
$
54.18
Electrical Service Delivery
184.25
Electrical Service Delivery
10,551.85
Electrical Service Delivery
1,949.99
Electrical Service Delivery
326.05
Electrical Service Delivery
285.01
Electrical Service Delivery
318.41
Electrical Service Delivery
25.41
Electrical Service Delivery
83.15
Electrical Service Delivery
29.12
Electrical Service Delivery
122.17
Electrical Service Delivery
87.12
Electrical Service Delivery
80.05
Electrical Service Delivery
106.96
Electrical Service Delivery
97.77
Electrical Service Delivery
183.14
Electrical Service Delivery
54.41
Lyons & Pinner Electric Companies
Traffic Light Maintenance
614.00
041 Motor Fuel Tax Fund Total
$
15,153.04
042 Community Development Block Grant
Chicago Title Insurance
CDBG SFR Title Search
$ 75.00
De Lage Landen Financial Services, Inc.
Copier Lease Payment
94.80
Huffman, William W.
Spring 2014 Parkway Tree Planting
24,985.00
ICMA Retirement Trust - 457
ICMA 457 (flat percent)
112.50
Illinois Department of Revenue
IL State Withholding
95.98
IMRF
IMRF
545.99
Internal Revenue Service
Federal Withholding
575.84
Paddock Publications, Inc.
CDBG legal notice
85.05
Pads to Hope, Inc.
CDBG -1st Qtr Subrecipient
2,250.00
Page 6 of 11
Fund
Vendor Name
Saewert, Janet
Village of Mount Prospect
042 Community Development Block Grant Total
045 DUI Fine Fund
EMS Barcode Solutions, LLC
045 DUI Fine Fund Total
050 Water and Sewer Fund
APWA -IPSI
Aramark Uniform Services, Inc.
AT &T
Badger Meter Inc
Baxter & Woodman, Inc.
Burns & Mcdonnell Engineering Co.
C. Stamis
Carl Ekberg
Central Continental Bakery
Century Cleaners
Chicago Metro Chapter Apwa
Constellation NewEnergy, Inc.
Dell Marketing L.P.
Fed'I National Mortgage Corporation
Globe Construction
Grainger Inc.
HBK Water Meter Service
ICMA Retirement Trust - 457
Igor /anna Davydov
Illinois Department of Revenue
IMRF
Infor (US), Inc.
Internal Revenue Service
International Union of Operating Engineers
Karlstedt Landscape Group, Inc.
L & B Business Services Inc.
Lands' End Business Outfitters
Lauterbach & Amen, LLP
Martam Construction
Mighty Mites Awards & Sons
Mont Blanc Construction
Nationwide Mutual Insurance Company
VILLAGE OF MOUNT PROSPECT
List of Bills
May 29 - June 11, 2014
Invoice [
CDBG- HUD meeting expense
Flex - Medical
Department inventory tracking software & equipment
Travel and Meeting Expenses
Uniform Cleaning and Rental
Uniform rental and cleaning for all public works employees
Uniform cleaning and rental for all public works employees
Service 5/16/14 - 6/15/14
AMR /AMI System
Combined Sewer System Evaluation Study
Professional Services
Emergency Generators
Utility Refund - 505 Man A Wa Trl
Utility Refund - 220 University Dr
Other supplies
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Training Expenses
Electrical Service Delivery
E -Port Replicator for PW
Utility Refund -1519 Stonegate Mnr
Concrete Restorations
Repair Maintenance Supplies
Building Sewer Inspections
ICMA 457 (flat percent)
Utility Refund - 5 S Emerson St # B
IL State Withholding
IMRF
Hansen - Laserfiche Interface
Federal Withholding
IUOE PW Membership Dues
Parkway Restoration
Maintenance Supplies
Uniforms purchased for Public Works employees
Uniforms purchased for Public Works employees
Professional Services -Audit of the Financial Statements
Contractual Hauling
Contractual Hauling
Contractual Hauling
Other supplies
Utility Refund - 1509 Larch Dr
Nationwide 457 (flat percent)
Page 7 of 11
Amount
26.70
78.13
$ 28,924.99
$ 2,671.31
$ 2,671.31
$ 695.00
116.23
116.23
116.23
264.77
112,290.50
3,158.47
411.25
2,904.00
12.50
69.21
404.33
16.40
14.57
14.12
39.00
12.75
10.02
12.30
20.47
10.47
14.57
14.12
23.30
22.75
12.30
20.47
33.77
12.30
1,150.66
9,364.55
127.49
20.26
13,422.24
112.56
82.00
1,322.94
104.31
3,581.40
23,145.01
128.54
22,645.79
927.52
7,791.90
26.50
771.77
149.63
7,550.00
1,622.33
3,539.35
2,170.80
258.38
35.18
420.90
VILLAGE OF MOUNT PROSPECT
List of Bills
May 29 - June 11, 2014
Fund Vendor Name
Invoice Description
Amount
NCPERS Group Life Ins.
IMRF Life Insurance
52.80
Northwest Suburban United Way
United Way
34.73
Paddock Publications, Inc.
Bid Notice
64.80
Papke, Benjamin
Safety Shoe Allowance
180.00
Paul Johns
Utility Refund - 218 Hanover PI
18.93
Petty Cash
Petty Cash -June 2014
79.76
Putra, Jessica
Travel and Meeting Expenses
982.33
Red Wing Shoe Store
Safety Shoe Allowance
157.49
Robert Labedzki
Utility Refund -115 Hi Lusi Ave
58.28
Ruth J. Hunter
Utility Refund -1915 Seminole Ln
12.08
Steiner Electric Company
Tank Repair Supplies
39.55
Stephen A. Laser Assoc.,p.c.
Professional Services
2,400.00
27.44
Professional Services
800.00
Suburban Laboratories, Inc.
Water Sample Testing
307.00
Tank Industry Consultants, Inc.
Tank Repair Rehab
5,187.32
060 Vehicle Maintenance Fund
Tank Repair Rehab
3,067.50
Third Millennium Assoc.inc.
May 2014- Utility Billing
2,389.17
TigerDirect, Inc.
Repair Maintenance Supplies
39.67
Gas
Repair Maintenance & Supplies
369.53
U.S. Bank Equipment Finance, Inc.
P.W. Copy 1 Contract Payment #31862
167.50
Verizon Wireless Services LLC
Cellular Service & Equipment Charges
494.07
Village of Mount Prospect
Flex - Medical
625.45
Warehouse Direct
Office Supplies
205.30
Witold Skowron
Utility Refund - 311 Westgate Rd
32.89
Ziebell Water Service Products
Repair Maintenance Supplies
57.60
050 Water and Sewer Fund Total
(123.40)
$ 238,794.52
051 Village Parking System Fund
Crystal Maintenance Services Corp.
Cleaning Services at all public buildings for the month of June
$ 318.57
Elite Remodeling Group, Inc.
Garnishment
78.19
ICMA Retirement Trust - 457
ICMA 457 (flat percent)
6.00
Illinois Department of Revenue
IL State Withholding
59.48
Illinois Department of Revenue
Garnishment II
85.18
IMRF
IMRF
446.00
Internal Revenue Service
Federal Withholding
365.69
International Union of Operating Engineers
IUOE PW Membership Dues
15.21
Nationwide Mutual Insurance Company
Nationwide 457 (flat percent)
9.96
Petty Cash
Petty Cash May 2014
102.00
Village of Mount Prospect
Flex- Medical
34.64
051 Village Parking System Fund Total
$ 1,520.92
052 Parking System Revenue Fund
Crystal Maintenance Services Corp.
Cleaning Services at all public buildings for the month of June
$
269.62
Elite Remodeling Group, Inc.
Garnishment
64.02
ICMA Retirement Trust - 457
ICMA 457 (flat percent)
4.00
Illinois Department of Revenue
IL State Withholding
43.29
Garnishment II
69.75
IMRF
IMRF
326.14
Internal Revenue Service
Federal Withholding
265.17
International Union of Operating Engineers
IUOE PW Membership Dues
10.17
Nationwide Mutual Insurance Company
Nationwide 457 (flat percent)
6.64
Village of Mount Prospect
Flex - Medical
27.44
Period 3/31/14 - 5/2/14
35.00
052 Parking System Revenue Fund Total
$
1,121.24
060 Vehicle Maintenance Fund
Addison Building Material Co.
Gas
$
107.60
Gas
234.32
Alexander Equip.co., Inc.
Vehicle Maintenance Supplies
326.90
American Messaging
Professional Service
73.00
Arlington Heights Ford
313 Steering shaft
383.47
Vehicle Maintenance Supplies
659.41
Vehicle Maintenance Supplies
(123.40)
Page 8 of 11
VILLAGE OF MOUNT PROSPECT
List of Bills
May 29 - June 11, 2014
Fund Vendor Name
Invoice Description
Amount
Arlington Heights Ford
4542 Rear glass latch
33.10
General Small Tools
30.95
2742 A/C line
89.84
2749 Driver seat belt
199.26
Equipment Maintenance and Repair
100.00
AT&T
Service 5/16/14 - 6/15/14
9.92
Botts Welding & Truck Service, Inc.
4512 Front and rear springs
2,696.12
Chicago Parts & Sound Llc
Vehicle Maintenance Supplies
(382.77)
P -19 Blower Motor
41.93
Squad Radiator Fan
198.76
P -19 Thermostat
13.72
CV Squad Radiator Cap and Housing
23.64
N -51 Cooling fan and module
307.49
Headlight bulbs and connector
72.88
P -7 Blend door motor
47.81
Vehicle Maintenance Supplies
130.70
505 Front brake pads and rotors
469.90
P -39 Blend door motor
47.81
Brake Rotors
99.96
P -6 Wheel sensors, radiator fan and relay
403.85
P -3 Water pump
66.57
A/C Refrigerant
285.00
Ehrhardt's Trailer Sales Inc
Vehicle Maintenance Supplies
26.99
Vehicle Maintenance Supplies
26.99
Enterprise Oil Co
Diesel Engine Oil
4,465.00
General Parts Inc.
3/4" Impact Gun
664.99
Brake hardware
59.54
2729 Belt
26.77
Global Emergency Products
518 Fire engine decal replacements from downtown fire
109.43
Fire engine headlight adjusters
158.44
517 Headlight adjuster assy
98.84
Grossinger Chevrolet
P -42 A/C accumulator
47.39
Equipment Maintenance and Repair
150.00
ICMA Retirement Trust - 457
ICMA 457 (flat percent)
601.97
Illinois Department of Revenue
IL State Withholding
1,610.30
IMRF
IMRF
11,669.44
Inland Power Group Inc.
4512 Trans gasket
9.41
Internal Revenue Service
Federal Withholding
9,993.45
International Union of Operating Engineers
IUOE PW Membership Dues
469.72
J. P. Simons & Company
Vehicle Maintenance Supplies
63.00
Leach Enterprises, Inc.
Vehicle Maintenance Supplies
222.84
Napa- Heights Automotive Supply
I -60 Brake line fitting
29.88
P -19 Power outlet
45.98
T -53 battery
30.79
Aluminum polish
12.98
4514 Ball joints
68.14
NCPERS Group Life Ins.
IMRF Life Insurance
48.00
Northwest Suburban United Way
United Way
3.85
Palatine Oil, Inc.
7,459 Gallons unleaded fuel
25,597.12
Parkside Auto Body Inc
Equipment Maintenance and Repair
564.00
Pomp's Tire Service, Inc.
4502 Sweeper front tires
655.66
4502 Front tires
629.50
Precision Service & Parts
4565 Gas cap
13.91
505 Front brake pads
41.22
1 -28 Transmission filters
110.85
Belt tensioner
71.08
GM coolant
111.36
Rush Truck Centers of Illinois, Inc.
4512 Belt tensioner
164.24
Schnittker, John
Training Expenses
135.00
Spaulding Mfg Inc
Vehicle Maintenance Supplies
160.39
Vehicle Maintenance Supplies
31.78
Terrace Supply Company
Equipment Rental
17.00
Helium
186.34
Page 9 of 11
VILLAGE OF MOUNT PROSPECT
List of Bills
May 29 - June 11, 2014
Fund Vendor Name
Invoice Description
Amount
UPS Store #707
Shipping Expenses
7.93
Vehicle Service Partners, Inc.
Gas
220.81
Verizon Wireless Services LLC
Cellular Service & Equipment Charges
143.80
Village of Mount Prospect
Flex - Medical
195.84
Warehouse Direct
Office Supplies
140.76
Wholesale Direct Inc.
Vehicle Maintenance Supplies
43.35
060 Vehicle Maintenance Fund Total
$
66,603.81
061 Vehicle Replacement Fund
Pierce Manufacturing Inc.
2014 Pierce Pumper
$
538,275.00
Ziebart of Illinois
New Truck 2757 undercoating
550.00
061 Vehicle Replacement Fund Total
$
538,825.00
063 Risk Management Fund
International Union of Operating Engineers
PWInsurance -July 2014
$
550.00
Utility Dynamics Corp.
Streetlight Knockdown
640.00
063 Risk Management Fund Total
$
1,190.00
070 Police Pension Fund
Internal Revenue Service
Federal Withholding
$
41,206.79
070 Police Pension Fund Total
$
41,206.79
071 Fire Pension Fund
Internal Revenue Service
Federal Withholding
$
38,916.00
071 Fire Pension Fund Total
$
38,916.00
073 Escrow Deposit Fund
A Affordable Roofing
Escrow Refund Permit # 14 -0526 (1796 S Elmhurst Rd)
$
125.00
A Better Plumber
Escrow Refund Permit # 14 -0591 (1304 Burning Bush Ln)
125.00
Banks, Samuel W
Escrow Refund Permit # 14 -0557
200.00
Brunetti, Vito
Escrow Refund Permit # 14- 0761(421 S William St)
75.00
CKA Mechanical Inc
Escrow Refund Permit #14 -0238 (220 S Albert St)
125.00
CLP /SPF Randhurst
Escrow Refund Permit # 13 -1169 (1052 Center Dr)
200.00
Curran, Sean
Escrow Refund Permit # 13 -0996
400.00
De Monte, Frank
Escrow Refund Permit # 13 -0855
125.00
Dehua, Duan
Escrow Refund Permit # 14 -0136
350.00
Dependable Concrete
Escrow Refund Permit # 14 -0607 (1408 Lowden Ln)
200.00
E & J Builders Inc
Escrow Refund Permit # 13 -0754 (313 N Owen St)
500.00
Fortis Concrete
Escrow Refund Permit # 14 -0366 (1105 Ironwood Dr)
200.00
Escrow Refund Permit # 14 -0446 (213 South Louis St)
200.00
Gartshore, John
Escrow Refund Permit # 13 -1818
200.00
Great Space Home Improvement
Escrow Refund Permit # 13 -0872
350.00
Green T Services
Escrow Refund Permit # 14 -0563 (218 N Elmhurst Ave)
200.00
H2O Plumbing and Sewer Services
Escrow Refund Permit # 13 -0243 (414 Eastwood Ave)
125.00
Ibbotson Heating Company
Escrow Refund Permit # 14 -0544 (317 Leonard Lane)
125.00
Irwin, Zanobia
Escrow Refund Permit # 14 -0576
200.00
Istifan, Youkhana
Escrow Refund Permit # 13 -1676 (413 E Lincoln St)
125.00
JNL Climate Control Inc
Escrow Refund Permit # 14 -0510 (502 E Kensington Rd # A)
125.00
Kopec, Michael
Escrow Refund Permit # 13 -2184
200.00
Lakeshore Construction Group Inc
Escrow Refund Permit # 14 -0592 (1145 Boxwood Dr)
125.00
M & M Builders
Escrow Refund Permit # 14 -0739
125.00
Madia, Giuseppe
Escrow Refund Permit # 14 -0903
125.00
Main Street Remodeling LLC
Escrow Refund Permit # 14 -0257 (1450 N Elmhurst Rd # 102)
75.00
McDonough, Brendon
Escrow Refund Permit # 13 -2187
225.00
Miller, Jamie
Escrow Refund Permit # 14 -0776
125.00
Neville, James
Escrow Refund Permit # 14 -0605
200.00
Norb & Sons Electric
Escrow Refund Permit # 14 -0478 (208 George St)
125.00
Reliable Sign & Awning
Escrow Refund Permit # 13 -1747 (1646 W Algonquin Rd)
125.00
Rick's Sewer & Drainage
Escrow Refund Permit # 14- 0751(913 tower Dr)
125.00
Roto Rooter Glenview
Escrow Refund Permit # 13 -0234 (415 Bob O Link Rd)
125.00
Escrow Refund Permit # 14-0780 (1511 Lowden Lane)
125.00
Schroeder, Crystal
Escrow Refund Permit # 14 -0012
150.00
Sherman, Peter C
Escrow Refund Permit # 13 -1815
200.00
Page 10 of 11
VILLAGE OF MOUNT PROSPECT
List of Bills
May 29 - June 11, 2014
Fund Vendor Name Invoice Description Amount
Sign A Rama Escrow Refund Permit # 14 -0484 (710 E Northwest Hwy) 125.00
Splitt, Earl Escrow Refund Permit #14 -0827 200.00
Swanson Home Maintenance Escrow Refund Permit # 14 -0539 (1004 Wheeling Rd) 300.00
Third District Circuit Court Bond Check 5/30/14 350.00
Bond Check 420.00
Trevino, Ricard
Wilvar Enterprises Inc
Winkler, Nancy
Wisniewski, Gregory
073 Escrow Deposit Fund Total
Bond Check 6/4/14
Bond Check 6/10/14
Escrow Refund Permit # 14 -0782 ( 802 W Gregory St)
Escrow Refund Permit # 13 -2396 (4 Randhurst Village Dr)
Escrow Refund Permit # 14 -0202
Escrow Refund Permit # 14 -0471
240.00
840.00
500.00
500.00
125.00
150.00
074 Series 2002 Library Bond
J.P. Morgan Chase Bank N.A.
Wells Fargo Bank
074 Series 2002 Library Bond Total
Grand Total
GO Library Refunding Series 2011A Interest Payment
GO Series 2006 Interest Payment
$ 10,200.00
$ 25,462.50
191,726.25
$ 217,188.75
$ 4,250,229.75
Page 11 of 11