The URL can be used to link to this page

Home My WebLink AboutWK - September 4, 2018O 1DVE 1685 CROSSTOWN BOULEVARD N.W.. ANDOVER, MINNESOTA 55304 • (763) 755-5100 FAX (763) 755-8923 . WWW.ANDOVERMN.GOV September 4, 2018 City Council Workshop — Immediately following Regular City Council Meeting. Call to Order 2. 2019 Budget Development Discussion —Administration 3. Preview 2019 Preliminary Tax Levy —Administration 4. Other Business Adjournment 1685 CROSSTOWN BOULEVARD N.W. • ANDOVER, MINNESOTA 55304 . (763) 755-5100 FAX (763) 755-8923 • WWW.ANDOVERMN.GOV TO: FROM: SUBJECT: DATE: Mayor and Councilmembers Jim Dickinson, City Administrator 2019 Budget Development Discussion September 4, 2018 INTRODUCTION City Administration/Finance along with the Department Heads continue to work on the 2019 Annual Operating Budget Development process and are looking to update the City Council on progress and seek direction as the preparation of the 2019 Annual Operating Budget proceeds. In addition, Administration is providing for the Council's reference a General Fund summary and line item budget (pages 12-64). City Administration will review with the Council the bold italics items at the meeting. Also, Administration will review various spreadsheets with the Council using the Smart Board in the conference room. DISCUSSION The following are the 2019 Budget Development guidelines adopted at the April 3`d City Council meeting: 1) A commitment to a City Tax Capacity Rate to meet the needs of the organization and positioning the City for long-term competitiveness using sustainable revenue sources and operational efficiencies. Note: Preliminary Anoka County Assessor taxable market value figures for the City of Andover are reflecting a 5.8% increase in total taxable market value. Refer to attached Pay 2019 Valuation Estimates (nape 8). 2) A fiscal goal that works toward establishing the General Fund balance for working capital at no less than 45% of planned 2019 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 2018 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 recommended by the City's auditor. The 2018 budget exceeded this guideline, also Emergency Fund Balances (approximately 3% of planned General Fund expenditures) are in place to stabilize a situation, not be a complete solution. Staff will review with the Council a 2018 General Fund Fund Balance Analysis at the meeting (nape 9). 3) A commitment to limit the 2019 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. (refer to attached page 10) Note: The adopted 2018 debt levy was 12.88% of the gross tax levy, 2019 is currently proposed at 16.15% of the gross tax levy, the 25% guideline provides reasonable margin to accommodate additional debt next year. Please keep in mind thatfor the 2017 & 2018 budgets, $500,000 & $525,000 respectively of existing debt levy through 2016 was temporarily moved to a Capital Levy to fund planned equipment purchases (rather than issuing debt), that decreased the debt levy percentage of the gross tax levy significantly. The $525,000 is returning to debt levy for the 2019 budget. 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 performed this analysis and has made recommendations to the City Council as part of the 2019-2023 Capital Improvement Plan (CIP) development process. 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 complex set of financial data including growth factors, tax capacity valuations, per capita spending and debt ratios. 6) Continued commitment to strategic planning targeted toward meeting immediate and long- term operational, staffing, infrastructure and facility needs. Note: A Council Community Vision and Organizational Goals and Values document was approved by the City Council. Administration is to assure that direction provided in that document is integrated into various 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: Administration pays special attention to fiscal values, commercial & residential development or redevelopment, collaboration opportunities, service delivery, livability and image of the community. Staffing: Administration has received new full-time staffing requests from the Fire Department, Engineering Department and the Community Center for consideration in the 2019 budget. The Fire Department staffing request focuses on administrative support and community education activities. The Engineering Department request is for a Geographic Information System (GIS) specialist position to focus on mapping solutions. The Community Center request for an Assistant Manager to assist with facility and recreational management. Administration is continuing to review the requests with the respective departments and will make a recommendation on the positions to the Council at a future workshop, but the proposed budget is currently carrying a $50,000 place holder in the General Fund for staffing enhancements. There are also some anticipated retirements and staff vacancies within the next few years; in response Administration/Human Resources will continue to focus on succession planning, utilization of internship opportunities, continued cross -training of staff, and/or possible realignment of resources. 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. Based on the research, there are a few positions where salaries are lagging the market. The 2019 budget proposal is carrying a place holder to address those positions. Overall, pay steps for eligible employees are included in the 2019 budget proposal. A cost of living adjustment (COLA) for non -bargaining employees is currently being evaluated and the 2019 budget proposal has a placeholder to provide a COLA adiustment. The current Public Works Union contract expires December 31, 2019 and the negotiated wage increase of 3% for 2019 is included in the 2019 budget proposal numbers. 2. A midyear review of the employee health plan was conducted with our broker in late July, our group has had some high claims this past year and the broker is predicting a significant increase in the rates. Administration is working with the broker to market our group to other qualified insurance providers and is also considering plan modifications. The 2019 budget proposal is currently carrying a place holder for a significant increase in the rates. The City offers employees an open access high deductible plan ($5, 000 family plan deductible and $2,500 single plan deductible) with a health spending account (HSA), this was implemented originally in 2006 As part of the program, the City pays for 100% of the single health insurance premium and 76% for a family health insurance premium. The City does contribute annually to the employee's HSA. Contractual Departments: The City Attorney agreed to a fee neutral status -quo service level contract for 2018. There have been discussions on the contract for the 2019 budget, but nothing finalized as of yet. 2. The 2018 City of Andover Law Enforcement expenditure budget is $3,053,526 which is offset by a Police State Aid revenue budget of $135,200 and School Liaison revenue budget of $95,529 reflecting a net tax levy impact of $2,822,797. The 2018 Sheriff's contract provides for: a. 80 hours per day of patrol service b. 6 hours per day of service provided by a Community Service Officer c. School Liaison Officers in the middle school and high school d. 2 Patrol Investigators e. 50% of the Crime Watch Program's coordinator position. Per contract, the Sheriff always provides the required number of deputies for all hours contracted by the City. If the 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. Staff has had discussions with the Anoka County Sheriff for a 2019 contract and has received a proposal for a status quo contract. That proposal reflects a 4.26% increase ($130,084) over the 2018 contract. The primary driver of the contract increase is the recent wage settlements with the various bargaining units for the Anoka County Sheriffs Departments. Another driver is the inability to be able to acquire sedan squads, about the only option at this time is the SUV. Council Memberships and Donations/Contributions: The following memberships/contributions are currently included in the proposed 2019 Budget: • North Metro Mayors Association $15,150 (GF) • Metro Cities $ 9,518 (GF) • Mediation Services $ 3,366 (GF) • YMCA — Water Safety Program $ 8,500 (GF) ■ Alexandra House $18,328 ($15,328 GF & $3,000 CG) • Youth First (Program Funding) $14,000 ($12,000 GF & $2,000 CG) • NW Anoka Co. Community Consortium - JPA $10,000 (GF) ■ Teen Center Funding (YMCA) $24,500 ($8,100 GF & $16,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 $ 900 (CG) Some are funded via the General Fund (GF), and those that qualify for charitable gambling funding are done through the Charitable Gambling (CG) Special Revenue Fund. Capital Projects Levy: Capital Projects Levy — The 2018 Capital Projects Levy Budget specifically designates $2,134,014 of the general tax levy to capital projects and equipment needs relating to Capital Project Outlay ($275,000), Capital Equipment Purchases ($525,000) Road and Bridge ($1,169,014), Pedestrian Trail Maintenance ($100,000), Park Projects ($15,000) and Facility Maintenance Reserve ($50,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 and Park Levies increased/decreased according to the City Council budget guidelines (refer to attached page 10 for levy details). • 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 That State of Minnesota funding has largely gone away, down to $0.00 in 2017 and 2018. Future increases in LGA or even the presence of LGA for the City of Andover based on the current State formula are remote. The 2018 City of Andover Road & Bridge levy is $1,169,014. That was a 4.74% increase over 2017. Administration is proposing a 7.34% increase ($85,774) to $1.254,788 for the 2019 budget. The 2018 City ofAndover Pedestrian Trail Maintenance levy was increased significantly from $63,075 in 2017 to $100,000 for 2018, a 58.54% increase in funding. Administration is proposing a 2% increase ($2,000) to $102,000) for the 2019 budget. • Park Improvements 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 leviedfor 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, and the Parks Project levy remained at $15,000. Administration/Finance has evaluated these levy items throughout the CIP process and is not proposing any adjustment to these levies for the 2019 budget. • 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 2018 levy is $275,000, Administration is recommending the same $275,000 for the 2019 budget. • Equipment/Projects This was a reassigned levy in 2017 to provide for the 2017 equipment purchases. Administration/Finance proposed a straight $500,000 Capital Equipment Purchases Levy for the 2017 equipment purchases rather than through debt service levy and an equipment bond. This process continued through 2018 but increased the levy by $25,000 to $525,000. In 2019, this levy is turned back to debt service levy for the City Campus Master Plan implementation. • Facility Maintenance Reserve 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 is anticipated to continue. Administration/Finance after evaluating this levy throughout the CIP process is recommending a $5.000 increase in this levy to $55.000 to address maintenance repairs for the 2019 budget. In addition. Administration is proposing an additional $300,000 levy to address significant deferred maintenance items that have been identiTed for buildings (Public Works & Community Center) being evaluated as potential expansion proiects within the City Campus Master Plan. This levy could stay as a straight Capital Improvement Levv or could be converted to a Debt Service Levy based on market conditions at the time of the proiect or paired with an expansion project. 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. (Staffalong with Ehlers & Associates have completed reviews to see if any refinancing opportunities are available at this time, there are none. Finance will continue to monitor refunding opportunities, as markets can move quickly, and calculate potential savings for issues that may meet parameters which may generate savings.) The proposed 2019 Debt Service levy is as follows: • 2010A G.O.Open Space Referendum $ 183,989 2012C Taxable G.O. Abatement Bonds $ 969,378 • 2014A G.O. Equipment Certificates $ 294,525 • 2016A G.O. Equipment Certificates $ 142,837 • (New) 2019 Capital Improvement Bonds $ 525,000 Total $2,115,729 It should be noted that the levy is offset significantly by a $635,000 YMCA annual rental payment for the Community Center bonds (2012C Taxable G.O. Abatement Bonds). Staff will review with the Council at the meeting the City of Andover Long Range Debt Service Levy Summary (page 11). The 2019 proposed levy has reassigned the $525.000 Capital Proiects Levy back to Debt Service Levy for the City Campus Master Plan implementation. ACTION REQUESTED The Council is requested to receive a presentation and provide direction to staff. ed, CITY OF ANDOVER Pay 2019 Valuation Estimates t -E Taxable Market Value % Change Tax Capacity Value % Change Pay 2015 Pay 2016 2,539,686,867 Pay 2017 $ Pay 2018 Pay 2016 Estimate Pay 2019 2,636,599,713 3.82% Taxable Tax Taxable Tax Taxable Tax Taxable Tax 31,287,043 12.06% Market Capacity Market Capacity Market Capacity Market Capacity Value Value Value Value Value Value Value Value Andover Valuation Totals $ 2,539,686,867 $ 26,847,273 $ 2,636,599,713 $ 27,920,178 $ 2,959,411,470 $ 31,287,043 $ 3,131,174,122 $ 32,538,525 Captured Tax Increment (248,327) (91,996) (94,415) (94,542) Fiscal Disparity Contribution (1,055,284) (1,124,211) (1,184,724) (1,269,526) Local Tax Rate Value 25,543,662 26,703,971 30,007,904 31,174,457 Fiscal Disparity Distribution 4,264,789 4,516,466 4,807,372 5,151,580 t -E Taxable Market Value % Change Tax Capacity Value % Change Pay 2015 $ 2,539,686,867 Pay 2015 $ 26,847,273 Pay 2016 $ 2,636,599,713 3.82% Pay 2016 $ 27,920,178 4.00% Pay 2017 $ 2,959,411,470 12.24% Pay 2017 $ 31,287,043 12.06% Pay 2018 $ 3,131,174,122 5.80% Pay 2018 $ 32,538,525 4.00% Taxable Market Values $3,500,000,000 $3,000,000,000 $2,500,000,000 $2,000,000,000 $1,500,000,000 $1,000,000,000 $500,000,000 $0 Pay 2015 Pay 2016 Pay 2017 Pay 2018 Tax Capacity Values $35,000,000 $30,000,000 �r--r■ $25,000,000 �s $20,000,000 $15,000,000 $10,000,000 $5,000,000 $0 Pay 2015 Pay 2016 Pay 2017 Pay 2018 City of Andover General Fund 2018 Fund Balance Analysis Round 1 Actual December 31, 2017 $ 7,789,616 2018 Estimated Fund Balance Increase (Decrease) (78,949) Projected December 31, 2018 7,710,667 Less: Snow Emergency (90,000) Public Safety (90,000) Facility Management (90,000) Information Technology (90,000) 2019 Budgeted Use of Fund Balance (326,450) ** Economic Development (300,000) Fiscal Disparities Flunctuation (300,000) Prepaids / Inventories (117,253) Working Cash Flow (5,870,801) Estimated Balance Available for Adjustments 2018 Working Cash Flow Designation Calculation: 2019 Requested Expenditure - Preliminary Estimate $11,741,602 % of 2019 General Fund Expenditures 50.000% $ 5,870,801 M J CD City of Andover, Minnesota Property Tax Levy Other Levies Capital Projects Levy Capital Equipmendproject Certified Certified Certified Certified Certified Requested 2.10% $ Change 0.00% Capital Equipment Purchases 2014 2015 2016 2017 2018 2019 %of Total $ $ % General Fund Levy - - - - 50,000 355,000 2.71% $ 305,000 610.00% General Operations $ 7,435,891 $ 7,630,892 $ 7,947,528 $ 8,254,354 $ 8,543,256 $ 8,845,970 67.51% $ 302,714 3.54% Perko RepairlReplacement Items 967,197 987,197 90,000 90,000 100,000 100,000 0.76% $ 85,774 0.00% Total General Fund 7,435.891 7,630,892 8,037,528 8,344,354 8,643,256 8,945,970 68.27% $ 3D2,714 3.50% Debt Service Fund. Levy $ 8,938.489 $ 8,113,392 $ 9,820,807 $ 10,014,168 $ 1(14{24,617 $ 11,729,840 Atljusletl Tax Capacity Value"(1) 20,616,782 2004 EDA Public Facility Revenue Bonds 181,803 - - 31,174,457 _ _ 18.82% 2010A G.O. Open Space Referendum Bonds 187,283 184,238 186,291 187,84D 188,777 183,989 2012A G.O. Equipment Certificate 140,000 140,000 142,885- Yo Change Tax Capacity Rate"• 43.368% 37.204% 38.447% 37.501% 34.740% 2012BG.O.Cap lmprovRefunding Bonds 561.015 540,120 498,435 - - - 37.374% 37.374% 20120 Taxable G.O. Abatement Bonds 740,965 975,652 977,332 974,418 972,055 969,378 Voter Approved Ret -MV 2014A G.O. Equipment Certificate 260,000 296,055 295,470 295,260 294,945 294,525 2016A G.O. Equipment Certificate - - - 152,529 143,310 142,837 2019 Capital Improvement Bonds 525,000 Total Debt Service 2,071,066 2,136,065 2,100,413 1,610,047 1,599,087 2,115,729 16.15% $ 516,642 32.31% Other Levies Capital Projects Levy Capital Equipmendproject 210,000 250,000 250,000 250,000 275,000 275,000 2.10% $ - 0.00% Capital Equipment Purchases - - - 500,00D 525,000 - 0.00% $ (625,000) .100.00% Facility Maintenance Reserve - - - - 50,000 355,000 2.71% $ 305,000 610.00% Palls Projects 61,500 61,500 15,000 15,000 15,000 15,000 0.11% $ - 0.00% Road &Bridge 967,197 987,197 1089,146 1,116,079 1,169,014 1,254,788 9.58% $ 85,774 7.34% Pedestrian Trail Maintenance 58,271 58,271 61.838 63,075 100,000 102,000 0.78% $ 2,000 2.00% Lower Rum RlverWatershed 40,000 40,000 40,000 40,000 40,000 40,000 0.31% $ 0.00% Total Other 1,336.968 1,376,968 1,455,984 1,984,154 2,174,014 2,041.788 15.58% $ (132,226) Gross City Levy 10,843,925 11,143,926 11,593,926 11,938,655 12,416,367 13,103,487 100% $ 687,130 6S3% Less Fiscal Dispandes Distribution 1,718,153 1,846,295 1,506,747 1,736,547 1,802,963 1,789,658 Local Tax Rate Levy $ 9,126,772 $ 9,297,630 $ 10,007,170 $ 70,202,008 $ 10,613,394 $ 11,313,829 Less Levy Based on Market Value $ 187,203 $ 184,230 $ 186,291) $ 187,840) $ (1887777) $ 183,989 Net Local Tax Rate Levy $ 8,938.489 $ 8,113,392 $ 9,820,807 $ 10,014,168 $ 1(14{24,617 $ 11,729,840 Atljusletl Tax Capacity Value"(1) 20,616,782 24,496,024 26,543,662 26,703,977 30,007,904 31,174,457 18.82% 4.28% 9.01% 17.48% Change Yo Change Tax Capacity Rate"• 43.368% 37.204% 38.447% 37.501% 34.740% $5.700% 0.960% 2.760% Tax Capacity Rate W/O LRRWSD 43.197% 37.070% 38.314% 37.374% 37.374% Tax Capacity Rate With LRRWSD 43.657% 37.461% 38.702% 37.738% 37.738% Voter Approved Ret -MV 0.00841% 0.00719% 0.00599% 0.00681% 0.00681% "Adjusted Value deferminedbyad/usling for Fisoal Disperi0es and Tax Increment estimates. '** Blended rate due to the City ofAndoverlevying for Lower Rum R'ver Watershed District (1) Adjusted Tax Capacity Value is subject to change. CITY OF ANDOVER Long Range Debt Service Certificates of Indebtedness 2011A G.O. Equipment Certificates 2012A G.O. Equipment Certificates 2014A G.O. Equipment Certificates 2016A G.O. Equipment Certificates 2017 295,260 152,529 2018 294,945 143,310 2019 294,525 142,837 2020 143,373 2021 2022 - 2023 2024 `: EgvrpmeuiPbrclrasesevy __::_'' SOQ.r000 -,. «525;000, -. ,: -t 150000. -: -_ , 2020 Equipment Certificate- 320,000 320,000 320,000 320,000 2022 Equipment Certificate - 1,274,418 1,272,055 1,269,378 1,276,780 1,273,263 175,000 175,000 175,000 2024 Equipment Certificate - (301000) (300,000) (300,000) (300,000) (300,000) (300,000) (300,000) 325,000 Subtotal 947,789 963,255 437,362 463,373 470,000 495,000 495,000 500,000 Capital Improvement Bonds 2,110,047 2,124,087 2,115,729 2,149,352 2,152,341 2,179,628 2,174,745 2,183,650 2004A G.O. Cap Improvement Bonds 9,634 14,040 (8,358) 33,623 2,989 27,287 (4,883) 8,905 2012B G.O. Cap Improvement Ref Bonds 0.46% 0.67% -0.39% 1.59% 0.14% 1.27% -0.22% 0.41% Facility Expansion 525,000 525,000 525;000 710,000 710,000 710,000 525,000 525,000 525,000 710,000 710,000 710,000 1 -+ Referendum Bonds Open Space Referendum Bonds 187,840 188,777 183,989 184,199 184,078 Subtotal 1,135,629 1,152,032 1,146,351 1,172,572 1,179,078 1,205,000 1,205,000 1,210,000 Community Center Bonds 2004 BOA Public Facility Revenue Bonds 2012C G.O. Abatement Bonds 1,274,418 1,272,055 1,269,378 1,276,780 1,273,263 1,274,628 1,269,745 1,273,650 *Transfer from Operations (301000) (300,000) (300,000) (300,000) (300,000) (300,000) (300,000) (300,000) Subtotal 974,418 972,055 969,378 976,780 973,263 974,628 969,745 973,650 2,110,047 2,124,087 2,115,729 2,149,352 2,152,341 2,179,628 2,174,745 2,183,650 9,634 14,040 (8,358) 33,623 2,989 27,287 (4,883) 8,905 0.46% 0.67% -0.39% 1.59% 0.14% 1.27% -0.22% 0.41% CITY OF ANDOVER General Fund Revenue S Expense S ummary EXPENDITURES Actual Actual Actual Actual Actual Budget* Estimate Requested* Budget Change (*) General Government 2013 2014 2015 2016 2017 2018 2018 2019 $ % REVENUES 4,311,340 4,498,920 4,503,332 4,667,326 4,778,336 4,978,056 4,978,056 5,174,777 196,721 3.95% Property Taxes $ 7,376,284 $ 7,476,295 $ 7,634,715 $ 8,217,768 $ 8,332,634 $ 8,721,256 $ 8,721,256 $ 9,062,986 341,730 3.92% License and Permits 536,707 364,430 452,616 525,906 546,378 377,900 427,750 384,900 7,000 1.85% Intergovernmental Revenues 710,071 697,491 749,570 733,953 793,932 766,274 766,274 786,008 19,734 2.58% Charges for Current Services 1,122,460 998,150 804,684 912,220 843,022 746,700 759,950 708,700 (38,000) -5.09% Fines and Forfeits 96,130 94,375 99,304 88,600 75,287 90,250 75,075 75,250 (15,000) -16.62% Interest Income (17,096) 144,876 63,709 68,380 64,751 75,000 75,000 75,000 0 0.00% Miscellaneous Revenue 140,983 150,759 154,239 194,812 178,616 129,300 144,800 134,300 5,000 3.87% Transfers 196,930 196,930 196,930 196,930 196,930 178,558 178,558 188,008 9,450 5.29% TOTAL REVENUES 10162,469 10,123306 10,155,767 11038569 11031550 11,085,238 11148,663 11,415152 329,914 2.96% EXPENDITURES General Government 2,308,882 2,481,927 2,511,970 2,592,649 2,642,223 3,010,679 3,036,404 3,127,692 117,013 3.89% 1 N Public Safety 4,311,340 4,498,920 4,503,332 4,667,326 4,778,336 4,978,056 4,978,056 5,174,777 196,721 3.95% Public Warks 2,759,342 2,819,372 2,817,981 2,966,674 2,854,540 3,206,152 3,183,152 3,318,705 112,553 3.51% Other 210,510 81,185 256,720 283,077 764,875 70,428 30,000 120,428 50,000 70.99% TOTAL EXPENDITURES 9.590.074 9 881 404 10 090,003 10,509,726 11,039,974 11,265 315 11,227,612 11,741,602 476,287 4.23% UNDER OVER BUDGET 572 395 $ 241 902 $ 65 764 $ 528 843 $ (8,424) $ (180,077) $ (78,949) $ 326,450 $ 146 373 8/24/2018 CITY OF ANDOVER General Fund Revenue Budget Worksheet - 2019 Actual Actual Actual Actual Actual Budget* Estimate Requested*1 Change (�) Account Number Description 2013 2014 2015 2016 2017 2018 2018 2019 $ % 41230 -Human Resources Miscellaneous Revenue 41230 58100 Refunds & Reimbursements 1,512 4,167 595 1,994 1,127 500 Miscellaneous Revenue 1,512 4,167 595 1,994 1,127 500 _ Total 1,512 4,167 595 1,994 1,127 500 41300 - City Clerk License & Permits 41300 52100 Liquor -Intoxicating 35,550 30,100 27,255 36,597 41,674 33,000 40,000 40,000 7,000 21.21% 41300 52105 Liquor -Non -Intoxicating 450 375 400 375 300 300 300 300 - 0.00% 41300 52110 Tobacco 3,750 3,000 2,750 3,250 3,000 3,500 3,000 3,500 - 0.00% 41300 52115 Refuse/Recycler Haulers 3,725 3,600 3,875 3,475 3,600 3,500 3,500 3,500 - 0.00% 41300 52120 Peddler 1,450 1,575 1,950 1,950 2,675 1,500 2,000 1,500 - 0.00% 41300 52125 Therapeutic Massage 912 1,000 650 2,006 2,100 600 1,200 600 - 0.00% 41300 52126 Vehicle Sales License 945 840 420 840 1,260 500 1,000 500 - 0.00% License & Permits 46,782 40,490 37,300 48,493 54,609 42,900 51,000 49,900 7,000 16,32% J W Charges For Services 41300 54100 Notary Fees 234 183 186 207 297 100 200 100 - 0.00% 41300 54115 Sale of Copies, Ord, etc. 14 15 14 - 4 50 - 50 - 0.00% 41300 54125 Assessment Searches 5,925 2,125 2,300 1,620 3,225 2,000 2,500 2,000 - 0.00% 41300 54145 Parry Permits 155 130 120 120 150 100 100 100 - 0.00% 41300 54155 Recording Fees 800 800 800 700 700 500 700 500 - 0.00% Charges For Services 7,128 3,253 3,420 2,647 4,376 2,750 3,500 2,750 - 0.00°D Fines 41300 56100 Court Fines 95,255 93,700 97,529 88,525 75,212 90,000 75,000 75,000 (15,000) -16.67% 41300 56200 False Alarm Fines 875 675 1,775 75 75 250 75 250 - 0.00% Fines 96,130 94,375 99,304 88,600 75,287 90,250 75,075 75,250 (15,000) -16.62% Miscellaneous Revenue 41300 58175 Contributions 1,015 1,272 1,341 1,738 1,889 1,000 1,000 1,000 - 0.00% Miscellaneous Revenue 1,015 1,272 1,341 1,738 1,889 1,000 1,000 1,000 - 0.00% Total 151,055 139,390 141,365 1412478 136,161 136,900 130575 128,900 (8,000) -5.84% 41310-Rlections Charges For Services 41310 54175 Council Filing Fee 30 50 50 50 50 - 0.00% Charges For Services 30 50 50 50 50 - 0.00% Miscellaneous Revenue 8/24/2018 CITY OF ANDOVER General Fund Revenue Budget Worksheet - 2019 Miscellaneous Revenue License & Permits Actual Actual Actual Actual Actual Budget* Estimate Requested* Change(*) Account Number _ Description 2013 2014 2015 2016 2017 2018 2018 2019 $ % 41310 58100 Refunds & Reimbursements 26,386 - _ 25,000 25,000 5,000 25.00% Total - #DIV/Oi 161,321 61,829 Miscellaneous Revenue - 55,250 - 60,250 5,000 9.05% 41420 - Information Services 300 - #DIV/01 - 0.00% 41500 Total Lot Splits 30 410 50 60 50 50 50 - 0.00% - 0.00% 41400 -Finance 52150 Signs 5,048 2,426 3,546 4,490 3,623 3,500 3,500 3,500 - 0.00% Charges For Services 52155 Vacation of Easement 375 625 500 750 125 500 500 41400 54165 Bad Check Fee 150 120 60 120 30 150 150 150 - 0.00% 41400 54285 Finance Department Fees 151,602 132,084 34,118 41,400 80,683 35,000 35,000 35,000 - 0.00% 41400 54320 Finance Charge 1,971 494 555 616 219 100 100 100 - 0.00% 1,000 - Charges For Services 153,723 132,698 - 34,733 42,136 80,932 35,250 35,250 35,250 - 0.00% Miscellaneous Revenue License & Permits 41420 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 41400 58100 Refunds & Reimbursements 28,407 28,623 27,096 26,386 28,543 20,000 25,000 25,000 5,000 25.00% Miscellaneous Revenue 28,407 28,623 27,096 26,386 281543 20,000 25,000 25,000 5,000 25.00% Total 182,130 161,321 61,829 68,522 109,475 55,250 60,250 60,250 5,000 9.05% 41420 - Information Services 300 300 - 0.00% 41500 52145 Lot Splits 330 410 410 60 Miscellaneous Revenue License & Permits 41420 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-Plnnnin &Zonin - - - License & Permits 41500 52130 Rezoning 165 675 - - - 500 500 500 - 0.00% 41500 52135 Conditional Use 2,150 1,100 400 - 550 - - - - #DIV/O 41500 52140 Variance 300 150 125 - 875 300 300 300 - 0.00% 41500 52145 Lot Splits 330 410 410 60 920 300 300 300 - 0.00% 41500 52150 Signs 5,048 2,426 3,546 4,490 3,623 3,500 3,500 3,500 - 0.00% 41500 52155 Vacation of Easement 375 625 500 750 125 500 500 500 - 0.00% 41500 52260 Camp Plan Amendment - - 500 500 - 500 500 500 - 0.00% 41500 52270 Temporary Structure - 200 200 200 100 250 250 250 - 41500 52275 Interim Use 1,050 2,100 1,400 350 1,000 1,000 1,000 - License &Permits 8,368 6,636 7,781 7,400 6,543 6,850 6,850 6,850 - 0.0000/ Intergovernmental Revenue 41600 53490 Other Grants 3,836 Intergovernmental Revenue - 3,836 Charges For Services 8/24/2018 CITY OF ANDOVER General Fund Revenue Budget W orlcebeet - 2019 Actual Actual Actual Actual Actual Budget* Estimate Requested" Change(* Account Number Description 2013 2014 2015 2016 2017 2018 2018 2019 $ 41500 54105 Plat Fees 1,350 3,350 2,000 2,150 2,550 1,000 1,000 1,000 - 0.00% 41500 54130 Meeting Notification Signs 300 390 420 180 360 350 350 350 - 0.00% 41500 54280 Flood/ Zone Search Letter 25 100 150 50 100 - - - - #DN/01 41500 54290 Planning Department Fees 3,527 6,130 3,517 4,494 1,881 3,500 3,500 3,500 - 0.00% Charges For Services 5,202 9,970 6,087 6,874 4,891 4,850 4,850 4,850 - 0.00% Miscellaneous Revenue 41500 58100 Refunds & Reimbursements 88 577 - #DIV/0! Miscellaneous Revenue 88 577 - #DIV/01 Total 13,658 16,606 13,868 14,851 15,270 11,700 11,700 11,700 - 0.00% 41600 - Engineering License & Permits 41600 52250 Curb Cut 50 100 50 150 100 - - - - #DN/01 41600 52265 Fencing/ Retaining Wall 1,650 2,100 2,250 2,250 2,220 1,750 1,750 1,750 - 0.00% License & Permits 1,700 2,200 2,300 2,400 25320 1,750 1,750 1,750 - 0.00% -` Intergovernmental Revenue Cn41600 53490 Other Grants 6,062 2,227 - #DIV/01 Intergovernmental Revenue 6,062 2,227 - #DIV/01 Charges For Services 41600 54180 Escrow Inspection Fee 2,000 1,100 900 1,141 1,850 750 750 750 - 0.00% 41600 54185 Site Plan Review -Trees 1,170 520 455 715 - - - - - #DIV/0! 41600 54200 Engineer Fees - PW Director 29,301 31,207 27,772 23,479 19,288 22,000 20,000 22,000 - 0.00% 41600 54205 Engineer Fees - Asst PW Direc 14,332 18,346 10,658 10,654 6,781 7,500 7,000 7,500 - 0.00% 41600 54210 Engineer Fees - Asst Engineer 104,075 96,597 85,157 87,821 83,228 80,000 78,000 80,000 - 0.00% 41600 54215 Engineer Fees - Tech IV 283,144 252,665 168,632 205,751 208,320 200,000 192,000 200,000 - 0.00% 41600 54220 Engineer Fees -Natural Res Te 3,303 1,414 1,138 2,025 2,043 2,000 2,000 2,000 - 0.00% 41600 54225 Engineer Fees - Secretary 10,080 11,375 11,391 10,395 11,812 10,000 10,000 10,000 - 0.00% 41600 54230 Engineer Fees - Intern 7,536 3,264 5,261 4,147 - 4,000 4,000 4,000 - 0.00% 41600 54235 Engineer Fees - Mileage 5,070 4,081 3,361 3,525 2,360 3,000 35000 3,000 - 0.00% 41600 54295 Grading Inspection Fee 3,747 1,844 2,943 3,663 5,503 2,000 2,000 2,000 - 0.00% 41600 54305 Administrative Fees 100 - 100 400 100. - - - - #DIV/01 41600 54335 Sid Plans 570 490 1,550 890 750 750 750 - 0.00% Charges For Services 463,858 422,983 318,258 355,266 342,175 332,000 319,500 332,000 - 0.00% Miscellaneous Revenue 41600 58100 Refunds & Reimbursements 1,200 100 801 - #DN/0! Miscellaneous Revenue 1,200 100 801 - #DIV/0! Total 466,758 4255283 320,558 363,728 347,523 333,750 321,250 333,750 - 0.00% 41975 -Sunshine Park Concessions 8/24/2018 CITY OF ANDOVER General Fund Revenue Budget Worksheet - 2019 Actual Actual Actual Actual Actual Budget* Estimate Requested* Change(•) Account Number Description 2013 2014 2015 2016 2017 2018 2018 2019 $ % Charges For Services 41975 55540 Concessions 47,460 51,208 43,318 43,361 - 4DIV/0! Charges For Services 47,460 51,208 43,318 43,361 - #DN/0! Total 47,460 51,208 43,318 43,361 - #DIV/0! 41985 - Andover St N Concessions Charges For Services 41985 55540 Concessions 16,264 14,453 - #DIV/01 Charges For Services 16,264 14,453 - #DIW01 Total 16,264 14,453 - #DIV/01 42100 - Police Protection Intergovernmental Revenue 42100 53370 State Police Aid 124,800 126,880 131,040 133,120 135,200 135,200 135,200 135,200 0.00% 42100 53840 School District Liaison 86,524 88,254 90,020 91.820 93,656 95,529 95,529 97,440 1,911 2.00% Intergovernmental Revenue 211,324 215,134 221,060 224,940 228,856 230,729 230,729 232,640 1,911 0.83% Total 211,324 215,134 221,060 224,940 228,856 230,729 230,729 232,640 1,911 0.83° 42200 - Fire Protection License & Permits 42200 52160 Fire Permit 4,552 1,262 887 2,340 2,933 2,000 2,000 2,000 - 0.00% 42200 52165 Burning Pennit 940 820 941 1,360 1,140 1,100 1,100 1,100 - 0.00% License & Permits 5,492 2,082 1,828 3,700 4,073 3,100 3,100 3,100 - 0.00% Intergovernmental Revenue 42200 53410 State Fire Aid 153,555 151,491 165,332 167,844 167,893 165,000 165,000 165,000 - 0.00% 42200 53490 Other Grants 17,340 35,034 39,592 21,300 17,714 6,000 6,000 6,000 - 0.00% Intergovernmental Revenue 170,895 186,525 204,924 189,144 185,607 171,000 171,000 171,000 - 0.00% Charges For Services 42200 54110 Plan Check Fees 2,540 705 262 1,375 1,773 1,000 1,000 1,000 - 0.00% 42200 54120 Reports 165 180 20 20 40 - - - - 9DN/01 42200 54169 Inspection Fee 450 600 200 450 300 300 300 300 - 0.00% Charges For Services 3,155 1,485 482 1,845 2,113 1,300 1,300 1,300 - 0.00% Miscellaneous Revenue 42200 58100 Refunds & Reimbursements 1,761 1,144 3,132 1,324 1,007 500 500 500 - 0.00% 42200 58125 Donations 150 1,000 100 1,550 - #DN/01 Miscellaneous Revenue 1,911 1,144 4,132 1,424 2,557 500 500 500 - 820.0 % CITY OF ANDOVER General Fund Revenue Budget W orlsheet - 2019 Actual Actual Actual Actual Actual Budget* Estimate Requested* Change(*) Account Number Description 2013 2014 2015 2016 2017 2018 2018 2019 $ Total 181,453 191,236 211,366 196,113 194,350 175,900 175,900 175,900 - 0.00% 42300- Protective Insaection Total 602,518 License & Permits 520,310 735,827 597,760 403,750 469,750 403,750 - 0.00% 42500 -Animal Control 42300 52170 Rental Licenses - Multi 7,350 900 6,450 1,350 7,650 8,500 8,500 8,500 - 0.00% 42300 52171 Rental Licenses - Single 11,900 6,900 7,950 5,250 6,900 - - - - 42300 52175 Contractor 9,525 6,750 5,950 4,820 6,254 5,000 5,000 5,000 - 0.00% 42300 52180 Tree Trimmers 1,150 500 1,250 1,050 1,050 750 750 750 - 0.00% 42300 52185 Building 274,313 180,453 238,113 339,183 281,528 .180,000 210,000 180,000 - 0.00% 42300 52190 Heating 45,062 36,589 37,334 62,647 49,023 36,000 43,000 36,000 - 0.00% 42300 52195 Plumbing 42,447 21,324 27,229 48,022 35,950 21,000 25,000 21,000 - 0.00% 42300 52200 Septic Systems 3,400 2,575 3,875 3,665 3,075 2,500 2,500 2,500 - 0.00% 42300 52205 Septic Pumping 9,870 9,810 17,610 9,780 11,205 10,000 10,000 10,000 - 0.00% 42300 52215 Sanitary Sewer 2,025 2,950 4,350 7,725 6,450 4,000 4,000 4,000 - 0.00% 42300 52217 WaterPemrit Fee - - - 8,400 6,225 5,000 5,000 5,000 - 0.00% 42300 52220 Certificate of Occupancy 1,030 10 150 - - - - - - #DIV/01 42300 52225 Gas Fireplace 7,500 5,550 8,099 6,840 6,973 5,000 5,000 5,000 - 0.00% --42300 52230 Electric Permits 55,131 35,698 41,369 61,901 52,933 43,000 43,000 43,000 - 0.00% J License & Permits 470,703 310,009 399,729 560,633 475216 320,750 361,750 320,750 - 0.00% Charges For Services 42300 54110 Plan Check Fees 124,953 78,865 115,121 172,299 120,953 80,000 105,000 80,000 - 0.00% 42300 54135 Sewer Administration 1,215 15 - 15 - - - - - #DIV/01 42300 54170 Reinspection Fee 5,114 5,018 5,013 2,313 708 3,000 3,000 3,000 - 0.00% 42300 54325 Building Department Fee 533 575 447 477 393 - #DIV/0! Charges For Services 131,815 84,473 120,581 175,104 122,054 83,000 108,000 83,000 - 0.00% Miscellaneous Revenue 42300 58100 Refunds & Reimbursements 90 490 - Miscellaneous Revenue 90 490 - Total 602,518 394,482 520,310 735,827 597,760 403,750 469,750 403,750 - 0.00% 42500 -Animal Control License & Permits 42500 52235 Dog Kennel 500 325 125 100 275 50 300 50 - 0.00% 42500 52240 Dog License 3,162 2,688 3,553 3,180 3,342 2,500 3,000 2,500 - 0.00% License & Permits 3,662 3,013 3,678 3,280 3,617 2,550 3,300 2,550 - 0.00% Total 3,662 3,013 3,678 3,280 3,617 2,550 3,300 2,550 - 0.00% 43100 - Sheets & Hi hwme, 8/24/2018 - CITY OF ANDOVER General Fund Revenue Budget Worksheet - 2019 Actual Actual Actual Actual Actual Budget* Estimate Requested* Chan e(*) Account Number Description 2013 2014 2015 2016 2017 2018 2018 2019 $ % Intergovernmental Revenue 43100 53401 State Highway Aid - Maintenat 208,227 214,474 220,908 227,535 234,361 241,392 241,392 248,364 6,972 2.89% Intergovernmental Revenue 208,227 214,474 220,908 227,535 234,361 241,392 241,392 248,364 6,972 2.89% Charges For Services 43100 54245 Street Department Fees - 551 - #DIV/01 Charges For Services - 551 - #DN/0! Special Assessments 43100 57300 Spec Assess - Interest & Penal 57 169 70 110 446 - - - - NDN/0! 43100 57400 Spec Assess - Certified Bit 1,436 4,855 5,631 2,907 3,683 3,500 3,500 3,500 - 0.00% Special Assessments 1,493 5,024 5,701 3,017 4,129 3,500 3,500 3,500 - 0.00% Miscellaneous Revenue 43100 58100 Refunds & Reimbursements 1,874 391 569 719 5,481 Miscellaneous Revenue 1,874 391 569 719 5,481 - J Total 211,594 220,440 227,178 231,271 243,971 244,892 244,892 251,864 6,972 2.85% 43300 - Street Signs Charges For Services 43300 54190 Sale of Street Signs 14,713 6,251 12,645 9,703 8,164 4,500 4,500 4,500 - 0.00% Charges For Services 14,713 6,251 12,645 9,703 8,164 4,500 4,500 4,500 - 0.00% Miscellaneous Revenue 43300 58100 Refunds & Reimbursements 1,922 3,277 779 1,039 1,825 500 500 500 Miscellaneous Revenue 1,922 3,277 779 1,039 1,825 500 500 500 - Total 16,635 9,528 13,424 10,742 9,989 5,000 5,000 5,000 - 0.00% 43600 - Street Lights - Billed Charges For Services 43600 55410 Street Lights - User Fee 233,723 228,780 231,778 232,466 235,255 238,000 238,000 200,000 (38,000) -15.97% 43600 55440 Street Lights - Penalties 260 - #DN/01 Charges For Services233,983 228,780 231,778 232,466 235,255 238,000 238,000 200,000 (38,000) -15.97% Special Assessments 43600 57300 Spec Assess - Interest & Penal 38 120 23 138 333 - - - - #DIV/0! 43600 57400 Spec Assess - Certified Bit 2,323 4,099 8,922 12,121 12,780 10,000 - #DIV/01 Special Assessments 2361 4,219 8,945 12,259 13,113 10,000 - #DIV/01 Total 236,344 232,999 240,723 244,725 248,368 238,000 248,000 200,000 (38,000) -15.97% 8/24/2018 CITY OF ANDOVER General Fund Revenue Budget Worksheet - 2019 Actual Actual Actual Actual Actual Budget* Estimate Requested* Change (* Account Number Description 2013 2014 •2015 2016 2017 2018 2018 2019 8 % 45000 -Parks & Recreation Intergovernmental Revenue 45000 53420 State DNA _ _ _ - #DN/01 Intergovernmental Revenue - - #DIV/Oi. Charges For Services - 45000 54160 Tournament Fees 2,615 575 - #DIV/0! Charges For Services 2,615 575 - #DIV/01 Miscellaneous Revenue 45000 58100 Refunds & Reimbursements 692 740 1,026 38,336 10,895 500 500 500 - 0.00% 45000 58105 Rent 1,210 1,102 375 151 2 500 500 500 - 0.00% Miscellaneous Revenue 1,902 1,842 1,401 38,487 10,897 1,000 1,000 1,000 - 0.00% Total 4,517 2,417 1,401 38,487 10,897 1,000 1,000 1,000 - 0.00% 46000 -Recycling Intergovernmental Revenue 46000 53360 SCORE Reimbursement 108,286 71,265 69,514 72,718 125,407 113,060 113,060 123,911 10,851 9.60% 46000 53890 Misc Grants 23,071 _ Intergovernmental Revenue 108,286 71,265 92,585 72,718 125,407 113,060 113,060 123,911 10,851 9.60% Charges For Services 46000 54150 Recycling Fees 42,544 41,440 33,382 42,768 43,062 45,000 45,000 45,000 - 0.00% Charges For Services 42,544 41,440 33,382 42,768 43,062 45,000 45,000 45,000 - 0.00% Miseellaneous Revenue 46000 58100 Refunds & Reimbursements 100 - Miscellaneous Revenue 100 - Total 150,830 112,705 125,967 115,586 168,469 158,060 158,060 168,911 10,851 6.87% 49100 - Unnifocaserl General Property Tax 49100 51100 Property Tax - Current 6,003,532 6,194,041 6,293,733 7,040,377 7,129,257 8,643,256 8643,256 8,984,986 341,730 3.95% 49100 51110 Property Tax - Delinquent 114,837 72,773 59,108 66,152 48,051 70,000 70,000 70,000 - 0.00% 49100 51300 Fiscal Disparities 1239,279 1,196,777 1,274,273 1,096,956 1,145,300 - - - - #DIV/Oi. 49100 51400 Penalties & Interest on Taxes 18,636 12,704 7,601 14,283 10,026 8,000 8,000 8,000 - 0.00% General Property Tax 776,284 7,476,295 7,634,715 8,217,768 8,332,634 8,721,256 8,721256 9,062,986 341,730 3.92° Intergovernmental Revenue 49100 53310 Local Govenunent Aid _ _ _ _ - _ _ - - #DIV/01 49100 53340 PERA Aid 10,093 10,093 10,093 10,093 10,093 10,093 10,093 10,093 - 0.00% 8/24/2018 CITY OF ANDOVER General Fund Revenue Budget Worksheet- 2019 General Fund Summary Actual Actual Actual Actual Actual Budget* Estimate Requested -I Change(*) General Property Tax Account Number Description 2013 2014 2015 2016 2017 2018 2018 2019 $ % 49100 53380 Market Value Homestead Cred 1,246 - - 3,461 3,545 - - - - #DIV/0! 49100 53490 Other Grants 793,932 766,274 766,274 786,008 19,734 2.58% 54000 Charges For Services 1,122,460 998,150 804,684 912,220 Intergovernmental Revenue 11,339 10,093 10,093 13,554 13,638 10,093 10,093 10,093 - 0.00% 88,600 75,287 Investment Income 75,075 75,250 (15,000) -16.62% 56900 Investment Income (17,096) 144,876 63,709 68,380 49100 56910 Interest Earned 84,772 120,011 63,528 70,249 86,194 75,000 75,000 75,000 - 0.00% 49100 56920 Valuation Adjustment (101,868) 24,865 181 (1,869) (21,443) 141,516 139,593 179,536 - #DN/0! 131,300 130,800 Investment Income (17,096) 144,876 63,709 68,380 64,751 75,000 75,000 75,000 - 0.0000/ 188,008 9,450 Miscellaneous Revenue 10,162,469 10,123,306 10155,767 11,038,569 ]1031,550 11,085,238 11,148,663 11,415,152 49100 58100 Refunds & Reimbursements - - 125 - - - - - - #DIV/0! 49100 58105 Rent 59,456 62,687 65,702 69,163 69,939 65,000 65,000 65,000 - 0.00% 49100 58140 Maps, etc 42 213 53 19 25 - #DIV/0! Miscellaneous Revenue 59,498 62900 65,880 69,182 69,964 65,000 65,000 65,000 - 0.00% Other Financing Sources 49100 59100 Operating Transfers In 196,930 196,930 196,930 196,930 196,930 178,558 178,558 188,008 9,450 5.2900/ Other Financing Sources 196,930 196,930 196,930 196,930 196,930 178,558 178,558 188,008 9,450 5.2900/ N Total 7,626,9557,891,094 7,971,327 8,565,814 8.677,917 9,049,907 9,049,907 9,401,087 351,180 3.88% O Grand Total 10,162,469 102123,306 10,155,767 112038,569 11,031,550 11,085,238 11,148,663 11,415,152 329,914 2.98% General Fund Summary 51000 General Property Tax 7,376,284 7,476,295 7,634,715 8,217,768 8,332,634 8,721,256 8,721,256 9,062,986 341,730 3.92% 52000 License & Permits 536,707 364,430 452,616 625,906 546,378 377,900 427,750 384,900 7,000 1.85% 53000 Intergovernmental Revenue 710,071 697,491 749,570 733,953 793,932 766,274 766,274 786,008 19,734 2.58% 54000 Charges For Services 1,122,460 998,150 804,684 912,220 843,022 746,700 759,950 708,700 (38,000) -5.09% 56000 Fines 96,130 94,375 99,304 88,600 75,287 90,250 75,075 75,250 (15,000) -16.62% 56900 Investment Income (17,096) 144,876 63,709 68,380 64,751 75,000 75,000 75,000 - 0.00% 57000 Special Assessments 3,854 9,243 14,646 15,276 17,242 3,500 13,500 3,500 - 0.00% 58000 Miscellaneous Revenue 137,129 141,516 139,593 179,536 161,374 125,800 131,300 130,800 5,000 3.97% 59000 Other Financing Sources 196,930 196,930 196,930 196,930 196,930 178,558 178,558 188,008 9,450 5.29% 10,162,469 10,123,306 10155,767 11,038,569 ]1031,550 11,085,238 11,148,663 11,415,152 329914 2.98% 8/24/2018 CITY OF ANDOVER General Fund - Expenditure Budget Summary Totals - By Department Budget Year 2019 OTHER 210,510 81,185 256,720 283,077 764,875 70,428 30,000 120,428 50,000 70.99% Total Other 210,510 81,185 256,720 283,077 764,875 70,428 30,000 120,428 50,000 70.99% GRAND TOTAL S 9,590,074 S 9,881,404 S 10,090,003 S 10,509,726 S 11,039,974 S 11,265,315 $ 11,227,612 S 11,741,602 476,287 4.23% Actual Actual Actual Actual Actual Budget* Estimate Requested" Change (*) 2013 2014 2015 2016 2017 2018 2018 2019 $ % GENERAL GOVERNA27NT Mayor and Council $ 83,595 $ 84,650 $ 85,060 $ 86,989 $ 84,136 $ 91,298 $ 91,298 $ 93,361 2,063 2.26% Administration 147,503 169,218 172,296 187,876 187,514 203,833 203,833 216,567 12,734 .6.25% Newsletter 17,677 20,974 21,042 22,731 25,287 26,000 26,000 26,800 800 3.08% HumanResources 17,907 18,038 15,908 13,404 15,520 28,431 28,156 28,797 366 1.29% Attorney 173,244 177,427 180,313 184,990 188,644 191,360 191,360 197,041 5,681 2.97% City Clerk 108,312 128,861 134,775 148,338 147,450 155,608 155,608 164,293 8,685 5.58% Elections 11,352 41,508 14,497 64,433 17,852 59,781 59,781 65,713 5,932 9.92% Finance 215,215 230,639 240,319 252,563 258,883 278,660 278,660 291912 13252 4.76% Assessing 144,561 145,051 146,315 146,473 147,915 154,000 150,000 154,000 0 0.00% Information Services 135,982 146,984 131,744 151,387 - 149,512 180,597 180,597 188,090 7,493 4.15% Planning & Zoning 349,489 387,308 406,045 414,141 398,780 438,827 438,827 460,749 21,922 .5.00% Engineering 452,788 460,872 464,843 511,074 511,183 553,765 553,765 578,729 24,964 4.51% Facility M ement 451,257 470,397 498,813 408,250 509,547 648,519 678,519 661,640 13,121 2.02% Total General Gov 2,308,882 2,481,927 2,511,970 2,592,649 2,642,223 3,010,679 3,036,404 3,127,692 117,013 3.8951. PUBLICSAPETY N Police Protection 2,740,899 2,818,132 2,918,308 2,936,467 2,962,551 3,053,526 3,053,526 3,183,610 130,084 4.26% -+ Fire Protection 1,126,979 1,264,018 1,165,223 1285,417 1,353,209 1,423,914 1,423914 1,474,623 50,709 3.56% Protective Inspection 423,495 390,908 391,951 424,247 443,712 462,164 462,164 481,374 19,210 4.16% Emergency Management 13,930 21,836 24,352 17,495 16,320 32,502 32,502 29,220 (3,282) -10.10% Animal Control 6,037 4,026 3,498 3,700 2,544 5,950 5,950 5,950 0 0.00% Total Public Safety 4,311,340 4,498,920 4,503,332 4,667,326 4,778,336 4,978,056 4,978,056 5,174,777 196,721 3.95% PUBLIC WORKS Streets and Highways 572,753 600,313 629,724 686,086 597,963 659,943 659,943 705,150 45,207 6.85% Snow and Ice Removal 630,799 637,154 442,078 468,173 449,881 562,706 562,706 588,372 25,666 4.56% Street Signs 162,861 187,935 204,495 167,282 214,540 219,418 219,418 228,431 9,013 4.11% Traffic Signals 26,241 34,901 30,170 27,919 36,151 37,000 37,000 39,500 2,500 6.76% Street Lighting 31,702 32,646 30,664 37,089 27,735 40,400 40,400 40,400 0 0.00% Street Lights - Billed 210,331 203,148 201,500 200,509 144,451 220,500 173,000 180,500 (40,000) -18.14% Park & Recreation 946,545 1,009373 1,151,314 1247,501 1207,360 1,297,395 1318,395 1,353310 55,915 4.31% Natural Resource Preservatim - - - 7,255 6,503 11,574 15,074 14,131 2,557 22.09% OTHER 210,510 81,185 256,720 283,077 764,875 70,428 30,000 120,428 50,000 70.99% Total Other 210,510 81,185 256,720 283,077 764,875 70,428 30,000 120,428 50,000 70.99% GRAND TOTAL S 9,590,074 S 9,881,404 S 10,090,003 S 10,509,726 S 11,039,974 S 11,265,315 $ 11,227,612 S 11,741,602 476,287 4.23% CITY OF ANDOVER Budget Worksheet- 2019 General Fund General Fund Rallup Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2013 2014 2015 2016 2017 2018 2018 2019 Salaries&Benefits 60110 Salanes- Regular 2,655,718 2,803,831 2,T/3,604 2,952,184 2,961,024 3,458,929 3,458,929 3,579,693 60120 Salaries- Volunteer Fire Fighters 223,204 282,019 221,470 247,392 303,471 318,258 318,258 341,100 60130 Salaries-Electionludges 286 27,730 - 44,771 _ - 60140 Salunas- Council/Commission 47,830 48,080 47,500 47,070 45,790 48,700 4$]00 48,700 60210 FICA 158,863 170,958 163,946 181,313 179,191 216,664 216,664 224,566 60220 Medicare 40,976 42,936 41,797 46,701 45,964 54,933 54,933 56,949 60310 Health In.. 325,420 357,706 363,908 398,765 418,192 480,440 480,440 546,200 60320 Dental lnsurana 16,458 16,633 17,025 17,343 16,897 21,680 21,680 21,450 60330 Life Instance 1,107 1,051 955 865 826 900 900 900 60340 Long -Term Disability 6,819 6,794 5,839 6,243 6,466 8,742 8,742 9,044 60410 PERA 195,780 205,411 214,884 235,297 235,298 284,587 284,587 297,093 60420 Nationwide Intranets - 3,222 6,214 7,187 7,590 7,722 2,000 2,000 2,000 60520 Workers Comp 101,810 109,425 113,008 111,729 152,719 174,636 174,636 179,629 60540 ReliafAssociation 203,555 206,491 220,332 222,844 222,893 220,000 220,000 220,000 60990 Inter -City Labor Allocation - - (351,550) (351,550) (365,342) Salaries&Benefits 3,981,128 4,285,309 4,191.455 4,520.107 4,596,453 4,938,919 4,938,919 5,161,982 Deparanenral 61005 Supplies -General 18,425 21,485 26,428 26,078 26,741 31,450 31,300 33,500 61010 Supplies Printed Forms 682 353 665 333 564 1,000 1,000 1,000 61015 Supplies - Training - - 1,089 2,035 8,537 4,000 4,000 6,000 61020 Supplies - Operating 117,986 136,373 88,789 99,034 88,421 108,840 108,840 108,140 61025 SnPPlies-Cleaving 3,471 3,211 4,207 4,074 5,805 10,100 10,100 10,100 61030 SuppliesSips20,394 31,955 29,658 9,706 40,098 37,500 37,500 40,000 61060 Supplies- Fue Pancation/Eduratit - - 1,270 1,027 2,609 4,500 4,500 4,500 61105 R&M Supplies- General 24,411 22,311 21,866 24,471 17,200 23,000 23,000 31,000 61120 R&M Supplies -Building 17,331 10,358 8,998 8,771 9,663 27,500 27,500 22,500 61125 R& M Supplies- Streets 214,062 180,705 130,270 140,294 154,955 165,000 165,000 180,000 61130 R&M Supplies Landscape 25,326 41,006 43,670 38,103 31,207 40,000 40,000 40,000 61205 Sung &Evpend-Snell Tools 11,034 10,410 22,780 17,099 14,271 21,200 21,200 25,200 61210 Small &Ecpand- Office Equipm 2,780 3,547 2,795 3,929 7,300 7,000 7,000 7,000 61220 Sothvare 1,048 7,079 839 6,023 2,405 5,200 5,200 5,200 61225 Technology Upgrades 9,608 24,618 4,613 8,404 13,695 13,000 13,000 13,000 61245 It. fpr Resale 36,285 35,335 24,789 22,484 -_ - 61305 Ilydforms 1,621 17,761 55,879 52,014 37,442 35,000 35,000 40,000 61310 Mcals/Lodging 4,949 6,371 6,605 5,148 10,419 13,420 13,420 14,920 61315 Continuing Education 35,000 31,623 27,489 21,472 31,017 39,755 39,780 46,655 61320 Amual Dues/Licenses 41,679 41,793 43,580 44,149 44,121 63,484 63,684 64,793 61325 Subscriptions/Publications 2,962 2,927 1,388 2,804 2,833 2,479 2,479 2,479 61405 Postage 16,084 19,550 20,409 22,506 22,644 28,910 28,610 29,210 61410 Transportation/Mileage 9.063 8,047 7,102 8,210 9,250 11,085 11.035 11,885 Departmental 614,201 656,818 575,178 571,168 581,197 693,423 693,148 737,082 operating 62005 Electric 331,333 323,302 334,837 329,983 281,947 371,550 324,050 332,050 62010 Water& Sewer Service 58,631 37,357 57,287 48,666 50,356 65,500 65,500 65,500 62015 Natural Das 51,270 65,102 48,268 31,943 38,532 70,950 70,950 70,950 62020 Refuse Collection 20,461 20,823 22,233 26,421 30,598 26,500 26,500 34,800 62025 Storm Water Mty Charge 4,995 4,006 7,011 5,925 6,220 7,050 7,050 7,050 62030 Telephone 48,819 41,685 45,455 45,393 43,423 71,050 71,050 63,900 62100 Insurance 139,731 139,731 144,012 143,923 143,923 144,303 144,303 144,303 62200 Rentals 37,719 30,786 28,833 37,641 29,236 48,000 48,000 50,500 62205 Central Fquipmem Services 505,300 505,300 520,766 52,460 504,866 504,066 504,866 504,866 62300 Equipments Maintenance Contract 32,006 36,804 42,427 42j99 48,732 57,940 57,940 60,040 62305 Software Mairrtenance Contracts 44,971 38,811 47,586 65,472 66,390 90,500 90,500 96,550 Operating 1,275 242 1,243,707 1,298,715 1,298,226 1,244,223 1,458,209 1,410,709 1,430,509 Professional Services 63005 Professional Services 232,859 275,490 220,879 224,002 232,994 255,600 255,100 257,600 63010 Contractual Services 2,928,519 3,044,033 3,157,668 3,176,621 3,238,555 3,344,976 3,350,976 3,476,360 63015 Attorney 173,244 177,427 180,313 184,990 188,644 191,360 191,360 197,041 63025 Publishing 4,941 5,395 11,298 13,098 10,398 14,600 14,600 15,600 63030 Printing 10,877 11,726 10,922 12,009 12,290 13,450 13,450 14,950 63100 R&M Labor- General 36,933 55,479 41,644 23,036 15,674 54,300 54,300 52,00 63105 R& MLabor -Building 63,497 90,419 127,645 67,528 70,774 ]03,950 133,950 129,950 63110 R&MLubor- Streets - - 1,404 400 - 2,000 2,000 4,000 63215 RecordingFee 1,766 690 819 460 544 600 600 600 63300 Improvements - Streets 1,630 3,419 13,983 7,790 8,146 13,000 13,000 13,000 63900 Miscellaneous 42,678 44,459 32,702 21,237 4,822 40,600 18,000 40,600 63905 Contingmq 33,045 37,033 25,378 12,253 10,350 40.328 22,500 90,328 Professional Services 3,529,989 3,695,570 3,824655 3,343.424 3,793,191 4,074,764 4,069836 4,292 029 Capital Outlay 65200 Raiding 54,514 - _ _ 65300 Improvements - - - 126,801 74,910 100,000 115,000 120,000 65600 Equipment Capital Ouday 54,514 - 126,801 74,910 100,000 115,000 120,000 Other Fft arcing Uses 67101 Operating Trmsfas Out 135,000 200,000 250,000 750,000 Other Financing Uses 135,000 200,000 250.000 750,000 Total 9590.074 9,881,404 10,090 003 10,509726 11,039,974 11,265,315 11,227.612 11,741,602 22 CITY OF ANDOVER Budget Worksheet -2019 Function: General Government General Government Rol/up Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2013 2014 2015 2016 2017 2018 2018 2019 60110 60130 60140 60210 60220 60310 60320 60330 60340 60410 60420 60520 60990 Salaries & Benefits Salaries -Regular Salaries - Election Judges Salaries - Council / Commission FICA Medicare Health Insurance Dental Insurance Life Insurance Long -Term Disability PERA Nationwide Retirement Workers Comp Inter -City Labor Allocation Salaries &Benefits 1,298,478 1,427,099 1,436,600 1,589,229 1,623,590 946,978 1,026,717 1,052,692 1,132,287 286 27,730 - 44,771 44,170 44,440 43,780 43,660 57,006 61,217 63,059 69,856 14,531 14,396 14,872 16,606 123,141 133,053 135,822 156,400 5,131 5,392 6,309 6,417 183 175 155 156 2,596 2,433 2,206 2,379 67,812 73,312 78,120 85,661 1,000 1,282 1,293 1,387 35,644 36,952 38,292 29,649 1,186,505 42,450 71,237 16,763 163,586 5,956 169 2,593 89,474 1,440 43,417 1,803,417 45,100 112,289 26,262 234,980 10,298 420 4,592 134,856 2,000 63,577 (669,672) 1,768,119 1,803,417 45,100 112,289 26,262 234,980 10,298 420 4,592 134,856 2,000 63,577 (669,672) 1,768,119 1,870,678 45,100 116,152 27,166 275,200 9,900 420 4,754 140,093 2,000 65,822 (701,893) 1,855,392 23 Departmental 61005 Supplies- General 13,090 15,182 17,162 15,214 13,566 20,000 19,850 19,000 61020 Supplies -Operating (146) (759) 1,994 (382) 856 6,790 6,790 6,790 61025 Supplies- Cleaning 3,216 2,456 3,858 3,288 4,097 7,100 7,100 7,100 61120 R &M Supplies - Building 17,331 10,358 8,998 8,771 9,663 27,500 27,500 22,500 61205 Small & Expend -Small Tools 7,526 5,066 8,532 4,009 2,455 6,200 6,200 6,200 61210 Small&Expend - Office Equipu 2,780 3,547 2,795 3,929 7,300 7,000 7,000 7,000 61220 SORvare 1,048 409 839 863 1,644 1,200 1,200 1,200 61225 Technology Upgrades 9,608 24,618 4,613 8,404 13,695 13,000 13,000 13,000 61245 items for Resale 36,285 35,335 24,789 22,484 - - - - 61310 Meals/Lodging 2,717 3,264 3,759 3,292 3,327 5,570 5,570 5,970 61315 Continuing Education 4,452 7,349 3,465 5,137 4,661 12,755 12,780 14,155 61320 Annual Dues/Licenses 36,512 37,221 38,540 37,573 35,401 50,774 50,974 50,883 61325 Subscriptions Publications 839 750 912 1,084 514 979 979 979 61405 Postage 10,225 16,285 16,442 17,529 17,446 22,410 22,110 23,210 61410 Transportation/Mileage 5,444 5,255 5,419 5,675 5,093 7,310 7,260 8,110 Departmental 150,927 166,336 142,117 136,870 119,718 188,588 188,313 186,097 Operating 62005 Electric 65,019 60,534 70,233 64,583 69,392 79,750 79,750 79,750 62010 Water& Sewer Service 24,783 15,275 20,730 18,387 16,017 27,500 27,500 27,500 62015 Natural Gas 50,884 64,478 47,877 31,589 38,164 69,750 69,750 69,750 62020 Refuse Collection 6,323 10,442 10,129 12,851 12,472 13,800 13,800 14,300 62025 Storm Water Utility Charge 4,077 3,267 5,731 4,839 5,081 5,850 5,850 5,850 62030 Telephone 40,898 29,665 32,298 30,949 29,658 55,550 55,550 46,300 62100 Laurance 76,076 76,076 78,447 78,358 78,358 78,358 78,358 78,358 62200 Rentals 15,219 14,863 7,442 9,965 11,107 14,750 14,750 14,750 62205 Central Equipment Services 16,429 16,429 16,922 16,922 16,414 16,414 16,414 16,414 62300 Equipment Maintenance Connote 11,062 15,899 22,748 22,561 28,520 30,940 30,940 32,940 62305 Software Maintenance Contracts 39,338 34,831 40,480 46,737 43,664 53,600 53,600 59,050 Operating 350,108 341,759 353,037 337,741 348,847 446,262 446,262 444,962 Professional Services 63005 Professional Services 184,642 184,686 183,635 183,963 185,773 202,400 198,400 203,900 63010 Contractual Services 70,802 77,377 71,726 74,838 88,968 80,450 80,450 80,600 63015 Attorney 173,244 177,427 180,313 184,990 188,644 191,360 191,360 197,041 63025 Publishing 3,371 3,799 3,615 2,922 2,778 4,100 4,100 4,100 63030 Printing 10,877 11,726 10,922 12,009 12,290 12,950 12,950 12,950 63100 R& M Labor -General 957 302 181 1,686 - 1,400 1,400 1,600 63105 R & M Labor - Building 63,497 90,419 127,645 67,528 70,774 103,950 133,950 129,950 63215 RectrdingFee 1,766 690 819 460 544 600 600 600 63900 Miscellaneous 213 307 1,360 413 297 10,500 10,500 10,500 Professional Services 509,369 546,733 580,216 528,809 550,068 607,710 633,710 641,241 Capital Outlay 65600 Equipment Capital Outlay Total 2,308,882 2,481,927 1,511,970 2,592,649 2,642,223 3,010,679 3,036,404 3,127,692 23 8/24/2018 24 CITY OF ANDOVER Budget Worksheet - 2019 Function: General Government City Council - 41100 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2013 2014 2015 2016 2017 2018 2018 2019 Salaries & Benefits 60140 Salaries - Council/Commission 39,770 39,710 39,770 41,090 39,500 39,500 39,500 39,500 60210 FICA 2,465 2,461 2,465 2,547 2,448 2,449 2,449 2,449 60220 Medicare 576 576 576 596 573 574 574 574 60410 PERA 1,232 1,232 712 743 712 2,402 2,402 2,965 Salaries & Benefits 44,043 43,979 43,523 44,976 43,233 44,925 44,925 45,488 Departmental 61005 Supplies - General 191 778 436 443 230 400 400 400 61310 Meals/Lodging 1,223 1,600 1,945 1,412 1,481 1,900 1,900 1,900 61315 Continuing Education 260 1,030 675 690 - 1,800 1,800 3,000 61320 Annual Dues / Licenses 26,243 26,363 26,755 27,044 28,468 28,294 28,294 28,294 61410 Transportation/Mileage 555 391 848 1,327 286 1,200 1,200 1,500 Departmental 28,472 30,162 30,659 30,916 30,465 33,594 33,594 35,094 Operating 62030 Telephone 878 767 604 876 876 1,000 1,000 1,000 62100 Insurance 1,727 1,727 1,868 1,779 1,779 1,779 1,779 1,779 Operating 2,605 2,494 2,472 2,655 2,655 2,779 2,779 2,779 Professional Services 63005 Professional Services 8,475 8,015 8,406 8,442 7,783 10,000 10,000 10,000 63025 Publishing - - - - - Professional Services 8,475 8,015 8,406 8,442 7,783 10,000 10,000 10,000 Total 83,595 84,650 85,060 86,989 84,136 91,298 91,298 93,361 8/24/2018 24 8/24/2018 25 CITY OF ANDOVER Budget Worksheet -2019 Function: General Government Administration - 41200 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2013 2014 2015 2016 2017 2018 2018 2019 Salaries & Benefits 60110 Salaries - Regular 96,940 113,485 115,547 128,172 127,743 206,198 206,198 212,818 60210 FICA 5,261 6,099 6,228 6,854 7,038 12,784 12,784 13,195 60220 Medicare 1,314 1,503 1,572 1,815 1,746 2,990 2,990 3,086 60310 Health Insurance 7,889 10,746 11,048 11,893 11,894 14,500 14,500 17,400 60320 Dental Insurance 322 401 410 434 422 542 542 550 60330 Life Insurance 9 11 10 10 10 40 40 40 60340 Long -Term Disability 175 225 196 208 202 536 536 554 60410 PERA 7,052 8,110 8,644 9,945 9,582 15,465 15,465 15,962 60420 Nationwide Retirement 1,000 1,282 1,293 1,387 1,440 2,000 2,000 2,000 60520 Workers Comp 3,814 4,031 4,168 3,323 4,674 7,423 7,423 7,662 60990 Inter -City Labor Allocation - - (85,813) (85,813) (83,868) Salaries&Benefits 123,776 145,893 149,116 164,041 164,751 176,665 176,665 189,399 Departmental 61005 Supplies- General 1,653 1,913 1,742 1,091 1,997 1,800 1,800 1,800 61310 Meals/Lodging 772 646 782 746 607 1,000 1,000 1,000 61315 Continuing Education 1,057 1,213 1,150 1,865 645 2,200 2,200 2,200 61320 Annual Dues /Licenses 769 288 212 513 659 1,850 1,850 1,850 61325 Subscriptions Publications 392 204 220 547 - - - - 61405 Postage 1,035 829 675 448 469 1,100 1,100 1,100 61410 Transportation/Mileage 1,817 1,812 1,800 1,805 1,835 2,000 2,000 2,000 Departmental 7,495 6,905 6,581 7,015 6,212 9,950 9,950 9,950 Operating 62030 Telephone 936 1,049 845 1,066 833 1,500 1,500 1,500 62100 Insurance 15,260 15,260 15,718 15,718 15,718 15,718 15,718 15,718 62300 Equipment Maintenance Contra 36 36 36 36 - - - Operating 16,232 16,345 16,599 16,820 16,551 17,218 17,218 17,218 Professional Services 63005 Professional Services - 75 - - - - - - - 63015 Attorney - - - - - - Professional Services 75 - - Total 147,503 169,218 172,296 187,876 187,514 203,833 203,833. 216,567 8/24/2018 25 5 CrrY OF ANDOVER Budget Worksheet - 2019 Function: General Government Newsletter - 41210 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2013 2014 2015 2016 2017 2018 2018 2019 Departmental 61405 Postage 6,800 10,120 10,120 11,775 12,997 14,000 14,000 14,800 Departmental 6,800 10,120 10,120 11,775 12,997 14,000 14,000 14,800 Professional Services 63030 Printing 10,877 10,854 10,922 10,956 12,290 12,000 12,000 12,000 Professional Services 10,877 10,854 10,922 10,956 12,290 12,000 12,000 12,000 Total 17,677 20,974 21,042 22,731 25,287 26,000 26,000 26,800 8/24/2018 26 N n 27 8/24/2018 CITY OF ANDOVER Budget Worksheet - 2019 Function: General Government Human Resources - 41230 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2013 2014 2015 2016 2017 2018 2018 2019 Salaries & Benefits 60110 Salaries -Regular 6,652 2,367 2,277 3,409 3,474 105,920 105,920 108,941 60210 FICA 126 135 130 204 204 6,567 6,567 6,754 60220 Medicare 29 31 30 48 48 1,536 1,536 1,580 60310 Health Insurance 346 413 445 505 618 14,500 14,500 17,400 60320 Dental Insurance 11 12 16 18 23 542 542 550 60330 Life Insurance 1 1 I 1 1 20 20 20 60340 Long -Term Disability 7 8 7 9 10 275 275 283 60410 PERA 159 171 170 260 260 7,944 7,944 8,171 60520 Workers Comp 2,355 2,390 2,450 89 127 3,813 3,813 3,922 60990 Inter -City Labor Allocation - - - (136,340) (136,340) (142,628) Salaries & Benefits 9,686 5,528 5,526 4,543 4,765 4,777 4,777 4,993 Departmental 61005 Supplies - General 452 1,241 331 773 659 900 750 900 61310 Meals/Lodging 356 370 408 329 409 450 450 450 61315 Continuing Education 360 512 445 674 1,396 975 1,000 975 61320 Annual Dues Licenses 529 844 1,164 1,004 1,063 800 1,000 goo 61325 Subscriptions Publications 417 437 437 479 479 479 479 479 61405 Postage (57) 49 28 29 38 300 - 300 61410 Transportation / Mileage 308 367 486 54 279 400 350 400 Departmental 2,365 3,820 3,299 3,342 4,323 4,304 4,029 4,304 Operating 62305 Software Maintenance Contract 3,519 3,924 3,645 3,735 3,923 4,100 4,100 4,250 Operating 3,519 3,924 3,645 3,735 3,923 4,100 4,100 4,250 Professional Services 63005 Professional Services 2,124 3,481 2,053 1,098 1,903 4,250 4,250 4,250 63025 Publishing - 978 25 273 309 500 500 500 63900 Miscellaneous 213 307 1,360 413 297 10,500 10,500 10,500 Professional Services 2,337 4,766 3,438 1,784 2,509 15,250 15,250 15,250 Total 17,907 18,038 15,908 13,404 15,520 28,431 28,156 28,797 27 8/24/2018 8/24/2018 28 CITY OF ANDOVER Budget Worksheet - 2019 Function: General Government Attorney - 41240 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2013 2014 2015 2016 2017 2018 2018 2019 Professional Services 63015 Attorney 173,244 177,427 180,313 184,990 188,644 191,360 191,360 197,041 Professional Services 173,244 177,427 180,313 184,990 188,644 191,360 191,360 197,041 Total 173,244 177,427 180,313 184,990 188,644 191,360 191,360 197,041 8/24/2018 28 CITY OF ANDOVER Budget Worksheet - 2019 Function: General Government City Clerk - 41300 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2013 2014 2015 2016 2017 2018 2018 2019 Salaries & Benefits 60110 Salaries - Regular 61,979 79,396 83,651 89,791 89,797 140,852 140,852 151,933 60210 FICA 3,966 4,615 4,911 5,466 5,292 6,414 6,414 6,795 60220 Medicare 927 1,079 1,148 1,278 1,238 1,500 1,500 1,589 60310 Health Insurance 7,107 7,982 8,541 14,584 12,830 14,500 14,500 17,400 60320 Dental Insurance 288 289 559 494 432 542 542 550 60330 Life Insurance 12 12 10 11 11 40 40 40 60340 Long -Teem Disability 113 119 106 127 132 269 269 285 60410 PERA 4,977 5,719 6,257 6,813 6,737 7,759 7,759 8,220 60520 Workers Comp 1,654 2,107 2,244 2,467 3,582 3,725 3,725 3,946 60990 Inter -City Labor Allocation - - - - (48,180) (48,180) (54,652) Salaries & Benefits 81,023 101,318 107,427 121,031 120,051 127,421 127,421 136,106 Departmental 61005 Supplies - General 258 313 232 152 325 600 600 600 61310 Meals/Lodging 297 277 230 298 297 350 350 350 61315 Continuing Education - - - - 200 200 200 200 61320 Annual Dues/Licenses 430 560 470 470 240 500 500 500 61405 Postage 118 424 439 469 293 160 160 160 61410 Transportation / Mileage 95 160 87 91 67 300 300 300 Departmental 1,198 1,734 1,458 1,480 1,422 2,110 2,110 2,110 Operating 62030 Telephone 890 689 (5) - - - - - 62100 Insurance 24,929 24,929 25,677 25,677 25,677 25,677 25,677 25,677 62305 Software Maintenance Contract 200 150 150 150 150 200 200 200 Operating 26,019 25,768 25,822 25,827 25,827 25,877 25,877 25,877 Professional Services 63025 Publishing 72 41 68 - 150 - - - 63030 Printing - - - - - 200 200 200 63215 Recording Fee - - - - - - - ' Professional Services 72 41 68 150 200 200 200 Total 108,312 128,861 134,775 148,338 147,450 155,608 155,608 164,293 8/24/2018 29 CITY OF ANDOVER Budget Worksheet - 2019 Function: General Government Elections - 41310 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2013 2014 2015 2016 2017 2018 2018 2019 Salaries & Benefits 60110 Salaries -Regular 4,927 5,685 5,423 7,965 8,077 - - - 60130 Salaries - Election Judges 286 27,730 - 44,771 - - - - 60210 FICA 67 325 314 477 474 - - - 60220 Medicare 1,207 76 74 112 111 - - - 60310 Health Insurance 49 1,439 1,375 1,555 1,436 - - - 60320 Dental Insurance 1 53 46 54 47 - - - 60330 Life Insurance 13 2 1 1 1 - - - 60340 Long -Term Disability 354 15 12 17 IS - - - 60410 PERA - 410 406 612 602 - - - 60990 Inter -City Labor Allocation - 49,931 49,931 55,713 Salaries & Benefits 6,904 35,735 7,651 55,564 10,763 49,931 49,931 55,713 Departmental 61005 Supplies - General - 52 96 259 - - - - 61020 Supplies - Operating - 53 - 41 - 840 840 840 61405 Postage - - - 483 - 1,000 1,000 1,000 61410 Transportation/Mileage - 32 - 99 - 160 160 160 Departmental - 137 96 882 - 2,000 2,000 2,000 Professional Services 63010 Contractual Services 4,448 4,764 6,750 6,934 7,089 7,100 7,100 7,250 63030 Printing 872 1,053 - 750 750 750 Professional Services 4,448 5,636 6,750 7,987 7,089 7,850 7,850 8,000 Total 11,352 41,508 14,497 64,433 17,852 59,781 59,781 65,713 8/24/2018 30 CTFY OF ANDOVER Budget Worksheet - 2019 Function: General Government Finance -41400 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2013 2014 2015 2016 2017 2018 2018 2019 Salaries & Benefits 60110 Salaries - Regular 128,362 135,962 143,214 152,791 156,617 259,325 259,325 267,097 60210 FICA 7,465 7,429 7,823 8,999 8,993 16,077 16,077 16,560 60220 Medicare 1,658 1,734 1,830 2,105 2,103 3,760 3,760 3,873 60310 Health Insurance 18,563 21,320 21,894 22,769 23,037 36,500 36,500 43,800 60320 Dental Insurance 679 764 913 947 934 1,626 1,626 1,650 60330 Life Insurance 27 27 23 24 23 60 60 60 60340 Long -Term Disability 346 373 330 - 366 371 675 675 694 60410 PERA 9,257 9,784 10,702 11,840 11,742 19,450 19,450 20,033 60520 Workers Comp 5,348 5,427 5,569 3,945 5,731 9,336. 9,336 9,615 60990 Inter -City Labor Allocation - - - (125,695) (125,695) (131,716) Salaries & Benefits 171,705 182,820 192,298 203,786 209,551 221,114 221,114 231,666 Departmental 61005 Supplies - General 1,619 2,634 3,032 2,891 1,492 3,500 3,500 3,500 61220 Software 180 169 169 169 344 200 200 200 61310 Meals / Lodging - - - - - 250 250 250 61315 Continuing Education - 825 40 - - 750 750 750 61320 Annual Dues / Licenses 370 495 675 575 370 750 750 750 61405 Postage (362) 1,824 1,839 1,916 1,735 2,250 2,250 2,250 61410 Transportation/Mileage 228 230 184 174 129 400 400 400 Departmental 2,035 6,177 5,939 5,725 4,070 8,100 8,100 8,100 Operating 62030 Telephone 240 590 717 713 769 1,000 1,000 1,000 62100 Insurance 190 190 196 196 196 196 196 196 62305 Software Maintenance Contract 17,929 17,762 18,583 19,048 20,000 20,500 20,500 22,000 Operating 18,359 18,542 19,496 19,957 20,965 21,696 21,696 23,196 Professional Services 63005 Professional Services 22,631 22,583 22,035 22,506 23,772 26,650 26,650 27,650 63025 Publishing 485 517 551 589 525 800 800 800 63100 R & M Labor - General - - 300 300 500 Professional Services 23,116 23,100 22,586 23,095 24,297 27,750 27,750 28,950 Total 215,215 230,639 240,319 252,563 258,883 278,660 278,660 291,912 8/24/2018 31 CITY OF ANDOVER Budget Worksheet -2019 Function: General Government Assessing -41410 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2013 2014 2015 2016 2017 2018 2018 2019 Professional Services 63005 Professional Services 144,561 145,051 146,315 146,473 147,915 154,000 150,000 154,000 Professional Services 144,561 145,051 146,315 146,473 147,915 154,000 150,000 154,000 Total 144,561 145,051 146,315 146,473 147,915 154,000 150,000 154,000 8/24/2018 32 8/24/2018 33 CRY OF ANDOVER Budget Worksheet - 2019 Function: General Government Information Services - 41420 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2013 2014 2015 2016 2017 2018 2018 2019 Salaries & Benefits 60110 Salaries -Regular 70,719 74,293 77,838 82,406 83,996 94,969 94,969 97,679 60210 FICA 4,036 4,567 4,802 5,277 5,198 5,888 5,888 6,056 60220 Medicare 944 1,068 1,123 1,234 1,216 1,377 1,377 1,4M 60310 Health Insurance 11,092 6,451 6,594 6,696 6,888 7,500 7,500 9,000 60320 Dental Insurance 453 447 421 435 435 542 542 550 60330 Life Insurance 13 13 11 11 11 20 20 20 60340 Long -Term Disability 186 192 174 203 207 247 247 254 60410 PERA 5,089 5,348 5,818 6,392 6,297 7,123 7,123 7,326 60520 Workers Comp 1,845 2,020 2,132 2,134 3,074 3,419 3,419 3,516 60990 later -City Labor Allocation - - - - (10,308)1( 0,308) (10,697) Salaries & Benefits 94,377 94,399 98,913 104,788 107,322 110,777 110,777 115,120 Departmental 61005 Supplies -General 2,571 1,570 2,787 3,978 3,003 4,300 4,300 4,300 61020 Supplies -Operating (2,142) (2,289) (2,116) (2,999) (2,414) - - - 61210 Small & Expend -Office Equips 2,780 3,547 2,795 3,929 7,300 7,000 7,000 7,000 61225 Technology Upgrades 9,608 24,618 4,613 8,404 13,695 13,000 13,000 13,000 61310 Meals / Lodging - - - 16 - - - - 61315 Continuing Education 110 149 - - - 2,000 2,000 2,000 61320 Annual Dues/Licenses 5,895 4,932 6,602 4,073 1,891 14,970 14,970 14,970 61405 Postage 82 62 83 131 68 200 200 200 61410 Transportation/Mileage 411 265 136 236 219 150 150 250 Departmental 19,315 32,854 14,900 17,768 23,762 41,620 41,620 41,720 Operating 62030 Telephone 1,128 880 1,083 1,479 1,254 1,200 1,200 1,450 62200 Rentals 6,888 6,692 - 2,584 3,101 4,000 4,000 4,000 62305 Software Maintenance Contract 12,173 10,284 15,723 21,424 12,589 21,000 21,000 23,300 Operating 20,189 17,856 16,806 25,487 16,944 26,200 26,200 28,750 Professional Services 63005 Professional Services 2,101 1,875 1,125 3,094 1,484 1,500 1,500 2,000 63100 R & M Labor - General 250 - 500 500 500 Professional Services 2,101 1,875 1,125 3,344 1,484 2,000 2,000 2,500 Total 135,982 146,984 131,744 151,387 149,512 180,597 180,597 188,090 8/24/2018 33 8/24/2018 34 CITY OF ANDOVER Budget Worksheet - 2019 Function: General Government Planning & Zoning - 41500 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2013 2014 2015 2016 2017 2018 2018 2019 Salaries & Benefits 60110 . Salaries -Regular 242,808 270,842 283,989 293,168 283,554 299,842 299,842 313,500 60140 Salaries - Council/Commission 4,400 4,730 4,010 2,570 2,950 5,600 5,600 5,600 60210 FICA 14,009 15,462 16,367 17,617 16,423 18,938 18,938 19,784 60220 Medicare 3,276 3,616 3,828 4,120 3,841 4,429 4,429 4,627 60310 Health Insurance 38,307 44,070 47,385 47,956 40,045 45,480 45,480 47,800 60320 Dental Insurance 1,749 1,748 1,957 1,939 1,523 2,168 2,168 1,650 60330 Life Insurance 51 50 48 47 49 80 80 80 60340 Long-Term Disability 637 677 661 653 688 780 780 815 60410 PERA 17,438 19,374 21,250 21,599 21,181 22,488 22,488 23,512 60520 Workers Comp 6,974 6,997 7,348 7,846 10,376 10,794 10,794 11,286 60990 later -City Labor Allocation - - - 3,780 3,780 7,538 Salaries & Benefits 329,649 367,566 386,843 397,515 380,630 414,379 414,379 436,192 Departmental 61005 Supplies- General 1,678 2,330 1,773 1,486 2,340 3,000 3,000 2,000 61020 Supplies - Operating - 61 252 287 564 - - - 61310 Meals / Lodging - 15 14 - 277 820 820 1,220 61315 Continuing Education 295 135 60 83 885 1,330 1,330 1,530 61320 Annual Dues /Licenses 760 940 720 1,485 879 1,610 1,610 1,719 61405 Postage 1,874 2,469 1,895 1,409 1,186 2,000 2,000 2,000 61410 Transportation/Mileage - - - - 179 400 400 800 Departmental 4,607 5,950 4,714 4,750 6,310 9,160 9,160 9,269 Operating 62030 Telephone 1,364 1,511 1,182 1,407 1,177 1,500 1,500 1,500 62100 Insurance 305 305 314 314 314 314 314 314 62200 Rentals 1,094 1,327 1,200 1,100 1,001 1,500 1,500 1,500 62205 Central Equipment Services 3,978 3,978 4,097 4,097 3,974 3,974 3,974 3,974 62305 Software Maintenance Contract 314 250 250 250 250 300 300 300 Operating 7,055 7,371 7,043 7,168 6,716 7,588 7,588 7,588 Professional Services 63005 Professional Services 4,071 3,606 3,701 2,350 2,916 4,000 4,000 4,000 63025 Publishing 2,801 2,263 2,971 1,898 1,794 2,800 2,800 2,800 63100 R & M Labor - General - - - - - 300 300 300 63215 Recording Fee 1,306 552 773 460 414 600 600 600 Professional Services 8,178 6,421 7,445 4,708 5,124 7,700 7,700 7,700 Total 349,489 387,308 406,045 414,141 398,780 438,827 438,827 460,749 8/24/2018 34 8/24/2018 35 CITY OF ANDOVER Budget Worksheet - 2019 Function: General Government Engineering - 41600 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2013 2014 2015 2016 2017 2018 2018 2019 Salaries & Benefits 60110 Salaries -Regular 316,530 323,270 326,861 360,773 357,895 620,622 620,622 638,528 60210 FICA 18,499 18,823 19,175 21,565 20,834 38,479 38,479 39,588 60220 Medicare 4,340 4,409 4,493 5,099 4,873 8,999 8,999 9,258 60310 Health Insurance 38,658 39,087 37,278 49,720 51,136 87,500 87,500 105,000 60320 Dental Insurance 1,628 1,676 1,963 2,087 2,089 3,794 3,794 3,850 60330 Life Insurance 57 58 50 51 51 140 140 140 60340 Long -Term Disability 774 817 716 794 792 1,613 1,613 1,661 60410 PERA 22,345 22,853 23,926 27,377 26,826 46,548 46,548 47,890 60520 Workers Comp 13,654 13,980 14,381 9,412 13,096 22,342 22,342 22,988 60990 Inter -City Labor Allocation - - - - - (322,645) (322,645) (337,047) Salaries & Benefits 416,485 424,973 428,843 476,878 477,592 507,392 507,392 531,856 Departmental 61005 Supplies- General 4,668 4,351 6,733 4,141 3,520 5,500 5,500 5,500 61205 Small & Expend - Small Tools 181 1,086 771 329 1,531 2,200 2,200 2,200 61220 Software 868 240 670 694 1,300 1,000 1,000 1,000 61310 Meals/Lodging 69 356 380 491 256 800 800 800 61315 Continuing Education 2,370 3,485 1,095 1,825 1,535 3,500 3,500 3,500 61320 Annual Dues Licenses 1,053 1,833 1,479 1,946 1,686 2,000 2,000 2,000 61325 Subscriptions Publications 30 109 255 58 35 500 500 500 61405 Postage 735 508 1,363 869 660 1,400 1,400 1,400 61410 Transportation/Mileage 2,030 1,998 1,878 1,889 2,099 2,300 2,300 2,300 Departmental 12,004 13,966 14,624 12,242 12,622 19,200 19,200 19,200 Operating 62030 Telephone 4,076 5,233 4,843 5,304 5,020 6,100 6,100 6,600 62100 Insurance 323 323 333 333 333 333 333 333 62200 Rentals 1,094 1,327 1,200 1,200 1,001 1,500 1,500 1,500 62205 Central Equipment Services 12,451 12,451 12,825 12,825 12,440 12,440 12,440 12,440 62,305 Software Maintenance Contract: 5,203 2,461 2,129 2,130 2,045 4,500 4,500 4,500 Operating 23,147 21,795 21,330 21,792 20,839 24,873 24,873 25,373 Professional Services 63005 Professional Services 679 - - - - 2,000 2,000 2,000 63025 Publishing 13 - - 162 - - - - 63100 R & M Labor - General - - - - - 300 300 300 63215, Recording Fees 460 138 46 - 130 - - - Professional Services 1,152 138 46 162 130 2,300 2,300 2,300 Total 452,788 460,872 464,843 511,074 511,183 553,765 553,765 578,729 8/24/2018 35 8/24/2018 36 MY OF ANDOVER Budget Worksheet - 2019 Function: General Government Faciltiy Mgmt Rollup - 41900 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2013 2014 2015 2016 2017 2018 2018 2019 Salaries & Benefits 60110 . Salaries -Regular 18,061 21,417 13,892 13,812 75,352 75,689 75,689 80,182 60210 FICA 1,112 1,301 844 850 4,333 4,693 4,693 4,971 60220 Medicare 260 304 198 199 1,014 1,097 1,097 1,163 60310 Health Insurance 1,130 1,545 1,262 722 15,702 14,500 14,500 17,400 60320 Dental Insurance - 2 24 9 51 542 542 550 60330 Life Insurance - I I - 12 20 20 20 60340 Long -Term Disability 4 7 4 2 176 197 .197 208 60410 PERA 263 311 235 80 5,535 5,677 5,677 6,014 60520 Workers Comp - - - 433 2,757 2,725 2,725 2,887 60990 Inter -City Labor Allocation - - - 5,598 5,598 (4,536) Salaries & Benefits 20,830 24,888 16,460 16,107 104,932 110,738 110,738 108,859 Departmental 61005 Supplies - General - - - - - - - - 61020 - Supplies - Operating 1,996 1,416 3,858 2,289 2,706 5,950 5,950 5,950 61025 Supplies- Cleaning 3,216 2,456 3,858 3,288 4,097 7,100 7,100 7,100 61120 R&MSupplies -Building 17,331 10,358 8,998 8,771 9,663 27,500 27,500 22,500 61205 Small&Expend - Small Tools 7,345 3,980 7,761 3,680 924 4,000 4,000 4,000 61245 Items for Resale 36,285 35,335 24,789 22,484 - - - - 61320 Annual Dues / Licenses 463 1 966 463 463 145 - - Departmental 66,636 54,511 49,727 40,975 17,535 44,550 44,550 39,550 Operating 62005 Electric 65,019 60,534 70,233 64,583 69,392 79,750 79,750 79,750 62010 Water & Sewer Service 24,783 15,275 20,730 18,387 16;017 27,500 27,500 27,500 62015 Natural Gas 50,884 64,478 47,877 31,589 38,164 69,750 69,750 69,750 62020 Refuse Collection 6,323 10,442 10,129 12,851 12,472 13,800 13,800 14,300 62025 Storm Water Utility Charge 4,077 3,267 5,731 4,839 5,081 5,850 5,850 5,850 62030 Telephone 31,386 18,946 23,029 20,104 19,729 43,250 43,250 33,250 62100 Insurance 33,342 33,342 34,341 34,341 34,341 34,341 34,341 34,341 62200 Rentals 6,143 5,517 5,042 5,081 6,004 7,750 7,750 7,750 62300 Equipment Maintenance Contra 11,026 15,863 22,712 22,525 28,520 30,940 30,940 32,940 62305 Software Support Contract - - - - 4,707 3,000 3,000 4,500 Operating 232,983 227,664 239,824 214,300 234,427 315,931 315,931 309,931 Professional Services 63010 Contractual Services 66,354 72,613 64,976 67,904 81,879 73,350 73,350 73,350 63100 R & M Labor - General 957 302 181 1,436 - - - - 63105 R&M Labor - Building 63,497 90,419 127,645 67,528 70,774 103,950 133,950 129,950 Professional Services 130,808 163,334 192,802 136,868 152,653 177,300 207,300 203,300 Capital Outlay 65600 Equipment - - - - - - - - Capital Outlay - - - - Total 451,257 470,397 498,813 408,250 509,547 648,519 678,519 661,640 451,257 470,397 498,813 408,250 509,547 648,519 678,519 661,640 8/24/2018 36 8/24/2018 37 CITY OF ANDOVER Budget Worksheet - 2019 Function: General Government City Hall -41910 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2013 2014 2015 2016 2017 2018 2018 2019 Salaries & Benefits 60110 Salaries - Regular - - - - 25,115 75,689 75,689 80,182 60210 FICA - - - - 1,444 4,693 4,693 4,971 60220 Medicare - - - - 338 1,097 1,097 1,163 60310 Health Insurance - - - - 7,258 14,500 14,500 17,400 60320 Dental Insurance - - - - 17 542 542 550 60330 Life Insurance - - - - 4 20 20 20 60340 Long -Term Disability - - - - 59 197 197 208 60410 PERA - - - - 1,845 5,677 5,677 6,014 60520 Workers Comp - - - - 2,757 2,725 2,725 2,887 60990 Inter -City Labor Allocation - - - - (68,231) (68,231) (77,108) Salaries & Benefits 38,837 36,909 36,909 36,287 Departmental 61020 Supplies - Operating 112 522 763 316 789 2,100 2,100 2,100 61025 Supplies -Cleaning 1,696 933 1,686 972 1,624 1,500 1,500 1,500 61120 R & M Supplies - Building 954 601 281 515 2,572 5,730 5,730 5,730 61205 Small & Expend - Small Tools 2,254 - 945 - 80 2,000 2,000 2,000 Departmental 5,016 2,056 3,675 1,803 5,065 11,330 11,330 11,330 Operating 62005 Electric 20,360 19,555 19,321 19,552 19,023 24,250 24,250 24,250 62010 Water &Sewer Service 3,062 1,817 3,045 2,445 2,546 3,750 3,750 3,750 62015 Natural Gas 5,565 6,899 4,585 3,595 4,341 9,000 9,000 9,000 62020 Refuse Collection 858 2,150 1,917 2,013 2,078 2,500 2,500 2,500 62025 Storm Water Utility Charge 821 693 1,200 1,018 1,069 1,200 1,200 1,200 62030 Telephone 12,416 6,357 8,016 7,130 7,407 16,000 16,000 12,500 62100 Insurance 14,179 14,179 14,604 14,604 14,604 14,604 14,604 14,604 62200 Rentals 1,363 1,394 1,488 1,540 1,718 2,750 2,750 2,750 62300 Equipment Maintenance Contra 2,443 5,032 6,198 5,683 7,071 6,870 6,870 7,310 62305 Software Support Contract - - - 1,409 1,000 1,000 1,500 Operating 61,067 58,076 60,374 57,580 61,266 81,924 81,924 79,364 Professional Services 63010 Contractual Services 24,180 24,686 23,585 24,066 29,888 26,800 26,800 26,800 63105 R&MLabor -Building 14,538 22,857 25,730 9,918 27,831 23,000 33,000 45,500 Professional Services 38,718 47,543 49,315 33,984 57,719 49,800 59,800 72,300 Total 104,801 107,675 113,364 93,367 162,887 179,963 189,963 199,281 8/24/2018 37 CITY OF ANDOVER Budget Worksheet - 2019 Function: General Government Fire Stations - 41920 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2013 2014 2015 2016 2017 2018 2018 2019 8/24/2018 38 Salaries & Benefits 60110 Salaries -Regular - - - - 25,115 - - - 60210 FICA - - - - 1,444 - - - 60220 Medicare - - - - 338 - - - 60310 Health Insurance - - - - 3,945 - - - 60320 Dental Insurance - - - - 17 - " 60330 Life Insurance - - - - 4 - 60340 Long -Term Disability - - - - 58 - - - 60410 PERA - - - - 1,845 - - - 60520 Workers Comp - - - - - - " 60990 Inter -City Labor Allocation - - - - - 36,919 36,919 36,286 Salaries & Benefits - - 32,766 36,919 36,919 36,286 Departmental 61020 Supplies - Operating 30 48 30 138 233 300 300 300 61025 Supplies- Cleaning 532 208 957 833 603 1,200 1,200 1,200 61120 R&M Supplies - Building 1,787 .442 1,179 2,700 4,082 6,250 6,250 6,250 Departmeatal 2,349 698 2,166 3,671 4,918 7,750 7,750 7,750 Operating 62005 Electric 21,861 21,294 21,445 21,333 22,585 24,000 24,000 24,000 62010 Water &Sewer Service 5,166 3,325 4,656 3,937 3,448 6,000 6,000 6,000 62015 Natural Gas 14,601 19,629 12,205 9,269 10,724 20,000 20,000 20,000 62020 Refuse Collection 1,257 3,917 3,957 4,119 4,487 4,500 4,500 5,000 62025 Storm Water Utility Charge 92 76 132 112 118 I50 I50 150 62030 Telephone 10,971 7,513 8,764 7,625 7,742 16,500 16,500 13,000 62100 Insurance 10,450 10,450 10,764 10,764 10,764 10,764 10,764 10,764 62300 Equipment Maintenance Contra 4,873 5,664 9,566 6,532 10,706 12,850 12,850 13,450 62305 Software Support Contract - - - - 1,409 1,000 1,000 1,500 Operating 69,271 71,868 71,489 63,691 71,983 95,764 95,764 93,864 Professional Services 63010 Contractual Services 21,085 19,805 19,638 20,126 26,006 20,500 20,500 20,500 63105 R&M Labor - Building 16,608 33,407 27,340 26,992 28,968 34,000 44,000 37,500 Professional Services 37,693 53,212 46,978 47,118 54,974 54,500 64,500 58,000 Total 109,313 125,778 120,633 114,480 164,641 194,933 204,933 195,900 8/24/2018 38 824/2018 39 CITY OF ANDOVER Budget Worksheet - 2019 Function: General Government Public Works Building - 41930 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2013 2014 2015 2016 2017 2018 2018 2019 Salaries & Benefits 60110 Salaries -Regular - - - - 25,122 - - - 60210 FICA - - - - 1,445 - - - 60220 Medicare - - - - 338 - - - 60310 Health Insurance - - - - 3,979 - - - 60320 Dental Insurance - - - - 17 - - - 60330 Life Insurance - - - - 4 - - - 60340 Long -Term Disability - - - - 59 - - - 60410 PERA - - - - 1,845 - - - 60520 Workers Comp - - - - - - - - 60990 Inter -City Labor Allocation - - 36,910 36,910 36,286 Salaries&Benefits 32,809 36,910 36,910 36,286 Departmental 61020 Supplies - Operating 603 643 895 1,130 693 1,800 1,800 1,800 61025 Supplies -Cleaning 988 1,315 1,215 1,213 1,870 2,400 2,400 2,400 61120 R & M Supplies -Building 12,667 7,863 7,006 3,932 1,324 12,000 12,000 7,000 61205 Small & Expend - Small Tools 5,091 3,980 6,816 3,680 844 2,000 2,000 2,000 Departmental 19,349 13,801 15,932 9,955 4,731 18,200 18,200 13,200 Operating 62005 Electric 22,582 19,406 29,212 23,466 27,538 31,000 31,000 31,000 62010 Water & Sewer Service 15,302 9,328 11,738 10,946 8,884 16,000 16,000 16,000 62015 Natural Gas 26,012 31,835 27,257 15,632 19,029 34,000 34,000 34,000 62020 Refuse Collection 4,208 4,269 4,255 6,719 5,907 6,500 6,500 6,500 62025 Storm Water Utility Charge 3,164 2,498 4,399 3,709 3,894 4,500 4,500 4,500 62030 Telephone 6,679 3,938 5,290 4,324 3,368 9,500 9,500 6,500 62100 Insurance 6,273 6,273 6,461 6,461 6,461 6,461 6,461 6,461 62200 Rentals 4,780 4,123 3,554 3,541 4,286 5,000 5,000 5,000 62300 Equipment Maintenance Contract 1,900 4,967 6,728 10,090 7,989 8,800 8,800 9,370 62305 Software Support Contract - - 1,889 1,000 1,000 1,500 Operating 90,900 86,637 98,894 84,888 89,245 122,761 122,761 120,831 Professional Services 63010 Contractual Services 19,793 25,414 19,600 20,099 24,343 21,950 21,950 21,950 63105 R&MLabor -Building 30,902 25,607 71,667 25,699 13,306 30,000 40,000 35,000 Professional Services 50,695 51,021 91,267 45,798 37,649 51,950 61,950 56,950 Total 160,944 151,459 206,093 140,641 164,434 229,821 239,821 227,267 824/2018 39 CITY OF ANDOVER Budget Worksheet - 2019 Function: General Government Equipment Building - 41950 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2013 2014 2015 2016 2017 2018 2018 2019 Operating 62015 Natural Gas 1,376 1,774 1,218 1,020 1,257 2,250 2,250 2,250 62100 insurance 308 308 317 317 317 317 317 317 62300 Equipment Maintenance Contra 690 - - - - - - - Operating 2,374 2,082 1,535 1,337 1,574 2,567 2,567 2,567 Professional Services 63105 R & M Labor - Building 505. - - - 1,250 1,250 1,250 Professional Services 505 - - 1,250 1,250 1,250 Total2,879 2,082 1,535 1,337 1,574 3,817 3,817 3,817 8/24/2018 40 CITY OF ANDOVER Budget Worksheet - 2019 Function: General Government City Hall Garage- 41960 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2013 2014 2015 2016 2017 2018 2018 2019 Departmental 61120 R & M Supplies - Building - - - 74 350 350 350 Departmental - - - 74 350 350 350 Operating 62005 Electric 216 279 255 232 246 500 500 500 62100 Insurance 509 509 524 524 524 524 524 524 Operating 725 788 779 756 770 1,024 1,024 1,024 Professional Services 63105 R & M Labor - Building - - - - - 750 750 750 Professional Services - - - - 750 750 750 Total 725 788 779 756 844 2,124 2,124 2,124 824/1018 41 CITY OF ANDOVER Budget Worksheet - 2019 Function: General Government Sunshine Park Building - 41970 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2013 2014 2015 2016 2017 2018 2018 2019 61020 Departmental Supplies - Operating 545 113 607 419 991 1,000 1,000 1,000 61025 Supplies- Cleaning - - - 135 - 1,000 1,000 1,000 61120 R & M Supplies - Building 1,281 1,244 50 - 848 1,020 1,020 1,020 Departmental 1,826 1,357 657 554 1,839 3,020 3,020 3,020 62010 Operating Water & Sewer Service 1,253 805 1,291 1,059 1,139 1,750 1,750 1,750 62015 Natural Gas 1,489 2,045 1,056 734 1,102 2,000 2,000 2,000 62020 Refuse Collection - 53 - - - 300 300 300 62030 Telephone 385 343 '240 251 356 500 500 500 62100 Insurance 541 541 557 557 557 557 557 557 62300 Equipment Maintenance Contra 560 - - - 608 620 620 680 Operating 4,228 3,787 3,144 2,601 3,762 5,727 5,727 5,787 Professional Services 63010 Contractual Services 122 1,580 740 1,458 755 2,000 2,000 2,000 63105 R & M Labor -Building 539 7,252 2,154 3,293 - 10,000 10,000 5,000 Professional Services 661 8,832 2,894 4,751 755 12,000 12,000 7,000 Total 6,715 13,976 6,695 7,906 6,356 20,747 20,747 15,807 8/24/2018 42 8/242018 43 CITY OF ANDOVER Budget Worksheet - 2019 Function: General Government Sunshine Park Concessions - 41975 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2013 2014 2015 2016 2017 2018 2018 2019 Salaries & Benefits 60110 Salaries- Regular 11,955 15,417 13,812 13,812 - - - - 60210 FICA 736 936 840 850 - - - - 60220 Medicare 172 219 197 199 - - - - 60310 Health Insurance 812 1,154 1,042 722 520 - - - 60320 Dental Insurance - 2 23 9 - - - - 60330 Life Insurance - 1 1 - - - - - 60340 Long-Term Disability 3 5 4 2 - - - - 60410 PERA 165 213 229 80 - - - - 60520 Workers Comp - - - 433 - - - - 60990 Inter-City Labor Allocation - - - - - - - - Salaries&Benefits 13,843 17,947 16,148 16,107 520 - - - Departmental 61020 Supplies-Operating 537 90 1,563 16 - - - - 61245 Items for Resale 28,252 27,774 24,789 22,484 - - - - 61320 Annual Dues / Licenses 393 558 408 463 145 - - - Departmental 29,182 28,422 26,760 22,963 145 - - - Operating 62030 Telephone 385 343 240 251 147 - - - 62300 Equipment Maintenance Contra - 200 220 220 230 - - - Operating 385 543 460 471 377 - - - Professional Services 63100 R & M Labor - General 835 302 181 1,436 - - professional Services 835 302 181 1,436 - - - Capital Outlay 65600 Equipment - - - - - - Capital Outlay - - - - - - Tota] 44,245 47,2144 3,549 40,977 1,042 - - 8/242018 43 CrrY OF ANDOVER Budget Worksheet - 2019 Function: General Government Andover StNBldg - 41980 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2013 2014 2015 2016 2017 2018 2018 2019 Departmental 61020 Supplies - Operating 169 - - 270 - 750 750 750 61025 Supplies - Cleaning - - - 135 - 750 750 750 61120 R & M Supplies - Building 417 650 900 900 900 Departmental 169 - 417 405 650 2,400 2,400 2,400 Operating 62015 Natural Gas 1,354 1,640 1,115 966 1,261 1,750 1,750 1,750 62020 Refuse Collection - - - - - - - - 62030 Telephone 550 452 479 523 709 750 750 750 62100 Insurance 541 541 557 557 557 557 557 557 62300 Equipment Mainmmnce Contra 560 - - - 1,138 1,000 1,000 1,250 Operating 3,005 2,633 2,151 2,046 3,665 4,057 4,057 4,307 Professional Services 63010 Contractual Services 1,174 1,128 1,413 2,155 887 2,100 2,100 2,100 63105 R & M Labor - Building 271 - 754 1,626 476 3,000 3,000 3,000 Professional Services 1,445 1,128 2,167 3,781 1,363 5,100 5,100 5,100 Total 4,619 3,761 4,735 6,232 5,67811,557 11,557 11,807 44 MY OF ANDOVER Budget Worksheet - 2019 Function: General Government Account Actual Actual Actual Number Description 2013 2014 2015 Andover St N Concessions - 41985 Actual Actual Budget Estimate Requested 2016 2017 2018 2018 2019 - Salaries & Benefits _ - 60110 Salaries -Regular 6,106 6,000 80 - - _ 60210 FICA 376 365 4 _ 60220 Medicare 88 85 1 - - 60310 Health Insurance 318 391 220 - - - - 60320 Dental Insurance - - 1- 60330 Life Insurance - 60340 Long -Term Disability 1 2 60410 PERA 98 98 6- 60520 Workers Comp 60990 Inter -City Labor Allocation Salaries & Benefits 6,987 6,941 312 - Departmental - 61020 Supplies - Operating - 61245 Items for Resale 8,033 7,561 - - 61320 Annual Dues / Licenses 70 408 55 Departmental 8,1037,969 55 Operating - 62020 Refuse Collection - 62030 Telephone - - - Operating - Professional Services 63100 R & M Labor - General 122 Professional Services 122 ' Total15,212 74,910 367 - - - 45 CITY OF ANDOVER Budget Worksheet -2019 Prairie Knoll Park Bldg - 41990 Function: General Government Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2013 2014 2015 2016 2017 2018 2018 2019 Departmental - 250 250 250 61025 61120 Supplies - Cleaning R & M Supplies - Building - 642 - 208 - 65 - 1,624 113 1,250 1,250 1,250 Departmental 642 208 65 1,624 113 1,500 1,500 1,500 62015 Operating Natural Gas 487 656 441 373 450 750 750 750 62020 Refuse Collection - 541 53 541 - 557 - 557 - 557 - 557 - 557 557 62100 Insurance - 778 800 800 880 62300 Equipment Maintenance Contra - 1,028 - 1,250 - 998 930 1,785 2,107 2,107 2,187 Operating 63105 Professional Services R & M Labor - Building 134 1,296 - - 193 1,950 1,950 1,950 Professional Services 134 1,296 - 193 1,950 1,950 1,950 Total 1,804 2,754 1,063 2,554 2,091 5,557 5,557 5,637 CITY OFANDOVER Budget Worksheet -2019 Function: Public Safety Public Safety Rollup Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2013 2014 2015 2016 2017 2018 2018 2019 Salaries & Benefits 60110 Salaries -Regular 536,608 543,474 501,518 561,884 578,044 571,652 571,652 593,649 60120 Salaries- Volunteer Fire Fighter 223,204 282,019 221,470 247,392 303,471 318,258 318,258 341,100 60210 FICA 32,704 35,809 28,233 34,369 36,697 36,951 36,951 39,042 60220 Medicare 10,264 11,246 9,930 12,041 12,536 12,904 12,904 13,555 60310 Health Insurance 49,156 57,332 57,513 66,628 68,871 73,500 73,500 83,200 60320 Dental Insurance 3,163 2,918 2,675 2,889 2,937 3,252 3,252 3,300 60330 Life insurance 749 616 578 501 447 140 140 140 60340 Long -Term Disability 1,305 1,335 1,097 1,209 1,218 1,487 1,487 1,545 60410 PERA 46,949 45,968 52,199 61,069 60,573 68,445 68,445 73,349 60420 Nationwide Retirement 2,222 4,962 5,894 6,203 6,282 - _ 60520 Workers Comp 41,914 46,636 47,858 49,297 65,520 72,037 72,037 73,651 60540 Relief Association 203,555 206,491 220,332 222,844 222,893 220,000 220,000 220,000 60990 Inter-CityLabor Allocation - - 27,677 27,677 28,659 Salaries & Benefits 1,151,793 1,238,806 1,149,297 1,266,326 1,359,489 1,406,303 1,406,303 1,471,190 Departmental 61005 Supplies -General 2,303 3,014 6,188 8,030 9,364 10,200 10,200 12,100 61010 Supplies -Printed Forms 682 353 665 333 564 1,000 1,000 1,000 61015 Supplies - Training - - 1,089 2,035 8,537 4,000 4,000 6,000 61020 Supplies -Operating 59,643 86,583 27,639 48,052 29,530 37,050 37,050 29,850 61060 Supplies- Fire Prevention/Educ - - 1,270 1,027 2,609 4,500 4,500 4,500 61205 Small&Expend - Small Tools - 1,056 5,671 7,536 5,769 6,000 6,000 9,000 61305 Uniforms 1,621 17,761 55,879 52,014 37,442 35,000 35,000 40,000 61310 Meals/Lodging 2,232 2,606 2,490 1,534 7,022 7,000 7,000 8,000 61315 Continuing Education 28,763 21,524 21,784 16,805 23,898 23,000 23,000 28,000 61320 Annual Dues/Licenses 4,240 3,674 3,706 2,585 3,161 5,000 5,000 5,000 61325 Subscriptions/Publications 1,581 1,755 56 1,345 1,604 1,500 1,500 1,500 61405 Postage 1,916 1,385 1,852 1,353 1,361 2,300 2,300 1,800 61410 Transportation/Mileage 3,338 2,025 1,438 2,019 4,109 3,000 3,000 3,000 Departmental 106,319 141,736 129,727 144,668 134,970 139,550 139,550 149,750 Operating 62005 Electric 769 724 720 720 720 800 800 800 62030 Telephone 2,776 4,113 4,253 5,848 4,668 6,000 6,000 6,600 62100 Insurance 25,365 25,365 26,126 26,126 26,126 26,506 26,506 26,506 62200 Rentals 5,637 4,900 4,799 5,011 4,908 7,250 7,250 7,250 62205 Central Equipment Services 189,292 189,292 195,277 194,971 189,121 189,121 189,121 189,121 62300 Equipment Maintenance Contra 11,004 10,855 9,381 9,457 9,551 13,500 13,500 13,600 62305 Software Maintenance Contrail 3,039 2,880 6,006 17,635 19,074 34,400 34,400 35,000 Operating 237,882 238,129 246,562 259,768 254,168 277,577 277,577 278,877 Professional Services 63005 Professional Services 45,673 35,961 34,212 37,772 42,943 47,100 47,100 47,600 63010 Contractual Services 2,753,253 2,832,132 2,930,048 2,951,466 2,984,162 3,087,026 3,087,026 3,208,860 63025 Publishing 67 754 186 349 - 500 500 1,500 63030 Printing - - 500 500 2,000 63100 R&MLabor -General 16,353 11,402 13,300 6,977 2,604 19,500 19,500 15,000 Professional Services 2,815,346 2,880,249 2,977,746 2,996,564 3,029,709 3,154,626 3,154,626 3,274,960 Total 4,311,340 4,498,920 4,503,332 4,667,326 4,778,336 4,978,056 4,978,056 5,]74,777 47 CITY OF ANDOVER Budget Worksheet - 2019 Function: Public Safety Police Protection - 42100 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2013 2014 2015 2016 2017 2018 2018 2019 Professional Services 63010 Contractual Services 2,740,899 2,818,132 2,918,308 2,936,467 2,962,551 3,053,526 3,053,526 3,183,610 Professional Services 2,740,899 2,818,132 2,918,308 2,936,467 2,962,551 3,053,526 3,053,526 3,183,610 Total 2,740,899 2,818,132 2,918j08 2,936,467 2,962,551 3,053,526 3,053,526 1,183,610 8/24/2018 48 824/2018 49 CITY OF ANDOVER Budget Worksheet -2019 Function: Public Safety Fire Protection - 42200 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2013 2014 2015 2016 2017 2018 2015 2019 Salaries & Benefits 60110 Salaries -Regular 261,878 291,520 247,984 293,715 296,358 293,926 293,926 305,024 60120 Salaries -Volunteer Fire Fightei 223,204 282,019 221,470 247,392 303,471 318,258 318,258 341,100 60210 FICA 17,466 20,882 12,992 17,680 19,664 19,732 19,732 21,147 60220 Medicare 6,700 7,755 6,365 8,138 8,553 8,876 8,876 9,369 60310 Health Insurance 19,270 24,886 27,658 31,620 32,449 36,500 36,500 38,800 60320 Dental Insurance 1,363 1,137 1,037 1,046 1,044 1,084 1,084 1,100 60330 Life Insurance 697 564 543 467 412 60 60 60 60340 Long -Term Disability 652 694 595 674 665 765 765 793 60410 PERA 30,854 33,034 39,124 46,976 46,720 47,616 47,616 51,702 60520 Workers Comp 35,381 40,240 41,239 42,396 55,208 62,038 62,038 63,260 60540 Relief Association 203,555 206,491 220,332 222,844 222,893 220,000 220,000 220,000 60990 Inter -City Labor Allocation 21,435 21,435 22,294 Salaries & Benefits 801,020 909,222 819,339 912,948 987,437 1,030,290 1,030,290 1,074,649 Departmental 61005 Supplies - General 444 122 2,663 6,336 6,712 6,500 6,500 7,500 61015 Supplies - Training - - 1,089 2,035 8,537 4,000 4,000 6,000 61020 Supplies - Operating 58,191 84,466 26,550 47,058 28,595 34,300 34,300 27,600 61060 Supplies - Fire Prevention/Educ - - 1,270 1,027 2,609 4,500 4,500 4,500 61205 Small & Expend - Small Tools - 1,056 5,671 7,536 5,769 6,000 6,000 9,000 61305 Uniforms 1,621 17,761 55,879 52,014 37,442 35,000 35,000 40,000 61310 Meals/Lodging 2,232 2,278 2,258 968 5,851 6,000 6,000 7,000 61315 Continuing Education 25,493 19,431 19,053 13,040 21,837 15,000 15,000 20,000 61320 Annual Dues/ Licenses 4,030 3,574 3,606 2,485 2,771 3,500 3,500 3,500 61325 Subscriptions / Publications 1,581 1,755 56 1,345 1,604 1,500 1,500 1,500 61405 Postage 286 258 105 136 263 550 550 550 61410 Transportation/Mileage 2,635 1,313 561 1,014 2,759 2,000 2,000 2,000 Departmental 96,513 132,014 118,761 134,994 124,749 118,850 118,850 129,150 Operating 62030 Telephone 1,664 2,874 2,971 2,387 2,342 3,000 3,000 3,600 62100 Insurance 22,932 22,932 23,620 23,620 23,620 24,000 24,000 24,000 62200 Rentals 1,806 1,390 1,416 1,805 1,959 2,500 2,500 2,500 62205 Central Equipment Services 176,233 176,233 181,520 181,520 176,074 176,074 176,074 176,074 62300 Equipment Maintenance Contra 4,303 4,205 3,019 3,095 3,225 6,500 6,500 6,600 62305 Software Maintenance Contract - - 2,532 12,700 13,604 28,700 28,700 29,300 Operating 206,938 207,634 215,078 225,127 220,824 240,774 240,774 242,074 Professional Services 63005 Professional Services - 1,357 - - - 3,500 3,500 4,000 63010 Contractual Services 6,789 10,589 9,306 11,677 19,567 28,500 28,500 20,250 63025 Publishing - 40 - 45 - - - I,000 63030 Printing - - - - - 500 500 2,000 63100 R & M Labor -General 15,719 3,162 2,739 626 632 1,500 1,500 1,500 Professional Services 22,508 15,148 12,045 12,348 20,199 34,000 34,000 28,750 Total 1,126,979 1,264,018 1,165,223 1,285,417 1,353,209 1,423,914 1,423,914 1,474,623 824/2018 49 50 8/24/2018 CITY OF ANDOVER • Budget Worksheet -2019 Function: Public Safety Protective Inspection - 42300 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2013 2014 2015 2016 2017 2018 2018 2019 Salaries & Benefits 60110 Salaries -Regular 270,215 247,713 249,072 263,469 276,758 277,726 277,726 288,625 60210 FICA 14,965 14,679 14,980 16,401 16,742 17,219 17,219 17,895 60220 Medicare 3,500 3,433 3,504 3,836 3,915 4,028 4,028 4,186 60310 Health Insurance 29,463 31,767 29,161 34,306 35,698 37,000 37,000 44,400 60320 Dental Insurance 1,773 1,756 1,612 1,817 1,867 2,168 2,168 2,200 60330 Life Insurance 51 51 34 33 34 8o 80 80 60340 Long -Term Disability 640 629 492 524 541 722 722 752 60410 PERA 15,890 12,643 12,729 13,732 13,485 20,829 20,829 21,647 60420 Nationwide Retirement 2,099 4,962 5,894 6,203 6,282 - - - 60520 Workers Comp 6,533 6,396 6,619 6,901 10,312 9,999 9,999 10,391 60990 later -City Labor Allocation - - - 576) (576) (771) Salaries & Benefits 345,129 324,029 324,097 347,222 365,634 369,195 369,195 389,405 Departmental 61005 Supplies- General 1,859 2,458 3,525 1,694 2,652 3,700 3,700 3,700 61010 Supplies -Printed Forms 682 353 665 333 564 1,000 1,000 1,000 61020 Supplies - Operating 1,358 2,015 771 899 585 2,600 2,600 2,100 61310 Meals/Lodging - 328 232 566 1,171 1,000 1,000 1,000 61315 Continuing Education 3,270 2,093 2,731 3,680 2,061 5,500 5,500 5,500 61320 Annual Dues/Licenses 210 100 100 100 390 1,500 1,500 1,500 61405 Postage 1,630 1,127 1,747 1,217 1,098 1,750 1,750 1,250 61410 Transportation/Mileage 703 712 877 1,005 1,350 1,000 1,000 1,000 Departmental 9,712 9,186 10,648 9,494 9,871 18,050 18,050 17,050 Operating 62030 Telephone 1,112 1,239 1,282 3,461 2,326 3,000 3,000 3,000 62100 Insurance 1,575 1,575 1,622 1,622 1,622 1,622 1,622 1,622 62200 Rentals 3,831 3,510 3,383 3,206 2,949 4,750 4,750 4,750 62205 Central Equipment Services 13,059 13,059 13,757 13,451 13,047 13,047 13,047 13,047 62300 Equipment Maintenance Contra 676 625 36 36 - - - _ 62305 Software Maintenance Contract 2,839 2,730 3,324 4,785 5,320 5,500 5,500 5,500 Operating 23,092 22,738 23,404 26,561 25,264 27,919 27,919 27,919 Professional Services 63005 Professional Services 45,495 34,241 33,616 37,639 42,943 43,000 43,000 43,000 63025 Publishing 67 714 186 304 - 500 500 500 63100 R&MLabor -General - - - 3,027- 3,500 3,500 3,500 Professional Services 45,562 34,955 33,802 40,970 42,943 47,000 47,000 47,000 Total 423,495 390,908 391,951 424,247 443,712 462,164 462,164 481,374 50 8/24/2018 51 8/24/2018 CrrY OF ANDOVER Budget Worksheet- 2019 Function: Public Safety Emergency Mgmt-42400 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2013 2014 2015 2016 2017 2018 MIS 2019 Salaries & Benefits 60110 Salaries -Regular 4,515 4,241 4,462 4,700 4,928 - - - 60210 FICA 273 248 261 288 291 - - - 60220 Medicare 64 58 61 67 68 - - - 60310 Health Insurance 423 679 694 702 724 - - - 60320 Dental Insurance 27 25 26 26 26 - - - 60330 Life Insurance I I 1 1 1 - - - 60340 Long -Term Disability 13 12 10 11 12 - - - 60410 PERA 205 291 346 361 368 - - - 60420 Nationwide Retirement 123 - - - - _ _ - 60990 Inter -City Labor Allocation - - - - 6,818 6,818 7,136 Salaries & Benefits 5,644 5,555 5,861 6,156 6,418 6,818 6,818 7,136 Departmental 61005 Supplies - General - 434 - - - - - 900 61315 Continuing Education - - - 85 - 2,500 2,500 2,500 Departmental 434 - 85 2,500 2,500 3,400 Operating 62005 Electric 769 724 720 720 720 800 800 800 62100 Insurance 858 858 884 884 884 884 884 884 62300 Equipment Maintenance Contra 6,025 6,025 6,326 6,326 6,326 7,000 7,000 7,000 Operating 7,652 7,607 7,930 7,930 7,930 8,684 8,684 8,684 Professional Services 63100 R & M Labor - General 634 8,240 10,561 3,324 1,972 14,500 14,500 10,000 Professional Services 634 8,240 10,561 3,324 1,972 14,500 14,500 10,000 Total 13,930 21,836 24,352 17,495 16,320 32,502 32,5022 9,220 51 8/24/2018 CITY OF ANDOVER Budget Worksheet -2019 Function: Public Safety Animal Control- 42500 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2013 2014 2015 2016 2017 2018 2018 2019 Departmental 61010 Supplies - Printed Forms - - - _ _ - - - 61020 Supplies - Operating 94 102 318 95 350 150 150 150 Departmental 94 102 318 95 350 1S0 150 150 Operating - 62305 Software Maintenance Contract 200 150 150 150 150 200 200 200 Operating 200 150 150 150 I50 200 200 200 Professional Services 63005 Professional Services 178 363 596 133 - 600 600 600 63010 Contractual Services 5,565 3,411 2,434 3,322 2,044 5,000 5,000 5,000 Professional Services 5,743 3,774 3,030 3,455 2,044 5,600 5,600 5,600 Total 6,037 4,026 3,498 3,700 2,544 5,950 5,950 5,950 52 8/24/2018 CITY OF ANDOVER Budget Worksheet -2019 Function: Public Works Public Works Rollup Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2013 2014 2015 2016 2017 2018 2018 2019 53 Salaries & Benefits 60110 Salaries -Regular 1,172,132 1,233,640 1,219,394 1,258,013 1,196,475 1,083,860 1,083,860 1,115,366 60140 Salaries - Council/Commissior 3,660 3,640 3,720 3,410 3,340 3,600 3,600 3,600 60210 FICA 69,153 73,932 72,654 77,088 71,257 .67,424 67,424 69,372 60220 Medicare 16,181 17,294 16,995 18,054 16,665 15,767 15,767 16,228 60310 Health Insurance 153,123 167,321 170,573 175,737 185,735 171,960 171,960 187,800 60320 Dental Insurance 8,164 8,323 8,041 8,037 8,004 8,130 8,130 8,250 60330 Life Insurance 255 260 222 208 210 340 340 340 60340 Long -Term Disability 2,918 3,026 2,536 2,655 2,655 2,663 2,663 2,745 60410 PERA 81,019 86,131 84,565 88,567 85,251 81,286 81,286 83,651 60520 Workers Comp 24,252 25,837 26,858 32,783 43,782 39,022 39,022 40,156 60990 Inter -City Labor Allocation - - - - 290,445 290,445 307,892 Salaries & Benefits 1,530,857 1,619,404 1,605,558 1,664,552 1,613,374 1,764,497 1,764,497 1,835,400 Departmental 61005 Supplies -General 3,032 3,289 3,078 2,834 3,811 1,250 1,250 2,400 61020 Supplies -Operating 58,489 50,549 59,156 51,364 58,035 65,000 65,000 71,500 61025 Supplies -Cleaning 255 755 349 786 1,708 3,000 3,000 3,000 61030 Supplies - Signs 20,394 31,955 29,658 9,706 40,098 37,500 37,500 40,000 61105 R & M Supplies - General 24,411 22,311 21,866 24,471 17,200 23,000 23,000 31,000 61125 R & M Supplies - Streets 214,062 180,705 130,270 140,294 154,955 165,000 165,000 180,000 61130 R&M Supplies - Landscape 25,326 41,006 43,670 38,103 31,207 40,000 40,000 40,000 61205 Small & Expend - Small Tools 3,508 4,288 8,577 5,554 6,047 9,000 9,000 10,000 61220 Software - 6,670 - 5,160 761 4,000 4,000 4,000 61310 Meals/Lodging - 501 356 322 70 850 850 950 61315 Continuing Education 1,785 2,750 2,240 2,530 2,458 4,000 4,000 4,500 61320 Annual Dues/Licenses 927 898 1,334 3,991 5,559 7,710 7,710 8,910 61325 Subscriptions/Publications 542 422 420 375 715 - - - 61405 Postage 3,943 1,880. 2,115 3,624 3,837 4,200 4,200 4,200 61410 Transportation/Mileage 281 767 245 516 48 775 775 775 Departmental 356,955 348,746 303,334 289,630 326,509 365,285 365,285 401,235 Operating 62005 Electric 265,545 262,044 263,884 264,680 211,835 291,000 243,500 251,500 62015 Natural Gas 386 624 391 354 368 1,200 1,200 1,200 62010 Water & Sewer Service 33,848 22,082 36,557 30,279 34,339 38,000 38,000 38,000 62020 Refuse Collection 14,138 10,381 12,104 13,570 18,126 12,700 12,700 20,500 62025 Stora Water Utility Charge 918 739 - 1,280 1,086 1,139 1,200 1,200 1,200 62030 Telephone 5,145 7,907 8,904 8,596 9,097 9,500 9,500 11,000 62100 Insurance 38,290 38,290 39,439 39,439 39,439 39,439 39,439 39,439 62200 Rentals 16,863 11,023 16,592 22,665 13,221 26,000 26,000 28,500 62205 Central Equipment Services 299,579 299,579 308,567 308,567 299,331 299,331 299,331 299,331 62300 Equipment Maintenance Contra 9,940 10,050 10,298 10,381 10,661 13,500 13,500 13,500 62305 Software Maintenance Contract. 2,600 1,100 1,100 1,100 3,652 2,500 2,500 2,500 Operating 687,252 663,819 699,116 700,717 641,208 734,370 686,870 706,670 Professional Services 63005 Professional Services 2,544 4,843 3,032 2,267 4,278 6,100 9,600 6,100 63010 Contractual Services 104,464 134,524 155,894 150,317 165,425 177,500 183,500 186,900 63025 Publishing 1,503 842 7,497 9,827 7,620 10,000 10,000 10,000 63100 R&MLabor -General 19,623 43,775 28,163 14,373 13,070 33,400 33,400 35,400 63110 R & M Labor - Streets 1,404 400 - 2,000 2,000 4,000 63300 Improvements - Streets 1,630 3,419 13,983 7,790 8,146 13,000 13,000 13,000 Professional Services 129,764 187,403 209,973 184,974 198,539 242,000 251,500 255,400 Capital Outlay 65200 Building 54,514 - - - - 65300 Improvements - - - 126,801 74,910 100,000 115,000 120,000 65600 Equipment Capital Outlay 54,514 - - 126,801 74,910 ]00,000 115,000 120,000 Total 2,759,342 2,819,372 2,817,981 2,966,674 2,854,540 3,206,152 3,183,152 3,318,705 53 Function: Public Works Account Number Description CITY OF ANDOVER Budget Worksheet - 2019 Streets & Highways - 43100 Actual Actual Actual Actual Actual Budget Estimate Requested 2013 2014 2015 2016 2017 2018 2018 2019 8/24/2018 54 Salaries & Benefits 60110 Salaries -Regular 311,083 324,516 345,169 371,380 291,834 447,689 447,689 465,697 60210 FICA 18,973 19,149 20,896 22,430 17,567 27,757 27,757 28,872 60220 Medicare 4,439 4,479 4,888 5,252 4,108 6,491 6,491 6,754 60310 Health Insurance 43,336 43,073 48,116 45,263 51,127 74,980 74,980 83,200 60320 Dental Insurance 2,511 2,420 2,545 2,666 2,445 3,794 3,794 3,850 60330 - Life Insurance 73 71 66 62 60 140 140 140 60340 Long -Term Disability 821 810 752 805 707 1,112 1,112 1,159 60410 PERA 22,098 22,367 25,177 25,990 21,568 33,576 33,576 34,927 60520 Workers Comp 10,796 10,836 11,357 10,324 10,679 16,118 16,118 16,766 60990 Inter -City Labor Allocation - - - (161,353) (161,353) (169,604) Salaries & Benefits 414,130 427,721 458,966 484,172 400,095 450,304 450,304 471,761 Departmental 61005 Supplies -General 1,439 1,775 2,215 2,188 2,642 850 850 2,000 61020 Supplies -Operating 19,990 18,838 20,557 23,772 24,764 20,000 20,000 22,000 61125 R & M Supplies - Streets 39,131 40,767 30,279 41,538 36,942 40,000 40,000 50,000 61205 Small & Expend - Small Tools 1,887 3,381 2,966 3,446 2,725 4,000 4,000 4,000 61310 Meals / Lodging - 17 - 222 15 100 100 200 61315 Continuing Education 1,150 925 320 1,135 520 1,500 1,500 2,000 61320 Annual Dues/Licenses 220 182 535 1,115 2,194 2,000 2,000 2,500 61405 Postage 229 86 129 81 79 500 500 500 61410 Transportation/Mileage - - - - - 100 100 100 Departmental 64,046 65,971 57,001 73,497 69,881 69,050 69,050 83,300 Operating 62030 Telephone 2,428 3,624 3,812 3,570 3,406 4,000 4,000 4,000 62100 Insmance 20,992 20,992 21,622 21,622 21,622 21,622 21,622 21,622 62200 Rentals 2,036 - 561 10,053 3,700 10,000 10,000 12,500 62205 Central Equipment Services 57,919 57,919 59,657 59,657 57,867 57,867 57,867 57,867 Operating 83,375 82,535 85,652 94,902 86,595 93,489 93,489 95,989 Professional Services - 63005 Professional Services - 598 - - - 100 100 100 63010 Contractual Services 9,572 20,069 12,718 25,325 33,246 32,000 32,000 37,000 63110 R&MLabor -Streets - - 1,404 400 - 2,000 2,000 4,000 63300 Improvements - Streets 1,630 3,419 13,983 7,790 8,146 13,000 13,000 13,000 Professional Services 11,202 24,086 28,105 33,515 41,392 47,100 47,100 54,100 Total 572,753 600,313 629,724 686,086 597,963 659,943 659,943 705,150 8/24/2018 54 8/24/2018 55 CITY OF ANDOVER Budget Worksheet -2019 Function: Public Works Snow & Ice - 43200 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2013 2014 2015 2016 2017 2018 2018 2019 Salaries & Benefits 60110 Salaries - Regular 230,598 255,148 134,381 148,108 122,247 - - - 60210 FICA 12,552 16,123 7,679 9,484 7,429 - - - 60220 Medicare 2,938 3,771 1,797 2,225 1,738 - - - 60310 Health Insurance 24,112 30,238 17,430 18,412 19,081 - - - 60320 Dental Insurance 1,383 1,704 872 826 753 - - - 60330 Life Insurance 44 54 24 22 20 - - - 60340 Long -Term Disability 501 612 288 284 263 - - - 60410 PERA 15,257 19,540 9,631 11,712 9,387 - - - 60520 Workers Comp - - - 2,989 4,473 - - - 60990 Inter -City Labor Allocation - - - - 265,675 265,675 280,641 Salaries & Benefits 287,385 327,190 172,102 194,062 165,391 265,675 265,675 280,641 Departmental 61005 Supplies- General 132 188 113 102 151 - - - 61020 Supplies -Operating 2,790 2,100 22 2,929 272 4,500 4,500 4,500 61105 R & M Supplies - General 12,007 12,662 11,090 11,968 9,622 10,000 10,000 15,000 61125 R & M Supplies - Streets 174,931 139,938 99,991 98,756 118,013 125,000 125,000 130,000 61320 Annual Dues / Licenses 150 175 303 2,444 2,786 3,600 3,600 4,300 61325 Subscriptions/Publications 455 422 420 375 715 - - - Departmental 190,465 155,485 111,939 116,574 131,559 143,100 143,100 153,800 Operating 62100 Insurance 3,877 3,877 3,993 3,993 3,993 3,993 3,993 3,993 62205 Central Equipment Services 149,072 149,072 153,544 153,544 148,938 148,938 148,938 148,938 Operating 152,949 152,949 157,537 157,537 152,931 152,931 152,931 152,931 Professional Services 63100 R & M General 1,530 500 - 1,000 1,000 1,000 Professional Services 1,530 500 1,000 1,000 1,000 Total 630,799 637,154 442,078 468,173 449,881 562,706 562,706 588,372 8/24/2018 55 CITY OF ANDOVER Budget Worksheet - 2019 Function: Public Works Street Signs - 43300 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2013 2014 2015 2016 2017 2018 2018 2019 Salaries & Benefits 60110 Salaries -Regular 95,532 100,726 124,450 109,354 119,918 62,433 62,433 64,214 60210 FICA 5,777 5,943 7,391 6,806 7,302 3,871 3,871 3,981 60220 Medicare 1,353 1,391 1,729 1,598 1,708 905 905 931 60310 Health Insurance 9,439 9,805 11,752 11,181 11,893 7,500 7,500 9,000 60320 Dental Insurance 660 635 737 698 748 542 542 550 60330 Life Insurance 19 19 20 18 19 20 20 20 60340 Long -Term Disability 242 243 249 248 264 162 162 167 60410 PERA 6,564 6,744 8,128 8,061 8,393 4,682 4,682 4,816 60520 Workers Comp 1,356 1,402 1,437 2,812 4,388 2,248 2,248 2,312 60990 Inter -City Labor Allocation - - - 75,377 75,377 78,262 Salaries & Benefits 120,942 126,908 155,893 140,776 154,633 157,740 157,740 164,253 Departmental 61005 Supplies- General 990 130 - - 48 100 100 100 61020 Supplies - Operating 4,571 7,712 3,481 1,836 3,957 5,000 5,000 5,000 61030 Supplies - Signs 20,394 31,955 29,658 9,706 40,098 37,500 37,500 40,000 61105 R & M Supplies - General 991 92 857 593 1,016 1,000 1,000 1,000 61220 Software - 6,670 - - - - - - 61310 Meals/Lodging - 227 287 49 - 500 500 500 61315 Continuing Education 150 420 - - 200 500 500 500 61320 Annual Dues / Licenses 75 174 158 158 79 710 710 710 61325 Subscriptions publications 87 - - - - - - - 61410 Transportation/Mileage - - - 50 50 50 Departmental 27,258 47,380 34,441 12,342 45,398 45,360 45,360 47,860 Operating 62030 Telephone 240 726 885 888 866 500 500 500 62100 Insurance 228 228 235 235 235 235 235 235 62205 Central Equipment Services 11,593 11,593 11,941 11,941 11,583 11,583 11,583 11,583 62305 Software Maintenance Contract! 2,600 1,100 1,100 1,100 1,825 2,500 2,500 2,500 Operating 14,661 13,647 14,161 14,164 14,509 14,818 14,818 14,818 Professional Services 63100 R & M Labor - General - - 1,500 1,500 1,500 Professional Services - - 1,500 1,500 1,500 Capital Outlay 65600 Equipment - - - - Capital Outlay - - - - Total 162,861 187,935 204,495 167,282 214,540 219,418 219,418 228,431 8/24/2018 56 57 8/24/2018 CM OF ANDOVER Budget Worksheet -2019 Function: Public Works Traffic Signals - 43400 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2013 2014 2015 2016 2017 2018 2018 2019 Operating 62005 Electric 9,765 10,249 11,086 11,684 12,184 13,500 13,500 14,000 62300 Equipment Maintenance Contra. 9,940 10,050 10,298 10,381 10,661 13,500 13,500 13,500 Operating 19,705 20,299 21,384 22,065 22,845 27,000 27,000 27,500 Professional Services 63100 R&MLabor -General 6,536 14,602 8,786 5,854 13,306 10,000 10,000 12,000 Professional Services 6,536 14,602 8,786 5,854 13,306 10,000 10,000 12,000 Total 26,241 34,901 30,170 27,919 36,151 37,000 37,000 39,500 57 8/24/2018 Function: Public Works Account Number Description Operating 62005 Electric Operating Professional Services 63100 R&MLabor -General Professional Ser vices Total CITY OF ANDOVER Budget Worksheet -2019 m 8/24/2018 Street Lighting - 43500 Actual Actual Actual Actual Actual Budget Estimate Requested 2013 2014 2015 2016 2017 2018 2018 2019 31,702 32,646 30,664 37,089 27,596 40,000 40,000 40,000 31,702 32,646 30,664 37,089 27,596 40,000 40,000 40,000 - - - 139 400 400 400 - - - 139 400 400 400 31,702 32,646 30,664 37,089 27,735 40,400 40,400 40,400 m 8/24/2018 8/24/2018 59 CITY OF ANDOVER Budget Worksheet -2019 Function: Public Works Street Lights Billed - 43600 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2013 2014 2015 2016 2017 2018 2018 2019 Operating 62005 Electric 181,812 177,455 177,595 175,529 119,441 187,500 140,000 147,500 Operating 181,812 177,455 177,595 175,529 119,441 187,500 140,000 147,500 Professional Services 63010 Contractual Services 28,519 25,693 23,905 24,980 25,010 33,000 33,000 33,000 Professional Services 28,519 25,693 23,905 24,980 25,010 33,000 33,000 33,000 Total 210,331 203,148 201,500 200,509 144,451 220,500 173,000 180,500 8/24/2018 59 8/24/2018 60 CITY OF ANDOVER Budget Worksheet - 2019 Function: Public Works Parks & Recreation - 45000 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2013 2014 2015 2016 2017 2018 2018 2019 Salaries & Benefits 60110 Salaries - Regular 472,900 509,919 575,563 590,583 603,077 550,109 550,109 560,519 60140 Salaries - Council/ Comnissiot 31660 3,640 3,720 3,410 31340 3,600 3,600 3,600 60210 FICA 28,151 30,190 34,332 35,976 35,632 34,331 34,331 34,973 60220 Medicare 6,586 7,062 8,030 8,420 8,333 8,028 8,028 8,181 60310 Health Insurance 68,325 78,017 91,626 99,766 100,541 89,480 89,480 95,600 60320 Dental Insurance 3,059 3,188 3,775 3,742 3,876 3,794 3,794 3,850 60330 Life Insurance 103 105 108 103 106 160 160 160 60340 Long -Term Disability 1,183 1,246 1,207 1,287 1,361 1,328 1,328 1,354 60410 PERA 32,622 34,360 40,390 41,619 41,951 41,256 41,256 42,038 60520 Workers Comp 10,838 12,319 12,746 15,636 22,068 19,805 19,805 20,180 60990 Inter -City Labor Allocation 71,323 71,323 76,774 Salaries & Benefits 627,427 680,046 771,497 800,542 820,285 823,214 823,214 847,229 Departmental 61005 Supplies -General 377 799 631 423 661 - - - 61020 Supplies -Operating 29,919 19,133 32,733 21,651 28,049 32,500 32,500 37,000 61025 Supplies -Cleaning 255 755 349 786 11708 3,000 3,000 3,000 61105 R & M Supplies- General 11,413 9,557 9,919 11,910 6,562 12,000 12,000 15,000 61130 R & M Supplies -Landscape 25,326 41,006 43,670 37,103 30,033 37,500 37,500 37,500 61205 Small & Expend - Small Tools 1,621 907 5,611 2,108 3,322 5,000 5,000 6,000 61220 Software - - - 5,160 761 4,000 4,000 4,000 61310 Meals/Lodging - - - - 40 100 100 100 61315 Continuing Education 200 1,405 1,880 1,100 1,738 2,000 2,000 2,000 61320 Annual Dues/Licenses 262 182 188 239 350 400 400 400 61405 Postage 246 148 172 125 133 700 700 700 61410 Transportation/Mileage 112 245 36 48 200 200 200 Departmental 69,619 74,004 95,398 80,641 73,405 97,400 97,400 105,900 Operating 62005 Electric 42,266 41,280 44,070 39,893 52,140 50,000 50,000 50,000 62010 Water&Sewer Service 33,848 22,082 36,557 30,279 34,339 38,000 38,000 38,000 62015 Natural Gas 386 624 391 354 368 1,200 1,200 1,200 62020 Refuse Collection 11,891 8,218 10,213 10,128 9,774 10,500 10,500 10,500 62025 Storm Water Utility Charge 918 739 1,280 1,086 1,139 1,200 1,200 1,200 62030 Telephone 2,477 3,557 4,207 4,138 4,825 5,000 5,000 6,500 62100 Insurance 13,193 13,193 13,589 13,589 13,589 13,589 13,589 13,589 62200 Rentals 14,827 11,023 16,031 12,612 9,521 16,000 16,000 16,000 62205 Central Equipment Services 80,334 80,334 82,744 82,744 79,292 79,292 79,292 79,292 62305 Software Maintenance Contract 1,827 Operating 200,140 181,050 209,082 194,823 206,814 214,781 214,781 216,281 Professional Services 63005 Professional Services 2,544 4,245 3,032 2,267 3,018 4,000 4,000 4,000 63010 Contractual Services 33,728 45,217 53,428 33,908 29,303 38,000 44,000 39,900 63100 R & M Labor - General 13,087 24,811 18,877 8,519 (375) 20,000 20,000 20,000 Professional Services 49,359 74,273 75,337 44,694 31,946 62,000 68,000 63,900 Capital Outlay 65300 Improvements 126,801 74,910 100,000 115,000 120,000 Capital Outlay 126,801 74,910 100,000 115,000 120,000 Total 946,545 1,009,373 1,151,314 1,247,501 1,207,360 1,297,395 1,318,395 1,353,310 8/24/2018 60 CITY OF ANDOVER Budget Worksheet -2019 Function: Public Works Natural Resource Preservation - 45500 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2013 2014 2015 2016 2017 2018 2018 2019 Salaries & Benefits 60110 Salaries - Regular - - - - - - - - 60210 FICA - - - - - - - - 60220 Medicare - - - - - - - - 60310 Health Insurance - - - 50 5 - - - 60320 Dental Insurance - - - - - - - - 60330 Life Insurance - - - - - - - - 60340 Long -Term Disability - - - - - - - - 60410 PERA - - - - - - - - - 60520 Workers Comp - - - - - - - - 60990 Inter -City Labor Allocation 1,604 1,604 1,661 Salaries&Benefits 50 5 1,604 1,604 1,661 Departmental 61020 Supplies -Operating - - - - - - - - 61105 R & M Supplies - General - - - - - - - - 61130 R & M Supplies - Landscape 1,000 1,174 2,500 2,500 2,500 Departmental 1,000 1,174 2,500 2,500 2,500 Operating 62200 Rentals - - - - - - - - 62205 Central Equipment Services 970 970 970 970 Operating 970 970 970 970 Professional Services 63005 Professional Services - - - - 1,260 2,000 5,500 2,000 63010 Contractual Services - - - 6,205 3,094 4,500 4,500 7,000 63100 R & M Labor - General Professional Services - 6,205 4,354 6,500 10,000 9,000 Total 7,255 6,503 11,574 15,074 14,131 61 Function: Public Works Account Actual Number Description 2013 Departmental 61005 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 62205 Salaries & Benefits Departmental 61005 Supplies - General 61020 Supplies - Operating 61310 Meals / Lodging 61315 Continuing Education 61320 Annual Dues / Licenses 61405 Postage 61410 Transportation/Mileage 1,465 Departmental 865 Operating 62005 Electric 62020 Refuse Collection 62205 Central Equipment Services 7,911 Operating 1,649 Professional Services 63010 Contractual Services 63025 Publishing 63100 R & M Labor - General 112 Professional Services 182 Capital Outlay 65200 Building 65300 Improvements 4 Capital Outlay 5 Total CITY OF ANDOVER Budget Worksheet -2019 Actual Actual Actual Actual 2014 2015 2016 2017 Recycling - 46000 Budget Estimate Requested 2018 2018 2019 62,019 43,331 39,831 38,588 59,399 23,629 23,629 24,936 3,700 2,527 2,356 2,392 3,327 1,465 1,465 1,546 865 591 551 559 778 343 343 362 7,911 6,188 1,649 1,065 3,088 - - _ 551 376 112 105 182 - - _ 16 11 4 3 5 20 20 20 171 115 40 31 60 61 61 65 4,478 3,120 1,239 1,185 3,952 1,772 1,772 1,870 1,262 1,280 1,318 1,022 2,174 851 851 898 - - - - 37,819 37,819 40,158 80,973 57,539 47,100 44,950 72,965 65,960 65,960 69,855 94 397 119 121 309 300 300 300 1,219 2,766 2,363 1,176 993 3,000 3,000 3,000 - 257 69 51 15 150 150 150 285 - 40 295 - - _ _ 220 185 150 35 150 1,000 1,000 1,000 3,468 1,646 1,814 3,418 3,625 3,000 3,000 3,000 281 655 - 480 425 425 425 5,567 5,906 4,555 5,576 5,092 7,875 7,875 7,875 - 414 469 485 474 - - _ 2,247 2,163 1,891 3,442 8,352 2,200 2,200 10,000 661 661 681 681 681 681 681 681 2,908 3,238 3,041 4,608 9,507 2,881 2,881 10,681 32,645 43,545 65,843 59,899 74,772 70,000 70,000 70,000 1,503 842 7,497 9,827 7,620 10,000 10,000 10,000 - 2,832 - 500 500 500 34,148 47,219 73,340 69,726 82,392 80,500 80,500 80,500 54,514 54,514 178,110 113,902 128,036 124,860 169,956 157,216 157,216 168,911 62 8/24/2018 63 CITY OF ANDOVER Budget Worksheet-2019 Function: Other Other Rollup " Account Actual Actual Actual Actual Actual Budget Estimate Requested ` Number Description 2013 2014 2015 2016 2017 2018 2018 2019 Professional Services 63900 Miscellaneous 42,465 44,152 31,342 20,824 4,525 30,100 7,500 30,100 63905 Contingency 33,045 37,033 25,378 12,253 10,350 40,328 22,500 90,328 Professional Services 75,510 81,185 56,720 33,077 14,875 70,428 30,000 120,428 Other Financing Uses 67101 Operating Trapsfers Out 135,000 - 200,000 250,000 750,000 . Other Financing Uses 135,000 200,000 250,000 750,000 Total 210,510 81,185256,720 283,077 764,875 70,428 30,000 120,428 63 CITY OF ANDOVER Budget Worksheet - 2019 Function: Other Unallocated- 49100 Account Actual Actual Actual Actual Actual Budget Estimate Requested Number Description 2013 2014 2015 2016 2017 2018 2018 2019 Professional Services 63900 Miscellaneous 42,465 44,152 31,342 20,824 4,525 30,100 7,500 30,100 63905 Contingency 33,045 37,033 25,378 12,253 10,350 40,328 22,500 90,328 Professional Services 75,510 81,185 56,720 33,077 14,875 70,428 30,000 120,428 Other Financing Uses 67101 Operating Transfers Out 135,000 - 200,000 250,000 750,000 - Other Financing Uses 135,000 200,000 250,000 750,000 - - Total 210,510 81,185 256,720 283,077 764,875 70,428 30,000 120,428 8/24/2018 64 / • 'kms`^` i 1685 CROSSTOWN BOULEVARD N.W. • ANDOVER, MINNESOTA 55304 • (763) 755-5100 FAX (763) 755-8923 • WWW.CI.ANDOVER.MN.US TO: FROM: SUBJECT: DATE: Mayor and Councilmembers Jim Dickinson, City Administrator Preview 2019 Preliminary Tax Levy September 4, 2018 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 28th Council workshop 2019 Budget Proposal discussion. This memo and attachments are assuming a 5.53 % gross levy increase that will be presented at the August 28th Council workshop and is subiect to change. The 2019 Preliminary Levy certification would be the outcome of the numerous budget workshops held with the Council over the summer. The Preliminary 2019 Budget proposes a total property tax levy of $13,103,487: $8,945,970 (68.27%) operational levy, $2,115,729 (16.15%) debt service levy, and $2,041,788 (15.58%) capital/watershed levy. The 2019 Proposed Property Tax Levy is estimated to increase the current City tax rate by 2.76%. That rate will be applied to the City's growing tax base and will reflect a 5.53% increase in the gross tax levy. The Council has the right to reduce or keep constant this levy until the final certification date of December 28, 2018. BUDGETIMPACT This is the first step in establishing the City of Andover property tax levy for 2019. 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 18th City Council meeting when staff anticipates requesting the 2019 Preliminary Tax Levy to be set by the City Council. Attachments: Resolution Adopting the Proposed 2019 Property Tax Levy CITY OF ANDOVER COUNTY OF ANOKA STATE OF MINNESOTA RES. NO. A RESOLUTION ADOPTING THE CITY OF ANDOVER 2019 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, 2018. NOW, THEREFORE, BE IT RESOLVED that the City Council of the City of Andover hereby adopts the proposed 2019 property tax levy totaling $13,103,487 as listed on Attachment A. Adopted by the City of Andover this 18th day of September 2018. ATTEST: Michelle Harmer—Deputy City Clerk CITY OF ANDOVER Julie Trude - 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 2019 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 18th day of September 2018. Michelle Hartner — Deputy City Clerk CITY OF ANDOVER, MINNESOTA Attachment A 2019 Proposed Property Tax Levy Proposed 2019 Levy General Fund Levy General Operations $ 8,845,970 Park RepaWReplacement Items 100,000 Total General Fund 8,945,970 Debt Service Funds. Levy 2010A G.O. Open Space Referendum Bonds 183,989 2012C Taxable G.O. Abatement Bonds 969,378 2014A G.O. Equipment Certificate 294,525 2016A G.O. Equipment Certificate 142,837 2019 Capital Improvements Bonds 525,000 Total Debt Service 2,115,729 Other Levies Capital Projects Levy Capital Equipment/Project 275,000 Capital Equipment Purchases - Facility Maintenance Reserve 355,000 Parks Projects 15,000 Road & Bridge 1,254,788 Pedestrian Trail Maintenance 102,000 Lower Rum River Watershed 40,000 Total Other 2,041,788 Gross City Levy $ 13,103,487