01 - January 2020 Monthly Financial ReportVILLAGE
OAK BROOK
OF
MONTHLY FINANCIAL REPORTS
JANUARY 2020
Total
Cash and Cash Pooled Cash and
Fund Equivalents Investments Investments % By Fund
General Corporate $5,511,030 $14,926,033 $20,437,063 47.3%
Hotel/Motel Tax 2,582,106 2,477,383 5,059,489 11.7%
Motor Fuel Tax 993,990 82,388 1,076,378 2.5%
Infrastructure 6,028,082 1,978,322 8,006,404 18.5%
Promenade TIF 38,957 - 38,957 0.1%
Water 3,290,390 3,518,188 6,808,578 15.8%
Sports Core 105,151 - 105,151 0.2%
Golf Surcharge 159,413 188,090 347,503 0.8%
Self-Insurance 229,831 - 229,831 0.5%
Garage 286,568 - 286,568 0.7%
Equipment Replacement 436,546 381,437 817,983 1.9%
Total $19,662,064 $23,551,841 $43,213,905 100.0%
Change in Cash and Investments by Fund :
Balance at Balance at Year-to-Date Year-to-Date
Fund January 1, 2020 January 31, 2020 Change ($)Change (%)
General Corporate $21,270,239 $20,437,063 ($833,176)-3.9%
Hotel/Motel Tax 5,427,474 5,059,489 (367,985)-6.8%
Motor Fuel Tax 1,085,595 1,076,378 (9,217)-0.8%
Infrastructure 8,217,724 8,006,404 (211,320)-2.6%
Promenade TIF 304,194 38,957 (265,237)-87.2%
Water 6,947,239 6,808,578 (138,661)-2.0%
Sports Core 231,216 105,151 (126,065)-54.5%
Golf Surcharge 347,066 347,503 437 0.1%
Self-Insurance 308,820 229,831 (78,989)-25.6%
Garage 275,988 286,568 10,580 3.8%
Equipment Replacement 808,879 817,983 9,104 1.1%
$45,224,434 $43,213,905 ($2,010,529)-4.4%
Book Bank/Market
Value Value
Pooled Checking $204,505 $1,501,610
Sports Core Checking 264,855 263,108
Pooled IPTIP 18,917,997 18,917,997
Water E-Pay IPTIP 274,707 260,874
$19,662,064 $20,943,589
Pooled Investments:
Investments-Municipal Bonds $5,951,374 $5,973,779
Investments-Corporate Bonds 8,305,622 8,384,698
Government & Agency Obligations 2,710,088 2,692,666
Certificates of Deposit 6,485,000 6,514,301
Accrued Interest 99,757 99,757
Total Pooled Investments $23,551,841 $23,665,201
Total Cash and Investments $43,213,905 $44,608,790
For January, total interest revenue is $74,784. The total investment yield for the portfolio is:
Pooled
Investments Illinois Funds Total
Last 12 months yield 2.33%2.24%2.28%
The weighted average yield of the current pooled investment portfolio is 2.32%. The IL Funds December average daily rate was 1.685%.
Monthly Treasurer's Report
January 31, 2020
Monthly Treasurer's Report
January 2020
The table below lists the detail investment holdings at J.P. Morgan Securities as of 1/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,847 201,674 1,160
Florida Hurricane #34074GDH4 03/30/16 07/01/20 2.995%2.150%501,657 502,535 1,248
Bloomingdale Mich Pub Sch Dist #094383FS0 04/26/16 05/01/22 2.710%2.150%506,079 509,680 3,349
Milan Mich Area Achs #598801JD1 05/26/16 05/01/20 1.931%1.931%245,000 245,137 1,082
Lanse Creuse Mich Pub Schs #516228RL9 05/02/17 05/01/20 2.159%2.159%100,000 100,103 537
Connecticut St GO Bds 2016 #20772J3F7 06/15/17 08/15/21 1.750%2.300%495,874 501,195 3,982
Fowlerville Mich Comnty Schs #351280MS8 10/03/17 05/01/20 2.045%1.750%500,371 500,305 2,386
Wisconsin St Gen Fd Annual #977100CW4 01/05/18 05/01/20 1.446%2.100%599,011 599,706 2,073
Wright County Min #982276BC0 07/18/19 12/01/20 2.000%2.000%545,000 546,085 2,331
State of IL #452152P54 10/09/19 11/01/21 5.000%1.870%526,946 529,430 5,999
Anchor Bay Mich Sch #032879TE8 11/01/19 05/01/21 2.320%1.750%720,045 720,019 4,009
Brownsville TX #16405ST9 12/19/19 02/15/22 2.050%2.000%555,544 557,819 1,169
Laredo TX Waterworks #517039VW0 12/19/19 03/01/24 2.230%2.230%455,000 460,091 1,127
Total Municipal Bonds $5,951,374 $5,973,779 $30,452
Corporate Bonds:
Goldman Sachs #38141GVP9 09/26/18 09/15/20 2.750%3.180%498,697 502,370 5,155
Wells Fargo #94974BGR5 01/15/19 12/07/20 2.550%3.120%1,383,488 1,398,632 5,612
PNC Bank #69353RFH6 01/30/19 01/22/21 2.500%3.020%497,531 503,640 313
Morgan Stanley #61747WAL3 03/08/19 07/28/21 5.500%3.034%1,087,367 1,107,792 321
Citigroup #172967LC3 04/01/19 12/08/21 2.900%2.754%1,002,614 1,018,480 3,706
Bank of America #06051GFT1 04/03/19 10/19/20 2.625%2.625%700,000 704,277 4,951
Goldman Sachs #38143U8F1 05/02/19 02/25/21 2.875%2.707%365,630 368,869 4,520
American Honda #02665WBG5 07/31/19 09/09/21 1.700%2.180%496,243 500,415 3,376
BB&T Corp #05531FAZ6 08/15/19 02/01/21 2.150%2.010%751,040 752,648 7,866
JP Morgan #48128BAB7 09/30/19 01/15/23 2.972%2.337%1,018,017 1,022,880 1,321
JP Morgan #46625HRT9 01/30/20 06/07/21 2.400%1.648%504,995 504,695 1,800
Total Corporate Bonds $8,305,622 $8,384,698 $38,941
Government & Agency Obligations:
*Government National Mtg Assn #38379UEM4 02/29/16 02/16/51 2.300%2.245%$664,152 $651,808 $2,352
*Government National Mtg Assn #38381WV96 08/06/19 07/20/54 2.250%2.293%904,983 907,615 1,654
*Government National Mtg Assn #38380BNV3 12/05/19 06/20/46 2.000%2.112%650,953 643,846 1,069
Fed Farm Credit Bank #3133EK5Y8 11/14/19 02/14/22 1.770%1.770%490,000 489,397 2,168
Total Government & Agency Obligations:$2,710,088 $2,692,666 $7,243
Certificates of Deposit:
State Bk India NY #8562846A7 01/26/17 01/26/22 2.250%2.250%$245,000 $247,604 $76
American Express Centurion #02587DV96 08/15/17 08/17/20 1.900%1.900%245,000 245,380 2,134
Sallie Mae #795450C86 08/16/17 08/17/20 1.900%1.900%245,000 245,377 2,134
Merrick Bank South Jordan #59013JZS1 08/21/17 08/21/20 1.800%1.800%245,000 245,252 111
Pinnacle Bank #72345SFS5 08/30/17 08/31/20 1.800%1.800%115,000 115,122 -
Jackson County Bank #466682AP6 08/31/17 03/01/21 1.850%1.850%245,000 245,554 1,889
Barclays Bank #06740KKX4 09/27/17 09/28/20 1.950%1.950%245,000 245,524 1,632
Goldman Sachs Bank #38148PRK5 10/18/17 10/19/20 1.950%1.950%245,000 245,566 1,354
FirstBank PR Santurce #33767A6M8 11/03/17 11/03/20 2.000%2.000%245,000 245,688 352
Morgan Stanley #61747MQ53 03/22/18 03/23/20 2.550%2.550%245,000 245,368 2,096
Investors Community Bank #46147UTT7 08/28/18 02/28/20 2.550%2.550%245,000 245,203 19
Lakeside Bank #51210SPS0 08/30/18 03/30/20 2.550%2.550%245,000 245,426 2
Bank United #066519GJ2 08/31/18 02/20/20 2.500%2.500%245,000 245,191 2,552
Compass Bank #20451PVW3 10/26/18 10/26/20 3.000%3.000%245,000 247,460 1,919
UBS Bank #90348JFH8 10/30/18 10/29/20 3.050%3.050%245,000 247,599 5
Discover Bank #254673WF9 11/07/18 11/09/20 3.000%3.000%245,000 247,577 1,695
Ally Bank #02007GFX6 11/08/18 11/09/20 3.000%3.000%245,000 247,577 1,674
Comenity Cap Bank #20033AU46 04/15/19 04/15/21 2.500%2.500%245,000 247,499 234
Morgan Stanley #61760AE21 05/30/19 06/01/21 2.400%2.400%245,000 247,399 956
First St Bank DeQueen #336460CU2 07/18/19 07/19/21 2.000%2.000%245,000 246,186 184
Bank Hapoalim #06251AW89 07/19/19 07/19/21 2.000%2.000%245,000 246,539 61
Capital One Natl Assn #14042RMF5 07/24/19 07/26/19 2.050%2.050%245,000 246,374 189
TIAA FSB Jacksonville #87270LCN1 07/29/19 07/29/21 2.000%2.000%245,000 246,198 21
Wells Fargo #949763J31 09/18/19 09/20/21 1.850%1.850%245,000 245,676 185
BMW Bank #05580ASQ8 10/11/19 10/12/21 1.800%1.800%245,000 245,475 1,286
Metabank #59101LHW0 11/20/19 08/19/21 1.750%1.750%245,000 245,029 177
Wells Fargo #949495AN5 01/17/20 01/18/22 1.800%1.800%245,000 245,458 184
Total Certificates of Deposits $6,485,000 $6,514,301 $23,121
Total J.P.Morgan Securities $23,452,084 $23,565,444 $99,757
*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
January 31, 2020
Cash & Investments by Fund - Total $43.2 million
Cash & Investments by Type - Total $43.2 million
Checking
Illinois Funds
Certificates of Deposit
Municipal Bonds
Corporate Bonds
Government & Agency Obligations
Accrued Interest
General Corporate
47.29%
Hotel/Motel Tax
11.71%Motor Fuel Tax
2.49%
Infrastructure
18.53%
Promenade TIF
0.09%
Water
15.76%
Sports Core
0.24%
Golf Surcharge
0.80%
Self-Insurance
0.53%Garage
0.66%
Equipment
Replacement
1.89%
Checking, $0.5
Illinois Funds, $19.2
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)2,023,575 $2,694,581 ($671,006)($485,625)
Main operating fund of the Village.
Hotel Fund (Major Fund)$70,439 $196,283 ($125,844)$19,275
Collects and spends resources from the
3% hotel/motel tax.
Motor Fuel Tax Fund $36,158 $0 $36,158 $27,415
Collects and spends resources from the
State motor fuel tax.
Infrastructure Fund (Major Fund)$497,873 $318,046 $179,827 ($385,145)
Accounts for construction and maintenance of
roadways, drainage, and safety path systems.
Promenade TIF Fund (Major Fund)$218 $265,455 ($265,237)($265,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)$964,695 $182,112 $782,583 $234,875
Collects user fees for the distribution of water
and maintenance of infrastructure.
Sports Core Fund (Major Fund)$12,532 $156,615 ($144,083)($381,080)
Accounts for revenues and expenses relating
to administration, programs, food and beverage
operations, and golf course.
Golf Surcharge Fund $438 $0 $438 $210
Accounts for the collection of the $3 per round
golf surcharge.
Internal Service Funds
Self Insurance Fund $288,789 $74,823 $213,966 ($3,500)
Accounts for the Village's health insurance costs
and the related contributions from the Village,
employees, retirees, and other agencies.
Garage Fund $61,419 $64,324 ($2,905)($9,125)
Accounts for the maintenance of the Village's vehicle
fleet and the related departmental reimbursements.
Equipment Replacement Fund $27,900 $18,797 $9,103 $9,500
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 January 31, 2020
Village of Oak Brook
Monthly Financial Report – Fund Narrative
For the Period Ending January 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
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 January 2020 are $140,456, or 6.7%, lower than last January and
$117,704, or 5.6%, under budget to date. The main drivers for this are:
o Sales tax revenue, the General
Fund’s largest revenue source, is
down $47,182 from last year and
$33,438 under budget. Despite
January 2020 collections being
under 2019 collections,
collections over the past five
years have been relatively
consistent.
o Licenses and permits revenue is
down $77,463 from last year and
$83,085 under budget. This is due to the timing of receipts as the Village received two
larger building permits early in 2019. Permit revenue is still expected to be strong in
2020 with the Hines Oak Brook Commons project kicking off.
Total expenditures through January 2020 are $106,534, or 4.1%, higher than last year and
$67,674, or 2.6%, over budget to date. The main drivers for this are:
o Personnel expenditures are up $193,256 from last year and $75,760 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 $54,050 from last year, but $23,120 over
budget. This is due to the general timing of payments compared to when they were
projected to occur.
Hotel Tax Fund
Total revenues through January 2020 are $26,877, or 27.6%, lower than last year and $3,111, or
4.2%, under budget. The main drivers for this are:
o Hotel tax revenue is down $25,971 from last year and $5,538 under budget. The
decrease is due to the timing of receipts being received vs. when projected.
Total expenditures through January 2020 are $190,057 higher than last year and $142,007, or
295.5%, over budget. The main drivers for this are:
o Operation and contract expenditures are up $111,995 from last year and $63,945 over
budget. Payments early in 2020 relate to Q4 2019 marketing and will be adjusted
during the annual audit.
o Capital Outlay expenditures are up $78,062 from last year and $78,062 over budget.
The street light replacements happened earlier than originally projected.
Infrastructure Fund
Total revenues through January 2020 are down $21,581, or 4.4%, from last year and $4,535, or
1.0%, under budget. The main drivers for this are:
o Non-home rule sales tax revenue
is down $15,017 from last year
and $6,403 under budget.
Despite January 2020 collections
being under 2019 collections,
collections over the past five
years have been relatively
consistent.
Total expenditures through January 2020
are up $53,771, or 21.4%, from last year,
but $569,509, or 65.2%, under budget to
date. The main drivers for this are:
o Materials and Supplies expenditures are up $37,088 from last year and $23,993 over
budget. The increase is due to additional salt purchases in 2020.
o Operation and contract expenditures are up $11,859 from last year, but $89,069 under
budget. Expenditures are under budget due to the timing of engineering payments.
o Capital Outlay expenditures have not happened to date in 2020. January 2020 capital
outlay payments were originally projected to be $500,000, but have not occurred.
Promenade TIF Fund
Total revenues through January 2020 are down $71, or 24.6%, from last year, but $93, or 74.4%,
over budget. Interest rates have dropped slightly since January 2019.
Total expenditures through January 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 January 2020 are up $36,983, or 4.0%, from last year, but $14,675, or
1.5%, under budget. The main drivers for this are:
o Water sales revenue is up $43,350 from last year, but $2,610 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 less than projected so far this year.
Total expenditures through January 2020 are up $11,031, or 8.7%, from last year, but $562,384,
or 80.3%, under budget. The main drivers for this are:
o Operation and contract expenditures are up $1,399 from last year, but $458,341 under
budget. Expenditures are under budget due to the timing of invoices paid and DuPage
Water Commission water purchased being less than expected.
o Capital outlay expenditures are down $2,980 from last year and $101,463 under budget.
Capital projects will occur later in 2020 as planned.
Sports Core Fund
Total revenues through January 2020 are up $1,423, or 16.9%, from last year, but $140, or 1.4%,
under budget to date. In January, only miscellaneous revenue sources have been collected and
recorded. Memberships and user fees are expected to begin in February or March.
Total expenditures through January 2020 are down $219,340, or 59.1%, from last year and
$237,139, or 61.0%, under budget to date. The main drivers for this are:
o Operation and Contractual expenditures are down $236,711 from last year and
$242,757 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.
1/31/20 1/31/20
1/31/19 1/31/20 YTD % of 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 1,054,244$ 1,007,062$ 1,040,500$ 96.8%12,502,000$ (47,182)$
Other Intergovernmental Tax 116,478 149,460 116,500 128.3%1,352,000 32,982
Telecommunications/Utility Tax 526,992 512,445 521,000 98.4%6,125,000 (14,547)
Licenses and Permits 225,763 148,300 231,385 64.1%2,990,190 (77,463)
Charges for Services 98,229 77,100 95,995 80.3%1,253,100 (21,129)
Fines and Penalties 24,273 20,307 16,000 126.9%192,000 (3,966)
Administrative Towing Fees 4,500 3,637 1,665 218.4%20,000 (863)
Interest on Investments 35,615 37,724 34,585 109.1%415,000 2,109
Franchise/IMF Maint. Fee 5,462 - - 0.0%210,000 (5,462)
Miscellaneous Income 20,276 15,341 31,450 48.8%443,095 (4,935)
Total Operating Revenues 2,111,832$ 1,971,376$ 2,089,080$ 94.4%25,502,385$ (140,456)$
OPERATING EXPENDITURES
Personnel 1,955,474$ 2,148,730$ 2,072,970$ 103.7%19,160,220$ 193,256$
Materials and Supplies 33,617 28,293 43,150 65.6%539,170 (5,324)
Operation and Contract 557,055 503,005 479,885 104.8%4,071,660 (54,050)
Other Expenditures 2,200 2,200 770 285.7%10,000 -
Capital Outlay 28,054 706 18,485 3.8%688,030 (27,348)
Total Operating Expenditures 2,576,400$ 2,682,934$ 2,615,260$ 102.6%24,469,080$ 106,534$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES (464,568)$ (711,558)$ (526,180)$ 1,033,305$ (246,990)$
INTERFUND TRANSACTIONS
Transfers In 508,235$ -$ -$ 0.0%-$ (508,235)$
Transfers Out - - - 0.0%(923,000) -
Reimbursements From Other Funds 52,684 52,199 52,200 100.0%626,395 (485)
Reimbursements To Other Funds (10,925) (11,647) (11,645) 100.0%(139,770) (722)
Sports Core Loan (180,000) - - 0.0%- 180,000
Total Interfund Transactions 369,994$ 40,552$ 40,555$ 100.0%(436,375)$ (329,442)$
NET FUND INCREASE (DECREASE)(94,574)$ (671,006)$ (485,625)$ 596,930$ (576,432)$
Village of Oak Brook
General Fund Financial Update
For the Period Ending January 31, 2020
Total Total
Revenues Expenditures
1/31/20 Actual 1,971,376$ 2,682,934$
1/31/19 Actual 2,111,832$ 2,576,400$
% Change From Last Year -6.7%4.1%
Major Revenues
Other Telecom/Utility Licenses &Charges for
Sales Tax Intergov. Tax Tax Permits Services
1/31/20 Actual 1,007,062$ 149,460$ 512,445$ 148,300$ 77,100$
1/31/19 Actual $ 1,054,244 $ 116,478 $ 526,992 $ 225,763 $ 98,229
% Change From Last Year -4.5%28.3%-2.8%-34.3%-21.5%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
1/31/20 Actual 2,148,730$ 28,293$ 503,005$ 2,200$ 706$
1/31/19 Actual 1,955,474$ 33,617$ 557,055$ 2,200$ 28,054$
% Change From Last Year 9.9%-15.8%-9.7%0.0%-97.5%
Five Year Trend
Expenditures by Department
1/31/19 1/31/20 1/31/20 1/31/20 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Department Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 288,447$ 261,775$ 347,375$ 75.4%2,556,835$ (26,672)$
Financial Services 76,823 75,632 77,960 97.0%781,455 (1,191)
Public Works 40,820 56,732 55,515 102.2%893,055 15,912
Engineering & Capital Projects 26,704 706 10,150 7.0%411,500 (25,998)
Library 104,530 115,137 113,840 101.1%994,410 10,607
Police 1,001,038 1,121,574 1,067,195 105.1%9,493,905 120,536
Fire 935,492 965,130 837,305 115.3%8,298,370 29,638
Development Services 102,546 86,248 105,920 81.4%1,039,550 (16,298)
Total Expenditures 2,576,400$ 2,682,934$ 2,615,260$ 102.6%24,469,080$ 106,534$
Five Year Trend
For the Period Ending January 31, 2020
General Fund - Five Year Trend
Village of Oak Brook
Revenues Expenditures
1/31/20 1/31/20
1/31/19 1/31/20 YTD % of 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Hotel Tax 87,733$ 61,762$ 67,300$ 91.8%1,212,500$ (25,971)$
Interest 9,583 8,677 6,250 138.8%75,000 (906)
Total Operating Revenues 97,316$ 70,439$ 73,550$ 95.8%1,287,500$ (26,877)$
EXPENDITURES
Operation and Contract -$ 111,995$ 48,050$ 233.1%576,615$ 111,995$
Capital Outlay - 78,062 - N/A 640,395 78,062
Total Expenditures -$ 190,057$ 48,050$ 395.5%1,217,010$ 190,057$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 97,316$ (119,618)$ 25,500$ -469.1%70,490$ (216,934)$
INTERFUND TRANSACTIONS
Transfer Out -$ -$ -$ 0.0%(338,125)$ -$
Reimbursements to Other Funds (8,593) (6,226) (6,225) 100.0%(74,715) 2,367
Total Interfund Transactions (8,593)$ (6,226)$ (6,225)$ 100.0%(412,840)$ 2,367$
NET FUND INCREASE (DECREASE)88,723$ (125,844)$ 19,275$ (342,350)$ (214,567)$
Note - Expenditures are recorded in program 171.
Village of Oak Brook
Hotel Tax Fund Financial Update
For the Period Ending January 31, 2020
Total Total
Revenues Expenditures
1/31/20 Actual $ 70,439 190,057$
1/31/19 Actual $ 97,316 -$
% Change From Last Year -27.6%N/A
Major Revenues
Hotel Tax Interest Miscellaneous
1/31/20 Actual $ 61,762 $ 8,677 $ -
1/31/19 Actual $ 87,733 $ 9,583 $ -
% Change From Last Year -29.6%-9.5%0.0%
Five Year Trend
Major Expenditures Operation &
Contractual Capital Outlay
1/31/20 Actual 111,995$ 78,062$
1/31/19 Actual -$ -$
% Change From Last Year N/A N/A
Five Year Trend
Village of Oak Brook
Hotel Tax Fund - Major Sources Five Year Trend
For the Period Ending January 31, 2020
Five Year Trend
Revenues Expenditures
1/31/20 1/31/20
1/31/19 1/31/20 YTD % of 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 470,364$ 455,347$ 461,750$ 98.6%5,615,000$ (15,017)$
Charges for Services - - 85 0.0%1,000 -
Interest 19,142 12,427 10,415 119.3%125,000 (6,715)
Miscellaneous - 151 210 71.9%2,500 151
Total Operating Revenues 489,506$ 467,925$ 472,460$ 99.0%5,743,500$ (21,581)$
OPERATING EXPENDITURES
Personnel 159,868$ 164,692$ 169,125$ 97.4%1,389,540$ 4,824$
Materials and Supplies 1,765 38,853 14,860 261.5%253,295 37,088
Operation and Contract 89,117 100,976 190,045 53.1%1,856,790 11,859
Capital Outlay - - 500,000 0.0%10,220,090 -
Total Operating Expenditures 250,750$ 304,521$ 874,030$ 34.8%13,719,715$ 53,771$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 238,756$ 163,404$ (401,570)$ -40.7%(7,976,215)$ (75,352)$
INTERFUND TRANSACTIONS
Transfers In 216,125$ -$ -$ 0.0%1,653,125$ (216,125)$
Reimbursements From Other Funds 27,787 29,948 29,950 100.0%359,380 2,161
Reimbursements To Other Funds (13,461) (13,525) (13,525) 100.0%(162,300) (64)
Total Interfund Transactions 230,451$ 16,423$ 16,425$ 100.0%1,850,205$ (214,028)$
NET FUND INCREASE (DECREASE)469,207$ 179,827$ (385,145)$ (6,126,010)$ (289,380)$
Village of Oak Brook
Infrastructure Fund Financial Update
For the Period Ending January 31, 2020
Total Total
Revenues Expenditures
1/31/20 Actual $ 467,925 304,521$
1/31/19 Actual $ 489,506 250,750$
% Change From Last Year -4.4%21.4%
Major Revenues
Sales Tax
Charges for
Services Interest Miscellaneous Reimbursements
1/31/20 Actual $ 455,347 $ - $ 12,427 $ 151 $ 29,948
1/31/19 Actual $ 470,364 $ - $ 19,142 $ - $ 27,787
% Change From Last Year -3.2%0.0%-35.1%N/A 7.8%
Five Year Trend
Major Expenditures Materials &Operation &
Personnel Supplies Contractual Capital Outlay
1/31/20 Actual 164,692$ 38,853$ 100,976$ -$
1/31/19 Actual 159,868$ 1,765$ 89,117$ -$
% Change From Last Year 3.0%2101.3%13.3%0.0%
Five Year Trend
Expenditures by Department
1/31/19 1/31/20 1/31/20 1/31/20 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 2,080$ 4,557$ 14,190$ 32.1%176,490$ 2,477$
Public Works 237,350 288,868 781,980 36.9%4,390,810 51,518
Engineering & Capital Projects 11,320 11,096 77,860 14.3%9,152,415 (224)
Total Expenditures 250,750$ 304,521$ 874,030$ 34.8%13,719,715$ 53,771$
Five Year Trend
Village of Oak Brook
Infrastructure Fund - Major Sources Five Year Trend
For the Period Ending January 31, 2020
Revenues Expenditures
1/31/20 1/31/20
1/31/19 1/31/20 YTD % of 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 289 218 125 174.4%1,500 (71)
Total Operating Revenues 289$ 218$ 125$ 174.4%476,500$ (71)$
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,841)$ (265,237)$ (265,330)$ (32,290)$ (34,396)$
Note - Expenditures are recorded in program 283.
Village of Oak Brook
Promenade TIF Fund Financial Update
For the Period Ending January 31, 2020
Total Total
Revenues Expenditures
1/31/20 Actual $ 218 265,455$
1/31/19 Actual $ 289 231,130$
% Change From Last Year -24.6%14.9%
Major Revenues Real Estate
Sales Tax Tax Interest
1/31/20 Actual $ - $ - $ 218
1/31/19 Actual $ - $ - $ 289
% Change From Last Year 0.0%0.0%-24.6%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures
1/31/20 Actual -$ 265,455$
1/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 January 31, 2020
Five Year Trend
Revenues Expenditures
1/31/20 1/31/20
1/31/19 1/31/20 YTD % of 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Plan Review Fees 225$ -$ 100$ 0.0%1,200$ (225)$
Building/Inspection Fees 1,613 4,762 665 716.1%8,000 3,149
Water Sales 903,040 946,390 949,000 99.7%10,302,525 43,350
Unmetered Sales 4,335 - 2,500 0.0%30,000 (4,335)
Water Connection Fees 3,220 - 8,335 0.0%100,000 (3,220)
Meter Charges 1,935 - 1,685 0.0%20,000 (1,935)
Special Services - 763 - N/A 30,000 763
Interest on Investments 13,124 11,782 10,835 108.7%130,000 (1,342)
Miscellaneous 220 998 6,250 16.0%75,000 778
Total Operating Revenues 927,712$ 964,695$ 979,370$ 98.5%10,696,725$ 36,983$
OPERATING EXPENDITURES
Personnel 81,784$ 96,013$ 93,450$ 102.7%868,705$ 14,229$
Materials and Supplies 1,859 242 5,385 4.5%74,260 (1,617)
Operation and Contract 40,345 41,744 500,085 8.3%5,833,755 1,399
Capital Outlay 3,192 212 101,675 0.2%6,293,225 (2,980)
Total Expenditures 127,180$ 138,211$ 700,595$ 19.7%13,069,945$ 11,031$
Surplus (Deficit) of Revenues Over
Expenditures 800,532$ 826,484$ 278,775$ 296.5%(2,373,220)$ 25,952$
INTERFUND TRANSACTIONS
Transfers In 221,085$ -$ -$ 0.0%-$ (221,085)
Reimbursements To Other Funds (45,986) (43,901) (43,900) 100.0%(526,815) 2,085
Total Interfund Transactions 175,099$ (43,901)$ (43,900)$ 100.0%(526,815)$ (219,000)$
Fund Increase/(Decrease) - Budgetary Basis 975,631$ 782,583$ 234,875$ 333.2%(2,900,035)$ (193,048)$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay 3,192$ 212$
Depreciation Expense (45,833) (47,917)
IMRF Pension Expense 6,436 4,167
OPEB Expense 833 833
Total GAAP Adjustments (35,372)$ (42,705)$
Fund Increase/(Decrease) - GAAP Basis 940,259$ 739,878$
*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 January 31, 2020
Total Total
Revenues Expenditures
1/31/20 Actual $ 964,695 138,211$
1/31/19 Actual $ 927,712 127,180$
% Change From Last Year 4.0%8.7%
Unmetered Water
Water Sales Sales Connection Fees Meter Charges Miscellaneous
1/31/20 Actual $ 946,390 $ - $ - $ - $ 998
1/31/19 Actual $ 903,040 $ 4,335 $ 3,220 $ 1,935 $ 220
% Change From Last Year 4.8%-100.0%-100.0%-100.0%353.6%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
1/31/20 Actual 96,013$ 242$ 41,744$ -$ 212$
1/31/19 Actual 81,784$ 1,859$ 40,345$ -$ 3,192$
% Change From Last Year 17.4%-87.0%3.5%0.0%-93.4%
Five Year Trend
Expenditures by Department
1/31/19 1/31/20 1/31/20 1/31/20 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Public Works 127,180$ 138,211$ 578,130$ 23.9%6,527,120$ 11,031$
Engineering & Capital Projects - - 122,465 0.0%6,542,825 -
Total Expenditures 127,180$ 138,211$ 700,595$ 19.7%13,069,945$ 11,031$
Five Year Trend
Village of Oak Brook
Water Fund - Major Sources Five Year Trend
For the Period Ending January 31, 2020
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Sports Core Fund Consolidated Presentation
For the Period Ending January 31, 2020
1/31/20 1/31/20
1/31/20 YTD % of 2020 1/31/19 Difference
B&T Recreation Food &Golf YTD Amended Amended Adopted YTD Prior
Programs Beverage Club Total Budget Budget Budget Total Year
OPERATING REVENUES
Memberships 199$ -$ -$ 199$ -$ N/A 459,135$ -$ 199$
Greens Fees - - 807 807 - N/A 930,000 - 807
Pro Shop Sales - - 2,055 2,055 2,500 82.2%207,000 2,459 (404)
Golf Lessons - - - - - 0.0%40,000 - -
Driving Range Fees - - - - - 0.0%244,000 - -
Rentals - - (17) (17) - N/A 375,000 - (17)
Programs/User Fees 1,120 - - 1,120 2,485 45.1%353,300 1,550 (430)
Food Sales - - - - - 0.0%180,500 - -
Beverage Sales - 19 - 19 - N/A 265,000 - 19
Other Revenue (188) 5,800 70 5,682 5,020 113.2%431,000 4,433 1,249
Total Operating Revenues 1,131$ 5,819$ 2,915$ 9,865$ 10,005$ 98.6%3,624,735$ 8,442$ 1,423$
OPERATING EXPENDITURES
Personnel -$ 18,757$ 73,170$ 91,927$ 97,975$ 93.8%1,578,100$ 91,084$ 843$
Materials & Supplies 85 148 13,317 13,550 4,095 330.9%618,025 3,884 9,666
Operational & Contractual 17,571 995 25,657 44,223 286,980 15.4%1,055,095 280,934 (236,711)
Other - - - - - 0.0%(83,150) - -
Capital - - 2,211 2,211 - N/A 1,921,545 (4,651) 6,862
Total Operating Expenditures 17,656$ 19,900$ 114,355$ 151,911$ 389,050$ 39.0%5,089,615$ 371,251$ (219,340)$
B&T Administration Overhead Allocation*10,790$ (10,790)$ -$ -$ -$ 0.0%-$ -$ -$
Operating Revenues Over (Under) Expenditures (5,735)$ (24,871)$ (111,440)$ (142,046)$ (379,045)$ 37.5%(1,464,880)$ (362,809)$ 220,763$
INTERFUND TRANSACTIONS
Interfund Loan**-$ -$ -$ -$ -$ 0.0%-$ 180,000$ (180,000)$
Transfer From General Fund - - - - - 0.0%923,000 - -
Transfer From Hotel Tax Fund - - - - - 0.0%35,000 - -
Transfer From Golf Surcharge Fund - - - - - 0.0%400,000 - -
Reimbursement From Infrastructure Fund 2,000 - - 2,000 2,000 100.0%24,000 2,000 -
Reimbursement From Water Fund 667 - - 667 665 100.3%8,000 667 -
Reimbursement To General Fund (2,352) - (2,352) (4,704) (4,700) 100.1%(56,450) - (4,704)
Total Interfund Transactions 315$ -$ (2,352)$ (2,037)$ (2,035)$ 100.1%1,333,550$ 182,667$ (184,704)$
Total Revenues Over (Under) Expenditures - Budgetary Basis (5,420)$ (24,871)$ (113,792)$ (144,083)$ (381,080)$ (131,330)$ (180,142)$ 36,059$
ADUSTMENTS TO GAAP BASIS***
Remove Capital Outlay -$ -$ 2,211$ 2,211$ (4,651)$
Depreciation Expense (12,500) (2,408) (17,667) (32,575) (26,933)
IMRF Pension Expense (21) (292) (863) (1,175) 7,225
OPEB Expense - (683) (3,083) (3,767) (3,642)
Total GAAP Adjustments (12,521)$ (3,383)$ (19,402)$ (35,306)$ (28,001)$
Fund Increase/(Decrease) - GAAP Basis (17,941)$ (28,254)$ (133,194)$ (179,389)$ (208,143)$
*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
1/31/20 Actual $ 9,865 151,911$
1/31/19 Actual $ 8,442 371,251$
% Change From Last Year 16.9%-59.1%
Driving Program/
Memberships Greens Fees Range Fees Rentals User Fees
1/31/20 Actual $ 199 $ 807 $ - $ (17) $ 1,120
1/31/19 Actual $ - $ - $ - $ - $ 1,550
% Change From Last Year N/A N/A N/A N/A -27.7%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
1/31/20 Actual 91,927$ 13,550$ 44,223$ -$ 2,211$
1/31/19 Actual 91,084$ 3,884$ 280,934$ -$ (4,651)$
% Change From Last Year 0.9%248.9%-84.3%0.0%-147.5%
Five Year Trend
Revenues by Department 1/31/19 1/31/20 1/31/20 1/31/20 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Programs 1,545$ 1,131$ 646,495$ 0.2%857,735$ (414)$
Food & Beverage 4,298 5,819 127,800 4.6%745,500 1,521
Golf Club 2,599 2,915 567,997 0.5%2,021,500 316
Total Revenues 8,442$ 9,865$ 1,342,292$ 0.7%3,624,735$ 1,423$
Expenditures by Department 1/31/19 1/31/20 1/31/20 % of 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Programs 254,436$ 17,656$ 344,363$ 5.1%1,963,230$ (236,780)$
Food & Beverage 15,935 19,900 281,968 7.1%843,355 3,965
Golf Club 100,880 114,355 778,751 14.7%2,283,030 13,475
Total Expenditures 371,251$ 151,911$ 1,405,082$ 10.8%5,089,615$ (219,340)$
Five Year Trend
Village of Oak Brook
Sports Core Fund - Major Sources Five Year Trend
For the Period Ending January 31, 2020
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Club Recreation Programs
For the Period Ending January 31, 2020 1/31/20 1/31/20
1/31/20 YTD % of 2020 1/31/19 Difference
811 812 813 815 816 YTD Amended Amended Adopted YTD Prior
B&T Admin Swimming Tennis Polo Open Fields Total Budget Budget Budget Total Year
OPERATING REVENUES
Memberships -$ 199$ -$ -$ -$ 199$ -$ N/A 241,635$ -$ 199$
Programs/User Fees - - - - 1,120 1,120 2,485 45.1%353,300 1,550 (430)
Grants - - - - - - - 0.0%139,800 - -
Other Revenue (188) - - - - (188) 20 -940.0%123,000 (5) (183)
Total Operating Revenues (188)$ 199$ -$ -$ 1,120$ 1,131$ 2,505$ 45.1%857,735$ 1,545$ (414)$
OPERATING EXPENDITURES
Personnel -$ -$ -$ -$ -$ -$ 4,610$ 0.0%146,325$ 2,999$ (2,999)$
Materials & Supplies - - 85 - - 85 350 24.3%32,750 - 85
Operational & Contractual 17,442 - 48 - 81 17,571 254,970 6.9%656,610 251,437 (233,866)
Other - - - - - - - 0.0%- - -
Capital - - - - - - - 0.0%1,127,545 - -
Total Operating Expenditures 17,442$ -$ 133$ -$ 81$ 17,656$ 259,930$ 6.8%1,963,230$ 254,436$ (236,780)$
B&T Administration Overhead Allocation*19,982$ (7,194)$ (1,998)$ -$ -$ 10,790$ 15,435$ 69.9%100,690$ 13,135$ (2,345)$
Operating Revenues Over (Under) Expenditures 2,352$ (6,995)$ (2,131)$ -$ 1,039$ (5,735)$ (241,990)$ 2.4%(1,004,805)$ (239,756)$ 234,021$
INTERFUND TRANSACTIONS
Interfund Loan**-$ -$ -$ -$ -$ -$ -$ 0.0%-$ 180,000$ (180,000)$
Transfer From General Fund - - - - - - - 0.0%757,500 - -
Transfer From Hotel Tax Fund - - - - - - - 0.0%35,000 - -
Reimbursement From Infrastructure Fund 2,000 - - - - 2,000 2,000 100.0%24,000 2,000 -
Reimbursement From Water Fund 667 - - - - 667 665 100.3%8,000 667 -
Reimbursement To General Fund (2,352) - - - - (2,352) (2,350) 100.1%(28,225) - (2,352)
Total Interfund Transactions 315$ -$ -$ -$ -$ 315$ 315$ 100.0%796,275$ 182,667$ (182,352)$
Total Revenues Over (Under) Expenditures - Budgetary Basis 2,667$ (6,995)$ (2,131)$ -$ 1,039$ (5,420)$ (241,675)$ (208,530)$ (57,089)$ 51,669$
ADUSTMENTS TO GAAP BASIS***
Remove Capital Outlay -$ -$ -$ -$ -$ -$ -$
Depreciation Expense - (11,978) (417) - (105) (12,500) (8,292)
IMRF Pension Expense - - - - (21) (21) 61
Total GAAP Adjustments -$ (11,978)$ (417)$ -$ (126)$ (12,521)$ (8,230)$
Fund Increase/(Decrease) - GAAP Basis 2,667$ (18,973)$ (2,548)$ -$ 913$ (17,941)$ (65,319)$
*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
Sports Core Food & Beverage Programs
For the Period Ending January 31, 2020
1/31/20 1/31/20
821 822 823 1/31/20 YTD % of 2020 1/31/19 Difference
B&T Poolside Golf YTD Amended Amended Adopted YTD Prior
Clubhouse Café Clubhouse Total Budget Budget Budget Total Year
OPERATING REVENUES
Memberships -$ -$ -$ -$ -$ 0.0%-$ -$ -$
Food Sales - - - - - 0.0%180,500 - -
Beverage Sales - - 19 19 - N/A 265,000 - 19
Other Revenue 5,800 - - 5,800 5,000 116.0%300,000 4,298 1,502
Total Operating Revenues 5,800$ -$ 19$ 5,819$ 5,000$ 116.4%745,500$ 4,298$ 1,521$
OPERATING EXPENDITURES
Personnel 13,001$ 667$ 5,089$ 18,757$ 22,300$ 84.1%291,470$ 15,707$ 3,050$
Materials & Supplies - - 148 148 3,335 4.4%228,425 (112) 260
Operational & Contractual 750 84 161 995 7,550 13.2%118,460 340 655
Capital - - - - - 0.0%205,000 - -
Total Operating Expenditures 13,751$ 751$ 5,398$ 19,900$ 33,185$ 60.0%843,355$ 15,935$ 3,965$
B&T Administration Overhead Allocation*(9,991)$ (799)$ -$ (10,790)$ (15,435)$ 69.9%(100,690)$ (13,135)$ 2,345$
Operating Revenues Over (Under) Expenditures (17,942)$ (1,550)$ (5,379)$ (24,871)$ (43,620)$ 57.0%(198,545)$ (24,772)$ (99)$
INTERFUND TRANSACTIONS
Transfer From General Fund -$ -$ -$ -$ -$ 0.0%165,500$ -$ -$
Total Interfund Transactions -$ -$ -$ -$ -$ 0.0%165,500$ -$ -$
Total Revenues Over (Under) Expenditures - Budgetary Basis (17,942)$ (1,550)$ (5,379)$ (24,871)$ (43,620)$ (33,045)$ (24,772)$ (99)$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay -$ -$ -$ -$ -$
Depreciation Expense (2,292) (117) - (2,408) (1,975)
IMRF Pension Expense (167) - (125) (292) 1,085
OPEB Expense (433) - (250) (683) (683)
Total GAAP Adjustments (2,892)$ (117)$ (375)$ (3,383)$ (1,574)$
Fund Increase/(Decrease) - GAAP Basis (20,834)$ (1,667)$ (5,754)$ (28,254)$ (26,346)$
*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 January 31, 2020
1/31/20 1/31/20
831 832 833 834 1/31/20 YTD % of 2020 1/31/19 Difference
Golf General Golf Learning Golf Cart Golf Course YTD Amended Amended Adopted YTD Prior
Operation & Practice Operations Maintenance Total Budget Budget Budget Total Year
OPERATING REVENUES
Memberships -$ -$ -$ -$ -$ -$ 0.0%217,500$ -$ -$
Greens Fees 807 - - - 807 - N/A 930,000 - 807
Pro Shop Sales 2,055 - - - 2,055 2,500 82.2%207,000 2,459 (404)
Golf Lessons - - - - - - 0.0%40,000 - -
Driving Range Fees - - - - - - 0.0%244,000 - -
Rentals - - (17) - (17) - N/A 375,000 - (17)
Other Revenue 70 - - - 70 - N/A 8,000 140 (70)
Total Operating Revenues 2,932$ -$ (17)$ -$ 2,915$ 2,500$ 116.6%2,021,500$ 2,599$ 316$
OPERATING EXPENDITURES
Personnel 43,883$ -$ 622$ 28,665$ 73,170$ 71,065$ 103.0%1,140,305$ 72,378$ 792$
Materials & Supplies 9,874 - 14 3,429 13,317 410 3248.0%356,850 3,996 9,321
Operational & Contractual 21,725 - - 3,932 25,657 24,460 104.9%280,025 29,157 (3,500)
Other - - - - - - 0.0%(83,150) - -
Capital 2,211 - - - 2,211 - N/A 589,000 (4,651) 6,862
Total Operating Expenditures 77,693$ -$ 636$ 36,026$ 114,355$ 95,935$ 119.2%2,283,030$ 100,880$ 13,475$
Operating Revenues Over (Under) Expenditures (74,761)$ -$ (653)$ (36,026)$ (111,440)$ (93,435)$ 119.3%(261,530)$ (98,281)$ (13,159)$
INTERFUND TRANSACTIONS
Transfer from Golf Surcharge -$ -$ -$ -$ -$ -$ 0.0%400,000$ -$ -$
Reimbursement to General Fund (2,352) - - - (2,352) (2,350) 100.1%(28,225) - (2,352)
Total Interfund Transactions (2,352)$ -$ -$ -$ (2,352)$ (2,350)$ 100.1%371,775$ -$ (2,352)$
Total Revenues Over (Under) Expenditures - Budgetary Basis (77,113)$ -$ (653)$ (36,026)$ (113,792)$ (95,785)$ 110,245$ (98,281)$ (15,511)$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay 2,211$ -$ -$ -$ 2,211$ (4,651)$
Depreciation Expense (11,250) (333) (1,917) (4,167) (17,667) (16,667)
IMRF Pension Expense (417) (29) - (417) (863) 6,079
OPEB Expense (1,917) - - (1,167) (3,083) (2,958)
Total GAAP Adjustments (11,372)$ (363)$ (1,917)$ (5,750)$ (19,402)$ (18,197)$
Fund Increase/(Decrease) - GAAP Basis (88,485)$ (363)$ (2,570)$ (41,776)$ (133,194)$ (116,478)$
*Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.