Loading...
HomeMy WebLinkAbout07 - July 2024 Monthly Financial ReportVILLAGE OAK BROOKOF MONTHLY FINANCIAL REPORTS JULY 2024 Estimated YTD YTD Net Fund Ending YTD YTD Increase Fund Balance Governmental Funds Revenues Expenditures (Decrease)(Deficit) General Fund (Major Fund)19,296,274$ 16,361,107$ 2,935,168$ 45,560,556$ Main operating fund of the Village. Hotel Fund (Major Fund)989,587$ 137,093$ 852,494$ 4,623,691$ Collects and spends resources from the 3% hotel/motel tax. Motor Fuel Tax Fund 255,154$ 89,327$ 165,827$ 2,187,929$ Collects and spends resources from the State motor fuel tax. Infrastructure Fund (Major Fund)4,776,516$ 1,176,155$ 3,600,361$ 18,024,868$ Accounts for construction and maintenance of roadways, drainage, and safety path systems. Enterprise Funds Water Fund (Major Fund)6,319,694$ 5,029,612$ 1,290,082$ 23,208,725$ Collects user fees for the distribution of water and maintenance of infrastructure. Sports Core Fund (Major Fund)3,258,441$ 3,188,514$ 69,927$ 2,973,815$ Accounts for revenues and expenses relating to administration, programs, food and beverage operations, and golf course. Internal Service Funds Insurance Fund 1,693,901$ 2,031,378$ (337,477)$ 227,966$ Accounts for the Village's health insurance costs and the related contributions from the Village, employees, retirees, and other agencies. Garage Fund 433,626$ 378,608$ 55,018$ 401,492$ Accounts for the maintenance of the Village's vehicle fleet and the related departmental reimbursements. Equipment Replacement Fund 817,785$ 605,863$ 211,923$ 3,259,880$ 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 July 31, 2024 7/31/24 7/31/24 7/31/23 7/31/24 YTD % of YTD 2024 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax 10,113,872$ 10,032,368 9,623,019$ 104.3%16,496,604$ (81,504)$ State Income Tax 838,499 908,159 764,750 118.8%1,311,000 69,660 Replacement Tax 678,525 312,290 438,092 71.3%751,015 (366,235) Road & Bridge Tax 15,431 21,914 20,417 107.3%35,000 6,483 Local Use Tax 202,832 186,210 196,000 95.0%336,000 (16,622) Cannabis Use Tax 7,270 7,878 7,688 102.5%13,180 608 Grants 576,109 154,908 96,636 160.3%165,662 (421,201) Utility/Telecom. Tax 3,003,389 1,934,558 2,683,333 72.1%4,600,000 (1,068,831) Licenses and Permits 3,084,085 1,444,264 1,311,223 110.1%2,247,810 (1,639,821) Charges for Services 2,000,002 2,369,345 1,268,546 186.8%2,174,650 369,343 Investment Interest 585,104 920,320 262,500 350.6%450,000 335,216 Miscellaneous Income 748,857 493,096 534,374 92.3%916,070 (255,761) Total Operating Revenues 21,853,975$ 18,785,309$ 17,206,578$ 109.2%29,496,991$ (3,068,666)$ OPERATING EXPENDITURES Personnel 11,489,721$ 12,256,768$ 13,163,041$ 93.1%22,565,214$ 767,047$ Materials and Supplies 316,854 302,306 385,930 78.3%661,594 (14,548)$ Operation and Contract 2,893,371 3,601,400 3,689,183 97.6%6,324,313 708,029$ Other Expenditures 6,394 4,240 5,775 73.4%9,900 (2,154)$ Capital Outlay 499,825 196,392 386,812 50.8%663,107 (303,433)$ Total Operating Expenditures 15,206,165$ 16,361,107$ 17,630,742$ 92.8%30,224,129$ 1,154,942$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 6,647,810$ 2,424,203$ (424,163)$ -571.5%(727,137)$ (4,223,607)$ INTERFUND TRANSACTIONS Transfers In -$ -$ -$ N/A -$ -$ Transfers Out N/A - Reimbursements From Other Funds 456,000 510,965 510,964 100.0%875,938 54,965 Reimbursements To Other Funds - - 58,333 0.0%100,000 - Sports Core Loan N/A - - Total Interfund Transactions 456,000$ 510,965$ 569,297$ 89.8%975,938$ 54,965$ NET FUND INCREASE (DECREASE)7,103,810$ 2,935,168$ 145,134$ 248,801$ (4,168,642)$ Village of Oak Brook General Fund Financial Update For the Period Ending July 31, 2024 7/31/24 7/31/24 7/31/23 7/31/24 YTD % of YTD 2024 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Hotel Tax 832,878$ 897,148$ 845,833$ 106.1%1,450,000$ 64,270$ Investment Interest 44,511 91,439 14,583 627.0%25,000 46,928 Loan Interest 2,000 1,000 1,167 85.7%2,000 (1,000) Miscellaneous - - - - Total Operating Revenues 879,389$ 989,587$ 861,583$ 114.9%1,477,000$ 110,198$ EXPENDITURES Personnel -$ 14,928$ 14,928$ 100.0%-$ 14,928$ Operation and Contract 60,832 (23,888) 411,276 -5.8%705,045 (84,720) Capital Outlay - 3,770 160,417 2.3%275,000 3,770 Total Expenditures 60,832$ (5,191)$ 586,621$ -0.9%980,045$ (66,023)$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 818,557$ 994,778$ 289,890$ 343.2%496,955$ 176,221$ INTERFUND TRANSACTIONS Transfer Out -$ -$ -$ N/A -$ -$ Reimbursements to Other Funds (203,867) (142,284) (142,284) 100.0%(243,915) 61,583 Total Interfund Transactions (203,867)$ (142,284)$ (142,284)$ 100.0%(243,915)$ 61,583$ NET FUND INCREASE (DECREASE)614,690$ 852,494$ 147,607$ 253,040$ 237,804$ Note - Expenditures are recorded in program 171. Village of Oak Brook Hotel Tax Fund Financial Update For the Period Ending July 31, 2024 7/31/24 7/31/24 7/31/23 7/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 4,279,446$ 4,361,274$ 3,910,083$ 111.5%6,703,000$ 81,828$ Charges for Services - - N/A -$ Investment Interest 140,448 412,705 72,917 566.0%125,000 272,257 Grants - - - N/A - - Miscellaneous 2,100 2,537 13,417 18.9%23,000 437 Total Operating Revenues 4,421,994$ 4,776,516$ 3,996,417$ 119.5%6,851,000$ 354,522$ OPERATING EXPENDITURES Personnel 12,046$ 115,055$ -$ N/A -$ 103,009$ Materials and Supplies 153,873 21,269 27,125 78.4%46,500 (132,604) Operation and Contract 491,012 651,978 1,016,731 64.1%1,742,968 160,966 Other Expenditures - - 198,274 0.0%339,899 - Capital Outlay 1,314,661 369,184 1,973,869 18.7%3,383,775 (945,477) Total Operating Expenditures 1,971,592$ 1,157,486$ 3,216,000$ 36.0%5,513,142$ (814,106)$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 2,450,402$ 3,619,030$ 780,417$ 463.7%1,337,858$ 1,168,628$ INTERFUND TRANSACTIONS Transfers In -$ -$ -$ N/A -$ -$ Reimbursements From Other Funds 126,910 - - N/A - (126,910) Reimbursements To Other Funds (198,275) (18,669) - N/A - 179,606 Total Interfund Transactions (71,365)$ (18,669)$ -$ N/A -$ 52,696$ NET FUND INCREASE (DECREASE)2,379,037$ 3,600,361$ 780,417$ 1,337,858$ 1,221,324$ Village of Oak Brook Infrastructure Fund Financial Update For the Period Ending July 31, 2024 7/31/24 7/31/24 7/31/23 7/31/24 YTD % of YTD 2024 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Plan Review Fees 1,275$ 977$ 306$ 318.9%525$ (298)$ Building/Inspection Fees 1,275 - 1,167 0.0%2,000 (1,275) Water Sales 5,220,372 5,461,476 6,253,333 87.3%10,720,000 241,104 Unmetered Sales 30,496 36,881 37,917 97.3%65,000 6,385 Water Connection Fees 129,720 39,560 81,667 48.4%140,000 (90,160) Fire Service Charge - - - N/A - - Meter Charges 14,404 9,370 10,092 92.8%17,300 (5,034) Special Services 25,741 15,054 5,833 258.1%10,000 (10,687) Investment Interest 494,889 687,886 204,167 336.9%350,000 192,997 Proceeds from Property Sale - - - N/A - - Miscellaneous 63,158 68,490 670,676 10.2%1,149,730 5,332 Total Operating Revenues 5,981,330$ 6,319,694$ 7,265,157$ 87.0%12,454,555$ 338,364$ OPERATING EXPENDITURES Personnel 370,765$ 360,548$ 458,741$ 78.6%786,413$ (10,217)$ Materials and Supplies 62,658 64,257 80,043 80.3%137,216 1,599 Operation and Contract 2,694,955 2,413,177 4,142,466 58.3%7,101,369 (281,778) Capital Outlay 989,340 1,936,784 3,319,167 58.4%5,690,000 947,444 Total Expenditures 4,117,718$ 4,774,766$ 8,000,416$ 59.7%13,714,999$ 657,048$ Surplus (Deficit) of Revenues Over Expenditures 1,863,612$ 1,544,928$ (735,259)$ -210.1%(1,260,444)$ (318,684)$ INTERFUND TRANSACTIONS Reimbursements To Other Funds (108,848)$ (254,846)$ (254,846)$ 100.0%(436,879)$ (145,998)$ Total Interfund Transactions (108,848)$ (254,846)$ (254,846)$ 100.0%(436,879)$ (145,998)$ Fund Increase/(Decrease) - Budgetary Basis 1,754,764$ 1,290,082$ (990,105)$ (1,697,323)$ (464,682)$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay 989,340$ 1,936,784$ Depreciation Expense (191,667) (335,417) IMRF Pension Expense (15,000) (26,250) OPEB Expense (10,000) (17,500) Total GAAP Adjustments 772,673$ 1,557,617$ Fund Increase/(Decrease) - GAAP Basis 2,527,437$ 2,847,699$ *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 July 31, 2024 Village of Oak Brook Monthly Operating Statement Sports Core Fund Consolidated Presentation For the Period Ending July 31, 2024 7/31/24 7/31/24 7/31/24 YTD % of YTD 2024 7/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 429,880$ -$ -$ 395,650$ 825,530$ 554,590$ 148.9%950,725$ 887,885$ (62,355)$ Greens Fees - - - 983,668 983,668 819,583 120.0%1,405,000 859,224 124,444 Golf Surcharge - - - 129,982 129,982 53,143 244.6%53,143 83,384 46,599 Pro Shop Sales - - - 96,575 96,575 127,167 75.9%218,000 126,549 (29,974) Golf Lessons - - - 35,595 35,595 26,250 135.6%45,000 21,937 13,658 Driving Range Fees - - - 371,625 371,625 227,500 163.4%390,000 313,120 58,505 Rentals - 88,894 71,872 379,666 540,432 582,283 92.8%998,200 506,844 33,588 Programs/User Fees 115,813 - - - 115,813 64,050 180.8%109,800 79,480 36,333 Food Sales 3,728 - - 35,196 38,925 27,942 139.3%47,900 214,941 (176,016) Beverage Sales - - - - - 45,296 0.0%77,650 315,057 (315,057) Taste of Oak Brook - - - - - - N/A - - - Grants - - - - - - N/A - - - Other Revenue 95,519 - - 1,440 96,959 57,843 167.6%99,160 27,407 69,552 Total Operating Revenues 644,940$ 88,894$ 71,872$ 2,429,398$ 3,235,103$ 2,585,646$ 125.1%4,394,578$ 3,435,828$ (200,724)$ OPERATING EXPENDITURES Personnel 37,612$ -$ -$ 734,396$ 772,008$ 813,738$ 94.9%1,671,380$ 771,163$ 844$ Materials & Supplies 30,125 - 7,248 194,411 231,784 252,731 91.7%718,900 448,861 (217,076) Operational & Contractual 445,191 23,802 27,193 227,782 723,967 632,475 114.5%942,765 592,293 131,674 Other - - - - - - N/A - - - Capital 514,735 - - 827,518 1,342,252 627,815 213.8%466,750 111,412 1,230,840 Total Operating Expenditures 1,027,662$ 23,802$ 34,441$ 1,984,106$ 3,070,011$ 2,326,759$ 131.9%3,799,795$ 1,923,729$ 1,146,283$ B&T Administration Overhead Allocation*21,850$ -$ (7,292)$ (14,558)$ -$ (14,558)$ N/A (24,957) -$ (24,957)$ Operating Revenues Over (Under) Expenditures (360,872)$ 65,092$ 30,139$ 430,733$ 165,092$ 244,329$ 67.6%569,826$ 1,512,099$ (1,371,963)$ INTERFUND TRANSACTIONS Interfund Loan**-$ -$ -$ -$ -$ -$ N/A -$ -$ -$ Transfer From General Fund - - - - - - N/A - - - Reimbursement From Infrastructure Fund - - - - - - N/A - - - Reimbursement From Water Fund 23,338 - - - 23,338 23,333 100.0%40,000 - 23,338 Reimbursement To General Fund (29,624) - - (88,879) (118,503) (100,683) 117.7%(172,600) (47,230) (71,273) Total Interfund Transactions (6,286)$ -$ -$ (88,879)$ (95,165)$ (77,350)$ 123.0%(132,600)$ (47,230)$ (47,935)$ Total Revenues Over (Under) Expenditures - Budgetary Basis (367,158)$ 65,092$ 30,139$ 341,854$ 69,927$ 166,979$ 437,226$ 1,464,869$ (1,419,899)$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay 514,735$ -$ -$ 827,518$ 1,342,252$ 111,412$ Depreciation Expense (98,132) (983) (25,000) (143,675) (267,790) (267,790) IMRF Pension Expense (1,196) - (1,250) (14,292) (16,738) (16,738) OPEB Expense - - (1,250) (16,333) (17,583) (17,583) Total GAAP Adjustments 415,406$ (983)$ (27,500)$ 653,218$ 1,040,141$ (190,699)$ Fund Increase/(Decrease) - GAAP Basis 48,248$ 64,109$ 2,639$ 995,072$ 1,110,068$ 1,274,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 July 31, 2024 7/31/24 7/31/24 822 7/31/24 YTD % of YTD 2024 7/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 -$ 401,000$ 28,880$ -$ 429,880$ 258,285$ 166.4%442,775$ 407,785$ 22,095$ Programs/User Fees - 73,693 42,120 - 115,813 64,050.00 180.8%109,800 79,480 36,333 Food Sales - - - 3,728 3,728 3,500.00 106.5%6,000 41,697 - Beverage Sales - - - - - 1,400.00 0.0%2,400 14,863 - Grants - - - - - - N/A - - - Other Revenue 88,519 - 1,000 6,000 95,519 52,593 181.6%90,160 1,630 93,889 Total Operating Revenues 88,519$ 474,693$ 72,000$ 9,728$ 644,940$ 379,828$ 169.8%651,135$ 545,455$ 152,317$ OPERATING EXPENDITURES Personnel -$ 37,612$ -$ -$ 37,612$ 146,934$ 25.6%251,888$ 45,225$ (7,613)$ Materials & Supplies 21 18,195 11,774 136 30,125 26,472 113.8%45,380 38,775 (8,650) Operational & Contractual 138,542 245,319 60,567 763 445,191 334,270 133.2%573,034 302,068 143,123 Other - - - - - - N/A - - - Capital 429,778 84,957 - - 514,735 510,125 100.9%874,500 - 514,735 Total Operating Expenditures 568,341$ 386,082$ 72,341$ 899$ 1,027,662$ 1,017,801$ 101.0%1,744,801$ 386,068$ 641,594$ B&T Administration Overhead Allocation*60,958$ (23,986)$ (6,665)$ (8,458)$ 21,850$ -$ N/A 37,457$ -$ 21,850$ Operating Revenues Over (Under) Expenditures (418,863)$ 64,625$ (7,006)$ 371$ (360,872)$ (637,972)$ 56.6%(1,056,210)$ 159,387$ (467,428)$ Transfer From General Fund -$ -$ -$ -$ -$ -$ N/A - - Reimbursement From Infrastructure Fund - - - - - - N/A - - - Reimbursement From Water Fund 23,338 - - - 23,338 23,333 100.0%40,000 - 23,338 Reimbursement To General Fund (29,624) - - - (29,624) (11,808) 250.9%(20,242) (26,988) (2,636) Total Interfund Transactions (6,286)$ -$ -$ -$ (6,286)$ 11,526$ -54.5%19,758$ (26,988)$ 20,702$ Total Revenues Over (Under) Expenditures - Budgetary Basis (425,149)$ 64,625$ (7,006)$ 371$ (367,158)$ (626,447)$ (1,036,452)$ 132,399$ (446,726)$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay 429,778$ 84,957$ -$ -$ 514,735$ -$ Depreciation Expense (37,543) (58,333) (1,575) (681) (98,132) (98,132) IMRF Pension Expense (1,167) - - (29) (1,196) (1,196) Total GAAP Adjustments 391,069$ 26,623$ (1,575)$ (711)$ 415,406$ (99,328)$ Fund Increase/(Decrease) - GAAP Basis (34,080)$ 91,248$ (8,581)$ (339)$ 48,248$ 33,071$ *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 July 31, 2024 7/31/24 7/31/24 7/31/24 YTD % of YTD 2024 7/31/23 Difference 815 816 YTD Amended Amended Adopted YTD Prior Polo Open Fields Total Budget Budget Budget Total Year OPERATING REVENUES Field Rentals -$ 88,894$ 88,894 112,583$ 79.0%193,000$ 86,500$ 2,394$ Range Rentals - - - - N/A - 86,080 (86,080) Taste of Oak Brook - - - - N/A - - - Other Revenue - - - - N/A - - - Total Operating Revenues -$ 88,894$ 88,894$ 112,583$ 79.0%193,000$ 172,580$ (83,686)$ OPERATING EXPENDITURES Personnel -$ -$ -$ -$ N/A -$ -$ Materials & Supplies - - - 5,536 0.0%9,490$ - - Operational & Contractual - 23,802 23,802 44,363 53.7%76,050 27,049 (3,247) Other - - - - N/A - - - Capital - - - 26,833 0.0%46,000 - - Total Operating Expenditures -$ 23,802$ 23,802$ 76,732$ 31.0%131,540$ 27,049$ (3,247)$ Operating Revenues Over (Under) Expenditures -$ 65,092$ 65,092$ 35,852$ 181.6%61,460$ 145,531$ (80,439)$ INTERFUND TRANSACTIONS Transfer From Hotel Tax Fund -$ -$ -$ -$ N/A -$ -$ -$ Total Interfund Transactions -$ -$ -$ -$ N/A -$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis -$ 65,092$ 65,092$ 35,852$ 61,460$ 145,531$ (80,439)$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ -$ -$ -$ Depreciation Expense - (983) (983) (983) Total GAAP Adjustments -$ (983)$ (983)$ (983)$ Fund Increase/(Decrease) - GAAP Basis -$ 64,109$ 64,109$ 144,548$ *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 July 31, 2024 7/31/24 7/31/24 821 YTD % of YTD 2024 7/31/23 Difference B&T Amended Amended Adopted YTD Prior Clubhouse Budget Budget Budget Total Year OPERATING REVENUES Rentals 71,872$ 135,917$ 52.9%233,000$ 52,488$ 19,384$ Other Revenue - - 0.0%- - - Total Operating Revenues 71,872$ 135,917$ 52.9%233,000$ 52,488$ 19,384$ OPERATING EXPENDITURES Personnel -$ -$ N/A -$ 5,373$ (5,373)$ Materials & Supplies 7,248 8,021 90.4%13,750 6,855 393 Operational & Contractual 27,193 30,904 88.0%52,978 32,736 (5,543) Capital - - N/A - - - Total Operating Expenditures 34,441$ 38,925$ 88.5%66,728$ 44,964$ (10,523)$ B&T Administration Overhead Allocation*(7,292)$ -$ N/A (12,500)$ -$ (7,292)$ Operating Revenues Over (Under) Expenditures 30,139$ 96,992$ 31.1%153,772$ 7,524$ 22,615$ INTERFUND TRANSACTIONS Transfer From General Fund -$ -$ 0.0%-$ -$ -$ Total Interfund Transactions -$ -$ 0.0%-$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis 30,139$ 96,992$ 153,772$ 7,524$ 22,615$ 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 2,639$ (19,976)$ *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 July 31, 2024 7/31/24 7/31/24 823 831 832 833 834 7/31/24 YTD % of YTD 2024 7/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 -$ 395,650$ -$ -$ -$ 395,650$ 296,304$ 133.5%507,950$ 480,100$ (84,450)$ Greens Fees - 983,668 - - - 983,668 819,583 120.0%1,405,000 859,224 124,444 Surcharge - 129,982 129,982 53,143 244.6%53,143 83,384 46,599 Pro Shop Sales - 96,575 - - - 96,575 127,167 75.9%218,000 126,549 (29,974) Golf Lessons - - 35,595 - - 35,595 26,250 135.6%45,000 21,937 13,658 Driving Range Fees - - 371,625 - - 371,625 227,500 163.4%390,000 313,120 58,505 Rentals 15,000 - 35,000 329,666 - 379,666 333,783 113.7%572,200 281,776 97,890 Food Sales 35,196 - - - - 35,196 24,442 144.0%41,900 173,244 (138,048) Beverage Sales - - - - - - 43,896 0.0%75,250 300,194 (300,194) Other Revenue - 1,440 - - - 1,440 5,250 27.4%9,000 25,777 (24,337) Total Operating Revenues 50,196$ 1,607,315$ 442,220$ 329,666$ -$ 2,429,398$ 1,957,318$ 124.1%3,317,443$ 2,665,305$ (235,907)$ OPERATING EXPENDITURES Personnel 5,184$ 388,941$ 23,724$ 46,322$ 270,225$ 734,396$ 666,804$ 110.1%1,143,092$ 720,565$ 13,831$ Materials & Supplies (15) 90,253 6,268 915 96,990 194,411 212,703 91.4%364,633 403,231 (208,820) Operational & Contractual 3,288 135,995 21,493 31,688 35,317 227,782 222,939 102.2%382,181 230,440 (2,658) Other - - - - - N/A - - - Capital - 18,635 - 671,600 137,283 827,518 90,857 910.8%155,755 111,412 716,106 Total Operating Expenditures 8,457$ 633,823$ 51,485$ 750,525$ 539,816$ 1,984,106$ 1,193,302$ 166.3%2,045,661$ 1,465,648$ 518,458$ Operating Revenues Over (Under) Expenditures 41,739$ 973,492$ 390,735$ (420,859)$ (539,816)$ 445,291$ 764,016$ 58.3%1,271,782$ 1,199,657$ (754,365)$ INTERFUND TRANSACTIONS Overhead Charge -$ (14,558)$ -$ -$ -$ (14,558)$ (14,558)$ 100.0%(24,957)$ -$ (14,558)$ Transfers from Other Fund - - - - - - - 0.0%150,000 - - Reimbursement to General Fund - (88,879) - - - (88,879) (88,876) 100.0%(152,358) (20,242) (68,637) Total Interfund Transactions -$ (103,437)$ -$ -$ -$ (103,437)$ (103,434)$ 100.0%(27,315)$ (20,242)$ (83,195)$ Total Revenues Over (Under) Expenditures - Budgetary Basis 41,739$ 870,055$ 390,735$ (420,859)$ (539,816)$ 341,854$ 660,582$ 1,244,467$ 1,179,415$ (837,561)$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay -$ 18,635$ -$ 671,600$ 137,283$ 827,518$ 111,412$ Depreciation Expense (583) (61,250) (1,342) (7,583) (72,917) (143,675) (143,675) IMRF Pension Expense (1,458) (5,833) (583) - (6,417) (14,292) (14,292) OPEB Expense (1,750) (8,750) - - (5,833) (16,333) (16,333) Total GAAP Adjustments (3,792)$ (57,199)$ (1,925)$ 664,017$ 52,117$ 653,218$ (62,888)$ Fund Increase/(Decrease) - GAAP Basis 37,947$ 812,856$ 388,810$ 243,157$ (487,699)$ 995,072$ 1,116,527$ *Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.