Loading...
HomeMy WebLinkAboutWK - April 25, 2023AC I ' 60' -�; 1685 CROSSTOWN BOULEVARD N.W. • ANDOVER, MINNESOTA 55304 • (763) 755-5100 FAX (763) 755-8923 • WWW.ANDOVERMN.GOV City Council Workshop Tuesday, April 25, 2023 City Hall — Conference Rooms A & B 1. Call to Order— 6:00 p.m. 2. Discuss Results of Biological Study of Water Treatment Plant —Engineering 3. 2024 Budget Development Discussion —Administration a. Compensation/Benefits Survey Discussion 4. March 2023 Community Center Update —Administration 5. Other Topics 6. Adjournment 0 1685 CROSSTOWN BOULEVARD N.W. • ANDOVER, MINNESOTA 55304 • (763) 755-5100 FAX (763) 755-8923 • WWW.ANDOVERMN.GOV TO: CC: FROM: SUBJECT: DATE: Mayor and Council Members Jim Dickinson, City Administrator David D. Berkowitz, Director of Public Works/City Engineer Discuss Results of Biological Study at Water Treatment Plant — Engineering April 25, 2023 INTRODUCTION The City Council is requested to discuss the results of the Biological Study at the Water Treatment Plant and discuss the recommended next steps in the process. DISCUSSION Steve Nelson with WSB, the consulting firm that conducted the biological pilot plant study for the Water Treatment Plant will be at the meeting to review and discuss the results of the study and discuss the recommended next steps in the process. ACTION REQUIRED Staff is requesting direction from the City Council on how to proceed with biological treatment based on the results of the Biological Study. Respectfully submitted, David D. Berkowitz Attachment: Study Summary from WSB✓ WS61 Biological Filtration Pilot Study at Andover Water Treatment Plant Summary WSB's pilot skid was mobilized to the Andover WTP in October 2022 to start the biological filtration pilot study. The study was successfully completed in February 2023. WSB's pilot skid utilized two (2) filters to compare biological removal performance of the Andover WTP's existing filter media against new media of the same kind with different media depths. Both filters achieved similar performance with treated iron concentration of 0.03 mg/L; average treated manganese concentration of 0.030 mg/L; and an average ammonia concentration of 0.07 mg/L Implementing biological filtration at the Andover WTP would eliminate the need to pre -chlorinate and feed sodium permanganate to oxidize ammonia and manganese, respectively. This study estimates that eliminating both chemicals in Andover could generate over $2,000,000 in operational savings over the next 20 years. M 0 Based on the successful implementation of pilot -scale biological filtration the next steps are 0 recommended: Z w 3 • Submit report to MDH for review and approval • Continue to investigate feasibility of implementing biological filtration at the full-scale facility. • Filter evaluation: o Determine effective life of existing media o Identify opportunities to improve efficiencies and harness the benefits of biological filtration. N 0 K1020924-000\Water - Wastewater\Data\Presentations\Council Packet Summary - Biological Filtration Pilot Study at Andover Water Treatment Plant do" C I T Y 0 F 6'P__ I t_�LNDOVEA -- 1685 CROSSTOWN BOULEVARD N.W. • ANDOVER, MINNESOTA 55304 • (763) 755-5100 FAX (763) 755-8923 • WWW.ANDOVERMN.GOV TO: Mayor and Councilmembers FROM: Jim Dickinson, City Administrator SUBJECT: 2024 Budget Development Progress Update/Discussion DATE: April 25, 2023 City Administration has started to focus on the 2024 Annual Operating Budget Development process and is looking to update the City Council and seek direction as the preparation of the 2024 Annual Operating Budget proceeds. City Administration will review briefly with the Council the bold italics items at the meeting. The following are the 2024 Budget Development guidelines adopted at the April 4h City Council meeting: 1) A commitment to a City Tax Capacity Rate to meet the needs of the organization and positioning the City for long-term competitiveness using sustainable revenue sources and operational efficiencies. Note: Preliminary Anoka County Assessor estimated taxable market value figures for the City of Andover base on numbers presented at the Board of Review meeting are reflecting a 3.43 % increase in total taxable market value for 2024, last year the increase was 23%. 2) A fiscal goal that works toward establishing the General Fund balance for working capital at no less than 45% of planned 2024 General Fund expenditures and the preservation of emergency fund balances (snow emergency, public safety, facility management & information technology) through targeting revenue enhancements or expenditure limitations in the 2023 adopted General Fund budget. Note: With property tax revenues making up close to 80% of the total General Fund revenues cash flow designations approaching 50% are appropriate and recommended by the City's auditor. The 2023 budget development exceeded this guideline for cash flow, also Emergency Fund Balances (approximately 3% ofplanned General Fund expenditures per finance policy) are in place to stabilize a situation, not be a complete solution. Staff will review with the Council the final -audited 2022 General Fund Fund Balance Analysis at the May/June workshop meeting. 3) A commitment to limit the 2024 debt levy to no more than 25% of the gross tax levy and a commitment to a detailed city debt analysis to take advantage of alternative financing consistent with the City's adopted Debt Policy. Note: The adopted 2023 debt levy was 22.06% of the gross tax levy, the 25% guideline for 2024 will be attained via the structured management of the current long-term debt 4) A comprehensive review of the condition of capital equipment to ensure that the most cost- effective replacement schedule is followed. Equipment will be replaced based on a cost benefit analysis rather than a year -based replacement schedule. Note: The City Vehicle Purchasing Committee has been meeting and is performing this analysis and will make recommendations on equipment needs to the City Council as part of the 2024-2028 Capital Improvement Plan (CIP) development process. This will be covered in more detail with CIP discussions. 5) The use of long-term financial models that identify anticipated trends in community growth and financial resources that will help designate appropriate capital resources for future City needs. The financial models will be used in the budget planning process to ensure that key short-term fiscal targets are in line with long-term fiscal projections. Note. The City continually maintains various financial models to determine the long-term impacts of present-day expenditures and financing decisions. Fiscal assumptions are based upon a set of financial data including growth factors, tax capacity valuations, per capita spending, fund balance reserve, and debt ratios. Administration will review the attached Lone Range Debt Levy & General Fund Impacts model at the workshop. 6) Continued commitment to strategic planning targeted toward meeting immediate and long- term operational, staffing, infrastructure and facility needs. Note: The most recent Council Community Vision and Organizational Goals and Values document was adopted by the City Council on December 3, 2019. Administration is coordinating a session May/June 2023 and will assure that direction provided from those discussions is integrated into department work plans and budgets. 7) A management philosophy that actively supports the funding and implementation of Council policies and goals, and a commitment to being responsive to changing community conditions, concerns, and demands, and to do so in a cost-effective manner. Note: Special attention will be given to fiscal values, commercial & residential development or redevelopment, collaboration opportunities, service delivery, livability, and image of the community. Staffing: There are anticipated retirements and staff vacancies within the current and the next few years; in response Administration/Human Resources continues to focus on succession planning, utilization of internship opportunities, continued cross -training of staff, and/or realignment of resources. Some realignments added significant new responsibilities and pay adjustments were made, all accommodated within the current Human Resources budget. Administration is expecting new staffing requests from various Departments for the 2024 budget. Deadline for submission of those requests is July Is: Personnel Related Implications: To date the following are the other projected issues facing personnel related expenses: 1. Human Resources has reviewed all position -based salaries and the associated benefit package to determine if the total package is competitive with other government entities. The Human Resources Manager will be present at the workshop to discuss the fmdinus and seek Council direction on how to proceed. The current Public Works Union contract expires December 31, 2023. Negotiations will start up in early May for a 2024 contract. 2. A midyear review of the employee health plan for the 2024 Budget will be conducted with our broker in late June. For the 2023 budget, Administration at the November 1, 2022, Council meeting, recommended to stay with the Health Partners Open Access program, our existing plan with the 3% increase. The HSA plan with higher deductibles ($6,900 single and $13,800 family) and stacked with an HRA (Health Reimbursement Arrangement) is being offered. The HRA was originally funded utilizing premium savings that were achieved from a proposed renewal to a new higher deductible plan. Employees have $3,500 single and $7,000 family deductibles; but with the stacked HRA, the City will reimburse the remainder of the deductible, if needed, to the provider up to $3,400 for single and $6,800 for family. The plan offered is accompanied with a health spending account (HSA), originally implemented in 2006. The City does contribute annually to an employee's HSA to assist with the high deductible out of pocket costs. Contractual Departments: 1. The City Attorney 2023 contract reflected a 2% increase over the 2022 contract. A status quo contract will be looked at for 2024. 2. The approved 2023 City of Andover Law Enforcement expenditure is budgeted at $3,347,315 (0.3% increase) which is offset by a Police State Aid revenue budget of $126,192 and School Liaison revenue budget of $106,465 reflecting a net tax levy impact of $3,114,658 (0.68% increase). The 2023 Sheriffs contract provides for: a. 72 hours per day of patrol service b. 6 hours per day of service provided by a Community Service Officer c. School Liaison Officers in the middle school and high school d. 2 Patrol Investigators e. 50% of the Crime Watch Program's coordinator position Per contract, the Sheriff always provides the required number of deputies for all hours contracted by the City. If the Sheriffs Office has a deputy vacancy or a deputy is injured etc., they still provide the City with a deputy at straight time even though they may have to fill those hours with overtime which at times may cost the Sheriffs Department additional but is not billable per the contract. Staff has had initial discussions with the Anoka County Sheriff for a 2024 status quo contract, and the Anoka County Sheriffs Office will be scheduled to be before the City Council at the June or August workshop meeting. Council Memberships and Donations/Contributions: The following memberships/contributions are in the 2023 proposed budget: • North Metro Mayors Association $14,405 (GF) • Metro Cities $ 9,569 (GF) • Mediation Services $ 3,816 (GF) ■ YMCA — Water Safety Program $ 9,000 (GF) ■ Alexandra House $20,928 ($15,328 GF & $5,600 CG) • Youth First (Program Funding) $15,000 ($12,000 GF & $3,000 CG) • NW Anoka Co. Community Consortium - JPA $10,000 (GF) ■ Teen Center Funding (YMCA) $26,000 ($8,100 GF & $17,900 CG) • Family of Promise $ 3,000 (CG) • Lee Carlson Central Center for Family Resources $ 1,500 (GF) ■ Senior High Parties $ 1,000 (CG) • Stepping Stone $ 1,000 (CG) ■ Hope for Youth $ 1,000 (CG) • Andover Senior Center $ 2,500 (GF) Some are funded via the General Fund (GF), and those that qualify for charitable gambling funding are done through the Charitable Gambling (CG) Special Revenue Fund. Council direction will be sought on the memberships/contributions for 2024. Debt Service Lew: Annually the Finance Department conducts a detailed debt service analysis to monitor outstanding debt and to look for early debt retirement or refinancing opportunities that will yield interest expense savings to the city. (Staffalong with Ehlers & Associates have completed reviews to see if any refinancing opportunities are available at this time, currently there are none; we will then continue to monitor refunding opportunities, as markets move quickly, and calculate potential savings for each issue that may meet parameters which may generate savings) The 2023 Debt Service levy is as follows: • 2012C Taxable G.O. Abatement Bonds $ 969,745 Final levy year 2031 • 2018A CIP Bonds $ 612,794 Final levy year 2043 • 2019A GO Abatement Bonds $1,028,782 Final levy year 2039 • 2020A GO Equipment Certificates $ 376,740 Final levy year 2023 • 2021A GO Equipment Certificates $ 174,773 Final levy year 2025 • 2021A GO Street Reconstruction $ 603,863 Final levy year 2029 Total 3 766 697 Staff will review with the Council at the meeting, primarily to determine how the debt service budget guideline will be met ACTION REQUESTED The Council is reauested to receive a presentation and provide direction to staff. Certificates of Indebtedness 201 IA G.O. Equipment Cenificatcs 2012A G.O. Equipment Cenificams 2014A G.O. Equipment Certificates 2016A G.O. Equipmem Certificates 2020A G.O. Equipment Cenificmes 2021A G 0. Fquipment Certificates 1ILlipuipmem Purchases; Levy 2024 Equipment Certificate - 2026 Equipment Certificate - 2028 Equipment Certificate - 2030 Equipmem Certificate - 2032 Equipment Certificate - Subtotal Capital Improvement Bonds 10128 G.O. Cap Improv Ref Bonds 2018A G.O. Cap Impmv Plan Bonds Transfer from Water & Sewer EF 2031 G.O. CIP Bonds Subtotal Referendum Bonds Open Space Referendum Bonds Street Bonds 202A G.O. Simi Recon Transfer from PIR Fund Special Assessments Subtotal Community Center Abatement Bonds 2012C G.O. Abatement Bonds 'Transfer from Operations 2019A GO Tax Abatement Bonds -Transfer from Park Dedication (Sim) (10101-09130) Subtotal DEBT SERVICE LEVY CITY OF ANDOVER Long Range Debt Levy & General Fund Impacts 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 142,885 295,470 295,260 294,945 294,525 152,529 143,310 142,837 143,373 350,000 406,224 374,850 376,740 170,000 170,000 174,773 174,825 176,715 400,000 420.000 440,000 460,000 - - - - - 180,000 190,000 200,000 210,000 - - - Dependent upon operational revenues exceeding operational expenditures Actual Actual Actual Actual Actual Actual Actual Adopted Proposed 480,000 500,000 520,000 540,000 - - 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 220,000 230,000 240,000 250,000 2032 2073 Tax Capacity Value 26,847273 27,920,178 31,287,043 32,975,265 36,099,539 37,366,775 40,210,548 50,267,978 51,273,338 52,298,804 53,344,780 54,411,676 55,499,910 560,000 580,000 438355 947,789 963255 437,362 493,373 576229 514,850 1,686222 3,124,274 596715 620000 650,000 680,000 710,000 740,000 770,000 800.000 830.000 551,517 574.825 1,177,939 1,201,498 4.00% 12.06% 5.40% 9.47% 3.51% 7.61% 25.01% 2.00%. 2.00% 2,00% 2.00% 2.00% 2.00% 2.00% 498,435 2D0% 2.00% Gross Tax Levy 11,593,925 11,938.555 12,416,757 13,103,487 14,479,586 14,913,945 16,107,254 17,073,084 17,585,277 18,112,835 18,656220 19215,906 19,792,384 20,386,155 20,997,740 21,627,672 22,276,502 525,000 478,903 501,644 662,819 658,094 658,094 662,557 660,419 663,344 662,189 660,719 658,934 662,084 659,512 661,874 593,772 611,585 629,932 648,830 (45,300) (45,300) (45,300) (45,300) (45,300) (45,300) (45,300) (45,300) (45,300) (45,300) (45,300) (45,300) (45,300) (45,300) 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% General Fund 975,000 975,000 498,435 456344 617,519 612.794 612.794 617.257 615,119 12,327212 12,686,944 615 dig 613,634 616.784 1,589,212 1,591,574 616,044 616.869 525,000 431,603 16,682,473 17,182,947 17,698,435 18229,388 -0.05% 3.80% 7.64% 2.92% 1.00% 5.03% 0.79% 3.00% 186,291 187,940 188,777 183,989 184,199 151,078 3.80% 3.00% 3.00% Expenditures 10,509,726 11,039,974 11,105,246 - 12,395,879 12,841,500 13,119,829 - 14,218,980 14,538,907 14,866,032 15,200,518 15,542,530 15,892237 16,249,812 16,615,433 16,989,280 17,371,539 5.05% 0.59% -0.05% 11.68% 3.59% 2.17% 5.99% 2.25% 2.25%. 2.25% 1,001,003 1,003,863 1,001,658 999,138 1,001,553 1,003,548 999,086 998,844 7,796,745 7,789,616 8,136,336 9363,451 9,654,518 9,626,466 9,964,341 9,622,626 9,374,955 9,226,496 9,182,625 9,248,931 9,431,234 9,735.573 (401,003) (200,000) (150,000) (150,000) (1001000) (100,000) (50,000) (50,000) 84.36% Moved to Road & Bddge Levy 74.96% 75.95% 69.20% 65.93% 63.46% 61.77% 60.85% 60.68% (200,000) (200,000) (200,000) (200,000) (200,000) (200,000) 1200.000) 600,000 603,963 651.658 649,138 701,553 703,548 749,086 748,844 - - - - 1,123,081 1,135,629 1,152,032 1,146351 1,111,175 1,183,646 1,762369 1,768,170 1,839,277 1,863,110 1,936,672 1,971592 2,045,975 2,074263 1353,674 1386,784 2,389,212 2,421,574 1277,332 1,274,418 1,272,055 1,269,378 1,276,780 1,273,263 074,628 1,269,745 1,273,650 1,269,824 1268,689 1,265,513 1265,404 1,273,309 1,274,070 1,278,900 - - (300,000) (300.000) (300,000) (300,000) (300,000) (300.000) (300.000) (300,000) (300,000) (300.000) (300,000) (300,000) (300,000) (300.000) (300,000) (300,000) - - 1,176,236 1,179,570 1,177208 1,178,783 1,178,783 1,177,208 1,179,308 1,174,320 1,178,258 1,177,628 1,175,738 1,177,838 1,176,998 1,175,370 (175,146) (202,604) (163,143) (150,000) (150,000) (159,107) 977332 974,418 972,055 969,378 1,977,870 1,950229 1,988,693 1,998,529 2,002,433 1,987,925 2,147,997 2,139,833 2,143,662 2,150,937 2,149,808 2,156,738 1,176,998 1,175370 2 ,100 413 2,110,047 2,124,087 2,115.729 3,089.045 3.133.875 3,751,062 3,766.698 3,841,710 3,851,035 4084669 4.111.425 4.189,637 4.225200 3,503,042 3,513522 3.566.210 3.596.944 9,634 14,040 (8,358) 973,316 44,830 617,187 15,636 75,012 9.325 233.634 26,756 78,212 35.563 (721,758) 40,080 22,688 30,734 0.46% 0.67% -0.39% 46.00% 1.45% 19.69% 0.42% 1.99% 0.24% 6.07% 0.66% 1.90% 0.85% -17.08% 1.14% 0.64% 0.86% Dependent upon operational revenues exceeding operational expenditures 11 rift Actual Actual Actual Actual Actual Actual Actual Adopted Proposed 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2073 Tax Capacity Value 26,847273 27,920,178 31,287,043 32,975,265 36,099,539 37,366,775 40,210,548 50,267,978 51,273,338 52,298,804 53,344,780 54,411,676 55,499,910 56,609,908 57,742,106 58,896,948 60,074,887 61,276,385 1,072,905 1,366,865 1,686222 3,124,274 1,267,236 2,843,773 10,057,430 1,005,360 1,025,467 1,045,976 1,066,896 1,088,234 1,109,998 1,132,198 1,154,842 1,177,939 1,201,498 4.00% 12.06% 5.40% 9.47% 3.51% 7.61% 25.01% 2.00%. 2.00% 2,00% 2.00% 2.00% 2.00% 2.00% 2,00% 2D0% 2.00% Gross Tax Levy 11,593,925 11,938.555 12,416,757 13,103,487 14,479,586 14,913,945 16,107,254 17,073,084 17,585,277 18,112,835 18,656220 19215,906 19,792,384 20,386,155 20,997,740 21,627,672 22,276,502 22,944,797 344,630 477,802 687,130 1,376,099 434,359 1,193,309 965,830 512,193 527,558 543,385 559,687 576,477 593,772 611,585 629,932 648,830 668,295 2.97% 4.00% 5.53% 10.50°/. 3.00% 8.00% 6.00% 3.00% 3.00% 3.00% 3.00k 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% General Fund Revenues 11,038,567 11,072,846 11,451,964 12,327212 12,686,944 12,813,448 13,457,704 13,564,378 13,971309 14390,448 14,822,161 15266,826 15,724,831 16,196,576 16,682,473 17,182,947 17,698,435 18229,388 -0.05% 3.80% 7.64% 2.92% 1.00% 5.03% 0.79% 3.00% 3.00% 3.00^k 3.00% 3.00% 3.00% 3.00% 3.80% 3.00% 3.00% Expenditures 10,509,726 11,039,974 11,105,246 11,099,494 12,395,879 12,841,500 13,119,829 13,906.093 14,218,980 14,538,907 14,866,032 15,200,518 15,542,530 15,892237 16,249,812 16,615,433 16,989,280 17,371,539 5.05% 0.59% -0.05% 11.68% 3.59% 2.17% 5.99% 2.25% 2.25%. 2.25% 2.25% 2.25% 2.25% 2.25% 2.25% 2.25% 2.25%. Fund Balance 7,796,745 7,789,616 8,136,336 9363,451 9,654,518 9,626,466 9,964,341 9,622,626 9,374,955 9,226,496 9,182,625 9,248,931 9,431,234 9,735.573 10,168234 10,735,748 11,444,903 12,302,752 Fund Balance %of Expenditures 74.19% 70.56% 73.27% 84.36% 77.88% 74.96% 75.95% 69.20% 65.93% 63.46% 61.77% 60.85% 60.68% 61.26% 62.57% 64.61% 67.37% 70.82% 11 rift 1685 CROSSTOWN BOULEVARD N.W.. ANDOVER, MINNESOTA 55304 . (763) 755-5100 FAX (763) 755-8923 . WWW.ANDOVERMN.GOV TO: Mayor and Councilmembers FROM: Jim Dickinson, City SUBJECT: March 2023 DATE: April 25, 2023 INTRODUCTION: Attached for Council review is the Andover Community Center (ACC) Budget Summary Report for Budget Year 2022 and Budget Year 2023. The reports reflect activity through March 2023 with comparative data with March 2022. March 2023 Financials Coming off 2020 imposed COVID restrictions shutting down the entire facility mid-March of 2020, the facility was allowed to reopen in a restricted capacity early January 2021. The ACC operated at near full capacity for close to twelve months in 2021 and did operate at full capacity throughout 2022. 2023 Revenues are behind in comparison to 2022, this is due to ice rental payment timing. 2023 ice rental is expected to be comparable to 2022 versus in 2021 when the Sports Complex ice was not converted to turf and ice rentals filled that space. The 2023 expenses are mixed in comparison with 2022 primarily in salaries as ACC was able to fill our staffing needs in 2023 versus 2022 where full staffing was still a struggle. It is anticipated that 2023 activities will be comparable to the previous year as we proceed through the year, although we still will have some variability in staffing since it took until April of last year (2022) to be fully staffed. The 2023 Capital Outlay line item is for a high volume/output water heater replacement and dehumidification system replacement. Also provided is an ACC historical perspective of actual costs dating back to 2016. This is the report previously provided to the former ACC Advisory Commission. This report also provides history on debt service payments and the property tax levy assigned to debt and operations. APRIL/MAY 2023 FACILITY UPDATE: Please refer to the attached ACC Facility Update for Major Events and monthly Walking Track activity through February. Major events are picking up as the winter season is in full swing. PROGRAMS/ACTIVITIES UPDATE - ACC is completing the busiest time of the year now, every weekend through March ACC is hosting events. Andover Athletic Basketball hosted league games every Saturday, with all 4 courts running ACC hosts 40 games a day through early March. MN Premier Volleyball hosted volleyball tournaments for eight Sundays in a row through January and February. The hockey playoffs were held throughout February. PROGRAMS - Winter Learn to Skate Lessons began on January 8`h and are now complete. There were 140 kids in the program. The Winter Soccer Program started up January 14`h and is now complete. There were 110 kids in the program. ACC is offering spring Learn to Skate lessons that started March 26`h. There are 124 individuals currently registered, program cap is 140. ACC is offering a spring soccer session that started March 251h in the Sports Complex on the turf. There are 120 kids currently registered, the program cap is full. SCHEDULING - Scheduling for summer 2023 and winter 2023-24 has started; looking to get ahead of the game to help ensure we keep all our prime -time hours sold at close to 100% and find new users and programs to keep building our non-prime/summer usage. TURF - Ice went out the week of February 27`h with turf rentals starting early March. Andover Baseball, Softball, Andover HS, Andover Athletic Track and Field have committed hours. The turf will go out April 26th. ACC has 10 days to get turf out, rink floor cooled and ice in before the Midwest Hockey Youth tournament May 5-7 that will use both rinks. ACTION REQUESTED Informational. The Council is requested to review and receive a staff presentation on the attached reports. Attachments CITY OF ANDOVER CommunityCenter Budget Summary Totals Budget Year 2023 Other financing sour (uses) I 2022 I 2023 REVENUES Budget Mar YTD %Bud Pre -Audit Budget Mar YTD %Bud Investment income Charges for services - we (22,544) 3,000 (3,894) Na Rental/Lease Pymt Ice Rental $ 729,000 $ 242,187 33% $ 794,232 $ 794,000 $ 199,090 25% Turf Rental 50,000 561 ale 18,553 25,000 2,364 9% Track 2,500 1,838 n/a 5,871 3,000 2,852 Na Fieldhouse Rental 240,000 133,325 56% 287,696 255,000 129,937 51% Proshop 13,000 4,373 34% 11,978 13,000 5,639 43% Vending 15,000 7,001 47% 20,978 16,000 6,809 43% Advertising 63,000 17,066 27% 99,436 75,000 6,297 8% Total Charges for services 1,112,500 406,351 37% 1,238,744 1,181,000 352,988 30% Miscellaneous 182,000 29,687 16% 220,434 322,068 25,954 8% Total revenues 1,294,500 436,038 34% 1,459,178 1,503,068 378,942 25% EXPENDITURES 2022 2023 Budget Mar YTD %Bud Pre -Audit Budget Mar YTD %Bud Current: Salaries & benefits 770,110 176,421 23% 809,007 875,369 219,351 25% Departmental 97,100 18,202 19% 96,433 91,850 31,176 34% Operating 603,233 118,940 20% 579,619 679,647 96,616 14% Professional services 248,525 34,103 14% 179,690 181,525 41,529 23% Capital outlay 42,000 16,575 Na 37,358 360,000 0% Comm 1760,968 364,241 21% 1,702 107 2,188,391 388,672 18% Revenue over (under) expense (466,468) 71,797 -15% (242,929) (685,323) (9,730) 1% Other financing sour (uses) General Property Tax Levy 155,000 - 0% 154,614 155,000 - 0% Investment income - - we (22,544) 3,000 (3,894) Na Rental/Lease Pymt 638,000 490,678 77% 631,231 638,000 504,211 79% Transfers out (300,000) (300,000) 100% (300,000) (300,000) (300,000) 100% Total financing sources (uses) 493,000 190,678 39% 463,301 496,000 200,317 40% CITY OF ANDOVER, MINNESOTA Andover Community Center / YMCA Historical Comparison Debt Service Payments 2012C GO Abatement Bonds (P+1) $ 1,216,506 $ 1213,731 $ 1,211,481 $ 1,208,931 $ 1,215,981 $ PRE -AUDIT $ 1213,931 $ 1,209,281 $ 1,209,281 2019A GO Abatement Bonds (P+I) 2016 2017 - 2018 - 2019 2020 2021 2022 1,109,775 2023 2023 Actual 1,216,506 Actual 1,213,731 Actual 1,211,481 Actual $ Actual Actual Actual _S2 Budget Mar -YTD Revenues: Charges for services $ 977,332 $ 974,418 $ 972,055 $ 969,378 $ 976,780 $ 973,263 $ 974,628 $ 969,745 $ 969,745 Ice Rental $ 405,990 $ 392,828 $ 435,716 $ 442,995 $ 361,796 $ 823,856 $ 794,232 $ 794,000 $ 199,090 Turf Rental - - - - - - - 3,782 18,553 155,000 25,000 2,364 Track - 977,332 - 974,418 - 972,055 - $ 301 3,950 5,871 $ 2,143,693 3,000 2,852 Fieldhouse Rental 199,286 215,089 218,667 220,225 133,126 220,527 287,696 255,000 129,937 Proshop 9,412 9,247 8,606 9,680 4,394 9,606 11,978 13,000 5,639 Vending 8,588 9,182 7,470 8,427 6,148 7,763 20,978 16,000 6,809 Advertising 26,450 38,819 34,000 40,850 8,000 84,700 99,436 75,000 6,297 Charges for services 649,726 665,165 704,459 722,177 513,765 1,154,184 1,238,744 1,181,000 352,988 Miscellaneous 136,552 136,149 142,768 131,386 110,781 134,072 220,434 322,068 25,954 Total revenues 786,278 801,314 847,227 853,563 624,546 1,288256 1,459,178 1,503,068 378,942 Expenditures: Current: Salaries & benefits 451,332 481,926 501,108 533,044 503,842 692,742 809,007 875,369 219,351 Departmental 77,945 65,612 76,448 66,570 74,809 82,655 96,433 91,850 31,176 Operating 364,935 364,242 352,067 330,084 345,588 515,308 579,619 679,647 96,616 Professional services 106,381 125,034 104,076 77,818 129,261 85,130 179,690 181,525 41,529 Capital outlay 47,859 4,900 11,442 39,888 100,000 37,358 360,000 Current 1,048,452 1,041,714 1,045,141 1,047,404 1,153,500 1,375,835 1,702,107 2,188,391 388,672 Revenue over under ex enditures (262,174) (240,400) (197,914) (193,841) (528t954) (87,579)1 (242.929)1 685323 9 730 Other financing sources (uses) General Property Tax Levy - - - - - 154,534 154,614 155,000 - Investment income 2,190 2,779 5,780 16,107 6,793 2,817 (22,544) 3,000 (3,894) Rental/Lease Pymt 640,303 641,691 637,150 636,803 635,629 635,026 631,231 638,000 504,211 Transfers out (300,000) (300,000) (300,000) (300,000) (300.000) (300,000) (300,000) (300,000) (300,000) Total financing sources (uses) 342,493 344,470 342,930 352,910 342,422 492,377 463,301 496,000 200,317 Net increase (decrease) in fund balance 80,319 104,070 145,016 159,069 (186,532) 404,798 220,372 (189,323) 190,587 Fund balance (deficit)- January ) 56,140 136,459 240,529 385,545 544,614 358,082 762,880 983,252 983,252 Fund balance (deficit) - December 31 $ 136,459 $ 240.529 $ 385,545 $ 544,614 $ 358,082 $ 762,880 $ 983,252 $ 793 929 $ 1,173,839 Fund Balance Detail: FB - Replac Res for Common Space $ 154,449 $ 179,283 $ 173,560 $ 200,606 $ 190,067 $ 216,790 $ 216,790 $ 81,790 $ 81,790 FB - Unassigned (17,990) 61,246 211,985 344,008 168,015 546,090 766,462 712,139 1,092,049 $ 136,459 $ 240,529 $ 385,545 $ 544,614 $ 358,082 $ 762,880 $ 983,252 $ 793,929 $ 1 173 839 Debt Service Payments 2012C GO Abatement Bonds (P+1) $ 1,216,506 $ 1213,731 $ 1,211,481 $ 1,208,931 $ 1,215,981 $ 1,212,631 $ 1213,931 $ 1,209,281 $ 1,209,281 2019A GO Abatement Bonds (P+I) - - - 590,150 819,725 1,109,775 1,106,900 1,106,900 $ 1,216,506 $ 1,213,731 $ 1,211,481 $ 1208,931 $ 1,806,131 $ 2,032,356 _S2 $ 2,316,181 $ 2,316,181 Property Tax levy 2012C GO Abatement Bonds $ 977,332 $ 974,418 $ 972,055 $ 969,378 $ 976,780 $ 973,263 $ 974,628 $ 969,745 $ 969,745 2019A GO Abatement Bonds - - - - 1,001,090 976,966 1,014,065 1,028,782 1,028,782 Community Center Operations - - 155,000 155,000 155,000 155,000 $ 977,332 $ 974,418 $ 972,055 $ 969,378 $ 1,977,870 $ 2,105,229 $ 2,143,693 $ 2,153,527 $ 2,153,527 AND%VER COMMUNITY CENTER APRIL—MAY 2023 April 8-16 — Just Between Friends Kids Sale April 29 — Carousel Craft Spring Sale May 4-6—Midwest Hockey Youth Tournament May 18-21—Hometown AAA Youth Tournament May 26—PACT School Field Trip May 28-29—ACC Closed Track check in is required, Monday—Friday, 6:30am-4:30pm. Numbers below reflect those checked in during these times. Jan -2252 FPh-9nm March — 2519 March 25—April 22-5pring Indoor Soccer March 26 —April 30—Spring Learn to Skate