Loading...
07 - July 2023 Monthly Financial ReportVILLAGE OAK BROOKOF MONTHLY FINANCIAL REPORTS JULY 2023 YTD YTD Net Fund Ending YTD YTD Increase Fund Balance Governmental Funds Revenues Expenditures (Decrease)(Deficit) General Fund (Major Fund)22,309,975$ 15,206,165$ 7,103,810$ 45,574,861$ Main operating fund of the Village. Hotel Fund (Major Fund)879,389$ 264,699$ 614,690$ 3,005,036$ Collects and spends resources from the 3% hotel/motel tax. Motor Fuel Tax Fund 238,096$ 103,678$ 134,417$ 1,831,955$ Collects and spends resources from the State motor fuel tax. Infrastructure Fund (Major Fund)4,548,904$ 2,169,867$ 2,379,037$ 11,261,531$ Accounts for construction and maintenance of roadways, drainage, and safety path systems. Promenade TIF Fund (Major Fund)230,009$ 340,406$ (110,397)$ 203,227$ 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)5,981,330$ 4,226,566$ 1,754,764$ 20,630,974$ Collects user fees for the distribution of water and maintenance of infrastructure. Sports Core Fund (Major Fund)3,352,444$ 1,970,958$ 1,381,486$ 2,529,272$ Accounts for revenues and expenses relating to administration, programs, food and beverage operations, and golf course. Golf Surcharge Fund 63,351$ -$ 63,351$ 330,421$ Accounts for the collection of the $3 per round golf surcharge. Internal Service Funds Self Insurance Fund 1,604,119$ 2,145,911$ (541,792)$ (567,172)$ Accounts for the Village's health insurance costs and the related contributions from the Village, employees, retirees, and other agencies. Garage Fund 404,904$ 334,190$ 70,713$ 323,985$ Accounts for the maintenance of the Village's vehicle fleet and the related departmental reimbursements. Equipment Replacement Fund 835,386$ 740,493$ 94,893$ 2,919,779$ 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 July 31, 2023 7/31/23 7/31/23 7/31/22 7/31/23 YTD % of YTD 2023 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax 10,560,614$ 10,113,872 9,333,333$ 108.4%16,000,000$ (446,742)$ State Income Tax 902,162 838,499 667,917 125.5%1,145,000 (63,663) Replacement Tax 752,759 678,525 262,500 258.5%450,000 (74,234) Road & Bridge Tax 9,951 15,431 20,417 75.6%35,000 5,480 Local Use Tax 189,962 202,832 175,000 115.9%300,000 12,870 Cannabis Use Tax 7,950 7,270 9,275 78.4%15,900 (680) Grants 10,466 576,109 9,136 6305.6%15,662 565,643 Utility/Telecom. Tax 3,375,992 3,003,389 3,280,083 91.6%5,623,000 (372,603) Licenses and Permits 1,385,732 3,084,085 1,137,783 271.1%1,950,485 1,698,353 Charges for Services 1,377,261 2,000,002 960,966 208.1%1,647,370 622,741 Investment Interest 109,439 585,104 116,667 501.5%200,000 475,665 Miscellaneous Income 404,236 748,857 597,071 125.4%1,023,551 344,621 Total Operating Revenues 19,086,524$ 21,853,975$ 16,570,148$ 131.9%28,405,969$ 2,767,451$ OPERATING EXPENDITURES Personnel 10,274,226$ 11,489,721$ 12,913,280$ 89.0%22,137,051$ 1,215,495$ Materials and Supplies 247,457 316,854 348,283 91.0%597,056 69,397$ Operation and Contract 2,346,938 2,893,371 3,152,755 91.8%5,404,722 546,433$ Other Expenditures 68,389 6,394 5,250 121.8%9,000 (61,995)$ Capital Outlay 91,550 499,825 554,502 90.1%950,575 408,275$ Total Operating Expenditures 13,028,560$ 15,206,165$ 16,974,069$ 89.6%29,098,405$ 2,177,605$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 6,057,964$ 6,647,810$ (403,921)$ -1645.8%(692,436)$ 589,846$ INTERFUND TRANSACTIONS Transfers In -$ -$ -$ N/A -$ -$ Transfers Out - N/A - Reimbursements From Other Funds 329,714 456,000 395,151 115.4%677,401 126,286 Reimbursements To Other Funds - - - N/A - - Total Interfund Transactions 329,714$ 456,000$ 395,151$ 115.4%677,401$ 126,286$ NET FUND INCREASE (DECREASE)6,387,678$ 7,103,810$ (8,770)$ (15,035)$ 716,132$ *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 July 31, 2023 7/31/23 7/31/23 7/31/22 7/31/23 YTD % of YTD 2023 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Hotel Tax 650,540$ 832,878$ 670,833$ 124.2%1,150,000$ 182,338$ Investment Interest 7,201 44,511 7,000 635.9%12,000 37,310 Loan Interest 3,000 2,000 2,333 85.7%4,000 (1,000) Miscellaneous - - Total Operating Revenues 660,741$ 879,389$ 680,167$ 129.3%1,166,000$ 218,648$ EXPENDITURES Operation and Contract 86,577$ 60,832$ 393,514$ 15.5%674,595$ (25,745)$ Capital Outlay 52,696 - - N/A - (52,696) Total Expenditures 139,273$ 60,832$ 393,514$ 15.5%674,595$ (78,441)$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 521,468$ 818,557$ 286,653$ 285.6%491,405$ 297,089$ INTERFUND TRANSACTIONS Transfer Out -$ -$ -$ N/A -$ -$ Reimbursements to Other Funds (48,300) (203,867) (203,866) 100.0%(349,485) (155,567) Total Interfund Transactions (48,300)$ (203,867)$ (203,866)$ 100.0%(349,485)$ (155,567)$ NET FUND INCREASE (DECREASE)473,168$ 614,690$ 82,787$ 141,920$ 141,522$ Note - Expenditures are recorded in program 171. Village of Oak Brook Hotel Tax Fund Financial Update For the Period Ending July 31, 2023 7/31/23 7/31/23 7/31/22 7/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,271,770$ 4,279,446$ 3,806,250$ 112.4%6,525,000$ 7,676$ Charges for Services - - N/A -$ Investment Interest 39,736 140,448 16,042 875.5%27,500 100,712 Grants - - 635,676 0.0%1,089,730 - Miscellaneous - 2,100 583 360.0%1,000 2,100 Total Operating Revenues 4,311,506$ 4,421,994$ 4,458,551$ 99.2%7,643,230$ 110,488$ OPERATING EXPENDITURES Personnel 788,872$ 12,046$ 26,422$ 45.6%45,294$ (776,826)$ Materials and Supplies 127,189 153,873 115,150 133.6%197,400 26,684 Operation and Contract 603,069 491,012 1,009,272 48.7%1,730,180 (112,057) Other Expenditures - - - N/A - Capital Outlay 3,087,443 1,314,661 5,382,020 24.4%9,226,320 (1,772,782) Total Operating Expenditures 4,606,573$ 1,971,592$ 6,532,863$ 30.2%11,199,194$ (2,634,981)$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES (295,067)$ 2,450,402$ (2,074,312)$ -118.1%(3,555,964)$ 2,745,469$ INTERFUND TRANSACTIONS Transfers In -$ -$ -$ N/A -$ -$ Reimbursements From Other Funds 188,636 126,910 - N/A - (61,726) Reimbursements To Other Funds (68,908) (198,275) - N/A - (129,367) Total Interfund Transactions 119,728$ (71,365)$ -$ N/A -$ (191,093)$ NET FUND INCREASE (DECREASE)(175,339)$ 2,379,037$ (2,074,312)$ (3,555,964)$ 2,554,376$ Village of Oak Brook Infrastructure Fund Financial Update For the Period Ending July 31, 2023 7/31/23 7/31/23 7/31/22 7/31/23 YTD % of YTD 2023 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax -$ -$ 8,750$ 0.0%15,000$ -$ Real Estate Tax 207,773 227,725 236,250 96.4%405,000 19,952 Investment Interest 436 2,283 6 39139.9%10 1,847 Total Operating Revenues 208,209$ 230,009$ 245,006$ 93.9%420,010$ 21,799$ EXPENDITURES Operation and Contract -$ 3,613$ 2,975$ 121.4%5,100$ 3,613$ Other Expenditures 243,150 336,793 196,423 171.5%336,725 93,643 Total Expenditures 243,150$ 340,406$ 199,398$ 170.7%341,825$ 97,256$ NET FUND INCREASE (DECREASE)(34,941)$ (110,397)$ 45,608$ 78,185$ (75,456)$ Note - Expenditures are recorded in program 283. Village of Oak Brook Promenade TIF Fund Financial Update For the Period Ending July 31, 2023 7/31/23 7/31/23 7/31/22 7/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,275$ 306$ 416.3%525$ 825$ Building/Inspection Fees 1,350 1,275 1,167 109.3%2,000 (75) Water Sales 6,055,296 5,220,372 4,800,833 108.7%8,230,000 (834,924) Unmetered Sales 52,019 30,496 29,167 104.6%50,000 (21,523) Water Connection Fees 563,960 129,720 43,750 296.5%75,000 (434,240) Fire Service Charge - - - N/A - - Meter Charges 17,729 14,404 8,750 164.6%15,000 (3,325) Special Services 1,154 25,741 5,833 441.3%10,000 24,587 Investment Interest 21,948 494,889 11,667 4241.9%20,000 472,941 Proceeds from Property Sale - - - N/A - - Miscellaneous 63,990 63,158 29,167 216.5%50,000 (832) Total Operating Revenues 6,777,896$ 5,981,330$ 4,930,640$ 121.3%8,452,525$ (796,566)$ OPERATING EXPENDITURES Personnel 247,597$ 370,765$ 377,778$ 98.1%647,620$ 123,168$ Materials and Supplies 44,023 62,658 40,629 154.2%69,650 18,635 Operation and Contract 2,463,113 2,694,955 3,150,365 85.5%5,400,625 231,842 Capital Outlay 31,394 989,340 2,289,583 43.2%3,925,000 957,946 Total Expenditures 2,786,127$ 4,117,718$ 5,858,355$ 70.3%10,042,895$ 1,331,591$ Surplus (Deficit) of Revenues Over Expenditures 3,991,769$ 1,863,612$ (927,716)$ -200.9%(1,590,370)$ (2,128,157)$ INTERFUND TRANSACTIONS Reimbursements To Other Funds (245,287)$ (108,848)$ (245,286)$ 44.4%(420,490)$ 136,439$ Total Interfund Transactions (245,287)$ (108,848)$ (245,286)$ 44.4%(420,490)$ 136,439$ Fund Increase/(Decrease) - Budgetary Basis 3,746,482$ 1,754,764$ (1,173,002)$ (2,010,860)$ (1,991,718)$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay 3,894$ 989,340$ Depreciation Expense (143,750) (335,417) IMRF Pension Expense (11,250) (26,250) OPEB Expense (7,500) (17,500) Total GAAP Adjustments (158,606)$ 610,173$ Fund Increase/(Decrease) - GAAP Basis 3,587,876$ 2,364,937$ *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 July 31, 2023 Village of Oak Brook Monthly Operating Statement Sports Core Fund Consolidated Presentation For the Period Ending July 31, 2023 7/31/23 7/31/23 7/31/23 YTD % of YTD 2023 7/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 407,785$ -$ -$ 480,100$ 887,885$ 542,063$ 163.8%929,250$ 809,063$ 78,822$ Greens Fees - - - 859,224 859,224 764,167 112.4%1,310,000 896,150 (36,926) Pro Shop Sales - - - 126,549 126,549 145,833 86.8%250,000 154,677 (28,128) Golf Lessons - - - 21,937 21,937 29,167 75.2%50,000 39,448 (17,511) Driving Range Fees - - - 313,120 313,120 204,167 153.4%350,000 303,522 9,598 Rentals - 172,580 52,488 281,776 506,844 632,333 80.2%1,084,000 718,041 (211,197) Programs/User Fees 79,480 - - - 79,480 40,308 197.2%69,100 67,318 12,162 Food Sales 41,697 - - 173,244 214,941 169,167 127.1%290,000 238,052 (23,111) Beverage Sales 14,863 - - 300,194 315,057 287,000 109.8%492,000 373,518 (58,461) Taste of Oak Brook - - - - - - N/A - 66,812 (66,812) Grants - - - - - - N/A - - - Other Revenue 1,630 - - 25,777 27,407 16,115 170.1%27,625 (10,570) 37,977 Total Operating Revenues 545,455$ 172,580$ 52,488$ 2,581,921$ 3,352,444$ 2,830,319$ 118.4%4,851,975$ 3,656,031$ (303,587)$ OPERATING EXPENDITURES Personnel 45,225$ -$ 5,373$ 720,565$ 771,163$ 1,008,187$ 76.5%1,671,380$ 930,663$ (159,500)$ Materials & Supplies 38,775 - 6,855 403,231 448,861 479,522 93.6%718,900 649,659 (200,798) Operational & Contractual 302,068 27,049 32,736 230,440 592,293 440,893 134.3%942,765 814,259 (221,966) Other - - - - - - N/A - - - Capital - - - 111,412 111,412 920,938 12.1%466,750 343,859 (232,447) Total Operating Expenditures 386,068$ 27,049$ 44,964$ 1,465,648$ 1,923,729$ 2,849,540$ 67.5%3,799,795$ 2,738,440$ (814,711)$ B&T Administration Overhead Allocation*-$ -$ -$ -$ -$ -$ N/A -$ (0)$ (0)$ Operating Revenues Over (Under) Expenditures 159,387$ 145,531$ 7,524$ 1,116,273$ 1,428,715$ (19,221)$ -7433.1%1,052,180$ 917,592$ 511,123$ INTERFUND TRANSACTIONS Interfund Loan**-$ -$ -$ -$ -$ -$ N/A -$ -$ -$ Transfer From General Fund - - - - - - N/A - - - Transfer From Golf Surcharge Fund - - - - - 87,500 0.0%150,000 - - Reimbursement From Infrastructure Fund - - - - - - N/A - - - Reimbursement From Water Fund - - - - - - N/A - - - Reimbursement To General Fund (26,988) - - (20,242) (47,230) (47,231) 100.0%(80,967) (48,732) 1,502 Total Interfund Transactions (26,988)$ -$ -$ (20,242)$ (47,230)$ 40,269$ -117.3%69,033$ (48,732)$ 1,502$ Total Revenues Over (Under) Expenditures - Budgetary Basis 132,399$ 145,531$ 7,524$ 1,096,031$ 1,381,486$ 21,048$ 1,121,213$ 868,860$ 512,625$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ -$ -$ 111,412$ 111,412$ 310,716$ Depreciation Expense (98,132) (983) (25,000) (143,675) (267,790) (243,900) IMRF Pension Expense (1,196) - (1,250) (14,292) (16,738) (16,738) OPEB Expense - - (1,250) (16,333) (17,583) (16,333) Total GAAP Adjustments (99,328)$ (983)$ (27,500)$ (62,888)$ (190,699)$ 33,745$ Fund Increase/(Decrease) - GAAP Basis 33,071$ 144,548$ (19,976)$ 1,033,143$ 1,190,786$ 902,604$ *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 July 31, 2023 7/31/23 7/31/23 822 7/31/23 YTD % of YTD 2023 7/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 -$ 390,500$ 17,285$ -$ 407,785$ 302,896$ 134.6%519,250$ 402,838$ 4,947$ Programs/User Fees - 60,772 18,708 - 79,480 40,308.33 197.2%69,100 67,318 12,162 Food Sales - - - 41,697 41,697 23,333.33 178.7%40,000 36,543 - Beverage Sales - - - 14,863 14,863 9,916.67 149.9%17,000 14,575 - Grants - - - - - - N/A - - - Other Revenue 1,630 - - - 1,630 1,356 120.2%2,325 1,176 454 Total Operating Revenues 1,630$ 451,272$ 35,993$ 56,560$ 545,455$ 377,810$ 144.4%647,675$ 522,450$ 17,563$ OPERATING EXPENDITURES Personnel 233$ 26,504$ -$ 18,488$ 45,225$ 115,948$ 39.0%198,768$ 51,817$ (6,592)$ Materials & Supplies 136 27,899 1,936 8,804 38,775 41,881 92.6%71,796 45,959 (7,184) Operational & Contractual 46,260 213,109 38,566 4,133 302,068 144,075 209.7%246,985 247,889 54,179 Other - - - - - - N/A - - Capital - - - - - 320,833 0.0%550,000 235,645 (235,645) Total Operating Expenditures 46,629$ 267,512$ 40,502$ 31,425$ 386,068$ 622,737$ 62.0%1,067,549$ 581,310$ (195,242)$ B&T Administration Overhead Allocation*-$ -$ -$ -$ -$ -$ N/A 43,783$ 12,352$ (12,352)$ Operating Revenues Over (Under) Expenditures (44,999)$ 183,760$ (4,509)$ 25,135$ 159,387$ (244,927)$ -65.1%(376,092)$ (46,507)$ 200,453$ Transfer From General Fund - - - - - - N/A - - - Reimbursement From Infrastructure Fund - - - - - -$ N/A - - - Reimbursement From Water Fund - - - - - - N/A - - - Reimbursement To General Fund (26,988) - - - (26,988) (11,808) 228.6%(20,242) (11,004) (15,984) Total Interfund Transactions (26,988)$ -$ -$ -$ (26,988)$ (11,808)$ 228.6%(20,242)$ (11,004)$ (15,984)$ Total Revenues Over (Under) Expenditures - Budgetary Basis (71,987)$ 183,760$ (4,509)$ 25,135$ 132,399$ (256,735)$ (396,334)$ (57,511)$ 184,469$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ -$ -$ -$ -$ 227,501$ Depreciation Expense (37,543) (58,333) (1,575) (681) (98,132) (98,132) IMRF Pension Expense (1,167) - - (29) (1,196) (1,196) Total GAAP Adjustments (38,709)$ (58,333)$ (1,575)$ (711)$ (99,328)$ 128,173$ Fund Increase/(Decrease) - GAAP Basis (110,696)$ 125,427$ (6,084)$ 24,425$ 33,071$ 70,662$ *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 July 31, 2023 7/31/23 7/31/23 7/31/23 YTD % of YTD 2023 7/31/22 Difference 815 816 YTD Amended Amended Adopted YTD Prior Polo Open Fields Total Budget Budget Budget Total Year OPERATING REVENUES Field Rentals -$ 86,500$ 86,500$ 105,583$ 81.9%181,000$ 184,376$ (97,876)$ Range Rentals - 86,080 86,080 49,583 173.6%85,000 70,480 15,600 Taste of Oak Brook - - - - N/A - 66,812 - Other Revenue - - - - N/A - (17,542) 17,542 Total Operating Revenues -$ 172,580$ 172,580$ 155,167$ 111.2%266,000$ 304,126$ (64,734)$ OPERATING EXPENDITURES Personnel -$ -$ -$ -$ N/A -$ -$ Materials & Supplies - - - 5,536 0.0%9,490$ - - Operational & Contractual - 27,049 27,049 73,465 36.8%125,940 224,083 (197,034) Capital - - - - N/A - - Total Operating Expenditures -$ 27,049$ 27,049$ 79,001$ 34.2%135,430$ 224,083$ (197,034)$ Operating Revenues Over (Under) Expenditures -$ 145,531$ 145,531$ 76,166$ 191.1%130,570$ 80,043$ 132,300$ INTERFUND TRANSACTIONS Transfer From Hotel Tax Fund -$ -$ -$ -$ N/A -$ -$ -$ Total Interfund Transactions -$ -$ -$ -$ N/A -$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis -$ 145,531$ 145,531$ 76,166$ 130,570$ 80,043$ 132,300$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ -$ -$ -$ Depreciation Expense - (983) (983) (843) Total GAAP Adjustments -$ (983)$ (983)$ (843)$ Fund Increase/(Decrease) - GAAP Basis -$ 144,548$ 144,548$ 79,201$ *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 July 31, 2023 7/31/23 7/31/23 821 YTD % of YTD 2023 7/31/22 Difference B&T Amended Amended Adopted YTD Prior Clubhouse Budget Budget Budget Total Year OPERATING REVENUES Rentals 52,488$ 204,167$ 25.7%350,000$ 141,147$ (88,659)$ Other Revenue - - 0.0%- - - Total Operating Revenues 52,488$ 204,167$ 25.7%350,000$ 141,147$ (88,659)$ OPERATING EXPENDITURES Personnel 5,373$ 83,390$ 6.4%142,954$ 73,720$ (68,347)$ Materials & Supplies 6,855 13,984 49.0%23,972 2,016 4,839 Operational & Contractual 32,736 44,824 73.0%76,842 46,201 (13,465) Capital - - N/A - - - Total Operating Expenditures 44,964$ 142,198$ 31.6%243,767$ 121,937$ (76,973)$ B&T Administration Overhead Allocation*-$ -$ N/A (43,784)$ (12,352)$ 12,352$ Operating Revenues Over (Under) Expenditures 7,524$ 61,969$ 12.1%62,449$ 6,858$ 666$ INTERFUND TRANSACTIONS Transfer From General Fund -$ -$ 0.0%-$ -$ -$ Total Interfund Transactions -$ -$ 0.0%-$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis 7,524$ 61,969$ 62,449$ 6,858$ 666$ 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 (19,976)$ (20,642)$ *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 July 31, 2023 7/31/23 7/31/23 823 831 832 833 834 7/31/23 YTD % of YTD 2023 7/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$ 239,167$ 200.7%410,000$ 406,225$ 73,875$ Greens Fees - 859,224 - - - 859,224 764,167 112.4%1,310,000 896,150 (36,926) Pro Shop Sales - 126,549 - - - 126,549 145,833 86.8%250,000 154,677 (28,128) Golf Lessons - - 21,937 - - 21,937 29,167 75.2%50,000 39,448 (17,511) Driving Range Fees - - 313,120 - - 313,120 204,167 153.4%350,000 303,522 9,598 Rentals - 715 - 281,061 - 281,776 273,000 103.2%468,000 322,038 (40,262) Food Sales 173,244 - - - 173,244 145,833 118.8%250,000 201,509 (28,265) Beverage Sales 300,194 - - - - 300,194 277,083 108.3%475,000 358,943 (58,749) Other Revenue 12,068 13,709 - - - 25,777 14,758 174.7%25,300 5,796 19,981 Total Operating Revenues 485,506$ 1,480,297$ 335,057$ 281,061$ -$ 2,581,921$ 2,093,175$ 123.3%3,588,300$ 2,688,308$ (106,387)$ OPERATING EXPENDITURES Personnel 126,303$ 297,509$ 39,888$ 36,647$ 220,218$ 720,565$ 808,849$ 89.1%1,386,598$ 805,126$ (84,561)$ Materials & Supplies 208,582 62,597 14,812 2,945 114,295 403,231 418,122 96.4%716,780 601,684 (198,453) Operational & Contractual 5,266 143,006 8,017 40,954 33,197 230,440 178,529 129.1%306,050 296,086 (65,646) Other - - - - - - - N/A - - - Capital - 72,758 13,290 - 25,364 111,412 600,104 18.6%1,028,751 108,214 3,198 Total Operating Expenditures 340,151$ 575,870$ 76,007$ 80,546$ 393,074$ 1,465,648$ 2,005,604$ 73.1%3,438,178$ 1,811,110$ (345,462)$ Operating Revenues Over (Under) Expenditures 145,355$ 904,427$ 259,050$ 200,515$ (393,074)$ 1,116,273$ 87,571$ 1274.7%150,122$ 877,198$ 239,075$ INTERFUND TRANSACTIONS Transfer from Golf Surcharge -$ -$ -$ -$ -$ -$ 87,500$ 0.0%150,000$ -$ -$ Reimbursement to General Fund - (20,242) - - - (20,242) (35,423) 57.1%(60,725) (37,728) 17,486 Total Interfund Transactions -$ (20,242)$ -$ -$ -$ (20,242)$ 52,077$ -38.9%89,275$ (37,728)$ 17,486$ Total Revenues Over (Under) Expenditures - Budgetary Basis 145,355$ 884,185$ 259,050$ 200,515$ (393,074)$ 1,096,031$ 139,648$ 239,397$ 839,470$ 256,561$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay -$ 72,758$ 13,290$ -$ 25,364$ 111,412$ 108,214$ Depreciation Expense (583) (61,250) (1,342) (7,583) (72,917) (143,675) (143,675) IMRF Pension Expense (1,458) (5,833) (583) - (6,417) (14,292) (14,292) OPEB Expense (1,750) (8,750) - - (5,833) (16,333) (16,333) Total GAAP Adjustments (3,792)$ (3,075)$ 11,365$ (7,583)$ (59,803)$ (62,888)$ (66,086)$ Fund Increase/(Decrease) - GAAP Basis 141,563$ 881,110$ 270,415$ 192,932$ (452,877)$ 1,033,143$ 773,384$ *Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.