HomeMy WebLinkAbout3. FINANCIAL REPORT AND BILLS 10/19/2010 Mourn Prospect
Village of Mount Prospect
Mount Prospect, Illinois
INTEROFFICE MEMORANDUM
TO: VILLAGE PRESIDENT AND BOARD OF TRUSTEES
FINANCE COMMISSION
FROM: FINANCE DIRECTOR
DATE: OCTOBER 15, 2010
SUBJECT: MONTHLY FINANCIAL REPORT — SEPTEMBER 2010
Attached hereto are the cash position and investment statements of the Village for the month ended
September 30, 2010. 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, 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 accounts for the accumulation of monies for
debt service payments.
Governmental and Enterprise Funds - Cash and cash equivalents at August 31 were $24.8
million. During September, cash receipts totaled $4,396,878.54. In addition investment income for
the month was $5,437.99 and outflows due to Interfund activity removed $234,510.73 from the
balance. Additional reductions in cash and cash equivalents during September totaled
$5,662,201.56. Of this amount, payments to vendors were $3,621,944.99, employee payroll and
related expenses were $2,038,383.50 and other disbursements were $1,873.07. Cash and cash
equivalents at September 30 were $23.3 million.
Monthly Financial Report — September 2010
October 15, 2010
Page 2
There were no funds held in investments during the month of September. Funds were held in cash
money market accounts that currently earn competitive rates of interest.
Total cash and investments for Governmental and Enterprise Funds at August 31 were
$24,818,673.48. Cash and investments at September 30 totaled $23,324,277.72. This is a
decrease of $1,494,395.76.
Trust and Agency Funds - Cash and cash equivalents at August 31 were $5.1 million. During
September, cash receipts totaled $162,675.72. In addition investment income for the month was
$66,064.58 and inflows due to Interfund activity totaled $234,510.73. There was also a net increase
in cash due to investment activities of $954,356.63. Reductions in cash and cash equivalents
during September totaled $593,481.28. Of this amount, payments to vendors were $131,944.31,
employee payroll and related expenses were $442,750.54, payments related to the flexible ending
program totaled $17,152.47. Other disbursements were $1,633.96. Cash and cash equivalents at
September 30 were $5.9 million.
Total investments at September 30 were $79,547,800.92, an increase of $2,784,089.61 from August
31. There were unrealized investment gains of $3,738,446.24 and a transfer to cash of $954,356.63
that accounted for the change.
Total cash and investments for Trust and Agency Funds at August 31 were $81,840,621.22. Cash
and investments at September 30 totaled $85,448,837.21. This is an increase for the month of
$3,608,215.99.
Summary of Cash Activity by Fund Type (page 2)
This report provides a breakdown of the cash activity for the month broken down by fund type. This
breakdown is useful in identifying where the activity (receipts and disbursements) is occurring.
There are times during the year when activity in certain funds such as the capital improvement and
special revenue funds is higher than normal. This will distort the financial picture of some of the
other components of the governmental funds such as the General Fund which tends to be more
level and predictable in terms of spending and receipt of revenue. Each month the report will
provide detail explanation on activity of the General Fund, the Village's primary operating fund. The
report will also provide additional information on fund types that experienced higher than normal
activity for the month. Each of these is highlighted below.
General Fund — Cash and cash equivalents at August 31 totaled $4,012,215.54. During
September, cash receipts totaled $2,681,818.51 and investment income was $3,860.52. Significant
cash receipts included sales taxes, state income tax and telecommunication tax.
Sales tax revenues for the month totaled $972,796. Of this amount, $878,049 was generated
from the 1% state portion while $94,747 was generated from the .25% home rule portion. The
state portion showed an increase of 16.2% from last year same time. The home rule portion
also grew from the prior year by 5.5 %. The difference between the two sales tax sources in their
change from prior year is due to the tax being assessed on a different set of goods. Sales taxes
received in September are for June sales as there is a three -month lag in getting this distribution
from the state. For the months of February through September the increase from the prior year
is going to be skewed higher due to a large retailer being closed during this period for
remodeling.
H:WCCT\Treasurer's Report\2010 \Monthly Financial Report\Monthly Cash Position Report - September 2010.doc
Monthly Financial Report — September 2010
October 15, 2010
Page 3
State income tax receipts for September totaled $852,544. Two monthly allocations were
received during September. May allocations were $556,050 and June allocations were
$296,494. The state remains 4 months in arrears in remitting these taxes to the Village. The
total amount in arrears is approximately $1.3 million.
Telecommunication tax receipts for September reflect June activity. Total receipts for the
month were $243,642. Year to date receipts are running 1.7% higher than 2009.
Disbursements from the General Fund for September included payments to vendors of
$1,583,907.02, payments for employee wages and benefits of $1,649,169.78 and other
disbursements of $2,379.11. Interfund transfers of $574,358.68 for health premiums and vehicle
lease and maintenance payments were also made during September.
Cash and cash equivalents at September 30 were $2,888,079.98. There were no investments in
the General Fund at September 30.
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 - Investments for the governmental and agency funds are
typically made up of Certificates of Deposit. At September 30 there were no CD's placed at any
bank. This is due to the extremely low interest rates being offered. Money instead has been placed
in interest bearing money market accounts
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, Capital Gains, Segall
Bryant and Mesirow Financial. Segall Bryant holds approximately half of the fixed income
investments for the two pension funds while Capital Gains and Mesirow manage the balance of
fixed income investments for these two funds. Each manager maintains a small portion of their
portfolio in cash to help facilitate liquidity and trading.
Investments in equities consist of mutual funds spread across various sectors (small, mid and large -
cap stocks) as well as investment philosophies (value, core and growth). The pension funds also
have a small portion of their portfolio invested in international stocks. Each year the investment mix
is evaluated for optimal diversification to meet the pension funds investment policy goals and
objectives. Below is a breakdown of how the pension fund portfolios are invested.
H:\ACCT\Treasurer's Report\2010 \Monthly Financial Report\Monthly Cash Position Report - September 2010.doc
Monthly Financial Report — September 2010
October 15, 2010
Page 4
POLICE PENSION FUND (710)
Various Various Wells Fargo Wells Fargo Investments Various Various 21,586,641.78
Various Various Various Mutual Fund Investments Various Various 19,210,634.82
40,797,276.60
FIRE PENSION FUND (720)
Various Various Wells Fargo Wells Fargo Investments Various Various 21,947,614.21
Various Various Various Mutual Fund Investments Various Various 16,802,910.11
38,750,524.32
TOTAL TRUST AND AGENCY FUND INVESTMENTS $ 79,547,800.92
Investment of the Village's pension funds is governed by an Investment Policy adopted by each
Pension Board.
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 be provided to
the Village Board and Finance Commission on a monthly basis moving forward.
H:\ACCT\Treasurer's Report\2010 \Monthly Financial Report\Monthly Cash Position Report - September 2010.doc
VILLAGE OF MOUNT PROSPECT
Preliminary Cash and Investment Position Report - All Funds
For the Month Ended September 30, 2010
GOVERNMENTAL AND ENTERPRISE FUNDS
Cash and Cash Total Cash and
Equivalents Investments Investments
Balance at August 31, 2010 $ 24,818,673.48 $ - $ 24,818,673.48
Cash receipts 4,396,878.54 4,396,878.54
Investment income 5,437.99 5,437.99
Transfers from investments to cash - - -
Transfers to investments from cash - - -
Interfund activity (234,510.73) (234,510.73)
Disbursements:
Accounts payable (3,621,944.99) (3,621,944.99)
Payroll (2,038,383.50) (2,038,383.50)
Other (1,873.07) (1,873.07)
Balance at September 30, 2010 $ 23,324,277.72 $ - $ 23,324,277.72
TRUST AND AGENCY FUNDS *
Cash and Cash Total Cash and
Equivalents Investments Investments
Balance at August 31, 2010 $ 5,076,909.91 $ 76,763,711.31 $ 81,840,621.22
Cash receipts 162,675.72 162,675.72
Investment income (loss) 66,064.58 3,738,446.24 3,804,510.82
Transfers from investments to cash 5,398,094.42 (5,398,094.42) -
Transfers to investments from cash (4,443,737.79) 4,443,737.79 -
Interfund activity 234,510.73 234,510.73
Disbursements:
Accounts payable (131,944.31) (131,944.31)
Payroll (442,750.54) (442,750.54)
Flex spending (17,152.47) (17,152.47)
Other (1,633.96) (1,633.96)
Balance at September 30, 2010 $ 5,901,036.29 $ 79,547,800.92 $ 85,448,837.21
* Assets are restricted in purpose and do not represent discretionary assets of the government.
1
• 0 (O n N 00 co 1- d' O 0M N M
CO N U) V 1- O O d• 0 co O O 0 ) O 0)
M4 N d•I� OI- d•0 d• ' 1 O a
` Q LO
O D (0 0 0) M O U7 c) co U) V 0
M (0O n (0 T 00 co N Lo CO
O 115 0 CD M 0)r M 1 M M N r
h co u 0 CO at 1 0 U) O t•
0 V M V' ,,i oi N V M N. O
N y-
69 IR
0) N. 01 CO C 03 0) ~ ici co CO
)d• CO ' ( O
O = M <n . NM U , ( 0 d' r r r r O i
Q � IJ,J co D CO N 0 (O a O M
M
Z � U Z O o co 0) 0)
u_ W Q M r N
Z O Q EA w
w
0
Q d• M •• N 0) CD C1 to 0)M N M
Q 1'- M In d: r In U) 10 0) 0) 0) 0) CO
Z Q N d' ' ( N ( O ' O pi CO ' L0 4 O t.
< ZUZ co ar (00MM U) 0) 00 U) ,T 0 CO
f - Q 0 O O d• O O 1` d' t CO CD (V OD d•
M wJM (D 10( W d• C4 of i O 0) V ID
D L i cl- W 1 .5 (10 V 10 (00 0 v LO CD
H 0_ d' CO n CO
69
LU c(4) CO ( ( 0 0 1- 0 v Eli n N ■
MCDF ' ' Oci ' c'i d' r n
(-n0) N- CO d' n r
0 0 - o) CO co d• U) CO Cl 0) N w
0 0 OS co (ri v ..--- c6 c
< Z a0 M . v OC CO N V)
F( LL N� vv N M
O N
I- Q
Z
Q (»
0 U7 04 d• n ((0 ( (0 0 1-- N N
Q7 O in N c-a0 O N CV r. N
Z LL 00 N 0) a at C0 CO (0 v ?
CC s-
W w o � () � 0) N- N.
H. d' v 0) 0)
z 5 o � ai of
m 0 0) w E9 vi
0. 0
0 I— N M OD n O O n U7 O CO
ICJ C 0 W CO CO 00 d'0) 00 r . r N
O
CO CL _O 0 IL 0 N O N O' M M 0) 0)
0
Et E Z 12C Z 1` 0 05 0 0 d• CO
I- : CZ Q U- I- LLI LL N W W N CO M
Z > m w Z
D < Cr) CO W
6! N
n C
r Jr
IL n3
O U w C I-- a- (0 CO (0 CO CCOO t0 co
ui 15 -E Z
O W < V co CO N O r r
as tnt as
J E m Z 0 --) Z C v v M 0)
C.0 U_
z `9 w
w
Z W LO d• 0) 0
U 0) ai CC H = (0 0) 0) >
CO 0
w 0)
0 en. W 0
() 0
M 0( d' 1 CD C4 CO - . CD m
J W 0)) I'- CO ` 1 Na t ( . .1 . (0 M m
N
0Z0 r00N 0 OM V .4 ., CU
w W Z O (f C c CCD ( 2'
NW LL 0 M n v r CO
—
co w 1)
(0
N _
co Z 10 cD— 1'-0 a) m c
7 to CO ' ' C00 ' 0 h 0) Co N
U- CD 10 1` CD 0 r G m
J N CO OD M M 0) 0 d
< N CO M 4 C CO O O CO m
LL O CD (v (D U) CO O y0
Z
.4.- N N 04 C
W 0
0 v, v► v
v
(0 m
0) m ~ m
c _o W o
1-
1— C R n
W w o ° CO ~ 0
J c m w m W c
> E m p 0 c c Z
�a�i � � o •N m m
m E — m ( o i E z
C!m E c N o n CO a Y Z y
N N N 0E , cn V u) U I-- 09 v C C CD = N
Q Q w ° O CD m O m (0 W • m T C w co al C>p)mC m EEEE co 2 Se W m U m 2
Cry .c m E a) N C N w ( m ` n in 0 F V U- C J N
C ' C 0 C C .0 10 .0 . C W N 7 f 0
N 0 N m 0 N m m N to > m 3 Q
0 M ( - 1 ` - C QOQQ w ?U�i� 2 Q F .
f
VILLAGE OF MOUNT PROSPECT
STATEMENT OF INVESTMENTS
As of September 30, 2010
GOVERNMENTAL AND ENTERPRISE FUNDS
Maturity Purchase Financial Investment CUSIP/ Interest Market Weighted
Date Date Institution Description Acct # Rate % Value Avg Yield
As of September 30, 2010, there were no certificates of deposit held by the Governmental and Enterprise Funds.
TRUST AND AGENCY FUNDS *
Maturity Purchase Financial Investment CUSIP/ Interest Market Weighted
Date Date Institution Description Acct # Rate % Value Avg Yield
POLICE PENSION FUND (710)
Various Various Wells Fargo Wells Fargo Investments Various Various 21,586,641.78
Various Various Various Mutual Fund Investments Various Various 19,210,634.82
40,797,276.60
FIRE PENSION FUND (720)
Various Various Wells Fargo Wells Fargo Investments Various Various 21,947,614.21
Various Various Various Mutual Fund Investments Various Various 16,802,910.11
38,750,524.32
TOTAL TRUST AND AGENCY FUND INVESTMENTS $79,547,800.92
* Assets are restricted in purpose and do not represent discretionary assets of the government.
3
VILLAGE OF MOUNT PROSPECT
BUDGET REVENUE
&
EXPENDITURE SUMMARIES
January 1— September 30, 2010
10/14/2010 VILLAGE OF MOUNT PROSPECT 9 Months ( 75.0% ) Completed
09:11:57 3 Months ( 25.0% ) Remaining
Budget Revenue Summary
01/01/10 - 09/30/10
Cur Mo Y -T -D 2010 Unreceived Unreceived
Received Received Budget Balance Percent
REVENUE BY CLASSIFICATION
PROPERTY TAXES -9,502 7,759,464 14,999,000 7,239,536 48.3
OTHER TAXES 930,421 7,991,131 15,665,000 7,673,869 49.0
LICENSES, PERMITS & FEES 97,033 2,824,116 3,487,000 662,884 19.0
INTERGOVERMENT REV. 1,948,955 9,645,137 18,102,647 8,457,510 46.7
CHARGES FOR SERVICE 1,645,269 14,772,606 21,970,880 7,198,274 32.8
FINES AND FORFEITS 41,964 437,082 704,000 266,918 37.9
INVESTMENT INCOME 3,859,515 4,480,198 5,696,250 1,216,052 21.3
REIMBURSEMENTS 15,775 216,512 467,000 250,488 53.6
OTHER REVENUE 283,840 4,000,032 7,023,160 3,023,128 43.0
OTHER FINANCING SOURCES 0 2,551 1,023,505 1,020,954 99.8
Total All Funds 8,813,270 52,128,829 89,138,442 37,009,613 41.5
REVENUE BY FUND
GENERAL FUND 2,730,789 22,697,176 40,691,100 17,993,924 44.2
REFUSE DISPOSAL FUND 181,674 2,661,944 4,038,500 1,376,556 34.1
MOTOR FUEL TAX FUND 117,885 981,521 1,836,500 854,979 46.6
LAW ENFORCEMENT BLOCK GRANT 0 0 0 0
COMMUNITY DEVELPMNT BLOCK GRNT 31,439 236,360 565,447 329,087 58.2
ASSET SEIZURE FUND 6 15,912 6,000 -9,912 -165.2
DEA SHARED FUNDS FUND 5 38 1,500 1,462 97.5
DUI FINE FUND 986 8,808 20,500 11,692 57.0
FOREIGN FIRE TAX BOARD FUND 25,179 55,394 35,500 - 19,894 -56.0
SERIES 1987A B &I, PW FACILITY 0 0 0 0
SERIES 2001 B &I, VILLAGE HALL 1 3 379,000 378,997 100.0
SERIES 2003 B &I, VILLAGE HALL -605 498,478 904,000 405,522 44.9
SERIES 2009 B &I, FD /PW -444 227,831 414,000 186,169 45.0
2009B B &I, FD /PW -533 54,000 0 - 54,000
2009C B &I, FD /PW 77 66,123 0 - 66,123
SERIES 1999 B &I, TIF 0 0 0 0
SERIES 1998A B &I, FLOOD 0 0 0 0
SERIES 1998C B &I, TIF 0 0 0 0
IEPA FLOOD CONTROL LOANS B &I 86,800 468,350 1,140,708 672,358 58.9
SERIES 2000 B &I, FLOOD CONTROL 0 0 0 0
SERIES 2002B B &I, FLOOD 0 0 0 0
CAPITAL IMPROVEMENT FUND 87,220 487,891 1,421,500 933,609 65.7
SERIES 2009 CONST FUND 0 24,644 1,124,505 1,099,861 97.8
DOWNTOWN REDEVLPMNT CONST - 15,421 1,218,868 2,567,000 1,348,132 52.5
STREET IMPROVEMENT CONST FUND 128,751 1,137,084 1,717,600 580,516 33.8
FLOOD CONTROL CONST FUND 8,898 105,661 198,792 93,131 46.8
WATER AND SEWER FUND 819,030 7,419,996 12,225,500 4,805,504 39.3
VILLAGE PARKING SYSTEM FUND 12,030 88,913 152,000 63,087 41.5
PARKING SYSTEM REVENUE FUND 14,494 105,920 159,500 53,580 33.6
VEHICLE MAINTENANCE FUND 137,490 1,236,520 1,654,192 417,672 25.2
VEHICLE REPLACEMENT FUND 10,714 86,885 238,200 151,315 63.5
COMPUTER REPLACEMENT FUND 110 1,061 12,000 10,939 91.2
RISK MANAGEMENT FUND 430,604 4,955,612 6,865,098 1,909,486 27.8
POLICE PENSION FUND 2,095,568 3,724,450 5,585,500 1,861,050 33.3
FIRE PENSION FUND 1,910,526 3,563,386 5,184,300 1,620,914 31.3
SSA #6 GEORGE /ALBERT B &I -3 0 0 0
GENERAL FIXED ASSETS ACCT GP 0 0 0 0
1
10/14/2010 VILLAGE OF MOUNT PROSPECT 9 Months ( 75.0% ) Completed
09:11:57 3 Months ( 25.0' ) Remaining
Budget Revenue Summary
01 /01 /10 - 09/30/10
Cur Mo Y -T -D 2010 Unreceived Unreceived
Received Received Budget Balance Percent
Total All Funds 8,813,270 52,128,829 89,138,442 37,009,613 41.5
2
10/14/2010 9 Months ( 75.0% ) Completed
09:12:37 VILLAGE OF MOUNT PROSPECT 3 Months ( 25.0 ) Remaining
FRRBRR03
SUMO21 Budget Revenue by Category within Fund Summary
01 /01 /10 - 09/30/10
Cur Mo Y -T -D 2010 Unreceived Unreceived
Received Received Budget Balance Percent
GENERAL FUND
40 PROPERTY TAXES -6,681 5,978,667 11,575,000 5,596,333 48.3
41 OTHER TAXES 603,919 4,146,012 7,576,000 3,429,988 45.3
42 LICENSES, PERMITS & FEES 94,231 2,804,953 3,426,000 621,047 18.1
43 INTERGOVERMENT REV. 1,799,855 7,994,195 15,240,100 7,245,905 47.5
44 CHARGES FOR SERVICE 175,884 1,036,710 1,640,000 603,290 36.8
45 FINES AND FORFEITS 37,149 389,473 642,000 252,527 39.3
46 INVESTMENT INCOME 3,861 30,881 130,000 99,119 76.2
47 REIMBURSEMENTS 15,733 167,832 296,000 128,168 43.3
48 OTHER REVENUE 6,838 146,902 166,000 19,098 11.5
49 OTHER FINANCING SOURCES 0 1,551 0 -1,551
TOTAL GENERAL FUND 2,730,789 22,697,176 40,691,100 17,993,924 44.2
REFUSE DISPOSAL FUND
40 PROPERTY TAXES -1,262 955,716 1,731,000 775,284 44.8
44 CHARGES FOR SERVICE 171,403 1,613,986 2,151,000 537,014 25.0
46 INVESTMENT INCOME 24 852 22,500 21,648 96.2
48 OTHER REVENUE 11,509 91,390 134,000 42,610 31.8
TOTAL REFUSE DISPOSAL FUND 181,674 2,661,944 4,038,500 1,376,556 34.1
MOTOR FUEL TAX FUND
43 INTERGOVERMENT REV. 117,661 946,234 1,675,000 728,766 43.5
46 INVESTMENT INCOME 224 1,387 1,500 113 7.5
47 REIMBURSEMENTS 0 33,900 160,000 126,100 78.8
TOTAL MOTOR FUEL TAX FUND 117,885 981,521 1,836,500 854,979 46.6
LAW ENFORCEMENT BLOCK GRANT
43 INTERGOVERMENT REV. 0 0 0 0
46 INVESTMENT INCOME 0 0 0 0
TOTAL LAW ENFORCEMENT BLOCK GRANT 0 0 0 0
COMMUNITY DEVELPMNT BLOCK GRNT
43 INTERGOVERMENT REV. 31,439 185,850 515,447 329,597 63.9
46 INVESTMENT INCOME 0 0 0 0
48 OTHER REVENUE 0 50,510 50,000 -510 -1.0
TOTAL COMMUNITY DEVELPMNT BLOCK GRNT 31,439 236,360 565,447 329,087 58.2
ASSET SEIZURE FUND
45 FINES AND FORFEITS 0 15,865 5,000 - 10,865 -217.3
46 INVESTMENT INCOME 6 47 1,000 953 95.3
TOTAL ASSET SEIZURE FUND 6 15,912 6,000 -9,912 -165.2
DEA SHARED FUNDS FUND
45 FINES AND FORFEITS 0 0 1,000 1,000 100.0
46 INVESTMENT INCOME 5 38 500 462 92.4
1
10/14/2010 9 Months ( 75.0% ) Completed
09:12:37 RBR R03 VILLAGE OF MOUNT PROSPECT 3 Months ( 25.0 ) Remaining
F R
SUMO21 Budget Revenue by Category within Fund Summary
01 /01 /10 - 09/30/10
Cur Mo Y -T -D 2010 Unreceived Unreceived
Received Received Budget Balance Percent
TOTAL DEA SHARED FUNDS FUND 5 38 1,500 1,462 97.5
DUI FINE FUND
45 FINES AND FORFEITS 985 8,803 20,000 11,197 56.0
46 INVESTMENT INCOME 1 5 500 495 99.0
TOTAL DUI FINE FUND 986 8,808 20,500 11,692 57.0
FOREIGN FIRE TAX BOARD FUND
41 OTHER TAXES 25,176 55,381 35,000 - 20,381 -58.2
46 INVESTMENT INCOME 3 13 500 487 97.4
TOTAL FOREIGN FIRE TAX BOARD FUND 25,179 55,394 35,500 - 19,894 - 56.0
SERIES 1987A B &I, PW FACILITY
40 PROPERTY TAXES 0 0 0 0
46 INVESTMENT INCOME 0 0 0 0
TOTAL SERIES 1987A B &I, PW FACILITY 0 0 0 0
SERIES 2001 B &I, VILLAGE HALL
40 PROPERTY TAXES 0 0 378,000 378,000 100.0
46 INVESTMENT INCOME 1 3 1,000 997 99.7
49 OTHER FINANCING SOURCES 0 0 0 0
TOTAL SERIES 2001 B &I, VILLAGE HALL 1 3 379,000 378,997 100.0
SERIES 2003 B &I, VILLAGE HALL
40 PROPERTY TAXES -655 498,099 902,000 403,901 44.8
46 INVESTMENT INCOME 50 379 2,000 1,621 81.1
49 OTHER FINANCING SOURCES 0 0 0 0
TOTAL SERIES 2003 B &I, VILLAGE HALL - 605 498,478 904,000 405,522 44.9
SERIES 2009 B &I, FD /PW
40 PROPERTY TAXES -446 227,773 413,000 185,227 44.8
46 INVESTMENT INCOME 2 58 1,000 942 94.2
TOTAL SERIES 2009 B &I, FD /PW - 444 227,831 414,000 186,169 45.0
2009B B &I, FD /PW
40 PROPERTY TAXES -534 53,978 0 - 53,978
46 INVESTMENT INCOME 1 22 0 -22
49 OTHER FINANCING SOURCES 0 0 0 0
TOTAL 2009B B &I, FD /PW - 533 54,000 0 - 54,000
2009C B &I, FD /PW
40 PROPERTY TAXES 76 45,231 0 - 45,231
43 INTERGOVERMENT REV. 0 20,872 0 - 20,872
46 INVESTMENT INCOME 1 20 0 -20
10/14/2010 9 Months ( 75.0% ) Completed
09 :12:37 VILLAGE OF MOUNT PROSPECT 3 Months ( 25.0% ) Remaining
FRRBRR03
SUM 021 Budget Revenue by Category within Fund Summary
01 /01 /10 - 09/30/10
Cur Mo Y -T -D 2010 Unreceived Unreceived
Received Received Budget Balance Percent
TOTAL 2009C B &I, FD /PW 77 66,123 0 - 66,123
SERIES 1999 B &I, TIF
41 OTHER TAXES 0 0 0 0
46 INVESTMENT INCOME 0 0 0 0
TOTAL SERIES 1999 B &I, TIF 0 0 0 0
SERIES 1998A B &I, FLOOD
41 OTHER TAXES 0 0 0 0
46 INVESTMENT INCOME 0 0 0 0
TOTAL SERIES 1998A B &I, FLOOD 0 0 0 0
SERIES 1998C B &I, TIF
41 OTHER TAXES 0 0 0 0
46 INVESTMENT INCOME 0 0 0 0
TOTAL SERIES 1998C B &I, TIF 0 0 0 0
IEPA FLOOD CONTROL LOANS B &I
41 OTHER TAXES 86,740 468,006 1,140,708 672,702 59.0
46 INVESTMENT INCOME 60 344 0 -344
TOTAL IEPA FLOOD CONTROL LOANS B &I 86,800 468,350 1,140,708 672,358 58.9
SERIES 2000 B &I, FLOOD CONTROL
41 OTHER TAXES 0 0 0 0
46 INVESTMENT INCOME 0 0 0 0
TOTAL SERIES 2000 B &I, FLOOD CONTROL 0 0 0 0
SERIES 2002B B &I, FLOOD
41 OTHER TAXES 0 0 0 0
49 OTHER FINANCING SOURCES 0 0 0 0
TOTAL SERIES 2002B B &I, FLOOD 0 0 0 0
CAPITAL IMPROVEMENT FUND
41 OTHER TAXES 87,143 470,178 1,146,000 675,822 59.0
43 INTERGOVERMENT REV. 0 7,657 264,000 256,343 97.1
46 INVESTMENT INCOME 77 846 11,500 10,654 92.6
47 REIMBURSEMENTS 0 0 0 0
48 OTHER REVENUE 0 9,210 0 -9,210
49 OTHER FINANCING SOURCES 0 0 0 0
TOTAL CAPITAL IMPROVEMENT FUND 87,220 487,891 1,421,500 933,609 65.7
SERIES 2009 CONST FUND
43 INTERGOVERMENT REV. 0 20,000 150,000 130,000 86.7
46 INVESTMENT INCOME 0 4,644 1,000 -3,644 -364.4
48 OTHER REVENUE 0 0 0 0
10/14/2010 9 Months ( 75.0% ) Completed
0R VILLAGE OF MOUNT PROSPECT 3 Months ( 25.0% ) Remaining
FR BRR03
SUMO21 Budget Revenue by Category within Fund Summary
01 /01 /10 - 09/30/10
Cur Mo Y -T -D 2010 Unreceived Unreceived
Received Received Budget Balance Percent
49 OTHER FINANCING SOURCES 0 0 973,505 973,505 100.0
TOTAL SERIES 2009 CONST FUND 0 24,644 1,124,505 1,099,861 97.8
DOWNTOWN REDEVLPMNT CONST
41 OTHER TAXES - 15,598 1,216,935 2,556,000 1,339,065 52.4
46 INVESTMENT INCOME 177 1,933 11,000 9,067 82.4
47 REIMBURSEMENTS 0 0 0 0
48 OTHER REVENUE 0 0 0 0
49 OTHER FINANCING SOURCES 0 0 0 0
TOTAL DOWNTOWN REDEVLPMNT CONST - 15,421 1,218,868 2,567,000 1,348,132 52.5
STREET IMPROVEMENT CONST FUND
41 OTHER TAXES 128,751 717,877 1,506,000 788,123 52.3
43 INTERGOVERMENT REV. 0 413,250 210,600 - 202,650 -96.2
46 INVESTMENT INCOME 0 70 1,000 930 93.0
47 REIMBURSEMENTS 0 0 0 0
48 OTHER REVENUE 0 5,887 0 -5,887
TOTAL STREET IMPROVEMENT CONST FUND 128,751 1,137,084 1,717,600 580,516 33.8
FLOOD CONTROL CONST FUND
41 OTHER TAXES 8,006 43,199 105,292 62,093 59.0
42 LICENSES, PERMITS & FEES 892 5,383 45,000 39,617 88.0
43 INTERGOVERMENT REV. 0 57,079 47,500 -9,579 -20.2
46 INVESTMENT INCOME 0 0 1,000 1,000 100.0
TOTAL FLOOD CONTROL CONST FUND 8,898 105,661 198,792 93,131 46.8
WATER AND SEWER FUND
41 OTHER TAXES -1,320 832,516 1,500,000 667,484 44.5
42 LICENSES, PERMITS & FEES 1,910 13,780 16,000 2,220 13.9
44 CHARGES FOR SERVICE 817,766 6,541,026 10,596,000 4,054,974 38.3
46 INVESTMENT INCOME 2 779 92,500 91,721 99.2
47 REIMBURSEMENTS 0 9,450 1,000 -8,450 -845.0
48 OTHER REVENUE 672 22,445 20,000 -2,445 -12.2
49 OTHER FINANCING SOURCES 0 0 0 0
TOTAL WATER AND SEWER FUND 819,030 7,419,996 12,225,500 4,805,504 39.3
VILLAGE PARKING SYSTEM FUND
41 OTHER TAXES 3,422 18,462 45,000 26,538 59.0
42 LICENSES, PERMITS & FEES 0 0 0 0
44 CHARGES FOR SERVICE 8,595 70,380 106,000 35,620 33.6
46 INVESTMENT INCOME 13 71 1,000 929 92.9
TOTAL VILLAGE PARKING SYSTEM FUND 12,030 88,913 152,000 63,087 41.5
PARKING SYSTEM REVENUE FUND
41 OTHER TAXES 4,182 22,565 55,000 32,435 59.0
44 CHARGES FOR SERVICE 10,304 83,315 104,000 20,685 19.9
46 INVESTMENT INCOME 8 40 500 460 92.0
10/14/2010 9 Months ( 75.00 ) Completed
09:12:37 VILLAGE OF MOUNT PROSPECT 3 Months ( 25.0% ) Remaining
FRRBRR03
SUMO21 Budget Revenue by Category within Fund Summary
01/01/10 - 09/30/10
Cur Mo Y -T -D 2010 Unreceived Unreceived
Received Received Budget Balance Percent
TOTAL PARKING SYSTEM REVENUE FUND 14,494 105,920 159,500 53,580 33.6
VEHICLE MAINTENANCE FUND
44 CHARGES FOR SERVICE 137,288 1,235,579 1,647,442 411,863 25.0
46 INVESTMENT INCOME 73 687 6,750 6,063 89.8
48 OTHER REVENUE 129 254 0 -254
TOTAL VEHICLE MAINTENANCE FUND 137,490 1,236,520 1,654,192 417,672 25.2
VEHICLE REPLACEMENT FUND
44 CHARGES FOR SERVICE 6,308 56,775 75,700 18,925 25.0
45 FINES AND FORFEITS 3,830 22,941 36,000 13,059 36.3
46 INVESTMENT INCOME 576 6,169 76,500 70,331 91.9
48 OTHER REVENUE 0 0 0 0
49 OTHER FINANCING SOURCES 0 1,000 50,000 49,000 98.0
TOTAL VEHICLE REPLACEMENT FUND 10,714 86,885 238,200 151,315 63.5
COMPUTER REPLACEMENT FUND
44 CHARGES FOR SERVICE 0 0 0 0
46 INVESTMENT INCOME 110 1,061 12,000 10,939 91.2
TOTAL COMPUTER REPLACEMENT FUND 110 1,061 12,000 10,939 91.2
RISK MANAGEMENT FUND
44 CHARGES FOR SERVICE 317,721 4,134,835 5,650,738 1,515,903 26.8
46 INVESTMENT INCOME 165 2,175 31,500 29,325 93.1
47 REIMBURSEMENTS 42 5,330 10,000 4,670 46.7
48 OTHER REVENUE 112,676 813,272 1,172,860 359,588 30.7
TOTAL RISK MANAGEMENT FUND 430,604 4,955,612 6,865,098 1,909,486 27.8
POLICE PENSION FUND
46 INVESTMENT INCOME 2,013,810 2,247,019 2,635,500 388,481 14.7
48 OTHER REVENUE 81,758 1,477,431 2,950,000 1,472,569 49.9
TOTAL POLICE PENSION FUND 2,095,568 3,724,450 5,585,500 1,861,050 33.3
FIRE PENSION FUND
46 INVESTMENT INCOME 1,840,268 2,180,655 2,654,000 473,345 17.8
48 OTHER REVENUE 70,258 1,382,731 2,530,300 1,147,569 45.4
TOTAL FIRE PENSION FUND 1,910,526 3,563,386 5,184,300 1,620,914 31.3
SSA #6 GEORGE /ALBERT B &I
46 INVESTMENT INCOME -3 0 0 0
TOTAL SSA #6 GEORGE /ALBERT B &I - 3 0 0 0
GENERAL FIXED ASSETS ACCT GP
47 REIMBURSEMENTS 0 0 0 0
49 OTHER FINANCING SOURCES 0 0 0 0
c
10/14/2010 9 Months ( 75.0' ) Completed
09:12:37 VILLAGE OF MOUNT PROSPECT 3 Months ( zs.ot ) Remaining
FRRBRRO 3
SUM 021 Budget Revenue by Category within Fund Summary
01/01/10 - 09/30/10
Cur Mo Y -T -D 2010 Unreceived Unreceived
Received Received Budget Balance Percent
TOTAL GENERAL FIXED ASSETS ACCT GP 0 0 0 0
MOUNT PROSPECT LIBRARY FUND
49 OTHER FINANCING SOURCES 0 0 9,715,689 9,715,689 100.0
TOTAL MOUNT PROSPECT LIBRARY FUND 0 0 9,715,689 9,715,689 100.0
10/14/2010 VILLAGE OF MOUNT PROSPECT 9 Months ( 75.0% ) Completed
09:10:33 3 Months ( 25.0% ) Remaining
Budget Expenditure Summary
01 /01 /10 - 09/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
Expended Expended Budget Balance Percent
EXPENDITURE BY CLASSIFICATION
PERSONAL SERVICES 3,075,467 19,693,611 27,253,599 7,559,988 27.7
EMPLOYEE BENEFITS 539,406 6,879,405 11,075,849 4,196,444 37.9
OTHER EMPLOYEE COSTS 20,582 212,821 460,274 247,453 53.8
PENSION BENEFITS 542,455 4,948,034 6,404,900 1,456,866 22.7
CONTRACTUAL SERVICES 1,301,565 10,813,526 17,000,174 6,186,648 36.4
UTILITIES 34,518 367,261 631,674 264,413 41.9
INSURANCE 545,249 5,050,914 7,175,232 2,124,318 29.6
COMMODITIES & SUPPLIES 104,120 1,074,331 1,727,411 653,080 37.8
OTHER EXPENDITURES 24,357 1,283,455 2,628,150 1,344,695 51.2
LAND IMPROVEMENTS 0 0 76,065 76,065 100.0
BUILDING IMPROVEMENTS 23,984 2,684,972 1,260,658 - 1,424,314 -113.0
OFFICE EQUIPMENT 6,731 270,041 488,343 218,302 44.7
MOBILE EQUIPMENT 29,356 745,074 810,000 64,926 8.0
OTHER EQUIPMENT 53,100 694,922 3,090,636 2,395,714 77.5
DISTRIBUTION SYSTEMS 412,424 706,150 2,870,346 2,164,196 75.4
INFRASTRUCTURE 22,789 1,811,073 3,509,015 1,697,942 48.4
BOND PRINCIPAL 0 273,553 1,271,204 997,651 78.5
INTEREST EXPENSE 0 558,701 1,053,076 494,375 46.9
BANK AND FISCAL FEES 0 1,178 1,600 422 26.4
INTERFUND TRANSFERS 0 0 0 0
OTHER FINANCING USES 0 0 0 0
Total All Funds 6,736,103 58,069,022 88,788,206 30,719,184 34.6
EXPENDITURE BY FUND
GENERAL FUND 3,608,103 27,960,410 41,145,530 13,185,120 32.0
REFUSE DISPOSAL FUND 353,954 2,870,491 4,240,941 1,370,450 32.3
MOTOR FUEL TAX FUND 63,235 1,295,634 1,736,302 440,668 25.4
LAW ENFORCEMENT BLOCK GRANT 0 0 0 0
COMMUNITY DEVELPMNT BLOCK GRNT 33,353 271,296 565,447 294,151 52.0
ASSET SEIZURE FUND 0 6,118 2,000 -4,118 -205.9
DEA SHARED FUNDS FUND 0 2,514 1,000 -1,514 -151.4
DUI FINE FUND 0 343 1,500 1,157 77.1
FOREIGN FIRE TAX BOARD FUND 44 28,990 15,500 - 13,490 -87.0
SERIES 1987A B &I, PW FACILITY 0 0 0 0
SERIES 2001 B &I, VILLAGE HALL 0 150 382,203 382,053 100.0
SERIES 2003 B &I, VILLAGE HALL 0 191,628 912,658 721,030 79.0
SERIES 2009 B &I, FD /PW 0 209,059 417,663 208,604 49.9
2009B B &I, FD /PW 0 46,640 0 - 46,640
2009C B &I, FD /PW 0 59,635 0 - 59,635
SERIES 1999 B &I, TIF 0 0 0 0
SERIES 1996A B &I, FLOOD 0 0 0 0
SERIES 1998A B &I, FLOOD 0 0 0 0
SERIES 1998C B &I, TIF 0 0 0 0
IEPA FLOOD CONTROL LOANS B &I 0 326,320 613,356 287,036 46.8
SERIES 2000 B &I, FLOOD CONTROL 0 0 0 0
CAPITAL IMPROVEMENT FUND 70,336 745,394 2,130,265 1,384,871 65.0
SERIES 2009 CONST FUND 13,176 2,977,114 2,183,633 - 793,481 -36.3
DOWNTOWN REDEVLPMNT CONST 24,922 1,368,142 2,736,500 1,368,358 50.0
STREET IMPROVEMENT CONST FUND 27,838 746,756 1,575,880 829,124 52.6
FLOOD CONTROL CONST FUND 11,209 19,726 161,425 141,699 87.8
WATER AND SEWER FUND 1,231,892 6,826,361 13,549,749 6,723,388 49.6
10/14/2010 9 Months ( 75.0t ) Completed
VILLAGE OF MOUNT PROSPECT .
09:10:33 3 Months ( 25.0t ) Remaining
Budget Expenditure Summary
01 /01 /10 - 09/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
Expended Expended Budget Balance Percent
VILLAGE PARKING SYSTEM FUND 11,730 69,761 175,098 105,337 60.2
PARKING SYSTEM REVENUE FUND 21,866 106,650 174,597 67,947 38.9
VEHICLE MAINTENANCE FUND 172,028 1,297,327 1,814,711 517,384 28.5
VEHICLE REPLACEMENT FUND 29,356 745,074 810,000 64,926 8.0
COMPUTER REPLACEMENT FUND 6,138 174,085 206,050 31,965 15.5
RISK MANAGEMENT FUND 518,279 4,808,187 6,872,398 2,064,211 30.0
POLICE PENSION FUND 281,419 2,545,105 3,242,300 697,195 21.5
FIRE PENSION FUND 257,225 2,370,112 3,121,500 751,388 24.1
SSA #6 GEORGE /ALBERT B &I 0 0 0 0
GENERAL FIXED ASSETS ACCT GP 0 0 0 0
GENERAL LONG -TERM DEBT ACCT GP 0 0 0 0
Total All Funds 6,736,103 58,069,022 88,788,206 30,719,184 34.6
10/14/2010 9 Months ( 75.0 ) Completed
09:14:00 VILLAGE OF MOUNT PROSPECT 3 Months ( 25.CA ) Remaining
FRRDBRO1
SUM 031 Department Budget Expenditure Summary
01 /01 /10 - 09/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
NON - DEPARTMENTAL Expended Expended Budget Balance Percent
PROGRAM TOTALS
00 ADMINISTRATION 0 0 0 0
Totals 0 0 0 0
EXPENDITURE CLASSIFICATION
72 INTEREST EXPENSE 0 0 0 0
Totals 0 0 0 0
SOURCE OF FUNDS
930 GENERAL LONG -TERM DEBT ACCT GP 0 0 0 0
Totals 0 0 0 0
1
10/14/2010 9 Months ( 75.0t ) Completed
09:14:00 VILLAGE OF MOUNT PROSPECT 3 Months ( 25.O ) Remaining '
FRRDBR01
sUM031 Department Budget Expenditure Summary
01 /01 /10 - 09/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
PUBLIC REPRESENTATION Expended Expended Budget Balance Percent
PROGRAM TOTALS
02 MAYOR AND BOARD OF TRUSTEES 4,314 128,464 120,261 -8,203 -6.8
03 ADVISORY BOARDS & COMMISSIONS 497 3,552 6,149 2,597 42.2
Totals 4,811 132,016 126,410 -5,606 -4.4
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES 3,175 25,694 34,311 8,617 25.1
51 EMPLOYEE BENEFITS 527 4,627 6,291 1,664 26.5
52 OTHER EMPLOYEE COSTS 10 562 4,400 3,838 87.2
54 CONTRACTUAL SERVICES 379 99,906 76,853 - 23,053 -30.0
55 UTILITIES 25 193 455 262 57.6
57 COMMODITIES & SUPPLIES 695 1,034 4,100 3,066 74.8
Totals 4,811 132,016 126,410 -5,606 -4.4
SOURCE OF FUNDS
001 GENERAL FUND 4,811 132,016 126,410 - 5,606 - 4.4
Totals 4,811 132,016 126,410 - 5,606 - 4.4
2
10/14/2010 9 Months ( 75.0% ) Completed
09:14:00 VILLAGE OF MOUNT PROSPECT 3 Months ( 25.0% ) Remaining
FRRDBR01
SUM031 Department Budget Expenditure Summary
01/01/10 - 09/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
VILLAGE MANAGER' S OFFICE Expended Expended Budget Balance Percent
PROGRAM TOTALS
01 VILLAGE MANAGER'S OFFICE 69,569 428,837 575,229 146,392 25.4
02 LEGAL SERVICES 43,729 398,714 538,250 139,536 25.9
03 HUMAN RESOURCES 24,939 179,002 265,181 86,179 32.5
04 INFORMATION TECHNOLOGY 73,341 576,056 892,193 316,137 35.4
05 PUBLIC INFORMATION 11,007 160,714 248,098 87,384 35.2
Totals 222,585 1,743,323 2,518,951 775,628 30.8
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES 128,456 753,999 1,011,435 257,436 25.5
51 EMPLOYEE BENEFITS 29,271 236,606 321,215 84,609 26.3
52 OTHER EMPLOYEE COSTS 929 12,157 28,200 16,043 56.9
54 CONTRACTUAL SERVICES 62,121 713,167 1,115,200 402,033 36.1
55 UTILITIES 249 4,721 8,601 3,880 45.1
57 COMMODITIES & SUPPLIES 1,296 7,130 15,200 8,070 53.1
65 OFFICE EQUIPMENT 263 15,543 19,100 3,557 18.6
67 OTHER EQUIPMENT 0 0 0 0
Totals 222,585 1,743,323 2,518,951 775,628 30.8
SOURCE OF FUNDS
001 GENERAL FUND 222,585 1,743,323 2,518,951 775,628 30.8
Totals 222,585 1,743,323 2,518,951 775,628 30.8
3
10/14/2010 9 Months ( 75.0% ) Completed
09:14:00 VILLAGE OF MOUNT PROSPECT 3 Months ( 25.0% ) Remaining
FRRDBR01
SUM 031 Department Budget Expenditure Summary
01 /01 /10 - 09/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
TV SERVICES DIVISION Expended Expended Budget Balance Percent
PROGRAM TOTALS
02 CABLE TV OPERATIONS 14,497 107,004 139,639 32,635 23.4
04 INTERGOVERNMENTAL PROGRAMMING 4,425 38,457 62,410 23,953 38.4
Totals 18,922 145,461 202,049 56,588 28.0
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES 14,530 87,763 114,194 26,431 23.1
51 EMPLOYEE BENEFITS 3,911 32,719 44,177 11,458 25.9
52 OTHER EMPLOYEE COSTS 0 725 700 -25 -3.6
54 CONTRACTUAL SERVICES 312 12,250 27,378 15,128 55.3
55 UTILITIES 169 1,287 1,600 313 19.6
57 COMMODITIES & SUPPLIES 0 4,322 5,500 1,178 21.4
67 OTHER EQUIPMENT 0 6,395 8,500 2,105 24.8
Totals 18,922 145,461 202,049 56,588 28.0
SOURCE OF FUNDS
001 GENERAL FUND 18,922 145,461 202,049 56,588 28.0
Totals 18,922 145,461 202,049 56,588 28.0
4
10/14/2010 9 Months ( 75.0% ) Completed
09:14:00 VILLAGE OF MOUNT PROSPECT 3 Months ( 25.0% ) Remaining
FRRDBR01
SUM o31 Department Budget Expenditure Summary
01/01/10 - 09/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
VILLAGE CLERK' S OFFICE Expended Expended Budget Balance Percent
PROGRAM TOTALS
02 VILLAGE CLERK'S OFFICE 22,591 146,616 208,643 62,027 29.7
Totals 22,591 146,616 208,643 62,027 29.7
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES 16,933 98,589 126,804 28,215 22.3
51 EMPLOYEE BENEFITS 4,419 35,416 47,646 12,230 25.7
52 OTHER EMPLOYEE COSTS 65 573 1,485 912 61.4
54 CONTRACTUAL SERVICES 1,090 10,873 29,679 18,806 63.4
55 UTILITIES 84 644 1,549 905 58.4
57 COMMODITIES & SUPPLIES 0 521 1,480 959 64.8
Totals 22,591 146,616 208,643 62,027 29.7
SOURCE OF FUNDS
001 GENERAL FUND 22,591 146,616 208,643 62,027 29.7
Totals 22,591 146,616 208,643 62,027 29.7
5
10/14/2010 9 Months ( 75.0% ) Completed
09.14,00 VILLAGE OF MOUNT PROSPECT 3 Months ( 25.0% ) Remaining
FRRDBR01
s71 Department Budget Expenditure Summary
01 /01 /10 - 09/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
FINANCE DEPARTMENT Expended Expended Budget Balance Percent
PROGRAM TOTALS
01 FINANCE ADMINISTRATION 32,508 241,078 359,820 118,742 33.0
02 ACCOUNTING 51,708 355,206 491,793 136,587 27.8
05 INSURANCE PROGRAMS 28,009 233,476 311,872 78,396 25.1
06 CUSTOMER SERVICE 43,474 299,081 420,812 121,731 28.9
07 CASH MANAGEMENT 3,070 20,719 28,416 7,697 27.1
Totals 158,769 1,149,560 1,612,713 463,153 28.7
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES 96,037 606,860 843,557 236,697 28.1
51 EMPLOYEE BENEFITS 26,156 224,188 312,122 87,934 28.2
52 OTHER EMPLOYEE COSTS 201 3,237 5,650 2,413 42.7
54 CONTRACTUAL SERVICES 16,351 127,603 181,213 53,610 29.6
55 UTILITIES 320 3,257 4,900 1,643 33.5
56 INSURANCE 19,393 174,534 232,711 58,177 25.0
57 COMMODITIES & SUPPLIES 311 9,881 32,160 22,279 69.3
65 OFFICE EQUIPMENT 0 0 400 400 100.0
Totals 158,769 1,149,560 1,612,713 463,153 28.7
SOURCE OF FUNDS
001 GENERAL FUND 158,769 1,149,560 1,612,713 463,153 28.7
Totals 158,769 1,149,560 1,612,713 463,153 28.7
6
10/14/2010 9 Months ( 75.0 ) Completed
09:14:00 VILLAGE OF MOUNT PROSPECT 3 Months ( 25.0% ) Remaining
FRRDBR01
SUM 031 Department Budget Expenditure Summary
01/01/10 - 09/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
COMMUNITY DEVELOPMENT Expended Expended Budget Balance Percent
PROGRAM TOTALS
01 COMMUNITY DEVELOPMENT ADMIN 26,536 196,661 261,596 64,935 24.8
02 PLANNING & ZONING 26,704 191,717 333,616 141,899 42.5
03 ECONOMIC DEVELOPMENT 8,977 70,986 95,383 24,397 25.6
05 BUILDING INSPECTIONS 91,948 634,342 940,912 306,570 32.6
06 HOUSING INSPECTIONS 54,186 377,830 529,946 152,116 28.7
07 HEALTH INSPECTIONS 14,690 92,696 128,093 35,397 27.6
Totals 223,041 1,564,232 2,289,546 725,314 31.7
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES 161,884 1,026,458 1,402,026 375,568 26.8
51 EMPLOYEE BENEFITS 45,753 392,954 541,145 148,191 27.4
52 OTHER EMPLOYEE COSTS 1,038 13,210 31,246 18,036 57.7
54 CONTRACTUAL SERVICES 13,072 115,461 269,117 153,656 57.1
55 UTILITIES 563 8,393 17,671 9,278 52.5
57 COMMODITIES & SUPPLIES 731 7,756 24,141 16,385 67.9
65 OFFICE EQUIPMENT 0 0 4,200 4,200 100.0
Totals 223,041 1,564,232 2,289,546 725,314 31.7
SOURCE OF FUNDS
001 GENERAL FUND 223,041 1,562,732 2,288,046 725,314 31.7
550 DOWNTOWN REDEVLPMNT CONST 0 1,500 1,500 0
Totals 223,041 1,564,232 2,289,546 725,314 31.7
7
10/14/2010 9 Months ( 75.0% ) Completed
09:14:00 VILLAGE OF MOUNT PROSPECT 3 Months ( 25.0W ) Remaining
FRRDBROI
SUM031 Department Budget Expenditure Summary
01 /01 /10 - 09/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
COMMUNITY DEVELOPMENT - CDBG Expended Expended Budget Balance Percent
PROGRAM TOTALS
04 CDBG ADMINISTRATION 6,342 53,406 94,947 41,541 43.8
05 CDBG COMMUNITY PROGRAMS 0 65,907 90,500 24,593 27.2
06 ACCESSIBLTY & NEIGHBRHD IMPRV -672 2,688 100,000 97,312 97.3
07 CDBG RESIDENTIAL REHAB 13,570 52,649 280,000 227,351 81.2
08 CDBG RECOVERY ACT 14,113 96,646 0 - 96,646
Totals 33,353 271,296 565,447 294,151 52.0
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES 6,744 41,757 62,569 20,812 33.3
51 EMPLOYEE BENEFITS 1,911 16,442 23,311 6,869 29.5
52 OTHER EMPLOYEE COSTS 0 85 1,965 1,880 95.7
54 CONTRACTUAL SERVICES 341 78,870 106,625 27,755 26.0
57 COMMODITIES & SUPPLIES 0 94 977 883 90.4
59 OTHER EXPENDITURES 24,357 130,688 200,000 69,312 34.7
62 LAND IMPROVEMENTS 0 0 50,000 50,000 100.0
69 INFRASTRUCTURE 0 3,360 120,000 116,640 97.2
Totals 33,353 271,296 565,447 294,151 52.0
SOURCE OF FUNDS
070 COMMUNITY DEVELPMNT BLOCK GRNT 33,353 271,296 565,447 294,151 52.0
Totals 33,353 271,296 565,447 294,151 52.0
8
10/14/2010 9 Months ( 75.0% ) Completed
09:14:00 VILLAGE OF MOUNT PROSPECT 3 Months ( 25.0% ) Remaining
FRRDBR01
SUM on Department Budget Expenditure Summary
01 /01 /10 - 09/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
HUMAN SERVICES Expended Expended Budget Balance Percent
PROGRAM TOTALS
01 HUMAN SERVICES ADMINISTRATION 16,168 123,099 184,075 60,976 33.1
02 SOCIAL SERVICES 41,687 281,439 389,713 108,274 27.8
03 NURSING /HEALTH SERVICES 25,049 149,039 239,089 90,050 37.7
04 SENIOR CITIZEN LEIS ACTIVITIES 3,093 22,518 35,821 13,303 37.1
05 COMMUNITY CONNECTIONS CENTER 37,555 223,100 306,071 82,971 27.1
Totals 123,552 799,195 1,154,769 355,574 30.8
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES 80,978 512,860 689,812 176,952 25.7
51 EMPLOYEE BENEFITS 21,362 177,461 241,687 64,226 26.6
52 OTHER EMPLOYEE COSTS 0 1,452 12,581 11,129 88.5
54 CONTRACTUAL SERVICES 19,291 91,788 154,168 62,380 40.5
55 UTILITIES 660 7,751 14,756 7,005 47.5
57 COMMODITIES & SUPPLIES 1,261 7,883 39,065 31,182 79.8
64 BUILDING IMPROVEMENTS 0 0 0 0
65 OFFICE EQUIPMENT 0 0 2,700 2,700 100.0
Totals 123,552 799,195 1,154,769 355,574 30.8
SOURCE OF FUNDS
001 GENERAL FUND 123,552 799,195 1,154,769 355,574 30.8
Totals 123,552 799,195 1,154,769 355,574 30.8
9
10/14/2010 9 Months ( 75.0' ) Completed
09:14:00 VILLAGE OF MOUNT PROSPECT 3 Months ( 25.0% ) Remaining
FRRDBR01
SUM o31 Department Budget Expenditure Summary
01 /01 /10 - 09/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
POLICE Expended Expended Budget Balance Percent
PROGRAM TOTALS
01 POLICE ADMINISTRATION 206,665 2,265,548 3,958,608 1,693,060 42.8
02 PATROL & TRAFFIC ENFORCEMENT 869,682 6,234,641 8,946,765 2,712,124 30.3
03 CRIME PREVTN & PUBLIC SERVICES 26,446 197,095 271,910 74,815 27.5
04 INVESTIGATIVE & JUVENILE PRGM 133,563 952,321 1,318,756 366,435 27.8
05 CROSSING GUARDS 3,695 21,452 31,480 10,028 31.9
06 EQUIPMENT MAINTENANCE 35,884 375,926 515,145 139,219 27.0
Totals 1,275,935 10,046,983 15,042,664 4,995,681 33.2
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES 1,048,501 6,730,214 9,490,554 2,760,340 29.1
51 EMPLOYEE BENEFITS 137,477 2,350,303 4,146,442 1,796,139 43.3
52 OTHER EMPLOYEE COSTS 7,286 64,654 140,300 75,646 53.9
54 CONTRACTUAL SERVICES 77,111 803,749 1,080,543 276,794 25.6
55 UTILITIES 1,943 26,069 33,160 7,091 21.4
57 COMMODITIES & SUPPLIES 2,957 58,161 127,315 69,154 54.3
65 OFFICE EQUIPMENT 330 1,847 6,150 4,303 70.0
67 OTHER EQUIPMENT 330 11,986 18,200 6,214 34.1
80 INTERFUND TRANSFERS 0 0 0 0
Totals 1,275,935 10,046,983 15,042,664 4,995,681 33.2
SOURCE OF FUNDS
001 GENERAL FUND 1,275,935 10,038,008 15,038,164 5,000,156 33.2
060 LAW ENFORCEMENT BLOCK GRANT 0 0 0 0
080 ASSET SEIZURE FUND 0 6,118 2,000 -4,118 -205.9
085 DEA SHARED FUNDS FUND 0 2,514 1,000 -1,514 -151.4
086 DUI FINE FUND 0 343 1,500 1,157 77.1
Totals 1,275,935 10,046,983 15,042,664 4,995,681 33.2
in
10/14/2010 9 Months ( 75.0% ) Completed
09:14:00 VILLAGE OF MOUNT PROSPECT 3 Months ( 25.00) Remaining
FRRDBR01
suMo31 Department Budget Expenditure Summary
01 /01 /10 - 09/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
FIRE Expended Expended Budget Balance Percent
PROGRAM TOTALS
01 FIRE ADMINISTRATION 97,305 1,693,277 2,935,025 1,241,748 42.3
02 FIRE DEPARTMENT OPERATIONS 860,954 5,584,588 7,577,769 1,993,181 26.3
03 FIRE TRAINING ACADEMY 0 2,361 14,131 11,770 83.3
04 FIRE PREVENTION 48,856 364,790 603,725 238,935 39.6
05 FIRE COMMUNICATIONS 3,514 32,500 55,611 23,111 41.6
06 EQUIPMENT MAINTENANCE 16,475 148,400 197,950 49,550 25.0
07 EMERGENCY PREPAREDNESS PRGM 2,821 7,439 61,436 53,997 87.9
08 PAID -ON -CALL PROGRAM 2,876 21,234 33,180 11,946 36.0
10 FOREIGN FIRE INSURANCE 44 28,990 15,500 - 13,490 -87.0
Totals 1,032,845 7,883,579 11,494,327 3,610,748 31.4
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES 875,528 5,467,118 7,402,167 1,935,049 26.1
51 EMPLOYEE BENEFITS 96,229 1,941,437 3,333,594 1,392,157 41.8
52 OTHER EMPLOYEE COSTS 10,841 72,550 139,880 67,330 48.1
53 PENSION BENEFITS 0 0 500 500 100.0
54 CONTRACTUAL SERVICES 28,742 298,826 414,665 115,839 27.9
55 UTILITIES 2,720 23,673 38,311 14,638 38.2
57 COMMODITIES & SUPPLIES 7,990 33,633 73,970 40,337 54.5
64 BUILDING IMPROVEMENTS 0 51 3,800 3,749 98.7
65 OFFICE EQUIPMENT 0 0 9,000 9,000 100.0
67 OTHER EQUIPMENT 10,795 46,291 78,440 32,149 41.0
Totals 1,032,845 7,883,579 11,494,327 3,610,748 31.4
SOURCE OF FUNDS
001 GENERAL FUND 1,032,801 7,854,589 11,478,827 3,624,238 31.6
095 FOREIGN FIRE TAX BOARD FUND 44 28,990 15,500 - 13,490 -87.0
Totals 1,032,845 7,883,579 11,494,327 3,610,748 31.4
11
10/14/2010 9 Months ( 75.0t ) Completed
09:14:00 VILLAGE OF MOUNT PROSPECT 3 Months ( 25.0t ) Remaining
FRRDBR01
SUM031 Department Budget Expenditure Summary
01 /01 /10 - 09/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
PUBLIC WORKS - ADMINISTRATION Expended Expended Budget Balance Percent
PROGRAM TOTALS
01 PUBLIC WORKS ADMINISTRATION 88,447 726,027 982,823 256,796 26.1
Totals 88,447 726,027 982,823 256,796 26.1
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES 29,361 175,332 234,319 58,987 25.2
51 EMPLOYEE BENEFITS 13,029 111,406 149,319 37,913 25.4
52 OTHER EMPLOYEE COSTS -60 14,079 25,802 11,723 45.4
54 CONTRACTUAL SERVICES 44,783 400,628 538,489 137,861 25.6
55 UTILITIES 1,079 11,884 19,470 7,586 39.0
57 COMMODITIES & SUPPLIES 255 12,698 15,169 2,471 16.3
65 OFFICE EQUIPMENT 0 0 0 0
67 OTHER EQUIPMENT 0 0 255 255 100.0
Totals 88,447 726,027 982,823 256,796 26.1
SOURCE OF FUNDS
001 GENERAL FUND 88,447 726,027 982,823 256,796 26.1
Totals 88,447 726,027 982,823 256,796 26.1
1)
10/14/2010 9 Months ( 75.0% ) Completed
09:14:00 VILLAGE OF MOUNT PROSPECT 3 Months ( 25.0% ) Remaining
FRRDBR01
SUM031 Department Budget Expenditure Summary
01 /01 /10 - 09/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
PUBLIC WORKS - STREETS /BLDGS Expended Expended Budget Balance Percent
PROGRAM TOTALS
01 STREET DIVISION ADMINISTRATION 29,432 135,831 161,866 26,035 16.1
02 MAINTENANCE - PUBLIC BUILDINGS 93,498 664,044 1,010,405 346,361 34.3
04 STREET MAINTENANCE 75,316 251,033 418,912 167,879 40.1
05 SNOW REMOVAL 16,574 497,796 669,384 171,588 25.6
06 LEAF REMOVAL 0 0 0 0
07 STORM SEWER & BASIN MAINT 9,982 68,591 112,657 44,066 39.1
08 MAINTENANCE OF STATE HIGHWAYS 3,108 48,588 70,394 21,806 31.0
09 TRAFFIC SIGN MAINTENANCE 10,151 86,222 122,044 35,822 29.4
10 VILLAGE PARKING LOT MAINT 11,730 69,761 175,098 105,337 60.2
11 PARKING LOT MAINTENANCE 21,866 106,650 149,597 42,947 28.7
12 FLOOD CONTROL 0 0 0 0
13 STORM EVENT 0 0 0 0
Totals 271,657 1,928,516 2,890,357 961,841 33.3
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES 120,403 892,763 1,246,055 353,292 28.4
51 EMPLOYEE BENEFITS 30,591 268,367 382,210 113,843 29.8
54 CONTRACTUAL SERVICES 104,293 440,171 726,159 285,988 39.4
55 UTILITIES 3,469 27,522 79,230 51,708 65.3
56 INSURANCE 158 1,420 1,894 474 25.0
57 COMMODITIES & SUPPLIES 11,580 268,420 394,954 126,534 32.0
59 OTHER EXPENDITURES 0 0 0 0
64 BUILDING IMPROVEMENTS 0 4,265 19,855 15,590 78.5
67 OTHER EQUIPMENT 0 0 0 0
69 INFRASTRUCTURE 1,163 25,588 40,000 14,412 36.0
Totals 271,657 1,928,516 2,890,357 961,841 33.3
SOURCE OF FUNDS
001 GENERAL FUND 191,077 1,549,087 2,266,230 717,143 31.6
050 MOTOR FUEL TAX FUND 46,984 203,018 299,432 96,414 32.2
620 VILLAGE PARKING SYSTEM FUND 11,730 69,761 175,098 105,337 60.2
630 PARKING SYSTEM REVENUE FUND 21,866 106,650 149,597 42,947 28.7
Totals 271,657 1,928,516 2,890,357 961,841 33.3
13
10/14/2010 9 Months ( 75.00 ) Completed
09:14:00 VILLAGE OF MOUNT PROSPECT 3 Months ( 25.0% ) Remaining
FRRDBR01
SUM o31 Department Budget Expenditure Summary
01 /01 /10 - 09/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
PUBLIC WORKS - FORESTRY /GRNDS Expended Expended Budget Balance Percent
PROGRAM TOTALS
01 FORESTRY DIVISION ADMIN 25,151 170,270 237,763 67,493 28.4
02 MAINTENANCE OF GROUNDS 42,664 298,844 473,321 174,477 36.9
03 FORESTRY PROGRAM 49,953 598,460 1,002,138 403,678 40.3
04 PUBLIC GROUNDS BEAUTIFICATION 4,012 51,408 68,010 16,602 24.4
Totals 121,780 1,118,982 1,781,232 662,250 37.2
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES 85,637 548,832 761,579 212,747 27.9
51 EMPLOYEE BENEFITS 21,330 178,360 246,330 67,970 27.6
52 OTHER EMPLOYEE COSTS 0 3,662 3,662 0
54 CONTRACTUAL SERVICES 13,802 353,409 718,112 364,703 50.8
57 COMMODITIES & SUPPLIES 1,011 34,719 51,549 16,830 32.6
67 OTHER EQUIPMENT 0 0 0 0
Totals 121,780 1,118,982 1,781,232 662,250 37.2
SOURCE OF FUNDS
001 GENERAL FUND 121,780 1,118,982 1,762,432 643,450 36.5
690 RISK MANAGEMENT FUND 0 0 18,800 18,800 100.0
Totals 121,780 1,118,982 1,781,232 662,250 37.2
14
10/14/2010 9 Months ( 75.0 ) Completed
• 09:14:00 VILLAGE OF MOUNT PROSPECT 3 Months ( 25.0% ) Remaining
FRRDBR01
SUM031 Department Budget Expenditure Summary
01/01/10 - 09/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
PUBLIC WORKS - ENGINEERING Expended Expended Budget Balance Percent
PROGRAM TOTALS
01 ENGINEERING SERVICES 93,217 600,529 831,493 230,964 27.8
05 TRAFFIC CNTRL & STREET LGHTNG 33,074 282,917 756,494 473,577 62.6
Totals 126,291 883,446 1,587,987 704,541 44.4
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES 86,001 519,217 701,400 182,183 26.0
51 EMPLOYEE BENEFITS 20,170 153,911 211,200 57,289 27.1
52 OTHER EMPLOYEE COSTS 23 3,012 3,552 540 15.2
54 CONTRACTUAL SERVICES 4,129 57,073 131,796 74,723 56.7
55 UTILITIES 14,297 134,493 225,000 90,507 40.2
57 COMMODITIES & SUPPLIES 1,671 15,740 32,855 17,115 52.1
65 OFFICE EQUIPMENT 0 0 546 546 100.0
67 OTHER EQUIPMENT 0 0 1,638 1,638 100.0
69 INFRASTRUCTURE 0 0 280,000 280,000 100.0
Totals 126,291 883,446 1,587,987 704,541 44.4
SOURCE OF FUNDS
001 GENERAL FUND 110,040 710,830 1,071,117 360,287 33.6
050 MOTOR FUEL TAX FUND 16,251 172,616 516,870 344,254 66.6
Totals 126,291 883,446 1,587,987 704,541 44.4
15
10/14/2010 9 Months ( 75.0$ ) Completed
09:14:00 VILLAGE OF MOUNT PROSPECT 3 Months ( 25.0t ) Remaining
FRRDBROI
SUM o31 Department Budget Expenditure Summary
01 /01 /10 - 09/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
PUBLIC WORKS - WATER /SEWER Expended Expended Budget Balance Percent
PROGRAM TOTALS
01 WATER & SEWER DIVISION ADMIN 119,558 990,457 1,415,111 424,654 30.0
02 MAINTENANCE OF BUILDINGS 23,224 181,591 284,997 103,406 36.3
03 MAINTENANCE OF GROUNDS 7,849 83,710 136,428 52,718 38.6
04 WATER SUPPLY MAINT & REPAIR 65,181 512,858 1,585,848 1,072,990 67.7
05 WATER DISTRBT MAINT & REPAIR 64,504 443,895 868,982 425,087 48.9
06 WATER VALVE /HYDRNT MAINT & REP 37,949 264,434 413,162 148,728 36.0
07 WATER METER MAINT & REPL 29,194 200,907 963,266 762,359 79.1
08 EQUIPMENT MAINTENANCE 42,889 386,001 514,668 128,667 25.0
09 SANITARY SEWER MAINT & REPAIR 33,726 373,634 1,021,772 648,138 63.4
10 WATER & SEWER SYSTEM IMPROV 482,694 900,755 2,315,515 1,414,760 61.1
12 LAKE MICHIGAN WATER SUPPLY 325,124 2,488,119 4,030,000 1,541,881 38.3
Totals 1,231,892 6,826,361 13,549,749 6,723,388 49.6
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES 199,915 1,338,388 1,900,352 561,964 29.6
51 EMPLOYEE BENEFITS 55,131 477,129 671,563 194,434 29.0
52 OTHER EMPLOYEE COSTS 224 20,704 57,336 36,632 63.9
54 CONTRACTUAL SERVICES 515,137 3,898,017 6,260,726 2,362,709 37.7
55 UTILITIES 8,822 116,473 185,406 68,933 37.2
56 INSURANCE 5,524 49,722 66,295 16,573 25.0
57 COMMODITIES & SUPPLIES 29,248 167,292 291,120 123,828 42.5
59 OTHER EXPENDITURES 0 0 0 0
65 OFFICE EQUIPMENT 0 220 7,652 7,432 97.1
67 OTHER EQUIPMENT 5,467 52,266 1,238,953 1,186,687 95.8
68 DISTRIBUTION SYSTEMS 412,424 706,150 2,870,346 2,164,196 75.4
Totals 1,231,892 6,826,361 13,549,749 6,723,388 49.6
SOURCE OF FUNDS
610 WATER AND SEWER FUND 1,231,892 6,826,361 13,549,749 6,723,388 49.6
Totals 1,231,892 6,826,361 13,549,749 6,723,388 49.6
16
10/14/2010 9 Months ( 75.00 ) Completed
09:14:00 VILLAGE OF MOUNT PROSPECT 3 Months ( 25.00 ) Remaining
FRRDBR01
SUM 031 Department Budget Expenditure Summary
01/01/10 - 09/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
PUBLIC WORKS - REFUSE DISPOSAL Expended Expended Budget Balance Percent
PROGRAM TOTALS
01 REFUSE DISPOSAL PROGRAM 334,314 2,764,699 4,019,373 1,254,674 31.2
02 REFUSE LEAF REMOVAL PROGRAM 19,640 105,792 221,568 115,776 52.3
Totals 353,954 2,870,491 4,240,941 1,370,450 32.3
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES 24,083 142,309 251,942 109,633 43.5
51 EMPLOYEE BENEFITS 6,064 49,019 77,148 28,129 36.5
52 OTHER EMPLOYEE COSTS 0 0 1,200 1,200 100.0
54 CONTRACTUAL SERVICES 316,634 2,648,303 3,853,608 1,205,305 31.3
55 UTILITIES 34 257 572 315 55.1
56 INSURANCE 1,895 17,051 22,734 5,683 25.0
57 COMMODITIES & SUPPLIES 5,244 13,552 33,737 20,185 59.8
Totals 353,954 2,870,491 4,240,941 1,370,450 32.3
SOURCE OF FUNDS
030 REFUSE DISPOSAL FUND 353,954 2,870,491 4,240,941 1,370,450 32.3
Totals 353,954 2,870,491 4,240,941 1,370,450 32.3
17
10/14/2010 9 Months ( 75.0' ) Completed
09:14:00 VILLAGE OF MOUNT PROSPECT 3 Months ( 25.0t ) Remaining '
FRRDBR01
SUM 031 Department Budget Expenditure Summary
01 /01 /10 - 09/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
PUBLIC WORKS - VEHICLE MAINT Expended Expended Budget Balance Percent
PROGRAM TOTALS
01 VEHICLE MAINTENANCE ADMIN 24,810 142,084 180,836 38,752 21.4
02 VEHICLE MAINTENANCE PROGRAM 147,218 1,155,243 1,633,875 478,632 29.3
Totals 172,028 1,297,327 1,814,711 517,384 28.5
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES 96,411 634,449 879,792 245,343 27.9
51 EMPLOYEE BENEFITS 25,860 215,570 301,789 86,219 28.6
52 OTHER EMPLOYEE COSTS 25 2,159 2,315 156 6.7
54 CONTRACTUAL SERVICES 10,808 51,867 95,738 43,871 45.8
55 UTILITIES 84 644 993 349 35.1
57 COMMODITIES & SUPPLIES 38,840 392,559 530,039 137,480 25.9
59 OTHER EXPENDITURES 0 0 0 0
65 OFFICE EQUIPMENT 0 0 545 545 100.0
67 OTHER EQUIPMENT 0 79 3,500 3,421 97.7
Totals 172,028 1,297,327 1,814,711 517,384 28.5
SOURCE OF FUNDS
660 VEHICLE MAINTENANCE FUND 172,028 1,297,327 1,814,711 517,384 28.5
Totals 172,028 1,297,327 1,814,711 517,384 28.5
18
10/14/2010 9 Months ( 75.0% ) Completed
09:14:00 VILLAGE OF MOUNT PROSPECT 3 Months ( 25.0% ) Remaining
FRRDBR01
SUM 031 Department Budget Expenditure Summary
01 /01 /10 - 09/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
COMMUNITY SERVICE PROGRAMS Expended Expended Budget Balance Percent
PROGRAM TOTALS
02 COMMUNITY GROUPS & MISC 3,953 84,662 136,400 51,738 37.9
03 4TH OF JULY & CIVIC EVENTS,ETC 4,788 145,731 167,252 21,521 12.9
04 HOLIDAY DECORATIONS 939 17,290 81,330 64,040 78.7
05 BLOOD DONOR PROGRAM 261 2,008 2,774 766 27.6
Totals 9,941 249,691 387,756 138,065 35.6
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES 890 91,009 100,731 9,722 9.7
51 EMPLOYEE BENEFITS 215 13,490 18,660 5,170 27.7
54 CONTRACTUAL SERVICES 7,806 106,382 207,785 101,403 48.8
57 COMMODITIES & SUPPLIES 1,030 38,810 52,580 13,770 26.2
59 OTHER EXPENDITURES 0 0 8,000 8,000 100.0
Totals 9,941 249,691 387,756 138,065 35.6
SOURCE OF FUNDS
001 GENERAL FUND 9,941 249,691 387,756 138,065 35.6
Totals 9,941 249,691 387,756 138,065 35.6
19
10/14/2010 9 Months ( 75.0' ) Completed
09 :14:00 VILLAGE OF MOUNT PROSPECT 3 Months ( 25. o% ) Remaining
FRRDBR01
SUM031 Department Budget Expenditure Summary
01 /01 /10 - 09/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
CAPITAL IMPROVEMENT PROJECTS Expended Expended Budget Balance Percent
PROGRAM TOTALS
01 VILLAGE IMPROVEMENTS & EQUIP 67,226 668,949 1,829,500 1,160,551 63.4
02 COMMUNITY IMPROVEMENT PROJECTS 1,807 29,431 155,765 126,334 81.1
03 DOWNTOWN REDEVELOPMENT CONST 24,922 1,366,642 2,735,000 1,368,358 50.0
04 FLOOD CONTROL PROJECTS 11,209 19,726 161,425 141,699 87.8
06 STREET IMPROVEMENT PROJECTS 29,141 1,714,056 2,665,880 951,824 35.7
09 MOTOR EQUIPMENT REPLACEMENT 29,356 745,074 810,000 64,926 8.0
10 COMPUTER REPLACEMENT 6,138 174,085 206,050 31,965 15.5
11 STATION 14 3,968 2,358,441 1,380,963 - 977,478 -70.8
12 EMERGENCY OPERATION CENTER 2,000 225,309 456,741 231,432 50.7
13 PUBLIC WORKS EXPANSION 7,208 393,078 345,929 - 47,149 -13.6
Totals 182,975 7,694,791 10,747,253 3,052,462 28.4
EXPENDITURE CLASSIFICATION
54 CONTRACTUAL SERVICES 65,363 503,833 1,005,820 501,987 49.9
59 OTHER EXPENDITURES 0 1,152,767 2,420,150 1,267,383 52.4
62 LAND IMPROVEMENTS 0 0 26,065 26,065 100.0
64 BUILDING IMPROVEMENTS 23,984 2,680,656 1,237,003 - 1,443,653 -116.7
65 OFFICE EQUIPMENT 6,138 252,431 438,050 185,619 42.4
66 MOBILE EQUIPMENT 29,356 745,074 810,000 64,926 8.0
67 OTHER EQUIPMENT 36,508 577,905 1,741,150 1,163,245 66.8
69 INFRASTRUCTURE 21,626 1,782,125 3,069,015 1,286,890 41.9
71 BOND PRINCIPAL 0 0 0 0
72 INTEREST EXPENSE 0 0 0 0
80 INTERFUND TRANSFERS 0 0 0 0
Totals 182,975 7,694,791 10,747,253 3,052,462 28.4
SOURCE OF FUNDS
050 MOTOR FUEL TAX FUND 0 920,000 920,000 0
510 CAPITAL IMPROVEMENT FUND 70,336 745,394 2,130,265 1,384,871 65.0
528 SERIES 2009 CONST FUND 13,176 2,977,114 2,183,633 - 793,481 -36.3
550 DOWNTOWN REDEVLPMNT CONST 24,922 1,366,642 2,735,000 1,368,358 50.0
560 STREET IMPROVEMENT CONST FUND 27,838 746,756 1,575,880 829,124 52.6
590 FLOOD CONTROL CONST FUND 11,209 19,726 161,425 141,699 87.8
630 PARKING SYSTEM REVENUE FUND 0 0 25,000 25,000 100.0
670 VEHICLE REPLACEMENT FUND 29,356 745,074 810,000 64,926 8.0
680 COMPUTER REPLACEMENT FUND 6,138 174,085 206,050 31,965 15.5
Totals 182,975 7,694,791 10,747,253 3,052,462 28.4
20
10/14/2010 9 Months ( 75.0% ) Completed
. 09:14:00 VILLAGE OF MOUNT PROSPECT 3 Months ( 25.0% ) Remaining
FRRDBROI
SUM031 Department Budget Expenditure Summary
01/01/10 - 09/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
DEBT SERVICE Expended Expended Budget Balance Percent
PROGRAM TOTALS
02 DEBT SERVICE - PROPERTY TAXES 0 507,112 1,712,524 1,205,412 70.4
03 DEBT SERVICE - TAX INCREMENT 0 0 0 0
04 DEBT SERVICE - H/R SALES TAX 1 0 326,320 613,356 287,036 46.8
06 SPECIAL SERVICE AREA B & I 0 0 0 0
Totals 0 833,432 2,325,880 1,492,448 64.2
EXPENDITURE CLASSIFICATION
54 CONTRACTUAL SERVICES 0 0 0 0
59 OTHER EXPENDITURES 0 0 0 0
71 BOND PRINCIPAL 0 273,553 1,271,204 997,651 78.5
72 INTEREST EXPENSE 0 558,701 1,053,076 494,375 46.9
73 BANK AND FISCAL FEES 0 1,178 1,600 422 26.4
80 INTERFUND TRANSFERS 0 0 0 0
81 OTHER FINANCING USES 0 0 0 0
Totals 0 833,432 2,325,880 1,492,448 64.2
SOURCE OF FUNDS
140 SERIES 1987A B &I, PW FACILITY 0 0 0 0
180 SERIES 2001 B &I, VILLAGE HALL 0 150 382,203 382,053 100.0
190 SERIES 2003 B &I, VILLAGE HALL 0 191,628 912,658 721,030 79.0
195 SERIES 2009 B &I, FD /PW 0 209,059 417,663 208,604 49.9
196 2009B B &I, FD /PW 0 46,640 0 - 46,640
197 2009C B &I, FD /PW 0 59,635 0 - 59,635
290 SERIES 1999 B &I, TIF 0 0 0 0
340 SERIES 1996A B &I, FLOOD 0 0 0 0
350 SERIES 1998A B &I, FLOOD 0 0 0 0
360 SERIES 1998C B &I, TIF 0 0 0 0
380 IEPA FLOOD CONTROL LOANS B &I 0 326,320 613,356 287,036 46.8
390 SERIES 2000 B &I, FLOOD CONTROL 0 0 0 0
830 SSA #6 GEORGE /ALBERT B &I 0 0 0 0
Totals 0 833,432 2,325,880 1,492,448 64.2
21
10/14/2010 9 Months ( 75.0% ) Completed
09:14:00 VILLAGE OF MOUNT PROSPECT 3 Months ( 25.0% ) Remaining
FRRDBROI
SUM 031 Department Budget Expenditure Summary
01/01/10 - 09/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
RETIREE PENSIONS Expended Expended Budget Balance Percent
PROGRAM TOTALS
01 MISCELLANEOUS PENSIONS 3,811 34,293 46,600 12,307 26.4
02 POLICE PENSIONS 281,419 2,545,105 3,242,300 697,195 21.5
03 FIRE PENSIONS 257,225 2,370,112 3,121,500 751,388 24.1
Totals 542,455 4,949,510 6,410,400 1,460,890 22.8
EXPENDITURE CLASSIFICATION
53 PENSION BENEFITS 542,455 4,948,034 6,404,400 1,456,366 22.7
54 CONTRACTUAL SERVICES 0 1,350 4,500 3,150 70.0
57 COMMODITIES & SUPPLIES 0 126 1,500 1,374 91.6
Totals 542,455 4,949,510 6,410,400 1,460,890 22.8
SOURCE OF FUNDS
001 GENERAL FUND 3,811 34,293 46,600 12,307 26.4
710 POLICE PENSION FUND 281,419 2,545,105 3,242,300 697,195 21.5
720 FIRE PENSION FUND 257,225 2,370,112 3,121,500 751,388 24.1
Totals 542,455 4,949,510 6,410,400 1,460,890 22.8
22
10/14/2010 9 Months ( 75.0% ) Completed
09:14:00 VILLAGE OF MOUNT PROSPECT 3 Months ( 25.0t ) Remaining
FRRDBR01
SUM031 Department Budget Expenditure Summary
01/01/10 - 09/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
RISK MANAGEMENT Expended Expended Budget Balance Percent
PROGRAM TOTALS
01 CASUALTY & PROPERTY INSURANCE 54,702 823,477 927,700 104,223 11.2
02 MEDICAL INSURANCE 463,577 3,984,710 5,925,898 1,941,188 32.8
Totals 518,279 4,808,187 6,853,598 2,045,411 29.8
EXPENDITURE CLASSIFICATION
54 CONTRACTUAL SERVICES 0 0 2,000 2,000 100.0
56 INSURANCE 518,279 4,808,187 6,851,598 2,043,411 29.8
67 OTHER EQUIPMENT 0 0 0 0
Totals 518,279 4,808,187 6,853,598 2,045,411 29.8
SOURCE OF FUNDS
690 RISK MANAGEMENT FUND 518,279 4,808,187 6,853,598 2,045,411 29.8
Totals 518,279 4,808,187 6,853,598 2,045,411 29.8
23
10/14/2010 9 Months ( 75.0% ) Completed
09:14:00 VILLAGE OF MOUNT PROSPECT 3 Months ( 25.0% ) Remaining
FRRDBRO1
SUM 031 Department Budget Expenditure Summary
01 /01 /10 - 09/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
NON - DEPARTMENTAL Expended Expended Budget Balance Percent
PROGRAM TOTALS
01 CONTINGENCIES 0 0 0 0
Totals 0 0 0 0
EXPENDITURE CLASSIFICATION
80 INTERFUND TRANSFERS 0 0 0 0
Totals 0 0 0 0
SOURCE OF FUNDS
001 GENERAL FUND 0 0 0 0
Totals 0 0 0 0
24
10/14/2010 9 Months ( 75.0t ) Completed
09:14:00 VILLAGE OF MOUNT PROSPECT 3 Months ( 25.0t ) Remaining
FRRDBRO 1
SUM 031 Department Budget Expenditure Summary
01 /01 /10 - 09/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
CAPITAL, FIXED ASSETS Expended Expended Budget Balance Percent
PROGRAM TOTALS
00 CAPITAL FIXED ASSETS 0 0 0 0
Totals 0 0 0 0
EXPENDITURE CLASSIFICATION
59 OTHER EXPENDITURES 0 0 0 0
Totals 0 0 0 0
SOURCE OF FUNDS
910 GENERAL FIXED ASSETS ACCT GP 0 0 0 0
Totals 0 0 0 0
25
10/14/2010 9 Months ( 75.0' ) Completed
09:14:00 VILLAGE OF MOUNT PROSPECT 3 Months ( 25.0' ) Remaining '
FRRDBRO1
SUM 031 Department Budget Expenditure Summary
01 /01 /10 - 09/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
MOUNT PROSPECT LIBRARY Expended Expended Budget Balance Percent
PROGRAM TOTALS
02 LIBRARY SERVICES 0 0 9,715,689 9,715,689 100.0
Totals 0 0 9,715,689 9,715,689 100.0
EXPENDITURE CLASSIFICATION
90 COMPONENT UNIT EXPENDITURES 0 0 9,715,689 9,715,689 100.0
Totals 0 0 9,715,689 9,715,689 100.0
SOURCE OF FUNDS
950 MOUNT PROSPECT LIBRARY FUND 0 0 9,715,689 9,715,689 100.0
Totals 0 0 9,715,689 9,715,689 100.0
26
., VILLAGE OF MOUNT PROSPECT
List of Bills
October 1 to October 13, 2010
Fund Vendor Name Invoice Description Amount
001 - General Fund
Addison Building Material Co. Maintenance and repair supplies $ 70.71
Addison Building Material Co. Plumbing Supplies 17.26
Alexander Equip.co., Inc. Maintenance Supplies 107.15
American Landscaping Inc. Grass Cutting - 704 Wilshire 198.00
American Landscaping Inc. Grass Cutting - 120 5 Kenilworth 198.00
American Planning Association Membership 1/1/11- 12/31/11 560.00
American Planning Association Membership 1/1/1142/31/11 666.00
Brian Simmons Reimb Exp 9/21- 9/24/10 480.84
CDW Government, Inc. Software 146.60
CDW Government, Inc. Equipment for Repairs 346.61
CDW Government, Inc. Smartnets 1,100.00
CDW Government, Inc. 1 GB RAM 58.56
CDW Government, Inc. BES Maintenance 1,505.00
Century Cleaners Uniform Cleaning 162.12
Chicago Comm. Service, Inc. Radio / VRM Maintenance 1,903.95
Chicago Metro Chapter Apwa Training 160.00
CL Graphics, Inc. Newsletter Printing 8,325.00
CL Graphics, Inc. Fall Newsletter - Mailing Services 350.00
Clare O'shea Registration 11 /10- 11/11/10 415.00
David G. Eterno adjudication 375.00
Everbank Commercial Finance, Inc. Rental 10/23/10 2,144.03
Everbank Commercial Finance, Inc. Rental 10/24/10 396.90
Federal Express Corp Shipping for Planning Division 5.11
Fran Guziel September /October Marketing Svs 2,640.00
Friendly Farms Ltd Civic Events 650.00
GE Capital SERVICE 9/15/10- 10/14/10 795.78
Headsets.com, Inc. Headset Building Clerk Supervisor 392.85
Healy Asphalt Company,llc. Patching Materials 122.65
Heart Printing Inc. PHS Seat Belt Enforcement 120.00
HSBC Business Solutions Sep -10 378.40
Inside The Tape Training 275.00
Intn'I Institute of Municipal Clerks Membership 2011 250.00
Klein, Thorpe and lenkins,ltd. Legal Service August 2010 39,293.07
Lexisnexis Risk Data Managment Inc. Background checks 54.45
Lyon Financial Services, Inc. 10/20/2010 USAGE 1,362.28
Menards Maintenance Supplies & Materials 14.71
Michael Schuster CDL Reimbursement 30.00
Mobile Print Inc. Fallfest /Oktoberfest Printing 266.40
Mobile Print Inc. Building Inspection Door Hangers 89.00
Mobile Print Inc. EDC Breakfast Invites & Postage 957.10
Moise, Brian Reimb Exp 9/20- 9/22/10 24.00
Nagurski Kiddie Rides, Inc. Civic Events 550.00
Petty Cash Petty Cash 092710 128.05
Roland Thilmany Sidewalk Reimbursement 330.00
Ronco Industrial Supply Shelving -CCC 467.00
Samantha Raphael Edit Service ExMPTV Show 240.00
Sandra M. Clark Reimbursement 45.00
Sound Incorporated Telephone System Maintenance 828.23
Sound Incorporated Syn -Apps Annual Maint through 10/2/11 5,495.00
Systems Forms, Inc. 1,000 Food Inspection Forms 354.25
Systems Forms, Inc. 1,000 Field Inspection Forms 293.36
Systems Forms, Inc. 1,000 Rental License Inspection Form 307.40
Systems Forms, Inc. Findings Decision & Order 500 152.75
Page 1 of 3
VILLAGE OF MOUNT PROSPECT
List of Bills
October 1 to October 13, 2010
Fund Vendor Name Invoice Description Amount
Systems Forms, Inc. 500 Appearance Form 152.75
Tweedie, Bart Reimb Exp 9/15- 9/17/10 53.00
Uline Inc. ET Storage Supplies 654.51
Wal -Mart Community Maintenance Supplies 149.00
Weissberg, Andrea Reimb Exp 9/21- 9/23/10 24.00
William J. Cooney Reimb Mileage 7/1/10- 10/5/10 171.80
William Rainey Harper College Office 2007 Training 3,600.00
William Rainey Harper College Excel 2007 5,700.00
William W. Stenzel TSR Analysis Jan 2010 -June 2010 5,000.00
Total: 001- General Fund $ 92,103.63
020 - Capital Improvement Fund
CDW Government, Inc. Cash Drawers $ 565.08
CDW Government, Inc. 3 Cash Receipt Printers& Code Scanners 2,998.21
Total: 020 - Capital Improvement Fund $ 3,563.29
023 - Street Improvement Construc Fund
Arrow Road Construction Street Improvements $ 341,935.85
Traffic and Parking Control Co, Inc. Engineering Supplies & Materials 516.50
Total: 023 - Street Improvement Construc Fund $ 342,452.35
042 - Cmmty Development Block Grant
Everbank Commercial Finance, Inc. Rental 10/23/10 $ 16.80
GE Capital Service 9/15/10- 10/14/10 198.94
Klein, Thorpe and Jenkins,ltd. Legal Service August 2010 4,011.30
Total: 042 - Cmmty Development Block Grant $ 4,227.04
050 - Water and Sewer Fund
Alexian Brothers Medical Centr Random DOT Drug /Alcohol Screening $ 490.00
Baxter & Woodman, Inc. Professional Services 6,600.00
Century Cleaners Uniform Cleaning 162.13
Exelon Corporation Electrical Service Delivery 3,312.80
Lyon Financial Services, Inc. 10/20/2010 Usage 137.50
Prosafety, Inc. Maintenance Supplies 58.80
Red Wing Shoe Store Safety Shoes 144.49
Smith Ecological Systems, Inc. Water Treatment Chemicals 43.43
Smith Ecological Systems, Inc. Water Treatment Chemicals 61.33
Tank Industry Consultants, Inc. Professional Services 2,500.00
UPS Store #707 Shipping Charges 15.55
Total: 050 - Water and Sewer Fund $ 13,526.03
060 - Vehicle Maintenance Fund
Addison Building Material Co. Auto Parts $ 9.70
Arlington Heights Ford Auto Parts 41.28
Arlington Heights Ford Auto Parts 90.25
Arlington Heights Ford Auto Parts 55.65
Bowman Distribution Center Shop Supplies 58.44
Certified Power Inc Auto Parts 250.09
Fire Service, Inc. Auto Parts 525.49
Hoskins Chevrolet, Inc. Auto Parts 37.45
Just Tires Auto Parts 1,036.80
Morton Grove Automotive Auto Repairs 185.00
Morton Grove Automotive Auto Repairs 300.00
Morton Grove Automotive Auto Parts 275.00
Motion Ind. Inc. Auto Parts 16.36
Napa- heights Automotive Supply Auto Parts 11.94
Page 2 of 3
VILLAGE OF MOUNT PROSPECT
List of Bills
October 1 to October 13, 2010
Fund Vendor Name Invoice Description Amount
Pomp's Tire Service, Inc. Auto Repairs 64.00
Pomp's Tire Service, Inc. Auto Parts 54.00
Precision Service & Parts Auto Parts 1,051.96
Precision Service & Parts Auto Parts 14.45
Standard Equipment Company Auto Parts 425.11
Texor Fuel Purchase 20,819.58
Wholesale Direct Inc. Shop Supplies 49.57
Woodfield Chevrolet, Inc. Auto Parts 141.94
Total: 060 - Vehicle Maintenance Fund $ 25,514.06
061 - Vehicle Replacement Fund
Redistrip Company Auto Repairs & Parts $ 1,375.00
Total: 061- Vehicle Replacement Fund $ 1,375.00
063 - Risk Management Fund
High -Level Excess Liability Pool 2nd Payment $ 38,376.00
Total: 063 - Risk Management Fund $ 38,376.00
072 - Flexcomp Escrow Fund
Guardian Emp. Dental Plan October 2010 $ 8,063.32
Total: 072 - Flexcomp Escrow Fund $ 8,063.32
073 - Escrow Deposit Fund
NCPERS Group Life Ins. Premium - October 2010 $ 16.00
NCPERS Group Life Ins. Premium - October 2010 736.00
Third District Circuit Court Bond Money 10/5/10 1,660.00
Third District Circuit Court Bond Money 10/07/10 225.00
Third District Circuit Court Bond Check 101310 2,150.00
Total: 073 - Escrow Deposit Fund $ 4,787.00
Grand Total: $ 533,987.72
Page 3 of 3