Loading...
11 - November 2022 Monthly Financial ReportVILLAGE OAK BROOKOF MONTHLY FINANCIAL REPORTS NOVEMBER 2022 Village of Oak Brook Monthly Financial Report – Fund Narrative For the Period Ending November 30, 2022 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. A detailed financial statement and trend information is displayed for all Village major funds. A fund is considered major if it is the primary operating of the Village (General Fund) or meets the following criteria: • Total assets/deferred outflows of resources, liabilities/deferred inflows of resources, revenues, or expenditures/expenses of that individual governmental or enterprise fund are at least 10% of the total for all funds of the same category or type, and • The same element of the individual fun that met the 10% test is at least 5% of the corresponding total for all funds combined. 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 the cash basis of accounting. For the Village’s enterprise funds (Water and Sports Core), a reconciliation is included to display results on a full accrual basis, which is how information is presented in the Village’s annual Comprehensive Annual Financial Report (annual audit). The proceeding pages contain detailed information on the Village’s major funds. Highlights for each of the Village’s funds are: General Fund • Total revenues through November 2022 are $4,589,750, or 18.7%, higher than last November and $6,640,414, or 29.5%, over budget to date. The main drivers for this are: o Sales Tax revenue, the General Fund’s largest revenue source, is up $3,707,077 from last year and $4,486,911 over budget. November 2022 collections were the highest November in the past five years. o Other Intergovernmental Tax revenue is up 734,941 from last year and $1,073,042 over budget. Receipts from Income Tax, Replacement Tax, and Use Tax have been stronger than projected to date. o Telecommunications/Utility Tax revenue is down $168,715 from last year and $39,440 under budget. Telecommunications tax revenue has been trending downwards statewide as more people are switching to data only cellular plans. o Charges for Services revenue is up $395,009 from last year and $715,997 over budget. Amounts can vary from year to year due to the timing of billing requests. o Investment Interest revenue is up $139,738 from last year and $168,078 over budget. $0.25 $0.50 $0.75 $1.00 $1.25 $1.50 2018 2019 2020 2021 2022MillionsSales Tax -November Collections Last 5 Years • Total expenditures through November 2022 are $1,278,297, or 6.7%, higher than last year and $2,619,676, or 11.4%, under budget to date. The main drivers for this are: o Personnel expenditures are up $325,683 from last year, but $1,946,633 under budget. o Operation and contract expenditures are up $722,588 from last year, and $309,804 over budget. This is due in part to costs associated with cybersecurity and vehicle replacements. Hotel Tax Fund • Total revenues through November 2022 are $557,488, or 77.5%, higher than last year and $542,617, or 74.0%, over budget to date. The main drivers for this are: o Hotel tax revenue is up $569,313 from last year and $540,646 over budget. Hotel stay continues to recover from the effects of COVID-19 on the travel industry. • Total expenditures through November 2022 are $253,122, or 137.8%, higher than last year and $171,051, or 64.4%, over budget. Infrastructure Fund • Total revenues through November 2022 are up $2,000,705, or 36.3%, from last year and $1,153,460, or 18.1%, over budget. The main drivers for this are: o Non-home rule sales tax revenue is up $1,397,503 from last year and $1,540,030 over budget. November 2022 collections were the highest November in the past five years. o Investment Interest revenue is up $57,481 from last year and $63,265 over budget. • Total expenditures through November 2022 are up $1,019,800, or 12.5%, from last year, but $2,255,412, or 19.7%, under budget to date. The main drivers for this are: o Personnel expenditures are down $53,372 from last year, and $71,639 under budget. o Operation and contract expenditures are down $312,056 from last year, and $472,712 under budget. o Capital Outlay expenditures are up $1,391,646 from last year, but $1,656,650 under budget. Expenditures are up due to project delays from 2021 and general timing of work performed. Promenade TIF Fund • Total revenues through November 2022 are down $76,358, or 15.6%, from last year and $39,978, or 8.8%, over budget. Sales tax revenues are under budget mainly due to the timing of information needed to record the TIF sale tax transfer between funds. • Total expenditures through November 2022 are down $5,260, or 1.1%, from last year, but $680, or 0.1%, over budget to date. $0 $250 $500 $750 2018 2019 2020 2021 2022ThousandsNon-Home Rule Sales Tax -November Collections Last 5 Years Water Fund • Total revenues through November 2022 are up $817,343, or 7.2%, from last year and $2,317,173, or 23.6%, over budget. The main drivers for this are: o Water sales revenue is up $915,870 from last year and $1,625,329 over budget. o Water connection fees revenue is up $394,220 from last year and $514,300 over budget. o Investment revenue is up $30,283 from last year and $45,555 over budget. • Total expenditures through November 2022 are down $6,006,222, or 53.3%, from last year, and $3,950,739, or 42.9%, under budget. The main drivers for this are: o Personnel expenditures are down $271,519 from last year, and 187,634 under budget. o Capital outlay expenditures are down $5,945,765 from last year, and $3,564,063 under budget. Many capital projects were delayed in 2022 due to labor and supply shortages. Sports Core Fund • Total revenues through November 2022 are up $847,736, or 22.0%, from last year and $649,129, or 16.0%, over budget to date. The main drivers for this are: o Membership revenue is up $451,948 from last year, and $72,879 over budget. o Greens Fees revenue is down $32,080 from last year, and $202,501 under budget. o Driving Range Fees revenue is up $12,787 from last year, and $79,227 over budget. o Rentals revenue is up $242,995 from last year, and $132,342 over budget. This is due in part to soccer field rental agreement and increase in golf cart rentals. o Food sales are up $37,583 from last year, and $53,135 over budget. o Beverage sales are up $9,638 from last year, and $49,892 over budget. • Total expenditures through November 2022 are up $230,064, or 7.1%, from last year, but $19,429, or 0.56%, under budget to date. The main drivers for this are: o Personnel expenditures are up $14,799 from last year, but $162,990 under budget. o Operation and contractual expenditures are up $412,064 from last year, and $76,261 over budget. Expenditures are up due to agreement with Chicagoland Pool Management. o Capital outlay expenditures are down $294,908 from last year, and $52,265 under budget. YTD YTD Net Fund Budgeted YTD YTD Increase Increase Governmental Funds Revenues Expenditures (Decrease)(Decrease) General Fund (Major Fund)29,688,442$ 20,431,400$ 9,257,043$ (3,047)$ Main operating fund of the Village. Hotel Fund (Major Fund)1,276,409$ 512,770$ 763,639$ 214,812$ Collects and spends resources from the 3% hotel/motel tax. Motor Fuel Tax Fund 481,136$ -$ 481,136$ 211,550$ Collects and spends resources from the State motor fuel tax. Infrastructure Fund (Major Fund)7,805,349$ 9,289,146$ (1,483,797)$ (4,504,587)$ Accounts for construction and maintenance of roadways, drainage, and safety path systems. Promenade TIF Fund (Major Fund)413,818$ 490,835$ (77,017)$ 4,487$ 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)12,139,715$ 5,640,699$ 6,499,015$ 231,105$ Collects user fees for the distribution of water and maintenance of infrastructure. Sports Core Fund (Major Fund)4,700,819$ 3,532,888$ 1,167,931$ 636,877$ Accounts for revenues and expenses relating to administration, programs, food and beverage operations, and golf course. Golf Surcharge Fund 145,166$ -$ 145,166$ (25,500)$ Accounts for the collection of the $3 per round golf surcharge. Internal Service Funds Self Insurance Fund 3,365,545$ 2,843,373$ 522,172$ 190,720$ Accounts for the Village's health insurance costs and the related contributions from the Village, employees, retirees, and other agencies. Garage Fund 573,150$ 611,146$ (37,996)$ (77,625)$ Accounts for the maintenance of the Village's vehicle fleet and the related departmental reimbursements. Equipment Replacement Fund 763,294$ 704,303$ 58,991$ 15,045$ Accounts for the replacement of the Village's vehicle fleet and the related departmental contributions. Further information on the Village's major funds (as indicated above) can be found on the proceeding pages. Executive Summary on Village Funds Through November 30, 2022 11/30/22 11/30/22 11/30/21 11/30/22 YTD % of YTD 2022 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax 12,879,834$ 16,586,911 12,100,000$ 137.1%13,200,000$ 3,707,077$ Other Intergovernmental Tax*1,821,634 2,556,575 1,483,533 172.3%1,618,400 734,941 Telecommunications/Utility Tax 5,258,025 5,089,310 5,128,750 99.2%5,595,000 (168,715) Grants 42,371 25,152 13,750 182.9%15,000 (17,219) Licenses and Permits 2,371,345 2,194,760 1,840,218 119.3%2,007,510 (176,585) Charges for Services 1,379,646 1,774,655 1,058,658 167.6%1,154,900 395,009 Fines and Penalties 131,563 100,628 130,167 77.3%142,000 (30,935) Administrative Towing Fees 24,391 42,500 22,917 185.5%25,000 18,109 Investment Interest 160,340 300,078 132,000 227.3%144,000 139,738 Franchise Fees 159,960 223,852 181,500 123.3%198,000 63,892 Installment Contract Proceeds - N/A - Miscellaneous Income 351,461 275,899 438,414 62.9%478,270 (75,562) Total Operating Revenues 24,580,570$ 29,170,320$ 22,529,907$ 129.5%24,578,080$ 4,589,750$ OPERATING EXPENDITURES Personnel 15,573,578$ 15,899,261$ 17,845,895$ 89.1%19,468,249$ 325,683$ Materials and Supplies 378,671 449,214 524,833 85.6%572,545 70,543$ Operation and Contract 2,873,209 3,595,797 3,285,993 109.4%3,584,720 722,588$ Other Expenditures 8,599 6,437 108,973 5.9%118,880 (2,162)$ Capital Outlay 218,319 379,963 1,184,654 32.1%1,292,350 161,644$ Total Operating Expenditures 19,052,376$ 20,330,673$ 22,950,348$ 88.6%25,036,744$ 1,278,297$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 5,528,194$ 8,839,648$ (420,442)$ -2102.5%(458,664)$ 3,311,454$ INTERFUND TRANSACTIONS Transfers In -$ -$ -$ N/A -$ -$ Transfers Out - N/A - Reimbursements From Other Funds 544,203 518,122 518,118 100.0%565,220 (26,081) Reimbursements To Other Funds (97,064) (100,727) (100,723) 100.0%(109,880) (3,663) Sports Core Loan - N/A - - Total Interfund Transactions 447,139$ 417,395$ 417,395$ 100.0%455,340$ (29,744)$ NET FUND INCREASE (DECREASE)5,975,333$ 9,257,043$ (3,047)$ (3,324)$ 3,281,710$ *Includes the collection of Income Tax, Use Tax, Road & Bridge Tax, Personal Property Replacement Tax, and Cannabis Use Tax. Village of Oak Brook General Fund Financial Update For the Period Ending November 30, 2022 Total Total Revenues Expenditures 11/30/22 Actual 29,170,320$ 20,330,673$ 11/30/21 Actual 24,580,570$ 19,052,376$ % Change From Last Year 18.7%6.7% Major Revenues Other Telecom/Utility Licenses &Charges for Sales Tax Intergov. Tax Tax Permits Services 11/30/22 Actual 16,586,911$ 2,556,575$ 5,089,310$ 2,194,760$ 1,774,655$ 11/30/21 Actual $ 12,879,834 $ 1,821,634 $ 5,258,025 $ 2,371,345 $ 1,379,646 % Change From Last Year 28.8%40.3%-3.2%-7.4%28.6% Five Year Trend Major Expenditures Materials &Operation &Other Personnel Supplies Contractual Expenditures Capital Outlay 11/30/22 Actual 15,899,261$ 449,214$ 3,595,797$ 6,437$ 379,963$ 11/30/21 Actual 15,573,578$ 378,671$ 2,873,209$ 8,599$ 218,319$ % Change From Last Year 2.1%18.6%25.1%-25.1%74.0% Five Year Trend Expenditures by Department 11/30/21 11/30/22 11/30/22 11/30/22 2022 Difference Five YTD YTD YTD % of Annual Prior Year Department Actual Actual Budget Budget Budget Year Trend Legislative & General Management 2,123,970$ 2,705,977$ 2,752,273$ 98.3%3,002,480$ 582,007$ Financial Services 691,170 724,522 758,111 95.6%827,030 33,352 Public Works 718,961 766,797 851,368 90.1%928,765 47,836 Engineering & Capital Projects 22,671 13,418 352,000 3.8%384,000 (9,253) Library 810,260 879,249 913,133 96.3%996,145 68,989 Police 7,595,733 8,044,295 9,046,680 88.9%9,869,105 448,562 Fire 6,234,412 6,363,215 7,261,870 87.6%7,922,040 128,803 Development Services 855,199 811,554 1,003,095 80.9%1,094,285 (43,645) Total Expenditures 19,052,376$ 20,330,673$ 22,950,348$ 88.6%25,036,744$ 1,256,651$ Five Year Trend For the Period Ending November 30, 2022 General Fund - Five Year Trend Village of Oak Brook 10,000,000 30,000,000 50,000,000 Revenues Expenditures 11/30/22 11/30/22 11/30/21 11/30/22 YTD % of YTD 2022 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Hotel Tax 680,375$ 1,249,688$ 709,042$ 176.3%773,500$ 569,313$ Investment Interest 29,274 20,721 19,250 107.6%21,000 (8,553) Loan Interest 8,000 6,000 5,500 109.1%6,000 (2,000) Miscellaneous 1,272 (1,272) Total Operating Revenues 718,921$ 1,276,409$ 733,792$ 173.9%800,500$ 557,488$ EXPENDITURES Operation and Contract 178,533$ 384,175$ 265,820$ 144.5%289,985$ 205,642$ Capital Outlay 5,215 52,696 - N/A - 47,481 Total Expenditures 183,748$ 436,870$ 265,820$ 164.3%289,985$ 253,122$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 535,173$ 839,539$ 467,972$ 179.4%510,515$ 304,366$ INTERFUND TRANSACTIONS Transfer Out (2,714,068)$ -$ (177,260)$ 0.0%(193,375)$ 2,714,068$ Reimbursements to Other Funds (77,077) (75,900) (75,900) 100.0%(82,800) 1,177 Total Interfund Transactions (2,791,145)$ (75,900)$ (253,160)$ 30.0%(276,175)$ 2,715,245$ NET FUND INCREASE (DECREASE)(2,255,972)$ 763,639$ 214,812$ 234,340$ 3,019,611$ Note - Expenditures are recorded in program 171. Village of Oak Brook Hotel Tax Fund Financial Update For the Period Ending November 30, 2022 Total Total Revenues Expenditures 11/30/22 Actual $ 1,276,409 436,870$ 11/30/21 Actual $ 718,921 183,748$ % Change From Last Year 77.5%137.8% Major Revenues Investment Hotel Tax Interest Loan Interest Miscellaneous 11/30/22 Actual $ 1,249,688 $ 20,721 6,000$ -$ 11/30/21 Actual $ 680,375 $ 29,274 8,000$ 1,272$ % Change From Last Year 83.7%-29.2%0.0%0.0% Five Year Trend Major Expenditures Operation & Contractual Capital Outlay 11/30/22 Actual 384,175$ 52,696$ 11/30/21 Actual 178,533$ 5,215$ % Change From Last Year 115.2%N/A Five Year Trend Village of Oak Brook Hotel Tax Fund - Major Sources Five Year Trend For the Period Ending November 30, 2022 Five Year Trend Revenues Expenditures 11/30/22 11/30/22 11/30/21 11/30/22 YTD % of YTD 2022 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Non-Home Rule Sales Tax 5,472,944$ 6,870,447$ 5,330,417$ 128.9%5,815,000$ 1,397,503$ Charges for Services - - N/A -$ Investment Interest 30,993 88,474 25,208 351.0%27,500 57,481 Grants - 550,000 998,919 55.1%1,089,730 550,000 Miscellaneous 4,279 - 917 0.0%1,000 (4,279) Total Operating Revenues 5,508,216$ 7,508,921$ 6,355,461$ 118.1%6,933,230$ 2,000,705$ OPERATING EXPENDITURES Personnel 1,166,832$ 1,113,460$ 1,185,099$ 94.0%1,292,835$ (53,372)$ Materials and Supplies 159,724 153,306 207,717 73.8%226,600 (6,418) Operation and Contract 1,425,342 1,113,286 1,585,998 70.2%1,730,180 (312,056) Other Expenditures - N/A - Capital Outlay 5,409,164 6,800,810 8,457,460 80.4%9,226,320 1,391,646 Total Operating Expenditures 8,161,062$ 9,180,862$ 11,436,274$ 80.3%12,475,935$ 1,019,800$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES (2,652,846)$ (1,671,941)$ (5,080,813)$ 32.9%(5,542,705)$ 980,905$ INTERFUND TRANSACTIONS Transfers In 2,714,068$ -$ 388,094$ 0.0%423,375$ (2,714,068)$ Reimbursements From Other Funds 304,194 296,428 296,418 100.0%323,365 (7,766) Reimbursements To Other Funds (161,612) (108,284) (108,286) 100.0%(118,130) 53,328 Total Interfund Transactions 2,856,650$ 188,144$ 576,226$ 32.7%628,610$ (2,668,506)$ NET FUND INCREASE (DECREASE)203,804$ (1,483,797)$ (4,504,587)$ (4,914,095)$ (1,687,601)$ Village of Oak Brook Infrastructure Fund Financial Update For the Period Ending November 30, 2022 Total Total Revenues Expenditures 11/30/22 Actual $ 7,508,921 9,180,862$ 11/30/21 Actual $ 5,508,216 8,161,062$ % Change From Last Year 36.3%12.5% Major Revenues Sales Tax Charges for Services Investment Interest Miscellaneous 11/30/22 Actual $ 6,870,447 $ - $ 88,474 $ - 11/30/21 Actual $ 5,472,944 $ - $ 30,993 $ - % Change From Last Year 25.5%0.0%185.5%0.0% Five Year Trend Major Expenditures Materials &Operation & Personnel Supplies Contractual Capital Outlay 11/30/22 Actual 1,113,460$ 153,306$ 1,113,286$ 6,800,810$ 11/30/21 Actual 1,166,832$ 159,724$ 1,425,342$ 5,409,164$ % Change From Last Year -4.6%-4.0%-21.9%25.7% Five Year Trend Expenditures by Department 11/30/21 11/30/22 11/30/22 11/30/22 2022 Difference Five YTD YTD YTD % of Annual Prior Year Actual Actual Budget Budget Budget Year Trend Legislative & General Management 147,483$ 180,545$ 192,051$ 94.0%209,510$ 33,062$ Public Works 2,199,524 1,960,037 2,181,845 89.8%2,380,195 (239,487) Engineering & Capital Projects 5,814,055 7,040,280 9,062,378 77.7%9,886,230 1,226,225 Total Expenditures 8,161,062$ 9,180,862$ 11,436,274$ 80.3%12,475,935$ 1,019,800$ Five Year Trend Village of Oak Brook Infrastructure Fund - Major Sources Five Year Trend For the Period Ending November 30, 2022 Revenues Expenditures 11/30/22 11/30/22 11/30/21 11/30/22 YTD % of YTD 2022 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax 81,673$ -$ 82,500$ 0.0%90,000$ (81,673)$ Real Estate Tax 408,456 411,881 371,250 110.9%405,000 3,425 Investment Interest 47 1,937 46 4225.7%50 1,890 Total Operating Revenues 490,176$ 413,818$ 453,796$ 91.2%495,050$ (76,358)$ EXPENDITURES Operation and Contract 4,075$ 4,575$ 3,575$ 128.0%3,900$ 500$ Other Expenditures 481,500 486,260 445,734 109.1%486,255 4,760 Total Expenditures 485,575$ 490,835$ 449,309$ 109.2%490,155$ 5,260$ NET FUND INCREASE (DECREASE)4,601$ (77,017)$ 4,487$ 4,895$ (81,618)$ Note - Expenditures are recorded in program 283. Village of Oak Brook Promenade TIF Fund Financial Update For the Period Ending November 30, 2022 Total Total Revenues Expenditures 11/30/22 Actual $ 413,818 490,835$ 11/30/21 Actual $ 490,176 485,575$ % Change From Last Year -15.6%1.1% Major Revenues Real Estate Investment Sales Tax Tax Interest 11/30/22 Actual -$ $ 411,881 $ 1,937 11/30/21 Actual 81,673$ $ 408,456 $ 47 % Change From Last Year -100.0%0.0%4020.8% Five Year Trend Major Expenditures Operation &Other Contractual Expenditures 11/30/22 Actual 4,575$ 486,260$ 11/30/21 Actual 4,075$ 481,500$ % Change From Last Year 0.0%1.0% Five Year Trend Village of Oak Brook Promenade TIF Fund - Major Sources Five Year Trend For the Period Ending November 30, 2022 Five Year Trend Revenues Expenditures 11/30/22 11/30/22 11/30/21 11/30/22 YTD % of YTD 2022 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Plan Review Fees 525$ 600$ 917$ 65.5%1,000$ 75$ Building/Inspection Fees 3,000 2,025 4,583 44.2%5,000 (975) Water Sales 10,320,250 11,236,120 9,610,792 116.9%10,484,500 915,870 Unmetered Sales 44,602 93,243 45,833 203.4%50,000 48,641 Water Connection Fees 188,830 583,050 68,750 848.1%75,000 394,220 Fire Service Charge - - N/A - Meter Charges 7,826 23,739 13,750 172.6%15,000 15,913 Special Services 25,326 13,389 22,917 58.4%25,000 (11,937) Investment Interest 42,772 73,055 27,500 265.7%30,000 30,283 Miscellaneous 689,241 114,494 27,500 416.3%30,000 (574,747) Total Operating Revenues 11,322,372$ 12,139,715$ 9,822,542$ 123.6%10,715,500$ 817,343$ OPERATING EXPENDITURES Personnel 677,537$ 406,018$ 593,652$ 68.4%647,620$ (271,519)$ Materials and Supplies 121,457 72,971 63,846 114.3%69,650 (48,486) Operation and Contract 4,482,817 4,742,365 4,950,573 95.8%5,400,625 259,548 Capital Outlay 5,979,659 33,894 3,597,917 0.9%3,925,000 (5,945,765) Total Expenditures 11,261,470$ 5,255,248$ 9,205,987$ 57.1%10,042,895$ (6,006,222)$ Surplus (Deficit) of Revenues Over Expenditures 5,515$ 6,884,466$ 616,555$ 1116.6%672,605$ 6,823,564$ INTERFUND TRANSACTIONS Reimbursements To Other Funds (412,962)$ (385,451)$ (385,449)$ 100.0%(420,490)$ 27,511$ Total Interfund Transactions (412,962)$ (385,451)$ (385,449)$ 100.0%(420,490)$ 27,511$ Fund Increase/(Decrease) - Budgetary Basis (407,447)$ 6,499,015$ 231,105$ 252,115$ 6,851,075$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay 5,979,659$ 33,894$ Depreciation Expense (527,083) (527,083) IMRF Pension Expense (41,250) (41,250) OPEB Expense (27,500) (27,500) Total GAAP Adjustments 5,383,826$ (561,939)$ Fund Increase/(Decrease) - GAAP Basis 4,976,379$ 5,937,076$ *Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year. Village of Oak Brook Water Fund Financial Update For the Period Ending November 30, 2022 Total Total Revenues Expenditures 11/30/22 Actual $ 12,139,715 5,255,248$ 11/30/21 Actual $ 11,322,372 11,261,470$ % Change From Last Year 7.2%-53.3% Unmetered Water Water Sales Sales Connection Fees Meter Charges Miscellaneous 11/30/22 Actual $ 11,236,120 $ 93,243 $ 583,050 $ 23,739 $ 114,494 11/30/21 Actual $ 10,320,250 $ 44,602 $ 188,830 $ 7,826 $ 689,241 % Change From Last Year 8.9%109.1%208.8%203.3%-83.4% Five Year Trend Materials &Operation &Other Personnel Supplies Contractual Expenditures Capital Outlay 11/30/22 Actual 406,018$ 72,971$ 4,742,365$ -$ 33,894$ 11/30/21 Actual 677,537$ 121,457$ 4,482,817$ -$ 5,979,659$ % Change From Last Year -40.1%-39.9%5.8%0.0%-99.4% Five Year Trend Expenditures by Department 11/30/21 11/30/22 11/30/22 11/30/22 2022 Difference Five YTD YTD YTD % of Annual Prior Year Actual Actual Budget Budget Budget Year Trend Public Works 5,216,717$ 5,221,354$ 5,608,070$ 93.0%6,117,895$ (4,637)$ Engineering & Capital Projects 6,044,753 33,894 3,597,917 0.0%3,925,000 6,010,859 Total Expenditures 11,261,470$ 5,255,248$ 9,205,987$ 57.1%10,042,895$ 6,006,222$ Five Year Trend Village of Oak Brook Water Fund - Major Sources Five Year Trend For the Period Ending November 30, 2022 Revenues Expenditures Village of Oak Brook Monthly Operating Statement Sports Core Fund Consolidated Presentation For the Period Ending November 30, 2022 11/30/22 11/30/22 11/30/22 YTD % of YTD 2022 11/30/21 Difference B&T Recreation Field Clubhouse Golf YTD Amended Amended Adopted YTD Prior Operations Operations Operations Club Total Budget Budget Budget Total Year OPERATING REVENUES Memberships 402,838$ -$ -$ 404,975$ 807,813$ 734,938$ 109.9%801,750$ 355,865$ 451,948$ Greens Fees - - - 1,252,085 1,252,085 1,049,583 119.3%1,145,000 1,284,165 (32,080) Pro Shop Sales - - - 222,490 222,490 192,500 115.6%210,000 232,554 (10,064) Golf Lessons - - - 35,815 35,815 45,833 78.1%50,000 50,140 (14,325) Driving Range Fees - - - 354,227 354,227 275,000 128.8%300,000 341,440 12,787 Rentals - 239,143 348,592 455,567 1,043,302 910,960 114.5%993,775 800,307 242,995 Programs/User Fees 83,836 - - - 83,836 14,208 590.0%15,500 - 83,836 Food Sales 44,287 - - 271,015 315,302 262,167 120.3%286,000 277,719 37,583 Beverage Sales 17,712 - - 481,347 499,059 449,167 111.1%490,000 489,421 9,638 Taste of Oak Brook - 66,812 - - 66,812 110,000 60.7%120,000 - 66,812 Grants - - - - - - N/A - - - Other Revenue 2,989 - - 17,090 20,078 7,333 273.8%8,000 21,472 (1,394) Total Operating Revenues 551,661$ 305,955$ 348,592$ 3,494,610$ 4,700,819$ 4,051,690$ 116.0%4,420,025$ 3,853,083$ 847,736$ OPERATING EXPENDITURES Personnel 67,599$ -$ 117,319$ 1,184,190$ 1,369,109$ 1,532,098$ 89.4%1,671,380$ 1,354,310$ 14,799$ Materials & Supplies 69,540 - 10,452 698,567 778,559 658,992 118.1%718,900 680,451 98,108 Operational & Contractual 309,199 222,813 72,597 335,854 940,462 864,201 108.8%942,765 528,398 412,064 Other - - - - - - N/A - - - Capital 244,355 - - 131,234 375,589 427,854 87.8%466,750 670,497 (294,908) Total Operating Expenditures 690,693$ 222,813$ 200,368$ 2,349,845$ 3,463,720$ 3,483,145$ 99.4%3,799,795$ 3,233,656$ 230,064$ B&T Administration Overhead Allocation*32,738$ -$ (32,738)$ -$ -$ -$ N/A -$ -$ -$ Operating Revenues Over (Under) Expenditures (106,294)$ 83,142$ 115,486$ 1,144,765$ 1,237,099$ 568,544$ 217.6%620,230$ 619,427$ 617,672$ INTERFUND TRANSACTIONS Interfund Loan**-$ -$ -$ -$ -$ -$ N/A -$ -$ -$ Transfer From General Fund - - - - - - N/A - - - Transfer From Golf Surcharge Fund - - - - - 137,500 0.0%150,000 - - Reimbursement From Infrastructure Fund - - - - - - N/A - 29,337 (29,337) Reimbursement From Water Fund - - - - - - N/A - 7,337 (7,337) Reimbursement To General Fund (17,292) - - (51,876) (69,168) (69,167) 100.0%(75,455) (57,651) (11,517) Total Interfund Transactions (17,292)$ -$ -$ (51,876)$ (69,168)$ 68,333$ -101.2%74,545$ (20,977)$ (48,191)$ Total Revenues Over (Under) Expenditures - Budgetary Basis (123,586)$ 83,142$ 115,486$ 1,092,889$ 1,167,931$ 636,877$ 694,775$ 598,450$ 569,481$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay 244,355$ -$ -$ 131,234$ 375,589$ 670,497$ Depreciation Expense (154,208) (1,545) (25,000) (225,775) (406,528) (436,528) IMRF Pension Expense (1,879) - (1,250) (22,458) (25,588) (27,088) OPEB Expense - - (1,250) (25,667) (26,917) (28,417) Total GAAP Adjustments 88,268$ (1,545)$ (27,500)$ (142,666)$ (83,443)$ 178,465$ Fund Increase/(Decrease) - GAAP Basis (35,318)$ 81,597$ 87,986$ 950,223$ 1,084,488$ 776,915$ *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. **Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year. Total Direct Total Direct Revenues Expenditures 11/30/22 Actual $ 4,700,819 3,463,720$ 11/30/21 Actual $ 3,853,083 3,233,656$ % Change From Last Year 22.0%7.1% Driving Program/ Memberships Greens Fees Range Fees Rentals User Fees 11/30/22 Actual $ 807,813 $ 1,252,085 $ 354,227 $ 1,043,302 83,836$ 11/30/21 Actual $ 355,865 $ 1,284,165 $ 341,440 $ 800,307 -$ % Change From Last Year 127.0%-2.5%N/A 30.4%0.0% Five Year Trend Materials &Operation &Other Personnel Supplies Contractual Expenditures Capital Outlay 11/30/22 Actual 1,369,109$ 778,559$ 940,462$ -$ 375,589$ 11/30/21 Actual 1,354,310$ 680,451$ 528,398$ -$ 670,497$ % Change From Last Year 1.1%14.4%78.0%0.0%-44.0% Five Year Trend Revenues by Department 11/30/21 11/30/22 11/30/22 11/30/22 2022 Difference Five YTD YTD YTD % of Annual Prior Year Actual Actual Budget Budget Budget Year Trend B&T Recreation Operations 8,699$ 551,661$ 477,996$ 115.4%521,450$ 480,964$ Open Field Operations 108,000 305,955 343,750 89.0%375,000 131,143 B&T Clubhouse Operations 198,883 348,592 322,002 108.3%351,275 149,709 Golf Club 3,537,501 3,494,610 2,907,942 120.2%3,172,300 (42,891) Total Revenues 3,853,083$ 4,700,819$ 4,051,690$ 116.0%4,420,025$ 718,925$ Expenditures by Department 11/30/21 11/30/22 11/30/22 % of YTD 2022 Difference Five YTD YTD YTD % of Annual Prior Year Actual Actual Budget Budget Budget Year Trend B&T Recreation Operations 434,565$ 690,693$ 519,915$ 132.8%567,180$ 256,128$ Open Field Operations 242,020$ 222,813$ 229,772$ 97.0%250,660$ (19,207)$ B&T Clubhouse Operations 192,775 200,368 273,350 73.3%298,200 7,593 Golf Club 2,364,296 2,349,845 2,460,109 95.5%2,683,755 (14,451) Total Expenditures 3,233,656$ 3,463,720$ 3,483,145$ 99.4%3,799,795$ 230,064$ Five Year Trend Village of Oak Brook Sports Core Fund - Major Sources Five Year Trend For the Period Ending November 30, 2022 Revenues Expenditures Village of Oak Brook Monthly Operating Statement Bath & Tennis Club Recreation Operations For the Period Ending November 30, 2022 11/30/22 11/30/22 822 11/30/22 YTD % of YTD 2022 11/30/21 Difference 811 812 813 Poolside YTD Amended Amended Adopted YTD Prior B&T Admin Swimming Tennis Café Total Budget Budget Budget Total Year OPERATING REVENUES Memberships -$ 377,263$ 25,575 - 402,838$ 411,538$ 97.9%448,950$ -$ 402,838$ Programs/User Fees (874) 42,109 42,601 - 83,836 14,208.33 590.0%15,500 - 83,836 Food Sales - - - 44,287 44,287 33,000.00 134.2%36,000 - - Beverage Sales - - - 17,712 17,712 18,333.33 96.6%20,000 - - Grants - - - - - - N/A - - - Other Revenue 2,989 - - - 2,989 917 326.0%1,000 8,699 (5,710) Total Operating Revenues 2,114$ 419,372$ 68,176$ 61,998$ 551,661$ 477,996$ 115.4%521,450$ 8,699$ 480,964$ OPERATING EXPENDITURES Personnel 16,606$ 14,714$ -$ 36,280$ 67,599$ 116,738$ 57.9%127,350$ 16,251$ 51,348$ Materials & Supplies 691 29,588 6,574 32,687 69,540 68,338 101.8%74,550 32,675 36,865 Operational & Contractual 36,760 204,979 59,136 8,324 309,199 281,903 109.7%307,530 99,117 210,082 Other - - - - N/A - - Capital - 243,605 750 - 244,355 52,938 461.6%57,750 286,522 (42,167) Total Operating Expenditures 54,056$ 492,886$ 66,460$ 77,291$ 690,693$ 519,915$ 132.8%567,180$ 434,565$ 256,128$ B&T Administration Overhead Allocation*65,477$ (23,572)$ (6,548)$ (2,619)$ 32,738$ -$ N/A 68,810$ 126,182$ (93,444)$ Operating Revenues Over (Under) Expenditures 13,535$ (97,085)$ (4,832)$ (17,911)$ (106,294)$ (41,919)$ 253.6%23,080$ (299,684)$ 131,392$ Transfer From General Fund - - - - - - N/A - - Reimbursement From Infrastructure Fund - - - - - -$ N/A - 29,337 (29,337) Reimbursement From Water Fund - - - - - - N/A - 7,337 (7,337) Reimbursement To General Fund (17,292) - - - (17,292) (17,293) 100.0%(18,865) (14,410) (2,882) Total Interfund Transactions (17,292)$ -$ -$ -$ (17,292)$ (17,293)$ 100.0%(18,865)$ 22,264$ (39,556)$ Total Revenues Over (Under) Expenditures - Budgetary Basis (3,757)$ (97,085)$ (4,832)$ (17,911)$ (123,586)$ (59,212)$ 4,215$ (277,420)$ 91,836$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ 243,605$ 750$ -$ 244,355$ 286,522$ Depreciation Expense (58,996) (91,667) (2,475) (1,071) (154,208) (154,208) IMRF Pension Expense (1,833) - - (46) (1,879) (1,879) Total GAAP Adjustments (60,829)$ 151,938$ (1,725)$ (1,117)$ 88,268$ 130,435$ Fund Increase/(Decrease) - GAAP Basis (64,586)$ 54,853$ (6,557)$ (19,028)$ (35,318)$ (146,985)$ *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. **Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year. Village of Oak Brook Monthly Operating Statement Open Fields Operations For the Period Ending November 30, 2022 11/30/22 11/30/22 11/30/22 YTD % of YTD 2022 11/30/21 Difference 815 816 YTD Amended Amended Adopted YTD Prior Polo Open Fields Total Budget Budget Budget Total Year OPERATING REVENUES Field Rentals -$ 159,143$ 159,143$ 155,833$ 102.1%170,000$ 28,000$ 131,143$ Range Rentals - 80,000 80,000 77,917 102.7%85,000 80,000 - Taste of Oak Brook - 66,812 66,812 110,000 60.7%120,000 - - Other Revenue - - - N/A - - - Total Operating Revenues -$ 305,955$ 305,955$ 343,750$ 89.0%375,000$ 108,000$ 131,143$ OPERATING EXPENDITURES Personnel -$ -$ -$ -$ N/A -$ -$ Materials & Supplies - - - 1,375 0.0%1,500$ - - Operational & Contractual 199 222,614 222,813 228,397 97.6%249,160 9,345 213,468 Capital - - - N/A 232,675 (232,675) Total Operating Expenditures 199$ 222,614$ 222,813$ 229,772$ 97.0%250,660$ 242,020$ (19,207)$ Operating Revenues Over (Under) Expenditures (199)$ 83,341$ 83,142$ 113,978$ 72.9%124,340$ (134,020)$ 150,350$ INTERFUND TRANSACTIONS Transfer From Hotel Tax Fund -$ -$ -$ -$ N/A -$ -$ -$ Total Interfund Transactions -$ -$ -$ -$ N/A -$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis (199)$ 83,341$ 83,142$ 113,978$ 124,340$ (134,020)$ 150,350$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ -$ -$ 232,675$ Depreciation Expense - (1,545) (1,545) (1,545) Total GAAP Adjustments -$ (1,545)$ (1,545)$ 231,130$ Fund Increase/(Decrease) - GAAP Basis (199)$ 81,796$ 81,597$ 97,110$ *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. **Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year. Village of Oak Brook Monthly Operating Statement Bath & Tennis Clubhouse Operations For the Period Ending November 30, 2022 11/30/22 11/30/22 821 YTD % of YTD 2022 11/30/21 Difference B&T Amended Amended Adopted YTD Prior Clubhouse Budget Budget Budget Total Year OPERATING REVENUES Rentals 348,592$ 322,002$ 108.3%351,275$ 198,883$ 149,709$ Total Operating Revenues 348,592$ 322,002$ 108.3%351,275$ 198,883$ 149,709$ OPERATING EXPENDITURES Personnel 117,319$ 128,563$ 91.3%140,250$ 112,577$ 4,742$ Materials & Supplies 10,452 14,071 74.3%15,350 6,741 3,711 Operational & Contractual 72,597 84,883 85.5%92,600 69,075 3,522 Capital - 45,833 0.0%50,000 4,382 (4,382) Total Operating Expenditures 200,368$ 273,350$ 73.3%298,200$ 192,775$ 7,593$ B&T Administration Overhead Allocation*(32,738)$ -$ N/A (68,810)$ (126,182)$ 93,444$ Operating Revenues Over (Under) Expenditures 115,486$ 48,652$ 237.4%(15,735)$ (120,074)$ 235,560$ INTERFUND TRANSACTIONS Transfer From General Fund -$ -$ 0.0%-$ -$ -$ Total Interfund Transactions -$ -$ 0.0%-$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis 115,486$ 48,652$ (15,735)$ (120,074)$ 235,560$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ 4,382$ Depreciation Expense (25,000) (55,000) IMRF Pension Expense (1,250) (2,750) OPEB Expense (1,250) (2,750) Total GAAP Adjustments (27,500)$ (56,118)$ Fund Increase/(Decrease) - GAAP Basis 87,986$ (176,192)$ *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. **Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year. Village of Oak Brook Monthly Operating Statement Golf Club Programs For the Period Ending November 30, 2022 11/30/22 11/30/22 823 831 832 833 834 11/30/22 YTD % of YTD 2022 11/30/21 Difference Golf Golf General Golf Learning Golf Cart Golf Course YTD Amended Amended Adopted YTD Prior Café Operation & Practice Operations Maintenance Total Budget Budget Budget Total Year OPERATING REVENUES Memberships -$ 404,975$ -$ -$ -$ 404,975$ 323,400$ 125.2%352,800$ 355,865$ 49,110$ Greens Fees - 1,252,085 - - - 1,252,085 1,049,583 119.3%1,145,000 1,284,165 (32,080) Pro Shop Sales - 222,490 - - - 222,490 192,500 115.6%210,000 232,554 (10,064) Golf Lessons - - 35,815 - - 35,815 45,833 78.1%50,000 50,140 (14,325) Driving Range Fees - - 354,227 - - 354,227 275,000 128.8%300,000 341,440 12,787 Rentals - 3,105 - 452,462 - 455,567 355,208 128.3%387,500 493,424 (37,857) Food Sales 271,015 - - - - 271,015 229,167 118.3%250,000 277,719 (6,704) Beverage Sales 481,347 - - - - 481,347 430,833 111.7%470,000 489,421 (8,074) Other Revenue 16,988 102 - - - 17,090 6,417 266.3%7,000 12,773 4,317 Total Operating Revenues 769,350$ 1,882,756$ 390,042$ 452,462$ -$ 3,494,610$ 2,907,942$ 120.2%3,172,300$ 3,537,501$ (42,891)$ OPERATING EXPENDITURES Personnel 235,614$ 520,508$ 59,417$ 42,611$ 326,040$ 1,184,190$ 1,286,798$ 92.0%1,403,780$ 1,225,482$ (41,292)$ Materials & Supplies 284,696 187,926 19,958 1,006 204,980 698,567 575,208 121.4%627,500 641,035 57,532 Operational & Contractual 7,487 210,840 6,827 58,817 51,883 335,854 269,019 124.8%293,475 350,861 (15,007) Other - - - - - - - N/A - - - Capital - 131,234 - - - 131,234 329,083 39.9%359,000 146,918 (15,684) Total Operating Expenditures 527,798$ 1,050,507$ 86,202$ 102,434$ 582,903$ 2,349,845$ 2,460,109$ 95.5%2,683,755$ 2,364,296$ (14,451)$ Operating Revenues Over (Under) Expenditures 241,551$ 832,249$ 303,840$ 350,028$ (582,903)$ 1,144,765$ 447,833$ 255.6%488,545$ 1,173,205$ (28,440)$ INTERFUND TRANSACTIONS Transfer from Golf Surcharge -$ -$ -$ -$ -$ -$ 137,500$ 0.0%150,000$ -$ -$ Reimbursement to General Fund - (51,876) - - - (51,876) (51,874) 100.0%(56,590) (43,241) (8,635) Total Interfund Transactions -$ (51,876)$ -$ -$ -$ (51,876)$ 85,626$ -60.6%93,410$ (43,241)$ (8,635)$ Total Revenues Over (Under) Expenditures - Budgetary Basis 241,551$ 780,373$ 303,840$ 350,028$ (582,903)$ 1,092,889$ 533,459$ 581,955$ 1,129,964$ (37,075)$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay -$ 131,234$ -$ -$ -$ 131,234$ 146,918$ Depreciation Expense (917) (96,250) (2,108) (11,917) (114,583) (225,775) (225,775) IMRF Pension Expense (2,292) (9,167) (917) - (10,083) (22,458) (22,458) OPEB Expense (2,750) (13,750) - - (9,167) (25,667) (25,667) Total GAAP Adjustments (5,958)$ 12,068$ (3,025)$ (11,917)$ (133,833)$ (142,666)$ (126,982)$ Fund Increase/(Decrease) - GAAP Basis 235,593$ 792,441$ 300,815$ 338,111$ (716,737)$ 950,223$ 1,002,982$ *Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.