07 - July 2019 Monthly Financial ReportVILLAGE
OAK BROOK
OF
MONTHLY FINANCIAL REPORTS
JULY 2019
ITEM 6.D
Total
Cash and Cash Pooled Cash and
Fund Equivalents Investments Investments % By Fund
General Corporate $7,133,793 $13,209,218 $20,343,011 43.1%
Hotel/Motel Tax 3,134,139 1,942,681 5,076,820 10.8%
Motor Fuel Tax 778,304 128,369 906,673 1.9%
Infrastructure 7,736,079 2,367,814 10,103,893 21.4%
Promenade TIF 39,728 - 39,728 0.1%
Water 5,214,603 2,917,806 8,132,409 17.2%
Sports Core 313,776 - 313,776 0.7%
Golf Surcharge 57,774 235,786 293,560 0.6%
Self-Insurance 878,117 - 878,117 1.9%
Garage 338,501 - 338,501 0.7%
Equipment Replacement 284,131 449,076 733,207 1.6%
Total $25,908,945 $21,250,750 $47,159,695 100.0%
Change in Cash and Investments by Fund :
Balance at Balance at Year-to-Date Year-to-Date
Fund January 1, 2019 July 31, 2019 Change ($)Change (%)
General Corporate $18,092,186 $20,343,011 $2,250,825 12.4%
Hotel/Motel Tax 4,843,367 5,076,820 233,453 4.8%
Motor Fuel Tax 782,203 906,673 124,470 15.9%
Infrastructure 9,322,381 10,103,893 781,512 8.4%
Promenade TIF 257,485 39,728 (217,757)-84.6%
Water 6,449,315 8,132,409 1,683,094 26.1%
Sports Core 190,397 313,776 123,379 64.8%
Golf Surcharge 442,152 293,560 (148,592)-33.6%
Self-Insurance 468,568 878,117 409,549 87.4%
Garage 331,134 338,501 7,367 2.2%
Equipment Replacement 1,636,238 733,207 (903,031)-55.2%
$42,815,426 $47,159,695 $4,344,269 10.1%
Book Bank/Market
Value Value
Pooled Checking $1,716,789 $1,723,293
Sports Core Checking 419,641 411,077
Pooled IPTIP 23,600,440 23,600,440
Water E-Pay IPTIP 172,075 172,075
$25,908,945 $25,906,885
Pooled Investments:
Investments-Municipal Bonds $6,206,634 $6,191,462
Investments-Corporate Bonds 7,534,790 7,582,652
Government & Agency Obligations 682,685 666,593
Certificates of Deposit 6,730,000 6,747,060
Accrued Interest 96,641 96,641
Total Pooled Investments $21,250,750 $21,284,408
Total Cash and Investments $47,159,695 $47,191,293
For July, total interest revenue is $93,603 and YTD revenue is $621,625.
Total investment yield for the portfolio is:
Pooled
Investments Illinois Funds Total
Monthly yield 0.20%0.23%0.22%
YTD yield 1.38%1.49%1.43%
Last 12 months yield 2.26%2.36%2.31%
The weighted average yield of the current pooled investment portfolio is 2.40%.
Monthly Treasurer's Report
July 31, 2019
Monthly Treasurer's Report
July 2019
The table below lists the detail investment holdings at J.P. Morgan Securities as of 7/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,635 $499,960 $2,422
New York N Y City #64971QTX1 02/22/16 05/01/21 2.350%2.000%201,187 201,006 1,161
Florida Hurricane #34074GDH4 03/30/16 07/01/20 2.995%2.150%503,739 503,370 1,247
Bloomingdale Mich Pub Sch Dist #094383FS0 04/26/16 05/01/22 2.710%2.150%507,406 504,865 3,349
Milan Mich Area Achs #598801JD1 05/26/16 05/01/20 1.931%1.931%245,000 244,483 1,082
Indiana Bd Bk Rev Taxable #4546248F7 01/06/17 01/15/20 2.934%1.900%256,157 255,773 346
Garland Cnty Ark Sales & Use #36609PAN3 02/06/17 11/01/19 1.795%1.840%499,942 499,340 2,369
Lanse Creuse Mich Pub Schs #516228RL9 05/02/17 05/01/20 2.159%2.159%100,000 99,943 537
California St GO Bonds #13063A7G3 05/08/17 10/01/19 6.200%1.600%503,840 503,335 10,051
Connecticut St GO Bds 2016 #20772J3F7 06/15/17 08/15/21 1.750%2.300%494,555 493,210 3,982
Fowlerville Mich Comnty Schs #351280MS8 10/03/17 05/01/20 2.045%1.750%501,102 499,810 2,386
Racine Cnty WI #749845UK7 12/20/17 12/01/20 2.150%2.150%750,000 745,793 2,688
Wisconsin St Gen Fd Annual #977100CW4 01/05/18 05/01/20 1.446%2.100%597,071 597,078 2,073
Wright County Min #982276BC0 07/18/19 12/01/20 2.000%2.000%545,000 543,496 909
Total Municipal Bonds $6,206,634 $6,191,462 $34,602
Corporate Bonds:
Goldman Sachs #38141GVP9 09/26/18 09/15/20 2.750%3.180%497,652 501,630 5,156
Fifth Third #31677QBH1 10/11/18 09/27/19 1.625%2.750%998,316 998,950 5,597
Wells Fargo #94974BGR5 01/15/19 12/07/20 2.550%3.120%1,379,662 1,395,157 5,612
SunTrust #86787EAU1 01/28/19 01/29/21 2.590%3.050%498,922 500,210 0
PNC Bank #69353RFH6 01/30/19 01/22/21 2.500%3.020%496,280 501,215 313
Morgan Stanley #61747WAL3 03/08/19 07/28/21 5.500%3.034%1,099,638 1,110,386 321
Citigroup #172967LC3 04/01/19 12/08/21 2.900%2.754%1,003,303 1,011,280 3,706
Bank of America #06051GFT1 04/03/19 10/19/20 2.625%2.625%700,000 703,290 4,951
Goldman Sachs #38143U8F1 05/02/19 02/25/21 2.875%2.707%365,926 367,154 4,520
American Honda #02665WBG5 07/31/19 09/09/21 1.700%2.180%495,091 493,380 3,376
Total Corporate Bonds $7,534,790 $7,582,652 $33,552
Government & Agency Obligations:
*Government National Mtg Assn #38379UEM4 02/29/16 02/16/51 2.300%2.245%$682,685 $666,593 $2,239
Total Government & Agency Obligations:$682,685 $666,593 $2,239
Certificates of Deposit:
State Bk India NY #8562846A7 01/26/17 01/26/22 2.250%2.250%$245,000 $245,914 $99
Marlin Bank #57116ANU8 05/10/17 11/12/19 1.610%1.610%245,000 244,731 227
American Express Fed Svgs #02587CER7 05/10/17 11/12/19 1.700%1.700%245,000 244,792 937
American Express Centurion #02587DV96 08/15/17 08/17/20 1.900%1.900%245,000 244,750 2,114
Sallie Mae #795450C86 08/16/17 08/17/20 1.900%1.900%245,000 244,767 2,114
Merrick Bank South Jordan #59013JZS1 08/21/17 08/21/20 1.800%1.800%245,000 244,505 129
Pinnacle Bank #72345SFS5 08/30/17 08/31/20 1.800%1.800%115,000 114,760 9
Jackson County Bank #466682AP6 08/31/17 03/01/21 1.850%1.850%245,000 244,292 1,907
Barclays Bank #06740KKX4 09/27/17 09/28/20 1.950%1.950%245,000 244,853 1,652
Capital One Bank #1404205E6 10/04/17 10/04/19 1.700%1.700%245,000 244,865 1,348
Goldman Sachs Bank #38148PRK5 10/18/17 10/19/20 1.950%1.950%245,000 244,833 1,360
FirstBank PR Santurce #33767A6M8 11/03/17 11/03/20 2.000%2.000%245,000 244,973 372
Morgan Stanley #61747MQ53 03/22/18 03/23/20 2.550%2.550%245,000 245,897 2,121
Investors Community Bank #46147UTT7 08/28/18 02/28/20 2.550%2.550%245,000 245,806 45
Lakeside Bank #51210SPS0 08/30/18 03/30/20 2.550%2.550%245,000 245,926 27
Bank United #066519GJ2 08/31/18 02/20/20 2.500%2.500%245,000 245,745 2,577
Compass Bank #20451PVW3 10/26/18 10/26/20 3.000%3.000%245,000 247,962 1,929
UBS Bank #90348JFH8 10/30/18 10/29/20 3.050%3.050%245,000 248,148 36
Citibank #17294XJP2 10/31/18 10/31/20 3.000%3.000%245,000 245,546 1,888
Discover Bank #254673WF9 11/07/18 11/09/20 3.000%3.000%245,000 248,045 1,725
Ally Bank #02007GFX6 11/08/18 11/09/20 3.000%3.000%245,000 248,045 1,704
Comenity Cap Bank #20033AU46 04/15/19 04/15/21 2.500%2.500%245,000 246,869 259
Radius Bank #75047ABE3 05/30/19 05/28/21 2.450%2.450%245,000 245,091 30
Morgan Stanley #61760AE21 05/30/19 06/01/21 2.400%2.400%245,000 246,514 980
First St Bank DeQueen #336460CU2 07/18/19 07/19/21 2.000%2.000%245,000 244,686 204
Bank Hapoalim #06251AW89 07/19/19 07/19/21 2.000%2.000%245,000 245,159 204
Capital One Natl Assn #14042RMF5 07/24/19 07/26/19 2.050%2.050%245,000 244,914 209
TIAA FSB Jacksonville #87270LCN1 07/29/19 07/29/21 2.000%2.000%245,000 244,672 42
Total Certificates of Deposits $6,730,000 $6,747,060 $26,248
Total J.P.Morgan Securities $21,154,109 $21,187,767 $96,641
*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 2/16/2051 maturity date.
VILLAGE OF OAK BROOK
Monthly Treasurer's Report
July 31, 2019
Cash & Investments by Fund - Total $47.2 million
Cash & Investments by Type - Total $47.2 million
Checking
Illinois Funds
Certificates of Deposit
Municipal Bonds
Corporate Bonds
Government & Agency Obligations
Accrued Interest
General Corporate
43.14%
Hotel/Motel Tax
10.77%Motor Fuel Tax
1.92%
Infrastructure
21.42%
Promenade TIF
0.08%
Water
17.24%
Sports Core
0.67%
Golf Surcharge
0.62%
Self-Insurance
1.86%Garage
0.72%
Equipment
Replacement
1.55%
Checking, $2.2
Illinois Funds, $23.8
Certificates of Deposit,
$6.7
Municipal Bonds, $6.2
Corporate Bonds, $7.5
Government & Agency
Obligations, $0.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)15,948,145 $13,664,593 $2,283,552 $408,195
Main operating fund of the Village.
Hotel Fund (Major Fund)$709,693 $410,790 $298,903 ($1,487,050)
Collects and spends resources from the
3% hotel/motel tax.
Motor Fuel Tax Fund $124,471 $0 $124,471 ($31,140)
Collects and spends resources from the
State motor fuel tax.
Infrastructure Fund (Major Fund)$3,866,385 $3,035,270 $831,115 ($5,153,610)
Accounts for construction and maintenance of
roadways, drainage, and safety path systems.
Promenade TIF Fund (Major Fund)$246,696 $464,453 ($217,757)($250,965)
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)$5,650,920 $4,413,459 $1,237,461 ($2,148,385)
Collects user fees for the distribution of water
and maintenance of infrastructure.
Sports Core Fund (Major Fund)$2,666,942 $2,717,759 ($50,817)$134,855
Accounts for revenues and expenses relating
to administration, programs, food and beverage
operations, and golf course.
Golf Surcharge Fund $64,378 $212,969 ($148,591)($35,095)
Accounts for the collection of the $3 per round
golf surcharge.
Internal Service Funds
Self Insurance Fund $1,957,606 $1,465,033 $492,573 ($5,415)
Accounts for the Village's health insurance costs
and the related contributions from the Village,
employees, retirees, and other agencies.
Garage Fund $412,913 $403,281 $9,632 ($27,755)
Accounts for the maintenance of the Village's vehicle
fleet and the related departmental reimbursements.
Equipment Replacement Fund $136,695 $1,038,893 ($902,198)($1,065,740)
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 July 31, 2019
Village of Oak Brook
Monthly Financial Report – Fund Narrative
For the Period Ending July 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 July
2019 are $7,306,038, which is
$186,204 higher than through July
2018 and $214,288 over FY19 budget
to date. The increase is primarily due
to the opening of newer businesses
in town and general inflationary
growth. July 2019 collections have
been consistent with recent years.
Licenses and Permits revenue
through July 2019 is $1,687,864,
which is $822,511 lower than through July 2018, but $273,669 over FY19 budget to date. The
Village issued a number of large building permits during the first half of 2018. The Village
expects to issue permits for new developments in the second half of 2019.
Charges for Services revenue through July 2019 is $801,855, which is $197,356 higher than
through July 2018, but $60,210 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.
Personnel expenditures through July 2019 are $9,819,620, which is $220,511 more than through
July 2018, but $700,775 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.
Operation and Contract expenditures through July 2019 are $2,543,664, which is $344,217
more than through July 2018, but $51,691 under FY19 budget to date. The increase is primarily
due to the addition of five contracted paramedics to increase ambulance services.
Capital Outlay expenditures through July 2019 are $628,171, which is $833,733 less than
through July 2018 and $121,029 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 July 2019 are $642,500, which is $84,926 lower than through July
2018 and $34,500 under FY19 budget to date. The decrease is due to receipts coming in lower
than forecasted and the general timing of when the payments are received.
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
Non-Home Rule Sales Tax collections
through July 2019 are $3,316,963,
which is $94,088 higher than through
July 2018 and $105,963 over FY19
budget to date. The increase is
primarily due to the opening of
newer businesses in town and
general inflationary growth. July
2019 collections have been
consistent with recent years.
Operation and Contractual
expenditures through July 2019 are $900,745, which is $362,295 higher than through July 2018,
but $80,850 under FY19 budget to date. The increase is due to more being spent on project
engineering than in 2018.
Capital Outlay expenditures through July 2019 are $1,182,100, which is $1,131,113 higher than
through July 2018, but $5,840,200 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 July 2019 is $5,090,723, which is $31,204 higher than through July
2018, but $198,777 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 July 2019 are $2,277,649, which is $240,056
lower than through July 2018 and $1,130,176 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 July 2019 are $1,349,593, which is $26,035 higher than
through July 2018, but $2,205,927 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
Memberships revenue through July 2019 is $418,514, which is $14,910 lower than through July
2018 and $35,301 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 July 2019 is $515,003, which is $2,898 higher than through July
2018, but $25,632 under FY19 budget to date. Total rounds played is consistent with the 2018
season so far despite the unfavorable weather during early 2019.
Other Revenue collections through July 2019 are $168,439, which is $123,434 lower than
through July 2018 and $113,031 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.
Materials & Supplies expenditures through July 2019 are $382,285, which is $123,095 higher
than through July 2018, but $9,490 under 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.
Capital Outlay expenditures through July 2019 are $739,911, which is $598,924 higher than
through July 2018 and $49,411 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
Other Expenditures through July 2019 are $1,005,593, 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.
7/31/19 7/31/19
7/31/18 7/31/19 YTD % of 2019 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 7,119,834$ 7,306,038$ 7,091,750$ 103.0%12,325,000$ 186,204$
Other Intergovernmental Tax*837,547 944,662 834,950 113.1%1,227,750 107,115
Telecommunications/Utility Tax 3,619,607 3,720,247 3,485,860 106.7%5,857,500 100,640
Licenses and Permits 2,510,375 1,687,864 1,414,195 119.4%2,335,050 (822,511)
Charges for Services 604,499 801,855 862,065 93.0%1,491,400 197,356
Fines and Penalties 105,725 140,353 92,190 152.2%158,000 34,628
Administrative Towing Fees 18,325 13,004 17,500 74.3%30,000 (5,321)
Interest on Investments 190,645 267,359 192,500 138.9%330,000 76,714
Franchise/IMF Maint. Fee 59,331 58,453 106,500 54.9%213,000 (878)
Miscellaneous Income 221,740 131,287 117,250 112.0%212,800 (90,453)
Total Operating Revenues 15,287,628$ 15,071,122$ 14,214,760$ 106.0%24,180,500$ (216,506)$
OPERATING EXPENDITURES
Personnel 9,599,109$ 9,819,620$ 10,520,395$ 93.3%18,183,745$ 220,511$
Materials and Supplies 254,698 255,124 362,945 70.3%559,780 426
Operation and Contract 2,199,447 2,543,664 2,595,355 98.0%4,224,475 344,217
Other Expenditures 4,400 7,336 7,500 97.8%10,000 2,936
Capital Outlay 1,461,904 628,171 749,200 83.8%862,475 (833,733)
Total Operating Expenditures 13,519,558$ 13,253,915$ 14,235,395$ 93.1%23,840,475$ (265,643)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 1,768,070$ 1,817,207$ (20,635)$ 340,025$ 49,137$
OTHER TRANSACTIONS
Transfers In -$ 508,235$ 508,235$ 100.0%508,235$ 508,235$
Transfers Out - (334,203) (371,725) 89.9%(1,216,725) (334,203)
Reimbursements From Other Funds 366,947 368,788 368,795 100.0%632,210 1,841
Reimbursements To Other Funds (76,601) (76,475) (76,475) 100.0%(131,100) 126
Total Interfund Transactions 290,346$ 466,345$ 428,830$ 108.7%(207,380)$ 175,999$
NET FUND INCREASE (DECREASE)2,058,416$ 2,283,552$ 408,195$ 132,645$ 225,136$
*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 July 31, 2019
Total Total
Revenues Expenditures
7/31/19 Actual 15,071,122$ 13,253,915$
7/31/18 Actual 15,287,628$ 13,519,558$
% Change From Last Year -1.4%-2.0%
Major Revenues Other
Intergov.Licenses &Charges for
Sales Tax Tax Telecom Tax Permits Services
7/31/19 Actual 7,306,038$ 944,662$ 3,720,247$ 1,687,864$ 801,855$
7/31/18 Actual $ 7,119,834 $ 837,547 $ 3,619,607 $ 2,510,375 $ 604,499
% Change From Last Year 2.6%12.8%2.8%-32.8%32.6%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
7/31/19 Actual 9,819,620$ 255,124$ 2,543,664$ 7,336$ 628,171$
7/31/18 Actual 9,599,109$ 254,698$ 2,199,447$ 4,400$ 1,461,904$
% Change From Last Year 2.3%0.2%15.7%66.7%-57.0%
Five Year Trend
Expenditures by Department
7/31/18 7/31/19 7/31/19 7/31/19 2019 Difference Five
YTD YTD YTD % of Annual Prior Year
Department Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 1,255,310$ 1,326,906$ 1,528,910$ 86.8%2,700,820$ 71,596$
Financial Services 417,062 432,941 465,330 93.0%782,860 15,879
Public Works 359,999 497,421 519,685 95.7%886,420 137,422
Engineering & Capital Projects 1,367,781 291,125 268,275 108.5%459,900 (1,076,656)
Library 491,308 531,403 548,820 96.8%928,675 40,095
Police 4,910,350 5,057,644 5,460,795 92.6%8,891,960 147,294
Fire 4,182,849 4,572,874 4,877,630 93.8%8,207,785 390,025
Development Services 534,899 543,601 565,950 96.1%982,055 8,702
Total Expenditures 13,519,558$ 13,253,915$ 14,235,395$ 93.1%23,840,475$ (265,643)$
Five Year Trend
For the Period Ending July 31, 2019
General Fund - Five Year Trend
Village of Oak Brook
Revenues Expenditures
7/31/19 7/31/19
7/31/18 7/31/19 YTD % of 2019 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Hotel Tax 727,426$ 642,500$ 677,000$ 94.9%1,268,000$ (84,926)$
Interest 42,785 67,193 17,500 384.0%30,000 24,408
Miscellaneous 2,977 - - 0.0%- (2,977)
Total Operating Revenues 773,188$ 709,693$ 694,500$ 102.2%1,298,000$ (63,495)$
EXPENDITURES
Operation and Contract 208,198$ 350,639$ 337,075$ 104.0%577,860$ 142,441$
Capital Outlay 58,505 - 1,784,345 0.0%4,180,545 (58,505)
Total Expenditures 266,703$ 350,639$ 2,121,420$ 16.5%4,758,405$ 83,936$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 506,485$ 359,054$ (1,426,920)$ -25.2%(3,460,405)$ (147,431)$
INTERFUND TRANSACTIONS
Reimbursements to Other Funds (58,065)$ (60,151)$ (60,130)$ 100.0%(103,115)$ (2,086)$
Total Interfund Transactions (58,065)$ (60,151)$ (60,130)$ 100.0%(103,115)$ (2,086)$
NET FUND INCREASE (DECREASE)448,420$ 298,903$ (1,487,050)$ (3,563,520)$ (149,517)$
Note - Expenditures are recorded in program 171.
Village of Oak Brook
Hotel Tax Fund Financial Update
For the Period Ending July 31, 2019
Total Total
Revenues Expenditures
7/31/19 Actual $ 709,693 350,639$
7/31/18 Actual $ 773,188 266,703$
% Change From Last Year -8.2%31.5%
Major Revenues
Hotel Tax Interest Miscellaneous
7/31/19 Actual $ 642,500 $ 67,193 $ -
7/31/18 Actual $ 727,426 $ 42,785 $ 2,977
% Change From Last Year -11.7%57.0%-100.0%
Five Year Trend
Major Expenditures Operation &
Contractual Capital Outlay
7/31/19 Actual 350,639$ -$
7/31/18 Actual 208,198$ 58,505$
% Change From Last Year 68.4%-100.0%
Five Year Trend
Village of Oak Brook
Hotel Tax Fund - Major Sources Five Year Trend
For the Period Ending July 31, 2019
Five Year Trend
Revenues Expenditures
7/31/19 7/31/19
7/31/18 7/31/19 YTD % of 2019 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 3,222,875$ 3,316,963$ 3,211,000$ 103.3%5,548,000$ 94,088$
Interest 90,731 138,788 49,000 283.2%80,000 48,057
Miscellaneous 2,729 - 2,905 0.0%5,000 (2,729)
Total Operating Revenues 3,316,335$ 3,455,751$ 3,262,905$ 105.9%5,633,000$ 139,416$
OPERATING EXPENDITURES
Personnel 700,613$ 755,826$ 764,005$ 98.9%1,322,375$ 55,213$
Materials and Supplies 86,161 102,372 115,035 89.0%246,845 16,211
Operation and Contract 538,450 900,745 981,595 91.8%1,663,435 362,295
Capital Outlay 50,987 1,182,100 7,022,300 16.8%10,008,575 1,131,113
Total Operating Expenditures 1,376,211$ 2,941,043$ 8,882,935$ 33.1%13,241,230$ 1,564,832$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 1,940,124$ 514,708$ (5,620,030)$ -9.2%(7,608,230)$ (1,425,416)$
INTERFUND TRANSACTIONS
Transfers In 7,790$ 216,125$ 366,125$ 59.0%1,116,125$ 208,335$
Reimbursements From Other Funds 105,658 194,509 194,530 100.0%333,445 88,851
Reimbursements To Other Funds (96,173) (94,227) (94,235) 100.0%(161,535) 1,946
Total Interfund Transactions 17,275$ 316,407$ 466,420$ 67.8%1,288,035$ 299,132$
NET FUND INCREASE (DECREASE)1,957,399$ 831,115$ (5,153,610)$ (6,320,195)$ (1,126,284)$
Village of Oak Brook
Infrastructure Fund Financial Update
For the Period Ending July 31, 2019
Total Total
Revenues Expenditures
7/31/19 Actual $ 3,455,751 2,941,043$
7/31/18 Actual $ 3,316,335 1,376,211$
% Change From Last Year 4.2%113.7%
Major Revenues
Sales Tax Grants Interest Miscellaneous
7/31/19 Actual $ 3,316,963 $ - $ 138,788 $ -
7/31/18 Actual $ 3,222,875 $ - $ 90,731 $ 2,729
% Change From Last Year 2.9%0.0%53.0%-100.0%
Five Year Trend
Major Expenditures Materials &Operation &
Personnel Supplies Contractual Capital Outlay
7/31/19 Actual 755,826$ 102,372$ 900,745$ 1,182,100$
7/31/18 Actual 700,613$ 86,161$ 538,450$ 50,987$
% Change From Last Year 7.9%18.8%67.3%2218.4%
Five Year Trend
Expenditures by Department
7/31/18 7/31/19 7/31/19 7/31/19 2019 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 81,495$ 95,936$ 99,470$ 96.4%179,485$ 14,441$
Public Works 1,076,880 1,231,680 5,337,220 23.1%6,462,865 154,800
Engineering & Capital Projects 217,836 1,613,427 3,446,245 46.8%6,760,415 1,395,591
Total Expenditures 1,376,211$ 2,941,043$ 8,882,935$ 33.1%13,402,765$ 1,564,832$
Five Year Trend
Village of Oak Brook
Infrastructure Fund - Major Sources Five Year Trend
For the Period Ending July 31, 2019
Revenues Expenditures
7/31/19 7/31/19
7/31/18 7/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 768 1,021 525 194.5%900 253
Total Operating Revenues 221,499$ 246,696$ 214,025$ 115.3%460,900$ 25,197$
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,724)$ (217,757)$ (250,965)$ (4,290)$ 53,967$
Note - Expenditures are recorded in program 283.
Village of Oak Brook
Promenade TIF Fund Financial Update
For the Period Ending July 31, 2019
Total Total
Revenues Expenditures
7/31/19 Actual $ 246,696 464,453$
7/31/18 Actual $ 221,499 493,223$
% Change From Last Year 11.4%-5.8%
Major Revenues Real Estate
Sales Tax Tax Interest
7/31/19 Actual $ 39,820 $ 205,855 $ 1,021
7/31/18 Actual $ 34,169 $ 186,562 $ 768
% Change From Last Year 16.5%10.3%32.9%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures
7/31/19 Actual 3,473$ 460,980$
7/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 July 31, 2019
Five Year Trend
Revenues Expenditures
7/31/19 7/31/19
7/31/18 7/31/19 YTD % of 2019 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Plan Review Fees 600 825$ 875$ 94.3%1,500$ 225$
Building/Inspection Fees 5,063 2,625 2,905 90.4%5,000 (2,438)
Water Sales 5,059,519 5,090,723 5,289,500 96.2%10,223,250 31,204
Unmetered Sales 21,736 28,554 17,500 163.2%30,000 6,818
Water Connection Fees 109,284 137,770 29,050 474.3%50,000 28,486
Fire Service Charge - - 2,905 0.0%5,000 -
Meter Charges 8,334 10,767 11,675 92.2%20,000 2,433
Special Services 16,394 16,772 15,000 111.8%30,000 378
Interest on Investments 52,031 105,493 32,060 329.0%55,000 53,462
Miscellaneous 46,194 36,306 43,750 83.0%75,000 (9,888)
Total Operating Revenues 5,319,155$ 5,429,835$ 5,445,220$ 99.7%10,494,750$ 110,680$
EXPENDITURES
Personnel 422,892$ 443,905$ 480,830$ 92.3%828,710$ 21,013$
Materials and Supplies 34,511 20,410 48,610 42.0%76,210 (14,101)
Operation and Contract 2,517,705 2,277,649 3,407,825 66.8%5,822,285 (240,056)
Capital Outlay 1,323,558 1,349,593 3,555,520 38.0%6,244,075 26,035
Total Expenditures 4,298,666$ 4,091,557$ 7,492,785$ 54.6%12,971,280$ (207,109)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 1,020,489$ 1,338,278$ (2,047,565)$ (2,476,530)$ 317,789$
INTERFUND TRANSACTIONS
Transfers In -$ 221,085$ 221,085$ 100.0%221,085$ 221,085
Reimbursements To Other Funds (236,348) (321,902) (321,905) 100.0%(551,830) (85,554)
Total Interfund Transactions (236,348)$ (100,817)$ (100,820)$ 100.0%(330,745)$ 135,531$
NET FUND INCREASE (DECREASE)784,141$ 1,237,461$ (2,148,385)$ (2,807,275)$ 453,320$
Village of Oak Brook
Water Fund Financial Update
For the Period Ending July 31, 2019
Total Total
Revenues Expenditures
7/31/19 Actual $ 5,429,835 4,091,557$
7/31/18 Actual $ 5,319,155 4,298,666$
% Change From Last Year 2.1%-4.8%
Unmetered Water
Water Sales Sales Connection Fees Meter Charges Miscellaneous
7/31/19 Actual $ 5,090,723 $ 28,554 $ 137,770 $ 10,767 $ 36,306
7/31/18 Actual $ 5,059,519 $ 21,736 $ 109,284 $ 8,334 $ 46,194
% Change From Last Year 0.6%31.4%26.1%29.2%-21.4%
Five Year Trend
Materials &Operation &
Personnel Supplies Contractual Capital Outlay
7/31/19 Actual 443,905$ 20,410$ 2,277,649$ 1,349,593$
7/31/18 Actual 422,892$ 34,511$ 2,517,705$ 1,323,558$
% Change From Last Year 5.0%-40.9%-9.5%2.0%
Five Year Trend
Expenditures by Department
7/31/18 7/31/19 7/31/19 7/31/19 2019 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Public Works 2,999,057$ 2,736,131$ 3,948,930$ 69.3%7,299,035$ (262,926)$
Engineering & Capital Projects 1,299,609 1,355,426 3,543,855 38.2%6,224,075 55,817
Total Expenditures 4,298,666$ 4,091,557$ 7,492,785$ 54.6%13,523,110$ (207,109)$
Five Year Trend
Village of Oak Brook
Water Fund - Major Sources Five Year Trend
For the Period Ending July 31, 2019
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Sports Core Fund Consolidated Presentation
For the Period Ending July 31, 2019
7/31/19 7/31/19
7/31/19 YTD % of 2019 7/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,439$ -$ 196,075$ 418,514$ 453,815$ 92.2%453,815$ 433,424$ (14,910)$
Greens Fees - - 515,003 515,003 540,635 95.3%930,000 512,105 2,898
Pro Shop Sales - - 122,534 122,534 130,155 94.1%200,000 128,990 (6,456)
Golf Lessons - - 31,305 31,305 33,500 93.4%40,000 22,512 8,793
Driving Range Fees - - 181,451 181,451 180,650 100.4%226,000 167,510 13,941
Rentals - - 260,868 260,868 292,675 89.1%459,000 260,490 378
Programs/User Fees 135,570 - - 135,570 147,705 91.8%253,450 145,736 (10,166)
Food Sales - 108,467 - 108,467 107,185 101.2%175,500 95,579 12,888
Beverage Sales - 158,950 - 158,950 148,240 107.2%252,500 138,392 20,558
Other Revenue 7,063 154,736 6,640 168,439 281,470 59.8%428,300 291,873 (123,434)
Total Direct Revenues 365,072$ 422,153$ 1,313,876$ 2,101,101$ 2,316,030$ 90.7%3,418,565$ 2,196,611$ (95,510)$
DIRECT EXPENDITURES
Personnel 90,052$ 152,932$ 615,186$ 858,170$ 882,745$ 97.2%1,572,920$ 821,385$ 36,785$
Materials & Supplies 14,719 139,322 228,244 382,285 391,775 97.6%580,645 259,190 123,095
Operational & Contractual 488,542 58,033 190,818 737,393 711,535 103.6%1,115,975 745,070 (7,677)
Other - - - - - N/A (83,150) 33,048 (33,048)
Capital 76,054 363,304 300,553 739,911 690,500 107.2%1,655,900 140,987 598,924
Total Direct Expenditures 669,367$ 713,591$ 1,334,801$ 2,717,759$ 2,676,555$ 101.5%4,842,290$ 1,999,680$ 718,079$
Direct Revenues Over (Under) Expenditures (304,295)$ (291,438)$ (20,925)$ (616,658)$ (360,525)$ 171.0%(1,423,725)$ 196,931$ (813,589)$
B&T Administration Overhead Allocation*74,272$ (74,272)$ -$ -$ -$ 0.0%-$ -$ -$
Operating Revenues Over (Under) Expenditures (230,023)$ (365,710)$ (20,925)$ (616,658)$ (360,525)$ 171.0%(1,423,725)$ 196,931$ (813,589)$
Interfund Loan**-$ -$ -$ -$ -$ N/A -$ -$ -$
Transfer From General Fund 48,704 285,499 - 334,203 371,725 89.9%1,216,725 - 334,203
Transfer From Golf Surcharge Fund - - 212,969 212,969 105,000 202.8%175,000 - 212,969
Reimbursement From Infrastructure Fund 14,000 - - 14,000 14,000 100.0%24,000 14,000 -
Reimbursement From Water Fund 4,669 - - 4,669 4,655 100.3%8,000 4,669 -
Adjusted Operating Revenues Over (Under) Expenditures (162,650)$ (80,211)$ 192,044$ (50,817)$ 134,855$ -$ 215,600$ (266,417)$
*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
7/31/19 Actual $ 2,101,101 2,717,759$
7/31/18 Actual $ 2,196,611 1,999,680$
% Change From Last Year -4.3%35.9%
Driving Program/
Memberships Greens Fees Range Fees Rentals User Fees
7/31/19 Actual $ 418,514 $ 515,003 $ 181,451 $ 260,868 $ 135,570
7/31/18 Actual $ 433,424 $ 512,105 $ 167,510 $ 260,490 $ 145,736
% Change From Last Year -3.4%0.6%8.3%0.1%-7.0%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
7/31/19 Actual 858,170$ 382,285$ 737,393$ -$ 739,911$
7/31/18 Actual 821,385$ 259,190$ 745,070$ 33,048$ 140,987$
% Change From Last Year 4.5%47.5%-1.0%-100.0%424.8%
Five Year Trend
Revenues by Department 7/31/18 7/31/19 7/31/19 7/31/19 2019 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Programs 563,860$ 365,072$ 646,495$ 56.5%686,515$ (198,788)$
Food & Beverage 332,563 422,153 127,800 330.3%663,000 89,590
Golf Club 1,300,188 1,313,876 567,997 231.3%2,069,050 13,688
Total Revenues 2,196,611$ 2,101,101$ 1,342,292$ 156.5%3,418,565$ (95,510)$
Expenditures by Department 7/31/18 7/31/19 7/31/19 % of 2019 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Programs 733,641$ 669,367$ 344,363$ 194.4%1,883,075$ (64,274)$
Food & Beverage 295,806 713,591 281,968 253.1%1,037,845 417,785
Golf Club 970,233 1,334,801 778,751 171.4%1,921,370 364,568
Total Expenditures 1,999,680$ 2,717,759$ 1,405,082$ 193.4%4,842,290$ 718,079$
Five Year Trend
Village of Oak Brook
Sports Core Fund - Major Sources Five Year Trend
For the Period Ending July 31, 2019
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Club Recreation Programs
For the Period Ending July 31, 2019 7/31/19 7/31/19
7/31/19 YTD % of 2019 7/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,689$ 14,750$ -$ -$ 222,439$ 244,815$ 90.9%244,815$ 229,374$ (6,935)$
Programs/User Fees - 18,733 33,767 - 83,070 135,570 147,705 91.8%253,450 145,736 (10,166)
Other Revenue 473 6,073 517 - - 7,063 187,070 3.8%188,250 188,750 (181,687)
Total Revenue 473$ 232,495$ 49,034$ -$ 83,070$ 365,072$ 579,590$ 63.0%686,515$ 563,860$ (198,788)$
Expenditures:
Personnel 76,250$ 14,851$ (5,011)$ -$ 3,962$ 90,052$ 124,480$ 72.3%182,405$ 98,631$ (8,579)$
Materials & Supplies 475 13,533 711 - - 14,719 23,580 62.4%26,350 16,362 (1,643)
Operational & Contractual 48,811 263,926 43,858 10,000 121,947 488,542 431,490 113.2%673,820 546,693 (58,151)
Capital 12,476 59,143 - - 4,435 76,054 195,500 38.9%1,000,500 71,955 4,099
Total Expenditures 138,012$ 351,453$ 39,558$ 10,000$ 130,344$ 669,367$ 775,050$ 86.4%1,883,075$ 733,641$ (64,274)$
Direct Revenues Over (Under) Expenditures (137,539)$ (118,958)$ 9,476$ (10,000)$ (47,274)$ (304,295)$ (195,460)$ 155.7%(1,196,560)$ (169,781)$ (134,514)$
B&T Administration Overhead Allocation*137,539$ (49,513)$ (13,754)$ -$ -$ 74,272$ 74,415$ 99.8%91,410$ 74,964$ (692)$
Revenues Over (Under) Expenditures -$ (168,471)$ (4,278)$ (10,000)$ (47,274)$ (230,023)$ (121,045)$ 190.0%(1,105,150)$ (94,817)$ (135,206)$
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 14,000 - - - - 14,000 14,000 100.0%24,000 14,000 -$
Reimbursement From Water Fund 4,669 - - - - 4,669 4,655 100.3%8,000 4,669 -
Adjusted Revenues Over (Under) Expenditures 31,145$ (132,243)$ (4,278)$ (10,000)$ (47,274)$ (162,650)$ 68,110$ (107,650)$ (76,148)$ (86,502)$
*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 July 31, 2019
7/31/19 7/31/19
821 822 823 7/31/19 YTD % of 2019 7/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 -$ 27,327$ 81,140$ 108,467$ 107,185$ 101.2%175,500$ 95,579$ 12,888$
Beverage Sales - 15,311 143,639 158,950 148,240 107.2%252,500 138,392 20,558
Other Revenue 154,736 - - 154,736 90,000 171.9%235,000 98,592 56,144
Total Revenue 154,736$ 42,638$ 224,779$ 422,153$ 345,425$ 122.2%663,000$ 332,563$ 89,590$
Expenditures:
Personnel 71,915$ 16,189$ 64,828$ 152,932$ 156,155$ 97.9%286,125$ 138,472$ 14,460$
Materials & Supplies 8,160 27,191 103,971 139,322 122,595 113.6%208,200 90,085 49,237
Operational & Contractual 51,794 25 6,214 58,033 96,535 60.1%153,120 57,261 772
Capital 363,304 - - 363,304 300,000 121.1%390,400 9,988 353,316
Total Expenditures 495,173$ 43,405$ 175,013$ 713,591$ 675,285$ 105.7%1,037,845$ 295,806$ 417,785$
Direct Revenues Over (Under) Expenditures (340,437)$ (767)$ 49,766$ (291,438)$ (329,860)$ 88.4%(374,845)$ 36,757$ (328,195)$
B&T Administration Overhead Allocation*(68,770)$ (5,502)$ -$ (74,272)$ (74,415)$ 99.8%(91,410)$ (74,964)$ 692$
Revenues Over (Under) Expenditures (409,207)$ (6,269)$ 49,766$ (365,710)$ (404,275)$ 90.5%(466,255)$ (38,207)$ (327,503)$
Transfer From General Fund 285,499$ -$ -$ 285,499$ 201,225$ 141.9%251,225$ -$ 285,499$
Adjusted Revenues Over (Under) Expenditures (123,708)$ (6,269)$ 49,766$ (80,211)$ (203,050)$ (215,030)$ (38,207)$ (42,004)$
*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 July 31, 2019
7/31/19 7/31/19
831 832 833 834 7/31/19 YTD % of 2019 7/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 196,075$ -$ -$ -$ 196,075$ 209,000$ 93.8%209,000$ 204,050$ (7,975)$
Greens Fees 515,003 - - - 515,003 540,635 95.3%930,000 512,105 2,898
Pro Shop Sales 122,534 - - - 122,534 130,155 94.1%200,000 128,990 (6,456)
Golf Lessons - 31,305 - - 31,305 33,500 93.4%40,000 22,512 8,793
Driving Range Fees - 181,451 - - 181,451 180,650 100.4%226,000 167,510 13,941
Rentals 1,980 75,000 183,888 - 260,868 292,675 89.1%459,000 260,490 378
Other Revenue 6,640 - - - 6,640 4,400 150.9%5,050 4,531 2,109
Total Revenue 842,232$ 287,756$ 183,888$ -$ 1,313,876$ 1,391,015$ 94.5%2,069,050$ 1,300,188$ 13,688$
Expenditures:
Personnel 274,795$ 14,066$ 27,992$ 298,333$ 615,186$ 602,110$ 102.2%1,104,390$ 584,282$ 30,904$
Materials & Supplies 96,612 10,205 577 120,850 228,244 245,600 92.9%346,095 152,743 75,501
Operational & Contractual 132,863 - 33,792 24,163 190,818 183,510 104.0%289,035 141,116 49,702
Other - - - - - - N/A (83,150) 33,048 (33,048)
Capital 220,549 - - 80,004 300,553 195,000 154.1%265,000 59,044 241,509
Total Expenditures 724,819$ 24,271$ 62,361$ 523,350$ 1,334,801$ 1,226,220$ 108.9%1,921,370$ 970,233$ 364,568$
Direct Revenues Over (Under) Expenditures 117,413$ 263,485$ 121,527$ (523,350)$ (20,925)$ 164,795$ -12.7%147,680$ 329,955$ (350,880)$
Transfer from Golf Surcharge 212,969$ -$ -$ -$ 212,969$ 105,000$ 202.8%175,000$ -$ 212,969$
Adjusted Revenues Over (Under) Expenditures 330,382$ 263,485$ 121,527$ (523,350)$ 192,044$ 269,795$ 322,680$ 329,955$ (137,911)$