HomeMy WebLinkAbout3. Financial Report and Approve Bills 09/15/2015Mount I'rrs{��rt
Village of Mount Prospect
Mount Prospect, Illinois
INTEROFFICE MEMORANDUM
TO: VILLAGE PRESIDENT AND BOARD OF TRUSTEES
FINANCE COMMISSION
FROM. FINANCE DIRECTOR
DATE: SEPTEMBER 11, 2015
SUBJECT: MONTHLY FINANCIAL REPORT — AUGUST 2015
Attached hereto are the cash position and investment statements of the Village for the month
ended August 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 funds are not accessible for Village operations.
They are restricted for pension and escrow funding only. Please read the summary that follows
for further detail on the cash position of the Village.
Cash and Investment Position Report — All Funds (page 1)
This report provides a detail summary of cash and investments for the Village broken out by
governmental and enterprise funds and trust and agency funds. Governmental funds include
the General Fund, Special Revenue Funds, Debt Service Funds, Capital Project Funds and
Internal Service Funds. The Enterprise Funds consist of the Water/Sewer Fund and two (2)
Parking Funds.
Trust funds include the Village's two public safety pensions (Police and Firefighters') while the
agency funds include the Escrow Deposit and Flexcomp 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.
Governmental and Enterprise Funds - Cash and cash equivalents at July 31 was $45.7
million. During August, cash receipts totaled $9,964,598. There was also a transfer in from
investments of $998,846, investment income was $2,507 and inflows due to Interfund activity
added $46,858 to the balance. Reductions in cash and cash equivalents during August totaled
$5,785,848. Of this amount, payments to vendors were $4,458,453 and employee payroll and
related expenses were $1,319,998. Other disbursements totaled $7,397. Cash and cash
equivalents at August 31 were $51.0 million.
Monthly Financial Report —August 2015
September 11, 2015
Page 2
Investments in the Governmental and Enterprise Funds at July 31 were $2.6 million. $1.0
million worth of CD's matured during August. CD's in the Governmental and Enterprise Funds
reside in the Flood Control Fund and were purchased using proceeds from the Series 2013
bond issue. The maturity dates of the CD's are laddered to match the expected payout
schedule of the underlying flood control and street resurfacing work. Total investments at
August 31 were $1.6 million.
Total cash and investments for Governmental and Enterprise Funds at July 31 were
$48,383,222. Cash and investments at August 31 totaled $52,612,584. This is an increase of
$4,229,362 for the month.
Trust and Agency Funds - Cash and cash equivalents at July 31 was $2.7 million. During
August, cash receipts totaled $1,837,970. In addition investment income for the month was
$106,373 and outflows due to Interfund activity totaled $46,858. There was a net increase in
cash due to investment activities of $209,779. Reductions in cash and cash equivalents during
August totaled $852,159. Of this amount, payments to vendors were $222,770, employee
payroll and related expenses were $626,611, payments related to the flexible spending program
totaled $9,705. Other disbursements were $3,074. Cash and cash equivalents at August 31
were $4.0 million.
Total investments at August 31 were $114,246,911, a decrease of $2,359,104 from July 31,
2015. There was an unrealized investment loss of $2,149,325 and a transfer from cash of
$209,779 that accounted for the change.
Total cash and investments for Trust and Agency Funds at July 31 were $119,310,932. Cash
and investments at August 31 totaled $118,196,932, a decrease of $1,114,000 for the month.
Summary of Cash Activity by Fund Tvpe (page 2)
This report provides a breakdown of the cash activity for the month broken down by fund type.
This breakdown is useful in identifying where the activity (receipts and disbursements) is
occurring. There are times during the year when activity in certain funds such as the capital
improvement and special revenue funds is higher than normal. This will distort the financial
picture of some of the other components of the governmental funds such as the General Fund
which tends to be more level and predictable in terms of spending and receipt of revenue. Each
month the report will provide detail explanation on activity of the General Fund, the Village's
primary operating fund.
General Fund — Cash and cash equivalents at July 31 totaled $11,274,924. During August,
cash receipts totaled $6,221,659 and investment income was $587. Significant cash receipts
included the property tax, state and local sales taxes and the state income tax.
The Village continued receiving the second installment of 2014 property taxes during
August. A total of $4,596,103 was received in the General Fund during the month.
Sales tax revenues for the month totaled $1,385,994. Of this amount, $1,271,281 was
generated from the 1% state portion while $114,713 was generated from the .25% home
rule portion. Sales taxes received in August are for May sales as there is a three-month lag
in getting this distribution from the state.
H:\ACCT\Treasurer's Report\2014\Monthly Cash Position Report - August 2014.docx
Monthly Financial Report — August 2015
September 11, 2015
Page 3
State income tax receipts for August totaled $403,230 and were for the month of May.
Receipts of this revenue source are now consistent with sales tax in that there is a three-
month lag in getting this distribution from the state.
Disbursements from the General Fund for August included payments to vendors of $1,162,840
and payments for employee wages and benefits of $1,312,982. Interfund transfers of $663,277
for health premiums and vehicle lease and maintenance payments were also made during
August. Other disbursements totaled $7,413.
Cash and cash equivalents at August 31 were $14,350,659, an increase of $3,075,735 from
July 31. There were no investments in the General Fund at August 31.
Statement of Investments (page 3)
This report provides a breakdown of investments by governmental and enterprise funds and
trust and agency funds. The report also provides a fund -by fund breakdown of the investments.
Government and Enterprise Funds - The investments for the governmental and agency funds
are made up solely of certificates of deposit. Certificates of deposit have maturities of between
253 and 283 days from date of purchase and are currently placed with several banks through
our financial advisor, PMA.
Return on the portfolio of CD's range from 25 to 34 basis points. The portfolio return remains
low on all types of investments available to municipalities (typically certificate of deposits,
money market accounts and short-term treasuries). A detailed listing of the CD's currently held
can be found in the table below.
Maturity Purchase Financial
Date Date Institution
FLOOD CONTROL CONSTRUCTION FUND (024
Irm anent CUSIP/
Des, iption FDIC # Net Yield Purch Price
09/15/15
01/05/15
Bank of the Ozarks, AR
Certificate of Deposit
110
0.262%
249,500.00
09/15/15
01/05/15
Onewest Bank, NA, CA
Certificate of Deposit
58978
0.310%
249,400.00
09/15/15
01/05/15
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
0.343%
249,300.00
10/15/15
01/05/15
Affiliated Bank. TX
Certificate of Deposit
34885
0.343%
249,300.00
10/15/15
01/05/15
Royal Business Bank, CA
Certificate of Deposit
58816
0.303%
150,000.00
1,646,000.00
TOTAL GOVERNMENTAL AND ENTERPRISE FUNDS
$ 1.646.000.00
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
H:\ACCT\Treasurer's Report\2014\Monthly Cash Position Report - August 2014.docx
Monthly Financial Report — August 2015
September 11, 2015
Page 4
fixed income investments for the two pension funds while Galliard and Mesirow manage the
balance of fixed income investments for these two funds. Each manager maintains a small
portion of their portfolio in cash to help facilitate liquidity and trading.
Investments in equities consist of mutual funds spread across various sectors (small, mid and
large -cap stocks) as well as investment philosophies (value, core and growth). The funds also
invest a small amount in international stocks. Each year the investment mix is evaluated for
optimal diversification to meet pension fund investment policy goals and objectives. Equity
investments held by the Police Pension Fund are managed by Sawyer Falduto Asset
Management. Below is a breakdown of how the pension fund portfolios are invested.
Maturity Purchase Financial
Date Date Institution
POLICE PENSION FUND (070)
Various Various Wells Fargo
Various Various Various
FIRE PENSION FUND (071)
Various 5/26/2015 Principal Life Insurance Company
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,366,251.34
Mutual Fund Investments
Various
Various
33,629,457.68
56,995,709.02
Group Annuity Contract
8-10810
Variable
2,538,034.66
Wells Fargo Investments
Various
Various
20,429,077.25
Mutual Fund Investments
Various
Various
34,284,090.45
s7?st ?m 'Ar
$ 114.246.911.38
Investment of the Village's pension funds is governed by an Investment Policy adopted by each
Pension Board. The investment policies for both the pension funds were last updated in 2011.
Conclusion
This cash position report is intended to provide a snapshot of the Village's cash position as of a
particular month end date. Maintaining strong cash balances allow the Village to weather
delays in receipt of revenues or cover unanticipated/unscheduled expenses. Please review the
information and contact me with any questions.
David O. Erb
Finance Director
H:\ACCT\Treasurer's Report\2014\Monthly Cash Position Report - August 2014.docx
VILLAGE OF MOUNT PROSPECT
Preliminary Cash and Investment Position Report - All Funds
For the Month Ended August 31, 2015
GOVERNMENTAL AND ENTERPRISE FUNDS
Cash receipts 1,837,970.47 1,837,970.47
Investment income (loss) 106,372.93 (2,149,325.16) (2,042,952.23)
Transfers from investments to cash 875,742.84 (875,742.84)
Transfers to investments from cash (665,964.00) 665,964.00
Interfund activity (46,858.04) (46,858.04)
Disbursements
Accounts payable (222,770.00) (222,770.00)
Payroll (626,610.65) (626,610.65)
Flex spending (9,705.32) (9,705.32)
Other (3,073.38) (3,073.38)
Balance at August 31, 2015 $ 3,950,020.98 $ 114,246,911.38 $ 118,196,932.36
* Assets are restricted in purpose and do not represent discretionary assets of the government.
1
Cash and Cash
Total Cash and
Equivalents
Investments
Investments
Balance at July 31, 2015
$ 45,739,621.63
$ 2,643,600.00
$ 48,383,221.63
Cash receipts
9,964,598.05
9,964,598.05
Investment income
2,507.17
1,246.39
3,753.56
Transfers from investments to cash
998,846.39
(998,846.39)
-
Transfers to investments from cash
-
-
-
Interfund activity
46,858.04
46,858.04
Disbursements:
Accounts payable
(4,458,453.31)
(4,458,453.31)
Payroll
(1,319,997.62)
(1,319,997.62)
Other
(7,396.67)
(7,396.67)
Balance at August 31, 2015
$ 50,966,583.68
$ 1,646,000.00
$ 52,612,583.68
TRUST AND AGENCY FUNDS "
Cash and Cash
Total Cash and
Equivalents
Investments
Investments
Balance at July 31, 2015
$ 2,704,916.13
$ 116,606,015.38
$ 119,310,931.51
Cash receipts 1,837,970.47 1,837,970.47
Investment income (loss) 106,372.93 (2,149,325.16) (2,042,952.23)
Transfers from investments to cash 875,742.84 (875,742.84)
Transfers to investments from cash (665,964.00) 665,964.00
Interfund activity (46,858.04) (46,858.04)
Disbursements
Accounts payable (222,770.00) (222,770.00)
Payroll (626,610.65) (626,610.65)
Flex spending (9,705.32) (9,705.32)
Other (3,073.38) (3,073.38)
Balance at August 31, 2015 $ 3,950,020.98 $ 114,246,911.38 $ 118,196,932.36
* Assets are restricted in purpose and do not represent discretionary assets of the government.
1
N
VILLAGE OF MOUNT PROSPECT
Summary of Cash Activity by Fund Type
For the Month Ended August 31, 2015
GOVERNMENTAL AND ENTERPRISE FUNDS TRUST AND AGENCY FUNDS'
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
GENERALFUND
FUNDS
FUNDS
FUNDS
FUNDS
SERVICE FUNDS
FUNDS
PENSIONS
FUNDS
TOTAL
CASH & CASH EQUIVALENTS
Beginning balance
$ 11,274,923.72
$ 3,700,366.83
$ 1,179,813.73
$ 14,156,093.45
$ 4,266,681 39
$ 11,161,742.51
$ 45,739,621.63
$ 1,539,891.11
$ 1,165,025-02
$ 48,444,537.76
Cash receipts
6,221,659.49
392,337.10
762,842.90
994,081-92
1,576,617.41
17,059.23
9,964,598.05
1,696,501.54
141,468.93
11,802,568-52
Investment income
587.48
101.87
16.18
795.15
275.31
731.18
2,507-17
106,256.35
116.58
108,880.10
Transfers from investments
-
-
-
998,846.39
-
-
998,846.39
875,742.84
-
1,874,589.23
Transfers to investments
-
-
-
-
-
-
-
(665,964-00)
-
(665,964.00)
Interfund
(663,277-44)
54,62321
-
(23,336.97)
(173,373-69)
852,222-93
46,858.04
(38,866.74)
• (7,991-30)
0-00
Disbursements - other
(7,413.10)
-
-
-
16.43
-
(7,396.67)
-
(3,073.38)
(10,470.05)
Disbursements - flexible spending
-
-
-
-
(9,705.32
(9,705.32)
Disbursements -payroll
(1,162,839.94)
(13,98411)
-
(98,464.14)
(44,709.43)
(1,319,997.62)
(626,610.65)
-
(1,946,608.27)
Disbursements -accounts payable
(1,312,981.68)
401,812.65)
(250.00)
(824,965.54)
(1,031,450.75)
(886,992.69)
4,458,453.31)
(154,085.00)
(68,685.00)
(4,681,223.31)
Ending balance
14,350,658.53
3,731,632.25
1,942,422.81
15,301.514-40
4,540,301 .96
11,100,053.73
50.966.583.68
2,732,865,45
1,217,155.53
54,916,604.66
INVESTMENTS
Certificates of deposit
-
-
-
1,646,000.00
-
1,646,000.00
-
-
1,646,000-00
Wells Fargo investments
-
-
-
-
-
43,795,328.59
-
43,795,328.59
Mutual fund investments
-
70,451,582.79
70.451,582.79
Total investments
1,646,000.00
1,646,000.00
114,246,911.38
115,892,911.38
TOTAL CASH AND INVESTMENTS
$ 14,350,658.53
$ 3,731,632.25
$ 1,942,422.81
$ 16,947,514.40
$ 4,540,301.96
$ 11,100,053.73
S 52,612,583.68
$116,979,776.83
$ 1,217,155.53
$170,809,516.04
Assets are restricted in purpose and do not represent discretionary assets of the government.
VILLAGE OF MOUNT PROSPECT
STATEMENT OF INVESTMENTS
As of August 31, 2015
TOTAL GOVERNMENTAL AND ENTERPRISE FUNDS
CUSIP/
FDIC #
Net Yield
GOVERNMENTAL AND ENTERPRISE FUNDS
Maturity
Purchase
Financial
Investment
Date
Date
Institution
Description
FLOOD CONTROL CONSTRUCTION FUND (024)
34885
09/15/15
01/05/15
Bank of the Ozarks, AR
Certificate of Deposit
09/15/15
01/05/15
Onewest Bank, NA, CA
Certificate of Deposit
09/15/15
01/05/15
IDB Bank - NY, NY
Certificate of Deposit
09/15/15
01/05/15
Enerbank USA, UT
Certificate of Deposit
10/15/15
01/05/15
United Texas Bank, TX
Certificate of Deposit
10/15/15
01/05/15
Affiliated Bank. TX
Certificate of Deposit
10/15/15
01/05/15
Royal Business Bank, CA
Certificate of Deposit
TOTAL GOVERNMENTAL AND ENTERPRISE FUNDS
CUSIP/
FDIC #
Net Yield
Ito
0.262%
58978
0,310%
19977
0.243%
57293
0,250%
26626
0.343%
34885
0.343%
58816
0.303%
TOTAL TRUST AND AGENCY FUND INVESTMENTS
* Assets are restricted in purpose and do not represent discretionary assets of the government.
249,500.00
249,400.00
249,200.00
249,300.00
249,300.00
249,300.00
150,000.00
1,646,000.00
$ 1,646,000.00
Market
$ 23,366,251.34
33,629,457 68
56,995,709.02
2,538,034.66
20,429,077.25
34,284,090.45
57,251,202.36
$ 114,246,911.38
3
TRUST AND AGENCY FUNDS
Maturity
Purchase
Financial
Investment
CUSIP/
Interest
Date
Date
Institution
Description
Acct #
Rate %
POLICE PENSION FUND (070)
Various
Various
Wells Fargo
Wells Fargo Investments
Various
Various
Various
Various
Various
Mutual Fund Investments
Various
Various
FIRE PENSION FUND (071)
Various
5/26/2015
Principal Life Insurance Company
Group Annuity Contract
8-10810
Variable
Various
Various
Wells Fargo
Wells Fargo Investments
Various
Various
Various
Various
Various
Mutual Fund Investments
Various
Various
TOTAL TRUST AND AGENCY FUND INVESTMENTS
* Assets are restricted in purpose and do not represent discretionary assets of the government.
249,500.00
249,400.00
249,200.00
249,300.00
249,300.00
249,300.00
150,000.00
1,646,000.00
$ 1,646,000.00
Market
$ 23,366,251.34
33,629,457 68
56,995,709.02
2,538,034.66
20,429,077.25
34,284,090.45
57,251,202.36
$ 114,246,911.38
3
VILLAGE OF MOUNT PROSPECT
BUDGET REVENUE
EXPENDITURE SUMMARIES
August 01— August 31, 2015
Account Classification
Fund 001 - General Fund
REVENUE
Property Taxes
Other Taxes
Licenses, Permits & Fees
Intergovernmental Revenue
Charges For Services
Fines & Forfeits
Investment Income
Reimbursements
Other Revenue
Other Financing Sources
Revenue Budget by Account Classification
Report
Through 08/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
15,427,500.00
.00
15,427,500.00
4,596,102.61
.00
14,927,821.68
499,678.32
97
14,175,206.91
7,457,566.00
.00
7,457,566.00
763,656.20
.00
4,490,530.47
2,967,035.53
60
4,150,684.38
1,256,000.00
.00
1,256,000.00
357,706.50
.00
1,159,168.99
96,831.01
92
1,132,387.81
20,123,200.00
2,404.00
20,125,604.00
1,803,483.03
.00
10,225,123.12
9,900,480.88
51
9,052,844.55
1,633,223.00
.00
1,633,223.00
139,871.61
.00
1,047,166.13
586,056.87
64
981,438.88
439,000.00
.00
439,000.00
40,940.94
.00
318,255.93
120,744.07
72
310,438.77
5,918.00
.00
5,918.00
703.78
.00
6,324.95
(406.95)
107
3,076.64
220,000.00
.A0
220,000.00
23,629.15
.00
120,797.32
99,202.68
55
282,088.25
236,000.00
.00
236,000.00
25,341.94
.00
199,053.25
36,946.75
84
204,253.78
20,000.00
.00
20,000.00
.00
.00
20,000.00
.00
100
.00
REVENUE TOTALS $46,818,407.00 $2,404.00 $46,820,811.00 $7,751,435.76
Fund 001 - General Fund Totals $46,818,407.00 $2,404.00 $46,820,811.00 $7,751,435.76
1
$0.00 $32,514,241.84 $14,306,569.16 69% $30,292,419.97
$0.00 $32,514,241.84 $14,306,569.16 $30,292,419.97
Account Classification
Fund 002 - Debt Service Fund
REVENUE
Revenue Budget by Account Classification
Report
Through 08/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
Property Taxes
2,254,000.00
,00
2,254,000.00
678,566.60
.00
2,199,202.18
54,797.82
98
2,173,180.05
Other Taxes
988,508.00
.00
988,508.00
84,276.30
.00
373,114.55
615,393.45
38
397,700.25
Intergovernmental Revenue
42,773.00
1,568,856.00
1,611,629.00
.00
.00
228,960.35
1,382,668.65
14
21,927.64
Investment Income
100.00
.00
100.00
1&18
.00
81.98
18.02
82
40.40
Other Revenue
.00
.00
.00
.AO
.00
.00
.00
+++
.00
Other Financing Sources
.00
.00
.00
.00
.00
.00
.00
+++
3,231.19
REVENUE TOTALS
$3,285,381.00
$1,568,856.00
$4,854,237.00
$762,859.08
$0.00
$2,801,359.06
$2,052,877.94
58%
$2,596,079.53
Fund 002 - Debt Service Fund Totals
$3,285,381.00
$1,568,856.00
$4,854,237.00
$762,859.08
$0.00
$2,801,359.06
$2,052,877.94
$2,596,079.53
2
Revenue Budget by Account Classification
Report
Through 08/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 Recd Prior Year YTD
Fund 020 - Capital Improvement Fund
1,246,000.00
REVENUE
.00
Other Taxes
1,246,000.00
Intergovernmental Revenue
.00
Investment Income
1,000.00
Reimbursements
.00
Other Revenue
20,000.00
Other Financing Sources
.00
.00
REVENUE TOTALS $1,267,000.00
Fund 020 - Capital Improvement Fund Totals $1,267,000.00
AO
1,246,000.00
106,190.22
.00
470,133.57
775,866.43
38
469,019.85
.00
.00
.00
.00
47,273.72
(47,273.72)
+++
.00
.00
1,000.00
66.91
.00
275.44
724.56
28
362.33
.00
.00
.00
.00
.00
.00
+++
.00
.00
20,000.00
29,400.00
.00
47,520.00
(27,520.00)
238
140,181.00
.00
.00
.00
,00
.00
.00
+++
.00
$0.00 $1,267,000.00 $135,657.13 $0.00 $565,202.73 $701,797.27 45% $609,563.18
$0.00 $1,267,000.00 $135,657.13
$0.00 $565,202.73 $701,797.27 $609,563.18
Revenue Budget by Account Classification
Report
Through 08/31/15
Prior Fiscal Year Activity Included
Summary Listing
4
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD
0!o 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
625,276.41
.00
2,277,671.77
431,328.23
84
2,236,137.84
Investment Income
500.00
.00
500.00
48.21
'00
198.60
301.40
40
231.99
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
AO
+++
.00
REVENUE TOTALS
$2,709,500.00
$0.00
$2,709,500.00
$625,324.62
$0.00
$2,277,870.37
$431,629.63
84%
$2,236,369.83
Fund 022 - Downtown Redevelopment Construct Totals
$2,709,500.00
$0.00
$2,709,500.00
$625,324.62
$0.00
$2,277,870.37
$431,629.63
$2,236,369.83
4
Revenue Budget by Account Classification
Report
Through 08/31/15
Prior Fiscal Year Activity Included
Summary Listing
5
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
171,027.35
.00
901,102.75
1,154,897.25
44
914,546.52
Licenses, Permits & Fees
1,540,000-00
.00
1,540,000.00
23,124.25
.00
1,422,216.75
117,783.25
92
979,558.77
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
151.86
.00
1,069.58
(969.58)
1070
3,792.33
Reimbursements
'00
.00
.00
.00
.00
.00
.00
...
.00
Other Revenue
6,000.00
.00
6,000.00
8,397.28
.00
45,672.32
(39,672.32)
761
70,593.83
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
$202,700.74
$0.00
$2,370,061.40
$1,232,038.60
66%
$8,509,192.27
Fund 023 - Street Improvement Construc Fund Totals
$3,602,100.00
$0.00
$3,602,100.00
$202,700.74
$0.00
$2,370,061.40
$1,232,038.60
$8,509,192.27
5
Account Classification
Revenue Budget by Account Classification
Report
Through 08/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 024 - Flood Control Construction Fund
REVENUE
Other Taxes
357,000.00
.00
357,000.00
30,436.41
.00
134,750.44
222,249.56
38
108,961.67
Intergovernmental Revenue
.00
.00
.00
.00
.00
.00
.00
+++
.00
Charges For Services
.00
.00
.00
.00
.00
25,997.00
(25,997.00)
...
.00
Investment Income
1,100.00
.00
1,100.00
1,030.77
,00
9,869.92
(8,769.92)
897
8,633,20
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
$31,467.18
$0.00
$170,617.36
$187,482.64
48%
$117,594.87
Fund 024 - Flood Control Construction Fund Totals
$358,100.00
$0.00
$358,100.00
$31,467.18
$0.00
$170,617.36
$187,482.64
$117,594.87
A
Account Classification
Fund 040 - Refuse Disposal Fund
REVENUE
Revenue Budget by Account Classification
Repo
Through #:
Summary Listi)n
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD
Property Taxes
.00
.00
.00
.00
.00
.00
.00
+++
327,732.94
Charges For Services
3,549,000.00
.00
3,549,000.00
237,354.67
,00
2,235,969.62
1,313,030.38
63
1,853,328.21
Fines & Forfeits
24,000.00
.00
24,000.00
1,733.39
.00
23,802.71
197.29
99
18,712.10
Investment Income
500.00
.00
500.00
31.93
.00
138.40
361.60
28
450.79
Reimbursements
1,000.00
,00
1,000.00
720.43
.00
3,415.54
(2,415.54)
342
294.96
Other Revenue
371,500.00
.00
371,500.00
34,735.19
.00
269,452.10
102,047.90
73
231,166.44
REVENUE TOTALS
$3,946,000.00
$0.00
$3,946,000.00
$274,575.61
$0.00
$2,532,778.37
$1,413,221.63
64%
$2,431,685.44
Fund 040 - Refuse Disposal Fund Totals
$3,946,000.00
$0.00
$3,946,000.00
$274,575.61
$0.00
$2,532,778.37
$1,413,221.63
$2,431,685.44
7
Account Classification
Fund 041 - Motor Fuel Tax Fund
REVENUE
Intergovernmental Revenue
Investment Income
Reimbursements
REVENUE TOTALS
Fund 041 - Motor Fuel Tax Fund Totals
Revenue Budget by Account Classification
Report
Through 08/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD 0% used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
1,320,000.00
.00
1,320,000.00
.00
-00
596,472.32
723,527.68
45 1,268,321.29
200.00
.00
200.00
40.67
.00
165.12
34.88
83 21.46
11,000.00
.00
11,000.00
.00
.00
7,613.15
3,386.85
69 11,704.04
$1,331,200.00
$0.00
$1,331,200.00
$40.67
$0.00
$604,250.59
$726,949.41
45% $1,280,046.79
$1,331,200.00
$0.00
$1,331,200.00
$40.67
$0.00
$604,250.59
$726,949.41
$1,280,046.79
E.
Account Classification
Fund 042 - Cmmty Development Block Grant
REVENUE
Intergovernmental Revenue
Investment Income
Other Revenue
REVENUE TOTALS
Fund 042 - Cmmty Development Block Grant Totals
Revenue Budget by Account Classification
Report
Through 08/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
339,264.00
00
339,264.00
,00
.00
.00
339,264.00 0
21,392.87
.00
.00
.00
..00
.00
.00
.00 +++
.00
80,000.00
.00
80,000.00
.00
.00
59,69350
20,306.50 75
128,858.12
$419,264.00
$0.00
$419,264.00
$0.00
$0.00
$59,693.50
$359,570.50 14%
$150,250.99
$419,264.00
$0.00
$419,264.00
$0.00
$0.00
$59,693.50
$359,570.50
$150,250.99
Account Classification
Fund 043 - Asset Seizure Fund
REVENUE
Revenue Budget by Account Classification
Report
Through 08/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
Fines & Forfeits 2,000.00
.00
2,000.00
427.05
.00
10,182.09
(8,182.09) 509
43,321.06
Investment Income 100.00
.00
100.00
3.10
.00
11.68
88.32 12
9.95
REVENUE TOTALS $2,100.00
$0.00
$2,100.00
$430.15
$0.00
$10,193.77
($8,093.77) 485%
$43,331.01
Fund 043 - Asset Seizure Fund Totals $2,100.00
$0.00
$2,100.00
$430.15
$0.00
$10,193.77
($8,093.77)
$43,331.01
10
Account Classification
Revenue Budget by Account Classification
Adopted Budget Amended Current Month YTD
Budget Amendments Budget Transactions Encumbrances
1
Through 08/31/15
Prior Fiscal Year Activity Included
Summary Listing
YTD Budget - YTD % used/
Transactions Transactions Rec'd Prior Year YTD
Fund 044 - Federal Equitable Share Funds
REVENUE
Fines & Forfeits
100.00
.00
100.00
.00
.00
.00
100.00 0
24,637.80
Investment Income
100.00
,00
100.00
=84
.00
7.18
92.82 7
13.72
REVENUE TOTALS
$200.00
$0.00
$200.00
$0.84
$0.00
$7.18
$192.82 4%
$24,651.52
Fund 044 - Federal Equitable Share Funds Totals
$200.00
$0.00
$200.00
$0.84
$0.00
$7.18
$192.82
$24,651.52
11
Account Classification
Fund 045 - DUI Fine Fund
REVENUE
Fines & Forfeits
Investment Income
Revenue Budget by Account Classification
Report
Through 08/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 3,620.02
100.00 .00 100.00 4.65
REVENUE TOTALS $20,100.00
Fund 045 - DUI Fine Fund Totals $20,100.00
,00 21,204.15 (1,204.15) 106 22,224.22
00 20.07 79.93 20 27.69
$0.00 $20,100.00 $3,624.67 $0.00 $21,224.22 ($1,124.22) 106% $22,251.91
$0.00 $20,100.00 $3,624.67 $0.00 $21,224.22 ($1,124.22)
12
$22,251.91
Account Classification
Fund 046 - Foreign Fire Tax Board Fund
REVENUE
Other Taxes
Investment Income
Other Revenue
Other Financing Sources
REVENUE TOTALS
Fund 046 - Foreign Fire Tax Board Fund Totals
Revenue Budget by Account Classification
Report
Through 08/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
70,000.00
.00
70,000.00
34,727.93
.00
76,822.73
(6,822.73)
110
53,600.52
loozoo
,00
100,00
13.02
.00
5159
47.41
53
77.03
.00
.00
.00
.00
.00
.00
.00
...
.00
,00
,00
.00
.00
.00
.00
.00
...
.00
$70,100,00
$0.00
$70,100.00
$34,740.95
$0.00
$76,875.32
($6,775.32)
110%
$53,677.55
$70,100.00
$0.00
$70,100.00
$34,740.95
$0.00
$76,875.32
($6,775.32)
$53,677.55
13
Account Classification
Fund 048 - Business District Fund
REVENUE
Other Taxes
Investment Income
Other Financing Sources
REVENUE TOTALS
Fund 048 - Business District Fund Totals
Revenue Budget by Account Classification
Adopted Budget Amended Current Month YTD
Budget Amendments Budget Transactions Encumbrances
Through 08/31/15
Prior Fiscal Year Activity Included
Summary Listing
YTD Budget - YTD % used/
Transactions Transactions Rec'd Prior Year YTD
1,021,000.00
.00
1,021,000.00
100,767.94
.00
571,686.61
449,313.39 56
509,199.97
.00
.00
.00
7.66
.00
51.85
(51.85) ...
21.05
,00
.00
.00
.00
.00
.00
.00 +++
00
$1,021,000.00
$0.00
$1,021,000.00
$100,775.60
$0.00
$571,738.46
$449,261.54 56%
$509,221.02
$1,021,000.00
$0.00
$1,021,000.00
$100,775.60
$0.00
$571,738.46
$449,261.54
$509,221.02
14
Revenue Budget by Account Classification
Report
Through 08/31/15
Prior Fiscal Year Activity Included
Summary Listing
Account Classification
Adopted
Budget
Budget
Amendments
Amended
Budget
Current Month
Transactions
YTD
Encumbrances
YTD
Transactions
Budget - YTD
Transactions
% used/
Rec'd
Prior Year YTD
Fund 050 - Water and Sewer Fund
REVENUE
Property Taxes
1,530,000.00
.00
1,530,000.00
(2,552.58)
.00
(5,557.11)
1,535,557.11
0
1,474,317.45
Licenses, Permits & Fees
18,000.00
.00
18,000.00
930.00
.00
12,860.00
5,140.00
71
12,080.00
Charges For Services
13,789,000.00
,00
13,789,000.00
1,191,688.50
.00
8,165,294.08
5,623,705.92
59
7,685,634.62
Fines & Forfeits
118,000.00
,00
118,000.00
8,889.91
.00
80,257.07
37,742.93
68
74,492.67
Investment Income
2,100.00
.00
2,100.00
262.91
.00
1,086.82
1,013.18
52
1,155.25
Reimbursements
500.00
.00
500.00
.00
.00
.00
500.00
0
(131.00)
Other Revenue
72,000.00
.00
72,000.00
4,760.00
.00
51,931.04
20,068.96
72
41,277.16
Other Financing Sources
.00
.00
.00
.00
.00
.00
.00
+++
.00
REVENUE TOTALS
$15,529,600.00
$0.00
$15,529,600.00
$1,203,978.74
$0.00
$8,305,871.90
$7,223,728.10
53%
$9,288,826.15
Fund 050 - Water and Sewer Fund Totals
$15,529,600.00
$0.00
$15,529,600.00
$1,203,978.74
$0.00
$8,305,871.90
$7,223,728.10
$9,288,826.15
15
Account Classification
Fund 051 - Village Parking System Fund
REVENUE
Other Taxes
Charges For Services
Investment Income
Other Revenue
Other Financing Sources
Revenue Budget by Account Classification
Report
Through 08/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
.00
.00
.00
.00
.00
.00
+++
3,764.21
124,000.00
,00
124,000.00
9,759.25
.00
90,147.58
33,852.42
73
86,967.32
100.00
,00
100.00
12.40
.00
48.96
51.04
49
64.74
6,600.00
.00
6,600.00
550.00
.00
4,455.00
2,145.00
68
4,400.00
.00
,00
.00
.00
.00
.00
.00
+++
.00
REVENUE TOTALS $130,700.00 $0.00 $130,700.00 $10,321.65 $0.00 $94,651.54 $36,048.46 72% $95,196.27
Fund 051 - Village Parking System Fund Totals $130,700.00 $0.00 $130,700.00 $10,321.65 $0.00 $94,651.54 $36,048.46 $95,196.27
16
Account Classification
Fund 052 - Parking System Revenue Fund
REVENUE
Other Taxes
Intergovernmental Revenue
Charges For Services
Investment Income
Other Revenue
Other Financing Sources
REVENUE TOTALS
Fund 052 - Parking System Revenue Fund Totals
Revenue Budget by Account Classification
Report
Through 08/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
100,000.00
.00
100,000.00
8,522.49
.00
37,731.43
62,268.57
38
33,877.85
.00
.00
00
.00
.00
.00
.00
...
.00
119,000.00
.00
119,000.00
10,190.65
.00
79,756.43
39,243.57
67
78,321,62
.00
.00
.00
.00
.00
.00
.00
+++
.00
.00
,00
,00
.00
.00
.00
.00
+++
.00
.00
.00
<00
.00
.00
.00
.00
+++
.00
$219,000.00
$0.00
$219,000.00
$18,713.14
$0.00
$117,487.86
$101,512.14
54%
$112,199.47
$219,000.00
$0.00
$219,000.00
$18,713.14
$0.00
$117,487.86
$101,512.14
$112,199.47
17
Account Classification
Fund 060 - Vehicle Maintenance Fund
REVENUE
Charges For Services
Investment Income
Other Revenue
Revenue Budget by Account Classification
Report
Through 08/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,157,889.00
600.00
.00
REVENUE TOTALS $2,158,489.00
Fund 060 - Vehicle Maintenance Fund Totals $2,158,489.00
.00 2,157,889.00
179,824.09
.00
1,438,592.72
719,296.28
67 1,425,544.56
.00 600.00
38.18
.00
237.60
362.40
40 373.83
.00 .00
362.86
.00
1,123.70
(1,123.70)
+++ 525.88
$0.00 $2,158,489.00
$180,225.13
$0.00
$1,439,954.02
$718,534.98
67% $1,426,444.27
$0.00 $2,158,489.00 $180,225.13
18
$0.00 $1,439,954.02 $718,534.98 $1,426,444.27
Account Classification
Fund 061 - Vehicle Replacement Fund
REVENUE
Charges For Services
Fines & Forfeits
Investment Income
Other Revenue
Other Financing Sources
REVENUE TOTALS
Fund 061 - Vehicle Replacement Fund Totals
Revenue Budget by Account Classification
Report
Through 08/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,380,500.00
.00
1,380,500.00
115,041.68
=00
920,333.44
460,166.56
67
897,533.44
11,150.00
,00
11,150.00
1,260.00
.00
6,879.00
4,271.00
62
8,997.72
7,200.00
.00
7,200.00
511.01
,00
2,886.96
4,313.04
40
4,693.92
.00
.00
.00
.00
.00
.00
.00
+++
.00
.00
.00
.00
.00
.00
9,002.00
(9,002.00)
+++
42,333.87
$1,398,850.00
$0.00
$1,398,850.00
$116,812.69
$0.00
$939,101.40
$459,748.60
67%
$953,558.95
$1,398,850.00
$0.00
$1,398,850.00
$116,812.69
$0.00
$939,101.40
$459,748.60
$953,558.95
19
Account Classification
Revenue Budget by Account Classification
Report
Through 08/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 062 - Computer Replacement Fund
REVENUE
Charges For Services
272,307.00
.00
272,307.00
22,692.25
.00
181,538.00
90,769.00 67
15,392.00
Investment Income
1,000.00
.00
1,000.00
50.11
.00
324.63
675.37 32
497.84
Other Financing Sources
.00
.00
.00
.00
'00
.00
.00 +++
.00
REVENUE TOTALS
$273,307.00
$0.00
$273,307.00
$22,742.36
$0.00
$181,862.63
$91,444.37 67%
$15,889.84
Fund 062 - Computer Replacement Fund Totals
$273,307.00
$0.00
$273,307.00
$22,742.36
$0.00
$181,862.63
$91,444.37
$15,889.84
20
Account Classification
Fund 063 - Risk Management Fund
REVENUE
Charges For Services
Investment Income
Reimbursements
Other Revenue
REVENUE TOTALS
Fund 063 - Risk Management Fund Totals
Revenue Budget by Account Classification
Report
Through 08/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
6,513,826.00
100
6,513,826.00
471,064.17
.00
4,278,855.63
2,234,970.37
66
4,324,679.28
3,000.00
.00
3,000.00
131.88
.00
809.85
2,190.15
27
1,517.68
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00
0
.00
1,463,700.00
.00
1,463,700.00
94,096.69
,00
869,735.33
593,964.67
59
888,999.21
$7,981,526.00
$0.00
$7,981,526.00
$565,292.74
$0.00
$5,149,400.81
$2,832,125.19
65%
$5,215,196.17
$7,981,526.00
$0.00
$7,981,526.00
$565,292.74
$0.00
$5,149,400.81
$2,832,125.19
$5,215,196.17
21
Account Classification
Fund 070 - Police Pension Fund
REVENUE
Revenue Budget by Account Classification
Report
Through 08/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
(2,045,192.09)
.00
(269,367.05)
4,652,167.05
-6 3,067,496.95
Other Revenue 3,743,175.00
.00
3,743,175.00
913,502.98
.00
3,308,856.84
434,318.16
88 3,354,755.83
REVENUE TOTALS $8,125,975.00
$0.00
$8,125,975.00
($1,131,689.11)
$0.00
$3,039,489.79
$5,086,485.21
37% $6,422,252.78
Fund 070 - Police Pension Fund Totals $8,125,975.00
$0.00
$8,125,975.00
($1,131,689.11)
$0.00
$3,039,489.79
$5,086,485.21
$6,422,252.78
22
REVENUE TOTALS
$7,401,625.00
Revenue Budget
by Account
Classification
$0.00
$5,045,606.91
$2,356,018.09
68% $5,407,241.72
Report
$7,401,625.00
$0.00
$7,401,625.00
$781,392.63
Through 08/31/15
$5,045,606.91
$2,356,018.09
$5,407,241.72
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget Amended Current Month
YTD YTD
Budget - YTD % used/
Account Classification
Budget
Amendments Budget Transactions
Encumbrances Transactions
Transactions Rec'd Prior Year YTD
Fund 071 - Fire Pension Fund
$108,069,524.00
—
$109,640,784.00
$11,691,422.97
REVENUE
$68,889,541.03
$40,751,242.97
$77,813,141.50
Investment Income
4,250,500.00
.00 4,250,500.00 (1,605.93)
.00 2,227,265.60
2,023,234.40 52 2,619,737.08
Other Revenue
3,151,125.00
.00 3,151,125.00 782,998.56
.00 2,818,341.31
332,783.69 89 2,787,504.64
REVENUE TOTALS
$7,401,625.00
$0.00
$7,401,625.00
$781,392.63
$0.00
$5,045,606.91
$2,356,018.09
68% $5,407,241.72
Fund 071 - Fire Pension Fund Totals
$7,401,625.00
$0.00
$7,401,625.00
$781,392.63
$0.00
$5,045,606.91
$2,356,018.09
$5,407,241.72
Grand Totals
$108,069,524.00
$1,571,260.00
$109,640,784.00
$11,691,422.97
$0.00
$68,889,541.03
$40,751,242.97
$77,813,141.50
23
Expense Budget by Account Classification
Report
Through 08/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec°d Prior Year YTD
Fund 001 - General Fund
EXPENSE
Personal Services, Scheduled Salaries & Wages
24,232,037.00
.00
24,232,037.00
1,800,301.40
.00
15,158,498.13
9,073,538.87
63
15,541,133.16
Employee Benefits
12,235,287.00
.00
12,235,287.00
2,116,645.49
.00
9,777,368.44
2,457,918.56
80
10,042,044.22
Other Employee Costs
440,543.00
(8,860.00)
431,683.00
27,801.35
11,026.55
271,257.22
149,399.23
65
214,405.36
Pension Benefits
46,456.00
.00
46,456.00
3,871.28
.00
30,970.24
15,485.76
67
30,866.88
Contractual Services
7,528,869.00
9,578.00
7,538,447.00
582,317.79
414,159.50
4,601,224.04
2,523,063.46
67
4,834,953.21
Utilities
271,939.00
.00
271,939.00
16,475.55
.00
101,590.05
170,348.95
37
115,093.03
Insurance
415,398.00
.00
415,398.00
34,586.08
.00
276,756.95
138,641.05
67
233,700.13
Commodities & Supplies
641,996.00
8,883.00
650,879.00
27,864.05
26,021.32
319,988.14
304,869.54
53
351,840.26
Other Expenditures
11,140.00
.00
11,140.00
.00
.00
.00
11,140.00
0
22,373.53
Building Improvements
10,200.00
.00
10,200.00
.00
.00
6,553.03
3,646.97
64
1,781.90
Office Equipment
33,520.00
17,400.00
50,920.00
105.18
7,187.10
4,960.90
38,772.00
24
7,606.36
Other Equipment
184,199.00
10,815.00
195,014.00
2,434.72
42,100.95
87,954.26
64,958.79
67
94,858.47
Distribution Systems
100,000.00
.00
100,000.00
.00
45,389.24
54,610.31
.45
100
.00
Infrastructure
666,823.00
.00
666,823.00
14,663.54
159,126.36
150,995.19
356,701.45
47
253,654.94
Interfund Transfers
.00
.00
.00
.00
.00
.00
.00
+++
.00
EXPENSE TOTALS
$46,818,407.00
$37,816.00
$46,856,223.00
$4,627,066.43
$705,011.02
$30,842,726.90
$15,308,485.08
67%
$31,744,311.45
Fund 001 - General Fund Totals
$46,818,407.00
$37,816.00
$46,856,223.00
$4,627,066.43
$705,011.02
$30,842,726.90
$15,308,485.08
$31,744,311.45
1
Account Classification
Fund 002 - Debt Service Fund
EXPENSE
Expense Budget by Account Classification
Report
Through 08/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
88,848.45
2,960,064.55
3
270,780.49
Interest Expense
1,382,571.00
413,356.00
1,795,927.00
.00
,00
898,571.26
897,355.74
50
766,300.74
Bank & Fiscal Fees
2,312.00
500.00
2,812.00
250.00
.00
3,287.14
(475.14)
117
1,686.20
Interfund Transfers
.00
.00
.00
.00
.00
.00
.00
+++
.00
Other Financing Uses
.00
.00
.00
AO
.00
.00
.00
+++
.00
EXPENSE TOTALS $3,278,796.00
$1,568,856.00
$4,847,652.00
$250.00
$0.00
$990,706.85
$3,856,945.15
20%
$1,038,767.43
Fund 002 - Debt Service Fund Totals $3,278,796.00
$1,568,856.00
$4,847,652.00
$250.00
$0.00
$990,706.85
$3,856,945.15
$1,038,767.43
2
Account Classification
Expense Budget by Account Classification
Report
Through 08/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 020 - Capital Improvement Fund
EXPENSE
Contractual Services
.00
.00
.00
.00
.00
.00
.00
+++
.00
Other Expenditures
.00
.00
.00
.00
.00
.00
.00
+++
.00
Land Improvements
350,000.00
236,250.00
586,250.00
33,793.99
405,540.74
35,833.39
144,875.87
75
.00
Building Improvements
896,000.00
502,440.00
1,398,440.00
29,058.56
142,868.54
581,298.33
674,273.13
52
165,904.89
Office Equipment
.00
.00
.00
.00
.00
.00
.00
+++
.00
Motor Equipment
.00
.00
.00
.00
.00
.00
.00
+++
.00
Other Equipment
486,747.00
52,118.00
538,865.00
16,347.71
72,750.67
141,834.72
324,279.61
40
169,975.24
Infrastructure
503,000.00
284,861.00
787,861.00
25,786.90
248,356.88
100,483.77
439,020.35
44
29,149.13
Interfund Transfers
.00
.00
.00
.00
.00
.00
.00
+++
.00
EXPENSE TOTALS
$2,235,747.00
$1,075,669.00
$3,311,416.00
$104,987.16
$869,516.83
$859,450.21
$1,582,448.96
52%
$365,029.26
Fund 020 - Capital Improvement Fund Totals
$2,235,747.00
$1,075,669.00
$3,311,416.00
$104,987.16
$869,516.83
$859,450.21
$1,582,448.96
$365,029.26
Account Classification
Fund 022 - Downtown Redevelopment Construct
EXPENSE
Contractual Services
Utilities
Other Expenditures
Infrastructure
Bond Principal
Interest Expense
Interfund Transfers
EXPENSE TOTALS
Fund 022 -Downtown Redevelopment Construct Totals
Expense Budget by Account Classification
Report
Through 08/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
109,201.00
.00
109,201.00
15,542.17
30,186.66
96,383.06
(17,368.72)
116
57,201.90
.00
.00
.00
.00
.00
.00
.00
+++
.00
3,306,969.00
.00
3,306,969.00
42,605.41
,00
111,738.93
3,195,230.07
3
83,223.00
342,285.00
3,675,00
345,960.00
.00
332,042.99
.00
13,917.01
96
16,775.75
.00
.00
.00
.00
.00
.00
.00
+++
.00
.00
.00
.00
.00
,00
.00
.00
+++
.00
.00
..00
.00
.00
00
.00
.00
+++
.00
$3,758,455.00
$3,675.00
$3,762,130.00
$58,147.58
$362,229.65
$208,121.99
$3,191,778.36
15%
$157,200.65
$3,758,455.00
$31675.00
$3,762,130.00
$58,147.58
$362,229.65
$208,121.99
$3,191,778.36
$157,200.65
4
Account Classification
Fund 023 - Street Improvement Construc Fund
EXPENSE
Contractual Services
Other Expenditures
Land Improvements
Infrastructure
Interfund Transfers
EXPENSE TOTALS
Fund 023 - Street Improvement Construc Fund Totals
Expense Budget by Account Classification
Report
Through 08/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
107,000.00
.00
107,000.00
75,000.00
9,786.00
80,130.00
17,084.00
84
43,293.75
.00
.00
.00
,00
,00
.00
.00
+++
.00
.00
.00
.00
.00
00
.00
.00
+++
.00
4,715,000.00
2,041,886.00
6,756,886.00
621,604.50
2,275,230.66
3,757,617.89
724,037.45
89
6,535,427.31
.00
.00
.00
,00
.00
.00
.00
...
.00
$4,822,000.00
$2,041,886.00
$6,863,886.00
$696,604.50
$2,285,016.66
$3,837,747.89
$741,121.45
89%
$6,578,721.06
$4,822,000.00
$2,041,886.00
$6,863,886.00
$696,604.50
$2,285,016.66
$3,837,747.89
$741,121.45
$6,578,721.06
5
Account Classification
Expense Budget by Account Classification
Report
Through 08/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 024 - Flood Control Construction Fund
EXPENSE
Contractual Services
12,000.00
.00
12,000.00
„00
.00
.00
12,000.00
0
.00
Utilities
2,300.00
.00
2,300.00
167.95
.00
1,513.57
786.43
66
915.87
Commodities & Supplies
5,000.00
.00
5,000.00
.00
.00
.00
5,000.00
0
.00
Other Expenditures
5,100.00
.00
5,100.00
.00
.00
.00
5,100.00
0
.00
Other Equipment
.00
.00
.00
<00
.00
.00
.00
...
,00
Distribution Systems
.00
.00
.00
.00
.00
.00
.00
+++
.00
Infrastructure
9,779,960.00
868,591.00
10,648,551.00
446,568.52
6,985,800.75
2,430,177.71
1,232,572,54
88
323,180.48
EXPENSE TOTALS
$9,804,360.00
$868,591.00
$10,672,951.00
$446,736.47
$6,985,800.75
$2,431,691.28
$1,255,458.97
88%
$324,096.35
Fund 024 - Flood Control Construction Fund Totals
$9,804,360.00
$868,591.00
$10,672,951.00
$446,736.47
$6,985,800.75
$2,431,691.28
$1,255,458.97
$324,096.35
iwm Expense Budget by Account Classification
Report
Through 08/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Fund 040 - Refuse Disposal Fund
EXPENSE
Personal Services, Scheduled Salaries & Wages
236,644.00
.00
236,644.00
18,127.93
.00
158,393.49
78,250.51
67
162,402.87
Employee Benefits
110,436.00
.00
110,436.00
8,553.23
.00
73,693.83
36,742.17
67
71,964.15
Other Employee Costs
1,248.00
.00
1,248.00
.00
.00
.00
1,248.00
0
1,224.00
Contractual Services
4,294,934.00
4,742.00
4,299,676.00
323,409.42
9,200.00
2,570,434.26
1,720,041.74
60
2,571,327.21
Utilities
447.00
.00
447.00
14.64
.00
167.18
279.82
37
190.57
Insurance
31,809.00
.00
31,809.00
2,650.75
.00
21,206.00
10,603.00
67
19,093.36
Commodities & Supplies
38,446.00
.00
38,446.00
4,784.26
.00
29,797.54
8,648.46
78
13,517.24
EXPENSE TOTALS
$4,713,964.00
$4,742.00
$4,718,706.00
$357,540.23
$9,200.00
$2,853,692.30
$1,855,813.70
61%
$2,839,719.40
Fund 040 - Refuse Disposal Fund Totals
$4,713,964.00
$4,742.00
$4,718,706.00
$357,540.23
$9,200.00
$2,853,692.30
$1,855,813.70
$2,839,719.40
7
Account Classification
Expense Budget by Account Classification
Report
Through 08/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 041 - Motor Fuel Tax Fund
EXPENSE
Contractual Services
284,686.00
.00
284,686.00
64,480.20
16,192.98
158,491.14
110,001.88
61
187,679.86
Utilities
156,060.00
.00
156,060.00
14,660.59
.00
111,841.03
44,218.97
72
107,668.75
Commodities & Supplies
453,209.00
.00
453,209.00
.00
127,207.88
177,324.24
148,676.88
67
231,459.75
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
(23,336.97)
20,861.00
25,129.47
617,009.53
7
10,056.62
EXPENSE TOTALS
$2,156,955.00
$0.00
$2,156,955.00
$55,803.82
$164,261.86
$472,785.88
$1,519,907.26
30%
$536,864.98
Fund 041 - Motor Fuel Tax Fund Totals
$2,156,955.00
$0.00
$2,156,955.00
$55,803.82
$164,261.86
$472,785.88
$1,519,907.26
$536,864.98
0
Expense Budget by Account Classification
Report
Through 08/31/15
Prior Fiscal Year Activity Included
Summary Listing
0
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD
% used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions
Rec'd
Prior Year YTD
Fund 042 - Cm mty Development Block Grant
EXPENSE
Personal Services, Scheduled Salaries & Wages
48,783.00
-00
48,783.00
4,575.00
.00
33,949.24
14,833.76
70
31,783.38
Employee Benefits
25,491.00
,00
25,491.00
2,157.31
.00
17,046.10
8,444.90
67
17,165.70
Other Employee Costs
1,040.00
.00
1,040.00
.00
.00
133.32
906.68
13
151.70
Contractual Services
154,430.00
.00
154,430.00
162.90
2,208.45
58,154.86
94,066.69
39
66,772.19
Commodities & Supplies
520.00
.00
520.00
.00
.00
.00
520.00
0
,00
Other Expenditures
189,000.00
.00
189,000.00
.00
.00
8,117.50
180,882.50
4
3,230.00
Land Improvements
.00
.00
.00
.00
.00
.00
.00
+++
.00
Building Improvements
.00
.00
.00
.00
.00
.00
.00
+++
.00
Infrastructure
.00
.00
.00
.00
.00
.00
.00
...
.00
EXPENSE TOTALS
$419,264.00
$0.00
$419,264.00
$6,895.21
$2,208.45
$117,401.02
$299,654.53
29%
$119,102.97
Fund 042 - Cmmty Development Block Grant Totals
$419,264.00
$0.00
$419,264.00
$6,895.21
$2f208.45
$117,401.02
$299,654.53
$119,102.97
0
Account Classification
Fund 043 - Asset Seizure Fund
EXPENSE
Other Employee Costs
Contractual Services
Other Equipment
Expense Budget by Account Classification
Report
Through 08/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget
Budget
Amendments
Amended
Budget
Current Month
Transactions
YTD
Encumbrances
YTD
Transactions
Budget - YTD
Transactions
% used/
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
2,000.00
1,000.00
67
4,000.00
15,000.00
.00
15,000.00
.00
.00
6,488.75
8,511.25
43
1,642.29
EXPENSE TOTALS $19,000.00 $0.00 $19,000.00 $0.00 $0.00 $8,488.75 $10,511.25 45% $5,642.29
Fund 043 - Asset Seizure Fund Totals $19,000.00 $0.00 $19,000.00 $0.00 $0.00 $8,488.75 $10,511.25 $5,642.29
10
Account Classification
Fund 044 - Federal Equitable Share Funds
EXPENSE
Expense Budget by Account Classification
Report
Through 08/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 1,000.00
AO
1,000.00
(5835)
.00
.00
1,000.00 0
.00
Building Improvements .00
,00
.00
AO
.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
($58.75)
$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
($58.75)
$0.00
$0.00
$2,000.00
$0.00
11
Account Classification
Fund 045 - DUI Fine Fund
EXPENSE
Other Employee Costs
Contractual Services
Other Equipment
Interfund Transfers
Expense Budget by Account Classification
Report
Through 08/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
640.30
359.70
64
.00
.00
.00
.00
.00
.00
.00
.00
+++
AO
1,000.00
.00
1,000.00
187.50
.00
3,932.50
(2,932.50)
393
2,767.30
.00
.00
.00
.00
.00
.00
.00
+++
,00
EXPENSE TOTALS $2,000.00
$0.00
$2,000.00
$187.50
$0.00
$4,572.80
($2,572.80)
229%
$2,767.30
Fund 045 - DUI Fine Fund Totals $2,000.00
$0.00
$2,000.00
$187.50
$0.00
$4,572.80
($2,572.80)
$2,767.30
12
Account Classification
Fund 046 - Foreign Fire Tax Board Fund
EXPENSE
Contractual Services
Insurance
Commodities & Supplies
Other Equipment
EXPENSE TOTALS
Fund 046 - Foreign Fire Tax Board Fund Totals
Expense Budget by Account Classification
Report
Through 08/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
10,000.00
.00
10,000.00
.00
.00
7,422.88
2,577.12
74
3,946.60
500.00
.00
500.00
.00
.00
.00
500.00
0
.00
5,000.00
.00
5,000.00
.00
.00
444.26
4,555.74
9
211.65
15,000.00
.00
15,000.00
.00
.00
31,488.86
(16,488.86)
210
11,688.00
$30,500.00
$0.00
$30,500.00
$0.00
$0.00
$39,356.00
($8,856.00)
129%
$15,846.25
$30,500.00
$0.00
$30,500.00
$0.00
$0.00
$39,356.00
($8,856.00)
$15,846.25
13
Account Classification
Fund 048 - Business District Fund
EXPENSE
Expense Budget by Account Classification
Report
Through 08/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
Bond Principal .00
.00
.00
.00
.00
.00
.00 ...
.00
Interest Expense 1,021,000.00
.00
1,021,000.00
.00
.00
371,008.08
649,991.92 36
.00
EXPENSE TOTALS $1,021,000.00
$0.00
$1,021,000.00
$0.00
$0.00
$371,008.08
$649,991.92 36%
$0.00
Fund 048 - Business District Fund Totals $1,021,000.00
$0.00
$1,021,000.00
$0.00
$0.00
$371,008.08
$649,991.92
$0.00
14
Account Classification
Fund 050 - Water and Sewer Fund
EXPENSE
Expense Budget by Account Classification
Repo
Through 0:
Prior Fiscal Year Activity ._4
Summary Listi a
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD
Personal Services, Scheduled Salaries & Wages
2,006,058.00
.00
2,006,058.00
144,488.96
.00
1,289,024.60
717,033.40
64
1,352,657.66
Employee Benefits
772,177.00
.00
772,177.00
58,397.63
.00
516,671.33
255,505.67
67
513,493.27
Other Employee Costs
37,393.00
.00
37,393.00
1,427.55
557.20
16,431.58
20,404.22
45
23,279.38
Contractual Services
8,650,244.00
140,210.00
8,790,454.00
757,563.07
189,616.64
5,118,368.64
3,482,468.72
60
4,806,191.31
Utilities
160,913.00
.00
160,913.00
7,365.36
.00
73,915.29
86,997.71
46
79,914.89
Insurance
101,312.00
.00
101,312.00
8,442.67
.00
67,541.31
33,770.69
67
53,649.28
Commodities & Supplies
293,516.00
.00
293,516.00
19,216.32
47,267.80
151,130.45
95,117.75
68
104,860.57
Other Expenditures
.00
.00
.00
.00
.00
.00
.00
...
.00
Building Improvements
65,000.00
37,225.00
102,225.00
.00
85,475.00
9,708.64
7,041.36
93
1,350.00
Office Equipment
3,930.00
.00
3,930.00
.00
.00
.00
3,930.00
0
.00
Other Equipment
1,173,744.00
1,546,434.00
2,720,178.00
2,615.43
928,550.45
1,659,370.78
132,256.77
95
942,757.19
Distribution Systems
2,300,500.00
620,279.00
2,920,779.00
10,561.38
1,734,105.42
461,681.76
724,991.82
75
117,930.71
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,010,078.37
$2,985,572.51
$9,363,844.38
$5,559,518.11
69%
$7,996,084.26
Fund 050 - Water and Sewer Fund Totals
$15,564,787.00
$2,344,148.00
$17,908,935.00
$1,010,078.37
$2,985,572.51
$9,363,844.38
$5,559,518.11
$7,996,084.26
15
Expense Budget by Account Classification
Report
Through 08/31/15
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Fund 051 - Village Parking System Fund
EXPENSE
Personal Services, Scheduled Salaries & Wages
35,175.00
.00
35,175.00
2,500.03
.00
22,165.85
13,009.15
63
24,593.54
Employee Benefits
17,353.00
.00
17,353.00
1,304.74
.00
10,802.04
6,550.96
62
10,781.23
Contractual Services
94,382.00
.00
94,382.00
8,460.60
2,036.86
54,194.38
38,150.76
60
42,149.89
Insurance
2,156.00
.00
2,156.00
179.67
.00
1,437.36
718.64
67
783.36
Commodities & Supplies
520.00
.00
520.00
.00
.00
.00
520.00
0
170.00
Other Expenditures
.00
.00
.00
.00
.00
.00
.00
...
.00
Building Improvements
7,074.00
.00
7,074.00
.00
1,750.00
1,750.00
3,574.00
49
1,687.26
Infrastructure
153,500.00
.00
153,500.00
.00
6,750.00
.00
146,750.00
4
26,527.74
Interfund Transfers
.00
.00
.00
.00
.00
.00
.00
...
.00
EXPENSE TOTALS
$310,160.00
$0.00
$310,160.00
$12,445.04
$10,536.86
$90,349.63
$209,273.51
33%
$106,693.02
Fund 051 - Village Parking System Fund Totals
$310,160.00
$0.00
$310,160.00
$12,445.04
$10,536.86
$90,349.63
$209,273.51
$106,693.02
9.1
Account Classification
Fund 052 - Parking System Revenue Fund
EXPENSE
Personal Services, Scheduled Salaries & Wages
Employee Benefits
Contractual Services
Utilities
Insurance
Commodities & Supplies
Other Expenditures
Building Improvements
Infrastructure
Interfund Transfers
EXPENSE TOTALS
Fund 052 - Parking System Revenue Fund Totals
Expense Budget by Account Classification
Report
Through 08/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
25,830.00
.00
25,830.00
1,842.29
.00
16,290.78
9,539.22
63
17,873.12
13,024.00
.00
13,024.00
968.32
.00
8,002.95
5,021.05
61
7,987.28
114,325.00
.00
114,325.00
5,862.32
5,572.59
71,323.78
37,428.63
67
52,544.70
10,733.00
.00
10,733.00
94.16
.00
3,322.02
7,410.98
31
4,176.45
1,757.00
.00
1,757.00
146.42
.00
1,171.36
585.64
67
937.36
9,974.00
.00
9,974.00
1,700.00
.00
3,629.29
6,344.71
36
6,250.56
.00
.00
.00
.00
.00
.00
.00
+++
.00
75,000.00
.00
75,000.00
.00
.00
.00
75,000.00
0
.00
.00
.00
.00
.00
.00
.00
.00
+++
.00
.00
.00
.00
.00
.00
.00
.00
+++
.00
$250,643.00
$0.00
$250,643.00
$10,613.51
$5,572.59
$103,740.18
$141,330.23
44%
$89,769.47
$250,643.00
$0.00
$250,643.00
$10,613.51
$5,572.59
$103,740.18
$141,330.23
$89,769.47
17
Account Classification
Fund 060 - Vehicle Maintenance Fund
EXPENSE
Personal Services, Scheduled Salaries & Wages
Employee Benefits
Other Employee Costs
Contractual Services
Utilities
Commodities & Supplies
Other Expenditures
Office Equipment
Other Equipment
EXPENSE TOTALS
Fund 060 - Vehicle Maintenance Fund Totals
Expense Budget by Account Classification
Report
Through 08/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
951,226.00
.00
951,226.00
67,938.07
.00
618,715.53
332,510.47
65
633,782.77
379,364.00
.00
379,364.00
27,125.40
.00
234,510.78
144,853.22
62
239,611.26
2,408.00
.00
2,408.00
1,035.00
,00
1,596.33
811.67
66
1,090.00
102,813.00
12,844,00
115,657.00
6,097.74
15,740=03
60,952.53
38,964.44
66
48,080.69
3,132.00
.00
3,132.00
502.68
.00
2,390.55
741.45
76
1,591.97
735,223.00
26,295.00
761,518.00
31,435.36
214,743.66
357,573.24
189,201.10
75
455,279.53
.00
.00
.00
.00
,00
.00
.00
+++
.00
567.00
.00
567.00
.00
.00
54.67
512.33
10
132.99
20,165.00
.00
20,165.00
91.94
605.00
16,671.72
2,888.28
86
870.13
$2,194,898.00
$39,139.00
$2,234,037.00
$134,226.19
$231,088.69
$1,292,465.35
$710,482.96
68%
$1,380,439.34
$2,194,898.00
$39,139.00
$2,234,037.00
$134,226.19
$231,088.69
$1,292,465.35
$710,482.96
$1,380,439.34
18
Account Classification
Expense Budget by Account Classification
Report
Through 08/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 061 - Vehicle Replacement Fund
EXPENSE
Other Expenditures
,00
.00
.00
.00
.00
.00
,00
+++ .00
Motor Equipment
909,000.00
273,406.00
1,182,406.00
1,215.00
450,147.60
175,560.38
556,698.02
53 800,679.02
Interfund Transfers
,00
.00
.00
.00
.00
.00
.00
+++ ,00
EXPENSE TOTALS
$909,000.00
$273,406.00
$1,182,406.00
$1,215.00
$450,147.60
$175,560.38
$556,698.02
53% $800,679.02
Fund 061 - Vehicle Replacement Fund Totals
$909,000.00
$273,406.00
$1,182,406.00
$1,215.00
$450,147.60
$175,560.38
$556,698.02
$800,679.02
19
Account Classification
Expense Budget by Account Classification
Report
Through 08/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 062 - Computer Replacement Fund
EXPENSE
Other Expenditures
_00
.00
.00
.00
.00
.00
.00 +++
.00
Office Equipment
429,380.00
.00
429,380.00
3,822.00
47,436.11
60,949.02
320,994.87 25
75,335.21
EXPENSE TOTALS
$429,380.00
$0.00
$429,380.00
$3,822.00
$47,436.11
$60,949.02
$320,994.87 25%
$75,335.21
Fund 062 - Computer Replacement Fund Totals
$429,380.00
$0.00
$429,380.00
$3,822.00
$47,436.11
$60,949.02
$320,994.87
$75,335.21
20
Account Classification
Fund 063 - Risk Management Fund
EXPENSE
Contractual Services
Insurance
Other Equipment
Infrastructure
Interfund Transfers
Expense Budget by Account Classification
Report
Through 08/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
25,000.00
.00
25,000.00
.00
.00
12,150.00
12,850.00
49
10,300.00
7,889,896.00
.00
7,889,896.00
776,999.33
.00
5,510,861.40
2,379,034.60
70
5,749,596.72
165,000.00
.00
165,000.00
.00
.00
.00
165,000.00
0
58.25
.00
.00
.00
,00
.00
.00
.00
...
.00
.00
.00
.00
.00
.00
.00
.00
+++
.00
EXPENSE TOTALS $8,079,896.00 $0.00 $8,079,896.00 $776,999.33 $0.00 $5,523,011.40 $2,556,884.60 68% $5,759,954.97
Fund 063 - Risk Management Fund Totals $8,079,896.00 $0.00 $8,079,896.00 $776,999.33 $0.00 $5,523,011.40 $2,556,884.60 $5,759,954.97
21
Account Classification
Fund 070 - Police Pension Fund
EXPENSE
Pension Benefits
Contractual Services
Insurance
Commodities & Supplies
Other Expenditures
Office Equipment
Expense Budget by Account Classification
Report
Through 08/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,472,170.00
.00
4,472,170.00
375,414.80
.00
3,008,710.99
1,463,459.01
67
2,682,949.14
154,100.00
.00
154,100.00
16,112.92
.00
70,228.31
83,871.69
46
72,961.15
15,000.00
..00
15,000.00
12,558.00
.00
12,558.00
2,442.00
84
.00
100.00
.00
100.00
.00
.00
.00
100.00
0
.00
12,000.00
.00
12,000.00
1,018.42
.00
9,368.42
2,631.58
78
8,555.00
.00
.00
.00
.00
.00
.00
.00
+++
.00
EXPENSE TOTALS $4,653,370.00 $0.00 $4,653,370.00 $405,104.14 $0.00 $3,100,865.72 $1,552,504.28 67% $2,764,465.29
Fund 070 - Police Pension Fund Totals $4,653,370.00 $0.00 $4,653,370.00 $405,104.14 $0.00 $3,100,865.72 $1,552,504.28 $2,764,465.29
22
Account Classification
Fund 071 - Fire Pension Fund
EXPENSE
Pension Benefits
Contractual Services
Insurance
Commodities & Supplies
Other Expenditures
EXPENSE TOTALS
Fund 071 - Fire Pension Fund Totals
Expense Budget by Account Classification
Report
Through 08/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
386,988.89
.00
3,008,421.22
1,325,746.78
69
2,753,548.53
136,100.00
.00
136,100.00
13,976.36
.00
77,462.45
58,637.55
57
68,885.83
15,000.00
.00
15,000.00
13,493.00
.00
13,493.00
1,507.00
90
.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
8,000.00
4,000.00
67
8,450.00
$4,498,268.00
$0.00
$4,498,268.00
$414,458.25
$0.00
$3,107,376.67
$1,390,891.33
69%
$2,830,884.36
$4,498,268.00
$0.00
$4,498,268.00
$414,458.25
$0.00
$3,107,376.67
$1,390,891.33
$2,830,884.36
Grand Totals $115,972,850.00 $8,257,928.00 $124,230,778.00 $9,123,121.98 $15,113,599.58 $65,855,912.68 $43,261,265.74 $65,532,374.33
23
Page 1 of 7
Amount
6,311.29
24.56
632.00
135.00
237.00
1,386.00
95.00
95.00
5,468.55
92.78
96.74
62.00
716.22
85.00
3,250.00
13, 680.00
506.60
1,175.00
300.00
1,529.56
706.54
374.85
1,967.90
544.49
13.03
14.58
18.68
20.50
12.30
15.95
11.85
12.30
2,563.53
66.30
312.50
2,973.00
140.00
50.00
5,914.97
49.94
7,187.24
281.40
52.00
52.00
109.89
127.00
75.00
142.22
583.60
712.50
562.50
77.48
45.99
44.60
22,123.09
1,227.00
2,046.30
106.59
VILLAGE OF MOUNT PROSPECT
List of Bills
August 27 - September 09, 2015
Fund Vendor Name
Invoice Description
001 General Fund
ACS State & Local Government Solutions
Illinois State Disbursement Unit
Addison Building Material Co.
Catch Basin Supplies
Air One Equipment, Inc.
2015 SCBA Compressor Maint./ Quarterly Air Test
2015 SCBA Compressor Maint./ Quarterly Air Test
Alpha Prime Communications
Service Contract CERT Radios
American Binding Company
Electronic Letter Opener
Anderson Pest Solutions
Hornets Nest at 507 N. Pine
Hornets Nest at 101 Bobby
Andres Medical Billing, Ltd.
Ambulance Billing -July 2015
Aramark Uniform Services, Inc.
Uniform Cleaning and Rental
Uniform Cleaning and Rental
ARC Document Solutions, LLC
Equipment Maintenance
AT & T
Period 8/16/15 - 9/15/15
Avanti Cafe & Sandwich Bar, Inc.
Food for Firefighter Oral Interviews (9/1/15)
Bald Eagle Window Cleaning
Window cleaning at 6 buildings
Baxter & Woodman, Inc.
Storm Sewer Inspection Program
Bedco Mechanical
HVAC Repairs
Bokina, Joan
SHRM Certification & Preparatory Classes
SH RM Certification & Preparatory Classes
Capital One National Association
Costco Purchase 7/30/15 - 8/21/15
Cardno, Inc.
Professional Services
Case Lots, Inc.
Custodial Supplies
Custodial supplies to be used in all buildings
CDW Government, Inc.
Receipt Printer for Community Development
Central Continental Bakery
Closed Session dinner
Century Cleaners
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Chicago Comm. Service, Inc.
Radio equipment maintenance/upgrade
Christianson, Kevin
Pizzas for Firefighters -Oil Leak
Chuboff, Darrin
Rebate Sidewalk Shared Program
Community College District 502
Register C. Garrity for Basic Recruit Academy 07/06-09/25/15
Register C. Garrity for CPR in Basic Academy
Register C. Garrity in training class 07/18/15
Crystal Court Shopping Center
October rent for the CCC
Crystal Maintenance Services Corp.
Custodial Services
Custodial Services
Dash Medical Gloves
Disposable gloves
Dirtbusters Auto Detailing, Inc.
Cleaning for squad P-37
Cleaning for squad P-33
Discount Media Products, LLC
DVDs
Dolan, John
2015 Fire Uniform Allowance
Dollinger, Annabelle
Refund Landlord License#712
Elite Remodeling Group, Inc.
Garnishment
Enterprise Rent -a -car
SIU rental car 07/29-08/25/15
Eterno, David G.
July billing
August billing
Experian
Background checks - August, 2015
Federal Express Corp
Shipping Expenses
Shipping for Christianson to Williams Fine & Hazard Control
Fire Pension Fund
Fire Pension
G & J Associates, Inc.
Light Pole Banners
Garrity, Connor
Reimburse expenses: Basic Recruit Academy 07/06-09/25/15
Grainger Inc.
Special Events Supplies
Page 1 of 7
Amount
6,311.29
24.56
632.00
135.00
237.00
1,386.00
95.00
95.00
5,468.55
92.78
96.74
62.00
716.22
85.00
3,250.00
13, 680.00
506.60
1,175.00
300.00
1,529.56
706.54
374.85
1,967.90
544.49
13.03
14.58
18.68
20.50
12.30
15.95
11.85
12.30
2,563.53
66.30
312.50
2,973.00
140.00
50.00
5,914.97
49.94
7,187.24
281.40
52.00
52.00
109.89
127.00
75.00
142.22
583.60
712.50
562.50
77.48
45.99
44.60
22,123.09
1,227.00
2,046.30
106.59
VILLAGE OF MOUNT PROSPECT
List of Bills
August 27 - September 09, 2015
Fund Vendor Name
Invoice Description
Amount
Grainger Inc.
Street light supplies
164.58
Maintenance and repair supplies
71.85
Custodial Supplies
159.38
Guardian
Emp. Dental Plan September 2015
9,803.95
Guziel, Fran
Open House Promotional Materials & Apartment Safety Rack Card
815.00
HD Supply Const Supply Ltd
Engineering Supplies
132.00
Healy Asphalt Company,llc.
Streets Patching Materials
59.89
Asphalt materials used for street patching
45.58
Streets Patching Materials
122.96
Streets Patching Materials
77.91
Streets Patching Materials
18.02
Streets Patching Materials
75.26
Asphalt materials used for street patching
31.27
Streets Patching Materials
32.86
Homer Tree Care, Inc.
Tree Removals
2,024.90
Humintell, LLC
Register D. Kidd for training class 09/09-11/15
300.00
ICMA Retirement Trust - 457
ICMA 457 (flat percent)
20,039.73
ID Network, Inc.
Annual service agreement for FingerRoll Livescan system & Camera
3,184.00
Illinois American Water Company
Period 2/8/15 - 8/9/15
2,360.66
Private Fire Service 9/1/15 - 10/1/15
33.84
Illinois Department of Revenue
IL State Withholding
27,596.32
IL State Withholding
73.87
IMRF
IMRF
153,209.58
Infor Public Sector, Inc.
Software Development
1,544.00
Hansen quarterly maintenance
11,980.90
Internal Revenue Service
Federal Withholding
458.45
Federal Withholding
174,677.32
Federal Withholding
375.99
International Code Council, Inc.
Reference Membership
240.00
International Union of Operating Engineers
IUOE PW Membership Dues
986.39
Janowick, Timothy
Reimburse expenses: Command staff meeting 08/19/15
50.39
Kane, Julie K
Reimbursement for Police Chief's Luncheon
170.00
Kerstein, June
Reimbursement Food Exp - August 2015
30.59
Klein, Thorpe and Jenkins, Ltd.
July billing
51,640.15
Knox Company
Knox box door hanger
37.00
Manna, Christopher R
Transfer Stamp Rebate
600.00
Menard Inc.
Engineering Supplies
39.72
Street light supplies
9.45
Metro Door and Dock, Inc.
Overhead door repair
494.40
Overhead door repair
2,394.80
Metro Federal Credit Union
MP Fire Local 4119 Dues
2,239.38
Metropolitan Alliance - Police
MP Police Association Dues
1,349.50
Miller, James
Donuts & coffee for Pub. Ed event
41.77
MilPro Marine LLC
430SR inflatable rescue boat
10,645.00
Mitchell Cowit
Register J. Garris & A. Teevan for training class
268.00
Mobile Print Inc.
Open House Poster & Rack Card Printing
339.50
Open House Flyer
270.63
Officers' case cards
93.12
Morgan, Dean
Safety Shoe Allowance
180.00
Morris, Doug
Rebate Sidewalk Shared Program
250.00
Morton Suggestion Co.
Citizen Police Academy Supplies
550.68
Municipal Emergency Services, Inc.
Credit for Alpha X Structural Globe
(513.00)
Alpha X Structural Globe
513.00
Ellen becker-Coat/Pa nts
1,612.00
Nabielec, Mark
2015 Fire Uniform Allowance
142.23
Nationwide Mutual Insurance Company
Nationwide 457 (flat percent)
11,749.97
NCPERS Group Life Ins.
IMRF Life Insurance
625.60
NICOR
Natural Gas Consumption
17.11
Natural Gas Consumption
11.50
Natural Gas Consumption
216.78
Natural Gas Consumption
115.75
Natural Gas Consumption
1,363.31
North East Multi Regional Trng
Course registration for Saric, Brogan & Burrell
1,050.00
Course registration for J. Henderson
300.00
Page 2 of 7
Wisconsin Department of Revenue
W ISCTF
001 General Fund Total
020 Capital Improvement Fund
B & H Photo/video
Ciorba Group Inc
K -Plus Engineering, LLC.
Mercury Partners 90 BI Inc.
Northwest Central 9-1-1 System
DV Symposium registration for Julia Arteaga
DV symposium registration for Nina Persino
Register Lisa Schaps for training course 10/23/15
WI State Withholding
Garnishment
Monitor for control room
Boardroom Upgrade Equipment
Pond Improvements
Professional Services
Public Building Improvements
Motorola Subscriber Financing - September 2015
Page 3 of 7
Amount
3,995.00
405.00
99.00
340.00
765.00
453.00
55,795.54
105.36
1,200.00
920.00
70.00
242.70
789.95
2,821.00
29,793.91
180.00
5,500.00
28,032.66
1,068.69
(453.91)
24.99
1,050.00
236.70
3,107.10
127.00
212.75
250.00
278.99
139.00
30.00
37.95
43.99
1,454.00
350.82
897.00
1,100.00
750.00
2,185.68
767.62
1,640.00
22.72
29.06
1,995.00
112.50
63.60
584.25
127.82
6,510.84
9,349.67
127.49
40.00
40.00
40.00
40.00
504.12
542.48
753,748.74
339.99
1,160.68
20,357.70
640.00
140.00
10, 603.91
VILLAGE OF MOUNT PROSPECT
List of Bills
August 27 - September 09, 2015
Fund Vendor Name
Invoice Description
Northeastern III. Pub. Safety Trng.
Fire Academy Tuition-Liebgott
Northern Illinois Funeral Service Inc.
Remains removal: MP train station (train accident: D. Zell)
Northshore University Healthsystem
Physical exam: R. Smith
Physical exam: R. Smith
Physical exam: R. Etchingham
Physical exam: M. Brady
Northwest Central Dispatch System
October 2015 - Member Assessment
Northwest Suburban United Way
United Way
Patch 22 Ltd.
Special Events
Pellum, Christine M & James
Transfer Stamp Rebate
Persino, Nina
Reimbursement for Essentials for Public Health
Petty Cash
Petty Cash 8/2015
Phoenix Fire Systems, Inc.
Fire Extinguisher Service/Repair
Pitney Bowes
Equipment Maintenance
Police Pension Fund
Police Pension
Prosafety, Inc.
Other supplies
Ravenswood Special Events, Inc.
Mount Prospect Block Party 2015 Management Deposit
Mount Prospect Block Party 2015
Ray O'herron Co., Inc.
Uniform supplies: CSO Trejo
Credit for returned uniform items for CSO Trejo
Uniform supplies: CSO Trejo
Record -A -Hit, Inc.
Special Events
Red Wing Shoe Store
POC Shoes for 2015
Reliance Standard Life Insurance Co,
Short Term Disability
Rodewald, Craig R.
2015 Fire Uniform Allowance
Sanders, Bill
Rebate Sidewalk Shared Program
Saracco, Antoinette
Rebate Sidewalk Shared Program
Schroeder, William
Reimbursement - Supplies
Dues/Membership
Schwamb, Douglas M.
CDL Reimbursement
Skalon, Tim
2015 Fire Uniform Allowance
Slobe, Steve
2015 Fire Uniform Allowance
Smoron, Scott
Transfer Stamp Rebate
Standard Equipment Company
Sweeper side shoes
Standard Fuse Corporation
Flares
Stephen A. Laser Assoc.,p.c.
New Hire Assessment-Ellenbecker & Wnek
New Hire Assessment-Pietrzyk
Strahl, David
Professional Development Strahl
Sulak, Todd
Reimbursement for Travel Expenses
Taser International
Annual maintenance agreement for Tasers
The Ups Store
Legal billing
Postage
Town Square Publications LLC
Marketing/Advertising
TransUnion Risk and Alternative Data Solutions Inc Background checks - August, 2015
Uline Inc.
3 multi -fold counter top towel dispensers
United Healthcare
Flex Benefit Plan Services - May 2015
Vanopdorp, Teresa
Reimbursement Family Bike Ride Expenses 8/13 & 8/14
Verizon Wireless Services LLC
Cellular Service & Equipment Charges - July/Aug 2015
Village of Mount Prospect
Flex - Medical
Wagner, Matthew
Safety Shoe Allowance
Wings Program, Inc.
DV Symposium registration for Victoria Bran
Wisconsin Department of Revenue
W ISCTF
001 General Fund Total
020 Capital Improvement Fund
B & H Photo/video
Ciorba Group Inc
K -Plus Engineering, LLC.
Mercury Partners 90 BI Inc.
Northwest Central 9-1-1 System
DV Symposium registration for Julia Arteaga
DV symposium registration for Nina Persino
Register Lisa Schaps for training course 10/23/15
WI State Withholding
Garnishment
Monitor for control room
Boardroom Upgrade Equipment
Pond Improvements
Professional Services
Public Building Improvements
Motorola Subscriber Financing - September 2015
Page 3 of 7
Amount
3,995.00
405.00
99.00
340.00
765.00
453.00
55,795.54
105.36
1,200.00
920.00
70.00
242.70
789.95
2,821.00
29,793.91
180.00
5,500.00
28,032.66
1,068.69
(453.91)
24.99
1,050.00
236.70
3,107.10
127.00
212.75
250.00
278.99
139.00
30.00
37.95
43.99
1,454.00
350.82
897.00
1,100.00
750.00
2,185.68
767.62
1,640.00
22.72
29.06
1,995.00
112.50
63.60
584.25
127.82
6,510.84
9,349.67
127.49
40.00
40.00
40.00
40.00
504.12
542.48
753,748.74
339.99
1,160.68
20,357.70
640.00
140.00
10, 603.91
VILLAGE OF MOUNT PROSPECT
List of Bills
Page 4 of 7
August 27 - September 09, 2015
Fund Vendor Name
Invoice Description
Amount
Northwest Electrical Supply
Public Building Improvements
92.27
020 Capital Improvement Fund Total
$
33,334.55
023 Street Improvement Construction Fund
Arrow Road Construction
Street Resurfacing
$
530,209.41
023 Street Improvement Construction Fund Total
$
530,209.41
024 Flood Control Construction Fund
A Lamp Concrete
Isabella Drainage Improvements Project
$
364,998.15
Burns & Mcdonnell Engineering Co.
Engineering Service
52,073.45
Cardno, Inc.
Professional Services
1,448.21
Constellation NewEnergy, Inc.
Electrical Service Delivery
83.35
Electrical Service Delivery
84.60
024 Flood Control Construction Fund Total
$
418,687.76
040 Refuse Disposal Fund
ARC Disposal Company
Refuse Disposal Program
$
72.19
AT & T
Period 8/16/15 - 9/15/15
3.98
Enginemasters, Inc.
Leaf Machine Parts
53.50
General Parts Inc.
Repair Maintenance Supplies
11.94
Repair Maintenance Supplies
43.56
Headco Industries, Inc.
Leaf Machine Parts
338.36
Leaf Machine Parts
451.07
Leaf Machine Parts
431.51
Leaf Machine Parts
467.00
ICMA Retirement Trust - 457
ICMA 457 (flat percent)
66.54
Illinois Department of Revenue
IL State Withholding
314.57
IMRF
IMRF
2,893.23
Internal Revenue Service
Federal Withholding
2,753.56
International Union of Operating Engineers
IUOE PW Membership Dues
103.26
Messick Farm EQ
Leaf Machine Parts
487.58
Leaf Machine Parts
316.60
Napa -Heights Automotive Supply
Repair Maintenance Supplies
23.88
Nationwide Mutual Insurance Company
Nationwide 457 (flat percent)
233.81
NCPERS Group Life Ins.
IMRF Life Insurance
17.60
Reliance Standard Life Insurance Co.
Short Term Disability
92.38
Standard Equipment Company
Leaf Truck Boxes
310.32
Village of Mount Prospect
Flex - Medical
71.88
040 Refuse Disposal Fund Total
$
9,558.32
041 Motor Fuel Tax Fund
Constellation NewEnergy, Inc.
Electrical Service Delivery
$
52.93
Electrical Service Delivery
2,093.14
Electrical Service Delivery
82.73
Electrical Service Delivery
80.52
Electrical Service Delivery
90.95
Electrical Service Delivery
98.46
Electrical Service Delivery
89.67
Electrical Service Delivery
29.83
Electrical Service Delivery
83.35
Electrical Service Delivery
117.49
Electrical Service Delivery
57.12
Electrical Service Delivery
171.10
Electrical Service Delivery
23.76
Preform Traffic Contr Sys,ltd.
2015 Pavement Marking
62,943.69
V3 Companies
Traffic Signal Replacement
1,440.00
041 Motor Fuel Tax Fund Total
$
67,454.74
042 Community Development Block Grant
ICMA Retirement Trust - 457
ICMA 457 (flat percent)
$
450.00
Illinois Department of Revenue
IL State Withholding
48.90
IMRF
IMRF
598.48
Internal Revenue Service
Federal Withholding
450.57
Village of Mount Prospect
Flex - Medical
31.25
042 Community Development Block Grant Total
$
1,579.20
Page 4 of 7
VILLAGE OF MOUNT PROSPECT
List of Bills
August 27 - September 09, 2015
Fund Vendor Name Invoice
046 Foreign Fire Tax Board Fund
Peterson, Bradley
046 Foreign Fire Tax Board Fund Total
050 Water and Sewer Fund
Aramark Uniform Services, Inc.
AT&T
Badger Meter Inc
Baxter & Woodman, Inc.
Century Cleaners
East Jordan Iron Works, Inc.
EESCO, A Division of WESCO Distribution, Inc
Enterprise Rent -a -car
Grainger Inc.
HBK Water Meter Service
ICMA Retirement Trust - 457
Illinois Department of Revenue
Illinois Tool Works Inc.
IMRF
Internal Revenue Service
International Union of Operating Engineers
Jones, Daniel G.
JP Morgan Chase Bank
L. Marshall, Inc.
Legend Electrical Sales
Martam Construction
Mid American Water of Wauconda, Inc.
Nationwide Mutual Insurance Company
NCH Corporation
NCPERS Group Life Ins.
NICOR
Northwest Suburban United Way
Olena Ponomarova
Prosafety,Inc.
Reliance Standard Life Insurance Co.
Steven Mackey
USA Bluebook
Verizon Wireless Services LLC
Victor Grzebicki
Village of Mount Prospect
Ziebell Water Service Products
050 Water and Sewer Fund Total
051 Village Parking System Fund
Crystal Maintenance Services Corp.
Elite Remodeling Group, Inc.
ICMA Retirement Trust - 457
Illinois Department of Revenue
IMRF
Internal Revenue Service
Post Office Mail Box Renewal (9/1/15 - 8/31/16)
Uniform Cleaning and Rental
Uniform Cleaning and Rental
Period 8/16/15 - 9/15/15
AMR/AMI System
SCADA Wireless
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Uniform Cleaning
Hydrants
SCADA Control
Summer car rental
Repair Maintenance Supplies
Repair Maintenance Supplies
Repair Maintenance Supplies
Meter Installation
Meter Installation
ICMA 457 (flat percent)
IL State Withholding
Repair Maintenance Supplies
IMRF
Federal Withholding
IUOE PW Membership Dues
Uniform Expense
Utility Refund - 603 Carol Ln
Roof repairs
Meter Testing and Repair
2015 Water Main Improvements
Repair Maintenance Supplies
Nationwide 457 (flat percent)
Water Hydrants
IMRF Life Insurance
Natural Gas Consumption
Natural Gas Consumption
Natural Gas Consumption
United Way
Utility Refund - 308 N Wille St
Repair Maintenance Supplies
Short Term Disability
Utility Refund - 603 Carol Ln
Meter Repair Parts
Cellular Service & Equipment Charges -July/Aug 2015
Utility Refund - 636 E Sha Bonee Trl
Flex - Medical
Repair Maintenance Supplies
Water Hydrants
Custodial Services
Custodial Services
Garnishment
ICMA 457 (flat percent)
IL State Withholding
IMRF
Federal Withholding
Page 5 of 7
Amount
$ 66.00
$ 66.00
$ 92.78
96.74
265.96
448,997.64
906.83
14.57
18.67
20.50
12.30
15.95
11.85
12.30
8,271.00
7,029.72
1,672.15
130.40
69.70
130.40
5,232.45
5,451.75
1,267.35
2,343.00
358.75
22,183.17
19,302.70
1,035.57
31.55
41.22
35,775.00
94.68
337, 668.75
2,407.16
420.89
158.86
36.80
68.65
78.04
78.46
21.00
16.92
210.00
118.92
16.43
249.95
388.75
40.49
715.02
235.00
943.00
$ 904,759.74
$ 2.30
330.23
78.19
9.00
36.58
400.06
291.71
Fund Vendor Name
International Union of Operating Engineers
Nationwide Mutual Insurance Company
NCPERS Group Life Ins.
Northwest Electrical Supply
Preform Traffic Contr Sys,ltd.
Village of Mount Prospect
051 Village Parking System Fund Total
052 Parking System Revenue Fund
Byrne, Connor
Crystal Maintenance Services Corp.
Elite Remodeling Group, Inc.
ICMA Retirement Trust - 457
Illinois Department of Revenue
IMRF
Internal Revenue Service
International Union of Operating Engineers
Nationwide Mutual Insurance Company
NCPERS Group Life Ins.
Petty Cash
Preform Traffic Contr Sys,ltd.
Union Pacific Railroad
Village of Mount Prospect
052 Parking System Revenue Fund Total
060 Vehicle Maintenance Fund
American Messaging
Arlington Heights Ford
Arlington Power Equipment
AT&T
Atlas First Access, LLC
Black Dog Chicago Corp
Chicago Parts & Sound Llc
Enterprise Rent -a -car
General Parts Inc.
ICMA Retirement Trust - 457
Illinois Department of Revenue
IMRF
Inland Power Group Inc.
Internal Revenue Service
International Union of Operating Engineers
Just Tires
Lund Industries, Inc.
Mansfield Oil Company
Mcmaster-carr Supply Co.
N.W. Ideal Auto Body & Mechanical Repair Inc.
Napa -Heights Automotive Supply
NCH Corporation
NCPERS Group Life Ins.
Northwest Suburban United Way
Pomp's Tire Service, Inc.
Precision Service & Parts
VILLAGE OF MOUNT PROSPECT
List of Bills
August 27 - September 09, 2015
Invoice F
IUOE PW Membership Dues
Nationwide 457 (flat percent)
IMRF Life Insurance
Equipment Maintenance and Repair
2015 Pavement Marking
Flex - Medical
Refund Easy Park Pass
Custodial Services
Custodial Services
Garnishment
ICMA 457 (flat percent)
IL State Withholding
IMRF
Federal Withholding
IUOE PW Membership Dues
Nationwide 457 (flat percent)
IMRF Life Insurance
Petty Cash 8/2015
2015 Pavement Marking
Metra Land Lease - July 2015
Flex - Medical
Professional Service
Gasket
4503 right rear tail lamp
P-3 shift cable
309 OEM only ABS Module
Vehicle Maintenance Supplies
Period 8/16/15 - 9/15/15
Vehicle Maintenance Supplies
Vehicle Maintenance Supplies
Equipment Maintenance and Repair
P-37 turn signal switch
Oil filters
Summer car rental
P-39 rear wheel bearings and seals
ICMA 457 (flat percent)
IL State Withholding
IMRF
Air filters
Air filters
Federal Withholding
IUOE PW Membership Dues
Squad Utility Tires
Vehicle Maintenance Supplies
8,500 gallons UL Fuel
Velcro
Equipment Maintenance and Repair
P-39 rear axle pinion bearings and seal
Belt for Doall saw
Aux power outlets
Vehicle Maintenance Supplies
Vehicle Maintenance Supplies
IMRF Life Insurance
United Way
Crown Vic Squad Tires
Vehicle Maintenance Supplies
Vehicle Maintenance Supplies
549 oil filters
P-4 front brake calipers
Page 6 of 7
15
Amount
15.94
9.96
4.40
43.98
3,591.47
34.64
4,848.46
150.00
1.76
252.53
64.02
6.02
26.75
295.45
212.81
10.65
6.65
3.60
1.00
2,398.91
3,745.22
27.44
7,202.81
91.64
8.51
38.88
63.02
751.29
4.20
9.96
138.89
479.44
275.00
24.75
193.68
422.22
38.20
1,079.80
1,095.92
10,770.10
54.40
27.98
9,058.66
494.53
1,594.92
68.90
16,585.29
188.55
941.25
100.48
19.79
30.72
285.63
214.10
48.00
4.00
1,299.56
(75.00)
(84.64)
29.10
158.84
VILLAGE OF MOUNT PROSPECT
List of Bills
August 27 - September 09, 2015
Fund Vendor Name
Invoice Description
Amount
Reliance Standard Life Insurance Co.
Short Term Disability
97.34
Ronco Industrial Supply
Vehicle Maintenance Supplies
164.03
Sid Tool Co., Inc.
Nuts, bolts, washers, machine screws, hose clamps and sheet metal
409.68
Fortis Concrete
Grease, cable lube, solder and hose clamps
165.95
Suburban Accents Inc
Vehicle Maintenance Supplies
80.50
Terrace Supply Company
Vehicle Maintenance Supplies
100.42
Refund Escrow Permit # 15-0826 (113 S Elmhurst Ave)
Vehicle Maintenance Supplies
38.00
Highland Park Electric
Vehicle Maintenance Supplies
208.80
Underwriters Laboratories Inc.
530 Tower annual UL Inspection fee
795.00
Vehicle Maintenance Program Inc.
Vehicle Maintenance Supplies
481.60
Vehicle Service Partners, Inc.
Gas Fuel
176.97
Verizon Wireless Services LLC
Cellular Service & Equipment Charges -July/Aug 2015
237.74
Village of Mount Prospect
Flex - Medical
350.02
Waytek, Inc.
Vehicle Maintenance Supplies
298.87
Refund Escrow Permit # 15-0374 (290 N Westgate Rd #209)
Vehicle Maintenance Supplies
122.17
060 Vehicle Maintenance Fund Total
2015 PPRT- 6th Allocation
$ 50,257.65
063 Risk Management Fund
Intergovernmental Per.ben.coop IPBC - September 2015 $ 487,892.78
IPBC - August 2015 487,892.78
Municipal Claims and Safety Agreement W/C Medical Bills 46,640.21
Northwest Community Hospital Nowak - DOS 05/16/12 - Acct #70961032 83.52
Perrault, Andrew Reimbursement for Mailbox Damaged While Snow Plowing 125.00
State of Illinois W/C Rate Assessment 01/01/15 - 06/30/15 2,254.27
Trout Downing, LLC Settlement 7/31/15 (111 Mount Prospect LLC) 10,000.00
063 Risk Management Fund Total $ 1,034,888.56
070 Police Pension Fund
Internal Revenue Service Federal Withholding $ 48,482.53
Reimer Dobrovolny & Karlson LLC Legal Services Rendered 161.24
Wells Fargo Bank Admin Fees 8/1/15-10/31/15 1,120.37
070 Police Pension Fund Total $ 49,764.14
071 Fire Pension Fund
Buffalo Grove Orthopaedic Associates Medical Exam - Eric Mertes 8/24/15 $ 1,200.00
Internal Revenue Service Federal Withholding 45,728.24
Wells Fargo Bank Admin Fees 8/1/15-10/31/15 975.07
071 Fire Pension Fund Total $ 47,903.31
073 Escrow Deposit Fund
ABT Electronics Inc
Refund Escrow Permit # 15-1435 (1705 Freedom Ct)
$
125.00
Allegiance Construction Group Inc
Refund Escrow Permit # 15-1193 (1550 Bishop Ct)
400.00
Brown, Mary Baptist
Refund Escrow Permit # 15-1426 (717 N Prospect Manor Ave)
200.00
Fortis Concrete
Refund Escrow Permit # 15-0990 (800 W Cathy Ln)
150.00
Gabriels Landscape and Tree Service
Refund Escrow Permit # 15-0676 (1 N Maple St)
200.00
Gambino Lanscaping and Brick Paving
Refund Escrow Permit # 15-0826 (113 S Elmhurst Ave)
150.00
Highland Park Electric
Refund Escrow Permit # 15-1251 (203 North Withorn Ln)
125.00
J Montoya Construction
Refund Escrow Permit # 15-1496 (616 N Pine St)
200.00
K & K Concrete
Refund Escrow Permit # 15-1481 (1112 N Crabtree Ln)
200.00
Kirchner, Edward
Refund Escrow Permit # 15-1181 (117 S Elmhurst Ave)
200.00
Leindecker Concrete Specialties
Refund Escrow Permit # 15-0931(1824 Thornwood Ln)
200.00
Letsos, Angela
Refund Escrow Permit # 15-0374 (290 N Westgate Rd #209)
125.00
Mount Prospect Public Library
2015 PPRT- 6th Allocation
1,220.79
Pizzato, Linda & David
Refund Escrow Permit # 15-1163 (615 S William St)
200.00
Rainbow Signs Inc
Refund Escrow Permit # 15-1115 (1120 S Elmhurst Rd)
125.00
Recinos Concrete Inc
Refund Escrow Permit # 15-1290 (807 S Edward St)
200.00
Third District Circuit Court
Bond Check 8/27/15
150.00
Bond Check 9/1/15
450.00
Bond Check 9/8/15
450.00
Wojtowicz, Gary
Refund Escrow Permit # 15-1463 ( 604 W Lonnquist Blvd)
200.00
073 Escrow Deposit Fund Total
$
5,270.79
Grand Total
$
3,919,534.18
Page 7 of 7