06 - June 2018 Monthly Financial ReportVILLAGE
OAK BROOK
OF
MONTHLY FINANCIAL REPORTS
JUNE 2018
ITEM 6.E
Total
Cash and Cash Pooled Cash and
Fund Equivalents Investments Investments % By Fund
General Corporate $6,759,847 $12,181,004 $18,940,851 44.3%
Hotel/Motel Tax 1,712,478 2,685,902 4,398,380 10.3%
Motor Fuel Tax 258,280 411,286 669,566 1.6%
Infrastructure 6,554,076 3,343,139 9,897,215 23.2%
Promenade TIF 273,621 - 273,621 0.6%
Water 3,489,770 1,489,349 4,979,118 11.6%
Sports Core 451,661 - 451,661 1.1%
Golf Surcharge 51,417 555,698 607,115 1.4%
Self-Insurance 277,029 - 277,029 0.6%
Garage 385,542 - 385,542 0.9%
Equipment Replacement 818,930 1,051,022 1,869,951 4.4%
Total $21,032,650 $21,717,400 $42,750,050 100.0%
Change in Cash and Investments by Fund :
Balance at Balance at Year-to-Date Year-to-Date
Fund January 1, 2018 June 30, 2018 Change ($)Change (%)
General Corporate $17,679,496 $18,940,851 $1,261,355 7.1%
Hotel/Motel Tax 4,172,234 4,398,380 226,147 5.4%
Motor Fuel Tax 574,460 669,566 95,106 16.6%
Infrastructure 8,222,145 9,897,215 1,675,070 20.4%
Promenade TIF 276,164 273,621 (2,543)-0.9%
Water 5,693,109 4,979,118 (713,991)-12.5%
Sports Core 472,473 451,661 (20,813)-4.4%
Golf Surcharge 559,073 607,115 48,042 8.6%
Self-Insurance 45,042 277,029 231,986 515.0%
Garage 427,409 385,542 (41,867)-9.8%
Equipment Replacement 1,805,752 1,869,951 64,200 3.6%
$39,927,358 $42,750,050 $2,822,692 7.1%
Book Market
Value Value
Pooled Checking $1,217,374 $1,217,374
Sports Core Checking 502,129 502,129
Pooled IPTIP 19,247,216 19,247,216
Water E-Pay IPTIP 65,931 65,931
$21,032,650 $21,032,650
Pooled Investments:
Investments-Municipal Bonds $9,133,557 $9,019,602
Investments-Corporate Bonds 4,724,692 4,717,669
Government & Agency Obligations 776,861 745,894
Certificates of Deposit 6,965,000 6,892,947
Accrued Interest 117,290 117,290
Total Pooled Investments $21,717,400 $21,493,403
Total Cash and Investments $42,750,050 $42,526,053
For June, total interest revenue is $64,655 and YTD interest revenue is $346,666.
Total investment yield for the portfolio is:
Pooled
Investments Illinois Funds Total
Monthly yield 0.16%0.17%0.16%
YTD yield 0.90%0.85%0.88%
Last 12 months yield 1.69%1.37%1.55%
The weighted average yield of the current pooled investment portfolio is 1.87%.
Monthly Treasurer's Report
June 30, 2018
Monthly Treasurer's Report
June 2018
The table below lists the detail investment holdings at J.P. Morgan Securities as of 6/30/18:
Month End VOB
Settlement Maturity Coupon Yield Book Market Accrued
Type Date Date Rate Rate Value Value Interest
Municipal Bonds:
Florida Hurricane #34074GDG6 01/05/15 7/1/2018 2.107%2.090%$750,000 $750,000 $7,888
Maryland St Econ Dev #57420PGK6 07/08/15 6/1/2019 2.050%2.123%99,933 99,593 169
Rosemont IL GO Corp #777543UT4 02/08/16 12/1/2019 3.021%2.000%507,066 498,455 1,163
New York N Y City #64971QTX1 02/22/16 5/1/2021 2.350%2.000%201,911 196,574 769
Florida Hurricane #34074GDH4 03/30/16 7/1/2020 2.995%2.150%508,173 501,410 7,487
Bloomingdale Mich Pub Sch Dist #094383FS0 04/26/16 5/1/2022 2.710%2.150%510,231 490,795 2,219
Milan Mich Area Achs #598801JD1 05/26/16 5/1/2020 1.931%1.931%245,000 241,511 688
Indiana Bd Bk Rev Taxable #4546248F7 01/06/17 1/15/2020 2.934%1.900%258,959 255,995 3,463
North Carolina Eastn Mun PWR #65819WAC7 01/30/17 7/1/2018 2.003%1.450%700,000 700,000 7,011
Garland Cnty Ark Sales & Use #36609PAN3 02/06/17 11/1/2019 1.795%1.840%499,702 494,730 1,621
Anchor Bay Mich Sch Dist GO #032879TA6 02/13/17 5/1/2019 1.810%1.420%366,182 362,777 1,024
Macomb Cnty Mich Retirees #554885H63 04/11/17 11/1/2018 1.731%1.300%400,574 399,328 1,111
Lanse Creuse Mich Pub Schs #516228RL9 05/02/17 5/1/2020 2.159%2.159%100,000 99,068 358
California St GO Bonds #13063A7G3 05/08/17 10/1/2019 6.200%1.600%528,460 522,530 7,468
*Genesee Cnty Mich #371608UV0 05/31/17 10/1/2019 2.507%2.507%366,000 366,032 960
Connecticut St GO Bds 2016 #20772J3F7 06/15/17 8/15/2021 1.750%2.300%491,750 476,875 3,252
North Carolina Eastn Mun Pwr #65819WAL7 10/02/17 7/1/2019 2.578%1.700%504,360 499,950 6,302
Fowlerville Mich Comnty Schs #351280MS8 10/03/17 5/1/2020 2.045%1.750%502,663 494,150 1,534
Racine Cnty WI #749845UK7 12/20/17 12/1/2020 2.150%2.150%750,000 733,658 1,344
Wisconsin St Gen Fd Annual #977100CW4 01/05/18 5/1/2020 1.446%2.100%592,937 586,830 1,350
Illinois St G/O #452152HU8 04/03/18 3/1/2019 5.877%3.000%249,657 249,341 4,680
Total Municipal Bonds $9,133,557 $9,019,602 $61,858
Corporate Bonds:
Goldman Sachs #38147MAA3 01/25/18 7/19/2018 2.900%1.752%$845,493 $845,186 $10,959
American Honda Finance Corp #02665WAC5 01/25/18 10/10/2018 2.125%1.809%1,000,852 999,120 4,722
JP Morgan Securities #44640QKV2 02/01/18 10/29/2018 2.082%2.082%1,489,708 1,487,978 0
Wells Fargo #94974BFQ8 04/25/18 1/15/2019 2.150%2.330%1,388,638 1,385,385 13,697
Total Corporate Bonds $4,724,692 $4,717,669 $29,379
Government & Agency Obligations:
**Government National Mtg Assn #38379UEM4 02/29/16 2/16/2051 2.300%2.245%$776,861 $745,894 $2,096
Total Government & Agency Obligations:$776,861 $745,894 $2,096
Certificates of Deposit:
Capital One Natl Assn VA #14042E5Z9 08/26/15 8/27/2018 1.750%1.750%$245,000 $244,904 $1,903
Ally Bk Midvale Utah #02006LVC4 10/29/15 10/29/2018 1.600%1.600%245,000 244,718 659
Wex Bank Midvale Utah #92937CDY1 07/29/16 7/30/2018 1.000%1.000%245,000 244,829 1,024
Bank Hope Los Angeles #062683AB3 08/26/16 8/27/2018 1.000%1.000%245,000 244,606 28
Wells Fargo Bank Natl Assn #949763AL0 08/31/16 8/31/2018 1.100%1.100%245,000 244,586 238
BMW Bank #05580AFG4 09/23/16 9/24/2018 1.100%1.100%245,000 244,385 737
Comenity Cap Bank #20033ASB3 09/26/16 9/26/2018 1.100%1.100%245,000 244,383 35
Enerbank #29266N4E4 10/21/16 10/22/2018 1.100%1.100%245,000 244,287 528
Discover Bank #254672L71 10/26/16 10/26/2018 1.200%1.200%245,000 244,118 535
State Bk India NY #8562846A7 01/26/17 1/26/2022 2.250%2.250%245,000 238,231 2,374
Marlin Business Bk #57116ANU8 05/10/17 11/12/2019 1.600%1.600%245,000 241,896 222
American Express Fed Svgs #02587CER7 05/10/17 11/12/2019 1.700%1.700%245,000 242,038 590
Synchrony Bank #87164WRA8 05/26/17 5/28/2019 1.650%1.650%245,000 243,454 371
Umpqua Bank #90421MAG8 05/31/17 5/31/2019 1.600%1.600%245,000 243,327 338
Stone Bk Mtn View Ark #86158RAJ8 06/28/17 6/28/2019 1.600%1.600%245,000 243,116 22
TIAA FSB Jacksonville #87270LAA1 07/19/17 7/19/2019 1.600%1.600%245,000 242,954 1,748
Peoples United Bank #71270QQZ2 07/19/17 7/19/2019 1.650%1.650%245,000 243,082 1,803
Priority Bank Ozark Ark #74269KBR6 07/26/17 7/26/2019 1.600%1.600%245,000 242,886 50
American Express Centurion #02587DV96 08/15/17 8/17/2020 1.900%1.900%245,000 239,524 1,727
Sallie Mae #795450C86 08/16/17 8/17/2020 1.900%1.900%245,000 240,272 1,727
Merrick Bank South Jordan #59013JZS1 08/21/17 8/21/2020 1.800%1.800%245,000 239,708 124
Pinnacle Bank #72345SFS5 08/30/17 8/31/2020 1.800%1.800%115,000 112,476 182
Jackson County Bank #466682AP6 08/31/17 3/1/2021 1.850%1.850%245,000 238,179 1,529
Barclays Bank #06740KKX4 09/27/17 9/28/2020 1.950%1.950%245,000 240,171 1,254
Capital One Bank #1404205E6 10/04/17 10/4/2019 1.700%1.700%245,000 242,575 1,001
Transportation Alliance #89388CCB2 10/13/17 4/12/2019 1.600%1.600%235,000 233,731 181
Goldman Sachs Bank #38148PRK5 10/18/17 10/19/2020 1.950%1.950%245,000 239,992 962
FirstBank PR Santurce #33767A6M8 11/03/17 11/3/2020 2.000%2.000%245,000 240,134 366
Morgan Stanley #61747MQ53 03/22/18 3/23/2020 2.550%2.550%245,000 244,388 1,701
Total Certificates of Deposits $6,965,000 $6,892,947 $23,958
Total J.P.Morgan Securities $21,600,110 $21,376,112 $117,290
*Interest rate is a floating rate that sets each month. Rate is determined at the one-month LIBOR rate plus 0.60%.
**This is a mortgage backed security that receives principal payments each month based on mortgage repayments. Monthly
principal payments will vary and the investment balance may be repaid before the 2/16/2051 maturity date.
VILLAGE OF OAK BROOK
Monthly Treasurer's Report
June 30, 2018
Cash & Investments by Fund - Total $42.8 million
Cash & Investments by Type - Total $42.8 million
Checking
Illinois Funds
Certificates of Deposit
Municipal Bonds
Corporate Bonds
Government & Agency Obligations
Accrued Interest
General Corporate
44.31%
Hotel/Motel Tax
10.29%Motor Fuel Tax
1.57%
Infrastructure
23.15%
Promenade TIF
0.64%
Water
11.65%
Sports Core
1.06%
Golf Surcharge
1.42%
Self-Insurance
0.65%Garage
0.90%
Equipment
Replacement
4.37%
Checking, $1.7
Illinois Funds, $19.3
Certificates of Deposit,
$7.0
Municipal Bonds, $9.2
Corporate Bonds, $4.7
Government & Agency
Obligations, $0.8
Accrued Interest, $0.1
in millions
Village of Oak Brook
Monthly Financial Report – Fund Narrative
For the Period Ending June 30, 2018
The monthly financial report serves as a document to inform and update readers of the Village’s
financial current position, including historical and trend information. This report is prepared on a cash
basis of accounting, meaning transactions are recognized only when cash is increased or decreased.
Transactions for each month are compared to amounts from the Village’s annual budget, which was also
prepared using a cash basis.
The proceeding pages contain detailed information on the Village’s major funds. Highlights for each of
the Village’s funds are:
General Fund
Total revenues through June 2018 are $407,580 higher than last year and $595,712 over budget.
o Sales tax revenue, the General Fund’s largest revenue source, is down $138,134 from
last year and $42,739 under budget. This is due to the closure of two large taxpayers in
late 2017.
o Other intergovernmental tax revenue is up $42,312 from last year and $58,420 over
budget. Revenue from Income Tax, Replacement Tax, and Use Tax has been better than
anticipated in 2018 despite a 10% reduction in Income Tax receipts by the State.
o Telecommunications/utility tax revenue is up $98,916 from last year and $205,983 over
budget. Revenue is over budget due to a planned reduction of 5% in
telecommunications tax revenue from business closures that has not occurred to date.
o Licenses and permits revenue is up $212,318 from last year and $290,381 over budget.
The increase is due to the receipt large building permits that have occurred to date,
including KidZania and Carvana.
Total expenditures through June 2018 are $470,365 higher than last year, but $1,661,020 under
budget.
o Personnel expenditures are up $332,840 from last year, but $733,330 under budget.
The increase is due to general wage and benefits increases. Personnel is under budget
due to a delay in full pension funding that may occur later in 2018 and ongoing union
contract negotiations.
o Operation and contract expenditures are down $249,795 from last year and $331,796
under budget. This is due to a reduction in liability insurance payments and general
timing of payments.
o Capital outlay expenditures are up $340,992 from last year, but $494,430 under budget.
This is due to the general timing of projects scheduled, including the Police Department
expansion.
Hotel Tax Fund
Total revenues through June 2018 are $42,653 higher than last year, but $5,784 under budget.
o Hotel tax revenue is up $37,272 from last year, but $29,576 under budget. This is due to
an additional hotel in 2018, but overall reduction from existing hotels.
o Interest income revenue is up $13,735 from last year and $20,815 over budget. This is
due to favorable market conditions and rising interest rates.
Total expenditures through June 2018 are $342,571 lower than last year and $195,330 under
budget.
o Operation and contract expenditures are up $1,874 from last year, but $126,831 under
budget. Expenditures are under budget due to the timing of advertising expenditures
paid.
o Capital Outlay expenditures are down $347,517 from last year and $68,499 under
budget. This is due to the timing of projects being completed.
Motor Fuel Tax Fund
Total revenues through June 2018 are down $917 from last year, but $1,544 over budget.
Motor Fuel Tax receipts are slightly under budget, but are offset by increases in interest income.
Total expenditures through June 2018 are up $7,790 from last year, but $192,210 under budget.
This is due to the timing of the transfer of funds to the Infrastructure Fund to pay for roadway
improvements.
Infrastructure Fund
Total revenues through June 2018 are down $89,554 from last year, but $48,340 over budget.
o Non-home rule sales tax revenue is down $132,522 from last year and $5,909 under
budget. This is primarily due to the State’s implementation of a 2% collection fee and
the closure of two large taxpayers.
o Interest income revenue is up $43,381 from last year and $54,010 over budget. This is
due to favorable market conditions and rising interest rates.
Total expenditures through June 2018 are down $147,476 from last year and $2,263,109 under
budget.
o Personnel expenditures are up $10,907 from last year, but $72,379 under budget. The
increase is primarily due to an increase in snow removal overtime compared to last
year. Personnel is under budget due to employee turnover and ongoing union contract
negotiations.
o Operation and contract expenditures are down $153,989 from last year and $224,986
under budget. The reduction is due to a decrease in liability insurance premiums from
last year. Expenditures are under budget due to the timing of engineering payments.
o Capital outlay expenditures are down $25,681 from last year and $1,937,182 under
budget. This is due to the timing of roadway improvement projects.
Promenade TIF Fund
Total revenues through June 2018 are up $28,633 from last year and $28,650 over budget. This
is due to increases in interest income revenue and the timing of Sales Tax collections.
Total expenditures through June 2018 are up $2,640 from last year, but $2,627 under budget.
The increase is in line with the scheduled TIF note repayment schedule.
Water Fund
Total revenues through June 2018 are up $268,083 from last year and $244,204 over budget.
o Water sales revenue is up $219,984 from last year and $116,365 over budget. The
increase is due to a 7% rate increase effective 1/1/18. Water gallons sold has also been
more than projected so far this year.
Total expenditures through June 2018 are up $1,350,310 from last year, but $1,596,259 under
budget.
o Operation and contract expenditures are up $116,290 from last year, but $1,382,186
under budget. The increase is due to more water being purchased from DuPage Water
Commission and a rate increase on gallons purchased. Expenditures are under budget
due to the timing of invoices paid.
o Capital outlay expenditures are up $1,282,722 from last year, but $166,239 under
budget. The increase relates to the start of the Village-wide water meter replacement
project.
Sports Core Fund
Total revenues through June 2018 are down $128,654 from last year and $67,389 under budget.
o Memberships are up $19,921 from last year and $3,394 over budget. Memberships
from both B&T and Golf are up in 2018 compared to last year.
o Greens Fees are down $32,639 from last year and $21,673 under budget. Rounds
played are down in 2018 due to unfavorable weather conditions.
o Rentals are up $48,069 from last year and $35,006 over budget. This is due to the
reclassification of driving range rental fees and the timing of fees received.
o Program/User Fees are down $132,038 from last year and $75,930 under budget. This
is due to the timing of soccer field rental payments and the reclassification of driving
range rental fees.
Total expenditures through June 2018 are up $239,902 from last year and $225,768 over
budget.
o Personnel expenditures are down $1,522 from last year and $40,586 under budget. This
is due to a reorganization and outsourcing of the Bath and Tennis administration.
o Operation and Contractual expenditures are up $263,995 from last year and $147,371
over budget. This is due to the outsourcing of swim operations to the Park District,
which required management fees to be paid before the season.
o Capital outlay expenditures are down $26,283 from last year and $164,674 under
budget. Expenses are under budget due to the general timing or cancellation of
budgeted projects.
Golf Surcharge Fund
Total revenues through June 2018 are down $3,624 from last year and $698 under budget. Golf
surcharge revenue is down through June compared to last year due to inconsistent weather, but
offset by increases in interest income revenue.
No golf surcharge funds have been transferred or expended in 2018 so far.
Self Insurance Fund
Total revenues through June 2018 are down $21,596 from last year and $47,674 under budget.
This is due retirees moving to a new insurance plan in FY18.
Total expenditures through June 2018 are down $25,011 from last year and $243,242 under
budget. This is due to the timing of invoices paid.
Garage Fund
Total revenues through June 2018 are down $64,811 from last year, but $3,096 over budget.
This is due to a budgeted reduction in maintenance charges to use available net position
reserves.
Total expenditures through June 2018 are down $16,092 from last year and $65,777 under
budget. This is due to the delay in hiring a vacant position and a general decrease in
maintenance costs.
Equipment Replacement Fund
Total revenues through June 2018 are down $250,155 from last year, but $8,837 over budget.
This is due to grant revenue received for equipment purchases last year and a reduction in
replacement charges to use available net position.
Total expenditures through June 2018 are down $163,399 from last year and $271,176 under
budget. This is due to the timing of scheduled vehicle replacements.
YTD YTD
Net Fund Budgeted
YTD YTD Increase Increase
Governmental Funds Revenues Expenditures (Decrease)(Decrease)
General Fund (Major Fund)12,812,763 $11,529,955 $1,282,808 $1,543,385
Main operating fund of the Village.
Hotel Fund (Major Fund)$592,216 $289,175 $303,041 $113,495
Collects and spends resources from the
3% hotel/motel tax.
Motor Fuel Tax Fund $106,634 $7,790 $98,844 ($94,910)
Collects and spends resources from the
State motor fuel tax.
Infrastructure Fund (Major Fund)$2,981,434 $1,264,531 $1,716,903 ($402,330)
Accounts for construction and maintenance of
roadways, drainage, and safety path systems.
Promenade TIF Fund (Major Fund)$221,280 $223,823 ($2,543)($33,820)
Accounts for the revenues and expenditures
restricted to the Tax Increment Financing (TIF)
district located at 22nd St. and Meyers Rd.
Enterprise Funds
Water Fund (Major Fund)$3,942,584 $3,932,836 $9,748 ($1,830,715)
Collects user fees for the distribution of water
and maintenance of infrastructure.
Sports Core Fund (Major Fund)$1,720,993 $1,679,622 $41,371 ($117,020)
Accounts for revenues and expenses relating
to administration, programs, food and beverage
operations, and golf course.
Golf Surcharge Fund $48,042 $0 $48,042 $48,740
Accounts for the collection of the $3 per round
golf surcharge.
Internal Service Funds
Self Insurance Fund $1,536,547 $1,402,218 $134,329 ($61,240)
Accounts for the Village's health insurance costs
and the related contributions from the Village,
employees, retirees, and other agencies.
Garage Fund $309,436 $324,333 ($14,897)($83,770)
Accounts for the maintenance of the Village's vehicle
fleet and the related departmental reimbursements.
Equipment Replacement Fund $210,287 $81,564 $128,723 ($151,290)
Accounts for the replacement of the Village's vehicle
fleet and the related departmental contributions.
Further information on the Village's major funds (as indicated above) can be found on the proceeding pages.
Executive Summary on Village Funds
Through June 30, 2018
6/30/18 6/30/18
6/30/17 6/30/18 YTD % of 2018 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 6,339,395$ 6,201,261$ 6,244,000$ 99%12,453,000$ (138,134)$
Other Intergovernmental Tax 671,008 713,320 654,900 109%1,144,700 42,312
Telecommunications/Utility Tax 3,024,867 3,123,783 2,917,800 107%5,792,250 98,916
Licenses and Permits 1,274,758 1,487,076 1,196,695 124%1,784,070 212,318
Charges for Services 438,954 466,744 508,510 92%1,017,100 27,790
Fines and Penalties 77,718 88,490 75,220 118%150,500 10,772
Administrative Towing Fees 19,875 16,325 17,490 93%35,000 (3,550)
Interest on Investments 101,408 160,458 97,500 165%195,000 59,050
Franchise/IMF Maint. Fee 53,253 53,478 107,500 50%215,000 225
Miscellaneous Income 89,421 187,302 82,910 226%180,750 97,881
Total Operating Revenues 12,090,657$ 12,498,237$ 11,902,525$ 105%22,967,370$ 407,580$
OPERATING EXPENDITURES
Personnel 7,931,315$ 8,264,155$ 8,997,485$ 92%17,953,350$ 332,840$
Materials and Supplies 189,496 237,018 299,445 79%532,820 47,522
Operation and Contract 2,134,434 1,884,639 2,216,435 85%4,278,675 (249,795)
Other Expenditures 69,052 67,858 106,895 63%388,815 (1,194)
Capital Outlay 735,293 1,076,285 1,570,715 69%2,997,840 340,992
Total Operating Expenditures 11,059,590$ 11,529,955$ 13,190,975$ 87%26,151,500$ 470,365$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 1,031,067$ 968,282$ (1,288,450)$ (3,184,130)$ (62,785)$
OTHER TRANSACTIONS
Transfers Out -$ -$ -$ 0%-$ -$
Interfund Loan - - - 0%- -
Reimbursements From Other Funds 308,652 314,526 356,670 88%713,360 5,874
Installment Contract Proceeds - - 2,475,165 0%2,475,165 -
Total Interfund Transactions 308,652$ 314,526$ 2,831,835$ 0%3,188,525$ 5,874$
NET FUND INCREASE (DECREASE)1,339,719$ 1,282,808$ 1,543,385$ 4,395$ (56,911)$
Village of Oak Brook
General Fund Financial Update
For the Period Ending June 30, 2018
Total Total
Revenues Expenditures
6/30/18 Actual 12,498,237$ 11,529,955$
6/30/17 Actual 12,090,657$ 11,059,590$
% Change From Last Year 3.4%4.3%
Major Revenues Other
Intergov.Licenses &Charges for
Sales Tax Tax Telecom Tax Permits Services
6/30/18 Actual 6,201,261$ 713,320$ 3,123,783$ 1,487,076$ 466,744$
6/30/17 Actual $ 6,339,395 $ 671,008 $ 3,024,867 $ 1,274,758 $ 438,954
% Change From Last Year -2.2%6.3%3.3%16.7%6.3%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
6/30/18 Actual 8,264,155$ 237,018$ 1,884,639$ 67,858$ 1,076,285$
6/30/17 Actual 7,931,315$ 189,496$ 2,134,434$ 69,052$ 735,293$
% Change From Last Year 4.2%25.1%-11.7%-1.7%46.4%
Five Year Trend
Expenditures by Department
6/30/17 6/30/18 6/30/18 6/30/18 2018 Difference Five
YTD YTD YTD % of Annual Prior Year
Department Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 1,373,608$ 1,137,362$ 1,388,625$ 81.9%2,673,305$ (236,246)$
Financial Services 420,346 434,391 489,760 88.7%1,117,875 14,045
Public Works 341,195 338,769 463,595 73.1%993,820 (2,426)
Engineering & Capital Projects 526,454 985,121 1,366,350 72.1%2,732,665 458,667
Library 468,202 431,491 460,285 93.7%889,845 (36,711)
Police 3,990,372 4,157,526 4,379,985 94.9%8,705,350 167,154
Fire 3,468,404 3,580,950 4,136,955 86.6%8,043,215 112,546
Development Services 471,009 464,345 505,420 91.9%995,425 (6,664)
Total Expenditures 11,059,590$ 11,529,955$ 13,190,975$ 87.4%26,151,500$ 470,365$
Five Year Trend
For the Period Ending June 30, 2018
General Fund - Five Year Trend
Village of Oak Brook
Revenues Expenditures
6/30/18 6/30/18
6/30/17 6/30/18 YTD % of 2018 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Hotel Tax 516,152$ 553,424$ 583,000$ 95%1,340,000$ 37,272$
Interest 22,080 35,815 15,000 239%30,000 13,735
Miscellaneous 11,331 2,977 - N/A - (8,354)
Total Operating Revenues 549,563$ 592,216$ 598,000$ 99%1,370,000$ 42,653$
EXPENDITURES
Operation and Contract 199,365$ 201,239$ 328,070$ 61%646,515$ 1,874$
Other Expenditures 46,698 49,770 49,770 100%99,550 3,072
Capital Outlay 385,683 38,166 106,665 36%640,000 (347,517)
Total Expenditures 631,746$ 289,175$ 484,505$ 59.7%1,386,065$ (342,571)$
NET FUND INCREASE (DECREASE)(82,183)$ 303,041$ 113,495$ (16,065)$ 385,224$
Note - Expenditures are recorded in program 171.
Village of Oak Brook
Hotel Tax Fund Financial Update
For the Period Ending June 30, 2018
Total Total
Revenues Expenditures
6/30/18 Actual $ 592,216 289,175$
6/30/17 Actual $ 549,563 631,746$
% Change From Last Year 7.8%-54.2%
Major Revenues
Grants Hotel Tax Interest Miscellaneous
6/30/18 Actual $ - $ 553,424 $ 35,815 $ 2,977
6/30/17 Actual $ - $ 516,152 $ 22,080 $ 11,331
% Change From Last Year 0.0%7.2%62.2%-73.7%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures Capital Outlay
6/30/18 Actual 201,239$ 49,770$ 38,166$
6/30/17 Actual 199,365$ 46,698$ 385,683$
% Change From Last Year 0.9%6.6%-90.1%
Five Year Trend
Village of Oak Brook
Hotel Tax Fund - Major Sources Five Year Trend
For the Period Ending June 30, 2018
Five Year Trend
Revenues Expenditures
6/30/18 6/30/18
6/30/17 6/30/18 YTD % of 2018 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 2,937,863$ 2,805,341$ 2,811,250$ 100%5,563,000$ (132,522)$
Grants 3,142 - - 0%- (3,142)
Interest 31,629 75,010 21,000 357%42,000 43,381
Miscellaneous - 2,729 2,490 110%5,000 2,729
Total Operating Revenues 2,972,634$ 2,883,080$ 2,834,740$ 102%5,610,000$ (89,554)$
OPERATING EXPENDITURES
Personnel 602,169$ 613,076$ 685,455$ 89%1,365,445$ 10,907$
Materials and Supplies 65,254 85,359 113,915 75%182,955 20,105
Operation and Contract 609,138 455,149 680,135 67%1,484,755 (153,989)
Other Expenditures 81,252 82,434 82,440 100%164,865 1,182
Capital Outlay 54,194 28,513 1,965,695 1%5,625,620 (25,681)
Total Operating Expenditures 1,412,007$ 1,264,531$ 3,527,640$ 36%8,823,640$ (147,476)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 1,560,627$ 1,618,549$ (692,900)$ -234%(3,213,640)$ 57,922$
INTERFUND TRANSACTIONS
Transfers In -$ 7,790$ 200,000$ 4%500,000$ 7,790$
Reimbursements From Other Funds 88,320 90,564 90,570 100%181,130 2,244
Total Interfund Transactions 88,320$ 98,354$ 290,570$ 34%681,130$ 10,034$
NET FUND INCREASE (DECREASE)1,648,947$ 1,716,903$ (402,330)$ (2,532,510)$ 67,956$
Village of Oak Brook
Infrastructure Fund Financial Update
For the Period Ending June 30, 2018
Total Total
Revenues Expenditures
6/30/18 Actual $ 2,883,080 1,264,531$
6/30/17 Actual $ 2,972,634 1,412,007$
% Change From Last Year -3.0%-10.4%
Major Revenues
Sales Tax Grants Interest Miscellaneous Reimbursements
6/30/18 Actual $ 2,805,341 $ - $ 75,010 $ 2,729 $ 90,564
6/30/17 Actual $ 2,937,863 $ 3,142 $ 31,629 $ - $ 88,320
% Change From Last Year -4.5%-100.0%137.2%N/A 2.5%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
6/30/18 Actual 613,076$ 85,359$ 455,149$ 82,434$ 28,513$
6/30/17 Actual 602,169$ 65,254$ 609,138$ 81,252$ 54,194$
% Change From Last Year 1.8%30.8%-25.3%1.5%-47.4%
Five Year Trend
Expenditures by Department
6/30/17 6/30/18 6/30/18 6/30/18 2018 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 78,016$ 80,018$ 89,875$ 89.0%178,530$ 2,002$
Public Works 1,148,489 1,033,406 1,364,450 75.7%2,592,335 (115,083)
Engineering & Capital Projects 185,502 151,107 2,073,315 7.3%6,052,775 (34,395)
Total Expenditures 1,412,007$ 1,264,531$ 3,527,640$ 35.8%8,823,640$ (147,476)$
Five Year Trend
Village of Oak Brook
Infrastructure Fund - Major Sources Five Year Trend
For the Period Ending June 30, 2018
Revenues Expenditures
6/30/18 6/30/18
6/30/17 6/30/18 YTD % of 2018 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax -$ 34,169$ -$ 0%102,500$ 34,169$
Real Estate Tax 192,509 186,562 192,500 97%385,000 (5,947)
Interest 138 549 130 422%250 411
Total Operating Revenues 192,647$ 221,280$ 192,630$ 115%487,750$ 28,633$
EXPENDITURES
Operation and Contract 888$ 613$ 3,240$ 19%4,090$ (275)$
Other Expenditures 220,295 223,210 223,210 100%459,820 2,915
Total Expenditures 221,183$ 223,823$ 226,450$ 99%463,910$ 2,640$
NET FUND INCREASE (DECREASE)(28,536)$ (2,543)$ (33,820)$ 23,840$ 25,993$
Note - Expenditures are recorded in program 283.
Village of Oak Brook
Promenade TIF Fund Financial Update
For the Period Ending June 30, 2018
Total Total
Revenues Expenditures
6/30/18 Actual $ 221,280 223,823$
6/30/17 Actual $ 192,647 221,183$
% Change From Last Year 14.9%1.2%
Major Revenues Real Estate
Sales Tax Tax Interest
6/30/18 Actual $ 34,169 $ 186,562 $ 549
6/30/17 Actual $ - $ 192,509 $ 138
% Change From Last Year N/A -3.1%297.8%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures
6/30/18 Actual 613$ 223,210$
6/30/17 Actual 888$ 220,295$
% Change From Last Year -31.0%1.3%
Five Year Trend
Village of Oak Brook
Promenade TIF Fund - Major Sources Five Year Trend
For the Period Ending June 30, 2018
Five Year Trend
Revenues Expenditures
6/30/18 6/30/18
6/30/17 6/30/18 YTD % of 2018 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Grants 3,386$ -$ -$ 0%-$ (3,386)$
Plan Review Fees 1,039 600 990 61%2,000 (439)
Building/Inspection Fees 3,814 5,063 2,490 203%5,000 1,249
Water Sales 3,491,381 3,711,365 3,595,000 103%9,730,425 219,984
Unmetered Sales (2,090) 6,995 15,000 47%30,000 9,085
Water Connection Fees 102,810 109,284 24,900 439%50,000 6,474
Fire Service Charge - - 2,490 0%5,000 -
Meter Charges 12,510 6,544 12,510 52%25,000 (5,966)
Special Services 15,286 16,394 15,000 109%30,000 1,108
Interest on Investments 14,729 43,598 5,010 870%10,000 28,869
Miscellaneous 31,636 42,741 24,990 171%50,000 11,105
Total Operating Revenues 3,674,501$ 3,942,584$ 3,698,380$ 107%9,937,425$ 268,083$
EXPENDITURES
Personnel 425,587$ 368,711$ 409,725$ 90%817,490$ (56,876)$
Materials and Supplies 25,929 32,321 39,135 83%76,860 6,392
Operation and Contract 1,894,079 2,010,369 3,392,555 59%6,780,015 116,290
Other Expenditures 200,802 202,584 202,590 100%405,170 1,782
Capital Outlay 36,129 1,318,851 1,485,090 89%2,710,220 1,282,722
Total Expenditures 2,582,526$ 3,932,836$ 5,529,095$ 71%10,789,755$ 1,350,310$
NET FUND INCREASE (DECREASE)1,091,975$ 9,748$ (1,830,715)$ (852,330)$ (1,082,227)$
Village of Oak Brook
Water Fund Financial Update
For the Period Ending June 30, 2018
Total Total
Revenues Expenditures
6/30/18 Actual $ 3,942,584 3,932,836$
6/30/17 Actual $ 3,674,501 2,582,526$
% Change From Last Year 7.3%52.3%
Unmetered Water
Water Sales Sales Connection Fees Meter Charges Miscellaneous
6/30/18 Actual $ 3,711,365 $ 6,995 $ 109,284 $ 6,544 $ 42,741
6/30/17 Actual $ 3,491,381 $ (2,090) $ 102,810 $ 12,510 $ 31,636
% Change From Last Year 6.3%-434.7%6.3%-47.7%35.1%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
6/30/18 Actual 368,711$ 32,321$ 2,010,369$ 202,584$ 1,318,851$
6/30/17 Actual 425,587$ 25,929$ 1,894,079$ 200,802$ 36,129$
% Change From Last Year -13.4%24.7%6.1%0.9%3550.4%
Five Year Trend
Expenditures by Department
6/30/17 6/30/18 6/30/18 6/30/18 2018 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Public Works 2,558,928$ 2,591,996$ 4,116,495$ 63.0%8,124,535$ 33,068$
Engineering & Capital Projects 23,598 1,340,840 1,412,600 94.9%2,665,220 1,317,242
Total Expenditures 2,582,526$ 3,932,836$ 5,529,095$ 71.1%10,789,755$ 1,350,310$
Five Year Trend
Village of Oak Brook
Water Fund - Major Sources Five Year Trend
For the Period Ending June 30, 2018
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Sports Core Fund Consolidated Presentation
For the Period Ending June 30, 2018
6/30/18 6/30/18
6/30/18 YTD % of 2018 6/30/17 Difference
B&T Recreation Food &Golf YTD Amended Amended Adopted YTD Prior
Programs Beverage Club Total Budget Budget Budget Total Year
DIRECT REVENUES
Memberships 225,459$ -$ 203,200$ 428,659$ 425,265$ 101%414,875$ 408,738$ 19,921$
Greens Fees - - 343,727 343,727 365,400 94%975,000 376,366 (32,639)
Pro Shop Sales - - 105,863 105,863 100,680 105%200,000 97,374 8,489
Golf Lessons - - 21,352 21,352 27,000 79%40,000 32,384 (11,032)
Driving Range Fees - - 138,913 138,913 156,000 89%235,000 149,907 (10,994)
Rentals - - 194,931 194,931 159,925 122%451,000 146,862 48,069
Programs/User Fees 118,395 - - 118,395 194,325 61%300,700 250,433 (132,038)
Food Sales - 59,948 - 59,948 55,315 108%145,500 69,427 (9,479)
Beverage Sales - 92,001 - 92,001 89,140 103%236,000 107,352 (15,351)
Other Revenue 127,929 69,247 4,026 201,202 199,330 101%380,650 194,802 6,400
Total Direct Revenues 471,783$ 221,196$ 1,012,012$ 1,704,991$ 1,772,380$ 96%3,378,725$ 1,833,645$ (128,654)$
DIRECT EXPENDITURES
Personnel 67,715$ 107,128$ 469,506$ 644,349$ 684,935$ 94%1,497,200$ 645,871$ (1,522)$
Materials & Supplies 16,044 75,515 129,544 221,103 341,045 65%615,885 250,439 (29,336)
Operational & Contractual 447,567 55,476 137,093 640,136 492,765 130%961,510 376,141 263,995
Other - - 33,048 33,048 80,985 41%(44,275) - 33,048
Capital 81,942 - 59,044 140,986 305,660 46%365,660 167,269 (26,283)
Total Direct Expenditures 613,268$ 238,119$ 828,235$ 1,679,622$ 1,905,390$ 88%3,395,980$ 1,439,720$ 239,902$
Direct Revenues Over (Under) Expenditures (141,485)$ (16,923)$ 183,777$ 25,369$ (133,010)$ -19%(17,255)$ 393,925$ (368,556)$
B&T Administration Overhead Allocation*56,337$ (56,337)$ -$ -$ -$ 0%-$ -$ -$
Operating Revenues Over (Under) Expenditures (85,148)$ (73,260)$ 183,777$ 25,369$ (133,010)$ -19%(17,255)$ 393,925$ (368,556)$
Interfund Loan**-$ -$ -$ -$ -$ 0%-$ -$ -$
Transfer From General Fund - - - - - 0%- - -
Transfer From Infrastructure Fund 12,000 - - 12,000 12,000 100%24,000 12,000 -
Transfer From Water Fund 4,002 - - 4,002 3,990 100%8,000 4,002 -
Transfer From Golf Surcharge Fund - - - - - 0%- - -
Adjusted Operating Revenues Over (Under) Expenditures (69,146)$ (73,260)$ 183,777$ 41,371$ (117,020)$ 14,745$ 409,927$ (368,556)$
*Overhead allocation is comprised of salaries, business forms, liability insurance, building & grounds maintenance and bank service fees in Program 811 -
Sports Core General Operations distributed to various Sports Core Programs on a % basis.
**Interfund loan is from the General Fund. This will be repaid as the season begins.
Total Direct Total Direct
Revenues Expenditures
6/30/18 Actual $ 1,704,991 1,679,622$
6/30/17 Actual $ 1,833,645 1,439,720$
% Change From Last Year -7.0%16.7%
Driving Program/
Memberships Greens Fees Range Fees Rentals User Fees
6/30/18 Actual $ 428,659 $ 343,727 $ 138,913 $ 194,931 $ 118,395
6/30/17 Actual $ 408,738 $ 376,366 $ 149,907 $ 146,862 $ 250,433
% Change From Last Year 4.9%-8.7%-7.3%32.7%-52.7%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
6/30/18 Actual 644,349$ 221,103$ 640,136$ 33,048$ 140,986$
6/30/17 Actual 645,871$ 250,439$ 376,141$ -$ 167,269$
% Change From Last Year -0.2%-11.7%70.2%N/A -15.7%
Five Year Trend
Revenues by Department 6/30/17 6/30/18 6/30/18 6/30/18 2018 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Programs 599,110$ 471,783$ 646,495$ 73.0%712,075$ (127,327)$
Food & Beverage 240,939 221,196 127,800 173.1%569,000 (19,093)
Golf Club 993,596 1,012,012 567,997 178.2%2,097,650 18,416
Total Revenues 1,833,645$ 1,704,991$ 1,342,292$ 127.0%3,378,725$ (128,004)$
Expenditures by Department 6/30/17 6/30/18 6/30/18 % of 2018 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Programs 375,387$ 613,268$ 344,363$ 178.1%1,058,430$ 237,881$
Food & Beverage 298,459 238,119 281,968 84.4%514,980 (60,340)
Golf Club 765,874 828,235 778,751 106.4%1,822,570 62,361
Total Expenditures 1,439,720$ 1,679,622$ 1,405,082$ 119.5%3,395,980$ 239,902$
Five Year Trend
Village of Oak Brook
Sports Core Fund - Major Sources Five Year Trend
For the Period Ending June 30, 2018
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Club Recreation Programs
For the Period Ending June 30, 2018 6/30/18 6/30/18
6/30/18 YTD % of 2018 6/30/17 Difference
811 812 813 815 816 YTD Amended Amended Adopted YTD Prior
B&T Admin Swimming Tennis Polo Open Fields Total Budget Budget Budget Total Year
Revenues:
Memberships -$ 206,226$ 19,233$ -$ -$ 225,459$ 234,765$ 96%223,375$ 221,235$ 4,224$
Programs/User Fees (1,612) 16,902 7,780 - 95,325 118,395 194,325 61%300,700 250,433 (132,038)
Other Revenue (5) 20 259 - 127,655 127,929 125,230 102%188,000 127,442 487
Total Revenue (1,617)$ 223,148$ 27,272$ -$ 222,980$ 471,783$ 554,320$ 85%712,075$ 599,110$ (127,327)$
Expenditures:
Personnel 58,321$ 5,543$ 3,851$ -$ -$ 67,715$ 89,155$ 76%208,040$ 93,870$ (26,155)$
Materials & Supplies 4,682 9,287 2,075 - - 16,044 15,035 107%28,280 20,909 (4,865)
Operational & Contractual 39,709 272,021 25,492 15,000 95,345 447,567 307,840 145%586,160 203,884 243,683
Other - - - - - - 28,090 0%56,200 - -
Capital - 81,564 - - 378 81,942 169,750 48%179,750 56,724 25,218
Total Expenditures 102,712$ 368,415$ 31,418$ 15,000$ 95,723$ 613,268$ 609,870$ 101%1,058,430$ 375,387$ 237,881$
Direct Revenues Over (Under) Expenditures (104,329)$ (145,267)$ (4,146)$ (15,000)$ 127,257$ (141,485)$ (55,550)$ 255%(346,355)$ 223,723$ (365,208)$
B&T Administration Overhead Allocation*104,329$ (37,559)$ (10,433)$ -$ -$ 56,337$ 98,660$ 57%207,995$ 97,794$ (41,457)$
Revenues Over (Under) Expenditures -$ (182,826)$ (14,579)$ (15,000)$ 127,257$ (85,148)$ 43,110$ -198%(138,360)$ 321,517$ (406,665)$
Interfund Loan**-$ -$ -$ -$ -$ -$ -$ 0%-$ -$ -$
Transfer From General Fund - - - - - - - 0%- - -
Transfer From Infrastructure Fund 12,000 - - - - 12,000 12,000 100%24,000 12,000 -
Transfer From Water Fund 4,002 - - - - 4,002 3,990 100%8,000 4,002 -
Adjusted Revenues Over (Under) Expenditures 16,002$ (182,826)$ (14,579)$ (15,000)$ 127,257$ (69,146)$ 59,100$ (106,360)$ 337,519$ (406,665)$
*Overhead allocation is comprised of salaries, business forms, liability insurance, building & grounds maintenance and bank service fees in Program 811 - Sports Core
General Operations distributed to various Sports Core Programs on a percentage basis.
**Interfund loan is from the General Fund.
Village of Oak Brook
Monthly Operating Statement
Sports Core Food & Beverage Programs
For the Period Ending June 30, 2018
6/30/18 6/30/18
821 822 823 6/30/18 YTD % of 2018 6/30/17 Difference
B&T Poolside Golf YTD Amended Amended Adopted YTD Prior
Clubhouse Café Clubhouse Total Budget Budget Budget Total Year
Revenues:
Memberships -$ -$ -$ -$ -$ 0%-$ 650$ -$
Food Sales - 14,404 45,544 59,948 55,315 108%145,500 69,427 (9,479)
Beverage Sales - 8,064 83,937 92,001 89,140 103%236,000 107,352 (15,351)
Other Revenue 69,247 - - 69,247 69,500 100%187,500 63,510 5,737
Total Revenue 69,247$ 22,468$ 129,481$ 221,196$ 213,955$ 103%569,000$ 240,939$ (19,093)$
Expenditures:
Personnel 51,662$ 5,833$ 49,633$ 107,128$ 93,165$ 115%199,505$ 90,697$ 16,431$
Materials & Supplies 7,928 6,740 60,847 75,515 72,825 104%182,150 87,324 (11,809)
Operational & Contractual 52,055 752 2,669 55,476 53,980 103%133,325 27,665 27,811
Capital - - - - - 0%- 92,773 (92,773)
Total Expenditures 111,645$ 13,325$ 113,149$ 238,119$ 219,970$ 108%514,980$ 298,459$ (60,340)$
Direct Revenues Over (Under) Expenditures (42,398)$ 9,143$ 16,332$ (16,923)$ (6,015)$ 281%54,020$ (57,520)$ 40,597$
B&T Administration Overhead Allocation*(52,164)$ (4,173)$ -$ (56,337)$ (98,660)$ 57%(175,995)$ (97,794)$ 41,457$
Revenues Over (Under) Expenditures (94,562)$ 4,970$ 16,332$ (73,260)$ (104,675)$ 70%(121,975)$ (155,314)$ 82,054$
Transfer From General Fund -$ -$ -$ -$ -$ 0%-$ -$ -$
Adjusted Revenues Over (Under) Expenditures (94,562)$ 4,970$ 16,332$ (73,260)$ (104,675)$ (121,975)$ (155,314)$ 82,054$
*Overhead allocation is comprised of salaries, business forms, liability insurance, building & grounds maintenance and bank service fees in Program 811 -
Sports Core General Operations distributed to various Sports Core Programs on a percentage basis.
Village of Oak Brook
Monthly Operating Statement
Golf Club Programs
For the Period Ending June 30, 2018
6/30/18 6/30/18
831 832 833 834 6/30/18 YTD % of 2018 6/30/17 Difference
Golf General Golf Learning Golf Cart Golf Course YTD Amended Amended Adopted YTD Prior
Operation & Practice Operations Maintenance Total Budget Budget Budget Total Year
Revenues:
Memberships 203,200$ -$ -$ -$ 203,200$ 190,500$ 107%191,500$ 186,853$ 16,347$
Greens Fees 343,727 - - - 343,727 365,400 94%975,000 376,366 (32,639)
Pro Shop Sales 105,863 - - - 105,863 100,680 105%200,000 97,374 8,489
Golf Lessons - 21,352 - - 21,352 27,000 79%40,000 32,384 (11,032)
Driving Range Fees - 138,913 - - 138,913 156,000 89%235,000 149,907 (10,994)
Rentals 1,315 70,000 123,616 - 194,931 159,925 122%451,000 146,862 48,069
Other Revenue 4,026 - - - 4,026 4,600 88%5,150 3,850 176
Total Revenue 658,131$ 230,265$ 123,616$ -$ 1,012,012$ 1,004,105$ 101%2,097,650$ 993,596$ 18,416$
Expenditures:
Personnel 222,867$ 9,453$ 17,820$ 219,366$ 469,506$ 502,615$ 93%1,089,655$ 461,304$ 8,202$
Materials & Supplies 54,227 7,667 243 67,407 129,544 253,185 51%405,455 142,206 (12,662)
Operational & Contractual 105,767 758 246 30,322 137,093 130,945 105%242,025 144,592 (7,499)
Other - - 33,048 - 33,048 52,895 62%(100,475) - 33,048
Capital 17,434 - 40,922 688 59,044 135,910 43%185,910 17,772 41,272
Total Expenditures 400,295$ 17,878$ 92,279$ 317,783$ 828,235$ 1,075,550$ 77%1,822,570$ 765,874$ 62,361$
Direct Revenues Over (Under) Expenditures 257,836$ 212,387$ 31,337$ (317,783)$ 183,777$ (71,445)$ -257%275,080$ 227,722$ (43,945)$
Transfer from General Fund -$ -$ -$ -$ -$ -$ 0%-$ -$ -$
Adjusted Revenues Over (Under) Expenditures 257,836$ 212,387$ 31,337$ (317,783)$ 183,777$ (71,445)$ 275,080$ 227,722$ (43,945)$