Loading...
06 - June 2019 Monthly Financial ReportVILLAGE OAK BROOK OF MONTHLY FINANCIAL REPORTS JUNE 2019 ITEM 6.F Total Cash and Cash Pooled Cash and Fund Equivalents Investments Investments % By Fund General Corporate $6,495,627 $13,989,298 $20,484,925 44.4% Hotel/Motel Tax 3,075,346 1,866,011 4,941,357 10.7% Motor Fuel Tax 751,604 138,722 890,326 1.9% Infrastructure 7,665,868 2,275,101 9,940,969 21.6% Promenade TIF 229,756 ‐                                       229,756                         0.5% Water 4,467,370 3,026,365 7,493,735 16.3% Sports Core 140,264                         ‐                                       140,264                         0.3% Golf Surcharge 35,049                            244,994                         280,043 0.6% Self‐Insurance 647,743 ‐                                       647,743                         1.4% Garage 344,781 ‐                                       344,781                         0.7% Equipment Replacement 267,799 451,565 719,364 1.6% Total $24,121,207 $21,992,056 $46,113,263 100.0% Change in Cash and Investments by Fund : Balance at Balance at Year‐to‐Date Year‐to‐Date Fund January 1, 2019 June 30, 2019 Change ($) Change (%) General Corporate $18,092,186 $20,484,925 $2,392,739 13.2% Hotel/Motel Tax 4,843,367 4,941,357 97,990 2.0% Motor Fuel Tax 782,203 890,326 108,123 13.8% Infrastructure 9,322,381 9,940,969 618,588 6.6% Promenade TIF 257,485 229,756                        (27,729)‐10.8% Water 6,449,315 7,493,735 1,044,420 16.2% Sports Core 190,397 140,264                        (50,133)‐26.3% Golf Surcharge 442,152 280,043 (162,109)‐36.7% Self‐Insurance 468,568 647,743                         179,175 38.2% Garage 331,134 344,781                         13,647 4.1% Equipment Replacement 1,636,238 719,364 (916,874)‐56.0% $42,815,426 $46,113,263 $3,297,837 7.7% Book Bank/Market   Value Value Pooled Checking $729,892 $1,437,461 Sports Core Checking 191,069 155,404 Pooled IPTIP 23,120,399 23,120,399 Water E‐Pay IPTIP 79,847 79,847 $24,121,207 $24,793,111 Pooled Investments: Investments‐Municipal Bonds $6,164,376 $6,152,615 Investments‐Corporate Bonds 8,536,209 8,589,424 Government & Agency Obligations 684,531 670,070 Certificates of Deposit 6,485,000 6,493,135 Accrued Interest 121,940 121,940 Total Pooled Investments $21,992,056 $22,027,184 Total Cash and Investments $46,113,263 $46,820,295 For June, total interest revenue is $90,938 and YTD revenue is $528,022. Total investment yield for the portfolio is: Pooled Investments Illinois Funds Total Monthly yield 0.20% 0.22% 0.21% YTD yield 1.18% 1.27% 1.22% Last 12 months yield 2.21% 2.32% 2.26% The weighted average yield of the current pooled investment portfolio is 2.43%.   Monthly Treasurer's Report June 30, 2019 Monthly Treasurer's Report June 2019 The table below lists the detail investment holdings at J.P. Morgan Securities as of 6/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% $502,057 $499,915 $1,163 New York N Y City #64971QTX1 02/22/16 05/01/21 2.350% 2.000% 201,243 201,172 769 Florida Hurricane #34074GDH4 03/30/16 07/01/20 2.995% 2.150% 504,084 503,250 7,487 Bloomingdale Mich Pub Sch Dist #094383FS0 04/26/16 05/01/22 2.710% 2.150% 507,625 506,700 2,219 Milan Mich Area Achs #598801JD1 05/26/16 05/01/20 1.931% 1.931% 245,000 244,566 688 Indiana Bd Bk Rev Taxable #4546248F7 01/06/17 01/15/20 2.934% 1.900% 256,375 255,921 3,463 Garland Cnty Ark Sales & Use #36609PAN3 02/06/17 11/01/19 1.795% 1.840% 499,923 499,060 1,621 Lanse Creuse Mich Pub Schs #516228RL9 05/02/17 05/01/20 2.159% 2.159% 100,000 99,993 358 California St GO Bonds #13063A7G3 05/08/17 10/01/19 6.200% 1.600% 505,749 505,000 7,468 Connecticut St GO Bds 2016 #20772J3F7 06/15/17 08/15/21 1.750% 2.300% 494,337 493,800 3,252 North Carolina Eastn Mun Pwr #65819WAL7 10/02/17 07/01/19 2.578% 1.700% 500,010 500,000 6,302 Fowlerville Mich Comnty Schs #351280MS8 10/03/17 05/01/20 2.045% 1.750% 501,223 500,070 1,534 Racine Cnty WI #749845UK7 12/20/17 12/01/20 2.150% 2.150% 750,000 746,708 1,344 Wisconsin St Gen Fd Annual #977100CW4 01/05/18 05/01/20 1.446% 2.100% 596,750 596,460 1,350 Total Municipal Bonds $6,164,376 $6,152,615 $39,018 Corporate Bonds: Goldman Sachs #38141GVP9 09/26/18 09/15/20 2.750% 3.180% 497,480 502,085 4,010 Fifth Third #31677QBH1 10/11/18 09/27/19 1.625% 2.750% 997,385 998,125 4,243 JP Morgan #46640QUV1 11/01/18 07/29/19 0.000% 3.017% 1,496,451 1,496,952 0 Wells Fargo #94974BGR5 01/15/19 12/07/20 2.550% 3.120% 1,379,031 1,393,892 2,658 SunTrust #86787EAU1 01/28/19 01/29/21 2.590% 3.050% 498,733 500,370 5,396 PNC Bank #69353RFH6 01/30/19 01/22/21 2.500% 3.020% 496,073 501,675 5,521 Morgan Stanley #61747WAL3 03/08/19 07/28/21 5.500% 3.034% 1,101,665 1,115,583 24,382 Citigroup #172967LC3 04/01/19 12/08/21 2.900% 2.754% 1,003,416 1,010,370 1,289 Bank of America #06051GFT1 04/03/19 10/19/20 2.625% 2.625% 700,000 702,751 3,420 Goldman Sachs #38143U8F1 05/02/19 02/25/21 2.875% 2.707% 365,975 367,621 3,646 Total Corporate Bonds $8,536,209 $8,589,424 $54,565 Government & Agency Obligations: *Government National Mtg Assn #38379UEM4 02/29/16 02/16/51 2.300% 2.245% $684,531 $670,070 $2,217 Total Government & Agency Obligations: $684,531 $670,070 $2,217 Certificates of Deposit: State Bk India NY #8562846A7 01/26/17 01/26/22 2.250% 2.250% $245,000 $245,076 $2,374 Marlin Bank #57116ANU8 05/10/17 11/12/19 1.610% 1.610% 245,000 244,493 222 American Express Fed Svgs #02587CER7 05/10/17 11/12/19 1.700% 1.700% 245,000 244,571 590 TIAA FSB Jacksonville #87270LAA1 07/19/17 07/19/19 1.600% 1.600% 245,000 244,904 1,748                    Peoples United Bank #71270QQZ2 07/19/17 07/19/19 1.650% 1.650% 245,000 244,909 1,803                    Priority Bank Ozark Ark #74269KBR6 07/26/17 07/26/19 1.600% 1.600% 245,000 244,875 50                          American Express Centurion #02587DV96 08/15/17 08/17/20 1.900% 1.900% 245,000 244,177 1,727                    Sallie Mae #795450C86 08/16/17 08/17/20 1.900% 1.900% 245,000 244,233 1,727                    Merrick Bank South Jordan #59013JZS1 08/21/17 08/21/20 1.800% 1.800% 245,000 243,949 124                       Pinnacle Bank #72345SFS5 08/30/17 08/31/20 1.800% 1.800% 115,000 114,495 182                       Jackson County Bank #466682AP6 08/31/17 03/01/21 1.850% 1.850% 245,000 243,616 1,529                    Barclays Bank #06740KKX4 09/27/17 09/28/20 1.950% 1.950% 245,000 244,297 1,254                    Capital One Bank #1404205E6 10/04/17 10/04/19 1.700% 1.700% 245,000 244,662 1,001                    Goldman Sachs Bank #38148PRK5 10/18/17 10/19/20 1.950% 1.950% 245,000 244,260 962                       FirstBank PR Santurce #33767A6M8 11/03/17 11/03/20 2.000% 2.000% 245,000 244,400 366                       Morgan Stanley #61747MQ53 03/22/18 03/23/20 2.550% 2.550% 245,000 245,659 1,601                    Investors Community Bank #46147UTT7 08/28/18 02/28/20 2.550% 2.550% 245,000 245,630 38                          Lakeside Bank #51210SPS0 08/30/18 03/30/20 2.550% 2.550% 245,000 245,676 551                       Bank United #066519GJ2 08/31/18 02/20/20 2.500% 2.500% 245,000 245,551 2,067                    Compass Bank #20451PVW3 10/26/18 10/26/20 3.000% 3.000% 245,000 247,607 1,317                    UBS Bank #90348JFH8 10/30/18 10/29/20 3.050% 3.050% 245,000 247,791 662                       Citibank #17294XJP2 10/31/18 10/31/20 3.000% 3.000% 245,000 245,644 1,276                    Discover Bank #254673WF9 11/07/18 11/09/20 3.000% 3.000% 245,000 247,680 1,112                    Ally Bank #02007GFX6 11/08/18 11/09/20 3.000% 3.000% 245,000 247,680 1,092                    Comenity Cap Bank #20033AU46 04/15/19 04/15/21 2.500% 2.500% 245,000 246,306 252                       Radius Bank #75047ABE3 05/30/19 05/28/21 2.450% 2.450% 245,000 245,078 23                          Morgan Stanley #61760AE21 05/30/19 06/01/21 2.400% 2.400% 245,000 245,916 490                       Total Certificates of Deposits $6,485,000 $6,493,135 $26,140 Total J.P.Morgan Securities $21,870,116 $21,905,244 $121,940 *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 June 30, 2019 Cash & Investments by Fund ‐ Total $46.1 million Cash & Investments by Type ‐ Total $46.1 million General Corporate 44.42% Hotel/Motel Tax 10.72%Motor Fuel Tax 1.93% Infrastructure 21.56% Promenade TIF 0.50% Water 16.25% Sports Core 0.30% Golf Surcharge 0.61% Self‐Insurance 1.40%Garage 0.75% Equipment  Replacement 1.56% Checking, $0.9 Illinois Funds, $23.2 Certificates of Deposit,  $6.5 Municipal Bonds, $6.2 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)14,071,077                 $11,665,733 $2,405,344 $504,300   Main operating fund of the Village. Hotel Fund (Major Fund)$567,597 $242,319 $325,278 ($991,055)   Collects and spends resources from the   3% hotel/motel tax. Motor Fuel Tax Fund $108,123 $0 $108,123 $101,880   Collects and spends resources from the   State motor fuel tax. Infrastructure Fund (Major Fund)$3,408,386 $2,730,543 $677,843 ($4,901,860)   Accounts for construction and maintenance of   roadways, drainage, and safety path systems. Promenade TIF Fund (Major Fund)$206,611 $234,340 ($27,729) ($51,680)   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)$4,354,025 $3,232,762 $1,121,263 ($2,225,865)   Collects user fees for the distribution of water   and maintenance of infrastructure. Sports Core Fund (Major Fund)$2,123,967 $2,190,035 ($66,068) $85,265   Accounts for revenues and expenses relating   to administration, programs, food and beverage   operations, and golf course. Golf Surcharge Fund $44,232 $206,341 ($162,109) ($55,510)   Accounts for the collection of the $3 per round   golf surcharge. Internal Service Funds Self Insurance Fund $1,668,730 $1,373,879 $294,851 ($15,840)   Accounts for the Village's health insurance costs   and the related contributions from the Village,   employees, retirees, and other agencies. Garage Fund $361,778 $356,741 $5,037 ($17,525)   Accounts for the maintenance of the Village's vehicle   fleet and the related departmental reimbursements. Equipment Replacement Fund $117,183 $1,033,224 ($916,041) ($1,074,820)   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 June 30, 2019 Village of Oak Brook  Monthly Financial Report – Fund Narrative  For the Period Ending June 30, 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 June  2019 are $6,396,358, which is  $195,097 higher than through June  2018 and $219,858 over FY19 budget  to date.  The increase is primarily due  to the opening of newer businesses  in town and general inflationary  growth.  June 2019 collections have  been consistent with recent years,  with the exception of large one‐time  receipts received in 2016.   Licenses and Permits revenue through June 2019 is $1,576,668, which is $89,592 higher than  through June 2018 and $340,433 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 June 2019 is $667,247, which is $200,503 higher than  through June 2018, but $78,173 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 June 2019 are $8,493,693, which is $229,538 more than  through June 2018, but $607,402 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.   Operation and Contract expenditures through June 2019 are $2,111,470, which is $226,831  more than through June 2018, but $61,310 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 June 2019 are $545,984, which is $530,301 less than  through June 2018 and $164,891 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 June 2019 are $510,359, which is $43,065 lower than through  June 2018 and $36,641 under FY19 budget to date.  This is primarily due to the timing of  receipts coming in.     Capital Outlay expenditures 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     Non‐Home Rule Sales Tax collections  through June 2019 are $2,906,481,  which is $101,140 higher than  through June 2018 and $109,731  over FY19 budget to date.  The  increase is primarily due to the  opening of newer businesses in town  and general inflationary growth.   June 2019 collections have been  consistent with recent years, with  the exception of large one‐time  receipts received in 2016.   Capital Outlay expenditures through June 2019 are $1,164,276, which is $1,135,763 higher than  through June 2018, but $5,264,169 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     Water Sales revenue through June 2019 is $3,885,195, which is $173,830 higher than through  June 2018 and $5,740 over FY19 budget to date.  The increase is due to a 5% rate increase  effective January 1, 2019 and slightly more gallons billed than estimated.   Operation and Contractual expenditures through June 2019 are $1,844,994, which is $165,375  lower than through June 2018 and $1,081,471 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 June 2019 are $719,986, which is $598,865 lower than  through June 2018 and $2,081,134 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 June 2019 are $413,014, which is $15,645 lower than through  June 2018 and $39,851 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 June 2019 is $341,013, which is $2,714 lower than through June  2018 and $18,172 under FY19 budget to date.  Total rounds played is consistent with the 2018  season so far despite the unfavorable weather during early 2019.   Other Revenue collections through June 2019 are $144,921, which is $56,281 lower than  through June 2018 and $47,059 under FY19 budget to date.  This is due to the $100,000  McDonald’s Taste of Oak Brook sponsorship not coming in for FY19.  There has been an increase  in B&T Clubhouse rentals in FY19 to offset this loss of revenue.   Capital Outlay expenditures through June 2019 are $649,418, which is $508,432 higher than  through June 2018 and $158,918 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 June 2019 are $1,004,794, 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.  6/30/19 6/30/19 6/30/18 6/30/19 YTD % of 2019 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax 6,201,261$        6,396,358$        6,176,500$        103.6% 12,325,000$     195,097$           Other Intergovernmental Tax* 713,320             807,596             713,500             113.2% 1,227,750          94,276                Telecommunications/Utility Tax 3,123,783          3,264,811          3,008,360          108.5% 5,857,500          141,028             Licenses and Permits 1,487,076          1,576,668          1,236,235          127.5% 2,335,050          89,592                Charges for Services 466,744             667,247             745,420             89.5% 1,491,400          200,503             Fines and Penalties 88,490                121,164             79,020                153.3% 158,000             32,674                Administrative Towing Fees 16,325                10,486                15,000                69.9% 30,000                (5,839)                 Interest on Investments 160,458             225,634             165,000             136.7% 330,000             65,176                Franchise/IMF Maint. Fee 53,478                53,211                106,500             50.0% 213,000             (267)                    Miscellaneous Income 187,302             123,563             96,950                127.5% 212,800             (63,739)              Total Operating Revenues 12,498,237$     13,246,738$     12,342,485$     107.3% 24,180,500$     748,501$           OPERATING EXPENDITURES Personnel 8,264,155$        8,493,693$        9,101,095$        93.3% 18,183,745$     229,538$           Materials and Supplies 237,018             207,032             325,505             63.6% 559,780             (29,986)              Operation and Contract 1,884,639          2,111,470          2,172,780          97.2% 4,224,475          226,831             Other Expenditures 2,200                  7,336                  5,000                  146.7% 10,000                5,136                  Capital Outlay 1,076,285          545,984             710,875             76.8% 862,475             (530,301)            Total Operating Expenditures 11,464,297$     11,365,515$     12,315,255$     92.3% 23,840,475$     (98,782)$            SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 1,033,940$        1,881,223$        27,230$             340,025$           847,283$           OTHER TRANSACTIONS Transfers In ‐$                    508,235$           508,235$           100.0% 508,235$           508,235$           Transfers Out ‐                      (234,668)            (281,725)            83.3% (1,216,725)        (234,668)            Reimbursements From Other Funds 314,526             316,104             316,110             100.0% 632,210             1,578                  Reimbursements To Other Funds (65,658)              (65,550)              (65,550)              100.0% (131,100)            108                     Total Interfund Transactions 248,868$           524,121$           477,070$           109.9% (207,380)$          275,253$           NET FUND INCREASE (DECREASE)1,282,808$        2,405,344$        504,300$           132,645$           1,122,536$        *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 June 30, 2019 Total Total Revenues Expenditures 6/30/19 Actual 13,246,738$          11,365,515$          6/30/18 Actual 12,498,237$          11,464,297$          % Change From Last Year 6.0% ‐0.9% Major Revenues Other Intergov. Licenses & Charges for Sales Tax Tax Telecom Tax Permits Services 6/30/19 Actual 6,396,358$            807,596$               3,264,811$            1,576,668$            667,247$               6/30/18 Actual  $          6,201,261   $              713,320   $          3,123,783   $          1,487,076   $              466,744  % Change From Last Year 3.1% 13.2% 4.5% 6.0% 43.0% Five Year Trend Major Expenditures Materials & Operation &Other Personnel Supplies Contractual Expenditures Capital Outlay 6/30/19 Actual 8,493,693$            207,032$               2,111,470$            7,336$                   545,984$               6/30/18 Actual 8,264,155$            237,018$               1,884,639$            2,200$                   1,076,285$            % Change From Last Year 2.8% ‐12.7% 12.0% 233.5% ‐49.3% Five Year Trend Expenditures by Department 6/30/18 6/30/19 6/30/19 6/30/19 2019 Difference Five YTD YTD YTD % of Annual Prior Year Department Actual Actual Budget Budget Budget Year Trend Legislative & General Management 1,137,362$            1,129,695$            1,344,590$            84.0% 2,700,820$            (7,667)$                  Financial Services 368,733                 379,146                 404,535                 93.7% 782,860                 10,413                   Public Works 338,769                 394,542                 461,080                 85.6% 886,420                 55,773                   Engineering & Capital Projects 985,121                 303,752                 229,950                 132.1% 459,900                 (681,369)                Library 431,491                 461,237                 474,005                 97.3% 928,675                 29,746                   Police 4,157,526              4,256,110              4,694,130              90.7% 8,891,960              98,584                   Fire 3,580,950              3,972,530              4,217,985              94.2% 8,207,785              391,580                 Development Services 464,345                 468,503                 488,980                 95.8% 982,055                 4,158                      Total Expenditures 11,464,297$          11,365,515$          12,315,255$          92.3% 23,840,475$          (98,782)$                Five Year Trend For the Period Ending June 30, 2019 General Fund ‐ Five Year Trend Village of Oak Brook Revenues Expenditures 6/30/19 6/30/19 6/30/18 6/30/19 YTD % of 2019 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Hotel Tax 553,424$           510,359$           547,000$           93.3% 1,268,000$        (43,065)$            Interest 35,815                57,238                15,000                381.6% 30,000                21,423                Miscellaneous 2,977                  ‐                      ‐                      0.0% ‐                      (2,977)                 Total Operating Revenues 592,216$           567,597$           562,000$           101.0% 1,298,000$        (24,619)$            EXPENDITURES Operation and Contract 201,239$           190,761$           288,920$           66.0% 577,860$           (10,478)$            Capital Outlay 38,166                ‐                      1,212,595          0.0% 4,180,545          (38,166)              Total Expenditures 239,405$           190,761$           1,501,515$        12.7% 4,758,405$        (48,644)$            SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 352,811$           376,836$           (939,515)$          ‐40.1% (3,460,405)$      24,025$             INTERFUND TRANSACTIONS Reimbursements to Other Funds (49,770)$            (51,558)$            (51,540)$            100.0% (103,115)$          (1,788)$              Total Interfund Transactions (49,770)$            (51,558)$            (51,540)$            100.0% (103,115)$          (1,788)$              NET FUND INCREASE (DECREASE)303,041$           325,278$           (991,055)$          (3,563,520)$      22,237$             Note ‐ Expenditures are recorded in program 171. Village of Oak Brook Hotel Tax Fund Financial Update For the Period Ending June 30, 2019 Total Total Revenues Expenditures 6/30/19 Actual  $              567,597 190,761$                6/30/18 Actual  $              592,216 239,405$                % Change From Last Year ‐4.2% ‐20.3% Major Revenues Hotel Tax Interest Miscellaneous 6/30/19 Actual  $              510,359   $                 57,238   $                          ‐    6/30/18 Actual  $              553,424   $                 35,815   $                   2,977  % Change From Last Year ‐7.8% 59.8% ‐100.0% Five Year Trend Major Expenditures Operation & Contractual Capital Outlay 6/30/19 Actual 190,761$                ‐$                        6/30/18 Actual 201,239$                38,166$                  % Change From Last Year ‐5.2% ‐100.0% Five Year Trend Village of Oak Brook Hotel Tax Fund ‐ Major Sources Five Year Trend For the Period Ending June 30, 2019 Five Year Trend Revenues Expenditures 6/30/19 6/30/19 6/30/18 6/30/19 YTD % of 2019 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax 2,805,341$       2,906,481$       2,796,750$       103.9% 5,548,000$       101,140$          Interest 75,010               119,058            42,000               283.5% 80,000               44,048               Miscellaneous 2,729                 ‐                     2,490                 0.0% 5,000                 (2,729)                Total Operating Revenues 2,883,080$       3,025,539$       2,841,240$       106.5% 5,633,000$       142,459$          OPERATING EXPENDITURES Personnel 613,076$          669,593$          666,885$          100.4% 1,322,375$       56,517$            Materials and Supplies 85,359               101,342            105,805            95.8% 246,845            15,983               Operation and Contract 455,149            714,566            844,055            84.7% 1,663,435         259,417            Capital Outlay 28,513               1,164,276         6,428,445         18.1% 10,008,575       1,135,763         Total Operating Expenditures 1,182,097$       2,649,777$       8,045,190$       32.9% 13,241,230$    1,467,680$       SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 1,700,983$       375,762$          (5,203,950)$     ‐7.2% (7,608,230)$     (1,325,221)$     INTERFUND TRANSACTIONS Transfers In 7,790$               216,125$          216,125$          100.0% 1,116,125$       208,335$          Reimbursements From Other Funds 90,564               166,722            166,740            100.0% 333,445            76,158               Reimbursements To Other Funds (82,434)             (80,766)             (80,775)             100.0% (161,535)           1,668                 Total Interfund Transactions 15,920$            302,081$          302,090$          100.0% 1,288,035$       286,161$          NET FUND INCREASE (DECREASE)1,716,903$       677,843$          (4,901,860)$     (6,320,195)$     (1,039,060)$     Village of Oak Brook Infrastructure Fund Financial Update For the Period Ending June 30, 2019 Total Total Revenues Expenditures 6/30/19 Actual  $          3,025,539 2,649,777$            6/30/18 Actual  $          2,883,080 1,182,097$            % Change From Last Year 4.9% 124.2% Major Revenues Sales Tax Grants Interest Miscellaneous 6/30/19 Actual  $          2,906,481   $                         ‐     $              119,058  $                         ‐    6/30/18 Actual  $          2,805,341   $                         ‐     $                75,010  $                  2,729  % Change From Last Year 3.6% 0.0% 58.7% ‐100.0% Five Year Trend Major Expenditures Materials & Operation & Personnel Supplies Contractual Capital Outlay 6/30/19 Actual 669,593$               101,342$               714,566$               1,164,276$            6/30/18 Actual 613,076$               85,359$                 455,149$               28,513$                 % Change From Last Year 9.2% 18.7% 57.0% 3983.3% Five Year Trend Expenditures by Department 6/30/18 6/30/19 6/30/19 6/30/19 2019 Difference Five YTD YTD YTD % of Annual Prior Year Actual Actual Budget Budget Budget Year Trend Legislative & General Management 80,018$                 72,788$                 87,600$                 83.1% 179,485$               (7,230)$                  Public Works 950,972                 1,098,801              5,176,675              21.2% 6,462,865              147,829                 Engineering & Capital Projects 151,107                 1,478,188              2,780,915              53.2% 6,760,415              1,327,081              Total Expenditures 1,182,097$            2,649,777$            8,045,190$            32.9% 13,402,765$          1,467,680$            Five Year Trend Village of Oak Brook Infrastructure Fund ‐ Major Sources Five Year Trend For the Period Ending June 30, 2019 Revenues Expenditures 6/30/19 6/30/19 6/30/18 6/30/19 YTD % of 2019 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax 34,169$            ‐$                   ‐$                   0.0% 100,000$          (34,169)$           Real Estate Tax 186,562            205,855            180,000            114.4% 360,000            19,293               Interest 549                    756                    450                    168.0% 900                    207                    Total Operating Revenues 221,280$          206,611$          180,450$          114.5% 460,900$          (14,669)$           EXPENDITURES Operation and Contract 613$                  3,210$               1,000$               321.0% 4,210$               2,597$               Other Expenditures 223,210            231,130            231,130            100.0% 460,980            7,920                 Total Expenditures 223,823$          234,340$          232,130$          101.0% 465,190$          10,517$            NET FUND INCREASE (DECREASE)(2,543)$             (27,729)$           (51,680)$           (4,290)$             (25,186)$           Note ‐ Expenditures are recorded in program 283. Village of Oak Brook Promenade TIF Fund Financial Update For the Period Ending June 30, 2019 Total Total Revenues Expenditures 6/30/19 Actual  $              206,611 234,340$                6/30/18 Actual  $              221,280 223,823$                % Change From Last Year ‐6.6% 4.7% Major Revenues Real Estate Sales Tax Tax Interest 6/30/19 Actual  $                          ‐     $              205,855   $                      756  6/30/18 Actual  $                 34,169   $              186,562   $                      549  % Change From Last Year ‐100.0% 10.3% 37.7% Five Year Trend Major Expenditures Operation & Other Contractual Expenditures 6/30/19 Actual 3,210$                    231,130$                6/30/18 Actual 613$                        223,210$                % Change From Last Year 423.7% 3.5% Five Year Trend Village of Oak Brook Promenade TIF Fund ‐ Major Sources Five Year Trend For the Period Ending June 30, 2019 Five Year Trend Revenues Expenditures 6/30/19 6/30/19 6/30/18 6/30/19 YTD % of 2019 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Plan Review Fees 600                    750$                  750$                  100.0% 1,500$               150$                  Building/Inspection Fees 5,063                 2,550                 2,490                 102.4% 5,000                 (2,513)                Water Sales 3,711,365         3,885,195         3,879,455         100.1% 10,223,250       173,830            Unmetered Sales 6,995                 7,883                 15,000               52.6% 30,000               888                    Water Connection Fees 109,284            89,010               24,900               357.5% 50,000               (20,274)             Fire Service Charge ‐                     ‐                     2,490                 0.0% 5,000                 ‐                     Meter Charges 6,544                 7,457                 10,010               74.5% 20,000               913                    Special Services 16,394               16,772               15,000               111.8% 30,000               378                    Interest on Investments 43,598               89,477               27,480               325.6% 55,000               45,879               Miscellaneous 42,741               33,846               37,500               90.3% 75,000               (8,895)                Total Operating Revenues 3,942,584$       4,132,940$       4,015,075$       102.9% 10,494,750$    190,356$          EXPENDITURES Personnel 368,711$          374,037$          415,360$          90.1% 828,710$          5,326$               Materials and Supplies 32,321               17,829               43,160               41.3% 76,210               (14,492)             Operation and Contract 2,010,369         1,844,994         2,926,465         63.0% 5,822,285         (165,375)           Capital Outlay 1,318,851         719,986            2,801,120         25.7% 6,244,075         (598,865)           Total Expenditures 3,730,252$       2,956,846$       6,186,105$       47.8% 12,971,280$    (773,406)$         SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 212,332$          1,176,094$       (2,171,030)$     (2,476,530)$     963,762$          INTERFUND TRANSACTIONS Transfers In ‐$                   221,085$          221,085$          100.0% 221,085$          221,085            Reimbursements To Other Funds (202,584)           (275,916)           (275,920)           100.0% (551,830)           (73,332)             Total Interfund Transactions (202,584)$         (54,831)$           (54,835)$           100.0% (330,745)$         147,753$          NET FUND INCREASE (DECREASE)9,748$               1,121,263$       (2,225,865)$     (2,807,275)$     1,111,515$       Village of Oak Brook Water Fund Financial Update For the Period Ending June 30, 2019 Total Total Revenues Expenditures 6/30/19 Actual  $          4,132,940 2,956,846$            6/30/18 Actual  $          3,942,584 3,730,252$            % Change From Last Year 4.8% ‐20.7% Unmetered Water Water Sales Sales Connection Fees Meter Charges Miscellaneous 6/30/19 Actual  $          3,885,195   $                  7,883   $                89,010   $                  7,457   $                33,846  6/30/18 Actual  $          3,711,365   $                  6,995   $              109,284   $                  6,544   $                42,741  % Change From Last Year 4.7% 12.7% ‐18.6% 14.0% ‐20.8% Five Year Trend Materials & Operation & Personnel Supplies Contractual Capital Outlay 6/30/19 Actual 374,037$               17,829$                 1,844,994$            719,986$               6/30/18 Actual 368,711$               32,321$                 2,010,369$            1,318,851$            % Change From Last Year 1.4% ‐44.8% ‐8.2% ‐45.4% Five Year Trend Expenditures by Department 6/30/18 6/30/19 6/30/19 6/30/19 2019 Difference Five YTD YTD YTD % of Annual Prior Year Actual Actual Budget Budget Budget Year Trend Public Works 2,389,412$            2,230,866$            3,670,905$            60.8% 7,299,035$            (158,546)$              Engineering & Capital Projects 1,340,840              725,980                 2,791,120              26.0% 6,224,075              (614,860)                Total Expenditures 3,730,252$            2,956,846$            6,462,025$            45.8% 13,523,110$          (773,406)$              Five Year Trend Village of Oak Brook Water Fund ‐ Major Sources Five Year Trend For the Period Ending June 30, 2019 Revenues Expenditures Village of Oak BrookMonthly Operating StatementSports Core Fund Consolidated PresentationFor the Period Ending June 30, 20196/30/19 6/30/196/30/19 YTD % of 2019 6/30/18 DifferenceB&T Recreation Food & Golf YTD Amended Amended Adopted YTD PriorPrograms Beverage Club Total Budget Budget Budget Total YearDIRECT REVENUESMemberships 217,789$            ‐$                     195,225$            413,014$            452,865$            91.2% 453,815$            428,659$            (15,645)$            Greens Fees ‐                       ‐                        341,013               341,013               359,185               94.9% 930,000               343,727               (2,714)                 Pro Shop Sales ‐                       ‐                        98,865                 98,865                 100,680               98.2% 200,000               105,863               (6,998)                 Golf Lessons ‐                       ‐                        27,885                 27,885                 27,000                 103.3% 40,000                 21,352                 6,533                  Driving Range Fees ‐                       ‐                        153,302               153,302               150,850               101.6% 226,000               138,913               14,389                Rentals ‐                       ‐                        196,439               196,439               226,725               86.6% 459,000               194,931               1,508                  Programs/User Fees 119,444              ‐                        ‐                        119,444               119,430               100.0% 253,450               118,395               1,049                  Food Sales ‐                       69,213                 ‐                        69,213                 67,815                 102.1% 175,500               59,948                 9,265                  Beverage Sales ‐                       102,860               ‐                        102,860               96,390                 106.7% 252,500               92,001                 10,859                Other Revenue 33,604                 104,981               6,336                   144,921               191,980               75.5% 428,300               201,202               (56,281)               Total Direct Revenues370,837$            277,054$            1,019,065$         1,666,956$         1,792,920$         93.0% 3,418,565$         1,704,991$         (38,035)$            DIRECT EXPENDITURESPersonnel 62,859$              116,908$            489,367$            669,134$            705,425$            94.9% 1,572,920$         644,349$            24,785$              Materials & Supplies 13,105                 98,260                 148,899               260,264               336,460               77.4% 580,645               221,103               39,161                Operational & Contractual 411,545              49,861                 149,813               611,219               577,985               105.7% 1,115,975           640,136               (28,917)               Other ‐                       ‐                        ‐                        ‐                        ‐                        N/A (83,150)                33,048                 (33,048)               Capital 74,417                 346,996               228,005               649,418               490,500               132.4% 1,655,900           140,986               508,432              Total Direct Expenditures561,926$            612,025$            1,016,084$         2,190,035$         2,110,370$         103.8% 4,842,290$         1,679,622$         510,413$           Direct Revenues Over (Under) Expenditures(191,089)$           (334,971)$           2,981$                 (523,079)$           (317,450)$           164.8% (1,423,725)$        25,369$               (548,448)$          B&T Administration Overhead Allocation* 65,969$              (65,969)$             ‐$                     ‐$                     ‐$                     0.0% ‐$                     ‐$                     ‐$                    Operating Revenues Over (Under) Expenditures(125,120)$           (400,940)$           2,981$                 (523,079)$           (317,450)$           164.8% (1,423,725)$        25,369$               (548,448)$          Interfund Loan** ‐$                     ‐$                     ‐$                     ‐$                     ‐$                     N/A ‐$                     ‐$                     ‐$                    Transfer From General Fund 32,171                 202,497               ‐                        234,668               281,725               83.3% 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 12,000                 ‐                        ‐                        12,000                 12,000                 100.0% 24,000                 12,000                 ‐                       Reimbursement From Water Fund 4,002                   ‐                        ‐                        4,002                   3,990                   100.3% 8,000                   4,002                   ‐                       Adjusted Operating Revenues Over (Under) Expenditures(76,947)$             (198,443)$           209,322$            (66,068)$             85,265$               ‐$                     41,371$               (107,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 % 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 6/30/19 Actual  $           1,666,956 2,190,035$            6/30/18 Actual  $           1,704,991 1,679,622$            % Change From Last Year ‐2.2% 30.4% Driving Program/ Memberships Greens Fees Range Fees Rentals User Fees 6/30/19 Actual  $              413,014   $              341,013   $              153,302   $              196,439   $              119,444  6/30/18 Actual  $              428,659   $              343,727   $              138,913   $              194,931   $              118,395  % Change From Last Year ‐3.6% ‐0.8% 10.4% 0.8% 0.9% Five Year Trend Materials & Operation & Other Personnel Supplies Contractual Expenditures Capital Outlay 6/30/19 Actual 669,134$                260,264$                611,219$                ‐$                        649,418$                6/30/18 Actual 644,349$                221,103$                640,136$                33,048$                  140,986$                % Change From Last Year 3.8% 17.7% ‐4.5% ‐100.0% 360.6% Five Year Trend Revenues by Department 6/30/18 6/30/19 6/30/19 6/30/19 2019 Difference Five YTD YTD YTD % of Annual Prior Year Actual Actual Budget Budget Budget Year Trend B&T Recreation Programs 471,783$                370,837$                646,495$                57.4% 686,515$                (100,946)$              Food & Beverage 221,196                  277,054                  127,800                  216.8% 663,000                  55,858                    Golf Club 1,012,012               1,019,065               567,997                  179.4% 2,069,050               7,053                      Total Revenues 1,704,991$            1,666,956$            1,342,292$            124.2% 3,418,565$            (38,035)$                Expenditures by Department 6/30/18 6/30/19 6/30/19 % of 2019 Difference Five YTD YTD YTD % of Annual Prior Year Actual Actual Budget Budget Budget Year Trend B&T Recreation Programs 613,268$                561,926$                344,363$                163.2% 1,883,075$            (51,342)$                Food & Beverage 238,119                  612,025                  281,968                  217.1% 1,037,845               373,906                  Golf Club 828,235                  1,016,084               778,751                  130.5% 1,921,370               187,849                  Total Expenditures 1,679,622$            2,190,035$            1,405,082$            155.9% 4,842,290$            510,413$                Five Year Trend Village of Oak Brook Sports Core Fund ‐ Major Sources Five Year Trend For the Period Ending June 30, 2019 Revenues Expenditures Village of Oak BrookMonthly Operating StatementBath & Tennis Club Recreation ProgramsFor the Period Ending June 30, 20196/30/19 6/30/196/30/19 YTD % of 2019 6/30/18 Difference811 812 813 815 816 YTD Amended Amended Adopted YTD PriorB&T Admin Swimming Tennis Polo Open Fields Total Budget Budget Budget Total YearRevenues:Memberships ‐$                    204,339$           13,450$             ‐$                    ‐$                    217,789$           243,865$           89.3% 244,815$           225,459$           (7,670)$             Programs/User Fees ‐                      17,063               25,826               ‐                      76,555               119,444             119,430             100.0% 253,450             118,395             1,049                Other Revenue (318)                    300                     324                     ‐                      33,298               33,604               123,880             27.1% 188,250             127,929             (94,325)             Total Revenue(318)$                 221,702$           39,600$             ‐$                    109,853$           370,837$           487,175$           76.1% 686,515$           471,783$           (100,946)$        Expenditures:Personnel 63,556$             4,270$               (4,967)$              ‐$                    ‐$                    62,859$             87,810$             71.6% 182,405$           67,715$             (4,856)$             Materials & Supplies 392                     12,476               237                     ‐                      ‐                      13,105               20,980               62.5% 26,350               16,044               (2,939)               Operational & Contractual 45,422               250,334             29,293               15,000               71,496               411,545             345,090             119.3% 673,820             447,567             (36,022)             Capital 12,476               57,882               ‐                      ‐                      4,059                 74,417               95,500               77.9% 1,000,500         81,942               (7,525)               Total Expenditures121,846$           324,962$           24,563$             15,000$             75,555$             561,926$           549,380$           102.3% 1,883,075$       613,268$           (51,342)$          Direct Revenues Over (Under) Expenditures(122,164)$         (103,260)$         15,037$             (15,000)$           34,298$             (191,089)$         (62,205)$           307.2% (1,196,560)$      (141,485)$         (49,604)$          B&T Administration Overhead Allocation* 122,164$           (43,979)$           (12,216)$           ‐$                    ‐$                    65,969$             63,705$             103.6% 91,410$             56,337$             9,632$              Revenues Over (Under) Expenditures‐$                    (147,239)$         2,821$               (15,000)$           34,298$             (125,120)$         1,500$               ‐8341.3% (1,105,150)$      (85,148)$           (39,972)$          Interfund Loan** ‐$                    ‐$                    ‐$                    ‐$                    ‐$                    ‐$                    ‐$                    N/A ‐$                    ‐$                    ‐$                   Transfer From General Fund 12,476               19,695               ‐                      ‐                      ‐                      32,171               80,500               40.0% 965,500             ‐                      32,171              Reimbursement From Infrastructure Fund 12,000               ‐                      ‐                      ‐                      ‐                      12,000               12,000               100.0% 24,000               12,000               ‐$                   Reimbursement From Water Fund 4,002                 ‐                      ‐                      ‐                      ‐                      4,002                 3,990                 100.3% 8,000                 4,002                 ‐                     Adjusted Revenues Over (Under) Expenditures28,478$             (127,544)$         2,821$               (15,000)$           34,298$             (76,947)$           97,990$             (107,650)$         (69,146)$           (7,801)$             *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 BrookMonthly Operating StatementSports Core Food & Beverage ProgramsFor the Period Ending June 30, 20196/30/19 6/30/19821 822 823 6/30/19 YTD % of 2019 6/30/18 DifferenceB&T  Poolside Golf YTD Amended Amended Adopted YTD Prior Clubhouse Café Clubhouse Total Budget Budget Budget Total YearRevenues:Food Sales ‐$                    13,379$              55,834$              69,213$              67,815$              102.1% 175,500$           59,948$              9,265$               Beverage Sales ‐                      7,078                  95,782                102,860              96,390                106.7% 252,500              92,001                10,859               Other Revenue 104,981              ‐                      ‐                      104,981              65,000                161.5% 235,000              69,247                35,734               Total Revenue104,981$           20,457$              151,616$           277,054$           229,205$           120.9% 663,000$           221,196$           55,858$             Expenditures:Personnel 62,219$              6,193$                48,496$              116,908$           124,050$           94.2% 286,125$           107,128$           9,780$               Materials & Supplies 3,191                  19,827                75,242                98,260                94,210                104.3% 208,200              75,515                22,745               Operational & Contractual 45,417                25                        4,419                  49,861                82,100                60.7% 153,120              55,476                (5,615)                Capital 346,996              ‐                      ‐                      346,996              200,000              173.5% 390,400              ‐                      346,996             Total Expenditures457,823$           26,045$              128,157$           612,025$           500,360$           122.3% 1,037,845$        238,119$           373,906$          Direct Revenues Over (Under) Expenditures(352,842)$          (5,588)$              23,459$              (334,971)$          (271,155)$          123.5% (374,845)$          (16,923)$            (318,048)$         B&T Administration Overhead Allocation* (61,082)$            (4,887)$              ‐$                    (65,969)$            (63,705)$            103.6% (91,410)$            (56,337)$            (9,632)$             Revenues Over (Under) Expenditures(413,924)$          (10,475)$            23,459$              (400,940)$          (334,860)$          119.7% (466,255)$          (73,260)$            (327,680)$         Transfer From General Fund 202,497$           ‐$                    ‐$                    202,497$           201,225$           100.6% 251,225$           ‐$                    202,497$          Adjusted Revenues Over (Under) Expenditures(211,427)$          (10,475)$            23,459$              (198,443)$          (133,635)$          (215,030)$          (73,260)$            (125,183)$         *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 BrookMonthly Operating StatementGolf Club ProgramsFor the Period Ending June 30, 20196/30/19 6/30/19831 832 833 834 6/30/19 YTD % of 2019 6/30/18 DifferenceGolf General Golf Learning Golf Cart Golf Course YTD Amended Amended Adopted YTD PriorOperation & Practice Operations Maintenance Total Budget Budget BudgetTotal YearRevenues:Memberships 195,225$           ‐$                    ‐$                    ‐$                    195,225$           209,000$           93.4% 209,000$           203,200$           (7,975)$             Greens Fees 341,013             ‐                      ‐                      ‐                      341,013             359,185             94.9% 930,000             343,727             (2,714)               Pro Shop Sales 98,865                ‐                      ‐                      ‐                      98,865                100,680             98.2% 200,000             105,863             (6,998)               Golf Lessons ‐                      27,885                ‐                      ‐                      27,885                27,000                103.3% 40,000                21,352                6,533                 Driving Range Fees ‐                      153,302             ‐                      ‐                      153,302             150,850             101.6% 226,000             138,913             14,389               Rentals 1,290                  75,000                120,149             ‐                      196,439             226,725             86.6% 459,000             194,931             1,508                 Other Revenue 6,336                  ‐                      ‐                      ‐                      6,336                  3,100                  204.4% 5,050                  4,026                  2,310                 Total Revenue642,729$           256,187$           120,149$           ‐$                    1,019,065$        1,076,540$        94.7% 2,069,050$        1,012,012$        7,053$               Expenditures:Personnel 219,106$           9,663$                18,562$             242,036$           489,367$           493,565$           99.1% 1,104,390$        469,506$           19,861$            Materials & Supplies 62,955                10,205                577                     75,162                148,899             221,270             67.3% 346,095             129,544             19,355               Operational & Contractual 102,783             ‐                      25,389                21,641                149,813             150,795             99.3% 289,035             137,093             12,720               Other ‐                      ‐                      ‐                      ‐                      ‐                      ‐                      N/A (83,150)              33,048                (33,048)             Capital 214,470             ‐                      ‐                      13,535                228,005             195,000             116.9% 265,000             59,044                168,961            Total Expenditures599,314$           19,868$             44,528$             352,374$           1,016,084$        1,060,630$        95.8% 1,921,370$        828,235$           187,849$          Direct Revenues Over (Under) Expenditures43,415$             236,319$           75,621$             (352,374)$          2,981$                15,910$             18.7% 147,680$           183,777$           (180,796)$         Transfer from Golf Surcharge 206,341$           ‐$                    ‐$                    ‐$                    206,341$           105,000$           196.5% 175,000$           ‐$                    206,341$          Adjusted Revenues Over (Under) Expenditures249,756$           236,319$           75,621$             (352,374)$          209,322$           120,910$           322,680$           183,777$           25,545$