HomeMy WebLinkAbout3. Monthly Financial Report & Approve Bills 03/16/2015I'ZOUIIt Prospect
Village of Mount Prospect
Mount Prospect, Illinois
INTEROFFICE MEMORANDUM
TO VILLAGE PRESIDENT AND BOARD OF TRUSTEES
FINANCE COMMISSION
FROM: FINANCE DIRECTOR
DATE: MARCH 12, 2015
SUBJECT: MONTHLY FINANCIAL REPORT — FEBRUARY 2015
Attached hereto are the cash position and investment statements of the Village for the month
ended February 28, 2015. These statements provide a snapshot of the Village's cash position
as of the month end date noted and are intended to supplement the budget revenue and
expenditure summary and listing of bills you receive. The first statement presents the Village's
cash position broken down by governmental and enterprise funds and trust and agency funds.
The second statement presents the Village's cash position by fund type. The third statement
presents the list of investments again broken down by governmental and enterprise funds and
trust and agency funds. It is important to note that although we have included the trust and
agency funds in the cash position report, these funds are not accessible for Village operations.
They are restricted for pension and escrow funding only. Please read the summary that follows
for further detail on the cash position of the Village.
Cash and Investment Position Report — All Funds (page 1)
This report provides a detail 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, Debt Service Fund, Special Revenue Funds, Capital Project Funds and
Internal Service Funds. The Enterprise Funds consist of the Water/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 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 Library Bonds Escrow
Fund accounts for the accumulation of monies for debt service payments.
Governmental and Enterprise Funds - Cash and cash equivalents at January 31 were $37.3
million. During February cash receipts totaled $7,341,861. Investment income for the month was
$1,238. Reductions in cash and cash equivalents during February totaled $5,061,545. Of this
amount, payments to vendors were $3,547,837 and employee payroll and related expenses
were $1,506.172. Other disbursements totaled $7,536. There was also a net increase in cash
due to interfund activity of $198,600. Cash and cash equivalents at February 28 were $39.8
million.
Monthly Financial Report — February 2015
March 12, 2015
Page 2
Investments in the Governmental and Enterprise Funds at February 28, 2015 were $6,137,603.
There was no investment activity during the month of February.
Total cash and investments for Governmental and Enterprise Funds at January 31 were
$43,430,855. Cash and investments at February 28 totaled $45,911,009. This is an increase of
$2,480,154.
Trust and Agency Funds - Cash and cash equivalents at January 31 were $4.5 million. During
February, cash receipts totaled $1,010,058 and investment income was $124,612. There was a
net decrease in cash due to investment activities of $893,556. Reductions in cash and cash
equivalents during February totaled $840,871. Of this amount, payments to vendors were
$222,076, employee payroll related expenses were $609,516 and payments related to the
flexible spending program totaled $3,905. Other disbursements totaled $5,374. There was also
a net decrease in cash due to interfund activity of $198,600. Cash and cash equivalents at
February 28 were $3.7 million.
Total investments at February 28 were $113,916,595, an increase of $2,455,993 from January
31. There were unrealized investment gains of $1,562,437 and a transfer from cash of $893,556
that accounted for the change.
Total cash and investments for Trust and Agency Funds at January 31 were $115.9 million.
Cash and investments at February 28 totaled $117.6 million. This is an increase for the month
of $1.7 million.
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 detail explanation on activity of the General Fund, the Village's
primary operating fund. The report will also provide additional information on fund types that
experienced higher than normal activity for the month. Each of these is highlighted below.
General Fund - Cash and cash equivalents at January 31 totaled $6,947,717. During
February, cash receipts totaled $4,449,234 and investment income was $203. Significant cash
receipts included property and sales taxes, and real estate transfer tax.
Initial receipts of the first installment of 2014 property taxes were taken in during February.
General corporate receipts of $2,818,790 were received during the month. This represents
roughly 18.3% of the total corporate levy of property taxes.
Sales tax revenues for the month totaled $1,221,719. Of this amount, $1,109,656 was
generated from the 1% state portion while $112,063 was generated from the .25% home
rule portion. Sales taxes received in February are for November sales as there is a normal
three-month lag in getting this distribution from the state.
H:\ACCT\Treasurer's Report\2015\Monthly Cash Position Report - February 2015.docx
Monthly Financial Report — February 2015
March 12, 2015
Page 3
Real estate transfer tax receipts for February totaled $351,763. This amount represents
almost 44% of the total budgeted amount. Year-to-date receipts total $448,237 which
represents over 56% of the total budgeted amount. Several larger transactions closed
during the month that account for the higher than typical month.
Disbursements from the General Fund for February included payments to vendors of
$1,307,721 and payments for employee wages and benefits of $1,302,152. Other
disbursements totaled $7,916. Interfund transfers of $607,117 for health premiums and vehicle
lease and maintenance payments were also made during the month.
Cash and cash equivalents at February 28 were $8,172,247. There were no investments in the
General Fund at February 28.
Statement of Investments (page 3)
This report provides a breakdown of investments by trust and agency funds and governmental
and enterprise funds. The report also provides a fund -by -fund breakdown of the investments.
Trust and Agency Funds — The investments for the trust and agency funds are made up of
certificates of deposits, fixed income investments and equity mutual funds. CD's (if any) held in
the Escrow Deposit Fund will generally have maturities of between 30 and 120 days. Most of
the reserves for this fund are invested in the more liquid money market account due to the
nature of the deposit. Escrow refunds are processed two times per month.
Investments for the Police and Firefighter Pension Funds consist of various fixed income
securities as well as equity mutual fund accounts. Wells Fargo is the third -party holder of the
fixed income securities. The funds are managed by three investment management firms,
Galliard, Segall Bryant and Mesirow Financial. Segall Bryant holds approximately half of the
fixed income investments for the two pension funds while Galliard and Mesirow manage the
balance of fixed income investments for these two funds. Each manager maintains a small
portion of their portfolio in cash to help facilitate liquidity and trading.
Investments in equities consist of mutual funds spread across various sectors (small, mid and
large -cap stocks) as well as investment philosophies (value, core and growth). The funds also
invest a small amount in international stocks. Each year the investment mix is evaluated for
optimal diversification to meet pension fund investment policy goals and objectives. Equity
investments held by the Police Pension Fund are managed by Sawyer Falduto Asset
Management. Below is a breakdown of how the pension fund portfolios are invested.
Maturity Purchase Financial
Date Date Institution
POLICE PENSION FUND (070)
Various Various Wells Fargo
Various Various Various
FIRE PENSION FUND (071}
Various Various Wells Fargo
Various Various Various
TOTAL TRUST AND AGENCY FUND INVESTMENTS
Investment
CUSIP/
Interest
Market
Description
Acct 8
Rate %
Value
Wells Fargo Investments
Various
Various
$ 23,358,216.08
Mutual Fund Investments
Various
Various
35,364,212.75
58,722,428.83
Wells Fargo Investments Various Various 20,334,308.74
Mutual Fund Investments Various Various 34,859,857.58
55,194,166.32
$ 113,9(6,595.15
H:WCCT\Treasurer's Report\2015\Monthly Cash Position Report - February 2015.docx
Monthly Financial Report - February 2015
March 12, 2015
Page 4
Investment of the Village's pension funds is governed by an Investment Policy adopted by each
Pension Board.
Government and Enterprise Funds - Investments for the governmental and agency funds are
typically made up of Certificates of Deposit. At February 28 there was a total of $6.1 million
invested in CD's. These CD's are investing proceeds of the 2013 flood control bond issue.
Other surplus funds in the governmental and enterprise funds have been placed in interest
bearing money market accounts.
Maturity
Purchase
Financial
Investment
CUSIP/
Date
Date
Institution
Description
FDIC 9
Net Yield
PUCCh Price
FLOOD CONTROL CONSTRUCTION FUND (0241
06/15/15
01/05/15
Landmark Community Bank, TN
Certificate of Deposit
34982
0.123%
249,800.00
06/15/15
01/05/15
Farmers St Bank Waterloo, IA
Certificate of Deposit
12855
0.123%
249,800.00
V6/ 15/15
01105/ I5
C 111.0 .R.". B."', N10
C.l t4V i.aLG Llf D.flllllt
9J0(nJ
00.12051.
249,0VV.VV
06/15/15
01/05/15
Texas Capital Bank, TX
Cerrtificate of Deposit
34383
0.120%
249,800.00
06/15/15
01/05/15
The First, NA, ME
Certificate of Deposit
4256
0.124%
249,800.00
06/15/15
01/05/15
Banco Popular North America, IL
Certificate of Deposit
34967
0.120%
82,800.00
06/15/15
01/05/15
Banco Popular Nath America, 1L
Certificate of Deposit
34967
0.120%
84,000.00
06/15/15
01/05/15
Banco Popular Nath America, IL
Certificate of Deposit
34967
0.120%
83,000.00
06/15/15
01/05/15
West Alliance/Torrey Pines, CA
Certificate of Deposit
57512
0.120%
249,800.00
07/08/15
01/09/15
0.3% -Bank of India CD
Certificate of Deposit
06278CJ89
0.253%
249,057.30
07/13/15
01/13/15
0.4%- Bank of Baroda CD
Certificate of Deposit
06062AB81
0.201%
249,246.06
07/15/15
01/05/15
Bank of China, NY
Certificate of Deposit
33653
0.216%
249,700.00
07/15/15
01/05/15
Bridgewater Bank, MN
Certificate of Deposit
58210
0.216%
249,700.00
07/15/15
01/05/15
Foothills Bank & Trust, TN
Certificate of Deposit
58591
0.203%
249,500.00
07/15/15
01/05/15
Modern Bank Nat'l Assoc, NY
Certificate of Deposit
22398
0.203%
249,500.00
07/15/15
01/05/15
Seaside Nat'l Bank & Trust, FL
Certificate of Deposit
58328
0.210%
249,500.00
08/17/15
01/05/15
ONB Bank and Trust Co, OK
Certificate of Deposit
35348
0.209%
249,400.00
08/17/15
01/05/15
Bank Leumi USA, NY
Certificate of Deposit
19842
0.200%
249,400.00
08/17/15
01/05/15
Orrstown Bank, PA
Certificate of Deposit
713
0.200%
249,400.00
08/17/15
01/05/15
Private Bank -Ml,MI
Certificate of Deposit
224
0.206%
249,400.00
09/15/15
01/05/15
Bank or the Ozarks, AR
Certificate of Deposit
110
0.262%
249,500.00
09/15/15
01/05/15
Onewest Bank, NA, CA
Certificate of Deposit
58978
0.310%
249,400.00
09/15/15
01/05/15
IDB Bank - NY, NY
Certificate of Deposit
19977
0.243%
249,200.00
09/15/15
01/05/15
Enerbank USA, UT
Certificate of Deposit
57293
0.250%
249,300.00
10/15/15
01105/15
United Texas Bank, TX
Certificate of Deposit
26626
0.343%
249,300.00
10/15/15
01/05/15
Affiliated Bank. TX
Certificate of Deposit
34885
0.343%
249,300.00
10/15/15
01/05/15
Royal Business Bank, CA
Certificate of Deposit
58816
0.303%
150,000.00
6,137,603.36
TOTAL GOVERNMENTAL AND ENTERPRISE FUNDS
6,137,603.36
Conclusion
As mentioned earlier, this cash position report is intended to provide a snapshot of the Village's
cash position as of a particular month end date. 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. The cash position report will
continue to be provided to the Village Board and Finance Commission on a monthly basis.
David O. Erb
Finance Director
H:WCCT\Treasurer's Report\2015\Monthly Cash Position Report - February 2015.docx
VILLAGE OF MOUNT PROSPECT
Preliminary Cash and Investment Position Report - All Funds
For the Month Ended February 28, 2015
GOVERNMENTAL AND ENTERPRISE FUNDS
TRUST AND AGENCY FUNDS *
Cash and Cash Total Cash and
Equivalents Investments Investments
Balance at January 31, 2015 $ 4,473,916.63 $ 111,460,602.35 $ 115,934,518.98
Cash receipts
Cash and Cash
Total Cash and
124,611.94 1,562,437.41
Equivalents Investments
Investments
Balance at January 31, 2015
$ 37,293,251.50 $ 6,137,603.36
$ 43,430,854.86
Cash receipts
7,341,861.02
7,341,861.02
Investment income
1,238.06 -
1,238.06
Transfers from investments to cash
-
Transfers to investments from cash
_ _
Interfund activity
198,599.85
198,599.85
Disbursements:
Accounts payable
(3,547,837.10)
(3,547,837.10)
Payroll
(1,506,172.12)
(1,506,172.12)
Other
(7,535.76)
(7,535.76)
Balance at February 28, 2015
$ 39,773,405.45 $ 6,137,603.36
$ 45,911,008.81
TRUST AND AGENCY FUNDS *
Cash and Cash Total Cash and
Equivalents Investments Investments
Balance at January 31, 2015 $ 4,473,916.63 $ 111,460,602.35 $ 115,934,518.98
Cash receipts
1,010,058.13
Investment income (loss)
124,611.94 1,562,437.41
Transfers from investments to cash
1,358,807.11 (1,358,807.11)
Transfers to investments from cash
(2,252,362.50) 2,252,362.50
Interfund activity
(198,599.85)
Disbursements:
Accounts payable
Payroll
Flex spending
Other
Balance at February 28, 2015
(222,075.94)
(609,516.13)
(3,905.37)
(5,374.36)
1,010,058.13
1,687,049.35
(198,599.85)
(222,075.94)
(609,516.13)
(3,905.37)
(5,374.36)
$ 3,675,559.66 $ 113,916,595.15 $ 117,592,154.81
* Assets are restricted in purpose and do not represent discretionary assets of the government.
1
IM
VILLAGE OF MOUNT PROSPECT
Summary of Cash Activity by Fund Type
For the Month Ended February 28, 2015
INVESTMENTS
Certificates of deposit 6,137,603-36 6,137,603-36 - 6,137,603-36
Wells Fargo investments 43,692,524.82 - 43,692,524,82
Mutual fund investments 70.224,070-33 - 70,224,070,33
Total investments - 6.137,603.36 6.137,603-36 113 916,595 15 120,054,198,51
TOTAL CASH AND INVESTMENTS $ 8,172,247.25 $ 4,194,457.43 $ 478,812.18 $ 17,546,362.25 $ 4,728,200.57 $ 10,790,929.13 $ 45,911,008.81 $1116�443 $ 1,148,163.12 $163.503,163.62
* 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 & CASH EQUIVALENTS
Beginning balance
$ 6,947,716-75
4,201,506.56
$ 122,582-62
$ 10,705,592.06
$ 4,758,591.81
$ 10,557,261.70
$ 37,293,251.50
$ 3,259,430,75
$ 1,214,485-88
$ 41,767,168-13
Cash receipts
4,449,233.66
438,774.74
349,83162
763,292-96
1,236,838,90
103,889.14
7,341,861.02
959,58298
50,475.15
8,351,919.15
Investment income
202.50
55.90
093
384.87
15264
441.22
1,238-06
124,519,58
92.36
125,850-00
Transfers from investments
-
-
-
-
-
-
-
1,358,807-11
-
1,358,807.11
Transfers to investments
-
-(2,252,362.50}
(2,252,362.5D)
(2,252,362,50)
Interfund
(607j16.91)
42,314 74
7,62251
23,002,43
(173,903-08)
906,675.16
198,599.- 85
(173,442.31)
(25,157.54)
000
Disbursements - other
(7,915.67)
-
-
379.91
-
(7,535.76)
a
(5,374.36)
(12,91612)
Disbursements - flexible spending
-
(3,90537)
(3,905,37)
Disbursements - payroll
(1,302,151.83)
(15,75661)
(128,062-82)
(60,200-86)
(1,506,17212)
(609,516.13)
(2,115,688-25)
Disbursements - accounts payable
(1,307,721,25)
(472,437,90)
(1,230,50)
(83,513,43)
(965,79679)
(717,137-23)
(3,547,837.10)
(139,622.94)
(82,453.00)
(3,769,913,04)
Ending balance
8,172,247.25
4,194,457.43
478,812.18
11,408,758 89
4,728,200,57
10,790,929.13
39,773,405,45
2,527,396.54
1,148,163.12
43,448,965.11
INVESTMENTS
Certificates of deposit 6,137,603-36 6,137,603-36 - 6,137,603-36
Wells Fargo investments 43,692,524.82 - 43,692,524,82
Mutual fund investments 70.224,070-33 - 70,224,070,33
Total investments - 6.137,603.36 6.137,603-36 113 916,595 15 120,054,198,51
TOTAL CASH AND INVESTMENTS $ 8,172,247.25 $ 4,194,457.43 $ 478,812.18 $ 17,546,362.25 $ 4,728,200.57 $ 10,790,929.13 $ 45,911,008.81 $1116�443 $ 1,148,163.12 $163.503,163.62
* Assets are restricted in purpose and do not represent discretionary assets of the government.
VILLAGE OF MOUNT PROSPECT
STATEMENT OF INVESTMENTS
As of February 28, 2015
GOVERNMENTAL AND ENTERPRISE FUNDS
Maturity Purchase Financial
Date Date Institution
FLOOD CONTROL CONSTRUCTION FUND (024)
06/15/15
01/05/15
Landmark Community Bank, TN
06/15/15
01/05/15
Farmers St Bank Waterloo, [A
06/15/15
01/05/15
Corner Stone Bank, MO
06/15/15
01/05/15
Texas Capital Bank, TX
06/15/15
01/05/15
The First, NA, ME
06/15/15
01/05/15
Banco Popular North America, IL
06/15/15
01/05/15
Banco Popular North America, IL
06/15/15
01/05/15
Banco Popular North America, IL
06/15/15
01/05/15
West Alliance/Torrey Pines, CA
07/08/15
01/09/15
0.3% - Bank of India CD
07/13/15
01/13/15
0.4%- Bank of Baroda CD
07/15/15
01/05/15
Bank of China, NY
07/15/15
01/05/15
Bridgewater Bank, MN
07/15/15
01/05/15
Foothills Bank & Trust, TN
07/15/15
01/05/15
Modern Bank Nat'l Assoc, NY
07/15/15
01/05/15
Seaside Nat'l Bank & Trust, FL
08/17/15
01/05/15
ONB Bank and Trust Co, OK
08/17/15
01/05/15
Bank Leumi USA, NY
08/17/15
01/05/15
Orrstown Bank, PA
08/17/15
01/05/15
Private Bank - MI, MI
09/15/15
01/05/15
Bank of the Ozarks, AR
09/15/15
01/05/15
Onewest Bank, NA, CA
09/15/15
01/05/15
IDB Bank - NY, NY
09/15/15
01/05/15
Enerbank USA, UT
10/15/15
01/05/15
United Texas Bank, TX
10/15/15
01/05/15
Affiliated Bank. TX
10/15/15
01/05/15
Royal Business Bank, CA
TOTAL GOVERNMENTAL AND ENTERPRISE FUNDS
Maturity Purchase Financial
Date Date Institution
POLICE PENSION FUND (070)
Various Various Wells Fargo
Various Various Various
FIRE PENSION FUND (071)
Various Various Wells Fargo
Various Various Various
Investment
Description
Certificate of Deposit
Certificate of Deposit
Certificate of Deposit
Certificate of Deposit
Certificate of Deposit
Certificate of Deposit
Certificate of Deposit
Certificate of Deposit
Certificate of Deposit
Certificate of Deposit
Certificate of Deposit
Certificate of Deposit
Certificate of Deposit
Certificate of Deposit
Certificate of Deposit
Certificate of Deposit
Certificate of Deposit
Certificate of Deposit
Certificate of Deposit
Certificate of Deposit
Certificate of Deposit
Certificate of Deposit
Certificate of Deposit
Certificate of Deposit
Certificate of Deposit
Certificate of Deposit
Certificate of Deposit
TRUST AND AGENCY FUNDS *
TOTAL TRUST AND AGENCY FUND INVESTMENTS
Investment
Description
Wells Fargo Investments
Mutual Fund Investments
Wells Fargo Investments
Mutual Fund Investments
* Assets are restricted in purpose and do not represent discretionary assets of the government.
CUSIP/
FDIC #
34982
12855
9388
34383
4256
34967
34967
34967
57512
06278CJ89
06062AB81
33653
58210
58591
22398
58328
35348
19842
713
224
110
58978
19977
57293
26626
34885
58816
Net Yield
0.123%
0.123%
0.120%
0.120%
0.124%
0.120%
0.120%
0.120%
0.120%
0.253%
0.201%
0.216%
0.216%
0.203%
0.203%
0.210%
0.209%
0.200%
0.200%
0.206%
0.262%
0.310%
0.243%
0.250%
0,343%
0.343%
0,303%
CUSIP/
Interest
Acct #
Rate %
Various
Various
Various
Various
Various Various
Various Various
Purch Price
249,800.00
249,800.00
249,000.00
249,800.00
249,800.00
82,800.00
84,000.00
83,000.00
249,800.00
249,057.30
249,246.06
249,700.00
249,700.00
249,500.00
249,500.00
249,500.00
249,400.00
249,400.00
249,400.00
249,400,00
249,500.00
249,400.00
249,200.00
249,300.00
249,300.00
249,300.00
150,000.00
6,137,603.36
$ 6,137,603.36
Market
Value
$ 23,358,216.08
35,364,212.75
58,722,428.83
20,334,308.74
34,859,857.58
55,194,166.32
$ 113,916,595.15
VILLAGE OF MOUNT PROSPECT
BUDGET REVENUE
EXPENDITURE SUMMARIES
February 01— February 28, 2015
Account 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
Xlevenue
Budget i
Repo
Through 02/28/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
15,427,500.00
.00
15,427,500.00
2,818,789.99
.00
2,818,789.99
12,608,710.01
18
1,942,832.28
7,457,566.00
.00
7,457,566.00
300,512.81
.00
683,703.49
6,773,862.51
9
519,022.03
1,256,000.00
.00
1,256,000.00
145,414.75
.00
187,547.00
1,068,453.00
15
493,892.32
20,123,200.00
.00
20,123,200.00
92,389.43
.00
150,990.33
19,972,209.67
1
145,128.62
1,633,223.00
.00
1,633,223.00
136,927.16
.00
275,060.78
1,358,162.22
17
284,212.68
439,000.00
.00
439,000.00
27,132.73
.00
50,624.88
388,375.12
12
46,656.30
5,918.00
.00
5,918.00
1,499.55
.00
1,920.53
3,997.47
32
880.55
220,000.00
.00
220,000.00
13,077.76
.00
22,340.30
197,659.70
10
25,559.17
236,000.00
.00
236,000.00
26,043.30
.00
61,047.44
174,952.56
26
75,493.35
20,000.00
.00
20,000.00
.00
.00
.00
20,000.00
0
.00
REVENUE TOTALS $46,818,407.00
$0.00
$46,818,407.00
$3,561,787.48
$0.00
$4,252,024.74
$42,566,382.26
9%
$3,533,677.30
Fund 001- General Fund Totals $46,818,407.00
$0.00
$46,818,407.00
$3,561,787.48
$0.00
$4,252,024.74
$42,566,382.26
$3,533,677.30
r1i
Account Classification
Fund 002 - Debt Service Fund
REVENUE
Property Taxes
Other Taxes
Intergovernmental Revenue
Investment Income
Other Revenue
Other Financing Sources
Revenue Budget by Account Classification
Report
Through 02/28/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
2,254,000.00
.00
2,254,000.00
349,581.62
988,508.00
.00
988,508.00
.00
42,773.00
.00
42,773.00
.00
100.00
.00
100.00
.93
.00
.00
.00
.00
.00
.00
.00
.00
.00
349,581.62
1,904,418.38
16
301,479.18
.00
.00
988,508.00
0
.00
.00
.00
42,773.00
0
.00
.00
.93
99.07
1
.00
.00
.00
.00
...
.00
.00
.00
.00
...
3,231.19
REVENUE TOTALS $3,285,381.00 $0.00 $3,285,381.00 $349,582.55 $0.00 $349,582.55 $2,935,798.45 11% $304,710.37
Fund 002 - Debt Service Fund Totals $3,285,381.00 $0.00 $3,285,381.00 $349,582.55 $0.00 $349,582.55 $2,935,798.45 11 $304,710.37
Account Classification
Fund 020 - Capital Improvement Fund
REVENUE
Other Taxes
Intergovernmental Revenue
Investment Income
Reimbursements
Other Revenue
Other Financing Sources
REVENUE TOTALS
Fund 020 - Capital Improvement Fund Totals
LJ
Zevenue
Budget byAccountClassification
. Report
Through 02/28/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
1,246,000.00
.00
1,246,000.00
.00
.00
.00
1,246,000.00
0
.00
.00
.00
.00
.00
.00
.00
.00
+++
.00
1,000.00
.00
1,000.00
33.67
.00
57.37
942.63
6
101.68
.00
.00
.00
.00
.00
.00
.00
+++
.00
20,000.00
.00
20,000.00
.00
.00
.00
20,000.00
0
.00
.00
.00
.00
.00
.00
.00
.00
+++
.00
$1,267,000.00
$0..00
$1,267,000.00
$33.67
$0.00
$57.37
$1,266,942.63
0%
$101.68
$1,267,000.00
$0.00
$1,267,000.00
$33.67
$0.00
$57.37
$1,266,942.63
$101.68
Adopted Budget
Account Classification Budget Amendments
Fund 022 - Downtown Redevelopment Construct
REVENUE
# ' #[fill
Lu-'sley,1111
Through 02/28/15
Prior Fiscal Year Activity Included
Summary Listing
Amended Current Month YTD YTD Budget - YTD % used/
Budget Transactions Encumbrances Transactions Transactions Rec°d Prior Year YTD
Property Taxes
2,709,000.00
.00
2,709,000.00
108,430.59
.00
108,430.59
2,600,569.41
4
442,357.26
Investment Income
500.00
.00
500.00
5.64
.00
5.64
494.36
1
53.96
Reimbursements
.00
.00
.00
.00
.00
.00
.00
+++
.00
Other Revenue
.00
.00
.00
.00
.00
.00
.00
+++
.00
Other Financing Sources
.00
.00
.00
.00
.00
.00
.00
...
.00
REVENUE TOTALS
$2,709,500.00
$0.00
$2,709,500.00
$108,436.23
$0.00
$108,436.23
$2,601,063.77
4%
$442,411.22
Fund 022 - Downtown Redevelopment Construct Totals
$2,709,500.00
$0.00
$2,709,500.00
$108,436.23
$0.00
$108,436.23
$2,601,063.77
$442,411.22
P
Aevenue Budget by Account Classification
Repo -FIE
Through 02/28/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD 0/b used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions
Rec'd
Prior Year YTD
Fund 023 - Street improvement Construc Fund
REVENUE
Other Taxes
2,056,000.00
.00
2,056,000.00
75,373.04
.00
75,373.04
1,980,626.96
4
60,415.94
Licenses, Permits & Fees
1,540,000.00
.00
1,540,000.00
251,928.00
.00
254,49100
1,285,507.00
17
.00
Intergovernmental Revenue
.00
.00
.00
.00
.00
.00
.00
...
.00
Fines & Forfeits
'00
.00
.00
.00
.00
.00
.00
...
.00
Investment Income
100.00
.00
100.00
110.19
.00
226.29
(126.29)
226
535.39
Reimbursements
.00
.00
.00
.00
.00
.00
.00
...
.00
Other Revenue
6,000.00
.00
6,000.00
.00
.00
.00
6,000.00
0
.00
Other Financing Sources
.00
.00
.00
.00
.00
.00
.00
...
6,540,700z 82
REVENUE TOTALS
$3,602,100.00
$0.00
$3,602,100.00
$327,411.23
$0.00
$330,092.33
$3,272,007.67
9%
$6,601,652.15
Fund 023 - Street Improvement Construc Fund Totals
$3,602,100.00
$0.00
$3,602,100.00
$327,411.23
$0.00
$330,092.33
$3,272,007.67
$6,601,652.15
Lin
".1
L�C,4uzl I 1� I C;4
;'. III I i jq
Adopted Budget
Account Classification Budget Amendments
Fund 024 - flood Control Construction Fund
REVENUE
Through 02/28/15
Prior Fiscal Year Activity Included
Summary Listing
Amended Current Month YTD YTD Budget - YTD 0/b used/
Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Other Taxes
357,000.00
.00
357,000.00
.00
.00
.00
357,000.00
0
.00
Intergovernmental Revenue
.00
.00
.00
.00
.00
.00
.00
...
.00
Charges For Services
.00
.00
.00
,00
.00
.00
.00
+++
.00
Investment Income
1,100.00
.00
1,100.00
1,210,61
.00
2,404.50
(1,304,50)
219
1,917.13
Reimbursements
.00
.00
.00
.00
.00
.00
.00
...
56,438.36
Other Financing Sources
.00
.00
.00
.00
.00
.00
.00
+++
.00
REVENUE TOTALS
$358,100.00
$0.00
$358,100.00
$1,210.61
$0.00
$2,404.50
$355,695.50
1%
$58,355.49
Fund 024 - Flood Control Construction Fund Totals
$358,100.00
$0.00
$358,100.00
$1,210.61
$0.00
$2,404.50
$355,695.50
$58,355.49
Account Classification
Fund 040 - Refuse Disposal Fund
REVENUE
1:(:4v E3= a NFrMM�nml!
Adopted Budget Amended Current Month YTD
Budget Amendments Budget Transactions Encumbrances
:('4 t o +i
Through 02/28/15
Prior Fiscal Year Activity Included
Summary Listing
YTD Budget - YTD % used/
Transactions Transactions Rec°d Prior Year YTE
Property Taxes
.00
.00
.00
.00
.00
.00
.00
+++
46,038.13
Charges For Services
3,549,000.00
.00
3,549,000.00
239,007.89
.00
474,955.69
3,074,044.31
13
398,061.76
Fines & Forfeits
24,000.00
.00
24,000.00
2,449.80
.00
6,142.30
17,857.70
26
4,762.88
Investment Income
500.00
.00
500.00
20.08
.00
36.88
463.12
7
131.92
Reimbursements
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00
0
.00
Other Revenue
371,500.00
.00
371,500.00
14,558.26
.00
14,547.42
356,952.58
4
15,140.68
REVENUE TOTALS $3,946,000.00
$0.00
$3,946,000.00
$256,036.03
$0.00
$495,682.29
$3,450,317.71
13%
$464,135.37
Fund 040 - Refuse Disposal Fund Totals $3,946,000.00
$0.00
$3,946,000.00
$256,036.03
$0.00
$495,682.29
$3,450,317.71
$464,135.37
OD
Account Classification
Fund 041 - Motor Fuel Tax Fund
REVENUE
Revenue Budget by Account Classification
R' • • Uri
Through 02/28/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD
Intergovernmental Revenue 1,320,000.00
.00
1,320,000.00
128,194.94
00
128,194.94
1,191,805.06
10
119,441.94
Investment Income 200.00
.00
200.00
21.62
.00
35.42
164.58
18
2.86
Reimbursements 11,000.00
.00
11,000.00
.00
.00
.00
11,000.00
0
.00
REVENUE TOTALS $1,331,200.00
$0.00
$1,331,200.00
$128,216.56
$0.00
$128,230.36
$1,202,969.64
10%
$119,444.80
Fund 041- Motor Fuel Tax Fund Totals $1,331,200.00
$0.00
$1,331,200.00
$128,216.56
$0.00
$128,230.36
$1,202,969.64
$119,444.80
Adopted Budget Amended Current Month YTD
Account Classification Budget Amendments Budget Transactions Encumbrances
Fund 042 - Cmmty Development Block Grant
REVENUE
Through 02/28/15
Prior Fiscal Year Activity Included
Summary Listing
YTD Budget - YTD % used/
Transactions Transactions Rec'd Prior Year YTD
Intergovernmental Revenue 339,264.00
.00
339,264.00
.00
.00
.00
339,264.00 0
.00
Investment Income .00
.00
.00
.00
.00
.00
.00 +++
.00
Other Revenue 80,000.00
.00
80,000.00
24,605.00
.00
24,605.00
55,395.00 31
22,650.00
REVENUE TOTALS $419,264.00
$0.00
$419,264.00
$24,605.00
$0.00
$24,605.00
$394,659.00 6%
$22,650.00
Fund 042 - Cmmty Development Block Grant Totals $419,264.00
$0.00
$419,264.00
$24,605.00
$0.00
$24,605.00
$394,659.00
$22,650.00
F K Revenue Budget by Account Classification
)L
--Repoit
Through 02/28/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget
Amended
Current Month
YTD
YTD Budget - YTD % used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions Transactions Rec'd Prior Year YTD
Fund 043 - Asset Seizure Fund
-
REVENUE
Fines & Forfeits
2,000.00
.00
2,000.00
.00
.00
.00 2,000.00 0 .00
Investment Income
100.00
.00
100.00
1.15
.00
2.05 97.95 2 3.26
REVENUE TOTALS $2,100.00 $0.00 $2,100.00 $1.15 $0.00 $2.05 $2,097.95 0%
Fund 043 - Asset Seizure Fund Totals $2,100.00 $0.00 $2,100.00 $1.15 $0.00 $2.05 $2,097.95
Adopted Budget
Account Classification Budget Amendments
Fund 044 - Federal Equitable Share Funds
REVENUE
itq fill Kill
Through 02/28/15
Prior Fiscal Year Activity Included
Summary Listing
Amended Current Month YTD YTD Budget - YTD % used/
Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD
Fines & Forfeits 100.00
.00
100.00
.00
.00
.00
100.00
0 24,637.80
Investment Income 100.00
.00
100.00
.76
.00
120
97.80
2 1.85
REVENUE TOTALS $200.00
$0.00
$200.00
$0.76
$0.00
$2.20
$197.80
1% $24,639.65
Fund 044 -Federal Equitable Share Funds Totals $200.00
$0.00
$200.00
$0.76
$0.00
$2.20
$197.80
$24,639.65
r
I—
Account Classification
Fund 045 - DUI Fine Fund
REVENUE
Fines & Forfeits
Investment Income
1evenue Budget by Account Classification
Report
Through 02/28/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
20,000.00 .00 20,000.00 .00 '00 .00 20,000.00 0 .00
100.00 .00 100.00 1.96 .00 4.36 95.64 4 8.85
REVENUE TOTALS $20,100.00
Fund 045 - DUI Fine Fund Totals $20,100.00
$0.00 $20,100.00 $1.96 $0.00 $4.36 $20,095.64 0% $8.85
$0.00 $20,100.00 $1.96 $0.00 $4.36 $20,095k4
I
Account Classification
Fund 046 - Foreign Fire Tax Board Fund
REVENUE
Revenue Budget by Account Classification
a i
Through 02/28/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD
Other Taxes
70,000.00
.00
70,000.00
.00
.00
.00
70,000.00
0
_00
Investment Income
300X0
.00
100.00
4.57
AO
8.77
91.23
9
23.38
Other Revenue
.00
.00
.00
.00
.00
.00
.00
+++
.00
Other Financing Sources
.00
.00
.00
.00
.00
.00
.00
+++
X0
REVENUE TOTALS
$70,10000
$0.00
$70,100.00
$4.57
$0.00
$8.77
$70,491.23
0%
$23.38
Fund 046 - Foreign Fire Tax Board Fund Totals
$70,100.00
$0.00
$70,100.00
$4.57
$0.00
$8.77
$70,091.23
$23.38
F1
L.)
r
A.
Account Classification
Fund 048 - Business District Fund
REVENUE
levenue Budget by Account Classcatiol'
Reporj
Through 02/28/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Other Taxes 1,021,000.00
.00
1,021,000.00
37,949.26
.00
37,949.26
983,050.74 4
49,804.07
Investment Income .00
,00
,00
5.76
.00
5.76
(5.76) +++
3.93
Other Financing Sources .00
,00
.00
.00
.00
.00
.00 +++
.00
REVENUE TOTALS $1,021,000.00
$0.00
$1,021,000.00
$37,955.02
$0.00
$37,955.02
$983,044.98 4%
$49,808.00
Fund 048 - Business District Fund Totals $1,021,000.00
$0.00
$1,021,000.00
$37,955.02
$0.00
$37,955.02
$983,044.98
$49,808.00
Account Classification
" 11 / ` TDR11
< i
Adopted Budget Amended Current Month YTD
Budget Amendments Budget Transactions Encumbrances
Through 02/28/15
Prior Fiscal Year Activity Included
Summary Listing
YTD Budget - YTD % used/
Transactions Transactions Recd Prior Year YTC
runs uou - water ana sewer Funa
-
REVENUE
Property Taxes
1,530,000.00
.00
1,530,000.00
.00
.00
.00
1,530,000.00
0
213,500.14
Licenses, Permits & Fees
18,000.00
.00
18,000.00
1,650.00
.00
3,510.00
14,490.00
20
2,460.00
Charges For Services
13,789,000.00
.00
13,789,000.00
958,442.22
.00
1,958,324.97
11,830,675.03
14
1,909,122.54
Fines & Forfeits
118,000.00
.00
118,000.00
11,477.41
.00
23,759.79
94,240.21
20
19,256.65
Investment Income
2,100.00
.00
2,100.00
153.00
.00
303.79
1,796.21
14
323.60
Reimbursements
500.00
.00
500.00
.00
.00
.00
500.00
0
.00
Other Revenue
72,000.00
.00
72,000.00
6,985.79
.00
16,025.79
55,974.21
22
14,235.55
Other Financing Sources
.00
.00
.00
.00
.00
.00
+++
.00
REVENUE TOTALS
$15,529,600.00
$0.00
$15,529,600.00
$978,708.42
$0.00
$2,001,924.34
$13,527,675.66
13%
$2,158,898.48
Fund 050 - Water and Sewer Fund Totals
$15,529,600.00
$0.00
$15,529,600.00
$978,708.42
$0.00
$2,001,924.34
$13,527,675.66
$2,158,898.48
r
Ln
r
rn
Account Classification
Fund 051- Village Parking System Fund
REVENUE
Budget by �
r • r
Through 02/28/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTC
Other Taxes
.00
.00
.00
.00
.00
.00
.00
+++
.00
Charges For Services
124,000.00
.00
124,000.00
10,098.71
.00
19,772.86
104,227.14
16
32,304.81
Investment Income
100.00
.00
100.00
4.04
.00
7.34
92.66
7
18.38
Other Revenue
6,600.00
.00
6,600.00
.00
.00
550.00
6,050.00
8
1,650.00
Other Financing Sources
.00
.00
.00
.00
.00
.00
.00++
.00
REVENUE TOTALS
$130,700.00
$0.00
$130,700.00
$10,102.75
$0.00
$20,330.20
$110,369.80
16%
$33,973.19
Fund 051- Village Parking System Fund Totals
$130,700.00
$0.00
$130,700.00
$10,102.75
$0.00
$20,330.20
$110,369.80
$33,973.19
Account Classification
Fund 052 - Parking System Revenue
REVENUE
Other Taxes
Intergovernmental Revenue
Charges For Services
Investment Income
Other Revenue
Other Financing Sources
REVENUE TOTALS
Fund 052 - Parking System Revenue Fund Totals
r
v
Revenue Budget #Classification
Reporilm-
Through 02/28/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec°d Prior Year YTD
100,000.00
.00
100,000.00
.00
.00
,00
100,000.00
0
.00
.00
.00
.00
X0
.00
.00
.00
+++
.00
119,000.00
.00
119,000.00
9,399.30
.00
18,445.76
100,554.24
16
27,329.92
.00
.00
.00
.00
.00
.00
.00
+++
.00
.00
.00
.00
.00
.00
.00
.00
+++
.00
.00
.00
.00
.00
.00
,00
.00
+++
.00
$219,000.00
$0.00
$219,000.00
$9,399.30
$0.00
$18,445.76
$200,554.24
8%
$27,329.92
$219,000.00
$0.00
$219,000.00
$9,399.30
$0.00
$18,445.76
$200,554.24
$27,329.92
Account Classification
Fund 060 - Vehicle Maintenance Fund
REVENUE
Charges For Services
Investment Income
Other Revenue
X'evenue Budget by Account Classificatio'
Rep: ,
Through 02/28/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD
2,157,889.00 .00 2,157,889.00 179,824.09 .00 359,648.18 1,798,240.82 17 356,386.14
600.00 .00 600.00 25.59 .00 51.86 548.14 9 97.78
.00 .00 .00 200.00 .00 200.00 (200.00) +++ .00
REVENUE TOTALS $2,158,489.00 $0.00 $2,158,489.00 $180,049.68 $0.00 $359,900.04 $1,798,588.96 17% $356,483.92
Fund 060 - Vehicle Maintenance Fund Totals $2,158,489.00 $0.00 $2,158,489.00 $180,049.68 $0.00 $359,900.04 $1,798,588.96 $356,483.92
Mr
-!Zevenue Budget by Account Classcation
Repor-11-
Through 02/28/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Redd Prior Year YTD
Fund 061 - Vehicle Replacement Fund
REVENUE
Charges For Services 1,380,500.00
Fines & Forfeits 11,150.00
Investment Income 7,200.00
Other Revenue .00
Other Financing Sources .00
REVENUE TOTALS $1,398,850.00
Fund 061 - Vehicle Replacement Fund Totals $1,398,850.00
.00
1,380,500.00
115,041.68
.00
230,083.36
1,150,416.64
17
224,383.36
.00
11,150.00
.00
00
.00
11,150.00
0
.00
.00
7,200.00
294.09
587.49
6,612.51
8
1,248.31
.00
.00
.00
.00
.00
.00
...
.00
.00
.00
.00
X0
5,135.27
(5,135.27)
...
.00
$0.00 $1,398,850.00 $115,335.77 $0.00 $235,806.12 $1,163,043.88 1* $225,631.67
$0.00 $1,398,850.00 $115,335.77 $0.00 $235,806.12 $1,163,043.88 $225,631.67
Account Classification
Ir.
levenue Budget by Account Classific t'
Through 02/28/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Fund 062 - Computer Replacement Fund
REVENUE
Charges For Services
272,307.00
.00
272,307.00
22,692.25
'00
45,384.50
226,922.50 17
3,848.00
Investment Income
1,000.00
.00
1,000.00
32.74
,00
68.01
931.99 7
126.13
Other Financing Sources
.00
.00
.00
.00
.00
.00
.00 ...
.00
REVENUE TOTALS
$273,307.00
$0.00
$273,307.00
$22,724.99
$0.00
$45,452.51
$227,854.49 17%
$3,974.13
Fund 062 - Computer Replacement Fund Totals
$273,307.00
$0.00
$273,307.00
$22,724.99
$0.00
$45,452.51
$227,854.49
$3,974.13
Account Classification
Fund 063 - Risk Management Fund
REVENUE
Revenue Budget by Account Classification
Report
Through 02/28/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTC
Charges For Services
6,513,826.00
.00
6,513,826.00
542,493.33
.00
1,010,426.14
5,503,399.86
16
1,179,899.48
Investment Income
3,000.00
.00
3,000.00
88.80
.00
184.37
2,815.63
6
387.49
Reimbursements
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00
0
.00
Other Revenue
1,463,700.00
.00
1,463,700.00
109,544.86
.00
233,790.88
1,229,909.12
16
217,415.72
REVENUE TOTALS
$7,981,526.00
$0.00
$7,981,526.00
$652,126.99
$0.00
$1,244,401.39
$6,737,124.61
16%
$1,397,702.69
Fund 063 - Risk Management Fund Totals
$7,981,526.00
$0.00
$7,981,526.00
$652,126.99
$0.00
$1,244,401.39
$6,737,124.61
$1,397,702.69
N
r
N
N
Revenue Budget
by Account
ClassificationX—M-Maw
Report
Through 02/28/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD % used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions Recd Prior Year YTD
Fund 070 - Police Pension Fund
REVENUE
Charges For Services
.00
.00
.00
.00
.00
.00
.00 ... .00
Investment Income
4,382,800.00
.00
4,382,800.00
1,810,744.53
.00
1,481,249.69
2,901,550.31 34 955,251.19
Other Revenue
3,743,175.00
.00
3,743,175.00
538,401.23
,00
600,356.89
3,142,818.11 16 539,401.29
REVENUE TOTALS
$8,125,975.00
$0.00
$8,125,975.00
$2,349,145.76
$0.00
$2,081,606.58
$6,044,368.42 26% $1,494,652.48
Fund 070 - Police Pension Fund Totals
$8,125,975.00
$0.00
$8,125,975.00
$2,349,145.76
$0.00
$2,081,606.58
$6,044,368.42 $1,494,652.48
Account Classification
Fund 071 - Fire Pension Fund
REVENUE
Investment Income
Other Revenue
N
W
Ievenue Budget by AccountClassification
Reporli
Through 02/28/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
4,250,500.00
.00
4,250,500.00
(102,904.98)
.00
236,622.76
4,013,877.24
6 378,704.62
3,151,125.00
.00
3,151,125.00
458,052.37
.00
507,111.85
2,644,013.15
16 473,108.43
REVENUE TOTALS $7,401,625.00
$0.00
$7,401,625.00
$355,147.39
$0.00
$743,734.61
$6,657,890.39
10% $851,813.05
Fund 071 - Fire Pension Fund Totals $7,401,625.00
$0.00
$7,401,625.00
$355,147.39
$0.00
$743,734.61
$6,657,890.39
$851,813.05
Grand Totals $108,069,524.00 $0.00 $108,069,524.00 $9,468,023.87 $0.00 $12,480,689.32 $95,588,834.68 $18,172,081.05
Adopted Budget
Account Classification Budget Amendments
Fund 001 - General Fund
EXPENSE
Through 02/28/15
Prior Fiscal Year Activity Included
Summary Listing
Amended Current Month YTD YTD Budget - YTD % used/
Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Personal Services, Scheduled Salaries & Wages
24,232,037.00
.00
24,232,037.00
1,936,898.68
.00
3,461,468.70
20,770,568.30
14
3,712,186.72
Employee Benefits
12,235,287.00
.00
12,235,287.00
1,529,270.45
.00
2,023,534.27
10,211,752.73
17
2,007,366.60
Other Employee Costs
440,543.00
(1,500.00)
439,043.00
21,902.95
9,452.50
68,027.49
361,563.01
18
54,227.77
Pension Benefits
46,456.00
.00
46,456.00
3,871.28
.00
7,742.56
38,713.44
17
7,716.72
Contractual Services
7,528,869.00
.00
7,528,869.00
485,566.27
599,793.06
1,159,361.18
5,769,714.76
23
1,073,913.18
Utilities
271,939.00
.00
271,939.00
22,034.81
.00
31,940.80
239,998.20
12
20,835.98
Insurance
415,398.00
.00
415,398.00
34,598.32
.00
69,159.74
346,238.26
17
58,453.32
Commodities & Supplies
641,996.00
1,500.00
643,496.00
27,821.79
32,570.42
65,211.06
545,714.52
15
66,747.11
Other Expenditures
11,140.00
.00
11,140.00
100.00
.00
.00
11,140.00
0
.00
Building Improvements
10,200.00
.00
10,200.00
4,550.96
.00
5,059.51
5,140.49
50
286.90
Office Equipment
33,520.00
.00
33,520.00
1,547.71
915.35
2,100.71
30,503.94
9
941.73
Other Equipment
184,199.00
.00
184,199.00
7,567.96
14,889.93
19,828.49
149,480.58
19
13,576.70
Distribution Systems
100,000.00
.00
100,000.00
.00
81,191.00
.00
18,809.00
81
.00
Infrastructure
666,823.00
.00
666,823.00
2,034.25
77,965.75
2,034.25
586,823.00
12
24,655.65
Interfund Transfers
.00
.00
.00
.00
.00
.00
.00
+++
.00
EXPENSE TOTALS
$46,818,407.00
$0.00
$46,818,407.00
$4,077,765.43
$816,778.01
$6,915,468.76
$39,086,160.23
17%
$7,040,908.38
Fund 001 - General Fund Totals
$46,818,407.00
$0.00
$46,818,407.00
$4,077,765.43
$816,778.01
$6,915,468.76
$39,086,160.23
$7,040,908.38
r
FIT
Account Classification
Fund 002 - Debt Service Fund
EXPENSE
F-xpense Budget by Account Classification
Re • • i
Through 02/28/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions 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,893,913.00
.00
1,893,913.00
.00
.00
.00
1,893,913.00
0
.00
Interest Expense
1,382,571.00
.00
1,382,571.00
.00
.00
.00
1,382,571.00
0
.00
Bank & Fiscal Fees
2,312.00
.00
2,312.00
1,230.50
.00
2,787.14
(475.14)
121
1,908.20
Interfund Transfers
.00
.00
.00
.00
.00
.00
.00
...
.00
Other Financing Uses
.00
.00
.00
.00
.00
.00
.00
+++
.00
EXPENSE TOTALS $3,278,796.00
$0.00
$3,278,796.00
$1,230.50
$0.00
$2,787.14
$3.276,008.86
0%
$1,908.20
Fund 002 - Debt Service Fund Totals $3,278,796.00
$0.00
$3,278,796.00
$1,230.50
$0.00
$2,787.14
$3,276,008.86
$1,908.20
Account Classification
Fund 020 - Capital Improvement Fund
EXPENSE
�xpenseBudget iClassification
R " ! i -
Through 02/28/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTE
Contractual Services
.00
.00
.00
.00
.00
.00
.00
+++
.00
Other Expenditures
.00
.00
.00
.00
.00
.00
.00
+++
.00
Land Improvements
350,000.00
.00
350,000.00
.00
.00
.00
350,000.00
0
.00
Building Improvements
896,000.00
.00
896,000.00
12,900.13
11,277.81
28,850.16
855,872.03
4
.00
Office Equipment
.00
.00
.00
.00
.00
.00
.00
+++
.00
Motor Equipment
.00
.00
.00
.00
.00
.00
.00
+++
.00
Other Equipment
486,747.00
.00
486,747.00
36,018.86
.00
54,704.49
432,042.51
11
25,126.90
Infrastructure
503,000.00
.00
503,000.00
.00
213,075.49
.00
289,924.51
42
.00
Interfund Transfers
.00
.00
.00
.00
.00
.00
.00
+++
.00
EXPENSE TOTALS
$2,235,747.00
$0.00
$2,235,747.00
$48,918.99
$224,353.30
$83,554.65
$1,927,839.05
14%
$25,126.90
Fund 020 - Capital Improvement Fund Totals
$2,235,747.00
$0.00
$2,235,747.00
$48,918.99
$224,353.30
$83,554.65
$1,927,839.05
$25,126.90
Lo
Account Classification
Fund 022 - Downtown Redevelopment Construct
EXPENSE
Contractual Services
Utilities
Other Expenditures
Infrastructure
Bond Principal
Interest Expense
Interfund Transfers
EXPENSE TOTALS
Fund 022 -Downtown Redevelopment Construct Totals
Budget byAccountClassification
r p i
Through 02/28/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec°d Prior Year YTD
109,201.00
.00
109,201.00
.00
57,043.51
.00
52,157.49
52
.00
.00
.00
.00
.00
.00
,00
.00
+++
.00
3,306,969.00
.00
3,306,969.00
4,248.35
.00
4,248.35
3,302,720.65
0
3,833.16
342,285.00
.00
342,285.00
.00
332,042.99
.00
10,242.01
97
.00
.00
.00
.00
.00
.00
.00
.00
+++
.00
.00
..00
.00
.00
.00
,00
.00
+++
.00
.00
.00
.00
.00
.00
.00
.00
+++
.00
$3,758,455.00
$0.00
$3,758,455.00
$4,248.35
$389,086.50
$4,248.35
$3,365,120.15
10%
$3,833.16
$3,758,455.00
$0.00
$3,758,455.00
$4,248.35
$389,086.50
$4,248.35
$3,365,120.15
$3,833.16
Ummw PNNPM
Expense Budget
by Account
Classification
Repoit
Through 02/28/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD % used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions Rec'd Prior Year YTD
Fund 023 - Street Improvement Construc Fund
EXPENSE
Contractual Services
107,000.00
.00
107,000.00
.00
.00
.00
107,000.00 0 40,700.82
Infrastructure
4,715,000.00
.00
4,715,000.00
.00
207,543.52
.00
4,507,456.48 4 .00
Interfund Transfers
.00
.00
.00
.00
.00
.00
.00 +++ .00
EXPENSE TOTALS
$4,822,000.00
$0.00
$4,822,000.00
$0.00
$207,543.52
$0.00
$4,614,456.48 4% $40,700.82
Fund 023 - Street Improvement Construc Fund Totals
$4,822,000.00
$0.00
$4,822,000.00
$0.00
$207,543.52
$0.00
$4,614,456.48 $40,700.82
H
WON IP rIMS]19111
Adopted Budget
Account Classification Budget Amendments
Fund 024 - Flood Control Construction Fund
EXPENSE
Through 02/28/15
Prior Fiscal Year Activity Included
Summary Listing
Amended Current Month YTD YTD Budget - YTD % used/
Budget Transactions Encumbrances Transactions Transactions Rec°d Prior Year YTD
Contractual Services
12,000.00
.00
12,000.00
.00
.00
.00
12,000.00
0
.00
Utilities
2,300.00
.00
2,300.00
106.09
.00
106.09
2,193.91
5
325.73
Commodities & Supplies
5,000.00
.00
5,000.00
.00
.00
.00
5,000.00
0
.00
Other Expenditures
5,100.00
.00
5,100.00
.00
.00
.00
5,100.00
0
.00
Other Equipment
.00
.00
.00
.00
.00
.00
.00
+++
.00
Infrastructure
9,779,960.00
.00
9,779,960.00
.00
8,730,052.09
.00
1,049,907.91
89
30,857.20
EXPENSE TOTALS
$9,804,360.00
$0.00
$9,804,360.00
$106.09
$8,730,052.09
$106.09
$1,074,201.82
89%
$31,182.93
Fund 024 - Flood Control Construction Fund Totals
$9,804,360.00
$0.00
$9,804,360.00
$106.09
$8,730,052.09
$106.09
$1,074,201.82
$31,182.93
Account Classification
Budget iClassification
� e i -
Through 02/28/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTE
Fund 040 - Refuse Disposal Fund
EXPENSE
Personal Services, Scheduled Salaries & Wages
236,644.00
.00
236,644.00
21,998.85
.00
39,449.39
197,194.61
17
46,421.88
Employee Benefits
110,436.00
.00
110,436.00
11,237.47
.00
19,667.42
90,768.58
18
20,102.98
Other Employee Costs
1,248.00
.00
1,248.00
.00
.00
.00
1,248.00
0
.00
Contractual Services
4,294,934.00
.00
4,294,934.00
312,413.31
4,752.15
510,238.82
3,779,943.03
12
511,334.59
Utilities
447.00
.00
447.00
18.23
,00
37.57
409.43
8
42.97
Insurance
31,809.00
.00
31,809.00
2,650.75
.00
5,301.50
26,507.50
17
4,773.34
Commodities & Supplies
38,446.00
.00
38,446.00
126.06
10,064.56
126.06
28,255.38
27
.00
EXPENSE TOTALS
$4,713,964.00
$0.00
$4,713,964.00
$348,444.67
$14,816.71
$574,820.76
$4,124,326.53
13%
$582,675.76
Fund 040 - Refuse Disposal Fund Totals
$4,713,964.00
$0.00
$4,713,964.00
$348,444.67
$14,816.71
$574,820.76
$4,124,326.53
$582,675.76
CID
Account Classification
Fund 041 - Motor Fuel Tax Fund
EXPENSE
-,-xpenseBudget AccountClassification
RepoRt
Through 02/28/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec°d Prior Year YTD
Contractual Services
284,686.00
.00
284,686.00
.00
151,801.40
1,360.00
131,524.60
54
2,792.63
Utilities
156,060.00
.00
156,060.00
19,531.77
.00
19,632.62
136,427.38
13
31,739.55
Commodities & Supplies
453,209.00
.00
453,209.00
30,605.56
160,229.44
144,302.68
148,676.88
67
182,906.73
Building Improvements
600,000.00
.00
600,000.00
.00
.00
.00
600,000.00
0
.00
Infrastructure
663,000.00
,00
663,000.00
.00
.00
.00
663,000.00
0
.00
EXPENSE TOTALS
$2,156,955.00
$0.00
$2,156,955.00
$50,137.33
$312,030.84
$165,295.30
$1,679,628.86
22%
$217,438.91
Fund 041 - Motor Fuel Tax Fund Totals
$2,156,955.00
$0.00
$2,156,955.00
$50,137.33
$312,030.84
$165,295.30
$1,679,628.86
$217,438.91
1111111111 1111111q -iiiiliiil�pi��� I
' '` :/ • •
Zil
Through 02/28/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions
Recd
Prior Year YTD
Fund 042 - Cmmty Development Block Grant
EXPENSE
Personal Services, Scheduled Salaries & Wages
48,783.00
.00
48,783.00
3,344.84
.00
6,020.71
42,762.29
12
6,066.43
Employee Benefits
25,491.00
.00
25,491.00
2,015.55
.00
3,908.83
21,582.17
15
4,063.29
Other Employee Costs
1,040.00
.00
1,040.00
47.50
.00
47.50
992.50
5
.00
Contractual Services
154,430.00
.00
154,430.00
590.36
.00
1,499.65
152,930.35
1
15,899.72
Commodities & Supplies
520.00
.00
520.00
.00
.00
.00
520.00
0
.00
Other Expenditures
189,000.00
.00
189,000.00
80.00
.00
6,800.00
182,200.00
4
80.00
Land Improvements
.00
.00
.00
.00
.00
.00
.00
+++
.00
Building Improvements
.00
.00
.00
.00
.00
.00
.00
+++
.00
Infrastructure
.00
.00
.00
.00
.00
.00
.00
+++
.00
EXPENSE TOTALS
$419,264.00
$0.00
$419,264.00
$6,078.25
$0.00
$18,276.69
$400,987.31
4%
$26,109.44
Fund 042 - Cmmty Development Block Grant Totals
$419,264.00
$0.00
$419,264.00
$6,078.25
$0.00
$18,276.69
$400,987.31
$26,109.44
kD
Account Classification
Fund 043 - Asset Seizure Fund
EXPENSE
!!!xpense Budget by Account Classcation
Repo[ ---'Li
Through 02/28/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transact -ions Transactions Rec'd Prior Year YTD
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
.00
3,000.00 0
1,500.00
Other Equipment 15,000.00
.00
15,000.00
505-54
.00
1,823.63
13,176.37 12
.00
EXPENSE TOTALS $19,000.00
$0.00
$19,000.00
$505.54
$0.00
$1,823.63
$17,176.37 10%
$1,500.00
Fund 043 - Asset Seizure Fund Totals $19,000.00
$0.00
$19,000.00
$505.54
$0.00
$1,823.63
$17,176.37
$1,500.00
Account Classification
Fund 044 - Federal Equitable Share Funds
EXPENSE
Contractual Services
Building Improvements
Other Equipment
EXPENSE TOTALS
Fund 044 - Federal Equitable Share Funds Totals
r
r
Expense Budget by Account Classification
Report
Through 02/28/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec°d Prior Year YTD
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00 0
.00
.00
<00
.00
.00
.00
.00
.00 +++
.00
1,000.00
,00
1,000.00
.00
.00
.00
1,000.00 0
.00
$2,000.00
$0.00
$2,000.00
$0.00
$0.00
$0.00
$2,000.00 0%
$0.00
$2,000.00
$0.00
$2,000.00
$0.00
$0.00
$0.00
$2,000.00
$0.00
r
N
Expense Budget
by Account
ClassificationY-M-Dwepwopm
\tv
Repoit
Through 02/28/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD % used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions Rec'd Prior Year YTD
Fund 045 - DUI Fine Fund
EXPENSE
Other Employee Costs
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00 0 .00
Contractual Services
.00
.00
.00
.00
.00
.00
.00 ... .00
Other Equipment
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00 0 95.99
Interfund Transfers
.00
.00
.00
.00
.00
.00
.00 +++ .00
EXPENSE TOTALS
$2,000.00
$0.00
$2,000.00
$0.00
$0.00
$0.00
$2,000.00 0% $95.99
Fund 045 - DUI Fine Fund Totals
$2,000.00
$0.00
$2,000.00
$0.00
$0.00
$0.00
$2,000.00 $95.99
Adopted Budget
Account Classification Budget Amendments
Fund 046 -Foreign Fire Tax Board Fund
EXPENSE
Through 02/28/15
Prior Fiscal Year Activity Included
Summary Listing
Amended Current Month YTD YTD Budget - YTD % used/
Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTC
Contractual Services
10,000.00
.00
10,000.00
390.00
.00
5,593.16
4,406.84
56
3,094.11
Insurance
500.00
.00
500.00
.00
.00
.00
500.00
0
.00
Commodities & Supplies
5,000.00
.00
5,000.00
.00
.00
.00
5,000.00
0
.00
Other Equipment
15,000.00
.00
15,000.00
.00
.00
.00
15,000.00
0
8,856.00
EXPENSE TOTALS
$30,500.00
$0.00
$30,500.00
$390.00
$0.00
$5,593.16
$24,906.84
18%
$11,950.11
Fund 046 - Foreign Fire Tax Board Fund Totals
$30,500.00
$0.00
$30,500.00
$390.00
$0.00
$5,593.16
$24,906.84
$11,950.11
r
w
r
T-Mmot P'""WP-M
Expense Budget
by Account
Classification
Repoit
Through 02/28/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget Amended Current Month
YTD YTD
Budget - YTD % used/
Account Classification
Budget
Amendments Budget Transactions
Encumbrances Transactions
Transactions Rec'd Prior Year YTD
Fund 048 - Business District Fund
EXPENSE
Bond Principal
.00
.00 .00 ,00
,00 .00
.00 +++ .00
Interest Expense
1,021,000.00
.00 1,021,000.00 00
.00 .00
1,021,000.00 0 .00
EXPENSE TOTALS
$1,021,000.00
$0.00 $1,021,000.00 $0.00
$0.00 $0.00
$1,021,000.00 0% $0.00
Fund 048 - Business District Fund Totals
$1,021,000.00
$0.00 $1,021,000.00 $0.00
$0.00 $0.00
$1,021,000.00 $0.00
Account Classification
Fund 050 - Water and Sewer Fund
EXPENSE
Personal Services, Scheduled Salaries & Wages
Employee Benefits
Other Employee Costs
Contractual Services
Utilities
Insurance
Commodities & Supplies
Other Expenditures
Building Improvements
Office Equipment
Other Equipment
Distribution Systems
Infrastructure
Bond Principal
Interest Expense
Interfund Transfers
Expense Budget by Account Classification
Report
Through 02/28/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
2,006,058.00
.00
2,006,058.00
184,189.82
.00
330,444.42
1,675,613.58
16
399,757.65
772,177.00
.00
772,177.00
79,535.72
.00
138,078.37
634,098.63
18
143,827.21
37,393.00
.00
37,393.00
1,455.00
211.75
2,540.56
34,640.69
7
6,922.32
8,650,244.00
.00
8,650,244.00
187,304.62
395,765.02
803,920.62
7,450,558.36
14
777,792.95
160,913.00
.00
160,913.00
4,988.47
.00
8,056.18
152,856.82
5
6,362.65
101,312.00
.00
101,312.00
8,442.66
.00
16,926.99
84,385.01
17
13,412.32
293,516.00
.00
293,516.00
11,420.66
57,219.74
12,247.33
224,048.93
24
20,307.63
.00
.00
.00
.00
.00
.00
.00
+++
.00
65,000.00
.00
65,000.00
.00
3,250.00
.00
61,750.00
5
.00
3,930.00
.00
3,930.00
.00
.00
.00
3,930.00
0
.00
1,173,744.00
.00
1,173,744.00
9,401.94
1,380,145.10
164,469.44
(370,870.54)
132
.00
2,300,500.00
.00
2,300,500.00
.00
372,768.75
8,777.38
1,918,953.87
17
.00
.00
.00
.00
.00
.00
.00
.00
+++
.00
.00
.00
.00
.00
.00
.00
.00
+++
.00
.00
.00
.00
.00
.00
.00
.00
+++
.00
.00
.00
.00
.00
.00
.00
.00
+++
.00
EXPENSE TOTALS $15,564,787.00 $0.00 $15,564,787.00 $486,738.89 $2,209,360.36 $1,485,461.29 $11,869,965.35 24% $1,368,382.73
Fund 050 -Water and Sewer Fund Totals $15,564,787.00 $0.00 $15,564,787.00 $486,738.89 $2,209,360.36 $1,485,461.29 $11,869,965.35 $1,368,382.73
r
Ln
r
rn
Report
Through 2/28/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec°d Prior Year YTD
Fund 051- Village Parking System Fund
35,175.00
EXPENSE
.00
Personal Services, Scheduled Salaries & Wages
35,175.00
Employee Benefits
17,353.00
Contractual Services
94,382.00
Insurance
2,156.00
Commodities & Supplies
520.00
Other Expenditures
.00
Building Improvements
7,074.00
Infrastructure
153,500.00
Interfund Transfers
.00
21
EXPENSE TOTALS $310,160.00
Fund 051- Village Parking System Fund Totals $310,160.00
.00
35,175.00
2,998.98
.00
5,446.35
29,728.65
15
6,877.82
.00
17,353.00
1,382.78
.00
2,661.48
14,691.52
15
2,706.18
.00
94,382.00
7,632.00
7,970.33
12,150.82
74,260.85
21
13,033.55
.00
2,156.00
179.67
.00
359.34
1,796.66
17
195.84
.00
520.00
.00
.00
.00
520.00
0
00
.00
.00
.00
.00
.00
.00
...
.00
.00
7,074.00
.00
.00
.00
7,074.00
0
.00
.00
153,500.00
.00
.00
.00
153,500.00
0
.00
.00
.00
.00
.00
.00
.00
+++
.00
$0.00 $310,160.00 $12,193.43 $7,970.33 $20,617.99 $281,571.68 9% $22,813.39
$0.00 $310,160.00 $12,193.43 $7,970.33 $20,617.99 $281,571.68 $22,813.39
Ik M"M pbmv�m Expense Budget by Account Classification
Repoit
Through 02/28/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec°d Prior Year YTE
Fund 052 - Parking System Revenue Fund
EXPENSE
Personal Services, Scheduled Salaries & Wages
25,830.00
.00
25,830.00
2,174.93
.00
3,973.32
21,856.68
15
4,916.65
Employee Benefits
13,024.00
.00
13,024.00
1,017.74
.00
1,964.40
11,059.60
15
1,995.38
Contractual Services
114,325.00
.00
114,325.00
8,795.16
5,745.82
12,016.69
96,562.49
16
15,294.10
Utilities
10,733.00
.00
10,733.00
246.30
.00
386.69
10,346.31
4
950.99
Insurance
1,757.00
.00
1,757.00
146.42
.00
292.84
1,464.16
17
234.34
Commodities & Supplies
9,974.00
.00
9,974.00
639.29
.00
639.29
9,334.71
6
1,746.54
Other Expenditures
.00
.00
.00
.00
.00
.00
.00
+++
.00
Building Improvements
75,000..00
.00
75,000,00
.00
.00
.00
75,000.00
0
.00
Infrastructure
.00
.00
.00
.00
.00
.00
.00
+++
.00
Interfund Transfers
.00
.00
.00
.00
.00
.00
.00
+++
.00
EXPENSE TOTALS
$250,643.00
$0.00
$250,643.00
$13,019.84
$5,745.82
$19,273.23
$225,623.95
10%
$25,138.00
Fund 052 - Parking System Revenue Fund Totals
$250,643.00
$0.00
$250,643.00
$13,019.84
$5,745.82
$19,273.23
$225,623.95
$25,138.00
F,
00
Account Classification
Fund 060 - Vehicle Maintenance Fund
EXPENSE
xpenseBudget by Account!
Repormi
Tru 2/2/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD
Personal Services, Scheduled Salaries & Wages
951,226.00
Employee Benefits
379,364.00
Other Employee Costs
2,408.00
Contractual Services
102,813.00
Utilities
3,132.00
Commodities & Supplies
735,223.00
Other Expenditures
.00
Office Equipment
567.00
Other Equipment
20,165.00
.00
EXPENSE TOTALS $2,194,898.00
.00
951,226.00
92,503.80
.00
158,702.47
792,523.53
17
185,292.58
.00
379,364.00
33,137.39
.00
59,999.24
319,364.76
16
65,540.05
.00
2,408.00
.00
,00
174.33
2,233.67
7
375.00
.00
102,813.00
2,544.05
29,479.48
5,334.38
67,999.14
34
12,949.20
.00
3,132.00
574.48
.00
710.60
2,421.40
23
196.01
.00
735,223.00
47,277.33
285,905.97
98,603.84
350,713.19
52
144,111.56
.00
.00
.00
.00
.00
.00
+++
.00
.00
567.00
.00
.00
.00
567.00
0
.00
.00
20,165.00
.00
.00
55.83
20,109.17
0
.00
$0.00
$2,194,898.00
$176,037.05
$315,385.45
$323,580.69
$1,555,931.86
29%
$408,464.40
Fund 060 - Vehicle Maintenance Fund Totals $2,194,898.00 $0.00 $2,194,898.00 $176,037.05 $315,385.45 $323,580.69 $1,555,931.86 $408,464.40
Account Classification
Fund 061 - Vehicle Replacement Fund
EXPENSE
ow
"xpense Budget by Account Classification
Report
Through 02/28/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Other Expenditures _00
.00
.00
.00
.00
.00
.00 +++
.00
Motor Equipment 909,000.00
.00
909,000.00
10,674.29
201,700.99
10,674.29
696,624.72 23
18,064.84
Interfund Transfers .00
.00
.00
,00
.00
.00
.00 +++
.00
EXPENSE TOTALS $909,000.00
$0.00
$909,000.00
$10,674.29
$201,700.99
$10,674.29
$696,624.72 23%
$18,064.84
Fund 061 - Vehicle Replacement Fund Totals $909,000.00
$0.00
$909,000.00
$10,674.29
$201,700.99
$10,674.29
$696,624.72
$18,064.84
N
O
i • / ! ' • r419111
Adopted Budget
Account Classification Budget Amendments
Fund 062 - Computer Replacement Fund
EXPENSE
Through 02/28/15
Prior Fiscal Year Activity Included
Summary Listing
Amended Current Month YTD YTD Budget - YTD % used/
Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Other Expenditures .00
.00
.00
.00
.00
.00
.00 +++
.00
Office Equipment 429,380.00
.00
429,380.00
734.18
3,320.00
32,843.26
393,216.74 8
5,652.35
EXPENSE TOTALS $429,380.00
$0.00
$429,380.00
$734.18
$3,320.00
$32,843.26
$393,216.74 8%
$5,652.35
Fund 062 - Computer Replacement Fund Totals $429,380.00
$0.00
$429,380.00
$734.18
$3,320.00
$32,843.26
$393,216.74
$5,652.35
Account Classification
Fund 063 - Risk Management Fund
EXPENSE
Expense Budget by Account Classification
Report
Through 02/28/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Contractual Services
25,000.00
.00
25,000.00
.00
.00
3,800.00
21,200.00
15
.00
Insurance
7,889,896.00
.00
7,889,896.00
571,496=79
.00
1,266,570.63
6,623,325.37
16
1,398,132.25
Other Equipment
165,000.00
.00
165,000.00
.00
.00
.00
165,000.00
0
.00
Infrastructure
.00
.00
.00
.00
.00
.00
.00
+++
.00
Interfund Transfers
.00
.00
.00
.00
.00
.00
.00
+++
.00
EXPENSE TOTALS
$8,079,896.00
$0.00
$8,079,896.00
$571,496.79
$0.00
$1,270,370.63
$6,809,525.37
16%
$1,398,132.25
Fund 063 - Risk Management Fund Totals
$8,079,896.00
$0.00
$8,079,896.00
$571,496.79
$0.00
$1,270,370.63
$6,809,525.37
$1,398,132.25
Account Classification
Fxpense Budget by Account Classification
Repo -r --'JL
Through 02/28/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Fund 070 - Police Pension Fund
--
EXPENSE
Pension Benefits
4,472,170.00
.00
4,472,170.00
370,716.80
.00
740,754.23
3,731,415.77
17
646,283.56
Contractual Services
154,100.00
.00
154,100.00
.00
.00
1,174.64
152,925.36
1
(2,628.75)
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
100.00
.00
350.00
11,650.00
3
250.00
Office Equipment
.00
.00
.00
.00
.00
-00
.00
...
.00
EXPENSE TOTALS
$4,653,370.00
$0.00
$4,653,370.00
$370,816.80
$0.00
$742,278.87
$3,911,091.13
16%
$643,904.81
Fund 070 - Police Pension Fund Totals
$4,653,370.00
$0.00
$4,653,370.00
$370,816.80
$0.00
$742,278.87
$3,911,091.13
$643,904.81
Account Classification
Fund 071 -Fire Pension Fund
EXPENSE
"xpense Budget by Account Classification
Report
Through 02/28/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTE
Pension Benefits
4,334,168.00
.00
4,334,168.00
369,480.27
.00
739,525.45
3,594,642.55
17
669,127.14
Contractual Services
136,100.00
.00
136,100.00
2,887.00
.00
13,026.15
123,073.85
10
11,234.58
Insurance
15,000.00
.00
15,000.00
.00
.00
.00
15,000.00
0
.00
Commodities & Supplies
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00
0
.00
Other Expenditures
12,000.00
.00
12,000.00
.00
.00
.00
12,000.00
0
.00
EXPENSE TOTALS $4,498,268.00
$0.00
$4,498,268.00
$372,367.27
$0.00
$752,551.60
$3,745,716.40
17%
$680,361.72
Fund 071 - Fire Pension Fund Totals $4,498,268.00
$0.00
$4,498,268.00
$372,367.27
$0.00
$752,551.60
$3,745,716.40
$680,361.72
Grand Totals $115,972,850.00 $0.00 $115,972,850.00 $6,551,903.69 $13,438,143.92 $12,429,626.38 $90,105,079.70 $12,554,345.09
N
W
Page 1 of 9
R
Amount
132.00
132.00
242.02
4,645.52
39.19
125.00
125.00
346.00
227.00
180.45
254.00
248.00
40.00
62.00
60.00
48.00
5,498.64
100.16
100.16
231.30
276.95
111.84
10.91
181.54
686.84
341.79
117.00
101.00
120.00
120.00
100.00
7.95
60.00
6,802.00
1,149.68
16.40
20.95
22.75
7.75
27.30
12.30
215.00
82.90
21.37
375.00
160.00
31.05
31.05
198.00
334.00
5,839.97
7,187.24
1,690.20
260.55
347.80
142.22
VILLAGE OF MOUNT PROSPECT
List of Bills
February 26 - March 11, 2015
Fund Vendor Name
Invoice Description
001 General Fund
199 Randhurst, LLC
Dinner for BOFPC- 3/3/15 Oral Interviews
Dinner for BOFPC-3/2/15 Oral Interviews
A Stars & Stripes Flag Corporation
Flags
ACS State & Local Government Solutions
Illinois State Disbursement Unit
Addison Building Material Co.
Maintenance and repair supplies
AFCI
Register J. Juhl for Annual Fraud Seminar 04/08/15
Register D. 011ech for Annual Fraud Seminar 04/08/15
Air One Equipment, Inc.
SCBA Head Harness Straps
RIT Pack Bag
Alexander Equip.co., Inc.
Forestry Equipment
Alexian Brothers Medical Center
Pre-employment testing - M. Mokijewski
Pre-employment testing
Amaro, Jennifer
Refund Vehicle License Fee
Amer Reprographics Co Llc
Equipment Maintenance
Anders, John T
Refund Vehicle License Fee
Anderson Pest Solutions
March pest control at the CCC
Andres Medical Billing, Ltd.
Ambulance Billing - February 2015
Aramark Uniform Services, Inc.
Uniform Cleaning and Rental
Uniform Cleaning and Rental
Ariens Specialty Brands LLC
Uniforms
Uniforms
Arlington Power Equipment
Fuel for small tools
Shipping Charges
Forestry Equipment
AT&T
Service 2/16/15 - 3/15/15
Service 02/16/15 - 3/15/15
Avanti Cafe & Sandwich Bar, Inc.
2/3/15 Dinner for BOFPC during FF Interviews
2/2/15 Dinner for BOFPC during FF Interviews
Barnett, Lesley
Reimburse training expenses: Police Firearms Instructor 02/16-20
Berg, Christopher
Reimburse training expenses: Police Firearms Instructor 02/16-20
Bright Electrical Supply Co.
Maintenance and repair supplies
Bures, Paul
Reimbursement
Busse's Flowers & Gifts
Sympathy Arrangement for C. Loomis
CDW Government, Inc.
Microsoft SQL User CALs
Microsoft Windows 2012 Std Server Licenses
Century Cleaners
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Chem -wise Ecological Pest Mgmt Inc
Pest control for Public Works in March
Comcast
Xfinity internet service 03/11-04/10/15
Commonwealth Edison
Electrical Service Delivery
Community College District 502
Course registration for Brady, Carlson & Rondeau 01/08/15
Conrad Polygraph, Incorporated
Polygraph for Hamann
Constellation NewEnergy, Inc.
Electrical Service Delivery
Electrical Service Delivery
Cook County Recorder of Deeds
Recording
CoolSpeak, a Limited Liability Company
Partial payment for speaker
Crystal Court Shopping Center
April rent for the CCC
Crystal Maintenance Services Corp.
Custodial Services
De Lage Landen Financial Services, Inc.
Copier Lease Payment
CCC Contract 25250916
Dicaro, Sandra
Celestial Celebration 2015
Elite Remodeling Group, Inc.
Garnishment
Page 1 of 9
R
Amount
132.00
132.00
242.02
4,645.52
39.19
125.00
125.00
346.00
227.00
180.45
254.00
248.00
40.00
62.00
60.00
48.00
5,498.64
100.16
100.16
231.30
276.95
111.84
10.91
181.54
686.84
341.79
117.00
101.00
120.00
120.00
100.00
7.95
60.00
6,802.00
1,149.68
16.40
20.95
22.75
7.75
27.30
12.30
215.00
82.90
21.37
375.00
160.00
31.05
31.05
198.00
334.00
5,839.97
7,187.24
1,690.20
260.55
347.80
142.22
Fund Vendor Name
ERLA, Inc.
Eterno, David G.
Experian
Fawley's Inc.
Federal Express Corp
Fifth Third Bank
Fire Pension Fund
Grainger Inc.
GreatAmerica Financial Services Corporation
Gryphon Training Group Inc.
Guardian
Hastings Air Energy Control Inc.
VILLAGE OF MOUNT PROSPECT
List of Bills
February 26 - March 11, 2015
Invoice I
Healy Asphalt Company,llc.
Home Depot U.S.A., Inc.
Homer Tree Care, Inc.
Hotstick USA, Inc.
ICMA Retirement Trust - 457
ILGISA
Illinois American Water Company
Illinois Arborist Association
Illinois Association of Property&evidence Mgr
Illinois Department of Revenue
Illinois Fire Chiefs Educ. & Research Foundation
Illinois Juvenile Ofcrs Assoc
Illinois Public Employer Labor Relations Assn
Illinois Society of Fire Service Instructors
Illinois State Police
IMRF
Info -Tech Research Group Inc.
Internal Revenue Service
International Association of Financial Crimes Inve
International Homicide Investigator's Association
International Union of Operating Engineers
Juracek, Arlene
Kearney, Ryan
Kerstein, June
Kiplinger Letter
Knox Company
Lambel, Brian
Law Enforcement Records Managers of Illinois
Lexington Corporate Enterprises, Inc.
Lexisnexis Risk Data Management Inc.
Martam Construction
Maxx Contractors Corp
Mazursky, Shelby
Mcmaster-carr Supply Co.
Cot Repair
February billing
Background checks - February 2015
Passports / Name Tags
Shipping Charges
Federal Express Postage 2/18/15
Shipping for equipment repair (2)
Credit Card
Fire Pension
Small Tools
Maintenance and repair supplies
Banner Supplies
Maintenance and repair supplies
Office equipment
Registration for N. Mavraganis for 05/07-08/15
Emp. Dental Plan March 2015
Service/Repair of Hose Connection Sta 12
Service/Repair of Hose Connection sta 13
Service/Repair of Hose Connection sta 14
Street patching materials used for pothole repairs
Home Depot Statement
Tree Removals
Hot Stick (4) Meters
ICMA 457 (flat percent)
ILGISA Membership
Period 2/8/14-2/6/15
Training fees
Register D. Okon for Annual training conference 04/15-17/15
IL State Withholding
IL State Withholding
2015 Annual Membership -Chief Malcolm
Register M. Landeweer for training class 03/18/15
Register R. Smith for training course
Register T. Griffin for training course
Register M. Eterno for training course
Register T. Janowick for training course
Lambel/Health and Safety Officer/2.23.15-2.27.15
Background check for intern (C.Cima)
Pre-employment testing - M. Mokijewski
IMRF
InfoTech Subscription Renewal
Federal Withholding
Federal Withholding
Federal Withholding
Membership: D. 011ech
Annual membership: Lee Schaps
IUOE PW Membership Dues
WGN shirts
Reimbursement
Reimbursement
Reimbursement Food Exp - February 2015
2015 Kiplinger Report
2 KeySecures with Red Strobes
Projector bulb, mouse and memory card for training room
Annual membership: M. Pickett
Maintenance and repair supplies
Background checks -February 2015
Snow Hauling
Monthly payment for section snow plowing for the month of March
One pass of all cul-de-sacs from 2/26/15 snow event
Office Supplies
Street Replacement Furniture and Supplies
Page 2 of 9
Amount
181.98
450.00
77.48
111.20
18.54
21.89
176.34
1,411.89
26, 209.43
34.70
183.99
72.03
951.75
149.47
145.00
9,717.37
559.00
722.96
654.00
1,598.20
121.75
18,312.10
1,130.00
21,424.83
50.00
1,776.39
130.00
355.00
54.09
33,703.40
450.00
20.00
195.00
195.00
195.00
195.00
300.00
31.50
31.50
170,732.72
765.00
458.45
425.99
226,346.79
105.00
50.00
903.37
120.00
20.00
50.00
29.87
99.00
1,186.00
108.76
25.00
108.22
32.75
8,715.00
7,500.00
4,335.00
315.00
173.91
Fund
VILLAGE OF MOUNT PROSPECT
List of Bills
Page 3 of 9
February 26 - March 11, 2015
Vendor Name
Invoice Description
Amount
Mcmaster-carr Supply Co.
Street Replacement Furniture & Supplies
100.57
Menards
ET Equipment
155.73
Maintenance and Repair Supplies
10.88
Light Pole Banners
40.80
Metro Federal Credit Union
MP Fire Local 4119 Dues
2,277.99
Metropolitan Alliance - Police
MP Police Association Dues
1,349.50
Metropolitan Fire Chiefs Assoc
Annual Membership Dues- Chief Malcolm
40.00
Metzger, Melody
Transfer Stamp Rebate
668.00
Michael Wagner & Sons, Inc.
Maintenance and repair supplies
109.08
Micro Tech Systems, Inc.
Station 14 Printer Repair
221.35
Middleton, Joan
Travel Reimbursement
36.40
Miller, James
Wireless Sound System
299.99
Mobile Print Inc.
Office Supplies
97.00
Business cards JAROSZ
32.98
Memo pads for Victoria Bran
30.07
Moinelli, La Deanna
Refund Overpayment Vehicle Sticker Fee
25.00
Morris, Barry J
Maintenance & repairs for fitness equipment
1,206.66
Nationwide Mutual Insurance Company
Nationwide 457 (flat percent)
13,114.77
NCPERS Group Life Ins.
IMRF Life Insurance
673.60
Neenah Foundry Company
Street Replacement Furniture and Supplies
82.79
Neopost USA Inc.
Postage Machine Replenishment - 03/03/15
3,000.00
NICOR
Natural Gas Consumption
97.22
Natural Gas Consumption
46.92
Natural Gas Consumption
139.33
North Suburban Association of Chiefs of Police
2015 Membership: T. Griffin, M. Eterno
150.00
Northern Illinois University
Registration Fee (Event #13920) -1/30/15
228.00
Northwest Central Dispatch System
April 2015 - Member Assessment
56,811.12
Northwest Suburban United Way
United Way
109.86
Office Depot
Office Supplies - January 2015
146.89
Office Supplies for HS & CCC
189.92
Office Supplies
563.05
Office Supplies
145.60
Office Supplies
73.99
Okon, David
Replacement Check #789673 - 10/15/14
200.00
Replacement Check #787538 - 6/25/14
168.00
Paddock Publications, Inc.
Legal notice
82.35
Bid Notice
102.60
Pathak, Pravin V
Refund Overpayment Vehicle Sticker Fee
25.00
Paul Conway Shields, Inc.
Draeger 4 gas meter and charger kit
1,183.50
Perma Seal Basement Systems
Refund Building Fee (Permit #150076) - 405 Na Wa Ta Ave
50.00
Pesche's Flower Shop
Flower/Plant Replacement
162.65
Peterson Roofing
Equipment Maintenance
2,450.00
Petty Cash
Petty Cash Police Department - 2/19/15
203.93
Petty Cash February 2015
231.09
Petty Cash -FD -Feb 2015
98.97
PMO Inc.
Lodging for M. Angarola for DRE Training 04/13-23/15
862.40
Police Pension Fund
Police Pension
32,268.96
QuickSeries Publishing Inc.
Emergency Management Guides
480.94
Rebel's Trophies, Inc.
Retirement Plaque - Follmer
35.00
Ronco Industrial Supply
Custodial Supplies
142.50
Rose, Catherine
Refund Overpayment Police Ticket #133939017
20.00
Signs By Tomorrow
Maintenance and repair supplies
64.60
Staples Contract & Commercial, Inc.
Office Supplies
96.38
Office Supplies
65.69
Office Supplies
6.49
State of Illinois
Internet Monthly Fee
1,166.25
Systems Forms, Inc.
Building Inspection Forms
449.68
The Aby Manufacturing Group, Inc.
Award bars
619.90
Thompson Elevator Inspections
Elevator Inspections/review
187.00
TransUnion Risk and Alternative Data Solutions
Inc Background checks - February 2015
129.75
U.S. Bank Equipment Finance, Inc.
Fire Sta. 12 #31906 - Copy Machine
138.78
United Parcel Service
Shipping charges for Investigations'
10.90
Page 3 of 9
VILLAGE OF MOUNT PROSPECT
List of Bills
February 26 - March 11, 2015
Fund Vendor Name
Invoice Description
Amount
Verizon Wireless Services LLC
Cellular Service & Equipment Charges Jan/Feb 2015
7,442.09
Village of Mount Prospect
Flex - Medical
9,426.15
Wal -mart Stores, Inc.
Membership Renewal
45.00
Warehouse Direct
3v Batteries
19.80
1,516.67
Office Supplies
144.64
12 - 2" Binders and Keyboard Pad for BC Office
62.32
Payment 2 of 2 for Kitchen Countertops
30 Binders (Training and Admin)
93.30
Graybar Electric Co.
4 Boxes of paper and 2 printer toners
247.44
5,871.80
Office Supplies
126.34
Wisconsin Department of Revenue
WI State Withholding
580.71
WISCTF
Garnishment
542.48
Yee, Eugene
Refund Police Ticket #133935195 - Ticket Withdrawn 12/1/14
50.00
Zepole Restaurant Supply Co.
Maintenance and repair supplies
2,176.03
001 General Fund Total
195.05
$ 729,706.02
020 Capital Improvement Fund
Bright Electrical Supply Co.
Electrical work for station 13 kitchen
$
378.51
C52 Design Group, LLC
PW HVAC
573.75
EWS Consultants, Inc.
Design/Consultation Services
150.00
Fifth Third Bank
Credit Card
1,516.67
Gewalt Hamilton Assoc.
KBC Path Design
4,697.79
GLC Industries, Inc.
Payment 2 of 2 for Kitchen Countertops
4,410.00
Graybar Electric Co.
Streetlights Improvements
5,871.80
Nationwide Mutual Insurance Company
Streetlights Supplies
2,935.90
Home Depot U.S.A., Inc.
Home Depot Statement
414.61
Menards
Drawer Organizers for Station 13 Kitchen
22.98
Michael Wagner & Sons, Inc.
Plumbing Materials for Station 13 Kitchen
$
195.05
Northwest Central 9-1-1 System
Motorola Subscriber Financing - March 2015
10,603.91
Schweppe Incorported
Bunn Coffee Maker for Kitchen Remodel
$
765.89
Servicemaster
Kitchen, Hallway and Bathroom Painting at Station 13
5,443.25
Tri-state Electronic Corp
Electrical Work/Lights in Station 13 Kitchen
866.87
Zepole Restaurant Supply Co.
Ice Machine with Drain Pump for Station 13 Kitchen
2,176.03
020 Capital Improvement Fund Total
Electrical Service Delivery
$
41,023.01
024 Flood Control Construction Fund
Electrical Service Delivery
104.90
A Lamp Concrete
Isabella Drainage Improvements Project
$
468,833.40
Burns & Mcdonnell Engineering Co.
Engineering Service
9,457.75
Constellation NewEnergy, Inc.
Electrical Service Delivery
106.09
Electrical Service Delivery
98.38
024 Flood Control Construction Fund Total
$
478,495.62
040 Refuse Disposal Fund
ARC Disposal Company
Debris Disposal
$
107.10
AT & T
Service 2/16/15 - 3/15/15
3.82
ICMA Retirement Trust - 457
ICMA 457 (flat percent)
72.94
Illinois Department of Revenue
IL State Withholding
362.01
IMRF
IMRF
3,770.27
Internal Revenue Service
Federal Withholding
3,472.74
International Union of Operating Engineers
IUOE PW Membership Dues
99.25
Nationwide Mutual Insurance Company
Nationwide 457 (flat percent)
272.95
NCPERS Group Life Ins.
IMRF Life Insurance
17.60
Village of Mount Prospect
Flex - Medical
71.88
040 Refuse Disposal Fund Total
$
8,250.56
041 Motor Fuel Tax Fund
Constellation NewEnergy, Inc.
Electrical Service Delivery
$
77.58
Electrical Service Delivery
106.08
Electrical Service Delivery
123.46
Electrical Service Delivery
123.23
Electrical Service Delivery
2,612.30
Electrical Service Delivery
104.90
Electrical Service Delivery
133.93
Page 4 of 9
VILLAGE OF MOUNT PROSPECT
List of Bills
February 26 - March 11, 2015
Fund Vendor Name Invoice Description
Constellation NewEnergy, Inc. Electrical Service Delivery
Electrical Service Delivery
Electrical Service Delivery
Electrical Service Delivery
Electrical Service Delivery
SNI Solutions, Inc. Liquid de-icing material used for snow and ice control
Anti -icing chemical for snow and ice control
041 Motor Fuel Tax Fund Total
042 Community Development Block Grant
Chicago Title Insurance
CDBG-SFR Title Search
De Lage Landen Financial Services, Inc.
Copier Lease Payment
ICMA Retirement Trust - 457
ICMA 457 (flat percent)
Illinois Department of Revenue
IL State Withholding
IMRF
IMRF
Internal Revenue Service
Federal Withholding
T.P.I.
CDBG- SFR Building Inspection
Village of Mount Prospect
Flex - Medical
042 Community Development Block Grant Total
050 Water and Sewer Fund
Addison Building Material Co.
Maintenance and repair supplies
Maintenance and repair supplies
Aramark Uniform Services, Inc.
Uniform Cleaning and Rental
Uniform Cleaning and Rental
AT & T
Service 2/16/15 - 3/15/15
Badger Meter Inc
AMR/AMI System
AMR/AMI System
AMR/AMI System
AMR/AMI System
Baxter & Woodman, Inc.
Professional Services
SCADA Wireless
Professional Services
Burns & Mcdonnell Engineering Co.
Professional Services
Professional Services
Emergency Generators
Century Cleaners
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Commonwealth Edison
Emergency Generators
Dariusz Walczak
Utility Refund - 1411 Hickory Dr
David J. Dollevoet
Utility Refund - 403 E Lincoln St
Garvey's Office Products
Office Supplies
Office Supplies
HBK Water Meter Service
Water Meter Installations
ICMA Retirement Trust - 457
ICMA 457 (flat percent)
Illinois Department of Revenue
IL State Withholding
IMRF
IMRF
Internal Revenue Service
Federal Withholding
International Union of Operating Engineers
IUOE PW Membership Dues
James Drive LLC
Utility Refund - 1660 James Dr
KorTerra, Inc.
Professional Services
Kramer Datapower, Inc.
Maintenance and repair supplies
Leonid Vingart
Utility Refund - 212 Coventry PI
Martam Construction
Contractual Hauling
Michael Wagner & Sons, Inc.
Water Meter Repair Parts
Mount Prospect Paint, Inc.
Maintenance and repair supplies
Maintenance and repair supplies
Nationwide Mutual Insurance Company
Nationwide 457 (flat percent)
Page 5 of 9
Amount
126.65
174.36
101.15
74.36
35.00
3,662.44
2,617.44
$ 10,072.88
75.00
94.80
375.05
41.65
533.85
382.15
80.00
31.26
1,613.76
43.66
22.37
100.17
100.17
255.06
336.60
4,127.28
10,169.92
30,370.00
15,925.00
494.50
372.80
1,762.20
368.00
22.00
16.40
20.95
22.75
7.75
27.30
12.30
1,000.00
23.90
227.73
129.90
182.46
1,536.00
1,263.09
2,865.28
31,188.98
25, 211.63
932.91
7.34
4,900,00
768.00
3,198.97
2,720.96
186.95
149.90
137.98
420.90
Fund Vendor Name
NCPERS Group Life Ins.
Newark In One
NICOR
Norbert Mika
Northwest Suburban United Way
Prosafety,lnc.
Suburban Laboratories, Inc.
Thermastor LLC
Tower Works, Inc.
UPS Store #707
Verizon Wireless Services LLC
Village of Mount Prospect
W. Presperin
Warehouse Direct
Weldstar Company
Winter Equipment Company Inc
ZBATTERY.COM INC
Ziebell Water Service Products
050 Water and Sewer Fund Total
051 Village Parking System Fund
Crystal Maintenance Services Corp.
Elite Remodeling Group, Inc.
ICMA Retirement Trust - 457
Illinois Department of Revenue
IMRF
Internal Revenue Service
International Union of Operating Engineers
Nationwide Mutual Insurance Company
NCPERS Group Life Ins.
Petty Cash
Village of Mount Prospect
051 Village Parking System Fund Total
052 Parking System Revenue Fund
Constellation NewEnergy, Inc.
Crystal Maintenance Services Corp.
Elite Remodeling Group, Inc.
ICMA Retirement Trust - 457
Illinois Department of Revenue
IMRF
Internal Revenue Service
International Union of Operating Engineers
Nationwide Mutual Insurance Company
NCPERS Group Life Ins.
NICOR
Village of Mount Prospect
052 Parking System Revenue Fund Total
060 Vehicle Maintenance Fund
American Messaging
Arlington Heights Ford
Arlington Power Equipment
VILLAGE OF MOUNT PROSPECT
List of Bills
February 26 - March 11, 2015
Invoice l
IMRF Life Insurance
Maintenance and repair supplies
Natural Gas Consumption
Natural Gas Consumption
Natural Gas Consumption
Utility Refund - 518 N Wille St
United Way
Maintenance and repair supplies
Water Sample Testing
Maintenance and repair supplies
Professional Services
Shipping Charges
Cellular Service & Equipment Charges Jan/Feb 2015
Flex - Medical
Utility Refund - 313 We Go Tri
Office Supplies
Water Treatment Chemicals
Snow Plow Blades
Maintenance and repair supplies
Maintenance and repair supplies
Custodial Services
Garnishment
ICMA 457 (flat percent)
IL State Withholding
IMRF
Federal Withholding
IUOE PW Membership Dues
Nationwide 457 (flat percent)
IMRF Life Insurance
Petty Cash February 2015
Flex - Medical
Electrical Service Delivery
Electrical Service Delivery
Custodial Services
Garnishment
ICMA 457 (flat percent)
IL State Withholding
IMRF
Federal Withholding
IUOE PW Membership Dues
Nationwide 457 (flat percent)
IMRF Life Insurance
Natural Gas
Flex- Medical
Pager Rental -03/01-03/31
P-7 Power steering hose
P-7 Intake manifold
P-7 Intake gasket
P-40 Intake manifold and gaskets
P-40 Throttle position sensor
A/C Relays
Maintenance and repair supplies
Maintenance and repair supplies
Page 6 of 9
Amount
52.80
263.37
192.68
263.47
111.83
24.76
21.00
30.60
5,433.50
2,391.00
1,200.00
20.96
469.24
696.27
31.57
144.64
124.80
1,975.83
1,562.20
1,766.90
$ 154,893.21
$ 330.23
78.19
9.00
36.71
479.70
292.71
15.22
9.95
4.40
40.00
34.64
$ 1,330.75
$ 99.31
232.48
252.53
64.02
6.02
26.81
348.53
213.16
10.16
6.65
3.60
356.07
27.44
$ 1,646.78
$ 73.97
114.70
286.56
54.35
351.02
77.50
34.78
5.48
0.76
VILLAGE OF MOUNT PROSPECT
List of Bills
February 26 - March 11, 2015
Fund Vendor Name
Invoice Description
Amount
AT & T
Service 2/16/15 - 3/15/15
9.55
Busse Car Wash, Inc.
See note
640.00
Chicago Parts & Sound Llc
Equipment Maintenance
175.00
061 Vehicle Replacement Fund Total
Police SUV rear brake rotors and pads
399.80
1,836.13
Belts
62.08
P-6 A/C compressor, tube and accumulator
488.12
HP U P3015dn Printer
Equipment Maintenance
275.00
EJ Equipment
Maintenance and repair supplies
60.60
Enginemasters, Inc.
Vehicle Maintenance Supplies
140.98
General Parts Inc.
Engine Oil
63.96
610A Axle seal & Bearing
52.60
Cabin Filters
19.02
Global Emergency Products
Maintenance and repair supplies
619.42
Vehicle Maintenance Supplies
627.07
ICMA Retirement Trust - 457
ICMA 457 (flat percent)
840.21
Illinois Department of Revenue
IL State Withholding
1,148.46
IMRF
IMRF
14,933.24
Inland Power Group Inc.
Air filters
120.04
Transmission Bolts
84.96
Equipment Maintenance
802.26
Internal Revenue Service
Federal Withholding
9,486.10
International Union of Operating Engineers
IUOE PW Membership Dues
474.38
Kelley Williamson Co.
Vehicle Maintenance Supplies
5,704.50
Leach Enterprises, Inc.
Vehicle Maintenance Supplies
418.75
McAllister Equipment Co
Vehicle Maintenance Supplies
27.70
Mcmaster-carr Supply Co.
Drum pumps, electrical tape
174.55
Plow bolts
396.19
Napa -Heights Automotive Supply
4508 Washer pump
20.68
NCPERS Group Life Ins.
IMRF Life Insurance
48.00
Northwest Suburban United Way
United Way
4.00
Palatine Oil, Inc.
6,002 Gallons diesel fuel
13,652.21
8,002 Gallons UL fuel
18,585.53
Credit for wrong price per gallon of UL fuel
(18,585.53)
Vehicle Fuel
16,037.69
Precision Service & Parts
507 Fuel pump
317.62
S-26 door lock actuator
35.84
2707 Front wheel bearing
245.06
Police CV thermostat and gaskets
24.58
Ronco Industrial Supply
Vehicle Maintenance Supplies
201.50
Rush Truck Centers of Illinois, Inc.
4510 Hood bumper
28.32
Sid Tool Co., Inc.
Bolts, nuts, washers
412.73
Verizon Wireless Services LLC
Cellular Service & Equipment Charges Jan/Feb 2015
386.36
Village of Mount Prospect
Flex - Medical
350.02
West Side Tractor Sales
John Deere Loader filters and bulbs
281.32
2726 Valve seal kit
134.56
Wholesale Direct Inc.
Vehicle Maintenance Supplies
282.59
Wirfs Industries, Inc.
Equipment Maintenance
1,157.50
060 Vehicle Maintenance Fund Total
$ 72,864.24
061 Vehicle Replacement Fund
Air One Equipment, Inc.
Fire Vehicle
$
938.00
Fifth Third Bank
Credit Card
393.92
Rush Truck Centers of Illinois, Inc.
New Vehicles
504.21
061 Vehicle Replacement Fund Total
$
1,836.13
062 Computer Replacement Fund
CDW Government, Inc.
HP U P3015dn Printer
$
734.18
062 Computer Replacement Fund Total
$
734.18
Page 7 of 9
Page 8 of 9
VILLAGE OF MOUNT PROSPECT
List of Bills
February 26 - March 11, 2015
Fund Vendor Name
Invoice Description
Amount
063 Risk Management Fund
Arthur J. Gallagher Rms, Inc.
2015 Renewal Premium
$
204,505.00
Intergovernmental Per.ben.coop
IPBC - March 2015
496,291.84
Northwest Community Hospital
Acct # 78672978 - Keady - DOS 03/03/14
621.72
Wickery- DOS 12/10/12 & 12/20/12
125.21
State of Illinois
W/C Rate Assessment 7/1/14 -12/31/14
3,993.59
063 Risk Management Fund Total
$
705,537.36
070 Police Pension Fund
Internal Revenue Service
Federal Withholding
$
47,999.75
070 Police Pension Fund Total
$
47,999.75
071 Fire Pension Fund
Internal Revenue Service
Federal Withholding
$
43,438.88
071 Fire Pension Fund Total
$
43,438.88
073 Escrow Deposit Fund
A Better Plumber
Refund Escrow Permit # 15-0084 (1402 Cedar Ln)
$
75.00
Absolute Garage Builders
Refund Escrow Permit # 14-2221 (521 N Maple St0
150.00
Airoom Builders
Refund Escrow Permit # 14-1208 (615 S William St)
600.00
Bartosh, Constance
Refund Escrow Permit # 14-1984 (14 S Edward St)
125.00
BELT Construction LLC
Refund Escrow Permit # 14-2364 (801 W Milburn Ave)
200.00
Breitenstein, Laurie
Refund Escrow Permit # 15-0144
125.00
Brennen, Therese
Refund Escrow Permit # 11-0930
125.00
CB Home Improvement
Refund Escrow Permit # 13-0403 (1430 Chestnut Dr)
200.00
Cruitt, Joseph
Refund Escrow Permit # 15-0169
125.00
DLS Landscaping Inc
Refund Escrow Permit # 14-1026 (713 Dresser Dr)
125.00
Ellsworth, Patrick H
Refund Escrow Permit # 15-0154 (1002 Butternut #A)
125.00
Ex -Stink Plumbing
Refund Escrow Permit # 15-0149 (918 S Lancaster Ave)
125.00
Father & Son Home Improvement
Refund Escrow Permit # 13-1062 (113 S Elmhurst Ave)
50.00
Four Seasons Heating and A/C
Refund Escrow Permit # 14-0501 (1160 Wheeling Rd)
125.00
Refund Escrow Permit # 14-1260 (501 N Maple St)
25.00
Refund Escrow Permit # 15-0116 (1907 W Golf Rd #1A)
125.00
Geiser Berner Plumbing
Refund Escrow Permit # 14-1137 (801 W Isabella St)
125.00
Govender, Kumerasen
Refund Payment (Wrong PO Box) 2/23/15
23.71
Haider, Garret
Refund Escrow Permit # 13-1930
100.00
Ibbotson Heating Company
Refund Escrow Permit # 14-1233 (206 S Pine St)
25.00
Refund Escrow Permit # 15-0118 (608 S School St)
75.00
IH2 Property LLC
Refund Escrow Permit # 14-0874 (804 Cedar Ln)
300.00
Refund Escrow Permit # 14-1452 (206 Deneen Ln)
350.00
Inter -Continental Trading USA Inc
Refund Overpayment Business License Fee
18.75
J Home Construction Services Inc
Refund Escrow Permit # 14-1589 (620 5 Edward St)
50.00
JRC Design Build
Refund Escrow Permit # 13-0319 (312 N Wille St)
400.00
KIMCO
Refund Escrow Permit # 14-1931 (1500 S Elmhurst Rd)
125.00
Klairmont Investments LLC
Refund Escrow Permit # 14-1972 (1699 Wall St)
125.00
Kragt, Joleen
Refund Escrow Permit # 15-0121
125.00
Kuohung, Ching Hu
Refund Escrow Permit # 15-0092 (250 W Kensington Rd)
125.00
Michels, Brian
Refund Escrow Permit # 14-1226
400.00
Morales, Victor
Refund Escrow Permit # 14-2486
75.00
Naegele, Jason & Anastasia
Refund Escrow Permit # 13-0927
125.00
Nardi, Frank J
Refund Escrow Permit # 15-0161
125.00
Nevins, Rosemary
Refund Escrow Permit # 15-0127
125.00
Norb & Sons Electric
Refund Escrow Permit # 14-2465 (518 Fairview Ave)
75.00
North Shore Energy
Refund Escrow Permit # 15-0034 (1114 Linden Ln)
75.00
Opland, Mark
Replacement Refund Check #790118 - 10/29/14
200.00
Perma Seal Basement Systems
Refund Escrow Permit # 15-0076 (405 Na Wa Ta Ave)
125.00
Peterson Roofing Inc
Refund Escrow Permit # 13-1172 (1450 Feehanville Dr)
125.00
Pinter, William
Refund Escrow Permit # 15-0156
125.00
Raucci, Frank
Refund Escrow Permit # 15-0155
125.00
Rozowicz, Marcin
Refund Escrow Permit # 15-0135 (918 Greenfield Ct)
125.00
Ryan, Douglas M
Refund Escrow Permit # 14-1414
300.00
Sewer Studio
Refund Escrow Permit # 14-1661
125.00
Page 8 of 9
Fund Vendor Name
Sign A Rama
Sneeden, Kirk
South Water Signs
Soyka, James
Suburban Sewer
Superior Corp of Illinois
Tafel, Eric
Third District Circuit Court
TJM Sewer and Drainage
Truline Sign Company
United Structural Systems
US Waterproofing Inc
073 Escrow Deposit Fund Total
Grand Total
VILLAGE OF MOUNT PROSPECT
List of Bills
February 26 - March 11, 2015
Invoice Description
Refund Escrow Permit # 14-2184 (990 Mt. Prospect Plz)
Refund Escrow Permit # 13-1167
Refund Escrow Permit # 14-1762 (15 E Prospect Ave)
Refund Escrow Permit # 15-0164
Refund Escrow Permit # 15-0141 (1629 Oneida Ln)
Refund Escrow Permit # 14-1464(3015 Lynn Ct # C)
Refund Escrow Permit # 11-0576
Bond Check 2/26/15
Bond Check 3/3/15
Bond Check 3/5/15
Bond Check 3/10/15
Refund Escrow Permit # 15-0133 (1106 Oakwood Dr)
Refund Escrow Permit # 15-0096 (1660 Wall St)
Refund Escrow Permit # 12-2116 (607 S School St)
Refund Escrow Permit # 14-0341(1913 Pawnee Ln)
Page 9 of 9
Amount
125.00
125.00
125.00
125.00
125.00
175.00
125.00
150.00
400.00
725.00
300.00
125.00
125.00
125.00
125.00
$ 9,642.46
$ 2,309,085.59