04 - April 2020 Monthly Financial ReportVILLAGE
OAK BROOK
OF
MONTHLY FINANCIAL REPORTS
APRIL 2020
ITEM 6.G
Cash and Investments by Fund:Total
Cash and Cash Pooled Cash and
Fund Equivalents Investments Investments % By Fund
General Corporate $6,664,827 $15,347,899 $22,012,726 48.8%
Hotel/Motel Tax 2,360,456 2,468,005 4,828,461 10.7%
Motor Fuel Tax 1,112,965 81,304 1,194,270 2.6%
Infrastructure 7,018,381 1,971,963 8,990,344 19.9%
Promenade TIF 58,346 - 58,346 0.1%
Water 3,041,011 3,506,450 6,547,461 14.5%
Sports Core - - - 0.0%
Golf Surcharge - 30,400 30,400 0.1%
Self-Insurance 297,900 - 297,900 0.7%
Garage 304,709 - 304,709 0.7%
Equipment Replacement 497,984 375,427 873,410 1.9%
Total $21,356,579 $23,781,448 $45,138,027 100.0%
Change in Cash and Investments by Fund :
Balance at Balance at Year-to-Date Year-to-Date
Fund January 1, 2020 April 30, 2020 Change ($)Change (%)
General Corporate $21,270,239 $22,012,726 $742,487 3.5%
Hotel/Motel Tax 5,427,474 4,828,461 (599,013)-11.0%
Motor Fuel Tax 1,085,595 1,194,270 108,675 10.0%
Infrastructure 8,217,724 8,990,344 772,620 9.4%
Promenade TIF 304,194 58,346 (245,848)-80.8%
Water 6,947,239 6,547,461 (399,778)-5.8%
Sports Core 231,216 - (231,216)-100.0%
Golf Surcharge 347,066 30,400 (316,666)-91.2%
Self-Insurance 308,820 297,900 (10,920)-3.5%
Garage 275,988 304,709 28,721 10.4%
Equipment Replacement 808,879 873,410 64,531 8.0%
$45,224,434 $45,138,027 ($86,407)-0.2%
Book Bank/Market
Value Value
Cash and Cash Equivalents:
Pooled Checking $171,934 $906,281
Sports Core Checking 187,856 94,251
Pooled IPTIP 20,789,563 20,789,563
Water E-Pay IPTIP 207,226 197,368
$21,356,579 $21,987,464
Pooled Investments:
Investments-Municipal Bonds $6,763,929 $6,762,967
Investments-Corporate Bonds 8,299,959 8,391,267
Government & Agency Obligations 2,070,356 2,110,289
Certificates of Deposit 6,485,000 6,569,122
Accrued Interest 162,204 162,204
Total Pooled Investments $23,781,448 $23,995,849
Total Cash and Investments $45,138,027 $45,983,313
For April, total interest revenue is $61,384 and YTD is $273,689. The total investment yield for the portfolio is:
Pooled
Investments Illinois Funds Total
Last 12 months yield 2.30%1.96%2.14%
The weighted average yield of the current pooled investment portfolio is 2.24%. The IL Funds April average daily rate was 1.00%.
Monthly Treasurer's Report
April 30, 2020
Monthly Treasurer's Report
April 2020
The table below lists the detail investment holdings at J.P. Morgan Securities as of 4/30/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,676 201,180 2,336
Florida Hurricane #34074GDH4 03/30/16 07/01/20 2.995%2.150%500,608 501,725 4,991
Bloomingdale Mich Pub Sch Dist #094383FS0 04/26/16 05/01/22 2.710%2.150%505,411 511,160 6,736
Milan Mich Area Achs #598801JD1 05/26/16 05/01/20 1.931%1.931%245,000 245,000 2,265
Lanse Creuse Mich Pub Schs #516228RL9 05/02/17 05/01/20 2.159%2.159%100,000 100,000 1,077
Connecticut St GO Bds 2016 #20772J3F7 06/15/17 08/15/21 1.750%2.300%496,539 501,560 1,794
Fowlerville Mich Comnty Schs #351280MS8 10/03/17 05/01/20 2.045%1.750%500,004 500,000 4,942
Wisconsin St Gen Fd Annual #977100CW4 01/05/18 05/01/20 1.446%2.100%599,988 600,000 4,242
Wright County Min #982276BC0 07/18/19 12/01/20 2.000%2.000%545,000 547,376 5,056
State of IL #452152P54 10/09/19 11/01/21 5.000%1.870%523,154 501,280 12,249
Anchor Bay Mich Sch #032879TE8 11/01/19 05/01/21 2.320%1.750%719,047 715,579 8,156
Brownsville TX #16405ST9 12/19/19 02/15/22 2.050%2.000%555,478 562,076 2,244
Laredo TX Waterworks #517039VW0 12/19/19 03/01/24 2.230%2.230%455,000 461,652 1,635
Manchester NH #562333JE5 03/12/20 12/01/20 5.000%0.850%486,469 486,557 9,855
Oakland Univ Mich #673588HJ1 04/29/20 03/01/24 5.000%1.650%331,555 327,822 2,458
Total Municipal Bonds $6,763,929 $6,762,967 $70,036
Corporate Bonds:
Goldman Sachs #38141GVP9 09/26/18 09/15/20 2.750%3.180%499,225 501,995 1,719
Wells Fargo #94974BGR5 01/15/19 12/07/20 2.550%3.120%1,385,422 1,401,023 14,473
PNC Bank #69353RFH6 01/30/19 01/22/21 2.500%3.020%498,164 504,565 3,438
Morgan Stanley #61747WAL3 03/08/19 07/28/21 5.500%3.034%1,081,162 1,101,261 14,758
Citigroup #172967LC3 04/01/19 12/08/21 2.900%2.754%1,002,266 1,020,060 10,956
Bank of America #06051GFT1 04/03/19 10/19/20 2.625%2.625%700,000 704,767 357
Goldman Sachs #38143U8F1 05/02/19 02/25/21 2.875%2.707%365,481 368,661 1,896
American Honda #02665WBG5 07/31/19 09/09/21 1.700%2.180%496,823 498,710 1,251
BB&T Corp #05531FAZ6 08/15/19 02/01/21 2.150%2.010%750,810 755,715 3,835
JP Morgan #48128BAB7 09/30/19 01/15/23 2.972%2.337%1,016,532 1,028,710 8,751
JP Morgan #46625HRT9 01/30/20 06/07/21 2.400%1.648%504,074 505,800 4,800
Total Corporate Bonds $8,299,959 $8,391,267 $66,234
Government & Agency Obligations:
*Government National Mtg Assn #38379UEM4 02/29/16 02/16/51 2.300%2.245%$605,346 $599,615 $2,314
*Government National Mtg Assn #38381WV96 08/06/19 07/20/54 2.250%2.293%852,978 875,884 1,523
*Government National Mtg Assn #38380BNV3 12/05/19 06/20/46 2.000%2.112%612,032 634,790 973
Total Government & Agency Obligations:$2,070,356 $2,110,289 $4,810
Certificates of Deposit:
State Bk India NY #8562846A7 01/26/17 01/26/22 2.250%2.250%$245,000 $251,784 $1,455
American Express Centurion #02587DV96 08/15/17 08/17/20 1.900%1.900%245,000 246,147 951
Sallie Mae #795450C86 08/16/17 08/17/20 1.900%1.900%245,000 246,147 951
Merrick Bank South Jordan #59013JZS1 08/21/17 08/21/20 1.800%1.800%245,000 246,095 114
Pinnacle Bank #72345SFS5 08/30/17 08/31/20 1.800%1.800%115,000 115,560 1
Jackson County Bank #466682AP6 08/31/17 03/01/21 1.850%1.850%245,000 248,111 762
Barclays Bank #06740KKX4 09/27/17 09/28/20 1.950%1.950%245,000 246,641 445
Goldman Sachs Bank #38148PRK5 10/18/17 10/19/20 1.950%1.950%245,000 246,869 153
FirstBank PR Santurce #33767A6M8 11/03/17 11/03/20 2.000%2.000%245,000 247,063 355
Compass Bank #20451PVW3 10/26/18 10/26/20 3.000%3.000%245,000 248,222 72
UBS Bank #90348JFH8 10/30/18 10/29/20 3.050%3.050%245,000 248,308 10
Discover Bank #254673WF9 11/07/18 11/09/20 3.000%3.000%245,000 248,420 3,532
Ally Bank #02007GFX6 11/08/18 11/09/20 3.000%3.000%245,000 248,420 3,512
Comenity Cap Bank #20033AU46 04/15/19 04/15/21 2.500%2.500%245,000 249,777 238
Morgan Stanley #61760AE21 05/30/19 06/01/21 2.400%2.400%245,000 250,000 2,426
First St Bank DeQueen #336460CU2 07/18/19 07/19/21 2.000%2.000%245,000 249,334 187
Bank Hapoalim #06251AW89 07/19/19 07/19/21 2.000%2.000%245,000 249,638 1,286
Capital One Natl Assn #14042RMF5 07/24/19 07/26/19 2.050%2.050%245,000 249,547 1,444
TIAA FSB Jacksonville #87270LCN1 07/29/19 07/29/21 2.000%2.000%245,000 249,420 1,246
Wells Fargo #949763J31 09/18/19 09/20/21 1.850%1.850%245,000 249,310 188
BMW Bank #05580ASQ8 10/11/19 10/12/21 1.800%1.800%245,000 249,297 178
Wells Fargo #949495AN5 01/17/20 01/18/22 1.800%1.800%245,000 249,834 187
Southpoint Bank #84464PBK2 02/28/20 02/28/22 1.600%1.600%245,000 246,041 9
New York Cmnty Bk Westbury #649447TM1 02/28/20 02/28/22 1.600%1.600%245,000 245,238 653
Bank Leumi #063248KQ0 03/31/20 03/31/22 1.250%1.250%245,000 247,656 255
Capital One Natl Assn #14042TCZ8 04/01/20 04/01/22 1.350%1.350%245,000 248,119 266
Synchrony Bank #87164WZN1 04/03/20 04/04/22 1.350%1.350%245,000 248,124 248
Total Certificates of Deposits $6,485,000 $6,569,122 $21,124
Total J.P.Morgan Securities $23,619,244 $23,833,645 $162,204
*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
April 30, 2020
Cash & Investments by Fund - Total $45.1 million
Cash & Investments by Type - Total $45.1 million
Checking
Illinois Funds
Certificates of Deposit
Municipal Bonds
Corporate Bonds
Government & Agency Obligations
Accrued Interest
General Corporate
48.77%
Hotel/Motel Tax
10.70%Motor Fuel Tax
2.65%
Infrastructure
19.92%
Promenade TIF
0.13%
Water
14.51%
Sports Core
0.00%
Golf Surcharge
0.07%
Self-Insurance
0.66%Garage
0.68%
Equipment
Replacement
1.93%
Checking, $0.3
Illinois Funds, $21.0
Certificates of Deposit,
$6.5
Municipal Bonds, $6.8
Corporate Bonds, $8.3
Government & Agency
Obligations, $2.1
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)8,873,742 $8,089,707 $784,035 $31,065
Main operating fund of the Village.
Hotel Fund (Major Fund)$293,931 $444,211 ($150,280)($55,520)
Collects and spends resources from the
3% hotel/motel tax.
Motor Fuel Tax Fund $113,834 $0 $113,834 $105,660
Collects and spends resources from the
State motor fuel tax.
Infrastructure Fund (Major Fund)$2,333,797 $1,142,947 $1,190,850 ($2,502,055)
Accounts for construction and maintenance of
roadways, drainage, and safety path systems.
Promenade TIF Fund (Major Fund)$19,607 $265,455 ($245,848)($241,205)
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)$2,628,112 $2,036,429 $591,683 ($129,405)
Collects user fees for the distribution of water
and maintenance of infrastructure.
Sports Core Fund (Major Fund)$1,077,740 $1,220,889 ($143,149)($756,140)
Accounts for revenues and expenses relating
to administration, programs, food and beverage
operations, and golf course.
Golf Surcharge Fund $4,066 $320,732 ($316,666)($386,160)
Accounts for the collection of the $3 per round
golf surcharge.
Internal Service Funds
Self Insurance Fund $1,157,391 $872,663 $284,728 ($14,000)
Accounts for the Village's health insurance costs
and the related contributions from the Village,
employees, retirees, and other agencies.
Garage Fund $245,424 $229,971 $15,453 ($10,210)
Accounts for the maintenance of the Village's vehicle
fleet and the related departmental reimbursements.
Equipment Replacement Fund $111,172 $46,641 $64,531 $38,090
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 April 30, 2020
Village of Oak Brook
Monthly Financial Report – Fund Narrative
For the Period Ending April 30, 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 April 2020 are $84,364, or 1.0%, higher than last April, but $238,804, or
2.7%, under budget to date. The main drivers for this are:
o Sales tax revenue, the General
Fund’s largest revenue source, is
up $169,180 from last year and
$233,179 over budget. April
2020 collections have been at
the highest levels the past five
years. Overall, total collections
through April have also been at
the highest levels in the past five
years.
o Other intergovernmental tax
revenue is up $47,592 from last year and $45,505 over budget. The Village has
experienced strong collections in income tax, use tax, and replacement tax to date.
Beginning in 2020, the Village receives a small share of cannabis use tax (which is
distributed per capita to local governments).
o Licenses and permits revenue is up $1,957 from last year, but is $356,831 under budget.
This is due to the timing of permits being issued vs. when originally planned. Permit
revenue is still expected to be strong in 2020 with the Hines Oak Brook Commons and
other major projects kicking off. These permits are expected to be issued later this year.
Total expenditures through April 2020 are $422,304, or 5.3%, lower than last year and $668,881,
or 8.1%, under budget to date. The main drivers for this are:
o Personnel expenditures are up $427,257 from last year, but $98,319 under budget. The
increase is due to a combination of annual pay increases and final accrual payouts from
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 $403,101 from last year and $401,583
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 $433,123 from last year and $97,975 under
budget. Many capital items have been put on hold for 2020 due to the current
economic state.
Hotel Tax Fund
Total revenues through April 2020 are $44,077, or 13.0%, lower than last year and $42,869, or
12.7%, under budget. The main drivers for this are:
o Hotel tax revenue is down $36,857 from last year and $48,499 under budget. The
decrease is due to the timing of receipts being received and a reduction room rentals in
March from the pandemic.
Total expenditures through April 2020 are $242,014, or 136.5%, higher than last year and
$106,712, or 34.1%, over budget. The main drivers for this are:
o Operation and contract expenditures are up $25,048 from last year, but $59,859 under
budget. This is due to the timing of advertising payments.
o Capital Outlay expenditures are up $216,966 from last year and $166,571 over budget.
The street light replacements began earlier than originally projected.
Infrastructure Fund
Total revenues through April 2020 are up $20,971, or 1.0%, from last year and $97,415, or 4.6%,
over budget. The main drivers for this are:
o Non-home rule sales tax revenue
is up $55,941 from last year, but
$96,105 over budget. April 2020
collections have been at the
highest levels the past five years.
Overall, total collections through
April have also been at the
highest levels in the past five
years.
o Interest revenue is down
$34,970 from last year, but
$2,490 over budget. Interest rates have dropped in recent months compared to last
year, but are still at levels projected for 2020.
Total expenditures through April 2020 are down $710,792, or 39.5%, from last year and
$3,650,323, or 77.0%, under budget to date. The main drivers for this are:
o Operation and contract expenditures are up $15,157 from last year, but $154,672 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 $717,336 from last year and $3,498,079 under
budget. Payments for ongoing projects have not occurred to date and will be delayed
until later in the year or 2021.
Promenade TIF Fund
Total revenues through April 2020 are up $19,157, or 4,257.1%%, from last year, but $4,643, or
19.1%, under budget. The timing of sales tax transfers has changed in 2020 due to information
being more readily available from IDOR. Interest rates have dropped in recent months
compared to last year, but are still at levels projected for 2020.
Total expenditures through April 2020 are up $34,325 from last year and even with budget. The
increase relates to additional principal and interest paid towards the TIF note.
Water Fund
Total revenues through April 2020 are up $34,163, or 1.3%, from last year, but $144,308, or
5.2%, under budget. The main drivers for this are:
o Water sales revenue is up $32,307 from last year, but $127,604 under budget. The
increase from last year is due to a 7% rate increase effective 1/1/20. Water gallons sold
has also been slightly lower than projected so far this year.
Total expenditures through April 2020 are up $389,301, or 26.5%, from last year, but $865,400,
or 31.7%, under budget. The main drivers for this are:
o Operation and contract expenditures are down $131,888 from last year and $997,363
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 $521,632 from last year and $172,403 over budget.
This is due to the final payments for the 2019 water main replacements falling into
2020. A number of budgeted projects for 2020 are on hold due to the current
pandemic.
Sports Core Fund
Total revenues through April 2020 are down $329,564, or 51.8%, from last year and $287,775,
or 48.4%, 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.
Total expenditures through April 2020 are up $81,351, or 7.3%, from last year, but $1,302,947,
or 52.0%, under budget to date. The main drivers for this are:
o Operation and Contractual expenditures are down $290,829 from last year and
$303,209 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 up $446,286 from last year, but $816,720 under budget. This is
due to the golf lounge renovation beginning earlier than projected and a delay in the
pool renovation project due to the COVID-19 pandemic.
4/30/20 4/30/20
4/30/19 4/30/20 YTD % of YTD 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 4,634,499$ 4,803,679$ 4,570,500$ 105.1%12,502,000$ 169,180$
Other Intergovernmental Tax*468,813 516,405 471,000 109.6%1,352,000 47,592
Telecommunications/Utility Tax 2,171,848 2,101,336 2,149,000 97.8%6,125,000 (70,512)
Licenses and Permits 578,682 580,639 937,470 61.9%2,990,190 1,957
Charges for Services 390,265 335,104 385,980 86.8%1,253,100 (55,161)
Fines and Penalties 86,964 60,751 64,000 94.9%192,000 (26,213)
Administrative Towing Fees 7,800 7,637 6,660 114.7%20,000 (163)
Interest on Investments 146,137 142,847 138,340 103.3%415,000 (3,290)
Franchise/IMF Maint. Fee 5,493 4,483 52,500 8.5%210,000 (1,010)
Miscellaneous Income 90,081 112,065 128,300 87.3%443,095 21,984
Total Operating Revenues 8,580,582$ 8,664,946$ 8,903,750$ 97.3%25,502,385$ 84,364$
OPERATING EXPENDITURES
Personnel 5,869,734$ 6,296,991$ 6,395,310$ 98.5%19,160,220$ 427,257$
Materials and Supplies 144,514 134,110 203,855 65.8%539,170 (10,404)
Operation and Contract 1,521,033 1,117,932 1,519,515 73.6%4,071,660 (403,101)
Other Expenditures 5,134 2,201 3,460 63.6%10,000 (2,933)
Capital Outlay 485,158 52,035 150,010 34.7%688,030 (433,123)
Total Operating Expenditures 8,025,573$ 7,603,269$ 8,272,150$ 91.9%24,469,080$ (422,304)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 555,009$ 1,061,677$ 631,600$ 1,033,305$ 506,668$
INTERFUND TRANSACTIONS
Transfers In 508,235$ -$ -$ 0.0%-$ (508,235)$
Transfers Out (42,169) (326,369) (762,755) 42.8%(923,000) (284,200)
Reimbursements From Other Funds 210,736 208,796 208,800 100.0%626,395 (1,940)
Reimbursements To Other Funds (43,700) (46,588) (46,580) 100.0%(139,770) (2,888)
Sports Core Loan (175,022) (113,481) - 0.0%- 61,541
Total Interfund Transactions 458,080$ (277,642)$ (600,535)$ 46.2%(436,375)$ (735,722)$
NET FUND INCREASE (DECREASE)1,013,089$ 784,035$ 31,065$ 596,930$ (229,054)$
*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 April 30, 2020
Total Total
Revenues Expenditures
4/30/20 Actual 8,664,946$ 7,603,269$
4/30/19 Actual 8,580,582$ 8,025,573$
% Change From Last Year 1.0%-5.3%
Major Revenues
Other Telecom/Utility Licenses &Charges for
Sales Tax Intergov. Tax Tax Permits Services
4/30/20 Actual 4,803,679$ 516,405$ 2,101,336$ 580,639$ 335,104$
4/30/19 Actual $ 4,634,499 $ 468,813 $ 2,171,848 $ 578,682 $ 390,265
% Change From Last Year 3.7%10.2%-3.2%0.3%-14.1%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
4/30/20 Actual 6,296,991$ 134,110$ 1,117,932$ 2,201$ 52,035$
4/30/19 Actual 5,869,734$ 144,514$ 1,521,033$ 5,134$ 485,158$
% Change From Last Year 7.3%-7.2%-26.5%-57.1%-89.3%
Five Year Trend
Expenditures by Department
4/30/19 4/30/20 4/30/20 4/30/20 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Department Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 773,773$ 712,699$ 906,035$ 78.7%2,556,835$ (61,074)$
Financial Services 268,169 273,735 284,970 96.1%781,455 5,566
Public Works 259,285 205,152 300,330 68.3%893,055 (54,133)
Engineering & Capital Projects 264,680 18,020 40,600 44.4%411,500 (246,660)
Library 315,665 282,574 348,625 81.1%994,410 (33,091)
Police 3,066,456 3,093,523 3,209,550 96.4%9,493,905 27,067
Fire 2,763,742 2,656,166 2,847,390 93.3%8,298,370 (107,576)
Development Services 313,803 361,400 334,650 108.0%1,039,550 47,597
Total Expenditures 8,025,573$ 7,603,269$ 8,272,150$ 91.9%24,469,080$ (422,304)$
Five Year Trend
For the Period Ending April 30, 2020
General Fund - Five Year Trend
Village of Oak Brook
Revenues Expenditures
4/30/20 4/30/20
4/30/19 4/30/20 YTD % of YTD 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Hotel Tax 300,158$ 263,301$ 311,800$ 84.4%1,212,500$ (36,857)$
Interest 37,850 30,630 25,000 122.5%75,000 (7,220)
Total Operating Revenues 338,008$ 293,931$ 336,800$ 87.3%1,287,500$ (44,077)$
EXPENDITURES
Operation and Contract 177,293$ 202,341$ 262,200$ 77.2%576,615$ 25,048$
Capital Outlay - 216,966 50,395 430.5%640,395 216,966
Total Expenditures 177,293$ 419,307$ 312,595$ 134.1%1,217,010$ 242,014$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 160,715$ (125,376)$ 24,205$ -518.0%70,490$ (286,091)$
INTERFUND TRANSACTIONS
Transfer Out -$ -$ (54,825)$ 0.0%(338,125)$ -$
Reimbursements to Other Funds (34,372) (24,904) (24,900) 100.0%(74,715) 9,468
Total Interfund Transactions (34,372)$ (24,904)$ (79,725)$ 31.2%(412,840)$ 9,468$
NET FUND INCREASE (DECREASE)126,343$ (150,280)$ (55,520)$ (342,350)$ (276,623)$
Note - Expenditures are recorded in program 171.
Village of Oak Brook
Hotel Tax Fund Financial Update
For the Period Ending April 30, 2020
Total Total
Revenues Expenditures
4/30/20 Actual $ 293,931 419,307$
4/30/19 Actual $ 338,008 177,293$
% Change From Last Year -13.0%136.5%
Major Revenues
Hotel Tax Interest Miscellaneous
4/30/20 Actual $ 263,301 $ 30,630 $ -
4/30/19 Actual $ 300,158 $ 37,850 $ -
% Change From Last Year -12.3%-19.1%0.0%
Five Year Trend
Major Expenditures Operation &
Contractual Capital Outlay
4/30/20 Actual 202,341$ 216,966$
4/30/19 Actual 177,293$ -$
% Change From Last Year 14.1%N/A
Five Year Trend
Village of Oak Brook
Hotel Tax Fund - Major Sources Five Year Trend
For the Period Ending April 30, 2020
Five Year Trend
Revenues Expenditures
4/30/20 4/30/20
4/30/19 4/30/20 YTD % of YTD 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 2,113,914$ 2,169,855$ 2,073,750$ 104.6%5,615,000$ 55,941$
Charges for Services - - 340 0.0%1,000 -
Interest 79,120 44,150 41,660 106.0%125,000 (34,970)
Miscellaneous - - 840 0.0%2,500 -
Total Operating Revenues 2,193,034$ 2,214,005$ 2,116,590$ 104.6%5,743,500$ 20,971$
OPERATING EXPENDITURES
Personnel 474,710$ 479,752$ 483,960$ 99.1%1,389,540$ 5,042$
Materials and Supplies 96,896 83,241 76,605 108.7%253,295 (13,655)
Operation and Contract 447,281 462,438 617,110 74.9%1,856,790 15,157
Capital Outlay 780,752 63,416 3,561,495 1.8%10,220,090 (717,336)
Total Operating Expenditures 1,799,639$ 1,088,847$ 4,739,170$ 23.0%13,719,715$ (710,792)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 393,395$ 1,125,158$ (2,622,580)$ -42.9%(7,976,215)$ 731,763$
INTERFUND TRANSACTIONS
Transfers In 216,125$ -$ 54,825$ 0.0%1,653,125$ (216,125)$
Reimbursements From Other Funds 111,148 119,792 119,800 100.0%359,380 8,644
Reimbursements To Other Funds (53,844) (54,100) (54,100) 100.0%(162,300) (256)
Total Interfund Transactions 273,429$ 65,692$ 120,525$ 54.5%1,850,205$ (207,737)$
NET FUND INCREASE (DECREASE)666,824$ 1,190,850$ (2,502,055)$ (6,126,010)$ 524,026$
Village of Oak Brook
Infrastructure Fund Financial Update
For the Period Ending April 30, 2020
Total Total
Revenues Expenditures
4/30/20 Actual $ 2,214,005 1,088,847$
4/30/19 Actual $ 2,193,034 1,799,639$
% Change From Last Year 1.0%-39.5%
Major Revenues
Sales Tax
Charges for
Services Interest Miscellaneous Reimbursements
4/30/20 Actual $ 2,169,855 $ - $ 44,150 $ - $ 119,792
4/30/19 Actual $ 2,113,914 $ - $ 79,120 $ - $ 111,148
% Change From Last Year 2.6%0.0%-44.2%0.0%7.8%
Five Year Trend
Major Expenditures Materials &Operation &
Personnel Supplies Contractual Capital Outlay
4/30/20 Actual 479,752$ 83,241$ 462,438$ 63,416$
4/30/19 Actual 474,710$ 96,896$ 447,281$ 780,752$
% Change From Last Year 1.1%-14.1%3.4%-91.9%
Five Year Trend
Expenditures by Department
4/30/19 4/30/20 4/30/20 4/30/20 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 41,697$ 48,260$ 60,200$ 80.2%176,490$ 6,563$
Public Works 798,534 750,829 2,728,045 27.5%4,390,810 (47,705)
Engineering & Capital Projects 959,408 289,758 1,950,925 14.9%9,152,415 (669,650)
Total Expenditures 1,799,639$ 1,088,847$ 4,739,170$ 23.0%13,719,715$ (710,792)$
Five Year Trend
Village of Oak Brook
Infrastructure Fund - Major Sources Five Year Trend
For the Period Ending April 30, 2020
Revenues Expenditures
4/30/20 4/30/20
4/30/19 4/30/20 YTD % of YTD 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax -$ 19,258$ 23,750$ 81.1%95,000$ 19,258$
Real Estate Tax - - - 0.0%380,000 -
Interest 450 349 500 69.8%1,500 (101)
Total Operating Revenues 450$ 19,607$ 24,250$ 80.9%476,500$ 19,157$
EXPENDITURES
Operation and Contract -$ -$ -$ 0.0%3,890$ -$
Other Expenditures 231,130 265,455 265,455 100.0%504,900 34,325
Total Expenditures 231,130$ 265,455$ 265,455$ 100.0%508,790$ 34,325$
NET FUND INCREASE (DECREASE)(230,680)$ (245,848)$ (241,205)$ (32,290)$ (15,168)$
Note - Expenditures are recorded in program 283.
Village of Oak Brook
Promenade TIF Fund Financial Update
For the Period Ending April 30, 2020
Total Total
Revenues Expenditures
4/30/20 Actual $ 19,607 265,455$
4/30/19 Actual $ 450 231,130$
% Change From Last Year 4257.1%14.9%
Major Revenues Real Estate
Sales Tax Tax Interest
4/30/20 Actual 19,258$ $ - $ 349
4/30/19 Actual -$ $ - $ 450
% Change From Last Year N/A 0.0%-22.4%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures
4/30/20 Actual -$ 265,455$
4/30/19 Actual -$ 231,130$
% Change From Last Year 0.0%14.9%
Five Year Trend
Village of Oak Brook
Promenade TIF Fund - Major Sources Five Year Trend
For the Period Ending April 30, 2020
Five Year Trend
Revenues Expenditures
4/30/20 4/30/20
4/30/19 4/30/20 YTD % of YTD 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Plan Review Fees 525$ 150$ 400$ 37.5%1,200$ (375)$
Building/Inspection Fees 1,838 4,912 2,660 184.7%8,000 3,074
Water Sales 2,491,089 2,523,396 2,651,000 95.2%10,302,525 32,307
Unmetered Sales 6,497 27,114 10,000 271.1%30,000 20,617
Water Connection Fees 11,500 5,080 33,340 15.2%100,000 (6,420)
Meter Charges 3,740 4,377 6,680 65.5%20,000 637
Special Services - 763 - N/A 30,000 763
Interest on Investments 57,800 41,706 43,340 96.2%130,000 (16,094)
Miscellaneous 20,960 20,614 25,000 82.5%75,000 (346)
Total Operating Revenues 2,593,949$ 2,628,112$ 2,772,420$ 94.8%10,696,725$ 34,163$
OPERATING EXPENDITURES
Personnel 263,683$ 270,054$ 289,115$ 93.4%868,705$ 6,371$
Materials and Supplies 10,470 3,656 25,035 14.6%74,260 (6,814)
Operation and Contract 1,089,930 958,042 1,955,405 49.0%5,833,755 (131,888)
Capital Outlay 107,441 629,073 456,670 137.8%6,293,225 521,632
Total Expenditures 1,471,524$ 1,860,825$ 2,726,225$ 68.3%13,069,945$ 389,301$
Surplus (Deficit) of Revenues Over
Expenditures 1,122,425$ 767,287$ 46,195$ 1661.0%(2,373,220)$ (355,138)$
INTERFUND TRANSACTIONS
Transfers In 221,085$ -$ -$ 0.0%-$ (221,085)
Reimbursements To Other Funds (183,944) (175,604) (175,600) 100.0%(526,815) 8,340
Total Interfund Transactions 37,141$ (175,604)$ (175,600)$ 100.0%(526,815)$ (212,745)$
Fund Increase/(Decrease) - Budgetary Basis 1,159,566$ 591,683$ (129,405)$ -457.2%(2,900,035)$ (567,883)$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay 107,441$ 629,073$
Depreciation Expense (128,026) (143,750)
IMRF Pension Expense 19,309 12,500
OPEB Expense (12,256) (11,250)
Total GAAP Adjustments (13,533)$ 486,573$
Fund Increase/(Decrease) - GAAP Basis 1,146,034$ 1,078,256$
*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 April 30, 2020
Total Total
Revenues Expenditures
4/30/20 Actual $ 2,628,112 1,860,825$
4/30/19 Actual $ 2,593,949 1,471,524$
% Change From Last Year 1.3%26.5%
Unmetered Water
Water Sales Sales Connection Fees Meter Charges Miscellaneous
4/30/20 Actual $ 2,523,396 $ 27,114 $ 5,080 $ 4,377 $ 20,614
4/30/19 Actual $ 2,491,089 $ 6,497 $ 11,500 $ 3,740 $ 20,960
% Change From Last Year 1.3%317.3%-55.8%17.0%-1.7%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
4/30/20 Actual 270,054$ 3,656$ 958,042$ -$ 629,073$
4/30/19 Actual 263,683$ 10,470$ 1,089,930$ -$ 107,441$
% Change From Last Year 2.4%-65.1%-12.1%0.0%485.5%
Five Year Trend
Expenditures by Department
4/30/19 4/30/20 4/30/20 4/30/20 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Public Works 1,351,131$ 1,231,762$ 2,186,365$ 56.3%6,527,120$ (119,369)$
Engineering & Capital Projects 120,393 629,063 539,860 116.5%6,542,825 508,670
Total Expenditures 1,471,524$ 1,860,825$ 2,726,225$ 68.3%13,069,945$ 389,301$
Five Year Trend
Village of Oak Brook
Water Fund - Major Sources Five Year Trend
For the Period Ending April 30, 2020
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Sports Core Fund Consolidated Presentation
For the Period Ending April 30, 2020
4/30/20 4/30/20
4/30/20 YTD % of YTD 2020 4/30/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$ -$ -$ 133,200$ 133,399$ 246,665$ 54.1%459,135$ 240,840$ (107,441)$
Greens Fees - - - 21,307 21,307 77,000 27.7%930,000 61,841 (40,534)
Pro Shop Sales - - - 16,289 16,289 44,500 36.6%207,000 44,314 (28,025)
Golf Lessons - - - 120 120 13,500 0.9%40,000 14,035 (13,915)
Driving Range Fees - - - 32,687 32,687 78,000 41.9%244,000 90,203 (57,516)
Rentals - 82,670 10,480 5,190 98,340 93,455 105.2%962,000 140,227 (41,887)
Programs/User Fees - - - - - 5,000 0.0%66,300 7,035 (7,035)
Food Sales - - - 926 926 12,465 7.4%180,500 10,753 (9,827)
Beverage Sales - - - 2,827 2,827 21,090 13.4%265,000 17,364 (14,537)
Taste of Oak Brook - - - - - - 0.0%120,000 6,500 (6,500)
Grants - - - - - - 0.0%139,800 - -
Other Revenue (235) - - 830 595 2,590 23.0%11,000 2,942 (2,347)
Total Operating Revenues (36)$ 82,670$ 10,480$ 213,376$ 306,490$ 594,265$ 51.6%3,624,735$ 636,054$ (329,564)$
OPERATING EXPENDITURES
Personnel 2,316$ -$ 37,949$ 245,458$ 285,723$ 367,140$ 77.8%1,578,100$ 342,141$ (56,418)$
Materials & Supplies 705 119 1,436 28,699 30,959 132,560 23.4%618,025 48,647 (17,688)
Operational & Contractual 27,004 22,127 8,807 74,673 132,611 435,820 30.4%1,055,095 423,440 (290,829)
Other - - - - - - 0.0%(83,150) - -
Capital 334,066 8,710 - 410,004 752,780 1,569,500 48.0%1,921,545 306,494 446,286
Total Operating Expenditures 364,091$ 30,956$ 48,192$ 758,834$ 1,202,073$ 2,505,020$ 48.0%5,089,615$ 1,120,722$ 81,351$
B&T Administration Overhead Allocation*21,180$ -$ (21,180)$ -$ -$ -$ 0.0%-$ -$ -$
Operating Revenues Over (Under) Expenditures (342,947)$ 51,714$ (58,892)$ (545,458)$ (895,583)$ (1,910,755)$ 46.9%(1,464,880)$ (484,668)$ (410,915)$
INTERFUND TRANSACTIONS
Interfund Loan**113,481$ -$ -$ -$ 113,481$ -$ N/A -$ 175,022$ (61,541)$
Transfer From General Fund 326,369 - - - 326,369 762,755 42.8%923,000 42,169 284,200
Transfer From Hotel Tax Fund - - - - - - 0.0%35,000 - -
Transfer From Golf Surcharge Fund - - - 320,732 320,732 400,000 80.2%400,000 85,258 235,474
Reimbursement From Infrastructure Fund 8,000 - - - 8,000 8,000 100.0%24,000 8,000 -
Reimbursement From Water Fund 2,668 - - - 2,668 2,660 100.3%8,000 2,668 -
Reimbursement To General Fund (9,408) - - (9,408) (18,816) (18,800) 100.1%(56,450) - (18,816)
Total Interfund Transactions 441,110$ -$ -$ 311,324$ 752,434$ 1,154,615$ 65.2%1,333,550$ 313,117$ 439,317$
Total Revenues Over (Under) Expenditures - Budgetary Basis 98,163$ 51,714$ (58,892)$ (234,134)$ (143,149)$ (756,140)$ (131,330)$ (171,551)$ 28,402$
ADUSTMENTS TO GAAP BASIS***
Remove Capital Outlay 334,066$ 8,710$ -$ 410,004$ 752,780$ 306,494$
Depreciation Expense (49,968) (562) (11,667) (70,667) (132,863) (109,463)
IMRF Pension Expense (1,750) (83) (667) (3,950) (6,450) 30,924
OPEB Expense - - (1,733) (13,333) (15,067) (6,678)
Total GAAP Adjustments 282,348$ 8,065$ (14,067)$ 322,054$ 598,401$ 221,276$
Fund Increase/(Decrease) - GAAP Basis 380,511$ 59,779$ (72,959)$ 87,920$ 455,252$ 49,725$
*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.
**Interfund loan is from the General Fund. This will be repaid as the season begins.
***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
4/30/20 Actual $ 306,490 1,202,073$
4/30/19 Actual $ 636,054 1,120,722$
% Change From Last Year -51.8%7.3%
Driving Program/
Memberships Greens Fees Range Fees Rentals User Fees
4/30/20 Actual $ 133,399 $ 21,307 $ 32,687 $ 98,340 $ -
4/30/19 Actual $ 240,840 $ 61,841 $ 90,203 $ 140,227 $ 7,035
% Change From Last Year -44.6%-65.5%-63.8%-29.9%-100.0%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
4/30/20 Actual 285,723$ 30,959$ 132,611$ -$ 752,780$
4/30/19 Actual 342,141$ 48,647$ 423,440$ -$ 306,494$
% Change From Last Year -16.5%-36.4%-68.7%0.0%145.6%
Five Year Trend
Revenues by Department 4/30/19 4/30/20 4/30/20 4/30/20 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Operations 76,690$ (36)$ 86,255$ 0.0%506,735$ (76,726)$
Open Field Operations 28,263 82,670 35,630 232.0%407,000 60,907
B&T Clubhouse Operations 19,482 10,480 22,500 46.6%300,000 (9,002)
Golf Club 511,619 213,376 449,880 47.4%2,411,000 (298,243)
Total Revenues 636,054$ 306,490$ 594,265$ 51.6%3,624,735$ (323,064)$
Expenditures by Department 4/30/19 4/30/20 4/30/20 % of YTD 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Operations 305,731$ 364,091$ 1,158,575$ 31.4%1,752,045$ 58,360$
Open Field Operations 37,736$ 30,956$ 24,250$ 127.7%267,110$ (6,780)$
B&T Clubhouse Operations 155,506 48,192 278,540 17.3%458,770 (107,314)
Golf Club 621,749 758,834 1,043,655 72.7%2,611,690 137,085
Total Expenditures 1,120,722$ 1,202,073$ 2,505,020$ 48.0%5,089,615$ 81,351$
Five Year Trend
Village of Oak Brook
Sports Core Fund - Major Sources Five Year Trend
For the Period Ending April 30, 2020
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Club Recreation Operations
For the Period Ending April 30, 2020 4/30/20 4/30/20
822 4/30/20 YTD % of YTD 2020 4/30/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$ 81,165$ 0.2%241,635$ 70,415$ (70,216)$
Programs/User Fees - - - - - 5,000 0.0%66,300 7,035 (7,035)
Food Sales - - - - - - 0.0%36,000 - -
Beverage Sales - - - - - - 0.0%20,000 - -
Grants - - - - - - 0.0%139,800 - -
Other Revenue (235) - - - (235) 90 -261.1%3,000 (760) 525
Total Operating Revenues (235)$ 199$ -$ -$ (36)$ 86,255$ 0.0%506,735$ 76,690$ (76,726)$
OPERATING EXPENDITURES
Personnel 1,649$ -$ -$ 667$ 2,316$ 34,610$ 6.7%163,580$ 26,408$ (24,092)$
Materials & Supplies 164 456 85 - 705 22,850 3.1%57,650 1,098 (393)
Operational & Contractual 23,205 1,795 1,920 84 27,004 288,615 9.4%418,270 272,161 (245,157)
Capital 7,697 326,369 - - 334,066 812,500 41.1%1,112,545 6,064 328,002
Total Operating Expenditures 32,715$ 328,620$ 2,005$ 751$ 364,091$ 1,158,575$ 31.4%1,752,045$ 305,731$ 58,360$
B&T Administration Overhead Allocation*42,361$ (15,250)$ (4,236)$ (1,695)$ 21,180$ 40,710$ 52.0%93,235$ 31,250$ (10,070)$
Operating Revenues Over (Under) Expenditures 9,411$ (343,671)$ (6,241)$ (2,446)$ (342,947)$ (1,031,610)$ 33.2%(1,152,075)$ (197,791)$ (145,156)$
INTERFUND TRANSACTIONS
Interfund Loan**113,481$ -$ -$ -$ 113,481$ -$ N/A -$ 175,022$ (61,541)$
Transfer From General Fund - 326,369 - - 326,369 597,255 54.6%757,500 4,385 321,984
Reimbursement From Infrastructure Fund 8,000 - - - 8,000 8,000 100.0%24,000 8,000 -
Reimbursement From Water Fund 2,668 - - - 2,668 2,660 100.3%8,000 2,668 -
Reimbursement To General Fund (9,408) - - - (9,408) (9,400) 100.1%(28,225) - (9,408)
Total Interfund Transactions 114,741$ 326,369$ -$ -$ 441,110$ 598,515$ 73.7%761,275$ 190,075$ 251,035$
Total Revenues Over (Under) Expenditures - Budgetary Basis 124,152$ (17,302)$ (6,241)$ (2,446)$ 98,163$ (433,095)$ (390,800)$ (7,716)$ 105,879$
ADUSTMENTS TO GAAP BASIS***
Remove Capital Outlay 7,697$ 326,369$ -$ -$ 334,066$ 6,064$
Depreciation Expense - (47,912) (1,667) (389) (49,968) (31,608)
IMRF Pension Expense (1,667) - - (83) (1,750) 2,033
Total GAAP Adjustments 6,030$ 278,457$ (1,667)$ (473)$ 282,348$ (23,511)$
Fund Increase/(Decrease) - GAAP Basis 130,182$ 261,155$ (7,908)$ (2,919)$ 380,511$ (31,227)$
*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.
**Interfund loan is from the General Fund.
***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 April 30, 2020 4/30/20 4/30/20
4/30/20 YTD % of YTD 2020 4/30/19 Difference
815 816 YTD Amended Amended Adopted YTD Prior
Polo Open Fields Total Budget Budget Budget Total Year
OPERATING REVENUES
Field Rentals -$ 7,670$ 7,670$ 35,630$ 21.5%212,000$ 21,763$ (14,093)$
Range Rentals - 75,000 75,000 - N/A 75,000 - 75,000
Taste of Oak Brook - - - - 0.0%120,000 6,500 -
Other Revenue - - - - 0.0%- - -
Total Operating Revenues -$ 82,670$ 82,670$ 35,630$ 232.0%407,000$ 28,263$ 60,907$
OPERATING EXPENDITURES
Personnel -$ -$ -$ -$ 0.0%10,810$ -$ -$
Materials & Supplies - 119 119 500 23.8%1,700 - 119
Operational & Contractual 20,000 2,127 22,127 23,750 93.2%239,600 37,736 (15,609)
Other - - - - 0.0%- - -
Capital - 8,710 8,710 - N/A 15,000 - 8,710
Total Operating Expenditures 20,000$ 10,956$ 30,956$ 24,250$ 127.7%267,110$ 37,736$ (6,780)$
Operating Revenues Over (Under) Expenditures (20,000)$ 71,714$ 51,714$ 11,380$ 454.4%139,890$ (9,473)$ 67,687$
INTERFUND TRANSACTIONS
Transfer From Hotel Tax Fund -$ -$ -$ -$ 0.0%35,000$ -$ -$
Total Interfund Transactions -$ -$ -$ -$ 0.0%35,000$ -$ -$
Total Revenues Over (Under) Expenditures - Budgetary Basis (20,000)$ 71,714$ 51,714$ 11,380$ 174,890$ (9,473)$ 67,687$
ADUSTMENTS TO GAAP BASIS***
Remove Capital Outlay -$ 8,710$ 8,710$ -$
Depreciation Expense - (562) (562) (562)
IMRF Pension Expense - (83) (83) 245
Total GAAP Adjustments -$ 8,065$ 8,065$ (317)$
Fund Increase/(Decrease) - GAAP Basis (20,000)$ 79,779$ 59,779$ (9,790)$
*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.
**Interfund loan is from the General Fund.
***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 April 30, 2020
4/30/20 4/30/20
821 YTD % of YTD 2020 4/30/19 Difference
B&T Amended Amended Adopted YTD Prior
Clubhouse Budget Budget Budget Total Year
OPERATING REVENUES
Rentals 10,480$ 22,500$ 46.6%300,000$ 19,482$ (9,002)$
Total Operating Revenues 10,480$ 22,500$ 46.6%300,000$ 19,482$ (9,002)$
OPERATING EXPENDITURES
Personnel 37,949$ 41,255$ 92.0%140,045$ 38,802$ (853)$
Materials & Supplies 1,436 8,365 17.2%20,225 2,149 (713)
Operational & Contractual 8,807 39,920 22.1%109,500 21,676 (12,869)
Capital - 189,000 0.0%189,000 92,879 (92,879)
Total Operating Expenditures 48,192$ 278,540$ 17.3%458,770$ 155,506$ (107,314)$
B&T Administration Overhead Allocation*(21,180)$ (40,710)$ 52.0%(93,235)$ (31,250)$ 10,070$
Operating Revenues Over (Under) Expenditures (58,892)$ (296,750)$ 19.8%(252,005)$ (167,274)$ 108,382$
INTERFUND TRANSACTIONS
Transfer From General Fund -$ 165,500$ 0.0%165,500$ 37,784$ (37,784)$
Total Interfund Transactions -$ 165,500$ 0.0%165,500$ 37,784$ (37,784)$
Total Revenues Over (Under) Expenditures - Budgetary Basis (58,892)$ (131,250)$ (86,505)$ (129,490)$ 70,598$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay -$ 92,879$
Depreciation Expense (11,667) (10,717)
IMRF Pension Expense (667) 2,233
OPEB Expense (1,733) (700)
Total GAAP Adjustments (14,067)$ 83,695$
Fund Increase/(Decrease) - GAAP Basis (72,959)$ (45,795)$
*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 April 30, 2020
4/30/20 4/30/20
823 831 832 833 834 4/30/20 YTD % of YTD 2020 4/30/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 -$ 133,200$ -$ -$ -$ 133,200$ 165,500$ 80.5%217,500$ 170,425$ (37,225)$
Greens Fees - 21,307 - - - 21,307 77,000 27.7%930,000 61,841 (40,534)
Pro Shop Sales - 16,289 - - - 16,289 44,500 36.6%207,000 44,314 (28,025)
Golf Lessons - - 120 - - 120 13,500 0.9%40,000 14,035 (13,915)
Driving Range Fees - - 32,687 - - 32,687 78,000 41.9%244,000 90,203 (57,516)
Rentals - 20 - 5,170 - 5,190 35,325 14.7%375,000 98,982 (93,792)
Food Sales 926 - - - - 926 12,465 7.4%144,500 10,753 (9,827)
Beverage Sales 2,827 - - - - 2,827 21,090 13.4%245,000 17,364 (14,537)
Other Revenue - 830 - - - 830 2,500 33.2%8,000 3,702 (2,872)
Total Operating Revenues 3,753$ 171,646$ 32,807$ 5,170$ -$ 213,376$ 449,880$ 47.4%2,411,000$ 511,619$ (298,243)$
OPERATING EXPENDITURES
Personnel 16,272$ 133,734$ -$ 2,028$ 93,424$ 245,458$ 291,275$ 84.3%1,263,665$ 276,931$ (31,473)$
Materials & Supplies 9,067 469 1,031 478 17,654 28,699 100,845 28.5%538,450 45,400 (16,701)
Operational & Contractual 1,433 53,887 50 8,262 11,041 74,673 83,535 89.4%287,725 91,867 (17,194)
Other - - - - - - - 0.0%(83,150) - -
Capital - 327,297 - - 82,707 410,004 568,000 72.2%605,000 207,551 202,453
Total Operating Expenditures 26,772$ 515,387$ 1,081$ 10,768$ 204,826$ 758,834$ 1,043,655$ 72.7%2,611,690$ 621,749$ 137,085$
Operating Revenues Over (Under) Expenditures (23,019)$ (343,741)$ 31,726$ (5,598)$ (204,826)$ (545,458)$ (593,775)$ 91.9%(200,690)$ (110,130)$ (435,328)$
INTERFUND TRANSACTIONS
Transfer from Golf Surcharge -$ 320,732$ -$ -$ -$ 320,732$ 400,000$ 80.2%400,000$ 85,258$ 235,474$
Reimbursement to General Fund - (9,408) - - - (9,408) (9,400) 100.1%(28,225) - (9,408)
Total Interfund Transactions -$ 311,324$ -$ -$ -$ 311,324$ 390,600$ 79.7%371,775$ 85,258$ 226,066$
Total Revenues Over (Under) Expenditures - Budgetary Basis (23,019)$ (32,417)$ 31,726$ (5,598)$ (204,826)$ (234,134)$ (203,175)$ 171,085$ (24,872)$ (209,262)$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay -$ 327,297$ -$ -$ 82,707$ 410,004$ 207,551$
Depreciation Expense - (45,000) (1,333) (7,667) (16,667) (70,667) (66,576)
IMRF Pension Expense (500) (1,667) (117) - (1,667) (3,950) 26,413
OPEB Expense (1,000) (7,667) - - (4,667) (13,333) (5,978)
Total GAAP Adjustments (1,500)$ 272,964$ (1,450)$ (7,667)$ 59,707$ 322,054$ 161,409$
Fund Increase/(Decrease) - GAAP Basis (24,519)$ 240,547$ 30,276$ (13,265)$ (145,119)$ 87,920$ 136,537$
*Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.