Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
03 - March 2024 Monthly Financial Report
VILLAGE OAK BROOKOF MONTHLY FINANCIAL REPORTS MARCH 2024 Estimated YTD YTD Net Fund Ending YTD YTD Increase Fund Balance Governmental Funds Revenues Expenditures (Decrease)(Deficit) General Fund (Major Fund)8,185,236$ 6,609,030$ 1,576,207$ 44,201,595$ Main operating fund of the Village. Hotel Fund (Major Fund)374,571$ 84,558$ 290,014$ 4,061,211$ Collects and spends resources from the 3% hotel/motel tax. Motor Fuel Tax Fund 119,082$ 44,393$ 74,689$ 2,096,791$ Collects and spends resources from the State motor fuel tax. Infrastructure Fund (Major Fund)2,323,581$ 257,906$ 2,065,675$ 16,490,182$ Accounts for construction and maintenance of roadways, drainage, and safety path systems. Enterprise Funds Water Fund (Major Fund)2,302,168$ 1,168,834$ 1,133,334$ 23,051,976$ Collects user fees for the distribution of water and maintenance of infrastructure. Sports Core Fund (Major Fund)434,861$ 508,398$ (73,538)$ 2,830,351$ Accounts for revenues and expenses relating to administration, programs, food and beverage operations, and golf course. Internal Service Funds Insurance Fund 508,445$ 999,911$ (491,466)$ 73,977$ Accounts for the Village's health insurance costs and the related contributions from the Village, employees, retirees, and other agencies. Garage Fund 184,500$ 132,783$ 51,717$ 398,191$ Accounts for the maintenance of the Village's vehicle fleet and the related departmental reimbursements. Equipment Replacement Fund 351,576$ 116,744$ 234,832$ 3,282,789$ 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 March 31, 2024 3/31/24 3/31/24 3/31/23 3/31/24 YTD % of YTD 2024 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax 5,137,363$ 4,998,802 4,124,151$ 121.2%16,496,604$ (138,562)$ State Income Tax 312,760 333,460 327,750 101.7%1,311,000 20,700 Replacement Tax 222,971 139,548 187,754 74.3%751,015 (83,423) Road & Bridge Tax - 15,433 8,750 176.4%35,000 15,433 Local Use Tax 97,680 90,918 84,000 108.2%336,000 (6,762) Cannabis Use Tax 3,079 3,327 3,295 101.0%13,180 248 Grants - 151,500 41,416 365.8%165,662 151,500 Utility/Telecom. Tax 1,310,982 736,254 1,150,000 64.0%4,600,000 (574,728) Licenses and Permits 1,639,847 685,561 561,953 122.0%2,247,810 (954,287) Charges for Services 892,133 275,243 543,663 50.6%2,174,650 (616,890) Investment Interest 200,216 275,341 112,500 244.7%450,000 75,125 Miscellaneous Income 161,747 260,865 229,017 113.9%916,070 99,118 Total Operating Revenues 9,978,779$ 7,966,251$ 7,374,248$ 108.0%29,496,991$ (2,012,527)$ OPERATING EXPENDITURES Personnel 4,336,723$ 4,695,343$ 5,641,303$ 83.2%22,565,214$ 358,620$ Materials and Supplies 123,804 112,980 165,399 68.3%661,594 (10,824)$ Operation and Contract 1,198,739 1,770,749 1,581,078 112.0%6,324,313 572,010$ Other Expenditures 2,147 2,123 2,475 85.8%9,900 (24)$ Capital Outlay 3,312 27,835 165,777 16.8%663,107 24,522$ Total Operating Expenditures 5,664,725$ 6,609,030$ 7,556,032$ 87.5%30,224,129$ 944,304$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 4,314,053$ 1,357,222$ (181,784)$ -746.6%(727,137)$ (2,956,831)$ INTERFUND TRANSACTIONS Transfers In -$ -$ -$ N/A -$ -$ Transfers Out N/A - Reimbursements From Other Funds 195,428 218,985 218,985 100.0%875,938 23,557 Reimbursements To Other Funds - - 25,000 0.0%100,000 - Sports Core Loan N/A - - Total Interfund Transactions 195,428$ 218,985$ 243,985$ 89.8%975,938$ 23,557$ NET FUND INCREASE (DECREASE)4,509,482$ 1,576,207$ 62,200$ 248,801$ (2,933,275)$ Village of Oak Brook General Fund Financial Update For the Period Ending March 31, 2024 3/31/24 3/31/24 3/31/23 3/31/24 YTD % of YTD 2024 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Hotel Tax 286,749$ 348,059$ 362,500$ 96.0%1,450,000$ 61,310$ Investment Interest 15,201 26,512 6,250 424.2%25,000 11,311 Loan Interest - - 500 0.0%2,000 - Miscellaneous - - - - Total Operating Revenues 301,950$ 374,571$ 369,250$ 101.4%1,477,000$ 72,621$ EXPENDITURES Operation and Contract 12,546$ 20,673$ 176,261$ 11.7%705,045$ 8,127$ Capital Outlay - 2,906 68,750 4.2%275,000 2,906 Total Expenditures 12,546$ 23,580$ 245,011$ 9.6%980,045$ 11,034$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 289,404$ 350,992$ 124,239$ 282.5%496,955$ 61,588$ INTERFUND TRANSACTIONS Transfer Out -$ -$ -$ N/A -$ -$ Reimbursements to Other Funds (87,371) (60,978) (60,979) 100.0%(243,915) 26,393 Total Interfund Transactions (87,371)$ (60,978)$ (60,979)$ 100.0%(243,915)$ 26,393$ NET FUND INCREASE (DECREASE)202,033$ 290,014$ 63,260$ 253,040$ 87,981$ Note - Expenditures are recorded in program 171. Village of Oak Brook Hotel Tax Fund Financial Update For the Period Ending March 31, 2024 3/31/24 3/31/24 3/31/23 3/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 2,161,371$ 2,204,203$ 1,675,750$ 131.5%6,703,000$ 42,832$ Charges for Services - N/A -$ Investment Interest 47,474 117,388 31,250 375.6%125,000 69,914 Grants - - - N/A - - Miscellaneous - 1,990 5,750 34.6%23,000 1,990 Total Operating Revenues 2,208,845$ 2,323,581$ 1,712,750$ 135.7%6,851,000$ 114,736$ OPERATING EXPENDITURES Personnel 27,904$ 40,775$ -$ N/A -$ 12,872$ Materials and Supplies 101,740 32 11,625 0.3%46,500 (101,707) Operation and Contract 151,276 202,806 435,742 46.5%1,742,968 51,530 Other Expenditures - - 84,975 0.0%339,899 - Capital Outlay 1,314,661 6,291 845,944 0.7%3,383,775 (1,308,370) Total Operating Expenditures 1,595,580$ 249,905$ 1,378,286$ 18.1%5,513,142$ (1,345,675)$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 613,265$ 2,073,676$ 334,464$ 620.0%1,337,858$ 1,460,411$ INTERFUND TRANSACTIONS Transfers In -$ -$ -$ N/A -$ -$ Reimbursements From Other Funds 54,390 - - N/A - (54,390) Reimbursements To Other Funds (84,975) (8,001) - N/A - 76,974 Total Interfund Transactions (30,585)$ (8,001)$ -$ N/A -$ 22,584$ NET FUND INCREASE (DECREASE)582,680$ 2,065,675$ 334,464$ 1,337,858$ 1,482,995$ Village of Oak Brook Infrastructure Fund Financial Update For the Period Ending March 31, 2024 3/31/24 3/31/24 3/31/23 3/31/24 YTD % of YTD 2024 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Plan Review Fees 525$ 152$ 131$ 115.6%525$ (373)$ Building/Inspection Fees 600 - 500 0.0%2,000 (600) Water Sales 1,856,638 2,051,167 2,680,000 76.5%10,720,000 194,529 Unmetered Sales 6,016 12,926 16,250 79.5%65,000 6,910 Water Connection Fees 107,410 15,870 35,000 45.3%140,000 (91,540) Fire Service Charge - - N/A - - Meter Charges 6,887 3,790 4,325 87.6%17,300 (3,097) Special Services 12,811 - 2,500 0.0%10,000 (12,811) Investment Interest 179,628 197,211 87,500 225.4%350,000 17,583 Proceeds from Property Sale - - - N/A - - Miscellaneous 33,172 21,052 287,433 7.3%1,149,730 (12,120) Total Operating Revenues 2,203,687$ 2,302,168$ 3,113,639$ 73.9%12,454,555$ 98,480$ OPERATING EXPENDITURES Personnel 129,433$ 151,296$ 196,603$ 77.0%786,413$ 21,863$ Materials and Supplies 17,129 27,521 34,304 80.2%137,216 10,393 Operation and Contract 733,598 880,695 1,775,342 49.6%7,101,369 147,096 Capital Outlay - 101 1,422,500 0.0%5,690,000 101 Total Expenditures 880,160$ 1,059,613$ 3,428,750$ 30.9%13,714,999$ 179,453$ Surplus (Deficit) of Revenues Over Expenditures 1,323,527$ 1,242,555$ (315,111)$ -394.3%(1,260,444)$ (80,973)$ INTERFUND TRANSACTIONS Reimbursements To Other Funds (46,649)$ (109,221)$ (109,220)$ 100.0%(436,879)$ (62,572)$ Total Interfund Transactions (46,649)$ (109,221)$ (109,220)$ 100.0%(436,879)$ (62,572)$ Fund Increase/(Decrease) - Budgetary Basis 1,276,879$ 1,133,334$ (424,331)$ (1,697,323)$ (143,545)$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay -$ 101$ Depreciation Expense (95,833) (143,750) IMRF Pension Expense (7,500) (11,250) OPEB Expense (5,000) (7,500) Total GAAP Adjustments (108,333)$ (162,399)$ Fund Increase/(Decrease) - GAAP Basis 1,168,545$ 970,935$ *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 March 31, 2024 Village of Oak Brook Monthly Operating Statement Sports Core Fund Consolidated Presentation For the Period Ending March 31, 2024 3/31/24 3/31/24 3/31/24 YTD % of YTD 2024 3/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 71,550$ -$ -$ 232,025$ 303,575$ 237,681$ 127.7%950,725$ 246,450$ 57,125$ Greens Fees - - - 25,932 25,932 351,250 7.4%1,405,000 2,476 23,457 Pro Shop Sales - - - 5,681 5,681 54,500 10.4%218,000 12,929 (7,249) Golf Lessons - - - 6,475 6,475 11,250 57.6%45,000 5,940 535 Driving Range Fees - - - 53,694 53,694 97,500 55.1%390,000 49,510 4,184 Rentals - 5,250 22,053 8,228 35,531 249,550 14.2%998,200 93,052 (57,520) Programs/User Fees - - - - - 27,450 0.0%109,800 - - Food Sales - - - - - 11,975 0.0%47,900 497 (497) Beverage Sales - - - - - 19,413 0.0%77,650 3,139 (3,139) Taste of Oak Brook - - - - - - N/A - - - Grants - - - - - - N/A - - - Other Revenue 2,588 - - 1,385 3,972 24,790 16.0%99,160 443 3,530 Total Operating Revenues 74,138$ 5,250$ 22,053$ 333,420$ 434,861$ 1,085,359$ 40.1%4,341,435$ 414,434$ 20,426$ OPERATING EXPENDITURES Personnel -$ -$ -$ 159,996$ 159,996$ 348,745$ 45.9%1,671,380$ 177,085$ (17,089)$ Materials & Supplies 2,215 - 3,752 20,324 26,291 108,313 24.3%718,900 (17,527) 43,819 Operational & Contractual 132,071 927 11,890 91,801 236,689 271,061 87.3%942,765 137,933 98,756 Other 12,696 - - - 12,696 - N/A - - 12,696 Capital 13,586 - - 21,048 34,634 269,064 12.9%466,750 39,965 (5,330) Total Operating Expenditures 160,568$ 927$ 15,642$ 293,169$ 470,307$ 997,183$ 47.2%3,799,795$ 337,456$ 132,851$ B&T Administration Overhead Allocation*-$ -$ -$ -$ -$ -$ N/A -$ -$ -$ Operating Revenues Over (Under) Expenditures (86,431)$ 4,323$ 6,411$ 40,250$ (35,447)$ 88,176$ -40.2%541,640$ 76,978$ (112,425)$ INTERFUND TRANSACTIONS Interfund Loan**-$ -$ -$ -$ -$ -$ N/A -$ -$ -$ Transfer From General Fund - - - - - - N/A - - - Transfer From Golf Surcharge Fund - - - - - (6,239) 0.0%(24,957) - - Reimbursement From Infrastructure Fund - - - - - - N/A - - - Reimbursement From Water Fund - - - - - 10,000 0.0%40,000 - - Reimbursement To General Fund - - - (38,091) (38,091) (43,150) 88.3%(172,600) - (38,091) Total Interfund Transactions -$ -$ -$ (38,091)$ (38,091)$ (39,389)$ 96.7%(157,557)$ -$ (38,091)$ Total Revenues Over (Under) Expenditures - Budgetary Basis (86,431)$ 4,323$ 6,411$ 2,159$ (73,538)$ 48,787$ 384,083$ 76,978$ (150,516)$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay 13,586$ -$ -$ 21,048$ 34,634$ 39,965$ Depreciation Expense (42,057) (421) (25,000) (61,575) (129,053) (129,053) IMRF Pension Expense (513) - (1,250) (6,125) (7,888) (7,888) OPEB Expense - - (1,250) (7,000) (8,250) (8,250) Total GAAP Adjustments (28,983)$ (421)$ (27,500)$ (53,652)$ (110,556)$ (105,226)$ Fund Increase/(Decrease) - GAAP Basis (115,414)$ 3,901$ (21,089)$ (51,493)$ (184,094)$ (28,248)$ *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 March 31, 2024 3/31/24 3/31/24 822 3/31/24 YTD % of YTD 2024 3/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 -$ 70,550$ 1,000$ -$ 71,550$ 110,694$ 64.6%442,775$ -$ 71,550$ Programs/User Fees - - - - - 27,450.00 0.0%109,800 - - Food Sales - - - - - 1,500.00 0.0%6,000 - - Beverage Sales - - - - - 600.00 0.0%2,400 - - Grants - - - - - - N/A - - - Other Revenue 588 - - 2,000 2,588 22,540 11.5%90,160 443 2,145 Total Operating Revenues 588$ 70,550$ 1,000$ 2,000$ 74,138$ 162,784$ 45.5%651,135$ 443$ 73,695$ OPERATING EXPENDITURES Personnel -$ -$ -$ -$ -$ 62,972$ 0.0%251,888$ -$ -$ Materials & Supplies - 2,151 - 63 2,215 11,345 19.5%45,380 5,098 (2,883) Operational & Contractual 80,802 50,342 927 - 132,071 143,258 92.2%573,034 62,897 69,175 Other 12,696 - - - 12,696 - N/A - - 12,696 Capital 1,830 11,757 - - 13,586 218,625 6.2%874,500 - 13,586 Total Operating Expenditures 95,328$ 64,250$ 927$ 63$ 160,568$ 436,200$ 36.8%1,744,801$ 67,995$ 92,574$ B&T Administration Overhead Allocation*-$ -$ -$ -$ -$ -$ N/A 37,457$ -$ -$ Operating Revenues Over (Under) Expenditures (94,740)$ 6,300$ 73$ 1,937$ (86,431)$ (273,417)$ 31.6%(1,056,210)$ (67,552)$ (18,879)$ Transfer From General Fund - - - - - - N/A - - Reimbursement From Infrastructure Fund - - - - - -$ N/A - - - Reimbursement From Water Fund 10,002 - - - - 10,000 0.0%40,000 - - Reimbursement To General Fund - - - - - (5,061) 0.0%(20,242) - - Total Interfund Transactions 10,002$ -$ -$ -$ -$ 4,940$ 0.0%19,758$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis (84,738)$ 6,300$ 73$ 1,937$ (86,431)$ (268,477)$ (1,036,452)$ (67,552)$ (18,879)$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay 1,830$ 11,757$ -$ -$ 13,586$ -$ Depreciation Expense (16,090) (25,000) (675) (292) (42,057) (42,057) IMRF Pension Expense (500) - - (13) (513) (513) Total GAAP Adjustments (14,760)$ (13,244)$ (675)$ (305)$ (28,983)$ (42,569)$ Fund Increase/(Decrease) - GAAP Basis (99,498)$ (6,943)$ (602)$ 1,632$ (115,414)$ (110,121)$ *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 o 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 March 31, 2024 3/31/24 3/31/24 3/31/24 YTD % of YTD 2024 3/31/23 Difference 815 816 YTD Amended Amended Adopted YTD Prior Polo Open Fields Total Budget Budget Budget Total Year OPERATING REVENUES Field Rentals -$ 5,250$ 5,250$ 48,250$ 10.9%193,000$ 4,500$ 750$ Range Rentals - - - - N/A - - - Taste of Oak Brook - - - - N/A - - - Other Revenue - - - N/A - - - Total Operating Revenues -$ 5,250$ 5,250$ 48,250$ 10.9%193,000$ 4,500$ 750$ OPERATING EXPENDITURES Personnel -$ -$ -$ -$ N/A -$ -$ Materials & Supplies - - - 2,373 0.0%9,490$ - - Operational & Contractual - 927 927 19,013 4.9%76,050 18,181 (17,254) Other - - N/A - - - Capital - - - 11,500 0.0%46,000 - - Total Operating Expenditures -$ 927$ 927$ 32,885$ 2.8%131,540$ 18,181$ (17,254)$ Operating Revenues Over (Under) Expenditures -$ 4,323$ 4,323$ 15,365$ 28.1%61,460$ (13,681)$ 18,004$ INTERFUND TRANSACTIONS Transfer From Hotel Tax Fund -$ -$ -$ -$ N/A -$ -$ -$ Total Interfund Transactions -$ -$ -$ -$ N/A -$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis -$ 4,323$ 4,323$ 15,365$ 61,460$ (13,681)$ 18,004$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ -$ -$ -$ Depreciation Expense - (421) (421) (421) Total GAAP Adjustments -$ (421)$ (421)$ (421)$ Fund Increase/(Decrease) - GAAP Basis -$ 3,901$ 3,901$ (14,103)$ *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 March 31, 2024 3/31/24 3/31/24 821 YTD % of YTD 2024 3/31/23 Difference B&T Amended Amended Adopted YTD Prior Clubhouse Budget Budget Budget Total Year OPERATING REVENUES Rentals 22,053$ 58,250$ 37.9%233,000$ 87,500$ (65,447)$ Other Revenue - - 0.0%- - - Total Operating Revenues 22,053$ 58,250$ 37.9%233,000$ 87,500$ (65,447)$ OPERATING EXPENDITURES Personnel -$ -$ N/A -$ 35,738$ (35,738)$ Materials & Supplies 3,752 3,438 109.2%13,750 5,993 (2,241) Operational & Contractual 11,890 13,245 89.8%52,978 19,210 (7,321) Capital - - N/A - - - Total Operating Expenditures 15,642$ 16,682$ 93.8%66,728$ 60,942$ (45,300)$ B&T Administration Overhead Allocation*-$ -$ N/A (12,500)$ -$ -$ Operating Revenues Over (Under) Expenditures 6,411$ 41,568$ 15.4%153,772$ 26,558$ (20,147)$ INTERFUND TRANSACTIONS Transfer From General Fund -$ -$ 0.0%-$ -$ -$ Total Interfund Transactions -$ -$ 0.0%-$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis 6,411$ 41,568$ 153,772$ 26,558$ (20,147)$ 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 (21,089)$ (942)$ *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 March 31, 2024 3/31/24 3/31/24 823 831 832 833 834 3/31/24 YTD % of YTD 2024 3/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 -$ 232,025$ -$ -$ -$ 232,025$ 126,988$ 182.7%507,950$ 246,450$ (14,425)$ Greens Fees - 25,932 - - - 25,932 351,250 7.4%1,405,000 2,476 23,457 Pro Shop Sales - 5,681 - - - 5,681 54,500 10.4%218,000 12,929 (7,249) Golf Lessons - - 6,475 - - 6,475 11,250 57.6%45,000 5,940 535 Driving Range Fees - - 53,694 - - 53,694 97,500 55.1%390,000 49,510 4,184 Rentals 5,000 - - 3,228 - 8,228 143,050 5.8%572,200 1,052 7,177 Food Sales - - - - - - 10,475 0.0%41,900 497 (497) Beverage Sales - - - - - - 18,813 0.0%75,250 3,139 (3,139) Other Revenue - 1,385 - - - 1,385 2,250 61.5%9,000 - 1,385 Total Operating Revenues 5,000$ 265,023$ 60,169$ 3,228$ -$ 333,420$ 816,075$ 40.9%3,264,300$ 321,992$ 11,428$ OPERATING EXPENDITURES Personnel -$ 108,010$ 706$ 220$ 51,061$ 159,996$ 285,773$ 56.0%1,143,092$ 141,347$ 18,649$ Materials & Supplies (16) 5,201 5,469 359 9,311 20,324 91,158 22.3%364,633 (28,618) 48,942 Operational & Contractual - 43,561 - 30,430 17,810 91,801 95,545 96.1%382,181 37,645 54,156 Other - - - - - - - N/A - - - Capital - 9,940 - - 11,108 21,048 38,939 54.1%155,755 39,965 (18,917) Total Operating Expenditures (16)$ 166,712$ 6,175$ 31,009$ 89,290$ 293,169$ 511,415$ 57.3%2,045,661$ 190,338$ 102,831$ Operating Revenues Over (Under) Expenditures 5,016$ 98,311$ 53,994$ (27,781)$ (89,290)$ 40,250$ 304,660$ 13.2%1,218,639$ 131,653$ (91,403)$ INTERFUND TRANSACTIONS Overhead Charge -$ -$ -$ -$ -$ -$ (6,239)$ 0.0%(24,957)$ -$ -$ Transfers from Other Fund - - - - - - - 0.0%150,000 - - Reimbursement to General Fund - (38,091) - - - (38,091) (38,090) 100.0%(152,358) - (38,091) Total Interfund Transactions -$ (38,091)$ -$ -$ -$ (38,091)$ (44,329)$ 85.9%(27,315)$ -$ (38,091)$ Total Revenues Over (Under) Expenditures - Budgetary Basis 5,016$ 60,220$ 53,994$ (27,781)$ (89,290)$ 2,159$ 260,331$ 1,191,324$ 131,653$ (129,494)$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay -$ 9,940$ -$ -$ 11,108$ 21,048$ 39,965$ Depreciation Expense (250) (26,250) (575) (3,250) (31,250) (61,575) (61,575) IMRF Pension Expense (625) (2,500) (250) - (2,750) (6,125) (6,125) OPEB Expense (750) (3,750) - - (2,500) (7,000) (7,000) Total GAAP Adjustments (1,625)$ (22,560)$ (825)$ (3,250)$ (25,392)$ (53,652)$ (34,735)$ Fund Increase/(Decrease) - GAAP Basis 3,391$ 37,660$ 53,169$ (31,031)$ (114,682)$ (51,493)$ 96,918$ *Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.