11 - November 2018 Monthly Financial ReportVILLAGE
OAK BROOK
OF
MONTHLY FINANCIAL REPORTS
NOVEMBER 2018
ITEM 6.G
Total
Cash and Cash Pooled Cash and
Fund Equivalents Investments Investments % By Fund
General Corporate $5,385,988 $13,261,865 $18,647,853 41.9%
Hotel/Motel Tax 2,179,913 2,533,657 4,713,570 10.6%
Motor Fuel Tax 583,868 179,047 762,915 1.7%
Infrastructure 6,832,386 3,284,285 10,116,671 22.7%
Promenade TIF 224,806 - 224,806 0.5%
Water 4,822,262 1,701,299 6,523,561 14.7%
Sports Core 453,311 - 453,311 1.0%
Golf Surcharge 114,048 550,143 664,191 1.5%
Self-Insurance 478,130 - 478,130 1.1%
Garage 351,578 - 351,578 0.8%
Equipment Replacement 559,067 1,008,440 1,567,507 3.5%
Total $21,985,357 $22,518,736 $44,504,093 100.0%
Change in Cash and Investments by Fund :
Balance at Balance at Year-to-Date Year-to-Date
Fund January 1, 2018 November 30, 2018 Change ($)Change (%)
General Corporate $17,679,496 $18,647,853 $968,357 5.5%
Hotel/Motel Tax 4,172,234 4,713,570 541,336 13.0%
Motor Fuel Tax 574,460 762,915 188,455 32.8%
Infrastructure 8,222,145 10,116,671 1,894,526 23.0%
Promenade TIF 276,164 224,806 (51,358)-18.6%
Water 5,693,109 6,523,561 830,452 14.6%
Sports Core 472,473 453,311 (19,162)-4.1%
Golf Surcharge 559,073 664,191 105,118 18.8%
Self-Insurance 45,042 478,130 433,088 961.5%
Garage 427,409 351,578 (75,831)-17.7%
Equipment Replacement 1,805,752 1,567,507 (238,245)-13.2%
$39,927,358 $44,504,093 $4,576,735 11.5%
Book Market
Value Value
Pooled Checking $826,352 $826,352
Sports Core Checking 566,394 566,394
Pooled IPTIP 20,512,541 20,512,541
Water E-Pay IPTIP 80,070 80,070
$21,985,357 $21,985,357
Pooled Investments:
Investments-Municipal Bonds $7,112,259 $7,004,223
Investments-Corporate Bonds 7,886,758 7,872,820
Government & Agency Obligations 697,292 660,080
Certificates of Deposit 6,720,000 6,653,457
Accrued Interest 102,427 102,427
Total Pooled Investments $22,518,736 $22,293,007
Total Cash and Investments $44,504,093 $44,278,364
For November, total interest revenue is $79,862 and YTD interest revenue is $713,975.
Total investment yield for the portfolio is:
Pooled
Investments Illinois Funds Total
Monthly yield 0.19%0.20%0.19%
YTD yield 1.76%1.71%1.73%
Last 12 months yield 1.89%1.81%1.85%
The weighted average yield of the current pooled investment portfolio is 2.27%.
Monthly Treasurer's Report
November 30, 2018
Monthly Treasurer's Report
November 2018
The table below lists the detail investment holdings at J.P. Morgan Securities as of 11/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 06/01/19 2.050%2.123%$99,963 $99,663 $1,023
Rosemont IL GO Corp #777543UT4 02/08/16 12/01/19 3.021%2.000%504,991 496,805 7,456
New York N Y City #64971QTX1 02/22/16 05/01/21 2.350%2.000%201,634 196,714 377
Florida Hurricane #34074GDH4 03/30/16 07/01/20 2.995%2.150%506,480 499,080 6,239
Bloomingdale Mich Pub Sch Dist #094383FS0 04/26/16 05/01/22 2.710%2.150%509,152 490,035 1,090
Milan Mich Area Achs #598801JD1 05/26/16 05/01/20 1.931%1.931%245,000 241,563 293
Indiana Bd Bk Rev Taxable #4546248F7 01/06/17 01/15/20 2.934%1.900%257,888 254,597 2,840
Garland Cnty Ark Sales & Use #36609PAN3 02/06/17 11/01/19 1.795%1.840%499,793 495,235 873
Anchor Bay Mich Sch Dist GO #032879TA6 02/13/17 05/01/19 1.810%1.420%365,594 363,697 474
Lanse Creuse Mich Pub Schs #516228RL9 05/02/17 05/01/20 2.159%2.159%100,000 98,882 178
California St GO Bonds #13063A7G3 05/08/17 10/01/19 6.200%1.600%519,041 513,895 4,885
*Genesee Cnty Mich #371608UV0 05/31/17 10/01/19 2.681%2.681%214,000 214,024 521
Connecticut St GO Bds 2016 #20772J3F7 06/15/17 08/15/21 1.750%2.300%492,820 478,905 2,523
North Carolina Eastn Mun Pwr #65819WAL7 10/02/17 07/01/19 2.578%1.700%502,557 499,065 5,228
Fowlerville Mich Comnty Schs #351280MS8 10/03/17 05/01/20 2.045%1.750%502,066 494,035 682
Racine Cnty WI #749845UK7 12/20/17 12/01/20 2.150%2.150%750,000 733,148 8,063
Wisconsin St Gen Fd Annual #977100CW4 01/05/18 05/01/20 1.446%2.100%594,516 588,246 626
Illinois St G/O #452152HU8 04/03/18 03/01/19 5.877%3.000%246,764 246,634 3,480
Total Municipal Bonds $7,112,259 $7,004,223 $46,851
Corporate Bonds:
Wells Fargo #94974BFQ8 04/25/18 01/15/19 2.150%2.330%$1,389,671 $1,388,874 $11,207
Huntington National Bank #446438RG0 07/06/18 04/01/19 2.200%2.541%699,198 698,355 2,524
Bank of America #06051GFD6 07/06/18 04/01/19 2.650%2.509%750,353 748,898 2,871
KeyBank #49327M2N3 07/19/18 03/08/19 2.350%2.490%844,673 843,682 4,523
Bank of America #06051GFD6 07/30/18 04/01/19 2.650%2.420%245,181 244,640 1,082
Morgan Stanley #61746BDM5 08/03/18 01/24/19 2.500%2.430%1,000,096 999,030 8,680
Goldman Sachs #38141GVP9 09/26/18 09/15/20 2.750%3.180%496,285 491,485 2,865
Fifth Third #31677QBH1 10/11/18 09/27/19 1.625%2.750%990,924 987,770 2,889
JP Morgan #46640QUV1 11/01/18 07/29/19 0.000%3.017%1,470,377 1,470,086 0
Total Corporate Bonds $7,886,758 $7,872,820 $36,641
Government & Agency Obligations:
**Government National Mtg Assn #38379UEM4 02/29/16 02/16/51 2.300%2.245%$697,292 $660,080 $2,068
Total Government & Agency Obligations:$697,292 $660,080 $2,068
Certificates of Deposit:
State Bk India NY #8562846A7 01/26/17 01/26/22 2.250%2.250%$245,000 $237,400 $1,937
Marlin Business Bk #57116ANU8 05/10/17 11/12/19 1.600%1.600%245,000 242,442 213
American Express Fed Svgs #02587CER7 05/10/17 11/12/19 1.700%1.700%245,000 242,675 226
Synchrony Bank #87164WRA8 05/26/17 05/28/19 1.650%1.650%245,000 244,071 17
Umpqua Bank #90421MAG8 05/31/17 05/31/19 1.600%1.600%245,000 243,991 6
Stone Bk Mtn View Ark #86158RAJ8 06/28/17 06/28/19 1.600%1.600%245,000 243,797 12
TIAA FSB Jacksonville #87270LAA1 07/19/17 07/19/19 1.600%1.600%245,000 243,638 1,437
Peoples United Bank #71270QQZ2 07/19/17 07/19/19 1.650%1.650%245,000 243,714 1,482
Priority Bank Ozark Ark #74269KBR6 07/26/17 07/26/19 1.600%1.600%245,000 243,584 40
American Express Centurion #02587DV96 08/15/17 08/17/20 1.900%1.900%245,000 240,036 1,358
Sallie Mae #795450C86 08/16/17 08/17/20 1.900%1.900%245,000 240,468 1,358
Merrick Bank South Jordan #59013JZS1 08/21/17 08/21/20 1.800%1.800%245,000 240,004 113
Pinnacle Bank #72345SFS5 08/30/17 08/31/20 1.800%1.800%115,000 112,600 1
Jackson County Bank #466682AP6 08/31/17 03/01/21 1.850%1.850%245,000 238,113 1,133
Barclays Bank #06740KKX4 09/27/17 09/28/20 1.950%1.950%245,000 240,235 836
Capital One Bank #1404205E6 10/04/17 10/04/19 1.700%1.700%245,000 243,123 648
Transportation Alliance #89388CCB2 10/13/17 04/12/19 1.600%1.600%235,000 234,333 172
Goldman Sachs Bank #38148PRK5 10/18/17 10/19/20 1.950%1.950%245,000 239,987 557
FirstBank PR Santurce #33767A6M8 11/03/17 11/03/20 2.000%2.000%245,000 240,034 354
Morgan Stanley #61747MQ53 03/22/18 03/23/20 2.550%2.550%245,000 243,996 1,154
Investors Community Bank #46147UTT7 08/28/18 02/28/20 2.550%2.550%245,000 244,113 22
Lakeside Bank #51210SPS0 08/30/18 03/30/20 2.550%2.550%245,000 243,956 5
Bank United #066519GJ2 08/31/18 02/20/20 2.500%2.500%245,000 243,956 1,531
Compass Bank #20451PVW3 10/26/18 10/26/20 3.000%3.000%245,000 244,642 694
UBS Bank #90348JFH8 10/30/18 10/29/20 3.050%3.050%245,000 244,853 9
Citibank #17294XJP2 10/31/18 10/31/20 3.000%3.000%245,000 244,544 633
Discover Bank #254673WF9 11/07/18 11/09/20 3.000%3.000%245,000 244,576 470
Ally Bank #02007GFX6 11/08/18 11/09/20 3.000%3.000%245,000 244,576 449
Total Certificates of Deposits $6,720,000 $6,653,457 $16,867
Total J.P.Morgan Securities $22,416,309 $22,190,580 $102,427
*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
November 30, 2018
Cash & Investments by Fund - Total $44.5 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
41.90%
Hotel/Motel Tax
10.59%Motor Fuel Tax
1.71%
Infrastructure
22.73%
Promenade TIF
0.51%
Water
14.66%
Sports Core
1.02%
Golf Surcharge
1.49%
Self-Insurance
1.07%Garage
0.79%
Equipment
Replacement
3.52%
Checking, $1.4
Illinois Funds, $20.6
Certificates of Deposit,
$6.7
Municipal Bonds, $7.1
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 November 30, 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 November 2018 are $1,508,584 higher than last year and $2,307,645
over budget.
o Sales tax revenue, the General Fund’s largest revenue source, is down $125,542 from
last year and $79,065 under budget. This is due to the closure of two large taxpayers in
late 2017.
o Other intergovernmental tax revenue is down $60,054 from last year, but $123,848 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 $102,757 from last year and $300,951
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,007,563 from last year and $1,415,183 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 November 2018 are $2,258,688 higher than last year, but
$1,801,632 under budget.
o Personnel expenditures are up $1,021,315 from last year, but $796,242 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 will occur later in 2018.
o Operation and contract expenditures are down $279,732 from last year and $646,824
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,764,408 from last year, but $39,616 under
budget. The increase is due to the Police Department expansion project in 2018.
Hotel Tax Fund
Total revenues through November 2018 are $34,113 higher than last year and $38,881 over
budget.
o Hotel tax revenue is up $43,477 from last year, but $13,246 under budget. The increase
is due to an additional hotel in 2018 as Hyatt House opened in late 2017. Revenue is
under budget due to the timing of receipts received.
o Interest income revenue is up $29,531 from last year and $46,927 over budget. This is
due to favorable market conditions and rising interest rates.
Total expenditures through November 2018 are $866,850 lower than last year and $770,973
under budget.
o Operation and contract expenditures are up $73,421 from last year, but $137,291 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 $945,903 from last year and $633,677 under
budget. This is due to the timing of projects scheduled.
Motor Fuel Tax Fund
Total revenues through November 2018 are up $1,930 from last year and $3,584 over budget.
Motor Fuel Tax receipts are slightly under budget, but are offset by increases in interest income.
Total expenditures through November 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
Total revenues through November 2018 are down $23,352 from last year, but $139,496 over
budget.
o Non-home rule sales tax revenue is down $107,384 from last year, but $18,838 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 $90,190 from last year and $122,504 over budget. This is
due to favorable market conditions and rising interest rates.
Total expenditures through November 2018 are up $422,389 from last year, but $4,479,547
under budget.
o Personnel expenditures are up $49,422 from last year, but $144,091 under budget.
Personnel is under budget due to employee turnover.
o Operation and contract expenditures are down $273,828 from last year and $261,671
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 $616,283 from last year, but $4,014,464 under
budget. This is due to the timing of roadway improvement projects.
Promenade TIF Fund
Total revenues through November 2018 are down $9,596 from last year and $11,490 under
budget. This is due to a decrease in real estate tax revenue from last year.
Total expenditures through November 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
Total revenues through November 2018 are up $22,056 from last year, but $44,886 under
budget.
o Water sales revenue is up $49,210 from last year, but $218,843 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.
Total expenditures through November 2018 are up $1,725,269 from last year, but $2,175,314
under budget.
o Operation and contract expenditures are down $146,027 from last year and $1,543,701
under budget. Expenditures are under budget due to the timing of invoices paid and
DuPage Water Commission water purchased being less than expected.
o Capital outlay expenditures are up $1,902,292 from last year, but $542,652 under
budget. The increase relates to the start of the Village-wide water meter replacement
project.
Sports Core Fund
Total revenues through November 2018 are down $146,966 from last year and $136,304 under
budget.
o Memberships are up $19,521 from last year and $19,899 over budget. Memberships
from both B&T and Golf are up in 2018 compared to last year.
o Greens Fees are down $60,807 from last year and $97,793 under budget. Rounds
played are down in 2018 due to unfavorable weather conditions.
o Rentals are up $39,605 from last year, but $47,006 under budget. The increase is due to
the reclassification of driving range rental fees and the timing of fees received. Fees are
under budget due to lower golf cart rentals in 2018.
o Program/User Fees are down $117,276 from last year and $49,803 under budget. This
is due to the Village contracting the Park District to run swim lessons and programs in
2018.
Total expenditures through November 2018 are up $182,294 from last year, but $356,078 under
budget.
o Personnel expenditures are up $31,208 from last year and $41,074 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 $8,535 from last year and $49,841 under
budget. This is due to the timing of golf course maintenance supplies purchases.
o Operation and Contractual expenditures are up $47,083 from last year and $108,138
over budget. This is due to the outsourcing of swim operations to the Park District.
o Capital outlay expenditures are up $54,915 from last year, but $379,957 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 October 2018 are down $8,459 from last year and $7,044 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.
A total of $11,039 through November 2018 has been transferred to the Sports Core Fund to pay
for the golf course patio renovation project.
Self Insurance Fund
Total revenues through November 2018 are up $52,968 from last year, but $44,912 under
budget. This is due retirees moving to a new insurance plan in FY18 with some not continuing
on the Village’s plan.
Total expenditures through November 2018 are down $446,652 from last year and $441,957
under budget. This is due to the timing of invoices paid and health claims coming in lower than
projected.
Garage Fund
Total revenues through November 2018 are down $118,504 from last year, but $5,668 over
budget. This is due to a budgeted reduction in maintenance charges to use available net
position reserves.
Total expenditures through November 2018 are down $30,800 from last year and $115,191
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 November 2018 are down $338,825 from last year, but $42,494 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. Interest income and vehicle sale
proceeds have been better than expected so far in 2018.
Total expenditures through November 2018 are up $622,654 from last year, but $23,090 under
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)24,003,386 $22,630,486 $1,372,900 ($183,933)
Main operating fund of the Village.
Hotel Fund (Major Fund)$1,291,381 $557,057 $734,324 ($75,530)
Collects and spends resources from the
3% hotel/motel tax.
Motor Fuel Tax Fund $196,244 $7,790 $188,454 ($307,340)
Collects and spends resources from the
State motor fuel tax.
Infrastructure Fund (Major Fund)$5,453,645 $3,501,668 $1,951,977 ($2,174,850)
Accounts for construction and maintenance of
roadways, drainage, and safety path systems.
Promenade TIF Fund (Major Fund)$442,040 $493,398 ($51,358)($10,380)
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)$9,547,754 $7,752,236 $1,795,518 ($334,910)
Collects user fees for the distribution of water
and maintenance of infrastructure.
Sports Core Fund (Major Fund)$3,275,532 $3,224,692 $50,840 $105,505
Accounts for revenues and expenses relating
to administration, programs, food and beverage
operations, and golf course.
Golf Surcharge Fund $116,156 $11,039 $105,117 ($162,300)
Accounts for the collection of the $3 per round
golf surcharge.
Internal Service Funds
Self Insurance Fund $2,934,603 $2,599,968 $334,635 ($62,410)
Accounts for the Village's health insurance costs
and the related contributions from the Village,
employees, retirees, and other agencies.
Garage Fund $567,323 $615,789 ($48,466)($169,325)
Accounts for the maintenance of the Village's vehicle
fleet and the related departmental reimbursements.
Equipment Replacement Fund $411,839 $585,560 ($173,721)($239,305)
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 November 30, 2018
11/30/18 11/30/18
11/30/17 11/30/18 YTD % of 2018 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 11,460,477$ 11,334,935$ 11,414,000$ 99.3%12,453,000$ (125,542)$
Other Intergovernmental Tax 1,267,802 1,207,748 1,083,900 111.4%1,144,700 (60,054)
Telecommunications/Utility Tax 5,505,114 5,607,871 5,306,920 105.7%5,792,250 102,757
Licenses and Permits 2,110,500 3,118,063 1,702,880 183.1%1,784,070 1,007,563
Charges for Services 861,109 1,099,387 888,240 123.8%1,017,100 238,278
Fines and Penalties 130,277 166,860 137,940 121.0%150,500 36,583
Administrative Towing Fees 38,415 28,475 32,080 88.8%35,000 (9,940)
Interest on Investments 209,901 322,243 178,750 180.3%195,000 112,342
Franchise/IMF Maint. Fee 162,548 163,465 215,000 76.0%215,000 917
Miscellaneous Income 172,028 377,708 159,400 237.0%180,750 205,680
Total Operating Revenues 21,918,171$ 23,426,755$ 21,119,110$ 110.9%22,967,370$ 1,508,584$
OPERATING EXPENDITURES
Personnel 14,745,078$ 15,766,393$ 16,562,635$ 95.2%17,953,350$ 1,021,315$
Materials and Supplies 402,166 436,036 503,355 86.6%532,820 33,870
Operation and Contract 3,682,463 3,402,731 4,049,555 84.0%4,278,675 (279,732)
Other Expenditures 407,412 126,239 377,870 33.4%388,815 (281,173)
Capital Outlay 1,134,679 2,899,087 2,938,703 98.7%2,997,840 1,764,408
Total Operating Expenditures 20,371,798$ 22,630,486$ 24,432,118$ 92.6%26,151,500$ 2,258,688$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 1,546,373$ 796,269$ (3,313,008)$ (3,184,130)$ (750,104)$
OTHER TRANSACTIONS
Reimbursements From Other Funds 565,862$ 576,631$ 653,910$ 88.2%713,360$ 10,769$
Installment Contract Proceeds - - 2,475,165 0.0%2,475,165 -
Total Interfund Transactions 565,862$ 576,631$ 3,129,075$ 0.0%3,188,525$ 10,769$
NET FUND INCREASE (DECREASE)2,112,235$ 1,372,900$ (183,933)$ 4,395$ (739,335)$
Village of Oak Brook
General Fund Financial Update
For the Period Ending November 30, 2018
Total Total
Revenues Expenditures
11/30/18 Actual 23,426,755$ 22,630,486$
11/30/17 Actual 21,918,171$ 20,371,798$
% Change From Last Year 6.9%11.1%
Major Revenues Other
Intergov.Licenses &Charges for
Sales Tax Tax Telecom Tax Permits Services
11/30/18 Actual 11,334,935$ 1,207,748$ 5,607,871$ 3,118,063$ 1,099,387$
11/30/17 Actual $ 11,460,477 $ 1,267,802 $ 5,505,114 $ 2,110,500 $ 861,109
% Change From Last Year -1.1%-4.7%1.9%47.7%27.7%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
11/30/18 Actual 15,766,393$ 436,036$ 3,402,731$ 126,239$ 2,899,087$
11/30/17 Actual 14,745,078$ 402,166$ 3,682,463$ 407,412$ 1,134,679$
% Change From Last Year 6.9%8.4%-7.6%-69.0%155.5%
Five Year Trend
Expenditures by Department
11/30/17 11/30/18 11/30/18 11/30/18 2018 Difference Five
YTD YTD YTD % of Annual Prior Year
Department Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 2,356,639$ 2,098,138$ 2,489,920$ 84.3%2,673,305$ (258,501)$
Financial Services 1,029,734 769,539 1,052,725 73.1%1,117,875 (260,195)
Public Works 589,225 632,169 946,150 66.8%993,820 42,944
Engineering & Capital Projects 804,566 2,713,198 2,617,298 103.7%2,732,665 1,908,632
Library 819,747 811,361 824,365 98.4%889,845 (8,386)
Police 7,441,091 7,778,552 8,073,090 96.4%8,705,350 337,461
Fire 6,435,345 6,974,087 7,504,625 92.9%8,043,215 538,742
Development Services 895,451 853,442 923,945 92.4%995,425 (42,009)
Total Expenditures 20,371,798$ 22,630,486$ 24,432,118$ 92.6%26,151,500$ 2,258,688$
Five Year Trend
For the Period Ending November 30, 2018
General Fund - Five Year Trend
Village of Oak Brook
Revenues Expenditures
11/30/18 11/30/18
11/30/17 11/30/18 YTD % of 2018 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Hotel Tax 1,168,277$ 1,211,754$ 1,225,000$ 98.9%1,340,000$ 43,477$
Interest 44,896 74,427 27,500 270.6%30,000 29,531
Miscellaneous 44,095 5,200 - N/A - (38,895)
Total Operating Revenues 1,257,268$ 1,291,381$ 1,252,500$ 103.1%1,370,000$ 34,113$
EXPENDITURES
Operation and Contract 386,068$ 459,489$ 596,780$ 77.0%646,515$ 73,421$
Other Expenditures 85,613 91,245 91,250 100.0%99,550 5,632
Capital Outlay 952,226 6,323 640,000 1.0%640,000 (945,903)
Total Expenditures 1,423,907$ 557,057$ 1,328,030$ 41.9%1,386,065$ (866,850)$
NET FUND INCREASE (DECREASE)(166,639)$ 734,324$ (75,530)$ (16,065)$ 900,963$
Note - Expenditures are recorded in program 171.
Village of Oak Brook
Hotel Tax Fund Financial Update
For the Period Ending November 30, 2018
Total Total
Revenues Expenditures
11/30/18 Actual $ 1,291,381 557,057$
11/30/17 Actual $ 1,257,268 1,423,907$
% Change From Last Year 2.7%-60.9%
Major Revenues
Grants Hotel Tax Interest Miscellaneous
11/30/18 Actual $ - $ 1,211,754 $ 74,427 $ 5,200
11/30/17 Actual $ - $ 1,168,277 $ 44,896 $ 44,095
% Change From Last Year 0.0%3.7%65.8%-88.2%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures Capital Outlay
11/30/18 Actual 459,489$ 91,245$ 6,323$
11/30/17 Actual 386,068$ 85,613$ 952,226$
% Change From Last Year 19.0%6.6%-99.3%
Five Year Trend
Village of Oak Brook
Hotel Tax Fund - Major Sources Five Year Trend
For the Period Ending November 30, 2018
Five Year Trend
Revenues Expenditures
11/30/18 11/30/18
11/30/17 11/30/18 YTD % of 2018 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 5,223,472$ 5,116,088$ 5,097,250$ 100.4%5,563,000$ (107,384)$
Grants 3,142 - - 0.0%- (3,142)
Interest 70,814 161,004 38,500 418.2%42,000 90,190
Miscellaneous 5,745 2,729 4,575 59.7%5,000 (3,016)
Total Operating Revenues 5,303,173$ 5,279,821$ 5,140,325$ 102.7%5,610,000$ (23,352)$
OPERATING EXPENDITURES
Personnel 1,049,797$ 1,099,219$ 1,243,310$ 88.4%1,365,445$ 49,422$
Materials and Supplies 87,050 115,395 174,715 66.0%182,955 28,345
Operation and Contract 1,397,177 1,123,349 1,385,020 81.1%1,484,755 (273,828)
Other Expenditures 148,962 151,129 151,130 100.0%164,865 2,167
Capital Outlay 396,293 1,012,576 5,027,040 20.1%5,625,620 616,283
Total Operating Expenditures 3,079,279$ 3,501,668$ 7,981,215$ 43.9%8,823,640$ 422,389$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 2,223,894$ 1,778,153$ (2,840,890)$ -62.6%(3,213,640)$ (445,741)$
INTERFUND TRANSACTIONS
Transfers In 389,604$ 7,790$ 500,000$ 1.6%500,000$ (381,814)$
Reimbursements From Other Funds 161,920 166,034 166,040 100.0%181,130 4,114
Total Interfund Transactions 551,524$ 173,824$ 666,040$ 26.1%681,130$ (377,700)$
NET FUND INCREASE (DECREASE)2,775,418$ 1,951,977$ (2,174,850)$ (2,532,510)$ (823,441)$
Village of Oak Brook
Infrastructure Fund Financial Update
For the Period Ending November 30, 2018
Total Total
Revenues Expenditures
11/30/18 Actual $ 5,279,821 3,501,668$
11/30/17 Actual $ 5,303,173 3,079,279$
% Change From Last Year -0.4%13.7%
Major Revenues
Sales Tax Grants Interest Miscellaneous Reimbursements
11/30/18 Actual $ 5,116,088 $ - $ 161,004 $ 2,729 $ 166,034
11/30/17 Actual $ 5,223,472 $ 3,142 $ 70,814 $ 5,745 $ 161,920
% Change From Last Year -2.1%-100.0%127.4%-52.5%2.5%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
11/30/18 Actual 1,099,219$ 115,395$ 1,123,349$ 151,129$ 1,012,576$
11/30/17 Actual 1,049,797$ 87,050$ 1,397,177$ 148,962$ 396,293$
% Change From Last Year 4.7%32.6%-19.6%1.5%155.5%
Five Year Trend
Expenditures by Department
11/30/17 11/30/18 11/30/18 11/30/18 2018 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 153,311$ 144,231$ 164,915$ 87.5%178,530$ (9,080)$
Public Works 2,102,070 1,939,100 2,408,640 80.5%2,592,335 (162,970)
Engineering & Capital Projects 823,898 1,418,337 5,407,660 26.2%6,052,775 594,439
Total Expenditures 3,079,279$ 3,501,668$ 7,981,215$ 43.9%8,823,640$ 422,389$
Five Year Trend
Village of Oak Brook
Infrastructure Fund - Major Sources Five Year Trend
For the Period Ending November 30, 2018
Revenues Expenditures
11/30/18 11/30/18
11/30/17 11/30/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 677 1,531 230 665.7%250 854
Total Operating Revenues 451,636$ 442,040$ 453,530$ 97.5%487,750$ (9,596)$
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,702)$ (51,358)$ (10,380)$ 23,840$ (44,656)$
Note - Expenditures are recorded in program 283.
Village of Oak Brook
Promenade TIF Fund Financial Update
For the Period Ending November 30, 2018
Total Total
Revenues Expenditures
11/30/18 Actual $ 442,040 493,398$
11/30/17 Actual $ 451,636 458,338$
% Change From Last Year -2.1%7.6%
Major Revenues Real Estate
Sales Tax Tax Interest
11/30/18 Actual $ 67,242 $ 373,267 $ 1,531
11/30/17 Actual $ 65,941 $ 385,018 $ 677
% Change From Last Year 2.0%-3.1%126.1%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures
11/30/18 Actual 3,578$ 489,820$
11/30/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 November 30, 2018
Five Year Trend
Revenues Expenditures
11/30/18 11/30/18
11/30/17 11/30/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 2,089 825 1,825 45.2%2,000 (1,264)
Building/Inspection Fees 11,614 7,838 4,580 171.1%5,000 (3,776)
Water Sales 9,132,372 9,181,582 9,400,425 97.7%9,730,425 49,210
Unmetered Sales 47,413 36,462 27,500 132.6%30,000 (10,951)
Water Connection Fees 182,850 112,054 45,800 244.7%50,000 (70,796)
Fire Service Charge - - 4,580 0.0%5,000 -
Meter Charges 21,112 10,235 22,925 44.6%25,000 (10,877)
Special Services 15,286 32,218 30,000 107.4%30,000 16,932
Interest on Investments 36,493 92,947 9,175 1013.0%10,000 56,454
Miscellaneous 73,083 73,593 45,830 160.6%50,000 510
Total Operating Revenues 9,525,698$ 9,547,754$ 9,592,640$ 99.5%9,937,425$ 22,056$
EXPENDITURES
Personnel 714,804$ 675,017$ 753,915$ 89.5%817,490$ (39,787)$
Materials and Supplies 55,904 61,428 71,485 85.9%76,860 5,524
Operation and Contract 4,820,381 4,674,354 6,218,055 75.2%6,780,015 (146,027)
Other Expenditures 368,137 371,404 371,410 100.0%405,170 3,267
Capital Outlay 67,741 1,970,033 2,512,685 78.4%2,710,220 1,902,292
Total Expenditures 6,026,967$ 7,752,236$ 9,927,550$ 78.1%10,789,755$ 1,725,269$
NET FUND INCREASE (DECREASE)3,498,731$ 1,795,518$ (334,910)$ (852,330)$ (1,703,213)$
Village of Oak Brook
Water Fund Financial Update
For the Period Ending November 30, 2018
Total Total
Revenues Expenditures
11/30/18 Actual $ 9,547,754 7,752,236$
11/30/17 Actual $ 9,525,698 6,026,967$
% Change From Last Year 0.2%28.6%
Unmetered Water
Water Sales Sales Connection Fees Meter Charges Miscellaneous
11/30/18 Actual $ 9,181,582 $ 36,462 $ 112,054 $ 10,235 $ 73,593
11/30/17 Actual $ 9,132,372 $ 47,413 $ 182,850 $ 21,112 $ 73,083
% Change From Last Year 0.5%-23.1%-38.7%-51.5%0.7%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
11/30/18 Actual 675,017$ 61,428$ 4,674,354$ 371,404$ 1,970,033$
11/30/17 Actual 714,804$ 55,904$ 4,820,381$ 368,137$ 67,741$
% Change From Last Year -5.6%9.9%-3.0%0.9%2808.2%
Five Year Trend
Expenditures by Department
11/30/17 11/30/18 11/30/18 11/30/18 2018 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Public Works 5,948,572$ 5,738,892$ 7,464,450$ 76.9%8,124,535$ (209,680)$
Engineering & Capital Projects 78,395 2,013,344 2,463,100 81.7%2,665,220 1,934,949
Total Expenditures 6,026,967$ 7,752,236$ 9,927,550$ 78.1%10,789,755$ 1,725,269$
Five Year Trend
Village of Oak Brook
Water Fund - Major Sources Five Year Trend
For the Period Ending November 30, 2018
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Sports Core Fund Consolidated Presentation
For the Period Ending November 30, 2018
11/30/18 11/30/18
11/30/18 YTD % of 2018 11/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$ -$ 205,300$ 434,674$ 414,775$ 104.8%414,875$ 415,153$ 19,521$
Greens Fees - - 877,007 877,007 974,800 90.0%975,000 937,814 (60,807)
Pro Shop Sales - - 184,012 184,012 199,315 92.3%200,000 175,595 8,417
Golf Lessons - - 36,705 36,705 40,000 91.8%40,000 43,359 (6,654)
Driving Range Fees - - 216,724 216,724 235,000 92.2%235,000 236,240 (19,516)
Rentals - - 401,969 401,969 448,975 89.5%451,000 362,364 39,605
Programs/User Fees 250,897 - - 250,897 300,700 83.4%300,700 368,173 (117,276)
Food Sales - 157,331 - 157,331 145,500 108.1%145,500 176,908 (19,577)
Beverage Sales - 229,166 - 229,166 234,815 97.6%236,000 267,271 (38,105)
Other Revenue 188,315 251,679 6,677 446,671 377,580 118.3%380,650 399,245 47,426
Total Direct Revenues 668,586$ 638,176$ 1,928,394$ 3,235,156$ 3,371,460$ 96.0%3,378,725$ 3,382,122$ (146,966)$
DIRECT EXPENDITURES
Personnel 150,297$ 242,643$ 1,070,034$ 1,462,974$ 1,421,900$ 102.9%1,497,200$ 1,431,766$ 31,208$
Materials & Supplies 19,334 180,372 363,863 563,569 613,410 91.9%615,885 572,104 (8,535)
Operational & Contractual 698,972 125,011 231,540 1,055,523 947,385 111.4%961,510 1,008,440 47,083
Other - - (128,577) (128,577) (53,085) 242.2%(44,275) (186,200) 57,623
Capital 91,588 11,988 167,627 271,203 651,160 41.6%365,660 216,288 54,915
Total Direct Expenditures 960,191$ 560,014$ 1,704,487$ 3,224,692$ 3,580,770$ 90.1%3,395,980$ 3,042,398$ 182,294$
Direct Revenues Over (Under) Expenditures (291,605)$ 78,162$ 223,907$ 10,464$ (209,310)$ -5.0%(17,255)$ 339,724$ (329,260)$
B&T Administration Overhead Allocation*117,450$ (117,450)$ -$ -$ -$ 0.0%-$ -$ -$
Operating Revenues Over (Under) Expenditures (174,155)$ (39,288)$ 223,907$ 10,464$ (209,310)$ -5.0%(17,255)$ 339,724$ (329,260)$
Interfund Loan**-$ -$ -$ -$ -$ 0.0%-$ -$ -$
Transfer From General Fund - - - - - 0.0%- - -
Transfer From Golf Surcharge Fund - - 11,039 11,039 285,500 3.9%- - 11,039
Reimbursement From Infrastructure Fund 22,000 - - 22,000 22,000 100.0%24,000 22,000 -
Reimbursement From Water Fund 7,337 - - 7,337 7,315 100.3%8,000 7,337 -
Adjusted Operating Revenues Over (Under) Expenditures (144,818)$ (39,288)$ 234,946$ 50,840$ 105,505$ 14,745$ 369,061$ (318,221)$
*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
11/30/18 Actual $ 3,235,156 3,224,692$
11/30/17 Actual $ 3,382,122 3,042,398$
% Change From Last Year -4.3%6.0%
Driving Program/
Memberships Greens Fees Range Fees Rentals User Fees
11/30/18 Actual $ 434,674 $ 877,007 $ 216,724 $ 401,969 $ 250,897
11/30/17 Actual $ 415,153 $ 937,814 $ 236,240 $ 362,364 $ 368,173
% Change From Last Year 4.7%-6.5%-8.3%10.9%-31.9%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
11/30/18 Actual 1,462,974$ 563,569$ 1,055,523$ (128,577)$ 271,203$
11/30/17 Actual 1,431,766$ 572,104$ 1,008,440$ (186,200)$ 216,288$
% Change From Last Year 2.2%-1.5%4.7%-30.9%25.4%
Five Year Trend
Revenues by Department 11/30/17 11/30/18 11/30/18 11/30/18 2018 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Programs 784,588$ 668,586$ 646,495$ 103.4%712,075$ (116,002)$
Food & Beverage 632,442 638,176 127,800 499.4%569,000 8,134
Golf Club 1,965,092 1,928,394 567,997 339.5%2,097,650 (36,698)
Total Revenues 3,382,122$ 3,235,156$ 1,342,292$ 241.0%3,378,725$ (144,566)$
Expenditures by Department 11/30/17 11/30/18 11/30/18 % of 2018 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Programs 926,838$ 960,191$ 344,363$ 278.8%1,058,430$ 33,353$
Food & Beverage 619,721 560,014 281,968 198.6%514,980 (59,707)
Golf Club 1,495,839 1,704,487 778,751 218.9%1,822,570 208,648
Total Expenditures 3,042,398$ 3,224,692$ 1,405,082$ 229.5%3,395,980$ 182,294$
Five Year Trend
Village of Oak Brook
Sports Core Fund - Major Sources Five Year Trend
For the Period Ending November 30, 2018
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Club Recreation Programs
For the Period Ending November 30, 2018 11/30/18 11/30/18
11/30/18 YTD % of 2018 11/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$ 223,275$ 102.7%223,375$ 222,790$ 6,584$
Programs/User Fees - 19,401 31,961 - 199,535 250,897 300,700 83.4%300,700 368,173 (117,276)
Other Revenue (634) 2,621 410 - 185,918 188,315 187,930 100.2%188,000 193,625 (5,310)
Total Revenue (634)$ 230,123$ 53,644$ -$ 385,453$ 668,586$ 711,905$ 93.9%712,075$ 784,588$ (116,002)$
Expenditures:
Personnel 97,033$ 20,179$ 27,890$ -$ 5,195$ 150,297$ 197,175$ 76.2%208,040$ 207,808$ (57,511)$
Materials & Supplies 5,602 10,605 2,075 - 1,052 19,334 27,895 69.3%28,280 37,914 (18,580)
Operational & Contractual 75,385 286,186 71,023 20,000 246,378 698,972 583,195 119.9%586,160 629,595 69,377
Other - - - - - - 51,515 0.0%56,200 - -
Capital 38,845 52,154 - - 589 91,588 106,000 86.4%179,750 51,521 40,067
Total Expenditures 216,865$ 369,124$ 100,988$ 20,000$ 253,214$ 960,191$ 965,780$ 99.4%1,058,430$ 926,838$ 33,353$
Direct Revenues Over (Under) Expenditures (217,499)$ (139,001)$ (47,344)$ (20,000)$ 132,239$ (291,605)$ (253,875)$ 114.9%(346,355)$ (142,250)$ (149,355)$
B&T Administration Overhead Allocation*217,500$ (78,300)$ (21,750)$ -$ -$ 117,450$ 167,600$ 70.1%207,995$ 159,840$ (42,390)$
Revenues Over (Under) Expenditures 1$ (217,301)$ (69,094)$ (20,000)$ 132,239$ (174,155)$ (86,275)$ 201.9%(138,360)$ 17,590$ (191,745)$
Reimbursement From Infrastructure Fund 22,000$ -$ -$ -$ -$ 22,000$ 22,000$ 100.0%24,000$ 22,000$ -$
Reimbursement From Water Fund 7,337 - - - - 7,337 7,315 100.3%8,000 7,337 -
Adjusted Revenues Over (Under) Expenditures 29,338$ (217,301)$ (69,094)$ (20,000)$ 132,239$ (144,818)$ (56,960)$ (106,360)$ 46,927$ (191,745)$
*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 November 30, 2018
11/30/18 11/30/18
821 822 823 11/30/18 YTD % of 2018 11/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.0%-$ 2,400$ -$
Food Sales - 34,693 122,638 157,331 145,500 108.1%145,500 176,908 (19,577)
Beverage Sales - 18,467 210,699 229,166 234,815 97.6%236,000 267,271 (38,105)
Other Revenue 251,679 - - 251,679 184,500 136.4%187,500 185,863 65,816
Total Revenue 251,679$ 53,160$ 333,337$ 638,176$ 564,815$ 113.0%569,000$ 632,442$ 8,134$
Expenditures:
Personnel 107,287$ 24,003$ 111,353$ 242,643$ 190,330$ 127.5%199,505$ 213,802$ 28,841$
Materials & Supplies 12,555 16,059 151,758 180,372 181,660 99.3%182,150 203,351 (22,979)
Operational & Contractual 117,628 1,272 6,111 125,011 124,850 100.1%133,325 107,818 17,193
Capital 11,988 - - 11,988 73,750 16.3%- 94,750 (82,762)
Total Expenditures 249,458$ 41,334$ 269,222$ 560,014$ 570,590$ 98.1%514,980$ 619,721$ (59,707)$
Direct Revenues Over (Under) Expenditures 2,221$ 11,826$ 64,115$ 78,162$ (5,775)$ -1353.5%54,020$ 12,721$ 65,441$
B&T Administration Overhead Allocation*(108,750)$ (8,700)$ -$ (117,450)$ (167,600)$ 70.1%(175,995)$ (159,840)$ 42,390$
Revenues Over (Under) Expenditures (106,529)$ 3,126$ 64,115$ (39,288)$ (173,375)$ 22.7%(121,975)$ (147,119)$ 107,831$
Transfer From General Fund -$ -$ -$ -$ -$ 0.0%-$ -$ -$
Adjusted Revenues Over (Under) Expenditures (106,529)$ 3,126$ 64,115$ (39,288)$ (173,375)$ (121,975)$ (147,119)$ 107,831$
*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 November 30, 2018
11/30/18 11/30/18
831 832 833 834 11/30/18 YTD % of 2018 11/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 205,300$ -$ -$ -$ 205,300$ 191,500$ 107.2%191,500$ 189,963$ 15,337$
Greens Fees 877,007 - - - 877,007 974,800 90.0%975,000 937,814 (60,807)
Pro Shop Sales 184,012 - - - 184,012 199,315 92.3%200,000 175,595 8,417
Golf Lessons - 36,705 - - 36,705 40,000 91.8%40,000 43,359 (6,654)
Driving Range Fees - 216,724 - - 216,724 235,000 92.2%235,000 236,240 (19,516)
Rentals 3,420 70,000 328,549 - 401,969 448,975 89.5%451,000 362,364 39,605
Other Revenue 6,677 - - - 6,677 5,150 129.7%5,150 19,757 (13,080)
Total Revenue 1,276,416$ 323,429$ 328,549$ -$ 1,928,394$ 2,094,740$ 92.1%2,097,650$ 1,965,092$ (36,698)$
Expenditures:
Personnel 441,307$ 54,954$ 53,389$ 520,384$ 1,070,034$ 1,034,395$ 103.4%1,089,655$ 1,010,156$ 59,878$
Materials & Supplies 143,773 19,579 343 200,168 363,863 403,855 90.1%405,455 330,839 33,024
Operational & Contractual 166,166 14,058 2,205 49,111 231,540 239,340 96.7%242,025 271,027 (39,487)
Other - - 49,573 (178,150) (128,577) (104,600) 122.9%(100,475) (186,200) 57,623
Capital 46,934 - 40,922 79,771 167,627 471,410 35.6%185,910 70,017 97,610
Total Expenditures 798,180$ 88,591$ 146,432$ 671,284$ 1,704,487$ 2,044,400$ 83.4%1,822,570$ 1,495,839$ 208,648$
Direct Revenues Over (Under) Expenditures 478,236$ 234,838$ 182,117$ (671,284)$ 223,907$ 50,340$ 444.8%275,080$ 469,253$ (245,346)$
Transfer from General Fund -$ -$ -$ -$ -$ -$ 0.0%-$ -$ -
Transfer from Golf Surcharge 11,039 - - - 11,039 285,500 3.9%- - 11,039
Adjusted Revenues Over (Under) Expenditures 489,275$ 234,838$ 182,117$ (671,284)$ 234,946$ 335,840$ 275,080$ 469,253$ (234,307)$