Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
03 - March 2023 Monthly Financial Report
VILLAGE OAK BROOKOF MONTHLY FINANCIAL REPORTS MARCH 2023 YTD YTD Net Fund Ending YTD YTD Increase Fund Balance Governmental Funds Revenues Expenditures (Decrease)(Deficit) General Fund (Major Fund)9,240,530$ 5,262,652$ 3,977,878$ 42,448,930$ Main operating fund of the Village. Hotel Fund (Major Fund)301,950$ 12,546$ 289,404$ 2,679,750$ Collects and spends resources from the 3% hotel/motel tax. Motor Fuel Tax Fund 97,914$ 62,640$ 35,274$ 1,732,812$ Collects and spends resources from the State motor fuel tax. Infrastructure Fund (Major Fund)2,209,070$ 1,583,983$ 625,087$ 9,507,581$ Accounts for construction and maintenance of roadways, drainage, and safety path systems. Promenade TIF Fund (Major Fund)1,165$ 337,243$ (336,078)$ (22,454)$ 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)2,195,915$ 837,423$ 1,358,492$ 20,234,702$ Collects user fees for the distribution of water and maintenance of infrastructure. Sports Core Fund (Major Fund)330,415$ 288,130$ 42,285$ 1,190,072$ Accounts for revenues and expenses relating to administration, programs, food and beverage operations, and golf course. Golf Surcharge Fund 372$ -$ 372$ 267,442$ Accounts for the collection of the $3 per round golf surcharge. Internal Service Funds Self Insurance Fund 666,057$ 1,593,194$ (927,137)$ (952,517)$ Accounts for the Village's health insurance costs and the related contributions from the Village, employees, retirees, and other agencies. Garage Fund 1,873$ 108,293$ (106,421)$ 146,851$ Accounts for the maintenance of the Village's vehicle fleet and the related departmental reimbursements. Equipment Replacement Fund 1,941$ 539,397$ (537,456)$ 2,287,431$ 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 3/31/23 3/31/23 3/31/22 3/31/23 YTD % of YTD 2023 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax 5,360,306$ 5,137,363 4,000,000$ 128.4%16,000,000$ (222,942)$ State Income Tax 310,019 312,760 286,250 109.3%1,145,000 2,741 Replacement Tax 228,175 222,971 112,500 198.2%450,000 (5,204) Road & Bridge Tax - - 8,750 0.0%35,000 - Local Use Tax 91,355 97,680 75,000 130.2%300,000 6,324 Cannabis Use Tax 3,487 3,079 3,975 77.5%15,900 (408) Grants 733 - 3,916 0.0%15,662 (733) Utility/Telecom. Tax 1,640,474 1,310,982 1,405,750 93.3%5,623,000 (329,492) Licenses and Permits 395,284 1,639,847 487,621 336.3%1,950,485 1,244,563 Charges for Services 504,475 154,750 411,843 37.6%1,647,370 (349,725) Investment Interest 22,701 200,216 50,000 400.4%200,000 177,515 Miscellaneous Income 191,987 160,881 255,888 62.9%1,023,551 (31,107) Total Operating Revenues 8,748,996$ 9,240,530$ 7,101,492$ 130.1%28,405,969$ 491,534$ OPERATING EXPENDITURES Personnel 4,164,609$ 4,338,830$ 5,534,263$ 78.4%22,137,051$ 174,221$ Materials and Supplies 105,067 117,745 149,264 78.9%597,056 12,678$ Operation and Contract 890,149 793,921 1,351,181 58.8%5,404,722 (96,228)$ Other Expenditures 2,142 2,147 2,250 95.4%9,000 5$ Capital Outlay 21,688 10,009 237,644 4.2%950,575 (11,679)$ Total Operating Expenditures 5,183,655$ 5,262,652$ 7,274,601$ 72.3%29,098,405$ 78,997$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 3,565,341$ 3,977,878$ (173,109)$ -2297.9%(692,436)$ 412,537$ INTERFUND TRANSACTIONS Transfers In -$ -$ -$ N/A 677,401$ -$ Transfers Out - N/A - Reimbursements From Other Funds 141,306 - - N/A - (141,306) Reimbursements To Other Funds (27,471) - - N/A - 27,471 Sports Core Loan - N/A - - Total Interfund Transactions 113,835$ -$ -$ N/A 677,401$ (113,835)$ NET FUND INCREASE (DECREASE)3,679,176$ 3,977,878$ (173,109)$ (15,035)$ 298,702$ *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 March 31, 2023 3/31/23 3/31/23 3/31/22 3/31/23 YTD % of YTD 2023 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Hotel Tax 206,094$ 286,749$ 287,500$ 99.7%1,150,000$ 80,655$ Investment Interest 1,453 15,201 3,000 506.7%12,000 13,748 Loan Interest - - 1,000 0.0%4,000 - Miscellaneous - - Total Operating Revenues 207,547$ 301,950$ 291,500$ 103.6%1,166,000$ 94,403$ EXPENDITURES Operation and Contract 27,080$ 12,546$ 168,649$ 7.4%674,595$ (14,534)$ Capital Outlay 52,696 - - N/A - (52,696) Total Expenditures 79,776$ 12,546$ 168,649$ 7.4%674,595$ (67,230)$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 127,772$ 289,404$ 122,851$ 235.6%491,405$ 161,632$ INTERFUND TRANSACTIONS Transfer Out -$ -$ -$ N/A -$ -$ Reimbursements to Other Funds (20,700) - (87,371) 0.0%(349,485) 20,700 Total Interfund Transactions (20,700)$ -$ (87,371)$ 0.0%(349,485)$ 20,700$ NET FUND INCREASE (DECREASE)107,072$ 289,404$ 35,480$ 141,920$ 182,332$ Note - Expenditures are recorded in program 171. Village of Oak Brook Hotel Tax Fund Financial Update For the Period Ending March 31, 2023 3/31/23 3/31/23 3/31/22 3/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 2,239,446$ 2,161,596$ 1,631,250$ 132.5%6,525,000$ (77,850)$ Charges for Services - - N/A -$ Investment Interest 7,799 47,474 6,875 690.5%27,500 39,675 Grants - - 272,433 0.0%1,089,730 - Miscellaneous - - 250 0.0%1,000 - Total Operating Revenues 2,247,245$ 2,209,070$ 1,910,808$ 115.6%7,643,230$ (38,175)$ OPERATING EXPENDITURES Personnel 373,329$ 4,466$ 11,324$ 39.4%45,294$ (368,863)$ Materials and Supplies 113,832 102,301 49,350 207.3%197,400 (11,531) Operation and Contract 211,049 162,555 432,545 37.6%1,730,180 (48,494) Other Expenditures - - N/A - Capital Outlay 18,654 1,314,661 2,306,580 57.0%9,226,320 1,296,007 Total Operating Expenditures 716,864$ 1,583,983$ 2,799,799$ 56.6%11,199,194$ 867,118$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 1,530,381$ 625,087$ (888,991)$ -70.3%(3,555,964)$ (905,294)$ INTERFUND TRANSACTIONS Transfers In -$ -$ -$ N/A -$ -$ Reimbursements From Other Funds 80,844 - - N/A - (80,844) Reimbursements To Other Funds (29,532) - - N/A - 29,532 Total Interfund Transactions 51,312$ -$ -$ N/A -$ (51,312)$ NET FUND INCREASE (DECREASE)1,581,693$ 625,087$ (888,991)$ (3,555,964)$ (956,606)$ Village of Oak Brook Infrastructure Fund Financial Update For the Period Ending March 31, 2023 3/31/23 3/31/23 3/31/22 3/31/23 YTD % of YTD 2023 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax -$ -$ 3,750$ 0.0%15,000$ -$ Real Estate Tax - - 101,250 0.0%405,000 - Investment Interest 28 1,165 3 46594.4%10 1,137 Total Operating Revenues 28$ 1,165$ 105,003$ 1.1%420,010$ 1,137$ EXPENDITURES Operation and Contract -$ 450$ 1,275$ 35.3%5,100$ 450$ Other Expenditures 243,150 336,793 84,181 400.1%336,725 93,643 Total Expenditures 243,150$ 337,243$ 85,456$ 394.6%341,825$ 94,093$ NET FUND INCREASE (DECREASE)(243,122)$ (336,078)$ 19,546$ 78,185$ (92,956)$ Note - Expenditures are recorded in program 283. Village of Oak Brook Promenade TIF Fund Financial Update For the Period Ending March 31, 2023 3/31/23 3/31/23 3/31/22 3/31/23 YTD % of YTD 2023 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Plan Review Fees 225$ 525$ 131$ 400.0%525$ 300$ Building/Inspection Fees 375 600 500 120.0%2,000 225 Water Sales 2,318,089 1,856,671 2,057,500 90.2%8,230,000 (461,418) Unmetered Sales 40,154 6,016 12,500 48.1%50,000 (34,138) Water Connection Fees 83,490 107,410 18,750 572.9%75,000 23,920 Fire Service Charge - - - N/A - - Meter Charges 4,100 6,887 3,750 183.7%15,000 2,787 Special Services - 12,811 2,500 512.4%10,000 12,811 Investment Interest 4,740 171,820 5,000 3436.4%20,000 167,080 Proceeds from Property Sale - - - N/A - - Miscellaneous 25,938 33,174 12,500 265.4%50,000 7,236 Total Operating Revenues 2,477,111$ 2,195,915$ 2,113,131$ 103.9%8,452,525$ (281,197)$ OPERATING EXPENDITURES Personnel 98,110$ 128,633$ 161,905$ 79.4%647,620$ 30,523$ Materials and Supplies 37,220 17,867 17,413 102.6%69,650 (19,352) Operation and Contract 697,114 690,922 1,350,156 51.2%5,400,625 (6,192) Capital Outlay 3,894 - 981,250 0.0%3,925,000 (3,894) Total Expenditures 836,338$ 837,423$ 2,510,724$ 33.4%10,042,895$ 1,084$ Surplus (Deficit) of Revenues Over Expenditures 1,640,773$ 1,358,492$ (397,593)$ -341.7%(1,590,370)$ (282,281)$ INTERFUND TRANSACTIONS Reimbursements To Other Funds (105,123)$ -$ (105,123)$ 0.0%(420,490)$ 105,123$ Total Interfund Transactions (105,123)$ -$ (105,123)$ 0.0%(420,490)$ 105,123$ Fund Increase/(Decrease) - Budgetary Basis 1,535,650$ 1,358,492$ (502,715)$ (2,010,860)$ (177,158)$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay 3,894$ -$ Depreciation Expense (143,750) (143,750) IMRF Pension Expense (11,250) (11,250) OPEB Expense (7,500) (7,500) Total GAAP Adjustments (158,606)$ (162,500)$ Fund Increase/(Decrease) - GAAP Basis 1,377,044$ 1,195,992$ *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, 2023 Village of Oak Brook Monthly Operating Statement Sports Core Fund Consolidated Presentation For the Period Ending March 31, 2023 3/31/23 3/31/23 3/31/23 YTD % of YTD 2023 3/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 -$ -$ -$ 246,450$ 246,450$ 232,313$ 106.1%929,250$ 278,125$ (31,675)$ Greens Fees - - - 2,476 2,476 327,500 0.8%1,310,000 23,242 (20,766) Pro Shop Sales - - - 12,929 12,929 62,500 20.7%250,000 25,161 (12,232) Golf Lessons - - - 5,940 5,940 12,500 47.5%50,000 10,050 (4,110) Driving Range Fees - - - 49,510 49,510 87,500 56.6%350,000 57,525 (8,015) Rentals - 4,500 3,481 1,052 9,032 271,000 3.3%1,084,000 146,228 (137,195) Programs/User Fees - - - - - 17,275 0.0%69,100 - - Food Sales - - - 497 497 72,500 0.7%290,000 6,136 (5,639) Beverage Sales - - - 3,139 3,139 123,000 2.6%492,000 11,638 (8,499) Taste of Oak Brook - - - - - - N/A - - - Grants - - - - - - N/A - - - Other Revenue 443 - - - 443 6,906 6.4%27,625 79 364 Total Operating Revenues 443$ 4,500$ 3,481$ 321,992$ 330,415$ 1,212,994$ 27.2%4,851,975$ 558,183$ (227,768)$ OPERATING EXPENDITURES Personnel -$ -$ 1,926$ 141,347$ 143,273$ 432,080$ 33.2%1,671,380$ 185,256$ (41,983)$ Materials & Supplies 5,098 - 18 (28,618) (23,502) 205,510 -11.4%718,900 14,280 (37,783) Operational & Contractual 62,897 18,181 9,672 37,645 128,395 188,954 68.0%942,765 102,783 25,612 Other - - - - - - N/A - - - Capital - - - 39,965 39,965 394,688 10.1%466,750 0 39,965 Total Operating Expenditures 67,995$ 18,181$ 11,616$ 190,338$ 288,130$ 1,221,231$ 23.6%3,799,795$ 302,319$ (14,189)$ B&T Administration Overhead Allocation*-$ -$ -$ -$ -$ -$ N/A -$ -$ -$ Operating Revenues Over (Under) Expenditures (67,552)$ (13,681)$ (8,135)$ 131,653$ 42,285$ (8,238)$ -513.3%1,052,180$ 255,864$ (213,579)$ INTERFUND TRANSACTIONS Interfund Loan**-$ -$ -$ -$ -$ -$ N/A -$ -$ -$ Transfer From General Fund - - - - - - N/A - - - Transfer From Golf Surcharge Fund - - - - - 37,500 0.0%150,000 - - Reimbursement From Infrastructure Fund - - - - - - N/A - - - Reimbursement From Water Fund - - - - - - N/A - - - Reimbursement To General Fund - - - - - (20,242) 0.0%(80,967) (18,864) 18,864 Total Interfund Transactions -$ -$ -$ -$ -$ 17,258$ 0.0%69,033$ (18,864)$ 18,864$ Total Revenues Over (Under) Expenditures - Budgetary Basis (67,552)$ (13,681)$ (8,135)$ 131,653$ 42,285$ 9,021$ 1,121,213$ 237,000$ (194,715)$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ -$ -$ 39,965$ 39,965$ (0)$ Depreciation Expense (42,057) (421) (25,000) (61,575) (129,053) (104,053) IMRF Pension Expense (513) - (1,250) (6,125) (7,888) (6,638) OPEB Expense - - (1,250) (7,000) (8,250) (7,000) Total GAAP Adjustments (42,569)$ (421)$ (27,500)$ (34,735)$ (105,226)$ (117,690)$ Fund Increase/(Decrease) - GAAP Basis (110,121)$ (14,103)$ (35,635)$ 96,918$ (62,941)$ 119,309$ *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, 2023 3/31/23 3/31/23 822 3/31/23 YTD % of YTD 2023 3/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 -$ -$ -$ -$ -$ 129,813$ 0.0%519,250$ 450$ (450)$ Programs/User Fees - - - - - 17,275.00 0.0%69,100 - - Food Sales - - - - - 10,000.00 0.0%40,000 - - Beverage Sales - - - - - 4,250.00 0.0%17,000 - - Grants - - - - - - N/A - - - Other Revenue 443 - - - 443 581 76.1%2,325 79 364 Total Operating Revenues 443$ -$ -$ -$ 443$ 161,919$ 0.3%647,675$ 529$ (86)$ OPERATING EXPENDITURES Personnel -$ -$ -$ -$ -$ 49,692$ 0.0%198,768$ 249$ (249)$ Materials & Supplies - 2,144 739 2,216 5,098 17,949 28.4%71,796 154 4,944 Operational & Contractual 26,245 36,526 125 - 62,897 61,746 101.9%246,985 26,740 36,157 Other - - - - - N/A - - Capital - - - - - 137,500 0.0%550,000 (1,949) 1,949 Total Operating Expenditures 26,245$ 38,670$ 864$ 2,216$ 67,995$ 266,887$ 25.5%1,067,549$ 25,194$ 42,801$ B&T Administration Overhead Allocation*-$ -$ -$ -$ -$ -$ N/A 43,783$ -$ -$ Operating Revenues Over (Under) Expenditures (25,803)$ (38,670)$ (864)$ (2,216)$ (67,552)$ (104,969)$ 64.4%(376,092)$ (24,665)$ (42,887)$ Transfer From General Fund - - - - - - N/A - - Reimbursement From Infrastructure Fund - - - - - -$ N/A - - - Reimbursement From Water Fund - - - - - - N/A - - - Reimbursement To General Fund - - - - - (5,061) 0.0%(20,242) (4,716) 4,716 Total Interfund Transactions -$ -$ -$ -$ -$ (5,061)$ 0.0%(20,242)$ (4,716)$ 4,716$ Total Revenues Over (Under) Expenditures - Budgetary Basis (25,803)$ (38,670)$ (864)$ (2,216)$ (67,552)$ (110,029)$ (396,334)$ (29,381)$ (38,171)$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ -$ -$ -$ -$ (1,949)$ Depreciation Expense (16,090) (25,000) (675) (292) (42,057) (42,057) IMRF Pension Expense (500) - - (13) (513) (513) Total GAAP Adjustments (16,590)$ (25,000)$ (675)$ (305)$ (42,569)$ (44,519)$ Fund Increase/(Decrease) - GAAP Basis (42,393)$ (63,670)$ (1,539)$ (2,520)$ (110,121)$ (73,899)$ *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 March 31, 2023 3/31/23 3/31/23 3/31/23 YTD % of YTD 2023 3/31/22 Difference 815 816 YTD Amended Amended Adopted YTD Prior Polo Open Fields Total Budget Budget Budget Total Year OPERATING REVENUES Field Rentals -$ 4,500$ 4,500$ 45,250$ 9.9%181,000$ 51,393$ (46,893)$ Range Rentals - - - 21,250 0.0%85,000 80,000 (80,000) Taste of Oak Brook - - - - N/A - - - Other Revenue - - - N/A - - - Total Operating Revenues -$ 4,500$ 4,500$ 66,500$ 6.8%266,000$ 131,393$ (126,893)$ OPERATING EXPENDITURES Personnel -$ -$ -$ -$ N/A -$ -$ Materials & Supplies - - - 2,373 0.0%9,490$ - - Operational & Contractual 12,850 5,331 18,181 31,485 57.7%125,940 13,849 4,332 Capital - - - - N/A - - Total Operating Expenditures 12,850$ 5,331$ 18,181$ 33,858$ 53.7%135,430$ 13,849$ 4,332$ Operating Revenues Over (Under) Expenditures (12,850)$ (831)$ (13,681)$ 32,643$ -41.9%130,570$ 117,544$ (131,225)$ INTERFUND TRANSACTIONS Transfer From Hotel Tax Fund -$ -$ -$ -$ N/A -$ -$ -$ Total Interfund Transactions -$ -$ -$ -$ N/A -$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis (12,850)$ (831)$ (13,681)$ 32,643$ 130,570$ 117,544$ (131,225)$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ -$ -$ -$ Depreciation Expense - (421) (421) (421) Total GAAP Adjustments -$ (421)$ (421)$ (421)$ Fund Increase/(Decrease) - GAAP Basis (12,850)$ (1,253)$ (14,103)$ 117,123$ *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, 2023 3/31/23 3/31/23 821 YTD % of YTD 2023 3/31/22 Difference B&T Amended Amended Adopted YTD Prior Clubhouse Budget Budget Budget Total Year OPERATING REVENUES Rentals 3,481$ 87,500$ 4.0%350,000$ 7,344$ (3,863)$ Other Revenue - - 0.0%- - - Total Operating Revenues 3,481$ 87,500$ 4.0%350,000$ 7,344$ (3,863)$ OPERATING EXPENDITURES Personnel 1,926$ 35,738$ 5.4%142,954$ 28,268$ (26,342)$ Materials & Supplies 18 5,993 0.3%23,972 14 4 Operational & Contractual 9,672 19,210 50.3%76,842 9,359 313 Capital - - N/A - 1,949 (1,949) Total Operating Expenditures 11,616$ 60,942$ 19.1%243,767$ 39,590$ (27,975)$ B&T Administration Overhead Allocation*-$ -$ N/A (43,784)$ -$ -$ Operating Revenues Over (Under) Expenditures (8,135)$ 26,558$ -30.6%62,449$ (32,246)$ 24,111$ INTERFUND TRANSACTIONS Transfer From General Fund -$ -$ 0.0%-$ -$ -$ Total Interfund Transactions -$ -$ 0.0%-$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis (8,135)$ 26,558$ 62,449$ (32,246)$ 24,111$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ 1,949$ Depreciation Expense (25,000) - IMRF Pension Expense (1,250) - OPEB Expense (1,250) - Total GAAP Adjustments (27,500)$ 1,949$ Fund Increase/(Decrease) - GAAP Basis (35,635)$ (30,297)$ *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, 2023 3/31/23 3/31/23 823 831 832 833 834 3/31/23 YTD % of YTD 2023 3/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 -$ 246,450$ -$ -$ -$ 246,450$ 102,500$ 240.4%410,000$ 277,675$ (31,225)$ Greens Fees - 2,476 - - - 2,476 327,500 0.8%1,310,000 23,242 (20,766) Pro Shop Sales - 12,929 - - - 12,929 62,500 20.7%250,000 25,161 (12,232) Golf Lessons - - 5,940 - - 5,940 12,500 47.5%50,000 10,050 (4,110) Driving Range Fees - - 49,510 - - 49,510 87,500 56.6%350,000 57,525 (8,015) Rentals - - - 1,052 - 1,052 117,000 0.9%468,000 7,491 (6,439) Food Sales 497 - - - - 497 62,500 0.8%250,000 6,136 (5,639) Beverage Sales 3,139 - - - - 3,139 118,750 2.6%475,000 11,638 (8,499) Other Revenue - - - - - - 6,325 0.0%25,300 - - Total Operating Revenues 3,635$ 261,855$ 55,450$ 1,052$ -$ 321,992$ 897,075$ 35.9%3,588,300$ 418,917$ (96,925)$ OPERATING EXPENDITURES Personnel 15,148$ 81,707$ 219$ 757$ 43,516$ 141,347$ 346,649$ 40.8%1,386,598$ 156,739$ (15,392)$ Materials & Supplies 6,278 (53,295) - - 18,399 (28,618) 179,195 -16.0%716,780 14,112 (42,731) Operational & Contractual 1,573 15,428 5,000 - 15,644 37,645 76,512 49.2%306,050 52,834 (15,189) Other - - - - - - - N/A - - - Capital - 35,600 4,365 - - 39,965 257,188 15.5%1,028,751 - 39,965 Total Operating Expenditures 22,999$ 79,440$ 9,584$ 757$ 77,559$ 190,338$ 859,545$ 22.1%3,438,178$ 223,686$ (33,347)$ Operating Revenues Over (Under) Expenditures (19,363)$ 182,415$ 45,866$ 295$ (77,559)$ 131,653$ 37,530$ 350.8%150,122$ 195,231$ (63,578)$ INTERFUND TRANSACTIONS Transfer from Golf Surcharge -$ -$ -$ -$ -$ -$ 37,500$ 0.0%150,000$ -$ -$ Reimbursement to General Fund - - - - - - (15,181) 0.0%(60,725) (14,148) 14,148 Total Interfund Transactions -$ -$ -$ -$ -$ -$ 22,319$ 0.0%89,275$ (14,148)$ 14,148$ Total Revenues Over (Under) Expenditures - Budgetary Basis (19,363)$ 182,415$ 45,866$ 295$ (77,559)$ 131,653$ 59,849$ 239,397$ 181,083$ (49,430)$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay -$ 35,600$ 4,365$ -$ -$ 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)$ 3,100$ 3,540$ (3,250)$ (36,500)$ (34,735)$ (74,700)$ Fund Increase/(Decrease) - GAAP Basis (20,988)$ 185,515$ 49,406$ (2,955)$ (114,059)$ 96,918$ 106,383$ *Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.