08 - August 2018 Monthly Financial ReportVILLAGE
OAK BROOK
OF
MONTHLY FINANCIAL REPORTS
AUGUST 2018
ITEM 6.C
Total
Cash and Cash Pooled Cash and
Fund Equivalents Investments Investments % By Fund
General Corporate $5,969,456 $12,959,172 $18,928,628 43.7%
Hotel/Motel Tax 1,590,129 2,895,087 4,485,217 10.4%
Motor Fuel Tax 525,439 183,178 708,617 1.6%
Infrastructure 6,871,335 3,505,336 10,376,671 24.0%
Promenade TIF 4,447 - 4,447 0.0%
Water 3,980,032 1,440,671 5,420,703 12.5%
Sports Core 541,109 - 541,109 1.2%
Golf Surcharge 61,187 586,986 648,173 1.5%
Self-Insurance 285,451 - 285,451 0.7%
Garage 382,014 - 382,014 0.9%
Equipment Replacement 498,189 1,011,582 1,509,770 3.5%
Total $20,708,787 $22,582,013 $43,290,800 100.0%
Change in Cash and Investments by Fund :
Balance at Balance at Year-to-Date Year-to-Date
Fund January 1, 2018 August 31, 2018 Change ($)Change (%)
General Corporate $17,679,496 $18,928,628 $1,249,132 7.1%
Hotel/Motel Tax 4,172,234 4,485,217 312,983 7.5%
Motor Fuel Tax 574,460 708,617 134,157 23.4%
Infrastructure 8,222,145 10,376,671 2,154,526 26.2%
Promenade TIF 276,164 4,447 (271,716)-98.4%
Water 5,693,109 5,420,703 (272,406)-4.8%
Sports Core 472,473 541,109 68,636 14.5%
Golf Surcharge 559,073 648,173 89,100 15.9%
Self-Insurance 45,042 285,451 240,409 533.7%
Garage 427,409 382,014 (45,395)-10.6%
Equipment Replacement 1,805,752 1,509,770 (295,981)-16.4%
$39,927,358 $43,290,800 $3,363,442 8.4%
Book Market
Value Value
Pooled Checking $202,104 $202,104
Sports Core Checking 604,497 604,497
Pooled IPTIP 19,796,667 19,796,667
Water E-Pay IPTIP 105,519 105,519
$20,708,787 $20,708,787
Pooled Investments:
Investments-Municipal Bonds $7,611,799 $7,495,886
Investments-Corporate Bonds 7,423,453 7,420,413
Government & Agency Obligations 708,635 679,867
Certificates of Deposit 6,720,000 6,660,659
Accrued Interest 118,126 118,126
Total Pooled Investments $22,582,013 $22,374,950
Total Cash and Investments $43,290,800 $43,083,737
For August, total interest revenue is $71,217 and YTD interest revenue is $485,092.
Total investment yield for the portfolio is:
Pooled
Investments Illinois Funds Total
Monthly yield 0.17%0.19%0.18%
YTD yield 1.22%1.18%1.20%
Last 12 months yield 1.76%1.54%1.66%
The weighted average yield of the current pooled investment portfolio is 2.03%.
Monthly Treasurer's Report
August 31, 2018
Monthly Treasurer's Report
August 2018
The table below lists the detail investment holdings at J.P. Morgan Securities as of 8/31/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,944 $99,605 $511
Rosemont IL GO Corp #777543UT4 02/08/16 12/1/2019 3.021%2.000%506,238 498,075 3,680
New York N Y City #64971QTX1 02/22/16 5/1/2021 2.350%2.000%201,800 196,692 1,552
Florida Hurricane #34074GDH4 03/30/16 7/1/2020 2.995%2.150%507,498 500,410 2,495
Bloomingdale Mich Pub Sch Dist #094383FS0 04/26/16 5/1/2022 2.710%2.150%509,801 490,385 4,478
Milan Mich Area Achs #598801JD1 05/26/16 5/1/2020 1.931%1.931%245,000 241,482 1,476
Indiana Bd Bk Rev Taxable #4546248F7 01/06/17 1/15/2020 2.934%1.900%258,532 254,962 969
Garland Cnty Ark Sales & Use #36609PAN3 02/06/17 11/1/2019 1.795%1.840%499,738 494,880 3,116
Anchor Bay Mich Sch Dist GO #032879TA6 02/13/17 5/1/2019 1.810%1.420%365,947 362,036 2,125
Macomb Cnty Mich Retirees #554885H63 04/11/17 11/1/2018 1.731%1.300%400,288 399,656 2,265
Lanse Creuse Mich Pub Schs #516228RL9 05/02/17 5/1/2020 2.159%2.159%100,000 99,009 717
California St GO Bonds #13063A7G3 05/08/17 10/1/2019 6.200%1.600%524,700 518,530 12,635
*Genesee Cnty Mich #371608UV0 05/31/17 10/1/2019 2.670%2.670%302,000 302,025 782
Connecticut St GO Bds 2016 #20772J3F7 06/15/17 8/15/2021 1.750%2.300%492,177 477,170 336
North Carolina Eastn Mun Pwr #65819WAL7 10/02/17 7/1/2019 2.578%1.700%503,640 499,580 2,005
Fowlerville Mich Comnty Schs #351280MS8 10/03/17 5/1/2020 2.045%1.750%502,425 493,970 3,238
Racine Cnty WI #749845UK7 12/20/17 12/1/2020 2.150%2.150%750,000 733,605 4,031
Wisconsin St Gen Fd Annual #977100CW4 01/05/18 5/1/2020 1.446%2.100%593,567 585,666 2,796
Illinois St G/O #452152HU8 04/03/18 3/1/2019 5.877%3.000%248,504 248,148 7,079
Total Municipal Bonds $7,611,799 $7,495,886 $56,287
Corporate Bonds:
American Honda Finance Corp #02665WAC5 01/25/18 10/10/2018 2.125%1.809%$1,000,328 $999,780 $8,264
JP Morgan Securities #44640QKV2 02/01/18 10/29/2018 2.082%2.082%1,494,882 1,494,747 0
Wells Fargo #94974BFQ8 04/25/18 1/15/2019 2.150%2.330%1,389,050 1,388,332 3,736
Huntington National Bank #446438RG0 07/06/18 4/1/2019 2.200%2.541%698,609 698,257 6,374
Bank of America #06051GFD6 07/06/18 4/1/2019 2.650%2.509%750,614 750,300 7,840
KeyBank #49327M2N3 07/19/18 3/8/2019 2.350%2.490%844,381 844,079 9,487
Bank of America #06051GFD6 07/30/18 4/1/2019 2.650%2.420%245,320 245,098 2,705
Morgan Stanley #61746BDM5 08/03/18 1/24/2019 2.500%2.430%1,000,270 999,820 2,431
Total Corporate Bonds $7,423,453 $7,420,413 $40,836
Government & Agency Obligations:
**Government National Mtg Assn #38379UEM4 02/29/16 2/16/2051 2.300%2.245%$708,635 $679,867 $2,015
Total Government & Agency Obligations:$708,635 $679,867 $2,015
Certificates of Deposit:
Ally Bk Midvale Utah #02006LVC4 10/29/15 10/29/2018 1.600%1.600%$245,000 $244,927 $1,312
BMW Bank #05580AFG4 09/23/16 9/24/2018 1.100%1.100%245,000 244,863 1,186
Comenity Cap Bank #20033ASB3 09/26/16 9/26/2018 1.100%1.100%245,000 244,851 34
Enerbank #29266N4E4 10/21/16 10/22/2018 1.100%1.100%245,000 244,738 977
Discover Bank #254672L71 10/26/16 10/26/2018 1.200%1.200%245,000 244,645 1,025
State Bk India NY #8562846A7 01/26/17 1/26/2022 2.250%2.250%245,000 238,647 559
Marlin Business Bk #57116ANU8 05/10/17 11/12/2019 1.600%1.600%245,000 242,403 221
American Express Fed Svgs #02587CER7 05/10/17 11/12/2019 1.700%1.700%245,000 242,611 1,284
Synchrony Bank #87164WRA8 05/26/17 5/28/2019 1.650%1.650%245,000 244,062 1,044
Umpqua Bank #90421MAG8 05/31/17 5/31/2019 1.600%1.600%245,000 243,949 991
Stone Bk Mtn View Ark #86158RAJ8 06/28/17 6/28/2019 1.600%1.600%245,000 243,694 20
TIAA FSB Jacksonville #87270LAA1 07/19/17 7/19/2019 1.600%1.600%245,000 243,481 457
Peoples United Bank #71270QQZ2 07/19/17 7/19/2019 1.650%1.650%245,000 243,586 472
Priority Bank Ozark Ark #74269KBR6 07/26/17 7/26/2019 1.600%1.600%245,000 243,410 48
American Express Centurion #02587DV96 08/15/17 8/17/2020 1.900%1.900%245,000 240,171 194
Sallie Mae #795450C86 08/16/17 8/17/2020 1.900%1.900%245,000 240,837 194
Merrick Bank South Jordan #59013JZS1 08/21/17 8/21/2020 1.800%1.800%245,000 240,318 122
Pinnacle Bank #72345SFS5 08/30/17 8/31/2020 1.800%1.800%115,000 112,753 6
Jackson County Bank #466682AP6 08/31/17 3/1/2021 1.850%1.850%245,000 238,782 0
Barclays Bank #06740KKX4 09/27/17 9/28/2020 1.950%1.950%245,000 240,720 2,050
Capital One Bank #1404205E6 10/04/17 10/4/2019 1.700%1.700%245,000 243,011 1,695
Transportation Alliance #89388CCB2 10/13/17 4/12/2019 1.600%1.600%235,000 234,295 179
Goldman Sachs Bank #38148PRK5 10/18/17 10/19/2020 1.950%1.950%245,000 240,546 1,758
FirstBank PR Santurce #33767A6M8 11/03/17 11/3/2020 2.000%2.000%245,000 240,661 364
Morgan Stanley #61747MQ53 03/22/18 3/23/2020 2.550%2.550%245,000 244,677 2,742
Investors Community Bank #46147UTT7 08/28/18 2/28/2020 2.550%2.550%245,000 244,780 35
Lakeside Bank #51210SPS0 08/30/18 3/30/2020 2.550%2.550%245,000 244,645 17
Bank United #066519GJ2 08/31/18 2/20/2028 2.500%2.500%245,000 244,598 -
Total Certificates of Deposits $6,720,000 $6,660,659 $18,987
Total J.P.Morgan Securities $22,463,888 $22,256,824 $118,126
*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
August 31, 2018
Cash & Investments by Fund - Total $43.3 million
Cash & Investments by Type - Total $43.3 million
Checking
Illinois Funds
Certificates of Deposit
Municipal Bonds
Corporate Bonds
Government & Agency Obligations
Accrued Interest
General Corporate
43.72%
Hotel/Motel Tax
10.36%Motor Fuel Tax
1.64%
Infrastructure
23.97%
Promenade TIF
0.01%
Water
12.52%
Sports Core
1.25%
Golf Surcharge
1.50%
Self-Insurance
0.66%Garage
0.88%
Equipment
Replacement
3.49%
Checking, $0.8
Illinois Funds, $19.9
Certificates of Deposit,
$6.7
Municipal Bonds, $7.6
Corporate Bonds, $7.4
Government & Agency
Obligations, $0.8
Accrued Interest, $0.1
in millions
Village of Oak Brook
Monthly Financial Report – Fund Narrative
For the Period Ending August 31, 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
x Total revenues through August 2018 are $1,343,330 hi gher than last year and $1,806,427 over
budget.
o Sales tax revenue, the General Fund’s largest revenue source, is down $72,661 from last
year and $4,542 under budget. This is due to the closure of two large taxpayers in late
2017.
o Other intergovernmental tax revenue is down $65,932 from last year, but $88,852 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 $80,437 from last year and $223,824 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,009,674 from last year and $1,180,595 over
budget. The increase is due to the receipt large building permits that have occurred to
date, including KidZania, Carvana, and LifeTime Fitness.
x Total expenditures through August 2018 are $1,274,533 higher than last year, but $1,768,250
under budget.
o Personnel expenditures are up $467,700 from last year, but $956,240 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 $364,955 from last year and $497,989
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,140,421 from last year, but $198,459 under
budget. The increase is due to the Police Department expansion project in 2018.
Hotel Tax Fund
x Total revenues through August 2018 are $90,832 higher than last year and $32,624 over budget.
o Hotel tax revenue is up $80,021 from last year, but $500 under budget. This is due to an
additional hotel in 2018 as Hyatt House opened in late 2017.
o Interest income revenue is up $19,165 from last year and $30,147 over budget. This is
due to favorable market conditions and rising interest rates.
x Total expenditures through August 2018 are $380,771 lower than last year and $443,261 under
budget.
o Operation and contract expenditures are down $19,698 from last year and $195,629
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 $365,169 from last year and $247,632 under
budget. This is due to the timing of projects scheduled.
Motor Fuel Tax Fund
x Total revenues through August 2018 are up $240 from last year and $1,827 over budget. Motor
Fuel Tax receipts are slightly under budget, but are offset by increases in interest income.
x Total expenditures through August 2018 are down $189,328 from last year and $342,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
x Total revenues through August 2018 are down $46,857 from last year, but $105,402 over
budget.
o Non-home rule sales tax revenue is down $102,081 from last year, but $26,350 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 $61,382 from last year and $79,643 over budget. This is
due to favorable market conditions and rising interest rates.
x Total expenditures through August 2018 are down $227,483 from last year and $3,640,263
under budget.
o Personnel expenditures are up $13,466 from last year, but $100,620 under budget.
Personnel is under budget due to employee turnover and an upcoming union contract
retro payment.
o Operation and contract expenditures are down $195,041 from last year and $381,817
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 $67,379 from last year and $3,114,049 under
budget. This is due to the timing of roadway improvement projects.
Promenade TIF Fund
x Total revenues through August 2018 are down $6,328 from last year and $5,313 under budget.
This is due to a decrease in real estate tax revenue from last year.
x Total expenditures through August 2018 are up $35,148 from last year and $29,313 over
budget. The increase relates to additional principal paid towards the TIF note.
Water Fund
x Total revenues through August 2018 are up $203,852 from last year and $159,024 over budget.
o Water sales revenue is up $188.517 from last year and $10,039 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.
x Total expenditures through August 2018 are up $1,422,800 from last year, but $1,882,648 under
budget.
o Operation and contract expenditures are up $68,520 from last year, but $1,331,183
under budget. The increase is due to more water being purchased from DuPage Water
Commission and a rate increase on gallons purchased. Expenditures are under budget
due to the timing of invoices paid.
o Capital outlay expenditures are up $1,384,033 from last year, but $486,858 under
budget. The increase relates to the start of the Village-wide water meter replacement
project.
Sports Core Fund
x Total revenues through August 2018 are down $140,971 from last year and $71,286 under
budget.
o Memberships are up $17,921 from last year and $13,949 over budget. Memberships
from both B&T and Golf are up in 2018 compared to last year.
o Greens Fees are down $38,925 from last year and $51,842 under budget. Rounds
played are down in 2018 due to unfavorable weather conditions.
o Rentals are up $49,381 from last year and $37,486 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 $132,202 from last year and $81,533 under budget. This
is due to the timing of soccer field rental payments and the reclassification of driving
range rental fees.
x Total expenditures through August 2018 are up $77,732 from last year, but $227,636 under
budget.
o Personnel expenditures are up $9,794 from last year and $35,231 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 $75,356 from last year and $118,266 under
budget. This is due to the timing of golf course maintenance supplies purchases.
o Operation and Contractual expenditures are up $102,890 from last year and $70,292
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 down $1,733 from last year and $158,405 under budget.
Expenses are under budget due to the general timing of projects or the cancellation of
budgeted projects.
Golf Surcharge Fund
x Total revenues through August 2018 are down $4,667 from last year and $220 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.
x No golf surcharge funds have been transferred or expended in 2018 so far.
Self Insurance Fund
x Total revenues through August 2018 are up $12,111 from last year, but $48,063 under budget.
This is due retirees moving to a new insurance plan in FY18 and a rate increase effective 7/1/18.
x Total expenditures through August 2018 are down $169,343 from last year and $336,124 under
budget. This is due to the timing of invoices paid and health claims coming in lower than
projected.
Garage Fund
x Total revenues through August 2018 are down $86,290 from last year, but $4,090 over budget.
This is due to a budgeted reduction in maintenance charges to use available net position
reserves.
x Total expenditures through August 2018 are up $21,657 from last year, but $99,141 under
budget. This is due to the delay in hiring a vacant position and a general decrease in
maintenance costs.
Equipment Replacement Fund
x Total revenues through August 2018 are down $261,077 from last year, but $36,530 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.
x Total expenditures through August 2018 are up $217,507 from last year and $81,478 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)17,768,705 $16,304,643 $1,464,062 $420,742
Main operating fund of the Village.
Hotel Fund (Major Fund)$896,624 $390,654 $505,970 $30,085
Collects and spends resources from the
3% hotel/motel tax.
Motor Fuel Tax Fund $141,947 $7,790 $134,157 ($209,880)
Collects and spends resources from the
State motor fuel tax.
Infrastructure Fund (Major Fund)$3,948,014 $1,734,072 $2,213,942 ($1,189,505)
Accounts for construction and maintenance of
roadways, drainage, and safety path systems.
Promenade TIF Fund (Major Fund)$221,507 $493,223 ($271,716)($237,090)
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,986,864 $5,442,387 $544,477 ($1,497,195)
Collects user fees for the distribution of water
and maintenance of infrastructure.
Sports Core Fund (Major Fund)$2,639,910 $2,472,899 $167,011 $10,645
Accounts for revenues and expenses relating
to administration, programs, food and beverage
operations, and golf course.
Golf Surcharge Fund $89,100 $0 $89,100 $89,320
Accounts for the collection of the $3 per round
golf surcharge.
Internal Service Funds
Self Insurance Fund $2,094,262 $1,892,316 $201,946 ($86,115)
Accounts for the Village's health insurance costs
and the related contributions from the Village,
employees, retirees, and other agencies.
Garage Fund $412,550 $431,024 ($18,474)($121,705)
Accounts for the maintenance of the Village's vehicle
fleet and the related departmental reimbursements.
Equipment Replacement Fund $305,130 $536,588 ($231,458)($186,510)
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, 2018
8/31/18 8/31/18
8/31/17 8/31/18 YTD % of 2018 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 8,259,119$ 8,186,458$ 8,191,000$ 100%12,453,000$ (72,661)$
Other Intergovernmental Tax 990,584 924,652 835,800 111%1,144,700 (65,932)
Telecommunications/Utility Tax 4,013,842 4,094,279 3,870,455 106%5,792,250 80,437
Licenses and Permits 1,631,406 2,641,080 1,460,485 181%1,784,070 1,009,674
Charges for Services 616,878 721,261 659,920 109%1,017,100 104,383
Fines and Penalties 97,702 120,277 100,300 120%150,500 22,575
Administrative Towing Fees 28,875 21,900 23,320 94%35,000 (6,975)
Interest on Investments 143,018 222,410 130,000 171%195,000 79,392
Franchise/IMF Maint. Fee 107,597 107,304 161,250 67%215,000 (293)
Miscellaneous Income 116,986 309,716 110,380 281%180,750 192,730
Total Operating Revenues 16,006,007$ 17,349,337$ 15,542,910$ 112%22,967,370$ 1,343,330$
OPERATING EXPENDITURES
Personnel 10,988,490$ 11,456,190$ 12,412,430$ 92%17,953,350$ 467,700$
Materials and Supplies 273,410 303,270 381,990 79%532,820 29,860
Operation and Contract 2,797,761 2,432,806 2,930,795 83%4,278,675 (364,955)
Other Expenditures 90,436 91,944 128,785 71%388,815 1,508
Capital Outlay 880,013 2,020,434 2,218,893 91%2,997,840 1,140,421
Total Operating Expenditures 15,030,110$ 16,304,643$ 18,072,893$ 90%26,151,500$ 1,274,533$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 975,897$ 1,044,694$ (2,529,983)$ (3,184,130)$ 68,797$
OTHER TRANSACTIONS
Transfers Out -$ -$ -$ 0%-$ -$
Interfund Loan - - - 0%- -
Reimbursements From Other Funds 411,536 419,368 475,560 88%713,360 7,832
Installment Contract Proceeds - - 2,475,165 0%2,475,165 -
Total Interfund Transactions 411,536$ 419,368$ 2,950,725$ 0%3,188,525$ 7,832$
NET FUND INCREASE (DECREASE)1,387,433$ 1,464,062$ 420,742$ 4,395$ 76,629$
Village of Oak Brook
General Fund Financial Update
For the Period Ending August 31, 2018
Total Total
Revenues Expenditures
8/31/18 Actual 17,349,337$ 16,304,643$
8/31/17 Actual 16,006,007$ 15,030,110$
% Change From Last Year 8.4%8.5%
Major Revenues Other
Intergov.Licenses &Charges for
Sales Tax Tax Telecom Tax Permits Services
8/31/18 Actual 8,186,458$ 924,652$ 4,094,279$ 2,641,080$ 721,261$
8/31/17 Actual $ 8,259,119 $ 990,584 $ 4,013,842 $ 1,631,406 $ 616,878
% Change From Last Year -0.9%-6.7%2.0%61.9%16.9%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
8/31/18 Actual 11,456,190$ 303,270$ 2,432,806$ 91,944$ 2,020,434$
8/31/17 Actual 10,988,490$ 273,410$ 2,797,761$ 90,436$ 880,013$
% Change From Last Year 4.3%10.9%-13.0%1.7%129.6%
Five Year Trend
Expenditures by Department
8/31/17 8/31/18 8/31/18 8/31/18 2018 Difference Five
YTD YTD YTD % of Annual Prior Year
Department Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 1,822,516$ 1,446,106$ 1,835,325$ 78.8%2,673,305$ (376,410)$
Financial Services 562,119 575,714 638,100 90.2%1,117,875 13,595
Public Works 464,520 435,934 660,200 66.0%993,820 (28,586)
Engineering & Capital Projects 603,770 1,917,304 1,934,148 99.1%2,732,665 1,313,534
Library 611,179 580,082 617,530 93.9%889,845 (31,097)
Police 5,533,075 5,712,392 6,047,255 94.5%8,705,350 179,317
Fire 4,784,878 4,998,202 5,656,465 88.4%8,043,215 213,324
Development Services 648,053 638,909 683,870 93.4%995,425 (9,144)
Total Expenditures 15,030,110$ 16,304,643$ 18,072,893$ 90.2%26,151,500$ 1,274,533$
Five Year Trend
For the Period Ending August 31, 2018
General Fund - Five Year Trend
Village of Oak Brook
Revenues Expenditures
8/31/18 8/31/18
8/31/17 8/31/18 YTD % of 2018 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Hotel Tax 763,479$ 843,500$ 844,000$ 100%1,340,000$ 80,021$
Interest 30,982 50,147 20,000 251%30,000 19,165
Miscellaneous 11,331 2,977 - N/A - (8,354)
Total Operating Revenues 805,792$ 896,624$ 864,000$ 104%1,370,000$ 90,832$
EXPENDITURES
Operation and Contract 271,629$ 251,931$ 447,560$ 56%646,515$ (19,698)$
Other Expenditures 62,264 66,360 66,360 100%99,550 4,096
Capital Outlay 437,532 72,363 319,995 23%640,000 (365,169)
Total Expenditures 771,425$ 390,654$ 833,915$ 46.8%1,386,065$ (380,771)$
NET FUND INCREASE (DECREASE)34,367$ 505,970$ 30,085$ (16,065)$ 471,603$
Note - Expenditures are recorded in program 171.
Village of Oak Brook
Hotel Tax Fund Financial Update
For the Period Ending August 31, 2018
Total Total
Revenues Expenditures
8/31/18 Actual $ 896,624 390,654$
8/31/17 Actual $ 805,792 771,425$
% Change From Last Year 11.3%-49.4%
Major Revenues
Grants Hotel Tax Interest Miscellaneous
8/31/18 Actual $ - $ 843,500 $ 50,147 $ 2,977
8/31/17 Actual $ - $ 763,479 $ 30,982 $ 11,331
% Change From Last Year 0.0%10.5%61.9%-73.7%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures Capital Outlay
8/31/18 Actual 251,931$ 66,360$ 72,363$
8/31/17 Actual 271,629$ 62,264$ 437,532$
% Change From Last Year -7.3%6.6%-83.5%
Five Year Trend
Village of Oak Brook
Hotel Tax Fund - Major Sources Five Year Trend
For the Period Ending August 31, 2018
Five Year Trend
Revenues Expenditures
8/31/18 8/31/18
8/31/17 8/31/18 YTD % of 2018 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 3,811,181$ 3,709,100$ 3,682,750$ 101%5,563,000$ (102,081)$
Grants 3,142 - - 0%- (3,142)
Interest 46,261 107,643 28,000 384%42,000 61,382
Miscellaneous 5,745 2,729 3,320 82%5,000 (3,016)
Total Operating Revenues 3,866,329$ 3,819,472$ 3,714,070$ 103%5,610,000$ (46,857)$
OPERATING EXPENDITURES
Personnel 810,029$ 823,495$ 924,115$ 89%1,365,445$ 13,466$
Materials and Supplies 71,896 91,790 135,560 68%182,955 19,894
Operation and Contract 836,639 641,598 1,023,415 63%1,484,755 (195,041)
Other Expenditures 108,336 109,912 109,920 100%164,865 1,576
Capital Outlay 134,655 67,276 3,181,325 2%5,625,620 (67,379)
Total Operating Expenditures 1,961,555$ 1,734,072$ 5,374,335$ 32%8,823,640$ (227,483)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 1,904,774$ 2,085,400$ (1,660,265)$ -126%(3,213,640)$ 180,626$
INTERFUND TRANSACTIONS
Transfers In 179,074$ 7,790$ 350,000$ 2%500,000$ (171,284)$
Reimbursements From Other Funds 117,760 120,752 120,760 100%181,130 2,992
Total Interfund Transactions 296,834$ 128,542$ 470,760$ 27%681,130$ (168,292)$
NET FUND INCREASE (DECREASE)2,201,608$ 2,213,942$ (1,189,505)$ (2,532,510)$ 12,334$
Village of Oak Brook
Infrastructure Fund Financial Update
For the Period Ending August 31, 2018
Total Total
Revenues Expenditures
8/31/18 Actual $ 3,819,472 1,734,072$
8/31/17 Actual $ 3,866,329 1,961,555$
% Change From Last Year -1.2%-11.6%
Major Revenues
Sales Tax Grants Interest Miscellaneous Reimbursements
8/31/18 Actual $ 3,709,100 $ - $ 107,643 $ 2,729 $ 120,752
8/31/17 Actual $ 3,811,181 $ 3,142 $ 46,261 $ 5,745 $ 117,760
% Change From Last Year -2.7%-100.0%132.7%-52.5%2.5%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
8/31/18 Actual 823,495$ 91,790$ 641,598$ 109,912$ 67,276$
8/31/17 Actual 810,029$ 71,896$ 836,639$ 108,336$ 134,655$
% Change From Last Year 1.7%27.7%-23.3%1.5%-50.0%
Five Year Trend
Expenditures by Department
8/31/17 8/31/18 8/31/18 8/31/18 2018 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 115,662$ 93,863$ 118,210$ 79.4%178,530$ (21,799)$
Public Works 1,561,067 1,365,578 1,783,980 76.5%2,592,335 (195,489)
Engineering & Capital Projects 284,826 274,631 3,472,145 7.9%6,052,775 (10,195)
Total Expenditures 1,961,555$ 1,734,072$ 5,374,335$ 32.3%8,823,640$ (227,483)$
Five Year Trend
Village of Oak Brook
Infrastructure Fund - Major Sources Five Year Trend
For the Period Ending August 31, 2018
Revenues Expenditures
8/31/18 8/31/18
8/31/17 8/31/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 192,509 186,562 192,500 97%385,000 (5,947)
Interest 249 776 170 456%250 527
Total Operating Revenues 227,835$ 221,507$ 226,820$ 98%487,750$ (6,328)$
EXPENDITURES
Operation and Contract 3,695$ 3,403$ 4,090$ 83%4,090$ (292)$
Other Expenditures 454,380 489,820 459,820 107%459,820 35,440
Total Expenditures 458,075$ 493,223$ 463,910$ 106%463,910$ 35,148$
NET FUND INCREASE (DECREASE)(230,240)$ (271,716)$ (237,090)$ 23,840$ (41,476)$
Note - Expenditures are recorded in program 283.
Village of Oak Brook
Promenade TIF Fund Financial Update
For the Period Ending August 31, 2018
Total Total
Revenues Expenditures
8/31/18 Actual $ 221,507 493,223$
8/31/17 Actual $ 227,835 458,075$
% Change From Last Year -2.8%7.7%
Major Revenues Real Estate
Sales Tax Tax Interest
8/31/18 Actual $ 34,169 $ 186,562 $ 776
8/31/17 Actual $ 35,077 $ 192,509 $ 249
% Change From Last Year -2.6%-3.1%211.6%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures
8/31/18 Actual 3,403$ 489,820$
8/31/17 Actual 3,695$ 454,380$
% Change From Last Year -7.9%7.8%
Five Year Trend
Village of Oak Brook
Promenade TIF Fund - Major Sources Five Year Trend
For the Period Ending August 31, 2018
Five Year Trend
Revenues Expenditures
8/31/18 8/31/18
8/31/17 8/31/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,339 600 1,320 45%2,000 (739)
Building/Inspection Fees 5,314 5,063 3,320 153%5,000 (251)
Water Sales 5,516,522 5,705,039 5,695,000 100%9,730,425 188,517
Unmetered Sales 25,003 21,736 20,000 109%30,000 (3,267)
Water Connection Fees 128,570 109,284 33,200 329%50,000 (19,286)
Fire Service Charge - - 3,320 0%5,000 -
Meter Charges 14,246 8,334 16,680 50%25,000 (5,912)
Special Services 15,286 16,394 15,000 109%30,000 1,108
Interest on Investments 22,095 61,169 6,680 916%10,000 39,074
Miscellaneous 51,251 59,245 33,320 178%50,000 7,994
Total Operating Revenues 5,783,012$ 5,986,864$ 5,827,840$ 103%9,937,425$ 203,852$
EXPENDITURES
Personnel 548,421$ 506,463$ 563,240$ 90%817,490$ (41,958)$
Materials and Supplies 34,704 44,533 52,355 85%76,860 9,829
Operation and Contract 3,119,487 3,188,007 4,519,190 71%6,780,015 68,520
Other Expenditures 267,736 270,112 270,120 100%405,170 2,376
Capital Outlay 49,239 1,433,272 1,920,130 75%2,710,220 1,384,033
Total Expenditures 4,019,587$ 5,442,387$ 7,325,035$ 74%10,789,755$ 1,422,800$
NET FUND INCREASE (DECREASE)1,763,425$ 544,477$ (1,497,195)$ (852,330)$ (1,218,948)$
Village of Oak Brook
Water Fund Financial Update
For the Period Ending August 31, 2018
Total Total
Revenues Expenditures
8/31/18 Actual $ 5,986,864 5,442,387$
8/31/17 Actual $ 5,783,012 4,019,587$
% Change From Last Year 3.5%35.4%
Unmetered Water
Water Sales Sales Connection Fees Meter Charges Miscellaneous
8/31/18 Actual $ 5,705,039 $ 21,736 $ 109,284 $ 8,334 $ 59,245
8/31/17 Actual $ 5,516,522 $ 25,003 $ 128,570 $ 14,246 $ 51,251
% Change From Last Year 3.4%-13.1%-15.0%-41.5%15.6%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
8/31/18 Actual 506,463$ 44,533$ 3,188,007$ 270,112$ 1,433,272$
8/31/17 Actual 548,421$ 34,704$ 3,119,487$ 267,736$ 49,239$
% Change From Last Year -7.7%28.3%2.2%0.9%2810.8%
Five Year Trend
Expenditures by Department
8/31/17 8/31/18 8/31/18 8/31/18 2018 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Public Works 3,978,546$ 3,976,305$ 5,468,235$ 72.7%8,124,535$ (2,241)$
Engineering & Capital Projects 41,041 1,466,082 1,856,800 79.0%2,665,220 1,425,041
Total Expenditures 4,019,587$ 5,442,387$ 7,325,035$ 74.3%10,789,755$ 1,422,800$
Five Year Trend
Village of Oak Brook
Water Fund - Major Sources Five Year Trend
For the Period Ending August 31, 2018
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Sports Core Fund Consolidated Presentation
For the Period Ending August 31, 2018
8/31/18 8/31/18
8/31/18 YTD % of 2018 8/31/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,475$ 103%414,875$ 415,503$ 17,921$
Greens Fees - - 679,358 679,358 731,200 93%975,000 718,283 (38,925)
Pro Shop Sales - - 154,554 154,554 150,890 102%200,000 143,288 11,266
Golf Lessons - - 22,512 22,512 39,000 58%40,000 36,977 (14,465)
Driving Range Fees - - 192,945 192,945 210,500 92%235,000 207,846 (14,901)
Rentals - - 326,761 326,761 289,275 113%451,000 277,380 49,381
Programs/User Fees 170,567 - - 170,567 252,100 68%300,700 302,769 (132,202)
Food Sales - 123,851 - 123,851 105,745 117%145,500 138,162 (14,311)
Beverage Sales - 183,962 - 183,962 177,115 104%236,000 207,862 (23,900)
Other Revenue 189,572 135,779 5,289 330,640 314,560 105%380,650 311,475 19,165
Total Direct Revenues 589,513$ 443,592$ 1,585,469$ 2,618,574$ 2,689,860$ 97%3,378,725$ 2,759,545$ (140,971)$
DIRECT EXPENDITURES
Personnel 130,268$ 178,715$ 760,123$ 1,069,106$ 1,033,875$ 103%1,497,200$ 1,059,312$ 9,794$
Materials & Supplies 16,696 130,251 225,897 372,844 491,110 76%615,885 448,200 (75,356)
Operational & Contractual 564,721 64,025 162,811 791,557 721,265 110%961,510 688,667 102,890
Other - - 42,137 42,137 98,625 43%(44,275) - 42,137
Capital 91,588 9,988 95,679 197,255 355,660 55%365,660 198,988 (1,733)
Total Direct Expenditures 803,273$ 382,979$ 1,286,647$ 2,472,899$ 2,700,535$ 92%3,395,980$ 2,395,167$ 77,732$
Direct Revenues Over (Under) Expenditures (213,760)$ 60,613$ 298,822$ 145,675$ (10,675)$ -1365%(17,255)$ 364,378$ (218,703)$
B&T Administration Overhead Allocation*96,090$ (96,090)$ -$ -$ -$ 0%-$ -$ -$
Operating Revenues Over (Under) Expenditures (117,670)$ (35,477)$ 298,822$ 145,675$ (10,675)$ -1365%(17,255)$ 364,378$ (218,703)$
Interfund Loan**-$ -$ -$ -$ -$ 0%-$ -$ -$
Transfer From General Fund - - - - - 0%- - -
Reimbursement From Infrastructure Fund 16,000 - - 16,000 16,000 100%24,000 16,000 -
Reimbursement From Water Fund 5,336 - - 5,336 5,320 100%8,000 5,336 -
Transfer From Golf Surcharge Fund - - - - - 0%- - -
Adjusted Operating Revenues Over (Under) Expenditures (96,334)$ (35,477)$ 298,822$ 167,011$ 10,645$ 14,745$ 385,714$ (218,703)$
*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
8/31/18 Actual $ 2,618,574 2,472,899$
8/31/17 Actual $ 2,759,545 2,395,167$
% Change From Last Year -5.1%3.2%
Driving Program/
Memberships Greens Fees Range Fees Rentals User Fees
8/31/18 Actual $ 433,424 $ 679,358 $ 192,945 $ 326,761 $ 170,567
8/31/17 Actual $ 415,503 $ 718,283 $ 207,846 $ 277,380 $ 302,769
% Change From Last Year 4.3%-5.4%-7.2%17.8%-43.7%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
8/31/18 Actual 1,069,106$ 372,844$ 791,557$ 42,137$ 197,255$
8/31/17 Actual 1,059,312$ 448,200$ 688,667$ -$ 198,988$
% Change From Last Year 0.9%-16.8%14.9%N/A -0.9%
Five Year Trend
Revenues by Department 8/31/17 8/31/18 8/31/18 8/31/18 2018 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Programs 718,631$ 589,513$ 646,495$ 91.2%712,075$ (129,118)$
Food & Beverage 463,655 443,592 127,800 347.1%569,000 (17,663)
Golf Club 1,577,259 1,585,469 567,997 279.1%2,097,650 8,210
Total Revenues 2,759,545$ 2,618,574$ 1,342,292$ 195.1%3,378,725$ (138,571)$
Expenditures by Department 8/31/17 8/31/18 8/31/18 % of 2018 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Programs 679,213$ 803,273$ 344,363$ 233.3%1,058,430$ 124,060$
Food & Beverage 482,036 382,979 281,968 135.8%514,980 (99,057)
Golf Club 1,233,918 1,286,647 778,751 165.2%1,822,570 52,729
Total Expenditures 2,395,167$ 2,472,899$ 1,405,082$ 176.0%3,395,980$ 77,732$
Five Year Trend
Village of Oak Brook
Sports Core Fund - Major Sources Five Year Trend
For the Period Ending August 31, 2018
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Club Recreation Programs
For the Period Ending August 31, 2018 8/31/18 8/31/18
8/31/18 YTD % of 2018 8/31/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$ 227,975$ 101%223,375$ 223,140$ 6,234$
Programs/User Fees (1,612) 19,320 28,099 - 124,760 170,567 252,100 68%300,700 302,769 (132,202)
Other Revenue 629 2,621 404 - 185,918 189,572 188,910 100%188,000 192,722 (3,150)
Total Revenue (983)$ 230,042$ 49,776$ -$ 310,678$ 589,513$ 668,985$ 88%712,075$ 718,631$ (129,118)$
Expenditures:
Personnel 81,833$ 20,179$ 23,061$ -$ 5,195$ 130,268$ 152,115$ 86%208,040$ 167,912$ (37,644)$
Materials & Supplies 5,136 9,485 2,075 - - 16,696 24,865 67%28,280 34,138 (17,442)
Operational & Contractual 51,149 278,789 40,195 5,000 189,588 564,721 469,860 120%586,160 425,642 139,079
Other - - - - - - 37,460 0%56,200 - -
Capital 38,845 52,154 - - 589 91,588 106,000 86%179,750 51,521 40,067
Total Expenditures 176,963$ 360,607$ 65,331$ 5,000$ 195,372$ 803,273$ 790,300$ 102%1,058,430$ 679,213$ 124,060$
Direct Revenues Over (Under) Expenditures (177,946)$ (130,565)$ (15,555)$ (5,000)$ 115,306$ (213,760)$ (121,315)$ 176%(346,355)$ 39,418$ (253,178)$
B&T Administration Overhead Allocation*177,946$ (64,061)$ (17,795)$ -$ -$ 96,090$ 136,980$ 70%207,995$ 114,564$ (18,474)$
Revenues Over (Under) Expenditures -$ (194,626)$ (33,350)$ (5,000)$ 115,306$ (117,670)$ 15,665$ -751%(138,360)$ 153,982$ (271,652)$
Interfund Loan**-$ -$ -$ -$ -$ -$ -$ 0%-$ -$ -$
Transfer From General Fund - - - - - - - 0%- - -
Reimbursement From Infrastructure Fund 16,000 - - - - 16,000 16,000 100%24,000 16,000 -
Reimbursement From Water Fund 5,336 - - - - 5,336 5,320 100%8,000 5,336 -
Adjusted Revenues Over (Under) Expenditures 21,336$ (194,626)$ (33,350)$ (5,000)$ 115,306$ (96,334)$ 36,985$ (106,360)$ 175,318$ (271,652)$
*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 August 31, 2018
8/31/18 8/31/18
821 822 823 8/31/18 YTD % of 2018 8/31/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,368 89,483 123,851 105,745 117%145,500 138,162 (14,311)
Beverage Sales - 18,246 165,716 183,962 177,115 104%236,000 207,862 (23,900)
Other Revenue 135,779 - - 135,779 120,500 113%187,500 115,231 20,548
Total Revenue 135,779$ 52,614$ 255,199$ 443,592$ 403,360$ 110%569,000$ 463,655$ (17,663)$
Expenditures:
Personnel 76,076$ 23,102$ 79,537$ 178,715$ 136,710$ 131%199,505$ 160,945$ 17,770$
Materials & Supplies 9,372 15,731 105,148 130,251 141,035 92%182,150 164,058 (33,807)
Operational & Contractual 59,447 752 3,826 64,025 75,555 85%133,325 64,260 (235)
Capital 9,988 - - 9,988 73,750 14%- 92,773 (82,785)
Total Expenditures 154,883$ 39,585$ 188,511$ 382,979$ 427,050$ 90%514,980$ 482,036$ (99,057)$
Direct Revenues Over (Under) Expenditures (19,104)$ 13,029$ 66,688$ 60,613$ (23,690)$ -256%54,020$ (18,381)$ 78,994$
B&T Administration Overhead Allocation*(88,972)$ (7,118)$ -$ (96,090)$ (136,980)$ 70%(175,995)$ (114,564)$ 18,474$
Revenues Over (Under) Expenditures (108,076)$ 5,911$ 66,688$ (35,477)$ (160,670)$ 22%(121,975)$ (132,945)$ 97,468$
Transfer From General Fund -$ -$ -$ -$ -$ 0%-$ -$ -$
Adjusted Revenues Over (Under) Expenditures (108,076)$ 5,911$ 66,688$ (35,477)$ (160,670)$ (121,975)$ (132,945)$ 97,468$
*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, 2018
8/31/18 8/31/18
831 832 833 834 8/31/18 YTD % of 2018 8/31/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 679,358 - - - 679,358 731,200 93%975,000 718,283 (38,925)
Pro Shop Sales 154,554 - - - 154,554 150,890 102%200,000 143,288 11,266
Golf Lessons - 22,512 - - 22,512 39,000 58%40,000 36,977 (14,465)
Driving Range Fees - 192,945 - - 192,945 210,500 92%235,000 207,846 (14,901)
Rentals 2,505 70,000 254,256 - 326,761 289,275 113%451,000 277,380 49,381
Other Revenue 5,289 - - - 5,289 5,150 103%5,150 3,522 1,767
Total Revenue 1,045,756$ 285,457$ 254,256$ -$ 1,585,469$ 1,617,515$ 98%2,097,650$ 1,577,259$ 8,210$
Expenditures:
Personnel 329,085$ 18,684$ 39,917$ 372,437$ 760,123$ 745,050$ 102%1,089,655$ 730,455$ 29,668$
Materials & Supplies 100,409 7,667 270 117,551 225,897 325,210 69%405,455 250,004 (24,107)
Operational & Contractual 122,427 858 246 39,280 162,811 175,850 93%242,025 198,765 (35,954)
Other - - 42,137 - 42,137 61,165 69%(100,475) - 42,137
Capital 24,765 - 40,922 29,992 95,679 175,910 54%185,910 54,694 40,985
Total Expenditures 576,686$ 27,209$ 123,492$ 559,260$ 1,286,647$ 1,483,185$ 87%1,822,570$ 1,233,918$ 52,729$
Direct Revenues Over (Under) Expenditures 469,070$ 258,248$ 130,764$ (559,260)$ 298,822$ 134,330$ 222%275,080$ 343,341$ (44,519)$
Transfer from General Fund -$ -$ -$ -$ -$ -$ 0%-$ -$ -$
Adjusted Revenues Over (Under) Expenditures 469,070$ 258,248$ 130,764$ (559,260)$ 298,822$ 134,330$ 275,080$ 343,341$ (44,519)$