11 - November 2019 Monthly Financial ReportVILLAGE
OAK BROOK
OF
MONTHLY FINANCIAL REPORTS
NOVEMBER 2019
ITEM 6.D
Total
Cash and Cash Pooled Cash and
Fund Equivalents Investments Investments % By Fund
General Corporate $6,686,146 $14,806,888 $21,493,034 47.1%
Hotel/Motel Tax 2,948,391 2,366,646 5,315,037 11.6%
Motor Fuel Tax 904,060 108,024 1,012,084 2.2%
Infrastructure 6,467,062 2,027,233 8,494,295 18.6%
Promenade TIF 271,967 - 271,967 0.6%
Water 3,746,273 3,272,863 7,019,136 15.4%
Sports Core 280,391 - 280,391 0.6%
Golf Surcharge 127,023 214,422 341,445 0.7%
Self-Insurance 335,635 - 335,635 0.7%
Garage 311,513 - 311,513 0.7%
Equipment Replacement 349,023 444,557 793,580 1.7%
Total $22,427,484 $23,240,633 $45,668,117 100.0%
Change in Cash and Investments by Fund :
Balance at Balance at Year-to-Date Year-to-Date
Fund January 1, 2019 November 30, 2019 Change ($)Change (%)
General Corporate $18,092,186 $21,493,034 $3,400,848 18.8%
Hotel/Motel Tax 4,843,367 5,315,037 471,670 9.7%
Motor Fuel Tax 782,203 1,012,084 229,881 29.4%
Infrastructure 9,322,381 8,494,295 (828,086)-8.9%
Promenade TIF 257,485 271,967 14,482 5.6%
Water 6,449,315 7,019,136 569,821 8.8%
Sports Core 190,397 280,391 89,994 47.3%
Golf Surcharge 442,152 341,445 (100,707)-22.8%
Self-Insurance 468,568 335,635 (132,933)-28.4%
Garage 331,134 311,513 (19,621)-5.9%
Equipment Replacement 1,636,238 793,580 (842,658)-51.5%
$42,815,426 $45,668,117 $2,852,691 6.7%
Book Bank/Market
Value Value
Pooled Checking $546,373 $1,652,628
Sports Core Checking 36,176 27,930
Pooled IPTIP 21,754,791 21,754,791
Water E-Pay IPTIP 90,144 90,144
$22,427,484 $23,525,493
Pooled Investments:
Investments-Municipal Bonds $6,449,703 $6,450,269
Investments-Corporate Bonds 8,303,469 8,366,853
Government & Agency Obligations 2,096,668 2,083,065
Certificates of Deposit 6,240,000 6,276,498
Accrued Interest 150,793 150,793
Total Pooled Investments $23,240,633 $23,327,478
Total Cash and Investments $45,668,117 $46,852,971
For November, total interest revenue is $78,299 and YTD revenue is $956,875.
Total investment yield for the portfolio is:
Pooled
Investments Illinois Funds Total
Last 12 months yield 2.33%2.33%2.33%
The weighted average yield of the current pooled investment portfolio is 2.35%. The IL Funds November average daily rate was 1.76%.
Monthly Treasurer's Report
November 30, 2019
Monthly Treasurer's Report
November 2019
The table below lists the detail investment holdings at J.P. Morgan Securities as of 11/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,000 $500,000 $7,553
New York N Y City #64971QTX1 02/22/16 05/01/21 2.350%2.000%200,960 201,050 377
Florida Hurricane #34074GDH4 03/30/16 07/01/20 2.995%2.150%502,354 503,400 6,239
Bloomingdale Mich Pub Sch Dist #094383FS0 04/26/16 05/01/22 2.710%2.150%506,523 506,850 1,090
Milan Mich Area Achs #598801JD1 05/26/16 05/01/20 1.931%1.931%245,000 245,181 293
Indiana Bd Bk Rev Taxable #4546248F7 01/06/17 01/15/20 2.934%1.900%255,284 255,344 2,840
Lanse Creuse Mich Pub Schs #516228RL9 05/02/17 05/01/20 2.159%2.159%100,000 100,146 178
Connecticut St GO Bds 2016 #20772J3F7 06/15/17 08/15/21 1.750%2.300%495,433 496,695 2,523
Fowlerville Mich Comnty Schs #351280MS8 10/03/17 05/01/20 2.045%1.750%500,615 500,420 682
Racine Cnty WI #749845UK7 12/20/17 12/01/20 2.150%2.150%750,000 750,000 8,063
Wisconsin St Gen Fd Annual #977100CW4 01/05/18 05/01/20 1.446%2.100%598,362 599,430 627
Wright County Min #982276BC0 07/18/19 12/01/20 2.000%2.000%545,000 545,687 4,542
State of IL #452152P54 10/09/19 11/01/21 5.000%1.870%529,464 527,305 1,832
Anchor Bay Mich Sch #032879TE8 11/01/19 05/01/21 2.320%1.750%720,708 718,761 1,244
Total Municipal Bonds $6,449,703 $6,450,269 $38,083
Corporate Bonds:
Goldman Sachs #38141GVP9 09/26/18 09/15/20 2.750%3.180%498,345 502,545 2,865
Wells Fargo #94974BGR5 01/15/19 12/07/20 2.550%3.120%1,382,206 1,398,020 17,427
SunTrust #86787EAU1 01/28/19 01/29/21 2.590%3.050%499,681 500,360 4,317
PNC Bank #69353RFH6 01/30/19 01/22/21 2.500%3.020%497,112 502,750 4,479
Morgan Stanley #61747WAL3 03/08/19 07/28/21 5.500%3.034%1,091,478 1,108,958 19,571
Citigroup #172967LC3 04/01/19 12/08/21 2.900%2.754%1,002,845 1,015,030 13,372
Bank of America #06051GFT1 04/03/19 10/19/20 2.625%2.625%700,000 704,018 1,889
Goldman Sachs #38143U8F1 05/02/19 02/25/21 2.875%2.707%365,730 368,442 2,771
American Honda #02665WBG5 07/31/19 09/09/21 1.700%2.180%495,858 498,455 1,959
BB&T Corp #05531FAZ6 08/15/19 02/01/21 2.150%2.010%751,212 750,915 5,178
JP Morgan #48128BAB7 09/30/19 01/15/23 2.972%2.337%1,019,002 1,017,360 11,228
Total Corporate Bonds $8,303,469 $8,366,853 $85,056
Government & Agency Obligations:
*Government National Mtg Assn #38379UEM4 02/29/16 02/16/51 2.300%2.245%$669,464 $656,496 $2,313
*Government National Mtg Assn #38381WV96 08/06/19 07/20/54 2.250%2.293%937,204 937,172 1,721
Fed Farm Credit Bank #3133EK5Y8 11/14/19 02/14/22 1.770%1.770%490,000 489,397 723
Total Government & Agency Obligations:$2,096,668 $2,083,065 $4,757
Certificates of Deposit:
State Bk India NY #8562846A7 01/26/17 01/26/22 2.250%2.250%$245,000 $247,776 $1,937
American Express Centurion #02587DV96 08/15/17 08/17/20 1.900%1.900%245,000 245,546 1,358
Sallie Mae #795450C86 08/16/17 08/17/20 1.900%1.900%245,000 245,546 1,358
Merrick Bank South Jordan #59013JZS1 08/21/17 08/21/20 1.800%1.800%245,000 245,380 113
Pinnacle Bank #72345SFS5 08/30/17 08/31/20 1.800%1.800%115,000 115,186 177
Jackson County Bank #466682AP6 08/31/17 03/01/21 1.850%1.850%245,000 245,735 1,133
Barclays Bank #06740KKX4 09/27/17 09/28/20 1.950%1.950%245,000 245,740 836
Goldman Sachs Bank #38148PRK5 10/18/17 10/19/20 1.950%1.950%245,000 245,799 558
FirstBank PR Santurce #33767A6M8 11/03/17 11/03/20 2.000%2.000%245,000 245,946 354
Morgan Stanley #61747MQ53 03/22/18 03/23/20 2.550%2.550%245,000 245,737 1,055
Investors Community Bank #46147UTT7 08/28/18 02/28/20 2.550%2.550%245,000 245,578 22
Lakeside Bank #51210SPS0 08/30/18 03/30/20 2.550%2.550%245,000 245,782 535
Bank United #066519GJ2 08/31/18 02/20/20 2.500%2.500%245,000 245,554 1,531
Compass Bank #20451PVW3 10/26/18 10/26/20 3.000%3.000%245,000 248,141 694
UBS Bank #90348JFH8 10/30/18 10/29/20 3.050%3.050%245,000 248,273 643
Discover Bank #254673WF9 11/07/18 11/09/20 3.000%3.000%245,000 248,266 470
Ally Bank #02007GFX6 11/08/18 11/09/20 3.000%3.000%245,000 248,266 449
Comenity Cap Bank #20033AU46 04/15/19 04/15/21 2.500%2.500%245,000 247,930 237
Morgan Stanley #61760AE21 05/30/19 06/01/21 2.400%2.400%245,000 247,771 2,940
First St Bank DeQueen #336460CU2 07/18/19 07/19/21 2.000%2.000%245,000 246,379 186
Bank Hapoalim #06251AW89 07/19/19 07/19/21 2.000%2.000%245,000 246,771 1,837
Capital One Natl Assn #14042RMF5 07/24/19 07/26/19 2.050%2.050%245,000 246,583 1,883
TIAA FSB Jacksonville #87270LCN1 07/29/19 07/29/21 2.000%2.000%245,000 246,387 1,674
Wells Fargo #949763J31 09/18/19 09/20/21 1.850%1.850%245,000 245,779 187
BMW Bank #05580ASQ8 10/11/19 10/12/21 1.800%1.800%245,000 245,549 551
Metabank #59101LHW0 11/20/19 08/19/21 1.750%1.750%245,000 245,098 179
Total Certificates of Deposits $6,240,000 $6,276,498 $22,897
Total J.P.Morgan Securities $23,089,840 $23,176,685 $150,793
*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
November 30, 2019
Cash & Investments by Fund - Total $45.7 million
Cash & Investments by Type - Total $45.7 million
Checking
Illinois Funds
Certificates of Deposit
Municipal Bonds
Corporate Bonds
Government & Agency Obligations
Accrued Interest
General Corporate
47.06%
Hotel/Motel Tax
11.64%Motor Fuel Tax
2.22%
Infrastructure
18.60%
Promenade TIF
0.60%
Water
15.37%
Sports Core
0.61%
Golf Surcharge
0.75%
Self-Insurance
0.73%Garage
0.68%
Equipment
Replacement
1.74%
Checking, $0.6
Illinois Funds, $21.8
Certificates of Deposit,
$6.2
Municipal Bonds, $6.5
Corporate Bonds, $8.3
Government & Agency
Obligations, $2.1
Accrued Interest, $0.2
in millions
YTD YTD
Net Fund Budgeted
YTD YTD Increase Increase
Governmental Funds Revenues Expenditures (Decrease)(Decrease)
General Fund (Major Fund)25,508,929 $22,151,544 $3,357,385 ($338,190)
Main operating fund of the Village.
Hotel Fund (Major Fund)$1,310,010 $610,497 $699,513 ($3,277,755)
Collects and spends resources from the
3% hotel/motel tax.
Motor Fuel Tax Fund $229,882 $0 $229,882 ($713,220)
Collects and spends resources from the
State motor fuel tax.
Infrastructure Fund (Major Fund)$5,933,845 $6,623,482 ($689,637)($5,892,240)
Accounts for construction and maintenance of
roadways, drainage, and safety path systems.
Promenade TIF Fund (Major Fund)$479,210 $464,728 $14,482 ($37,615)
Accounts for the revenues and expenditures
restricted to the Tax Increment Financing (TIF)
district located at 22nd St. and Meyers Rd.
Enterprise Funds
Water Fund (Major Fund)$9,953,937 $8,857,128 $1,096,809 ($2,577,030)
Collects user fees for the distribution of water
and maintenance of infrastructure.
Sports Core Fund (Major Fund)$4,323,350 $4,189,547 $133,803 $84,070
Accounts for revenues and expenses relating
to administration, programs, food and beverage
operations, and golf course.
Golf Surcharge Fund $112,262 $212,969 ($100,707)($50,435)
Accounts for the collection of the $3 per round
golf surcharge.
Internal Service Funds
Self Insurance Fund $3,112,890 $3,029,015 $83,875 $1,315
Accounts for the Village's health insurance costs
and the related contributions from the Village,
employees, retirees, and other agencies.
Garage Fund $617,916 $651,466 ($33,550)($80,795)
Accounts for the maintenance of the Village's vehicle
fleet and the related departmental reimbursements.
Equipment Replacement Fund $230,931 $1,072,757 ($841,826)($1,029,420)
Accounts for the replacement of the Village's vehicle
fleet and the related departmental contributions.
Further information on the Village's major funds (as indicated above) can be found on the proceeding pages.
Executive Summary on Village Funds
Through November 30, 2019
Village of Oak Brook
Monthly Financial Report – Fund Narrative
For the Period Ending November 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
November 2019 are $11,537,428,
which is $202,493 higher than
through November 2018 and
$192,678 over FY19 budget to date.
The increase is primarily due to the
opening of newer businesses in town
and general inflationary growth.
November 2019 collections have
been relatively consistent with with
the last 5 years.
x Other Intergovernmental Tax collections through November 2019 are $1,378,072, which is
$170,324 higher than through November 2018 and $218,322 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 November 2019 are $5,770,547, which is
$162,676 higher than through November 2018 and $390,137 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Ƶƚ haƐ ŶŽƚ ƐeeŶ a Ŷegaƚiǀe
impact to date.
x Licenses and Permits revenue through November 2019 is $3,533,554, which is $415,491 higher
than through November 2018 and $1,389,079 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 November 2019 is $1,191,019, which is $91,632 higher
than through November 2018, but $135,431 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 November 2019 are $16,324,622, which is $558,229 more than
through November 2018, but $447,553 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 upcoming labor union retro payments.
x Operation and Contract expenditures through November 2019 are $3,623,722, which is
$220,991 more than through November 2018, but $368,298 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 November 2019 are $952,298, which is $1,946,789 less
than through November 2018 and $68,202 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 November 2019 are $1,206,553, which is $5,201 lower than
through November 2018, but $47,553 over FY19 budget to date. The variances are primarily
due to the timing of receipts.
x Capital Outlay expenditures have not occurred to date due to the cancellation of the Jorie,
Kensington, and Forest Gate streetscape beautification project. Minor projects will occur as
budgeted.
Infrastructure Fund
x Non-Home Rule Sales Tax collections
through November 2019 are
$5,207,688, which is $91,600 higher
than through November 2018 and
$95,688 over FY19 budget to date.
The increase is primarily due to the
opening of newer businesses in town
and general inflationary growth.
November 2019 collections have
been relatively consistent with with
the last 5 years.
x Operation and Contractual expenditures through November 2019 are $1,420,732, which is
$297,383 higher than through November 2018, but $123,983 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 November 2019 are $3,761,386, which is $2,748,810
higher than through November 2018, but $5,653,334 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 November 2019 is $9,229,807, which is $48,225 higher than
through November 2018, but $646,838 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 November 2019 are $4,342,992, which is
$331,362 lower than through November 2018 and $999,273 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 November 2019 are $3,236,350, which is $1,266,317
higher than through November 2018, but $3,006,055 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 November 2019 is $419,681, which is $14,993 lower than
through November 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 November 2019 is $912,148, which is $35,141 higher than
through November 2018, but $17,852 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 November 2019 are $923,607, which is
$131,916 lower than through November 2018 and $176,023 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 November 2019 are $1,151,429, which is $880,226 higher
than through November 2018, but $504,471 under 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.
Equipment Replacement Fund
x Other Expenditures through November 2019 are $1,008,789, 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.
11/30/19 11/30/19
11/30/18 11/30/19 YTD % of 2019 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 11,334,935$ 11,537,428$ 11,344,750$ 101.7%12,325,000$ 202,493$
Other Intergovernmental Tax*1,207,748 1,378,072 1,159,750 118.8%1,227,750 170,324
Telecommunications/Utility Tax 5,607,871 5,770,547 5,380,410 107.3%5,857,500 162,676
Licenses and Permits 3,118,063 3,533,554 2,144,475 164.8%2,335,050 415,491
Charges for Services 1,099,387 1,191,019 1,326,450 89.8%1,491,400 91,632
Fines and Penalties 166,860 195,101 144,870 134.7%158,000 28,241
Administrative Towing Fees 28,475 20,530 27,500 74.7%30,000 (7,945)
Interest on Investments 322,243 425,616 302,500 140.7%330,000 103,373
Franchise/IMF Maint. Fee 163,465 159,169 213,000 74.7%213,000 (4,296)
Miscellaneous Income 377,708 210,134 189,900 110.7%212,800 (167,574)
Total Operating Revenues 23,426,755$ 24,421,170$ 22,233,605$ 109.8%24,180,500$ 994,415$
OPERATING EXPENDITURES
Personnel 15,766,393$ 16,324,622$ 16,772,175$ 97.3%18,183,745$ 558,229$
Materials and Supplies 436,036 416,672 527,970 78.9%559,780 (19,364)
Operation and Contract 3,402,731 3,623,722 3,992,020 90.8%4,224,475 220,991
Other Expenditures 5,866 9,537 10,000 95.4%10,000 3,671
Capital Outlay 2,899,087 952,298 1,020,500 93.3%862,475 (1,946,789)
Total Operating Expenditures 22,510,113$ 21,326,851$ 22,322,665$ 95.5%23,840,475$ (1,183,262)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 916,642$ 3,094,319$ (89,060)$ 340,025$ 2,177,677$
OTHER TRANSACTIONS
Transfers In -$ 508,235$ 508,235$ 100.0%508,235$ 508,235$
Transfers Out - (704,518) (1,216,725) 57.9%(1,216,725) (704,518)
Reimbursements From Other Funds 576,631 579,524 579,535 100.0%632,210 2,893
Reimbursements To Other Funds (120,373) (120,175) (120,175) 100.0%(131,100) 198
Total Interfund Transactions 456,258$ 263,066$ (249,130)$ -105.6%(207,380)$ (193,192)$
NET FUND INCREASE (DECREASE)1,372,900$ 3,357,385$ (338,190)$ 132,645$ 1,984,485$
*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 November 30, 2019
Total Total
Revenues Expenditures
11/30/19 Actual 24,421,170$ 21,326,851$
11/30/18 Actual 23,426,755$ 22,510,113$
% Change From Last Year 4.2%-5.3%
Major Revenues Other
Intergov.Licenses &Charges for
Sales Tax Tax Telecom Tax Permits Services
11/30/19 Actual 11,537,428$ 1,378,072$ 5,770,547$ 3,533,554$ 1,191,019$
11/30/18 Actual $ 11,334,935 $ 1,207,748 $ 5,607,871 $ 3,118,063 $ 1,099,387
% Change From Last Year 1.8%14.1%2.9%13.3%8.3%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
11/30/19 Actual 16,324,622$ 416,672$ 3,623,722$ 9,537$ 952,298$
11/30/18 Actual 15,766,393$ 436,036$ 3,402,731$ 5,866$ 2,899,087$
% Change From Last Year 3.5%-4.4%6.5%62.6%-67.2%
Five Year Trend
Expenditures by Department
11/30/18 11/30/19 11/30/19 11/30/19 2019 Difference Five
YTD YTD YTD % of Annual Prior Year
Department Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 2,098,138$ 2,095,097$ 2,522,430$ 83.1%2,700,820$ (3,041)$
Financial Services 649,166 671,497 645,885 104.0%782,860 22,331
Public Works 632,169 783,297 842,605 93.0%886,420 151,128
Engineering & Capital Projects 2,713,198 501,989 421,575 119.1%459,900 (2,211,209)
Library 811,361 837,200 861,810 97.1%928,675 25,839
Police 7,778,552 8,193,532 8,436,405 97.1%8,891,960 414,980
Fire 6,974,087 7,346,535 7,603,125 96.6%8,207,785 372,448
Development Services 853,442 897,704 910,865 98.6%982,055 44,262
Total Expenditures 22,510,113$ 21,326,851$ 22,244,700$ 95.9%23,840,475$ (1,183,262)$
Five Year Trend
For the Period Ending November 30, 2019
General Fund - Five Year Trend
Village of Oak Brook
Revenues Expenditures
11/30/19 11/30/19
11/30/18 11/30/19 YTD % of 2019 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Hotel Tax 1,211,754$ 1,206,553$ 1,159,000$ 104.1%1,268,000$ (5,201)$
Interest 74,427 103,457 27,500 376.2%30,000 29,030
Miscellaneous 5,200 - - 0.0%- (5,200)
Total Operating Revenues 1,291,381$ 1,310,010$ 1,186,500$ 110.4%1,298,000$ 18,629$
EXPENDITURES
Operation and Contract 459,489$ 515,974$ 529,695$ 97.4%577,860$ 56,485$
Capital Outlay 6,323 - 3,840,070 0.0%4,180,545 (6,323)
Total Expenditures 465,812$ 515,974$ 4,369,765$ 11.8%4,758,405$ 50,162$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 825,569$ 794,036$ (3,183,265)$ -24.9%(3,460,405)$ (31,533)$
INTERFUND TRANSACTIONS
Reimbursements to Other Funds (91,245) (94,523)$ (94,490)$ 100.0%(103,115)$ (3,278)$
Total Interfund Transactions (91,245)$ (94,523)$ (94,490)$ 100.0%(103,115)$ (3,278)$
NET FUND INCREASE (DECREASE)734,324$ 699,513$ (3,277,755)$ (3,563,520)$ (34,811)$
Note - Expenditures are recorded in program 171.
Village of Oak Brook
Hotel Tax Fund Financial Update
For the Period Ending November 30, 2019
Total Total
Revenues Expenditures
11/30/19 Actual $ 1,310,010 515,974$
11/30/18 Actual $ 1,291,381 465,812$
% Change From Last Year 1.4%10.8%
Major Revenues
Hotel Tax Interest Miscellaneous
11/30/19 Actual $ 1,206,553 $ 103,457 $ -
11/30/18 Actual $ 1,211,754 $ 74,427 $ 5,200
% Change From Last Year -0.4%39.0%-100.0%
Five Year Trend
Major Expenditures Operation &
Contractual Capital Outlay
11/30/19 Actual 515,974$ -$
11/30/18 Actual 459,489$ 6,323$
% Change From Last Year 12.3%-100.0%
Five Year Trend
Village of Oak Brook
Hotel Tax Fund - Major Sources Five Year Trend
For the Period Ending November 30, 2019
Five Year Trend
Revenues Expenditures
11/30/19 11/30/19
11/30/18 11/30/19 YTD % of 2019 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 5,116,088$ 5,207,688$ 5,112,000$ 101.9%5,548,000$ 91,600$
Charges for Services - 1,365 - N/A - 1,365
Interest 161,004 203,010 75,000 270.7%80,000 42,006
Miscellaneous 2,729 - 4,575 0.0%5,000 (2,729)
Total Operating Revenues 5,279,821$ 5,412,063$ 5,191,575$ 104.2%5,633,000$ 132,242$
OPERATING EXPENDITURES
Personnel 1,099,219$ 1,161,232$ 1,202,870$ 96.5%1,322,375$ 62,013$
Materials and Supplies 115,395 132,061 195,250 67.6%246,845 16,666
Operation and Contract 1,123,349 1,420,732 1,544,715 92.0%1,663,435 297,383
Capital Outlay 1,012,576 3,761,386 9,414,720 40.0%10,008,575 2,748,810
Total Operating Expenditures 3,350,539$ 6,475,411$ 12,357,555$ 52.4%13,241,230$ 3,124,872$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 1,929,282$ (1,063,348)$ (7,165,980)$ 14.8%(7,608,230)$ (2,992,630)$
INTERFUND TRANSACTIONS
Transfers In 7,790$ 216,125$ 1,116,125$ 19.4%1,116,125$ 208,335$
Reimbursements From Other Funds 166,034 305,657 305,690 100.0%333,445 139,623
Reimbursements To Other Funds (151,129) (148,071) (148,075) 100.0%(161,535) 3,058
Total Interfund Transactions 22,695$ 373,711$ 1,273,740$ 29.3%1,288,035$ 351,016$
NET FUND INCREASE (DECREASE)1,951,977$ (689,637)$ (5,892,240)$ (6,320,195)$ (2,641,614)$
Village of Oak Brook
Infrastructure Fund Financial Update
For the Period Ending November 30, 2019
Total Total
Revenues Expenditures
11/30/19 Actual $ 5,412,063 6,475,411$
11/30/18 Actual $ 5,279,821 3,350,539$
% Change From Last Year 2.5%93.3%
Major Revenues
Sales Tax Grants Interest Miscellaneous
11/30/19 Actual $ 5,207,688 $ 1,365 $ 203,010 $ -
11/30/18 Actual $ 5,116,088 $ - $ 161,004 $ 2,729
% Change From Last Year 1.8%0.0%26.1%-100.0%
Five Year Trend
Major Expenditures Materials &Operation &
Personnel Supplies Contractual Capital Outlay
11/30/19 Actual 1,161,232$ 132,061$ 1,420,732$ 3,761,386$
11/30/18 Actual 1,099,219$ 115,395$ 1,123,349$ 1,012,576$
% Change From Last Year 5.6%14.4%26.5%271.5%
Five Year Trend
Expenditures by Department
11/30/18 11/30/19 11/30/19 11/30/19 2019 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 144,231$ 146,091$ 163,485$ 89.4%179,485$ 1,860$
Public Works 1,787,971 3,338,099 6,093,905 54.8%6,462,865 1,550,128
Engineering & Capital Projects 1,418,337 2,991,221 6,100,165 49.0%6,760,415 1,572,884
Total Expenditures 3,350,539$ 6,475,411$ 12,357,555$ 52.4%13,402,765$ 3,124,872$
Five Year Trend
Village of Oak Brook
Infrastructure Fund - Major Sources Five Year Trend
For the Period Ending November 30, 2019
Revenues Expenditures
11/30/19 11/30/19
11/30/18 11/30/19 YTD % of 2019 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 67,242$ 65,184$ 66,750$ 97.7%100,000$ (2,058)$
Real Estate Tax 373,267 412,066 360,000 114.5%360,000 38,799
Interest 1,531 1,960 825 237.6%900 429
Total Operating Revenues 442,040$ 479,210$ 427,575$ 112.1%460,900$ 37,170$
EXPENDITURES
Operation and Contract 3,578$ 3,748$ 4,210$ 89.0%4,210$ 170$
Other Expenditures 489,820 460,980 460,980 100.0%460,980 (28,840)
Total Expenditures 493,398$ 464,728$ 465,190$ 99.9%465,190$ (28,670)$
NET FUND INCREASE (DECREASE)(51,358)$ 14,482$ (37,615)$ (4,290)$ 65,840$
Note - Expenditures are recorded in program 283.
Village of Oak Brook
Promenade TIF Fund Financial Update
For the Period Ending November 30, 2019
Total Total
Revenues Expenditures
11/30/19 Actual $ 479,210 464,728$
11/30/18 Actual $ 442,040 493,398$
% Change From Last Year 8.4%-5.8%
Major Revenues Real Estate
Sales Tax Tax Interest
11/30/19 Actual $ 65,184 $ 412,066 $ 1,960
11/30/18 Actual $ 67,242 $ 373,267 $ 1,531
% Change From Last Year -3.1%10.4%28.0%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures
11/30/19 Actual 3,748$ 460,980$
11/30/18 Actual 3,578$ 489,820$
% Change From Last Year 4.8%-5.9%
Five Year Trend
Village of Oak Brook
Promenade TIF Fund - Major Sources Five Year Trend
For the Period Ending November 30, 2019
Five Year Trend
Revenues Expenditures
11/30/19 11/30/19
11/30/18 11/30/19 YTD % of 2019 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Plan Review Fees 825$ 1,350$ 1,375$ 98.2%1,500$ 525$
Building/Inspection Fees 7,838 6,488 4,580 141.7%5,000 (1,350)
Water Sales 9,181,582 9,229,807 9,876,645 93.5%10,223,250 48,225
Unmetered Sales 36,462 42,792 27,500 155.6%30,000 6,330
Water Connection Fees 112,054 173,410 45,800 378.6%50,000 61,356
Fire Service Charge - - 4,580 0.0%5,000 -
Meter Charges 10,235 25,767 18,335 140.5%20,000 15,532
Special Services 32,218 32,975 30,000 109.9%30,000 757
Interest on Investments 92,947 160,776 50,380 319.1%55,000 67,829
Miscellaneous 73,593 59,487 68,750 86.5%75,000 (14,106)
Total Operating Revenues 9,547,754$ 9,732,852$ 10,127,945$ 96.1%10,494,750$ 185,098$
EXPENDITURES
Personnel 675,017$ 717,032$ 764,770$ 93.8%828,710$ 42,015$
Materials and Supplies 61,428 54,908 70,775 77.6%76,210 (6,520)
Operation and Contract 4,674,354 4,342,992 5,342,265 81.3%5,822,285 (331,362)
Capital Outlay 1,970,033 3,236,350 6,242,405 51.8%6,244,075 1,266,317
Total Expenditures 7,380,832$ 8,351,282$ 12,420,215$ 67.2%12,971,280$ 970,450$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 2,166,922$ 1,381,570$ (2,292,270)$ (2,476,530)$ (785,352)$
INTERFUND TRANSACTIONS
Transfers In -$ 221,085$ 221,085$ 100.0%221,085$ 221,085
Reimbursements To Other Funds (371,404) (505,846) (505,845) 100.0%(551,830) (134,442)
Total Interfund Transactions (371,404)$ (284,761)$ (284,760)$ 100.0%(330,745)$ 86,643$
NET FUND INCREASE (DECREASE)1,795,518$ 1,096,809$ (2,577,030)$ (2,807,275)$ (698,709)$
Village of Oak Brook
Water Fund Financial Update
For the Period Ending November 30, 2019
Total Total
Revenues Expenditures
11/30/19 Actual $ 9,732,852 8,351,282$
11/30/18 Actual $ 9,547,754 7,380,832$
% Change From Last Year 1.9%13.1%
Unmetered Water
Water Sales Sales Connection Fees Meter Charges Miscellaneous
11/30/19 Actual $ 9,229,807 $ 42,792 $ 173,410 $ 25,767 $ 59,487
11/30/18 Actual $ 9,181,582 $ 36,462 $ 112,054 $ 10,235 $ 73,593
% Change From Last Year 0.5%17.4%54.8%151.8%-19.2%
Five Year Trend
Materials &Operation &
Personnel Supplies Contractual Capital Outlay
11/30/19 Actual 717,032$ 54,908$ 4,342,992$ 3,236,350$
11/30/18 Actual 675,017$ 61,428$ 4,674,354$ 1,970,033$
% Change From Last Year 6.2%-10.6%-7.1%64.3%
Five Year Trend
Expenditures by Department
11/30/18 11/30/19 11/30/19 11/30/19 2019 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Public Works 5,367,488$ 5,107,250$ 6,196,140$ 82.4%7,299,035$ (260,238)$
Engineering & Capital Projects 2,013,344 3,244,032 6,224,075 52.1%6,224,075 1,230,688
Total Expenditures 7,380,832$ 8,351,282$ 12,420,215$ 67.2%13,523,110$ 970,450$
Five Year Trend
Village of Oak Brook
Water Fund - Major Sources Five Year Trend
For the Period Ending November 30, 2019
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Sports Core Fund Consolidated Presentation
For the Period Ending November 30, 2019
11/30/19 11/30/19
11/30/19 YTD % of 2019 11/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$ 434,674$ (14,993)$
Greens Fees - - 912,148 912,148 930,000 98.1%930,000 877,007 35,141
Pro Shop Sales - - 199,410 199,410 200,000 99.7%200,000 184,012 15,398
Golf Lessons - - 33,726 33,726 40,000 84.3%40,000 36,705 (2,979)
Driving Range Fees - - 235,405 235,405 226,000 104.2%226,000 216,724 18,681
Rentals - - 339,551 339,551 456,975 74.3%459,000 401,969 (62,418)
Programs/User Fees 311,763 - - 311,763 251,900 123.8%253,450 250,897 60,866
Food Sales - 182,186 - 182,186 175,500 103.8%175,500 157,331 24,855
Beverage Sales - 268,107 - 268,107 251,315 106.7%252,500 229,166 38,941
Other Revenue 126,094 338,264 10,191 474,549 423,280 112.1%428,300 446,671 27,878
Total Direct Revenues 659,863$ 788,557$ 1,928,106$ 3,376,526$ 3,408,785$ 99.1%3,418,565$ 3,235,156$ 141,370$
DIRECT EXPENDITURES
Personnel 118,993$ 273,732$ 1,081,929$ 1,474,654$ 1,501,430$ 98.2%1,572,920$ 1,462,974$ 11,680$
Materials & Supplies 40,701 219,819 379,337 639,857 571,945 111.9%580,645 563,569 76,288
Operational & Contractual 541,904 97,889 283,814 923,607 1,099,630 84.0%1,115,975 1,055,523 (131,916)
Other - - - - (83,150) 0.0%(83,150) (128,577) 128,577
Capital 464,577 357,552 329,300 1,151,429 1,655,900 69.5%1,655,900 271,203 880,226
Total Direct Expenditures 1,166,175$ 948,992$ 2,074,380$ 4,189,547$ 4,745,755$ 88.3%4,842,290$ 3,224,692$ 964,855$
Direct Revenues Over (Under) Expenditures (506,312)$ (160,435)$ (146,274)$ (813,021)$ (1,336,970)$ 60.8%(1,423,725)$ 10,464$ (823,485)$
B&T Administration Overhead Allocation*111,161$ (111,161)$ -$ -$ -$ 0.0%-$ -$ -$
Operating Revenues Over (Under) Expenditures (395,151)$ (271,596)$ (146,274)$ (813,021)$ (1,336,970)$ 60.8%(1,423,725)$ 10,464$ (823,485)$
Transfer From General Fund 419,019$ 285,499$ -$ 704,518$ 1,216,725$ 57.9%1,216,725$ -$ 704,518$
Transfer From Golf Surcharge Fund - - 212,969 212,969 175,000 121.7%175,000 11,039 201,930
Reimbursement From Infrastructure Fund 22,000 - - 22,000 22,000 100.0%24,000 22,000 -
Reimbursement From Water Fund 7,337 - - 7,337 7,315 100.3%8,000 7,337 -
Adjusted Operating Revenues Over (Under) Expenditures 53,205$ 13,903$ 66,695$ 133,803$ 84,070$ -$ 50,840$ 82,963$
*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
11/30/19 Actual $ 3,376,526 4,189,547$
11/30/18 Actual $ 3,235,156 3,224,692$
% Change From Last Year 4.4%29.9%
Driving Program/
Memberships Greens Fees Range Fees Rentals User Fees
11/30/19 Actual $ 419,681 $ 912,148 $ 235,405 $ 339,551 $ 311,763
11/30/18 Actual $ 434,674 $ 877,007 $ 216,724 $ 401,969 $ 250,897
% Change From Last Year -3.4%4.0%8.6%-15.5%24.3%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
11/30/19 Actual 1,474,654$ 639,857$ 923,607$ -$ 1,151,429$
11/30/18 Actual 1,462,974$ 563,569$ 1,055,523$ (128,577)$ 271,203$
% Change From Last Year 0.8%13.5%-12.5%-100.0%324.6%
Five Year Trend
Revenues by Department 11/30/18 11/30/19 11/30/19 11/30/19 2019 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Programs 668,586$ 659,863$ 646,495$ 102.1%686,515$ (8,723)$
Food & Beverage 638,176 788,557 127,800 617.0%663,000 150,381
Golf Club 1,928,394 1,928,106 567,997 339.5%2,069,050 (288)
Total Revenues 3,235,156$ 3,376,526$ 1,342,292$ 251.5%3,418,565$ 141,370$
Expenditures by Department 11/30/18 11/30/19 11/30/19 % of 2019 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Programs 960,191$ 1,166,175$ 344,363$ 338.6%1,883,075$ 205,984$
Food & Beverage 560,014 948,992 281,968 336.6%1,037,845 388,978
Golf Club 1,704,487 2,074,380 778,751 266.4%1,921,370 369,893
Total Expenditures 3,224,692$ 4,189,547$ 1,405,082$ 298.2%4,842,290$ 964,855$
Five Year Trend
Village of Oak Brook
Sports Core Fund - Major Sources Five Year Trend
For the Period Ending November 30, 2019
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Club Recreation Programs
For the Period Ending November 30, 2019 11/30/19 11/30/19
11/30/19 YTD % of 2019 11/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 49,083 - 242,948 311,763 251,900 123.8%253,450 250,897 60,866
Other Revenue (1,007) 6,473 5,888 - 114,740 126,094 188,230 67.0%188,250 188,315 (62,221)
Total Revenue (1,007)$ 233,461$ 69,721$ -$ 357,688$ 659,863$ 684,945$ 96.3%686,515$ 668,586$ (8,723)$
Expenditures:
Personnel 90,518$ 19,585$ -$ -$ 8,890$ 118,993$ 179,980$ 66.1%182,405$ 150,297$ (31,304)$
Materials & Supplies 24,896 13,719 711 - 1,375 40,701 26,250 155.1%26,350 19,334 21,367
Operational & Contractual 64,238 276,917 71,781 - 128,968 541,904 671,725 80.7%673,820 698,972 (157,068)
Capital 25,195 424,762 - - 14,620 464,577 1,000,500 46.4%1,000,500 91,588 372,989
Total Expenditures 204,847$ 734,983$ 72,492$ -$ 153,853$ 1,166,175$ 1,878,455$ 62.1%1,883,075$ 960,191$ 205,984$
Direct Revenues Over (Under) Expenditures (205,854)$ (501,522)$ (2,771)$ -$ 203,835$ (506,312)$ (1,193,510)$ 42.4%(1,196,560)$ (291,605)$ (214,707)$
B&T Administration Overhead Allocation*205,854$ (74,108)$ (20,585)$ -$ -$ 111,161$ 90,705$ 122.6%91,410$ 117,450$ (6,289)$
Revenues Over (Under) Expenditures -$ (575,630)$ (23,356)$ -$ 203,835$ (395,151)$ (1,102,805)$ 35.8%(1,105,150)$ (174,155)$ (220,996)$
Transfer From General Fund 12,476$ 406,543$ -$ -$ -$ 419,019$ 965,500$ 43.4%965,500$ -$ 419,019$
Reimbursement From Infrastructure Fund 22,000 - - - - 22,000 22,000 100.0%24,000 22,000 -$
Reimbursement From Water Fund 7,337 - - - - 7,337 7,315 100.3%8,000 7,337 -
Adjusted Revenues Over (Under) Expenditures 41,813$ (169,087)$ (23,356)$ -$ 203,835$ 53,205$ (107,990)$ (107,650)$ (144,818)$ 198,023$
*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 November 30, 2019
11/30/19 11/30/19
821 822 823 11/30/19 YTD % of 2019 11/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$ 146,811$ 182,186$ 175,500$ 103.8%175,500$ 157,331$ 24,855$
Beverage Sales - 19,534 248,573 268,107 251,315 106.7%252,500 229,166 38,941
Other Revenue 338,264 - - 338,264 230,000 147.1%235,000 251,679 86,585
Total Revenue 338,264$ 54,909$ 395,384$ 788,557$ 656,815$ 120.1%663,000$ 638,176$ 150,381$
Expenditures:
Personnel 120,822$ 29,839$ 123,071$ 273,732$ 273,850$ 100.0%286,125$ 242,643$ 31,089$
Materials & Supplies 19,892 30,849 169,078 219,819 205,785 106.8%208,200 180,372 39,447
Operational & Contractual 88,866 25 8,998 97,889 146,360 66.9%153,120 125,011 (27,122)
Capital 357,552 - - 357,552 390,400 91.6%390,400 11,988 345,564
Total Expenditures 587,132$ 60,713$ 301,147$ 948,992$ 1,016,395$ 93.4%1,037,845$ 560,014$ 388,978$
Direct Revenues Over (Under) Expenditures (248,868)$ (5,804)$ 94,237$ (160,435)$ (359,580)$ 44.6%(374,845)$ 78,162$ (238,597)$
B&T Administration Overhead Allocation*(102,927)$ (8,234)$ (111,161)$ (90,705)$ 122.6%(91,410)$ (117,450)$ 6,289$
Revenues Over (Under) Expenditures (351,795)$ (14,038)$ 94,237$ (271,596)$ (450,285)$ 60.3%(466,255)$ (39,288)$ (232,308)$
Transfer From General Fund 285,499$ -$ -$ 285,499$ 251,225$ 113.6%251,225$ -$ 285,499$
Adjusted Revenues Over (Under) Expenditures (66,296)$ (14,038)$ 94,237$ 13,903$ (199,060)$ (215,030)$ (39,288)$ 53,191$
*Overhead allocation is comprised of salaries, business forms, liability insurance, building & grounds maintenance and bank service fees in Program 811 -
Sports Core General Operations distributed to various Sports Core Programs on a percentage basis.
Village of Oak Brook
Monthly Operating Statement
Golf Club Programs
For the Period Ending November 30, 2019
11/30/19 11/30/19
831 832 833 834 11/30/19 YTD % of 2019 11/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$ 205,300$ (7,625)$
Greens Fees 912,148 - - - 912,148 930,000 98.1%930,000 877,007 35,141
Pro Shop Sales 199,410 - - - 199,410 200,000 99.7%200,000 184,012 15,398
Golf Lessons - 33,726 - - 33,726 40,000 84.3%40,000 36,705 (2,979)
Driving Range Fees - 235,405 - - 235,405 226,000 104.2%226,000 216,724 18,681
Rentals 4,556 9,000 325,995 - 339,551 456,975 74.3%459,000 401,969 (62,418)
Other Revenue 10,191 - - - 10,191 5,050 201.8%5,050 6,677 3,514
Total Revenue 1,323,980$ 278,131$ 325,995$ -$ 1,928,106$ 2,067,025$ 93.3%2,069,050$ 1,928,394$ (288)$
Expenditures:
Personnel 453,653$ 59,752$ 55,341$ 513,183$ 1,081,929$ 1,047,600$ 103.3%1,104,390$ 1,070,034$ 11,895$
Materials & Supplies 170,169 19,688 1,348 188,132 379,337 339,910 111.6%346,095 363,863 15,474
Operational & Contractual 199,585 631 53,107 30,491 283,814 281,545 100.8%289,035 231,540 52,274
Other - - - - - (83,150) 0.0%(83,150) (128,577) 128,577
Capital 241,070 - - 88,230 329,300 265,000 124.3%265,000 167,627 161,673
Total Expenditures 1,064,477$ 80,071$ 109,796$ 820,036$ 2,074,380$ 1,850,905$ 112.1%1,921,370$ 1,704,487$ 369,893$
Direct Revenues Over (Under) Expenditures 259,503$ 198,060$ 216,199$ (820,036)$ (146,274)$ 216,120$ -67.7%147,680$ 223,907$ (370,181)$
Transfer from Golf Surcharge 212,969$ -$ 212,969$ 175,000$ 121.7%175,000$ 11,039$ 201,930$
Adjusted Revenues Over (Under) Expenditures 472,472$ 198,060$ 216,199$ (820,036)$ 66,695$ 391,120$ 322,680$ 234,946$ (168,251)$