08 - August 2019 Monthly Financial ReportVILLAGE
OAK BROOK
OF
MONTHLY FINANCIAL REPORTS
AUGUST 2019
ITEM 6.D.
Total
Cash and Cash Pooled Cash and
Fund Equivalents Investments Investments % By Fund
General Corporate $6,613,385 $14,383,258 $20,996,643 44.8%
Hotel/Motel Tax 3,140,865 1,943,592 5,084,457 10.9%
Motor Fuel Tax 798,234 128,328 926,562 2.0%
Infrastructure 7,196,549 2,368,993 9,565,542 20.4%
Promenade TIF 39,799 - 39,799 0.1%
Water 4,307,536 3,249,901 7,557,437 16.1%
Sports Core 214,729 - 214,729 0.5%
Golf Surcharge 77,997 235,722 313,719 0.7%
Self-Insurance 1,068,719 - 1,068,719 2.3%
Garage 327,726 - 327,726 0.7%
Equipment Replacement 313,114 448,523 761,637 1.6%
Total $24,098,653 $22,758,317 $46,856,970 100.0%
Change in Cash and Investments by Fund :
Balance at Balance at Year-to-Date Year-to-Date
Fund January 1, 2019 August 31, 2019 Change ($)Change (%)
General Corporate $18,092,186 $20,996,643 $2,904,457 16.1%
Hotel/Motel Tax 4,843,367 5,084,457 241,090 5.0%
Motor Fuel Tax 782,203 926,562 144,359 18.5%
Infrastructure 9,322,381 9,565,542 243,161 2.6%
Promenade TIF 257,485 39,799 (217,686)-84.5%
Water 6,449,315 7,557,437 1,108,122 17.2%
Sports Core 190,397 214,729 24,332 12.8%
Golf Surcharge 442,152 313,719 (128,433)-29.0%
Self-Insurance 468,568 1,068,719 600,151 128.1%
Garage 331,134 327,726 (3,408)-1.0%
Equipment Replacement 1,636,238 761,637 (874,601)-53.5%
$42,815,426 $46,856,970 $4,041,544 9.4%
Book Bank/Market
Value Value
Pooled Checking $672,350 $1,130,481
Sports Core Checking 292,634 231,725
Pooled IPTIP 23,024,747 23,024,747
Water E-Pay IPTIP 108,922 108,922
$24,098,653 $24,495,875
Pooled Investments:
Investments-Municipal Bonds $6,203,897 $6,208,464
Investments-Corporate Bonds 8,286,389 8,358,396
Government & Agency Obligations 1,658,418 1,644,892
Certificates of Deposit 6,485,000 6,518,795
Accrued Interest 124,613 124,613
Total Pooled Investments $22,758,317 $22,855,160
Total Cash and Investments $46,856,970 $47,351,035
For August, total interest revenue is $88,589 and YTD revenue is $710,214.
Total investment yield for the portfolio is:
Pooled
Investments Illinois Funds Total
Monthly yield 0.20%0.21%0.20%
YTD yield 1.57%1.67%1.62%
Last 12 months yield 2.29%38.00%2.34%
The weighted average yield of the current pooled investment portfolio is 2.39%.
Monthly Treasurer's Report
August 31, 2019
Monthly Treasurer's Report
August 2019
The table below lists the detail investment holdings at J.P. Morgan Securities as of 8/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%$501,212 $500,085 $3,680
New York N Y City #64971QTX1 02/22/16 05/01/21 2.350%2.000%201,130 202,104 1,552
Florida Hurricane #34074GDH4 03/30/16 07/01/20 2.995%2.150%503,394 504,525 2,495
Bloomingdale Mich Pub Sch Dist #094383FS0 04/26/16 05/01/22 2.710%2.150%507,186 509,865 4,478
Milan Mich Area Achs #598801JD1 05/26/16 05/01/20 1.931%1.931%245,000 245,125 1,476
Indiana Bd Bk Rev Taxable #4546248F7 01/06/17 01/15/20 2.934%1.900%255,939 255,762 970
Garland Cnty Ark Sales & Use #36609PAN3 02/06/17 11/01/19 1.795%1.840%499,960 499,645 3,116
Lanse Creuse Mich Pub Schs #516228RL9 05/02/17 05/01/20 2.159%2.159%100,000 100,089 717
California St GO Bonds #13063A7G3 05/08/17 10/01/19 6.200%1.600%501,929 501,500 12,635
Connecticut St GO Bds 2016 #20772J3F7 06/15/17 08/15/21 1.750%2.300%494,774 497,140 336
Fowlerville Mich Comnty Schs #351280MS8 10/03/17 05/01/20 2.045%1.750%500,980 500,530 3,238
Racine Cnty WI #749845UK7 12/20/17 12/01/20 2.150%2.150%750,000 748,253 4,031
Wisconsin St Gen Fd Annual #977100CW4 01/05/18 05/01/20 1.446%2.100%597,393 598,650 2,796
Wright County Min #982276BC0 07/18/19 12/01/20 2.000%2.000%545,000 545,191 1,817
Total Municipal Bonds $6,203,897 $6,208,464 $43,337
Corporate Bonds:
Goldman Sachs #38141GVP9 09/26/18 09/15/20 2.750%3.180%497,825 502,565 6,302
Fifth Third #31677QBH1 10/11/18 09/27/19 1.625%2.750%999,250 999,600 6,951
Wells Fargo #94974BGR5 01/15/19 12/07/20 2.550%3.120%1,380,296 1,397,784 8,566
SunTrust #86787EAU1 01/28/19 01/29/21 2.590%3.050%499,111 500,675 1,079
PNC Bank #69353RFH6 01/30/19 01/22/21 2.500%3.020%496,487 503,425 1,354
Morgan Stanley #61747WAL3 03/08/19 07/28/21 5.500%3.034%1,097,606 1,114,029 5,133
Citigroup #172967LC3 04/01/19 12/08/21 2.900%2.754%1,003,188 1,017,340 6,122
Bank of America #06051GFT1 04/03/19 10/19/20 2.625%2.625%700,000 705,362 6,482
Goldman Sachs #38143U8F1 05/02/19 02/25/21 2.875%2.707%365,877 368,471 148
American Honda #02665WBG5 07/31/19 09/09/21 1.700%2.180%495,282 497,870 4,084
BB&T Corp 08/15/19 02/01/21 2.150%2.010%751,467 751,275 1,147
Total Corporate Bonds $8,286,389 $8,358,396 $47,368
Government & Agency Obligations:
*Government National Mtg Assn #38379UEM4 02/29/16 02/16/51 2.300%2.245%$675,703 $661,722 $2,250
*Government National Mtg Assn #38381WV96 08/06/19 07/20/54 2.250%2.293%$982,715 $983,170 $1,817
Total Government & Agency Obligations:$1,658,418 $1,644,892 $4,067
Certificates of Deposit:
State Bk India NY #8562846A7 01/26/17 01/26/22 2.250%2.250%$245,000 $247,509 $559
Marlin Bank #57116ANU8 05/10/17 11/12/19 1.610%1.610%245,000 244,833 221
American Express Fed Svgs #02587CER7 05/10/17 11/12/19 1.700%1.700%245,000 244,878 1,284
American Express Centurion #02587DV96 08/15/17 08/17/20 1.900%1.900%245,000 245,380 194
Sallie Mae #795450C86 08/16/17 08/17/20 1.900%1.900%245,000 245,380 194
Merrick Bank South Jordan #59013JZS1 08/21/17 08/21/20 1.800%1.800%245,000 245,149 122
Pinnacle Bank #72345SFS5 08/30/17 08/31/20 1.800%1.800%115,000 115,074 6
Jackson County Bank #466682AP6 08/31/17 03/01/21 1.850%1.850%245,000 245,311 2,285
Barclays Bank #06740KKX4 09/27/17 09/28/20 1.950%1.950%245,000 245,549 2,050
Capital One Bank #1404205E6 10/04/17 10/04/19 1.700%1.700%245,000 244,936 1,695
Goldman Sachs Bank #38148PRK5 10/18/17 10/19/20 1.950%1.950%245,000 245,568 1,758
FirstBank PR Santurce #33767A6M8 11/03/17 11/03/20 2.000%2.000%245,000 245,728 364
Morgan Stanley #61747MQ53 03/22/18 03/23/20 2.550%2.550%245,000 245,982 2,642
Investors Community Bank #46147UTT7 08/28/18 02/28/20 2.550%2.550%245,000 245,835 35
Lakeside Bank #51210SPS0 08/30/18 03/30/20 2.550%2.550%245,000 246,029 17
Bank United #066519GJ2 08/31/18 02/20/20 2.500%2.500%245,000 245,784 3,088
Compass Bank #20451PVW3 10/26/18 10/26/20 3.000%3.000%245,000 248,511 2,542
UBS Bank #90348JFH8 10/30/18 10/29/20 3.050%3.050%245,000 248,692 24
Citibank #17294XJP2 10/31/18 10/31/20 3.000%3.000%245,000 245,372 2,501
Discover Bank #254673WF9 11/07/18 11/09/20 3.000%3.000%245,000 248,621 2,337
Ally Bank #02007GFX6 11/08/18 11/09/20 3.000%3.000%245,000 248,619 2,317
Comenity Cap Bank #20033AU46 04/15/19 04/15/21 2.500%2.500%245,000 247,862 250
Morgan Stanley #61760AE21 05/30/19 06/01/21 2.400%2.400%245,000 247,619 1,470
First St Bank DeQueen #336460CU2 07/18/19 07/19/21 2.000%2.000%245,000 245,973 196
Bank Hapoalim #06251AW89 07/19/19 07/19/21 2.000%2.000%245,000 246,423 613
Capital One Natl Assn #14042RMF5 07/24/19 07/26/19 2.050%2.050%245,000 246,203 628
TIAA FSB Jacksonville #87270LCN1 07/29/19 07/29/21 2.000%2.000%245,000 245,975 449
Total Certificates of Deposits $6,485,000 $6,518,795 $29,841
Total J.P.Morgan Securities $22,633,704 $22,730,547 $124,613
*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
August 31, 2019
Cash & Investments by Fund - Total $46.9 million
Cash & Investments by Type - Total $46.9 million
Checking
Illinois Funds
Certificates of Deposit
Municipal Bonds
Corporate Bonds
Government & Agency Obligations
Accrued Interest
General Corporate
44.81%
Hotel/Motel Tax
10.85%Motor Fuel Tax
1.98%
Infrastructure
20.41%
Promenade TIF
0.08%
Water
16.13%
Sports Core
0.46%
Golf Surcharge
0.67%
Self-Insurance
2.28%Garage
0.70%
Equipment
Replacement
1.63%
Checking, $1.0
Illinois Funds, $23.1
Certificates of Deposit,
$6.5
Municipal Bonds, $6.2
Corporate Bonds, $8.3
Government & Agency
Obligations, $1.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)19,061,434 $16,256,714 $2,804,720 $14,895
Main operating fund of the Village.
Hotel Fund (Major Fund)$906,258 $436,820 $469,438 ($1,994,045)
Collects and spends resources from the
3% hotel/motel tax.
Motor Fuel Tax Fund $144,361 $0 $144,361 ($164,160)
Collects and spends resources from the
State motor fuel tax.
Infrastructure Fund (Major Fund)$4,394,918 $4,048,569 $346,349 ($5,374,210)
Accounts for construction and maintenance of
roadways, drainage, and safety path systems.
Promenade TIF Fund (Major Fund)$246,767 $464,453 ($217,686)($250,890)
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)$6,362,268 $5,168,916 $1,193,352 ($2,932,130)
Collects user fees for the distribution of water
and maintenance of infrastructure.
Sports Core Fund (Major Fund)$3,145,466 $3,130,651 $14,815 $78,885
Accounts for revenues and expenses relating
to administration, programs, food and beverage
operations, and golf course.
Golf Surcharge Fund $84,537 $212,969 ($128,432)($64,680)
Accounts for the collection of the $3 per round
golf surcharge.
Internal Service Funds
Self Insurance Fund $2,248,580 $1,533,589 $714,991 ($24,985)
Accounts for the Village's health insurance costs
and the related contributions from the Village,
employees, retirees, and other agencies.
Garage Fund $465,021 $473,659 ($8,638)($47,780)
Accounts for the maintenance of the Village's vehicle
fleet and the related departmental reimbursements.
Equipment Replacement Fund $171,302 $1,045,070 ($873,768)($1,056,660)
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 August 31, 2019
Village of Oak Brook
Monthly Financial Report – Fund Narrative
For the Period Ending August 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
x Sales Tax collections through August
2019 are $8,377,249, which is
$190,791 higher than through August
2018 and $213,999 over FY19 budget
to date. The increase is primarily due
to the opening of newer businesses
in town and general inflationary
growth. August 2019 collections
have been consistent with recent
years with the exception of a one-
time distribution in 2016.
x Other Intergovernmental Tax collections through August 2019 are $1,044,345, which is
$119,693 higher than through August 2018 and $133,095 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.
x Telecommunications/Utility Tax collections through August 2019 are $4,207,387, which is
$113,108 higher than through August 2018 and $263,737 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.
x Licenses and Permits revenue through August 2019 is $2,939,279, which is $298,199 higher
than through August 2018 and $1,338,274 over FY19 budget to date. The Village issued a
number of large building permits in 2019, including Senior Lifestyle.
x Charges for Services revenue through August 2019 is $828,430, which is $107,169 higher than
through August 2018, but $149,405 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.
x Personnel expenditures through August 2019 are $12,070,539, which is $614,349 more than
through August 2018, but $477,191 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 ongoing labor negotiations.
x Operation and Contract expenditures through August 2019 are $2,801,756, which is $368,950
more than through August 2018, but $71,284 under FY19 budget to date. The increase is
primarily due to the addition of five contracted paramedics to increase ambulance services.
x Capital Outlay expenditures through August 2019 are $664,207, which is $1,356,227 less than
through August 2018 and $141,318 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
x Hotel Tax collections through August 2019 are $829,538, which is $13,962 lower than through
August 2018, but $33,538 over FY19 budget to date. The decrease is due to general decreases
in hotel stays and events.
x Capital Outlay expenditures have not occurred yet in 2019 due to the delay in the Jorie,
Kensington, and Forest Gate streetscape beautification project. This project may occur later in
2019 or 2020.
Infrastructure Fund
x Non-Home Rule Sales Tax collections
through August 2019 are $3,799,573,
which is $90,473 higher than through
August 2018 and $101,573 over FY19
budget to date. The increase is
primarily due to the opening of
newer businesses in town and
general inflationary growth. August
2019 collections have been
consistent with recent years with the
exception of a one-time distribution
in 2016.
x Operation and Contractual expenditures through August 2019 are $1,023,987, which is
$382,389 higher than through August 2018, but $99,678 under FY19 budget to date. The
increase is due to more being spent on project engineering than in 2018.
x Capital Outlay expenditures through August 2019 are $1,918,181, which is $1,850,905 higher
than through August 2018, but $5,697,974 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
x Water Sales revenue through August 2019 is $5,730,027, which is $24,988 higher than through
August 2018, but $233,353 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.
x Operation and Contractual expenditures through August 2019 are $2,872,690, which is
$315,317 lower than through August 2018 and $1,016,495 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.
x Capital Outlay expenditures through August 2019 are $1,356,562, which is $76,710 lower than
through August 2018 and $3,053,358 under FY19 budget to date. The 2019 water main
replacement projects recently kicked off and are expected to continue throughout the
remainder of 2019.
Sports Core Fund
x Memberships revenue through August 2019 is $419,681, which is $13,743 lower than through
August 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.
x Greens Fees revenue through August 2019 is $692,353, which is $12,995 higher than through
August 2018, but $25,982 under FY19 budget to date. Total rounds played is consistent with the
2018 season so far despite the unfavorable weather during early 2019.
x Other Revenue collections through August 2019 are $224,166, which is $106,474 lower than
through August 2018 and $88,194 under FY19 budget to date. This is due to the cancellation of
the Taste of Oak Brook event. There has been an increase in B&T Clubhouse rentals in FY19 to
offset this loss of revenue.
x Materials & Supplies expenditures through August 2019 are $498,161, which is $125,317 higher
than through August 2018 and $22,066 over FY19 budget to date. The increase in FY19 is due to
the timing of payments for golf maintenance supplies and the timing of inventory cost of sales.
x Capital Outlay expenditures through August 2019 are $740,685, which is $543,430 higher than
through August 2018 and $100,215 over 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. Expenditures are over budget to date due to the timing of B&T renovations
and the completion of the golf patio work carrying into 2019.
Equipment Replacement Fund
x Other Expenditures through August 2019 are $1,006,392, 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.
8/31/19 8/31/19
8/31/18 8/31/19 YTD % of 2019 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 8,186,458$ 8,377,249$ 8,163,250$ 102.6%12,325,000$ 190,791$
Other Intergovernmental Tax*924,652 1,044,345 911,250 114.6%1,227,750 119,693
Telecommunications/Utility Tax 4,094,279 4,207,387 3,943,650 106.7%5,857,500 113,108
Licenses and Permits 2,641,080 2,939,279 1,601,005 183.6%2,335,050 298,199
Charges for Services 721,261 828,430 977,835 84.7%1,491,400 107,169
Fines and Penalties 120,277 156,786 105,360 148.8%158,000 36,509
Administrative Towing Fees 21,900 15,004 20,000 75.0%30,000 (6,896)
Interest on Investments 222,410 307,507 220,000 139.8%330,000 85,097
Franchise/IMF Maint. Fee 107,304 106,424 159,750 66.6%213,000 (880)
Miscellaneous Income 309,716 149,316 132,550 112.6%212,800 (160,400)
Total Operating Revenues 17,349,337$ 18,131,727$ 16,234,650$ 111.7%24,180,500$ 782,390$
OPERATING EXPENDITURES
Personnel 11,456,190$ 12,070,539$ 12,547,730$ 96.2%18,183,745$ 614,349$
Materials and Supplies 303,270 291,273 406,550 71.6%559,780 (11,997)
Operation and Contract 2,432,806 2,801,756 2,873,040 97.5%4,224,475 368,950
Other Expenditures 4,400 7,336 7,500 97.8%10,000 2,936
Capital Outlay 2,020,434 664,207 805,525 82.5%862,475 (1,356,227)
Total Operating Expenditures 16,217,099$ 15,835,111$ 16,640,345$ 95.2%23,840,475$ (381,988)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 1,132,238$ 2,296,616$ (405,695)$ 340,025$ 1,164,378$
OTHER TRANSACTIONS
Transfers In -$ 508,235$ 508,235$ 100.0%508,235$ 508,235$
Transfers Out - (334,203) (421,725) 79.2%(1,216,725) (334,203)
Reimbursements From Other Funds 419,368 421,472 421,480 100.0%632,210 2,104
Reimbursements To Other Funds (87,544) (87,400) (87,400) 100.0%(131,100) 144
Total Interfund Transactions 331,824$ 508,104$ 420,590$ 120.8%(207,380)$ 176,280$
NET FUND INCREASE (DECREASE)1,464,062$ 2,804,720$ 14,895$ 132,645$ 1,340,658$
*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 August 31, 2019
Total Total
Revenues Expenditures
8/31/19 Actual 18,131,727$ 15,835,111$
8/31/18 Actual 17,349,337$ 16,217,099$
% Change From Last Year 4.5%-2.4%
Major Revenues Other
Intergov.Licenses &Charges for
Sales Tax Tax Telecom Tax Permits Services
8/31/19 Actual 8,377,249$ 1,044,345$ 4,207,387$ 2,939,279$ 828,430$
8/31/18 Actual $ 8,186,458 $ 924,652 $ 4,094,279 $ 2,641,080 $ 721,261
% Change From Last Year 2.3%12.9%2.8%11.3%14.9%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
8/31/19 Actual 12,070,539$ 291,273$ 2,801,756$ 7,336$ 664,207$
8/31/18 Actual 11,456,190$ 303,270$ 2,432,806$ 4,400$ 2,020,434$
% Change From Last Year 5.4%-4.0%15.2%66.7%-67.1%
Five Year Trend
Expenditures by Department
8/31/18 8/31/19 8/31/19 8/31/19 2019 Difference Five
YTD YTD YTD % of Annual Prior Year
Department Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 1,446,106$ 1,562,795$ 1,769,495$ 88.3%2,700,820$ 116,689$
Financial Services 488,170 508,750 544,810 93.4%782,860 20,580
Public Works 435,934 619,492 607,075 102.0%886,420 183,558
Engineering & Capital Projects 1,917,304 317,120 306,600 103.4%459,900 (1,600,184)
Library 580,082 623,763 643,660 96.9%928,675 43,681
Police 5,712,392 6,098,968 6,373,555 95.7%8,891,960 386,576
Fire 4,998,202 5,460,263 5,721,355 95.4%8,207,785 462,061
Development Services 638,909 643,960 673,795 95.6%982,055 5,051
Total Expenditures 16,217,099$ 15,835,111$ 16,640,345$ 95.2%23,840,475$ (381,988)$
Five Year Trend
For the Period Ending August 31, 2019
General Fund - Five Year Trend
Village of Oak Brook
Revenues Expenditures
8/31/19 8/31/19
8/31/18 8/31/19 YTD % of 2019 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Hotel Tax 843,500$ 829,538$ 796,000$ 104.2%1,268,000$ (13,962)$
Interest 50,147 76,720 20,000 383.6%30,000 26,573
Miscellaneous 2,977 - - 0.0%- (2,977)
Total Operating Revenues 896,624$ 906,258$ 816,000$ 111.1%1,298,000$ 9,634$
EXPENDITURES
Operation and Contract 251,931$ 368,076$ 385,230$ 95.5%577,860$ 116,145$
Capital Outlay 72,363 - 2,356,095 0.0%4,180,545 (72,363)
Total Expenditures 324,294$ 368,076$ 2,741,325$ 13.4%4,758,405$ 43,782$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 572,330$ 538,182$ (1,925,325)$ -28.0%(3,460,405)$ (34,148)$
INTERFUND TRANSACTIONS
Reimbursements to Other Funds (66,360) (68,744)$ (68,720)$ 100.0%(103,115)$ (2,384)$
Total Interfund Transactions (66,360)$ (68,744)$ (68,720)$ 100.0%(103,115)$ (2,384)$
NET FUND INCREASE (DECREASE)505,970$ 469,438$ (1,994,045)$ (3,563,520)$ (36,532)$
Note - Expenditures are recorded in program 171.
Village of Oak Brook
Hotel Tax Fund Financial Update
For the Period Ending August 31, 2019
Total Total
Revenues Expenditures
8/31/19 Actual $ 906,258 368,076$
8/31/18 Actual $ 896,624 324,294$
% Change From Last Year 1.1%13.5%
Major Revenues
Hotel Tax Interest Miscellaneous
8/31/19 Actual $ 829,538 $ 76,720 $ -
8/31/18 Actual $ 843,500 $ 50,147 $ 2,977
% Change From Last Year -1.7%53.0%-100.0%
Five Year Trend
Major Expenditures Operation &
Contractual Capital Outlay
8/31/19 Actual 368,076$ -$
8/31/18 Actual 251,931$ 72,363$
% Change From Last Year 46.1%-100.0%
Five Year Trend
Village of Oak Brook
Hotel Tax Fund - Major Sources Five Year Trend
For the Period Ending August 31, 2019
Five Year Trend
Revenues Expenditures
8/31/19 8/31/19
8/31/18 8/31/19 YTD % of 2019 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 3,709,100$ 3,799,573$ 3,698,000$ 102.7%5,548,000$ 90,473$
Interest 107,643 156,924 56,000 280.2%80,000 49,281
Miscellaneous 2,729 - 3,320 0.0%5,000 (2,729)
Total Operating Revenues 3,819,472$ 3,956,497$ 3,757,320$ 105.3%5,633,000$ 137,025$
OPERATING EXPENDITURES
Personnel 823,495$ 894,524$ 899,220$ 99.5%1,322,375$ 71,029$
Materials and Supplies 91,790 104,189 123,240 84.5%246,845 12,399
Operation and Contract 641,598 1,023,987 1,123,665 91.1%1,663,435 382,389
Capital Outlay 67,276 1,918,181 7,616,155 25.2%10,008,575 1,850,905
Total Operating Expenditures 1,624,160$ 3,940,881$ 9,762,280$ 40.4%13,241,230$ 2,316,721$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 2,195,312$ 15,616$ (6,004,960)$ -0.3%(7,608,230)$ (2,179,696)$
INTERFUND TRANSACTIONS
Transfers In 7,790$ 216,125$ 516,125$ 41.9%1,116,125$ 208,335$
Reimbursements From Other Funds 120,752 222,296 222,320 100.0%333,445 101,544
Reimbursements To Other Funds (109,912) (107,688) (107,695) 100.0%(161,535) 2,224
Total Interfund Transactions 18,630$ 330,733$ 630,750$ 52.4%1,288,035$ 312,103$
NET FUND INCREASE (DECREASE)2,213,942$ 346,349$ (5,374,210)$ (6,320,195)$ (1,867,593)$
Village of Oak Brook
Infrastructure Fund Financial Update
For the Period Ending August 31, 2019
Total Total
Revenues Expenditures
8/31/19 Actual $ 3,956,497 3,940,881$
8/31/18 Actual $ 3,819,472 1,624,160$
% Change From Last Year 3.6%142.6%
Major Revenues
Sales Tax Grants Interest Miscellaneous
8/31/19 Actual $ 3,799,573 $ - $ 156,924 $ -
8/31/18 Actual $ 3,709,100 $ - $ 107,643 $ 2,729
% Change From Last Year 2.4%0.0%45.8%-100.0%
Five Year Trend
Major Expenditures Materials &Operation &
Personnel Supplies Contractual Capital Outlay
8/31/19 Actual 894,524$ 104,189$ 1,023,987$ 1,918,181$
8/31/18 Actual 823,495$ 91,790$ 641,598$ 67,276$
% Change From Last Year 8.6%13.5%59.6%2751.2%
Five Year Trend
Expenditures by Department
8/31/18 8/31/19 8/31/19 8/31/19 2019 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 93,863$ 108,509$ 117,095$ 92.7%179,485$ 14,646$
Public Works 1,255,666 2,140,022 5,530,660 38.7%6,462,865 884,356
Engineering & Capital Projects 274,631 1,692,350 4,114,525 41.1%6,760,415 1,417,719
Total Expenditures 1,624,160$ 3,940,881$ 9,762,280$ 40.4%13,402,765$ 2,316,721$
Five Year Trend
Village of Oak Brook
Infrastructure Fund - Major Sources Five Year Trend
For the Period Ending August 31, 2019
Revenues Expenditures
8/31/19 8/31/19
8/31/18 8/31/19 YTD % of 2019 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 34,169$ 39,820$ 33,500$ 118.9%100,000$ 5,651$
Real Estate Tax 186,562 205,855 180,000 114.4%360,000 19,293
Interest 776 1,092 600 182.0%900 316
Total Operating Revenues 221,507$ 246,767$ 214,100$ 115.3%460,900$ 25,260$
EXPENDITURES
Operation and Contract 3,403$ 3,473$ 4,010$ 86.6%4,210$ 70$
Other Expenditures 489,820 460,980 460,980 100.0%460,980 (28,840)
Total Expenditures 493,223$ 464,453$ 464,990$ 99.9%465,190$ (28,770)$
NET FUND INCREASE (DECREASE)(271,716)$ (217,686)$ (250,890)$ (4,290)$ 54,030$
Note - Expenditures are recorded in program 283.
Village of Oak Brook
Promenade TIF Fund Financial Update
For the Period Ending August 31, 2019
Total Total
Revenues Expenditures
8/31/19 Actual $ 246,767 464,453$
8/31/18 Actual $ 221,507 493,223$
% Change From Last Year 11.4%-5.8%
Major Revenues Real Estate
Sales Tax Tax Interest
8/31/19 Actual $ 39,820 $ 205,855 $ 1,092
8/31/18 Actual $ 34,169 $ 186,562 $ 776
% Change From Last Year 16.5%10.3%40.7%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures
8/31/19 Actual 3,473$ 460,980$
8/31/18 Actual 3,403$ 489,820$
% Change From Last Year 2.1%-5.9%
Five Year Trend
Village of Oak Brook
Promenade TIF Fund - Major Sources Five Year Trend
For the Period Ending August 31, 2019
Five Year Trend
Revenues Expenditures
8/31/19 8/31/19
8/31/18 8/31/19 YTD % of 2019 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Plan Review Fees 600 1,050$ 1,000$ 105.0%1,500$ 450$
Building/Inspection Fees 5,063 5,813 3,320 175.1%5,000 750
Water Sales 5,705,039 5,730,027 5,963,380 96.1%10,223,250 24,988
Unmetered Sales 21,736 31,997 20,000 160.0%30,000 10,261
Water Connection Fees 109,284 163,530 33,200 492.6%50,000 54,246
Fire Service Charge - - 3,320 0.0%5,000 -
Meter Charges 8,334 23,307 13,340 174.7%20,000 14,973
Special Services 16,394 16,772 15,000 111.8%30,000 378
Interest on Investments 61,169 120,272 36,640 328.3%55,000 59,103
Miscellaneous 59,245 48,415 50,000 96.8%75,000 (10,830)
Total Operating Revenues 5,986,864$ 6,141,183$ 6,139,200$ 100.0%10,494,750$ 154,319$
EXPENDITURES
Personnel 506,463$ 540,678$ 571,360$ 94.6%828,710$ 34,215$
Materials and Supplies 44,533 31,098 54,060 57.5%76,210 (13,435)
Operation and Contract 3,188,007 2,872,690 3,889,185 73.9%5,822,285 (315,317)
Capital Outlay 1,433,272 1,356,562 4,409,920 30.8%6,244,075 (76,710)
Total Expenditures 5,172,275$ 4,801,028$ 8,924,525$ 53.8%12,971,280$ (371,247)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 814,589$ 1,340,155$ (2,785,325)$ (2,476,530)$ 525,566$
INTERFUND TRANSACTIONS
Transfers In -$ 221,085$ 221,085$ 100.0%221,085$ 221,085
Reimbursements To Other Funds (270,112) (367,888) (367,890) 100.0%(551,830) (97,776)
Total Interfund Transactions (270,112)$ (146,803)$ (146,805)$ 100.0%(330,745)$ 123,309$
NET FUND INCREASE (DECREASE)544,477$ 1,193,352$ (2,932,130)$ (2,807,275)$ 648,875$
Village of Oak Brook
Water Fund Financial Update
For the Period Ending August 31, 2019
Total Total
Revenues Expenditures
8/31/19 Actual $ 6,141,183 4,801,028$
8/31/18 Actual $ 5,986,864 5,172,275$
% Change From Last Year 2.6%-7.2%
Unmetered Water
Water Sales Sales Connection Fees Meter Charges Miscellaneous
8/31/19 Actual $ 5,730,027 $ 31,997 $ 163,530 $ 23,307 $ 48,415
8/31/18 Actual $ 5,705,039 $ 21,736 $ 109,284 $ 8,334 $ 59,245
% Change From Last Year 0.4%47.2%49.6%179.7%-18.3%
Five Year Trend
Materials &Operation &
Personnel Supplies Contractual Capital Outlay
8/31/19 Actual 540,678$ 31,098$ 2,872,690$ 1,356,562$
8/31/18 Actual 506,463$ 44,533$ 3,188,007$ 1,433,272$
% Change From Last Year 6.8%-30.2%-9.9%-5.4%
Five Year Trend
Expenditures by Department
8/31/18 8/31/19 8/31/19 8/31/19 2019 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Public Works 3,706,193$ 3,435,643$ 4,527,935$ 75.9%7,299,035$ (270,550)$
Engineering & Capital Projects 1,466,082 1,365,385 4,396,590 31.1%6,224,075 (100,697)
Total Expenditures 5,172,275$ 4,801,028$ 8,924,525$ 53.8%13,523,110$ (371,247)$
Five Year Trend
Village of Oak Brook
Water Fund - Major Sources Five Year Trend
For the Period Ending August 31, 2019
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Sports Core Fund Consolidated Presentation
For the Period Ending August 31, 2019
8/31/19 8/31/19
8/31/19 YTD % of 2019 8/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 - - 692,353 692,353 718,335 96.4%930,000 679,358 12,995
Pro Shop Sales - - 155,876 155,876 150,890 103.3%200,000 154,554 1,322
Golf Lessons - - 33,575 33,575 39,000 86.1%40,000 22,512 11,063
Driving Range Fees - - 209,177 209,177 207,150 101.0%226,000 192,945 16,232
Rentals - - 326,746 326,746 360,175 90.7%459,000 326,761 (15)
Programs/User Fees 160,865 - - 160,865 172,965 93.0%253,450 170,567 (9,702)
Food Sales - 143,071 - 143,071 134,745 106.2%175,500 123,851 19,220
Beverage Sales - 211,448 - 211,448 193,115 109.5%252,500 183,962 27,486
Other Revenue 5,755 209,837 8,574 224,166 312,360 71.8%428,300 330,640 (106,474)
Total Direct Revenues 388,626$ 564,356$ 1,623,976$ 2,576,958$ 2,742,550$ 94.0%3,418,565$ 2,618,574$ (41,616)$
DIRECT EXPENDITURES
Personnel 101,032$ 209,028$ 776,668$ 1,086,728$ 1,106,625$ 98.2%1,572,920$ 1,069,106$ 17,622$
Materials & Supplies 39,083 187,045 272,033 498,161 476,095 104.6%580,645 372,844 125,317
Operational & Contractual 508,685 76,072 220,320 805,077 838,090 96.1%1,115,975 791,557 13,520
Other - - - - - N/A (83,150) 42,137 (42,137)
Capital 90,606 348,694 301,385 740,685 840,900 88.1%1,655,900 197,255 543,430
Total Direct Expenditures 739,406$ 820,839$ 1,570,406$ 3,130,651$ 3,261,710$ 96.0%4,842,290$ 2,472,899$ 657,752$
Direct Revenues Over (Under) Expenditures (350,780)$ (256,483)$ 53,570$ (553,693)$ (519,160)$ 106.7%(1,423,725)$ 145,675$ (699,368)$
B&T Administration Overhead Allocation*102,465$ (102,465)$ -$ -$ -$ 0.0%-$ -$ -$
Operating Revenues Over (Under) Expenditures (248,315)$ (358,948)$ 53,570$ (553,693)$ (519,160)$ 106.7%(1,423,725)$ 145,675$ (699,368)$
Interfund Loan**-$ -$ -$ -$ -$ N/A -$ -$ -$
Transfer From General Fund 48,704 285,499 - 334,203 421,725 79.2%1,216,725 - 334,203
Transfer From Golf Surcharge Fund - - 212,969 212,969 155,000 137.4%175,000 - 212,969
Reimbursement From Infrastructure Fund 16,000 - - 16,000 16,000 100.0%24,000 16,000 -
Reimbursement From Water Fund 5,336 - - 5,336 5,320 100.3%8,000 5,336 -
Adjusted Operating Revenues Over (Under) Expenditures (178,275)$ (73,449)$ 266,539$ 14,815$ 78,885$ -$ 167,011$ (152,196)$
*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
8/31/19 Actual $ 2,576,958 3,130,651$
8/31/18 Actual $ 2,618,574 2,472,899$
% Change From Last Year -1.6%26.6%
Driving Program/
Memberships Greens Fees Range Fees Rentals User Fees
8/31/19 Actual $ 419,681 $ 692,353 $ 209,177 $ 326,746 $ 160,865
8/31/18 Actual $ 433,424 $ 679,358 $ 192,945 $ 326,761 $ 170,567
% Change From Last Year -3.2%1.9%8.4%0.0%-5.7%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
8/31/19 Actual 1,086,728$ 498,161$ 805,077$ -$ 740,685$
8/31/18 Actual 1,069,106$ 372,844$ 791,557$ 42,137$ 197,255$
% Change From Last Year 1.6%33.6%1.7%-100.0%275.5%
Five Year Trend
Revenues by Department 8/31/18 8/31/19 8/31/19 8/31/19 2019 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Programs 589,513$ 388,626$ 646,495$ 60.1%686,515$ (200,887)$
Food & Beverage 443,592 564,356 127,800 441.6%663,000 120,764
Golf Club 1,585,469 1,623,976 567,997 285.9%2,069,050 38,507
Total Revenues 2,618,574$ 2,576,958$ 1,342,292$ 192.0%3,418,565$ (41,616)$
Expenditures by Department 8/31/18 8/31/19 8/31/19 % of 2019 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Programs 803,273$ 739,406$ 344,363$ 214.7%1,883,075$ (63,867)$
Food & Beverage 382,979 820,839 281,968 291.1%1,037,845 437,860
Golf Club 1,286,647 1,570,406 778,751 201.7%1,921,370 283,759
Total Expenditures 2,472,899$ 3,130,651$ 1,405,082$ 222.8%4,842,290$ 657,752$
Five Year Trend
Village of Oak Brook
Sports Core Fund - Major Sources Five Year Trend
For the Period Ending August 31, 2019
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Club Recreation Programs
For the Period Ending August 31, 2019 8/31/19 8/31/19
8/31/19 YTD % of 2019 8/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,767 42,405 - 98,693 160,865 172,965 93.0%253,450 170,567 (9,702)
Other Revenue (1,488) 6,473 770 - - 5,755 188,010 3.1%188,250 189,572 (183,817)
Total Revenue (1,488)$ 233,496$ 57,925$ -$ 98,693$ 388,626$ 605,790$ 64.2%686,515$ 589,513$ (200,887)$
Expenditures:
Personnel 82,496$ 19,585$ (5,011)$ -$ 3,962$ 101,032$ 155,125$ 65.1%182,405$ 130,268$ (29,236)$
Materials & Supplies 24,653 13,719 711 - - 39,083 25,070 155.9%26,350 16,696 22,387
Operational & Contractual 55,918 272,056 50,081 5,000 125,630 508,685 528,660 96.2%673,820 564,721 (56,036)
Capital 25,195 54,447 - - 10,964 90,606 205,500 44.1%1,000,500 91,588 (982)
Total Expenditures 188,262$ 359,807$ 45,781$ 5,000$ 140,556$ 739,406$ 914,355$ 80.9%1,883,075$ 803,273$ (63,867)$
Direct Revenues Over (Under) Expenditures (189,750)$ (126,311)$ 12,144$ (5,000)$ (41,863)$ (350,780)$ (308,565)$ 113.7%(1,196,560)$ (213,760)$ (137,020)$
B&T Administration Overhead Allocation*189,750$ (68,310)$ (18,975)$ -$ -$ 102,465$ 83,465$ 122.8%91,410$ 96,090$ 6,375$
Revenues Over (Under) Expenditures -$ (194,621)$ (6,831)$ (5,000)$ (41,863)$ (248,315)$ (225,100)$ 110.3%(1,105,150)$ (117,670)$ (130,645)$
Interfund Loan**-$ -$ -$ -$ -$ -$ -$ N/A -$ -$ -$
Transfer From General Fund 12,476 36,228 - - - 48,704 170,500 28.6%965,500 - 48,704
Reimbursement From Infrastructure Fund 16,000 - - - - 16,000 16,000 100.0%24,000 16,000 -$
Reimbursement From Water Fund 5,336 - - - - 5,336 5,320 100.3%8,000 5,336 -
Adjusted Revenues Over (Under) Expenditures 33,812$ (158,393)$ (6,831)$ (5,000)$ (41,863)$ (178,275)$ (33,280)$ (107,650)$ (96,334)$ (81,941)$
*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 August 31, 2019
8/31/19 8/31/19
821 822 823 8/31/19 YTD % of 2019 8/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$ 107,696$ 143,071$ 134,745$ 106.2%175,500$ 123,851$ 19,220$
Beverage Sales - 19,534 191,914 211,448 193,115 109.5%252,500 183,962 27,486
Other Revenue 209,837 - - 209,837 120,000 174.9%235,000 135,779 74,058
Total Revenue 209,837$ 54,909$ 299,610$ 564,356$ 447,860$ 126.0%663,000$ 443,592$ 120,764$
Expenditures:
Personnel 88,642$ 29,147$ 91,239$ 209,028$ 201,120$ 103.9%286,125$ 178,715$ 30,313$
Materials & Supplies 18,971 30,849 137,225 187,045 161,280 116.0%208,200 130,251 56,794
Operational & Contractual 69,327 25 6,720 76,072 105,970 71.8%153,120 64,025 12,047
Capital 348,694 - - 348,694 390,400 89.3%390,400 9,988 338,706
Total Expenditures 525,634$ 60,021$ 235,184$ 820,839$ 858,770$ 95.6%1,037,845$ 382,979$ 437,860$
Direct Revenues Over (Under) Expenditures (315,797)$ (5,112)$ 64,426$ (256,483)$ (410,910)$ 62.4%(374,845)$ 60,613$ (317,096)$
B&T Administration Overhead Allocation*(94,875)$ (7,590)$ (102,465)$ (83,465)$ 122.8%(91,410)$ (96,090)$ (6,375)$
Revenues Over (Under) Expenditures (410,672)$ (12,702)$ 64,426$ (358,948)$ (494,375)$ 72.6%(466,255)$ (35,477)$ (323,471)$
Transfer From General Fund 285,499$ -$ 285,499$ 251,225$ 113.6%251,225$ -$ 285,499$
Adjusted Revenues Over (Under) Expenditures (125,173)$ (12,702)$ 64,426$ (73,449)$ (243,150)$ (215,030)$ (35,477)$ (37,972)$
*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 August 31, 2019
8/31/19 8/31/19
831 832 833 834 8/31/19 YTD % of 2019 8/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 692,353 - - - 692,353 718,335 96.4%930,000 679,358 12,995
Pro Shop Sales 155,876 - - - 155,876 150,890 103.3%200,000 154,554 1,322
Golf Lessons - 33,575 - - 33,575 39,000 86.1%40,000 22,512 11,063
Driving Range Fees - 209,177 - - 209,177 207,150 101.0%226,000 192,945 16,232
Rentals 3,430 75,000 248,316 - 326,746 360,175 90.7%459,000 326,761 (15)
Other Revenue 8,574 - - - 8,574 4,350 197.1%5,050 5,289 3,285
Total Revenue 1,057,908$ 317,752$ 248,316$ -$ 1,623,976$ 1,688,900$ 96.2%2,069,050$ 1,585,469$ 38,507$
Expenditures:
Personnel 337,211$ 19,797$ 41,614$ 378,046$ 776,668$ 750,380$ 103.5%1,104,390$ 760,123$ 16,545$
Materials & Supplies 117,796 16,914 862 136,461 272,033 289,745 93.9%346,095 225,897 46,136
Operational & Contractual 150,698 113 42,054 27,455 220,320 203,460 108.3%289,035 162,811 57,509
Other - - - - - - N/A (83,150) 42,137 (42,137)
Capital 221,381 - - 80,004 301,385 245,000 123.0%265,000 95,679 205,706
Total Expenditures 827,086$ 36,824$ 84,530$ 621,966$ 1,570,406$ 1,488,585$ 105.5%1,921,370$ 1,286,647$ 283,759$
Direct Revenues Over (Under) Expenditures 230,822$ 280,928$ 163,786$ (621,966)$ 53,570$ 200,315$ 26.7%147,680$ 298,822$ (245,252)$
Transfer from Golf Surcharge 212,969$ -$ -$ -$ 212,969$ 155,000$ 137.4%175,000$ -$ 212,969$
Adjusted Revenues Over (Under) Expenditures 443,791$ 280,928$ 163,786$ (621,966)$ 266,539$ 355,315$ 322,680$ 298,822$ (32,283)$