HomeMy WebLinkAbout4. Monthly Financial Report & Approve Bills 04/21/2015Ik Mount 0'rosp
Village of Mount Prospect
Mount Prospect, Illinois
INTEROFFICE MEMORANDUM
TO: VILLAGE PRESIDENT AND BOARD OF TRUSTEES
FINANCE COMMISSION
FROM: FINANCE DIRECTOR
DATE: APRIL 17, 2015
SUBJECT: MONTHLY FINANCIAL REPORT — MARCH 2015
Attached hereto are the cash position and investment statements of the Village for the month
ended March 31, 2015. These statements provide a snapshot of the Village's cash position as
of the month end date noted and are intended to supplement the budget revenue and
expenditure summary and listing of bills you receive. The first statement presents the Village's
cash position broken down by governmental and enterprise funds and trust and agency funds.
The second statement presents the Village's cash position by fund type. The third statement
presents the list of investments again broken down by governmental and enterprise funds and
trust and agency funds. It is important to note that although we have included the trust and
agency funds in the cash position report, these are not funds accessible for Village operations.
They are restricted for pension and escrow funding only. Please read the summary that follows
for further detail on the cash position of the Village.
Cash and Investment Position Resort —All Funds (page 11
This report provides a detailed summary of cash and investments for the Village broken out by
governmental and enterprise funds and trust and agency funds. Governmental funds include
the General Fund, Special Revenue Funds, Debt Service Funds, Capital Project Funds and
Internal Service Funds. The Enterprise Funds consist of the Water and Sewer Fund and two (2)
Parking Funds.
Trust funds include the Village's two public safety pensions (Police and Firefighters') while the
agency funds include the Escrow Deposit, Flexcomp Escrow, Special Service Area and Library
Bonds Escrow Funds. The Escrow Deposit Fund accounts for refundable deposits held by the
Village to ensure completion of public improvements. The Flexcomp Escrow Fund accounts for
employee payroll deductions pursuant to a Section 125 flexible compensation plan. The Special
Service Area Fund and Library Bonds Escrow Fund account for the accumulation of monies for
debt service payments.
Governmental and Enterprise Funds - Cash and cash equivalents at February 28 were $39.8
million. During March, cash receipts totaled $10,778,804. In addition investment income for the
month was $1,334. Reductions to cash and cash equivalents during March totaled $5,626,615.
Of this amount, payments to vendors were $4,215,894; employee payroll related expenses were
$1,369,536 and other disbursements totaling $41,185. There was also a net increase in cash
due to interfund activity of $67,595. Cash and cash equivalents at March 31 increased to $45.0
million.
Monthly Financial Report — March 2015
April 17, 2015
Page 2
Investments in the Governmental and Enterprise Funds at February 28 were $6.1 million. There
was no investment activity during the month of March.
Total cash and investments for Governmental and Enterprise Funds at February 28 were
$45,911,009. Cash and investments at March 31 totaled $51,132,127. This is an increase of
$5,221,118. The larger than typical increase was due receipt of a portion of the 1St installment
2014 property tax.
Trust and Agency Funds - Cash and cash equivalents at February 28 were $3.7 million.
During March, cash receipts totaled $1,983,098. In addition investment income for the month
was $128,607. There was a net decrease in cash due to investment activities of $270,253, and
a net decrease in cash due to interfund activity of $67,595. Reductions to cash and cash
equivalents during March totaled $766,214. Of this amount, payments to vendors were
(ZIW 099 emnln%inn na%irn11 unrl mIntnrrll evr�oneec .niers GRnQ Aqq nnrr navmnntc ralateri to fha
flexible spending program totaled $31,805. There were also other adjustments totaling $384.
Cash and cash equivalents at March 31 were $4.7 million.
Total investments at March 31 were $115,437,021, an increase of $1,520,426 from February
28. There were investment income of $1,250,173 and a net transfer -in totaling $270,253 that
accounted for the change.
Total cash and investments for Trust and Agency Funds at February 28 were $117,592,155.
Cash and investments at March 31 totaled $120,120,607. This is an increase of $2,528,452
from the prior month.
Summary of Cash Activity by Fund Type (page 2)
Phis report provides a breakdown of the cash activity for the month broken down by fund type.
This breakdown is useful in identifying where the activity (receipts and disbursements) is
occurring. There are times during the year when activity in certain funds such as the capital
improvement and special revenue funds is higher than normal. This will distort the financial
picture of some of the other components of the governmental funds such as the General Fund
which tends to be more level and predictable in terms of spending and receipt of revenue. Each
month the report will provide further explanation on the activity of the General Fund, the
Village's primary operating fund. The report will also provide additional information on fund
types that experienced higher than normal activity for the month. Activity for the General Fund
is highlighted below.
General Fund — Cash and cash equivalents at February 28 totaled $8,172,247. During March,
cash receipts totaled $6,561,356 and investment income was $257. Significant cash receipts
include property taxes, sales and income taxes.
Receipts of Property taxes related to the 2014 levy continued coming in during March. A
total of $4,758,581 was received in the General Fund during the month. Approximately 49%
of the total budget for property taxes has been received during February and March.
State income tax receipts for March totaled $441,247 representing the January installment.
The "new normal" lag in receiving the income tax distribution from the state is two months.
H:\ACCT\Treasurer's Report\2015\Monthly Cash Position Report - March 2015.docx
Monthly Financial Report — March 2015
April 17, 2015
Page 3
Sales tax revenues for the month totaled $1,440,271. Of this amount, $1,306,533 was
generated from the 1% state portion while $133,738 was generated from the .25% home
rule portion. Sales taxes received in March are for December sales. There is a normal
three-month lag in getting this distribution from the state.
Disbursements from the General Fund for March included payments to vendors of $1,294,518,
payments for employee wages and benefits of $1,196,892 and other disbursements of $41,451.
There was also an interfund transfer of $1,074,563 for health premiums and vehicle lease and
maintenance payments were made during the month
Cash and cash equivalents at March 31 were $11,126,435. There were no investments in the
General Fund at March 31.
Statement of Investments (page 3)
This report provides a breakdown of investments by trust and agency funds and governmental
and enterprise funds. The report also provides a fund -by -fund breakdown of the investments.
Trust and Agency Funds — The investments for the trust and agency funds are made up of
certificates of deposits, fixed income investments and equity mutual funds. CD's (if any) held in
the Escrow Deposit Fund will generally have maturities of between 30 and 120 days. Most of
the reserves for this fund are invested in the more liquid money market account due to the
nature of the deposit. Escrow refunds are processed two times per month.
Investments for the Police and Firefighter Pension Funds consist of various fixed income
securities as well as equity mutual fund accounts. Wells Fargo is the third -party holder of the
fixed income securities. The funds are managed by three investment management firms,
Galliard, Segall Bryant and Mesirow Financial. Segall Bryant holds approximately half of the
fixed income investments for the two pension funds while Galliard and Mesirow manage the
balance of fixed income investments for these two funds. Each manager maintains a small
portion of their portfolio in cash to help facilitate liquidity and trading.
Investments in equities consist of mutual funds spread across various sectors (small, mid and
large -cap stocks) as well as investment philosophies (value, core and growth). The funds also
invest a small amount in international stocks. Each year the investment mix is evaluated for
optimal diversification to meet pension fund investment policy goals and objectives. Equity
investments held by the Police Pension Fund are managed by Sawyer Falduto Asset
Management. Below is a breakdown of how the pension fund portfolios are invested.
Maturity Purchase Financial
Date Date Institution
POLICE PENSION FUND (070}
Various Various Wells Fargo
Various Various Various
FIRE PENSION FUND (0711
Various Various Wells Fargo
Various Various Various
TOTAL TRUST AND AGENCY FUND INVESTMENTS
Investment
CUSIP/
Interest
Market
Description
Acct #
Rate %
Value
Wells Fargo Investments
Various
Various
$ 23,622,961.10
Mutual Fund Investments
Various
Various
35,165,316.92
58,788,278.02
Wells Fargo Investments Various Various 20,379,526.36
Mutual Fund Investments Various Various 36,269,216.59
56,648,742.95
$ 115,437,020.97
H:\ACCT\Treasurer's Repo rt\2015\Monthly Cash Position Report - March 2015.docx
Monthly Financial Report — March 2015
April 17, 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 March 31 there was a total of $6.1 million
invested in CD's. These CD's are investing proceeds of the 2013 flood control bond issue.
Other surplus funds in the governmental and enterprise funds have been placed in interest
bearing money market accounts.
Maturity
Purchase
Financial
Investment
CUSIP/
Date
Date
Institution
Description
FDIC #
Net Yield
Porch Price
FLOOD CONTI2®L C'(7l ajRUC jjq F'UNR 6024}
06/15/15
01/05/15
Landmark Community Bank, TN
Certificate of Deposit
34982
0.123%
249,800.00
06/15/15
01/05/15
Farmers St Bank Waterloo, IA
Certificate of Deposit
12855
0.123%
249,800.00
06/13/13
01/03/r3
Currier SLUM BUilk, MO
C Cuneate 0I`DVPUSu
7358
0.120%
249,VVV.VV
06/15/15
01/05/15
Texas Capital Bank, TX
Certificate of Deposit
34383
0.120%
249,800.00
06/15/15
01/05/15
The First, NA, MB
Certificate of Deposit
4256
0.124%
249,800.00
06/15/15
01/05/15
Banco Popular North America, IL
Certificate of Deposit
34967
0.120%
82,800.00
06/15/15
01/05/15
Banco Popular North America, IL
Certificate of Deposit
34967
0.120%
84,000.00
06/15/15
01/05/15
Banco Popular North America, IL
Certificate of Deposit
34967
0.120%
83,000.00
06/15/15
01/05/15
West Alliance/Torrey Pines, CA
Certificate of Deposit
57512
0.120%
249,800.00
07/08/15
01/09/15
0.3% - Bank of India CD
Certificate of Deposit
06278CJ89
0.253%
249,05730
07/13/15
01/13/15
0.4% -Bank ofBarodaCD
CertificateofDeposit
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 "[lust Co, OK
Certificate of Deposit
35348
0.209%
249,400.00
08/17/15
01/05/15
Bank Leumi USA, NY
Certificate of Deposit
19842
0.200%
249,400.00
08/17/15
01/05/15
Orrstown Bank, PA
Certificate of Deposit
713
0.200%
249,400.00
08/17/15
01/05/15
Private Bank - MI, MI
Certificate of Deposit
224
0.206%
249,400.00
09/15/15
01/05/15
Bank of the Ozarks, AIL
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
01/05/15
United Texas Bank, TX
Certificate of Deposit
26626
0343%
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,60336
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:\ACCT\Treasurer's Report\2015\Monthly Cash Position Report - March 2015.docx
VILLAGE OF MOUNT PROSPECT
Preliminary Cash and Investment Position Report - All Funds
For the Month Ended March 31, 2015
GOVERNMENTAL AND ENTERPRISE FUNDS
TRUST AND AGENCY FUNDS *
Cash and Cash Total Cash and
Equivalents Investments Investments
Balance at February 28, 2015 $ 3,675,559.66 $ 113,916,595.15 $ 117,592,154.81
Cash receipts
Cash and Cash
Total Cash and
128,606.54 1,250,172.91
Equivalents Investments
Investments
Balance at February 28, 2015
$ 39,773,405.45 $ 6,137,603.36
$ 45,911,008.81
Cash receipts
10,778,804.15
10,778,804.15
Investment income
1,334.05 -
1,334.05
Transfers from investments to cash
-
Transfers to investments from cash
Interfund activity
67,595.46
67,595.46
Disbursements:
Accounts payable
(4,215,893.77)
(4,215,893.77)
Payroll
(1,369,535.99)
(1,369,535.99)
Other
41,185.33)
(41,185.33)
Balance at March 31, 2015
$ 44,994,524.02 $ 6,137,603.36
$ 51,132,127.38
TRUST AND AGENCY FUNDS *
Cash and Cash Total Cash and
Equivalents Investments Investments
Balance at February 28, 2015 $ 3,675,559.66 $ 113,916,595.15 $ 117,592,154.81
Cash receipts
1,983,098.25
Investment income (loss)
128,606.54 1,250,172.91
Transfers from investments to cash
1,684,270.91 (1,684,270.91)
Transfers to investments from cash
(1,954,523.82) 1,954,523.82
Interfund activity
(67,595.46)
Disbursements:
Accounts payable
Payroll
Flex spending
Other
Balance at March 31, 2015
(124,925.81)
(609,483.31)
(31,804.58)
384.03
1, 983, 098.25
1, 378, 779.45
(67,595.46)
(124,925.81)
(609,483.31)
(31,804.58)
384.03
$ 4,683,586.41 $ 115,437,020.97 $ 120,120,607.38
* Assets are restricted in purpose and do not represent discretionary assets of the government.
1
z
CASH & CASH EQUIVALENTS
Beginning balance
Cash receipts
Investment income
Transfers from investments
Transfers to investments
Interfund
Disbursements - other
Disbursements - flexible spending
Disbursements - payroll
Disbursements - accounts payable
Ending balance
VILLAGE OF MOUNT PROSPECT
Summary of Cash Activity by Fund Type
For the Month Ended March 31, 2015
GOVERNMENTAL AND ENTERPR,S• FUNDS TRUST AND AGENCY FUNDS *—
INVESTMENTS
Certificates of deposit 6;137,60336 6,137,603-36
6,137,603-36
Wells Fargo investments - 44,002,437,46 44,002,48746
Mutual fund investments - 71.434,533,51 71,434,533-51
Total investments 6,13760336 6,137,603.36 115,437,020.97
121,574,624-33
TOTAL CASH AND INVESTMENTS _$ 11,126,434.89 $ 4,236,488.11 $ 1,228,374.37 $ 18,633,191.52 $ 5,217,095.02 $ 10,690,543.47 $ 51,132,127.38 $118,995,207.10 $ 1,125,400.28 $171,252,734.76
* Assets are restricted in purpose and do not represent discretionary assets of the government.
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
$ 8,172,247.25
$ 4,194,457,43
$ 478,812-18
$ 11,408,758 89
$ 4,728,20057
$ 10790,929.13
$ 39,773,405.45
$ 2,527,396.54
$ 1,148,163.12
$ 43,448,965 11
6,561,355.63
433,546.65
749,81047
1,230,294,51
1,707,976.43
95,82046
10,778,804 15
1,918,849,06
64,249.19
12,761,902.40
25660
46.55
1.72
421.96
111,06
49616
1,334,05
128,51672
8982
129,94059
-
-
-
-
-
-
-
1,684,270.91
-
1,684,270.91
-
-
-
(1,954,523-82)
(1,954,523.82)
(1,074,563.05)
59,895-03
-
410,683.95
(179,221-77)
850,801.c0
67,59546
(39,303.27)
(28,292.19)
0.00
(41,451.03)
250,00
15.70
(41,185.33)
1,200.00
(815.97)
(40,80130)
-
-
-
(31,804.58)
(31,804,58)
(1,196,892.30)
(13,744.17)
-
(109,764,28)
(49,135,24)
(1,369,535699)
(609,483 31)
(1,979,019 30)
(1,294,518-21)
(437,713.38)
(50000)
i'554,571.15)
(930,222 69)
(998,368.24)
(4,215,893.77)
(98736-70)
(26,189.11)
(4,340,819.58)
11,126,434:89
4,236,488.11
1,228,374.37
12 495,588-16
5.21T095 02
10,690,543 47
44,994,524.02
3,558,186.13
1,125,400.28
49,678,110.43
INVESTMENTS
Certificates of deposit 6;137,60336 6,137,603-36
6,137,603-36
Wells Fargo investments - 44,002,437,46 44,002,48746
Mutual fund investments - 71.434,533,51 71,434,533-51
Total investments 6,13760336 6,137,603.36 115,437,020.97
121,574,624-33
TOTAL CASH AND INVESTMENTS _$ 11,126,434.89 $ 4,236,488.11 $ 1,228,374.37 $ 18,633,191.52 $ 5,217,095.02 $ 10,690,543.47 $ 51,132,127.38 $118,995,207.10 $ 1,125,400.28 $171,252,734.76
* Assets are restricted in purpose and do not represent discretionary assets of the government.
VILLAGE OF MOUNT PROSPECT
STATEMENT OF INVESTMENTS
As of March 31, 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, IA
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„
M
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, 13703.36
Market
Value
$ 23,622,961.10
35,165,316.92
�-
58,788,278.020
20,379,52636
36,269,216.59
56,648,742.95
$ 115,437,020.97
VILLAGE OF MOUNT PROSPECT
BUDGET REVENUE
EXPENDITURE SUMMARIES
March 01— March 31, 2015
Account Classification
rwiu uui - uenerai rune
REVENUE
Property Taxes
Other Taxes
Licenses, Permits & Fees
Intergovernmental Revenue
Charges For Services
Fines & Forfeits
Investment Income
Reimbursements
Other Revenue
Other Financing Sources
r
Revenue Budget by Account Classification
Report
Through 03/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
15,427,500.00
.00
15,427,500.00
4,758,581.14
.00
7,577,371.13
7,850,128.87
49
7,224,119.98
7,457,566.00
.00
7,457,566.00
203,117.29
.00
886,820.78
6,570,745.22
12
849,655.15
1,256,000.00
.00
1,256,000.00
360,272.49
.00
547,819.49
708,180.51
44
461,730.34
20,123,200.00
2,404.00
20,125,604.00
606,592.40
.00
757,582.73
19,368,021.27
4
790,285.85
1,633,223.00
.00
1,633,223.00
47,135.45
.00
322,196.23
1,311,026.77
20
284,833.04
439,000.00
.00
439,000.00
54,941.78
.00
105,566.66
333,433.34
24
69,708.59
5,918.00
.00
5,918.00
345.21
.00
2,265.74
3,652.26
38
1,418.28
220,000.00
.00
220,000.00
25,474.63
.00
47,814.93
172,185.07
22
51,284.92
236,000.00
.00
236,000.00
31,640.87
.00
92,688.31
143,311.69
39
91,000.91
20,000.00
.00
20,000.00
20,000.00
.00
20,000.00
.00
100
.00
REVENUE TOTALS $46,818,407.00
$2,404.00
$46,820,811.00
$6,108,101.26
$0.00
$10,360,126.00
$36,460,685.00
22%
$9,824,037.06
Fund 001- General Fund Totals $46,818,407.00
$2,404.00
$46,820,81100
$6,108,101.26
$0.00
$10,360,126.00
$36,460,685.00
$9,824,037.06
N
Account Classification
Fund 002 - Debt Service Fund
REVENUE
Property Taxes
Other Taxes
Intergovernmental Revenue
Investment Income
Other Revenue
Other Financing Sources
REVENUE TOTALS
Fund 002 - Debt Service Fund Totals
Revenue Budget by Account Classification
Report
Through 03/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
2,254,000.00
,00
2,254,000.00
749,810.47
.00
1,099,392.09
1,154,607.91
49
1,120,588.63
988,508.00
.00
988,508.00
.00
.00
.00
988,508.00
0
.00
42,773.00
1,568,856,00
1,611,629.00
250.00
.00
250.00
1,611,379.00
0
.00
100.00
.00
100.00
1.72
.00
2.65
97.35
3
5.63
.00
.00
.00
.00
.00
.00
.00
...
.00
.00
.00
.00
.00
.00
.00
.00
...
3,231.19
$3,285,381.00
$1,568,856.00
$4,854,237.00
$750,062.19
$0.00
$1,099,644.74
$3,754,592.26
23%
$1,123,825.45
$3,285,381.00
$1,568,856.00
$4,854,237.00
$750,062.19
$0.00
$1,099,644.74
$3,754,592.26
$1,123,825.45
Account Classification
Fund 020 - Capital Improvement Fund
REVENUE
Other Taxes
Intergovernmental Revenue
Investment Income
Reimbursements
Other Revenue
Other Financing Sources
W
Revenue Budget by Account Classification
Report
Through 03/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
1,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
18.79
.00
76.16
923.84
8
155.88
.00
.00
,00
.00
.00
.00
.00
+++
.00
20,000.00
.00
20,000.00
.00
.00
.00
20,000.00
0
65,496.00
.00
.00
00
.00
.00
.00
.00
+++
.00
REVENUE TOTALS $1,267,000.00 $0.00 $1,267,000.00 $18.79 $0.00 $76.16 $1,266,923.84 0%
$65,651.88
Fund 020 - Capital Improvement Fund Totals $1,267,000.00 $0.00 $1,267,000.00 $18.79
$0.00 $76.16 $1,266,923.84 $65,651.88
Revenue Budget by Account Classification
Report
Through 03/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD
% used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions
Rec'd
Prior Year YTD
Fund 022 - Downtown Redevelopment Construct
REVENUE
Property Taxes
2,709,000.00
.00
2,709,000.00
1,106,755.72
.00
1,215,186.31
1,493,813.69
45
1,235,405.59
Investment Income
500.00
,00
500.00
6.64
.00
12.28
487.72
2
88.82
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
$1,106,762.36
$0.00
$1,215,198.59
$1,494,301.41
45%
$1,235,494.41
Fund 022 - Downtown Redevelopment Construct Totals
$2,709,500.00
$0.00
$2,709,500.00
$1,106,762.36
$0.00
$1,215,198.59
$1,494,301.41
$1,235,494.41
Revenue Budget by Account Classification
Report
Through 03/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD
% used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions
Rec'd
Prior Year YTD
Fund 023 - Street Improvement Construc Fund
-
-
REVENUE
Other Taxes
2,056,000,00
.00
2,056,000.00
53,258.08
.00
128,631.12
1,927,368.88
6
120,923.45
Licenses, Permits & Fees
1,540,000.00
.00
1,540,000.00
218,544.75
.00
473,037.75
1,066,962.25
31
420,331.50
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
136.70
.00
362.99
(262.99)
363
1,268.61
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,700.82
REVENUE TOTALS
$3,602,100.00
$0.00
$3,602,100.00
$271,939.53
$0.00
$602,031.86
$3,000,068.14
17%
$7,083,224.38
Fund 023 - Street Improvement Construc Fund Totals
$3,602,100.00
$0.00
$3,602,100.00
$271,939.53
$0.00
$602,031.86
$3,000,068.14
$7,083,224.38
rn
Revenue Budget by Account Classification
Report
Through 03/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions
Rec'd
Prior Year YTD
Fund 024 - Flood Control Construction Fund
REVENUE
Other Taxes
357,000.00
.00
357,000.00
.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,339.56
.00
3,744.06
(2,644.06)
340
3,092.73
Reimbursements
.00
.00
.00
.00
.00
.00
.00
+++
.00
Other Financing Sources
.00
.00
.00
.00
.00
.00
.00
+++
.00
REVENUE TOTALS
$358,100.00
$0.00
$358,100.00
$1,339.56
$0.00
$3,744.06
$354,355.94
1%
$3,092.73
Fund 024 - Flood Control Construction Fund Totals
$358,100.00
$0.00
$358,100.00
$1,339.56
$0.00
$3,744.06
$354,355.94
$3,092.73
Account Classification
Fund 040 - Refuse Disposal Fund
REVENUE
Revenue Budget by Account Classification
Adopted Budget Amended Current Month YTD
Budget Amendments Budget Transactions Encumbrances
Report
Through 03/31/15
Prior Fiscal Year Activity Included
Summary Listing
YTD Budget - YTD % used/
Transactions Transactions Rec'd Prior Year YTD
Property Taxes
.00
.00
.00
.00
.00
.00
.00
+++
174,732.42
Charges For Services
3,549,000.00
.00
3,549,000.00
405,529.79
.00
880,485.48
2,668,514.52
25
725,690.18
Fines & Forfeits
24,000.00
.00
24,000.00
2,309.79
.00
8,452.09
15,547.91
35
6,219.13
Investment Income
500.00
.00
500.00
13.84
.00
50.72
449.28
10
201.98
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
18,120.54
.00
32,667.96
338,832.04
9
29,255.07
REVENUE TOTALS
$3,946,000.00
$0.00
$3,946,000.00
$425,973.96
$0.00
$921,656.25
$3,024,343.75
23%
$936,098.78
Fund 040 - Refuse Disposal Fund Totals
$3,946,000.00
$0.00
$3,946,000.00
$425,973.96
$0.00
$921,656.25
$3,024,343.75
$936,098.78
1W
0
Account Classification
Fund 041 - Motor Fuel Tax Fund
REVENUE
'T'evenue Budget • Account Classification
Repo
Through 03/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Intergovernmental Revenue 1,320,000.00
.00
1,320,000.00
97,311.50
.00
225,506.44
1,094,493.56
17 229,446.54
Investment Income 200.00
.00
200.00
10.24
.00
45.66
154.34
23 4.57
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
$97,321.74
$0.00
$225,552.10
$1,105,647.90
17% $229,451.11
Fund 041 - Motor Fuel Tax Fund Totals $1,331,200.00
$0.00
$1,331,200.00
$97,321.74
$0.00
$225,552.10
$1,105,647.90
$229,451.11
I
Revenue Budget by Account Classification
Adopted Budget
Account Classification Budget Amendments
Fund 042 - Cmmty Development Block Grant
REVENUE
Report
Through 03/31/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
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
.00
.00
24,605.00
55,395.00 31
42,285.52
REVENUE TOTALS $419,264.00
$0.00
$419,264.00
$0.00
$0.00
$24,605.00
$394,659.00 6%
$42,285.52
Fund 042 - Cmmty Development Block Grant Totals $419,264.00
$0.00
$419,264.00
$0.00
$0.00
$24,605.00
$394,659.00
$42,285.52
110
r
0
Account Classification
Fund 043 - Asset Seizure Fund
REVENUE
Revenue Budget by Account Classification
Report
Through 03/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
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.68
.00
3.73
96.27 4
5.12
REVENUE TOTALS $2,100.00
$0.00
$2,100.00
$1.68
$0.00
$3.73
$2,096.27 0%
$5.12
Fund 043 - Asset Seizure Fund Totals $2,100.00
$0.00
$2,100.00
$1.68
$0.00
$3.73
$2,096.27
$5.12
Revenue Budget by Account Classification
Adopted Budget Amended Current Month YTD
Account Classification Budget Amendments Budget Transactions Encumbrances
Fund 044 - Federal Equitable Share Funds
REVENUE
Report
Through 03/31/15
Prior Fiscal Year Activity Included
Summary Listing
YTD Budget - YTD % used/
Transactions Transactions Rec'd 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
.84
.00
3.04
96.96
3 4.17
REVENUE TOTALS $200.00
$0.00
$200.00
$0.84
$0.00
$3.04
$196.96
2% $24,641.97
Fund 044 - Federal Equitable Share Funds Totals $200.00
$0.00
$200.00
$0.84
$0.00
$3.04
$196.96
$24,641.97
r
r
Account Classification
Fund 045 - DUI Fine Fund
REVENUE
Fines & Forfeits
Investment Income
Revenue Budget by Account Classification
Report
Through 03/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
20,000.00
.00
20,000.00
5,715.39
.00
5,715.39
14,284.61 29
.00
100.00
.00
100.00
4.40
.00
8.76
91.24 9
13.50
REVENUE TOTALS $20,100.00
$0.00
$20,100.00
$5,719.79
$0.00
$5,724.15
$14,375.85 28%
$13.50
Fund 045 - DUI Fine Fund Totals $20,100.00
$0.00
$20,100.00
$5,719.79
$0.00
$5,724.15
$14,375.85
$13.50
Revenue Budget by Account Classification
Adopted Budget
Account Classification Budget Amendments
Fund 046 -Foreign Fare Tax mrd Fund
REVENUE
Report
Through 03/31/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 Taxes
70,000.00
.00
70,000.00
.00
.00
.00
70,000.00
0
.00
Investment Income
100.00
.00
100.00
8.92
.00
17.69
82.31
18
35.47
Other Revenue
.00
.00
.00
.00
.00
.00
.00
+++
.00
Other Financing Sources
.00
.00
.00
.00
.00
.00
.00
+++
,00
REVENUE TOTALS
$70,100.00
$0.00
$70,100.00
$8.92
$0.00
$17.69
$70,082.31
0%
$35.47
Fund 046 - Foreign Fire Tax Board Fund Totals
$70,100.00
$0.00
$70,100.00
$8.92
$0.00
$17.69
$70,082.31
$35.47
r
w
Account Classification
Fund 048 - Business District Fund
REVENUE
Revenue Budget by Account Classification
Report
Through 03/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Other Taxes 1,021,000.00
.00
1,021,000.00
77,890.85
.00
115,840.11
905,159.89 11
93,948.64
Investment Income .00
.00
.00
6.63
.00
12.39
(12.39) +++
6.91
Other Financing Sources .00
,00
.00
.00
.00
,00
.00 +++
-00
REVENUE TOTALS $1,021,000.00
$0.00
$1,021,000.60
$77,897.48
$0.00
$115,852.50
$905,147.50 11%
$93,955.55
Fund 048 - Business District Fund Totals $1,021,000.00
$0.00
$1,021,000.00
$77,897.48
$0.00
$115,852.50
$905,147.50
$93,955.55
Account Classification
Fund 050 Water and Sewer Fund
REVENUE
Property Taxes
Licenses, Permits & Fees
Charges For Services
Fines & Forfeits
Investment Income
Reimbursements
Other Revenue
Other Financing Sources
REVENUE TOTALS
Fund 050 - Water and Sewer Fund Totals
r
U1
Revenue Budget by Account Classification
Adopted Budget Amended Current Month YTD
Budget Amendments Budget Transactions Encumbrances
Through 03/31/15
Prior Fiscal Year Activity Included
Summary Listing
YTD Budget - YTD % used/
Transactions Transactions Recd Prior Year YTD
1,530,000.00
.00
1,530,000:00
3,441.10
.00
3,441.10
1,526,558.90
0
791,173.78
18,000.00
.00
18,000.00
1,420.00
.00
4,930.00
13,070.00
27
3,780.00
13,789,000.00
.00
13,789,000.00
978,337.79
.00
2,936,662.76
10,852,337.24
21
2,820,837.68
118,000.00
.00
118,000.00
9,035.09
.00
32,794.88
85,205.12
28
26,938.97
2,100.00
.00
2,100.00
103.46
.00
407.25
1,692.75
19
497.75
500.00
.00
500.00
.00
.00
.00
500.00
0
.00
72,000.00
.00
72,000.00
6,465.70
.00
22,491.49
49,508.51
31
20,196.96
.00
.00
.00
.00
.00
.00
.00
+++
.00
$15,529,600.00
$0.00
$15,529,600.00
$998,803.14
$0.00
$3,000,727.48
$12,528,872.52
19%
$3,663,425.14
$15,529,600.00
$0.00
$15,529,600.00
$998,803.14
$0.00
$3,000,727.48
$12,528,872.52
$3,663,425.14
F-
rn
Account Classification
Fund 051 - Village Parking System Fund
REVENUE
Revenue Budget by Account Classification
Report
Through 03/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Other Taxes
.00
.00
.00
.00
.00
.00
.00
...
.00
Charges For Services
124,000.00
.00
124,000.00
18,892.58
.00
38,665.44
85,334.56
31
42,434.91
Investment Income
100.00
.00
100.00
7.60
.00
14.94
85.06
15
28.30
Other Revenue
6,600.00
.00
6,600.00
1,100.00
.00
1,650.00
4,950.00
25
1,650.00
Other Financing Sources
.00
.00
.00
.00
.00
.00
.00
...
.00
REVENUE TOTALS
$130,700.00
$0.00
$130,700.00
$20,000.18
$0.00
$40,330.38
$90,369.62
31%
$44,113.21
Fund 051 - Village Parking System Fund Totals
$130,700.00
$0.00
$130,700.00
$20,000.18
$0.00
$40,330.38
$90,369.62
$44,113.21
Account Classification
Fund 052 - Parking System Revenue Fund
Revenue Budget by Account Classification
Report
Through 03/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
REVENUE
Other Taxes
100,000.00
.00
100,000.00
.00
.00
.00
100,000.00
0
.00
Intergovernmental Revenue
.00
.00
AO
.00
.00
.00
.00
+++
,00
Charges For Services
119,000.00
.00
119,000.00
9,603.75
.00
28,049.51
90,950.49
24
37,074.32
Investment Income
.00
.00
.00
.00
.00
.00
.00
+++
.00
Other Revenue
.00
.00
.00
.00
.00
.00
.00
...
.00
Other Financing Sources
.00
.00
.00
.00
.00
.00
.00
+++
.00
REVENUE TOTALS
$219,000.00
$0.00
$219,000.00
$9,603.75
$0.00
$28,049.51
$190,950.49
13%
$37,074.32
Fund G52 - Parking System Revenue Fund Totals
$219,000.00
$0.00
$219,000.00
$9,603.75
$0.00
$28,049.51
$190,950.49
$37,074.32
r
r
00
Account Classification
Revenue Budget by Account Classification
Report
Through 03/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Fund 060 - Vehicle Maintenance Fund
REVENUE
Charges For Services
2,157,889.00
'00
2,157,889.00
179,824.09
.00
539,472.27
1,618,416.73
25 534,579.21
Investment Income
600.00
,00
600.00
23.39
.00
75.25
524.75
13 146.97
Other Revenue
.00
.00
.00
.00
.00
200.00
(200.00)
+++ .00
REVENUE TOTALS
$2,158,489.00
$0.00
$2,158,489.00
$179,847.48
$0.00
$539,747.52
$1,618,741.48
25% $534,726.18
Fund 060 - Vehicle Maintenance Fund Totals
$2,158,489.00
$0.00
$2,158,489:00
$179,847.48
$0.00
$539,747.52
$1,618,741.48
$534,726.18
Account Classification
Fund 061 -Vehicle Replacement Fund
REVENUE
Revenue Budget by Account Classification
Report
Through 03/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Charges For Services
1,380,500.00
.00
1,380,500.00
115,041.68
.00
345,125.04
1,035,374.96
25
336,575.04
Fines & Forfeits
11,150.00
.00
11,150.00
1,000.00
.00
1,000.00
10,150.00
9
.00
Investment Income
7,200.00
.00
7,200.00
347.43
.00
934.92
6,265.08
13
1,885.65
Other Revenue
.00
.00
.00
.00
.00
.00
.00
+++
.00
Other Financing Sources
.00
.00
.00
4,183.60
.00
9,318.87
(9,318.87)
+++
.00
REVENUE TOTALS
$1,398,830.00
$0.00
$1,398,850.00
$120,572.71
$0.00
$356,378.83
$1,042,471.17
25%
$338,460.69
Fund 061- Vehicle Replacement Fund Totals
$1,398,850.00
$0.00
$1,398,850.00
$120,572.71
$0.00
$356,378.83$1,042,471.17
$338,460.69
r
1.0
N
O
Account Classification
Fund 062 - Computer Replacement Fund
REVENUE
Revenue Budget by Account Classification
Report
Through 03/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Charges For Services
272,307.00
.00
272,307.00
22,692.25
.00
68,076.75
204,230.25 25
5,772.00
Investment Income
1,000.00
.00
1,000.00
38.61
.00
106.62
893.38 11
189.30
Other Financing Sources
.00
.00
.00
.00
.00
.00
.00 +++
.00
REVENUE TOTALS
$273,307.00
$0.00
$273,307.00
$22,730.86
$0.00
$68,183.37
$205,123.63 25%
$5,961.30
Fund 062 - Computer Replacement Fund Totals
$273,307.00
$0.00
$273,307.00
$22,730.86
$0.00
$68,183.37
$205,123.63
$5,961.30
REVENUE TOTALS $7,981,526.00 $0.00 $7,981,526.00 $711,367.98 $0.00 $1,955,769.37 $6,025,756.63 25% $1,976,870.17
Fund 063 - Risk Management Fund Totals $7,981,526.00 $0.00 $7,981,526.00 $711,367.98 $0.00 $1,955,769.37 $6,025,756.63 $1,976,870.17
z
Revenue Budget
by Account
Classification
Report
Through 03/31/15
Prior Fiscal
Year Activity Included
Summary Listing
Adopted
Budget
Amended Current Month
YTD YTD
Budget - YTD % used/
Account Classification
Budget
Amendments
Budget Transactions
Encumbrances Transactions
Transactions Rec'd Prior Year YTD
Fund 063 - Risk Management Fund
REVENUE
Charges For Services
6,513,826.00
.00
6,513,826.00 615,853.11
.00 1,626,279.25
4,887,546.75 25 1,644,292.43
Investment Income
3,000.00
.00
3,000.00 86.73
.00 271.10
2,728.90 9 584.99
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 95,428.14
.00 329,219.02
1,134,480.98 22 331,992.75
REVENUE TOTALS $7,981,526.00 $0.00 $7,981,526.00 $711,367.98 $0.00 $1,955,769.37 $6,025,756.63 25% $1,976,870.17
Fund 063 - Risk Management Fund Totals $7,981,526.00 $0.00 $7,981,526.00 $711,367.98 $0.00 $1,955,769.37 $6,025,756.63 $1,976,870.17
z
N
N
Account Classification
Fund 070 - Police Pension Fund
REVENUE
Revenue Budget 'by Account Classification
Report
Through 03/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Charges For Services .00
.00
.00
.00
,00
.00
.00
+++ .00
Investment Income 4,382,800.00
.00
4,382,800.00
(99,073.63)
.00
1,382,176.06
3,000,623.94
32 755,452.09
Other Revenue 3,743,175.00
.00
3,743,175.00
1,046,547.68
.00
1,646,904.57
2,096,270.43
44 1,581,639.87
REVENUE TOTALS $8,125,975.00
$0.00
$8,125,975.00
$947,474.05
$0.00
$3,029,080.63
$5,096,894.37
37% $2,337,091.96
Fund 070 - Police Pension Fund Totals $8,125,975.00
$0.00
$8,125,975.00
$947,474.05
$0.00
$3,029,080.63
$5,096,894.37
$2,337,091.96
Account Classification
Fund 071 - Fire Pension Fund
REVENUE
Revenue Budget by Account Classification
Report
Through 03/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Investment Income 4,250,500.00
.00
4,250,500.00
1,489,871.47
.00
1,726,494.23
2,524,005.77
41 846,562.52
Other Revenue 3,151,125.00
.00
3,151,125.00
876,079.12
.00
1,383,190.97
1,767,934.03
44 1,400,870.34
REVENUE TOTALS $7,401,625.00
$0.00
$7,401,625.00
$2,365,950.59
$0.00
$3,109,685.20
$4,291,939.80
42% $2,247,432.86
Fund 071 - Fire Pension Fund Totals $7,401,625.00
$0.00
$7,401,625.00
$2,365,950.59
$0.00
$3,109,685.20
$4,291,939.80
$2,247,432.86
Grand Totals $108,069,524.00 $1,571,260.00 $109,64D,784.00 $14,221,498.84 $0.00 $26,702,188.16 $82,938,595.84 $31,846,968.76
N
W
Expense Budget by Account Classification
Adopted Budget
Account Classification Budget Amendments
Fund 001- General Fund
EXPENSE
Report
Through 03/31/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,751,900.02
.00
5,213,368.72
19,018,668.28
22
5,449,039.88
Employee Benefits
12,235,287.00
.00
12,235,287.00
2,459,563.60
.00
4,483,097.87
7,752,189.13
37
4,526,915.29
Other Employee Costs
440,543.00
(1,500.00)
439,043.00
30,150.68
6,966=20
98,178.17
333,898.63
24
73,781.34
Pension Benefits
46,456.00
.00
46,456.00
3,871.28
00
11,613.84
34,842.16
25
11,575.08
Contractual Services
7,528,869.00
14,228.00
7,543,097.00
595,886.29
665,836.56
1,755,247.47
5,122,012.97
32
1,657,621.50
Utilities
271,939.00
.00
271,939.00
11,583.77
.00
43,524.57
228,414.43
16
33,265.31
Insurance
415,398.00
.00
415,398.00
34,546.12
.00
103,705.86
311,692.14
25
87,656.25
Commodities & Supplies
641,996.00
7,688.00
649,684.00
34,960.69
57,886.64
100,171.75
491,625.61
24
117,649.87
Other Expenditures
11,140.00
.00
11,140.00
.00
.00
.00
11,140.00
0
.00
Building Improvements
10,200.00
.00
10,200.00
.00
.00
5,059.51
5,140.49
50
788.68
Office Equipment
33,520.00
17,400.00
501920.00
105.18
1,030.43
2,205.89
47,683.68
6
2,131.89
Other Equipment
184,199.00
.00
184,199.00
3,873.17
34,222.70
23,701.66
126,274.64
31
19,429.28
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
.00
124,295.75
2,034.25
540,493.00
19
25,731.40
Interfund Transfers
.00
.00
.00
.00
r .00
,00
.00
+++
.00
EXPENSE TOTALS
$46,818,407.00
$37,816.00
$46,856,223.00
$4,926,440.80
$971,429.28
$11,841,909.56
$34,042,884.16
27%
$12,005,585.77
Fund 001 - General Fund Totals
$46,818,407.00
$37,816.00
$46,856,223.00
$4,926,440.80
$971,429.28
$11,841,909.56
$34,042,884.16
$12,005,585.77
H
IM
Account Classification
Fund 002 - Debt Service Fund
EXPENSE
Expense Budget by Account classification
Report
Through 03/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Contractual Services
.00
.00
.00
.00
.00
.00
.00
...
.00
Other Expenditures
.00
.00
.00
.00
.00
.00
.00
+++
.00
Bond Principal
1,893,913.00
1,155,000.00
3,048,913.00
,00
.00
.00
3,048,913.00
0
.00
Interest Expense
1,382,571.00
413,356.00
1,795,927.00
.00
.00
.00
1,795,927.00
0
.00
Bank & Fiscal Fees
2,312.00
500.00
2,812.00
250.00
.00
3,037.14
(225.14)
108
1,258.20
Interfund Transfers
.00
.00
.00
.00
.00
.00
.00
+++
.00
Other Financing Uses
.00
.00
.00
.00
.00
.00
.00
+++
.00
EXPENSE TOTALS $3,278,796.00
$1,568,856.00
$4,847,652.00
$250.00
$0.00
$3,037.14
$4,844,614.86
0%
$1,258.20
Fund 002 - Debt Service Fund Totals $3,278,796.00
$1,568,856.00
$4,847,652.00
$250.00
$0.00
$3,037.14
$4,844,614.86
$1,258.20
Expense Budget by Account Classification
Adopted Budget
Account Classification Budget Amendments
Fund 020 - Capital Improvement Fund
EXPENSE
Report
Through 03/31/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
.00
.00
.00
.00
.00
.00
.00
...
.00
Other Expenditures
.00
.00
.00
.00
.00
.00
.00
+++
.00
Land Improvements
350,000.00
236,250.00
586,250.00
2,039.40
'00
2,039.40
584,210.60
0
,00
Building Improvements
896,000.00
502,440.00
1,398,440.00
48,287.48
403,101.36
77,137.64
918,201.00
34
22,816.60
Office Equipment
.00
.00
.00
.00
.00
.00
.00
+++
.00
Motor Equipment
.00
.00
.00
.00
.00
.AO
.00
+++
.00
Other Equipment
486,747.00
52,118.00
538,865.00
10,603.91
.00
65,308.40
473,556.60
12
35,730.81
Infrastructure
503,000.00
284,861.00
787,861.00
22,327.56
216,195.49
22,327.56
549,337.95
30
.00
Interfund Transfers
.00
.00
.00
.00
.00
.00
.00
+++
.00
EXPENSE TOTALS
$2,235,747.00
$1,075,669.00
$3,311,416.00
$83,258.35
$619,296.85
$166,813.00
$2,525,306.15
24%
$58,547.41
Fund 020 - Capital Improvement Fund Totals
$2,235,747.00
$1,075,669.00
$3,311,416.00
$83,258.35
$619,296.85
$166,813.00
$2,525,306.15
$58,547.41
w
.01
Expense Budget by Account Classification
Report
Through 03/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD
% used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions
Rec'd
Prior Year YTD
Fund 022 - Downtown Redevelopment Construct
EXPENSE
Contractual Services
109,201.00
.00
109,201.00
.00
57,043.51
.00
52,157.49
52
.00
Utilities
.00
.00
.00
.00
.00
.00
.00
+++
.00
Other Expenditures
3,306,969.00
.00
3,306,969.00
.00
.00
4,248.35
3,302,720.65
0
13,833.16
Infrastructure
342,285.00
3,675,00
345,960.00
.00
332,042.99
.00
13,917.01
96
9,240.00
Bond Principal
.00
.00
.00
.00
.00
.00
.00
+++
.00
Interest Expense
.00
.00
.00
.00
.00
.00
.00
+++
00
Interfund Transfers
.00
.00
.00
.00
.00
.00
.00
...
.00
EXPENSE TOTALS
$3,758,455.00
$3,675.00
$3,762,130.00
$0.00
$389,086.50
$4,248.35
$3,368,795.15
10%
$23,073.16
Fund 022 - Downtown Redevelopment Construct Totals
$3,758,455.00
$3,675.00
$3,762,130.00
$0.00
$389,086.50
$4,248.35
$3,368,795.15
$23,073.16
Expense Budget by Account Classification
Adopted Budget
Account Classification Budget Amendments
Fund 023 - Street Improvement Construc Fund
EXPENSE
Report
Through 03/31/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 107,000.00
.00
107,000.00
.00
.00
.00
107,000.00 0
40,700.82
Infrastructure 4,715,000.00
2,041,886.00
6,756,886.00
7,992.88
5,831,813.64
7,992.88
917,079.48 86
1,724.61
Interfund Transfers .00
.00
.00
.00
.00
.00
.00 +++
.00
EXPENSE TOTALS $4,822,000.00
$2,041,886.00
$6,863,886.00
$7,992.88
$5,831,813.64
$7,992.88
$1,024,079.48 85%
$42,425.43
Fund 023 - Street Improvement Construc Fund Totals $4,822,000.00
$2,041,886.00
$6,863886.007
$ , 992.88
$5,831,813.64
$7,992.88
$1,024,079.48
$42,425.43
C�
rn
Expense Budget by Account Classification
Adopted Budget
Account Classification Budget Amendments
Fund 024 - Flood Control Construction Fund
EXPENSE
Report
Through 03/31/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
282.80
.00
388.89
1,911.11
17
549.37
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
8.68,591.00
10,648,551.00
530,383.75
8,251,760.94
530,383.75
1,866,406.31
82
100,139.00
EXPENSE TOTALS
$9,804,360.00
$868,591.00
$10,672,951.00
$530,666.55
$8,251,760.94
$530,772.64
$1,890,417.42
82%
$100,688.37
Fund 024 - Flood Control Construction Fund Totals
$9,804,360.00
$868,591.00
$10,672,951.00
$530,666.55
$8,251,760.94
$530,772.64
$1,890,417.42
$100,688.37
Expense Budget by Account Classification
Adopted Budget
Account Classification Budget Amendments
Fund 040 - Refuse Disposal Fund
EXPENSE
Report
Through 03/31/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
Personal Services, Scheduled Salaries & Wages
236,644.00
..00
236,644.00
19,100.22
.00
58,549.61
178,094.39
25
66,886.22
Employee Benefits
110,436.00
.00
110,436.00
9,501.35
.00
29,168.77
81,267.23
26
28,697.59
Other Employee Costs
1,248.00
,00
1,248.00
.00
.00
.00
1,248.00
0
.00
Contractual Services
4,294,934.00
4,742.00
4,299,676.00
311,189.80
4,752.15
821,428.62
3,473,495.23
19
825,196.92
Utilities
447.00
.00
447.00
22.07
.00
59.64
387.36
13
62.65
Insurance
31,809.00
.00
31,809.00
2,650.75
.00
7,952.25
23,856.75
25
7,160.01
Commodities & Supplies
38,446.00
.00
38,446.00
9,947.72
133.30
10,073.78
28,238.92
27
2,481.84
EXPENSE TOTALS
$4,713,964.00
$4,742.00
$4,718,706.00
$352,411.91
$4,885.45
$927,232.67
$3,786,587.88
20%
$930,485.23
Fund 040 - Refuse Disposal Fund Totals
$4,713,964.00
$4,742.00
$4,718,706.00
$352,411.91
$4,885.45
$927,232.67
$3,786,587.88
$930,485.23
v
00
Account Classification
Fund 041 - Motor Fuel Tax Fund
EXPENSE
Expense Budget by Account Classification
Report
Through 03/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Contractual Services
284,686.00
.00
284,686.00
5,927.01
150,209.39
7,287.01
127,189.60
55
48,202.63
Utilities
156,060.00
.00
156,060.00
14,156.87
.00
33,789.49
122,270.51
22
44,210.34
Commodities & Supplies
453,209.00
.00
453,209.00
33,021.56
127,207.88
177,324.24
148,676.88
67
216,890.32
Building Improvements
600,000.00
.00
600,000.00
.00
.00
.00
600,000.00
0
.00
Infrastructure
663,000.00
.00
663,000.00
12,508.57
18,042.50
12,508.57
632,448.93
5
10,056.62
EXPENSE TOTALS
$2,156,955.00
$0.00
$2,156,955.00
$65,614.01
$295,459.77
$230,909.31
$1,630,585.92
24%
$319,359.91
Fund 041 - Motor Fuel Tax Fund Totals
$2,156,955.00
$0.00
$2,156,955.00
$65,614.01
$295,459.77
$230,909.31
$1,630,585.92
$319,359.91
Account Classification
Fund 042 - Cmmty Development Block Grant
EXPENSE
Personal Services, Scheduled Salaries & Wages
Employee Benefits
Other Employee Costs
Contractual Services
Commodities & Supplies
Other Expenditures
Land Improvements
Building Improvements
Infrastructure
EXPENSE TOTALS
Fund 042 - Cmmty Development Block Grant Totals
F-.1
Expense Budget by Account Classification
Report
Through 03/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
48,783.00
.00
48,783.00
3,344.84
.00
9,365.55
39,417.45
19
9,345.57
25,491.00
.00
25,491.00
2,016.76
.00
5,925.59
19,565.41
23
6,136.68
1,040.00
.00
1,040.00
.00
.00
47.50
992.50
5
.00
154,430.00
.00
154,430.00
157.64
.00
1,657.29
152,772.71
1
16, 596.81
520.00
.00
520.00
.00
.00
.00
520.00
0
.00
189,000.00
.00
189,000.00
430.00
.00
7,230.00
181,770.00
4
320.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
$419,264.00
$0.00
$419,264.00
$5,949.24
$0.00
$24,225.93
$395,038.07
6%
$32,399.06
$419,264.00
$0.00
$419,264.00
$5,949.24
$0.00
$24,225.93
$395,038.07
$32,399.06
Account Classification
Fund 043 -Asset Seizure Fund
EXPENSE
Other Employee Costs
Contractual Services
Other Equipment
Expense Budget Iby Account Classification
Report
Through 03/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 .00
3,000.00 .00 3,000.00 .00 .00 .00 3,000.00 0 1,500.00
15,000.00 �00 15,000.00 .00 .00 1,823.63 13,176.37 12 1,642.29
EXPENSE TOTALS $19,000.00 $0.00 $19,000.00 $0.00 $0.00 $1,823.63 $17,176.37 -10%$3,142.29
Fund 043 - Asset Seizure Fund Totals $19,000.00 $0.00 $19,000.00 $0.00 $0.00 $1,823.63 $17,176.37 $3,142.29
Expense Budget by Account Classification
Adopted Budget
Account Classification Budget Amendments
Fund 044 - Federal Equitable Share Funds
EXPENSE
Report
Through 03/31/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
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00 0
.00
Building Improvements
.00
.00
.00
.00
.00
.00
.00 +++
.00
Other Equipment
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00 0
.00
EXPENSE TOTALS
$2,000.00
$0.00
$2,000.00
$0.00
$0.00
$0.00
$2,000.00 0%
$0.00
Fund 044 - Federal Equitable Share Funds Totals
$2,000.00
$0.00
$2,000.00
$0.00
$0.00
$0.00
$2,000.00
$0.00
r
r
Account Classification
Fund 045 - DUI Fine Fund
EXPENSE
Other Employee Costs
Contractual Services
Other Equipment
Interfund Transfers
Expense Budget by Account Classification
Report
Through 03/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00
0
100
.00
.00
AO
00
.00
.00
.00
...
,00
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00
0
95.99
.00
.00
.00
.00
.00
.00
.00
+++
.00
EXPENSE TOTALS $2,000.00
$0.00
$2,000.00
$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
Expense Budget by Account Classification
Adopted Budget
Account Classification Budget Amendments
Fund 046 - Foreign Fire Tax Board Fund
EXPENSE
Report
Through 03/31/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
10,000.00
.00
10,000.00
.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
31,488.86
.00
31,488.86
(16,488.86)
210
8,856.00
EXPENSE TOTALS
$30,500.00
$0.00
$30,500.00
$31,488.86
$0.00
$37,082.02
($6,582.02)
122%
$11,950.11
Fund 046 - Foreign Fire Tax Board Fund Totals
$30,500.00
$0.00
$30,500.00
$31,488.86
$0.00
$37,082.02
($6,W.02)
$11,950.11
r
w
Account Classification
Fund 048 - Business District Fund
EXPENSE
Bond Principal
Interest Expense
EXPENSE TOTALS
Fund 048 - Business District Fund Totals
Expense Budget by Account Classification
Report
Through 03/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
.00
1,021,000.00
.00
.00
.00
1,021,000.00
.00
115,852.50
.00
.00
.00
115,852.50
.00 ...
905,147.50 11
.00
.00
$1,021,000.00
$0.00
$1,021,000.00
$115,852.50
$0.00
$115,852.50
$905,147.50 11%
$0.00
$1,021,000.00
$0.00
$1,021,000.00
$115,852.50
$0.00
$115,852.50
$905,147.50
$0.00
Expense Budget by Account Classification
Adopted Budget
Account Classification Budget Amendments
Fund 050 - Water and Sewer Fund
EXPENSE
Report
Through 03/31/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
2,006,058.00
.00
2,006,058.00
155,888.68
.00
486,333.10
1,519,724.90
24
548,713.38
Employee Benefits
772,177.00
.00
772,177.00
71,798.49
.00
209,876.86
562,300.14
27
210,730.86
Other Employee Costs
37,393.00
.00
37,393.00
934.43
211.75
3,474.99
33,706.26
10
10,480.69
Contractual Services
8,650,244.00
140,210.00
8,790,454.00
628,411.68
378,232.01
1,432,332.30
6,979,889.69
21
1,381,234.63
Utilities
160,913.00
.00
160,913.00
12,328.86
.00
20,385.04
140,527.96
13
21,298.99
Insurance
101,312.00
.00
101,312.00
8,484.33
.00
25,411.32
75,900.68
25
20,118.48
Commodities & Supplies
293,516.00
.00
293,516.00
29,429.21
54,029.72
41,676.54
197,809.74
33
47,095.75
Other Expenditures
.00
.00
.00
.00
.00
.00
.00
+++
.00
Building Improvements
65,000.00
37,225.00
102,225.00
.00
4,000.00
.00
98,225.00
4
.00
Office Equipment
3,930.00
.00
3,930.00
.00
.00
.00
3,930.00
0
.00
Other Equipment
1,173,744.00
1,253,881.00
2,427,625.00
199,415.23
1,203,410.57
363,884.67
860,329.76
65
.00
Distribution Systems
2,300,500.00
912,832.00
3,213,332.00
95,730.95
411,382.83
104,508.33
2,697,440.84
16
2,786.21
Infrastructure
.00
.00
.00
.00
.00
.00
.00
+++
.00
Bond Principal
.00
.00
.00
.00
.00
.00
.00
+++
.00
Interest Expense
.00
.00
.00
.00
.00
.00
.00
...
.00
Interfund Transfers
.00
.00
.00
.00
.00
.00
.00
...
.00
EXPENSE TOTALS
$15,564,787.00
$2,344,148.00
$17,908,935.00
$1,202,421.86
$2,051,266.88
$2,687,883.15
$13,169,784.97
26%
$2,242,458.99
Fund 050 - Water and Sewer Fund Totals
$15,564,787.00
$2,344,148.00
$17,908,935.00
$1,202,421.86$2,051,266.88
$2,687,883.15
$13,169,784.97
$2,242,458.99
r
Ln
r
rn
Expense Budget by Account Classification
Adopted Budget
Account Classification Budget Amendments
Fund 051 - Village Parking System Fund
EXPENSE
Report
Through 03/31/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
Personal Services, Scheduled Salaries & Wages
35,175.00
.00
35,175.00
2,654.12
.00
8,100.47
27,074.53
23
9,761.69
Employee Benefits
17,353.00
.00
17,353.00
1,316.88
.00
3,978.36
13,374.64
23
3,946.31
Contractual Services
94,382.00
.00
94,382.00
4,865.81
7,304.77
17,016.63
70,060.60
26
17,346.95
Insurance
2,156.00
.00
2,156.00
179.67
.00
539.01
1,616.99
25
293.76
Commodities & Supplies
520.00
.00
520.00
.00
.00
.00
520.00
0
.00
Other Expenditures
.00
.00
.00
.00
.00
.00
.00
...
.00
Building Improvements
7,074.00
.00
7,074.00
.00
3,500.00
.00
3,574.00
49
.00
Infrastructure
153,500.00
.00
153,500.00
.00
.00
.00
153,500.00
0
.00
Interfund Transfers
.00
.00
.00
.00
.00
.00
.00
+++
.00
EXPENSE TOTALS
$310,160.00
$0.00
$310,160.00
$9,016.48
$10,804.77
$29,634.47
$269,720.76
13%
$31,348.71
Fund 051 - Village Parking System Fund Totals
$310,160.00
$0.00
$310,160.00
$9,016.48
$10,804.77
$29,634.47
$269,720.76
$31,348.71
Expense Budget by Account Classification
Report
Through 03/31/15
Prior Fiscal Year Activity Included
Summary Listing
r
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD
% used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions
Rec'd
Prior Year YTD
Fund 052 - Parking System Revenue Fund
EXPENSE
Personal Services, Scheduled Salaries & Wages
25,830.00
.00
25,830.00
1,945.03
.00
5,918.35
19,911.65
23
7,011.40
Employee Benefits
13,024.00
.00
13,024.00
973.78
.00
2,938.18
10,085.82
23
2,918.63
Contractual Services
114,325.00
.00
114,325.00
9,609.46
5,236.86
21,626.15
87,461.99
23
20,706.57
Utilities
10,733.00
.00
10,733.00
1,072.89
.00
1,459.58
9,273.42
14
1,769.80
Insurance
1,757.00
.00
1,757.00
146.42
.00
439.26
1,317.74
25
351.51
Commodities & Supplies
9,974.00
.00
9,974.00
.00
.00
639.29
9,334.71
6
5,176.44
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,747.58
$5,236.86
$33,020.81
$212,385.33
15%
$37,934.35
Fund 052 - Parking System Revenue Fund Totals
$250,643.00
$0.00
$250,643.00
$13,747.58
$5,236.86
$33,020.81
$212,385.33
$37,934.35
r
00
Expense Budget Iby Account Classification
Adopted Budget
Account Classification Budget Amendments
Fund 060 - Vehicle Maintenance Fund
EXPENSE
Report
Through 03/31/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
951,226.00
.00
951,226.00
72,855.93
.00
231,558.40
719,667.60
24
260,341.01
Employee Benefits
379,364.00
.00
379,364.00
29,913.08
.00
89,912.32
289,451.68
24
97,992.82
Other Employee Costs
2,408.00
,00
2,408.00
75.00
.00
249.33
2,158.67
10
375.00
Contractual Services
102,813.00
12,844.00
115,657.00
9,455.85
36,385.94
14,790.23
64,480.83
44
17,845.24
Utilities
3,132.00
.00
3,132.00
198.28
.00
908.88
2,223.12
29
390.55
Commodities & Supplies
735,223.00
26,295.00
761,518.00
43,480.81
254,903.90
142,084.65
364,529.45
52
203,517.34
Other Expenditures
.00
.00
.00
.00
.00
.00
.00
...
.00
Office Equipment
567.00
.00
567.00
.00
.00
.00
567.00
0
132.99
Other Equipment
20,165.00
.00
20,165.00
.00
13,840.00
55.83
6,269.17
69
350.00
EXPENSE TOTALS
$2,194,898.00
$39,139.00
$2,234,037.00
$155,978.95
$305,129.84
$479,559.64
$1,449,347.52
35%
$580,944.95
Fund 060 - Vehicle Maintenance Fund Totals
$2,194,898.00
$39,139.00
$2,234,037.00
$155,978.95
$305,129.84
$479,559.64
$1,449,347.52
$580,944.95
Account Classification
Fund 061 - Vehicle Replacement Fund
EXPENSE
Expense Budget by Account Classification
Report
Through 03/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Other Expenditures .00
.00
.00
.00
.00
.00
.00 ...
00
Motor Equipment 909,000.00
273,406.00
1,182,406.00
2,837.18
233,421.95
13,511.47
935,472.58 21
20,842.91
Interfund Transfers .00
.00
.00
.00
.00
.00
.00 +++
.00
EXPENSE TOTALS $909,000.00
$273,406.00
$1,182,406.00
$2,837.18
$233,421.95
$13,511.47
$935,472.58 21%
$20,842.91
Fund 061- Vehicle Replacement Fund Totals $909,000.00
$273,406.00
$1,182,406.00
$2,837.18
$233,421.95
$13,511.47
$935,472.58
$20,842.91
r
�O
N
O
Account Classification
Fund 062 - Computer Replacement Fund
EXPENSE
Other Expenditures
Office Equipment
EXPENSE TOTALS
Fund 062 - Computer Replacement Fund Totals
Expense Budget by Account Classification
Report
Through 03/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
.00
429,380.00
.00
.00
.00
429,380.00
.00
.00
.00
4,078.70
.00
32,843.26
.00 +++
392,458.04 9
.00
51,184.23
$429,380.00
$0.00
$429,380.00
$0.00
$4,078.70
$32,843.26
$392,458.04 9%
$51,184.23
$429,380.00
$0.00
$429,380.00
$0.00
$4,078.70
$32,843.26
$392,458.04
$51,184.23
Account Classification
Fund 063 - Risk Management Fund
EXPENSE
Expense Budget by Account Classification
Report
Through 03/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD
Contractual Services
25,000.00
.00
25,000.00
650.00
.00
4,450.00
20,550.00
18
,00
Insurance
7,889,896.00
.00
7,889,896.00
878,807.54
.00
2,145,378.17
5,744,517.83
27
2,052,010.94
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
$879,457.54
$0.00
$2,149,828.17
$5,930,067.83
27%
$2,052,010.94
Fund 063 - Risk Management Fund Totals
$8,079,896.00
$0.00
$8,079,896.00
$879,457.54
$0.00
$2,149,828.17
$5,930,067.83
$2,052,010.94
N
r
N
N
Account Classification
Fund 070 - Police Pension Fund
EXPENSE
Expense Budget by Account Classification
Report
Through 03/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD
Pension Benefits
4,472,170.00
.00
4,472,170.00
370,716.80
.00
1,111,471.03
3,360,698.97
25
973,779.44
Contractual Services
154,100.00
.00
154,100.00
2,415.97
.00
3,590.61
150,509.39
2
2,466.83
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
.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
$373,132.77
$0.00
$1,115,411.64
$3,537,958.36
24%
$976,496.27
Fund 070 - Police Pension Fund Totals
$4,653,370.00
$0.00
$4,653,370.00
$373,132.77
$0.00
$1,115,411.64
$3,537,958.36
$976,496.27
Account Classification
Fund 071 - Fire Pension Fund
EXPENSE
Pension Benefits
Contractual Services
Insurance
Commodities & Supplies
Other Expenditures
Expense Budget by Account Classification
Report
Through 03/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
4,334,168.00
.00
4,334,168.00
369,480.27
.00
1,109,005.72
3,225,162.28
26
1,003,690.71
136,100.00
.00
136,100.00
3,649.28
.00
16,675.43
119,424.57
12
13,491.74
15,000.00
.00
15,000.00
.00
.00
.00
15,000.00
0
.00
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00
0
.00
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 $373,129.55 $0.00 $1,125,681.15 $3,372,586.85 25% $1,017,182.45
Fund 071- Fire Pension Fund Totals $4,498,268.00 $0.00 $4,498,268.00 $373,129.55
$0.00 $1,125,681.15 $3,372,586.85 $1,017,182.45
Grand Totals $115,972,850.00 $8,257,928.00 $124,230,778.00 $9,129,647.01 $18,973,671.43 $21,559,273.39 $83,697,833.18 $20,539,414.73
N
W
so
Amount
231.50
95.88
227.94
6,609.37
69.98
14.52
22.47
40.91
213.17
50.00
82.99
48.00
5,606.40
40.00
100.26
100.26
100.26
62.00
237.70
450.00
207.45
335.00
64.69
38.00
2,915.03
2,754.15
690.00
567.90
439.95
38.00
212.71
142.85
608.89
88.50
39.20
50.00
86.37
374.85
1,975.25
(39.45)
206.62
46.32
111.60
90.00
12.30
16.15
6.37
13.68
27.30
16.40
4.10
22.75
215.00
390.00
9,890.00
225.00
VILLAGE OF MOUNT PROSPECT
List of Bills
April 01 - April 15, 2015
Fund Vendor Name
Invoice Description
001 General Fund
A Stars & Stripes Flag Corporation
Flags
A.M. Leonard Inc.
Other Equipment - Anchor Duckbill
Forestry Equipment
ACS State & Local Government Solutions
Illinois State Disbursement Unit
Addison Building Material Co.
Maintenance and repair supplies
Maintenance and repair supplies
Maintenance and repair supplies
Maintenance and repair supplies
Airgas, Inc.
Oxygen Tank Supplies
Allan I. Kaplan
Sister Cities Pot Luck 2015 Musician
Anderson Lock Company
Locks for Evidence/Property area
Anderson Pest Solutions
April pest control for the CCC
Andres Medical Billing, Ltd.
Ambulance Billing - March 2015
Anwar, Muhammad Arfeen
Refund Vehicle License Fee
Aramark Uniform Services, Inc.
Rental and cleaning of uniforms for Public Works employees
Rental and cleaning of uniforms for Public Works employees
Uniform Cleaning and Rental
ARC Document Solutions, LLC
Equipment Maintenance
Arlington Power Equipment
Forestry Equipment
Armor Systems Corporation
March 2015 Commission due on MB Invoice Collection
Arrowhead Scientific Inc.
Evidence technician supplies
ET Equipment
Baldini, Carol
Mileage Reimbursement
Barnett, Lesley
Reimburse training expenses
Baudville, Inc.
Photo Equipment for Department IDs
Bedco Mechanical
Bi -monthly HVAC service at 10 public buildings for April/May
HVAC Repairs
Repairs made to HVAC at the Village Hall
Repairs made to the AC unit for TV services at the Village Hall
Berg, Christopher
Reimburse training expenses
Blue Cross Blue Shield of Illinois
Refund for Ambulance Services - Patrcia Hermann 1/30/15
BMK Veterinary Associates
Stray dogs- March, 2015
Brownells, Inc.
Range supplies
Busse's Flowers & Gifts
Wilks arrangement
Other supplies
Mayor's arrangement
Capital One National Association
Costco Purchase 3/10/15
Case Lots, Inc.
Custodial Supplies
Custodial Supplies
CDW Government, Inc.
Credit for return of HDMI cable
Replacement hard drive for web server
Software for Investigations
Central Continental Bakery
Cake for Pastor Russ (70th)
Maintenance and repair supplies
Century Cleaners
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Chem -wise Ecological Pest Mgmt Inc
Equipment Maintenance and Repair
CL Graphics, Inc.
Postage Set Up professional services
Print Spring 2015 Newsletter
College of Lake County
Career Fair registration 05/21/15
Page 1 of 9
so
Amount
231.50
95.88
227.94
6,609.37
69.98
14.52
22.47
40.91
213.17
50.00
82.99
48.00
5,606.40
40.00
100.26
100.26
100.26
62.00
237.70
450.00
207.45
335.00
64.69
38.00
2,915.03
2,754.15
690.00
567.90
439.95
38.00
212.71
142.85
608.89
88.50
39.20
50.00
86.37
374.85
1,975.25
(39.45)
206.62
46.32
111.60
90.00
12.30
16.15
6.37
13.68
27.30
16.40
4.10
22.75
215.00
390.00
9,890.00
225.00
Fund
Page 2 of 9
VILLAGE OF MOUNT PROSPECT
List of Bills
April 01- April 15, 2015
Vendor Name
Invoice Description
Amount
Comcast
Xfinity Internet service 04/11-05/10/15
82.90
Constellation NewEnergy, Inc.
Electrical Service Delivery
31.05
Electrical Service Delivery
31.05
Costar Realty Information, Inc.
April service
542.09
Crystal Court Shopping Center
May rent for the CCC
5,839.97
Crystal Maintenance Services Corp.
Billing for custodial services in eight buildings for April
7,187.24
CVS Pharmacy, Inc.
Prisoner medication: #15-2817 (A. Russell)
64.06
Elgin Community College
Job Fair registration 04/17/15
175.00
Elite Remodeling Group, Inc.
Garnishment
142.22
Emergency Medical Products
Shoulder Straps (previously on back order)
82.80
Eterno, David G.
March billing
262.50
Experian
Background checks- March, 2015
77.24
Fire Pension Fund
Fire Pension
22,290.72
G & J Associates, Inc.
Civic Events Supplies
206.20
Maintenance and repair supplies
175.00
Gary J. Klein
Celestial Celebration 2015
1,250.00
Gorre, Katrina
Refund Overpayment Police Ticket #P3937952
50.00
Grainger Inc.
4 Sets of Rain Gear and Flashlights for Employee Go Kits
381.86
Mnintpnanrp and rpnair ciinnliac
5n 77
Purchased 4 New Sets of Rain Gear for Employee Go Kits
369.16
Custodial Supplies
658.62
Returned 4 Sets of Rain Gear for Employee Go Kits
(227.88)
Brackets to mount air tanks on engines -Qty. 6
114.66
Squad emergency supplies
107.13
Grandgeorge, Aaron
2015 Fire Uniform Clothing Allowance
220.49
GreatAmerica Financial Services Corporation
Office equipment
149.47
Guardian
Emp. Dental Plan April 2015
9,664.99
Guziel, Fran
Spring Newsletter 2015
1,760.00
Healy Asphalt Company,llc.
Asphalt materials for street patching at various locations
1,835.31
Hedman, Eric J.
Register Lisa Schaps for Honor Guard 10106/01-05/15
275.00
Hoffman, Walter
Refund Overpayment Vehicle Sticker Fee
25.00
Home Depot U.S.A., Inc.
Home Depot Statement
45.71
Humana Health Care Plans
Refund for Ambulance Services - Matthew Showalter 7/24/13
313.90
Refund for Ambulance Services - Martina Perez 9/20/13
483.56
ICMA Retirement Trust - 457
ICMA 457 (flat percent)
21,586.41
ILEETA
Conference registration & membership renewal: T. Janowick
412.00
Conference & membership: J. Schmitz
412.00
Conference & membership: D. 011ech
412.00
Conference & membership: Lisa Schaps
412.00
Conference and membership: C. Rondeau
412.00
Conference & membership: B. Tweedie
417.00
ILETSB Executive Institute
Register A. Addante & P. Lyons for training 05/27-28/15
150.00
Illinois American Water Company
Private Fire Service 4/2/15 - 4/29/15
33.84
Illinois Department of Revenue
IL State Withholding
27,662.86
Illinois Environmental Health Assc.
IEHA-Conf.
105.00
Illinois State Police
New Hire Background Check -Hamann
29.75
Fingerprinting charges of IT Dept. for PD
178.50
IMRF
IMRF
162,571.01
Internal Revenue Service
Federal Withholding
177,635.34
International Assoc of Arson Investigators IL Chap Membership: F. Raus
100.00
Membership: M. Landeweer
100.00
Membership: T. Hoskinson
100.00
Register T. Hoskinson for training conference
695.00
Register M. Landeweer for training conference
695.00
Register F. Raus for training conference
695.00
International Association of Fire Chiefs
Malcolm -Membership Renewal 2015
209.00
International Union of Operating Engineers
IUOE PW Membership Dues
959.49
Jackson, Timothy J
Refund Overpayment Police Ticket #133939734
20.00
Jasculca Terman & Associates, Inc.
Special legal services
1,976.00
Johnson, Naden Harriet
Refund Vehicle License Fee
40.00
Kane, Julie K
Reimbursement for Hands on Subn Event
32.49
Page 2 of 9
VILLAGE OF MOUNT PROSPECT
List of Bills
April 01- April 15, 2015
Fund Vendor Name
Invoice Descriotion
Amount
Kerstein, June
Reimbursement Food Exp - March 2015p
21.76
Kramer Tree Specialists
Tree Trimming
10,786.00
Tree Trimming
3,562.00
Tree Trimming
6,264.00
Kuhar, James
2015 Fire Uniform Clothing Allowance
42.49
Lands' End Business Outfitters
Administration/Fire Prevention Clothing
367.95
Laurinaitis, Kyle
2015 Fire Uniform Clothing Allowance
67.98
2015 Fire Uniform Clothing Allowance
23.96
Leib, Jason
Reimbursement
152.15
Lexisnexis Risk Data Management Inc.
Background checks - March, 2015
80.75
Malcolm, John
Lunch for EMS Coordinator Interview Panel
79.22
Mazursky, Shelby
Printing Expense
185.00
Menard Inc.
Tote for new fleet Dodge Charger
7.97
Metro Door and Dock, Inc.
Overhead door repair
528.20
Metro Federal Credit Union
MP Fire Local 4119 Dues
2,277.99
Metropolitan Alliance - Police
MP Police Association Dues
1,349.50
Meyer Laboratory, Inc.
Cleaning Supplies
1,451.03
Michael Wagner & Sons, Inc.
Maintenance and repair supplies
327.00
Maintenance and repair supplies
4.68
Midwest Commercial Fitness
Cardio Equipment Replacement
11,955.35
Mobile Print Inc.
Business cards for recruiting officers (6 names)
199.82
Envelopes (regular & window)
498.58
Irish Fest Posters 2015
126.10
Irish Fest Entrepreneurs Cafe Big Rack Cards
509.25
Moliere, Phyllis
Refund Overpayment Vehicle Sticker Fee
25.00
Nationwide Mutual Insurance Company
Nationwide 457 (flat percent)
12,734.70
NCPERS Group Life Ins.
IMRF Life Insurance
673.60
NGS Medicare Illinois
Refund for Ambulance Services - Patricia Hermann 1/30/15
257.57
NICOR
Natural Gas Consumption
62.38
Natural Gas Consumption
89.04
Natural Gas Consumption
85.38
North East Multi Regional Trng
Training for R. Kane
120.00
Northern Illinois Funeral Service Inc.
Remains removal: 10-57 Fatal (J. Gonzalez-Navarette)
300.00
Northshore University Healthsystem
Pre-employment physical: C. Johansen
696.00
Pre-employment physical: C. Johansen
208.00
Northwest Central Dispatch System
May 2015 - Member Assessment
55,795.54
Northwest Municipal Conference
Legislative days
250.16
Northwest Suburban United Way
United Way
108.86
Pachal, Susan
Refund Overpayment Police Ticket #P3939261
6.00
Paddock Publications, Inc.
PZ -05-15 legal notice
91.80
PZ -06-15 legal notice
82.35
PZ -07-15 legal notice
95.85
PZ -08-15 legal notice
86.40
Patel, Kanji
Refund Vehicle License Fee
15.00
Pelican Products, Inc„
Cases for tasers and traffic wands
396.46
Petty Cash
Petty Cash March 2015
191.43
Petty Cash -FD -March -2015
88.63
Phenegar, Dane R.
2015 Fire Uniform Clothing Allowance
55.24
Pikora, Cory
2015 Fire Uniform Clothing Allowance
157.24
Police Pension Fund
Police Pension
29,422.80
Proforma Customized Graphics
Open House Supplies
240.24
Open House Supplies
174.26
Open House Supplies
159.63
Open House Supplies
139.41
Open House Supplies
293.98
RAR Communications, Inc.
Media Relations Training
135.00
Reliance Standard Life Insurance Co.
Short Term Disability
3,210.40
Ronco Industrial Supply
Custodial Supplies
635.66
Roubitchek, Robert A
Refund Vehicle License Fee
40.00
Rudnicka, Jolanta
Refund Overpayment Police Ticket #P3923651
30.00
Schweppe Incorported
Maintenance and repair supplies
158.00
Secretary of State
H352208 - S-26 - License Plate Renewal
101.00
Page 3 of 9
VILLAGE OF MOUNT PROSPECT
List of Bills
April 01- April 15, 2015
Fund Vendor Name
Invoice Description
Amount
Secretary of State
6329272 - S-32 - License Plate Renewal
101.00
Security Equipment Supply
Maintenance and repair supplies
70.95
SHI International Corp.
Email Archiving Annual Fee
11,187.00
Sill, Gregory
Reimburse expenses: case for tablet
37.99
Slobe, Steve
2015 Fire Uniform Clothing Allowance
136.68
Solvent Systems Int'I. Inc.
Solvent for Tool Room Parts Washer
185.64
Maintenance and repair supplies
90.00
Standard Equipment Company
4502 Right side broom tilt motor
918.60
Staples Contract & Commercial, Inc.
Birthday banner for Pastor Bechtold
1.00
USB drives for photo evidence
167.30
State of Illinois
Internet Service
1,111.25
Stenzel, William W.
TSR analysis for 07/01-12/31/14
5,000.00
Stephen A. Laser Assoc.,p.c.
Hamann -Psychological Assessment
550.00
Pre-employment testing: W. Shaffer
550.00
Systems Forms, Inc.
#9 Return Envelopes
305.25
T.P.I.
Building Inspections
22,370.50
Taser International
Taser battery packs
503.46
The Carroll -Keller Group
Training-Consuelo
245.00
The Marpa Group, Inc.
Register D. 011ech & W. Ryan for training 05/13/15
200.00
The Ups Store
Shipping Fees
90.04
Shipping Charges
27.19
Theodore Polygraph Service Inc.
Pre-employment testing: W. Shaffer
175.00
Thompson Elevator Inspections
Elevator Inspections
450.00
Elevator Inspections
75.00
Elevator Inspections
150.00
Elevator Inspections
37.00
Elevator Inspections
74.00
TransUnion Risk and Alternative Data Solutions Inc
Background checks - March, 2015
151.00
U.S. Bank Equipment Finance, Inc.
Fire Station 12 #31906
138.78
Uline Inc.
Photo evidence supplies
120.08
United Parcel Service
Shipping charges for T. Follmer's retirement plaque
14.37
University of Illinois
Schwegler Leadership 13/16/15-3/20/15
300.00
VCG Uniform
Tactical vest cover: R. Kane
205.00
Vena, joseph B.
2015 Fire Unilorrn Clothing Allowance
277.40
2015 Fire Uniform Clothing Allowance
50.99
Village of Mount Prospect
Flex - Medical
9,530.33
Warehouse Direct
Keurig Machine
215.00
Label Maker/Labels for Station 12 and Dry Erase Cleaner
145.47
Keurig Filter & Filter Head
27.63
Office Supplies
200.25
Office Supplies
70.04
Office Supplies
436.28
11x17 paper, post its,6000 labels, wipes, expo markers
122.67
Office Supplies - March 2015
115.58
Office Supplies
35.16
Credit for return
(70.04)
Wide Open West
Backup Internet
284.50
Wilder, Ralph
Sister Cities Pot Luck 2015 Musician
50.00
WISCTF
Garnishment
542.48
001 General Fund Total
$ 696,110.03
020 Capital Improvement Fund
CS2 Design Group, LLC
Construction Engineering
$ 382.50
EWS Consultants, Inc.
Design/Consultation Services
380.00
Home Depot U.S.A., Inc.
Home Depot Statement
411.89
LAFORCE, INC.
Replacement of the back door at Fire Station 12 on Golf Road.
3,691.00
MG Mechanical Service, Inc.
HVAC Replacement
22,331.70
Northwest Central 9-1-1 System
Motorola Subscriber Financing - April 2015
10,603.91
Parenti & Raffaelli,ltd.
Payment 2 of 2 for Station 13 Kitchen Cabinets
9,902.50
020 Capital Improvement Fund Total
$ 47,703.50
Page 4 of 9
Fund Vendor Name
023 Street Improvement Construction Fund
Meade Electric Co. Inc.
023 Street Improvement Construction Fund Total
024 Flood Control Construction Fund
Burns & Mcdonnell Engineering Co.
Constellation NewEnergy, Inc.
024 Flood Control Construction Fund Total
040 Refuse Disposal Fund
ARC Disposal Company
Groot Industries, Inc.
[CMA Retirement Trust - 457
Illinois Department of Revenue
IMRF
Internal Revenue Service
International Union of Operating Engineers
Nationwide Mutual Insurance Company
NCPERS Group Life Ins.
Proforma Customized Graphics
Reliance Standard Life Insurance Co.
Anderson Lock Company
Anderson Pest Solutions
Andres Medical Billing, Ltd.
Anwar, Muhammad Arfeen
Aramark Uniform Services, Inc.
ARC Document Solutions, LLC
Arlington Power Equipment
Armor Systems Corporation
Arrowhead Scientific Inc.
Baldini, Carol
Barnett, Lesley
Baudville, Inc.
Bedco Mechanical
Berg, Christopher
Blue Cross Blue Shield of Illinois
BMK Veterinary Associates
Brownells, Inc.
Busse's Flowers & Gifts
Capital One National Association
Case Lots, Inc.
CDW Government, Inc.
Central Continental Bakery
VILLAGE OF MOUNT PROSPECT
List of Bills
April 01- April 15, 2015
Invoice
EVP System Improvements
Engineering Service
Electrical Service Delivery
Electrical Service Delivery
Debris Disposal
Debris Disposal
ICMA 457 (flat percent)
IL State Withholding
IMRF
Federal Withholding
IUOE PW Membership Dues
Nationwide 457 (flat percent)
IMRF Life Insurance
Open House Supplies
Open House Supplies
Open House Supplies
Open House Supplies
Open House Supplies
Short Term Disability
Locks for Evidence/Property area
April pest control for the CCC
Ambulance Billing - March 2015
Refund Vehicle License Fee
Rental and cleaning of uniforms for Public Works employees
Rental and cleaning of uniforms for Public Works employees
Uniform Cleaning and Rental
Equipment Maintenance
Forestry Equipment
March 2015 Commission due on MB Invoice Collection
Evidence technician supplies
ET Equipment
Mileage Reimbursement
Reimburse training expenses
Photo Equipment for Department IDs
Bi -monthly HVAC service at 10 public buildings for April/May
HVAC Repairs
Repairs made to HVAC at the Village Hall
Repairs made to the AC unit for TV services at the Village Hall
Reimburse training expenses
Refund for Ambulance Services - Patrcia Hermann 1/30/15
Stray dogs - March, 2015
Range supplies
Wilks arrangement
Other supplies
Mayor's arrangement
Costco Purchase 3/10/15
Custodial Supplies
Custodial Supplies
Credit for return of HDMI cable
Replacement hard drive for web server
Software for Investigations
Cake for Pastor Russ (70th)
Page 5 of 9
Amount
$ 18,836.00
$ 18,836.00
$ 39,833.18
91.63
92.79
$ 40,017.60
$ 1,333.31
81.00
73.86
297.77
3,161.01
2,741.82
99.23
205.58
17.60
31.70
22.99
21.06
18.39
38.79
81.36
82.99
48.00
5,606.40
40.00
100.26
100.26
100.26
62.00
237.70
450.00
207.45
335.00
64.69
38.00
2,915.03
f5
690.00
567.90
439.95
38.00
212.71
142.85
88.50
39.20
50.00
86.37
1,975.25
(39.45)
206.62
46.32
111.60
Fund Vendor Name
050 Water and Sewer Fund
Addison Building Material Co.
Aramark Uniform Services, Inc.
Aries Industries, Inc.
Baxter & Woodman, Inc.
Brunswick Zone - M.P.
Burns & Mcdonnell Engineering Co.
Busse's Flowers & Gifts
BWIP MP Owner LLC
Cash N Gold
CDW Government, Inc.
Century Cleaners
Clear Loss Prevention
Dong Xi An
HBK Water Meter Service
ICMA Retirement Trust - 457
Illinois Department of Revenue
IMRF
Internal Revenue Service
International Union of Operating Engineers
Kieft Brothers Inc.
Lorraine Pokuta
Michael Mazer
Nationwide Mutual Insurance Company
NCPERS Group Life Ins.
NICOR
Northwest Suburban United Way
Proforma Customized Graphics
Reliance Standard Life Insurance Co.
Smith Ecological Systems, Inc.
Suburban Laboratories, Inc.
Sytech,lnc.
Utility Dynamics Corp.
Vedat Mourad
Village of Mount Prospect
Warehouse Direct
Ziebell Water Service Products
050 Water and Sewer Fund Total
VILLAGE OF MOUNT PROSPECT
List of Bills
April 01- April 15, 2015
Invoice
Maintenance and repair supplies
Rental and cleaning of uniforms for Public Works employees
Rental and cleaning of uniforms for Public Works employees
Uniform Cleaning and Rental
Equipment Maintenance
Equipment Maintenance
Professional Services
Professional Services
Utility Refund - 824 E Rand Rd
Professional Services
Other supplies
Other supplies
Utility Refund -1545 Redwood Dr
Utility Refund - 1774 W Algonquin Rd
MS Project for PW
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Building Maintenance
Utility Refund -1401 Picadilly Cir
Water Meter Installations
Water Meter Installations
Water Meter Installations
Water Meter Installations
ICMA 457 (flat percent)
IL State Withholding
IMRF
Federal Withholding
IUOE PW Membership Dues
Water/Sewer Valves
Utility Refund - 908 S Elmhurst Rd
Utility Refund -1456 Picadilly Cir
Nationwide 457 (flat percent)
IMRF Life Insurance
Natural Gas
United Way
Open House Supplies
Open House Supplies
Open House Supplies
Open House Supplies
Open House Supplies
Short Term Disability
Water Treatment Chemicals
Water Sample Testing
XLR Reporter Update
Water Services
Utility Refund - 1817 Bonita Ave
Flex- Medical
Office Supplies
Maintenance and repair supplies
Amount
$ 67.61
100.27
100.27
100.27
1,165.53
247.15
11,900.00
2,758.75
272.21
1,180.20
40.80
93.50
137.87
1.87
611.34
12.30
16.15
6.38
13.67
27.30
16.40
4.10
22.75
3,080.00
1.02
6,944.00
5,561.00
71120
459.78
1,247.24
2,361.19
26,336.91
20, 238.25
990.50
900.00
9.72
180.42
420.89
52.80
121.21
21.00
179.56
130.25
119.31
104.20
219.73
63.94
1,064.25
314.50
250.00
2,290.00
3.13
696.27
119.95
371.00
$ 94,459.91
051 Village Parking System Fund
Crystal Maintenance Services Corp. Billing for custodial services in eight buildings for April $ 330.23
Elite Remodeling Group, Inc. Garnishment 78.19
ICMA Retirement Trust - 457 ICMA 457 (flat percent) 9.00
Page 6 of 9
Fund Vendor Name
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
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
Abbott Rubber Co., Inc.
American Messaging
Arlington Heights Ford
Arlington Power Equipment
Atlas Bobcat Inc.
Chicago Parts & Sound Llc
Elite Power Solutions LLC
General Parts Inc.
Global Emergency Products
ICMA Retirement Trust - 457
Illinois Department of Revenue
IMRF
Inland Power Group Inc.
Internal Revenue Service
International Union of Operating Engineers
Interstate Battery
Leach Enterprises, Inc.
Lindco Equipment Sales, Inc.
Mcmaster-carr Supply Co.
Municipal Fleet Managers Assoc
Napa -Heights Automotive Supply
VILLAGE OF MOUNT PROSPECT
List of Bills
April 01- April 15, 2015
Invoice
IL State Withholding
IMRF
Federal Withholding
IUOE PW Membership Dues
Nationwide 457 (flat percent)
IMRF Life Insurance
Petty Cash March 2015
Flex - Medical
Billing for custodial services in eight buildings for April
Garnishment
ICMA 457 (flat percent)
IL State Withholding
IMRF
Federal Withholding
IUOE PW Membership Dues
Nationwide 457 (flat percent)
IMRF Life Insurance
Natural Gas Consumption
Flex- Medical
Vehicle Maintenance Supplies
Vehicle Maintenance Supplies
Professional Service
P-7 Instrument cluster, P-2 fog light
Vehicle Maintenance Supplies
Vehicle Maintenance Supplies
Vehicle Maintenance Supplies
Police CV wheel tire sensors
Oil and fuel filters
P37 Drivers door
Oil filters
Air filters, thermostats and outlet
Equipment Maintenance
WD -40 -Partial
Credit for wrong part
Engine Oil
Fog light bulbs
Bulbs
4542 Catalytic convertors
4558 Hydraulic filters
Fuel and coolant filters
4568 Oil filter
530 Tower intake gauge
ICMA 457 (flat percent)
IL State Withholding
IMRF
Equipment Maintenance
Federal Withholding
IUOE PW Membership Dues
2 Batteries
Vehicle Maintenance Supplies
Vehicle Maintenance Supplies
Foam tape seal
Training
555 Trailer brake switch
4524 Air filter
4542 Spark plug boots
Page 7 of 9
Amount
36.70
424.64
294.28
15.22
9.96
4.40
20.00
34.64
$ 1,257.26
$ 252.53
64.02
6.02
26.79
311.86
214.16
10.16
6.65
3.60
207.91
27.44
$ 1,131.14
$ 106.80
106.80
115.71
405.29
31.70
500.07
122.14
95.26
164.44
200.00
69.36
53.99
2,198.00
75.00
(7.20)
47.40
15.38
48.98
325.48
95.40
34.54
2.91
102.26
866.50
1,179.95
11,868.42
2,778.28
9,750.59
474.38
183.90
14.28
439.13
11.83
30.00
23.58
18.68
39.04
VILLAGE OF MOUNT PROSPECT
List of Bills
April 01 - April 15, 2015
Fund Vendor Name
Invoice Description
$
Amount
Napa -Heights Automotive Supply
4542 Valve cover gasket _
$
70.49
063 Risk Management Fund
Brake Cleaner, carb cleaner, Undercoating
Refund Escrow Permit # 13-2042 (1716 Myrtle Dr)
498.36
NCPERS Group Life Ins.
IMRF Life Insurance
$
48.00
Northwest Suburban United Way
United Way
Carmen and Son's Concrete
4.00
Palatine Oil, Inc.
6,502 Gallons biodiesel fuel
Refund Escrow Permit # 14-1855 (408 Eastwood Ave)
13,113.31
Petroliance, LLC.
Vehicle Maintenance Supplies
$
323.02
Power Equipment Leasing Co
Equipment Maintenance and Repair
1,807.00
Lauterbach & Amen, LLP
Credit
$
(940.54)
Precision Service & Parts
4500 Gas cap
$
18.91
071 Fire Pension Fund
Coolant
285.60
Bogdahn Consulting, LLC
4542 Oxygen sensor
$
36.53
Collins & Radja
2707 Thermostat & Gasket
27.70
Lauterbach & Amen, LLP
4542 Fuel pressure sensor
82.62
071 Fire Pension Fund Total
4542 Spark plugs
$
76.64
4542 Ignition coils
386.40
Reliance Standard Life Insurance Co.
Short Term Disability
92.48
Ronco Industrial Supply
Small Tools
60.60
Schnittker, John
Training
141.00
Sid Tool Co., Inc.
Bolts, washers, nuts, electric connectors, rivets, screws, tubing
442.44
Nuts, bolts, washers, eye bolts and clamps
447.66
Snap On Industrial Div of IDSC Holdings Inc.
Equipment Maintenance
1,249.00
Village of Mount Prospect
Flex - Medical
350.02
West Side Tractor Sales
John Deere backhoe fuel caps, bulbs
210.29
060 Vehicle Maintenance Fund Total
$
51,419.80
061 Vehicle Replacement Fund
Global Emergency Products
New Vehicles
$
99.87
Sauber Mfg. Co.
New Vehicles
420.00
W.S. Darley & Co.
New Vehicles
333.90
New Vehicles
1,825.00
061 Vehicle Replacement Fund Total
$
2,678.77
062 Computer Replacement Fund
Meridian It Inc.
Router Replacement - Public Safety WanRTR
$
2,835.52
062 Computer Replacement Fund Total
25.00
$
2,835.52
063 Risk Management Fund
Aspen General Contractors Inc
Refund Escrow Permit # 13-2042 (1716 Myrtle Dr)
250.00
Intergovernmental Per.ben.coop
IPBC-April 2015
$
496,291.84
International Union of Operating Engineers
PW Insurance Premiums
Carmen and Son's Concrete
52,425.00
The Cima Companies, Inc.
Volunteer Insurance Renewal 7/1/15 - 7/1/16
Refund Escrow Permit # 14-1855 (408 Eastwood Ave)
2,435.00
063 Risk Management Fund Total
Refund Escrow Permit # 15-0266 (1422 Redwood Dr)
$
551,151.84
070 Police Pension Fund
Lauterbach & Amen, LLP
Pension Services Administration - March 2015
$
1,315.00
070 Police Pension Fund Total
$
1,315.00
071 Fire Pension Fund
Bogdahn Consulting, LLC
Performance Evaluation 4/1/15 - 6/30/15
$
9,000.00
Collins & Radja
1st Quarter Retainer 2015 (January, February & March)
800.00
Lauterbach & Amen, LLP
Pension Services Administration - March 2015
1,500.00
071 Fire Pension Fund Total
$
11,300.00
073 Escrow Deposit Fund
Airoom Builders
Refund Escrow Permit # 13-2141 (12 N Edward St)
$ 350.00
ARS of Illinois
Refund Escrow Permit # 14-1716 (40 N Albert St)
25.00
Refund Escrow Permit # 15-0287 (106 S Mt. Prospect Rd)
125.00
Aspen General Contractors Inc
Refund Escrow Permit # 13-2042 (1716 Myrtle Dr)
250.00
Brasco Inc
Refund Escrow Permit # 14-1385 (475 Enterprise Dr)
125.00
Capps Plumbing and Sewer Inc
Refund Escrow Permit # 15-0345 (1420 S Busse Rd)
125.00
Carmen and Son's Concrete
Refund Escrow Permit # 15-0257 (419 N Forest Ave)
200.00
Carvell, William
Refund Escrow Permit # 14-1855 (408 Eastwood Ave)
125.00
Cox Contracting
Refund Escrow Permit # 15-0266 (1422 Redwood Dr)
125.00
Page 8 of 9
VILLAGE OF MOUNT PROSPECT
List of Bills
April 01- April 15, 2015
Fund Vendor Name
Invoice Descriotion
Amount
DRF Installations Inc
Refund Escrow Permit # 15-0236 (1925 Hopi Ln)
125.00
Flush Sewer & Drainage
Refund Escrow Permit # 15-0263 (219 S William St)
125.00
Four Seasons Heating and A/C
Refund Escrow Permit # 14-2493 (1511 Lowden Ln)
125.00
Freeman, Matt Mongoven
Refund Escrow Permit # 15-0069 (1780 Wall St)
400.00
Fricano, Guiseppe
Refund Escrow Permit # 15-0315 (607 W Central Rd # 131)
125.00
G A Johnson & Son
Refund Escrow Permit # 12-0638 (1000 Mt Prospect Piz)
900.00
Home Comfort Services
Refund Escrow Permit # 14-2524 (1810 Pheasant Trl)
50.00
Hurdogan, Recep-zeha
Refund Escrow Permit # 15-0312 (1309 N Lama Ln)
125.00
Illinois State Police
Seized Assets - MPPD #14-15269 - S.A.O.#14-11-0037
4,679.00
Lampignano & Son Construction Co
Refund Escrow Permit # 15-0354 (604 Russel St)
200.00
Lara, Leobardo M
Refund Escrow Permit # 11-0605 (10 E Golf Rd)
125.00
Maggos, Dean
Refund Escrow Permit # 15-0270 (1102 W Milburn Ave)
500.00
McNelly Services Inc
Refund Escrow Permit # 14-1912 (1701 E Kensington Rd)
125.00
Meadows Construction Inc
Refund Escrow Permit # 15-0066 (1800 S Elmhurst Rd)
200.00
Refund Escrow Permit # 15-0068 (935 N Elmhurst Rd)
209.00
Midwest Interstate Electric
Refund Escrow Permit # 15-0078 (800 Business Center Dr)
125.00
MK Construction
Refund Escrow Permit # 14-2479 (1428 Burning Bush Ln)
300.00
Mount Prospect Public Library
2015 PPRT- 3rd Allocation
13,382.72
Olszewski, Sylwester
Refund Escrow Permit # 15-0262 (1416 Lowden Ln)
125.00
Panagakis, lames
Refund Escrow Permit # 10-2246 (912 S Busse Rd)
300.00
Piatek, Olgierd
Refund Escrow Permit # 13-0678 (1433 E Emmerson Ln)
200.00
Presidential Construction and Roofing
Refund Escrow Permit # 14-2453 (1165 Boxwood Dr)
125.00
Punnavila, Philip J
Refund Escrow Permit # 14-1188 (1807 Willow Ln)
400.00
Rave Electric Corp
Refund Escrow Permit # 14-0992 (800 Patridge Ln)
125.00
Ricks Sewer & Drainage
Refund Escrow Permit # 15-0316 (124 Bobby Ln)
125.00
Rock Solid Builders Inc
Refund Escrow Permit # 15-0115 (5115 Owen St)
300.00
Shargio Patel Realty LLC
Refund Escrow Permit #14-0679 (1601 W Algonquin Rd)
500.00
Sign A Rama
Refund Escrow Permit # 15-0165 (60 E Busse Ave)
125.00
St Paul Evangeligcal Lutheran Congregation
Refund Escrow Permit # 14-1574 (100 S School St)
125.00
Taylor, Norman L
Refund Escrow Permit # 15-0301 (500 S Emerson St)
125.00
TDH Mechanical
Refund Escrow Permit # 15-0368 (217 S Elmhurst Ave)
125.00
Third District Circuit Court
Bond Check 4/2/15
100.00
Bond Check 4/7/15
600.00
Bond Check 4/9/15
1,450.00
Bond Check 4/14/15
300.00
US Waterproofing Inc
Refund Escrow Permit # 14-1557 (1325 Peachtree Ln)
125.00
073 Escrow Deposit Fund Total
$ 28,545.72
Grand Total
$ 2,585,225.18
Page 9 of 9