The URL can be used to link to this page

Home My WebLink AboutWK - June 28, 20221685 CROSSTOWN BOULEVARD N.W. • ANDOVER, MINNESOTA 55304 • (763) 755-5100 FAX (763) 755-8923 • WWW.ANDOVERMN.GOV City Council Workshop Tuesday, June 28, 2022 City Hall — Conference Rooms A & B 1. Call to Order— 6:00 p.m. 2. Joint Meeting with Park & Recreation Commission A. Discuss the 2023-2027 CIP for Playground Equipment Replacement for Parks B. Discuss the 2023-2027 CIP for New Trail Segment Improvements C. Discuss the 2023-2027 CIP for Trail Reconstruction Improvements in Parks D. Discuss the 2023-2027 CIP for Parks E. Other Business 3. Discuss Water Treatment Plant & Biological Water Treatment Study — Engineering 4. Discuss Proposed Improvements/Round Lake Boulevard NW (149th Avenue NW to 157th Avenue NW)/22-37 — Engineering 5. 2023-2025 CIP Development Update —Administration 6. 2023-2025 Budget Development Update - Administration 7. Other Topics S. Adjournment 1685 CROSSTOWN BOULEVARD N.W. • ANDOVER, MINNESOTA 55304 • (763) 755-5100 FAX (763) 755-8923 • WWW.ANDOVERMN.GOV TO: Mayor and City Council CC: FROM: SUBJECT: DATE: Jim Dickinson, City Administl David D. Berkowitz, Director Park and Recreation Commiss :ity Engineer D�3 Jason Baumunk, Parks & Streets Operations Manager 2A. Discuss the 2023-2027 Park Playground Equipment Replacement Plan June 28, 2022 INTRODUCTION This is an update regarding the 2023-2027 CIP for Park Playground Equipment Replacement Plan that has been recommended by the Park and Recreation Commission and Public Works staff. DISCUSSION Below are the proposed structures that are being recommended to be replaced as part of the 2023-2027 CIP. 2023 — Hills of Bunker Lake West Park (originally installed in 2004) and Hidden Creek East Park (originally installed in 2002). Proposed budget impact is $110,000. 2024 — Woodland Estates Park (originally installed in 2006), Oakview Park (originally installed in 2006) and Shady Knoll Park (originally installed in 2005). Staff is recommending increasing the proposed budget impact to $150,000. 2025 — Meadows of Round Lake Park (originally installed in 2008), Creekview Crossing Park (originally installed in 2007) and Oak Bluff Park (originally installed in 2006). Proposed budget impact is $150,000. 2026 — Country Oaks Park (originally installed in 2005), Fox Meadows Park (originally installed in 2006), Hidden Creek South Park (originally installed in 2006) and Woodland Crossing Park (originally installed in 2008). Proposed budget impact is $150,000. 2027 — Andover Station North (originally installed in 2008), Red Oaks West (originally installed in 1993, replaced in 2007) and Woodland Crossing (originally installed in 2008). Proposed budget impact is $150,000. Playground equipment replacement is typically based on condition, safety, handicap accessibility and requested changes due to age of the structure. Staff recommendation to meet these standards is to replace equipment on a 15 -year cycle, which is also the industry standard life expectancy of a structure. To meet this replacement standard, 3 structures need to be replaced each year based Mayor and Council Members June 28, 2022 Page 2 of 2 on the 42 playground structures that the City currently has in place. Currently there is $110,000 in the 2023 proposed operating budget. This would only replace 2 complete structures per year, which will drastically fall behind a reasonable replacement schedule. In the 2022-2026 CIP, City Council proposed replacing three playgrounds per year starting in 2024 Parks Maintenance Department will continue to review the playground structures from year to year and modify the replacement schedule as the condition of the structures change. BUDGETIMPACT Identified in the 2023-2027 CIP, $110,000 is to be allocated for 2023 which will cover 2 replacements. To get to 3 replacements per year, an additional $50,000 will be necessary ($150,000 total) each year starting in 2024. With the rising cost of equipment and supplies (concrete borders, wood chips, etc.), $150,000 will need to be re-evaluated if three playgrounds are to continue to be replaced each year. The Finance Department has indicated to Staff that the recommended $150,000 per year starting in 2024 cannot be supported by the current General Fund and that the operating levy would need to be increased. The Park and Recreation Commission will continue evaluating the option of phasing out certain playground structures in smaller parks located in the rural areas. In past experience, this has not been a viable option. Attached are the Park and Recreation Commission meeting minutes discussing the 2023-2027 Playground Equipment CIP and a list of playgrounds with installation dates, age, replacement dates, and proposed replacement schedule. ACTION REQUIRED The City Council is requested to review the proposed 2023-2027 CIP for Park Playground Equipment Replacement Plan and determine if any changes should be made. Respectfully submitted, Jason Baumunk Attachments: Spreadsheet of Playground and Play Structures Installed by Age, Meeting Minutes from 4/7/22 and 4/21/22. ✓ Play Structures and Playgrounds Installed Age Park Name Years Replaced, Refurbished or Removed Notes 20 Hidden Creek East 1992 2002 2015 (Partial) 2023 2015: New border & wood chips 18 Hills of Bunker Lake West 1988 2004 2023 17 Shady Knoll 1989 2005 (2024) 17 Country Oaks 2005 2026 2005: New Park 16 Fox Meadows 1991 2006 2026 16 Woodland Estates 2006 2024 2006: New Park 16 Hidden Creek South 1988 2006 2026 16 Oak View 2006 (2024) 2006: New Park 35 Red Oaks West 1993 2007 15 Creekview Crossing 1992 1993 2007 2025 14 Andover Station North 2008 2008: New Park 14 Meadows of Round Lake 1995 1997 2008 2025 14 Oak Bluff 1991 1998 2008 2025 14 Woodland Crossing 2008 2008: New Park 13 Meadowood North 2009 12 Sophie's 2010 2010: New Park 11 Timber Trails 1996 2011 11 Nordeen's 1997 2011 10 Hickory Meadows 2012 2012: New Park 10 Pleasant Oaks 1984 1996 2012 9 Green Acres 1983 1998 2013 9 Northwoods East 1983 1998 2013 8 Langseth 1979 1999 2014 7 Pine Hills North 2015 2015: New Park 7 Timber Rivers 1999 2000 2015 6 Maple View 2016 2016: New Park 6 Forest Meadows 1987 Removed 2001 2016 5 Andover Lions 1998 2017 5 Chesterton 2000 2017 5 Shadowbrook East 2002 2017 4 Pine Hills South 1979 2000 2018 (Refurb.) 2018: Refurbished 3 City Hall (Purple Park) 1996 2001 2019 2019: New 2 Hidden Creek North 1988 1991,'95(Partial) 2000 2005 (Partial) 2020: Full Replacement 1 Hawkridge 1988 2003 2021 2021:New Border/Structure/Chips I Sunshine 2000 2009 (Partial) 2021 2000: Kidtime unit installed 2009: Swings, Digger, Spring Toys 1 Woodland Meadows 1995 2021 2021:New Structures 1 Wild Iris 7987 2003 2021 N- .. .. PrelrkKnoll 1988 2005 (2022) (2022) - - -. Rose 1987 2004 -, - - - 2002 2020 2020 Downsized -Re Structure. 2022 -added small structure back. = Complete Rebuild Tot Lot 138th 1985 2003 2009 (Partial) Possible Refurbishment REMOVALS Current CIP _ 1 Crooked Lake Boat Landing 1982 Removed 1999 2 Creekridge 1990 Removed 2001 _ 3 Northwoods West 1979 Removed 2004 Andover Park & Recreation Commission Workshop Meeting Minutes —April 7, 2022 Page 1 UPDATE OF 2023-2027 PARK PLAYGROUND EQUIPMENT PLAN Parks and Streets Operations Manager Baumunk gave the Commission and update of what Playground equipment staff thought should be replaced over the next five years. Their Consensus was to keep the same playgrounds listed in the current CIP and add Andover Station North, Red Oaks West, and Woodland Crossings for replacement in 2027. Baumunk also stated that there is currently $50,000 average budgeted for each playground Replacement and that number might have to be raised soon due to rising prices. Chair Lindahl agreed with staff recommendations and stated they support the playground inspectors and staff's recommendations. Regular Andover Park & Recreation Commission Meeting Minutes —April 21, 2022 Page I RECOMMEND 2023-2027 PARK PLAYGROUND EQUIPMENT REPLACMENT PLAN The Park and Recreation Commission is requested to review and make a recommendation to the City Council for the 2023-2027 Park Playground Equipment Replacement Plan. Parks & Streets Operations Manager Baumunk explained that staff has completed playground inspections and is recommending parks for playground replacement. Vice -Chairperson Widmyer asked if things would need to be moved around as in the past. Mr. Baumunk stated staff are comfortable with the list and the parks identified need replacement. Motion by Stenzel, seconded by Newton, to recommend the 2023-2027 Park Playground Equipment Plan to the City Council. Motion passed 5 ayes, 2 absent (Lindahl and Strombeck). C I T Y O F ,ND OVE 1685 CROSSTOWN BOULEVARD N.W. • ANDOVER, MINNESOTA 55304 . (763) 755-510 FAX (763) 755-8923 • WWW.ANDOVERMN.GOV TO: CC: FROM: SUBJECT: DATE: Mayor and Council Members Jim Dickinson, City Administrate David D. Berkowitz, City Engin er/Dir or of Public Works�� Park and Recreation Commission mb rs Jason Baumunk, Parks & Streets Operations Manager 213. Discuss the 2023-2027 CIP for New Trail Segment Improvements - Engineering June 28, 2022 INTRODUCTION This is an update regarding the 2023-2027 CIP for New Trail Segments Improvements. DISCUSSION Below are the following segments that were discussed at the 2021 joint meeting. Segments 2, 3 and 4 were identified by the City Council in the 2022-2026 CIP. Segment 1 was extended to begin at Bluebird St instead of Xeon as previously identified. Segment 1 — 8' Bit. Trail along Crosstown Blvd from Bluebird Street NW to Prairie Rd on the south side of Crosstown Blvd. 8' Bit. Trail along Crosstown Blvd from 157`" Avenue to 159`h Avenue constructed on the east side of Crosstown Blvd. *Preliminarily design for this segment has begun. ($1,350,000) Segment 2 — 8' Bit. Trail along Station Parkway from Thrush Street to Partridge Circle 8' Bit. Trail along Station Parkway from Partridge Street to Jay St. ($55,000) • Segment 3 — 8' Bit. Trail along Verdin Street NW from 1615 Avenue to 163`d Lane. ($88,000) Segment 4 — 8' Bit. Trail along Coon Creek from Prairie Road going east to the existing trail in the Shadowbrook North development. This project would likely be eligible for MN DNR funding. ($380,000) Mayor and Council Members June 28, 2022 Page 2 of 2 A copy of the trail map identifying the segments is included with this item. The Park and Recreation Commission meeting minutes discussing the 2023-2027 CIP for New Trails Segments are also attached. The funding for the trail/sidewalk improvements have been a combination of DNR Grants, general funds, and trail funds that have been received from new developments. ACTION REQUIRED The City Council is requested to review the proposed 2023-2027 CIP for New Trail Segments Improvements and determine if any changes should be made. Respectfully submitt , Jason Baumunk Attachment: Trail Map with Proposed SegmentsMeeting Minutes from 4/7/22, 4/21/22, 5/5/22 and 5/19/22 Trail Map Legend Paved Trail Underpass Bunker Under c i z v O FI� NDOVEThis map is provided by the City of Andover to guide people in the enjoyment Proposed Trail Railroad of our trails when walking, running, rolling or biking. Trails displayed consist of paved and unpaved surfaces. Paved surface trails are blacktop and sidewalks. Unpaved surface trails are wood chips, soil or sand. Nat all surrounding trails are shown. Trail distances are approximate. Unpaved Trail — Sidewalk Trails — County Trails 14 Andover Schools Water dF Parks Oisl®Imm: no command has been conrygel using Information p 9mo d eom xadme government sources and b to be used for reference residents only. Every effort hes been made to orders Ne complemented and, a=mq of dommam. no cry ofnndowr does not remsent that me data can be used for exact measurement d elAenm or dbedkn or p Oslon Inthede*tiwofgec mMicfeaturesifanorsordbuepandes de fount, passe road (703) 1555100. Andover Park & Recreation Commission Workshop Meeting Minutes —April 7, 2022 Page 1 DISCUSS 2023-2027 TRAIL CAPITIAL IMPROVEMENT PLAN The suggested new trail segments listed in the current CIP were reviewed. A group from the Catchers Creek East and Shadowbrook North developments were present to speak about the trail segment #4 which runs from Prairie Road along the north side of Coon Creek to the Shadow Brook North development. Karen Murphy, 100 144' ave nw, in Catchers Creek East, spoke about the need for a trail connection for the neighborhood. She expressed concern due to there being no way to get out of the neighborhood other that traveling along Andover Blvd where there is limited shoulder. She also requested that is the trail connection cannot be completed from the neighborhood to Prairie Rd if it would be possible to complete the bridge across Coon Creek to connect to Shadowbrook 5`" Addition on the south side of the creek. Multiple residents from the group came forward to express their concerns and for the need of a trail connection out of the neighborhood. Chairperson Lindahl stated they understand the groups concern. It was discussed that the Park and Recreation Commission doesn't have control over trails, that they make recommendations to the City Council and advised that there is not money budgeted right away for this trail segment. He suggested that the group might want to approach City Council with their concern. Parks and Streets Operation Manager Baumunk explained to the group the process the new trails are built. The new trail segment that are identified in the CIP currently are there because there is a need for them, the same needs that the group is expressing about trail segment they are requesting get built. Many of these trails have been on the plan for several years. It was asked about the possibility of adding a trail in the right of way along Andover Boulevard. It was explained to the group that Anoka County would have to be involved with that process, and a trail would have to be far enough off the roadway for safety that there might not even be room for one. Baumunk explained to the group where we are in the CIP process. That this was just an initial meeting for the year to start the process of determining what will be recommended to City Council for approval for the 2023-2027 CIP plan. Andover Park & Recreation Commission Workshop Meeting Minutes—April 21, 2022 Page 1 DISCUSS 2023-2027 TRAIL CAPITAL IMPROVEMENT PLAN The Park and Recreation Commission is requested to review and discuss the Trail Capital Improvement Plan (CIP). Mr. Baumunk stated he checked into grants for Safer Routes to School and found the City does not qualify for it. Mr. Baumunk researched the Trail Connection Grant and found that the goal is to construct a trail that connects where people live to a significant resource. The Park and Recreation Commission discussed a trail in the Catchers Creek East Development and staff have not heard back from the Mohlencamp family for an easement. The Park and Recreation Commission discussed alternative trail options for this neighborhood. The Park and Recreation Commission discussed the importance of trails, trail connections, and having a trail Master Plan. Andover Park & Recreation Commission Workshop Meeting Minutes — May 5, 2022 Page 2 DISCUSS 2023-2027 TRAIL CAPITAL IMPROVEMENT PLAN The Park and Recreation Commission is requested to continue discussion on the Trail Capital Improvement Plan (CIP). Mr. Baumunk requested the Commission to prioritize the trail segments. The Commission discussed the Trails CIP and recommended the following changes: Segment 1 — no change Segment 2 • Did not believe there should be a trail on each side of Station Parkway • Partridge to Thrush and Partridge to Jay • Reached consensus to put a trail in west to Quinn • Look into a crosswalk to get to the trail on the north side of Station Parkway Segment 3 • Needs to be a boardwalk Segment 4 • Bridge can be built around $150,000 across the creek The Commission discussed raising the trail dedication fee. Staff will update the Trails CIP and bring it to the Commission for their recommendation at the next meeting. Regular Andover Park & Recreation Commission Meeting Minutes —May 19, 2022 Page 2 RECOMMEND 2023-2027 TRAIL CAPITAL IMPROVEMENT PLAN The Park and Recreation Commission is requested to review the 2023-2027 Trail Capital Improvement Plan and make a recommendation to City Council. Parks & Streets Operations Manager Baumunk presented the plan as reviewed by the Commission at the last meeting. Motion by Stenzel, seconded by Strombeck, to recommend approval of the 2023-2027 Trail Capital Improvement Plan. Motion passed 6 ayes, 1 absent (Newton). Projected Sources of Revenue platted units Trail Fee - $900 ARPA Funds Land Sale Operating Transfer In Total Revenues Available Projected Commitments Railroad Underpass Trail 8' Bituminous Trail along Crosstown Blvd - Xeon St to railroad tracks Railroad tracks to 157th Ave 157th Ave to 159th Ave 8' Bituminous Trail along Station Parkway - Thrush St to Partridge Circle Partridge St to Hanson Blvd 8' Bituminous Trail along Verdin St - 161 at Ave to 163rd Lane 8' Bituminous Trail along Coon Creek - East to existing trail in Shadowbrook development Total Commitments Revenues Over (Under) Expenditures Fund Balance as of December 31, 2021 Fund Balance Brought Forward Ending Fund Balance CITY OF ANDOVER Trail Fund Projected Fund Balance Estimate 2022 2023 2024 2025 2026 2027 TOTALS 50 50 25 25 25 25 $ 238,008 $ 45,000 $ 22,500 $ 22,500 $ 22,500 $ 22,500 $ 373,008 - 350,000 - - - - 350,000 113,709 - - - - - 113,709 351,717 395,000 22,500 22,500 22,500 22,500 836,717 320,000 575,000 455,000 55,000 88,000 705,000 340,000 1,350,000 143,000 705,000 340,000 351,717 (955,000) (120,500) (682,500) (317,500) 22,500 249,245 600,962 (354,038) (474,538) (1,157,038) (1,474,538) $ 600,962 $ (354,038) $ (474,538)$ (1,157,038) $ (1,474,538) _L_1 'Target -10% of current years commitments to create a contingency for any project overages. " It is anticipated that all projects will not be fully expended by the end of the year, and future projects will be contingent on additional revenues. 320,000 575,000 455,000 55,000 88,000 705,000 340,000 2,538,000 CI T Y O F NDOVE • 1685 CROSSTOWN BOULEVARD N.W. • ANDOVER, MINNESOTA 55304 • (763) 755-5100 FAX (763) 755-8923 • WWW.ANDOVERMN.GOV TO: Mayor and Council Members CC: Jim Dickinson, City Administratk/Dire David D. Berkowitz, City Enginf Public WorksD3 Park and Recreation Commissio FROM: Jason Baumunk, Parks & Streets Operations Manager SUBJECT: 2C. Discuss the 2023-2027 CIP for Trail Reconstruction Improvements in Parks - Engineering DATE: June 28, 2022 INTRODUCTION This is an update regarding the 2023-2027 CIP for Trail Reconstruction Improvements in Parks. DISCUSSION The trail reconstruction and improvement planned over the next 5 years are as follows: 2023 — Kelsey Round Lake Park Boardwalk Reconstruction. Staff received approval from the Mn DNR Outdoor Recreation Grant Program for the reconstruction of the boardwalk in 2023. Total cost $230,875 Mn DNR Grant - $105,875 City of Andover - $125,000. (Possibly ARPA Funds) • 2025-2026 Kelsey Round Lake Park Trail Reconstruction. Staff will determine timing of replacement and apply for funding through the Mn DNR grant program. ($500,000) No other park trails have been identified for now. Potential projects will be based on annual condition inspections. The funding of these trail projects will come from a combination of Grants, Capital Equipment Reserve, General Fund and/or Road & Bridge Funds. ACTION REQUIRED The City Council is requested to review the proposed 2023-2027 CIP for Trail Reconstruction Improvements in Parks and determine if any changes should be made. Respectfully submitted, -moi 11`�a Qu'h� Jason Baumunk C I T Y O F ND1 1685 CROSSTOWN BOULEVARD N.W. • ANDOVER, MINNESOTA 55304 • (763) 755-5100 FAX (763) 755-8923 • WWW.ANDOVERMN.GOV TO: Mayor and Council Members ' CC: Jim Dickinson, City Administrator David D. Berkowitz, City Engineer 're for of Public Works��3 Park and Recreation Commission Mem rs FROM: Jason Baumunk, Parks & Streets Operations Manager SUBJECT: 2D. Discuss the 2023-2027 CIP for Parks - Engineering DATE: June 28, 2022 The City Council is requested to review the proposed 2023-2027 CIP for Parks as recommended by the Park and Recreation Commission. DISCUSSION The Park and Recreation Commission discussed items from the Future Facilities List identified in the most current Park Dedication Study, with an emphasis on finishing Master Plan items for Pine Hills North Park and Kelsey Round Lake Park. Both Parks have a building with bathrooms and a shelter identified as future improvements. Both improvements are included in the recommend 2023-2027 CIP The warming house building at Prairie Knoll Park needs a remodel and expansion, or total replacement. Andover Football Association (AFA) has expressed interest in participating in the project over the last two years. Their original intention was to manage the project themselves including putting together plans, coordinating the work and financial contributions. This has proven difficult and in discussions with AFA and the Park and Recreation Commission it is recommended that the City would oversee design and construction of the project. The Park and Recreation Commission and Staff see this as an opportunity to impact three of our large Community Parks with the addition of these facilities. These improvements would include bathroom facilities on timed locks that are available for all park users during normal operating hours, shelters with reservable space for gatherings or events with all three to have a similar aesthetic design to create a signature look in our parks that could extended to future additions. Attached is an example showing Elk Rivers common theme for shelters. The Park and Recreation Commission wanted to commit to projects in Zone C and Zone A in years four and five of the CIP. Refer to the attached map for Park Zone locations. These projects will be identified as they get closer based on need and public input. Mayor and Council Members June 28, 2022 Page 2 of 3 Listed below are the projects identified by the Park and Recreation Commission based on the commitment of Park Dedication contribution to the Andover Community Center (ACC) of $200,000. 2023 Lunds North Park -- $50,000. The Park and Recreation Commission recently reviewed a request from the neighborhood for the installation of new playground equipment. Currently the park does not have any equipment. Design of Prairie Knoll Park Building/Warming House - $50,000. The existing warming house area is small. With the new residential area to the north developing within the next few years, it is anticipated there will be more users of the park during the winter months and with already very limited space for the hockey teams to get dressed for practices, the warming house needs to be expanded. Needs to be determined if an expansion is possible or should the entire building be replaced to accommodate the space needs. AFA has expressed interest to contribute to the project as this is their primary storage space for equipment and need more space than what they currently have. Financial commitment amount TBD Design of Pine Hills North Multipurpose Building with Shelter - $50,000. The Master Plan calls for a multipurpose building with integrated group shelter, bathrooms, concession space and storage space. The plan also calls for a separate storage building to be used by athletic associations. Staff met with Boreal Football Club (BFC), the primary user of the athletic fields at Pine Hills North and determined there is no need for concessions at the facility. It was also determined we would be better suited to add the necessary storage space they would need to the multipurpose building. They have committed $25,000 towards that storage space. Hidden Creek North Park/New Medium Shelter -- $40,000. The park is considered an urban neighborhood park with an existing baseball and soccer fields along with new playground equipment. Since this an active park, the Park and Recreation Commission is recommending the installation of a new shelter. • Annual Misc. Projects - $25,000 • Contribution to ACC -$200,000 2024 • Construction of Prairie Knoll Building/Warming House Expansion/Replacement $150,000 • Construction of Pine Hills North Multipurpose Building - $350,000 • Annual Misc. Proiects - $25,000 • Contribution to ACC - $200,000 2025 • Park at Fields at Winslow Cove - $150,000. This is a new park that is identified in the development plans. • Kelsey Round Lake Park Shelter with Bathrooms Design - $50,000 • Annual Misc. Projects - $25,000 • Contribution to ACC - $59,108. Final payment for the ACC expansion contribution. Mayor and Council Members June 28, 2022 Page 3 of 3 2026 2027 Zone C Proiects TBD - $150,000 Annual Misc. Projects - $25,000 Zone A Projects TBD - $150,000 Annual Misc. Projects - $25,000 The Purposed 2023-2027 Park Capital Improvement Plan and the Park Improvement Projected Fund Balance spreadsheet is attached for your review identifying projects listed above. Minutes from 2022 Park & Recreation Meetings discussing the 2023-2027 Park Improvement CIP are also attached. ACTION REQUIRED The City Council is requested to review the proposed 2023-2027 CIP for Parks as recommended by the Park and Recreation Commission and determine if changes should be considered. Respectfully submitt Jason Baumunk Attachment: Examples of similar aesthetic design building/shelter from Elk River Park Zone Location Map-,1froposed 2023-2027 Park Capital Improvement Plan, Bark Improvement Projected Fund Balance spreadshe inutes from Park Capital Improvement Discussions from 4/7/22, 4/21/22, 5/5/22, and 5/19/22 y 40- 47e-,-;. I ivIll , Mm'" 1 ELEMENTS INDIAN TRI BES FL 0 H R BIR DS TR l 1 7A� -9A I OAL © 5.A . -2A' U" 1A 12A -V A 4A L� 27B I 19B� , i �.. 216 L._ r WARDI 13A,4 /26B A L K LEEMAEMAN I 28B _ + 1 1 228 6A I 20B i r 8A 2� 56,,'� I _ 246 a I r , 360 37C i 39Cj i ROUND LA KF7 38C _ • d �, 32C r Map Sources: City of Andover Engineering Department City of Andover GIS Anoka County GIS Office Anoka Couny Assessor's Office Map Update Date: 4/26/2017 Scale. 1 inch = 3.452 feet 3C UZU_ \ 9 41CI40� `44C i 31 Com) 340 47C Is' ( 351 L I T) O F NDOVE PARKS & TRAILS MAP L E G E N D ® Parks /V bituminous ^� sidewalk ace ^� gravel Park Zone ~naturetlail Pazk Number OS bikew:ry A City Features I/V county City Map Key for Parks & City Features Park 9 Park or Oeur Feature Park Typo Park Address A0r•• Tobaom F. 1A CEOARCREST PARK 3680173RDLANENW 348 2.76 M CEDARCRESt ESTATE PARK 39091T4THAVENUENW 0.88 2.51 3A FOX MEADOWS PARK 16000 f'O%ST.NW 1236 X M RAWK RmGE PARK 18001 VERDIN ST. NW 13.14 x M LANGSE I PARK 3341174TH LANE NW 1.67 X SA LUNDS NORTH PARK 2640166TH AVE. NW 4.01 x 7A MARTINS MEADOWS PARK&MENSPACE 17101 NAVAJO ST. NW 74.11 x M PNTHOASSOUTH PARK 3536161STAVENW 5.08 X M TIMBER RIVERS PARK 16980 BARIUMST 6.78 X IRA TDIBERTRA65 PARK 17761 AZTEC Sr.NW 1.05 X 11A PINE Im3S NORTH PARK 3535161ST AVE. NW 4250 X 12A VALJ. VIEW PARK 3929169714 AVE. NW 8.86 2221140TH LANE NW 13A WImECAKS PARK 27401TLND AVE NW 914 3857143MAW 1RB BIRCHRDGE PARK 1450181ST AVE New 11.21 4635147TH LANE NW 20B CWMRYOAKS PARK 1065162ND SANE NW 1.10 x 21B FOREST MEADOWS PARK 1010179TH AVE. NW 6.63 x 228 NORTH WOODS PRESERVE OPEN SPACE 16347 HAMIXN BLVD. NW 20.62 X 238 OAK HOLLOW PARK a6515WH AVE. NW 5.89 U535 POPPY ST. NW 246 OAKVIEW PARK 15851 AVOCET ST NW 1.04 x 25B WOODLAND CROSSINGS PARK 15827 JAY ST.W. 531 X 288 WOODLIN (MEADOWS PARK 1139172ND AVE Nw R98 X 278 DALSKE WOODLANDS OPEN SPACE 400191ST AVE NW 39.45 22.16 28B MAPLE VIEW PARK AND WEN SPACE PAM &OPEN SPACE 125116M AVE NW 4437 X DC I18THAVE PARK M02139MAVE NW 0.40 x WC CREEKRIDGE PARK 1216SIXIMCOONCREEKDRNE 2.76 31CCROOKED LAKE BOUT LANDING PARK 2980 BUNKER SAKE BLVD. NW 2.51 K 326 DELNS PARK I4432 GUARANI ST. NW 2.32 33C GREENACRES PARK 141411 001)ST. NW 1.08 x 340 HIDDEN CREEKNORTH PARK 2620 BUNKER LAKE BLVD. NW 8.41 x 35C HIDDEN CREEK SOUTH PARK 11415 HIDDEN CREEK DR 0A2 x 36C KELSEY ROUND LAKE PARK 15521 M14A ST NW 152.56 X EA � ,. .. 37C MDOWOOD NORTH PARK 4519148TH AVE. NW 0.58 X 38C MEADOWOOD SOUTH PARK 4568147TH LANE NW 0.14 ,,. 39C MEADOws OF ROUND LAKE PARK 4040146TH LN. NW 0J7 X On NORTH WOODS EAST PARK 14035 YUKON ST.. NW 2.12 x _ 41C NORTH WOODS WEST PARK 2221140TH LANE NW 3.81 X 420 PLEASANT OAKS PARK 3857143MAW 20.29 X 43C RIVER TRAILS PARK 4635147TH LANE NW 12.85 44C ROSE PARK 14052 ROSE ST. NW 4.92 x ASC ROUND LAKE BOAT LANDING PARK 14601 ROUND LAKE BLVD. NW 131 49G STRCOTMAN PARK 4575154M AVE. NW 1137 x 47C TERRACE PARK U535 POPPY ST. NW 2.13 X ABC WILDOUS PARK 1219 BUNKER LAKE BLVD. NW 11.23 X 49C CRWJI(ED LAKE WARMING HOUSE A RINK FACILITY PARK 2939 BUNKER LAKE BLVD. NW 0.24 x 69D ANDOVER LIONS PARK BUNKERLAKE BLVD & SYCAMORE ST 19.04 X No ANOOVERSTATMINORTH PARK 1823119TH LN NW 22.16 X SID BUNKER (BLL REGIIXUL(CODNTY) PARK BDM(ER LUKE BLVD. NW 558.15 62D CHESTERTON COMMONS PARK 1414155TH AVE 0.61 x 63D CITY CAMPUS OUTDOOR HOCKEY COMPLEX PARK 1885 CROSSTOWN BLVD. NW 232 64D Cffl'HALLCOhIELEx XINDRPLE PARK 1685 CROSSTOWN BLVD. NW 51.28 x 65D COON CREEI(?ONANDERSON TRAE PARK EAST W HANSM BLVD OF C.C. 44.09 x 880 CREEK VIEW CROSSING PARK 14271 YELLOW PONE ST 0.63 X STD EVELANDFIELDS PARK R25 ANDOVER BLVD NW 2.01 X 6so MYTETELS PARK HANSOM BLVD.& ANDOVER BLVD. 1.59 69DHICKORY MEADOWS PARK 300144THAVE on X 700 HIDDEN CREEK EASTPARK 2156 33M LANE NW 226 X 710 N6LS OF BUNKER TAKE WEST PARK 155739THLANENW 6.26 x Mo LANDLOCKED PARK 15543 PRAIRIE RD 2.15 "D MOORES ESTATES PARK 905 CROSSTOWN BLVD. NW 0.26 740 NORDEENS PARK 13535JUNWERST.NW 0.85 x 75D OAK BLUFF PARK 14257 BLUEBOD ST. NW 339 x 760 PRAIRIE KNOLL PARK148W PRAGUE ROAD NW 19.38 X T20 RED OAKS EAST PARK 14045 MAI GHTENGE ST. NW 135 280 REDOMSwEST PARK 14058 RAVEN ST. NW 2.96 X no REDWOOD PARK 11922 BLUEBURD ST. NW 5.82 BOD Sf1ADOWBRWKEAST PARK 13257BVRERNUTSTNW 15.03 X - BLD SHADOWBROOKWEST PARK BUNKERLAKERD&GOLDENRODST 10.38 BID SHADY KNOLL PARK 2352 INLANDER ST. NW 1.52 X 83D SOPD6S PARK 1170152ND LANE NW 018 s "DSUNSWKE PARK 1900 CROSSTOWN BLVD. NW 38.65 x BSD THE OAKS PARK 14431 CROSSTOWN BLVD. NW 1.13 85D WOODLANDESTATES PARK B63 152ND LANE ANY 017 S City Features: A Andover City Hall I/ Crooked Lake Elementary School O Oakvim Middle School B Andover Elementary I FBe StatiOn 41 P Recycling Canter C Andover Public Works J Fhe Station s2 Q Rum River Elementary D Anoka County Highway Department K Fire Statlon #3 R Slaple Cemetary E Anoka Count Parks Maintenance L High School F Anoka County Sheriffs Office M Meadow Creek Christian School G Composring Site N Mosquito Coalrol Proposed 2023-2027 Park Capital Improvement Plan 2023 • DESIGN - Prairie Knoll Park — Warming House Expansion/Replacement - $50,000 — • DESIGN — Pine Hills North Building/Shelter - $50,000 • Hidden Creek North — Medium Shelter - $40,000 • Lunds North Playground Equipment - $50,000 • Annual Misc. Projects - $25,000. • ACC Contribution - $200,000 2024 • Construction of Prairie Knoll Park Building/Warming House Expansion/Replacement - $150,000 • Construction of Pine Hills North Multipurpose Building and Shelter (with $25,000 commitment from BFC) $350,000 • Annual Misc. Projects - $25,000. • ACC Contribution - $200,000 2025 • Park at Fields of Winslow Cove - $150,000 • DESIGN - Kelsey Round Lake Park Master Plan Item - Shelter with Restrooms $50,000 • Annual Misc. Projects - $25,000. • ACC Contribution - $59,108 2026 • Zone C Projects TBD - $150, 000 • Annual Misc. Projects - $25,000 2027 • Zone A Projects TBD - $150, 000 • Annual Misc. Projects - $25,000 CITY OF ANDOVER Park Improvement Fund Projected Fund Balance Fund Balance Brought Forward 1,011,925 852,225 287,375 138,418 98,568 Ending Fund Balance`" $ 1,011,925 $ 852,225 $ 287,375 $ 138,418 $ 98,568 $ 58,718 Based on 50% of previous year's estimated park dedication w/ a reconciliation of two years prior. "Target - $50,000 to create a contingency for any project overages. Dedicated Funds Available for: Community Center Contribution $1m Rose Park - tower rental fee $ 57,995 $ 175,146 2020 202,604 2021 $ 377,750 Estimate 2022 2023 2024 2025 2026 2027 TOTALS Projected Sources of Revenue Park Dedication Fee - Residential Units 50 25 25 25 25 Park Dedication Fee- Residential($4,806/unit) $ 363,377 $ 240,300 $ 120,150 $ 120,150 $ 120,150 $ 120,150 $ 1,084,277 less: Contribution to Comm Ctr Expan ` (163,143) (200,000) (200,000) (59,107) - - (622,250) Donation / Contribution - - 25,000 - - - 25,000 Capital Projects Levy - Park Improvements 15,000 15,000 15,000 15,000 15,000 15,000 90,000 Total Revenues Available 215,234 55,300 (39,850) 76,043 135,150 135,150 577,027 Projected Commitments Pine Hills North - Phase II parking lot 120,000 120,000 Pine Hills South - parking lot 67,000 67,000 Oak Bluff - New Basketball Court 10,000 10,000 Prairie Knoll Park - Warming House Expansion/Replacement 50,000 150,000 200,000 Hidden Creek North - Medium Shelter 40,000 40,000 Lunds North Playground Equipment 50,000 50,000 Pine Hills North - Multipurpose Building 50,000 350,000 400,000 Park at Fields of Winslow Cove 150,000 150,000 Kelsey Round Lake Park - Design Shelter w/ Bathrooms 50,000 50,000 Zone C Projects - TBD 150,000 150,000 Zone A Projects - TBD 150,000 150,000 Annual Miscellaneous Projects 25,000 25,000 25,000 25,000 25,000 25,000 150,000 Total Commitments 222,000 215,000 525,000 225,000 175,000 175,000 1,537,000 Revenues Over (Under) Expenditures (6,766) (159,700) (564,850) (148,957) (39,850) (39,850) Fund Balance as of December 31, 2021 1,018,691 Fund Balance Brought Forward 1,011,925 852,225 287,375 138,418 98,568 Ending Fund Balance`" $ 1,011,925 $ 852,225 $ 287,375 $ 138,418 $ 98,568 $ 58,718 Based on 50% of previous year's estimated park dedication w/ a reconciliation of two years prior. "Target - $50,000 to create a contingency for any project overages. Dedicated Funds Available for: Community Center Contribution $1m Rose Park - tower rental fee $ 57,995 $ 175,146 2020 202,604 2021 $ 377,750 Andover Park & Recreation Commission Workshop Meeting Minutes —April 7, 2022 Page 1 DISCUSS 2023-3027 PARK CAPTIAL IMPROVEMENT PLAN The Park Dedication funds and what they can be used for was explained to the Park and Recreation Commission by Parks and Streets Operations Manager Baumunk. He also walked the Commission through the budget sheets for the Park Dedication Fund with the projected improvements. Baumunk also provided a sheet detailing the future park facilities identified in the 2020 Park Dedication Study. Commissioner Strombeck asked if there where any known costs for upgrading the Prairie Knoll warming house which is identified as $100,000 in the 2023 CIP. Baumunk responded that they are still waiting for AFA to get together a quote or plans on remodeling that building. Commissioner Stenzel asked if they must identify specific projects in the CIP or can they identify a set dollar amount for a Zone and list that in the CIP. It was discussed amongst the Commissioners about how that process could work. Parks and Streets Operations Manger Baumunk stated he would follow with Administration on the possibility for identifying Zones in the CIP. He also noted that there would be a need for a park within the next couple years in the Fields at Winslow Cove Development on the East side of Prairie Road and that will need to be budgeted for. Andover Park & Recreation Commission Workshop Meeting Minutes —April 21, 2022 Page 1 DISCUSS 2023-2027 PARK CAPITAL IMPROVEMENT PLAN The Park and Recreation Commission is requested to discuss the 2023-2027 Park Capital Improvement Plan (CIP). Mr. Baumunk stated the Park and Recreation Commission can budget the CIP in zones. The Park and Recreation Department discussed the Park CIP and asked staff to make a list of their priorities. They discussed using the $25,000 miscellaneous project budget to complete smaller projects. Andover Park & Recreation Commission Workshop Meeting Minutes —May 5, 2022 Page 1 DISCUSS 2023-2027 PARK CAPITAL IMPROVEMENT PLAN The Park and Recreation Commission is requested to continue discussion on the 2023-2027 Park Capital Improvement Plan (CIP). Mr. Baumunk stated the Finance Department recommends the Commission dedicates $200,000 to pay for the Community Center debt instead of paying more. Mr. Baumunk stated staff has provided recommendations for the CIP. The Commission reviewed the Parks CIP and recommended the following changes: 2023 - Contact the Andover Football Association and if they don't have concrete plans for a warming house expansion at Prairie Knoll, then the Commission will push the project out to 2024. 2024 - Fields of Winslow Cove Park will be moved to 2025 Other items recommended by staff: • Pine Hills North restroom facility and storage o Boreal FC would contribute $25,000 o The president of Boreal FC will be at the next meeting to discuss the project o Look at having automatic locks on the restroom doors • The Commission supported the additional items recommended by staff Staff will update the Parks CIP with staff recommendations and present it to the Commission for their recommendation at the next meeting. Regular Andover Park & Recreation Commission Meeting Minutes —May 19, 2022 Page 2 RECOMMEND 2 023-2 02 7 PARK CAPITAL IMPROVEMENT PLAN The Park and Recreation Commission is requested to review the Park Capital Improvement Plan and make a recommendation to City Council. Parks and Streets Operations Manager Baumunk presented the plan and stated the Finance Department would like to cap the payment to the Community Center at $200,000 per year. Chairperson Lindahl asked about the Prairie Knoll warming house project. Mr. Baumunk stated he spoke with Andover Football, and they will get plans to the Commission prior to the next meeting. Commissioner Strombeck asked if it should be in the CIP if it is a tentative plan. Commissioner Widmyer asked if Lunds North is new equipment or replacement. Mr. Baumunk stated it is new equipment and will come out of the Parks CIP. Commissioner Stenzel stated there is a large fund balance and is concerned the City will use the funds for other purposes. He asked if the Commission should do more projects to get the fund balance down. Mr. Baumunk stated the fund is secure and can't be dipped into to for non -park projects. Commissioner Strombeck agrees with spending down the fund balance but is concerned costs will be high due to the economy. Commissioner Stenzel stated he would like to see more projects in the plans that show a lower fund balance. Commissioner Lackie stated she agrees and mentioned finishing Kelsey Round Lake Park and Pine Hills. The Commission requested adding projects to 2023 and 2024. Commissioner Stenzel suggested increasing the miscellaneous fund to $50,000. The Commission supported increasing the fund. Commissioner Strombeck suggested replacing the sign at Kelsey. Mr. Baumunk stated Mr. Haas and Councilmember Holthus have been working on signs. Mr. Baumunk asked what the Commission wants the fund balance to be at. The Commission recommended keeping the fund balance at $150,000. 1685 CROSSTOWN BOULEVARD N.W.. ANDOVER, MINNESOTA 55304 • (763) 755-5100 FAX (763) 755-8923 . WWW.ANDOVERMN.GOV TO: Mayor and Council Members CC: Jim Dickinson, City Administra FROM: David D. Berkowitz, Director of Public orks/City Engineer SUBJECT: Discuss Water Treatment Plant & Biological Water Treatment Study — Engineering DATE: June 28, 2022 INTRODUCTION8 The City Council is requested to discuss the Radon issues within the Water Treatment Plant and the potential study to evaluate if biological treatment is the right fit for the City's water treatment. DISCUSSION Early in 2022 staff was made aware that other Cities have been experiencing exceedance levels of Radon gas within their water treatment plants. Staff conducted monitoring within the plant and determined that that is also the case in Andover. Once it was determined that the levels exceeded the Federal standards a process was put in place to reduce access to the building and move full time offices out of the space of concern. Steve Weinhold, Andover Utilities Manager will be at the meeting to provide more detail on the monitoring/testing process, steps that have been taken, evaluation of future improvements to remove the Radon and the proposed future steps to address the concern. The other item related to City water and Water Treatment Plant is a potential study that could be conducted to evaluate if biological treatment to the water could work for the Andover Municipal water system. Greg Johnson and Ursinio Puga from WSB will provide to the City Council detailed information on a potential water treatment pilot plant study along with the history of biological treatment, results other Cities have experienced and the benefits of biological treatment. BUDGETIMPACT Funding for improvements to address Radon within the Water Treatment Plant will be discussed during the 2023-2027 Capital Improvement Plan discussion. Pilot plant study would range for $30,000 to $35,000 depending on how much work can be done by Andover Public Works staff. Funding for this study would come from the Water Treatment Plant Operating Budget. ACTION REQUIRED The City Council is requested to discuss the Radon issue within the Water Treatment plant and a potential water treatment pilot plant study to look at biological treatment effectiveness and direct staff on how to proceed. ectfully submitted David D. Berkowitz �s- / , ' r1�. IQ 1685 CROSSTOWN BOULEVARD N.W.. ANDOVER, MINNESOTA 55304 . (763) 755-5100 FAX (763) 755-8923 . WWW.ANDOVERMN.GOV TO: CC: FROM: SUBJECT: DATE: Mayor and Council Members Jim Dickinson, City Administrator David D. Berkowitz, Director of Public Works/City Engineer Discuss Proposed Improvements/Round Lake Boulevard NW (149th Avenue NW to 15711 Avenue NW)/22-37 —Engineering June 28, 2022 INTRODUCTION8 The City Council is requested to review and discuss the proposed improvements to Round Lake Boulevard NW between 149th Avenue NW and 157th Avenue NW. DISCUSSION Improvements are planned for 2024 for Round Lake Boulevard between 1491h Avenue NW and 157th Avenue NW. Attached is the proposed layout from the Anoka County Highway Department (ACED) for review and discussion. The project is subject to the City/County cost share agreement and the trail along Round Lake Boulevard would be 100% City cost as no trial currently exists and this project will not be funded by Federal STP funding. BUDGETIMPACT The City portion of this project including the trail would come from Municipal State Aid funds. The total project estimate is $3.4 Million with $500,000 funded from the Andover Municipal State Aid fund. ACTION REQUIRED The City Council is requested to review and discuss the attached proposed layout for improvements to Round Lake Boulevard NW and provide comments that will be forwarded on to the ACHD. Respectfully submitted, David D. Berkowitz Attachment: Proposed Layout for Improvements to Round Lake Boulevard NW & Proposed Corridor Access/Egress List,,/ . � .J1 �/ a i �" r .-# (' rv� y: R�•-•c �r.y is : ��{��' �gyfF.'il ', � .lF� i � ' _i. � .•'-� P ' tom{ ' hif � , ti� .,:aN' � vI4Ldim k T � x .i �� .I p � :5 �/�.�YE/ � .'% T. -T •�'+/"ti,+ � �� t � •i� "*• s}"5... ,/� l_ '�� h� ! � i, •i r , - {',r`lM(va� 4` a� °1 .i _ ' �' `y .. I� Ali:a;/.W di/ C'� .�'�y� �. • yt�' � xa i.' <k. r �'. ;i f 4�.. f� C rs i � 1, `•i j J�•,� 3Mi - ie f >. ' ' cR � .: � .. � f,• }s.' NY A+ •y91 f11 • M,�y"r u • • 1` 258' - 1062' 755 ' r 756' - - - 1022 fa 1 _ • If AlW �r.,.. .. - i II p '� r iI e: �r .i {, / ••�'vl {y I� i Is tii a f:' �y 'Y" Ic f �'f. ��'e �'��. "i I i ! .,t �; F n , r— —of @A . d � •ui4'�, LL . EX H191T A r �. by p i CSAH9 DESIGN LAYOUT OPTI SA t 549 2004 — -' _ 2845yfl.i PREUMINARYDl FT ' - ' _ SUB/ELT TO CHANGE . lw eawg MpeuT.e Potm .� .mow. Em«.. • w.. .er q ,.t.`'. �r ,,,, �y� { y� '_� • rlwmo,. r.rt+.w�+� � wssm+soo.o.ocaax � !�� `� ti / ar�'- Ftyp� V. ii .- •�' m. m.nm�.�m �m�.o,�,� I A ,aowarw.. y'�'-, a _✓,i. "�` i� f P ; a'y �3 ._. .R x a v I t • �� ae.m..an., �"� y- y �`�� v. �r '` ".. "7T � { � � �(�j�•�J�ii'•� w.• r cm�.ea.,..w cw.nNa�,., : s N _ 9N_.C^M'✓fsM W1e.MVueW'�i 'Y Y. a !q� F ! ♦ � s � �w.Y . L y�!`� I 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 2023-2027 CIP Development Discussion June 28, 2022 INTRODUCTION Late March, Administration/Finance distributed baseline worksheets to Department Heads for the 2023-2027 CIP kick-off. Subsequent discussion centered on the 2023-2027 CIP development, the need of other committees (Vehicle/Equipment Purchasing & Facility Management Committees) and commissions (Parks and Recreation & Nature Preserve) to complete their work toward a "draft" proposed 2023-2027 CIP to present to the City Council. DISCUSSION Throughout the summer a significant amount of time will be spent on evaluating utility infrastructure, transportation improvements, building maintenance, equipment and park and recreation needs. Each of these items will be supported by a fund balance analysis of funding sources (based on various assumptions and estimates) that will be presented to the Council for review at workshops. At this time, the Staff would like to present proposed proiects and equipment to the Council to determine if Council's priorities for a 2023-2027 CIP are being met. It is anticipated that an interactive review of the attached Capital Plan summaries and Fund Balance analysis' will be done at the workshop meeting. Staff will be specifically looking for Council review and.comment on the proiects and determine if there are other initiatives. ACTION REQUESTED The Council is requested to review the attachments, receive a brief presentation, and provide direction to staff on Council priorities for the 2023-2027 CIP. QM City of Andover, MN Capital Plan 2023 thru 2027 PROJECTS & FUNDING SOURCES BY DEPARTMENT Department Project# Priority 2023 2024 2025 2026 2027 Total Central Equipment New - AIC Recycling Machine 23-08800-01 1 11,000 11,000 Capital Equipment Reserve 11,000 11,000 Replacement- Service Truck #371 24-08800-01 1 45,000 45,000 Capital Equipment Reserve 45,000 45,000 Central Equipment Total 11,000 45,000 56,000 Community Center 200,000 Carpet -Entry/Fieldhouse Foyer 23-04000-01 Comm Ctr Operations 15,000 Replacement - Water Heater 2344000-03 Comm Ctr Operations 15,000 Concrete Floor Sealant 24-44000-01 Comm Ctr Operations 65,000 Replacement- East Parking Lot Pavement 24-04000-02 Comm Cfr Operations 350,000 Replacement - Heat Exchangers - MunlersUnit 24-04300-01 Comm Ctr Operations 70,000 Repaint Field House Ceiling 2444400-01 Comm Ctr Operations 36,000 Replacment- Kivac Cleaning Machine 25-04000-01 Cmm Ctr Operations 36,000 Replacement- Carpet Track Level 2544300-01 Comm Ctr Operations 380,000 Replacement - Generator 26-04000-01 Comm Ctr Operations Repaint Ice Arena ceiling 27-44300-01 Comm Ctr Operations 25,000 Replacement-Zamboni 2744300-02 Comm CtrOperations 380,000 Community Center Total 2,228,000 1 230,875 25,000 Engineering New Development Projects 2341600-01 Sewer Trunk Fund 50,000 Water Trunk Fund 50,000 Pedestrian Trail Maintenance 2341600-02 RoadllBridge Funds 1 New Pedestrian Trail and Sidewalk Segments 2341600-03 ARPA Funds 8,000 Trail Funds Pedestrian/Park Trail Reconstruction 23-01600-04 ARPA Funds 1 1 15,000 200,000 210,000 220,000 15,000 15,000 130,000 135,000 140,000 15,000 1 80,000 700,000 60,000 65,000 80,000 80,000 80,000 350,000 1 62,000 80,000 1 36,000 70,000 73,000 336,000 36,000 36,000 67,000 70,000 73,000 36,000 1 400,000 705,000 380,000 400,000 2,578,000 400,000 400,000 1 25,000 1,000,000 143,000 25,000 380,000 25,000 2,228,000 1 230,875 25,000 1 50,000 730,875 50,000 50,000 50,000 1 8,000 8,000 4000 8,000 1 12,000 12,000 12,000 12,080 1 40,000 40,000 40,000 40,000 1 200,000 200,000 200,000 200,000 1 180,000 180,000 180,000 180,000 131,000 475,000 20,000 40,000 380,000 1,046,000 1 190,000 200,000 210,000 220,000 230,000 1,050,000 130,000 135,000 140,000 145,000 150,000 700,000 60,000 65,000 70,000 75,000 80,000 350,000 1 62,000 64,000 67,000 70,000 73,000 336,000 62,000 64,000 67,000 70,000 73,000 336,000 1 1,350,000 143,000 705,000 380,000 2,578,000 350,000 350,000 1,000,000 143,000 705,000 380,000 2,228,000 1 230,875 500,000 730,875 105,875 105,875 HIM Department Project # Priority 2023 2024 2025 2026 2027 Total GenealFund 500,000 500,000 Gant 125,000 125,000 New - Drone 23-41600-05 1 13,000 13,000 GenenlFund 3,000 3,000 RcadB Bridge Funds 6,000 6,000 Storm Sewer Fund 1,000 1,000 Water Fund 3,000 3,000 Replacement - Total Station Survey Equipment 24-41600-01 1 35,000 35,000 Capital Equipment Reserve 35,000 35,000 Replacement -Chevrolet Tahoe#16 26-41600-07 1 65,000 65,000 Equipment Bond 65,000 65,000 Engineering Total 1,845,875 442,000 1,482,000 735,000 303,000 4,807,875 Facility Management Annual Parking Lot Maintenance/Replacement 2341900-01 1 170,000 100,000 60,000 70,000 80,000 480,000 Facility Maintenance Reserve 170,000 100,000 60,000 70,000 80,000 480,000 City -Wide Facilities Space Study 2341900-02 1 120,000 120,000 Facility Maintenance Reserve 115,000 115,000 WalerFund 5,000 5,000 Replacement - Emergency Generator FS #1 23-41900-03 1 50,000 50,000 Facility Maintenance Reserve 50,000 50,000 Replacement -Tube Heaters FS #1 23-41900-05 1 35,000 35,000 Facility Maintenance Reserve 35,000 35,000 Replacement- Roof Top Package Units 1 -8 CH 23-41900-06 1 120,000 120,000 Facility Maintenance Reserve 120,000 120,000 Replacement - Furnace FS#3 23-41900-07 1 10,000 10,000 Facility Maintenance Reserve 10,000 10,000 Replacement - Carpet l Tile 2441900-01 1 30,000 30,000 Facility Maintenance Reserve 30,000 30,000 Replacement -Emergency Generator FS#2 24-41900-02 1 35,000 35,000 Facility Maintenance Reserve 35,000 35,000 Replacement - Fire Sprinkler System FS #1 24-41900-03 1 50,000 50,000 Facility Maintenance Reserve 50,000 50,000 Replacement- Fire Sprinkler System PW 24-41900-04 1 50,000 50,000 Facility Maintenance Reserve 50,000 50,000 Replacement - Roof Top Package Units 9 -16 CH 2441900-05 1 112,000 112,000 Facility Maintenance Reserve 112,000 112,000 Replacement -Garage door PW 24-41900-06 1 12,000 12,000 Facility Maintenance Reserve 11000 12,000 Replacement - Garage Door Springs FS #1 24-41900-07 1 25,000 25,000 Facility Maintenance Reserve 25,000 25,000 Replacement- Emergency Generator FS#3 2541900-01 1 50,000 50,000 Facility Maintenance Reserve 50,000 50,000 Replacement- Fire Sprinkler System CH 2541900-03 1 50,000 50,000 Facility Maintenance Reserve 50,000 50,000 Replacement- Mini Split Unit QCTV 25-41900-04 1 6,500 6,500 Capital Equipment Reserve 6,500 6,500 Replacement - Water Heater ASN 2541900-05 1 5,000 5,000 Facility Maintenance Reserve 5,000 5,000 Replacement - Fan Coil Unit ASN 2541900-06 1 6,500 6,500 Facility Maintenance Reserve Q500 6,500 Replacement -Gamge Door Springs FS#2 2541900-07 1 18,000 18,000 Facility Maintenance Reserve 18,000 18,000 Building A - Seal Floor 27-41900-01 1 35,000 35,000 Department Project At Priority 2023 2024 2025 2026 2027 Total Facility Maintenance Reserve 35,000 35,000 Replacement -Generator CH 27-01900-02 1 60,000 60,000 Facility Maintenance Reserve 60,000 60,000 Facility Management Total 505,000 414,000 196,000 70,000 175,000 1,360,000 Fire New - First Response Vehicle 23-02200-01 1 75,000 75,000 Capital Equipment Reserve 75,000 75,000 Replacement - UT -10 94810 23-02200-02 1 65,000 65,000 Capital Equipment Reserve 65,000 55,000 Replacement -800 MHz Radios 23-02200-03 1 50,000 50,000 50,000 150,000 Capital Equipment Reserve 50,000 50,000 50,000 150,000 New - Digital Fire Extinguisher Training System 24-42200-01 1 12,000 12,000 CapitalEqulpmentResene 1$000 12,000 Replacement -Engine 31#4800 24-02200-02 1 800,000 800,000 Equipment Bond 800,000 800,000 New- Forcible Entry Prop 24-02200-03 1 8,000 8,000 Capital Equipment Reserve 8,000 8,000 Replacement- Ford Interceptor#4827 26-02200-01 1 50,000 50,000 Equipment Bond 50,000 50,000 Replacement- Grass Utility Vehicle (UTV) #4813 26-02200-02 1 45,000 45,000 Equipment Bond 45,000 45,000 Replacement - Grass&Rescue Vehicle 26-42200-03 1 300,000 300,000 Equipment Bond 300,000 300,000 Replacement - SOBA Equipment 26-42200-04 1 250,000 250,000 500,000 Capital Equipment Reserve 250,000 250,000 500,000 Replacement -Engine 11 #4821 27-02200-01 1 900,000 900,000 Equipment Bond 900,000 900,000 Replacement -Rescue 21#4819 27-02200-02 1 300,000 300,000 Equipment Bond 300,000 300,000 Replacement - GMC Sierra #4826 27.42200-03 1 60,000 60,000 Capital Equipment Reserve 60,000 60,000 Fire Total 190,000 870,000 50,000 645,000 1,510,000 3,265,000 Information Technology Replacement- Data SAN (Storage Area Network) 23-41420-01 1 30,000 30,000 Capital Equipment Reserve 30,000 30,000 Information Technology Total 30,000 30,000 Park & Rec - Operations Replace/Repair Play Structures - Various Parks 2345000-01 1 110,000 150,000 150,000 150,000 150,000 710,000 General Fund 110,000 150,000 150,000 150,000 150,000 710,000 Replace/Repair Major Park Projects -Various Parks 23-05000-02 1 35,000 35,000 35,000 35,000 35,000 175,000 General Fund 35,000 35,000 35,000 35,000 35,000 175,000 New - Zero Tum Mower 23-45000-03 1 15,000 15,000 Capital Equipment Reserve 15,000 15,000 Replacement- Sunshine Park Parking Lot 23-05000-04 1 290,000 50,000 340,000 ARPA Funds 290,000 290,000 General Fund 50,000 50,000 Replacement - Toro Groundsmaster#561 24-05000-01 1 60,000 60,000 Capital Equipment Reserve 60,000 60,000 Imo'', Department Project# Priority 2023 2024 2025 2026 2027 Total Replacement - One Ton Truck w/Plow #569 24-05000-02 1 90,000 25,000 Park Dedication Funds Sanitary Sewer Fund 90,000 Equipment Bond 25,000 Prairie Knoll Park Warming House Expansion 90,000 100,000 3,800,000 10,000 90,000 Replacement- One Ton Irrigation Truck 24-05000-03 1 80,000 Hidden Creek North Park Medium Shelter 23415001-03 1 40,000 80,000 Equipment Bond Park Dedication Funds 75,000 80,000 24-08200-01 1 Lunds North Park New Playground Equipment 80,000 New -Trail Machine 24-05000-05 1 200,000 Crooked Lake Blvd Sanitary Sewer Lining Project 50,000 1 200,000 Equipment Bond 23-45001-05 1 147,500 200,000 1 Capifal Equipment Reserve 200,000 Replacement- Toro Groundsmaster#564 2545000-01 1 80,000 80,000 CapkdlEquipmentReserve 362,500 25,000 25,000 80,000 80,000 Replacement -Toro Groundsmaster#550 25-05000-02 1 80,000 80,000 Capital Equipment Reserve 80,000 80,000 Replacement - One Ton Truck w/ Plow #577 25-05000-03 1 85,000 85,000 Capital Equipment Reserve 85,000 85,000 Replacement- Trackless MTS#525 26-05000-01 1 200,000 200,000 Equipment Bond 200,000 200,000 Replacement -Tmckster#548 26-05000-02 1 15,000 15,000 Equipment Bond 15,000 15,000 Replacement -Toro Zero -Tum Mower #09-592 27,15000-01 1 17,000 11,000 Cap#al EquipmentResarve 17,000 17,000 Replacement- Toro Workman #566 27-05000-02 1 15,000 15,000 Capital Equipment Reserve 15,000 15,000 Park & Rec - Operations Total 450,000 615,000 430,000 450,000 217,000 2,162,000 Park & Rec - Projects Annual Miscellaneous Park Projects 23,15001-01 1 25,000 25,000 25,000 Park Dedication Funds Sanitary Sewer Fund 25,000 25,000 25,000 Prairie Knoll Park Warming House Expansion 23,15001-02 1 100,000 3,800,000 10,000 Park Dedication Funds 2348200-03 100,000 SanifarySewerFund 1,000,000 Hidden Creek North Park Medium Shelter 23415001-03 1 40,000 1 75,000 Sewer Trunk Fund Park Dedication Funds 75,000 40,000 24-08200-01 1 Lunds North Park New Playground Equipment 23,15001-04 1 50,000 Sewer Revenue Bonds Park Dedication Funds Crooked Lake Blvd Sanitary Sewer Lining Project 50,000 1 Sewer Trunk Fund Dalske Preserve Boardwalk 23-45001-05 1 147,500 2748200-01 1 Capifal Equipment Reserve 73,750 Grant 73,750 Park & Rec - Projects Total 362,500 25,000 25,000 Sanitary Sewer 20,000 10,000 Lift Station #1 Valve Manhole 23,18200-01 1 100,000 Sanitary Sewer Fund 30,000 100,000 Upgrade Controls at Sanitary Lift Stators 2348200-02 1 10,000 Sanitary Sewer Fund 3,800,000 10,000 New - Sanitary Sewer Line Assessment Tool 2348200-03 1 30,000 SanifarySewerFund 1,000,000 30,000 New- Backup Generator at Lift Station#5 2348200-04 1 75,000 Sewer Trunk Fund 90,000 90,000 75,000 Rural Reserve Trunk Sanitary Sewer 24-08200-01 1 Assessments Sewer Revenue Bonds Crooked Lake Blvd Sanitary Sewer Lining Project 24.48200-02 1 Sewer Trunk Fund Replacement - One Ton Truck w/ Plow #13-094 2748200-01 1 SanitarySewer Fund 25,000 25,000 25,000 25,000 25,000 25,000 125,000 125,000 100,000 100,000 40,000 40,000 50,000 50,000 147,500 73,750 73,750 461500 100,000 100,000 10,000 20,000 10,000 20,000 30,000 30,000 75,000 75,000 3,800,000 3,800,000 1,500,000 1,500,000 1300,000 1300,000 1,000,000 1,000,000 1,000,000 1,000,000 90,000 90,000 90,000 90,000 Department Project# Priority 2023 2024 2025 2026 2027 Total 2343100-01 Capital Equipment Reserve 10,000 Replacement- Crash Attenuator Trailer 2343100-02 Sanitary Sewer Fund Sanitary Sewer Total Water Fund 215,000 4,610,000 90,000 5,115,000 Storm Sewer Storm Sewer Improvements 2348300-01 1 70,000 70,000 73,000 74,000 76,000 363,000 Storm Sewer Fund 70,000 70,000 73,000 74,000 76000 363,000 Replacement- Elgin Street Sweeper #169 2348300-02 1 200,000 200,000 Storm Sewer Fund 200,000 200.000 Storm Sewer Total 210,000 220,000 230,000 Streets - Equipment Replacement - Bobcat S185#120 2343100-01 Capital Equipment Reserve 10,000 Replacement- Crash Attenuator Trailer 2343100-02 Sanitary Sewer Fund 190,000 Water Fund 24,000 New -Dump truck w/ Snow removal equipment 24-03100-01 Equipment Bond 1 62,000 New -1/2 ton pick-up 2443100-02 Capital Equipment Reserve 72,000 Replacement - One Ton Truck w/ Plow #134 2443100-03 Equipment Bond 255,000 Replacement - Dump Truck w/Snow removal#200 24-43100-04 Sanitary Sewer Fund 1 110,000 Storm Sewer Fund 120,000 Water Fund 255,000 Replacement- Dump Truck wl Snow removal #201 26-43100-01 Equipment Bond 120,000 Replacement - Dump Truck w/ Snow removal 9202 2643100-02 Equipment Bond 1 990,000 Replacement -1 Ton Truck w/ Plow #13-102 2743100-01 Equipment Bond 90,000 Replacement- Aerial bucket truck #00-139 2743100-02 Equipment Bond 480,000 Streets - Equipment Total 880,000 2,510,000 90,000 Streets - Roadways Annual Street Crack Seal Project 2349300-01 Construction Ssal Coat Fund 255,000 Rod Bridge Funds 85,000 Annual Pavement Markings 2349300-02 Road& Bridge Funds 6,740,000 Curb, Sidewalk and Pedestrian Ramp Replacement 2349300-03 Road & Bridge Funds 85,000 Annual Sheet Reconstruction 2349300-04 Assessments 116,000 G.O. Bond 1 Read & Bridge Funds 270,000 Municipal State Aid Routes/Mill & Overlay 2349300-05 Assessments 281,000 Municipal State Aid Funds 1,769,000 Sheet Mill & Overlay 2349300-06 Assessments 270,000 270,000 70,000 73,000 74,000 76,000 563,000 1 70,000 210,000 220,000 230,000 70,000 70,000 10,000 10,000 10,000 70,000 1 24,000 50,000 190,000 200,000 24,000 12,000 230,000 1,050,000 1 62,000 12,000 12,000 69,000 72,000 333,000 12,000 1 255,000 69,000 72,000 255,000 1 110,000 255,000 120,000 125,000 255,000 1 50,000 115,000 120,000 50,000 130,000 50,000 1 990,000 2,400,000 $0,000 1 90,000 9,990,000 250,000 90,000 480,000 90,000 880,000 2,510,000 90,000 1 255,000 255,000 85,000 11420,000 900,000 85,000 6,740,000 85,000 461,000 329,000 85,000 500,000 85,000 174000 116,000 85,000 1 125,000 270,000 521,000 270,000 247,000 281,000 270,000 1,769,000 270,000 1 1,000,000 270,000 1,000,000 270,000 452,000 250,000 270,000 250,000 270,000 1 90,000 90,000 90,000 90,000 1 200,000 200,000 200,000 200,000 94,000 650,000 540,000 290,000 1,574,000 1 200,000 210,000 220,000 230,000 240,000 1,100,000 10,000 10,000 10,000 10,000 10,000 50,000 190,000 200,000 210,000 220,000 230,000 1,050,000 1 62,000 64,000 66,000 69,000 72,000 333,000 62,000 64,000 66,000 69,000 72,000 333,000 1 110,000 115,000 120,000 125,000 130,000 600,000 110,000 115,000 120,000 125,000 130,000 600,000 1 990,000 2,400,000 1,900,000 1,200,000 3,500,000 9,990,000 250,000 600,000 480,000 300,000 880,000 2,510,000 740,000 740,000 1,800,000 11420,000 900,000 1,620,000 6,740,000 1 695,000 461,000 329,000 375,000 500,000 2,360,000 174000 116,000 82,000 94,000 125,000 591,000 521,000 345,000 247,000 281,000 375,000 1,769,000 1 1,798,000 1,000,000 1,000,000 1,000,000 1,000,000 5,798,000 452,000 250,000 250,000 250,000 250,000 1,452,000 0 Department Project# Priority 2023 2024 2025 2026 2027 Total G.O. Bond 100,000 1,346,000 100,000 100,000 100,000 100,000 1,346,000 Road B Bridge Funds 100,000 100,000 750,000 750,000 750,000 750,000 3,000,000 Gravel Road Improvements 23-49300-07 1 20,000 21,000 22,000 23,000 24,000 110,000 Road&Bridge Funds 40,000 20,000 21,000 22,000 23,000 24000 110,000 Street Full Depth Reclamation 23-49300-08 1 3,544,000 3,544,000 Assessments 886,000 886,000 G.O. Bond 2658,000 2,658,000 Intersection Upgrades 2449300-01 1 333,000 4,366,000 4,699,000 County Reimbursement 177,450 177,450 Grant 3,896,100 3,896,100 Municipal State Aid Funds 333,000 294450 625,450 Municipal State Aid Routes / New &Reconstruct 24-49300-02 1 1,600,000 1,270,000 470,000 2,590,000 5,930,000 Assessments 188,000 104,000 118,000 400,000 810,000 Municipal State Aid Funds 1,41;000 1,166,000 352,000 2,190,000 5,120,000 Streets - Roadways Total Water Replacement - Residential Meters Water Fund Water Main Gate Valve Rehabilitation Water Trunk Fund Rehabilitation of Wells Water Fund WTP High Service Pump Maintenance Water Fund New - Backup Generator at Well #5 Water Fund Replacement -WTP Valve Actuators Water Fund Replacement- WTP PLC controls Water Fund Water Main Improvements Water Trunk Fund WTP Radon Mitigation Water Fund Security Cameras at towers and well houses Water Fund Update Logic Controls at City Wells Water Fund Fiber Optic Upgrade For City Wells Water Fund Replacement - Polymer pump/mixers Water Fund Red Oaks Manor Water Main Improvements St of MY Asset Management Software Implementation Sanitary Sewer Fund Storm Sewer Fund Water Fund WTP replacement Flow meters Water Fund Replacement- Plate Settler Plates Water Fund Replacement - WTP Make Up Air Unit 2348100-01 1 2348100-02 1 2348100-03 1 2348100-04 1 2348100-05 1 23-48100-06 1 2348100-07 1 2348100-08 1 2348100-09 1 23-48100-10 1 2348100-11 1 2348100-12 1 2348100-13 1 23-48100-14 1 2348100-15 1 9,019,000 5,874,000 8,023,000 3,492,000 8,056,000 34,464,000 100,000 100,000 250,000 250,000 35,000 35,000 30,000 30,000 150,000 150,000 35,000 35,000 55,000 55,000 780,000 780,000 1,345,500 1,345,500 12,000 12,000 10,000 10,000 10,000 10,000 10,000 10,000 7,000,000 7,000,000 100,000 33,333 33,334 33,333 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 40,000 40,000 45,000 50,000 40,000 40,000 45,000 50,000 35,000 40,000 45,000 50,000 35,000 40,000 45,000 50,000 35,000 35,000 35,000 35,000 1,900,000 1,900,000 540,500 540,500 12,000 1$000 10,000 10,000 10,000 10,000 12,000 12000 2448100-01 1 20,000 30,000 20,000 30,000 2448100-02 1 115,000 115,000 2448100-03 1 35,000 O 500,000 500,000 650,000 650,000 210,000 210,000 200,000 200,000 150,000 150,000 105,000 105,000 55,000 55,000 2,680,000 3,680,000 1,886,000 1,884000 36,000 36,000 20,000 20,000 20,000 20,000 10,000 10,000 7,000,000 7,000,000 100,000 33,333 33,334 33,333 50,000 50,000 115,000 115,000 35,000 Department Project# Priority 2023 2024 2025 2026 2027 Total Water Fund 35,000 35,000 Replacement -2003 Chevrolet S-10 #77 25-48100-02 1 70,000 70,000 Water Fund 70,000 70,000 New -Backup Generator atWell #4 2548100-03 1 80,000 80,000 Water Fund 80,000 80,000 Water Total 9,922,500 2,952,500 507,000 290,000 300,000 13,972,000 GRAND TOTAL 23,045,875 17,242,500 10,806,000 6,361,000 11,422,000 68,877,375 M Projected Sources of Revenue Est. Annual MSA Construction Allocation Est. Annual Maintenance Allocation General Fund Commitment Available MSA Maintenance Total MSA Available for other Commitments Federal I State / County Funds Assessments' Transferin Bonds Tax Levy /� Total Revenues Available (hx^yalt Projected Commitments MSA - New & Reconstruct Routes MSA - Mill & Overlay MSA - Intersection Upgrades R & B - Pavement Markings R & B - Curb Replacement R & B - New & Reconstruct Routes R & B - Full Depth Reclamation R & B - Crack Sealing R & B - Gravel Road Improvements R & B - Pedestrian Crossing R & B - Mill & Overlay Pedestrian Trail Reconstruction Pedestrian Trail Maintenance Transfer Out - DS Pymt Total Commitments Revenues Over (Under) Expenditures Fund Balance as of December 31, 2021 Fund Balance Brought Forward Ending Fund Balance Assuming collected in same year CITY OF ANDOVER Road & Bridge Funds - Rollup Projected Fund Balance Estimate 2022 2023 $ 1,369,533 $ 1,369,533 456,511 456,511 (271,689) (279,840) 184,822 176,671 1,554,355 1,546,204 946,500 1,950,000 1,517,822 1,643,251 4,018,677 5,139,455 1,600,000 1,600,000 170,000 695,000 60,000 62,000 105,000 110,000 1,700,000 990,000 - 3,544,000 180,000 190,000 19,000 20,000 1,700,000 1,798,000 $ 1,369,533 456,511 (288,235) 168,276 1,537,809 1,070,000 1,680,722 4,288,531 1,270,000 461,000 333,000 64,000 115,000 2,400,000 200.000 21,000 1,000,000 60,000 62,000 64,000 (305,788) 200,000 200,000 5,594,000 9,271,000 6,128,000 (1,575,323) (4,131,545) (1,839,469) 16,820,896 1,780,676 8,144,520 4,062,932 15,245,573 11,114, 028 $ 15,245,573 $ 11,114,028 $ 9,274,559 $ 1,369,533 $ 1,369,533 456,511 456,511 (296,882) (305,788) 159,629 150,723 1,529,162 1,520,256 4,073,550 - 812,000 762,000 1,729,808 1,780,676 8,144,520 4,062,932 24,000 129,000 470,000 329,000 375,000 4,366,000 - 66,000 69,000 120,000 125,000 1,900,000 1,200,000 210,000 220,000 22,000 23,000 1,000,000 1,000,000 67,000 70.000 200,000 200,000 8,280,000 3,752,000 (135,480) 310,932 9,274,559 9,139,080 $ 9,139,080 $ 9,450,012 2027 TOTALS $ 1,369,533 $ 8,217,198 456,511 2,739,066 (314,962) (1,757,396) 141,549 981,670 1,511,082 1,554,355 - 4,073,550 1,655,000 7,195,500 1,833,394 10,185,673 4,999,476 23,009,078 2,590,000 7,530,000 500,000 2.530,000 - 4,699,000 72,000 393,000 130.000 705.000 3,500,000 11,690,000 - 3,544,000 230,000 1,230,000 24,000 129,000 1,000,000 7,498,000 73,000 396,000 200,000 1,000,000 8,319,000 41,344,000 (3,319,524) 9,450,012 $ 6,130,487 Based on 50% of previous year's estimated park dedication w/ a reconciliation of two years prior. "Target - $50,000 to create a contingency for any project overages. Dedicated Funds Available for: Community Center Contribution $1m $ 175,146 2020 Rose Park - tower rental fee $ 57,995 202,604 2021 $ 377,750 CITY OF ANDOVER Park Improvement Fund Projected Fund Balance Estimate 2022 2023 2024 2025 2026 2027 TOTALS Projected Sources of Revenue Park Dedication Fee - Residential Units 50 25 25 25 25 Park Dedication Fee - Residential ($4,806/unit) $ 363,377 $ 240,300 $ 120,150 $ 120,150 $ 120,150 $ 120,150 $ 1,084,277 less: Contribution to Comm Ctr Fxpan (163,143) (200,000) (200,000) (59,107) - - (622,250) Donation / Contribution - - 25,000 - - - 25,000 Capital Projects Levy - Park Improvements 15,000 15,000 15,000 15,000 15,000 15,000 90,000 Total Revenues Available 215,234 55,300 (39,850) 76,043 135,150 135,150 577,027 Projected Commitments Pine Hills North - Phase II parking lot 120,000 120,000 Pine Hills South - parking lot 67,000 67,000 Oak Bluff - New Basketball Court 10,000 10,000 Prairie Knoll Park - Warming House Expansion/Replacement 50,000 150,000 200,000 Hidden Creek North - Medium Shelter 40,000 40,000 Lunds North Playground Equipment 50,000 50,000 © Pine Hills North - Multipurpose Building 50,000 350,000 400,000 Park at Fields of Winslow Cove 150,000 150,000 Kelsey Round Lake Park - Design Shelter w/ Bathrooms 50,000 50,000 Zone C Projects - TBD 150,000 150,000 Zone A Projects - TBD 150,000 150,000 Annual Miscellaneous Projects 25,000 25,000 25.000 25,000 25,000 25,000 150,000 Total Commitments 222,000 215,000 525,000 225,000 175,000 175,000 1,537,000 Revenues Over (Under) Expenditures (6,766) (159,700) (564,850) (148,957) (39,850) (39,850) Fund Balance as of December 31, 2021 1,018,691 Fund Balance Brought Forward 1,011,925 852,225 287,375 138,418 98,568 Ending Fund Balance" $ 1,011,925 $ 852,225 $ 287,375 $ 138,418 $ 98,568 $ 58,718 Based on 50% of previous year's estimated park dedication w/ a reconciliation of two years prior. "Target - $50,000 to create a contingency for any project overages. Dedicated Funds Available for: Community Center Contribution $1m $ 175,146 2020 Rose Park - tower rental fee $ 57,995 202,604 2021 $ 377,750 CITY OF ANDOVER Trail Fund Projected Fund Balance Estimate 2022 2023 2024 2025 2026 2027 TOTALS Projected Sources of Revenue platted units 50 50 25 25 25 25 Trail Fee -$900 $ 238,008 $ 45,000 $ 22,500 $ 22,500 $ 22,500 $ 22,500 $ 373,008 ARPA Funds - 350,000 - - - - 350,000 Land Sale 113,709 - - - - - 113,709 Operating Transfer In - - - - - Total Revenues Available Projected Commitments Railroad Underpass Trail 8' Bituminous Trail along Crosstown Blvd - Xeon St to railroad tracks ORailroad (racks to 157th Ave 59t 157th Ave l0 1h Ave 8' Bituminous Trail along Station Parkway - Thrush St to Partridge Circle Partridge St to Hanson Blvd 8' Bituminous Trail along Verdin St - 161 st Ave to 163rd Lane 8' Bituminous Trail along Coon Creek - East to existing trail in Shadowbrook development Total Commitments Revenues Over (Under) Expenditures Fund Balance as of December 31, 2021 Fund Balance Brought Forward Ending Fund Balance' 351,717 395,000 22,500 22,500 22,500 22,500 836,717 320,000 575,000 455,000 55,000 88,000 705,000 340,000 1,350,000 143,000 705,000 340,000 351,717 (955,000) (120,500) (682,500) (317,500) 22,500 249,245 600,962 (354,038) (474,538) (1,157,038) (1,474,538) $ 600,962 $ (354,038) _L_(174,538) $ (1,157,038) $ (1,474,538) $ (1,452,038) `Target -10% of current years commitments to create a contingency for any project overages. It is anticipated that all projects will not be fully expended by the end of the year, and future projects will be contingent on additional revenues. 320,000 575,000 455,000 55,000 88,000 705,000 340,000 2,538,000 Projected Sources of Revenue Capital Projects Levy Grant Operating Transfers In - Cent Eq Operating Transfers In - Stom1 Water EF Total Revenues Available Projected Commitmerl[s Emergency Operations Center Improvements Memorial - Veterans Memorial Replacement - Emergency Sirens Replacement - Trailer #T-155 New - Mobile CAD Fire Replacement - 800MHz Radios Replacement - Tractor #515 Replacement - Toro Workman #565 Dag Park -Trail & Parking Lot Paving Replacement - Data SAN (Storage Area Network) New - First Response Vehicle Replacement - UT -10 #4810 New -zero tum mower Replacement-Bobcat5185 #120 New - A1C Recycling Machine Dalske Preserve - Boardwalk New - Forcible Entry Prop New - Digital Fire Extinguisher Training System Replacement - Service Truck #371 Replacement - Survey Equipment Replacement - Toro Groundmaster #561 New -112 Ton Pick Up Replacement - Mini Split DCN Control Room Replacement - Toro Groundmaster #564 Replacement - Two Groundmaster LISW Replacement -One Ton Truck wl Plow #577 Replacement -SCBi Replacement - GMC Siena #4826 Replacement - Toro Zero Tum Mower #09-592 Replacement - Toro Workman #566 Pine Hills North Parking Lot Natural Disaster Reserve CCTV -Council Chambers Total Commitments Revenues Over (Under) Expenditures Fund Balance as of December 31, 2021 Fund Balance Brought Forward Ending Fund Balance CITY OF ANDOVER Capital Equipment Reserve Fund Projected Fund Balance Estimate 2022 2023 2024 2025 2026 2027 TOTALS $ 275,000 $ 275,000 $ 275,000 $ 275.000 $ 275.000 $ 275,000 $ 1,650,000 73,750 - - - - 73,750 - - 45,000 - - - 45,000 23,500 23,500 298,500 348,750 320,000 275,000 275,000 275,000 1,792,250 20,000 6,000 50,000 25,000 12,000 50,000 25,000 13,000 37,500 280,000 350.000 157,692 50,000 50,000 50,000 30,000 75.000 65,000 15,000 70,000 11,000 147,500 8,000 12,000 45,000 35,000 60,000 50,000 6.500 80.000 80,000 85,000 250,000 250,000 60,000 17,000 15.000 20,000 6.000 50,000 25,000 12,000 200,000 25,000 13,000 37,500 30,000 75,000 65,000 15,000 70,000 11,000 147,500 8,000 12.000 45,000 35.000 60,000 50.000 6.500 80,000 80,000 85,000 500,000 60,000 17,000 15,000 280,000 350,000 157,692 1,026,192 463,500 260,000 301,500 250,000 342,000 S 2,643,192 (727,692) (114,750) 60,000 (26,500) 25.000 (67,000) 1,928,097 1,200,405 1,085,655 1,145,655 1,119,155 1,144,155 $ 1,200,405 S 1,0851655 S 1.145,655 $ 1,119,155 $ 1,144,155 S 1,077,155 CITY OF ANDOVER Building Fund Projected Fund Balance Estimate 2022 2023 2024 2025 2026 2027 TOTALS Proacted Sources of Revenue Facility Maintenance Reserve Levy $ 355,000 $ 355,000 $ 355,000 $ 355,000 $ 355,000 $ 355,000 $ 2,130,000 Miscellaneous Revenues - - - - - - - Operating Transfers In Total Revenues Available 355,000 355,000 355,000 355,000 355,000 355,000 2,130,000 Projected Commitments Annual Parking Lot Maintenance 100,000 60,000 70,000 80,000 310,000 Replacement - CH Parking Lot / Garage Driveway 275,000 275,000 Replacement- Roof Top Package Unit PW 45,000 45,000 Replacement- Furnace CH 4,000 4,000 Replacement- Make Up Air Units / Exhaust Fan PW 75.000 75,000 Replacement- FS #2 Parking Lot 170,000 170,000 Replacement - Emergency Generator FS #1 50,000 50,000 City -Wide Facilities Space Analysis 115,000 115,000 Replacement - Tube Heaters FS #1 35,000 35,000 Replacement - Roof Top Package Units 1-8 CH 120,000 120,000 �) Replacement - Furnace FS #3 10,000 10,000 Replacement - CarpeUTile 30,000 30,000 Replacement - Emergency Generator FS #2 35,000 35,000 Replacement- Fire Sprinkler System FS #1 50,000 50,000 Replacement - Fire Sprinkler System PW 50,000 50,000 Replacement - Roof Top Package Units 9-16 CH 112,000 112,000 Replacement - Garege Door PW 12,000 12,000 Replacement - Garage Door Springs FS #1 25,000 25,000 Replacement - Emergency Generator FS #3 50,000 50,000 Replacement - Fire Sprinkler System CH 50,000 501000 Replacement - Water Heater ASN 5,000 5,000 Replacement - HVAC Unit ASN Building 6,500 6,500 Replacement - Garage Door Springs FS #2 18,000 18,000 Replacement - Seal Floor Bldg 35,000 35,000 Replacement- Emergency Generator CH 60,000 60,000 Andover Station Outlet E - landscaping Improvements 25,000 25,000 Total Commitments 424,000 500,000 414,000 189,500 70,000 175,000 E 1,772,500 Revenues Over (Under) Expenditures (69,000) (145,000) (59,000) 165,500 285,000 180,000 Fund Balance as of December 31, 2021 751,054 Fund Balance Brought Forward 682,054 537,054 478,054 643,554 928,554 Ending Fund Balance $ 682,054 E 537,054 E 478,054 E 643,554 $ 928,554 E 1,108,554 Rates CITY OF ANDOVER Water System Financial Projections Base Rate 513.33 513.67 514.01 $14.15 514.43 514.79 SI5.16 Actual $16.40 Estimate 517.73 Forecast 52.18 52.26 $2.34 Year 2017 2018 2019 2020 2021 2022 2023 20U 2025 2026 2027 Inflation Factor 54.833 55.026 55227 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% Ave. Use (;al per user per q1r) 32.773 36.260 30.487 37,068 39.964 33,000 33,000 33,000 33.000 33.000 33.000 Acres Added 55.605 $5,829 $6.062 56.305 5 5 5 5 5 New Convections 2.0% 2.5% 2.5% 4.0% 10 10 10 10 10 New Customers 3.7% 3.5% 1.7% 1.7% 35 35 35 35 35 Residential Accounts 6,514 6564 6.644 6,750 6,856 4.0% 4.0% 2.0% 2.0% 4.0% 4.0% CmmverciaNnstitutional Accts 149 161 160 162 162 Area Charge 4.0% 4.0% 4.0% 2.0% Total Accounts 6,663 6.725 6,804 6,912 7,018 7.100 7,135 7.170 7,205 7,240 7275 128% 0.93% 1.17% 1.59% 1.53% 1.17% Forecast Rates Base Rate 513.33 513.67 514.01 $14.15 514.43 514.79 SI5.16 515.77 $16.40 517.05 517.73 Use Rate 52.18 52.26 $2.34 52.38 52.42 82.50 $2.56 52.67 $2.77 $2.88 $3.00 Connection Charge 54.833 55.026 55227 55,332 55,439 $5,657 55,883 $6,119 $6.363 $6,618 56.883 Area Charge 54.428 54,605 54,789 54,885 54,983 55,182 55.389 55.605 $5,829 $6.062 56.305 Bax Rate 1.5% 2.6% 2.5% 1.0% 2.0% 2.5% 2.5% 4.0% 4.0% 4.0% 4.0% Use Rate 2.8% 3.7% 3.5% 1.7% 1.7% 3.3% 2.5% 4.0% 4.0% 4.0% 4.0% Connection Charge 4.0% 4.0% 4.0% 2.0% 2.0% 4.0% 4.0% 4.0% 4.01A 4.0% 4.0% Area Charge 4.0% 4.0% 4.0% 2.0% 2.0% 4.0% 4.0% 4.0% 4.0% 4.0% 4.0% Actual Estimate Forecast F.nte rise Fund - Watt,D ra0ons 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 Cash flows firm operating activities: Receipts from customers and users S 2,555,019 $ 3,167,024 S 2,829,052 S 3311,988 S 3,764,171 S 2,817,106 S 2.966,744 S 3,IO,549 $ 3,240.311 S 3.386,294 S 3,538,771 Payment to suppliers (811,931) (830244) (839,369) (991.587) (620.181) (1213286) (1.315,494) (1.154.959) (1.395.608) (1.437.476) (1,480,600) O Payment to employees (440973) (480749) (523.571) (551774) (602.315) (587.993) (608,818) (627.083) (645.895) (665272) (685230) W Net from operating activities 002,115 1.856,031 1,466,112 1,768,627 2,541,675 1.015.827 1,042,432 1,118507 1,198,809 1283,546 1,372,940 Cash flows from noocapiml financing activities: ImMovervmeoml revenue - Transfers in 54,228 114,850 58,110 59,740 148,705 152,877 133.945 14,434 15,011 15,612 16,236 Transfers out -Replacement Reserve - - (300,000) (300.000) (300,000) (300.000) (300.000) (400,000) (400,000) (400,000) (400,000) Trmsfers out - PW Expansiou(YR 20431 - - (157.685) (22,650) (22,650) (22.650) (22,650) (22,650) (22,650) (22,650) (22,650) Transfers out (4%) (150250) (90.700) (95226) (93,975) (115213) (96.091) (170,012) (112,374) (97,660) (84.110) (86.633) Net from nomapital fnaativg activities (96.022) 24,150 (494801) (356,885) (289,158) (265.864) (358,717) (520590) (495299) (491,148) (493.047) Cash flows from capital and related financing activities: Acquisition ofcapital assets (14244) (54264) (64.526) (968,851) (25,000) (1,543,833) (740,500) (150.000) - - Paymemondebt (4,734,401) (776,843) (781.980) (786,499) (780,493) (784500) (782,152) (86,806) - - - Receiptofbonds - - - Proceeds from the sale ofcapital assets 6,635 4,534 - - NetOomcapimlandrelatedfmamingactivities (4742,012) (831107) (841972) (786,499) (1,749,344) (809500) (2.325,985) (827,306) (150,000) - Cash flows from investing activities: Investment income 30,308 55,852 127,377 100,178 (1025) 30,000 30,000 15,000 15,000 15,000 15,000 Net increase in cash and cash equivalents (3,505,611) 1.104.926 256.716 725,421 502.148 (29,537) (1,612270) (214.389) 568,509 807.398 894,893 Cash and cash equivalents - January) 7,161.022 3.655.411 4,760.337 5.017.053 5.742,474 6244,622 6215.085 4,602,815 4,388,426 4.956,936 5,764.334 Cash and cash equivalents-13ecemlxr 31 S 3,655,411 S 4,760,337 S 5.017,053 $ 5,742,474 S 6.244,622 S 6,215,085 S 4,602.815 S 4,388,426 S 4,956,936 $ 5,764.334 5 6,659227 CITY OF ANDOVER Water System Financial Projections Actual Estimate Forecast Ca ital Projects Fund - Water Truok 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 Revenues Connection Charges $ 322,249 S 341,371 $ 852,743 $ 873,581 $ 765,398 $ 56,566 S 58,833 $ 61,186 $ 63,634 S 66,179 $ 68,826 Area Charges - - - - - 25,912 26,946 28,024 29,145 30,311 31,523 Interest 39,859 62,664 145,501 131,533 (8,468) 25,000 25,000 25,000 25,000 25,000 25,000 Special Assessment 409,286 166,435 152,087 48,242 97,642 50,000 50,000 50,000 50,000 50,000 50,000 Replacement Reserve - - 300,000 300,000 300,000 300,000 300,000 400,000 400,000 400,000 400,000 Other - - - - - - 7,000,000 - - - - Xferin Total 771,394 570,470 1,450,331 1,353,356 1,154,572 457,477 7,460,779 564,210 567,779 571,490 575,350 Expenses Debt Service - - - - - - - - - Capital Outlay 103,515 289,691 236,291 213,913 276,400 1,915,000 8,090,000 2,065.000 170,000 175,000 180,000 Xfcr Out 54,228 114,850 58,110 59,740 148,705 152,877 133,945 14,434 15,011 15,612 16236 Total 157,743 404,541 294,401 273.653 425,105 2,067,877 8,223,945 2,079,434 185,011 190,612 196,236 Net Increase(Decresse) in Fund Balance 613,651 165,929 1,155,930 1,079,703 729,467 (1,610,400) (763,166) (1,515,224) 382,768 380,878 379,114 Fund Balance - January) 2,887206 3,500,857 3,666,786 4,822,716 5,902,419 6,631,886 5,021,486 4,258,320 2,743,097 3,125,865 3,506,742 Food Balance -December 31 $ 3,500,857 S 3,666,786 S 4,822,716 $ 5,902,419 S 6,631,886 $ 5,021,486 $ 4,258,320 S 21743,097 S 31125,865 $ 3,506,742 $ 3,885,856 Capital Projects Truck New Development Projects 60,000 60,000 65,000 70,000 75,000 80.000 Water Main Improvements 780,000 1,900,000 Red Oak Manor- Water Main Improvements 7,000,000 Water TowereBlvd Recondition lv Repaint 1,655,000 � Bunker lake Blvd Control Valve Upgrade Water Main Gate Valve Rehabilitation 200,000 250,000 100,000 100,000 100,000 100,000 Welk Rehab Wells 35,000 40,000 40,000 45,000 50,000 Plant/ Equipment / Operations Radon Mitigation 1,345,500 540,500 Equipment 25,000 198,333 85,000 150,000 Plant Maintenance 167,000 157,000 117,000 45,000 50,000 Plate Settler Replacement 115,000 Residential Meter Replacement 100,000 100,000 100,000 100,000 100,000 100,000 Total $ S $ $ $ $ 2,040,000 S 9,935,833 $ 3,102,500 $ 577,000 $ 365,000 $ 380,000 Funded by Operations $ - $ - $ - $ - $ - $ 125,000 S 1,845,833 S 1,037,500 S 407,000 S 190,000 $ 200,000 Funded by ln&astructure/Trunk - - - - - 1,915,000 8,090,000 2,065,000 170,000 175,000 180,000 Funded by debt - - - - - Total S $ $ $ $ S 2,040,000 $ 9,935,833 $ 3,102,500 $ 577,000 S 365,000 $ 380,000 Debt _, .... .. -. ...... .. .: '..: t.. Rale J_-" 5.500%% 5.50% 5.50% 5.50% 5.50% S.50SO% 5.50% 5.50%0% 5.50% 5.50% 5.50% Term 10 10 10 10 10 10 10 15 15 15 15 AADS S - $ - $ - $ - S - $ - S - $ - $ - $ - $ - Cumulative DS $ - S - $ - $ - S - $ - S - $ - $ - $ - $ - Current DS S 4,734,403 S 776,843 S 781,980 $ 786,500 $ 780,500 S 784,042 S 782,152 S 86,806 S - $ - S - CITY OF ANDOVER Sanitary Sewer System Financial Projection Receipts from customers and users S 2,131,393 Actual $ 2,437,302 S 2,416,616 S 2,388,912 Estimate S 2,477,810 $ 2,570,381 S Forecast 2.767,232 S 2.888.091 S 3.014.190 Year 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 (2,180,521) (463,772) (2345,937) (477,685) 1 rte. Net from opemling activities 521,371 510,767 829353 713,235 549,542 571,639 413.938 Inflation Factor 158,898 199,957 243,797 290,568 Cash flows from noncapital financing activities: IM 3.0% 3.0% 3.0% 3.0% 3.0% Acmes Added 5 5 5 5 5 5 New Connections (400.000) (400,000) (400,000) (400,000) (400,000) (400.000) 10 10 10 10 10 10 New Cost.. (22,650) (22,650) (22,650) (22,650) (22,650) (22,650) 35 35 35 35 35 35 Residen0al Accounts 7,331 7,419 7,474 7,552 7,776 7,757 (105.772) (108,945) Net from noncapital finuncing activities (446.680) (446.680) Commercial SACS 1,561 1,592 1,847 1,890 1,989 1,996 (525,341) (528,422) (531,595) Cash flows from capital and related financing activities: Total Accounts 8,892 9,011 9,321 9,442 9,765 9,753 9,800 9,835 9,870 9,905 9,940 9,975 - (22722 1) 1.34% 3.44% 130% 3.42% -0.12% 0.36% (85,000) - - (90,000) Rates 1,425 20,710 11.284 Base Rate $59.37 561.15 561.15 $61.15 $61.15 $61.15 563.00 $64.58 567.16 569.84 $72.64 $75.54 Connection Charge 5435 5452 5452 5452 5452 5452 $466 5485 5504 $524 $545 5567 Area Charge 51,613 $1,678 51,678 51,678 51,678 $1,678 $1,728 51,797 51,869 51,944 22,022 $2,102 Base Rate 0.0% 3.0% 0.0% 0.0% 0.0% 0.0% 3.0% 2.5% 4.0% 4.0% 4.0% 4.0% COaectioWArea 0.0% 3.9% 0.0% 0.0% 0.0% 0.0% 3.1% 4.0% 4.0% 4.0% 4.0% 4.0% Area Clarge 0.0% 4.0% 00% 0.0% 0.0% 0.0% 3.0% 4.0% 4.0% 4.0% 4.0% 4.0% S 3,558,554 5 3,141240 S 2.719,387 S Actual 2,169,379 S 1,868,352 Estimate Forecast Enterprise Fund - Sanity Sewer Operations 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 Receipts from customers and users S 2,131,393 S 2,151,936 $ 2,437,302 S 2,416,616 S 2,388,912 $ 2,392,753 S 2,477,810 $ 2,570,381 S 2.651,398 S 2.767,232 S 2.888.091 S 3.014.190 Payment to suppliers Payment to employees (1,306,202) (103,820) (1.316,251) (304,918) (1272,939) (335,110) (1,369258) (334,123) (1,474,914) (364,456) (1,409,719) (411,395) (1,620,531) (443,341) (1,995,486) (424,417) (2.055,35q (437,150) (2.117,011) (450364) (2,180,521) (463,772) (2345,937) (477,685) 1 rte. Net from opemling activities 521,371 510,767 829353 713,235 549,542 571,639 413.938 150,478 158,898 199,957 243,797 290,568 Cash flows from noncapital financing activities: Transfers out- Replacement Reserve (400,000) (400.000) (400,000) (400,000) (400,000) (400,000) (400.000) (400,000) (400,000) (400,000) (400,000) (400.000) Transfers out - PW Expansion (YR 2043) - - - (157,684) (22,650) (22,650) (22,650) (22,650) (22,650) (22,650) (22,650) (22,650) Transfers out (46,680) (46,680) (70,012) (73,957) (77,123) (76,828) (82,921) (99,809) (103,100) (102,691) (105.772) (108,945) Net from noncapital finuncing activities (446.680) (446.680) (470,012) (631,641) (499,773) (499,478) (505,571) (522,459) (525,750) (525,341) (528,422) (531,595) Cash flows from capital and related financing activities: Acquisition ofcapital assets - (22722 1) (9,864) (119,673) - (1,500) (42,500) (75,333) (85,000) - - (90,000) Proceeds from the sale ofcapiml assets 1,425 20,710 11.284 Net from capital and related financing activities 1,425 (206,511) (9,864) (108,389) (1,500) (42,500) (75,333) (85,000) (90,000) Cash flows from investing activities: Invesunent income 32,181 29285 45,583 91,013 66,326 (3.675) 30.000 30,000 30,000 30,000 30,000 30,000 Net increase in cash said cash equivalents 108297 (113,139) 394,960 64,218 116,095 66,986 (104,133) (417,314) (421,852) (295384) (254,625) (301,027) Cash and cash equivalents-Januny1 3,025,270 3,133,567 3,020,428 3,415.388 3,479,606 3,595,701 3,662,687 3,558,554 3,141340 2,719,387 2,424,003 2,169.379 Cash and cash equivalents -December 31 S 3,133,567 S 3,020,428 S 3,415,388 S 3,479,606 5 3,595,701 S 3.662,687 S 3,558,554 5 3,141240 S 2.719,387 S 2,424,003 S 2,169,379 S 1,868,352 Capital Projects CITY OF ANDOVER Trunk Sanitary Sewer System Financial Projections Actual New Development Projects Estimate Forecast 125,000 Capital Projects Food - Sewer Track 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 Reveaues 3,800,000 Back Up Generator at LS M5 Connection Charges $ 163,162 $ 90,442 $ 103,618 S 300,016 $ 263,301 $ 161,584 S 4,656 $ 4,846 S 5,040 S 5,242 $ 5,452 S 5,670 Area Charges - - - - - - 8,642 8,986 9,345 9,719 10,108 10,512 Interest 87,366 83,110 127,533 236,298 174,256 (17,849) 50,000 50,000 50,000 50,000 50,000 50,000 Special Assessment 28,138 31,329 74,233 30,215 30,089 74,711 20,000 20,000 320,000 320,000 320,000 320,000 Replacement Reserve 400,000 400,000 400,000 400,000 400,000 400,000 400,000 400,000 400,000 400,000 400,000 400,000 Bond Proceeds - - - - - - 75,333 _ _ _ _ - Other $ 7,500 S $ $ S 167,500 $ 4,190,333 $ 1,230,000 $ 140,000 $ 145,000 S 240,000 Total 678,666 612,381 705,384 966,529 867,646 618,446 483,298 483,832 784,385 784,961 785,559 786,181 Expenses - $ - $ - S - $ - S - $ 42,500 $ 185,333 $ 95,000 $ - $ - S 90,000 Debt Service - - - - _ _ _ 125,000 4,005,000 _ _ 145,000 Capital Outlay 205,935 270,363 241,567 1,090,151 24,938 808,747 125,000 4,005,000 1,135,000 140,000 145,000 150,000 Total 205,935 270,363 241,567 11090,151 24,938 808,747 125,000 4,005,000 1,135,000 140,000 145,000 150,000 Net Increase(Decrmse) in Fund Balance 472,731 342,018 463,817 (123,622) 842,708 (190,301) 358298 (3,521,168) (350,615) W,961 640,559 636,181 Fwd Balance -January1 6,081,930 6,554,661 6,896,679 7,360,496 7,236,874 8,079,582 7,889281 8,247,579 4,726,411 4,375,796 5,020,757 5,661,316 Fund Balance - December 31 S 6,554,661 S 6,896,679 S 7,360,496 $ 7,236,874 $ 8,079,582 $ 7,889281 $ 8,247,579 $ 4,726,411 $ 4,375,796 S 5,020,757 S 5,661,316 $ 6297,498 Capital Projects Trunk New Development Projects 125,000 130,000 135,000 140,000 145,000 150,000 Rural Reserve Trunk Sanitary Sewer 3,800,000 Back Up Generator at LS M5 75,000 Crooked lake Blvd Sewer Lining 1,000,000 Operations Lift Station pl Valve Manhole 100,000 Update Controls at Lift Stations 10,000 10,000 Equipment 42,500 75,333 85,000 90,000 Total $ $ $ S $ $ S 167,500 $ 4,190,333 $ 1,230,000 $ 140,000 $ 145,000 S 240,000 Funded by Operations S - $ - $ - S - $ - S - $ 42,500 $ 185,333 $ 95,000 $ - $ - S 90,000 Funded by lnfrustructure/Tmnk - - - - - - 125,000 4,005,000 1,135,000 140,000 145,000 150,000 Funded by debt Total $ S $ $ $ $ $ 167,500 S 4,190,333 $ 1,230,000 $ 140,000 $ 145,000 S 240,000 Debt... ,: ,.. . _. ... _...... .. .._. .. Rate 2.50% 2.50% 2.50% 2.50% 2.50% 2.50% 2.50% 2.50% 2.50% 2.50% 2.50% 2.50% Term 10 10 10 10 10 10 10 10 10 10 10 10 AADS $ - $ - $ - $ - $ - $ - S _ S - $ - $ _ $ $ _ Cumulative DS $ - S - $ - $ - $ - $ - S - S - $ - $ _ $ - $ _ Current DS $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - CITY OF ANDOVER Storm Sewer System Financial Projections Cub flows from capital ad related financing activities: Actual Estimate Forecast Acquisition ofcapiml assets Year 2016 2017 2018 2019 2020 2021 2022 2023 20M 2025 2026 2027 Inflation Factor 5,510 3.0% 3.0% 3.0% 3.0% 3.0% New Customers 5,510 (9,864) (2,130) (2500) 35 33 35 35 35 Residential - Urban/Rural (units) 9,867 9,938 9,959 10,114 10,245 10,277 10,335 10,370 10,405 10,440 10,475 10,510 Multiple l3welling(acres) 220 220 222 212 212 238 212 212 212 212 212 212 Comm/Indamnal (acres) 443 478 478 490 480 480 480 480 480 480 480 480 SCbwls/Chumhm (acres) 282 312 312 312 312 312 312 312 312 312 312 312 Rata (Qtriy) S 253,334 $ 312,756 $ 469,271 $ 543,902 $ 723,743 $ 1,002,424 S 1,031,044 $ 909,840 $ 904,817 $ 992,382 $ 1,084,316 $ 1,180,804 Residential -Urban/Rand - per unit $ 9.36 $ 9.82 S 10.31 $ 10.83 $ 11.37 $ 11.94 $ 12.25 $ 12.56 $ 12.87 S 13.26 $ 13.65 $ 14.06 Multiple Dwelling - pa acre $ 20.61 $ 21.64 $ 22.72 $ 23.86 $ 25.05 $ 26.31 $ 27.63 $ 28.32 S 29.03 $ 29.90 $ 30.80 $ 31.72 Comm/Industrial -per acre $ 39.76 $ 41.75 $ 43.84 $ 46.03 $ 48.33 $ 50.75 $ 53.29 S 54.62 $ 55.99 $ 57.67 $ 59.40 $ 61.18 Schools/Churches - per acre $ 18.71 $ 19.65 $ 20.63 S 21.66 $ 22.74 $ 23.88 $ 23.07 $ 25.70 $ 26.34 $ 27.13 $ 27.94 $ 28.78 Residential -Urban/Rural - per unit S 5.1% 4.9% 5.0% 3.0% 5.0% 5.0% 2.6% 2.5% 2.5% 3.0% 3.0% 3.0% Multiple Dwelling - per acre $ 3.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 2.5% 2.5% 3.0% 3.0% 3.0% Comm/Industrial - per acre 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 2.5% 2.5% 3.0% 3.0% 3.0% Schools/Church. - per acre 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 2.5% 2.5% 3.0% 3.0% 3.0% Tocol $ $ S Achml $ $ S ESOmat, S 304,334 $ 155,000 $ Forecast 74,000 S 76,000 Ent. ria. Fund - Storm SewerO ntiom 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 Cash flows from operating activities: Receipts from customers and users $ 451,961 $ 469,707 S 546,457 $ 564,976 S 587,250 $ 621,979 $ 629,822 $ 667,704 $ 663,608 $ 687,339 $ 709,776 $ 732,939 Payment to suppliers (108.000) (156,064) (116,329) (181,840) (176,379) (119,635) (250.205) (265,638) (273,607) (281,815) (290,270) (298,978) Payment to employees (208,740) (264,334) (227,914) (211652) (200963) (178996) (286336) (280228) (288635) (297294) (306213) (315399) Net fiom operating activities 135,221 49,309 202,214 171,484 209,908 323,348 91,281 121,838 103,366 108,230 113,293 118,562 Cash flows from noncapiml financing activities: Transfers out - Debt Service - - - (23,500) (43,090) (23.500) (23,500) - - - - - Toasfersout © (41,346) (85,088) (19,990) (21661) (31208) (25890) (23164) (23859) (24575) Net from noncapital financing activities (41,346) (108,588) (43,090) (43490) (45161) (31,208) (25890) (23164) (23859) (24375) Cub flows from capital ad related financing activities: Acquisition ofcapiml assets - - (9,864) (2,130) (2,500) - (234,334) (85,000) - - - Procceds 6om the sale ofcapimd assns 5,510 Net from capital and related financing activities 5,510 (9,864) (2,130) (2500) (234334) (83000) Cab flows from iweating activities: lavestmmt inceme 2,080 2,603 5,511 13,865 13,023 1,323 2,500 2,500 2,500 2,500 2,500 2,500 Net increase is cash and caab equivalents 137,301 57,422 156515 74,631 179,841 278,681 48,620 (141,204) (5,023) 87,366 91,934 96,487 Cash and cash equivalents - January) 118,033 255,334 312,756 469,271 543,902 723,743 1,002,424 1,031,044 909,840 904,817 992,382 1,084,316 Cash and cash equivalents - December 31 S 253,334 $ 312,756 $ 469,271 $ 543,902 $ 723,743 $ 1,002,424 S 1,031,044 $ 909,840 $ 904,817 $ 992,382 $ 1,084,316 $ 1,180,804 Cu hal ProeMs .... •.. __. ..... - Storm Sewer bnprovemerm, $ 68,000 $ 70,000 $ 70,000 $ 73,000 S 74,000 $ 76,000 Equipment 42500 234,334 85,000 Total S $ S S $ $ $ 110,500 $ 304,334 $ 135,000 $ 73,000 $ 74,000 $ 767000 Funded by Operations $ - S - $ - $ - $ - $ - $ 110,500 S 304,334 S 133,000 $ 73,000 $ 74,000 $ 76,000 Fundedbylafnsnucturerllunk _ _ _ _ _ _ _ _ _ Funded by debt Tocol $ $ S $ $ $ S 110,500 S 304,334 $ 155,000 $ 73,000 $ 74,000 S 76,000 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 2023 Budget Development Discussion June 28, 2022 INTRODUCTION 60 City Administration has starting to focus on the 2023 Annual Operating Budget Development process and is looking to update the City Council and seek direction as the preparation of the 2023 Annual Operating Budget proceeds. Administration is requesting that Council bring their 2023 service/program ideas to the workshop and be prepared to discuss any additional service provisions you may have. Administration will seek to identify any common themes during discussions and integrate into the budget. City Administration will review briefly with the Council the bold italics items at the meeting. The following are the 2023 Budget Development guidelines adopted at the April 19th City Council meeting: 1) A commitment to a City Tax Capacity Rate to meet the needs of the organization and positioning the City for long-term competitiveness using sustainable revenue sources and operational efficiencies. Note: Preliminary Anoka County Assessor estimated taxable market value figures for the City of Andover base on numbers presented at the Board of Review meeting are reflecting close to a 22% increase in total estimated market value, it is anticipated that will yield a significant taxable market value increase, but lower than 22%. Administration is using a 15% increase in the taxable market value at this stage of the budget process, see attached Pay 2023 Valuation Estimates. 2) A fiscal goal that works toward establishing the General Fund balance for working capital at no less than 45% of planned 2023 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 2022 adopted General Fund budget. Note: With property tax revenues making up close to 80% of the total General Fund revenues cash flow designations approaching 50% are appropriate and recommended by the City's auditor. The 2022 budget development exceeded this guideline for cash flow, also Emergency Fund Balances (approximately 3% of planned General Fund expenditures per finance policy) are in place to stabilize a situation, not be a complete solution. Staffwill review with the Council the attached General Fund 2022 Fund Balance Analysis at the meeting. 3) A commitment to limit the 2023 debt levy to no more than 25% of the gross tax levy and a commitment to a detailed city debt analysis to take advantage of alternative financing consistent with the City's adopted Debt Policy. Note. The adopted 2022 debt levy was 23.29% of the gross tax levy, the 25% guideline for 2023 will be attained via the structured management of the current long-term debt. 4) A comprehensive review of the condition of capital equipment to ensure that the most cost- effective replacement schedule is followed. Equipment will be replaced based on a cost benefit analysis rather than a year -based replacement schedule. Note: The City Vehicle Purchasing Committee has been meeting and is performing this analysis and will make recommendations on equipment needs to the City Council as part of the 2023-2027 Capital Improvement Plan (CIP) development process. This will be covered in more detail with CIP discussions. Administration will review the attached 2022 Capital Improvement Plan Progress to Date at the meeting. 5) The use of long-term financial models that identify anticipated trends in community growth and financial resources that will help designate appropriate capital resources for future City needs. The financial models will be used in the budget planning process to ensure that key short-term fiscal targets are in line with long-term fiscal projections. Note: The City continually maintains various financial models to determine the long-term impacts of present-day expenditures and financing decisions. Fiscal assumptions are based upon a set of financial data including growth factors, tax capacity valuations, per capita spending, fund balance reserve, and debt ratios. 6) Continued commitment to strategic planning targeted toward meeting immediate and long- term operational, staffing, infrastructure and facility needs. Note: The most recent Council Community Vision and Organizational Goals and Values document was adopted by the City Council on December 3, 2019. Administration will assure that direction provided in that document is integrated into department work plans and budgets. 7) A management philosophy that actively supports the funding and implementation of Council policies and goals, and a commitment to being responsive to changing community conditions, concerns, and demands, and to do so in a cost-effective manner. Note. Special attention will be given to fiscal values, commercial & residential development or redevelopment, collaboration opportunities, service delivery, livability, and image of the community. Staffing: Fire Department — Yet to fill for the 2022 budget is filling the Assistant Chiefposition. The 2022 budget also contains funds to help meet acceptable response times with an enhanced Duty Crew model Administration and Fire are closely monitoring the progress of the Duty Crew model, success is crucial as duty crew alternatives such as fulltime firefighters is very expensive. Administration is expecting new staffing requests or staffing restructures from various Departments for the 2023 budget. Deadline for submission of those requests will be July 1s? There are some anticipated retirements and staff vacancies within the coming year and 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 realignment of resources. Personnel Related Implications: To date the following are the other projected issues facing personnel related expenses: L Human Resources will review all position -based salaries and the associated benefit package to determine if the total package is competitive with other government entities. Pay steps for eligible employees will be included in a 2023 budget proposal A cost -of - living adjustment (COLA) for non -bargaining employees will also be evaluated. The current Public Works Union contract expires December 31, 2023. A 2.75% increase effective January 1, 2023 is provided for in that contract 2. A midyear review of the employee health plan for the 2023 Budget will be conducted with our broker in late July. For the 2022 budget, Administration recommended to stay with the Health Partners Open Access program. The existing HSA plan with higher deductibles ($6,900 single and $13,800 family) and stacked with an HRA (Health Reimbursement Arrangement) was offered for 2022. The HRA was funded utilizing premium savings that were achieved from the proposed renewal to a new higher deductible plan. Employees have $3,500 single and $7,000 family deductibles; but with the stacked HRA, the City will reimburse the remainder of the deductible, if needed, to the provider up to $3,400 for single and $6,800 for family. The plan offered is accompanied with a health spending account (HSA), originally implemented in 2006. The City does contribute annually to an employee's HSA to assist with the high deductible out of pocket costs. That contribution is evaluated annually as part of the marketing of the health insurance plans. Contractual Departments: 1. The City Attorney 2022 contract reflected a 2% increase over the 2021 contract There have been limited discussions to date for 2023, anticipating a status quo contract 2. The 2022 City of Andover Law Enforcement expenditure is budgeted at $3,337,486 which is offset by a Police State Aid revenue budget of $137,280 and School Liaison revenue budget of $106,465 reflecting a net tax levy impact of $3,093,741. The 2022 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. Staff discussions with the Anoka County Sheriff for a 2023 contract take into consideration efficiencies brought about by technology investments and a detailed evaluation of reactive/proactive patrolling, and matching staffing with historical incident call times. The proposed 2023 City of Andover Law Enforcement expenditure is budgeted at $3,366,659 (0.87% increase) which is offset by a Police State Aid revenue budget of $126,192 and School Liaison revenue budget of $106,465 reflecting a net tax levy impact of $3,134,002 (1.3% increase). The proposed 2023 Sheriff's contract provides for: a. 72 hours per day of patrol service b. 6 hours per day of service provided by a Community Service Officer c. School Liaison Officers in the middle school and high school d. 2 Patrol Investigators e. 50% of the Crime Watch Program's coordinator position Per contract, the Sheriff always provides the required number of deputies for all hours contracted by the City. If the Sheriffs Office has a deputy vacancy or a deputy is injured etc., they still provide the City with a deputy at straight time even though they may have to fill those hours with overtime which at times may cost the Sheriff's Department additional but is not billable per the contract. The Anoka County Sheriffs Office is scheduled to be before the City Council at the August workshop meeting. A Proposal Summary and Analysis ofACSO Patrol StaifinQ is attached Council Memberships and Donations/Contributions: The following memberships/contributions are in the 2022 proposed budget, updated for 2023: • North Metro Mayors Association • Metro Cities • Mediation Services • YMCA— Water Safety Program • Alexandra House • Youth First (Program Funding) • NW Anoka Co. Community Consortium - JPA • Teen Center Funding (YMCA) • Family of Promise • Lee Carlson Central Center for Family Resources • Senior High Parties • Stepping Stone • Hope for Youth • Andover Senior Center $14,261 (GF) $ 9,569 (GF) $ 6,628 (GF) $ 9,000 (GF) $20,928 ($15,328 GF & $5,600 CG) $15,000 ($12,000 GF & $3,000 CG) $10,000 (GF) $26,000 ($5,600 GF & $20,400 CG) $ 3,000 (CG) $ 1,500 (GF) $ 1,000 (CG) $ 1,000 (CG) $ 1,000 (CG) $ 3,500 (GF) Some are funded via the General Fund (GF), and those that qualify for charitable gambling funding are done through the Charitable Gambling (CG) Special Revenue Fund Council direction will be sought on the memberships/contributions for 2023. Debt Service Levy: Annually the Finance Department conducts a detailed debt service analysis to monitor outstanding debt and to look for early debt retirement or refinancing opportunities that will yield interest expense savings to the city. (Staff, along with Ehlers & Associates will complete reviews to see if any refinancing opportunities are available at this time; we will then continue to monitor refunding opportunities, as markets move quickly, and calculate potential savings for each issue that may meet parameters which may generate savings) The 2023 Debt Service levy is as follows • 2012C Taxable G.O. Abatement Bonds $ 969,745 Final levy year 2031 • 2018A Capital Improvement Plan Bonds $ 612,794 Final levy year 2043 • 2019A GO Abatement Bonds $1,028,782 Final levy year 2039 • 2020A GO Equipment Certificates $ 376,740 Final levy year 2023 • 2021 GO Equipment Certificates $ 174,773 Final levy year 2025 • 2022 GO Street Reconstruction $ 603,863 Final levy year 2029 Total $3.751.062 Staff will review with the Council at the meeting, primarily to determine how the debt service budget guideline will be met ACTION REQUESTED The Council is requested to receive a presentation and provide direction to staff. submitted, CITY OF ANDOVER Pay 2023 Valuation Estimates Taxable Market Values $5,000,000,000 $4,500,000,000 $4,000,000,000 $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 2020 Pay 2021 Pay 2022 Pay 2023 Tax Capacity Values $50,000,000 $45,000,000 $40,000,000 $35,000,000 $30,000,000 $25,000,000 $20,000,000 $15,000,000 $10,000,000 $5,000,000 $0 Pay 2020 Pay 2021 Pay 2022 Pay 2023 ESTIMATE Pay 2020 Pay 2021 Pay 2022 Pay 2023 Taxable Tax Taxable Tax Taxable Tax Taxable Tax Market Capacity Market Capacity Market Capacity Market Capacity Value Value Value Value Value Value Value Value Andover Valuation Totals $ 3,561,318,700 $ 36,099,539 $ 3,615,408,106 $ 37,366,775 $ 3,885,459,439 $ 40,210,548 $ 4,468,278,355 $ 46,242,130 Captured Tax Increment (114,064) (119,819) (122,976) (122,976) Fiscal Disparity Contribution (1,310,143) (1,348,420) (1,414,808) (1,414,808) Local Tax Rate Value 34,675,332 35,898,536 38-6-7-2,7-647— 8672,764Fiscal FiscalDisparity Distribution 5,355,244 5,475,223 6,037,850 6,037,850 Total Adjusted Values $ 40,030,576 $ 41,373,759 —$-44—,7-10,6-14—F $ 50,742,198 3.36% 8.07% 13.49% Taxable Market Value Tax Capacity Value % Change % Change Pay 2020 $ 3,561,318,700 Pay 2020 $ 36,099,539 Pay 2021 $ 3,615,408,106 1.52% Pay 2021 $ 37,366,775 3.51% Pay 2022 $ 3,885,459,439 7.47% Pay 2022 $ 40,210,548 7.61% Pay 2023 $ 4,468,278,355 15.00% Pay 2023 $ 46,242,130 15.00% Taxable Market Values $5,000,000,000 $4,500,000,000 $4,000,000,000 $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 2020 Pay 2021 Pay 2022 Pay 2023 Tax Capacity Values $50,000,000 $45,000,000 $40,000,000 $35,000,000 $30,000,000 $25,000,000 $20,000,000 $15,000,000 $10,000,000 $5,000,000 $0 Pay 2020 Pay 2021 Pay 2022 Pay 2023 City of Andover General Fund 2022 Fund Balance Analysis 12/31/2 Actual December 31, 2021 $ 9,626,466 2021 Estimated Fund Balance Increase (Decrease) (364,625) Projected December 31, 2021 9,261,841 Less: Snow Emergency (100,000) Public Safety (100,000) Facility Management (100,000) Information Technology (100,000) 2023 Budgeted Use of Fund Balance (480,213) Economic Development (150,000) Fiscal Disparities Flunctuation (300,000) Prepaids / Inventories (154,736) Working Cash Flow (6,940,052) Estimated Balance Available for Adjustments $ 836,840 2022 Working Cash Flow Designation Calculation: 2023 Requested Expenditure - Preliminary Estimate $13,880,104 % of 2023 General Fund Expenditures 50.000% $ 6,940,052 Matches 2023 General Fund Revenue and Expense Summary CITY OF ANDOVER 2022 Capital Improvement Plan Projects By Department - Use of Funds Project/ Equipment Budget Community Center Replacement- Walk Behind Floor Scrubber Exterior Caulking New - Scissor Lift Emergency Management Replacement - Emergency Sirens Emergency Operations Center Improvement Engineering New Development Projects Pedestrian Trail Maintenance Replacement - Pick Up Truck #6 Facility Management Annual Parking Lot Maintenance Replacement - Roof Top Package Unit PW Replacement - Furnace CH Fire New - First Response Vehicle New - Digital Fire Extinguisher Training System Replacement -800 MHz Radios Replacement - Grass / Rescue Vehicle New - Mobile CAD Park & Recreation - Operations Replace/Repair Play Structures - Various Parks Replace/Repair Major Park Projects - Various Parks Replacement - Cushman #546 Replacement - Tractor #515 New - Zero -Turn Mower Replacement - Large Capacity Mower #585 Park & Recreation - Projects Annual Miscellaneous Projects Pine Hills North - Parking Lot Dog Park - Parking Lot & Trail Pine Hills South - Parking Lot Oak Bluff Park - New Basketball Court Sanitary Sewer Replacement - One Ton Truck w/ Plow #78 Storm Sewer Storm Sewer Improvements Streets - Equipment New - Dump Truck w/ Snow Removal Equipment Replacement - Asphalt Roller #114 Replacement - Dump Truck w/ Snow Removal Equipment $ 15,000 50,000 15,000 80,000 50,000 15,000 65,000 185,000 60,000 50,000 295,000 275,000 45,000 8,000 328,000 70,000 12,000 50,000 275,000 12,000 419,000 100,000 35,000 13,000 50,000 10,000 130,000 338,000 Progress to Date - 06/22/22 changes in BOLD equipment demo in May bid received delivered delivery week of 06/20/22 to be determined ongoing bids received, summer start reserved at dealership plans being prepared, late summer start waiting for delivery completed will be ordered later in the year Grant funded - not approved ordered Grant funded - not approved working on specs ordered to be determined ordered delivered delivered delivered 25,000 to be determined 400,000 bid opening late May, late summer start 37,500 bid opening late May, late summer start 67,000 bid opening late May, late summer start 10,000 bid opening late May, late summer start 539,500 85,000 to be ordered soon 68,000 ongoing 250,000 chassis built, waiting for box & plow 20,000 nothing available at this time 255,000 chassis built, waiting for box & plow 525,000 CITY OF ANDOVER 2022 Capital Improvement Plan Projects By Department - Use of Funds Project / Equipment Budget Progress to Date - 06/22/22 Residential Meter Replacement 100,000 changes in BOLD Streets - Roadways 200,000 will be completed w/ road projects Annual Street Crack Seal Project 190,000 bids awarded, summer construction Annual Pavement Markings 60,000 bids awarded, summer construction Curb, Sidewalk & Pedestrian Ramp Replacement 105,000 bid awarded, summer construction Municipal State Aid Routes / New & Reconstruct 1,600,000 Design in 2022, construction 2023 Annual Street Reconstruction 3,400,000 bids awarded, construction late April Gravel Road Improvement 19,000 work this summer Street Mill & Overlay 2,000,000 bids awarded, summer construction Municipal State Aid Routes / Mill & Overlay 170,000 bids awarded, summer construction Bunker Lake Blvd Concrete Median 150,000 ACHD to administer project, summer start 7,694,000 Water Recondition & Paint Water Tower 1,655,000 completed by July 1st Residential Meter Replacement 100,000 ordered in Jan, still unavailable Water Main Gate Valve Rehabilitation 200,000 will be completed w/ road projects WTP Valve Actuator Replacement 52,000 completed 2,007,000 Grand Total $ 12,443,500 Andover - Cost Summary 72HR January 2023- December 2023 Attachment A L PERSONNEL A. Sworn Deputy Sheriff 1.) 15.12 Patrol Deputies $3,366,659 1,397,306 2.) 7 Overtime (Average hours/month per Deputy) 90,243 3.) 2 Liaison Officers 184,829 4.) 2 Patrol Investigators 187,689 B. Non -Sworn C.S.O. 6 hours per day 39,420 Non -Sworn C.S.O. - Parks 9,360 C. Crime Watch Coordinator 20 hours/week 32,074 Benefits for Sworn and Non -Sworn Personnel Total Benefits 752,684 TOTAL PERSONNEL COSTS $2,693,604 II. VEHICLE A. Police Equipped Vehicles 3 Squads 114,150 B. C.S.O. Vehicle 1 Vehicle 4,000.00 C.S.O. Vehicle - Parks 0(splltusage withcsovehicleabove) 3,200.00 C. Combined below vehicles 1 Vehicle 38,050.00 D. Crime Watch Coordinator Vehicle - 1/2 E. Patrol/Crime Investigators Vehicles/Crime Watch F. Total Maintenance Costs for all vehicles 1.) Vehicle 128,668 2.) Emergency & Communications Equipment 40,375 3.) Emergency Vehicle Equip. replc fee 5,000 4.) Insurance 30,160 5.) Cellular Telephone 9,178 Total Maintenance Costs 213,380 TOTAL VEHICLE COSTS $372,780 III. Administrative Costs A. PSDS Maintenance costs & Aps 18,666 B. Administrative, Clerical,+ computer fee charges Etc. 281,610 Total Administrative Costs $300,275 IV. TOTAL COST TO CONTRACTING MUNICIPALITY $3,366,659 'Less Amount Received From State for Police State Aid 126,192 NET COST TO CONTRACTING MUNICIPALITY $3,240,467 'This figure is determined by the State and is subject to fluctuation. The latest estimate is $6600 per Deputy. Revenue received is for previous year Deputy hours hired prior to Aug 1 Detail Attached Analysis Of ACSO Patrol Staffing Requirements Andover 1 Community Generated Workload • Calls For Service 13,114.00 • Handling time/CFS in hrs. (@34:18 Actual) 0.57 • Total CFS handling time in hrs. 7,470.61 • Officer back-up rate (@1.4 — Est.) 0.40 • Officer back-up time (back-up @75% of first unit time on scene) in hours. 2,241.18 • Number of bookings (Est.) 280.00 • Booking time (Est. @ 0.75 hrs/booking) in hours 210.00 • Number of reports 7,000.00 • Report writing time (est. @ 30 minutes min. avg) in hours 3500 Total Time Required To Handle Community Generated Workloads (Hrs.) 2. Time for Preventative Patrol and Self Initiated Activities ((& Alternative Levels of Proactivitv), in Hours. • 50% of Available Time 13,421.79 • 40% of Available Time 8,947.86 3 Total Time Required To Handle Both Reactive and Proactive Activities (In Hrs.) • @ 50% of Available Time 26,843.58 • @ 40% of Available Time 4. Officer Availability Est. Availability • Net shifts worked 2,080 • Net hours lost on shift 362 Net hours worked each year 1,718 5 Deputies Required to Handle Workloads • @ 50% of Proactive Time 15.62 • @ 40% of Proactive Time 13.02 6. Deputies Required Given Est. Turnover and Time Needed to Academy and Field Train • @ 50% of Proactive Time 16.15 • @ 40% of Proactive Time 13.46 Based on 2020 Calls for Service 06/01/2022