09 - September 2019 Monthly Financial ReportVILLAGE
OAK BROOK
OF
MONTHLY FINANCIAL REPORTS
SEPTEMBER 2019
ITEM 6.D.
Total
Cash and Cash Pooled Cash and
Fund Equivalents Investments Investments % By Fund
General Corporate $6,448,705 $14,738,052 $21,186,757 45.0%
Hotel/Motel Tax 2,892,239 2,256,358 5,148,597 10.9%
Motor Fuel Tax 826,183 128,246 954,429 2.0%
Infrastructure 6,989,891 2,168,258 9,158,149 19.5%
Promenade TIF 245,425 - 245,425 0.5%
Water 4,977,021 3,048,896 8,025,917 17.1%
Sports Core 368,807 - 368,807 0.8%
Golf Surcharge 82,198 235,405 317,603 0.7%
Self-Insurance 531,001 - 531,001 1.1%
Garage 325,759 - 325,759 0.7%
Equipment Replacement 324,274 447,583 771,857 1.6%
Total $24,011,503 $23,022,798 $47,034,301 100.0%
Change in Cash and Investments by Fund :
Balance at Balance at Year-to-Date Year-to-Date
Fund January 1, 2019 September 30, 2019 Change ($)Change (%)
General Corporate $18,092,186 $21,186,757 $3,094,571 17.1%
Hotel/Motel Tax 4,843,367 5,148,597 305,230 6.3%
Motor Fuel Tax 782,203 954,429 172,226 22.0%
Infrastructure 9,322,381 9,158,149 (164,232)-1.8%
Promenade TIF 257,485 245,425 (12,060)-4.7%
Water 6,449,315 8,025,917 1,576,602 24.4%
Sports Core 190,397 368,807 178,410 93.7%
Golf Surcharge 442,152 317,603 (124,549)-28.2%
Self-Insurance 468,568 531,001 62,433 13.3%
Garage 331,134 325,759 (5,375)-1.6%
Equipment Replacement 1,636,238 771,857 (864,381)-52.8%
$42,815,426 $47,034,301 $4,218,875 9.9%
Book Bank/Market
Value Value
Pooled Checking $1,274,348 $1,766,152
Sports Core Checking 450,861 411,917
Pooled IPTIP 22,045,386 22,045,386
Water E-Pay IPTIP 240,908 240,908
$24,011,503 $24,464,363
Pooled Investments:
Investments-Municipal Bonds $6,201,157 $6,201,910
Investments-Corporate Bonds 8,306,234 8,372,324
Government & Agency Obligations 1,644,087 1,627,401
Certificates of Deposit 6,730,000 6,759,598
Accrued Interest 141,320 141,320
Total Pooled Investments $23,022,798 $23,102,553
Total Cash and Investments $47,034,301 $47,566,916
For September, total interest revenue is $85,638 and YTD revenue is $795,853.
Total investment yield for the portfolio is:
Pooled
Investments Illinois Funds Total
Last 12 months yield 2.32%2.39%2.36%
The weighted average yield of the current pooled investment portfolio is 2.36%. The IL Funds September average daily rate was 2.122%.
Monthly Treasurer's Report
September 30, 2019
Monthly Treasurer's Report
September 2019
The table below lists the detail investment holdings at J.P. Morgan Securities as of 9/30/19:
Month End VOB
Settlement Maturity Coupon Yield Book Market Accrued
Type Date Date Rate Rate Value Value Interest
Municipal Bonds:
Rosemont IL GO Corp #777543UT4 02/08/16 12/01/19 3.021%2.000%$500,788 $500,180 $4,940
New York N Y City #64971QTX1 02/22/16 05/01/21 2.350%2.000%201,074 201,736 1,945
Florida Hurricane #34074GDH4 03/30/16 07/01/20 2.995%2.150%503,048 503,450 3,743
Bloomingdale Mich Pub Sch Dist #094383FS0 04/26/16 05/01/22 2.710%2.150%506,965 507,840 5,607
Milan Mich Area Achs #598801JD1 05/26/16 05/01/20 1.931%1.931%245,000 244,975 1,870
Indiana Bd Bk Rev Taxable #4546248F7 01/06/17 01/15/20 2.934%1.900%255,721 255,676 1,593
Garland Cnty Ark Sales & Use #36609PAN3 02/06/17 11/01/19 1.795%1.840%499,979 499,885 3,864
Lanse Creuse Mich Pub Schs #516228RL9 05/02/17 05/01/20 2.159%2.159%100,000 100,092 897
California St GO Bonds #13063A7G3 05/08/17 10/01/19 6.200%1.600%500,015 500,000 15,218
Connecticut St GO Bds 2016 #20772J3F7 06/15/17 08/15/21 1.750%2.300%494,993 496,190 1,065
Fowlerville Mich Comnty Schs #351280MS8 10/03/17 05/01/20 2.045%1.750%500,859 500,535 4,090
Racine Cnty WI #749845UK7 12/20/17 12/01/20 2.150%2.150%750,000 747,637 5,375
Wisconsin St Gen Fd Annual #977100CW4 01/05/18 05/01/20 1.446%2.100%597,715 598,752 3,519
Wright County Min #982276BC0 07/18/19 12/01/20 2.000%2.000%545,000 544,962 2,725
Total Municipal Bonds $6,201,157 $6,201,910 $56,451
Corporate Bonds:
Goldman Sachs #38141GVP9 09/26/18 09/15/20 2.750%3.180%497,998 502,685 573
Wells Fargo #94974BGR5 01/15/19 12/07/20 2.550%3.120%1,380,931 1,397,464 11,520
SunTrust #86787EAU1 01/28/19 01/29/21 2.590%3.050%499,300 500,420 2,158
PNC Bank #69353RFH6 01/30/19 01/22/21 2.500%3.020%496,695 503,125 2,396
Morgan Stanley #61747WAL3 03/08/19 07/28/21 5.500%3.034%1,095,568 1,114,176 9,946
Citigroup #172967LC3 04/01/19 12/08/21 2.900%2.754%1,003,074 1,014,750 8,539
Bank of America #06051GFT1 04/03/19 10/19/20 2.625%2.625%700,000 704,445 8,014
Goldman Sachs #38143U8F1 05/02/19 02/25/21 2.875%2.707%365,828 368,146 1,022
American Honda #02665WBG5 07/31/19 09/09/21 1.700%2.180%495,474 497,785 542
BB&T Corp #05531FAZ6 08/15/19 02/01/21 2.150%2.010%751,382 751,238 2,491
JP Morgan #48128BAB7 09/30/19 01/15/23 2.972%2.337%1,019,984 1,018,090 6,274
Total Corporate Bonds $8,306,234 $8,372,324 $53,475
Government & Agency Obligations:
*Government National Mtg Assn #38379UEM4 02/29/16 02/16/51 2.300%2.245%$673,851 $658,769 $2,272
*Government National Mtg Assn #38381WV96 08/06/19 07/20/54 2.250%2.293%$970,236 $968,632 $1,790
Total Government & Agency Obligations:$1,644,087 $1,627,401 $4,062
Certificates of Deposit:
State Bk India NY #8562846A7 01/26/17 01/26/22 2.250%2.250%$245,000 $247,477 $1,018
Marlin Bank #57116ANU8 05/10/17 11/12/19 1.610%1.610%245,000 244,912 214
American Express Fed Svgs #02587CER7 05/10/17 11/12/19 1.700%1.700%245,000 244,936 1,631
American Express Centurion #02587DV96 08/15/17 08/17/20 1.900%1.900%245,000 245,211 582
Sallie Mae #795450C86 08/16/17 08/17/20 1.900%1.900%245,000 245,211 582
Merrick Bank South Jordan #59013JZS1 08/21/17 08/21/20 1.800%1.800%245,000 244,997 115
Pinnacle Bank #72345SFS5 08/30/17 08/31/20 1.800%1.800%115,000 114,999 2
Jackson County Bank #466682AP6 08/31/17 03/01/21 1.850%1.850%245,000 245,172 378
Barclays Bank #06740KKX4 09/27/17 09/28/20 1.950%1.950%245,000 245,363 40
Capital One Bank #1404205E6 10/04/17 10/04/19 1.700%1.700%245,000 244,995 2,042
Goldman Sachs Bank #38148PRK5 10/18/17 10/19/20 1.950%1.950%245,000 245,380 2,157
FirstBank PR Santurce #33767A6M8 11/03/17 11/03/20 2.000%2.000%245,000 245,529 356
Morgan Stanley #61747MQ53 03/22/18 03/23/20 2.550%2.550%245,000 245,835 13
Investors Community Bank #46147UTT7 08/28/18 02/28/20 2.550%2.550%245,000 245,696 25
Lakeside Bank #51210SPS0 08/30/18 03/30/20 2.550%2.550%245,000 245,867 7
Bank United #066519GJ2 08/31/18 02/20/20 2.500%2.500%245,000 245,652 510
Compass Bank #20451PVW3 10/26/18 10/26/20 3.000%3.000%245,000 248,107 3,154
UBS Bank #90348JFH8 10/30/18 10/29/20 3.050%3.050%245,000 248,283 12
Citibank #17294XJP2 10/31/18 10/31/20 3.000%3.000%245,000 245,149 3,113
Discover Bank #254673WF9 11/07/18 11/09/20 3.000%3.000%245,000 248,217 2,950
Ally Bank #02007GFX6 11/08/18 11/09/20 3.000%3.000%245,000 248,217 2,929
Comenity Cap Bank #20033AU46 04/15/19 04/15/21 2.500%2.500%245,000 247,607 240
Morgan Stanley #61760AE21 05/30/19 06/01/21 2.400%2.400%245,000 247,408 1,960
First St Bank DeQueen #336460CU2 07/18/19 07/19/21 2.000%2.000%245,000 245,870 189
Bank Hapoalim #06251AW89 07/19/19 07/19/21 2.000%2.000%245,000 246,299 1,021
Capital One Natl Assn #14042RMF5 07/24/19 07/26/19 2.050%2.050%245,000 246,093 1,046
TIAA FSB Jacksonville #87270LCN1 07/29/19 07/29/21 2.000%2.000%245,000 245,879 857
Wells Fargo #949763J31 09/18/19 09/20/21 1.850%1.850%245,000 245,237 189
Total Certificates of Deposits $6,730,000 $6,759,598 $27,332
Total J.P.Morgan Securities $22,881,478 $22,961,233 $141,320
*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 maturity date.
VILLAGE OF OAK BROOK
Monthly Treasurer's Report
September 30, 2019
Cash & Investments by Fund - Total $47.0 million
Cash & Investments by Type - Total $47.0 million
Checking
Illinois Funds
Certificates of Deposit
Municipal Bonds
Corporate Bonds
Government & Agency Obligations
Accrued Interest
General Corporate
45.05%
Hotel/Motel Tax
10.95%Motor Fuel Tax
2.03%
Infrastructure
19.47%
Promenade TIF
0.52%
Water
17.06%
Sports Core
0.78%
Golf Surcharge
0.68%
Self-Insurance
1.13%Garage
0.69%
Equipment
Replacement
1.64%
Checking, $1.7
Illinois Funds, $22.3
Certificates of Deposit,
$6.7
Municipal Bonds, $6.2
Corporate Bonds, $8.3
Government & Agency
Obligations, $1.7
Accrued Interest, $0.1
in millions
YTD YTD
Net Fund Budgeted
YTD YTD Increase Increase
Governmental Funds Revenues Expenditures (Decrease)(Decrease)
General Fund (Major Fund)21,139,857 $18,051,234 $3,088,623 $219,920
Main operating fund of the Village.
Hotel Fund (Major Fund)$1,048,385 $523,488 $524,897 ($2,503,040)
Collects and spends resources from the
3% hotel/motel tax.
Motor Fuel Tax Fund $172,226 $0 $172,226 ($447,180)
Collects and spends resources from the
State motor fuel tax.
Infrastructure Fund (Major Fund)$4,916,244 $4,980,433 ($64,189)($5,423,410)
Accounts for construction and maintenance of
roadways, drainage, and safety path systems.
Promenade TIF Fund (Major Fund)$452,667 $464,728 ($12,061)($71,015)
Accounts for the revenues and expenditures
restricted to the Tax Increment Financing (TIF)
district located at 22nd St. and Meyers Rd.
Enterprise Funds
Water Fund (Major Fund)$8,194,330 $6,960,317 $1,234,013 ($2,528,920)
Collects user fees for the distribution of water
and maintenance of infrastructure.
Sports Core Fund (Major Fund)$3,674,317 $3,545,320 $128,997 $190,980
Accounts for revenues and expenses relating
to administration, programs, food and beverage
operations, and golf course.
Golf Surcharge Fund $88,420 $212,969 ($124,549)($47,265)
Accounts for the collection of the $3 per round
golf surcharge.
Internal Service Funds
Self Insurance Fund $2,535,781 $2,320,169 $215,612 ($14,555)
Accounts for the Village's health insurance costs
and the related contributions from the Village,
employees, retirees, and other agencies.
Garage Fund $516,047 $521,754 ($5,707)($58,005)
Accounts for the maintenance of the Village's vehicle
fleet and the related departmental reimbursements.
Equipment Replacement Fund $192,235 $1,055,784 ($863,549)($1,047,580)
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 September 30, 2019
Village of Oak Brook
Monthly Financial Report – Fund Narrative
For the Period Ending September 30, 2019
The monthly financial report serves as a document to inform and update readers of ƚhe Village͛Ɛ
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.
TƌaŶƐacƚiŽŶƐ fŽƌ each mŽŶƚh aƌe cŽmƉaƌed ƚŽ amŽƵŶƚƐ fƌŽm ƚhe Village͛Ɛ aŶŶƵal bƵdgeƚ͕ ǁhich ǁaƐ alƐŽ
prepared using a cash basis.
The proceeding pages contain detailed information on significant items by individual fund:
General Fund
x Sales Tax collections through
September 2019 are $9,431,654,
which is $187,150 higher than
through September 2018 and
$207,904 over FY19 budget to date.
The increase is primarily due to the
opening of newer businesses in town
and general inflationary growth.
September 2019 collections have
been relatively consistent with with
the last 5 years.
x Other Intergovernmental Tax collections through September 2019 are $1,122,891, which is
$122,293 higher than through September 2018 and $137,641 over FY19 budget to date. The
Village has seen strong collections in Income Tax, Replacement Tax, Road & Bridge Tax, and Use
Tax so far in 2019.
x Telecommunications/Utility Tax collections through September 2019 are $4,730,763, which is
$123,917 higher than through September 2018 and $295,413 over FY19 budget to date. The
Village bƵdgeƚed a decƌeaƐe iŶ ƚadž dƵe ƚŽ ƚhe mŽǀe Žf McDŽŶald͛Ɛ͕ bƵƚ has not seen a negative
impact to date.
x Licenses and Permits revenue through September 2019 is $3,076,334, which is $251,456 higher
than through September 2018 and $1,297,559 over FY19 budget to date. The Village issued a
number of large building permits in 2019, including Senior Lifestyle.
x Charges for Services revenue through September 2019 is $987,379, which is $119,501 higher
than through September 2018, but $106,396 under FY19 budget to date. The increase is due to
the raise of ambulance fees in mid-2018. Revenue is under budget due to more ambulance
unallowable billings than projected and timing of police auxiliary services billings.
x Personnel expenditures through September 2019 are $13,459,378, which is $705,979 more than
through September 2018, but $492,787 under FY19 budget to date. The increase is due to
normal salary and benefit increases. Personnel is under budget in FY19 due to a delay in full
pension funding until later in the year and ongoing labor negotiations.
x Operation and Contract expenditures through September 2019 are $3,047,953, which is
$301,610 more than through September 2018, but $167,202 under FY19 budget to date. The
increase is primarily due to the addition of five contracted paramedics to increase ambulance
services. This number will be reduced from eleven to nine contracted paramedics later in 2019.
x Capital Outlay expenditures through September 2019 are $771,866, which is $1,352,540 less
than through September 2018 and $71,984 under FY19 budget to date. The decrease is due to
the Police Department expansion and renovation project that occurred in 2018. Budgeted
projects for 2019 are still expected to occur later in the year as planned.
Hotel Tax Fund
x Hotel Tax collections through September 2019 are $962,651, which is $17,096 higher than
through September 2018 and $49,651 over FY19 budget to date. The variances are primarily
due to the timing of receipts.
x Capital Outlay expenditures through September 2019 are $69,313, which is $62,990 higher than
through September 2018, but $2,858,532 under FY19 budget to date. Many projects have not
occurred yet in 2019 due to the delay in the Jorie, Kensington, and Forest Gate streetscape
beautification project. This project may occur later in 2019 or 2020.
Infrastructure Fund
x Non-Home Rule Sales Tax collections
through September 2019 are
$4,275,306, which is $83,275 higher
than through September 2018 and
$95,056 over FY19 budget to date.
The increase is primarily due to the
opening of newer businesses in town
and general inflationary growth.
September 2019 collections have
been relatively consistent with with
the last 5 years.
x Operation and Contractual expenditures through September 2019 are $1,111,876, which is
$280,027 higher than through September 2018, but $162,729 under FY19 budget to date. The
increase is due to more being spent on project engineering than in 2018. Expenditures are
under budget due to the timing of invoices paid.
x Capital Outlay expenditures through September 2019 are $2,669,839, which is $2,599,767
higher than through September 2018, but $5,540,171 under FY19 budget to date. The increase
from last year is due to the B&T Circle drainage improvement project and Salt Storage Facility
drainage. Projects are expected to occur later in FY19 or early FY20 as planned.
Water Fund
x Water Sales revenue through September 2019 is $7,544,391, which is $60,835 higher than
through September 2018, but $279,349 under FY19 budget to date. The increase is due to a 5%
rate increase effective January 1, 2019, however, slightly less gallons have been billed than
projected.
x Operation and Contractual expenditures through September 2019 are $3,500,804, which is
$301,286 lower than through September 2018 and $874,246 under FY19 budget to date. The
decrease is due to less total gallons purchased from DuPage Water Commission compared to
FY18. Payments are under budget due to the general timing of when invoices have been paid
compared to when budgeted.
x Capital Outlay expenditures through September 2019 are $2,404,041, which is $557,698 higher
than through September 2018, but $2,880,279 under FY19 budget to date. The 2019 water
main replacement projects recently kicked off and are expected to continue throughout the
remainder of 2019. No major water main projects were done in 2018.
Sports Core Fund
x Memberships revenue through September 2019 is $419,681, which is $13,743 lower than
through September 2018 and $34,134 under FY19 budget to date. Memberships for the pool,
tennis, and golf are all less than 2018 totals and coming in less than projected for 2019.
x Greens Fees revenue through September 2019 is $847,535, which is $38,728 higher than
through September 2018, but $16,475 under FY19 budget to date. Total rounds played is
consistent with the 2018 season so far despite the unfavorable weather during early 2019.
x Operational & Contractual expenditures through September 2019 are $842,231, which is
$171,957 lower than through September 2018 and $172,434 under FY19 budget to date. The
decrease in FY19 is due to the timing of payments and the cancellation of the Taste of Oak Brook
event.
x Capital Outlay expenditures through September 2019 are $921,498, which is $716,673 higher
than through August 2018 and $80,598 over FY19 budget to date. The FY19 increase is due to
the Golf Club pro shop renovation, finishing of the golf patio, and finishing the B&T generator
installation project. Expenditures are over budget to date due to the timing of B&T renovations
and the completion of the golf patio work carrying into 2019.
Equipment Replacement Fund
x Other Expenditures through September 2019 are $1,007,191, which is even with FY19 budget to
date. This includes a $1,000,000 equity transfer to the General Fund, Infrastructure Fund, Water
Fund, and Garage Fund as a result of switching to a leasing program.
9/30/19 9/30/19
9/30/18 9/30/19 YTD % of 2019 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 9,244,504$ 9,431,654$ 9,223,750$ 102.3%12,325,000$ 187,150$
Other Intergovernmental Tax*1,000,598 1,122,891 985,250 114.0%1,227,750 122,293
Telecommunications/Utility Tax 4,606,846 4,730,763 4,435,350 106.7%5,857,500 123,917
Licenses and Permits 2,824,878 3,076,334 1,778,775 172.9%2,335,050 251,456
Charges for Services 867,878 987,379 1,093,775 90.3%1,491,400 119,501
Fines and Penalties 132,693 171,046 118,530 144.3%158,000 38,353
Administrative Towing Fees 24,475 16,042 22,500 71.3%30,000 (8,433)
Interest on Investments 254,189 347,294 247,500 140.3%330,000 93,105
Franchise/IMF Maint. Fee 107,304 106,424 159,750 66.6%213,000 (880)
Miscellaneous Income 323,005 167,639 155,450 107.8%212,800 (155,366)
Total Operating Revenues 19,386,370$ 20,157,466$ 18,220,630$ 110.6%24,180,500$ 771,096$
OPERATING EXPENDITURES
Personnel 12,753,399$ 13,459,378$ 13,952,165$ 96.5%18,183,745$ 705,979$
Materials and Supplies 335,125 332,173 444,390 74.7%559,780 (2,952)
Operation and Contract 2,746,343 3,047,953 3,215,155 94.8%4,224,475 301,610
Other Expenditures 4,400 7,336 7,500 97.8%10,000 2,936
Capital Outlay 2,124,406 771,866 843,850 91.5%862,475 (1,352,540)
Total Operating Expenditures 17,963,673$ 17,618,706$ 18,463,060$ 95.4%23,840,475$ (344,967)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 1,422,697$ 2,538,760$ (242,430)$ 340,025$ 1,116,063$
OTHER TRANSACTIONS
Transfers In -$ 508,235$ 508,235$ 100.0%508,235$ 508,235$
Transfers Out - (334,203) (421,725) 79.2%(1,216,725) (334,203)
Reimbursements From Other Funds 471,789 474,156 474,165 100.0%632,210 2,367
Reimbursements To Other Funds (98,487) (98,325) (98,325) 100.0%(131,100) 162
Total Interfund Transactions 373,302$ 549,863$ 462,350$ 118.9%(207,380)$ 176,561$
NET FUND INCREASE (DECREASE)1,795,999$ 3,088,623$ 219,920$ 132,645$ 1,292,624$
*Includes the collection of Income Tax, Use Tax, Road & Bridge Tax, and Personal Property Replacement Tax.
Village of Oak Brook
General Fund Financial Update
For the Period Ending September 30, 2019
Total Total
Revenues Expenditures
9/30/19 Actual 20,157,466$ 17,618,706$
9/30/18 Actual 19,386,370$ 17,963,673$
% Change From Last Year 4.0%-1.9%
Major Revenues Other
Intergov.Licenses &Charges for
Sales Tax Tax Telecom Tax Permits Services
9/30/19 Actual 9,431,654$ 1,122,891$ 4,730,763$ 3,076,334$ 987,379$
9/30/18 Actual $ 9,244,504 $ 1,000,598 $ 4,606,846 $ 2,824,878 $ 867,878
% Change From Last Year 2.0%12.2%2.7%8.9%13.8%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
9/30/19 Actual 13,459,378$ 332,173$ 3,047,953$ 7,336$ 771,866$
9/30/18 Actual 12,753,399$ 335,125$ 2,746,343$ 4,400$ 2,124,406$
% Change From Last Year 5.5%-0.9%11.0%66.7%-63.7%
Five Year Trend
Expenditures by Department
9/30/18 9/30/19 9/30/19 9/30/19 2019 Difference Five
YTD YTD YTD % of Annual Prior Year
Department Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 1,682,986$ 1,762,145$ 2,008,940$ 87.7%2,700,820$ 79,159$
Financial Services 540,731 563,549 604,690 93.2%782,860 22,818
Public Works 495,101 665,464 690,140 96.4%886,420 170,363
Engineering & Capital Projects 1,990,371 393,984 344,925 114.2%459,900 (1,596,387)
Library 661,254 691,918 711,385 97.3%928,675 30,664
Police 6,302,397 6,755,879 7,021,930 96.2%8,891,960 453,482
Fire 5,580,560 6,072,142 6,332,200 95.9%8,207,785 491,582
Development Services 710,273 713,625 748,850 95.3%982,055 3,352
Total Expenditures 17,963,673$ 17,618,706$ 18,463,060$ 95.4%23,840,475$ (344,967)$
Five Year Trend
For the Period Ending September 30, 2019
General Fund - Five Year Trend
Village of Oak Brook
Revenues Expenditures
9/30/19 9/30/19
9/30/18 9/30/19 YTD % of 2019 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Hotel Tax 945,555$ 962,651$ 913,000$ 105.4%1,268,000$ 17,096$
Interest 57,656 85,734 22,500 381.0%30,000 28,078
Miscellaneous 2,977 - - 0.0%- (2,977)
Total Operating Revenues 1,006,188$ 1,048,385$ 935,500$ 112.1%1,298,000$ 42,197$
EXPENDITURES
Operation and Contract 367,625$ 376,838$ 433,385$ 87.0%577,860$ 9,213$
Capital Outlay 6,323 69,313 2,927,845 2.4%4,180,545 62,990
Total Expenditures 373,948$ 446,151$ 3,361,230$ 13.3%4,758,405$ 72,203$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 632,240$ 602,234$ (2,425,730)$ -24.8%(3,460,405)$ (30,006)$
INTERFUND TRANSACTIONS
Reimbursements to Other Funds (74,655) (77,337)$ (77,310)$ 100.0%(103,115)$ (2,682)$
Total Interfund Transactions (74,655)$ (77,337)$ (77,310)$ 100.0%(103,115)$ (2,682)$
NET FUND INCREASE (DECREASE)557,585$ 524,897$ (2,503,040)$ (3,563,520)$ (32,688)$
Note - Expenditures are recorded in program 171.
Village of Oak Brook
Hotel Tax Fund Financial Update
For the Period Ending September 30, 2019
Total Total
Revenues Expenditures
9/30/19 Actual $ 1,048,385 446,151$
9/30/18 Actual $ 1,006,188 373,948$
% Change From Last Year 4.2%19.3%
Major Revenues
Hotel Tax Interest Miscellaneous
9/30/19 Actual $ 962,651 $ 85,734 $ -
9/30/18 Actual $ 945,555 $ 57,656 $ 2,977
% Change From Last Year 1.8%48.7%-100.0%
Five Year Trend
Major Expenditures Operation &
Contractual Capital Outlay
9/30/19 Actual 376,838$ 69,313$
9/30/18 Actual 367,625$ 6,323$
% Change From Last Year 2.5%996.2%
Five Year Trend
Village of Oak Brook
Hotel Tax Fund - Major Sources Five Year Trend
For the Period Ending September 30, 2019
Five Year Trend
Revenues Expenditures
9/30/19 9/30/19
9/30/18 9/30/19 YTD % of 2019 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 4,192,031$ 4,275,306$ 4,180,250$ 102.3%5,548,000$ 83,275$
Charges for Services - 965 - N/A - 965
Interest 124,923 173,765 63,000 275.8%80,000 48,842
Miscellaneous 2,729 - 3,735 0.0%5,000 (2,729)
Total Operating Revenues 4,319,683$ 4,450,036$ 4,246,985$ 104.8%5,633,000$ 130,353$
OPERATING EXPENDITURES
Personnel 916,808$ 972,678$ 995,490$ 97.7%1,322,375$ 55,870$
Materials and Supplies 97,091 104,891 135,370 77.5%246,845 7,800
Operation and Contract 831,849 1,111,876 1,274,605 87.2%1,663,435 280,027
Capital Outlay 70,072 2,669,839 8,210,010 32.5%10,008,575 2,599,767
Total Operating Expenditures 1,915,820$ 4,859,284$ 10,615,475$ 45.8%13,241,230$ 2,943,464$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 2,403,863$ (409,248)$ (6,368,490)$ 6.4%(7,608,230)$ (2,813,111)$
INTERFUND TRANSACTIONS
Transfers In 7,790$ 216,125$ 816,125$ 26.5%1,116,125$ 208,335$
Reimbursements From Other Funds 135,846 250,083 250,110 100.0%333,445 114,237
Reimbursements To Other Funds (123,651) (121,149) (121,155) 100.0%(161,535) 2,502
Total Interfund Transactions 19,985$ 345,059$ 945,080$ 36.5%1,288,035$ 325,074$
NET FUND INCREASE (DECREASE)2,423,848$ (64,189)$ (5,423,410)$ (6,320,195)$ (2,488,037)$
Village of Oak Brook
Infrastructure Fund Financial Update
For the Period Ending September 30, 2019
Total Total
Revenues Expenditures
9/30/19 Actual $ 4,450,036 4,859,284$
9/30/18 Actual $ 4,319,683 1,915,820$
% Change From Last Year 3.0%153.6%
Major Revenues
Sales Tax Grants Interest Miscellaneous
9/30/19 Actual $ 4,275,306 $ 965 $ 173,765 $ -
9/30/18 Actual $ 4,192,031 $ - $ 124,923 $ 2,729
% Change From Last Year 2.0%0.0%39.1%-100.0%
Five Year Trend
Major Expenditures Materials &Operation &
Personnel Supplies Contractual Capital Outlay
9/30/19 Actual 972,678$ 104,891$ 1,111,876$ 2,669,839$
9/30/18 Actual 916,808$ 97,091$ 831,849$ 70,072$
% Change From Last Year 6.1%8.0%33.7%3710.1%
Five Year Trend
Expenditures by Department
9/30/18 9/30/19 9/30/19 9/30/19 2019 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 114,212$ 120,137$ 129,265$ 92.9%179,485$ 5,925$
Public Works 1,418,558 3,001,755 5,706,750 52.6%6,462,865 1,583,197
Engineering & Capital Projects 383,050 1,737,392 4,779,460 36.4%6,760,415 1,354,342
Total Expenditures 1,915,820$ 4,859,284$ 10,615,475$ 45.8%13,402,765$ 2,943,464$
Five Year Trend
Village of Oak Brook
Infrastructure Fund - Major Sources Five Year Trend
For the Period Ending September 30, 2019
Revenues Expenditures
9/30/19 9/30/19
9/30/18 9/30/19 YTD % of 2019 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 34,169$ 39,820$ 33,500$ 118.9%100,000$ 5,651$
Real Estate Tax 373,123 411,687 360,000 114.4%360,000 38,564
Interest 783 1,160 675 171.9%900 377
Total Operating Revenues 408,075$ 452,667$ 394,175$ 114.8%460,900$ 44,592$
EXPENDITURES
Operation and Contract 3,403$ 3,748$ 4,210$ 89.0%4,210$ 345$
Other Expenditures 489,820 460,980 460,980 100.0%460,980 (28,840)
Total Expenditures 493,223$ 464,728$ 465,190$ 99.9%465,190$ (28,495)$
NET FUND INCREASE (DECREASE)(85,148)$ (12,061)$ (71,015)$ (4,290)$ 73,087$
Note - Expenditures are recorded in program 283.
Village of Oak Brook
Promenade TIF Fund Financial Update
For the Period Ending September 30, 2019
Total Total
Revenues Expenditures
9/30/19 Actual $ 452,667 464,728$
9/30/18 Actual $ 408,075 493,223$
% Change From Last Year 10.9%-5.8%
Major Revenues Real Estate
Sales Tax Tax Interest
9/30/19 Actual $ 39,820 $ 411,687 $ 1,160
9/30/18 Actual $ 34,169 $ 373,123 $ 783
% Change From Last Year 16.5%10.3%48.1%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures
9/30/19 Actual 3,748$ 460,980$
9/30/18 Actual 3,403$ 489,820$
% Change From Last Year 10.1%-5.9%
Five Year Trend
Village of Oak Brook
Promenade TIF Fund - Major Sources Five Year Trend
For the Period Ending September 30, 2019
Five Year Trend
Revenues Expenditures
9/30/19 9/30/19
9/30/18 9/30/19 YTD % of 2019 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Plan Review Fees 675 1,125$ 1,125$ 100.0%1,500$ 450$
Building/Inspection Fees 7,688 5,963 3,740 159.4%5,000 (1,725)
Water Sales 7,483,556 7,544,391 7,823,740 96.4%10,223,250 60,835
Unmetered Sales 26,113 32,297 22,500 143.5%30,000 6,184
Water Connection Fees 110,894 166,730 37,400 445.8%50,000 55,836
Fire Service Charge - - 3,740 0.0%5,000 -
Meter Charges 8,635 24,017 15,005 160.1%20,000 15,382
Special Services 16,394 16,772 15,000 111.8%30,000 378
Interest on Investments 70,584 134,870 41,220 327.2%55,000 64,286
Miscellaneous 61,014 47,080 56,250 83.7%75,000 (13,934)
Total Operating Revenues 7,785,553$ 7,973,245$ 8,019,720$ 99.4%10,494,750$ 187,692$
EXPENDITURES
Personnel 565,903$ 593,927$ 636,830$ 93.3%828,710$ 28,024$
Materials and Supplies 53,703 47,671 59,650 79.9%76,210 (6,032)
Operation and Contract 3,802,090 3,500,804 4,375,050 80.0%5,822,285 (301,286)
Capital Outlay 1,846,343 2,404,041 5,284,320 45.5%6,244,075 557,698
Total Expenditures 6,268,039$ 6,546,443$ 10,355,850$ 63.2%12,971,280$ 278,404$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 1,517,514$ 1,426,802$ (2,336,130)$ (2,476,530)$ (90,712)$
INTERFUND TRANSACTIONS
Transfers In -$ 221,085$ 221,085$ 100.0%221,085$ 221,085
Reimbursements To Other Funds (303,876) (413,874) (413,875) 100.0%(551,830) (109,998)
Total Interfund Transactions (303,876)$ (192,789)$ (192,790)$ 100.0%(330,745)$ 111,087$
NET FUND INCREASE (DECREASE)1,213,638$ 1,234,013$ (2,528,920)$ (2,807,275)$ 20,375$
Village of Oak Brook
Water Fund Financial Update
For the Period Ending September 30, 2019
Total Total
Revenues Expenditures
9/30/19 Actual $ 7,973,245 6,546,443$
9/30/18 Actual $ 7,785,553 6,268,039$
% Change From Last Year 2.4%4.4%
Unmetered Water
Water Sales Sales Connection Fees Meter Charges Miscellaneous
9/30/19 Actual $ 7,544,391 $ 32,297 $ 166,730 $ 24,017 $ 47,080
9/30/18 Actual $ 7,483,556 $ 26,113 $ 110,894 $ 8,635 $ 61,014
% Change From Last Year 0.8%23.7%50.4%178.1%-22.8%
Five Year Trend
Materials &Operation &
Personnel Supplies Contractual Capital Outlay
9/30/19 Actual 593,927$ 47,671$ 3,500,804$ 2,404,041$
9/30/18 Actual 565,903$ 53,703$ 3,802,090$ 1,846,343$
% Change From Last Year 5.0%-11.2%-7.9%30.2%
Five Year Trend
Expenditures by Department
9/30/18 9/30/19 9/30/19 9/30/19 2019 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Public Works 4,385,233$ 4,135,336$ 5,086,525$ 81.3%7,299,035$ (249,897)$
Engineering & Capital Projects 1,882,806 2,411,107 5,269,325 45.8%6,224,075 528,301
Total Expenditures 6,268,039$ 6,546,443$ 10,355,850$ 63.2%13,523,110$ 278,404$
Five Year Trend
Village of Oak Brook
Water Fund - Major Sources Five Year Trend
For the Period Ending September 30, 2019
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Sports Core Fund Consolidated Presentation
For the Period Ending September 30, 2019
9/30/19 9/30/19
9/30/19 YTD % of 2019 9/30/18 Difference
B&T Recreation Food &Golf YTD Amended Amended Adopted YTD Prior
Programs Beverage Club Total Budget Budget Budget Total Year
DIRECT REVENUES
Memberships 222,006$ -$ 197,675$ 419,681$ 453,815$ 92.5%453,815$ 433,424$ (13,743)$
Greens Fees - - 847,535 847,535 864,010 98.1%930,000 808,807 38,728
Pro Shop Sales - - 184,751 184,751 173,000 106.8%200,000 166,474 18,277
Golf Lessons - - 33,606 33,606 40,000 84.0%40,000 22,512 11,094
Driving Range Fees - - 235,664 235,664 233,130 101.1%226,000 208,578 27,086
Rentals - - 301,948 301,948 414,975 72.8%459,000 377,442 (75,494)
Programs/User Fees 273,751 - - 273,751 208,540 131.3%253,450 207,871 65,880
Food Sales - 170,499 - 170,499 162,945 104.6%175,500 148,738 21,761
Beverage Sales - 250,685 - 250,685 232,515 107.8%252,500 215,934 34,751
Other Revenue 126,017 250,316 8,689 385,022 358,160 107.5%428,300 380,203 4,819
Total Direct Revenues 621,774$ 671,500$ 1,809,868$ 3,103,142$ 3,141,090$ 98.8%3,418,565$ 2,969,983$ 133,159$
DIRECT EXPENDITURES
Personnel 109,238$ 236,049$ 915,552$ 1,260,839$ 1,264,625$ 99.7%1,572,920$ 1,212,996$ 47,843$
Materials & Supplies 39,156 204,380 277,216 520,752 513,780 101.4%580,645 443,644 77,108
Operational & Contractual 513,198 79,203 249,830 842,231 1,014,665 83.0%1,115,975 1,014,188 (171,957)
Other - - - - (83,150) 0.0%(83,150) (128,577) 128,577
Capital 265,464 354,127 301,907 921,498 840,900 109.6%1,655,900 204,825 716,673
Total Direct Expenditures 927,056$ 873,759$ 1,744,505$ 3,545,320$ 3,550,820$ 99.8%4,842,290$ 2,747,076$ 798,244$
Direct Revenues Over (Under) Expenditures (305,282)$ (202,259)$ 65,363$ (442,178)$ (409,730)$ 107.9%(1,423,725)$ 222,907$ (665,085)$
B&T Administration Overhead Allocation*105,990$ (105,990)$ -$ -$ -$ 0.0%-$ -$ -$
Operating Revenues Over (Under) Expenditures (199,292)$ (308,249)$ 65,363$ (442,178)$ (409,730)$ 107.9%(1,423,725)$ 222,907$ (665,085)$
Transfer From General Fund 48,704$ 285,499$ -$ 334,203$ 421,725$ 79.2%1,216,725$ -$ 334,203$
Transfer From Golf Surcharge Fund - - 212,969 212,969 155,000 137.4%175,000 - 212,969
Reimbursement From Infrastructure Fund 18,000 - - 18,000 18,000 100.0%24,000 18,000 -
Reimbursement From Water Fund 6,003 - - 6,003 5,985 100.3%8,000 6,003 -
Adjusted Operating Revenues Over (Under) Expenditures (126,585)$ (22,750)$ 278,332$ 128,997$ 190,980$ -$ 246,910$ (117,913)$
*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 and cash becomes available.
Total Direct Total Direct
Revenues Expenditures
9/30/19 Actual $ 3,103,142 3,545,320$
9/30/18 Actual $ 2,969,983 2,747,076$
% Change From Last Year 4.5%29.1%
Driving Program/
Memberships Greens Fees Range Fees Rentals User Fees
9/30/19 Actual $ 419,681 $ 847,535 $ 235,664 $ 301,948 $ 273,751
9/30/18 Actual $ 433,424 $ 808,807 $ 208,578 $ 377,442 $ 207,871
% Change From Last Year -3.2%4.8%13.0%-20.0%31.7%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
9/30/19 Actual 1,260,839$ 520,752$ 842,231$ -$ 921,498$
9/30/18 Actual 1,212,996$ 443,644$ 1,014,188$ (128,577)$ 204,825$
% Change From Last Year 3.9%17.4%-17.0%-100.0%349.9%
Five Year Trend
Revenues by Department 9/30/18 9/30/19 9/30/19 9/30/19 2019 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Programs 625,498$ 621,774$ 646,495$ 96.2%686,515$ (3,724)$
Food & Beverage 549,737 671,500 127,800 525.4%663,000 121,763
Golf Club 1,794,748 1,809,868 567,997 318.6%2,069,050 15,120
Total Revenues 2,969,983$ 3,103,142$ 1,342,292$ 231.2%3,418,565$ 133,159$
Expenditures by Department 9/30/18 9/30/19 9/30/19 % of 2019 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Programs 957,702$ 927,056$ 344,363$ 269.2%1,883,075$ (30,646)$
Food & Beverage 476,422 873,759 281,968 309.9%1,037,845 397,337
Golf Club 1,312,952 1,744,505 778,751 224.0%1,921,370 431,553
Total Expenditures 2,747,076$ 3,545,320$ 1,405,082$ 252.3%4,842,290$ 798,244$
Five Year Trend
Village of Oak Brook
Sports Core Fund - Major Sources Five Year Trend
For the Period Ending September 30, 2019
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Club Recreation Programs
For the Period Ending September 30, 2019 9/30/19 9/30/19
9/30/19 YTD % of 2019 9/30/18 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 -$ 207,256$ 14,750$ -$ -$ 222,006$ 244,815$ 90.7%244,815$ 229,374$ (7,368)$
Programs/User Fees - 19,732 46,586 - 207,433 273,751 208,540 131.3%253,450 207,871 65,880
Other Revenue (1,084) 6,473 5,888 - 114,740 126,017 188,110 67.0%188,250 188,253 (62,236)
Total Revenue (1,084)$ 233,461$ 67,224$ -$ 322,173$ 621,774$ 641,465$ 96.9%686,515$ 625,498$ (3,724)$
Expenditures:
Personnel 85,691$ 19,585$ -$ -$ 3,962$ 109,238$ 167,345$ 65.3%182,405$ 141,321$ (32,083)$
Materials & Supplies 24,726 13,719 711 - - 39,156 25,170 155.6%26,350 18,228 20,928
Operational & Contractual 59,583 274,179 56,005 - 123,431 513,198 647,380 79.3%673,820 706,565 (193,367)
Capital 25,195 228,586 - - 11,683 265,464 205,500 129.2%1,000,500 91,588 173,876
Total Expenditures 195,195$ 536,069$ 56,716$ -$ 139,076$ 927,056$ 1,045,395$ 88.7%1,883,075$ 957,702$ (30,646)$
Direct Revenues Over (Under) Expenditures (196,279)$ (302,608)$ 10,508$ -$ 183,097$ (305,282)$ (403,930)$ 75.6%(1,196,560)$ (332,204)$ 26,922$
B&T Administration Overhead Allocation*196,279$ (70,661)$ (19,628)$ -$ 105,990$ 88,320$ 120.0%91,410$ 111,504$ (5,514)$
Revenues Over (Under) Expenditures -$ (373,269)$ (9,120)$ -$ 183,097$ (199,292)$ (315,610)$ 63.1%(1,105,150)$ (220,700)$ 21,408$
Transfer From General Fund 12,476$ 36,228$ -$ -$ -$ 48,704$ 170,500$ 28.6%965,500$ -$ 48,704$
Reimbursement From Infrastructure Fund 18,000 - - - - 18,000 18,000 100.0%24,000 18,000 -$
Reimbursement From Water Fund 6,003 - - - - 6,003 5,985 100.3%8,000 6,003 -
Adjusted Revenues Over (Under) Expenditures 36,479$ (337,041)$ (9,120)$ -$ 183,097$ (126,585)$ (121,125)$ (107,650)$ (196,697)$ 70,112$
*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. This will be repaid as the season begins and cash becomes available.
Village of Oak Brook
Monthly Operating Statement
Sports Core Food & Beverage Programs
For the Period Ending September 30, 2019
9/30/19 9/30/19
821 822 823 9/30/19 YTD % of 2019 9/30/18 Difference
B&T Poolside Golf YTD Amended Amended Adopted YTD Prior
Clubhouse Café Clubhouse Total Budget Budget Budget Total Year
Revenues:
Food Sales -$ 35,375$ 135,124$ 170,499$ 162,945$ 104.6%175,500$ 148,738$ 21,761$
Beverage Sales - 19,534 231,151 250,685 232,515 107.8%252,500 215,934 34,751
Other Revenue 250,316 - - 250,316 165,000 151.7%235,000 185,065 65,251
Total Revenue 250,316$ 54,909$ 366,275$ 671,500$ 560,460$ 119.8%663,000$ 549,737$ 121,763$
Expenditures:
Personnel 99,571$ 29,839$ 106,639$ 236,049$ 233,375$ 101.1%286,125$ 204,627$ 31,422$
Materials & Supplies 19,072 30,849 154,459 204,380 180,665 113.1%208,200 150,247 54,133
Operational & Contractual 72,115 25 7,063 79,203 124,775 63.5%153,120 111,560 (32,357)
Capital 354,127 - - 354,127 390,400 90.7%390,400 9,988 344,139
Total Expenditures 544,885$ 60,713$ 268,161$ 873,759$ 929,215$ 94.0%1,037,845$ 476,422$ 397,337$
Direct Revenues Over (Under) Expenditures (294,569)$ (5,804)$ 98,114$ (202,259)$ (368,755)$ 54.8%(374,845)$ 73,315$ (275,574)$
B&T Administration Overhead Allocation*(98,139)$ (7,851)$ -$ (105,990)$ (88,320)$ 120.0%(91,410)$ (111,504)$ 5,514$
Revenues Over (Under) Expenditures (392,708)$ (13,655)$ 98,114$ (308,249)$ (457,075)$ 67.4%(466,255)$ (38,189)$ (270,060)$
Transfer From General Fund 285,499$ -$ -$ 285,499$ 251,225$ 113.6%251,225$ -$ 285,499$
Adjusted Revenues Over (Under) Expenditures (107,209)$ (13,655)$ 98,114$ (22,750)$ (205,850)$ (215,030)$ (38,189)$ 15,439$
*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 September 30, 2019
9/30/19 9/30/19
831 832 833 834 9/30/19 YTD % of 2019 9/30/18 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 197,675$ -$ -$ -$ 197,675$ 209,000$ 94.6%209,000$ 204,050$ (6,375)$
Greens Fees 847,535 - - - 847,535 864,010 98.1%930,000 808,807 38,728
Pro Shop Sales 184,751 - - - 184,751 173,000 106.8%200,000 166,474 18,277
Golf Lessons - 33,606 - - 33,606 40,000 84.0%40,000 22,512 11,094
Driving Range Fees - 235,664 - - 235,664 233,130 101.1%226,000 208,578 27,086
Rentals 4,231 - 297,717 - 301,948 414,975 72.8%459,000 377,442 (75,494)
Other Revenue 8,689 - - - 8,689 5,050 172.1%5,050 6,885 1,804
Total Revenue 1,242,881$ 269,270$ 297,717$ -$ 1,809,868$ 1,939,165$ 93.3%2,069,050$ 1,794,748$ 15,120$
Expenditures:
Personnel 382,468$ 56,822$ 48,337$ 427,925$ 915,552$ 863,905$ 106.0%1,104,390$ 867,048$ 48,504$
Materials & Supplies 119,865 16,914 1,329 139,108 277,216 307,945 90.0%346,095 275,169 2,047
Operational & Contractual 170,173 631 51,095 27,931 249,830 242,510 103.0%289,035 196,063 53,767
Other - - - - - (83,150) 0.0%(83,150) (128,577) 128,577
Capital 221,773 - - 80,134 301,907 245,000 123.2%265,000 103,249 198,658
Total Expenditures 894,279$ 74,367$ 100,761$ 675,098$ 1,744,505$ 1,576,210$ 110.7%1,921,370$ 1,312,952$ 431,553$
Direct Revenues Over (Under) Expenditures 348,602$ 194,903$ 196,956$ (675,098)$ 65,363$ 362,955$ 18.0%147,680$ 481,796$ (416,433)$
Transfer from Golf Surcharge 212,969$ -$ -$ -$ 212,969$ 155,000$ 137.4%175,000$ -$ 212,969$
Adjusted Revenues Over (Under) Expenditures 561,571$ 194,903$ 196,956$ (675,098)$ 278,332$ 517,955$ 322,680$ 481,796$ (203,464)$