09 - September 2018 Monthly Financial ReportVILLAGE
OAK BROOK
OF
MONTHLY FINANCIAL REPORTS
SEPTEMBER 2018
ITEM 6.D
Total
Cash and Cash Pooled Cash and
Fund Equivalents Investments Investments % By Fund
General Corporate $6,279,534 $12,950,348 $19,229,882 43.1%
Hotel/Motel Tax 1,641,089 2,895,743 4,536,832 10.2%
Motor Fuel Tax 544,679 182,350 727,029 1.6%
Infrastructure 7,083,649 3,503,883 10,587,532 23.7%
Promenade TIF 191,016 - 191,016 0.4%
Water 4,403,884 1,442,894 5,846,778 13.1%
Sports Core 582,337 - 582,337 1.3%
Golf Surcharge 77,219 586,883 664,102 1.5%
Self-Insurance 366,626 - 366,626 0.8%
Garage 393,979 - 393,979 0.9%
Equipment Replacement 485,483 1,011,527 1,497,010 3.4%
Total $22,049,495 $22,573,628 $44,623,123 100.0%
Change in Cash and Investments by Fund :
Balance at Balance at Year-to-Date Year-to-Date
Fund January 1, 2018 September 30, 2018 Change ($)Change (%)
General Corporate $17,679,496 $19,229,882 $1,550,386 8.8%
Hotel/Motel Tax 4,172,234 4,536,832 364,598 8.7%
Motor Fuel Tax 574,460 727,029 152,569 26.6%
Infrastructure 8,222,145 10,587,532 2,365,387 28.8%
Promenade TIF 276,164 191,016 (85,148)-30.8%
Water 5,693,109 5,846,778 153,669 2.7%
Sports Core 472,473 582,337 109,864 23.3%
Golf Surcharge 559,073 664,102 105,029 18.8%
Self-Insurance 45,042 366,626 321,584 714.0%
Garage 427,409 393,979 (33,430)-7.8%
Equipment Replacement 1,805,752 1,497,010 (308,742)-17.1%
$39,927,358 $44,623,123 $4,695,765 11.8%
Book Market
Value Value
Pooled Checking $1,238,235 $1,238,235
Sports Core Checking 644,852 644,852
Pooled IPTIP 20,132,245 20,132,245
Water E-Pay IPTIP 34,163 34,163
$22,049,495 $22,049,495
Pooled Investments:
Investments-Municipal Bonds $7,585,911 $7,459,879
Investments-Corporate Bonds 7,922,041 7,917,360
Government & Agency Obligations 706,833 676,278
Certificates of Deposit 6,230,000 6,168,437
Accrued Interest 128,843 128,843
Total Pooled Investments $22,573,628 $22,350,797
Total Cash and Investments $44,623,123 $44,400,292
For September, total interest revenue is $71,842 and YTD interest revenue is $556,934.
Total investment yield for the portfolio is:
Pooled
Investments Illinois Funds Total
Monthly yield 0.17%0.18%0.18%
YTD yield 1.39%1.34%1.37%
Last 12 months yield 1.80%1.61%1.71%
The weighted average yield of the current pooled investment portfolio is 2.07%.
Monthly Treasurer's Report
September 30, 2018
Monthly Treasurer's Report
September 2018
The table below lists the detail investment holdings at J.P. Morgan Securities as of 9/30/18:
Month End VOB
Settlement Maturity Coupon Yield Book Market Accrued
Type Date Date Rate Rate Value Value Interest
Municipal Bonds:
Maryland St Econ Dev #57420PGK6 07/08/15 6/1/2019 2.050%2.123%$99,950 $99,595 $681
Rosemont IL GO Corp #777543UT4 02/08/16 12/1/2019 3.021%2.000%505,823 497,545 4,939
New York N Y City #64971QTX1 02/22/16 5/1/2021 2.350%2.000%201,745 195,904 1,944
Florida Hurricane #34074GDH4 03/30/16 7/1/2020 2.995%2.150%507,159 499,700 3,743
Bloomingdale Mich Pub Sch Dist #094383FS0 04/26/16 5/1/2022 2.710%2.150%509,585 487,650 5,607
Milan Mich Area Achs #598801JD1 05/26/16 5/1/2020 1.931%1.931%245,000 241,080 1,870
Indiana Bd Bk Rev Taxable #4546248F7 01/06/17 1/15/2020 2.934%1.900%258,317 254,559 1,593
Garland Cnty Ark Sales & Use #36609PAN3 02/06/17 11/1/2019 1.795%1.840%499,757 494,650 3,864
Anchor Bay Mich Sch Dist GO #032879TA6 02/13/17 5/1/2019 1.810%1.420%365,830 362,255 2,676
Macomb Cnty Mich Retirees #554885H63 04/11/17 11/1/2018 1.731%1.300%400,145 399,788 2,842
Lanse Creuse Mich Pub Schs #516228RL9 05/02/17 5/1/2020 2.159%2.159%100,000 98,673 897
California St GO Bonds #13063A7G3 05/08/17 10/1/2019 6.200%1.600%522,816 516,465 15,218
*Genesee Cnty Mich #371608UV0 05/31/17 10/1/2019 2.681%2.681%280,000 280,028 653
Connecticut St GO Bds 2016 #20772J3F7 06/15/17 8/15/2021 1.750%2.300%492,391 475,370 1,065
North Carolina Eastn Mun Pwr #65819WAL7 10/02/17 7/1/2019 2.578%1.700%503,280 499,345 3,079
Fowlerville Mich Comnty Schs #351280MS8 10/03/17 5/1/2020 2.045%1.750%502,305 493,100 4,090
Racine Cnty WI #749845UK7 12/20/17 12/1/2020 2.150%2.150%750,000 731,408 5,375
Wisconsin St Gen Fd Annual #977100CW4 01/05/18 5/1/2020 1.446%2.100%593,883 584,946 3,519
Illinois St G/O #452152HU8 04/03/18 3/1/2019 5.877%3.000%247,925 247,818 1,080
Total Municipal Bonds $7,585,911 $7,459,879 $64,735
Corporate Bonds:
American Honda Finance Corp #02665WAC5 01/25/18 10/10/2018 2.125%1.809%$1,000,065 $999,870 $10,036
JP Morgan Securities #44640QKV2 02/01/18 10/29/2018 2.082%2.082%1,497,476 1,497,105 0
Wells Fargo #94974BFQ8 04/25/18 1/15/2019 2.150%2.330%1,389,257 1,388,443 6,226
Huntington National Bank #446438RG0 07/06/18 4/1/2019 2.200%2.541%698,805 698,390 7,657
Bank of America #06051GFD6 07/06/18 4/1/2019 2.650%2.509%750,528 750,053 9,496
KeyBank #49327M2N3 07/19/18 3/8/2019 2.350%2.490%844,478 844,172 1,214
Bank of America #06051GFD6 07/30/18 4/1/2019 2.650%2.420%245,273 245,017 3,246
Morgan Stanley #61746BDM5 08/03/18 1/24/2019 2.500%2.430%1,000,212 999,430 4,514
Goldman Sachs #38141GVP9 09/26/18 9/15/2020 2.750%3.180%495,947 494,880 573
Total Corporate Bonds $7,922,041 $7,917,360 $42,962
Government & Agency Obligations:
**Government National Mtg Assn #38379UEM4 02/29/16 2/16/2051 2.300%2.245%$706,833 $676,278 $2,037
Total Government & Agency Obligations:$706,833 $676,278 $2,037
Certificates of Deposit:
Ally Bk Midvale Utah #02006LVC4 10/29/15 10/29/2018 1.600%1.600%$245,000 $244,953 $1,639
Enerbank #29266N4E4 10/21/16 10/22/2018 1.100%1.100%245,000 244,870 1,201
Discover Bank #254672L71 10/26/16 10/26/2018 1.200%1.200%245,000 244,814 1,270
State Bk India NY #8562846A7 01/26/17 1/26/2022 2.250%2.250%245,000 238,255 1,018
Marlin Business Bk #57116ANU8 05/10/17 11/12/2019 1.600%1.600%245,000 242,388 214
American Express Fed Svgs #02587CER7 05/10/17 11/12/2019 1.700%1.700%245,000 242,614 1,631
Synchrony Bank #87164WRA8 05/26/17 5/28/2019 1.650%1.650%245,000 243,993 1,381
Umpqua Bank #90421MAG8 05/31/17 5/31/2019 1.600%1.600%245,000 243,898 1,318
Stone Bk Mtn View Ark #86158RAJ8 06/28/17 6/28/2019 1.600%1.600%245,000 243,706 14
TIAA FSB Jacksonville #87270LAA1 07/19/17 7/19/2019 1.600%1.600%245,000 243,508 784
Peoples United Bank #71270QQZ2 07/19/17 7/19/2019 1.650%1.650%245,000 243,608 809
Priority Bank Ozark Ark #74269KBR6 07/26/17 7/26/2019 1.600%1.600%245,000 243,449 42
American Express Centurion #02587DV96 08/15/17 8/17/2020 1.900%1.900%245,000 240,095 582
Sallie Mae #795450C86 08/16/17 8/17/2020 1.900%1.900%245,000 240,683 582
Merrick Bank South Jordan #59013JZS1 08/21/17 8/21/2020 1.800%1.800%245,000 240,186 115
Pinnacle Bank #72345SFS5 08/30/17 8/31/2020 1.800%1.800%115,000 112,689 178
Jackson County Bank #466682AP6 08/31/17 3/1/2021 1.850%1.850%245,000 238,539 378
Barclays Bank #06740KKX4 09/27/17 9/28/2020 1.950%1.950%245,000 240,475 40
Capital One Bank #1404205E6 10/04/17 10/4/2019 1.700%1.700%245,000 242,989 2,042
Transportation Alliance #89388CCB2 10/13/17 4/12/2019 1.600%1.600%235,000 234,222 173
Goldman Sachs Bank #38148PRK5 10/18/17 10/19/2020 1.950%1.950%245,000 240,301 2,156
FirstBank PR Santurce #33767A6M8 11/03/17 11/3/2020 2.000%2.000%245,000 240,401 356
Morgan Stanley #61747MQ53 03/22/18 3/23/2020 2.550%2.550%245,000 244,449 113
Investors Community Bank #46147UTT7 08/28/18 2/28/2020 2.550%2.550%245,000 244,557 25
Lakeside Bank #51210SPS0 08/30/18 3/30/2020 2.550%2.550%245,000 244,412 538
Bank United #066519GJ2 08/31/18 2/20/2028 2.500%2.500%245,000 244,383 510
Total Certificates of Deposits $6,230,000 $6,168,437 $19,109
Total J.P.Morgan Securities $22,444,785 $22,221,954 $128,843
*Interest rate is a floating rate that sets each month. Rate is determined at the one-month LIBOR rate plus 0.60%.
**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
September 30, 2018
Cash & Investments by Fund - Total $44.6 million
Cash & Investments by Type - Total $44.6 million
Checking
Illinois Funds
Certificates of Deposit
Municipal Bonds
Corporate Bonds
Government & Agency Obligations
Accrued Interest
General Corporate
43.09%
Hotel/Motel Tax
10.17%Motor Fuel Tax
1.63%
Infrastructure
23.73%
Promenade TIF
0.43%
Water
13.10%
Sports Core
1.31%
Golf Surcharge
1.49%
Self-Insurance
0.82%Garage
0.88%
Equipment
Replacement
3.35%
Checking, $1.9
Illinois Funds, $20.2
Certificates of Deposit,
$6.2
Municipal Bonds, $7.6
Corporate Bonds, $7.9
Government & Agency
Obligations, $0.7
Accrued Interest, $0.1
in millions
Village of Oak Brook
Monthly Financial Report – Fund Narrative
For the Period Ending September, 2018
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 the Village’s major funds. Highlights for each of
the Village’s funds are:
General Fund
Total revenues through September 2018 are $1,503,537 higher than last year and $1,998,900
over budget.
o Sales tax revenue, the General Fund’s largest revenue source, is down $98,035 from last
year and $29,496 under budget. This is due to the closure of two large taxpayers in late
2017.
o Other intergovernmental tax revenue is down $91,657 from last year, but $92,498 over
budget. Revenue is down from last year due to extra one-time Income Tax payments
from the State. Revenue from Income Tax, Replacement Tax, and Use Tax has been
better than budgeted in 2018, despite a 10% reduction in Income Tax receipts by the
State. This reduction was changed from 10% to 5% midway through 2018.
o Telecommunications/utility tax revenue is up $93,113 from last year and $254,461 over
budget. Revenue is over budget due to a planned reduction of 5% in
telecommunications tax revenue from business closures that has not occurred to date.
o Licenses and permits revenue is up $1,132,428 from last year and $1,286,738 over
budget. The increase is due to the receipt large building permits that have occurred to
date, including KidZania, Carvana, and LifeTime Fitness.
Total expenditures through September 2018 are $1,316,732 higher than last year, but
$2,034,993 under budget.
o Personnel expenditures are up $488,431 from last year, but $1,048,631 under budget.
The increase is due to general wage and benefits increases. Personnel is under budget
due to a delay in full pension funding that may occur later in 2018.
o Operation and contract expenditures are down $284,544 from last year and $510,202
under budget. This is due to a reduction in liability insurance payments in 2018 and the
general timing of payments compared to when they were projected to occur.
o Capital outlay expenditures are up $1,088,373 from last year, but $356,127 under
budget. The increase is due to the Police Department expansion project in 2018.
Hotel Tax Fund
Total revenues through September 2018 are $79,341 higher than last year and $16,688 over
budget.
o Hotel tax revenue is up $65,668 from last year, but $21,445 under budget. This is due to
an additional hotel in 2018 as Hyatt House opened in late 2017, but an overall softening
of room rentals in 2018.
o Interest income revenue is up $22,027 from last year and $35,156 over budget. This is
due to favorable market conditions and rising interest rates.
Total expenditures through September 2018 are $405,791 lower than last year and $550,017
under budget.
o Operation and contract expenditures are up $37,961 from last year, but $129,680 under
budget. Expenditures are down due to the timing of advertising expenditures paid.
Payments are still to come later in FY2018 as originally budgeted.
o Capital Outlay expenditures are down $448,360 from last year and $420,337 under
budget. This is due to the timing of projects scheduled.
Motor Fuel Tax Fund
Total revenues through September 2018 are up $496 from last year and $2,724 over budget.
Motor Fuel Tax receipts are slightly under budget, but are offset by increases in interest income.
Total expenditures through September 2018 are down $212,999from last year and $492,210
under budget. This is due to the timing of the transfer of funds to the Infrastructure Fund to pay
for roadway improvements.
Infrastructure Fund
Total revenues through September 2018 are down $47,121 from last year, but $112,448 over
budget.
o Non-home rule sales tax revenue is down $111,757 from last year, but $20,031 over
budget. This is primarily due to the State’s implementation of a 2% collection fee and
the closure of two large taxpayers. The collection fee decreased to 1.5% effective July
2018.
o Interest income revenue is up $70,794 from last year and $93,423 over budget. This is
due to favorable market conditions and rising interest rates.
Total expenditures through September 2018 are down $258,443 from last year and $4,223,964
under budget.
o Personnel expenditures are up $30,233 from last year, but $105,807 under budget.
Personnel is under budget due to employee turnover.
o Operation and contract expenditures are down $89,126 from last year and $310,836
under budget. The reduction is due to a decrease in liability insurance premiums from
last year. Expenditures are under budget due to the timing of engineering payments.
o Capital outlay expenditures are down $224,060 from last year and $3,759,818 under
budget. This is due to the timing of roadway improvement projects.
Promenade TIF Fund
Total revenues through September 2018 are down $12,285 from last year and $11,265 under
budget. This is due to a decrease in real estate tax revenue from last year.
Total expenditures through September 2018 are up $34,885 from last year and $29,313 over
budget. The increase relates to additional principal paid towards the TIF note.
Water Fund
Total revenues through September 2018 are up $263,730 from last year and $162,493 over
budget.
o Water sales revenue is up $252,395 from last year and $8,131 over budget. The
increase from last year is due to a 7% rate increase effective 1/1/18. Water gallons sold
has also been slightly more than projected so far this year.
Total expenditures through September 2018 are up $1,832,231 from last year, but $1,621,630
under budget.
o Operation and contract expenditures are up $56,181 from last year, but $1,284,885
under budget. The increase is due to a rate increase from DuPage Water Commission.
Expenditures are under budget due to the timing of invoices paid.
o Capital outlay expenditures are up $1,797,104 from last year, but $271,307 under
budget. The increase relates to the start of the Village-wide water meter replacement
project.
Sports Core Fund
Total revenues through September 2018 are down $180,299 from last year and $78,677 under
budget.
o Memberships are up $18,271 from last year and $13,849 over budget. Memberships
from both B&T and Golf are up in 2018 compared to last year.
o Greens Fees are down $57,582 from last year and $79,093 under budget. Rounds
played are down in 2018 due to unfavorable weather conditions.
o Rentals are up $46,327 from last year and $34,767 over budget. This is due to the
reclassification of driving range rental fees and the timing of fees received.
o Program/User Fees are down $119,330 from last year and $63,519 under budget. This
is due to the timing of soccer field rental payments and the reclassification of driving
range rental fees.
Total expenditures through September 2018 are up $172,541 from last year, but $446,289
under budget.
o Personnel expenditures are up $25,878 from last year and $36,376 over budget. This is
due to a combination of: an increase in the tennis program, the B&T grill being run in-
house rather than outsourced, and increased staff time for golf course maintenance.
o Materials & Supplies expenditures are down $49,973 from last year and $108,501 under
budget. This is due to the timing of golf course maintenance supplies purchases.
o Operation and Contractual expenditures are up $131,281 from last year and $130,038
over budget. This is due to the outsourcing of swim operations to the Park District,
which required management fees to be paid before the season.
o Capital outlay expenditures are up $7,732 from last year, but $446,335 under budget.
Expenses are under budget due to the general timing of projects or the cancellation of
budgeted projects.
Golf Surcharge Fund
Total revenues through September 2018 are down $7,014 from last year and $1,581 under
budget. This is due to less rounds played in 2018 compared to last year. Interest income
revenue has helped make up the reduction in golf surcharge revenue in 2018.
No golf surcharge funds have been transferred or expended in 2018 so far.
Self Insurance Fund
Total revenues through September 2018 are down $31,126 from last year and $106,231 under
budget. This is due retirees moving to a new insurance plan in FY18.
Total expenditures through September 2018 are down $324,238 from last year and $406,656
under budget. This is due to the timing of invoices paid and health claims coming in lower than
projected.
Garage Fund
Total revenues through September 2018 are down $97,031 from last year, but $4,600 over
budget. This is due to a budgeted reduction in maintenance charges to use available net
position reserves.
Total expenditures through September 2018 are down $17,800 from last year and $118,129
under budget. This is due to the delay in hiring a vacant position and a general decrease in
maintenance costs.
Equipment Replacement Fund
Total revenues through September 2018 are down $282,539 from last year, but $33,874 over
budget. This is due to grant revenue received for equipment purchases last year and a
reduction in replacement charges to use available net position.
Total expenditures through September 2018 are up $259,522 from last year and $73,978 over
budget. This is due to the timing of scheduled vehicle replacements being ordered and
received.
YTD YTD
Net Fund Budgeted
YTD YTD Increase Increase
Governmental Funds Revenues Expenditures (Decrease)(Decrease)
General Fund (Major Fund)19,858,159 $18,062,160 $1,795,999 $300,492
Main operating fund of the Village.
Hotel Fund (Major Fund)$1,006,188 $448,603 $557,585 ($9,120)
Collects and spends resources from the
3% hotel/motel tax.
Motor Fuel Tax Fund $160,359 $7,790 $152,569 ($342,365)
Collects and spends resources from the
State motor fuel tax.
Infrastructure Fund (Major Fund)$4,463,319 $2,039,471 $2,423,848 ($1,420,345)
Accounts for construction and maintenance of
roadways, drainage, and safety path systems.
Promenade TIF Fund (Major Fund)$408,075 $493,223 ($85,148)($44,570)
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)$7,785,553 $6,571,915 $1,213,638 ($570,485)
Collects user fees for the distribution of water
and maintenance of infrastructure.
Sports Core Fund (Major Fund)$2,993,986 $2,747,076 $246,910 $164,780
Accounts for revenues and expenses relating
to administration, programs, food and beverage
operations, and golf course.
Golf Surcharge Fund $105,029 $0 $105,029 ($178,890)
Accounts for the collection of the $3 per round
golf surcharge.
Internal Service Funds
Self Insurance Fund $2,315,154 $2,091,779 $223,375 ($77,050)
Accounts for the Village's health insurance costs
and the related contributions from the Village,
employees, retirees, and other agencies.
Garage Fund $464,120 $478,546 ($14,426)($137,155)
Accounts for the maintenance of the Village's vehicle
fleet and the related departmental reimbursements.
Equipment Replacement Fund $336,049 $580,268 ($244,219)($204,115)
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 September 30, 2018
9/30/18 9/30/18
9/30/17 9/30/18 YTD % of 2018 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 9,342,539$ 9,244,504$ 9,274,000$ 100%12,453,000$ (98,035)$
Other Intergovernmental Tax 1,092,255 1,000,598 908,100 110%1,144,700 (91,657)
Telecommunications/Utility Tax 4,513,733 4,606,846 4,352,385 106%5,792,250 93,113
Licenses and Permits 1,692,450 2,824,878 1,538,140 184%1,784,070 1,132,428
Charges for Services 698,024 867,878 736,550 118%1,017,100 169,854
Fines and Penalties 105,867 132,693 112,840 118%150,500 26,826
Administrative Towing Fees 31,375 24,475 26,240 93%35,000 (6,900)
Interest on Investments 164,515 254,189 146,250 174%195,000 89,674
Franchise/IMF Maint. Fee 107,597 107,304 161,250 67%215,000 (293)
Miscellaneous Income 134,478 323,005 131,715 245%180,750 188,527
Total Operating Revenues 17,882,833$ 19,386,370$ 17,387,470$ 111%22,967,370$ 1,503,537$
OPERATING EXPENDITURES
Personnel 12,264,968$ 12,753,399$ 13,802,030$ 92%17,953,350$ 488,431$
Materials and Supplies 312,412 335,125 418,315 80%532,820 22,713
Operation and Contract 3,030,887 2,746,343 3,256,545 84%4,278,675 (284,544)
Other Expenditures 101,128 102,887 139,730 74%388,815 1,759
Capital Outlay 1,036,033 2,124,406 2,480,533 86%2,997,840 1,088,373
Total Operating Expenditures 16,745,428$ 18,062,160$ 20,097,153$ 90%26,151,500$ 1,316,732$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 1,137,405$ 1,324,210$ (2,709,683)$ (3,184,130)$ 186,805$
OTHER TRANSACTIONS
Reimbursements From Other Funds 462,978$ 471,789$ 535,010$ 88%713,360$ 8,811$
Installment Contract Proceeds - - 2,475,165 0%2,475,165 -
Total Interfund Transactions 462,978$ 471,789$ 3,010,175$ 0%3,188,525$ 8,811$
NET FUND INCREASE (DECREASE)1,600,383$ 1,795,999$ 300,492$ 4,395$ 195,616$
Village of Oak Brook
General Fund Financial Update
For the Period Ending September 30, 2018
Total Total
Revenues Expenditures
9/30/18 Actual 19,386,370$ 18,062,160$
9/30/17 Actual 17,882,833$ 16,745,428$
% Change From Last Year 8.4%7.9%
Major Revenues Other
Intergov.Licenses &Charges for
Sales Tax Tax Telecom Tax Permits Services
9/30/18 Actual 9,244,504$ 1,000,598$ 4,606,846$ 2,824,878$ 867,878$
9/30/17 Actual $ 9,342,539 $ 1,092,255 $ 4,513,733 $ 1,692,450 $ 698,024
% Change From Last Year -1.0%-8.4%2.1%66.9%24.3%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
9/30/18 Actual 12,753,399$ 335,125$ 2,746,343$ 102,887$ 2,124,406$
9/30/17 Actual 12,264,968$ 312,412$ 3,030,887$ 101,128$ 1,036,033$
% Change From Last Year 4.0%7.3%-9.4%1.7%105.1%
Five Year Trend
Expenditures by Department
9/30/17 9/30/18 9/30/18 9/30/18 2018 Difference Five
YTD YTD YTD % of Annual Prior Year
Department Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 1,981,575$ 1,682,986$ 2,088,320$ 80.6%2,673,305$ (298,589)$
Financial Services 621,091 639,218 703,855 90.8%1,117,875 18,127
Public Works 504,370 495,101 759,355 65.2%993,820 (9,269)
Engineering & Capital Projects 759,061 1,990,371 2,161,868 92.1%2,732,665 1,231,310
Library 684,074 661,254 683,510 96.7%889,845 (22,820)
Police 6,144,828 6,302,397 6,686,615 94.3%8,705,350 157,569
Fire 5,320,016 5,580,560 6,256,770 89.2%8,043,215 260,544
Development Services 730,413 710,273 756,860 93.8%995,425 (20,140)
Total Expenditures 16,745,428$ 18,062,160$ 20,097,153$ 89.9%26,151,500$ 1,316,732$
Five Year Trend
For the Period Ending September 30, 2018
General Fund - Five Year Trend
Village of Oak Brook
Revenues Expenditures
9/30/18 9/30/18
9/30/17 9/30/18 YTD % of 2018 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Hotel Tax 879,887$ 945,555$ 967,000$ 98%1,340,000$ 65,668$
Interest 35,629 57,656 22,500 256%30,000 22,027
Miscellaneous 11,331 2,977 - N/A - (8,354)
Total Operating Revenues 926,847$ 1,006,188$ 989,500$ 102%1,370,000$ 79,341$
EXPENDITURES
Operation and Contract 329,664$ 367,625$ 497,305$ 74%646,515$ 37,961$
Other Expenditures 70,047 74,655 74,655 100%99,550 4,608
Capital Outlay 454,683 6,323 426,660 1%640,000 (448,360)
Total Expenditures 854,394$ 448,603$ 998,620$ 44.9%1,386,065$ (405,791)$
NET FUND INCREASE (DECREASE)72,453$ 557,585$ (9,120)$ (16,065)$ 485,132$
Note - Expenditures are recorded in program 171.
Village of Oak Brook
Hotel Tax Fund Financial Update
For the Period Ending September 30, 2018
Total Total
Revenues Expenditures
9/30/18 Actual $ 1,006,188 448,603$
9/30/17 Actual $ 926,847 854,394$
% Change From Last Year 8.6%-47.5%
Major Revenues
Grants Hotel Tax Interest Miscellaneous
9/30/18 Actual $ - $ 945,555 $ 57,656 $ 2,977
9/30/17 Actual $ - $ 879,887 $ 35,629 $ 11,331
% Change From Last Year 0.0%7.5%61.8%-73.7%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures Capital Outlay
9/30/18 Actual 367,625$ 74,655$ 6,323$
9/30/17 Actual 329,664$ 70,047$ 454,683$
% Change From Last Year 11.5%6.6%-98.6%
Five Year Trend
Village of Oak Brook
Hotel Tax Fund - Major Sources Five Year Trend
For the Period Ending September 30, 2018
Five Year Trend
Revenues Expenditures
9/30/18 9/30/18
9/30/17 9/30/18 YTD % of 2018 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 4,303,788$ 4,192,031$ 4,172,000$ 100%5,563,000$ (111,757)$
Grants 3,142 - - 0%- (3,142)
Interest 54,129 124,923 31,500 397%42,000 70,794
Miscellaneous 5,745 2,729 3,735 73%5,000 (3,016)
Total Operating Revenues 4,366,804$ 4,319,683$ 4,207,235$ 103%5,610,000$ (47,121)$
OPERATING EXPENDITURES
Personnel 886,575$ 916,808$ 1,022,615$ 90%1,365,445$ 30,233$
Materials and Supplies 74,354 97,091 144,585 67%182,955 22,737
Operation and Contract 920,975 831,849 1,142,685 73%1,484,755 (89,126)
Other Expenditures 121,878 123,651 123,660 100%164,865 1,773
Capital Outlay 294,132 70,072 3,829,890 2%5,625,620 (224,060)
Total Operating Expenditures 2,297,914$ 2,039,471$ 6,263,435$ 33%8,823,640$ (258,443)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 2,068,890$ 2,280,212$ (2,056,200)$ -111%(3,213,640)$ 211,322$
INTERFUND TRANSACTIONS
Transfers In 220,789$ 7,790$ 500,000$ 2%500,000$ (212,999)$
Reimbursements From Other Funds 132,480 135,846 135,855 100%181,130 3,366
Total Interfund Transactions 353,269$ 143,636$ 635,855$ 23%681,130$ (209,633)$
NET FUND INCREASE (DECREASE)2,422,159$ 2,423,848$ (1,420,345)$ (2,532,510)$ 1,689$
Village of Oak Brook
Infrastructure Fund Financial Update
For the Period Ending September 30, 2018
Total Total
Revenues Expenditures
9/30/18 Actual $ 4,319,683 2,039,471$
9/30/17 Actual $ 4,366,804 2,297,914$
% Change From Last Year -1.1%-11.2%
Major Revenues
Sales Tax Grants Interest Miscellaneous Reimbursements
9/30/18 Actual $ 4,192,031 $ - $ 124,923 $ 2,729 $ 135,846
9/30/17 Actual $ 4,303,788 $ 3,142 $ 54,129 $ 5,745 $ 132,480
% Change From Last Year -2.6%-100.0%130.8%-52.5%2.5%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
9/30/18 Actual 916,808$ 97,091$ 831,849$ 123,651$ 70,072$
9/30/17 Actual 886,575$ 74,354$ 920,975$ 121,878$ 294,132$
% Change From Last Year 3.4%30.6%-9.7%1.5%-76.2%
Five Year Trend
Expenditures by Department
9/30/17 9/30/18 9/30/18 9/30/18 2018 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 117,068$ 114,212$ 132,330$ 86.3%178,530$ (2,856)$
Public Works 1,727,537 1,542,209 2,013,770 76.6%2,592,335 (185,328)
Engineering & Capital Projects 453,309 383,050 4,117,335 9.3%6,052,775 (70,259)
Total Expenditures 2,297,914$ 2,039,471$ 6,263,435$ 32.6%8,823,640$ (258,443)$
Five Year Trend
Village of Oak Brook
Infrastructure Fund - Major Sources Five Year Trend
For the Period Ending September 30, 2018
Revenues Expenditures
9/30/18 9/30/18
9/30/17 9/30/18 YTD % of 2018 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 35,077$ 34,169$ 34,150$ 100%102,500$ (908)$
Real Estate Tax 385,018 373,123 385,000 97%385,000 (11,895)
Interest 265 783 190 412%250 518
Total Operating Revenues 420,360$ 408,075$ 419,340$ 97%487,750$ (12,285)$
EXPENDITURES
Operation and Contract 3,958$ 3,403$ 4,090$ 83%4,090$ (555)$
Other Expenditures 454,380 489,820 459,820 107%459,820 35,440
Total Expenditures 458,338$ 493,223$ 463,910$ 106%463,910$ 34,885$
NET FUND INCREASE (DECREASE)(37,978)$ (85,148)$ (44,570)$ 23,840$ (47,170)$
Note - Expenditures are recorded in program 283.
Village of Oak Brook
Promenade TIF Fund Financial Update
For the Period Ending September 30, 2018
Total Total
Revenues Expenditures
9/30/18 Actual $ 408,075 493,223$
9/30/17 Actual $ 420,360 458,338$
% Change From Last Year -2.9%7.6%
Major Revenues Real Estate
Sales Tax Tax Interest
9/30/18 Actual $ 34,169 $ 373,123 $ 783
9/30/17 Actual $ 35,077 $ 385,018 $ 265
% Change From Last Year -2.6%-3.1%195.5%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures
9/30/18 Actual 3,403$ 489,820$
9/30/17 Actual 3,958$ 454,380$
% Change From Last Year -14.0%7.8%
Five Year Trend
Village of Oak Brook
Promenade TIF Fund - Major Sources Five Year Trend
For the Period Ending September 30, 2018
Five Year Trend
Revenues Expenditures
9/30/18 9/30/18
9/30/17 9/30/18 YTD % of 2018 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Grants 3,386$ -$ -$ 0%-$ (3,386)$
Plan Review Fees 1,489 675 1,485 45%2,000 (814)
Building/Inspection Fees 9,589 7,688 3,740 206%5,000 (1,901)
Water Sales 7,231,161 7,483,556 7,475,425 100%9,730,425 252,395
Unmetered Sales 26,803 26,113 22,500 116%30,000 (690)
Water Connection Fees 135,700 110,894 37,400 297%50,000 (24,806)
Fire Service Charge - - 3,740 0%5,000 -
Meter Charges 17,077 8,635 18,765 46%25,000 (8,442)
Special Services 15,286 16,394 15,000 109%30,000 1,108
Interest on Investments 26,432 70,584 7,515 939%10,000 44,152
Miscellaneous 54,900 61,014 37,490 163%50,000 6,114
Total Operating Revenues 7,521,823$ 7,785,553$ 7,623,060$ 102%9,937,425$ 263,730$
EXPENDITURES
Personnel 602,777$ 565,903$ 626,795$ 90%817,490$ (36,874)$
Materials and Supplies 40,556 53,703 58,240 92%76,860 13,147
Operation and Contract 3,745,909 3,802,090 5,086,975 75%6,780,015 56,181
Other Expenditures 301,203 303,876 303,885 100%405,170 2,673
Capital Outlay 49,239 1,846,343 2,117,650 87%2,710,220 1,797,104
Total Expenditures 4,739,684$ 6,571,915$ 8,193,545$ 80%10,789,755$ 1,832,231$
NET FUND INCREASE (DECREASE)2,782,139$ 1,213,638$ (570,485)$ (852,330)$ (1,568,501)$
Village of Oak Brook
Water Fund Financial Update
For the Period Ending September 30, 2018
Total Total
Revenues Expenditures
9/30/18 Actual $ 7,785,553 6,571,915$
9/30/17 Actual $ 7,521,823 4,739,684$
% Change From Last Year 3.5%38.7%
Unmetered Water
Water Sales Sales Connection Fees Meter Charges Miscellaneous
9/30/18 Actual $ 7,483,556 $ 26,113 $ 110,894 $ 8,635 $ 61,014
9/30/17 Actual $ 7,231,161 $ 26,803 $ 135,700 $ 17,077 $ 54,900
% Change From Last Year 3.5%-2.6%-18.3%-49.4%11.1%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
9/30/18 Actual 565,903$ 53,703$ 3,802,090$ 303,876$ 1,846,343$
9/30/17 Actual 602,777$ 40,556$ 3,745,909$ 301,203$ 49,239$
% Change From Last Year -6.1%32.4%1.5%0.9%3649.8%
Five Year Trend
Expenditures by Department
9/30/17 9/30/18 9/30/18 9/30/18 2018 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Public Works 4,692,609$ 4,689,109$ 6,134,645$ 76.4%8,124,535$ (3,500)$
Engineering & Capital Projects 47,075 1,882,806 2,058,900 91.4%2,665,220 1,835,731
Total Expenditures 4,739,684$ 6,571,915$ 8,193,545$ 80.2%10,789,755$ 1,832,231$
Five Year Trend
Village of Oak Brook
Water Fund - Major Sources Five Year Trend
For the Period Ending September 30, 2018
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Sports Core Fund Consolidated Presentation
For the Period Ending September 30, 2018
9/30/18 9/30/18
9/30/18 YTD % of 2018 9/30/17 Difference
B&T Recreation Food &Golf YTD Amended Amended Adopted YTD Prior
Programs Beverage Club Total Budget Budget Budget Total Year
DIRECT REVENUES
Memberships 229,374$ -$ 204,050$ 433,424$ 419,575$ 103%414,875$ 415,153$ 18,271$
Greens Fees - - 808,807 808,807 887,900 91%975,000 866,389 (57,582)
Pro Shop Sales - - 166,474 166,474 173,000 96%200,000 163,230 3,244
Golf Lessons - - 22,512 22,512 40,000 56%40,000 43,119 (20,607)
Driving Range Fees - - 208,578 208,578 225,500 92%235,000 227,788 (19,210)
Rentals - - 377,442 377,442 342,675 110%451,000 331,115 46,327
Programs/User Fees 207,871 - - 207,871 271,390 77%300,700 327,201 (119,330)
Food Sales - 148,738 - 148,738 132,945 112%145,500 166,414 (17,676)
Beverage Sales - 215,934 - 215,934 216,015 100%236,000 248,984 (33,050)
Other Revenue 188,253 185,065 6,885 380,203 339,660 112%380,650 360,889 19,314
Total Direct Revenues 625,498$ 549,737$ 1,794,748$ 2,969,983$ 3,048,660$ 97%3,378,725$ 3,150,282$ (180,299)$
DIRECT EXPENDITURES
Personnel 141,321$ 204,627$ 867,048$ 1,212,996$ 1,176,620$ 103%1,497,200$ 1,187,118$ 25,878$
Materials & Supplies 18,228 150,247 275,169 443,644 552,145 80%615,885 493,617 (49,973)
Operational & Contractual 706,565 111,560 196,063 1,014,188 884,150 115%961,510 882,907 131,281
Other - - (128,577) (128,577) (70,710) 182%(44,275) (186,200) 57,623
Capital 91,588 9,988 103,249 204,825 651,160 31%365,660 197,093 7,732
Total Direct Expenditures 957,702$ 476,422$ 1,312,952$ 2,747,076$ 3,193,365$ 86%3,395,980$ 2,574,535$ 172,541$
Direct Revenues Over (Under) Expenditures (332,204)$ 73,315$ 481,796$ 222,907$ (144,705)$ -154%(17,255)$ 575,747$ (352,840)$
B&T Administration Overhead Allocation*111,504$ (111,504)$ -$ -$ -$ 0%-$ -$ -$
Operating Revenues Over (Under) Expenditures (220,700)$ (38,189)$ 481,796$ 222,907$ (144,705)$ -154%(17,255)$ 575,747$ (352,840)$
Interfund Loan**-$ -$ -$ -$ -$ 0%-$ -$ -$
Transfer From General Fund - - - - - 0%- - -
Reimbursement From Infrastructure Fund 18,000 - - 18,000 18,000 100%24,000 18,000 -
Reimbursement From Water Fund 6,003 - - 6,003 5,985 100%8,000 6,003 -
Transfer From Golf Surcharge Fund - - - - 285,500 0%- - -
Adjusted Operating Revenues Over (Under) Expenditures (196,697)$ (38,189)$ 481,796$ 246,910$ 164,780$ 14,745$ 599,750$ (352,840)$
*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.
Total Direct Total Direct
Revenues Expenditures
9/30/18 Actual $ 2,969,983 2,747,076$
9/30/17 Actual $ 3,150,282 2,574,535$
% Change From Last Year -5.7%6.7%
Driving Program/
Memberships Greens Fees Range Fees Rentals User Fees
9/30/18 Actual $ 433,424 $ 808,807 $ 208,578 $ 377,442 $ 207,871
9/30/17 Actual $ 415,153 $ 866,389 $ 227,788 $ 331,115 $ 327,201
% Change From Last Year 4.4%-6.6%-8.4%14.0%-36.5%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
9/30/18 Actual 1,212,996$ 443,644$ 1,014,188$ (128,577)$ 204,825$
9/30/17 Actual 1,187,118$ 493,617$ 882,907$ (186,200)$ 197,093$
% Change From Last Year 2.2%-10.1%14.9%-30.9%3.9%
Five Year Trend
Revenues by Department 9/30/17 9/30/18 9/30/18 9/30/18 2018 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Programs 743,123$ 625,498$ 646,495$ 96.8%712,075$ (117,625)$
Food & Beverage 567,360 549,737 127,800 430.2%569,000 (15,223)
Golf Club 1,839,799 1,794,748 567,997 316.0%2,097,650 (45,051)
Total Revenues 3,150,282$ 2,969,983$ 1,342,292$ 221.3%3,378,725$ (177,899)$
Expenditures by Department 9/30/17 9/30/18 9/30/18 % of 2018 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Programs 836,008$ 957,702$ 344,363$ 278.1%1,058,430$ 121,694$
Food & Beverage 554,624 476,422 281,968 169.0%514,980 (78,202)
Golf Club 1,183,903 1,312,952 778,751 168.6%1,822,570 129,049
Total Expenditures 2,574,535$ 2,747,076$ 1,405,082$ 195.5%3,395,980$ 172,541$
Five Year Trend
Village of Oak Brook
Sports Core Fund - Major Sources Five Year Trend
For the Period Ending September 30, 2018
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Club Recreation Programs
For the Period Ending September 30, 2018 9/30/18 9/30/18
9/30/18 YTD % of 2018 9/30/17 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 -$ 208,101$ 21,273$ -$ -$ 229,374$ 228,075$ 101%223,375$ 222,790$ 6,584$
Programs/User Fees - 19,401 30,887 - 157,583 207,871 271,390 77%300,700 327,201 (119,330)
Other Revenue (690) 2,621 404 - 185,918 188,253 188,010 100%188,000 193,132 (4,879)
Total Revenue (690)$ 230,123$ 52,564$ -$ 343,501$ 625,498$ 687,475$ 91%712,075$ 743,123$ (117,625)$
Expenditures:
Personnel 89,239$ 20,179$ 26,708$ -$ 5,195$ 141,321$ 169,360$ 83%208,040$ 181,888$ (40,567)$
Materials & Supplies 5,136 9,965 2,075 - 1,052 18,228 25,925 70%28,280 34,491 (16,263)
Operational & Contractual 72,579 307,031 64,743 20,000 242,212 706,565 569,585 124%586,160 568,108 138,457
Other - - - - - - 42,145 0%56,200 - -
Capital 38,845 52,154 - - 589 91,588 106,000 86%179,750 51,521 40,067
Total Expenditures 205,799$ 389,329$ 93,526$ 20,000$ 249,048$ 957,702$ 913,015$ 105%1,058,430$ 836,008$ 121,694$
Direct Revenues Over (Under) Expenditures (206,489)$ (159,206)$ (40,962)$ (20,000)$ 94,453$ (332,204)$ (225,540)$ 147%(346,355)$ (92,885)$ (239,319)$
B&T Administration Overhead Allocation*206,489$ (74,336)$ (20,649)$ -$ 111,504$ 148,755$ 75%207,995$ 133,500$ (21,996)$
Revenues Over (Under) Expenditures -$ (233,542)$ (61,611)$ (20,000)$ 94,453$ (220,700)$ (76,785)$ 287%(138,360)$ 40,615$ (261,315)$
Reimbursement From Infrastructure Fund 18,000$ -$ -$ -$ -$ 18,000$ 18,000$ 100%24,000$ 18,000$ -$
Reimbursement From Water Fund 6,003 - - - - 6,003 5,985 100%8,000 6,003 -
Adjusted Revenues Over (Under) Expenditures 24,003$ (233,542)$ (61,611)$ (20,000)$ 94,453$ (196,697)$ (52,800)$ (106,360)$ 64,618$ (261,315)$
*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.
Village of Oak Brook
Monthly Operating Statement
Sports Core Food & Beverage Programs
For the Period Ending September 30, 2018
9/30/18 9/30/18
821 822 823 9/30/18 YTD % of 2018 9/30/17 Difference
B&T Poolside Golf YTD Amended Amended Adopted YTD Prior
Clubhouse Café Clubhouse Total Budget Budget Budget Total Year
Revenues:
Memberships -$ -$ -$ -$ -$ 0%-$ 2,400$ -$
Food Sales - 34,693 114,045 148,738 132,945 112%145,500 166,414 (17,676)
Beverage Sales - 18,467 197,467 215,934 216,015 100%236,000 248,984 (33,050)
Other Revenue 185,065 - - 185,065 146,500 126%187,500 149,562 35,503
Total Revenue 185,065$ 53,160$ 311,512$ 549,737$ 495,460$ 111%569,000$ 567,360$ (15,223)$
Expenditures:
Personnel 86,965$ 24,003$ 93,659$ 204,627$ 158,355$ 129%199,505$ 184,106$ 20,521$
Materials & Supplies 10,702 15,731 123,814 150,247 160,305 94%182,150 186,728 (36,481)
Operational & Contractual 106,294 752 4,514 111,560 105,080 106%133,325 89,040 22,520
Capital 9,988 - - 9,988 73,750 14%- 94,750 (84,762)
Total Expenditures 213,949$ 40,486$ 221,987$ 476,422$ 497,490$ 96%514,980$ 554,624$ (78,202)$
Direct Revenues Over (Under) Expenditures (28,884)$ 12,674$ 89,525$ 73,315$ (2,030)$ -3612%54,020$ 12,736$ 60,579$
B&T Administration Overhead Allocation*(103,244)$ (8,260)$ -$ (111,504)$ (148,755)$ 75%(175,995)$ (133,500)$ 21,996$
Revenues Over (Under) Expenditures (132,128)$ 4,414$ 89,525$ (38,189)$ (150,785)$ 25%(121,975)$ (120,764)$ 82,575$
Transfer From General Fund -$ -$ -$ -$ -$ 0%-$ -$ -$
Adjusted Revenues Over (Under) Expenditures (132,128)$ 4,414$ 89,525$ (38,189)$ (150,785)$ (121,975)$ (120,764)$ 82,575$
*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 September 30, 2018
9/30/18 9/30/18
831 832 833 834 9/30/18 YTD % of 2018 9/30/17 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 204,050$ -$ -$ -$ 204,050$ 191,500$ 107%191,500$ 189,963$ 14,087$
Greens Fees 808,807 - - - 808,807 887,900 91%975,000 866,389 (57,582)
Pro Shop Sales 166,474 - - - 166,474 173,000 96%200,000 163,230 3,244
Golf Lessons - 22,512 - - 22,512 40,000 56%40,000 43,119 (20,607)
Driving Range Fees - 208,578 - - 208,578 225,500 92%235,000 227,788 (19,210)
Rentals 3,210 70,000 304,232 - 377,442 342,675 110%451,000 331,115 46,327
Other Revenue 6,885 - - - 6,885 5,150 134%5,150 18,195 (11,310)
Total Revenue 1,189,426$ 301,090$ 304,232$ -$ 1,794,748$ 1,865,725$ 96%2,097,650$ 1,839,799$ (45,051)$
Expenditures:
Personnel 370,307$ 22,657$ 46,291$ 427,793$ 867,048$ 848,905$ 102%1,089,655$ 821,124$ 45,924$
Materials & Supplies 119,404 8,188 326 147,251 275,169 365,915 75%405,455 272,398 2,771
Operational & Contractual 137,721 14,058 246 44,038 196,063 209,485 94%242,025 225,759 (29,696)
Other - - 49,573 (178,150) (128,577) (112,855) 114%(100,475) (186,200) 57,623
Capital 32,335 - 40,922 29,992 103,249 471,410 22%185,910 50,822 52,427
Total Expenditures 659,767$ 44,903$ 137,358$ 470,924$ 1,312,952$ 1,782,860$ 74%1,822,570$ 1,183,903$ 129,049$
Direct Revenues Over (Under) Expenditures 529,659$ 256,187$ 166,874$ (470,924)$ 481,796$ 82,865$ 581%275,080$ 655,896$ (174,100)$
Transfer from Golf Surcharge -$ -$ -$ -$ -$ 285,500$ 0%-$ -$ -$
Adjusted Revenues Over (Under) Expenditures 529,659$ 256,187$ 166,874$ (470,924)$ 481,796$ 368,365$ 275,080$ 655,896$ (174,100)$