10 - October 2018 Monthly Financial ReportVILLAGE
OAK BROOK
OF
MONTHLY FINANCIAL REPORTS
OCTOBER 2018
ITEM 6.D
Total
Cash and Cash Pooled Cash and
Fund Equivalents Investments Investments % By Fund
General Corporate $6,340,919 $12,147,357 $18,488,276 42.0%
Hotel/Motel Tax 2,131,725 2,539,096 4,670,821 10.6%
Motor Fuel Tax 562,044 180,658 742,702 1.7%
Infrastructure 6,780,714 3,494,174 10,274,888 23.3%
Promenade TIF 224,418 - 224,418 0.5%
Water 4,892,093 1,089,549 5,981,642 13.6%
Sports Core 556,694 - 556,694 1.3%
Golf Surcharge 121,877 550,991 672,868 1.5%
Self-Insurance 475,915 - 475,915 1.1%
Garage 395,053 - 395,053 0.9%
Equipment Replacement 518,401 1,009,218 1,527,619 3.5%
Total $22,999,853 $21,011,042 $44,010,895 100.0%
Change in Cash and Investments by Fund :
Balance at Balance at Year-to-Date Year-to-Date
Fund January 1, 2018 October 31, 2018 Change ($)Change (%)
General Corporate $17,679,496 $18,488,276 $808,779 4.6%
Hotel/Motel Tax 4,172,234 4,670,821 498,588 12.0%
Motor Fuel Tax 574,460 742,702 168,242 29.3%
Infrastructure 8,222,145 10,274,888 2,052,743 25.0%
Promenade TIF 276,164 224,418 (51,746)-18.7%
Water 5,693,109 5,981,642 288,532 5.1%
Sports Core 472,473 556,694 84,221 17.8%
Golf Surcharge 559,073 672,868 113,795 20.4%
Self-Insurance 45,042 475,915 430,873 956.6%
Garage 427,409 395,053 (32,356)-7.6%
Equipment Replacement 1,805,752 1,527,619 (278,133)-15.4%
$39,927,358 $44,010,895 $4,083,537 10.2%
Book Market
Value Value
Pooled Checking $2,321,528 $2,321,528
Sports Core Checking 643,362 643,362
Pooled IPTIP 19,890,118 19,890,118
Water E-Pay IPTIP 144,845 144,845
$22,999,853 $22,999,853
Pooled Investments:
Investments-Municipal Bonds $7,560,017 $7,436,559
Investments-Corporate Bonds 6,414,987 6,405,065
Government & Agency Obligations 699,092 667,712
Certificates of Deposit 6,230,000 6,165,572
Accrued Interest 106,946 106,946
Total Pooled Investments $21,011,042 $20,781,854
Total Cash and Investments $44,010,895 $43,781,707
For October, total interest revenue is $77,179 and YTD interest revenue is $634,113.
Total investment yield for the portfolio is:
Pooled
Investments Illinois Funds Total
Monthly yield 0.18%0.20%0.19%
YTD yield 1.57%1.53%1.55%
Last 12 months yield 1.84%1.71%1.78%
The weighted average yield of the current pooled investment portfolio is 2.18%.
Monthly Treasurer's Report
October 31, 2018
Monthly Treasurer's Report
October 2018
The table below lists the detail investment holdings at J.P. Morgan Securities as of 10/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 06/01/19 2.050%2.123%$99,957 $99,595 $852
Rosemont IL GO Corp #777543UT4 02/08/16 12/01/19 3.021%2.000%505,407 497,415 6,198
New York N Y City #64971QTX1 02/22/16 05/01/21 2.350%2.000%201,690 195,836 2,336
Florida Hurricane #34074GDH4 03/30/16 07/01/20 2.995%2.150%506,820 498,405 4,991
Bloomingdale Mich Pub Sch Dist #094383FS0 04/26/16 05/01/22 2.710%2.150%509,369 487,370 6,736
Milan Mich Area Achs #598801JD1 05/26/16 05/01/20 1.931%1.931%245,000 241,149 2,265
Indiana Bd Bk Rev Taxable #4546248F7 01/06/17 01/15/20 2.934%1.900%258,103 254,434 2,216
Garland Cnty Ark Sales & Use #36609PAN3 02/06/17 11/01/19 1.795%1.840%499,775 494,755 4,612
Anchor Bay Mich Sch Dist GO #032879TA6 02/13/17 05/01/19 1.810%1.420%365,712 363,387 3,226
Macomb Cnty Mich Retirees #554885H63 04/11/17 11/01/18 1.731%1.300%400,001 400,000 3,419
Lanse Creuse Mich Pub Schs #516228RL9 05/02/17 05/01/20 2.159%2.159%100,000 98,846 1,077
California St GO Bonds #13063A7G3 05/08/17 10/01/19 6.200%1.600%520,930 515,100 2,301
*Genesee Cnty Mich #371608UV0 05/31/17 10/01/19 2.681%2.681%258,000 258,024 669
Connecticut St GO Bds 2016 #20772J3F7 06/15/17 08/15/21 1.750%2.300%492,605 476,625 1,794
North Carolina Eastn Mun Pwr #65819WAL7 10/02/17 07/01/19 2.578%1.700%502,918 498,900 4,153
Fowlerville Mich Comnty Schs #351280MS8 10/03/17 05/01/20 2.045%1.750%502,186 493,185 4,942
Racine Cnty WI #749845UK7 12/20/17 12/01/20 2.150%2.150%750,000 731,520 6,719
Wisconsin St Gen Fd Annual #977100CW4 01/05/18 05/01/20 1.446%2.100%594,199 584,796 4,242
Illinois St G/O #452152HU8 04/03/18 03/01/19 5.877%3.000%247,345 247,217 2,280
Total Municipal Bonds $7,560,017 $7,436,559 $65,028
Corporate Bonds:
Wells Fargo #94974BFQ8 04/25/18 01/15/19 2.150%2.330%$1,389,464 $1,388,457 $8,716
Huntington National Bank #446438RG0 07/06/18 04/01/19 2.200%2.541%699,001 698,271 1,241
Bank of America #06051GFD6 07/06/18 04/01/19 2.650%2.509%750,440 749,453 1,215
KeyBank #49327M2N3 07/19/18 03/08/19 2.350%2.490%844,575 843,623 2,868
Bank of America #06051GFD6 07/30/18 04/01/19 2.650%2.420%245,227 244,821 541
Morgan Stanley #61746BDM5 08/03/18 01/24/19 2.500%2.430%1,000,154 999,360 6,597
Goldman Sachs #38141GVP9 09/26/18 09/15/20 2.750%3.180%496,116 493,990 1,719
Fifth Third #31677QBH1 10/11/18 09/27/19 1.625%2.750%990,010 987,090 1,535
Total Corporate Bonds $6,414,987 $6,405,065 $24,432
Government & Agency Obligations:
**Government National Mtg Assn #38379UEM4 02/29/16 02/16/51 2.300%2.245%$699,092 $667,712 $2,047
Total Government & Agency Obligations:$699,092 $667,712 $2,047
Certificates of Deposit:
State Bk India NY #8562846A7 01/26/17 01/26/22 2.250%2.250%$245,000 $237,672 $1,477
Marlin Business Bk #57116ANU8 05/10/17 11/12/19 1.600%1.600%245,000 242,425 219
American Express Fed Svgs #02587CER7 05/10/17 11/12/19 1.700%1.700%245,000 242,675 1,978
Synchrony Bank #87164WRA8 05/26/17 05/28/19 1.650%1.650%245,000 244,003 1,718
Umpqua Bank #90421MAG8 05/31/17 05/31/19 1.600%1.600%245,000 243,917 1,644
Stone Bk Mtn View Ark #86158RAJ8 06/28/17 06/28/19 1.600%1.600%245,000 243,726 18
TIAA FSB Jacksonville #87270LAA1 07/19/17 07/19/19 1.600%1.600%245,000 243,579 1,111
Peoples United Bank #71270QQZ2 07/19/17 07/19/19 1.650%1.650%245,000 243,665 1,145
Priority Bank Ozark Ark #74269KBR6 07/26/17 07/26/19 1.600%1.600%245,000 243,530 46
American Express Centurion #02587DV96 08/15/17 08/17/20 1.900%1.900%245,000 239,990 970
Sallie Mae #795450C86 08/16/17 08/17/20 1.900%1.900%245,000 240,492 970
Merrick Bank South Jordan #59013JZS1 08/21/17 08/21/20 1.800%1.800%245,000 240,007 120
Pinnacle Bank #72345SFS5 08/30/17 08/31/20 1.800%1.800%115,000 112,601 5
Jackson County Bank #466682AP6 08/31/17 03/01/21 1.850%1.850%245,000 238,191 755
Barclays Bank #06740KKX4 09/27/17 09/28/20 1.950%1.950%245,000 240,242 438
Capital One Bank #1404205E6 10/04/17 10/04/19 1.700%1.700%245,000 243,067 301
Transportation Alliance #89388CCB2 10/13/17 04/12/19 1.600%1.600%235,000 234,255 178
Goldman Sachs Bank #38148PRK5 10/18/17 10/19/20 1.950%1.950%245,000 239,982 159
FirstBank PR Santurce #33767A6M8 11/03/17 11/03/20 2.000%2.000%245,000 240,031 362
Morgan Stanley #61747MQ53 03/22/18 03/23/20 2.550%2.550%245,000 244,214 634
Investors Community Bank #46147UTT7 08/28/18 02/28/20 2.550%2.550%245,000 244,339 32
Lakeside Bank #51210SPS0 08/30/18 03/30/20 2.550%2.550%245,000 244,177 15
Bank United #066519GJ2 08/31/18 02/20/20 2.500%2.500%245,000 244,174 1,021
Compass Bank #20451PVW3 10/26/18 10/26/20 3.000%3.000%245,000 244,833 82
UBS Bank #90348JFH8 10/30/18 10/29/20 3.050%3.050%245,000 245,054 21
Citibank #17294XJP2 10/31/18 10/31/20 3.000%3.000%245,000 244,731 20
Total Certificates of Deposits $6,230,000 $6,165,572 $15,439
Total J.P.Morgan Securities $20,904,096 $20,674,908 $106,946
*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
October 31, 2018
Cash & Investments by Fund - Total $44.0 million
Cash & Investments by Type - Total $44.0 million
Checking
Illinois Funds
Certificates of Deposit
Municipal Bonds
Corporate Bonds
Government & Agency Obligations
Accrued Interest
General Corporate
42.01%
Hotel/Motel Tax
10.61%Motor Fuel Tax
1.69%
Infrastructure
23.35%
Promenade TIF
0.51%
Water
13.59%
Sports Core
1.26%
Golf Surcharge
1.53%
Self-Insurance
1.08%Garage
0.90%
Equipment
Replacement
3.47%
Checking, $3.0
Illinois Funds, $20.0
Certificates of Deposit,
$6.2
Municipal Bonds, $7.6
Corporate Bonds, $6.4
Government & Agency
Obligations, $0.7
Accrued Interest, $0.1
in millions
Village of Oak Brook
Monthly Financial Report – Fund Narrative
For the Period Ending October 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 October 2018 are $1,439,723 higher than last year and $2,231,312 over
budget.
o Sales tax revenue, the General Fund’s largest revenue source, is down $99,590 from last
year and $37,130 under budget. This is due to the closure of two large taxpayers in late
2017.
o Other intergovernmental tax revenue is down $65,432 from last year, but $112,808 over
budget. Revenue is down from last year due to extra one-time Income Tax payments
from the State in 2017. Revenue from Income Tax, Replacement Tax, and Use Tax has
been higher 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 $110,533 from last year and $290,011
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,032,613 from last year and $1,428,989 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 October 2018 are $2,037,925 higher than last year, but $1,399,744
under budget.
o Personnel expenditures are up $971,738 from last year, but $712,704 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 $310,201 from last year and $586,447
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,623,553 from last year and $14,419 over budget.
The increase is due to the Police Department expansion project in 2018.
Hotel Tax Fund
x Total revenues through October 2018 are $62,008 higher than last year and $59,187 over
budget.
o Hotel tax revenue is up $75,339 from last year and $13,036 over budget. This is due to
an additional hotel in 2018 as Hyatt House opened in late 2017.
o Interest income revenue is up $25,564 from last year and $40,951 over budget. This is
due to favorable market conditions and rising interest rates.
x Total expenditures through October 2018 are $841,049 lower than last year and $675,714 under
budget.
o Operation and contract expenditures are up $25,425 from last year, but $148,712 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 $871,594 from last year and $527,002 under
budget. This is due to the timing of projects scheduled.
Motor Fuel Tax Fund
x Total revenues through October 2018 are down $36 from last year, but $882 over budget.
Motor Fuel Tax receipts are slightly under budget, but are offset by increases in interest income.
x Total expenditures through October 2018 are down $381,814 from 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
x Total revenues through October 2018 are down $30,964 from last year, but $132,722 over
budget.
o Non-home rule sales tax revenue is down $105,402 from last year, but $26,067 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 $80,596 from last year and $108,076 over budget. This is
due to favorable market conditions and rising interest rates.
x Total expenditures through October 2018 are up $54,828 from last year, but $4,266,011 under
budget.
o Personnel expenditures are up $40,868 from last year, but $111,586 under budget.
Personnel is under budget due to employee turnover.
o Operation and contract expenditures are down $237,504 from last year and $299,934
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 up $219,749 from last year, but $3,812,413 under
budget. This is due to the timing of roadway improvement projects.
Promenade TIF Fund
x Total revenues through October 2018 are down $9,774 from last year and $11,858 under
budget. This is due to a decrease in real estate tax revenue from last year.
x Total expenditures through October 2018 are up $35,060 from last year and $29,488 over
budget. The increase relates to additional principal paid towards the TIF note.
Water Fund
x Total revenues through October 2018 are up $213,091 from last year $148,268 over budget.
o Water sales revenue is up $232,998 from last year, but $23,153 under budget. The
increase from last year is due to a 7% rate increase effective 1/1/18. Water gallons sold
has also been slightly less than projected so far this year.
x Total expenditures through October 2018 are up $1,772,626 from last year, but $1,810,340
under budget.
o Operation and contract expenditures are down $75,394 from last year and $1,352,121
under budget. Expenditures are under budget due to the timing of invoices paid.
o Capital outlay expenditures are up $1,879,820 from last year, but $376,729 under
budget. The increase relates to the start of the Village-wide water meter replacement
project.
Sports Core Fund
x Total revenues through October 2018 are down $150,649 from last year and $57,741 under
budget.
o Memberships are up $18,271 from last year and $18,749 over budget. Memberships
from both B&T and Golf are up in 2018 compared to last year.
o Greens Fees are down $53,746 from last year and $85,235 under budget. Rounds
played are down in 2018 due to unfavorable weather conditions.
o Rentals are up $42,393 from last year and $31,123 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,760 from last year and $53,770 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 October 2018 are up $149,217 from last year, but $386,605 under
budget.
o Personnel expenditures are up $32,317 from last year and $53,783 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 $15,999 from last year and $59,259 under
budget. This is due to the timing of golf course maintenance supplies purchases.
o Operation and Contractual expenditures are up $61,908 from last year and $107,057
over budget. This is due to the outsourcing of swim operations to the Park District.
o Capital outlay expenditures are up $13,368 from last year, but $421,504 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 October 2018 are down $7,333 from last year and $4,106 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 October 2018 are up $43,248 from last year, but $46,380 under budget.
This is due retirees moving to a new insurance plan in FY18 with some not continuing on the
Village’s plan.
x Total expenditures through October 2018 are down $379,198 from last year and $444,144
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 October 2018 are down $107,747 from last year, but $5,162 over
budget. This is due to a budgeted reduction in maintenance charges to use available net
position reserves.
x Total expenditures through October 2018 are down $36,835 from last year and $163,139 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 October 2018 are down $304,084 from last year, but $31,354 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 October 2018 are up $182,196 from last year and $23,243 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)21,934,392 $20,819,239 $1,115,153 $29,512
Main operating fund of the Village.
Hotel Fund (Major Fund)$1,179,187 $487,611 $691,576 ($43,325)
Collects and spends resources from the
3% hotel/motel tax.
Motor Fuel Tax Fund $176,032 $7,790 $168,242 ($324,850)
Collects and spends resources from the
State motor fuel tax.
Infrastructure Fund (Major Fund)$4,951,352 $2,840,504 $2,110,848 ($1,795,665)
Accounts for construction and maintenance of
roadways, drainage, and safety path systems.
Promenade TIF Fund (Major Fund)$441,652 $493,398 ($51,746)($10,400)
Accounts for the revenues and expenditures
restricted to the Tax Increment Financing (TIF)
district located at 22nd St. and Meyers Rd.
Enterprise Funds
Water Fund (Major Fund)$8,336,123 $7,249,205 $1,086,918 ($871,690)
Collects user fees for the distribution of water
and maintenance of infrastructure.
Sports Core Fund (Major Fund)$3,216,094 $3,018,365 $197,729 $154,345
Accounts for revenues and expenses relating
to administration, programs, food and beverage
operations, and golf course.
Golf Surcharge Fund $113,794 $0 $113,794 ($167,600)
Accounts for the collection of the $3 per round
golf surcharge.
Internal Service Funds
Self Insurance Fund $2,654,070 $2,324,286 $329,784 ($67,980)
Accounts for the Village's health insurance costs
and the related contributions from the Village,
employees, retirees, and other agencies.
Garage Fund $515,742 $501,666 $14,076 ($154,225)
Accounts for the maintenance of the Village's vehicle
fleet and the related departmental reimbursements.
Equipment Replacement Fund $367,104 $580,713 ($213,609)($221,720)
Accounts for the replacement of the Village's vehicle
fleet and the related departmental contributions.
Further information on the Village's major funds (as indicated above) can be found on the proceeding pages.
Executive Summary on Village Funds
Through October 31, 2018
10/31/18 10/31/18
10/31/17 10/31/18 YTD % of 2018 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 10,342,460$ 10,242,870$ 10,280,000$ 99.6%12,453,000$ (99,590)$
Other Intergovernmental Tax 1,201,140 1,135,708 1,022,900 111.0%1,144,700 (65,432)
Telecommunications/Utility Tax 5,004,413 5,114,946 4,824,935 106.0%5,792,250 110,533
Licenses and Permits 2,010,691 3,043,304 1,614,315 188.5%1,784,070 1,032,613
Charges for Services 797,538 955,118 812,880 117.5%1,017,100 157,580
Fines and Penalties 117,909 146,905 125,380 117.2%150,500 28,996
Administrative Towing Fees 34,875 26,475 29,160 90.8%35,000 (8,400)
Interest on Investments 187,223 287,508 162,500 176.9%195,000 100,285
Franchise/IMF Maint. Fee 113,712 112,802 161,250 70.0%215,000 (910)
Miscellaneous Income 160,498 344,546 145,550 236.7%180,750 184,048
Total Operating Revenues 19,970,459$ 21,410,182$ 19,178,870$ 111.6%22,967,370$ 1,439,723$
OPERATING EXPENDITURES
Personnel 13,497,508$ 14,469,246$ 15,181,950$ 95.3%17,953,350$ 971,738$
Materials and Supplies 346,488 380,747 460,380 82.7%532,820 34,259
Operation and Contract 3,439,564 3,129,363 3,715,810 84.2%4,278,675 (310,201)
Other Expenditures 396,720 115,296 150,675 76.5%388,815 (281,424)
Capital Outlay 1,101,034 2,724,587 2,710,168 100.5%2,997,840 1,623,553
Total Operating Expenditures 18,781,314$ 20,819,239$ 22,218,983$ 93.7%26,151,500$ 2,037,925$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 1,189,145$ 590,943$ (3,040,113)$ (3,184,130)$ (598,202)$
OTHER TRANSACTIONS
Reimbursements From Other Funds 514,420$ 524,210$ 594,460$ 88%713,360$ 9,790$
Installment Contract Proceeds - - 2,475,165 0%2,475,165 -
Total Interfund Transactions 514,420$ 524,210$ 3,069,625$ 0%3,188,525$ 9,790$
NET FUND INCREASE (DECREASE)1,703,565$ 1,115,153$ 29,512$ 4,395$ (588,412)$
Village of Oak Brook
General Fund Financial Update
For the Period Ending October 31, 2018
Total Total
Revenues Expenditures
10/31/18 Actual 21,410,182$ 20,819,239$
10/31/17 Actual 19,970,459$ 18,781,314$
% Change From Last Year 7.2%10.9%
Major Revenues Other
Intergov.Licenses &Charges for
Sales Tax Tax Telecom Tax Permits Services
10/31/18 Actual 10,242,870$ 1,135,708$ 5,114,946$ 3,043,304$ 955,118$
10/31/17 Actual $ 10,342,460 $ 1,201,140 $ 5,004,413 $ 2,010,691 $ 797,538
% Change From Last Year -1.0%-5.4%2.2%51.4%19.8%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
10/31/18 Actual 14,469,246$ 380,747$ 3,129,363$ 115,296$ 2,724,587$
10/31/17 Actual 13,497,508$ 346,488$ 3,439,564$ 396,720$ 1,101,034$
% Change From Last Year 7.2%9.9%-9.0%-70.9%147.5%
Five Year Trend
Expenditures by Department
10/31/17 10/31/18 10/31/18 10/31/18 2018 Difference Five
YTD YTD YTD % of Annual Prior Year
Department Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 2,188,655$ 1,885,525$ 2,294,845$ 82.2%2,673,305$ (303,130)$
Financial Services 967,028 702,714 770,355 91.2%1,117,875 (264,314)
Public Works 560,706 570,014 837,665 68.0%993,820 9,308
Engineering & Capital Projects 776,915 2,571,572 2,389,583 107.6%2,732,665 1,794,657
Library 750,321 735,172 753,545 97.6%889,845 (15,149)
Police 6,847,761 7,179,515 7,434,355 96.6%8,705,350 331,754
Fire 5,886,433 6,393,358 6,907,420 92.6%8,043,215 506,925
Development Services 803,495 781,369 831,215 94.0%995,425 (22,126)
Total Expenditures 18,781,314$ 20,819,239$ 22,218,983$ 93.7%26,151,500$ 2,037,925$
Five Year Trend
For the Period Ending October 31, 2018
General Fund - Five Year Trend
Village of Oak Brook
Revenues Expenditures
10/31/18 10/31/18
10/31/17 10/31/18 YTD % of 2018 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Hotel Tax 1,032,697$ 1,108,036$ 1,095,000$ 101.2%1,340,000$ 75,339$
Interest 40,387 65,951 25,000 263.8%30,000 25,564
Miscellaneous 44,095 5,200 - N/A - (38,895)
Total Operating Revenues 1,117,179$ 1,179,187$ 1,120,000$ 105.3%1,370,000$ 62,008$
EXPENDITURES
Operation and Contract 372,913$ 398,338$ 547,050$ 72.8%646,515$ 25,425$
Other Expenditures 77,830 82,950 82,950 100.0%99,550 5,120
Capital Outlay 877,917 6,323 533,325 1.2%640,000 (871,594)
Total Expenditures 1,328,660$ 487,611$ 1,163,325$ 41.9%1,386,065$ (841,049)$
NET FUND INCREASE (DECREASE)(211,481)$ 691,576$ (43,325)$ (16,065)$ 903,057$
Note - Expenditures are recorded in program 171.
Village of Oak Brook
Hotel Tax Fund Financial Update
For the Period Ending October 31, 2018
Total Total
Revenues Expenditures
10/31/18 Actual $ 1,179,187 487,611$
10/31/17 Actual $ 1,117,179 1,328,660$
% Change From Last Year 5.6%-63.3%
Major Revenues
Grants Hotel Tax Interest Miscellaneous
10/31/18 Actual $ - $ 1,108,036 $ 65,951 $ 5,200
10/31/17 Actual $ - $ 1,032,697 $ 40,387 $ 44,095
% Change From Last Year 0.0%7.3%63.3%-88.2%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures Capital Outlay
10/31/18 Actual 398,338$ 82,950$ 6,323$
10/31/17 Actual 372,913$ 77,830$ 877,917$
% Change From Last Year 6.8%6.6%-99.3%
Five Year Trend
Village of Oak Brook
Hotel Tax Fund - Major Sources Five Year Trend
For the Period Ending October 31, 2018
Five Year Trend
Revenues Expenditures
10/31/18 10/31/18
10/31/17 10/31/18 YTD % of 2018 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 4,752,219$ 4,646,817$ 4,620,750$ 100.6%5,563,000$ (105,402)$
Grants 3,142 - - 0.0%- (3,142)
Interest 62,480 143,076 35,000 408.8%42,000 80,596
Miscellaneous 5,745 2,729 4,150 65.8%5,000 (3,016)
Total Operating Revenues 4,823,586$ 4,792,622$ 4,659,900$ 102.8%5,610,000$ (30,964)$
OPERATING EXPENDITURES
Personnel 968,626$ 1,009,494$ 1,121,080$ 90.0%1,365,445$ 40,868$
Materials and Supplies 80,702 110,447 152,520 72.4%182,955 29,745
Operation and Contract 1,204,635 967,131 1,267,065 76.3%1,484,755 (237,504)
Other Expenditures 135,420 137,390 137,395 100.0%164,865 1,970
Capital Outlay 396,293 616,042 4,428,455 13.9%5,625,620 219,749
Total Operating Expenditures 2,785,676$ 2,840,504$ 7,106,515$ 40.0%8,823,640$ 54,828$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 2,037,910$ 1,952,118$ (2,446,615)$ -79.8%(3,213,640)$ (85,792)$
INTERFUND TRANSACTIONS
Transfers In 389,604$ 7,790$ 500,000$ 1.6%500,000$ (381,814)$
Reimbursements From Other Funds 147,200 150,940 150,950 100.0%181,130 3,740
Total Interfund Transactions 536,804$ 158,730$ 650,950$ 24.4%681,130$ (378,074)$
NET FUND INCREASE (DECREASE)2,574,714$ 2,110,848$ (1,795,665)$ (2,532,510)$ (463,866)$
Village of Oak Brook
Infrastructure Fund Financial Update
For the Period Ending October 31, 2018
Total Total
Revenues Expenditures
10/31/18 Actual $ 4,792,622 2,840,504$
10/31/17 Actual $ 4,823,586 2,785,676$
% Change From Last Year -0.6%2.0%
Major Revenues
Sales Tax Grants Interest Miscellaneous Reimbursements
10/31/18 Actual $ 4,646,817 $ - $ 143,076 $ 2,729 $ 150,940
10/31/17 Actual $ 4,752,219 $ 3,142 $ 62,480 $ 5,745 $ 147,200
% Change From Last Year -2.2%-100.0%129.0%-52.5%2.5%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
10/31/18 Actual 1,009,494$ 110,447$ 967,131$ 137,390$ 616,042$
10/31/17 Actual 968,626$ 80,702$ 1,204,635$ 135,420$ 396,293$
% Change From Last Year 4.2%36.9%-19.7%1.5%55.5%
Five Year Trend
Expenditures by Department
10/31/17 10/31/18 10/31/18 10/31/18 2018 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 141,895$ 130,723$ 151,045$ 86.5%178,530$ (11,172)$
Public Works 1,918,930 1,757,287 2,193,035 80.1%2,592,335 (161,643)
Engineering & Capital Projects 724,851 952,494 4,762,435 20.0%6,052,775 227,643
Total Expenditures 2,785,676$ 2,840,504$ 7,106,515$ 40.0%8,823,640$ 54,828$
Five Year Trend
Village of Oak Brook
Infrastructure Fund - Major Sources Five Year Trend
For the Period Ending October 31, 2018
Revenues Expenditures
10/31/18 10/31/18
10/31/17 10/31/18 YTD % of 2018 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 65,941$ 67,242$ 68,300$ 98.5%102,500$ 1,301$
Real Estate Tax 385,018 373,267 385,000 97.0%385,000 (11,751)
Interest 467 1,143 210 544.3%250 676
Total Operating Revenues 451,426$ 441,652$ 453,510$ 97.4%487,750$ (9,774)$
EXPENDITURES
Operation and Contract 3,958$ 3,578$ 4,090$ 87.5%4,090$ (380)$
Other Expenditures 454,380 489,820 459,820 106.5%459,820 35,440
Total Expenditures 458,338$ 493,398$ 463,910$ 106.4%463,910$ 35,060$
NET FUND INCREASE (DECREASE)(6,912)$ (51,746)$ (10,400)$ 23,840$ (44,834)$
Note - Expenditures are recorded in program 283.
Village of Oak Brook
Promenade TIF Fund Financial Update
For the Period Ending October 31, 2018
Total Total
Revenues Expenditures
10/31/18 Actual $ 441,652 493,398$
10/31/17 Actual $ 451,426 458,338$
% Change From Last Year -2.2%7.6%
Major Revenues Real Estate
Sales Tax Tax Interest
10/31/18 Actual $ 67,242 $ 373,267 $ 1,143
10/31/17 Actual $ 65,941 $ 385,018 $ 467
% Change From Last Year 2.0%-3.1%144.8%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures
10/31/18 Actual 3,578$ 489,820$
10/31/17 Actual 3,958$ 454,380$
% Change From Last Year -9.6%7.8%
Five Year Trend
Village of Oak Brook
Promenade TIF Fund - Major Sources Five Year Trend
For the Period Ending October 31, 2018
Five Year Trend
Revenues Expenditures
10/31/18 10/31/18
10/31/17 10/31/18 YTD % of 2018 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Grants 3,386$ -$ -$ 0.0%-$ (3,386)$
Plan Review Fees 1,714 750 1,650 45.5%2,000 (964)
Building/Inspection Fees 11,389 7,763 4,160 186.6%5,000 (3,626)
Water Sales 7,769,274 8,002,272 8,025,425 99.7%9,730,425 232,998
Unmetered Sales 37,498 34,532 25,000 138.1%30,000 (2,966)
Water Connection Fees 163,070 110,894 41,600 266.6%50,000 (52,176)
Fire Service Charge - - 4,160 0.0%5,000 -
Meter Charges 19,908 9,900 20,850 47.5%25,000 (10,008)
Special Services 15,286 16,394 15,000 109.3%30,000 1,108
Interest on Investments 31,409 81,264 8,350 973.2%10,000 49,855
Miscellaneous 70,098 72,354 41,660 173.7%50,000 2,256
Total Operating Revenues 8,123,032$ 8,336,123$ 8,187,855$ 101.8%9,937,425$ 213,091$
EXPENDITURES
Personnel 658,519$ 619,652$ 690,350$ 89.8%817,490$ (38,867)$
Materials and Supplies 51,231 55,328 66,110 83.7%76,860 4,097
Operation and Contract 4,373,538 4,298,144 5,650,265 76.1%6,780,015 (75,394)
Other Expenditures 334,670 337,640 337,650 100.0%405,170 2,970
Capital Outlay 58,621 1,938,441 2,315,170 83.7%2,710,220 1,879,820
Total Expenditures 5,476,579$ 7,249,205$ 9,059,545$ 80.0%10,789,755$ 1,772,626$
NET FUND INCREASE (DECREASE)2,646,453$ 1,086,918$ (871,690)$ (852,330)$ (1,559,535)$
Village of Oak Brook
Water Fund Financial Update
For the Period Ending October 31, 2018
Total Total
Revenues Expenditures
10/31/18 Actual $ 8,336,123 7,249,205$
10/31/17 Actual $ 8,123,032 5,476,579$
% Change From Last Year 2.6%32.4%
Unmetered Water
Water Sales Sales Connection Fees Meter Charges Miscellaneous
10/31/18 Actual $ 8,002,272 $ 34,532 $ 110,894 $ 9,900 $ 72,354
10/31/17 Actual $ 7,769,274 $ 37,498 $ 163,070 $ 19,908 $ 70,098
% Change From Last Year 3.0%-7.9%-32.0%-50.3%3.2%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
10/31/18 Actual 619,652$ 55,328$ 4,298,144$ 337,640$ 1,938,441$
10/31/17 Actual 658,519$ 51,231$ 4,373,538$ 334,670$ 58,621$
% Change From Last Year -5.9%8.0%-1.7%0.9%3206.7%
Five Year Trend
Expenditures by Department
10/31/17 10/31/18 10/31/18 10/31/18 2018 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Public Works 5,404,891$ 5,267,721$ 6,798,545$ 77.5%8,124,535$ (137,170)$
Engineering & Capital Projects 71,688 1,981,484 2,261,000 87.6%2,665,220 1,909,796
Total Expenditures 5,476,579$ 7,249,205$ 9,059,545$ 80.0%10,789,755$ 1,772,626$
Five Year Trend
Village of Oak Brook
Water Fund - Major Sources Five Year Trend
For the Period Ending October 31, 2018
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Sports Core Fund Consolidated Presentation
For the Period Ending October 31, 2018
10/31/18 10/31/18
10/31/18 YTD % of 2018 10/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$ 414,675$ 104.5%414,875$ 415,153$ 18,271$
Greens Fees - - 871,665 871,665 956,900 91.1%975,000 925,411 (53,746)
Pro Shop Sales - - 180,084 180,084 193,000 93.3%200,000 171,540 8,544
Golf Lessons - - 36,705 36,705 40,000 91.8%40,000 43,359 (6,654)
Driving Range Fees - - 216,126 216,126 235,000 92.0%235,000 235,274 (19,148)
Rentals - - 398,398 398,398 367,275 108.5%451,000 356,005 42,393
Programs/User Fees 241,570 - - 241,570 295,340 81.8%300,700 361,330 (119,760)
Food Sales - 156,220 - 156,220 142,300 109.8%145,500 175,726 (19,506)
Beverage Sales - 227,136 - 227,136 230,815 98.4%236,000 263,947 (36,811)
Other Revenue 189,902 231,327 6,867 428,096 371,860 115.1%380,650 392,328 35,768
Total Direct Revenues 660,846$ 614,683$ 1,913,895$ 3,189,424$ 3,247,165$ 98.2%3,378,725$ 3,340,073$ (150,649)$
DIRECT EXPENDITURES
Personnel 145,600$ 225,319$ 992,439$ 1,363,358$ 1,309,575$ 104.1%1,497,200$ 1,331,041$ 32,317$
Materials & Supplies 18,499 169,821 337,156 525,476 584,735 89.9%615,885 541,475 (15,999)
Operational & Contractual 693,720 118,076 216,656 1,028,452 921,395 111.6%961,510 966,544 61,908
Other - - (128,577) (128,577) (61,895) 207.7%(44,275) (186,200) 57,623
Capital 91,588 11,988 126,080 229,656 651,160 35.3%365,660 216,288 13,368
Total Direct Expenditures 949,407$ 525,204$ 1,543,754$ 3,018,365$ 3,404,970$ 88.6%3,395,980$ 2,869,148$ 149,217$
Direct Revenues Over (Under) Expenditures (288,561)$ 89,479$ 370,141$ 171,059$ (157,805)$ -108.4%(17,255)$ 470,925$ (299,866)$
B&T Administration Overhead Allocation*114,264$ (114,264)$ -$ -$ -$ 0.0%-$ -$ -$
Operating Revenues Over (Under) Expenditures (174,297)$ (24,785)$ 370,141$ 171,059$ (157,805)$ -108.4%(17,255)$ 470,925$ (299,866)$
Interfund Loan**-$ -$ -$ -$ -$ 0.0%-$ -$ -$
Transfer From General Fund - - - - - 0.0%- - -
Reimbursement From Infrastructure Fund 20,000 - - 20,000 20,000 100.0%24,000 20,000 -
Reimbursement From Water Fund 6,670 - - 6,670 6,650 100.3%8,000 6,670 -
Transfer From Golf Surcharge Fund - - - - 285,500 0.0%- - -
Adjusted Operating Revenues Over (Under) Expenditures (147,627)$ (24,785)$ 370,141$ 197,729$ 154,345$ 14,745$ 497,595$ (299,866)$
*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
10/31/18 Actual $ 3,189,424 3,018,365$
10/31/17 Actual $ 3,340,073 2,869,148$
% Change From Last Year -4.5%5.2%
Driving Program/
Memberships Greens Fees Range Fees Rentals User Fees
10/31/18 Actual $ 433,424 $ 871,665 $ 216,126 $ 398,398 $ 241,570
10/31/17 Actual $ 415,153 $ 925,411 $ 235,274 $ 356,005 $ 361,330
% Change From Last Year 4.4%-5.8%-8.1%11.9%-33.1%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
10/31/18 Actual 1,363,358$ 525,476$ 1,028,452$ (128,577)$ 229,656$
10/31/17 Actual 1,331,041$ 541,475$ 966,544$ (186,200)$ 216,288$
% Change From Last Year 2.4%-3.0%6.4%-30.9%6.2%
Five Year Trend
Revenues by Department 10/31/17 10/31/18 10/31/18 10/31/18 2018 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Programs 777,523$ 660,846$ 646,495$ 102.2%712,075$ (116,677)$
Food & Beverage 621,230 614,683 127,800 481.0%569,000 (4,147)
Golf Club 1,941,320 1,913,895 567,997 337.0%2,097,650 (27,425)
Total Revenues 3,340,073$ 3,189,424$ 1,342,292$ 237.6%3,378,725$ (148,249)$
Expenditures by Department 10/31/17 10/31/18 10/31/18 % of 2018 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Programs 890,501$ 949,407$ 344,363$ 275.7%1,058,430$ 58,906$
Food & Beverage 594,361 525,204 281,968 186.3%514,980 (69,157)
Golf Club 1,384,286 1,543,754 778,751 198.2%1,822,570 159,468
Total Expenditures 2,869,148$ 3,018,365$ 1,405,082$ 214.8%3,395,980$ 149,217$
Five Year Trend
Village of Oak Brook
Sports Core Fund - Major Sources Five Year Trend
For the Period Ending October 31, 2018
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Club Recreation Programs
For the Period Ending October 31, 2018 10/31/18 10/31/18
10/31/18 YTD % of 2018 10/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$ 223,175$ 102.8%223,375$ 222,790$ 6,584$
Programs/User Fees (1,612) 19,401 31,981 - 191,800 241,570 295,340 81.8%300,700 361,330 (119,760)
Other Revenue 953 2,621 410 - 185,918 189,902 189,210 100.4%188,000 193,403 (3,501)
Total Revenue (659)$ 230,123$ 53,664$ -$ 377,718$ 660,846$ 707,725$ 93.4%712,075$ 777,523$ (116,677)$
Expenditures:
Personnel 92,670$ 20,179$ 27,556$ -$ 5,195$ 145,600$ 180,280$ 80.8%208,040$ 192,158$ (46,558)$
Materials & Supplies 5,407 9,965 2,075 - 1,052 18,499 27,560 67.1%28,280 35,562 (17,063)
Operational & Contractual 74,019 284,631 69,112 20,000 245,958 693,720 580,215 119.6%586,160 611,260 82,460
Other - - - - - - 46,830 0.0%56,200 - -
Capital 38,845 52,154 - - 589 91,588 106,000 86.4%179,750 51,521 40,067
Total Expenditures 210,941$ 366,929$ 98,743$ 20,000$ 252,794$ 949,407$ 940,885$ 100.9%1,058,430$ 890,501$ 58,906$
Direct Revenues Over (Under) Expenditures (211,600)$ (136,806)$ (45,079)$ (20,000)$ 124,924$ (288,561)$ (233,160)$ 123.8%(346,355)$ (112,978)$ (175,583)$
B&T Administration Overhead Allocation*211,600$ (76,176)$ (21,160)$ -$ -$ 114,264$ 159,225$ 71.8%207,995$ 153,922$ (39,658)$
Revenues Over (Under) Expenditures -$ (212,982)$ (66,239)$ (20,000)$ 124,924$ (174,297)$ (73,935)$ 235.7%(138,360)$ 40,944$ (215,241)$
Reimbursement From Infrastructure Fund 20,000$ -$ -$ -$ -$ 20,000$ 20,000$ 100.0%24,000$ 20,000$ -$
Reimbursement From Water Fund 6,670 - - - - 6,670 6,650 100.3%8,000 6,670 -
Adjusted Revenues Over (Under) Expenditures 26,670$ (212,982)$ (66,239)$ (20,000)$ 124,924$ (147,627)$ (47,285)$ (106,360)$ 67,614$ (215,241)$
*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 October 31, 2018
10/31/18 10/31/18
821 822 823 10/31/18 YTD % of 2018 10/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.0%-$ 2,400$ -$
Food Sales - 34,693 121,527 156,220 142,300 109.8%145,500 175,726 (19,506)
Beverage Sales - 18,467 208,669 227,136 230,815 98.4%236,000 263,947 (36,811)
Other Revenue 231,327 - - 231,327 177,500 130.3%187,500 179,157 52,170
Total Revenue 231,327$ 53,160$ 330,196$ 614,683$ 550,615$ 111.6%569,000$ 621,230$ (4,147)$
Expenditures:
Personnel 97,791$ 24,003$ 103,525$ 225,319$ 175,025$ 128.7%199,505$ 200,851$ 24,468$
Materials & Supplies 12,045 15,731 142,045 169,821 172,970 98.2%182,150 199,448 (29,627)
Operational & Contractual 110,967 1,272 5,837 118,076 114,605 103.0%133,325 99,312 18,764
Capital 11,988 - - 11,988 73,750 16.3%- 94,750 (82,762)
Total Expenditures 232,791$ 41,006$ 251,407$ 525,204$ 536,350$ 97.9%514,980$ 594,361$ (69,157)$
Direct Revenues Over (Under) Expenditures (1,464)$ 12,154$ 78,789$ 89,479$ 14,265$ 627.3%54,020$ 26,869$ 62,610$
B&T Administration Overhead Allocation*(105,800)$ (8,464)$ -$ (114,264)$ (159,225)$ 71.8%(175,995)$ (153,922)$ 39,658$
Revenues Over (Under) Expenditures (107,264)$ 3,690$ 78,789$ (24,785)$ (144,960)$ 17.1%(121,975)$ (127,053)$ 102,268$
Transfer From General Fund -$ -$ -$ -$ -$ 0.0%-$ -$ -$
Adjusted Revenues Over (Under) Expenditures (107,264)$ 3,690$ 78,789$ (24,785)$ (144,960)$ (121,975)$ (127,053)$ 102,268$
*Overhead allocation is comprised of salaries, business forms, liability insurance, building & grounds maintenance and bank service fees in Program 811 -
Sports Core General Operations distributed to various Sports Core Programs on a percentage basis.
Village of Oak Brook
Monthly Operating Statement
Golf Club Programs
For the Period Ending October 31, 2018
10/31/18 10/31/18
831 832 833 834 10/31/18 YTD % of 2018 10/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$ 106.6%191,500$ 189,963$ 14,087$
Greens Fees 871,665 - - - 871,665 956,900 91.1%975,000 925,411 (53,746)
Pro Shop Sales 180,084 - - - 180,084 193,000 93.3%200,000 171,540 8,544
Golf Lessons - 36,705 - - 36,705 40,000 91.8%40,000 43,359 (6,654)
Driving Range Fees - 216,126 - - 216,126 235,000 92.0%235,000 235,274 (19,148)
Rentals 3,340 70,000 325,058 - 398,398 367,275 108.5%451,000 356,005 42,393
Other Revenue 6,867 - - - 6,867 5,150 133.3%5,150 19,768 (12,901)
Total Revenue 1,266,006$ 322,831$ 325,058$ -$ 1,913,895$ 1,988,825$ 96.2%2,097,650$ 1,941,320$ (27,425)$
Expenditures:
Personnel 408,624$ 53,683$ 50,858$ 479,274$ 992,439$ 954,270$ 104.0%1,089,655$ 938,032$ 54,407$
Materials & Supplies 143,555 19,579 343 173,679 337,156 384,205 87.8%405,455 306,465 30,691
Operational & Contractual 152,265 14,058 2,205 48,128 216,656 226,575 95.6%242,025 255,972 (39,316)
Other - - 49,573 (178,150) (128,577) (108,725) 118.3%(100,475) (186,200) 57,623
Capital 35,216 - 40,922 49,942 126,080 471,410 26.7%185,910 70,017 56,063
Total Expenditures 739,660$ 87,320$ 143,901$ 572,873$ 1,543,754$ 1,927,735$ 80.1%1,822,570$ 1,384,286$ 159,468$
Direct Revenues Over (Under) Expenditures 526,346$ 235,511$ 181,157$ (572,873)$ 370,141$ 61,090$ 605.9%275,080$ 557,034$ (186,893)$
Transfer from Golf Surcharge -$ -$ -$ -$ -$ 285,500$ 0.0%-$ -$ -$
Adjusted Revenues Over (Under) Expenditures 526,346$ 235,511$ 181,157$ (572,873)$ 370,141$ 346,590$ 275,080$ 557,034$ (186,893)$