Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
05 - May 2023 Monthly Financial Report
VILLAGE OAK BROOKOF MONTHLY FINANCIAL REPORTS MAY 2023 YTD YTD Net Fund Ending YTD YTD Increase Fund Balance Governmental Funds Revenues Expenditures (Decrease)(Deficit) General Fund (Major Fund)15,321,211$ 9,743,046$ 5,578,165$ 44,049,217$ Main operating fund of the Village. Hotel Fund (Major Fund)511,960$ 198,664$ 313,295$ 2,703,641$ Collects and spends resources from the 3% hotel/motel tax. Motor Fuel Tax Fund 158,500$ 103,678$ 54,821$ 1,752,359$ Collects and spends resources from the State motor fuel tax. Infrastructure Fund (Major Fund)3,316,647$ 2,027,287$ 1,289,360$ 10,171,855$ Accounts for construction and maintenance of roadways, drainage, and safety path systems. Promenade TIF Fund (Major Fund)1,165$ 339,406$ (338,241)$ (24,616)$ 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)3,454,119$ 2,818,960$ 635,159$ 19,511,369$ Collects user fees for the distribution of water and maintenance of infrastructure. Sports Core Fund (Major Fund)1,975,513$ 890,532$ 1,084,981$ 2,232,768$ Accounts for revenues and expenses relating to administration, programs, food and beverage operations, and golf course. Golf Surcharge Fund 34,669$ -$ 34,669$ 301,738$ Accounts for the collection of the $3 per round golf surcharge. Internal Service Funds Self Insurance Fund 1,133,339$ 2,046,874$ (913,535)$ (938,915)$ Accounts for the Village's health insurance costs and the related contributions from the Village, employees, retirees, and other agencies. Garage Fund 287,158$ 222,800$ 64,358$ 317,630$ Accounts for the maintenance of the Village's vehicle fleet and the related departmental reimbursements. Equipment Replacement Fund 457,316$ 631,032$ (173,715)$ 2,651,171$ 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 May 31, 2023 5/31/23 5/31/23 5/31/22 5/31/23 YTD % of YTD 2023 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax 7,674,915$ 7,442,697 6,666,667$ 111.6%16,000,000$ (232,218)$ State Income Tax 697,551 623,628 477,083 130.7%1,145,000 (73,923) Replacement Tax 579,569 510,455 187,500 272.2%450,000 (69,114) Road & Bridge Tax - - 14,583 0.0%35,000 - Local Use Tax 139,751 148,004 125,000 118.4%300,000 8,253 Cannabis Use Tax 5,874 5,230 6,625 78.9%15,900 (644) Grants 973 1,109 6,526 17.0%15,662 136 Utility/Telecom. Tax 2,535,162 2,240,031 2,342,917 95.6%5,623,000 (295,131) Licenses and Permits 938,611 2,235,710 812,702 275.1%1,950,485 1,297,099 Charges for Services 940,675 1,083,324 686,404 157.8%1,647,370 142,649 Investment Interest 56,826 285,147 83,333 342.2%200,000 228,320 Miscellaneous Income 310,996 420,162 426,480 98.5%1,023,551 109,165 Total Operating Revenues 13,880,904$ 14,995,497$ 11,835,820$ 126.7%28,405,969$ 1,114,592$ OPERATING EXPENDITURES Personnel 6,839,783$ 7,448,967$ 9,223,771$ 80.8%22,137,051$ 609,184$ Materials and Supplies 167,268 202,146 248,773 81.3%597,056 34,878$ Operation and Contract 1,557,754 1,995,581 2,251,968 88.6%5,404,722 437,827$ Other Expenditures 4,290 4,271 3,750 113.9%9,000 (19)$ Capital Outlay 56,049 92,081 396,073 23.2%950,575 36,032$ Total Operating Expenditures 8,625,143$ 9,743,046$ 12,124,335$ 80.4%29,098,405$ 1,117,903$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 5,255,761$ 5,252,451$ (288,515)$ -1820.5%(692,436)$ (3,311)$ INTERFUND TRANSACTIONS Transfers In -$ -$ -$ N/A 677,401$ -$ Transfers Out - N/A - Reimbursements From Other Funds 235,510 325,714 - N/A - 90,204 Reimbursements To Other Funds (45,785) - - N/A - 45,785 Sports Core Loan - N/A - - Total Interfund Transactions 189,725$ 325,714$ -$ N/A 677,401$ 135,989$ NET FUND INCREASE (DECREASE)5,445,486$ 5,578,165$ (288,515)$ (15,035)$ 132,679$ *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 MAY 31, 2023 5/31/23 5/31/23 5/31/22 5/31/23 YTD % of YTD 2023 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Hotel Tax 400,691$ 488,084$ 479,167$ 101.9%1,150,000$ 87,393$ Investment Interest 3,419 21,876 5,000 437.5%12,000 18,457 Loan Interest - 2,000 1,667 120.0%4,000 2,000 Miscellaneous - - Total Operating Revenues 404,110$ 511,960$ 485,833$ 105.4%1,166,000$ 107,850$ EXPENDITURES Operation and Contract 42,767$ 53,045$ 281,081$ 18.9%674,595$ 10,279$ Capital Outlay 52,696 - - N/A - (52,696) Total Expenditures 95,462$ 53,045$ 281,081$ 18.9%674,595$ (42,417)$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 308,648$ 458,914$ 204,752$ 224.1%491,405$ 150,267$ INTERFUND TRANSACTIONS Transfer Out -$ -$ -$ N/A -$ -$ Reimbursements to Other Funds (34,500) (145,619) (145,619) 100.0%(349,485) (111,119) Total Interfund Transactions (34,500)$ (145,619)$ (145,619)$ 100.0%(349,485)$ (111,119)$ NET FUND INCREASE (DECREASE)274,148$ 313,295$ 59,133$ 141,920$ 39,148$ Note - Expenditures are recorded in program 171. Village of Oak Brook Hotel Tax Fund Financial Update For the Period Ending MAY 31, 2023 5/31/23 5/31/23 5/31/22 5/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 3,140,010$ 3,158,232$ 2,718,750$ 116.2%6,525,000$ 18,222$ Charges for Services - - N/A -$ Investment Interest 21,211 65,440 11,458 571.1%27,500 44,229 Grants - 225 454,054 0.0%1,089,730 225 Miscellaneous - 2,100 417 504.0%1,000 2,100 Total Operating Revenues 3,161,222$ 3,225,997$ 3,184,679$ 101.3%7,643,230$ 64,775$ OPERATING EXPENDITURES Personnel 577,623$ 105,707$ 18,873$ 560.1%45,294$ (471,916)$ Materials and Supplies 123,125 139,134 82,250 169.2%197,400 16,008 Operation and Contract 443,970 326,161 720,908 45.2%1,730,180 (117,810) Other Expenditures - - - N/A - Capital Outlay 630,497 1,314,661 3,844,300 34.2%9,226,320 684,164 Total Operating Expenditures 1,775,216$ 1,885,662$ 4,666,331$ 40.4%11,199,194$ 110,446$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 1,386,006$ 1,340,335$ (1,481,652)$ -90.5%(3,555,964)$ (45,671)$ INTERFUND TRANSACTIONS Transfers In -$ -$ -$ N/A -$ -$ Reimbursements From Other Funds 134,740 90,650 - N/A - (44,090) Reimbursements To Other Funds (49,220) (141,625) - N/A - (92,405) Total Interfund Transactions 85,520$ (50,975)$ -$ N/A -$ (136,495)$ NET FUND INCREASE (DECREASE)1,471,526$ 1,289,360$ (1,481,652)$ (3,555,964)$ (182,166)$ Village of Oak Brook Infrastructure Fund Financial Update For the Period Ending MAY 31, 2023 5/31/23 5/31/23 5/31/22 5/31/23 YTD % of YTD 2023 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax -$ -$ 6,250$ 0.0%15,000$ -$ Real Estate Tax 3,704 - 168,750 0.0%405,000 (3,704) Investment Interest 85 1,165 4 27956.6%10 1,080 Total Operating Revenues 3,789$ 1,165$ 175,004$ 0.7%420,010$ (2,625)$ EXPENDITURES Operation and Contract -$ 2,613$ 2,125$ 122.9%5,100$ 2,613$ Other Expenditures 243,150 336,793 140,302 240.0%336,725 93,643 Total Expenditures 243,150$ 339,406$ 142,427$ 238.3%341,825$ 96,256$ NET FUND INCREASE (DECREASE)(239,361)$ (338,241)$ 32,577$ 78,185$ (98,880)$ Note - Expenditures are recorded in program 283. Village of Oak Brook Promenade TIF Fund Financial Update For the Period Ending MAY 31, 2023 5/31/23 5/31/23 5/31/22 5/31/23 YTD % of YTD 2023 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Plan Review Fees 375$ 975$ 219$ 445.7%525$ 600$ Building/Inspection Fees 825 1,050 833 126.0%2,000 225 Water Sales 3,714,486 2,985,383 3,429,167 87.1%8,230,000 (729,103) Unmetered Sales 47,647 8,490 20,833 40.8%50,000 (39,157) Water Connection Fees 183,310 119,830 31,250 383.5%75,000 (63,480) Fire Service Charge - - - N/A - - Meter Charges 9,926 11,944 6,250 191.1%15,000 2,018 Special Services - 25,741 4,167 617.8%10,000 25,741 Investment Interest 11,102 256,193 8,333 3074.3%20,000 245,091 Proceeds from Property Sale - - - N/A - - Miscellaneous 37,963 44,513 20,833 213.7%50,000 6,550 Total Operating Revenues 4,005,635$ 3,454,119$ 3,521,885$ 98.1%8,452,525$ (551,516)$ OPERATING EXPENDITURES Personnel 161,630$ 231,003$ 269,842$ 85.6%647,620$ 69,372$ Materials and Supplies 39,592 38,514 29,021 132.7%69,650 (1,078) Operation and Contract 1,370,759 1,482,355 2,250,260 65.9%5,400,625 111,596 Capital Outlay 6,394 989,340 1,635,417 60.5%3,925,000 982,946 Total Expenditures 1,578,375$ 2,741,212$ 4,184,540$ 65.5%10,042,895$ 1,162,836$ Surplus (Deficit) of Revenues Over Expenditures 2,427,259$ 712,907$ (662,654)$ -107.6%(1,590,370)$ (1,714,352)$ INTERFUND TRANSACTIONS Reimbursements To Other Funds (175,205)$ (77,748)$ (175,204)$ 44.4%(420,490)$ 97,457$ Total Interfund Transactions (175,205)$ (77,748)$ (175,204)$ 44.4%(420,490)$ 97,457$ Fund Increase/(Decrease) - Budgetary Basis 2,252,054$ 635,159$ (837,858)$ (2,010,860)$ (1,616,896)$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay 3,894$ 989,340$ Depreciation Expense (143,750) (239,583) IMRF Pension Expense (11,250) (18,750) OPEB Expense (7,500) (12,500) Total GAAP Adjustments (158,606)$ 718,507$ Fund Increase/(Decrease) - GAAP Basis 2,093,448$ 1,353,665$ *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 MAY 31, 2023 Village of Oak Brook Monthly Operating Statement Sports Core Fund Consolidated Presentation For the Period Ending MAY 31, 2023 5/31/23 5/31/23 5/31/23 YTD % of YTD 2023 5/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 387,642$ -$ -$ 477,575$ 865,217$ 387,188$ 223.5%929,250$ 770,730$ 94,487$ Greens Fees - - - 325,075 325,075 545,833 59.6%1,310,000 258,131 66,944 Pro Shop Sales - - - 73,418 73,418 104,167 70.5%250,000 71,123 2,295 Golf Lessons - - - 16,580 16,580 20,833 79.6%50,000 27,648 (11,068) Driving Range Fees - - - 194,005 194,005 145,833 133.0%350,000 159,711 34,295 Rentals - 131,580 23,492 111,051 266,123 451,667 58.9%1,084,000 278,933 (12,810) Programs/User Fees 45,220 - - - 45,220 28,792 157.1%69,100 32,718 12,502 Food Sales - - - 71,789 71,789 120,833 59.4%290,000 57,764 14,026 Beverage Sales - - - 117,278 117,278 205,000 57.2%492,000 98,631 18,648 Taste of Oak Brook - - - - - - N/A - 5,500 (5,500) Grants - - - - - - N/A - - - Other Revenue 805 - - - 805 11,510 7.0%27,625 311 494 Total Operating Revenues 433,668$ 131,580$ 23,492$ 1,386,773$ 1,975,513$ 2,021,656$ 97.7%4,851,975$ 1,761,199$ 214,314$ OPERATING EXPENDITURES Personnel 419$ -$ 3,380$ 355,794$ 359,593$ 720,133$ 49.9%1,671,380$ 383,966$ (24,374)$ Materials & Supplies 5,383 - 529 137,558 143,470 342,516 41.9%718,900 129,840 13,630 Operational & Contractual 158,056 31,682 19,042 89,975 298,755 314,924 94.9%942,765 288,754 10,001 Other - - - - - - N/A - - - Capital - - - 54,978 54,978 657,813 8.4%466,750 185,236 (130,258) Total Operating Expenditures 163,859$ 31,682$ 22,951$ 638,305$ 856,796$ 2,035,385$ 42.1%3,799,795$ 987,797$ (131,001)$ B&T Administration Overhead Allocation*-$ -$ -$ -$ -$ -$ N/A -$ (12,352)$ (12,352)$ Operating Revenues Over (Under) Expenditures 269,809$ 99,898$ 541$ 748,468$ 1,118,717$ (13,729)$ -8148.4%1,052,180$ 761,050$ 332,963$ INTERFUND TRANSACTIONS Interfund Loan**-$ -$ -$ -$ -$ -$ N/A -$ -$ -$ Transfer From General Fund - - - - - - N/A - - - Transfer From Golf Surcharge Fund - - - - - 62,500 0.0%150,000 - - Reimbursement From Infrastructure Fund - - - - - - N/A - - - Reimbursement From Water Fund - - - - - - N/A - - - Reimbursement To General Fund (13,494) - - (20,242) (33,736) (33,736) 100.0%(80,967) (31,440) (2,296) Total Interfund Transactions (13,494)$ -$ -$ (20,242)$ (33,736)$ 28,764$ -117.3%69,033$ (31,440)$ (2,296)$ Total Revenues Over (Under) Expenditures - Budgetary Basis 256,315$ 99,898$ 541$ 728,226$ 1,084,981$ 15,035$ 1,121,213$ 729,610$ 330,667$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ -$ -$ 54,978$ 54,978$ 160,236$ Depreciation Expense (70,095) (702) (25,000) (102,625) (198,422) (174,672) IMRF Pension Expense (854) - (1,250) (10,208) (12,313) (12,313) OPEB Expense - - (1,250) (11,667) (12,917) (11,667) Total GAAP Adjustments (70,949)$ (702)$ (27,500)$ (69,522)$ (168,673)$ (38,414)$ Fund Increase/(Decrease) - GAAP Basis 185,366$ 99,196$ (26,959)$ 658,704$ 916,308$ 691,195$ *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 MAY 31, 2023 5/31/23 5/31/23 822 5/31/23 YTD % of YTD 2023 5/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 -$ 367,625$ 16,135$ 3,882$ 387,642$ 216,354$ 179.2%519,250$ 368,630$ 19,012$ Programs/User Fees - 40,068 3,309 1,843 45,220 28,791.67 157.1%69,100 32,718 12,502 Food Sales - - - - - 16,666.67 0.0%40,000 4,871 - Beverage Sales - - - - - 7,083.33 0.0%17,000 1,912 - Grants - - - - - - N/A - - - Other Revenue 805 - - - 805 969 83.1%2,325 311 494 Total Operating Revenues 805$ 407,693$ 19,444$ 5,726$ 433,668$ 269,865$ 160.7%647,675$ 408,442$ 32,009$ OPERATING EXPENDITURES Personnel 146$ -$ -$ 273$ 419$ 82,820$ 0.5%198,768$ 5,930$ (5,511)$ Materials & Supplies 115 3,358 1,408 503 5,383 29,915 18.0%71,796 12,640 (7,257) Operational & Contractual 30,317 124,368 2,156 1,215 158,056 102,910 153.6%246,985 119,611 38,446 Other - - - - - - N/A - - Capital - - - - - 229,167 0.0%550,000 152,755 (152,755) Total Operating Expenditures 30,579$ 127,726$ 3,564$ 1,990$ 163,859$ 444,812$ 36.8%1,067,549$ 290,936$ (127,078)$ B&T Administration Overhead Allocation*-$ -$ -$ -$ -$ -$ N/A 43,783$ -$ -$ Operating Revenues Over (Under) Expenditures (29,773)$ 279,967$ 15,880$ 3,735$ 269,809$ (174,948)$ -154.2%(376,092)$ 117,506$ 159,086$ Transfer From General Fund - - - - - - N/A - - Reimbursement From Infrastructure Fund - - - - - -$ N/A - - - Reimbursement From Water Fund - - - - - - N/A - - - Reimbursement To General Fund (13,494) - - - (13,494) (8,434) 160.0%(20,242) (7,860) (5,634) Total Interfund Transactions (13,494)$ -$ -$ -$ (13,494)$ (8,434)$ 160.0%(20,242)$ (7,860)$ (5,634)$ Total Revenues Over (Under) Expenditures - Budgetary Basis (43,268)$ 279,967$ 15,880$ 3,735$ 256,315$ (183,382)$ (396,334)$ 109,646$ 153,452$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ -$ -$ -$ -$ 152,755$ Depreciation Expense (26,816) (41,667) (1,125) (487) (70,095) (70,095) IMRF Pension Expense (833) - - (21) (854) (854) Total GAAP Adjustments (27,650)$ (41,667)$ (1,125)$ (508)$ (70,949)$ 81,807$ Fund Increase/(Decrease) - GAAP Basis (70,917)$ 238,300$ 14,755$ 3,228$ 185,366$ 191,452$ *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 MAY 31, 2023 5/31/23 5/31/23 5/31/23 YTD % of YTD 2023 5/31/22 Difference 815 816 YTD Amended Amended Adopted YTD Prior Polo Open Fields Total Budget Budget Budget Total Year OPERATING REVENUES Field Rentals -$ 45,500$ 45,500$ 75,417$ 60.3%181,000$ 67,643$ (22,143)$ Range Rentals - 86,080 86,080 35,417 243.0%85,000 80,000 6,080 Taste of Oak Brook - - - - N/A - 5,500 - Other Revenue - - - - N/A - - - Total Operating Revenues -$ 131,580$ 131,580$ 110,833$ 118.7%266,000$ 153,143$ (16,063)$ OPERATING EXPENDITURES Personnel -$ -$ -$ -$ N/A -$ -$ Materials & Supplies - - - 3,954 0.0%9,490$ - - Operational & Contractual 12,850 18,832 31,682 52,475 60.4%125,940 14,565 17,117 Capital - - - - N/A - - Total Operating Expenditures 12,850$ 18,832$ 31,682$ 56,429$ 56.1%135,430$ 14,565$ 17,117$ Operating Revenues Over (Under) Expenditures (12,850)$ 112,748$ 99,898$ 54,404$ 183.6%130,570$ 138,578$ (33,180)$ INTERFUND TRANSACTIONS Transfer From Hotel Tax Fund -$ -$ -$ -$ N/A -$ -$ -$ Total Interfund Transactions -$ -$ -$ -$ N/A -$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis (12,850)$ 112,748$ 99,898$ 54,404$ 130,570$ 138,578$ (33,180)$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ -$ -$ -$ Depreciation Expense - (702) (702) (702) Total GAAP Adjustments -$ (702)$ (702)$ (702)$ Fund Increase/(Decrease) - GAAP Basis (12,850)$ 112,046$ 99,196$ 137,876$ *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 MAY 31, 2023 5/31/23 5/31/23 821 YTD % of YTD 2023 5/31/22 Difference B&T Amended Amended Adopted YTD Prior Clubhouse Budget Budget Budget Total Year OPERATING REVENUES Rentals 23,492$ 145,833$ 16.1%350,000$ 43,756$ (20,264)$ Other Revenue - - 0.0%- - - Total Operating Revenues 23,492$ 145,833$ 16.1%350,000$ 43,756$ (20,264)$ OPERATING EXPENDITURES Personnel 3,380$ 59,564$ 5.7%142,954$ 47,758$ (44,378)$ Materials & Supplies 529 9,988 5.3%23,972 421 108 Operational & Contractual 19,042 32,017 59.5%76,842 26,567 (7,525) Capital - - N/A - - - Total Operating Expenditures 22,951$ 101,570$ 22.6%243,767$ 74,745$ (51,794)$ B&T Administration Overhead Allocation*-$ -$ N/A (43,784)$ (12,352)$ 12,352$ Operating Revenues Over (Under) Expenditures 541$ 44,264$ 1.2%62,449$ (43,341)$ 43,882$ INTERFUND TRANSACTIONS Transfer From General Fund -$ -$ 0.0%-$ -$ -$ Total Interfund Transactions -$ -$ 0.0%-$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis 541$ 44,264$ 62,449$ (43,341)$ 43,882$ 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 (26,959)$ (70,841)$ *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 MAY 31, 2023 5/31/23 5/31/23 823 831 832 833 834 5/31/23 YTD % of YTD 2023 5/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 -$ 477,575$ -$ -$ -$ 477,575$ 170,833$ 279.6%410,000$ 402,100$ 75,475$ Greens Fees - 325,075 - - - 325,075 545,833 59.6%1,310,000 258,131 66,944 Pro Shop Sales - 73,418 - - - 73,418 104,167 70.5%250,000 71,123 2,295 Golf Lessons - - 16,580 - - 16,580 20,833 79.6%50,000 27,648 (11,068) Driving Range Fees - - 194,005 - - 194,005 145,833 133.0%350,000 159,711 34,295 Rentals - 370 - 110,681 - 111,051 195,000 56.9%468,000 87,534 23,517 Food Sales 71,789 - - - 71,789 104,167 68.9%250,000 52,892 18,897 Beverage Sales 117,278 - - - - 117,278 197,917 59.3%475,000 96,719 20,559 Other Revenue - - - - - - 10,542 0.0%25,300 - - Total Operating Revenues 189,068$ 876,439$ 210,585$ 110,681$ -$ 1,386,773$ 1,495,125$ 92.8%3,588,300$ 1,155,858$ 230,915$ OPERATING EXPENDITURES Personnel 56,843$ 176,952$ 12,191$ 6,557$ 103,252$ 355,794$ 577,749$ 61.6%1,386,598$ 330,278$ 25,515$ Materials & Supplies 88,429 (31,747) 14,283 1,430 65,164 137,558 298,658 46.1%716,780 116,780 20,779 Operational & Contractual 2,534 44,324 5,250 14,327 23,541 89,975 127,521 70.6%306,050 128,012 (38,037) Other - - - - - - - N/A - - - Capital - 41,688 13,290 - - 54,978 428,646 12.8%1,028,751 32,481 22,497 Total Operating Expenditures 147,805$ 231,216$ 45,013$ 22,314$ 191,956$ 638,305$ 1,432,574$ 44.6%3,438,178$ 607,551$ 30,754$ Operating Revenues Over (Under) Expenditures 41,263$ 645,223$ 165,572$ 88,367$ (191,956)$ 748,468$ 62,551$ 1196.6%150,122$ 548,307$ 200,161$ INTERFUND TRANSACTIONS Transfer from Golf Surcharge -$ -$ -$ -$ -$ -$ 62,500$ 0.0%150,000$ -$ -$ Reimbursement to General Fund - (20,242) - - - (20,242) (25,302) 80.0%(60,725) (23,580) 3,338 Total Interfund Transactions -$ (20,242)$ -$ -$ -$ (20,242)$ 37,198$ -54.4%89,275$ (23,580)$ 3,338$ Total Revenues Over (Under) Expenditures - Budgetary Basis 41,263$ 624,981$ 165,572$ 88,367$ (191,956)$ 728,226$ 99,749$ 239,397$ 524,727$ 203,499$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay -$ 41,688$ 13,290$ -$ -$ 54,978$ 32,481$ Depreciation Expense (417) (43,750) (958) (5,417) (52,083) (102,625) (102,625) IMRF Pension Expense (1,042) (4,167) (417) - (4,583) (10,208) (10,208) OPEB Expense (1,250) (6,250) - - (4,167) (11,667) (11,667) Total GAAP Adjustments (2,708)$ (12,479)$ 11,915$ (5,417)$ (60,833)$ (69,522)$ (92,019)$ Fund Increase/(Decrease) - GAAP Basis 38,554$ 612,502$ 177,487$ 82,951$ (252,790)$ 658,704$ 432,708$ *Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.