The URL can be used to link to this page

Home My WebLink About12 - December 2024 Monthly Financial ReportVILLAGE OAK BROOKOF MONTHLY FINANCIAL REPORTS DECEMBER 2024 Estimated YTD YTD Net Fund Ending YTD YTD Increase Fund Balance Governmental Funds Revenues Expenditures (Decrease)(Deficit) General Fund (Major Fund)33,067,388$ 31,793,301$ 1,274,087$ 43,899,475$ Main operating fund of the Village. Hotel Fund (Major Fund)1,897,739$ 351,759$ 1,545,980$ 5,317,177$ Collects and spends resources from the 3% hotel/motel tax. Motor Fuel Tax Fund 463,498$ 89,327$ 374,171$ 2,396,273$ Collects and spends resources from the State motor fuel tax. Infrastructure Fund (Major Fund)8,618,759$ 2,688,126$ 5,930,633$ 20,355,140$ Accounts for construction and maintenance of roadways, drainage, and safety path systems. Enterprise Funds Water Fund (Major Fund)13,476,307$ 11,326,558$ 2,149,749$ 24,068,392$ Collects user fees for the distribution of water and maintenance of infrastructure. Sports Core Fund (Major Fund)4,994,371$ 4,675,983$ 318,388$ 3,222,276$ Accounts for revenues and expenses relating to administration, programs, food and beverage operations, and golf course. Internal Service Funds Insurance Fund 2,904,947$ 3,050,621$ (145,674)$ 419,769$ Accounts for the Village's health insurance costs and the related contributions from the Village, employees, retirees, and other agencies. Garage Fund 745,103$ 612,757$ 132,346$ 478,821$ Accounts for the maintenance of the Village's vehicle fleet and the related departmental reimbursements. Equipment Replacement Fund 1,407,317$ 1,130,079$ 277,237$ 3,325,194$ Accounts for the replacement of the Village's vehicle fleet and the related departmental contributions. 11,856,917$ Further information on the Village's major funds (as indicated above) can be found on the proceeding pages. Executive Summary on Village Funds Through December 31, 2024 12/31/24 12/31/24 12/31/23 12/31/24 YTD % of YTD 2024 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax 17,498,014$ 17,917,391 16,496,604$ 108.6%16,496,604$ 419,378$ State Income Tax 1,303,915 1,386,575 1,311,000 105.8%1,311,000 82,660 Replacement Tax 869,774 521,793 751,015 69.5%751,015 (347,982) Road & Bridge Tax 37,643 40,074 35,000 114.5%35,000 2,431 Local Use Tax 320,810 305,750 336,000 91.0%336,000 (15,060) Cannabis Use Tax 12,361 13,033 13,180 98.9%13,180 672 Grants 717,733 312,652 165,662 188.7%165,662 (405,081) Utility/Telecom. Tax 4,286,590 3,116,055 4,600,000 67.7%4,600,000 (1,170,535) Licenses and Permits 3,843,934 2,161,436 2,247,810 96.2%2,247,810 (1,682,498) Charges for Services 2,298,448 3,075,601 2,174,650 141.4%2,174,650 777,153 Investment Interest 1,811,615 1,971,450 450,000 438.1%450,000 159,835 Miscellaneous Income 2,246,763 1,369,638 916,070 149.5%916,070 (877,125) Total Operating Revenues 35,247,600$ 32,191,448$ 29,496,991$ 109.1%29,496,991$ (3,056,152)$ OPERATING EXPENDITURES Personnel 23,085,388$ 24,048,912$ 22,565,214$ 106.6%22,565,214$ 963,524$ Materials and Supplies 608,023 589,896 661,594 89.2%661,594 (18,127)$ Operation and Contract 4,895,041 5,787,145 6,324,313 91.5%6,324,313 892,104$ Other Expenditures 8,517 824,958 9,900 8332.9%9,900 816,441$ Capital Outlay 1,142,730 542,390 663,107 81.8%663,107 (600,340)$ Total Operating Expenditures 29,739,699$ 31,793,301$ 30,224,129$ 105.2%30,224,129$ 2,053,602$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 5,507,901$ 398,147$ (727,137)$ -54.8%(727,137)$ (5,109,754)$ INTERFUND TRANSACTIONS Transfers In -$ -$ -$ N/A -$ -$ Transfers Out 1,500,000 N/A (1,500,000) Reimbursements From Other Funds 716,572 875,940 875,938 100.0%875,938 159,368 Reimbursements To Other Funds - - 100,000 0.0%100,000 - Sports Core Loan N/A - - Total Interfund Transactions 2,216,572$ 875,940$ 975,938$ 89.8%975,938$ (1,340,632)$ NET FUND INCREASE (DECREASE)7,724,473$ 1,274,087$ 248,801$ 248,801$ (6,450,386)$ Village of Oak Brook General Fund Financial Update For the Period Ending December 31, 2024 12/31/24 12/31/24 12/31/23 12/31/24 YTD % of YTD 2024 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Hotel Tax 1,576,776$ 1,688,948$ 1,450,000$ 116.5%1,450,000$ 112,171$ Investment Interest 138,687 206,792 25,000 827.2%25,000 68,104 Loan Interest 4,000 2,000 2,000 100.0%2,000 (2,000) Miscellaneous 100,000 - - - (100,000) Total Operating Revenues 1,819,464$ 1,897,739$ 1,477,000$ 128.5%1,477,000$ 78,276$ EXPENDITURES Personnel -$ 64,863$ 14,928$ 434.5%-$ 64,863$ Operation and Contract 418,249 33,961 705,045 4.8%705,045 (384,289) Capital Outlay - 9,023 275,000 3.3%275,000 9,023 Total Expenditures 418,249$ 107,847$ 994,973$ 10.8%980,045$ (310,402)$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 1,401,214$ 1,789,892$ 496,955$ 360.2%496,955$ 388,678$ INTERFUND TRANSACTIONS Transfer Out -$ -$ -$ N/A -$ -$ Reimbursements to Other Funds (320,363) (243,912) (243,915) 100.0%(243,915) 76,451 Total Interfund Transactions (320,363)$ (243,912)$ (243,915)$ 100.0%(243,915)$ 76,451$ NET FUND INCREASE (DECREASE)1,080,851$ 1,545,980$ 253,040$ 253,040$ 465,129$ Note - Expenditures are recorded in program 171. Village of Oak Brook Hotel Tax Fund Financial Update For the Period Ending December 31, 2024 12/31/24 12/31/24 12/31/23 12/31/24 YTD % of YTD 2024 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Non-Home Rule Sales Tax 7,528,765$ 7,738,573$ 6,703,000$ 115.4%6,703,000$ 209,808$ Charges for Services - - - N/A -$ Investment Interest 562,842 877,391 125,000 701.9%125,000 314,549 Grants - - - N/A - - Miscellaneous 102,362 2,795 23,000 12.2%23,000 (99,567) Total Operating Revenues 8,193,969$ 8,618,759$ 6,851,000$ 125.8%6,851,000$ 424,790$ OPERATING EXPENDITURES Personnel 37,091$ 22,871$ -$ N/A -$ (14,219)$ Materials and Supplies 161,277 19,571 46,500 42.1%46,500 (141,706) Operation and Contract 987,608 1,210,499 1,742,968 69.5%1,742,968 222,890 Other Expenditures - - 339,899 0.0%339,899 - Capital Outlay 1,999,234 1,403,181 3,383,775 41.5%3,383,775 (596,053) Total Operating Expenditures 3,185,209$ 2,656,122$ 5,513,142$ 48.2%5,513,142$ (529,088)$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 5,008,759$ 5,962,637$ 1,337,858$ 445.7%1,337,858$ 953,878$ INTERFUND TRANSACTIONS Transfers In 1,000,000$ -$ -$ N/A -$ (1,000,000)$ Reimbursements From Other Funds 199,430 - - N/A - (199,430) Reimbursements To Other Funds (311,575) (32,004) - N/A - 279,571 Total Interfund Transactions 887,855$ (32,004)$ -$ N/A -$ (919,859)$ NET FUND INCREASE (DECREASE)5,896,615$ 5,930,633$ 1,337,858$ 1,337,858$ 34,018$ Village of Oak Brook Infrastructure Fund Financial Update For the Period Ending December 31, 2024 12/31/24 12/31/24 12/31/23 12/31/24 YTD % of YTD 2024 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Plan Review Fees 1,725$ 1,877$ 525$ 357.5%525$ 152$ Building/Inspection Fees 1,350 - 2,000 0.0%2,000 (1,350) Water Sales 9,717,533 10,677,338 10,720,000 99.6%10,720,000 959,804 Unmetered Sales 56,465 51,579 65,000 79.4%65,000 (4,886) Water Connection Fees 153,640 80,500 140,000 57.5%140,000 (73,140) Fire Service Charge - - - N/A - - Meter Charges 17,828 15,140 17,300 87.5%17,300 (2,688) Special Services 27,392 30,108 10,000 301.1%10,000 2,716 Investment Interest 1,150,165 1,387,584 350,000 396.5%350,000 237,419 Grants - 1,090,855 - N/A - 1,090,855 Miscellaneous 109,291 141,327 1,149,730 12.3%1,149,730 32,036 Total Operating Revenues 11,235,390$ 13,476,307$ 12,454,555$ 108.2%12,454,555$ 2,240,918$ OPERATING EXPENDITURES Personnel 704,276$ 596,784$ 786,413$ 75.9%786,413$ (107,493)$ Materials and Supplies 102,489 127,765 137,216 93.1%137,216 25,276 Operation and Contract 5,870,474 6,101,682 7,101,369 85.9%7,101,369 231,207 Capital Outlay 1,170,961 4,063,443 5,690,000 71.4%5,690,000 2,892,483 Total Expenditures 7,848,201$ 10,889,674$ 13,714,999$ 79.4%13,714,999$ 3,041,473$ Surplus (Deficit) of Revenues Over Expenditures 3,387,189$ 2,586,633$ (1,260,444)$ -205.2%(1,260,444)$ (800,556)$ INTERFUND TRANSACTIONS Reimbursements To Other Funds (171,048)$ (436,884)$ (436,879)$ 100.0%(436,879)$ (265,836)$ Total Interfund Transactions (171,048)$ (436,884)$ (436,879)$ 100.0%(436,879)$ (265,836)$ Fund Increase/(Decrease) - Budgetary Basis 3,216,141$ 2,149,749$ (1,697,323)$ (1,697,323)$ (1,066,391)$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay 1,170,961$ 4,063,443$ Depreciation Expense (191,667) (575,000) IMRF Pension Expense (15,000) (45,000) OPEB Expense (10,000) (30,000) Total GAAP Adjustments 954,294$ 3,413,443$ Fund Increase/(Decrease) - GAAP Basis 4,170,435$ 5,563,193$ *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 December 31, 2024 Village of Oak Brook Monthly Operating Statement Sports Core Fund Consolidated Presentation For the Period Ending December 31, 2024 12/31/24 12/31/24 12/31/24 YTD % of YTD 2024 12/31/23 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 431,143$ -$ -$ 393,375$ 824,518$ 950,725$ 86.7%950,725$ 887,047$ (62,530)$ Greens Fees - - - 1,760,471 1,760,471 1,405,000 125.3%1,405,000 1,430,805 329,666 Golf Surcharge - - - 236,378 236,378 53,143 444.8%53,143 142,980 93,398 Pro Shop Sales - - - 167,281 167,281 218,000 76.7%218,000 195,557 (28,276) Golf Lessons - - - 35,035 35,035 45,000 77.9%45,000 24,872 10,163 Driving Range Fees - - - 534,640 534,640 390,000 137.1%390,000 402,126 132,514 Rentals - 193,680 145,355 706,144 1,045,179 998,200 104.7%998,200 926,182 118,997 Programs/User Fees 141,969 - - - 141,969 109,800 129.3%109,800 114,020 27,948 Food Sales 8,587 - - 77,435 86,022 47,900 179.6%47,900 295,170 (209,149) Beverage Sales - - - 13,039 13,039 77,650 16.8%77,650 503,554 (490,515) Taste of Oak Brook - - - - - - N/A - - - Grants - - - - - - N/A - - - Other Revenue 97,291 - - 12,541 109,833 99,160 110.8%99,160 50,817 59,015 Total Operating Revenues 678,989$ 193,680$ 145,355$ 3,936,339$ 4,954,363$ 4,394,578$ 112.7%4,394,578$ 4,973,132$ (18,769)$ OPERATING EXPENDITURES Personnel 237,164$ -$ -$ 1,186,247$ 1,423,411$ 1,394,980$ 102.0%1,671,380$ 1,453,519$ (30,108)$ Materials & Supplies 39,749 - 7,454 399,337 446,540 433,253 103.1%718,900 787,761 (341,220) Operational & Contractual 564,998 45,452 46,615 390,268 1,047,332 1,084,243 96.6%942,765 936,747 110,586 Other - - - - - - N/A - - - Capital 732,087 - - 823,465 1,555,551 1,076,255 144.5%466,750 231,855 1,323,697 Total Operating Expenditures 1,573,998$ 45,452$ 54,069$ 2,799,316$ 4,472,835$ 3,988,730$ 112.1%3,799,795$ 3,409,881$ 1,062,954$ B&T Administration Overhead Allocation*37,457$ -$ (12,500)$ (24,957)$ -$ (24,957)$ N/A (24,957) -$ (24,957)$ Operating Revenues Over (Under) Expenditures (857,552)$ 148,228$ 78,786$ 1,112,066$ 481,528$ 380,890$ 126.4%569,826$ 1,563,250$ (1,106,679)$ INTERFUND TRANSACTIONS Interfund Loan**-$ -$ -$ -$ -$ -$ N/A -$ -$ -$ Transfer From General Fund - - - - - - N/A - - - Reimbursement From Infrastructure Fund - - - - - - N/A - - - Reimbursement From Water Fund 40,008 - - - 40,008 40,000 100.0%40,000 - 40,008 Reimbursement To General Fund (50,784) - - (152,364) (203,148) (199,587) 101.8%(199,587) (74,218) (128,930) Total Interfund Transactions (10,776)$ -$ -$ (152,364)$ (163,140)$ (159,587)$ 102.2%(159,587)$ (74,218)$ (88,922)$ Total Revenues Over (Under) Expenditures - Budgetary Basis (868,328)$ 148,228$ 78,786$ 959,702$ 318,388$ 221,303$ 410,239$ 1,489,032$ (1,195,601)$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay 732,087$ -$ -$ 823,465$ 1,555,551$ 231,855$ Depreciation Expense (168,227) (1,685) (25,000) (246,300) (441,212) (441,212) IMRF Pension Expense (2,050) - (1,250) (24,500) (27,800) (27,800) OPEB Expense - - (1,250) (28,000) (29,250) (29,250) Total GAAP Adjustments 561,810$ (1,685)$ (27,500)$ 524,665$ 1,057,289$ (266,407)$ Fund Increase/(Decrease) - GAAP Basis (306,518)$ 146,543$ 51,286$ 1,484,367$ 1,375,677$ 1,222,625$ *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 December 31, 2024 12/31/24 12/31/24 822 12/31/24 YTD % of YTD 2024 12/31/23 Difference 811 812 813 Poolside YTD Adopted Amended Adopted YTD Prior B&T Admin Swimming Tennis Café Total Budget Budget Budget Total Year OPERATING REVENUES Memberships -$ 403,800$ 27,343$ -$ 431,143$ 442,775$ 97.4%442,775$ 406,947$ 24,196$ Programs/User Fees - 80,163 61,806 - 141,969 109,800.00 129.3%109,800 114,020 27,948 Food Sales - - - 8,587 8,587 6,000.00 143.1%6,000 48,507 - Beverage Sales - - - - - 2,400.00 0.0%2,400 18,909 - Grants - - - - - - N/A - - - Other Revenue 87,691 - 2,350 7,250 97,291 90,160 107.9%90,160 16,390 80,901 Total Operating Revenues 87,691$ 483,963$ 91,498$ 15,837$ 678,989$ 651,135$ 104.3%651,135$ 604,773$ 133,045$ OPERATING EXPENDITURES Personnel 185,664$ 51,500$ -$ -$ 237,164$ 251,888$ 94.2%251,888$ 63,970$ 173,194$ Materials & Supplies 21 22,594 15,470 1,665 39,749 45,380 87.6%45,380 64,421 (24,672) Operational & Contractual 175,856 290,828 97,551 763 564,998 573,034 98.6%573,034 445,966 119,032 Other - - - - - - N/A - - - Capital 637,131 94,956 - - 732,087 874,500 83.7%874,500 38,207 693,880 Total Operating Expenditures 998,671$ 459,878$ 113,021$ 2,428$ 1,573,998$ 1,744,801$ 90.2%1,744,801$ 612,564$ 961,434$ B&T Administration Overhead Allocation*104,500$ (41,118)$ (11,425)$ (14,500)$ 37,457$ -$ N/A 37,457$ 43,784$ (6,327)$ Operating Revenues Over (Under) Expenditures (806,480)$ (17,034)$ (32,947)$ (1,091)$ (857,552)$ (1,093,667)$ 78.4%(1,056,210)$ 35,993$ (834,716)$ Transfer From General Fund -$ -$ -$ -$ -$ -$ N/A - - Reimbursement From Infrastructure Fund - - - - - - N/A - - - Reimbursement From Water Fund 40,008 - - - 40,008 40,000 100.0%40,000 - 40,008 Reimbursement To General Fund (50,784) - - - (50,784) (47,229) 107.5%(47,229) (53,976) 3,192 Total Interfund Transactions (10,776)$ -$ -$ -$ (10,776)$ (7,229)$ 149.1%(7,229)$ (53,976)$ 43,200$ Total Revenues Over (Under) Expenditures - Budgetary Basis (817,256)$ (17,034)$ (32,947)$ (1,091)$ (868,328)$ (1,100,896)$ (1,063,439)$ (17,983)$ (791,516)$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay 637,131$ 94,956$ -$ -$ 732,087$ 38,207$ Depreciation Expense (64,359) (100,000) (2,700) (1,168) (168,227) (168,227) IMRF Pension Expense (2,000) - - (50) (2,050) (2,050) Total GAAP Adjustments 570,772$ (5,044)$ (2,700)$ (1,218)$ 561,810$ (132,070)$ Fund Increase/(Decrease) - GAAP Basis (246,484)$ (22,078)$ (35,647)$ (2,309)$ (306,518)$ (150,053)$ *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 December 31, 2024 12/31/24 12/31/24 12/31/24 YTD % of YTD 2024 12/31/23 Difference 815 816 YTD Amended Amended Adopted YTD Prior Polo Open Fields Total Budget Budget Budget Total Year OPERATING REVENUES Field Rentals -$ 193,680$ 193,680 193,000$ 100.4%193,000$ 189,003$ 4,676$ Range Rentals - - - - N/A - 86,080 (86,080) Taste of Oak Brook - - - - N/A - - - Other Revenue - - - - N/A - - - Total Operating Revenues -$ 193,680$ 193,680$ 193,000$ 100.4%193,000$ 275,083$ (81,404)$ OPERATING EXPENDITURES Personnel -$ -$ -$ -$ N/A -$ -$ Materials & Supplies - - - 9,490 0.0%9,490$ 1,064 (1,064) Operational & Contractual - 45,452 45,452 76,050 59.8%76,050 42,488 2,964 Other - - - - N/A - - - Capital - - - 46,000 0.0%46,000 - - Total Operating Expenditures -$ 45,452$ 45,452$ 131,540$ 34.6%131,540$ 43,552$ 1,900$ Operating Revenues Over (Under) Expenditures -$ 148,228$ 148,228$ 61,460$ 241.2%61,460$ 231,531$ (83,303)$ INTERFUND TRANSACTIONS Transfer From Hotel Tax Fund -$ -$ -$ -$ N/A -$ -$ -$ Total Interfund Transactions -$ -$ -$ -$ N/A -$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis -$ 148,228$ 148,228$ 61,460$ 61,460$ 231,531$ (83,303)$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ -$ -$ -$ Depreciation Expense - (1,685) (1,685) (1,685) Total GAAP Adjustments -$ (1,685)$ (1,685)$ (1,685)$ Fund Increase/(Decrease) - GAAP Basis -$ 146,543$ 146,543$ 229,846$ *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 December 31, 2024 12/31/24 12/31/24 821 YTD % of YTD 2024 12/31/23 Difference B&T Amended Amended Adopted YTD Prior Clubhouse Budget Budget Budget Total Year OPERATING REVENUES Rentals 145,355$ 233,000$ 62.4%233,000$ 151,968$ (6,613)$ Other Revenue - - 0.0%- - - Total Operating Revenues 145,355$ 233,000$ 62.4%233,000$ 151,968$ (6,613)$ OPERATING EXPENDITURES Personnel -$ -$ N/A -$ 15,039$ (15,039)$ Materials & Supplies 7,454 13,750 54.2%13,750 14,046 (6,592) Operational & Contractual 46,615 52,978 88.0%52,978 69,875 (23,260) Capital - - N/A - - - Total Operating Expenditures 54,069$ 66,728$ 81.0%66,728$ 98,961$ (44,891)$ B&T Administration Overhead Allocation*(12,500)$ -$ N/A (12,500)$ (43,784)$ 31,284$ Operating Revenues Over (Under) Expenditures 78,786$ 166,272$ 47.4%153,772$ 9,224$ 69,562$ INTERFUND TRANSACTIONS Transfer From General Fund -$ -$ 0.0%-$ -$ -$ Total Interfund Transactions -$ -$ 0.0%-$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis 78,786$ 166,272$ 153,772$ 9,224$ 69,562$ 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 51,286$ (18,276)$ *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 December 31, 2024 12/31/24 12/31/24 823 831 832 833 834 12/31/24 YTD % of YTD 2024 12/31/23 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 -$ 393,375$ -$ -$ -$ 393,375$ 507,950$ 77.4%507,950$ 480,100$ (86,725)$ Greens Fees - 1,760,471 - - - 1,760,471 1,405,000 125.3%1,405,000 1,430,805 329,666 Surcharge - 236,378 236,378 53,143 444.8%53,143 142,980 93,398 Pro Shop Sales - 167,281 - - - 167,281 218,000 76.7%218,000 195,557 (28,276) Golf Lessons - - 35,035 - - 35,035 45,000 77.9%45,000 24,872 10,163 Driving Range Fees - - 534,640 - - 534,640 390,000 137.1%390,000 402,126 132,514 Rentals 29,250 3,420 68,412 605,062 - 706,144 572,200 123.4%572,200 499,131 207,013 Food Sales 77,435 - - - - 77,435 41,900 184.8%41,900 246,663 (169,228) Beverage Sales 13,039 - - - - 13,039 75,250 17.3%75,250 484,645 (471,606) Other Revenue - 12,541 - - - 12,541 9,000 139.3%9,000 34,427 (21,886) Total Operating Revenues 119,724$ 2,573,466$ 638,087$ 605,062$ -$ 3,936,339$ 3,317,443$ 118.7%3,317,443$ 3,941,307$ (4,968)$ OPERATING EXPENDITURES Personnel 5,184$ 354,355$ 63,030$ 80,773$ 682,905$ 1,186,247$ 1,143,092$ 103.8%1,143,092$ 1,374,510$ (188,263)$ Materials & Supplies (874) 202,581 19,898 1,274 176,458 399,337 364,633 109.5%364,633 708,229 (308,893) Operational & Contractual 3,912 256,579 46,904 32,959 49,914 390,268 382,181 102.1%382,181 378,418 11,850 Other - - - - - N/A - - - Capital - 11,260 - 671,600 140,605 823,465 155,755 528.7%155,755 193,648 629,817 Total Operating Expenditures 8,222$ 824,775$ 129,831$ 786,606$ 1,049,882$ 2,799,316$ 2,045,661$ 136.8%2,045,661$ 2,654,805$ 144,511$ Operating Revenues Over (Under) Expenditures 111,502$ 1,748,691$ 508,256$ (181,544)$ (1,049,882)$ 1,137,023$ 1,271,782$ 89.4%1,271,782$ 1,286,502$ (149,479)$ INTERFUND TRANSACTIONS Overhead Charge -$ (24,957)$ -$ -$ -$ (24,957)$ (24,957)$ 100.0%(24,957)$ -$ (24,957)$ Transfers from Other Fund - - - - - - - 0.0%150,000 - - Reimbursement to General Fund - (152,364) - - - (152,364) (152,358) 100.0%(152,358) (20,242) (132,122) Total Interfund Transactions -$ (177,321)$ -$ -$ -$ (177,321)$ (177,315)$ 100.0%(27,315)$ (20,242)$ (157,079)$ Total Revenues Over (Under) Expenditures - Budgetary Basis 111,502$ 1,571,370$ 508,256$ (181,544)$ (1,049,882)$ 959,702$ 1,094,467$ 1,244,467$ 1,266,260$ (306,558)$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay -$ 11,260$ -$ 671,600$ 140,605$ 823,465$ 193,648$ Depreciation Expense (1,000) (105,000) (2,300) (13,000) (125,000) (246,300) (246,300) IMRF Pension Expense (2,500) (10,000) (1,000) - (11,000) (24,500) (24,500) OPEB Expense (3,000) (15,000) - - (10,000) (28,000) (28,000) Total GAAP Adjustments (6,500)$ (118,740)$ (3,300)$ 658,600$ (5,396)$ 524,665$ (105,152)$ Fund Increase/(Decrease) - GAAP Basis 105,002$ 1,452,630$ 504,956$ 477,056$ (1,055,277)$ 1,484,367$ 1,161,108$ *Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.