Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
10 - October 2023 Monthly Financial Report
VILLAGE OAK BROOKOF MONTHLY FINANCIAL REPORTS OCTOBER 2023 YTD YTD Net Fund Ending YTD YTD Increase Fund Balance Governmental Funds Revenues Expenditures (Decrease)(Deficit) General Fund (Major Fund)30,269,186$ 23,456,980$ 6,812,206$ 45,283,258$ Main operating fund of the Village. Hotel Fund (Major Fund)1,424,979$ 594,543$ 830,436$ 3,220,782$ Collects and spends resources from the 3% hotel/motel tax. Motor Fuel Tax Fund 351,650$ 103,678$ 247,972$ 1,945,510$ Collects and spends resources from the State motor fuel tax. Infrastructure Fund (Major Fund)7,676,435$ 2,775,904$ 4,900,531$ 13,783,025$ Accounts for construction and maintenance of roadways, drainage, and safety path systems. Promenade TIF Fund (Major Fund)461,507$ 341,566$ 119,941$ 433,565$ 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)9,268,395$ 6,579,341$ 2,689,054$ 21,565,264$ Collects user fees for the distribution of water and maintenance of infrastructure. Sports Core Fund (Major Fund)4,651,566$ 3,079,730$ 1,571,836$ 2,719,623$ 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,550,703$ 2,884,314$ (333,611)$ (358,992)$ Accounts for the Village's health insurance costs and the related contributions from the Village, employees, retirees, and other agencies. Garage Fund 580,096$ 504,911$ 75,185$ 328,456$ Accounts for the maintenance of the Village's vehicle fleet and the related departmental reimbursements. Equipment Replacement Fund 1,116,015$ 852,442$ 263,573$ 3,088,460$ 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, 2023 10/31/23 10/31/23 10/31/22 10/31/23 YTD % of YTD 2023 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax 15,055,045$ 14,657,709 13,333,333$ 109.9%16,000,000$ (397,336)$ State Income Tax 1,171,943 1,133,762 954,167 118.8%1,145,000 (38,181) Replacement Tax 972,409 835,637 375,000 222.8%450,000 (136,772) Road & Bridge Tax 20,935 28,004 29,167 96.0%35,000 7,069 Local Use Tax 269,202 272,209 250,000 108.9%300,000 3,007 Cannabis Use Tax 11,288 10,344 13,250 78.1%15,900 (944) Grants 25,151 588,397 13,052 4508.1%15,662 563,246 Utility/Telecom. Tax 4,664,049 4,130,307 4,685,833 88.1%5,623,000 (533,742) Licenses and Permits 1,956,203 3,620,576 1,625,404 222.7%1,950,485 1,664,373 Charges for Services 1,626,113 2,504,257 1,372,808 182.4%1,647,370 878,144 Investment Interest 249,857 943,698 166,667 566.2%200,000 693,841 Miscellaneous Income 553,803 892,857 852,959 104.7%1,023,551 339,054 Total Operating Revenues 26,575,998$ 29,617,757$ 23,671,640$ 125.1%28,405,969$ 3,041,759$ OPERATING EXPENDITURES Personnel 14,508,033$ 16,638,905$ 18,447,543$ 90.2%22,137,051$ 2,130,872$ Materials and Supplies 412,112 464,640 497,547 93.4%597,056 52,528$ Operation and Contract 3,448,599 4,075,876 4,503,935 90.5%5,404,722 627,277$ Other Expenditures 6,437 8,517 7,500 113.6%9,000 2,080$ Capital Outlay 322,437 769,042 792,145 97.1%950,575 446,605$ Total Operating Expenditures 18,697,618$ 21,956,980$ 24,248,670$ 90.5%29,098,405$ 3,259,362$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 7,878,380$ 7,660,777$ (577,030)$ -1327.6%(692,436)$ (217,603)$ INTERFUND TRANSACTIONS Transfers In -$ -$ -$ N/A -$ -$ Transfers Out - (1,500,000) N/A (1,500,000) Reimbursements From Other Funds 471,020 651,429 564,501 115.4%677,401 180,409 Reimbursements To Other Funds (91,570) - - N/A - 91,570 Total Interfund Transactions 379,450$ (848,571)$ 564,501$ -150.3%677,401$ (1,228,021)$ NET FUND INCREASE (DECREASE)8,257,830$ 6,812,206$ (12,529)$ (15,035)$ (1,445,624)$ Village of Oak Brook General Fund Financial Update For the Period Ending October 31, 2023 10/31/23 10/31/23 10/31/22 10/31/23 YTD % of YTD 2023 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Hotel Tax 1,071,594$ 1,348,981$ 958,333$ 140.8%1,150,000$ 277,387$ Investment Interest 16,724 73,998 10,000 740.0%12,000 57,274 Loan Interest 3,000 2,000 3,333 60.0%4,000 (1,000) Miscellaneous - - Total Operating Revenues 1,091,318$ 1,424,979$ 971,667$ 146.7%1,166,000$ 333,661$ EXPENDITURES Operation and Contract 378,547$ 303,304$ 562,163$ 54.0%674,595$ (75,243)$ Capital Outlay 52,696 - - N/A - (52,696) Total Expenditures 431,243$ 303,304$ 562,163$ 54.0%674,595$ (127,939)$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 660,075$ 1,121,675$ 409,504$ 273.9%491,405$ 461,600$ INTERFUND TRANSACTIONS Transfer Out -$ -$ -$ N/A -$ -$ Reimbursements to Other Funds (69,000) (291,239) (291,238) 100.0%(349,485) (222,239) Total Interfund Transactions (69,000)$ (291,239)$ (291,238)$ 100.0%(349,485)$ (222,239)$ NET FUND INCREASE (DECREASE)591,075$ 830,436$ 118,267$ 141,920$ 239,361$ Note - Expenditures are recorded in program 171. Village of Oak Brook Hotel Tax Fund Financial Update For the Period Ending October 31, 2023 10/31/23 10/31/23 10/31/22 10/31/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 6,211,289$ 6,246,560$ 5,437,500$ 114.9%6,525,000$ 35,271$ Charges for Services - - N/A -$ Investment Interest 77,590 246,475 22,917 1075.5%27,500 168,885 Grants 550,000 - 908,108 0.0%1,089,730 (550,000) Miscellaneous - 2,100 833 252.0%1,000 2,100 Total Operating Revenues 6,838,879$ 6,495,135$ 6,369,358$ 102.0%7,643,230$ (343,744)$ OPERATING EXPENDITURES Personnel 1,032,075$ 34,641$ 37,745$ 91.8%45,294$ (997,434)$ Materials and Supplies 150,135 159,091 164,500 96.7%197,400 8,956 Operation and Contract 985,109 726,663 1,441,817 50.4%1,730,180 (258,446) Other Expenditures - - - N/A - Capital Outlay 6,408,189 1,572,259 7,688,600 20.4%9,226,320 (4,835,930) Total Operating Expenditures 8,575,508$ 2,492,654$ 9,332,662$ 26.7%11,199,194$ (6,082,854)$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES (1,736,629)$ 4,002,481$ (2,963,303)$ -135.1%(3,555,964)$ 5,739,110$ INTERFUND TRANSACTIONS Transfers In -$ 1,000,000$ -$ N/A -$ 1,000,000$ Reimbursements From Other Funds 269,480 181,300 - N/A - (88,180) Reimbursements To Other Funds (98,440) (283,250) - N/A - (184,810) Total Interfund Transactions 171,040$ 898,050$ -$ N/A -$ 727,010$ NET FUND INCREASE (DECREASE)(1,565,589)$ 4,900,531$ (2,963,303)$ (3,555,964)$ 6,466,120$ Village of Oak Brook Infrastructure Fund Financial Update For the Period Ending October 31, 2023 10/31/23 10/31/23 10/31/22 10/31/23 YTD % of YTD 2023 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax -$ -$ 12,500$ 0.0%15,000$ -$ Real Estate Tax 411,855 455,450 337,500 134.9%405,000 43,595 Investment Interest 1,377 6,057 8 72684.0%10 4,680 Total Operating Revenues 413,232$ 461,507$ 350,008$ 131.9%420,010$ 48,275$ EXPENDITURES Operation and Contract 1,688$ 4,773$ 4,250$ 112.3%5,100$ 3,085$ Other Expenditures 486,260 336,793 280,604 120.0%336,725 (149,467) Total Expenditures 487,948$ 341,566$ 284,854$ 119.9%341,825$ (146,382)$ NET FUND INCREASE (DECREASE)(74,716)$ 119,941$ 65,154$ 78,185$ 194,657$ Note - Expenditures are recorded in program 283. Village of Oak Brook Promenade TIF Fund Financial Update For the Period Ending October 31, 2023 10/31/23 10/31/23 10/31/22 10/31/23 YTD % of YTD 2023 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Plan Review Fees 525$ 1,650$ 438$ 377.1%525$ 1,125$ Building/Inspection Fees 1,875 1,350 1,667 81.0%2,000 (525) Water Sales 9,539,792 8,198,599 6,858,333 119.5%8,230,000 (1,341,193) Unmetered Sales 92,643 39,136 41,667 93.9%50,000 (53,507) Water Connection Fees 579,830 140,530 62,500 224.8%75,000 (439,300) Meter Charges 22,319 16,449 12,500 131.6%15,000 (5,870) Special Services 13,388 25,741 8,333 308.9%10,000 12,353 Investment Interest 60,455 745,002 16,667 4470.0%20,000 684,547 Proceeds from Property Sale - - - N/A - - Miscellaneous 105,341 99,938 41,667 239.9%50,000 (5,403) Total Operating Revenues 10,416,168$ 9,268,395$ 7,043,771$ 131.6%8,452,525$ (1,147,773)$ OPERATING EXPENDITURES Personnel 363,033$ 558,230$ 539,683$ 103.4%647,620$ 195,197$ Materials and Supplies 63,464 92,843 58,042 160.0%69,650 29,379 Operation and Contract 4,714,615 4,601,809 4,500,521 102.3%5,400,625 (112,806) Capital Outlay 33,894 1,170,961 3,270,833 35.8%3,925,000 1,137,067 Total Expenditures 5,175,006$ 6,423,843$ 8,369,079$ 76.8%10,042,895$ 1,248,837$ Surplus (Deficit) of Revenues Over Expenditures 5,241,162$ 2,844,552$ (1,325,308)$ -214.6%(1,590,370)$ (2,396,610)$ INTERFUND TRANSACTIONS Reimbursements To Other Funds (350,410)$ (155,498)$ (350,408)$ 44.4%(420,490)$ 194,912$ Total Interfund Transactions (350,410)$ (155,498)$ (350,408)$ 44.4%(420,490)$ 194,912$ Fund Increase/(Decrease) - Budgetary Basis 4,890,752$ 2,689,054$ (1,675,717)$ (2,010,860)$ (2,201,698)$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay 33,894$ 1,170,961$ Depreciation Expense (383,333) (479,167) IMRF Pension Expense (30,000) (37,500) OPEB Expense (20,000) (25,000) Total GAAP Adjustments (399,439)$ 629,294$ Fund Increase/(Decrease) - GAAP Basis 4,491,313$ 3,318,348$ *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, 2023 Village of Oak Brook Monthly Operating Statement Sports Core Fund Consolidated Presentation For the Period Ending October 31, 2023 10/31/23 10/31/23 10/31/23 YTD % of YTD 2023 10/31/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$ 774,375$ 114.6%929,250$ 807,813$ 79,234$ Greens Fees - - - 1,414,566 1,414,566 1,091,667 129.6%1,310,000 1,206,113 208,453 Pro Shop Sales - - - 182,923 182,923 208,333 87.8%250,000 207,058 (24,135) Golf Lessons - - - 24,872 24,872 41,667 59.7%50,000 35,815 (10,943) Driving Range Fees - - - 401,496 401,496 291,667 137.7%350,000 354,137 47,359 Rentals - 213,580 133,465 470,309 817,354 903,333 90.5%1,084,000 981,187 (163,833) Programs/User Fees 104,649 - - - 104,649 57,583 181.7%69,100 84,890 19,759 Food Sales 53,070 - - 242,205 295,275 241,667 122.2%290,000 304,622 (9,347) Beverage Sales 18,909 - - 467,254 486,163 410,000 118.6%492,000 482,392 3,771 Taste of Oak Brook - - - - - - N/A - 66,812 (66,812) Grants - - - - - - N/A - - - Other Revenue 3,175 - - 34,046 37,221 23,021 161.7%27,625 19,308 17,913 Total Operating Revenues 586,750$ 213,580$ 133,465$ 3,717,771$ 4,651,566$ 4,043,313$ 115.0%4,851,975$ 4,550,148$ 101,418$ OPERATING EXPENDITURES Personnel 62,893$ -$ 9,693$ 1,194,194$ 1,266,780$ 1,440,267$ 88.0%1,671,380$ 1,263,459$ 3,321$ Materials & Supplies 55,694 1,064 10,264 579,578 646,600 685,032 94.4%718,900 734,608 (88,008) Operational & Contractual 469,400 39,876 64,364 343,041 916,681 629,847 145.5%942,765 915,648 1,033 Other - - - - - - N/A - - - Capital 1,405 - - 180,793 182,198 1,315,625 13.8%466,750 364,593 (182,395) Total Operating Expenditures 589,392$ 40,940$ 84,321$ 2,297,606$ 3,012,259$ 4,070,771$ 74.0%3,799,795$ 3,278,308$ (266,049)$ B&T Administration Overhead Allocation*36,486$ -$ (36,486)$ -$ -$ -$ N/A -$ -$ -$ Operating Revenues Over (Under) Expenditures 33,844$ 172,640$ 12,658$ 1,420,165$ 1,639,307$ (27,458)$ -5970.1%1,052,180$ 1,271,840$ 367,467$ 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 - - - Reimbursement From Water Fund - - - - - - N/A - - - Reimbursement To General Fund (47,229) - - (20,242) (67,471) (67,473) 100.0%(80,967) (62,880) (4,591) Total Interfund Transactions (47,229)$ -$ -$ (20,242)$ (67,471)$ 57,528$ -117.3%69,033$ (62,880)$ (4,591)$ Total Revenues Over (Under) Expenditures - Budgetary Basis (13,385)$ 172,640$ 12,658$ 1,399,923$ 1,571,836$ 30,069$ 1,121,213$ 1,208,960$ 362,877$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay 1,405$ -$ -$ 180,793$ 182,198$ 364,593$ Depreciation Expense (140,189) (1,404) (25,000) (205,250) (371,843) (371,843) IMRF Pension Expense (1,708) - (1,250) (20,417) (23,375) (23,375) OPEB Expense - - (1,250) (23,333) (24,583) (24,583) Total GAAP Adjustments (140,493)$ (1,404)$ (27,500)$ (68,207)$ (237,604)$ (55,209)$ Fund Increase/(Decrease) - GAAP Basis (153,878)$ 171,236$ (14,842)$ 1,331,716$ 1,334,233$ 1,153,751$ *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 October 31, 2023 10/31/23 10/31/23 822 10/31/23 YTD % of YTD 2023 10/31/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$ 432,708$ 94.0%519,250$ 402,838$ 4,109$ Programs/User Fees - 71,921 32,728 - 104,649 57,583.33 181.7%69,100 84,890 19,759 Food Sales - - - 53,070 53,070 33,333.33 159.2%40,000 44,287 - Beverage Sales - - - 18,909 18,909 14,166.67 133.5%17,000 17,712 - Grants - - - - - - N/A - - - Other Revenue 3,175 - - - 3,175 1,938 163.9%2,325 2,854 321 Total Operating Revenues 3,175$ 461,296$ 50,300$ 71,979$ 586,750$ 539,729$ 108.7%647,675$ 552,581$ 24,189$ OPERATING EXPENDITURES Personnel 233$ 34,935$ -$ 27,725$ 62,893$ 165,640$ 38.0%198,768$ 64,847$ (1,954)$ Materials & Supplies 200 40,900 2,014 12,580 55,694 59,830 93.1%71,796 69,234 (13,540) Operational & Contractual 52,448 347,867 64,312 4,773 469,400 205,821 228.1%246,985 306,292 163,108 Other - - - - - - N/A - - Capital 1,405 - - - 1,405 458,333 0.3%550,000 244,355 (242,950) Total Operating Expenditures 54,286$ 423,702$ 66,326$ 45,078$ 589,392$ 889,624$ 66.3%1,067,549$ 684,727$ (95,335)$ B&T Administration Overhead Allocation*72,973$ (26,269)$ (7,299)$ (2,919)$ 36,486$ -$ N/A 43,783$ 32,738$ 3,748$ Operating Revenues Over (Under) Expenditures 21,862$ 11,325$ (23,325)$ 23,982$ 33,844$ (349,895)$ -9.7%(376,092)$ (99,409)$ 123,272$ Transfer From General Fund - - - - - - N/A - - - Reimbursement From Infrastructure Fund - - - - - -$ N/A - - - Reimbursement From Water Fund - - - - - - N/A - - - Reimbursement To General Fund (47,229) - - - (47,229) (16,868) 280.0%(20,242) (15,720) (31,509) Total Interfund Transactions (47,229)$ -$ -$ -$ (47,229)$ (16,868)$ 280.0%(20,242)$ (15,720)$ (31,509)$ Total Revenues Over (Under) Expenditures - Budgetary Basis (25,367)$ 11,325$ (23,325)$ 23,982$ (13,385)$ (366,764)$ (396,334)$ (115,129)$ 91,763$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay 1,405$ -$ -$ -$ 1,405$ 244,355$ 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 (53,894)$ (83,333)$ (2,250)$ (1,015)$ (140,493)$ 102,457$ Fund Increase/(Decrease) - GAAP Basis (79,261)$ (72,008)$ (25,575)$ 22,967$ (153,878)$ (12,671)$ *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, 2023 10/31/23 10/31/23 10/31/23 YTD % of YTD 2023 10/31/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$ 150,833$ 84.5%181,000$ 143,893$ (16,393)$ Range Rentals - 86,080 86,080 70,833 121.5%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$ 221,667$ 96.4%266,000$ 290,705$ (10,313)$ OPERATING EXPENDITURES Personnel -$ -$ -$ -$ N/A -$ -$ Materials & Supplies - 1,064 1,064 7,908 13.5%9,490$ - 1,064 Operational & Contractual 5 39,871 39,876 104,950 38.0%125,940 218,250 (178,374) Capital - - - - N/A - - Total Operating Expenditures 5$ 40,935$ 40,940$ 112,858$ 36.3%135,430$ 218,250$ (177,310)$ Operating Revenues Over (Under) Expenditures (5)$ 172,645$ 172,640$ 108,808$ 158.7%130,570$ 72,455$ 166,997$ INTERFUND TRANSACTIONS Transfer From Hotel Tax Fund -$ -$ -$ -$ N/A -$ -$ -$ Total Interfund Transactions -$ -$ -$ -$ N/A -$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis (5)$ 172,645$ 172,640$ 108,808$ 130,570$ 72,455$ 166,997$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ -$ -$ -$ Depreciation Expense - (1,404) (1,404) (1,404) Total GAAP Adjustments -$ (1,404)$ (1,404)$ (1,404)$ Fund Increase/(Decrease) - GAAP Basis (5)$ 171,241$ 171,236$ 71,051$ *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, 2023 10/31/23 10/31/23 821 YTD % of YTD 2023 10/31/22 Difference B&T Amended Amended Adopted YTD Prior Clubhouse Budget Budget Budget Total Year OPERATING REVENUES Rentals 133,465$ 291,667$ 45.8%350,000$ 321,619$ (188,154)$ Other Revenue - - 0.0%- - - Total Operating Revenues 133,465$ 291,667$ 45.8%350,000$ 321,619$ (188,154)$ OPERATING EXPENDITURES Personnel 9,693$ 119,128$ N/A 142,954$ 107,207$ (97,514)$ Materials & Supplies 10,264 19,977 51.4%23,972 6,427 3,837 Operational & Contractual 64,364 64,035 100.5%76,842 67,782 (3,418) Capital - - N/A - - - Total Operating Expenditures 84,321$ 203,139$ 41.5%243,767$ 181,416$ (97,095)$ B&T Administration Overhead Allocation*(36,486)$ -$ N/A (43,784)$ (32,738)$ (3,748)$ Operating Revenues Over (Under) Expenditures 12,658$ 88,527$ 14.3%62,449$ 107,465$ (94,807)$ INTERFUND TRANSACTIONS Transfer From General Fund -$ -$ 0.0%-$ -$ -$ Total Interfund Transactions -$ -$ 0.0%-$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis 12,658$ 88,527$ 62,449$ 107,465$ (94,807)$ 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 (14,842)$ 79,965$ *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, 2023 10/31/23 10/31/23 823 831 832 833 834 10/31/23 YTD % of YTD 2023 10/31/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$ 341,667$ 140.5%410,000$ 404,975$ 75,125$ Greens Fees - 1,414,566 - - - 1,414,566 1,091,667 129.6%1,310,000 1,206,113 208,453 Pro Shop Sales - 182,923 - - - 182,923 208,333 87.8%250,000 207,058 (24,135) Golf Lessons - - 24,872 - - 24,872 41,667 59.7%50,000 35,815 (10,943) Driving Range Fees - - 401,496 - - 401,496 291,667 137.7%350,000 354,137 47,359 Rentals - 1,890 - 468,419 - 470,309 390,000 120.6%468,000 435,675 34,634 Food Sales 242,205 - - - 242,205 208,333 116.3%250,000 260,335 (18,130) Beverage Sales 467,254 - - - - 467,254 395,833 118.0%475,000 464,681 2,573 Other Revenue 17,554 16,492 - - - 34,046 21,083 161.5%25,300 16,454 17,592 Total Operating Revenues 727,013$ 2,095,971$ 426,368$ 468,419$ -$ 3,717,771$ 2,990,250$ 124.3%3,588,300$ 3,385,243$ 332,528$ OPERATING EXPENDITURES Personnel 204,205$ 464,533$ 64,433$ 65,490$ 395,533$ 1,194,194$ 1,155,498$ 103.3%1,386,598$ 1,091,405$ 102,789$ Materials & Supplies 274,617 95,214 14,812 3,033 191,902 579,578 597,317 97.0%716,780 658,947 (79,369) Operational & Contractual 7,372 224,007 10,896 61,388 39,378 343,041 255,042 134.5%306,050 323,325 19,717 Other - - - - - - - N/A - - - Capital - 72,758 13,290 - 94,745 180,793 857,292 21.1%1,028,751 120,238 60,555 Total Operating Expenditures 486,194$ 856,512$ 103,431$ 129,911$ 721,558$ 2,297,606$ 2,865,149$ 80.2%3,438,178$ 2,193,915$ 103,691$ Operating Revenues Over (Under) Expenditures 240,819$ 1,239,459$ 322,937$ 338,508$ (721,558)$ 1,420,165$ 125,101$ 1135.2%150,122$ 1,191,328$ 228,837$ INTERFUND TRANSACTIONS Transfer from Golf Surcharge -$ -$ -$ -$ -$ -$ 125,000$ 0.0%150,000$ -$ -$ Reimbursement to General Fund - (20,242) - - - (20,242) (50,604) 40.0%(60,725) (47,160) 26,918 Total Interfund Transactions -$ (20,242)$ -$ -$ -$ (20,242)$ 74,396$ -27.2%89,275$ (47,160)$ 26,918$ Total Revenues Over (Under) Expenditures - Budgetary Basis 240,819$ 1,219,217$ 322,937$ 338,508$ (721,558)$ 1,399,923$ 199,497$ 239,397$ 1,144,168$ 255,755$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay -$ 72,758$ 13,290$ -$ 94,745$ 180,793$ 120,238$ 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)$ (35,575)$ 10,540$ (10,833)$ (26,922)$ (68,207)$ (128,762)$ Fund Increase/(Decrease) - GAAP Basis 235,402$ 1,183,642$ 333,477$ 327,675$ (748,480)$ 1,331,716$ 1,015,406$ *Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.