06 - June 2020 Monthly Financial ReportVILLAGE
OAK BROOK
OF
MONTHLY FINANCIAL REPORTS
JUNE 2020
Cash and Investments by Fund:Total
Cash and Cash Pooled Cash and
Fund Equivalents Investments Investments % By Fund
General Corporate $7,217,648 $14,967,295 $22,184,943 48.0%
Hotel/Motel Tax 2,339,354 2,462,709 4,802,063 10.4%
Motor Fuel Tax 1,254,673 69,498 1,324,171 2.9%
Infrastructure 7,160,575 1,996,235 9,156,810 19.8%
Promenade TIF 272,527 - 272,527 0.6%
Water 3,151,732 3,492,365 6,644,097 14.4%
Sports Core 87,459 - 87,459 0.2%
Golf Surcharge 51,513 5,119 56,632 0.1%
Self-Insurance 460,026 - 460,026 1.0%
Garage 334,956 - 334,956 0.7%
Equipment Replacement 531,165 374,263 905,428 2.0%
Total $22,861,628 $23,367,484 $46,229,112 100.0%
Change in Cash and Investments by Fund :
Balance at Balance at Year-to-Date Year-to-Date
Fund January 1, 2020 June 30, 2020 Change ($)Change (%)
General Corporate $21,270,239 $22,184,943 $914,704 4.3%
Hotel/Motel Tax 5,427,474 4,802,063 (625,411)-11.5%
Motor Fuel Tax 1,085,595 1,324,171 238,576 22.0%
Infrastructure 8,217,724 9,156,810 939,086 11.4%
Promenade TIF 304,194 272,527 (31,667)-10.4%
Water 6,947,239 6,644,097 (303,142)-4.4%
Sports Core 231,216 87,459 (143,757)-62.2%
Golf Surcharge 347,066 56,632 (290,434)-83.7%
Self-Insurance 308,820 460,026 151,206 49.0%
Garage 275,988 334,956 58,968 21.4%
Equipment Replacement 808,879 905,428 96,549 11.9%
$45,224,434 $46,229,112 $1,004,678 2.2%
Book Bank/Market
Value Value
Cash and Cash Equivalents:
Pooled Checking $775,167 $824,983
Sports Core Checking 290,532 267,029
Pooled IPTIP 21,457,438 21,457,438
Water E-Pay IPTIP 338,491 335,260
$22,861,628 $22,884,710
Pooled Investments:
Investments-Municipal Bonds $6,001,344 $6,055,666
Investments-Corporate Bonds 8,809,774 8,946,251
Government & Agency Obligations 1,927,821 1,967,919
Certificates of Deposit 6,485,000 6,571,265
Accrued Interest 143,545 143,545
Total Pooled Investments $23,367,484 $23,684,646
Total Cash and Investments $46,229,112 $46,569,356
For June, total interest revenue is $51,064 and YTD is $381,389. The total investment yield for the portfolio is:
Pooled
Investments Illinois Funds Total
Last 12 months yield 2.25%1.65%1.96%
The weighted average yield of the current pooled investment portfolio is 2.21%. The IL Funds June average daily rate was 0.451%.
Monthly Treasurer's Report
June 30, 2020
Monthly Treasurer's Report
June 2020
The table below lists the detail investment holdings at J.P. Morgan Securities as of 6/30/20:
Month End VOB
Settlement Maturity Coupon Yield Book Market Accrued
Type Date Date Rate Rate Value Value Interest
Municipal Bonds:
New York N Y City #64971QTX1 02/22/16 05/01/21 2.350%2.000%200,562 203,148 770
Florida Hurricane #34074GDH4 03/30/16 07/01/20 2.995%2.150%500,000 500,000 7,487
Bloomingdale Mich Pub Sch Dist #094383FS0 04/26/16 05/01/22 2.710%2.150%504,963 512,325 2,219
Connecticut St GO Bds 2016 #20772J3F7 06/15/17 08/15/21 1.750%2.300%496,984 505,025 3,252
Wright County Min #982276BC0 07/18/19 12/01/20 2.000%2.000%545,000 547,000 1,423
State of IL #452152P54 10/09/19 11/01/21 5.000%1.870%520,615 514,845 3,916
Anchor Bay Mich Sch #032879TE8 11/01/19 05/01/21 2.320%1.750%718,379 726,676 2,626
Brownsville TX #16405ST9 12/19/19 02/15/22 2.050%2.000%555,434 563,525 4,140
Laredo TX Waterworks #517039VW0 12/19/19 03/01/24 2.230%2.230%455,000 465,561 3,326
Manchester NH #562333JE5 03/12/20 12/01/20 5.000%0.850%483,198 484,225 1,939
Oakland Univ Mich #673588HJ1 04/29/20 03/01/24 5.000%1.650%330,007 334,725 4,917
Philadelphia PA GO Ref #717813SW0 05/05/20 08/01/22 5.000%1.820%415,344 424,012 7,922
Maryland St DOT #574204WG4 05/06/20 06/15/22 4.350%1.200%275,858 274,599 386
Total Municipal Bonds $6,001,344 $6,055,666 $44,323
Corporate Bonds:
Goldman Sachs #38141GVP9 09/26/18 09/15/20 2.750%3.180%499,580 501,255 4,010
Wells Fargo #94974BGR5 01/15/19 12/07/20 2.550%3.120%1,386,721 1,402,871 2,658
PNC Bank #69353RFH6 01/30/19 01/22/21 2.500%3.020%498,589 505,065 5,521
Morgan Stanley #61747WAL3 03/08/19 07/28/21 5.500%3.034%1,076,999 1,105,661 24,383
Citigroup #172967LC3 04/01/19 12/08/21 2.900%2.754%1,002,033 1,030,140 1,290
Bank of America #06051GFT1 04/03/19 10/19/20 2.625%2.625%700,000 704,760 3,420
Goldman Sachs #38143U8F1 05/02/19 02/25/21 2.875%2.707%365,381 369,924 3,646
American Honda #02665WBG5 07/31/19 09/09/21 1.700%2.180%497,212 507,100 2,667
BB&T Corp #05531FAZ6 08/15/19 02/01/21 2.150%2.010%750,637 756,360 6,522
JP Morgan #48128BAB7 09/30/19 01/15/23 2.972%2.337%1,015,537 1,035,470 13,704
JP Morgan #46625HRT9 01/30/20 06/07/21 2.400%1.648%503,458 508,525 800
American Express #025816CD9 05/05/20 05/20/22 2.750%1.290%513,627 519,120 1,423
Total Corporate Bonds $8,809,774 $8,946,251 $70,044
Government & Agency Obligations:
*Government National Mtg Assn #38379UEM4 02/29/16 02/16/51 2.300%2.245%$529,374 $524,344 $2,218
*Government National Mtg Assn #38381WV96 08/06/19 07/20/54 2.250%2.293%801,410 822,420 1,419
*Government National Mtg Assn #38380BNV3 12/05/19 06/20/46 2.000%2.112%597,037 621,155 939
Total Government & Agency Obligations:$1,927,821 $1,967,919 $4,576
Certificates of Deposit:
State Bk India NY #8562846A7 01/26/17 01/26/22 2.250%2.250%$245,000 $252,914 $2,374
American Express Centurion #02587DV96 08/15/17 08/17/20 1.900%1.900%245,000 245,586 1,727
Sallie Mae #795450C86 08/16/17 08/17/20 1.900%1.900%245,000 245,586 1,727
Merrick Bank South Jordan #59013JZS1 08/21/17 08/21/20 1.800%1.800%245,000 245,588 112
Pinnacle Bank #72345SFS5 08/30/17 08/31/20 1.800%1.800%115,000 115,331 1
Jackson County Bank #466682AP6 08/31/17 03/01/21 1.850%1.850%245,000 247,840 1,517
Barclays Bank #06740KKX4 09/27/17 09/28/20 1.950%1.950%245,000 246,120 1,241
Goldman Sachs Bank #38148PRK5 10/18/17 10/19/20 1.950%1.950%245,000 246,379 949
FirstBank PR Santurce #33767A6M8 11/03/17 11/03/20 2.000%2.000%245,000 246,570 353
Compass Bank #20451PVW3 10/26/18 10/26/20 3.000%3.000%245,000 247,308 1,297
UBS Bank #90348JFH8 10/30/18 10/29/20 3.050%3.050%245,000 247,389 20
Discover Bank #254673WF9 11/07/18 11/09/20 3.000%3.000%245,000 247,582 1,092
Ally Bank #02007GFX6 11/08/18 11/09/20 3.000%3.000%245,000 247,582 1,072
Comenity Cap Bank #20033AU46 04/15/19 04/15/21 2.500%2.500%245,000 249,577 236
Morgan Stanley #61760AE21 05/30/19 06/01/21 2.400%2.400%245,000 250,103 474
First St Bank DeQueen #336460CU2 07/18/19 07/19/21 2.000%2.000%245,000 249,731 185
Bank Hapoalim #06251AW89 07/19/19 07/19/21 2.000%2.000%245,000 249,988 2,102
Capital One Natl Assn #14042RMF5 07/24/19 07/26/19 2.050%2.050%245,000 249,947 2,281
TIAA FSB Jacksonville #87270LCN1 07/29/19 07/29/21 2.000%2.000%245,000 249,851 2,062
Wells Fargo #949763J31 09/18/19 09/20/21 1.850%1.850%245,000 250,018 186
BMW Bank #05580ASQ8 10/11/19 10/12/21 1.800%1.800%245,000 250,121 913
Wells Fargo #949495AN5 01/17/20 01/18/22 1.800%1.800%245,000 251,103 185
Southpoint Bank #84464PBK2 02/28/20 02/28/22 1.600%1.600%245,000 245,586 7
Bank Leumi #063248KQ0 03/31/20 03/31/22 1.250%1.250%245,000 249,518 766
Capital One Natl Assn #14042TCZ8 04/01/20 04/01/22 1.350%1.350%245,000 249,939 818
Synchrony Bank #87164WZN1 04/03/20 04/04/22 1.350%1.350%245,000 249,961 799
Wells Fargo #95001DAB6 06/17/20 06/17/23 1.200%1.200%245,000 244,047 106
Total Certificates of Deposits $6,485,000 $6,571,265 $24,602
Total J.P.Morgan Securities $23,223,939 $23,541,101 $143,545
*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 maturity date.
VILLAGE OF OAK BROOK
Monthly Treasurer's Report
June 30, 2020
Cash & Investments by Fund - Total $46.2 million
Cash & Investments by Type - Total $46.2 million
Checking
Illinois Funds
Certificates of Deposit
Municipal Bonds
Corporate Bonds
Government & Agency Obligations
Accrued Interest
General Corporate
47.99%
Hotel/Motel Tax
10.39%Motor Fuel Tax
2.86%
Infrastructure
19.81%
Promenade TIF
0.59%
Water
14.37%
Sports Core
0.19%
Golf Surcharge
0.12%
Self-Insurance
1.00%Garage
0.72%
Equipment
Replacement
1.96%
Checking, $1.1
Illinois Funds, $21.8
Certificates of Deposit,
$6.5
Municipal Bonds, $6.0
Corporate Bonds, $8.8
Government & Agency
Obligations, $1.9
Accrued Interest, $0.1
in millions
YTD YTD
Net Fund Budgeted
YTD YTD Increase Increase
Governmental Funds Revenues Expenditures (Decrease)(Decrease)
General Fund (Major Fund)12,437,169$ 11,551,678$ 885,491$ 524,585$
Main operating fund of the Village.
Hotel Fund (Major Fund)359,643$ 482,709$ (123,066)$ 65,925$
Collects and spends resources from the
3% hotel/motel tax.
Motor Fuel Tax Fund 243,736$ -$ 243,736$ 159,740$
Collects and spends resources from the
State motor fuel tax.
Infrastructure Fund (Major Fund)3,097,600$ 1,733,433$ 1,364,167$ (3,866,910)$
Accounts for construction and maintenance of
roadways, drainage, and safety path systems.
Promenade TIF Fund (Major Fund)237,377$ 269,045$ (31,668)$ (30,295)$
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,738,856$ 3,576,112$ 162,744$ (1,122,825)$
Collects user fees for the distribution of water
and maintenance of infrastructure.
Sports Core Fund (Major Fund)1,603,478$ 1,688,520$ (85,042)$ (242,195)$
Accounts for revenues and expenses relating
to administration, programs, food and beverage
operations, and golf course.
Golf Surcharge Fund 32,940$ 323,373$ (290,433)$ (354,240)$
Accounts for the collection of the $3 per round
golf surcharge.
Internal Service Funds
Self Insurance Fund 1,738,407$ 1,331,225$ 407,182$ (21,000)$
Accounts for the Village's health insurance costs
and the related contributions from the Village,
employees, retirees, and other agencies.
Garage Fund 367,782$ 346,241$ 21,541$ (9,005)$
Accounts for the maintenance of the Village's vehicle
fleet and the related departmental reimbursements.
Equipment Replacement Fund 166,147$ 69,599$ 96,548$ 57,150$
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, 2020
Village of Oak Brook
Monthly Financial Report – Fund Narrative
For the Period Ending June 30, 2020
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. A detailed financial statement and
trend information is displayed for all Village major funds. A fund is considered major if it is the primary
operating of the Village (General Fund) or meets the following criteria:
Total assets/deferred outflows of resources, liabilities/deferred inflows of resources, revenues,
or expenditures/expenses of that individual governmental or enterprise fund are at least 10% of
the total for all funds of the same category or type, and
The same element of the individual fun that met the 10% test is at least 5% of the
corresponding total for all funds combined.
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 the cash basis of accounting. For the Village’s
major enterprise funds (Water and Sports Core), a reconciliation is included to display results on a full
accrual basis, which is how information is presented in the Village’s annual Comprehensive Annual
Financial Report (CAFR).
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 2020 are $1,122,763, or 8.5%, lower than last June and $1,035,030,
or 7.9%, under budget to date. The main drivers for this are:
o Sales tax revenue, the General
Fund’s largest revenue source, is
up $43,939 from last year and
$118,547 over budget. June
2020 collections dropped
significantly compared to
collections the previous five
years. The decline is related to
the COVID-19 pandemic, which
say numerous businesses closed
in March 2020.
o Other intergovernmental tax revenue is down $54,179 from last year and $20,483 under
budget. The Village has experienced a decrease in Income Tax and Replacement Tax
receipts in June due to the COVID-19 pandemic. The State income tax filing date was
moved from April to July, which affected May collections. Use Tax payments have been
consistent with prior year and budget to date.
o Licenses and permits revenue is down $705,030 from last year and $689,847 under
budget. This is due to the timing of permits being issued vs. when originally planned.
Permit revenue is still expected to be strong in 2020 with the Hines Oak Brook
Commons and other major projects kicking off. These permits are expected to be issued
later this year.
o Charges for Services revenue is down $195,387 from last year and $154,660 under
budget. This is primarily due to a decrease in ambulance fees from fewer calls for
service in March through May.
Total expenditures through June 2020 are $210,088, or 1.8%, lower than last year and $959,568,
or 7.9%, under budget to date. The main drivers for this are:
o Personnel expenditures are up $549,706 from last year, but $236,046 under budget.
The increase is due to a combination of annual pay increases and final accrual payouts
from retirements. Personnel is under budget due to the start of furlough days and a
reduction in overtime due to the COVID-19 pandemic.
o Operation and contract expenditures are down $318,249 from last year and $313,099
under budget. This is due to the general timing of payments compared to when they
were projected to occur. The Village has also put various projects on hold until after the
pandemic is over.
o Capital outlay expenditures are down $446,132 from last year and $325,558 under
budget. Many capital items have been put on hold for 2020 due to the current
economic state.
Hotel Tax Fund
Total revenues through June 2020 are $207,954, or 36.6%, lower than last year and $207,157, or
36.5%, under budget. The main drivers for this are:
o Hotel tax revenue is down $200,986 from last year and $219,927 under budget. The
decrease is due to the timing of receipts being received and a reduction in room rentals
from the COVID-19 pandemic.
Total expenditures through June 2020 are $254,592, or 133.5%, higher than last year and
$36,653, or 9.0%, over budget. The main drivers for this are:
o Operation and contract expenditures are up $37,626 from last year, but $169,918 under
budget. This is due to the timing of advertising payments and the cancelling of some
campaigns. In addition, the Village rebated $69,348 of hotel tax related to January,
February, and March stays back to the hotels.
o Capital Outlay expenditures are up $216,966 from last year and $206,571 over budget.
The street light replacements began earlier than originally projected.
Infrastructure Fund
Total revenues through June 2020 are down $107,627, or 3.6%, from last year and $2,848, or
0.1%, under budget. The main drivers for this are:
o Non-home rule sales tax
revenue is down $47,312 from
last year, but $2,669 over
budget. June 2020 collections
dropped significantly compared
to collections the previous five
years. The decline is related to
the COVID-19 pandemic, which
say numerous businesses closed
in March 2020.
o Interest revenue is down $60,650 from last year and $4,082 under budget. Interest
rates have dropped in recent months compared to last year. In addition, the
Infrastructure Fund’s reserve balance has shifted to cash and other short-term
investments in order to have money available for upcoming projects.
Total expenditures through June 2020 are down $997,494, or 37.6%, from last year and
$5,288,762, or 76.2%, under budget to date. The main drivers for this are:
o Operation and contract expenditures are down $8,528 from last year and $224,692
under budget. Expenditures are under budget due to the timing of engineering
payments. Some projects have been delayed due to the current pandemic.
o Capital Outlay expenditures are down $989,014 from last year and $5,055,883 under
budget. Payments for ongoing projects have not occurred to date and will be delayed
until later in the year or 2021.
Promenade TIF Fund
Total revenues through June 2020 are up $30,766, or 14.9% from last year, but $873, or 0.4%,
under budget. The timing of sales tax transfers has changed in 2020 due to information being
more readily available from IDOR. Interest rates have dropped in recent months compared to
last year, but are still at levels projected for 2020.
Total expenditures through June 2020 are up $34,705, or 14.8%, from last year and $500, or
0.2%, over budget. The increase relates to additional principal and interest paid towards the TIF
note. Expenditures are over budget due to the timing of audit and TIF report fees.
Water Fund
Total revenues through June 2020 are down $394,084, or 9.5%, from last year and $603,264, or
13.9%, under budget. The main drivers for this are:
o Water sales revenue is down $279,754 from last year and $539,559 under budget. The
decrease in water sales relates to the business shut down from the COVID-19 pandemic.
Total expenditures through June 2020 are up $355,860, or 12.0%, from last year, but
$1,888,839, or 36.3%, under budget. The main drivers for this are:
o Operation and contract expenditures are down $255,195 from last year and $1,333,536
under budget. Expenditures are under budget due to the timing of invoices paid and
DuPage Water Commission water purchased being less than expected.
o Capital outlay expenditures are up $601,437 from last year, but $498,577 under budget.
This is due to the final payments for the 2019 water main replacements falling into
2020. A number of budgeted projects for 2020 are on hold due to the current
pandemic.
Sports Core Fund
Total revenues through June 2020 are down $729,222, or 43.7%, from last year and $871,571, or
48.2%, under budget to date. Most revenue sources are under budget to date in 2020 due to
the COVID-19 pandemic limiting activity. Starting in 2020, the Park District took over all Bath
and Tennis Club membership sales, however, this was not factored into the 2020 budget due to
the timing of the agreement. Highlights of Sports core revenues are:
o Membership revenue is down $186,027 from last year and $225,088 under budget. This
is due to a change in memberships being collected by the Park District rather than the
Village. Golf memberships are up $31,563 from last year and $9,288 over budget to
date.
o Greens Fees are down $84,922 from last year and $99,909 under budget. This is due to
the golf course being closed in the spring due to the COVID-19 pandemic.
o Rental income is down $201,246 from last year and $146,916 under budget. This is due
to many events being cancelled this year at the B&T Clubhouse. In addition, golf cart
rental fees are down due to the course being closed in the spring.
Total expenditures through June 2020 are down $529,739, or 24.2%, from last year and
$1,541,749, or 48.1%, under budget to date. The main drivers for this are:
o Personnel expenditures are down $174,625 from last year and $193,491 under budget.
Personnel is down due to the COVID-19 pandemic closing Sports Core facilities for much
of spring.
o Materials & Supplies expenditures are down $109,493 from last year and $211,554
under budget. Expenditures are down due to facilities being closed for much of the
spring.
o Operation and Contractual expenditures are down $379,324 from last year and
$333,325 under budget. This is due to the outsourcing of swimming, tennis, and soccer
fields to the Park District. Previously, the Village paid the Park District $230,000 to
operate the swimming pool.
o Capital expenditures are up $133,703 from last year, but $803,379 under budget. This is
due to the golf lounge renovation project and a delay in the pool renovation project due
to the COVID-19 pandemic.
6/30/20 6/30/20
6/30/19 6/30/20 YTD % of YTD 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 6,396,358$ 6,440,297$ 6,321,750$ 101.9%12,502,000$ 43,939$
Other Intergovernmental Tax*807,596 753,417 773,900 97.4%1,352,000 (54,179)
Telecommunications/Utility Tax 3,264,811 3,045,980 3,228,000 94.4%6,125,000 (218,831)
Licenses and Permits 1,576,668 871,638 1,561,485 55.8%2,990,190 (705,030)
Charges for Services 667,247 471,860 626,520 75.3%1,253,100 (195,387)
Fines and Penalties 121,164 84,633 96,000 88.2%192,000 (36,531)
Administrative Towing Fees 10,486 8,164 9,990 81.7%20,000 (2,322)
Investment Interest 225,634 204,708 207,510 98.6%415,000 (20,926)
Franchise Fees 53,211 51,448 105,000 49.0%210,000 (1,763)
Miscellaneous Income 123,563 191,830 228,850 83.8%443,095 68,267
Total Operating Revenues 13,246,738$ 12,123,975$ 13,159,005$ 92.1%25,502,385$ (1,122,763)$
OPERATING EXPENDITURES
Personnel 8,493,693$ 9,043,399$ 9,279,445$ 97.5%19,160,220$ 549,706$
Materials and Supplies 207,032 214,581 298,820 71.8%539,170 7,549
Operation and Contract 2,111,470 1,793,221 2,106,320 85.1%4,071,660 (318,249)
Other Expenditures 7,336 4,374 5,000 87.5%10,000 (2,962)
Capital Outlay 545,984 99,852 425,410 23.5%688,030 (446,132)
Total Operating Expenditures 11,365,515$ 11,155,427$ 12,114,995$ 92.1%24,469,080$ (210,088)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 1,881,223$ 968,548$ 1,044,010$ 1,033,305$ (912,675)$
INTERFUND TRANSACTIONS
Transfers In 508,235$ -$ -$ 0.0%-$ (508,235)$
Transfers Out (234,668) (326,369) (762,755) 42.8%(923,000) (91,701)
Reimbursements From Other Funds 316,104 313,194 313,200 100.0%626,395 (2,910)
Reimbursements To Other Funds (65,550) (69,882) (69,870) 100.0%(139,770) (4,332)
Total Interfund Transactions 524,121$ (83,057)$ (519,425)$ 16.0%(436,375)$ (607,178)$
NET FUND INCREASE (DECREASE)2,405,344$ 885,491$ 524,585$ 596,930$ (1,519,853)$
*Includes the collection of Income Tax, Use Tax, Road & Bridge Tax, Personal Property Replacement Tax, and Cannabis Use Tax.
Village of Oak Brook
General Fund Financial Update
For the Period Ending June 30, 2020
Total Total
Revenues Expenditures
6/30/20 Actual 12,123,975$ 11,155,427$
6/30/19 Actual 13,246,738$ 11,365,515$
% Change From Last Year -8.5%-1.8%
Major Revenues
Other Telecom/Utility Licenses &Charges for
Sales Tax Intergov. Tax Tax Permits Services
6/30/20 Actual 6,440,297$ 753,417$ 3,045,980$ 871,638$ 471,860$
6/30/19 Actual $ 6,396,358 $ 807,596 $ 3,264,811 $ 1,576,668 $ 667,247
% Change From Last Year 0.7%-6.7%-6.7%-44.7%-29.3%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
6/30/20 Actual 9,043,399$ 214,581$ 1,793,221$ 4,374$ 99,852$
6/30/19 Actual 8,493,693$ 207,032$ 2,111,470$ 7,336$ 545,984$
% Change From Last Year 6.5%3.6%-15.1%-40.4%-81.7%
Five Year Trend
Expenditures by Department
6/30/19 6/30/20 6/30/20 6/30/20 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Department Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 1,129,695$ 981,327$ 1,301,075$ 75.4%2,556,835$ (148,368)$
Financial Services 379,146 381,079 399,105 95.5%781,455 1,933
Public Works 394,542 342,905 446,160 76.9%893,055 (51,637)
Engineering & Capital Projects 303,752 31,739 250,750 12.7%411,500 (272,013)
Library 461,237 397,388 497,070 79.9%994,410 (63,849)
Police 4,256,110 4,582,222 4,597,965 99.7%9,493,905 326,112
Fire 3,972,530 3,953,374 4,119,975 96.0%8,298,370 (19,156)
Development Services 468,503 485,393 502,895 96.5%1,039,550 16,890
Total Expenditures 11,365,515$ 11,155,427$ 12,114,995$ 92.1%24,469,080$ (210,088)$
Five Year Trend
For the Period Ending June 30, 2020
General Fund - Five Year Trend
Village of Oak Brook
Revenues Expenditures
6/30/20 6/30/20
6/30/19 6/30/20 YTD % of YTD 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Hotel Tax 510,359$ 309,373$ 529,300$ 58.4%1,212,500$ (200,986)$
Investment Interest 57,238 41,937 37,500 111.8%75,000 (15,301)
Loan Interest - 8,333 - N/A - 8,333
Total Operating Revenues 567,597$ 359,643$ 566,800$ 63.5%1,287,500$ (207,954)$
EXPENDITURES
Operation and Contract 190,761$ 228,387$ 398,305$ 57.3%576,615$ 37,626$
Capital Outlay - 216,966 10,395 2087.2%640,395 216,966
Total Expenditures 190,761$ 445,353$ 408,700$ 109.0%1,217,010$ 254,592$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 376,836$ (85,710)$ 158,100$ -54.2%70,490$ (462,546)$
INTERFUND TRANSACTIONS
Transfer Out -$ -$ (54,825)$ 0.0%(338,125)$ -$
Reimbursements to Other Funds (51,558) (37,356) (37,350) 100.0%(74,715) 14,202
Total Interfund Transactions (51,558)$ (37,356)$ (92,175)$ 40.5%(412,840)$ 14,202$
NET FUND INCREASE (DECREASE)325,278$ (123,066)$ 65,925$ (342,350)$ (448,344)$
Note - Expenditures are recorded in program 171.
Village of Oak Brook
Hotel Tax Fund Financial Update
For the Period Ending June 30, 2020
Total Total
Revenues Expenditures
6/30/20 Actual $ 359,643 445,353$
6/30/19 Actual $ 567,597 190,761$
% Change From Last Year -36.6%133.5%
Major Revenues Investment
Hotel Tax Interest Loan Interest
6/30/20 Actual $ 309,373 $ 41,937 $ 8,333
6/30/19 Actual $ 510,359 $ 57,238 $ -
% Change From Last Year -39.4%-26.7%0.0%
Five Year Trend
Major Expenditures Operation &
Contractual Capital Outlay
6/30/20 Actual 228,387$ 216,966$
6/30/19 Actual 190,761$ -$
% Change From Last Year 19.7%N/A
Five Year Trend
Village of Oak Brook
Hotel Tax Fund - Major Sources Five Year Trend
For the Period Ending June 30, 2020
Five Year Trend
Revenues Expenditures
6/30/20 6/30/20
6/30/19 6/30/20 YTD % of YTD 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 2,906,481$ 2,859,169$ 2,856,500$ 100.1%5,615,000$ (47,312)$
Charges for Services - 335 510 65.7%1,000 335
Investment Interest 119,058 58,408 62,490 93.5%125,000 (60,650)
Miscellaneous - - 1,260 0.0%2,500 -
Total Operating Revenues 3,025,539$ 2,917,912$ 2,920,760$ 99.9%5,743,500$ (107,627)$
OPERATING EXPENDITURES
Personnel 669,593$ 656,549$ 682,315$ 96.2%1,389,540$ (13,044)$
Materials and Supplies 101,342 114,434 96,855 118.1%253,295 13,092
Operation and Contract 714,566 706,038 930,730 75.9%1,856,790 (8,528)
Capital Outlay 1,164,276 175,262 5,231,145 3.4%10,220,090 (989,014)
Total Operating Expenditures 2,649,777$ 1,652,283$ 6,941,045$ 23.8%13,719,715$ (997,494)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 375,762$ 1,265,629$ (4,020,285)$ -31.5%(7,976,215)$ 889,867$
INTERFUND TRANSACTIONS
Transfers In 216,125$ -$ 54,825$ 0.0%1,653,125$ (216,125)$
Reimbursements From Other Funds 166,722 179,688 179,700 100.0%359,380 12,966
Reimbursements To Other Funds (80,766) (81,150) (81,150) 100.0%(162,300) (384)
Total Interfund Transactions 302,081$ 98,538$ 153,375$ 64.2%1,850,205$ (203,543)$
NET FUND INCREASE (DECREASE)677,843$ 1,364,167$ (3,866,910)$ (6,126,010)$ 686,324$
Village of Oak Brook
Infrastructure Fund Financial Update
For the Period Ending June 30, 2020
Total Total
Revenues Expenditures
6/30/20 Actual $ 2,917,912 1,652,283$
6/30/19 Actual $ 3,025,539 2,649,777$
% Change From Last Year -3.6%-37.6%
Major Revenues
Sales Tax
Charges for
Services
Investment
Interest Miscellaneous Reimbursements
6/30/20 Actual $ 2,859,169 $ 335 $ 58,408 $ - $ 179,688
6/30/19 Actual $ 2,906,481 $ - $ 119,058 $ - $ 166,722
% Change From Last Year -1.6%0.0%-50.9%0.0%7.8%
Five Year Trend
Major Expenditures Materials &Operation &
Personnel Supplies Contractual Capital Outlay
6/30/20 Actual 656,549$ 114,434$ 706,038$ 175,262$
6/30/19 Actual 669,593$ 101,342$ 714,566$ 1,164,276$
% Change From Last Year -1.9%12.9%-1.2%-84.9%
Five Year Trend
Expenditures by Department
6/30/19 6/30/20 6/30/20 6/30/20 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 72,788$ 73,081$ 88,210$ 82.8%176,490$ 293$
Public Works 1,098,801 1,102,733 3,103,300 35.5%4,390,810 3,932
Engineering & Capital Projects 1,478,188 476,469 3,749,535 12.7%9,152,415 (1,001,719)
Total Expenditures 2,649,777$ 1,652,283$ 6,941,045$ 23.8%13,719,715$ (997,494)$
Five Year Trend
Village of Oak Brook
Infrastructure Fund - Major Sources Five Year Trend
For the Period Ending June 30, 2020
Revenues Expenditures
6/30/20 6/30/20
6/30/19 6/30/20 YTD % of YTD 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax -$ 29,658$ 47,500$ 62.4%95,000$ 29,658$
Real Estate Tax 205,855 207,272 190,000 109.1%380,000 1,417
Investment Interest 756 447 750 59.6%1,500 (309)
Total Operating Revenues 206,611$ 237,377$ 238,250$ 99.6%476,500$ 30,766$
EXPENDITURES
Operation and Contract 3,210$ 3,590$ 3,090$ 116.2%3,890$ 380$
Other Expenditures 231,130 265,455 265,455 100.0%504,900 34,325
Total Expenditures 234,340$ 269,045$ 268,545$ 100.2%508,790$ 34,705$
NET FUND INCREASE (DECREASE)(27,729)$ (31,668)$ (30,295)$ (32,290)$ (3,939)$
Note - Expenditures are recorded in program 283.
Village of Oak Brook
Promenade TIF Fund Financial Update
For the Period Ending June 30, 2020
Total Total
Revenues Expenditures
6/30/20 Actual $ 237,377 269,045$
6/30/19 Actual $ 206,611 234,340$
% Change From Last Year 14.9%14.8%
Major Revenues Real Estate Investment
Sales Tax Tax Interest
6/30/20 Actual 29,658$ $ 207,272 $ 447
6/30/19 Actual -$ $ 205,855 $ 756
% Change From Last Year N/A 0.7%-40.9%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures
6/30/20 Actual 3,590$ 265,455$
6/30/19 Actual 3,210$ 231,130$
% Change From Last Year 11.8%14.9%
Five Year Trend
Village of Oak Brook
Promenade TIF Fund - Major Sources Five Year Trend
For the Period Ending June 30, 2020
Five Year Trend
Revenues Expenditures
6/30/20 6/30/20
6/30/19 6/30/20 YTD % of YTD 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Plan Review Fees 750$ 225$ 600$ 37.5%1,200$ (525)$
Building/Inspection Fees 2,550 4,987 3,990 125.0%8,000 2,437
Water Sales 3,885,195 3,605,441 4,145,000 87.0%10,302,525 (279,754)
Unmetered Sales 7,883 27,433 15,000 182.9%30,000 19,550
Water Connection Fees 89,010 5,080 50,010 10.2%100,000 (83,930)
Meter Charges 7,457 4,442 10,010 44.4%20,000 (3,015)
Special Services 16,772 12,657 15,000 84.4%30,000 (4,115)
Investment Interest 89,477 57,883 65,010 89.0%130,000 (31,594)
Miscellaneous 33,846 20,708 37,500 55.2%75,000 (13,138)
Total Operating Revenues 4,132,940$ 3,738,856$ 4,342,120$ 86.1%10,696,725$ (394,084)$
OPERATING EXPENDITURES
Personnel 374,037$ 390,095$ 419,605$ 93.0%868,705$ 16,058$
Materials and Supplies 17,829 11,389 38,605 29.5%74,260 (6,440)
Operation and Contract 1,844,994 1,589,799 2,923,335 54.4%5,833,755 (255,195)
Capital Outlay 719,986 1,321,423 1,820,000 72.6%6,293,225 601,437
Total Expenditures 2,956,846$ 3,312,706$ 5,201,545$ 63.7%13,069,945$ 355,860$
Surplus (Deficit) of Revenues Over
Expenditures 1,176,094$ 426,150$ (859,425)$ -49.6%(2,373,220)$ (749,944)$
INTERFUND TRANSACTIONS
Transfers In 221,085$ -$ -$ 0.0%-$ (221,085)
Reimbursements To Other Funds (275,916) (263,406) (263,400) 100.0%(526,815) 12,510
Total Interfund Transactions (54,831)$ (263,406)$ (263,400)$ 100.0%(526,815)$ (208,575)$
Fund Increase/(Decrease) - Budgetary Basis 1,121,263$ 162,744$ (1,122,825)$ -14.5%(2,900,035)$ (958,519)$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay 719,986$ 1,321,423$
Depreciation Expense (256,053) (287,500)
IMRF Pension Expense 38,618 25,000
OPEB Expense (24,513) (22,500)
Total GAAP Adjustments 478,039$ 1,036,423$
Fund Increase/(Decrease) - GAAP Basis 1,599,302$ 1,199,167$
*Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.
Village of Oak Brook
Water Fund Financial Update
For the Period Ending June 30, 2020
Total Total
Revenues Expenditures
6/30/20 Actual $ 3,738,856 3,312,706$
6/30/19 Actual $ 4,132,940 2,956,846$
% Change From Last Year -9.5%12.0%
Unmetered Water
Water Sales Sales Connection Fees Meter Charges Miscellaneous
6/30/20 Actual $ 3,605,441 $ 27,433 $ 5,080 $ 4,442 $ 20,708
6/30/19 Actual $ 3,885,195 $ 7,883 $ 89,010 $ 7,457 $ 33,846
% Change From Last Year -7.2%248.0%-94.3%-40.4%-38.8%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
6/30/20 Actual 390,095$ 11,389$ 1,589,799$ -$ 1,321,423$
6/30/19 Actual 374,037$ 17,829$ 1,844,994$ -$ 719,986$
% Change From Last Year 4.3%-36.1%-13.8%0.0%83.5%
Five Year Trend
Expenditures by Department
6/30/19 6/30/20 6/30/20 6/30/20 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Public Works 2,230,866$ 1,995,888$ 3,256,755$ 61.3%6,527,120$ (234,978)$
Engineering & Capital Projects 725,980 1,316,818 1,944,790 67.7%6,542,825 590,838
Total Expenditures 2,956,846$ 3,312,706$ 5,201,545$ 63.7%13,069,945$ 355,860$
Five Year Trend
Village of Oak Brook
Water Fund - Major Sources Five Year Trend
For the Period Ending June 30, 2020
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Sports Core Fund Consolidated Presentation
For the Period Ending June 30, 2020
6/30/20 6/30/20
6/30/20 YTD % of YTD 2020 6/30/19 Difference
B&T Recreation Field Clubhouse Golf YTD Amended Amended Adopted YTD Prior
Operations Operations Operations Club Total Budget Budget Budget Total Year
OPERATING REVENUES
Memberships 199$ -$ -$ 226,788$ 226,987$ 452,075$ 50.2%459,135$ 413,014$ (186,027)$
Greens Fees - - - 256,091 256,091 356,000 71.9%930,000 341,013 (84,922)
Pro Shop Sales - - - 57,437 57,437 102,500 56.0%207,000 98,865 (41,428)
Golf Lessons - - - 7,105 7,105 27,000 26.3%40,000 27,885 (20,780)
Driving Range Fees - - - 113,636 113,636 155,000 73.3%244,000 153,302 (39,666)
Rentals - 87,540 12,648 76,541 176,729 323,645 54.6%962,000 377,975 (201,246)
Programs/User Fees - - - - - 35,250 0.0%66,300 42,889 (42,889)
Food Sales - - - 30,371 30,371 69,815 43.5%180,500 69,213 (38,842)
Beverage Sales - - - 66,616 66,616 100,390 66.4%265,000 102,860 (36,244)
Taste of Oak Brook - - - - - 40,000 0.0%120,000 33,298 (33,298)
Grants - - - - - 139,800 0.0%139,800 - -
Other Revenue (7) - - 2,769 2,762 7,830 35.3%11,000 6,642 (3,880)
Total Operating Revenues 192$ 87,540$ 12,648$ 837,354$ 937,734$ 1,809,305$ 51.8%3,624,735$ 1,666,956$ (729,222)$
OPERATING EXPENDITURES
Personnel 2,259$ -$ 52,561$ 439,689$ 494,509$ 688,000$ 71.9%1,578,100$ 669,134$ (174,625)$
Materials & Supplies 1,149 119 1,527 147,976 150,771 362,325 41.6%618,025 260,264 (109,493)
Operational & Contractual 34,458 34,864 30,567 132,006 231,895 565,220 41.0%1,055,095 611,219 (379,324)
Other - - - - - - 0.0%(83,150) - -
Capital 342,657 8,710 1,293 430,461 783,121 1,586,500 49.4%1,921,545 649,418 133,703
Total Operating Expenditures 380,523$ 43,693$ 85,948$ 1,150,132$ 1,660,296$ 3,202,045$ 51.9%5,089,615$ 2,190,035$ (529,739)$
B&T Administration Overhead Allocation*28,963$ -$ (28,963)$ -$ -$ -$ 0.0%-$ -$ -$
Operating Revenues Over (Under) Expenditures (351,368)$ 43,847$ (102,263)$ (312,778)$ (722,562)$ (1,392,740)$ 51.9%(1,464,880)$ (523,079)$ (199,483)$
INTERFUND TRANSACTIONS
Transfer From General Fund 326,369$ -$ -$ -$ 326,369$ 762,755$ 42.8%923,000$ 234,668$ 91,701$
Transfer From Hotel Tax Fund - - - - - - 0.0%35,000 - -
Transfer From Golf Surcharge Fund - - - 323,373 323,373 400,000 80.8%400,000 206,341 117,032
Reimbursement From Infrastructure Fund 12,000 - - - 12,000 11,995 100.0%24,000 12,000 -
Reimbursement From Water Fund 4,002 - - - 4,002 3,995 100.2%8,000 4,002 -
Reimbursement To General Fund (14,112) - - (14,112) (28,224) (28,200) 100.1%(56,450) - (28,224)
Total Interfund Transactions 328,259$ -$ -$ 309,261$ 637,520$ 1,150,545$ 55.4%1,333,550$ 457,011$ 180,509$
Total Revenues Over (Under) Expenditures - Budgetary Basis (23,109)$ 43,847$ (102,263)$ (3,517)$ (85,042)$ (242,195)$ (131,330)$ (66,068)$ (18,974)$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 342,657$ 8,710$ 1,293$ 430,461$ 783,121$ 649,418$
Depreciation Expense (74,952) (843) (17,500) (106,000) (199,294) (164,195)
IMRF Pension Expense (2,625) (125) (1,000) (5,925) (9,675) 46,386
OPEB Expense - - (2,600) (20,000) (22,600) (10,018)
Total GAAP Adjustments 265,081$ 7,743$ (19,807)$ 298,536$ 551,552$ 521,592$
Fund Increase/(Decrease) - GAAP Basis 241,972$ 51,590$ (122,070)$ 295,019$ 466,510$ 455,524$
*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.
**Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.
Total Direct Total Direct
Revenues Expenditures
6/30/20 Actual $ 937,734 1,660,296$
6/30/19 Actual $ 1,666,956 2,190,035$
% Change From Last Year -43.7%-24.2%
Driving Program/
Memberships Greens Fees Range Fees Rentals User Fees
6/30/20 Actual $ 226,987 $ 256,091 $ 113,636 $ 176,729 $ -
6/30/19 Actual $ 413,014 $ 341,013 $ 153,302 $ 377,975 $ 42,889
% Change From Last Year -45.0%-24.9%-25.9%-53.2%-100.0%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
6/30/20 Actual 494,509$ 150,771$ 231,895$ -$ 783,121$
6/30/19 Actual 669,134$ 260,264$ 611,219$ -$ 649,418$
% Change From Last Year -26.1%-42.1%-62.1%0.0%20.6%
Five Year Trend
Revenues by Department 6/30/19 6/30/20 6/30/20 6/30/20 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Operations 281,441$ 192$ 433,455$ 0.0%506,735$ (260,792)$
Open Field Operations 184,853 87,540 131,920 66.4%407,000 (64,015)
B&T Clubhouse Operations 104,981 12,648 80,000 15.8%300,000 (92,333)
Golf Club 1,095,681 837,354 1,163,930 71.9%2,411,000 (258,327)
Total Revenues 1,666,956$ 937,734$ 1,809,305$ 51.8%3,624,735$ (675,467)$
Expenditures by Department 6/30/19 6/30/20 6/30/20 % of YTD 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Operations 497,416$ 380,523$ 1,279,960$ 29.7%1,752,045$ (116,893)$
Open Field Operations 90,555$ 43,693$ 31,000$ 140.9%267,110$ (46,862)$
B&T Clubhouse Operations 457,823 85,948 321,130 26.8%458,770 (371,875)
Golf Club 1,144,241 1,150,132 1,569,955 73.3%2,611,690 5,891
Total Expenditures 2,190,035$ 1,660,296$ 3,202,045$ 51.9%5,089,615$ (529,739)$
Five Year Trend
Village of Oak Brook
Sports Core Fund - Major Sources Five Year Trend
For the Period Ending June 30, 2020
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Club Recreation Operations
For the Period Ending June 30, 2020 6/30/20 6/30/20
822 6/30/20 YTD % of YTD 2020 6/30/19 Difference
811 812 813 Poolside YTD Amended Amended Adopted YTD Prior
B&T Admin Swimming Tennis Café Total Budget Budget Budget Total Year
OPERATING REVENUES
Memberships -$ 199$ -$ -$ 199$ 234,575$ 0.1%241,635$ 217,789$ (217,590)$
Programs/User Fees - - - - - 35,250 0.0%66,300 42,889 (42,889)
Food Sales - - - - - 15,000 0.0%36,000 13,379 -
Beverage Sales - - - - - 7,500 0.0%20,000 7,078 -
Grants - - - - - 139,800 0.0%139,800 - -
Other Revenue (7) - - - (7) 1,330 -0.5%3,000 306 (313)
Total Operating Revenues (7)$ 199$ -$ -$ 192$ 433,455$ 0.0%506,735$ 281,441$ (260,792)$
OPERATING EXPENDITURES
Personnel 2,165$ -$ -$ 94$ 2,259$ 80,535$ 2.8%163,580$ 69,052$ (66,793)$
Materials & Supplies 206 787 156 - 1,149 46,100 2.5%57,650 32,932 (31,783)
Operational & Contractual 26,025 3,760 4,589 84 34,458 340,825 10.1%418,270 325,074 (290,616)
Capital 15,409 326,369 879 - 342,657 812,500 42.2%1,112,545 70,358 272,299
Total Operating Expenditures 43,805$ 330,916$ 5,624$ 178$ 380,523$ 1,279,960$ 29.7%1,752,045$ 497,416$ (116,893)$
B&T Administration Overhead Allocation*57,926$ (20,853)$ (5,793)$ (2,317)$ 28,963$ 62,820$ 46.1%93,235$ 61,082$ (32,119)$
Operating Revenues Over (Under) Expenditures 14,114$ (351,570)$ (11,417)$ (2,495)$ (351,368)$ (783,685)$ 44.8%(1,152,075)$ (154,893)$ (176,018)$
INTERFUND TRANSACTIONS
Transfer From General Fund -$ 326,369$ -$ -$ 326,369$ 597,255$ 54.6%757,500$ 32,171$ 294,198$
Reimbursement From Infrastructure Fund 12,000 - - - 12,000 11,995 100.0%24,000 12,000 -
Reimbursement From Water Fund 4,002 - - - 4,002 3,995 100.2%8,000 4,002 -
Reimbursement To General Fund (14,112) - - - (14,112) (14,100) 100.1%(28,225) - (14,112)
Total Interfund Transactions 1,890$ 326,369$ -$ -$ 328,259$ 599,145$ 54.8%761,275$ 48,173$ 280,086$
Total Revenues Over (Under) Expenditures - Budgetary Basis 16,004$ (25,201)$ (11,417)$ (2,495)$ (23,109)$ (184,540)$ (390,800)$ (106,720)$ 104,068$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 15,409$ 326,369$ 879$ -$ 342,657$ 70,358$
Depreciation Expense - (71,868) (2,500) (584) (74,952) (47,412)
IMRF Pension Expense (2,500) - - (125) (2,625) 3,050
Total GAAP Adjustments 12,909$ 254,502$ (1,621)$ (709)$ 265,081$ 25,996$
Fund Increase/(Decrease) - GAAP Basis 28,913$ 229,301$ (13,038)$ (3,204)$ 241,972$ (80,725)$
*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.
**Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.
Village of Oak Brook
Monthly Operating Statement
Open Fields Operations
For the Period Ending June 30, 2020 6/30/20 6/30/20
6/30/20 YTD % of YTD 2020 6/30/19 Difference
815 816 YTD Amended Amended Adopted YTD Prior
Polo Open Fields Total Budget Budget Budget Total Year
OPERATING REVENUES
Field Rentals -$ 12,540$ 12,540$ 91,920$ 13.6%212,000$ 76,555$ (64,015)$
Range Rentals - 75,000 75,000 - N/A 75,000 75,000 -
Taste of Oak Brook - - - 40,000 0.0%120,000 33,298 -
Total Operating Revenues -$ 87,540$ 87,540$ 131,920$ 66.4%407,000$ 184,853$ (64,015)$
OPERATING EXPENDITURES
Personnel -$ -$ -$ -$ 0.0%10,810$ -$ -$
Materials & Supplies - 119 119 500 23.8%1,700 - 119
Operational & Contractual 20,000 14,864 34,864 25,500 136.7%239,600 86,496 (51,632)
Capital - 8,710 8,710 5,000 174.2%15,000 4,059 4,651
Total Operating Expenditures 20,000$ 23,693$ 43,693$ 31,000$ 140.9%267,110$ 90,555$ (46,862)$
Operating Revenues Over (Under) Expenditures (20,000)$ 63,847$ 43,847$ 100,920$ 43.4%139,890$ 94,298$ (17,153)$
INTERFUND TRANSACTIONS
Transfer From Hotel Tax Fund -$ -$ -$ -$ 0.0%35,000$ -$ -$
Total Interfund Transactions -$ -$ -$ -$ 0.0%35,000$ -$ -$
Total Revenues Over (Under) Expenditures - Budgetary Basis (20,000)$ 63,847$ 43,847$ 100,920$ 174,890$ 94,298$ (17,153)$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay -$ 8,710$ 8,710$ 4,059$
Depreciation Expense - (843) (843) (843)
IMRF Pension Expense - (125) (125) 368
Total GAAP Adjustments -$ 7,743$ 7,743$ 3,584$
Fund Increase/(Decrease) - GAAP Basis (20,000)$ 71,590$ 51,590$ 97,882$
*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.
**Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Clubhouse Operations
For the Period Ending June 30, 2020
6/30/20 6/30/20
821 YTD % of YTD 2020 6/30/19 Difference
B&T Amended Amended Adopted YTD Prior
Clubhouse Budget Budget Budget Total Year
OPERATING REVENUES
Rentals 12,648$ 80,000$ 15.8%300,000$ 104,981$ (92,333)$
Total Operating Revenues 12,648$ 80,000$ 15.8%300,000$ 104,981$ (92,333)$
OPERATING EXPENDITURES
Personnel 52,561$ 64,695$ 81.2%140,045$ 62,219$ (9,658)$
Materials & Supplies 1,527 10,935 14.0%20,225 3,191 (1,664)
Operational & Contractual 30,567 56,500 54.1%109,500 45,417 (14,850)
Capital 1,293 189,000 0.7%189,000 346,996 (345,703)
Total Operating Expenditures 85,948$ 321,130$ 26.8%458,770$ 457,823$ (371,875)$
B&T Administration Overhead Allocation*(28,963)$ (62,820)$ 46.1%(93,235)$ (61,082)$ 32,119$
Operating Revenues Over (Under) Expenditures (102,263)$ (303,950)$ 33.6%(252,005)$ (413,924)$ 311,661$
INTERFUND TRANSACTIONS
Transfer From General Fund -$ 165,500$ 0.0%165,500$ 202,497$ (202,497)$
Total Interfund Transactions -$ 165,500$ 0.0%165,500$ 202,497$ (202,497)$
Total Revenues Over (Under) Expenditures - Budgetary Basis (102,263)$ (138,450)$ (86,505)$ (211,427)$ 109,164$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 1,293$ 346,996$
Depreciation Expense (17,500) (16,076)
IMRF Pension Expense (1,000) 3,350
OPEB Expense (2,600) (1,050)
Total GAAP Adjustments (19,807)$ 333,220$
Fund Increase/(Decrease) - GAAP Basis (122,070)$ 121,793$
*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.
**Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.
Village of Oak Brook
Monthly Operating Statement
Golf Club Programs
For the Period Ending June 30, 2020
6/30/20 6/30/20
823 831 832 833 834 6/30/20 YTD % of YTD 2020 6/30/19 Difference
Golf Golf General Golf Learning Golf Cart Golf Course YTD Amended Amended Adopted YTD Prior
Café Operation & Practice Operations Maintenance Total Budget Budget Budget Total Year
OPERATING REVENUES
Memberships -$ 226,788$ -$ -$ -$ 226,788$ 217,500$ 104.3%217,500$ 195,225$ 31,563$
Greens Fees - 256,091 - - - 256,091 356,000 71.9%930,000 341,013 (84,922)
Pro Shop Sales - 57,437 - - - 57,437 102,500 56.0%207,000 98,865 (41,428)
Golf Lessons - - 7,105 - - 7,105 27,000 26.3%40,000 27,885 (20,780)
Driving Range Fees - - 113,636 - - 113,636 155,000 73.3%244,000 153,302 (39,666)
Rentals - 20 - 76,521 - 76,541 151,725 50.4%375,000 121,439 (44,898)
Food Sales 30,371 - - - - 30,371 54,815 55.4%144,500 55,834 (25,463)
Beverage Sales 66,616 - - - - 66,616 92,890 71.7%245,000 95,782 (29,166)
Other Revenue - 2,769 - - - 2,769 6,500 42.6%8,000 6,336 (3,567)
Total Operating Revenues 96,987$ 543,105$ 120,741$ 76,521$ -$ 837,354$ 1,163,930$ 71.9%2,411,000$ 1,095,681$ (258,327)$
OPERATING EXPENDITURES
Personnel 39,557$ 206,992$ 5,681$ 12,483$ 174,976$ 439,689$ 542,770$ 81.0%1,263,665$ 537,863$ (98,174)$
Materials & Supplies 57,246 30,868 4,527 478 54,857 147,976 304,790 48.6%538,450 224,141 (76,165)
Operational & Contractual 3,380 75,834 121 26,492 26,179 132,006 142,395 92.7%287,725 154,232 (22,226)
Other - - - - - - - 0.0%(83,150) - -
Capital - 347,754 - - 82,707 430,461 580,000 74.2%605,000 228,005 202,456
Total Operating Expenditures 100,183$ 661,448$ 10,329$ 39,453$ 338,719$ 1,150,132$ 1,569,955$ 73.3%2,611,690$ 1,144,241$ 5,891$
Operating Revenues Over (Under) Expenditures (3,196)$ (118,343)$ 110,412$ 37,068$ (338,719)$ (312,778)$ (406,025)$ 77.0%(200,690)$ (48,560)$ (264,218)$
INTERFUND TRANSACTIONS
Transfer from Golf Surcharge -$ 323,373$ -$ -$ -$ 323,373$ 400,000$ 80.8%400,000$ 206,341$ 117,032$
Reimbursement to General Fund - (14,112) - - - (14,112) (14,100) 100.1%(28,225) - (14,112)
Total Interfund Transactions -$ 309,261$ -$ -$ -$ 309,261$ 385,900$ 80.1%371,775$ 206,341$ 102,920$
Total Revenues Over (Under) Expenditures - Budgetary Basis (3,196)$ 190,918$ 110,412$ 37,068$ (338,719)$ (3,517)$ (20,125)$ 171,085$ 157,781$ (161,298)$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay -$ 347,754$ -$ -$ 82,707$ 430,461$ 228,005$
Depreciation Expense - (67,500) (2,000) (11,500) (25,000) (106,000) (99,865)
IMRF Pension Expense (750) (2,500) (175) - (2,500) (5,925) 39,619
OPEB Expense (1,500) (11,500) - - (7,000) (20,000) (8,968)
Total GAAP Adjustments (2,250)$ 266,254$ (2,175)$ (11,500)$ 48,207$ 298,536$ 158,792$
Fund Increase/(Decrease) - GAAP Basis (5,446)$ 457,172$ 108,237$ 25,568$ (290,512)$ 295,019$ 316,573$
*Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.