The URL can be used to link to this page

Home My WebLink About08 - August 2024 Monthly Financial ReportVILLAGE OAK BROOKOF MONTHLY FINANCIAL REPORTS AUGUST 2024 Estimated YTD YTD Net Fund Ending YTD YTD Increase Fund Balance Governmental Funds Revenues Expenditures (Decrease)(Deficit) General Fund (Major Fund)22,454,311$ 18,706,896$ 3,747,414$ 46,372,803$ Main operating fund of the Village. Hotel Fund (Major Fund)1,181,534$ 181,520$ 1,000,014$ 4,771,211$ Collects and spends resources from the 3% hotel/motel tax. Motor Fuel Tax Fund 303,045$ 89,327$ 213,718$ 2,235,820$ Collects and spends resources from the State motor fuel tax. Infrastructure Fund (Major Fund)5,604,327$ 1,365,162$ 4,239,164$ 18,663,672$ Accounts for construction and maintenance of roadways, drainage, and safety path systems. Enterprise Funds Water Fund (Major Fund)7,297,987$ 7,431,976$ (133,988)$ 21,784,654$ Collects user fees for the distribution of water and maintenance of infrastructure. Sports Core Fund (Major Fund)3,877,673$ 3,614,677$ 262,996$ 3,166,884$ Accounts for revenues and expenses relating to administration, programs, food and beverage operations, and golf course. Internal Service Funds Insurance Fund 1,937,682$ 2,280,717$ (343,035)$ 222,409$ Accounts for the Village's health insurance costs and the related contributions from the Village, employees, retirees, and other agencies. Garage Fund 436,800$ 515,525$ (78,725)$ 267,750$ Accounts for the maintenance of the Village's vehicle fleet and the related departmental reimbursements. Equipment Replacement Fund 827,083$ 661,706$ 165,377$ 3,213,334$ 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 August 31, 2024 8/31/24 8/31/24 8/31/23 8/31/24 YTD % of YTD 2024 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax 11,602,516$ 11,613,028 10,997,736$ 105.6%16,496,604$ 10,512$ State Income Tax 919,125 999,165 874,000 114.3%1,311,000 80,041 Replacement Tax 701,174 420,168 500,677 83.9%751,015 (281,006) Road & Bridge Tax 16,950 21,914 23,333 93.9%35,000 4,965 Local Use Tax 227,534 209,950 224,000 93.7%336,000 (17,584) Cannabis Use Tax 8,373 8,958 8,787 101.9%13,180 584 Grants 580,607 167,030 110,442 151.2%165,662 (413,577) Utility/Telecom. Tax 3,380,917 2,083,590 3,066,667 67.9%4,600,000 (1,297,328) Licenses and Permits 3,341,870 1,634,461 1,498,540 109.1%2,247,810 (1,707,409) Charges for Services 2,313,647 2,900,622 1,449,767 200.1%2,174,650 586,975 Investment Interest 700,357 1,220,666 300,000 406.9%450,000 520,309 Miscellaneous Income 838,697 590,799 610,713 96.7%916,070 (247,898) Total Operating Revenues 24,631,768$ 21,870,351$ 19,664,661$ 111.2%29,496,991$ (2,761,417)$ OPERATING EXPENDITURES Personnel 13,117,917$ 13,926,300$ 15,043,476$ 92.6%22,565,214$ 808,383$ Materials and Supplies 373,296 381,025 441,063 86.4%661,594 7,729$ Operation and Contract 3,321,589 4,109,041 4,216,209 97.5%6,324,313 787,452$ Other Expenditures 6,394 6,356 6,600 96.3%9,900 (38)$ Capital Outlay 636,190 284,174 442,071 64.3%663,107 (352,016)$ Total Operating Expenditures 17,455,387$ 18,706,896$ 20,149,419$ 92.8%30,224,129$ 1,251,510$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 7,176,381$ 3,163,454$ (484,758)$ -652.6%(727,137)$ (4,012,927)$ INTERFUND TRANSACTIONS Transfers In -$ -$ -$ N/A -$ -$ Transfers Out N/A - Reimbursements From Other Funds 521,143 583,960 583,959 100.0%875,938 62,817 Reimbursements To Other Funds - - 66,667 0.0%100,000 - Sports Core Loan N/A - - Total Interfund Transactions 521,143$ 583,960$ 650,625$ 89.8%975,938$ 62,817$ NET FUND INCREASE (DECREASE)7,697,524$ 3,747,414$ 165,867$ 248,801$ (3,950,110)$ Village of Oak Brook General Fund Financial Update For the Period Ending August 31, 2024 8/31/24 8/31/24 8/31/23 8/31/24 YTD % of YTD 2024 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Hotel Tax 972,196$ 1,055,974$ 966,667$ 109.2%1,450,000$ 83,778$ Investment Interest 54,000 124,560 16,667 747.4%25,000 70,560 Loan Interest 2,000 1,000 1,333 75.0%2,000 (1,000) Miscellaneous - - - - Total Operating Revenues 1,028,196$ 1,181,534$ 984,667$ 120.0%1,477,000$ 153,338$ EXPENDITURES Personnel -$ 20,227$ 14,928$ 135.5%-$ 20,227$ Operation and Contract 182,212 (5,084) 470,030 -1.1%705,045 (187,296) Capital Outlay - 3,770 183,333 2.1%275,000 3,770 Total Expenditures 182,212$ 18,912$ 668,291$ 2.8%980,045$ (163,300)$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 845,984$ 1,162,622$ 331,303$ 350.9%496,955$ 316,638$ INTERFUND TRANSACTIONS Transfer Out -$ -$ -$ N/A -$ -$ Reimbursements to Other Funds (232,991) (162,608) (162,610) 100.0%(243,915) 70,383 Total Interfund Transactions (232,991)$ (162,608)$ (162,610)$ 100.0%(243,915)$ 70,383$ NET FUND INCREASE (DECREASE)612,993$ 1,000,014$ 168,693$ 253,040$ 387,021$ Note - Expenditures are recorded in program 171. Village of Oak Brook Hotel Tax Fund Financial Update For the Period Ending August 31, 2024 8/31/24 8/31/24 8/31/23 8/31/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 4,914,922$ 5,044,843$ 4,468,667$ 112.9%6,703,000$ 129,921$ Charges for Services - - N/A -$ Investment Interest 173,142 557,089 83,333 668.5%125,000 383,947 Grants - - - N/A - - Miscellaneous 2,100 2,395 15,333 15.6%23,000 295 Total Operating Revenues 5,090,164$ 5,604,327$ 4,567,333$ 122.7%6,851,000$ 514,163$ OPERATING EXPENDITURES Personnel 13,839$ 135,367$ -$ N/A -$ 121,528$ Materials and Supplies 155,414 21,269 31,000 68.6%46,500 (134,144) Operation and Contract 575,211 780,917 1,161,979 67.2%1,742,968 205,706 Other Expenditures - - 226,599 0.0%339,899 - Capital Outlay 1,323,969 406,272 2,255,850 18.0%3,383,775 (917,697) Total Operating Expenditures 2,068,433$ 1,343,826$ 3,675,428$ 36.6%5,513,142$ (724,606)$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 3,021,731$ 4,260,500$ 891,905$ 477.7%1,337,858$ 1,238,770$ INTERFUND TRANSACTIONS Transfers In -$ -$ -$ N/A -$ -$ Reimbursements From Other Funds 145,040 - - N/A - (145,040) Reimbursements To Other Funds (226,600) (21,336) - N/A - 205,264 Total Interfund Transactions (81,560)$ (21,336)$ -$ N/A -$ 60,224$ NET FUND INCREASE (DECREASE)2,940,171$ 4,239,164$ 891,905$ 1,337,858$ 1,298,993$ Village of Oak Brook Infrastructure Fund Financial Update For the Period Ending August 31, 2024 8/31/24 8/31/24 8/31/23 8/31/24 YTD % of YTD 2024 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Plan Review Fees 1,500$ 1,202$ 350$ 343.4%525$ (298)$ Building/Inspection Fees 1,350 - 1,333 0.0%2,000 (1,350) Water Sales 5,897,566 6,178,967 7,146,667 86.5%10,720,000 281,400 Unmetered Sales 35,959 37,481 43,333 86.5%65,000 1,523 Water Connection Fees 135,700 60,720 93,333 65.1%140,000 (74,980) Fire Service Charge - - - N/A - - Meter Charges 15,572 10,790 11,533 93.6%17,300 (4,782) Special Services 25,741 15,054 6,667 225.8%10,000 (10,687) Investment Interest 599,552 911,194 233,333 390.5%350,000 311,642 Proceeds from Property Sale - - - N/A - - Miscellaneous 79,025 82,579 766,487 10.8%1,149,730 3,554 Total Operating Revenues 6,791,966$ 7,297,987$ 8,303,037$ 87.9%12,454,555$ 506,022$ OPERATING EXPENDITURES Personnel 448,248$ 407,790$ 524,275$ 77.8%786,413$ (40,458)$ Materials and Supplies 70,278 73,488 91,478 80.3%137,216 3,211 Operation and Contract 3,381,183 3,747,358 4,734,246 79.2%7,101,369 366,175 Capital Outlay 1,170,961 2,912,083 3,793,333 76.8%5,690,000 1,741,123 Total Expenditures 5,070,669$ 7,140,720$ 9,143,333$ 78.1%13,714,999$ 2,070,050$ Surplus (Deficit) of Revenues Over Expenditures 1,721,297$ 157,268$ (840,296)$ -18.7%(1,260,444)$ (1,564,029)$ INTERFUND TRANSACTIONS Reimbursements To Other Funds (124,398)$ (291,256)$ (291,253)$ 100.0%(436,879)$ (166,858)$ Total Interfund Transactions (124,398)$ (291,256)$ (291,253)$ 100.0%(436,879)$ (166,858)$ Fund Increase/(Decrease) - Budgetary Basis 1,596,898$ (133,988)$ (1,131,549)$ (1,697,323)$ (1,730,887)$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay 1,170,961$ 2,912,083$ Depreciation Expense (191,667) (383,333) IMRF Pension Expense (15,000) (30,000) OPEB Expense (10,000) (20,000) Total GAAP Adjustments 954,294$ 2,478,750$ Fund Increase/(Decrease) - GAAP Basis 2,551,192$ 2,344,762$ *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 August 31, 2024 Village of Oak Brook Monthly Operating Statement Sports Core Fund Consolidated Presentation For the Period Ending August 31, 2024 8/31/24 8/31/24 8/31/24 YTD % of YTD 2024 8/31/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 430,793$ -$ -$ 393,375$ 824,168$ 633,817$ 130.0%950,725$ 887,047$ (62,880)$ Greens Fees - - - 1,282,143 1,282,143 936,667 136.9%1,405,000 1,092,800 189,343 Golf Surcharge - - - 167,754 167,754 53,143 315.7%53,143 89,378 78,376 Pro Shop Sales - - - 123,108 123,108 145,333 84.7%218,000 155,894 (32,786) Golf Lessons - - - 35,420 35,420 30,000 118.1%45,000 24,052 11,368 Driving Range Fees - - - 437,004 437,004 260,000 168.1%390,000 360,520 76,484 Rentals - 110,055 84,925 499,889 694,869 665,467 104.4%998,200 616,232 78,637 Programs/User Fees 130,964 - - - 130,964 73,200 178.9%109,800 94,099 36,865 Food Sales 6,616 - - 49,414 56,030 31,933 175.5%47,900 262,113 (206,083) Beverage Sales - - - - - 51,767 0.0%77,650 391,311 (391,311) Taste of Oak Brook - - - - - - N/A - - - Grants - - - - - - N/A - - - Other Revenue 97,106 - - 2,436 99,542 66,106 150.6%99,160 30,183 69,359 Total Operating Revenues 665,478$ 110,055$ 84,925$ 2,990,543$ 3,851,001$ 2,947,433$ 130.7%4,394,578$ 4,003,629$ (152,627)$ OPERATING EXPENDITURES Personnel 47,057$ -$ -$ 900,569$ 947,626$ 929,986$ 101.9%1,671,380$ 983,911$ (36,285)$ Materials & Supplies 33,769 - 7,330 233,582 274,681 288,835 95.1%718,900 522,437 (247,756) Operational & Contractual 517,947 30,773 34,752 297,540 881,013 722,829 121.9%942,765 694,118 186,895 Other - - - - - - N/A - - - Capital 547,088 - - 828,838 1,375,925 717,503 191.8%466,750 111,412 1,264,513 Total Operating Expenditures 1,145,859$ 30,773$ 42,083$ 2,260,530$ 3,479,245$ 2,659,154$ 130.8%3,799,795$ 2,311,878$ 1,167,367$ B&T Administration Overhead Allocation*24,971$ -$ (8,333)$ (16,638)$ -$ (16,638)$ N/A (24,957) -$ (24,957)$ Operating Revenues Over (Under) Expenditures (455,410)$ 79,282$ 34,509$ 713,375$ 371,756$ 271,641$ 136.9%569,826$ 1,691,751$ (1,344,951)$ INTERFUND TRANSACTIONS Interfund Loan**-$ -$ -$ -$ -$ -$ N/A -$ -$ -$ Transfer From General Fund - - - - - - N/A - - - Reimbursement From Infrastructure Fund - - - - - - N/A - - - Reimbursement From Water Fund 26,672 - - - 26,672 26,667 100.0%40,000 - 26,672 Reimbursement To General Fund (33,856) - - (101,576) (135,432) (115,067) 117.7%(172,600) (53,977) (81,455) Total Interfund Transactions (7,184)$ -$ -$ (101,576)$ (108,760)$ (88,400)$ 123.0%(132,600)$ (53,977)$ (54,783)$ Total Revenues Over (Under) Expenditures - Budgetary Basis (462,594)$ 79,282$ 34,509$ 611,799$ 262,996$ 183,241$ 437,226$ 1,637,774$ (1,399,735)$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay 547,088$ -$ -$ 828,838$ 1,375,925$ 111,412$ Depreciation Expense (112,151) (1,123) (25,000) (164,200) (302,475) (302,474) IMRF Pension Expense (1,367) - (1,250) (16,333) (18,950) (18,950) OPEB Expense - - (1,250) (18,667) (19,917) (19,917) Total GAAP Adjustments 433,570$ (1,123)$ (27,500)$ 629,638$ 1,034,584$ (229,929)$ Fund Increase/(Decrease) - GAAP Basis (29,025)$ 78,159$ 7,009$ 1,241,437$ 1,297,580$ 1,407,845$ *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 August 31, 2024 8/31/24 8/31/24 822 8/31/24 YTD % of YTD 2024 8/31/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,130$ -$ 430,793$ 295,183$ 145.9%442,775$ 406,947$ 23,846$ Programs/User Fees - 79,792 51,172 - 130,964 73,200.00 178.9%109,800 94,099 36,865 Food Sales - - - 6,616 6,616 4,000.00 165.4%6,000 50,253 - Beverage Sales - - - - - 1,600.00 0.0%2,400 17,585 - Grants - - - - - - N/A - - - Other Revenue 88,506 - 2,350 6,250 97,106 60,106 161.6%90,160 2,175 94,931 Total Operating Revenues 88,506$ 481,454$ 82,652$ 12,866$ 665,478$ 434,090$ 153.3%651,135$ 571,059$ 155,641$ OPERATING EXPENDITURES Personnel -$ 47,057$ -$ -$ 47,057$ 167,925$ 28.0%251,888$ 57,227$ (10,170)$ Materials & Supplies 21 20,152 11,931 1,665 33,769 30,253 111.6%45,380 55,557 (21,788) Operational & Contractual 162,917 278,012 76,255 763 517,947 382,023 135.6%573,034 358,838 159,109 Other - - - - - - N/A - - - Capital 462,131 84,957 - - 547,088 583,000 93.8%874,500 - 547,088 Total Operating Expenditures 625,068$ 430,177$ 88,186$ 2,428$ 1,145,859$ 1,163,201$ 98.5%1,744,801$ 471,622$ 674,237$ B&T Administration Overhead Allocation*69,667$ (27,412)$ (7,617)$ (9,667)$ 24,971$ -$ N/A 37,457$ -$ 24,971$ Operating Revenues Over (Under) Expenditures (466,895)$ 23,865$ (13,151)$ 771$ (455,410)$ (729,111)$ 62.5%(1,056,210)$ 99,437$ (493,625)$ Transfer From General Fund -$ -$ -$ -$ -$ -$ N/A - - Reimbursement From Infrastructure Fund - - - - - - N/A - - - Reimbursement From Water Fund 26,672 - - - 26,672 26,667 100.0%40,000 - 26,672 Reimbursement To General Fund (33,856) - - - (33,856) (13,495) 250.9%(20,242) (33,735) (121) Total Interfund Transactions (7,184)$ -$ -$ -$ (7,184)$ 13,172$ -54.5%19,758$ (33,735)$ 26,551$ Total Revenues Over (Under) Expenditures - Budgetary Basis (474,079)$ 23,865$ (13,151)$ 771$ (462,594)$ (715,939)$ (1,036,452)$ 65,702$ (467,074)$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay 462,131$ 84,957$ -$ -$ 547,088$ -$ Depreciation Expense (42,906) (66,667) (1,800) (779) (112,151) (112,151) IMRF Pension Expense (1,333) - - (33) (1,367) (1,367) Total GAAP Adjustments 417,892$ 18,290$ (1,800)$ (812)$ 433,570$ (113,518)$ Fund Increase/(Decrease) - GAAP Basis (56,188)$ 42,155$ (14,951)$ (41)$ (29,025)$ (47,816)$ *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 August 31, 2024 8/31/24 8/31/24 8/31/24 YTD % of YTD 2024 8/31/23 Difference 815 816 YTD Amended Amended Adopted YTD Prior Polo Open Fields Total Budget Budget Budget Total Year OPERATING REVENUES Field Rentals -$ 110,055$ 110,055 128,667$ 85.5%193,000$ 107,000$ 3,055$ Range Rentals - - - - N/A - 86,080 (86,080) Taste of Oak Brook - - - - N/A - - - Other Revenue - - - - N/A - - - Total Operating Revenues -$ 110,055$ 110,055$ 128,667$ 85.5%193,000$ 193,080$ (83,025)$ OPERATING EXPENDITURES Personnel -$ -$ -$ -$ N/A -$ -$ Materials & Supplies - - - 6,327 0.0%9,490$ 1,064 (1,064) Operational & Contractual - 30,773 30,773 50,700 60.7%76,050 30,150 623 Other - - - - N/A - - - Capital - - - 30,667 0.0%46,000 - - Total Operating Expenditures -$ 30,773$ 30,773$ 87,693$ 35.1%131,540$ 31,214$ (441)$ Operating Revenues Over (Under) Expenditures -$ 79,282$ 79,282$ 40,973$ 193.5%61,460$ 161,866$ (82,584)$ INTERFUND TRANSACTIONS Transfer From Hotel Tax Fund -$ -$ -$ -$ N/A -$ -$ -$ Total Interfund Transactions -$ -$ -$ -$ N/A -$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis -$ 79,282$ 79,282$ 40,973$ 61,460$ 161,866$ (82,584)$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ -$ -$ -$ Depreciation Expense - (1,123) (1,123) (1,123) Total GAAP Adjustments -$ (1,123)$ (1,123)$ (1,123)$ Fund Increase/(Decrease) - GAAP Basis -$ 78,159$ 78,159$ 160,743$ *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 August 31, 2024 8/31/24 8/31/24 821 YTD % of YTD 2024 8/31/23 Difference B&T Amended Amended Adopted YTD Prior Clubhouse Budget Budget Budget Total Year OPERATING REVENUES Rentals 84,925$ 155,333$ 54.7%233,000$ 60,524$ 24,401$ Other Revenue - - 0.0%- - - Total Operating Revenues 84,925$ 155,333$ 54.7%233,000$ 60,524$ 24,401$ OPERATING EXPENDITURES Personnel -$ -$ N/A -$ 6,172$ (6,172)$ Materials & Supplies 7,330 9,167 80.0%13,750 7,144 186 Operational & Contractual 34,752 35,319 98.4%52,978 49,010 (14,258) Capital - - N/A - - - Total Operating Expenditures 42,083$ 44,485$ 94.6%66,728$ 62,326$ (20,243)$ B&T Administration Overhead Allocation*(8,333)$ -$ N/A (12,500)$ -$ (8,333)$ Operating Revenues Over (Under) Expenditures 34,509$ 110,848$ 31.1%153,772$ (1,802)$ 36,311$ INTERFUND TRANSACTIONS Transfer From General Fund -$ -$ 0.0%-$ -$ -$ Total Interfund Transactions -$ -$ 0.0%-$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis 34,509$ 110,848$ 153,772$ (1,802)$ 36,311$ 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 7,009$ (29,302)$ *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 August 31, 2024 8/31/24 8/31/24 823 831 832 833 834 8/31/24 YTD % of YTD 2024 8/31/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$ 338,633$ 116.2%507,950$ 480,100$ (86,725)$ Greens Fees - 1,282,143 - - - 1,282,143 936,667 136.9%1,405,000 1,092,800 189,343 Surcharge - 167,754 167,754 53,143 315.7%53,143 89,378 78,376 Pro Shop Sales - 123,108 - - - 123,108 145,333 84.7%218,000 155,894 (32,786) Golf Lessons - - 35,420 - - 35,420 30,000 118.1%45,000 24,052 11,368 Driving Range Fees - - 437,004 - - 437,004 260,000 168.1%390,000 360,520 76,484 Rentals 18,250 - 50,008 431,631 - 499,889 381,467 131.0%572,200 362,628 137,261 Food Sales 49,414 - - - - 49,414 27,933 176.9%41,900 211,860 (162,446) Beverage Sales - - - - - - 50,167 0.0%75,250 373,726 (373,726) Other Revenue - 2,436 - - - 2,436 6,000 40.6%9,000 28,008 (25,572) Total Operating Revenues 67,664$ 1,968,816$ 522,432$ 431,631$ -$ 2,990,543$ 2,229,343$ 134.1%3,317,443$ 3,178,966$ (188,422)$ OPERATING EXPENDITURES Personnel 5,184$ 459,387$ 54,803$ 56,364$ 324,831$ 900,569$ 762,061$ 118.2%1,143,092$ 920,512$ (19,943)$ Materials & Supplies (15) 93,237 7,704 915 131,741 233,582 243,089 96.1%364,633 458,672 (225,090) Operational & Contractual 4,051 176,677 41,173 32,158 43,482 297,540 254,787 116.8%382,181 256,120 41,420 Other - - - - - N/A - - - Capital - 19,955 - 671,600 137,283 828,838 103,837 798.2%155,755 111,412 717,426 Total Operating Expenditures 9,220$ 749,255$ 103,680$ 761,037$ 637,337$ 2,260,530$ 1,363,774$ 165.8%2,045,661$ 1,746,716$ 513,814$ Operating Revenues Over (Under) Expenditures 58,444$ 1,219,561$ 418,752$ (329,406)$ (637,337)$ 730,013$ 865,569$ 84.3%1,271,782$ 1,432,250$ (702,236)$ INTERFUND TRANSACTIONS Overhead Charge -$ (16,638)$ -$ -$ -$ (16,638)$ (16,638)$ 100.0%(24,957)$ -$ (16,638)$ Transfers from Other Fund - - - - - - - 0.0%150,000 - - Reimbursement to General Fund - (101,576) - - - (101,576) (101,572) 100.0%(152,358) (20,242) (81,334) Total Interfund Transactions -$ (118,214)$ -$ -$ -$ (118,214)$ (118,210)$ 100.0%(27,315)$ (20,242)$ (97,972)$ Total Revenues Over (Under) Expenditures - Budgetary Basis 58,444$ 1,101,347$ 418,752$ (329,406)$ (637,337)$ 611,799$ 747,359$ 1,244,467$ 1,412,008$ (800,209)$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay -$ 19,955$ -$ 671,600$ 137,283$ 828,838$ 111,412$ Depreciation Expense (667) (70,000) (1,533) (8,667) (83,333) (164,200) (164,200) IMRF Pension Expense (1,667) (6,667) (667) - (7,333) (16,333) (16,333) OPEB Expense (2,000) (10,000) - - (6,667) (18,667) (18,667) Total GAAP Adjustments (4,333)$ (66,712)$ (2,200)$ 662,933$ 39,950$ 629,638$ (87,788)$ Fund Increase/(Decrease) - GAAP Basis 54,110$ 1,034,634$ 416,552$ 333,528$ (597,388)$ 1,241,437$ 1,324,220$ *Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.