06 - June 2021 Monthly Financial ReportVILLAGE
OAK BROOK
OF
MONTHLY FINANCIAL REPORTS
JUNE 2021
ITEM 6.D
Cash and Investments by Fund:Total
Cash and Cash Pooled Cash and
Fund Equivalents Investments Investments % By Fund
General Corporate $13,241,707 $13,463,918 $26,705,625 57.3%
Hotel/Motel Tax 666,659 2,642,092 3,308,751 7.1%
Motor Fuel Tax 964,157 27,767 991,924 2.1%
Infrastructure 4,324,204 2,583,269 6,907,473 14.8%
Promenade TIF 276,130 - 276,130 0.6%
Water 2,225,232 3,821,220 6,046,452 13.0%
Sports Core 672,951 - 672,951 1.4%
Golf Surcharge 192,262 - 192,262 0.4%
Self-Insurance 433,752 - 433,752 0.9%
Garage 307,046 - 307,046 0.7%
Equipment Replacement 328,488 443,886 772,374 1.7%
Total $23,632,588 $22,982,152 $46,614,740 100.0%
Change in Cash and Investments by Fund :
Balance at Balance at Year-to-Date Year-to-Date
Fund January 1, 2021 June 30, 2021 Change ($)Change (%)
General Corporate $23,894,312 $26,705,625 $2,811,313 11.8%
Hotel/Motel Tax 4,567,176 3,308,751 (1,258,425)-27.6%
Motor Fuel Tax 673,455 991,924 318,469 47.3%
Infrastructure 7,480,975 6,907,473 (573,502)-7.7%
Promenade TIF 267,300 276,130 8,830 3.3%
Water 6,900,169 6,046,452 (853,717)-12.4%
Sports Core 114,133 672,951 558,818 489.6%
Golf Surcharge 132,593 192,262 59,669 45.0%
Self-Insurance - 433,752 433,752 N/A
Garage 298,348 307,046 8,698 2.9%
Equipment Replacement 696,392 772,374 75,982 10.9%
$45,024,853 $46,614,740 $1,589,887 3.5%
Book Bank/Market
Value Value
Cash and Cash Equivalents:
Pooled Checking $775,016 $1,242,130
Sports Core Checking 876,446 853,959
Pooled IPTIP 21,921,083 21,921,083
Water E-Pay IPTIP 60,043 46,728
$23,632,588 $24,063,900
Pooled Investments:
Investments-Municipal Bonds $10,119,494 $10,157,914
Investments-Corporate Bonds 8,378,150 8,394,277
Government & Agency Obligations 1,574,943 1,588,051
Certificates of Deposit 2,695,000 2,710,961
Accrued Interest 214,565 214,565
Total Pooled Investments $22,982,152 $23,065,768
Total Cash and Investments $46,614,740 $47,129,668
For June, total interest revenue is $24,833 and YTD is $164,864. The total investment yield for the portfolio is:
Pooled
Investments Illinois Funds Total
Last 12 months yield 1.60%0.10%0.91%
The weighted average yield of the current investment portfolio is 1.31%. The IL Funds June average daily rate was 0.023%.
Monthly Treasurer's Report
June 30, 2021
Monthly Treasurer's Report
June 2021
The table below lists the detail investment holdings at J.P. Morgan Securities as of 6/30/21:
Month End VOB
Settlement Maturity Coupon Yield Book Market Accrued
Type Date Date Rate Rate Value Value Interest
Municipal Bonds:
Bloomingdale Mich Pub Sch Dist #094383FS0 04/26/16 05/01/22 2.710%2.150%$502,242 $509,480 $2,219
Connecticut St GO Bds 2016 #20772J3F7 06/15/17 08/15/21 1.750%2.300%499,694 500,925 3,252
State of IL #452152P54 10/09/19 11/01/21 5.000%1.870%505,219 507,940 3,916
Brownsville TX #16405ST9 12/19/19 02/15/22 2.050%2.000%555,162 560,916 4,140
Laredo TX Waterworks #517039VW0 12/19/19 03/01/24 2.230%2.230%455,000 473,300 3,326
Oakland Univ Mich #673588HJ1 04/29/20 03/01/24 5.000%1.650%320,632 330,713 4,917
Philadelphia PA GO Ref #717813SW0 05/05/20 08/01/22 5.000%1.820%403,303 410,315 7,922
Maryland St DOT #574204WG4 05/06/20 06/15/22 4.350%1.200%267,814 270,046 386
University of CA #91412HFK4 07/16/20 05/15/23 0.628%0.628%25,000 25,102 20
Waterford Mich Sch Dist #941468YZ7 08/20/20 08/24/21 4.000%0.301%502,715 502,645 17,258
Universty of IL #914353YH4 08/31/20 10/01/21 3.000%0.701%251,426 251,730 1,875
New Jersey St #646039UD7 09/20/20 06/01/22 5.000%0.600%494,108 495,767 1,913
Alaska St GO #011770Z72 10/14/2020 8/1/2021 5.000%0.252%175,712 175,686 3,622
Rio Rancho NM #767175HM7 10/14/2020 5/15/2022 5.000%0.350%192,504 192,777 1,156
Cook, Kane, Lake, & McHenry #216181GL5 10/29/2020 12/15/2022 4.000%0.300%1,080,023 1,082,749 27,554
Miami-Dade Cnty #59333NN90 11/16/2020 12/15/2022 0.375%0.430%734,293 735,110 674
Hamilton NY #407741MC8 1/21/2021 5/1/2023 1.000%0.550%206,685 206,193 330
Southern Cal Pub Pwr #84247PHZ7 1/25/2021 4/1/2024 3.608%0.500%1,092,579 1,084,940 17,840
Hillsborough Cnty FL #43232VV3 3/11/2021 7/1/2024 1.815%0.770%515,500 512,490 4,462
Port Auth of NY and NJ #73358WAH7 4/15/2021 12/1/2024 5.859%0.600%588,924 581,910 2,279
City of Atlanta GA Water #047870SG6 4/19/2021 11/1/2024 0.616%0.500%250,959 248,565 240
West Contra Costa Cal Uni #9523474U3 6/17/2021 8/1/2024 0.575%0.575%500,000 498,615 104
Total Municipal Bonds $10,119,494 $10,157,914 $109,405
Corporate Bonds:
Morgan Stanley #61747WAL3 03/08/19 07/28/21 5.500%3.034%$1,051,303 $1,054,025 $24,383
Citigroup #172967LC3 04/01/19 12/08/21 2.900%2.754%1,000,718 1,009,483 1,289
American Honda #02665WBG5 07/31/19 09/09/21 1.700%2.180%499,575 501,365 2,667
JP Morgan #48128BAB7 09/30/19 01/15/23 2.972%2.337%1,009,485 1,014,154 13,704
American Express #025816CD9 05/05/20 05/20/22 2.750%1.290%506,461 509,866 1,423
Goldman Sachs #38141GGQ1 08/31/20 07/27/21 5.250%0.251%346,238 346,200 7,748
PNC Bank #69349LAK4 12/7/2020 1/30/2023 2.950%0.457%1,059,980 1,058,731 12,538
Wells Fargo #94974BFJ4 12/7/2020 2/13/2023 3.450%0.480%1,456,283 1,457,134 18,250
Comerica Bank #200340AS6 12/23/2020 7/31/2023 3.700%0.500%533,107 531,436 7,708
Bank of America #06048WM23 5/14/2021 5/14/2024 0.650%0.650%915,000 911,883 743
Total Corporate Bonds $8,378,150 $8,394,277 $90,453
Government & Agency Obligations:
*Government National Mtg Assn #38379UEM4 02/29/16 02/16/51 2.300%2.245%$284,436 $274,662 $669
*Government National Mtg Assn #38381WV96 08/06/19 07/20/54 2.250%2.293%361,318 371,004 552
*Government National Mtg Assn #38380BNV3 12/05/19 06/20/46 2.000%2.112%429,189 442,384 607
Federal Home Loan Bank #3130AMVU3 06/29/21 06/29/26 0.500%0.500%500,000 500,001 0
Total Government & Agency Obligations:$1,574,943 $1,588,051 $1,828
Certificates of Deposit:
State Bk India NY #8562846A7 01/26/17 01/26/22 2.250%2.250%$245,000 $248,081 $2,359
First St Bank DeQueen #336460CU2 07/18/19 07/19/21 2.000%2.000%245,000 245,252 185
Bank Hapoalim #06251AW89 07/19/19 07/19/21 2.000%2.000%245,000 245,265 2,351
Capital One Natl Assn #14042RMF5 07/24/19 07/26/19 2.050%2.050%245,000 245,354 2,268
TIAA FSB Jacksonville #87270LCN1 07/29/19 07/29/21 2.000%2.000%245,000 245,385 2,049
Wells Fargo #949763J31 09/18/19 09/20/21 1.850%1.850%245,000 245,980 186
BMW Bank #05580ASQ8 10/11/19 10/12/21 1.800%1.800%245,000 246,238 913
Wells Fargo #949495AN5 01/17/20 01/18/22 1.800%1.800%245,000 247,356 185
Bank Leumi #063248KQ0 03/31/20 03/31/22 1.250%1.250%245,000 247,224 766
Capital One Natl Assn #14042TCZ8 04/01/20 04/01/22 1.350%1.350%245,000 247,401 818
Synchrony Bank #87164WZN1 04/03/20 04/04/22 1.350%1.350%245,000 247,425 799
Total Certificates of Deposits $2,695,000 $2,710,961 $12,879
Total J.P.Morgan Securities $22,767,587 $22,851,203 $214,565
*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, 2021
Cash & Investments by Fund - Total $46.6 million
Cash & Investments by Type - Total $46.6 million
Checking
Illinois Funds
Certificates of Deposit
Municipal Bonds
Corporate Bonds
Government & Agency Obligations
Accrued Interest
General Corporate
57.3%
Hotel/Motel Tax
7.1%Motor Fuel Tax
2.1%
Infrastructure
14.8%
Promenade TIF
0.6%
Water
13.0%
Sports Core
1.4%
Golf Surcharge
0.4%
Self-Insurance
0.9%
Garage
0.7%
Equipment
Replacement
1.7%
Checking, $1.7
Illinois Funds, $21.9
Certificates of Deposit,
$2.7
Municipal Bonds,
$10.1
Corporate Bonds, $8.4
Government & Agency
Obligations, $1.6
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)12,822,085$ 10,177,924$ 2,644,161$ 1,309,080$
Main operating fund of the Village.
Hotel Fund (Major Fund)263,794$ 1,562,734$ (1,298,940)$ (968,580)$
Collects and spends resources from the
3% hotel/motel tax.
Motor Fuel Tax Fund 318,164$ -$ 318,164$ 231,085$
Collects and spends resources from the
State motor fuel tax.
Infrastructure Fund (Major Fund)4,447,090$ 4,336,147$ 110,943$ (1,509,080)$
Accounts for construction and maintenance of
roadways, drainage, and safety path systems.
Promenade TIF Fund (Major Fund)239,842$ 484,263$ (244,421)$ 7,960$
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)4,632,213$ 4,851,950$ (219,737)$ (4,467,135)$
Collects user fees for the distribution of water
and maintenance of infrastructure.
Sports Core Fund (Major Fund)1,936,279$ 1,289,276$ 647,003$ (398,620)$
Accounts for revenues and expenses relating
to administration, programs, food and beverage
operations, and golf course.
Golf Surcharge Fund 59,669$ -$ 59,669$ (155,010)$
Accounts for the collection of the $3 per round
golf surcharge.
Internal Service Funds
Self Insurance Fund 1,997,319$ 1,348,249$ 649,070$ 9,520$
Accounts for the Village's health insurance costs
and the related contributions from the Village,
employees, retirees, and other agencies.
Garage Fund 305,530$ 299,651$ 5,879$ (57,540)$
Accounts for the maintenance of the Village's vehicle
fleet and the related departmental reimbursements.
Equipment Replacement Fund 201,954$ 122,489$ 79,465$ (53,790)$
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, 2021
Village of Oak Brook
Monthly Financial Report – Fund Narrative
For the Period Ending June 30, 2021
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
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 (annual audit).
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 2021 are $401,272, or 3.3%, higher than last June and $313,727, or
2.6%, over budget to date. The main drivers for this are:
o Sales Tax revenue, the General
Fund’s largest revenue source, is
up $58,014 from last year and
$519,111 over budget. June
2021 collections were the
highest June in the past five
years despite COVID-19
restrictions that were in place.
o Other Intergovernmental Tax
revenue is up $287,789 from last
year and $316,006 over budget.
Receipts from Income Tax, Replacement Tax, and Use Tax have been stronger than
projected to date.
o Telecommunications/Utility Tax revenue is down $247,475 from last year and $335,495
under budget. The decrease relates to amended telecommunications tax returns that
were processed in 2021. We have also seen a decrease in tax revenue as a result of
remote working over the last year.
o Licenses and Permits revenue is up $294,425 from last year and $13,143 over budget.
The increase relates to a combination of the timing of receipt collections and a
reduction of certain liquor licenses in 2020 related to COVID-19 business closures.
o Charges for Services revenue is up $71,279 from last year, but $103,631 under budget.
This is due to a decrease in billable auxiliary police services and a decrease in billable
ambulance revenue to date. Amounts can vary from year to year due to the timing of
billing requests.
o Investment Interest revenue is down $105,983 from last year and $51,275 under
budget. Investment return rates have dropped significantly since the beginning of the
COVID-19 pandemic.
Total expenditures through June 2021 are $1,030,447, or 9.2%, lower than last year and
$921,360, or 8.3%, under budget to date. The main drivers for this are:
o Personnel expenditures are down $874,505 from last year and $615,121 under budget.
The decrease is due to two payroll cycles in January 2021 vs. three payroll cycles in
January 2020. In addition, personnel expenditures are under budget due to delays in
full public safety pension funding.
Hotel Tax Fund
Total revenues through June 2021 are $95,849, or 26.7%, lower than last year, but $45,884, or
21.1%, over budget to date. The main drivers for this are:
o Hotel tax revenue is down $68,766 from last year, but $46,707 over budget. The
decrease in revenue is due to the effects of COVID-19 on the travel industry.
Total expenditures through June 2021 are $387,579, or 87.0%, lower than last year and $86,686,
or 60.0%, under budget. Major expenditures from the Hotel Tax Fund have not occurred yet in
2021 as many initiatives have been put on hold due to the lack of revenue.
Through June 2021, the Hotel Tax Fund has transferred $1,462,918 to the Infrastructure Fund
related to the Windsor Drive widening project. A total of $3,806,250 was approved to be
transferred in 2021 as construction invoices are paid.
Infrastructure Fund
Total revenues through June 2021 are down $99,664, or 3.4%, from last year, but $89,128, or
3.3%, over budget. The main drivers for this are:
o Non-home rule sales tax revenue
is down $60,838 from last year,
but $89,731 over budget. June
2021 collections were the
highest June in the past five
years despite COVID-19
restrictions that were in place.
o Investment Interest revenue is
down $41,571 from last year and
$3,173 under budget.
Investment return rates have
dropped significantly since the beginning of the COVID-19 pandemic.
Total expenditures through July 2021 are up $2,595,712, or 157.1%, from last year, but
$1,067,855, or 20.1%, under budget to date. The main drivers for this are:
o Personnel expenditures are up $104,910 from last year and $100,694 over budget. This
is due to multiple retirements and the related unused accrual time payouts.
o Operation and contract expenditures are down $152,742 from last year and $414,364
under budget. Expenditures are under budget due to the timing of engineering and
other miscellaneous payments.
o Capital Outlay expenditures are up $2,621,766 from last year, but $768,702 under
budget. Expenditures are up due to delays last year and general timing of work
performed.
Through June 2021, the Infrastructure Fund has received $1,462,918 from the Hotel Tax Fund
related to the Windsor Drive widening project. A total of $3,806,250 was approved to be
transferred in 2021 as construction invoices are paid.
Promenade TIF Fund
Total revenues through June 2021 are up $2,465, or 1.0%, from last year and $632, or 0.3%, over
budget.
Total expenditures through June 2021 are up $215,218, or 80.0%, from last year and $253,013,
or 109.4%, over budget to date. This relates to the timing of the second principal and interest
installment due in July.
Water Fund
Total revenues through June 2021 are up $893,357, or 23.9%, from last year and $168,203, or
3.8%, over budget. The main drivers for this are:
o Water sales revenue is up $148,889 from last year, but $555,670 under budget. Water
gallons sold has been less than projected so far this year.
o Miscellaneous revenue is up $617,691 from last year and $605,909 over budget. This is
due to a payment related to the sale of non-corporate water lines.
Total expenditures through June 2021 are up $1,313,992, or 39.7%, from last year, but
$4,079,207, or 46.9%, under budget. The main drivers for this are:
o Operation and contract expenditures are up $112,530 from last year, but $990,381
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 $1,182,212 from last year, but $3,073,865 under
budget. Many capital projects were delayed in 2020 due to the COVID-19 pandemic.
Capital projects are still scheduled to occur later in 2021 as planned.
Sports Core Fund
Total revenues through June 2021 are up $978,541, or 104.4%, from last year and $517,480, or
37.0%, over budget to date. The main drivers for this are:
o Memberships revenue is up $129,928 from last year and $118,415 over budget. Golf
memberships have seen a significant increase in 2021 to some of the highest levels.
o Greens Fees revenue is up $271,050 from last year and $169,141 over budget. The
course did not see much activity in early 2020 due to COVID-19 restrictions.
o Driving Range Fees revenue is up $101,562 from last year and $65,198 over budget.
This is due to the golf course being able to open early and stay open this season.
o Food sales are up $79,089 from last year and $57,460 over budget. This is due to recent
renovations to the Golf patio and clubhouse and due to minimal activity last spring due
to COVID-19 restrictions.
o Beverage sales are up $130,505 from last year and $119,621 over budget. This is due to
recent renovations to the Golf patio and clubhouse and due to minimal activity last
spring due to COVID-19 restrictions.
Total expenditures through June 2021 are down $402,466, or 24.2%, from last year and
$828,140, or 39.7%, under budget to date. The main drivers for this are:
o Personnel expenditures are up $79,285 from last year, but $31,211 under budget.
Expenditures are up from last year due to the golf course being closed in spring 2020 for
COVID-19 restrictions. Personnel is under budget due to the poolside grille operations
and swim team not occurring in 2021.
o Capital outlay expenditures are down $633,369 from last year and $697,748 under
budget. Expenditures are down because of the golf lounge project that occurred in
spring 2020. Expenditures are under budget due to the timing of projects.
6/30/21 6/30/21
6/30/20 6/30/21 YTD % of YTD 2021 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 6,440,297$ 6,498,311$ 5,979,200$ 108.7%11,860,995$ 58,014$
Other Intergovernmental Tax*753,417 1,041,206 725,200 143.6%1,320,600 287,789
Telecommunications/Utility Tax 3,045,980 2,798,505 3,134,000 89.3%5,995,000 (247,475)
Licenses and Permits 871,638 1,166,063 1,152,920 101.1%2,180,360 294,425
Charges for Services 471,860 543,139 646,770 84.0%1,293,540 71,279
Fines and Penalties 84,633 83,488 90,270 92.5%180,500 (1,145)
Administrative Towing Fees 8,164 13,724 11,010 124.7%22,000 5,560
Investment Interest 204,708 98,725 150,000 65.8%300,000 (105,983)
Franchise Fees 51,448 52,636 101,000 52.1%202,000 1,188
Miscellaneous Income 191,830 229,450 221,150 103.8%463,380 37,620
Total Operating Revenues 12,123,975$ 12,525,247$ 12,211,520$ 102.6%23,818,375$ 401,272$
OPERATING EXPENDITURES
Personnel 9,043,399$ 8,168,894$ 8,784,015$ 93.0%18,842,080$ (874,505)$
Materials and Supplies 214,581 199,477 303,560 65.7%551,030 (15,104)
Operation and Contract 1,793,221 1,631,552 1,816,635 89.8%3,397,210 (161,669)
Other Expenditures 4,374 4,315 5,000 86.3%10,000 (59)
Capital Outlay 99,852 120,742 137,130 88.0%452,300 20,890
Total Operating Expenditures 11,155,427$ 10,124,980$ 11,046,340$ 91.7%23,252,620$ (1,030,447)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 968,548$ 2,400,267$ 1,165,180$ 565,755$ 1,431,719$
INTERFUND TRANSACTIONS
Transfers Out (326,369)$ -$ (100,000)$ 0.0%(100,000)$ 326,369$
Reimbursements From Other Funds 313,194 296,838 296,850 100.0%593,685 (16,356)
Reimbursements To Other Funds (69,882) (52,944) (52,950) 100.0%(105,885) 16,938
Total Interfund Transactions (83,057)$ 243,894$ 143,900$ 169.5%387,800$ 326,951$
NET FUND INCREASE (DECREASE)885,491$ 2,644,161$ 1,309,080$ 953,555$ 1,758,670$
*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, 2021
Total Total
Revenues Expenditures
6/30/21 Actual 12,525,247$ 10,124,980$
6/30/20 Actual 12,123,975$ 11,155,427$
% Change From Last Year 3.3%-9.2%
Major Revenues
Other Telecom/Utility Licenses &Charges for
Sales Tax Intergov. Tax Tax Permits Services
6/30/21 Actual 6,498,311$ 1,041,206$ 2,798,505$ 1,166,063$ 543,139$
6/30/20 Actual $ 6,440,297 $ 753,417 $ 3,045,980 $ 871,638 $ 471,860
% Change From Last Year 0.9%38.2%-8.1%33.8%15.1%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
6/30/21 Actual 8,168,894$ 199,477$ 1,631,552$ 4,315$ 120,742$
6/30/20 Actual 9,043,399$ 214,581$ 1,793,221$ 4,374$ 99,852$
% Change From Last Year -9.7%-7.0%-9.0%-1.3%20.9%
Five Year Trend
Expenditures by Department
6/30/20 6/30/21 6/30/21 6/30/21 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Department Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 981,327$ 1,131,385$ 1,222,135$ 92.6%2,498,625$ 150,058$
Financial Services 381,079 364,524 379,270 96.1%770,360 (16,555)
Public Works 342,905 479,945 463,350 103.6%948,860 137,040
Engineering & Capital Projects 31,739 19,877 44,000 45.2%209,000 (11,862)
Library 397,388 403,388 450,190 89.6%943,405 6,000
Police 4,582,222 3,949,989 4,324,190 91.3%9,213,585 (632,233)
Fire 3,953,374 3,315,805 3,631,225 91.3%7,576,045 (637,569)
Development Services 485,393 460,067 531,980 86.5%1,092,740 (25,326)
Total Expenditures 11,155,427$ 10,124,980$ 11,046,340$ 91.7%23,252,620$ (1,030,447)$
Five Year Trend
For the Period Ending June 30, 2021
General Fund - Five Year Trend
Village of Oak Brook
Revenues Expenditures
6/30/21 6/30/21
6/30/20 6/30/21 YTD % of YTD 2021 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Hotel Tax 309,373$ 240,607$ 193,900$ 124.1%414,000$ (68,766)$
Investment Interest 41,937 19,187 20,010 95.9%40,000 (22,750)
Loan Interest 8,333 4,000 4,000 100.0%8,000 (4,333)
Total Operating Revenues 359,643$ 263,794$ 217,910$ 121.1%462,000$ (95,849)$
EXPENDITURES
Operation and Contract 228,387$ 55,124$ 94,460$ 58.4%193,945$ (173,263)$
Capital Outlay 216,966 2,650 50,000 5.3%250,000 (214,316)
Total Expenditures 445,353$ 57,774$ 144,460$ 40.0%443,945$ (387,579)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES (85,710)$ 206,020$ 73,450$ 280.5%18,055$ 291,730$
INTERFUND TRANSACTIONS
Transfer Out -$ (1,462,918)$ (1,000,000)$ 146.3%(100,000)$ (1,462,918)$
Reimbursements to Other Funds (37,356) (42,042) (42,030) 100.0%(84,085) (4,686)
Total Interfund Transactions (37,356)$ (1,504,960)$ (1,042,030)$ 144.4%(184,085)$ (1,467,604)$
NET FUND INCREASE (DECREASE)(123,066)$ (1,298,940)$ (968,580)$ (166,030)$ (1,175,874)$
Note - Expenditures are recorded in program 171.
Village of Oak Brook
Hotel Tax Fund Financial Update
For the Period Ending June 30, 2021
Total Total
Revenues Expenditures
6/30/21 Actual $ 263,794 57,774$
6/30/20 Actual $ 359,643 445,353$
% Change From Last Year -26.7%-87.0%
Major Revenues Investment
Hotel Tax Interest Loan Interest Miscellaneous
6/30/21 Actual $ 240,607 $ 19,187 4,000$ -$
6/30/20 Actual $ 309,373 $ 41,937 8,333$ -$
% Change From Last Year -22.2%-54.2%-52.0%0.0%
Five Year Trend
Major Expenditures Operation &
Contractual Capital Outlay
6/30/21 Actual 55,124$ 2,650$
6/30/20 Actual 228,387$ 216,966$
% Change From Last Year -75.9%-98.8%
Five Year Trend
Village of Oak Brook
Hotel Tax Fund - Major Sources Five Year Trend
For the Period Ending June 30, 2021
Five Year Trend
Revenues Expenditures
6/30/21 6/30/21
6/30/20 6/30/21 YTD % of YTD 2021 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Non-Home Rule Sales Tax 2,859,169$ 2,798,331$ 2,708,600$ 103.3%5,333,500$ (60,838)$
Charges for Services 335 - 510 0.0%1,000 (335)
Investment Interest 58,408 16,837 20,010 84.1%40,000 (41,571)
Miscellaneous - 3,080 - N/A - 3,080
Total Operating Revenues 2,917,912$ 2,818,248$ 2,729,120$ 103.3%5,374,500$ (99,664)$
OPERATING EXPENDITURES
Personnel 656,549$ 761,459$ 660,765$ 115.2%1,386,115$ 104,910$
Materials and Supplies 114,434 136,212 121,695 111.9%245,660 21,778
Operation and Contract 706,038 553,296 967,660 57.2%1,892,905 (152,742)
Capital Outlay 175,262 2,797,028 3,565,730 78.4%8,956,170 2,621,766
Total Operating Expenditures 1,652,283$ 4,247,995$ 5,315,850$ 79.9%12,480,850$ 2,595,712$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 1,265,629$ (1,429,747)$ (2,586,730)$ 55.3%(7,106,350)$ (2,695,376)$
INTERFUND TRANSACTIONS
Transfers In -$ 1,462,918$ 1,000,000$ 146.3%1,400,000$ 1,462,918$
Reimbursements From Other Funds 179,688 165,924 165,930 100.0%331,840 (13,764)
Reimbursements To Other Funds (81,150) (88,152) (88,280) 99.9%(176,300) (7,002)
Total Interfund Transactions 98,538$ 1,540,690$ 1,077,650$ 143.0%1,555,540$ 1,442,152$
NET FUND INCREASE (DECREASE)1,364,167$ 110,943$ (1,509,080)$ (5,550,810)$ (1,253,224)$
Village of Oak Brook
Infrastructure Fund Financial Update
For the Period Ending June 30, 2021
Total Total
Revenues Expenditures
6/30/21 Actual $ 2,818,248 4,247,995$
6/30/20 Actual $ 2,917,912 1,652,283$
% Change From Last Year -3.4%157.1%
Major Revenues
Sales Tax
Charges for
Services
Investment
Interest Miscellaneous
6/30/21 Actual $ 2,798,331 $ - $ 16,837 $ 3,080
6/30/20 Actual $ 2,859,169 $ 335 $ 58,408 $ -
% Change From Last Year -2.1%-100.0%-71.2%N/A
Five Year Trend
Major Expenditures Materials &Operation &
Personnel Supplies Contractual Capital Outlay
6/30/21 Actual 761,459$ 136,212$ 553,296$ 2,797,028$
6/30/20 Actual 656,549$ 114,434$ 706,038$ 175,262$
% Change From Last Year 16.0%19.0%-21.6%1495.9%
Five Year Trend
Expenditures by Department
6/30/20 6/30/21 6/30/21 6/30/21 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 73,081$ 82,977$ 75,160$ 110.4%157,640$ 9,896$
Public Works 1,102,733 1,332,016 1,267,325 105.1%2,789,580 229,283
Engineering & Capital Projects 476,469 2,833,002 3,973,365 71.3%9,709,930 2,356,533
Total Expenditures 1,652,283$ 4,247,995$ 5,315,850$ 79.9%12,657,150$ 2,595,712$
Five Year Trend
Village of Oak Brook
Infrastructure Fund - Major Sources Five Year Trend
For the Period Ending June 30, 2021
Revenues Expenditures
6/30/21 6/30/21
6/30/20 6/30/21 YTD % of YTD 2021 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 29,658$ 35,586$ 38,700$ 92.0%75,000$ 5,928$
Real Estate Tax 207,272 204,228 200,000 102.1%400,000 (3,044)
Investment Interest 447 28 510 5.5%1,000 (419)
Total Operating Revenues 237,377$ 239,842$ 239,210$ 100.3%476,000$ 2,465$
EXPENDITURES
Operation and Contract 3,590$ 2,763$ 3,000$ 92.1%3,850$ (827)$
Other Expenditures 265,455 481,500 228,250 211.0%466,500 216,045
Total Expenditures 269,045$ 484,263$ 231,250$ 209.4%470,350$ 215,218$
NET FUND INCREASE (DECREASE)(31,668)$ (244,421)$ 7,960$ 5,650$ (212,753)$
Note - Expenditures are recorded in program 283.
Village of Oak Brook
Promenade TIF Fund Financial Update
For the Period Ending June 30, 2021
Total Total
Revenues Expenditures
6/30/21 Actual $ 239,842 484,263$
6/30/20 Actual $ 237,377 269,045$
% Change From Last Year 1.0%80.0%
Major Revenues Real Estate Investment
Sales Tax Tax Interest
6/30/21 Actual 35,586$ $ 204,228 $ 28
6/30/20 Actual 29,658$ $ 207,272 $ 447
% Change From Last Year 20.0%-1.5%-93.7%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures
6/30/21 Actual 2,763$ 481,500$
6/30/20 Actual 3,590$ 265,455$
% Change From Last Year -23.0%81.4%
Five Year Trend
Village of Oak Brook
Promenade TIF Fund - Major Sources Five Year Trend
For the Period Ending June 30, 2021
Five Year Trend
Revenues Expenditures
6/30/21 6/30/21
6/30/20 6/30/21 YTD % of YTD 2021 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Plan Review Fees 225$ 375$ 510$ 73.5%1,000$ 150$
Building/Inspection Fees 4,987 2,700 3,510 76.9%7,000 (2,287)
Water Sales 3,605,441 3,754,330 4,310,000 87.1%10,597,000 148,889
Unmetered Sales 27,433 9,690 17,490 55.4%35,000 (17,743)
Water Connection Fees 5,080 181,240 50,010 362.4%100,000 176,160
Meter Charges 4,442 6,126 7,500 81.7%15,000 1,684
Special Services 12,657 12,757 12,500 102.1%25,000 100
Investment Interest 57,883 26,596 30,000 88.7%60,000 (31,287)
Miscellaneous 20,708 638,399 32,490 1964.9%65,000 617,691
Total Operating Revenues 3,738,856$ 4,632,213$ 4,464,010$ 103.8%10,905,000$ 893,357$
OPERATING EXPENDITURES
Personnel 390,095$ 374,196$ 396,365$ 94.4%842,235$ (15,899)$
Materials and Supplies 11,389 46,538 39,330 118.3%75,780 35,149
Operation and Contract 1,589,799 1,702,329 2,692,710 63.2%5,379,925 112,530
Capital Outlay 1,321,423 2,503,635 5,577,500 44.9%8,103,750 1,182,212
Total Expenditures 3,312,706$ 4,626,698$ 8,705,905$ 53.1%14,401,690$ 1,313,992$
Surplus (Deficit) of Revenues Over
Expenditures 426,150$ 5,515$ (4,241,895)$ -0.1%(3,496,690)$ (420,635)$
INTERFUND TRANSACTIONS
Reimbursements To Other Funds (263,406) (225,252)$ (225,240)$ 100.0%(450,500)$ 38,154$
Total Interfund Transactions (263,406)$ (225,252)$ (225,240)$ 100.0%(450,500)$ 38,154$
Fund Increase/(Decrease) - Budgetary Basis 162,744$ (219,737)$ (4,467,135)$ 4.9%(3,947,190)$ (382,481)$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay 1,321,423$ 2,503,635$
Depreciation Expense (274,352) (287,500)
IMRF Pension Expense (20,747) (22,500)
OPEB Expense 13,822 (15,000)
Total GAAP Adjustments 1,040,147$ 2,178,635$
Fund Increase/(Decrease) - GAAP Basis 1,202,891$ 1,958,898$
*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, 2021
Total Total
Revenues Expenditures
6/30/21 Actual $ 4,632,213 4,626,698$
6/30/20 Actual $ 3,738,856 3,312,706$
% Change From Last Year 23.9%39.7%
Unmetered Water
Water Sales Sales Connection Fees Meter Charges Miscellaneous
6/30/21 Actual $ 3,754,330 $ 9,690 $ 181,240 $ 6,126 $ 638,399
6/30/20 Actual $ 3,605,441 $ 27,433 $ 5,080 $ 4,442 $ 20,708
% Change From Last Year 4.1%-64.7%3467.7%37.9%2982.9%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
6/30/21 Actual 374,196$ 46,538$ 1,702,329$ -$ 2,503,635$
6/30/20 Actual 390,095$ 11,389$ 1,589,799$ -$ 1,321,423$
% Change From Last Year -4.1%308.6%7.1%0.0%89.5%
Five Year Trend
Expenditures by Department
6/30/20 6/30/21 6/30/21 6/30/21 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Public Works 1,995,888$ 2,109,814$ 3,138,405$ 67.2%6,317,940$ 113,926$
Engineering & Capital Projects 1,316,818 2,516,884 5,567,500 45.2%8,083,750 1,200,066
Total Expenditures 3,312,706$ 4,626,698$ 8,705,905$ 53.1%14,401,690$ 1,313,992$
Five Year Trend
Village of Oak Brook
Water Fund - Major Sources Five Year Trend
For the Period Ending June 30, 2021
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Sports Core Fund Consolidated Presentation
For the Period Ending June 30, 2021
6/30/21 6/30/21
6/30/21 YTD % of YTD 2021 6/30/20 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 -$ -$ -$ 356,915$ 356,915$ 238,500$ 149.6%238,500$ 226,987$ 129,928$
Greens Fees - - - 527,141 527,141 358,000 147.2%985,000 256,091 271,050
Pro Shop Sales - - - 125,997 125,997 102,500 122.9%207,000 57,437 68,560
Golf Lessons - - - 46,525 46,525 30,000 155.1%45,000 7,105 39,420
Driving Range Fees - - - 215,198 215,198 150,000 143.5%250,000 113,636 101,562
Rentals - 95,000 33,658 196,880 325,538 313,725 103.8%761,000 176,729 148,809
Programs/User Fees - - - - - 31,500 0.0%31,500 - -
Food Sales - - - 109,460 109,460 52,000 210.5%207,500 30,371 79,089
Beverage Sales - - - 197,121 197,121 77,500 254.3%382,000 66,616 130,505
Taste of Oak Brook - - - - - 40,000 0.0%120,000 - -
Grants - - - - - - 0.0%233,600 - -
Other Revenue 7,442 - - 4,938 12,380 5,070 244.2%7,700 2,762 9,618
Total Operating Revenues 7,442$ 95,000$ 33,658$ 1,780,175$ 1,916,275$ 1,398,795$ 137.0%3,468,800$ 937,734$ 978,541$
OPERATING EXPENDITURES
Personnel 6,867$ -$ 52,515$ 514,412$ 573,794$ 605,005$ 94.8%1,597,610$ 494,509$ 79,285$
Materials & Supplies 28,301 - 2,890 250,054 281,245 364,200 77.2%628,450 150,771 130,474
Operational & Contractual 40,024 5,161 25,628 182,226 253,039 269,265 94.0%663,035 231,895 21,144
Other - - - - - - 0.0%(39,000) - -
Capital 133,420 - 4,382 11,950 149,752 847,500 17.7%1,125,380 783,121 (633,369)
Total Operating Expenditures 208,612$ 5,161$ 85,415$ 958,642$ 1,257,830$ 2,085,970$ 60.3%3,975,475$ 1,660,296$ (402,466)$
B&T Administration Overhead Allocation*24,342$ -$ (24,342)$ -$ -$ -$ 0.0%-$ -$ -$
Operating Revenues Over (Under) Expenditures (176,828)$ 89,839$ (76,099)$ 821,533$ 658,445$ (687,175)$ -95.8%(506,675)$ (722,562)$ 1,381,007$
INTERFUND TRANSACTIONS
Transfer From General Fund -$ -$ -$ -$ -$ 100,000$ 0.0%100,000$ 326,369$ (326,369)$
Transfer From Golf Surcharge Fund - - - - - 200,000 0.0%200,000 323,373 (323,373)
Reimbursement From Infrastructure Fund 16,002 - - - 16,002 16,005 100.0%32,000 12,000 4,002
Reimbursement From Water Fund 4,002 - - - 4,002 4,005 99.9%8,000 4,002 -
Reimbursement To General Fund (7,860) - - (23,586) (31,446) (31,455) 100.0%(62,900) (28,224) (3,222)
Total Interfund Transactions 12,144$ -$ -$ (23,586)$ (11,442)$ 288,555$ -4.0%277,100$ 637,520$ (648,962)$
Total Revenues Over (Under) Expenditures - Budgetary Basis (164,684)$ 89,839$ (76,099)$ 797,947$ 647,003$ (398,620)$ (229,575)$ (85,042)$ 732,045$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 133,420$ -$ 4,382$ 11,950$ 149,752$ 783,121$
Depreciation Expense (84,114) (843) (30,000) (123,150) (238,106) (194,541)
IMRF Pension Expense (1,025) - (1,500) (12,250) (14,775) (13,077)
OPEB Expense - - (1,500) (14,000) (15,500) (12,623)
Total GAAP Adjustments 48,282$ (843)$ (28,618)$ (137,450)$ (118,629)$ 562,880$
Fund Increase/(Decrease) - GAAP Basis (116,403)$ 88,997$ (104,717)$ 660,497$ 528,374$ 477,838$
*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.
Total Direct Total Direct
Revenues Expenditures
6/30/21 Actual $ 1,916,275 1,257,830$
6/30/20 Actual $ 937,734 1,660,296$
% Change From Last Year 104.4%-24.2%
Driving Program/
Memberships Greens Fees Range Fees Rentals User Fees
6/30/21 Actual $ 356,915 $ 527,141 $ 215,198 $ 325,538 -$
6/30/20 Actual $ 226,987 $ 256,091 $ 113,636 $ 176,729 -$
% Change From Last Year 57.2%105.8%89.4%84.2%0.0%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
6/30/21 Actual 573,794$ 281,245$ 253,039$ -$ 149,752$
6/30/20 Actual 494,509$ 150,771$ 231,895$ -$ 783,121$
% Change From Last Year 16.0%86.5%9.1%0.0%-80.9%
Five Year Trend
Revenues by Department 6/30/20 6/30/21 6/30/21 6/30/21 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Operations 192$ 7,442$ 56,070$ 13.3%325,800$ 7,250$
Open Field Operations 87,540 95,000 135,000 70.4%230,000 7,460
B&T Clubhouse Operations 12,648 33,658 67,000 50.2%267,000 21,010
Golf Club 837,354 1,780,175 1,140,725 156.1%2,646,000 942,821
Total Revenues 937,734$ 1,916,275$ 1,398,795$ 137.0%3,468,800$ 978,541$
Expenditures by Department 6/30/20 6/30/21 6/30/21 % of YTD 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Operations 380,523$ 208,612$ 460,575$ 45.3%780,740$ (171,911)$
Open Field Operations 43,693$ 5,161$ 123,530$ 4.2%358,910$ (38,532)$
B&T Clubhouse Operations 85,948 85,415 121,350 70.4%262,635 (533)
Golf Club 1,150,132 958,642 1,380,515 69.4%2,573,190 (191,490)
Total Expenditures 1,660,296$ 1,257,830$ 2,085,970$ 60.3%3,975,475$ (402,466)$
Five Year Trend
Village of Oak Brook
Sports Core Fund - Major Sources Five Year Trend
For the Period Ending June 30, 2021
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Club Recreation Operations
For the Period Ending June 30, 2021 6/30/21 6/30/21
822 6/30/21 YTD % of YTD 2021 6/30/20 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 -$ -$ -$ -$ -$ -$ 0.0%-$ 199$ (199)$
Programs/User Fees - - - - - 31,500 0.0%31,500 - -
Food Sales - - - - - 16,000 0.0%38,000 - -
Beverage Sales - - - - - 8,500 0.0%22,000 - -
Grants - - - - - - 0.0%233,600 - -
Other Revenue 7,442 - - - 7,442 70 10631.4%700 (7) 7,449
Total Operating Revenues 7,442$ -$ -$ -$ 7,442$ 56,070$ 13.3%325,800$ 192$ 7,250$
OPERATING EXPENDITURES
Personnel 6,477$ -$ -$ 390$ 6,867$ 47,615$ 14.4%119,110$ 2,259$ 4,608$
Materials & Supplies 226 22,061 2,460 3,554 28,301 28,840 98.1%37,250 1,149 27,152
Operational & Contractual 18,518 18,918 2,465 123 40,024 54,120 74.0%89,550 34,458 5,566
Capital 23,045 110,375 - - 133,420 330,000 40.4%534,830 342,657 (209,237)
Total Operating Expenditures 48,266$ 151,354$ 4,925$ 4,067$ 208,612$ 460,575$ 45.3%780,740$ 380,523$ (171,911)$
B&T Administration Overhead Allocation*48,683$ (17,526)$ (4,868)$ (1,947)$ 24,342$ 27,700$ 87.9%44,755$ 28,963$ (4,621)$
Operating Revenues Over (Under) Expenditures 7,859$ (168,880)$ (9,793)$ (6,014)$ (176,828)$ (376,805)$ 46.9%(410,185)$ (351,368)$ 174,540$
INTERFUND TRANSACTIONS
Transfer From General Fund -$ -$ -$ -$ -$ 100,000$ 0.0%100,000$ 326,369$ (326,369)$
Reimbursement From Infrastructure Fund 16,002 - - - 16,002 16,005 100.0%32,000 12,000 4,002
Reimbursement From Water Fund 4,002 - - - 4,002 4,005 99.9%8,000 4,002 -
Reimbursement To General Fund (7,860) - - - (7,860) (7,860) 100.0%(15,725) (14,112) 6,252
Total Interfund Transactions 12,144$ -$ -$ -$ 12,144$ 112,150$ 10.8%124,275$ 328,259$ (316,115)$
Total Revenues Over (Under) Expenditures - Budgetary Basis 20,003$ (168,880)$ (9,793)$ (6,014)$ (164,684)$ (264,655)$ (285,910)$ (23,109)$ (141,575)$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 23,045$ 110,375$ -$ -$ 133,420$ 342,657$
Depreciation Expense (32,180) (50,000) (1,350) (584) (84,114) (46,054)
IMRF Pension Expense (1,000) - - (25) (1,025) (560)
Total GAAP Adjustments (10,135)$ 60,375$ (1,350)$ (609)$ 48,282$ 296,044$
Fund Increase/(Decrease) - GAAP Basis 9,869$ (108,505)$ (11,143)$ (6,623)$ (116,403)$ 272,935$
*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, 2021 6/30/21 6/30/21
6/30/21 YTD % of YTD 2021 6/30/20 Difference
815 816 YTD Amended Amended Adopted YTD Prior
Polo Open Fields Total Budget Budget Budget Total Year
OPERATING REVENUES
Field Rentals -$ 15,000$ 15,000$ 15,000$ 100.0%30,000$ 12,540$ 2,460$
Range Rentals - 80,000 80,000 80,000 100.0%80,000 75,000 5,000
Taste of Oak Brook - - - 40,000 0.0%120,000 - -
Other Revenue - - - - 0.0%- - -
Total Operating Revenues -$ 95,000$ 95,000$ 135,000$ 70.4%230,000$ 87,540$ 7,460$
OPERATING EXPENDITURES
Personnel -$ -$ -$ -$ 0.0%-$ -$ -$
Materials & Supplies - - - 200 0.0%500 119 (119)
Operational & Contractual - 5,161 5,161 23,330 22.1%190,360 34,864 (29,703)
Capital - - - 100,000 0.0%168,050 8,710 (8,710)
Total Operating Expenditures -$ 5,161$ 5,161$ 123,530$ 4.2%358,910$ 43,693$ (38,532)$
Operating Revenues Over (Under) Expenditures -$ 89,839$ 89,839$ 11,470$ 783.3%(128,910)$ 43,847$ 45,992$
INTERFUND TRANSACTIONS
Transfer From Hotel Tax Fund -$ -$ -$ -$ 0.0%-$ -$ -$
Total Interfund Transactions -$ -$ -$ -$ 0.0%-$ -$ -$
Total Revenues Over (Under) Expenditures - Budgetary Basis -$ 89,839$ 89,839$ 11,470$ (128,910)$ 43,847$ 45,992$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay -$ -$ -$ 8,710$
Depreciation Expense - (843) (843) (843)
Total GAAP Adjustments -$ (843)$ (843)$ 7,868$
Fund Increase/(Decrease) - GAAP Basis -$ 88,997$ 88,997$ 51,715$
*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, 2021
6/30/21 6/30/21
821 YTD % of YTD 2021 6/30/20 Difference
B&T Amended Amended Adopted YTD Prior
Clubhouse Budget Budget Budget Total Year
OPERATING REVENUES
Rentals 33,658$ 67,000$ 50.2%267,000$ 12,648$ 21,010$
Total Operating Revenues 33,658$ 67,000$ 50.2%267,000$ 12,648$ 21,010$
OPERATING EXPENDITURES
Personnel 52,515$ 58,790$ 89.3%133,585$ 52,561$ (46)$
Materials & Supplies 2,890 5,890 49.1%12,000 1,527 1,363
Operational & Contractual 25,628 52,170 49.1%107,550 30,567 (4,939)
Capital 4,382 4,500 97.4%9,500 1,293 3,089
Total Operating Expenditures 85,415$ 121,350$ 70.4%262,635$ 85,948$ (533)$
B&T Administration Overhead Allocation*(24,342)$ (27,700)$ 87.9%(44,755)$ (28,963)$ 4,621$
Operating Revenues Over (Under) Expenditures (76,099)$ (82,050)$ 92.7%(40,390)$ (102,263)$ 26,164$
INTERFUND TRANSACTIONS
Transfer From General Fund -$ -$ 0.0%-$ -$ -$
Total Interfund Transactions -$ -$ 0.0%-$ -$ -$
Total Revenues Over (Under) Expenditures - Budgetary Basis (76,099)$ (82,050)$ (40,390)$ (102,263)$ 26,164$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 4,382$ 1,293$
Depreciation Expense (30,000) (30,278)
IMRF Pension Expense (1,500) (1,037)
OPEB Expense (1,500) (1,322)
Total GAAP Adjustments (28,618)$ (31,343)$
Fund Increase/(Decrease) - GAAP Basis (104,717)$ (133,606)$
*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, 2021
6/30/21 6/30/21
823 831 832 833 834 6/30/21 YTD % of YTD 2021 6/30/20 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 -$ 356,915$ -$ -$ -$ 356,915$ 238,500$ 149.6%238,500$ 226,788$ 130,127$
Greens Fees - 527,141 - - - 527,141 358,000 147.2%985,000 256,091 271,050
Pro Shop Sales - 125,997 - - - 125,997 102,500 122.9%207,000 57,437 68,560
Golf Lessons - - 46,525 - - 46,525 30,000 155.1%45,000 7,105 39,420
Driving Range Fees - - 215,198 - - 215,198 150,000 143.5%250,000 113,636 101,562
Rentals - 925 - 195,955 - 196,880 151,725 129.8%384,000 76,541 120,339
Food Sales 109,460 - - - - 109,460 36,000 304.1%169,500 30,371 79,089
Beverage Sales 197,121 - - - - 197,121 69,000 285.7%360,000 66,616 130,505
Other Revenue 28 4,910 - - - 4,938 5,000 98.8%7,000 2,769 2,169
Total Operating Revenues 306,609$ 1,015,888$ 261,723$ 195,955$ -$ 1,780,175$ 1,140,725$ 156.1%2,646,000$ 837,354$ 942,821$
OPERATING EXPENDITURES
Personnel 90,093$ 230,326$ 12,623$ 15,441$ 165,929$ 514,412$ 498,600$ 103.2%1,344,915$ 439,689$ 74,723$
Materials & Supplies 121,681 41,850 8,162 735 77,626 250,054 329,270 75.9%578,700 147,976 102,078
Operational & Contractual 3,132 137,018 439 24,786 16,851 182,226 139,645 130.5%275,575 132,006 50,220
Other - - - - - - - 0.0%(39,000) - -
Capital - 11,552 - - 398 11,950 413,000 2.9%413,000 430,461 (418,511)
Total Operating Expenditures 214,906$ 420,746$ 21,224$ 40,962$ 260,804$ 958,642$ 1,380,515$ 69.4%2,573,190$ 1,150,132$ (191,490)$
Operating Revenues Over (Under) Expenditures 91,703$ 595,142$ 240,499$ 154,993$ (260,804)$ 821,533$ (239,790)$ -342.6%72,810$ (312,778)$ 1,134,311$
INTERFUND TRANSACTIONS
Transfer from Golf Surcharge -$ -$ -$ -$ 200,000$ 0.0%200,000$ 323,373$ (323,373)$
Reimbursement to General Fund - (23,586) - (23,586) (23,595) 100.0%(47,175) (14,112) (9,474)
Total Interfund Transactions -$ (23,586)$ -$ -$ -$ (23,586)$ 176,405$ -13.4%152,825$ 309,261$ (332,847)$
Total Revenues Over (Under) Expenditures - Budgetary Basis 91,703$ 571,556$ 240,499$ 154,993$ (260,804)$ 797,947$ (63,385)$ 225,635$ (3,517)$ 801,464$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay -$ 11,552$ -$ -$ 398$ 11,950$ 430,461$
Depreciation Expense (500) (52,500) (1,150) (6,500) (62,500) (123,150) (117,368)
IMRF Pension Expense (1,250) (5,000) (500) - (5,500) (12,250) (11,481)
OPEB Expense (1,500) (7,500) - - (5,000) (14,000) (11,301)
Total GAAP Adjustments (3,250)$ (53,448)$ (1,650)$ (6,500)$ (72,602)$ (137,450)$ 290,312$
Fund Increase/(Decrease) - GAAP Basis 88,453$ 518,108$ 238,849$ 148,493$ (333,406)$ 660,497$ 286,795$
*Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.