07 - July 2018 Monthly Financial ReportVILLAGE
OAK BROOK
OF
MONTHLY FINANCIAL REPORTS
JULY 2018
ITEM 6.F
Total
Cash and Cash Pooled Cash and
Fund Equivalents Investments Investments % By Fund
General Corporate $7,494,294 $12,090,310 $19,584,603 44.4%
Hotel/Motel Tax 1,657,695 2,769,972 4,427,667 10.0%
Motor Fuel Tax 383,443 306,077 689,519 1.6%
Infrastructure 6,738,030 3,381,917 10,119,948 22.9%
Promenade TIF 4,440 - 4,440 0.0%
Water 4,163,677 1,439,465 5,603,143 12.7%
Sports Core 569,455 - 569,455 1.3%
Golf Surcharge 40,894 586,880 627,775 1.4%
Self-Insurance 367,678 - 367,678 0.8%
Garage 384,731 - 384,731 0.9%
Equipment Replacement 737,262 1,011,107 1,748,369 4.0%
Total $22,541,599 $21,585,728 $44,127,327 100.0%
Change in Cash and Investments by Fund :
Balance at Balance at Year-to-Date Year-to-Date
Fund January 1, 2018 July 31, 2018 Change ($)Change (%)
General Corporate $17,679,496 $19,584,603 $1,905,107 10.8%
Hotel/Motel Tax 4,172,234 4,427,667 255,434 6.1%
Motor Fuel Tax 574,460 689,519 115,059 20.0%
Infrastructure 8,222,145 10,119,948 1,897,803 23.1%
Promenade TIF 276,164 4,440 (271,724)-98.4%
Water 5,693,109 5,603,143 (89,967)-1.6%
Sports Core 472,473 569,455 96,981 20.5%
Golf Surcharge 559,073 627,775 68,701 12.3%
Self-Insurance 45,042 367,678 322,636 716.3%
Garage 427,409 384,731 (42,679)-10.0%
Equipment Replacement 1,805,752 1,748,369 (57,383)-3.2%
$39,927,358 $44,127,327 $4,199,969 10.5%
Book Market
Value Value
Pooled Checking $1,293,768 $1,293,768
Sports Core Checking 609,519 609,519
Pooled IPTIP 20,472,296 20,472,296
Water E-Pay IPTIP 166,016 166,016
$22,541,599 $22,541,599
Pooled Investments:
Investments-Municipal Bonds $7,636,681 $7,509,762
Investments-Corporate Bonds 6,420,491 6,414,568
Government & Agency Obligations 710,410 680,892
Certificates of Deposit 6,720,000 6,655,645
Accrued Interest 98,146 98,146
Total Pooled Investments $21,585,728 $21,359,013
Total Cash and Investments $44,127,327 $43,900,612
For July, total interest revenue is $67,209 and YTD interest revenue is $413,875.
Total investment yield for the portfolio is:
Pooled
Investments Illinois Funds Total
Monthly yield 0.16%0.18%0.17%
YTD yield 1.06%1.01%1.04%
Last 12 months yield 1.73%1.45%1.60%
The weighted average yield of the current pooled investment portfolio is 1.97%.
Monthly Treasurer's Report
July 31, 2018
Monthly Treasurer's Report
July 2018
The table below lists the detail investment holdings at J.P. Morgan Securities as of 7/31/18:
Month End VOB
Settlement Maturity Coupon Yield Book Market Accrued
Type Date Date Rate Rate Value Value Interest
Municipal Bonds:
Maryland St Econ Dev #57420PGK6 07/08/15 6/1/2019 2.050%2.123%$99,938 $99,567 $340
Rosemont IL GO Corp #777543UT4 02/08/16 12/1/2019 3.021%2.000%506,652 497,860 2,422
New York N Y City #64971QTX1 02/22/16 5/1/2021 2.350%2.000%201,856 196,242 1,161
Florida Hurricane #34074GDH4 03/30/16 7/1/2020 2.995%2.150%507,836 499,795 1,247
Bloomingdale Mich Pub Sch Dist #094383FS0 04/26/16 5/1/2022 2.710%2.150%510,016 488,685 3,349
Milan Mich Area Achs #598801JD1 05/26/16 5/1/2020 1.931%1.931%245,000 241,158 1,082
Indiana Bd Bk Rev Taxable #4546248F7 01/06/17 1/15/2020 2.934%1.900%258,745 255,543 346
Garland Cnty Ark Sales & Use #36609PAN3 02/06/17 11/1/2019 1.795%1.840%499,720 494,435 2,368
Anchor Bay Mich Sch Dist GO #032879TA6 02/13/17 5/1/2019 1.810%1.420%366,065 362,810 1,575
Macomb Cnty Mich Retirees #554885H63 04/11/17 11/1/2018 1.731%1.300%400,431 399,528 1,688
Lanse Creuse Mich Pub Schs #516228RL9 05/02/17 5/1/2020 2.159%2.159%100,000 98,902 537
California St GO Bonds #13063A7G3 05/08/17 10/1/2019 6.200%1.600%526,581 520,410 10,051
*Genesee Cnty Mich #371608UV0 05/31/17 10/1/2019 2.480%2.480%323,000 323,030 825
Connecticut St GO Bds 2016 #20772J3F7 06/15/17 8/15/2021 1.750%2.300%491,963 475,485 3,982
North Carolina Eastn Mun Pwr #65819WAL7 10/02/17 7/1/2019 2.578%1.700%504,000 499,585 931
Fowlerville Mich Comnty Schs #351280MS8 10/03/17 5/1/2020 2.045%1.750%502,544 493,375 2,386
Racine Cnty WI #749845UK7 12/20/17 12/1/2020 2.150%2.150%750,000 729,435 2,688
Wisconsin St Gen Fd Annual #977100CW4 01/05/18 5/1/2020 1.446%2.100%593,252 585,168 2,073
Illinois St G/O #452152HU8 04/03/18 3/1/2019 5.877%3.000%249,081 248,749 5,879
Total Municipal Bonds $7,636,681 $7,509,762 $44,928
Corporate Bonds:
American Honda Finance Corp #02665WAC5 01/25/18 10/10/2018 2.125%1.809%$1,000,590 $999,440 $6,493
JP Morgan Securities #44640QKV2 02/01/18 10/29/2018 2.082%2.082%1,492,293 1,491,375 0
Wells Fargo #94974BFQ8 04/25/18 1/15/2019 2.150%2.330%1,388,844 1,387,317 1,245
Huntington National Bank #446438RG0 07/06/18 4/1/2019 2.200%2.541%698,413 697,683 5,091
Bank of America #06051GFD6 07/06/18 4/1/2019 2.650%2.509%750,701 750,060 6,183
KeyBank #49327M2N3 07/19/18 3/8/2019 2.350%2.490%844,284 843,673 7,833
Bank of America #06051GFD6 07/30/18 4/1/2019 2.650%2.420%245,366 245,020 2,164
Total Corporate Bonds $6,420,491 $6,414,568 $29,009
Government & Agency Obligations:
**Government National Mtg Assn #38379UEM4 02/29/16 2/16/2051 2.300%2.245%$710,410 $680,892 $1,994
Total Government & Agency Obligations:$710,410 $680,892 $1,994
Certificates of Deposit:
Capital One Natl Assn VA #14042E5Z9 08/26/15 8/27/2018 1.750%1.750%$245,000 $244,978 $2,260
Ally Bk Midvale Utah #02006LVC4 10/29/15 10/29/2018 1.600%1.600%245,000 244,824 985
Bank Hope Los Angeles #062683AB3 08/26/16 8/27/2018 1.000%1.000%245,000 244,838 31
Wells Fargo Bank Natl Assn #949763AL0 08/31/16 8/31/2018 1.100%1.100%245,000 244,814 12
BMW Bank #05580AFG4 09/23/16 9/24/2018 1.100%1.100%245,000 244,642 962
Comenity Cap Bank #20033ASB3 09/26/16 9/26/2018 1.100%1.100%245,000 244,635 38
Enerbank #29266N4E4 10/21/16 10/22/2018 1.100%1.100%245,000 244,517 752
Discover Bank #254672L71 10/26/16 10/26/2018 1.200%1.200%245,000 244,385 780
State Bk India NY #8562846A7 01/26/17 1/26/2022 2.250%2.250%245,000 238,417 99
Marlin Business Bk #57116ANU8 05/10/17 11/12/2019 1.600%1.600%245,000 242,180 227
American Express Fed Svgs #02587CER7 05/10/17 11/12/2019 1.700%1.700%245,000 242,356 937
Synchrony Bank #87164WRA8 05/26/17 5/28/2019 1.650%1.650%245,000 243,785 708
Umpqua Bank #90421MAG8 05/31/17 5/31/2019 1.600%1.600%245,000 243,662 664
Stone Bk Mtn View Ark #86158RAJ8 06/28/17 6/28/2019 1.600%1.600%245,000 243,403 26
TIAA FSB Jacksonville #87270LAA1 07/19/17 7/19/2019 1.600%1.600%245,000 243,180 131
Peoples United Bank #71270QQZ2 07/19/17 7/19/2019 1.650%1.650%245,000 243,297 135
Priority Bank Ozark Ark #74269KBR6 07/26/17 7/26/2019 1.600%1.600%245,000 243,114 55
American Express Centurion #02587DV96 08/15/17 8/17/2020 1.900%1.900%245,000 239,904 2,114
Sallie Mae #795450C86 08/16/17 8/17/2020 1.900%1.900%245,000 240,622 2,114
Merrick Bank South Jordan #59013JZS1 08/21/17 8/21/2020 1.800%1.800%245,000 240,076 130
Pinnacle Bank #72345SFS5 08/30/17 8/31/2020 1.800%1.800%115,000 112,645 9
Jackson County Bank #466682AP6 08/31/17 3/1/2021 1.850%1.850%245,000 238,564 1,907
Barclays Bank #06740KKX4 09/27/17 9/28/2020 1.950%1.950%245,000 240,517 1,652
Capital One Bank #1404205E6 10/04/17 10/4/2019 1.700%1.700%245,000 242,815 1,348
Transportation Alliance #89388CCB2 10/13/17 4/12/2019 1.600%1.600%235,000 234,084 185
Goldman Sachs Bank #38148PRK5 10/18/17 10/19/2020 1.950%1.950%245,000 240,340 1,360
FirstBank PR Santurce #33767A6M8 11/03/17 11/3/2020 2.000%2.000%245,000 240,470 372
Morgan Stanley #61747MQ53 03/22/18 3/23/2020 2.550%2.550%245,000 244,584 2,221
Total Certificates of Deposits $6,720,000 $6,655,645 $22,215
Total J.P.Morgan Securities $21,487,582 $21,260,867 $98,146
*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, 2018
Cash & Investments by Fund - Total $44.1 million
Cash & Investments by Type - Total $44.1 million
Checking
Illinois Funds
Certificates of Deposit
Municipal Bonds
Corporate Bonds
Government & Agency Obligations
Accrued Interest
General Corporate
44.38%
Hotel/Motel Tax
10.03%Motor Fuel Tax
1.56%
Infrastructure
22.93%
Promenade TIF
0.01%
Water
12.70%
Sports Core
1.29%
Golf Surcharge
1.42%
Self-Insurance
0.83%Garage
0.87%
Equipment
Replacement
3.96%
Checking, $1.9
Illinois Funds, $20.6
Certificates of Deposit,
$6.7
Municipal Bonds, $7.6
Corporate Bonds, $6.4
Government & Agency
Obligations, $0.8
Accrued Interest, $0.1
in millions
Village of Oak Brook
Monthly Financial Report – Fund Narrative
For the Period Ending July 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 July 2018 are $1,252,169 higher than last year and $1,613,428 over
budget.
o Sales tax revenue, the General Fund’s largest revenue source, is down $118,634 from
last year and $47,166 under budget. This is due to the closure of two large taxpayers in
late 2017.
o Other intergovernmental tax revenue is down $54,307 from last year, but $56,347 over
budget. Revenue is down from last year due to extra one-time Income Tax payments
from the State. Revenue from Income Tax, Replacement Tax, and Use Tax has been
better than budgeted in 2018, despite a 10% reduction in Income Tax receipts by the
State.
o Telecommunications/utility tax revenue is up $103,441 from last year and $228,922
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,049,832 from last year and $1,185,835 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 July 2018 are $743,365 higher than last year, but $1,877,334 under
budget.
o Personnel expenditures are up $414,586 from last year, but $796,896 under budget.
The increase is due to general wage and benefits increases. Personnel is under budget
due to a delay in full pension funding that may occur later in 2018 and ongoing union
contract negotiations.
o Operation and contract expenditures are down $330,897 from last year and $452,433
under budget. This is due to a reduction in liability insurance payments and general
timing of payments.
o Capital outlay expenditures are up $628,620 from last year, but $507,349 under budget.
This is due to the general timing of projects scheduled, including the Police Department
expansion.
Hotel Tax Fund
Total revenues through July 2018 are $59,075 higher than last year and $36,688 over budget.
o Hotel tax revenue is up $51,054 from last year and $8,426 over budget. This is due to an
additional hotel in 2018 as Hyatt House opened in late 2017.
o Interest income revenue is up $16,375 from last year and $25,285 over budget. This is
due to favorable market conditions and rising interest rates.
Total expenditures through July 2018 are $396,296 lower than last year and $334,442 under
budget.
o Operation and contract expenditures are down $51,812 from last year and $179,617
under budget. Expenditures are down due to the timing of advertising expenditures
paid. Payments are still to come later in FY2018.
o Capital Outlay expenditures are down $348,068 from last year and $154,825 under
budget. This is due to the timing of projects being completed.
Motor Fuel Tax Fund
Total revenues through July 2018 are up $375 from last year, but $244 under budget. Motor
Fuel Tax receipts are slightly under budget, but are offset by increases in interest income.
Total expenditures through July 2018 are up $7,790 from last year, but $342,210 under budget.
This is due to the timing of the transfer of funds to the Infrastructure Fund to pay for roadway
improvements.
Infrastructure Fund
Total revenues through July 2018 are down $83,239 from last year, but $63,180 over budget.
o Non-home rule sales tax revenue is down $129,157 from last year and $2,875 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 $52,076 from last year and $66,231 over budget. This is
due to favorable market conditions and rising interest rates.
Total expenditures through July 2018 are down $227,970 from last year and $3,017,611 under
budget.
o Personnel expenditures are up $2,684 from last year, but $82,942 under budget.
Personnel is under budget due to employee turnover and ongoing union contract
negotiations.
o Operation and contract expenditures are down $191,491 from last year and $365,700
under budget. The reduction is due to a decrease in liability insurance premiums from
last year. Expenditures are under budget due to the timing of engineering payments.
o Capital outlay expenditures are down $57,388 from last year and $2,531,773 under
budget. This is due to the timing of roadway improvement projects.
Promenade TIF Fund
Total revenues through July 2018 are down $6,320 from last year and $5,301 under budget.
This is due to a decrease in real estate tax revenue from last year.
Total expenditures through July 2018 are up $35,148 from last year and $29,363 over budget.
The increase relates to additional principal paid towards the TIF note.
Water Fund
Total revenues through July 2018 are up $159,981 from last year and $106,045 over budget.
o Water sales revenue is up $132,237 from last year, but $35,481 under budget. The
increase from last year is due to a 7% rate increase effective 1/1/18. Water gallons sold
has also been less than projected so far this year causing sales to be under budget.
Total expenditures through July 2018 are up $1,266,248 from last year, but $1,860,066 under
budget.
o Operation and contract expenditures are up $17,475 from last year, but $1,438,140
under budget. The increase is due to more water being purchased from DuPage Water
Commission and a rate increase on gallons purchased. Expenditures are under budget
due to the timing of invoices paid.
o Capital outlay expenditures are up $1,287,429 from last year, but $359,052 under
budget. The increase relates to the start of the Village-wide water meter replacement
project.
Sports Core Fund
Total revenues through July 2018 are down $145,901 from last year and $88,739 under budget.
o Memberships are up $19,981 from last year and $249 over budget. Memberships from
both B&T and Golf are up in 2018 compared to last year.
o Greens Fees are down $40,671 from last year and $43,095 under budget. Rounds
played are down in 2018 due to unfavorable weather conditions.
o Rentals are up $48,613 from last year and $36,915 over budget. This is due to the
reclassification of driving range rental fees and the timing of fees received.
o Program/User Fees are down $126,461 from last year and $72,764 under budget. This
is due to the timing of soccer field rental payments and the reclassification of driving
range rental fees.
Total expenditures through July 2018 are down $14,282 from last year and $300,870 under
budget.
o Personnel expenditures are down $4,675 from last year and $15,275 under budget. This
is due to a reorganization and outsourcing of the Bath and Tennis administration.
o Materials & Supplies expenditures are down $110,153 from last year and $158,435
under budget. This is due to the timing of golf course maintenance supplies purchases.
o Operation and Contractual expenditures are up $112,005 from last year and $144,270
over budget. This is due to the outsourcing of swim operations to the Park District,
which required management fees to be paid before the season.
o Capital outlay expenditures are down $44,507 from last year and $214,673 under
budget. Expenses are under budget due to the general timing or cancellation of
budgeted projects.
Golf Surcharge Fund
Total revenues through July 2018 are down $4,265 from last year, but $329 over budget. Golf
surcharge revenue is down through July compared to last year due to inconsistent weather, but
offset by increases in interest income revenue.
No golf surcharge funds have been transferred or expended in 2018 so far.
Self Insurance Fund
Total revenues through July 2018 are down $3,289 from last year and $47,433 under budget.
This is due retirees moving to a new insurance plan in FY18.
Total expenditures through July 2018 are down $456,616 from last year and $329,251 under
budget. This is due to the timing of invoices paid.
Garage Fund
Total revenues through July 2018 are down $75,551 from last year, but $3,580 over budget.
This is due to a budgeted reduction in maintenance charges to use available net position
reserves.
Total expenditures through July 2018 are down $11,784 from last year and $85,573 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 July 2018 are down $247,771 from last year, but $31,081 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.
Total expenditures through July 2018 are down $1,823 from last year and $144,959 under
budget. This is due to the timing of scheduled vehicle replacements.
YTD YTD
Net Fund Budgeted
YTD YTD Increase Increase
Governmental Funds Revenues Expenditures (Decrease)(Decrease)
General Fund (Major Fund)15,654,575 $13,596,159 $2,058,416 $1,091,987
Main operating fund of the Village.
Hotel Fund (Major Fund)$773,188 $324,768 $448,420 $77,290
Collects and spends resources from the
3% hotel/motel tax.
Motor Fuel Tax Fund $122,849 $7,790 $115,059 ($227,395)
Collects and spends resources from the
State motor fuel tax.
Infrastructure Fund (Major Fund)$3,429,783 $1,472,384 $1,957,399 ($781,175)
Accounts for construction and maintenance of
roadways, drainage, and safety path systems.
Promenade TIF Fund (Major Fund)$221,499 $493,223 ($271,724)($237,060)
Accounts for the revenues and expenditures
restricted to the Tax Increment Financing (TIF)
district located at 22nd St. and Meyers Rd.
Enterprise Funds
Water Fund (Major Fund)$5,319,155 $4,535,014 $784,141 ($1,181,970)
Collects user fees for the distribution of water
and maintenance of infrastructure.
Sports Core Fund (Major Fund)$2,215,280 $1,999,680 $215,600 $3,455
Accounts for revenues and expenses relating
to administration, programs, food and beverage
operations, and golf course.
Golf Surcharge Fund $68,701 $0 $68,701 $69,030
Accounts for the collection of the $3 per round
golf surcharge.
Internal Service Funds
Self Insurance Fund $1,815,837 $1,592,199 $223,638 ($58,180)
Accounts for the Village's health insurance costs
and the related contributions from the Village,
employees, retirees, and other agencies.
Garage Fund $360,980 $370,777 ($9,797)($98,950)
Accounts for the maintenance of the Village's vehicle
fleet and the related departmental reimbursements.
Equipment Replacement Fund $266,106 $258,966 $7,140 ($168,900)
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 July 31, 2018
7/31/18 7/31/18
7/31/17 7/31/18 YTD % of 2018 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 7,238,468$ 7,119,834$ 7,167,000$ 99%12,453,000$ (118,634)$
Other Intergovernmental Tax 891,854 837,547 781,200 107%1,144,700 (54,307)
Telecommunications/Utility Tax 3,516,166 3,619,607 3,390,685 107%5,792,250 103,441
Licenses and Permits 1,460,543 2,510,375 1,324,540 190%1,784,070 1,049,832
Charges for Services 529,596 604,499 584,715 103%1,017,100 74,903
Fines and Penalties 89,308 105,725 87,760 120%150,500 16,417
Administrative Towing Fees 25,875 18,325 20,405 90%35,000 (7,550)
Interest on Investments 121,875 190,645 113,750 168%195,000 68,770
Franchise/IMF Maint. Fee 59,149 59,331 107,500 55%215,000 182
Miscellaneous Income 102,625 221,740 96,645 229%180,750 119,115
Total Operating Revenues 14,035,459$ 15,287,628$ 13,674,200$ 112%22,967,370$ 1,252,169$
OPERATING EXPENDITURES
Personnel 9,184,523$ 9,599,109$ 10,396,005$ 92%17,953,350$ 414,586$
Materials and Supplies 224,899 254,698 338,515 75%532,820 29,799
Operation and Contract 2,530,344 2,199,447 2,651,880 83%4,278,675 (330,897)
Other Expenditures 79,744 81,001 117,840 69%388,815 1,257
Capital Outlay 833,284 1,461,904 1,969,253 74%2,997,840 628,620
Total Operating Expenditures 12,852,794$ 13,596,159$ 15,473,493$ 88%26,151,500$ 743,365$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 1,182,665$ 1,691,469$ (1,799,293)$ (3,184,130)$ 508,804$
OTHER TRANSACTIONS
Transfers Out -$ -$ -$ 0%-$ -$
Interfund Loan - - - 0%- -
Reimbursements From Other Funds 360,094 366,947 416,115 88%713,360 6,853
Installment Contract Proceeds - - 2,475,165 0%2,475,165 -
Total Interfund Transactions 360,094$ 366,947$ 2,891,280$ 0%3,188,525$ 6,853$
NET FUND INCREASE (DECREASE)1,542,759$ 2,058,416$ 1,091,987$ 4,395$ 515,657$
Village of Oak Brook
General Fund Financial Update
For the Period Ending July 31, 2018
Total Total
Revenues Expenditures
7/31/18 Actual 15,287,628$ 13,596,159$
7/31/17 Actual 14,035,459$ 12,852,794$
% Change From Last Year 8.9%5.8%
Major Revenues Other
Intergov.Licenses &Charges for
Sales Tax Tax Telecom Tax Permits Services
7/31/18 Actual 7,119,834$ 837,547$ 3,619,607$ 2,510,375$ 604,499$
7/31/17 Actual $ 7,238,468 $ 891,854 $ 3,516,166 $ 1,460,543 $ 529,596
% Change From Last Year -1.6%-6.1%2.9%71.9%14.1%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
7/31/18 Actual 9,599,109$ 254,698$ 2,199,447$ 81,001$ 1,461,904$
7/31/17 Actual 9,184,523$ 224,899$ 2,530,344$ 79,744$ 833,284$
% Change From Last Year 4.5%13.2%-13.1%1.6%75.4%
Five Year Trend
Expenditures by Department
7/31/17 7/31/18 7/31/18 7/31/18 2018 Difference Five
YTD YTD YTD % of Annual Prior Year
Department Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 1,576,607$ 1,255,310$ 1,580,445$ 79.4%2,673,305$ (321,297)$
Financial Services 481,839 493,663 554,435 89.0%1,117,875 11,824
Public Works 396,341 359,999 558,215 64.5%993,820 (36,342)
Engineering & Capital Projects 591,308 1,367,781 1,706,423 80.2%2,732,665 776,473
Library 530,267 491,308 526,315 93.3%889,845 (38,959)
Police 4,690,051 4,910,350 5,151,555 95.3%8,705,350 220,299
Fire 4,029,830 4,182,849 4,816,635 86.8%8,043,215 153,019
Development Services 556,551 534,899 579,470 92.3%995,425 (21,652)
Total Expenditures 12,852,794$ 13,596,159$ 15,473,493$ 87.9%26,151,500$ 743,365$
Five Year Trend
For the Period Ending July 31, 2018
General Fund - Five Year Trend
Village of Oak Brook
Revenues Expenditures
7/31/18 7/31/18
7/31/17 7/31/18 YTD % of 2018 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Hotel Tax 676,372$ 727,426$ 719,000$ 101%1,340,000$ 51,054$
Interest 26,410 42,785 17,500 244%30,000 16,375
Miscellaneous 11,331 2,977 - N/A - (8,354)
Total Operating Revenues 714,113$ 773,188$ 736,500$ 105%1,370,000$ 59,075$
EXPENDITURES
Operation and Contract 260,010$ 208,198$ 387,815$ 54%646,515$ (51,812)$
Other Expenditures 54,481 58,065 58,065 100%99,550 3,584
Capital Outlay 406,573 58,505 213,330 27%640,000 (348,068)
Total Expenditures 721,064$ 324,768$ 659,210$ 49.3%1,386,065$ (396,296)$
NET FUND INCREASE (DECREASE)(6,951)$ 448,420$ 77,290$ (16,065)$ 455,371$
Note - Expenditures are recorded in program 171.
Village of Oak Brook
Hotel Tax Fund Financial Update
For the Period Ending July 31, 2018
Total Total
Revenues Expenditures
7/31/18 Actual $ 773,188 324,768$
7/31/17 Actual $ 714,113 721,064$
% Change From Last Year 8.3%-55.0%
Major Revenues
Grants Hotel Tax Interest Miscellaneous
7/31/18 Actual $ - $ 727,426 $ 42,785 $ 2,977
7/31/17 Actual $ - $ 676,372 $ 26,410 $ 11,331
% Change From Last Year 0.0%7.5%62.0%-73.7%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures Capital Outlay
7/31/18 Actual 208,198$ 58,065$ 58,505$
7/31/17 Actual 260,010$ 54,481$ 406,573$
% Change From Last Year -19.9%6.6%-85.6%
Five Year Trend
Village of Oak Brook
Hotel Tax Fund - Major Sources Five Year Trend
For the Period Ending July 31, 2018
Five Year Trend
Revenues Expenditures
7/31/18 7/31/18
7/31/17 7/31/18 YTD % of 2018 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 3,352,032$ 3,222,875$ 3,225,750$ 100%5,563,000$ (129,157)$
Grants 3,142 - - 0%- (3,142)
Interest 38,655 90,731 24,500 370%42,000 52,076
Miscellaneous 5,745 2,729 2,905 94%5,000 (3,016)
Total Operating Revenues 3,399,574$ 3,316,335$ 3,253,155$ 102%5,610,000$ (83,239)$
OPERATING EXPENDITURES
Personnel 697,929$ 700,613$ 783,555$ 89%1,365,445$ 2,684$
Materials and Supplies 69,315 86,161 123,350 70%182,955 16,846
Operation and Contract 729,941 538,450 904,150 60%1,484,755 (191,491)
Other Expenditures 94,794 96,173 96,180 100%164,865 1,379
Capital Outlay 108,375 50,987 2,582,760 2%5,625,620 (57,388)
Total Operating Expenditures 1,700,354$ 1,472,384$ 4,489,995$ 33%8,823,640$ (227,970)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 1,699,220$ 1,843,951$ (1,236,840)$ -149%(3,213,640)$ 144,731$
INTERFUND TRANSACTIONS
Transfers In -$ 7,790$ 350,000$ 2%500,000$ 7,790$
Reimbursements From Other Funds 103,040 105,658 105,665 100%181,130 2,618
Total Interfund Transactions 103,040$ 113,448$ 455,665$ 25%681,130$ 10,408$
NET FUND INCREASE (DECREASE)1,802,260$ 1,957,399$ (781,175)$ (2,532,510)$ 155,139$
Village of Oak Brook
Infrastructure Fund Financial Update
For the Period Ending July 31, 2018
Total Total
Revenues Expenditures
7/31/18 Actual $ 3,316,335 1,472,384$
7/31/17 Actual $ 3,399,574 1,700,354$
% Change From Last Year -2.4%-13.4%
Major Revenues
Sales Tax Grants Interest Miscellaneous Reimbursements
7/31/18 Actual $ 3,222,875 $ - $ 90,731 $ 2,729 $ 105,658
7/31/17 Actual $ 3,352,032 $ 3,142 $ 38,655 $ 5,745 $ 103,040
% Change From Last Year -3.9%-100.0%134.7%-52.5%2.5%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
7/31/18 Actual 700,613$ 86,161$ 538,450$ 96,173$ 50,987$
7/31/17 Actual 697,929$ 69,315$ 729,941$ 94,794$ 108,375$
% Change From Last Year 0.4%24.3%-26.2%1.5%-53.0%
Five Year Trend
Expenditures by Department
7/31/17 7/31/18 7/31/18 7/31/18 2018 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 89,969$ 81,495$ 103,695$ 78.6%178,530$ (8,474)$
Public Works 1,349,541 1,173,053 1,562,840 75.1%2,592,335 (176,488)
Engineering & Capital Projects 260,844 217,836 2,823,460 7.7%6,052,775 (43,008)
Total Expenditures 1,700,354$ 1,472,384$ 4,489,995$ 32.8%8,823,640$ (227,970)$
Five Year Trend
Village of Oak Brook
Infrastructure Fund - Major Sources Five Year Trend
For the Period Ending July 31, 2018
Revenues Expenditures
7/31/18 7/31/18
7/31/17 7/31/18 YTD % of 2018 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 35,077$ 34,169$ 34,150$ 100%102,500$ (908)$
Real Estate Tax 192,509 186,562 192,500 97%385,000 (5,947)
Interest 233 768 150 512%250 535
Total Operating Revenues 227,819$ 221,499$ 226,800$ 98%487,750$ (6,320)$
EXPENDITURES
Operation and Contract 3,695$ 3,403$ 4,040$ 84%4,090$ (292)$
Other Expenditures 454,380 489,820 459,820 107%459,820 35,440
Total Expenditures 458,075$ 493,223$ 463,860$ 106%463,910$ 35,148$
NET FUND INCREASE (DECREASE)(230,256)$ (271,724)$ (237,060)$ 23,840$ (41,468)$
Note - Expenditures are recorded in program 283.
Village of Oak Brook
Promenade TIF Fund Financial Update
For the Period Ending July 31, 2018
Total Total
Revenues Expenditures
7/31/18 Actual $ 221,499 493,223$
7/31/17 Actual $ 227,819 458,075$
% Change From Last Year -2.8%7.7%
Major Revenues Real Estate
Sales Tax Tax Interest
7/31/18 Actual $ 34,169 $ 186,562 $ 768
7/31/17 Actual $ 35,077 $ 192,509 $ 233
% Change From Last Year -2.6%-3.1%229.6%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures
7/31/18 Actual 3,403$ 489,820$
7/31/17 Actual 3,695$ 454,380$
% Change From Last Year -7.9%7.8%
Five Year Trend
Village of Oak Brook
Promenade TIF Fund - Major Sources Five Year Trend
For the Period Ending July 31, 2018
Five Year Trend
Revenues Expenditures
7/31/18 7/31/18
7/31/17 7/31/18 YTD % of 2018 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Grants 3,386$ -$ -$ 0%-$ (3,386)$
Plan Review Fees 1,264 600 1,155 52%2,000 (664)
Building/Inspection Fees 5,314 5,063 2,905 174%5,000 (251)
Water Sales 4,927,282 5,059,519 5,095,000 99%9,730,425 132,237
Unmetered Sales 11,155 21,736 17,500 124%30,000 10,581
Water Connection Fees 128,570 109,284 29,050 376%50,000 (19,286)
Fire Service Charge - - 2,905 0%5,000 -
Meter Charges 14,246 8,334 14,595 57%25,000 (5,912)
Special Services 15,286 16,394 15,000 109%30,000 1,108
Interest on Investments 18,157 52,031 5,845 890%10,000 33,874
Miscellaneous 34,514 46,194 29,155 158%50,000 11,680
Total Operating Revenues 5,159,174$ 5,319,155$ 5,213,110$ 102%9,937,425$ 159,981$
EXPENDITURES
Personnel 469,521$ 422,892$ 473,275$ 89%817,490$ (46,629)$
Materials and Supplies 28,617 34,511 46,995 73%76,860 5,894
Operation and Contract 2,500,230 2,517,705 3,955,845 64%6,780,015 17,475
Other Expenditures 234,269 236,348 236,355 100%405,170 2,079
Capital Outlay 36,129 1,323,558 1,682,610 79%2,710,220 1,287,429
Total Expenditures 3,268,766$ 4,535,014$ 6,395,080$ 71%10,789,755$ 1,266,248$
NET FUND INCREASE (DECREASE)1,890,408$ 784,141$ (1,181,970)$ (852,330)$ (1,106,267)$
Village of Oak Brook
Water Fund Financial Update
For the Period Ending July 31, 2018
Total Total
Revenues Expenditures
7/31/18 Actual $ 5,319,155 4,535,014$
7/31/17 Actual $ 5,159,174 3,268,766$
% Change From Last Year 3.1%38.7%
Unmetered Water
Water Sales Sales Connection Fees Meter Charges Miscellaneous
7/31/18 Actual $ 5,059,519 $ 21,736 $ 109,284 $ 8,334 $ 46,194
7/31/17 Actual $ 4,927,282 $ 11,155 $ 128,570 $ 14,246 $ 34,514
% Change From Last Year 2.7%94.9%-15.0%-41.5%33.8%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
7/31/18 Actual 422,892$ 34,511$ 2,517,705$ 236,348$ 1,323,558$
7/31/17 Actual 469,521$ 28,617$ 2,500,230$ 234,269$ 36,129$
% Change From Last Year -9.9%20.6%0.7%0.9%3563.4%
Five Year Trend
Expenditures by Department
7/31/17 7/31/18 7/31/18 7/31/18 2018 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Public Works 3,245,168$ 3,235,405$ 4,780,380$ 67.7%8,124,535$ (9,763)$
Engineering & Capital Projects 23,598 1,299,609 1,614,700 80.5%2,665,220 1,276,011
Total Expenditures 3,268,766$ 4,535,014$ 6,395,080$ 70.9%10,789,755$ 1,266,248$
Five Year Trend
Village of Oak Brook
Water Fund - Major Sources Five Year Trend
For the Period Ending July 31, 2018
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Sports Core Fund Consolidated Presentation
For the Period Ending July 31, 2018
7/31/18 7/31/18
7/31/18 YTD % of 2018 7/31/17 Difference
B&T Recreation Food &Golf YTD Amended Amended Adopted YTD Prior
Programs Beverage Club Total Budget Budget Budget Total Year
DIRECT REVENUES
Memberships 229,374$ -$ 204,050$ 433,424$ 433,175$ 100%414,875$ 413,443$ 19,981$
Greens Fees - - 512,105 512,105 555,200 92%975,000 552,776 (40,671)
Pro Shop Sales - - 128,990 128,990 130,155 99%200,000 118,996 9,994
Golf Lessons - - 22,512 22,512 33,500 67%40,000 35,042 (12,530)
Driving Range Fees - - 167,510 167,510 185,500 90%235,000 179,165 (11,655)
Rentals - - 260,490 260,490 223,575 117%451,000 211,877 48,613
Programs/User Fees 145,736 - - 145,736 218,500 67%300,700 272,197 (126,461)
Food Sales - 95,579 - 95,579 83,685 114%145,500 109,352 (13,773)
Beverage Sales - 138,392 - 138,392 134,990 103%236,000 161,463 (23,071)
Other Revenue 188,750 98,592 4,531 291,873 287,070 102%380,650 288,201 3,672
Total Direct Revenues 563,860$ 332,563$ 1,300,188$ 2,196,611$ 2,285,350$ 96%3,378,725$ 2,342,512$ (145,901)$
DIRECT EXPENDITURES
Personnel 98,631$ 138,472$ 584,282$ 821,385$ 836,660$ 98%1,497,200$ 826,060$ (4,675)$
Materials & Supplies 16,362 90,085 152,743 259,190 417,625 62%615,885 369,343 (110,153)
Operational & Contractual 546,693 57,261 141,116 745,070 600,800 124%961,510 633,065 112,005
Other - - 33,048 33,048 89,805 37%(44,275) - 33,048
Capital 71,955 9,988 59,044 140,987 355,660 40%365,660 185,494 (44,507)
Total Direct Expenditures 733,641$ 295,806$ 970,233$ 1,999,680$ 2,300,550$ 87%3,395,980$ 2,013,962$ (14,282)$
Direct Revenues Over (Under) Expenditures (169,781)$ 36,757$ 329,955$ 196,931$ (15,200)$ -1296%(17,255)$ 328,550$ (131,619)$
B&T Administration Overhead Allocation*74,964$ (74,964)$ -$ -$ -$ 0%-$ -$ -$
Operating Revenues Over (Under) Expenditures (94,817)$ (38,207)$ 329,955$ 196,931$ (15,200)$ -1296%(17,255)$ 328,550$ (131,619)$
Interfund Loan**-$ -$ -$ -$ -$ 0%-$ -$ -$
Transfer From General Fund - - - - - 0%- - -
Transfer From Infrastructure Fund 14,000 - - 14,000 14,000 100%24,000 14,000 -
Transfer From Water Fund 4,669 - - 4,669 4,655 100%8,000 4,669 -
Transfer From Golf Surcharge Fund - - - - - 0%- - -
Adjusted Operating Revenues Over (Under) Expenditures (76,148)$ (38,207)$ 329,955$ 215,600$ 3,455$ 14,745$ 347,219$ (131,619)$
*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
7/31/18 Actual $ 2,196,611 1,999,680$
7/31/17 Actual $ 2,342,512 2,013,962$
% Change From Last Year -6.2%-0.7%
Driving Program/
Memberships Greens Fees Range Fees Rentals User Fees
7/31/18 Actual $ 433,424 $ 512,105 $ 167,510 $ 260,490 $ 145,736
7/31/17 Actual $ 413,443 $ 552,776 $ 179,165 $ 211,877 $ 272,197
% Change From Last Year 4.8%-7.4%-6.5%22.9%-46.5%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
7/31/18 Actual 821,385$ 259,190$ 745,070$ 33,048$ 140,987$
7/31/17 Actual 826,060$ 369,343$ 633,065$ -$ 185,494$
% Change From Last Year -0.6%-29.8%17.7%N/A -24.0%
Five Year Trend
Revenues by Department 7/31/17 7/31/18 7/31/18 7/31/18 2018 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Programs 687,191$ 563,860$ 646,495$ 87.2%712,075$ (123,331)$
Food & Beverage 366,089 332,563 127,800 260.2%569,000 (31,126)
Golf Club 1,289,232 1,300,188 567,997 228.9%2,097,650 10,956
Total Revenues 2,342,512$ 2,196,611$ 1,342,292$ 163.6%3,378,725$ (143,501)$
Expenditures by Department 7/31/17 7/31/18 7/31/18 % of 2018 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Programs 640,787$ 733,641$ 344,363$ 213.0%1,058,430$ 92,854$
Food & Beverage 377,943 295,806 281,968 104.9%514,980 (82,137)
Golf Club 995,232 970,233 778,751 124.6%1,822,570 (24,999)
Total Expenditures 2,013,962$ 1,999,680$ 1,405,082$ 142.3%3,395,980$ (14,282)$
Five Year Trend
Village of Oak Brook
Sports Core Fund - Major Sources Five Year Trend
For the Period Ending July 31, 2018
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Club Recreation Programs
For the Period Ending July 31, 2018 7/31/18 7/31/18
7/31/18 YTD % of 2018 7/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$ 241,675$ 95%223,375$ 223,340$ 6,034$
Programs/User Fees (1,612) 18,778 22,070 - 106,500 145,736 218,500 67%300,700 272,197 (126,461)
Other Revenue 283 2,521 279 - 185,667 188,750 188,120 100%188,000 191,654 (2,904)
Total Revenue (1,329)$ 229,400$ 43,622$ -$ 292,167$ 563,860$ 648,295$ 87%712,075$ 687,191$ (123,331)$
Expenditures:
Personnel 66,173$ 16,264$ 10,999$ -$ 5,195$ 98,631$ 120,535$ 82%208,040$ 137,777$ (39,146)$
Materials & Supplies 5,000 9,287 2,075 - - 16,362 20,175 81%28,280 31,836 (15,474)
Operational & Contractual 46,897 272,725 30,499 10,000 186,572 546,693 376,845 145%586,160 411,557 135,136
Other - - - - - - 32,775 0%56,200 - -
Capital 19,423 52,154 - - 378 71,955 179,750 40%179,750 59,617 12,338
Total Expenditures 137,493$ 350,430$ 43,573$ 10,000$ 192,145$ 733,641$ 730,080$ 100%1,058,430$ 640,787$ 92,854$
Direct Revenues Over (Under) Expenditures (138,822)$ (121,030)$ 49$ (10,000)$ 100,022$ (169,781)$ (81,785)$ 208%(346,355)$ 46,404$ (216,185)$
B&T Administration Overhead Allocation*138,822$ (49,976)$ (13,882)$ -$ -$ 74,964$ 110,920$ 68%207,995$ 111,541$ (36,577)$
Revenues Over (Under) Expenditures -$ (171,006)$ (13,833)$ (10,000)$ 100,022$ (94,817)$ 29,135$ -325%(138,360)$ 157,945$ (252,762)$
Interfund Loan**-$ -$ -$ -$ -$ -$ -$ 0%-$ -$ -$
Transfer From General Fund - - - - - - - 0%- - -
Transfer From Infrastructure Fund 14,000 - - - - 14,000 14,000 100%24,000 14,000 -
Transfer From Water Fund 4,669 - - - - 4,669 4,655 100%8,000 4,669 -
Adjusted Revenues Over (Under) Expenditures 18,669$ (171,006)$ (13,833)$ (10,000)$ 100,022$ (76,148)$ 47,790$ (106,360)$ 176,614$ (252,762)$
*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, 2018
7/31/18 7/31/18
821 822 823 7/31/18 YTD % of 2018 7/31/17 Difference
B&T Poolside Golf YTD Amended Amended Adopted YTD Prior
Clubhouse Café Clubhouse Total Budget Budget Budget Total Year
Revenues:
Memberships -$ -$ -$ -$ 0%-$ 2,400$ -$
Food Sales - 27,592 67,987 95,579 83,685 114%145,500 109,352 (13,773)
Beverage Sales - 14,928 123,464 138,392 134,990 103%236,000 161,463 (23,071)
Other Revenue 98,592 - - 98,592 94,500 104%187,500 92,874 5,718
Total Revenue 98,592$ 42,520$ 191,451$ 332,563$ 313,175$ 106%569,000$ 366,089$ (31,126)$
Expenditures:
Personnel 61,628$ 11,034$ 65,810$ 138,472$ 112,065$ 124%199,505$ 120,167$ 18,305$
Materials & Supplies 8,551 9,568 71,966 90,085 104,230 86%182,150 125,583 (35,498)
Operational & Contractual 53,723 752 2,786 57,261 63,280 90%133,325 39,420 17,841
Capital 9,988 - - 9,988 - 0%- 92,773 (82,785)
Total Expenditures 133,890$ 21,354$ 140,562$ 295,806$ 279,575$ 106%514,980$ 377,943$ (82,137)$
Direct Revenues Over (Under) Expenditures (35,298)$ 21,166$ 50,889$ 36,757$ 33,600$ 109%54,020$ (11,854)$ 48,611$
B&T Administration Overhead Allocation*(69,411)$ (5,553)$ -$ (74,964)$ (110,920)$ 68%(175,995)$ (111,541)$ 36,577$
Revenues Over (Under) Expenditures (104,709)$ 15,613$ 50,889$ (38,207)$ (77,320)$ 49%(121,975)$ (123,395)$ 85,188$
Transfer From General Fund -$ -$ -$ -$ -$ 0%-$ -$ -$
Adjusted Revenues Over (Under) Expenditures (104,709)$ 15,613$ 50,889$ (38,207)$ (77,320)$ (121,975)$ (123,395)$ 85,188$
*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, 2018
7/31/18 7/31/18
831 832 833 834 7/31/18 YTD % of 2018 7/31/17 Difference
Golf General Golf Learning Golf Cart Golf Course YTD Amended Amended Adopted YTD Prior
Operation & Practice Operations Maintenance Total Budget Budget Budget Total Year
Revenues:
Memberships 204,050$ -$ -$ -$ 204,050$ 191,500$ 107%191,500$ 187,703$ 16,347$
Greens Fees 512,105 - - - 512,105 555,200 92%975,000 552,776 (40,671)
Pro Shop Sales 128,990 - - - 128,990 130,155 99%200,000 118,996 9,994
Golf Lessons - 22,512 - - 22,512 33,500 67%40,000 35,042 (12,530)
Driving Range Fees - 167,510 - - 167,510 185,500 90%235,000 179,165 (11,655)
Rentals 1,905 70,000 188,585 - 260,490 223,575 117%451,000 211,877 48,613
Other Revenue 4,531 - - - 4,531 4,450 102%5,150 3,673 858
Total Revenue 851,581$ 260,022$ 188,585$ -$ 1,300,188$ 1,323,880$ 98%2,097,650$ 1,289,232$ 10,956$
Expenditures:
Personnel 266,725$ 13,325$ 27,004$ 277,228$ 584,282$ 604,060$ 97%1,089,655$ 568,116$ 16,166$
Materials & Supplies 68,245 7,667 243 76,588 152,743 293,220 52%405,455 211,924 (59,181)
Operational & Contractual 109,333 858 246 30,679 141,116 160,675 88%242,025 182,088 (40,972)
Other - - 33,048 - 33,048 57,030 58%(100,475) - 33,048
Capital 17,434 - 40,922 688 59,044 175,910 34%185,910 33,104 25,940
Total Expenditures 461,737$ 21,850$ 101,463$ 385,183$ 970,233$ 1,290,895$ 75%1,822,570$ 995,232$ (24,999)$
Direct Revenues Over (Under) Expenditures 389,844$ 238,172$ 87,122$ (385,183)$ 329,955$ 32,985$ 1000%275,080$ 294,000$ 35,955$
Transfer from General Fund -$ -$ -$ -$ -$ -$ 0%-$ -$ -$
Adjusted Revenues Over (Under) Expenditures 389,844$ 238,172$ 87,122$ (385,183)$ 329,955$ 32,985$ 275,080$ 294,000$ 35,955$