Loading...
10 - October 2022 Monthly Financial ReportVILLAGE OAK BROOKOF MONTHLY FINANCIAL REPORTS OCTOBER 2022 Village of Oak Brook Monthly Financial Report – Fund Narrative For the Period Ending October 31, 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 fund 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 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 October 2022 are $4,854,713, or 22.4%, higher than last October, and $6,084,830, or 29.7%, over budget to date. The main drivers for this are: o Sales tax revenue, the General Fund’s largest revenue source, is up $3,628,284 from last year and $4,055,045 over budget. October 2022 collections came in at the highest level in the past five years. o Other Intergovernmental Tax is up $726,832 from last year and $1,097,113 over budget. Receipts from Income Tax and Replacement Tax came in higher than anticipated in October. o The Telecommunication/Utility Tax is down $137,916 from last year and $1,550 over budget. $0.25 $0.50 $0.75 $1.00 $1.25 $1.50 2018 2019 2020 2021 2022 Sales Tax -October Collections Last 5 Years • Total expenditures through October 2022 are $1,161,329, or 6.6%, higher than last year and $2,235,104 or 10.71%, under budget to date. Hotel Tax Fund • Total revenues through October 2022 are $492,918, or 82.4%, higher than last year and $423,899, or 63.5%, over budget to date. The main drivers for this are: o Hotel tax revenue is up $506,480 from last year and $427,010 over budget. Hotel stay continues to recover from the effects of COVID-19 on the travel industry. • Total expenditures through October 2022 are $257,936 higher than last year and $189,197 over budget. o Operation and Contract expenditures are up $207,891, or 122.1%, from last year and $136,502 over budget. Infrastructure Fund • Total revenues through October 2022 are up $1,896,448, or 38.4%, from last year and $1,058,817 or 18.3%, over budget. The main drivers for this are: o Non-home rule sales tax revenue is up $1,303,666 from last year, and $1,365,455 over budget. October 2022 collections came in at the highest level in the past five years. • Total expenditures through October 2022 are up $742,620 or 9.5%, from last year and $1,821,281 or 17.5%, under budget to date. The main drivers for this are: o Operation and contract expenditures are down $337,179 from last year and $456,710 under budget. o Capital Outlay is up $1,134,936 from last year and $1,280,411 under budget. Promenade TIF Fund • Total revenues through October 2022 are down $68,599 or 14.2%, from last year and $691 over budget to date. Sales tax revenues are under budget this is mainly due to the timing of information needed to record the TIF sale tax transfer between funds. • Total expenditures through October 2022 are up $2,373 from last year and $79,485 over budget. The increase relates to timing in payment of notes payable compared to last year. $0 $250 $500 $750 2018 2019 2020 2021 2022 Non-Home Rule Sales Tax - October Collections Last 5 Years Water Fund •Total revenues through October 2022 are up $756,859, or 7.8% higher than last year and $1,484,822, or 16.6%, over budget. •Total expenditures through October 2022 are down $4,870,184, or 48.5%, from last year and $3,194,753 or 38.17%, under budget. The main drivers for this are: o Personnel expenditures are down $279,918 from last year and $176,750 under budget. o Capital outlay expenditures are down $5,185,584 from last year. Sports Core Fund •Total revenues through October 2022 are up $785,475 or 20.9% higher than last year and $866,794, over budget to date. The main drivers for this are: o Membership revenue is up $451,948 from last year and $139,688 over budget. o Rentals are up by $212,493 from last year and $153,042 over budget. •Total expenditures through October 2022 are up $220,513, or 7.2%, from last year, and $111,812, or 2.9% over budget to date. The main drivers for this are: o Operation and contract expenditures are higher $424,213 from last year and $220,513 over budget. o Capital outlay expenditures are down $283,414 from last year, and $24,365 under budget. YTD YTD Net Fund Budgeted YTD YTD Increase Increase Governmental Funds Revenues Expenditures (Decrease)(Decrease) General Fund (Major Fund)27,037,583$ 18,720,419$ 8,317,164$ (2,770)$ Main operating fund of the Village. Hotel Fund (Major Fund)1,090,983$ 499,851$ 591,131$ 195,283$ Collects and spends resources from the 3% hotel/motel tax. Motor Fuel Tax Fund 449,421$ -$ 449,421$ 157,960$ Collects and spends resources from the State motor fuel tax. Infrastructure Fund (Major Fund)7,105,988$ 8,673,772$ (1,567,783)$ (4,095,079)$ Accounts for construction and maintenance of roadways, drainage, and safety path systems. Promenade TIF Fund (Major Fund)413,233$ 487,948$ (74,715)$ 4,079$ 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)10,414,405$ 5,524,736$ 4,889,669$ 210,096$ Collects user fees for the distribution of water and maintenance of infrastructure. Sports Core Fund (Major Fund)4,550,148$ 3,341,188$ 1,208,960$ 578,979$ Accounts for revenues and expenses relating to administration, programs, food and beverage operations, and golf course. Golf Surcharge Fund 138,977$ -$ 138,977$ 66,499$ Accounts for the collection of the $3 per round golf surcharge. Internal Service Funds Self Insurance Fund 2,264,708$ 2,482,607$ (217,899)$ 30,809$ Accounts for the Village's health insurance costs and the related contributions from the Village, employees, retirees, and other agencies. Garage Fund 520,602$ 547,714$ (27,111)$ (19,713)$ Accounts for the maintenance of the Village's vehicle fleet and the related departmental reimbursements. Equipment Replacement Fund 703,671$ 615,898$ 87,773$ 37,262$ 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 October 31, 2022 10/31/22 10/31/22 10/31/21 10/31/22 YTD % of YTD 2022 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax 11,426,761$ 15,055,045 11,000,000$ 136.9%13,200,000$ 3,628,284$ Other Intergovernmental Tax*1,718,947 2,445,779 1,348,667 181.3%1,618,400 726,832 Telecommunications/Utility Tax 4,801,966 4,664,050 4,662,500 100.0%5,595,000 (137,916) Grants 41,765 22,507 12,500 180.1%15,000 (19,258) Licenses and Permits 1,730,729 1,956,206 1,672,925 116.9%2,007,510 225,477 Charges for Services 1,255,692 1,626,117 962,417 169.0%1,154,900 370,425 Fines and Penalties 121,942 88,333 118,333 74.6%142,000 (33,609) Administrative Towing Fees 23,156 40,850 20,833 196.1%25,000 17,694 Investment Interest 149,743 242,703 120,000 202.3%144,000 92,960 Franchise Fees 109,738 166,134 165,000 100.7%198,000 56,396 Installment Contract Proceeds - N/A - Miscellaneous Income 331,411 258,841 398,558 64.9%478,270 (72,570) Total Operating Revenues 21,711,850$ 26,566,563$ 20,481,733$ 129.7%24,578,080$ 4,854,713$ OPERATING EXPENDITURES Personnel 14,233,927$ 14,503,079$ 16,223,541$ 89.4%19,468,249$ 269,152$ Materials and Supplies 335,010 404,254 477,121 84.7%572,545 69,244$ Operation and Contract 2,686,132 3,392,644 2,987,267 113.6%3,584,720 706,512$ Other Expenditures 8,599 6,437 99,067 6.5%118,880 (2,162)$ Capital Outlay 203,852 322,436 1,076,958 29.9%1,292,350 118,584$ Total Operating Expenditures 17,467,520$ 18,628,849$ 20,863,953$ 89.3%25,036,744$ 1,161,329$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 4,244,330$ 7,937,714$ (382,220)$ -2076.7%(458,664)$ 3,693,384$ INTERFUND TRANSACTIONS Transfers In -$ -$ -$ N/A -$ -$ Transfers Out - N/A - Reimbursements From Other Funds 445,257 471,020 471,017 100.0%565,220 25,763 Reimbursements To Other Funds (79,416) (91,570) (91,567) 100.0%(109,880) (12,154) Sports Core Loan - N/A - - Total Interfund Transactions 365,841$ 379,450$ 379,450$ 100.0%455,340$ 13,609$ NET FUND INCREASE (DECREASE)4,610,171$ 8,317,164$ (2,770)$ (3,324)$ 3,706,993$ *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 October 31, 2022 Total Total Revenues Expenditures 10/31/22 Actual 26,566,563$ 18,628,849$ 10/31/21 Actual 21,711,850$ 17,467,520$ % Change From Last Year 22.4%6.6% Major Revenues Other Telecom/Utility Licenses &Charges for Sales Tax Intergov. Tax Tax Permits Services 10/31/22 Actual 15,055,045$ 2,445,779$ 4,664,050$ 1,956,206$ 1,626,117$ 10/31/21 Actual $ 11,426,761 $ 1,718,947 $ 4,801,966 $ 1,730,729 $ 1,255,692 % Change From Last Year 31.8%42.3%-2.9%13.0%29.5% Five Year Trend Major Expenditures Materials &Operation &Other Personnel Supplies Contractual Expenditures Capital Outlay 10/31/22 Actual 14,503,079$ 404,254$ 3,392,644$ 6,437$ 322,436$ 10/31/21 Actual 14,233,927$ 335,010$ 2,686,132$ 8,599$ 203,852$ % Change From Last Year 1.9%20.7%26.3%-25.1%58.2% Five Year Trend Expenditures by Department 10/31/21 10/31/22 10/31/22 10/31/22 2022 Difference Five YTD YTD YTD % of Annual Prior Year Department Actual Actual Budget Budget Budget Year Trend Legislative & General Management 1,930,457$ 2,508,550$ 2,502,067$ 100.3%3,002,480$ 578,093$ Financial Services 616,093 656,494 689,192 95.3%827,030 40,401 Public Works 682,522 706,402 773,971 91.3%928,765 23,880 Engineering & Capital Projects 22,548 13,418 320,000 4.2%384,000 (9,130) Library 737,413 808,126 830,121 97.4%996,145 70,713 Police 6,966,381 7,400,036 8,224,254 90.0%9,869,105 433,655 Fire 5,731,069 5,811,634 6,601,700 88.0%7,922,040 80,565 Development Services 781,037 726,082 911,904 79.6%1,094,285 (54,955) Total Expenditures 17,467,520$ 18,628,849$ 20,863,953$ 89.3%25,036,744$ 1,163,222$ Five Year Trend For the Period Ending October 31, 2022 General Fund - Five Year Trend Village of Oak Brook Revenues Expenditures 10/31/22 10/31/22 10/31/21 10/31/22 YTD % of YTD 2022 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Hotel Tax 565,114$ 1,071,594$ 644,583$ 166.2%773,500$ 506,480$ Investment Interest 27,679 16,389 17,500 93.7%21,000 (11,290) Loan Interest 4,000 3,000 5,000 60.0%6,000 (1,000) Miscellaneous 1,272 (1,272) Total Operating Revenues 598,065$ 1,090,983$ 667,083$ 163.5%800,500$ 492,918$ EXPENDITURES Operation and Contract 170,265$ 378,156$ 241,654$ 156.5%289,985$ 207,891$ Capital Outlay 2,650 52,696 - N/A - 50,046 Total Expenditures 172,915$ 430,851$ 241,654$ 178.3%289,985$ 257,936$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 425,150$ 660,131$ 425,429$ 155.2%510,515$ 234,981$ INTERFUND TRANSACTIONS Transfer Out (2,714,068)$ -$ (161,146)$ 0.0%(193,375)$ 2,714,068$ Reimbursements to Other Funds (70,070) (69,000) (69,000) 100.0%(82,800) 1,070 Total Interfund Transactions (2,784,138)$ (69,000)$ (230,146)$ 30.0%(276,175)$ 2,715,138$ NET FUND INCREASE (DECREASE)(2,358,988)$ 591,131$ 195,283$ 234,340$ 2,950,119$ Note - Expenditures are recorded in program 171. Village of Oak Brook Hotel Tax Fund Financial Update For the Period Ending October 31, 2022 Total Total Revenues Expenditures 10/31/22 Actual $ 1,090,983 430,851$ 10/31/21 Actual $ 598,065 172,915$ % Change From Last Year 82.4%149.2% Major Revenues Investment Hotel Tax Interest Loan Interest Miscellaneous 10/31/22 Actual $ 1,071,594 $ 16,389 3,000$ -$ 10/31/21 Actual $ 565,114 $ 27,679 4,000$ 1,272$ % Change From Last Year 89.6%-40.8%0.0%0.0% Five Year Trend Major Expenditures Operation & Contractual Capital Outlay 10/31/22 Actual 378,156$ 52,696$ 10/31/21 Actual 170,265$ 2,650$ % Change From Last Year 122.1%N/A Five Year Trend Village of Oak Brook Hotel Tax Fund - Major Sources Five Year Trend For the Period Ending October 31, 2022 Five Year Trend Revenues Expenditures 10/31/22 10/31/22 10/31/21 10/31/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 4,907,623$ 6,211,289$ 4,845,833$ 128.2%5,815,000$ 1,303,666$ Charges for Services - - N/A -$ Investment Interest 28,158 75,220 22,917 328.2%27,500 47,062 Grants - 550,000 908,108 60.6%1,089,730 550,000 Miscellaneous 4,279 - 833 0.0%1,000 (4,279) Total Operating Revenues 4,940,060$ 6,836,508$ 5,777,692$ 118.3%6,933,230$ 1,896,448$ OPERATING EXPENDITURES Personnel 1,082,671$ 1,031,900$ 1,077,363$ 95.8%1,292,835$ (50,771)$ Materials and Supplies 154,502 150,136 188,833 79.5%226,600 (4,366) Operation and Contract 1,322,286 985,107 1,441,817 68.3%1,730,180 (337,179) Other Expenditures - N/A - Capital Outlay 5,273,253 6,408,189 7,688,600 83.3%9,226,320 1,134,936 Total Operating Expenditures 7,832,712$ 8,575,332$ 10,396,613$ 82.5%12,475,935$ 742,620$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES (2,892,652)$ (1,738,823)$ (4,618,921)$ 37.6%(5,542,705)$ 1,153,829$ INTERFUND TRANSACTIONS Transfers In 2,714,068$ -$ 352,813$ 0.0%423,375$ (2,714,068)$ Reimbursements From Other Funds 276,540 269,480 269,471 100.0%323,365 (7,060) Reimbursements To Other Funds (146,920) (98,440) (98,442) 100.0%(118,130) 48,480 Total Interfund Transactions 2,843,688$ 171,040$ 523,842$ 32.7%628,610$ (2,672,648)$ NET FUND INCREASE (DECREASE)(48,964)$ (1,567,783)$ (4,095,079)$ (4,914,095)$ (1,518,819)$ Village of Oak Brook Infrastructure Fund Financial Update For the Period Ending October 31, 2022 Total Total Revenues Expenditures 10/31/22 Actual $ 6,836,508 8,575,332$ 10/31/21 Actual $ 4,940,060 7,832,712$ % Change From Last Year 38.4%9.5% Major Revenues Sales Tax Charges for Services Investment Interest Miscellaneous 10/31/22 Actual $ 6,211,289 $ - $ 75,220 $ - 10/31/21 Actual $ 4,907,623 $ - $ 28,158 $ - % Change From Last Year 26.6%0.0%167.1%0.0% Five Year Trend Major Expenditures Materials &Operation & Personnel Supplies Contractual Capital Outlay 10/31/22 Actual 1,031,900$ 150,136$ 985,107$ 6,408,189$ 10/31/21 Actual 1,082,671$ 154,502$ 1,322,286$ 5,273,253$ % Change From Last Year -4.7%-2.8%-25.5%21.5% Five Year Trend Expenditures by Department 10/31/21 10/31/22 10/31/22 10/31/22 2022 Difference Five YTD YTD YTD % of Annual Prior Year Actual Actual Budget Budget Budget Year Trend Legislative & General Management 121,253$ 142,652$ 174,592$ 81.7%209,510$ 21,399$ Public Works 1,961,546 1,791,692 1,983,496 90.3%2,380,195 (169,854) Engineering & Capital Projects 5,749,913 6,739,429 8,238,525 81.8%9,886,230 989,516 Total Expenditures 7,832,712$ 8,673,773$ 10,396,613$ 83.4%12,475,935$ 841,061$ Five Year Trend Village of Oak Brook Infrastructure Fund - Major Sources Five Year Trend For the Period Ending October 31, 2022 Revenues Expenditures 10/31/22 10/31/22 10/31/21 10/31/22 YTD % of YTD 2022 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax 73,335$ -$ 75,000$ 0.0%90,000$ (73,335)$ Real Estate Tax 408,456 411,855 337,500 122.0%405,000 3,399 Investment Interest 41 1,378 42 3306.3%50 1,337 Total Operating Revenues 481,832$ 413,233$ 412,542$ 100.2%495,050$ (68,599)$ EXPENDITURES Operation and Contract 4,075$ 1,688$ 3,250$ 51.9%3,900$ (2,388)$ Other Expenditures 481,500 486,260 405,213 120.0%486,255 4,760 Total Expenditures 485,575$ 487,948$ 408,463$ 119.5%490,155$ 2,373$ NET FUND INCREASE (DECREASE)(3,743)$ (74,715)$ 4,079$ 4,895$ (70,972)$ Note - Expenditures are recorded in program 283. Village of Oak Brook Promenade TIF Fund Financial Update For the Period Ending October 31, 2022 Total Total Revenues Expenditures 10/31/22 Actual $ 413,233 487,948$ 10/31/21 Actual $ 481,832 485,575$ % Change From Last Year -14.2%0.5% Major Revenues Real Estate Investment Sales Tax Tax Interest 10/31/22 Actual -$ $ 411,855 $ 1,378 10/31/21 Actual 73,335$ $ 408,456 $ 41 % Change From Last Year -100.0%0.0%3260.0% Five Year Trend Major Expenditures Operation &Other Contractual Expenditures 10/31/22 Actual 1,688$ 486,260$ 10/31/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 October 31, 2022 Five Year Trend Revenues Expenditures 10/31/22 10/31/22 10/31/21 10/31/22 YTD % of YTD 2022 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Plan Review Fees 525$ 525$ 833$ 63.0%1,000$ -$ Building/Inspection Fees 2,925 1,875 4,167 45.0%5,000 (1,050) Water Sales 8,681,695 9,539,744 8,737,083 109.2%10,484,500 858,049 Unmetered Sales 43,028 92,643 41,667 222.3%50,000 49,615 Water Connection Fees 187,220 579,830 62,500 927.7%75,000 392,610 Fire Service Charge - - N/A - Meter Charges 7,116 22,319 12,500 178.6%15,000 15,203 Special Services 13,333 13,389 20,833 64.3%25,000 56 Investment Interest 40,073 58,739 25,000 235.0%30,000 18,666 Miscellaneous 681,631 105,341 25,000 421.4%30,000 (576,290) Total Operating Revenues 9,657,546$ 10,414,405$ 8,929,583$ 116.6%10,715,500$ 756,859$ OPERATING EXPENDITURES Personnel 642,851$ 362,933$ 539,683$ 67.2%647,620$ (279,918)$ Materials and Supplies 116,231 63,464 58,042 109.3%69,650 (52,767) Operation and Contract 4,065,950 4,714,034 4,500,521 104.7%5,400,625 648,084 Capital Outlay 5,219,478 33,894 3,270,833 1.0%3,925,000 (5,185,584) Total Expenditures 10,044,510$ 5,174,326$ 8,369,079$ 61.8%10,042,895$ (4,870,184)$ Surplus (Deficit) of Revenues Over Expenditures 5,515$ 5,240,079$ 560,504$ 934.9%672,605$ 5,627,043$ INTERFUND TRANSACTIONS Reimbursements To Other Funds (375,420)$ (350,410)$ (350,408)$ 100.0%(420,490)$ 25,010$ Total Interfund Transactions (375,420)$ (350,410)$ (350,408)$ 100.0%(420,490)$ 25,010$ Fund Increase/(Decrease) - Budgetary Basis (369,905)$ 4,889,669$ 210,096$ 252,115$ 5,652,053$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay 5,219,478$ 33,894$ Depreciation Expense (479,167) (479,167) IMRF Pension Expense (37,500) (37,500) OPEB Expense (25,000) (25,000) Total GAAP Adjustments 4,677,811$ (507,773)$ Fund Increase/(Decrease) - GAAP Basis 4,307,906$ 4,381,896$ *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 October 31, 2022 Total Total Revenues Expenditures 10/31/22 Actual $ 10,414,405 5,174,326$ 10/31/21 Actual $ 9,657,546 10,044,510$ % Change From Last Year 7.8%-48.5% Unmetered Water Water Sales Sales Connection Fees Meter Charges Miscellaneous 10/31/22 Actual $ 9,539,744 $ 92,643 $ 579,830 $ 22,319 $ 105,341 10/31/21 Actual $ 8,681,695 $ 43,028 $ 187,220 $ 7,116 $ 681,631 % Change From Last Year 9.9%115.3%209.7%213.6%-84.5% Five Year Trend Materials &Operation &Other Personnel Supplies Contractual Expenditures Capital Outlay 10/31/22 Actual 362,933$ 63,464$ 4,714,034$ -$ 33,894$ 10/31/21 Actual 642,851$ 116,231$ 4,065,950$ -$ 5,219,478$ % Change From Last Year -43.5%-45.4%15.9%0.0%-99.4% Five Year Trend Expenditures by Department 10/31/21 10/31/22 10/31/22 10/31/22 2022 Difference Five YTD YTD YTD % of Annual Prior Year Actual Actual Budget Budget Budget Year Trend Public Works 4,759,938$ 5,140,432$ 5,098,246$ 93.4%6,117,895$ (380,494)$ Engineering & Capital Projects 5,284,572 33,894 3,270,833 0.0%3,925,000 5,250,678 Total Expenditures 10,044,510$ 5,174,326$ 8,369,079$ 61.8%10,042,895$ 4,870,184$ Five Year Trend Village of Oak Brook Water Fund - Major Sources Five Year Trend For the Period Ending October 31, 2022 Revenues Expenditures Village of Oak Brook Monthly Operating Statement Sports Core Fund Consolidated Presentation For the Period Ending October 31, 2022 10/31/22 10/31/22 10/31/22 YTD % of YTD 2022 10/31/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$ 668,125$ 120.9%801,750$ 355,865$ 451,948$ Greens Fees - - - 1,206,113 1,206,113 954,167 126.4%1,145,000 1,252,179 (46,066) Pro Shop Sales - - - 207,058 207,058 175,000 118.3%210,000 222,939 (15,881) Golf Lessons - - - 35,815 35,815 41,667 86.0%50,000 50,140 (14,325) Driving Range Fees - - - 354,137 354,137 250,000 141.7%300,000 341,445 12,692 Rentals - 223,893 321,619 435,675 981,187 828,146 118.5%993,775 768,694 212,493 Programs/User Fees 84,890 - - - 84,890 12,917 657.2%15,500 - 84,890 Food Sales 44,287 - - 260,335 304,622 238,333 127.8%286,000 272,117 32,505 Beverage Sales 17,712 - - 464,681 482,392 408,333 118.1%490,000 479,258 3,134 Taste of Oak Brook - 66,812 - - 66,812 100,000 66.8%120,000 - 66,812 Grants - - - - - - N/A - - - Other Revenue 2,854 - - 16,454 19,308 6,667 289.6%8,000 22,036 (2,728) Total Operating Revenues 552,581$ 290,705$ 321,619$ 3,385,243$ 4,550,148$ 3,683,354$ 123.5%4,420,025$ 3,764,673$ 785,475$ OPERATING EXPENDITURES Personnel 64,847$ -$ 107,207$ 1,091,405$ 1,263,459$ 1,392,817$ 90.7%1,671,380$ 1,257,881$ 5,578$ Materials & Supplies 69,234 - 6,427 658,947 734,608 599,083 122.6%718,900 660,472 74,136 Operational & Contractual 306,292 218,250 67,782 323,325 915,648 785,638 116.5%942,765 491,435 424,213 Other - - - - - - N/A - - - Capital 244,355 - - 120,238 364,593 388,958 93.7%466,750 648,007 (283,414) Total Operating Expenditures 684,727$ 218,250$ 181,416$ 2,193,915$ 3,278,308$ 3,166,496$ 103.5%3,799,795$ 3,057,795$ 220,513$ B&T Administration Overhead Allocation*32,738$ -$ (32,738)$ -$ -$ -$ N/A -$ -$ -$ Operating Revenues Over (Under) Expenditures (99,409)$ 72,455$ 107,465$ 1,191,328$ 1,271,840$ 516,858$ 246.1%620,230$ 706,878$ 564,962$ INTERFUND TRANSACTIONS Interfund Loan**-$ -$ -$ -$ -$ -$ N/A -$ -$ -$ Transfer From General Fund - - - - - - N/A - - - Transfer From Golf Surcharge Fund - - - - - 125,000 0.0%150,000 - - Reimbursement From Infrastructure Fund - - - - - - N/A - 26,670 (26,670) Reimbursement From Water Fund - - - - - - N/A - 6,670 (6,670) Reimbursement To General Fund (15,720) - - (47,160) (62,880) (62,879) 100.0%(75,455) (52,410) (10,470) Total Interfund Transactions (15,720)$ -$ -$ (47,160)$ (62,880)$ 62,121$ -101.2%74,545$ (19,070)$ (43,810)$ Total Revenues Over (Under) Expenditures - Budgetary Basis (115,129)$ 72,455$ 107,465$ 1,144,168$ 1,208,960$ 578,979$ 694,775$ 687,808$ 521,152$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay 244,355$ -$ -$ 120,238$ 364,593$ 648,007$ Depreciation Expense (140,189) (1,404) (25,000) (205,250) (371,843) (396,843) IMRF Pension Expense (1,708) - (1,250) (20,417) (23,375) (24,625) OPEB Expense - - (1,250) (23,333) (24,583) (25,833) Total GAAP Adjustments 102,457$ (1,404)$ (27,500)$ (128,762)$ (55,209)$ 200,705$ Fund Increase/(Decrease) - GAAP Basis (12,671)$ 71,051$ 79,965$ 1,015,406$ 1,153,751$ 888,513$ *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 10/31/22 Actual $ 4,550,148 3,278,308$ 10/31/21 Actual $ 3,764,673 3,057,795$ % Change From Last Year 20.9%7.2% Driving Program/ Memberships Greens Fees Range Fees Rentals User Fees 10/31/22 Actual $ 807,813 $ 1,206,113 $ 354,137 $ 981,187 84,890$ 10/31/21 Actual $ 355,865 $ 1,252,179 $ 341,445 $ 768,694 -$ % Change From Last Year 127.0%-3.7%N/A 27.6%0.0% Five Year Trend Materials &Operation &Other Personnel Supplies Contractual Expenditures Capital Outlay 10/31/22 Actual 1,263,459$ 734,608$ 915,648$ -$ 364,593$ 10/31/21 Actual 1,257,881$ 660,472$ 491,435$ -$ 648,007$ % Change From Last Year 0.4%11.2%86.3%0.0%-43.7% Five Year Trend Revenues by Department 10/31/21 10/31/22 10/31/22 10/31/22 2022 Difference Five YTD YTD YTD % of Annual Prior Year Actual Actual Budget Budget Budget Year Trend B&T Recreation Operations 9,505$ 552,581$ 434,542$ 127.2%521,450$ 481,077$ Open Field Operations 105,500 290,705 312,500 93.0%375,000 118,393 B&T Clubhouse Operations 181,719 321,619 292,729 109.9%351,275 139,900 Golf Club 3,467,949 3,385,243 2,643,583 128.1%3,172,300 (82,706) Total Revenues 3,764,673$ 4,550,148$ 3,683,354$ 123.5%4,420,025$ 656,664$ Expenditures by Department 10/31/21 10/31/22 10/31/22 % of YTD 2022 Difference Five YTD YTD YTD % of Annual Prior Year Actual Actual Budget Budget Budget Year Trend B&T Recreation Operations 414,853$ 684,727$ 472,650$ 144.9%567,180$ 269,874$ Open Field Operations 241,861$ 218,250$ 208,883$ 104.5%250,660$ (23,611)$ B&T Clubhouse Operations 171,903 181,416 248,500 73.0%298,200 9,513 Golf Club 2,229,178 2,193,915 2,236,463 98.1%2,683,755 (35,263) Total Expenditures 3,057,795$ 3,278,308$ 3,166,496$ 103.5%3,799,795$ 220,513$ Five Year Trend Village of Oak Brook Sports Core Fund - Major Sources Five Year Trend For the Period Ending October 31, 2022 Revenues Expenditures Village of Oak Brook Monthly Operating Statement Bath & Tennis Club Recreation Operations For the Period Ending October 31, 2022 10/31/22 10/31/22 822 10/31/22 YTD % of YTD 2022 10/31/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$ 374,125$ 107.7%448,950$ -$ 402,838$ Programs/User Fees - 42,259 42,631 - 84,890 12,916.67 657.2%15,500 - 84,890 Food Sales - - - 44,287 44,287 30,000.00 147.6%36,000 - - Beverage Sales - - - 17,712 17,712 16,666.67 106.3%20,000 - - Grants - - - - - - N/A - - - Other Revenue 2,854 - - - 2,854 833 342.4%1,000 9,505 (6,651) Total Operating Revenues 2,854$ 419,522$ 68,206$ 61,998$ 552,581$ 434,542$ 127.2%521,450$ 9,505$ 481,077$ OPERATING EXPENDITURES Personnel 16,606$ 12,211$ -$ 36,030$ 64,847$ 106,125$ 61.1%127,350$ 16,251$ 48,596$ Materials & Supplies 581 29,392 6,574 32,687 69,234 62,125 111.4%74,550 32,561 36,673 Operational & Contractual 35,424 204,979 59,136 6,752 306,292 256,275 119.5%307,530 96,740 209,552 Other - - - - N/A - - Capital - 243,605 750 - 244,355 48,125 507.8%57,750 269,301 (24,946) Total Operating Expenditures 52,611$ 490,186$ 66,460$ 75,470$ 684,727$ 472,650$ 144.9%567,180$ 414,853$ 269,874$ B&T Administration Overhead Allocation*65,477$ (23,572)$ (6,548)$ (2,619)$ 32,738$ -$ N/A 68,810$ 116,176$ (83,438)$ Operating Revenues Over (Under) Expenditures 15,720$ (94,236)$ (4,802)$ (16,090)$ (99,409)$ (38,108)$ 260.9%23,080$ (289,172)$ 127,765$ Transfer From General Fund - - - - - - N/A - - Reimbursement From Infrastructure Fund - - - - - -$ N/A - 26,670 (26,670) Reimbursement From Water Fund - - - - - - N/A - 6,670 (6,670) Reimbursement To General Fund (15,720) - - - (15,720) (15,721) 100.0%(18,865) (13,100) (2,620) Total Interfund Transactions (15,720)$ -$ -$ -$ (15,720)$ (15,721)$ 100.0%(18,865)$ 20,240$ (35,960)$ Total Revenues Over (Under) Expenditures - Budgetary Basis (0)$ (94,236)$ (4,802)$ (16,090)$ (115,129)$ (53,829)$ 4,215$ (268,932)$ 91,805$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ 243,605$ 750$ -$ 244,355$ 269,301$ Depreciation Expense (53,633) (83,333) (2,250) (973) (140,189) (140,189) IMRF Pension Expense (1,667) - - (42) (1,708) (1,708) Total GAAP Adjustments (55,299)$ 160,272$ (1,500)$ (1,015)$ 102,457$ 127,404$ Fund Increase/(Decrease) - GAAP Basis (55,300)$ 66,036$ (6,302)$ (17,105)$ (12,671)$ (141,529)$ *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 October 31, 2022 10/31/22 10/31/22 10/31/22 YTD % of YTD 2022 10/31/21 Difference 815 816 YTD Amended Amended Adopted YTD Prior Polo Open Fields Total Budget Budget Budget Total Year OPERATING REVENUES Field Rentals -$ 143,893$ 143,893$ 141,667$ 101.6%170,000$ 25,500$ 118,393$ Range Rentals - 80,000 80,000 70,833 112.9%85,000 80,000 - Taste of Oak Brook - 66,812 66,812 100,000 66.8%120,000 - - Other Revenue - - - N/A - - - Total Operating Revenues -$ 290,705$ 290,705$ 312,500$ 93.0%375,000$ 105,500$ 118,393$ OPERATING EXPENDITURES Personnel -$ -$ -$ -$ N/A -$ -$ Materials & Supplies - - - 1,250 0.0%1,500$ - - Operational & Contractual 199 218,050 218,250 207,633 105.1%249,160 9,186 209,064 Capital - - - N/A 232,675 (232,675) Total Operating Expenditures 199$ 218,050$ 218,250$ 208,883$ 104.5%250,660$ 241,861$ (23,611)$ Operating Revenues Over (Under) Expenditures (199)$ 72,654$ 72,455$ 103,617$ 69.9%124,340$ (136,361)$ 142,004$ INTERFUND TRANSACTIONS Transfer From Hotel Tax Fund -$ -$ -$ -$ N/A -$ -$ -$ Total Interfund Transactions -$ -$ -$ -$ N/A -$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis (199)$ 72,654$ 72,455$ 103,617$ 124,340$ (136,361)$ 142,004$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ -$ -$ 232,675$ Depreciation Expense - (1,404) (1,404) (1,404) Total GAAP Adjustments -$ (1,404)$ (1,404)$ 231,271$ Fund Increase/(Decrease) - GAAP Basis (199)$ 71,250$ 71,051$ 94,910$ *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 October 31, 2022 10/31/22 10/31/22 821 YTD % of YTD 2022 10/31/21 Difference B&T Amended Amended Adopted YTD Prior Clubhouse Budget Budget Budget Total Year OPERATING REVENUES Rentals 321,619$ 292,729$ 109.9%351,275$ 181,719$ 139,900$ Total Operating Revenues 321,619$ 292,729$ 109.9%351,275$ 181,719$ 139,900$ OPERATING EXPENDITURES Personnel 107,207$ 116,875$ 91.7%140,250$ 100,453$ 6,754$ Materials & Supplies 6,427 12,792 50.2%15,350 5,643 784 Operational & Contractual 67,782 77,167 87.8%92,600 61,425 6,357 Capital - 41,667 0.0%50,000 4,382 (4,382) Total Operating Expenditures 181,416$ 248,500$ 73.0%298,200$ 171,903$ 9,513$ B&T Administration Overhead Allocation*(32,738)$ -$ N/A (68,810)$ (116,176)$ 83,438$ Operating Revenues Over (Under) Expenditures 107,465$ 44,229$ 243.0%(15,735)$ (106,360)$ 213,825$ INTERFUND TRANSACTIONS Transfer From General Fund -$ -$ 0.0%-$ -$ -$ Total Interfund Transactions -$ -$ 0.0%-$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis 107,465$ 44,229$ (15,735)$ (106,360)$ 213,825$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ 4,382$ Depreciation Expense (25,000) (50,000) IMRF Pension Expense (1,250) (2,500) OPEB Expense (1,250) (2,500) Total GAAP Adjustments (27,500)$ (50,618)$ Fund Increase/(Decrease) - GAAP Basis 79,965$ (156,978)$ *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 October 31, 2022 10/31/22 10/31/22 823 831 832 833 834 10/31/22 YTD % of YTD 2022 10/31/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$ 294,000$ 137.7%352,800$ 355,865$ 49,110$ Greens Fees - 1,206,113 - - - 1,206,113 954,167 126.4%1,145,000 1,252,179 (46,066) Pro Shop Sales - 207,058 - - - 207,058 175,000 118.3%210,000 222,939 (15,881) Golf Lessons - - 35,815 - - 35,815 41,667 86.0%50,000 50,140 (14,325) Driving Range Fees - - 354,137 - - 354,137 250,000 141.7%300,000 341,445 12,692 Rentals - 3,065 - 432,610 - 435,675 322,917 134.9%387,500 481,475 (45,800) Food Sales 260,335 - - - - 260,335 208,333 125.0%250,000 272,117 (11,782) Beverage Sales 464,681 - - - - 464,681 391,667 118.6%470,000 479,258 (14,577) Other Revenue 16,352 102 - - - 16,454 5,833 282.1%7,000 12,531 3,923 Total Operating Revenues 741,368$ 1,821,313$ 389,952$ 432,610$ -$ 3,385,243$ 2,643,583$ 128.1%3,172,300$ 3,467,949$ (82,706)$ OPERATING EXPENDITURES Personnel 218,087$ 479,260$ 57,100$ 40,405$ 296,553$ 1,091,405$ 1,169,817$ 93.3%1,403,780$ 1,141,177$ (49,772)$ Materials & Supplies 280,572 174,473 19,958 1,006 182,938 658,947 522,917 126.0%627,500 622,268 36,679 Operational & Contractual 4,568 203,737 6,827 58,817 49,376 323,325 244,563 132.2%293,475 324,084 (760) Other - - - - - - - N/A - - - Capital - 120,238 - - - 120,238 299,167 40.2%359,000 141,649 (21,411) Total Operating Expenditures 503,228$ 977,708$ 83,885$ 100,228$ 528,866$ 2,193,915$ 2,236,463$ 98.1%2,683,755$ 2,229,178$ (35,263)$ Operating Revenues Over (Under) Expenditures 238,140$ 843,605$ 306,067$ 332,382$ (528,866)$ 1,191,328$ 407,121$ 292.6%488,545$ 1,238,771$ (47,443)$ INTERFUND TRANSACTIONS Transfer from Golf Surcharge -$ -$ -$ -$ -$ -$ 125,000$ 0.0%150,000$ -$ -$ Reimbursement to General Fund - (47,160) - - - (47,160) (47,158) 100.0%(56,590) (39,310) (7,850) Total Interfund Transactions -$ (47,160)$ -$ -$ -$ (47,160)$ 77,842$ -60.6%93,410$ (39,310)$ (7,850)$ Total Revenues Over (Under) Expenditures - Budgetary Basis 238,140$ 796,445$ 306,067$ 332,382$ (528,866)$ 1,144,168$ 484,963$ 581,955$ 1,199,461$ (55,293)$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay -$ 120,238$ -$ -$ -$ 120,238$ 141,649$ Depreciation Expense (833) (87,500) (1,917) (10,833) (104,167) (205,250) (205,250) IMRF Pension Expense (2,083) (8,333) (833) - (9,167) (20,417) (20,417) OPEB Expense (2,500) (12,500) - - (8,333) (23,333) (23,333) Total GAAP Adjustments (5,417)$ 11,905$ (2,750)$ (10,833)$ (121,667)$ (128,762)$ (107,351)$ Fund Increase/(Decrease) - GAAP Basis 232,724$ 808,349$ 303,317$ 321,549$ (650,533)$ 1,015,406$ 1,092,110$ *Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.