07 - July 2017 Monthly Financial ReportVILLAGE
OAK BROOK
OF
MONTHLY FINANCIAL REPORTS
JULY 2017
RG
Total
Cash and Cash Pooled Cash and
Fund Equivalents Investments Investments % By Fund
General Corporate $4,923,871 $13,413,646 $18,337,517 47.4%
Hotel/Motel Tax 2,044,517 2,209,397 4,253,914 11.0%
Motor Fuel Tax 552,461 479,939 1,032,400 2.7%
TIF #1 Butterfield/Meyers 19,022 - 19,022 0.0%
Water 3,280,150 864,678 4,144,828 10.7%
Self-Insurance 484,209 - 484,209 1.3%
Sports Core 634,971 - 634,971 1.6%
Golf Surcharge - 484,530 484,530 1.3%
Equipment Replacement 813,500 949,614 1,763,114 4.6%
Infrastructure 3,803,865 3,351,821 7,155,686 18.5%
Garage 381,745 - 381,745 1.0%
Total $16,938,311 $21,753,625 $38,691,936 100.0%
Change in Cash and Investments by Fund :
Balance at Balance at Year-to-Date Year-to-Date
Fund January 1, 2017 July 31, 2017 Change ($)Change (%)
General Corporate $16,586,097 $18,337,517 $1,751,420 10.6%
Hotel/Motel Tax 4,415,721 4,253,914 (161,807)-3.7%
Motor Fuel Tax 909,926 1,032,400 122,474 13.5%
TIF #1 Butterfield/Meyers 249,278 19,022 (230,256)-92.4%
Water 2,732,210 4,144,828 1,412,618 51.7%
Self-Insurance 589,849 484,209 (105,640)-17.9%
Sports Core 268,828 634,971 366,143 136.2%
Golf Surcharge 432,619 484,530 51,911 12.0%
Equipment Replacement 1,510,026 1,763,114 253,088 16.8%
Infrastructure 5,436,080 7,155,686 1,719,606 31.6%
Garage 347,053 381,745 34,692 10.0%
$33,477,688 $38,691,936 $5,214,248 15.6%
Book Market
Value Value
Pooled Checking $1,173,149 $1,173,149
Sports Core Checking 645,067 645,067
Pooled IPTIP 15,015,913 15,015,913
Water E-Pay IPTIP 104,182 104,182
$16,938,311 $16,938,311
Pooled Investments:
Certificates of Deposit $6,370,000 $6,362,509
Investments-Municipal 9,087,132 9,064,355
Investments-Corporate 4,418,345 4,415,034
Government & Agency Obligations 1,750,945 1,734,637
Accrued Interest 127,203 127,203
Total Pooled Investments $21,753,625 $21,703,738
Total Cash and Investments $38,691,936 $38,642,049
For July, total interest revenue is $39,471 and year to date is $229,845.
Total investment yield for the portfolio is:
Pooled
Investments Illinois Funds Total
Monthly yield 0.13%0.10%0.12%
YTD yield 0.81%0.48%0.68%
Last 12 months yield 1.31%0.65%1.06%
The weighted average yield of the current pooled investment portfolio is 1.57%.
Monthly Treasurer's Report
July 31, 2017
Monthly Treasurer's Report
July 2017
The table below lists the detail investment holdings at J.P. Morgan Securities as of 7/31/17:
Month End VOB
Settlement Maturity Coupon Yield Book Market Accrued
Type Date Date Rate Rate Value Value Interest
Municipal Bonds:
Public Utility District #181117EP3 09/02/14 1/1/2018 1.667%1.650%$600,785 $600,966 $878
Florida Hurricane #34074GDG6 01/05/15 7/1/2018 2.107%2.090%752,082 753,780 1,303
Maryland St Econ Dev #57420PGK6 07/08/15 6/1/2019 2.050%2.123%99,867 100,948 340
Du Page County IL #263493TN8 07/20/15 10/1/2017 4.850%1.200%503,081 503,005 7,874
Hidalgo County Tex Ltd Tax #429326WW7 10/14/15 8/15/2017 1.291%1.263%850,003 850,128 5,053
Rosemont IL GO Corp #777543UT4 02/08/16 12/1/2019 3.021%2.000%511,571 507,155 2,422
New York St Urban Dev Corp #650035J58 02/22/16 3/15/2018 1.650%1.150%175,539 175,420 1,082
New York N Y City #64971QTX1 02/22/16 5/1/2021 2.350%2.000%202,511 200,930 1,161
Florida Hurricane #34074GDH4 03/30/16 7/1/2020 2.995%2.150%511,845 511,735 1,247
Bloomingdale Mich Pub Sch Dist #094383FS0 04/26/16 5/1/2022 2.710%2.150%512,571 506,465 3,348
Milan Mich Area Achs #598801JD1 05/26/16 5/1/2020 1.931%1.931%245,000 243,356 1,182
Indiana Bd Bk Rev Taxable #4546248F7 01/06/17 1/15/2020 2.934%1.900%261,285 262,025 346
North Carolina Eastn Mun PWR #65819WAC7 01/30/17 7/1/2018 2.003%1.450%703,499 702,492 1,168
Garland Cnty Ark Sales & Use #36609PAN3 02/06/17 11/1/2019 1.795%1.840%499,502 497,525 2,368
Anchor Bay Mich Sch Dist GO #032879TA6 02/13/17 5/1/2019 1.810%1.420%367,462 366,716 1,575
Macomb Cnty Mich Retirees #554885H63 04/11/17 11/1/2018 1.731%1.300%402,138 400,964 1,688
Lanse Creuse Mich Pub Schs #516228RL9 05/02/17 5/1/2020 2.159%2.159%100,000 100,540 531
California St GO Bonds #13063A7G3 05/08/17 10/1/2019 6.200%1.600%548,962 545,855 10,051
*Genesee Cnty Mich #371608UV0 05/31/17 10/1/2019 1.872%1.872%750,000 750,210 1,054
Connecticut St GO Bds 2016 #20772J3F7 06/15/17 8/15/2021 1.750%2.300%489,429 484,140 3,981
Total Municipal Bonds $9,087,132 $9,064,355 $48,652
Corporate Bonds:
Morgan Stanley #617446V71 03/10/17 8/28/2017 6.250%1.201%$1,003,746 $1,003,230 $26,524
MacCormick & Co #579780AF4 04/06/17 12/15/2017 5.750%1.401%508,094 507,360 3,567
JP Morgan Chase #46625HJG6 06/08/17 1/25/2018 1.800%1.371%846,748 846,056 199
Goldman Sachs Group #38141GRC0 06/08/17 1/22/2018 2.375%1.531%1,003,999 1,003,860 508
Wachovia #92976WBH8 06/15/17 2/1/2018 5.750%1.360%1,055,758 1,054,528 29,337
Total Corporate Bonds $4,418,345 $4,415,034 $60,135
Government & Agency Obligations:
**Government National Mtg Assn #38379UEM4 02/29/16 2/16/2051 2.300%2.245%$900,945 $885,352 $2,061
Fed Home Loan Bank #3130A9HF1 09/30/16 9/30/2019 0.750%1.280%600,000 599,340 375
Fed Home Loan Mtg Corp #3314GALU6 09/30/16 9/30/2019 0.800%1.852%250,000 249,945 667
Total Government & Agency Obligations:$1,750,945 $1,734,637 $3,103
Certificates of Deposit:
Capital One Bank #140420PP9 09/23/14 10/2/2017 1.35%1.36%$245,000 $245,015 $1,107
Goldman Sachs Bank #38148JNW7 03/17/15 9/25/2017 1.15%1.15%245,000 245,044 985
Capital One Natl Assn VA #14042E5Z9 08/26/15 8/27/2018 1.75%1.75%245,000 245,625 2,260
FirstBank PR Santurce #33767ANR8 08/31/15 8/31/2017 1.30%1.30%245,000 245,066 270
Needham Co-Operative Bk #63983RAS8 10/07/15 10/10/2017 1.05%1.05%245,000 245,049 811
BMO Harris #05573J5A8 10/07/15 10/10/2017 1.10%1.10%245,000 245,044 850
Ally Bk Midvale Utah #02006LVC4 10/29/15 10/29/2018 1.60%1.60%245,000 245,600 985
Everbank Jacksonville #29976DD23 10/30/15 10/30/2017 1.05%1.05%245,000 244,927 647
Wex Bank Midvale Utah #92937CDY1 07/29/16 7/30/2018 1.00%1.00%245,000 244,059 14
Bank Hope Los Angeles #062683AB3 08/26/16 8/27/2018 1.00%1.00%245,000 243,618 31
Wells Fargo Bank Natl Assn #949763AL0 08/31/16 8/31/2018 1.10%1.10%245,000 243,626 12
BMW Bank #05580AFG4 09/23/16 9/24/2018 1.10%1.10%245,000 243,486 962
Comenity Cap Bank #20033ASB3 09/26/16 9/26/2018 1.10%1.10%245,000 243,474 39
Enerbank #29266N4E4 10/21/16 10/22/2018 1.10%1.10%245,000 243,846 752
Discover Bank #254672L71 10/26/16 10/26/2018 1.20%1.20%245,000 243,324 780
Bank of Baroda #06062QXT6 11/30/16 11/30/2017 0.95%0.95%245,000 244,782 1,552
State Bk India NY #8562846A7 01/26/17 1/26/2022 2.25%2.25%245,000 246,245 99
Marlin Business Bk #57116ANU8 05/10/17 11/12/2019 1.60%1.60%245,000 244,486 227
American Express Fed Svgs #02587CER7 05/10/17 11/12/2019 1.70%1.70%245,000 245,032 937
Synchrony Bank #87164WRA8 05/26/17 5/28/2019 1.65%1.65%245,000 245,240 707
Umpqua Bank #90421MAG8 05/31/17 5/31/2019 1.60%1.60%245,000 245,012 664
Stone Bk Mtn View Ark #86158RAJ8 06/28/17 6/28/2019 1.60%1.60%245,000 244,951 26
Investors Savings Bk #46176PGU3 06/30/17 4/2/2018 1.35%1.35%245,000 245,039 276
TIAA FSB Jacksonville #87270LAA1 07/19/17 7/19/2019 1.60%1.60%245,000 244,900 131
Peoples United Bank #71270QQZ2 07/19/17 7/19/2019 1.65%1.65%245,000 245,137 135
Priority Bank Ozark Ark #74269KBR6 07/26/17 7/26/2019 1.60%1.60%245,000 244,882 54
Total Certificates of Deposits $6,370,000 $6,362,509 $15,313
Total J.P.Morgan Securities $21,626,422 $21,576,535 $127,203
*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
July 31, 2017
Cash & Investments by Fund - Total $38.7 million
Cash & Investments by Type - Total $38.7 million
Checking
Illinois Funds
Certificates of Deposit
Municipal Bonds
Corporate Bonds
Government & Agency Obligations
Accrued Interest
General Corporate
47.39%
Hotel/Motel Tax
10.99% Motor Fuel Tax
2.67%
TIF #1
Butterfield/Meyers
0.05%
Water
10.71%
Self-Insurance
1.25%
Sports Core
1.64%
Golf Surcharge
1.25%
Equipment
Replacement
4.56% Infrastructure
18.49%
Garage
0.99%
Checking, $1.8
Illinois Funds, $15.1
Certificates of Deposit,
$6.4
Municipal Bonds, $9.1
Corporate Bonds, $4.4
Government & Agency
Obligations, $1.8
Accrued Interest, $0.1
in millions
YTD YTD
Net Fund Budget
Increase Increase
Major Governmental Funds Revenues Expenditures (Decrease)(Decrease)
General Fund $14,395,553 $12,852,794 $1,542,759 $262,800
Main operating fund of the Village.
Hotel Fund $714,113 $721,064 ($6,951)($776,495)
Collects and spends resources from the
3% hotel/motel tax.
Motor Fuel Tax Fund $122,473 $0 $122,473 ($165,245)
Collects and spends resources from the
State motor fuel tax.
Infrastructure Fund $3,502,614 $1,700,354 $1,802,260 $1,298,005
Accounts for construction and maintenance of
roadways, drainage, and safety path systems.
Promenade TIF Funds $227,819 $458,075 ($230,256)($247,210)
Accounts for the revenues and expenditures
restricted to the Tax Increment Financing (TIF)
district located at 22nd St. and Meyers Rd.
YTD
YTD Budget
Enterprise Funds Revenues Expenses Profit/ (Loss)Profit/ (Loss)
Water Fund $5,159,174 $3,268,766 $1,890,408 ($1,288,660)
Collects user fees for the distribution of water
and maintenance of infrastructure.
Sports Core Fund $2,361,181 $2,013,962 $347,219 $163,220
Accounts for revenues and expenses relating
to administration, programs, food and beverage
operations, and golf course.
Golf Surcharge Fund $72,966 $0 $72,966 $67,155
Accounts for the collection of the $3 per round
golf surcharge.
Executive Summary on Funds
Through July 31, 2017
Revenues Expenses
Actual Budget
Revenues Expenses
Actual Budget
Revenues Expenses
Actual Budget
Revenues Expenses
Actual Budget
Revenues Expenses
Actual Budget
Revenues Expenses
Actual Budget
General Fund Hotel Tax Fund Infrastructure Fund
Promenade TIF
Fund Water Fund Sports Core Fund
Revenues Expenses
Actual Budget
Revenues Expenses
Actual Budget
Motor Fuel Tax
Fund
Golf Surcharge
Fund
7/31/17 7/31/17
7/31/16 7/31/17 YTD % of 2017 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 7,572,770$ 7,238,468$ 7,611,345$ 95%13,048,000$ (334,302)$
Other Intergovernmental Tax 886,085 891,854 825,365 108%1,265,235 5,769
Telecommunications/Utility Tax 3,520,419 3,516,166 3,451,465 102%5,638,000 (4,253)
Licenses and Permits 976,220 1,460,543 1,294,635 113%1,711,750 484,323
Charges for Services 569,673 529,596 579,575 91%1,006,750 (40,077)
Fines and Penalties 89,854 89,308 89,530 100%153,590 (546)
Administrative Towing Fees 21,550 25,875 29,155 89%50,000 4,325
Interest on Investments 80,866 121,875 72,905 167%125,000 41,009
Franchise/IMF Maint. Fee 121,803 59,149 103,600 57%207,200 (62,654)
Reimbursements From Other Funds 366,345 360,094 360,080 100%617,300 (6,251)
Miscellaneous Income 96,553 102,625 131,265 78%231,675 6,072
Total Operating Revenues 14,302,138$ 14,395,553$ 14,548,920$ 99%24,054,500$ 93,415$
OPERATING EXPENDITURES
Personnel 9,169,555$ 9,184,523$ 10,287,830$ 89%17,788,210$ 14,968$
Materials and Supplies 236,902 224,899 347,165 65%554,530 (12,003)
Operation and Contract 2,291,628 2,530,344 2,740,090 92%4,344,325 238,716
Other Expenditures 85,564 79,744 79,730 100%418,100 (5,820)
Capital Outlay 232,525 833,284 831,305 100%805,310 600,759
Total Operating Expenditures 12,016,174$ 12,852,794$ 14,286,120$ 90%23,910,475$ 836,620$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 2,285,964$ 1,542,759$ 262,800$ 144,025$ (743,205)$
INTERFUND TRANSACTIONS
Transfers Out -$ -$ -$ 0%(73,505)$ -$
Interfund Loan - - - 0%- -
Total Interfund Transactions -$ -$ -$ 0%(73,505)$ -$
NET FUND INCREASE (DECREASE)2,285,964$ 1,542,759$ 262,800$ 70,520$ (743,205)$
Village of Oak Brook
General Fund Financial Update
For the Period Ending July 31, 2017
Total Total
Revenues Expenditures
6/30/17 Actual $ 14,395,553 12,852,794$
6/30/16 Actual $ 14,302,138 12,016,174$
% Change From Last Year 0.7%7.0%
Major Revenues Other
Intergov.Licenses &Charges for
Sales Tax Tax Telecom Tax Permits Services
6/30/17 Actual $ 7,238,468 $ 891,854 $ 3,516,166 $ 1,460,543 529,596
6/30/16 Actual $ 7,572,770 $ 886,085 $ 3,520,419 $ 976,220 569,673
% Change From Last Year -4.4%0.7%-0.1%49.6%-7.0%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
6/30/17 Actual 9,184,523$ 224,899$ 2,530,344$ 79,744 833,284$
6/30/16 Actual 9,169,555$ 236,902$ 2,291,628$ 85,564 232,525$
% Change From Last Year 0.2%-5.1%10.4%-6.8%258.4%
Five Year Trend
Expenditures by Department
7/31/16 7/31/17 7/31/17 7/31/17 2017 Difference Five
YTD YTD YTD % of Annual Prior Year
Department Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 1,363,387$ 1,576,607$ 1,778,850$ 88.6%2,883,255$ 213,220$
Financial Services 546,137 481,839 497,170 96.9%1,116,445 (64,298)
Public Works 314,312 396,341 411,445 96.3%752,340 82,029
Engineering & Capital Projects 151,032 591,308 466,190 126.8%372,500 440,276
Library 549,096 530,267 605,940 87.5%989,470 (18,829)
Police 4,735,133 4,690,051 5,065,395 92.6%8,609,255 (45,082)
Fire 3,820,963 4,029,830 4,887,195 82.5%8,205,100 208,867
Development Services 536,114 556,551 573,935 97.0%982,110 20,437
Total Expenditures 12,016,174$ 12,852,794$ 14,286,120$ 90.0%23,910,475$ 836,620$
Explanation of Major Changes From Last Year:
Sales Tax revenue is down $334,302 compared to revenue through July 2016. This is due to non-routine receipts received from a top taxpayer in 2016. Total Sales Tax
revenue through June 2017 is $372,877 under budget due to the timing of receipts from new businesses and slowed retail growth.
Licenses & Permits revenue is up $484,323 compared to collections through July 2016. This is primarily due to increases in building permits and accessory structure
permits. Total Licenses & Permits revenue through July 2017 is over budget by $165,908. The Village issued a building permit during May 2017 that resulted in
nearly $300,000 in revenue.
Operation & Contractual expenditures are up $238,716 compared to payments through July 2016. This is due to increased litigation services and increases in liability
insurance premiums and claims. Total Operation & Contractual expenditures through July 2017 are $209,746 under budget due to general timing of payments.
Capital Outlay expenditures are up $600,759 compared to payments through July 2016. This is due to major projects performed early in 2017 such as the BGC restroom
renovation project, fire department humidifier installation, and BGC electrical upgrade. Total Capital Outlay expenditures through July 2017 are $1,979 over budget.
Five Year Trend
For the Period Ending July 31, 2017
General Fund - Five Year Trend
Village of Oak Brook
Revenues Expenditures
7/31/17 7/31/17
7/31/16 7/31/17 YTD % of 2017 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Hotel Tax 635,905$ 676,372$ 531,525$ 127%1,266,000$ 40,467$
Interest 18,995 26,410 12,810 206%22,000 7,415
Miscellaneous - 11,331 - N/A - 11,331
Total Operating Revenues 654,900$ 714,113$ 544,335$ 131%1,288,000$ 59,213$
EXPENDITURES
Operation and Contract 140,884$ 260,010$ 347,620$ 75%595,975$ 119,126$
Other Expenditures 52,675 54,481 54,460 100%93,400 1,806
Capital Outlay 1,188 406,573 918,750 44%1,837,500 405,385
Total Expenditures 194,747$ 721,064$ 1,320,830$ 55%2,526,875$ 526,317$
NET FUND INCREASE (DECREASE)460,153$ (6,951)$ (776,495)$ (1,238,875)$ (467,104)$
Note - Expenditures are recorded in program 171.
Village of Oak Brook
Hotel Tax Fund Financial Update
For the Period Ending July 31, 2017
Total Total
Revenues Expenditures
6/30/17 Actual $ 714,113 721,064$
6/30/16 Actual $ 654,900 194,747$
% Change From Last Year 9.0%270.3%
Major Revenues
Grants Hotel Tax Interest Miscellaneous
6/30/17 Actual $ - $ 676,372 $ 26,410 $ 11,331
6/30/16 Actual $ - $ 635,905 $ 18,995 $ -
% Change From Last Year 0.0%6.4%39.0%N/A
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures Capital Outlay
6/30/17 Actual 260,010$ 54,481$ 406,573$
6/30/16 Actual 140,884$ 52,675$ 1,188$
% Change From Last Year 84.6%3.4%34123.3%
Five Year Trend
Explanation of Major Changes From Last Year:
Hotel Tax revenue is up $40,467 compared to collections through July 2016. This is related to the timing of when
payments are received and general increases in receipts. Total Hotel Tax revenue through July 2017 is over budget
by $144,847 because of general increases in receipts and the timing of when receipts have been received.
Operation & Contractual expenditures are up $119,126 compared to payments through July 2016. This is related to
engineering costs for a 22nd Street beautification project. Total Operation & Contractual expenditures through
July 2017 are under budget by $87,610 due to the timing of DCVB quarterly dues payments.
Capital Outlay expenditures are up $405,385 compared to payments through July 2016. This is related to 22nd St.
construction costs that were delayed from 2016. Total Capital Outlay expenditures through July 2017 are
under budget by $512,177 due to the timing of payments.
Village of Oak Brook
Hotel Tax Fund - Major Sources Five Year Trend
For the Period Ending July 31, 2017
Five Year Trend
Revenues Expenditures
7/31/17 7/31/17
7/31/16 7/31/17 YTD % of 2017 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Motor Fuel Tax 114,182$ 116,534$ 120,260$ 97%206,200$ 2,352$
Interest 4,293 5,939 1,750 339%3,000 1,646
Total Operating Revenues 118,475$ 122,473$ 122,010$ 100%209,200$ 3,998$
EXPENDITURES
Other Expenditures - - 287,255 0%561,765 -
Total Expenditures -$ -$ 287,255$ 0%561,765$ -$
NET FUND INCREASE (DECREASE)118,475$ 122,473$ (165,245)$ (352,565)$ 3,998$
Note - Expenditures are recorded in program 431.
Village of Oak Brook
Motor Fuel Tax Fund Financial Update
For the Period Ending July 31, 2017
Total Total
Revenues Expenditures
6/30/17 Actual $ 122,473 -$
6/30/16 Actual $ 118,475 -$
% Change From Last Year 3.4%0.0%
Major Revenues Motor Fuel
Tax Interest
6/30/17 Actual $ 116,534 $ 5,939
6/30/16 Actual $ 114,182 $ 4,293
% Change From Last Year 2.1%38.3%
Five Year Trend
Major Expenditures Other
Expenditures
6/30/17 Actual -$
6/30/16 Actual -$
% Change From Last Year 0.0%
Five Year Trend
Explanation of Major Changes From Last Year:
Motor Fuel Tax revenue is up $2,352 compared to collections through July 2016. This is related to general increases in
receipts. Total Motor Fuel Tax revenue through July 2017 is under budget by $3,726 due to 2017 projections being
higher than actually collected so far this year.
Other Expenditures represents transfers to the Infrastructure Fund for roadway improvements. The Village has not
incurred any Motor Fuel Tax project related expenditures so far this year.
Village of Oak Brook
Motor Fuel Tax Fund - Major Sources Five Year Trend
For the Period Ending July 31, 2017
Five Year Trend
Revenues Expenditures
7/31/17 7/31/17
7/31/16 7/31/17 YTD % of 2017 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 3,497,724$ 3,352,032$ 3,499,930$ 96%5,982,000$ (145,692)$
Grants - 3,142 - N/A - 3,142
Interest 23,268 38,655 16,030 241%27,500 15,387
Miscellaneous (1,645) 5,745 2,905 198%5,000 7,390
Reimbursements From Other Funds 105,021 103,040 103,040 100%176,635 (1,981)
Total Operating Revenues 3,624,368$ 3,502,614$ 3,621,905$ 97%6,191,135$ (121,754)$
OPERATING EXPENDITURES
Personnel 831,043$ 697,929$ 758,300$ 92%1,474,390$ (133,114)$
Materials and Supplies 70,970 69,315 228,640 30%351,095 (1,655)
Operation and Contract 630,186 729,941 857,560 85%1,132,435 99,755
Other Expenditures 90,419 94,794 94,780 100%162,500 4,375
Capital Outlay 81,639 108,375 671,875 16%1,755,000 26,736
-
Total Operating Expenditures 1,704,257$ 1,700,354$ 2,611,155$ 65%4,875,420$ (3,903)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 1,920,111$ 1,802,260$ 1,010,750$ 178%1,315,715$ (117,851)$
INTERFUND TRANSACTIONS
Transfers In -$ -$ 287,255$ 0%561,765$ -$
Total Interfund Transactions -$ -$ 287,255$ 0%561,765$ -$
NET FUND INCREASE (DECREASE)1,920,111$ 1,802,260$ 1,298,005$ 1,877,480$ (117,851)$
Village of Oak Brook
Infrastructure Fund Financial Update
For the Period Ending July 31, 2017
Total Total
Revenues Expenditures
6/30/17 Actual $ 3,502,614 1,700,354$
6/30/16 Actual $ 3,624,368 1,704,257$
% Change From Last Year -3.4%-0.2%
Major Revenues
Sales Tax Grants Interest Miscellaneous Reimbursements
6/30/17 Actual $ 3,352,032 $ 3,142 $ 38,655 $ 5,745 $ 103,040
6/30/16 Actual $ 3,497,724 $ - $ 23,268 $ (1,645) $ 105,021
% Change From Last Year -4.2%N/A 66.1%-449.2%-1.9%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
6/30/17 Actual 697,929$ 69,315$ 729,941$ 94,794$ 108,375$
6/30/16 Actual 831,043$ 70,970$ 630,186$ 90,419$ 81,639$
% Change From Last Year -16.0%-2.3%15.8%4.8%32.7%
Five Year Trend
Expenditures by Department
7/31/16 7/31/17 7/31/17 7/31/17 2017 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 70,550$ 89,969$ 101,335$ 88.8%174,430$ 19,419$
Public Works 1,175,898 1,349,541 1,656,180 81.5%2,697,845 173,643
Engineering & Capital Projects 457,809 260,844 853,640 30.6%2,003,145 (196,965)
Total Expenditures 1,704,257$ 1,700,354$ 2,611,155$ 65.1%4,875,420$ (3,903)$
Explanation of Major Changes From Last Year:
Sales Tax revenue is down $145,692 compared to revenue through July 2016. This is due to non-routine receipts received from a top taxpayer in 2016. Total Sales Tax
revenue through July 2017 is $147,898 under budget due to the timing of receipts from new businesses and slowed retail growth.
Personnel expenditures are down $133,114 compared to payments through July 2016. This is primarily due to a decrease in hours needed for snow removal overtime and a
reduction in headcount related to the outsourcing of the Village engineering function. Total Personnel costs through July 2017 are $60,371 under budget due to less time
spent on snow removal.
Operation & Contractual expenditures are up $99,755 compared to payments through July 2016. This is due to payments for outsourced engineering services that started
in 2017. Total Operation & Contractual expenditures through July 2017 are $127,619 under budget due to the timing of general maintenance payments.
Capital Outlay expenditures are up $26,736 compared to payments through July 2016. This is due to projects that were delayed in 2016. Total Capital Outlay expenditures
through July 2017 are $563,500 under budget due to the timing of capital projects.
Five Year Trend
Village of Oak Brook
Infrastructure Fund - Major Sources Five Year Trend
For the Period Ending July 31, 2017
Revenues Expenditures
7/31/17 7/31/17
7/31/16 7/31/17 YTD % of 2017 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 34,842$ 35,077$ 33,500$ 105%100,500$ 235$
Real Estate Tax 177,415 192,509 177,500 108%355,000 15,094
Interest 124 233 40 583%100 109
Total Operating Revenues 212,381$ 227,819$ 211,040$ 108%455,600$ 15,438$
EXPENDITURES
Operation and Contract 3,763$ 3,695$ 3,870$ 95%4,070$ (68)$
Other Expenditures 435,220 454,380 454,380 100%454,380 19,160
Total Expenditures 438,983$ 458,075$ 458,250$ 100%458,450$ 19,092$
NET FUND INCREASE (DECREASE)(226,602)$ (230,256)$ (247,210)$ (2,850)$ (3,654)$
Note - Expenditures are recorded in program 283.
Village of Oak Brook
Promenade TIF Fund Financial Update
For the Period Ending July 31, 2017
Total Total
Revenues Expenditures
6/30/17 Actual $ 227,819 458,075$
6/30/16 Actual $ 212,381 438,983$
% Change From Last Year 7.3%4.3%
Major Revenues Real Estate
Sales Tax Tax Interest
6/30/17 Actual $ 35,077 $ 192,509 $ 233
6/30/16 Actual $ 34,842 $ 177,415 $ 124
% Change From Last Year 0.7%8.5%87.9%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures
6/30/17 Actual 3,695$ 454,380$
6/30/16 Actual 3,763$ 435,220$
% Change From Last Year -1.8%4.4%
Five Year Trend
Explanation of Major Changes From Last Year:
Real Estate Tax revenue is up $15,094 compared to revenue through July 2016. This is due to general property value
increases within the TIF. Total Real Estate Tax revenue through July 2017 is $15,009 over budget due to the property
valuation being higher than anticipated.
Other Expenditures are up $19,160 compared to payments through July 2016. This is due to an increase in TIF note payable
principal payments to the bondholders.
Village of Oak Brook
Promenade TIF Fund - Major Sources Five Year Trend
For the Period Ending July 31, 2017
Five Year Trend
Revenues Expenditures
7/31/17 7/31/17
7/31/16 7/31/17 YTD % of 2017 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Grants -$ 3,386$ -$ N/A -$ 3,386$
Plan Review Fees 1,059 1,264 1,155 109%2,000 205
Building/Inspection Fees 3,438 5,314 2,625 202%4,500 1,876
Water Sales 4,568,502 4,927,282 4,981,660 99%9,143,000 358,780
Unmetered Sales 11,359 11,155 14,560 77%25,000 (204)
Water Connection Fees 29,583 128,570 17,500 735%30,000 98,987
Fire Service Charge 4,743 - 5,845 0%10,000 (4,743)
Meter Charges 10,916 14,246 14,595 98%25,000 3,330
Special Services 15,620 15,286 15,500 99%31,000 (334)
Interest on Investments 6,336 18,157 5,845 311%10,000 11,821
Miscellaneous 33,637 34,514 37,905 91%65,000 877
Total Operating Revenues 4,685,193$ 5,159,174$ 5,097,190$ 101%9,345,500$ 473,981$
EXPENDITURES
Personnel 491,598$ 469,521$ 483,635$ 97%835,110$ (22,077)$
Materials and Supplies 30,875 28,617 41,360 69%70,660 (2,258)
Operation and Contract 2,794,152 2,500,230 3,832,445 65%6,547,735 (293,922)
Other Expenditures 247,170 234,269 234,255 100%401,600 (12,901)
Capital Outlay 56,910 36,129 1,794,155 2%3,235,010 (20,781)
Total Expenditures 3,620,705$ 3,268,766$ 6,385,850$ 51%11,090,115$ (351,939)$
NET FUND INCREASE (DECREASE)1,064,488$ 1,890,408$ (1,288,660)$ (1,744,615)$ 825,920$
Village of Oak Brook
Water Fund Financial Update
For the Period Ending July 31, 2017
Total Total
Revenues Expenditures
6/30/17 Actual $ 5,159,174 3,268,766$
6/30/16 Actual $ 4,685,193 3,620,705$
% Change From Last Year 10.1%-9.7%
Unmetered Water
Water Sales Sales Connection Fees Meter Charges Miscellaneous
6/30/17 Actual $ 4,927,282 $ 11,155 $ 128,570 $ 14,246 $ 34,514
6/30/16 Actual $ 4,568,502 $ 11,359 $ 29,583 $ 10,916 $ 33,637
% Change From Last Year 7.9%-1.8%334.6%30.5%2.6%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
6/30/17 Actual 469,521$ 28,617$ 2,500,230$ 234,269$ 36,129$
6/30/16 Actual 491,598$ 30,875$ 2,794,152$ 247,170$ 56,910$
% Change From Last Year -4.5%-7.3%-10.5%-5.2%-36.5%
Five Year Trend
Expenditures by Department
7/31/16 7/31/17 7/31/17 7/31/17 2017 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Public Works 3,620,705$ 3,245,168$ 4,681,825$ 69.3%7,912,070$ (375,537)$
Engineering & Capital Projects - 23,598 1,704,025 0.0%3,178,045 23,598
Total Expenditures 3,620,705$ 3,268,766$ 6,385,850$ 51.2%11,090,115$ (351,939)$
Explanation of Major Changes From Last Year:
Water Sales revenue is up $358,780 compared to collections through July 2016. This is due to a 10% rate increase adopted January 1, 2017. Total Water Sales revenue
through July 2017 is under budget by $54,378 due to less gallons being billed than projected.
Water Connection Fees revenue is up $98,987 compared to collections through July 2016. This is due to construction of the Rush Midwest Orthopedics building. Total
Water Connection Fees revenue through July 2017 is over budget by $110,070 due to the exact timing of the Rush building fees not being originally known.
Operation & Contractual expenditures are down $293,922 compared to payments through July 2016. This is due to total gallons pumped from DuPage Water Commission
being less than projected and the DuPage Water Commission rate increase being less than anticipated. Operation & Contractual expenditures through July 2017 are under
budget by $1,332,215 due to the timing of bills being paid to DuPage Water Commission and those bills being slightly less than projected.
Capital Outlay expenditures are down $20,781 compared to payments through July 2016. This is due to general timing of payments. Capital Outlay expenditures through
July 2017 are under budget by $1,758,026 due to the meter replacement project happening later than originally planned.
Five Year Trend
Village of Oak Brook
Water Fund - Major Sources Five Year Trend
For the Period Ending July 31, 2017
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Sports Core Fund Consolidated Presentation
For the Period Ending July 31, 2017
7/31/17 7/31/17
7/31/17 YTD % of 2017 7/31/16 Difference
B&T Recreation Food &Golf YTD Amended Amended Adopted YTD Prior
Programs Beverage Club Total Budget Budget Budget Total Year
DIRECT REVENUES
Memberships 223,340$ 2,400$ 187,703$ 413,443$ 453,080$ 91%443,580$ 405,563$ 7,880$
Greens Fees - - 552,776 552,776 506,560 109%840,000 508,409 44,367
Pro Shop Sales - - 118,996 118,996 130,155 91%190,000 118,293 703
Golf Lessons - - 35,042 35,042 27,625 127%30,250 34,398 644
Driving Range Fees - - 179,165 179,165 175,500 102%225,000 174,645 4,520
Rentals - - 211,877 211,877 198,225 107%327,850 211,805 72
Programs/User Fees 272,197 - - 272,197 222,765 122%387,750 176,203 95,994
Food Sales - 109,352 - 109,352 102,210 107%163,850 102,737 6,615
Beverage Sales - 161,463 - 161,463 150,325 107%199,300 148,017 13,446
Other Revenue 191,654 92,874 3,673 288,201 268,835 107%351,900 274,330 13,871
Total Direct Revenues 687,191$ 366,089$ 1,289,232$ 2,342,512$ 2,235,280$ 105%3,159,480$ 2,154,400$ 188,112$
DIRECT EXPENDITURES
Personnel 137,777$ 120,167$ 568,116$ 826,060$ 864,985$ 95%1,609,185$ 846,348$ (20,288)$
Materials & Supplies 31,836 125,583 211,924 369,343 475,385 78%700,870 327,391 41,952
Operational & Contractual 411,557 39,420 182,088 633,065 629,220 101%1,047,630 691,343 (58,278)
Other - - - - (12,000) 0%(206,200) (12,000) 12,000
Capital 59,617 92,773 33,104 185,494 176,000 105%226,000 119,221 66,273
Total Direct Expenditures 640,787$ 377,943$ 995,232$ 2,013,962$ 2,133,590$ 94%3,377,485$ 1,972,303$ 41,659$
Direct Revenues Over (Under) Expenditures 46,404$ (11,854)$ 294,000$ 328,550$ 101,690$ 323%(218,005)$ 182,097$ 146,453$
B&T Administration Overhead Allocation*111,541$ (111,541)$ -$ -$ -$ 0%-$ -$ -$
Operating Revenues Over (Under) Expenditures 157,945$ (123,395)$ 294,000$ 328,550$ 101,690$ 323%(218,005)$ 182,097$ 146,453$
Interfund Loan**-$ -$ -$ -$ -$ 0%-$ -$ -$
Transfer From General Fund - - - - 42,875 0%73,505 - -
Transfer From Infrastructure Fund 14,000 - - 14,000 13,990 100%24,000 14,000 -
Transfer From Water Fund 4,669 - - 4,669 4,665 100%8,000 4,669 -
Adjusted Operating Revenues Over (Under) Expenditures 176,614$ (123,395)$ 294,000$ 347,219$ 163,220$ (112,500)$ 200,766$ 146,453$
*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.
Total Direct Total Direct
Revenues Expenditures
6/30/17 Actual $ 2,342,512 2,013,962$
6/30/16 Actual $ 2,154,400 1,972,303$
% Change From Last Year 8.7%2.1%
Driving Program/
Memberships Greens Fees Range Fees Rentals User Fees
6/30/17 Actual $ 413,443 $ 552,776 $ 179,165 $ 211,877 $ 272,197
6/30/16 Actual $ 405,563 $ 508,409 $ 174,645 $ 211,805 $ 176,203
% Change From Last Year 1.9%8.7%2.6%0.0%54.5%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
6/30/17 Actual 826,060$ 369,343$ 633,065$ -$ 185,494$
6/30/16 Actual 846,348$ 327,391$ 691,343$ (12,000)$ 119,221$
% Change From Last Year -2.4%12.8%-8.4%0.0%55.6%
Five Year Trend
Revenues by Department 7/31/16 7/31/17 7/31/17 7/31/17 2017 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Programs 590,523$ 687,191$ 646,495$ 106.3%842,830$ 96,668$
Food & Beverage 330,261 366,089 127,800 286.5%532,350 33,428
Golf Club 1,233,616 1,289,232 567,997 227.0%1,784,300 55,616
Total Revenues 2,154,400$ 2,342,512$ 1,342,292$ 174.5%3,159,480$ 185,712$
Expenditures by Department 7/31/16 7/31/17 7/31/17 % of 2017 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Programs 647,810$ 640,787$ 344,363$ 186.1%992,140$ (7,023)$
Food & Beverage 324,272 377,943 281,968 134.0%633,545 53,671
Golf Club 1,000,221 995,232 778,751 127.8%1,751,800 (4,989)
Total Expenditures 1,972,303$ 2,013,962$ 1,405,082$ 143.3%3,377,485$ 41,659$
Explanation of Major Changes From Last Year:
Memberships revenue is up $7,880 compared to collections through July 2016. This is due to an increase in Golf Club memberships compared to last
year. Total Memberships revenue through July 2017 is $39,637 under budget due to Bath & Tennis Club memberships being lower than projected.
Greens Fees revenue is up $44,367 compared to collections through July 2016. This is due to the weather allowing the golf course to open early in 2017. Total
Greens Fees revenue through July 2017 is $46,216 over budget due to the course opening early during the 2017 season.
Program/User Fees revenue is up $95,994 compared to collections through July 2016. This is due to the timing of field rental receipts being collected vs. last year.
Total Program/User Fees revenue through July 2017 is $49,432 over budget due to field rental receipts being received earlier than anticipated.
Personnel expenditures are down $20,288 compared to payments through July 2016. This is due to final accrued time payouts in 2016 for the former Director. Total
Personnel expenditures through July 2017 are $38,925 under budget due to seasonal salaries being less than projected so far this year.
Materials & Supplies expenditures are up $41,952 compared to payments through July 2016. This is due to the timing of golf maintenance payments.
Total Operation & Contractual expenditures through July 2017 are $106,042 under budget due to the timing of payments for food and beverage inventory.
Operation & Contractual expenditures are down $58,278 compared to payments through July 2016. This is due to emergency repairs at the B&T Clubhouse in 2016.
Total Operation & Contractual expenditures through July 2017 are $3,845 over budget due to the general timing of payments.
Capital Outlay expenditures are up $66,273 compared to payments through July 2016. This is due to the renovation project at the B&T Clubhouse in 2017. Total
Capital Outlay expenditures through July 2017 are $9,484 over budget due to the timing of the B&T renovation project and delay in Golf capital spending.
Five Year Trend
Village of Oak Brook
Sports Core Fund - Major Sources Five Year Trend
For the Period Ending July 31, 2017
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Club Recreation Programs
For the Period Ending July 31, 2017 7/31/17 7/31/17
7/31/17 YTD % of 2017 7/31/16 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 -$ 215,752$ 7,588$ -$ -$ 223,340$ 273,080$ 82%273,080$ 224,901$ (1,561)$
Programs/User Fees (4,506) 87,461 16,904 - 172,338 272,197 222,765 122%387,750 176,203 95,994
Beverage Sales - - - - - - 225 0%300 - -
Other Revenue 899 3,070 125 - 187,560 191,654 180,155 106%181,700 189,419 2,235
Total Revenue (3,607)$ 306,283$ 24,617$ -$ 359,898$ 687,191$ 676,225$ 102%842,830$ 590,523$ 96,668$
Expenditures:
Personnel 99,693$ 19,858$ 13,185$ -$ 5,041$ 137,777$ 137,185$ 100%226,335$ 113,506$ 24,271$
Materials & Supplies 18,280 7,997 3,769 - 1,790 31,836 52,440 61%66,700 27,318 4,518
Operational & Contractual 76,054 106,438 14,170 40,000 174,895 411,557 383,755 107%638,105 464,759 (53,202)
Capital 8,924 30,070 - - 20,623 59,617 61,000 98%61,000 42,227 17,390
Total Expenditures 202,951$ 164,363$ 31,124$ 40,000$ 202,349$ 640,787$ 634,380$ 101%992,140$ 647,810$ (7,023)$
Direct Revenues Over (Under) Expenditures (206,558)$ 141,920$ (6,507)$ (40,000)$ 157,549$ 46,404$ 41,845$ 111%(149,310)$ (57,287)$ 103,691$
B&T Administration Overhead Allocation*206,558$ (74,361)$ (20,656)$ -$ -$ 111,541$ 103,205$ 108%176,890$ 44,575$ 66,966$
Revenues Over (Under) Expenditures -$ 67,559$ (27,163)$ (40,000)$ 157,549$ 157,945$ 145,050$ 109%27,580$ (12,712)$ 170,657$
Interfund Loan**-$ -$ -$ -$ -$ -$ -$ 0%-$ -$ -$
Transfer From General Fund - - - - - - 42,875 0%73,505 - -
Transfer From Infrastructure Fund 14,000 - - - - 14,000 13,990 100%24,000 14,000 -
Transfer From Water Fund 4,669 - - - - 4,669 4,665 100%8,000 4,669 -
Adjusted Revenues Over (Under) Expenditures 18,669$ 67,559$ (27,163)$ (40,000)$ 157,549$ 176,614$ 206,580$ 133,085$ 5,957$ 170,657$
*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 July 31, 2017
7/31/17 7/31/17
821 822 823 7/31/17 YTD % of 2017 7/31/16 Difference
B&T Poolside Golf YTD Amended Amended Adopted YTD Prior
Clubhouse Café Clubhouse Total Budget Budget Budget Total Year
Revenues:
Memberships 2,400$ -$ -$ 2,400$ -$ 0%4,500$ -$ -$
Food Sales - 32,463 76,889 109,352 102,210 107%163,850 102,737 6,615
Beverage Sales - 16,722 144,741 161,463 150,100 108%199,000 148,017 13,446
Other Revenue 92,874 - - 92,874 84,000 111%165,000 79,507 13,367
Total Revenue 95,274$ 49,185$ 221,630$ 366,089$ 336,310$ 109%532,350$ 330,261$ 33,428$
Expenditures:
Personnel 51,879$ 13,363$ 54,925$ 120,167$ 127,715$ 94%226,890$ 115,170$ 4,997$
Materials & Supplies 6,646 22,915 96,022 125,583 129,695 97%210,920 118,984 6,599
Operational & Contractual 34,659 1,076 3,685 39,420 82,920 48%160,735 90,118 (50,698)
Capital 76,400 16,373 - 92,773 35,000 265%35,000 - 92,773
Total Expenditures 169,584$ 53,727$ 154,632$ 377,943$ 375,330$ 101%633,545$ 324,272$ 53,671$
Direct Revenues Over (Under) Expenditures (74,310)$ (4,542)$ 66,998$ (11,854)$ (39,020)$ 30%(101,195)$ 5,989$ (17,843)$
B&T Administration Overhead Allocation*(103,279)$ (8,262)$ -$ (111,541)$ (103,205)$ 108%(176,890)$ (44,575)$ (66,966)$
Revenues Over (Under) Expenditures (177,589)$ (12,804)$ 66,998$ (123,395)$ (142,225)$ 87%(278,085)$ (38,586)$ (84,809)$
Transfer From General Fund -$ -$ -$ -$ -$ 0%-$ -$ -$
Adjusted Revenues Over (Under) Expenditures (177,589)$ (12,804)$ 66,998$ (123,395)$ (142,225)$ (278,085)$ (38,586)$ (84,809)$
*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 July 31, 2017
7/31/17 7/31/17
831 832 833 834 7/31/17 YTD % of 2017 7/31/16 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 187,703$ -$ -$ -$ 187,703$ 180,000$ 104%166,000$ 180,662$ 7,041$
Greens Fees 552,776 - - - 552,776 506,560 109%840,000 508,409 44,367
Pro Shop Sales 118,996 - - - 118,996 130,155 91%190,000 118,293 703
Golf Lessons - 35,042 - - 35,042 27,625 127%30,250 34,398 644
Driving Range Fees - 179,165 - - 179,165 175,500 102%225,000 174,645 4,520
Rentals 2,373 - 209,504 - 211,877 198,225 107%327,850 211,805 72
Other Revenue 3,673 - - - 3,673 4,680 78%5,200 5,404 (1,731)
Total Revenue 865,521$ 214,207$ 209,504$ -$ 1,289,232$ 1,222,745$ 105%1,784,300$ 1,233,616$ 55,616$
Expenditures:
Personnel 258,926$ 33,908$ 27,470$ 247,812$ 568,116$ 600,085$ 95%1,155,960$ 617,672$ (49,556)$
Materials & Supplies 90,311 11,243 3,930 106,440 211,924 293,250 72%423,250 181,089 30,835
Operational & Contractual 135,567 141 4,222 42,158 182,088 162,545 112%248,790 136,466 45,622
Other - - - - - (12,000) 0%(206,200) (12,000) 12,000
Capital 15,332 - 17,772 - 33,104 80,000 41%130,000 76,994 (43,890)
Total Expenditures 500,136$ 45,292$ 53,394$ 396,410$ 995,232$ 1,123,880$ 89%1,751,800$ 1,000,221$ (4,989)$
Direct Revenues Over (Under) Expenditures 365,385$ 168,915$ 156,110$ (396,410)$ 294,000$ 98,865$ 297%32,500$ 233,395$ 60,605$
Transfer from General Fund -$ -$ -$ -$ -$ -$ 0%-$ -$ -$
Adjusted Revenues Over (Under) Expenditures 365,385$ 168,915$ 156,110$ (396,410)$ 294,000$ 98,865$ 32,500$ 233,395$ 60,605$
7/31/17 7/31/17
7/31/16 7/31/17 YTD % of 2017 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Golf Surcharge 66,928$ 69,414$ 65,685$ 106%117,000$ 2,486$
Interest on Investments 2,006 3,552 1,470 242%2,500 1,546
Total Operating Revenues 68,934$ 72,966$ 67,155$ 109%119,500$ 4,032$
EXPENDITURES
Capital Outlay 22,036$ -$ -$ 0%-$ (22,036)$
Total Expenditures 22,036$ -$ -$ 0%-$ (22,036)$
NET FUND INCREASE (DECREASE)46,898$ 72,966$ 67,155$ 119,500$ 26,068$
Village of Oak Brook
Golf Surcharge Fund Financial Update
For the Period Ending July 31, 2017
Total Total
Revenues Expenditures
6/30/17 Actual $ 72,966 -$
6/30/16 Actual $ 68,934 22,036$
% Change From Last Year 5.8%-100.0%
Major Revenues
Golf Surcharge Interest
6/30/17 Actual $ 69,414 $ 3,552
6/30/16 Actual $ 66,928 $ 2,006
% Change From Last Year 3.7%77.1%
Five Year Trend
Major Expenditures Capital
Outlay
6/30/17 Actual -$
6/30/16 Actual 22,036$
% Change From Last Year -100.0%
Five Year Trend
Explanation of Major Changes From Last Year:
Golf Surcharge revenue is up $2,486 compared to collections through July 2016. This is due to an increase in golf rounds
played compared to last year. Total Golf Surcharge revenue through July 2017 is $3,729 over budget due to rounds
played being higher than projected.
Village of Oak Brook
Golf Surcharge Fund - Major Sources Five Year Trend
For the Period Ending July 31, 2017
Five Year Trend
Revenues Expenditures