10 - October 2019 Monthly Financial ReportVILLAGE
OAK BROOK
OF
MONTHLY FINANCIAL REPORTS
OCTOBER 2019
ITEM 6.D
Total
Cash and Cash Pooled Cash and
Fund Equivalents Investments Investments % By Fund
General Corporate $6,878,065 $14,767,881 $21,645,946 46.2%
Hotel/Motel Tax 2,861,030 2,304,873 5,165,903 11.0%
Motor Fuel Tax 874,897 118,121 993,018 2.1%
Infrastructure 7,324,525 2,036,517 9,361,042 20.0%
Promenade TIF 271,200 - 271,200 0.6%
Water 4,095,412 3,155,450 7,250,862 15.5%
Sports Core 143,640 - 143,640 0.3%
Golf Surcharge 114,503 225,010 339,513 0.7%
Self-Insurance 562,208 - 562,208 1.2%
Garage 310,875 - 310,875 0.7%
Equipment Replacement 336,002 446,509 782,511 1.7%
Total $23,772,357 $23,054,361 $46,826,718 100.0%
Change in Cash and Investments by Fund :
Balance at Balance at Year-to-Date Year-to-Date
Fund January 1, 2019 October 31, 2019 Change ($)Change (%)
General Corporate $18,092,186 $21,645,946 $3,553,760 19.6%
Hotel/Motel Tax 4,843,367 5,165,903 322,536 6.7%
Motor Fuel Tax 782,203 993,018 210,815 27.0%
Infrastructure 9,322,381 9,361,042 38,661 0.4%
Promenade TIF 257,485 271,200 13,715 5.3%
Water 6,449,315 7,250,862 801,547 12.4%
Sports Core 190,397 143,640 (46,757)-24.6%
Golf Surcharge 442,152 339,513 (102,639)-23.2%
Self-Insurance 468,568 562,208 93,640 20.0%
Garage 331,134 310,875 (20,259)-6.1%
Equipment Replacement 1,636,238 782,511 (853,727)-52.2%
$42,815,426 $46,826,718 $4,011,292 9.4%
Book Bank/Market
Value Value
Pooled Checking $767,552 $1,329,047
Sports Core Checking 257,026 234,910
Pooled IPTIP 22,416,853 22,416,853
Water E-Pay IPTIP 330,926 330,926
$23,772,357 $24,311,736
Pooled Investments:
Investments-Municipal Bonds $6,231,036 $6,237,170
Investments-Corporate Bonds 8,304,853 8,379,310
Government & Agency Obligations 1,628,321 1,617,151
Certificates of Deposit 6,730,000 6,763,399
Accrued Interest 160,151 160,151
Total Pooled Investments $23,054,361 $23,157,181
Total Cash and Investments $46,826,718 $47,468,917
For October, total interest revenue is $82,724 and YTD revenue is $878,576.
Total investment yield for the portfolio is:
Pooled
Investments Illinois Funds Total
Last 12 months yield 2.33%2.37%2.35%
The weighted average yield of the current pooled investment portfolio is 2.37%. The IL Funds October average daily rate was 1.92%.
Monthly Treasurer's Report
October 31, 2019
Monthly Treasurer's Report
October 2019
The table below lists the detail investment holdings at J.P. Morgan Securities as of 10/31/19:
Month End VOB
Settlement Maturity Coupon Yield Book Market Accrued
Type Date Date Rate Rate Value Value Interest
Municipal Bonds:
Rosemont IL GO Corp #777543UT4 02/08/16 12/01/19 3.021%2.000%$500,364 $500,325 $6,198
New York N Y City #64971QTX1 02/22/16 05/01/21 2.350%2.000%201,017 201,072 2,336
Florida Hurricane #34074GDH4 03/30/16 07/01/20 2.995%2.150%502,701 503,645 4,991
Bloomingdale Mich Pub Sch Dist #094383FS0 04/26/16 05/01/22 2.710%2.150%506,744 508,280 6,736
Milan Mich Area Achs #598801JD1 05/26/16 05/01/20 1.931%1.931%245,000 245,282 2,265
Indiana Bd Bk Rev Taxable #4546248F7 01/06/17 01/15/20 2.934%1.900%255,503 255,604 2,216
Garland Cnty Ark Sales & Use #36609PAN3 02/06/17 11/01/19 1.795%1.840%499,998 500,000 4,612
Lanse Creuse Mich Pub Schs #516228RL9 05/02/17 05/01/20 2.159%2.159%100,000 100,202 1,077
Connecticut St GO Bds 2016 #20772J3F7 06/15/17 08/15/21 1.750%2.300%495,213 497,420 1,794
Fowlerville Mich Comnty Schs #351280MS8 10/03/17 05/01/20 2.045%1.750%500,737 501,075 4,942
Racine Cnty WI #749845UK7 12/20/17 12/01/20 2.150%2.150%750,000 750,158 6,719
Wisconsin St Gen Fd Annual #977100CW4 01/05/18 05/01/20 1.446%2.100%598,038 599,478 4,242
Wright County Min #982276BC0 07/18/19 12/01/20 2.000%2.000%545,000 546,254 3,633
State of IL #452152P54 10/09/19 11/01/21 5.000%1.870%530,721 528,375 12,249
Total Municipal Bonds $6,231,036 $6,237,170 $64,010
Corporate Bonds:
Goldman Sachs #38141GVP9 09/26/18 09/15/20 2.750%3.180%498,172 503,020 1,719
Wells Fargo #94974BGR5 01/15/19 12/07/20 2.550%3.120%1,381,568 1,400,425 14,472
SunTrust #86787EAU1 01/28/19 01/29/21 2.590%3.050%499,490 500,370 3,237
PNC Bank #69353RFH6 01/30/19 01/22/21 2.500%3.020%496,903 503,550 3,438
Morgan Stanley #61747WAL3 03/08/19 07/28/21 5.500%3.034%1,093,526 1,110,921 14,758
Citigroup #172967LC3 04/01/19 12/08/21 2.900%2.754%1,002,960 1,016,910 10,956
Bank of America #06051GFT1 04/03/19 10/19/20 2.625%2.625%700,000 704,690 357
Goldman Sachs #38143U8F1 05/02/19 02/25/21 2.875%2.707%365,779 368,836 1,897
American Honda #02665WBG5 07/31/19 09/09/21 1.700%2.180%495,665 498,655 1,251
BB&T Corp #05531FAZ6 08/15/19 02/01/21 2.150%2.010%751,297 752,573 3,835
JP Morgan #48128BAB7 09/30/19 01/15/23 2.972%2.337%1,019,493 1,019,360 8,751
Total Corporate Bonds $8,304,853 $8,379,310 $64,671
Government & Agency Obligations:
*Government National Mtg Assn #38379UEM4 02/29/16 02/16/51 2.300%2.245%$671,993 $659,552 $2,292
*Government National Mtg Assn #38381WV96 08/06/19 07/20/54 2.250%2.293%956,328 957,599 1,761
Total Government & Agency Obligations:$1,628,321 $1,617,151 $4,053
Certificates of Deposit:
State Bk India NY #8562846A7 01/26/17 01/26/22 2.250%2.250%$245,000 $247,403 $1,478
Marlin Bank #57116ANU8 05/10/17 11/12/19 1.610%1.610%245,000 245,005 219
American Express Fed Svgs #02587CER7 05/10/17 11/12/19 1.700%1.700%245,000 245,012 1,978
American Express Centurion #02587DV96 08/15/17 08/17/20 1.900%1.900%245,000 245,539 970
Sallie Mae #795450C86 08/16/17 08/17/20 1.900%1.900%245,000 245,539 970
Merrick Bank South Jordan #59013JZS1 08/21/17 08/21/20 1.800%1.800%245,000 245,343 120
Pinnacle Bank #72345SFS5 08/30/17 08/31/20 1.800%1.800%115,000 115,156 5
Jackson County Bank #466682AP6 08/31/17 03/01/21 1.850%1.850%245,000 245,407 755
Barclays Bank #06740KKX4 09/27/17 09/28/20 1.950%1.950%245,000 245,630 438
Goldman Sachs Bank #38148PRK5 10/18/17 10/19/20 1.950%1.950%245,000 245,620 159
FirstBank PR Santurce #33767A6M8 11/03/17 11/03/20 2.000%2.000%245,000 245,733 362
Morgan Stanley #61747MQ53 03/22/18 03/23/20 2.550%2.550%245,000 245,943 534
Investors Community Bank #46147UTT7 08/28/18 02/28/20 2.550%2.550%245,000 245,786 32
Lakeside Bank #51210SPS0 08/30/18 03/30/20 2.550%2.550%245,000 245,982 15
Bank United #066519GJ2 08/31/18 02/20/20 2.500%2.500%245,000 245,752 1,021
Compass Bank #20451PVW3 10/26/18 10/26/20 3.000%3.000%245,000 248,141 82
UBS Bank #90348JFH8 10/30/18 10/29/20 3.050%3.050%245,000 248,273 21
Citibank #17294XJP2 10/31/18 10/31/20 3.000%3.000%245,000 245,154 3,725
Discover Bank #254673WF9 11/07/18 11/09/20 3.000%3.000%245,000 248,219 3,562
Ally Bank #02007GFX6 11/08/18 11/09/20 3.000%3.000%245,000 248,217 3,542
Comenity Cap Bank #20033AU46 04/15/19 04/15/21 2.500%2.500%245,000 247,707 247
Morgan Stanley #61760AE21 05/30/19 06/01/21 2.400%2.400%245,000 247,514 2,450
First St Bank DeQueen #336460CU2 07/18/19 07/19/21 2.000%2.000%245,000 246,036 194
Bank Hapoalim #06251AW89 07/19/19 07/19/21 2.000%2.000%245,000 246,446 1,429
Capital One Natl Assn #14042RMF5 07/24/19 07/26/19 2.050%2.050%245,000 246,247 1,465
TIAA FSB Jacksonville #87270LCN1 07/29/19 07/29/21 2.000%2.000%245,000 246,039 1,266
Wells Fargo #949763J31 09/18/19 09/20/21 1.850%1.850%245,000 245,399 194
BMW Bank #05580ASQ8 10/11/19 10/12/21 1.800%1.800%245,000 245,157 184
Total Certificates of Deposits $6,730,000 $6,763,399 $27,417
Total J.P.Morgan Securities $22,894,210 $22,997,030 $160,151
*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
October 31, 2019
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
46.23%
Hotel/Motel Tax
11.03%Motor Fuel Tax
2.12%
Infrastructure
19.99%
Promenade TIF
0.58%
Water
15.48%
Sports Core
0.31%
Golf Surcharge
0.73%
Self-Insurance
1.20%Garage
0.66%
Equipment
Replacement
1.67%
Checking, $1.0
Illinois Funds, $22.7
Certificates of Deposit,
$6.7
Municipal Bonds, $6.2
Corporate Bonds, $8.3
Government & Agency
Obligations, $1.7
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)23,404,943 $20,065,115 $3,339,828 ($151,690)
Main operating fund of the Village.
Hotel Fund (Major Fund)$1,152,139 $601,259 $550,880 ($3,007,035)
Collects and spends resources from the
3% hotel/motel tax.
Motor Fuel Tax Fund $202,277 $0 $202,277 ($730,200)
Collects and spends resources from the
State motor fuel tax.
Infrastructure Fund (Major Fund)$5,411,994 $5,913,353 ($501,359)($5,502,085)
Accounts for construction and maintenance of
roadways, drainage, and safety path systems.
Promenade TIF Fund (Major Fund)$478,441 $464,728 $13,713 ($37,690)
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)$8,761,067 $7,868,750 $892,317 ($3,316,720)
Collects user fees for the distribution of water
and maintenance of infrastructure.
Sports Core Fund (Major Fund)$3,894,821 $4,045,292 ($150,471)$198,870
Accounts for revenues and expenses relating
to administration, programs, food and beverage
operations, and golf course.
Golf Surcharge Fund $110,330 $212,969 ($102,639)($55,850)
Accounts for the collection of the $3 per round
golf surcharge.
Internal Service Funds
Self Insurance Fund $2,824,365 $2,639,409 $184,956 ($1,620)
Accounts for the Village's health insurance costs
and the related contributions from the Village,
employees, retirees, and other agencies.
Garage Fund $567,008 $585,618 ($18,610)($70,180)
Accounts for the maintenance of the Village's vehicle
fleet and the related departmental reimbursements.
Equipment Replacement Fund $211,616 $1,064,510 ($852,894)($1,038,500)
Accounts for the replacement of the Village's vehicle
fleet and the related departmental contributions.
Further information on the Village's major funds (as indicated above) can be found on the proceeding pages.
Executive Summary on Village Funds
Through October 31, 2019
Village of Oak Brook
Monthly Financial Report – Fund Narrative
For the Period Ending October 31, 2019
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. 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 a cash basis.
The proceeding pages contain detailed information on significant items by individual fund:
General Fund
Sales Tax collections through
October 2019 are $10,428,409,
which is $185,539 higher than
through October 2018 and $187,159
over FY19 budget to date. The
increase is primarily due to the
opening of newer businesses in town
and general inflationary growth.
October 2019 collections have been
relatively consistent with with the
last 5 years.
Other Intergovernmental Tax collections through October 2019 are $1,302,270, which is
$166,562 higher than through October 2018 and $202,520 over FY19 budget to date. The
Village has seen strong collections in Income Tax, Replacement Tax, Road & Bridge Tax, and Use
Tax so far in 2019.
Telecommunications/Utility Tax collections through October 2019 are $5,259,852, which is
$144,906 higher than through October 2018 and $345,412 over FY19 budget to date. The
Village budgeted a decrease in tax due to the move of McDonald’s, but has not seen a negative
impact to date.
Licenses and Permits revenue through October 2019 is $3,433,253, which is $389,949 higher
than through October 2018 and $1,468,958 over FY19 budget to date. The Village issued a
number of large building permits in 2019, including Senior Lifestyle.
Charges for Services revenue through October 2019 is $1,049,373, which is $94,255 higher than
through October 2018, but $161,167 under FY19 budget to date. The increase is due to the
raise of ambulance fees in mid‐2018. Revenue is under budget due to more ambulance
unallowable billings than projected and timing of police auxiliary services billings.
Personnel expenditures through October 2019 are $14,874,443, which is $405,197 more than
through October 2018, but $485,967 under FY19 budget to date. The increase is due to normal
salary and benefit increases. Personnel is under budget in FY19 due to a delay in full pension
funding until later in the year and upcoming labor union retro payments.
Operation and Contract expenditures through October 2019 are $3,504,505, which is $375,142
more than through October 2018, but $109,115 under FY19 budget to date. The increase is
primarily due to the addition of five contracted paramedics to increase ambulance services. This
number will be reduced from eleven to nine contracted paramedics later in 2019.
Capital Outlay expenditures through October 2019 are $859,842, which is $1,864,745 less than
through October 2018 and $122,333 under FY19 budget to date. The decrease is due to the
Police Department expansion and renovation project that occurred in 2018. Budgeted projects
for 2019 are still expected to occur later in the year as planned.
Hotel Tax Fund
Hotel Tax collections through October 2019 are $1,057,362, which is $50,674 lower than
through October 2018, but $22,362 over FY19 budget to date. The variances are primarily due
to the timing of receipts.
Capital Outlay expenditures have not occurred to date due to the cancellation of the Jorie,
Kensington, and Forest Gate streetscape beautification project. Minor projects will occur as
budgeted.
Infrastructure Fund
Non‐Home Rule Sales Tax collections
through October 2019 are
$4,727,879, which is $81,062 higher
than through October 2018 and
$88,879 over FY19 budget to date.
The increase is primarily due to the
opening of newer businesses in town
and general inflationary growth.
October 2019 collections have been
relatively consistent with with the
last 5 years.
Operation and Contractual expenditures through October 2019 are $1,279,563, which is
$312,432 higher than through October 2018, but $138,432 under FY19 budget to date. The
increase is due to more being spent on project engineering than in 2018. Expenditures are
under budget due to the timing of invoices paid.
Capital Outlay expenditures through October 2019 are $3,324,824, which is $2,708,782 higher
than through October 2018, but $5,496,041 under FY19 budget to date. The increase from last
year is due to the B&T Circle drainage improvement project and Salt Storage Facility drainage.
Projects are expected to occur later in FY19 or early FY20 as planned.
Water Fund
Water Sales revenue through October 2019 is $8,065,866, which is $63,594 higher than through
October 2018, but $368,074 under FY19 budget to date. The increase is due to a 5% rate
increase effective January 1, 2019, however, slightly less gallons have been billed than
projected.
Operation and Contractual expenditures through October 2019 are $3,966,224, which is
$331,920 lower than through October 2018 and $890,186 under FY19 budget to date. The
decrease is due to less total gallons purchased from DuPage Water Commission compared to
FY18. Payments are under budget due to the general timing of when invoices have been paid
compared to when budgeted.
Capital Outlay expenditures through October 2019 are $2,735,388, which is $796,947 higher
than through October 2018, but $3,370,347 under FY19 budget to date. The 2019 water main
replacement projects recently kicked off and are expected to continue throughout the
remainder of 2019. No major water main projects were done in 2018.
Sports Core Fund
Memberships revenue through October 2019 is $419,681, which is $13,743 lower than through
October 2018 and $34,134 under FY19 budget to date. Memberships for the pool, tennis, and
golf are all less than 2018 totals and coming in less than projected for 2019.
Greens Fees revenue through October 2019 is $901,632, which is $29,967 higher than through
October 2018, but $26,528 under FY19 budget to date. Total rounds played is consistent with
the 2018 season so far despite the unfavorable weather during early 2019.
Operational & Contractual expenditures through October 2019 are $893,883, which is $134,569
lower than through October 2018 and $166,452 under FY19 budget to date. The decrease in
FY19 is due to the timing of payments and the cancellation of the Taste of Oak Brook event.
Capital Outlay expenditures through October 2019 are $1,148,004, which is $918,348 higher
than through October 2018, but $112,896 under FY19 budget to date. The FY19 increase is due
to the Golf Club pro shop renovation, finishing of the golf patio, and finishing the B&T generator
installation project.
Equipment Replacement Fund
Other Expenditures through October 2019 are $1,007,990, which is even with FY19 budget to
date. This includes a $1,000,000 equity transfer to the General Fund, Infrastructure Fund, Water
Fund, and Garage Fund as a result of switching to a leasing program.
10/31/19 10/31/19
10/31/18 10/31/19 YTD % of 2019 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 10,242,870$ 10,428,409$ 10,241,250$ 101.8%12,325,000$ 185,539$
Other Intergovernmental Tax*1,135,708 1,302,270 1,099,750 118.4%1,227,750 166,562
Telecommunications/Utility Tax 5,114,946 5,259,852 4,914,440 107.0%5,857,500 144,906
Licenses and Permits 3,043,304 3,433,253 1,964,295 174.8%2,335,050 389,949
Charges for Services 955,118 1,049,373 1,210,540 86.7%1,491,400 94,255
Fines and Penalties 146,905 187,538 131,700 142.4%158,000 40,633
Administrative Towing Fees 26,475 18,530 25,000 74.1%30,000 (7,945)
Interest on Investments 287,508 386,584 275,000 140.6%330,000 99,076
Franchise/IMF Maint. Fee 112,802 111,255 159,750 69.6%213,000 (1,547)
Miscellaneous Income 344,546 192,804 170,850 112.8%212,800 (151,742)
Total Operating Revenues 21,410,182$ 22,369,868$ 20,192,575$ 110.8%24,180,500$ 959,686$
OPERATING EXPENDITURES
Personnel 14,469,246$ 14,874,443$ 15,360,410$ 96.8%18,183,745$ 405,197$
Materials and Supplies 380,747 373,335 484,670 77.0%559,780 (7,412)
Operation and Contract 3,129,363 3,504,505 3,613,620 97.0%4,224,475 375,142
Other Expenditures 5,866 9,537 7,500 127.2%10,000 3,671
Capital Outlay 2,724,587 859,842 982,175 87.5%862,475 (1,864,745)
Total Operating Expenditures 20,709,809$ 19,621,662$ 20,448,375$ 96.0%23,840,475$ (1,088,147)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 700,373$ 2,748,206$ (255,800)$ 340,025$ 2,047,833$
OTHER TRANSACTIONS
Transfers In -$ 508,235$ 508,235$ 100.0%508,235$ 508,235$
Transfers Out - (334,203) (821,725) 40.7%(1,216,725) (334,203)
Reimbursements From Other Funds 524,210 526,840 526,850 100.0%632,210 2,630
Reimbursements To Other Funds (109,430) (109,250) (109,250) 100.0%(131,100) 180
Total Interfund Transactions 414,780$ 591,622$ 104,110$ 568.3%(207,380)$ 176,842$
NET FUND INCREASE (DECREASE)1,115,153$ 3,339,828$ (151,690)$ 132,645$ 2,224,675$
*Includes the collection of Income Tax, Use Tax, Road & Bridge Tax, and Personal Property Replacement Tax.
Village of Oak Brook
General Fund Financial Update
For the Period Ending October 31, 2019
Total Total
Revenues Expenditures
10/31/19 Actual 22,369,868$ 19,621,662$
10/31/18 Actual 21,410,182$ 20,709,809$
% Change From Last Year 4.5%-5.3%
Major Revenues Other
Intergov.Licenses &Charges for
Sales Tax Tax Telecom Tax Permits Services
10/31/19 Actual 10,428,409$ 1,302,270$ 5,259,852$ 3,433,253$ 1,049,373$
10/31/18 Actual $ 10,242,870 $ 1,135,708 $ 5,114,946 $ 3,043,304 $ 955,118
% Change From Last Year 1.8%14.7%2.8%12.8%9.9%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
10/31/19 Actual 14,874,443$ 373,335$ 3,504,505$ 9,537$ 859,842$
10/31/18 Actual 14,469,246$ 380,747$ 3,129,363$ 5,866$ 2,724,587$
% Change From Last Year 2.8%-1.9%12.0%62.6%-68.4%
Five Year Trend
Expenditures by Department
10/31/18 10/31/19 10/31/19 10/31/19 2019 Difference Five
YTD YTD YTD % of Annual Prior Year
Department Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 1,885,525$ 1,931,441$ 2,323,165$ 83.1%2,700,820$ 45,916$
Financial Services 593,284 619,106 597,595 103.6%782,860 25,822
Public Works 570,014 728,077 738,170 98.6%886,420 158,063
Engineering & Capital Projects 2,571,572 473,581 383,250 123.6%459,900 (2,097,991)
Library 735,172 760,057 787,015 96.6%928,675 24,885
Police 7,179,515 7,540,016 7,786,355 96.8%8,891,960 360,501
Fire 6,393,358 6,782,189 6,947,020 97.6%8,207,785 388,831
Development Services 781,369 787,195 820,205 96.0%982,055 5,826
Total Expenditures 20,709,809$ 19,621,662$ 20,382,775$ 96.3%23,840,475$ (1,088,147)$
Five Year Trend
For the Period Ending October 31, 2019
General Fund - Five Year Trend
Village of Oak Brook
Revenues Expenditures
10/31/19 10/31/19
10/31/18 10/31/19 YTD % of 2019 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Hotel Tax 1,108,036$ 1,057,362$ 1,035,000$ 102.2%1,268,000$ (50,674)$
Interest 65,951 94,777 25,000 379.1%30,000 28,826
Miscellaneous 5,200 - - 0.0%- (5,200)
Total Operating Revenues 1,179,187$ 1,152,139$ 1,060,000$ 108.7%1,298,000$ (27,048)$
EXPENDITURES
Operation and Contract 398,338$ 515,329$ 481,540$ 107.0%577,860$ 116,991$
Capital Outlay 6,323 - 3,499,595 0.0%4,180,545 (6,323)
Total Expenditures 404,661$ 515,329$ 3,981,135$ 12.9%4,758,405$ 110,668$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 774,526$ 636,810$ (2,921,135)$ -21.8%(3,460,405)$ (137,716)$
INTERFUND TRANSACTIONS
Reimbursements to Other Funds (82,950) (85,930)$ (85,900)$ 100.0%(103,115)$ (2,980)$
Total Interfund Transactions (82,950)$ (85,930)$ (85,900)$ 100.0%(103,115)$ (2,980)$
NET FUND INCREASE (DECREASE)691,576$ 550,880$ (3,007,035)$ (3,563,520)$ (140,696)$
Note - Expenditures are recorded in program 171.
Village of Oak Brook
Hotel Tax Fund Financial Update
For the Period Ending October 31, 2019
Total Total
Revenues Expenditures
10/31/19 Actual $ 1,152,139 515,329$
10/31/18 Actual $ 1,179,187 404,661$
% Change From Last Year -2.3%27.3%
Major Revenues
Hotel Tax Interest Miscellaneous
10/31/19 Actual $ 1,057,362 $ 94,777 $ -
10/31/18 Actual $ 1,108,036 $ 65,951 $ 5,200
% Change From Last Year -4.6%43.7%-100.0%
Five Year Trend
Major Expenditures Operation &
Contractual Capital Outlay
10/31/19 Actual 515,329$ -$
10/31/18 Actual 398,338$ 6,323$
% Change From Last Year 29.4%-100.0%
Five Year Trend
Village of Oak Brook
Hotel Tax Fund - Major Sources Five Year Trend
For the Period Ending October 31, 2019
Five Year Trend
Revenues Expenditures
10/31/19 10/31/19
10/31/18 10/31/19 YTD % of 2019 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 4,646,817$ 4,727,879$ 4,639,000$ 101.9%5,548,000$ 81,062$
Charges for Services - 965 - N/A - 965
Interest 143,076 189,155 70,000 270.2%80,000 46,079
Miscellaneous 2,729 - 4,150 0.0%5,000 (2,729)
Total Operating Revenues 4,792,622$ 4,917,999$ 4,713,150$ 104.3%5,633,000$ 125,377$
OPERATING EXPENDITURES
Personnel 1,009,494$ 1,061,972$ 1,092,385$ 97.2%1,322,375$ 52,478$
Materials and Supplies 110,447 112,384 143,400 78.4%246,845 1,937
Operation and Contract 967,131 1,279,563 1,417,995 90.2%1,663,435 312,432
Capital Outlay 616,042 3,324,824 8,820,865 37.7%10,008,575 2,708,782
Total Operating Expenditures 2,703,114$ 5,778,743$ 11,474,645$ 50.4%13,241,230$ 3,075,629$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 2,089,508$ (860,744)$ (6,761,495)$ 12.7%(7,608,230)$ (2,950,252)$
INTERFUND TRANSACTIONS
Transfers In 7,790$ 216,125$ 1,116,125$ 19.4%1,116,125$ 208,335$
Reimbursements From Other Funds 150,940 277,870 277,900 100.0%333,445 126,930
Reimbursements To Other Funds (137,390) (134,610) (134,615) 100.0%(161,535) 2,780
Total Interfund Transactions 21,340$ 359,385$ 1,259,410$ 28.5%1,288,035$ 338,045$
NET FUND INCREASE (DECREASE)2,110,848$ (501,359)$ (5,502,085)$ (6,320,195)$ (2,612,207)$
Village of Oak Brook
Infrastructure Fund Financial Update
For the Period Ending October 31, 2019
Total Total
Revenues Expenditures
10/31/19 Actual $ 4,917,999 5,778,743$
10/31/18 Actual $ 4,792,622 2,703,114$
% Change From Last Year 2.6%113.8%
Major Revenues
Sales Tax Grants Interest Miscellaneous
10/31/19 Actual $ 4,727,879 $ 965 $ 189,155 $ -
10/31/18 Actual $ 4,646,817 $ - $ 143,076 $ 2,729
% Change From Last Year 1.7%0.0%32.2%-100.0%
Five Year Trend
Major Expenditures Materials &Operation &
Personnel Supplies Contractual Capital Outlay
10/31/19 Actual 1,061,972$ 112,384$ 1,279,563$ 3,324,824$
10/31/18 Actual 1,009,494$ 110,447$ 967,131$ 616,042$
% Change From Last Year 5.2%1.8%32.3%439.7%
Five Year Trend
Expenditures by Department
10/31/18 10/31/19 10/31/19 10/31/19 2019 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 130,723$ 130,864$ 151,565$ 86.3%179,485$ 141$
Public Works 1,619,897 3,144,047 5,883,170 53.4%6,462,865 1,524,150
Engineering & Capital Projects 952,494 2,503,832 5,439,910 46.0%6,760,415 1,551,338
Total Expenditures 2,703,114$ 5,778,743$ 11,474,645$ 50.4%13,402,765$ 3,075,629$
Five Year Trend
Village of Oak Brook
Infrastructure Fund - Major Sources Five Year Trend
For the Period Ending October 31, 2019
Revenues Expenditures
10/31/19 10/31/19
10/31/18 10/31/19 YTD % of 2019 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 67,242$ 65,184$ 66,750$ 97.7%100,000$ (2,058)$
Real Estate Tax 373,267 411,687 360,000 114.4%360,000 38,420
Interest 1,143 1,570 750 209.3%900 427
Total Operating Revenues 441,652$ 478,441$ 427,500$ 111.9%460,900$ 36,789$
EXPENDITURES
Operation and Contract 3,578$ 3,748$ 4,210$ 89.0%4,210$ 170$
Other Expenditures 489,820 460,980 460,980 100.0%460,980 (28,840)
Total Expenditures 493,398$ 464,728$ 465,190$ 99.9%465,190$ (28,670)$
NET FUND INCREASE (DECREASE)(51,746)$ 13,713$ (37,690)$ (4,290)$ 65,459$
Note - Expenditures are recorded in program 283.
Village of Oak Brook
Promenade TIF Fund Financial Update
For the Period Ending October 31, 2019
Total Total
Revenues Expenditures
10/31/19 Actual $ 478,441 464,728$
10/31/18 Actual $ 441,652 493,398$
% Change From Last Year 8.3%-5.8%
Major Revenues Real Estate
Sales Tax Tax Interest
10/31/19 Actual $ 65,184 $ 411,687 $ 1,570
10/31/18 Actual $ 67,242 $ 373,267 $ 1,143
% Change From Last Year -3.1%10.3%37.4%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures
10/31/19 Actual 3,748$ 460,980$
10/31/18 Actual 3,578$ 489,820$
% Change From Last Year 4.8%-5.9%
Five Year Trend
Village of Oak Brook
Promenade TIF Fund - Major Sources Five Year Trend
For the Period Ending October 31, 2019
Five Year Trend
Revenues Expenditures
10/31/19 10/31/19
10/31/18 10/31/19 YTD % of 2019 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Plan Review Fees 750$ 1,275$ 1,250$ 102.0%1,500$ 525$
Building/Inspection Fees 7,763 6,113 4,160 146.9%5,000 (1,650)
Water Sales 8,002,272 8,065,866 8,433,940 95.6%10,223,250 63,594
Unmetered Sales 34,532 42,492 25,000 170.0%30,000 7,960
Water Connection Fees 110,894 172,250 41,600 414.1%50,000 61,356
Fire Service Charge - - 4,160 0.0%5,000 -
Meter Charges 9,900 25,437 16,670 152.6%20,000 15,537
Special Services 16,394 16,772 15,000 111.8%30,000 378
Interest on Investments 81,264 148,655 45,800 324.6%55,000 67,391
Miscellaneous 72,354 61,122 62,500 97.8%75,000 (11,232)
Total Operating Revenues 8,336,123$ 8,539,982$ 8,650,080$ 98.7%10,494,750$ 203,859$
EXPENDITURES
Personnel 619,652$ 655,576$ 700,800$ 93.5%828,710$ 35,924$
Materials and Supplies 55,328 51,702 65,080 79.4%76,210 (3,626)
Operation and Contract 4,298,144 3,966,224 4,856,410 81.7%5,822,285 (331,920)
Capital Outlay 1,938,441 2,735,388 6,105,735 44.8%6,244,075 796,947
Total Expenditures 6,911,565$ 7,408,890$ 11,728,025$ 63.2%12,971,280$ 497,325$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 1,424,558$ 1,131,092$ (3,077,945)$ (2,476,530)$ (293,466)$
INTERFUND TRANSACTIONS
Transfers In -$ 221,085$ 221,085$ 100.0%221,085$ 221,085
Reimbursements To Other Funds (337,640) (459,860) (459,860) 100.0%(551,830) (122,220)
Total Interfund Transactions (337,640)$ (238,775)$ (238,775)$ 100.0%(330,745)$ 98,865$
NET FUND INCREASE (DECREASE)1,086,918$ 892,317$ (3,316,720)$ (2,807,275)$ (194,601)$
Village of Oak Brook
Water Fund Financial Update
For the Period Ending October 31, 2019
Total Total
Revenues Expenditures
10/31/19 Actual $ 8,539,982 7,408,890$
10/31/18 Actual $ 8,336,123 6,911,565$
% Change From Last Year 2.4%7.2%
Unmetered Water
Water Sales Sales Connection Fees Meter Charges Miscellaneous
10/31/19 Actual $ 8,065,866 $ 42,492 $ 172,250 $ 25,437 $ 61,122
10/31/18 Actual $ 8,002,272 $ 34,532 $ 110,894 $ 9,900 $ 72,354
% Change From Last Year 0.8%23.1%55.3%156.9%-15.5%
Five Year Trend
Materials &Operation &
Personnel Supplies Contractual Capital Outlay
10/31/19 Actual 655,576$ 51,702$ 3,966,224$ 2,735,388$
10/31/18 Actual 619,652$ 55,328$ 4,298,144$ 1,938,441$
% Change From Last Year 5.8%-6.6%-7.7%41.1%
Five Year Trend
Expenditures by Department
10/31/18 10/31/19 10/31/19 10/31/19 2019 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Public Works 4,930,081$ 4,666,436$ 5,638,950$ 82.8%7,299,035$ (263,645)$
Engineering & Capital Projects 1,981,484 2,742,454 6,089,075 45.0%6,224,075 760,970
Total Expenditures 6,911,565$ 7,408,890$ 11,728,025$ 63.2%13,523,110$ 497,325$
Five Year Trend
Village of Oak Brook
Water Fund - Major Sources Five Year Trend
For the Period Ending October 31, 2019
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Sports Core Fund Consolidated Presentation
For the Period Ending October 31, 2019
10/31/19 10/31/19
10/31/19 YTD % of 2019 10/31/18 Difference
B&T Recreation Food &Golf YTD Amended Amended Adopted YTD Prior
Programs Beverage Club Total Budget Budget Budget Total Year
DIRECT REVENUES
Memberships 222,006$ -$ 197,675$ 419,681$ 453,815$ 92.5%453,815$ 433,424$ (13,743)$
Greens Fees - - 901,632 901,632 928,160 97.1%930,000 871,665 29,967
Pro Shop Sales - - 193,420 193,420 193,685 99.9%200,000 180,084 13,336
Golf Lessons - - 33,726 33,726 40,000 84.3%40,000 36,705 (2,979)
Driving Range Fees - - 242,380 242,380 310,000 78.2%226,000 216,126 26,254
Rentals - - 327,920 327,920 366,275 89.5%459,000 398,398 (70,478)
Programs/User Fees 310,213 - - 310,213 245,255 126.5%253,450 241,570 68,643
Food Sales - 181,542 - 181,542 172,300 105.4%175,500 156,220 25,322
Beverage Sales - 266,784 - 266,784 247,315 107.9%252,500 227,136 39,648
Other Revenue 126,092 307,399 10,190 443,681 403,260 110.0%428,300 428,096 15,585
Total Direct Revenues 658,311$ 755,725$ 1,906,943$ 3,320,979$ 3,360,065$ 98.8%3,418,565$ 3,189,424$ 131,555$
DIRECT EXPENDITURES
Personnel 112,042$ 257,298$ 1,009,138$ 1,378,478$ 1,398,650$ 98.6%1,572,920$ 1,363,358$ 15,120$
Materials & Supplies 40,531 220,484 363,912 624,927 547,835 114.1%580,645 525,476 99,451
Operational & Contractual 524,755 93,474 275,654 893,883 1,060,335 84.3%1,115,975 1,028,452 (134,569)
Other - - - - (83,150) 0.0%(83,150) (128,577) 128,577
Capital 464,577 354,127 329,300 1,148,004 1,260,900 91.0%1,655,900 229,656 918,348
Total Direct Expenditures 1,141,905$ 925,383$ 1,978,004$ 4,045,292$ 4,184,570$ 96.7%4,842,290$ 3,018,365$ 1,026,927$
Direct Revenues Over (Under) Expenditures (483,594)$ (169,658)$ (71,061)$ (724,313)$ (824,505)$ 87.8%(1,423,725)$ 171,059$ (895,372)$
B&T Administration Overhead Allocation*108,340$ (108,340)$ -$ -$ -$ 0.0%-$ -$ -$
Operating Revenues Over (Under) Expenditures (375,254)$ (277,998)$ (71,061)$ (724,313)$ (824,505)$ 87.8%(1,423,725)$ 171,059$ (895,372)$
Transfer From General Fund 48,704$ 285,499$ -$ 334,203$ 821,725$ 40.7%1,216,725$ -$ 334,203$
Transfer From Golf Surcharge Fund - - 212,969 212,969 175,000 121.7%175,000 - 212,969
Reimbursement From Infrastructure Fund 20,000 - - 20,000 20,000 100.0%24,000 20,000 -
Reimbursement From Water Fund 6,670 - - 6,670 6,650 100.3%8,000 6,670 -
Adjusted Operating Revenues Over (Under) Expenditures (299,880)$ 7,501$ 141,908$ (150,471)$ 198,870$ -$ 197,729$ (348,200)$
*Overhead allocation is comprised of salaries, business forms, liability insurance, building & grounds maintenance and bank service fees in Program 811 -
Sports Core General Operations distributed to various Sports Core Programs on a % basis.
**Interfund loan is from the General Fund. This will be repaid as the season begins and cash becomes available.
Total Direct Total Direct
Revenues Expenditures
10/31/19 Actual $ 3,320,979 4,045,292$
10/31/18 Actual $ 3,189,424 3,018,365$
% Change From Last Year 4.1%34.0%
Driving Program/
Memberships Greens Fees Range Fees Rentals User Fees
10/31/19 Actual $ 419,681 $ 901,632 $ 242,380 $ 327,920 $ 310,213
10/31/18 Actual $ 433,424 $ 871,665 $ 216,126 $ 398,398 $ 241,570
% Change From Last Year -3.2%3.4%12.1%-17.7%28.4%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
10/31/19 Actual 1,378,478$ 624,927$ 893,883$ -$ 1,148,004$
10/31/18 Actual 1,363,358$ 525,476$ 1,028,452$ (128,577)$ 229,656$
% Change From Last Year 1.1%18.9%-13.1%-100.0%399.9%
Five Year Trend
Revenues by Department 10/31/18 10/31/19 10/31/19 10/31/19 2019 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Programs 660,846$ 658,311$ 646,495$ 101.8%686,515$ (2,535)$
Food & Beverage 614,683 755,725 127,800 591.3%663,000 141,042
Golf Club 1,913,895 1,906,943 567,997 335.7%2,069,050 (6,952)
Total Revenues 3,189,424$ 3,320,979$ 1,342,292$ 247.4%3,418,565$ 131,555$
Expenditures by Department 10/31/18 10/31/19 10/31/19 % of 2019 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Programs 949,407$ 1,141,905$ 344,363$ 331.6%1,883,075$ 192,498$
Food & Beverage 525,204 925,383 281,968 328.2%1,037,845 400,179
Golf Club 1,543,754 1,978,004 778,751 254.0%1,921,370 434,250
Total Expenditures 3,018,365$ 4,045,292$ 1,405,082$ 287.9%4,842,290$ 1,026,927$
Five Year Trend
Village of Oak Brook
Sports Core Fund - Major Sources Five Year Trend
For the Period Ending October 31, 2019
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Club Recreation Programs
For the Period Ending October 31, 2019 10/31/19 10/31/19
10/31/19 YTD % of 2019 10/31/18 Difference
811 812 813 815 816 YTD Amended Amended Adopted YTD Prior
B&T Admin Swimming Tennis Polo Open Fields Total Budget Budget Budget Total Year
Revenues:
Memberships -$ 207,256$ 14,750$ -$ -$ 222,006$ 244,815$ 90.7%244,815$ 229,374$ (7,368)$
Programs/User Fees - 19,732 49,083 - 241,398 310,213 245,255 126.5%253,450 241,570 68,643
Other Revenue (1,009) 6,473 5,888 - 114,740 126,092 188,210 67.0%188,250 189,902 (63,810)
Total Revenue (1,009)$ 233,461$ 69,721$ -$ 356,138$ 658,311$ 678,280$ 97.1%686,515$ 660,846$ (2,535)$
Expenditures:
Personnel 88,495$ 19,585$ -$ -$ 3,962$ 112,042$ 172,620$ 64.9%182,405$ 145,600$ (33,558)$
Materials & Supplies 24,726 13,719 711 - 1,375 40,531 26,070 155.5%26,350 18,499 22,032
Operational & Contractual 61,205 275,329 60,005 - 128,216 524,755 663,600 79.1%673,820 693,720 (168,965)
Capital 25,195 424,762 - - 14,620 464,577 605,500 76.7%1,000,500 91,588 372,989
Total Expenditures 199,621$ 733,395$ 60,716$ -$ 148,173$ 1,141,905$ 1,467,790$ 77.8%1,883,075$ 949,407$ 192,498$
Direct Revenues Over (Under) Expenditures (200,630)$ (499,934)$ 9,005$ -$ 207,965$ (483,594)$ (789,510)$ 61.3%(1,196,560)$ (288,561)$ (195,033)$
B&T Administration Overhead Allocation*200,630$ (72,227)$ (20,063)$ -$ -$ 108,340$ 89,930$ 120.5%91,410$ 114,264$ (5,924)$
Revenues Over (Under) Expenditures -$ (572,161)$ (11,058)$ -$ 207,965$ (375,254)$ (699,580)$ 53.6%(1,105,150)$ (174,297)$ (200,957)$
Transfer From General Fund 12,476$ 36,228$ -$ -$ -$ 48,704$ 570,500$ 8.5%965,500$ -$ 48,704$
Reimbursement From Infrastructure Fund 20,000 - - - - 20,000 20,000 100.0%24,000 20,000 -$
Reimbursement From Water Fund 6,670 - - - - 6,670 6,650 100.3%8,000 6,670 -
Adjusted Revenues Over (Under) Expenditures 39,146$ (535,933)$ (11,058)$ -$ 207,965$ (299,880)$ (102,430)$ (107,650)$ (147,627)$ (152,253)$
*Overhead allocation is comprised of salaries, business forms, liability insurance, building & grounds maintenance and bank service fees in Program 811 - Sports Core
General Operations distributed to various Sports Core Programs on a percentage basis.
**Interfund loan is from the General Fund. This will be repaid as the season begins and cash becomes available.
Village of Oak Brook
Monthly Operating Statement
Sports Core Food & Beverage Programs
For the Period Ending October 31, 2019
10/31/19 10/31/19
821 822 823 10/31/19 YTD % of 2019 10/31/18 Difference
B&T Poolside Golf YTD Amended Amended Adopted YTD Prior
Clubhouse Café Clubhouse Total Budget Budget Budget Total Year
Revenues:
Food Sales -$ 35,375$ 146,167$ 181,542$ 172,300$ 105.4%175,500$ 156,220$ 25,322$
Beverage Sales - 19,534 247,250 266,784 247,315 107.9%252,500 227,136 39,648
Other Revenue 307,399 - - 307,399 210,000 146.4%235,000 231,327 76,072
Total Revenue 307,399$ 54,909$ 393,417$ 755,725$ 629,615$ 120.0%663,000$ 614,683$ 141,042$
Expenditures:
Personnel 109,766$ 29,839$ 117,693$ 257,298$ 255,400$ 100.7%286,125$ 225,319$ 31,979$
Materials & Supplies 19,500 30,849 170,135 220,484 196,715 112.1%208,200 169,821 50,663
Operational & Contractual 85,066 25 8,383 93,474 132,730 70.4%153,120 118,076 (24,602)
Capital 354,127 - - 354,127 390,400 90.7%390,400 11,988 342,139
Total Expenditures 568,459$ 60,713$ 296,211$ 925,383$ 975,245$ 94.9%1,037,845$ 525,204$ 400,179$
Direct Revenues Over (Under) Expenditures (261,060)$ (5,804)$ 97,206$ (169,658)$ (345,630)$ 49.1%(374,845)$ 89,479$ (259,137)$
B&T Administration Overhead Allocation*(100,315)$ (8,025)$ -$ (108,340)$ (89,930)$ 120.5%(91,410)$ (114,264)$ 5,924$
Revenues Over (Under) Expenditures (361,375)$ (13,829)$ 97,206$ (277,998)$ (435,560)$ 63.8%(466,255)$ (24,785)$ (253,213)$
Transfer From General Fund 285,499$ -$ -$ 285,499$ 251,225$ 113.6%251,225$ -$ 285,499$
Adjusted Revenues Over (Under) Expenditures (75,876)$ (13,829)$ 97,206$ 7,501$ (184,335)$ (215,030)$ (24,785)$ 32,286$
*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.
Village of Oak Brook
Monthly Operating Statement
Golf Club Programs
For the Period Ending October 31, 2019
10/31/19 10/31/19
831 832 833 834 10/31/19 YTD % of 2019 10/31/18 Difference
Golf General Golf Learning Golf Cart Golf Course YTD Amended Amended Adopted YTD Prior
Operation & Practice Operations Maintenance Total Budget Budget Budget Total Year
Revenues:
Memberships 197,675$ -$ -$ -$ 197,675$ 209,000$ 94.6%209,000$ 204,050$ (6,375)$
Greens Fees 901,632 - - - 901,632 928,160 97.1%930,000 871,665 29,967
Pro Shop Sales 193,420 - - - 193,420 193,685 99.9%200,000 180,084 13,336
Golf Lessons - 33,726 - - 33,726 40,000 84.3%40,000 36,705 (2,979)
Driving Range Fees - 242,380 - - 242,380 310,000 78.2%226,000 216,126 26,254
Rentals 4,556 - 323,364 - 327,920 366,275 89.5%459,000 398,398 (70,478)
Other Revenue 10,190 - - - 10,190 5,050 201.8%5,050 6,867 3,323
Total Revenue 1,307,473$ 276,106$ 323,364$ -$ 1,906,943$ 2,052,170$ 92.9%2,069,050$ 1,913,895$ (6,952)$
Expenditures:
Personnel 421,404$ 59,119$ 53,581$ 475,034$ 1,009,138$ 970,630$ 104.0%1,104,390$ 992,439$ 16,699$
Materials & Supplies 165,685 19,688 1,348 177,191 363,912 325,050 112.0%346,095 337,156 26,756
Operational & Contractual 191,636 631 53,107 30,280 275,654 264,005 104.4%289,035 216,656 58,998
Other - - - - - (83,150) 0.0%(83,150) (128,577) 128,577
Capital 241,070 - - 88,230 329,300 265,000 124.3%265,000 126,080 203,220
Total Expenditures 1,019,795$ 79,438$ 108,036$ 770,735$ 1,978,004$ 1,741,535$ 113.6%1,921,370$ 1,543,754$ 434,250$
Direct Revenues Over (Under) Expenditures 287,678$ 196,668$ 215,328$ (770,735)$ (71,061)$ 310,635$ -22.9%147,680$ 370,141$ (441,202)$
Transfer from Golf Surcharge 212,969$ -$ -$ 212,969$ 175,000$ 121.7%175,000$ -$ 212,969$
Adjusted Revenues Over (Under) Expenditures 500,647$ 196,668$ 215,328$ (770,735)$ 141,908$ 485,635$ 322,680$ 370,141$ (228,233)$