07 - July 2021 Monthly Financial ReportVILLAGE
OAK BROOK
OF
MONTHLY FINANCIAL REPORTS
JULY 2021
Cash and Investments by Fund:Total
Cash and Cash Pooled Cash and
Fund Equivalents Investments Investments % By Fund
General Corporate $12,341,445 $14,133,476 $26,474,921 58.4%
Hotel/Motel Tax 523,539 2,222,362 2,745,901 6.1%
Motor Fuel Tax 998,313 20,115 1,018,428 2.2%
Infrastructure 4,050,255 3,105,903 7,156,158 15.8%
Promenade TIF 31,510 - 31,510 0.1%
Water 1,562,749 3,687,101 5,249,850 11.6%
Sports Core 881,014 - 881,014 1.9%
Golf Surcharge 216,903 - 216,903 0.5%
Self-Insurance 488,992 - 488,992 1.1%
Garage 333,972 - 333,972 0.7%
Equipment Replacement 304,693 441,424 746,117 1.6%
Total $21,733,385 $23,610,381 $45,343,766 100.0%
Change in Cash and Investments by Fund :
Balance at Balance at Year-to-Date Year-to-Date
Fund January 1, 2021 July 31, 2021 Change ($)Change (%)
General Corporate $23,894,312 $26,474,921 $2,580,609 10.8%
Hotel/Motel Tax 4,567,176 2,745,901 (1,821,275)-39.9%
Motor Fuel Tax 673,455 1,018,428 344,973 51.2%
Infrastructure 7,480,975 7,156,158 (324,817)-4.3%
Promenade TIF 267,300 31,510 (235,790)-88.2%
Water 6,900,169 5,249,850 (1,650,319)-23.9%
Sports Core 114,133 881,014 766,881 671.9%
Golf Surcharge 132,593 216,903 84,310 63.6%
Self-Insurance - 488,992 488,992 N/A
Garage 298,348 333,972 35,624 11.9%
Equipment Replacement 696,392 746,117 49,725 7.1%
$45,024,853 $45,343,766 $318,913 0.7%
Book Bank/Market
Value Value
Cash and Cash Equivalents:
Pooled Checking $822,879 $3,917,974
Sports Core Checking 1,105,366 1,029,373
Pooled IPTIP 19,639,094 19,639,094
Water E-Pay IPTIP 166,046 128,393
$21,733,385 $24,714,834
Pooled Investments:
Investments-Municipal Bonds $10,102,203 $10,152,640
Investments-Corporate Bonds 9,362,744 9,371,330
Government & Agency Obligations 1,512,695 1,525,056
Certificates of Deposit 2,450,000 2,462,068
Accrued Interest 182,739 182,739
Total Pooled Investments $23,610,381 $23,693,833
Total Cash and Investments $45,343,766 $48,408,667
For July, total interest revenue is $25,092 and YTD is $189,956. The total investment yield for the portfolio is:
Pooled
Investments Illinois Funds Total
Last 12 months yield 1.52%0.80%0.86%
The weighted average yield of the current investment portfolio is 1.12%. The IL Funds July average daily rate was 0.02%.
Monthly Treasurer's Report
July 31, 2021
Monthly Treasurer's Report
July 2021
The table below lists the detail investment holdings at J.P. Morgan Securities as of 7/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%$502,013 $508,520 $3,349
Connecticut St GO Bds 2016 #20772J3F7 06/15/17 08/15/21 1.750%2.300%499,922 500,260 3,982
State of IL #452152P54 10/09/19 11/01/21 5.000%1.870%503,923 505,955 5,999
Brownsville TX #16405ST9 12/19/19 02/15/22 2.050%2.000%555,139 560,117 5,088
Laredo TX Waterworks #517039VW0 12/19/19 03/01/24 2.230%2.230%455,000 474,105 4,171
Oakland Univ Mich #673588HJ1 04/29/20 03/01/24 5.000%1.650%319,844 330,441 6,146
Philadelphia PA GO Ref #717813SW0 05/05/20 08/01/22 5.000%1.820%402,290 408,962 9,547
Maryland St DOT #574204WG4 05/06/20 06/15/22 4.350%1.200%267,139 269,363 1,329
University of CA #91412HFK4 07/16/20 05/15/23 0.628%0.628%25,000 25,165 33
Waterford Mich Sch Dist #941468YZ7 08/20/20 08/24/21 4.000%0.301%501,175 501,120 18,925
Universty of IL #914353YH4 08/31/20 10/01/21 3.000%0.701%250,948 251,163 2,500
New Jersey St #646039UD7 09/20/20 06/01/22 5.000%0.600%492,376 494,071 3,892
Alaska St GO #011770Z72 10/14/2020 8/1/2021 5.000%0.252%175,020 175,000 4,351
Rio Rancho NM #767175HM7 10/14/2020 5/15/2022 5.000%0.350%191,789 192,106 1,927
Cook, Kane, Lake, & McHenry #216181GL5 10/29/2020 12/15/2022 4.000%0.300%1,076,876 1,080,412 30,970
Miami-Dade Cnty #59333NN90 11/16/2020 12/15/2022 0.375%0.430%734,326 734,794 903
Hamilton NY #407741MC8 1/21/2021 5/1/2023 1.000%0.550%206,609 206,378 501
Southern Cal Pub Pwr #84247PHZ7 1/25/2021 4/1/2024 3.608%0.500%1,090,028 1,086,410 2,806
Hillsborough Cnty FL #43232VV3 3/11/2021 7/1/2024 1.815%0.770%515,074 514,010 681
Port Auth of NY and NJ #73358WAH7 4/15/2021 12/1/2024 5.859%0.600%586,777 584,060 4,720
City of Atlanta GA Water #047870SG6 4/19/2021 11/1/2024 0.616%0.500%250,935 251,253 368
West Contra Costa Cal Uni #9523474U3 6/17/2021 8/1/2024 0.575%0.575%500,000 498,975 343
Total Municipal Bonds $10,102,203 $10,152,640 $112,531
Corporate Bonds:
Citigroup #172967LC3 04/01/19 12/08/21 2.900%2.754%$1,000,598 $1,007,089 $3,706
American Honda #02665WBG5 07/31/19 09/09/21 1.700%2.180%499,774 500,770 3,376
JP Morgan #48128BAB7 09/30/19 01/15/23 2.972%2.337%1,008,975 1,012,011 1,321
American Express #025816CD9 05/05/20 05/20/22 2.750%1.290%505,859 508,905 2,569
PNC Bank #69349LAK4 12/7/2020 1/30/2023 2.950%0.457%1,057,876 1,056,890 0
Wells Fargo #94974BFJ4 12/7/2020 2/13/2023 3.450%0.480%1,452,869 1,455,430 22,246
Comerica Bank #200340AS6 12/23/2020 7/31/2023 3.700%0.500%531,788 530,951 9,250
Bank of America #06048WM23 5/14/2021 5/14/2024 0.650%0.650%915,000 914,968 1,239
Goldman Sachs #38141GXE9 7/27/2021 2/20/2024 3.625%0.693%644,478 642,237 9,667
Goldman Sachs #38150AGU3 7/28/2021 7/28/2023 0.550%0.550%655,000 655,059 30
Morgan Stanley #61746BDQ6 7/28/2021 4/29/2024 3.875%0.547%1,090,527 1,087,020 9,903
Total Corporate Bonds $9,362,744 $9,371,330 $63,307
Government & Agency Obligations:
*Government National Mtg Assn #38379UEM4 02/29/16 02/16/51 2.300%2.245%$278,370 $268,544 $683
*Government National Mtg Assn #38381WV96 08/06/19 07/20/54 2.250%2.293%316,894 325,714 466
*Government National Mtg Assn #38380BNV3 12/05/19 06/20/46 2.000%2.112%417,431 431,610 583
Federal Home Loan Bank #3130AMVU3 06/29/21 06/29/26 0.500%0.500%500,000 499,188 208
Total Government & Agency Obligations:$1,512,695 $1,525,056 $1,940
Certificates of Deposit:
State Bk India NY #8562846A7 01/26/17 01/26/22 2.250%2.250%$245,000 $247,656 $85
Wells Fargo #949763J31 09/18/19 09/20/21 1.850%1.850%245,000 245,627 191
BMW Bank #05580ASQ8 10/11/19 10/12/21 1.800%1.800%245,000 245,884 1,280
Wells Fargo #949495AN5 01/17/20 01/18/22 1.800%1.800%245,000 246,980 190
Bank Leumi #063248KQ0 03/31/20 03/31/22 1.250%1.250%245,000 246,952 1,021
Capital One Natl Assn #14042TCZ8 04/01/20 04/01/22 1.350%1.350%245,000 247,109 1,093
Synchrony Bank #87164WZN1 04/03/20 04/04/22 1.350%1.350%245,000 247,136 1,075
Goldman Sachs 38149MXG3 07/28/21 07/29/24 0.550%0.550%245,000 244,910 11
Sallie Mae #795451AD5 07/28/21 07/29/24 0.600%0.600%245,000 245,275 12
Texas Exchange Bk #88241TLS7 07/30/21 07/30/24 0.500%0.500%245,000 244,539 3
Total Certificates of Deposits $2,450,000 $2,462,068 $4,961
Total J.P.Morgan Securities $23,427,642 $23,511,094 $182,739
*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
July 31, 2021
Cash & Investments by Fund - Total $45.3 million
Cash & Investments by Type - Total $45.3 million
Checking
Illinois Funds
Certificates of Deposit
Municipal Bonds
Corporate Bonds
Government & Agency Obligations
Accrued Interest
General Corporate
58.4%
Hotel/Motel Tax
6.1%Motor Fuel Tax
2.2%
Infrastructure
15.8%
Promenade TIF
0.1%
Water
11.6%
Sports Core
1.9%
Golf Surcharge
0.5%
Self-Insurance
1.1%
Garage
0.7%
Equipment
Replacement
1.6%
Checking, $1.9
Illinois Funds, $19.8
Certificates of Deposit,
$2.5
Municipal Bonds,
$10.1
Corporate Bonds, $9.4
Government & Agency
Obligations, $1.5
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)14,892,755$ 12,492,457$ 2,400,298$ 593,425$
Main operating fund of the Village.
Hotel Fund (Major Fund)346,930$ 2,209,669$ (1,862,739)$ (950,995)$
Collects and spends resources from the
3% hotel/motel tax.
Motor Fuel Tax Fund 344,668$ -$ 344,668$ 342,925$
Collects and spends resources from the
State motor fuel tax.
Infrastructure Fund (Major Fund)5,559,107$ 5,198,330$ 360,777$ (2,344,880)$
Accounts for construction and maintenance of
roadways, drainage, and safety path systems.
Promenade TIF Fund (Major Fund)249,347$ 485,138$ (235,791)$ (224,630)$
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)6,427,609$ 7,219,219$ (791,610)$ (3,827,190)$
Collects user fees for the distribution of water
and maintenance of infrastructure.
Sports Core Fund (Major Fund)2,490,268$ 1,737,035$ 753,233$ (485,170)$
Accounts for revenues and expenses relating
to administration, programs, food and beverage
operations, and golf course.
Golf Surcharge Fund 84,310$ -$ 84,310$ (137,425)$
Accounts for the collection of the $3 per round
golf surcharge.
Internal Service Funds
Self Insurance Fund 2,273,297$ 1,642,895$ 630,402$ 17,795$
Accounts for the Village's health insurance costs
and the related contributions from the Village,
employees, retirees, and other agencies.
Garage Fund 356,374$ 336,316$ 20,058$ (75,290)$
Accounts for the maintenance of the Village's vehicle
fleet and the related departmental reimbursements.
Equipment Replacement Fund 229,908$ 176,700$ 53,208$ (62,760)$
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 July 31, 2021
Village of Oak Brook
Monthly Financial Report – Fund Narrative
For the Period Ending July 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 July 2021 are $1,245,694, or 9.4%, higher than last July and $507,874, or
3.6%, over budget to date. The main drivers for this are:
o Sales Tax revenue, the General
Fund’s largest revenue source, is
up $714,000 from last year and
$712,412 over budget. July 2021
collections were the highest July
in the past five years despite
COVID-19 restrictions that were
in place during April 2020 and
2021.
o Other Intergovernmental Tax
revenue is up $346,074 from last
year and $383,696 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 $272,074 from last year and $334,662
under budget. The decrease relates to amended telecommunications tax returns that
were processed in 2021. We have also seen a decrease in tax revenue as a result of
remote working over the last year.
o Licenses and Permits revenue is up $227,819 from last year, but $91,158 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 $317,296 from last year, but $30,131 under budget.
Revenue is up due to certain revenue sources slowing down 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 $119,519 from last year and $61,519 under
budget. Investment return rates have dropped significantly since the beginning of the
COVID-19 pandemic.
Total expenditures through July 2021 are $1,000,006, or 7.4%, lower than last year and
$1,199,006, or 8.8%, under budget to date. The main drivers for this are:
o Personnel expenditures are down $928,635 from last year and $809,394 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 July 2021 are $35,241, or 9.2%, lower than last year, but $84,935, or
32.4%, over budget to date. The main drivers for this are:
o Hotel tax revenue is down $10,225 from last year, but $86,302 over budget. The
decrease in revenue is due to the effects of COVID-19 on the travel industry. Revenue
has come in higher than projections in 2021, but has yet to reach pre-pandemic levels.
Total expenditures through July 2021 are $371,636, or 82.2%, lower than last year and $83,413,
or 50.1%, 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 July 2021, the Hotel Tax Fund has transferred $2,080,078 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 July 2021 are up $204,484, or 6.6%, from last year and $151,936, or
4.8%, over budget. The main drivers for this are:
o Non-home rule sales tax revenue
is up $245,373 from last year
and $153,068 over budget. July
2021 collections were the
highest July in the past five years
despite COVID-19 restrictions
that were in place during April
2020 and 2021.
o Investment Interest revenue is
down $43,634 from last year and
$3,617 under budget.
Investment return rates have dropped significantly since the beginning of the COVID-19
pandemic.
Total expenditures through July 2021 are up $2,646,404, or 108.1%, from last year, but
$1,473,544, or 22.4%, under budget to date. The main drivers for this are:
o Personnel expenditures are up $77,686 from last year and $54,749 over budget. This is
due to multiple retirements and the related unused accrual time payouts.
o Operation and contract expenditures are down $122,257 from last year and $464,746
under budget. Expenditures are under budget due to the timing of engineering and
other miscellaneous payments.
o Capital Outlay expenditures are up $2,676,177 from last year, but $1,060,618 under
budget. Expenditures are up due to delays last year and general timing of work
performed.
Through July 2021, the Infrastructure Fund has received $2,080,078 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 July 2021 are up $7,774, or 3.2%, from last year and $3,977, or 1.6%,
over budget.
Total expenditures through July 2021 are down $48,427, or 9.1%, from last year and $15,138, 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 July 2021 are up $1,235,342, or 23.8%, from last year and $630,014, or
10.9%, over budget. The main drivers for this are:
o Water sales revenue is up $496,987 from last year, but $103,185 under budget. Water
gallons sold has been less than projected so far this year.
o Water connection fees revenue is up $175,010 from last year and $124,505 over
budget. This is due to construction on the Hines property and Restoration Hardware.
o Miscellaneous revenue is up $620,100 from last year and $602,879 over budget. This is
due to a payment related to the sale of non-corporate water lines.
Total expenditures through July 2021 are up $3,039,882, or 77.6%, from last year, but
$2,045,580, or 25.7%, under budget. The main drivers for this are:
o Operation and contract expenditures are up $138,086 from last year, but $894,536
under budget. Expenditures are under budget due to the timing of invoices paid and
DuPage Water Commission water purchased being less than expected.
o Capital outlay expenditures are up $2,829,147 from last year, but $1,519,426 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 July 2021 are up $967,209, or 64.5%, from last year and $497,930, or
25.3%, over budget to date. The main drivers for this are:
o Memberships revenue is up $131,178 from last year and $119,665 over budget. Golf
memberships have seen a significant increase in 2021 to some of the highest levels.
o Greens Fees revenue is up $258,981 from last year and $210,130 over budget. The
course did not see much activity in early 2020 due to COVID-19 restrictions.
o Driving Range Fees revenue is up $98,718 from last year and $78,383 over budget. This
is due to the golf course being able to open early and stay open this season.
o Food sales are up $93,236 from last year and $57,831 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 $139,586 from last year and $121,268 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 July 2021 are down $343,663, or 16.8%, from last year and
$1,040,472, or 38.0%, under budget to date. The main drivers for this are:
o Personnel expenditures are up $52,041 from last year, but $91,994 under budget.
Expenditures are up from last year due to the golf course being closed in spring 2020 for
COVID-19 restrictions. Personnel is under budget due to the poolside grille operations
and swim team not occurring in 2021. In addition, the Sports Core has had difficultly
filling open seasonal positions this season.
o Capital outlay expenditures are down $588,308 from last year and $811,030 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.
7/31/21 7/31/21
7/31/20 7/31/21 YTD % of YTD 2021 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 6,858,562$ 7,572,562$ 6,860,150$ 110.4%11,860,995$ 714,000$
Other Intergovernmental Tax*900,072 1,246,146 862,450 144.5%1,320,600 346,074
Telecommunications/Utility Tax 3,526,412 3,254,338 3,589,000 90.7%5,995,000 (272,074)
Licenses and Permits 1,009,593 1,237,412 1,328,570 93.1%2,180,360 227,819
Charges for Services 399,638 716,934 747,065 96.0%1,293,540 317,296
Fines and Penalties 93,855 96,696 105,315 91.8%180,500 2,841
Administrative Towing Fees 9,664 16,252 12,845 126.5%22,000 6,588
Investment Interest 233,000 113,481 175,000 64.8%300,000 (119,519)
Franchise Fees 55,794 56,400 101,000 55.8%202,000 606
Miscellaneous Income 214,160 236,223 257,175 91.9%463,380 22,063
Total Operating Revenues 13,300,750$ 14,546,444$ 14,038,570$ 103.6%23,818,375$ 1,245,694$
OPERATING EXPENDITURES
Personnel 11,069,881$ 10,141,246$ 10,950,640$ 92.6%18,842,080$ (928,635)$
Materials and Supplies 249,553 232,070 343,995 67.5%551,030 (17,483)
Operation and Contract 2,005,375 1,926,835 2,153,230 89.5%3,397,210 (78,540)
Other Expenditures 4,374 4,315 7,500 57.5%10,000 (59)
Capital Outlay 101,512 126,223 174,330 72.4%452,300 24,711
Total Operating Expenditures 13,430,695$ 12,430,689$ 13,629,695$ 91.2%23,252,620$ (1,000,006)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES (129,945)$ 2,115,755$ 408,875$ 565,755$ 2,245,700$
INTERFUND TRANSACTIONS
Transfers Out (326,369)$ -$ (100,000)$ 0.0%(100,000)$ 326,369$
Reimbursements From Other Funds 365,393 346,311 346,325 100.0%593,685 (19,082)
Reimbursements To Other Funds (81,529) (61,768) (61,775) 100.0%(105,885) 19,761
Total Interfund Transactions (42,505)$ 284,543$ 184,550$ 154.2%387,800$ 327,048$
NET FUND INCREASE (DECREASE)(172,450)$ 2,400,298$ 593,425$ 953,555$ 2,572,748$
*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 July 31, 2021
Total Total
Revenues Expenditures
7/31/21 Actual 14,546,444$ 12,430,689$
7/31/20 Actual 13,300,750$ 13,430,695$
% Change From Last Year 9.4%-7.4%
Major Revenues
Other Telecom/Utility Licenses &Charges for
Sales Tax Intergov. Tax Tax Permits Services
7/31/21 Actual 7,572,562$ 1,246,146$ 3,254,338$ 1,237,412$ 716,934$
7/31/20 Actual $ 6,858,562 $ 900,072 $ 3,526,412 $ 1,009,593 $ 399,638
% Change From Last Year 10.4%38.4%-7.7%22.6%79.4%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
7/31/21 Actual 10,141,246$ 232,070$ 1,926,835$ 4,315$ 126,223$
7/31/20 Actual 11,069,881$ 249,553$ 2,005,375$ 4,374$ 101,512$
% Change From Last Year -8.4%-7.0%-3.9%-1.3%24.3%
Five Year Trend
Expenditures by Department
7/31/20 7/31/21 7/31/21 7/31/21 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Department Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 1,159,693$ 1,292,891$ 1,421,635$ 90.9%2,498,625$ 133,198$
Financial Services 456,454 443,636 465,380 95.3%770,360 (12,818)
Public Works 417,462 575,281 550,695 104.5%948,860 157,819
Engineering & Capital Projects 31,899 24,639 54,000 45.6%209,000 (7,260)
Library 480,746 506,436 564,795 89.7%943,405 25,690
Police 5,466,115 4,964,687 5,439,150 91.3%9,213,585 (501,428)
Fire 4,833,768 4,061,441 4,480,245 90.7%7,576,045 (772,327)
Development Services 584,558 561,678 653,795 85.9%1,092,740 (22,880)
Total Expenditures 13,430,695$ 12,430,689$ 13,629,695$ 91.2%23,252,620$ (1,000,006)$
Five Year Trend
For the Period Ending July 31, 2021
General Fund - Five Year Trend
Village of Oak Brook
Revenues Expenditures
7/31/21 7/31/21
7/31/20 7/31/21 YTD % of YTD 2021 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Hotel Tax 331,177$ 320,952$ 234,650$ 136.8%414,000$ (10,225)$
Investment Interest 46,827 21,978 23,345 94.1%40,000 (24,849)
Loan Interest 4,167 4,000 4,000 100.0%8,000 (167)
Total Operating Revenues 382,171$ 346,930$ 261,995$ 132.4%462,000$ (35,241)$
EXPENDITURES
Operation and Contract 235,212$ 77,892$ 113,955$ 68.4%193,945$ (157,320)$
Capital Outlay 216,966 2,650 50,000 5.3%250,000 (214,316)
Total Expenditures 452,178$ 80,542$ 163,955$ 49.1%443,945$ (371,636)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES (70,007)$ 266,388$ 98,040$ 271.7%18,055$ 336,395$
INTERFUND TRANSACTIONS
Transfer Out -$ (2,080,078)$ (1,000,000)$ 208.0%(100,000)$ (2,080,078)$
Reimbursements to Other Funds (43,582) (49,049) (49,035) 100.0%(84,085) (5,467)
Total Interfund Transactions (43,582)$ (2,129,127)$ (1,049,035)$ 203.0%(184,085)$ (2,085,545)$
NET FUND INCREASE (DECREASE)(113,589)$ (1,862,739)$ (950,995)$ (166,030)$ (1,749,150)$
Note - Expenditures are recorded in program 171.
Village of Oak Brook
Hotel Tax Fund Financial Update
For the Period Ending July 31, 2021
Total Total
Revenues Expenditures
7/31/21 Actual $ 346,930 80,542$
7/31/20 Actual $ 382,171 452,178$
% Change From Last Year -9.2%-82.2%
Major Revenues Investment
Hotel Tax Interest Loan Interest Miscellaneous
7/31/21 Actual $ 320,952 $ 21,978 4,000$ -$
7/31/20 Actual $ 331,177 $ 46,827 4,167$ -$
% Change From Last Year -3.1%-53.1%-4.0%0.0%
Five Year Trend
Major Expenditures Operation &
Contractual Capital Outlay
7/31/21 Actual 77,892$ 2,650$
7/31/20 Actual 235,212$ 216,966$
% Change From Last Year -66.9%-98.8%
Five Year Trend
Village of Oak Brook
Hotel Tax Fund - Major Sources Five Year Trend
For the Period Ending July 31, 2021
Five Year Trend
Revenues Expenditures
7/31/21 7/31/21
7/31/20 7/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 3,017,270$ 3,262,643$ 3,109,575$ 104.9%5,333,500$ 245,373$
Charges for Services 335 - 595 0.0%1,000 (335)
Investment Interest 63,362 19,728 23,345 84.5%40,000 (43,634)
Miscellaneous - 3,080 - N/A - 3,080
Total Operating Revenues 3,080,967$ 3,285,451$ 3,133,515$ 104.8%5,374,500$ 204,484$
OPERATING EXPENDITURES
Personnel 786,308$ 863,994$ 809,245$ 106.8%1,386,115$ 77,686$
Materials and Supplies 122,803 137,601 140,530 97.9%245,660 14,798
Operation and Contract 786,796 664,539 1,129,285 58.8%1,892,905 (122,257)
Capital Outlay 753,175 3,429,352 4,489,970 76.4%8,956,170 2,676,177
Total Operating Expenditures 2,449,082$ 5,095,486$ 6,569,030$ 77.6%12,480,850$ 2,646,404$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 631,885$ (1,810,035)$ (3,435,515)$ 52.7%(7,106,350)$ (2,441,920)$
INTERFUND TRANSACTIONS
Transfers In 666,289$ 2,080,078$ 1,000,000$ 208.0%1,400,000$ 1,413,789$
Reimbursements From Other Funds 209,636 193,578 193,585 100.0%331,840 (16,058)
Reimbursements To Other Funds (94,675) (102,844) (102,950) 99.9%(176,300) (8,169)
Total Interfund Transactions 781,250$ 2,170,812$ 1,090,635$ 199.0%1,555,540$ 1,389,562$
NET FUND INCREASE (DECREASE)1,413,135$ 360,777$ (2,344,880)$ (5,550,810)$ (1,052,358)$
Village of Oak Brook
Infrastructure Fund Financial Update
For the Period Ending July 31, 2021
Total Total
Revenues Expenditures
7/31/21 Actual $ 3,285,451 5,095,486$
7/31/20 Actual $ 3,080,967 2,449,082$
% Change From Last Year 6.6%108.1%
Major Revenues
Sales Tax
Charges for
Services
Investment
Interest Miscellaneous
7/31/21 Actual $ 3,262,643 $ - $ 19,728 $ 3,080
7/31/20 Actual $ 3,017,270 $ 335 $ 63,362 $ -
% Change From Last Year 8.1%-100.0%-68.9%N/A
Five Year Trend
Major Expenditures Materials &Operation &
Personnel Supplies Contractual Capital Outlay
7/31/21 Actual 863,994$ 137,601$ 664,539$ 3,429,352$
7/31/20 Actual 786,308$ 122,803$ 786,796$ 753,175$
% Change From Last Year 9.9%12.1%-15.5%355.3%
Five Year Trend
Expenditures by Department
7/31/20 7/31/21 7/31/21 7/31/21 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 77,881$ 85,246$ 91,985$ 92.7%157,640$ 7,365$
Public Works 1,280,944 1,515,230 1,544,125 98.1%2,789,580 234,286
Engineering & Capital Projects 1,090,257 3,495,010 4,932,920 70.9%9,709,930 2,404,753
Total Expenditures 2,449,082$ 5,095,486$ 6,569,030$ 77.6%12,657,150$ 2,646,404$
Five Year Trend
Village of Oak Brook
Infrastructure Fund - Major Sources Five Year Trend
For the Period Ending July 31, 2021
Revenues Expenditures
7/31/21 7/31/21
7/31/20 7/31/21 YTD % of YTD 2021 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 33,825$ 45,088$ 44,775$ 100.7%75,000$ 11,263$
Real Estate Tax 207,272 204,228 200,000 102.1%400,000 (3,044)
Investment Interest 476 31 595 5.2%1,000 (445)
Total Operating Revenues 241,573$ 249,347$ 245,370$ 101.6%476,000$ 7,774$
EXPENDITURES
Operation and Contract 3,665$ 3,638$ 3,500$ 103.9%3,850$ (27)$
Other Expenditures 529,900 481,500 466,500 103.2%466,500 (48,400)
Total Expenditures 533,565$ 485,138$ 470,000$ 103.2%470,350$ (48,427)$
NET FUND INCREASE (DECREASE)(291,992)$ (235,791)$ (224,630)$ 5,650$ 56,201$
Note - Expenditures are recorded in program 283.
Village of Oak Brook
Promenade TIF Fund Financial Update
For the Period Ending July 31, 2021
Total Total
Revenues Expenditures
7/31/21 Actual $ 249,347 485,138$
7/31/20 Actual $ 241,573 533,565$
% Change From Last Year 3.2%-9.1%
Major Revenues Real Estate Investment
Sales Tax Tax Interest
7/31/21 Actual 45,088$ $ 204,228 $ 31
7/31/20 Actual 33,825$ $ 207,272 $ 476
% Change From Last Year 33.3%-1.5%-93.5%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures
7/31/21 Actual 3,638$ 481,500$
7/31/20 Actual 3,665$ 529,900$
% Change From Last Year -0.7%-9.1%
Five Year Trend
Village of Oak Brook
Promenade TIF Fund - Major Sources Five Year Trend
For the Period Ending July 31, 2021
Five Year Trend
Revenues Expenditures
7/31/21 7/31/21
7/31/20 7/31/21 YTD % of YTD 2021 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Plan Review Fees 300$ 450$ 595$ 75.6%1,000$ 150$
Building/Inspection Fees 5,062 2,775 4,095 67.8%7,000 (2,287)
Water Sales 5,019,828 5,516,815 5,620,000 98.2%10,597,000 496,987
Unmetered Sales 55,744 33,440 20,405 163.9%35,000 (22,304)
Water Connection Fees 7,840 182,850 58,345 313.4%100,000 175,010
Meter Charges 5,152 6,456 8,750 73.8%15,000 1,304
Special Services 12,657 13,333 12,500 106.7%25,000 676
Investment Interest 65,000 30,706 35,000 87.7%60,000 (34,294)
Miscellaneous 20,684 640,784 37,905 1690.5%65,000 620,100
Total Operating Revenues 5,192,267$ 6,427,609$ 5,797,595$ 110.9%10,905,000$ 1,235,342$
OPERATING EXPENDITURES
Personnel 457,164$ 495,581$ 489,195$ 101.3%842,235$ 38,417$
Materials and Supplies 13,609 47,841 45,845 104.4%75,780 34,232
Operation and Contract 2,120,178 2,258,264 3,152,800 71.6%5,379,925 138,086
Capital Outlay 1,325,592 4,154,739 5,674,165 73.2%8,103,750 2,829,147
Total Expenditures 3,916,543$ 6,956,425$ 9,362,005$ 74.3%14,401,690$ 3,039,882$
Surplus (Deficit) of Revenues Over
Expenditures 1,275,724$ (528,816)$ (3,564,410)$ 14.8%(3,496,690)$ (1,804,540)$
INTERFUND TRANSACTIONS
Reimbursements To Other Funds (307,307)$ (262,794)$ (262,780)$ 100.0%(450,500)$ 44,513$
Total Interfund Transactions (307,307)$ (262,794)$ (262,780)$ 100.0%(450,500)$ 44,513$
Fund Increase/(Decrease) - Budgetary Basis 968,417$ (791,610)$ (3,827,190)$ 20.7%(3,947,190)$ (1,760,027)$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay 1,325,592$ 4,154,739$
Depreciation Expense (320,077) (335,417)
IMRF Pension Expense (24,204) (26,250)
OPEB Expense 16,125 (17,500)
Total GAAP Adjustments 997,436$ 3,775,572$
Fund Increase/(Decrease) - GAAP Basis 1,965,853$ 2,983,962$
*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 July 31, 2021
Total Total
Revenues Expenditures
7/31/21 Actual $ 6,427,609 6,956,425$
7/31/20 Actual $ 5,192,267 3,916,543$
% Change From Last Year 23.8%77.6%
Unmetered Water
Water Sales Sales Connection Fees Meter Charges Miscellaneous
7/31/21 Actual $ 5,516,815 $ 33,440 $ 182,850 $ 6,456 $ 640,784
7/31/20 Actual $ 5,019,828 $ 55,744 $ 7,840 $ 5,152 $ 20,684
% Change From Last Year 9.9%-40.0%2232.3%25.3%2998.0%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
7/31/21 Actual 495,581$ 47,841$ 2,258,264$ -$ 4,154,739$
7/31/20 Actual 457,164$ 13,609$ 2,120,178$ -$ 1,325,592$
% Change From Last Year 8.4%251.5%6.5%0.0%213.4%
Five Year Trend
Expenditures by Department
7/31/20 7/31/21 7/31/21 7/31/21 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Public Works 2,599,725$ 2,788,437$ 3,699,505$ 75.4%6,317,940$ 188,712$
Engineering & Capital Projects 1,316,818 4,167,988 5,662,500 73.6%8,083,750 2,851,170
Total Expenditures 3,916,543$ 6,956,425$ 9,362,005$ 74.3%14,401,690$ 3,039,882$
Five Year Trend
Village of Oak Brook
Water Fund - Major Sources Five Year Trend
For the Period Ending July 31, 2021
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Sports Core Fund Consolidated Presentation
For the Period Ending July 31, 2021
7/31/21 7/31/21
7/31/21 YTD % of YTD 2021 7/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 -$ -$ -$ 358,165$ 358,165$ 238,500$ 150.2%238,500$ 226,987$ 131,178$
Greens Fees - - - 755,130 755,130 545,000 138.6%985,000 496,149 258,981
Pro Shop Sales - - - 159,089 159,089 131,500 121.0%207,000 91,431 67,658
Golf Lessons - - - 47,595 47,595 37,000 128.6%45,000 43,325 4,270
Driving Range Fees - - - 258,383 258,383 180,000 143.5%250,000 159,665 98,718
Rentals - 97,500 49,914 281,964 429,378 412,175 104.2%761,000 266,069 163,309
Programs/User Fees - - - - - 31,500 0.0%31,500 - -
Food Sales - - - 158,831 158,831 101,000 157.3%207,500 65,595 93,236
Beverage Sales - - - 286,768 286,768 165,500 173.3%382,000 147,182 139,586
Taste of Oak Brook - - - - - 120,000 0.0%120,000 - -
Grants - - - - - - 0.0%233,600 - -
Other Revenue 7,863 - - 5,728 13,591 6,825 199.1%7,700 3,318 10,273
Total Operating Revenues 7,863$ 97,500$ 49,914$ 2,311,653$ 2,466,930$ 1,969,000$ 125.3%3,468,800$ 1,499,721$ 967,209$
OPERATING EXPENDITURES
Personnel 13,469$ -$ 67,968$ 718,729$ 800,166$ 892,160$ 89.7%1,597,610$ 748,125$ 52,041$
Materials & Supplies 29,252 - 4,022 358,696 391,970 454,265 86.3%628,450 239,602 152,368
Operational & Contractual 49,486 6,458 32,062 215,686 303,692 378,845 80.2%663,035 263,456 40,236
Other - - - - - - 0.0%(39,000) - -
Capital 135,272 - 4,382 64,866 204,520 1,015,550 20.1%1,125,380 792,828 (588,308)
Total Operating Expenditures 227,479$ 6,458$ 108,434$ 1,357,977$ 1,700,348$ 2,740,820$ 62.0%3,975,475$ 2,044,011$ (343,663)$
B&T Administration Overhead Allocation*30,312$ -$ (30,312)$ -$ -$ -$ 0.0%-$ -$ -$
Operating Revenues Over (Under) Expenditures (189,304)$ 91,042$ (88,832)$ 953,676$ 766,582$ (771,820)$ -99.3%(506,675)$ (544,290)$ 1,310,872$
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 18,669 - - - 18,669 18,675 100.0%32,000 14,000 4,669
Reimbursement From Water Fund 4,669 - - - 4,669 4,670 100.0%8,000 4,669 -
Reimbursement To General Fund (9,170) - - (27,517) (36,687) (36,695) 100.0%(62,900) (32,928) (3,759)
Total Interfund Transactions 14,168$ -$ -$ (27,517)$ (13,349)$ 286,650$ -4.7%277,100$ 635,483$ (648,832)$
Total Revenues Over (Under) Expenditures - Budgetary Basis (175,136)$ 91,042$ (88,832)$ 926,159$ 753,233$ (485,170)$ (229,575)$ 91,193$ 662,040$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 135,272$ -$ 4,382$ 64,866$ 204,520$ 792,828$
Depreciation Expense (98,132) (983) (35,000) (143,675) (277,790) (226,965)
IMRF Pension Expense (1,196) - (1,750) (14,292) (17,238) (15,257)
OPEB Expense - - (1,750) (16,333) (18,083) (14,727)
Total GAAP Adjustments 35,944$ (983)$ (34,118)$ (109,434)$ (108,591)$ 535,880$
Fund Increase/(Decrease) - GAAP Basis (139,192)$ 90,059$ (122,950)$ 816,725$ 644,642$ 627,073$
*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
7/31/21 Actual $ 2,466,930 1,700,348$
7/31/20 Actual $ 1,499,721 2,044,011$
% Change From Last Year 64.5%-16.8%
Driving Program/
Memberships Greens Fees Range Fees Rentals User Fees
7/31/21 Actual $ 358,165 $ 755,130 $ 258,383 $ 429,378 -$
7/31/20 Actual $ 226,987 $ 496,149 $ 159,665 $ 266,069 -$
% Change From Last Year 57.8%52.2%61.8%61.4%0.0%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
7/31/21 Actual 800,166$ 391,970$ 303,692$ -$ 204,520$
7/31/20 Actual 748,125$ 239,602$ 263,456$ -$ 792,828$
% Change From Last Year 7.0%63.6%15.3%0.0%-74.2%
Five Year Trend
Revenues by Department 7/31/20 7/31/21 7/31/21 7/31/21 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Operations 511$ 7,863$ 77,225$ 10.2%325,800$ 7,352$
Open Field Operations 92,540 97,500 217,500 44.8%230,000 4,960
B&T Clubhouse Operations 14,223 49,914 97,000 51.5%267,000 35,691
Golf Club 1,392,447 2,311,653 1,577,275 146.6%2,646,000 919,206
Total Revenues 1,499,721$ 2,466,930$ 1,969,000$ 125.3%3,468,800$ 967,209$
Expenditures by Department 7/31/20 7/31/21 7/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 388,111$ 227,479$ 606,920$ 37.5%780,740$ (160,632)$
Open Field Operations 36,658$ 6,458$ 252,225$ 2.6%358,910$ (30,200)$
B&T Clubhouse Operations 101,506 108,434 150,365 72.1%262,635 6,928
Golf Club 1,517,736 1,357,977 1,731,310 78.4%2,573,190 (159,759)
Total Expenditures 2,044,011$ 1,700,348$ 2,740,820$ 62.0%3,975,475$ (343,663)$
Five Year Trend
Village of Oak Brook
Sports Core Fund - Major Sources Five Year Trend
For the Period Ending July 31, 2021
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Club Recreation Operations
For the Period Ending July 31, 2021 7/31/21 7/31/21
822 7/31/21 YTD % of YTD 2021 7/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 - - - - - 29,000 0.0%38,000 - -
Beverage Sales - - - - - 16,500 0.0%22,000 - -
Grants - - - - - - 0.0%233,600 - -
Other Revenue 7,863 - - - 7,863 225 3494.7%700 312 7,551
Total Operating Revenues 7,863$ -$ -$ -$ 7,863$ 77,225$ 10.2%325,800$ 511$ 7,352$
OPERATING EXPENDITURES
Personnel 13,045$ -$ -$ 424$ 13,469$ 77,985$ 17.3%119,110$ 2,680$ 10,789$
Materials & Supplies 457 22,733 2,460 3,602 29,252 33,580 87.1%37,250 2,149 27,103
Operational & Contractual 20,917 24,029 4,417 123 49,486 65,355 75.7%89,550 34,612 14,874
Capital 24,897 110,375 - - 135,272 430,000 31.5%534,830 348,670 (213,398)
Total Operating Expenditures 59,316$ 157,137$ 6,877$ 4,149$ 227,479$ 606,920$ 37.5%780,740$ 388,111$ (160,632)$
B&T Administration Overhead Allocation*60,623$ (21,824)$ (6,062)$ (2,425)$ 30,312$ 32,540$ 93.2%44,755$ 33,754$ (3,442)$
Operating Revenues Over (Under) Expenditures 9,170$ (178,961)$ (12,939)$ (6,574)$ (189,304)$ (497,155)$ 38.1%(410,185)$ (353,846)$ 164,542$
INTERFUND TRANSACTIONS
Transfer From General Fund -$ -$ -$ -$ -$ 100,000$ 0.0%100,000$ 326,369$ (326,369)$
Reimbursement From Infrastructure Fund 18,669 - - - 18,669 18,675 100.0%32,000 14,000 4,669
Reimbursement From Water Fund 4,669 - - - 4,669 4,670 100.0%8,000 4,669 -
Reimbursement To General Fund (9,170) - - - (9,170) (9,170) 100.0%(15,725) (16,464) 7,294
Total Interfund Transactions 14,168$ -$ -$ -$ 14,168$ 114,175$ 12.4%124,275$ 328,574$ (314,406)$
Total Revenues Over (Under) Expenditures - Budgetary Basis 23,338$ (178,961)$ (12,939)$ (6,574)$ (175,136)$ (382,980)$ (285,910)$ (25,272)$ (149,864)$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 24,897$ 110,375$ -$ -$ 135,272$ 348,670$
Depreciation Expense (37,543) (58,333) (1,575) (681) (98,132) (53,729)
IMRF Pension Expense (1,167) - - (29) (1,196) (653)
Total GAAP Adjustments (13,812)$ 52,042$ (1,575)$ (711)$ 35,944$ 294,288$
Fund Increase/(Decrease) - GAAP Basis 9,526$ (126,919)$ (14,514)$ (7,285)$ (139,192)$ 269,016$
*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 July 31, 2021 7/31/21 7/31/21
7/31/21 YTD % of YTD 2021 7/31/20 Difference
815 816 YTD Amended Amended Adopted YTD Prior
Polo Open Fields Total Budget Budget Budget Total Year
OPERATING REVENUES
Field Rentals -$ 17,500$ 17,500$ 17,500$ 100.0%30,000$ 17,540$ (40)$
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 - -
Other Revenue - - - - 0.0%- - -
Total Operating Revenues -$ 97,500$ 97,500$ 217,500$ 44.8%230,000$ 92,540$ 4,960$
OPERATING EXPENDITURES
Personnel -$ -$ -$ -$ 0.0%-$ -$ -$
Materials & Supplies - - - 300 0.0%500 119 (119)
Operational & Contractual - 6,458 6,458 83,875 7.7%190,360 27,829 (21,371)
Capital - - - 168,050 0.0%168,050 8,710 (8,710)
Total Operating Expenditures -$ 6,458$ 6,458$ 252,225$ 2.6%358,910$ 36,658$ (30,200)$
Operating Revenues Over (Under) Expenditures -$ 91,042$ 91,042$ (34,725)$ -262.2%(128,910)$ 55,882$ 35,160$
INTERFUND TRANSACTIONS
Transfer From Hotel Tax Fund -$ -$ -$ -$ 0.0%-$ -$ -$
Total Interfund Transactions -$ -$ -$ -$ 0.0%-$ -$ -$
Total Revenues Over (Under) Expenditures - Budgetary Basis -$ 91,042$ 91,042$ (34,725)$ (128,910)$ 55,882$ 35,160$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay -$ -$ -$ 8,710$
Depreciation Expense - (983) (983) (983)
Total GAAP Adjustments -$ (983)$ (983)$ 7,727$
Fund Increase/(Decrease) - GAAP Basis -$ 90,059$ 90,059$ 63,609$
*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 July 31, 2021
7/31/21 7/31/21
821 YTD % of YTD 2021 7/31/20 Difference
B&T Amended Amended Adopted YTD Prior
Clubhouse Budget Budget Budget Total Year
OPERATING REVENUES
Rentals 49,914$ 97,000$ 51.5%267,000$ 14,223$ 35,691$
Total Operating Revenues 49,914$ 97,000$ 51.5%267,000$ 14,223$ 35,691$
OPERATING EXPENDITURES
Personnel 67,968$ 75,735$ 89.7%133,585$ 63,814$ 4,154$
Materials & Supplies 4,022 7,305 55.1%12,000 1,540 2,482
Operational & Contractual 32,062 62,825 51.0%107,550 36,152 (4,090)
Capital 4,382 4,500 97.4%9,500 - 4,382
Total Operating Expenditures 108,434$ 150,365$ 72.1%262,635$ 101,506$ 6,928$
B&T Administration Overhead Allocation*(30,312)$ (32,540)$ 93.2%(44,755)$ (33,754)$ 3,442$
Operating Revenues Over (Under) Expenditures (88,832)$ (85,905)$ 103.4%(40,390)$ (121,037)$ 32,205$
INTERFUND TRANSACTIONS
Transfer From General Fund -$ -$ 0.0%-$ -$ -$
Total Interfund Transactions -$ -$ 0.0%-$ -$ -$
Total Revenues Over (Under) Expenditures - Budgetary Basis (88,832)$ (85,905)$ (40,390)$ (121,037)$ 32,205$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 4,382$ -$
Depreciation Expense (35,000) (35,324)
IMRF Pension Expense (1,750) (1,209)
OPEB Expense (1,750) (1,542)
Total GAAP Adjustments (34,118)$ (38,075)$
Fund Increase/(Decrease) - GAAP Basis (122,950)$ (159,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
Golf Club Programs
For the Period Ending July 31, 2021
7/31/21 7/31/21
823 831 832 833 834 7/31/21 YTD % of YTD 2021 7/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 -$ 358,165$ -$ -$ -$ 358,165$ 238,500$ 150.2%238,500$ 226,788$ 131,377$
Greens Fees - 755,130 - - - 755,130 545,000 138.6%985,000 496,149 258,981
Pro Shop Sales - 159,089 - - - 159,089 131,500 121.0%207,000 91,431 67,658
Golf Lessons - - 47,595 - - 47,595 37,000 128.6%45,000 43,325 4,270
Driving Range Fees - - 258,383 - - 258,383 180,000 143.5%250,000 159,665 98,718
Rentals - 1,420 - 280,544 - 281,964 217,675 129.5%384,000 159,306 122,658
Food Sales 158,831 - - - - 158,831 72,000 220.6%169,500 65,595 93,236
Beverage Sales 286,768 - - - - 286,768 149,000 192.5%360,000 147,182 139,586
Other Revenue - 5,728 - - - 5,728 6,600 86.8%7,000 3,006 2,722
Total Operating Revenues 445,599$ 1,279,532$ 305,978$ 280,544$ -$ 2,311,653$ 1,577,275$ 146.6%2,646,000$ 1,392,447$ 919,206$
OPERATING EXPENDITURES
Personnel 134,212$ 308,461$ 21,211$ 26,473$ 228,372$ 718,729$ 738,440$ 97.3%1,344,915$ 681,631$ 37,098$
Materials & Supplies 164,666 89,078 9,419 735 94,798 358,696 413,080 86.8%578,700 235,794 122,902
Operational & Contractual 3,505 164,037 799 27,915 19,430 215,686 166,790 129.3%275,575 164,863 50,823
Other - - - - - - - 0.0%(39,000) - -
Capital - 13,296 - - 51,570 64,866 413,000 15.7%413,000 435,448 (370,582)
Total Operating Expenditures 302,383$ 574,872$ 31,429$ 55,123$ 394,170$ 1,357,977$ 1,731,310$ 78.4%2,573,190$ 1,517,736$ (159,759)$
Operating Revenues Over (Under) Expenditures 143,216$ 704,660$ 274,549$ 225,421$ (394,170)$ 953,676$ (154,035)$ -619.1%72,810$ (125,289)$ 1,078,965$
INTERFUND TRANSACTIONS
Transfer from Golf Surcharge -$ -$ -$ -$ -$ 200,000$ 0.0%200,000$ 323,373$ (323,373)$
Reimbursement to General Fund - (27,517) - - (27,517) (27,525) 100.0%(47,175) (16,464) (11,053)
Total Interfund Transactions -$ (27,517)$ -$ -$ -$ (27,517)$ 172,475$ -16.0%152,825$ 306,909$ (334,426)$
Total Revenues Over (Under) Expenditures - Budgetary Basis 143,216$ 677,143$ 274,549$ 225,421$ (394,170)$ 926,159$ 18,440$ 225,635$ 181,620$ 744,539$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay -$ 13,296$ -$ -$ 51,570$ 64,866$ 435,448$
Depreciation Expense (583) (61,250) (1,342) (7,583) (72,917) (143,675) (136,929)
IMRF Pension Expense (1,458) (5,833) (583) - (6,417) (14,292) (13,395)
OPEB Expense (1,750) (8,750) - - (5,833) (16,333) (13,185)
Total GAAP Adjustments (3,792)$ (62,537)$ (1,925)$ (7,583)$ (33,597)$ (109,434)$ 271,940$
Fund Increase/(Decrease) - GAAP Basis 139,424$ 614,606$ 272,624$ 217,838$ (427,767)$ 816,725$ 453,560$
*Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.