02 - February 2020 Monthly Financial ReportVILLAGE
OAK BROOK
OF
MONTHLY FINANCIAL REPORTS
FEBRUARY 2020
ITEM 6.D
Cash and Investments by Fund:Total
Cash and Cash Pooled Cash and
Fund Equivalents Investments Investments % By Fund
General Corporate $6,503,987 $14,898,321 $21,402,308 48.7%
Hotel/Motel Tax 2,577,015 2,473,585 5,050,600 11.5%
Motor Fuel Tax 1,020,203 82,194 1,102,397 2.5%
Infrastructure 6,348,439 1,975,485 8,323,924 18.9%
Promenade TIF 39,009 - 39,009 0.1%
Water 2,815,460 3,512,342 6,327,802 14.4%
Sports Core 122,531 - 122,531 0.3%
Golf Surcharge 40,193 187,951 228,144 0.5%
Self-Insurance 244,839 - 244,839 0.6%
Garage 286,191 - 286,191 0.7%
Equipment Replacement 455,157 379,643 834,800 1.9%
Total $20,453,024 $23,509,521 $43,962,545 100.0%
Change in Cash and Investments by Fund :
Balance at Balance at Year-to-Date Year-to-Date
Fund January 1, 2020 February 29, 2020 Change ($)Change (%)
General Corporate $21,270,239 $21,402,308 $132,069 0.6%
Hotel/Motel Tax 5,427,474 5,050,600 (376,874)-6.9%
Motor Fuel Tax 1,085,595 1,102,397 16,802 1.5%
Infrastructure 8,217,724 8,323,924 106,200 1.3%
Promenade TIF 304,194 39,009 (265,185)-87.2%
Water 6,947,239 6,327,802 (619,437)-8.9%
Sports Core 231,216 122,531 (108,685)-47.0%
Golf Surcharge 347,066 228,144 (118,922)-34.3%
Self-Insurance 308,820 244,839 (63,981)-20.7%
Garage 275,988 286,191 10,203 3.7%
Equipment Replacement 808,879 834,800 25,921 3.2%
$45,224,434 $43,962,545 ($1,261,889)-2.8%
Book Bank/Market
Value Value
Cash and Cash Equivalents:
Pooled Checking $900,337 $1,365,317
Sports Core Checking 81,236 80,053
Pooled IPTIP 19,396,348 19,396,348
Water E-Pay IPTIP 75,103 66,493
$20,453,024 $20,908,211
Pooled Investments:
Investments-Municipal Bonds $5,949,554 $6,002,479
Investments-Corporate Bonds 8,303,730 8,393,990
Government & Agency Obligations 2,659,517 2,673,379
Certificates of Deposit 6,485,000 6,522,496
Accrued Interest 111,720 111,720
Total Pooled Investments $23,509,521 $23,704,064
Total Cash and Investments $43,962,545 $44,612,275
For February, total interest revenue is $71,603 and YTD is $146,387. The total investment yield for the portfolio is:
Pooled
Investments Illinois Funds Total
Last 12 months yield 2.32%2.19%2.26%
The weighted average yield of the current pooled investment portfolio is 2.30%. The IL Funds February average daily rate was 1.66%.
Monthly Treasurer's Report
February 29, 2020
Monthly Treasurer's Report
February 2020
The table below lists the detail investment holdings at J.P. Morgan Securities as of 2/29/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,790 202,390 1,552
Florida Hurricane #34074GDH4 03/30/16 07/01/20 2.995%2.150%501,308 502,815 2,495
Bloomingdale Mich Pub Sch Dist #094383FS0 04/26/16 05/01/22 2.710%2.150%505,857 513,920 4,478
Milan Mich Area Achs #598801JD1 05/26/16 05/01/20 1.931%1.931%245,000 245,110 1,476
Lanse Creuse Mich Pub Schs #516228RL9 05/02/17 05/01/20 2.159%2.159%100,000 100,114 717
Connecticut St GO Bds 2016 #20772J3F7 06/15/17 08/15/21 1.750%2.300%496,095 504,320 336
Fowlerville Mich Comnty Schs #351280MS8 10/03/17 05/01/20 2.045%1.750%500,249 500,430 3,238
Wisconsin St Gen Fd Annual #977100CW4 01/05/18 05/01/20 1.446%2.100%599,336 599,814 2,796
Wright County Min #982276BC0 07/18/19 12/01/20 2.000%2.000%545,000 547,867 3,240
State of IL #452152P54 10/09/19 11/01/21 5.000%1.870%525,684 532,515 8,082
Anchor Bay Mich Sch #032879TE8 11/01/19 05/01/21 2.320%1.750%719,713 723,466 5,391
Brownsville TX #16405ST9 12/19/19 02/15/22 2.050%2.000%555,522 562,287 348
Laredo TX Waterworks #517039VW0 12/19/19 03/01/24 2.230%2.230%455,000 467,431 1,973
Total Municipal Bonds $5,949,554 $6,002,479 $36,122
Corporate Bonds:
Goldman Sachs #38141GVP9 09/26/18 09/15/20 2.750%3.180%498,872 502,270 6,302
Wells Fargo #94974BGR5 01/15/19 12/07/20 2.550%3.120%1,384,131 1,399,619 8,566
PNC Bank #69353RFH6 01/30/19 01/22/21 2.500%3.020%497,742 503,815 1,354
Morgan Stanley #61747WAL3 03/08/19 07/28/21 5.500%3.034%1,085,304 1,106,375 5,133
Citigroup #172967LC3 04/01/19 12/08/21 2.900%2.754%1,002,498 1,020,490 6,122
Bank of America #06051GFT1 04/03/19 10/19/20 2.625%2.625%700,000 705,033 6,482
Goldman Sachs #38143U8F1 05/02/19 02/25/21 2.875%2.707%365,581 368,745 148
American Honda #02665WBG5 07/31/19 09/09/21 1.700%2.180%496,436 502,630 4,084
BB&T Corp #05531FAZ6 08/15/19 02/01/21 2.150%2.010%750,955 752,153 1,147
JP Morgan #48128BAB7 09/30/19 01/15/23 2.972%2.337%1,017,523 1,027,690 3,798
JP Morgan #46625HRT9 01/30/20 06/07/21 2.400%1.648%504,688 505,170 2,800
Total Corporate Bonds $8,303,730 $8,393,990 $45,936
Government & Agency Obligations:
*Government National Mtg Assn #38379UEM4 02/29/16 02/16/51 2.300%2.245%$653,912 $645,982 $2,358
*Government National Mtg Assn #38381WV96 08/06/19 07/20/54 2.250%2.293%886,947 896,104 1,593
*Government National Mtg Assn #38380BNV3 12/05/19 06/20/46 2.000%2.112%628,658 641,896 1,010
Fed Farm Credit Bank #3133EK5Y8 11/14/19 02/14/22 1.770%1.770%490,000 489,397 723
Total Government & Agency Obligations:$2,659,517 $2,673,379 $5,684
Certificates of Deposit:
State Bk India NY #8562846A7 01/26/17 01/26/22 2.250%2.250%$245,000 $248,685 $537
American Express Centurion #02587DV96 08/15/17 08/17/20 1.900%1.900%245,000 245,461 175
Sallie Mae #795450C86 08/16/17 08/17/20 1.900%1.900%245,000 245,461 175
Merrick Bank South Jordan #59013JZS1 08/21/17 08/21/20 1.800%1.800%245,000 245,350 104
Pinnacle Bank #72345SFS5 08/30/17 08/31/20 1.800%1.800%115,000 115,174 173
Jackson County Bank #466682AP6 08/31/17 03/01/21 1.850%1.850%245,000 245,975 2,266
Barclays Bank #06740KKX4 09/27/17 09/28/20 1.950%1.950%245,000 245,659 2,031
Goldman Sachs Bank #38148PRK5 10/18/17 10/19/20 1.950%1.950%245,000 245,747 1,752
FirstBank PR Santurce #33767A6M8 11/03/17 11/03/20 2.000%2.000%245,000 245,889 344
Morgan Stanley #61747MQ53 03/22/18 03/23/20 2.550%2.550%245,000 245,167 2,616
Lakeside Bank #51210SPS0 08/30/18 03/30/20 2.550%2.550%245,000 245,218 522
Compass Bank #20451PVW3 10/26/18 10/26/20 3.000%3.000%245,000 247,460 2,532
UBS Bank #90348JFH8 10/30/18 10/29/20 3.050%3.050%245,000 247,587 628
Discover Bank #254673WF9 11/07/18 11/09/20 3.000%3.000%245,000 247,607 2,307
Ally Bank #02007GFX6 11/08/18 11/09/20 3.000%3.000%245,000 247,607 2,287
Comenity Cap Bank #20033AU46 04/15/19 04/15/21 2.500%2.500%245,000 247,876 224
Morgan Stanley #61760AE21 05/30/19 06/01/21 2.400%2.400%245,000 247,896 1,446
First St Bank DeQueen #336460CU2 07/18/19 07/19/21 2.000%2.000%245,000 246,852 176
Bank Hapoalim #06251AW89 07/19/19 07/19/21 2.000%2.000%245,000 247,188 469
Capital One Natl Assn #14042RMF5 07/24/19 07/26/19 2.050%2.050%245,000 247,048 607
TIAA FSB Jacksonville #87270LCN1 07/29/19 07/29/21 2.000%2.000%245,000 246,889 429
Wells Fargo #949763J31 09/18/19 09/20/21 1.850%1.850%245,000 246,509 177
BMW Bank #05580ASQ8 10/11/19 10/12/21 1.800%1.800%245,000 246,370 1,654
Metabank #59101LHW0 11/20/19 08/19/21 1.750%1.750%245,000 245,037 170
Wells Fargo #949495AN5 01/17/20 01/18/22 1.800%1.800%245,000 246,595 177
Southpoint Bank #84464PBK2 02/28/20 02/28/22 1.600%1.600%245,000 245,130 -
New York Cmnty Bk Westbury #649447TM1 02/28/20 02/28/22 1.600%1.600%245,000 245,059 -
Total Certificates of Deposits $6,485,000 $6,522,496 $23,978
Total J.P.Morgan Securities $23,397,801 $23,592,344 $111,720
*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
February 29, 2020
Cash & Investments by Fund - Total $44.0 million
Cash & Investments by Type - Total $44.0 million
Checking
Illinois Funds
Certificates of Deposit
Municipal Bonds
Corporate Bonds
Government & Agency Obligations
Accrued Interest
General Corporate
48.68%
Hotel/Motel Tax
11.49%Motor Fuel Tax
2.51%
Infrastructure
18.93%
Promenade TIF
0.09%
Water
14.39%
Sports Core
0.28%
Golf Surcharge
0.52%
Self-Insurance
0.56%Garage
0.65%
Equipment
Replacement
1.90%
Checking, $1.0
Illinois Funds, $19.5
Certificates of Deposit,
$6.5
Municipal Bonds, $5.9
Corporate Bonds, $8.3
Government & Agency
Obligations, $2.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)4,262,018 $4,412,193 ($150,175)($49,760)
Main operating fund of the Village.
Hotel Fund (Major Fund)$158,175 $36,869 $121,306 $42,250
Collects and spends resources from the
3% hotel/motel tax.
Motor Fuel Tax Fund $62,176 $0 $62,176 $54,830
Collects and spends resources from the
State motor fuel tax.
Infrastructure Fund (Major Fund)$1,062,981 $583,588 $479,393 ($891,655)
Accounts for construction and maintenance of
roadways, drainage, and safety path systems.
Promenade TIF Fund (Major Fund)$270 $265,455 ($265,185)($265,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)$1,351,053 $1,065,776 $285,277 $13,185
Collects user fees for the distribution of water
and maintenance of infrastructure.
Sports Core Fund (Major Fund)$250,581 $355,334 ($104,753)($540,585)
Accounts for revenues and expenses relating
to administration, programs, food and beverage
operations, and golf course.
Golf Surcharge Fund $798 $119,719 ($118,921)$420
Accounts for the collection of the $3 per round
golf surcharge.
Internal Service Funds
Self Insurance Fund $576,530 $355,454 $221,076 ($7,000)
Accounts for the Village's health insurance costs
and the related contributions from the Village,
employees, retirees, and other agencies.
Garage Fund $122,826 $117,663 $5,163 ($9,565)
Accounts for the maintenance of the Village's vehicle
fleet and the related departmental reimbursements.
Equipment Replacement Fund $55,778 $29,857 $25,921 $19,030
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 February 29, 2020
Village of Oak Brook
Monthly Financial Report – Fund Narrative
For the Period Ending February 29, 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
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 February 2020 are $79,943, or 2.0%, higher than last February, but
$153,475, or 3.6%, under budget to date. The main drivers for this are:
o Sales tax revenue, the General
Fund’s largest revenue source, is
down $52,563 from last year
and $16,360 under budget.
Despite February 2020
collections being under 2019
collections, collections over the
past five years have been
relatively consistent.
o Other intergovernmental tax
revenue is up $30,769 from last
year and $37,560 over budget. The Village has experienced strong collections in income
tax, use tax, and replacement tax to date.
o Licenses and permits revenue is up $118,459 from last year, but is $47,591 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 projects kicking off.
Total expenditures through February 2020 are $91,489, or 2.2%, higher than last year, but
$158,066, or 3.6%, under budget to date. The main drivers for this are:
o Personnel expenditures are up $325,425 from last year and $53,078 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 $121,391 from last year and $121,354
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,402 from last year and $62,594 under
budget. Many capital items have been put on hold for 2020 due to the current
economic state.
Hotel Tax Fund
Total revenues through February 2020 are $15,232, or 8.8%, lower than last year, but $7,375, or
4.9%, over budget. The main drivers for this are:
o Hotel tax revenue is down $13,354 from last year, but $3,028 over budget. The
decrease is due to the timing of receipts being received vs. when projected.
Total expenditures through February 2020 are $24,340 higher than last year, but $71,683, or
74.6%, under budget. The main drivers for this are:
o Operation and contract expenditures are up $4,761 from last year, but $91,262 under
budget. Payments for early 2020 marketing have not been made to date.
o Capital Outlay expenditures are up $19,579 from last year and $19,579 over budget.
The street light replacements began earlier than originally projected.
Infrastructure Fund
Total revenues through February 2020 are down $32,650, or 3.2%, from last year, but $5,415, or
0.5%, over budget. The main drivers for this are:
o Non-home rule sales tax revenue
is down $19,318 from last year,
but $2,393 over budget. Despite
February 2020 collections being
under 2019 collections,
collections over the past five
years have been relatively
consistent.
o Interest revenue is down
$13,332 from last year, but
$3,612 over budget. Interest
rates have dropped in recent months compared to last year, but are still at levels
projected for 2020.
Total expenditures through February 2020 are down $25,579, or 4.4%, from last year and
$1,365,637, or 71.0%, under budget to date. The main drivers for this are:
o Operation and contract expenditures are up $19,954 from last year, but $125,713 under
budget. Expenditures are under budget due to the timing of engineering payments.
o Capital Outlay expenditures are down $44,098 from last year and $1,247,521 under
budget. Payments for ongoing projects have not occurred to date.
Promenade TIF Fund
Total revenues through February 2020 are down $69, or 20.4%, from last year, but $20, or 8.0%,
over budget. Interest rates have dropped in recent months compared to last year, but are still
at levels projected for 2020.
Total expenditures through February 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 February 2020 are up $80,703, or 6.4%, from last year, but $6,667, or
0.5%, under budget. The main drivers for this are:
o Water sales revenue is up $88,542 from last year and $12,072 over budget. The
increase from last year is due to a 7% rate increase effective 1/1/20. Water gallons sold
has also been slightly higher than projected so far this year.
Total expenditures through February 2020 are up $369,147, or 60.6%, from last year, but
$278,761, or 22.2%, under budget. The main drivers for this are:
o Operation and contract expenditures are down $37,771 from last year, but $619,703
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 $399,470 from last year and $357,290 over budget.
This is due to water main replacement payments happening sooner than projected.
Sports Core Fund
Total revenues through February 2020 are down $8,613, or 29.6%, from last year, but $18,522,
or 47.4%, under budget to date. In February, only miscellaneous revenue sources have been
collected and recorded. Golf memberships and user fees are expected to begin in February or
March. B&T memberships were budgeted for 2020, but these will now be collected by the Park
District and will show as under budget and less than 2019 amounts.
Total expenditures through February 2020 are down $193,573, or 35.9%, from last year and
$229,639, or 39.9%, under budget to date. The main drivers for this are:
o Operation and Contractual expenditures are down $234,499 from last year and
$258,522 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 $67,965 from last year and $58,344 over budget. This is due
to the golf lounge renovation beginning earlier than projected.
2/29/20 2/29/20
2/29/19 2/29/20 YTD % of YTD 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 2,206,953$ 2,154,390$ 2,170,750$ 99.2%12,502,000$ (52,563)$
Other Intergovernmental Tax 222,291 253,060 215,500 117.4%1,352,000 30,769
Telecommunications/Utility Tax 1,056,008 1,043,773 1,049,000 99.5%6,125,000 (12,235)
Licenses and Permits 296,905 415,364 462,955 89.7%2,990,190 118,459
Charges for Services 155,788 150,190 192,990 77.8%1,253,100 (5,598)
Fines and Penalties 42,022 31,097 32,000 97.2%192,000 (10,925)
Administrative Towing Fees 5,000 4,637 3,330 139.2%20,000 (363)
Interest on Investments 70,687 74,262 69,170 107.4%415,000 3,575
Franchise/IMF Maint. Fee - - 52,500 0.0%210,000 -
Miscellaneous Income 22,023 30,847 62,900 49.0%443,095 8,824
Total Operating Revenues 4,077,677$ 4,157,620$ 4,311,095$ 96.4%25,502,385$ 79,943$
OPERATING EXPENDITURES
Personnel 3,243,168$ 3,568,593$ 3,515,515$ 101.5%19,160,220$ 325,425$
Materials and Supplies 72,557 71,413 99,270 71.9%539,170 (1,144)
Operation and Contract 753,507 632,116 753,470 83.9%4,071,660 (121,391)
Other Expenditures 2,200 2,201 1,540 142.9%10,000 1
Capital Outlay 120,978 9,576 72,170 13.3%688,030 (111,402)
Total Operating Expenditures 4,192,410$ 4,283,899$ 4,441,965$ 96.4%24,469,080$ 91,489$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES (114,733)$ (126,279)$ (130,870)$ 1,033,305$ (11,546)$
INTERFUND TRANSACTIONS
Transfers In 508,235$ -$ -$ 0.0%-$ (508,235)$
Transfers Out - - 0.0%(923,000) -
Reimbursements From Other Funds 105,368 104,398 104,400 100.0%626,395 (970)
Reimbursements To Other Funds (21,850) (23,294) (23,290) 100.0%(139,770) (1,444)
Sports Core Loan (275,188) (105,000) - 0.0%- 170,188
Total Interfund Transactions 316,565$ (23,896)$ 81,110$ -29.5%(436,375)$ (340,461)$
NET FUND INCREASE (DECREASE)201,832$ (150,175)$ (49,760)$ 596,930$ (352,007)$
Village of Oak Brook
General Fund Financial Update
For the Period Ending February 29, 2020
Total Total
Revenues Expenditures
2/29/20 Actual 4,157,620$ 4,283,899$
2/29/19 Actual 4,077,677$ 4,192,410$
% Change From Last Year 2.0%2.2%
Major Revenues
Other Telecom/Utility Licenses &Charges for
Sales Tax Intergov. Tax Tax Permits Services
2/29/20 Actual 2,154,390$ 253,060$ 1,043,773$ 415,364$ 150,190$
2/29/19 Actual $ 2,206,953 $ 222,291 $ 1,056,008 $ 296,905 $ 155,788
% Change From Last Year -2.4%13.8%-1.2%39.9%-3.6%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
2/29/20 Actual 3,568,593$ 71,413$ 632,116$ 2,201$ 9,576$
2/29/19 Actual 3,243,168$ 72,557$ 753,507$ 2,200$ 120,978$
% Change From Last Year 10.0%-1.6%-16.1%0.0%-92.1%
Five Year Trend
Expenditures by Department
2/29/19 2/29/20 2/29/20 2/29/20 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Department Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 442,636$ 410,656$ 530,970$ 77.3%2,556,835$ (31,980)$
Financial Services 133,831 139,166 140,800 98.8%781,455 5,335
Public Works 86,898 88,235 133,950 65.9%893,055 1,337
Engineering & Capital Projects 104,724 3,010 20,300 14.8%411,500 (101,714)
Library 170,892 183,661 192,490 95.4%994,410 12,769
Police 1,573,365 1,804,602 1,735,745 104.0%9,493,905 231,237
Fire 1,506,003 1,485,273 1,506,930 98.6%8,298,370 (20,730)
Development Services 174,061 169,296 180,780 93.6%1,039,550 (4,765)
Total Expenditures 4,192,410$ 4,283,899$ 4,441,965$ 96.4%24,469,080$ 91,489$
Five Year Trend
For the Period Ending February 29, 2020
General Fund - Five Year Trend
Village of Oak Brook
Revenues Expenditures
2/29/20 2/29/20
2/29/19 2/29/20 YTD % of YTD 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Hotel Tax 154,682$ 141,328$ 138,300$ 102.2%1,212,500$ (13,354)$
Interest 18,725 16,847 12,500 134.8%75,000 (1,878)
Total Operating Revenues 173,407$ 158,175$ 150,800$ 104.9%1,287,500$ (15,232)$
EXPENDITURES
Operation and Contract 77$ 4,838$ 96,100$ 5.0%576,615$ 4,761$
Capital Outlay - 19,579 - N/A 640,395 19,579
Total Expenditures 77$ 24,417$ 96,100$ 25.4%1,217,010$ 24,340$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 173,330$ 133,758$ 54,700$ 244.5%70,490$ (39,572)$
INTERFUND TRANSACTIONS
Transfer Out -$ -$ -$ 0.0%(338,125)$ -$
Reimbursements to Other Funds (17,186) (12,452) (12,450) 100.0%(74,715) 4,734
Total Interfund Transactions (17,186)$ (12,452)$ (12,450)$ 100.0%(412,840)$ 4,734$
NET FUND INCREASE (DECREASE)156,144$ 121,306$ 42,250$ (342,350)$ (34,838)$
Note - Expenditures are recorded in program 171.
Village of Oak Brook
Hotel Tax Fund Financial Update
For the Period Ending February 29, 2020
Total Total
Revenues Expenditures
2/29/20 Actual $ 158,175 24,417$
2/29/19 Actual $ 173,407 77$
% Change From Last Year -8.8%31610.4%
Major Revenues
Hotel Tax Interest Miscellaneous
2/29/20 Actual $ 141,328 $ 16,847 $ -
2/29/19 Actual $ 154,682 $ 18,725 $ -
% Change From Last Year -8.6%-10.0%0.0%
Five Year Trend
Major Expenditures Operation &
Contractual Capital Outlay
2/29/20 Actual 4,838$ 19,579$
2/29/19 Actual 77$ -$
% Change From Last Year 6183.1%N/A
Five Year Trend
Village of Oak Brook
Hotel Tax Fund - Major Sources Five Year Trend
For the Period Ending February 29, 2020
Five Year Trend
Revenues Expenditures
2/29/20 2/29/20
2/29/19 2/29/20 YTD % of YTD 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 997,961$ 978,643$ 976,250$ 100.2%5,615,000$ (19,318)$
Charges for Services - - 170 0.0%1,000 -
Interest 37,774 24,442 20,830 117.3%125,000 (13,332)
Miscellaneous - - 420 0.0%2,500 -
Total Operating Revenues 1,035,735$ 1,003,085$ 997,670$ 100.5%5,743,500$ (32,650)$
OPERATING EXPENDITURES
Personnel 285,914$ 284,358$ 287,150$ 99.0%1,389,540$ (1,556)$
Materials and Supplies 63,548 63,669 53,280 119.5%253,295 121
Operation and Contract 186,078 206,032 331,745 62.1%1,856,790 19,954
Capital Outlay 46,577 2,479 1,250,000 0.2%10,220,090 (44,098)
Total Operating Expenditures 582,117$ 556,538$ 1,922,175$ 29.0%13,719,715$ (25,579)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 453,618$ 446,547$ (924,505)$ -48.3%(7,976,215)$ (7,071)$
INTERFUND TRANSACTIONS
Transfers In 216,125$ -$ -$ 0.0%1,653,125$ (216,125)$
Reimbursements From Other Funds 55,574 59,896 59,900 100.0%359,380 4,322
Reimbursements To Other Funds (26,922) (27,050) (27,050) 100.0%(162,300) (128)
Total Interfund Transactions 244,777$ 32,846$ 32,850$ 100.0%1,850,205$ (211,931)$
NET FUND INCREASE (DECREASE)698,395$ 479,393$ (891,655)$ (6,126,010)$ (219,002)$
Village of Oak Brook
Infrastructure Fund Financial Update
For the Period Ending February 29, 2020
Total Total
Revenues Expenditures
2/29/20 Actual $ 1,003,085 556,538$
2/29/19 Actual $ 1,035,735 582,117$
% Change From Last Year -3.2%-4.4%
Major Revenues
Sales Tax
Charges for
Services Interest Miscellaneous Reimbursements
2/29/20 Actual $ 978,643 $ - $ 24,442 $ - $ 59,896
2/29/19 Actual $ 997,961 $ - $ 37,774 $ - $ 55,574
% Change From Last Year -1.9%0.0%-35.3%0.0%7.8%
Five Year Trend
Major Expenditures Materials &Operation &
Personnel Supplies Contractual Capital Outlay
2/29/20 Actual 284,358$ 63,669$ 206,032$ 2,479$
2/29/19 Actual 285,914$ 63,548$ 186,078$ 46,577$
% Change From Last Year -0.5%0.2%10.7%-94.7%
Five Year Trend
Expenditures by Department
2/29/19 2/29/20 2/29/20 2/29/20 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 18,497$ 16,465$ 32,695$ 50.4%176,490$ (2,032)$
Public Works 481,288 468,582 1,737,190 27.0%4,390,810 (12,706)
Engineering & Capital Projects 82,332 71,491 152,290 46.9%9,152,415 (10,841)
Total Expenditures 582,117$ 556,538$ 1,922,175$ 29.0%13,719,715$ (25,579)$
Five Year Trend
Village of Oak Brook
Infrastructure Fund - Major Sources Five Year Trend
For the Period Ending February 29, 2020
Revenues Expenditures
2/29/20 2/29/20
2/29/19 2/29/20 YTD % of YTD 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax -$ -$ -$ 0.0%95,000$ -$
Real Estate Tax - - - 0.0%380,000 -
Interest 339 270 250 108.0%1,500 (69)
Total Operating Revenues 339$ 270$ 250$ 108.0%476,500$ (69)$
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,791)$ (265,185)$ (265,205)$ (32,290)$ (34,394)$
Note - Expenditures are recorded in program 283.
Village of Oak Brook
Promenade TIF Fund Financial Update
For the Period Ending February 29, 2020
Total Total
Revenues Expenditures
2/29/20 Actual $ 270 265,455$
2/29/19 Actual $ 339 231,130$
% Change From Last Year -20.4%14.9%
Major Revenues Real Estate
Sales Tax Tax Interest
2/29/20 Actual $ - $ - $ 270
2/29/19 Actual $ - $ - $ 339
% Change From Last Year 0.0%0.0%-20.4%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures
2/29/20 Actual -$ 265,455$
2/29/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 February 29, 2020
Five Year Trend
Revenues Expenditures
2/29/20 2/29/20
2/29/19 2/29/20 YTD % of YTD 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Plan Review Fees 300$ -$ 200$ 0.0%1,200$ (300)$
Building/Inspection Fees 1,688 4,762 1,330 358.0%8,000 3,074
Water Sales 1,220,530 1,309,072 1,297,000 100.9%10,302,525 88,542
Unmetered Sales 4,635 2,400 5,000 48.0%30,000 (2,235)
Water Connection Fees 5,980 1,160 16,670 7.0%100,000 (4,820)
Meter Charges 2,265 330 3,350 9.9%20,000 (1,935)
Special Services - 763 - N/A 30,000 763
Interest on Investments 26,855 22,731 21,670 104.9%130,000 (4,124)
Miscellaneous 8,097 9,835 12,500 78.7%75,000 1,738
Total Operating Revenues 1,270,350$ 1,351,053$ 1,357,720$ 99.5%10,696,725$ 80,703$
OPERATING EXPENDITURES
Personnel 141,422$ 155,871$ 158,940$ 98.1%868,705$ 14,449$
Materials and Supplies 7,397 396 13,675 2.9%74,260 (7,001)
Operation and Contract 398,848 361,077 980,780 36.8%5,833,755 (37,771)
Capital Outlay 61,160 460,630 103,340 445.7%6,293,225 399,470
Total Expenditures 608,827$ 977,974$ 1,256,735$ 77.8%13,069,945$ 369,147$
Surplus (Deficit) of Revenues Over
Expenditures 661,523$ 373,079$ 100,985$ 369.4%(2,373,220)$ (288,444)$
INTERFUND TRANSACTIONS
Transfers In 221,085$ -$ -$ 0.0%-$ (221,085)
Reimbursements To Other Funds (91,972) (87,802) (87,800) 100.0%(526,815) 4,170
Total Interfund Transactions 129,113$ (87,802)$ (87,800)$ 100.0%(526,815)$ (216,915)$
Fund Increase/(Decrease) - Budgetary Basis 790,636$ 285,277$ 13,185$ 2163.6%(2,900,035)$ (505,359)$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay 61,160$ 460,630$
Depreciation Expense (85,351) (95,833)
IMRF Pension Expense 12,873 8,333
OPEB Expense (8,171) (7,500)
Total GAAP Adjustments (19,489)$ 365,630$
Fund Increase/(Decrease) - GAAP Basis 771,147$ 650,907$
*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 February 29, 2020
Total Total
Revenues Expenditures
2/29/20 Actual $ 1,351,053 977,974$
2/29/19 Actual $ 1,270,350 608,827$
% Change From Last Year 6.4%60.6%
Unmetered Water
Water Sales Sales Connection Fees Meter Charges Miscellaneous
2/29/20 Actual $ 1,309,072 $ 2,400 $ 1,160 $ 330 $ 9,835
2/29/19 Actual $ 1,220,530 $ 4,635 $ 5,980 $ 2,265 $ 8,097
% Change From Last Year 7.3%-48.2%-80.6%-85.4%21.5%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
2/29/20 Actual 155,871$ 396$ 361,077$ -$ 460,630$
2/29/19 Actual 141,422$ 7,397$ 398,848$ -$ 61,160$
% Change From Last Year 10.2%-94.6%-9.5%0.0%653.2%
Five Year Trend
Expenditures by Department
2/29/19 2/29/20 2/29/20 2/29/20 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Public Works 550,685$ 517,441$ 1,111,805$ 46.5%6,527,120$ (33,244)$
Engineering & Capital Projects 58,142 460,533 144,930 317.8%6,542,825 402,391
Total Expenditures 608,827$ 977,974$ 1,256,735$ 77.8%13,069,945$ 369,147$
Five Year Trend
Village of Oak Brook
Water Fund - Major Sources Five Year Trend
For the Period Ending February 29, 2020
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Sports Core Fund Consolidated Presentation
For the Period Ending February 29, 2020
2/29/20 2/29/20
2/29/20 YTD % of YTD 2020 2/29/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$ -$ -$ -$ 199$ 6,500$ 3.1%459,135$ 5,000$ (4,801)$
Greens Fees - - - 807 807 - N/A 930,000 - 807
Pro Shop Sales - - - 8,326 8,326 10,500 79.3%207,000 10,363 (2,037)
Golf Lessons - - - - - - 0.0%40,000 - -
Driving Range Fees - - - - - 5,000 0.0%244,000 1,200 (1,200)
Rentals - 2,670 8,742 (17) 11,395 17,010 67.0%962,000 - 11,395
Programs/User Fees - - - - - - 0.0%66,300 3,100 (3,100)
Food Sales - - - - - - 0.0%180,500 - -
Beverage Sales - - - 33 33 - N/A 265,000 - 33
Taste of Oak Brook - - - - - - 0.0%120,000 - -
Grants - - - - - - 0.0%139,800 - -
Other Revenue (372) - - 140 (232) 40 -580.0%11,000 9,478 (9,710)
Total Operating Revenues (173)$ 2,670$ 8,742$ 9,289$ 20,528$ 39,050$ 52.6%3,624,735$ 29,141$ (8,613)$
OPERATING EXPENDITURES
Personnel 800$ -$ 21,556$ 120,296$ 142,652$ 172,675$ 82.6%1,578,100$ 154,716$ (12,064)$
Materials & Supplies 249 - 305 11,338 11,892 11,330 105.0%618,025 26,867 (14,975)
Operational & Contractual 18,666 711 2,450 41,211 63,038 321,560 19.6%1,055,095 297,537 (234,499)
Other - - - - - - 0.0%(83,150) - -
Capital - 6,976 - 121,368 128,344 70,000 183.3%1,921,545 60,379 67,965
Total Operating Expenditures 19,715$ 7,687$ 24,311$ 294,213$ 345,926$ 575,565$ 60.1%5,089,615$ 539,499$ (193,573)$
B&T Administration Overhead Allocation*11,953$ -$ (11,953)$ -$ -$ -$ 0.0%-$ -$ -$
Operating Revenues Over (Under) Expenditures (7,935)$ (5,017)$ (27,522)$ (284,924)$ (325,398)$ (536,515)$ 60.7%(1,464,880)$ (510,358)$ 184,960$
INTERFUND TRANSACTIONS
Interfund Loan**105,000$ -$ -$ -$ 105,000$ -$ N/A -$ 275,188$ (170,188)$
Transfer From General Fund - - - - - - 0.0%923,000 - -
Transfer From Hotel Tax Fund - - - - - - 0.0%35,000 - -
Transfer From Golf Surcharge Fund - - - 119,719 119,719 - N/A 400,000 59,887 59,832
Reimbursement From Infrastructure Fund 4,000 - - - 4,000 4,000 100.0%24,000 4,000 -
Reimbursement From Water Fund 1,334 - - - 1,334 1,330 100.3%8,000 1,334 -
Reimbursement To General Fund (4,704) - - (4,704) (9,408) (9,400) 100.1%(56,450) - (9,408)
Total Interfund Transactions 105,630$ -$ -$ 115,015$ 220,645$ (4,070)$ -5421.3%1,333,550$ 340,409$ (119,764)$
Total Revenues Over (Under) Expenditures - Budgetary Basis 97,695$ (5,017)$ (27,522)$ (169,909)$ (104,753)$ (540,585)$ (131,330)$ (169,949)$ 65,196$
ADUSTMENTS TO GAAP BASIS***
Remove Capital Outlay -$ 6,976$ -$ 121,368$ 128,344$ 60,379$
Depreciation Expense (24,984) (281) (5,833) (35,333) (66,431) (54,732)
IMRF Pension Expense (875) (42) (333) (1,975) (3,225) 15,462
OPEB Expense - - (867) (3,333) (4,200) (3,339)
Total GAAP Adjustments (25,859)$ 6,654$ (7,033)$ 80,726$ 54,488$ 17,770$
Fund Increase/(Decrease) - GAAP Basis 71,836$ 1,637$ (34,555)$ (89,183)$ (50,265)$ (152,179)$
*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
2/29/20 Actual $ 20,528 345,926$
2/29/19 Actual $ 29,141 539,499$
% Change From Last Year -29.6%-35.9%
Driving Program/
Memberships Greens Fees Range Fees Rentals User Fees
2/29/20 Actual $ 199 $ 807 $ - $ 11,395 $ -
2/29/19 Actual $ 5,000 $ - $ 1,200 $ - $ 3,100
% Change From Last Year -96.0%N/A -100.0%N/A -100.0%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
2/29/20 Actual 142,652$ 11,892$ 63,038$ -$ 128,344$
2/29/19 Actual 154,716$ 26,867$ 297,537$ -$ 60,379$
% Change From Last Year -7.8%-55.7%-78.8%0.0%112.6%
Five Year Trend
Revenues by Department 2/29/19 2/29/20 2/29/20 2/29/20 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Operations (872)$ (173)$ 40$ -432.5%506,735$ 699$
Open Field Operations 4,100 2,670 4,985 53.6%407,000 (430)
B&T Clubhouse Operations 9,055 8,742 10,000 87.4%300,000 (313)
Golf Club 16,858 9,289 24,025 38.7%2,411,000 (7,569)
Total Revenues 29,141$ 20,528$ 39,050$ 52.6%3,624,735$ (7,613)$
Expenditures by Department 2/29/19 2/29/20 2/29/20 % of YTD 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Operations 259,561$ 19,715$ 272,280$ 7.2%1,752,045$ (239,846)$
Open Field Operations 480$ 7,687$ 1,750$ 439.3%267,110$ 7,207$
B&T Clubhouse Operations 34,312 24,311 76,340 31.8%458,770 (10,001)
Golf Club 245,146 294,213 225,195 130.6%2,611,690 49,067
Total Expenditures 539,499$ 345,926$ 575,565$ 60.1%5,089,615$ (193,573)$
Five Year Trend
Village of Oak Brook
Sports Core Fund - Major Sources Five Year Trend
For the Period Ending February 29, 2020
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Club Recreation Operations
For the Period Ending February 29, 2020 2/29/20 2/29/20
822 2/29/20 YTD % of YTD 2020 2/29/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$ -$ N/A 241,635$ -$ 199$
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 (372) - - - (372) 40 -930.0%3,000 (872) 500
Total Operating Revenues (372)$ 199$ -$ -$ (173)$ 40$ -432.5%506,735$ (872)$ 699$
OPERATING EXPENDITURES
Personnel 133$ -$ -$ 667$ 800$ 8,565$ 9.3%163,580$ 4,799$ (3,999)$
Materials & Supplies 164 - 85 - 249 2,650 9.4%57,650 31 218
Operational & Contractual 18,534 - 48 84 18,666 261,065 7.1%418,270 254,731 (236,065)
Capital - - - - - - 0.0%1,112,545 - -
Total Operating Expenditures 18,831$ -$ 133$ 751$ 19,715$ 272,280$ 7.2%1,752,045$ 259,561$ (239,846)$
B&T Administration Overhead Allocation*23,907$ (8,606)$ (2,391)$ (957)$ 11,953$ 19,550$ 61.1%93,235$ 12,162$ (209)$
Operating Revenues Over (Under) Expenditures 4,704$ (8,407)$ (2,524)$ (1,708)$ (7,935)$ (252,690)$ 3.1%(1,152,075)$ (248,271)$ 240,336$
INTERFUND TRANSACTIONS
Interfund Loan**105,000$ -$ -$ -$ 105,000$ -$ N/A -$ 275,188$ (170,188)$
Transfer From General Fund - - - - - - 0.0%757,500 - -
Reimbursement From Infrastructure Fund 4,000 - - - 4,000 4,000 100.0%24,000 4,000 -
Reimbursement From Water Fund 1,334 - - - 1,334 1,330 100.3%8,000 1,334 -
Reimbursement To General Fund (4,704) - - - (4,704) (4,700) 100.1%(28,225) - (4,704)
Total Interfund Transactions 105,630$ -$ -$ -$ 105,630$ 630$ 16766.7%761,275$ 280,522$ (174,892)$
Total Revenues Over (Under) Expenditures - Budgetary Basis 110,334$ (8,407)$ (2,524)$ (1,708)$ 97,695$ (252,060)$ (390,800)$ 32,251$ 65,444$
ADUSTMENTS TO GAAP BASIS***
Remove Capital Outlay -$ -$ -$ -$ -$ -$
Depreciation Expense - (23,956) (833) (195) (24,984) (15,804)
IMRF Pension Expense (833) - - (42) (875) 1,017
Total GAAP Adjustments (833)$ (23,956)$ (833)$ (236)$ (25,859)$ (14,788)$
Fund Increase/(Decrease) - GAAP Basis 109,501$ (32,363)$ (3,357)$ (1,944)$ 71,836$ 17,464$
*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 February 29, 2020 2/29/20 2/29/20
2/29/20 YTD % of YTD 2020 2/29/19 Difference
815 816 YTD Amended Amended Adopted YTD Prior
Polo Open Fields Total Budget Budget Budget Total Year
OPERATING REVENUES
Field Rentals -$ 2,670$ 2,670$ 4,985$ 53.6%212,000$ 3,100$ (430)$
Range Rentals - - - - 0.0%75,000 - -
Taste of Oak Brook - - - - 0.0%120,000 1,000 -
Other Revenue - - - - 0.0%- - -
Total Operating Revenues -$ 2,670$ 2,670$ 4,985$ 53.6%407,000$ 4,100$ (430)$
OPERATING EXPENDITURES
Personnel -$ -$ -$ -$ 0.0%10,810$ -$ -$
Materials & Supplies - - - - 0.0%1,700 - -
Operational & Contractual - 711 711 1,750 40.6%239,600 480 231
Other - - - - 0.0%- - -
Capital - 6,976 6,976 - N/A 15,000 - 6,976
Total Operating Expenditures -$ 7,687$ 7,687$ 1,750$ 439.3%267,110$ 480$ 7,207$
Operating Revenues Over (Under) Expenditures -$ (5,017)$ (5,017)$ 3,235$ -155.1%139,890$ 3,620$ (7,637)$
INTERFUND TRANSACTIONS
Transfer From Hotel Tax Fund -$ -$ -$ -$ 0.0%35,000$ -$ -$
Total Interfund Transactions -$ -$ -$ -$ #DIV/0!35,000$ -$ -$
Total Revenues Over (Under) Expenditures - Budgetary Basis -$ (5,017)$ (5,017)$ 3,235$ 174,890$ 3,620$ (7,637)$
ADUSTMENTS TO GAAP BASIS***
Remove Capital Outlay -$ 6,976$ 6,976$ -$
Depreciation Expense - (281) (281) (281)
IMRF Pension Expense - (42) (42) 123
Total GAAP Adjustments -$ 6,654$ 6,654$ (158)$
Fund Increase/(Decrease) - GAAP Basis -$ 1,637$ 1,637$ 3,462$
*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 February 29, 2020
2/29/20 2/29/20
821 YTD % of YTD 2020 2/29/19 Difference
B&T Amended Amended Adopted YTD Prior
Clubhouse Budget Budget Budget Total Year
OPERATING REVENUES
Rentals 8,742$ 10,000$ 87.4%300,000$ 9,055$ (313)$
Total Operating Revenues 8,742$ 10,000$ 87.4%300,000$ 9,055$ (313)$
OPERATING EXPENDITURES
Personnel 21,556$ 22,080$ 97.6%140,045$ 21,631$ (75)$
Materials & Supplies 305 4,670 6.5%20,225 1,077 (772)
Operational & Contractual 2,450 25,590 9.6%109,500 3,822 (1,372)
Capital - 24,000 0.0%189,000 7,782 (7,782)
Total Operating Expenditures 24,311$ 76,340$ 31.8%458,770$ 34,312$ (10,001)$
B&T Administration Overhead Allocation*(11,953)$ (19,550)$ 61.1%(93,235)$ (12,162)$ 209$
Operating Revenues Over (Under) Expenditures (27,522)$ (85,890)$ 32.0%(252,005)$ (37,419)$ 9,897$
INTERFUND TRANSACTIONS
Transfer From General Fund -$ -$ 0.0%165,500$ -$ -$
Total Interfund Transactions -$ -$ 0.0%165,500$ -$ -$
Total Revenues Over (Under) Expenditures - Budgetary Basis (27,522)$ (85,890)$ (86,505)$ (37,419)$ 9,897$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay -$ 7,782$
Depreciation Expense (5,833) (5,359)
IMRF Pension Expense (333) 1,117
OPEB Expense (867) (350)
Total GAAP Adjustments (7,033)$ 3,190$
Fund Increase/(Decrease) - GAAP Basis (34,555)$ (34,229)$
*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 February 29, 2020
2/29/20 2/29/20
823 831 832 833 834 2/29/20 YTD % of YTD 2020 2/29/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 -$ -$ -$ -$ -$ -$ 6,500$ 0.0%217,500$ 5,000$ (5,000)$
Greens Fees - 807 - - - 807 - N/A 930,000 - 807
Pro Shop Sales - 8,326 - - - 8,326 10,500 79.3%207,000 10,363 (2,037)
Golf Lessons - - - - - - - 0.0%40,000 - -
Driving Range Fees - - - - - - 5,000 0.0%244,000 1,200 (1,200)
Rentals - - - (17) - (17) 2,025 -0.8%375,000 - (17)
Food Sales - - - - - - - 0.0%144,500 - -
Beverage Sales 33 - - - - 33 - N/A 245,000 - 33
Other Revenue - 140 - - - 140 - N/A 8,000 295 (155)
Total Operating Revenues 33$ 9,273$ -$ (17)$ -$ 9,289$ 24,025$ 38.7%2,411,000$ 16,858$ (7,569)$
OPERATING EXPENDITURES
Personnel 8,567$ 71,629$ -$ 622$ 39,478$ 120,296$ 142,030$ 84.7%1,263,665$ 128,286$ (7,990)$
Materials & Supplies 148 7,389 - 218 3,583 11,338 4,010 282.7%538,450 25,759 (14,421)
Operational & Contractual 322 35,293 - - 5,596 41,211 33,155 124.3%287,725 38,504 2,707
Other - - - - - - - 0.0%(83,150) - -
Capital - 121,368 - - - 121,368 46,000 263.8%605,000 52,597 68,771
Total Operating Expenditures 9,037$ 235,679$ -$ 840$ 48,657$ 294,213$ 225,195$ 130.6%2,611,690$ 245,146$ 49,067$
Operating Revenues Over (Under) Expenditures (9,004)$ (226,406)$ -$ (857)$ (48,657)$ (284,924)$ (201,170)$ 141.6%(200,690)$ (228,288)$ (56,636)$
INTERFUND TRANSACTIONS
Transfer from Golf Surcharge -$ 119,719$ -$ -$ -$ 119,719$ 0.0%400,000$ 59,887$ 59,832$
Reimbursement to General Fund - (4,704) - - - (4,704) (4,700) 100.1%(28,225) - (4,704)
Total Interfund Transactions -$ 115,015$ -$ -$ -$ 115,015$ (4,700)$ -2447.1%371,775$ 59,887$ 55,128$
Total Revenues Over (Under) Expenditures - Budgetary Basis (9,004)$ (111,391)$ -$ (857)$ (48,657)$ (169,909)$ (205,870)$ 171,085$ (168,401)$ (1,508)$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay -$ 121,368$ -$ -$ -$ 121,368$ 52,597$
Depreciation Expense - (22,500) (667) (3,833) (8,333) (35,333) (33,288)
IMRF Pension Expense (250) (833) (58) - (833) (1,975) 13,206
OPEB Expense (250) (1,917) - - (1,167) (3,333) (2,989)
Total GAAP Adjustments (500)$ 96,118$ (725)$ (3,833)$ (10,333)$ 80,726$ 29,526$
Fund Increase/(Decrease) - GAAP Basis (9,504)$ (15,273)$ (725)$ (4,690)$ (58,990)$ (89,183)$ (138,875)$
*Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.