Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
06 - June 2023 Monthly Financial Report
VILLAGE OAK BROOKOF MONTHLY FINANCIAL REPORTS JUNE 2023 YTD YTD Net Fund Ending YTD YTD Increase Fund Balance Governmental Funds Revenues Expenditures (Decrease)(Deficit) General Fund (Major Fund)19,139,427$ 12,970,838$ 6,168,589$ 44,639,641$ Main operating fund of the Village. Hotel Fund (Major Fund)672,178$ 227,788$ 444,390$ 2,834,735$ Collects and spends resources from the 3% hotel/motel tax. Motor Fuel Tax Fund 194,304$ 103,678$ 90,626$ 1,788,164$ Collects and spends resources from the State motor fuel tax. Infrastructure Fund (Major Fund)3,913,641$ 2,025,542$ 1,888,098$ 10,770,593$ Accounts for construction and maintenance of roadways, drainage, and safety path systems. Promenade TIF Fund (Major Fund)228,890$ 339,406$ (110,515)$ 203,109$ 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)4,060,798$ 3,440,997$ 619,801$ 19,496,011$ Collects user fees for the distribution of water and maintenance of infrastructure. Sports Core Fund (Major Fund)2,678,334$ 1,499,044$ 1,179,290$ 2,327,077$ Accounts for revenues and expenses relating to administration, programs, food and beverage operations, and golf course. Golf Surcharge Fund 59,281$ -$ 59,281$ 326,350$ Accounts for the collection of the $3 per round golf surcharge. Internal Service Funds Self Insurance Fund 1,373,658$ 1,897,611$ (523,953)$ (549,333)$ Accounts for the Village's health insurance costs and the related contributions from the Village, employees, retirees, and other agencies. Garage Fund 345,333$ 247,536$ 97,797$ 351,068$ Accounts for the maintenance of the Village's vehicle fleet and the related departmental reimbursements. Equipment Replacement Fund 741,088$ 656,880$ 84,207$ 2,909,094$ 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 June 30, 2023 6/30/23 6/30/23 6/30/22 6/30/23 YTD % of YTD 2023 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax 9,139,691$ 8,786,461 8,000,000$ 109.8%16,000,000$ (353,230)$ State Income Tax 773,666 715,826 572,500 125.0%1,145,000 (57,840) Replacement Tax 612,903 538,044 225,000 239.1%450,000 (74,859) Road & Bridge Tax 9,755 15,089 17,500 86.2%35,000 5,334 Local Use Tax 167,633 177,855 150,000 118.6%300,000 10,222 Cannabis Use Tax 7,008 6,235 7,950 78.4%15,900 (773) Grants 10,466 576,109 7,831 7356.6%15,662 565,643 Utility/Telecom. Tax 2,957,981 2,623,357 2,811,500 93.3%5,623,000 (334,624) Licenses and Permits 1,203,577 2,977,462 975,243 305.3%1,950,485 1,773,885 Charges for Services 1,158,466 1,382,336 823,685 167.8%1,647,370 223,870 Investment Interest 79,205 381,598 100,000 381.6%200,000 302,393 Miscellaneous Income 384,384 568,197 511,776 111.0%1,023,551 183,813 Total Operating Revenues 16,504,736$ 18,748,570$ 14,202,984$ 132.0%28,405,969$ 2,243,834$ OPERATING EXPENDITURES Personnel 8,905,879$ 9,863,775$ 11,068,526$ 89.1%22,137,051$ 957,895$ Materials and Supplies 187,786 273,740 298,528 91.7%597,056 85,954$ Operation and Contract 1,758,441 2,333,964 2,702,361 86.4%5,404,722 575,523$ Other Expenditures 4,290 4,271 4,500 94.9%9,000 (19)$ Capital Outlay 65,851 495,089 475,287 104.2%950,575 429,237$ Total Operating Expenditures 10,922,248$ 12,970,838$ 14,549,202$ 89.2%29,098,405$ 2,048,591$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 5,582,488$ 5,777,732$ (346,218)$ -1668.8%(692,436)$ 195,243$ INTERFUND TRANSACTIONS Transfers In -$ -$ -$ N/A 677,401$ -$ Transfers Out - N/A - Reimbursements From Other Funds 282,612 390,857 - N/A - 108,245 Reimbursements To Other Funds (54,942) - - N/A - 54,942 Sports Core Loan - N/A - - Total Interfund Transactions 227,670$ 390,857$ -$ N/A 677,401$ 163,187$ NET FUND INCREASE (DECREASE)5,810,158$ 6,168,589$ (346,218)$ (15,035)$ 358,431$ *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 JUNE 30, 2023 6/30/23 6/30/23 6/30/22 6/30/23 YTD % of YTD 2023 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Hotel Tax 512,885$ 641,285$ 575,000$ 111.5%1,150,000$ 128,400$ Investment Interest 5,110 28,893 6,000 481.5%12,000 23,782 Loan Interest - 2,000 2,000 100.0%4,000 2,000 Miscellaneous - - Total Operating Revenues 517,996$ 672,178$ 583,000$ 115.3%1,166,000$ 154,182$ EXPENDITURES Operation and Contract 43,803$ 53,045$ 337,298$ 15.7%674,595$ 9,243$ Capital Outlay 52,696 - - N/A - (52,696) Total Expenditures 96,498$ 53,045$ 337,298$ 15.7%674,595$ (43,453)$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 421,497$ 619,133$ 245,703$ 252.0%491,405$ 197,635$ INTERFUND TRANSACTIONS Transfer Out -$ -$ -$ N/A -$ -$ Reimbursements to Other Funds (41,400) (174,743) (174,743) 100.0%(349,485) (133,343) Total Interfund Transactions (41,400)$ (174,743)$ (174,743)$ 100.0%(349,485)$ (133,343)$ NET FUND INCREASE (DECREASE)380,097$ 444,390$ 70,960$ 141,920$ 64,292$ Note - Expenditures are recorded in program 171. Village of Oak Brook Hotel Tax Fund Financial Update For the Period Ending JUNE 30, 2023 6/30/23 6/30/23 6/30/22 6/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 3,710,894$ 3,714,827$ 3,262,500$ 113.9%6,525,000$ 3,933$ Charges for Services - - N/A -$ Investment Interest 29,498 87,934 13,750 639.5%27,500 58,436 Grants - - 544,865 0.0%1,089,730 - Miscellaneous - 2,100 500 420.0%1,000 2,100 Total Operating Revenues 3,740,392$ 3,804,861$ 3,821,615$ 99.6%7,643,230$ 64,469$ OPERATING EXPENDITURES Personnel 694,117$ 10,375$ 22,647$ 45.8%45,294$ (683,742)$ Materials and Supplies 123,372 139,330 98,700 141.2%197,400 15,958 Operation and Contract 480,053 391,227 865,090 45.2%1,730,180 (88,826) Other Expenditures - - - N/A - Capital Outlay 1,348,846 1,314,661 4,613,160 28.5%9,226,320 (34,185) Total Operating Expenditures 2,646,388$ 1,855,593$ 5,599,597$ 33.1%11,199,194$ (790,796)$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 1,094,004$ 1,949,268$ (1,777,982)$ -109.6%(3,555,964)$ 855,264$ INTERFUND TRANSACTIONS Transfers In -$ -$ -$ N/A -$ -$ Reimbursements From Other Funds 161,688 108,780 - N/A - (52,908) Reimbursements To Other Funds (59,064) (169,950) - N/A - (110,886) Total Interfund Transactions 102,624$ (61,170)$ -$ N/A -$ (163,794)$ NET FUND INCREASE (DECREASE)1,196,628$ 1,888,098$ (1,777,982)$ (3,555,964)$ 691,471$ Village of Oak Brook Infrastructure Fund Financial Update For the Period Ending JUNE 30, 2023 6/30/23 6/30/23 6/30/22 6/30/23 YTD % of YTD 2023 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax -$ -$ 7,500$ 0.0%15,000$ -$ Real Estate Tax 207,773 227,725 202,500 112.5%405,000 19,952 Investment Interest 130 1,165 5 23297.2%10 1,035 Total Operating Revenues 207,903$ 228,890$ 210,005$ 109.0%420,010$ 20,987$ EXPENDITURES Operation and Contract -$ 2,613$ 2,550$ 102.5%5,100$ 2,613$ Other Expenditures 243,150 336,793 168,363 200.0%336,725 93,643 Total Expenditures 243,150$ 339,406$ 170,913$ 198.6%341,825$ 96,256$ NET FUND INCREASE (DECREASE)(35,247)$ (110,515)$ 39,093$ 78,185$ (75,268)$ Note - Expenditures are recorded in program 283. Village of Oak Brook Promenade TIF Fund Financial Update For the Period Ending JUNE 30, 2023 6/30/23 6/30/23 6/30/22 6/30/23 YTD % of YTD 2023 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Plan Review Fees 375$ 1,200$ 263$ 457.1%525$ 825$ Building/Inspection Fees 1,200 1,275 1,000 127.5%2,000 75 Water Sales 4,247,022 3,489,344 4,115,000 84.8%8,230,000 (757,678) Unmetered Sales 50,247 9,390 25,000 37.6%50,000 (40,857) Water Connection Fees 483,920 126,960 37,500 338.6%75,000 (356,960) Fire Service Charge - - - N/A - - Meter Charges 16,174 14,074 7,500 187.7%15,000 (2,100) Special Services - 25,741 5,000 514.8%10,000 25,741 Investment Interest 15,519 337,947 10,000 3379.5%20,000 322,428 Proceeds from Property Sale - - - N/A - - Miscellaneous 49,117 54,868 25,000 219.5%50,000 5,751 Total Operating Revenues 4,863,574$ 4,060,798$ 4,226,263$ 96.1%8,452,525$ (802,776)$ OPERATING EXPENDITURES Personnel 205,960$ 305,043$ 323,810$ 94.2%647,620$ 99,083$ Materials and Supplies 41,854 45,298 34,825 130.1%69,650 3,444 Operation and Contract 1,387,365 2,008,018 2,700,313 74.4%5,400,625 620,653 Capital Outlay 6,394 989,340 1,962,500 50.4%3,925,000 982,946 Total Expenditures 1,641,573$ 3,347,699$ 5,021,448$ 66.7%10,042,895$ 1,706,126$ Surplus (Deficit) of Revenues Over Expenditures 3,222,001$ 713,099$ (795,185)$ -89.7%(1,590,370)$ (2,508,902)$ INTERFUND TRANSACTIONS Reimbursements To Other Funds (210,246)$ (93,298)$ (210,245)$ 44.4%(420,490)$ 116,948$ Total Interfund Transactions (210,246)$ (93,298)$ (210,245)$ 44.4%(420,490)$ 116,948$ Fund Increase/(Decrease) - Budgetary Basis 3,011,755$ 619,801$ (1,005,430)$ (2,010,860)$ (2,391,954)$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay 3,894$ 989,340$ Depreciation Expense (143,750) (287,500) IMRF Pension Expense (11,250) (22,500) OPEB Expense (7,500) (15,000) Total GAAP Adjustments (158,606)$ 664,340$ Fund Increase/(Decrease) - GAAP Basis 2,853,149$ 1,284,141$ *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 JUNE 30, 2023 Village of Oak Brook Monthly Operating Statement Sports Core Fund Consolidated Presentation For the Period Ending JUNE 30, 2023 6/30/23 6/30/23 6/30/23 YTD % of YTD 2023 6/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,310$ -$ -$ 480,100$ 886,410$ 464,625$ 190.8%929,250$ 805,380$ 81,030$ Greens Fees - - - 583,491 583,491 655,000 89.1%1,310,000 457,154 126,338 Pro Shop Sales - - - 100,224 100,224 125,000 80.2%250,000 94,548 5,676 Golf Lessons - - - 21,751 21,751 25,000 87.0%50,000 33,158 (11,407) Driving Range Fees - - - 260,209 260,209 175,000 148.7%350,000 210,597 49,613 Rentals - 152,080 39,482 197,626 389,188 542,000 71.8%1,084,000 437,460 (48,272) Programs/User Fees 65,081 - - - 65,081 34,550 188.4%69,100 50,302 14,779 Food Sales 24,049 - - 130,419 154,467 145,000 106.5%290,000 123,938 30,529 Beverage Sales 8,099 - - 208,247 216,346 246,000 87.9%492,000 191,367 24,979 Taste of Oak Brook - - - - - - N/A - 15,500 (15,500) Grants - - - - - - N/A - - - Other Revenue 1,166 - - - 1,166 13,813 8.4%27,625 684 482 Total Operating Revenues 504,705$ 152,080$ 39,482$ 1,982,067$ 2,678,334$ 2,425,988$ 110.4%4,851,975$ 2,420,088$ 258,246$ OPERATING EXPENDITURES Personnel 22,283$ -$ 4,846$ 570,468$ 597,597$ 864,160$ 69.2%1,671,380$ 622,128$ (24,531)$ Materials & Supplies 10,596 - 1,228 289,039 300,863 411,019 73.2%718,900 156,055 144,809 Operational & Contractual 229,044 38,898 24,769 172,099 464,810 377,908 123.0%942,765 321,326 143,483 Other - - - - - - N/A - - - Capital - - - 95,291 95,291 789,375 12.1%466,750 204,279 (108,988) Total Operating Expenditures 261,923$ 38,898$ 30,842$ 1,126,897$ 1,458,561$ 2,442,463$ 59.7%3,799,795$ 1,303,789$ 154,772$ B&T Administration Overhead Allocation*-$ -$ -$ -$ -$ -$ N/A -$ (0)$ (0)$ Operating Revenues Over (Under) Expenditures 242,782$ 113,182$ 8,640$ 855,170$ 1,219,773$ (16,475)$ -7403.8%1,052,180$ 1,116,299$ 103,474$ INTERFUND TRANSACTIONS Interfund Loan**-$ -$ -$ -$ -$ -$ N/A -$ -$ -$ Transfer From General Fund - - - - - - N/A - - - Transfer From Golf Surcharge Fund - - - - - 75,000 0.0%150,000 - - Reimbursement From Infrastructure Fund - - - - - - N/A - - - Reimbursement From Water Fund - - - - - - N/A - - - Reimbursement To General Fund (20,241) - - (20,242) (40,483) (40,484) 100.0%(80,967) (37,728) (2,755) Total Interfund Transactions (20,241)$ -$ -$ (20,242)$ (40,483)$ 34,517$ -117.3%69,033$ (37,728)$ (2,755)$ Total Revenues Over (Under) Expenditures - Budgetary Basis 222,541$ 113,182$ 8,640$ 834,928$ 1,179,290$ 18,041$ 1,121,213$ 1,078,571$ 100,719$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ -$ -$ 95,291$ 95,291$ 179,279$ Depreciation Expense (84,114) (843) (25,000) (123,150) (233,106) (209,356) IMRF Pension Expense (1,025) - (1,250) (12,250) (14,525) (14,525) OPEB Expense - - (1,250) (14,000) (15,250) (14,000) Total GAAP Adjustments (85,139)$ (843)$ (27,500)$ (54,109)$ (167,590)$ (58,602)$ Fund Increase/(Decrease) - GAAP Basis 137,402$ 112,339$ (18,860)$ 780,819$ 1,011,700$ 1,019,969$ *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 JUNE 30, 2023 6/30/23 6/30/23 822 6/30/23 YTD % of YTD 2023 6/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,275$ 17,035$ -$ 406,310$ 259,625$ 156.5%519,250$ 400,955$ 5,355$ Programs/User Fees - 52,668 12,414 - 65,081 34,550.00 188.4%69,100 50,302 14,779 Food Sales - - - 24,049 24,049 20,000.00 120.2%40,000 22,149 - Beverage Sales - - - 8,099 8,099 8,500.00 95.3%17,000 8,763 - Grants - - - - - - N/A - - - Other Revenue 1,166 - - - 1,166 1,163 100.3%2,325 684 482 Total Operating Revenues 1,166$ 441,943$ 29,449$ 32,147$ 504,705$ 323,838$ 155.9%647,675$ 482,853$ 20,616$ OPERATING EXPENDITURES Personnel 233$ 12,121$ -$ 9,929$ 22,283$ 99,384$ 22.4%198,768$ 34,563$ (12,280)$ Materials & Supplies 115 3,497 1,936 5,049 10,596 35,898 29.5%71,796 21,338 (10,742) Operational & Contractual 42,397 155,438 29,321 1,887 229,044 123,493 185.5%246,985 130,392 98,652 Other - - - - - - N/A - - Capital - - - - - 275,000 0.0%550,000 171,798 (171,798) Total Operating Expenditures 42,745$ 171,057$ 31,257$ 16,864$ 261,923$ 533,775$ 49.1%1,067,549$ 358,091$ (96,168)$ B&T Administration Overhead Allocation*-$ -$ -$ -$ -$ -$ N/A 43,783$ 12,352$ (12,352)$ Operating Revenues Over (Under) Expenditures (41,579)$ 270,886$ (1,808)$ 15,283$ 242,782$ (209,937)$ -115.6%(376,092)$ 137,113$ 104,433$ Transfer From General Fund - - - - - - N/A - 210 (210) Reimbursement From Infrastructure Fund - - - - - -$ N/A - - - Reimbursement From Water Fund - - - - - - N/A - - - Reimbursement To General Fund (20,241) - - - (20,241) (10,121) 200.0%(20,242) (9,432) (10,809) Total Interfund Transactions (20,241)$ -$ -$ -$ (20,241)$ (10,121)$ 200.0%(20,242)$ (9,222)$ (11,019)$ Total Revenues Over (Under) Expenditures - Budgetary Basis (61,820)$ 270,886$ (1,808)$ 15,283$ 222,541$ (220,058)$ (396,334)$ 127,891$ 93,414$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ -$ -$ -$ -$ 171,798$ Depreciation Expense (32,180) (50,000) (1,350) (584) (84,114) (84,114) IMRF Pension Expense (1,000) - - (25) (1,025) (1,025) Total GAAP Adjustments (33,180)$ (50,000)$ (1,350)$ (609)$ (85,139)$ 86,660$ Fund Increase/(Decrease) - GAAP Basis (94,999)$ 220,886$ (3,158)$ 14,674$ 137,402$ 214,551$ *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 JUNE 30, 2023 6/30/23 6/30/23 6/30/23 YTD % of YTD 2023 6/30/22 Difference 815 816 YTD Amended Amended Adopted YTD Prior Polo Open Fields Total Budget Budget Budget Total Year OPERATING REVENUES Field Rentals -$ 66,000$ 66,000$ 90,500$ 72.9%181,000$ 98,143$ (32,143)$ Range Rentals - 86,080 86,080 42,500 202.5%85,000 80,000 6,080 Taste of Oak Brook - - - - N/A - 15,500 - Other Revenue - - - - N/A - - - Total Operating Revenues -$ 152,080$ 152,080$ 133,000$ 114.3%266,000$ 193,643$ (26,063)$ OPERATING EXPENDITURES Personnel -$ -$ -$ -$ N/A -$ -$ Materials & Supplies - - - 4,745 0.0%9,490$ - - Operational & Contractual 12,850 26,048 38,898 62,970 61.8%125,940 14,638 24,260 Capital - - - - N/A - - Total Operating Expenditures 12,850$ 26,048$ 38,898$ 67,715$ 57.4%135,430$ 14,638$ 24,260$ Operating Revenues Over (Under) Expenditures (12,850)$ 126,032$ 113,182$ 65,285$ 173.4%130,570$ 179,005$ (50,323)$ INTERFUND TRANSACTIONS Transfer From Hotel Tax Fund -$ -$ -$ -$ N/A -$ -$ -$ Total Interfund Transactions -$ -$ -$ -$ N/A -$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis (12,850)$ 126,032$ 113,182$ 65,285$ 130,570$ 179,005$ (50,323)$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ -$ -$ -$ Depreciation Expense - (843) (843) (843) Total GAAP Adjustments -$ (843)$ (843)$ (843)$ Fund Increase/(Decrease) - GAAP Basis (12,850)$ 125,189$ 112,339$ 178,162$ *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 JUNE 30, 2023 6/30/23 6/30/23 821 YTD % of YTD 2023 6/30/22 Difference B&T Amended Amended Adopted YTD Prior Clubhouse Budget Budget Budget Total Year OPERATING REVENUES Rentals 39,482$ 175,000$ 22.6%350,000$ 99,546$ (60,064)$ Other Revenue - - 0.0%- - - Total Operating Revenues 39,482$ 175,000$ 22.6%350,000$ 99,546$ (60,064)$ OPERATING EXPENDITURES Personnel 4,846$ 71,477$ 6.8%142,954$ 63,263$ (58,418)$ Materials & Supplies 1,228 11,986 10.2%23,972 427 800 Operational & Contractual 24,769 38,421 64.5%76,842 33,840 (9,072) Capital - - N/A - - - Total Operating Expenditures 30,842$ 121,884$ 25.3%243,767$ 97,531$ (66,689)$ B&T Administration Overhead Allocation*-$ -$ N/A (43,784)$ (12,352)$ 12,352$ Operating Revenues Over (Under) Expenditures 8,640$ 53,116$ 16.3%62,449$ (10,337)$ 18,977$ INTERFUND TRANSACTIONS Transfer From General Fund -$ -$ 0.0%-$ -$ -$ Total Interfund Transactions -$ -$ 0.0%-$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis 8,640$ 53,116$ 62,449$ (10,337)$ 18,977$ 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 (18,860)$ (37,837)$ *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 JUNE 30, 2023 6/30/23 6/30/23 823 831 832 833 834 6/30/23 YTD % of YTD 2023 6/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$ 205,000$ 234.2%410,000$ 404,425$ 75,675$ Greens Fees - 583,491 - - - 583,491 655,000 89.1%1,310,000 457,154 126,338 Pro Shop Sales - 100,224 - - - 100,224 125,000 80.2%250,000 94,548 5,676 Golf Lessons - - 21,751 - - 21,751 25,000 87.0%50,000 33,158 (11,407) Driving Range Fees - - 260,209 - - 260,209 175,000 148.7%350,000 210,597 49,613 Rentals - - - 197,626 - 197,626 234,000 84.5%468,000 159,771 37,855 Food Sales 130,419 - - - 130,419 125,000 104.3%250,000 101,790 28,629 Beverage Sales 208,247 - - - - 208,247 237,500 87.7%475,000 182,604 25,643 Other Revenue - - - - - - 12,650 0.0%25,300 - - Total Operating Revenues 338,666$ 1,163,815$ 281,960$ 197,626$ -$ 1,982,067$ 1,794,150$ 110.5%3,588,300$ 1,644,046$ 338,021$ OPERATING EXPENDITURES Personnel 100,367$ 248,747$ 29,407$ 23,020$ 168,928$ 570,468$ 693,299$ 82.3%1,386,598$ 524,302$ 46,167$ Materials & Supplies 164,770 16,457 14,812 1,915 91,084 289,039 358,390 80.6%716,780 134,289 154,750 Operational & Contractual 5,061 98,517 5,250 32,692 30,579 172,099 153,025 112.5%306,050 142,456 29,643 Other - - - - - - - N/A - - - Capital - 82,001 13,290 - - 95,291 514,375 18.5%1,028,751 32,481 62,810 Total Operating Expenditures 270,199$ 445,721$ 62,759$ 57,627$ 290,591$ 1,126,897$ 1,719,089$ 65.6%3,438,178$ 833,528$ 293,369$ Operating Revenues Over (Under) Expenditures 68,467$ 718,094$ 219,201$ 139,999$ (290,591)$ 855,170$ 75,061$ 1139.3%150,122$ 810,518$ 44,652$ INTERFUND TRANSACTIONS Transfer from Golf Surcharge -$ -$ -$ -$ -$ -$ 75,000$ 0.0%150,000$ -$ -$ Reimbursement to General Fund - (20,242) - - - (20,242) (30,363) 66.7%(60,725) (28,296) 8,054 Total Interfund Transactions -$ (20,242)$ -$ -$ -$ (20,242)$ 44,638$ -45.3%89,275$ (28,296)$ 8,054$ Total Revenues Over (Under) Expenditures - Budgetary Basis 68,467$ 697,852$ 219,201$ 139,999$ (290,591)$ 834,928$ 119,698$ 239,397$ 782,222$ 52,706$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay -$ 82,001$ 13,290$ -$ -$ 95,291$ 32,481$ Depreciation Expense (500) (52,500) (1,150) (6,500) (62,500) (123,150) (123,150) IMRF Pension Expense (1,250) (5,000) (500) - (5,500) (12,250) (12,250) OPEB Expense (1,500) (7,500) - - (5,000) (14,000) (14,000) Total GAAP Adjustments (3,250)$ 17,001$ 11,640$ (6,500)$ (73,000)$ (54,109)$ (116,919)$ Fund Increase/(Decrease) - GAAP Basis 65,217$ 714,853$ 230,841$ 133,499$ (363,591)$ 780,819$ 665,303$ *Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.