05 - May 2019 Monthly Financial ReportVILLAGE
OAK BROOK
OF
MONTHLY FINANCIAL REPORTS
MAY 2019
ITEM 6.E
Total
Cash and Cash Pooled Cash and
Fund Equivalents Investments Investments % By Fund
General Corporate $5,885,172 $14,171,705 $20,056,877 43.9%
Hotel/Motel Tax 2,901,426 1,900,600 4,802,026 10.5%
Motor Fuel Tax 725,499 147,103 872,602 1.9%
Infrastructure 7,387,604 2,422,228 9,809,832 21.5%
Promenade TIF 26,861 - 26,861 0.1%
Water 5,058,486 3,044,439 8,102,925 17.8%
Sports Core - - - 0.0%
Golf Surcharge - 251,358 251,358 0.6%
Self-Insurance 654,539 - 654,539 1.4%
Garage 360,329 - 360,329 0.8%
Equipment Replacement 252,723 453,210 705,933 1.5%
Total $23,252,639 $22,390,643 $45,643,282 100.0%
Change in Cash and Investments by Fund :
Balance at Balance at Year-to-Date Year-to-Date
Fund January 1, 2019 May 31, 2019 Change ($)Change (%)
General Corporate $18,092,186 $20,056,877 $1,964,691 10.9%
Hotel/Motel Tax 4,843,367 4,802,026 (41,341)-0.9%
Motor Fuel Tax 782,203 872,602 90,399 11.6%
Infrastructure 9,322,381 9,809,832 487,451 5.2%
Promenade TIF 257,485 26,861 (230,624)-89.6%
Water 6,449,315 8,102,925 1,653,610 25.6%
Sports Core 190,397 - (190,397)-100.0%
Golf Surcharge 442,152 251,358 (190,794)-43.2%
Self-Insurance 468,568 654,539 185,971 39.7%
Garage 331,134 360,329 29,195 8.8%
Equipment Replacement 1,636,238 705,933 (930,305)-56.9%
$42,815,426 $45,643,282 $2,827,856 6.6%
Book Bank/Market
Value Value
Pooled Checking $1,005,682 $2,139,982
Sports Core Checking 99,560 62,527
Pooled IPTIP 21,908,459 21,908,459
Water E-Pay IPTIP 238,938 238,938
$23,252,639 $24,349,906
Pooled Investments:
Investments-Municipal Bonds $6,310,468 $6,287,118
Investments-Corporate Bonds 8,532,514 8,562,889
Government & Agency Obligations 686,371 668,266
Certificates of Deposit 6,730,000 6,719,166
Accrued Interest 131,290 131,290
Total Pooled Investments $22,390,643 $22,368,729
Total Cash and Investments $45,643,282 $46,718,635
For May, total interest revenue is $91,678 and YTD revenue is $437,084.
Total investment yield for the portfolio is:
Pooled
Investments Illinois Funds Total
Monthly yield 0.20%0.23%0.21%
YTD yield 0.98%1.06%1.02%
Last 12 months yield 2.16%2.28%2.22%
The weighted average yield of the current pooled investment portfolio is 2.43%.
Monthly Treasurer's Report
May 31, 2019
Monthly Treasurer's Report
May 2019
The table below lists the detail investment holdings at J.P. Morgan Securities as of 5/31/19:
Month End VOB
Settlement Maturity Coupon Yield Book Market Accrued
Type Date Date Rate Rate Value Value Interest
Municipal Bonds:
Maryland St Econ Dev #57420PGK6 07/08/15 06/01/19 2.050%2.123%$99,998 $100,000 $1,022
Rosemont IL GO Corp #777543UT4 02/08/16 12/01/19 3.021%2.000%502,477 499,320 7,457
New York N Y City #64971QTX1 02/22/16 05/01/21 2.350%2.000%201,299 200,722 377
Florida Hurricane #34074GDH4 03/30/16 07/01/20 2.995%2.150%504,428 503,555 6,239
Bloomingdale Mich Pub Sch Dist #094383FS0 04/26/16 05/01/22 2.710%2.150%507,845 504,505 1,090
Milan Mich Area Achs #598801JD1 05/26/16 05/01/20 1.931%1.931%245,000 243,969 293
Indiana Bd Bk Rev Taxable #4546248F7 01/06/17 01/15/20 2.934%1.900%256,592 255,671 2,840
Garland Cnty Ark Sales & Use #36609PAN3 02/06/17 11/01/19 1.795%1.840%499,905 498,350 873
Lanse Creuse Mich Pub Schs #516228RL9 05/02/17 05/01/20 2.159%2.159%100,000 99,765 178
California St GO Bonds #13063A7G3 05/08/17 10/01/19 6.200%1.600%507,656 506,160 4,885
*Genesee Cnty Mich #371608UV0 05/31/17 10/01/19 2.681%2.681%43,000 43,000 0
Connecticut St GO Bds 2016 #20772J3F7 06/15/17 08/15/21 1.750%2.300%494,119 491,725 2,523
North Carolina Eastn Mun Pwr #65819WAL7 10/02/17 07/01/19 2.578%1.700%500,376 500,085 5,228
Fowlerville Mich Comnty Schs #351280MS8 10/03/17 05/01/20 2.045%1.750%501,344 498,940 682
Racine Cnty WI #749845UK7 12/20/17 12/01/20 2.150%2.150%750,000 746,475 8,063
Wisconsin St Gen Fd Annual #977100CW4 01/05/18 05/01/20 1.446%2.100%596,429 594,876 627
Total Municipal Bonds $6,310,468 $6,287,118 $42,377
Corporate Bonds:
Goldman Sachs #38141GVP9 09/26/18 09/15/20 2.750%3.180%497,307 500,865 2,865
Fifth Third #31677QBH1 10/11/18 09/27/19 1.625%2.750%996,455 996,990 2,889
JP Morgan #46640QUV1 11/01/18 07/29/19 0.000%3.017%1,492,698 1,493,903 0
Wells Fargo #94974BGR5 01/15/19 12/07/20 2.550%3.120%1,378,401 1,390,528 17,426
SunTrust #86787EAU1 01/28/19 01/29/21 2.590%3.050%498,545 499,905 4,317
PNC Bank #69353RFH6 01/30/19 01/22/21 2.500%3.020%495,867 499,815 4,479
Morgan Stanley #61747WAL3 03/08/19 07/28/21 5.500%3.034%1,103,687 1,110,848 19,571
Citigroup #172967LC3 04/01/19 12/08/21 2.900%2.754%1,003,530 1,003,360 13,372
Bank of America #06051GFT1 04/03/19 10/19/20 2.625%2.625%700,000 700,189 1,889
Goldman Sachs #38143U8F1 05/02/19 02/25/21 2.875%2.707%366,024 366,486 2,771
Total Corporate Bonds $8,532,514 $8,562,889 $69,579
Government & Agency Obligations:
**Government National Mtg Assn #38379UEM4 02/29/16 02/16/51 2.300%2.245%$686,371 $668,266 $2,196
Total Government & Agency Obligations:$686,371 $668,266 $2,196
Certificates of Deposit:
State Bk India NY #8562846A7 01/26/17 01/26/22 2.250%2.250%$245,000 $243,251 $1,914
Marlin Bank #57116ANU8 05/10/17 11/12/19 1.610%1.610%245,000 244,113 229
American Express Fed Svgs #02587CER7 05/10/17 11/12/19 1.700%1.700%245,000 244,209 243
Stone Bk Mtn View Ark #86158RAJ8 06/28/17 06/28/19 1.600%1.600%245,000 244,870 28
TIAA FSB Jacksonville #87270LAA1 07/19/17 07/19/19 1.600%1.600%245,000 244,757 1,421
Peoples United Bank #71270QQZ2 07/19/17 07/19/19 1.650%1.650%245,000 244,772 1,466
Priority Bank Ozark Ark #74269KBR6 07/26/17 07/26/19 1.600%1.600%245,000 244,721 56
American Express Centurion #02587DV96 08/15/17 08/17/20 1.900%1.900%245,000 243,263 1,339
Sallie Mae #795450C86 08/16/17 08/17/20 1.900%1.900%245,000 243,356 1,339
Merrick Bank South Jordan #59013JZS1 08/21/17 08/21/20 1.800%1.800%245,000 243,042 132
Pinnacle Bank #72345SFS5 08/30/17 08/31/20 1.800%1.800%115,000 114,060 10
Jackson County Bank #466682AP6 08/31/17 03/01/21 1.850%1.850%245,000 242,322 1,152
Barclays Bank #06740KKX4 09/27/17 09/28/20 1.950%1.950%245,000 243,344 856
Capital One Bank #1404205E6 10/04/17 10/04/19 1.700%1.700%245,000 244,400 654
Goldman Sachs Bank #38148PRK5 10/18/17 10/19/20 1.950%1.950%245,000 243,263 564
FirstBank PR Santurce #33767A6M8 11/03/17 11/03/20 2.000%2.000%245,000 243,381 374
Morgan Stanley #61747MQ53 03/22/18 03/23/20 2.550%2.550%245,000 245,218 1,080
Investors Community Bank #46147UTT7 08/28/18 02/28/20 2.550%2.550%245,000 245,213 48
Lakeside Bank #51210SPS0 08/30/18 03/30/20 2.550%2.550%245,000 245,225 30
Bank United #066519GJ2 08/31/18 02/20/20 2.500%2.500%245,000 245,120 1,555
Compass Bank #20451PVW3 10/26/18 10/26/20 3.000%3.000%245,000 246,781 704
UBS Bank #90348JFH8 10/30/18 10/29/20 3.050%3.050%245,000 246,967 40
Citibank #17294XJP2 10/31/18 10/31/20 3.000%3.000%245,000 245,554 663
Discover Bank #254673WF9 11/07/18 11/09/20 3.000%3.000%245,000 246,825 500
Ally Bank #02007GFX6 11/08/18 11/09/20 3.000%3.000%245,000 246,825 479
Comenity Cap Bank #20033AU46 04/15/19 04/15/21 2.500%2.500%245,000 245,027 262
Radius Bank #75047ABE3 05/30/19 05/28/21 2.450%2.450%245,000 244,765 -
Morgan Stanley #61760AE21 05/30/19 06/01/21 2.400%2.400%245,000 244,522 -
Total Certificates of Deposits $6,730,000 $6,719,166 $17,138
Total J.P.Morgan Securities $22,259,353 $22,237,439 $131,290
*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
May 31, 2019
Cash & Investments by Fund - Total $45.6 million
Cash & Investments by Type - Total $45.6 million
Checking
Illinois Funds
Certificates of Deposit
Municipal Bonds
Corporate Bonds
Government & Agency Obligations
Accrued Interest
General Corporate
43.94%
Hotel/Motel Tax
10.52%Motor Fuel Tax
1.91%
Infrastructure
21.49%
Promenade TIF
0.06%
Water
17.75%
Sports Core
0.00%
Golf Surcharge
0.55%
Self-Insurance
1.43%Garage
0.79%
Equipment
Replacement
1.55%
Checking, $1.1
Illinois Funds, $22.2
Certificates of Deposit,
$6.7
Municipal Bonds, $6.3
Corporate Bonds, $8.5
Government & Agency
Obligations, $0.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)11,924,111 $10,034,539 $1,889,572 $351,385
Main operating fund of the Village.
Hotel Fund (Major Fund)$437,866 $252,822 $185,044 ($754,810)
Collects and spends resources from the
3% hotel/motel tax.
Motor Fuel Tax Fund $90,400 $0 $90,400 $84,900
Collects and spends resources from the
State motor fuel tax.
Infrastructure Fund (Major Fund)$2,920,156 $2,326,023 $594,133 ($4,507,215)
Accounts for construction and maintenance of
roadways, drainage, and safety path systems.
Promenade TIF Fund (Major Fund)$506 $231,130 ($230,624)($231,255)
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)$3,893,111 $2,720,720 $1,172,391 ($1,278,545)
Collects user fees for the distribution of water
and maintenance of infrastructure.
Sports Core Fund (Major Fund)$1,579,776 $1,806,074 ($226,298)($56,945)
Accounts for revenues and expenses relating
to administration, programs, food and beverage
operations, and golf course.
Golf Surcharge Fund $25,259 $206,341 ($181,082)($75,925)
Accounts for the collection of the $3 per round
golf surcharge.
Internal Service Funds
Self Insurance Fund $1,393,271 $1,090,712 $302,559 ($16,765)
Accounts for the Village's health insurance costs
and the related contributions from the Village,
employees, retirees, and other agencies.
Garage Fund $310,626 $287,767 $22,859 ($7,745)
Accounts for the maintenance of the Village's vehicle
fleet and the related departmental reimbursements.
Equipment Replacement Fund $97,725 $1,027,198 ($929,473)($1,083,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 May 31, 2019
Village of Oak Brook
Monthly Financial Report – Fund Narrative
For the Period Ending May 31, 2019
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 significant items by individual fund:
General Fund
Sales Tax collections through May
2019 are $5,420,396, which is
$190,956 higher than through May
2018 and $207,146 over FY19 budget
to date. The increase is primarily due
to the opening of newer businesses
in town and general inflationary
growth. May 2019 collections have
been consistent with recent years,
with the exception of large one-time
receipts received in 2016.
Licenses and Permits revenue through May 2019 is $1,356,452, which is $86,191 higher than
through May 2018 and $384,302 over FY19 budget to date. The Village issued a number of large
building permits this month, including the expansion of the Hub Group corporate offices.
Charges for Services revenue through May 2019 is $480,576, which is $152,896 higher than
through May 2018, but $100,574 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.
Personnel expenditures through May 2019 are $7,179,203, which is $316,423 more than
through May 2018, but $492,247 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.
Operation and Contract expenditures through May 2019 are $1,849,343, which is $198,256
more than through May 2018, but $36,917 under FY19 budget to date. The increase is primarily
due to the addition of five contracted paramedics to increase ambulance services.
Capital Outlay expenditures through May 2019 are $510,613, which is $117,352 less than
through May 2018 and $125,437 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
Hotel Tax collections through May 2019 are $390,220, which is $41,046 lower than through May
2018 and $38,780 under FY19 budget to date. This is primarily due to the timing of receipts
coming in. FY19 tax receipts have been consistent with the FY18 comparable month to date.
Capital Outlay expenditures through May 2019 are $26,355, which is $10,637 more than
through May 2018, but $886,240 under FY19 budget to date. Expenditures are under FY19
budget to date 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
Non-Home Rule Sales Tax collections
through May 2019 are $2,465,424,
which is $98,848 higher than through
May 2018 and $104,174 over FY19
budget to date. The increase is
primarily due to the opening of
newer businesses in town and
general inflationary growth. May
2019 collections have been
consistent with recent years, with
the exception of large one-time
receipts received in 2016.
Capital Outlay expenditures through May 2019 are $1,007,648, which is $988,716 higher than
through May 2018, but $4,826,942 under FY19 budget to date. The increase from last year is
due to the B&T Circle drainage improvement project. Projects are expected to occur later in
FY19 or early FY20 as planned.
Water Fund
Water Sales revenue through May 2019 is $3,453,812, which is $211,848 higher than through
May 2018 and $63,907 over FY19 budget to date. The increase is due to a 5% rate increase
effective January 1, 2019 and more gallons being billed than estimated.
Operation and Contractual expenditures through May 2019 are $1,443,225, which is $127,245
lower than through May 2018 and $997,330 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.
Capital Outlay expenditures through May 2019 are $712,121, which is $337,642 lower than
through May 2018 and $1,234,599 under FY19 budget to date. The decrease is due to the FY18
meter replacement project kicking off in early 2018. The 2019 budgeted capital projects have
not all started to date, but are expected to occur as planned later in 2019.
Sports Core Fund
Memberships revenue through May 2019 are $363,705, which is $36,683 lower than through
May 2018 and $47,305 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.
Greens Fees revenue through May 2019 is $174,099, which is $28,854 lower than through May
2018 and $37,486 under FY19 budget to date. Total rounds played is approximately 1,000 less
than last year due to the unfavorable weather during early 2019.
Other Revenue collections through May 2019 are $67,558, which is $90,812 lower than through
May 2018 and $86,942 under FY19 budget to date. This is due to the $100,000 McDonald’s
Taste of Oak Brook sponsorship not coming in for FY19. This sponsorship will be made up from
other sources in FY19. There has been an increase in B&T Clubhouse rentals in FY19 to offset
this loss of revenue.
Capital Outlay expenditures through May 2019 are $599,682, which is $458,721 higher than
through May 2018 and $164,182 over FY19 budget to date. The FY19 increase is due to the Golf
Club pro shop renovation and the finishing of the golf patio. 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
Other Expenditures through May 2019 are $1,003,995, 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.
5/31/19 5/31/19
5/31/18 5/31/19 YTD % of 2019 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 5,229,440$ 5,420,396$ 5,213,250$ 104.0%12,325,000$ 190,956$
Other Intergovernmental Tax*627,868 719,180 631,000 114.0%1,227,750 91,312
Telecommunications/Utility Tax 2,616,522 2,712,290 2,519,950 107.6%5,857,500 95,768
Licenses and Permits 1,270,261 1,356,452 972,150 139.5%2,335,050 86,191
Charges for Services 327,680 480,576 581,150 82.7%1,491,400 152,896
Fines and Penalties 76,855 107,583 65,850 163.4%158,000 30,728
Administrative Towing Fees 14,825 9,386 12,500 75.1%30,000 (5,439)
Interest on Investments 131,569 185,174 137,500 134.7%330,000 53,605
Franchise/IMF Maint. Fee 53,478 53,211 106,500 50.0%213,000 (267)
Miscellaneous Income 179,438 108,208 81,650 132.5%212,800 (71,230)
Total Operating Revenues 10,527,936$ 11,152,456$ 10,321,500$ 108.1%24,180,500$ 624,520$
OPERATING EXPENDITURES
Personnel 6,862,780$ 7,179,203$ 7,671,450$ 93.6%18,183,745$ 316,423$
Materials and Supplies 198,763 180,752 282,890 63.9%559,780 (18,011)
Operation and Contract 1,651,087 1,849,343 1,886,260 98.0%4,224,475 198,256
Other Expenditures 2,200 5,135 5,000 102.7%10,000 2,935
Capital Outlay 627,965 510,613 636,050 80.3%862,475 (117,352)
Total Operating Expenditures 9,342,795$ 9,725,046$ 10,481,650$ 92.8%23,840,475$ 382,251$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 1,185,141$ 1,427,410$ (160,150)$ 340,025$ 242,269$
OTHER TRANSACTIONS
Transfers In -$ 508,235$ 508,235$ 100.0%508,235$ 508,235$
Transfers Out - (234,668) (205,500) 114.2%(1,216,725) (234,668)
Reimbursements From Other Funds 262,105 263,420 263,425 100.0%632,210 1,315
Reimbursements To Other Funds (54,715) (54,625) (54,625) 100.0%(131,100) 90
Sports Core Loan - (20,200) - N/A - (20,200)
Total Interfund Transactions 207,390$ 462,162$ 511,535$ 90.3%(207,380)$ 254,772$
NET FUND INCREASE (DECREASE)1,392,531$ 1,889,572$ 351,385$ 132,645$ 497,041$
*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 May 31, 2019
Total Total
Revenues Expenditures
4/30/19 Actual 11,152,456$ 9,725,046$
4/30/18 Actual 10,527,936$ 9,342,795$
% Change From Last Year 5.9%4.1%
Major Revenues Other
Intergov.Licenses &Charges for
Sales Tax Tax Telecom Tax Permits Services
4/30/19 Actual 5,420,396$ 719,180$ 2,712,290$ 1,356,452$ 480,576$
4/30/18 Actual $ 5,229,440 $ 627,868 $ 2,616,522 $ 1,270,261 $ 327,680
% Change From Last Year 3.7%14.5%3.7%6.8%46.7%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
4/30/19 Actual 7,179,203$ 180,752$ 1,849,343$ 5,135$ 510,613$
4/30/18 Actual 6,862,780$ 198,763$ 1,651,087$ 2,200$ 627,965$
% Change From Last Year 4.6%-9.1%12.0%133.4%-18.7%
Five Year Trend
Expenditures by Department
5/31/18 5/31/19 5/31/19 5/31/19 2019 Difference Five
YTD YTD YTD % of Annual Prior Year
Department Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 957,904$ 964,853$ 1,116,175$ 86.4%2,700,820$ 6,949$
Financial Services 317,629 324,010 346,700 93.5%782,860 6,381
Public Works 274,572 350,884 377,440 93.0%886,420 76,312
Engineering & Capital Projects 539,412 289,520 191,625 151.1%459,900 (249,892)
Library 354,626 394,825 402,680 98.0%928,675 40,199
Police 3,469,164 3,679,398 4,041,015 91.1%8,891,960 210,234
Fire 3,046,529 3,339,551 3,595,505 92.9%8,207,785 293,022
Development Services 382,959 382,005 410,510 93.1%982,055 (954)
Total Expenditures 9,342,795$ 9,725,046$ 10,481,650$ 92.8%23,840,475$ 382,251$
Five Year Trend
For the Period Ending May 31, 2019
General Fund - Five Year Trend
Village of Oak Brook
Revenues Expenditures
5/31/19 5/31/19
5/31/18 5/31/19 YTD % of 2019 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Hotel Tax 431,266$ 390,220$ 429,000$ 91.0%1,268,000$ (41,046)$
Interest 29,159 47,646 12,500 381.2%30,000 18,487
Miscellaneous 2,977 - - 0.0%- (2,977)
Total Operating Revenues 463,402$ 437,866$ 441,500$ 99.2%1,298,000$ (25,536)$
EXPENDITURES
Operation and Contract 80,531$ 183,502$ 240,765$ 76.2%577,860$ 102,971$
Capital Outlay 15,718 26,355 912,595 2.9%4,180,545 10,637
Total Expenditures 96,249$ 209,857$ 1,153,360$ 18.2%4,758,405$ 113,608$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 367,153$ 228,009$ (711,860)$ -32.0%(3,460,405)$ (139,144)$
INTERFUND TRANSACTIONS
Reimbursements to Other Funds (41,475)$ (42,965)$ (42,950)$ 100.0%(103,115)$ (1,490)$
Total Interfund Transactions (41,475)$ (42,965)$ (42,950)$ 100.0%(103,115)$ (1,490)$
NET FUND INCREASE (DECREASE)325,678$ 185,044$ (754,810)$ (3,563,520)$ (140,634)$
Note - Expenditures are recorded in program 171.
Village of Oak Brook
Hotel Tax Fund Financial Update
For the Period Ending May 31, 2019
Total Total
Revenues Expenditures
4/30/19 Actual $ 437,866 209,857$
4/30/18 Actual $ 463,402 96,249$
% Change From Last Year -5.5%118.0%
Major Revenues
Hotel Tax Interest Miscellaneous
4/30/19 Actual $ 390,220 $ 47,646 $ -
4/30/18 Actual $ 431,266 $ 29,159 $ 2,977
% Change From Last Year -9.5%63.4%-100.0%
Five Year Trend
Major Expenditures Operation &
Contractual Capital Outlay
4/30/19 Actual 183,502$ 26,355$
4/30/18 Actual 80,531$ 15,718$
% Change From Last Year 127.9%67.7%
Five Year Trend
Village of Oak Brook
Hotel Tax Fund - Major Sources Five Year Trend
For the Period Ending May 31, 2019
Five Year Trend
Revenues Expenditures
5/31/19 5/31/19
5/31/18 5/31/19 YTD % of 2019 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 2,366,576$ 2,465,424$ 2,361,250$ 104.4%5,548,000$ 98,848$
Interest 59,799 99,672 35,000 284.8%80,000 39,873
Miscellaneous 2,729 - 2,075 0.0%5,000 (2,729)
Total Operating Revenues 2,429,104$ 2,565,096$ 2,398,325$ 107.0%5,633,000$ 135,992$
OPERATING EXPENDITURES
Personnel 525,771$ 571,524$ 571,475$ 100.0%1,322,375$ 45,753$
Materials and Supplies 80,382 97,602 97,830 99.8%246,845 17,220
Operation and Contract 403,298 581,944 689,405 84.4%1,663,435 178,646
Capital Outlay 18,932 1,007,648 5,834,590 17.3%10,008,575 988,716
Total Operating Expenditures 1,028,383$ 2,258,718$ 7,193,300$ 31.4%13,241,230$ 1,230,335$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 1,400,721$ 306,378$ (4,794,975)$ -6.4%(7,608,230)$ (1,094,343)$
INTERFUND TRANSACTIONS
Transfers In 7,790$ 216,125$ 216,125$ 100.0%1,116,125$ 208,335$
Reimbursements From Other Funds 75,470 138,935 138,950 100.0%333,445 63,465
Reimbursements To Other Funds (68,695) (67,305) (67,315) 100.0%(161,535) 1,390
Total Interfund Transactions 14,565$ 287,755$ 287,760$ 100.0%1,288,035$ 273,190$
NET FUND INCREASE (DECREASE)1,415,286$ 594,133$ (4,507,215)$ (6,320,195)$ (821,153)$
Village of Oak Brook
Infrastructure Fund Financial Update
For the Period Ending May 31, 2019
Total Total
Revenues Expenditures
4/30/19 Actual $ 2,565,096 2,258,718$
4/30/18 Actual $ 2,429,104 1,028,383$
% Change From Last Year 5.6%119.6%
Major Revenues
Sales Tax Grants Interest Miscellaneous Reimbursements
4/30/19 Actual $ 2,465,424 $ - $ 99,672 $ - $ 138,935
4/30/18 Actual $ 2,366,576 $ - $ 59,799 $ 2,729 $ 75,470
% Change From Last Year 4.2%0.0%66.7%-100.0%84.1%
Five Year Trend
Major Expenditures Materials &Operation &
Personnel Supplies Contractual Capital Outlay
4/30/19 Actual 571,524$ 97,602$ 581,944$ 1,007,648$
4/30/18 Actual 525,771$ 80,382$ 403,298$ 18,932$
% Change From Last Year 8.7%21.4%44.3%5222.5%
Five Year Trend
Expenditures by Department
5/31/18 5/31/19 5/31/19 5/31/19 2019 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 67,336$ 48,055$ 70,905$ 67.8%179,485$ (19,281)$
Public Works 828,921 1,228,952 5,073,620 24.2%6,462,865 400,031
Engineering & Capital Projects 132,126 1,049,017 2,116,090 49.6%6,760,415 916,891
Total Expenditures 1,028,383$ 2,326,024$ 7,260,615$ 32.0%13,402,765$ 1,297,641$
Five Year Trend
Village of Oak Brook
Infrastructure Fund - Major Sources Five Year Trend
For the Period Ending May 31, 2019
Revenues Expenditures
5/31/19 5/31/19
5/31/18 5/31/19 YTD % of 2019 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax -$ -$ -$ 0.0%100,000$ -$
Real Estate Tax - - - 0.0%360,000 -
Interest 415 506 375 134.9%900 91
Total Operating Revenues 415$ 506$ 375$ 134.9%460,900$ 91$
EXPENDITURES
Operation and Contract 438$ -$ 500$ 0.0%4,210$ (438)$
Other Expenditures 223,210 231,130 231,130 100.0%460,980 7,920
Total Expenditures 223,648$ 231,130$ 231,630$ 99.8%465,190$ 7,482$
NET FUND INCREASE (DECREASE)(223,233)$ (230,624)$ (231,255)$ (4,290)$ (7,391)$
Note - Expenditures are recorded in program 283.
Village of Oak Brook
Promenade TIF Fund Financial Update
For the Period Ending May 31, 2019
Total Total
Revenues Expenditures
4/30/19 Actual $ 506 231,130$
4/30/18 Actual $ 415 223,648$
% Change From Last Year 21.9%3.3%
Major Revenues Real Estate
Sales Tax Tax Interest
4/30/19 Actual $ - $ - $ 506
4/30/18 Actual $ - $ - $ 415
% Change From Last Year 0.0%0.0%21.9%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures
4/30/19 Actual -$ 231,130$
4/30/18 Actual 438$ 223,210$
% Change From Last Year 0.0%3.5%
Five Year Trend
Village of Oak Brook
Promenade TIF Fund - Major Sources Five Year Trend
For the Period Ending May 31, 2019
Five Year Trend
Revenues Expenditures
5/31/19 5/31/19
5/31/18 5/31/19 YTD % of 2019 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Plan Review Fees 375$ 675$ 625$ 108.0%1,500$ 300$
Building/Inspection Fees 2,400 1,913 2,075 92.2%5,000 (487)
Water Sales 3,241,964 3,453,812 3,389,905 101.9%10,223,250 211,848
Unmetered Sales 6,395 7,647 12,500 61.2%30,000 1,252
Water Connection Fees 30,174 86,250 20,750 415.7%50,000 56,076
Fire Service Charge - - 2,075 0.0%5,000 -
Meter Charges 4,978 7,127 8,345 85.4%20,000 2,149
Special Services 16,394 16,203 15,000 108.0%30,000 (191)
Interest on Investments 35,736 73,849 22,900 322.5%55,000 38,113
Miscellaneous 32,941 24,550 31,250 78.6%75,000 (8,391)
Total Operating Revenues 3,371,357$ 3,672,026$ 3,505,425$ 104.8%10,494,750$ 300,669$
EXPENDITURES
Personnel 315,619$ 318,710$ 351,395$ 90.7%828,710$ 3,091$
Materials and Supplies 20,185 16,734 36,450 45.9%76,210 (3,451)
Operation and Contract 1,570,470 1,443,225 2,440,555 59.1%5,822,285 (127,245)
Capital Outlay 1,049,763 712,121 1,946,720 36.6%6,244,075 (337,642)
Total Expenditures 2,956,037$ 2,490,790$ 4,775,120$ 52.2%12,971,280$ (465,247)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 415,320$ 1,181,236$ (1,269,695)$ (2,476,530)$ 765,916$
INTERFUND TRANSACTIONS
Transfers In -$ 221,085$ 221,085$ 100.0%221,085$ 221,085
Reimbursements To Other Funds (168,820) (229,930) (229,935) 100.0%(551,830) (61,110)
Total Interfund Transactions (168,820)$ (8,845)$ (8,850)$ 99.9%(330,745)$ 159,975$
NET FUND INCREASE (DECREASE)246,500$ 1,172,391$ (1,278,545)$ (2,807,275)$ 925,891$
Village of Oak Brook
Water Fund Financial Update
For the Period Ending May 31, 2019
Total Total
Revenues Expenditures
4/30/19 Actual $ 3,672,026 2,490,790$
4/30/18 Actual $ 3,371,357 2,956,037$
% Change From Last Year 8.9%-15.7%
Unmetered Water
Water Sales Sales Connection Fees Meter Charges Miscellaneous
4/30/19 Actual $ 3,453,812 $ 7,647 $ 86,250 $ 7,127 $ 24,550
4/30/18 Actual $ 3,241,964 $ 6,395 $ 30,174 $ 4,978 $ 32,941
% Change From Last Year 6.5%19.6%185.8%43.2%-25.5%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
4/30/19 Actual 318,710$ 16,734$ 1,443,225$ -$ 712,121$
4/30/18 Actual 315,619$ 20,185$ 1,570,470$ -$ 1,049,763$
% Change From Last Year 1.0%-17.1%-8.1%0.0%-32.2%
Five Year Trend
Expenditures by Department
5/31/18 5/31/19 5/31/19 5/31/19 2019 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Public Works 1,885,690$ 1,995,900$ 3,066,670$ 65.1%7,299,035$ 110,210$
Engineering & Capital Projects 1,070,347 724,820 1,938,385 37.4%6,224,075 (345,527)
Total Expenditures 2,956,037$ 2,720,720$ 5,005,055$ 54.4%13,523,110$ (235,317)$
Five Year Trend
Village of Oak Brook
Water Fund - Major Sources Five Year Trend
For the Period Ending May 31, 2019
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Sports Core Fund Consolidated Presentation
For the Period Ending May 31, 2019
5/31/19 5/31/19
5/31/19 YTD % of 2019 5/31/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 172,205$ -$ 191,500$ 363,705$ 411,010$ 88.5%453,815$ 400,388$ (36,683)$
Greens Fees - - 174,099 174,099 211,585 82.3%930,000 202,953 (28,854)
Pro Shop Sales - - 71,327 71,327 75,415 94.6%200,000 71,617 (290)
Golf Lessons - - 21,725 21,725 18,500 117.4%40,000 18,532 3,193
Driving Range Fees - - 118,106 118,106 120,950 97.6%226,000 111,294 6,812
Rentals - - 136,506 136,506 155,225 87.9%459,000 136,600 (94)
Programs/User Fees 71,700 - - 71,700 86,370 83.0%253,450 86,164 (14,464)
Food Sales - 31,229 - 31,229 30,815 101.3%175,500 29,114 2,115
Beverage Sales - 49,277 - 49,277 45,590 108.1%252,500 49,104 173
Other Revenue 12,795 48,947 5,816 67,558 154,500 43.7%428,300 158,370 (90,812)
Total Direct Revenues 256,700$ 129,453$ 719,079$ 1,105,232$ 1,309,960$ 84.4%3,418,565$ 1,264,136$ (158,904)$
DIRECT EXPENDITURES
Personnel 43,916$ 82,373$ 378,718$ 505,007$ 506,845$ 99.6%1,572,920$ 478,140$ 26,867$
Materials & Supplies 10,043 73,879 109,637 193,559 246,745 78.4%580,645 161,581 31,978
Operational & Contractual 329,217 45,141 116,944 491,302 501,640 97.9%1,115,975 524,680 (33,378)
Other - - 16,524 16,524 - N/A (83,150) 33,048 (16,524)
Capital 39,974 331,703 228,005 599,682 435,500 137.7%1,655,900 140,961 458,721
Total Direct Expenditures 423,150$ 533,096$ 849,828$ 1,806,074$ 1,690,730$ 106.8%4,842,290$ 1,338,410$ 467,664$
Direct Revenues Over (Under) Expenditures (166,450)$ (403,643)$ (130,749)$ (700,842)$ (380,770)$ 184.1%(1,423,725)$ (74,274)$ (626,568)$
B&T Administration Overhead Allocation*56,249$ (56,249)$ -$ -$ -$ 0.0%-$ -$ -$
Operating Revenues Over (Under) Expenditures (110,201)$ (459,892)$ (130,749)$ (700,842)$ (380,770)$ 184.1%(1,423,725)$ (74,274)$ (626,568)$
Interfund Loan**20,200$ -$ -$ 20,200$ -$ N/A -$ -$ 20,200$
Transfer From General Fund 32,171 202,497 - 234,668 205,500 114.2%1,216,725 - 234,668
Transfer From Golf Surcharge Fund - - 206,341 206,341 105,000 196.5%175,000 - 206,341
Reimbursement From Infrastructure Fund 10,000 - - 10,000 10,000 100.0%24,000 10,000 -
Reimbursement From Water Fund 3,335 - - 3,335 3,325 100.3%8,000 3,335 -
Adjusted Operating Revenues Over (Under) Expenditures (44,495)$ (257,395)$ 75,592$ (226,298)$ (56,945)$ -$ (60,939)$ (165,359)$
*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
4/30/19 Actual $ 1,105,232 1,806,074$
4/30/18 Actual $ 1,264,136 1,338,410$
% Change From Last Year -12.6%34.9%
Driving Program/
Memberships Greens Fees Range Fees Rentals User Fees
4/30/19 Actual $ 363,705 $ 174,099 $ 118,106 $ 136,506 $ 71,700
4/30/18 Actual $ 400,388 $ 202,953 $ 111,294 $ 136,600 $ 86,164
% Change From Last Year -9.2%-14.2%6.1%-0.1%-16.8%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
4/30/19 Actual 505,007$ 193,559$ 491,302$ 16,524$ 599,682$
4/30/18 Actual 478,140$ 161,581$ 524,680$ 33,048$ 140,961$
% Change From Last Year 5.6%19.8%-6.4%0.0%325.4%
Five Year Trend
Revenues by Department 5/31/18 5/31/19 5/31/19 5/31/19 2019 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Programs 399,698$ 256,700$ 646,495$ 39.7%686,515$ (142,998)$
Food & Beverage 118,453 129,453 127,800 101.3%663,000 11,000
Golf Club 745,985 719,079 567,997 126.6%2,069,050 (26,906)
Total Revenues 1,264,136$ 1,105,232$ 1,342,292$ 82.3%3,418,565$ (158,904)$
Expenditures by Department 5/31/18 5/31/19 5/31/19 % of 2019 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Programs 494,074$ 423,150$ 344,363$ 122.9%1,883,075$ (70,924)$
Food & Beverage 191,394 533,096 281,968 189.1%1,037,845 341,702
Golf Club 652,942 849,828 778,751 109.1%1,921,370 196,886
Total Expenditures 1,338,410$ 1,806,074$ 1,405,082$ 128.5%4,842,290$ 467,664$
Five Year Trend
Village of Oak Brook
Sports Core Fund - Major Sources Five Year Trend
For the Period Ending May 31, 2019
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Club Recreation Programs
For the Period Ending May 31, 2019 5/31/19 5/31/19
5/31/19 YTD % of 2019 5/31/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 -$ 165,655$ 6,550$ -$ -$ 172,205$ 208,560$ 82.6%244,815$ 199,763$ (27,558)$
Programs/User Fees - 10,475 11,910 - 49,315 71,700 86,370 83.0%253,450 86,164 (14,464)
Other Revenue (705) - - - 13,500 12,795 112,850 11.3%188,250 113,771 (100,976)
Total Revenue (705)$ 176,130$ 18,460$ -$ 62,815$ 256,700$ 407,780$ 63.0%686,515$ 399,698$ (142,998)$
Expenditures:
Personnel 48,883$ -$ (4,967)$ -$ -$ 43,916$ 58,265$ 75.4%182,405$ 43,799$ 117$
Materials & Supplies 392 9,651 - - - 10,043 16,180 62.1%26,350 15,206 (5,163)
Operational & Contractual 41,707 240,611 10,040 17,500 19,359 329,217 302,275 108.9%673,820 353,152 (23,935)
Capital 12,476 24,414 - - 3,084 39,974 90,500 44.2%1,000,500 81,917 (41,943)
Total Expenditures 103,458$ 274,676$ 5,073$ 17,500$ 22,443$ 423,150$ 467,220$ 90.6%1,883,075$ 494,074$ (70,924)$
Direct Revenues Over (Under) Expenditures (104,163)$ (98,546)$ 13,387$ (17,500)$ 40,372$ (166,450)$ (59,440)$ 280.0%(1,196,560)$ (94,376)$ (72,074)$
B&T Administration Overhead Allocation*104,163$ (37,498)$ (10,416)$ 56,249$ 51,580$ 109.1%91,410$ 45,004$ 11,245$
Revenues Over (Under) Expenditures -$ (136,044)$ 2,971$ (17,500)$ 40,372$ (110,201)$ (7,860)$ 1402.0%(1,105,150)$ (49,372)$ (60,829)$
Interfund Loan**20,200$ -$ -$ -$ -$ 20,200$ -$ N/A -$ -$ 20,200$
Transfer From General Fund 12,476 19,695 - - - 32,171 80,500 40.0%965,500 - 32,171
Reimbursement From Infrastructure Fund 10,000 - - - - 10,000 10,000 100.0%24,000 10,000 -$
Reimbursement From Water Fund 3,335 - - - - 3,335 3,325 100.3%8,000 3,335 -
Adjusted Revenues Over (Under) Expenditures 46,011$ (116,349)$ 2,971$ (17,500)$ 40,372$ (44,495)$ 85,965$ (107,650)$ (36,037)$ (8,458)$
*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 May 31, 2019
5/31/19 5/31/19
821 822 823 5/31/19 YTD % of 2019 5/31/18 Difference
B&T Poolside Golf YTD Amended Amended Adopted YTD Prior
Clubhouse Café Clubhouse Total Budget Budget Budget Total Year
Revenues:
Food Sales -$ 929$ 30,300$ 31,229$ 30,815$ 101.3%175,500$ 29,114$ 2,115$
Beverage Sales - 518 48,759 49,277 45,590 108.1%252,500 49,104 173
Other Revenue 48,947 - - 48,947 40,000 122.4%235,000 40,235 8,712
Total Revenue 48,947$ 1,447$ 79,059$ 129,453$ 116,405$ 111.2%663,000$ 118,453$ 11,000$
Expenditures:
Personnel 49,165$ 39$ 33,169$ 82,373$ 88,525$ 93.1%286,125$ 77,014$ 5,359$
Materials & Supplies 2,845 16,404 54,630 73,879 67,325 109.7%208,200 64,305 9,574
Operational & Contractual 41,001 25 4,115 45,141 73,815 61.2%153,120 50,075 (4,934)
Capital 331,703 - - 331,703 200,000 165.9%390,400 - 331,703
Total Expenditures 424,714$ 16,468$ 91,914$ 533,096$ 429,665$ 124.1%1,037,845$ 191,394$ 341,702$
Direct Revenues Over (Under) Expenditures (375,767)$ (15,021)$ (12,855)$ (403,643)$ (313,260)$ 128.9%(374,845)$ (72,941)$ (330,702)$
B&T Administration Overhead Allocation*(52,082)$ (4,167)$ -$ (56,249)$ (51,580)$ 109.1%(91,410)$ (45,004)$ (11,245)$
Revenues Over (Under) Expenditures (427,849)$ (19,188)$ (12,855)$ (459,892)$ (364,840)$ 126.1%(466,255)$ (117,945)$ (341,947)$
Transfer From General Fund 202,497$ -$ -$ 202,497$ 125,000$ 162.0%251,225$ -$ 202,497$
Adjusted Revenues Over (Under) Expenditures (225,352)$ (19,188)$ (12,855)$ (257,395)$ (239,840)$ (215,030)$ (117,945)$ (139,450)$
*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 May 31, 2019
5/31/19 5/31/19
831 832 833 834 5/31/19 YTD % of 2019 5/31/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 191,500$ -$ -$ -$ 191,500$ 202,450$ 94.6%209,000$ 200,625$ (9,125)$
Greens Fees 174,099 - - - 174,099 211,585 82.3%930,000 202,953 (28,854)
Pro Shop Sales 71,327 - - - 71,327 75,415 94.6%200,000 71,617 (290)
Golf Lessons - 21,725 - - 21,725 18,500 117.4%40,000 18,532 3,193
Driving Range Fees - 118,106 - - 118,106 120,950 97.6%226,000 111,294 6,812
Rentals 745 75,000 60,761 - 136,506 155,225 87.9%459,000 136,600 (94)
Other Revenue 5,816 - - - 5,816 1,650 352.5%5,050 4,364 1,452
Total Revenue 443,487$ 214,831$ 60,761$ -$ 719,079$ 785,775$ 91.5%2,069,050$ 745,985$ (26,906)$
Expenditures:
Personnel 176,780$ 6,102$ 9,588$ 186,248$ 378,718$ 360,055$ 105.2%1,104,390$ 357,327$ 21,391$
Materials & Supplies 48,472 10,205 577 50,383 109,637 163,240 67.2%346,095 82,070 27,567
Operational & Contractual 86,711 - 8,865 21,368 116,944 125,550 93.1%289,035 121,453 (4,509)
Other - - 16,524 - 16,524 - N/A (83,150) 33,048 (16,524)
Capital 214,470 - - 13,535 228,005 145,000 157.2%265,000 59,044 168,961
Total Expenditures 526,433$ 16,307$ 35,554$ 271,534$ 849,828$ 793,845$ 107.1%1,921,370$ 652,942$ 196,886$
Direct Revenues Over (Under) Expenditures (82,946)$ 198,524$ 25,207$ (271,534)$ (130,749)$ (8,070)$ 1620.2%147,680$ 93,043$ (223,792)$
Transfer from Golf Surcharge 206,341$ -$ -$ -$ 206,341$ 105,000$ 196.5%175,000$ -$ 206,341$
Adjusted Revenues Over (Under) Expenditures 123,395$ 198,524$ 25,207$ (271,534)$ 75,592$ 96,930$ 322,680$ 93,043$ (17,451)$