Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
04 - April 2023 Monthly Financial Report
VILLAGE OAK BROOKOF MONTHLY FINANCIAL REPORTS APRIL 2023 YTD YTD Net Fund Ending YTD YTD Increase Fund Balance Governmental Funds Revenues Expenditures (Decrease)(Deficit) General Fund (Major Fund)12,426,728$ 6,904,422$ 5,522,306$ 43,993,357$ Main operating fund of the Village. Hotel Fund (Major Fund)395,034$ 129,078$ 265,956$ 2,656,302$ Collects and spends resources from the 3% hotel/motel tax. Motor Fuel Tax Fund 129,498$ 62,640$ 66,858$ 1,764,396$ Collects and spends resources from the State motor fuel tax. Infrastructure Fund (Major Fund)2,792,746$ 1,836,567$ 956,179$ 9,838,673$ Accounts for construction and maintenance of roadways, drainage, and safety path systems. Promenade TIF Fund (Major Fund)1,165$ 337,806$ (336,641)$ (23,016)$ 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)2,632,591$ 1,287,613$ 1,344,978$ 20,221,188$ Collects user fees for the distribution of water and maintenance of infrastructure. Sports Core Fund (Major Fund)1,273,506$ 453,359$ 820,147$ 1,967,934$ Accounts for revenues and expenses relating to administration, programs, food and beverage operations, and golf course. Golf Surcharge Fund 12,986$ -$ 12,986$ 280,056$ Accounts for the collection of the $3 per round golf surcharge. Internal Service Funds Self Insurance Fund 890,797$ 1,775,786$ (884,988)$ (910,369)$ Accounts for the Village's health insurance costs and the related contributions from the Village, employees, retirees, and other agencies. Garage Fund 2,408$ 175,471$ (173,063)$ 80,208$ Accounts for the maintenance of the Village's vehicle fleet and the related departmental reimbursements. Equipment Replacement Fund 1,941$ 555,503$ (553,562)$ 2,271,324$ 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 April 30, 2023 4/30/23 4/30/23 4/30/22 4/30/23 YTD % of YTD 2023 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax 6,491,475$ 6,270,207 5,333,333$ 117.6%16,000,000$ (221,268)$ State Income Tax 438,439 427,265 381,667 111.9%1,145,000 (11,174) Replacement Tax 385,318 229,593 150,000 153.1%450,000 (155,725) Road & Bridge Tax - - 11,667 0.0%35,000 - Local Use Tax 115,979 123,871 100,000 123.9%300,000 7,893 Cannabis Use Tax 4,744 4,245 5,300 80.1%15,900 (499) Grants 973 718 5,221 13.7%15,662 (256) Utility/Telecom. Tax 2,099,088 1,837,121 1,874,333 98.0%5,623,000 (261,967) Licenses and Permits 692,795 1,896,887 650,162 291.8%1,950,485 1,204,091 Charges for Services 760,583 785,692 549,123 143.1%1,647,370 25,109 Investment Interest 28,883 285,147 66,667 427.7%200,000 256,263 Miscellaneous Income 219,427 305,412 341,184 89.5%1,023,551 85,985 Total Operating Revenues 11,237,705$ 12,166,156$ 9,468,656$ 128.5%28,405,969$ 928,451$ OPERATING EXPENDITURES Personnel 5,511,354$ 5,850,793$ 7,379,017$ 79.3%22,137,051$ 339,439$ Materials and Supplies 133,043 156,060 199,019 78.4%597,056 23,017$ Operation and Contract 1,150,810 889,637 1,801,574 49.4%5,404,722 (261,172)$ Other Expenditures 4,290 2,147 3,000 71.6%9,000 (2,142)$ Capital Outlay 31,812 5,784 316,858 1.8%950,575 (26,028)$ Total Operating Expenditures 6,831,308$ 6,904,422$ 9,699,468$ 71.2%29,098,405$ 73,114$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 4,406,397$ 5,261,734$ (230,812)$ -2279.7%(692,436)$ 855,337$ INTERFUND TRANSACTIONS Transfers In -$ -$ -$ N/A 677,401$ -$ Transfers Out - N/A - Reimbursements From Other Funds 188,408 260,571 - N/A - 72,163 Reimbursements To Other Funds (36,628) - - N/A - 36,628 Sports Core Loan - N/A - - Total Interfund Transactions 151,780$ 260,571$ -$ N/A 677,401$ 108,791$ NET FUND INCREASE (DECREASE)4,558,177$ 5,522,306$ (230,812)$ (15,035)$ 964,129$ *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 APRIL 30, 2023 4/30/23 4/30/23 4/30/22 4/30/23 YTD % of YTD 2023 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Hotel Tax 291,470$ 373,159$ 383,333$ 97.3%1,150,000$ 81,689$ Investment Interest 1,887 21,876 4,000 546.9%12,000 19,989 Loan Interest - - 1,333 0.0%4,000 - Miscellaneous - - Total Operating Revenues 293,356$ 395,034$ 388,667$ 101.6%1,166,000$ 101,678$ EXPENDITURES Operation and Contract 27,615$ 12,583$ 224,865$ 5.6%674,595$ (15,032)$ Capital Outlay 52,696 - - N/A - (52,696) Total Expenditures 80,311$ 12,583$ 224,865$ 5.6%674,595$ (67,728)$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 213,045$ 382,451$ 163,802$ 233.5%491,405$ 169,406$ INTERFUND TRANSACTIONS Transfer Out -$ -$ -$ N/A -$ -$ Reimbursements to Other Funds (27,600) (116,495) (116,495) 100.0%(349,485) (88,895) Total Interfund Transactions (27,600)$ (116,495)$ (116,495)$ 100.0%(349,485)$ (88,895)$ NET FUND INCREASE (DECREASE)185,445$ 265,956$ 47,307$ 141,920$ 80,511$ Note - Expenditures are recorded in program 171. Village of Oak Brook Hotel Tax Fund Financial Update For the Period Ending APRIL 30, 2023 4/30/23 4/30/23 4/30/22 4/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 2,680,680$ 2,654,561$ 2,175,000$ 122.0%6,525,000$ (26,119)$ Charges for Services - - N/A -$ Investment Interest 10,726 65,440 9,167 713.9%27,500 54,714 Grants - 225 363,243 0.1%1,089,730 225 Miscellaneous - - 333 0.0%1,000 - Total Operating Revenues 2,691,406$ 2,720,226$ 2,547,743$ 106.8%7,643,230$ 28,821$ OPERATING EXPENDITURES Personnel 472,005$ 77,922$ 15,098$ 516.1%45,294$ (394,083)$ Materials and Supplies 117,565 102,354 65,800 155.6%197,400 (15,211) Operation and Contract 291,695 228,331 576,727 39.6%1,730,180 (63,364) Other Expenditures 39,376 113,300 - N/A 73,924 Capital Outlay 29,948 1,314,661 3,075,440 42.7%9,226,320 1,284,713 Total Operating Expenditures 950,588$ 1,836,567$ 3,733,065$ 49.2%11,199,194$ 885,979$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 1,740,818$ 883,659$ (1,185,321)$ -74.6%(3,555,964)$ (857,158)$ INTERFUND TRANSACTIONS Transfers In -$ -$ -$ N/A -$ -$ Reimbursements From Other Funds 107,792 72,520 - N/A - (35,272) Reimbursements To Other Funds (39,376) - - N/A - 39,376 Total Interfund Transactions 68,416$ 72,520$ -$ N/A -$ 4,104$ NET FUND INCREASE (DECREASE)1,809,234$ 956,179$ (1,185,321)$ (3,555,964)$ (853,054)$ Village of Oak Brook Infrastructure Fund Financial Update For the Period Ending APRIL 30, 2023 4/30/23 4/30/23 4/30/22 4/30/23 YTD % of YTD 2023 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax -$ -$ 5,000$ 0.0%15,000$ -$ Real Estate Tax - - 135,000 0.0%405,000 - Investment Interest 49 1,165 3 34945.8%10 1,116 Total Operating Revenues 49$ 1,165$ 140,003$ 0.8%420,010$ 1,116$ EXPENDITURES Operation and Contract -$ 1,013$ 1,700$ 59.6%5,100$ 1,013$ Other Expenditures 243,150 336,793 112,242 300.1%336,725 93,643 Total Expenditures 243,150$ 337,806$ 113,942$ 296.5%341,825$ 94,656$ NET FUND INCREASE (DECREASE)(243,101)$ (336,641)$ 26,062$ 78,185$ (93,540)$ Note - Expenditures are recorded in program 283. Village of Oak Brook Promenade TIF Fund Financial Update For the Period Ending APRIL 30, 2023 4/30/23 4/30/23 4/30/22 4/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$ 750$ 175$ 428.6%525$ 375$ Building/Inspection Fees 825 825 667 123.8%2,000 - Water Sales 2,678,766 2,191,238 2,743,333 79.9%8,230,000 (487,528) Unmetered Sales 45,547 6,616 16,667 39.7%50,000 (38,931) Water Connection Fees 183,310 112,240 25,000 449.0%75,000 (71,070) Fire Service Charge - - - N/A - - Meter Charges 9,926 9,775 5,000 195.5%15,000 (151) Special Services - 12,811 3,333 384.3%10,000 12,811 Investment Interest 5,466 256,193 6,667 3842.9%20,000 250,727 Proceeds from Property Sale - - - N/A - - Miscellaneous 35,748 42,143 16,667 252.9%50,000 6,395 Total Operating Revenues 2,959,963$ 2,632,591$ 2,817,508$ 93.4%8,452,525$ (327,372)$ OPERATING EXPENDITURES Personnel 132,917$ 178,466$ 215,873$ 82.7%647,620$ 45,550$ Materials and Supplies 39,430 23,463 23,217 101.1%69,650 (15,966) Operation and Contract 1,025,051 1,023,486 1,800,208 56.9%5,400,625 (1,566) Capital Outlay 3,894 - 1,308,333 0.0%3,925,000 (3,894) Total Expenditures 1,201,291$ 1,225,415$ 3,347,632$ 36.6%10,042,895$ 24,124$ Surplus (Deficit) of Revenues Over Expenditures 1,758,672$ 1,407,176$ (530,123)$ -265.4%(1,590,370)$ (351,496)$ INTERFUND TRANSACTIONS Reimbursements To Other Funds (140,164)$ (62,198)$ (140,163)$ 44.4%(420,490)$ 77,966$ Total Interfund Transactions (140,164)$ (62,198)$ (140,163)$ 44.4%(420,490)$ 77,966$ Fund Increase/(Decrease) - Budgetary Basis 1,618,508$ 1,344,978$ (670,287)$ (2,010,860)$ (273,530)$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay 3,894$ -$ Depreciation Expense (143,750) (191,667) IMRF Pension Expense (11,250) (15,000) OPEB Expense (7,500) (10,000) Total GAAP Adjustments (158,606)$ (216,667)$ Fund Increase/(Decrease) - GAAP Basis 1,459,902$ 1,128,311$ *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 APRIL 30, 2023 Village of Oak Brook Monthly Operating Statement Sports Core Fund Consolidated Presentation For the Period Ending APRIL 30, 2023 4/30/23 4/30/23 4/30/23 YTD % of YTD 2023 4/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 287,580$ -$ -$ 446,025$ 733,605$ 309,750$ 236.8%929,250$ 674,325$ 59,280$ Greens Fees - - - 111,789 111,789 436,667 25.6%1,310,000 89,686 22,103 Pro Shop Sales - - - 50,698 50,698 83,333 60.8%250,000 46,129 4,569 Golf Lessons - - - 14,015 14,015 16,667 84.1%50,000 21,603 (7,588) Driving Range Fees - - - 129,909 129,909 116,667 111.4%350,000 109,237 20,672 Rentals - 111,080 3,481 41,408 155,969 361,333 43.2%1,084,000 191,186 (35,217) Programs/User Fees 5,157 - - - 5,157 23,033 22.4%69,100 750 4,407 Food Sales - - - 24,883 24,883 96,667 25.7%290,000 19,465 5,418 Beverage Sales - - - 45,347 45,347 164,000 27.7%492,000 36,980 8,367 Taste of Oak Brook - - - - - - N/A - - - Grants - - - - - - N/A - - - Other Revenue 512 - - 1,624 2,136 9,208 23.2%27,625 150 1,986 Total Operating Revenues 293,249$ 111,080$ 3,481$ 865,697$ 1,273,506$ 1,617,325$ 78.7%4,851,975$ 1,189,511$ 83,995$ OPERATING EXPENDITURES Personnel 105$ -$ 2,545$ 226,940$ 229,590$ 576,107$ 39.9%1,671,380$ 272,617$ (43,027)$ Materials & Supplies 5,342 - 354 (7,222) (1,527) 274,013 -0.6%718,900 86,818 (88,345) Operational & Contractual 64,384 19,730 14,431 50,073 148,617 251,939 59.0%942,765 190,977 (42,360) Other - - - - - - N/A - - - Capital - - - 49,690 49,690 526,250 9.4%466,750 52,981 (3,291) Total Operating Expenditures 69,831$ 19,730$ 17,330$ 319,481$ 426,370$ 1,628,308$ 26.2%3,799,795$ 603,393$ (177,023)$ B&T Administration Overhead Allocation*-$ -$ -$ -$ -$ -$ N/A -$ -$ -$ Operating Revenues Over (Under) Expenditures 223,418$ 91,350$ (13,849)$ 546,216$ 847,136$ (10,983)$ -7712.9%1,052,180$ 586,118$ 261,018$ INTERFUND TRANSACTIONS Interfund Loan**-$ -$ -$ -$ -$ -$ N/A -$ -$ -$ Transfer From General Fund - - - - - - N/A - - - Transfer From Golf Surcharge Fund - - - - - 50,000 0.0%150,000 - - Reimbursement From Infrastructure Fund - - - - - - N/A - - - Reimbursement From Water Fund - - - - - - N/A - - - Reimbursement To General Fund (6,747) - - (20,242) (26,989) (26,989) 100.0%(80,967) (25,152) (1,837) Total Interfund Transactions (6,747)$ -$ -$ (20,242)$ (26,989)$ 23,011$ -117.3%69,033$ (25,152)$ (1,837)$ Total Revenues Over (Under) Expenditures - Budgetary Basis 216,671$ 91,350$ (13,849)$ 525,974$ 820,147$ 12,028$ 1,121,213$ 560,966$ 259,181$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ -$ -$ 49,690$ 49,690$ 52,981$ Depreciation Expense (56,076) (562) (25,000) (82,100) (163,737) (104,053) IMRF Pension Expense (683) - (1,250) (8,167) (10,100) (6,638) OPEB Expense - - (1,250) (9,333) (10,583) (7,000) Total GAAP Adjustments (56,759)$ (562)$ (27,500)$ (49,910)$ (134,731)$ (64,709)$ Fund Increase/(Decrease) - GAAP Basis 159,912$ 90,789$ (41,349)$ 476,064$ 685,416$ 496,257$ *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 APRIL 30, 2023 4/30/23 4/30/23 822 4/30/23 YTD % of YTD 2023 4/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 -$ 277,725$ 9,855$ -$ 287,580$ 173,083$ 166.2%519,250$ 304,025$ (16,445)$ Programs/User Fees - 4,895 262 - 5,157 23,033.33 22.4%69,100 750 4,407 Food Sales - - - - - 13,333.33 0.0%40,000 - - Beverage Sales - - - - - 5,666.67 0.0%17,000 - - Grants - - - - - - N/A - - - Other Revenue 512 - - - 512 775 66.1%2,325 150 362 Total Operating Revenues 512$ 282,620$ 10,117$ -$ 293,249$ 215,892$ 135.8%647,675$ 304,925$ (11,676)$ OPERATING EXPENDITURES Personnel -$ -$ -$ 105$ 105$ 66,256$ 0.2%198,768$ 3,617$ (3,512)$ Materials & Supplies - 2,144 982 2,216 5,342 23,932 22.3%71,796 4,488 853 Operational & Contractual 26,515 37,465 125 279 64,384 82,328 78.2%246,985 59,443 4,941 Other - - - - - N/A - - Capital - - - - - 183,333 0.0%550,000 14,708 (14,708) Total Operating Expenditures 26,515$ 39,609$ 1,107$ 2,600$ 69,831$ 355,850$ 19.6%1,067,549$ 82,256$ (12,426)$ B&T Administration Overhead Allocation*-$ -$ -$ -$ -$ -$ N/A 43,783$ -$ -$ Operating Revenues Over (Under) Expenditures (26,003)$ 243,011$ 9,010$ (2,600)$ 223,418$ (139,958)$ -159.6%(376,092)$ 222,669$ 750$ Transfer From General Fund - - - - - - N/A - - Reimbursement From Infrastructure Fund - - - - - -$ N/A - - - Reimbursement From Water Fund - - - - - - N/A - - - Reimbursement To General Fund (6,747) - - - (6,747) (6,747) 100.0%(20,242) (6,288) (459) Total Interfund Transactions (6,747)$ -$ -$ -$ (6,747)$ (6,747)$ 100.0%(20,242)$ (6,288)$ (459)$ Total Revenues Over (Under) Expenditures - Budgetary Basis (32,750)$ 243,011$ 9,010$ (2,600)$ 216,671$ (146,705)$ (396,334)$ 216,381$ 290$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ -$ -$ -$ -$ 14,708$ Depreciation Expense (21,453) (33,333) (900) (389) (56,076) (42,057) IMRF Pension Expense (667) - - (17) (683) (513) Total GAAP Adjustments (22,120)$ (33,333)$ (900)$ (406)$ (56,759)$ (27,861)$ Fund Increase/(Decrease) - GAAP Basis (54,870)$ 209,678$ 8,110$ (3,006)$ 159,912$ 188,520$ *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 APRIL 30, 2023 4/30/23 4/30/23 4/30/23 YTD % of YTD 2023 4/30/22 Difference 815 816 YTD Amended Amended Adopted YTD Prior Polo Open Fields Total Budget Budget Budget Total Year OPERATING REVENUES Field Rentals -$ 25,000$ 25,000$ 60,333$ 41.4%181,000$ 67,643$ (42,643)$ Range Rentals - 86,080 86,080 28,333 303.8%85,000 80,000 6,080 Taste of Oak Brook - - - - N/A - - - Other Revenue - - - N/A - - - Total Operating Revenues -$ 111,080$ 111,080$ 88,667$ 125.3%266,000$ 147,643$ (36,563)$ OPERATING EXPENDITURES Personnel -$ -$ -$ -$ N/A -$ -$ Materials & Supplies - - - 3,163 0.0%9,490$ - - Operational & Contractual 12,850 6,880 19,730 41,980 47.0%125,940 14,007 5,723 Capital - - - - N/A - - Total Operating Expenditures 12,850$ 6,880$ 19,730$ 45,143$ 43.7%135,430$ 14,007$ 5,723$ Operating Revenues Over (Under) Expenditures (12,850)$ 104,200$ 91,350$ 43,523$ 209.9%130,570$ 133,636$ (42,285)$ INTERFUND TRANSACTIONS Transfer From Hotel Tax Fund -$ -$ -$ -$ N/A -$ -$ -$ Total Interfund Transactions -$ -$ -$ -$ N/A -$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis (12,850)$ 104,200$ 91,350$ 43,523$ 130,570$ 133,636$ (42,285)$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ -$ -$ -$ Depreciation Expense - (562) (562) (421) Total GAAP Adjustments -$ (562)$ (562)$ (421)$ Fund Increase/(Decrease) - GAAP Basis (12,850)$ 103,639$ 90,789$ 133,215$ *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 APRIL 30, 2023 4/30/23 4/30/23 821 YTD % of YTD 2023 4/30/22 Difference B&T Amended Amended Adopted YTD Prior Clubhouse Budget Budget Budget Total Year OPERATING REVENUES Rentals 3,481$ 116,667$ 3.0%350,000$ 13,888$ (10,408)$ Other Revenue - - 0.0%- - - Total Operating Revenues 3,481$ 116,667$ 3.0%350,000$ 13,888$ (10,408)$ OPERATING EXPENDITURES Personnel 2,545$ 47,651$ 5.3%142,954$ 37,548$ (35,004)$ Materials & Supplies 354 7,991 4.4%23,972 414 (60) Operational & Contractual 14,431 25,614 56.3%76,842 21,311 (6,880) Capital - - N/A - 5,792 (5,792) Total Operating Expenditures 17,330$ 81,256$ 21.3%243,767$ 65,065$ (47,735)$ B&T Administration Overhead Allocation*-$ -$ N/A (43,784)$ -$ -$ Operating Revenues Over (Under) Expenditures (13,849)$ 35,411$ -39.1%62,449$ (51,176)$ 37,327$ INTERFUND TRANSACTIONS Transfer From General Fund -$ -$ 0.0%-$ -$ -$ Total Interfund Transactions -$ -$ 0.0%-$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis (13,849)$ 35,411$ 62,449$ (51,176)$ 37,327$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ 5,792$ Depreciation Expense (25,000) - IMRF Pension Expense (1,250) - OPEB Expense (1,250) - Total GAAP Adjustments (27,500)$ 5,792$ Fund Increase/(Decrease) - GAAP Basis (41,349)$ (45,384)$ *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 APRIL 30, 2023 4/30/23 4/30/23 823 831 832 833 834 4/30/23 YTD % of YTD 2023 4/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 -$ 446,025$ -$ -$ -$ 446,025$ 136,667$ 326.4%410,000$ 370,300$ 75,725$ Greens Fees - 111,789 - - - 111,789 436,667 25.6%1,310,000 89,686 22,103 Pro Shop Sales - 50,698 - - - 50,698 83,333 60.8%250,000 46,129 4,569 Golf Lessons - - 14,015 - - 14,015 16,667 84.1%50,000 21,603 (7,588) Driving Range Fees - - 129,909 - - 129,909 116,667 111.4%350,000 109,237 20,672 Rentals - 90 - 41,318 - 41,408 156,000 26.5%468,000 29,655 11,753 Food Sales 24,883 - - - 24,883 83,333 29.9%250,000 19,465 5,418 Beverage Sales 45,347 - - - - 45,347 158,333 28.6%475,000 36,980 8,367 Other Revenue 1,624 - - - - 1,624 8,433 19.3%25,300 - 1,624 Total Operating Revenues 71,853$ 608,601$ 143,924$ 41,318$ -$ 865,697$ 1,196,100$ 72.4%3,588,300$ 723,055$ 142,641$ OPERATING EXPENDITURES Personnel 28,802$ 127,919$ 4,174$ 1,912$ 64,133$ 226,940$ 462,199$ 49.1%1,386,598$ 231,452$ (4,512)$ Materials & Supplies 21,233 (54,871) 1,309 - 25,107 (7,222) 238,927 -3.0%716,780 81,916 (89,138) Operational & Contractual 1,687 23,348 5,000 3,565 16,473 50,073 102,017 49.1%306,050 96,216 (46,144) Other - - - - - - - N/A - - - Capital - 36,400 13,290 - - 49,690 342,917 14.5%1,028,751 32,481 17,209 Total Operating Expenditures 51,722$ 132,796$ 23,773$ 5,477$ 105,713$ 319,481$ 1,146,059$ 27.9%3,438,178$ 442,066$ (122,585)$ Operating Revenues Over (Under) Expenditures 20,131$ 475,806$ 120,151$ 35,841$ (105,713)$ 546,216$ 50,041$ 1091.5%150,122$ 280,990$ 265,226$ INTERFUND TRANSACTIONS Transfer from Golf Surcharge -$ -$ -$ -$ -$ -$ 50,000$ 0.0%150,000$ -$ -$ Reimbursement to General Fund - (20,242) - - - (20,242) (20,242) 100.0%(60,725) (18,864) (1,378) Total Interfund Transactions -$ (20,242)$ -$ -$ -$ (20,242)$ 29,758$ -68.0%89,275$ (18,864)$ (1,378)$ Total Revenues Over (Under) Expenditures - Budgetary Basis 20,131$ 455,564$ 120,151$ 35,841$ (105,713)$ 525,974$ 79,799$ 239,397$ 262,126$ 263,849$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay -$ 36,400$ 13,290$ -$ -$ 49,690$ 32,481$ Depreciation Expense (333) (35,000) (767) (4,333) (41,667) (82,100) (61,575) IMRF Pension Expense (833) (3,333) (333) - (3,667) (8,167) (6,125) OPEB Expense (1,000) (5,000) - - (3,333) (9,333) (7,000) Total GAAP Adjustments (2,167)$ (6,933)$ 12,190$ (4,333)$ (48,667)$ (49,910)$ (42,219)$ Fund Increase/(Decrease) - GAAP Basis 17,964$ 448,631$ 132,341$ 31,508$ (154,380)$ 476,064$ 219,907$ *Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.