12 - December 2018 Monthly Financial ReportVILLAGE
OAK BROOK
OF
MONTHLY FINANCIAL REPORTS
DECEMBER 2018
ITEM 6.E
Total
Cash and Cash Pooled Cash and
Fund Equivalents Investments Investments % By Fund
General Corporate $4,750,938 $13,337,233 $18,088,171 42.2%
Hotel/Motel Tax 2,290,114 2,530,485 4,820,599 11.3%
Motor Fuel Tax 604,229 177,974 782,203 1.8%
Infrastructure 6,078,199 3,277,497 9,355,696 21.9%
Promenade TIF 225,250 - 225,250 0.5%
Water 4,746,202 1,703,113 6,449,315 15.1%
Sports Core 201,758 - 201,758 0.5%
Golf Surcharge 478 458,504 458,982 1.1%
Self-Insurance 468,568 - 468,568 1.1%
Garage 330,334 - 330,334 0.8%
Equipment Replacement 625,646 1,008,939 1,634,585 3.8%
Total $20,321,716 $22,493,745 $42,815,461 100.0%
Change in Cash and Investments by Fund :
Balance at Balance at Year-to-Date Year-to-Date
Fund January 1, 2018 December 31, 2018 Change ($)Change (%)
General Corporate $17,679,496 $18,088,171 $408,675 2.3%
Hotel/Motel Tax 4,172,234 4,820,599 648,365 15.5%
Motor Fuel Tax 574,460 782,203 207,743 36.2%
Infrastructure 8,222,145 9,355,696 1,133,551 13.8%
Promenade TIF 276,164 225,250 (50,914)-18.4%
Water 5,693,109 6,449,315 756,206 13.3%
Sports Core 472,473 201,758 (270,715)-57.3%
Golf Surcharge 559,073 458,982 (100,091)-17.9%
Self-Insurance 45,042 468,568 423,526 940.3%
Garage 427,409 330,334 (97,075)-22.7%
Equipment Replacement 1,805,752 1,634,585 (171,167)-9.5%
$39,927,358 $42,815,461 $2,888,103 7.2%
Book Market
Value Value
Pooled Checking $954,472 $954,472
Sports Core Checking 111,570 111,570
Pooled IPTIP 19,245,958 19,245,958
Water E-Pay IPTIP 9,716 9,716
$20,321,716 $20,321,716
Pooled Investments:
Investments-Municipal Bonds $7,065,497 $6,983,225
Investments-Corporate Bonds 7,891,851 7,883,870
Government & Agency Obligations 695,486 666,263
Certificates of Deposit 6,720,000 6,662,275
Accrued Interest 120,911 120,911
Total Pooled Investments $22,493,745 $22,316,544
Total Cash and Investments $42,815,461 $42,638,260
For December, total interest revenue is $83,371 and YTD interest revenue is $797,346.
Total investment yield for the portfolio is:
Pooled
Investments Illinois Funds Total
Monthly yield 0.19%0.21%0.19%
YTD yield 1.94%1.90%1.73%
Last 12 months yield 1.94%1.90%1.85%
The weighted average yield of the current pooled investment portfolio is 2.27%.
Monthly Treasurer's Report
December 31, 2018
Monthly Treasurer's Report
December 2018
The table below lists the detail investment holdings at J.P. Morgan Securities as of 12/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,969 $99,739 $169
Rosemont IL GO Corp #777543UT4 02/08/16 12/01/19 3.021%2.000%504,574 497,465 1,163
New York N Y City #64971QTX1 02/22/16 05/01/21 2.350%2.000%201,578 198,406 769
Florida Hurricane #34074GDH4 03/30/16 07/01/20 2.995%2.150%506,139 500,655 7,487
Bloomingdale Mich Pub Sch Dist #094383FS0 04/26/16 05/01/22 2.710%2.150%508,935 495,710 2,219
Milan Mich Area Achs #598801JD1 05/26/16 05/01/20 1.931%1.931%245,000 242,283 688
Indiana Bd Bk Rev Taxable #4546248F7 01/06/17 01/15/20 2.934%1.900%257,673 254,911 3,463
Garland Cnty Ark Sales & Use #36609PAN3 02/06/17 11/01/19 1.795%1.840%499,812 496,005 1,621
Anchor Bay Mich Sch Dist GO #032879TA6 02/13/17 05/01/19 1.810%1.420%365,476 363,989 1,024
Lanse Creuse Mich Pub Schs #516228RL9 05/02/17 05/01/20 2.159%2.159%100,000 99,160 358
California St GO Bonds #13063A7G3 05/08/17 10/01/19 6.200%1.600%517,150 512,525 7,468
*Genesee Cnty Mich #371608UV0 05/31/17 10/01/19 2.681%2.681%171,000 171,017 250
Connecticut St GO Bds 2016 #20772J3F7 06/15/17 08/15/21 1.750%2.300%493,036 483,930 3,252
North Carolina Eastn Mun Pwr #65819WAL7 10/02/17 07/01/19 2.578%1.700%502,194 499,370 6,302
Fowlerville Mich Comnty Schs #351280MS8 10/03/17 05/01/20 2.045%1.750%501,946 495,450 1,534
Racine Cnty WI #749845UK7 12/20/17 12/01/20 2.150%2.150%750,000 738,023 1,344
Wisconsin St Gen Fd Annual #977100CW4 01/05/18 05/01/20 1.446%2.100%594,834 588,504 1,350
Illinois St G/O #452152HU8 04/03/18 03/01/19 5.877%3.000%246,181 246,083 4,680
Total Municipal Bonds $7,065,497 $6,983,225 $45,141
Corporate Bonds:
Wells Fargo #94974BFQ8 04/25/18 01/15/19 2.150%2.330%$1,389,879 $1,389,596 $13,697
Huntington National Bank #446438RG0 07/06/18 04/01/19 2.200%2.541%699,395 698,635 3,807
Bank of America #06051GFD6 07/06/18 04/01/19 2.650%2.509%750,266 749,212 4,527
KeyBank #49327M2N3 07/19/18 03/08/19 2.350%2.490%844,771 843,910 6,178
Bank of America #06051GFD6 07/30/18 04/01/19 2.650%2.420%245,134 244,743 1,623
Morgan Stanley #61746BDM5 08/03/18 01/24/19 2.500%2.430%1,000,038 999,590 10,764
Goldman Sachs #38141GVP9 09/26/18 09/15/20 2.750%3.180%496,454 494,830 4,010
Fifth Third #31677QBH1 10/11/18 09/27/19 1.625%2.750%991,840 989,490 4,243
JP Morgan #46640QUV1 11/01/18 07/29/19 0.000%3.017%1,474,074 1,473,864 0
Total Corporate Bonds $7,891,851 $7,883,870 $48,849
Government & Agency Obligations:
**Government National Mtg Assn #38379UEM4 02/29/16 02/16/51 2.300%2.245%$695,486 $666,263 $2,089
Total Government & Agency Obligations:$695,486 $666,263 $2,089
Certificates of Deposit:
State Bk India NY #8562846A7 01/26/17 01/26/22 2.250%2.250%$245,000 $238,049 $2,396
American Express Fed Svgs #02587CER7 05/10/17 11/12/19 1.700%1.700%245,000 242,979 573
Marlin Bank #57116ANU8 05/10/17 11/12/19 1.610%1.610%245,000 242,761 217
Synchrony Bank #87164WRA8 05/26/17 05/28/19 1.650%1.650%245,000 244,130 354
Umpqua Bank #90421MAG8 05/31/17 05/31/19 1.600%1.600%245,000 244,057 332
Stone Bk Mtn View Ark #86158RAJ8 06/28/17 06/28/19 1.600%1.600%245,000 243,853 17
TIAA FSB Jacksonville #87270LAA1 07/19/17 07/19/19 1.600%1.600%245,000 243,706 1,764
Peoples United Bank #71270QQZ2 07/19/17 07/19/19 1.650%1.650%245,000 243,773 1,819
Priority Bank Ozark Ark #74269KBR6 07/26/17 07/26/19 1.600%1.600%245,000 243,648 45
American Express Centurion #02587DV96 08/15/17 08/17/20 1.900%1.900%245,000 240,617 1,746
Sallie Mae #795450C86 08/16/17 08/17/20 1.900%1.900%245,000 240,977 1,746
Merrick Bank South Jordan #59013JZS1 08/21/17 08/21/20 1.800%1.800%245,000 240,531 118
Pinnacle Bank #72345SFS5 08/30/17 08/31/20 1.800%1.800%115,000 112,851 4
Jackson County Bank #466682AP6 08/31/17 03/01/21 1.850%1.850%245,000 238,699 1,511
Barclays Bank #06740KKX4 09/27/17 09/28/20 1.950%1.950%245,000 240,766 1,234
Capital One Bank #1404205E6 10/04/17 10/04/19 1.700%1.700%245,000 243,307 995
Transportation Alliance #89388CCB2 10/13/17 04/12/19 1.600%1.600%235,000 234,415 176
Goldman Sachs Bank #38148PRK5 10/18/17 10/19/20 1.950%1.950%245,000 240,541 956
FirstBank PR Santurce #33767A6M8 11/03/17 11/03/20 2.000%2.000%245,000 240,585 359
Morgan Stanley #61747MQ53 03/22/18 03/23/20 2.550%2.550%245,000 244,255 1,675
Investors Community Bank #46147UTT7 08/28/18 02/28/20 2.550%2.550%245,000 244,358 29
Lakeside Bank #51210SPS0 08/30/18 03/30/20 2.550%2.550%245,000 244,223 12
Bank United #066519GJ2 08/31/18 02/20/20 2.500%2.500%245,000 244,214 2,042
Compass Bank #20451PVW3 10/26/18 10/26/20 3.000%3.000%245,000 244,995 1,307
UBS Bank #90348JFH8 10/30/18 10/29/20 3.050%3.050%245,000 245,208 17
Citibank #17294XJP2 10/31/18 10/31/20 3.000%3.000%245,000 244,900 1,245
Discover Bank #254673WF9 11/07/18 11/09/20 3.000%3.000%245,000 244,939 1,082
Ally Bank #02007GFX6 11/08/18 11/09/20 3.000%3.000%245,000 244,938 1,061
Total Certificates of Deposits $6,720,000 $6,662,275 $24,832
Total J.P.Morgan Securities $22,372,834 $22,195,633 $120,911
*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
December 31, 2018
Cash & Investments by Fund - Total $42.8 million
Cash & Investments by Type - Total $42.8 million
Checking
Illinois Funds
Certificates of Deposit
Municipal Bonds
Corporate Bonds
Government & Agency Obligations
Accrued Interest
General Corporate
42.25%
Hotel/Motel Tax
11.26%Motor Fuel Tax
1.83%
Infrastructure
21.85%
Promenade TIF
0.53%
Water
15.06%
Sports Core
0.47%
Golf Surcharge
1.07%
Self-Insurance
1.09%Garage
0.77%
Equipment
Replacement
3.82%
Checking, $1.1
Illinois Funds, $19.2
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 December 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
Total revenues through December 2018 are $1,478,456 higher than last year and $2,331,806
over budget.
o Sales tax revenue, the General Fund’s largest revenue source, is down $178,201 from
last year and $133,702 under budget. This is due to the closure of two large taxpayers
in late 2017.
o Other intergovernmental tax revenue is down $52,697 from last year, but $137,265 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 $96,662 from last year and $313,537 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 $978,653 from last year and $1,390,695 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 December 2018 are $1,758,435 higher than last year, but
$1,245,851 under budget.
o Personnel expenditures are up $487,562 from last year, but $349,917 under budget.
The increase is due to general wage and benefits increases.
o Operation and contract expenditures are down $231,336 from last year and $509,970
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,762,981 from last year, but $70,769 under
budget. The increase is due to the Police Department expansion project in 2018.
Hotel Tax Fund
Total revenues through December 2018 are $24,781 higher than last year and $36,764 over
budget.
o Hotel tax revenue is up $30,086 from last year, but $22,027 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 $33,590 from last year and $53,591 over budget. This is
due to favorable market conditions and rising interest rates.
•Total expenditures through December 2018 are $893,612 lower than last year and $820,654
under budget.
o Operation and contract expenditures are up $73,424 from last year, but $186,977 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 $973,186 from last year and $633,677 under
budget. This is due to the timing of projects scheduled.
Motor Fuel Tax Fund
•Total revenues through December 2018 are up $2,544 from last year and $5,372 over budget.
Motor Fuel Tax receipts are slightly under budget, but are offset by increases in interest income.
•Total expenditures through December 2018 are down $403,234 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 December 2018 are down $36,879 from last year, but $132,710 over
budget.
o Non‐home rule sales tax revenue is down $130,241 from last year and $2,926 under
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 $99,520 from last year and $137,907 over budget. This is
due to favorable market conditions and rising interest rates.
•Total expenditures through December 2018 are up $1,334,844 from last year, but $4,070,232
under budget.
o Personnel expenditures are up $56,333 from last year, but $166,376 under budget.
Personnel is under budget due to employee turnover.
o Operation and contract expenditures are down $241,580 from last year and $237,647
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 $1,471,111 from last year, but $3,620,626 under
budget. This is due to the timing of roadway improvement projects.
Promenade TIF Fund
•Total revenues through December 2018 are down $9,400 from last year and $45,266 under
budget. This is due to a decrease in real estate tax revenue from last year and a delay in the
third sales tax transfer.
•Total expenditures through December 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 December 2018 are up $18,762 from last year, but $46,098 under
budget.
o Water sales revenue is up $38,680 from last year, but $245,553 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 December 2018 are up $1,789,748 from last year, but $2,450,202
under budget.
o Operation and contract expenditures are down $196,896 from last year and $1,769,201
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 $2,032,139 from last year, but $582,150 under
budget. The increase relates to the start of the Village‐wide water meter replacement
project.
Sports Core Fund
Total revenues through December 2018 are down $161,231 from last year and $126,855 under
budget.
o Memberships are up $19,521 from last year and $19,799 over budget. Memberships
from both B&T and Golf are up in 2018 compared to last year.
o Greens Fees are down $65,278 from last year and $97,772 under budget. Rounds
played are down in 2018 due to unfavorable weather conditions.
o Rentals are up $37,402 from last year, but $49,035 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,726 from last year and $48,253 under budget. This
is due to the Village contracting the Park District to run swim lessons and programs in
2018.
Total expenditures through December 2018 are up $544,751 from last year and $77,859 over
budget.
o Personnel expenditures are up $9,428 from last year and $37,991 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 Operation and Contractual expenditures are up $28,797 from last year and $116,604
over budget. This is due to the outsourcing of swim operations to the Park District.
o Capital outlay expenditures are up $449,255 from last year and $19,741 over budget.
This is due to the B&T Electrical upgrade project and Golf patio construction.
Golf Surcharge Fund
Total operating revenues through December 2018 are down $9,287 from last year and $6,333
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 $217,258 through December 2018 has been transferred to the Sports Core Fund to
pay for the golf course patio renovation project.
Self Insurance Fund
Total revenues through December 2018 are up $128,442 from last year, but $43,967 under
budget. The increase is due to a rate increase effective July 1, 2018. Revenue is under budget
due retirees moving to a new insurance plan in FY18 with some not continuing on the Village’s
plan.
Total expenditures through December 2018 are down $549,499 from last year and $499,376
under budget. This is due to the timing of invoices paid and health claims coming in lower than
projected.
Garage Fund
Total revenues through December 2018 are down $129,328 from last year, but $6,202 over
budget. This is due to a budgeted reduction in maintenance charges to use available net
position reserves.
Total expenditures through December 2018 are up $55,538 from last year and $140,159 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 December 2018 are down $317,755 from last year, but $82,007 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 December 2018 are up $660,053 from last year, but $68,244 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)25,928,236 $25,074,147 $854,089 ($164,103)
Main operating fund of the Village.
Hotel Fund (Major Fund)$1,406,764 $565,411 $841,353 ($16,065)
Collects and spends resources from the
3% hotel/motel tax.
Motor Fuel Tax Fund $215,532 $7,790 $207,742 ($289,840)
Collects and spends resources from the
State motor fuel tax.
Infrastructure Fund (Major Fund)$5,931,630 $4,753,408 $1,178,222 ($2,532,510)
Accounts for construction and maintenance of
roadways, drainage, and safety path systems.
Promenade TIF Fund (Major Fund)$442,484 $493,398 ($50,914)$23,840
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,891,327 $8,339,553 $1,551,774 ($852,330)
Collects user fees for the distribution of water
and maintenance of infrastructure.
Sports Core Fund (Major Fund)$3,501,128 $3,759,339 ($258,211)$14,745
Accounts for revenues and expenses relating
to administration, programs, food and beverage
operations, and golf course.
Golf Surcharge Fund $117,167 $217,258 ($100,091)($162,000)
Accounts for the collection of the $3 per round
golf surcharge.
Internal Service Funds
Self Insurance Fund $3,215,363 $2,818,544 $396,819 ($58,590)
Accounts for the Village's health insurance costs
and the related contributions from the Village,
employees, retirees, and other agencies.
Garage Fund $618,932 $657,021 ($38,089)($184,450)
Accounts for the maintenance of the Village's vehicle
fleet and the related departmental reimbursements.
Equipment Replacement Fund $484,947 $591,591 ($106,644)($256,895)
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 December 31, 2018
12/31/18 12/31/18
12/31/17 12/31/18 YTD % of 2018 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 12,497,499$ 12,319,298$ 12,453,000$ 98.9%12,453,000$ (178,201)$
Other Intergovernmental Tax 1,334,662 1,281,965 1,144,700 112.0%1,144,700 (52,697)
Telecommunications/Utility Tax 6,009,125 6,105,787 5,792,250 105.4%5,792,250 96,662
Licenses and Permits 2,196,112 3,174,765 1,784,070 178.0%1,784,070 978,653
Charges for Services 1,028,509 1,291,599 1,017,100 127.0%1,017,100 263,090
Fines and Penalties 142,394 185,500 150,500 123.3%150,500 43,106
Administrative Towing Fees 39,915 31,475 35,000 89.9%35,000 (8,440)
Interest on Investments 233,804 357,100 195,000 183.1%195,000 123,296
Franchise/IMF Maint. Fee 162,548 163,465 215,000 76.0%215,000 917
Miscellaneous Income 176,152 388,222 180,750 214.8%180,750 212,070
Total Operating Revenues 23,820,720$ 25,299,176$ 22,967,370$ 110.2%22,967,370$ 1,478,456$
OPERATING EXPENDITURES
Personnel 17,112,781$ 17,600,343$ 17,950,260$ 98.1%17,953,350$ 487,562$
Materials and Supplies 454,112 474,259 537,820 88.2%532,820 20,147
Operation and Contract 3,998,131 3,766,795 4,276,765 88.1%4,278,675 (231,336)
Other Expenditures 418,100 137,181 388,815 35.3%388,815 (280,919)
Capital Outlay 1,332,588 3,095,569 3,166,338 97.8%2,997,840 1,762,981
Total Operating Expenditures 23,315,712$ 25,074,147$ 26,319,998$ 95.3%26,151,500$ 1,758,435$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 505,008$ 225,029$ (3,352,628)$ (3,184,130)$ (279,979)$
OTHER TRANSACTIONS
Reimbursements From Other Funds 617,300$ 629,060$ 713,360$ 88.2%713,360$ 11,760$
Installment Contract Proceeds - - 2,475,165 0.0%2,475,165 -
Total Interfund Transactions 617,300$ 629,060$ 3,188,525$ 0.0%3,188,525$ 11,760$
NET FUND INCREASE (DECREASE)1,122,308$ 854,089$ (164,103)$ 4,395$ (268,219)$
Village of Oak Brook
General Fund Financial Update
For the Period Ending December 31, 2018
Total Total
Revenues Expenditures
12/31/18 Actual 25,299,176$ 25,074,147$
12/31/17 Actual 23,820,720$ 23,315,712$
% Change From Last Year 6.2%7.5%
Major Revenues Other
Intergov.Licenses &Charges for
Sales Tax Tax Telecom Tax Permits Services
12/31/18 Actual 12,319,298$ 1,281,965$ 6,105,787$ 3,174,765$ 1,291,599$
12/31/17 Actual $ 12,497,499 $ 1,334,662 $ 6,009,125 $ 2,196,112 $ 1,028,509
% Change From Last Year -1.4%-3.9%1.6%44.6%25.6%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
12/31/18 Actual 17,600,343$ 474,259$ 3,766,795$ 137,181$ 3,095,569$
12/31/17 Actual 17,112,781$ 454,112$ 3,998,131$ 418,100$ 1,332,588$
% Change From Last Year 2.8%4.4%-5.8%-67.2%132.3%
Five Year Trend
Expenditures by Department
12/31/17 12/31/18 12/31/18 12/31/18 2018 Difference Five
YTD YTD YTD % of Annual Prior Year
Department Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 2,633,206$ 2,494,171$ 2,673,305$ 93.3%2,673,305$ (139,035)$
Financial Services 1,094,738 835,948 1,117,875 74.8%1,117,875 (258,790)
Public Works 693,058 692,345 993,820 69.7%993,820 (713)
Engineering & Capital Projects 844,438 2,766,218 2,845,013 97.2%2,732,665 1,921,780
Library 878,459 872,564 889,845 98.1%889,845 (5,895)
Police 8,373,617 8,685,489 8,705,350 99.8%8,705,350 311,872
Fire 7,822,048 7,782,814 8,099,365 96.1%8,043,215 (39,234)
Development Services 976,148 944,598 995,425 94.9%995,425 (31,550)
Total Expenditures 23,315,712$ 25,074,147$ 26,319,998$ 95.3%26,151,500$ 1,758,435$
Five Year Trend
For the Period Ending December 31, 2018
General Fund - Five Year Trend
Village of Oak Brook
Revenues Expenditures
12/31/18 12/31/18
12/31/17 12/31/18 YTD % of 2018 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Hotel Tax 1,287,887$ 1,317,973$ 1,340,000$ 98.4%1,340,000$ 30,086$
Interest 50,001 83,591 30,000 278.6%30,000 33,590
Miscellaneous 44,095 5,200 - N/A - (38,895)
Total Operating Revenues 1,381,983$ 1,406,764$ 1,370,000$ 102.7%1,370,000$ 24,781$
EXPENDITURES
Operation and Contract 386,114$ 459,538$ 646,515$ 71.1%646,515$ 73,424$
Other Expenditures 93,400 99,550 99,550 100.0%99,550 6,150
Capital Outlay 979,509 6,323 640,000 1.0%640,000 (973,186)
Total Expenditures 1,459,023$ 565,411$ 1,386,065$ 40.8%1,386,065$ (893,612)$
NET FUND INCREASE (DECREASE)(77,040)$ 841,353$ (16,065)$ (16,065)$ 918,393$
Note - Expenditures are recorded in program 171.
Village of Oak Brook
Hotel Tax Fund Financial Update
For the Period Ending December 31, 2018
Total Total
Revenues Expenditures
12/31/18 Actual $ 1,406,764 565,411$
12/31/17 Actual $ 1,381,983 1,459,023$
% Change From Last Year 1.8%-61.2%
Major Revenues
Grants Hotel Tax Interest Miscellaneous
12/31/18 Actual $ - $ 1,317,973 $ 83,591 $ 5,200
12/31/17 Actual $ - $ 1,287,887 $ 50,001 $ 44,095
% Change From Last Year 0.0%2.3%67.2%-88.2%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures Capital Outlay
12/31/18 Actual 459,538$ 99,550$ 6,323$
12/31/17 Actual 386,114$ 93,400$ 979,509$
% Change From Last Year 19.0%6.6%-99.4%
Five Year Trend
Village of Oak Brook
Hotel Tax Fund - Major Sources Five Year Trend
For the Period Ending December 31, 2018
Five Year Trend
Revenues Expenditures
12/31/18 12/31/18
12/31/17 12/31/18 YTD % of 2018 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 5,690,315$ 5,560,074$ 5,563,000$ 99.9%5,563,000$ (130,241)$
Grants 3,142 - - 0.0%- (3,142)
Interest 80,387 179,907 42,000 428.4%42,000 99,520
Miscellaneous 5,745 2,729 5,000 54.6%5,000 (3,016)
Total Operating Revenues 5,779,589$ 5,742,710$ 5,610,000$ 102.4%5,610,000$ (36,879)$
OPERATING EXPENDITURES
Personnel 1,142,736$ 1,199,069$ 1,365,445$ 87.8%1,365,445$ 56,333$
Materials and Supplies 90,757 137,372 182,955 75.1%182,955 46,615
Operation and Contract 1,488,688 1,247,108 1,484,755 84.0%1,484,755 (241,580)
Other Expenditures 162,500 164,865 164,865 100.0%164,865 2,365
Capital Outlay 533,883 2,004,994 5,625,620 35.6%5,625,620 1,471,111
Total Operating Expenditures 3,418,564$ 4,753,408$ 8,823,640$ 53.9%8,823,640$ 1,334,844$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 2,361,025$ 989,302$ (3,213,640)$ -30.8%(3,213,640)$ (1,371,723)$
INTERFUND TRANSACTIONS
Transfers In 389,604$ 7,790$ 500,000$ 1.6%500,000$ (381,814)$
Reimbursements From Other Funds 176,635 181,130 181,130 100.0%181,130 4,495
Total Interfund Transactions 566,239$ 188,920$ 681,130$ 27.7%681,130$ (377,319)$
NET FUND INCREASE (DECREASE)2,927,264$ 1,178,222$ (2,532,510)$ (2,532,510)$ (1,749,042)$
Village of Oak Brook
Infrastructure Fund Financial Update
For the Period Ending December 31, 2018
Total Total
Revenues Expenditures
12/31/18 Actual $ 5,742,710 4,753,408$
12/31/17 Actual $ 5,779,589 3,418,564$
% Change From Last Year -0.6%39.0%
Major Revenues
Sales Tax Grants Interest Miscellaneous Reimbursements
12/31/18 Actual $ 5,560,074 $ - $ 179,907 $ 2,729 $ 181,130
12/31/17 Actual $ 5,690,315 $ 3,142 $ 80,387 $ 5,745 $ 176,635
% Change From Last Year -2.3%-100.0%123.8%-52.5%2.5%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
12/31/18 Actual 1,199,069$ 137,372$ 1,247,108$ 164,865$ 2,004,994$
12/31/17 Actual 1,142,736$ 90,757$ 1,488,688$ 162,500$ 533,883$
% Change From Last Year 4.9%51.4%-16.2%1.5%275.5%
Five Year Trend
Expenditures by Department
12/31/17 12/31/18 12/31/18 12/31/18 2018 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 164,906$ 166,159$ 178,530$ 93.1%178,530$ 1,253$
Public Works 2,254,560 2,125,123 2,592,335 82.0%2,592,335 (129,437)
Engineering & Capital Projects 999,098 2,462,126 6,052,775 40.7%6,052,775 1,463,028
Total Expenditures 3,418,564$ 4,753,408$ 8,823,640$ 53.9%8,823,640$ 1,334,844$
Five Year Trend
Village of Oak Brook
Infrastructure Fund - Major Sources Five Year Trend
For the Period Ending December 31, 2018
Revenues Expenditures
12/31/18 12/31/18
12/31/17 12/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$ 102,500$ 65.6%102,500$ 1,301$
Real Estate Tax 385,018 373,267 385,000 97.0%385,000 (11,751)
Interest 925 1,975 250 790.0%250 1,050
Total Operating Revenues 451,884$ 442,484$ 487,750$ 90.7%487,750$ (9,400)$
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,454)$ (50,914)$ 23,840$ 23,840$ (44,460)$
Note - Expenditures are recorded in program 283.
Village of Oak Brook
Promenade TIF Fund Financial Update
For the Period Ending December 31, 2018
Total Total
Revenues Expenditures
12/31/18 Actual $ 442,484 493,398$
12/31/17 Actual $ 451,884 458,338$
% Change From Last Year -2.1%7.6%
Major Revenues Real Estate
Sales Tax Tax Interest
12/31/18 Actual $ 67,242 $ 373,267 $ 1,975
12/31/17 Actual $ 65,941 $ 385,018 $ 925
% Change From Last Year 2.0%-3.1%113.5%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures
12/31/18 Actual 3,578$ 489,820$
12/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 December 31, 2018
Five Year Trend
Revenues Expenditures
12/31/18 12/31/18
12/31/17 12/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 2,314 1,050 2,000 52.5%2,000 (1,264)
Building/Inspection Fees 11,839 8,888 5,000 177.8%5,000 (2,951)
Water Sales 9,446,192 9,484,872 9,730,425 97.5%9,730,425 38,680
Unmetered Sales 50,422 37,062 30,000 123.5%30,000 (13,360)
Water Connection Fees 187,680 117,134 50,000 234.3%50,000 (70,546)
Fire Service Charge - - 5,000 0.0%5,000 -
Meter Charges 22,979 11,591 25,000 46.4%25,000 (11,388)
Special Services 15,858 32,789 30,000 109.3%30,000 16,931
Interest on Investments 42,796 105,751 10,000 1057.5%10,000 62,955
Miscellaneous 89,099 92,190 50,000 184.4%50,000 3,091
Total Operating Revenues 9,872,565$ 9,891,327$ 9,937,425$ 99.5%9,937,425$ 18,762$
EXPENDITURES
Personnel 777,335$ 730,113$ 817,490$ 89.3%817,490$ (47,222)$
Materials and Supplies 67,229 65,386 76,860 85.1%76,860 (1,843)
Operation and Contract 5,207,710 5,010,814 6,780,015 73.9%6,780,015 (196,896)
Other Expenditures 401,600 405,170 405,170 100.0%405,170 3,570
Capital Outlay 95,931 2,128,070 2,710,220 78.5%2,710,220 2,032,139
Total Expenditures 6,549,805$ 8,339,553$ 10,789,755$ 77.3%10,789,755$ 1,789,748$
NET FUND INCREASE (DECREASE)3,322,760$ 1,551,774$ (852,330)$ (852,330)$ (1,770,986)$
Village of Oak Brook
Water Fund Financial Update
For the Period Ending December 31, 2018
Total Total
Revenues Expenditures
12/31/18 Actual $ 9,891,327 8,339,553$
12/31/17 Actual $ 9,872,565 6,549,805$
% Change From Last Year 0.2%27.3%
Unmetered Water
Water Sales Sales Connection Fees Meter Charges Miscellaneous
12/31/18 Actual $ 9,484,872 $ 37,062 $ 117,134 $ 11,591 $ 92,190
12/31/17 Actual $ 9,446,192 $ 50,422 $ 187,680 $ 22,979 $ 89,099
% Change From Last Year 0.4%-26.5%-37.6%-49.6%3.5%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
12/31/18 Actual 730,113$ 65,386$ 5,010,814$ 405,170$ 2,128,070$
12/31/17 Actual 777,335$ 67,229$ 5,207,710$ 401,600$ 95,931$
% Change From Last Year -6.1%-2.7%-3.8%0.9%2118.3%
Five Year Trend
Expenditures by Department
12/31/17 12/31/18 12/31/18 12/31/18 2018 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Public Works 6,430,813$ 6,182,379$ 8,124,535$ 76.1%8,124,535$ (248,434)$
Engineering & Capital Projects 118,992 2,157,174 2,665,220 80.9%2,665,220 2,038,182
Total Expenditures 6,549,805$ 8,339,553$ 10,789,755$ 77.3%10,789,755$ 1,789,748$
Five Year Trend
Village of Oak Brook
Water Fund - Major Sources Five Year Trend
For the Period Ending December 31, 2018
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Sports Core Fund Consolidated Presentation
For the Period Ending December 31, 2018
12/31/18 12/31/18
12/31/18 YTD % of 2018 12/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$ -$ 205,300$ 434,674$ 414,875$ 104.8%414,875$ 415,153$ 19,521$
Greens Fees - - 877,228 877,228 975,000 90.0%975,000 942,506 (65,278)
Pro Shop Sales - - 189,501 189,501 200,000 94.8%200,000 181,149 8,352
Golf Lessons - - 36,705 36,705 40,000 91.8%40,000 43,359 (6,654)
Driving Range Fees - - 216,866 216,866 235,000 92.3%235,000 236,520 (19,654)
Rentals - - 401,965 401,965 451,000 89.1%451,000 364,563 37,402
Programs/User Fees 252,447 - - 252,447 300,700 84.0%300,700 370,173 (117,726)
Food Sales - 157,331 - 157,331 145,500 108.1%145,500 177,514 (20,183)
Beverage Sales - 229,184 - 229,184 236,000 97.1%236,000 268,679 (39,495)
Other Revenue 188,439 260,182 7,348 455,969 380,650 119.8%380,650 413,485 42,484
Total Direct Revenues 670,260$ 646,697$ 1,934,913$ 3,251,870$ 3,378,725$ 96.2%3,378,725$ 3,413,101$ (161,231)$
DIRECT EXPENDITURES
Personnel 160,983$ 252,489$ 1,121,719$ 1,535,191$ 1,497,200$ 102.5%1,497,200$ 1,525,763$ 9,428$
Materials & Supplies 19,334 180,454 403,922 603,710 615,885 98.0%615,885 604,062 (352)
Operational & Contractual 701,253 131,628 245,233 1,078,114 961,510 112.1%961,510 1,049,317 28,797
Other - - (128,577) (128,577) (44,275) 290.4%(44,275) (186,200) 57,623
Capital 91,588 167,810 411,503 670,901 651,160 103.0%365,660 221,646 449,255
Total Direct Expenditures 973,158$ 732,381$ 2,053,800$ 3,759,339$ 3,681,480$ 102.1%3,395,980$ 3,214,588$ 544,751$
Direct Revenues Over (Under) Expenditures (302,898)$ (85,684)$ (118,887)$ (507,469)$ (302,755)$ 167.6%(17,255)$ 198,513$ (705,982)$
B&T Administration Overhead Allocation*120,701$ (120,701)$ -$ -$ -$ 0.0%-$ -$ -$
Operating Revenues Over (Under) Expenditures (182,197)$ (206,385)$ (118,887)$ (507,469)$ (302,755)$ 167.6%(17,255)$ 198,513$ (705,982)$
Interfund Loan**-$ -$ -$ -$ -$ 0.0%-$ -$ -$
Transfer From General Fund - - - - - 0.0%- - -
Transfer From Golf Surcharge Fund - - 217,258 217,258 285,500 76.1%- - 217,258
Transfer To Golf Surcharge Fund - - - - - 0.0%- (431,457)
Reimbursement From Infrastructure Fund 24,000 - - 24,000 24,000 100.0%24,000 24,000 -
Reimbursement From Water Fund 8,000 - - 8,000 8,000 100.0%8,000 8,000 -
Adjusted Operating Revenues Over (Under) Expenditures (150,197)$ (206,385)$ 98,371$ (258,211)$ 14,745$ 14,745$ (200,944)$ (488,724)$
*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
12/31/18 Actual $ 3,251,870 3,759,339$
12/31/17 Actual $ 3,413,101 3,214,588$
% Change From Last Year -4.7%16.9%
Driving Program/
Memberships Greens Fees Range Fees Rentals User Fees
12/31/18 Actual $ 434,674 $ 877,228 $ 216,866 $ 401,965 $ 252,447
12/31/17 Actual $ 415,153 $ 942,506 $ 236,520 $ 364,563 $ 370,173
% Change From Last Year 4.7%-6.9%-8.3%10.3%-31.8%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
12/31/18 Actual 1,535,191$ 603,710$ 1,078,114$ (128,577)$ 670,901$
12/31/17 Actual 1,525,763$ 604,062$ 1,049,317$ (186,200)$ 221,646$
% Change From Last Year 0.6%-0.1%2.7%-30.9%202.7%
Five Year Trend
Revenues by Department 12/31/17 12/31/18 12/31/18 12/31/18 2018 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Programs 786,788$ 670,260$ 646,495$ 103.7%712,075$ (116,528)$
Food & Beverage 648,495 646,697 127,800 506.0%569,000 602
Golf Club 1,977,818 1,934,913 567,997 340.7%2,097,650 (42,905)
Total Revenues 3,413,101$ 3,251,870$ 1,342,292$ 242.3%3,378,725$ (158,831)$
Expenditures by Department 12/31/17 12/31/18 12/31/18 % of 2018 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Programs 963,788$ 973,158$ 344,363$ 282.6%1,058,430$ 9,370$
Food & Beverage 662,022 732,381 281,968 259.7%514,980 70,359
Golf Club 1,588,778 2,053,800 778,751 263.7%1,822,570 465,022
Total Expenditures 3,214,588$ 3,759,339$ 1,405,082$ 267.6%3,395,980$ 544,751$
Five Year Trend
Village of Oak Brook
Sports Core Fund - Major Sources Five Year Trend
For the Period Ending December 31, 2018
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Club Recreation Programs
For the Period Ending December 31, 2018 12/31/18 12/31/18
12/31/18 YTD % of 2018 12/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,375$ 102.7%223,375$ 222,790$ 6,584$
Programs/User Fees - 19,401 31,961 - 201,085 252,447 300,700 84.0%300,700 370,173 (117,726)
Other Revenue (656) 2,767 410 - 185,918 188,439 188,000 100.2%188,000 193,825 (5,386)
Total Revenue (656)$ 230,269$ 53,644$ -$ 387,003$ 670,260$ 712,075$ 94.1%712,075$ 786,788$ (116,528)$
Expenditures:
Personnel 101,895$ 20,179$ 27,890$ -$ 11,019$ 160,983$ 208,040$ 77.4%208,040$ 240,554$ (79,571)$
Materials & Supplies 5,602 10,605 2,075 - 1,052 19,334 28,280 68.4%28,280 38,283 (18,949)
Operational & Contractual 76,523 286,208 71,551 20,000 246,971 701,253 586,160 119.6%586,160 633,430 67,823
Other - - - - - - 56,200 0.0%56,200 - -
Capital 38,845 52,154 - - 589 91,588 106,000 86.4%179,750 51,521 40,067
Total Expenditures 222,865$ 369,146$ 101,516$ 20,000$ 259,631$ 973,158$ 984,680$ 98.8%1,058,430$ 963,788$ 9,370$
Direct Revenues Over (Under) Expenditures (223,521)$ (138,877)$ (47,872)$ (20,000)$ 127,372$ (302,898)$ (272,605)$ 111.1%(346,355)$ (177,000)$ (125,898)$
B&T Administration Overhead Allocation*223,521$ (80,468)$ (22,352)$ -$ -$ 120,701$ 175,995$ 68.6%207,995$ 178,250$ (57,549)$
Revenues Over (Under) Expenditures -$ (219,345)$ (70,224)$ (20,000)$ 127,372$ (182,197)$ (96,610)$ 188.6%(138,360)$ 1,250$ (183,447)$
Reimbursement From Infrastructure Fund 24,000$ -$ -$ -$ -$ 24,000$ 24,000$ 100.0%24,000$ 24,000$ -$
Reimbursement From Water Fund 8,000 - - - - 8,000 8,000 100.0%8,000 8,000 -
Adjusted Revenues Over (Under) Expenditures 32,000$ (219,345)$ (70,224)$ (20,000)$ 127,372$ (150,197)$ (64,610)$ (106,360)$ 33,250$ (183,447)$
*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 December 31, 2018
12/31/18 12/31/18
821 822 823 12/31/18 YTD % of 2018 12/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 122,638 157,331 145,500 108.1%145,500 177,514 (20,183)
Beverage Sales - 18,467 210,717 229,184 236,000 97.1%236,000 268,679 (39,495)
Other Revenue 260,182 - - 260,182 187,500 138.8%187,500 199,902 60,280
Total Revenue 260,182$ 53,160$ 333,355$ 646,697$ 569,000$ 113.7%569,000$ 648,495$ 602$
Expenditures:
Personnel 116,137$ 24,003$ 112,349$ 252,489$ 199,505$ 126.6%199,505$ 223,276$ 29,213$
Materials & Supplies 13,151 16,059 151,244 180,454 182,150 99.1%182,150 204,135 (23,681)
Operational & Contractual 123,250 1,272 7,106 131,628 133,325 98.7%133,325 139,686 (8,058)
Capital 167,810 - - 167,810 73,750 227.5%- 94,925 72,885
Total Expenditures 420,348$ 41,334$ 270,699$ 732,381$ 588,730$ 124.4%514,980$ 662,022$ 70,359$
Direct Revenues Over (Under) Expenditures (160,166)$ 11,826$ 62,656$ (85,684)$ (19,730)$ 434.3%54,020$ (13,527)$ (72,157)$
B&T Administration Overhead Allocation*(111,760)$ (8,941)$ -$ (120,701)$ (175,995)$ 68.6%(175,995)$ (178,250)$ 57,549$
Revenues Over (Under) Expenditures (271,926)$ 2,885$ 62,656$ (206,385)$ (195,725)$ 105.4%(121,975)$ (191,777)$ (14,608)$
Transfer From General Fund -$ -$ -$ -$ -$ 0.0%-$ -$ -$
Adjusted Revenues Over (Under) Expenditures (271,926)$ 2,885$ 62,656$ (206,385)$ (195,725)$ (121,975)$ (191,777)$ (14,608)$
*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 December 31, 2018
12/31/18 12/31/18
831 832 833 834 12/31/18 YTD % of 2018 12/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 205,300$ -$ -$ -$ 205,300$ 191,500$ 107.2%191,500$ 189,963$ 15,337$
Greens Fees 877,228 - - - 877,228 975,000 90.0%975,000 942,506 (65,278)
Pro Shop Sales 189,501 - - - 189,501 200,000 94.8%200,000 181,149 8,352
Golf Lessons - 36,705 - - 36,705 40,000 91.8%40,000 43,359 (6,654)
Driving Range Fees - 216,866 - - 216,866 235,000 92.3%235,000 236,520 (19,654)
Rentals 3,420 70,000 328,545 - 401,965 451,000 89.1%451,000 364,563 37,402
Other Revenue 7,348 - - - 7,348 5,150 142.7%5,150 19,758 (12,410)
Total Revenue 1,282,797$ 323,571$ 328,545$ -$ 1,934,913$ 2,097,650$ 92.2%2,097,650$ 1,977,818$ (42,905)$
Expenditures:
Personnel 471,989$ 55,007$ 53,537$ 541,186$ 1,121,719$ 1,089,655$ 102.9%1,089,655$ 1,061,933$ 59,786$
Materials & Supplies 167,519 19,579 343 216,481 403,922 405,455 99.6%405,455 361,644 42,278
Operational & Contractual 178,734 14,058 2,205 50,236 245,233 242,025 101.3%242,025 276,201 (30,968)
Other - - 49,573 (178,150) (128,577) (100,475) 128.0%(100,475) (186,200) 57,623
Capital 290,810 - 40,922 79,771 411,503 471,410 87.3%185,910 75,200 336,303
Total Expenditures 1,109,052$ 88,644$ 146,580$ 709,524$ 2,053,800$ 2,108,070$ 97.4%1,822,570$ 1,588,778$ 465,022$
Direct Revenues Over (Under) Expenditures 173,745$ 234,927$ 181,965$ (709,524)$ (118,887)$ (10,420)$ 1141.0%275,080$ 389,040$ (507,927)$
Transfer from General Fund -$ -$ -$ -$ -$ 0.0%-$ -$ -
Transfer from Golf Surcharge 217,258 - - - 217,258 285,500 76.1%- - 217,258
Adjusted Revenues Over (Under) Expenditures 391,003$ 234,927$ 181,965$ (709,524)$ 98,371$ 275,080$ 275,080$ 389,040$ (290,669)$