Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
05 - May 2024 Monthly Financial Report
VILLAGE OAK BROOKOF MONTHLY FINANCIAL REPORTS MAY 2024 Estimated YTD YTD Net Fund Ending YTD YTD Increase Fund Balance Governmental Funds Revenues Expenditures (Decrease)(Deficit) General Fund (Major Fund)13,266,519$ 11,868,568$ 1,397,951$ 44,023,340$ Main operating fund of the Village. Hotel Fund (Major Fund)686,890$ 164,175$ 522,715$ 4,293,913$ Collects and spends resources from the 3% hotel/motel tax. Motor Fuel Tax Fund 185,079$ 85,862$ 99,217$ 2,121,319$ Collects and spends resources from the State motor fuel tax. Infrastructure Fund (Major Fund)3,504,423$ 858,715$ 2,645,707$ 17,070,215$ Accounts for construction and maintenance of roadways, drainage, and safety path systems. Enterprise Funds Water Fund (Major Fund)3,934,791$ 3,342,501$ 592,290$ 22,510,933$ Collects user fees for the distribution of water and maintenance of infrastructure. Sports Core Fund (Major Fund)1,957,505$ 1,992,300$ (34,794)$ 2,869,094$ Accounts for revenues and expenses relating to administration, programs, food and beverage operations, and golf course. Internal Service Funds Insurance Fund 1,205,117$ 1,526,132$ (321,015)$ 244,429$ Accounts for the Village's health insurance costs and the related contributions from the Village, employees, retirees, and other agencies. Garage Fund 310,275$ 256,042$ 54,233$ 400,708$ Accounts for the maintenance of the Village's vehicle fleet and the related departmental reimbursements. Equipment Replacement Fund 586,056$ 511,863$ 74,193$ 3,122,150$ 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, 2024 5/31/24 5/31/24 5/31/23 5/31/24 YTD % of YTD 2024 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax 7,442,697$ 7,311,509 6,873,585$ 106.4%16,496,604$ (131,188)$ State Income Tax 623,750 678,329 546,250 124.2%1,311,000 54,579 Replacement Tax 510,455 196,566 312,923 62.8%751,015 (313,889) Road & Bridge Tax 2,682 15,434 14,583 105.8%35,000 12,752 Local Use Tax 148,004 133,946 140,000 95.7%336,000 (14,058) Cannabis Use Tax 5,230 5,725 5,492 104.2%13,180 495 Grants 1,109 154,300 69,026 223.5%165,662 153,191 Utility/Telecom. Tax 2,240,031 1,358,966 1,916,667 70.9%4,600,000 (881,065) Licenses and Permits 2,235,710 1,096,824 936,588 117.1%2,247,810 (1,138,886) Charges for Services 1,358,799 864,058 906,104 95.4%2,174,650 (494,741) Investment Interest 381,598 686,488 187,500 366.1%450,000 304,889 Miscellaneous Income 420,162 399,400 381,696 104.6%916,070 (20,762) Total Operating Revenues 15,370,227$ 12,901,544$ 12,290,413$ 105.0%29,496,991$ (2,468,682)$ OPERATING EXPENDITURES Personnel 7,490,198$ 8,764,296$ 9,402,172$ 93.2%22,565,214$ 1,274,098$ Materials and Supplies 212,264 227,511 275,664 82.5%661,594 15,246$ Operation and Contract 2,006,755 2,725,470 2,635,131 103.4%6,324,313 718,714$ Other Expenditures 4,271 4,240 4,125 102.8%9,900 (31)$ Capital Outlay 92,081 147,052 276,295 53.2%663,107 54,971$ Total Operating Expenditures 9,805,570$ 11,868,568$ 12,593,387$ 94.2%30,224,129$ 2,062,999$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 5,564,657$ 1,032,976$ (302,974)$ -340.9%(727,137)$ (4,531,681)$ INTERFUND TRANSACTIONS Transfers In -$ -$ -$ N/A -$ -$ Transfers Out N/A - Reimbursements From Other Funds 325,714 364,975 364,974 100.0%875,938 39,261 Reimbursements To Other Funds - - 41,667 0.0%100,000 - Sports Core Loan N/A - - Total Interfund Transactions 325,714$ 364,975$ 406,641$ 89.8%975,938$ 39,261$ NET FUND INCREASE (DECREASE)5,890,371$ 1,397,951$ 103,667$ 248,801$ (4,492,420)$ Village of Oak Brook General Fund Financial Update For the Period Ending May 31, 2024 5/31/24 5/31/24 5/31/23 5/31/24 YTD % of YTD 2024 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Hotel Tax 488,084$ 618,492$ 604,167$ 102.4%1,450,000$ 130,408$ Investment Interest 28,893 68,399 10,417 656.6%25,000 39,506 Loan Interest 2,000 - 833 0.0%2,000 (2,000) Miscellaneous - - - - Total Operating Revenues 518,977$ 686,890$ 615,417$ 111.6%1,477,000$ 167,914$ EXPENDITURES Operation and Contract 53,045$ 58,862$ 293,769$ 20.0%705,045$ 5,817$ Capital Outlay - 3,683 114,583 3.2%275,000 3,683 Total Expenditures 53,045$ 62,545$ 408,352$ 15.3%980,045$ 9,500$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 465,932$ 624,345$ 207,065$ 301.5%496,955$ 158,414$ INTERFUND TRANSACTIONS Transfer Out -$ -$ -$ N/A -$ -$ Reimbursements to Other Funds (145,619) (101,630) (101,631) 100.0%(243,915) 43,989 Total Interfund Transactions (145,619)$ (101,630)$ (101,631)$ 100.0%(243,915)$ 43,989$ NET FUND INCREASE (DECREASE)320,313$ 522,715$ 105,433$ 253,040$ 202,403$ Note - Expenditures are recorded in program 171. Village of Oak Brook Hotel Tax Fund Financial Update For the Period Ending May 31, 2024 5/31/24 5/31/24 5/31/23 5/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 3,158,232$ 3,190,959$ 2,792,917$ 114.3%6,703,000$ 32,727$ Charges for Services - - N/A -$ Investment Interest 87,934 311,474 52,083 598.0%125,000 223,540 Grants - - - N/A - - Miscellaneous 2,100 1,990 9,583 20.8%23,000 (110) Total Operating Revenues 3,248,266$ 3,504,423$ 2,854,583$ 122.8%6,851,000$ 256,157$ OPERATING EXPENDITURES Personnel 47,293$ 75,673$ -$ N/A -$ 28,380$ Materials and Supplies 138,691 199 19,375 1.0%46,500 (138,493) Operation and Contract 311,354 428,097 726,237 58.9%1,742,968 116,743 Other Expenditures - 13,335 141,625 9.4%339,899 13,335 Capital Outlay 1,314,661 330,723 1,409,906 23.5%3,383,775 (983,938) Total Operating Expenditures 1,811,999$ 848,027$ 2,297,143$ 36.9%5,513,142$ (963,972)$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 1,436,267$ 2,656,395$ 557,441$ 476.5%1,337,858$ 1,220,129$ INTERFUND TRANSACTIONS Transfers In -$ -$ -$ N/A -$ -$ Reimbursements From Other Funds 90,650 - - N/A - (90,650) Reimbursements To Other Funds (141,625) (10,688) - N/A - 130,937 Total Interfund Transactions (50,975)$ (10,688)$ -$ N/A -$ 40,287$ NET FUND INCREASE (DECREASE)1,385,292$ 2,645,707$ 557,441$ 1,337,858$ 1,260,415$ Village of Oak Brook Infrastructure Fund Financial Update For the Period Ending May 31, 2024 5/31/24 5/31/24 5/31/23 5/31/24 YTD % of YTD 2024 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Plan Review Fees 975$ 227$ 219$ 103.7%525$ (748)$ Building/Inspection Fees 1,050 - 833 0.0%2,000 (1,050) Water Sales 2,985,383 3,322,784 4,466,667 74.4%10,720,000 337,401 Unmetered Sales 8,490 17,969 27,083 66.3%65,000 9,479 Water Connection Fees 119,830 23,000 58,333 39.4%140,000 (96,830) Fire Service Charge - - - N/A - - Meter Charges 11,944 5,210 7,208 72.3%17,300 (6,734) Special Services 25,741 - 4,167 0.0%10,000 (25,741) Investment Interest 337,947 525,445 145,833 360.3%350,000 187,499 Proceeds from Property Sale - - - N/A - - Miscellaneous 44,513 40,157 479,054 8.4%1,149,730 (4,356) Total Operating Revenues 3,535,872$ 3,934,791$ 5,189,398$ 75.8%12,454,555$ 398,919$ OPERATING EXPENDITURES Personnel 256,513$ 263,939$ 327,672$ 80.5%786,413$ 7,426$ Materials and Supplies 38,963 42,522 57,174 74.4%137,216 3,559 Operation and Contract 1,484,196 1,716,766 2,958,904 58.0%7,101,369 232,569 Capital Outlay 989,340 1,137,239 2,370,833 48.0%5,690,000 147,899 Total Expenditures 2,769,012$ 3,160,466$ 5,714,583$ 55.3%13,714,999$ 391,453$ Surplus (Deficit) of Revenues Over Expenditures 766,860$ 774,325$ (525,185)$ -147.4%(1,260,444)$ 7,465$ INTERFUND TRANSACTIONS Reimbursements To Other Funds (77,748)$ (182,035)$ (182,033)$ 100.0%(436,879)$ (104,287)$ Total Interfund Transactions (77,748)$ (182,035)$ (182,033)$ 100.0%(436,879)$ (104,287)$ Fund Increase/(Decrease) - Budgetary Basis 689,112$ 592,290$ (707,218)$ (1,697,323)$ (96,821)$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay 989,340$ 1,137,239$ Depreciation Expense (191,667) (239,583) IMRF Pension Expense (15,000) (18,750) OPEB Expense (10,000) (12,500) Total GAAP Adjustments 772,673$ 866,406$ Fund Increase/(Decrease) - GAAP Basis 1,461,785$ 1,458,696$ *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, 2024 Village of Oak Brook Monthly Operating Statement Sports Core Fund Consolidated Presentation For the Period Ending May 31, 2024 5/31/24 5/31/24 5/31/24 YTD % of YTD 2024 5/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 381,075$ -$ -$ 391,650$ 772,725$ 396,135$ 195.1%950,725$ 789,742$ (17,017)$ Greens Fees - - - 412,473 412,473 585,417 70.5%1,405,000 258,131 154,342 Golf Surcharge - - - 53,143 53,143 53,143 100.0%53,143 34,669 18,474 Pro Shop Sales - - - 42,856 42,856 90,833 47.2%218,000 71,123 (28,267) Golf Lessons - - - 29,330 29,330 18,750 156.4%45,000 27,648 1,682 Driving Range Fees - - - 224,685 224,685 162,500 138.3%390,000 159,711 64,974 Rentals - 46,972 44,936 165,147 257,055 415,917 61.8%998,200 242,606 14,449 Programs/User Fees 46,724 - - - 46,724 45,750 102.1%109,800 45,220 1,504 Food Sales - - - 7,664 7,664 19,958 38.4%47,900 52,892 (45,229) Beverage Sales - - - - - 32,354 0.0%77,650 96,719 (96,719) Taste of Oak Brook - - - - - - N/A - - - Grants - - - - - - N/A - - - Other Revenue 92,741 - - 1,439 94,180 41,316 227.9%99,160 805 93,375 Total Operating Revenues 520,540$ 46,972$ 44,936$ 1,328,386$ 1,940,834$ 1,862,074$ 104.2%4,394,578$ 1,779,267$ 161,568$ OPERATING EXPENDITURES Personnel 1,142$ -$ -$ 431,748$ 432,890$ 581,242$ 74.5%1,671,380$ 334,077$ 98,812$ Materials & Supplies 20,536 - 4,353 130,700 155,590 180,522 86.2%718,900 122,692 32,898 Operational & Contractual 241,459 23,620 20,407 159,540 445,025 451,768 98.5%942,765 336,792 108,234 Other - - - - - - N/A - - - Capital 89,213 - - 784,937 874,150 448,440 194.9%466,750 32,481 841,669 Total Operating Expenditures 352,349$ 23,620$ 24,760$ 1,506,925$ 1,907,655$ 1,661,971$ 114.8%3,799,795$ 826,042$ 1,081,613$ B&T Administration Overhead Allocation*15,607$ -$ (5,208)$ (10,399)$ -$ -$ N/A -$ -$ -$ Operating Revenues Over (Under) Expenditures 183,797$ 23,352$ 14,968$ (188,937)$ 33,180$ 200,103$ 16.6%594,783$ 953,225$ (920,045)$ INTERFUND TRANSACTIONS Interfund Loan**-$ -$ -$ -$ -$ -$ N/A -$ -$ -$ Transfer From General Fund - - - - - - N/A - - - Transfer From Golf Surcharge Fund - - - (10,399) (10,399) (10,399) 100.0%(24,957) - (10,399) Reimbursement From Infrastructure Fund - - - - - - N/A - - - Reimbursement From Water Fund - - - - - 16,667 0.0%40,000 - - Reimbursement To General Fund (21,160) - - (63,485) (84,645) (71,917) 117.7%(172,600) (37,074) (47,571) Total Interfund Transactions (21,160)$ -$ -$ (73,884)$ (95,044)$ (65,649)$ 144.8%(157,557)$ (37,074)$ (57,969)$ Total Revenues Over (Under) Expenditures - Budgetary Basis 162,637$ 23,352$ 14,968$ (262,821)$ (61,864)$ 134,454$ 437,226$ 916,150$ (978,014)$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay 89,213$ -$ -$ 784,937$ 874,150$ 32,481$ Depreciation Expense (70,095) (702) (25,000) (102,625) (198,422) (184,403) IMRF Pension Expense (854) - (1,250) (10,208) (12,313) (12,142) OPEB Expense - - (1,250) (11,667) (12,917) (12,917) Total GAAP Adjustments 18,264$ (702)$ (27,500)$ 660,437$ 650,499$ (176,980)$ Fund Increase/(Decrease) - GAAP Basis 180,902$ 22,650$ (12,532)$ 397,616$ 588,635$ 739,170$ *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, 2024 5/31/24 5/31/24 822 5/31/24 YTD % of YTD 2024 5/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 -$ 359,450$ 21,625$ -$ 381,075$ 184,490$ 206.6%442,775$ 387,642$ (6,567)$ Programs/User Fees - 36,240 10,484 - 46,724 45,750.00 102.1%109,800 45,220 1,504 Food Sales - - - - - 2,500.00 0.0%6,000 - - Beverage Sales - - - - - 1,000.00 0.0%2,400 - - Grants - - - - - - N/A - - - Other Revenue 88,741 - - 4,000 92,741 37,566 246.9%90,160 805 91,936 Total Operating Revenues 88,741$ 395,690$ 32,109$ 4,000$ 520,540$ 271,306$ 191.9%651,135$ 433,668$ 86,872$ OPERATING EXPENDITURES Personnel -$ 1,142$ -$ -$ 1,142$ 104,953$ 1.1%251,888$ 419$ 722$ Materials & Supplies 21 12,133 8,319 63 20,536 18,908 108.6%45,380 5,383 15,153 Operational & Contractual 100,592 114,850 25,611 405 241,459 238,764 101.1%573,034 158,056 83,402 Other - - - - - - N/A - - - Capital 8,456 80,757 - - 89,213 364,375 24.5%874,500 - 89,213 Total Operating Expenditures 109,069$ 208,882$ 33,930$ 468$ 352,349$ 727,001$ 48.5%1,744,801$ 163,859$ 188,491$ B&T Administration Overhead Allocation*43,542$ (17,133)$ (4,760)$ (6,042)$ 15,607$ -$ N/A 37,457$ -$ 15,607$ Operating Revenues Over (Under) Expenditures 23,213$ 169,676$ (6,582)$ (2,510)$ 183,797$ (455,695)$ -40.3%(1,056,210)$ 269,809$ (86,012)$ Transfer From General Fund - - - - - - N/A - - Reimbursement From Infrastructure Fund - - - - - -$ N/A - - - Reimbursement From Water Fund 16,670 - - - - 16,667 0.0%40,000 - - Reimbursement To General Fund (21,160) - - - (21,160) (8,434) 250.9%(20,242) (13,494) (7,666) Total Interfund Transactions (4,490)$ -$ -$ -$ (21,160)$ 8,233$ -257.0%19,758$ (13,494)$ (7,666)$ Total Revenues Over (Under) Expenditures - Budgetary Basis 18,723$ 169,676$ (6,582)$ (2,510)$ 162,637$ (447,462)$ (1,036,452)$ 256,315$ (93,677)$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay 8,456$ 80,757$ -$ -$ 89,213$ -$ Depreciation Expense (26,816) (41,667) (1,125) (487) (70,095) (56,076) IMRF Pension Expense (833) - - (21) (854) (683) Total GAAP Adjustments (19,193)$ 39,090$ (1,125)$ (508)$ 18,264$ (56,759)$ Fund Increase/(Decrease) - GAAP Basis (470)$ 208,766$ (7,707)$ (3,018)$ 180,902$ 199,556$ *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, 2024 5/31/24 5/31/24 5/31/24 YTD % of YTD 2024 5/31/23 Difference 815 816 YTD Amended Amended Adopted YTD Prior Polo Open Fields Total Budget Budget Budget Total Year OPERATING REVENUES Field Rentals -$ 46,972$ 46,972$ 80,417$ 58.4%193,000$ 45,500$ 1,472$ Range Rentals - - - - N/A - 86,080 (86,080) Taste of Oak Brook - - - - N/A - - - Other Revenue - - - N/A - - - Total Operating Revenues -$ 46,972$ 46,972$ 80,417$ 58.4%193,000$ 131,580$ (84,608)$ OPERATING EXPENDITURES Personnel -$ -$ -$ -$ N/A -$ -$ Materials & Supplies - - - 3,954 0.0%9,490$ - - Operational & Contractual - 23,620 23,620 31,688 74.5%76,050 31,682 (8,062) Other - - N/A - - - Capital - - - 19,167 0.0%46,000 - - Total Operating Expenditures -$ 23,620$ 23,620$ 54,808$ 43.1%131,540$ 31,682$ (8,062)$ Operating Revenues Over (Under) Expenditures -$ 23,352$ 23,352$ 25,608$ 91.2%61,460$ 99,898$ (76,546)$ INTERFUND TRANSACTIONS Transfer From Hotel Tax Fund -$ -$ -$ -$ N/A -$ -$ -$ Total Interfund Transactions -$ -$ -$ -$ N/A -$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis -$ 23,352$ 23,352$ 25,608$ 61,460$ 99,898$ (76,546)$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ -$ -$ -$ Depreciation Expense - (702) (702) (702) Total GAAP Adjustments -$ (702)$ (702)$ (702)$ Fund Increase/(Decrease) - GAAP Basis -$ 22,650$ 22,650$ 99,196$ *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, 2024 5/31/24 5/31/24 821 YTD % of YTD 2024 5/31/23 Difference B&T Amended Amended Adopted YTD Prior Clubhouse Budget Budget Budget Total Year OPERATING REVENUES Rentals 44,936$ 97,083$ 46.3%233,000$ 23,492$ 21,444$ Other Revenue - - 0.0%- - - Total Operating Revenues 44,936$ 97,083$ 46.3%233,000$ 23,492$ 21,444$ OPERATING EXPENDITURES Personnel -$ -$ N/A -$ 3,380$ (3,380)$ Materials & Supplies 4,353 5,729 76.0%13,750 529 3,824 Operational & Contractual 20,407 22,074 92.4%52,978 19,042 1,365 Capital - - N/A - - - Total Operating Expenditures 24,760$ 27,803$ 89.1%66,728$ 22,951$ 1,810$ B&T Administration Overhead Allocation*(5,208)$ -$ N/A (12,500)$ -$ (5,208)$ Operating Revenues Over (Under) Expenditures 14,968$ 69,280$ 21.6%153,772$ 541$ 14,426$ INTERFUND TRANSACTIONS Transfer From General Fund -$ -$ 0.0%-$ -$ -$ Total Interfund Transactions -$ -$ 0.0%-$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis 14,968$ 69,280$ 153,772$ 541$ 14,426$ 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 (12,532)$ (26,959)$ *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, 2024 5/31/24 5/31/24 823 831 832 833 834 5/31/24 YTD % of YTD 2024 5/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 -$ 391,650$ -$ -$ -$ 391,650$ 211,646$ 185.0%507,950$ 402,100$ (10,450)$ Greens Fees - 412,473 - - - 412,473 585,417 70.5%1,405,000 258,131 154,342 Surcharge 53,143 53,143 53,143 100.0%53,143 34,669 18,474 Pro Shop Sales - 42,856 - - - 42,856 90,833 47.2%218,000 71,123 (28,267) Golf Lessons - - 29,330 - - 29,330 18,750 156.4%45,000 27,648 1,682 Driving Range Fees - - 224,685 - - 224,685 162,500 138.3%390,000 159,711 64,974 Rentals 10,000 - 24,500 130,647 - 165,147 238,417 69.3%572,200 87,534 77,613 Food Sales 7,664 - - - - 7,664 17,458 43.9%41,900 52,892 (45,229) Beverage Sales - - - - - - 31,354 0.0%75,250 96,719 (96,719) Other Revenue - 1,439 - - - 1,439 3,750 38.4%9,000 - 1,439 Total Operating Revenues 17,664$ 901,561$ 278,515$ 130,647$ -$ 1,328,386$ 1,413,268$ 94.0%3,317,443$ 1,190,527$ 137,859$ OPERATING EXPENDITURES Personnel -$ 251,476$ 9,243$ 24,864$ 146,166$ 431,748$ 476,288$ 90.6%1,143,092$ 330,278$ 101,470$ Materials & Supplies (15) 31,118 6,268 466 92,863 130,700 151,930 86.0%364,633 116,780 13,920 Operational & Contractual 2,870 87,079 9,034 31,361 29,196 159,540 159,242 100.2%382,181 128,012 31,528 Other - - - - - N/A - - - Capital - 9,940 - 671,600 103,397 784,937 64,898 1209.5%155,755 32,481 752,456 Total Operating Expenditures 2,855$ 379,613$ 24,545$ 728,290$ 371,622$ 1,506,925$ 852,359$ 176.8%2,045,661$ 607,551$ 899,374$ Operating Revenues Over (Under) Expenditures 14,808$ 521,948$ 253,970$ (597,643)$ (371,622)$ (178,539)$ 560,909$ -31.8%1,271,782$ 582,976$ (761,515)$ INTERFUND TRANSACTIONS Overhead Charge -$ (10,399)$ -$ -$ -$ (10,399)$ (10,399)$ 100.0%(24,957)$ -$ (10,399)$ Transfers from Other Fund - - - - - - - 0.0%150,000 - - Reimbursement to General Fund - (63,485) - - - (63,485) (63,483) 100.0%(152,358) (23,580) (39,905) Total Interfund Transactions -$ (73,884)$ -$ -$ -$ (73,884)$ (73,881)$ 100.0%(27,315)$ (23,580)$ (50,304)$ Total Revenues Over (Under) Expenditures - Budgetary Basis 14,808$ 448,064$ 253,970$ (597,643)$ (371,622)$ (252,422)$ 487,028$ 1,244,467$ 559,396$ (811,819)$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay -$ 9,940$ -$ 671,600$ 103,397$ 784,937$ 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)$ (44,227)$ (1,375)$ 666,183$ 42,564$ 660,437$ (92,019)$ Fund Increase/(Decrease) - GAAP Basis 12,100$ 403,837$ 252,595$ 68,540$ (329,058)$ 408,015$ 467,377$ *Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.