Loading...
HomeMy WebLinkAbout06 - June 2024 Monthly Financial ReportVILLAGE OAK BROOKOF MONTHLY FINANCIAL REPORTS JUNE 2024 Estimated YTD YTD Net Fund Ending YTD YTD Increase Fund Balance Governmental Funds Revenues Expenditures (Decrease)(Deficit) General Fund (Major Fund)15,734,319$ 14,267,283$ 1,467,036$ 44,092,425$ Main operating fund of the Village. Hotel Fund (Major Fund)796,970$ 100,295$ 696,675$ 4,467,872$ Collects and spends resources from the 3% hotel/motel tax. Motor Fuel Tax Fund 223,176$ 89,327$ 133,849$ 2,155,951$ Collects and spends resources from the State motor fuel tax. Infrastructure Fund (Major Fund)4,175,346$ 1,064,577$ 3,110,769$ 17,535,276$ Accounts for construction and maintenance of roadways, drainage, and safety path systems. Enterprise Funds Water Fund (Major Fund)4,684,636$ 4,735,352$ (50,716)$ 21,867,927$ Collects user fees for the distribution of water and maintenance of infrastructure. Sports Core Fund (Major Fund)2,646,652$ 2,717,487$ (70,835)$ 2,833,053$ Accounts for revenues and expenses relating to administration, programs, food and beverage operations, and golf course. Internal Service Funds Insurance Fund 1,453,412$ 1,794,871$ (341,458)$ 223,985$ Accounts for the Village's health insurance costs and the related contributions from the Village, employees, retirees, and other agencies. Garage Fund 372,800$ 363,105$ 9,694$ 356,169$ Accounts for the maintenance of the Village's vehicle fleet and the related departmental reimbursements. Equipment Replacement Fund 703,045$ 529,606$ 173,440$ 3,221,397$ 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 June 30, 2024 6/30/24 6/30/24 6/30/23 6/30/24 YTD % of YTD 2024 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax 8,786,461$ 8,678,973 8,248,302$ 105.2%16,496,604$ (107,489)$ State Income Tax 715,826 771,953 655,500 117.8%1,311,000 56,128 Replacement Tax 538,044 312,290 375,508 83.2%751,015 (225,754) Road & Bridge Tax 15,089 21,516 17,500 122.9%35,000 6,427 Local Use Tax 177,855 161,610 168,000 96.2%336,000 (16,245) Cannabis Use Tax 6,235 6,791 6,590 103.0%13,180 556 Grants 576,109 154,908 82,831 187.0%165,662 (421,202) Utility/Telecom. Tax 2,623,357 1,603,876 2,300,000 69.7%4,600,000 (1,019,481) Licenses and Permits 2,977,462 1,295,077 1,123,905 115.2%2,247,810 (1,682,385) Charges for Services 1,660,036 964,223 1,087,325 88.7%2,174,650 (695,814) Investment Interest 478,800 878,675 225,000 390.5%450,000 399,874 Miscellaneous Income 563,197 446,457 458,035 97.5%916,070 (116,740) Total Operating Revenues 19,118,472$ 15,296,349$ 14,748,496$ 103.7%29,496,991$ (3,822,123)$ OPERATING EXPENDITURES Personnel 9,844,158$ 10,558,262$ 11,282,607$ 93.6%22,565,214$ 714,104$ Materials and Supplies 280,257 267,749 330,797 80.9%661,594 (12,509)$ Operation and Contract 2,355,729 3,262,337 3,162,157 103.2%6,324,313 906,609$ Other Expenditures 4,271 4,240 4,950 85.7%9,900 (31)$ Capital Outlay 495,089 174,695 331,554 52.7%663,107 (320,394)$ Total Operating Expenditures 12,979,503$ 14,267,283$ 15,112,064$ 94.4%30,224,129$ 1,287,779$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 6,138,969$ 1,029,066$ (363,569)$ -283.0%(727,137)$ (5,109,903)$ INTERFUND TRANSACTIONS Transfers In -$ -$ -$ N/A -$ -$ Transfers Out N/A - Reimbursements From Other Funds 390,857 437,970 437,969 100.0%875,938 47,113 Reimbursements To Other Funds - - 50,000 0.0%100,000 - Sports Core Loan N/A - - Total Interfund Transactions 390,857$ 437,970$ 487,969$ 89.8%975,938$ 47,113$ NET FUND INCREASE (DECREASE)6,529,826$ 1,467,036$ 124,400$ 248,801$ (5,062,790)$ Village of Oak Brook General Fund Financial Update For the Period Ending June 30, 2024 6/30/24 6/30/24 6/30/23 6/30/24 YTD % of YTD 2024 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Hotel Tax 641,285$ 707,934$ 725,000$ 97.6%1,450,000$ 66,649$ Investment Interest 36,119 88,036 12,500 704.3%25,000 51,917 Loan Interest 2,000 1,000 1,000 100.0%2,000 (1,000) Miscellaneous - - - - Total Operating Revenues 679,404$ 796,970$ 738,500$ 107.9%1,477,000$ 117,565$ EXPENDITURES Operation and Contract 53,045$ (25,344)$ 352,523$ -7.2%705,045$ (78,390)$ Capital Outlay - 3,683 137,500 2.7%275,000 3,683 Total Expenditures 53,045$ (21,661)$ 490,023$ -4.4%980,045$ (74,706)$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 626,359$ 818,631$ 248,478$ 329.5%496,955$ 192,272$ INTERFUND TRANSACTIONS Transfer Out -$ -$ -$ N/A -$ -$ Reimbursements to Other Funds (174,743) (121,956) (121,958) 100.0%(243,915) 52,787 Total Interfund Transactions (174,743)$ (121,956)$ (121,958)$ 100.0%(243,915)$ 52,787$ NET FUND INCREASE (DECREASE)451,616$ 696,675$ 126,520$ 253,040$ 245,059$ Note - Expenditures are recorded in program 171. Village of Oak Brook Hotel Tax Fund Financial Update For the Period Ending June 30, 2024 6/30/24 6/30/24 6/30/23 6/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 3,714,827$ 3,774,404$ 3,351,500$ 112.6%6,703,000$ 59,577$ Charges for Services - - N/A -$ Investment Interest 112,192 398,952 62,500 638.3%125,000 286,760 Grants - - - N/A - - Miscellaneous 2,100 1,990 11,500 17.3%23,000 (110) Total Operating Revenues 3,829,119$ 4,175,346$ 3,425,500$ 121.9%6,851,000$ 346,227$ OPERATING EXPENDITURES Personnel 7,853$ 94,008$ -$ N/A -$ 86,155$ Materials and Supplies 139,330 199 23,250 0.9%46,500 (139,131) Operation and Contract 392,613 612,510 871,484 70.3%1,742,968 219,896 Other Expenditures 169,950 - 169,950 0.0%339,899 (169,950) Capital Outlay 1,314,661 341,859 1,691,888 20.2%3,383,775 (972,802) Total Operating Expenditures 2,024,407$ 1,048,575$ 2,756,571$ 38.0%5,513,142$ (975,832)$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 1,804,712$ 3,126,771$ 668,929$ 467.4%1,337,858$ 1,322,059$ INTERFUND TRANSACTIONS Transfers In -$ -$ -$ N/A -$ -$ Reimbursements From Other Funds 108,780 - - N/A - (108,780) Reimbursements To Other Funds - (16,002) - N/A - (16,002) Total Interfund Transactions 108,780$ (16,002)$ -$ N/A -$ (124,782)$ NET FUND INCREASE (DECREASE)1,913,492$ 3,110,769$ 668,929$ 1,337,858$ 1,197,277$ Village of Oak Brook Infrastructure Fund Financial Update For the Period Ending June 30, 2024 6/30/24 6/30/24 6/30/23 6/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,200$ 227$ 263$ 86.4%525$ (973)$ Building/Inspection Fees 1,275 - 1,000 0.0%2,000 (1,275) Water Sales 3,489,344 3,883,758 5,360,000 72.5%10,720,000 394,415 Unmetered Sales 9,390 35,081 32,500 107.9%65,000 25,691 Water Connection Fees 126,960 23,000 70,000 32.9%140,000 (103,960) Fire Service Charge - - - N/A - - Meter Charges 14,074 5,210 8,650 60.2%17,300 (8,864) Special Services 25,741 15,054 5,000 301.1%10,000 (10,687) Investment Interest 417,447 673,197 175,000 384.7%350,000 255,750 Proceeds from Property Sale - - - N/A - - Miscellaneous 54,868 49,108 574,865 8.5%1,149,730 (5,759) Total Operating Revenues 4,140,299$ 4,684,636$ 6,227,278$ 75.2%12,454,555$ 544,338$ OPERATING EXPENDITURES Personnel 330,060$ 320,759$ 393,207$ 81.6%786,413$ (9,301)$ Materials and Supplies 50,184 63,360 68,608 92.4%137,216 13,176 Operation and Contract 2,010,177 2,335,325 3,550,685 65.8%7,101,369 325,148 Capital Outlay 989,340 1,797,466 2,845,000 63.2%5,690,000 808,126 Total Expenditures 3,379,762$ 4,516,910$ 6,857,499$ 65.9%13,714,999$ 1,137,148$ Surplus (Deficit) of Revenues Over Expenditures 760,537$ 167,726$ (630,222)$ -26.6%(1,260,444)$ (592,811)$ INTERFUND TRANSACTIONS Reimbursements To Other Funds (93,298)$ (218,442)$ (218,440)$ 100.0%(436,879)$ (125,144)$ Total Interfund Transactions (93,298)$ (218,442)$ (218,440)$ 100.0%(436,879)$ (125,144)$ Fund Increase/(Decrease) - Budgetary Basis 667,239$ (50,716)$ (848,661)$ (1,697,323)$ (717,955)$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay 989,340$ 1,797,466$ Depreciation Expense (191,667) (287,500) IMRF Pension Expense (15,000) (22,500) OPEB Expense (10,000) (15,000) Total GAAP Adjustments 772,673$ 1,472,466$ Fund Increase/(Decrease) - GAAP Basis 1,439,912$ 1,421,750$ *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 June 30, 2024 Village of Oak Brook Monthly Operating Statement Sports Core Fund Consolidated Presentation For the Period Ending June 30, 2024 6/30/24 6/30/24 6/30/24 YTD % of YTD 2024 6/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 426,930$ -$ -$ 396,900$ 823,830$ 475,363$ 173.3%950,725$ 886,410$ (62,580)$ Greens Fees - - - 701,460 701,460 702,500 99.9%1,405,000 583,491 117,969 Golf Surcharge - - - 91,629 91,629 53,143 172.4%53,143 - 91,629 Pro Shop Sales - - - 73,707 73,707 109,000 67.6%218,000 100,224 (26,516) Golf Lessons - - - 35,910 35,910 22,500 159.6%45,000 21,751 14,159 Driving Range Fees - - - 298,354 298,354 195,000 153.0%390,000 260,209 38,145 Rentals - 67,833 56,017 271,335 395,186 499,100 79.2%998,200 389,188 5,998 Programs/User Fees 90,399 - - - 90,399 54,900 164.7%109,800 65,081 25,317 Food Sales - - - 20,044 20,044 23,950 83.7%47,900 154,467 (134,423) Beverage Sales - - - - - 38,825 0.0%77,650 216,346 (216,346) Taste of Oak Brook - - - - - - N/A - - - Grants - - - - - - N/A - - - Other Revenue 94,690 - - 1,439 96,129 49,580 193.9%99,160 1,166 94,963 Total Operating Revenues 612,019$ 67,833$ 56,017$ 1,890,779$ 2,626,648$ 2,223,860$ 118.1%4,394,578$ 2,678,334$ (51,686)$ OPERATING EXPENDITURES Personnel 16,976$ -$ -$ 601,939$ 618,915$ 697,490$ 88.7%1,671,380$ 597,597$ 21,317$ Materials & Supplies 28,911 - 6,812 176,572 212,295 216,627 98.0%718,900 300,863 (88,568) Operational & Contractual 400,079 23,646 24,366 195,982 644,073 542,121 118.8%942,765 464,809 179,263 Other - - - - - - N/A - - - Capital 346,999 - - 793,632 1,140,630 538,128 212.0%466,750 95,291 1,045,339 Total Operating Expenditures 792,965$ 23,646$ 31,178$ 1,768,124$ 2,615,913$ 1,994,365$ 131.2%3,799,795$ 1,458,561$ 1,157,352$ B&T Administration Overhead Allocation*18,728$ -$ (6,250)$ (12,478)$ -$ (12,478)$ N/A (24,957) -$ (24,957)$ Operating Revenues Over (Under) Expenditures (162,218)$ 44,187$ 18,589$ 110,177$ 10,735$ 217,017$ 4.9%569,826$ 1,219,773$ (1,233,994)$ INTERFUND TRANSACTIONS Interfund Loan**-$ -$ -$ -$ -$ -$ N/A -$ -$ -$ Transfer From General Fund - - - - - - N/A - - - Reimbursement From Infrastructure Fund - - - - - - N/A - - - Reimbursement From Water Fund 20,004 - - - 20,004 20,000 100.0%40,000 - 20,004 Reimbursement To General Fund (25,392) - - (76,182) (101,574) (86,300) 117.7%(172,600) (20,242) (81,332) Total Interfund Transactions (5,388)$ -$ -$ (76,182)$ (81,570)$ (66,300)$ 123.0%(132,600)$ (20,242)$ (61,328)$ Total Revenues Over (Under) Expenditures - Budgetary Basis (167,606)$ 44,187$ 18,589$ 33,995$ (70,835)$ 150,717$ 437,226$ 1,199,531$ (1,295,323)$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay 346,999$ -$ -$ 793,632$ 1,140,630$ 95,291$ Depreciation Expense (84,114) (843) (25,000) (123,150) (233,106) (233,107) IMRF Pension Expense (1,025) - (1,250) (12,250) (14,525) (14,525) OPEB Expense - - (1,250) (14,000) (15,250) (15,250) Total GAAP Adjustments 261,860$ (843)$ (27,500)$ 644,232$ 877,749$ (167,591)$ Fund Increase/(Decrease) - GAAP Basis 94,254$ 43,345$ (8,911)$ 678,226$ 806,914$ 1,031,941$ *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 June 30, 2024 6/30/24 6/30/24 822 6/30/24 YTD % of YTD 2024 6/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 -$ 398,500$ 28,430$ -$ 426,930$ 221,388$ 192.8%442,775$ 406,310$ 20,620$ Programs/User Fees - 61,110 29,289 - 90,399 54,900.00 164.7%109,800 65,081 25,317 Food Sales - - - - - 3,000.00 0.0%6,000 24,049 - Beverage Sales - - - - - 1,200.00 0.0%2,400 8,099 - Grants - - - - - - N/A - - - Other Revenue 88,690 - 1,000 5,000 94,690 45,080 210.1%90,160 1,166 93,524 Total Operating Revenues 88,690$ 459,610$ 58,719$ 5,000$ 612,019$ 325,567$ 188.0%651,135$ 504,705$ 139,461$ OPERATING EXPENDITURES Personnel -$ 16,976$ -$ -$ 16,976$ 125,944$ 13.5%251,888$ 22,283$ (5,307)$ Materials & Supplies 21 17,773 10,982 136 28,911 22,690 127.4%45,380 10,596 18,315 Operational & Contractual 117,504 225,368 56,444 763 400,079 286,517 139.6%573,034 229,044 171,035 Other - - - - - - N/A - - - Capital 262,043 84,956 - - 346,999 437,250 79.4%874,500 - 346,999 Total Operating Expenditures 379,567$ 345,073$ 67,426$ 899$ 792,965$ 872,401$ 90.9%1,744,801$ 261,923$ 531,041$ B&T Administration Overhead Allocation*52,250$ (20,559)$ (5,712)$ (7,250)$ 18,728$ -$ N/A 37,457$ -$ 18,728$ Operating Revenues Over (Under) Expenditures (238,627)$ 93,978$ (14,420)$ (3,149)$ (162,218)$ (546,833)$ 29.7%(1,056,210)$ 242,782$ (372,852)$ Transfer From General Fund - - - - - - N/A - - Reimbursement From Infrastructure Fund - - - - - -$ N/A - - - Reimbursement From Water Fund 20,004 - - - 20,004 20,000 100.0%40,000 - 20,004 Reimbursement To General Fund (25,392) - - - (25,392) (10,121) 250.9%(20,242) - (25,392) Total Interfund Transactions (5,388)$ -$ -$ -$ (5,388)$ 9,879$ -54.5%19,758$ -$ (5,388)$ Total Revenues Over (Under) Expenditures - Budgetary Basis (244,015)$ 93,978$ (14,420)$ (3,149)$ (167,606)$ (536,954)$ (1,036,452)$ 242,782$ (378,240)$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay 262,043$ 84,956$ -$ -$ 346,999$ -$ Depreciation Expense (32,180) (50,000) (1,350) (584) (84,114) (84,114) IMRF Pension Expense (1,000) - - (25) (1,025) (1,025) Total GAAP Adjustments 228,863$ 34,956$ (1,350)$ (609)$ 261,860$ (85,139)$ Fund Increase/(Decrease) - GAAP Basis (15,152)$ 128,934$ (15,770)$ (3,758)$ 94,254$ 157,643$ *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 June 30, 2024 6/30/24 6/30/24 6/30/24 YTD % of YTD 2024 6/30/23 Difference 815 816 YTD Amended Amended Adopted YTD Prior Polo Open Fields Total Budget Budget Budget Total Year OPERATING REVENUES Field Rentals -$ 67,833$ 67,833 96,500$ 70.3%193,000$ 66,000$ 1,833$ Range Rentals - - - - N/A - 86,080 (86,080) Taste of Oak Brook - - - - N/A - - - Other Revenue - - - - N/A - - - Total Operating Revenues -$ 67,833$ 67,833$ 96,500$ 70.3%193,000$ 152,080$ (84,247)$ OPERATING EXPENDITURES Personnel -$ -$ -$ -$ N/A -$ -$ Materials & Supplies - - - 4,745 0.0%9,490$ - - Operational & Contractual - 23,646 23,646 38,025 62.2%76,050 38,898 (15,252) Other - - - - N/A - - - Capital - - - 23,000 0.0%46,000 - - Total Operating Expenditures -$ 23,646$ 23,646$ 65,770$ 36.0%131,540$ 38,898$ (15,252)$ Operating Revenues Over (Under) Expenditures -$ 44,187$ 44,187$ 30,730$ 143.8%61,460$ 113,182$ (68,995)$ INTERFUND TRANSACTIONS Transfer From Hotel Tax Fund -$ -$ -$ -$ N/A -$ -$ -$ Total Interfund Transactions -$ -$ -$ -$ N/A -$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis -$ 44,187$ 44,187$ 30,730$ 61,460$ 113,182$ (68,995)$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ -$ -$ -$ Depreciation Expense - (843) (843) (843) Total GAAP Adjustments -$ (843)$ (843)$ (843)$ Fund Increase/(Decrease) - GAAP Basis -$ 43,345$ 43,345$ 112,339$ *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 June 30, 2024 6/30/24 6/30/24 821 YTD % of YTD 2024 6/30/23 Difference B&T Amended Amended Adopted YTD Prior Clubhouse Budget Budget Budget Total Year OPERATING REVENUES Rentals 56,017$ 116,500$ 48.1%233,000$ 39,482$ 16,535$ Other Revenue - - 0.0%- - - Total Operating Revenues 56,017$ 116,500$ 48.1%233,000$ 39,482$ 16,535$ OPERATING EXPENDITURES Personnel -$ -$ N/A -$ 4,846$ (4,846)$ Materials & Supplies 6,812 6,875 99.1%13,750 1,228 5,584 Operational & Contractual 24,366 26,489 92.0%52,978 24,769 (403) Capital - - N/A - - - Total Operating Expenditures 31,178$ 33,364$ 93.4%66,728$ 30,842$ 336$ B&T Administration Overhead Allocation*(6,250)$ -$ N/A (12,500)$ -$ (6,250)$ Operating Revenues Over (Under) Expenditures 18,589$ 83,136$ 22.4%153,772$ 8,640$ 9,949$ INTERFUND TRANSACTIONS Transfer From General Fund -$ -$ 0.0%-$ -$ -$ Total Interfund Transactions -$ -$ 0.0%-$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis 18,589$ 83,136$ 153,772$ 8,640$ 9,949$ 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 (8,911)$ (18,860)$ *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 June 30, 2024 6/30/24 6/30/24 823 831 832 833 834 6/30/24 YTD % of YTD 2024 6/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 -$ 396,900$ -$ -$ -$ 396,900$ 253,975$ 156.3%507,950$ 480,100$ (83,200)$ Greens Fees - 701,460 - - - 701,460 702,500 99.9%1,405,000 583,491 117,969 Surcharge - 91,629 91,629 53,143 172.4%53,143 - 91,629 Pro Shop Sales - 73,707 - - - 73,707 109,000 67.6%218,000 100,224 (26,516) Golf Lessons - - 35,910 - - 35,910 22,500 159.6%45,000 21,751 14,159 Driving Range Fees - - 298,354 - - 298,354 195,000 153.0%390,000 260,209 38,145 Rentals 12,500 - 28,250 230,585 - 271,335 286,100 94.8%572,200 197,626 73,709 Food Sales 20,044 - - - - 20,044 20,950 95.7%41,900 130,419 (110,374) Beverage Sales - - - - - - 37,625 0.0%75,250 208,247 (208,247) Other Revenue - 1,439 - - - 1,439 4,500 32.0%9,000 - 1,439 Total Operating Revenues 32,544$ 1,265,135$ 362,514$ 230,585$ -$ 1,890,779$ 1,685,293$ 112.2%3,317,443$ 1,982,067$ (91,288)$ OPERATING EXPENDITURES Personnel 5,184$ 324,926$ 19,347$ 36,214$ 216,268$ 601,939$ 571,546$ 105.3%1,143,092$ 570,468$ 31,470$ Materials & Supplies (15) 74,068 6,268 915 95,336 176,572 182,317 96.8%364,633 289,039 (112,467) Operational & Contractual 2,870 119,620 12,250 31,415 29,826 195,982 191,091 102.6%382,181 172,099 23,883 Other - - - - - N/A - - - Capital - 18,635 - 671,600 103,397 793,632 77,878 1019.1%155,755 95,291 698,341 Total Operating Expenditures 8,039$ 537,249$ 37,865$ 740,144$ 444,827$ 1,768,124$ 1,022,831$ 172.9%2,045,661$ 1,126,897$ 641,226$ Operating Revenues Over (Under) Expenditures 24,505$ 727,887$ 324,649$ (509,559)$ (444,827)$ 122,655$ 662,463$ 18.5%1,271,782$ 855,170$ (732,515)$ INTERFUND TRANSACTIONS Overhead Charge -$ (12,478)$ -$ -$ -$ (12,478)$ (12,478)$ 100.0%(24,957)$ -$ (12,478)$ Transfers from Other Fund - - - - - - - 0.0%150,000 - - Reimbursement to General Fund - (76,182) - - - (76,182) (76,179) 100.0%(152,358) (20,242) (55,940) Total Interfund Transactions -$ (88,660)$ -$ -$ -$ (88,660)$ (88,657)$ 100.0%(27,315)$ (20,242)$ (68,419)$ Total Revenues Over (Under) Expenditures - Budgetary Basis 24,505$ 639,226$ 324,649$ (509,559)$ (444,827)$ 33,995$ 573,805$ 1,244,467$ 834,928$ (800,933)$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay -$ 18,635$ -$ 671,600$ 103,397$ 793,632$ 95,291$ Depreciation Expense (500) (52,500) (1,150) (6,500) (62,500) (123,150) (123,150) IMRF Pension Expense (1,250) (5,000) (500) - (5,500) (12,250) (12,250) OPEB Expense (1,500) (7,500) - - (5,000) (14,000) (14,000) Total GAAP Adjustments (3,250)$ (46,366)$ (1,650)$ 665,100$ 30,397$ 644,232$ (54,109)$ Fund Increase/(Decrease) - GAAP Basis 21,255$ 592,861$ 322,999$ 155,541$ (414,430)$ 678,226$ 780,819$ *Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.