03 - March 2022 Monthly Financial ReportVILLAGE
OAK BROOK
OF
MONTHLY FINANCIAL REPORTS
MARCH 2022
ITEM 6.E
Cash and Investments by Fund:Total
Cash and Cash Pooled Cash and
Fund Equivalents Investments Investments % By Fund
General Corporate $15,873,899 $13,824,353 $29,698,252 57.1%
Hotel/Motel Tax 1,107,071 716,622 1,823,693 3.5%
Motor Fuel Tax 1,300,538 14,728 1,315,265 2.5%
Infrastructure 7,607,717 4,507,451 12,115,168 23.3%
Promenade TIF 55,266 - 55,266 0.1%
Water 1,378,363 3,368,190 4,746,553 9.1%
Sports Core 770,485 - 770,485 1.5%
Golf Surcharge 281,686 - 281,686 0.5%
Self-Insurance 260,242 - 260,242 0.5%
Garage 345,962 - 345,962 0.7%
Equipment Replacement 243,434 377,457 620,891 1.2%
Total $29,224,662 $22,808,801 $52,033,462 100.0%
Change in Cash and Investments by Fund :
Balance at Balance at Year-to-Date Year-to-Date
Fund January 1, 2022 March 31, 2022 Change ($)Change (%)
General Corporate $25,941,144 $29,698,252 $3,757,108 14.5%
Hotel/Motel Tax 1,754,745 1,823,693 68,948 3.9%
Motor Fuel Tax 1,153,550 1,315,265 161,715 14.0%
Infrastructure 10,880,028 12,115,168 1,235,140 11.4%
Promenade TIF 298,387 55,266 (243,121)-81.5%
Water 3,614,863 4,746,553 1,131,690 31.3%
Sports Core 576,566 770,485 193,919 33.6%
Golf Surcharge 278,773 281,686 2,913 1.0%
Self-Insurance 87,655 260,242 172,587 N/A
Garage 325,902 345,962 20,060 6.2%
Equipment Replacement 759,255 620,891 (138,364)-18.2%
45,670,868 $52,033,462 $6,362,594 13.9%
Book Bank/Market
Value Value
Cash and Cash Equivalents:
Pooled Checking $1,472,885 $1,944,721
Sports Core Checking 1,201,814 1,084,510
Pooled IPTIP 26,144,093 26,144,093
Water E-Pay IPTIP 405,871 389,842
29,224,662 $29,563,166
Pooled Investments:
Investments-Municipal Bonds $9,221,723 $8,994,664
Investments-Corporate Bonds 8,996,961 8,740,259
Government & Agency Obligations 2,743,382 2,623,130
Certificates of Deposit 1,715,000 1,666,974
Accrued Interest 131,735 131,735
Total Pooled Investments $22,808,801 $22,156,761
Total Cash and Investments $52,033,462 $51,719,928
Monthly Treasurer's Report
March 31, 2022
Monthly Treasurer's Report
March 2022
The table below lists the detail investment holdings at J.P. Morgan Securities as of 03/31/22:
Month End VOB
Settlement Maturity Coupon Yield Book Market Accrued
Type Date Date Rate Rate Value Value Interest
Municipal Bonds:
Bloomingdale Mich Pub Sch Dist #094383FS0 04/26/16 05/01/22 2.710%2.150%$500,164 500,685 $5,607
Laredo TX Waterworks #517039VW0 12/19/19 03/01/24 2.230%2.230%455,000 452,775 789
Oakland Univ Mich #673588HJ1 04/29/20 03/01/24 5.000%1.650%313,498 310,735 1,229
Philadelphia PA GO Ref #717813SW0 05/05/20 08/01/22 5.000%1.820%394,128 394,926 3,047
Maryland St DOT #574204WG4 05/06/20 06/15/22 4.350%1.200%261,718 261,854 3,214
University of CA #91412HFK4 07/16/20 05/15/23 0.628%0.628%25,000 24,636 59
New Jersey St #646039UD7 09/20/20 06/01/22 5.000%0.600%478,488 477,845 7,851
Rio Rancho NM #767175HM7 10/14/2020 5/15/2022 5.000%0.350%186,064 185,866 3,469
Cook, Kane, Lake, & McHenry #216181GL5 10/29/2020 12/15/2022 4.000%0.300%1,051,674 1,044,178 12,065
Miami-Dade Cnty #59333NN90 11/16/2020 12/15/2022 0.375%0.430%734,594 724,350 1,363
Hamilton NY #407741MC8 1/21/2021 5/1/2023 1.000%0.550%205,998 202,294 843
Southern Cal Pub Pwr #84247PHZ7 1/25/2021 4/1/2024 3.608%0.500%1,069,578 1,022,610 8,820
Hillsborough Cnty FL #43232VV3 3/11/2021 7/1/2024 1.815%0.770%511,661 489,020 2,193
Port Auth of NY and NJ #73358WAH7 4/15/2021 12/1/2024 5.859%0.600%569,564 539,210 9,602
City of Atlanta GA Water #047870SG6 4/19/2021 11/1/2024 0.616%0.500%250,744 237,440 625
West Contra Costa Cal Uni #9523474U3 6/17/2021 8/1/2024 0.575%0.575%500,000 476,285 823
New York NY City #64971XA40 10/7/2021 11/1/2024 0.450%0.620%711,881 672,050 1,323
NY Urban Dev Corp #650036AR7 11/5/2021 3/15/2023 0.720%0.451%501,286 494,090 150
Colorado Brdg Enterprise #19633SAZ6 11/24/2021 12/31/2023 0.923%0.844%500,682 483,815 1,167
Total Municipal Bonds $9,221,723 $8,994,664 $64,237
Corporate Bonds:
American Express #025816CD9 05/05/20 05/20/22 2.750%1.290%$501,025 500,355 $4,860
PNC Bank #69349LAK4 12/7/2020 1/30/2023 2.950%0.457%1,041,016 1,028,252 5,015
Wells Fargo #94974BFJ4 12/7/2020 2/13/2023 3.450%0.480%1,425,510 1,405,415 6,261
Comerica Bank #200340AS6 12/23/2020 7/31/2023 3.700%0.500%521,212 506,635 12,333
Bank of America #06048WM23 5/14/2021 5/14/2024 0.650%0.650%915,000 862,349 743
Goldman Sachs #38141GXE9 7/27/2021 2/20/2024 3.625%0.693%632,932 607,635 2,417
Goldman Sachs #38150AGU3 7/28/2021 7/28/2023 0.550%0.550%655,000 631,071 630
Morgan Stanley #61746BDQ6 7/28/2021 4/29/2024 3.875%0.547%1,068,635 1,020,103 16,361
Citigroup #17329UEH0 11/18/2021 11/18/2024 1.000%1.149%1,000,000 962,348 3,667
Bank New York Mellon #06406RAG2 1/25/2022 4/28/2023 3.500%0.810%720,153 709,459 10,344
Comerica Bank #200340AS6 1/25/2022 7/31/2023 3.700%1.200%516,477 506,635 (6,167)
Total Corporate Bonds $8,996,961 $8,740,259 $56,466
Government & Agency Obligations:
Government National Mtg Assn #38381WV96 08/06/19 07/20/54 2.250%2.293%116,303 114,452 90
Government National Mtg Assn #38380BNV3 12/05/19 06/20/46 2.000%2.112%325,764 314,880 408
Federal Home Loan Bank #3130AMVU3 06/29/21 06/29/26 0.500%0.500%500,000 473,577 625
Government National Mtg Assn #38383DWC8 12/14/2021 11/20/2056 1.250%1.379%940,564 862,403 1,023
Federal Home Loan Bank #313381BR5 2/25/2022 12/9/2022 1.875%0.900%860,750 857,818 4,898
Total Government & Agency Obligations:$2,743,382 $2,623,130 $7,045
Certificates of Deposit:
Capital One Natl Assn #14042TCZ8 04/01/20 04/01/22 1.350%1.350%245,000 245,006 1,640
Synchrony Bank #87164WZN1 04/03/20 04/04/22 1.350%1.350%245,000 245,025 1,622
Goldman Sachs 38149MXG3 07/28/21 07/29/24 0.550%0.550%245,000 235,506 230
Sallie Mae #795451AD5 07/28/21 07/29/24 0.600%0.600%245,000 235,782 251
Texas Exchange Bk #88241TLS7 07/30/21 07/30/24 0.500%0.500%245,000 235,179 6
Toyota Financial #89235MLF6 08/05/21 8/5/2024 0.550%0.550%245,000 235,384 200
UBS Bank #90348JT42 09/22/21 9/23/2024 0.650%0.650%245,000 235,092 38
Total Certificates of Deposits $1,715,000 $1,666,974 $3,987
Total J.P.Morgan Securities $22,677,066 $22,025,026 $131,735
This is a mortgage backed security that receives principal payments each month based on mortgage repayments. Monthly principal payments will vary and the
investment balance may be repaid before the maturity date.
VILLAGE OF OAK BROOK
Monthly Treasurer's Report
March 31, 2022
Cash & Investments by Fund - Total $52 million
Cash & Investments by Type - Total $52 million
General Corporate
57.1%
Hotel/Motel Tax
3.5%Motor Fuel Tax
2.5%
Infrastructure
23.3%
Promenade TIF
0.1%
Water
9.1%
Sports Core
1.5%
Golf Surcharge
0.5%
Self-Insurance
0.5%
Garage
0.7%
Equipment
Replacement
1.2%
Checking, $2.7
Illinois Funds, $26.5
Certificates of Deposit,
1.7
Municipal Bonds, $9.2
Corporate Bonds, $9.0
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)8,890,302$ 5,211,126$ 3,679,176$ 742,510$
Main operating fund of the Village.
Hotel Fund (Major Fund)207,547$ 100,476$ 107,072$ 72,930$
Collects and spends resources from the
3% hotel/motel tax.
Motor Fuel Tax Fund 161,715$ -$ 161,715$ 157,960$
Collects and spends resources from the
State motor fuel tax.
Infrastructure Fund (Major Fund)2,328,089$ 746,396$ 1,581,693$ 307,730$
Accounts for construction and maintenance of
roadways, drainage, and safety path systems.
Promenade TIF Fund (Major Fund)28$ 243,150$ (243,122)$ (220,640)$
Accounts for the revenues and expenditures
restricted to the Tax Increment Financing (TIF)
district located at 22nd St. and Meyers Rd.
Enterprise Funds
Water Fund (Major Fund)2,477,112$ 941,461$ 1,535,650$ 898,655$
Collects user fees for the distribution of water
and maintenance of infrastructure.
Sports Core Fund (Major Fund)558,182$ 321,183$ 237,000$ 48,370$
Accounts for revenues and expenses relating
to administration, programs, food and beverage
operations, and golf course.
Golf Surcharge Fund 2,913$ -$ 2,913$ (46,500)$
Accounts for the collection of the $3 per round
golf surcharge.
Internal Service Funds
Self Insurance Fund 998,625$ 850,503$ 148,122$ 66,675$
Accounts for the Village's health insurance costs
and the related contributions from the Village,
employees, retirees, and other agencies.
Garage Fund 155,444$ 148,239$ 7,205$ (17,760)$
Accounts for the maintenance of the Village's vehicle
fleet and the related departmental reimbursements.
Equipment Replacement Fund 231,116$ 369,480$ (138,364)$ (133,965)$
Accounts for the replacement of the Village's vehicle
fleet and the related departmental contributions.
Further information on the Village's major funds (as indicated above) can be found on the proceeding pages.
Executive Summary on Village Funds
Through March 31, 2022
Village of Oak Brook
Monthly Financial Report – Fund Narrative
For the Period Ending March 31, 2022
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 fund 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 March 2022 are $2,225,060, or 34.1%, higher than last March,
and $2,119,706, or 32%, over budget to date. The main drivers for this are:
o Sales tax revenue, the General Fund’s
largest revenue source, is up $1,640,362
from last year and $1,545,306 over
budget. March 2022 collections came in
at the highest level in the past five years.
o Other Intergovernmental Tax is up
215,844 from last year and $242,187
over budget. Receipts from Income Tax
and Replacement Tax came in higher than anticipated in March.
o The Telecommunication/Utility Tax is up $159,775 from last year and $200,474
over budget.
1.00
2.50
4.00
5.50
2018 2019 2020 20212022MillionsSales
Tax -March Collection
Last 5 Years
Total expenditures through March 2022 are $44,201, or 1%, lower than last year and
817,085, or 13.62%, under budget to date.
Hotel Tax Fund
Total revenues through March 2022 are $116,166, or 127.1%, higher than last year and
63,797, or 44.4%, over budget to date. The main drivers for this are:
o Hotel tax revenue is up$124,942 from last year and $67,594 over budget. Hotel
stay continues to recover from the effects of COVID-19 on the travel industry.
Total expenditures through March 2022 are $65,002 higher than last year and $29,656
over budget.
Infrastructure Fund
Total revenues through March 2022 are up
612,458, or 37.5%, from last year and
647,625 or 140.5%, over budget. The main
drivers for this are:
o Non-home rule sales tax revenue is up
613,623 from last year, and $646,946
over budget. March 2022 collections
came in at the highest level in the past
five years.
Total expenditures through March 2022 are down $739,732, or 50.8%, from last year and
626,336 or 46.6%, under budget to date. The main drivers for this are:
o Operation and contract expenditures are down $214,821 from last year and
214,821 under budget.
o Capital Outlay is down $692,497 from last year and $481,346 under budget.
Promenade TIF Fund
Total revenues through March 2022 are lower than last year and $ 22,482 or 99.9%,
under budget. Revenues are under budget due to the timing of information to record
the TIF sale tax transfer.
Total expenditures through March 2022 are up $14,900 from last year and even with
budget. The increase relates to more principal paid towards the TIF note compared to
last year.
Water Fund
Total revenues through March 2022 are up $215,993, or 9.6% higher than last year and
332,617, or 115.5%, over budget. The main drivers for this are:
1.00
1.50
2.00
2.50
2018 2019 2020 20212022MillionsNon-
Home Rule Sales Tax -March Collections
Last 5 Years
o Water sales revenue is up $266,981 from last year and $225,589 over budget.
Water gallons sold has also been slightly more than projected so far this year.
Total expenditures through March 2022 are down $529,881, or 38.8%, from last year and
304,372 or 26.7%, under budget. The main drivers for this are:
o Personnel expenditures are down $86,724 from last year and $53,585 under
budget.
o Capital outlay expenditures are down $504,267 from last year.
Sports Core Fund
Total revenues through March 2022 are up $109,982 or 24.5% higher than last year and
72,917, or 115% over budget to date. The main drivers for this are:
o Membership revenue is up $22,350 from last year but down $26,575 under
budget.
o Rentals are up by $125,724 from last year and 111,953 over budget.
Total expenditures through March 2022 are down $153,738, or 33.7%, from last year, and
165,711, or 4.4% under budget to date. The main drivers for this are:
o Personnel expenditure are down $10,403 from last year and $52,279 under
budget.
o Operation and contract expenditures are down $33,320 from last year and
12,262 under budget.
o Capital outlay expenditures are down $66,180 from last year, and $80,000 under
budget. Activity in the Sports Core Fund are expected to increase in the coming
month as preparation for the season begins.
3/31/22 3/31/22
3/31/21 3/31/22 YTD % of YTD 2022 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 3,719,944$ 5,360,306 3,815,000$ 140.5%13,200,000$ 1,640,362$
Other Intergovernmental Tax*417,193 633,037 390,850 162.0%1,618,400 215,844$
Telecommunications/Utility Tax 1,480,699 1,640,474 1,440,000 113.9%5,595,000 159,775$
Grants 12,043 733 - #DIV/0!15,000 (11,311)$
Licenses and Permits 543,390 395,284 457,875 86.3%2,007,510 (148,106)$
Charges for Services 161,457 504,475 265,465 190.0%1,154,900 343,018$
Fines and Penalties 40,559 21,636 34,430 62.8%142,000 (18,923)$
Administrative Towing Fees 8,579 11,000 6,255 175.9%25,000 2,421$
Investment Interest 52,409 22,701 36,000 63.1%144,000 (29,708)$
Franchise Fees - 53,735 49,500 108.6%198,000 53,735$
Miscellaneous Income 87,663 105,616 133,915 78.9%478,270 17,953$
Total Operating Revenues 6,523,936$ 8,748,996$ 6,629,290$ 132.0%24,578,080$ 2,225,060$
OPERATING EXPENDITURES
Personnel 4,144,371$ 4,164,609 4,538,390$ 91.8%19,596,700$ 20,238$
Materials and Supplies 88,329 105,067 170,185 61.7%541,780 16,738$
Operation and Contract 931,241 890,149 896,355 99.3%3,584,020 (41,092)$
Other Expenditures 2,173 2,142 2,250 95.2%9,000 (31)$
Capital Outlay 61,742 21,688 393,560 5.5%1,292,350 (40,054)$
Total Operating Expenditures 5,227,856$ 5,183,655$ 6,000,740$ 86.4%25,023,850$ (44,201)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 1,296,080$ 3,565,341$ 628,550$ (445,770)$ 2,269,261$
INTERFUND TRANSACTIONS
Transfers In -$ -$ -$ 0.0%-$ -$
Transfers Out -$ 0.0%-$
Reimbursements From Other Funds 148,419 141,306 141,300 100.0%565,220 (7,113)$
Reimbursements To Other Funds (26,472) (27,471) (27,340) 100.5%(109,880) (999)$
Sports Core Loan - 0.0%- -$
Total Interfund Transactions 121,947$ 113,835$ 113,960$ 99.9%455,340$ (8,112)$
NET FUND INCREASE (DECREASE)1,418,027$ 3,679,176$ 742,510$ 9,570$ 2,261,149$
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 March 31, 2022
Total Total
Revenues Expenditures
3/31/22 Actual 8,748,996$ 5,183,655$
3/31/21 Actual 6,523,936$ 5,227,856$
Change From Last Year 34.1%-0.8%
Major Revenues
Other Telecom/Utility Licenses &Charges for
Sales Tax Intergov. Tax Tax Permits Services
3/31/22 Actual 5,360,306$ 633,037$ 1,640,474$ 395,284$ 504,475$
3/31/21 Actual $ 3,719,944 $ 417,193 $ 1,480,699 $ 543,390 $ 161,457
Change From Last Year 44.1%51.7%10.8%-27.3%212.5%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
3/31/22 Actual 4,164,609$ 105,067$ 890,149$ 2,142$ 21,688$
3/31/21 Actual 4,144,371$ 88,329$ 931,241$ 2,173$ 61,742$
Change From Last Year 0.5%18.9%-4.4%-1.4%-64.9%
Five Year Trend
Expenditures by Department
3/31/21 3/31/22 3/31/22 3/31/22 2022 Difference Five
YTD YTD YTD % of Annual Prior Year
Department Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 555,439$ 555,048$ 784,905$ 70.7%3,002,480$ (391)$
Financial Services 178,532 207,071 194,640 106.4%827,030 28,539
Public Works 223,019 157,826 183,560 86.0%928,765 (65,193)
Engineering & Capital Projects 4,547 11,172 139,000 8.0%384,000 6,625
Library 206,516 233,222 239,800 97.3%996,145 26,706
Police 2,034,356 2,185,963 2,336,800 93.5%9,869,105 151,607
Fire 1,767,963 1,611,145 1,872,020 86.1%7,922,040 (156,818)
Development Services 257,484 222,207 250,015 88.9%1,094,285 (35,277)
Total Expenditures 5,227,856$ 5,183,655$ 6,000,740$ 86.4%25,023,850$ (44,201)$
Five Year Trend
For the Period Ending March 31, 2022
General Fund - Five Year Trend
Village of Oak Brook
Revenues Expenditures
3/31/22 3/31/22
3/31/21 3/31/22 YTD % of YTD 2022 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Hotel Tax 81,152$ 206,094 138,500$ 148.8%773,500$ 124,942$
Investment Interest 10,229 1,453 5,250 27.7%21,000 (8,776)
Loan Interest - #DIV/0!6,000 -
Total Operating Revenues 91,381$ 207,547$ 143,750$ 144.4%800,500$ 116,166$
EXPENDITURES
Operation and Contract 14,774$ 27,080 50,120$ 54.0%289,985$ 12,306$
Capital Outlay - 52,696 #DIV/0!- 52,696
Total Expenditures 14,774$ 79,776$ 50,120$ 159.2%289,985$ 65,002$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 76,607$ 127,772$ 93,630$ 136.5%510,515$ 51,165$
INTERFUND TRANSACTIONS
Transfer Out -$ -$ -$ #DIV/0!(193,375)$ -$
Reimbursements to Other Funds (21,021) (20,700) (20,700) 100.0%(82,800) 321
Total Interfund Transactions (21,021)$ (20,700)$ (20,700)$ 100.0%(276,175)$ 321$
NET FUND INCREASE (DECREASE)55,586$ 107,072$ 72,930$ 234,340$ 51,486$
Note - Expenditures are recorded in program 171.
Village of Oak Brook
Hotel Tax Fund Financial Update
For the Period Ending March 31, 2022
Total Total
Revenues Expenditures
3/31/22 Actual $ 207,547 79,776$
3/31/21 Actual $ 91,381 14,774$
Change From Last Year 127.1%440.0%
Major Revenues Investment
Hotel Tax Interest Loan Interest Miscellaneous
3/31/22 Actual $ 206,094 $ 1,453 -$ -$
3/31/21 Actual $ 81,152 $ 10,229 -$ -$
Change From Last Year 154.0%-85.8%0.0%0.0%
Five Year Trend
Major Expenditures Operation &
Contractual Capital Outlay
3/31/22 Actual 27,080$ 52,696$
3/31/21 Actual 14,774$ -$
Change From Last Year 83.3%#DIV/0!
Five Year Trend
Village of Oak Brook
Hotel Tax Fund - Major Sources Five Year Trend
For the Period Ending March 31, 2022
Five Year Trend
Revenues Expenditures
3/31/22 3/31/22
3/31/21 3/31/22 YTD % of YTD 2022 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Non-Home Rule Sales Tax 1,625,823$ 2,239,446 1,592,500$ 102.1%5,815,000$ 613,623$
Investment Interest 8,964 7,799 6,870 130.5%27,500 (1,165)$
Grants - - - 1,089,730 -$
Miscellaneous - - 250 0.0%1,000 -$
Total Operating Revenues 1,634,787$ 2,247,245$ 1,599,620$ 140.5%6,933,230$ 612,458$
OPERATING EXPENDITURES
Personnel 352,232$ 373,329$ 315,610$ 118.3%1,292,835$ 21,097$
Materials and Supplies 121,833 113,832 101,720 111.9%226,600 (8,001)
Operation and Contract 271,380 211,049 425,870 49.6%1,730,180 (60,331)
Capital Outlay 711,151 18,654 500,000 3.7%9,226,320 (692,497)
Total Operating Expenditures 1,456,596$ 716,864$ 1,343,200$ 53.4%12,475,935$ (739,732)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 178,191$ 1,530,381$ 256,420$ 596.8%(5,542,705)$ 1,352,190$
INTERFUND TRANSACTIONS
Transfers In -$ -$ 0.0%423,375$ -$
Reimbursements From Other Funds 82,962 80,844 80,835 100.0%323,365 (2,118)
Reimbursements To Other Funds (44,076) (29,532) (29,525) 100.0%(118,130) 14,544
Total Interfund Transactions 38,886$ 51,312$ 51,310$ 100.0%628,610$ 12,426$
NET FUND INCREASE (DECREASE)217,077$ 1,581,693$ 307,730$ (4,914,095)$ 1,364,616$
Village of Oak Brook
Infrastructure Fund Financial Update
For the Period Ending March 31, 2022
Total Total
Revenues Expenditures
3/31/22 Actual $ 2,247,245 716,864$
3/31/21 Actual $ 1,634,787 1,456,596$
Change From Last Year 37.5%-50.8%
Major Revenues
Sales Tax
Charges for
Services
Investment
Interest Miscellaneous
3/31/22 Actual $ 2,239,446 $ - $ 7,799 $ -
3/31/21 Actual $ 1,625,823 $ - $ 8,964 $ -
Change From Last Year 37.7%0.0%-13.0%0.0%
Five Year Trend
Major Expenditures Materials &Operation &
Personnel Supplies Contractual Capital Outlay
3/31/22 Actual 373,329$ 113,832$ 211,049$ 18,654$
3/31/21 Actual 352,232$ 121,833$ 271,380$ 711,151$
Change From Last Year 6.0%-6.6%-22.2%-97.4%
Five Year Trend
Expenditures by Department
3/31/21 3/31/22 3/31/22 3/31/22 2022 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 36,285$ 28,892$ 52,010$ 55.5%209,510$ (7,394)$
Public Works 651,848 589,033 584,365 100.8%2,380,195 (62,815)
Engineering & Capital Projects 768,463 98,940 706,825 14.0%9,886,230 (669,523)
Total Expenditures 1,456,596$ 716,864$ 1,343,200$ 53.4%12,475,935$ (739,732)$
Five Year Trend
Village of Oak Brook
Infrastructure Fund - Major Sources Five Year Trend
For the Period Ending March 31, 2022
Revenues Expenditures
3/31/22 3/31/22
3/31/21 3/31/22 YTD % of YTD 2022 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 9,944$ -$ 22,500$ 0.0%90,000$ (9,944)$
Real Estate Tax - 0.0%405,000 -
Investment Interest 22 28 10 283.4%50 6
Total Operating Revenues 9,966$ 28$ 22,510$ 0.126%495,050$ (9,938)$
EXPENDITURES
Operation and Contract -$ 0.0%3,900$ -$
Other Expenditures 228,250 243,150 243,150 100.0%486,255 14,900
Total Expenditures 228,250$ 243,150$ 243,150$ 100.0%490,155$ 14,900$
NET FUND INCREASE (DECREASE)(218,284)$ (243,122)$ (220,640)$ 4,895$ (24,838)$
Note - Expenditures are recorded in program 283.
Village of Oak Brook
Promenade TIF Fund Financial Update
For the Period Ending March 31, 2022
Total Total
Revenues Expenditures
3/31/22 Actual $ 28 243,150$
3/31/21 Actual $ 9,966 228,250$
Change From Last Year -99.7%6.5%
Major Revenues Real Estate Investment
Sales Tax Tax Interest
3/31/22 Actual -$ $ - $ 28
3/31/21 Actual 9,944$ $ - $ 22
Change From Last Year -100.0%0.0%28.8%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures
3/31/22 Actual -$ 243,150$
3/31/21 Actual -$ 228,250$
Change From Last Year 0.0%6.5%
Five Year Trend
Village of Oak Brook
Promenade TIF Fund - Major Sources Five Year Trend
For the Period Ending March 31, 2022
Five Year Trend
Revenues Expenditures
3/31/22 3/31/22
3/31/21 3/31/22 YTD % of YTD 2022 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Plan Review Fees 75$ 225$ 255$ 88.2%1,000$ 150$
Building/Inspection Fees 638 375 1,245 30.1%5,000 (263)
Water Sales 2,051,108 2,318,089 2,092,500 110.8%10,484,500 266,981
Unmetered Sales 2,400 40,154 12,495 321.4%50,000 37,754
Water Connection Fees 74,750 83,490 18,750 445.3%75,000 8,740
Meter Charges 1,518 4,100 3,750 109.3%15,000 2,582
Special Services 765 - 500 N/A 25,000 (765)
Investment Interest 14,074 4,740 7,500 63.2%30,000 (9,334)
Miscellaneous 115,791 25,938 7,500 345.8%30,000 (89,853)
Total Operating Revenues 2,261,119$ 2,477,112$ 2,144,495$ 115.5%10,715,500$ 215,993$
OPERATING EXPENDITURES
Personnel 184,834$ 98,110$ 151,695$ 64.7%647,620$ (86,724)$
Materials and Supplies 37,265 37,220 18,175 204.8%69,650 (45)
Operation and Contract 635,959 697,114 970,840 71.8%5,400,625 61,155
Capital Outlay 508,161 3,894 - #DIV/0!3,925,000 (504,267)
Total Expenditures 1,366,219$ 836,338$ 1,140,710$ 73.3%10,042,895$ (529,881)$
Surplus (Deficit) of Revenues Over
Expenditures 894,900$ 1,640,773$ 1,003,785$ 163.5%672,605$ 745,873$
INTERFUND TRANSACTIONS
Reimbursements To Other Funds (112,626)$ (105,123)$ (105,130)$ 100.0%(420,490)$ 7,503$
Total Interfund Transactions (112,626)$ (105,123)$ (105,130)$ 100.0%(420,490)$ 7,503$
Fund Increase/(Decrease) - Budgetary Basis 782,274$ 1,535,650$ 898,655$ 170.9%252,115$ 753,376$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay 508,161$ 3,894$
Depreciation Expense (143,750) (143,750)
IMRF Pension Expense (11,250) (11,250)
OPEB Expense (7,500) (7,500)
Total GAAP Adjustments 345,661$ (158,606)$
Fund Increase/(Decrease) - GAAP Basis 1,127,935$ 1,377,044$
Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.
Village of Oak Brook
Water Fund Financial Update
For the Period Ending March 31, 2022
Total Total
Revenues Expenditures
3/31/22 Actual $ 2,477,112 836,338$
3/31/21 Actual $ 2,261,119 1,366,219$
Change From Last Year 9.6%-38.8%
Unmetered Water
Water Sales Sales Connection Fees Meter Charges Miscellaneous
3/31/22 Actual $ 2,318,089 $ 40,154 $ 83,490 $ 4,100 $ 25,938
3/31/21 Actual $ 2,051,108 $ 2,400 $ 74,750 $ 1,518 $ 115,791
Change From Last Year 13.0%1573.1%11.7%170.1%-77.6%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
3/31/22 Actual 98,110$ 37,220$ 697,114$ -$ 3,894$
3/31/21 Actual 184,834$ 37,265$ 635,959$ -$ 508,161$
Change From Last Year -46.9%-0.1%9.6%0.0%-99.2%
Five Year Trend
Expenditures by Department
3/31/21 3/31/22 3/31/22 3/31/22 2022 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Public Works 838,833$ 813,074$ 1,140,710$ 73.5%6,067,895$ 25,759$
Engineering & Capital Projects 527,386 23,265 - #DIV/0!3,975,000 504,122
Total Expenditures 1,366,219$ 836,338$ 1,140,710$ 73.3%10,042,895$ 529,881$
Five Year Trend
Village of Oak Brook
Water Fund - Major Sources Five Year Trend
For the Period Ending March 31, 2022
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Sports Core Fund Consolidated Presentation
For the Period Ending March 31, 2022
3/31/22 3/31/22
3/31/22 YTD % of YTD 2022 3/31/21 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 450$ -$ -$ 277,675$ 278,125$ 304,700$ 91.3%801,750$ 255,775$ 22,350$
Greens Fees - - - 23,242 23,242 36,000 64.6%1,145,000 35,969 (12,727)
Pro Shop Sales - - - 25,161 25,161 21,910 114.8%210,000 23,888 1,273
Golf Lessons - - - 10,050 10,050 7,000 143.6%50,000 11,310 (1,260)
Driving Range Fees - - - 57,525 57,525 63,000 91.3%300,000 72,300 (14,775)
Rentals - 131,393 7,344 7,491 146,228 34,275 426.6%993,775 20,504 125,724
Programs/User Fees - - - - - - 0.0%15,500 - -
Food Sales - - - 6,136 6,136 6,440 95.3%286,000 7,226 (1,090)
Beverage Sales - - - 11,638 11,638 11,500 101.2%490,000 12,192 (554)
Taste of Oak Brook - - - - - - 0.0%120,000 - -
Grants - - - - - - 0.0%- - -
Other Revenue 79 - - - 79 440 17.8%8,000 9,036 (8,957)
Total Operating Revenues 529$ 131,393$ 7,344$ 418,917$ 558,182$ 485,265$ 115.0%4,420,025$ 448,200$ 109,982$
OPERATING EXPENDITURES
Personnel 249$ -$ 28,268$ 156,739$ 185,256$ 237,535$ 78.0%1,671,380$ 195,659$ (10,403)$
Materials & Supplies 154 - 14 14,112 14,281 59,975 23.8%718,900 58,116 (43,835)
Operational & Contractual 26,740 13,849 9,359 52,834 102,782 90,520 113.5%942,765 136,102 (33,320)
Other - - - - - - 0.0%- - -
Capital (1,949) - 1,949 - (0) 80,000 0.0%466,750 66,180 (66,180)
Total Operating Expenditures 25,193$ 13,849$ 39,590$ 223,686$ 302,319$ 468,030$ 64.6%3,799,795$ 456,057$ (153,738)$
B&T Administration Overhead Allocation*-$ -$ -$ -$ -$ -$ 0.0%-$ -$ -$
Operating Revenues Over (Under) Expenditures (24,665)$ 117,544$ (32,246)$ 195,231$ 255,864$ 17,235$ 1484.6%620,230$ (7,857)$ 263,721$
INTERFUND TRANSACTIONS
Interfund Loan**-$ -$ -$ -$ -$ -$ 0.0%-$ -$ -$
Transfer From General Fund - - - - - - 0.0%- - -
Transfer From Golf Surcharge Fund - - - - - 50,000 0.0%150,000 - -
Reimbursement From Infrastructure Fund - - - - - - #DIV/0!- 8,000 (8,000)
Reimbursement From Water Fund - - - - - - #DIV/0!- 2,002 (2,002)
Reimbursement To General Fund (4,716) - - (14,148) (18,864) (18,865) 100.0%(75,455) 30,761 (49,625)
Total Interfund Transactions (4,716)$ -$ -$ (14,148)$ (18,864)$ 31,135$ -60.6%74,545$ 40,763$ (59,627)$
Total Revenues Over (Under) Expenditures - Budgetary Basis (29,381)$ 117,544$ (32,246)$ 181,083$ 237,000$ 48,370$ 694,775$ 32,906$ 204,094$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay (1,949)$ -$ 1,949$ -$ (0)$ 131,962$
Depreciation Expense (42,057) (421) - (61,575) (104,053) (176,531)
IMRF Pension Expense (513) - - (6,125) (6,638) (8,651)
OPEB Expense - - - (7,000) (7,000) (8,500)
Total GAAP Adjustments (44,519)$ (421)$ 1,949$ (74,700)$ (117,691)$ (61,720)$
Fund Increase/(Decrease) - GAAP Basis (73,899)$ 117,122$ (30,297)$ 106,383$ 119,309$ (28,814)$
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
3/31/22 Actual $ 558,182 302,319$
3/31/21 Actual $ 448,200 456,057$
Change From Last Year 24.5%-33.7%
Driving Program/
Memberships Greens Fees Range Fees Rentals User Fees
3/31/22 Actual $ 278,125 $ 23,242 $ 57,525 $ 146,228 -$
3/31/21 Actual $ 255,775 $ 35,969 $ 72,300 $ 20,504 -$
Change From Last Year 8.7%-35.4%N/A 613.2%0.0%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
3/31/22 Actual 185,256$ 14,281$ 102,782$ -$ (0)$
3/31/21 Actual 195,659$ 58,116$ 136,102$ -$ 66,180$
Change From Last Year -5.3%-75.4%-24.5%0.0%-100.0%
Five Year Trend
Revenues by Department 3/31/21 3/31/22 3/31/22 3/31/22 2022 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Operations 6,899$ 529$ 63,140$ 0.8%521,450$ (6,370)$
Open Field Operations 7,500 131,393 3,000 4379.8%375,000 123,893
B&T Clubhouse Operations - 7,344 21,275 34.5%351,275 7,344
Golf Club 433,801 418,917 397,850 105.3%3,172,300 (14,884)
Total Revenues 448,200$ 558,182$ 485,265$ 115.0%4,420,025$ 109,982$
Expenditures by Department 3/31/21 3/31/22 3/31/22 % of YTD 2022 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Operations 97,657$ 25,193$ 40,240$ 62.6%567,180$ (72,464)$
Open Field Operations 26,082$ 13,849$ 11,255$ 123.0%250,660$ (12,233)$
B&T Clubhouse Operations 32,638 39,590 63,215 62.6%298,200 6,952
Golf Club 299,680 223,686 353,320 63.3%2,683,755 (75,994)
Total Expenditures 456,057$ 302,319$ 468,030$ 64.6%3,799,795$ (153,738)$
Five Year Trend
Village of Oak Brook
Sports Core Fund - Major Sources Five Year Trend
For the Period Ending March 31, 2022
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Club Recreation Operations
For the Period Ending March 31, 2022 3/31/22 3/31/22
822 3/31/22 YTD % of YTD 2022 3/31/21 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 -$ 450$ - - 450$ 62,900$ 0.7%448,950$ -$ 450$
Programs/User Fees - - - - -$ - #DIV/0!15,500 - -
Food Sales - - - - -$ - #DIV/0!36,000 - -
Beverage Sales - - - - -$ - #DIV/0!20,000 - -
Grants - - - - -$ - #DIV/0!- - -
Other Revenue 79 - - - 79$ 240 32.7%1,000 6,899 (6,820)
Total Operating Revenues 79$ 450$ -$ -$ 529$ 63,140$ 0.8%521,450$ 6,899$ (6,370)$
OPERATING EXPENDITURES
Personnel 249$ - - - 249$ 9,340$ 2.7%127,350$ -$ 249$
Materials & Supplies 109 - 45 - 154$ 8,620 1.8%74,550 14,038 (13,884)
Operational & Contractual 7,616 18,526 339 258 26,740$ 18,215 146.8%307,530 17,837 8,903
Capital (3,899) 1,404 390 156 (1,949)$ 4,065 -48.0%57,750 65,782 (67,731)
Total Operating Expenditures 4,075$ 19,930$ 774$ 414$ 25,193$ 40,240$ 62.6%567,180$ 97,657$ (72,464)$
B&T Administration Overhead Allocation*-$ -$ -$ -$ -$ -$ #DIV/0!68,810$ 9,984$ (9,984)$
Operating Revenues Over (Under) Expenditures (3,997)$ (19,480)$ (774)$ (414)$ (24,665)$ 22,900$ -107.7%23,080$ (80,774)$ 56,109$
Reimbursement From Infrastructure Fund - - - - - - #DIV/0!- 8,000 (8,000)
Reimbursement From Water Fund - - - - - - #DIV/0!- 2,002 (2,002)
Reimbursement To General Fund (4,716) - - - (4,716) (4,710) 100.1%(18,865) (3,930) (786)
Total Interfund Transactions (4,716)$ -$ -$ -$ (4,716)$ (4,710)$ 100.1%(18,865)$ 6,072$ (10,788)$
Total Revenues Over (Under) Expenditures - Budgetary Basis (8,713)$ (19,480)$ (774)$ (414)$ (29,381)$ 18,190$ 4,215$ (74,702)$ 45,321$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay (3,899)$ 1,404$ 390$ 156$ (1,949)$ 65,782$
Depreciation Expense (16,090) (25,000) (675) (292) (42,057) (42,057)
IMRF Pension Expense (500) - - (13) (513) (513)
Total GAAP Adjustments (20,488)$ (23,596)$ (285)$ (149)$ (44,519)$ 23,213$
Fund Increase/(Decrease) - GAAP Basis (29,201)$ (43,076)$ (1,060)$ (563)$ (73,899)$ (51,489)$
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 March 31, 2022 3/31/22 3/31/22
3/31/22 YTD % of YTD 2022 3/31/21 Difference
815 816 YTD Amended Amended Adopted YTD Prior
Polo Open Fields Total Budget Budget Budget Total Year
OPERATING REVENUES
Field Rentals -$ 51,393$ 51,393$ 3,000$ 1713.1%170,000$ 7,500$ 43,893$
Range Rentals - 80,000 80,000 - 0.0%85,000 - 80,000
Taste of Oak Brook - - - 0.0%120,000 - -
Other Revenue - - 0.0%- - -
Total Operating Revenues -$ 131,393$ 131,393$ 3,000$ 4379.8%375,000$ 7,500$ 123,893$
OPERATING EXPENDITURES
Personnel -$ -$ -$ 0.0%-$ -$
Materials & Supplies - - - 100 0.0%1,500$ - -
Operational & Contractual - 13,849 13,849 11,155 124.2%249,160 26,082 (12,233)
Capital - - 0.0%- -
Total Operating Expenditures -$ 13,849$ 13,849$ 11,255$ 123.0%250,660$ 26,082$ (12,233)$
Operating Revenues Over (Under) Expenditures -$ 117,544$ 117,544$ (8,255)$ -1423.9%124,340$ (18,582)$ 136,126$
INTERFUND TRANSACTIONS
Transfer From Hotel Tax Fund -$ -$ -$ -$ 0.0%-$ -$ -$
Total Interfund Transactions -$ -$ -$ -$ 0.0%-$ -$ -$
Total Revenues Over (Under) Expenditures - Budgetary Basis -$ 117,544$ 117,544$ (8,255)$ 124,340$ (18,582)$ 136,126$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay -$ -$ -$ -$
Depreciation Expense - (421) (421) (421)
Total GAAP Adjustments -$ (421)$ (421)$ (421)$
Fund Increase/(Decrease) - GAAP Basis -$ 117,122$ 117,122$ (19,003)$
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 March 31, 2022
3/31/22 3/31/22
821 YTD % of YTD 2022 3/31/21 Difference
B&T Amended Amended Adopted YTD Prior
Clubhouse Budget Budget Budget Total Year
OPERATING REVENUES
Rentals 7,344$ 21,275$ 34.5%351,275$ -$ 7,344$
Total Operating Revenues 7,344$ 21,275$ 34.5%351,275$ -$ 7,344$
OPERATING EXPENDITURES
Personnel 28,268$ 28,030$ 100.8%140,250$ 25,017$ 3,251$
Materials & Supplies 14 3,445 0.4%15,350 1,459 (1,445)
Operational & Contractual 9,359 15,805 59.2%92,600 6,162 3,197
Capital 1,949 15,935 12.2%50,000 - 1,949
Total Operating Expenditures 39,590$ 63,215$ 62.6%298,200$ 32,638$ 6,952$
B&T Administration Overhead Allocation*-$ -$ #DIV/0!(68,810)$ (9,984)$ 9,984$
Operating Revenues Over (Under) Expenditures (32,246)$ (41,940)$ 76.9%(15,735)$ (42,622)$ 10,376$
INTERFUND TRANSACTIONS
Transfer From General Fund -$ -$ 0.0%-$ -$ -$
Total Interfund Transactions -$ -$ 0.0%-$ -$ -$
Total Revenues Over (Under) Expenditures - Budgetary Basis (32,246)$ (41,940)$ (15,735)$ (42,622)$ 10,376$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 1,949$ -$
Depreciation Expense (15,000)
IMRF Pension Expense (750)
OPEB Expense (750)
Total GAAP Adjustments 1,949$ (16,500)$
Fund Increase/(Decrease) - GAAP Basis (30,297)$ (59,122)$
Overhead allocation is comprised of salaries, business forms, liability insurance, building & grounds maintenance and bank service fees in Program 811 -
Sports Core General Operations distributed to various Sports Core Programs on a percentage basis.
Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.
Village of Oak Brook
Monthly Operating Statement
Golf Club Programs
For the Period Ending March 31, 2022
3/31/22 3/31/22
823 831 832 833 834 3/31/22 YTD % of YTD 2022 3/31/21 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 -$ 277,675$ -$ -$ -$ 277,675$ 241,800$ 114.8%352,800$ 255,775$ 21,900$
Greens Fees - 23,242 - - - 23,242 36,000 64.6%1,145,000 35,969 (12,727)
Pro Shop Sales - 25,161 - - - 25,161 21,910 114.8%210,000 23,888 1,273
Golf Lessons - - 10,050 - - 10,050 7,000 143.6%50,000 11,310 (1,260)
Driving Range Fees - - 57,525 - - 57,525 63,000 91.3%300,000 72,300 (14,775)
Rentals - 15 - 7,476 - 7,491 10,000 74.9%387,500 13,004 (5,514)
Food Sales 6,136 - - - - 6,136 6,440 95.3%250,000 7,226 (1,090)
Beverage Sales 11,638 - - - - 11,638 11,500 101.2%470,000 12,192 (554)
Other Revenue - - - - - - 200 0.0%7,000 2,137 (2,137)
Total Operating Revenues 17,774$ 326,093$ 67,575$ 7,476$ -$ 418,917$ 397,850$ 105.3%3,172,300$ 433,801$ (14,884)$
OPERATING EXPENDITURES
Personnel 14,610$ 91,361$ -$ -$ 50,767$ 156,739$ 200,165$ 78.3%1,403,780$ 170,642$ (13,903)$
Materials & Supplies 11,238 (13,308) 6,180 1,368 8,634 14,112 47,810 29.5%627,500 42,619 (28,507)
Operational & Contractual 1,129 34,541 606 1,352 15,206 52,834 45,345 116.5%293,475 86,021 (33,187)
Other - - - - - - - 0.0%- - -
Capital - - - - - - 60,000 0.0%359,000 398 (398)
Total Operating Expenditures 26,977$ 112,595$ 6,786$ 2,721$ 74,608$ 223,686$ 353,320$ 63.3%2,683,755$ 299,680$ (75,994)$
Operating Revenues Over (Under) Expenditures (9,203)$ 213,498$ 60,789$ 4,755$ (74,608)$ 195,231$ 44,530$ 438.4%488,545$ 134,121$ 61,110$
INTERFUND TRANSACTIONS
Transfer from Golf Surcharge -$ -$ -$ -$ -$ -$ 50,000$ 0.0%150,000$ -$ -$
Reimbursement to General Fund - (14,148) - - - (14,148) (14,155) 100.0%(56,590) 34,691 (48,839)
Total Interfund Transactions -$ (14,148)$ -$ -$ -$ (14,148)$ 35,845$ -39.5%93,410$ 34,691$ (48,839)$
Total Revenues Over (Under) Expenditures - Budgetary Basis (9,203)$ 199,350$ 60,789$ 4,755$ (74,608)$ 181,083$ 80,375$ 581,955$ 168,812$ 12,271$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay -$ -$ -$ -$ -$ -$ 66,180$
Depreciation Expense (250) (26,250) (575) (3,250) (31,250) (61,575) (119,053)
IMRF Pension Expense (625) (2,500) (250) - (2,750) (6,125) (7,388)
OPEB Expense (750) (3,750) - - (2,500) (7,000) (7,750)
Total GAAP Adjustments (1,625)$ (32,500)$ (825)$ (3,250)$ (36,500)$ (74,700)$ (68,011)$
Fund Increase/(Decrease) - GAAP Basis (10,828)$ 166,850$ 59,964$ 1,505$ (111,108)$ 106,383$ 100,801$
Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.