01 - January 2021 Monthly Financial ReportVILLAGE
OAK BROOK
OF
MONTHLY FINANCIAL REPORTS
JANUARY 2021
Cash and Investments by Fund:Total
Cash and Cash Pooled Cash and
Fund Equivalents Investments Investments % By Fund
General Corporate $9,693,776 $14,214,133 $23,907,909 53.2%
Hotel/Motel Tax 1,770,517 2,755,139 4,525,656 10.1%
Motor Fuel Tax 699,486 35,288 734,774 1.6%
Infrastructure 5,382,183 2,262,140 7,644,323 17.0%
Promenade TIF 39,060 - 39,060 0.1%
Water 3,090,648 3,798,189 6,888,837 15.3%
Sports Core 20,021 - 20,021 0.0%
Golf Surcharge 132,587 - 132,587 0.3%
Self-Insurance (19,315)- (19,315) 0.0%
Garage 323,065 - 323,065 0.7%
Equipment Replacement 309,009 411,457 720,466 1.6%
Total $21,441,037 $23,476,346 $44,917,383 100.0%
Change in Cash and Investments by Fund :
Balance at Balance at Year-to-Date Year-to-Date
Fund January 1, 2021 January 31, 2021 Change ($)Change (%)
General Corporate $23,744,852 $23,907,909 $163,057 0.7%
Hotel/Motel Tax 4,476,710 4,525,656 48,946 1.1%
Motor Fuel Tax 708,509 734,774 26,265 3.7%
Infrastructure 7,565,348 7,644,323 78,975 1.0%
Promenade TIF 267,300 39,060 (228,240)-85.4%
Water 6,900,133 6,888,837 (11,296)-0.2%
Sports Core 123,369 20,021 (103,348)-83.8%
Golf Surcharge 132,593 132,587 (6)0.0%
Self-Insurance 0 (19,315)(19,315)N/A
Garage 298,348 323,065 24,717 8.3%
Equipment Replacement 696,392 720,466 24,074 3.5%
$44,913,554 $44,917,383 $3,829 0.0%
Book Bank/Market
Value Value
Cash and Cash Equivalents:
Pooled Checking $752,631 $2,090,655
Sports Core Checking 151,980 153,329
Pooled IPTIP 20,359,628 20,359,628
Water E-Pay IPTIP 176,798 151,314
$21,441,037 $22,754,926
Pooled Investments:
Investments-Municipal Bonds $10,231,765 $10,302,957
Investments-Corporate Bonds 7,885,602 7,939,612
Government & Agency Obligations 1,523,652 1,555,063
Certificates of Deposit 3,675,000 3,713,570
Accrued Interest 160,327 160,327
Total Pooled Investments $23,476,346 $23,671,529
Total Cash and Investments $44,917,383 $46,426,455
For January, total interest revenue is $30,891. The total investment yield for the portfolio is:
Pooled
Investments Illinois Funds Total
Last 12 months yield 1.96%0.51%1.30%
The weighted average yield of the current investment portfolio is 1.45%. The IL Funds January average daily rate was 0.085%.
Monthly Treasurer's Report
January 31, 2021
Monthly Treasurer's Report
January 31 2021
The table below lists the detail investment holdings at J.P. Morgan Securities as of 1/31/21:
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,158 $201,062 $1,161
Bloomingdale Mich Pub Sch Dist #094383FS0 04/26/16 05/01/22 2.710%2.150%503,384 514,075 3,349
Connecticut St GO Bds 2016 #20772J3F7 06/15/17 08/15/21 1.750%2.300%498,557 504,265 3,982
State of IL #452152P54 10/09/19 11/01/21 5.000%1.870%511,669 513,890 5,999
Anchor Bay Mich Sch #032879TE8 11/01/19 05/01/21 2.320%1.750%716,026 718,654 4,009
Brownsville TX #16405ST9 12/19/19 02/15/22 2.050%2.000%555,275 564,285 5,088
Laredo TX Waterworks #517039VW0 12/19/19 03/01/24 2.230%2.230%455,000 475,525 4,171
Oakland Univ Mich #673588HJ1 04/29/20 03/01/24 5.000%1.650%324,557 331,819 6,146
Philadelphia PA GO Ref #717813SW0 05/05/20 08/01/22 5.000%1.820%408,347 416,329 9,547
Maryland St DOT #574204WG4 05/06/20 06/15/22 4.350%1.200%271,177 274,058 1,329
University of CA #91412HFK4 07/16/20 05/15/23 0.628%0.628%25,000 25,163 33
Windsor NY Sch Dist #973675EW7 07/23/02 06/17/21 1.500%0.400%476,952 476,971 3,735
Waterford Mich Sch Dist #941468YZ7 08/20/20 08/24/21 4.000%0.301%510,412 510,185 8,925
Weedsport NY Cent Sch Dist #948543KA0 08/21/20 08/20/21 1.000%0.570%501,181 500,630 2,218
Universty of IL #914353YH4 08/31/20 10/01/21 3.000%0.701%253,813 253,868 2,500
New Jersey St #646039UD7 09/20/20 06/01/22 5.000%0.600%502,756 504,293 3,892
Alaska St GO #011770Z72 10/14/2020 8/1/2021 5.000%0.252%179,171 179,253 4,351
Rio Rancho NM #767175HM7 10/14/2020 5/15/2022 5.000%0.350%196,074 196,500 1,927
Cook, Kane, Lake, & McHenry #216181GL5 10/29/2020 12/15/2022 4.000%0.300%1,095,744 1,097,242 10,470
Miami-Dade Cnty #59333NN90 11/16/2020 12/15/2022 0.375%0.430%734,126 734,361 911
Hamilton NY #407741MC8 1/21/2021 5/1/2023 1.000%0.550%207,065 206,829 46
Southern Cal Pub Pwr #84247PHZ7 1/25/2021 4/1/2024 3.608%0.500%1,105,321 1,103,700 2,806
Total Municipal Bonds $10,231,765 $10,302,957 $86,595
Corporate Bonds:
Morgan Stanley #61747WAL3 03/08/19 07/28/21 5.500%3.034%1,062,261 1,076,670 321
Citigroup #172967LC3 04/01/19 12/08/21 2.900%2.754%1,001,315 1,020,110 3,706
Goldman Sachs #38143U8F1 05/02/19 02/25/21 2.875%2.707%365,027 365,161 4,520
American Honda #02665WBG5 07/31/19 09/09/21 1.700%2.180%498,584 504,330 3,376
JP Morgan #48128BAB7 09/30/19 01/15/23 2.972%2.337%1,012,024 1,025,270 1,321
American Express #025816CD9 05/05/20 05/20/22 2.750%1.290%509,458 514,755 2,569
Goldman Sachs #38141GGQ1 08/31/20 07/27/21 5.250%0.251%353,418 353,377 201
PNC Bank #69349LAK4 12/7/2020 1/30/2023 2.950%0.457%1,070,487 1,068,725 15,045
Wells Fargo #94974BFJ4 12/7/2020 2/13/2023 3.450%0.480%1,473,331 1,472,594 22,246
Comerica Bank #200340AS6 12/23/2020 7/31/2023 3.700%0.500%539,697 538,620 9,250
Total Corporate Bonds $7,885,602 $7,939,612 $62,555
Government & Agency Obligations:
*Government National Mtg Assn #38379UEM4 02/29/16 02/16/51 2.300%2.245%$446,418 $440,655 $856
*Government National Mtg Assn #38381WV96 08/06/19 07/20/54 2.250%2.293%576,087 591,955 972
*Government National Mtg Assn #38380BNV3 12/05/19 06/20/46 2.000%2.112%501,147 522,453 749
Total Government & Agency Obligations:$1,523,652 $1,555,063 $2,577
Certificates of Deposit:
State Bk India NY #8562846A7 01/26/17 01/26/22 2.250%2.250%$245,000 $250,343 $62
Jackson Cnty Bk #466682AP6 08/31/17 03/01/21 1.850%1.850%245,000 245,382 1,889
Comenity Cap Bank #20033AU46 04/15/19 04/15/21 2.500%2.500%245,000 246,284 218
Morgan Stanley #61760AE21 05/30/19 06/01/21 2.400%2.400%245,000 246,980 980
First St Bank DeQueen #336460CU2 07/18/19 07/19/21 2.000%2.000%245,000 247,291 171
Bank Hapoalim #06251AW89 07/19/19 07/19/21 2.000%2.000%245,000 247,406 207
Capital One Natl Assn #14042RMF5 07/24/19 07/26/19 2.050%2.050%245,000 247,445 175
TIAA FSB Jacksonville #87270LCN1 07/29/19 07/29/21 2.000%2.000%245,000 247,426 7
Wells Fargo #949763J31 09/18/19 09/20/21 1.850%1.850%245,000 247,867 172
BMW Bank #05580ASQ8 10/11/19 10/12/21 1.800%1.800%245,000 248,038 1,274
Wells Fargo #949495AN5 01/17/20 01/18/22 1.800%1.800%245,000 249,158 172
Bank Leumi #063248KQ0 03/31/20 03/31/22 1.250%1.250%245,000 248,406 1,008
Capital One Natl Assn #14042TCZ8 04/01/20 04/01/22 1.350%1.350%245,000 248,685 1,089
Synchrony Bank #87164WZN1 04/03/20 04/04/22 1.350%1.350%245,000 248,709 1,070
Wells Fargo #95001DAB6 06/17/20 06/17/23 1.200%1.200%245,000 244,150 106
Total Certificates of Deposits $3,675,000 $3,713,570 $8,600
Total J.P.Morgan Securities $23,316,019 $23,511,202 $160,327
*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, 2021
Cash & Investments by Fund - Total $44.9 million
Cash & Investments by Type - Total $44.9 million
Checking
Illinois Funds
Certificates of Deposit
Municipal Bonds
Corporate Bonds
Government & Agency Obligations
Accrued Interest
General Corporate
53.2%
Hotel/Motel Tax
10.1%
Motor Fuel Tax
1.6%
Infrastructure
17.0%
Promenade TIF
0.1%
Water
15.3%
Sports Core
0.0%
Golf Surcharge
0.3%
Self-Insurance
0.0%Garage
0.7%
Equipment
Replacement
1.6%
Checking, $0.9
Illinois Funds, $20.5
Certificates of Deposit,
$3.7
Municipal Bonds,
$10.2
Corporate Bonds, $7.9
Government & Agency
Obligations, $1.5
Accrued Interest, $0.2
in millions
YTD YTD
Net Fund Budgeted
YTD YTD Increase Increase
Governmental Funds Revenues Expenditures (Decrease)(Decrease)
General Fund (Major Fund)2,078,814$ 2,032,426$ 46,388$ (71,055)$
Main operating fund of the Village.
Hotel Fund (Major Fund)34,538$ 7,007$ 27,531$ 8,995$
Collects and spends resources from the
3% hotel/motel tax.
Motor Fuel Tax Fund 26,265$ -$ 26,265$ 23,250$
Collects and spends resources from the
State motor fuel tax.
Infrastructure Fund (Major Fund)534,303$ 246,572$ 287,731$ 45,925$
Accounts for construction and maintenance of
roadways, drainage, and safety path systems.
Promenade TIF Fund (Major Fund)11$ 228,250$ (228,239)$ (221,865)$
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)892,564$ 160,722$ 731,842$ 147,245$
Collects user fees for the distribution of water
and maintenance of infrastructure.
Sports Core Fund (Major Fund)21,624$ 125,111$ (103,487)$ (120,480)$
Accounts for revenues and expenses relating
to administration, programs, food and beverage
operations, and golf course.
Golf Surcharge Fund (6)$ -$ (6)$ 65$
Accounts for the collection of the $3 per round
golf surcharge.
Internal Service Funds
Self Insurance Fund 280,485$ 14,879$ 265,606$ 3,855$
Accounts for the Village's health insurance costs
and the related contributions from the Village,
employees, retirees, and other agencies.
Garage Fund 50,861$ 45,382$ 5,479$ (9,810)$
Accounts for the maintenance of the Village's vehicle
fleet and the related departmental reimbursements.
Equipment Replacement Fund 28,029$ 17,698$ 10,331$ (8,940)$
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, 2021
Village of Oak Brook
Monthly Financial Report – Fund Narrative
For the Period Ending January 31, 2021
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 2021 are $57,965, or 2.9%, higher than last January and
$77,141, or 4.0%, over budget to date. The main drivers for this are:
o Sales tax revenue, the General
Fund’s largest revenue source, is
up $145,190 from last year and
$231,452 over budget. January
2021 collections came in at the
highest level in the past five
years.
o Licenses and permits revenue is
down $92,800 from last year and
$108,670 under budget. This is
due to the timing of receipts as
the Village issues permits throughout the year. Permit revenue is still expected to be
strong in 2021 with the continuation of the Hines Oak Brook Commons project.
Total expenditures through January 2021 are $659,332, or 24.6%, lower than last year and
$40,303, or 2.0%, under budget to date. The main drivers for this are:
o Personnel expenditures are down $601,716 from last year, but $68,484 over budget.
The decrease is due to two payroll cycles in January 2021 vs. three payroll cycles in
January 2020. In addition, personnel expenditures are over budget due to a retirement
payout that occurred in early 2021.
Hotel Tax Fund
Total revenues through January 2021 are $35,901, or 51.0%, lower than last year, but $4,053, or
13.3%, over budget to date. The main drivers for this are:
o Hotel tax revenue is down $30,948 from last year, but $3,664 over budget. The
decrease in revenue is due to the effects of COVID-19 on the travel industry.
Total expenditures through January 2021 are $190,057, or 100.0%, lower than last year and
$14,485, or 100.0%, under budget. Expenditures from the Hotel Tax Fund have not occurred yet
in 2021 as many initiatives have been put on hold due to the lack of revenue.
Infrastructure Fund
Total revenues through January 2021 are up $38,724, or 8.3%, from last year and $89,829, or
21.6%, over budget. The main drivers for this are:
o Non-home rule sales tax revenue
is up $48,183 from last year and
$90,130 over budget. January
2021 collections came in at the
highest level in the past five
years.
Total expenditures through January 2021
are down $72,641, or 23.9%, from last
year and $151,740, or 39.6%, under
budget to date. The main drivers for this
are:
o Personnel expenditures are down $53,695 from last year and $16,603 under budget.
The decrease is due to two payroll cycles in January 2021 vs. three payroll cycles in
January 2020.
o Operation and contract expenditures are down $7,540 from last year and $117,439
under budget. Expenditures are under budget due to the timing of engineering and
other miscellaneous payments.
Promenade TIF Fund
Total revenues through January 2021 are down $207, or 95.0%, from last year and $6,374, or
98.2%, under budget. The decrease is due to the decline in interest rates on available cash and
investments. Revenues are under budget due to the timing of information to record the TIF sale
tax transfer.
Total expenditures through January 2021 are down $37,205 from last year and even with
budget. The decrease relates to less principal and interest paid towards the TIF note.
Water Fund
Total revenues through January 2021 are down $72,131, or 7.5%, from last year and $111,021,
or 11.1%, under budget. The main drivers for this are:
o Water sales revenue is down $58,536 from last year and $92,146 under budget. Water
gallons sold has also been slightly less than projected so far this year.
Total expenditures through January 2021 are down $15,031, or 10.9%, from last year and
$695,620, or 85.0%, under budget. The main drivers for this are:
o Operation and contract expenditures are up $16,175 from last year, but $383,906 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 $212 from last year and $301,675 under budget.
Capital projects will occur later in 2021 as planned.
Sports Core Fund
Total revenues through January 2021 are up $8,425, or 85.4%, from last year and $11,255, or
160.0%, over 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 2021 are down $32,041, or 21.1%, from last year and
$5,725, or 4.6%, under budget to date. The main drivers for this are:
o Personnel expenditures are down $26,753 from last year and $8,996 under budget. The
decrease is due to two payroll cycles in January 2021 vs. three payroll cycles in January
2020.
1/31/21 1/31/21
1/31/20 1/31/21 YTD % of YTD 2021 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 1,007,062$ 1,152,252$ 920,800$ 125.1%11,860,995$ 145,190$
Other Intergovernmental Tax*149,460 163,341 124,550 131.1%1,320,600 13,881
Telecommunications/Utility Tax 512,445 481,698 515,000 93.5%5,995,000 (30,747)
Licenses and Permits 148,300 55,500 164,170 33.8%2,180,360 (92,800)
Charges for Services 77,100 62,782 99,275 63.2%1,293,540 (14,318)
Fines and Penalties 20,307 14,909 15,045 99.1%180,500 (5,398)
Administrative Towing Fees 3,637 8,014 1,835 436.7%22,000 4,377
Investment Interest 37,724 18,384 25,000 73.5%300,000 (19,340)
Franchise Fees - - 50,500 0.0%202,000 -
Miscellaneous Income 15,341 72,461 36,025 201.1%463,380 57,120
Total Operating Revenues 1,971,376$ 2,029,341$ 1,952,200$ 104.0%23,818,375$ 57,965$
OPERATING EXPENDITURES
Personnel 2,148,730$ 1,547,014$ 1,478,530$ 104.6%18,842,080$ (601,716)$
Materials and Supplies 28,293 22,769 36,795 61.9%551,030 (5,524)
Operation and Contract 503,005 451,646 541,880 83.3%3,397,210 (51,359)
Other Expenditures 2,200 2,173 2,500 86.9%10,000 (27)
Capital Outlay 706 - 4,200 0.0%452,300 (706)
Total Operating Expenditures 2,682,934$ 2,023,602$ 2,063,905$ 98.0%23,252,620$ (659,332)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES (711,558)$ 5,739$ (111,705)$ 565,755$ 717,297$
INTERFUND TRANSACTIONS
Transfers Out -$ -$ -$ -$ (100,000)$ -$
Reimbursements From Other Funds 52,199 49,473 49,475 100.0%593,685 (2,726)
Reimbursements To Other Funds (11,647) (8,824) (8,825) 100.0%(105,885) 2,823
Total Interfund Transactions 40,552$ 40,649$ 40,650$ 100.0%387,800$ 97$
NET FUND INCREASE (DECREASE)(671,006)$ 46,388$ (71,055)$ 953,555$ 717,394$
*Includes the collection of Income Tax, Use Tax, Road & Bridge Tax, Personal Property Replacement Tax, and Cannabis Use Tax.
Village of Oak Brook
General Fund Financial Update
For the Period Ending January 31, 2021
Total Total
Revenues Expenditures
1/31/21 Actual 2,029,341$ 2,023,602$
1/31/20 Actual 1,971,376$ 2,682,934$
% Change From Last Year 2.9%-24.6%
Major Revenues
Other Telecom/Utility Licenses &Charges for
Sales Tax Intergov. Tax Tax Permits Services
1/31/21 Actual 1,152,252$ 163,341$ 481,698$ 55,500$ 62,782$
1/31/20 Actual $ 1,007,062 $ 149,460 $ 512,445 $ 148,300 $ 77,100
% Change From Last Year 14.4%9.3%-6.0%-62.6%-18.6%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
1/31/21 Actual 1,547,014$ 22,769$ 451,646$ 2,173$ -$
1/31/20 Actual 2,148,730$ 28,293$ 503,005$ 2,200$ 706$
% Change From Last Year -28.0%-19.5%-10.2%-1.2%-100.0%
Five Year Trend
Expenditures by Department
1/31/20 1/31/21 1/31/21 1/31/21 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Department Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 261,775$ 244,706$ 325,350$ 75.2%2,498,625$ (17,069)$
Financial Services 75,632 56,793 59,535 95.4%770,360 (18,839)
Public Works 56,732 45,374 49,640 91.4%948,860 (11,358)
Engineering & Capital Projects 706 - 4,000 0.0%209,000 (706)
Library 115,137 73,072 78,825 92.7%943,405 (42,065)
Police 1,121,574 873,286 799,525 109.2%9,213,585 (248,288)
Fire 965,130 633,402 638,065 99.3%7,576,045 (331,728)
Development Services 86,248 96,969 108,965 89.0%1,092,740 10,721
Total Expenditures 2,682,934$ 2,023,602$ 2,063,905$ 98.0%23,252,620$ (659,332)$
Five Year Trend
For the Period Ending January 31, 2021
General Fund - Five Year Trend
Village of Oak Brook
Revenues Expenditures
1/31/21 1/31/21
1/31/20 1/31/21 YTD % of YTD 2021 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Hotel Tax 61,762$ 30,814$ 27,150$ 113.5%414,000$ (30,948)$
Investment Interest 8,677 3,724 3,335 111.7%40,000 (4,953)
Loan Interest - - - 0.0%8,000 -
Total Operating Revenues 70,439$ 34,538$ 30,485$ 113.3%462,000$ (35,901)$
EXPENDITURES
Operation and Contract 111,995$ -$ 14,485$ 0.0%193,945$ (111,995)$
Capital Outlay 78,062 - - 0.0%250,000 (78,062)
Total Expenditures 190,057$ -$ 14,485$ 0.0%443,945$ (190,057)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES (119,618)$ 34,538$ 16,000$ 215.9%18,055$ 154,156$
INTERFUND TRANSACTIONS
Transfer Out -$ -$ -$ 0.0%(100,000)$ -$
Reimbursements to Other Funds (6,226) (7,007) (7,005) 100.0%(84,085) (781)
Total Interfund Transactions (6,226)$ (7,007)$ (7,005)$ 100.0%(184,085)$ (781)$
NET FUND INCREASE (DECREASE)(125,844)$ 27,531$ 8,995$ (166,030)$ 153,375$
Note - Expenditures are recorded in program 171.
Village of Oak Brook
Hotel Tax Fund Financial Update
For the Period Ending January 31, 2021
Total Total
Revenues Expenditures
1/31/21 Actual $ 34,538 -$
1/31/20 Actual $ 70,439 190,057$
% Change From Last Year -51.0%-100.0%
Major Revenues Investment
Hotel Tax Interest Loan Interest Miscellaneous
1/31/21 Actual $ 30,814 $ 3,724 -$ -$
1/31/20 Actual $ 61,762 $ 8,677 -$ -$
% Change From Last Year -50.1%-57.1%0.0%0.0%
Five Year Trend
Major Expenditures Operation &
Contractual Capital Outlay
1/31/21 Actual -$ -$
1/31/20 Actual 111,995$ 78,062$
% Change From Last Year -100.0%-100.0%
Five Year Trend
Village of Oak Brook
Hotel Tax Fund - Major Sources Five Year Trend
For the Period Ending January 31, 2021
Five Year Trend
Revenues Expenditures
1/31/21 1/31/21
1/31/20 1/31/21 YTD % of YTD 2021 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Non-Home Rule Sales Tax 455,347$ 503,530$ 413,400$ 121.8%5,333,500$ 48,183$
Charges for Services - - 85 0.0%1,000 -
Investment Interest 12,427 3,119 3,335 93.5%40,000 (9,308)
Miscellaneous 151 - - 0.0%- (151)
Total Operating Revenues 467,925$ 506,649$ 416,820$ 121.6%5,374,500$ 38,724$
OPERATING EXPENDITURES
Personnel 164,692$ 110,997$ 127,600$ 87.0%1,386,115$ (53,695)$
Materials and Supplies 38,853 22,260 45,145 49.3%245,660 (16,593)
Operation and Contract 100,976 93,436 210,875 44.3%1,892,905 (7,540)
Capital Outlay - 5,187 - N/A 8,956,170 5,187
Total Operating Expenditures 304,521$ 231,880$ 383,620$ 60.4%12,480,850$ (72,641)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 163,404$ 274,769$ 33,200$ 827.6%(7,106,350)$ 111,365$
INTERFUND TRANSACTIONS
Transfers In -$ -$ -$ 0.0%1,400,000$ -$
Reimbursements From Other Funds 29,948 27,654 27,655 100.0%331,840 (2,294)
Reimbursements To Other Funds (13,525) (14,692) (14,930) 98.4%(176,300) (1,167)
Total Interfund Transactions 16,423$ 12,962$ 12,725$ 101.9%1,555,540$ (3,461)$
NET FUND INCREASE (DECREASE)179,827$ 287,731$ 45,925$ (5,550,810)$ 107,904$
Village of Oak Brook
Infrastructure Fund Financial Update
For the Period Ending January 31, 2021
Total Total
Revenues Expenditures
1/31/21 Actual $ 506,649 231,880$
1/31/20 Actual $ 467,925 304,521$
% Change From Last Year 8.3%-23.9%
Major Revenues
Sales Tax
Charges for
Services
Investment
Interest Miscellaneous
1/31/21 Actual $ 503,530 $ - $ 3,119 $ -
1/31/20 Actual $ 455,347 $ - $ 12,427 $ 151
% Change From Last Year 10.6%0.0%-74.9%-100.0%
Five Year Trend
Major Expenditures Materials &Operation &
Personnel Supplies Contractual Capital Outlay
1/31/21 Actual 110,997$ 22,260$ 93,436$ 5,187$
1/31/20 Actual 164,692$ 38,853$ 100,976$ -$
% Change From Last Year -32.6%-42.7%-7.5%N/A
Five Year Trend
Expenditures by Department
1/31/20 1/31/21 1/31/21 1/31/21 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 4,557$ 3,965$ 14,885$ 26.6%157,640$ (592)$
Public Works 288,868 213,786 290,600 73.6%2,789,580 (75,082)
Engineering & Capital Projects 11,096 14,129 78,135 18.1%9,709,930 3,033
Total Expenditures 304,521$ 231,880$ 383,620$ 60.4%12,657,150$ (72,641)$
Five Year Trend
Village of Oak Brook
Infrastructure Fund - Major Sources Five Year Trend
For the Period Ending January 31, 2021
Revenues Expenditures
1/31/21 1/31/21
1/31/20 1/31/21 YTD % of YTD 2021 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax -$ -$ 6,300$ 0.0%75,000$ -$
Real Estate Tax - - - 0.0%400,000 -
Investment Interest 218 11 85 12.9%1,000 (207)
Total Operating Revenues 218$ 11$ 6,385$ 0.2%476,000$ (207)$
EXPENDITURES
Operation and Contract -$ -$ -$ 0.0%3,850$ -$
Other Expenditures 265,455 228,250 228,250 100.0%466,500 (37,205)
Total Expenditures 265,455$ 228,250$ 228,250$ 100.0%470,350$ (37,205)$
NET FUND INCREASE (DECREASE)(265,237)$ (228,239)$ (221,865)$ 5,650$ 36,998$
Note - Expenditures are recorded in program 283.
Village of Oak Brook
Promenade TIF Fund Financial Update
For the Period Ending January 31, 2021
Total Total
Revenues Expenditures
1/31/21 Actual $ 11 228,250$
1/31/20 Actual $ 218 265,455$
% Change From Last Year -95.0%-14.0%
Major Revenues Real Estate Investment
Sales Tax Tax Interest
1/31/21 Actual -$ $ - $ 11
1/31/20 Actual -$ $ - $ 218
% Change From Last Year 0.0%0.0%-95.0%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures
1/31/21 Actual -$ 228,250$
1/31/20 Actual -$ 265,455$
% Change From Last Year 0.0%-14.0%
Five Year Trend
Village of Oak Brook
Promenade TIF Fund - Major Sources Five Year Trend
For the Period Ending January 31, 2021
Five Year Trend
Revenues Expenditures
1/31/21 1/31/21
1/31/20 1/31/21 YTD % of YTD 2021 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Plan Review Fees -$ -$ 85$ 0.0%1,000$ -$
Building/Inspection Fees 4,762 - 585 0.0%7,000 (4,762)
Water Sales 946,390 887,854 980,000 90.6%10,597,000 (58,536)
Unmetered Sales - - 2,915 0.0%35,000 -
Water Connection Fees - - 8,335 0.0%100,000 -
Meter Charges - - 1,250 0.0%15,000 -
Special Services 763 - - 0.0%25,000 (763)
Investment Interest 11,782 4,974 5,000 99.5%60,000 (6,808)
Miscellaneous 998 (264) 5,415 -4.9%65,000 (1,262)
Total Operating Revenues 964,695$ 892,564$ 1,003,585$ 88.9%10,905,000$ (72,131)$
OPERATING EXPENDITURES
Personnel 96,013$ 59,194$ 69,770$ 84.8%842,235$ (36,819)$
Materials and Supplies 242 6,067 5,530 109.7%75,780 5,825
Operation and Contract 41,744 57,919 441,825 13.1%5,379,925 16,175
Capital Outlay 212 - 301,675 0.0%8,103,750 (212)
Total Expenditures 138,211$ 123,180$ 818,800$ 15.0%14,401,690$ (15,031)$
Surplus (Deficit) of Revenues Over
Expenditures 826,484$ 769,384$ 184,785$ 416.4%(3,496,690)$ (57,100)$
INTERFUND TRANSACTIONS
Transfers In -$ -$ -$ 0.0%-$ -
Reimbursements To Other Funds (43,901) (37,542) (37,540) 100.0%(450,500) 6,359
Total Interfund Transactions (43,901)$ (37,542)$ (37,540)$ 100.0%(450,500)$ 6,359$
Fund Increase/(Decrease) - Budgetary Basis 782,583$ 731,842$ 147,245$ 497.0%(3,947,190)$ (50,741)$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay 212$ -$
Depreciation Expense (42,675) (47,917)
IMRF Pension Expense 6,436 4,167
OPEB Expense (4,085) (3,750)
Total GAAP Adjustments (40,113)$ (47,500)$
Fund Increase/(Decrease) - GAAP Basis 742,471$ 684,342$
*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, 2021
Total Total
Revenues Expenditures
1/31/21 Actual $ 892,564 123,180$
1/31/20 Actual $ 964,695 138,211$
% Change From Last Year -7.5%-10.9%
Unmetered Water
Water Sales Sales Connection Fees Meter Charges Miscellaneous
1/31/21 Actual $ 887,854 $ - $ - $ - $ (264)
1/31/20 Actual $ 946,390 $ - $ - $ - $ 998
% Change From Last Year -6.2%0.0%0.0%0.0%-126.5%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
1/31/21 Actual 59,194$ 6,067$ 57,919$ -$ -$
1/31/20 Actual 96,013$ 242$ 41,744$ -$ 212$
% Change From Last Year -38.3%2407.0%38.7%0.0%-100.0%
Five Year Trend
Expenditures by Department
1/31/20 1/31/21 1/31/21 1/31/21 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Public Works 138,211$ 123,180$ 518,800$ 23.7%6,317,940$ (15,031)$
Engineering & Capital Projects - - 300,000 0.0%8,083,750 -
Total Expenditures 138,211$ 123,180$ 818,800$ 15.0%14,401,690$ (15,031)$
Five Year Trend
Village of Oak Brook
Water Fund - Major Sources Five Year Trend
For the Period Ending January 31, 2021
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Sports Core Fund Consolidated Presentation
For the Period Ending January 31, 2021
1/31/21 1/31/21
1/31/21 YTD % of YTD 2021 1/31/20 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 -$ -$ -$ 5,700$ 5,700$ -$ N/A 238,500$ 199$ 5,501$
Greens Fees - - - - - - 0.0%985,000 807 (807)
Pro Shop Sales - - - 2,570 2,570 2,500 102.8%207,000 2,055 515
Golf Lessons - - - - - - 0.0%45,000 - -
Driving Range Fees - - - 550 550 - N/A 250,000 - 550
Rentals - 2,500 - (34) 2,466 4,500 54.8%761,000 6,903 (4,437)
Programs/User Fees - - - - - - 0.0%31,500 - -
Food Sales - - - - - - 0.0%207,500 - -
Beverage Sales - - - - - - 0.0%382,000 19 (19)
Taste of Oak Brook - - - - - - 0.0%120,000 - -
Grants - - - - - - 0.0%233,600 - -
Other Revenue 6,903 - - 101 7,004 35 20011.4%7,700 (118) 7,122
Total Operating Revenues 6,903$ 2,500$ -$ 8,887$ 18,290$ 7,035$ 260.0%3,468,800$ 9,865$ 8,425$
OPERATING EXPENDITURES
Personnel -$ -$ 8,428$ 56,746$ 65,174$ 74,170$ 87.9%1,597,610$ 91,927$ (26,753)$
Materials & Supplies 63 - 606 9,676 10,345 1,965 526.5%628,450 13,550 (3,205)
Operational & Contractual 13,030 460 850 30,011 44,351 49,460 89.7%663,035 44,223 128
Other - - - - - - 0.0%(39,000) - -
Capital - - - - - - 0.0%1,125,380 2,211 (2,211)
Total Operating Expenditures 13,093$ 460$ 9,884$ 96,433$ 119,870$ 125,595$ 95.4%3,975,475$ 151,911$ (32,041)$
B&T Administration Overhead Allocation*3,565$ -$ (3,565)$ -$ -$ -$ 0.0%-$ -$ -$
Operating Revenues Over (Under) Expenditures (2,625)$ 2,040$ (13,449)$ (87,546)$ (101,580)$ (118,560)$ 85.7%(506,675)$ (142,046)$ 40,466$
INTERFUND TRANSACTIONS
Transfer From General Fund -$ -$ -$ -$ -$ -$ 0.0%100,000$ -$ -$
Transfer From Hotel Tax Fund - - - - - - 0.0%- - -
Transfer From Golf Surcharge Fund - - - - - - 0.0%200,000 - -
Reimbursement From Infrastructure Fund 2,667 - - - 2,667 2,670 99.9%32,000 2,000 667
Reimbursement From Water Fund 667 - - - 667 665 100.3%8,000 667 -
Reimbursement To General Fund (1,310) - - (3,931) (5,241) (5,255) 99.7%(62,900) (4,704) (537)
Total Interfund Transactions 2,024$ -$ -$ (3,931)$ (1,907)$ (1,920)$ 99.3%277,100$ (2,037)$ 130$
Total Revenues Over (Under) Expenditures - Budgetary Basis (601)$ 2,040$ (13,449)$ (91,477)$ (103,487)$ (120,480)$ (229,575)$ (144,083)$ 40,596$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay -$ -$ -$ -$ -$ 2,211$
Depreciation Expense (12,492) (140) (2,917) (17,667) (33,216) (27,366)
IMRF Pension Expense (438) (21) (167) (988) (1,613) 7,731
OPEB Expense - - (433) (3,333) (3,767) (1,670)
Total GAAP Adjustments (12,929)$ (161)$ (3,517)$ (21,988)$ (38,595)$ (19,093)$
Fund Increase/(Decrease) - GAAP Basis (13,530)$ 1,879$ (16,966)$ (113,465)$ (142,082)$ (163,176)$
*Overhead allocation is comprised of salaries, business forms, liability insurance, building & grounds maintenance and bank service fees in Program 811 - Sports Core General Operations distributed to various Sports Core
Programs on a % basis.
**Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.
Total Direct Total Direct
Revenues Expenditures
1/31/21 Actual $ 18,290 119,870$
1/31/20 Actual $ 9,865 151,911$
% Change From Last Year 85.4%-21.1%
Driving Program/
Memberships Greens Fees Range Fees Rentals User Fees
1/31/21 Actual $ 5,700 $ - $ 550 $ 2,466 -$
1/31/20 Actual $ 199 $ 807 $ - $ 6,903 -$
% Change From Last Year 2764.3%-100.0%N/A -64.3%#DIV/0!
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
1/31/21 Actual 65,174$ 10,345$ 44,351$ -$ -$
1/31/20 Actual 91,927$ 13,550$ 44,223$ -$ 2,211$
% Change From Last Year -29.1%-23.7%0.3%0.0%-100.0%
Five Year Trend
Revenues by Department 1/31/20 1/31/21 1/31/21 1/31/21 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Operations 11$ 6,903$ 35$ 19722.9%325,800$ 6,892$
Open Field Operations 1,120 2,500 2,500 100.0%230,000 1,380
B&T Clubhouse Operations 5,800 - 2,000 0.0%267,000 (5,800)
Golf Club 2,934 8,887 2,500 355.5%2,646,000 5,953
Total Revenues 9,865$ 18,290$ 7,035$ 260.0%3,468,800$ 8,425$
Expenditures by Department 1/31/20 1/31/21 1/31/21 % of YTD 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Operations 18,326$ 13,093$ 20,660$ 63.4%780,740$ (5,233)$
Open Field Operations 81$ 460$ 525$ 87.6%358,910$ 379$
B&T Clubhouse Operations 13,751 9,884 17,310 57.1%262,635 (3,867)
Golf Club 119,753 96,433 87,100 110.7%2,573,190 (23,320)
Total Expenditures 151,911$ 119,870$ 125,595$ 95.4%3,975,475$ (32,041)$
Five Year Trend
Village of Oak Brook
Sports Core Fund - Major Sources Five Year Trend
For the Period Ending January 31, 2021
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Club Recreation Operations
For the Period Ending January 31, 2021 1/31/21 1/31/21
822 1/31/21 YTD % of YTD 2021 1/31/20 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 -$ -$ -$ -$ -$ -$ 0.0%-$ 199$ (199)$
Programs/User Fees - - - - - - 0.0%31,500 - -
Food Sales - - - - - - 0.0%38,000 - -
Beverage Sales - - - - - - 0.0%22,000 - -
Grants - - - - - - 0.0%233,600 - -
Other Revenue 6,903 - - - 6,903 35 19722.9%700 (188) 7,091
Total Operating Revenues 6,903$ -$ -$ -$ 6,903$ 35$ 19722.9%325,800$ 11$ 6,892$
OPERATING EXPENDITURES
Personnel -$ -$ -$ -$ -$ 2,375$ 0.0%119,110$ 667$ (667)$
Materials & Supplies - 63 - - 63 40 157.5%37,250 85 (22)
Operational & Contractual 12,723 307 - - 13,030 18,245 71.4%89,550 17,574 (4,544)
Capital - - - - - - 0.0%534,830 - -
Total Operating Expenditures 12,723$ 370$ -$ -$ 13,093$ 20,660$ 63.4%780,740$ 18,326$ (5,233)$
B&T Administration Overhead Allocation*7,130$ (2,567)$ (713)$ (285)$ 3,565$ 9,235$ 38.6%44,755$ 9,991$ (6,426)$
Operating Revenues Over (Under) Expenditures 1,310$ (2,937)$ (713)$ (285)$ (2,625)$ (11,390)$ 23.0%(410,185)$ (8,324)$ 5,699$
INTERFUND TRANSACTIONS
Transfer From General Fund -$ -$ -$ -$ -$ 0.0%100,000$ -$ -$
Reimbursement From Infrastructure Fund 2,667 - - 2,667 2,670 99.9%32,000 2,000 667
Reimbursement From Water Fund 667 - - 667 665 100.3%8,000 667 -
Reimbursement To General Fund (1,310) - - (1,310) (1,310) 100.0%(15,725) (2,352) 1,042
Total Interfund Transactions 2,024$ -$ -$ -$ 2,024$ 2,025$ 100.0%124,275$ 315$ 1,709$
Total Revenues Over (Under) Expenditures - Budgetary Basis 3,334$ (2,937)$ (713)$ (285)$ (601)$ (9,365)$ (285,910)$ (8,009)$ 7,408$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay -$ -$ -$ -$ -$ -$
Depreciation Expense - (11,978) (417) (97) (12,492) (7,902)
IMRF Pension Expense (417) - - (21) (438) 508
Total GAAP Adjustments (417)$ (11,978)$ (417)$ (118)$ (12,929)$ (7,394)$
Fund Increase/(Decrease) - GAAP Basis 2,917$ (14,915)$ (1,130)$ (403)$ (13,530)$ (15,403)$
*Overhead allocation is comprised of salaries, business forms, liability insurance, building & grounds maintenance and bank service fees in Program 811 - Sports Core General Operations distributed to various Sports Core Programs on
a percentage basis.
**Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.
Village of Oak Brook
Monthly Operating Statement
Open Fields Operations
For the Period Ending January 31, 2021 1/31/21 1/31/21
1/31/21 YTD % of YTD 2021 1/31/20 Difference
815 816 YTD Amended Amended Adopted YTD Prior
Polo Open Fields Total Budget Budget Budget Total Year
OPERATING REVENUES
Field Rentals -$ 2,500$ 2,500$ 2,500$ 100.0%30,000$ 1,120$ 1,380$
Range Rentals - - - - 0.0%80,000 - -
Taste of Oak Brook - - - - 0.0%120,000 - -
Other Revenue - - - - 0.0%- - -
Total Operating Revenues -$ 2,500$ 2,500$ 2,500$ 100.0%230,000$ 1,120$ 1,380$
OPERATING EXPENDITURES
Personnel -$ -$ -$ -$ 0.0%-$ -$
Materials & Supplies - - - - 0.0%500 - -
Operational & Contractual - 460 460 525 87.6%190,360 81 379
Capital - - - - 0.0%168,050 - -
Total Operating Expenditures -$ 460$ 460$ 525$ 87.6%358,910$ 81$ 379$
Operating Revenues Over (Under) Expenditures -$ 2,040$ 2,040$ 1,975$ 103.3%(128,910)$ 1,039$ 1,001$
INTERFUND TRANSACTIONS
Transfer From Hotel Tax Fund -$ -$ -$ -$ 0.0%-$ -$ -$
Total Interfund Transactions -$ -$ -$ -$ 0.0%-$ -$ -$
Total Revenues Over (Under) Expenditures - Budgetary Basis -$ 2,040$ 2,040$ 1,975$ (128,910)$ 1,039$ 1,001$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay -$ -$ -$ -$
Depreciation Expense - (140) (140) (140)
IMRF Pension Expense - (21) (21) 61
Total GAAP Adjustments -$ (161)$ (161)$ (79)$
Fund Increase/(Decrease) - GAAP Basis -$ 1,879$ 1,879$ 960$
*Overhead allocation is comprised of salaries, business forms, liability insurance, building & grounds maintenance and bank service fees in Program 811 - Sports Core General Operations distributed to
various Sports Core Programs on a percentage basis.
**Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Clubhouse Operations
For the Period Ending January 31, 2021
1/31/21 1/31/21
821 YTD % of YTD 2021 1/31/20 Difference
B&T Amended Amended Adopted YTD Prior
Clubhouse Budget Budget Budget Total Year
OPERATING REVENUES
Rentals -$ 2,000$ 0.0%267,000$ 5,800$ (5,800)$
Total Operating Revenues -$ 2,000$ 0.0%267,000$ 5,800$ (5,800)$
OPERATING EXPENDITURES
Personnel 8,428$ 9,165$ 92.0%133,585$ 13,001$ (4,573)$
Materials & Supplies 606 1,515 40.0%12,000 - 606
Operational & Contractual 850 6,630 12.8%107,550 750 100
Capital - - 0.0%9,500 - -
Total Operating Expenditures 9,884$ 17,310$ 57.1%262,635$ 13,751$ (3,867)$
B&T Administration Overhead Allocation*(3,565)$ (9,235)$ 38.6%(44,755)$ (9,991)$ 6,426$
Operating Revenues Over (Under) Expenditures (13,449)$ (24,545)$ 54.8%(40,390)$ (17,942)$ 4,493$
INTERFUND TRANSACTIONS
Transfer From General Fund -$ -$ 0.0%-$ -$ -$
Total Interfund Transactions -$ -$ 0.0%-$ -$ -$
Total Revenues Over (Under) Expenditures - Budgetary Basis (13,449)$ (24,545)$ (40,390)$ (17,942)$ 4,493$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay -$ -$
Depreciation Expense (2,917) (2,679)
IMRF Pension Expense (167) 558
OPEB Expense (433) (175)
Total GAAP Adjustments (3,517)$ (2,296)$
Fund Increase/(Decrease) - GAAP Basis (16,966)$ (20,238)$
*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, 2021
1/31/21 1/31/21
823 831 832 833 834 1/31/21 YTD % of YTD 2021 1/31/20 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 -$ 5,700$ -$ -$ -$ 5,700$ -$ N/A 238,500$ -$ 5,700$
Greens Fees - - - - - - - 0.0%985,000 807 (807)
Pro Shop Sales - 2,570 - - - 2,570 2,500 102.8%207,000 2,055 515
Golf Lessons - - - - - - - 0.0%45,000 - -
Driving Range Fees - - 550 - - 550 - N/A 250,000 - 550
Rentals - - - (34) - (34) - N/A 384,000 (17) (17)
Food Sales - - - - - - - 0.0%169,500 - -
Beverage Sales - - - - - - - 0.0%360,000 19 (19)
Other Revenue - 101 - - - 101 - N/A 7,000 70 31
Total Operating Revenues -$ 8,371$ 550$ (34)$ -$ 8,887$ 2,500$ 355.5%2,646,000$ 2,934$ 5,953$
OPERATING EXPENDITURES
Personnel 3,439$ 30,857$ -$ -$ 22,450$ 56,746$ 62,630$ 90.6%1,344,915$ 78,259$ (21,513)$
Materials & Supplies 689 8,940 - - 47 9,676 410 2360.0%578,700 13,465 (3,789)
Operational & Contractual 276 22,341 - - 7,394 30,011 24,060 124.7%275,575 25,818 4,193
Other - - - - - - 0.0%(39,000) - -
Capital - - - - - - 0.0%413,000 2,211 (2,211)
Total Operating Expenditures 4,404$ 62,138$ -$ -$ 29,891$ 96,433$ 87,100$ 110.7%2,573,190$ 119,753$ (23,320)$
Operating Revenues Over (Under) Expenditures (4,404)$ (53,767)$ 550$ (34)$ (29,891)$ (87,546)$ (84,600)$ 103.5%72,810$ (116,819)$ 29,273$
INTERFUND TRANSACTIONS
Transfer from Golf Surcharge -$ -$ -$ -$ -$ 0.0%200,000$ -$ -$
Reimbursement to General Fund - (3,931) - - (3,931) (3,945) 99.6%(47,175) (2,352) (1,579)
Total Interfund Transactions -$ (3,931)$ -$ -$ -$ (3,931)$ (3,945)$ 99.6%152,825$ (2,352)$ (1,579)$
Total Revenues Over (Under) Expenditures - Budgetary Basis (4,404)$ (57,698)$ 550$ (34)$ (29,891)$ (91,477)$ (88,545)$ 225,635$ (119,171)$ 27,694$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay -$ -$ -$ -$ -$ -$ 2,211$
Depreciation Expense - (11,250) (333) (1,917) (4,167) (17,667) (16,644)
IMRF Pension Expense (125) (417) (29) - (417) (988) 6,603
OPEB Expense (250) (1,917) - - (1,167) (3,333) (1,495)
Total GAAP Adjustments (375)$ (13,583)$ (363)$ (1,917)$ (5,750)$ (21,988)$ (9,325)$
Fund Increase/(Decrease) - GAAP Basis (4,779)$ (71,281)$ 188$ (1,951)$ (35,641)$ (113,465)$ (128,496)$
*Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.