The URL can be used to link to this page

Home My WebLink About11 - November 2024 Monthly Financial ReportVILLAGE OAK BROOK OF MONTHLY FINANCIAL REPORTS NOVEMBER 2024 Estimated YTD YTD Net Fund Ending YTD YTD Increase Fund Balance Governmental Funds Revenues Expenditures (Decrease)(Deficit) General Fund (Major Fund)30,061,556$ 26,045,228$ 4,016,328$ 46,641,717$ Main operating fund of the Village. Hotel Fund (Major Fund)1,723,669$ 317,814$ 1,405,855$ 5,177,053$ Collects and spends resources from the 3% hotel/motel tax. Motor Fuel Tax Fund 388,799$ 89,327$ 299,472$ 2,321,574$ Collects and spends resources from the State motor fuel tax. Infrastructure Fund (Major Fund)7,764,892$ 1,578,978$ 6,185,915$ 20,610,422$ Accounts for construction and maintenance of roadways, drainage, and safety path systems. Enterprise Funds Water Fund (Major Fund)12,829,975$ 10,789,836$ 2,040,139$ 23,958,781$ Collects user fees for the distribution of water and maintenance of infrastructure. Sports Core Fund (Major Fund)4,937,275$ 4,526,416$ 410,859$ 3,314,747$ Accounts for revenues and expenses relating to administration, programs, food and beverage operations, and golf course. Internal Service Funds Insurance Fund 2,659,398$ 2,803,424$ (144,026)$ 421,417$ Accounts for the Village's health insurance costs and the related contributions from the Village, employees, retirees, and other agencies. Garage Fund 682,894$ 531,387$ 151,507$ 497,982$ Accounts for the maintenance of the Village's vehicle fleet and the related departmental reimbursements. Equipment Replacement Fund 1,282,587$ 782,718$ 499,869$ 3,547,826$ Accounts for the replacement of the Village's vehicle fleet and the related departmental contributions. 14,865,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 November 30, 2024 11/30/24 11/30/24 11/30/23 11/30/24 YTD % of YTD 2024 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax 16,236,309$ 16,346,667 15,121,887$ 108.1%16,496,604$ 110,358$ State Income Tax 1,229,048 1,314,753 1,201,750 109.4%1,311,000 85,706 Replacement Tax 833,637 500,101 688,430 72.6%751,015 (333,537) Road & Bridge Tax 28,210 39,750 32,083 123.9%35,000 11,540 Local Use Tax 296,996 279,251 308,000 90.7%336,000 (17,745) Cannabis Use Tax 11,362 12,009 12,082 99.4%13,180 647 Grants 596,068 310,940 151,857 204.8%165,662 (285,128) Utility/Telecom. Tax 4,450,352 2,777,215 4,216,667 65.9%4,600,000 (1,673,138) Licenses and Permits 3,825,714 2,035,313 2,060,493 98.8%2,247,810 (1,790,401) Charges for Services 3,384,398 3,230,833 1,993,429 162.1%2,174,650 (153,564) Investment Interest 1,059,863 1,538,193 412,500 372.9%450,000 478,330 Miscellaneous Income 980,511 873,587 839,731 104.0%916,070 (106,924) Total Operating Revenues 32,932,468$ 29,258,611$ 27,038,909$ 108.2%29,496,991$ (3,673,857)$ OPERATING EXPENDITURES Personnel 20,936,945$ 19,915,054$ 20,684,779$ 96.3%22,565,214$ (1,021,891)$ Materials and Supplies 526,655 503,092 606,462 83.0%661,594 (23,563)$ Operation and Contract 4,498,349 5,237,950 5,797,287 90.4%6,324,313 739,601$ Other Expenditures 8,517 8,473 9,075 93.4%9,900 (45)$ Capital Outlay 887,443 380,658 607,848 62.6%663,107 (506,785)$ Total Operating Expenditures 26,857,910$ 26,045,228$ 27,705,451$ 94.0%30,224,129$ (812,682)$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 6,074,558$ 3,213,383$ (666,542)$ -482.1%(727,137)$ (2,861,175)$ INTERFUND TRANSACTIONS Transfers In -$ -$ -$ N/A -$ -$ Transfers Out 1,500,000 N/A (1,500,000) Reimbursements From Other Funds 716,572 802,945 802,943 100.0%875,938 86,373 Reimbursements To Other Funds - - 91,667 0.0%100,000 - Sports Core Loan N/A - - Total Interfund Transactions 2,216,572$ 802,945$ 894,610$ 89.8%975,938$ (1,413,627)$ NET FUND INCREASE (DECREASE)8,291,131$ 4,016,328$ 228,067$ 248,801$ (4,274,802)$ Village of Oak Brook General Fund Financial Update For the Period Ending November 30, 2024 11/30/24 11/30/24 11/30/23 11/30/24 YTD % of YTD 2024 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Hotel Tax 1,434,673$ 1,559,052$ 1,329,167$ 117.3%1,450,000$ 124,378$ Investment Interest 84,606 162,618 22,917 709.6%25,000 78,012 Loan Interest 4,000 2,000 1,833 109.1%2,000 (2,000) Miscellaneous - - - - Total Operating Revenues 1,523,279$ 1,723,669$ 1,353,917$ 127.3%1,477,000$ 200,390$ EXPENDITURES Personnel -$ 54,865$ 14,928$ 367.5%-$ 54,865$ Operation and Contract 336,839 33,780 646,291 5.2%705,045 (303,059) Capital Outlay - 5,583 252,083 2.2%275,000 5,583 Total Expenditures 336,839$ 94,228$ 913,303$ 10.3%980,045$ (242,611)$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 1,186,440$ 1,629,441$ 455,542$ 357.7%496,955$ 443,001$ INTERFUND TRANSACTIONS Transfer Out -$ -$ -$ N/A -$ -$ Reimbursements to Other Funds (320,363) (223,586) (223,589) 100.0%(243,915) 96,777 Total Interfund Transactions (320,363)$ (223,586)$ (223,589)$ 100.0%(243,915)$ 96,777$ NET FUND INCREASE (DECREASE)866,077$ 1,405,855$ 231,953$ 253,040$ 539,778$ Note - Expenditures are recorded in program 171. Village of Oak Brook Hotel Tax Fund Financial Update For the Period Ending November 30, 2024 11/30/24 11/30/24 11/30/23 11/30/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 6,882,295$ 7,044,848$ 6,144,417$ 114.7%6,703,000$ 162,553$ Charges for Services - - - N/A -$ Investment Interest 289,628 717,249 114,583 626.0%125,000 427,621 Grants - - - N/A - - Miscellaneous 2,383 2,795 21,083 13.3%23,000 412 Total Operating Revenues 7,174,307$ 7,764,892$ 6,280,083$ 123.6%6,851,000$ 590,586$ OPERATING EXPENDITURES Personnel 44,746$ 17,851$ -$ N/A -$ (26,894)$ Materials and Supplies 159,422 18,433 42,625 43.2%46,500 (140,989) Operation and Contract 893,039 1,114,770 1,597,721 69.8%1,742,968 221,731 Other Expenditures - - 311,574 0.0%339,899 - Capital Outlay 1,839,421 398,586 3,101,794 12.9%3,383,775 (1,440,835) Total Operating Expenditures 2,936,628$ 1,549,641$ 5,053,714$ 30.7%5,513,142$ (1,386,987)$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 4,237,679$ 6,215,252$ 1,226,370$ 506.8%1,337,858$ 1,977,573$ 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) (29,337) - N/A - 282,238 Total Interfund Transactions 887,855$ (29,337)$ -$ N/A -$ (917,192)$ NET FUND INCREASE (DECREASE)5,125,534$ 6,185,915$ 1,226,370$ 1,337,858$ 1,060,380$ Village of Oak Brook Infrastructure Fund Financial Update For the Period Ending November 30, 2024 11/30/24 11/30/24 11/30/23 11/30/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,727$ 481$ 358.8%525$ 2$ Building/Inspection Fees 1,350 - 1,833 0.0%2,000 (1,350) Water Sales 9,337,429 10,268,101 9,826,667 104.5%10,720,000 930,671 Unmetered Sales 44,111 57,870 59,583 97.1%65,000 13,760 Water Connection Fees 153,640 74,980 128,333 58.4%140,000 (78,660) Fire Service Charge - - - N/A - - Meter Charges 17,828 13,330 15,858 84.1%17,300 (4,498) Special Services 39,627 30,108 9,167 328.5%10,000 (9,519) Investment Interest 897,055 1,176,344 320,833 366.7%350,000 279,289 Grants - 1,090,855 - N/A - 1,090,855 Miscellaneous 107,848 116,660 1,053,919 11.1%1,149,730 8,812 Total Operating Revenues 10,600,614$ 12,829,975$ 11,416,675$ 112.4%12,454,555$ 2,229,361$ OPERATING EXPENDITURES Personnel 636,100$ 547,645$ 720,879$ 76.0%786,413$ (88,455)$ Materials and Supplies 100,640 85,949 125,782 68.3%137,216 (14,691) Operation and Contract 5,117,213 5,692,321 6,509,589 87.4%7,101,369 575,107 Capital Outlay 1,170,961 4,063,443 5,215,833 77.9%5,690,000 2,892,483 Total Expenditures 7,024,914$ 10,389,359$ 12,572,082$ 82.6%13,714,999$ 3,364,445$ Surplus (Deficit) of Revenues Over Expenditures 3,575,699$ 2,440,616$ (1,155,407)$ -211.2%(1,260,444)$ (1,135,084)$ INTERFUND TRANSACTIONS Reimbursements To Other Funds (171,048)$ (400,477)$ (400,472)$ 100.0%(436,879)$ (229,429)$ Total Interfund Transactions (171,048)$ (400,477)$ (400,472)$ 100.0%(436,879)$ (229,429)$ Fund Increase/(Decrease) - Budgetary Basis 3,404,651$ 2,040,139$ (1,555,879)$ (1,697,323)$ (1,364,513)$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay 1,170,961$ 4,063,443$ Depreciation Expense (191,667) (527,083) IMRF Pension Expense (15,000) (41,250) OPEB Expense (10,000) (27,500) Total GAAP Adjustments 954,294$ 3,467,610$ Fund Increase/(Decrease) - GAAP Basis 4,358,945$ 5,507,749$ *Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year. Village of Oak Brook Water Fund Financial Update For the Period Ending November 30, 2024 Village of Oak Brook Monthly Operating Statement Sports Core Fund Consolidated Presentation For the Period Ending November 30, 2024 11/30/24 11/30/24 11/30/24 YTD % of YTD 2024 11/30/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,243$ -$ -$ 393,375$ 824,618$ 871,498$ 94.6%950,725$ 887,047$ (62,430)$ Greens Fees - - - 1,755,387 1,755,387 1,287,917 136.3%1,405,000 1,414,566 340,821 Golf Surcharge - - - 235,540 235,540 53,143 443.2%53,143 94,127 141,413 Pro Shop Sales - - - 167,020 167,020 199,833 83.6%218,000 182,923 (15,903) Golf Lessons - - - 35,035 35,035 41,250 84.9%45,000 24,872 10,163 Driving Range Fees - - - 534,510 534,510 357,500 149.5%390,000 401,496 133,014 Rentals - 172,819 130,096 699,521 1,002,436 915,017 109.6%998,200 817,354 185,082 Programs/User Fees 141,569 - - - 141,569 100,650 140.7%109,800 104,649 36,920 Food Sales 8,587 - - 74,799 83,385 43,908 189.9%47,900 295,275 (211,890) Beverage Sales - - - 13,039 13,039 71,179 18.3%77,650 486,163 (473,124) Taste of Oak Brook - - - - - - N/A - - - Grants - - - - - - N/A - - - Other Revenue 98,625 - - 9,438 108,063 90,896 118.9%99,160 37,221 70,842 Total Operating Revenues 680,023$ 172,819$ 130,096$ 3,917,664$ 4,900,601$ 4,032,791$ 121.5%4,394,578$ 4,745,693$ 154,908$ OPERATING EXPENDITURES Personnel 221,693$ -$ -$ 1,127,559$ 1,349,252$ 1,278,731$ 105.5%1,671,380$ 1,266,780$ 82,472$ Materials & Supplies 37,366 - 7,454 383,646 428,466 397,149 107.9%718,900 646,600 (218,134) Operational & Contractual 556,740 40,674 42,859 376,693 1,016,967 993,889 102.3%942,765 916,681 100,286 Other - - - - - - N/A - - - Capital 722,087 - - 823,425 1,545,512 986,567 156.7%466,750 182,198 1,363,314 Total Operating Expenditures 1,537,886$ 40,674$ 50,314$ 2,711,323$ 4,340,197$ 3,656,336$ 118.7%3,799,795$ 3,012,259$ 1,327,938$ B&T Administration Overhead Allocation*34,335$ -$ (11,458)$ (22,877)$ -$ (22,877)$ N/A (24,957) -$ (24,957)$ Operating Revenues Over (Under) Expenditures (823,528)$ 132,144$ 68,324$ 1,183,463$ 560,404$ 353,578$ 158.5%569,826$ 1,733,434$ (1,197,986)$ INTERFUND TRANSACTIONS Interfund Loan**-$ -$ -$ -$ -$ -$ N/A -$ -$ -$ Transfer From General Fund - - - - - - N/A - - - Reimbursement From Infrastructure Fund - - - - - - N/A - - - Reimbursement From Water Fund 36,674 - - - 36,674 36,667 100.0%40,000 - 36,674 Reimbursement To General Fund (46,552) - - (139,667) (186,219) (182,955) 101.8%(199,587) (67,471) (118,748) Total Interfund Transactions (9,878)$ -$ -$ (139,667)$ (149,545)$ (146,288)$ 102.2%(159,587)$ (67,471)$ (82,074)$ Total Revenues Over (Under) Expenditures - Budgetary Basis (833,406)$ 132,144$ 68,324$ 1,043,796$ 410,859$ 207,290$ 410,239$ 1,665,963$ (1,280,060)$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay 722,087$ -$ -$ 823,425$ 1,545,512$ 182,198$ Depreciation Expense (154,208) (1,545) (25,000) (225,775) (406,528) (406,528) IMRF Pension Expense (1,879) - (1,250) (22,458) (25,588) (25,588) OPEB Expense - - (1,250) (25,667) (26,917) (26,917) Total GAAP Adjustments 566,000$ (1,545)$ (27,500)$ 549,525$ 1,086,480$ (276,834)$ Fund Increase/(Decrease) - GAAP Basis (267,406)$ 130,600$ 40,824$ 1,593,321$ 1,497,339$ 1,389,129$ *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 November 30, 2024 11/30/24 11/30/24 822 11/30/24 YTD % of YTD 2024 11/30/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,900$ 27,343$ -$ 431,243$ 405,877$ 106.2%442,775$ 406,947$ 24,296$ Programs/User Fees - 80,063 61,506 - 141,569 100,650.00 140.7%109,800 104,649 36,920 Food Sales - - - 8,587 8,587 5,500.00 156.1%6,000 53,070 - Beverage Sales - - - - - 2,200.00 0.0%2,400 18,909 - Grants - - - - - - N/A - - - Other Revenue 89,275 - 2,350 7,000 98,625 82,646 119.3%90,160 3,175 95,450 Total Operating Revenues 89,275$ 483,963$ 91,198$ 15,587$ 680,023$ 596,873$ 113.9%651,135$ 586,750$ 156,665$ OPERATING EXPENDITURES Personnel 171,924$ 49,769$ -$ -$ 221,693$ 230,897$ 96.0%251,888$ 62,893$ 158,800$ Materials & Supplies 21 21,478 14,202 1,665 37,366 41,598 89.8%45,380 55,694 (18,328) Operational & Contractual 172,844 288,910 94,224 763 556,740 525,281 106.0%573,034 469,400 87,340 Other - - - - - - N/A - - - Capital 637,131 84,957 - - 722,087 801,625 90.1%874,500 1,405 720,682 Total Operating Expenditures 981,918$ 445,115$ 108,425$ 2,428$ 1,537,886$ 1,599,401$ 96.2%1,744,801$ 589,392$ 948,494$ B&T Administration Overhead Allocation*95,792$ (37,692)$ (10,473)$ (13,292)$ 34,335$ -$ N/A 37,457$ 36,486$ (2,151)$ Operating Revenues Over (Under) Expenditures (796,852)$ 1,156$ (27,700)$ (133)$ (823,528)$ (1,002,528)$ 82.1%(1,056,210)$ 33,844$ (793,980)$ Transfer From General Fund -$ -$ -$ -$ -$ -$ N/A - - Reimbursement From Infrastructure Fund - - - - - - N/A - - - Reimbursement From Water Fund 36,674 - - - 36,674 36,667 100.0%40,000 - 36,674 Reimbursement To General Fund (46,552) - - - (46,552) (43,293) 107.5%(47,229) (47,229) 677 Total Interfund Transactions (9,878)$ -$ -$ -$ (9,878)$ (6,627)$ 149.1%(7,229)$ (47,229)$ 37,351$ Total Revenues Over (Under) Expenditures - Budgetary Basis (806,730)$ 1,156$ (27,700)$ (133)$ (833,406)$ (1,009,155)$ (1,063,439)$ (13,385)$ (756,629)$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay 637,131$ 84,957$ -$ -$ 722,087$ 1,405$ Depreciation Expense (58,996) (91,667) (2,475) (1,071) (154,208) (154,208) IMRF Pension Expense (1,833) - - (46) (1,879) (1,879) Total GAAP Adjustments 576,302$ (6,710)$ (2,475)$ (1,117)$ 566,000$ (154,682)$ Fund Increase/(Decrease) - GAAP Basis (230,428)$ (5,554)$ (30,175)$ (1,249)$ (267,406)$ (168,067)$ *Overhead allocation is comprised of salaries, business forms, liability insurance, building & grounds maintenance and bank service fees in Program 811 - Sports Core General Operations distributed to various Sports Core Programs on a percentage basis. **Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year. Village of Oak Brook Monthly Operating Statement Open Fields Operations For the Period Ending November 30, 2024 11/30/24 11/30/24 11/30/24 YTD % of YTD 2024 11/30/23 Difference 815 816 YTD Amended Amended Adopted YTD Prior Polo Open Fields Total Budget Budget Budget Total Year OPERATING REVENUES Field Rentals -$ 172,819$ 172,819 176,917$ 97.7%193,000$ 127,500$ 45,319$ Range Rentals - - - - N/A - 86,080 (86,080) Taste of Oak Brook - - - - N/A - - - Other Revenue - - - - N/A - - - Total Operating Revenues -$ 172,819$ 172,819$ 176,917$ 97.7%193,000$ 213,580$ (40,761)$ OPERATING EXPENDITURES Personnel -$ -$ -$ -$ N/A -$ -$ Materials & Supplies - - - 8,699 0.0%9,490$ 1,064 (1,064) Operational & Contractual - 40,674 40,674 69,713 58.3%76,050 39,876 798 Other - - - - N/A - - - Capital - - - 42,167 0.0%46,000 - - Total Operating Expenditures -$ 40,674$ 40,674$ 120,578$ 33.7%131,540$ 40,940$ (266)$ Operating Revenues Over (Under) Expenditures -$ 132,144$ 132,144$ 56,338$ 234.6%61,460$ 172,640$ (40,496)$ INTERFUND TRANSACTIONS Transfer From Hotel Tax Fund -$ -$ -$ -$ N/A -$ -$ -$ Total Interfund Transactions -$ -$ -$ -$ N/A -$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis -$ 132,144$ 132,144$ 56,338$ 61,460$ 172,640$ (40,496)$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ -$ -$ -$ Depreciation Expense - (1,545) (1,545) (1,545) Total GAAP Adjustments -$ (1,545)$ (1,545)$ (1,545)$ Fund Increase/(Decrease) - GAAP Basis -$ 130,600$ 130,600$ 171,095$ *Overhead allocation is comprised of salaries, business forms, liability insurance, building & grounds maintenance and bank service fees in Program 811 - Sports Core General Operations distributed to various Sports Core Programs on a percentage basis. **Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year. Village of Oak Brook Monthly Operating Statement Bath & Tennis Clubhouse Operations For the Period Ending November 30, 2024 11/30/24 11/30/24 821 YTD % of YTD 2024 11/30/23 Difference B&T Amended Amended Adopted YTD Prior Clubhouse Budget Budget Budget Total Year OPERATING REVENUES Rentals 130,096$ 213,583$ 60.9%233,000$ 133,465$ (3,369)$ Other Revenue - - 0.0%- - - Total Operating Revenues 130,096$ 213,583$ 60.9%233,000$ 133,465$ (3,369)$ OPERATING EXPENDITURES Personnel -$ -$ N/A -$ 9,693$ (9,693)$ Materials & Supplies 7,454 12,604 59.1%13,750 10,264 (2,810) Operational & Contractual 42,859 48,563 88.3%52,978 64,364 (21,505) Capital - - N/A - - - Total Operating Expenditures 50,314$ 61,167$ 82.3%66,728$ 84,321$ (34,007)$ B&T Administration Overhead Allocation*(11,458)$ -$ N/A (12,500)$ (36,486)$ 25,028$ Operating Revenues Over (Under) Expenditures 68,324$ 152,416$ 44.8%153,772$ 12,658$ 55,666$ INTERFUND TRANSACTIONS Transfer From General Fund -$ -$ 0.0%-$ -$ -$ Total Interfund Transactions -$ -$ 0.0%-$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis 68,324$ 152,416$ 153,772$ 12,658$ 55,666$ 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 40,824$ (14,842)$ *Overhead allocation is comprised of salaries, business forms, liability insurance, building & grounds maintenance and bank service fees in Program 811 - Sports Core General Operations distributed to various Sports Core Programs on a percentage basis. **Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year. Village of Oak Brook Monthly Operating Statement Golf Club Programs For the Period Ending November 30, 2024 11/30/24 11/30/24 823 831 832 833 834 11/30/24 YTD % of YTD 2024 11/30/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$ 465,621$ 84.5%507,950$ 480,100$ (86,725)$ Greens Fees - 1,755,387 - - - 1,755,387 1,287,917 136.3%1,405,000 1,414,566 340,821 Surcharge - 235,540 235,540 53,143 443.2%53,143 94,127 141,413 Pro Shop Sales - 167,020 - - - 167,020 199,833 83.6%218,000 182,923 (15,903) Golf Lessons - - 35,035 - - 35,035 41,250 84.9%45,000 24,872 10,163 Driving Range Fees - - 534,510 - - 534,510 357,500 149.5%390,000 401,496 133,014 Rentals 26,500 3,395 64,662 604,964 - 699,521 524,517 133.4%572,200 470,309 229,212 Food Sales 74,799 - - - - 74,799 38,408 194.7%41,900 242,205 (167,406) Beverage Sales 13,039 - - - - 13,039 68,979 18.9%75,250 467,254 (454,215) Other Revenue - 9,438 - - - 9,438 8,250 114.4%9,000 34,046 (24,608) Total Operating Revenues 114,338$ 2,564,155$ 634,207$ 604,964$ -$ 3,917,664$ 3,045,418$ 128.6%3,317,443$ 3,811,898$ 105,766$ OPERATING EXPENDITURES Personnel 5,184$ 329,886$ 62,418$ 79,300$ 650,771$ 1,127,559$ 1,047,834$ 107.6%1,143,092$ 1,194,194$ (66,635)$ Materials & Supplies (874) 197,576 19,898 1,274 165,773 383,646 334,247 114.8%364,633 579,578 (195,932) Operational & Contractual 3,912 243,098 46,904 32,959 49,820 376,693 350,333 107.5%382,181 343,041 33,652 Other - - - - - N/A - - - Capital - 19,955 - 671,600 131,870 823,425 142,775 576.7%155,755 180,793 642,632 Total Operating Expenditures 8,222$ 790,514$ 129,220$ 785,133$ 998,234$ 2,711,323$ 1,875,189$ 144.6%2,045,661$ 2,297,606$ 413,717$ Operating Revenues Over (Under) Expenditures 106,116$ 1,773,641$ 504,987$ (180,169)$ (998,234)$ 1,206,340$ 1,170,229$ 103.1%1,271,782$ 1,514,292$ (307,951)$ INTERFUND TRANSACTIONS Overhead Charge -$ (22,877)$ -$ -$ -$ (22,877)$ (22,877)$ 100.0%(24,957)$ -$ (22,877)$ Transfers from Other Fund - - - - - - - 0.0%150,000 - - Reimbursement to General Fund - (139,667) - - - (139,667) (139,662) 100.0%(152,358) (20,242) (119,425) Total Interfund Transactions -$ (162,544)$ -$ -$ -$ (162,544)$ (162,538)$ 100.0%(27,315)$ (20,242)$ (142,302)$ Total Revenues Over (Under) Expenditures - Budgetary Basis 106,116$ 1,611,097$ 504,987$ (180,169)$ (998,234)$ 1,043,796$ 1,007,690$ 1,244,467$ 1,494,050$ (450,253)$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay -$ 19,955$ -$ 671,600$ 131,870$ 823,425$ 180,793$ Depreciation Expense (917) (96,250) (2,108) (11,917) (114,583) (225,775) (225,775) IMRF Pension Expense (2,292) (9,167) (917) - (10,083) (22,458) (22,458) OPEB Expense (2,750) (13,750) - - (9,167) (25,667) (25,667) Total GAAP Adjustments (5,958)$ (99,212)$ (3,025)$ 659,683$ (1,963)$ 549,525$ (93,107)$ Fund Increase/(Decrease) - GAAP Basis 100,157$ 1,511,885$ 501,962$ 479,514$ (1,000,197)$ 1,593,321$ 1,400,943$ *Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.