The URL can be used to link to this page

Home My WebLink About09 - September 2024 Monthly Financial ReportVILLAGE OAK BROOKOF MONTHLY FINANCIAL REPORTS SEPTEMBER 2024 Estimated YTD YTD Net Fund Ending YTD YTD Increase Fund Balance Governmental Funds Revenues Expenditures (Decrease)(Deficit) General Fund (Major Fund)25,030,373$ 20,546,819$ 4,483,554$ 47,108,942$ Main operating fund of the Village. Hotel Fund (Major Fund)1,335,334$ 202,628$ 1,132,705$ 4,903,902$ Collects and spends resources from the 3% hotel/motel tax. Motor Fuel Tax Fund 342,459$ 89,327$ 253,132$ 2,275,234$ Collects and spends resources from the State motor fuel tax. Infrastructure Fund (Major Fund)6,327,944$ 1,475,246$ 4,852,698$ 19,277,205$ Accounts for construction and maintenance of roadways, drainage, and safety path systems. Enterprise Funds Water Fund (Major Fund)10,368,416$ 9,145,958$ 1,222,458$ 23,141,101$ Collects user fees for the distribution of water and maintenance of infrastructure. Sports Core Fund (Major Fund)4,388,571$ 4,026,885$ 361,686$ 3,265,574$ Accounts for revenues and expenses relating to administration, programs, food and beverage operations, and golf course. Internal Service Funds Insurance Fund 2,177,445$ 2,538,994$ (361,549)$ 203,894$ Accounts for the Village's health insurance costs and the related contributions from the Village, employees, retirees, and other agencies. Garage Fund 437,751$ 584,575$ (146,824)$ 199,651$ Accounts for the maintenance of the Village's vehicle fleet and the related departmental reimbursements. Equipment Replacement Fund 830,095$ 739,569$ 90,525$ 3,138,482$ 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 September 30, 2024 9/30/24 9/30/24 9/30/23 9/30/24 YTD % of YTD 2024 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax 13,185,513$ 13,141,681 12,372,453$ 106.2%16,496,604$ (43,832)$ State Income Tax 992,305 1,070,610 983,250 108.9%1,311,000 78,305 Replacement Tax 714,974 420,168 563,261 74.6%751,015 (294,806) Road & Bridge Tax 27,804 21,914 26,250 83.5%35,000 (5,890) Local Use Tax 246,078 232,854 252,000 92.4%336,000 (13,224) Cannabis Use Tax 9,344 9,963 9,885 100.8%13,180 618 Grants 592,648 168,440 124,247 135.6%165,662 (424,208) Utility/Telecom. Tax 3,774,769 2,341,224 3,450,000 67.9%4,600,000 (1,433,545) Licenses and Permits 3,458,226 1,738,499 1,685,858 103.1%2,247,810 (1,719,727) Charges for Services 2,763,961 3,270,290 1,630,988 200.5%2,174,650 506,329 Investment Interest 816,270 1,327,395 337,500 393.3%450,000 511,125 Miscellaneous Income 861,979 630,381 687,052 91.8%916,070 (231,598) Total Operating Revenues 27,443,870$ 24,373,418$ 22,122,744$ 110.2%29,496,991$ (3,070,452)$ OPERATING EXPENDITURES Personnel 15,014,983$ 15,737,023$ 16,923,910$ 93.0%22,565,214$ 722,040$ Materials and Supplies 423,328 423,096 496,196 85.3%661,594 (232)$ Operation and Contract 3,651,627 4,116,388 4,743,235 86.8%6,324,313 464,761$ Other Expenditures 6,394 6,356 7,425 85.6%9,900 (38)$ Capital Outlay 718,439 263,955 497,330 53.1%663,107 (454,484)$ Total Operating Expenditures 19,814,771$ 20,546,819$ 22,668,096$ 90.6%30,224,129$ 732,048$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 7,629,099$ 3,826,599$ (545,353)$ -701.7%(727,137)$ (3,802,500)$ INTERFUND TRANSACTIONS Transfers In -$ -$ -$ N/A -$ -$ Transfers Out N/A - Reimbursements From Other Funds 586,286 656,955 656,954 100.0%875,938 70,669 Reimbursements To Other Funds - - 75,000 0.0%100,000 - Sports Core Loan N/A - - Total Interfund Transactions 586,286$ 656,955$ 731,954$ 89.8%975,938$ 70,669$ NET FUND INCREASE (DECREASE)8,215,385$ 4,483,554$ 186,601$ 248,801$ (3,731,831)$ Village of Oak Brook General Fund Financial Update For the Period Ending September 30, 2024 9/30/24 9/30/24 9/30/23 9/30/24 YTD % of YTD 2024 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Hotel Tax 1,120,924$ 1,197,355$ 1,087,500$ 110.1%1,450,000$ 76,431$ Investment Interest 63,717 136,979 18,750 730.6%25,000 73,262 Loan Interest 2,000 1,000 1,500 66.7%2,000 (1,000) Miscellaneous - - - - Total Operating Revenues 1,186,641$ 1,335,334$ 1,107,750$ 120.5%1,477,000$ 148,693$ EXPENDITURES Personnel -$ 30,125$ 14,928$ 201.8%-$ 30,125$ Operation and Contract 205,995 (15,755) 528,784 -3.0%705,045 (221,750) Capital Outlay - 5,324 206,250 2.6%275,000 5,324 Total Expenditures 205,995$ 19,694$ 749,962$ 2.6%980,045$ (186,301)$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 980,645$ 1,315,639$ 372,716$ 353.0%496,955$ 334,994$ INTERFUND TRANSACTIONS Transfer Out -$ -$ -$ N/A -$ -$ Reimbursements to Other Funds (262,115) (182,934) (182,936) 100.0%(243,915) 79,181 Total Interfund Transactions (262,115)$ (182,934)$ (182,936)$ 100.0%(243,915)$ 79,181$ NET FUND INCREASE (DECREASE)718,530$ 1,132,705$ 189,780$ 253,040$ 414,175$ Note - Expenditures are recorded in program 171. Village of Oak Brook Hotel Tax Fund Financial Update For the Period Ending September 30, 2024 9/30/24 9/30/24 9/30/23 9/30/24 YTD % of YTD 2024 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Non-Home Rule Sales Tax 5,596,918$ 5,714,383$ 5,027,250$ 113.7%6,703,000$ 117,466$ Charges for Services - - N/A -$ Investment Interest 207,909 611,165 93,750 651.9%125,000 403,256 Grants - - - N/A - - Miscellaneous 2,100 2,395 17,250 13.9%23,000 295 Total Operating Revenues 5,806,927$ 6,327,944$ 5,138,250$ 123.2%6,851,000$ 521,017$ OPERATING EXPENDITURES Personnel 25,970$ 12,065$ -$ N/A -$ (13,905)$ Materials and Supplies 155,431 21,469 34,875 61.6%46,500 (133,961) Operation and Contract 652,162 955,969 1,307,226 73.1%1,742,968 303,806 Other Expenditures - - 254,924 0.0%339,899 - Capital Outlay 1,528,001 461,740 2,537,831 18.2%3,383,775 (1,066,261) Total Operating Expenditures 2,361,564$ 1,451,243$ 4,134,857$ 35.1%5,513,142$ (910,321)$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 3,445,363$ 4,876,701$ 1,003,393$ 486.0%1,337,858$ 1,431,338$ INTERFUND TRANSACTIONS Transfers In -$ -$ -$ N/A -$ -$ Reimbursements From Other Funds 163,170 - - N/A - (163,170) Reimbursements To Other Funds (254,925) (24,003) - N/A - 230,922 Total Interfund Transactions (91,755)$ (24,003)$ -$ N/A -$ 67,752$ NET FUND INCREASE (DECREASE)3,353,608$ 4,852,698$ 1,003,393$ 1,337,858$ 1,499,090$ Village of Oak Brook Infrastructure Fund Financial Update For the Period Ending September 30, 2024 9/30/24 9/30/24 9/30/23 9/30/24 YTD % of YTD 2024 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Plan Review Fees 1,575$ 1,352$ 394$ 343.3%525$ (223)$ Building/Inspection Fees 1,350 - 1,500 0.0%2,000 (1,350) Water Sales 7,641,146 8,046,073 8,040,000 100.1%10,720,000 404,927 Unmetered Sales 39,136 51,832 48,750 106.3%65,000 12,695 Water Connection Fees 138,920 65,090 105,000 62.0%140,000 (73,830) Fire Service Charge - - - N/A - - Meter Charges 16,030 11,720 12,975 90.3%17,300 (4,310) Special Services 25,741 15,054 7,500 200.7%10,000 (10,687) Investment Interest 693,359 997,463 262,500 380.0%350,000 304,104 Grants - 1,090,855 - N/A - 1,090,855 Miscellaneous 87,170 88,978 862,298 10.3%1,149,730 1,807 Total Operating Revenues 8,644,428$ 10,368,416$ 9,340,916$ 111.0%12,454,555$ 1,723,988$ OPERATING EXPENDITURES Personnel 504,937$ 447,267$ 589,810$ 75.8%786,413$ (57,670)$ Materials and Supplies 73,735 78,094 102,912 75.9%137,216 4,359 Operation and Contract 4,020,163 5,087,271 5,326,027 95.5%7,101,369 1,067,108 Capital Outlay 1,170,961 3,205,663 4,267,500 75.1%5,690,000 2,034,702 Total Expenditures 5,769,796$ 8,818,295$ 10,286,249$ 85.7%13,714,999$ 3,048,500$ Surplus (Deficit) of Revenues Over Expenditures 2,874,633$ 1,550,121$ (945,333)$ -164.0%(1,260,444)$ (1,324,512)$ INTERFUND TRANSACTIONS Reimbursements To Other Funds (139,948)$ (327,663)$ (327,659)$ 100.0%(436,879)$ (187,715)$ Total Interfund Transactions (139,948)$ (327,663)$ (327,659)$ 100.0%(436,879)$ (187,715)$ Fund Increase/(Decrease) - Budgetary Basis 2,734,684$ 1,222,458$ (1,272,992)$ (1,697,323)$ (1,512,226)$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay 1,170,961$ 3,205,663$ Depreciation Expense (191,667) (431,250) IMRF Pension Expense (15,000) (33,750) OPEB Expense (10,000) (22,500) Total GAAP Adjustments 954,294$ 2,718,163$ Fund Increase/(Decrease) - GAAP Basis 3,688,978$ 3,940,620$ *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 September 30, 2024 Village of Oak Brook Monthly Operating Statement Sports Core Fund Consolidated Presentation For the Period Ending September 30, 2024 9/30/24 9/30/24 9/30/24 YTD % of YTD 2024 9/30/23 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 431,243$ -$ -$ 393,375$ 824,618$ 713,044$ 115.6%950,725$ 887,047$ (62,430)$ Greens Fees - - - 1,520,067 1,520,067 1,053,750 144.3%1,405,000 1,294,628 225,439 Golf Surcharge - - - 200,077 200,077 53,143 376.5%53,143 94,127 105,950 Pro Shop Sales - - - 141,009 141,009 163,500 86.2%218,000 173,880 (32,871) Golf Lessons - - - 35,245 35,245 33,750 104.4%45,000 24,872 10,373 Driving Range Fees - - - 493,359 493,359 292,500 168.7%390,000 388,753 104,606 Rentals - 131,096 101,216 598,500 830,813 748,650 111.0%998,200 758,674 72,139 Programs/User Fees 136,162 - - - 136,162 82,350 165.3%109,800 102,959 33,203 Food Sales 8,587 - - 65,111 73,697 35,925 205.1%47,900 282,357 (208,660) Beverage Sales - - - - - 58,238 0.0%77,650 453,376 (453,376) Taste of Oak Brook - - - - - - N/A - - - Grants - - - - - - N/A - - - Other Revenue 97,087 - - 6,432 103,519 74,370 139.2%99,160 33,130 70,389 Total Operating Revenues 673,077$ 131,096$ 101,216$ 3,453,175$ 4,358,565$ 3,309,219$ 131.7%4,394,578$ 4,493,803$ (135,238)$ OPERATING EXPENDITURES Personnel 186,638$ -$ -$ 888,676$ 1,075,314$ 1,046,235$ 102.8%1,671,380$ 1,147,539$ (72,225)$ Materials & Supplies 36,508 - 7,354 289,435 333,298 324,940 102.6%718,900 597,038 (263,740) Operational & Contractual 538,377 30,876 38,434 315,033 922,720 813,182 113.5%942,765 744,807 177,913 Other - - - - - - N/A - - - Capital 720,250 - - 822,943 1,543,193 807,191 191.2%466,750 111,412 1,431,781 Total Operating Expenditures 1,481,772$ 30,876$ 45,788$ 2,316,088$ 3,874,524$ 2,991,548$ 129.5%3,799,795$ 2,600,796$ 1,273,728$ B&T Administration Overhead Allocation*28,093$ -$ (9,375)$ (18,717)$ -$ (18,717)$ N/A (24,957) -$ (24,957)$ Operating Revenues Over (Under) Expenditures (780,602)$ 100,220$ 46,053$ 1,118,370$ 484,041$ 298,954$ 161.9%569,826$ 1,893,007$ (1,433,922)$ INTERFUND TRANSACTIONS Interfund Loan**-$ -$ -$ -$ -$ -$ N/A -$ -$ -$ Transfer From General Fund - - - - - - N/A - - - Reimbursement From Infrastructure Fund - - - - - - N/A - - - Reimbursement From Water Fund 30,006 - - - 30,006 30,000 100.0%40,000 - 30,006 Reimbursement To General Fund (38,088) - - (114,273) (152,361) (129,450) 117.7%(172,600) (60,724) (91,637) Total Interfund Transactions (8,082)$ -$ -$ (114,273)$ (122,355)$ (99,450)$ 123.0%(132,600)$ (60,724)$ (61,631)$ Total Revenues Over (Under) Expenditures - Budgetary Basis (788,684)$ 100,220$ 46,053$ 1,004,097$ 361,686$ 199,504$ 437,226$ 1,832,283$ (1,495,554)$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay 720,250$ -$ -$ 822,943$ 1,543,193$ 111,412$ Depreciation Expense (126,170) (1,264) (25,000) (184,725) (337,159) (337,159) IMRF Pension Expense (1,538) - (1,250) (18,375) (21,163) (21,163) OPEB Expense - - (1,250) (21,000) (22,250) (22,250) Total GAAP Adjustments 592,542$ (1,264)$ (27,500)$ 598,843$ 1,162,622$ (269,160)$ Fund Increase/(Decrease) - GAAP Basis (196,142)$ 98,956$ 18,553$ 1,602,940$ 1,524,307$ 1,563,123$ *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 September 30, 2024 9/30/24 9/30/24 822 9/30/24 YTD % of YTD 2024 9/30/23 Difference 811 812 813 Poolside YTD Adopted Amended Adopted YTD Prior B&T Admin Swimming Tennis Café Total Budget Budget Budget Total Year OPERATING REVENUES Memberships -$ 401,663$ 29,580$ -$ 431,243$ 332,081$ 129.9%442,775$ 406,947$ 24,296$ Programs/User Fees - 79,942 56,220 - 136,162 82,350.00 165.3%109,800 102,959 33,203 Food Sales - - - 8,587 8,587 4,500.00 190.8%6,000 53,070 - Beverage Sales - - - - - 1,800.00 0.0%2,400 18,909 - Grants - - - - - - N/A - - - Other Revenue 88,237 - 2,350 6,500 97,087 67,620 143.6%90,160 2,747 94,340 297 Total Operating Revenues 88,534$ 481,604$ 88,150$ 15,087$ 673,077$ 488,351$ 137.8%651,135$ 584,632$ 151,838$ OPERATING EXPENDITURES Personnel 137,449$ 49,188$ -$ -$ 186,638$ 188,916$ 98.8%251,888$ 61,776$ 124,862$ Materials & Supplies 21 21,478 13,344 1,665 36,508 34,035 107.3%45,380 55,630 (19,122) Operational & Contractual 167,802 282,594 87,218 763 538,377 429,775 125.3%573,034 380,496 157,881 Other - - - - - - N/A - - - Capital 635,293 84,957 - - 720,250 655,875 109.8%874,500 - 720,250 Total Operating Expenditures 940,565$ 438,217$ 100,562$ 2,428$ 1,481,772$ 1,308,601$ 113.2%1,744,801$ 497,902$ 983,870$ B&T Administration Overhead Allocation*78,375$ (30,839)$ (8,569)$ (10,875)$ 28,093$ -$ N/A 37,457$ -$ 28,093$ Operating Revenues Over (Under) Expenditures (773,656)$ 12,548$ (20,981)$ 1,784$ (780,602)$ (820,250)$ 95.2%(1,056,210)$ 86,730$ (803,940)$ Transfer From General Fund -$ -$ -$ -$ -$ -$ N/A - - Reimbursement From Infrastructure Fund - - - - - - N/A - - - Reimbursement From Water Fund 30,006 - - - 30,006 30,000 100.0%40,000 - 30,006 Reimbursement To General Fund (38,088) - - - (38,088) (15,182) 250.9%(20,242) (40,482) 2,394 Total Interfund Transactions (8,082)$ -$ -$ -$ (8,082)$ 14,819$ -54.5%19,758$ (40,482)$ 32,400$ Total Revenues Over (Under) Expenditures - Budgetary Basis (781,738)$ 12,548$ (20,981)$ 1,784$ (788,684)$ (805,432)$ (1,036,452)$ 46,248$ (771,540)$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay 635,293$ 84,957$ -$ -$ 720,250$ -$ Depreciation Expense (48,269) (75,000) (2,025) (876) (126,170) (126,170) IMRF Pension Expense (1,500) - - (38) (1,538) (1,538) Total GAAP Adjustments 585,524$ 9,957$ (2,025)$ (914)$ 592,542$ (127,708)$ Fund Increase/(Decrease) - GAAP Basis (196,214)$ 22,505$ (23,006)$ 871$ (196,142)$ (81,460)$ *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 September 30, 2024 9/30/24 9/30/24 9/30/24 YTD % of YTD 2024 9/30/23 Difference 815 816 YTD Amended Amended Adopted YTD Prior Polo Open Fields Total Budget Budget Budget Total Year OPERATING REVENUES Field Rentals -$ 131,096$ 131,096 144,750$ 90.6%193,000$ 127,500$ 3,596$ Range Rentals - - - - N/A - 86,080 (86,080) Taste of Oak Brook - - - - N/A - - - Other Revenue - - - - N/A - - - Total Operating Revenues -$ 131,096$ 131,096$ 144,750$ 90.6%193,000$ 213,580$ (82,484)$ OPERATING EXPENDITURES Personnel -$ -$ -$ -$ N/A -$ -$ Materials & Supplies - - - 7,118 0.0%9,490$ 1,064 (1,064) Operational & Contractual - 30,876 30,876 57,038 54.1%76,050 30,876 0 Other - - - - N/A - - - Capital - - - 34,500 0.0%46,000 - - Total Operating Expenditures -$ 30,876$ 30,876$ 98,655$ 31.3%131,540$ 31,940$ (1,064)$ Operating Revenues Over (Under) Expenditures -$ 100,220$ 100,220$ 46,095$ 217.4%61,460$ 181,640$ (81,420)$ INTERFUND TRANSACTIONS Transfer From Hotel Tax Fund -$ -$ -$ -$ N/A -$ -$ -$ Total Interfund Transactions -$ -$ -$ -$ N/A -$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis -$ 100,220$ 100,220$ 46,095$ 61,460$ 181,640$ (81,420)$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ -$ -$ -$ Depreciation Expense - (1,264) (1,264) (1,264) Total GAAP Adjustments -$ (1,264)$ (1,264)$ (1,264)$ Fund Increase/(Decrease) - GAAP Basis -$ 98,956$ 98,956$ 180,376$ *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 September 30, 2024 9/30/24 9/30/24 821 YTD % of YTD 2024 9/30/23 Difference B&T Amended Amended Adopted YTD Prior Clubhouse Budget Budget Budget Total Year OPERATING REVENUES Rentals 101,216$ 174,750$ 57.9%233,000$ 116,344$ (15,128)$ Other Revenue - - 0.0%- - - Total Operating Revenues 101,216$ 174,750$ 57.9%233,000$ 116,344$ (15,128)$ OPERATING EXPENDITURES Personnel -$ -$ N/A -$ 8,130$ (8,130)$ Materials & Supplies 7,354 10,313 71.3%13,750 7,162 192 Operational & Contractual 38,434 39,734 96.7%52,978 53,444 (15,011) Capital - - N/A - - - Total Operating Expenditures 45,788$ 50,046$ 91.5%66,728$ 68,736$ (22,948)$ B&T Administration Overhead Allocation*(9,375)$ -$ N/A (12,500)$ -$ (9,375)$ Operating Revenues Over (Under) Expenditures 46,053$ 124,704$ 36.9%153,772$ 47,608$ (1,555)$ INTERFUND TRANSACTIONS Transfer From General Fund -$ -$ 0.0%-$ -$ -$ Total Interfund Transactions -$ -$ 0.0%-$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis 46,053$ 124,704$ 153,772$ 47,608$ (1,555)$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ -$ Depreciation Expense (25,000) (25,000) IMRF Pension Expense (1,250) (1,250) OPEB Expense (1,250) (1,250) Total GAAP Adjustments (27,500)$ (27,500)$ Fund Increase/(Decrease) - GAAP Basis 18,553$ 20,108$ *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 September 30, 2024 9/30/24 9/30/24 823 831 832 833 834 9/30/24 YTD % of YTD 2024 9/30/23 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 -$ 393,375$ -$ -$ -$ 393,375$ 380,963$ 103.3%507,950$ 480,100$ (86,725)$ Greens Fees - 1,520,067 - - - 1,520,067 1,053,750 144.3%1,405,000 1,294,628 225,439 Surcharge - 200,077 200,077 53,143 376.5%53,143 94,127 105,950 Pro Shop Sales - 141,009 - - - 141,009 163,500 86.2%218,000 173,880 (32,871) Golf Lessons - - 35,245 - - 35,245 33,750 104.4%45,000 24,872 10,373 Driving Range Fees - - 493,359 - - 493,359 292,500 168.7%390,000 388,753 104,606 Rentals 21,000 2,495 60,912 514,093 - 598,500 429,150 139.5%572,200 428,750 169,750 Food Sales 65,111 - - - - 65,111 31,425 207.2%41,900 229,287 (164,176) Beverage Sales - - - - - - 56,438 0.0%75,250 434,467 (434,467) Other Revenue - 6,432 - - - 6,432 6,750 95.3%9,000 30,383 (23,951) Total Operating Revenues 86,111$ 2,263,455$ 589,516$ 514,093$ -$ 3,453,175$ 2,501,368$ 138.1%3,317,443$ 3,579,247$ (126,072)$ OPERATING EXPENDITURES Personnel 5,184$ 251,757$ 58,097$ 64,562$ 509,077$ 888,676$ 857,319$ 103.7%1,143,092$ 1,077,633$ (188,957)$ Materials & Supplies (15) 134,637 19,446 979 134,389 289,435 273,475 105.8%364,633 533,182 (243,747) Operational & Contractual 4,051 192,716 41,941 32,799 43,526 315,033 286,636 109.9%382,181 279,991 35,042 Other - - - - - N/A - - - Capital - 19,955 - 671,600 131,389 822,943 116,816 704.5%155,755 111,412 711,531 Total Operating Expenditures 9,220$ 599,064$ 119,484$ 769,940$ 818,381$ 2,316,088$ 1,534,246$ 151.0%2,045,661$ 2,002,218$ 313,870$ Operating Revenues Over (Under) Expenditures 76,890$ 1,664,391$ 470,033$ (255,847)$ (818,381)$ 1,137,087$ 967,122$ 117.6%1,271,782$ 1,577,029$ (439,941)$ INTERFUND TRANSACTIONS Overhead Charge -$ (18,717)$ -$ -$ -$ (18,717)$ (18,717)$ 100.0%(24,957)$ -$ (18,717)$ Transfers from Other Fund - - - - - - - 0.0%150,000 - - Reimbursement to General Fund - (114,273) - - - (114,273) (114,269) 100.0%(152,358) (20,242) (94,031) Total Interfund Transactions -$ (132,990)$ -$ -$ -$ (132,990)$ (132,986)$ 100.0%(27,315)$ (20,242)$ (112,749)$ Total Revenues Over (Under) Expenditures - Budgetary Basis 76,890$ 1,531,401$ 470,033$ (255,847)$ (818,381)$ 1,004,097$ 834,136$ 1,244,467$ 1,556,787$ (552,690)$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay -$ 19,955$ -$ 671,600$ 131,389$ 822,943$ 111,412$ Depreciation Expense (750) (78,750) (1,725) (9,750) (93,750) (184,725) (184,725) IMRF Pension Expense (1,875) (7,500) (750) - (8,250) (18,375) (18,375) OPEB Expense (2,250) (11,250) - - (7,500) (21,000) (21,000) Total GAAP Adjustments (4,875)$ (77,546)$ (2,475)$ 661,850$ 21,889$ 598,843$ (112,688)$ Fund Increase/(Decrease) - GAAP Basis 72,015$ 1,453,855$ 467,558$ 406,003$ (796,492)$ 1,602,940$ 1,444,099$ *Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.