11 - November 2021 Monthly Financial ReportVILLAGE
OAK BROOK
OF
MONTHLY FINANCIAL REPORTS
NOVEMBER 2021
ITEM 6.F
Cash and Investments by Fund:Total
Cash and Cash Pooled Cash and
Fund Equivalents Investments Investments % By Fund
General Corporate $16,968,700 $13,206,892 $30,175,592 61.2%
Hotel/Motel Tax 363,939 1,964,680 2,328,619 4.7%
Motor Fuel Tax 1,107,870 17,951 1,125,821 2.3%
Infrastructure 3,951,730 3,595,812 7,547,542 15.3%
Promenade TIF 271,901 - 271,901 0.6%
Water 2,267,902 3,343,503 5,611,405 11.4%
Sports Core 693,472 - 693,472 1.4%
Golf Surcharge 275,840 - 275,840 0.6%
Self-Insurance 152,840 - 152,840 0.3%
Garage 338,333 - 338,333 0.7%
Equipment Replacement 400,205 396,697 796,902 1.6%
Total $26,792,732 $22,525,535 $49,318,267 100.0%
Change in Cash and Investments by Fund :
Balance at Balance at Year-to-Date Year-to-Date
Fund January 1, 2021 November 30, 2021 Change ($)Change (%)
General Corporate $23,894,312 $30,175,592 $6,281,280 26.3%
Hotel/Motel Tax 4,567,176 2,328,619 (2,238,557)-49.0%
Motor Fuel Tax 673,455 1,125,821 452,366 67.2%
Infrastructure 7,480,975 7,547,542 66,567 0.9%
Promenade TIF 267,300 271,901 4,601 1.7%
Water 6,900,169 5,611,405 (1,288,764)-18.7%
Sports Core 114,133 693,472 579,339 507.6%
Golf Surcharge 132,593 275,840 143,247 108.0%
Self-Insurance - 152,840 152,840 N/A
Garage 298,348 338,333 39,985 13.4%
Equipment Replacement 696,392 796,902 100,510 14.4%
$45,024,853 $49,318,267 $4,293,414 9.5%
Book Bank/Market
Value Value
Cash and Cash Equivalents:
Pooled Checking $1,134,756 $2,427,787
Sports Core Checking 976,583 969,908
Pooled IPTIP 23,916,614 23,916,614
Water E-Pay IPTIP 764,779 721,052
$26,792,732 $28,035,361
Pooled Investments:
Investments-Municipal Bonds $9,831,112 $9,821,409
Investments-Corporate Bonds 8,813,829 8,732,805
Government & Agency Obligations 1,254,181 1,249,339
Certificates of Deposit 2,450,000 2,447,242
Accrued Interest 176,414 176,414
Total Pooled Investments $22,525,535 $22,427,209
Total Cash and Investments $49,318,267 $50,462,570
For November, total interest revenue is $18,110 and YTD is $269,090. The total investment yield for the portfolio is:
Pooled
Investments Illinois Funds Total
Last 12 months yield 1.22%0.04%0.66%
The weighted average yield of the current investment portfolio is 0.93%. The IL Funds November average daily rate was 0.028%.
Monthly Treasurer's Report
November 30, 2021
Monthly Treasurer's Report
November 2021
The table below lists the detail investment holdings at J.P. Morgan Securities as of 11/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%$501,092 $504,700 $1,090
Brownsville TX #16405ST9 12/19/19 02/15/22 2.050%2.000%555,047 556,948 3,192
Laredo TX Waterworks #517039VW0 12/19/19 03/01/24 2.230%2.230%455,000 469,028 2,480
Oakland Univ Mich #673588HJ1 04/29/20 03/01/24 5.000%1.650%316,679 324,659 3,688
Philadelphia PA GO Ref #717813SW0 05/05/20 08/01/22 5.000%1.820%398,221 402,503 6,297
Maryland St DOT #574204WG4 05/06/20 06/15/22 4.350%1.200%264,434 265,821 5,099
University of CA #91412HFK4 07/16/20 05/15/23 0.628%0.628%25,000 25,056 7
New Jersey St #646039UD7 09/20/20 06/01/22 5.000%0.600%485,439 485,968 11,809
Rio Rancho NM #767175HM7 10/14/2020 5/15/2022 5.000%0.350%188,928 189,029 385
Cook, Kane, Lake, & McHenry #216181GL5 10/29/2020 12/15/2022 4.000%0.300%1,064,281 1,065,734 44,637
Miami-Dade Cnty #59333NN90 11/16/2020 12/15/2022 0.375%0.430%734,460 733,457 444
Hamilton NY #407741MC8 1/21/2021 5/1/2023 1.000%0.550%206,304 205,461 159
Southern Cal Pub Pwr #84247PHZ7 1/25/2021 4/1/2024 3.608%0.500%1,079,812 1,066,480 14,833
Hillsborough Cnty FL #43232VV3 3/11/2021 7/1/2024 1.815%0.770%513,370 508,275 3,706
Port Auth of NY and NJ #73358WAH7 4/15/2021 12/1/2024 5.859%0.600%578,179 571,020 14,485
City of Atlanta GA Water #047870SG6 4/19/2021 11/1/2024 0.616%0.500%250,840 247,225 111
West Contra Costa Cal Uni #9523474U3 6/17/2021 8/1/2024 0.575%0.575%500,000 494,085 1,302
New York NY City #64971XA40 10/7/2021 11/1/2024 0.450%0.620%711,483 703,660 250
NY Urban Dev Corp #650036AR7 11/5/2021 3/15/2023 0.720%0.451%501,732 501,345 750
Colorado Brdg Enterprise #19633SAZ6 11/24/2021 12/31/2023 0.923%0.844%500,811 500,955 987
Total Municipal Bonds $9,831,112 $9,821,409 $115,711
Corporate Bonds:
JP Morgan #48128BAB7 09/30/19 01/15/23 2.972%2.337%1,006,922 1,002,737 11,228
American Express #025816CD9 05/05/20 05/20/22 2.750%1.290%503,447 504,545 277
PNC Bank #69349LAK4 12/7/2020 1/30/2023 2.950%0.457%1,049,452 1,044,976 10,030
Wells Fargo #94974BFJ4 12/7/2020 2/13/2023 3.450%0.480%1,439,200 1,433,232 14,253
Comerica Bank #200340AS6 12/23/2020 7/31/2023 3.700%0.500%526,504 521,908 6,167
Bank of America #06048WM23 5/14/2021 5/14/2024 0.650%0.650%915,000 904,212 248
Goldman Sachs #38141GXE9 7/27/2021 2/20/2024 3.625%0.693%638,712 632,036 6,042
Goldman Sachs #38150AGU3 7/28/2021 7/28/2023 0.550%0.550%655,000 626,841 1,231
Morgan Stanley #61746BDQ6 7/28/2021 4/29/2024 3.875%0.547%1,079,591 1,062,024 3,444
Citigroup #17329UEH0 11/18/2021 11/18/2024 1.000%1.149%1,000,000 1,000,294 333
Total Corporate Bonds $8,813,829 $8,732,805 $53,253
Government & Agency Obligations:
*Government National Mtg Assn #38379UEM4 02/29/16 02/16/51 2.300%2.245%$186,392 $174,701 $606
*Government National Mtg Assn #38381WV96 08/06/19 07/20/54 2.250%2.293%201,332 206,932 235
*Government National Mtg Assn #38380BNV3 12/05/19 06/20/46 2.000%2.112%366,457 372,990 481
Federal Home Loan Bank #3130AMVU3 06/29/21 06/29/26 0.500%0.500%500,000 494,716 1,042
Total Government & Agency Obligations:$1,254,181 $1,249,339 $2,363
Certificates of Deposit:
State Bk India NY #8562846A7 01/26/17 01/26/22 2.250%2.250%$245,000 $245,814 $1,922
Wells Fargo #949495AN5 01/17/20 01/18/22 1.800%1.800%245,000 245,539 174
Bank Leumi #063248KQ0 03/31/20 03/31/22 1.250%1.250%245,000 245,900 510
Capital One Natl Assn #14042TCZ8 04/01/20 04/01/22 1.350%1.350%245,000 245,990 538
Synchrony Bank #87164WZN1 04/03/20 04/04/22 1.350%1.350%245,000 246,014 519
Goldman Sachs 38149MXG3 07/28/21 07/29/24 0.550%0.550%245,000 243,569 460
Sallie Mae #795451AD5 07/28/21 07/29/24 0.600%0.600%245,000 243,892 502
Texas Exchange Bk #88241TLS7 07/30/21 07/30/24 0.500%0.500%245,000 243,235 -
Toyota Financial #89235MLF6 08/05/21 8/5/2024 0.550%0.550%245,000 243,512 430
UBS Bank #90348JT42 09/22/21 9/23/2024 0.650%0.650%245,000 243,777 30
Total Certificates of Deposits $2,450,000 $2,447,242 $5,087
Total J.P.Morgan Securities $22,349,122 $22,250,795 $176,414
*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
November 30, 2021
Cash & Investments by Fund - Total $49.3 million
Cash & Investments by Type - Total $49.3 million
Checking
Illinois Funds
Certificates of Deposit
Municipal Bonds
Corporate Bonds
Government & Agency Obligations
Accrued Interest
General Corporate
61.2%
Hotel/Motel Tax
4.7%Motor Fuel Tax
2.3%
Infrastructure
15.3%
Promenade TIF
0.6%
Water
11.4%
Sports Core
1.4%
Golf Surcharge
0.6%
Self-Insurance
0.3%
Garage
0.7%
Equipment
Replacement
1.6%
Checking, $2.1
Illinois Funds, $24.7
Certificates of Deposit,
$2.5
Municipal Bonds, $9.8
Corporate Bonds, $8.8
Government & Agency
Obligations, $1.3
Accrued Interest, $0.1
in millions
YTD YTD
Net Fund Budgeted
YTD YTD Increase Increase
Governmental Funds Revenues Expenditures (Decrease)(Decrease)
General Fund (Major Fund)25,124,773$ 19,149,440$ 5,975,333$ 1,138,915$
Main operating fund of the Village.
Hotel Fund (Major Fund)718,921$ 2,974,893$ (2,255,972)$ (3,082,925)$
Collects and spends resources from the
3% hotel/motel tax.
Motor Fuel Tax Fund 452,061$ -$ 452,061$ (857,075)$
Collects and spends resources from the
State motor fuel tax.
Infrastructure Fund (Major Fund)8,526,478$ 8,322,674$ 203,804$ (1,810,610)$
Accounts for construction and maintenance of
roadways, drainage, and safety path systems.
Promenade TIF Fund (Major Fund)490,176$ 485,575$ 4,601$ (415)$
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)11,322,372$ 11,674,432$ (352,060)$ (3,781,990)$
Collects user fees for the distribution of water
and maintenance of infrastructure.
Sports Core Fund (Major Fund)3,889,757$ 3,291,307$ 598,450$ (161,045)$
Accounts for revenues and expenses relating
to administration, programs, food and beverage
operations, and golf course.
Golf Surcharge Fund 143,247$ -$ 143,247$ (84,085)$
Accounts for the collection of the $3 per round
golf surcharge.
Internal Service Funds
Self Insurance Fund 3,598,780$ 3,310,585$ 288,195$ 18,020$
Accounts for the Village's health insurance costs
and the related contributions from the Village,
employees, retirees, and other agencies.
Garage Fund 559,751$ 491,771$ 67,980$ (135,560)$
Accounts for the maintenance of the Village's vehicle
fleet and the related departmental reimbursements.
Equipment Replacement Fund 354,471$ 250,477$ 103,994$ (442,315)$
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 November 30, 2021
Village of Oak Brook
Monthly Financial Report – Fund Narrative
For the Period Ending November 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 November 2021 are $1,616,115, or 7.0%, higher than last November and
$2,678,250, or 12.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,527,477 from last year
and $1,955,694 over budget.
November 2021 collections were
the highest November 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 $395,442 from last year and $582,584 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 $191,715 from last year and $252,975
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 down $1,091,209 from last year, but $370,550 over
budget. The decrease relates to a large building permit received in November 2020 that
resulted in revenue being near its highest levels seen.
o Charges for Services revenue is up $570,586 from last year and $234,366 over 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 $172,209 from last year and $114,660 under
budget. Investment return rates have dropped significantly since the beginning of the
COVID-19 pandemic.
Total expenditures through November 2021 are $1,428,297, or 7.0%, lower than last year and
$2,058,179, or 9.7%, under budget to date. The main drivers for this are:
o Personnel expenditures are down $1,022,757 from last year and $1,353,122 under
budget. The decrease is due to two payroll cycles in January 2021 vs. three payroll
cycles in January 2020, which resulted in one additional payroll for 2020. In addition,
personnel expenditures are under budget due to delays in full public safety pension
funding.
Hotel Tax Fund
Total revenues through November 2021 are $161,350, or 28.9%, higher than last year and
$295,336, or 69.7%, over budget to date. The main drivers for this are:
o Hotel tax revenue is up $208,020 from last year and $297,475 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 November 2021 are $649,730, or 78.0%, lower than last year and
$245,687, or 57.2%, 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 November 2021, the Hotel Tax Fund has transferred $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 November 2021 are up $957,402, or 21.0%, from last year and
$562,096, or 11.4%, over budget. The main drivers for this are:
o Non-home rule sales tax revenue
is up $1,001,421 from last year
and $564,444 over budget.
November 2021 collections were
the highest November 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,819 from last year and
$5,692 under budget. Investment return rates have dropped significantly since the
beginning of the COVID-19 pandemic.
Total expenditures through November 2021 are up $2,046,152, or 33.5%, from last year, but
$3,138,243, or 27.8%, under budget to date. The main drivers for this are:
o Personnel expenditures are up $9,211 from last year, but $76,983 under budget.
Personnel is up due to multiple retirements and the related unused accrual time
payouts.
o Operation and contract expenditures are up $221,234 from last year, but $330,913
under budget. Expenditures are under budget due to the timing of engineering and
other miscellaneous payments.
o Capital Outlay expenditures are up $1,792,861 from last year, but $2,667,766 under
budget. Expenditures are up due to project delays last year and general timing of work
performed.
Through November 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 November 2021 are up $19,614, or 4.2%, from last year and $20,241, or
4.3%, over budget. Sales tax receipts have come in higher than anticipated so far in 2021.
Total expenditures through November 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 November 2021 are up $1,528,607, or 15.6%, from last year and
$817,937, or 7.8%, over budget. The main drivers for this are:
o Water sales revenue is up $788,677 from last year and $100,250 over budget. Revenue
is up in 2021 due to the business shutdowns in 2020 and a rate increase.
o Water connection fees revenue is up $166,710 from last year and $97,145 over budget.
This is due to construction on the Hines property and Restoration Hardware.
o Miscellaneous revenue is up $667,792 from last year and $629,676 over budget. This is
due to a payment related to the sale of non-corporate water lines.
Total expenditures through November 2021 are up $3,005,899, or 36.4%, from last year, but
$2,612,015, or 28.8%, under budget. The main drivers for this are:
o Operation and contract expenditures are up $109,121 from last year, but $455,288
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,817,903 from last year, but $2,122,421 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 November 2021 are up $1,019,239, or 36.0%, from last year and
$426,063, or 12.4%, over budget to date. The main drivers for this are:
o Memberships revenue is up $129,178 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 $172,389 from last year and $299,165 over budget. The
course did not see much activity in early 2020 due to COVID-19 restrictions.
o Driving Range Fees revenue is up $82,324 from last year and $91,440 over budget. This
is due to the golf course being able to open early and stay open this season.
o Rentals revenue is up $310,416 from last year and $73,832 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 $114,745 from last year and $71,919 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 $132,485 from last year and $112,421 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 November 2021 are down $201,324, or 5.9%, from last year, but
$633,439, or 16.4%, under budget to date. The main drivers for this are:
o Personnel expenditures are down $44,728 from last year and $154,420 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 $99,836 from last year, but $118,392
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 $381,236 from last year and $454,883 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.
11/30/21 11/30/21
11/30/20 11/30/21 YTD % of YTD 2021 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 10,352,357$ 12,879,834$ 10,924,140$ 117.9%11,860,995$ 2,527,477$
Other Intergovernmental Tax*1,426,192 1,821,634 1,239,050 147.0%1,320,600 395,442
Telecommunications/Utility Tax 5,449,740 5,258,025 5,511,000 95.4%5,995,000 (191,715)
Grants 437,834 42,371 15,100 280.6%15,100 (395,463)
Licenses and Permits 3,462,554 2,371,345 2,000,795 118.5%2,180,360 (1,091,209)
Charges for Services 809,060 1,379,646 1,145,280 120.5%1,293,540 570,586
Fines and Penalties 183,346 131,563 165,495 79.5%180,500 (51,783)
Administrative Towing Fees 23,828 24,391 20,185 120.8%22,000 563
Investment Interest 332,549 160,340 275,000 58.3%300,000 (172,209)
Franchise Fees 151,877 159,960 202,000 79.2%202,000 8,083
Miscellaneous Income 335,118 351,461 404,275 86.9%448,280 16,343
Total Operating Revenues 22,964,455$ 24,580,570$ 21,902,320$ 112.2%23,818,375$ 1,616,115$
OPERATING EXPENDITURES
Personnel 16,596,335$ 15,573,578$ 16,926,700$ 92.0%18,842,080$ (1,022,757)$
Materials and Supplies 412,327 378,671 512,815 73.8%551,030 (33,656)
Operation and Contract 3,259,503 2,873,209 3,218,865 89.3%3,397,210 (386,294)
Other Expenditures 6,547 8,599 10,000 86.0%10,000 2,052
Capital Outlay 205,961 218,319 442,175 49.4%452,300 12,358
Total Operating Expenditures 20,480,673$ 19,052,376$ 21,110,555$ 90.3%23,252,620$ (1,428,297)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 2,483,782$ 5,528,194$ 791,765$ 565,755$ 3,044,412$
INTERFUND TRANSACTIONS
Transfers Out (326,369) -$ (100,000)$ 0.0%(100,000)$ 326,369$
Reimbursements From Other Funds 574,189 544,203 544,225 100.0%593,685 (29,986)
Reimbursements To Other Funds (128,117) (97,064) (97,075) 100.0%(105,885) 31,053
Total Interfund Transactions 119,703$ 447,139$ 347,150$ 128.8%387,800$ 327,436$
NET FUND INCREASE (DECREASE)2,603,485$ 5,975,333$ 1,138,915$ 953,555$ 3,371,848$
*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 November 30, 2021
Total Total
Revenues Expenditures
11/30/21 Actual 24,580,570$ 19,052,376$
11/30/20 Actual 22,964,455$ 20,480,673$
% Change From Last Year 7.0%-7.0%
Major Revenues
Other Telecom/Utility Licenses &Charges for
Sales Tax Intergov. Tax Tax Permits Services
11/30/21 Actual 12,879,834$ 1,821,634$ 5,258,025$ 2,371,345$ 1,379,646$
11/30/20 Actual $ 10,352,357 $ 1,426,192 $ 5,449,740 $ 3,462,554 $ 809,060
% Change From Last Year 24.4%27.7%-3.5%-31.5%70.5%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
11/30/21 Actual 15,573,578$ 378,671$ 2,873,209$ 8,599$ 218,319$
11/30/20 Actual 16,596,335$ 412,327$ 3,259,503$ 6,547$ 205,961$
% Change From Last Year -6.2%-8.2%-11.9%31.3%6.0%
Five Year Trend
Expenditures by Department
11/30/20 11/30/21 11/30/21 11/30/21 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Department Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 1,884,863$ 2,123,970$ 2,319,965$ 91.6%2,498,625$ 239,107$
Financial Services 680,718 691,170 711,335 97.2%770,360 10,452
Public Works 735,240 718,961 869,725 82.7%948,860 (16,279)
Engineering & Capital Projects 53,528 22,671 199,000 11.4%209,000 (30,857)
Library 765,180 810,260 883,085 91.8%943,405 45,080
Police 8,162,887 7,595,733 8,378,840 90.7%9,213,585 (567,154)
Fire 7,250,168 6,234,412 6,748,285 92.4%7,576,045 (1,015,756)
Development Services 948,089 855,199 1,000,320 85.5%1,092,740 (92,890)
Total Expenditures 20,480,673$ 19,052,376$ 21,110,555$ 90.3%23,252,620$ (1,428,297)$
Five Year Trend
For the Period Ending November 30, 2021
General Fund - Five Year Trend
Village of Oak Brook
Revenues Expenditures
11/30/21 11/30/21
11/30/20 11/30/21 YTD % of YTD 2021 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Hotel Tax 472,355$ 680,375$ 382,900$ 177.7%414,000$ 208,020$
Investment Interest 64,690 29,274 36,685 79.8%40,000 (35,416)
Loan Interest 4,167 8,000 4,000 200.0%8,000 3,833
Miscellaneous 16,359 1,272 - N/A - (15,087)
Total Operating Revenues 557,571$ 718,921$ 423,585$ 169.7%462,000$ 161,350$
EXPENDITURES
Operation and Contract 360,235$ 178,533$ 179,435$ 99.5%193,945$ (181,702)$
Capital Outlay 473,243 5,215 250,000 2.1%250,000 (468,028)
Total Expenditures 833,478$ 183,748$ 429,435$ 42.8%443,945$ (649,730)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES (275,907)$ 535,173$ (5,850)$ -9148.3%18,055$ 811,080$
INTERFUND TRANSACTIONS
Transfer Out -$ (2,714,068)$ (3,000,000)$ 90.5%(100,000)$ (2,714,068)$
Reimbursements to Other Funds (68,486) (77,077) (77,075) 100.0%(84,085) (8,591)
Total Interfund Transactions (68,486)$ (2,791,145)$ (3,077,075)$ 90.7%(184,085)$ (2,722,659)$
NET FUND INCREASE (DECREASE)(344,393)$ (2,255,972)$ (3,082,925)$ (166,030)$ (1,911,579)$
Note - Expenditures are recorded in program 171.
Village of Oak Brook
Hotel Tax Fund Financial Update
For the Period Ending November 30, 2021
Total Total
Revenues Expenditures
11/30/21 Actual $ 718,921 183,748$
11/30/20 Actual $ 557,571 833,478$
% Change From Last Year 28.9%-78.0%
Major Revenues Investment
Hotel Tax Interest Loan Interest Miscellaneous
11/30/21 Actual $ 680,375 $ 29,274 8,000$ 1,272$
11/30/20 Actual $ 472,355 $ 64,690 4,167$ 16,359$
% Change From Last Year 44.0%-54.7%92.0%-92.2%
Five Year Trend
Major Expenditures Operation &
Contractual Capital Outlay
11/30/21 Actual 178,533$ 5,215$
11/30/20 Actual 360,235$ 473,243$
% Change From Last Year -50.4%-98.9%
Five Year Trend
Village of Oak Brook
Hotel Tax Fund - Major Sources Five Year Trend
For the Period Ending November 30, 2021
Five Year Trend
Revenues Expenditures
11/30/21 11/30/21
11/30/20 11/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 4,471,523$ 5,472,944$ 4,908,500$ 111.5%5,333,500$ 1,001,421$
Charges for Services 335 - 935 0.0%1,000 (335)
Investment Interest 78,812 30,993 36,685 84.5%40,000 (47,819)
Miscellaneous 144 4,279 - N/A - 4,135
Total Operating Revenues 4,550,814$ 5,508,216$ 4,946,120$ 111.4%5,374,500$ 957,402$
OPERATING EXPENDITURES
Personnel 1,157,621$ 1,166,832$ 1,243,815$ 93.8%1,386,115$ 9,211$
Materials and Supplies 136,878 159,724 222,305 71.8%245,660 22,846
Operation and Contract 1,204,108 1,425,342 1,756,255 81.2%1,892,905 221,234
Capital Outlay 3,616,303 5,409,164 8,076,930 67.0%8,956,170 1,792,861
Total Operating Expenditures 6,114,910$ 8,161,062$ 11,299,305$ 72.2%12,480,850$ 2,046,152$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES (1,564,096)$ (2,652,846)$ (6,353,185)$ 41.8%(7,106,350)$ (1,088,750)$
INTERFUND TRANSACTIONS
Transfers In 666,289$ 2,714,068$ 4,400,000$ 61.7%1,400,000$ 2,047,779$
Reimbursements From Other Funds 329,428 304,194 304,205 100.0%331,840 (25,234)
Reimbursements To Other Funds (148,775) (161,612) (161,630) 100.0%(176,300) (12,837)
Total Interfund Transactions 846,942$ 2,856,650$ 4,542,575$ 62.9%1,555,540$ 2,009,708$
NET FUND INCREASE (DECREASE)(717,154)$ 203,804$ (1,810,610)$ (5,550,810)$ 920,958$
Village of Oak Brook
Infrastructure Fund Financial Update
For the Period Ending November 30, 2021
Total Total
Revenues Expenditures
11/30/21 Actual $ 5,508,216 8,161,062$
11/30/20 Actual $ 4,550,814 6,114,910$
% Change From Last Year 21.0%33.5%
Major Revenues
Sales Tax
Charges for
Services
Investment
Interest Miscellaneous
11/30/21 Actual $ 5,472,944 $ - $ 30,993 $ 4,279
11/30/20 Actual $ 4,471,523 $ 335 $ 78,812 $ 144
% Change From Last Year 22.4%-100.0%-60.7%2871.5%
Five Year Trend
Major Expenditures Materials &Operation &
Personnel Supplies Contractual Capital Outlay
11/30/21 Actual 1,166,832$ 159,724$ 1,425,342$ 5,409,164$
11/30/20 Actual 1,157,621$ 136,878$ 1,204,108$ 3,616,303$
% Change From Last Year 0.8%16.7%18.4%49.6%
Five Year Trend
Expenditures by Department
11/30/20 11/30/21 11/30/21 11/30/21 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 128,250$ 147,483$ 145,250$ 101.5%157,640$ 19,233$
Public Works 3,650,787 2,199,524 2,400,825 91.6%2,789,580 (1,451,263)
Engineering & Capital Projects 2,335,873 5,814,055 8,753,230 66.4%9,709,930 3,478,182
Total Expenditures 6,114,910$ 8,161,062$ 11,299,305$ 72.2%12,657,150$ 2,046,152$
Five Year Trend
Village of Oak Brook
Infrastructure Fund - Major Sources Five Year Trend
For the Period Ending November 30, 2021
Revenues Expenditures
11/30/21 11/30/21
11/30/20 11/30/21 YTD % of YTD 2021 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 55,493$ 81,673$ 69,000$ 118.4%75,000$ 26,180$
Real Estate Tax 414,544 408,456 400,000 102.1%400,000 (6,088)
Investment Interest 525 47 935 5.0%1,000 (478)
Total Operating Revenues 470,562$ 490,176$ 469,935$ 104.3%476,000$ 19,614$
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)(63,641)$ 4,601$ (415)$ 5,650$ 68,242$
Note - Expenditures are recorded in program 283.
Village of Oak Brook
Promenade TIF Fund Financial Update
For the Period Ending November 30, 2021
Total Total
Revenues Expenditures
11/30/21 Actual $ 490,176 485,575$
11/30/20 Actual $ 470,562 534,203$
% Change From Last Year 4.2%-9.1%
Major Revenues Real Estate Investment
Sales Tax Tax Interest
11/30/21 Actual 81,673$ $ 408,456 $ 47
11/30/20 Actual 55,493$ $ 414,544 $ 525
% Change From Last Year 47.2%-1.5%-91.0%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures
11/30/21 Actual 4,075$ 481,500$
11/30/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 November 30, 2021
Five Year Trend
Revenues Expenditures
11/30/21 11/30/21
11/30/20 11/30/21 YTD % of YTD 2021 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Plan Review Fees 1,050$ 525$ 935$ 56.1%1,000$ (525)$
Building/Inspection Fees 5,887 3,000 6,435 46.6%7,000 (2,887)
Water Sales 9,531,573 10,320,250 10,220,000 101.0%10,597,000 788,677
Unmetered Sales 82,626 44,602 32,065 139.1%35,000 (38,024)
Water Connection Fees 22,120 188,830 91,685 206.0%100,000 166,710
Meter Charges 15,082 7,826 13,750 56.9%15,000 (7,256)
Special Services 24,169 25,326 25,000 101.3%25,000 1,157
Investment Interest 89,809 42,772 55,000 77.8%60,000 (47,037)
Miscellaneous 21,449 689,241 59,565 1157.1%65,000 667,792
Total Operating Revenues 9,793,765$ 11,322,372$ 10,504,435$ 107.8%10,905,000$ 1,528,607$
OPERATING EXPENDITURES
Personnel 685,423$ 677,537$ 763,025$ 88.8%842,235$ (7,886)$
Materials and Supplies 34,696 121,457 70,275 172.8%75,780 86,761
Operation and Contract 4,373,696 4,482,817 4,938,105 90.8%5,379,925 109,121
Capital Outlay 3,161,756 5,979,659 8,102,080 73.8%8,103,750 2,817,903
Total Expenditures 8,255,571$ 11,261,470$ 13,873,485$ 81.2%14,401,690$ 3,005,899$
Surplus (Deficit) of Revenues Over
Expenditures 1,538,194$ 60,902$ (3,369,050)$ -1.8%(3,496,690)$ (1,477,292)$
INTERFUND TRANSACTIONS
Reimbursements To Other Funds (482,911)$ (412,962)$ (412,940)$ 100.0%(450,500)$ 69,949$
Total Interfund Transactions (482,911)$ (412,962)$ (412,940)$ 100.0%(450,500)$ 69,949$
Fund Increase/(Decrease) - Budgetary Basis 1,055,283$ (352,060)$ (3,781,990)$ 9.3%(3,947,190)$ (1,407,343)$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay 3,161,756$ 5,979,659$
Depreciation Expense (502,978) (527,083)
IMRF Pension Expense (38,035) (41,250)
OPEB Expense 25,339 (27,500)
Total GAAP Adjustments 2,646,082$ 5,383,826$
Fund Increase/(Decrease) - GAAP Basis 3,701,365$ 5,031,766$
*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 November 30, 2021
Total Total
Revenues Expenditures
11/30/21 Actual $ 11,322,372 11,261,470$
11/30/20 Actual $ 9,793,765 8,255,571$
% Change From Last Year 15.6%36.4%
Unmetered Water
Water Sales Sales Connection Fees Meter Charges Miscellaneous
11/30/21 Actual $ 10,320,250 $ 44,602 $ 188,830 $ 7,826 $ 689,241
11/30/20 Actual $ 9,531,573 $ 82,626 $ 22,120 $ 15,082 $ 21,449
% Change From Last Year 8.3%-46.0%753.7%-48.1%3113.4%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
11/30/21 Actual 677,537$ 121,457$ 4,482,817$ -$ 5,979,659$
11/30/20 Actual 685,423$ 34,696$ 4,373,696$ -$ 3,161,756$
% Change From Last Year -1.2%250.1%2.5%0.0%89.1%
Five Year Trend
Expenditures by Department
11/30/20 11/30/21 11/30/21 11/30/21 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Public Works 5,125,023$ 5,216,717$ 5,789,735$ 90.1%6,317,940$ 91,694$
Engineering & Capital Projects 3,130,548 6,044,753 8,083,750 74.8%8,083,750 2,914,205
Total Expenditures 8,255,571$ 11,261,470$ 13,873,485$ 81.2%14,401,690$ 3,005,899$
Five Year Trend
Village of Oak Brook
Water Fund - Major Sources Five Year Trend
For the Period Ending November 30, 2021
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Sports Core Fund Consolidated Presentation
For the Period Ending November 30, 2021
11/30/21 11/30/21
11/30/21 YTD % of YTD 2021 11/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 -$ -$ -$ 355,865$ 355,865$ 238,500$ 149.2%238,500$ 226,687$ 129,178$
Greens Fees - - - 1,284,165 1,284,165 985,000 130.4%985,000 1,111,776 172,389
Pro Shop Sales - - - 232,554 232,554 206,500 112.6%207,000 178,102 54,452
Golf Lessons - - - 50,140 50,140 45,000 111.4%45,000 41,580 8,560
Driving Range Fees - - - 341,440 341,440 250,000 136.6%250,000 259,116 82,324
Rentals - 108,000 198,883 493,424 800,307 726,475 110.2%761,000 489,891 310,416
Programs/User Fees - - - - - 31,500 0.0%31,500 - -
Food Sales - - - 277,719 277,719 205,800 134.9%207,500 162,974 114,745
Beverage Sales - - - 489,421 489,421 377,000 129.8%382,000 356,936 132,485
Taste of Oak Brook - - - - - 120,000 0.0%120,000 - -
Grants - - - - - 233,600 0.0%233,600 - -
Other Revenue 8,699 - - 12,773 21,472 7,645 280.9%7,700 6,782 14,690
Total Operating Revenues 8,699$ 108,000$ 198,883$ 3,537,501$ 3,853,083$ 3,427,020$ 112.4%3,468,800$ 2,833,844$ 1,019,239$
OPERATING EXPENDITURES
Personnel 16,251$ -$ 112,577$ 1,225,482$ 1,354,310$ 1,508,730$ 89.8%1,597,610$ 1,399,038$ (44,728)$
Materials & Supplies 32,675 - 6,741 641,035 680,451 625,195 108.8%628,450 555,647 124,804
Operational & Contractual 99,117 9,345 69,075 350,861 528,398 646,790 81.7%663,035 428,562 99,836
Other - - - - - (39,000) 0.0%(39,000) - -
Capital 286,522 232,675 4,382 146,918 670,497 1,125,380 59.6%1,125,380 1,051,733 (381,236)
Total Operating Expenditures 434,565$ 242,020$ 192,775$ 2,364,296$ 3,233,656$ 3,867,095$ 83.6%3,975,475$ 3,434,980$ (201,324)$
B&T Administration Overhead Allocation*126,182$ -$ (126,182)$ -$ -$ -$ 0.0%-$ -$ -$
Operating Revenues Over (Under) Expenditures (299,684)$ (134,020)$ (120,074)$ 1,173,205$ 619,427$ (440,075)$ -140.8%(506,675)$ (601,136)$ 1,220,563$
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 340,065 (340,065)
Reimbursement From Infrastructure Fund 29,337 - - - 29,337 29,345 100.0%32,000 22,000 7,337
Reimbursement From Water Fund 7,337 - - - 7,337 7,340 100.0%8,000 7,337 -
Reimbursement To General Fund (14,410) - - (43,241) (57,651) (57,655) 100.0%(62,900) (51,744) (5,907)
Total Interfund Transactions 22,264$ -$ -$ (43,241)$ (20,977)$ 279,030$ -7.5%277,100$ 644,027$ (665,004)$
Total Revenues Over (Under) Expenditures - Budgetary Basis (277,420)$ (134,020)$ (120,074)$ 1,129,964$ 598,450$ (161,045)$ (229,575)$ 42,891$ 555,559$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 286,522$ 232,675$ 4,382$ 146,918$ 670,497$ 1,051,733$
Depreciation Expense (154,208) (1,545) (55,000) (225,775) (436,528) (356,659)
IMRF Pension Expense (1,879) - (2,750) (22,458) (27,088) (23,975)
OPEB Expense - - (2,750) (25,667) (28,417) (23,142)
Total GAAP Adjustments 130,435$ 231,130$ (56,118)$ (126,982)$ 178,465$ 647,958$
Fund Increase/(Decrease) - GAAP Basis (146,985)$ 97,110$ (176,192)$ 1,002,982$ 776,915$ 690,849$
*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
11/30/21 Actual $ 3,853,083 3,233,656$
11/30/20 Actual $ 2,833,844 3,434,980$
% Change From Last Year 36.0%-5.9%
Driving Program/
Memberships Greens Fees Range Fees Rentals User Fees
11/30/21 Actual $ 355,865 $ 1,284,165 $ 341,440 $ 800,307 -$
11/30/20 Actual $ 226,687 $ 1,111,776 $ 259,116 $ 489,891 -$
% Change From Last Year 57.0%15.5%31.8%63.4%0.0%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
11/30/21 Actual 1,354,310$ 680,451$ 528,398$ -$ 670,497$
11/30/20 Actual 1,399,038$ 555,647$ 428,562$ -$ 1,051,733$
% Change From Last Year -3.2%22.5%23.3%0.0%-36.2%
Five Year Trend
Revenues by Department 11/30/20 11/30/21 11/30/21 11/30/21 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Operations 1,787$ 8,699$ 325,745$ 2.7%325,800$ 6,912$
Open Field Operations 100,040 108,000 227,500 47.5%230,000 7,960
B&T Clubhouse Operations 20,402 198,883 237,000 83.9%267,000 178,481
Golf Club 2,711,615 3,537,501 2,636,775 134.2%2,646,000 825,886
Total Revenues 2,833,844$ 3,853,083$ 3,427,020$ 112.4%3,468,800$ 1,019,239$
Expenditures by Department 11/30/20 11/30/21 11/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 573,796$ 434,565$ 775,315$ 56.1%780,740$ (139,231)$
Open Field Operations 33,804$ 242,020$ 358,335$ 67.5%358,910$ 208,216$
B&T Clubhouse Operations 295,815 192,775 243,800 79.1%262,635 (103,040)
Golf Club 2,531,565 2,364,296 2,489,645 95.0%2,573,190 (167,269)
Total Expenditures 3,434,980$ 3,233,656$ 3,867,095$ 83.6%3,975,475$ (201,324)$
Five Year Trend
Village of Oak Brook
Sports Core Fund - Major Sources Five Year Trend
For the Period Ending November 30, 2021
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Club Recreation Operations
For the Period Ending November 30, 2021 11/30/21 11/30/21
822 11/30/21 YTD % of YTD 2021 11/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 - - - - - 38,000 0.0%38,000 - -
Beverage Sales - - - - - 22,000 0.0%22,000 - -
Grants - - - - - 233,600 0.0%233,600 - -
Other Revenue 8,699 - - - 8,699 645 1348.7%700 1,588 7,111
Total Operating Revenues 8,699$ -$ -$ -$ 8,699$ 325,745$ 2.7%325,800$ 1,787$ 6,912$
OPERATING EXPENDITURES
Personnel 16,251$ -$ -$ -$ 16,251$ 115,025$ 14.1%119,110$ 56,776$ (40,525)$
Materials & Supplies 593 27,913 2,460 1,709 32,675 37,190 87.9%37,250 3,762 28,913
Operational & Contractual 53,662 38,075 7,157 223 99,117 88,270 112.3%89,550 75,681 23,436
Capital 176,147 110,375 - - 286,522 534,830 53.6%534,830 437,577 (151,055)
Total Operating Expenditures 246,653$ 176,363$ 9,617$ 1,932$ 434,565$ 775,315$ 56.1%780,740$ 573,796$ (139,231)$
B&T Administration Overhead Allocation*252,363$ (90,851)$ (25,236)$ (10,094)$ 126,182$ 43,130$ 292.6%44,755$ 96,807$ 29,375$
Operating Revenues Over (Under) Expenditures 14,409$ (267,214)$ (34,853)$ (12,026)$ (299,684)$ (406,440)$ 73.7%(410,185)$ (475,202)$ 175,518$
INTERFUND TRANSACTIONS
Transfer From General Fund -$ -$ -$ -$ -$ 100,000$ 0.0%100,000$ 326,369$ (326,369)$
Reimbursement From Infrastructure Fund 29,337 - - - 29,337 29,345 100.0%32,000 22,000 7,337
Reimbursement From Water Fund 7,337 - - - 7,337 7,340 100.0%8,000 7,337 -
Reimbursement To General Fund (14,410) - - - (14,410) (14,410) 100.0%(15,725) (25,872) 11,462
Total Interfund Transactions 22,264$ -$ -$ -$ 22,264$ 122,275$ 18.2%124,275$ 329,834$ (307,570)$
Total Revenues Over (Under) Expenditures - Budgetary Basis 36,673$ (267,214)$ (34,853)$ (12,026)$ (277,420)$ (284,165)$ (285,910)$ (145,368)$ (132,052)$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 176,147$ 110,375$ -$ -$ 286,522$ 437,577$
Depreciation Expense (58,996) (91,667) (2,475) (1,071) (154,208) (84,431)
IMRF Pension Expense (1,833) - - (46) (1,879) (1,026)
Total GAAP Adjustments 115,318$ 18,708$ (2,475)$ (1,117)$ 130,435$ 352,120$
Fund Increase/(Decrease) - GAAP Basis 151,991$ (248,506)$ (37,328)$ (13,143)$ (146,985)$ 206,752$
*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 November 30, 2021 11/30/21 11/30/21
11/30/21 YTD % of YTD 2021 11/30/20 Difference
815 816 YTD Amended Amended Adopted YTD Prior
Polo Open Fields Total Budget Budget Budget Total Year
OPERATING REVENUES
Field Rentals -$ 28,000$ 28,000$ 27,500$ 101.8%30,000$ 25,040$ 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 -$ 108,000$ 108,000$ 227,500$ 47.5%230,000$ 100,040$ 7,960$
OPERATING EXPENDITURES
Personnel -$ -$ -$ -$ 0.0%-$ -$ -$
Materials & Supplies - - - 500 0.0%500 119 (119)
Operational & Contractual - 9,345 9,345 189,785 4.9%190,360 24,264 (14,919)
Capital - 232,675 232,675 168,050 138.5%168,050 9,421 223,254
Total Operating Expenditures -$ 242,020$ 242,020$ 358,335$ 67.5%358,910$ 33,804$ 208,216$
Operating Revenues Over (Under) Expenditures -$ (134,020)$ (134,020)$ (130,835)$ 102.4%(128,910)$ 66,236$ (200,256)$
INTERFUND TRANSACTIONS
Transfer From Hotel Tax Fund -$ -$ -$ -$ 0.0%-$ -$ -$
Total Interfund Transactions -$ -$ -$ -$ 0.0%-$ -$ -$
Total Revenues Over (Under) Expenditures - Budgetary Basis -$ (134,020)$ (134,020)$ (130,835)$ (128,910)$ 66,236$ (200,256)$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay -$ 232,675$ 232,675$ 9,421$
Depreciation Expense - (1,545) (1,545) (1,545)
Total GAAP Adjustments -$ 231,130$ 231,130$ 7,876$
Fund Increase/(Decrease) - GAAP Basis -$ 97,110$ 97,110$ 74,112$
*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 November 30, 2021
11/30/21 11/30/21
821 YTD % of YTD 2021 11/30/20 Difference
B&T Amended Amended Adopted YTD Prior
Clubhouse Budget Budget Budget Total Year
OPERATING REVENUES
Rentals 198,883$ 237,000$ 83.9%267,000$ 20,402$ 178,481$
Total Operating Revenues 198,883$ 237,000$ 83.9%267,000$ 20,402$ 178,481$
OPERATING EXPENDITURES
Personnel 112,577$ 122,880$ 91.6%133,585$ 97,283$ 15,294$
Materials & Supplies 6,741 10,565 63.8%12,000 1,758 4,983
Operational & Contractual 69,075 100,855 68.5%107,550 51,702 17,373
Capital 4,382 9,500 46.1%9,500 145,072 (140,690)
Total Operating Expenditures 192,775$ 243,800$ 79.1%262,635$ 295,815$ (103,040)$
B&T Administration Overhead Allocation*(126,182)$ (43,130)$ 292.6%(44,755)$ (96,807)$ (29,375)$
Operating Revenues Over (Under) Expenditures (120,074)$ (49,930)$ 240.5%(40,390)$ (372,220)$ 252,146$
INTERFUND TRANSACTIONS
Transfer From General Fund -$ -$ 0.0%-$ -$ -$
Total Interfund Transactions -$ -$ 0.0%-$ -$ -$
Total Revenues Over (Under) Expenditures - Budgetary Basis (120,074)$ (49,930)$ (40,390)$ (372,220)$ 252,146$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 4,382$ 145,072$
Depreciation Expense (55,000) (55,509)
IMRF Pension Expense (2,750) (1,900)
OPEB Expense (2,750) (2,424)
Total GAAP Adjustments (56,118)$ 85,239$
Fund Increase/(Decrease) - GAAP Basis (176,192)$ (286,981)$
*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 November 30, 2021
11/30/21 11/30/21
823 831 832 833 834 11/30/21 YTD % of YTD 2021 11/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 -$ 355,865$ -$ -$ -$ 355,865$ 238,500$ 149.2%238,500$ 226,488$ 129,377$
Greens Fees - 1,284,165 - - - 1,284,165 985,000 130.4%985,000 1,111,776 172,389
Pro Shop Sales - 232,554 - - - 232,554 206,500 112.6%207,000 178,102 54,452
Golf Lessons - - 50,140 - - 50,140 45,000 111.4%45,000 41,580 8,560
Driving Range Fees - - 341,440 - - 341,440 250,000 136.6%250,000 259,116 82,324
Rentals - 2,685 9,000 481,739 - 493,424 381,975 129.2%384,000 369,449 123,975
Food Sales 277,719 - - - - 277,719 167,800 165.5%169,500 162,974 114,745
Beverage Sales 489,421 - - - - 489,421 355,000 137.9%360,000 356,936 132,485
Other Revenue - 12,773 - - - 12,773 7,000 182.5%7,000 5,194 7,579
Total Operating Revenues 767,140$ 1,888,042$ 400,580$ 481,739$ -$ 3,537,501$ 2,636,775$ 134.2%2,646,000$ 2,711,615$ 825,886$
OPERATING EXPENDITURES
Personnel 232,020$ 504,076$ 78,677$ 42,404$ 368,305$ 1,225,482$ 1,270,825$ 96.4%1,344,915$ 1,244,979$ (19,497)$
Materials & Supplies 277,625 172,500 16,171 1,205 173,534 641,035 576,940 111.1%578,700 550,008 91,027
Operational & Contractual 5,647 253,891 799 56,759 33,765 350,861 267,880 131.0%275,575 276,915 73,946
Other - - - - - - (39,000) 0.0%(39,000) - -
Capital 6,678 19,702 - - 120,538 146,918 413,000 35.6%413,000 459,663 (312,745)
Total Operating Expenditures 521,970$ 950,169$ 95,647$ 100,368$ 696,142$ 2,364,296$ 2,489,645$ 95.0%2,573,190$ 2,531,565$ (167,269)$
Operating Revenues Over (Under) Expenditures 245,170$ 937,873$ 304,933$ 381,371$ (696,142)$ 1,173,205$ 147,130$ 797.4%72,810$ 180,050$ 993,155$
INTERFUND TRANSACTIONS
Transfer from Golf Surcharge -$ -$ -$ -$ -$ -$ 200,000$ 0.0%200,000$ 340,065$ (340,065)$
Reimbursement to General Fund - (43,241) - - - (43,241) (43,245) 100.0%(47,175) (25,872) (17,369)
Total Interfund Transactions -$ (43,241)$ -$ -$ -$ (43,241)$ 156,755$ -27.6%152,825$ 314,193$ (357,434)$
Total Revenues Over (Under) Expenditures - Budgetary Basis 245,170$ 894,632$ 304,933$ 381,371$ (696,142)$ 1,129,964$ 303,885$ 225,635$ 494,243$ 635,721$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay 6,678$ 19,702$ -$ -$ 120,538$ 146,918$ 459,663$
Depreciation Expense (917) (96,250) (2,108) (11,917) (114,583) (225,775) (215,174)
IMRF Pension Expense (2,292) (9,167) (917) - (10,083) (22,458) (21,049)
OPEB Expense (2,750) (13,750) - - (9,167) (25,667) (20,719)
Total GAAP Adjustments 720$ (99,465)$ (3,025)$ (11,917)$ (13,295)$ (126,982)$ 202,722$
Fund Increase/(Decrease) - GAAP Basis 245,890$ 795,167$ 301,908$ 369,454$ (709,437)$ 1,002,982$ 696,965$
*Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.