Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
12 - December 2023 Monthly Financial Report
VILLAGE OAK BROOKOF MONTHLY FINANCIAL REPORTS DECEMBER 2023 YTD YTD Net Fund Ending YTD YTD Increase Fund Balance Governmental Funds Revenues Expenditures (Decrease)(Deficit) General Fund (Major Fund)35,394,036$ 31,239,699$ 4,154,337$ 42,625,389$ Main operating fund of the Village. Hotel Fund (Major Fund)1,645,667$ 699,842$ 945,825$ 3,336,170$ Collects and spends resources from the 3% hotel/motel tax. Motor Fuel Tax Fund 430,092$ 106,032$ 324,060$ 2,021,598$ Collects and spends resources from the State motor fuel tax. Infrastructure Fund (Major Fund)9,038,797$ 3,496,784$ 5,542,013$ 14,424,507$ Accounts for construction and maintenance of roadways, drainage, and safety path systems. Promenade TIF Fund (Major Fund)535,894$ 845,814$ (309,920)$ -$ 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)11,061,682$ 8,019,249$ 3,042,433$ 21,918,643$ Collects user fees for the distribution of water and maintenance of infrastructure. Sports Core Fund (Major Fund)4,830,152$ 3,484,100$ 1,346,052$ 2,493,839$ Accounts for revenues and expenses relating to administration, programs, food and beverage operations, and golf course. Golf Surcharge Fund 142,980$ -$ 142,980$ 410,050$ Accounts for the collection of the $3 per round golf surcharge. Internal Service Funds Self Insurance Fund 3,627,338$ 3,129,492$ 497,846$ 472,466$ Accounts for the Village's health insurance costs and the related contributions from the Village, employees, retirees, and other agencies. Garage Fund 697,057$ 576,087$ 120,970$ 374,241$ Accounts for the maintenance of the Village's vehicle fleet and the related departmental reimbursements. Equipment Replacement Fund 1,340,158$ 1,207,927$ 132,231$ 2,957,118$ 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 December 31, 2023 12/31/23 12/31/23 12/31/22 12/31/23 YTD % of YTD 2023 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax 17,699,843$ 17,654,357$ 16,000,000$ 110.3%16,000,000$ (45,486)$ State Income Tax 1,330,139 1,303,915 1,145,000 113.9%1,145,000 (26,224) Replacement Tax 1,052,604 869,774 450,000 193.3%450,000 (182,830) Road & Bridge Tax 25,146 32,429 35,000 92.7%35,000 7,283 Local Use Tax 330,549 324,507 300,000 108.2%300,000 (6,042) Cannabis Use Tax 13,351 12,361 15,900 77.7%15,900 (990) Grants 157,038 592,896 15,662 3785.5%15,662 435,858 Utility/Telecom. Tax 5,214,840 4,753,803 5,623,000 84.5%5,623,000 (461,037) Licenses and Permits 2,452,505 3,845,051 1,950,485 197.1%1,950,485 1,392,546 Charges for Services 1,924,623 3,107,078 1,647,370 188.6%1,647,370 1,182,455 Investment Interest (91,575) 1,178,063 200,000 589.0%200,000 1,269,638 Miscellaneous Income 1,092,397 1,003,230 1,023,551 98.0%1,023,551 (89,167) Total Operating Revenues 31,201,460$ 34,677,464$ 28,405,969$ 122.1%28,405,969$ 3,476,004$ OPERATING EXPENDITURES Personnel 19,088,220$ 23,085,388$ 22,137,051$ 104.3%22,137,051$ 3,997,167$ Materials and Supplies 553,336 608,023 597,056 101.8%597,056 54,687$ Operation and Contract 4,019,782 4,895,041 5,404,722 90.6%5,404,722 875,259$ Other Expenditures 6,437 8,517 9,000 94.6%9,000 2,080$ Capital Outlay 829,060 1,142,730 950,575 120.2%950,575 313,670$ Total Operating Expenditures 24,496,835$ 29,739,699$ 29,098,405$ 102.2%29,098,405$ 5,242,864$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 6,704,625$ 4,937,765$ (692,436)$ -713.1%(692,436)$ (1,766,860)$ INTERFUND TRANSACTIONS Transfers In -$ -$ -$ N/A -$ -$ Transfers Out - (1,500,000) N/A (1,500,000) Reimbursements From Other Funds 565,220 716,572 677,401 105.8%677,401 151,352 Reimbursements To Other Funds (109,880) - - N/A - 109,880 Total Interfund Transactions 455,340$ (783,428)$ 677,401$ -115.7%677,401$ (1,238,768)$ NET FUND INCREASE (DECREASE)7,159,965$ 4,154,337$ (15,035)$ (15,035)$ (3,005,628)$ Village of Oak Brook General Fund Financial Update For the Period Ending December 31, 2023 12/31/23 12/31/23 12/31/22 12/31/23 YTD % of YTD 2023 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Hotel Tax 1,382,607 1,545,584 1,150,000$ 134.4%1,150,000$ 162,977$ Investment Interest (4,431) 96,083 12,000 800.7%12,000 100,514 Loan Interest 6,000 4,000 4,000 100.0%4,000 (2,000) Miscellaneous 100,000 - - (100,000) Total Operating Revenues 1,484,176$ 1,645,667$ 1,166,000$ 141.1%1,166,000$ 161,491$ EXPENDITURES Operation and Contract 358,236$ 379,479$ 674,595$ 56.3%674,595$ 21,244$ Capital Outlay 52,696 - - N/A - (52,696) Total Expenditures 410,932$ 379,479$ 674,595$ 56.3%674,595$ (31,452)$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 1,073,244$ 1,266,188$ 491,405$ 257.7%491,405$ 192,943$ INTERFUND TRANSACTIONS Transfer Out -$ -$ -$ N/A -$ -$ Reimbursements to Other Funds (82,800) (320,363) (349,485) 91.7%(349,485) (237,563) Total Interfund Transactions (82,800)$ (320,363)$ (349,485)$ 91.7%(349,485)$ (237,563)$ NET FUND INCREASE (DECREASE)990,444$ 945,825$ 141,920$ 141,920$ (44,620)$ Note - Expenditures are recorded in program 171. Village of Oak Brook Hotel Tax Fund Financial Update For the Period Ending December 31, 2023 12/31/23 12/31/23 12/31/22 12/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 7,363,215$ 7,494,625$ 6,525,000$ 114.9%6,525,000$ 131,410$ Charges for Services - - N/A -$ Investment Interest (54,681) 341,897 27,500 1243.3%27,500 396,578 Grants 550,000 - 1,089,730 0.0%1,089,730 (550,000) Miscellaneous - 2,845 1,000 284.5%1,000 2,845 Total Operating Revenues 7,858,534$ 7,839,367$ 7,643,230$ 102.6%7,643,230$ (19,167)$ OPERATING EXPENDITURES Personnel 1,246,003$ 37,091 45,294$ 81.9%45,294$ (1,208,913)$ Materials and Supplies 174,762 161,277 197,400 81.7%197,400 (13,486) Operation and Contract 1,215,630 987,608 1,730,180 57.1%1,730,180 (228,022) Other Expenditures - - - N/A - Capital Outlay 5,352,696 1,999,234 9,226,320 21.7%9,226,320 (3,353,463) Total Operating Expenditures 7,989,092$ 3,185,209$ 11,199,194$ 28.4%11,199,194$ (4,803,883)$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES (130,558)$ 4,654,158$ (3,555,964)$ -130.9%(3,555,964)$ 4,784,716$ INTERFUND TRANSACTIONS Transfers In -$ 1,000,000$ -$ N/A -$ 1,000,000$ Reimbursements From Other Funds 323,365 199,430 - N/A - (123,935) Reimbursements To Other Funds (118,130) (311,575) - N/A - (193,445) Total Interfund Transactions 205,235$ 887,855$ -$ N/A -$ 682,620$ NET FUND INCREASE (DECREASE)74,677$ 5,542,013$ (3,555,964)$ (3,555,964)$ 5,467,336$ Village of Oak Brook Infrastructure Fund Financial Update For the Period Ending December 31, 2023 12/31/23 12/31/23 12/31/22 12/31/23 YTD % of YTD 2023 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax 91,755$ 74,379$ 15,000$ 495.9%15,000$ (17,376)$ Real Estate Tax 408,176 455,451 405,000 112.5%405,000 47,275 Investment Interest 2,436 6,064 10 60640.0%10 3,628 Total Operating Revenues 502,367$ 535,894$ 420,010$ 127.6%420,010$ 33,527$ EXPENDITURES Operation and Contract 4,575$ 5,625 5,100$ 110.3%5,100$ 1,050$ Other Expenditures 486,260 840,189 336,725 249.5%336,725 353,929 Total Expenditures 490,835$ 845,814$ 341,825$ 247.4%341,825$ 354,979$ NET FUND INCREASE (DECREASE)11,532$ (309,920)$ 78,185$ 78,185$ (321,452)$ Note - Expenditures are recorded in program 283. Village of Oak Brook Promenade TIF Fund Financial Update For the Period Ending December 31, 2023 12/31/23 12/31/23 12/31/22 12/31/23 YTD % of YTD 2023 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Plan Review Fees 600$ 1,725$ 525$ 328.6%525$ 1,125$ Building/Inspection Fees 2,175 1,350 2,000 67.5%2,000 (825) Water Sales 11,171,196 9,670,893 8,230,000 117.5%8,230,000 (1,500,303) Unmetered Sales 99,978 50,646 50,000 101.3%50,000 (49,332) Water Connection Fees 586,270 153,640 75,000 204.9%75,000 (432,630) Meter Charges 24,729 17,828 15,000 118.9%15,000 (6,901) Special Services 25,623 39,627 10,000 396.3%10,000 14,004 Investment Interest 12,392 1,001,653 20,000 5008.3%20,000 989,261 Proceeds from Property Sale 10,416,822 - - N/A - (10,416,822) Miscellaneous 113,378 124,320 50,000 248.6%50,000 10,942 Total Operating Revenues 22,453,163$ 11,061,682$ 8,452,525$ 130.9%8,452,525$ (11,391,481)$ OPERATING EXPENDITURES Personnel 480,809$ 704,276.27 647,620$ 108.7%647,620$ 223,467$ Materials and Supplies 81,992 102,489.22 69,650 147.1%69,650 20,497 Operation and Contract 5,408,771 5,870,474.43 5,400,625 108.7%5,400,625 461,703 Capital Outlay 33,894 1,170,961 3,925,000 29.8%3,925,000 1,137,067 Total Expenditures 6,005,466$ 7,848,201$ 10,042,895$ 78.1%10,042,895$ 1,842,734$ Surplus (Deficit) of Revenues Over Expenditures 16,447,697$ 3,213,481$ (1,590,370)$ -202.1%(1,590,370)$ (13,234,215)$ INTERFUND TRANSACTIONS Reimbursements To Other Funds (420,490)$ (171,048)$ (420,490)$ 40.7%(420,490)$ 249,442$ Total Interfund Transactions (420,490)$ (171,048)$ (420,490)$ 40.7%(420,490)$ 249,442$ Fund Increase/(Decrease) - Budgetary Basis 16,027,207$ 3,042,433$ (2,010,860)$ (2,010,860)$ (12,984,774)$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay 33,894$ 1,170,961$ Depreciation Expense (383,333) (575,000) IMRF Pension Expense (30,000) (45,000) OPEB Expense (20,000) (30,000) Total GAAP Adjustments (399,439)$ 520,961$ Fund Increase/(Decrease) - GAAP Basis 15,627,767$ 3,563,394$ *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, 2023 Village of Oak Brook Monthly Operating Statement Sports Core Fund Consolidated Presentation For the Period Ending December 31, 2023 12/31/23 12/31/23 12/31/23 YTD % of YTD 2023 12/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$ 929,250$ 95.5%929,250$ 807,813$ 79,234$ Greens Fees - - - 1,430,805 1,430,805 1,310,000 109.2%1,310,000 1,259,625 171,180 Pro Shop Sales - - - 195,557 195,557 250,000 78.2%250,000 226,529 (30,972) Golf Lessons - - - 24,872 24,872 50,000 49.7%50,000 35,815 (10,943) Driving Range Fees - - - 402,126 402,126 350,000 114.9%350,000 356,233 45,893 Rentals - 275,083 151,968 499,131 926,182 1,084,000 85.4%1,084,000 1,065,864 (139,682) Programs/User Fees 114,020 - - - 114,020 69,100 165.0%69,100 84,221 29,800 Food Sales 48,507 - - 246,663 295,170 290,000 101.8%290,000 317,343 (22,173) Beverage Sales 18,909 - - 484,645 503,554 492,000 102.3%492,000 502,100 1,455 Taste of Oak Brook - - - - - - N/A - 66,812 (66,812) Grants - - - - - - N/A - - - Other Revenue 16,390 - - 34,427 50,817 27,625 184.0%27,625 19,846 30,972 Total Operating Revenues 604,773$ 275,083$ 151,968$ 3,798,327$ 4,830,152$ 4,851,975$ 99.6%4,851,975$ 4,742,201$ 87,951$ OPERATING EXPENDITURES Personnel 63,970$ -$ 15,039$ 1,374,510$ 1,453,519$ 1,728,320$ 84.1%1,671,380$ 1,471,016$ (17,497)$ Materials & Supplies 64,421 1,064 14,046 708,229 787,761 822,038 95.8%718,900 799,382 (11,622) Operational & Contractual 445,966 42,488 69,875 378,418 936,747 755,817 123.9%942,765 968,025 (31,278) Other - - - - - - N/A - - - Capital 38,207 - - 193,648 231,855 1,578,751 14.7%466,750 375,676 (143,821) Total Operating Expenditures 612,564$ 43,552$ 98,961$ 2,654,805$ 3,409,881$ 4,884,925$ 69.8%3,799,795$ 3,614,099$ (204,218)$ B&T Administration Overhead Allocation*43,784$ -$ (43,784)$ -$ -$ -$ N/A -$ -$ -$ Operating Revenues Over (Under) Expenditures 35,993$ 231,531$ 9,224$ 1,143,522$ 1,420,270$ (32,950)$ -4310.4%1,052,180$ 1,128,101$ 292,169$ INTERFUND TRANSACTIONS Interfund Loan**-$ -$ -$ -$ -$ -$ N/A -$ -$ -$ Transfer From General Fund - - - - - - N/A - - - Transfer From Golf Surcharge Fund - - - - - 150,000 0.0%150,000 - - Reimbursement From Infrastructure Fund - - - - - - N/A - - - Reimbursement From Water Fund - - - - - - N/A - - - Reimbursement To General Fund (53,976) - - (20,242) (74,218) (80,967) 91.7%(80,967) (69,168) (5,050) Total Interfund Transactions (53,976)$ -$ -$ (20,242)$ (74,218)$ 69,033$ -107.5%69,033$ (69,168)$ (5,050)$ Total Revenues Over (Under) Expenditures - Budgetary Basis (17,983)$ 231,531$ 9,224$ 1,123,280$ 1,346,052$ 36,083$ 1,121,213$ 1,058,933$ 287,119$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay 38,207$ -$ -$ 193,648$ 231,855$ 375,676$ Depreciation Expense (168,227) (1,685) (25,000) (246,300) (441,212) (413,174) IMRF Pension Expense (2,050) - (1,250) (24,500) (27,800) (27,458) OPEB Expense - - (1,250) (28,000) (29,250) (29,250) Total GAAP Adjustments (132,070)$ (1,685)$ (27,500)$ (105,152)$ (266,407)$ (94,206)$ Fund Increase/(Decrease) - GAAP Basis (150,053)$ 229,846$ (18,276)$ 1,018,128$ 1,079,645$ 964,727$ *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, 2023 12/31/23 12/31/23 822 12/31/23 YTD % of YTD 2023 12/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$ 519,250$ 78.4%519,250$ 402,838$ 4,109$ Programs/User Fees - 71,961 42,059 - 114,020 69,100.00 165.0%69,100 84,221 29,800 Food Sales - - - 48,507 48,507 40,000.00 121.3%40,000 44,287 - Beverage Sales - - - 18,909 18,909 17,000.00 111.2%17,000 17,712 - Grants - - - - - - N/A - - - Other Revenue 16,390 - - - 16,390 2,325 704.9%2,325 3,127 13,263 Total Operating Revenues 16,390$ 461,336$ 59,631$ 67,416$ 604,773$ 647,675$ 93.4%647,675$ 552,184$ 47,171$ OPERATING EXPENDITURES Personnel 233$ 36,012$ -$ 27,725$ 63,970$ 198,768$ 32.2%198,768$ 67,599$ (3,629)$ Materials & Supplies 429 49,398 2,014 12,580 64,421 71,796 89.7%71,796 69,928 (5,507) Operational & Contractual 54,741 312,723 73,576 4,926 445,966 246,985 180.6%246,985 311,454 134,512 Other - - - - - - N/A - - Capital 38,207 - - - 38,207 550,000 6.9%550,000 244,355 (206,148) Total Operating Expenditures 93,610$ 398,133$ 75,590$ 45,231$ 612,564$ 1,067,549$ 57.4%1,067,549$ 693,335$ (80,772)$ B&T Administration Overhead Allocation*87,568$ (31,522)$ (8,759)$ (3,503)$ 43,784$ -$ N/A 43,783$ 32,738$ 11,046$ Operating Revenues Over (Under) Expenditures 10,348$ 31,681$ (24,718)$ 18,682$ 35,993$ (419,874)$ -8.6%(376,092)$ (108,413)$ 138,989$ Transfer From General Fund - - - - - - N/A - - - Reimbursement From Infrastructure Fund - - - - - -$ N/A - - - Reimbursement From Water Fund - - - - - - N/A - - - Reimbursement To General Fund (53,976) - - - (53,976) (20,242) 266.7%(20,242) (17,292) (36,684) Total Interfund Transactions (53,976)$ -$ -$ -$ (53,976)$ (20,242)$ 266.7%(20,242)$ (17,292)$ (36,684)$ Total Revenues Over (Under) Expenditures - Budgetary Basis (43,629)$ 31,681$ (24,718)$ 18,682$ (17,983)$ (440,116)$ (396,334)$ (125,705)$ 102,305$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay 38,207$ -$ -$ -$ 38,207$ 244,355$ Depreciation Expense (64,359) (100,000) (2,700) (1,168) (168,227) (140,189) IMRF Pension Expense (2,000) - - (50) (2,050) (1,708) Total GAAP Adjustments (28,152)$ (100,000)$ (2,700)$ (1,218)$ (132,070)$ 102,457$ Fund Increase/(Decrease) - GAAP Basis (71,781)$ (68,319)$ (27,418)$ 17,464$ (150,053)$ (23,248)$ *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, 2023 12/31/23 12/31/23 12/31/23 YTD % of YTD 2023 12/31/22 Difference 815 816 YTD Amended Amended Adopted YTD Prior Polo Open Fields Total Budget Budget Budget Total Year OPERATING REVENUES Field Rentals -$ 189,003$ 189,003$ 181,000$ 104.4%181,000$ 174,393$ 14,610$ Range Rentals - 86,080 86,080 85,000 101.3%85,000 80,000 6,080 Taste of Oak Brook - - - - N/A - 66,812 - Other Revenue - - - - N/A - - Total Operating Revenues -$ 275,083$ 275,083$ 266,000$ 103.4%266,000$ 321,205$ 20,690$ OPERATING EXPENDITURES Personnel -$ -$ -$ -$ N/A -$ -$ Materials & Supplies - 1,064 1,064 9,490 11.2%9,490$ - 1,064 Operational & Contractual 5 42,483 42,488 125,940 33.7%125,940 223,829 (181,341) Capital - - - - N/A - - Total Operating Expenditures 5$ 43,547$ 43,552$ 135,430$ 32.2%135,430$ 223,829$ (180,277)$ Operating Revenues Over (Under) Expenditures (5)$ 231,536$ 231,531$ 130,570$ 177.3%130,570$ 97,376$ 200,967$ INTERFUND TRANSACTIONS Transfer From Hotel Tax Fund -$ -$ -$ -$ N/A -$ -$ -$ Total Interfund Transactions -$ -$ -$ -$ N/A -$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis (5)$ 231,536$ 231,531$ 130,570$ 130,570$ 97,376$ 200,967$ 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 (5)$ 229,851$ 229,846$ 95,691$ *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, 2023 12/31/23 12/31/23 821 YTD % of YTD 2023 12/31/22 Difference B&T Amended Amended Adopted YTD Prior Clubhouse Budget Budget Budget Total Year OPERATING REVENUES Rentals 151,968$ 350,000$ 43.4%350,000$ 354,269$ (202,301)$ Other Revenue - - 0.0%- - - Total Operating Revenues 151,968$ 350,000$ 43.4%350,000$ 354,269$ (202,301)$ OPERATING EXPENDITURES Personnel 15,039$ 142,954$ N/A 142,954$ 135,657$ (120,618)$ Materials & Supplies 14,046 23,972 58.6%23,972 19,460 (5,413) Operational & Contractual 69,875 76,842 90.9%76,842 79,775 (9,900) Capital - - N/A - - - Total Operating Expenditures 98,961$ 243,767$ 40.6%243,767$ 234,892$ (135,931)$ B&T Administration Overhead Allocation*(43,784)$ -$ N/A (43,784)$ (32,738)$ (11,046)$ Operating Revenues Over (Under) Expenditures 9,224$ 106,233$ 8.7%62,449$ 86,639$ (77,416)$ INTERFUND TRANSACTIONS Transfer From General Fund -$ -$ 0.0%-$ -$ -$ Total Interfund Transactions -$ -$ 0.0%-$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis 9,224$ 106,233$ 62,449$ 86,639$ (77,416)$ 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 (18,276)$ 59,139$ *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, 2023 12/31/23 12/31/23 823 831 832 833 834 12/31/23 YTD % of YTD 2023 12/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$ 410,000$ 117.1%410,000$ 404,975$ 75,125$ Greens Fees - 1,430,805 - - - 1,430,805 1,310,000 109.2%1,310,000 1,259,625 171,180 Pro Shop Sales - 195,557 - - - 195,557 250,000 78.2%250,000 226,529 (30,972) Golf Lessons - - 24,872 - - 24,872 50,000 49.7%50,000 35,815 (10,943) Driving Range Fees - - 402,126 - - 402,126 350,000 114.9%350,000 356,233 45,893 Rentals - 1,980 9,000 488,151 - 499,131 468,000 106.7%468,000 457,202 41,929 Food Sales 246,663 - - - 246,663 250,000 98.7%250,000 273,057 (26,393) Beverage Sales 484,645 - - - - 484,645 475,000 102.0%475,000 484,388 258 Other Revenue 17,954 16,473 - - - 34,427 25,300 136.1%25,300 16,719 17,709 Total Operating Revenues 749,263$ 2,124,915$ 435,998$ 488,151$ -$ 3,798,327$ 3,588,300$ 105.9%3,588,300$ 3,514,542$ 283,785$ OPERATING EXPENDITURES Personnel 215,709$ 553,558$ 69,244$ 71,803$ 464,196$ 1,374,510$ 1,386,598$ 99.1%1,386,598$ 1,267,759$ 106,751$ Materials & Supplies 306,548 176,766 14,812 5,916 204,187 708,229 716,780 98.8%716,780 709,995 (1,766) Operational & Contractual 7,758 251,383 13,610 61,388 44,279 378,418 306,050 123.6%306,050 352,967 25,451 Other - - - - - - - N/A - - - Capital - 85,613 13,290 - 94,745 193,648 1,028,751 18.8%1,028,751 131,321 62,327 Total Operating Expenditures 530,015$ 1,067,320$ 110,956$ 139,107$ 807,407$ 2,654,805$ 3,438,178$ 77.2%3,438,178$ 2,462,043$ 192,762$ Operating Revenues Over (Under) Expenditures 219,248$ 1,057,595$ 325,042$ 349,044$ (807,407)$ 1,143,522$ 150,122$ 761.7%150,122$ 1,052,499$ 91,023$ INTERFUND TRANSACTIONS Transfer from Golf Surcharge -$ -$ -$ -$ -$ -$ 150,000$ 0.0%150,000$ -$ -$ Reimbursement to General Fund - (20,242) - - - (20,242) (60,725) 33.3%(60,725) (51,876) 31,634 Total Interfund Transactions -$ (20,242)$ -$ -$ -$ (20,242)$ 89,275$ -22.7%89,275$ (51,876)$ 31,634$ Total Revenues Over (Under) Expenditures - Budgetary Basis 219,248$ 1,037,353$ 325,042$ 349,044$ (807,407)$ 1,123,280$ 239,397$ 239,397$ 1,000,623$ 122,657$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay -$ 85,613$ 13,290$ -$ 94,745$ 193,648$ 131,321$ 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)$ (44,387)$ 9,990$ (13,000)$ (51,255)$ (105,152)$ (167,479)$ Fund Increase/(Decrease) - GAAP Basis 212,748$ 992,966$ 335,032$ 336,044$ (858,662)$ 1,018,128$ 833,144$ *Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.