The URL can be used to link to this page

Home My WebLink AboutWK - August 27, 2024C I T Y O F ND 4VE 1685 CROSSTOWN BOULEVARD N.W. • ANDOVER, MINNESOTA 55304 • (763) 755-5100 FAX (763) 755-8923 • WWW.ANDOVERMN.GOV City Council Workshop Tuesday, August 27, 2024 City Hall — Conference Rooms A & B 1. Call to Order — 6:00 p.m. 2. Discuss Fence Proposal - Planning 3. Tree Preservation Policy Proposal - Engineering 4. Discuss Potential Development —Verbal — Administration/Planning 5. 2025-2029 Draft CIP Distribution/Discussion — Administration 6. Discuss 2025 Budget Development - Administration a. Discuss City of Andover Employee 2025 Compensation — Human Resources 7. Discuss 2025 Preliminary Tax Levy —Administration 8. Other Topics 9. Adjournment 100? C I T Y O F NNDOVEA 1685 CROSSTOWN BOULEVARD N.W. • ANDOVER, MINNESOTA 55304 • (763) 755-5100 FAX (763) 755-8923 • WWW.ANDOVERMN.GOV TO: Mayor & Councilmembers CC: Jim Dickinson, City Administrator - Joe Janish, Community Develop Dir for FROM: Jake Griffiths, Associate Planner SUBJECT: Discuss Fence Proposal — Planning DATE: August 27, 2024 DISCUSSION The City recently received a fence permit application for a wood framed welded wire fence. A copy of the fence permit application including images of this style of fence is attached for review. City Code 12-7-4-A states that "Fences in all districts shall be constructed or materials widely accepted in the fencing industry. No plywood boards, canvas, plastic sheeting, or metal sheeting shall be used for any fence construction. No fence may have boards, plants, or panels larger than twelve (12) inches in width". After reviewing the fence permit, City staff were unable to make a clear determination on if the proposal met City Code requirements and forwarded the application to the Andover Review Committee (ARC) for review. After review, ARC was also not able to make a clear determination and was split on if this style of fence should be allowed based on the City Code. As far as City staff are aware, this is the first fence permit application that has proposed a wood framed welded wire fence in the community. ACTION REQUESTED The City Council is requested to discuss the fence proposal and provide feedback on whether or not the proposal meets City Code requirements. �spectfully submitted, ,A�/� Jake Griffiths Associate Planner Attachments Fence Permit Application Materials 9NXb6WRJ FENCE I RETAMING WALL PENRWHT APPUCATIJOKI 1685 CROSSTOWN BOULEVARD NW, ANDOVER, MINNESOTA 55304 (763) 755-5100 • FAX (763) 755-8923 • c,m , _ i,4DOVERMN.GOV Project Address: Owner Telephone E -Mail Address 7�-3-y" - 73 7 �.th viz r»� �-"; � Contractor Telephone E -Mail Address Mail Address Contact Person Telephone Mobile Telephone Property Single Family Two-FamilyMultifamily Residential 1:1Residential ❑ Residential ❑ Townhome ❑ Agricultural Type (CHECK ONE)ElCommercial ❑Industrial ❑ Institutional Public 1 Gov't 1:1OTHER Permit FENCE ® See back of this form for maximum RETAINING WALL ❑ Up to 4'- O" tall Type allowable fence heights. ❑ Taller than 4'- 0" (Building Permit Required) (CHECK ONE) Using a dark highlighter, draw the proposed fence/retaining wall location on a certificate of survey for the property. Please include the height and tvne of fence. If you don't have a survey, the City may email or provide a copy to you. If there is no survey for the property, an aerial photo or a sketch below will suffice. (For additional information please see the reverse side Of this form.) r pk jv w i f4 516--614. ��L ��oS� p'� � ,7 �rrr�r k S'",4_ Ole -If j'+� a�� (Gtr r g Signature & Acknowledgement of Contractor or Owner Authorized Agent Date Signature & nent of Owner (If Owner is Builder) Date BELOW - FOR CITY USE ONLY ❑ $75.00 Permit Fee Received NOTES FOR INSTALLATION: ❑ Building Permit Required Engineering 1 Building Dept Approval for Issuance Date: Page I 1 Approx. 20ft. From 4 NNG pipeline M N i3-8 Tt7,6,1 W Approx. 35 ft from NNG pipeline i, 01 3. C I T Y O F NDOVE 1685 CROSSTOWN BOULEVARD N.W. • ANDOVER, MINNESOTA 55304 • (763) 755-5100 FAX (763) 755-8923 • WWW.CI.ANDOVER.MN.US TO: Mayor and Council Members CC: Jim Dickinson, City Administrator David Berkowitz, Director of Public s/City Engineer FROM: Kameron Kytonen, Natural Resources Technician SUBJECT: Gwinn Tree Preservation Policy Proposal - Engineering DATE: August 27, 2024 INTRODUCTION Nature Preserve Commissioner Jonathan Gwinn drafted a proposal with some ideas for advocating developers to protect more trees. It also outlined tree replacement/tree fund requirements for potential scenarios that meet a tree removal threshold. This was initially brought to the March 28, 2023 City Council workshop for discussion. Since that time, City staff has worked with Mr. Gwinn to update the proposal. DISCUSSION Mr. Gwinn's initial report provided information including what the current City Code/Tree Preservation Policy outlines; benefits of trees; other cities' programs; and a general proposal of what could possibly work in the City. The updates made have simplified the proposal and lessened the potential financial penalty for developers if it is adopted. It also uses an existing new development as an example, which shows new trees planted and a proposed tree fund amount that would apply for three different tree replacement scenarios. ACTION REQUIRED The City Council is requested to listen to and discuss Commissioner Gwinn's proposal. Respectfully submitted, �Kameron Kytonen Natural Resources Technician Attach: Updated Gwinn Tree Preservation Policy Proposal Gwinn Tree Proposal 8.27.2024 Andover's Vision Statement Andover, a safe, growing community in which to live and work which enhances the quality of its citizens' lives through recreational opportunity, quiet neighborhoods, civic involvement, fiscal and environmental stewardship. Gwinn Tree Proposal Key Takeaways: 8.27.2024 • Andover's Ordinance for Tree Preservation has not been changed since 2002 • Neighboring communities have taken steps to increase their tree planting/preservation requirements • As shown below, there are many benefits of trees including, increased property value, additional interest from commercial stakeholders, prospective homebuyers (nature view from home), and many more • New developments and various insects and diseases have and continue to affect the overall tree canopy in the City. Emerald Ash Borer (EAB) has and will continue to kill hundreds of trees annually. • A tree fund would provide additional money for preservation and tree planting in the community. It could also offer opportunities for restoration in the realm of natural resources, perhaps even in residents' backyards • Since initial proposal in March of 2023, this has been updated to reflect a new proposal that is generally more fair and reasonable to developers. It has also been significantly simplified. • A tree inventory prior to tree clearing would be required to determine what's out there and what's proposed to be removed/saved • This applies to significant trees that are removed, which is any tree (not invasive) that is at least 6 inches in diameter Gwinn Tree Proposal S[ENAR/D 8.27.2024 Since the last time this was brought for discussion at a City Council Workshop, some adjustments to the proposal have been made. The following table summarizes the new proposal and compares it to the initial proposal from March of 2023. It uses a development (Oakview Acres) as its example with replacement requirements and tree fund amount based on removals that occurred. A color coded hypothetical Landscape Plan also accompanies it. Oakview Acres Proposed Maximum Acreage Tree Meets Replacement Front yard Total Total trees Value of Tree fund specs tree removal threshold? requirements trees replacement unplanted replacement amount replacement threshold trees planted (under tree unplanted per acre (including replacement buffer) requirements) Initial 12 20 240 Yes 240 72 98 142 $600 $85,200 proposal New 8 20 160 Yes 160 72 98 62 $300 $18,600 proposal Optional 6 20 120 Yes 120 72 98 22 $300 $6.600 copynght 4D 2021 ,Wdio gro. Pik !1 Legend. Wes _ ED G MY OF AWXWE I i Oy.l. �. ®w�•,�... o..w wacaw..t •Ra/<.w./eoc.:�..w `v' '•�_/� �_/��```� -_ - _+st__----_T_______ T______ -i i / ___' `` 1 1 t •i �� t ; I 1 - ----------- -- 11 1 1 1 1 i I i - I -- r __ 1 �. Ji `. I I �_______- ` ------------- qb Oil • + � - ; 7 t , j n f �Ij L r � I � • I) I V �^I • �� , a • r. ---- - i �-%\ • .tet/ • ,� +. IJ ' � i 1' i i i - ...• A '` I q �` �1 `/ I j � - tI �,i t`'{. 1 i _ \y ____-_______-i i - 4UK>wd y A rK Tw taFNeW, STUDIO(?iR0 TAMARACK LAND DEVELOPMENT ANDOVER, MN Printed at 22 n 34 OAKVIEW ACRESI scaled"-_ (LASCHINSKI PROPERTY) a so' loot LANDSCAPE PIAN mpynghl ® 2021 studio gro. pllc Upend a Nob" STUDIO (P7RO TAMARACK LAND DEVELOPMENT ANDOVER, MN Printed at 22 x 34 OAWEW ACRES sold'=sa (LASCHINSKIPROPERTY) w' iar L-02 LANDSCAPE PLAN kC I T Y 0 F 50-- NDOVEO- I 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: 2025-2029 Draft CIP Distribution/Discussion DATE: August 27, 2024 INTRODUCTION Late March, Administration/Finance distributed baseline worksheets to Department Heads for the 2025-2029 CIP kick-off. Subsequent discussions centered on the 2025-2029 CIP development, the need of other committees (Vehicle/Equipment Purchasing & Facility Management Committees) and commissions (primarily Parks and Recreation) to complete their work and for Administration/Finance to assemble a "draft" proposed 2025-2029 CIP. For the current 2024 CIP active items, attached is a progress to date 08-15-24 summary for Council reference. DISCUSSION Throughout the summer a significant amount of time has been spent evaluating utility infrastructure, transportation improvements, building maintenance, equipment and park and recreation needs. Each of those items is then supported by a detailed fund balance analysis of funding sources that is also part of the "draft" proposed 2025-2029 CIP. Staff would like the Council to review the "draft" to confirm that the Council's priorities are being met The "draft" has been updated with the most recent Council & Commission discussions. A September 17th Public Hearing will be scheduled for the public to comment on the 2025- 2029 CIP. ACTION REQUESTED The Council is requested to review the attachments, receive a brief presentation, and provide Directions to staff on the "draft" 2025-2029 CIP. submitted, CITY OF ANDOVER 2024 Capital Improvement Plan Projects By Department - Use of Funds Updated 08/15/24 Community Center Repaint Fieldhouse Ceiling $ 70,000 completed Emergency Management Replacement - Siren Transmitter Equipment 140,000 August - replace circuit board Engineering New Development Projects 200,000 on going Pedestrian Trail Maintenance 64,000 completed New Pedestrian Trail & Sidewalk Segments 630,000 under construction Replacement - Total Station Survey Equipment 36,000 purchased New - Trail Machine 930,000 purchased Facility Management 605,000 summer Annual Parking Lot Maintenance / Replacement 90,000 September start date Replacement - Carpet / Tile 30,000 summer to fall project Replacement - Emergency Generator CH 70,000 Installed Replacement - Roof Top Package Units 9-16 CH 112,000 June install Replacement - Garage Door Springs FS #1 25,000 getting estimates City Hall Remodel 100,000 main corridor/bathrooms completed; secondary bathrooms in fall Storm Sewer Improvements 427,000 Fire Replacement - 800 MHz Radios 50,000 purchased Replacement - Engine 31 #4800 970,000 ordered 1,020,000 Park & Recreation - Operations Replace/Repair Play Structures - Various Parks 200,000 completed Replace/Repair Major Park Projects - Various Parks 35,000 completed Replacement - Toro Groundmaster #561 60,000 Delivered Replacement - One Ton Truck w/ Plow #569 90,000 purchased New - Trail Machine 220,000 purchased Sanitary Sewer 605,000 summer Park & Recreation - Projects Annual Miscellaneous Projects 25,000 Prairie Knoll fence complete. Yellow capping late summer Pine Hills North - Building & Shelter 425,000 Project ordered. Possible fall start date. Park Irrigation Improvements 27,000 Wild Iris is complete. Hickory Meadows fall installation Hills of Bunker Lake West Parking Lot Paving 130,000 In progress, late August completion. Annual Street Reconstruction 607,000 near completion Sanitary Sewer 21,000 summer Rural Reserve - Area Analysis & Sanitary Sewer 150,000 ongoing Upgrade Controls at Sanitary Lift Stations 10,000 summer to fall project Sanitary Sewer Flow Meters 95,000 in progress Sanitary Sewer Lift Station Pump Replacement 50,000 city lift station #6 project completed 305,000 Storm Sewer Storm Sewer Improvements 70,000 Streets - Equipment Replacement - Dump Truck w/ Snow Removal #198 315,000 ordered, December chassis delivery Replacement - Dump Truck w/ Snow Removal #200 315,000 ordered, December chassis delivery 630,000 Streets - Roadways Annual Street Seal Coat Project 210,000 completed Annual Pavement Markings 64,000 completed Curb, Sidewalk and Ped Ramp Replacement 115,000 restoration work remains Municipal State Aid Routes / New & Reconstruct 650,000 completed Annual Street Reconstruction 2,400,000 near completion Gravel Road Improvement 21,000 summer Intersection Upgrades 285,000 ongoing Municipal State Aid Routes / Mill & Overlay 380,000 completed Street Full Depth Reclamation 2,460,000 completed Pavement Rejuvenator Application 150,000 completed 6,735,000 CITY OF ANDOVER 2024 Capital Improvement Plan Projects By Department - Use of Funds Updated 08/15/24 Water Replacement - Residential Meters 100,000 meters have been received and installed Water Main Gate Valve Rehabilitation 100,000 Completed valves in 2025 and 2026 project areas Rehabilitation of Wells 180,000 completed WTP High Service Pump Maintenance 150,000 completed Replacement - WTP Valve Actuators 55,000 completed Water Main Improvements 3,000,000 Design is complete, was bid in June WTP Radon Mitigation 1,345,500 project was awarded at 5/21 council meeting Security Cameras at Towers and Well Houses 12,000 well #6 will have cameras installed this summer Update Logic Controls at City Wells 10,000 summer project Fiber Optic Upgrade for City Wells 10,000 Will be completed with fiber install project Replacement - WTP Flow Meters 40,000 completed WTP Door Access Control - Security System 25,000 completed Replacement - Water Testing Equipment 7,500 purchased Fiber Optic Conduit Installation 300,000 awarded project to start soon DO Probes for Biological Treatment 35,000 purchased and will be installed late summer Red Oaks Manor Water Main Improvements 6,100,000 watermain install complete, hooking up houses now Replacement - Plate Settler Plates 180,000 project completed 11,650,000 Grand Total $ 23,189,000 (of .C I T Y • NDOVEA 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: 2025 Budget Development Progress Update/Discussion DATE: August 27, 2024 INTRODUCTION City Administration has been focusing on the 2025 Annual Operating Budget Development process over the past few months and is looking to update the City Council and seek direction as the preparation of the 2025 Annual Operating Budget proceeds. City Administration will review with the Council the bold italics items in this staff report at the meeting. Administration will also review and provide detailed analysis/commentary on the attached General Fund spreadsheets: 1. General Fund Revenue and Expense Summary (pg. 4) 2. General Fund - Revenue Budget Worksheet (pgs. 5-13) 3. General Fund — Expenditure Budget Summary Totals — By Department (pg. 14) 4. General Fund — Expenditure Budget Worksheets — Line Item (pgs. 15-56) DISCUSSION The following are the 2024 Budget Development guidelines adopted at the April 4t' 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: Anoka County Assessor estimated taxable market value figures for the City of Andover are based on numbers presented at the Board of Review meeting reflecting only a 0.40 % increase in total taxable market value for 2025. The 2024 increase was 2.93%. (See attached Pay 2025 Valuation Estimates on pg. 1) 2) A fiscal goal that works toward establishing the General Fund balance for working capital at no less than 45% of planned 2025 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 2024 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 2024 budget development exceeded this guideline for cash flow, also Emergency Fund Balances (approximately 3% of planned 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 attached General Fund 2024 Fund Balance Analysis (pg. 2) at the meeting. 3) A commitment to limit the 2025 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 2024 debt levy was below the guideline. The 25% guideline for 2025 will be attained via the structured management of the current long-term debt. An equipment certificate is contemplated for 2024, and street reconstruction bonds planned in 2025. (See attached Property Tax Levy spreadsheet pg. 3 & pg. 57). 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 2025-2029 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 6) Continued commitment to strategic planning targeted toward meeting immediate and long- term operational, staffing, infrastructure and facility needs. Note On May 25, 2023, and June 8, 2023, the Andover City Council and Staff Leadership Team convened work sessions with Facilitator Phil Kern for the purpose of updating its long-term vision, organizational values, external values, and short-term goals. The outcome of those sessions was summarized, and the Council adopted the updated "City of Andover Strategic Plan" at the June 20, 2023, City Council meeting. Administration will ensure that the direction provided 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 Focus: Consistent with the strategic plan, the City will be prioritizing staff to assure that the City of Andover is supported by talented and well -supported officials and that its employees operate in a strong organizational culture providing stability, creativity, and excellence in delivery of service. The strategic plan provides the following goals: • Develop and implement succession plans, identifying and establishing appropriate depth within each department and mentoring employees to gain organizational capacity. • Implement actions related to staff retention and attraction in order to keep the City market competitive (compensation, benefits, etc.). • Evaluate staffing and level of service for Fire, EMS, and Sheriff's Office to provide effective fire and rescue response. 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 past realignments added significant new responsibilities and pay adjustments were made and continue to carry forward into 2024. Administration did receive a new staffing request from the Fire Department for the 2025 budget. Deadline for submission was July 1s Fire D partment — New requests are for an Administrative Assistant and an additional Fire Inspector/Firefighter for the 2025 budget. The primary focus is to help meet acceptable response times with the Duty Crew and Paid -on -Call model. Administration and Fire are closely monitoring the progress of the Duty Crew model, success is crucial as duty crew alternatives such as full-time firefighters are expensive. Prior Fire Department staffing requests have outlined what a fulltime firefighting model would look like; bottom line expensive, an additional $1.5 million per year for operations, plus additional capital expenses to bring fire stations up to code for fulltime staffing (sleeping quarters). Administration has not recommended the full-time firefighting model but does want the Council to be aware of the cost of that model. The additional Fire Inspector/Firefighter for the 2025 budget is not recommended at this time by Administration as the City is currently undertaking a Fire Services Evaluation by Fitch & Associates which is anticipated to be complete in early 2025. It is anticipated that recommendations in the final report will be key toward future new Firefighter hires. Relative to the Administrative Assistant request, Human Resources/Administration is evaluating options for additional administrative support service options for. the Fire Department within the current City staffing compliment. 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 present the findings at the workshop under a separate agenda item and will seek Council direction on how to proceed based on the findings Administration has included a placeholder in the Human Resources Budget to address market competitiveness and will review in more detail at the meeting as well The 2024 budget focus was on front-line workers, the 2025 budget is focus is on mid - managers and department heads The current Public Works Union contract expires December 31, 2025. A two-year contract was achieved in 2024, and the current Public Works Union Contract (2024- 2025) was approved at the October 3, 2024, City Council meeting. That approval provided for a $1.75 per hour market rate adjustment for 2024 and a 3% COLA is provided for 2024 and 2025. For non -bargaining employees, Administration is carrying a placeholder for 2025 COLA. Council direction will be sought on a 2025 COLA for non-barzaininz employees. 2. A midyear review of the employee health plan for the 2025 Budget was conducted with our broker on July 9th, and an increase in the renewal rates is forecasted. The marketing of the group to various insurance carriers is an option, but as more information does come available a decision will be made as the current health insurance contract does contain a rate increase cap. For the 2024 budget, Administration at the November 8, 2023, Council meeting, recommended switching from the Health Partners Open Access program to MEDICA with three high -deductible plan designs offered to the employees. The health plan is offered with higher deductibles ($6,900 single and $13,800 family) and is stacked with an HRA (Health Reimbursement Arrangement). The HRA was originally funded utilizing premium savings that were achieved from by continued renewal of higher deductible plans. 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 by 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. That contribution is evaluated as part of the marketing of the health insurance plans, is in place for 2023 and proposed for 2024. Administration is carrying an employee health insurance increase placeholder in the proposed 2025 budget 3. Fire Services Study: The City of Andover Strategic Plan identifies the following as a major short-term initiative, "Evaluate staffing and level of service for Fire, EMS, and Sheriff's Office to provide effective fire and rescue response. " In response, the City initiated a Request For Proposal (RFP) process seeking an independent firm that specializes in reviewing Fire and EMS service. Proposals were due on May 17th. After the review of nine submitted proposals, three firms were interviewed, and Fitch and Associates was recommended to the Council for approval at the June 18th City Council meeting. Fitch & Associates did start the study process in late June with data requests and onsite in July. 4. Andover Fire ReliefAssociation: The City of Andover Strategic Plan identifies the following as a major short-term initiative, "Implement actions related to staff retention and attraction in order to keep the City market competitive (compensation, benefits, etc.). At the February workshop, the Council met with the Andover Firefighters Relief Association where a presentation along with stories and personal impacts behind the numbers was provided by members of the Relief Board. Council direction from that meeting was for Administration to gather additional data and for the Council to discuss a Fire Relief contribution and Firefighter pay at a future workshop, City Administration did provide to -date research, shared conversations with other communities, and provided analysis.at the May 28th Council workshop. The outcome of the May 28th workshop was the City Council while recognizing a contribution is not mandatory also recognizes that a municipal contribution can contribute to the City achieving firefighter recruitment goals, long-term retention of firefighters and to assist in fending off going to full-time firefighters. The City Council did adopt at the June 4' regular council meeting a process and formula for the current year 2024 and future year's contribution to the Andover Firefighters Relief Association. The City formula for a municipal contribution is based on service credits as determined by the Andover Fire Department and the process will be triggered after the preceding years' service credits are certified to the Andover Firefighters Relief Association, no later than March 31 st of each year. Payment made after a 60 -day appeal of service credit process. The formula established is as follows: For the 2024 contribution the City has established a baseline of $125/per service credit. The municipal contribution will be calculated by multiplying the baseline per service credit by the total number of months certified per active firefighter. In future years, the baseline per service credit will be adjusted by the cost -of -living adjustment (COLA) percent increase provided to the City non -bargaining employees for the budget year payment is made. Contractual Departments: Consistent with the strategic plan, the following goal applies to contractual departments: • Evaluate staffing and level of service for Fire, EMS, and Sheriff's Office to provide effective fire and rescue response. • Continue to enter into collaborative agreements and partnerships when mutually beneficial. The City Attorney 2024 contract included a 2% increase over the 2023 contract. The proposed 2025 budget is carrying a placeholder increase for the attorney's 2025 contract. 2. The Anoka County Assessor contract was up for renewal in 2023 and was approved going into the 2024 budget. The County Assessor is on a five-year contract renewal consistent with past renewals. Efficiencies brought about by technological investments have assisted in keeping the contract pricing consistent and affordable. No increase is proposed for 2025. 3. Each year the City Council approves the subsequent years (2025) law enforcement contract with the Anoka County Sheriffs Office as part of the annual budget process. The current 2024 City of Andover Law Enforcement contract (a status quo contract to 2023) was approved at the September 19, 2023, City Council meeting with expenditures budgeted at $3,739,849, offset by a Police State Aid revenue budget of $128,104 and School Liaison revenue budget of $110,767 reflecting a net tax levy impact of $3,500,978. The 2024 Sheriff's 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. 2 full-time Deputy Sheriffs assigned to Community Oriented Policing (working in such areas as patrol, selected enforcement efforts, and crime prevention). d. 2 Patrol Investigators The Crime Watch Coordinator position historically covered 50% by Andover was moved to be under the Sheriff service umbrella with the 2024 contract. Per contract, the Sheriff always provides the required number of deputies for all hours contracted by the City. If the Sheriff's 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 Sheriff s Department additional but is not billable per the contract. As you may recall, 2022-2023 legislation regarding limitations placed on School Liaison Officers was met with a decision by the Anoka County Sheriff to not place School Liaison Officers in Andover High School and Oak View Middle School for school year 2023-2024. In response, the City and the Sheriff s Office addressed this in the 2024 Law Enforcement Contract by adding language in the contract to address the School Liaison Officers by adding the following language to the 2024 contract: "In the event the Sheriff reassigns staff to an assignment that is not in service to the municipality. The parties will come to a mutual agreement as to a commensurate reduction in compensation to the County." That language will not be needed for the proposed 2025 contract, as there was a push for the legislature to provide more clarity to the new law at the most recent legislative session (2023-2024) and as more acceptable language was approved by the Legislature and Governor, in response the School Liaison Officers were placed back into Andover High School and Oak View Middle School in February of 2024. Discussions with the Anoka County Sherifffor2025 were again for a status quo contract. Those discussions yielded a 5.27% increase in the contract expenditures budgeted at $3,932,050, offset by a Police State Aid revenue budget of $126,192 and School Liaison revenue budget of $114,267 reflecting a net tax levy impact of $3,691,591. It should be noted that the School Liaison reimbursement from the School District is still being negotiated, we are targeting 50% reimbursement. The primary driver of cost increase for the 2025 contract proposal is deputy salary increases to remain competitive with the Metro Area. The 2025 Sheriffs contract was approved at the July 2, 2024, City Council meeting after a presentation by Sheriff Brad Wise. Council Memberships and Donations/Contributions: The following memberships/contributions are in the 2025 proposed budget: ■ North Metro Mayors Association $14,261 (GF) ■ Metro Cities $10,027 (GF) ■ Mediation Services $ 6,628 (GF) ■ YMCA — Water Safety Program $ 9,500 (GF) ■ Alexandra House $24,500 ($15,000 GF & $9,500 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 ($5,600 GF & $20,400 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 organizations are funded via the General Fund (GF), and those organizations 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. Youth Programming — Andover Community Center: Regarding Youth Programming, the City of Andover Strategic Plan identifies the following as major short-term initiatives: • Develop and implement additional youth activity programming at the Andover Community Center. • Continue to enter into collaborative agreements and partnerships when mutually beneficial. In response, Administration and Community Center staff are working with Youth First and the YMCA to develop a more structured after school program at the ACC. Youth First with their new Executive Director taking the lead are formulating a program that can work with grant dollars Youth First has been awarded and integrate a program where Opioid Settlement dollars or Public Safety Aid could be leveraged and to utilize existing City funding targeted toward youth programming. A program titled "The Andover Community Engagement Model (A.C.E.)" is being fine-tuned for this fall if funding can be secured. Administration will provide more information at the meeting: Council input will be sought regarding implementing a program and the potential utilization of Opioid Settlement funds to assist with starting up the program at the ACC. To date, the City has received approximately $77,000 to date in settlement funds and anticipates receiving an additional $75,000 in future years. Capital Projects Lew: Consistent with the new strategic plan, the following goal applies to capital projects: • Review and update street capital improvement plan, including funding and implementation. • Prioritize the timely replacement of equipment and commitment to necessary maintenance of equipment and municipal facilities. • Explore, identify gaps, and strengthen critical infrastructure. Capital Projects Levy -The 2024 Capital Projects Levy Budget specifically designates $2,434,438 of the general tax levy to capital projects and equipment needs relating to Capital Project Outlay ($300,000), Road and Bridge ($1,651,822), Pedestrian Trail Maintenance ($112,616), Park Projects ($15,000) and Facility Maintenance Reserve ($355,000). Specific designation of the tax levy to anticipated City needs and priorities for transportation and trail maintenance, park projects and equipment outlays allows the city to strategically allocate its resources and raise the public's awareness of City spending priorities. The Road and Bridge levy is evaluated annually and along with Capital Outlay, Pedestrian Trail Maintenance, Parks Projects, and Facility Maintenance levies increased/decreased according to the City Council budget guidelines. • Road and Bridge An adjustment was made to the Road & Bridge funding formula in 2014, primarily to stop the continual decrease in the levy that has been happening over the past few years due to decreases in the Anoka County Assessor taxable market value figures for the City of Andover. Based on Council discussion, consensus was to stop the decline in road funding and evaluate annually through the adopted City Council Budget Development Guidelines. It should be noted that in 2014, Local Government Aid (LGA) in the amount of $74,655 was used to help fund the Road & Bridge Fund. The State of Minnesota funding has gone away, down to $0.00 in 2017, and has remained at 0.00 each year since. Future increases in LGA or even the presence of LGA for the City of Andover based on the current State formula are remote. In 2021, as part of the 2022 budget process, Administration has had discussions with the Council regarding the use of debt service levy and the Permanent Improvement Revolving (PIR) Fund fund balance to address immediate street maintenance needs in the community based on Engineering analysis of the street infrastructure. The Council did approve the 2022 Street Reconstruction Bonds infusing $7.33m into the Road & Bridge program to focus on mill and overlays and reclaims of city streets. For the 2025 budget development, detail analysis including a review of conditions and needs of the city street system to date was presented to and discussed by the City Council throughout this spring and summer, this review has shown a financial need of approximately $70,000,000 over the next 8 years to bring all City streets to acceptable levels. Through this process the City Council reviewed the City of Andover Road Rating process, forecasted costs, proposed improvement methods (mill & overlay, full street reclaim, or full street reconstruction), potential revenue sources and potential future corresponding property tax impacts. The City Council rejected options that included increasing assessment rates or using franchise fees. The City Council chose to integrate bonding with the current assessment rates, current funding sources, pursuit of grant options, and an increased property tax contribution starting in 2025. The 2024 Road & Bridge levy reflected a 2.02% increase to $1,651,822, that increase followed previous Council guidelines capturing market value increases to dedicate to roads Administration is Proposing a 45.29% increase ($748,178) to $2,400,000 for the 2025 levy to help address the new Street Improvement Program. • Pedestrian Trail Maintenance The 2020 City of Andover Pedestrian Trail Maintenance levy was $104,040. The 2021, 2022, 2023 & 2024 budgets each included a 2% increase leading to a $112,616 levy for 2024. Administration is again proposing a 2% increase ($2,252) to $114,868 for the 2025 levy • Park Improvements / Parks Repair & Replacement This levy is an annual appropriation to be used to underwrite park improvement projects as recommended by the Park and Recreation Commission and approved by the City Council. This funding is intended to be a supplemental source of capital funding for park projects that is separately identified in the City's Five -Year Capital Improvement Plan. The 2015 levy was $61,500, but only $15,000 was levied for 2016. $46,500 of the previous levy was re -assigned to the General Fund to focus on Park's maintenance/replacement items. In addition to the re -assigned funds, an additional $43,500 of General Fund levy was assigned to Parks Repair/Replacement items for a total levy of $90,000 in 2016, and that continued for 2017. The 2018 General Fund levy assigned to Parks Repair/Replacement items levy was increased to $100,000 for 2019, to $120,000 for 2020 & 2021, $130,000 for 2022 and $145,000 for 2023; the Parks Project levy has remained the same at $15,000 since 2015. For 2024, per Council direction after a Joint Meeting with the Park and Recreation Commission as part of the 2024 budget development process, there was a $90,000 adjustment proposed to these levies, the Parks Repair/Replacement Items levy was set at $235,000 and the Parks Project levy remained at $15,000. No change is recommended for the 2025 budget, • Capital Equipment/Projects Under the Capital Projects Levy, a levy is proposed to be designated to Capital Equipment/Project expenditures identified through the CIP process. Through this designation, the City, over time, will build a fund reserve to avoid cash flow "spikes" and address a wide range of capital improvement needs such as facility maintenance projects under a more controlled spending environment. The 2022 levy & 2023 levy was $275,000. An additional $25,000 increase to $300,000 was done with the 2024 levy to continue to meet the needs of the CIP. No change is recommended for the 2025 budget, • Facility Maintenance This was a new $50,000 levy proposed for 2018. A facility condition assessment study identified many maintenance repairs for City facilities such as roof repairs, HVAC, electrical panels, fire alarm systems, windows, and air quality related items. This levy was increased to $355,000 for the 2019 budget to help address the deferred maintenance items that have been identified. Most recently for the Public Works and Community Center buildings expansion projects within the City Campus Master Plan materialized. The $355,000 levy is anticipated to continue at that level into the future to address additional facility repairs. The preliminary 2025 levy does not recommend any adjustment to the Facility Maintenance levy $355,000 is again proposed for the 2025 levy Debt Service Levy: 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. (Staff, along 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 proposed 2025 Debt Service levy is as follows: • 2012C Taxable G.O. Abatement Bonds $ 969,824 Final levy year 2031 • 2018A CIP Bonds $ 617,257 Final levy year 2043 • 2019A GO Abatement Bonds $1,018,100 Final levy year 2039 • 2021A GO Equipment Certificates $ 176,715 Final levy year 2025 • 2021A GO Street Reconstruction $ 649,138 Final levy year 2029 • 2024 GO Equipment Certificate $ 450,000 Final levy year 2027 • 2025 GO Street Reconstruction Bonds $1,000,000 Est. - Final levy year 2034 Total 4 881 034 Staff will review with the Council at the meeting. ACTION REQUESTED Council is requested to receive a presentation and provide direction to staff. .11y submitted, J CITY OF ANDOVER Pay 2025 Valuation Estimates City of Andover Taxable Market Values $6,000,000,000 $5,000,000,000 $4,000,000,000 $3,000,000,000 $2,000,000,000 $1,000,000,000 $0 Pay 2022 Pay 2023 Pay 2024 Pay 2025 I City of Andover Tax Capacity Values $60,000,000 $50,000,000 $40,000,000 $30,000,000 $20,000,000 $10,000,000 $0 Pay 2022 Pay 2023 Pay 2024 Pay 2025 ESTIMATE Pay 2022 Pay 2023 Pay 2024 Pay 2025 Taxable Tax Taxable Tax Taxable Tax Taxable Tax Market Capacity Market Capacity Market Capacity Market Capacity Value Value Value Value Value Value Value Value Andover Valuation Totals $ 3,885,459,439 $ 40,210,548 $ 4,786,225,134 $ 50,267,978 $ 4,926,472,404 $ 52,292,926 $ 4,946,320,181 $ 52,741,700 Captured Tax Increment (122,976) (141,278) (210,758) (121,674) Fiscal Disparity Contribution (1,414,808) (1,368,461) (1,449,326) (1,780,176) Local Tax Rate Value 38,672,764 48,758,239 50,632,842 50,839,850 Fiscal Disparity Distribution 6,037,850 5,500,256 5,711,542 5,492,555 Total Adjusted Values $ 44,710,614 $ 54,258,495 $ 56,344,384 $ 56,332,405 21.35% 3.84% -0.02% Taxable Market Value Tax Capacity Value % Change % Change Pay 2022 $ 3,885,459,439 Pay 2022 $ 40,210,548 Pay 2023 $ 4,786,225,134 23.18% Pay 2023 $ 50,267,978 25.01% Pay 2024 $ 4,926,472,404 2.93% Pay 2024 $ 52,292,926 4.03% Pay 2025 $ 4,946,320,181 0.40% Pay 2025 $ 52,741,700 0.86% City of Andover Taxable Market Values $6,000,000,000 $5,000,000,000 $4,000,000,000 $3,000,000,000 $2,000,000,000 $1,000,000,000 $0 Pay 2022 Pay 2023 Pay 2024 Pay 2025 I City of Andover Tax Capacity Values $60,000,000 $50,000,000 $40,000,000 $30,000,000 $20,000,000 $10,000,000 $0 Pay 2022 Pay 2023 Pay 2024 Pay 2025 City of Andover General Fund 2024 Fund Balance Analysis 8/15/2024 Actual December 31, 2023 $11,549,450 2024 Estimated Fund Balance Increase (Decrease) (378,090) Projected December 31, 2024 11,171,360 Less: Snow Emergency (100,000) Public Safety (100,000) Facility Management (100,000) Information Technology (100,000) 2025 Budgeted Use of Fund Balance (550,931) "* Economic Development (150,000) Fiscal Disparities Fluctuation (300,000) Prepaids / Inventories (400,396) Budget Carryforwards / Adjustments (148,300) Compensated Absences (400,000) Working Cash Flow (7,868,373) Estimated Balance Available for Adjustments $ 953,360 2024 Working Cash Flow Designation Calculation: 2025 Requested Expenditure - Preliminary Estimate $15,736,745 % of 2025 General Fund Expenditures 50.000% $ 7,868,373 ** Matches 2025 General Fund Revenue and Expense Summary City of Andover, Minnesota Property Tax Levy Other Levies Capital Projects Levy Capital Equipment/Project Certified Certified Certified Certified Certified Requested 1.47% $ Change 0.00% Facility Maintenance Reserve 2020 2021 2022 2023 2024 2025 % of Total $ $ % General & Other Operational Levies 15,000 15,000 15,000 15,000 15,000 15,000 0.07% $ - 0.00% General Operations $ 9,194,032 $ 9,396,493 $ 9,868,370 $ 10,591,789 $ 11,341,126 $ 11,908,182 58.37% $ 567,056 5.00% Community Center Operations - 155,000 155,000 155,000 155,000 155,000 0.76% $ - 0.00% Parks Repair/Replacement Items 120,000 120,000 130,000 145,000 235,000 235,000 1.15% $ - 0.00% Total General & Other Operational Levies 9,314,032 9,671,493 10,153,370 10,891,789 11,731,126 12,298,182 60.28% $ 567,056 4.83% Debt Service Levies 2010A G.O. Open Space Referendum Bonds 184,199 151,078 - - - - 100.00% $ 2,306,810 12.75% 2012C Taxable G.O. Abatement Bonds 976,780 973,263 974,628 969,745 973,650 969,824 2016A G.O. Equipment Certificate 143,373 - - - - - 2018A G.O. Cap Improv Plan Bonds 433,603 456,344 617,519 612,794 612,794 617,257 2019A G.O. Abatement Bonds 1,001,090 976,966 1,014,065 1,028,782 1,028,783 1,018,100 2020A G.O. Equipment Certificate 350,000 406,224 374,850 376,740 - - 2021A G.O. Equipment Certificate - 170,000 170,000 174,773 174,825 176,715 0.41% 2021A G.O. Street Reconstruction Bonds - - 600,000 603,863 651,658 649,138 2024 G.O. Equipment Certificate - - - - 450,000 450,000 32.251% 36.317% 2025 G.O. Street Reconstruction Bonds 12.610% Tax Capacity Rate W/O LRRWSD 35.656% 35.574% 35.994% 1,000,000 32.181% Total Debt Service Levies 3,089,045 3,133,875 3,751,062 3,766,697 3,891,710 4,881,034 _ 23.929% $ 989,324 25.42% Other Levies Capital Projects Levy Capital Equipment/Project 275,000 250,000 275,000 275,000 300,000 300,000 1.47% $ - 0.00% Facility Maintenance Reserve 355,000 355,000 355,000 355,000 355,000 355,000 1.74% $ - 0.00% Parks Projects 15,000 15,000 15,000 15,000 15,000 15,000 0.07% $ - 0.00% Road &Bridge 1,287,469 1,342,456 1,409,579 1,619,190 1,651,822 2,400,000 11.76% $ 748,178 45.29% Pedestrian Trail Maintenance 104,040 106,121 108,243 110,408 112,616 114,868 0.56% $ 2,252 2.00% Lower Rum River Watershed 40,000 40,000 40,000 40,000 40,000 401000 0.20% $ 0.00% Total Other Levies 2,076,509 2,108,577 2,202,822 2,414,598 2,474,438 3,224,868 15.80% $ 750,430 30.33% Gross City Levy 14,479,586 14,913,945 16,107,254 17,073,084 18,097,274 20,404,084 100.00% $ 2,306,810 12.75% Less Fiscal Disparities Distribution 1,896,892 1,9571824 211531911 109849687 117679559 1,940,524 Local Tax Rate Levy f 12,582,694 $ 12,956,121 $ 13,953,343 $ 15,088,397 $ 16,329,715 $ 18,463,560 Less Levy Based on Market Value $ 184,199 $ 151,078 f f $ S Net Local Tax Rate Levy f 12,398,495 $ 12,805,043 f 13,953,343 $ 15,088,397 $ 16,329,715 $ 18,463,560 Adjusted Tax Capacity Value" (1) _!_34,675,332 _S_35,898,536 _L_38,672,764 _L_48,758,239 $ 50,632,842 $ 50,839,850 3.53% 7.73% 26.08% 3.84% 0.41% Ch Chance Tax Capacity Rate- 35.756% 35.670% 36.081% 30.945% 32.251% 36.317% 4.066% 12.610% Tax Capacity Rate W/O LRRWSD 35.656% 35.574% 35.994% 30.873% 32.181% Tax Capacity Rate With LRRWSD 35.942% 35.845% 36.245% 31.073% 32.378% Voter Approved Ref - MV 0.00526% 0.00418% 0.00000% 0,00000% 0.00000% "Adjusted Value determined by adjusting for Fiscal Disparities and Tax Increment estimates - Blended rate due to the City of Andover levying for Lower Rum River Watershed District (1) Adjusted Tax Capacity Value is subject to change. 3 CITY OF ANDOVER General Fund Revenue & Expense Summary Actual Actual Actual Actual Actual Budget * Estimate Requested * Budget Change (*) 2019 2020 2021 2022 2023 2024 2024 2025 $ % REVENUES Property Taxes $ 8,864,720 $ 9,303,235 $ 9,527,670 $ 9,974,141 $ 10,663,259 $ 11,621,126 $ 11,621,126 $ 12,188,182 567,056. 4.88% License and Permits 855,831 892,277 891,762 972,878 854,738 617,600 722,175 668,850 51,250 8.30% Intergovernmental Revenues 822,129 861,178 939,174 963,290 977,028 868,657 834,259 878,892 10,235 1.18% Charges for Current Services 1,133,160 1,070,788 1,036,850 1,295,429 1,447,507 897,610 1,042,220 966,910 69,300 7.72% Fines and Forfeits 62,349 47,630 53,747 55,983 70,683 50,500 50,500 50,500 0 0.00% Interest Income 208,957 148,974 (15,183) (189,494) 377,355 75,000 100,000 100,000 25,000 33.33% Miscellaneous Revenue 192,058 172,174 167,397 188,395 185,646 154,800 158,165 155,300 500 0.32% Transfers 188,008 190,688 212,031 197,081 228,772 221,246 221,246 177,180 (44,066) -19.92% TOTAL REVENUES 12,327,212 12,686,944 12,813,448 13,457,703 14,804,988 14,506,539 14,749,691 15,185,814 679,275 4.61% EXPENDITURES General Government 2,843,957 2,906,325 3,020,260 3,222,596 3,290,966 3,985,287 3,995,501 4,145,443 160,156 4.02% Public Safety 5,091,793 5,162,234 5,532,429 5,705,358 5,800,627 6,464,154 6,586,108 6,895,777 431,623 6.68% Public Works 3,148,743 3,314,542 3,522,626 3,624,481 3,904,812 4,430,572 4,450,572 4,599,425 168,853 3.81% Other 15,001 1,012,778 766,109 567,396 223,436 95,600 95,600 96,100 500 0.52% TOTAL EXPENDITURES 11,099 494 12,395,879 12,841,424 13,119,831 13,219 841 14,975,613 15,127,781 15,736,745 761,132 5.08% UNDER(OVER)BUDGET $ 1,227,718 $ 291,065 $ 27,976 $ 337,872 $ 1,585,147 $ 469,074 $ 378,090 $ 550,931 $ 81,857 4 CITY OF ANDOVER General Fund Revenue Budget Worksheet - 2025 Actual Actual Actual Actual Actual Budget* Estimate Requested*1 Chane count Num Description 2019 2020 2021 2022 2023 2024 2024 2025 $ % 41230 - Human Resources Miscellaneous Revenue 58100 Refunds & Reimbursements 971 292 115 633 825 500 Miscellaneous Revenue 971 292 115 633 825 500 Total 971 292 115 633 825 500 41300 - City Clerk Miscellaneous Revenue 58175 Contributions 3,182 2,672 3,821 4,534 4,413 2,500 3,000 3,000 500 20.00% Miscellaneous Revenue 3,182 2,672 3,821 4,534 4,413 2,500 3,000 3,000 500 20.00% Total 128,301 80,063 134,553 134,086 159,366 114,250 127,910 126,250 12,000 10.50% 41310 - Elections Intergovernmental Revenue 5 License & Permits 52100 Liquor - Intoxicating 39,884 9,998 54,358 50,700 56,774 45,000 55,000 55,000 10,000 22.22% 52105 Liquor - Non -Intoxicating 450 300 300 300 225 300 300 300 - 0.00% 52110 Tobacco 4,356 3,500 3,750 4,500 4,500 3,500 5,500 3,500 0.00% 52115 Refuse/Recycler Haulers 4,075 3,850 3,325 3,250 4,150 3,800 3,400 3,800 0.00% 52120 Peddler 3,350 2,075 2,950 3,125 4,475 2,000 2,000 2,000 0.00% 52125 Therapeutic Massage 2,161 1,750 2,275 2,125 2,502 1,500 1,500 1,500 0.00% 52126 Vehicle Sales License 945 840 1,155 840 840 700 700 700 - 0.00% License & Permits 55,221 22,313 68,113 64,840 73,466 56,800 68,400 66,800 10,000 17.61% Charges For Services 54100 Notary Fees 252 288 351 273 339 250 250 250 - 0.00% 54115 Sale of Copies, Ord, etc. 122 10 131 1 310 - - - - #DIV/0! 54125 Assessment Searches 5,325 6,250 7,300 7,175 8,925 3,500 5,100 5,000 1,500 42.86% 54145 Party Permits 150 100 90 80 30 100 60 100 - 0.00% 54155 Recording Fees 1,700 800 1,000 1,200 1,200 600 600 600 - 0.00% Charges For Services 7,549 7,448 8,872 8,729 10,804 4,450 6,010 5,950 1,500 33.71% Fines 56100 Court Fines 61,674 46,430 52,472 55,408 64,733 50,000 50,000 50,000 - 0.00% 56110 Admin Penalty - 825 900 200 5,950 - - - 56200 False Alarm Fines 675 375 375 375 500 500 500 0.00% Fines 62,349 47,630 53,747 55,983 70,683 50,500 50,500 50,500 0.00% Miscellaneous Revenue 58175 Contributions 3,182 2,672 3,821 4,534 4,413 2,500 3,000 3,000 500 20.00% Miscellaneous Revenue 3,182 2,672 3,821 4,534 4,413 2,500 3,000 3,000 500 20.00% Total 128,301 80,063 134,553 134,086 159,366 114,250 127,910 126,250 12,000 10.50% 41310 - Elections Intergovernmental Revenue 5 CITY OF ANDOVER General Fund Revenue Budget Worksheet - 2025 Actual Actual Actual Actual Actual Budget* Estimate Requested*1 Chane *) count Num Description 2019 2020 2021 2022 2023 2024 2024 2025 $ % 53490 Other Grants 29,188 11,355 Intergovernmental Revenue 29,188 - Charges For Services 54175 Council Filing Fee 50 - 25 50 #DIV/0! Charges For Services 50 25 50 #DIV/0! Miscellaneous Revenue 58100 Refunds & Reimbursements #DIV/0! Miscellaneous Revenue - - #DIV/0! Total 29,238 25 - 50 - #DIV/0! 41400- Finance Charges For Services 54165 Bad Check Fee 30 30 60 120 120 150 150 150 - 0.00% 54285 Finance Department Fees 134,301 152,957 98,435 216,296 308,556 60,000 100,000 85,000 25,000 41.67% 54320 Finance Charge 563 194 337 1,478 411 100 100 100 - 0.00% Charges For Services 134,894 153,181 98,832 217,894 309,087 60,250 100,250 85,250 25,000 41.49% Miscellaneous Revenue 58100 Refunds & Reimbursements 32,955 29,852 30,034 42,501 32,484 30,000 30,000 30,000 - 0.00% Miscellaneous Revenue 32,955 29,852 30,034 42,501 32,484 30,000 30,000 30,000 - 0.00% Total 167,849 183,033 128,866 260,395 341,571 90,250 130,250 115,250 25,000 27.70% 41420 - Information Services Miscellaneous Revenue 58110 Computer Services 37,800 37,800 37,800 37,800 37,800 37,800 37,800 37,800 - 0.00% Miscellaneous Revenue 37,800 37,800 37,800 37,800 37,800 37,800 37,800 37,800 0.00% Total 37,800 37,800 37,800 37,800 37,800 37,800 37,800 37,800 0.00% 41500 - Planning & Zoning License & Permits 52130 Rezoning 350 1,750 350 350 700 700 800 100 14.29% 52135 Conditional Use 700 1,250 600 - 700 700 700 - 0.00% 52140 Variance 700 - 350 - 1,750 350 350 400 50 14.29% 52145 Lot Splits 400 1,550 1,400 1,000 1,850 400 1,000 400 0.00% 6 CITY OF ANDOVER General Fund Revenue Budget Worksheet - 2025 Actual Actual Actual Actual Actual Budget* Estimate Requested*1 Chane (*) count Num Description 2019 2020 2021 2022 2023 2024 2024 2025 $ % 52150 Signs 3,801 2,563 1,738 2,310 2,773 3,500 3,000 3,500 - 0.00% 52155 Vacation of Easement 750 1,000 800 600 1,000 600 1,400 700 100 16.67% 52260 Comp Plan Amendment - - 500 1,000 500 500 500 500 - 0.00% 52270 Temporary Structure 100 200 200 100 - 250 250 250 - 52275 Interim Use 1,600 700 700 1,020 1,000 1,000 800 (200) License & Permits 8,401 6,013 7,988 6,660 9,243 8,000 8,900 8,050 50 0.63% Intergovernmental Revenue 53490 Other Grants 3,836 - - - - Intergovernmental Revenue - - 3,836 - - - - - Charges For Services 54105 Plat Fees 1,250 1,150 3,300 1,800 1,100 1,000 1,000 800 (200) -20.00% 54130 Meeting Notification Signs 300 270 480 420 360 360 360 360 - 0.00% 54280 Flood / Zone Search Letter 450 250 200 300 300 - 150 - #DIV/0! 54290 Planning Department Fees 3,421 5,836 12,239 6,059 6,070 4,000 7,100 4,000 - 0.00% Charges For Services 5,421 7,506 16,219 8,579 7,830 5,360 8,610 5,160 (200) -3.73% Miscellaneous Revenue 58100 Refunds & Reimbursements 750 - - - #DIV/0! Miscellaneous Revenue 750 - - - - - - #DIV/0! Total 14,572 13,519 28,042 15,239 17,073 13,360 17,510 13,210 (150) -1.12% 41600 - Engineering License & Permits 52250 Curb Cut 250 300 100 150 350 - 75 - - 4DIV/0! 52265 Fencing / Retaining Wall 3,420 4,725 3,562 3,360 6,855 2,300 4,000 3,000 700 30.43% License & Permits 3,670 5,025 3,662 3,510 7,205 2,300 4,075 3,000 700 30.43% Intergovernmental Revenue 53490 Other Grants - - - - - #DIV/0! Intergovernmental Revenue - - - #DIV/0! Charges For Services 54180 Escrow Inspection Fee 1,100 1,650 4,775 3,150 4,800 1,500 1,500 1,500 0.00% 54185 Site Plan Review - Trees 280 - - - - - - - - #DIV/0! 54200 Engineer Fees - PW Director 35,586 31,625 28,894 33,450 39,713 27,000 35,000 30,000 3,000 11.11% 54205 Engineer Fees - Asst PW Direc 17,413 10,823 7,879 4,314 - - - - - #DIV/0! 54210 Engineer Fees - Asst Engineer 96,774 77,285 100,464 102,227 117,216 95,000 100,000 100,000 5,000 5.26% 54215 Engineer Fees - Tech IV 285,730 245,609 242,094 348,835 396,171 250,000 320,000 275,000 25,000 10.00% 54220 Engineer Fees - Natural Res T< 2,254 1,558 1,421 505 908 2,000 2,000 2,000 - 0.00% 7 CITY OF ANDOVER General Fund Revenue Budget Worksheet - 2025 Actual Actual Actual Actual Actual Budget* Estimate Requested*1 Chane (* count Num Description 2019 2020 2021 2022 2023 2024 2024 2025 $ % 54225 Engineer Fees - Secretary 13,356 15,682 16,295 14,565 23,867 14,000 14,000 14,000 0.00% 54230 Engineer Fees - Intern 10,146 - - - 3,614 4,000 4,000 4,000 0.00% 54235 Engineer Fees - Mileage 3,729 3,985 2,951 5,825 5,502 3,000 3,750 3,000 0.00% 54295 Grading Inspection Fee 4,241 5,297 6,857 4,665 3,894 3,000 3,000 3,000 0.00% 54305 Administrative Fees - 200 300 200 200 - - - #DIV/0! 54335 Bid Plans 355 545 255 395 366 750 750 750 - 0.00% Charges For Services 470,964 394,259 412,185 518,131 596,251 400,250 484,000 433,250 33,000 8.24% Miscellaneous Revenue 58100 Refunds & Reimbursements - - 895 - - - #DIV/0! Miscellaneous Revenue 895 - - - - - 4DIV/0! Total 474,634 399,284 416,742 521,641 603,456 402,550 488,075 436,250 33,700 8.37% 42100 - Police Protection Intergovernmental Revenue 53370 State Police Aid 137,280 141,440 137,280 139,360 126,192 128,104 128,104 126,192 (1,912) -1.49% 53840 School District Liaison 99,351 102,331 104,378 106,465 108,595 110,767 36,630 114,267 3,500 3.16% Intergovernmental Revenue 236,631 243,771 241,658 245,825 234,787 238,871 164,734 240,459 1,588 0.66% Total 236,631 243,771 241,658 245,825 234,787 238,871 164,734 240,459 1,588 0.66% 42200 - Fire Protection License & Permits 52160 Fire Permit 5,521 4,790 1,287 4,007 15,336 3,000 3,500 3,000 - 0.00% 52165 Burning Permit 1,200 800 1,085 1,108 420 800 800 800 0.00% License & Permits 6,721 5,590 2,372 5,115 15,756 3,800 4,300 3,800 - 0.00% Intergovernmental Revenue 53410 State Fire Aid 181,101 194,699 202,747 219,669 249,917 220,000 220,000 220,000 - 0.00% 53490 Other Grants 29,087 27,728 108,179 103,931 88,580 6,000 44,454 6,000 - 0.00% Intergovernmental Revenue 210,188 222,427 310,926 323,600 338,497 226,000 264,454 226,000 - 0.00% Charges For Services 54110 Plan Check Fees 3,528 2,562 705 2,159 10,481 2,000 2,000 2,000 - 0.00% 54120 Reports 20 465 140 185 150 - - - - #DIV/0! 54169 Inspection Fee 350 200 250 450 200 300 300 300 - 0.00% Charges For Services 3,898 3,227 1,095 2,794 10,831 2,300 2,300 2,300 - 0.00% Miscellaneous Revenue 58100 Refunds & Reimbursements - 6,118 711 - 8,189 500 2,865 500 - 0.00% 8 Actual count Num Description 2019 CITY OF ANDOVER General Fund Revenue Budget Worksheet - 2025 Actual Actual Actual Actual 2020 2021 2022 2023 Budget* Estimate Requested*1 Chane (*) 2024 2024 2025 $ % 58125 Donations 350 200 200 - #DIV/0! Miscellaneous Revenue - 6,468 711 200 8,389 500 2,865 500 0.00% Total 220,807 237,712 315,105 331,709 373,473 232,600 273,919 232,600 0.00% 42300 - Protective Inspection Total 1,020,971 1,094,704 1,022,693 1,164,517 974,362 707,000 811,800 757,500 50,500 7.14% 42500 - Animal Control License & Permits 52235 Dog Kennel 125 100 145 75 500 100 100 100 0.00% 52240 Dog License 3,372 2,738 2,592 2,628 2,376 2,600 2,600 2,600 0.00% 9 License & Permits 52170 Rental Licenses - Multi 7,275 300 7,350 675 7,425 8,500 8,500 8,500 0.00% 52171 Rental Licenses - Single 7,700 5,150 7,325 6,450 6,800 - - - 52175 Contractor 7,681 8,100 8,200 8,540 8,315 7,000 7,000 5,000 (2,000) -28.57% 52180 Tree Trimmers 1,550 1,000 1,300 1,150 1,350 1,000 1,300 1,000 - 0.00% 52185 Building 508,673 537,513 503,897 535,012 452,307 325,000 375,000 350,000 25,000 7.69% 52190 Heating 85,916 114,041 82,827 112,051 103,951 65,000 80,000 75,000 10,000 15.38% 52195 Plumbing 46,991 51,585 57,782 69,357 45,798 45,000 50,000 45,000 - 0.00% 52200 Septic Systems 9,294 11,350 16,571 19,271 14,159 6,000 10,000 8,000 2,000 33.33% 52205 Septic Pumping 10,575 10,800 14,680 11,440 11,040 10,000 10,000 11,000 1,000 10.00% 52215 Sanitary Sewer 9,075 11,970 10,500 7,305 5,235 5,000 6,000 5,000 - 0.00% 52217 Water Permit Fee 8,895 11,340 10,350 7,470 5,130 6,000 13,000 8,000 2,000 33.33% 52220 Certificate of Occupancy - - - - - - - - - #DIV/0! 52225 Gas Fireplace 14,220 13,590 13,698 12,150 8,460 8,000 8,000 8,000 - 0.00% 52230 Electric Permits 60,476 73,759 72,411 99,179 76,222 57,500 65,000 60,000 2,500 4.35% License & Permits 778,321 850,498 806,890 890,050 746,192 544,000 633,800 584,500 40,500 7.44% Charges For Services 54110 Plan Check Fees 238,972 236,922 209,565 270,465 226,070 160,000 175,000 170,000 10,000 6.25% 54135 Sewer Administration - - 390 165 75 - - - - #DIV/0! 54170 Reinspection Fee 2,858 6,602 5,230 3,240 2,025 3,000 3,000 3,000 0.00% 54325 Building Department Fee 630 682 617 597 - - - - - #DIV/0! Charges For Services 242,460 244,206 215,803 274,467 228,170 163,000 178,000 173,000 10,000 6.13% Miscellaneous Revenue 58100 Refunds & Reimbursements 190 - - - - - - - Miscellaneous Revenue 190 Total 1,020,971 1,094,704 1,022,693 1,164,517 974,362 707,000 811,800 757,500 50,500 7.14% 42500 - Animal Control License & Permits 52235 Dog Kennel 125 100 145 75 500 100 100 100 0.00% 52240 Dog License 3,372 2,738 2,592 2,628 2,376 2,600 2,600 2,600 0.00% 9 CITY OF ANDOVER General Fund Revenue Budget Worksheet - 2025 Actual Actual Actual Actual Actual Budget* Estimate Requested* Change (*) count Num Description 2019 2020 2021 2022 2023 2024 2024 2025 $ % License & Permits 3,497 2,838 2,737 2,703 2,876 2,700 2,700 2,700 0.00% Total 3,497 2,838 2,737 2,703 2,876 2,700 2,700 2,700 0.00% 43100 - Streets & Highways Intergovernmental Revenue 53401 State Highway Aid - Maintena 248,364 248,364 263,776 271,689 279,840 288,235 288,235 296,882 8,647 3.00% Intergovernmental Revenue 248,364 248,364 263,776 271,689 279,840 288,235 288,235 296,882 8,647 3.00% Special Assessments 57300 Spec Assess - Interest & Penal 31 - 2 1 5 - - - - #DIV/0! 57400 Spec Assess - Certified Bil 847 2,582 5,614 2,134 2,704 3,000 3,000 3,000 0.00% Special Assessments 878 2,582 5,616 2,135 2,709 3,000 3,000 3,000 0.00% Miscellaneous Revenue 58100 Refunds & Reimbursements 10,975 6,498 5,157 11,718 2,685 - - Miscellaneous Revenue 10,975 6,498 5,157 11,718 2,685 - - Total 260,217 257,444 274,549 285,542 285,234 291,235 291,235 299,882 8,647 2.97% 43200 - Snow & Ice Intergovernmental Revenue 53401 Other Grants - - - 5,139 1,285 - - #DIV/01 Intergovernmental Revenue 5,139 1,285 #DIV/0! Miscellaneous Revenue 58100 Refunds & Reimbursements 7,881 Miscellaneous Revenue 7,881 Total 13,020 1,285 #DIV/0! 43300- Street Signs Charges For Services 54190 Sale of Street Signs 31,444 16,261 11,366 9,202 24,581 8,000 9,000 8,000 0.00% Charges For Services 31,444 16,261 11,366 9,202 24,581 8,000 9,000 8,000 0.00% Miscellaneous Revenue 58100 Refunds & Reimbursements 563 497 318 578 519 500 500 500 Miscellaneous Revenue 563 497 318 578 519 500 500 500 10 CITY OF ANDOVER General Fund Revenue Budget Worksheet - 2025 Actual Actual Actual Actual Actual Budget* Estimate Requested*1 Chane count Num Description 2019 2020 2021 2022 2023 2024 2024 2025 $ % Total 32,007 16,758 11,684 9,780 25,100 8,500 9,500 8,500 0.00% 43600 - Street Lights - Billed Charges For Services 55410 Street Lights - User Fee 192,431 195,945 202,476 204,608 205,174 204,000 204,000 204,000 0.00% 55440 Street Lights - Penalties - - - - - - - #DIV/0! Charges For Services 192,431 195,945 202,476 204,608 205,174 204,000 204,000 204,000 0.00% Special Assessments 57300 Spec Assess - Interest & Penal 98 - - 5 13 - - - #DIV/0! 57400 Spec Assess - Certified Bil 13,006 10,765 4,578 6,400 8,718 5,000 5,000 5,000 0.00% Special Assessments 13,104 10,765 4,578 6,405 8,731 5,000 5,000 5,000 0.00% Total 205,535 206,710 207,054 211,013 213,905 209,000 209,000 209,000 0.00% 45000 - Parks & Recreation Intergovernmental Revenue 53420 State DNR - - - - - - - #DIV/0! Intergovernmental Revenue - #DIV/0! Charges For Services 54160 Tournament Fees 75 900 - #DIV/0! Charges For Services 75 900 - - #DIV/0! Miscellaneous Revenue 58100 Refunds & Reimbursements 7,150 456 1,612 2,417 1,500 500 500 500 - 0.00% 58105 Rent 2 5 10 - - - - - - #DIV/0! Miscellaneous Revenue 7,152 461 1,622 2,417 1,500 500 500 500 - 0.00% Total 7,152 461 1,622 2,492 2,400 500 500 500 - 0.00% 46000 - Recycling Intergovernmental Revenue 53360 SCORE Reimbursement 112,893 113,300 115,400 115,850 115,083 115,551 115,551 115,551 0.00% 53890 Misc Grants - - 1,909 - - Intergovemmental Revenue 112,893 113,300 115,400 117,759 115,083 115,551 115,551 115,551 0.00% Charges For Services 11 CITY OF ANDOVER General Fund Revenue Budget Worksheet - 2025 Actual Actual Actual Actual Actual Budget* Estimate Requested* Chane count Num Description 2019 2020 2021 2022 2023 2024 2024 2025 $ % 54150 Recycling Fees 44,099 48,705 70,003 50,925 53,879 50,000 50,000 50,000 0.00% Charges For Services 44,099 48,705 70,003 50,925 53,879 50,000 50,000 50,000 0.00% Miscellaneous Revenue 58100 Refunds & Reimbursements 763 103 - - - - Miscellaneous Revenue 763 103 - - Total 157,755 162,108 185,403 168,684 168,962 165,551 165,551 165,551 0.00% 49100 - Unallocated General Property Tax 51100 Property Tax - Current 7,636,518 8,028,774 8,225,044 8,626,158 9,441,581 11,576,126 11,576,126 12,143,182 567,056 4.90% 51110 Property Tax - Delinquent 12,342 37,610 41,795 20,341 9,871 40,000 40,000 40,000 - 0.00% 51300 Fiscal Disparities 1,216,431 1,232,162 1,255,098 1,318,343 1,212,690 - - - #DIV/0! 51400 Penalties & Interest on Taxes (571) 4,689 5,733 (2,063) (5,113) 5,000 5,000 5,000 - 0.00% 51500 Forfeited Tax Sale 11,362 4,230 - General Property Tax 8,864,720 9,303,235 9,527,670 9,974,141 10,663,259 11,621,126 11,621,126 12,188,182 567,056 4.88% Intergovernmental Revenue 53310 Local Government Aid #DIV/0! 53340 PERA Aid 10,093 #DIV/0! 53380 Market Value Homestead Cred 3,960 4,128 3,578 4,417 3,682 #DIV/0! 53490 Other Grants - - Intergovemmental Revenue 14,053 4,128 3,578 4,417 3,682 #DIV/0! Investment Income 56910 Interest Earned 136,771 119,333 60,776 57,744 206,647 75,000 100,000 100,000 25,000 33.33% 56920 Valuation Adjustment 72,186 29,641 (75,959) (247,238) 170,708 - - - - 4DIV/0! Investment Income 208,957 148,974 (15,183) (189,494) 377,355 75,000 100,000 100,000 25,000 33.33% Miscellaneous Revenue 58100 Refunds & Reimbursements 4,080 - - - - - - - - #DIV/0! 58105 Rent 71,175 74,144 76,685 79,459 77,650 75,000 75,000 75,000 0.00% 58140 Maps, etc 20 40 45 15 60 - - - #DIV/0! 58155 Sale of Used Equipment 7,500 - - Miscellaneous Revenue 82,775 74,184 76,730 79,474 77,710 75,000 75,000 75,000 0.00% Other Financing Sources 59100 Operating Transfers In 188,008 190,688 212,031 197,081 228,772 221,246 221,246 177,180 (44,066) -19.92% Other Financing Sources 188,008 190,688 212,031 197,081 228,772 221,246 221,246 177,180 (44,066) -19.92% Total 9,358,513 9,721,209 9,804,826 10,065,619 11,350,778 11,992,372 12,017,372 12,540,362 547,990 4.57% 12 CITY OF ANDOVER General Fund Revenue Budget Worksheet - 2025 Actual Actual Actual Actual Actual Budget* Estimate Requested*1 Chane (*) count Num Description 2019 2020 2021 2022 2023 2024 2024 2025 $ % Grand Total 12,327,212 12,686,944 12,813,448 13,457,703 14,804,988 14,506,539 14,748,406 15,185,814 679,275 4.68% General Fund Summary 51000 General Property Tax 8,864,720 9,303,235 9,527,670 9,974,141 10,663,259 11,621,126 11,621,126 12,188,182 567,056 4.88% 52000 License & Permits 855,831 892,277 891,762 972,878 854,738 617,600 722,175 668,850 51,250 8.30% 53000 Intergovernmental Revenue 822,129 861,178 939,174 963,290 977,028 868,657 834,259 878,892 10,235 1.18% 54000 Charges For Services 1,133,160 1,070,788 1,036,850 1,295,429 1,447,507 897,610 1,042,220 966,910 69,300 7.72% 56000 Fines 62,349 47,630 53,747 55,983 70,683 50,500 50,500 50,500 - 0.00% 56900 Investment Income 208,957 148,974 (15,183) (189,494) 377,355 75,000 100,000 100,000 25,000 33.33% 57000 Special Assessments 13,982 13,347 10,194 8,540 11,440 8,000 8,000 8,000 - 0.00% 58000 Miscellaneous Revenue 178,076 158,827 157,203 179,855 174,206 146,800 150,165 147,300 500 0.34% 59000 Other Financing Sources 188,008 190,688 212,031 197,081 228,772 221,246 221,246 177,180 (44,066) -19.92% 12,327,212 12,686,944 12,813,448 13,457,703 14,804,988 14,506,539 14,749,691 15,185,814 679,275 4.68% 13 CITY OF ANDOVER General Fund - Expenditure Budget Summary Totals - By Department Budget Year 2025 Actual Actual Actual Actual Actual Budget* Estimate Requested* Change(*) 2019 2020 2021 2022 2023 2024 2024 2025 $ % GENERAL GOVERNMENT Mayor and Council $ 99,001 $ 95,519 $ 95,658 $ 95,366 $ 99,860 $ 112,042 $ 105,042 $ 111,874 (168) -0.15% Administration 211,898 187,758 229,314 245,222 278,092 303,714 301,114 320,561 16,847 5.55% Newsletter 24,413 22,156 22,945 24,631 27,733 36,000 32,000 36,000 0 0.00% Human Resources 15,842 16,181 20,836 19,905 21,172 134,494 134,494 135,708 1,214 0.90% Attorney 191,782 195,721 199,809 206,399 207,922 223,486 221,000 227,836 4,350 1.95% City Clerk 160,184 166,221 175,177 184,318 193,217 204,009 204,009 213,349 9,340 4.58% Elections 20,452 91,643 20,260 75,115 28,002 90,906 90,906 92,188 1,282 1.41% Finance 280,199 294,501 307,009 320,729 335,992 360,343 360,343 377,001 16,658 4.62% Assessing 149,033 154,482 128,829 131,097 136,705 161,000 161,000 161,000 0 0.00% InfomtationServices 169,827 187,703 185,642 226,588 235,842 249,184 249,184 278,229 29,045 11.66% Planning & Zoning 412,282 453,133 491,395 490,576 473,193 570,506 570,506 588,951 18,445 3.23% Engineering 561,642 566,224 594,720 649,664 703,515 755,758 757,558 789,785 34,027 4.50% Facility Management 547,402 475,083 548,666 552,986 549,721 783,845 808,345 812,961 29,116 3.71% Total General Gov 2,843,957 2,906,325 3,020,260 3,222,596 3,290,966 3,985,287 3,995,501 4,145,443 160,156 4.02% PUBLIC SAFETY Police Protection 3,183,610 3,114,623 3,287,046 3,261,423 3,347,315 3,739,849 3,739,849 3,932,050 192,201 5.14% Fire Protection 1,391,252 1,508,854 1,706,876 1,961,915 1,926,998 2,120,451 2,247,405 2,323,989 203,538 9.60% Protective Inspection 493,955 519,183 519,787 464,560 501,561 557,917 557,917 588,979 31,062 5.57% Emergency Management 18,608 17,227 15,203 12,296 19,958 34,987 34,987 39,809 4,822 13.78% Animal Control 4,368 2,347 3,517 5,164 4,795 10,950 5,950 10,950 0 0.00% Total Public Safety 5,091,793 5,162,234 5,532,429 5,705,358 5,800,627 6,464,154 6,586,108 6,895,777 431,623 6.68% PUBLIC WORKS Streets and Highways 615,450 686,978 804,392 788,330 899,542 994,486 994,486 1,058,439 63,953 6.43% Snow and Ice Removal 703,647 496,668 540,226 752,396 771,857 901,461 901,461 925,774 24,313 2.70% Street Signs 202,996 257,281 196,782 194,276 169,472 221,186 221,186 230,342 9,156 4.14% Traffic Signals 26,422 23,045 33,362 28,150 29,471 44,000 44,000 44,000 0 0.00% Street Lighting 32,716 34,211 36,533 36,142 29,975 45,400 45,400 45,400 0 0.00% Street Lights - Billed 145,604 152,181 156,841 158,028 151,879 182,000 182,000 182,000 0 0.00% Park & Recreation 1,180,502 1,426,233 1,505,145 1,482,060 1,665,607 1,779,408 1,799,408 1,846,403 66,995 3.77% Natural Resource Preservation 16,831 9,821 9,738 15,932 10,946 17,022 17,022 17,102 80 0.47% Recycling 224,575 228,124 239,607 169,167 176,063 245,609 245,609 249,965 4,356 1.77% Total Public Works 3,148,743 3,314,542 3,522,626 3,624,481 3,904,812 4,430,572 4,450,572 4,599,425 168,853 3.81% OTHER 15,001 1,012,778 766,109 567,396 223,436 95,600 95,600 96,100 500 0.52% Total Other 15,001 1,012,778 766,109 567,3% 223,436 95,600 95,600 96,100 500 0.52% GRAND TOTAL $ 11,099,494 $ 12 395,879 $ 12,841,424 $ 13,119,831 $ 13,219,841 $ 14,975,613 $ 15,127,781 $ 15,736,745 761,132 5.08% 14 W CITY OF ANDOVER Budget Worksheet - 2025 General Fund General Fund Rollup Change from Budget Account Actual Actual Actual Actual Actual Budget Estimate Requested 2024 to Budget 2025 Number Description 2019 2020 2021 2022 2023 2024 2024 2025 S % Salaries & Benefits 60110 Salaries-Regular 3,238,979 3,352,190 3,426,719 3,537,409 3,692,054 4,456,126 4,456,126 4,643,833 187,707 4.21% 60120 Salaries- Volunteer Fire Fighters 377,362 396,063 425,176 535,960 514,477 590,854 590,854 623,011 32,157 5.44% 60130 Salaries-Election Judges - 48,310 - 50,038 898 - - - - #DIV/0!00 60140 Salaries - Council / Commission 58,620 55,946 58,907 57,900 57,360 66,000 66,000 66,0 - 0.00% 60210 FICA 198,368 203,309 207,741 220,285 225,485 284,996 284,996 297,160 12,164 4.27% 60220 Medicare 50,486 52,566 53,345 57,258 61,942 73,339 73,339 76,532 3,193 4.35% 60310 Health Insurance 460,257 504,613 556,609 562,045 699,364 686,100 686,100 778,000 91,900 13.39% 60320 Dental Insurance 18,258 18,957 19,682 19,757 20,726 23,460 23,460 23,970 510 2.171% 60330 Life Insurance 1,205 670 654 605 638 980 980 980 - 0.00% 60340 Long-Term Disability 8,020 7,227 7,538 7,039 8,351 12,785 12,785 13,353 568 4.44% 60410 PERA 252,503 245,000 257,128 273,508 290,764 381,029 381,029 397,527 16,498 4.33% 60420 Nationwide Retirement 9,735 28,966 26,721 25,662 37,017 4,148 4,148 4,148 - 0.00% 60520 Workers Comp 169,255 175,427 178,564 189,675 184,753 224,704 224,704 252,840 28,136 12.52% 60540 Relief Association 181,101 249,699 202,747 260,669 249,917 220,000 278,500 290,000 70,000 31.82% 60990 Inter-City Labor Allocation (113,872) - - (441,167) (441,167) (460,043) (18,876) 4.28% Salaries & Benefits 5,024,149 5,225,071 5,421 531 5,797,810 6,043,746 6,583,354 6,641,854 7,007,311 423,957 6.44% Departmental 61005 Supplies - General 29,246 37,908 40,502 27,673 26,924 41,245 40,945 41,845 600 1.45% 61010 Supplies - Printed Forms - 430 169 - 1,272 1,000 1,000 1,000 - 0.00% 61015 Supplies-Training 4,251 3,438 4,694 10,531 3,651 10,000 10,000 11,000 1,000 10.00% 61020 Supplies - Operating 81,035 91,724 124,378 107,243 94,763 116,640 116,640 117,640 1,000 0.86% 61025 Supplies-Cleaning 8,676 8,427 5,729 13,166 5,132 12,650 12,650 13,450 800 6.321% 61030 Supplies - Signs 30,560 64,107 5,162 27,142 26,500 40,000 40,000 40,000 - 0.00°/ 61060 Supplies - Fire Prevention/Educati< 4,029 1,358 3,830 2,898 3,585 4,500 4,500 5,000 500 11.11% 61105 R & M Supplies - General 24,451 21,859 12,946 35,357 34,915 42,550 42,550 42,550 - 0.00% 61120 R & M Supplies - Building 8,618 7,428 7,456 8,104 13,912 26,170 26,170 26,410 240 0.92% 61125 R & M Supplies - Streets 208,372 144,724 144,817 195,205 182,645 215,000 215,000 220,000 5,000 2.33% 61130 R & M Supplies - Landscape 34,739 39,133 37,835 36,042 49,893 47,500 47,500 52,500 5,000 10.53% 61205 Small & Expend - Small Tools 18,649 17,695 15,192 10,519 7,693 25,050 25,050 25,500 450 1.80% 61210 Small & Expend - Office Equipm 3,013 5,655 35,875 5,974 3,421 5,000 5,000 5,000 - 0.00% 61220 Software 150 150 4,183 1,942 533 6,300 6,300 6,300 - 0.00% 61225 Technology Upgrades 8,388 11,403 9,087 6,798 9,054 15,000 15,000 18,000 3,000 20.00% 61245 Items for Resale - - - - - - - - - #DIV/01 61305 Uniforms 30,388 41,087 44,653 70,669 21,359 55,000 113,454 63,170 8,170 14.85% 61310 Meals/Lodging 9,101 3,749 14,440 17,757 24,237 23,300 22,800 26,400 3,100 13.30% 61315 Continuing Education 31,204 30,783 88,272 105,447 76,763 87,975 84,275 86,525 (1,450) -1.65% 61320 Annual Dues / Licenses 58,026 61,810 64,682 76,878 90,714 83,648 82,848 85,466 1,818 2.17% 61325 Subscriptions / Publications 576 909 3,047 2,646 828 4,600 4,900 5,400 800 17.39% 61405 Postage 22,892 20,928 20,996 22,237 25,904 34,600 33,600 34,600 - 0.001% 61410 Transportation / Mileage 7,652 5,058 5,499 7,887 7,476 12,485 11,285 12,285 (200) -1.60% Departmental 624,016 619,763 693,444 792,115 711,174 910,213 961,467 940,041 29,828 3.28% Operating 62005 Electric 279,214 277,744 290,249 284,739 275,795 340,250 340,250 342,750 2,500 0.73% 62010 Water & Sewer Service 66,923 75,464 83,927 85,949 117,338 96,500 96,500 99,750 3,250 3.37% 62015 Natural Gas 46,638 44,207 49,449 68,827 57,281 80,950 80,950 85,150 4,200 5.19% 62020 Refuse Collection 33,238 38,673 35,387 37,296 24,027 41,300 41,300 44,360 3,060 7.41% 62025 Storm Water Utility Charge 7,367 7,778 7,800 8,109 8,300 8,260 8,260 9,400 1,140 13.80% 62030 Telephone 51,018 57,134 49,873 53,064 67,711 86,500 85,900 87,200 700 0.81% 62100 Insurance 144,303 144,429 159,234 184,504 193,929 200,414 200,414 206,440 6,026 3.01% 62200 Rentals 32,981 38,323 47,225 32,727 32,200 47,000 47,000 50,450 3,450 7.34% 62205 Central Equipment Services 504,866 548,513 622,604 691,000 799,100 947,149 947,149 988,492 41,343 4.360% 62300 Equipment Maintenance Contract 28,505 17,340 27,301 24,411 30,828 66,250 66,250 66,650 400 0.600% 62305 Software Maintenance Contracts 93,081 101,301 118,556 157,149 145,721 157,010 157,010 177,260 20,250 12.90 Operating 1,288,134 1,350,906 1,491,605 1,627,775 1,752,230 2,071,583 2,070,983 2,157,902 86,319 4.17% Professional Services 63005 Professional Services 264,222 279,991 281,461 278,746 284,141 299,450 298,450 304,100 4,650 1.55% 63010 Contractual Services 3,523,279 3,433,113 3,611,421 3,545,218 3,682,659 4,178,909 4,173,909 4,381,927 203,018 4.86% 63015 Attorney 191,782 195,721 199,809 206,399 207,922 223,486 221,000 227,836 4,350 1.95% 63025 Publishing 11,065 10,860 10,854 9,307 9,684 15,900 15,900 16,160 260 1.64% 63030 Printing 9,820 10,939 10,671 12,014 11,824 22,250 19,250 22,250 - 0.00% 63100 R & M Labor - General 9,964 17,339 22,346 40,881 15,465 57,500 57,500 62,750 5,250 9.13% 63105 R & M Labor - Building 112,332 63,822 110,620 63,096 56,354 149,250 173,750 152,250 3,000 2.01% 63110 R & M Labor - Streets 2,520 894 250 34,036 1,736 10,000 10,000 10,000 - 0.00% 63215 Recording Fee 598 414 907 276 940 738 738 738 - 0.00% 63300 Improvements - Streets 5,880 1,396 10,645 - 4,528 13,000 13,000 13,000 - 0.00% 63900 Miscellaneous 11,282 11,056 13,976 15,161 22,806 139,980 139,980 140,480 500 0.360% 63905 Contingency 4,036 1,722 2,714 2,538 994 65,000 65,000 65,000 - 0.00% Professional Services 4,146,780 4,027,267 4,275,674 4,207,672 4,299,053 5,175,463 5,188,477 5,396,491 221,028 4.27% Capital Outlay 65300 Improvements 16,415 172,872 197,853 144,459 123,996 235,000 255,000 235,000 - 0.00% 65600 Equipment 11,317 89,642 - 10,000 - #DIV/O! Capital Outlay 16,415 172,872 209,170 144,459 213,638 235,000 265,000 235,000 - 0.00% Other Financing Uses 67101 Operating Transfers Out 1,000,000 750,000 550,000 200,000 - - - #DIV/0! Other Financing Uses 1,000,000 750,000 550,000 200,000 - - #DIV/01 Total 11,099,494 12,395,879 12,841,424 131 13,219,841 14,975,613 15,127,781 15,736,745 761,132 5.08% 761,132 5.08% W 16 MY OF ANDOVER Budget Worksheet - 2025 Function: General Government General Government Rollup Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2019 2020 2021 2022 2023 2024 2024 2025 Salaries & Benefits 60110 Salaries - Regular 1,275,888 1,341,335 1,388,350 1,452,492 1,498,207 2,286,331 2,286,331 2,370,083 60130 Salaries - Election Judges - 48,310 50,038 898 - - - 60140 Salaries - Council / Commissior 55,990 53,026 55,687 55,410 54,760 59,000 59,000 59,000 60210 FICA 76,014 80,911 83,157 87,822 90,637 142,002 142,002 147,192 60220 Medicare 17,954 19,150 19,617 20,632 23,959 33,209 33,209 34,424 60310 Health Insurance 188,778 193,497 220,599 221,071 259,717 334,400 334,400 374,000 60320 Dental Insurance 6,361 6,928 7,059 6,847 7,543 10,710 10,710 11,220 60330 Life Insurance 215 134 137 134 166 440 440 440 60340 Long-Tenn Disability 3,177 2,956 3,049 2,760 4,029 5,802 5,802 6,020 60410 PERA 94,584 100,586 102,601 105,203 109,748 171,250 171,250 177,532 60420 Nationwide Retiremem 3,088 3,089 3,089 3,089 3,090 4,148 4,148 4,148 60520 Workers Comp 46,145 48,231 50,711 53,153 53,859 82,558 82,558 85,660 60990 Inter-City Labor Allocatior (37,939) (778,717) (778,717) (809,937) Salaries & Benefits 1,768,194 1,860,214 1,934,056 2,058,651 2,106,613 2,351,133 2,351,133 2,459,782 Departmental 61005 Supplies- General 13,777 21,256 18,038 16,094 18,479 21,800 21,500 21,750 61020 Supplies- Operating (911) 3,668 (4,753) (3,638) (3,634) 6,790 6,790 6,790 61025 Supplies-Cleaning 5,141 5,095 3,278 6,603 4,336 8,650 8,650 9,450 61120 R & M Supplies- Building 8,618 7,428 7,456 8,104 13,912 26,170 26,170 26,410 61205 Small & Expend - Small Tools 482 1,159 911 2,592 5,086 6,700 6,700 6,700 61210 Small & Expend- Office Equipn 3,013 5,655 1,875 5,974 3,421 5,000 5,000 5,000 61220 Software 150 150 414 264 414 1,300 1,300 1,300 61225 Technology Upgrades 8,388 11,403 9,087 6,798 9,054 15,000 15,000 18,000 61245 Items for Resale - - - - - - - 61310 Meals/ Lodging 2,985 853 1,439 2,888 4,192 7,350 6,850 7,450 61315 Continuing Education 4,559 856 6,816 17,170 16,452 21,975 18,275 17,125 61320 Annual Dues Licenses 45,102 45,823 47,929 55,428 59,525 64,238 63,438 66,056 61325 Subscriptions Publications 35 440 48 114 295 1,100 1,400 1,100 61405 Postage 19,754 17,765 19,796 20,697 24,558 28,650 27,650 28,650 61410 Transportation/ Mileage 6,363 4,520 3,892 4,722 4,187 7,460 6,260 7,260 Departmental 117,456 126,071 116,226 143,810 160,277 222,183 214,983 223,041 Operating 62005 Electric 64,598 59,798 53,976 53,796 53,686 81,250 81,250 83,750 62010 Water & Sewer Service 17,782 22,020 27,148 26,829 34,369 36,500 36,500 39,750 62015 Natural Gas 46,119 43,783 49,125 67,982 56,648 79,750 79,750 83,950 62020 Refuse Collection 11,299 12,415 12,169 12,625 5,582 15,300 15,300 15,360 62025 Storm Water Utility Charge 5,947 6,232 6,176 6,480 6,642 7,060. 7,060 8,200 62030 Telephone 36,017 35,680 30,791 33,708 44,024 58,900 58,300 59,600 62100 Insurance 78,358 78,484 87,024 100,883 104,127 107,664 107,664 110,904 62200 Rentals 13,121 13,218 11,454 9,443 12,140 14,750 14,750 18,200 62205 Central Equipment Services 16,414 17,235 22,260 26,000 22,050 22,823 22,823 25,272 62300 Equipment Maintenance Contrac 11,114 11,164 7,632 9,689 14,508 40,750 40,750 41,150 62305 Software Maintenance Contracts 61,115 66,497 77,624 109,669 109,826 111,130 111,130 125,880 Operating 361,884 366,526 385,379 457,104 463,602 575,877 575,277 612,016 Professional Services 63005 Professional Services 187,533 195,554 170,240 180,096 182,960 221,950 220,950 225,100 63010 Contractual Services 90,637 82,716 86,604 97,042 96,005 107,340 107,340 110,840 63015 Attorney 191,782 195,721 199,809 206,399 207,922 223,486 221,000 227,836 63025 Publishing 3,404 4,348 4,901 4,062 4,105 4,400 4,400 4,660 63030 Printing 9,820 10,939 10,015 11,757 11,824 17,950 14,950 17,950 63100 R & M Labor- General - 922 - - 1,600 1,600 1,850 63105 R & M Labor- Building 112,332 63,822 110,620 63,096 56,354 149,250 173,750 152,250 63215 Recording Fee 598 414 907 276 940 738 738 738 63900 Miscellaneous 317 581 303 364 109,380 109,380 109,380 Professional Services 596,423 553,514 584,599 563,031 560,474 836,094 854,108 850,604 Capital Outlay 65600 Equipment - Capital Outlay Total 2,843,957 2,906,325 3,020,260 3,222,596 3,290,966 3,985,287 3,995,501 4,145,443 160,156 4.02% 16 CITY OF ANDOVER Budget Worksheet - 2025 Function: General Government City Council -41100 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2019 2020 2021 2022 2023 2024 2024 2025 Salaries & Benefits 60140 Salaries - Council / Commissior 52,000 50,846 52,000 52,000 52,000 52,000 52,000 52,000 60210 FICA 3,225 3,153 3,224 3,225 3,225 3,224 3,224 3,224 60220 Medicare 754 738 754 754 754 754 754 754 60410 PERA 900 900 - 3,900 3,900 3,900 Salaries & Benefits 56,879 55,637 55,978 55,979 55,979 59,878 59,878 59,878 Departmental 61005 Supplies - General 210 262 335 230 1,009 1,300 1,000 1,000 61310 Meals / Lodging 811 485 642 1,396 1,658 1,900 1,900 2,200 61315 Continuing Education 355 - 545 370 15 3,000 500 3,000 61320 Annual Dues / Licenses 28,332 28,080 27,740 27,649 30,802 31,040 31,040 31,316 61410 Transportation / Mileage 1,372 509 - 1,000 - 800 Departmental 31,080 29,336 29,262 29,645 33,484 38,240 347440 38,316 Operating 62030 Telephone 876 876 600 600 600 1,000 600 700 62100 Insurance 1,779 1,779 1,779 1,779 1,868 1,924 1,924 1,980 Operating 2,655 2,655 2,379 2,379 2,468 2,924 2,524 2,680 Professional Services 63005 Professional Services 8,387 7,818 8,039 7,363 7,929 11,000 8,200 11,000 63025 Publishing 73 Professional Services 8,387 7,891 8,039 7,363 7,929 11,000 8,200 11,000 Total 99,001 95,519 95,658 95,366 99,860 112,042 105,042 111,874 (168) 0.15% 8/15/2024 17 CITY OF ANDOVER Budget Worksheet - 2025 Function: General Government Administration - 41200 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2019 2020 2021 2022 2023 2024 2024 2025 8/15/2024 18 Salaries & Benefits 60110 Salaries - Regular 145,402 144,292 153,361 166,524 185,829 260,244 260,244 268,659 60210 FICA 7,605 7,872 8,208 9,297 10,444 16,135 16,135 16,657 60220 Medicare 1,956 1,948 2,084 2,266 2,550 3,774 3,774 3,895 60310 Health Insurance 13,871 16,804 18,693 21,266 29,555 25,300 25,300 28,000 60320 Dental Insurance 435 447 445 568 628 510 510 1,020 60330 Life Insurance 13 10 10 11 12 40 40 40 60340 Long -Term Disability 258 245 250 243 280 676 676 699 60410 PERA 10,483 10,714 11,088 12,413 13,358 19,518 19,518 20,149 60420 Nationwide Retirement 3,088 3,089 3,089 3,089 3,090 4,148 4,148 4,148 60520 Workers Comp 5,275 5,181 5,596 6,048 6,498 9,629 9,629 9,941 60990 Inter -City Labor Allocation 24,168 65,560 65,560 6( 1,759) Salaries & Benefits 188,386 166,434 202,824 221,725 252,244 274,414 274,414 291,449 Departmental 61005 Supplies - General 1,075 1,489 3,172 1,933 2,647 2,000 2,000 2,000 61310 Meals / Lodging 736 304 175 122 840 1,500 1,000 1,000 61315 Continuing Education 1,790 98 1,330 772 752 2,200 1,000 2,200 61320 Annual Dues / Licenses 637 727 1,480 1,209 1,384 2,300 1,500 2,100 61325 Subscriptions / Publications - - - 66 195 - 300 - 61405 Postage 720 402 2,046 1,126 708 1,100 1,100 1,100 61410 Transportation / Mileage 1,837 1,800 1,800 1,800 1,800 2,000 1,800 2,000 Departmental 6,795 4,820 10,003 7,028 8,326 11,100 8,700 10,400 Operating 62030 Telephone 999 786 769 751 1,018 1,200 1,000 1,200 62100 Insurance 15,718 15,718 15,718 15;718 16,504 17,000 17,000 17,512 62300 Equipment Maintenance Comr, - - - - - - - - Operating 16,717 16,504 16,487 16,469 17,522 18,200 18,000 18,712 Professional Services 63005 Professional Services - - - - - 63015 Attorney Professional Services Total 211,898 187,758 229,314 245,222 278,092 303,714 301,114 320,561 16,847 5.55% 8/15/2024 18 8/15/2024 19 CITY OF ANDOVER Budget Worksheet - 2025 Function: General Government Newsletter - 41210 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2019 2020 2021 2022 2023 2024 2024 2025 Departmental 61320 Annual Dues & License; - - 598 689 689 - - - 61405 Postage 14,593 12,336 12,332 12,680 15,220 19,000 18,000 19,000 Departmental 14,593 12,336 12,930 13,369 15,909 19,000 18,000 19,000 Professional Services 63030 Printing 9,820 9,820 10,015 11,262 11,824 17,000 14,000 17,000 Professional Services 9,820 9,820 10,015 11,262 11,824 17,000 14,000 17,000 Total 24,413 22,156 22,945 24,631 27,733 36,000 32,000 36,000 0.00% 8/15/2024 19 CITY OF ANDOVER Budget Worksheet - 2025 Function: General Government Human Resources - 41230 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2019 2020 2021 2022 2023 2024 2024 2025 Salaries & Benefits 60110 Salaries -Regular 3,691 6,365 6,645 7,096 7,960 127,188 127,188 131,098 60210 FICA 213 364 389 419 477 7,886 7,886 8,128 60220 Medicare 50 86 91 98 112 1,844 1,844 1,901 60310 Health Insurance 660 627 751 729 790 23,300 23,300 26,000 60320 Dental Insurance 22 19 20 21 22 510 510 510 60330 Life Insurance 1 1 1 1 1 20 20 20 60340 Long -Term Disability 13 14 16 14 17 331 331 341 60410 PERA 275 468 496 529 596 9,539 9,539 9,832 60520 Workers Comp 133 228 242 251 290 4,706 4,706 4,851 60990 Inter -City Labor Allocation - - -164,825 16( 4,825) 171,768 Salaries & Benefits 5,058 8,172 8,651 9,158 10,265 10,499 10,499 10,913 Departmental 61005 Supplies - General 1,076 1,008 966 693 540 1,000 1,000 1,000 61310 Meals / Lodging 414 32 498 400 438 500 500 500 61315 Continuing Education 400 128 770 490 1,219 975 975 975 61320 Annual Dues / Licenses 873 915 1,194 984 604 990 990 990 61325 Subscriptions / Publications - 411 - - - 600 600 600 61405 Postage 29 45 40 43 61 200 200 200 61410 Transportation / Mileage 583 60 135 161 161 400 400 400 Departmental 3,375 2,599 3,603 2,771 3,023 4,665 4,665 4,665 Operating 62305 Software Maintenance Contrac 4,325 4,295 4,500 4,680 4,867 5,200 5,200 5,500 Operating 4,325 4,295 4,500 4,680 4,867 5,200 5,200 5,500 Professional Services 63005 Professional Services 2,717 1,115 3,035 2,755 2,653 4,250 4,250 4,750 63025 Publishing 50 - 466 238 - 500 500 500 63900 Miscellaneous 317 - 581 303 364 109,380 109,380 109,380 Professional Services 3,084 1,115 4,082 3,296 3,017 114,130 114,130 114,630 Total 15,842 16,181 20,836 19,905 21,172 134,494 134,494 135,708 1,214 0.90% 8/15/2024 20 CITY OF ANDOVER Budget Worksheet - 2025 Function: General Government Attorney - 41240 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2019 2020 2021 2022 2023 2024 2024 2025 Professional Services 63015 Attorney 191,782 195,721 199,809 206,399 207,922 223,486 221,000 227,836 Professional Services 191,782 195,721 199,809 206,399 207,922 223,486 221,000 227,836 Total 191,782 195,721 199,809 206,399 207,922 223,486 221,000 227,836 4,350 1.95% 8/15/2024 21 8/15/2024 22 CITY OF ANDOVER Budget Worksheet - 2025 Function: General Government City Clerk - 41300 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2019 2020 2021 2022 2023 2024 2024 2025 Salaries & Benefits 60110 Salaries - Regular 99,950 105,335 109,431 114,075 114,789 194,330 194,330 201,102 60210 FICA 5,811 6,006 6,338 6,655 6,710 8,638 8,638 9,059 60220 Medicare 1,359 1,427 1,482 1,557 1,569 2,020 2,020 2,118 60310 Health Insurance 14,554 15,837 17,947 21,082 28,035 25,300 25,300 28,000 60320 Dental Insurance 452 556 719 648 770 1,020 1,020 1,020 60330 Life Insurance 14 9 12 12 12 40 40 40 60340 Long -Term Disability 164 172 208 205 201 362 362 380 60410 PERA 7,353 7,815 8,162 8,486 8,573 10,449 10,449 10,957 60520 Workers Comp 3,614 3,780 3,985 4,174 4,176 5,155 5,155 5,406 60990 Inter -City Labor Allocation- (1,821) 73,755 7( 3,755)7( 6,019) Salaries & Benefits 133,271 139,116 148,284 156,894 164,835 173,559 173,559 182,063 Departmental 61005 Supplies- General 384 296 229 341 328 600 600 600 61310 Meals / Lodging - - - 45 - 350 350 350 61315 Continuing Education - - - - - 200 200 200 61320 Annual Dues / Licenses 45 395 260 265 275 500 500 500 61405 Postage 359 345 420 573 357 400 400 400 61410 Transportation / Mileage 22 40 - 68 - 200 200 200 Departmental 810 1,076 909 1,292 960 2,250 2,250 2,250 Operating 62030 Telephone - - - - - - - - 62100 Insurance 25,677 25,677 25,677 25,677 26,961 27,800 27,800 28,636 62305 Software Maintenance Contrac 150 200 200 200 50 200 200 200 Operating 25,827 25,877 25,877 25,877 27,011 28,000 28,000 28,836 Professional Services 63025 Publishing 276 152 107 255 411 - - - 63030 Printing - - - - - 200 200 200 63215 Recording Fee - - - Professional Services 276 152 107 255 411 200 200 200 Total 160,184 166,221 175,177 184,318 193,217 204,009 204,009 213,349 9,340 4.58% 8/15/2024 22 CITY OF ANDOVER Budget Worksheet - 2025 Function: General Government Elections - 41310 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2019 2020 2021 2022 2023 2024 2024 2025 Salaries & Benefits 60110 Salaries - Regular 9,984 18,709 9,961 10,942 15,240 - - - 60130 Salaries - Election Judges - 48,310 - 50,038 898 60210 FICA 587 1,780 581 1,511 210 60220 Medicare 137 418 136 354 2,702 60310 Health Insurance 1,638 3,149 2,020 2,653 57 60320 Dental Insurance 51 84 53 57 2 60330 Life Insurance 2 2 1 1 34 60340 Long -Term Disability 18 39 25 24 1,130 60410 PERA 744 1,384 743 818 556 60520 Workers Comp 360 698 363 406 - - - - 60990 Inter -City Labor Allocation - - - - 77,106 77,106 78,388 Salaries & Benefits 13,521 74 ,573 13,883 66 ,804 20,829 77,106 77,106 78,388 Departmental 61005 Supplies - General - 1,426 - 58 - - - 61020 Supplies - Operating 7,399 - 840 840 840 61310 Meals Lodging - 263 - - - 61405 Postage - - 1,000 1,000 1,000 61410 Transportation / Mileage 49 168 160 160 160 Departmental - 8,874 - 489 - 2,000 2,000 2,000 Professional Services 63010 Contractual Services 6,931 7,077 6,377 7,327 7,173 11,050 11,050 11,050 63030 Printing - 1,119 495 750 750 750 Professional Services 6,931 8,196 6,377 7,822 7,173 11,800 11,800 11,800 Total 20,452 91,643 20,260 75,115 28,002 90,906 90,906 92,188 1,282 1.41% 8/15/2024 23 Function: General Government Account Number Description CITY OF ANDOVER Budget Worksheet - 2025 Finance - 41400 Actual Actual Actual Actual Actual Budget Estimate Requested 2019 2020 2021 2022 2023 2024 2024 2025 16,658 4.62% 8/15/2024 24 Salaries & Benefits 60110 Salaries -Regular 169,691 178,883 184,422 189,593 197,198 316,275 316,275 329,139 60210 FICA 9,683 10,131 10,508 10,882 11,479 19,609 19,609 20,407 60220 Medicare 2,265 2,371 2,457 2,545 2,685 4,585 4,585 4,772 60310 Health Insurance 26,100 24,491 27,483 26,780 30,451 47,300 47,300 53,000 60320 Dental Insurance 973 1,008 1,012 1,044 1,093 1,530 1,530 1,530 60330 Life Insurance 30 18 18 18 18 60 60 60 60340 Long -Term Disability. 460 419 429 395 414 822 822 856 60410 PERA 12,666 13,287 13,759 14,198 14,770 23,721 23,721 24,686 60520 Workers Comp 6,136 6,423 6,721 6,917 7,183 11,701 11,701 12,178 60990 Inter -City Labor Allocation 3,637 -146,150 14( 6,150)15( 3,333) Salaries & Benefits 228,004 233,394 246,809 252,372 265,291 279,453 279,453 293,295 Departmental 61005 Supplies - General 2,172 3,458 3,892 2,331 4,169 4,500 4,500 4,750 61220 Software 150 150 150 - 150 300 300 300 61310 Meals / Lodging - - - - 500 500 500 61315 Continuing Education - - - - - 1,150 1,150 1,300 61320 Annual Dues / Licenses 350 580 480 390 390 750 750 750 61405 Postage 1,794 1,942 1,982 2,309 2,116 2,750 2,750 2,750 61410 Transportation / Mileage 159 95 63 107 119 400 400 400 Departmental 4,625 6,225 6,567 5,137 6,944 10,350 10,350 10,750 Operating 62030 Telephone 905 664 710 691 778 2,400 2,400 2,400 62100 Insurance 196 196 500 500 525 540 540 556 62305 Software Maintenance Contrac 22,050 23,398 28,000 29,120 30,285 32,500 32,500 33,000 Operating 23,151 24,258 29,210 30,311 31,588 35,440 35,440 35,956 Professional Services 63005 Professional Services 23,806 30,091 23,896 32,304 31,819 33,700 33,700 35,350 63025 Publishing 613 533 527 605 350 900 900 900 63100 R & M Labor- General - - - - 500 500 750 Professional Services 24,419 30,624 24,423 32,909 32,169 35,100 35,100 37,000 Total 280,199 294,501 307,009 320,729 335,992 360,343 360,343 377,001 16,658 4.62% 8/15/2024 24 CITY OF ANDOVER Budget Worksheet - 2025 Function: General Government Assessing - 41410 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2019 2020 2021 2022 2023 2024 2024 2025 Professional Services 63005 Professional Services 149,033 154,482 128,829 131,097 136,705 161,000 161,000 161,000 Professional Services 149,033 154,482 128,829 131,097 136,705 161,000 161,000 161,000 Total 149,033 154,482 128,829 131,097 136,705 161,000 161,000 161,000 0.00% 8/15/2024 25 8/15/2024 26 CITY OF ANDOVER Budget Worksheet - 2025 Function: General Government Information Services - 41420 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2019 2020 2021 2022 2023 2024 2024 2025 Salaries & Benefits 60110 Salaries - Regular 89,260 92,474 95,130 97,345 100,507 110,448 110,448 118,117 60210 FICA 5,498 5,625 5,857 6,019 6,212 6,848 6,848 7,323 60220 Medicare 1,286 1,326 1,370 1,408 1,453 1,601 1,601 1,713 60310 Health Insurance 7,787 8,508 9,538 9,937 12,891 12,000 12,000 13,500 60320 Dental Insurance 464 482 479 498 522 510 510 510 60330 Life Insurance 15 8 8 8 8 20 20 20 60340 Long -Term Disability 257 229 227 196 213 287 287 307 60410 PERA 6,662 6,871 7,098 7,294 7,528 8,284 8,284 8,859 60520 Workers Comp 3,228 3,319 3,466 3,555 3,660 4,087 4,087 4,370 60990 Inter -City Labor Allocation - (774) - -(12,171)(12,171)1( 3,140) Salaries & Benefits 114,457 118,068 123,173 126,260 132,994 131,914 131,914 141,579 Departmental 61005 Supplies - General 2,578 6,707 1,995 4,604 2,481 3,300 3,300 3,300 61020 Supplies- Operating (2,660) (5,209) (5,502) (4,204) (4,638) - - - 61210 Small & Expend - Office Equil 3,013 5,655 1,875 5,974 3,421 5,000 5,000 5,000 61225 Technology Upgrades 8,388 11,403 9,087 6,798 9,054 15,000 15,000 18,000 61310 Meals / Lodging - - - - - - - - 61315 Continuing Education - - - - - 250 250 250 61320 Annual Dues / Licenses 11,775 12,761 13,109 22,506 22,824 23,570 23,570 25,000 61405 Postage 69 41 112 117 260 200 200 200 61410 Transportation / Mileage 266 144 72 10 - 100 100 100 Departmental 23,429 31,502 20,748 35,805 33,402 47,420 47,420 51,850 Operating 62030 Telephone 1,164 4,217 (1,603) 1,090 1,366 1,450 1,450 1,450 62200 Rentals 3,248 3,248 3,248 - 5,458 4,000 4,000 4,000 62305 Software Maintenance Contrac 27,529 30,668 37,576 60,983 61,583 57,900 57,900 71,850 Operating 31,941 38,133 39,221 62,073 68,407 63,350 63,350 77,300 Professional Services 63005 Professional Services - - 2,500 2,450 1,039 6,000 6,000 7,000 63100 R & M Labor- General 500 500 500 Professional Services - 2,500 2,450 1,039 6,500 6,500 7,500 Total 169,827 187,703 185,642 226,588 235,842 249,184 249,184 278,229 29,045 11.66% 8/15/2024 26 8/15/2024 27 CITY,OF ANDOVER Budget Worksheet - 2025 Function: General Government Planning & Zoning - 41500 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2019 2020 2021 2022 2023 2024 2024 2025 Salaries & Benefits 60110 Salaries -Regular 287,617 327,537 345,373 345,478 325,911 390,131 390,131 403,901 60140 Salaries - Council / Commissio 3,990 2,180 3,687 3,410 2,760 7,000 7,000 7,000 60210 FICA 16,639 19,415 20,771 19,842 19,651 24,623 24,623 25,475 60220 Medicare 3,891 4,565 4,858 4,640 4,596 5,758 5,758 5,958 60310 Health Insurance 45,889 46,446 52,136 48,645 56,792 59,300 59,300 66,500 60320 Dental Insurance 1,818 2,136 2,132 1,844 1,757 2,040 2,040 2,040 60330 Life Insurance 59 37 37 31 28 80 80 80 60340 Long -Tenn Disability 814 773 801 646 644 1,014 1,014 1,049 60410 PERA 21,223 24,321 25,741 23,803 23,777 29,260 29,260 30,293 60520 Workers Comp 10,342 11,756 12,585 12,810 11,950 14,434 14,434 14,945 60990 Inter -City Labor Allocation - (3,199) - 3,617 3,617 3,662 Salaries & Benefits 392,282 435,967 468,121 461,149 447,866 537,257 537,257 560,903 Departmental 61005 Supplies -General 2,147 2,631 3,057 2,179 2,512 2,000 2,000 2,000 61020 Supplies - Operating 134 268 55 53 16 - - - 61310 Meals / Lodging 610 - 20 318 - 1,800 1,800 2,100 61315 Continuing Education 1,014 - 2,892 10,474 9,000 8,200 8,200 3,200 61320 Annual Dues / Licenses 1,527 657 657 826 990 3,088 3,088 3,400 61405 Postage 1,320 1,077 1,282 1,546 1,718 2,000 2,000 2,000 61410 Transportation / Mileage 261 - 18 193 900 900 900 Departmental 7,013 4,633 7,981 15,589 14,236 17,988 17,988 13,600 Operating 62030 Telephone 1,027 900 904 898 657 1,500 1,500 1,500 62100 Insurance 314 314 500 500 525 540 540 556 62200 Rentals 1,045 1,128 821 821 279 1,500 1,500 1,500 62205 Central Equipment Services 3,974 4,173 4,592 5,000 3,150 2,853 2,853 1,764 62305 Software Maintenance Contrac 250 200 200 200 50 830 830 830 Operating 6,610 6,715 7,017 7,419 4,661 7,223 7,223 6,150 Professional Services 63005 Professional Services 3,590 2,048 3,890 3,225 2,695 4,000 4,000 4,000 63025 Publishing 2,465 3,494 3,801 2,964 2,887 3,000 3,000 3,260 63100 R & M Labor- General - - - - - 300 300 300 63215 Recording Fee 322 276 585 230 848 738 738 738 Professional Services 6,377 5,818 8,276 6,419 6,430 8,038 8,038 8,298 Total 412,282 453,133 491,395 490,576 473,193 570,506 570,506 588,951 18,445 3.23% 8/15/2024 27 Function: General Government Account Number Description CITY OF ANDOVER Budget Worksheet - 2025 Engineering - 41600 Actual Salaries & Benefits 60110 Salaries - Regular 60210 FICA 60220 Medicare 60310 Health Insurance 60320 Dental Insurance 60330 Life Insurance 60340 Long -Term Disability 60410 PERA 60520 Workers Comp 60990 Inter -City Labor Allocation 106 Salaries & Benefits CITY OF ANDOVER Budget Worksheet - 2025 Engineering - 41600 Actual Actual Actual Actual Actual Budget Estimate Requested 2019 2020 2021 2022 2023 2024 2024 2025 4,793 7,100 7,100 7,100 61205 Small & Expend - Small Tools 106 394,027 399,726 408,679 445,308 473,201 791,744 791,744 819,216 22,347 22,713 23,093 25,664 27,535 49,089 49,089 50,790 5,226 5,365 5,401 6,002 6,440 11,481 11,481 11,880 62,580 62,484 74,490 72,077 89,404 129,900 129,900 145,500 2,146 2,196 2,199 2,167 2,270 4,080 4,080 4,080 66 40 41 43 45 160 160 160 995 888 904 860 953 2,060 2,060 2,131 28,576 29,720 29,935 31,962 34,776 59,381 59,381 61,442 14,300 14,395 15,008 16,211 17,297 29,295 29,295 30,312 - (3,953) - -38( 2,300 0,489)38( 0,489)39( 8,838) 530,263 533,574 559,750 600,294 651,921 696,701 696,701 726,673 8/15/2024 28 Departmental 61005 Supplies - General 4,135 3,979 4,392 3,725 4,793 7,100 7,100 7,100 61205 Small & Expend - Small Tools 106 650 772 1,808 4,794 2,200 2,200 2,200 61220 Software - - 264 264 264 1,000 1,000 1,000 61310 Meals / Lodging 414 32 104 344 1,256 800 800 800 61315 Continuing Education 1,000 630 1,279 5,064 5,466 6,000 6,000 6,000 61320 Annual Dues / Licenses 1,563 1,708 2,411 910 1,567 2,000 2,000 2,000 61325 Subscriptions / Publications 35 29 48 48 100 500 500 500 61405 Postage 870 1,577 1,582 2,303 4,118 2,000 2,000 2,000 61410 Transportation / Mileage 1,863 1,823 1,804 2,215 2,107 2,300 2,300 2,300 Departmental 9,986 10,428 12,656 16,681 24,465 23,900 23,900 23,900 Operating 62030 Telephone 4,928 4,355 3,732 4,016 3,606 6,600 6,600 6,600 62100 Insurance 333 333 500 500 525 540 540 556 62200 Rentals 1,045 1,128 821 821 279 1,500 1,500 1,500 62205 Central Equipment Services 12,440 13,062 14,368 17,000 15,750 17,117 17,117 21,156 62305 Software Maintenance Contrac 2,371 3,110 1,598 9,404 6,300 7,100 7,100 7,100 Operating 21,117 21,988 21,019 31,741 26,460 32,857 32,857 36,912 Professional Services 63005 Professional Services - - 51 902 120 2,000 3,800 2,000 63025 Publishing 96 - - 457 - - - 63100 R & M Labor- General - - 922 - - 300 300 300 63215 Recording Fees 276 138 322 46 92 - - - Professional Services 276 234 1,295 948 669 2,300 4,100 2,300 Total 561,642 566,224 594,720 649,664 703,515 755,758 757,558 789,785 34,027 4.50% 8/15/2024 28 CITY OF ANDOVER Budget Worksheet - 2025 Function: General Government Faciltiy Mgmt Rollup - 41900 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2019 2020 2021 2022 2023 2024 2024 2025 Salaries & Benefits 60110 Salaries - Regular 76,266 68,014 75,348 76,131 77,572 95,971 95,971 98,851 60210 FICA 4,406 3,852 4,188 4,308 4,694 5,950 5,950 6,129 60220 Medicare 1,030 906 984 1,008 1,098 1,392 1,392 1,433 60310 Health Insurance 15,699 15,151 17,541 17,902 11,742 12,000 12,000 13,500 60320 Dental Insurance - - - - 479 510 510 510 60330 Life Insurance 15 9 9 9 8 20 20 20 60340 Long -Term Disability 198 177 189 177 177 250 250 257 60410 PERA 5,702 5,106 5,579 5,700 5,814 7,198 7,198 7,414 60520 Workers Comp 2,757 2,451 2,745 2,781 2,805 3,551 3,551 3,657 60990 Inter -City Labor Allocation - (387)1( 6,490)1( 6,490) 17,130 Salaries & Benefits 106,073 95,279 106,583 108,016 104,389 110,352 110,352 114,641 Departmental 61005 Supplies - General - - - - - - - - 61020 Supplies - Operating 1,615 1,210 694 513 988 5,950 5,950 5,950 61025 Supplies - Cleaning 5,141 5,095 3,278 6,603 4,336 8,650 8,650 9,450 61120 R & M Supplies - Building 8,618 7,428 7,456 8,104 13,912 26,170 26,170 26,410 61205 Small & Expend - Small Tools 376 509 139 784 292 4,500 4,500 4,500 61245 Items for Resale - - - - - - - - 61320 Annual Dues / Licenses - - - - - Departmental 15,750 14,242 11,567 16,004 19,528 45,270 45,270 46,310 Operating 62005 Electric 64,598 59,798 53,976 53,796 53,686 81,250 81,250 83,750 62010 Water & Sewer Service 17,782 22,020 27,148 26,829 34,369 36,500 36,500 39,750 62015 Natural Gas 46,119 43,783 49,125 67,982 56,648 79,750 79,750 83,950 62020 Refuse Collection 11,299 12,415 12,169 12,625 5,582 15,300 15,300 15,360 62025 Storm Water Utility Charge 5,947 6,232 6,176 6,480 6,642 7,060 7,060 8,200 62030 Telephone 26,118 23,882 25,679 25,662 35,999 44,750 44,750 45,750 62100 Insurance 34,341 34,467 42,350 56,209 57,219 59,320 59,320 61,108 62200 Rentals 7,783 7,714 6,564 7,801 6,124 7,750 7,750 11,200 62205 Central Equipment Services - - 3,300 4,000 3,150 2,853 2,853 2,352 62300 Equipment Maintenance Contr, 11,114 11,164 7,632 9,689 14,508 40,750 40,750 41,150 62305 Software Support Contract 4,440 4,626 5,550 5,082 6,691 7,400 7,400 7,400 Operating 229,541 226,101 239,669 276,155 280,618 382,683 382,683 399,970 Professional Services 63010 Contractual Services 83,706 75,639 80,227 89,715 88,832 96,290 96,290 99,790 63100 R & M Labor - General - - - - - - - - 63105 R & M Labor - Building 112,332 63,822 110,620 63,096 56,354 149,250 173,750 152,250 Professional Services 196,038 139,461 190,847 152,811 145,186 245,540 270,040 252,040 Capital Outlay 65600 Equipment - - - - - - - - Capital Outlay - - - Total 547,402 475,083 548,666 552,986 549,721 783,845 808,345 812,961 29,116 3.71% 547,402 475,083 548,666 552,986 549,721 783,845 808,345 812,961 8/15/2024 29 8/15/2024 30 CITY OF ANDOVER Budget Worksheet - 2025 Function: General Government City Hall - 41910 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2019 2020 2021 2022 2023 2024 2024 2025 Salaries & Benefits 60110 Salaries - Regular 25,422 22,671 25,116 26,452 24,772 95,971 95,971 98,851 60210 FICA 1,469 1,284 1,396 1,436 1,564 5,950 5,950 6,129 60220 Medicare 343 302 328 336 366 1,392 1,392 1,433 60310 Health Insurance 5,283 5,050 7,733 5,968 3,913 12,000 12,000 13,500 60320 Dental Insurance - - - - 159 510 510 510 60330 Life Insurance 5 3 3 3 3 20 20 20 60340 Long -Term Disability 67 59 63 59 59 250 250 257 60410 PERA 1,901 1,702 1,860 1,900 1,937 7,198 7,198 7,414 60520 Workers Comp 919 817 915 927 886 3,551 3,551 3,657 60990 Inter -City Labor Allocation - (387) -90,059 9( 0,059) (93,559 Salaries & Benefits 35,409 31,501 37,414 37,081 33,659 36,783 36,783 38,212 Departmental 61020 Supplies - Operating 638 631 256 490 537 2,100 2,100 2,100 61025 Supplies - Cleaning 2,027 2,094 1,939 1,838 2,359 2,300 2,300 2,600 61120 R & M Supplies - Building 1,808 1,738 1,219 2,790 3,076 6,400 6,400 6,500 61205 Small & Expend - Small Tools - 51 20 596 17 2,000 2,000 2,000 Departmental 4,473 4,514 3,434 5,714 5,989 12,800 12,800 13,200 Operating 62005 Electric 16,550 16,860 16,956 16,364 16,524 23,250 23,250 23,750 62010 Water & Sewer Service 2,546 2,523 2,546 2,618 2,762 3,750 3,750 4,000 62015 Natural Gas 4,343 5,159 5,544 8,136 8,382 10,000 10,000 11,000 62020 Refuse Collection 2,203 2,598 2,267 2,581 1,745 2,500 2,500 2,560 62025 Storm Water Utility Charge 1,178 1,237 1,299 1,364 1,398 1,400 1,400 1,500 62030 Telephone 13,752 11,921 13,652 13,977 19,641 20,900 20,900 20,900 62100 Insurance 14,604 14,604 14,604 14,604 15,334 15,800 15,800 16,276 62200 Rentals 1,775 1,530 1,595 1,668 2,048 2,750 2,750 2,900 62300 Equipment Maintenance Contra 3,843 3,817 2,162 2,400 4,335 9,600 9,600 9,600 62305 Software Support Contract 1,480 1,542 1,850 1,700 1,900 2,100 2,100 2,100 Operating 62,274 61,791 62,475 65,412 74,069 92,050 92,050 94,586 Professional Services 63010 Contractual Services 28,901 27,006 27,156 27,435 33,715 38,500 38,500 38,500 63105 R & M Labor - Building 43,936 4,584 33,570 16,311 6,208 35,500 60,000 35,500 Professional Services 72,837 31,590 60,726 43,746 39,923 74,000 98,500 74,000 Total 174,993 129,396 164,049 151,953 153,640 215,633 240,133 219,998 4,365 2.02% 8/15/2024 30 CITY OF ANDOVER Budget Worksheet - 2025 Function: General Government Fire Stations - 41920 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2019 2020 2021 2022 2023 2024 2024 2025 Salaries & Benefits 60110 Salaries - Regular 25,422 22,672 25,116 25,377 25,878 - - - 60210 FICA 1,468 1,284 1,396 1,436 1,566 60220 Medicare 344 302 328 336 366 60310 Health Insurance 5,208 5,050 4,904 5,967 3,917 60320 Dental Insurance - - - - 160 60330 Life Insurance 5 3 3 3 2 60340 Long -Term Disability 65 59 63 59 59 60410 PERA 1,900 1,702 1,859 1,900 1,940 60520 Workers Comp 919 817 915 927 936 - - - 60990 Inter -City Labor Allocation - - - - - 36,784 36,784 38,214 Salaries & Benefits 35,331 31,889 34,584 36,005 34,824 36,784 36,784 38,214 Departmental 61020 Supplies - Operating 51 - - - 67 300 300 300 61025 Supplies - Cleaning 1,145 1,547 156 2,356 1,787 1,800 1,800 2,000 61120 R & M Supplies - Building 3,809 1,644 3,580 1,702 5,521 6,900 6,900 6,950 Departmental 5,005 3,191 3,736 4,058 7,375 9,000 9,000 9,250 Operating 62005 Electric 20,450 19,028 18,370 19,926 18,864 24,000 24,000 24,500 62010 Water & Sewer Service 4,259 3,691 3,452 4,055 6,061 6,000 6,000 6,500 62015 Natural Gas 14,280 12,497 14,348 20,642 20,983 23,000 23,000 24,000 62020 Refuse Collection 4,846 4,874 5,535 5,806 1,710 6,000 6,000 6,000 62025 Storm Water Utility Charge 130 136 143 147 151 160 160 200 62030 Telephone 6,844 6,421 5,676 5,408 7,028 14,950 14,950 14,950 62100 Insurance 10,764 10,764 10,764 10,764 11,302 11,700 11,700 12,052 62200 Rentals 1,420 1,639 635 1,672 1,254 - - 2,500 62205 Central Equipment Services - - 3,300 4,000 3,150 2,853 2,853 2,352 62300 Equipment Maintenance Contr 4,103 4,987 3,604 2,759 5,314 14,000 14,000 14,000 62305 Software Support Contract 1,480 1,542 1,850 1,700 1,900 2,100 2,100 2,100 Operating 68,576 65,579 67,677 76,879 77,717 104,763 104,763 109,154 Professional Services 63010 Contractual Services 21,270 22,602 26,022 34,489 25,701 30,440 30,440 30,440 63105 R & M Labor - Building 32,484 22,679 50,280 19,817 15,191 48,000 48,000 50,000 Professional Services 53,754 45,281 76,302 54,306 40,892 78,440 78,440 80,440 Total 162,666 145,940 182,299 171,248 160,808 228,987 228,987 237,058 8,071 3.52% 8/15/2024 31 8/15/2024 32 CITY OF ANDOVER Budget Worksheet - 2025 Function: General Government Public Works Building - 41930 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2019 2020 2021 2022 2023 2024 2024 2025 Salaries & Benefits 60110 Salaries - Regular 25,422 22,671 25,116 24,302 26,922 - - - 60210 FICA 1,469 1,284 1,396 1,436 1,564 60220 Medicare 343 302 328 336 366 60310 Health Insurance 5,208 5,051 4,904 5,967 3,912 60320 Dental Insurance - - - - 160 60330 Life Insurance 5 3 3 3 3 60340 Long -Term Disability 66 59 63 59 59 60410 PERA 1,901 1,702 1,860 1,900 1,937 60520 Workers Comp 919 817 915 927 983 - - - 60990 Inter -City Labor Allocation - - - - - 36,785 36,785 38,215 Salaries & Benefits 35,333 31,889 34,585 34,930 35,906 36,785 36,785 38,215 Departmental 61020 Supplies - Operating 926 579 438 23 384 1,800 1,800 1,800 61025 Supplies - Cleaning 1,730 1,454 1,183 2,409 190 2,400 2,400 2,700 61120 R & M Supplies - Building 2,309 3,813 2,484 3,052 5,178 7,500 7,500 7,500 61205 Small & Expend - Small ToolE 376 458 119 188 275 2,500 2,500 2,500 Departmental 5,341 6,304 4,224 5,672 6,027 14,200 14,200 14,500 Operating 62005 Electric 27,048 21,671 17,139 15,952 16,652 30,500 30,500 32,000 62010 Water & Sewer Service 9,841 11,898 14,139 11,782 15,530 16,000 16,000 17,000 62015 Natural Gas 21,324 18,565 22,652 27,548 17,127 30,000 30,000 32,000 62020 Refuse Collection 4,250 4,943 4,367 4,238 2,127 6,500 6,500 6,500 62025 Storm Water Utility Charge 4,639 4,859 4,734 4,969 5,093 5,500 5,500 6,500 62030 Telephone 4,544 4,514 5,271 5,201 8,250 7,400 7,400 8,400 62100 Insurance 6,461 6,461 6,461 7,000 8,000 8,300 8,300 8,548 62200 Rentals 4,588 4,545 4,334 4,461 2,822 5,000 5,000 5,800 62300 Equipment Maintenance Contrac 2,436 1,580 1,250 2,400 3,848 11,300 11,300 11,300 62305 Software Support Contract 1,480 1,542 1,850 1,682 1,791 2,100 2,100 2,100 Operating 86,611 80,578 82,197 85,233 81,240 122,600 122,600 130,148 Professional Services 63010 Contractual Services 30,602 22,697 23,299 23,216 25,958 18,500 18,500 21,900 63105 R & M Labor - Building 29,813 35,150 24,046 24,532 24,009 47,500 47,500 47,500 Professional Services 60,415 57,847 47,345 47,748 49,967 66,000 66,000 69,400 Total 187,700 176,618 168,351 173,583 173,140 239,585 239,585 252,263 12,678 5.29% 8/15/2024 32 CITY OF ANDOVER Budget Worksheet - 2025 Function: General Government Cold Storage Building - 41940 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2019 2020 2021 2022 2023 2024 2024 2025 Departmental 61120 R & M Supplies - Building - - - 94 - 1,250 1,250 1,250 Departmental - - - 94 - 1,250 1,250 1,250 Operating 62005 Electric 291 1,999 1,263 1,302 1,384 3,000 3,000 3,000 62010 Water & Sewer Service - 2,905 5,915 7,242 8,777 9,000 9,000 10,500 62015 Natural Gas 1,764 3,541 2,796 5,233 4,135 8,000 8,000 8,000 62100 Insurance - 126 5,000 4,000 4,200 4,400 4,400 4,532 62300 Equipment Maintenance Contr, 1,000 - 1,100 1,100 1,100 62305 Software Support Contract - 1,100 1,100 1,100 1,100 Operating 2,055 8,571 14,974 18,777 19,596 26,600 26,600 28,232 Professional Services 63010 Contractual Services - 552 844 850 871 2,600 2,600 2,600 63105 R & M Labor - Building - - - - 2,000 2,000 2,000 Professional Services - 552 844 850 871 4,600 4,600 4,600 Total 2,055 9,123 15,818 19,721 20,467 32,450 32,450 34,082 1,632 5.03% 33 CITY OF ANDOVER Budget Worksheet - 2025 Function: General Government Equipment Building - 41950 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2019 2020 2021 2022 2023 2024 2024 2025 Operating 62015 Natural Gas 1,384 1,304 1,378 2,173 1,980 3,000 3,000 3,000 62100 Insurance 317 317 317 317 333 350 350 364 62300 Equipment Maintenance Contrr - - - - - 700 700 700 Operating 1,701 1,621 1,695 2,490 2,313 4,050 4,050 4,064 Professional Services 63010 Contractual Services - - - 796 382 2,250 2,250 2,250 63105 R & M Labor - Building 318 370 1,250 1,250 1,250 Professional Services 1,114 752 3,500 3,500 3,500 Total 1,701 1,621 1,695 3,604 3,065 7,550 7,550 7,564 14 0.19% 8/15/2024 34 CITY OF ANDOVER Budget Worksheet - 2025 Function: General Government City Hall Garage - 41960 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2019 2020 2021 2022 2023 2024 2024 2025 Departmental 61120 R & M Supplies - Building - 45 - 33 500 500 500 Departmental - 45 33 500 500 500 Operating 62005 Electric 259 240 248 252 262 500 500 500 62100 Insurance 524 524 524 524 550 570 570 588 Operating 783 764 772 776 812 1,070 1,070 1,088 Professional Services 63105 R & M Labor - Building 532 125 198 1,245 476 2,050 2,050 2,550 Professional Services 532 125 198 1,245 476 2,050 2,050 2,550 Total 1,315 934 970 2,021 1,321 3,620 3,620 4,138 518 14.31% 8/15/2024 35 8/15/2024 36 CITY OF ANDOVER Budget Worksheet - 2025 Function: General Government Sunshine Park Building - 41970 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2019 2020 2021 2022 2023 2024 2024 2025 Departmental 61020 Supplies - Operating - - - - - 1,000 1,000 1,000 61025 Supplies - Cleaning 108 1,000 1,000 1,000 61120 R & M Supplies - Building 340 21 14 49 7 1,150 1,150 1,180 Departmental 448 21 14 49 7 3,150 3,150 3,180 Operating 62010 Water & Sewer Service 1,136 1,003 1,096 1,132 1,239 1,750 1,750 1,750 62015 Natural Gas 1,255 1,169 1,002 1,693 1,681 2,500 2,500 2,500 62020 Refuse Collection - - - - - 300 300 300 62030 Telephone 489 514 540 538 540 750 750 750 62100 Insurance 557 557 1,560 8,500 8,000 8,300 8,300 8,548 62300 Equipment MaintenanceContn 244 260 410 500 360 1,100 1,100 1,500 Operating 3,681 3,503 4,608 12,363 11,820 14,700 14,700 15,348 Professional Services 63010 Contractual Services 1,860 1,232 1,345 874 797 2,000 2,000 2,000 63105 R & M Labor - Building 833 - 1,309 - 4,825 6,000 6,000 6,000 Professional Services 2,693 1,232 2,654 874 5,622 8,000 8,000 8,000 Total 6,822 4,756 7,276 13,286 17,449 25,850 25,850 26,528 678 2.62% 8/15/2024 36 Function: General Government Account Number Description CITY OF ANDOVER Budget Worksheet - 2025 Andover St N Bldg - 41980 Actual Actual Actual Actual Actual Budget Estimate Requested 2019 2020 2021 2022 2023 2024 2024 2025 37 Departmental 61020 Supplies - Operating 750 750 750 61025 Supplies - Cleaning - - - - 900 900 900 61120 R & M Supplies - Building 138 123 145 408 90 1,200 1,200 1,240 Departmental 138 123 145 408 90 2,850 2,850 2,890 Operating 62015 Natural Gas 1,270 1,123 1,110 2,078 1,876 2,500 2,500 2,500 62020 Refuse Collection - - - - - - - - 62030 Telephone 489 512 540 538 540 750 750 750 62100 Insurance 557 557 1,560 6,000 5,500 5,700 5,700 5,872 62300 Equipment Maintenance Contr 244 260 150 500 491 1,850 1,850 1,850 Operating 2,560 2,452 3,360 9,116 8,407 10,800 10,800 10,972 Professional Services 63010 Contractual Services 1,073 1,550 1,561 2,055 1,408 2,000 2,000 2,100 63105 R & M Labor - Building 3,336 1,284 610 873 5,252 4,500 4,500 5,000 Professional Services 4,409 2,834 2,171 2,928 6,660 6,500 6,500 7,100 Total 7,107 5,409 5,676 12,452 15,157 20,150 20,150 20,962 812 4.03% 37 38 CITY OF ANDOVER Budget Worksheet - 2025 Function: General Government Prairie Knoll Park Bldg - 41990 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2019 2020 2021 2022 2023 2024 2024 2025 Departmental 61025 Supplies - Cleaning 131 - - - - 250 250 250 61120 R & M Supplies - Building 214 44 14 9 7 1,270 1,270 1,290 Departmental 345 44 14 9 7 1,520 1,520 1,540 Operating 62015 Natural Gas 499 425 295 479 484 750 750 950 62020 Refuse Collection - - - - - - - - 62100 Insurance 557 557 1,560 4,500 4,000 4,200 4,200 4,328 62300 Equipment MaintenanceContn 244 260 56 130 160 1,100 1,100 1,100 Operating 1,300 1,242 1,911 5,109 4,644 6,050 6,050 6,378 Professional Services 63105 R & M Labor - Building 1,398 - 607 - 23 2,450 2,450 2,450 Professional Services 1,398 - 607 - 23 2,450 2,450 2,450 Total 3,043 1,286 2,532 5,118 4,674 10,020 10,020 10,368 348 3.47% 38 39 CITY OF ANDOVER Budget Worksheet - 2025 Function: Public Safety Public Safety Rollup Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2019 2020 2021 2022 2023 2024 2024 2025 Salaries & Benefits 60110 Salaries- Regular 596,440 662,418 632,840 676,210 720,577 806,189 806,189 853,183 60120 Salaries- Volunteer Fire Fightc 377,362 396,063 425,176 535,960 514,477 590,854 590,854 623,011 60210 FICA 42,177 44,217 42,084 49,053 47,962 58,020 58,020 61,458 60220 Medicare 13,782 14,992 14,433 17,118 17,663 20,256 20,256 21,404 60310 Health Insurance 71,468 96,801 94,531 99,935 114,988 100,600 100,600 111,000 60320 Dental Insurance 3,469 2,931 3,175 3,857 4,068 4,590 4,590 4,590 60330 Life Insurance 708 372 353 311 313 200 200 200 60340 Long -Term Disability 1,515 1,332 1,425 1,411 1,432 3,632 3,632 3,838 60410 PERA 62,719 50,994 56,468 68,521 76,928 107,508 107,508 113,454 60420 Nationwide Retirement 6,647 25,877 23,632 22,573 33,927 - - - 60520 Workers Comp 73,733 79,070 77,076 86,032 75,954 91,690 91,690 114,618 60540 Relief Association 181,101 249,699 202,747 260,669 249,917 220,000 278,500 290,000 60990 Inter -City Labor Allocatior 59,510 - - 37,326 37,326 37,720 Salaries & Benefits 1,431,121 1,565,256 1,573,940 1,821,650 1,858,206 2,040,865 2,099,365 2,234,476 Departmental 61005 Supplies - General 10,565 11,376 17,170 7,362 5,617 14,450 14,450 15,100 61010 Supplies - Printed Forms - 430 169 - 1,272 1,000 1,000 1,000 61015 Supplies - Training 4,251 3,438 4,694 10,531 3,651 10,000 10,000 11,000 61020 Supplies- Operating 13,224 35,157 61,066 42,561 55,287 38,450 38,450 39,450 61060 Supplies - Fire Prevention/Edo 4,029 1,358 3,830 2,898 3,585 4,500 4,500 5,000 61205 Small & Expend - Small Tools 13,688 5,402 4,728 5,513 - 9,350 9,350 9,800 61210 Small & Expend - Office Equil - - 34,000 - - - - - 61220 Software - - 3,769 1,678 119 - - - 61305 Uniforms 30,388 41,087 44,653 70,669 21,359 55,000 113,454 63,170 61310 Meals / Lodging 6,023 2,842 13,001 14,546 19,901 15,000 15,000 18,000 61315 Continuing Education 24,463 27,515 77,190 86,652 56,950 58,500 58,500 61,900 61320 Annual Dues/ Licenses 6,620 7,281 5,613 3,161 13,058 6,500 6,500 6,500 61325 Subscriptions / Publications 121 49 2,544 2,147 69 3,500 3,500 4,300 61405 Postage 1,144 771 827 1,142 966 1,750 1,750 1,750 61410 Transportation / Mileage 1,247 455 1,607 2,782 3,289 4,250 4,250 4250 Departmental 115,763 137,161 274,861 251,642 185,123 222,250 280,704 241,220 Operating 62005 Electric 720 797 840 840 879 1,000 1,000 1,000 62030 Telephone 4,735 6,945 6,415 6,961 12,226 14,100 14,100 14,100 62100 Insurance 26,506 26,506 26,506 26,506 28,331 29,300 29,300 30,180 62200 Rentals 3,555 3,384 4,655 951 4,813 7,250 7,250 7,250 62205 Central Equipment Services 189,121 180,202 178,976 197,000 215,250 239,640 239,640 253,884 62300 Equipment Maintenance Contr. 8,271 3,321 12,527 8,021 9,496 12,000 12,000 12,000 62305 Software Maintenance Contrac 28,594 32,304 39,009 42,240 30,870 38,080 38,080 43,580 Operating 261,502 253,459 268,928 282,519 301,865 341,370 341,370 361,994 Professional Services 63005 Professional Services 67,495 68,421 100,046 75,824 84,964 59,900 59,900 61,400 63010 Contractual Services 3,209,636 3,133,975 3,298,952 3,273,120 3,367,123 3,778,969 3,773,969 3,975,887 63025 Publishing 295 73 217 121 384 1,500 1,500 1,500 63030 Printing - 656 257 - 4,300 4,300 4,300 63100 R & M Labor- General 5,981 3,889 6,512 225 2,962 15,000 15,000 15,000 Professional Services 3,283,407 3,206,358 3,406,383 3,349,547 3,455,433 3,859,669 3,854,669 4,058,087 Capital Outlay 65600 Equipment 8,317 10,000 Capital Outlay 8,317 10,000 Total 5,091,793 5,162,234 5,532,429 5,705,358 5,800,627 6,464,154 6,586,108 6,895,777 431,623 6.68% 39 8/15/2024 40 CITY OF ANDOVER Budget Worksheet - 2025 Function: Public Safety Police Protection - 42100 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2019 2020 2021 2022 2023 2024 2024 2025 Professional Services 63010 Contractual Services 3,183,610 3,114,623 3,287,046 3,261,423 3,347,315 3,739,849 3,739,849 3,932,050 Professional Services 3,183,610 3,114,623 3,287,046 3,261,423 3,347,315 3,739,849 3,739,849 3,932,050 Total 3,183,610 3,114,623 3,287,046 3,261,423 3,347,315 3,739,849 3,739,849 3,932,050 192,201 5.14% 8/15/2024 40 8/15/2024 41 CITY OF ANDOVER Budget Worksheet - 2025 Function: Public Safety Fire Protection - 42200 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2019 2020 2021 2022 2023 2024 2024 2025 Salaries & Benefits 60110 Salaries - Regular 296,020 351,443 350,404 421,020 446,698 461,220 461,220 484,943 60120 Salaries - Volunteer Fire Fighte 377,362 396,063 425,176 535,960 514,477 590,854 590,854 623,011 60210 FICA 24,522 25,968 25,262 34,143 31,812 36,633 36,633 38,627 60220 Medicare 9,653 10,719 10,499 13,630 13,886 15,254 15,254 16,065 60310 Health Insurance 26,557 33,717 36,902 39,195 38,839 41,300 41,300 44,500 60320 Dental Insurance 1,529 1,173 1,117 1,924 2,040 2,550 2,550 2,550 60330 Life Insurance 657 339 317 277 281 100 100 100 60340 Long -Term Disability 728 637 800 815 876 2,735 2,735 2,880 60410 PERA 47,791 36,202 37,775 49,507 57,516 81,635 81,635 85,835 60420 Nationwide Retirement - 19,075 21,326 22,573 23,996 - - - 60520 Workers Comp 62,999 67,969 66,720 76,738 75,770 78,927 78,927 100,994 60540 Relief Association 181,101 249,699 202,747 260,669 249,917 220,000 278,500 290,000 60990 Inter -City Labor Allocation (59,510) 42,614 42,614 44,387 Salaries & Benefits 1,028,919 1,133,494 1,179,045 1,456,451 1,456,108 1,573,822 1,632,322 1,733,892 Departmental 61005 Supplies - General 8,467 7,437 14,133 5,078 3,073 9,400 9,400 10,000 61015 Supplies - Training 4,251 3,438 4,694 10,531 3,651 10,000 10,000 11,000 61020 Supplies - Operating 11,281 32,504 59,474 41,626 54,253 36,200 36,200 37,200 61060 Supplies - Fire Prevention/Educ 4,029 1,358 3,830 2,898 3,585 4,500 4,500 5,000 61205 Small & Expend - Small Tools 13,688 5,402 4,728 5,513 - 9,350 9,350 9,800 61210 Small & Expend - Office Equip - - 34,000 - - - - - 61220 Software - - 3,769 1,678 119 - - - 61305 Uniforms 30,388 41,087 44,653 70,669 21,359 55,000 113,454 63,170 61310 Meals / Lodging 5,874 2,842 11,743 14,546 19,817 14,000 14,000 17,000 61315 Continuing Education 22,038 24,277 73,535 84,322 55,043 50,500 50,500 50,500 61320 Annual Dues / Licenses 6,555 7,011 5,348 3,196 12,217 5,000 5,000 5,000 61325 Subscriptions / Publications 121 49 571 2,107 69 1,500 1,500 1,500 61405 Postage 622 165 285 521 334 500 500 500 61410 Transportation / Mileage 583 842 2,334 2,913 3,250 3,250 3,250 Departmental 107,897 125,570 261,605 245,019 176,433 199,200 257,654 213,920 Operating 62030 Telephone 2,908 4,371 3,910 5,012 10,278 11,100 11,100 11,100 62100 Insurance 24,000 24,000 24,000 24,000 25,200 26,000 26,000 26,780 62200 Rentals 853 600 2,178 130 1,789 2,500 2,500 2,500 62205 Central Equipment Services 176,074 166,503 163,904 180,000 201,600 228,229 228,229 244,480 62300 Equipment Maintenance Contra 1,629 - 1,457 4,146 460 3,000 3,000 3,000 62305 Software Maintenance Contract 23,969 26,304 32,663 31,039 30,970 29,380 29,380 34,880 Operating 229,433 221,778 228,112 244,327 270,297 300,209 300,209 322,740 Professional Services 63005 Professional Services 10,704 14,040 9,025 8,038 11,300 11,300 12,800 63010 Contractual Services 22,179 17,308 8,589 6,836 15,295 29,120 29,120 33,837 63025 Publishing 152 - - - - 1,000 1,000 1,000 63030 Printing - 656 257 - 4,300 4,300 4,300 63100 R & M Labor - General 2,672 6,512 827 1,500 1,500 1,500 Professional Services 25,003 28,012 29,797 16,118 24,160 47,220 47,220 53,437 Capital Outlay 65600 Equipment - 8,317 - 10,000 Capital Outlay - 8,317 10,000 Total 1,391,252 1,508,854 1,706,876 1,961,915 1,926,998 2,120,451 2,247,405 2,323,989 8/15/2024 41 8/15/2024 42 CITY OF ANDOVER Budget Worksheet - 2025 Function: Public Safety Protective Inspection - 42300 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2019 2020 2021 2022 2023 2024 2024 2025 Salaries & Benefits 60110 Salaries - Regular 295,184 305,589 280,391 250,497 268,822 344,969 344,969 368,240 60210 FICA 17,358 17,935 16,695 14,642 15,860 21,387 21,387 22,831 60220 Medicare 4,059 4,200 3,904 3,425 3,709 5,002 5,002 5,339 60310 Health Insurance 44,090 62,029 57,629 59,855 74,787 59,300 59,300 66,500 60320 Dental Insurance 1,914 1,732 2,058 1,906 1,999 2,040 2,040 2,040 60330 Life Insurance 50 32 36 33 31 100 100 100 60340 Long -Term Disability 772 682 625 585 545 897 897 958 60410 PERA 14,538 14,392 18,557 18,664 19,034 25,873 25,873 27,619 60420 Nationwide Retirement 6,647 6,802 2,306 - 9,931 - - - 60520 Workers Comp 10,537 10,908 10,285 9,120 - 12,763 12,763 13,624 60990 Inter -City Labor Allocation - - - -12,925 1( 2,925) 14,832 Salaries & Benefits 395,149 424,301 392,486 358,727 394,718 459,406 459,406 492,419 Departmental 61005 Supplies - General 2,098 3,334 3,037 2,284 2,544 3,700 3,700 3,700 61010 Supplies - Printed Forms - 430 169 - 1,156 1,000 1,000 1,000 61020 Supplies - Operating 1,572 2,550 1,592 832 918 2,100 2,100 2,100 61310 Meals / Lodging 149 - 1,258 - 84 1,000 1,000 1,000 61315 Continuing Education 2,425 2,968 3,655 2,330 1,907 5,500 5,500 5,500 61320 Annual Dues / Licenses 65 270 265 (35) 841 1,500 1,500 1,500 61325 Subscriptions / Publications - - 1,973 40 - - - - 61405 Postage 522 606 542 621 632 1,250 1,250 1,250 61410 Transportation / Mileage 664 455 765 448 376 1,000 1,000 1,000 Departmental 7,495 10,613 13,256 6,520 8,458 17,050 17,050 17,050 Operating 62030 Telephone 1,827 2,574 2,505 1,949 1,948 3,000 3,000 3,000 62100 Insurance 1,622 1,622 1,622 1,622 1,703 1,800 1,800 1,856 62200 Rentals 2,702 2,784 2,477 821 3,024 4,750 4,750 4,750 62205 Central Equipment Services 13,047 13,699 15,072 17,000 13,650 11,411 11,411 9,404 62300 Equipment Maintenance Contn - - - - 900 - - - 62305 Software Maintenance Contrac 4,475 5,800 6,146 11,001 150 8,500 8,500 8,500 Operating 23,673 26,479 27,822 32,393 21,075 29,461 29,461 27,510 Professional Services 63005 Professional Services 67,495 57,717 86,006 66,799 76,926 48,000 48,000 48,000 63025 Publishing 143 73 217 121 384 500 500 500 63100 R & M Labor - General - - 3,500 3,500 3,500 Professional Services 67,638 57,790 86,223 66,920 77,310 52,000 52,000 52,000 Total 493,955 519,183 519,787 464,560 501,561 557,917 557,917 588,979 31,062 5.57% 8/15/2024 42 CITY OF ANDOVER Budget Worksheet - 2025 Function: Public Safety Emergency Mgmt - 42400 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2019 2020 2021 2022 2023 2024 2024 2025 Salaries & Benefits 60110 Salaries - Regular 5,236 5,386 2,045 4,693 5,057 - - - 60210 FICA 297 314 127 268 290 60220 Medicare 70 73 30 63 68 60310 Health Insurance 821 1,055 - 885 1,362 60320 Dental Insurance 26 26 27 29 60330 Life Insurance 1 1 1 1 60340 Long -Term Disability 15 13 - 11 11 60410 PERA 390 400 136 350 378 60420 Nationwide Retirement - - - - - 60520 Workers Comp 197 193 71 174 184 - - - 60990 Inter -City Labor Allocation - - 7,637 7,637 8,165 Salaries & Benefits 7,053 7,461 2,409 6,472 7,380 7,637 7,637 8,165 Departmental 61005 Supplies - General - 605 - - - 1,350 1,350 1,400 61315 Continuing Education 270 2,500 2,500 5,900 61325 Subscriptions / Publications - 2,000 2,000 2,800 Departmental 875 - 51850 5,850 10,100 Operating 62005 Electric 720 797 840 840 879 1,000 1,000 1,000 62100 Insurance 884 884 884 884 1,428 1,500 1,500 1,544 62300 Equipment Maintenance Contr 6,642 3,321 11,070 3,875 8,136 9,000 9,000 9,000 Operating 8,246 5,002 12,794 5,599 10,443 11,500 11,500 11,544 Professional Services 63100 R & M Labor - General 3,309 3,889 225 2,135 10,000 10,000 10,000 Professional Services 3,309 3,889 - 225 2,135 10,000 10,000 10,000 Total 18,608 17,227 15,203 12,296 19,958 34,987 34,987 39,809 4,822 13.78% 8/15/2024 43 CITY OF ANDOVER Budget Worksheet - 2025 Function: Public Safety Animal Control - 42500 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2019 2020 2021 2022 2023 2024 2024 2025 Departmental 61010 Supplies - Printed Forms - - - - 116 - - - 61020 Supplies - Operating 371 103 103 116 150 150 150 Departmental 371 103 103 232 150 150 150 Operating 62305 Software Maintenance Contrac 150 200 200 200 50 200 200 200 Operating 150 200 200 200 50 200 200 200 Professional Services 63005 Professional Services - - - - - 600 600 600 63010 Contractual Services 3,847 2,044 3,317 4,861 4,513 10,000 5,000 10,000 Professional Services 3,847 2,044 3,317 4,861 4,513 10,600 5,600 10,600 Total 4,368 2,347 3,517 5,164 4,795 10,950 5,950 10,950 0.00% 8/15/2024 44 45 CITY OF ANDOVER Budget Worksheet - 2025 Function: Public Works Public Works Rollup Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2019 2020 2021 2022 2023 2024 2024 2025 Salaries & Benefits 60110 Salaries - Regular 1,366,651 1,348,437 1,405,529 1,408,707 1,473,270 1,363,606 1,363,606 1,420,567 60140 Salaries - Council / Commissim 2,630 2,920 3,220 2,490 2,600 7,000 7,000 7,000 60210 FICA 80,177 78,181 82,500 83,410 86,886 84,974 84,974 88,510 60220 Medicare 18,750 18,424 19,295 19,508 20,320 19,874 19,874 20,704 60310 Health Insurance 200,011 214,315 241,479 241,039 324,659 251,100 251,100 293,000 60320 Dental Insurance 8,428 9,098 9,448 9,053 9,115 8,160 8,160 8,160 60330 Life Insurance 282 164 164 160 159 340 340 340 60340 Long-Term Disability 3,328 2,939 3,064 2,868 2,890 3,351 3,351 3,495 60410 PERA 95,200 93,420 98,059 99,784 104,088 102,271 102,271 106,541 60520 Workers Comp 49,377 48,126 50,777 50,490 54,940 50,456 50,456 52,562 60990 Inter-City Labor Allocation (16,423) 300,224 300,224 312,174 Salaries & Benefits 1,824,834 1,799,601 1,913,535 1,917,509 2,078,927 2,191,356 2,191,356 2,313,053 Departmental 61005 Supplies - General 4,904 5,276 5,294 4,217 2,828 4,995 4,995 4,995 61020 Supplies - Operating 68,722 52,899 68,065 68,320 43,110 71,400 71,400 71,400 61025 Supplies - Cleaning 3,535 3,332 2,451 6,563 796 4,000 4,000 4,000 61030 Supplies - Signs 30,560 64,107 5,162 27,142 26,500 40,000 40,000 40,000 61105 R & M Supplies - General 24,451 21,859 12,946 35,357 34,915 42,550 42,550 42,550 61125 R & M Supplies - Streets 208,372 144,724 144,817 195,205 182,645 215,000 215,000 220,000 61130 R & M Supplies - Landscape 34,739 39,133 37,835 36,042 49,893 47,500 47,500 52,500 61205 Small & Expend - Small Tools 4,479 11,134 9,553 2,414 2,607 9,000 9,000 9,000 61220 Software - - - - - 5,000 5,000 5,000 61310 Meals / Lodging 93 54 - 323 144 950 950 950 61315 Continuing Education 2,182 2,412 4,266 1,625 3,361 7,500 7,500 7,500 61320 Annual Dues Licenses 6,304 8,706 11,140 18,289 18,131 12,910 12,910 12,910 61325 Subscriptions / Publications 420 420 455 385 464 - - - 61405 Postage 1,994 2,392 373 398 380 4,200 4,200 4,200 61410 Transportation / Mileage 42 83 - 383 775 775 775 Departmental 390,797 356,531 302,357 396,663 365,774 465,780 465,780 475,780 Operating 62005 Electric 213,896 217,149 235,433 230,103 221,230 258,000 258,000 258,000 62015 Natural Gas 519 424 324 845 633 1,200 1,200 1,200 62010 Water & Sewer Service 49,141 53,444 56,779 59,120 82,969 60,000 60,000 60,000 62020 Refuse Collection 21,939 26,258 23,218 24,671 18,445 26,000 26,000 29,000 62025 Storm Water Utility Charge 1,420 1,546 1,624 1,629 1,658 1,200 1,200 1,200 62030 Telephone 10,266 14,509 12,667 12,395 11,461 13,500 13,500 13,500 62100 Insurance 39,439 39,439 45,704 57,115 61,471 63,450 63,450 65,356 62200 Rentals 16,305 21,721 31,116 22,333 15,247 25,000 25,000 25,000 62205 Central Equipment Services 299,331 351,076 421,368 468,000 561,800 684,686 684,686 709,336 62300 Equipment Maintenance Contra 9,120 2,855 7,142 6,701 6,824 13,500 13,500 13,500 62305 Software Maintenance Contract 3,372 2,500 1,923 5,240 5,025 7,800 7,800 7,800 Operating 664,748 730,921 837,298 888,152 986,763 1,154,336 1,154,336 1,183,892 Professional Services 63005 Professional Services 9,194 16,016 11,175 22,826 16,217 17,600 17,600 17,600 63010 Contractual Services 223,006 216,422 225,865 175,056 219,531 292,600 292,600 295,200 63025 Publishing 7,366 6,439 5,736 5,124 5,195 10,000 10,000 10,000 63100 R & M Labor - General 3,983 13,450 14,912 40,656 12,503 40,900 40,900 45,900 63110 R & M Labor - Streets 2,520 894 250 34,036 1,736 10,000 10,000 10,000 63300 Improvements - Streets 5,880 1,396 10,645 4,528 13,000 13,000 13,000 Professional Services 251,949 254,617 268,583 277,698 259,710 384,100 384,100 391,700 Capital Outlay 65300 Improvements 16,415 172,872 197,853 144,459 123,996 235,000 255,000 235,000 65600 Equipment 3,000 89,642 Capital Outlay 16,415 172,872 200,853 144,459 213,638 235,000 255,000 235,000 Total 3,148,743 3,314,542 3,522,626 3,624,481 3,904,812 4,430,572 4,450,572 4,599,425 168,853 3.81% 45 CITY OF ANDOVER Budget Worksheet - 2025 Function: Public Works Streets & Highways - 43100 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2019 2020 2021 2022 2023 2024 2024 2025 Salaries & Benefits 60110 Salaries - Regular 316,335 370,269 420,181 385,665 422,761 640,140 640,140 686,188 60210 FICA 18,830 21,610 24,918 23,122 23,836 39,687 39,687 42,545 60220 Medicare 4,403 5,125 5,828 5,408 5,574 9,282 9,282 9,952 60310 Health Insurance 46,590 55,334 77,975 73,336 117,033 142,500 142,500 146,500 60320 Dental Insurance 2,225 2,689 3,270 2,700 2,712 4,080 4,080 4,080 60330 Life Insurance 71 51 57 50 52 160 160 160 60340 Long -Term Disability 793 827 1,001 839 862 1,599 1,599 1,718 60410 PERA 21,972 25,302 29,636 28,477 29,784 48,012 48,012 51,464 60520 Workers Comp 11,773 13,462 15,579 14,801 15,156 23,686 23,686 25,389 60990 Inter -City Labor Allocation - (1,730) - - 267,175 267,175 283,124 Salaries & Benefits 422,992 492,939 578,445 534,398 617,770 641,971 641,971 684,872 Departmental 61005 Supplies - General 3,723 3,665 3,831 3,165 2,073 4,595 4,595 4,595 61020 Supplies - Operating 21,980 18,741 26,766 23,323 17,806 22,200 22,200 22,200 61125 R & M Supplies - Streets 44,606 57,377 38,762 35,076 60,429 55,000 55,000 60,000 61205 Small & Expend - Small Tools 2,588 4,345 5,518 1,463 771 4,000 4,000 4,000 61220 Software - - - - - 4,000 4,000 4,000 61310 Meals / Lodging - - - - 23 200 200 200 61315 Continuing Education 745 746 1,850 1,480 1,815 3,000 3,000 3,000 61320 Annual Dues / Licenses 1,314 1,308 1,330 1,248 1,219 2,500 2,500 2,500 61405 Postage 82 84 86 93 89 500 500 500 61410 Transportation / Mileage 100 100 100 Departmental 75,038 86,266 78,143 65,848 84,225 96,095 96,095 101,095 Operating 62030 Telephone 3,112 3,828 3,541 4,980 4,516 5,000 5,000 5,000 62100 Insurance 21,622 21,622 21,622 21,622 22,703 23,400 23,400 24,104 62200 Rentals 7,525 5,225 6,800 6,300 804 9,000 9,000 9,000 62205 Central Equipment Services 57,867 60,760 76,464 90,000 105,000 119,820 119,820 135,168 62305 Software Maintenance - - 1,347 500 1,400 1,400 1,400 Operating 90,126 91,435 108,427 124,249 133,523 158,620 158,620 174,672 Professional Services 63005 Professional Services - - - - 50 100 100 100 63010 Contractual Services 18,894 14,048 27,482 29,799 50,686 74,700 74,700 74,700 63110 R & M Labor - Streets 2,520 894 250 34,036 1,736 10,000 10,000 10,000 63300 Improvements - Streets 5,880 1,396 10,645 4,528 13,000 13,000 13,000 Professional Services 27,294 16,338 38,377 63,835 57,000 97,800 97,800 97,800 Capital Outlay 65600 Equipment 1,000 - 7,024 - - - Capital Outlay - 1,000 7,024 Total 615,450 686,978 804,392 788,330 899,542 994,486 994,486 1,058,439 63,953 6.43% 8/15/2024 46 8/15/2024 47 CITY OF ANDOVER Budget Worksheet - 2025 Function: Public Works Snow & Ice - 43200 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2019 2020 2021 2022 2023 2024 2024 2025 Salaries & Benefits 60110 Salaries - Regular 275,904 148,802 155,213 236,129 233,718 - - - 60210 FICA 16,086 8,077 8,910 13,376 15,294 60220 Medicare 3,762 1,897 2,084 3,128 3,577 60310 Health Insurance 38,545 24,037 28,580 41,807 57,837 60320 Dental Insurance 1,796 858 996 1,546 1,636 60330 Life Insurance 60 18 18 28 28 60340 Long -Term Disability 692 313 348 513 513 60410 PERA 20,436 10,287 11,201 17,081 19,399 60520 Workers Comp 9,167 4,595 4,740 6,260 9,712 - - - 60990 Inter -City Labor Allocation - - 352,662 352,662 372,280 Salaries & Benefits 366,448 198,884 212,090 319,868 341,714 352,662 352,662 372,280 Departmental 61005 Supplies - General 136 86 105 262 79 - - - 61020 Supplies - Operating 4,632 60 5,360 2,041 2,810 4,500 4,500 4,500 61105 R & M Supplies - General 10,683 18,911 1,668 25,357 19,414 21,550 21,550 21,550 61125 R & M Supplies - Streets 163,766 87,347 106,055 160,129 122,216 160,000 160,000 160,000 61320 Annual Dues / Licenses 4,631 6,858 7,636 16,711 13,217 9,300 9,300 9,300 61325 Subscriptions / Publications 420 420 455 385 464 - - - Departmental 184,268 113,682 121,279 204,885 158,200 195,350 195,350 195,350 Operating 62100 Insurance 3,993 3,993 3,993 3,993 4,193 4,400 4,400 4,532 62205 Central Equipment Services 148,938 174,760 201,864 220,000 267,750 348,049 348,049 352,612 Operating 152,931 178,753 205,857 223,993 271,943 352,449 352,449 357,144 Professional Services 63100 R & M General 5,349 1,000 3,650 1,000 1,000 1,000 Professional Services - 5,349 1,000 3,650 1,000 1,000 1,000 Total 703,647 496,668 540,226 752,396 771,857 901,461 901,461 925,774 24,313 2.70% 8/15/2024 47 Function: Public Works Account Number Description CITY OF ANDOVER Budget Worksheet - 2025 Street Signs - 43300 Actual Actual Actual Actual Actual Budget Estimate Requested 2019 2020 2021 2022 2023 2024 2024 2025 8/15/2024 48 Salaries & Benefits 60110 Salaries - Regular 120,079 132,432 133,864 111,551 93,202 87,522 87,522 78,936 60210 FICA 6,995 7,960 8,038 6,884 5,561 5,426 5,426 4,894 60220 Medicare 1,636 1,867 1,880 1,610 1,300 1,269 1,269 1,145 60310 Health Insurance 13,591 17,801 16,856 12,988 15,981 12,000 12,000 26,000 60320 Dental Insurance 722 840 768 646 477 510 510 510 60330 Life Insurance 23 14 13 11 9 20 20 20 60340 Long -Term Disability 297 289 266 213 186 228 228 205 60410 PERA 8,422 9,141 9,118 7,833 6,897 6,564 6,564 5,920 60520 Workers Comp 4,312 4,780 4,958 4,270 3,476 3,238 3,238 2,921 60990 Inter -City Labor Allocation 2,153 - - 39,088 39,088 40,583 Salaries & Benefits 156,077 172,971 175,761 146,006 127,089 155,865 155,865 161,134 Departmental 61005 Supplies - General - - - - - 100 100 100 61020 Supplies - Operating 1,386 4,682 1,430 4,833 1,529 5,000 5,000 5,000 61030 Supplies - Signs 30,560 64,107 5,162 27,142 26,500 40,000 40,000 40,000 61105 R & M Supplies - General 428 530 400 1,854 521 1,000 1,000 1,000 61220 Software - - - - - - - - 61310 Meals / Lodging 54 - 65 500 500 500 61315 Continuing Education 100 - 500 500 500 61320 Annual Dues / Licenses 44 - 330 50 710 710 710 61325 Subscriptions / Publications - - - - 61410 Transportation / Mileage - - 85 50 50 50 Departmental 32,472 69,419 6,992 34,309 28,600 47,860 47,860 47,860 Operating 62030 Telephone 872 994 1,355 975 974 500 500 500 62100 Insurance 235 235 500 500 525 550 550 568 62205 Central Equipment Services 11,583 12,162 10,080 11,000 9,450 11,411 11,411 15,280 62305 Software Maintenance Contrac 1,757 1,500 1,094 1,486 2,224 3,500 3,500 3,500 Operating 14,447 14,891 13,029 13,961 13,173 15,961 15,961 19,848 Professional Services 63100 R & M Labor - General - - 610 1,500 1,500 1,500 Professional Services - 610 1,500 1,500 1,500 Capital Outlay 65600 Equipment 1,000 - Capital Outlay - - 1,000 - - Total 202,996 257,281 196,782 194,276 169,472 221,186 221,186 230,342 9,156 4.14% 8/15/2024 48 CITY OF ANDOVER Budget Worksheet - 2025 Function: Public Works Traffic Signals - 43400 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2019 2020 2021 2022 2023 2024 2024 2025 Operating 62005 Electric 13,319 15,562 16,116 15,880 14,962 18,000 18,000 18,000 62300 Equipment MaintenanceContn 9,120 2,855 7,142 6,701 6,824 13,500 13,500 13,500 Operating 22,439 18,417 23,258 22,581 21,786 31,500 31,500 31,500 Professional Services 63100 R & M Labor - General 3,983 4,628 10,104 5,569 7,685 12,500 12,500 12,500 Professional Services 3,983 4,628 10,104 5,569 7,685 12,500 12,500 12,500 Total 26,422 23,045 33,362 28,150 29,471 44,000 44,000 44,000 0.00% 8/15/2024 49 8/15/2024 50 CITY OF ANDOVER Budget Worksheet - 2025 Function: Public Works Street Lighting - 43500 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2019 2020 2021 2022 2023 2024 2024 2025 Operating 62005 Electric 32,716 34,211 36,533 36,142 29,975 40,000 40,000 40,000 Operating 32,716 34,211 36,533 36,142 29,975 40,000 40,000 40,000 Professional Services 63100 R & M Labor - General - - - - 5,400 5,400 5,400 Professional Services - - 5,400 5,400 5,400 Total 32,716 34,211 36,533 36,142 29,975 45,400 45,400 45,400 0.00% 8/15/2024 50 8/15/2024 51 CITY OF ANDOVER Budget Worksheet - 2025 Function: Public Works Street Lights Billed - 43600 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2019 2020 2021 2022 2023 2024 2024 2025 Operating 62005 Electric 118,093 121,852 125,720 125,616 118,941 145,000 145,000 145,000 Operating 118,093 121,852 125,720 125,616 118,941 145,000 145,000 145,000 Professional Services 63010 Contractual Services 27,511 30,329 31,121 32,412 32,938 37,000 37,000 37,000 Professional Services 27,511 30,329 31,121 32,412 32,938 37,000 37,000 37,000 Total 145,604 152,181 156,841 158,028 151,879 182,000 182,000 182,000 0.00% 8/15/2024 51 8/15/2024 52 CITY OF ANDOVER Budget Worksheet - 2025 Function: Public Works Parks & Recreation - 45000 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2019 2020 2021 2022 2023 2024 2024 2025 Salaries & Benefits 60110 Salaries - Regular 604,206 649,825 636,513 620,591 663,652 603,314 603,314 621,890 60140 Salaries - Council / Commissio 2,630 2,920 3,220 2,490 2,600 7,000 7,000 7,000 60210 FICA 35,262 37,744 37,062 36,744 38,686 37,838 37,838 38,991 60220 Medicare 8,247 8,878 8,668 8,594 9,048 8,850 8,850 9,120 60310 Health Insurance 98,251 113,262 113,942 108,483 126,093 96,600 96,600 120,500 60320 Dental Insurance 3,541 4,525 4,211 3,997 4,096 3,570 3,570 3,570 60330 Life Insurance 123 77 73 68 66 140 140 140 60340 Long -Term Disability 1,489 1,455 1,386 1,250 1,265 1,439 1,439 1,485 60410 PERA 40,683 45,260 43,738 42,353 43,659 45,248 45,248 46,641 60520 Workers Comp 22,287 23,610 23,300 23,130 24,451 22,325 22,325 23,011 60990 Inter -City Labor Allocatior (7,051) 124,231 124,231 127,795 Salaries & Benefits 816,719 880,505 872,113 847,700 913,616 950,555 950,555 1,000,143 Departmental 61005 Supplies - General 798 1,398 940 606 502 - - - 61020 Supplies - Operating 36,322 29,275 33,464 36,118 20,940 36,700 36,700 36,700 61025 Supplies - Cleaning 3,535 3,332 2,451 6,563 796 4,000 4,000 4,000 61105 R & M Supplies - General 13,340 2,418 10,878 8,146 14,980 20,000 20,000 20,000 61130 R & M Supplies- Landscape 34,679 38,878 37,835 36,042 49,450 45,000 45,000 50,000 61205 Small & Expend - Small Tool; 1,891 6,789 4,035 951 1,836 5,000 5,000 5,000 61220 Software - - - - - 1,000 1,000 1,000 61310 Meals / Lodging - 54 - 142 - 100 100 100 61315 Continuing Education 1,437 1,566 2,416 145 1,231 3,000 3,000 3,000 61320 Annual Dues / Licenses 315 540 2,174 - 3,645 400 400 400 61405 Postage 151 203 181 190 186 700 700 700 61410 Transportation / Mileage 83 298 200 200 200 Departmental 92,468 84,536 94,374 89,201 93,566 116,100 116,100 121,100 Operating 62005 Electric 49,299 45,050 56,578 51,799 56,687 55,000 55,000 55,000 62010 Water & Sewer Service 49,141 53,444 56,779 59,120 82,969 60,000 60,000 60,000 62015 Natural Gas 519 424 324 845 633 1,200 1,200 1,200 62020 Refuse Collection 9,669 11,581 9,940 11,772 12,949 11,000 11,000 14,000 62025 Storm Water Utility Charge 1,420 1,546 1,624 1,629 1,658 1,200 1,200 1,200 62030 Telephone 6,282 9,687 7,771 6,440 5,971 8,000 8,000 8,000 62100 Insurance 13,589 13,589 18,589 30,000 33,000 34,000 34,000 35,020 62200 Rentals 8,780 16,496 24,316 16,033 14,443 16,000 16,000 16,000 62205 Central Equipment Services 79,292 101,660 131,048 145,000 178,500 202,553 202,553 203,340 62305 Software Maintenance Contract 1,615 1,000 829 2,407 2,301 2,900 2,900 2,900 Operating 219,606 254,477 307,798 325,045 389,111 391,853 391,853 396,660 Professional Services 63005 Professional Services 6,055 7,599 4,128 9,244 5,712 14,000 14,000 14,000 63010 Contractual Services 29,239 22,771 24,071 34,974 52,780 51,900 51,900 54,500 63100 R & M Labor - General 3,473 3,808 31,437 4,208 20,000 20,000 25,000 Professional Services 35,294 33,843 32,007 75,655 62,700 85,900 85,900 93,500 Capital Outlay 65300 Improvements 16,415 172,872 197,853 144,459 123,996 235,000 255,000 235,000 65600 Equipment - - 1,000 - 82,618 - Capital Outlay 16,415 172,872 198,853 144,459 206,614 235,000 255,000 235,000 Total 1,180,502 1,426,233 1,505,145 1,482,060 1,665,607 1,779,408 1,799,408 1,846,403 66,995 3.77% 8/15/2024 52 CITY OF ANDOVER Budget Worksheet - 2025 Function: Public Works Natural Resource Preservation - 45500 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2019 2020 2021 2022 2023 2024 2024 2025 Salaries & Benefits 60110 Salaries - Regular - - - - - - - - 60210 FICA 60220 Medicare 60310 Health Insurance 18 18 18 23 60320 Dental Insurance 60330 Life Insurance 60340 Long -Term Disability 60410 PERA 60520 Workers Comp - - - 60990 Inter -City Labor Allocation - 2,022 2,022 2,102 Salaries & Benefits 18 18 18 23 2,022 2,022 2,102 Departmental 61020 Supplies - Operating 112 25 25 25 - - - 61105 R & M Supplies - General - - - - - 61130 R & M Supplies - Landscape 60 255 443 2,500 2,500 2,500 Departmental 60 367 25 25 468 2,500 2,500 2,500 Operating 62200 Rentals - - - - - - - - 62205 Central Equipment Services 970 1,019 1,124 1,000 Operating 970 1,019 1,124 1,000 Professional Services 63005 Professional Services 3,139 8,417 7,047 13,582 10,455 3,500 3,500 3,500 63010 Contractual Services 12,644 - 1,524 1,325 - 9,000 9,000 9,000 63100 R & M Labor - General - - Professional Services 15,783 8,417 8,571 14,907 10,455 12,500 12,500 12,500 Total 16,831 9,821 9,738 15,932 10,946 17,022 17,022 17,102 80 0.47% 53 CITY OF ANDOVER Budget Worksheet - 2025 Function: Public Works Recycling - 46000 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2019 2020 2021 2022 2023 2024 2024 2025 Salaries & Benefits 60110 Salaries - Regular 50,127 47,109 59,758 54,771 59,937 32,630 32,630 33,553 60210 FICA 3,004 2,790 3,572 3,284 3,509 2,023 2,023 2,080 60220 Medicare 702 657 835 768 821 473 473 487 60310 Health Insurance 3,016 3,863 4,108 4,425 7,692 - - - 60320 Dental Insurance 144 186 203 164 194 - - - 60330 Life Insurance 5 4 3 3 4 20 20 20 60340 Long -Tenn Disability 57 55 63 53 64 85 85 87 60410 PERA 3,687 3,430 4,366 4,040 4,349 2,447 2,447 2,516 60520 Workers Comp 1,838 1,679 2,200 2,029 2,145 1,207 1,207 1,241 60990 Inter -City Labor Allocation - (5,489) - 49,396 49,396 52,538 Salaries & Benefits 62,580 54,284 75,108 69,537 78,715 88,281 88,281 92,522 Departmental 61005 Supplies- General 247 127 418 184 174 300 300 300 61020 Supplies - Operating 4,402 29 1,020 1,980 - 3,000 3,000 3,000 61310 Meals / Lodging 39 - - 116 121 150 150 150 61315 Continuing Education - - - - 315 1,000 1,000 1,000 61405 Postage 1,761 2,105 106 115 105 3,000 3,000 3,000 61410 Transportation / Mileage 42 - - - - . 425 425 425 Departmental 6,491 2,261 1,544 2,395 715 7,875 7,875 7,875 Operating 62005 Electric 469 474 486 666 665 - - - 62020 Refuse Collection 12,270 14,677 13,278 12,899 5,496 15,000 15,000 15,000 62100 Insurance - - 1,000 1,000 1,050 1,100 1,100 1,132 62205 Central Equipment Services 681 715 788 1,000 1,100 2,853 2,853 2,936 Operating 13,420 15,866 15,552 15,565 8,311 18,953 18,953 19,068 Professional Services 63010 Contractual Services 134,718 149,274 141,667 76,546 83,127 120,000 120,000 120,000 63025 Publishing 7,366 6,439 5,736 5,124 5,195 10,000 10,000 10,000 63100 R & M Labor- General - 500 500 500 Professional Services 142,084 155,713 147,403 81,670 88,322 130,500 130,500 130,500 Total 224,575 228,124 239,607 169,167 176,063 245,609 245,609 249,965 4,356 1.77% 8/15/2024 54 CITY OF ANDOVER Budget Worksheet - 2025 Function: Other OtherRollup Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2019 2020 2021 2022 2023 2024 2024 2025 Professional Services 63900 Miscellaneous 10,965 11,056 13,395 14,858 22,442 30,600 30,600 31,100 63905 Contingency 4,036 1,722 2,714 2,538 994 65,000 65,000 65,000 Professional Services 15,001 12,778 16,109 17,396 23,436 95,600 95,600 96,100 Other Financing Uses 67101 Operating Transfers Out - 1,000,000 750,000 550,000 200,000 Other Financing Uses 1,000,000 750,000 550,000 200,000 - Total 15,001 1,012,778 766,109 567,396 223,436 95,600 95,600 96,100 500 0.52% 55 CITY OF ANDOVER Budget Worksheet - 2025 Function: Other Unallocated - 49100 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2019 2020 2021 2022 2023 2024 2024 2025 Professional Services 63900 Miscellaneous 10,965 11,056 13,395 14,858 22,442 30,600 30,600 31,100 63905 Contingency 4,036 1,722 2,714 2,538 994 65,000 65,000 65,000 Professional Services 15,001 12,778 16,109 17,396 23,436 95,600 95,600 96,100 Other Financing Uses 67101 Operating Transfers Out - 1,000,000 750,000 550,000 200,000 - - - Other Financing Uses 1,000,000 750,000 550,000 200,000 Total 15,001 1,012,778 766,109 567,396 223,436 95,600 95,600 96,100 500 0.52% 8/15/2024 56 t� aaa S ;eaa u9i�'�a�4u3Yu9i g`�� a as 3°00 �sFm�� of t� aaa S ;eaa u9i�'�a�4u3Yu9i g`�� a as 3°00 �sFm�� E � • o Fi 6 y Pi S � �., 8 'a2, ."'. � X IBJ �I IIM s E � � 3 —eg ci o • F NDOVEA_ % C I T Y 1685 CROSSTOWN BOULEVARD N.W. • ANDOVER, MINNESOTA 55304 • (763) 755-5100 FAX (763) 755-8923 • WWW.ANDOVERMN.GOV TO: Mayor and Councilmembers CC: James Dickinson City Administrator FROM: Dana Makinen, Human Resources Manager SUBJECT: Discuss City of Andover Employee's 2025 Compensation DATE: August 27, 2024 INTRODUCTION During the April and June Workshops in 2023, Human Resources discussed employee positions and salaries with the City Council, resulting in market rate increases for some positions and reclassifications of two positions. Further discussion of salaries would continue into 2024. Human Resources has been working on this project and will discuss some of the results. The City of Andover has been efficient in its hiring practices and as growth has occurred, the City has used technology and flexible staffing options to offset the increasing demand for services, without increasing wages at the same rate as other cities. The City of Andover has increased the number of employees in the Public Works Department and in the Fire Department, as the City needs have grown, but at a reasonable rate that should not result in layoffs in the future. The City of Andover also offers employees a lot of flexibility in their schedules and work/life balances (Summer 4-10 scheduling for Public Works, flexible scheduling for City Hall and Fire staff). Positions of special interest for 2025 are Department Head positions and some other positions that didn't receive a market rate increase in 2024. ACTION REQUESTED Receive presentation and provide direction. Respectfully submitted, Dana Makinen Human Resources Manager VC I T Y 0 F NDOVE 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: Preview Proposed 2025 Preliminary Tax Levy DATE: August 27, 2024 INTRODUCTION Each year the City Council is required by state law to approve a preliminary budget and submit a preliminary levy certification to Anoka County Property Records and Taxation Division. Legislation requires the certification to take place by September 30th. DISCUSSION Below is a sample message that will be updated after the August 27th Council workshop 2025 Budget Proposal discussion. This memo and attachments are assuming a 12.75 % gross levy increase proposal that will be presented at the August 27th Council workshop and is subject to change. The 2025 Preliminary Levy certification proposal would be the outcome of the numerous budget workshops held with the Council over the summer. The Preliminary 2025 Budget proposes a total property tax levy of $20,404,084: $12,298,182 (60.28%) operational levy, $4,881,034 (23.92%) debt service levy, and $3,224,868 (15.80%) capital/watershed levy. The 2025 Proposed Property Tax Levy is estimated to increase the current City tax rate by 12.61%. That rate will be applied to the City's growing tax base and will reflect a 12.75% increase in the gross tax levy, the focus of the 2025 Budget and Levy is to address inflationary items, capital replacements, an infusion of funds into the street improvement program, and address staff retention. The Council has the right to reduce or keep constant this levy until the final certification date of December 28, 2024. BUDGET IMPACT This is the first step in establishing the City of Andover property tax levy for 2025. ACTION REQUESTED The Andover City Council is requested to receive a brief presentation, discuss and provide direction to staff on what type of presentation is desired at the September 3rd City Council meeting when staff anticipates requesting the proposed 2025 Preliminary Tax Levy to be set by the City Council. Jim y submitted, : Resolution Adopting the Proposed 2025 Preliminary Property Tax Levy CITY OF ANDOVER COUNTY OF ANOKA STATE OF MINNESOTA RES. NO. A RESOLUTION ADOPTING THE CITY OF ANDOVER 2025 PROPOSED PROPERTY TAX LEVY TO BE CERTIFIED TO THE COUNTY AUDITOR. WHEREAS, the preparation and adoption of operating budgets is recognized as sound financial practice; and WHEREAS, the City of Andover receives significant financial support from its residents through the payment of property taxes; and WHEREAS, the City of Andover has the responsibility to appropriately and efficiently manage the public's funds; and WHEREAS, Minnesota State Law requires the City to certify to the County Auditor a proposed tax levy prior to September 30, 2024. NOW, THEREFORE, BE IT RESOLVED that the City Council of the City of Andover hereby adopts the proposed 2025 property tax levy totaling $20,404,084 as listed on Attachment A. Adopted by the City of Andover this 3rd day of September 2024. ATTEST: Michelle Hartner — City Clerk CITY OF ANDOVER Sheri Bukkila - Mayor STATE OF MINNESOTA) COUNTY OF ANOKA CITY OF ANDOVER I, the undersigned, being the duly qualified and acting City Clerk of the City of Andover, Minnesota, do hereby certify that I have carefully compared the attached Resolution No. adopting the 2025 Proposed Property Tax Levy with the original record thereof preserved in my office, and have found the same to be true and correct transcript of the whole thereof. IN TESTIMONY WHEREOF, I have hereunto subscribed my hand this 3rd day of September 2024. Michelle Hartner — City Clerk CITY OF ANDOVER, MINNESOTA Attachment A 2025 Property Tax Levy Proposed 2025 Levy General Fund Levy General Operations $ 11,908,182 Community Center Operations 155,000 Park Repair/Replacement Items 235,000 Total General Fund 12,298,182 Debt Service Funds Levy 300,000 2012C Taxable G.O. Abatement Bonds 969,824 2018A G.O. Capital Improvement Plan Bonds 617,257 2019A Taxable G.O. Abatement Bonds 1,018,100 2021A G.O. Equipment Certificate 176,715 2021A G.O. Street Reconstruction Bonds 649,138 2024 G.O. Equipment Certificate 450,000 2025 G.O. Street Reconstruction Bonds 1,000,000 Total Debt Service 4,881,034 Other Levies Capital Projects Levy Capital Equipment/Project 300,000 Facility Maintenance Reserve 355,000 Parks Projects 15,000 Road & Bridge 2,400,000 Pedestrian Trail Maintenance 114,868 Lower Rum River Watershed 40,000 Total Other 3,224,868 Gross City Levy $ 20,404,084