Loading...
09 - September 2023 Monthly Financial ReportVILLAGE OAK BROOKOF MONTHLY FINANCIAL REPORTS SEPTEMBER 2023 YTD YTD Net Fund Ending YTD YTD Increase Fund Balance Governmental Funds Revenues Expenditures (Decrease)(Deficit) General Fund (Major Fund)27,471,654$ 19,800,681$ 7,670,973$ 46,142,025$ Main operating fund of the Village. Hotel Fund (Major Fund)1,186,618$ 468,110$ 718,508$ 3,108,854$ Collects and spends resources from the 3% hotel/motel tax. Motor Fuel Tax Fund 311,999$ 103,678$ 208,321$ 1,905,859$ Collects and spends resources from the State motor fuel tax. Infrastructure Fund (Major Fund)5,970,017$ 2,606,385$ 3,363,632$ 12,246,126$ Accounts for construction and maintenance of roadways, drainage, and safety path systems. Promenade TIF Fund (Major Fund)459,793$ 341,566$ 118,227$ 431,851$ 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)8,609,120$ 5,900,008$ 2,709,112$ 21,585,322$ Collects user fees for the distribution of water and maintenance of infrastructure. Sports Core Fund (Major Fund)4,399,676$ 2,661,520$ 1,738,156$ 2,885,943$ Accounts for revenues and expenses relating to administration, programs, food and beverage operations, and golf course. Golf Surcharge Fund 94,127$ -$ 94,127$ 361,196$ Accounts for the collection of the $3 per round golf surcharge. Internal Service Funds Self Insurance Fund 2,014,522$ 2,640,614$ (626,092)$ (651,472)$ Accounts for the Village's health insurance costs and the related contributions from the Village, employees, retirees, and other agencies. Garage Fund 521,647$ 406,264$ 115,383$ 368,654$ Accounts for the maintenance of the Village's vehicle fleet and the related departmental reimbursements. Equipment Replacement Fund 1,022,157$ 794,081$ 228,076$ 3,052,963$ 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 September 30, 2023 9/30/23 9/30/23 9/30/22 9/30/23 YTD % of YTD 2023 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax 13,584,036$ 13,185,513 12,000,000$ 109.9%16,000,000$ (398,523)$ State Income Tax 1,040,268 992,305 858,750 115.6%1,145,000 (47,963) Replacement Tax 782,464 714,973 337,500 211.8%450,000 (67,491) Road & Bridge Tax 20,569 25,482 26,250 97.1%35,000 4,913 Local Use Tax 244,137 246,077 225,000 109.4%300,000 1,940 Cannabis Use Tax 10,319 9,344 11,925 78.4%15,900 (975) Grants 22,506 588,397 11,747 5009.0%15,662 565,891 Utility/Telecom. Tax 4,244,606 3,774,768 4,217,250 89.5%5,623,000 (469,838) Licenses and Permits 1,849,664 3,458,221 1,462,864 236.4%1,950,485 1,608,557 Charges for Services 1,459,422 2,207,450 1,235,528 178.7%1,647,370 748,028 Investment Interest 195,012 815,990 150,000 544.0%200,000 620,978 Miscellaneous Income 534,512 866,848 767,663 112.9%1,023,551 332,336 Total Operating Revenues 23,987,515$ 26,885,368$ 21,304,476$ 126.2%28,405,969$ 2,897,853$ OPERATING EXPENDITURES Personnel 13,060,471$ 15,011,361$ 16,602,788$ 90.4%22,137,051$ 1,950,890$ Materials and Supplies 342,653 411,120 447,792 91.8%597,056 68,467$ Operation and Contract 2,965,573 3,653,366 4,053,542 90.1%5,404,722 687,793$ Other Expenditures 4,290 6,394 6,750 94.7%9,000 2,104$ Capital Outlay 274,734 718,440 712,931 100.8%950,575 443,706$ Total Operating Expenditures 16,647,721$ 19,800,681$ 21,823,803$ 90.7%29,098,405$ 3,152,960$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 7,339,794$ 7,084,687$ (519,327)$ -1364.2%(692,436)$ (255,107)$ INTERFUND TRANSACTIONS Transfers In -$ -$ -$ N/A -$ -$ Transfers Out - N/A - Reimbursements From Other Funds 423,918 586,286 508,051 115.4%677,401 162,368 Reimbursements To Other Funds (82,413) - - N/A - 82,413 Total Interfund Transactions 341,505$ 586,286$ 508,051$ 115.4%677,401$ 244,781$ NET FUND INCREASE (DECREASE)7,681,299$ 7,670,973$ (11,276)$ (15,035)$ (10,326)$ Village of Oak Brook General Fund Financial Update For the Period Ending September 30, 2023 9/30/23 9/30/23 9/30/22 9/30/23 YTD % of YTD 2023 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Hotel Tax 924,025$ 1,120,924$ 862,500$ 130.0%1,150,000$ 196,899$ Investment Interest 12,915 63,694 9,000 707.7%12,000 50,779 Loan Interest 3,000 2,000 3,000 66.7%4,000 (1,000) Miscellaneous - - Total Operating Revenues 939,940$ 1,186,618$ 874,500$ 135.7%1,166,000$ 246,678$ EXPENDITURES Operation and Contract 334,282$ 205,995$ 505,946$ 40.7%674,595$ (128,287)$ Capital Outlay 52,696 - - N/A - (52,696) Total Expenditures 386,978$ 205,995$ 505,946$ 40.7%674,595$ (180,983)$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 552,962$ 980,623$ 368,554$ 266.1%491,405$ 427,661$ INTERFUND TRANSACTIONS Transfer Out -$ -$ -$ N/A -$ -$ Reimbursements to Other Funds (62,100) (262,115) (262,114) 100.0%(349,485) (200,015) Total Interfund Transactions (62,100)$ (262,115)$ (262,114)$ 100.0%(349,485)$ (200,015)$ NET FUND INCREASE (DECREASE)490,862$ 718,508$ 106,440$ 141,920$ 227,646$ Note - Expenditures are recorded in program 171. Village of Oak Brook Hotel Tax Fund Financial Update For the Period Ending September 30, 2023 9/30/23 9/30/23 9/30/22 9/30/23 YTD % of YTD 2023 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Non-Home Rule Sales Tax 5,567,373$ 5,596,917$ 4,893,750$ 114.4%6,525,000$ 29,544$ Charges for Services - - N/A -$ Investment Interest 62,975 207,830 20,625 1007.7%27,500 144,855 Grants 550,000 - 817,298 0.0%1,089,730 (550,000) Miscellaneous - 2,100 750 280.0%1,000 2,100 Total Operating Revenues 6,180,348$ 5,806,847$ 5,732,423$ 101.3%7,643,230$ (373,501)$ OPERATING EXPENDITURES Personnel 960,120$ 15,865$ 33,971$ 46.7%45,294$ (944,255)$ Materials and Supplies 141,522 155,430 148,050 105.0%197,400 13,908 Operation and Contract 888,292 652,163 1,297,635 50.3%1,730,180 (236,129) Other Expenditures - - - N/A - Capital Outlay 4,778,211 1,528,002 6,919,740 22.1%9,226,320 (3,250,209) Total Operating Expenditures 6,768,145$ 2,351,460$ 8,399,396$ 28.0%11,199,194$ (4,416,685)$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES (587,797)$ 3,455,387$ (2,666,973)$ -129.6%(3,555,964)$ 4,043,184$ INTERFUND TRANSACTIONS Transfers In -$ -$ -$ N/A -$ -$ Reimbursements From Other Funds 242,532 163,170 - N/A - (79,362) Reimbursements To Other Funds (88,596) (254,925) - N/A - (166,329) Total Interfund Transactions 153,936$ (91,755)$ -$ N/A -$ (245,691)$ NET FUND INCREASE (DECREASE)(433,861)$ 3,363,632$ (2,666,973)$ (3,555,964)$ 3,797,493$ Village of Oak Brook Infrastructure Fund Financial Update For the Period Ending September 30, 2023 9/30/23 9/30/23 9/30/22 9/30/23 YTD % of YTD 2023 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax -$ -$ 11,250$ 0.0%15,000$ -$ Real Estate Tax 411,855 455,450 303,750 149.9%405,000 43,595 Investment Interest 889 4,343 8 57901.3%10 3,454 Total Operating Revenues 412,744$ 459,793$ 315,008$ 146.0%420,010$ 47,049$ EXPENDITURES Operation and Contract 450$ 4,773$ 3,825$ 124.8%5,100$ 4,323$ Other Expenditures 486,260 336,793 252,544 133.4%336,725 (149,467) Total Expenditures 486,710$ 341,566$ 256,369$ 133.2%341,825$ (145,144)$ NET FUND INCREASE (DECREASE)(73,966)$ 118,227$ 58,639$ 78,185$ 192,193$ Note - Expenditures are recorded in program 283. Village of Oak Brook Promenade TIF Fund Financial Update For the Period Ending September 30, 2023 9/30/23 9/30/23 9/30/22 9/30/23 YTD % of YTD 2023 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Plan Review Fees 450$ 1,575$ 394$ 400.0%525$ 1,125$ Building/Inspection Fees 1,650 1,350 1,500 90.0%2,000 (300) Water Sales 8,935,677 7,641,146 6,172,500 123.8%8,230,000 (1,294,531) Unmetered Sales 80,848 39,136 37,500 104.4%50,000 (41,712) Water Connection Fees 573,850 138,920 56,250 247.0%75,000 (434,930) Fire Service Charge 20,189 - - N/A - (20,189) Meter Charges - 16,030 11,250 142.5%15,000 16,030 Special Services 13,389 25,741 7,500 343.2%10,000 12,352 Investment Interest 43,992 658,077 15,000 4387.2%20,000 614,085 Proceeds from Property Sale - - - N/A - - Miscellaneous 86,368 87,145 37,500 232.4%50,000 777 Total Operating Revenues 9,756,413$ 8,609,120$ 6,339,394$ 135.8%8,452,525$ (1,147,293)$ OPERATING EXPENDITURES Personnel 326,073$ 496,945$ 485,715$ 102.3%647,620$ 170,872$ Materials and Supplies 55,526 73,735 52,238 141.2%69,650 18,209 Operation and Contract 3,779,880 4,018,419 4,050,469 99.2%5,400,625 238,539 Capital Outlay 33,894 1,170,961 2,943,750 39.8%3,925,000 1,137,067 Total Expenditures 4,195,373$ 5,760,060$ 7,532,171$ 76.5%10,042,895$ 1,564,687$ Surplus (Deficit) of Revenues Over Expenditures 5,561,040$ 2,849,060$ (1,192,778)$ -238.9%(1,590,370)$ (2,711,980)$ INTERFUND TRANSACTIONS Reimbursements To Other Funds (315,369)$ (139,948)$ (315,368)$ 44.4%(420,490)$ 175,421$ Total Interfund Transactions (315,369)$ (139,948)$ (315,368)$ 44.4%(420,490)$ 175,421$ Fund Increase/(Decrease) - Budgetary Basis 5,245,671$ 2,709,112$ (1,508,145)$ (2,010,860)$ (2,536,559)$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay 33,894$ 1,170,961$ Depreciation Expense (383,333) (431,250) IMRF Pension Expense (30,000) (33,750) OPEB Expense (20,000) (22,500) Total GAAP Adjustments (399,439)$ 683,461$ Fund Increase/(Decrease) - GAAP Basis 4,846,232$ 3,392,573$ *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 September 30, 2023 Village of Oak Brook Monthly Operating Statement Sports Core Fund Consolidated Presentation For the Period Ending September 30, 2023 9/30/23 9/30/23 9/30/23 YTD % of YTD 2023 9/30/22 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 406,947$ -$ -$ 480,100$ 887,047$ 696,938$ 127.3%929,250$ 809,063$ 77,984$ Greens Fees - - - 1,294,628 1,294,628 982,500 131.8%1,310,000 1,089,321 205,307 Pro Shop Sales - - - 173,880 173,880 187,500 92.7%250,000 190,219 (16,339) Golf Lessons - - - 24,872 24,872 37,500 66.3%50,000 41,695 (16,823) Driving Range Fees - - - 388,753 388,753 262,500 148.1%350,000 330,936 57,818 Rentals - 213,580 116,344 428,750 758,674 813,000 93.3%1,084,000 855,202 (96,528) Programs/User Fees 102,959 - - - 102,959 51,825 198.7%69,100 78,680 24,279 Food Sales 53,070 - - 229,287 282,357 217,500 129.8%290,000 282,914 (557) Beverage Sales 18,909 - - 434,467 453,376 369,000 122.9%492,000 444,874 8,502 Taste of Oak Brook - - - - - - N/A - 66,812 (66,812) Grants - - - - - - N/A - - - Other Revenue 2,747 - - 30,383 33,130 20,719 159.9%27,625 16,751 16,379 Total Operating Revenues 584,632$ 213,580$ 116,344$ 3,485,120$ 4,399,676$ 3,638,981$ 120.9%4,851,975$ 4,206,465$ 193,211$ OPERATING EXPENDITURES Personnel 61,776$ -$ 8,130$ 1,077,633$ 1,147,539$ 1,296,240$ 88.5%1,671,380$ 1,094,970$ 52,569$ Materials & Supplies 55,630 1,064 7,162 533,182 597,038 616,529 96.8%718,900 612,013 (14,975) Operational & Contractual 380,496 30,876 53,444 279,991 744,807 566,863 131.4%942,765 833,969 (89,162) Other - - - - - - N/A - - - Capital - - - 111,412 111,412 1,184,063 9.4%466,750 340,230 (228,818) Total Operating Expenditures 497,902$ 31,940$ 68,736$ 2,002,218$ 2,600,796$ 3,663,694$ 71.0%3,799,795$ 2,881,182$ (280,386)$ B&T Administration Overhead Allocation*-$ -$ -$ -$ -$ -$ N/A -$ (0)$ (0)$ Operating Revenues Over (Under) Expenditures 86,730$ 181,640$ 47,608$ 1,482,902$ 1,798,880$ (24,713)$ -7279.2%1,052,180$ 1,325,282$ 473,597$ INTERFUND TRANSACTIONS Interfund Loan**-$ -$ -$ -$ -$ -$ N/A -$ -$ -$ Transfer From General Fund - - - - - - N/A - - - Transfer From Golf Surcharge Fund - - - - - 112,500 0.0%150,000 - - Reimbursement From Infrastructure Fund - - - - - - N/A - - - Reimbursement From Water Fund - - - - - - N/A - - - Reimbursement To General Fund (40,482) - - (20,242) (60,724) (60,725) 100.0%(80,967) (56,592) (4,132) Total Interfund Transactions (40,482)$ -$ -$ (20,242)$ (60,724)$ 51,775$ -117.3%69,033$ (56,592)$ (4,132)$ Total Revenues Over (Under) Expenditures - Budgetary Basis 46,248$ 181,640$ 47,608$ 1,462,660$ 1,738,156$ 27,062$ 1,121,213$ 1,268,690$ 469,465$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ -$ -$ 111,412$ 111,412$ 340,230$ Depreciation Expense (126,170) (1,264) (25,000) (184,725) (337,159) (337,159) IMRF Pension Expense (1,538) - (1,250) (18,375) (21,163) (21,163) OPEB Expense - - (1,250) (21,000) (22,250) (22,250) Total GAAP Adjustments (127,708)$ (1,264)$ (27,500)$ (112,688)$ (269,160)$ (40,341)$ Fund Increase/(Decrease) - GAAP Basis (81,460)$ 180,376$ 20,108$ 1,349,972$ 1,468,997$ 1,228,349$ *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. Village of Oak Brook Monthly Operating Statement Bath & Tennis Club Recreation Operations For the Period Ending September 30, 2023 9/30/23 9/30/23 822 9/30/23 YTD % of YTD 2023 9/30/22 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 -$ 389,375$ 17,572$ -$ 406,947$ 389,438$ 104.5%519,250$ 402,838$ 4,109$ Programs/User Fees - 71,921 31,038 - 102,959 51,825.00 198.7%69,100 78,680 24,279 Food Sales - - - 53,070 53,070 30,000.00 176.9%40,000 44,287 - Beverage Sales - - - 18,909 18,909 12,750.00 148.3%17,000 17,712 - Grants - - - - - - N/A - - - Other Revenue 2,747 - - - 2,747 1,744 157.5%2,325 2,359 388 Total Operating Revenues 2,747$ 461,296$ 48,610$ 71,979$ 584,632$ 485,756$ 120.4%647,675$ 545,875$ 28,776$ OPERATING EXPENDITURES Personnel 233$ 33,871$ -$ 27,672$ 61,776$ 149,076$ 41.4%198,768$ 64,155$ (2,379)$ Materials & Supplies 136 40,900 2,014 12,580 55,630 53,847 103.3%71,796 58,718 (3,088) Operational & Contractual 47,131 274,489 54,743 4,133 380,496 185,239 205.4%246,985 282,230 98,266 Other - - - - - - N/A - - Capital - - - - - 412,500 0.0%550,000 232,016 (232,016) Total Operating Expenditures 47,500$ 349,260$ 56,757$ 44,385$ 497,902$ 800,662$ 62.2%1,067,549$ 637,120$ (139,218)$ B&T Administration Overhead Allocation*-$ -$ -$ -$ -$ -$ N/A 43,783$ 12,352$ (12,352)$ Operating Revenues Over (Under) Expenditures (44,753)$ 112,036$ (8,147)$ 27,594$ 86,730$ (314,906)$ -27.5%(376,092)$ (78,893)$ 155,642$ Transfer From General Fund - - - - - - N/A - - - Reimbursement From Infrastructure Fund - - - - - -$ N/A - - - Reimbursement From Water Fund - - - - - - N/A - - - Reimbursement To General Fund (40,482) - - - (40,482) (15,182) 266.7%(20,242) (14,148) (26,334) Total Interfund Transactions (40,482)$ -$ -$ -$ (40,482)$ (15,182)$ 266.7%(20,242)$ (14,148)$ (26,334)$ Total Revenues Over (Under) Expenditures - Budgetary Basis (85,235)$ 112,036$ (8,147)$ 27,594$ 46,248$ (330,087)$ (396,334)$ (93,041)$ 129,308$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ -$ -$ -$ -$ 232,016$ Depreciation Expense (48,269) (75,000) (2,025) (876) (126,170) (126,170) IMRF Pension Expense (1,500) - - (38) (1,538) (1,538) Total GAAP Adjustments (49,769)$ (75,000)$ (2,025)$ (914)$ (127,708)$ 104,308$ Fund Increase/(Decrease) - GAAP Basis (135,004)$ 37,036$ (10,172)$ 26,681$ (81,460)$ 11,268$ *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 September 30, 2023 9/30/23 9/30/23 9/30/23 YTD % of YTD 2023 9/30/22 Difference 815 816 YTD Amended Amended Adopted YTD Prior Polo Open Fields Total Budget Budget Budget Total Year OPERATING REVENUES Field Rentals -$ 127,500$ 127,500$ 135,750$ 93.9%181,000$ 128,643$ (1,143)$ Range Rentals - 86,080 86,080 63,750 135.0%85,000 80,000 6,080 Taste of Oak Brook - - - - N/A - 66,812 - Other Revenue - - - - N/A - - Total Operating Revenues -$ 213,580$ 213,580$ 199,500$ 107.1%266,000$ 275,455$ 4,937$ OPERATING EXPENDITURES Personnel -$ -$ -$ -$ N/A -$ -$ Materials & Supplies - 1,064 1,064 7,118 14.9%9,490$ - 1,064 Operational & Contractual - 30,876 30,876 94,455 32.7%125,940 203,055 (172,179) Capital - - - - N/A - - Total Operating Expenditures -$ 31,940$ 31,940$ 101,573$ 31.4%135,430$ 203,055$ (171,115)$ Operating Revenues Over (Under) Expenditures -$ 181,640$ 181,640$ 97,928$ 185.5%130,570$ 72,399$ 176,053$ INTERFUND TRANSACTIONS Transfer From Hotel Tax Fund -$ -$ -$ -$ N/A -$ -$ -$ Total Interfund Transactions -$ -$ -$ -$ N/A -$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis -$ 181,640$ 181,640$ 97,928$ 130,570$ 72,399$ 176,053$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ -$ -$ -$ Depreciation Expense - (1,264) (1,264) (1,264) Total GAAP Adjustments -$ (1,264)$ (1,264)$ (1,264)$ Fund Increase/(Decrease) - GAAP Basis -$ 180,376$ 180,376$ 71,136$ *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 September 30, 2023 9/30/23 9/30/23 821 YTD % of YTD 2023 9/30/22 Difference B&T Amended Amended Adopted YTD Prior Clubhouse Budget Budget Budget Total Year OPERATING REVENUES Rentals 116,344$ 262,500$ 44.3%350,000$ 254,460$ (138,116)$ Other Revenue - - 0.0%- - - Total Operating Revenues 116,344$ 262,500$ 44.3%350,000$ 254,460$ (138,116)$ OPERATING EXPENDITURES Personnel 8,130$ 107,215$ N/A 142,954$ 96,118$ (87,988)$ Materials & Supplies 7,162 17,979 39.8%23,972 6,367 795 Operational & Contractual 53,444 57,631 92.7%76,842 61,123 (7,679) Capital - - N/A - - - Total Operating Expenditures 68,736$ 182,826$ 37.6%243,767$ 163,609$ (94,873)$ B&T Administration Overhead Allocation*-$ -$ N/A (43,784)$ (12,352)$ 12,352$ Operating Revenues Over (Under) Expenditures 47,608$ 79,674$ 59.8%62,449$ 78,500$ (30,892)$ INTERFUND TRANSACTIONS Transfer From General Fund -$ -$ 0.0%-$ -$ -$ Total Interfund Transactions -$ -$ 0.0%-$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis 47,608$ 79,674$ 62,449$ 78,500$ (30,892)$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ -$ Depreciation Expense (25,000) (25,000) IMRF Pension Expense (1,250) (1,250) OPEB Expense (1,250) (1,250) Total GAAP Adjustments (27,500)$ (27,500)$ Fund Increase/(Decrease) - GAAP Basis 20,108$ 51,000$ *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 September 30, 2023 9/30/23 9/30/23 823 831 832 833 834 9/30/23 YTD % of YTD 2023 9/30/22 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 -$ 480,100$ -$ -$ -$ 480,100$ 307,500$ 156.1%410,000$ 406,225$ 73,875$ Greens Fees - 1,294,628 - - - 1,294,628 982,500 131.8%1,310,000 1,089,321 205,307 Pro Shop Sales - 173,880 - - - 173,880 187,500 92.7%250,000 190,219 (16,339) Golf Lessons - - 24,872 - - 24,872 37,500 66.3%50,000 41,695 (16,823) Driving Range Fees - - 388,753 - - 388,753 262,500 148.1%350,000 330,936 57,818 Rentals - 1,550 - 427,200 - 428,750 351,000 122.2%468,000 392,099 36,651 Food Sales 229,287 - - - 229,287 187,500 122.3%250,000 238,627 (9,340) Beverage Sales 434,467 - - - - 434,467 356,250 122.0%475,000 427,162 7,305 Other Revenue 16,609 13,774 - - - 30,383 18,975 160.1%25,300 14,392 15,991 Total Operating Revenues 680,363$ 1,963,932$ 413,625$ 427,200$ -$ 3,485,120$ 2,691,225$ 129.5%3,588,300$ 3,130,674$ 354,446$ OPERATING EXPENDITURES Personnel 189,338$ 426,346$ 57,457$ 57,880$ 346,612$ 1,077,633$ 1,039,948$ 103.6%1,386,598$ 934,697$ 142,936$ Materials & Supplies 257,855 86,977 14,812 3,033 170,505 533,182 537,585 99.2%716,780 546,927 (13,745) Operational & Contractual 5,840 168,263 8,017 61,388 36,483 279,991 229,537 122.0%306,050 287,560 (7,569) Other - - - - - - - N/A - - - Capital - 72,758 13,290 - 25,364 111,412 771,563 14.4%1,028,751 108,214 3,198 Total Operating Expenditures 453,033$ 754,344$ 93,576$ 122,301$ 578,964$ 2,002,218$ 2,578,634$ 77.6%3,438,178$ 1,877,398$ 124,820$ Operating Revenues Over (Under) Expenditures 227,330$ 1,209,588$ 320,049$ 304,899$ (578,964)$ 1,482,902$ 112,591$ 1317.1%150,122$ 1,253,276$ 229,626$ INTERFUND TRANSACTIONS Transfer from Golf Surcharge -$ -$ -$ -$ -$ -$ 112,500$ 0.0%150,000$ -$ -$ Reimbursement to General Fund - (20,242) - - - (20,242) (45,544) 44.4%(60,725) (42,444) 22,202 Total Interfund Transactions -$ (20,242)$ -$ -$ -$ (20,242)$ 66,956$ -30.2%89,275$ (42,444)$ 22,202$ Total Revenues Over (Under) Expenditures - Budgetary Basis 227,330$ 1,189,346$ 320,049$ 304,899$ (578,964)$ 1,462,660$ 179,547$ 239,397$ 1,210,832$ 251,828$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay -$ 72,758$ 13,290$ -$ 25,364$ 111,412$ 108,214$ Depreciation Expense (750) (78,750) (1,725) (9,750) (93,750) (184,725) (184,725) IMRF Pension Expense (1,875) (7,500) (750) - (8,250) (18,375) (18,375) OPEB Expense (2,250) (11,250) - - (7,500) (21,000) (21,000) Total GAAP Adjustments (4,875)$ (24,742)$ 10,815$ (9,750)$ (84,136)$ (112,688)$ (115,886)$ Fund Increase/(Decrease) - GAAP Basis 222,455$ 1,164,604$ 330,864$ 295,149$ (663,100)$ 1,349,972$ 1,094,946$ *Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.