Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
08 - August 2023 Monthly Financial Report
VILLAGE OAK BROOK OF MONTHLY FINANCIAL REPORTS AUGUST 2023 YTD YTD Net Fund Ending YTD YTD Increase Fund Balance Governmental Funds Revenues Expenditures (Decrease)(Deficit) General Fund (Major Fund)24,802,456$ 17,444,572$ 7,357,884$ 45,828,936$ Main operating fund of the Village. Hotel Fund (Major Fund)1,018,707$ 415,203$ 603,504$ 2,993,850$ Collects and spends resources from the 3% hotel/motel tax. Motor Fuel Tax Fund 267,227$ 103,678$ 163,549$ 1,861,087$ Collects and spends resources from the State motor fuel tax. Infrastructure Fund (Major Fund)5,202,510$ 2,294,318$ 2,908,192$ 11,790,686$ Accounts for construction and maintenance of roadways, drainage, and safety path systems. Promenade TIF Fund (Major Fund)230,009$ 341,566$ (111,557)$ 202,067$ 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)6,687,302$ 5,193,671$ 1,493,631$ 20,369,841$ Collects user fees for the distribution of water and maintenance of infrastructure. Sports Core Fund (Major Fund)3,914,251$ 2,365,855$ 1,548,396$ 2,696,183$ Accounts for revenues and expenses relating to administration, programs, food and beverage operations, and golf course. Golf Surcharge Fund 89,378$ -$ 89,378$ 356,447$ Accounts for the collection of the $3 per round golf surcharge. Internal Service Funds Self Insurance Fund 1,639,027$ 2,390,094$ (751,068)$ (776,448)$ Accounts for the Village's health insurance costs and the related contributions from the Village, employees, retirees, and other agencies. Garage Fund 461,854$ 354,022$ 107,832$ 361,103$ Accounts for the maintenance of the Village's vehicle fleet and the related departmental reimbursements. Equipment Replacement Fund 926,461$ 768,583$ 157,878$ 2,982,764$ 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 August 31, 2023 8/31/23 8/31/23 8/31/22 8/31/23 YTD % of YTD 2023 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax 12,044,173$ 11,602,516 10,666,667$ 108.8%16,000,000$ (441,657)$ State Income Tax 968,345 919,125 763,333 120.4%1,145,000 (49,220) Replacement Tax 782,464 701,174 300,000 233.7%450,000 (81,290) Road & Bridge Tax 11,734 16,950 23,333 72.6%35,000 5,216 Local Use Tax 215,419 227,534 200,000 113.8%300,000 12,115 Cannabis Use Tax 9,266 8,373 10,600 79.0%15,900 (893) Grants 10,466 576,357 10,442 5519.8%15,662 565,891 Utility/Telecom. Tax 3,801,219 3,380,917 3,748,667 90.2%5,623,000 (420,302) Licenses and Permits 1,555,582 3,341,868 1,300,323 257.0%1,950,485 1,786,286 Charges for Services 1,534,056 2,077,826 1,098,247 189.2%1,647,370 543,770 Investment Interest 149,959 585,104 133,333 438.8%200,000 435,145 Miscellaneous Income 494,295 843,569 682,367 123.6%1,023,551 349,274 Total Operating Revenues 21,576,978$ 24,281,313$ 18,937,312$ 128.2%28,405,969$ 2,704,335$ OPERATING EXPENDITURES Personnel 11,649,235$ 13,118,002$ 14,758,034$ 88.9%22,137,051$ 1,468,767$ Materials and Supplies 294,916 361,000 398,037 90.7%597,056 66,084$ Operation and Contract 2,660,740 3,322,985 3,603,148 92.2%5,404,722 662,245$ Other Expenditures 77,546 6,394 6,000 106.6%9,000 (71,152)$ Capital Outlay 92,837 636,191 633,716 100.4%950,575 543,354$ Total Operating Expenditures 14,775,274$ 17,444,572$ 19,398,936$ 89.9%29,098,405$ 2,669,298$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 6,801,704$ 6,836,741$ (461,624)$ -1481.0%(692,436)$ 35,037$ INTERFUND TRANSACTIONS Transfers In -$ -$ -$ N/A -$ -$ Transfers Out - N/A - Reimbursements From Other Funds 376,816 521,143 451,601 115.4%677,401 144,327 Reimbursements To Other Funds - - - N/A - - Total Interfund Transactions 376,816$ 521,143$ 451,601$ 115.4%677,401$ 144,327$ NET FUND INCREASE (DECREASE)7,178,520$ 7,357,884$ (10,023)$ (15,035)$ 179,364$ *Includes the collection of Income Tax, Use Tax, Road & Bridge Tax, Personal Property Replacement Tax, and Cannabis Use Tax. Village of Oak Brook General Fund Financial Update For the Period Ending August 31, 2023 8/31/23 8/31/23 8/31/22 8/31/23 YTD % of YTD 2023 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Hotel Tax 755,890$ 972,196$ 766,667$ 126.8%1,150,000$ 216,306$ Investment Interest 9,973 44,511 8,000 556.4%12,000 34,538 Loan Interest 3,000 2,000 2,667 75.0%4,000 (1,000) Miscellaneous - - Total Operating Revenues 768,863$ 1,018,707$ 777,333$ 131.1%1,166,000$ 249,844$ EXPENDITURES Operation and Contract 334,246$ 182,212$ 449,730$ 40.5%674,595$ (152,034)$ Capital Outlay 52,696 - - N/A - (52,696) Total Expenditures 386,942$ 182,212$ 449,730$ 40.5%674,595$ (204,730)$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 381,921$ 836,495$ 327,603$ 255.3%491,405$ 454,574$ INTERFUND TRANSACTIONS Transfer Out -$ -$ -$ N/A -$ -$ Reimbursements to Other Funds (55,200) (232,991) (232,990) 100.0%(349,485) (177,791) Total Interfund Transactions (55,200)$ (232,991)$ (232,990)$ 100.0%(349,485)$ (177,791)$ NET FUND INCREASE (DECREASE)326,721$ 603,504$ 94,613$ 141,920$ 276,783$ Note - Expenditures are recorded in program 171. Village of Oak Brook Hotel Tax Fund Financial Update For the Period Ending August 31, 2023 8/31/23 8/31/23 8/31/22 8/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 4,908,338$ 4,914,922$ 4,350,000$ 113.0%6,525,000$ 6,584$ Charges for Services - - N/A -$ Investment Interest 50,883 140,448 18,333 766.1%27,500 89,565 Grants - - 726,487 0.0%1,089,730 - Miscellaneous - 2,100 667 315.0%1,000 2,100 Total Operating Revenues 4,959,221$ 5,057,470$ 5,095,487$ 99.3%7,643,230$ 98,249$ OPERATING EXPENDITURES Personnel 876,812$ 13,123$ 30,196$ 43.5%45,294$ (863,689)$ Materials and Supplies 133,418 155,413 131,600 118.1%197,400 21,995 Operation and Contract 751,330 575,213 1,153,453 49.9%1,730,180 (176,117) Other Expenditures - - - N/A - Capital Outlay 4,777,084 1,323,969 6,150,880 21.5%9,226,320 (3,453,115) Total Operating Expenditures 6,538,644$ 2,067,718$ 7,466,129$ 27.7%11,199,194$ (4,470,926)$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES (1,579,423)$ 2,989,752$ (2,370,643)$ -126.1%(3,555,964)$ 4,569,175$ INTERFUND TRANSACTIONS Transfers In -$ -$ -$ N/A -$ -$ Reimbursements From Other Funds 215,584 145,040 - N/A - (70,544) Reimbursements To Other Funds (78,752) (226,600) - N/A - (147,848) Total Interfund Transactions 136,832$ (81,560)$ -$ N/A -$ (218,392)$ NET FUND INCREASE (DECREASE)(1,442,591)$ 2,908,192$ (2,370,643)$ (3,555,964)$ 4,350,783$ Village of Oak Brook Infrastructure Fund Financial Update For the Period Ending August 31, 2023 8/31/23 8/31/23 8/31/22 8/31/23 YTD % of YTD 2023 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax -$ -$ 10,000$ 0.0%15,000$ -$ Real Estate Tax 207,773 227,725 270,000 84.3%405,000 19,952 Investment Interest 436 2,283 7 34247.4%10 1,847 Total Operating Revenues 208,209$ 230,009$ 280,007$ 82.1%420,010$ 21,799$ EXPENDITURES Operation and Contract -$ 4,773$ 3,400$ 140.4%5,100$ 4,773$ Other Expenditures 486,260 336,793 224,483 150.0%336,725 (149,467) Total Expenditures 486,260$ 341,566$ 227,883$ 149.9%341,825$ (144,694)$ NET FUND INCREASE (DECREASE)(278,051)$ (111,557)$ 52,123$ 78,185$ 166,493$ Note - Expenditures are recorded in program 283. Village of Oak Brook Promenade TIF Fund Financial Update For the Period Ending August 31, 2023 8/31/23 8/31/23 8/31/22 8/31/23 YTD % of YTD 2023 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Plan Review Fees 450$ 1,500$ 350$ 428.6%525$ 1,050$ Building/Inspection Fees 1,500 1,350 1,333 101.3%2,000 (150) Water Sales 6,793,467 5,897,566 5,486,667 107.5%8,230,000 (895,901) Unmetered Sales 70,480 35,959 33,333 107.9%50,000 (34,521) Water Connection Fees 568,330 135,700 50,000 271.4%75,000 (432,630) Fire Service Charge - N/A - - Meter Charges 19,149 15,572 10,000 155.7%15,000 (3,577) Special Services 13,389 25,741 6,667 386.1%10,000 12,352 Investment Interest 33,323 494,889 13,333 3711.7%20,000 461,566 Proceeds from Property Sale - - - N/A - - Miscellaneous 81,639 79,025 33,333 237.1%50,000 (2,614) Total Operating Revenues 7,581,727$ 6,687,302$ 5,635,017$ 118.7%8,452,525$ (894,425)$ OPERATING EXPENDITURES Personnel 285,472$ 448,248$ 431,747$ 103.8%647,620$ 162,776$ Materials and Supplies 49,337 70,277 46,433 151.4%69,650 20,940 Operation and Contract 2,505,021 3,379,787 3,600,417 93.9%5,400,625 874,766 Capital Outlay 31,394 1,170,961 2,616,667 44.8%3,925,000 1,139,567 Total Expenditures 2,871,224$ 5,069,273$ 6,695,263$ 75.7%10,042,895$ 2,198,049$ Surplus (Deficit) of Revenues Over Expenditures 4,710,503$ 1,618,029$ (1,060,247)$ -152.6%(1,590,370)$ (3,092,474)$ INTERFUND TRANSACTIONS Reimbursements To Other Funds (280,328)$ (124,398)$ (280,327)$ 44.4%(420,490)$ 155,930$ Total Interfund Transactions (280,328)$ (124,398)$ (280,327)$ 44.4%(420,490)$ 155,930$ Fund Increase/(Decrease) - Budgetary Basis 4,430,175$ 1,493,631$ (1,340,573)$ (2,010,860)$ (2,936,544)$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay 31,394$ 1,170,961$ Depreciation Expense (383,333) (383,333) IMRF Pension Expense (30,000) (30,000) OPEB Expense (20,000) (20,000) Total GAAP Adjustments (401,939)$ 737,628$ Fund Increase/(Decrease) - GAAP Basis 4,028,236$ 2,231,259$ *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 August 31, 2023 Village of Oak Brook Monthly Operating Statement Sports Core Fund Consolidated Presentation For the Period Ending August 31, 2023 8/31/23 8/31/23 8/31/23 YTD % of YTD 2023 8/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$ 619,500$ 143.2%929,250$ 809,063$ 77,984$ Greens Fees - - - 1,092,800 1,092,800 873,333 125.1%1,310,000 898,170 194,630 Pro Shop Sales - - - 155,894 155,894 166,667 93.5%250,000 160,474 (4,580) Golf Lessons - - - 24,052 24,052 33,333 72.2%50,000 39,448 (15,396) Driving Range Fees - - - 360,520 360,520 233,333 154.5%350,000 303,523 56,998 Rentals - 193,080 60,524 362,628 616,232 722,667 85.3%1,084,000 715,697 (99,465) Programs/User Fees 94,099 - - - 94,099 46,067 204.3%69,100 74,031 20,068 Food Sales 50,253 - - 211,860 262,113 193,333 135.6%290,000 244,824 17,289 Beverage Sales 17,585 - - 373,726 391,311 328,000 119.3%492,000 376,084 15,227 Taste of Oak Brook - - - - - - N/A - 66,812 (66,812) Grants - - - - - - N/A - - - Other Revenue 2,175 - - 28,008 30,183 18,417 163.9%27,625 1,784 28,399 Total Operating Revenues 571,059$ 193,080$ 60,524$ 3,089,588$ 3,914,251$ 3,234,650$ 121.0%4,851,975$ 3,689,909$ 224,342$ OPERATING EXPENDITURES Personnel 57,227$ -$ 6,172$ 920,512$ 983,911$ 1,152,213$ 85.4%1,671,380$ 950,436$ 33,475$ Materials & Supplies 55,557 1,064 7,144 458,672 522,437 548,025 95.3%718,900 556,919 (34,482) Operational & Contractual 358,838 30,150 49,010 256,120 694,118 503,878 137.8%942,765 657,734 36,384 Other - - - - - - N/A - - - Capital - - - 111,412 111,412 1,052,500 10.6%466,750 340,230 (228,818) Total Operating Expenditures 471,622$ 31,214$ 62,326$ 1,746,716$ 2,311,878$ 3,256,617$ 71.0%3,799,795$ 2,505,320$ (193,442)$ B&T Administration Overhead Allocation*-$ -$ -$ -$ -$ -$ N/A -$ (0)$ (0)$ Operating Revenues Over (Under) Expenditures 99,437$ 161,866$ (1,802)$ 1,342,872$ 1,602,373$ (21,967)$ -7294.5%1,052,180$ 1,184,589$ 417,784$ INTERFUND TRANSACTIONS Interfund Loan**-$ -$ -$ -$ -$ -$ N/A -$ -$ -$ Transfer From General Fund - - - - - - N/A - - - Transfer From Golf Surcharge Fund - - - - - 100,000 0.0%150,000 - - Reimbursement From Infrastructure Fund - - - - - - N/A - - - Reimbursement From Water Fund - - - - - - N/A - - - Reimbursement To General Fund (33,735) - - (20,242) (53,977) (53,978) 100.0%(80,967) (50,304) (3,673) Total Interfund Transactions (33,735)$ -$ -$ (20,242)$ (53,977)$ 46,022$ -117.3%69,033$ (50,304)$ (3,673)$ Total Revenues Over (Under) Expenditures - Budgetary Basis 65,702$ 161,866$ (1,802)$ 1,322,630$ 1,548,396$ 24,055$ 1,121,213$ 1,134,285$ 414,111$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ -$ -$ 111,412$ 111,412$ 315,230$ Depreciation Expense (112,151) (1,123) (25,000) (164,200) (302,475) (278,725) IMRF Pension Expense (1,367) - (1,250) (16,333) (18,950) (18,950) OPEB Expense - - (1,250) (18,667) (19,917) (18,667) Total GAAP Adjustments (113,518)$ (1,123)$ (27,500)$ (87,788)$ (229,929)$ (1,111)$ Fund Increase/(Decrease) - GAAP Basis (47,816)$ 160,743$ (29,302)$ 1,234,842$ 1,318,467$ 1,133,174$ *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 August 31, 2023 8/31/23 8/31/23 822 8/31/23 YTD % of YTD 2023 8/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$ 346,167$ 117.6%519,250$ 402,838$ 4,109$ Programs/User Fees - 67,221 26,878 - 94,099 46,066.67 204.3%69,100 74,031 20,068 Food Sales - - - 50,253 50,253 26,666.67 188.4%40,000 43,314 - Beverage Sales - - - 17,585 17,585 11,333.33 155.2%17,000 17,140 - Grants - - - - - - N/A - - - Other Revenue 2,175 - - - 2,175 1,550 140.3%2,325 1,784 391 Total Operating Revenues 2,175$ 456,596$ 44,450$ 67,838$ 571,059$ 431,783$ 132.3%647,675$ 539,107$ 24,568$ OPERATING EXPENDITURES Personnel 233$ 31,039$ -$ 25,955$ 57,227$ 132,512$ 43.2%198,768$ 60,948$ (3,721)$ Materials & Supplies 136 40,827 2,014 12,580 55,557 47,864 116.1%71,796 58,139 (2,582) Operational & Contractual 47,131 259,227 48,347 4,133 358,838 164,657 217.9%246,985 273,678 85,160 Other - - - - - - N/A - - Capital - - - - - 366,667 0.0%550,000 232,016 (232,016) Total Operating Expenditures 47,500$ 331,093$ 50,361$ 42,668$ 471,622$ 711,700$ 66.3%1,067,549$ 624,781$ (153,159)$ B&T Administration Overhead Allocation*-$ -$ -$ -$ -$ -$ N/A 43,783$ 12,352$ (12,352)$ Operating Revenues Over (Under) Expenditures (45,325)$ 125,503$ (5,911)$ 25,170$ 99,437$ (279,916)$ -35.5%(376,092)$ (73,322)$ 165,376$ Transfer From General Fund - - - - - - N/A - - - Reimbursement From Infrastructure Fund - - - - - -$ N/A - - - Reimbursement From Water Fund - - - - - - N/A - - - Reimbursement To General Fund (33,735) - - - (33,735) (13,495) 250.0%(20,242) (12,576) (21,159) Total Interfund Transactions (33,735)$ -$ -$ -$ (33,735)$ (13,495)$ 250.0%(20,242)$ (12,576)$ (21,159)$ Total Revenues Over (Under) Expenditures - Budgetary Basis (79,060)$ 125,503$ (5,911)$ 25,170$ 65,702$ (293,411)$ (396,334)$ (85,898)$ 144,217$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ -$ -$ -$ -$ 232,016$ Depreciation Expense (42,906) (66,667) (1,800) (779) (112,151) (112,151) IMRF Pension Expense (1,333) - - (33) (1,367) (1,367) Total GAAP Adjustments (44,239)$ (66,667)$ (1,800)$ (812)$ (113,518)$ 118,498$ Fund Increase/(Decrease) - GAAP Basis (123,299)$ 58,836$ (7,711)$ 24,358$ (47,816)$ 32,600$ *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 August 31, 2023 8/31/23 8/31/23 8/31/23 YTD % of YTD 2023 8/31/22 Difference 815 816 YTD Amended Amended Adopted YTD Prior Polo Open Fields Total Budget Budget Budget Total Year OPERATING REVENUES Field Rentals -$ 107,000$ 107,000$ 120,667$ 88.7%181,000$ 113,393$ (6,393)$ Range Rentals - 86,080 86,080 56,667 151.9%85,000 80,000 6,080 Taste of Oak Brook - - - - N/A - 66,812 - Other Revenue - - - - N/A - - Total Operating Revenues -$ 193,080$ 193,080$ 177,333$ 108.9%266,000$ 260,205$ (313)$ OPERATING EXPENDITURES Personnel -$ -$ -$ -$ N/A -$ -$ Materials & Supplies - 1,064 1,064 6,327 16.8%9,490$ - 1,064 Operational & Contractual - 30,150 30,150 83,960 35.9%125,940 67,946 (37,796) Capital - - - - N/A - - Total Operating Expenditures -$ 31,214$ 31,214$ 90,287$ 34.6%135,430$ 67,946$ (36,732)$ Operating Revenues Over (Under) Expenditures -$ 161,866$ 161,866$ 87,047$ 186.0%130,570$ 192,259$ 36,419$ INTERFUND TRANSACTIONS Transfer From Hotel Tax Fund -$ -$ -$ -$ N/A -$ -$ -$ Total Interfund Transactions -$ -$ -$ -$ N/A -$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis -$ 161,866$ 161,866$ 87,047$ 130,570$ 192,259$ 36,419$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ -$ -$ -$ Depreciation Expense - (1,123) (1,123) (1,123) Total GAAP Adjustments -$ (1,123)$ (1,123)$ (1,123)$ Fund Increase/(Decrease) - GAAP Basis -$ 160,743$ 160,743$ 191,136$ *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 August 31, 2023 8/31/23 8/31/23 821 YTD % of YTD 2023 8/31/22 Difference B&T Amended Amended Adopted YTD Prior Clubhouse Budget Budget Budget Total Year OPERATING REVENUES Rentals 60,524$ 233,333$ 25.9%350,000$ 202,286$ (141,762)$ Other Revenue - - 0.0%- - - Total Operating Revenues 60,524$ 233,333$ 25.9%350,000$ 202,286$ (141,762)$ OPERATING EXPENDITURES Personnel 6,172$ 95,303$ N/A 142,954$ 84,793$ (78,621)$ Materials & Supplies 7,144 15,981 44.7%23,972 5,454 1,690 Operational & Contractual 49,010 51,228 95.7%76,842 57,924 (8,914) Capital - - N/A - - - Total Operating Expenditures 62,326$ 162,512$ 38.4%243,767$ 148,171$ (85,845)$ B&T Administration Overhead Allocation*-$ -$ N/A (43,784)$ (12,352)$ 12,352$ Operating Revenues Over (Under) Expenditures (1,802)$ 70,822$ -2.5%62,449$ 41,763$ (43,565)$ INTERFUND TRANSACTIONS Transfer From General Fund -$ -$ 0.0%-$ -$ -$ Total Interfund Transactions -$ -$ 0.0%-$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis (1,802)$ 70,822$ 62,449$ 41,763$ (43,565)$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ (25,000)$ Depreciation Expense (25,000) (1,250) IMRF Pension Expense (1,250) (1,250) OPEB Expense (1,250) - Total GAAP Adjustments (27,500)$ (27,500)$ Fund Increase/(Decrease) - GAAP Basis (29,302)$ 14,263$ *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 August 31, 2023 8/31/23 8/31/23 823 831 832 833 834 8/31/23 YTD % of YTD 2023 8/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$ 273,333$ 175.6%410,000$ 406,225$ 73,875$ Greens Fees - 1,092,800 - - - 1,092,800 873,333 125.1%1,310,000 898,170 194,630 Pro Shop Sales - 155,894 - - - 155,894 166,667 93.5%250,000 160,474 (4,580) Golf Lessons - - 24,052 - - 24,052 33,333 72.2%50,000 39,448 (15,396) Driving Range Fees - - 360,520 - - 360,520 233,333 154.5%350,000 303,523 56,998 Rentals - 965 - 361,663 - 362,628 312,000 116.2%468,000 320,019 42,609 Food Sales 211,860 - - - 211,860 166,667 127.1%250,000 201,510 10,350 Beverage Sales 373,726 - - - - 373,726 316,667 118.0%475,000 358,944 14,782 Other Revenue 14,298 13,710 - - - 28,008 16,867 166.1%25,300 - 28,008 Total Operating Revenues 599,884$ 1,743,469$ 384,572$ 361,663$ -$ 3,089,588$ 2,392,200$ 129.2%3,588,300$ 2,688,312$ 401,276$ OPERATING EXPENDITURES Personnel 173,566$ 378,924$ 49,908$ 48,704$ 269,410$ 920,512$ 924,399$ 99.6%1,386,598$ 804,696$ 115,816$ Materials & Supplies 233,687 70,984 14,812 2,945 136,244 458,672 477,853 96.0%716,780 493,326 (34,654) Operational & Contractual 5,494 157,040 8,017 51,158 34,411 256,120 204,033 125.5%306,050 258,187 (2,067) Other - - - - - - - N/A - - - Capital - 72,758 13,290 - 25,364 111,412 685,834 16.2%1,028,751 108,214 3,198 Total Operating Expenditures 412,747$ 679,706$ 86,027$ 102,807$ 465,429$ 1,746,716$ 2,292,119$ 76.2%3,438,178$ 1,664,423$ 82,293$ Operating Revenues Over (Under) Expenditures 187,137$ 1,063,763$ 298,545$ 258,856$ (465,429)$ 1,342,872$ 100,081$ 1341.8%150,122$ 1,023,889$ 318,983$ INTERFUND TRANSACTIONS Transfer from Golf Surcharge -$ -$ -$ -$ -$ -$ 100,000$ 0.0%150,000$ -$ -$ Reimbursement to General Fund - (20,242) - - - (20,242) (40,483) 50.0%(60,725) (37,728) 17,486 Total Interfund Transactions -$ (20,242)$ -$ -$ -$ (20,242)$ 59,517$ -34.0%89,275$ (37,728)$ 17,486$ Total Revenues Over (Under) Expenditures - Budgetary Basis 187,137$ 1,043,521$ 298,545$ 258,856$ (465,429)$ 1,322,630$ 159,598$ 239,397$ 986,161$ 336,469$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay -$ 72,758$ 13,290$ -$ 25,364$ 111,412$ 108,214$ Depreciation Expense (667) (70,000) (1,533) (8,667) (83,333) (164,200) (164,200) IMRF Pension Expense (1,667) (6,667) (667) - (7,333) (16,333) (16,333) OPEB Expense (2,000) (10,000) - - (6,667) (18,667) (18,667) Total GAAP Adjustments (4,333)$ (13,909)$ 11,090$ (8,667)$ (71,969)$ (87,788)$ (90,986)$ Fund Increase/(Decrease) - GAAP Basis 182,804$ 1,029,613$ 309,635$ 250,189$ (537,398)$ 1,234,842$ 895,175$ *Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.