03 - March 2020 Monthly Financial ReportVILLAGE
OAK BROOK
OF
MONTHLY FINANCIAL REPORTS
MARCH 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,425,836 $14,599,358 $22,025,194 48.6%
Hotel/Motel Tax 2,625,581 2,315,734 4,941,315 10.9%
Motor Fuel Tax 1,086,452 81,677 1,168,129 2.6%
Infrastructure 6,889,255 1,944,440 8,833,695 19.5%
Promenade TIF 48,594 - 48,594 0.1%
Water 3,230,364 3,510,077 6,740,441 14.9%
Sports Core - - - 0.0%
Golf Surcharge 53,369 177,704 231,073 0.5%
Self-Insurance 200,645 - 200,645 0.4%
Garage 300,937 - 300,937 0.7%
Equipment Replacement 494,363 357,650 852,013 1.9%
Total $22,355,396 $22,986,640 $45,342,036 100.0%
Change in Cash and Investments by Fund :
Balance at Balance at Year-to-Date Year-to-Date
Fund January 1, 2020 March 31, 2020 Change ($)Change (%)
General Corporate $21,270,239 $22,025,194 $754,955 3.5%
Hotel/Motel Tax 5,427,474 4,941,315 (486,159)-9.0%
Motor Fuel Tax 1,085,595 1,168,129 82,534 7.6%
Infrastructure 8,217,724 8,833,695 615,971 7.5%
Promenade TIF 304,194 48,594 (255,600)-84.0%
Water 6,947,239 6,740,441 (206,798)-3.0%
Sports Core 231,216 - (231,216)-100.0%
Golf Surcharge 347,066 231,073 (115,993)-33.4%
Self-Insurance 308,820 200,645 (108,175)-35.0%
Garage 275,988 300,937 24,949 9.0%
Equipment Replacement 808,879 852,013 43,134 5.3%
$45,224,434 $45,342,036 $117,602 0.3%
Book Bank/Market
Value Value
Cash and Cash Equivalents:
Pooled Checking $1,192,536 $1,365,514
Sports Core Checking 98,628 98,628
Pooled IPTIP 20,902,718 20,902,718
Water E-Pay IPTIP 161,514 142,827
$22,355,396 $22,509,687
Pooled Investments:
Investments-Municipal Bonds $6,435,833 $6,453,082
Investments-Corporate Bonds 8,301,861 8,313,637
Government & Agency Obligations 2,118,116 2,152,648
Certificates of Deposit 5,995,000 6,040,332
Accrued Interest 135,830 135,830
Total Pooled Investments $22,986,640 $23,095,529
Total Cash and Investments $45,342,036 $45,605,216
For March, total interest revenue is $65,918 and YTD is $212,305. The total investment yield for the portfolio is:
Pooled
Investments Illinois Funds Total
Last 12 months yield 2.31%2.08%2.20%
The weighted average yield of the current pooled investment portfolio is 2.27%. The IL Funds March average daily rate was 1.23%.
Monthly Treasurer's Report
March 31, 2020
Monthly Treasurer's Report
March 2020
The table below lists the detail investment holdings at J.P. Morgan Securities as of 3/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,733 201,810 1,944
Florida Hurricane #34074GDH4 03/30/16 07/01/20 2.995%2.150%500,959 499,535 3,743
Bloomingdale Mich Pub Sch Dist #094383FS0 04/26/16 05/01/22 2.710%2.150%505,634 512,690 5,607
Milan Mich Area Achs #598801JD1 05/26/16 05/01/20 1.931%1.931%245,000 245,172 1,870
Lanse Creuse Mich Pub Schs #516228RL9 05/02/17 05/01/20 2.159%2.159%100,000 100,105 897
Connecticut St GO Bds 2016 #20772J3F7 06/15/17 08/15/21 1.750%2.300%496,317 503,175 1,065
Fowlerville Mich Comnty Schs #351280MS8 10/03/17 05/01/20 2.045%1.750%500,126 500,455 4,090
Wisconsin St Gen Fd Annual #977100CW4 01/05/18 05/01/20 1.446%2.100%599,662 600,192 3,519
Wright County Min #982276BC0 07/18/19 12/01/20 2.000%2.000%545,000 548,161 4,148
State of IL #452152P54 10/09/19 11/01/21 5.000%1.870%524,420 510,570 10,166
Anchor Bay Mich Sch #032879TE8 11/01/19 05/01/21 2.320%1.750%719,380 716,573 6,773
Brownsville TX #16405ST9 12/19/19 02/15/22 2.050%2.000%555,500 563,547 1,296
Laredo TX Waterworks #517039VW0 12/19/19 03/01/24 2.230%2.230%455,000 463,918 789
Manchester NH #562333JE5 03/12/20 12/01/20 5.000%0.850%488,102 487,179 7,876
Total Municipal Bonds $6,435,833 $6,453,082 $53,783
Corporate Bonds:
Goldman Sachs #38141GVP9 09/26/18 09/15/20 2.750%3.180%499,048 501,295 573
Wells Fargo #94974BGR5 01/15/19 12/07/20 2.550%3.120%1,384,776 1,393,322 11,520
PNC Bank #69353RFH6 01/30/19 01/22/21 2.500%3.020%497,953 500,995 2,396
Morgan Stanley #61747WAL3 03/08/19 07/28/21 5.500%3.034%1,083,235 1,090,215 9,946
Citigroup #172967LC3 04/01/19 12/08/21 2.900%2.754%1,002,383 1,007,690 8,539
Bank of America #06051GFT1 04/03/19 10/19/20 2.625%2.625%700,000 701,092 8,014
Goldman Sachs #38143U8F1 05/02/19 02/25/21 2.875%2.707%365,531 366,285 1,022
American Honda #02665WBG5 07/31/19 09/09/21 1.700%2.180%496,630 491,805 542
BB&T Corp #05531FAZ6 08/15/19 02/01/21 2.150%2.010%750,896 743,708 2,491
JP Morgan #48128BAB7 09/30/19 01/15/23 2.972%2.337%1,017,028 1,016,200 6,274
JP Morgan #46625HRT9 01/30/20 06/07/21 2.400%1.648%504,381 501,030 3,800
Total Corporate Bonds $8,301,861 $8,313,637 $55,117
Government & Agency Obligations:
*Government National Mtg Assn #38379UEM4 02/29/16 02/16/51 2.300%2.245%$626,563 $615,438 $2,330
*Government National Mtg Assn #38381WV96 08/06/19 07/20/54 2.250%2.293%871,077 893,842 1,560
*Government National Mtg Assn #38380BNV3 12/05/19 06/20/46 2.000%2.112%620,476 643,368 992
Total Government & Agency Obligations:$2,118,116 $2,152,648 $4,882
Certificates of Deposit:
State Bk India NY #8562846A7 01/26/17 01/26/22 2.250%2.250%$245,000 $249,038 $996
American Express Centurion #02587DV96 08/15/17 08/17/20 1.900%1.900%245,000 245,821 563
Sallie Mae #795450C86 08/16/17 08/17/20 1.900%1.900%245,000 245,821 563
Merrick Bank South Jordan #59013JZS1 08/21/17 08/21/20 1.800%1.800%245,000 245,737 121
Pinnacle Bank #72345SFS5 08/30/17 08/31/20 1.800%1.800%115,000 115,366 5
Jackson County Bank #466682AP6 08/31/17 03/01/21 1.850%1.850%245,000 246,458 384
Barclays Bank #06740KKX4 09/27/17 09/28/20 1.950%1.950%245,000 246,103 47
Goldman Sachs Bank #38148PRK5 10/18/17 10/19/20 1.950%1.950%245,000 246,196 2,150
FirstBank PR Santurce #33767A6M8 11/03/17 11/03/20 2.000%2.000%245,000 246,343 363
Compass Bank #20451PVW3 10/26/18 10/26/20 3.000%3.000%245,000 247,695 3,144
UBS Bank #90348JFH8 10/30/18 10/29/20 3.050%3.050%245,000 247,810 22
Discover Bank #254673WF9 11/07/18 11/09/20 3.000%3.000%245,000 247,852 2,920
Ally Bank #02007GFX6 11/08/18 11/09/20 3.000%3.000%245,000 247,852 2,899
Comenity Cap Bank #20033AU46 04/15/19 04/15/21 2.500%2.500%245,000 248,158 248
Morgan Stanley #61760AE21 05/30/19 06/01/21 2.400%2.400%245,000 248,217 1,936
First St Bank DeQueen #336460CU2 07/18/19 07/19/21 2.000%2.000%245,000 247,279 195
Bank Hapoalim #06251AW89 07/19/19 07/19/21 2.000%2.000%245,000 247,590 877
Capital One Natl Assn #14042RMF5 07/24/19 07/26/19 2.050%2.050%245,000 247,462 1,026
TIAA FSB Jacksonville #87270LCN1 07/29/19 07/29/21 2.000%2.000%245,000 247,313 837
Wells Fargo #949763J31 09/18/19 09/20/21 1.850%1.850%245,000 246,972 195
BMW Bank #05580ASQ8 10/11/19 10/12/21 1.800%1.800%245,000 246,840 2,021
Wells Fargo #949495AN5 01/17/20 01/18/22 1.800%1.800%245,000 247,046 194
Southpoint Bank #84464PBK2 02/28/20 02/28/22 1.600%1.600%245,000 245,581 15
New York Cmnty Bk Westbury #649447TM1 02/28/20 02/28/22 1.600%1.600%245,000 245,265 327
Bank Leumi #063248KQ0 03/31/20 03/31/22 1.250%1.250%245,000 244,517 -
Total Certificates of Deposits $5,995,000 $6,040,332 $22,048
Total J.P.Morgan Securities $22,850,810 $22,959,699 $135,830
*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
March 31, 2020
Cash & Investments by Fund - Total $45.3 million
Cash & Investments by Type - Total $45.3 million
Checking
Illinois Funds
Certificates of Deposit
Municipal Bonds
Corporate Bonds
Government & Agency Obligations
Accrued Interest
General Corporate
48.58%
Hotel/Motel Tax
10.90%Motor Fuel Tax
2.58%
Infrastructure
19.48%
Promenade TIF
0.11%
Water
14.87%
Sports Core
0.00%
Golf Surcharge
0.51%
Self-Insurance
0.44%Garage
0.66%
Equipment
Replacement
1.88%
Checking, $1.3
Illinois Funds, $21.1
Certificates of Deposit,
$6.0
Municipal Bonds, $6.4
Corporate Bonds, $8.3
Government & Agency
Obligations, $2.1
Accrued Interest, $0.1
in millions
Village of Oak Brook
Monthly Financial Report – Fund Narrative
For the Period Ending March 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 March 2020 are $107,494, or 1.6%, higher than last March, but
$161,785, or 2.3%, under budget to date. The main drivers for this are:
o Sales tax revenue, the General
Fund’s largest revenue source, is
down $10,510 from last year,
but $54,471 over budget. March
2020 collections have been at
the highest levels the past five
years.
o Other intergovernmental tax
revenue is up $32,454 from last
year and $37,255 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 $96,374 from last year, but is $184,675 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.
Total expenditures through March 2020 are $240,303, or 4.1%, higher than last year, but
$185,176, or 3.0%, under budget to date. The main drivers for this are:
o Personnel expenditures are up $415,739 from last year and $25,187 over budget. The
increase is due to a combination of annual pay increases and final accrual payouts from
retirements.
o Operation and contract expenditures are down $64,836 from last year and $82,531
under budget. This is due to the general timing of payments compared to when they
were projected to occur.
o Capital outlay expenditures are down $111,525 from last year and $78,450 under
budget. Many capital items have been put on hold for 2020 due to the current
economic state.
Hotel Tax Fund
Total revenues through March 2020 are $11,788, or 4.9%, lower than last year and $6,804, or
2.9%, under budget. The main drivers for this are:
o Hotel tax revenue is down $7,260 from last year and $12,127 under budget. The
decrease is due to the timing of receipts being received vs. when projected.
Total expenditures through March 2020 are $344,750, or 2,848.0%, higher than last year and
$164,705, or 85.7%, over budget. The main drivers for this are:
o Operation and contract expenditures are up $149,081 from last year, but $30,964 under
budget. This is due to the timing of advertising payments.
o Capital Outlay expenditures are up $195,669 from last year and $195,669 over budget.
The street light replacements began earlier than originally projected.
Infrastructure Fund
Total revenues through March 2020 are down $34,577, or 1.9%, from last year, but $31,244, or
1.7%, over budget. The main drivers for this are:
o Non-home rule sales tax revenue
is down $10,620 from last year,
but $28,440 over budget. March
2020 collections have been at
the highest levels the past five
years.
o Interest revenue is down
$23,957 from last year, but
$3,689 over budget. Interest
rates have dropped in recent
months compared to last year,
but are still at levels projected for 2020.
Total expenditures through March 2020 are up $19,541, or 2.3%, from last year and $2,797,469,
or 76.5%, under budget to date. The main drivers for this are:
o Operation and contract expenditures are up $90,387 from last year, but $108,238 under
budget. Expenditures are under budget due to the timing of engineering payments.
o Capital Outlay expenditures are down $77,718 from last year and $2,708,698 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 March 2020 are up $9,459, or 2,388.6%%, from last year, but $14,270,
or 59.2%, under budget. Interest rates have dropped in recent months compared to last year,
but are still at levels projected for 2020.
Total expenditures through March 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 March 2020 are up $124,096, or 5.6%, from last year, but $33,697, or
1.4%, under budget. The main drivers for this are:
o Water sales revenue is up $112,905 from last year, but $22,027 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 March 2020 are up $341,432, or 33.7%, from last year, but
$554,427, or 29.0%, under budget. The main drivers for this are:
o Operation and contract expenditures are down $45,457 from last year and $785,469
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 $377,022 from last year and $255,538 over budget.
This is due to the final payments for the 2019 water main replacements falling into
2020.
Sports Core Fund
Total revenues through March 2020 are down $12,487, or 5.7%, from last year and $37,249, or
15.4%, under budget to date. In March, only miscellaneous revenue sources have been
collected and recorded. Most revenue sources are under budget to date in 2020 due to the
COVID-19 pandemic limiting activity.
Total expenditures through March 2020 are up $140,444, or 20.1%, from last year, but
$377,045, or 31.0%, under budget to date. The main drivers for this are:
o Operation and Contractual expenditures are down $238,444 from last year and
$257,870 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 $344,721 from last year, but $51,894 under budget. This is
due to the golf lounge renovation beginning earlier than projected.
YTD YTD
Net Fund Budgeted
YTD YTD Increase Increase
Governmental Funds Revenues Expenditures (Decrease)(Decrease)
General Fund (Major Fund)7,051,422 $6,328,124 $723,298 $739,745
Main operating fund of the Village.
Hotel Fund (Major Fund)$231,246 $375,533 ($144,287)$27,225
Collects and spends resources from the
3% hotel/motel tax.
Motor Fuel Tax Fund $87,694 $0 $87,694 $80,245
Collects and spends resources from the
State motor fuel tax.
Infrastructure Fund (Major Fund)$1,906,968 $897,661 $1,009,307 ($1,819,400)
Accounts for construction and maintenance of
roadways, drainage, and safety path systems.
Promenade TIF Fund (Major Fund)$9,855 $265,455 ($255,600)($241,330)
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,329,373 $1,487,536 $841,837 $321,110
Collects user fees for the distribution of water
and maintenance of infrastructure.
Sports Core Fund (Major Fund)$538,150 $854,492 ($316,342)($615,680)
Accounts for revenues and expenses relating
to administration, programs, food and beverage
operations, and golf course.
Golf Surcharge Fund $3,726 $119,719 ($115,993)($197,370)
Accounts for the collection of the $3 per round
golf surcharge.
Internal Service Funds
Self Insurance Fund $867,865 $685,899 $181,966 ($10,500)
Accounts for the Village's health insurance costs
and the related contributions from the Village,
employees, retirees, and other agencies.
Garage Fund $184,155 $182,996 $1,159 ($9,190)
Accounts for the maintenance of the Village's vehicle
fleet and the related departmental reimbursements.
Equipment Replacement Fund $83,525 $40,390 $43,135 $28,560
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 March 31, 2020
3/31/20 3/31/20
3/31/19 3/31/20 YTD % of YTD 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 3,911,481$ 3,900,971$ 3,846,500$ 101.4%12,502,000$ (10,510)$
Other Intergovernmental Tax 317,801 350,255 313,000 111.9%1,352,000 32,454
Telecommunications/Utility Tax 1,625,232 1,603,049 1,608,000 99.7%6,125,000 (22,183)
Licenses and Permits 415,476 511,850 696,525 73.5%2,990,190 96,374
Charges for Services 278,619 288,282 288,985 99.8%1,253,100 9,663
Fines and Penalties 65,728 54,453 48,000 113.4%192,000 (11,275)
Administrative Towing Fees 6,100 7,137 4,995 142.9%20,000 1,037
Interest on Investments 108,042 109,279 103,755 105.3%415,000 1,237
Franchise/IMF Maint. Fee - - 52,500 0.0%210,000 -
Miscellaneous Income 58,852 69,549 94,350 73.7%443,095 10,697
Total Operating Revenues 6,787,331$ 6,894,825$ 7,056,610$ 97.7%25,502,385$ 107,494$
OPERATING EXPENDITURES
Personnel 4,570,333$ 4,986,072$ 4,960,885$ 100.5%19,160,220$ 415,739$
Materials and Supplies 109,620 111,277 160,550 69.3%539,170 1,657
Operation and Contract 1,026,505 961,669 1,044,200 92.1%4,071,660 (64,836)
Other Expenditures 2,933 2,201 2,310 95.3%10,000 (732)
Capital Outlay 138,160 26,635 105,085 25.3%688,030 (111,525)
Total Operating Expenditures 5,847,551$ 6,087,854$ 6,273,030$ 97.0%24,469,080$ 240,303$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 939,780$ 806,971$ 783,580$ 1,033,305$ (132,809)$
INTERFUND TRANSACTIONS
Transfers In 508,235$ -$ -$ 0.0%-$ (508,235)$
Transfers Out (37,439) - (165,500) 0.0%(923,000) 37,439
Reimbursements From Other Funds 158,052 156,597 156,600 100.0%626,395 (1,455)
Reimbursements To Other Funds (32,775) (34,941) (34,935) 100.0%(139,770) (2,166)
Sports Core Loan (230,022) (205,329) - 0.0%- 24,693
Total Interfund Transactions 366,051$ (83,673)$ (43,835)$ 190.9%(436,375)$ (449,724)$
NET FUND INCREASE (DECREASE)1,305,831$ 723,298$ 739,745$ 596,930$ (582,533)$
Village of Oak Brook
General Fund Financial Update
For the Period Ending March 31, 2020
Total Total
Revenues Expenditures
3/31/20 Actual 6,894,825$ 6,087,854$
3/31/19 Actual 6,787,331$ 5,847,551$
% Change From Last Year 1.6%4.1%
Major Revenues
Other Telecom/Utility Licenses &Charges for
Sales Tax Intergov. Tax Tax Permits Services
3/31/20 Actual 3,900,971$ 350,255$ 1,603,049$ 511,850$ 288,282$
3/31/19 Actual $ 3,911,481 $ 317,801 $ 1,625,232 $ 415,476 $ 278,619
% Change From Last Year -0.3%10.2%-1.4%23.2%3.5%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
3/31/20 Actual 4,986,072$ 111,277$ 961,669$ 2,201$ 26,635$
3/31/19 Actual 4,570,333$ 109,620$ 1,026,505$ 2,933$ 138,160$
% Change From Last Year 9.1%1.5%-6.3%-25.0%-80.7%
Five Year Trend
Expenditures by Department
3/31/19 3/31/20 3/31/20 3/31/20 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Department Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 609,613$ 573,518$ 722,640$ 79.4%2,556,835$ (36,095)$
Financial Services 185,761 207,741 196,290 105.8%781,455 21,980
Public Works 188,633 153,249 225,495 68.0%893,055 (35,384)
Engineering & Capital Projects 108,489 17,706 30,450 58.1%411,500 (90,783)
Library 250,926 242,581 271,850 89.2%994,410 (8,345)
Police 2,207,701 2,474,151 2,417,285 102.4%9,493,905 266,450
Fire 2,052,800 2,130,410 2,150,030 99.1%8,298,370 77,610
Development Services 243,628 288,498 258,990 111.4%1,039,550 44,870
Total Expenditures 5,847,551$ 6,087,854$ 6,273,030$ 97.0%24,469,080$ 240,303$
Five Year Trend
For the Period Ending March 31, 2020
General Fund - Five Year Trend
Village of Oak Brook
Revenues Expenditures
3/31/20 3/31/20
3/31/19 3/31/20 YTD % of YTD 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Hotel Tax 214,433$ 207,173$ 219,300$ 94.5%1,212,500$ (7,260)$
Interest 28,601 24,073 18,750 128.4%75,000 (4,528)
Total Operating Revenues 243,034$ 231,246$ 238,050$ 97.1%1,287,500$ (11,788)$
EXPENDITURES
Operation and Contract 12,105$ 161,186$ 192,150$ 83.9%576,615$ 149,081$
Capital Outlay - 195,669 - N/A 640,395 195,669
Total Expenditures 12,105$ 356,855$ 192,150$ 185.7%1,217,010$ 344,750$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 230,929$ (125,609)$ 45,900$ -273.7%70,490$ (356,538)$
INTERFUND TRANSACTIONS
Transfer Out -$ -$ -$ 0.0%(338,125)$ -$
Reimbursements to Other Funds (25,779) (18,678) (18,675) 100.0%(74,715) 7,101
Total Interfund Transactions (25,779)$ (18,678)$ (18,675)$ 100.0%(412,840)$ 7,101$
NET FUND INCREASE (DECREASE)205,150$ (144,287)$ 27,225$ (342,350)$ (349,437)$
Note - Expenditures are recorded in program 171.
Village of Oak Brook
Hotel Tax Fund Financial Update
For the Period Ending March 31, 2020
Total Total
Revenues Expenditures
3/31/20 Actual $ 231,246 356,855$
3/31/19 Actual $ 243,034 12,105$
% Change From Last Year -4.9%2848.0%
Major Revenues
Hotel Tax Interest Miscellaneous
3/31/20 Actual $ 207,173 $ 24,073 $ -
3/31/19 Actual $ 214,433 $ 28,601 $ -
% Change From Last Year -3.4%-15.8%0.0%
Five Year Trend
Major Expenditures Operation &
Contractual Capital Outlay
3/31/20 Actual 161,186$ 195,669$
3/31/19 Actual 12,105$ -$
% Change From Last Year 1231.6%N/A
Five Year Trend
Village of Oak Brook
Hotel Tax Fund - Major Sources Five Year Trend
For the Period Ending March 31, 2020
Five Year Trend
Revenues Expenditures
3/31/20 3/31/20
3/31/19 3/31/20 YTD % of YTD 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 1,792,810$ 1,782,190$ 1,753,750$ 101.6%5,615,000$ (10,620)$
Charges for Services - - 255 0.0%1,000 -
Interest 58,891 34,934 31,245 111.8%125,000 (23,957)
Miscellaneous - - 630 0.0%2,500 -
Total Operating Revenues 1,851,701$ 1,817,124$ 1,785,880$ 101.7%5,743,500$ (34,577)$
OPERATING EXPENDITURES
Personnel 378,561$ 386,784$ 384,665$ 100.6%1,389,540$ 8,223$
Materials and Supplies 81,104 79,753 62,405 127.8%253,295 (1,351)
Operation and Contract 272,190 362,577 470,815 77.0%1,856,790 90,387
Capital Outlay 105,690 27,972 2,736,670 1.0%10,220,090 (77,718)
Total Operating Expenditures 837,545$ 857,086$ 3,654,555$ 23.5%13,719,715$ 19,541$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 1,014,156$ 960,038$ (1,868,675)$ -51.4%(7,976,215)$ (54,118)$
INTERFUND TRANSACTIONS
Transfers In 216,125$ -$ -$ 0.0%1,653,125$ (216,125)$
Reimbursements From Other Funds 83,361 89,844 89,850 100.0%359,380 6,483
Reimbursements To Other Funds (40,383) (40,575) (40,575) 100.0%(162,300) (192)
Total Interfund Transactions 259,103$ 49,269$ 49,275$ 100.0%1,850,205$ (209,834)$
NET FUND INCREASE (DECREASE)1,273,259$ 1,009,307$ (1,819,400)$ (6,126,010)$ (263,952)$
Village of Oak Brook
Infrastructure Fund Financial Update
For the Period Ending March 31, 2020
Total Total
Revenues Expenditures
3/31/20 Actual $ 1,817,124 857,086$
3/31/19 Actual $ 1,851,701 837,545$
% Change From Last Year -1.9%2.3%
Major Revenues
Sales Tax
Charges for
Services Interest Miscellaneous Reimbursements
3/31/20 Actual $ 1,782,190 $ - $ 34,934 $ - $ 89,844
3/31/19 Actual $ 1,792,810 $ - $ 58,891 $ - $ 83,361
% Change From Last Year -0.6%0.0%-40.7%0.0%7.8%
Five Year Trend
Major Expenditures Materials &Operation &
Personnel Supplies Contractual Capital Outlay
3/31/20 Actual 386,784$ 79,753$ 362,577$ 27,972$
3/31/19 Actual 378,561$ 81,104$ 272,190$ 105,690$
% Change From Last Year 2.2%-1.7%33.2%-73.5%
Five Year Trend
Expenditures by Department
3/31/19 3/31/20 3/31/20 3/31/20 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 30,120$ 46,922$ 46,200$ 101.6%176,490$ 16,802$
Public Works 629,286 613,155 2,556,810 24.0%4,390,810 (16,131)
Engineering & Capital Projects 178,139 197,009 1,051,545 18.7%9,152,415 18,870
Total Expenditures 837,545$ 857,086$ 3,654,555$ 23.5%13,719,715$ 19,541$
Five Year Trend
Village of Oak Brook
Infrastructure Fund - Major Sources Five Year Trend
For the Period Ending March 31, 2020
Revenues Expenditures
3/31/20 3/31/20
3/31/19 3/31/20 YTD % of YTD 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax -$ 9,545$ 23,750$ 40.2%95,000$ 9,545$
Real Estate Tax - - - 0.0%380,000 -
Interest 396 310 375 82.7%1,500 (86)
Total Operating Revenues 396$ 9,855$ 24,125$ 40.8%476,500$ 9,459$
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,734)$ (255,600)$ (241,330)$ (32,290)$ (24,866)$
Note - Expenditures are recorded in program 283.
Village of Oak Brook
Promenade TIF Fund Financial Update
For the Period Ending March 31, 2020
Total Total
Revenues Expenditures
3/31/20 Actual $ 9,855 265,455$
3/31/19 Actual $ 396 231,130$
% Change From Last Year 2388.6%14.9%
Major Revenues Real Estate
Sales Tax Tax Interest
3/31/20 Actual $ 9,545 $ - $ 310
3/31/19 Actual $ - $ - $ 396
% Change From Last Year N/A 0.0%-21.7%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures
3/31/20 Actual -$ 265,455$
3/31/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 March 31, 2020
Five Year Trend
Revenues Expenditures
3/31/20 3/31/20
3/31/19 3/31/20 YTD % of YTD 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Plan Review Fees 300$ 75$ 300$ 25.0%1,200$ (225)$
Building/Inspection Fees 1,688 4,837 1,995 242.5%8,000 3,149
Water Sales 2,137,068 2,249,973 2,272,000 99.0%10,302,525 112,905
Unmetered Sales 4,635 24,071 7,500 320.9%30,000 19,436
Water Connection Fees 5,980 3,920 25,005 15.7%100,000 (2,060)
Meter Charges 2,265 660 5,015 13.2%20,000 (1,605)
Special Services - 763 - N/A 30,000 763
Interest on Investments 42,274 32,536 32,505 100.1%130,000 (9,738)
Miscellaneous 11,067 12,538 18,750 66.9%75,000 1,471
Total Operating Revenues 2,205,277$ 2,329,373$ 2,363,070$ 98.6%10,696,725$ 124,096$
OPERATING EXPENDITURES
Personnel 199,975$ 216,971$ 224,135$ 96.8%868,705$ 16,996$
Materials and Supplies 9,452 2,323 19,655 11.8%74,260 (7,129)
Operation and Contract 721,453 675,996 1,461,465 46.3%5,833,755 (45,457)
Capital Outlay 83,521 460,543 205,005 224.6%6,293,225 377,022
Total Expenditures 1,014,401$ 1,355,833$ 1,910,260$ 71.0%13,069,945$ 341,432$
Surplus (Deficit) of Revenues Over
Expenditures 1,190,876$ 973,540$ 452,810$ 215.0%(2,373,220)$ (217,336)$
INTERFUND TRANSACTIONS
Transfers In 221,085$ -$ -$ 0.0%-$ (221,085)
Reimbursements To Other Funds (137,958) (131,703) (131,700) 100.0%(526,815) 6,255
Total Interfund Transactions 83,127$ (131,703)$ (131,700)$ 100.0%(526,815)$ (214,830)$
Fund Increase/(Decrease) - Budgetary Basis 1,274,003$ 841,837$ 321,110$ 262.2%(2,900,035)$ (432,166)$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay 83,521$ 460,543$
Depreciation Expense (128,026) (143,750)
IMRF Pension Expense 19,309 12,500
OPEB Expense (12,256) (11,250)
Total GAAP Adjustments (37,453)$ 318,043$
Fund Increase/(Decrease) - GAAP Basis 1,236,551$ 1,159,880$
*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 March 31, 2020
Total Total
Revenues Expenditures
3/31/20 Actual $ 2,329,373 1,355,833$
3/31/19 Actual $ 2,205,277 1,014,401$
% Change From Last Year 5.6%33.7%
Unmetered Water
Water Sales Sales Connection Fees Meter Charges Miscellaneous
3/31/20 Actual $ 2,249,973 $ 24,071 $ 3,920 $ 660 $ 12,538
3/31/19 Actual $ 2,137,068 $ 4,635 $ 5,980 $ 2,265 $ 11,067
% Change From Last Year 5.3%419.3%-34.4%-70.9%13.3%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
3/31/20 Actual 216,971$ 2,323$ 675,996$ -$ 460,543$
3/31/19 Actual 199,975$ 9,452$ 721,453$ -$ 83,521$
% Change From Last Year 8.5%-75.4%-6.3%0.0%451.4%
Five Year Trend
Expenditures by Department
3/31/19 3/31/20 3/31/20 3/31/20 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Public Works 933,573$ 895,300$ 1,642,865$ 54.5%6,527,120$ (38,273)$
Engineering & Capital Projects 80,828 460,533 267,395 172.2%6,542,825 379,705
Total Expenditures 1,014,401$ 1,355,833$ 1,910,260$ 71.0%13,069,945$ 341,432$
Five Year Trend
Village of Oak Brook
Water Fund - Major Sources Five Year Trend
For the Period Ending March 31, 2020
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Sports Core Fund Consolidated Presentation
For the Period Ending March 31, 2020
3/31/20 3/31/20
3/31/20 YTD % of YTD 2020 3/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$ -$ -$ 110,775$ 110,974$ 118,165$ 93.9%459,135$ 111,760$ (786)$
Greens Fees - - - 21,191 21,191 26,500 80.0%930,000 10,340 10,851
Pro Shop Sales - - - 15,390 15,390 19,500 78.9%207,000 19,261 (3,871)
Golf Lessons - - - 120 120 5,000 2.4%40,000 5,695 (5,575)
Driving Range Fees - - - 32,687 32,687 38,000 86.0%244,000 45,429 (12,742)
Rentals - 5,170 10,167 5,190 20,527 28,710 71.5%962,000 20,060 467
Programs/User Fees - - - - - - 0.0%66,300 - -
Food Sales - - - 926 926 1,915 48.4%180,500 1,344 (418)
Beverage Sales - - - 2,827 2,827 4,000 70.7%265,000 2,405 422
Taste of Oak Brook - - - - - - 0.0%120,000 1,000 (1,000)
Grants - - - - - - 0.0%139,800 - -
Other Revenue (243) - - 702 459 560 82.0%11,000 294 165
Total Operating Revenues (44)$ 5,170$ 10,167$ 189,808$ 205,101$ 242,350$ 84.6%3,624,735$ 217,588$ (12,487)$
OPERATING EXPENDITURES
Personnel 2,316$ -$ 31,005$ 194,782$ 228,103$ 258,915$ 88.1%1,578,100$ 228,865$ (762)$
Materials & Supplies 705 - 305 4,461 5,471 41,940 13.0%618,025 (29,458) 34,929
Operational & Contractual 21,020 21,091 6,850 52,739 101,700 359,570 28.3%1,055,095 340,144 (238,444)
Other - - - - - - 0.0%(83,150) - -
Capital 152,510 8,378 - 344,218 505,106 557,000 90.7%1,921,545 160,385 344,721
Total Operating Expenditures 176,551$ 29,469$ 38,160$ 596,200$ 840,380$ 1,217,425$ 69.0%5,089,615$ 699,936$ 140,444$
B&T Administration Overhead Allocation*14,507$ -$ (14,507)$ -$ -$ -$ 0.0%-$ -$ -$
Operating Revenues Over (Under) Expenditures (162,088)$ (24,299)$ (42,500)$ (406,392)$ (635,279)$ (975,075)$ 65.2%(1,464,880)$ (482,348)$ (152,931)$
INTERFUND TRANSACTIONS
Interfund Loan**205,329$ -$ -$ -$ 205,329$ -$ N/A -$ 230,022$ (24,693)$
Transfer From General Fund - - - - - 165,500 0.0%923,000 37,439 (37,439)
Transfer From Hotel Tax Fund - - - - - - 0.0%35,000 - -
Transfer From Golf Surcharge Fund - - - 119,719 119,719 200,000 59.9%400,000 82,047 37,672
Reimbursement From Infrastructure Fund 6,000 - - - 6,000 6,000 100.0%24,000 6,000 -
Reimbursement From Water Fund 2,001 - - - 2,001 1,995 100.3%8,000 2,001 -
Reimbursement To General Fund (7,056) - - (7,056) (14,112) (14,100) 100.1%(56,450) - (14,112)
Total Interfund Transactions 206,274$ -$ -$ 112,663$ 318,937$ 359,395$ 88.7%1,333,550$ 357,509$ (38,572)$
Total Revenues Over (Under) Expenditures - Budgetary Basis 44,186$ (24,299)$ (42,500)$ (293,729)$ (316,342)$ (615,680)$ (131,330)$ (124,839)$ (191,503)$
ADUSTMENTS TO GAAP BASIS***
Remove Capital Outlay 152,510$ 8,378$ -$ 344,218$ 505,106$ 160,385$
Depreciation Expense (37,476) (421) (8,750) (53,000) (99,647) (82,097)
IMRF Pension Expense (1,313) (63) (500) (2,963) (4,838) 23,193
OPEB Expense - - (1,300) (10,000) (11,300) (5,009)
Total GAAP Adjustments 113,722$ 7,894$ (10,550)$ 278,256$ 389,322$ 96,472$
Fund Increase/(Decrease) - GAAP Basis 157,908$ (16,405)$ (53,050)$ (15,474)$ 72,980$ (28,367)$
*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
3/31/20 Actual $ 205,101 840,380$
3/31/19 Actual $ 217,588 699,936$
% Change From Last Year -5.7%20.1%
Driving Program/
Memberships Greens Fees Range Fees Rentals User Fees
3/31/20 Actual $ 110,974 $ 21,191 $ 32,687 $ 20,527 $ -
3/31/19 Actual $ 111,760 $ 10,340 $ 45,429 $ 20,060 $ -
% Change From Last Year -0.7%104.9%-28.0%2.3%0.0%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
3/31/20 Actual 228,103$ 5,471$ 101,700$ -$ 505,106$
3/31/19 Actual 228,865$ (29,458)$ 340,144$ -$ 160,385$
% Change From Last Year -0.3%-118.6%-70.1%0.0%214.9%
Five Year Trend
Revenues by Department 3/31/19 3/31/20 3/31/20 3/31/20 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Operations 3,074$ (44)$ 11,725$ -0.4%506,735$ (3,118)$
Open Field Operations 5,790 5,170 7,485 69.1%407,000 380
B&T Clubhouse Operations 11,027 10,167 15,000 67.8%300,000 (860)
Golf Club 197,697 189,808 208,140 91.2%2,411,000 (7,889)
Total Revenues 217,588$ 205,101$ 242,350$ 84.6%3,624,735$ (11,487)$
Expenditures by Department 3/31/19 3/31/20 3/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 279,760$ 176,551$ 299,460$ 59.0%1,752,045$ (103,209)$
Open Field Operations 13,983$ 29,469$ 2,625$ 1122.6%267,110$ 15,486$
B&T Clubhouse Operations 101,866 38,160 257,995 14.8%458,770 (63,706)
Golf Club 304,327 596,200 657,345 90.7%2,611,690 291,873
Total Expenditures 699,936$ 840,380$ 1,217,425$ 69.0%5,089,615$ 140,444$
Five Year Trend
Village of Oak Brook
Sports Core Fund - Major Sources Five Year Trend
For the Period Ending March 31, 2020
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Club Recreation Operations
For the Period Ending March 31, 2020 3/31/20 3/31/20
822 3/31/20 YTD % of YTD 2020 3/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$ 11,665$ 1.7%241,635$ 3,935$ (3,736)$
Programs/User Fees - - - - - - 0.0%66,300 - -
Food Sales - - - - - - 0.0%36,000 - -
Beverage Sales - - - - - - 0.0%20,000 - -
Grants - - - - - - 0.0%139,800 - -
Other Revenue (243) - - - (243) 60 -405.0%3,000 (861) 618
Total Operating Revenues (243)$ 199$ -$ -$ (44)$ 11,725$ -0.4%506,735$ 3,074$ (3,118)$
OPERATING EXPENDITURES
Personnel 1,649$ -$ -$ 667$ 2,316$ 18,585$ 12.5%163,580$ 14,266$ (11,950)$
Materials & Supplies 164 456 85 - 705 8,350 8.4%57,650 31 674
Operational & Contractual 19,904 876 156 84 21,020 272,525 7.7%418,270 260,944 (239,924)
Capital - 152,510 - - 152,510 - N/A 1,112,545 4,519 147,991
Total Operating Expenditures 21,717$ 153,842$ 241$ 751$ 176,551$ 299,460$ 59.0%1,752,045$ 279,760$ (103,209)$
B&T Administration Overhead Allocation*29,016$ (10,446)$ (2,902)$ (1,161)$ 14,507$ 29,160$ 49.7%93,235$ 22,908$ (8,401)$
Operating Revenues Over (Under) Expenditures 7,056$ (164,089)$ (3,143)$ (1,912)$ (162,088)$ (258,575)$ 62.7%(1,152,075)$ (253,778)$ 91,690$
INTERFUND TRANSACTIONS
Interfund Loan**205,329$ -$ -$ -$ 205,329$ -$ N/A -$ 230,022$ (24,693)$
Transfer From General Fund - - - - - - 0.0%757,500 4,385 (4,385)
Reimbursement From Infrastructure Fund 6,000 - - - 6,000 6,000 100.0%24,000 6,000 -
Reimbursement From Water Fund 2,001 - - - 2,001 1,995 100.3%8,000 2,001 -
Reimbursement To General Fund (7,056) - - - (7,056) (7,050) 100.1%(28,225) - (7,056)
Total Interfund Transactions 206,274$ -$ -$ -$ 206,274$ 945$ 21827.9%761,275$ 242,408$ (36,134)$
Total Revenues Over (Under) Expenditures - Budgetary Basis 213,330$ (164,089)$ (3,143)$ (1,912)$ 44,186$ (257,630)$ (390,800)$ (11,370)$ 55,556$
ADUSTMENTS TO GAAP BASIS***
Remove Capital Outlay -$ 152,510$ -$ -$ 152,510$ 4,519$
Depreciation Expense - (35,934) (1,250) (292) (37,476) (23,706)
IMRF Pension Expense (1,250) - - (63) (1,313) 1,525
Total GAAP Adjustments (1,250)$ 116,576$ (1,250)$ (355)$ 113,722$ (17,662)$
Fund Increase/(Decrease) - GAAP Basis 212,080$ (47,513)$ (4,393)$ (2,267)$ 157,908$ (29,032)$
*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 March 31, 2020 3/31/20 3/31/20
3/31/20 YTD % of YTD 2020 3/31/19 Difference
815 816 YTD Amended Amended Adopted YTD Prior
Polo Open Fields Total Budget Budget Budget Total Year
OPERATING REVENUES
Field Rentals -$ 5,170$ 5,170$ 7,485$ 69.1%212,000$ 4,790$ 380$
Range Rentals - - - - 0.0%75,000 - -
Taste of Oak Brook - - - - 0.0%120,000 1,000 -
Other Revenue - - - - 0.0%- - -
Total Operating Revenues -$ 5,170$ 5,170$ 7,485$ 69.1%407,000$ 5,790$ 380$
OPERATING EXPENDITURES
Personnel -$ -$ -$ -$ 0.0%10,810$ -$ -$
Materials & Supplies - - - - 0.0%1,700 - -
Operational & Contractual 20,000 1,091 21,091 2,625 803.5%239,600 13,983 7,108
Other - - - - 0.0%- - -
Capital - 8,378 8,378 - N/A 15,000 - 8,378
Total Operating Expenditures 20,000$ 9,469$ 29,469$ 2,625$ 1122.6%267,110$ 13,983$ 15,486$
Operating Revenues Over (Under) Expenditures (20,000)$ (4,299)$ (24,299)$ 4,860$ -500.0%139,890$ (8,193)$ (15,106)$
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)$ (4,299)$ (24,299)$ 4,860$ 174,890$ (8,193)$ (15,106)$
ADUSTMENTS TO GAAP BASIS***
Remove Capital Outlay -$ 8,378$ 8,378$ -$
Depreciation Expense - (421) (421) (421)
IMRF Pension Expense - (63) (63) 184
Total GAAP Adjustments -$ 7,894$ 7,894$ (238)$
Fund Increase/(Decrease) - GAAP Basis (20,000)$ 3,595$ (16,405)$ (8,431)$
*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 March 31, 2020
3/31/20 3/31/20
821 YTD % of YTD 2020 3/31/19 Difference
B&T Amended Amended Adopted YTD Prior
Clubhouse Budget Budget Budget Total Year
OPERATING REVENUES
Rentals 10,167$ 15,000$ 67.8%300,000$ 11,027$ (860)$
Total Operating Revenues 10,167$ 15,000$ 67.8%300,000$ 11,027$ (860)$
OPERATING EXPENDITURES
Personnel 31,005$ 31,335$ 98.9%140,045$ 29,597$ 1,408$
Materials & Supplies 305 5,530 5.5%20,225 2,114 (1,809)
Operational & Contractual 6,850 32,130 21.3%109,500 5,854 996
Capital - 189,000 0.0%189,000 64,301 (64,301)
Total Operating Expenditures 38,160$ 257,995$ 14.8%458,770$ 101,866$ (63,706)$
B&T Administration Overhead Allocation*(14,507)$ (29,160)$ 49.7%(93,235)$ (22,908)$ 8,401$
Operating Revenues Over (Under) Expenditures (42,500)$ (272,155)$ 15.6%(252,005)$ (113,747)$ 71,247$
INTERFUND TRANSACTIONS
Transfer From General Fund -$ 165,500$ 0.0%165,500$ 33,054$ (33,054)$
Total Interfund Transactions -$ 165,500$ 0.0%165,500$ 33,054$ (33,054)$
Total Revenues Over (Under) Expenditures - Budgetary Basis (42,500)$ (106,655)$ (86,505)$ (80,693)$ 38,193$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay -$ 64,301$
Depreciation Expense (8,750) (8,038)
IMRF Pension Expense (500) 1,675
OPEB Expense (1,300) (525)
Total GAAP Adjustments (10,550)$ 57,413$
Fund Increase/(Decrease) - GAAP Basis (53,050)$ (23,280)$
*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 March 31, 2020
3/31/20 3/31/20
823 831 832 833 834 3/31/20 YTD % of YTD 2020 3/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 -$ 110,775$ -$ -$ -$ 110,775$ 106,500$ 104.0%217,500$ 107,825$ 2,950$
Greens Fees - 21,191 - - - 21,191 26,500 80.0%930,000 10,340 10,851
Pro Shop Sales - 15,390 - - - 15,390 19,500 78.9%207,000 19,261 (3,871)
Golf Lessons - - 120 - - 120 5,000 2.4%40,000 5,695 (5,575)
Driving Range Fees - - 32,687 - - 32,687 38,000 86.0%244,000 45,429 (12,742)
Rentals - 20 - 5,170 - 5,190 6,225 83.4%375,000 4,243 947
Food Sales 926 - - - - 926 1,915 48.4%144,500 1,344 (418)
Beverage Sales 2,827 - - - - 2,827 4,000 70.7%245,000 2,405 422
Other Revenue - 702 - - - 702 500 140.4%8,000 1,155 (453)
Total Operating Revenues 3,753$ 148,078$ 32,807$ 5,170$ -$ 189,808$ 208,140$ 91.2%2,411,000$ 197,697$ (7,889)$
OPERATING EXPENDITURES
Personnel 13,892$ 106,889$ -$ 1,847$ 72,154$ 194,782$ 208,995$ 93.2%1,263,665$ 185,002$ 9,780$
Materials & Supplies 8,885 (14,313) - 478 9,411 4,461 28,060 15.9%538,450 (31,603) 36,064
Operational & Contractual 1,326 42,207 - - 9,206 52,739 52,290 100.9%287,725 59,363 (6,624)
Other - - - - - - - 0.0%(83,150) - -
Capital - 261,511 - - 82,707 344,218 368,000 93.5%605,000 91,565 252,653
Total Operating Expenditures 24,103$ 396,294$ -$ 2,325$ 173,478$ 596,200$ 657,345$ 90.7%2,611,690$ 304,327$ 291,873$
Operating Revenues Over (Under) Expenditures (20,350)$ (248,216)$ 32,807$ 2,845$ (173,478)$ (406,392)$ (449,205)$ 90.5%(200,690)$ (106,630)$ (299,762)$
INTERFUND TRANSACTIONS
Transfer from Golf Surcharge -$ 119,719$ -$ -$ -$ 119,719$ 200,000$ 59.9%400,000$ 82,047$ 37,672$
Reimbursement to General Fund - (7,056) - - - (7,056) (7,050) 100.1%(28,225) - (7,056)
Total Interfund Transactions -$ 112,663$ -$ -$ -$ 112,663$ 192,950$ 58.4%371,775$ 82,047$ 30,616$
Total Revenues Over (Under) Expenditures - Budgetary Basis (20,350)$ (135,553)$ 32,807$ 2,845$ (173,478)$ (293,729)$ (256,255)$ 171,085$ (24,583)$ (269,146)$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay -$ 261,511$ -$ -$ 82,707$ 344,218$ 91,565$
Depreciation Expense - (33,750) (1,000) (5,750) (12,500) (53,000) (49,932)
IMRF Pension Expense (375) (1,250) (88) - (1,250) (2,963) 19,810
OPEB Expense (750) (5,750) - - (3,500) (10,000) (4,484)
Total GAAP Adjustments (1,125)$ 220,761$ (1,088)$ (5,750)$ 65,457$ 278,256$ 56,959$
Fund Increase/(Decrease) - GAAP Basis (21,475)$ 85,208$ 31,720$ (2,905)$ (108,021)$ (15,474)$ 32,376$
*Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.