05 - May 2021 Monthly Financial ReportVILLAGE
OAK BROOK
OF
MONTHLY FINANCIAL REPORTS
MAY 2021
ITEM 6.E
Cash and Investments by Fund:Total
Cash and Cash Pooled Cash and
Fund Equivalents Investments Investments % By Fund
General Corporate $12,416,538 $13,832,882 $26,249,420 57.5%
Hotel/Motel Tax 546,665 2,723,799 3,270,464 7.2%
Motor Fuel Tax 937,615 28,503 966,118 2.1%
Infrastructure 4,552,520 2,312,644 6,865,164 15.0%
Promenade TIF 63,285 - 63,285 0.1%
Water 2,636,827 3,737,285 6,374,112 14.0%
Sports Core 463,582 - 463,582 1.0%
Golf Surcharge 170,927 - 170,927 0.4%
Self-Insurance 243,834 - 243,834 0.5%
Garage 292,292 - 292,292 0.6%
Equipment Replacement 306,564 421,437 728,001 1.6%
Total $22,630,649 $23,056,550 $45,687,199 100.0%
Change in Cash and Investments by Fund :
Balance at Balance at Year-to-Date Year-to-Date
Fund January 1, 2021 May 31, 2021 Change ($)Change (%)
General Corporate $23,894,312 $26,249,420 $2,355,108 9.9%
Hotel/Motel Tax 4,567,176 3,270,464 (1,296,712)-28.4%
Motor Fuel Tax 673,455 966,118 292,663 43.5%
Infrastructure 7,480,975 6,865,164 (615,811)-8.2%
Promenade TIF 267,300 63,285 (204,015)-76.3%
Water 6,900,169 6,374,112 (526,057)-7.6%
Sports Core 114,133 463,582 349,449 306.2%
Golf Surcharge 132,593 170,927 38,334 28.9%
Self-Insurance 0 243,834 243,834 N/A
Garage 298,348 292,292 (6,056)-2.0%
Equipment Replacement 696,392 728,001 31,609 4.5%
$45,024,853 $45,687,199 $662,346 1.5%
Book Bank/Market
Value Value
Cash and Cash Equivalents:
Pooled Checking $797,975 $1,935,304
Sports Core Checking 642,623 546,881
Pooled IPTIP 20,626,814 20,626,814
Water E-Pay IPTIP 563,237 532,342
$22,630,649 $23,641,341
Pooled Investments:
Investments-Municipal Bonds $10,111,986 $10,172,880
Investments-Corporate Bonds 8,389,871 8,421,892
Government & Agency Obligations 1,149,222 1,166,607
Certificates of Deposit 3,185,000 3,205,391
Accrued Interest 220,472 220,472
Total Pooled Investments $23,056,550 $23,187,242
Total Cash and Investments $45,687,199 $46,828,583
For May, total interest revenue is $25,905 and YTD is $140,031. The total investment yield for the portfolio is:
Pooled
Investments Illinois Funds Total
Last 12 months yield 1.67%0.14%0.96%
The weighted average yield of the current investment portfolio is 1.33%. The IL Funds April average daily rate was 0.035%.
Monthly Treasurer's Report
May 31, 2021
Monthly Treasurer's Report
May 2021
The table below lists the detail investment holdings at J.P. Morgan Securities as of 5/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,472 510,575 1,090
Connecticut St GO Bds 2016 #20772J3F7 06/15/17 08/15/21 1.750%2.300%499,465 501,650 2,523
State of IL #452152P54 10/09/19 11/01/21 5.000%1.870%506,513 509,755 1,832
Brownsville TX #16405ST9 12/19/19 02/15/22 2.050%2.000%555,184 561,521 3,192
Laredo TX Waterworks #517039VW0 12/19/19 03/01/24 2.230%2.230%455,000 475,502 2,480
Oakland Univ Mich #673588HJ1 04/29/20 03/01/24 5.000%1.650%321,419 331,907 3,688
Philadelphia PA GO Ref #717813SW0 05/05/20 08/01/22 5.000%1.820%404,315 411,984 6,297
Maryland St DOT #574204WG4 05/06/20 06/15/22 4.350%1.200%268,488 271,011 5,099
University of CA #91412HFK4 07/16/20 05/15/23 0.628%0.628%25,000 25,185 7
Windsor NY Sch Dist #973675EW7 07/23/02 06/17/21 1.500%0.400%475,212 475,223 6,110
Waterford Mich Sch Dist #941468YZ7 08/20/20 08/24/21 4.000%0.301%504,255 504,120 15,591
Universty of IL #914353YH4 08/31/20 10/01/21 3.000%0.701%251,904 252,195 1,250
New Jersey St #646039UD7 09/20/20 06/01/22 5.000%0.600%495,840 497,781 11,809
Alaska St GO #011770Z72 10/14/2020 8/1/2021 5.000%0.252%176,404 176,404 2,892
Rio Rancho NM #767175HM7 10/14/2020 5/15/2022 5.000%0.350%193,218 193,569 385
Cook, Kane, Lake, & McHenry #216181GL5 10/29/2020 12/15/2022 4.000%0.300%1,083,169 1,087,064 24,137
Miami-Dade Cnty #59333NN90 11/16/2020 12/15/2022 0.375%0.430%734,259 735,301 444
Hamilton NY #407741MC8 1/21/2021 5/1/2023 1.000%0.550%206,761 206,513 159
Southern Cal Pub Pwr #84247PHZ7 1/25/2021 4/1/2024 3.608%0.500%1,095,130 1,091,830 14,833
Hillsborough Cnty FL #43232VV3 3/11/2021 7/1/2024 1.815%0.770%515,925 515,020 3,706
Port Auth of NY and NJ #73358WAH7 4/15/2021 12/1/2024 5.859%0.600%591,070 588,860 14,485
City of Atlanta GA Water #047870SG6 4/19/2021 11/1/2024 0.616%0.500%250,982 249,910 111
Total Municipal Bonds $10,111,986 $10,172,880 $122,122
Corporate Bonds:
Morgan Stanley #61747WAL3 03/08/19 07/28/21 5.500%3.034%1,053,721 1,058,573 19,571
Citigroup #172967LC3 04/01/19 12/08/21 2.900%2.754%1,000,838 1,011,760 13,372
American Honda #02665WBG5 07/31/19 09/09/21 1.700%2.180%499,376 502,111 1,959
JP Morgan #48128BAB7 09/30/19 01/15/23 2.972%2.337%1,009,995 1,016,551 11,228
American Express #025816CD9 05/05/20 05/20/22 2.750%1.290%507,062 511,290 277
Goldman Sachs #38141GGQ1 08/31/20 07/27/21 5.250%0.251%347,674 347,666 6,239
PNC Bank #69349LAK4 12/7/2020 1/30/2023 2.950%0.457%1,062,083 1,062,182 10,030
Wells Fargo #94974BFJ4 12/7/2020 2/13/2023 3.450%0.480%1,459,695 1,462,856 14,253
Comerica Bank #200340AS6 12/23/2020 7/31/2023 3.700%0.500%534,426 533,784 6,167
Bank of America #06048WM23 5/14/2021 5/14/2024 0.650%0.650%915,000 915,119 248
Total Corporate Bonds $8,389,871 $8,421,892 $83,343
Government & Agency Obligations:
*Government National Mtg Assn #38379UEM4 02/29/16 02/16/51 2.300%2.245%$316,769 $307,830 $707
*Government National Mtg Assn #38381WV96 08/06/19 07/20/54 2.250%2.293%391,115 401,886 612
*Government National Mtg Assn #38380BNV3 12/05/19 06/20/46 2.000%2.112%441,337 456,891 632
Total Government & Agency Obligations:$1,149,222 $1,166,607 $1,950
Certificates of Deposit:
State Bk India NY #8562846A7 01/26/17 01/26/22 2.250%2.250%$245,000 $248,591 $1,900
Morgan Stanley #61760AE21 05/30/19 06/01/21 2.400%2.400%245,000 245,064 2,940
First St Bank DeQueen #336460CU2 07/18/19 07/19/21 2.000%2.000%245,000 245,695 193
Bank Hapoalim #06251AW89 07/19/19 07/19/21 2.000%2.000%245,000 245,730 1,922
Capital One Natl Assn #14042RMF5 07/24/19 07/26/19 2.050%2.050%245,000 245,809 1,849
TIAA FSB Jacksonville #87270LCN1 07/29/19 07/29/21 2.000%2.000%245,000 245,828 1,641
Wells Fargo #949763J31 09/18/19 09/20/21 1.850%1.850%245,000 246,391 193
BMW Bank #05580ASQ8 10/11/19 10/12/21 1.800%1.800%245,000 246,639 545
Wells Fargo #949495AN5 01/17/20 01/18/22 1.800%1.800%245,000 247,764 192
Bank Leumi #063248KQ0 03/31/20 03/31/22 1.250%1.250%245,000 247,492 510
Capital One Natl Assn #14042TCZ8 04/01/20 04/01/22 1.350%1.350%245,000 247,691 542
Synchrony Bank #87164WZN1 04/03/20 04/04/22 1.350%1.350%245,000 247,714 524
Wells Fargo #95001DAB6 06/17/20 06/17/23 1.200%1.200%245,000 244,983 106
Total Certificates of Deposits $3,185,000 $3,205,391 $13,057
Total J.P.Morgan Securities $22,836,078 $22,966,770 $220,472
*This is a mortgage backed security that receives principal payments each month based on mortgage repayments. Monthly principal payments will vary and the
investment balance may be repaid before the maturity date.
VILLAGE OF OAK BROOK
Monthly Treasurer's Report
May 31, 2021
Cash & Investments by Fund - Total $45.7 million
Cash & Investments by Type - Total $45.7 million
Checking
Illinois Funds
Certificates of Deposit
Municipal Bonds
Corporate Bonds
Government & Agency Obligations
Accrued Interest
General Corporate
57.5%
Hotel/Motel Tax
7.2%Motor Fuel Tax
2.1%
Infrastructure
15.0%
Promenade TIF
0.1%
Water
14.0%
Sports Core
1.0%
Golf Surcharge
0.4%
Self-Insurance
0.5%
Garage
0.6%
Equipment
Replacement
1.6%
Checking, $1.4
Illinois Funds, $21.2
Certificates of Deposit,
$3.2
Municipal Bonds,
$10.1
Corporate Bonds, $8.4
Government & Agency
Obligations, $1.2
Accrued Interest, $0.2
in millions
YTD YTD
Net Fund Budgeted
YTD YTD Increase Increase
Governmental Funds Revenues Expenditures (Decrease)(Decrease)
General Fund (Major Fund)10,595,757$ 8,571,419$ 2,024,338$ 937,955$
Main operating fund of the Village.
Hotel Fund (Major Fund)200,491$ 1,524,227$ (1,323,736)$ 11,835$
Collects and spends resources from the
3% hotel/motel tax.
Motor Fuel Tax Fund 292,358$ -$ 292,358$ 206,835$
Collects and spends resources from the
State motor fuel tax.
Infrastructure Fund (Major Fund)3,925,900$ 3,859,006$ 66,894$ (1,759,825)$
Accounts for construction and maintenance of
roadways, drainage, and safety path systems.
Promenade TIF Fund (Major Fund)26,736$ 230,750$ (204,014)$ (195,875)$
Accounts for the revenues and expenditures
restricted to the Tax Increment Financing (TIF)
district located at 22nd St. and Meyers Rd.
Enterprise Funds
Water Fund (Major Fund)4,112,750$ 3,906,120$ 206,630$ (3,849,230)$
Collects user fees for the distribution of water
and maintenance of infrastructure.
Sports Core Fund (Major Fund)1,453,264$ 953,226$ 500,038$ (402,750)$
Accounts for revenues and expenses relating
to administration, programs, food and beverage
operations, and golf course.
Golf Surcharge Fund 38,334$ -$ 38,334$ (172,595)$
Accounts for the collection of the $3 per round
golf surcharge.
Internal Service Funds
Self Insurance Fund 1,719,613$ 1,277,924$ 441,689$ 12,515$
Accounts for the Village's health insurance costs
and the related contributions from the Village,
employees, retirees, and other agencies.
Garage Fund 254,686$ 257,266$ (2,580)$ (47,335)$
Accounts for the maintenance of the Village's vehicle
fleet and the related departmental reimbursements.
Equipment Replacement Fund 139,814$ 104,722$ 35,092$ (44,820)$
Accounts for the replacement of the Village's vehicle
fleet and the related departmental contributions.
Further information on the Village's major funds (as indicated above) can be found on the proceeding pages.
Executive Summary on Village Funds
Through May 31, 2021
Village of Oak Brook
Monthly Financial Report – Fund Narrative
For the Period Ending May 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 May 2021 are $51,337, or 0.5%, lower than last May, but $163,647, or
1.6%, over budget to date. The main drivers for this are:
o Sales Tax revenue, the General
Fund’s largest revenue source, is
down $314,692 from last year,
but $323,796 over budget. May
2021 collections were consistent
with the past five years despite
current COVID-19 restrictions.
o Other Intergovernmental Tax
revenue is up $221,603 from last
year and $245,124 over budget.
Receipts from Income Tax,
Replacement Tax, and Use Tax have been stronger than projected to date.
o Telecommunications/Utility Tax revenue is down $247,742 from last year and $275,127
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 Charges for Services revenue is up $32,934 from last year, but $85,576 under budget.
This is due to a decrease in billable auxiliary police services and a decrease in billable
ambulance revenue to date. Amounts can vary from year to year due to the timing of
billing requests.
o Investment Interest revenue is down $90,798 from last year and $40,972 under budget.
Investment return rates have dropped significantly since the beginning of the COVID-19
pandemic.
Total expenditures through May 2021 are $849,719, or 9.1%, lower than last year and $822,741,
or 8.8%, under budget to date. The main drivers for this are:
o Personnel expenditures are down $760,527 from last year and $516,996 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 May 2021 are $131,001, or 39.5%, lower than last year, but $28,666, or
16.7%, over budget to date. The main drivers for this are:
o Hotel tax revenue is down $114,724 from last year, but $25,055 over budget. The
decrease in revenue is due to the effects of COVID-19 on the travel industry.
Total expenditures through May 2021 are $415,180, or 94.0%, lower than last year and $98,691,
or 79.0%, under budget. Major expenditures from the Hotel Tax Fund have not occurred yet in
2021 as many initiatives have been put on hold due to the lack of revenue.
Infrastructure Fund
Total revenues through May 2021 are down $282,195, or 10.8%, from last year, but $18,012, or
0.8%, over budget. The main drivers for this are:
o Non-home rule sales tax revenue
is down $247,055 from last year,
but $17,783 over budget. May
2021 collections were consistent
with the past five years despite
current COVID-19 restrictions.
o Investment Interest revenue is
down $37,885 from last year and
$2,426 under budget.
Investment return rates have
dropped significantly since the
beginning of the COVID-19 pandemic.
Total expenditures through May 2021 are up $2,390,224, or 171.3%, from last year, but
$345,644, or 8.4%, under budget to date. The main drivers for this are:
o Personnel expenditures are down $14,158 from last year and $5,945 under budget. The
decrease is due to two payroll cycles in January 2021 vs. three payroll cycles in January
2020.
o Operation and contract expenditures are down $150,072 from last year and $352,235
under budget. Expenditures are under budget due to the timing of engineering and
other miscellaneous payments.
o Capital Outlay expenditures are up $2,506,602 from last year, but $5,850 under budget.
Expenditures are up due to delays last year and general timing of work performed.
Promenade TIF Fund
Total revenues through May 2021 are up $1,425, or 5.6%, from last year, but $6,389, or 19.3%,
under budget. Revenues are under budget due to the timing of Department of Revenue
information to record the TIF sale tax transfer.
Total expenditures through May 2021 are down $35,745, or 13.4%, from last year, but $1,750,
or 0.8%, over budget. The decrease relates to less principal and interest paid towards the TIF
note. Expenditures are over budget due to the timing of audit services invoices.
Water Fund
Total revenues through May 2021 are up $628,147, or 18.0%, from last year and $157,325, or
4.0%, over budget. The main drivers for this are:
o Water sales revenue is down $35,100 from last year and $500,485 under budget. Water
gallons sold has also been less than projected so far this year.
o Miscellaneous revenue is up $608,467 from last year and $602,081 over budget. This is
due to a payment related to the sale of non-corporate water lines.
Total expenditures through May 2021 are up $1,241,619, or 50.1%, from last year, but
$3,898,545, or 51.2%, under budget. The main drivers for this are:
o Operation and contract expenditures are up $12,842 from last year, but $993,404 under
budget. Expenditures are under budget due to the timing of invoices paid and DuPage
Water Commission water purchased being less than expected.
o Capital outlay expenditures are up $1,220,746 from last year, but $2,879,284 under
budget. Capital projects will occur later in 2021 as planned.
Sports Core Fund
Total revenues through May 2021 are up $962,468, or 203.0%, from last year and $519,994, or
56.7%, over budget to date. The main drivers for this are:
o Memberships revenue is up $157,951 from last year and $134,950 over budget. Golf
memberships have nearly doubled the 2020 total through May.
o Greens Fees revenue is up $260,193 from last year and $117,114 over budget. The
course did not see much activity last spring due to COVID-19 restrictions.
o Driving Range Fees revenue is up $116,396 from last year and $56,968 over budget.
This is due to the golf course being able to open early and stay open this season.
o Food sales are up $64,285 from last year and $54,837 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 $110,819 from last year and $107,110 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 May 2021 are down $419,141, or 31.1%, from last year and
$682,789, or 42.4%, under budget to date. The main drivers for this are:
o Capital outlay expenditures are down $627,209 from last year and $564,673 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.
5/31/21 5/31/21
5/31/20 5/31/21 YTD % of YTD 2021 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 5,691,688$ 5,376,996$ 5,053,200$ 106.4%11,860,995$ (314,692)$
Other Intergovernmental Tax*661,171 882,774 637,650 138.4%1,320,600 221,603
Telecommunications/Utility Tax 2,576,615 2,328,873 2,604,000 89.4%5,995,000 (247,742)
Licenses and Permits 635,498 963,115 895,895 107.5%2,180,360 327,617
Charges for Services 379,965 412,899 498,475 82.8%1,293,540 32,934
Fines and Penalties 67,959 69,937 75,225 93.0%180,500 1,978
Administrative Towing Fees 8,164 11,669 9,175 127.2%22,000 3,505
Investment Interest 174,826 84,028 125,000 67.2%300,000 (90,798)
Franchise Fees 51,448 52,636 101,000 52.1%202,000 1,188
Miscellaneous Income 152,395 165,465 185,125 89.4%463,380 13,070
Total Operating Revenues 10,399,729$ 10,348,392$ 10,184,745$ 101.6%23,818,375$ (51,337)$
OPERATING EXPENDITURES
Personnel 7,573,936$ 6,813,409$ 7,330,405$ 92.9%18,842,080$ (760,527)$
Materials and Supplies 176,919 168,480 254,185 66.3%551,030 (8,439)
Operation and Contract 1,538,882 1,439,008 1,633,520 88.1%3,397,210 (99,874)
Other Expenditures 4,374 4,315 5,000 86.3%10,000 (59)
Capital Outlay 82,907 102,087 126,930 80.4%452,300 19,180
Total Operating Expenditures 9,377,018$ 8,527,299$ 9,350,040$ 91.2%23,252,620$ (849,719)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 1,022,711$ 1,821,093$ 834,705$ 565,755$ 798,382$
INTERFUND TRANSACTIONS
Transfers Out (326,369) -$ (100,000)$ 0.0%(100,000)$ 326,369$
Reimbursements From Other Funds 260,995 247,365 247,375 100.0%593,685 (13,630)
Reimbursements To Other Funds (58,235) (44,120) (44,125) 100.0%(105,885) 14,115
Sports Core Loan (150,660) - - 0.0%- 150,660
Total Interfund Transactions (274,269)$ 203,245$ 103,250$ 196.8%387,800$ 477,514$
NET FUND INCREASE (DECREASE)748,442$ 2,024,338$ 937,955$ 953,555$ 1,275,896$
*Includes the collection of Income Tax, Use Tax, Road & Bridge Tax, Personal Property Replacement Tax, and Cannabis Use Tax.
Village of Oak Brook
General Fund Financial Update
For the Period Ending May 31, 2021
Total Total
Revenues Expenditures
5/31/21 Actual 10,348,392$ 8,527,299$
5/31/20 Actual 10,399,729$ 9,377,018$
% Change From Last Year -0.5%-9.1%
Major Revenues
Other Telecom/Utility Licenses &Charges for
Sales Tax Intergov. Tax Tax Permits Services
5/31/21 Actual 5,376,996$ 882,774$ 2,328,873$ 963,115$ 412,899$
5/31/20 Actual $ 5,691,688 $ 661,171 $ 2,576,615 $ 635,498 $ 379,965
% Change From Last Year -5.5%33.5%-9.6%51.6%8.7%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
5/31/21 Actual 6,813,409$ 168,480$ 1,439,008$ 4,315$ 102,087$
5/31/20 Actual 7,573,936$ 176,919$ 1,538,882$ 4,374$ 82,907$
% Change From Last Year -10.0%-4.8%-6.5%-1.3%23.1%
Five Year Trend
Expenditures by Department
5/31/20 5/31/21 5/31/21 5/31/21 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Department Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 844,459$ 930,743$ 1,050,850$ 88.6%2,498,625$ 86,284$
Financial Services 324,768 306,827 321,590 95.4%770,360 (17,941)
Public Works 283,922 368,143 387,760 94.9%948,860 84,221
Engineering & Capital Projects 21,633 7,232 34,000 21.3%209,000 (14,401)
Library 345,690 340,045 379,555 89.6%943,405 (5,645)
Police 3,856,136 3,343,066 3,648,595 91.6%9,213,585 (513,070)
Fire 3,280,473 2,839,353 3,076,405 92.3%7,576,045 (441,120)
Development Services 419,937 391,890 451,285 86.8%1,092,740 (28,047)
Total Expenditures 9,377,018$ 8,527,299$ 9,350,040$ 91.2%23,252,620$ (849,719)$
Five Year Trend
For the Period Ending May 31, 2021
General Fund - Five Year Trend
Village of Oak Brook
Revenues Expenditures
5/31/21 5/31/21
5/31/20 5/31/21 YTD % of YTD 2021 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Hotel Tax 294,929$ 180,205$ 155,150$ 116.1%414,000$ (114,724)$
Investment Interest 36,563 16,286 16,675 97.7%40,000 (20,277)
Loan Interest - 4,000 - 0.0%8,000 4,000
Total Operating Revenues 331,492$ 200,491$ 171,825$ 116.7%462,000$ (131,001)$
EXPENDITURES
Operation and Contract 224,488$ 26,274$ 74,965$ 35.0%193,945$ (198,214)$
Capital Outlay 216,966 - 50,000 0.0%250,000 (216,966)
Total Expenditures 441,454$ 26,274$ 124,965$ 21.0%443,945$ (415,180)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES (109,962)$ 174,217$ 46,860$ 371.8%18,055$ 284,179$
INTERFUND TRANSACTIONS
Transfer Out -$ (1,462,918)$ -$ 0.0%(100,000)$ (1,462,918)$
Reimbursements to Other Funds (31,130) (35,035) (35,025) 100.0%(84,085) (3,905)
Total Interfund Transactions (31,130)$ (1,497,953)$ (35,025)$ 4276.8%(184,085)$ (1,466,823)$
NET FUND INCREASE (DECREASE)(141,092)$ (1,323,736)$ 11,835$ (166,030)$ (1,182,644)$
Note - Expenditures are recorded in program 171.
Village of Oak Brook
Hotel Tax Fund Financial Update
For the Period Ending May 31, 2021
Total Total
Revenues Expenditures
5/31/21 Actual $ 200,491 26,274$
5/31/20 Actual $ 331,492 441,454$
% Change From Last Year -39.5%-94.0%
Major Revenues Investment
Hotel Tax Interest Loan Interest Miscellaneous
5/31/21 Actual $ 180,205 $ 16,286 4,000$ -$
5/31/20 Actual $ 294,929 $ 36,563 -$ -$
% Change From Last Year -38.9%-55.5%N/A 0.0%
Five Year Trend
Major Expenditures Operation &
Contractual Capital Outlay
5/31/21 Actual 26,274$ -$
5/31/20 Actual 224,488$ 216,966$
% Change From Last Year -88.3%-100.0%
Five Year Trend
Village of Oak Brook
Hotel Tax Fund - Major Sources Five Year Trend
For the Period Ending May 31, 2021
Five Year Trend
Revenues Expenditures
5/31/21 5/31/21
5/31/20 5/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 2,554,438$ 2,307,383$ 2,289,600$ 100.8%5,333,500$ (247,055)$
Charges for Services 335 - 425 0.0%1,000 (335)
Investment Interest 52,134 14,249 16,675 85.5%40,000 (37,885)
Miscellaneous - 3,080 - N/A - 3,080
Total Operating Revenues 2,606,907$ 2,324,712$ 2,306,700$ 100.8%5,374,500$ (282,195)$
OPERATING EXPENDITURES
Personnel 564,268$ 550,110$ 556,055$ 98.9%1,386,115$ (14,158)$
Materials and Supplies 85,354 133,206 114,820 116.0%245,660 47,852
Operation and Contract 606,662 456,590 808,825 56.5%1,892,905 (150,072)
Capital Outlay 139,038 2,645,640 2,651,490 99.8%8,956,170 2,506,602
Total Operating Expenditures 1,395,322$ 3,785,546$ 4,131,190$ 91.6%12,480,850$ 2,390,224$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 1,211,585$ (1,460,834)$ (1,824,490)$ 80.1%(7,106,350)$ (2,672,419)$
INTERFUND TRANSACTIONS
Transfers In -$ 1,462,918$ -$ 0.0%1,400,000$ 1,462,918$
Reimbursements From Other Funds 149,740 138,270 138,275 100.0%331,840 (11,470)
Reimbursements To Other Funds (67,625) (73,460) (73,610) 99.8%(176,300) (5,835)
Total Interfund Transactions 82,115$ 1,527,728$ 64,665$ 2362.5%1,555,540$ 1,445,613$
NET FUND INCREASE (DECREASE)1,293,700$ 66,894$ (1,759,825)$ (5,550,810)$ (1,226,806)$
Village of Oak Brook
Infrastructure Fund Financial Update
For the Period Ending May 31, 2021
Total Total
Revenues Expenditures
5/31/21 Actual $ 2,324,712 3,785,546$
5/31/20 Actual $ 2,606,907 1,395,322$
% Change From Last Year -10.8%171.3%
Major Revenues
Sales Tax
Charges for
Services
Investment
Interest Miscellaneous
5/31/21 Actual $ 2,307,383 $ - $ 14,249 $ 3,080
5/31/20 Actual $ 2,554,438 $ 335 $ 52,134 $ -
% Change From Last Year -9.7%-100.0%-72.7%N/A
Five Year Trend
Major Expenditures Materials &Operation &
Personnel Supplies Contractual Capital Outlay
5/31/21 Actual 550,110$ 133,206$ 456,590$ 2,645,640$
5/31/20 Actual 564,268$ 85,354$ 606,662$ 139,038$
% Change From Last Year -2.5%56.1%-24.7%1802.8%
Five Year Trend
Expenditures by Department
5/31/20 5/31/21 5/31/21 5/31/21 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 62,967$ 70,784$ 63,205$ 112.0%157,640$ 7,817$
Public Works 928,788 1,069,338 1,049,465 101.9%2,789,580 140,550
Engineering & Capital Projects 403,567 2,645,424 3,018,520 87.6%9,709,930 2,241,857
Total Expenditures 1,395,322$ 3,785,546$ 4,131,190$ 91.6%12,657,150$ 2,390,224$
Five Year Trend
Village of Oak Brook
Infrastructure Fund - Major Sources Five Year Trend
For the Period Ending May 31, 2021
Revenues Expenditures
5/31/21 5/31/21
5/31/20 5/31/21 YTD % of YTD 2021 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 24,925$ 26,711$ 32,700$ 81.7%75,000$ 1,786$
Real Estate Tax - - - 0.0%400,000 -
Investment Interest 386 25 425 5.9%1,000 (361)
Total Operating Revenues 25,311$ 26,736$ 33,125$ 80.7%476,000$ 1,425$
EXPENDITURES
Operation and Contract 1,040$ 2,500$ 750$ 0.0%3,850$ 1,460$
Other Expenditures 265,455 228,250 228,250 100.0%466,500 (37,205)
Total Expenditures 266,495$ 230,750$ 229,000$ 100.8%470,350$ (35,745)$
NET FUND INCREASE (DECREASE)(241,184)$ (204,014)$ (195,875)$ 5,650$ 37,170$
Note - Expenditures are recorded in program 283.
Village of Oak Brook
Promenade TIF Fund Financial Update
For the Period Ending May 31, 2021
Total Total
Revenues Expenditures
5/31/21 Actual $ 26,736 230,750$
5/31/20 Actual $ 25,311 266,495$
% Change From Last Year 5.6%-13.4%
Major Revenues Real Estate Investment
Sales Tax Tax Interest
5/31/21 Actual 26,711$ $ - $ 25
5/31/20 Actual 24,925$ $ - $ 386
% Change From Last Year 7.2%0.0%-93.5%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures
5/31/21 Actual 2,500$ 228,250$
5/31/20 Actual 1,040$ 265,455$
% Change From Last Year 140.4%-14.0%
Five Year Trend
Village of Oak Brook
Promenade TIF Fund - Major Sources Five Year Trend
For the Period Ending May 31, 2021
Five Year Trend
Revenues Expenditures
5/31/21 5/31/21
5/31/20 5/31/21 YTD % of YTD 2021 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Plan Review Fees 150$ 375$ 425$ 88.2%1,000$ 225$
Building/Inspection Fees 4,912 2,550 2,925 87.2%7,000 (2,362)
Water Sales 3,359,615 3,324,515 3,825,000 86.9%10,597,000 (35,100)
Unmetered Sales 27,318 8,300 14,575 56.9%35,000 (19,018)
Water Connection Fees 5,080 106,490 41,675 255.5%100,000 101,410
Meter Charges 4,377 6,126 6,250 98.0%15,000 1,749
Special Services 12,275 12,757 12,500 N/A 25,000 482
Investment Interest 50,187 22,481 25,000 89.9%60,000 (27,706)
Miscellaneous 20,689 629,156 27,075 2323.8%65,000 608,467
Total Operating Revenues 3,484,603$ 4,112,750$ 3,955,425$ 104.0%10,905,000$ 628,147$
OPERATING EXPENDITURES
Personnel 322,552$ 294,268$ 331,245$ 88.8%842,235$ (28,284)$
Materials and Supplies 5,875 42,190 31,070 135.8%75,780 36,315
Operation and Contract 1,236,379 1,249,221 2,242,625 55.7%5,379,925 12,842
Capital Outlay 911,985 2,132,731 5,012,015 42.6%8,103,750 1,220,746
Total Expenditures 2,476,791$ 3,718,410$ 7,616,955$ 48.8%14,401,690$ 1,241,619$
Surplus (Deficit) of Revenues Over
Expenditures 1,007,812$ 394,340$ (3,661,530)$ -10.8%(3,496,690)$ (613,472)$
INTERFUND TRANSACTIONS
Reimbursements To Other Funds (219,505)$ (187,710)$ (187,700)$ 100.0%(450,500)$ 31,795$
Total Interfund Transactions (219,505)$ (187,710)$ (187,700)$ 100.0%(450,500)$ 31,795$
Fund Increase/(Decrease) - Budgetary Basis 788,307$ 206,630$ (3,849,230)$ -5.4%(3,947,190)$ (581,677)$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay 911,985$ 2,132,731$
Depreciation Expense (228,626) (239,583)
IMRF Pension Expense (17,289) (18,750)
OPEB Expense 11,518 (12,500)
Total GAAP Adjustments 677,588$ 1,861,898$
Fund Increase/(Decrease) - GAAP Basis 1,465,895$ 2,068,528$
*Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.
Village of Oak Brook
Water Fund Financial Update
For the Period Ending May 31, 2021
Total Total
Revenues Expenditures
5/31/21 Actual $ 4,112,750 3,718,410$
5/31/20 Actual $ 3,484,603 2,476,791$
% Change From Last Year 18.0%50.1%
Unmetered Water
Water Sales Sales Connection Fees Meter Charges Miscellaneous
5/31/21 Actual $ 3,324,515 $ 8,300 $ 106,490 $ 6,126 $ 629,156
5/31/20 Actual $ 3,359,615 $ 27,318 $ 5,080 $ 4,377 $ 20,689
% Change From Last Year -1.0%-69.6%1996.3%40.0%2941.0%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
5/31/21 Actual 294,268$ 42,190$ 1,249,221$ -$ 2,132,731$
5/31/20 Actual 322,552$ 5,875$ 1,236,379$ -$ 911,985$
% Change From Last Year -8.8%618.1%1.0%0.0%133.9%
Five Year Trend
Expenditures by Department
5/31/20 5/31/21 5/31/21 5/31/21 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Public Works 1,568,143$ 1,572,430$ 2,613,275$ 60.2%6,317,940$ 4,287$
Engineering & Capital Projects 908,648 2,145,980 5,003,680 42.9%8,083,750 1,237,332
Total Expenditures 2,476,791$ 3,718,410$ 7,616,955$ 48.8%14,401,690$ 1,241,619$
Five Year Trend
Village of Oak Brook
Water Fund - Major Sources Five Year Trend
For the Period Ending May 31, 2021
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Sports Core Fund Consolidated Presentation
For the Period Ending May 31, 2021
5/31/21 5/31/21
5/31/21 YTD % of YTD 2021 5/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 -$ -$ -$ 357,450$ 357,450$ 222,500$ 160.7%238,500$ 199,499$ 157,951$
Greens Fees - - - 329,114 329,114 212,000 155.2%985,000 68,921 260,193
Pro Shop Sales - - - 90,095 90,095 72,500 124.3%207,000 25,366 64,729
Golf Lessons - - - 40,225 40,225 21,000 191.5%45,000 270 39,955
Driving Range Fees - - - 166,968 166,968 110,000 151.8%250,000 50,572 116,396
Rentals - 90,000 18,015 121,827 229,842 209,725 109.6%761,000 115,098 114,744
Programs/User Fees 22,525 - - - 22,525 20,000 112.6%31,500 - 22,525
Food Sales - - - 67,837 67,837 13,000 521.8%207,500 3,552 64,285
Beverage Sales - - - 120,110 120,110 13,000 923.9%382,000 9,291 110,819
Taste of Oak Brook - - - - - 20,000 0.0%120,000 - -
Grants - - - - - - 0.0%233,600 - -
Other Revenue 7,152 - - 5,276 12,428 2,875 432.3%7,700 1,557 10,871
Total Operating Revenues 29,677$ 90,000$ 18,015$ 1,298,902$ 1,436,594$ 916,600$ 156.7%3,468,800$ 474,126$ 962,468$
OPERATING EXPENDITURES
Personnel 2,082$ -$ 43,045$ 385,015$ 430,142$ 448,815$ 95.8%1,597,610$ 364,886$ 65,256$
Materials & Supplies 26,751 - 2,782 124,944 154,477 244,145 63.3%628,450 29,341 125,136
Operational & Contractual 34,458 5,143 18,836 151,138 209,575 219,350 95.5%663,035 191,899 17,676
Other - - - - - - 0.0%(39,000) - -
Capital 121,020 - 32 11,775 132,827 697,500 19.0%1,125,380 760,036 (627,209)
Total Operating Expenditures 184,311$ 5,143$ 64,695$ 672,872$ 927,021$ 1,609,810$ 57.6%3,975,475$ 1,346,162$ (419,141)$
B&T Administration Overhead Allocation*14,788$ -$ (14,788)$ -$ -$ -$ 0.0%-$ -$ -$
Operating Revenues Over (Under) Expenditures (139,846)$ 84,857$ (61,468)$ 626,030$ 509,573$ (693,210)$ -73.5%(506,675)$ (872,036)$ 1,381,609$
INTERFUND TRANSACTIONS
Interfund Loan**-$ -$ -$ -$ -$ -$ 0.0%-$ 150,660$ (150,660)$
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 13,333 - - - 13,333 13,335 100.0%32,000 10,000 3,333
Reimbursement From Water Fund 3,337 - - - 3,337 3,340 99.9%8,000 3,335 2
Reimbursement To General Fund (6,550) - - (19,655) (26,205) (26,215) 100.0%(62,900) (23,520) (2,685)
Total Interfund Transactions 10,120$ -$ -$ (19,655)$ (9,535)$ 290,460$ -3.3%277,100$ 790,217$ (799,752)$
Total Revenues Over (Under) Expenditures - Budgetary Basis (129,726)$ 84,857$ (61,468)$ 606,375$ 500,038$ (402,750)$ (229,575)$ (81,819)$ 581,857$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 121,020$ -$ 32$ 11,775$ 132,827$ 760,036$
Depreciation Expense (70,095) (702) (25,000) (102,625) (198,422) (162,118)
IMRF Pension Expense (854) - (1,250) (10,208) (12,313) (10,898)
OPEB Expense - - (1,250) (11,667) (12,917) (10,519)
Total GAAP Adjustments 50,071$ (702)$ (27,468)$ (112,725)$ (90,824)$ 576,502$
Fund Increase/(Decrease) - GAAP Basis (79,655)$ 84,155$ (88,936)$ 493,650$ 409,214$ 494,683$
*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.
**Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.
Total Direct Total Direct
Revenues Expenditures
5/31/21 Actual $ 1,436,594 927,021$
5/31/20 Actual $ 474,126 1,346,162$
% Change From Last Year 203.0%-31.1%
Driving Program/
Memberships Greens Fees Range Fees Rentals User Fees
5/31/21 Actual $ 357,450 $ 329,114 $ 166,968 $ 229,842 22,525$
5/31/20 Actual $ 199,499 $ 68,921 $ 50,572 $ 115,098 -$
% Change From Last Year 79.2%377.5%230.2%99.7%N/A
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
5/31/21 Actual 430,142$ 154,477$ 209,575$ -$ 132,827$
5/31/20 Actual 364,886$ 29,341$ 191,899$ -$ 760,036$
% Change From Last Year 17.9%426.5%9.2%0.0%-82.5%
Five Year Trend
Revenues by Department 5/31/20 5/31/21 5/31/21 5/31/21 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Operations 72$ 29,677$ 24,975$ 118.8%325,800$ 29,605$
Open Field Operations 87,540 90,000 112,500 80.0%230,000 2,460
B&T Clubhouse Operations 12,648 18,015 37,000 48.7%267,000 5,367
Golf Club 373,866 1,298,902 742,125 175.0%2,646,000 925,036
Total Revenues 474,126$ 1,436,594$ 916,600$ 156.7%3,468,800$ 962,468$
Expenditures by Department 5/31/20 5/31/21 5/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 372,054$ 184,311$ 317,620$ 58.0%780,740$ (187,743)$
Open Field Operations 43,676$ 5,143$ 72,985$ 7.0%358,910$ (38,533)$
B&T Clubhouse Operations 74,856 64,695 102,040 63.4%262,635 (10,161)
Golf Club 855,576 672,872 1,117,165 60.2%2,573,190 (182,704)
Total Expenditures 1,346,162$ 927,021$ 1,609,810$ 57.6%3,975,475$ (419,141)$
Five Year Trend
Village of Oak Brook
Sports Core Fund - Major Sources Five Year Trend
For the Period Ending May 31, 2021
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Club Recreation Operations
For the Period Ending May 31, 2021 5/31/21 5/31/21
822 5/31/21 YTD % of YTD 2021 5/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 - 22,525 - - 22,525 20,000 112.6%31,500 - 22,525
Food Sales - - - - - 4,000 0.0%38,000 - -
Beverage Sales - - - - - 1,000 0.0%22,000 - -
Grants - - - - - - 0.0%233,600 - -
Other Revenue 7,152 - - - 7,152 (25) -28608.0%700 (127) 7,279
Total Operating Revenues 7,152$ 22,525$ -$ -$ 29,677$ 24,975$ 118.8%325,800$ 72$ 29,605$
OPERATING EXPENDITURES
Personnel 2,082$ -$ -$ -$ 2,082$ 26,940$ 7.7%119,110$ 2,165$ (83)$
Materials & Supplies 226 20,699 2,460 3,366 26,751 19,800 135.1%37,250 853 25,898
Operational & Contractual 17,224 15,327 1,784 123 34,458 40,880 84.3%89,550 31,151 3,307
Capital 10,645 110,375 - - 121,020 230,000 52.6%534,830 337,885 (216,865)
Total Operating Expenditures 30,177$ 146,401$ 4,244$ 3,489$ 184,311$ 317,620$ 58.0%780,740$ 372,054$ (187,743)$
B&T Administration Overhead Allocation*29,575$ (10,646)$ (2,958)$ (1,183)$ 14,788$ 22,645$ 65.3%44,755$ 24,602$ (9,814)$
Operating Revenues Over (Under) Expenditures 6,550$ (134,522)$ (7,202)$ (4,672)$ (139,846)$ (270,000)$ 51.8%(410,185)$ (347,380)$ 207,534$
INTERFUND TRANSACTIONS
Interfund Loan**-$ -$ -$ -$ -$ -$ 0.0%-$ 150,660$ (150,660)$
Transfer From General Fund - - - - - 100,000 0.0%100,000 326,369 (326,369)
Reimbursement From Infrastructure Fund 13,333 - - - 13,333 13,335 100.0%32,000 10,000 3,333
Reimbursement From Water Fund 3,337 - - - 3,337 3,340 99.9%8,000 3,335 2
Reimbursement To General Fund (6,550) - - - (6,550) (6,550) 100.0%(15,725) (11,760) 5,210
Total Interfund Transactions 10,120$ -$ -$ -$ 10,120$ 110,125$ 9.2%124,275$ 478,604$ (468,484)$
Total Revenues Over (Under) Expenditures - Budgetary Basis 16,670$ (134,522)$ (7,202)$ (4,672)$ (129,726)$ (159,875)$ (285,910)$ 131,224$ (260,950)$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 10,645$ 110,375$ -$ -$ 121,020$ 337,885$
Depreciation Expense (26,816) (41,667) (1,125) (487) (70,095) (38,378)
IMRF Pension Expense (833) - - (21) (854) (466)
Total GAAP Adjustments (17,005)$ 68,708$ (1,125)$ (508)$ 50,071$ 299,041$
Fund Increase/(Decrease) - GAAP Basis (335)$ (65,814)$ (8,327)$ (5,180)$ (79,655)$ 430,265$
*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 May 31, 2021 5/31/21 5/31/21
5/31/21 YTD % of YTD 2021 5/31/20 Difference
815 816 YTD Amended Amended Adopted YTD Prior
Polo Open Fields Total Budget Budget Budget Total Year
OPERATING REVENUES
Field Rentals -$ 10,000$ 10,000$ 12,500$ 80.0%30,000$ 12,540$ (2,540)$
Range Rentals - 80,000 80,000 80,000 100.0%80,000 75,000 5,000
Taste of Oak Brook - - - 20,000 0.0%120,000 - -
Other Revenue - - - - 0.0%- - -
Total Operating Revenues -$ 90,000$ 90,000$ 112,500$ 80.0%230,000$ 87,540$ 2,460$
OPERATING EXPENDITURES
Personnel -$ -$ -$ -$ 0.0%-$ -$ -$
Materials & Supplies - - - 200 0.0%500 119 (119)
Operational & Contractual - 5,143 5,143 22,785 22.6%190,360 34,847 (29,704)
Capital - - - 50,000 0.0%168,050 8,710 (8,710)
Total Operating Expenditures -$ 5,143$ 5,143$ 72,985$ 7.0%358,910$ 43,676$ (38,533)$
Operating Revenues Over (Under) Expenditures -$ 84,857$ 84,857$ 39,515$ 214.7%(128,910)$ 43,864$ 40,993$
INTERFUND TRANSACTIONS
Transfer From Hotel Tax Fund -$ -$ -$ -$ 0.0%-$ -$ -$
Total Interfund Transactions -$ -$ -$ -$ 0.0%-$ -$ -$
Total Revenues Over (Under) Expenditures - Budgetary Basis -$ 84,857$ 84,857$ 39,515$ (128,910)$ 43,864$ 40,993$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay -$ -$ -$ 8,710$
Depreciation Expense - (702) (702) (702)
Total GAAP Adjustments -$ (702)$ (702)$ 8,008$
Fund Increase/(Decrease) - GAAP Basis -$ 84,155$ 84,155$ 51,872$
*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 May 31, 2021
5/31/21 5/31/21
821 YTD % of YTD 2021 5/31/20 Difference
B&T Amended Amended Adopted YTD Prior
Clubhouse Budget Budget Budget Total Year
OPERATING REVENUES
Rentals 18,015$ 37,000$ 48.7%267,000$ 12,648$ 5,367$
Total Operating Revenues 18,015$ 37,000$ 48.7%267,000$ 12,648$ 5,367$
OPERATING EXPENDITURES
Personnel 43,045$ 47,205$ 91.2%133,585$ 45,057$ (2,012)$
Materials & Supplies 2,782 4,925 56.5%12,000 1,436 1,346
Operational & Contractual 18,836 45,410 41.5%107,550 27,659 (8,823)
Capital 32 4,500 0.7%9,500 704 (672)
Total Operating Expenditures 64,695$ 102,040$ 63.4%262,635$ 74,856$ (10,161)$
B&T Administration Overhead Allocation*(14,788)$ (22,645)$ 65.3%(44,755)$ (24,602)$ 9,814$
Operating Revenues Over (Under) Expenditures (61,468)$ (87,685)$ 70.1%(40,390)$ (86,810)$ 25,342$
INTERFUND TRANSACTIONS
Transfer From General Fund -$ -$ 0.0%-$ -$ -$
Total Interfund Transactions -$ -$ 0.0%-$ -$ -$
Total Revenues Over (Under) Expenditures - Budgetary Basis (61,468)$ (87,685)$ (40,390)$ (86,810)$ 25,342$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 32$ 704$
Depreciation Expense (25,000) (25,231)
IMRF Pension Expense (1,250) (864)
OPEB Expense (1,250) (1,102)
Total GAAP Adjustments (27,468)$ (26,493)$
Fund Increase/(Decrease) - GAAP Basis (88,936)$ (113,303)$
*Overhead allocation is comprised of salaries, business forms, liability insurance, building & grounds maintenance and bank service fees in Program 811 -
Sports Core General Operations distributed to various Sports Core Programs on a percentage basis.
**Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.
Village of Oak Brook
Monthly Operating Statement
Golf Club Programs
For the Period Ending May 31, 2021
5/31/21 5/31/21
823 831 832 833 834 5/31/21 YTD % of YTD 2021 5/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 -$ 357,450$ -$ -$ -$ 357,450$ 222,500$ 160.7%238,500$ 199,300$ 158,150$
Greens Fees - 329,114 - - - 329,114 212,000 155.2%985,000 68,921 260,193
Pro Shop Sales - 90,095 - - - 90,095 72,500 124.3%207,000 25,366 64,729
Golf Lessons - - 40,225 - - 40,225 21,000 191.5%45,000 270 39,955
Driving Range Fees - - 166,968 - - 166,968 110,000 151.8%250,000 50,572 116,396
Rentals - 475 - 121,352 - 121,827 80,225 151.9%384,000 14,910 106,917
Food Sales 67,837 - - - - 67,837 9,000 753.7%169,500 3,552 64,285
Beverage Sales 120,110 - - - - 120,110 12,000 1000.9%360,000 9,291 110,819
Other Revenue - 5,276 - - - 5,276 2,900 181.9%7,000 1,684 3,592
Total Operating Revenues 187,947$ 782,410$ 207,193$ 121,352$ -$ 1,298,902$ 742,125$ 175.0%2,646,000$ 373,866$ 925,036$
OPERATING EXPENDITURES
Personnel 59,807$ 178,797$ 8,191$ 9,011$ 129,209$ 385,015$ 374,670$ 102.8%1,344,915$ 317,664$ 67,351$
Materials & Supplies 65,507 13,232 5,763 735 39,707 124,944 219,220 57.0%578,700 26,933 98,011
Operational & Contractual 2,228 116,940 439 16,524 15,007 151,138 110,275 137.1%275,575 98,242 52,896
Other - - - - - - - 0.0%(39,000) - -
Capital - 11,377 - - 398 11,775 413,000 2.9%413,000 412,737 (400,962)
Total Operating Expenditures 127,542$ 320,346$ 14,393$ 26,270$ 184,321$ 672,872$ 1,117,165$ 60.2%2,573,190$ 855,576$ (182,704)$
Operating Revenues Over (Under) Expenditures 60,405$ 462,064$ 192,800$ 95,082$ (184,321)$ 626,030$ (375,040)$ -166.9%72,810$ (481,710)$ 1,107,740$
INTERFUND TRANSACTIONS
Transfer from Golf Surcharge -$ -$ -$ -$ -$ -$ 200,000$ 0.0%200,000$ 323,373$ (323,373)$
Reimbursement to General Fund - (19,655) - - - (19,655) (19,665) 99.9%(47,175) (11,760) (7,895)
Total Interfund Transactions -$ (19,655)$ -$ -$ -$ (19,655)$ 180,335$ -10.9%152,825$ 311,613$ (331,268)$
Total Revenues Over (Under) Expenditures - Budgetary Basis 60,405$ 442,409$ 192,800$ 95,082$ (184,321)$ 606,375$ (194,705)$ 225,635$ (170,097)$ 776,472$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay -$ 11,377$ -$ -$ 398$ 11,775$ 412,737$
Depreciation Expense (417) (43,750) (958) (5,417) (52,083) (102,625) (97,806)
IMRF Pension Expense (1,042) (4,167) (417) - (4,583) (10,208) (9,568)
OPEB Expense (1,250) (6,250) - - (4,167) (11,667) (9,418)
Total GAAP Adjustments (2,708)$ (42,790)$ (1,375)$ (5,417)$ (60,435)$ (112,725)$ 295,946$
Fund Increase/(Decrease) - GAAP Basis 57,697$ 399,619$ 191,425$ 89,665$ (244,756)$ 493,650$ 125,849$
*Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.