Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
01 - January 2023 Monthly Financial Report
VILLAGE OAK BROOKOF MONTHLY FINANCIAL REPORTS JANUARY 2023 YTD YTD Net Fund Ending YTD YTD Increase Fund Balance Governmental Funds Revenues Expenditures (Decrease)(Deficit) General Fund (Major Fund)2,499,208$ 1,352,772$ 1,146,436$ 39,349,877$ Main operating fund of the Village. Hotel Fund (Major Fund)99,167$ -$ 99,167$ 2,302,408$ Collects and spends resources from the 3% hotel/motel tax. Motor Fuel Tax Fund 36,255$ -$ 36,255$ 1,695,129$ Collects and spends resources from the State motor fuel tax. Infrastructure Fund (Major Fund)594,958$ 5,042$ 589,916$ 7,661,815$ Accounts for construction and maintenance of roadways, drainage, and safety path systems. Promenade TIF Fund (Major Fund)11$ -$ 11$ 297,229$ Accounts for the revenues and expenditures restricted to the Tax Increment Financing (TIF) district located at 22nd St. and Meyers Rd. Enterprise Funds Water Fund (Major Fund)860,113$ 37,503$ 822,610$ 21,781,890$ Collects user fees for the distribution of water and maintenance of infrastructure. Sports Core Fund (Major Fund)4,783$ 220,430$ (215,647)$ 937,486$ Accounts for revenues and expenses relating to administration, programs, food and beverage operations, and golf course. Golf Surcharge Fund -$ -$ -$ 417,070$ Accounts for the collection of the $3 per round golf surcharge. Internal Service Funds Self Insurance Fund 224,796$ 123,032$ 101,764$ 435,358$ Accounts for the Village's health insurance costs and the related contributions from the Village, employees, retirees, and other agencies. Garage Fund 702$ 47,680$ (46,978)$ 251,667$ Accounts for the maintenance of the Village's vehicle fleet and the related departmental reimbursements. Equipment Replacement Fund 1,134$ 302,591$ (301,457)$ 3,529,672$ 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 January 31, 2023 1/31/23 1/31/23 1/31/22 1/31/23 YTD % of YTD 2023 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax 1,439,904$ 1,439,420 1,333,333$ 108.0%16,000,000$ (484)$ State Income Tax 111,223 121,490 95,417 127.3%1,145,000 10,267 Replacement Tax 93,710 136,132 37,500 363.0%450,000 42,422 Road & Bridge Tax - - 2,917 0.0%35,000 - Local Use Tax 24,934 29,340 25,000 117.4%300,000 4,406 Cannabis Use Tax 1,154 1,036 1,325 78.2%15,900 (117) Grants 264 - 1,305 0.0%15,662 (264) Utility/Telecom. Tax 573,784 539,284 468,583 115.1%5,623,000 (34,500) Licenses and Permits 47,123 102,270 162,540 62.9%1,950,485 55,147 Charges for Services 212,553 38,616 137,281 28.1%1,647,370 (173,937) Investment Interest 7,214 - 16,667 0.0%200,000 (7,214) Miscellaneous Income 15,710 91,620 85,296 107.4%1,023,551 75,910 Total Operating Revenues 2,527,573$ 2,499,208$ 2,367,164$ 105.6%28,405,969$ (28,365)$ OPERATING EXPENDITURES Personnel 1,431,552$ 1,190,410$ 1,844,754$ 64.5%22,137,051$ (241,142)$ Materials and Supplies 33,004 13,608 49,755 27.3%597,056 (19,396)$ Operation and Contract 267,769 148,645 450,394 33.0%5,404,722 (119,124)$ Other Expenditures 2,142 - 750 0.0%9,000 (2,142)$ Capital Outlay - 109 79,215 0.1%950,575 109$ Total Operating Expenditures 1,734,467$ 1,352,772$ 2,424,867$ 55.8%29,098,405$ (381,695)$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 793,106$ 1,146,436$ (57,703)$ -1986.8%(692,436)$ 353,330$ INTERFUND TRANSACTIONS Transfers In -$ -$ -$ N/A 677,401$ -$ Transfers Out - N/A - Reimbursements From Other Funds 47,102 - - N/A - (47,102) Reimbursements To Other Funds (9,157) - - N/A - 9,157 Sports Core Loan - N/A - - Total Interfund Transactions 37,945$ -$ -$ N/A 677,401$ (37,945)$ NET FUND INCREASE (DECREASE)831,051$ 1,146,436$ (57,703)$ (15,035)$ 315,385$ *Includes the collection of Income Tax, Use Tax, Road & Bridge Tax, Personal Property Replacement Tax, and Cannabis Use Tax. Village of Oak Brook General Fund Financial Update For the Period Ending January 31, 2023 1/31/23 1/31/23 1/31/22 1/31/23 YTD % of YTD 2023 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Hotel Tax 91,777$ 94,710$ 95,833$ 98.8%1,150,000$ 2,933$ Investment Interest 511 4,457 1,000 445.7%12,000 3,946 Loan Interest - - 333 0.0%4,000 - Miscellaneous - - Total Operating Revenues 92,288$ 99,167$ 97,167$ 102.1%1,166,000$ 6,879$ EXPENDITURES Operation and Contract 10,000$ -$ 56,216$ 0.0%674,595$ (10,000)$ Capital Outlay - - - N/A - - Total Expenditures 10,000$ -$ 56,216$ 0.0%674,595$ (10,000)$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 82,288$ 99,167$ 40,950$ 242.2%491,405$ 16,879$ INTERFUND TRANSACTIONS Transfer Out -$ -$ -$ N/A -$ -$ Reimbursements to Other Funds (6,900) - (29,124) 0.0%(349,485) 6,900 Total Interfund Transactions (6,900)$ -$ (29,124)$ 0.0%(349,485)$ 6,900$ NET FUND INCREASE (DECREASE)75,388$ 99,167$ 11,827$ 141,920$ 23,779$ Note - Expenditures are recorded in program 171. Village of Oak Brook Hotel Tax Fund Financial Update For the Period Ending January 31, 2023 1/31/23 1/31/23 1/31/22 1/31/23 YTD % of YTD 2023 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Non-Home Rule Sales Tax 583,906$ 580,095$ 543,750$ 106.7%6,525,000$ (3,811)$ Charges for Services - - N/A -$ Investment Interest 2,210 14,863 2,292 648.6%27,500 12,653 Grants - - 90,811 0.0%1,089,730 - Miscellaneous - - 83 0.0%1,000 - Total Operating Revenues 586,116$ 594,958$ 636,936$ 93.4%7,643,230$ 8,842$ OPERATING EXPENDITURES Personnel 123,065$ 3,936$ 3,775$ 104.3%45,294$ (119,129)$ Materials and Supplies 2,321 1,106 16,450 6.7%197,400 (1,215) Operation and Contract 40,197 - 144,182 0.0%1,730,180 (40,197) Other Expenditures - - - N/A - Capital Outlay - - 768,860 0.0%9,226,320 - Total Operating Expenditures 165,583$ 5,042$ 933,266$ 0.5%11,199,194$ (160,541)$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 420,533$ 589,916$ (296,330)$ -199.1%(3,555,964)$ 169,383$ INTERFUND TRANSACTIONS Transfers In -$ -$ -$ N/A -$ -$ Reimbursements From Other Funds 26,948 - - N/A - (26,948) Reimbursements To Other Funds (9,844) - - N/A - 9,844 Total Interfund Transactions 17,104$ -$ -$ N/A -$ (17,104)$ NET FUND INCREASE (DECREASE)437,637$ 589,916$ (296,330)$ (3,555,964)$ 152,279$ Village of Oak Brook Infrastructure Fund Financial Update For the Period Ending January 31, 2023 1/31/23 1/31/23 1/31/22 1/31/23 YTD % of YTD 2023 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax -$ -$ 1,250$ 0.0%15,000$ -$ Real Estate Tax - - 33,750 0.0%405,000 - Investment Interest 11 11 1 1320.0%10 - Total Operating Revenues 11$ 11$ 35,001$ 0.0%420,010$ -$ EXPENDITURES Operation and Contract -$ -$ 425$ 0.0%5,100$ -$ Other Expenditures 243,150 - 28,060 0.0%336,725 (243,150) Total Expenditures 243,150$ -$ 28,485$ 0.0%341,825$ (243,150)$ NET FUND INCREASE (DECREASE)(243,139)$ 11$ 6,515$ 78,185$ 243,150$ Note - Expenditures are recorded in program 283. Village of Oak Brook Promenade TIF Fund Financial Update For the Period Ending January 31, 2023 1/31/23 1/31/23 1/31/22 1/31/23 YTD % of YTD 2023 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Plan Review Fees 150$ 150$ 44$ 342.9%525$ -$ Building/Inspection Fees 150 150 167 90.0%2,000 - Water Sales 998,793 794,475 685,833 115.8%8,230,000 (204,318) Unmetered Sales 38,979 3,275 4,167 78.6%50,000 (35,704) Water Connection Fees 4,370 1,610 6,250 25.8%75,000 (2,760) Fire Service Charge - - - N/A - - Meter Charges 1,040 330 1,250 26.4%15,000 (710) Special Services - 576 833 69.2%10,000 576 Investment Interest - 48,213 1,667 2892.8%20,000 48,213 Proceeds from Property Sale 1,643 - - N/A - (1,643) Miscellaneous 97 11,334 4,167 272.0%50,000 11,237 Total Operating Revenues 1,045,222$ 860,113$ 704,377$ 122.1%8,452,525$ (185,109)$ OPERATING EXPENDITURES Personnel 36,523$ 36,207$ 53,968$ 67.1%647,620$ (316)$ Materials and Supplies 3,413 1,256 5,804 21.6%69,650 (2,157) Operation and Contract 18,384 40 450,052 0.0%5,400,625 (18,344) Capital Outlay 3,894 - 327,083 0.0%3,925,000 (3,894) Total Expenditures 62,214$ 37,503$ 836,908$ 4.5%10,042,895$ (24,711)$ Surplus (Deficit) of Revenues Over Expenditures 983,008$ 822,610$ (132,531)$ -620.7%(1,590,370)$ (160,398)$ INTERFUND TRANSACTIONS Reimbursements To Other Funds (35,041)$ -$ (35,041)$ 0.0%(420,490)$ 35,041$ Total Interfund Transactions (35,041)$ -$ (35,041)$ 0.0%(420,490)$ 35,041$ Fund Increase/(Decrease) - Budgetary Basis 947,967$ 822,610$ (167,572)$ (2,010,860)$ (125,357)$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay 3,894$ -$ Depreciation Expense (47,917) (47,917) IMRF Pension Expense (3,750) (3,750) OPEB Expense (2,500) (2,500) Total GAAP Adjustments (50,273)$ (54,167)$ Fund Increase/(Decrease) - GAAP Basis 897,694$ 768,443$ *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 January 31, 2023 Village of Oak Brook Monthly Operating Statement Sports Core Fund Consolidated Presentation For the Period Ending January 31, 2023 1/31/23 1/31/23 1/31/23 YTD % of YTD 2023 1/31/22 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 -$ -$ -$ -$ -$ 77,438$ 0.0%929,250$ -$ -$ Greens Fees - - - - - 109,167 0.0%1,310,000 - - Pro Shop Sales - - - 146 146 20,833 0.7%250,000 4,496 (4,350) Golf Lessons - - - - - 4,167 0.0%50,000 - - Driving Range Fees - - - - - 29,167 0.0%350,000 - - Rentals - 1,500 1,031 - 2,531 90,333 2.8%1,084,000 711 1,820 Programs/User Fees - - - - - 5,758 0.0%69,100 - - Food Sales - - - 162 162 24,167 0.7%290,000 497 (335) Beverage Sales - - - 1,742 1,742 41,000 4.2%492,000 2,070 (328) Taste of Oak Brook - - - - - - N/A - - - Grants - - - - - - N/A - - - Other Revenue 210 - - (8) 202 2,302 8.8%27,625 55 147 Total Operating Revenues 210$ 1,500$ 1,031$ 2,042$ 4,783$ 404,331$ 1.2%4,851,975$ 7,829$ (3,046)$ OPERATING EXPENDITURES Personnel -$ -$ 690$ 39,367$ 40,057$ 144,027$ 27.8%1,671,380$ 62,828$ (22,771)$ Materials & Supplies (123) - 1,226 8,110 9,213 68,503 13.4%718,900 4,870 4,343 Operational & Contractual - - - 8,214 8,214 62,985 13.0%942,765 8,846 (632) Other - - - - - - N/A - - - Capital - - - 162,946 162,946 131,563 123.9%466,750 - 162,946 Total Operating Expenditures (123)$ -$ 1,916$ 218,637$ 220,430$ 407,077$ 54.1%3,799,795$ 76,544$ 143,886$ B&T Administration Overhead Allocation*-$ -$ -$ -$ -$ -$ N/A -$ -$ -$ Operating Revenues Over (Under) Expenditures 333$ 1,500$ (885)$ (216,595)$ (215,647)$ (2,746)$ 7853.6%1,052,180$ (68,715)$ (146,932)$ INTERFUND TRANSACTIONS Interfund Loan**-$ -$ -$ -$ -$ -$ N/A -$ -$ -$ Transfer From General Fund - - - - - - N/A - - - Transfer From Golf Surcharge Fund - - - - - 12,500 0.0%150,000 - - Reimbursement From Infrastructure Fund - - - - - - N/A - - - Reimbursement From Water Fund - - - - - - N/A - - - Reimbursement To General Fund - - - - - (6,747) 0.0%(80,967) (6,288) 6,288 Total Interfund Transactions -$ -$ -$ -$ -$ 5,753$ 0.0%69,033$ (6,288)$ 6,288$ Total Revenues Over (Under) Expenditures - Budgetary Basis 333$ 1,500$ (885)$ (216,595)$ (215,647)$ 3,007$ 1,121,213$ (75,003)$ (140,644)$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ -$ -$ 162,946$ 162,946$ -$ Depreciation Expense (14,019) (140) (25,000) (20,525) (59,684) (36,652) IMRF Pension Expense (171) - (1,250) (2,042) (3,463) (2,167) OPEB Expense - - (1,250) (2,333) (3,583) (2,175) Total GAAP Adjustments (14,190)$ (140)$ (27,500)$ 138,046$ 96,216$ (40,993)$ Fund Increase/(Decrease) - GAAP Basis (13,857)$ 1,360$ (28,385)$ (78,549)$ (119,431)$ (115,996)$ *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 January 31, 2023 1/31/23 1/31/23 822 1/31/23 YTD % of YTD 2023 1/31/22 Difference 811 812 813 Poolside YTD Amended Amended Adopted YTD Prior B&T Admin Swimming Tennis Café Total Budget Budget Budget Total Year OPERATING REVENUES Memberships -$ -$ -$ -$ -$ 43,271$ 0.0%519,250$ -$ -$ Programs/User Fees - - - - - 5,758.33 0.0%69,100 - - Food Sales - - - - - 3,333.33 0.0%40,000 - - Beverage Sales - - - - - 1,416.67 0.0%17,000 - - Grants - - - - - - N/A - - - Other Revenue 210 - - - 210 194 108.4%2,325 50 160 Total Operating Revenues 210$ -$ -$ -$ 210$ 53,973$ 0.4%647,675$ 50$ 160$ OPERATING EXPENDITURES Personnel -$ -$ -$ -$ -$ 16,564$ 0.0%198,768$ 68$ (68)$ Materials & Supplies - (123) - - (123) 5,983 -2.1%71,796 - (123) Operational & Contractual - - - - - 20,582 0.0%246,985 157 (157) Other - - - - - N/A - - Capital - - - - - 45,833 0.0%550,000 - - Total Operating Expenditures -$ (123)$ -$ -$ (123)$ 88,962$ -0.1%1,067,549$ 225$ (348)$ B&T Administration Overhead Allocation*-$ -$ -$ -$ -$ -$ N/A 43,783$ 873$ (873)$ Operating Revenues Over (Under) Expenditures 210$ 123$ -$ -$ 333$ (34,990)$ -1.0%(376,092)$ 698$ (365)$ Transfer From General Fund - - - - - - N/A - - Reimbursement From Infrastructure Fund - - - - - -$ N/A - - - Reimbursement From Water Fund - - - - - - N/A - - - Reimbursement To General Fund - - - - - (1,687) 0.0%(20,242) (1,572) 1,572 Total Interfund Transactions -$ -$ -$ -$ -$ (1,687)$ 0.0%(20,242)$ (1,572)$ 1,572$ Total Revenues Over (Under) Expenditures - Budgetary Basis 210$ 123$ -$ -$ 333$ (36,676)$ (396,334)$ (874)$ 1,207$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ -$ -$ -$ -$ -$ Depreciation Expense (5,363) (8,333) (225) (97) (14,019) (10,622) IMRF Pension Expense (167) - - (4) (171) (83) Total GAAP Adjustments (5,530)$ (8,333)$ (225)$ (102)$ (14,190)$ (10,705)$ Fund Increase/(Decrease) - GAAP Basis (5,320)$ (8,210)$ (225)$ (102)$ (13,857)$ (11,579)$ *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 January 31, 2023 1/31/23 1/31/23 1/31/23 YTD % of YTD 2023 1/31/22 Difference 815 816 YTD Amended Amended Adopted YTD Prior Polo Open Fields Total Budget Budget Budget Total Year OPERATING REVENUES Field Rentals -$ 1,500$ 1,500$ 15,083$ 9.9%181,000$ -$ 1,500$ Range Rentals - - - 7,083 0.0%85,000 - - Taste of Oak Brook - - - - N/A - - - Other Revenue - - - N/A - - - Total Operating Revenues -$ 1,500$ 1,500$ 22,167$ 6.8%266,000$ -$ 1,500$ OPERATING EXPENDITURES Personnel -$ -$ -$ -$ N/A -$ -$ Materials & Supplies - - - 791 0.0%9,490$ - - Operational & Contractual - - - 10,495 0.0%125,940 15 (15) Capital - - - N/A - - Total Operating Expenditures -$ -$ -$ 11,286$ 0.0%135,430$ 15$ (15)$ Operating Revenues Over (Under) Expenditures -$ 1,500$ 1,500$ 10,881$ 13.8%130,570$ (15)$ 1,515$ INTERFUND TRANSACTIONS Transfer From Hotel Tax Fund -$ -$ -$ -$ N/A -$ -$ -$ Total Interfund Transactions -$ -$ -$ -$ N/A -$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis -$ 1,500$ 1,500$ 10,881$ 130,570$ (15)$ 1,515$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ -$ -$ -$ Depreciation Expense - (140) (140) (1,152) Total GAAP Adjustments -$ (140)$ (140)$ (1,152)$ Fund Increase/(Decrease) - GAAP Basis -$ 1,360$ 1,360$ (1,167)$ *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 January 31, 2023 1/31/23 1/31/23 821 YTD % of YTD 2023 1/31/22 Difference B&T Amended Amended Adopted YTD Prior Clubhouse Budget Budget Budget Total Year OPERATING REVENUES Rentals 1,031$ 29,167$ 3.5%350,000$ 728$ 303$ Other Revenue - - 0.0%- - - Total Operating Revenues 1,031$ 29,167$ 3.5%350,000$ 728$ 303$ OPERATING EXPENDITURES Personnel 690$ 11,913$ 5.8%142,954$ 9,769$ (9,079)$ Materials & Supplies 1,226 1,998 61.4%23,972 - 1,226 Operational & Contractual - 6,403 0.0%76,842 433 (433) Capital - - N/A - - - Total Operating Expenditures 1,916$ 20,314$ 9.4%243,767$ 10,202$ (8,286)$ B&T Administration Overhead Allocation*-$ -$ N/A (43,784)$ (873)$ 873$ Operating Revenues Over (Under) Expenditures (885)$ 8,853$ -10.0%62,449$ (10,347)$ 9,462$ INTERFUND TRANSACTIONS Transfer From General Fund -$ -$ 0.0%-$ -$ -$ Total Interfund Transactions -$ -$ 0.0%-$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis (885)$ 8,853$ 62,449$ (10,347)$ 9,462$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ -$ Depreciation Expense (25,000) (5,217) IMRF Pension Expense (1,250) (167) OPEB Expense (1,250) (250) Total GAAP Adjustments (27,500)$ (5,633)$ Fund Increase/(Decrease) - GAAP Basis (28,385)$ (15,980)$ *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 January 31, 2023 1/31/23 1/31/23 823 831 832 833 834 1/31/23 YTD % of YTD 2023 1/31/22 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 -$ -$ -$ -$ -$ -$ 34,167$ 0.0%410,000$ -$ -$ Greens Fees - - - - - - 109,167 0.0%1,310,000 - - Pro Shop Sales - 146 - - - 146 20,833 0.7%250,000 4,496 (4,350) Golf Lessons - - - - - - 4,167 0.0%50,000 - - Driving Range Fees - - - - - - 29,167 0.0%350,000 - - Rentals - - - - - - 39,000 0.0%468,000 (17) 17 Food Sales 162 - - - - 162 20,833 0.8%250,000 497 (335) Beverage Sales 1,742 - - - - 1,742 39,583 4.4%475,000 2,070 (328) Other Revenue 2 (10) - - - (8) 2,108 -0.4%25,300 5 (13) Total Operating Revenues 1,906$ 136$ -$ -$ -$ 2,042$ 299,025$ 0.7%3,588,300$ 7,051$ (5,009)$ OPERATING EXPENDITURES Personnel 4,337$ 23,184$ -$ -$ 11,846$ 39,367$ 115,550$ 34.1%1,386,598$ 52,991$ (13,624)$ Materials & Supplies 1,209 3,844 - - 3,057 8,110 59,732 13.6%716,780 4,870 3,240 Operational & Contractual 408 257 - - 7,549 8,214 25,504 32.2%306,050 8,241 (27) Other - - - - - - - N/A - - - Capital - - - - 162,946 162,946 85,729 190.1%1,028,751 - 162,946 Total Operating Expenditures 5,954$ 27,285$ -$ -$ 185,398$ 218,637$ 286,515$ 76.3%3,438,178$ 66,102$ 152,535$ Operating Revenues Over (Under) Expenditures (4,048)$ (27,149)$ -$ -$ (185,398)$ (216,595)$ 12,510$ -1731.4%150,122$ (59,051)$ (157,544)$ INTERFUND TRANSACTIONS Transfer from Golf Surcharge -$ -$ -$ -$ -$ -$ 12,500$ 0.0%150,000$ -$ -$ Reimbursement to General Fund - - - - - - (5,060) 0.0%(60,725) (4,716) 4,716 Total Interfund Transactions -$ -$ -$ -$ -$ -$ 7,440$ 0.0%89,275$ (4,716)$ 4,716$ Total Revenues Over (Under) Expenditures - Budgetary Basis (4,048)$ (27,149)$ -$ -$ (185,398)$ (216,595)$ 19,950$ 239,397$ (63,767)$ (152,828)$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay -$ -$ -$ -$ 162,946$ 162,946$ -$ Depreciation Expense (83) (8,750) (192) (1,083) (10,417) (20,525) (19,661) IMRF Pension Expense (208) (833) (83) - (917) (2,042) (1,917) OPEB Expense (250) (1,250) - - (833) (2,333) (1,925) Total GAAP Adjustments (542)$ (10,833)$ (275)$ (1,083)$ 150,779$ 138,046$ (23,503)$ Fund Increase/(Decrease) - GAAP Basis (4,590)$ (37,982)$ (275)$ (1,083)$ (34,619)$ (78,549)$ (87,270)$ *Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.