10 - October 2020 Monthly Financial ReportVILLAGE
OAK BROOK
OF
MONTHLY FINANCIAL REPORTS
OCTOBER 2020
ITEM 6.D
Cash and Investments by Fund:Total
Cash and Cash Pooled Cash and
Fund Equivalents Investments Investments % By Fund
General Corporate $7,632,775 $14,163,575 $21,796,350 50.7%
Hotel/Motel Tax 1,814,809 2,775,900 4,590,709 10.7%
Motor Fuel Tax 802,919 36,495 839,414 2.0%
Infrastructure 5,761,018 2,048,450 7,809,468 18.2%
Promenade TIF 234,092 - 234,092 0.5%
Water 3,106,949 3,561,636 6,668,585 15.5%
Sports Core 345,313 - 345,313 0.8%
Golf Surcharge 137,277 - 137,277 0.3%
Self-Insurance (707,967)- (707,967) -1.6%
Garage 342,677 - 342,677 0.8%
Equipment Replacement 537,560 419,454 957,014 2.2%
Total $20,007,422 $23,005,510 $43,012,932 100.0%
Change in Cash and Investments by Fund :
Balance at Balance at Year-to-Date Year-to-Date
Fund January 1, 2020 October 31, 2020 Change ($)Change (%)
General Corporate $21,270,239 $21,796,350 $526,111 2.5%
Hotel/Motel Tax 5,427,474 4,590,709 (836,765)-15.4%
Motor Fuel Tax 1,085,595 839,414 (246,181)-22.7%
Infrastructure 8,217,724 7,809,468 (408,256)-5.0%
Promenade TIF 304,194 234,092 (70,102)-23.0%
Water 6,947,239 6,668,585 (278,654)-4.0%
Sports Core 231,216 345,313 114,097 49.3%
Golf Surcharge 347,066 137,277 (209,789)-60.4%
Self-Insurance 308,820 (707,967)(1,016,787)-329.2%
Garage 275,988 342,677 66,689 24.2%
Equipment Replacement 808,879 957,014 148,135 18.3%
$45,224,434 $43,012,932 ($2,211,502)-4.9%
Book Bank/Market
Value Value
Cash and Cash Equivalents:
Pooled Checking $1,158,363 $2,785,209
Sports Core Checking 485,087 462,657
Pooled IPTIP 18,045,025 18,045,025
Water E-Pay IPTIP 318,947 304,451
$20,007,422 $21,597,341
Pooled Investments:
Investments-Municipal Bonds $9,246,054 $9,306,705
Investments-Corporate Bonds 7,454,925 7,541,358
Government & Agency Obligations 1,716,768 1,751,501
Certificates of Deposit 4,410,000 4,463,581
Accrued Interest 177,763 177,763
Total Pooled Investments $23,005,510 $23,240,908
Total Cash and Investments $43,012,932 $44,838,249
For October, total interest revenue is $40,013 and YTD is $553,205. The total investment yield for the portfolio is:
Pooled
Investments Illinois Funds Total
Last 12 months yield 2.13%0.95%1.59%
The weighted average yield of the current pooled investment portfolio is 1.87%. The IL Funds October average daily rate was 0.099%.
Monthly Treasurer's Report
October 31, 2020
Monthly Treasurer's Report
October 2020
The table below lists the detail investment holdings at J.P. Morgan Securities as of 10/31/20:
Month End VOB
Settlement Maturity Coupon Yield Book Market Accrued
Type Date Date Rate Rate Value Value Interest
Municipal Bonds:
New York N Y City #64971QTX1 02/22/16 05/01/21 2.350%2.000%$200,330 $201,990 $2,335
Bloomingdale Mich Pub Sch Dist #094383FS0 04/26/16 05/01/22 2.710%2.150%504,063 516,550 6,736
Connecticut St GO Bds 2016 #20772J3F7 06/15/17 08/15/21 1.750%2.300%497,881 504,810 1,794
Wright County Min #982276BC0 07/18/19 12/01/20 2.000%2.000%545,000 545,589 5,056
State of IL #452152P54 10/09/19 11/01/21 5.000%1.870%515,515 511,305 12,249
Anchor Bay Mich Sch #032879TE8 11/01/19 05/01/21 2.320%1.750%717,037 721,900 8,156
Brownsville TX #16405ST9 12/19/19 02/15/22 2.050%2.000%555,343 564,552 2,244
Laredo TX Waterworks #517039VW0 12/19/19 03/01/24 2.230%2.230%455,000 474,228 1,635
Manchester NH #562333JE5 03/12/20 12/01/20 5.000%0.850%476,644 476,748 9,855
Oakland Univ Mich #673588HJ1 04/29/20 03/01/24 5.000%1.650%326,899 333,495 2,458
Philadelphia PA GO Ref #717813SW0 05/05/20 08/01/22 5.000%1.820%411,355 419,094 4,672
Maryland St DOT #574204WG4 05/06/20 06/15/22 4.350%1.200%273,187 276,024 4,156
University of CA #91412HFK4 07/16/20 05/15/23 0.628%0.628%25,000 25,063 46
Windsor NY Sch Dist #973675EW7 07/23/02 06/17/21 1.500%0.400%478,255 477,812 1,954
Waterford Mich Sch Dist #941468YZ7 08/20/20 08/24/21 4.000%0.301%515,026 514,105 3,925
Weedsport NY Cent Sch Dist #948543KA0 08/21/20 08/20/21 1.000%0.570%501,716 501,300 968
Universty of IL #914353YH4 08/31/20 10/01/21 3.000%0.701%255,242 254,820 625
New Jersey St #646039UD7 09/20/20 06/01/22 5.000%0.600%507,934 505,362 9,830
Alaska St GO #011770Z72 10/14/2020 8/1/2021 5.000%0.252%181,245 181,137 2,163
Rio Rancho NM #767175HM7 10/14/2020 5/15/2022 5.000%0.350%198,214 198,351 4,240
Cook, Kane, Lake, & McHenry #216181GL5 10/29/2020 12/15/2022 4.000%0.300%1,105,168 1,102,470 220
Total Municipal Bonds $9,246,054 $9,306,705 $85,317
Corporate Bonds:
Wells Fargo #94974BGR5 01/15/19 12/07/20 2.550%3.120%$1,389,338 $1,393,114 $14,472
PNC Bank #69353RFH6 01/30/19 01/22/21 2.500%3.020%499,445 501,570 3,438
Morgan Stanley #61747WAL3 03/08/19 07/28/21 5.500%3.034%1,068,609 1,089,512 14,758
Citigroup #172967LC3 04/01/19 12/08/21 2.900%2.754%1,001,564 1,025,500 10,956
Goldman Sachs #38143U8F1 05/02/19 02/25/21 2.875%2.707%365,179 367,161 1,897
American Honda #02665WBG5 07/31/19 09/09/21 1.700%2.180%497,994 505,980 1,251
BB&T Corp #05531FAZ6 08/15/19 02/01/21 2.150%2.010%750,290 752,295 3,835
JP Morgan #48128BAB7 09/30/19 01/15/23 2.972%2.337%1,013,535 1,031,080 8,751
American Express #025816CD9 05/05/20 05/20/22 2.750%1.290%511,249 517,760 6,006
Goldman Sachs #38141GGQ1 08/31/20 07/27/21 5.250%0.251%357,722 357,386 4,729
Total Corporate Bonds $7,454,925 $7,541,358 $70,093
Government & Agency Obligations:
*Government National Mtg Assn #38379UEM4 02/29/16 02/16/51 2.300%2.245%$485,968 $480,020 $2,235
*Government National Mtg Assn #38381WV96 08/06/19 07/20/54 2.250%2.293%672,382 690,601 1,163
*Government National Mtg Assn #38380BNV3 12/05/19 06/20/46 2.000%2.112%558,418 580,880 858
Total Government & Agency Obligations:$1,716,768 $1,751,501 $4,256
Certificates of Deposit:
State Bk India NY #8562846A7 01/26/17 01/26/22 2.250%2.250%$245,000 $251,598 $1,463
Jackson Cnty Bk #466682AP6 08/31/17 03/01/21 1.850%1.850%245,000 246,507 755
FirstBank PR Santurce #33767A6M8 11/03/17 11/03/20 2.000%2.000%245,000 245,054 348
Discover Bank #254673WF9 11/07/18 11/09/20 3.000%3.000%245,000 245,201 3,556
Ally Bank #02007GFX6 11/08/18 11/09/20 3.000%3.000%245,000 245,201 3,522
Comenity Cap Bank #20033AU46 04/15/19 04/15/21 2.500%2.500%245,000 247,759 230
Morgan Stanley #61760AE21 05/30/19 06/01/21 2.400%2.400%245,000 248,369 2,434
First St Bank DeQueen #336460CU2 07/18/19 07/19/21 2.000%2.000%245,000 248,413 181
Bank Hapoalim #06251AW89 07/19/19 07/19/21 2.000%2.000%245,000 248,602 1,515
Capital One Natl Assn #14042RMF5 07/24/19 07/26/19 2.050%2.050%245,000 248,606 1,451
TIAA FSB Jacksonville #87270LCN1 07/29/19 07/29/21 2.000%2.000%245,000 248,555 1,252
Wells Fargo #949763J31 09/18/19 09/20/21 1.850%1.850%245,000 248,886 182
BMW Bank #05580ASQ8 10/11/19 10/12/21 1.800%1.800%245,000 249,047 172
Wells Fargo #949495AN5 01/17/20 01/18/22 1.800%1.800%245,000 250,128 181
Bank Leumi #063248KQ0 03/31/20 03/31/22 1.250%1.250%245,000 249,040 243
Capital One Natl Assn #14042TCZ8 04/01/20 04/01/22 1.350%1.350%245,000 249,381 262
Synchrony Bank #87164WZN1 04/03/20 04/04/22 1.350%1.350%245,000 249,405 244
Wells Fargo #95001DAB6 06/17/20 06/17/23 1.200%1.200%245,000 243,829 106
Total Certificates of Deposits $4,410,000 $4,463,581 $18,097
Total J.P.Morgan Securities $22,827,747 $23,063,145 $177,763
*This is a mortgage backed security that receives principal payments each month based on mortgage repayments. Monthly principal payments will vary and the
investment balance may be repaid before the maturity date.
VILLAGE OF OAK BROOK
Monthly Treasurer's Report
October 31, 2020
Cash & Investments by Fund - Total $43.0 million
Cash & Investments by Type - Total $43.0 million
Checking
Illinois Funds
Certificates of Deposit
Municipal Bonds
Corporate Bonds
Government & Agency Obligations
Accrued Interest
General Corporate
49.1%
Hotel/Motel Tax
10.3%Motor Fuel Tax
1.9%
Infrastructure
17.6%
Promenade TIF
0.5%
Water
15.0%
Sports Core
0.8%
Golf Surcharge
0.3%
Self-Insurance
-1.6%Garage
0.8%
Equipment
Replacement
2.2%
Checking, $1.6
Illinois Funds, $18.4
Certificates of Deposit,
$4.4
Municipal Bonds, $9.3
Corporate Bonds, $7.5
Government & Agency
Obligations, $1.7
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)19,308,717$ 19,292,783$ 15,934$ 679,465$
Main operating fund of the Village.
Hotel Fund (Major Fund)503,637$ 844,307$ (340,670)$ (175,395)$
Collects and spends resources from the
3% hotel/motel tax.
Motor Fuel Tax Fund 425,973$ 666,994$ (241,021)$ (1,086,100)$
Collects and spends resources from the
State motor fuel tax.
Infrastructure Fund (Major Fund)5,046,549$ 5,002,238$ 44,311$ (4,859,785)$
Accounts for construction and maintenance of
roadways, drainage, and safety path systems.
Promenade TIF Fund (Major Fund)464,101$ 534,203$ (70,102)$ (56,290)$
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)8,400,215$ 7,683,620$ 716,595$ (1,669,690)$
Collects user fees for the distribution of water
and maintenance of infrastructure.
Sports Core Fund (Major Fund)3,373,587$ 3,138,725$ 234,862$ 190,750$
Accounts for revenues and expenses relating
to administration, programs, food and beverage
operations, and golf course.
Golf Surcharge Fund 113,585$ 323,373$ (209,788)$ (287,900)$
Accounts for the collection of the $3 per round
golf surcharge.
Internal Service Funds
Self Insurance Fund 2,936,012$ 3,711,402$ (775,390)$ 11,500$
Accounts for the Village's health insurance costs
and the related contributions from the Village,
employees, retirees, and other agencies.
Garage Fund 594,098$ 555,849$ 38,249$ (40,775)$
Accounts for the maintenance of the Village's vehicle
fleet and the related departmental reimbursements.
Equipment Replacement Fund 275,238$ 411,196$ (135,958)$ 40,595$
Accounts for the replacement of the Village's vehicle
fleet and the related departmental contributions.
Further information on the Village's major funds (as indicated above) can be found on the proceeding pages.
Executive Summary on Village Funds
Through October 31, 2020
Village of Oak Brook
Monthly Financial Report – Fund Narrative
For the Period Ending October 31, 2020
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
major 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 (CAFR).
The proceeding pages contain detailed information on the Village’s major funds. Highlights for each of
the Village’s funds are:
General Fund
Total revenues through October 2020 are $3,583,141, or 16.0%, lower than last October and
$2,559,738, or 12.0%, under budget to date. The main drivers for this are:
o Sales tax revenue, the General
Fund’s largest revenue source, is
down $1,228,516 from last year
and $1,202,607 under budget.
October 2020 collections are
relatively consistent with
collections the previous five
years as revenues rebounded
from the COVID-19 related
business closures earlier this
year.
o Telecommunications/Utility Tax is down $268,707 from last year and $178,355 under
budget. This is due to a decrease in usage from the closure of businesses during the
pandemic.
o Licenses and permits revenue is down $1,860,178 from last year and $935,780 under
budget. This is due to the timing of permits being issued vs. when originally planned.
Permit revenue is still expected to end strong in 2020 with the Hines Oak Brook
Commons kicking off shortly.
o Charges for Services revenue is down $272,350 from last year and $235,537 under
budget. This is primarily due to a decrease in ambulance fees from fewer calls for
service due to the ongoing pandemic.
Total expenditures through October 2020 are $771,718, or 3.9%, lower than last year and
$1,459,851, or 7.2%, under budget to date. The main drivers for this are:
o Personnel expenditures are up $356,176 from last year, but $426,946 under budget.
The increase is due to a combination of annual pay increases and final accrual payouts
from three retirements. Personnel is under budget due to the start of furlough days and
a reduction in overtime due to the COVID-19 pandemic.
o Operation and contract expenditures are down $435,867 from last year and $466,352
under budget. This is due to the general timing of payments compared to when they
were projected to occur. The Village has also put various projects on hold until after the
pandemic is over.
o Capital outlay expenditures are down $700,262 from last year and $491,500 under
budget. Many capital items have been put on hold for 2020 due to the current
economic state.
Hotel Tax Fund
Total revenues through October 2020 are $648,502, or 56.3%, lower than last year and
$561,963, or 52.7%, under budget. The main drivers for this are:
o Hotel tax revenue is down $618,253 from last year and $563,991 under budget. The
decrease is due to the timing of receipts being received and a reduction in room rentals
from the COVID-19 pandemic.
Total expenditures through October 2020 are $266,718, or 51.8%, higher than last year, but
$138,873, or 15.1%, under budget. The main drivers for this are:
o Operation and contract expenditures are down $206,525 from last year and $281,721
under budget. This is due to the timing of advertising payments and the cancelling of
certain campaigns. In addition, the Village rebated $70,013 of hotel tax related to
January, February, and March stays back to the hotels.
o Capital Outlay expenditures are up $473,243 from last year and $142,848 over budget.
The street light replacements began earlier than originally projected.
Infrastructure Fund
Total revenues through October 2020 are down $837,219, or 17.0%, from last year and
$719,320, or 15.0%, under budget. The main drivers for this are:
o Non-home rule sales tax revenue
is down $722,744 from last year
and $687,865 under budget.
October 2020 collections are
relatively consistent with
collections the previous five
years as revenues rebounded
from the COVID-19 related
business closures earlier this
year.
o Interest revenue is down
$113,845 from last year and $28,840 under budget. Interest rates have dropped in
recent months compared to last year. In addition, the Infrastructure Fund’s reserve
balance has shifted to cash and other short-term investments in order to have money
available for upcoming projects.
Total expenditures through October 2020 are down $911,755, or 15.8%, from last year and
$6,529,972, or 57.3%, under budget to date. The main drivers for this are:
o Operation and contract expenditures are down $202,062 from last year and $491,684
under budget. Expenditures are under budget due to the timing of engineering
payments. Some projects have been delayed due to the current pandemic.
o Capital Outlay expenditures are down $728,594 from last year and $5,974,215 under
budget. The majority of budgeted projects have not occurred to date and may be
delayed until later in the year or 2021.
Promenade TIF Fund
Total revenues through October 2020 are down $14,340, or 3.0% from last year, but $11,601, or
2.6%, over budget. Real estate tax revenue increased slightly in 2020 compared to last year.
Interest rates have dropped in recent months compared to last year, resulting in a decrease in
interest income.
Total expenditures through October 2020 are up $69,475, or 14.9%, from last year and $25,413,
or 5.0%, over budget. The increase relates to additional principal and interest paid towards the
TIF note. Expenditures are over budget due to the timing of audit and TIF report fees, as well as
more principal paid on the note due to an increase in real estate taxes.
Water Fund
Total revenues through October 2020 are down $139,767, or 1.6%, from last year and $548,305,
or 6.1%, under budget. The main drivers for this are:
o Water sales revenue is up $102,790 from last year, but $461,344 under budget. Sales
are under budget due to the business shut downs from the COVID-19 pandemic.
o Water connection fees are down $151,740 from last year and $62,840 under budget.
Revenue is down from last year due to the opening of a large office building in 2019.
Revenue is under budget due to the delay in construction of planned development in
2020.
Total expenditures through October 2020 are down $164,280, or 2.2%, from last year and
$2,934,600, or 28.8%, under budget. The main drivers for this are:
o Operation and contract expenditures are up $25,141 from last year, but $867,730 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 down $149,179 from last year and $1,960,451 under
budget. A number of budgeted projects for 2020 are on hold due to the current
pandemic. Activity so far in 2020 primarily relates to finishing 2019 projects.
Sports Core Fund
Total revenues through October 2020 are down $623,804, or 18.8%, from last year and
$836,410, or 23.7%, under budget to date. Most revenue sources are under budget to date in
2020 due to the COVID-19 pandemic limiting activity. Starting in 2020, the Park District took
over all Bath and Tennis Club membership sales, however, this was not factored into the 2020
budget due to the timing of the agreement. Highlights of Sports core revenues are:
o Membership revenue is down $194,794 from last year and $234,248 under budget. This
is due to a change in swimming and tennis memberships being taken over by the Park
District rather than the Village. Golf memberships are up $27,013 from last year and
$7,188 over budget to date.
o Greens Fees are up $145,531 from last year and $117,163 over budget. The golf course
was open on a limited basis until June 1, but has made up nearly all the lost rounds
since.
o Rental income is down $420,816 from last year and $429874 under budget. This is due
to many events being cancelled this year at the B&T Clubhouse. In addition, golf cart
rental fees are under budget due to the course being closed in the spring.
Total expenditures through October 2020 are down $953,607, or 23.6%, from last year and
$1,428,555, or 31.6%, under budget to date. The main drivers for this are:
o Personnel expenditures are down $89,227 from last year and $96,829 under budget.
Personnel is down due to the COVID-19 pandemic closing Sports Core facilities for much
of spring.
o Materials & Supplies expenditures are down $107,523 from last year and $66,181 under
budget. Expenditures are down due to facilities being closed for much of the spring.
o Operation and Contractual expenditures are down $487,091 from last year and
$605,433 under budget. This is due to the outsourcing of swimming, tennis, and soccer
fields to the Park District. Previously, the Village paid the Park District $230,000 to
operate the swimming pool.
o Capital expenditures are down $269,766 from last year and $743,262 under budget.
This is due to the golf lounge renovation project and a delay in the pool renovation
project due to the COVID-19 pandemic.
10/31/20 10/31/20
10/31/19 10/31/20 YTD % of YTD 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 10,428,409$ 9,199,893$ 10,402,500$ 88.4%12,502,000$ (1,228,516)$
Other Intergovernmental Tax*1,302,270 1,337,410 1,200,500 111.4%1,352,000 35,140
Telecommunications/Utility Tax 5,259,852 4,991,145 5,169,500 96.5%6,125,000 (268,707)
Licenses and Permits 3,433,253 1,573,075 2,508,855 62.7%2,990,190 (1,860,178)
Charges for Services 1,049,373 777,023 1,012,560 76.7%1,253,100 (272,350)
Fines and Penalties 187,538 136,041 160,000 85.0%192,000 (51,497)
Administrative Towing Fees 18,530 15,778 16,650 94.8%20,000 (2,752)
Investment Interest 386,584 310,777 345,850 89.9%415,000 (75,807)
Franchise Fees 111,255 105,921 157,500 67.3%210,000 (5,334)
Miscellaneous Income 192,804 339,664 372,550 91.2%443,095 146,860
Total Operating Revenues 22,369,868$ 18,786,727$ 21,346,465$ 88.0%25,502,385$ (3,583,141)$
OPERATING EXPENDITURES
Personnel 14,874,443$ 15,230,619$ 15,657,565$ 97.3%19,160,220$ 356,176$
Materials and Supplies 373,335 384,560 457,700 84.0%539,170 11,225
Operation and Contract 3,504,505 3,068,638 3,534,990 86.8%4,071,660 (435,867)
Other Expenditures 9,537 6,547 8,460 77.4%10,000 (2,990)
Capital Outlay 859,842 159,580 651,080 24.5%688,030 (700,262)
Total Operating Expenditures 19,621,662$ 18,849,944$ 20,309,795$ 92.8%24,469,080$ (771,718)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 2,748,206$ (63,217)$ 1,036,670$ 1,033,305$ (2,811,423)$
INTERFUND TRANSACTIONS
Transfers In 508,235$ -$ -$ 0.0%-$ (508,235)$
Transfers Out (334,203) (326,369) (762,755) 42.8%(923,000) 7,834
Reimbursements From Other Funds 526,840 521,990 522,000 100.0%626,395 (4,850)
Reimbursements To Other Funds (109,250) (116,470) (116,450) 100.0%(139,770) (7,220)
Total Interfund Transactions 591,622$ 79,151$ (357,205)$ -22.2%(436,375)$ (512,471)$
NET FUND INCREASE (DECREASE)3,339,828$ 15,934$ 679,465$ 596,930$ (3,323,894)$
*Includes the collection of Income Tax, Use Tax, Road & Bridge Tax, Personal Property Replacement Tax, and Cannabis Use Tax.
Village of Oak Brook
General Fund Financial Update
For the Period Ending October 31, 2020
Total Total
Revenues Expenditures
10/31/20 Actual 18,786,727$ 18,849,944$
10/31/19 Actual 22,369,868$ 19,621,662$
% Change From Last Year -16.0%-3.9%
Major Revenues
Other Telecom/Utility Licenses &Charges for
Sales Tax Intergov. Tax Tax Permits Services
10/31/20 Actual 9,199,893$ 1,337,410$ 4,991,145$ 1,573,075$ 777,023$
10/31/19 Actual $ 10,428,409 $ 1,302,270 $ 5,259,852 $ 3,433,253 $ 1,049,373
% Change From Last Year -11.8%2.7%-5.1%-54.2%-26.0%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
10/31/20 Actual 15,230,619$ 384,560$ 3,068,638$ 6,547$ 159,580$
10/31/19 Actual 14,874,443$ 373,335$ 3,504,505$ 9,537$ 859,842$
% Change From Last Year 2.4%3.0%-12.4%-31.4%-81.4%
Five Year Trend
Expenditures by Department
10/31/19 10/31/20 10/31/20 10/31/20 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Department Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 1,931,441$ 1,720,907$ 2,145,950$ 80.2%2,556,835$ (210,534)$
Financial Services 619,106 628,523 646,120 97.3%781,455 9,417
Public Works 728,077 666,642 741,195 89.9%893,055 (61,435)
Engineering & Capital Projects 473,581 53,528 391,200 13.7%411,500 (420,053)
Library 760,057 703,145 820,375 85.7%994,410 (56,912)
Police 7,540,016 7,492,340 7,862,660 95.3%9,493,905 (47,676)
Fire 6,782,189 6,735,012 6,862,880 98.1%8,298,370 (47,177)
Development Services 787,195 849,847 839,415 101.2%1,039,550 62,652
Total Expenditures 19,621,662$ 18,849,944$ 20,309,795$ 92.8%24,469,080$ (771,718)$
Five Year Trend
For the Period Ending October 31, 2020
General Fund - Five Year Trend
Village of Oak Brook
Revenues Expenditures
10/31/20 10/31/20
10/31/19 10/31/20 YTD % of YTD 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Hotel Tax 1,057,362$ 439,109$ 1,003,100$ 43.8%1,212,500$ (618,253)$
Investment Interest 94,777 60,361 62,500 96.6%75,000 (34,416)
Loan Interest - 4,167 - N/A - 4,167
Total Operating Revenues 1,152,139$ 503,637$ 1,065,600$ 47.3%1,287,500$ (648,502)$
EXPENDITURES
Operation and Contract 515,329$ 308,804$ 590,525$ 52.3%576,615$ (206,525)$
Capital Outlay - 473,243 330,395 143.2%640,395 473,243
Total Expenditures 515,329$ 782,047$ 920,920$ 84.9%1,217,010$ 266,718$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 636,810$ (278,410)$ 144,680$ -192.4%70,490$ (915,220)$
INTERFUND TRANSACTIONS
Transfer Out -$ -$ (257,825)$ 0.0%(338,125)$ -$
Reimbursements to Other Funds (85,930) (62,260) (62,250) 100.0%(74,715) 23,670
Total Interfund Transactions (85,930)$ (62,260)$ (320,075)$ 19.5%(412,840)$ 23,670$
NET FUND INCREASE (DECREASE)550,880$ (340,670)$ (175,395)$ (342,350)$ (891,550)$
Note - Expenditures are recorded in program 171.
Village of Oak Brook
Hotel Tax Fund Financial Update
For the Period Ending October 31, 2020
Total Total
Revenues Expenditures
10/31/20 Actual $ 503,637 782,047$
10/31/19 Actual $ 1,152,139 515,329$
% Change From Last Year -56.3%51.8%
Major Revenues Investment
Hotel Tax Interest Loan Interest Miscellaneous
10/31/20 Actual $ 439,109 $ 60,361 4,167$ -$
10/31/19 Actual $ 1,057,362 $ 94,777 -$ -$
% Change From Last Year -58.5%-36.3%N/A 0.0%
Five Year Trend
Major Expenditures Operation &
Contractual Capital Outlay
10/31/20 Actual 308,804$ 473,243$
10/31/19 Actual 515,329$ -$
% Change From Last Year -40.1%N/A
Five Year Trend
Village of Oak Brook
Hotel Tax Fund - Major Sources Five Year Trend
For the Period Ending October 31, 2020
Five Year Trend
Revenues Expenditures
10/31/20 10/31/20
10/31/19 10/31/20 YTD % of YTD 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 4,727,879$ 4,005,135$ 4,693,000$ 85.3%5,615,000$ (722,744)$
Charges for Services 965 335 850 39.4%1,000 (630)
Investment Interest 189,155 75,310 104,150 72.3%125,000 (113,845)
Miscellaneous - - 2,100 0.0%2,500 -
Total Operating Revenues 4,917,999$ 4,080,780$ 4,800,100$ 85.0%5,743,500$ (837,219)$
OPERATING EXPENDITURES
Personnel 1,061,972$ 1,058,545$ 1,118,905$ 94.6%1,389,540$ (3,427)$
Materials and Supplies 112,384 134,712 138,425 97.3%253,295 22,328
Operation and Contract 1,279,563 1,077,501 1,569,185 68.7%1,856,790 (202,062)
Capital Outlay 3,324,824 2,596,230 8,570,445 30.3%10,220,090 (728,594)
Total Operating Expenditures 5,778,743$ 4,866,988$ 11,396,960$ 42.7%13,719,715$ (911,755)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES (860,744)$ (786,208)$ (6,596,860)$ 11.9%(7,976,215)$ 74,536$
INTERFUND TRANSACTIONS
Transfers In 216,125$ 666,289$ 1,572,825$ 42.4%1,653,125$ 450,164$
Reimbursements From Other Funds 277,870 299,480 299,500 100.0%359,380 21,610
Reimbursements To Other Funds (134,610) (135,250) (135,250) 100.0%(162,300) (640)
Total Interfund Transactions 359,385$ 830,519$ 1,737,075$ 47.8%1,850,205$ 471,134$
NET FUND INCREASE (DECREASE)(501,359)$ 44,311$ (4,859,785)$ (6,126,010)$ 545,670$
Village of Oak Brook
Infrastructure Fund Financial Update
For the Period Ending October 31, 2020
Total Total
Revenues Expenditures
10/31/20 Actual $ 4,080,780 4,866,988$
10/31/19 Actual $ 4,917,999 5,778,743$
% Change From Last Year -17.0%-15.8%
Major Revenues
Sales Tax
Charges for
Services
Investment
Interest Miscellaneous
10/31/20 Actual $ 4,005,135 $ 335 $ 75,310 $ -
10/31/19 Actual $ 4,727,879 $ 965 $ 189,155 $ -
% Change From Last Year -15.3%-65.3%-60.2%0.0%
Five Year Trend
Major Expenditures Materials &Operation &
Personnel Supplies Contractual Capital Outlay
10/31/20 Actual 1,058,545$ 134,712$ 1,077,501$ 2,596,230$
10/31/19 Actual 1,061,972$ 112,384$ 1,279,563$ 3,324,824$
% Change From Last Year -0.3%19.9%-15.8%-21.9%
Five Year Trend
Expenditures by Department
10/31/19 10/31/20 10/31/20 10/31/20 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 130,864$ 109,993$ 143,870$ 76.5%176,490$ (20,871)$
Public Works 3,144,047 3,467,539 3,902,705 88.8%4,390,810 323,492
Engineering & Capital Projects 2,503,832 1,289,456 7,350,385 17.5%9,152,415 (1,214,376)
Total Expenditures 5,778,743$ 4,866,988$ 11,396,960$ 42.7%13,719,715$ (911,755)$
Five Year Trend
Village of Oak Brook
Infrastructure Fund - Major Sources Five Year Trend
For the Period Ending October 31, 2020
Revenues Expenditures
10/31/20 10/31/20
10/31/19 10/31/20 YTD % of YTD 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 65,184$ 49,048$ 71,250$ 68.8%95,000$ (16,136)$
Real Estate Tax 411,687 414,544 380,000 109.1%380,000 2,857
Investment Interest 1,570 509 1,250 40.7%1,500 (1,061)
Total Operating Revenues 478,441$ 464,101$ 452,500$ 102.6%476,500$ (14,340)$
EXPENDITURES
Operation and Contract 3,748$ 4,303$ 3,890$ 110.6%3,890$ 555$
Other Expenditures 460,980 529,900 504,900 105.0%504,900 68,920
Total Expenditures 464,728$ 534,203$ 508,790$ 105.0%508,790$ 69,475$
NET FUND INCREASE (DECREASE)13,713$ (70,102)$ (56,290)$ (32,290)$ (83,815)$
Note - Expenditures are recorded in program 283.
Village of Oak Brook
Promenade TIF Fund Financial Update
For the Period Ending October 31, 2020
Total Total
Revenues Expenditures
10/31/20 Actual $ 464,101 534,203$
10/31/19 Actual $ 478,441 464,728$
% Change From Last Year -3.0%14.9%
Major Revenues Real Estate Investment
Sales Tax Tax Interest
10/31/20 Actual 49,048$ $ 414,544 $ 509
10/31/19 Actual 65,184$ $ 411,687 $ 1,570
% Change From Last Year -24.8%0.7%-67.6%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures
10/31/20 Actual 4,303$ 529,900$
10/31/19 Actual 3,748$ 460,980$
% Change From Last Year 14.8%15.0%
Five Year Trend
Village of Oak Brook
Promenade TIF Fund - Major Sources Five Year Trend
For the Period Ending October 31, 2020
Five Year Trend
Revenues Expenditures
10/31/20 10/31/20
10/31/19 10/31/20 YTD % of YTD 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Plan Review Fees 1,275$ 825$ 1,000$ 82.5%1,200$ (450)$
Building/Inspection Fees 6,113 5,662 6,650 85.1%8,000 (451)
Water Sales 8,065,866 8,168,656 8,630,000 94.7%10,302,525 102,790
Unmetered Sales 42,492 78,456 25,000 313.8%30,000 35,964
Water Connection Fees 172,250 20,510 83,350 24.6%100,000 (151,740)
Meter Charges 25,437 9,157 16,670 54.9%20,000 (16,280)
Special Services 16,772 12,657 15,000 84.4%30,000 (4,115)
Investment Interest 148,655 84,189 108,350 77.7%130,000 (64,466)
Miscellaneous 61,122 20,103 62,500 32.2%75,000 (41,019)
Total Operating Revenues 8,539,982$ 8,400,215$ 8,948,520$ 93.9%10,696,725$ (139,767)$
OPERATING EXPENDITURES
Personnel 655,576$ 633,843$ 710,335$ 89.2%868,705$ (21,733)$
Materials and Supplies 51,702 33,193 63,120 52.6%74,260 (18,509)
Operation and Contract 3,966,224 3,991,365 4,859,095 82.1%5,833,755 25,141
Capital Outlay 2,735,388 2,586,209 4,546,660 56.9%6,293,225 (149,179)
Total Expenditures 7,408,890$ 7,244,610$ 10,179,210$ 71.2%13,069,945$ (164,280)$
Surplus (Deficit) of Revenues Over
Expenditures 1,131,092$ 1,155,605$ (1,230,690)$ -93.9%(2,373,220)$ 24,513$
INTERFUND TRANSACTIONS
Transfers In 221,085$ -$ -$ 0.0%-$ (221,085)
Reimbursements To Other Funds (459,860) (439,010) (439,000) 100.0%(526,815) 20,850
Total Interfund Transactions (238,775)$ (439,010)$ (439,000)$ 100.0%(526,815)$ (200,235)$
Fund Increase/(Decrease) - Budgetary Basis 892,317$ 716,595$ (1,669,690)$ -42.9%(2,900,035)$ (175,722)$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay 2,735,388$ 2,586,209$
Depreciation Expense (426,754) (479,167)
IMRF Pension Expense 64,363 41,667
OPEB Expense (40,854) (37,500)
Total GAAP Adjustments 2,332,143$ 2,111,209$
Fund Increase/(Decrease) - GAAP Basis 3,224,460$ 2,827,804$
*Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.
Village of Oak Brook
Water Fund Financial Update
For the Period Ending October 31, 2020
Total Total
Revenues Expenditures
10/31/20 Actual $ 8,400,215 7,244,610$
10/31/19 Actual $ 8,539,982 7,408,890$
% Change From Last Year -1.6%-2.2%
Unmetered Water
Water Sales Sales Connection Fees Meter Charges Miscellaneous
10/31/20 Actual $ 8,168,656 $ 78,456 $ 20,510 $ 9,157 $ 20,103
10/31/19 Actual $ 8,065,866 $ 42,492 $ 172,250 $ 25,437 $ 61,122
% Change From Last Year 1.3%84.6%-88.1%-64.0%-67.1%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
10/31/20 Actual 633,843$ 33,193$ 3,991,365$ -$ 2,586,209$
10/31/19 Actual 655,576$ 51,702$ 3,966,224$ -$ 2,735,388$
% Change From Last Year -3.3%-35.8%0.6%0.0%-5.5%
Five Year Trend
Expenditures by Department
10/31/19 10/31/20 10/31/20 10/31/20 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Public Works 4,666,436$ 4,689,659$ 5,424,560$ 86.5%6,527,120$ 23,223$
Engineering & Capital Projects 2,742,454 2,554,951 4,754,650 53.7%6,542,825 (187,503)
Total Expenditures 7,408,890$ 7,244,610$ 10,179,210$ 71.2%13,069,945$ (164,280)$
Five Year Trend
Village of Oak Brook
Water Fund - Major Sources Five Year Trend
For the Period Ending October 31, 2020
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Sports Core Fund Consolidated Presentation
For the Period Ending October 31, 2020
10/31/20 10/31/20
10/31/20 YTD % of YTD 2020 10/31/19 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 199$ -$ -$ 224,688$ 224,887$ 459,135$ 49.0%459,135$ 419,681$ (194,794)$
Greens Fees - - - 1,047,163 1,047,163 930,000 112.6%930,000 901,632 145,531
Pro Shop Sales - - - 168,377 168,377 200,500 84.0%207,000 193,420 (25,043)
Golf Lessons - - - 41,580 41,580 40,000 104.0%40,000 33,726 7,854
Driving Range Fees - - - 262,779 262,779 244,000 107.7%244,000 242,380 20,399
Rentals - 97,540 20,402 337,959 455,901 885,775 51.5%962,000 876,717 (420,816)
Programs/User Fees - - - - - 66,300 0.0%66,300 68,815 (68,815)
Food Sales - - - 152,268 152,268 177,300 85.9%180,500 181,542 (29,274)
Beverage Sales - - - 337,532 337,532 259,815 129.9%265,000 266,784 70,748
Taste of Oak Brook - - - - - 120,000 0.0%120,000 - -
Grants - - - - - 139,800 0.0%139,800 - -
Other Revenue 1,481 - - 5,207 6,688 10,960 61.0%11,000 136,282 (129,594)
Total Operating Revenues 1,680$ 97,540$ 20,402$ 2,577,553$ 2,697,175$ 3,533,585$ 76.3%3,624,735$ 3,320,979$ (623,804)$
OPERATING EXPENDITURES
Personnel 53,654$ -$ 88,955$ 1,146,642$ 1,289,251$ 1,386,080$ 93.0%1,578,100$ 1,378,478$ (89,227)$
Materials & Supplies 3,723 119 1,693 511,869 517,404 583,585 88.7%618,025 624,927 (107,523)
Operational & Contractual 72,606 24,122 50,117 259,947 406,792 1,012,225 40.2%1,055,095 893,883 (487,091)
Other - - - - - (83,150) 0.0%(83,150) - -
Capital 374,075 9,421 36,215 458,527 878,238 1,621,500 54.2%1,921,545 1,148,004 (269,766)
Total Operating Expenditures 504,058$ 33,662$ 176,980$ 2,376,985$ 3,091,685$ 4,520,240$ 68.4%5,089,615$ 4,045,292$ (953,607)$
B&T Administration Overhead Allocation*90,341$ -$ (90,341)$ -$ -$ -$ 0.0%-$ -$ -$
Operating Revenues Over (Under) Expenditures (412,037)$ 63,878$ (246,919)$ 200,568$ (394,510)$ (986,655)$ 40.0%(1,464,880)$ (724,313)$ 329,803$
INTERFUND TRANSACTIONS
Transfer From General Fund 326,369$ -$ -$ -$ 326,369$ 762,755$ 42.8%923,000$ 334,203$ (7,834)$
Transfer From Hotel Tax Fund - - - - - 35,000 0.0%35,000 - -
Transfer From Golf Surcharge Fund - - - 323,373 323,373 400,000 80.8%400,000 212,969 110,404
Reimbursement From Infrastructure Fund 20,000 - - - 20,000 20,000 100.0%24,000 20,000 -
Reimbursement From Water Fund 6,670 - - - 6,670 6,650 100.3%8,000 6,670 -
Reimbursement To General Fund (23,520) - - (23,520) (47,040) (47,000) 100.1%(56,450) - (47,040)
Total Interfund Transactions 329,519$ -$ -$ 299,853$ 629,372$ 1,177,405$ 53.5%1,333,550$ 573,842$ 55,530$
Total Revenues Over (Under) Expenditures - Budgetary Basis (82,518)$ 63,878$ (246,919)$ 500,421$ 234,862$ 190,750$ (131,330)$ (150,471)$ 385,333$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 374,075$ 9,421$ 36,215$ 458,527$ 878,238$ 1,148,004$
Depreciation Expense (124,919) (1,404) (29,167) (176,667) (332,157) (273,658)
IMRF Pension Expense (4,375) (208) (1,667) (9,875) (16,125) 77,309
OPEB Expense - - (4,333) (33,333) (37,667) (16,696)
Total GAAP Adjustments 244,781$ 7,809$ 1,048$ 238,652$ 492,290$ 934,960$
Fund Increase/(Decrease) - GAAP Basis 162,263$ 71,687$ (245,871)$ 739,073$ 727,152$ 784,489$
*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
10/31/20 Actual $ 2,697,175 3,091,685$
10/31/19 Actual $ 3,320,979 4,045,292$
% Change From Last Year -18.8%-23.6%
Driving Program/
Memberships Greens Fees Range Fees Rentals User Fees
10/31/20 Actual $ 224,887 $ 1,047,163 $ 262,779 $ 455,901 -$
10/31/19 Actual $ 419,681 $ 901,632 $ 242,380 $ 876,717 68,815$
% Change From Last Year -46.4%16.1%8.4%-48.0%-100.0%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
10/31/20 Actual 1,289,251$ 517,404$ 406,792$ -$ 878,238$
10/31/19 Actual 1,378,478$ 624,927$ 893,883$ -$ 1,148,004$
% Change From Last Year -6.5%-17.2%-54.5%0.0%-23.5%
Five Year Trend
Revenues by Department 10/31/19 10/31/20 10/31/20 10/31/20 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Operations 357,082$ 1,680$ 506,695$ 0.3%506,735$ (300,493)$
Open Field Operations 356,138 97,540 399,500 24.4%407,000 (258,598)
B&T Clubhouse Operations 307,399 20,402 240,000 8.5%300,000 (286,997)
Golf Club 2,300,360 2,577,553 2,387,390 108.0%2,411,000 277,193
Total Revenues 3,320,979$ 2,697,175$ 3,533,585$ 76.3%3,624,735$ (568,895)$
Expenditures by Department 10/31/19 10/31/20 10/31/20 % of YTD 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Operations 1,054,445$ 504,058$ 1,440,025$ 35.0%1,752,045$ (550,387)$
Open Field Operations 148,173$ 33,662$ 261,055$ 12.9%267,110$ (114,511)$
B&T Clubhouse Operations 568,459 176,980 419,165 42.2%458,770 (391,479)
Golf Club 2,274,215 2,376,985 2,399,995 99.0%2,611,690 102,770
Total Expenditures 4,045,292$ 3,091,685$ 4,520,240$ 68.4%5,089,615$ (953,607)$
Five Year Trend
Village of Oak Brook
Sports Core Fund - Major Sources Five Year Trend
For the Period Ending October 31, 2020
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Club Recreation Operations
For the Period Ending October 31, 2020 10/31/20 10/31/20
822 10/31/20 YTD % of YTD 2020 10/31/19 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 -$ 199$ -$ -$ 199$ 241,635$ 0.1%241,635$ 222,006$ (221,807)$
Programs/User Fees - - - - - 66,300 0.0%66,300 68,815 (68,815)
Food Sales - - - - - 36,000 0.0%36,000 35,375 -
Beverage Sales - - - - - 20,000 0.0%20,000 19,534 -
Grants - - - - - 139,800 0.0%139,800 - -
Other Revenue 1,481 - - - 1,481 2,960 50.0%3,000 11,352 (9,871)
Total Operating Revenues 1,481$ 199$ -$ -$ 1,680$ 506,695$ 0.3%506,735$ 357,082$ (300,493)$
OPERATING EXPENDITURES
Personnel 53,338$ -$ -$ 316$ 53,654$ 159,730$ 33.6%163,580$ 137,919$ (84,265)$
Materials & Supplies 523 2,165 1,035 - 3,723 57,100 6.5%57,650 70,005 (66,282)
Operational & Contractual 60,277 5,680 6,649 - 72,606 410,695 17.7%418,270 396,564 (323,958)
Capital 44,504 329,477 94 - 374,075 812,500 46.0%1,112,545 449,957 (75,882)
Total Operating Expenditures 158,642$ 337,322$ 7,778$ 316$ 504,058$ 1,440,025$ 35.0%1,752,045$ 1,054,445$ (550,387)$
B&T Administration Overhead Allocation*180,681$ (65,045)$ (18,068)$ (7,227)$ 90,341$ 89,890$ 100.5%93,235$ 100,315$ (9,974)$
Operating Revenues Over (Under) Expenditures 23,520$ (402,168)$ (25,846)$ (7,543)$ (412,037)$ (843,440)$ 48.9%(1,152,075)$ (597,048)$ 239,920$
INTERFUND TRANSACTIONS
Transfer From General Fund -$ 326,369$ -$ -$ 326,369$ 597,255$ 54.6%757,500$ 48,704$ 277,665$
Reimbursement From Infrastructure Fund 20,000 - - - 20,000 20,000 100.0%24,000 20,000 -
Reimbursement From Water Fund 6,670 - - - 6,670 6,650 100.3%8,000 6,670 -
Reimbursement To General Fund (23,520) - - - (23,520) (23,500) 100.1%(28,225) - (23,520)
Total Interfund Transactions 3,150$ 326,369$ -$ -$ 329,519$ 600,405$ 54.9%761,275$ 75,374$ 254,145$
Total Revenues Over (Under) Expenditures - Budgetary Basis 26,670$ (75,799)$ (25,846)$ (7,543)$ (82,518)$ (243,035)$ (390,800)$ (521,674)$ 494,065$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 44,504$ 329,477$ 94$ -$ 374,075$ 449,957$
Depreciation Expense - (119,779) (4,167) (973) (124,919) (79,020)
IMRF Pension Expense (4,167) - - (208) (4,375) 5,083
Total GAAP Adjustments 40,337$ 209,698$ (4,073)$ (1,182)$ 244,781$ 376,020$
Fund Increase/(Decrease) - GAAP Basis 67,007$ 133,899$ (29,919)$ (8,725)$ 162,263$ (145,655)$
*Overhead allocation is comprised of salaries, business forms, liability insurance, building & grounds maintenance and bank service fees in Program 811 - Sports Core General Operations distributed to various Sports Core Programs on
a percentage basis.
**Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.
Village of Oak Brook
Monthly Operating Statement
Open Fields Operations
For the Period Ending October 31, 2020 10/31/20 10/31/20
10/31/20 YTD % of YTD 2020 10/31/19 Difference
815 816 YTD Amended Amended Adopted YTD Prior
Polo Open Fields Total Budget Budget Budget Total Year
OPERATING REVENUES
Field Rentals -$ 22,540$ 22,540$ 204,500$ 11.0%212,000$ 166,398$ (143,858)$
Range Rentals - 75,000 75,000 75,000 100.0%75,000 75,000 -
Taste of Oak Brook - - - 120,000 0.0%120,000 - -
Other Revenue - - - - 0.0%- 114,740 (114,740)
Total Operating Revenues -$ 97,540$ 97,540$ 399,500$ 24.4%407,000$ 356,138$ (258,598)$
OPERATING EXPENDITURES
Personnel -$ -$ -$ 6,505$ 0.0%10,810$ 3,962$ (3,962)$
Materials & Supplies - 119 119 1,700 7.0%1,700 1,375 (1,256)
Operational & Contractual - 24,122 24,122 237,850 10.1%239,600 128,216 (104,094)
Capital - 9,421 9,421 15,000 62.8%15,000 14,620 (5,199)
Total Operating Expenditures -$ 33,662$ 33,662$ 261,055$ 12.9%267,110$ 148,173$ (114,511)$
Operating Revenues Over (Under) Expenditures -$ 63,878$ 63,878$ 138,445$ 46.1%139,890$ 207,965$ (144,087)$
INTERFUND TRANSACTIONS
Transfer From Hotel Tax Fund -$ -$ -$ 35,000$ 0.0%35,000$ -$ -$
Total Interfund Transactions -$ -$ -$ 35,000$ 0.0%35,000$ -$ -$
Total Revenues Over (Under) Expenditures - Budgetary Basis -$ 63,878$ 63,878$ 173,445$ 174,890$ 207,965$ (144,087)$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay -$ 9,421$ 9,421$ 14,620$
Depreciation Expense - (1,404) (1,404) (1,404)
IMRF Pension Expense - (208) (208) 613
Total GAAP Adjustments -$ 7,809$ 7,809$ 13,828$
Fund Increase/(Decrease) - GAAP Basis -$ 71,687$ 71,687$ 221,793$
*Overhead allocation is comprised of salaries, business forms, liability insurance, building & grounds maintenance and bank service fees in Program 811 - Sports Core General Operations distributed to
various Sports Core Programs on a percentage basis.
**Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Clubhouse Operations
For the Period Ending October 31, 2020
10/31/20 10/31/20
821 YTD % of YTD 2020 10/31/19 Difference
B&T Amended Amended Adopted YTD Prior
Clubhouse Budget Budget Budget Total Year
OPERATING REVENUES
Rentals 20,402$ 240,000$ 8.5%300,000$ 307,399$ (286,997)$
Total Operating Revenues 20,402$ 240,000$ 8.5%300,000$ 307,399$ (286,997)$
OPERATING EXPENDITURES
Personnel 88,955$ 115,830$ 76.8%140,045$ 109,766$ (20,811)$
Materials & Supplies 1,693 17,175 9.9%20,225 19,500 (17,807)
Operational & Contractual 50,117 97,160 51.6%109,500 85,066 (34,949)
Capital 36,215 189,000 19.2%189,000 354,127 (317,912)
Total Operating Expenditures 176,980$ 419,165$ 42.2%458,770$ 568,459$ (391,479)$
B&T Administration Overhead Allocation*(90,341)$ (89,890)$ 100.5%(93,235)$ (100,315)$ 9,974$
Operating Revenues Over (Under) Expenditures (246,919)$ (269,055)$ 91.8%(252,005)$ (361,375)$ 114,456$
INTERFUND TRANSACTIONS
Transfer From General Fund -$ 165,500$ 0.0%165,500$ 285,499$ (285,499)$
Total Interfund Transactions -$ 165,500$ 0.0%165,500$ 285,499$ (285,499)$
Total Revenues Over (Under) Expenditures - Budgetary Basis (246,919)$ (103,555)$ (86,505)$ (75,876)$ (171,043)$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 36,215$ 354,127$
Depreciation Expense (29,167) (26,793)
IMRF Pension Expense (1,667) 5,583
OPEB Expense (4,333) (1,750)
Total GAAP Adjustments 1,048$ 331,167$
Fund Increase/(Decrease) - GAAP Basis (245,871)$ 255,291$
*Overhead allocation is comprised of salaries, business forms, liability insurance, building & grounds maintenance and bank service fees in Program 811 -
Sports Core General Operations distributed to various Sports Core Programs on a percentage basis.
**Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.
Village of Oak Brook
Monthly Operating Statement
Golf Club Programs
For the Period Ending October 31, 2020
10/31/20 10/31/20
823 831 832 833 834 10/31/20 YTD % of YTD 2020 10/31/19 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 -$ 224,688$ -$ -$ -$ 224,688$ 217,500$ 103.3%217,500$ 197,675$ 27,013$
Greens Fees - 1,047,163 - - - 1,047,163 930,000 112.6%930,000 901,632 145,531
Pro Shop Sales - 168,377 - - - 168,377 200,500 84.0%207,000 193,420 (25,043)
Golf Lessons - - 41,580 - - 41,580 40,000 104.0%40,000 33,726 7,854
Driving Range Fees - - 262,779 - - 262,779 244,000 107.7%244,000 242,380 20,399
Rentals - 330 - 337,629 - 337,959 366,275 92.3%375,000 327,920 10,039
Food Sales 152,268 - - - - 152,268 141,300 107.8%144,500 146,167 6,101
Beverage Sales 337,532 - - - - 337,532 239,815 140.7%245,000 247,250 90,282
Other Revenue - 5,207 - - - 5,207 8,000 65.1%8,000 10,190 (4,983)
Total Operating Revenues 489,800$ 1,445,765$ 304,359$ 337,629$ -$ 2,577,553$ 2,387,390$ 108.0%2,411,000$ 2,300,360$ 277,193$
OPERATING EXPENDITURES
Personnel 161,316$ 424,266$ 77,113$ 44,131$ 439,816$ 1,146,642$ 1,104,015$ 103.9%1,263,665$ 1,126,831$ 19,811$
Materials & Supplies 200,394 135,617 11,638 1,351 162,869 511,869 507,610 100.8%538,450 534,047 (22,178)
Operational & Contractual 5,410 159,951 121 54,238 40,227 259,947 266,520 97.5%287,725 284,037 (24,090)
Other - - - - - - (83,150) 0.0%(83,150) - -
Capital 12,059 358,761 - - 87,707 458,527 605,000 75.8%605,000 329,300 129,227
Total Operating Expenditures 379,179$ 1,078,595$ 88,872$ 99,720$ 730,619$ 2,376,985$ 2,399,995$ 99.0%2,611,690$ 2,274,215$ 102,770$
Operating Revenues Over (Under) Expenditures 110,621$ 367,170$ 215,487$ 237,909$ (730,619)$ 200,568$ (12,605)$ -1591.2%(200,690)$ 26,145$ 174,423$
INTERFUND TRANSACTIONS
Transfer from Golf Surcharge -$ 323,373$ -$ -$ -$ 323,373$ 400,000$ 80.8%400,000$ 212,969$ 110,404$
Reimbursement to General Fund - (23,520) - - - (23,520) (23,500) 100.1%(28,225) - (23,520)
Total Interfund Transactions -$ 299,853$ -$ -$ -$ 299,853$ 376,500$ 79.6%371,775$ 212,969$ 86,884$
Total Revenues Over (Under) Expenditures - Budgetary Basis 110,621$ 667,023$ 215,487$ 237,909$ (730,619)$ 500,421$ 363,895$ 171,085$ 239,114$ 261,307$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay 12,059$ 358,761$ -$ -$ 87,707$ 458,527$ 329,300$
Depreciation Expense - (112,500) (3,333) (19,167) (41,667) (176,667) (166,441)
IMRF Pension Expense (1,250) (4,167) (292) - (4,167) (9,875) 66,032
OPEB Expense (2,500) (19,167) - - (11,667) (33,333) (14,946)
Total GAAP Adjustments 8,309$ 222,928$ (3,625)$ (19,167)$ 30,207$ 238,652$ 213,945$
Fund Increase/(Decrease) - GAAP Basis 118,930$ 889,951$ 211,862$ 218,742$ (700,412)$ 739,073$ 453,059$
*Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.