05 - May 2020 Monthly Financial ReportVILLAGE
OAK BROOK
OF
MONTHLY FINANCIAL REPORTS
MAY 2020
ITEM 6.D
Cash and Investments by Fund:Total
Cash and Cash Pooled Cash and
Fund Equivalents Investments Investments % By Fund
General Corporate $7,221,976 $14,810,891 $22,032,867 48.0%
Hotel/Motel Tax 2,314,871 2,476,379 4,791,250 10.4%
Motor Fuel Tax 1,234,072 71,005 1,305,077 2.8%
Infrastructure 7,144,017 2,008,097 9,152,114 19.9%
Promenade TIF 63,010 - 63,010 0.1%
Water 3,260,986 3,507,087 6,768,073 14.7%
Sports Core - - - 0.0%
Golf Surcharge 29,246 7,032 36,278 0.1%
Self-Insurance 537,602 - 537,602 1.2%
Garage 315,086 - 315,086 0.7%
Equipment Replacement 508,739 380,733 889,472 1.9%
Total $22,629,605 $23,261,224 $45,890,829 100.0%
Change in Cash and Investments by Fund :
Balance at Balance at Year-to-Date Year-to-Date
Fund January 1, 2020 May 31, 2020 Change ($)Change (%)
General Corporate $21,270,239 $22,032,867 $762,628 3.6%
Hotel/Motel Tax 5,427,474 4,791,250 (636,224)-11.7%
Motor Fuel Tax 1,085,595 1,305,077 219,482 20.2%
Infrastructure 8,217,724 9,152,114 934,390 11.4%
Promenade TIF 304,194 63,010 (241,184)-79.3%
Water 6,947,239 6,768,073 (179,166)-2.6%
Sports Core 231,216 - (231,216)-100.0%
Golf Surcharge 347,066 36,278 (310,788)-89.5%
Self-Insurance 308,820 537,602 228,782 74.1%
Garage 275,988 315,086 39,098 14.2%
Equipment Replacement 808,879 889,472 80,593 10.0%
$45,224,434 $45,890,829 $666,395 1.5%
Book Bank/Market
Value Value
Cash and Cash Equivalents:
Pooled Checking $585,660 $1,493,416
Sports Core Checking 132,547 74,101
Pooled IPTIP 21,624,723 21,624,723
Water E-Pay IPTIP 286,675 265,083
$22,629,605 $23,457,323
Pooled Investments:
Investments-Municipal Bonds $6,007,356 $6,035,714
Investments-Corporate Bonds 8,812,276 8,942,788
Government & Agency Obligations 2,037,030 2,075,962
Certificates of Deposit 6,240,000 6,336,580
Accrued Interest 164,562 164,562
Total Pooled Investments $23,261,224 $23,555,606
Total Cash and Investments $45,890,829 $47,012,929
For May, total interest revenue is $56,636 and YTD is $330,325. The total investment yield for the portfolio is:
Pooled
Investments Illinois Funds Total
Last 12 months yield 2.28%1.81%2.05%
The weighted average yield of the current pooled investment portfolio is 2.22%. The IL Funds May average daily rate was 0.735%.
Monthly Treasurer's Report
May 31, 2020
Monthly Treasurer's Report
May 2020
The table below lists the detail investment holdings at J.P. Morgan Securities as of 5/31/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,619 201,924 377
Florida Hurricane #34074GDH4 03/30/16 07/01/20 2.995%2.150%500,257 500,945 6,239
Bloomingdale Mich Pub Sch Dist #094383FS0 04/26/16 05/01/22 2.710%2.150%505,187 511,620 1,090
Connecticut St GO Bds 2016 #20772J3F7 06/15/17 08/15/21 1.750%2.300%496,761 503,330 2,523
Wright County Min #982276BC0 07/18/19 12/01/20 2.000%2.000%545,000 547,038 5,965
State of IL #452152P54 10/09/19 11/01/21 5.000%1.870%521,885 506,585 1,832
Anchor Bay Mich Sch #032879TE8 11/01/19 05/01/21 2.320%1.750%718,714 715,787 1,244
Brownsville TX #16405ST9 12/19/19 02/15/22 2.050%2.000%555,455 562,653 3,192
Laredo TX Waterworks #517039VW0 12/19/19 03/01/24 2.230%2.230%455,000 463,331 2,480
Manchester NH #562333JE5 03/12/20 12/01/20 5.000%0.850%484,835 486,372 11,835
Oakland Univ Mich #673588HJ1 04/29/20 03/01/24 5.000%1.650%330,782 335,955 3,688
Philadelphia PA GO Ref #717813SW0 05/05/20 08/01/22 5.000%1.820%416,337 425,658 6,297
Maryland St DOT #574204WG4 05/06/20 06/15/22 4.350%1.200%276,524 274,516 5,099
Total Municipal Bonds $6,007,356 $6,035,714 $51,861
Corporate Bonds:
Goldman Sachs #38141GVP9 09/26/18 09/15/20 2.750%3.180%499,402 502,260 2,865
Wells Fargo #94974BGR5 01/15/19 12/07/20 2.550%3.120%1,386,071 1,404,067 17,427
PNC Bank #69353RFH6 01/30/19 01/22/21 2.500%3.020%498,376 505,800 4,479
Morgan Stanley #61747WAL3 03/08/19 07/28/21 5.500%3.034%1,079,083 1,105,619 19,571
Citigroup #172967LC3 04/01/19 12/08/21 2.900%2.754%1,002,150 1,027,360 13,372
Bank of America #06051GFT1 04/03/19 10/19/20 2.625%2.625%700,000 706,076 1,889
Goldman Sachs #38143U8F1 05/02/19 02/25/21 2.875%2.707%365,431 369,876 2,771
American Honda #02665WBG5 07/31/19 09/09/21 1.700%2.180%497,018 504,365 1,959
BB&T Corp #05531FAZ6 08/15/19 02/01/21 2.150%2.010%750,724 757,335 5,178
JP Morgan #48128BAB7 09/30/19 01/15/23 2.972%2.337%1,016,035 1,032,010 11,228
JP Morgan #46625HRT9 01/30/20 06/07/21 2.400%1.648%503,766 508,885 5,800
American Express #025816CD9 05/05/20 05/20/22 2.750%1.290%514,220 519,135 277
Total Corporate Bonds $8,812,276 $8,942,788 $86,816
Government & Agency Obligations:
*Government National Mtg Assn #38379UEM4 02/29/16 02/16/51 2.300%2.245%$596,725 $591,501 $2,323
*Government National Mtg Assn #38381WV96 08/06/19 07/20/54 2.250%2.293%830,898 851,754 1,478
*Government National Mtg Assn #38380BNV3 12/05/19 06/20/46 2.000%2.112%609,407 632,707 964
Total Government & Agency Obligations:$2,037,030 $2,075,962 $4,765
Certificates of Deposit:
State Bk India NY #8562846A7 01/26/17 01/26/22 2.250%2.250%$245,000 $253,254 $1,915
American Express Centurion #02587DV96 08/15/17 08/17/20 1.900%1.900%245,000 245,968 1,339
Sallie Mae #795450C86 08/16/17 08/17/20 1.900%1.900%245,000 245,968 1,339
Merrick Bank South Jordan #59013JZS1 08/21/17 08/21/20 1.800%1.800%245,000 245,948 119
Pinnacle Bank #72345SFS5 08/30/17 08/31/20 1.800%1.800%115,000 115,493 174
Jackson County Bank #466682AP6 08/31/17 03/01/21 1.850%1.850%245,000 248,178 1,139
Barclays Bank #06740KKX4 09/27/17 09/28/20 1.950%1.950%245,000 246,517 843
Goldman Sachs Bank #38148PRK5 10/18/17 10/19/20 1.950%1.950%245,000 246,776 551
FirstBank PR Santurce #33767A6M8 11/03/17 11/03/20 2.000%2.000%245,000 246,977 361
Compass Bank #20451PVW3 10/26/18 10/26/20 3.000%3.000%245,000 247,935 684
UBS Bank #90348JFH8 10/30/18 10/29/20 3.050%3.050%245,000 248,006 633
Discover Bank #254673WF9 11/07/18 11/09/20 3.000%3.000%245,000 248,207 480
Ally Bank #02007GFX6 11/08/18 11/09/20 3.000%3.000%245,000 248,207 459
Comenity Cap Bank #20033AU46 04/15/19 04/15/21 2.500%2.500%245,000 250,037 245
Morgan Stanley #61760AE21 05/30/19 06/01/21 2.400%2.400%245,000 250,486 2,916
First St Bank DeQueen #336460CU2 07/18/19 07/19/21 2.000%2.000%245,000 250,072 193
Bank Hapoalim #06251AW89 07/19/19 07/19/21 2.000%2.000%245,000 250,348 1,694
Capital One Natl Assn #14042RMF5 07/24/19 07/26/19 2.050%2.050%245,000 250,294 1,863
TIAA FSB Jacksonville #87270LCN1 07/29/19 07/29/21 2.000%2.000%245,000 250,189 1,654
Wells Fargo #949763J31 09/18/19 09/20/21 1.850%1.850%245,000 250,309 193
BMW Bank #05580ASQ8 10/11/19 10/12/21 1.800%1.800%245,000 250,395 545
Wells Fargo #949495AN5 01/17/20 01/18/22 1.800%1.800%245,000 251,350 192
Southpoint Bank #84464PBK2 02/28/20 02/28/22 1.600%1.600%245,000 245,897 13
Bank Leumi #063248KQ0 03/31/20 03/31/22 1.250%1.250%245,000 249,621 510
Capital One Natl Assn #14042TCZ8 04/01/20 04/01/22 1.350%1.350%245,000 250,064 542
Synchrony Bank #87164WZN1 04/03/20 04/04/22 1.350%1.350%245,000 250,084 524
Total Certificates of Deposits $6,240,000 $6,336,580 $21,120
Total J.P.Morgan Securities $23,096,662 $23,391,044 $164,562
*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
May 31, 2020
Cash & Investments by Fund - Total $45.9 million
Cash & Investments by Type - Total $45.9 million
Checking
Illinois Funds
Certificates of Deposit
Municipal Bonds
Corporate Bonds
Government & Agency Obligations
Accrued Interest
General Corporate
48.01%
Hotel/Motel Tax
10.44%Motor Fuel Tax
2.84%
Infrastructure
19.94%
Promenade TIF
0.14%
Water
14.75%
Sports Core
0.00%
Golf Surcharge
0.08%
Self-Insurance
1.17%Garage
0.69%
Equipment
Replacement
1.94%
Checking, $0.7
Illinois Funds, $21.9
Certificates of Deposit,
$6.3
Municipal Bonds, $6.0
Corporate Bonds, $8.8
Government & Agency
Obligations, $2.0
Accrued Interest, $0.2
in millions
YTD YTD
Net Fund Budgeted
YTD YTD Increase Increase
Governmental Funds Revenues Expenditures (Decrease)(Decrease)
General Fund (Major Fund)10,660,724$ 9,912,282$ 748,442$ 326,375$
Main operating fund of the Village.
Hotel Fund (Major Fund)331,492$ 472,584$ (141,092)$ (3,545)$
Collects and spends resources from the
3% hotel/motel tax.
Motor Fuel Tax Fund 224,643$ -$ 224,643$ 133,575$
Collects and spends resources from the
State motor fuel tax.
Infrastructure Fund (Major Fund)2,756,647$ 1,462,947$ 1,293,700$ (3,216,930)$
Accounts for construction and maintenance of
roadways, drainage, and safety path systems.
Promenade TIF Fund (Major Fund)25,311$ 266,495$ (241,184)$ (241,080)$
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,484,603$ 2,696,296$ 788,307$ (765,485)$
Collects user fees for the distribution of water
and maintenance of infrastructure.
Sports Core Fund (Major Fund)1,287,863$ 1,369,682$ (81,819)$ (561,825)$
Accounts for revenues and expenses relating
to administration, programs, food and beverage
operations, and golf course.
Golf Surcharge Fund 12,586$ 323,373$ (310,787)$ (371,950)$
Accounts for the collection of the $3 per round
golf surcharge.
Internal Service Funds
Self Insurance Fund 1,448,215$ 995,457$ 452,758$ (17,500)$
Accounts for the Village's health insurance costs
and the related contributions from the Village,
employees, retirees, and other agencies.
Garage Fund 306,638$ 263,147$ 43,491$ (9,725)$
Accounts for the maintenance of the Village's vehicle
fleet and the related departmental reimbursements.
Equipment Replacement Fund 138,709$ 58,116$ 80,593$ 47,620$
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 May 31, 2020
Village of Oak Brook
Monthly Financial Report – Fund Narrative
For the Period Ending May 31, 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 May 2020 are $752,727, or 6.7%, lower than last May and $612,761, or
5.6%, under budget to date. The main drivers for this are:
o Sales tax revenue, the General
Fund’s largest revenue source, is
up $271,292 from last year and
$333,188 over budget. May
2020 collections have been at
the highest levels the past four
years. Overall, total collections
through May have also been at
the highest levels in the past five
years.
o Other intergovernmental tax
revenue is down $58,009 from last year and $24,729 under budget. The Village has
experienced a decrease in Income Tax and Replacement Tax receipts in May due to the
COVID-19 pandemic. The State income tax filing date was moved from April to July,
which affected May collections.
o Licenses and permits revenue is down $720,954 from last year and $600,417 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 $100,611 from last year and $102,060 under
budget. This is primarily due to a decrease in ambulance fees from fewer calls for
service in April.
Total expenditures through May 2020 are $348,028, or 3.6%, lower than last year and $749,117,
or 7.4%, under budget to date. The main drivers for this are:
o Personnel expenditures are up $394,733 from last year, but $269,539 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 $310,461 from last year and $289,108
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 $427,706 from last year and $119,228 under
budget. Many capital items have been put on hold for 2020 due to the current
economic state.
Hotel Tax Fund
Total revenues through May 2020 are $106,374, or 24.3%, lower than last year and $111,558, or
25.2%, under budget. The main drivers for this are:
o Hotel tax revenue is down $95,291 from last year and $116,871 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 May 2020 are $231,597, or 110.4%, higher than last year and
$80,809, or 22.4%, over budget. The main drivers for this are:
o Operation and contract expenditures are up $40,986 from last year, but $125,762 under
budget. This is due to the timing of advertising payments and the cancelling of some
campaigns.
o Capital Outlay expenditures are up $190,611 from last year and $206,571 over budget.
The street light replacements began earlier than originally projected.
Infrastructure Fund
Total revenues through May 2020 are up $41,811, or 1.6%, from last year and $129,107, or
5.2%, over budget. The main drivers for this are:
o Non-home rule sales tax revenue
is up $89,014 from last year, but
$130,188 over budget. May
2020 collections have been at
the highest levels the past four
years. Overall, total collections
through May have also been at
the highest levels in the past five
years.
o Interest revenue is down
$47,538 from last year, but $59
over budget. Interest rates have dropped in recent months compared to last year, but
are still at levels projected for 2020.
Total expenditures through May 2020 are down $863,396, or 38.2%, from last year and
$4,436,358, or 76.1%, under budget to date. The main drivers for this are:
o Operation and contract expenditures are up $24,718 from last year, but $168,608 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 $868,610 from last year and $4,247,282 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 May 2020 are up $24,805, or 4,902.2% from last year and $936, or 3.8%,
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 May 2020 are up $35,365, or 15.3%, from last year and $1,040, or
0.4%, 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 May 2020 are down $187,423, or 5.1%, from last year and $362,167, or
9.4%, under budget. The main drivers for this are:
o Water sales revenue is down $94,197 from last year and $320,385 under budget. The
decrease in water sales relates to the business shut down from the COVID-19 pandemic.
Total expenditures through May 2020 are down $13,999, or 0.6%, from last year and
$1,915,964, or 43.6%, under budget. The main drivers for this are:
o Operation and contract expenditures are down $206,846 from last year and $1,202,966
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 $199,864 from last year, but $656,350 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 May 2020 are down $631,106, or 57.1%, from last year and $667,984, or
58.5%, 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.
Total expenditures through May 2020 are down $459,912, or 25.5%, from last year and
$1,510,353, or 52.9%, under budget to date. The main drivers for this are:
o Personnel expenditures are down $140,121 from last year and $163,134 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 $164,218 from last year and $237,794
under budget. Expenditures are down due to facilities being closed for much of the
spring.
o Operation and Contractual expenditures are down $299,403 from last year and
$299,961 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 $160,354 from last year, but $809,464 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.
5/31/20 5/31/20
5/31/19 5/31/20 YTD % of YTD 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 5,420,396$ 5,691,688$ 5,358,500$ 106.2%12,502,000$ 271,292$
Other Intergovernmental Tax*719,180 661,171 685,900 96.4%1,352,000 (58,009)
Telecommunications/Utility Tax 2,712,290 2,576,615 2,686,500 95.9%6,125,000 (135,675)
Licenses and Permits 1,356,452 635,498 1,235,915 51.4%2,990,190 (720,954)
Charges for Services 480,576 379,965 482,025 78.8%1,253,100 (100,611)
Fines and Penalties 107,583 67,959 80,000 84.9%192,000 (39,624)
Administrative Towing Fees 9,386 8,164 8,325 98.1%20,000 (1,222)
Interest on Investments 185,174 174,826 172,925 101.1%415,000 (10,348)
Franchise Fees 53,211 51,448 105,000 49.0%210,000 (1,763)
Miscellaneous Income 108,208 152,395 197,400 77.2%443,095 44,187
Total Operating Revenues 11,152,456$ 10,399,729$ 11,012,490$ 94.4%25,502,385$ (752,727)$
OPERATING EXPENDITURES
Personnel 7,179,203$ 7,573,936$ 7,843,475$ 96.6%19,160,220$ 394,733$
Materials and Supplies 180,752 176,919 248,305 71.3%539,170 (3,833)
Operation and Contract 1,849,343 1,538,882 1,827,990 84.2%4,071,660 (310,461)
Other Expenditures 5,135 4,374 4,230 103.4%10,000 (761)
Capital Outlay 510,613 82,907 202,135 41.0%688,030 (427,706)
Total Operating Expenditures 9,725,046$ 9,377,018$ 10,126,135$ 92.6%24,469,080$ (348,028)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 1,427,410$ 1,022,711$ 886,355$ 1,033,305$ (404,699)$
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 263,420 260,995 261,000 100.0%626,395 (2,425)
Reimbursements To Other Funds (54,625) (58,235) (58,225) 100.0%(139,770) (3,610)
Sports Core Loan (20,200) (150,660) - 0.0%- (130,460)
Total Interfund Transactions 462,162$ (274,269)$ (559,980)$ 49.0%(436,375)$ (736,431)$
NET FUND INCREASE (DECREASE)1,889,572$ 748,442$ 326,375$ 596,930$ (1,141,130)$
*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 May 31, 2020
Total Total
Revenues Expenditures
5/31/20 Actual 10,399,729$ 9,377,018$
5/31/19 Actual 11,152,456$ 9,725,046$
% Change From Last Year -6.7%-3.6%
Major Revenues
Other Telecom/Utility Licenses &Charges for
Sales Tax Intergov. Tax Tax Permits Services
5/31/20 Actual 5,691,688$ 661,171$ 2,576,615$ 635,498$ 379,965$
5/31/19 Actual $ 5,420,396 $ 719,180 $ 2,712,290 $ 1,356,452 $ 480,576
% Change From Last Year 5.0%-8.1%-5.0%-53.1%-20.9%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
5/31/20 Actual 7,573,936$ 176,919$ 1,538,882$ 4,374$ 82,907$
5/31/19 Actual 7,179,203$ 180,752$ 1,849,343$ 5,135$ 510,613$
% Change From Last Year 5.5%-2.1%-16.8%-14.8%-83.8%
Five Year Trend
Expenditures by Department
5/31/19 5/31/20 5/31/20 5/31/20 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Department Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 964,853$ 844,459$ 1,105,480$ 76.4%2,556,835$ (120,394)$
Financial Services 324,010 324,768 1,810,475 17.9%781,455 758
Public Works 350,884 283,922 373,735 76.0%893,055 (66,962)
Engineering & Capital Projects 289,520 21,633 50,750 42.6%411,500 (267,887)
Library 394,825 345,690 424,550 81.4%994,410 (49,135)
Police 3,679,398 3,856,136 3,922,200 98.3%9,493,905 176,738
Fire 3,339,551 3,280,473 3,482,260 94.2%8,298,370 (59,078)
Development Services 382,005 419,937 426,685 98.4%1,039,550 37,932
Total Expenditures 9,725,046$ 9,377,018$ 11,596,135$ 80.9%24,469,080$ (348,028)$
Five Year Trend
For the Period Ending May 31, 2020
General Fund - Five Year Trend
Village of Oak Brook
Revenues Expenditures
5/31/20 5/31/20
5/31/19 5/31/20 YTD % of YTD 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Hotel Tax 390,220$ 294,929$ 411,800$ 71.6%1,212,500$ (95,291)$
Interest 47,646 36,563 31,250 117.0%75,000 (11,083)
Total Operating Revenues 437,866$ 331,492$ 443,050$ 74.8%1,287,500$ (106,374)$
EXPENDITURES
Operation and Contract 183,502$ 224,488$ 350,250$ 64.1%576,615$ 40,986$
Capital Outlay 26,355 216,966 10,395 2087.2%640,395 190,611
Total Expenditures 209,857$ 441,454$ 360,645$ 122.4%1,217,010$ 231,597$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 228,009$ (109,962)$ 82,405$ -133.4%70,490$ (337,971)$
INTERFUND TRANSACTIONS
Transfer Out -$ -$ (54,825)$ 0.0%(338,125)$ -$
Reimbursements to Other Funds (42,965) (31,130) (31,125) 100.0%(74,715) 11,835
Total Interfund Transactions (42,965)$ (31,130)$ (85,950)$ 36.2%(412,840)$ 11,835$
NET FUND INCREASE (DECREASE)185,044$ (141,092)$ (3,545)$ (342,350)$ (326,136)$
Note - Expenditures are recorded in program 171.
Village of Oak Brook
Hotel Tax Fund Financial Update
For the Period Ending May 31, 2020
Total Total
Revenues Expenditures
5/31/20 Actual $ 331,492 441,454$
5/31/19 Actual $ 437,866 209,857$
% Change From Last Year -24.3%110.4%
Major Revenues
Hotel Tax Interest Miscellaneous
5/31/20 Actual $ 294,929 $ 36,563 $ -
5/31/19 Actual $ 390,220 $ 47,646 $ -
% Change From Last Year -24.4%-23.3%0.0%
Five Year Trend
Major Expenditures Operation &
Contractual Capital Outlay
5/31/20 Actual 224,488$ 216,966$
5/31/19 Actual 183,502$ 26,355$
% Change From Last Year 22.3%723.2%
Five Year Trend
Village of Oak Brook
Hotel Tax Fund - Major Sources Five Year Trend
For the Period Ending May 31, 2020
Five Year Trend
Revenues Expenditures
5/31/20 5/31/20
5/31/19 5/31/20 YTD % of YTD 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 2,465,424$ 2,554,438$ 2,424,250$ 105.4%5,615,000$ 89,014$
Charges for Services - 335 425 78.8%1,000 335
Interest 99,672 52,134 52,075 100.1%125,000 (47,538)
Miscellaneous - - 1,050 0.0%2,500 -
Total Operating Revenues 2,565,096$ 2,606,907$ 2,477,800$ 105.2%5,743,500$ 41,811$
OPERATING EXPENDITURES
Personnel 571,524$ 564,268$ 581,810$ 97.0%1,389,540$ (7,256)$
Materials and Supplies 97,602 85,354 88,280 96.7%253,295 (12,248)
Operation and Contract 581,944 606,662 775,270 78.3%1,856,790 24,718
Capital Outlay 1,007,648 139,038 4,386,320 3.2%10,220,090 (868,610)
Total Operating Expenditures 2,258,718$ 1,395,322$ 5,831,680$ 23.9%13,719,715$ (863,396)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 306,378$ 1,211,585$ (3,353,880)$ -36.1%(7,976,215)$ 905,207$
INTERFUND TRANSACTIONS
Transfers In 216,125$ -$ 54,825$ 0.0%1,653,125$ (216,125)$
Reimbursements From Other Funds 138,935 149,740 149,750 100.0%359,380 10,805
Reimbursements To Other Funds (67,305) (67,625) (67,625) 100.0%(162,300) (320)
Total Interfund Transactions 287,755$ 82,115$ 136,950$ 60.0%1,850,205$ (205,640)$
NET FUND INCREASE (DECREASE)594,133$ 1,293,700$ (3,216,930)$ (6,126,010)$ 699,567$
Village of Oak Brook
Infrastructure Fund Financial Update
For the Period Ending May 31, 2020
Total Total
Revenues Expenditures
5/31/20 Actual $ 2,606,907 1,395,322$
5/31/19 Actual $ 2,565,096 2,258,718$
% Change From Last Year 1.6%-38.2%
Major Revenues
Sales Tax
Charges for
Services Interest Miscellaneous Reimbursements
5/31/20 Actual $ 2,554,438 $ 335 $ 52,134 $ - $ 149,740
5/31/19 Actual $ 2,465,424 $ - $ 99,672 $ - $ 138,935
% Change From Last Year 3.6%N/A -47.7%0.0%7.8%
Five Year Trend
Major Expenditures Materials &Operation &
Personnel Supplies Contractual Capital Outlay
5/31/20 Actual 564,268$ 85,354$ 606,662$ 139,038$
5/31/19 Actual 571,524$ 97,602$ 581,944$ 1,007,648$
% Change From Last Year -1.3%-12.5%4.2%-86.2%
Five Year Trend
Expenditures by Department
5/31/19 5/31/20 5/31/20 5/31/20 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 48,055$ 62,967$ 74,705$ 84.3%176,490$ 14,912$
Public Works 1,161,646 928,788 2,906,695 32.0%4,390,810 (232,858)
Engineering & Capital Projects 1,049,017 403,567 2,850,280 14.2%9,152,415 (645,450)
Total Expenditures 2,258,718$ 1,395,322$ 5,831,680$ 23.9%13,719,715$ (863,396)$
Five Year Trend
Village of Oak Brook
Infrastructure Fund - Major Sources Five Year Trend
For the Period Ending May 31, 2020
Revenues Expenditures
5/31/20 5/31/20
5/31/19 5/31/20 YTD % of YTD 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax -$ 24,925$ 23,750$ 104.9%95,000$ 24,925$
Real Estate Tax - - - 0.0%380,000 -
Interest 506 386 625 61.8%1,500 (120)
Total Operating Revenues 506$ 25,311$ 24,375$ 103.8%476,500$ 24,805$
EXPENDITURES
Operation and Contract -$ 1,040$ -$ 0.0%3,890$ 1,040$
Other Expenditures 231,130 265,455 265,455 100.0%504,900 34,325
Total Expenditures 231,130$ 266,495$ 265,455$ 100.4%508,790$ 35,365$
NET FUND INCREASE (DECREASE)(230,624)$ (241,184)$ (241,080)$ (32,290)$ (10,560)$
Note - Expenditures are recorded in program 283.
Village of Oak Brook
Promenade TIF Fund Financial Update
For the Period Ending May 31, 2020
Total Total
Revenues Expenditures
5/31/20 Actual $ 25,311 266,495$
5/31/19 Actual $ 506 231,130$
% Change From Last Year 4902.2%15.3%
Major Revenues Real Estate
Sales Tax Tax Interest
5/31/20 Actual 24,925$ $ - $ 386
5/31/19 Actual -$ $ - $ 506
% Change From Last Year N/A 0.0%-23.7%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures
5/31/20 Actual 1,040$ 265,455$
5/31/19 Actual -$ 231,130$
% Change From Last Year N/A 14.9%
Five Year Trend
Village of Oak Brook
Promenade TIF Fund - Major Sources Five Year Trend
For the Period Ending May 31, 2020
Five Year Trend
Revenues Expenditures
5/31/20 5/31/20
5/31/19 5/31/20 YTD % of YTD 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Plan Review Fees 675$ 150$ 500$ 30.0%1,200$ (525)$
Building/Inspection Fees 1,913 4,912 3,325 147.7%8,000 2,999
Water Sales 3,453,812 3,359,615 3,680,000 91.3%10,302,525 (94,197)
Unmetered Sales 7,647 27,318 12,500 218.5%30,000 19,671
Water Connection Fees 86,250 5,080 41,675 12.2%100,000 (81,170)
Meter Charges 7,127 4,377 8,345 52.5%20,000 (2,750)
Special Services 16,203 12,275 15,000 N/A 30,000 (3,928)
Interest on Investments 73,849 50,187 54,175 92.6%130,000 (23,662)
Miscellaneous 24,550 20,689 31,250 66.2%75,000 (3,861)
Total Operating Revenues 3,672,026$ 3,484,603$ 3,846,770$ 90.6%10,696,725$ (187,423)$
OPERATING EXPENDITURES
Personnel 318,710$ 322,552$ 354,610$ 91.0%868,705$ 3,842$
Materials and Supplies 16,734 5,875 30,465 19.3%74,260 (10,859)
Operation and Contract 1,443,225 1,236,379 2,439,345 50.7%5,833,755 (206,846)
Capital Outlay 712,121 911,985 1,568,335 58.1%6,293,225 199,864
Total Expenditures 2,490,790$ 2,476,791$ 4,392,755$ 56.4%13,069,945$ (13,999)$
Surplus (Deficit) of Revenues Over
Expenditures 1,181,236$ 1,007,812$ (545,985)$ -184.6%(2,373,220)$ (173,424)$
INTERFUND TRANSACTIONS
Transfers In 221,085$ -$ -$ 0.0%-$ (221,085)
Reimbursements To Other Funds (229,930) (219,505) (219,500) 100.0%(526,815) 10,425
Total Interfund Transactions (8,845)$ (219,505)$ (219,500)$ 100.0%(526,815)$ (210,660)$
Fund Increase/(Decrease) - Budgetary Basis 1,172,391$ 788,307$ (765,485)$ -103.0%(2,900,035)$ (384,084)$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay 712,121$ 911,985$
Depreciation Expense (213,377) (239,583)
IMRF Pension Expense 32,182 20,833
OPEB Expense (20,427) (18,750)
Total GAAP Adjustments 510,499$ 674,485$
Fund Increase/(Decrease) - GAAP Basis 1,682,890$ 1,462,792$
*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 May 31, 2020
Total Total
Revenues Expenditures
5/31/20 Actual $ 3,484,603 2,476,791$
5/31/19 Actual $ 3,672,026 2,490,790$
% Change From Last Year -5.1%-0.6%
Unmetered Water
Water Sales Sales Connection Fees Meter Charges Miscellaneous
5/31/20 Actual $ 3,359,615 $ 27,318 $ 5,080 $ 4,377 $ 20,689
5/31/19 Actual $ 3,453,812 $ 7,647 $ 86,250 $ 7,127 $ 24,550
% Change From Last Year -2.7%257.2%-94.1%-38.6%-15.7%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
5/31/20 Actual 322,552$ 5,875$ 1,236,379$ -$ 911,985$
5/31/19 Actual 318,710$ 16,734$ 1,443,225$ -$ 712,121$
% Change From Last Year 1.2%-64.9%-14.3%0.0%28.1%
Five Year Trend
Expenditures by Department
5/31/19 5/31/20 5/31/20 5/31/20 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Public Works 1,765,970$ 1,568,143$ 2,720,430$ 57.6%6,527,120$ (197,827)$
Engineering & Capital Projects 724,820 908,648 1,672,325 54.3%6,542,825 183,828
Total Expenditures 2,490,790$ 2,476,791$ 4,392,755$ 56.4%13,069,945$ (13,999)$
Five Year Trend
Village of Oak Brook
Water Fund - Major Sources Five Year Trend
For the Period Ending May 31, 2020
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Sports Core Fund Consolidated Presentation
For the Period Ending May 31, 2020
5/31/20 5/31/20
5/31/20 YTD % of YTD 2020 5/31/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$ -$ -$ 199,300$ 199,499$ 403,305$ 49.5%459,135$ 363,705$ (164,206)$
Greens Fees - - - 68,921 68,921 210,000 32.8%930,000 174,099 (105,178)
Pro Shop Sales - - - 25,366 25,366 72,500 35.0%207,000 71,327 (45,961)
Golf Lessons - - - 270 270 18,500 1.5%40,000 21,725 (21,455)
Driving Range Fees - - - 50,572 50,572 123,000 41.1%244,000 118,106 (67,534)
Rentals - 87,540 12,648 14,910 115,098 191,500 60.1%962,000 234,768 (119,670)
Programs/User Fees - - - - - 20,250 0.0%66,300 22,385 (22,385)
Food Sales - - - 3,552 3,552 31,815 11.2%180,500 31,229 (27,677)
Beverage Sales - - - 9,291 9,291 46,590 19.9%265,000 49,277 (39,986)
Taste of Oak Brook - - - - - 20,000 0.0%120,000 13,500 (13,500)
Grants - - - - - - 0.0%139,800 - -
Other Revenue (127) - - 1,684 1,557 4,650 33.5%11,000 5,111 (3,554)
Total Operating Revenues 72$ 87,540$ 12,648$ 373,866$ 474,126$ 1,142,110$ 41.5%3,624,735$ 1,105,232$ (631,106)$
OPERATING EXPENDITURES
Personnel 2,165$ -$ 45,057$ 317,664$ 364,886$ 528,020$ 69.1%1,578,100$ 505,007$ (140,121)$
Materials & Supplies 853 119 1,436 26,933 29,341 267,135 11.0%618,025 193,559 (164,218)
Operational & Contractual 31,151 34,847 27,659 98,242 191,899 491,860 39.0%1,055,095 491,302 (299,403)
Other - - - - - - 0.0%(83,150) 16,524 (16,524)
Capital 337,885 8,710 704 412,737 760,036 1,569,500 48.4%1,921,545 599,682 160,354
Total Operating Expenditures 372,054$ 43,676$ 74,856$ 855,576$ 1,346,162$ 2,856,515$ 47.1%5,089,615$ 1,806,074$ (459,912)$
B&T Administration Overhead Allocation*24,602$ -$ (24,602)$ -$ -$ -$ 0.0%-$ -$ -$
Operating Revenues Over (Under) Expenditures (347,380)$ 43,864$ (86,810)$ (481,710)$ (872,036)$ (1,714,405)$ 50.9%(1,464,880)$ (700,842)$ (171,194)$
INTERFUND TRANSACTIONS
Interfund Loan**150,660$ -$ -$ -$ 150,660$ -$ N/A -$ 20,200$ 130,460$
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 10,000 - - - 10,000 10,000 100.0%24,000 10,000 -
Reimbursement From Water Fund 3,335 - - - 3,335 3,325 100.3%8,000 3,335 -
Reimbursement To General Fund (11,760) - - (11,760) (23,520) (23,500) 100.1%(56,450) - (23,520)
Total Interfund Transactions 478,604$ -$ -$ 311,613$ 790,217$ 1,152,580$ 68.6%1,333,550$ 474,544$ 315,673$
Total Revenues Over (Under) Expenditures - Budgetary Basis 131,224$ 43,864$ (86,810)$ (170,097)$ (81,819)$ (561,825)$ (131,330)$ (226,298)$ 144,479$
ADUSTMENTS TO GAAP BASIS***
Remove Capital Outlay 337,885$ 8,710$ 704$ 412,737$ 760,036$ 599,682$
Depreciation Expense (62,460) (702) (14,583) (88,333) (166,078) (136,829)
IMRF Pension Expense (2,188) (104) (833) (4,938) (8,063) 38,655
OPEB Expense - - (2,167) (16,667) (18,833) (8,348)
Total GAAP Adjustments 273,238$ 7,904$ (16,879)$ 302,800$ 567,062$ 493,160$
Fund Increase/(Decrease) - GAAP Basis 404,462$ 51,768$ (103,689)$ 132,703$ 485,243$ 266,862$
*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.
***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
5/31/20 Actual $ 474,126 1,346,162$
5/31/19 Actual $ 1,105,232 1,806,074$
% Change From Last Year -57.1%-25.5%
Driving Program/
Memberships Greens Fees Range Fees Rentals User Fees
5/31/20 Actual $ 199,499 $ 68,921 $ 50,572 $ 115,098 $ -
5/31/19 Actual $ 363,705 $ 174,099 $ 118,106 $ 234,768 $ 22,385
% Change From Last Year -45.1%-60.4%-57.2%-51.0%-100.0%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
5/31/20 Actual 364,886$ 29,341$ 191,899$ -$ 760,036$
5/31/19 Actual 505,007$ 193,559$ 491,302$ 16,524$ 599,682$
% Change From Last Year -27.7%-84.8%-60.9%-100.0%26.7%
Five Year Trend
Revenues by Department 5/31/19 5/31/20 5/31/20 5/31/20 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Operations 195,332$ 72$ 216,905$ 0.0%506,735$ (193,813)$
Open Field Operations 62,815 87,540 83,775 104.5%407,000 38,225
B&T Clubhouse Operations 48,947 12,648 47,500 26.6%300,000 (36,299)
Golf Club 798,138 373,866 793,930 47.1%2,411,000 (424,272)
Total Revenues 1,105,232$ 474,126$ 1,142,110$ 41.5%3,624,735$ (616,159)$
Expenditures by Department 5/31/19 5/31/20 5/31/20 % of YTD 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Operations 399,675$ 372,054$ 1,208,705$ 30.8%1,752,045$ (27,621)$
Open Field Operations 39,943$ 43,676$ 25,125$ 173.8%267,110$ 3,733$
B&T Clubhouse Operations 424,714 74,856 298,885 25.0%458,770 (349,858)
Golf Club 941,742 855,576 1,323,800 64.6%2,611,690 (86,166)
Total Expenditures 1,806,074$ 1,346,162$ 2,856,515$ 47.1%5,089,615$ (459,912)$
Five Year Trend
Village of Oak Brook
Sports Core Fund - Major Sources Five Year Trend
For the Period Ending May 31, 2020
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Club Recreation Operations
For the Period Ending May 31, 2020 5/31/20 5/31/20
822 5/31/20 YTD % of YTD 2020 5/31/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$ 193,005$ 0.1%241,635$ 172,205$ (172,006)$
Programs/User Fees - - - - - 20,250 0.0%66,300 22,385 (22,385)
Food Sales - - - - - 3,000 0.0%36,000 929 -
Beverage Sales - - - - - 500 0.0%20,000 518 -
Grants - - - - - - 0.0%139,800 - -
Other Revenue (127) - - - (127) 150 -84.7%3,000 (705) 578
Total Operating Revenues (127)$ 199$ -$ -$ 72$ 216,905$ 0.0%506,735$ 195,332$ (193,813)$
OPERATING EXPENDITURES
Personnel 2,165$ -$ -$ -$ 2,165$ 53,055$ 4.1%163,580$ 43,955$ (41,790)$
Materials & Supplies 206 562 85 - 853 35,100 2.4%57,650 26,447 (25,594)
Operational & Contractual 24,215 3,140 3,712 84 31,151 308,050 10.1%418,270 292,383 (261,232)
Capital 10,731 326,369 785 - 337,885 812,500 41.6%1,112,545 36,890 300,995
Total Operating Expenditures 37,317$ 330,071$ 4,582$ 84$ 372,054$ 1,208,705$ 30.8%1,752,045$ 399,675$ (27,621)$
B&T Administration Overhead Allocation*49,204$ (17,714)$ (4,920)$ (1,968)$ 24,602$ 51,995$ 47.3%93,235$ 52,082$ (27,480)$
Operating Revenues Over (Under) Expenditures 11,760$ (347,586)$ (9,502)$ (2,052)$ (347,380)$ (939,805)$ 37.0%(1,152,075)$ (152,261)$ (193,672)$
INTERFUND TRANSACTIONS
Interfund Loan**150,660$ -$ -$ -$ 150,660$ -$ N/A -$ 20,200$ 130,460$
Transfer From General Fund - 326,369 - - 326,369 597,255 54.6%757,500 32,171 294,198
Reimbursement From Infrastructure Fund 10,000 - - - 10,000 10,000 100.0%24,000 10,000 -
Reimbursement From Water Fund 3,335 - - - 3,335 3,325 100.3%8,000 3,335 -
Reimbursement To General Fund (11,760) - - - (11,760) (11,750) 100.1%(28,225) - (11,760)
Total Interfund Transactions 152,235$ 326,369$ -$ -$ 478,604$ 598,830$ 79.9%761,275$ 65,706$ 412,898$
Total Revenues Over (Under) Expenditures - Budgetary Basis 163,995$ (21,217)$ (9,502)$ (2,052)$ 131,224$ (340,975)$ (390,800)$ (86,555)$ 219,226$
ADUSTMENTS TO GAAP BASIS***
Remove Capital Outlay 10,731$ 326,369$ 785$ -$ 337,885$ 36,890$
Depreciation Expense - (59,890) (2,083) (487) (62,460) (39,510)
IMRF Pension Expense (2,083) - - (104) (2,188) 2,541
Total GAAP Adjustments 8,648$ 266,479$ (1,298)$ (591)$ 273,238$ (79)$
Fund Increase/(Decrease) - GAAP Basis 172,643$ 245,262$ (10,800)$ (2,643)$ 404,462$ (86,634)$
*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.
***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 May 31, 2020 5/31/20 5/31/20
5/31/20 YTD % of YTD 2020 5/31/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$ 63,775$ 19.7%212,000$ 49,315$ (36,775)$
Range Rentals - 75,000 75,000 - N/A 75,000 - 75,000
Taste of Oak Brook - - - 20,000 0.0%120,000 13,500 -
Other Revenue - - - - 0.0%- - -
Total Operating Revenues -$ 87,540$ 87,540$ 83,775$ 104.5%407,000$ 62,815$ 38,225$
OPERATING EXPENDITURES
Personnel -$ -$ -$ -$ 0.0%10,810$ -$ -$
Materials & Supplies - 119 119 500 23.8%1,700 - 119
Operational & Contractual 20,000 14,847 34,847 24,625 141.5%239,600 36,859 (2,012)
Other - - - - 0.0%- - -
Capital - 8,710 8,710 - N/A 15,000 3,084 5,626
Total Operating Expenditures 20,000$ 23,676$ 43,676$ 25,125$ 173.8%267,110$ 39,943$ 3,733$
Operating Revenues Over (Under) Expenditures (20,000)$ 63,864$ 43,864$ 58,650$ 74.8%139,890$ 22,872$ 34,492$
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,864$ 43,864$ 58,650$ 174,890$ 22,872$ 34,492$
ADUSTMENTS TO GAAP BASIS***
Remove Capital Outlay -$ 8,710$ 8,710$ 3,084$
Depreciation Expense - (702) (702) (702)
IMRF Pension Expense - (104) (104) 306
Total GAAP Adjustments -$ 7,904$ 7,904$ 2,688$
Fund Increase/(Decrease) - GAAP Basis (20,000)$ 71,768$ 51,768$ 25,560$
*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.
***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 May 31, 2020
5/31/20 5/31/20
821 YTD % of YTD 2020 5/31/19 Difference
B&T Amended Amended Adopted YTD Prior
Clubhouse Budget Budget Budget Total Year
OPERATING REVENUES
Rentals 12,648$ 47,500$ 26.6%300,000$ 48,947$ (36,299)$
Total Operating Revenues 12,648$ 47,500$ 26.6%300,000$ 48,947$ (36,299)$
OPERATING EXPENDITURES
Personnel 45,057$ 52,575$ 85.7%140,045$ 49,165$ (4,108)$
Materials & Supplies 1,436 9,600 15.0%20,225 2,845 (1,409)
Operational & Contractual 27,659 47,710 58.0%109,500 41,001 (13,342)
Capital 704 189,000 0.4%189,000 331,703 (330,999)
Total Operating Expenditures 74,856$ 298,885$ 25.0%458,770$ 424,714$ (349,858)$
B&T Administration Overhead Allocation*(24,602)$ (51,995)$ 47.3%(93,235)$ (52,082)$ 27,480$
Operating Revenues Over (Under) Expenditures (86,810)$ (303,380)$ 28.6%(252,005)$ (427,849)$ 341,039$
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 (86,810)$ (137,880)$ (86,505)$ (225,352)$ 138,542$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 704$ 331,703$
Depreciation Expense (14,583) (13,396)
IMRF Pension Expense (833) 2,791
OPEB Expense (2,167) (875)
Total GAAP Adjustments (16,879)$ 320,223$
Fund Increase/(Decrease) - GAAP Basis (103,689)$ 94,871$
*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 May 31, 2020
5/31/20 5/31/20
823 831 832 833 834 5/31/20 YTD % of YTD 2020 5/31/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 -$ 199,300$ -$ -$ -$ 199,300$ 210,300$ 94.8%217,500$ 191,500$ 7,800$
Greens Fees - 68,921 - - - 68,921 210,000 32.8%930,000 174,099 (105,178)
Pro Shop Sales - 25,366 - - - 25,366 72,500 35.0%207,000 71,327 (45,961)
Golf Lessons - - 270 - - 270 18,500 1.5%40,000 21,725 (21,455)
Driving Range Fees - - 50,572 - - 50,572 123,000 41.1%244,000 118,106 (67,534)
Rentals - 20 - 14,890 - 14,910 80,225 18.6%375,000 136,506 (121,596)
Food Sales 3,552 - - - - 3,552 28,815 12.3%144,500 30,300 (26,748)
Beverage Sales 9,291 - - - - 9,291 46,090 20.2%245,000 48,759 (39,468)
Other Revenue - 1,684 - - - 1,684 4,500 37.4%8,000 5,816 (4,132)
Total Operating Revenues 12,843$ 295,291$ 50,842$ 14,890$ -$ 373,866$ 793,930$ 47.1%2,411,000$ 798,138$ (424,272)$
OPERATING EXPENDITURES
Personnel 20,085$ 165,636$ 861$ 5,042$ 126,040$ 317,664$ 422,390$ 75.2%1,263,665$ 411,887$ (94,223)$
Materials & Supplies 2,935 4,173 1,031 478 18,316 26,933 221,935 12.1%538,450 164,267 (137,334)
Operational & Contractual 2,820 58,577 50 16,888 19,907 98,242 111,475 88.1%287,725 121,059 (22,817)
Other - - - - - - - 0.0%(83,150) 16,524 (16,524)
Capital - 330,030 - - 82,707 412,737 568,000 72.7%605,000 228,005 184,732
Total Operating Expenditures 25,840$ 558,416$ 1,942$ 22,408$ 246,970$ 855,576$ 1,323,800$ 64.6%2,611,690$ 941,742$ (86,166)$
Operating Revenues Over (Under) Expenditures (12,997)$ (263,125)$ 48,900$ (7,518)$ (246,970)$ (481,710)$ (529,870)$ 90.9%(200,690)$ (143,604)$ (338,106)$
INTERFUND TRANSACTIONS
Transfer from Golf Surcharge -$ 323,373$ -$ -$ 323,373$ 400,000$ 80.8%400,000$ 206,341$ 117,032$
Reimbursement to General Fund - (11,760) - - (11,760) (11,750) 100.1%(28,225) - (11,760)
Total Interfund Transactions -$ 311,613$ -$ -$ -$ 311,613$ 388,250$ 80.3%371,775$ 206,341$ 105,272$
Total Revenues Over (Under) Expenditures - Budgetary Basis (12,997)$ 48,488$ 48,900$ (7,518)$ (246,970)$ (170,097)$ (141,620)$ 171,085$ 62,737$ (232,834)$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay -$ 330,030$ -$ -$ 82,707$ 412,737$ 228,005$
Depreciation Expense - (56,250) (1,667) (9,583) (20,833) (88,333) (83,220)
IMRF Pension Expense (625) (2,083) (146) - (2,083) (4,938) 33,016
OPEB Expense (1,250) (9,583) - - (5,833) (16,667) (7,473)
Total GAAP Adjustments (1,875)$ 262,113$ (1,813)$ (9,583)$ 53,957$ 302,800$ 170,328$
Fund Increase/(Decrease) - GAAP Basis (14,872)$ 310,601$ 47,088$ (17,101)$ (193,013)$ 132,703$ 233,065$
*Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.