Loading...
11 - November 2023 Monthly Financial ReportVILLAGE OAK BROOKOF MONTHLY FINANCIAL REPORTS NOVEMBER 2023 YTD YTD Net Fund Ending YTD YTD Increase Fund Balance Governmental Funds Revenues Expenditures (Decrease)(Deficit) General Fund (Major Fund)33,649,041$ 28,357,911$ 5,291,130$ 43,762,182$ Main operating fund of the Village. Hotel Fund (Major Fund)1,523,279$ 657,203$ 866,076$ 3,256,422$ Collects and spends resources from the 3% hotel/motel tax. Motor Fuel Tax Fund 388,087$ 103,678$ 284,408$ 1,981,946$ Collects and spends resources from the State motor fuel tax. Infrastructure Fund (Major Fund)8,373,736$ 3,248,203$ 5,125,533$ 14,008,027$ Accounts for construction and maintenance of roadways, drainage, and safety path systems. Promenade TIF Fund (Major Fund)535,894$ 845,814$ (309,920)$ 3,704$ 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)10,600,613$ 7,195,963$ 3,404,650$ 22,280,860$ Collects user fees for the distribution of water and maintenance of infrastructure. Sports Core Fund (Major Fund)4,827,265$ 3,245,931$ 1,581,334$ 2,729,121$ Accounts for revenues and expenses relating to administration, programs, food and beverage operations, and golf course. Golf Surcharge Fund 100,581$ -$ 100,581$ 367,651$ Accounts for the collection of the $3 per round golf surcharge. Internal Service Funds Self Insurance Fund 3,391,428$ 3,126,630$ 264,799$ 239,418$ Accounts for the Village's health insurance costs and the related contributions from the Village, employees, retirees, and other agencies. Garage Fund 638,546$ 553,524$ 85,022$ 338,293$ Accounts for the maintenance of the Village's vehicle fleet and the related departmental reimbursements. Equipment Replacement Fund 1,235,300$ 1,182,716$ 52,584$ 2,877,471$ 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 November 30, 2023 11/30/23 11/30/23 11/30/22 11/30/23 YTD % of YTD 2023 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax 16,586,911$ 16,236,309 14,666,667$ 110.7%16,000,000$ (350,602)$ State Income Tax 1,255,326 1,229,048 1,049,583 117.1%1,145,000 (26,278) Replacement Tax 972,410 833,637 412,500 202.1%450,000 (138,773) Road & Bridge Tax 21,249 28,210 32,083 87.9%35,000 6,961 Local Use Tax 295,235 296,996 275,000 108.0%300,000 1,761 Cannabis Use Tax 12,357 11,362 14,575 78.0%15,900 (995) Grants 29,320 596,068 14,357 4151.7%15,662 566,748 Utility/Telecom. Tax 5,089,310 4,450,352 5,154,417 86.3%5,623,000 (638,958) Licenses and Permits 2,194,759 3,825,714 1,787,945 214.0%1,950,485 1,630,955 Charges for Services 1,772,938 3,384,399 1,510,089 224.1%1,647,370 1,611,461 Investment Interest 314,371 1,059,863 183,333 578.1%200,000 745,492 Miscellaneous Income 647,318 980,511 938,255 104.5%1,023,551 333,193 Total Operating Revenues 29,191,504$ 32,932,469$ 26,038,804$ 126.5%28,405,969$ 3,740,965$ OPERATING EXPENDITURES Personnel 15,907,436$ 20,936,945$ 20,292,297$ 103.2%22,137,051$ 5,029,509$ Materials and Supplies 454,975 526,654 547,301 96.2%597,056 71,679$ Operation and Contract 3,621,876 4,498,352 4,954,329 90.8%5,404,722 876,476$ Other Expenditures 6,437 8,517 8,250 103.2%9,000 2,080$ Capital Outlay 381,341 887,443 871,360 101.8%950,575 506,102$ Total Operating Expenditures 20,372,065$ 26,857,911$ 26,673,537$ 100.7%29,098,405$ 6,485,846$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 8,819,439$ 6,074,558$ (634,733)$ -957.0%(692,436)$ (2,744,881)$ INTERFUND TRANSACTIONS Transfers In -$ -$ -$ N/A -$ -$ Transfers Out - (1,500,000) N/A (1,500,000) Reimbursements From Other Funds 518,122 716,572 620,951 115.4%677,401 198,450 Reimbursements To Other Funds (100,727) - - N/A - 100,727 Total Interfund Transactions 417,395$ (783,428)$ 620,951$ -126.2%677,401$ (1,200,823)$ NET FUND INCREASE (DECREASE)9,236,834$ 5,291,130$ (13,782)$ (15,035)$ (3,945,704)$ Village of Oak Brook General Fund Financial Update For the Period Ending November 30, 2023 11/30/23 11/30/23 11/30/22 11/30/23 YTD % of YTD 2023 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Hotel Tax 1,249,688$ 1,434,673$ 1,054,167$ 136.1%1,150,000$ 184,985$ Investment Interest 21,391 84,606 11,000 769.1%12,000 63,215 Loan Interest 6,000 4,000 3,667 109.1%4,000 (2,000) Miscellaneous - - Total Operating Revenues 1,277,079$ 1,523,279$ 1,068,833$ 142.5%1,166,000$ 246,200$ EXPENDITURES Operation and Contract 384,174$ 336,840$ 618,379$ 54.5%674,595$ (47,334)$ Capital Outlay 52,696 - - N/A - (52,696) Total Expenditures 436,870$ 336,840$ 618,379$ 54.5%674,595$ (100,030)$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 840,209$ 1,186,439$ 450,455$ 263.4%491,405$ 346,230$ INTERFUND TRANSACTIONS Transfer Out -$ -$ -$ N/A -$ -$ Reimbursements to Other Funds (75,900) (320,363) (320,361) 100.0%(349,485) (244,463) Total Interfund Transactions (75,900)$ (320,363)$ (320,361)$ 100.0%(349,485)$ (244,463)$ NET FUND INCREASE (DECREASE)764,309$ 866,076$ 130,093$ 141,920$ 101,767$ Note - Expenditures are recorded in program 171. Village of Oak Brook Hotel Tax Fund Financial Update For the Period Ending November 30, 2023 11/30/23 11/30/23 11/30/22 11/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 6,870,447$ 6,882,295$ 5,981,250$ 115.1%6,525,000$ 11,848$ Charges for Services - - N/A -$ Investment Interest 93,208 289,628 25,208 1148.9%27,500 196,420 Grants 550,000 - 998,919 0.0%1,089,730 (550,000) Miscellaneous - 2,383 917 260.0%1,000 2,383 Total Operating Revenues 7,513,655$ 7,174,306$ 7,006,294$ 102.4%7,643,230$ (339,349)$ OPERATING EXPENDITURES Personnel 1,120,894$ 44,745$ 41,520$ 107.8%45,294$ (1,076,149)$ Materials and Supplies 153,305 159,423 180,950 88.1%197,400 6,118 Operation and Contract 1,113,288 893,039 1,585,998 56.3%1,730,180 (220,249) Other Expenditures - - - N/A - Capital Outlay 6,800,810 1,839,421 8,457,460 21.7%9,226,320 (4,961,389) Total Operating Expenditures 9,188,297$ 2,936,628$ 10,265,928$ 28.6%11,199,194$ (6,251,669)$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES (1,674,642)$ 4,237,678$ (3,259,634)$ -130.0%(3,555,964)$ 5,912,320$ INTERFUND TRANSACTIONS Transfers In -$ 1,000,000$ -$ N/A -$ 1,000,000$ Reimbursements From Other Funds 296,428 199,430 - N/A - (96,998) Reimbursements To Other Funds (108,284) (311,575) - N/A - (203,291) Total Interfund Transactions 188,144$ 887,855$ -$ N/A -$ 699,711$ NET FUND INCREASE (DECREASE)(1,486,498)$ 5,125,533$ (3,259,634)$ (3,555,964)$ 6,612,031$ Village of Oak Brook Infrastructure Fund Financial Update For the Period Ending November 30, 2023 11/30/23 11/30/23 11/30/22 11/30/23 YTD % of YTD 2023 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax -$ 74,379$ 13,750$ 540.9%15,000$ 74,379$ Real Estate Tax 411,881 455,451 371,250 122.7%405,000 43,570 Investment Interest 1,937 6,064 9 66152.7%10 4,127 Total Operating Revenues 413,818$ 535,894$ 385,009$ 139.2%420,010$ 122,076$ EXPENDITURES Operation and Contract 4,575$ 5,625$ 4,675$ 120.3%5,100$ 1,050$ Other Expenditures 486,260 840,189 308,665 272.2%336,725 353,929 Total Expenditures 490,835$ 845,814$ 313,340$ 269.9%341,825$ 354,979$ NET FUND INCREASE (DECREASE)(77,017)$ (309,920)$ 71,670$ 78,185$ (232,903)$ Note - Expenditures are recorded in program 283. Village of Oak Brook Promenade TIF Fund Financial Update For the Period Ending November 30, 2023 11/30/23 11/30/23 11/30/22 11/30/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$ 481$ 358.4%525$ 1,125$ Building/Inspection Fees 2,025 1,350 1,833 73.6%2,000 (675) Water Sales 11,236,169 9,337,429 7,544,167 123.8%8,230,000 (1,898,740) Unmetered Sales 93,243 44,111 45,833 96.2%50,000 (49,132) Water Connection Fees 583,050 153,640 68,750 223.5%75,000 (429,410) Meter Charges 23,739 17,828 13,750 129.7%15,000 (5,911) Special Services 13,389 39,627 9,167 432.3%10,000 26,238 Investment Interest 81,053 897,055 18,333 4893.0%20,000 816,002 Proceeds from Property Sale 12,243,661 - - N/A - (12,243,661) Miscellaneous 114,494 107,848 45,833 235.3%50,000 (6,646) Total Operating Revenues 24,391,423$ 10,600,613$ 7,748,148$ 136.8%8,452,525$ (13,790,810)$ OPERATING EXPENDITURES Personnel 415,529$ 636,100$ 593,652$ 107.2%647,620$ 220,571$ Materials and Supplies 72,971 100,641 63,846 157.6%69,650 27,670 Operation and Contract 4,742,929 5,117,213 4,950,573 103.4%5,400,625 374,284 Capital Outlay 33,894 1,170,961 3,597,917 32.5%3,925,000 1,137,067 Total Expenditures 5,265,323$ 7,024,915$ 9,205,987$ 76.3%10,042,895$ 1,759,592$ Surplus (Deficit) of Revenues Over Expenditures 19,126,100$ 3,575,698$ (1,457,839)$ -245.3%(1,590,370)$ (15,550,402)$ INTERFUND TRANSACTIONS Reimbursements To Other Funds (385,451)$ (171,048)$ (385,449)$ 44.4%(420,490)$ 214,403$ Total Interfund Transactions (385,451)$ (171,048)$ (385,449)$ 44.4%(420,490)$ 214,403$ Fund Increase/(Decrease) - Budgetary Basis 18,740,649$ 3,404,650$ (1,843,288)$ (2,010,860)$ (15,335,999)$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay 33,894$ 1,170,961$ Depreciation Expense (383,333) (527,083) IMRF Pension Expense (30,000) (41,250) OPEB Expense (20,000) (27,500) Total GAAP Adjustments (399,439)$ 575,128$ Fund Increase/(Decrease) - GAAP Basis 18,341,210$ 3,979,778$ *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, 2023 Village of Oak Brook Monthly Operating Statement Sports Core Fund Consolidated Presentation For the Period Ending November 30, 2023 11/30/23 11/30/23 11/30/23 YTD % of YTD 2023 11/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$ 851,813$ 104.1%929,250$ 807,813$ 79,234$ Greens Fees - - - 1,463,558 1,463,558 1,200,833 121.9%1,310,000 1,252,085 211,473 Pro Shop Sales - - - 186,179 186,179 229,167 81.2%250,000 222,490 (36,311) Golf Lessons - - - 24,872 24,872 45,833 54.3%50,000 35,815 (10,943) Driving Range Fees - - - 402,046 402,046 320,833 125.3%350,000 354,227 47,819 Rentals - 254,583 147,168 497,006 898,757 993,667 90.4%1,084,000 1,043,302 (144,545) Programs/User Fees 113,980 - - - 113,980 63,342 179.9%69,100 83,836 30,144 Food Sales 53,070 - - 246,538 299,608 265,833 112.7%290,000 315,302 (15,694) Beverage Sales 18,909 - - 481,903 500,812 451,000 111.0%492,000 499,059 1,753 Taste of Oak Brook - - - - - - N/A - 66,812 (66,812) Grants - - - - - - N/A - - - Other Revenue 16,080 - - 34,326 50,406 25,323 199.1%27,625 20,079 30,327 Total Operating Revenues 608,986$ 254,583$ 147,168$ 3,816,528$ 4,827,265$ 4,447,644$ 108.5%4,851,975$ 4,700,819$ 126,446$ OPERATING EXPENDITURES Personnel 63,456$ -$ 11,458$ 1,311,312$ 1,386,226$ 1,584,293$ 87.5%1,671,380$ 1,369,108$ 17,118$ Materials & Supplies 63,628 1,064 13,685 590,066 668,443 753,535 88.7%718,900 778,559 (110,116) Operational & Contractual 442,023 42,324 66,209 365,780 916,336 692,832 132.3%942,765 940,463 (24,127) Other - - - - - - N/A - - - Capital 19,915 - - 180,793 200,708 1,447,188 13.9%466,750 375,589 (174,881) Total Operating Expenditures 589,022$ 43,388$ 91,352$ 2,447,951$ 3,171,713$ 4,477,848$ 70.8%3,799,795$ 3,463,719$ (292,006)$ B&T Administration Overhead Allocation*40,135$ -$ (40,135)$ -$ -$ -$ N/A -$ -$ -$ Operating Revenues Over (Under) Expenditures 60,099$ 211,195$ 15,681$ 1,368,577$ 1,655,552$ (30,204)$ -5481.2%1,052,180$ 1,237,100$ 418,452$ INTERFUND TRANSACTIONS Interfund Loan**-$ -$ -$ -$ -$ -$ N/A -$ -$ -$ Transfer From General Fund - - - - - - N/A - - - Transfer From Golf Surcharge Fund - - - - - 137,500 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) (74,220) 100.0%(80,967) (69,168) (5,050) Total Interfund Transactions (53,976)$ -$ -$ (20,242)$ (74,218)$ 63,280$ -117.3%69,033$ (69,168)$ (5,050)$ Total Revenues Over (Under) Expenditures - Budgetary Basis 6,123$ 211,195$ 15,681$ 1,348,335$ 1,581,334$ 33,076$ 1,121,213$ 1,167,932$ 413,402$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay 19,915$ -$ -$ 180,793$ 200,708$ 375,589$ 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,614) OPEB Expense - - (1,250) (25,667) (26,917) (26,917) Total GAAP Adjustments (136,172)$ (1,545)$ (27,500)$ (93,107)$ (258,324)$ (83,470)$ Fund Increase/(Decrease) - GAAP Basis (130,049)$ 209,650$ (11,819)$ 1,255,228$ 1,323,010$ 1,084,462$ *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, 2023 11/30/23 11/30/23 822 11/30/23 YTD % of YTD 2023 11/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$ 475,979$ 85.5%519,250$ 402,838$ 4,109$ Programs/User Fees - 71,921 42,059 - 113,980 63,341.67 179.9%69,100 83,836 30,144 Food Sales - - - 53,070 53,070 36,666.67 144.7%40,000 44,287 - Beverage Sales - - - 18,909 18,909 15,583.33 121.3%17,000 17,712 - Grants - - - - - - N/A - - - Other Revenue 16,080 - - - 16,080 2,131 754.5%2,325 2,989 13,091 Total Operating Revenues 16,080$ 461,296$ 59,631$ 71,979$ 608,986$ 593,702$ 102.6%647,675$ 551,661$ 47,344$ OPERATING EXPENDITURES Personnel 233$ 35,498$ -$ 27,725$ 63,456$ 182,204$ 34.8%198,768$ 67,599$ (4,143)$ Materials & Supplies 428 48,606 2,014 12,580 63,628 65,813 96.7%71,796 69,540 (5,912) Operational & Contractual 53,803 310,243 73,051 4,926 442,023 226,403 195.2%246,985 309,199 132,824 Other - - - - - - N/A - - Capital 19,915 - - - 19,915 504,167 4.0%550,000 244,355 (224,440) Total Operating Expenditures 74,379$ 394,347$ 75,065$ 45,231$ 589,022$ 978,587$ 60.2%1,067,549$ 690,693$ (101,671)$ B&T Administration Overhead Allocation*80,270$ (28,895)$ (8,029)$ (3,211)$ 40,135$ -$ N/A 43,783$ 32,738$ 7,397$ Operating Revenues Over (Under) Expenditures 21,971$ 38,054$ (23,463)$ 23,537$ 60,099$ (384,885)$ -15.6%(376,092)$ (106,294)$ 156,412$ 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) (18,555) 290.9%(20,242) (17,292) (36,684) Total Interfund Transactions (53,976)$ -$ -$ -$ (53,976)$ (18,555)$ 290.9%(20,242)$ (17,292)$ (36,684)$ Total Revenues Over (Under) Expenditures - Budgetary Basis (32,005)$ 38,054$ (23,463)$ 23,537$ 6,123$ (403,440)$ (396,334)$ (123,586)$ 119,728$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay 19,915$ -$ -$ -$ 19,915$ 244,355$ 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 (40,914)$ (91,667)$ (2,475)$ (1,117)$ (136,172)$ 88,268$ Fund Increase/(Decrease) - GAAP Basis (72,919)$ (53,613)$ (25,938)$ 22,421$ (130,049)$ (35,318)$ *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 o 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, 2023 11/30/23 11/30/23 11/30/23 YTD % of YTD 2023 11/30/22 Difference 815 816 YTD Amended Amended Adopted YTD Prior Polo Open Fields Total Budget Budget Budget Total Year OPERATING REVENUES Field Rentals -$ 168,503$ 168,503$ 165,917$ 101.6%181,000$ 159,143$ 9,360$ Range Rentals - 86,080 86,080 77,917 110.5%85,000 80,000 6,080 Taste of Oak Brook - - - - N/A - 66,812 - Other Revenue - - - - N/A - - Total Operating Revenues -$ 254,583$ 254,583$ 243,833$ 104.4%266,000$ 305,955$ 15,440$ OPERATING EXPENDITURES Personnel -$ -$ -$ -$ N/A -$ -$ Materials & Supplies - 1,064 1,064 8,699 12.2%9,490$ - 1,064 Operational & Contractual 5 42,319 42,324 115,445 36.7%125,940 222,813 (180,489) Capital - - - - N/A - - Total Operating Expenditures 5$ 43,383$ 43,388$ 124,144$ 34.9%135,430$ 222,813$ (179,425)$ Operating Revenues Over (Under) Expenditures (5)$ 211,200$ 211,195$ 119,689$ 176.5%130,570$ 83,142$ 194,865$ INTERFUND TRANSACTIONS Transfer From Hotel Tax Fund -$ -$ -$ -$ N/A -$ -$ -$ Total Interfund Transactions -$ -$ -$ -$ N/A -$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis (5)$ 211,200$ 211,195$ 119,689$ 130,570$ 83,142$ 194,865$ 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 (5)$ 209,655$ 209,650$ 81,597$ *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, 2023 11/30/23 11/30/23 821 YTD % of YTD 2023 11/30/22 Difference B&T Amended Amended Adopted YTD Prior Clubhouse Budget Budget Budget Total Year OPERATING REVENUES Rentals 147,168$ 320,833$ 45.9%350,000$ 348,592$ (201,424)$ Other Revenue - - 0.0%- - - Total Operating Revenues 147,168$ 320,833$ 45.9%350,000$ 348,592$ (201,424)$ OPERATING EXPENDITURES Personnel 11,458$ 131,041$ N/A 142,954$ 117,319$ (105,861)$ Materials & Supplies 13,685 21,974 62.3%23,972 10,452 3,233 Operational & Contractual 66,209 70,438 94.0%76,842 72,597 (6,388) Capital - - N/A - - - Total Operating Expenditures 91,352$ 223,453$ 40.9%243,767$ 200,368$ (109,016)$ B&T Administration Overhead Allocation*(40,135)$ -$ N/A (43,784)$ (32,738)$ (7,397)$ Operating Revenues Over (Under) Expenditures 15,681$ 97,380$ 16.1%62,449$ 115,486$ (99,805)$ INTERFUND TRANSACTIONS Transfer From General Fund -$ -$ 0.0%-$ -$ -$ Total Interfund Transactions -$ -$ 0.0%-$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis 15,681$ 97,380$ 62,449$ 115,486$ (99,805)$ 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 (11,819)$ 87,986$ *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, 2023 11/30/23 11/30/23 823 831 832 833 834 11/30/23 YTD % of YTD 2023 11/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$ 375,833$ 127.7%410,000$ 404,975$ 75,125$ Greens Fees - 1,463,558 - - - 1,463,558 1,200,833 121.9%1,310,000 1,252,085 211,473 Pro Shop Sales - 186,179 - - - 186,179 229,167 81.2%250,000 222,490 (36,311) Golf Lessons - - 24,872 - - 24,872 45,833 54.3%50,000 35,815 (10,943) Driving Range Fees - - 402,046 - - 402,046 320,833 125.3%350,000 354,227 47,819 Rentals - 1,980 9,000 486,026 - 497,006 429,000 115.9%468,000 455,567 41,439 Food Sales 246,538 - - - 246,538 229,167 107.6%250,000 271,015 (24,477) Beverage Sales 481,903 - - - - 481,903 435,417 110.7%475,000 481,347 556 Other Revenue 17,864 16,462 - - - 34,326 23,192 148.0%25,300 17,090 17,236 Total Operating Revenues 746,305$ 2,148,279$ 435,918$ 486,026$ -$ 3,816,528$ 3,289,275$ 116.0%3,588,300$ 3,494,611$ 321,917$ OPERATING EXPENDITURES Personnel 215,197$ 512,035$ 68,927$ 71,417$ 443,736$ 1,311,312$ 1,271,048$ 103.2%1,386,598$ 1,184,190$ 127,122$ Materials & Supplies 277,298 96,551 14,812 3,033 198,372 590,066 657,048 89.8%716,780 698,567 (108,501) Operational & Contractual 7,703 241,737 13,610 61,388 41,342 365,780 280,546 130.4%306,050 335,854 29,926 Other - - - - - - - N/A - - - Capital - 72,758 13,290 - 94,745 180,793 943,021 19.2%1,028,751 131,234 49,559 Total Operating Expenditures 500,198$ 923,081$ 110,639$ 135,838$ 778,195$ 2,447,951$ 3,151,664$ 77.7%3,438,178$ 2,349,845$ 98,106$ Operating Revenues Over (Under) Expenditures 246,107$ 1,225,198$ 325,279$ 350,188$ (778,195)$ 1,368,577$ 137,611$ 994.5%150,122$ 1,144,766$ 223,811$ INTERFUND TRANSACTIONS Transfer from Golf Surcharge -$ -$ -$ -$ -$ -$ 137,500$ 0.0%150,000$ -$ -$ Reimbursement to General Fund - (20,242) - - - (20,242) (55,665) 36.4%(60,725) (51,876) 31,634 Total Interfund Transactions -$ (20,242)$ -$ -$ -$ (20,242)$ 81,835$ -24.7%89,275$ (51,876)$ 31,634$ Total Revenues Over (Under) Expenditures - Budgetary Basis 246,107$ 1,204,956$ 325,279$ 350,188$ (778,195)$ 1,348,335$ 219,447$ 239,397$ 1,092,890$ 255,445$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay -$ 72,758$ 13,290$ -$ 94,745$ 180,793$ 131,234$ 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,485) OPEB Expense (2,750) (13,750) - - (9,167) (25,667) (25,667) Total GAAP Adjustments (5,958)$ (46,409)$ 10,265$ (11,917)$ (39,088)$ (93,107)$ (142,693)$ Fund Increase/(Decrease) - GAAP Basis 240,149$ 1,158,548$ 335,544$ 338,271$ (817,283)$ 1,255,228$ 950,197$ *Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.