Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
04 - April 2024 Monthly Financial Report
VILLAGE OAK BROOKOF MONTHLY FINANCIAL REPORTS APRIL 2024 Estimated YTD YTD Net Fund Ending YTD YTD Increase Fund Balance Governmental Funds Revenues Expenditures (Decrease)(Deficit) General Fund (Major Fund)10,894,085$ 8,931,599$ 1,962,486$ 44,587,875$ Main operating fund of the Village. Hotel Fund (Major Fund)494,059$ 134,441$ 359,618$ 4,130,815$ Collects and spends resources from the 3% hotel/motel tax. Motor Fuel Tax Fund 147,133$ 75,965$ 71,169$ 2,093,271$ Collects and spends resources from the State motor fuel tax. Infrastructure Fund (Major Fund)2,917,159$ 619,946$ 2,297,213$ 16,721,720$ Accounts for construction and maintenance of roadways, drainage, and safety path systems. Enterprise Funds Water Fund (Major Fund)2,963,335$ 1,639,011$ 1,324,324$ 23,242,966$ Collects user fees for the distribution of water and maintenance of infrastructure. Sports Core Fund (Major Fund)1,158,249$ 1,606,847$ (448,598)$ 2,455,290$ Accounts for revenues and expenses relating to administration, programs, food and beverage operations, and golf course. Internal Service Funds Insurance Fund 962,529$ 1,263,434$ (300,904)$ 264,539$ Accounts for the Village's health insurance costs and the related contributions from the Village, employees, retirees, and other agencies. Garage Fund 247,997$ 234,774$ 13,222$ 359,697$ 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 April 30, 2024 4/30/24 4/30/24 4/30/23 4/30/24 YTD % of YTD 2024 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax 6,270,207$ 6,116,429 5,498,868$ 111.2%16,496,604$ (153,778)$ State Income Tax 427,265 459,878 437,000 105.2%1,311,000 32,613 Replacement Tax 336,691 196,566 250,338 78.5%751,015 (140,124) Road & Bridge Tax - 15,434 11,667 132.3%35,000 15,434 Local Use Tax 123,871 111,173 112,000 99.3%336,000 (12,698) Cannabis Use Tax 4,245 4,551 4,393 103.6%13,180 306 Grants 718 154,300 55,221 279.4%165,662 153,583 Utility/Telecom. Tax 1,837,121 1,080,456 1,533,333 70.5%4,600,000 (756,665) Licenses and Permits 1,896,887 800,016 749,270 106.8%2,247,810 (1,096,870) Charges for Services 1,070,427 809,318 724,883 111.6%2,174,650 (261,109) Investment Interest 285,147 532,758 150,000 355.2%450,000 247,611 Miscellaneous Income 306,277 321,226 305,357 105.2%916,070 14,949 Total Operating Revenues 12,558,855$ 10,602,105$ 9,832,330$ 107.8%29,496,991$ (1,956,750)$ OPERATING EXPENDITURES Personnel 5,916,535$ 6,368,697$ 7,521,738$ 84.7%22,565,214$ 452,163$ Materials and Supplies 181,484 164,929 220,531 74.8%661,594 (16,554)$ Operation and Contract 1,538,946 2,318,130 2,108,104 110.0%6,324,313 779,184$ Other Expenditures 2,147 2,123 3,300 64.3%9,900 (24)$ Capital Outlay 5,784 77,719 221,036 35.2%663,107 71,935$ Total Operating Expenditures 7,644,895$ 8,931,599$ 10,074,710$ 88.7%30,224,129$ 1,286,704$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 4,913,960$ 1,670,506$ (242,379)$ -689.2%(727,137)$ (3,243,454)$ INTERFUND TRANSACTIONS Transfers In -$ -$ -$ N/A -$ -$ Transfers Out N/A - Reimbursements From Other Funds 260,571 291,980 291,979 100.0%875,938 31,409 Reimbursements To Other Funds - - 33,333 0.0%100,000 - Sports Core Loan N/A - - Total Interfund Transactions 260,571$ 291,980$ 325,313$ 89.8%975,938$ 31,409$ NET FUND INCREASE (DECREASE)5,174,531$ 1,962,486$ 82,934$ 248,801$ (3,212,045)$ Village of Oak Brook General Fund Financial Update For the Period Ending April 30, 2024 4/30/24 4/30/24 4/30/23 4/30/24 YTD % of YTD 2024 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Hotel Tax 373,159$ 441,499$ 483,333$ 91.3%1,450,000$ 68,340$ Investment Interest 21,876 52,560 8,333 630.7%25,000 30,685 Loan Interest - - 667 0.0%2,000 - Miscellaneous - - - - Total Operating Revenues 395,034$ 494,059$ 492,333$ 100.4%1,477,000$ 99,025$ EXPENDITURES Operation and Contract 36,479$ 50,231$ 235,015$ 21.4%705,045$ 13,752$ Capital Outlay - 2,906 91,667 3.2%275,000 2,906 Total Expenditures 36,479$ 53,137$ 326,682$ 16.3%980,045$ 16,658$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 358,555$ 440,922$ 165,652$ 266.2%496,955$ 82,367$ INTERFUND TRANSACTIONS Transfer Out -$ -$ -$ N/A -$ -$ Reimbursements to Other Funds (116,495) (81,304) (81,305) 100.0%(243,915) 35,191 Total Interfund Transactions (116,495)$ (81,304)$ (81,305)$ 100.0%(243,915)$ 35,191$ NET FUND INCREASE (DECREASE)242,060$ 359,618$ 84,347$ 253,040$ 117,558$ Note - Expenditures are recorded in program 171. Village of Oak Brook Hotel Tax Fund Financial Update For the Period Ending April 30, 2024 4/30/24 4/30/24 4/30/23 4/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 2,654,561$ 2,676,068$ 2,234,333$ 119.8%6,703,000$ 21,507$ Charges for Services - - N/A -$ Investment Interest 65,440 239,101 41,667 573.8%125,000 173,660 Grants 225 - - N/A - (225) Miscellaneous - 1,990 7,667 26.0%23,000 1,990 Total Operating Revenues 2,720,226$ 2,917,159$ 2,283,667$ 127.7%6,851,000$ 196,932$ OPERATING EXPENDITURES Personnel 19,508$ 55,208$ -$ N/A -$ 35,701$ Materials and Supplies 101,911 134 15,500 0.9%46,500 (101,777) Operation and Contract 255,967 230,421 580,989 39.7%1,742,968 (25,546) Other Expenditures - - 113,300 0.0%339,899 - Capital Outlay 1,314,661 323,494 1,127,925 28.7%3,383,775 (991,167) Total Operating Expenditures 1,692,047$ 609,258$ 1,837,714$ 33.2%5,513,142$ (1,082,789)$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 1,028,179$ 2,307,901$ 445,953$ 517.5%1,337,858$ 1,279,722$ INTERFUND TRANSACTIONS Transfers In -$ -$ -$ N/A -$ -$ Reimbursements From Other Funds 72,520 - - N/A - (72,520) Reimbursements To Other Funds (113,300) (10,688) - N/A - 102,612 Total Interfund Transactions (40,780)$ (10,688)$ -$ N/A -$ 30,092$ NET FUND INCREASE (DECREASE)987,399$ 2,297,213$ 445,953$ 1,337,858$ 1,309,814$ Village of Oak Brook Infrastructure Fund Financial Update For the Period Ending April 30, 2024 4/30/24 4/30/24 4/30/23 4/30/24 YTD % of YTD 2024 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Plan Review Fees 750$ 152$ 175$ 86.7%525$ (598)$ Building/Inspection Fees 825 - 667 0.0%2,000 (825) Water Sales 2,191,238 2,462,683 3,573,333 68.9%10,720,000 271,446 Unmetered Sales 6,616 17,669 21,667 81.5%65,000 11,052 Water Connection Fees 112,240 20,240 46,667 43.4%140,000 (92,000) Fire Service Charge - - - N/A - - Meter Charges 9,775 4,500 5,767 78.0%17,300 (5,275) Special Services 12,811 - 3,333 0.0%10,000 (12,811) Investment Interest 256,193 424,998 116,667 364.3%350,000 168,805 Proceeds from Property Sale - - - N/A - - Miscellaneous 42,143 33,093 383,243 8.6%1,149,730 (9,050) Total Operating Revenues 2,632,591$ 2,963,335$ 4,151,518$ 71.4%12,454,555$ 330,744$ OPERATING EXPENDITURES Personnel 204,499$ 208,581$ 262,138$ 79.6%786,413$ 4,082$ Materials and Supplies 37,009 32,610 45,739 71.3%137,216 (4,399) Operation and Contract 1,412,919 1,252,091 2,367,123 52.9%7,101,369 (160,828) Capital Outlay - 101 1,896,667 0.0%5,690,000 101 Total Expenditures 1,654,427$ 1,493,383$ 4,571,666$ 32.7%13,714,999$ (161,044)$ Surplus (Deficit) of Revenues Over Expenditures 978,164$ 1,469,952$ (420,148)$ -349.9%(1,260,444)$ 491,787$ INTERFUND TRANSACTIONS Reimbursements To Other Funds (62,198)$ (145,628)$ (145,626)$ 100.0%(436,879)$ (83,430)$ Total Interfund Transactions (62,198)$ (145,628)$ (145,626)$ 100.0%(436,879)$ (83,430)$ Fund Increase/(Decrease) - Budgetary Basis 915,966$ 1,324,324$ (565,774)$ (1,697,323)$ 408,357$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay -$ 101$ Depreciation Expense (191,667) (191,667) IMRF Pension Expense (15,000) (15,000) OPEB Expense (10,000) (10,000) Total GAAP Adjustments (216,667)$ (216,565)$ Fund Increase/(Decrease) - GAAP Basis 699,300$ 1,107,758$ *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 April 30, 2024 Village of Oak Brook Monthly Operating Statement Sports Core Fund Consolidated Presentation For the Period Ending April 30, 2024 4/30/24 4/30/24 4/30/24 YTD % of YTD 2024 4/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 241,635$ -$ -$ 358,450$ 600,085$ 316,908$ 189.4%950,725$ 733,605$ (133,520)$ Greens Fees - - - 165,047 165,047 468,333 35.2%1,405,000 111,789 53,258 Pro Shop Sales - - - 17,202 17,202 72,667 23.7%218,000 50,698 (33,496) Golf Lessons - - - 20,825 20,825 15,000 138.8%45,000 14,015 6,810 Driving Range Fees - - - 134,590 134,590 130,000 103.5%390,000 129,909 4,681 Rentals - 26,111 32,492 72,817 131,420 332,733 39.5%998,200 155,969 (24,548) Programs/User Fees 3,530 - - - 3,530 36,600 9.6%109,800 5,157 (1,627) Food Sales - - - 990 990 15,967 6.2%47,900 24,883 (23,893) Beverage Sales - - - - - 25,883 0.0%77,650 45,347 (45,347) Taste of Oak Brook - - - - - - N/A - - - Grants - - - - - - N/A - - - Other Revenue 91,441 - - 1,439 92,880 33,053 281.0%99,160 2,136 90,744 Total Operating Revenues 336,606$ 26,111$ 32,492$ 771,359$ 1,166,567$ 1,447,145$ 80.6%4,341,435$ 1,273,506$ (106,939)$ OPERATING EXPENDITURES Personnel -$ -$ -$ 243,247$ 243,247$ 464,993$ 52.3%1,671,380$ 229,590$ 13,657$ Materials & Supplies 11,586 - 4,223 70,585 86,394 144,418 59.8%718,900 (1,527) 87,921 Operational & Contractual 189,777 19,651 15,953 116,586 341,967 361,414 94.6%942,765 148,617 193,349 Other 16,928 - - 103,397 120,325 - N/A - - 120,325 Capital 82,586 - - 681,540 764,126 358,752 213.0%466,750 49,690 714,437 Total Operating Expenditures 300,877$ 19,651$ 20,175$ 1,215,355$ 1,556,059$ 1,329,577$ 117.0%3,799,795$ 426,370$ 1,129,688$ B&T Administration Overhead Allocation*12,486$ -$ (4,167)$ (8,319)$ 0$ -$ N/A -$ -$ 0$ Operating Revenues Over (Under) Expenditures 48,214$ 6,460$ 8,150$ (452,315)$ (389,491)$ 117,568$ -331.3%541,640$ 847,136$ (1,236,627)$ INTERFUND TRANSACTIONS Interfund Loan**-$ -$ -$ -$ -$ -$ N/A -$ -$ -$ Transfer From General Fund - - - - - - N/A - - - Transfer From Golf Surcharge Fund - - - (8,319) (8,319) (8,319) 100.0%(24,957) - (8,319) Reimbursement From Infrastructure Fund - - - - - - N/A - - - Reimbursement From Water Fund - - - - - 13,333 0.0%40,000 - - Reimbursement To General Fund - - - (50,788) (50,788) (57,533) 88.3%(172,600) (20,242) (30,546) Total Interfund Transactions -$ -$ -$ (59,107)$ (59,107)$ (52,519)$ 112.5%(157,557)$ (20,242)$ (38,865)$ Total Revenues Over (Under) Expenditures - Budgetary Basis 48,214$ 6,460$ 8,150$ (511,422)$ (448,598)$ 65,049$ 384,083$ 826,894$ (1,275,492)$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay 82,586$ -$ -$ 681,540$ 764,126$ 49,690$ Depreciation Expense (56,076) (562) (25,000) (82,100) (163,737) (163,737) IMRF Pension Expense (683) - (1,250) (8,167) (10,100) (10,100) OPEB Expense - - (1,250) (9,333) (10,583) (10,583) Total GAAP Adjustments 25,827$ (562)$ (27,500)$ 581,940$ 579,706$ (134,731)$ Fund Increase/(Decrease) - GAAP Basis 74,042$ 5,898$ (19,350)$ 70,518$ 131,108$ 692,164$ *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 April 30, 2024 4/30/24 4/30/24 822 4/30/24 YTD % of YTD 2024 4/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 -$ 230,725$ 10,910$ -$ 241,635$ 147,592$ 163.7%442,775$ 287,580$ (45,945)$ Programs/User Fees - 3,350 180 - 3,530 36,600.00 9.6%109,800 5,157 (1,627) Food Sales - - - - - 2,000.00 0.0%6,000 - - Beverage Sales - - - - - 800.00 0.0%2,400 - - Grants - - - - - - N/A - - - Other Revenue 88,441 - - 3,000 91,441 30,053 304.3%90,160 512 90,929 Total Operating Revenues 88,441$ 234,075$ 11,090$ 3,000$ 336,606$ 217,045$ 155.1%651,135$ 293,249$ 43,357$ OPERATING EXPENDITURES Personnel -$ -$ -$ -$ -$ 83,963$ 0.0%251,888$ 105$ (105)$ Materials & Supplies 21 11,373 129 63 11,586 15,127 76.6%45,380 5,342 6,245 Operational & Contractual 84,256 105,521 - - 189,777 191,011 99.4%573,034 64,384 125,393 Other 16,928 - - - 16,928 - N/A - - 16,928 Capital 1,830 80,757 - - 82,586 291,500 28.3%874,500 - 82,586 Total Operating Expenditures 103,034$ 197,650$ 129$ 63$ 300,877$ 581,600$ 51.7%1,744,801$ 69,831$ 231,047$ B&T Administration Overhead Allocation*34,833$ (13,706)$ (3,808)$ (4,833)$ 12,486$ -$ N/A 37,457$ -$ 12,486$ Operating Revenues Over (Under) Expenditures 20,240$ 22,719$ 7,153$ (1,897)$ 48,214$ (364,556)$ -13.2%(1,056,210)$ 223,418$ (175,204)$ Transfer From General Fund - - - - - - N/A - - Reimbursement From Infrastructure Fund - - - - - -$ N/A - - - Reimbursement From Water Fund 13,336 - - - - 13,333 0.0%40,000 - - Reimbursement To General Fund - - - - - (6,747) 0.0%(20,242) - - Total Interfund Transactions 13,336$ -$ -$ -$ -$ 6,586$ 0.0%19,758$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis 33,576$ 22,719$ 7,153$ (1,897)$ 48,214$ (357,970)$ (1,036,452)$ 223,418$ (175,204)$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay 1,830$ 80,757$ -$ -$ 82,586$ -$ Depreciation Expense (21,453) (33,333) (900) (389) (56,076) (56,076) IMRF Pension Expense (667) - - (17) (683) (683) Total GAAP Adjustments (20,290)$ 47,423$ (900)$ (406)$ 25,827$ (56,759)$ Fund Increase/(Decrease) - GAAP Basis 13,286$ 70,142$ 6,253$ (2,303)$ 74,042$ 166,659$ *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 April 30, 2024 4/30/24 4/30/24 4/30/24 YTD % of YTD 2024 4/30/23 Difference 815 816 YTD Amended Amended Adopted YTD Prior Polo Open Fields Total Budget Budget Budget Total Year OPERATING REVENUES Field Rentals -$ 26,111$ 26,111$ 64,333$ 40.6%193,000$ 25,000$ 1,111$ Range Rentals - - - - N/A - 86,080 (86,080) Taste of Oak Brook - - - - N/A - - - Other Revenue - - - N/A - - - Total Operating Revenues -$ 26,111$ 26,111$ 64,333$ 40.6%193,000$ 111,080$ (84,969)$ OPERATING EXPENDITURES Personnel -$ -$ -$ -$ N/A -$ -$ Materials & Supplies - - - 3,163 0.0%9,490$ - - Operational & Contractual - 19,651 19,651 25,350 77.5%76,050 19,730 (79) Other - - N/A - - - Capital - - - 15,333 0.0%46,000 - - Total Operating Expenditures -$ 19,651$ 19,651$ 43,847$ 44.8%131,540$ 19,730$ (79)$ Operating Revenues Over (Under) Expenditures -$ 6,460$ 6,460$ 20,487$ 31.5%61,460$ 91,350$ (84,890)$ INTERFUND TRANSACTIONS Transfer From Hotel Tax Fund -$ -$ -$ -$ N/A -$ -$ -$ Total Interfund Transactions -$ -$ -$ -$ N/A -$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis -$ 6,460$ 6,460$ 20,487$ 61,460$ 91,350$ (84,890)$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ -$ -$ -$ Depreciation Expense - (562) (562) (562) Total GAAP Adjustments -$ (562)$ (562)$ (562)$ Fund Increase/(Decrease) - GAAP Basis -$ 5,898$ 5,898$ 90,789$ *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 April 30, 2024 4/30/24 4/30/24 821 YTD % of YTD 2024 4/30/23 Difference B&T Amended Amended Adopted YTD Prior Clubhouse Budget Budget Budget Total Year OPERATING REVENUES Rentals 32,492$ 77,667$ 41.8%233,000$ 3,481$ 29,011$ Other Revenue - - 0.0%- - - Total Operating Revenues 32,492$ 77,667$ 41.8%233,000$ 3,481$ 29,011$ OPERATING EXPENDITURES Personnel -$ -$ N/A -$ 2,545$ (2,545)$ Materials & Supplies 4,223 4,583 92.1%13,750 354 3,869 Operational & Contractual 15,953 17,659 90.3%52,978 14,431 1,521 Capital - - N/A - - - Total Operating Expenditures 20,175$ 22,243$ 90.7%66,728$ 17,330$ 2,846$ B&T Administration Overhead Allocation*(4,167)$ -$ N/A (12,500)$ -$ (4,167)$ Operating Revenues Over (Under) Expenditures 8,150$ 55,424$ 14.7%153,772$ (13,849)$ 21,999$ INTERFUND TRANSACTIONS Transfer From General Fund -$ -$ 0.0%-$ -$ -$ Total Interfund Transactions -$ -$ 0.0%-$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis 8,150$ 55,424$ 153,772$ (13,849)$ 21,999$ 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 (19,350)$ (41,349)$ *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 April 30, 2024 4/30/24 4/30/24 823 831 832 833 834 4/30/24 YTD % of YTD 2024 4/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 -$ 358,450$ -$ -$ -$ 358,450$ 169,317$ 211.7%507,950$ 446,025$ (87,575)$ Greens Fees - 165,047 - - - 165,047 468,333 35.2%1,405,000 111,789 53,258 Pro Shop Sales - 17,202 - - - 17,202 72,667 23.7%218,000 50,698 (33,496) Golf Lessons - - 20,825 - - 20,825 15,000 138.8%45,000 14,015 6,810 Driving Range Fees - - 134,590 - - 134,590 130,000 103.5%390,000 129,909 4,681 Rentals 7,500 - 17,750 47,567 - 72,817 190,733 38.2%572,200 41,408 31,409 Food Sales 990 - - - - 990 13,967 7.1%41,900 24,883 (23,893) Beverage Sales - - - - - - 25,083 0.0%75,250 45,347 (45,347) Other Revenue - 1,439 - - - 1,439 3,000 48.0%9,000 1,624 (185) Total Operating Revenues 8,490$ 542,137$ 173,165$ 47,567$ -$ 771,359$ 1,088,100$ 70.9%3,264,300$ 865,697$ (94,338)$ OPERATING EXPENDITURES Personnel -$ 154,188$ 3,331$ 6,785$ 78,943$ 243,247$ 381,031$ 63.8%1,143,092$ 226,940$ 16,307$ Materials & Supplies (15) 26,862 6,268 466 37,004 70,585 121,544 58.1%364,633 (7,222) 77,807 Operational & Contractual 2,870 61,939 - 30,430 21,347 116,586 127,394 91.5%382,181 50,073 66,514 Other - - - - 103,397 103,397 - N/A - - 103,397 Capital - 9,940 - 671,600 - 681,540 51,918 1312.7%155,755 49,690 631,850 Total Operating Expenditures 2,855$ 252,930$ 9,599$ 709,280$ 240,691$ 1,215,355$ 681,887$ 178.2%2,045,661$ 319,481$ 895,875$ Operating Revenues Over (Under) Expenditures 5,634$ 289,208$ 163,566$ (661,713)$ (240,691)$ (443,996)$ 406,213$ -109.3%1,218,639$ 546,216$ (990,213)$ INTERFUND TRANSACTIONS Overhead Charge -$ (8,319)$ -$ -$ -$ (8,319)$ (8,319)$ 100.0%(24,957)$ -$ (8,319)$ Transfers from Other Fund - 19,646 - - - 19,646 - 0.0%150,000 - - Reimbursement to General Fund - (50,788) - - - (50,788) (50,786) 100.0%(152,358) (20,242) (30,546) Total Interfund Transactions -$ (39,461)$ -$ -$ -$ (39,461)$ (59,105)$ 66.8%(27,315)$ (20,242)$ (38,865)$ Total Revenues Over (Under) Expenditures - Budgetary Basis 5,634$ 249,747$ 163,566$ (661,713)$ (240,691)$ (483,457)$ 347,108$ 1,191,324$ 525,974$ (1,029,078)$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay -$ 9,940$ -$ 671,600$ -$ 681,540$ 49,690$ Depreciation Expense (333) (35,000) (767) (4,333) (41,667) (82,100) (82,100) IMRF Pension Expense (833) (3,333) (333) - (3,667) (8,167) (8,167) OPEB Expense (1,000) (5,000) - - (3,333) (9,333) (9,333) Total GAAP Adjustments (2,167)$ (33,393)$ (1,100)$ 667,267$ (48,667)$ 581,940$ (49,910)$ Fund Increase/(Decrease) - GAAP Basis 3,468$ 216,353$ 162,466$ 5,554$ (289,358)$ 98,483$ 476,064$ *Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.