10 - October 2021 Monthly Financial ReportVILLAGE
OAK BROOK
OF
MONTHLY FINANCIAL REPORTS
OCTOBER 2021
Cash and Investments by Fund:Total
Cash and Cash Pooled Cash and
Fund Equivalents Investments Investments % By Fund
General Corporate $15,663,798 $13,045,736 $28,709,534 60.6%
Hotel/Motel Tax 158,959 2,070,644 2,229,603 4.7%
Motor Fuel Tax 1,082,614 18,062 1,100,676 2.3%
Infrastructure 4,228,986 3,097,528 7,326,514 15.5%
Promenade TIF 263,557 - 263,557 0.6%
Water 1,993,024 3,457,035 5,450,059 11.5%
Sports Core 735,700 - 735,700 1.6%
Golf Surcharge 271,207 - 271,207 0.6%
Self-Insurance 165,464 - 165,464 0.3%
Garage 331,069 - 331,069 0.7%
Equipment Replacement 390,861 397,819 788,680 1.7%
Total $25,285,239 $22,086,824 $47,372,063 100.0%
Change in Cash and Investments by Fund :
Balance at Balance at Year-to-Date Year-to-Date
Fund January 1, 2021 October 31, 2021 Change ($)Change (%)
General Corporate $23,894,312 $28,709,534 $4,815,222 20.2%
Hotel/Motel Tax 4,567,176 2,229,603 (2,337,573)-51.2%
Motor Fuel Tax 673,455 1,100,676 427,221 63.4%
Infrastructure 7,480,975 7,326,514 (154,461)-2.1%
Promenade TIF 267,300 263,557 (3,743)-1.4%
Water 6,900,169 5,450,059 (1,450,110)-21.0%
Sports Core 114,133 735,700 621,567 544.6%
Golf Surcharge 132,593 271,207 138,614 104.5%
Self-Insurance - 165,464 165,464 N/A
Garage 298,348 331,069 32,721 11.0%
Equipment Replacement 696,392 788,680 92,288 13.3%
$45,024,853 $47,372,063 $2,347,210 5.2%
Book Bank/Market
Value Value
Cash and Cash Equivalents:
Pooled Checking $394,520 $1,134,022
Sports Core Checking 1,014,437 979,495
Pooled IPTIP 23,248,111 23,248,111
Water E-Pay IPTIP 628,171 623,018
$25,285,239 $25,984,646
Pooled Investments:
Investments-Municipal Bonds $9,342,037 $9,339,793
Investments-Corporate Bonds 8,826,210 8,782,474
Government & Agency Obligations 1,288,042 1,286,254
Certificates of Deposit 2,450,000 2,451,972
Accrued Interest 180,535 180,535
Total Pooled Investments $22,086,824 $22,041,028
Total Cash and Investments $47,372,063 $48,025,674
For October, total interest revenue is $19,614 and YTD is $250,980. The total investment yield for the portfolio is:
Pooled
Investments Illinois Funds Total
Last 12 months yield 1.29%0.05%0.70%
The weighted average yield of the current investment portfolio is 1.04%. The IL Funds October average daily rate was 0.025%.
Monthly Treasurer's Report
October 31, 2021
Monthly Treasurer's Report
October 2021
The table below lists the detail investment holdings at J.P. Morgan Securities as of 10/31/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%$501,324 $505,695 $6,736
State of IL #452152P54 10/09/19 11/01/21 5.000%1.870%500,023 500,000 12,249
Brownsville TX #16405ST9 12/19/19 02/15/22 2.050%2.000%555,070 557,747 2,244
Laredo TX Waterworks #517039VW0 12/19/19 03/01/24 2.230%2.230%455,000 469,860 1,635
Oakland Univ Mich #673588HJ1 04/29/20 03/01/24 5.000%1.650%317,472 325,816 2,458
Philadelphia PA GO Ref #717813SW0 05/05/20 08/01/22 5.000%1.820%399,241 404,024 4,672
Maryland St DOT #574204WG4 05/06/20 06/15/22 4.350%1.200%265,111 266,685 4,156
University of CA #91412HFK4 07/16/20 05/15/23 0.628%0.628%25,000 25,083 72
New Jersey St #646039UD7 09/20/20 06/01/22 5.000%0.600%487,175 487,645 9,830
Rio Rancho NM #767175HM7 10/14/2020 5/15/2022 5.000%0.350%189,644 189,753 4,240
Cook, Kane, Lake, & McHenry #216181GL5 10/29/2020 12/15/2022 4.000%0.300%1,067,431 1,068,880 41,220
Miami-Dade Cnty #59333NN90 11/16/2020 12/15/2022 0.375%0.430%734,426 734,059 214
Hamilton NY #407741MC8 1/21/2021 5/1/2023 1.000%0.550%206,380 205,681 1,014
Southern Cal Pub Pwr #84247PHZ7 1/25/2021 4/1/2024 3.608%0.500%1,082,367 1,069,650 11,826
Hillsborough Cnty FL #43232VV3 3/11/2021 7/1/2024 1.815%0.770%513,796 508,255 2,949
Port Auth of NY and NJ #73358WAH7 4/15/2021 12/1/2024 5.859%0.600%580,330 573,390 12,044
City of Atlanta GA Water #047870SG6 4/19/2021 11/1/2024 0.616%0.500%250,864 247,483 753
West Contra Costa Cal Uni #9523474U3 6/17/2021 8/1/2024 0.575%0.575%500,000 496,205 1,062
New York NY City 10/7/2021 11/1/2024 0.450%0.620%711,383 703,882 644
Total Municipal Bonds $9,342,037 $9,339,793 $120,018
Corporate Bonds:
Citigroup #172967LC3 04/01/19 12/08/21 2.900%2.754%$1,000,235 $1,000,456 $10,955
JP Morgan #48128BAB7 09/30/19 01/15/23 2.972%2.337%1,007,436 1,005,227 8,751
American Express #025816CD9 05/05/20 05/20/22 2.750%1.290%504,051 505,569 6,006
PNC Bank #69349LAK4 12/7/2020 1/30/2023 2.950%0.457%1,051,560 1,048,224 7,523
Wells Fargo #94974BFJ4 12/7/2020 2/13/2023 3.450%0.480%1,442,620 1,439,015 10,257
Comerica Bank #200340AS6 12/23/2020 7/31/2023 3.700%0.500%527,826 524,305 4,625
Bank of America #06048WM23 5/14/2021 5/14/2024 0.650%0.650%915,000 905,532 1,239
Goldman Sachs #38141GXE9 7/27/2021 2/20/2024 3.625%0.693%640,155 634,548 4,229
Goldman Sachs #38150AGU3 7/28/2021 7/28/2023 0.550%0.550%655,000 651,721 931
Morgan Stanley #61746BDQ6 7/28/2021 4/29/2024 3.875%0.547%1,082,327 1,067,877 215
Total Corporate Bonds $8,826,210 $8,782,474 $54,731
Government & Agency Obligations:
*Government National Mtg Assn #38379UEM4 02/29/16 02/16/51 2.300%2.245%$187,761 $176,193 $584
*Government National Mtg Assn #38381WV96 08/06/19 07/20/54 2.250%2.293%224,826 231,110 283
*Government National Mtg Assn #38380BNV3 12/05/19 06/20/46 2.000%2.112%375,455 383,696 500
Federal Home Loan Bank #3130AMVU3 06/29/21 06/29/26 0.500%0.500%500,000 495,255 833
Total Government & Agency Obligations:$1,288,042 $1,286,254 $2,200
Certificates of Deposit:
State Bk India NY #8562846A7 01/26/17 01/26/22 2.250%2.250%$245,000 $246,314 $1,463
Wells Fargo #949495AN5 01/17/20 01/18/22 1.800%1.800%245,000 245,938 181
Bank Leumi #063248KQ0 03/31/20 03/31/22 1.250%1.250%245,000 246,203 255
Capital One Natl Assn #14042TCZ8 04/01/20 04/01/22 1.350%1.350%245,000 246,315 262
Synchrony Bank #87164WZN1 04/03/20 04/04/22 1.350%1.350%245,000 246,340 244
Goldman Sachs 38149MXG3 07/28/21 07/29/24 0.550%0.550%245,000 244,112 348
Sallie Mae #795451AD5 07/28/21 07/29/24 0.600%0.600%245,000 244,446 380
Texas Exchange Bk #88241TLS7 07/30/21 07/30/24 0.500%0.500%245,000 243,751 102
Toyota Financial #89235MLF6 08/05/21 8/5/2024 0.550%0.550%245,000 244,072 318
UBS Bank #90348JT42 09/22/21 9/23/2024 0.650%0.650%245,000 244,481 33
Total Certificates of Deposits $2,450,000 $2,451,972 $3,586
Total J.P.Morgan Securities $21,906,289 $21,860,493 $180,535
*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
October 31, 2021
Cash & Investments by Fund - Total $47.4 million
Cash & Investments by Type - Total $47.4 million
Checking
Illinois Funds
Certificates of Deposit
Municipal Bonds
Corporate Bonds
Government & Agency Obligations
Accrued Interest
General Corporate
60.6%
Hotel/Motel Tax
4.7%Motor Fuel Tax
2.3%
Infrastructure
15.5%
Promenade TIF
0.6%
Water
11.5%
Sports Core
1.6%
Golf Surcharge
0.6%
Self-Insurance
0.3%
Garage
0.7%
Equipment
Replacement
1.7%
Checking, $1.4
Illinois Funds, $23.9
Certificates of Deposit,
$2.5
Municipal Bonds, $9.3
Corporate Bonds, $8.8
Government & Agency
Obligations, $1.3
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)22,206,580$ 17,555,760$ 4,650,820$ 895,570$
Main operating fund of the Village.
Hotel Fund (Major Fund)598,065$ 2,957,053$ (2,358,988)$ (3,097,855)$
Collects and spends resources from the
3% hotel/motel tax.
Motor Fuel Tax Fund 426,916$ -$ 426,916$ (881,325)$
Collects and spends resources from the
State motor fuel tax.
Infrastructure Fund (Major Fund)7,930,668$ 7,979,632$ (48,964)$ (1,084,055)$
Accounts for construction and maintenance of
roadways, drainage, and safety path systems.
Promenade TIF Fund (Major Fund)481,832$ 485,575$ (3,743)$ (6,575)$
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)9,657,546$ 10,419,930$ (762,384)$ (4,303,895)$
Collects user fees for the distribution of water
and maintenance of infrastructure.
Sports Core Fund (Major Fund)3,798,013$ 3,110,205$ 687,808$ (126,990)$
Accounts for revenues and expenses relating
to administration, programs, food and beverage
operations, and golf course.
Golf Surcharge Fund 138,614$ -$ 138,614$ (89,170)$
Accounts for the collection of the $3 per round
golf surcharge.
Internal Service Funds
Self Insurance Fund 3,271,084$ 2,968,732$ 302,352$ 9,745$
Accounts for the Village's health insurance costs
and the related contributions from the Village,
employees, retirees, and other agencies.
Garage Fund 508,906$ 472,049$ 36,857$ (124,580)$
Accounts for the maintenance of the Village's vehicle
fleet and the related departmental reimbursements.
Equipment Replacement Fund 326,672$ 230,901$ 95,771$ (433,345)$
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 October 31, 2021
Village of Oak Brook
Monthly Financial Report – Fund Narrative
For the Period Ending October 31, 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 October 2021 are $2,925,123, or 15.6%, higher than last October and
$1,820,770, or 9.2%, over budget to date. The main drivers for this are:
o Sales Tax revenue, the General
Fund’s largest revenue source, is
up $2,226,868 from last year
and $1,578,571 over budget.
October 2021 collections were
the highest October in the past
five years, as the Village has
seen encouraging economic
trends after the COVID-19
restrictions of 2020.
o Other Intergovernmental Tax
revenue is up $381,537 from last year and $551,947 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 $189,179 from last year and $241,034
under budget. We have seen a decrease in tax revenue as a result of remote working
over the last year. In addition, telecommunications tax revenue has been trending
downwards statewide as more people are switching to data only cellular plans.
o Licenses and Permits revenue is up $157,654 from last year, but $102,541 under 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.
Revenue is under budget due to the timing of building permits issued.
o Charges for Services revenue is up $478,669 from last year and $209,722over budget.
Revenue is up due to certain revenue sources being negatively affected by COVID-19 in
2020, such as elevator inspections and ambulance fees. Amounts can vary from year to
year due to the timing of billing requests.
o Investment Interest revenue is down $161,034 from last year and $100,257 under
budget. Investment return rates have dropped significantly since the beginning of the
COVID-19 pandemic.
Total expenditures through November 2021 are $1,382,424, or 7.3%, lower than last year and
$1,834,490, or 9.5%, under budget to date. The main drivers for this are:
o Personnel expenditures are down $996,692 from last year and $1,241,843 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 October 2021 are $94,428, or 18.7%, higher than last year and
$210,915, or 54.5%, over budget to date. The main drivers for this are:
o Hotel tax revenue is up $126,005 from last year and $215,314 over budget. Revenue
has come in higher than projections in 2021, but has yet to reach pre-pandemic levels.
This is projected to occur in late 2022 as the business travel industry recovers.
Total expenditures through October 2021 are $609,132, or 77.9%, lower than last year and
$242,025, or 58.3%, 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.
Expenditures have primarily been limited to minimal advertising efforts and DCVB dues.
Through October 2021, the Hotel Tax Fund has transferred $2,2,714,068 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 October 2021 are up $859,280, or 21.1%, from last year and $451,335,
or 10.1%, over budget. The main drivers for this are:
o Non-home rule sales tax revenue
is up $902,488 from last year
and $453,098 over budget.
October 2021 collections were
the highest October in the past
five years, as the Village has
seen encouraging economic
trends after the COVID-19
restrictions of 2020.
o Investment Interest revenue is
down $47,152 from last year and
$5,192 under budget. Investment return rates have dropped significantly since the
beginning of the COVID-19 pandemic.
Total expenditures through October 2021 are up $2,965,724, or 60.9%, from last year, but
$2,269,958, or 22.5%, under budget to date. The main drivers for this are:
o Personnel expenditures are up $24,126 from last year, but $35,204 under budget.
Personnel is up due to multiple retirements and the related unused accrual time
payouts.
o Operation and contract expenditures are up $244,785 from last year, but $281,734
under budget. Expenditures are under budget due to the timing of engineering and
other miscellaneous payments.
o Capital Outlay expenditures are up $2,677,023 from last year, but $1,924,437 under
budget. Expenditures are up due to project delays last year and general timing of work
performed.
Through October 2021, the Infrastructure Fund has received $2,714,068 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 October 2021 are up $17,731, or 3.8%, from last year and $18,057, or
3.9%, over budget. Sales tax receipts have come in higher than anticipated so far in 2021.
Total expenditures through October 2021 are down $48,628, or 9.1%, from last year, but
$15,225, or 3.2%, over budget to date. Expenditures are over budget due to more principal
being paid on the note than originally projected.
Water Fund
Total revenues through October 2021 are up $1,257,331, or 15.0%, from last year and $519,196,
or 5.7%, over budget. The main drivers for this are:
o Water sales revenue is up $513,039 from last year, but $208,305 under budget. Water
gallons sold has been less than projected so far this year. Revenue is up in 2021 due to
the business shutdowns in 2020.
o Water connection fees revenue is up $166,710 from last year and $103,870 over
budget. This is due to construction on the Hines property and Restoration Hardware.
o Miscellaneous revenue is up $661,528 from last year and $627,481 over budget. This is
due to a payment related to the sale of non-corporate water lines.
Total expenditures through October 2021 are up $2,799,900, or 38.6%, from last year, but
$3,022,335, or 23.1%, under budget. The main drivers for this are:
o Operation and contract expenditures are up $74,585 from last year, but $427,075 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 $2,633,269 from last year, but $2,604,682 under
budget. Many capital projects were delayed in 2020 due to the COVID-19 pandemic.
Capital projects have begun in 2021 as planned.
Sports Core Fund
Total revenues through October 2021 are up $1,067,498, or 39.6%, from last year and $441,188,
or 13.3%, over budget to date. The main drivers for this are:
o Memberships revenue is up $130,978 from last year and $117,365 over budget. Golf
memberships have seen a significant increase in 2021 to some of the highest levels.
o Greens Fees revenue is up $205,016 from last year and $289,679 over budget. The
course did not see much activity in early 2020 due to COVID-19 restrictions.
o Driving Range Fees revenue is up $78,666 from last year and $91,445 over budget. This
is due to the golf course being able to open early and stay open this season.
o Rentals revenue is up $312,793 from last year and $86,419 over budget. This is due to
events at the Bath & Tennis Clubhouse starting to return to normal in 2021 and an
increase in golf cart rentals from more rounds played in 2021.
o Food sales are up $119,849 from last year and $77,017 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 $141,726 from last year and $122,258 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 October 2021 are down $38,890, or 1.1%, from last year, but
$673,615, or 18.1%, under budget to date. The main drivers for this are:
o Personnel expenditures are down $31,370 from last year and $149,189 under budget.
Personnel is under budget due to the poolside grille operations and swim team not
occurring in 2021. In addition, the Sports Core has had difficultly filling open seasonal
positions this season.
o Operation and contractual expenditures are up $84,643 from last year, but $133,985
under budget. Expenditures are up due to a full golf season in 2021 compared to last
year. Expenditures are under budget due to the cancellation of the Taste of Oak Brook
event.
o Capital outlay expenditures are down $230,231 from last year and $477,373 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.
10/31/21 10/31/21
10/31/20 10/31/21 YTD % of YTD 2021 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 9,199,893$ 11,426,761$ 9,848,190$ 116.0%11,860,995$ 2,226,868$
Other Intergovernmental Tax*1,337,410 1,718,947 1,167,000 147.3%1,320,600 381,537
Telecommunications/Utility Tax 4,991,145 4,801,966 5,043,000 95.2%5,995,000 (189,179)
Grants 22,285 41,765 15,100 276.6%15,100 19,480
Licenses and Permits 1,573,075 1,730,729 1,833,270 94.4%2,180,360 157,654
Charges for Services 777,023 1,255,692 1,045,970 120.1%1,293,540 478,669
Fines and Penalties 136,041 121,942 150,450 81.1%180,500 (14,099)
Administrative Towing Fees 15,778 23,156 18,350 126.2%22,000 7,378
Investment Interest 310,777 149,743 250,000 59.9%300,000 (161,034)
Franchise Fees 105,921 109,738 151,500 72.4%202,000 3,817
Miscellaneous Income 317,379 331,411 368,250 90.0%448,280 14,032
Total Operating Revenues 18,786,727$ 21,711,850$ 19,891,080$ 109.2%23,818,375$ 2,925,123$
OPERATING EXPENDITURES
Personnel 15,230,619$ 14,233,927$ 15,475,770$ 92.0%18,842,080$ (996,692)$
Materials and Supplies 384,560 335,010 473,530 70.7%551,030 (49,550)
Operation and Contract 3,068,638 2,686,132 2,970,735 90.4%3,397,210 (382,506)
Other Expenditures 6,547 8,599 10,000 86.0%10,000 2,052
Capital Outlay 159,580 203,852 371,975 54.8%452,300 44,272
Total Operating Expenditures 18,849,944$ 17,467,520$ 19,302,010$ 90.5%23,252,620$ (1,382,424)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES (63,217)$ 4,244,330$ 589,070$ 565,755$ 4,307,547$
INTERFUND TRANSACTIONS
Transfers Out (326,369)$ -$ (100,000)$ 0.0%(100,000)$ 326,369$
Reimbursements From Other Funds 521,990 494,730 494,750 100.0%593,685 (27,260)
Reimbursements To Other Funds (116,470) (88,240) (88,250) 100.0%(105,885) 28,230
Total Interfund Transactions 79,151$ 406,490$ 306,500$ 132.6%387,800$ 327,339$
NET FUND INCREASE (DECREASE)15,934$ 4,650,820$ 895,570$ 953,555$ 4,634,886$
*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 October 31, 2021
Total Total
Revenues Expenditures
10/31/21 Actual 21,711,850$ 17,467,520$
10/31/20 Actual 18,786,727$ 18,849,944$
% Change From Last Year 15.6%-7.3%
Major Revenues
Other Telecom/Utility Licenses &Charges for
Sales Tax Intergov. Tax Tax Permits Services
10/31/21 Actual 11,426,761$ 1,718,947$ 4,801,966$ 1,730,729$ 1,255,692$
10/31/20 Actual $ 9,199,893 $ 1,337,410 $ 4,991,145 $ 1,573,075 $ 777,023
% Change From Last Year 24.2%28.5%-3.8%10.0%61.6%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
10/31/21 Actual 14,233,927$ 335,010$ 2,686,132$ 8,599$ 203,852$
10/31/20 Actual 15,230,619$ 384,560$ 3,068,638$ 6,547$ 159,580$
% Change From Last Year -6.5%-12.9%-12.5%31.3%27.7%
Five Year Trend
Expenditures by Department
10/31/20 10/31/21 10/31/21 10/31/21 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Department Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 1,720,907$ 1,930,457$ 2,046,240$ 94.3%2,498,625$ 209,550$
Financial Services 628,523 616,093 653,425 94.3%770,360 (12,430)
Public Works 666,642 682,522 791,015 86.3%948,860 15,880
Engineering & Capital Projects 53,528 22,548 189,000 11.9%209,000 (30,980)
Library 703,145 737,413 812,960 90.7%943,405 34,268
Police 7,492,340 6,966,381 7,701,975 90.4%9,213,585 (525,959)
Fire 6,735,012 5,731,069 6,205,845 92.3%7,576,045 (1,003,943)
Development Services 849,847 781,037 901,550 86.6%1,092,740 (68,810)
Total Expenditures 18,849,944$ 17,467,520$ 19,302,010$ 90.5%23,252,620$ (1,382,424)$
Five Year Trend
For the Period Ending October 31, 2021
General Fund - Five Year Trend
Village of Oak Brook
Revenues Expenditures
10/31/21 10/31/21
10/31/20 10/31/21 YTD % of YTD 2021 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Hotel Tax 439,109$ 565,114$ 349,800$ 161.6%414,000$ 126,005$
Investment Interest 60,361 27,679 33,350 83.0%40,000 (32,682)
Loan Interest 4,167 4,000 4,000 100.0%8,000 (167)
Miscellaneous - 1,272 - N/A - 1,272
Total Operating Revenues 503,637$ 598,065$ 387,150$ 154.5%462,000$ 94,428$
EXPENDITURES
Operation and Contract 308,804$ 170,265$ 164,940$ 103.2%193,945$ (138,539)$
Capital Outlay 473,243 2,650 250,000 1.1%250,000 (470,593)
Total Expenditures 782,047$ 172,915$ 414,940$ 41.7%443,945$ (609,132)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES (278,410)$ 425,150$ (27,790)$ -1529.9%18,055$ 703,560$
INTERFUND TRANSACTIONS
Transfer Out -$ (2,714,068)$ (3,000,000)$ 90.5%(100,000)$ (2,714,068)$
Reimbursements to Other Funds (62,260) (70,070) (70,065) 100.0%(84,085) (7,810)
Total Interfund Transactions (62,260)$ (2,784,138)$ (3,070,065)$ 90.7%(184,085)$ (2,721,878)$
NET FUND INCREASE (DECREASE)(340,670)$ (2,358,988)$ (3,097,855)$ (166,030)$ (2,018,318)$
Note - Expenditures are recorded in program 171.
Village of Oak Brook
Hotel Tax Fund Financial Update
For the Period Ending October 31, 2021
Total Total
Revenues Expenditures
10/31/21 Actual $ 598,065 172,915$
10/31/20 Actual $ 503,637 782,047$
% Change From Last Year 18.7%-77.9%
Major Revenues Investment
Hotel Tax Interest Loan Interest Miscellaneous
10/31/21 Actual $ 565,114 $ 27,679 4,000$ 1,272$
10/31/20 Actual $ 439,109 $ 60,361 4,167$ -$
% Change From Last Year 28.7%-54.1%-4.0%N/A
Five Year Trend
Major Expenditures Operation &
Contractual Capital Outlay
10/31/21 Actual 170,265$ 2,650$
10/31/20 Actual 308,804$ 473,243$
% Change From Last Year -44.9%-99.4%
Five Year Trend
Village of Oak Brook
Hotel Tax Fund - Major Sources Five Year Trend
For the Period Ending October 31, 2021
Five Year Trend
Revenues Expenditures
10/31/21 10/31/21
10/31/20 10/31/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 4,005,135$ 4,907,623$ 4,454,525$ 110.2%5,333,500$ 902,488$
Charges for Services 335 - 850 0.0%1,000 (335)
Investment Interest 75,310 28,158 33,350 84.4%40,000 (47,152)
Miscellaneous - 4,279 - N/A - 4,279
Total Operating Revenues 4,080,780$ 4,940,060$ 4,488,725$ 110.1%5,374,500$ 859,280$
OPERATING EXPENDITURES
Personnel 1,058,545$ 1,082,671$ 1,117,875$ 96.9%1,386,115$ 24,126$
Materials and Supplies 134,712 154,502 182,785 84.5%245,660 19,790
Operation and Contract 1,077,501 1,322,286 1,604,020 82.4%1,892,905 244,785
Capital Outlay 2,596,230 5,273,253 7,197,690 73.3%8,956,170 2,677,023
Total Operating Expenditures 4,866,988$ 7,832,712$ 10,102,370$ 77.5%12,480,850$ 2,965,724$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES (786,208)$ (2,892,652)$ (5,613,645)$ 51.5%(7,106,350)$ (2,106,444)$
INTERFUND TRANSACTIONS
Transfers In 666,289$ 2,714,068$ 4,400,000$ 61.7%1,400,000$ 2,047,779$
Reimbursements From Other Funds 299,480 276,540 276,550 100.0%331,840 (22,940)
Reimbursements To Other Funds (135,250) (146,920) (146,960) 100.0%(176,300) (11,670)
Total Interfund Transactions 830,519$ 2,843,688$ 4,529,590$ 62.8%1,555,540$ 2,013,169$
NET FUND INCREASE (DECREASE)44,311$ (48,964)$ (1,084,055)$ (5,550,810)$ (93,275)$
Village of Oak Brook
Infrastructure Fund Financial Update
For the Period Ending October 31, 2021
Total Total
Revenues Expenditures
10/31/21 Actual $ 4,940,060 7,832,712$
10/31/20 Actual $ 4,080,780 4,866,988$
% Change From Last Year 21.1%60.9%
Major Revenues
Sales Tax
Charges for
Services
Investment
Interest Miscellaneous
10/31/21 Actual $ 4,907,623 $ - $ 28,158 $ 4,279
10/31/20 Actual $ 4,005,135 $ 335 $ 75,310 $ -
% Change From Last Year 22.5%-100.0%-62.6%N/A
Five Year Trend
Major Expenditures Materials &Operation &
Personnel Supplies Contractual Capital Outlay
10/31/21 Actual 1,082,671$ 154,502$ 1,322,286$ 5,273,253$
10/31/20 Actual 1,058,545$ 134,712$ 1,077,501$ 2,596,230$
% Change From Last Year 2.3%14.7%22.7%103.1%
Five Year Trend
Expenditures by Department
10/31/20 10/31/21 10/31/21 10/31/21 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 109,993$ 121,253$ 128,795$ 94.1%157,640$ 11,260$
Public Works 3,467,539 1,961,546 2,175,245 90.2%2,789,580 (1,505,993)
Engineering & Capital Projects 1,289,456 5,749,913 7,798,330 73.7%9,709,930 4,460,457
Total Expenditures 4,866,988$ 7,832,712$ 10,102,370$ 77.5%12,657,150$ 2,965,724$
Five Year Trend
Village of Oak Brook
Infrastructure Fund - Major Sources Five Year Trend
For the Period Ending October 31, 2021
Revenues Expenditures
10/31/21 10/31/21
10/31/20 10/31/21 YTD % of YTD 2021 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 49,048$ 73,335$ 62,925$ 116.5%75,000$ 24,287$
Real Estate Tax 414,544 408,456 400,000 102.1%400,000 (6,088)
Investment Interest 509 41 850 4.8%1,000 (468)
Total Operating Revenues 464,101$ 481,832$ 463,775$ 103.9%476,000$ 17,731$
EXPENDITURES
Operation and Contract 4,303$ 4,075$ 3,850$ 105.8%3,850$ (228)$
Other Expenditures 529,900 481,500 466,500 103.2%466,500 (48,400)
Total Expenditures 534,203$ 485,575$ 470,350$ 103.2%470,350$ (48,628)$
NET FUND INCREASE (DECREASE)(70,102)$ (3,743)$ (6,575)$ 5,650$ 66,359$
Note - Expenditures are recorded in program 283.
Village of Oak Brook
Promenade TIF Fund Financial Update
For the Period Ending October 31, 2021
Total Total
Revenues Expenditures
10/31/21 Actual $ 481,832 485,575$
10/31/20 Actual $ 464,101 534,203$
% Change From Last Year 3.8%-9.1%
Major Revenues Real Estate Investment
Sales Tax Tax Interest
10/31/21 Actual 73,335$ $ 408,456 $ 41
10/31/20 Actual 49,048$ $ 414,544 $ 509
% Change From Last Year 49.5%-1.5%-91.9%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures
10/31/21 Actual 4,075$ 481,500$
10/31/20 Actual 4,303$ 529,900$
% Change From Last Year -5.3%-9.1%
Five Year Trend
Village of Oak Brook
Promenade TIF Fund - Major Sources Five Year Trend
For the Period Ending October 31, 2021
Five Year Trend
Revenues Expenditures
10/31/21 10/31/21
10/31/20 10/31/21 YTD % of YTD 2021 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Plan Review Fees 825$ 525$ 850$ 61.8%1,000$ (300)$
Building/Inspection Fees 5,662 2,925 5,850 50.0%7,000 (2,737)
Water Sales 8,168,656 8,681,695 8,890,000 97.7%10,597,000 513,039
Unmetered Sales 78,456 43,028 29,150 147.6%35,000 (35,428)
Water Connection Fees 20,510 187,220 83,350 224.6%100,000 166,710
Meter Charges 9,157 7,116 12,500 56.9%15,000 (2,041)
Special Services 12,657 13,333 12,500 106.7%25,000 676
Investment Interest 84,189 40,073 50,000 80.1%60,000 (44,116)
Miscellaneous 20,103 681,631 54,150 1258.8%65,000 661,528
Total Operating Revenues 8,400,215$ 9,657,546$ 9,138,350$ 105.7%10,905,000$ 1,257,331$
OPERATING EXPENDITURES
Personnel 633,843$ 642,851$ 685,290$ 93.8%842,235$ 9,008$
Materials and Supplies 33,193 116,231 64,370 180.6%75,780 83,038
Operation and Contract 3,991,365 4,065,950 4,493,025 90.5%5,379,925 74,585
Capital Outlay 2,586,209 5,219,478 7,824,160 66.7%8,103,750 2,633,269
Total Expenditures 7,244,610$ 10,044,510$ 13,066,845$ 76.9%14,401,690$ 2,799,900$
Surplus (Deficit) of Revenues Over
Expenditures 1,155,605$ (386,964)$ (3,928,495)$ 9.9%(3,496,690)$ (1,542,569)$
INTERFUND TRANSACTIONS
Reimbursements To Other Funds (439,010)$ (375,420)$ (375,400)$ 100.0%(450,500)$ 63,590$
Total Interfund Transactions (439,010)$ (375,420)$ (375,400)$ 100.0%(450,500)$ 63,590$
Fund Increase/(Decrease) - Budgetary Basis 716,595$ (762,384)$ (4,303,895)$ 17.7%(3,947,190)$ (1,478,979)$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay 2,586,209$ 5,219,478$
Depreciation Expense (457,253) (479,167)
IMRF Pension Expense (34,578) (37,500)
OPEB Expense 23,036 (25,000)
Total GAAP Adjustments 2,117,415$ 4,677,811$
Fund Increase/(Decrease) - GAAP Basis 2,834,010$ 3,915,427$
*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 October 31, 2021
Total Total
Revenues Expenditures
10/31/21 Actual $ 9,657,546 10,044,510$
10/31/20 Actual $ 8,400,215 7,244,610$
% Change From Last Year 15.0%38.6%
Unmetered Water
Water Sales Sales Connection Fees Meter Charges Miscellaneous
10/31/21 Actual $ 8,681,695 $ 43,028 $ 187,220 $ 7,116 $ 681,631
10/31/20 Actual $ 8,168,656 $ 78,456 $ 20,510 $ 9,157 $ 20,103
% Change From Last Year 6.3%-45.2%812.8%-22.3%3290.7%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
10/31/21 Actual 642,851$ 116,231$ 4,065,950$ -$ 5,219,478$
10/31/20 Actual 633,843$ 33,193$ 3,991,365$ -$ 2,586,209$
% Change From Last Year 1.4%250.2%1.9%0.0%101.8%
Five Year Trend
Expenditures by Department
10/31/20 10/31/21 10/31/21 10/31/21 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Public Works 4,689,659$ 4,759,938$ 5,259,345$ 90.5%6,317,940$ 70,279$
Engineering & Capital Projects 2,554,951 5,284,572 7,807,500 67.7%8,083,750 2,729,621
Total Expenditures 7,244,610$ 10,044,510$ 13,066,845$ 76.9%14,401,690$ 2,799,900$
Five Year Trend
Village of Oak Brook
Water Fund - Major Sources Five Year Trend
For the Period Ending October 31, 2021
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Sports Core Fund Consolidated Presentation
For the Period Ending October 31, 2021
10/31/21 10/31/21
10/31/21 YTD % of YTD 2021 10/31/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 -$ -$ -$ 355,865$ 355,865$ 238,500$ 149.2%238,500$ 224,887$ 130,978$
Greens Fees - - - 1,252,179 1,252,179 962,500 130.1%985,000 1,047,163 205,016
Pro Shop Sales - - - 222,939 222,939 200,500 111.2%207,000 168,377 54,562
Golf Lessons - - - 50,140 50,140 45,000 111.4%45,000 41,580 8,560
Driving Range Fees - - - 341,445 341,445 250,000 136.6%250,000 262,779 78,666
Rentals - 105,500 181,719 481,475 768,694 682,275 112.7%761,000 455,901 312,793
Programs/User Fees - - - - - 31,500 0.0%31,500 - -
Food Sales - - - 272,117 272,117 195,100 139.5%207,500 152,268 119,849
Beverage Sales - - - 479,258 479,258 357,000 134.2%382,000 337,532 141,726
Taste of Oak Brook - - - - - 120,000 0.0%120,000 - -
Grants - - - - - 233,600 0.0%233,600 - -
Other Revenue 9,505 - - 12,531 22,036 7,510 293.4%7,700 6,688 15,348
Total Operating Revenues 9,505$ 105,500$ 181,719$ 3,467,949$ 3,764,673$ 3,323,485$ 113.3%3,468,800$ 2,697,175$ 1,067,498$
OPERATING EXPENDITURES
Personnel 16,251$ -$ 100,453$ 1,141,177$ 1,257,881$ 1,407,070$ 89.4%1,597,610$ 1,289,251$ (31,370)$
Materials & Supplies 32,561 - 5,643 622,268 660,472 612,540 107.8%628,450 517,404 143,068
Operational & Contractual 96,740 9,186 61,425 324,084 491,435 625,420 78.6%663,035 406,792 84,643
Other - - - - - (39,000) 0.0%(39,000) - -
Capital 269,301 232,675 4,382 141,649 648,007 1,125,380 57.6%1,125,380 878,238 (230,231)
Total Operating Expenditures 414,853$ 241,861$ 171,903$ 2,229,178$ 3,057,795$ 3,731,410$ 81.9%3,975,475$ 3,091,685$ (33,890)$
B&T Administration Overhead Allocation*116,176$ -$ (116,176)$ -$ -$ -$ 0.0%-$ -$ -$
Operating Revenues Over (Under) Expenditures (289,172)$ (136,361)$ (106,360)$ 1,238,771$ 706,878$ (407,925)$ -173.3%(506,675)$ (394,510)$ 1,101,388$
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 26,670 - - - 26,670 26,675 100.0%32,000 20,000 6,670
Reimbursement From Water Fund 6,670 - - - 6,670 6,675 99.9%8,000 6,670 -
Reimbursement To General Fund (13,100) - - (39,310) (52,410) (52,415) 100.0%(62,900) (47,040) (5,370)
Total Interfund Transactions 20,240$ -$ -$ (39,310)$ (19,070)$ 280,935$ -6.8%277,100$ 629,372$ (648,442)$
Total Revenues Over (Under) Expenditures - Budgetary Basis (268,932)$ (136,361)$ (106,360)$ 1,199,461$ 687,808$ (126,990)$ (229,575)$ 234,862$ 452,946$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 269,301$ 232,675$ 4,382$ 141,649$ 648,007$ 878,238$
Depreciation Expense (140,189) (1,404) (50,000) (205,250) (396,843) (324,235)
IMRF Pension Expense (1,708) - (2,500) (20,417) (24,625) (21,795)
OPEB Expense - - (2,500) (23,333) (25,833) (21,038)
Total GAAP Adjustments 127,404$ 231,271$ (50,618)$ (107,351)$ 200,705$ 511,170$
Fund Increase/(Decrease) - GAAP Basis (141,529)$ 94,910$ (156,978)$ 1,092,110$ 888,513$ 746,032$
*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
10/31/21 Actual $ 3,764,673 3,057,795$
10/31/20 Actual $ 2,697,175 3,091,685$
% Change From Last Year 39.6%-1.1%
Driving Program/
Memberships Greens Fees Range Fees Rentals User Fees
10/31/21 Actual $ 355,865 $ 1,252,179 $ 341,445 $ 768,694 -$
10/31/20 Actual $ 224,887 $ 1,047,163 $ 262,779 $ 455,901 -$
% Change From Last Year 58.2%19.6%29.9%68.6%0.0%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
10/31/21 Actual 1,257,881$ 660,472$ 491,435$ -$ 648,007$
10/31/20 Actual 1,289,251$ 517,404$ 406,792$ -$ 878,238$
% Change From Last Year -2.4%27.7%20.8%0.0%-26.2%
Five Year Trend
Revenues by Department 10/31/20 10/31/21 10/31/21 10/31/21 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Operations 1,680$ 9,505$ 325,710$ 2.9%325,800$ 7,825$
Open Field Operations 97,540 105,500 225,000 46.9%230,000 7,960
B&T Clubhouse Operations 20,402 181,719 202,000 90.0%267,000 161,317
Golf Club 2,577,553 3,467,949 2,570,775 134.9%2,646,000 890,396
Total Revenues 2,697,175$ 3,764,673$ 3,323,485$ 113.3%3,468,800$ 1,067,498$
Expenditures by Department 10/31/20 10/31/21 10/31/21 % of YTD 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Operations 504,058$ 414,853$ 769,775$ 53.9%780,740$ (89,205)$
Open Field Operations 33,662$ 241,861$ 357,650$ 67.6%358,910$ 208,199$
B&T Clubhouse Operations 176,980 171,903 225,345 76.3%262,635 (5,077)
Golf Club 2,376,985 2,229,178 2,378,640 93.7%2,573,190 (147,807)
Total Expenditures 3,091,685$ 3,057,795$ 3,731,410$ 81.9%3,975,475$ (33,890)$
Five Year Trend
Village of Oak Brook
Sports Core Fund - Major Sources Five Year Trend
For the Period Ending October 31, 2021
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Club Recreation Operations
For the Period Ending October 31, 2021 10/31/21 10/31/21
822 10/31/21 YTD % of YTD 2021 10/31/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 - - - - - 38,000 0.0%38,000 - -
Beverage Sales - - - - - 22,000 0.0%22,000 - -
Grants - - - - - 233,600 0.0%233,600 - -
Other Revenue 9,505 - - - 9,505 610 1558.2%700 1,481 8,024
Total Operating Revenues 9,505$ -$ -$ -$ 9,505$ 325,710$ 2.9%325,800$ 1,680$ 7,825$
OPERATING EXPENDITURES
Personnel 16,251$ -$ -$ -$ 16,251$ 111,495$ 14.6%119,110$ 53,654$ (37,403)$
Materials & Supplies 593 27,799 2,460 1,709 32,561 37,050 87.9%37,250 3,723 28,838
Operational & Contractual 52,988 36,404 7,125 223 96,740 86,400 112.0%89,550 72,606 24,134
Capital 158,926 110,375 - - 269,301 534,830 50.4%534,830 374,075 (104,774)
Total Operating Expenditures 228,758$ 174,578$ 9,585$ 1,932$ 414,853$ 769,775$ 53.9%780,740$ 504,058$ (89,205)$
B&T Administration Overhead Allocation*232,352$ (83,647)$ (23,235)$ (9,294)$ 116,176$ 41,765$ 278.2%44,755$ 90,341$ 25,835$
Operating Revenues Over (Under) Expenditures 13,099$ (258,225)$ (32,820)$ (11,226)$ (289,172)$ (402,300)$ 71.9%(410,185)$ (412,037)$ 122,865$
INTERFUND TRANSACTIONS
Transfer From General Fund -$ -$ -$ -$ -$ 100,000$ 0.0%100,000$ 326,369$ (326,369)$
Reimbursement From Infrastructure Fund 26,670 - - - 26,670 26,675 100.0%32,000 20,000 6,670
Reimbursement From Water Fund 6,670 - - - 6,670 6,675 99.9%8,000 6,670 -
Reimbursement To General Fund (13,100) - - - (13,100) (13,100) 100.0%(15,725) (23,520) 10,420
Total Interfund Transactions 20,240$ -$ -$ -$ 20,240$ 120,250$ 16.8%124,275$ 329,519$ (309,279)$
Total Revenues Over (Under) Expenditures - Budgetary Basis 33,339$ (258,225)$ (32,820)$ (11,226)$ (268,932)$ (282,050)$ (285,910)$ (82,518)$ (186,414)$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 158,926$ 110,375$ -$ -$ 269,301$ 374,075$
Depreciation Expense (53,633) (83,333) (2,250) (973) (140,189) (76,756)
IMRF Pension Expense (1,667) - - (42) (1,708) (933)
Total GAAP Adjustments 103,627$ 27,042$ (2,250)$ (1,015)$ 127,404$ 296,387$
Fund Increase/(Decrease) - GAAP Basis 136,966$ (231,183)$ (35,070)$ (12,241)$ (141,529)$ 213,869$
*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 October 31, 2021 10/31/21 10/31/21
10/31/21 YTD % of YTD 2021 10/31/20 Difference
815 816 YTD Amended Amended Adopted YTD Prior
Polo Open Fields Total Budget Budget Budget Total Year
OPERATING REVENUES
Field Rentals -$ 25,500$ 25,500$ 25,000$ 102.0%30,000$ 22,540$ 2,960$
Range Rentals - 80,000 80,000 80,000 100.0%80,000 75,000 5,000
Taste of Oak Brook - - - 120,000 0.0%120,000 - -
Total Operating Revenues -$ 105,500$ 105,500$ 225,000$ 46.9%230,000$ 97,540$ 7,960$
OPERATING EXPENDITURES
Personnel -$ -$ -$ -$ 0.0%-$ -$ -$
Materials & Supplies - - - 400 0.0%500 119 (119)
Operational & Contractual - 9,186 9,186 189,200 4.9%190,360 24,122 (14,936)
Capital - 232,675 232,675 168,050 138.5%168,050 9,421 223,254
Total Operating Expenditures -$ 241,861$ 241,861$ 357,650$ 67.6%358,910$ 33,662$ 208,199$
Operating Revenues Over (Under) Expenditures -$ (136,361)$ (136,361)$ (132,650)$ 102.8%(128,910)$ 63,878$ (200,239)$
INTERFUND TRANSACTIONS
Transfer From Hotel Tax Fund -$ -$ -$ -$ 0.0%-$ -$ -$
Total Interfund Transactions -$ -$ -$ -$ 0.0%-$ -$ -$
Total Revenues Over (Under) Expenditures - Budgetary Basis -$ (136,361)$ (136,361)$ (132,650)$ (128,910)$ 63,878$ (200,239)$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay -$ 232,675$ 232,675$ 9,421$
Depreciation Expense - (1,404) (1,404) (1,404)
Total GAAP Adjustments -$ 231,271$ 231,271$ 8,017$
Fund Increase/(Decrease) - GAAP Basis -$ 94,910$ 94,910$ 71,895$
*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 October 31, 2021
10/31/21 10/31/21
821 YTD % of YTD 2021 10/31/20 Difference
B&T Amended Amended Adopted YTD Prior
Clubhouse Budget Budget Budget Total Year
OPERATING REVENUES
Rentals 181,719$ 202,000$ 90.0%267,000$ 20,402$ 161,317$
Total Operating Revenues 181,719$ 202,000$ 90.0%267,000$ 20,402$ 161,317$
OPERATING EXPENDITURES
Personnel 100,453$ 111,645$ 90.0%133,585$ 88,955$ 11,498$
Materials & Supplies 5,643 10,100 55.9%12,000 1,693 3,950
Operational & Contractual 61,425 94,100 65.3%107,550 50,117 11,308
Capital 4,382 9,500 46.1%9,500 36,215 (31,833)
Total Operating Expenditures 171,903$ 225,345$ 76.3%262,635$ 176,980$ (5,077)$
B&T Administration Overhead Allocation*(116,176)$ (41,765)$ 278.2%(44,755)$ (90,341)$ (25,835)$
Operating Revenues Over (Under) Expenditures (106,360)$ (65,110)$ 163.4%(40,390)$ (246,919)$ 140,559$
INTERFUND TRANSACTIONS
Transfer From General Fund -$ -$ 0.0%-$ -$ -$
Total Interfund Transactions -$ -$ 0.0%-$ -$ -$
Total Revenues Over (Under) Expenditures - Budgetary Basis (106,360)$ (65,110)$ (40,390)$ (246,919)$ 140,559$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 4,382$ 36,215$
Depreciation Expense (50,000) (50,463)
IMRF Pension Expense (2,500) (1,728)
OPEB Expense (2,500) (2,203)
Total GAAP Adjustments (50,618)$ (18,178)$
Fund Increase/(Decrease) - GAAP Basis (156,978)$ (265,097)$
*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 October 31, 2021
10/31/21 10/31/21
823 831 832 833 834 10/31/21 YTD % of YTD 2021 10/31/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 -$ 355,865$ -$ -$ -$ 355,865$ 238,500$ 149.2%238,500$ 224,688$ 131,177$
Greens Fees - 1,252,179 - - - 1,252,179 962,500 130.1%985,000 1,047,163 205,016
Pro Shop Sales - 222,939 - - - 222,939 200,500 111.2%207,000 168,377 54,562
Golf Lessons - - 50,140 - - 50,140 45,000 111.4%45,000 41,580 8,560
Driving Range Fees - - 341,445 - - 341,445 250,000 136.6%250,000 262,779 78,666
Rentals - 2,610 9,000 469,865 - 481,475 375,275 128.3%384,000 337,959 143,516
Food Sales 272,117 - - - - 272,117 157,100 173.2%169,500 152,268 119,849
Beverage Sales 479,258 - - - - 479,258 335,000 143.1%360,000 337,532 141,726
Other Revenue - 12,531 - - - 12,531 6,900 181.6%7,000 5,207 7,324
Total Operating Revenues 751,375$ 1,846,124$ 400,585$ 469,865$ -$ 3,467,949$ 2,570,775$ 134.9%2,646,000$ 2,577,553$ 890,396$
OPERATING EXPENDITURES
Personnel 218,939$ 462,871$ 77,695$ 41,540$ 340,132$ 1,141,177$ 1,183,930$ 96.4%1,344,915$ 1,146,642$ (5,465)$
Materials & Supplies 269,980 165,033 16,171 1,205 169,879 622,268 564,990 110.1%578,700 511,869 110,399
Operational & Contractual 4,632 233,564 799 56,738 28,351 324,084 255,720 126.7%275,575 259,947 64,137
Other - - - - - - (39,000) 0.0%(39,000) - -
Capital 3,339 17,772 - - 120,538 141,649 413,000 34.3%413,000 458,527 (316,878)
Total Operating Expenditures 496,890$ 879,240$ 94,665$ 99,483$ 658,900$ 2,229,178$ 2,378,640$ 93.7%2,573,190$ 2,376,985$ (147,807)$
Operating Revenues Over (Under) Expenditures 254,485$ 966,884$ 305,920$ 370,382$ (658,900)$ 1,238,771$ 192,135$ 644.7%72,810$ 200,568$ 1,038,203$
INTERFUND TRANSACTIONS
Transfer from Golf Surcharge -$ -$ -$ -$ -$ -$ 200,000$ 0.0%200,000$ 323,373$ (323,373)$
Reimbursement to General Fund - (39,310) - - - (39,310) (39,315) 100.0%(47,175) (23,520) (15,790)
Total Interfund Transactions -$ (39,310)$ -$ -$ -$ (39,310)$ 160,685$ -24.5%152,825$ 299,853$ (339,163)$
Total Revenues Over (Under) Expenditures - Budgetary Basis 254,485$ 927,574$ 305,920$ 370,382$ (658,900)$ 1,199,461$ 352,820$ 225,635$ 500,421$ 699,040$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay 3,339$ 17,772$ -$ -$ 120,538$ 141,649$ 458,527$
Depreciation Expense (833) (87,500) (1,917) (10,833) (104,167) (205,250) (195,613)
IMRF Pension Expense (2,083) (8,333) (833) - (9,167) (20,417) (19,135)
OPEB Expense (2,500) (12,500) - - (8,333) (23,333) (18,835)
Total GAAP Adjustments (2,078)$ (90,561)$ (2,750)$ (10,833)$ (1,129)$ (107,351)$ 224,945$
Fund Increase/(Decrease) - GAAP Basis 252,407$ 837,013$ 303,170$ 359,549$ (660,029)$ 1,092,110$ 725,366$
*Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.