Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
02 - February 2023 Monthly Financial Report
VILLAGE OAK BROOKOF MONTHLY FINANCIAL REPORTS FEBRUARY 2023 YTD YTD Net Fund Ending YTD YTD Increase Fund Balance Governmental Funds Revenues Expenditures (Decrease)(Deficit) General Fund (Major Fund)5,606,549$ 3,160,408$ 2,446,140$ 38,471,052$ Main operating fund of the Village. Hotel Fund (Major Fund)222,260$ 12,506$ 209,754$ 2,390,346$ Collects and spends resources from the 3% hotel/motel tax. Motor Fuel Tax Fund 61,797$ 7,342$ 54,455$ 1,697,233$ Collects and spends resources from the State motor fuel tax. Infrastructure Fund (Major Fund)1,199,406$ 719,962$ 479,443$ 8,880,970$ Accounts for construction and maintenance of roadways, drainage, and safety path systems. Promenade TIF Fund (Major Fund)783$ 337,018$ (336,235)$ 313,624$ 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)1,326,574$ 428,575$ 897,999$ 18,856,574$ Collects user fees for the distribution of water and maintenance of infrastructure. Sports Core Fund (Major Fund)5,253$ 135,548$ (130,295)$ 1,147,787$ Accounts for revenues and expenses relating to administration, programs, food and beverage operations, and golf course. Golf Surcharge Fund -$ -$ -$ 267,070$ Accounts for the collection of the $3 per round golf surcharge. Internal Service Funds Self Insurance Fund 254,220$ 790,538$ (536,318)$ (32,519)$ Accounts for the Village's health insurance costs and the related contributions from the Village, employees, retirees, and other agencies. Garage Fund 702$ 67,752$ (67,050)$ 248,083$ Accounts for the maintenance of the Village's vehicle fleet and the related departmental reimbursements. Equipment Replacement Fund 1,134$ 335,949$ (334,815)$ 2,826,716$ 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 February 28, 2023 2/28/23 2/28/23 2/28/22 2/28/23 YTD % of YTD 2023 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax 2,972,631$ 2,872,086 2,666,667$ 107.7%16,000,000$ (100,545)$ State Income Tax 249,907 241,615 190,833 126.6%1,145,000 (8,293) Replacement Tax 96,244 136,132 75,000 181.5%450,000 39,888 Road & Bridge Tax - - 5,833 0.0%35,000 - Local Use Tax 54,226 60,268 50,000 120.5%300,000 6,042 Cannabis Use Tax 2,287 2,069 2,650 78.1%15,900 (219) Grants 264 - 2,610 0.0%15,662 (264) Utility/Telecom. Tax 1,076,619 924,844 937,167 98.7%5,623,000 (151,775) Licenses and Permits 275,739 1,066,919 325,081 328.2%1,950,485 791,180 Charges for Services 245,620 121,856 274,562 44.4%1,647,370 (123,764) Investment Interest 16,774 57,577 33,333 172.7%200,000 40,804 Miscellaneous Income 126,167 123,182 170,592 72.2%1,023,551 (2,984) Total Operating Revenues 5,116,478$ 5,606,549$ 4,734,328$ 118.4%28,405,969$ 490,071$ OPERATING EXPENDITURES Personnel 2,774,509$ 2,708,206$ 3,689,509$ 73.4%22,137,051$ (66,303)$ Materials and Supplies 77,041 65,598 99,509 65.9%597,056 (11,443)$ Operation and Contract 657,791 383,847 900,787 42.6%5,404,722 (273,944)$ Other Expenditures 2,142 2,147 1,500 143.2%9,000 5$ Capital Outlay 9,713 609 158,429 0.4%950,575 (9,104)$ Total Operating Expenditures 3,521,196$ 3,160,408$ 4,849,734$ 65.2%29,098,405$ (360,788)$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 1,595,281$ 2,446,140$ (115,406)$ -2119.6%(692,436)$ 850,859$ INTERFUND TRANSACTIONS Transfers In -$ -$ -$ N/A 677,401$ -$ Transfers Out - N/A - Reimbursements From Other Funds 94,204 - - N/A - (94,204) Reimbursements To Other Funds (18,314) - - N/A - 18,314 Sports Core Loan - N/A - - Total Interfund Transactions 75,890$ -$ -$ N/A 677,401$ (75,890)$ NET FUND INCREASE (DECREASE)1,671,171$ 2,446,140$ (115,406)$ (15,035)$ 774,969$ *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 February 28, 2023 2/28/23 2/28/23 2/28/22 2/28/23 YTD % of YTD 2023 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Hotel Tax 128,427$ 217,803$ 191,667$ 113.6%1,150,000$ 89,376$ Investment Interest 1,045 4,457 2,000 222.9%12,000 3,412 Loan Interest - - 667 0.0%4,000 - Miscellaneous - - Total Operating Revenues 129,472$ 222,260$ 194,333$ 114.4%1,166,000$ 92,789$ EXPENDITURES Operation and Contract 10,040$ 12,506$ 112,433$ 11.1%674,595$ 2,466$ Capital Outlay 52,696 - - N/A - (52,696) Total Expenditures 62,736$ 12,506$ 112,433$ 11.1%674,595$ (50,229)$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 66,736$ 209,754$ 81,901$ 256.1%491,405$ 143,018$ INTERFUND TRANSACTIONS Transfer Out -$ -$ -$ N/A -$ -$ Reimbursements to Other Funds (13,800) - (58,248) 0.0%(349,485) 13,800 Total Interfund Transactions (13,800)$ -$ (58,248)$ 0.0%(349,485)$ 13,800$ NET FUND INCREASE (DECREASE)52,936$ 209,754$ 23,653$ 141,920$ 156,818$ Note - Expenditures are recorded in program 171. Village of Oak Brook Hotel Tax Fund Financial Update For the Period Ending February 28, 2023 2/28/23 2/28/23 2/28/22 2/28/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 1,204,555$ 1,184,543$ 1,087,500$ 108.9%6,525,000$ (20,013)$ Charges for Services - - N/A -$ Investment Interest 5,095 14,863 4,583 324.3%27,500 9,768 Grants - - 181,622 0.0%1,089,730 - Miscellaneous - - 167 0.0%1,000 - Total Operating Revenues 1,209,650$ 1,199,406$ 1,273,872$ 94.2%7,643,230$ (10,245)$ OPERATING EXPENDITURES Personnel 255,201$ 7,549$ 7,549$ 100.0%45,294$ (247,651)$ Materials and Supplies 62,240 101,457 32,900 308.4%197,400 39,217 Operation and Contract 141,471 33,803 288,363 11.7%1,730,180 (107,668) Other Expenditures - - - N/A - Capital Outlay 10,326 577,153 1,537,720 37.5%9,226,320 566,827 Total Operating Expenditures 469,238$ 719,962$ 1,866,532$ 38.6%11,199,194$ 250,725$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 740,412$ 479,443$ (592,661)$ -80.9%(3,555,964)$ (260,969)$ INTERFUND TRANSACTIONS Transfers In -$ -$ -$ N/A -$ -$ Reimbursements From Other Funds 53,896 - - N/A - (53,896) Reimbursements To Other Funds (19,688) - - N/A - 19,688 Total Interfund Transactions 34,208$ -$ -$ N/A -$ (34,208)$ NET FUND INCREASE (DECREASE)774,620$ 479,443$ (592,661)$ (3,555,964)$ (295,177)$ Village of Oak Brook Infrastructure Fund Financial Update For the Period Ending February 28, 2023 2/28/23 2/28/23 2/28/22 2/28/23 YTD % of YTD 2023 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax -$ -$ 2,500$ 0.0%15,000$ -$ Real Estate Tax - - 67,500 0.0%405,000 - Investment Interest 11 783 2 46992.6%10 772 Total Operating Revenues 11$ 783$ 70,002$ 1.1%420,010$ 772$ EXPENDITURES Operation and Contract -$ 225$ 850$ 26.5%5,100$ 225$ Other Expenditures 243,150 336,793 56,121 600.1%336,725 93,643 Total Expenditures 243,150$ 337,018$ 56,971$ 591.6%341,825$ 93,868$ NET FUND INCREASE (DECREASE)(243,139)$ (336,235)$ 13,031$ 78,185$ (93,096)$ Note - Expenditures are recorded in program 283. Village of Oak Brook Promenade TIF Fund Financial Update For the Period Ending February 28, 2023 2/28/23 2/28/23 2/28/22 2/28/23 YTD % of YTD 2023 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Plan Review Fees 225$ 300$ 88$ 342.9%525$ 75$ Building/Inspection Fees 225 375 333 112.5%2,000 150 Water Sales 1,332,559 1,134,398 1,371,667 82.7%8,230,000 (198,162) Unmetered Sales 39,279 5,116 8,333 61.4%50,000 (34,163) Water Connection Fees 5,980 102,580 12,500 820.6%75,000 96,600 Fire Service Charge - - - N/A - - Meter Charges 1,750 4,757 2,500 190.3%15,000 3,007 Special Services - 576 1,667 34.6%10,000 576 Investment Interest 4,015 48,213 3,333 1446.4%20,000 44,198 Proceeds from Property Sale - - - N/A - - Miscellaneous 17,573 30,259 8,333 363.1%50,000 12,686 Total Operating Revenues 1,401,607$ 1,326,574$ 1,408,754$ 94.2%8,452,525$ (75,033)$ OPERATING EXPENDITURES Personnel 76,986$ 74,349$ 107,937$ 68.9%647,620$ (2,637)$ Materials and Supplies 29,986 7,179 11,608 61.8%69,650 (22,808) Operation and Contract 396,585 347,047 900,104 38.6%5,400,625 (49,538) Capital Outlay 3,894 - 654,167 0.0%3,925,000 (3,894) Total Expenditures 507,451$ 428,575$ 1,673,816$ 25.6%10,042,895$ (78,876)$ Surplus (Deficit) of Revenues Over Expenditures 894,156$ 897,999$ (265,062)$ -338.8%(1,590,370)$ 3,843$ INTERFUND TRANSACTIONS Reimbursements To Other Funds (70,082)$ -$ (70,082)$ 0.0%(420,490)$ 70,082$ Total Interfund Transactions (70,082)$ -$ (70,082)$ 0.0%(420,490)$ 70,082$ Fund Increase/(Decrease) - Budgetary Basis 824,074$ 897,999$ (335,143)$ (2,010,860)$ 73,925$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay 3,894$ -$ Depreciation Expense (95,833) (95,833) IMRF Pension Expense (7,500) (7,500) OPEB Expense (5,000) (5,000) Total GAAP Adjustments (104,439)$ (108,333)$ Fund Increase/(Decrease) - GAAP Basis 719,635$ 789,666$ *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 February 28, 2023 Village of Oak Brook Monthly Operating Statement Sports Core Fund Consolidated Presentation For the Period Ending February 28, 2023 2/28/23 2/28/23 2/28/23 YTD % of YTD 2023 2/28/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 -$ -$ -$ -$ -$ 154,875$ 0.0%929,250$ 450$ (450)$ Greens Fees - - - - - 218,333 0.0%1,310,000 - - Pro Shop Sales - - - 348 348 41,667 0.8%250,000 6,112 (5,764) Golf Lessons - - - - - 8,333 0.0%50,000 - - Driving Range Fees - - - 80 80 58,333 0.1%350,000 (17) 97 Rentals - 1,500 1,031 - 2,531 180,667 1.4%1,084,000 8,737 (6,206) Programs/User Fees - - - - - 11,517 0.0%69,100 - - Food Sales - - - 164 164 48,333 0.3%290,000 2,576 (2,412) Beverage Sales - - - 1,750 1,750 82,000 2.1%492,000 4,053 (2,303) Taste of Oak Brook - - - - - - N/A - - - Grants - - - - - - N/A - - - Other Revenue 380 - - - 380 4,604 8.2%27,625 57 323 Total Operating Revenues 380$ 1,500$ 1,031$ 2,342$ 5,253$ 808,663$ 0.6%4,851,975$ 21,967$ (16,715)$ OPERATING EXPENDITURES Personnel -$ -$ 1,439$ 90,960$ 92,398$ 288,053$ 32.1%1,671,380$ 122,717$ (30,318)$ Materials & Supplies (123) - - 5,133 5,010 137,006 3.7%718,900 30,849 (25,838) Operational & Contractual (1,318) 14,020 6,410 19,027 38,139 125,969 30.3%942,765 56,171 (18,032) Other - - - - - - N/A - - - Capital - - - - - 263,125 0.0%466,750 0 (0) Total Operating Expenditures (1,441)$ 14,020$ 7,848$ 115,120$ 135,548$ 814,154$ 16.6%3,799,795$ 209,736$ (74,188)$ B&T Administration Overhead Allocation*-$ -$ -$ -$ -$ -$ N/A -$ -$ -$ Operating Revenues Over (Under) Expenditures 1,821$ (12,520)$ (6,817)$ (112,778)$ (130,295)$ (5,492)$ 2372.6%1,052,180$ (187,769)$ 57,474$ INTERFUND TRANSACTIONS Interfund Loan**-$ -$ -$ -$ -$ -$ N/A -$ -$ -$ Transfer From General Fund - - - - - - N/A - - - Transfer From Golf Surcharge Fund - - - - - 25,000 0.0%150,000 - - Reimbursement From Infrastructure Fund - - - - - - N/A - - - Reimbursement From Water Fund - - - - - - N/A - - - Reimbursement To General Fund - - - - - (13,495) 0.0%(80,967) (12,576) 12,576 Total Interfund Transactions -$ -$ -$ -$ -$ 11,506$ 0.0%69,033$ (12,576)$ 12,576$ Total Revenues Over (Under) Expenditures - Budgetary Basis 1,821$ (12,520)$ (6,817)$ (112,778)$ (130,295)$ 6,014$ 1,121,213$ (200,345)$ 70,050$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ -$ -$ -$ -$ 0$ Depreciation Expense (28,038) (281) (25,000) (41,050) (94,369) (58,040) IMRF Pension Expense (342) - (1,250) (4,083) (5,675) (4,333) OPEB Expense - - (1,250) (4,667) (5,917) (4,917) Total GAAP Adjustments (28,380)$ (281)$ (27,500)$ (49,800)$ (105,960)$ (67,290)$ Fund Increase/(Decrease) - GAAP Basis (26,559)$ (12,801)$ (34,317)$ (162,578)$ (236,256)$ (267,635)$ *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 February 28, 2023 2/28/23 2/28/23 822 2/28/23 YTD % of YTD 2023 2/28/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 -$ -$ -$ -$ -$ 86,542$ 0.0%519,250$ 450$ (450)$ Programs/User Fees - - - - - 11,516.67 0.0%69,100 - - Food Sales - - - - - 6,666.67 0.0%40,000 - - Beverage Sales - - - - - 2,833.33 0.0%17,000 - - Grants - - - - - - N/A - - - Other Revenue 380 - - - 380 388 98.0%2,325 57 323 Total Operating Revenues 380$ -$ -$ -$ 380$ 107,946$ 0.4%647,675$ 507$ (127)$ OPERATING EXPENDITURES Personnel -$ -$ -$ -$ -$ 33,128$ 0.0%198,768$ 249$ (249)$ Materials & Supplies - (123) - - (123) 11,966 -1.0%71,796 24 (147) Operational & Contractual 182 (1,125) (375) - (1,318) 41,164 -3.2%246,985 7,164 (8,482) Other - - - - - N/A - - Capital - - - - - 91,667 0.0%550,000 (874) 874 Total Operating Expenditures 182$ (1,248)$ (375)$ -$ (1,441)$ 177,925$ -0.8%1,067,549$ 6,564$ (8,005)$ B&T Administration Overhead Allocation*-$ -$ -$ -$ -$ -$ N/A 43,783$ -$ -$ Operating Revenues Over (Under) Expenditures 198$ 1,248$ 375$ -$ 1,821$ (69,979)$ -2.6%(376,092)$ (6,057)$ 7,877$ Transfer From General Fund - - - - - - N/A - - Reimbursement From Infrastructure Fund - - - - - -$ N/A - - - Reimbursement From Water Fund - - - - - - N/A - - - Reimbursement To General Fund - - - - - (3,374) 0.0%(20,242) (3,144) 3,144 Total Interfund Transactions -$ -$ -$ -$ -$ (3,374)$ 0.0%(20,242)$ (3,144)$ 3,144$ Total Revenues Over (Under) Expenditures - Budgetary Basis 198$ 1,248$ 375$ -$ 1,821$ (73,353)$ (396,334)$ (9,201)$ 11,021$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ -$ -$ -$ -$ (874)$ Depreciation Expense (10,727) (16,667) (450) (195) (28,038) (10,622) IMRF Pension Expense (333) - - (8) (342) (83) Total GAAP Adjustments (11,060)$ (16,667)$ (450)$ (203)$ (28,380)$ (11,579)$ Fund Increase/(Decrease) - GAAP Basis (10,862)$ (15,419)$ (75)$ (203)$ (26,559)$ (20,780)$ *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 February 28, 2023 2/28/23 2/28/23 2/28/23 YTD % of YTD 2023 2/28/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$ 30,167$ 5.0%181,000$ 1,393$ 107$ Range Rentals - - - 14,167 0.0%85,000 - - Taste of Oak Brook - - - - N/A - - - Other Revenue - - - N/A - - - Total Operating Revenues -$ 1,500$ 1,500$ 44,333$ 3.4%266,000$ 1,393$ 107$ OPERATING EXPENDITURES Personnel -$ -$ -$ -$ N/A -$ -$ Materials & Supplies - - - 1,582 0.0%9,490$ - - Operational & Contractual 12,850 1,170 14,020 20,990 66.8%125,940 1,736 12,284 Capital - - - - N/A - - Total Operating Expenditures 12,850$ 1,170$ 14,020$ 22,572$ 62.1%135,430$ 1,736$ 12,284$ Operating Revenues Over (Under) Expenditures (12,850)$ 330$ (12,520)$ 21,762$ -57.5%130,570$ (343)$ (12,177)$ INTERFUND TRANSACTIONS Transfer From Hotel Tax Fund -$ -$ -$ -$ N/A -$ -$ -$ Total Interfund Transactions -$ -$ -$ -$ N/A -$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis (12,850)$ 330$ (12,520)$ 21,762$ 130,570$ (343)$ (12,177)$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ -$ -$ -$ Depreciation Expense - (281) (281) (1,152) Total GAAP Adjustments -$ (281)$ (281)$ (1,152)$ Fund Increase/(Decrease) - GAAP Basis (12,850)$ 49$ (12,801)$ (1,495)$ *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 February 28, 2023 2/28/23 2/28/23 821 YTD % of YTD 2023 2/28/22 Difference B&T Amended Amended Adopted YTD Prior Clubhouse Budget Budget Budget Total Year OPERATING REVENUES Rentals 1,031$ 58,333$ 1.8%350,000$ 7,344$ (6,313)$ Other Revenue - - 0.0%- - - Total Operating Revenues 1,031$ 58,333$ 1.8%350,000$ 7,344$ (6,313)$ OPERATING EXPENDITURES Personnel 1,439$ 23,826$ 6.0%142,954$ 18,612$ (17,174)$ Materials & Supplies - 3,995 0.0%23,972 7 (7) Operational & Contractual 6,410 12,807 50.0%76,842 4,592 1,818 Capital - - N/A - 874 (874) Total Operating Expenditures 7,848$ 40,628$ 19.3%243,767$ 24,086$ (16,237)$ B&T Administration Overhead Allocation*-$ -$ N/A (43,784)$ -$ -$ Operating Revenues Over (Under) Expenditures (6,817)$ 17,705$ -38.5%62,449$ (16,741)$ 9,924$ INTERFUND TRANSACTIONS Transfer From General Fund -$ -$ 0.0%-$ -$ -$ Total Interfund Transactions -$ -$ 0.0%-$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis (6,817)$ 17,705$ 62,449$ (16,741)$ 9,924$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ 874$ Depreciation Expense (25,000) (5,217) IMRF Pension Expense (1,250) (167) OPEB Expense (1,250) (250) Total GAAP Adjustments (27,500)$ (4,759)$ Fund Increase/(Decrease) - GAAP Basis (34,317)$ (21,501)$ *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 February 28, 2023 2/28/23 2/28/23 823 831 832 833 834 2/28/23 YTD % of YTD 2023 2/28/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 -$ -$ -$ -$ -$ -$ 68,333$ 0.0%410,000$ -$ -$ Greens Fees - - - - - - 218,333 0.0%1,310,000 - - Pro Shop Sales - 348 - - - 348 41,667 0.8%250,000 6,112 (5,764) Golf Lessons - - - - - - 8,333 0.0%50,000 - - Driving Range Fees - - 80 - - 80 58,333 0.1%350,000 (17) 97 Rentals - - - - - - 78,000 0.0%468,000 - - Food Sales 164 - - - - 164 41,667 0.4%250,000 2,576 (2,412) Beverage Sales 1,750 - - - - 1,750 79,167 2.2%475,000 4,053 (2,303) Other Revenue - - - - - - 4,217 0.0%25,300 - - Total Operating Revenues 1,914$ 348$ 80$ -$ -$ 2,342$ 598,050$ 0.4%3,588,300$ 12,723$ (10,381)$ OPERATING EXPENDITURES Personnel 9,819$ 52,606$ -$ -$ 28,535$ 90,960$ 231,100$ 39.4%1,386,598$ 103,855$ (12,896)$ Materials & Supplies 2,127 3,092 - - (86) 5,133 119,463 4.3%716,780 30,817 (25,684) Operational & Contractual 647 8,316 - - 10,064 19,027 51,008 37.3%306,050 42,678 (23,651) Other - - - - - - - N/A - - - Capital - - - - - - 171,458 0.0%1,028,751 - - Total Operating Expenditures 12,593$ 64,014$ -$ -$ 38,513$ 115,120$ 573,030$ 20.1%3,438,178$ 177,351$ (62,231)$ Operating Revenues Over (Under) Expenditures (10,679)$ (63,666)$ 80$ -$ (38,513)$ (112,778)$ 25,020$ -450.7%150,122$ (164,627)$ 51,849$ INTERFUND TRANSACTIONS Transfer from Golf Surcharge -$ -$ -$ -$ -$ -$ 25,000$ 0.0%150,000$ -$ -$ Reimbursement to General Fund - - - - - - (10,121) 0.0%(60,725) (9,432) 9,432 Total Interfund Transactions -$ -$ -$ -$ -$ -$ 14,879$ 0.0%89,275$ (9,432)$ 9,432$ Total Revenues Over (Under) Expenditures - Budgetary Basis (10,679)$ (63,666)$ 80$ -$ (38,513)$ (112,778)$ 39,899$ 239,397$ (174,059)$ 61,281$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay -$ -$ -$ -$ -$ -$ -$ Depreciation Expense (167) (17,500) (383) (2,167) (20,833) (41,050) (41,050) IMRF Pension Expense (417) (1,667) (167) - (1,833) (4,083) (4,083) OPEB Expense (500) (2,500) - - (1,667) (4,667) (4,667) Total GAAP Adjustments (1,083)$ (21,667)$ (550)$ (2,167)$ (24,333)$ (49,800)$ (49,800)$ Fund Increase/(Decrease) - GAAP Basis (11,762)$ (85,332)$ (470)$ (2,167)$ (62,847)$ (162,578)$ (223,859)$ *Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.