03 - March 2021 Monthly Financial ReportVILLAGE
OAK BROOK
OF
MONTHLY FINANCIAL REPORTS
MARCH 2021
Cash and Investments by Fund:Total
Cash and Cash Pooled Cash and
Fund Equivalents Investments Investments % By Fund
General Corporate $11,475,190 $14,108,190 $25,583,380 54.7%
Hotel/Motel Tax 2,000,480 2,658,393 4,658,873 10.0%
Motor Fuel Tax 797,409 33,407 830,816 1.8%
Infrastructure 4,776,718 2,243,314 7,020,032 15.0%
Promenade TIF 49,016 - 49,016 0.1%
Water 3,278,722 3,690,714 6,969,436 14.9%
Sports Core 73,014 - 73,014 0.2%
Golf Surcharge 137,177 - 137,177 0.3%
Self-Insurance 403,851 - 403,851 0.9%
Garage 302,359 - 302,359 0.6%
Equipment Replacement 323,941 401,647 725,588 1.6%
Total $23,617,877 $23,135,665 $46,753,542 100.0%
Change in Cash and Investments by Fund :
Balance at Balance at Year-to-Date Year-to-Date
Fund January 1, 2021 March 31, 2021 Change ($)Change (%)
General Corporate $23,894,312 $25,583,380 $1,689,068 7.1%
Hotel/Motel Tax 4,567,176 4,658,873 91,697 2.0%
Motor Fuel Tax 673,455 830,816 157,361 23.4%
Infrastructure 7,480,975 7,020,032 (460,943)-6.2%
Promenade TIF 267,300 49,016 (218,284)-81.7%
Water 6,900,169 6,969,436 69,267 1.0%
Sports Core 114,133 73,014 (41,119)-36.0%
Golf Surcharge 132,593 137,177 4,584 3.5%
Self-Insurance 0 403,851 403,851 N/A
Garage 298,348 302,359 4,011 1.3%
Equipment Replacement 696,392 725,588 29,196 4.2%
$45,024,853 $46,753,542 $1,728,689 3.8%
Book Bank/Market
Value Value
Cash and Cash Equivalents:
Pooled Checking $933,201 $1,216,649
Sports Core Checking 437,060 400,528
Pooled IPTIP 21,893,000 21,893,000
Water E-Pay IPTIP 354,616 337,960
$23,617,877 $23,848,137
Pooled Investments:
Investments-Municipal Bonds $10,717,211 $10,774,500
Investments-Corporate Bonds 7,497,743 7,531,063
Government & Agency Obligations 1,326,675 1,353,400
Certificates of Deposit 3,430,000 3,457,612
Accrued Interest 164,036 164,036
Total Pooled Investments $23,135,665 $23,280,611
Total Cash and Investments $46,753,542 $47,128,748
For March, total interest revenue is $27,972 and YTD is $87,571. The total investment yield for the portfolio is:
Pooled
Investments Illinois Funds Total
Last 12 months yield 1.82%0.28%1.11%
The weighted average yield of the current investment portfolio is 1.41%. The IL Funds March average daily rate was 0.060%.
Monthly Treasurer's Report
March 31, 2021
Monthly Treasurer's Report
March 2021
The table below lists the detail investment holdings at J.P. Morgan Securities as of 3/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,041 $200,310 $1,944
Bloomingdale Mich Pub Sch Dist #094383FS0 04/26/16 05/01/22 2.710%2.150%502,929 512,230 5,607
Connecticut St GO Bds 2016 #20772J3F7 06/15/17 08/15/21 1.750%2.300%499,010 502,680 1,065
State of IL #452152P54 10/09/19 11/01/21 5.000%1.870%509,095 512,635 10,166
Anchor Bay Mich Sch #032879TE8 11/01/19 05/01/21 2.320%1.750%715,349 716,087 6,773
Brownsville TX #16405ST9 12/19/19 02/15/22 2.050%2.000%555,230 562,859 1,296
Laredo TX Waterworks #517039VW0 12/19/19 03/01/24 2.230%2.230%455,000 472,431 789
Oakland Univ Mich #673588HJ1 04/29/20 03/01/24 5.000%1.650%322,990 332,607 1,229
Philadelphia PA GO Ref #717813SW0 05/05/20 08/01/22 5.000%1.820%406,334 413,045 3,047
Maryland St DOT #574204WG4 05/06/20 06/15/22 4.350%1.200%269,834 272,579 3,214
University of CA #91412HFK4 07/16/20 05/15/23 0.628%0.628%25,000 25,137 59
Windsor NY Sch Dist #973675EW7 07/23/02 06/17/21 1.500%0.400%476,082 476,050 4,922
Waterford Mich Sch Dist #941468YZ7 08/20/20 08/24/21 4.000%0.301%507,335 507,095 12,258
Weedsport NY Cent Sch Dist #948543KA0 08/21/20 08/20/21 1.000%0.570%500,823 500,040 3,051
Universty of IL #914353YH4 08/31/20 10/01/21 3.000%0.701%252,859 253,195 3,750
New Jersey St #646039UD7 09/20/20 06/01/22 5.000%0.600%499,299 500,446 7,851
Alaska St GO #011770Z72 10/14/2020 8/1/2021 5.000%0.252%177,788 177,744 1,434
Rio Rancho NM #767175HM7 10/14/2020 5/15/2022 5.000%0.350%194,646 194,894 3,469
Cook, Kane, Lake, & McHenry #216181GL5 10/29/2020 12/15/2022 4.000%0.300%1,089,458 1,092,302 17,304
Miami-Dade Cnty #59333NN90 11/16/2020 12/15/2022 0.375%0.430%734,192 735,169 1,370
Hamilton NY #407741MC8 1/21/2021 5/1/2023 1.000%0.550%206,913 206,515 387
Southern Cal Pub Pwr #84247PHZ7 1/25/2021 4/1/2024 3.608%0.500%1,100,227 1,093,470 8,820
Hillsborough Cnty FL #43232VV3 3/11/2021 7/1/2024 1.815%0.770%516,774 514,980 2,193
Total Municipal Bonds $10,717,211 $10,774,500 $101,998
Corporate Bonds:
Morgan Stanley #61747WAL3 03/08/19 07/28/21 5.500%3.034%1,058,002 1,067,252 9,946
Citigroup #172967LC3 04/01/19 12/08/21 2.900%2.754%1,001,077 1,015,890 8,539
American Honda #02665WBG5 07/31/19 09/09/21 1.700%2.180%498,979 503,145 542
JP Morgan #48128BAB7 09/30/19 01/15/23 2.972%2.337%1,011,012 1,020,130 6,274
American Express #025816CD9 05/05/20 05/20/22 2.750%1.290%508,261 512,445 4,861
Goldman Sachs #38141GGQ1 08/31/20 07/27/21 5.250%0.251%350,547 350,320 3,220
PNC Bank #69349LAK4 12/7/2020 1/30/2023 2.950%0.457%1,066,286 1,063,217 5,015
Wells Fargo #94974BFJ4 12/7/2020 2/13/2023 3.450%0.480%1,466,516 1,464,059 6,261
Comerica Bank #200340AS6 12/23/2020 7/31/2023 3.700%0.500%537,063 534,605 3,083
Total Corporate Bonds $7,497,743 $7,531,063 $47,741
Government & Agency Obligations:
*Government National Mtg Assn #38379UEM4 02/29/16 02/16/51 2.300%2.245%$358,984 $350,732 $738
*Government National Mtg Assn #38381WV96 08/06/19 07/20/54 2.250%2.293%503,546 518,449 829
*Government National Mtg Assn #38380BNV3 12/05/19 06/20/46 2.000%2.112%464,145 484,219 679
Total Government & Agency Obligations:$1,326,675 $1,353,400 $2,246
Certificates of Deposit:
State Bk India NY #8562846A7 01/26/17 01/26/22 2.250%2.250%$245,000 $249,405 $981
Comenity Cap Bank #20033AU46 04/15/19 04/15/21 2.500%2.500%245,000 245,250 248
Morgan Stanley #61760AE21 05/30/19 06/01/21 2.400%2.400%245,000 245,992 1,960
First St Bank DeQueen #336460CU2 07/18/19 07/19/21 2.000%2.000%245,000 246,446 195
Bank Hapoalim #06251AW89 07/19/19 07/19/21 2.000%2.000%245,000 246,534 1,065
Capital One Natl Assn #14042RMF5 07/24/19 07/26/19 2.050%2.050%245,000 246,590 1,012
TIAA FSB Jacksonville #87270LCN1 07/29/19 07/29/21 2.000%2.000%245,000 246,590 824
Wells Fargo #949763J31 09/18/19 09/20/21 1.850%1.850%245,000 247,078 195
BMW Bank #05580ASQ8 10/11/19 10/12/21 1.800%1.800%245,000 247,281 2,009
Wells Fargo #949495AN5 01/17/20 01/18/22 1.800%1.800%245,000 248,396 194
Bank Leumi #063248KQ0 03/31/20 03/31/22 1.250%1.250%245,000 247,854 -
Capital One Natl Assn #14042TCZ8 04/01/20 04/01/22 1.350%1.350%245,000 248,089 1,640
Synchrony Bank #87164WZN1 04/03/20 04/04/22 1.350%1.350%245,000 248,114 1,622
Wells Fargo #95001DAB6 06/17/20 06/17/23 1.200%1.200%245,000 243,993 106
Total Certificates of Deposits $3,430,000 $3,457,612 $12,051
Total J.P.Morgan Securities $22,971,628 $23,116,575 $164,036
*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, 2021
Cash & Investments by Fund - Total $46.8 million
Cash & Investments by Type - Total $46.8 million
Checking
Illinois Funds
Certificates of Deposit
Municipal Bonds
Corporate Bonds
Government & Agency Obligations
Accrued Interest
General Corporate
54.7%
Hotel/Motel Tax
10.0%
Motor Fuel Tax
1.8%
Infrastructure
15.0%
Promenade TIF
0.1%
Water
14.9%
Sports Core
0.2%
Golf Surcharge
0.3%
Self-Insurance
0.9%Garage
0.6%
Equipment
Replacement
1.6%
Checking, $1.4
Illinois Funds, $22.3
Certificates of Deposit ,
$3.4
Municipal Bonds,
$10.7
Corporate Bonds, $7.5
Government & Agency
Obligations, $1.3
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)6,672,355$ 5,254,328$ 1,418,027$ 900,545$
Main operating fund of the Village.
Hotel Fund (Major Fund)91,381$ 35,795$ 55,586$ 1,165$
Collects and spends resources from the
3% hotel/motel tax.
Motor Fuel Tax Fund 157,360$ -$ 157,360$ 71,750$
Collects and spends resources from the
State motor fuel tax.
Infrastructure Fund (Major Fund)1,717,749$ 1,500,672$ 217,077$ (162,690)$
Accounts for construction and maintenance of
roadways, drainage, and safety path systems.
Promenade TIF Fund (Major Fund)9,966$ 228,250$ (218,284)$ (207,445)$
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,261,119$ 1,478,845$ 782,274$ (1,739,895)$
Collects user fees for the distribution of water
and maintenance of infrastructure.
Sports Core Fund (Major Fund)458,202$ 471,780$ (13,578)$ (282,665)$
Accounts for revenues and expenses relating
to administration, programs, food and beverage
operations, and golf course.
Golf Surcharge Fund 4,584$ -$ 4,584$ (97,765)$
Accounts for the collection of the $3 per round
golf surcharge.
Internal Service Funds
Self Insurance Fund 1,055,081$ 576,440$ 478,641$ 4,750$
Accounts for the Village's health insurance costs
and the related contributions from the Village,
employees, retirees, and other agencies.
Garage Fund 152,992$ 168,575$ (15,583)$ (29,495)$
Accounts for the maintenance of the Village's vehicle
fleet and the related departmental reimbursements.
Equipment Replacement Fund 83,958$ 53,109$ 30,849$ (26,880)$
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, 2021
Village of Oak Brook
Monthly Financial Report – Fund Narrative
For the Period Ending March 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 March 2021 are $370,889, or 5.4%, lower than last March, but $68,676,
or 1.1%, over budget to date. The main drivers for this are:
o Sales tax revenue, the General
Fund’s largest revenue source, is
down $181,027 from last year,
but $203,644 over budget.
March 2021 collections were the
lowest over the past five years
due to COVID-19 restrictions.
o Telecommunications/Utility Tax
revenue is down $122,350 from
last year and $69,301 under
budget. The decrease relates to
electric and telecommunications and is currently being researched.
o Charges for Services revenue is down $126,825 from last year and $137,418 under
budget. This is due to a decrease in billable auxiliary police services and a decrease in
billable ambulance revenue to date.
o Investment Interest revenue is down $56,870 from last year and $22,591 under budget.
Investment return rates have dropped significantly since the beginning of the COVID-19
pandemic.
Total expenditures through March 2021 are $859,998, or 14.1%, lower than last year and
$448,809, or 7.9%, under budget to date. The main drivers for this are:
o Personnel expenditures are down $841,701 from last year and $268,954 under budget.
The decrease is due to two payroll cycles in January 2021 vs. three payroll cycles in
January 2020. In addition, personnel expenditures are under budget due to delays in
full public safety pension funding.
Hotel Tax Fund
Total revenues through March 2021 are $139,865, or 60.5%, lower than last year and $1,774, or
1.9%, under budget to date. The main drivers for this are:
o Hotel tax revenue is down $126,021 from last year and $1,998 under budget. The
decrease in revenue is due to the effects of COVID-19 on the travel industry.
Total expenditures through March 2021 are $342,081, or 95.9%, lower than last year and
$56,201, or 79.2%, under budget. Major 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 March 2021 are down $182,337, or 10.0%, from last year, but $14,877,
or 0.9%, over budget. The main drivers for this are:
o Non-home rule sales tax revenue
is down $156,367 from last year,
but $16,173 over budget. March
2021 collections were the lowest
over the past five years due to
COVID-19 restrictions.
o Investment Interest revenue is
down $25,970 from last year and
$1,041 under budget.
Investment return rates have
dropped significantly since the
beginning of the COVID-19 pandemic.
Total expenditures through March 2021 are up $599,510, or 69.9%, from last year, but
$364,699, or 20.0%, under budget to date. The main drivers for this are:
o Personnel expenditures are down $34,552 from last year, but $1,222 over budget. The
decrease is due to two payroll cycles in January 2021 vs. three payroll cycles in January
2020. Personnel is over budget due to snow removal overtime.
o Operation and contract expenditures are down $91,197 from last year and $228,750
under budget. Expenditures are under budget due to the timing of engineering and
other miscellaneous payments.
o Capital Outlay expenditures are up $683,179 from last year, but $168,109 under budget.
Expenditures are up due to delays last year and general timing of work performed.
Promenade TIF Fund
Total revenues through March 2021 are up $111, or 1.1%, from last year and $10,839, or 52.1%,
under budget. Revenues are under budget due to the timing of Department of Revenue
information to record the TIF sale tax transfer.
Total expenditures through March 2021 are down $37,205, or 14.0%, 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 March 2021 are down $68,254, or 2.9%, from last year and $174,636, or
7.2%, under budget. The main drivers for this are:
o Water sales revenue is down $198,865 from last year and $313,892 under budget.
Water gallons sold has also been slightly less than projected so far this year.
Total expenditures through March 2021 are up $10,386, or 0.8%, from last year, but $2,696,811,
or 66.4%, under budget. The main drivers for this are:
o Operation and contract expenditures are down $40,037 from last year and $706,006
under budget. Expenditures are under budget due to the timing of invoices paid and
DuPage Water Commission water purchased being less than expected.
o Capital outlay expenditures are up $47,618 from last year, but $1,991,844 under
budget. Capital projects will occur later in 2021 as planned.
Sports Core Fund
Total revenues through March 2021 are up $243,099, or 118.5%, from last year and $226,820,
or 102.5%, over budget to date. The main drivers for this are:
o Memberships revenue is up $144,801 from last year and $146,775 over budget. Golf
memberships have exceeded the total 2021 budget already through March.
o Driving Range Fees revenue is up $39,613 from last year and $42,300 over budget. This
is due to the golf course being able to open early and stay open this season.
Total expenditures through March 2021 are down $384,323, or 45.7%, from last year and
$142,258, or 23.8%, under budget to date. The main drivers for this are:
o Personnel expenditures are down $32,444 from last year and $35,776 under budget.
The decrease is due to two payroll cycles in January 2021 vs. three payroll cycles in
January 2020.
o Capital outlay expenditures are down $438,926 from last year and $166,820 under
budget. Expenditures are down because of the golf lounge project that occurred in
spring 2020. Expenditures are under budget due to the timing of projects.
3/31/21 3/31/21
3/31/20 3/31/21 YTD % of YTD 2021 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 3,900,971$ 3,719,944$ 3,516,300$ 105.8%11,860,995$ (181,027)$
Other Intergovernmental Tax*350,255 417,193 312,650 133.4%1,320,600 66,938
Telecommunications/Utility Tax 1,603,049 1,480,699 1,550,000 95.5%5,995,000 (122,350)
Licenses and Permits 511,850 543,390 493,220 110.2%2,180,360 31,540
Charges for Services 288,282 161,457 298,875 54.0%1,293,540 (126,825)
Fines and Penalties 54,453 40,559 45,135 89.9%180,500 (13,894)
Administrative Towing Fees 7,137 8,579 5,505 155.8%22,000 1,442
Investment Interest 109,279 52,409 75,000 69.9%300,000 (56,870)
Franchise Fees - - 50,500 0.0%202,000 -
Miscellaneous Income 69,549 99,706 108,075 92.3%463,380 30,157
Total Operating Revenues 6,894,825$ 6,523,936$ 6,455,260$ 101.1%23,818,375$ (370,889)$
OPERATING EXPENDITURES
Personnel 4,986,072$ 4,144,371$ 4,413,325$ 93.9%18,842,080$ (841,701)$
Materials and Supplies 111,277 88,329 152,995 57.7%551,030 (22,948)
Operation and Contract 961,669 931,241 1,038,215 89.7%3,397,210 (30,428)
Other Expenditures 2,201 2,173 2,500 86.9%10,000 (28)
Capital Outlay 26,635 61,742 69,630 88.7%452,300 35,107
Total Operating Expenditures 6,087,854$ 5,227,856$ 5,676,665$ 92.1%23,252,620$ (859,998)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 806,971$ 1,296,080$ 778,595$ 565,755$ 489,109$
INTERFUND TRANSACTIONS
Transfers Out -$ 0.0%(100,000)$ -$
Reimbursements From Other Funds 156,597 148,419 148,425 100.0%593,685 (8,178)
Reimbursements To Other Funds (34,941) (26,472) (26,475) 100.0%(105,885) 8,469
Sports Core Loan (205,329) - - 0.0%- 205,329
Total Interfund Transactions (83,673)$ 121,947$ 121,950$ 100.0%387,800$ 205,620$
NET FUND INCREASE (DECREASE)723,298$ 1,418,027$ 900,545$ 953,555$ 694,729$
*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, 2021
Total Total
Revenues Expenditures
3/31/21 Actual 6,523,936$ 5,227,856$
3/31/20 Actual 6,894,825$ 6,087,854$
% Change From Last Year -5.4%-14.1%
Major Revenues
Other Telecom/Utility Licenses &Charges for
Sales Tax Intergov. Tax Tax Permits Services
3/31/21 Actual 3,719,944$ 417,193$ 1,480,699$ 543,390$ 161,457$
3/31/20 Actual $ 3,900,971 $ 350,255 $ 1,603,049 $ 511,850 $ 288,282
% Change From Last Year -4.6%19.1%-7.6%6.2%-44.0%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
3/31/21 Actual 4,144,371$ 88,329$ 931,241$ 2,173$ 61,742$
3/31/20 Actual 4,986,072$ 111,277$ 961,669$ 2,201$ 26,635$
% Change From Last Year -16.9%-20.6%-3.2%-1.3%131.8%
Five Year Trend
Expenditures by Department
3/31/20 3/31/21 3/31/21 3/31/21 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Department Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 573,518$ 555,439$ 717,940$ 77.4%2,498,625$ (18,079)$
Financial Services 207,741 178,532 180,910 98.7%770,360 (29,209)
Public Works 153,249 223,019 225,040 99.1%948,860 69,770
Engineering & Capital Projects 17,706 4,547 19,000 23.9%209,000 (13,159)
Library 242,581 206,516 226,005 91.4%943,405 (36,065)
Police 2,474,151 2,034,356 2,149,620 94.6%9,213,585 (439,795)
Fire 2,130,410 1,767,963 1,887,580 93.7%7,576,045 (362,447)
Development Services 288,498 257,484 270,570 95.2%1,092,740 (31,014)
Total Expenditures 6,087,854$ 5,227,856$ 5,676,665$ 92.1%23,252,620$ (859,998)$
Five Year Trend
For the Period Ending March 31, 2021
General Fund - Five Year Trend
Village of Oak Brook
Revenues Expenditures
3/31/21 3/31/21
3/31/20 3/31/21 YTD % of YTD 2021 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Hotel Tax 207,173$ 81,152$ 83,150$ 97.6%414,000$ (126,021)$
Investment Interest 24,073 10,229 10,005 102.2%40,000 (13,844)
Loan Interest - - - 0.0%8,000 -
Total Operating Revenues 231,246$ 91,381$ 93,155$ 98.1%462,000$ (139,865)$
EXPENDITURES
Operation and Contract 161,186$ 14,774$ 45,975$ 32.1%193,945$ (146,412)$
Capital Outlay 195,669 - 25,000 0.0%250,000 (195,669)
Total Expenditures 356,855$ 14,774$ 70,975$ 20.8%443,945$ (342,081)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES (125,609)$ 76,607$ 22,180$ 345.4%18,055$ 202,216$
INTERFUND TRANSACTIONS
Transfer Out -$ -$ -$ 0.0%(100,000)$ -$
Reimbursements to Other Funds (18,678) (21,021) (21,015) 100.0%(84,085) (2,343)
Total Interfund Transactions (18,678)$ (21,021)$ (21,015)$ 100.0%(184,085)$ (2,343)$
NET FUND INCREASE (DECREASE)(144,287)$ 55,586$ 1,165$ (166,030)$ 199,873$
Note - Expenditures are recorded in program 171.
Village of Oak Brook
Hotel Tax Fund Financial Update
For the Period Ending March 31, 2021
Total Total
Revenues Expenditures
3/31/21 Actual $ 91,381 14,774$
3/31/20 Actual $ 231,246 356,855$
% Change From Last Year -60.5%-95.9%
Major Revenues Investment
Hotel Tax Interest Loan Interest Miscellaneous
3/31/21 Actual $ 81,152 $ 10,229 -$ -$
3/31/20 Actual $ 207,173 $ 24,073 -$ -$
% Change From Last Year -60.8%-57.5%0.0%0.0%
Five Year Trend
Major Expenditures Operation &
Contractual Capital Outlay
3/31/21 Actual 14,774$ -$
3/31/20 Actual 161,186$ 195,669$
% Change From Last Year -90.8%-100.0%
Five Year Trend
Village of Oak Brook
Hotel Tax Fund - Major Sources Five Year Trend
For the Period Ending March 31, 2021
Five Year Trend
Revenues Expenditures
3/31/21 3/31/21
3/31/20 3/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 1,782,190$ 1,625,823$ 1,609,650$ 101.0%5,333,500$ (156,367)$
Charges for Services - - 255 0.0%1,000 -
Investment Interest 34,934 8,964 10,005 89.6%40,000 (25,970)
Miscellaneous - - - 0.0%- -
Total Operating Revenues 1,817,124$ 1,634,787$ 1,619,910$ 100.9%5,374,500$ (182,337)$
OPERATING EXPENDITURES
Personnel 386,784$ 352,232$ 351,010$ 100.3%1,386,115$ (34,552)$
Materials and Supplies 79,753 121,833 90,895 134.0%245,660 42,080
Operation and Contract 362,577 271,380 500,130 54.3%1,892,905 (91,197)
Capital Outlay 27,972 711,151 879,260 80.9%8,956,170 683,179
Total Operating Expenditures 857,086$ 1,456,596$ 1,821,295$ 80.0%12,480,850$ 599,510$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 960,038$ 178,191$ (201,385)$ -88.5%(7,106,350)$ (781,847)$
INTERFUND TRANSACTIONS
Transfers In -$ -$ -$ 0.0%1,400,000$ -$
Reimbursements From Other Funds 89,844 82,962 82,965 100.0%331,840 (6,882)
Reimbursements To Other Funds (40,575) (44,076) (44,270) 99.6%(176,300) (3,501)
Total Interfund Transactions 49,269$ 38,886$ 38,695$ 100.5%1,555,540$ (10,383)$
NET FUND INCREASE (DECREASE)1,009,307$ 217,077$ (162,690)$ (5,550,810)$ (792,230)$
Village of Oak Brook
Infrastructure Fund Financial Update
For the Period Ending March 31, 2021
Total Total
Revenues Expenditures
3/31/21 Actual $ 1,634,787 1,456,596$
3/31/20 Actual $ 1,817,124 857,086$
% Change From Last Year -10.0%69.9%
Major Revenues
Sales Tax
Charges for
Services
Investment
Interest Miscellaneous
3/31/21 Actual $ 1,625,823 $ - $ 8,964 $ -
3/31/20 Actual $ 1,782,190 $ - $ 34,934 $ -
% Change From Last Year -8.8%0.0%-74.3%0.0%
Five Year Trend
Major Expenditures Materials &Operation &
Personnel Supplies Contractual Capital Outlay
3/31/21 Actual 352,232$ 121,833$ 271,380$ 711,151$
3/31/20 Actual 386,784$ 79,753$ 362,577$ 27,972$
% Change From Last Year -8.9%52.8%-25.2%2442.4%
Five Year Trend
Expenditures by Department
3/31/20 3/31/21 3/31/21 3/31/21 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 46,922$ 36,285$ 38,795$ 93.5%157,640$ (10,637)$
Public Works 613,155 651,848 673,895 96.7%2,789,580 38,693
Engineering & Capital Projects 197,009 768,463 1,108,605 69.3%9,709,930 571,454
Total Expenditures 857,086$ 1,456,596$ 1,821,295$ 80.0%12,657,150$ 599,510$
Five Year Trend
Village of Oak Brook
Infrastructure Fund - Major Sources Five Year Trend
For the Period Ending March 31, 2021
Revenues Expenditures
3/31/21 3/31/21
3/31/20 3/31/21 YTD % of YTD 2021 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 9,545$ 9,944$ 20,550$ 48.4%75,000$ 399$
Real Estate Tax - - - 0.0%400,000 -
Investment Interest 310 22 255 8.6%1,000 (288)
Total Operating Revenues 9,855$ 9,966$ 20,805$ 47.9%476,000$ 111$
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)(255,600)$ (218,284)$ (207,445)$ 5,650$ 37,316$
Note - Expenditures are recorded in program 283.
Village of Oak Brook
Promenade TIF Fund Financial Update
For the Period Ending March 31, 2021
Total Total
Revenues Expenditures
3/31/21 Actual $ 9,966 228,250$
3/31/20 Actual $ 9,855 265,455$
% Change From Last Year 1.1%-14.0%
Major Revenues Real Estate Investment
Sales Tax Tax Interest
3/31/21 Actual 9,944$ $ - $ 22
3/31/20 Actual 9,545$ $ - $ 310
% Change From Last Year 4.2%0.0%-92.9%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures
3/31/21 Actual -$ 228,250$
3/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 March 31, 2021
Five Year Trend
Revenues Expenditures
3/31/21 3/31/21
3/31/20 3/31/21 YTD % of YTD 2021 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Plan Review Fees 75$ 75$ 255$ 29.4%1,000$ -$
Building/Inspection Fees 4,837 638 1,755 36.4%7,000 (4,199)
Water Sales 2,249,973 2,051,108 2,365,000 86.7%10,597,000 (198,865)
Unmetered Sales 24,071 2,400 8,745 27.4%35,000 (21,671)
Water Connection Fees 3,920 74,750 25,005 298.9%100,000 70,830
Meter Charges 660 1,518 3,750 40.5%15,000 858
Special Services 763 765 - N/A 25,000 2
Investment Interest 32,536 14,074 15,000 93.8%60,000 (18,462)
Miscellaneous 12,538 115,791 16,245 712.8%65,000 103,253
Total Operating Revenues 2,329,373$ 2,261,119$ 2,435,755$ 92.8%10,905,000$ (68,254)$
OPERATING EXPENDITURES
Personnel 216,971$ 184,834$ 201,010$ 92.0%842,235$ (32,137)$
Materials and Supplies 2,323 37,265 20,050 185.9%75,780 34,942
Operation and Contract 675,996 635,959 1,341,965 47.4%5,379,925 (40,037)
Capital Outlay 460,543 508,161 2,500,005 20.3%8,103,750 47,618
Total Expenditures 1,355,833$ 1,366,219$ 4,063,030$ 33.6%14,401,690$ 10,386$
Surplus (Deficit) of Revenues Over
Expenditures 973,540$ 894,900$ (1,627,275)$ -55.0%(3,496,690)$ (78,640)$
INTERFUND TRANSACTIONS
Reimbursements To Other Funds (131,703)$ (112,626)$ (112,620)$ 100.0%(450,500)$ 19,077$
Total Interfund Transactions (131,703)$ (112,626)$ (112,620)$ 100.0%(450,500)$ 19,077$
Fund Increase/(Decrease) - Budgetary Basis 841,837$ 782,274$ (1,739,895)$ -45.0%(3,947,190)$ (59,563)$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay 460,543$ 508,161$
Depreciation Expense (137,176) (143,750)
IMRF Pension Expense (10,373) (11,250)
OPEB Expense 6,911 (7,500)
Total GAAP Adjustments 319,905$ 345,661$
Fund Increase/(Decrease) - GAAP Basis 1,161,742$ 1,127,935$
*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, 2021
Total Total
Revenues Expenditures
3/31/21 Actual $ 2,261,119 1,366,219$
3/31/20 Actual $ 2,329,373 1,355,833$
% Change From Last Year -2.9%0.8%
Unmetered Water
Water Sales Sales Connection Fees Meter Charges Miscellaneous
3/31/21 Actual $ 2,051,108 $ 2,400 $ 74,750 $ 1,518 $ 115,791
3/31/20 Actual $ 2,249,973 $ 24,071 $ 3,920 $ 660 $ 12,538
% Change From Last Year -8.8%-90.0%1806.9%130.0%823.5%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
3/31/21 Actual 184,834$ 37,265$ 635,959$ -$ 508,161$
3/31/20 Actual 216,971$ 2,323$ 675,996$ -$ 460,543$
% Change From Last Year -14.8%1504.2%-5.9%0.0%10.3%
Five Year Trend
Expenditures by Department
3/31/20 3/31/21 3/31/21 3/31/21 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Public Works 895,300$ 838,833$ 1,568,030$ 53.5%6,317,940$ (56,467)$
Engineering & Capital Projects 460,533 527,386 2,495,000 21.1%8,083,750 66,853
Total Expenditures 1,355,833$ 1,366,219$ 4,063,030$ 33.6%14,401,690$ 10,386$
Five Year Trend
Village of Oak Brook
Water Fund - Major Sources Five Year Trend
For the Period Ending March 31, 2021
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Sports Core Fund Consolidated Presentation
For the Period Ending March 31, 2021
3/31/21 3/31/21
3/31/21 YTD % of YTD 2021 3/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 -$ -$ -$ 255,775$ 255,775$ 109,000$ 234.7%238,500$ 110,974$ 144,801$
Greens Fees - - - 35,969 35,969 31,500 114.2%985,000 21,191 14,778
Pro Shop Sales - - - 23,888 23,888 19,500 122.5%207,000 15,390 8,498
Golf Lessons - - - 11,310 11,310 6,000 188.5%45,000 120 11,190
Driving Range Fees - - - 72,300 72,300 30,000 241.0%250,000 32,687 39,613
Rentals - 7,500 - 13,004 20,504 20,725 98.9%761,000 20,527 (23)
Programs/User Fees - - - - - - 0.0%31,500 - -
Food Sales - - - 7,226 7,226 1,100 656.9%207,500 926 6,300
Beverage Sales - - - 12,192 12,192 3,000 406.4%382,000 2,827 9,365
Taste of Oak Brook - - - - - - 0.0%120,000 - -
Grants - - - - - - 0.0%233,600 - -
Other Revenue 6,899 - - 2,137 9,036 555 1628.1%7,700 459 8,577
Total Operating Revenues 6,899$ 7,500$ -$ 433,801$ 448,200$ 221,380$ 202.5%3,468,800$ 205,101$ 243,099$
OPERATING EXPENDITURES
Personnel -$ -$ 25,017$ 170,642$ 195,659$ 231,435$ 84.5%1,597,610$ 228,103$ (32,444)$
Materials & Supplies 14,038 - 1,459 42,619 58,116 34,375 169.1%628,450 5,471 52,645
Operational & Contractual 17,837 26,082 6,162 86,021 136,102 99,505 136.8%663,035 101,700 34,402
Other - - - - - - 0.0%(39,000) - -
Capital 65,782 - - 398 66,180 233,000 28.4%1,125,380 505,106 (438,926)
Total Operating Expenditures 97,657$ 26,082$ 32,638$ 299,680$ 456,057$ 598,315$ 76.2%3,975,475$ 840,380$ (384,323)$
B&T Administration Overhead Allocation*9,984$ -$ (9,984)$ -$ -$ -$ 0.0%-$ -$ -$
Operating Revenues Over (Under) Expenditures (80,774)$ (18,582)$ (42,622)$ 134,121$ (7,857)$ (376,935)$ 2.1%(506,675)$ (635,279)$ 627,422$
INTERFUND TRANSACTIONS
Interfund Loan**-$ -$ -$ -$ -$ -$ 0.0%-$ 205,329$ (205,329)$
Transfer From General Fund - - - - - - 0.0%100,000 - -
Transfer From Golf Surcharge Fund - - - - - 100,000 0.0%200,000 119,719 (119,719)
Reimbursement From Infrastructure Fund 8,000 - - - 8,000 8,000 100.0%32,000 6,000 2,000
Reimbursement From Water Fund 2,002 - - - 2,002 2,005 99.9%8,000 2,001 1
Reimbursement To General Fund (3,930) - - (11,793) (15,723) (15,735) 99.9%(62,900) (14,112) (1,611)
Total Interfund Transactions 6,072$ -$ -$ (11,793)$ (5,721)$ 94,270$ -6.1%277,100$ 318,937$ (324,658)$
Total Revenues Over (Under) Expenditures - Budgetary Basis (74,702)$ (18,582)$ (42,622)$ 122,328$ (13,578)$ (282,665)$ (229,575)$ (316,342)$ 302,764$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 65,782$ -$ -$ 398$ 66,180$ 505,106$
Depreciation Expense (42,057) (421) (15,000) (61,575) (119,053) (97,271)
IMRF Pension Expense (513) - (750) (6,125) (7,388) (6,539)
OPEB Expense - - (750) (7,000) (7,750) (6,312)
Total GAAP Adjustments 23,213$ (421)$ (16,500)$ (74,302)$ (68,011)$ 394,986$
Fund Increase/(Decrease) - GAAP Basis (51,489)$ (19,003)$ (59,122)$ 48,026$ (81,589)$ 78,644$
*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/21 Actual $ 448,200 456,057$
3/31/20 Actual $ 205,101 840,380$
% Change From Last Year 118.5%-45.7%
Driving Program/
Memberships Greens Fees Range Fees Rentals User Fees
3/31/21 Actual $ 255,775 $ 35,969 $ 72,300 $ 20,504 -$
3/31/20 Actual $ 110,974 $ 21,191 $ 32,687 $ 20,527 -$
% Change From Last Year 130.5%69.7%N/A -0.1%0.0%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
3/31/21 Actual 195,659$ 58,116$ 136,102$ -$ 66,180$
3/31/20 Actual 228,103$ 5,471$ 101,700$ -$ 505,106$
% Change From Last Year -14.2%962.3%33.8%0.0%-86.9%
Five Year Trend
Revenues by Department 3/31/20 3/31/21 3/31/21 3/31/21 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Operations (44)$ 6,899$ (145)$ -4757.9%325,800$ 6,943$
Open Field Operations 5,170 7,500 7,500 100.0%230,000 2,330
B&T Clubhouse Operations 10,167 - 7,000 0.0%267,000 (10,167)
Golf Club 189,808 433,801 207,025 209.5%2,646,000 243,993
Total Revenues 205,101$ 448,200$ 221,380$ 202.5%3,468,800$ 243,099$
Expenditures by Department 3/31/20 3/31/21 3/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 176,551$ 97,657$ 83,540$ 116.9%780,740$ (78,894)$
Open Field Operations 29,469$ 26,082$ 1,755$ 1486.2%358,910$ (3,387)$
B&T Clubhouse Operations 38,160 32,638 49,140 66.4%262,635 (5,522)
Golf Club 596,200 299,680 463,880 64.6%2,573,190 (296,520)
Total Expenditures 840,380$ 456,057$ 598,315$ 76.2%3,975,475$ (384,323)$
Five Year Trend
Village of Oak Brook
Sports Core Fund - Major Sources Five Year Trend
For the Period Ending March 31, 2021
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Club Recreation Operations
For the Period Ending March 31, 2021 3/31/21 3/31/21
822 3/31/21 YTD % of YTD 2021 3/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,899 - - - 6,899 (145) -4757.9%700 (243) 7,142
Total Operating Revenues 6,899$ -$ -$ -$ 6,899$ (145)$ -4757.9%325,800$ (44)$ 6,943$
OPERATING EXPENDITURES
Personnel -$ -$ -$ -$ -$ 9,815$ 0.0%119,110$ 2,316$ (2,316)$
Materials & Supplies - 9,993 1,945 2,100 14,038 2,670 525.8%37,250 705 13,333
Operational & Contractual 14,345 3,247 122 123 17,837 26,055 68.5%89,550 21,020 (3,183)
Capital 8,591 57,191 - - 65,782 45,000 146.2%534,830 152,510 (86,728)
Total Operating Expenditures 22,936$ 70,431$ 2,067$ 2,223$ 97,657$ 83,540$ 116.9%780,740$ 176,551$ (78,894)$
B&T Administration Overhead Allocation*19,967$ (7,187)$ (1,997)$ (799)$ 9,984$ 14,465$ 69.0%44,755$ 14,507$ (4,523)$
Operating Revenues Over (Under) Expenditures 3,930$ (77,618)$ (4,064)$ (3,022)$ (80,774)$ (69,220)$ 116.7%(410,185)$ (162,088)$ 81,314$
INTERFUND TRANSACTIONS
Interfund Loan**-$ -$ -$ -$ -$ -$ 0.0%-$ 205,329$ (205,329)$
Transfer From General Fund - - - - - - 0.0%100,000 - -
Reimbursement From Infrastructure Fund 8,000 - - - 8,000 8,000 100.0%32,000 6,000 2,000
Reimbursement From Water Fund 2,002 - - - 2,002 2,005 99.9%8,000 2,001 1
Reimbursement To General Fund (3,930) - - - (3,930) (3,930) 100.0%(15,725) (7,056) 3,126
Total Interfund Transactions 6,072$ -$ -$ -$ 6,072$ 6,075$ 100.0%124,275$ 206,274$ (200,202)$
Total Revenues Over (Under) Expenditures - Budgetary Basis 10,002$ (77,618)$ (4,064)$ (3,022)$ (74,702)$ (63,145)$ (285,910)$ 44,186$ (118,888)$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 8,591$ 57,191$ -$ -$ 65,782$ 152,510$
Depreciation Expense (16,090) (25,000) (675) (292) (42,057) (23,027)
IMRF Pension Expense (500) - - (13) (513) (280)
Total GAAP Adjustments (7,999)$ 32,191$ (675)$ (305)$ 23,213$ 129,204$
Fund Increase/(Decrease) - GAAP Basis 2,003$ (45,427)$ (4,739)$ (3,327)$ (51,489)$ 173,390$
*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, 2021 3/31/21 3/31/21
3/31/21 YTD % of YTD 2021 3/31/20 Difference
815 816 YTD Amended Amended Adopted YTD Prior
Polo Open Fields Total Budget Budget Budget Total Year
OPERATING REVENUES
Field Rentals -$ 7,500$ 7,500$ 7,500$ 100.0%30,000$ 5,170$ 2,330$
Range Rentals - - - - 0.0%80,000 - -
Taste of Oak Brook - - - - 0.0%120,000 - -
Other Revenue - - - - 0.0%- - -
Total Operating Revenues -$ 7,500$ 7,500$ 7,500$ 100.0%230,000$ 5,170$ 2,330$
OPERATING EXPENDITURES
Personnel -$ -$ -$ -$ 0.0%-$ -$ -$
Materials & Supplies - - - 100 0.0%500 - -
Operational & Contractual 25,000 1,082 26,082 1,655 1576.0%190,360 21,091 4,991
Capital - - - - 0.0%168,050 8,378 (8,378)
Total Operating Expenditures 25,000$ 1,082$ 26,082$ 1,755$ 1486.2%358,910$ 29,469$ (3,387)$
Operating Revenues Over (Under) Expenditures (25,000)$ 6,418$ (18,582)$ 5,745$ -323.4%(128,910)$ (24,299)$ 5,717$
INTERFUND TRANSACTIONS
Transfer From Hotel Tax Fund -$ -$ -$ -$ 0.0%-$ -$ -$
Total Interfund Transactions -$ -$ -$ -$ 0.0%-$ -$ -$
Total Revenues Over (Under) Expenditures - Budgetary Basis (25,000)$ 6,418$ (18,582)$ 5,745$ (128,910)$ (24,299)$ 5,717$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay -$ -$ -$ 8,378$
Depreciation Expense - (421) (421) (421)
Total GAAP Adjustments -$ (421)$ (421)$ 7,957$
Fund Increase/(Decrease) - GAAP Basis (25,000)$ 5,997$ (19,003)$ (16,342)$
*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, 2021
3/31/21 3/31/21
821 YTD % of YTD 2021 3/31/20 Difference
B&T Amended Amended Adopted YTD Prior
Clubhouse Budget Budget Budget Total Year
OPERATING REVENUES
Rentals -$ 7,000$ 0.0%267,000$ 10,167$ (10,167)$
Total Operating Revenues -$ 7,000$ 0.0%267,000$ 10,167$ (10,167)$
OPERATING EXPENDITURES
Personnel 25,017$ 26,700$ 93.7%133,585$ 31,005$ (5,988)$
Materials & Supplies 1,459 3,045 47.9%12,000 305 1,154
Operational & Contractual 6,162 19,395 31.8%107,550 6,850 (688)
Capital - - 0.0%9,500 - -
Total Operating Expenditures 32,638$ 49,140$ 66.4%262,635$ 38,160$ (5,522)$
B&T Administration Overhead Allocation*(9,984)$ (14,465)$ 69.0%(44,755)$ (14,507)$ 4,523$
Operating Revenues Over (Under) Expenditures (42,622)$ (56,605)$ 75.3%(40,390)$ (42,500)$ (122)$
INTERFUND TRANSACTIONS
Transfer From General Fund -$ -$ 0.0%-$ -$ -$
Total Interfund Transactions -$ -$ 0.0%-$ -$ -$
Total Revenues Over (Under) Expenditures - Budgetary Basis (42,622)$ (56,605)$ (40,390)$ (42,500)$ (122)$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay -$ -$
Depreciation Expense (15,000) (15,139)
IMRF Pension Expense (750) (518)
OPEB Expense (750) (661)
Total GAAP Adjustments (16,500)$ (16,318)$
Fund Increase/(Decrease) - GAAP Basis (59,122)$ (58,818)$
*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, 2021
3/31/21 3/31/21
823 831 832 833 834 3/31/21 YTD % of YTD 2021 3/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 -$ 255,775$ -$ -$ -$ 255,775$ 109,000$ 234.7%238,500$ 110,775$ 145,000$
Greens Fees - 35,969 - - - 35,969 31,500 114.2%985,000 21,191 14,778
Pro Shop Sales - 23,888 - - - 23,888 19,500 122.5%207,000 15,390 8,498
Golf Lessons - - 11,310 - - 11,310 6,000 188.5%45,000 120 11,190
Driving Range Fees - - 72,300 - - 72,300 30,000 241.0%250,000 32,687 39,613
Rentals - 15 - 12,989 - 13,004 6,225 208.9%384,000 5,190 7,814
Food Sales 7,226 - - - - 7,226 1,100 656.9%169,500 926 6,300
Beverage Sales 12,192 - - - - 12,192 3,000 406.4%360,000 2,827 9,365
Other Revenue - 2,137 - - - 2,137 700 305.3%7,000 702 1,435
Total Operating Revenues 19,418$ 317,784$ 83,610$ 12,989$ -$ 433,801$ 207,025$ 209.5%2,646,000$ 189,808$ 243,993$
OPERATING EXPENDITURES
Personnel 11,989$ 92,153$ -$ -$ 66,500$ 170,642$ 194,920$ 87.5%1,344,915$ 194,782$ (24,140)$
Materials & Supplies 26,384 (9,905) 4,967 735 20,438 42,619 28,560 149.2%578,700 4,461 38,158
Operational & Contractual 808 62,806 249 8,262 13,896 86,021 52,400 164.2%275,575 52,739 33,282
Other - - - - - - - 0.0%(39,000) - -
Capital - 398 - - - 398 188,000 0.0%413,000 344,218 (343,820)
Total Operating Expenditures 39,181$ 145,452$ 5,216$ 8,997$ 100,834$ 299,680$ 463,880$ 64.6%2,573,190$ 596,200$ (296,520)$
Operating Revenues Over (Under) Expenditures (19,763)$ 172,332$ 78,394$ 3,992$ (100,834)$ 134,121$ (256,855)$ -52.2%72,810$ (406,392)$ 540,513$
INTERFUND TRANSACTIONS
Transfer from Golf Surcharge -$ -$ -$ -$ -$ -$ 100,000$ 0.0%200,000$ 119,719$ (119,719)$
Reimbursement to General Fund - (11,793) - - - (11,793) (11,805) 99.9%(47,175) (7,056) (4,737)
Total Interfund Transactions -$ (11,793)$ -$ -$ -$ (11,793)$ 88,195$ -13.4%152,825$ 112,663$ (124,456)$
Total Revenues Over (Under) Expenditures - Budgetary Basis (19,763)$ 160,539$ 78,394$ 3,992$ (100,834)$ 122,328$ (168,660)$ 225,635$ (293,729)$ 416,057$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay -$ 398$ -$ -$ -$ 398$ 344,218$
Depreciation Expense (250) (26,250) (575) (3,250) (31,250) (61,575) (58,684)
IMRF Pension Expense (625) (2,500) (250) - (2,750) (6,125) (5,741)
OPEB Expense (750) (3,750) - - (2,500) (7,000) (5,651)
Total GAAP Adjustments (1,625)$ (32,102)$ (825)$ (3,250)$ (36,500)$ (74,302)$ 274,143$
Fund Increase/(Decrease) - GAAP Basis (21,388)$ 128,437$ 77,569$ 742$ (137,334)$ 48,026$ (19,586)$
*Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.