The URL can be used to link to this page

Home My WebLink About10 - October 2024 Monthly Financial ReportVILLAGE OAK BROOKOF MONTHLY FINANCIAL REPORTS OCTOBER 2024 Estimated YTD YTD Net Fund Ending YTD YTD Increase Fund Balance Governmental Funds Revenues Expenditures (Decrease)(Deficit) General Fund (Major Fund)27,414,867$ 23,366,163$ 4,048,704$ 46,674,093$ Main operating fund of the Village. Hotel Fund (Major Fund)1,539,693$ 246,388$ 1,293,305$ 5,064,502$ Collects and spends resources from the 3% hotel/motel tax. Motor Fuel Tax Fund 348,575$ 89,327$ 259,248$ 2,281,350$ Collects and spends resources from the State motor fuel tax. Infrastructure Fund (Major Fund)7,027,264$ 1,507,480$ 5,519,784$ 19,944,291$ Accounts for construction and maintenance of roadways, drainage, and safety path systems. Enterprise Funds Water Fund (Major Fund)11,121,535$ 9,241,181$ 1,880,355$ 23,798,997$ Collects user fees for the distribution of water and maintenance of infrastructure. Sports Core Fund (Major Fund)4,786,480$ 4,248,091$ 538,389$ 3,442,277$ Accounts for revenues and expenses relating to administration, programs, food and beverage operations, and golf course. Internal Service Funds Insurance Fund 2,418,745$ 2,541,936$ (123,191)$ 442,252$ Accounts for the Village's health insurance costs and the related contributions from the Village, employees, retirees, and other agencies. Garage Fund 438,517$ 475,556$ (37,038)$ 309,436$ Accounts for the maintenance of the Village's vehicle fleet and the related departmental reimbursements. Equipment Replacement Fund 832,750$ 739,569$ 93,181$ 3,141,138$ 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 October 31, 2024 10/31/24 10/31/24 10/31/23 10/31/24 YTD % of YTD 2024 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax 14,657,709$ 14,732,334 13,747,170$ 107.2%16,496,604$ 74,624$ State Income Tax 1,133,763 1,223,171 1,092,500 112.0%1,311,000 89,408 Replacement Tax 833,637 420,168 625,846 67.1%751,015 (413,470) Road & Bridge Tax 28,005 21,914 29,167 75.1%35,000 (6,090) Local Use Tax 272,210 256,389 280,000 91.6%336,000 (15,820) Cannabis Use Tax 10,345 11,005 10,983 100.2%13,180 660 Grants 596,068 168,440 138,052 122.0%165,662 (427,628) Utility/Telecom. Tax 4,130,308 2,637,210 3,833,333 68.8%4,600,000 (1,493,098) Licenses and Permits 3,620,581 1,833,940 1,873,175 97.9%2,247,810 (1,786,641) Charges for Services 3,086,751 3,180,948 1,812,208 175.5%2,174,650 94,197 Investment Interest 944,252 1,428,222 375,000 380.9%450,000 483,970 Miscellaneous Income 889,362 771,177 763,392 101.0%916,070 (118,185) Total Operating Revenues 30,202,989$ 26,684,917$ 24,580,826$ 108.6%29,496,991$ (3,518,072)$ OPERATING EXPENDITURES Personnel 16,640,852$ 18,187,407$ 18,804,345$ 96.7%22,565,214$ 1,546,555$ Materials and Supplies 471,991 452,286 551,329 82.0%661,594 (19,705)$ Operation and Contract 4,094,299 4,447,248 5,270,261 84.4%6,324,313 352,950$ Other Expenditures 8,517 8,473 8,250 102.7%9,900 (45)$ Capital Outlay 769,501 270,749 552,589 49.0%663,107 (498,752)$ Total Operating Expenditures 21,985,160$ 23,366,163$ 25,186,774$ 92.8%30,224,129$ 1,381,004$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 8,217,830$ 3,318,754$ (605,948)$ -547.7%(727,137)$ (4,899,076)$ INTERFUND TRANSACTIONS Transfers In -$ -$ -$ N/A -$ -$ Transfers Out 1,500,000 N/A (1,500,000) Reimbursements From Other Funds 651,429 729,950 729,948 100.0%875,938 78,521 Reimbursements To Other Funds - - 83,333 0.0%100,000 - Sports Core Loan N/A - - Total Interfund Transactions 2,151,429$ 729,950$ 813,282$ 89.8%975,938$ (1,421,479)$ NET FUND INCREASE (DECREASE)10,369,259$ 4,048,704$ 207,334$ 248,801$ (6,320,555)$ Village of Oak Brook General Fund Financial Update For the Period Ending October 31, 2024 10/31/24 10/31/24 10/31/23 10/31/24 YTD % of YTD 2024 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Hotel Tax 1,348,981$ 1,389,705$ 1,208,333$ 115.0%1,450,000$ 40,724$ Investment Interest 74,043 148,988 20,833 715.1%25,000 74,946 Loan Interest 2,000 1,000 1,667 60.0%2,000 (1,000) Miscellaneous - - - - Total Operating Revenues 1,425,024$ 1,539,693$ 1,230,833$ 125.1%1,477,000$ 114,669$ EXPENDITURES Personnel -$ 44,967$ 14,928$ 301.2%-$ 44,967$ Operation and Contract 303,304 (7,163) 587,538 -1.2%705,045 (310,467) Capital Outlay - 5,324 229,167 2.3%275,000 5,324 Total Expenditures 303,304$ 43,128$ 831,632$ 5.2%980,045$ (260,176)$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 1,121,720$ 1,496,565$ 414,129$ 361.4%496,955$ 374,845$ INTERFUND TRANSACTIONS Transfer Out -$ -$ -$ N/A -$ -$ Reimbursements to Other Funds (291,239) (203,260) (203,263) 100.0%(243,915) 87,979 Total Interfund Transactions (291,239)$ (203,260)$ (203,263)$ 100.0%(243,915)$ 87,979$ NET FUND INCREASE (DECREASE)830,481$ 1,293,305$ 210,867$ 253,040$ 462,824$ Note - Expenditures are recorded in program 171. Village of Oak Brook Hotel Tax Fund Financial Update For the Period Ending October 31, 2024 10/31/24 10/31/24 10/31/23 10/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 6,246,560$ 6,362,440$ 5,585,833$ 113.9%6,703,000$ 115,880$ Charges for Services - - - N/A -$ Investment Interest 246,644 660,853 104,167 634.4%125,000 414,210 Grants - - - N/A - - Miscellaneous 2,100 3,970 19,167 20.7%23,000 1,870 Total Operating Revenues 6,495,304$ 7,027,264$ 5,709,167$ 123.1%6,851,000$ 531,960$ OPERATING EXPENDITURES Personnel 35,358$ 17,817$ -$ N/A -$ (17,540)$ Materials and Supplies 159,091 18,433 38,750 47.6%46,500 (140,658) Operation and Contract 727,916 957,706 1,452,473 65.9%1,742,968 229,790 Other Expenditures - - 283,249 0.0%339,899 - Capital Outlay 1,572,259 486,853 2,819,813 17.3%3,383,775 (1,085,406) Total Operating Expenditures 2,494,624$ 1,480,810$ 4,594,285$ 32.2%5,513,142$ (1,013,814)$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 4,000,680$ 5,546,454$ 1,114,882$ 497.5%1,337,858$ 1,545,774$ INTERFUND TRANSACTIONS Transfers In -$ -$ -$ N/A -$ -$ Reimbursements From Other Funds 163,170 - - N/A - (163,170) Reimbursements To Other Funds (283,250) (26,670) - N/A - 256,580 Total Interfund Transactions (120,080)$ (26,670)$ -$ N/A -$ 93,410$ NET FUND INCREASE (DECREASE)3,880,601$ 5,519,784$ 1,114,882$ 1,337,858$ 1,639,183$ Village of Oak Brook Infrastructure Fund Financial Update For the Period Ending October 31, 2024 10/31/24 10/31/24 10/31/23 10/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,650$ 1,352$ 438$ 309.0%525$ (298)$ Building/Inspection Fees 1,350 - 1,667 0.0%2,000 (1,350) Water Sales 8,198,599 8,705,658 8,933,333 97.5%10,720,000 507,059 Unmetered Sales 39,136 57,105 54,167 105.4%65,000 17,969 Water Connection Fees 140,530 65,090 116,667 55.8%140,000 (75,440) Fire Service Charge - - - N/A - - Meter Charges 16,449 11,720 14,417 81.3%17,300 (4,729) Special Services 25,741 15,054 8,333 180.6%10,000 (10,687) Investment Interest 794,135 1,063,735 291,667 364.7%350,000 269,600 Grants - 1,090,855 - N/A - 1,090,855 Miscellaneous 99,939 110,967 958,108 11.6%1,149,730 11,029 Total Operating Revenues 9,317,529$ 11,121,535$ 10,378,796$ 107.2%12,454,555$ 1,804,007$ OPERATING EXPENDITURES Personnel 559,198$ 505,496$ 655,344$ 77.1%786,413$ (53,702)$ Materials and Supplies 92,899 78,385 114,347 68.6%137,216 (14,514) Operation and Contract 4,604,170 5,087,567 5,917,808 86.0%7,101,369 483,397 Capital Outlay 1,170,961 3,205,663 4,741,667 67.6%5,690,000 2,034,702 Total Expenditures 6,427,228$ 8,877,111$ 11,429,166$ 77.7%13,714,999$ 2,449,883$ Surplus (Deficit) of Revenues Over Expenditures 2,890,301$ 2,244,425$ (1,050,370)$ -213.7%(1,260,444)$ (645,877)$ INTERFUND TRANSACTIONS Reimbursements To Other Funds (155,498)$ (364,070)$ (364,066)$ 100.0%(436,879)$ (208,572)$ Total Interfund Transactions (155,498)$ (364,070)$ (364,066)$ 100.0%(436,879)$ (208,572)$ Fund Increase/(Decrease) - Budgetary Basis 2,734,803$ 1,880,355$ (1,414,436)$ (1,697,323)$ (854,448)$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay 1,170,961$ 3,205,663$ Depreciation Expense (191,667) (479,167) IMRF Pension Expense (15,000) (37,500) OPEB Expense (10,000) (25,000) Total GAAP Adjustments 954,294$ 2,663,996$ Fund Increase/(Decrease) - GAAP Basis 3,689,097$ 4,544,350$ *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 October 31, 2024 Village of Oak Brook Monthly Operating Statement Sports Core Fund Consolidated Presentation For the Period Ending October 31, 2024 10/31/24 10/31/24 10/31/24 YTD % of YTD 2024 10/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 431,243$ -$ -$ 393,375$ 824,618$ 792,271$ 104.1%950,725$ 887,047$ (62,430)$ Greens Fees - - - 1,699,612 1,699,612 1,170,833 145.2%1,405,000 1,414,566 285,046 Golf Surcharge - - - 226,150 226,150 53,143 425.6%53,143 94,127 132,024 Pro Shop Sales - - - 161,373 161,373 181,667 88.8%218,000 182,923 (21,550) Golf Lessons - - - 35,035 35,035 37,500 93.4%45,000 24,872 10,163 Driving Range Fees - - - 533,369 533,369 325,000 164.1%390,000 401,496 131,873 Rentals - 151,958 114,410 675,666 942,034 831,833 113.2%998,200 817,354 124,680 Programs/User Fees 137,727 - - - 137,727 91,500 150.5%109,800 104,649 33,078 Food Sales 8,587 - - 65,111 73,697 39,917 184.6%47,900 295,275 (221,578) Beverage Sales - - - 13,039 13,039 64,708 20.2%77,650 486,163 (473,124) Taste of Oak Brook - - - - - - N/A - - - Grants - - - - - - N/A - - - Other Revenue 98,552 - - 7,934 106,486 82,633 128.9%99,160 37,221 69,265 Total Operating Revenues 676,108$ 151,958$ 114,410$ 3,810,665$ 4,753,140$ 3,671,005$ 129.5%4,394,578$ 4,745,693$ 7,447$ OPERATING EXPENDITURES Personnel 207,544$ -$ -$ 1,046,032$ 1,253,576$ 1,162,483$ 107.8%1,671,380$ 1,266,780$ (13,204)$ Materials & Supplies 36,508 - 7,354 290,117 333,980 361,044 92.5%718,900 646,600 (312,620) Operational & Contractual 546,986 30,986 41,163 328,622 947,756 903,536 104.9%942,765 916,681 31,075 Other - - - - - - N/A - - - Capital 720,250 - - 823,239 1,543,489 896,879 172.1%466,750 182,198 1,361,291 Total Operating Expenditures 1,511,287$ 30,986$ 48,517$ 2,488,011$ 4,078,801$ 3,323,942$ 122.7%3,799,795$ 3,012,259$ 1,066,542$ B&T Administration Overhead Allocation*31,214$ -$ (10,417)$ (20,797)$ -$ (20,797)$ N/A (24,957) -$ (24,957)$ Operating Revenues Over (Under) Expenditures (803,965)$ 120,972$ 55,476$ 1,301,857$ 674,339$ 326,266$ 206.7%569,826$ 1,733,434$ (1,084,051)$ INTERFUND TRANSACTIONS Interfund Loan**-$ -$ -$ -$ -$ -$ N/A -$ -$ -$ Transfer From General Fund - - - - - - N/A - - - Reimbursement From Infrastructure Fund - - - - - - N/A - - - Reimbursement From Water Fund 33,340 - - - 33,340 33,333 100.0%40,000 - 33,340 Reimbursement To General Fund (42,320) - - (126,970) (169,290) (166,323) 101.8%(199,587) (67,471) (101,819) Total Interfund Transactions (8,980)$ -$ -$ (126,970)$ (135,950)$ (132,989)$ 102.2%(159,587)$ (67,471)$ (68,479)$ Total Revenues Over (Under) Expenditures - Budgetary Basis (812,945)$ 120,972$ 55,476$ 1,174,887$ 538,389$ 193,277$ 410,239$ 1,665,963$ (1,152,531)$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay 720,250$ -$ -$ 823,239$ 1,543,489$ 182,198$ Depreciation Expense (140,189) (1,404) (25,000) (205,250) (371,843) (371,843) IMRF Pension Expense (1,708) - (1,250) (20,417) (23,375) (23,375) OPEB Expense - - (1,250) (23,333) (24,583) (24,583) Total GAAP Adjustments 578,352$ (1,404)$ (27,500)$ 574,239$ 1,123,687$ (237,604)$ Fund Increase/(Decrease) - GAAP Basis (234,593)$ 119,567$ 27,976$ 1,749,126$ 1,662,076$ 1,428,359$ *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 October 31, 2024 10/31/24 10/31/24 822 10/31/24 YTD % of YTD 2024 10/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,580$ -$ 431,243$ 368,979$ 116.9%442,775$ 406,947$ 24,296$ Programs/User Fees - 79,942 57,785 - 137,727 91,500.00 150.5%109,800 104,649 33,078 Food Sales - - - 8,587 8,587 5,000.00 171.7%6,000 53,070 - Beverage Sales - - - - - 2,000.00 0.0%2,400 18,909 - Grants - - - - - - N/A - - - Other Revenue 89,202 - 2,350 7,000 98,552 75,133 131.2%90,160 3,175 95,377 Total Operating Revenues 89,202$ 481,604$ 89,715$ 15,587$ 676,108$ 542,612$ 124.6%651,135$ 586,750$ 152,750$ OPERATING EXPENDITURES Personnel 157,774$ 49,769$ -$ -$ 207,544$ 209,906$ 98.9%251,888$ 62,893$ 144,651$ Materials & Supplies 21 21,478 13,344 1,665 36,508 37,817 96.5%45,380 55,694 (19,186) Operational & Contractual 167,802 287,517 90,905 763 546,986 477,528 114.5%573,034 469,400 77,586 Other - - - - - - N/A - - - Capital 635,293 84,957 - - 720,250 728,750 98.8%874,500 1,405 718,845 Total Operating Expenditures 960,890$ 443,721$ 104,249$ 2,428$ 1,511,287$ 1,454,001$ 103.9%1,744,801$ 589,392$ 921,895$ B&T Administration Overhead Allocation*87,083$ (34,265)$ (9,521)$ (12,083)$ 31,214$ -$ N/A 37,457$ 36,486$ (5,272)$ Operating Revenues Over (Under) Expenditures (784,604)$ 3,618$ (24,055)$ 1,076$ (803,965)$ (911,389)$ 88.2%(1,056,210)$ 33,844$ (774,417)$ Transfer From General Fund -$ -$ -$ -$ -$ -$ N/A - - Reimbursement From Infrastructure Fund - - - - - - N/A - - - Reimbursement From Water Fund 33,340 - - - 33,340 33,333 100.0%40,000 - 33,340 Reimbursement To General Fund (42,320) - - - (42,320) (39,358) 107.5%(47,229) (47,229) 4,909 Total Interfund Transactions (8,980)$ -$ -$ -$ (8,980)$ (6,024)$ 149.1%(7,229)$ (47,229)$ 38,249$ Total Revenues Over (Under) Expenditures - Budgetary Basis (793,584)$ 3,618$ (24,055)$ 1,076$ (812,945)$ (917,413)$ (1,063,439)$ (13,385)$ (736,168)$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay 635,293$ 84,957$ -$ -$ 720,250$ 1,405$ Depreciation Expense (53,633) (83,333) (2,250) (973) (140,189) (140,189) IMRF Pension Expense (1,667) - - (42) (1,708) (1,708) Total GAAP Adjustments 579,994$ 1,623$ (2,250)$ (1,015)$ 578,352$ (140,493)$ Fund Increase/(Decrease) - GAAP Basis (213,590)$ 5,241$ (26,305)$ 61$ (234,593)$ (153,878)$ *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 October 31, 2024 10/31/24 10/31/24 10/31/24 YTD % of YTD 2024 10/31/23 Difference 815 816 YTD Amended Amended Adopted YTD Prior Polo Open Fields Total Budget Budget Budget Total Year OPERATING REVENUES Field Rentals -$ 151,958$ 151,958 160,833$ 94.5%193,000$ 127,500$ 24,458$ Range Rentals - - - - N/A - 86,080 (86,080) Taste of Oak Brook - - - - N/A - - - Other Revenue - - - - N/A - - - Total Operating Revenues -$ 151,958$ 151,958$ 160,833$ 94.5%193,000$ 213,580$ (61,622)$ OPERATING EXPENDITURES Personnel -$ -$ -$ -$ N/A -$ -$ Materials & Supplies - - - 7,908 0.0%9,490$ 1,064 (1,064) Operational & Contractual - 30,986 30,986 63,375 48.9%76,050 39,876 (8,890) Other - - - - N/A - - - Capital - - - 38,333 0.0%46,000 - - Total Operating Expenditures -$ 30,986$ 30,986$ 109,617$ 28.3%131,540$ 40,940$ (9,954)$ Operating Revenues Over (Under) Expenditures -$ 120,972$ 120,972$ 51,217$ 236.2%61,460$ 172,640$ (51,668)$ INTERFUND TRANSACTIONS Transfer From Hotel Tax Fund -$ -$ -$ -$ N/A -$ -$ -$ Total Interfund Transactions -$ -$ -$ -$ N/A -$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis -$ 120,972$ 120,972$ 51,217$ 61,460$ 172,640$ (51,668)$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ -$ -$ -$ Depreciation Expense - (1,404) (1,404) (1,404) Total GAAP Adjustments -$ (1,404)$ (1,404)$ (1,404)$ Fund Increase/(Decrease) - GAAP Basis -$ 119,567$ 119,567$ 171,236$ *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 October 31, 2024 10/31/24 10/31/24 821 YTD % of YTD 2024 10/31/23 Difference B&T Amended Amended Adopted YTD Prior Clubhouse Budget Budget Budget Total Year OPERATING REVENUES Rentals 114,410$ 194,167$ 58.9%233,000$ 133,465$ (19,055)$ Other Revenue - - 0.0%- - - Total Operating Revenues 114,410$ 194,167$ 58.9%233,000$ 133,465$ (19,055)$ OPERATING EXPENDITURES Personnel -$ -$ N/A -$ 9,693$ (9,693)$ Materials & Supplies 7,354 11,458 64.2%13,750 10,264 (2,910) Operational & Contractual 41,163 44,148 93.2%52,978 64,364 (23,201) Capital - - N/A - - - Total Operating Expenditures 48,517$ 55,607$ 87.3%66,728$ 84,321$ (35,804)$ B&T Administration Overhead Allocation*(10,417)$ -$ N/A (12,500)$ (36,486)$ 26,069$ Operating Revenues Over (Under) Expenditures 55,476$ 138,560$ 40.0%153,772$ 12,658$ 42,818$ INTERFUND TRANSACTIONS Transfer From General Fund -$ -$ 0.0%-$ -$ -$ Total Interfund Transactions -$ -$ 0.0%-$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis 55,476$ 138,560$ 153,772$ 12,658$ 42,818$ 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 27,976$ (14,842)$ *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 October 31, 2024 10/31/24 10/31/24 823 831 832 833 834 10/31/24 YTD % of YTD 2024 10/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$ 423,292$ 92.9%507,950$ 480,100$ (86,725)$ Greens Fees - 1,699,612 - - - 1,699,612 1,170,833 145.2%1,405,000 1,414,566 285,046 Surcharge - 226,150 226,150 53,143 425.6%53,143 94,127 132,024 Pro Shop Sales - 161,373 - - - 161,373 181,667 88.8%218,000 182,923 (21,550) Golf Lessons - - 35,035 - - 35,035 37,500 93.4%45,000 24,872 10,163 Driving Range Fees - - 533,369 - - 533,369 325,000 164.1%390,000 401,496 131,873 Rentals 23,750 3,295 64,662 583,959 - 675,666 476,833 141.7%572,200 470,309 205,357 Food Sales 65,111 - - - - 65,111 34,917 186.5%41,900 242,205 (177,094) Beverage Sales 13,039 - - - - 13,039 62,708 20.8%75,250 467,254 (454,215) Other Revenue - 7,934 - - - 7,934 7,500 105.8%9,000 34,046 (26,112) Total Operating Revenues 101,900$ 2,491,740$ 633,066$ 583,959$ -$ 3,810,665$ 2,773,393$ 137.4%3,317,443$ 3,811,898$ (1,233)$ OPERATING EXPENDITURES Personnel 5,184$ 305,020$ 61,308$ 76,576$ 597,944$ 1,046,032$ 952,577$ 109.8%1,143,092$ 1,194,194$ (148,162)$ Materials & Supplies (874) 136,237 19,446 979 134,330 290,117 303,861 95.5%364,633 579,578 (289,461) Operational & Contractual 3,912 202,099 46,155 32,799 43,657 328,622 318,484 103.2%382,181 343,041 (14,419) Other - - - - - N/A - - - Capital - 19,955 - 671,600 131,684 823,239 129,796 634.3%155,755 180,793 642,446 Total Operating Expenditures 8,222$ 663,311$ 126,909$ 781,954$ 907,615$ 2,488,011$ 1,704,718$ 145.9%2,045,661$ 2,297,606$ 190,405$ Operating Revenues Over (Under) Expenditures 93,678$ 1,828,429$ 506,157$ (197,994)$ (907,615)$ 1,322,654$ 1,068,676$ 123.8%1,271,782$ 1,514,292$ (191,638)$ INTERFUND TRANSACTIONS Overhead Charge -$ (20,797)$ -$ -$ -$ (20,797)$ (20,797)$ 100.0%(24,957)$ -$ (20,797)$ Transfers from Other Fund - - - - - - - 0.0%150,000 - - Reimbursement to General Fund - (126,970) - - - (126,970) (126,965) 100.0%(152,358) (20,242) (106,728) Total Interfund Transactions -$ (147,767)$ -$ -$ -$ (147,767)$ (147,762)$ 100.0%(27,315)$ (20,242)$ (127,526)$ Total Revenues Over (Under) Expenditures - Budgetary Basis 93,678$ 1,680,662$ 506,157$ (197,994)$ (907,615)$ 1,174,887$ 920,913$ 1,244,467$ 1,494,050$ (319,163)$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay -$ 19,955$ -$ 671,600$ 131,684$ 823,239$ 180,793$ Depreciation Expense (833) (87,500) (1,917) (10,833) (104,167) (205,250) (205,250) IMRF Pension Expense (2,083) (8,333) (833) - (9,167) (20,417) (20,417) OPEB Expense (2,500) (12,500) - - (8,333) (23,333) (23,333) Total GAAP Adjustments (5,417)$ (88,379)$ (2,750)$ 660,767$ 10,018$ 574,239$ (68,207)$ Fund Increase/(Decrease) - GAAP Basis 88,261$ 1,592,283$ 503,407$ 462,772$ (897,597)$ 1,749,126$ 1,425,843$ *Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.