Loading...
HomeMy WebLinkAbout_06 21 2021 City Council Agenda PacketCHECK REGISTER FOR CITY OF PRIOR LAKE 1/5Page: 06/14/2021 08:35 AM User: Janet DB: Prior Lake CHECK DATE FROM 05/28/2021 - 06/11/2021 AmountDescriptionVendor NameVendorCheckBankCheck Date Bank 1 General Bank 1,865.12 2021 Dental ClaimsDELTA DENTAL000272137249(E)106/01/2021 21.90 Jun 2021 Merchant FeesAUTHORIZE.NET000268217250(E)106/02/2021 31,093.87 Jun 2021 Electric BillsXCEL ENERGY000147207251(E)106/02/2021 4,400.00 GO Bonds 2011ANORTHLAND TRUST SERVICES INC000147767252(E)106/10/2021 44,642.50 GO Bonds 2011B 69,423.75 GO CIP Refunding Bonds 2012A 11,977.50 GO Bonds 2013A 10,650.00 GO Bonds 2014A 123,662.50 GO Bonds 2015A 8,865.00 Taxable GO Bonds 2015B 17,650.00 GO Bonds 2016A 32,181.25 GO Bonds 2017A 149,750.00 GO Bonds 2018A 47,500.00 GO Bonds 2019A 520,702.50 2,400.00 May 2021 Animal Control4 PAWS ANIMAL CONTROL LLC000067987253(A)106/04/2021 2,060.00 Overhead Door - MCAUTOMATED DOOR SERVICE INC000274197254(A)106/04/2021 2,971.00 Laptop, Docking StationBAYCOM INC000269697255(A)106/04/2021 2,372.85 May 2021 Misc SuppliesCARLSON HARDWARE COMPANY000031257256(A)106/04/2021 3,780.00 Ponds & Ryan Parks Restroom CleaningCOVERALL000275717257(A)106/04/2021 7,890.00 Jun 2021 Cleaning 11,670.00 28.00 547 Box door latchCRYSTEEL TRUCK EQUIPMENT000039557258(A)106/04/2021 20.91 HRA Returned ChecksERIC WHITMER000235597259(A)106/04/2021 834.30 May 2021 LocatesGOPHER STATE ONE-CALL INC000075257260(A)106/04/2021 2,598.75 May 2021 GeneralHOFF BARRY PA000273877261(A)106/04/2021 82.50 May 2021 Bylaws 742.50 May 2021 Annexation 330.00 May 2021 Data Practices/Open Meeting 907.50 May 2021 Finance 247.50 May 221 Franchises 82.50 May 2021 PW/Engineering 123.75 May 2021 Recreation 82.50 May 201 CH 21& Revere Way 536.25 May 2021 Enforcement 742.50 May 2021 Development 371.25 May 2021 Police 453.75 May 2021 Code Pt 3 123.75 May 2021 Code Pt 6 1,031.25 May 2021 Code Pt 11 185.00 May 2021 Litigation 1,100.00 May 2021 AT&T at Cedarwood 9,741.25 865.10 May 2021 UniformsHUEBSCH000275367262(A)106/04/2021 145.38 Misc Office SuppliesINNOVATIVE OFFICE SOLUTIONS LLC000271497263(A)106/04/2021 49.85 Donuts - UB Software TrainingKELLY HORN000279827264(A)106/04/2021 47,902.00 South Water Tower ReconditioningKLM ENGINEERING INC000115207265(A)106/04/2021 455.00 Duplicate Keys - MCLOCKSAFE 000108557266(A)106/04/2021 409.00 TonerMETRO SALES INCORPORATED000133867267(A)106/04/2021 CHECK REGISTER FOR CITY OF PRIOR LAKE 2/5Page: 06/14/2021 08:35 AM User: Janet DB: Prior Lake CHECK DATE FROM 05/28/2021 - 06/11/2021 AmountDescriptionVendor NameVendorCheckBankCheck Date 185.47 Repair Ricoh C3003 594.47 137,768.55 Jun 2021 Waste Water ServiceMETROPOLITAN COUNCIL000134007268(A)106/04/2021 142.56 538 Exhaust pipe MTI DISTRIBUTING INC000139517269(A)106/04/2021 965.15 Paper ProductsNETWORK SERVICES COMPANY000143817270(A)106/04/2021 476.84 ApparelNORTH AMERICAN SAFETY000145747271(A)106/04/2021 410.30 521 Box stand NOVAK COMPANIES000149007272(A)106/04/2021 587.23 Apr 2021 Data & SoftwarePRECISE MOBILE RESOURCE MGMT000165487273(A)106/04/2021 560.47 May 2021 Misc SuppliesPRIOR LAKE HARDWARE000166587274(A)106/04/2021 285.00 E Coli TestingUC LABORATORY000212357275(A)106/04/2021 107.16 GFCI CoversVIKING ELECTRIC SUPPLY000226307276(A)106/04/2021 398.90 Bulbs 223.44 GFCI Self Test 729.50 1,747.16 AsphaltWM MUELLER & SONS INC000236457277(A)106/04/2021 3,755.50 Dev Plan ReviewsWSB & ASSOCIATES INC000237807278(A)106/04/2021 3,619.50 Parkwood Estates Traffic Study 7,375.00 29.70 City Hall First Aid SuppliesZEE MEDICAL SERVICE000263507279(A)106/04/2021 207,140.00 #8488 Cat 938M LoaderZIEGLER INC000265007280(A)106/04/2021 111.69 Franklin lift station block heater 207,251.69 6,096.26 May 2021 Natural Gas BillsCENTERPOINT ENERGY000135707282(E)105/28/2021 318.95 May 2021 Merchant FeesPAYMENT SERVICE NETWORK INC000161417283(E)106/03/2021 400.00 Move CompressorALEX AIR APPARATUS INC000013297284(A)106/10/2021 885.40 Compressor Service & Air Quality Test 1,285.40 71.30 3V Lithium BatteriesBATTERIES PLUS000021307285(A)106/10/2021 4,500.00 Tree Removal - 14881 Timberglade Circle COLLINS TREE 000036707286(A)106/10/2021 1,254.00 IT SupportCOMPUTER INTEGRATION TECH000037607287(A)106/10/2021 292.80 Cable TieFASTENAL COMPANY000061407288(A)106/10/2021 585.60 Cable Tie 878.40 60.13 FilterG&B ENVIRONMENTAL INC000278747289(A)106/10/2021 50.00 Kleist - Business CardsINNOVATIVE OFFICE SOLUTIONS LLC000271497290(A)106/10/2021 50.00 Frazer - Business Cards 20.64 Disinfectact Wipes 40.34 Toner 160.98 9,287.92 May 2021 UnleadedKELLEY FUELS INC000112197291(A)106/10/2021 5,083.46 May 2021 Diesel 14,371.38 CHECK REGISTER FOR CITY OF PRIOR LAKE 3/5Page: 06/14/2021 08:35 AM User: Janet DB: Prior Lake CHECK DATE FROM 05/28/2021 - 06/11/2021 AmountDescriptionVendor NameVendorCheckBankCheck Date 115.00 Jelle - SCBA ExamMED-COMPASS INC000133067292(A)106/10/2021 3,620.00 SCBA Exams, Fit Tests 3,735.00 590.90 Apr 2021 Random Drug TestingMN OCCUPATIONAL HEALTH000270997293(A)106/10/2021 654.00 Seasonal CSO Pre-Emp Testing 1,244.90 23.10 538 Valve cover gaskets MTI DISTRIBUTING INC000139517294(A)106/10/2021 120.40 504 Cabin Filter 64.60 503 Deck spacers 208.10 115.36 Apr, May 2021 MileageNICHOLAS MONSERUD000273907295(A)106/10/2021 525.00 May 2021 Labor & EmploymentNILAN JOHNSON LEWIS000081237296(A)106/10/2021 139.19 507 Hitch pins NOVAK COMPANIES000149007297(A)106/10/2021 400.00 June 2021 ROWay AppPERRILL000065027298(A)106/10/2021 1,524.16 AsphaltWM MUELLER & SONS INC000236457299(A)106/10/2021 174.00 Asphalt 1,698.16 68.05 Mtce Center First Aid SuppliesZEE MEDICAL SERVICE000263507300(A)106/10/2021 1,292.34 2021 Dental ClaimsDELTA DENTAL000272137301(E)106/07/2021 312.25 Jun 2020 Vision PremiumsEYEMED000279177302(E)106/07/2021 46.00 Filing Fee - Res 21-06PCSCOTT COUNTY000192127303(E)106/08/2021 603.81 May 2021 Merchant Card FeesTRANSFIRST000206937304(E)106/10/2021 70.00 May 2021 Technology Time ClassAMANDA FAY00027666108215106/04/2021 105.00 May 2021 Tai Chi InstructorCHRISTINE T MORGAN00027316108216106/04/2021 117.43 May 2021 Bottled WaterCULLIGAN BOTTLED WATER00003958108217106/04/2021 2,542.98 May 2021 RefuseDICK'S SANITATION INC00027918108218106/04/2021 2,179.21 Jun 2021 Refuse 4,722.19 383.93 Water MetersFERGUSON WATERWORKS #251600006231108219106/04/2021 2,320.00 Water Meters 1,024.00 Water Meters 3,727.93 315.00 Apr May 2021 Yoga InstructorGWENDOLYN SCHMID00027984108220106/04/2021 2,325.92 Water Heater - City HallHAYES ELECTRIC INC00008315108221106/04/2021 1,693.44 GFI Replacement - Parks 873.77 A/C Rewire - WTP 1,398.85 Light Repair - CH 276.00 SCBA Reconnect - FS #1 6,567.98 7,100.00 Water Heater - City HallKLAMM MECHANICAL CONTRACTORS INC00026904108222106/04/2021 2,500.00 19-0543 5832 Pinnacle Circle NELENNAR HOMESMISC-CD108223106/04/2021 115.15 PartsMENARDS LUMBER CO00013318108224106/04/2021 47.41 Misc Supplies 162.56 CHECK REGISTER FOR CITY OF PRIOR LAKE 4/5Page: 06/14/2021 08:35 AM User: Janet DB: Prior Lake CHECK DATE FROM 05/28/2021 - 06/11/2021 AmountDescriptionVendor NameVendorCheckBankCheck Date 41,822.55 May 2021 SAC ChargesMETROPOLITAN COUNCIL-SAC00013406108225106/04/2021 41,281.68 Seal CoatingNORTHWEST ASPHALT & MAINTENANCE00027983108226106/04/2021 2,000.00 6/19/2020 Music in the ParkPHAT VOX LLC00027761108227106/04/2021 2,035.21 Ponds Park Dugouts - Refund Sales TaxPLAY SPORTS00016412108228106/04/2021 2,500.00 19-2220 14472 Shady Beach Tral NERONALD RENISMAMISC-CD108229106/04/2021 14,058.49 2021 JPA Line PaintingSIR LINES-A-LOT00019531108230106/04/2021 32,745.16 May 2021 Water PurchasesSMSC00019384108231106/04/2021 1,504.68 Stihl TrimmerTIM'S SMALL ENGINE REPAIR INC00020510108232106/04/2021 959.80 40V Weed Whip Batteries 2,464.48 19,937.00 8469 Wing replacement and box hinge repaTOWMASTER00020659108233106/04/2021 31,873.50 Well #9 RehabTRAUT COMPANIES00020705108234106/04/2021 150,306.91 Honeywell EPC ContractUS BANK00002105108235106/04/2021 4,676.64 May 2021 Cell Phone BillsVERIZON WIRELESS00001315108236106/04/2021 5,824.67 Jun 2021 Cell Phone Bills 10,501.31 50.00 Bean Bag 1st PlaceANDERS SCHMIDTREFUND-REC108237106/10/2021 248.68 CoffeeARAMARK REFRESHMENT SERVICES00001772108238106/10/2021 59.53 Coffee 308.21 45.87 UB REFUND ACCT: 202671-02ASHLEY HEMMINGSENREFUND-UB108239106/10/2021 103.71 UB REFUND ACCT: 208153-01BARBRA MERWINREFUND-UB108240106/10/2021 110.93 UB REFUND ACCT: 207788-01BRAD MATTSONREFUND-UB108241106/10/2021 240.47 UB REFUND ACCT: 405350-00CHAD ROSSREFUND-UB108242106/10/2021 240.52 UB REFUND ACCT: 308867-01CHRIS MYERSREFUND-UB108243106/10/2021 55.36 Water - 4662 Dakota St SECITY OF PRIOR LAKE00016810108244106/10/2021 32.73 May 2021 UB Billing FinalsCSG SYSTEMS INC00027506108245106/10/2021 13.55 UB REFUND ACCT: 107268-04DAVID & NICOLE HOENREFUND-UB108246106/10/2021 202.07 UB REFUND ACCT: 405042-00DAVID DEWALLREFUND-UB108247106/10/2021 10.86 UB REFUND ACCT: 102211-03DAVID THOMPSONREFUND-UB108248106/10/2021 530.00 Chalkfest Caricature ArtistsFUN JUMPS ENTERTAINMENT INC00027423108249106/10/2021 88.00 FuseGRAINGER INC00023030108250106/10/2021 985.89 Jun 2021 Misc SuppliesHOME DEPOT CREDIT SERVICES00008865108251106/10/2021 106.89 Polo ShirtsJACK'S UNIFORMS & EQUIPMENT00027636108252106/10/2021 16.66 UB REFUND ACCT: 303623-02JACKIE KNUTSONREFUND-UB108253106/10/2021 37.10 UB REFUND ACCT: 408792-01JAMES CRAIGREFUND-UB108254106/10/2021 14.11 UB REFUND ACCT: 306330-01JAMES VALENTOREFUND-UB108255106/10/2021 24.06 UB REFUND ACCT: 100357-02JASON VIGREFUND-UB108256106/10/2021 1,941.70 Holmatro V-StrutJEFFERSON FIRE & SAFETY INC00010359108257106/10/2021 50.00 Youth Yoga InstructorJENIFER MATTHEWS00027988108258106/10/2021 100.00 Summer Program InstructorJENNIFER HOLM REICHSTADT00027985108259106/10/2021 36.80 UB REFUND ACCT: 407371-01JOHN & RHONDA HARMANREFUND-UB108260106/10/2021 51.03 UB REFUND ACCT: 100218-00JOHN SPIELMANREFUND-UB108261106/10/2021 28.40 UB REFUND ACCT: 407494-02JULIE BOCOCKREFUND-UB108262106/10/2021 47.36 UB REFUND ACCT: 309119-01KEITH & MICHELLE KOVACEVICKREFUND-UB108263106/10/2021 300.00 DJ - 6/1/2021 Beach PartyKIDSDANCE00011347108264106/10/2021 450.00 DJ - ChalkfestKIDSDANCE00011347108265106/10/2021 35.89 UB REFUND ACCT: 308980-01LAUREN HERRERAREFUND-UB108266106/10/2021 24.00 Jun 2021 Go To Meeting LicenseLOGMEIN INC00026895108267106/10/2021 19.64 UB REFUND ACCT: 100193-00LORETTA MALZREFUND-UB108268106/10/2021 7.61 UB REFUND ACCT: 101971-03MATTHEW & NICOLE PETITEREFUND-UB108269106/10/2021 169.99 Air MoverMENARDS LUMBER CO00013318108270106/10/2021 12,250.00 Legislative RepresentationMESSERLI & KRAMER00027771108271106/10/2021 CHECK REGISTER FOR CITY OF PRIOR LAKE 5/5Page: 06/14/2021 08:35 AM User: Janet DB: Prior Lake CHECK DATE FROM 05/28/2021 - 06/11/2021 AmountDescriptionVendor NameVendorCheckBankCheck Date 125.98 UB REFUND ACCT: 106392-02MICHAEL & PATRICIA MUNSONREFUND-UB108272106/10/2021 9.70 UB REFUND ACCT: 406482-03MIKE & KELLY HOEPPNERREFUND-UB108273106/10/2021 12.00 Cameron - Credit CheckMULTIHOUSING CREDIT CONTROL00013968108274106/10/2021 44.93 UB REFUND ACCT: 101273-00PAMELA JUULREFUND-UB108275106/10/2021 60.46 Misc ReimbursementsPETTY CASH00016300108276106/10/2021 2,000.00 6/18/2021 Music in the ParkPHAT VOX LLC00027761108277106/10/2021 27.62 UB REFUND ACCT: 100614-01RICHARD & KAREN SWEETREFUND-UB108278106/10/2021 46.18 UB REFUND ACCT: 405436-00ROBERT REJDAREFUND-UB108279106/10/2021 84.00 MulchROCK HARD LANDSCAPE SUPPLY00018571108280106/10/2021 120.00 Frazer - DuesROTARY CLUB OF PRIOR LAKE00018675108281106/10/2021 454.82 UB REFUND ACCT: 203414-00SANDI CARLTONREFUND-UB108282106/10/2021 30.86 UB REFUND ACCT: 108195-03SARAH GAVANDAREFUND-UB108283106/10/2021 75.00 UB REFUND ACCT: 303905-01SAWYER & KATIE DESOTELLEREFUND-UB108284106/10/2021 716.47 May 2021 Legal AdsSOUTHWEST NEWS MEDIA00019676108285106/10/2021 56.36 UB REFUND ACCT: 407700-01TAMMY HIGGINSREFUND-UB108286106/10/2021 94.00 Tennis Camp RefundTASHA MYRAHREFUND-REC108287106/10/2021 81.41 UB REFUND ACCT: 202308-00TIM & TAMMY HANSONREFUND-UB108288106/10/2021 154.90 May 2021 Misc SuppliesTRACTOR SUPPLY CREDIT PLAN00020663108289106/10/2021 35.13 UB REFUND ACCT: 407566-03TRACY EDDINGTONREFUND-UB108290106/10/2021 210.06 May 2021 Investigative ServicesWEST PAYMENT CENTER00023420108291106/10/2021 113.80 UB REFUND ACCT: 300205-00WILLIAM ALLENREFUND-UB108292106/10/2021 1 TOTALS: 1,433,705.08 Total of 133 Disbursements: 0.00 Less 0 Void Checks: 1,433,705.08 Total of 133 Checks: City of Prior Lake Expenditures- Payroll and BenefitsAs of 5/31/2021 (Preliminary & Unaudited)Activity for Activity for Variance from Variance fromPrevious Month Month 2021 2021 2021 Amended Budget ‐ % BDGT5/31/20from 20204/30/2021 5/31/2021 Budget Amended Actual YTD Positive (Negative) USEDActual YTD Positive (Negative)GENERAL FUNDFunction: General Government41110.00 MAYOR & COUNCIL 4,899                          5,526                          66,234                 66,234                 25,959                 40,275                               39% 25,606                     (353)                                       41320.00 ADMINISTRATION 15,809                        16,591                        197,222               197,222               73,182                 124,040                            37% 146,123                   72,941                                   41330.00 BOARDS & COMMISSIONS 323                             861                             10,765                 10,765                 2,338                   8,427                                 22% 1,399                       (938)                                       41400.00 CITY CLERK FUNCTIONS 9,303                          9,437                          120,422               120,422               42,493                 77,929                               35% 41,077                     (1,416)                                    41410.00 ELECTIONS 171                             (33)                              3,500                   3,500                   137                       3,363                                 4% 7,677                       7,540                                     41520.00 FINANCE 42,035                        41,401                        537,955               537,955               192,127               345,828                            36% 148,104                   (44,024)                                  41820.00 HUMAN RESOURCES 21,147                        20,719                        271,624               271,624               96,367                 175,257                            35% 57,923                     (38,444)                                  41830.00 COMMUNICATIONS 8,929                          8,971                          128,054               128,054               40,899                 87,155                               32% 39,744                     (1,155)                                    41910.00 COMMUNITY DEVELOPMENT 24,428                        25,016                        317,724               317,724               110,001               207,723                            35% 101,553                   (8,448)                                    41920.00 INFORMATION TECHNOLOGY 17,308                        17,215                        225,935               225,935               79,150                 146,785                            35% 58,226                     (20,924)                                  41940.00 FACILITIES ‐ CITY HALL 6,770                          6,379                          91,018                 91,018                 20,133                 70,885                               22% 30,497                     10,364                                   Total ‐ Function General Government 151,120                      152,084                      1,970,453            1,970,453            682,786               1,287,667                         35% 657,928                   (24,858)                                  Function: Public Safety42100.00 POLICE 368,426                      342,538                      4,736,215            4,822,965            1,642,360            3,180,605                         34% 1,545,043                (97,317)                                  42200.00 FIRE 52,430                        38,007                        760,123               760,123               191,553               568,570                            25% 189,195                   (2,358)                                    42400.00 BUILDING INSPECTION 52,398                        51,820                        679,565               679,565               236,974               442,591                            35% 216,036                   (20,937)                                  Total ‐ Function Public Safety 473,253                      432,364                      6,175,903            6,262,653            2,070,887            4,191,766                         33% 1,950,275                (120,613)                                Function: Public Works43050.00 ENGINEERING 25,826                        28,411                        350,041               350,041               118,176               231,865                            34% 113,060                   (5,117)                                    43100.00 STREET 44,066                        33,707                        503,876               503,876               180,392               323,484                            36% 165,350                   (15,042)                                  43400.00 CENTRAL GARAGE 19,132                        16,909                        247,198               247,198               83,493                 163,705                            34% 83,907                     415                                         Total ‐ Function Public Works 89,025                        79,028                        1,101,115            1,101,115            382,061               719,054                            35% 362,317                   (19,744)                                  Function: Culture and Recreation45100.00 RECREATION 22,417                        16,094                        360,011               360,011               90,895                 269,116                            25% 96,794                     5,899                                     45200.00 PARKS 73,089                        59,431                        1,081,258            1,081,258            306,853               774,405                            28% 330,230                   23,377                                   Total ‐ Function Culture and Recreation 95,506                        75,524                        1,441,269            1,441,269            397,748               1,043,521                         28% 427,023                   29,275                                   General Fund Payroll Only Expenditures Total 808,904                      739,000                      10,688,740         10,775,490         3,533,482            7,242,008                         33% 3,397,543                (135,939)                                COMPARATIVEAnnual City of Prior Lake Expenditures- Payroll and BenefitsAs of 5/31/2021 (Preliminary & Unaudited)Activity for Activity for Variance from Variance fromPrevious Month Month 2021 2021 2021 Amended Budget ‐ % BDGT5/31/20from 20204/30/2021 5/31/2021 Budget Amended Actual YTD Positive (Negative) USEDActual YTD Positive (Negative)COMPARATIVEAnnualEDA FUNDFunction:  Economic Development   46500.00 ECONOMIC DEVELOPMENT 10,561                        10,408                        135,544               135,544               52,153                 83,391                               38% 55,070                     2,917                                     EDA Fund Payroll Only Expenditures Total 10,561                        10,408                        135,544               135,544               52,153                 83,391                               38% 55,070                     2,917                                     WATER FUNDFunction: Water41520.00 Finance 5,876                          5,913                          76,881                 76,881                 27,106                 49,775                               35% 26,491                     (615)                                       49400.00 Water 59,722                        58,478                        749,281               749,281               266,365               482,916                            36% 259,934                   (6,431)                                    Water Fund Payroll Only Expenditures Total 65,598                        64,391                        826,162               826,162               293,471               532,691                            36% 286,425                   (7,046)                                    SEWER FUNDFunction: Sewer41520.00 Finance 5,875                          5,913                          76,881                 76,881                 27,103                 49,778                               35% 26,835                     (267)                                       49450.00 Sewer 60,571                        50,924                        731,502               731,502               269,997               461,505                            37% 286,765                   16,767                                   Sewer Fund Payroll Only Expenditures Total 66,447                        56,836                        808,383               808,383               297,100               511,283                            37% 313,600                   16,500                                   STORM WATER FUNDFunction: Storm Water49420.00 Water Quality 25,524                        25,650                        366,879               366,879               119,943               246,936                            33% 123,208                   3,265                                     Storm Water Fund Payroll Only Expenditures Total 25,524                        25,650                        366,879               366,879               119,943               246,936                            33% 123,208                   3,265                                     City‐Wide Total Payroll Expenditures 977,033                     896,287                     12,825,708         12,912,458         4,296,149           8,616,309                         33% 4,175,845               (120,304)                                Number of Permits Declared Value Number of Permits Declared Value Single Family Dwellings 15 $5,312,310.00 13 $4,741,337.00 Townhouses (# units)0 $0.00 0 $0.00 Multiple Units 0 $0.00 0 $0.00 New Commercial Industrial & Commercial 1 $284,390.00 1 $2,600,000.00 Residential 126 $1,308,662.78 141 $457,944.00 Industrial & Commercial 4 $97,250.00 1 $20,000.00 tMechanical 67 49 $0.00 ttMechanical (SF&TH)60 52 $0.00 TOTALS 273 $7,002,612.78 257 $7,819,281.00 Number of Permits Declared Value Number of Permits Declared Value Single Family Dwellings 66 $25,671,867.00 44 $14,596,039.00 Townhouses (# units)0 $0.00 4 $832,206.00 Multiple Units 0 $0.00 0 $0.00 New Commercial Industrial & Commercial 3 $1,514,256.00 1 $2,600,000.00 Residential 636 $6,457,603.77 700 $2,649,087.00 Industrial & Commercial 16 $936,725.46 9 $5,136,300.00 tMechanical 357 $0.00 270 $0.00 ttMechanical (SF & TH)264 $0.00 192 $0.00 TOTALS 1342 $34,580,452.23 1220 $25,813,632.00 Summary of Fees Collected MAY 2021 MAY 2020 YTD 2021 YTD 2020 General Fund $122,094.85 $124,532.06 $549,818.00 $401,604.14 Trunk Reserve Fund $32,300.00 $54,558.00 $130,200.00 $123,816.00 Water Storage Fund $0.00 $40,010.00 $6,160.00 $90,800.00 Water and Sewer Fund $14,520.00 $9,770.00 $58,160.00 $35,955.00 Metro Council SAC $42,245.00 $62,125.00 $171,465.00 $144,130.00 State Surcharge $3,280.31 $8,507.59 $16,221.95 $21,155.98 Builders Fees and Deposits $40,900.00 $32,700.00 $177,200.00 $117,700.00 TOTAL $255,340.16 $332,202.65 $1,109,224.95 $935,161.12 Mary Olson CITY OF PRIOR LAKE BUILDING PERMIT SUMMARY May 1, 2021 - May 31, 2021 New Residential MAY 2021 MAY 2020 2021 YEAR TO DATE 2020 YEAR TO DATE New Residential Additions and Alterations Additions and Alterations t Mechanical permits include but are not limited to furnaces, water heaters, softeners, and fireplaces. They are flat-rate permit fees. tt Mechanical (SF & TH) permits include required plumbing, heating, sewer and water and fireplace permits for new single family residences. They are flat-rate permit fees. Mary Olson, Development Services Assistant Building Department City of Prior Lake Treasurers Report May 2021 Fund 5/1/2021 5/31/2021 Fund Type & Name No. Balance Receipts Disbursements Balance Business-Type Funds Water Fund 601 5,838,902.74$ 116,772.72 225,760.59 5,729,914.87$ Sewer Fund 604 2,956,285.10 68,635.66 216,519.96 2,808,400.80 Water Quality Fund 602 2,150,658.50 18,882.31 153,657.98 2,015,882.83 Total Business-Type Funds 10,945,846.34$ 204,290.69$ 595,938.53$ 10,554,198.50$ Governmental-Type Funds General Fund 101 8,284,702.36$ 585,441.72 1,417,153.52 7,452,990.56$ Special Revenue Funds Cable Franchise Fund 210 98,725.99$ 381.68 0.00 99,107.67$ Capital Park Fund 225 1,645,755.78 13,631.66 182,388.22 1,476,999.22 Police Forfeiture Fund 235 163,714.30 8,527.96 2,482.50 169,759.76 EDA Special Revenue 240 400,117.39 761.16 12,636.08 388,242.47 Econ Dev Federal Revolving Loan Fund 250 132,087.88 197.12 0.00 132,285.00 Econ Dev MN Revolving Loan Fund 255 174.69 0.26 0.00 174.95 Developer Agreement Fund 260 942,532.33 5,400.00 48,139.50 899,792.83 Total Special Revenue Funds 3,383,108.36$ 28,899.84$ 245,646.30$ 3,166,361.90$ Capital Project Funds Tax Increment 402 16,785.23$ 25.02 21.58 16,788.67$ TIF #1-3 413 109,619.11 163.59 0.00 109,782.70 TIF #3-1 414 263,769.52 393.64 0.00 264,163.16 TIF #5-1 416 10,600.29 15.82 0.00 10,616.11 TIF #6-1 417 428,644.17 639.69 0.00 429,283.86 TIF #1-4 418 1,374.36 2.05 0.00 1,376.41 TIF #1-5 419 26,499.06 39.55 0.00 26,538.61 Revolving Equipment Fund 410 615,303.26 475.93 296,389.04 319,390.15 Revolving Park Equipment Fund 430 1,209,115.20 1,796.64 5,211.25 1,205,700.59 Facilities Management Fund 440 523,579.66 781.36 0.00 524,361.02 Permanent Impr Revolving Fund 450 350,729.86 2,245.58 0.00 352,975.44 Construction Fund 501 1,016,460.77 1,241.99 184,219.48 833,483.28 Trunk Reserve Fund 502 4,116,146.26 38,924.81 0.00 4,155,071.07 Street Oversize Fund 503 1,345,516.45 2,007.98 0.00 1,347,524.43 Water Storage Fund 505 635,658.38 1,237.89 0.00 636,896.27 Total Capital Project Funds 10,669,801.58$ 49,991.54$ 485,841.35$ 10,233,951.77$ Debt Service Funds 314-351 & 549-573 $ 2,773,253.90 42,556.96$ -$ 2,815,810.86$ Agency Fund 801 736,872.50$ 40,900.00$ 10,000.00$ 767,772.50$ Total Governmental Type Funds 25,847,738.70$ 747,790.06$ 2,158,641.17$ 24,436,887.59$ Internal Service Funds 7xx 538,660.43$ 3,984.25$ -$ 542,644.68$ Total All Funds 37,332,245.47$ 956,065.00$ 2,754,579.70$ 35,533,730.77$ Investment Pool & Ratio as of 5/31/2021 99.37% 35,310,879.09$ This report does not reflect financial obligations from contracts, agreements, purchases, services received, etc. TREASURER’S REPORT FUND DESCRIPTIONS General Fund - Represents the resources to support general operating budget expenditures of the City. The year- end fund balance represents dollars that have accumulated over a period of time. The City Council has designated a minimum of 45% of the current operating budget, for working capital to finance city operations. Water Fund - For the collection of water billing utility revenue. This enterprise fund balance is allocated for the operational costs of the Water departments and normally reserved for large capital municipal system expenses. Sewer Fund - For the collection of sewer billing utility revenue. This enterprise fund balance is allocated for the operational costs of the Sewer department and normally reserved for large capital municipal system expenses. Water Quality Fund - An enterprise account funded by the storm water charge that is generated on the bi-monthly water and sewer utility bills. The funds in the account are dedicated to finance water quality improvements including departmental administration, storm water maintenance operations and improvement projects related to water quality. Cable Franchise Fund - Acts as a clearing house for funds received from the cable franchise company as specified by ordinance. Capital Park Fund - Dedicated funds received from developers in accordance with the City’s Park Dedication requirement when land is platted. Funds are collected for the purpose of developing the City’s neighborhood park and trail system. These dollars are programmed throughout the course of the City’s Capital Improvement Program. Police Forfeiture Fund – Special revenue fund created to track criminal and DWI forfeiture revenues and expenditures. ED Special Revenue – Reserved and expended at the direction of the Prior Lake Economic Development Authority for specific economic development activity as allowed by MN Statute. The purpose is to provide economic incentives for new business expansion within the community. ED Fed/MN Loan Funds - Accounts for the proceeds of economic development grants received either from the federal government or the State of Minnesota to provide seed money for a revolving loan account. This provides economic incentive for new business expansion within the community. DAG Special Revenue Fund - Special revenue fund related to costs the City incurs in connection with a subdivision. Fees are paid to the City by the developer when the Development Contract and Final Plat are approved by City Council. Revenues are used to pay for legal expenses incurred with review and approval of the plat and inspection services on developer installed-utilities for newly approved subdivisions within Prior Lake. Water Revenue Bond Fund – PW Bldg - Debt service fund to pay bonds issued to construct the public works maintenance building. The capital facility charge generated on the utility bill provides the funding for the bond payments which occur semi-annually. Funds are transferred from Sewer and Water Fund. Water Revenue Bond Fund – WT Plant - Debt service fund to pay bonds issued to construct the water treatment plant. Revenue from the utility bills provides the funding for the bond payments which occur semi-annually. Funds are transferred from Sewer and Water Fund. Tax Increment Funds - Represents an accumulation of funds such as bond proceeds and project administration fees charged to companies requesting project write-downs in the form of tax increment financing for new and/or redevelopment. The TIF district property taxes are then deposited in a number of tax increment funds established to track their respective revenue. Revolving Equipment Fund - A regular replacement schedule for equipment needs of the City in excess of $5,000 has been adopted. Periodic fund transfers are appropriated to provide a funding source for the acquisition and purchase of new and replacement vehicles and equipment. Revolving Park Equipment Fund – Consists of funds reserved for the replacement of park equipment. Facilities Management Fund – Established in conjunction with the Facilities Management Plan (FMP). The FMP provides a schedule of major repairs, replacements and upgrades to all of the City facilities. Permanent Improvement Revolving Fund – Consists of funds available for annual street mill and overlay projects with any remaining funds to be used to provide upfront funding for future improvements. Construction Fund - Represent unexpended bond proceeds that are reserved to pay for improvement projects approved by the City Council on an annual basis. These dollars are necessary to complete outstanding construction contracts and related engineering and professional services. Street Oversize Fund - Consists of dedicated revenue generated by fees associated with new development and new construction building permits for the funding of pedestrian related improvements i.e., bikeways, sidewalks, trails plus right of way acquisition along collector streets and occasional collector street links. Trunk Reserve Fund - Consists of dedicated revenue generated from utility connection permits and acreage fees assessed at time of sewer and water installation for the recovering of trunk oversizing costs and central municipal system improvements i.e., wells lift stations, force mains, etc. These dollars are programmed throughout the course of the City’s capital improvement plan. Water Storage Fund - Accounts for the water tower fee that is charged and collected on building permits. This fund balance is 100% reserved for the construction of elevated and ground water storage facilities. Debt Service Funds - Represents prepayments of special assessments, property tax collections and special levies needed to pay the outstanding bonded indebtedness of the City. This fund balance is 100% reserved for the payment of bond principal and interest. Agency Fund - Accounts for the residential building permit deposit that is refunded to the building contractor upon final inspection. This provides financial assurance that the property site will be adequately cleaned up and debris free before an occupancy permit is granted. Severance Compensation Fund – Internal Service Fund established to partially fund the City’s compensated absence liability associated with the accrued vacation and sick leave for employees upon termination as recommended by the State Auditor’s Office. Insurance Fund – Internal Service Fund established to track revenues and expenditures related to insurance funds. City of Prior Lake Treasurers Report May 2021 Fund Type & Name Fund Balance Classification Constraints Business-Type Funds Water Fund Unrestricted Identified on utility bill for this purpose Sewer Fund Unrestricted Identified on utility bill for this purpose Water Quality Fund Unrestricted Identified on utility bill for this purpose Governmental-Type Funds General Fund Unassigned Cash flow, emergencies, one-time opportunities Special Revenue Funds Cable Franchise Fund Assigned for communications Statutory obligation to use for PEG access Capital Park Fund Assigned for capital improvements Contractually obligated; park dedication fees EDA Special Revenue Assigned for development Economic Development Econ Dev Federal Revolving Loan Fund Restricted for economic development Economic Development Econ Dev MN Revolving Loan Fund Restricted for economic development Economic Development Developer Agreement Fund Assigned for development Contractually obligated; Capital Project Funds Tax Increment Restricted for tax increment Contractually obligated by tax increment agreements TIF #1-3 Restricted for tax increment Contractually obligated by tax increment agreements TIF #1-4 Restricted for tax increment Contractually obligated by tax increment agreements TIF #3-1 Restricted for tax increment Contractually obligated by tax increment agreements TIF #4-1 Restricted for tax increment Contractually obligated by tax increment agreements TIF #5-1 Restricted for tax increment Contractually obligated by tax increment agreements TIF #6-1 Restricted for tax increment Contractually obligated by tax increment agreements Revolving Equipment Fund Assigned for capital improvements Identified for equipment replacement Revolving Park Equipment Fund Assigned for capital improvements Identified for park equipment replacement Facilities Management Fund Assigned for capital improvements Identified for funding Facilities Management Plan Permanent Improvement Revolving Fund Assigned for capital improvements Identified for funding street improvement projects Construction Fund Restricted for capital improvements Construction projects in progress Trunk Reserve Fund Assigned for capital improvements Contractually obligated by developer agreements Street Oversize Fund Assigned for capital improvements Contractually obligated by developer agreements Water Storage Fund Assigned for capital improvements Contractually obligated by developer agreements Debt Service Funds Restricted for Debt Service Reserved for contractually obligated debt service Agency Fund N/A Escrows to be reimbursed to depositors Internal Service Funds Unrestricted Identified as payment for severance compensation and insurance MANUFACTURERS REPRESENTITIVES ● CONTROLS ● MECHANICAL EQUIPMENT MAIN OFFICE: P.O. BOX 120359 ST. PAUL, MINNESOTA 55112 PHONE 651-631-9005 (FAX) 651-631-0027 BRANCH OFFICE: P.O. BOX 787 AMES, IOWA 50010 PHONE 515-232-4770 (FAX) 515-232-0795 BRANCH OFFICE: CHICAGO, ILLINOIS PHONE 815-927-3386 (FAX) 651-631-0027 Friday, March 19, 2021 Mr. Andy Stephes City of Prior Lake 17073 Adelmann Street SE Prior Lake, MN. 55372 Reference: WTP SCADA Computer System Upgrade Dear Andy: In accordance with your request to our Mr. Mark Juker, we are pleased to provide you with our proposal to include an upgrade of your Water Treatment Plant SCADA System Computer Hardware and Software as follows: A Two (2) SCADA Computer Workstations, DELL, Intel Core i9-9900 3.1 GHz processor, 32GB memory, one (1) 512GB Solid-State hard drive, keyboard, mouse, speakers, 21” Flat Panel Monitors, Windows 10 Professional, Microsoft Office Professional & AVG Antivirus for installation in place of the existing SCADA Computer Workstations, one (1) at the WTP and one (1) at the City Maintenance Facility. B One (1) Lot labor and materials as required to replace the existing Industrial Computer/Operator Interface Module on the WTP Control Panel with: a Dell Optiplex SCADA computer installed and wired inside the control panel running the updated HMI software. The existing 17” Hope Industrial Touch Sensitive Color Monitor flush mounted on the control panel will remain and reused in place. C One (1) Lot Human Machine Interface (HMI) Software License Upgrade including: ➢Three (3) Wonderware Intouch Runtime Software License Version Upgrades for installation on the WTP workstation, WTP panel mount computer and workstation at the City Maintenance Facility. ➢One (1) Wonderware Media kit. ➢One (1) WIN911 Alarm Dialing Softwared license upgrade, installed, configured and setup on the new SCADA Workstation within the WTP. EXHIBIT A D One (1) Lot Professional Services to include set of new SCADA workstations, install new SCADA computer hardware and software in place of the existing SCADA workstations located at the Water Treatment Plant and City Maintenance Facility including re-installation and configuration of all existing HMI and Alarming software with the most recent license upgrades, including graphic enhancements in the new Workstations and commission and test for complete and proper operation. E One (1) Lot of startup, checkout and Owner training services. Your net price for Items A through E, FOB factory with freight allowed to jobsite including one (1) year warranty and three sets of updated drawings for insertion in your existing Operation and Maintenance Manuals...…$34,335.00. For accounting proposes I have the following breakouts: Item A…………….$5,206.00 Item B…………….$2,682.00 Item C…………….$17,800.00 Item D…………….$8,051.00 Item E…………….$596.00 Please note, price does not include any sales or use tax, printers, surge protection, UPS units or additional reports. If you wish to proceed with an order simply sign on the space provided below and return a copy to this office, upon receipt we will immediately proceed with equipment release and scheduling installation. Thank you for the opportunity of providing you with this proposal. Should you have any questions or wish to get together to discuss in greater detail please don’t hesitate to give Mark or me a call. Sincerely, Mr. Bruce Wirth, Pres. Automatic Systems Company Accepted by: Date:_______________________ cc: Mr. Mark Juker, ASC 2021.03 Page 1 of 9 Standard Contract for Services SCADA System Upgrades This agreement (“Agreement”) is between the City of Prior Lake, Minnesota ("City"), whose business address is 4646 Dakota Street SE, Prior Lake, MN 55372, and Automatic Systems Co., a Minnesota ____________________________________ ("Contractor") whose business address is PO Box 120359, St. Paul, MN 55112. Based on the mutual promises and covenants set forth herein, the sufficiency of which are hereby acknowledged, the City and Contractor agree as follows: 1. Scope of Work. Contractor agrees to provide, perform and complete all the services in accordance with the terms of this Agreement and attached Exhibit A (“Work”). The terms of this Agreement shall take precedence over any provisions of the Contractor’s proposal and/or general conditions. If Contractor’s proposal is attached as Exhibit A, City rejects any contract terms and/or general conditions included in such proposal unless specifically agreed to by the City in writing. 2. Effective Date and Term of Agreement. This Agreement shall become effective as of June 21, 2021. The Work shall be completed by December 31, 2021. 3. Compensation for Services. City agrees to pay the Contractor a fixed sum of $34,335 as full and complete payment for the Work (“Contract Price”). A. Any changes in the scope of the Work which may result in an increase to the compensation due the Contractor shall require prior written approval by an authorized representative of the City or by the City Council. The City will not pay additional compensation for services or materials that do not have prior written authorization. B. If Contractor is delayed in performance due to any cause beyond its reasonable control, including but not limited to strikes, riots, fires, acts of God, governmental actions, actions of a third party, or actions or inactions of City, the time for performance shall be extended by the period of time lost by reason of the delay. Contractor will be entitled to payment for its reasonable additional charges, if any, due to the delay. 4. Method of Payment. Contractor shall prepare and submit to City, on a monthly basis, itemized invoices setting forth work performed and the payments requested under this Agreement. Contractor shall provide an itemized listing of all expenses and such other documentation as reasonably required by the City. Each invoice shall contain the City’s project number and a progress summary showing the current billing, past payments and unexpended balance of the Contract Price. Invoices submitted shall be paid in the same manner as other claims made to the City. A. Claims. In compliance with Minn. Stat. 471.38, by making a claim for payment, Contractor is declaring that the account, claim, or demand is just and correct and that no part of it has been paid. B. Waiver of Claims. The Contractor’s acceptance of final payment shall constitute a waiver of all claims by the Contractor except those previously made in writing and identified by the Contractor as unsettled at the time of application for final payment. 2021.03 Page 2 of 9 5. Compliance with Laws and Regulations. In providing the Work, the Contractor shall abide by all statutes, ordinances, rules, and regulations pertaining to the Work. Any violation of statutes, ordinances, rules and regulations pertaining to the Work shall constitute a material breach of this Agreement and entitle the City to immediately terminate this Agreement. 6. Contractor’s Employees. Contractor and its employees, representatives and agents shall comply with all City policies (no smoking, parking location, check in, sign it, etc.). Contractor and its employees, representatives and agents shall use care, coordination and communication in order to ensure City employees and guests are not disturbed or inconvenienced. Contractor’s employees, representatives and agents shall be neat appearing and at City’s request wear an identification badge approved by the City. Contractor must honor the City’s request to reassign an employee, representative or agent whom the City determines is unsuitable for the Work. When necessary, Contractor’s employees, representatives and agents will be provided with keys or access cards in order to perform their work. Any lost keys or cards that result in rekeying a space or other cost to the City will be billed back to the Contractor. The City shall have the right to perform or require to be performed criminal background checks on any employee, representative or agent of the Contractor who will perform any aspect of the Work. The Contractor shall cooperate with the City in the performance of all such criminal background checks. 7. Contractor’s Representative. Contractor has designated a project representative to coordinate with the City and manage the Work. The project representative shall be assisted by other staff members as necessary to facilitate the completion of the Work in accordance with the terms of this Agreement. Contractor may not remove or replace the project representative without the approval of the City. 8. Standard of Care. Contractor shall exercise the same degree of care, skill and diligence in the performance of the Work as is ordinarily exercised by members of the profession under similar circumstances in Scott County, Minnesota. Contractor shall be liable to the fullest extent permitted under applicable law, without limitation, for any injuries, loss, or damages proximately caused by Contractor's breach of this standard of care. Contractor shall put forth reasonable efforts to complete the Work in a timely manner. Contractor shall not be responsible for delays caused by factors beyond its control or that could not be reasonably foreseen at the time of execution of this Agreement. Contractor shall be responsible for costs, delays or damages arising from unreasonable delays in the performance of the Work. 9. City’s Obligations. City will provide access to public and private property as necessary for Contractor to perform the Work. City shall give thorough consideration to all reports, sketches, estimates, drawings, and other documents presented by the Contractor, and shall inform the Contractor of all decisions required of City within a reasonable time so as not to delay the Work. The City shall furnish the Contractor with a copy of any applicable policy, standard or criteria, including but not limited to, design and construction standards, that may be required for the Work. 10. City's Representative. City has designated a project representative with respect to the Work. He or she shall have authority to transmit instructions, receive information, and interpret the City's policy and decisions with respect to the Work. 11. Ownership of Documents. All plans, diagrams, analyses, reports and information generated in connection with the performance of this Agreement (“Information”) shall 2021.03 Page 3 of 9 become the property of the City, but Contractor may retain copies of the Information as records of the services provided. The City may use the Information for its purposes and the Contractor also may use the Information for its purposes. Use of the Information for the purposes of the Work does not relieve any liability on the part of the Contractor, but any use of the Information by the City or the Contractor beyond the scope of this Agreement is without liability to the other, and the party using the Information agrees to defend and indemnify the other from any claims or liability resulting therefrom. 12. Insurance. Prior to starting the Work, Contractor shall procure, maintain and pay for such insurance as will protect Contractor and City against claims or loss which may arise out of operations by Contractor or by any subcontractor or by anyone employed by any of them or by anyone for whose acts any of them may be liable. Contractor agrees to maintain all coverage required herein throughout the term of this Agreement and for a minimum of two years following City’s written acceptance of the Work. A. Such insurance shall include, but not be limited to, the following minimum coverages and limits of liability: i. Commercial General Liability Insurance. Commercial General Liability Insurance protecting Contractor and City from claims for damages for bodily injury, including death, and from claims for property damage, which may arise from operations under this Agreement. The Commercial General Liability Policy shall be on ISO form CG 00 01 12 07 or CG 00 01 04 13, or the equivalent. Such insurance shall cover liability arising from premises, operations, independent contractors, products- completed operations, personal and advertising injury, and liability assumed under an insured contract (including the tort liability of another assumed in a business contract). There shall be no endorsement or modification of the Commercial General Liability form arising from pollution, explosion, collapse, underground property damage or work performed by subcontractors. The City, including its elected and appointed officials, employees, and agents, must be endorsed as an Additional Insured using ISO Form CG 20 10 or equivalent for Ongoing Operations and ISO Form CG 20 37 or equivalent for Products/Completed Operations. Insurance minimum limits are as follows: • $1,000,000 – per occurrence • $2,000,000 – annual aggregate • $2,000,000 – annual aggregate – Products/Completed Operations ii. Workers’ Compensation Insurance. Workers’ Compensation Insurance for all Contractor’s employees in accordance with the statutory requirements of the State of Minnesota. The Contractor shall also provide Employer’s Liability Insurance with minimum limits as follows: • $500,000 – Bodily Injury by Disease per employee • $500,000 – Bodily Injury by Disease aggregate • $500,000 – Bodily Injury by Accident The Contractor shall maintain “stop gap” coverage if Contractor obtains Workers’ Compensation coverage from any state fund if Employer’s liability coverage is not available. 2021.03 Page 4 of 9 If Minnesota Statutes, Section 176.041 exempts the Contractor from Workers’ Compensation insurance, the Contractor must provide a written statement, signed by an authorized representative, indicating the qualifying exemption that excludes the Contractor from the Minnesota Workers’ Compensation requirements. iii. Business Automobile Liability Insurance. Business Automobile Liability Insurance protecting City and Contractor from claims for damages for bodily injury, including death, and from claims for property damage resulting from the ownership, operation, maintenance or use of all autos which may arise from operations under this Agreement. Insurance minimum limits are as follows: • $1,000,000 – per occurrence Combined Single Limit for Bodily Injury and Property Damage including Owned, Hired, and Non-owned Automobiles. iv. Professional/Technical (Errors and Omissions) Liability Insurance. Professional Liability (Errors and Omissions) Insurance that provides coverage for all claims the Contractor may become legally obligated to pay resulting from any actual or alleged negligent act, error, or omission related to the Contractor’s professional services required under this Agreement. The Contractor is required to carry the following minimum limits: • $2,000,000 – per claim • $2,000,000 – annual aggregate The retroactive or prior acts date of such coverage shall not be after the effective date of this Agreement and the Contractor shall maintain such insurance for a period of at least two years, following completion of the work. If such insurance is discontinued, extended reporting period coverage must be obtained by the Contractor to fulfill this requirement. B. All of the insurance policies required by this Agreement shall comply with the following: i. The Contractor’s policies, except Worker’s Compensation Insurance and Professional/Technical Liability Insurance, shall be primary insurance and non- contributory to any other valid and collectible insurance available to the City with respect to any claim arising out of the Contractor’s performance under this Agreement including the defense and indemnity obligations assumed by Contractor under this Agreement. ii. An Umbrella or Excess Liability insurance policy may be used to supplement the Contractor’s policy limits to satisfy the full policy limits required by this Agreement. iii. All insurance shall be provided on an occurrence basis and not on a claims-made basis, except professional liability insurance or other coverage not reasonably available on an occurrence basis; provided that all such claims-made coverage is subject to the approval of the City Attorney. iv. Any insurance limits in excess of the minimum limits shall be available to the City. v. All policies, except professional liability, shall be endorsed with a waiver of subrogation in favor of the City, including its elected and appointed officials, employees, and agents for losses arising from activities under this Agreement. 2021.03 Page 5 of 9 vi. It shall be Contractor’s responsibility to pay any retention or deductible for the coverages required. The City may require the Contractor to provide proof of ability to pay losses and related expenses within the deductible and retention. vii. The Contractor is required to submit a Certificate of Insurance acceptable to the City as evidence of the required insurance coverage requirements. viii. The Contractor’s policies and Certificate of Insurance shall contain a provision that coverage afforded under the policies shall not be cancelled without at least thirty days’ advanced written notice to the City, or ten days’ written notice for non- payment of premium. ix. The Contractor is responsible to review and ensure all subcontractors comply with the insurance provisions contained herein and said insurance is maintained as specified. x. If the City authorizes the Contractor to be self-insured, a Certificate of Self- Insurance must be attached. xi. The Contractor shall obtain insurance policies from insurance companies having an “AM BEST” rating of A- (minus); Financial Size Category (FSC) VII or better and authorized to do business in the State of Minnesota, or as approved by the City. xii. The City reserves the right to immediately terminate this Agreement if the Contractor is not in compliance with the insurance requirements and retains all rights to pursue any remedies against the Contractor. xiii. All insurance policies must be open to inspection by the City, and copies of policies must be submitted to the City’s authorized representative upon written request. xiv. The City’s failure to approve or disapprove the Contractor’s policies or certificates shall not relieve the Contractor of full responsibility to maintain the required insurance. xv. If the coverage period shown on the Contractor's current certificate of insurance ends during the duration of the project, the Contractor must, prior to the end of the coverage period, obtain a new certificate of insurance showing that coverage has been extended. xvi. No representation is made that the minimum insurance requirements are sufficient to cover the obligations of the Contractor under this Agreement. C. Effect of Contractor’s Failure to Provide Insurance. If Contractor fails to provide the specified insurance, then Contractor will defend, indemnify and hold harmless the City, the City's officials, agents and employees from any loss, claim, liability and expense (including reasonable attorney's fees and expenses of litigation) to the extent necessary to afford the same protection as would have been provided by the specified insurance. Except to the extent prohibited by law, this indemnity applies regardless of any strict liability or negligence attributable to the City (including sole negligence) and regardless of the extent to which the underlying occurrence (i.e., the event giving rise to a claim which would have been covered by the specified insurance) is attributable to the negligent or otherwise wrongful act or omission (including breach of contract) of Contractor, its subcontractors, agents, employees or delegates. Contractor agrees that this indemnity shall be construed and applied in favor of indemnification. Contractor also agrees that if applicable law limits or precludes any aspect of this indemnity, then the indemnity will be considered limited only to the extent necessary to comply with that applicable law. The stated indemnity continues until all applicable statutes of limitation have run. If a claim arises within the scope of the stated indemnity, the City may require Contractor to take one of the following actions within fifteen days of receiving notice from the City.: 2021.03 Page 6 of 9 i. Furnish and pay for a surety bond, satisfactory to the City, guaranteeing performance of the indemnity obligation; or ii. Furnish a written acceptance of tender of defense and indemnity from Contractor's insurance company. 13. Indemnification. Contractor will defend and indemnify City, its officers, agents, and employees and hold them harmless from and against all judgments, claims, damages, costs and expenses, including a reasonable amount as and for its attorney’s fees paid, incurred or for which it may be liable resulting from any breach of this Agreement by Contractor, its agents, representatives, contractors and employees, or any negligent or intentional act or omission performed, taken or not performed or taken by Contractor, its agents, representatives, contractors and employees, relative to this Agreement. City will indemnify and hold Contractor harmless from and against any loss for injuries or damages arising out of the negligent acts of the City, its officers, agents or employees. 14. Termination. This Agreement may be terminated by either party by thirty days' written notice delivered to the other party at the addresses written above. Upon termination under this provision if there is no fault of the Contractor, the Contractor shall be paid for Work performed until the effective date of termination. 15. Mediation. Each dispute, claim or controversy arising from or related to this Agreement shall be subject to mediation as a condition precedent to initiating arbitration or legal or equitable actions by either party. Upon service of a written notice requesting mediation, the parties shall have ten (10) days to jointly select one person to act as mediator. If the parties are unable to agree upon a mediator, the parties shall ask the Scott County District Court to select a mediator. The mediation shall be conducted pursuant to the commercial mediation procedures of the American Arbitration Association but shall not be administered by the American Arbitration Association. No arbitration or legal or equitable action may be instituted for a period of 90 days from the filing of the request for mediation unless a longer period of time is provided by agreement of the parties. Each party shall bear its own costs of the mediation process. The parties shall share equally the fees and expenses of the mediator. Mediation shall be held in the City of Prior Lake unless another location is mutually agreed upon by the parties. The parties acknowledge that mediation is a voluntary process, and that the mediator does not have the authority to bind either party absent the party’s consent. The parties shall memorialize any agreement resulting from the mediation in a mediated settlement agreement, which agreement shall be enforceable as a settlement in any court having jurisdiction thereof. 16. Notice. Any notice required or permitted under this Agreement shall be delivered in one or more of the following manners: (i) delivered personally; (ii) mailed by United States mail; or (iii) deposited cost paid with a nationally recognized, reputable overnight courier. Notice shall be delivered or directed to an officer or agent of the Contractor or to the City Manager as applicable at the address set forth on page 1 of this Agreement. Notice shall be deemed effective on the date of receipt. Any party may change its address for the service of notice by giving written notice of such change to the other party in any manner above specified, 10 days prior to the effective date of such change. 17. Independent Contractor. At all times and for all purposes, Contractor is an independent contractor engaged by City to perform the services described in this Agreement and Contractor shall have no authority to employ persons or make purchases on behalf of City, 2021.03 Page 7 of 9 or otherwise bind or obligate City. No statement in this Agreement shall be construed to find the Contractor an employee of the City. 18. Employees. Contractor agrees not to hire any employee or former employee of City and City agrees not to hire any employee or former employee of Contractor prior to termination of this Agreement and for one year thereafter, without prior written consent of the former employer in each case. 19. Assignment or Subcontract. Contractor shall not subcontract any part of the Work; nor may Contractor assign this Agreement, or any interest arising herein, without the prior written consent of the City. 20. Audit Disclosure. Pursuant to Minn. Stat. 16C.05, Subd. 5, the books, records, documents and accounting procedures and practices of the Contractor or other parties relevant to this Agreement are subject to examination by the City and either the Legislative Auditor or the State Auditor for a period of six years after the effective date of this Agreement. 21. Data Practices. Any reports, information, data, etc. given to, or prepared or assembled by the Contractor under this Agreement which the City requests to be kept confidential, shall not be made available to any individual or organization without the City's prior written approval. This Agreement is subject to the Minnesota Government Data Practice Act, Minnesota Statutes Chapter 13 (“Data Practices Act”). All government data, as defined in the Data Practices Act, which is created, collected, received, stored, used, maintained, or disseminated by Contractor in performing any of the functions of the City during performance of this Agreement is subject to the requirements of the Data Practice Act and Contractor shall comply with those requirements as if it were a government entity. All subcontracts entered into by Contractor in relation to this Agreement shall contain similar Data Practices Act compliance language. 22. Non-Discrimination. During the performance of this Agreement, the Contractor shall not discriminate against any employee or applicant for employment because of race, color, creed, religion, national origin, sex, marital status, status with regard to public assistance, disability, sexual orientation or age. The Contractor shall post in places available to employees and applicants for employment, notices setting forth the provision of this non- discrimination clause and stating that all qualified applicants will receive consideration for employment. The Contractor shall incorporate the foregoing requirements of this paragraph in all of its subcontracts for the Work, and will require all of its subcontractors for the Work to incorporate such requirements in all subcontracts for the Work. The Contractor further agrees to comply with all aspects of the Minnesota Human Rights Act, Minnesota Statutes 363.01, et. seq., Title VI of the Civil Rights Act of 1964, and the Americans with Disabilities Act of 1990. 23. Conflicts. No salaried officer or employee of the City and no member of the Council, or Commission, or Board of the City shall have a financial interest, direct or indirect, in this Agreement. The violation of this provision renders this Agreement void. 24. Rights and Remedies. The duties and obligations imposed by this Agreement and the rights and remedies available thereunder shall be in addition to and not a limitation of any duties, obligations, rights and remedies otherwise imposed or available by law. 2021.03 Page 8 of 9 25. Damages. In the event of a breach of this Agreement by the City, Contractor shall not be entitled to recover punitive, special or consequential damages or damages for loss of business. 26. Enforcement. The Contractor shall reimburse the City for all costs and expenses, including without limitation, attorneys' fees paid or incurred by the City in connection with the enforcement by the City during the term of this Agreement or thereafter of any of the rights or remedies of the City under this Agreement. 27. Governing Law. This Agreement shall be controlled by the laws of the State of Minnesota. Venue and jurisdiction for any action, suit or proceeding arising out of this Agreement shall be only in the courts of Scott County, Minnesota or the federal courts for the United States for the District of Minnesota. 28. Entire Agreement. The entire agreement of the parties is contained herein. This Agreement supersedes all oral agreements and negotiations between the parties relating to the subject matter hereof as well as any previous agreements presently in effect between the parties relating to the subject matter hereof. Any alterations, amendments, deletions, or waivers of the provisions of this Agreement shall be valid only when expressed in writing and duly signed by the parties, unless otherwise provided herein. 29. Severability. The provisions of this Agreement are severable. If any portion hereof is, for any reason, held by a court of competent jurisdiction to be contrary to law, such decision shall not affect the remaining provisions of this Contract. 30. Waiver. No action nor failure to act by the City or the Contractor shall constitute a waiver of any right or duty afforded any of them under this Agreement, nor shall any such action or failure to act constitute an approval of or acquiescence in any breach thereunder, except as may be specifically agreed in writing. 31. Counterparts. This Agreement may be executed in multiple counterparts, each of which shall be considered an original. 2021.03 Page 9 of 9 In witness whereof, the parties have caused this Agreement to be executed by their duly authorized agents. CITY OF PRIOR LAKE ______________________ __________________________________ Date Mayor ___________________________________ City Manager AUTOMATIC SYSTEMS, CO. ______________________ By: ________________________________ Date Its: ________________________________ MANUFACTURERS REPRESENTITIVES ● CONTROLS ● MECHANICAL EQUIPMENT MAIN OFFICE: P.O. BOX 120359 ST. PAUL, MINNESOTA 55112 PHONE 651-631-9005 (FAX) 651-631-0027 BRANCH OFFICE: P.O. BOX 787 AMES, IOWA 50010 PHONE 515-232-4770 (FAX) 515-232-0795 BRANCH OFFICE: CHICAGO, ILLINOIS PHONE 815-927-3386 (FAX) 651-631-0027 Friday, March 19, 2021 Mr. Andy Stephes City of Prior Lake 17073 Adelmann Street SE Prior Lake, MN. 55372 Reference: WTP SCADA Computer System Upgrade Dear Andy: In accordance with your request to our Mr. Mark Juker, we are pleased to provide you with our proposal to include an upgrade of your Water Treatment Plant SCADA System Computer Hardware and Software as follows: A Two (2) SCADA Computer Workstations, DELL, Intel Core i9-9900 3.1 GHz processor, 32GB memory, one (1) 512GB Solid-State hard drive, keyboard, mouse, speakers, 21” Flat Panel Monitors, Windows 10 Professional, Microsoft Office Professional & AVG Antivirus for installation in place of the existing SCADA Computer Workstations, one (1) at the WTP and one (1) at the City Maintenance Facility. B One (1) Lot labor and materials as required to replace the existing Industrial Computer/Operator Interface Module on the WTP Control Panel with: a Dell Optiplex SCADA computer installed and wired inside the control panel running the updated HMI software. The existing 17” Hope Industrial Touch Sensitive Color Monitor flush mounted on the control panel will remain and reused in place. C One (1) Lot Human Machine Interface (HMI) Software License Upgrade including: ➢Three (3) Wonderware Intouch Runtime Software License Version Upgrades for installation on the WTP workstation, WTP panel mount computer and workstation at the City Maintenance Facility. ➢One (1) Wonderware Media kit. ➢One (1) WIN911 Alarm Dialing Softwared license upgrade, installed, configured and setup on the new SCADA Workstation within the WTP. EXHIBIT A D One (1) Lot Professional Services to include set of new SCADA workstations, install new SCADA computer hardware and software in place of the existing SCADA workstations located at the Water Treatment Plant and City Maintenance Facility including re-installation and configuration of all existing HMI and Alarming software with the most recent license upgrades, including graphic enhancements in the new Workstations and commission and test for complete and proper operation. E One (1) Lot of startup, checkout and Owner training services. Your net price for Items A through E, FOB factory with freight allowed to jobsite including one (1) year warranty and three sets of updated drawings for insertion in your existing Operation and Maintenance Manuals...…$34,335.00. For accounting proposes I have the following breakouts: Item A…………….$5,206.00 Item B…………….$2,682.00 Item C…………….$17,800.00 Item D…………….$8,051.00 Item E…………….$596.00 Please note, price does not include any sales or use tax, printers, surge protection, UPS units or additional reports. If you wish to proceed with an order simply sign on the space provided below and return a copy to this office, upon receipt we will immediately proceed with equipment release and scheduling installation. Thank you for the opportunity of providing you with this proposal. Should you have any questions or wish to get together to discuss in greater detail please don’t hesitate to give Mark or me a call. Sincerely, Mr. Bruce Wirth, Pres. Automatic Systems Company Accepted by: Date:_______________________ cc: Mr. Mark Juker, ASC Title Sheet Page i TEN YEAR STORMWATER POND MANAGEMENT PLAN TEN YEAR STORMWATER POND MANAGEMENT PLAN FOR: THE CITY OF PRIOR LAKE March 10, 2021 PREPARED BY: Table of Contents Page ii TEN YEAR STORMWATER POND MANAGEMENT PLAN TITLE SHEET TABLE OF CONTENTS 1. Overview & Purpose .............................................................................................................................. 3 Stormwater Asset Management Program (SWAMP) .................................................................... 3 Annual SWAMP Updates .............................................................................................................. 4 Annual Stormwater Pond Surveys ................................................................................................ 4 2. Pond Management Plan ........................................................................................................................ 5 Inspect and Maintain Priority Ponds ............................................................................................. 5 Survey Priority Ponds .................................................................................................................... 5 Maintenance Priority Ponds .......................................................................................................... 8 Pond Feasibility Memos .............................................................................................................. 11 3. BMP Retrofits ....................................................................................................................................... 12 Outlet Control Structures (OCS) ................................................................................................. 12 Pretreatment................................................................................................................................ 12 Filtration/Biofiltration .................................................................................................................... 12 4. Estimated Costs ................................................................................................................................... 13 Survey Priority Ponds Cost ......................................................................................................... 13 Maintenance Priority Ponds Cost ................................................................................................ 13 Ten-Year Cost ............................................................................................................................. 14 5. Next Steps ........................................................................................................................................... 15 LIST OF FIGURES Survey Priority Ponds Maintenance Priority Ponds APPENDICES Appendix A – Pond Feasibility Memorandum Example Pond Management Plan Page 3 TEN YEAR STORMWATER POND MANAGEMENT PLAN 1. OVERVIEW & PURPOSE The City of Prior Lake (the City) has approximately 300 stormwater ponds, including constructed wet and dry ponds and wetlands. These assets provide the City with essential rate control for flood mitigation and water quality treatment. Stormwater basins are designed to remove pollutants from runoff, including sediment. Over time, the sediment builds up in a basin, making it shallower and less effective at continuing to remove pollutants and manage stormwater. To most effectively manage stormwater and to maintain the vitality of downstream waterbodies, stor mwater basins need to be inspected and maintained. Inspection and maintenance of this infrastructure supports population growth, ensures compliance with the City’s National Pollution Discharge Elimination System (NPDES) Municipal Separate Storm Sewer System (MS4) Permit, and ensures water quality goals are met. Prioritization of inspection and maintenance activities is crucial to a successful and cost-effective stormwater management program. Stormwater basins typically have a 20- to 50-year lifespan. The variability can be attributed to factors including, but not limited to, drainage area characteristics, impervious percentage, proximity to agriculture and the amount of erosion occurring both naturally and during construction projects . Older basins, having been designed with smaller rainfall depths, may not be sized appropriately to meet today’s stormwater treatment standards. Aging basins that have elevated chloride concentrations from road salts or over - abundant aquatic vegetation can become a source of nutrient loading to a watershed system. This is the opposite intended effect of stormwater treatment best management practices (BMPs), and if not managed properly, these issues can offset water quality projects implemented by the City. The timing of stormwater inspections and maintenance is extremely important to ensure the health of water bodies and adequate treatment of stormwater runoff. Prioritizing the cleanout schedule for stormwater basins ensures the dollars spent by the City on stormwater maintenance are optimally allocated to basins that require cleanout to return to original treatment levels. If a filled basin is left unmaintained, its effectiveness at removing pollutants will continue to decrease and it may reach the end of its life cycle prematurely. The purpose of this Ten-Year Stormwater Pond Management Plan is to provide guidance concerning the planning and execution of pond maintenance activities within the City. This includes: 1. Routine field verification and calibration of the City’s Storm Water Asset Management Program (SWAMP), 2. Prioritizing ponds for inspection/survey, 3. Prioritizing ponds for maintenance, 4. Conducting inspections and maintenance, 5. BMP retrofitting options, and 6. Cost estimates for these activities. Stormwater Asset Management Program (SWAMP) The City utilizes SWAMP to inventory, document, and prioritize inspection and maintenance activities, and generate lifecycle estimates for constructed ponds. SWAMP provides a standard rating system to help prioritize maintenance activities. The SWAMP score is calculated using user provided inputs including construction year, basin area, drainage area, impervious percentage, estimated loading rate, and receiving water body. The score is derived from comparing these variables against Nationwide Urban Runoff Program (NURP) pond design standards. Pond Management Plan Page 4 TEN YEAR STORMWATER POND MANAGEMENT PLAN Newly constructed ponds (or a basin meeting the City’s treatment goals) will have a SWAMP score of 100, while a basin that is at the end of its life expectancy will have a SWAMP score approaching 50 or less. A score between 50-70 is an indication that maintenance should be evaluated. SWAMP also provides estimates for water quality performance for total suspended solids and total phosphorus removal efficiency. Annual SWAMP Updates To ensure the scores produced by SWAMP are accurate, annual updates should be incorporated into the program to reflect changes to stormwater basin, drainage areas, and structural BMP data sets in areas that have been recently changed. SWAMP can also be calibrated using historical record plans to calculate an average pond depth. This information is used similarly to survey data, except that the “survey date” in SWAMP would be the estimated construction date from the grading plan. This is a cost-effective way for the City to improve their SWAMP accuracy by reducing the number of pond surveys needed. If this method is employed, the user should upload the grading plan and depth calculation methods into SWAMP for record keeping purposes. One limitation is that basins are not always constructed exactly as planned (either over excavated or not constructed correctly), and the construction erosion control techniques today are much more effective than they were in the past. If a basin is generating a SWAMP score that does not reflect observed conditions, the user should consider three things before overriding a basin’s inputs: 1. Verify that all input data sets are accurate. 2. Complete a survey of the basin to confirm accurate current average depth. 3. Document supporting evidence for the use of alternative loading rates or managed depths. One scenario for using an alternative loading rate is if it is known that a specific drainag e area routinely receives more or less de-icing volume than other areas. The alternative loading rate can be updated based on estimated deicing records and procedures. It is most common to override the basin’s managed depth to reflect a smaller managed vo lume as originally intended or approved by the City. This will help calibrate a basin and reprioritize accordingly. Annual Stormwater Pond Surveys The process for selecting basins for surveying should follow the general guidance listed below: 1. Update the basin and drainage area files for all new and redeveloped areas within the City. 2. Update SWAMP with all historical grading plans available. - Ponds with average depths and estimated construction dates from grading plans should be considered last priority for surveying. 3. Select basins on public property with the lowest SWAMP scores to survey first. - SWAMP should be updated with the survey date and average depth. Attach the bathymetric map to its corresponding basin in SWAMP. This will prevent ponds from being surveyed too frequently and will provide evidence for any program overrides. 4. The City may need to coordinate with private landowners to ensure the maintenance expectations are met for private basins. Pond Management Plan Page 5 TEN YEAR STORMWATER POND MANAGEMENT PLAN 2. POND MANAGEMENT PLAN The following section describes the approach and schedule the City would follow to maintain the City’s SWAMP data and plan for maintenance activities over a ten-year period. Inspect and Maintain Priority Ponds Using historical pond survey data that has been completed and evaluated in SWAMP, the City can identify inspection and maintenance needs based on the following criteria: If a basin has SWAMP score less than 70 or observed quality issues: • A survey of the pond’s current conditions should be completed. This data will be used in the pond feasibility memorandum below. • If the survey confirms the basin is scoring less than 70, a pond feasibility memorandum should be completed (if survey results in a SWAMP score higher than 70 then no further action will likely be needed). This memorandum should outline maintenance and/or improvement options based on the identified deficiencies and treatment goals for the basin. Material quantities would be estimated at this time for construction and budget planning. - Once the feasibility memorandum is completed, the City can budget and schedule the maintenance and construction activities. - This should include collection of sediment samples in accordance with MPCA Guidance “Managing Stormwater Sediment Best Management Practices” to identify material disposal requirements. Contaminated material can have a significant impact on the project budget, so sampling should be completed as soon as the basin is identified for dredge maintenance. If a basin has a SWAMP score greater than 70: • The City will likely take no immediate action and continue to monitor the basin per the MS4 permit requirements. If a basin has a SWAMP score around 70: • The basin may need to be resurveyed in the next 0-5 years to reevaluate maintenance needs. Survey priority ponds and maintenance priority ponds were identified and are shown in detail in Sections 2.2 and 2.3 below, based on the 2021 SWAMP score. Survey Priority Ponds There are 7 stormwater basin that have no survey data associated with the location and scored less than 70 in the Prior Lake SWAMP program. A low SWAMP score (< 70) indicates that the basin needs to be surveyed to appropriately evaluate maintenance needs. Table 1 indicates the current SWAMP score of the pond, the average estimated water depth of the pond, whether the pond has been surveyed, and the average depth to which the pond should be cleaned for optimal function (Managed NURP Depth). A SWAMP score of 0 indicates that the basin has likely filled with sediment and needs to be surveyed to determine appropriate maintenance activities. Pond Management Plan Page 6 TEN YEAR STORMWATER POND MANAGEMENT PLAN Table 1. Survey Priority Ponds Basin ID Current SWAMP Score Survey Data (Y/N) Est. Current Depth (ft) Managed NURP Depth (ft) SWP-6654N-04 0 N 0.0 3.6 255 39 N 3.2 8.2 333 50 N 4.5 9.0 SWW-6852S-01 61 N 2.1 3.4 190 66 N 3.4 5.2 SWW-6654N-09 70 N 2.1 2.9 299 70 N 0.9 1.2 Pond Management Plan Page 7 TEN YEAR STORMWATER POND MANAGEMENT PLAN Figure 1 indicates the location of the ponds in Table 1 that have been identified as survey priority ponds. Pond Management Plan Page 8 TEN YEAR STORMWATER POND MANAGEMENT PLAN Maintenance Priority Ponds There are 14 surveyed stormwater basins that generally scored less than 50 in the SWAMP program. A pond that has been surveyed verified and returns a very low SWAMP score (generally < 50) indicates a need for maintenance in order to achieve proper stormwater management and meet the original intent of the basin. Table 2 shows the current SWAMP score of the pond, whether the pond has been surveyed, the date of the survey, the estimated current water depth of the pond, and the depth to which the pond should be to function properly (Managed NURP Depth). Pond Management Plan Page 9 TEN YEAR STORMWATER POND MANAGEMENT PLAN Table 2. Maintenance Priority Ponds Basin ID Current SWAMP Score Survey Data (Y/N) Date of Survey Est. Current Depth (ft) Managed NURP Depth (ft) 207 0 Y 06-01-2014 0.0 4.9 204 9 Y 06-01-2014 0.4 4.5 96 10 Y 06-01-2014 0.5 5.6 178 11 Y 06-01-2014 0.7 6.8 233 11 Y 06-01-2014 0.7 6.4 177 13 Y 06-01-2014 0.8 5.9 168 14 Y 06-01-2014 1.0 7.3 135 18 Y 06-01-2014 1.0 5.3 155 20 Y 06-01-2014 1.1 5.7 169 24 Y 06-01-2014 1.7 6.9 154 31 Y 06-01-2014 1.4 4.6 259 37 Y 06-01-2014 3.3 8.9 172 46 Y 06-01-2014 2.2 4.7 145 49 Y 06-01-2014 1.4 3.0 Pond Management Plan Page 10 TEN YEAR STORMWATER POND MANAGEMENT PLAN Figure 2 indicates the location of the ponds that have been identified in Table 2 as maintenance priority ponds. Pond Management Plan Page 11 TEN YEAR STORMWATER POND MANAGEMENT PLAN Pond Feasibility Memos Pond feasibility memorandums are highly recommended before pursuing cleanout operations for ponds identified for maintenance. These memorandums identify permitting requirements, access issues or needs related to cleanout project, cost benefit analyses, and potential inlet and outlet improvements. Also included is a review of historical data, a field inspection of the basin and bathymetric survey, and updating the SWAMP application to reflect the survey. See Appendix A for a Pond Feasibility Memorandum completed for the City of Prior Lake. Pond feasibility memorandums identify a tailored cleanout plan for each pond to restore optimal treatment efficiency, rather than maximum efficiency. Significant cost reductions occur when a pond is identified for a partial cleanout (i.e. inlet dredging) rather than a full pond cleanout. A partial cleanout has been found to be effective in achieving stormwater treatment goals while simultaneously reducing excavation costs. For example, a pond may be cleaned so that it returns to 80% functionality for half the cost it would take to return to 85% functionality, saving the City a significant amount of money. If a pond’s overall functionality is adjusted during maintenance operations, SWAMP is also updated so that the program calculations are adjusted according to these changes. SWAMP recalculates the stormwater treatment capacity of the basin so that the program returns an accurate SWAMP score. BMP Retrofits Page 12 TEN YEAR STORMWATER POND MANAGEMENT PLAN 3. BMP RETROFITS When ponds and other BMPs are no longer meeting their designed objectives, retrofits may be considered as opposed to complete replacement of the BMP. Many retrofits are needed or designed based on changing regulatory conditions. BMPs constructed before 2013 were typically designed based on the TP-40 rainfall standards. In 2013, NOAA released the Atlas-14 rainfall data for the state of Minnesota. The Atlas-14 data predicted over a 1.0-inch increase in precipitation depth for the modeled 100-year event in many areas, therefore BMPs constructed before 2013 may be undersized for flood prevention based on current rainfall modeling. The City recently completed an Atlas 14 Report for several ponds to identify at-risk infrastructure. Retrofitting of a BMP may also be desired if the BMP cannot achieve adequate water treatment performance based on updated water quality thresholds, which in some cases have become more stringent overtime. This section presents a summary of common BMP retrofits options that may be considered. Outlet Control Structures (OCS) Outlet control structures are engineered devices that help to control water level and outflow rate of water discharging from the BMP. Modifications to these structures can many times improve treatment provided by the BMP. These structures typically have openings of varying sizes that can be easily modified. Outlet control structures can also contain designs for preventing floating and settling debris from continuing downstream. Pretreatment Pretreatment structures are BMPs designed to catch and settle stormwater particulates and pollutants prior to discharge into a subsequent BMP. These systems are often small and require frequent maintenance. They are intended to extend the functional life of the downstream BMP and provide easier maintenance. Examples of pretreatment include, but are not limited to, pond forebays, sumps, a SAFL Baffle, and hydrodynamic separators. Filtration/Biofiltration In areas where soils, ground water, contamination, or bedrock prohibit infiltration, filtration or biofiltration BMPs should be considered. Filtration BMPs function primarily as a rate control and water treatment structure and are not intended for volume reduction. Stormwater is temporarily retained within the BMP, then filtered through a minimum of 18-inches of filter media. It is then collected in perforated drain tile beneath the media and discharged back into the storm sewer system. Many permitting agencies consider this as treating less than 100 percent of the pollutants contained within the filtered volume. Filtration benches or areas can be added to ponds if conditions are appropriate to retrofit a pond. Estimated Costs Page 13 TEN YEAR STORMWATER POND MANAGEMENT PLAN 4. ESTIMATED COSTS Pond survey costs were estimated for the survey priority ponds and excavation costs were estimated for the maintenance priority ponds owned by the City. Ponds that are not owned by the City should be surveyed and evaluated for maintenance by the private/state/county pond owner. Survey Priority Ponds Cost Pond surveys cost approximately $500 to $1,000 per basin (depending on size). This includes a review of historical data, a field inspection of the basin and bathymetric survey , and updating the SWAMP application to reflect the survey. To survey the 7 city-owned ponds identified in Table 1, the total cost is approximately $7,000. Depending on the results of the survey, the pond may also be identified for maintenance. It is highly recommended that the City survey the pond soon so that the City can budget forecast accurately. Maintenance Priority Ponds Cost The annual stormwater maintenance cost estimate was developed using the calibrated SWAMP results. SWAMP approximates the amount of sediment that needs to be removed from each basin to achieve the City’s managed volume needs (the approximate excavation volume). The basins outlined are the basins in the City that are most likely to need maintenance in the next ten years. In addition to excavation, pond cleanout activities include, but are not limited to, engineering and design, sediment sampling, basin dewatering, construction mobilization, dredging, erosion control, and site restoration. Pond feasibility memorandums are recommended for each of the basins to create a tailored maintenance plan that optimizes the money spent on basin cleanout operations. It is likely that the City will encounter contaminated soils at most (50% or more) of these basins based on the number of past projects in the City that addressed soil contamination. Contamination is identified through soil sampling prior to maintenance activities. Sediment sample results are typically valid for two years based on acceptance from landfills. Because of this short time window, contamination sampling should be completed as close to the actual maintenance period as possible. Estimated Costs Page 14 TEN YEAR STORMWATER POND MANAGEMENT PLAN Table 3 shows the City owned maintenance priority ponds identified in Table 2 and their approximate excavation volume and estimated excavation cost. Soil disposal is estimated at approximately $30 per cubic yard (CY) for non-contaminated areas based on previous pond cleanout projects. Table 3. Maintenance Priority Pond Cleanout Costs Basin ID Current SWAMP Score Est. Excavation Volume (CY) Est. Cost ($) 207 0 848 $ 25,440 204 9 634 $ 19,020 96 10 2,260 $ 67,800 178 11 2,364 $ 70,920 233 11 5,087 $ 152,610 177 13 3,008 $ 90,240 168 14 3,221 $ 96,630 135 18 1,150 $ 34,500 155 20 1,157 $ 34,710 169 24 11,561 $ 346,830 154 31 489 $ 14,670 259 37 3,274 $ 98,220 172 46 876 $ 26,280 145 49 304 $ 9,120 Total* 36,233 $ 1,086,990 *Does not include costs for contaminated material, restoration, erosion control, and other work. The presence of contaminated soil will increase the cost of disposal to approximately $50 per cubic yard. When contamination is encountered, this will most likely cause a shift in the pond maintenance schedule, as these basins cost more to maintain. Fewer ponds may be maintained in that year, but typically, over a five- to ten-year period, the City’s maintenance schedule will still accommodate all cleanout operations. Table 3 costs were increased to account for restoration, erosion control, all appurtenant work, and indirect/contingency costs using a factor of 1.75. This factor is based on an average multiplier of 1.4, which was calculated from historical project trends and includes 25% for indirect/contingency costs. The estimated cost to maintain the city-owned ponds identified is $1.90 million. If any of the 7 ponds identified for survey are selected for maintenance, the list requiring maintenance will expand. Ten-Year Cost The total cost to survey the 7 City owned survey priority ponds is $7,000. Maintaining the 14 City owned ponds identified for cleanout would cost approximately $1.90 million. Depending on the conditions of the ponds surveyed, additional funds may be needed to maintain the ponds that are added to the maintenance list. The total cost of survey and maintenance activities for the City owned ponds is approximately $1,910,000. The total pond improvement cost was divided by ten years to create an annualized pond improvements cost, which equates to approximately $191,000 per year. Next Steps Page 15 TEN YEAR STORMWATER POND MANAGEMENT PLAN 5. NEXT STEPS WSB recommends the City complete the following steps: 1. Complete pond cleanout projects for the 14 city-owned maintenance priority ponds identified in this report. 2. Survey the remaining 7 city-owned pond identified for survey in this report (and any additional private ponds the City wants to survey). 3. Adjust City pond maintenance budget, as needed, for the annualized pond improvements cost. 4. Determine ponds to survey and maintain in 2021 and 2022. 5. Conduct sediment sampling during the spring or summer of 2021 and 2022 for the initial ponds planned for maintenance. 6. Based on contamination results from sediment sampling, refine budget accordingly. Appendices TEN YEAR STORMWATER POND MANAGEMENT PLAN Appendix A – Example Pond Feasibility Memorandum Mr. Pete Young November 10, 2020 Page 4 K:\016481-000\Admin\Docs\016481-000_Pond Maintenance Memo.docx Pond SWP-6751S-06 Pond SWP-6751S-06 was inspected in August 2020. The pond is owned by the City of Prior Lake and is located near Summer Street and adjacent to Cardinal Ridge Park. The pond is shown in the NWI. The pond was constructed between 2006 and 2008, confirmed by available aerial photos prior to and following construction (Appendix A: Figure 2a and Figure 2b). Refer to Appendix B for the bathymetric survey results, drainage area map, and photos (Figure 2a, Figure 2b, Figure 2c, and Figure 2d). Table 3: Pond SWP-6751S-06 Summary Direct Drainage Area 73.5 acres Impervious Surface 37.3 acres Impervious Surface 50.7% Pond Area 0.15 acres Current Average Depth 0.6 feet Current Wet Volume 0.09 acre-feet Outlet Diameter 36-inch RCP (E) Inlet Diameter 2 - 30-inch RCPs (W) SWAMP Score 10 Inspection Observations A large sediment delta was observed at the pond inlet. The pond inlet grates are beginning to rust and bend. The pond outlet flared end section appears in good condition, but evidence of dumped grass clippings can be seen around the outlet. Water Quality Analysis SWAMP was used to estimate the TP and TSS annual reductions for Pond SWP-6751S-06 under various maintenance options, as shown in Table 4. Recommendations Because the pond is undersized for the drainage area, excavate the pond to an average depth of 5.7 feet or as deep as possible given the small footprint (Table 4 Option 7). As part of the pond maintenance, remove the sediment delta at the inlet to the pond and repair the inlet grates. If possible, consider expanding the pond footprint. If the City chooses to do maintenance, sediment samples will be required consistent with MPCA guideli nes. Following maintenance, update the managed depth and basin area in SWAMP. Mr. Pete Young November 10, 2020 Page 5 K:\016481-000\Admin\Docs\016481-000_Pond Maintenance Memo.docx Table 4: Pond SWP-6751S-06 Maintenance Options *Cost estimates do not include indirect costs, contingencies, access/restoration costs, or disposal of contaminated materials. Option Description Volume to Excavate (cy) Estimated Cost to Excavate* ($) TP Removal Efficiency (%) Annual TP Reduction (lbs/yr) TP Cost Benefit ($/lb) TSS Removal Efficiency (%) Annual TSS Reduction (tons/yr) TSS Cost Benefit ($/ton) 1 (Existing) 0.6’ average depth N/A N/A 6.1 3.97 N/A 13.8 1.35 N/A 2 Excavate to 1.0’ average depth 100 3,000 10.0 6.46 996 19.6 2.00 3,562 3 Excavate to 2.0’ average depth 340 10,200 16.9 11.0 282 33.4 3.29 982 4 Excavate to 3.0’ average depth 590 17,700 22.3 14.5 222 45.2 4.45 741 5 Excavate to 4.0’ average depth 830 24,900 26.5 17.2 213 53.0 5.22 721 6 Excavate to 5.0’ average depth 1,070 32,100 30.0 19.5 242 57.6 5.67 840 7 Excavate to 5.7’ average depth (SWAMP managed depth) 1,230 36,900 32.1 20.9 261 59.4 5.84 921 APPENDIX A HISTORIC IMAGERY Figure 2a: Historic Google Earth Aerial, USDA Farm Service Agency, September 2006, Pond SWP-6751S-06 Not Yet Constructed Figure 2b: Historic Google Earth Aerial, USDA Farm Service Agency, September 2008, Pond SWP-6751S-06 APPENDIX B MAPS AND PHOTOS Figure 2c: Pond SWP-6751S-06, Sediment delta at the dual 30-inch Inlets Figure 2d: Pond SWP-6751S-06, Grass Clippings at Pond Outlet Page 1 of 2 Public Works Consultant Pool Work Order (2022 Stormwater Pond Maintenance) WSB & ASSOCIATES, INCORPORATED, dba WSB This work order (“Work Order”) is issued on this _______ day of _________________, 2021 by the City of Prior Lake (“City”) pursuant to the Public Works Consultant Pool – Master Agreement dated April 20, 2020 (“Contract”) between the City and WSB & Associates, Incorporated, dba WSB (“Consultant”). Based on the mutual promises and covenants set forth herein, the sufficiency of which are hereby acknowledged, the City and Consultant agree as follows: 1. Scope of Work Order. Consultant agrees to provide, perform and complete all the services requested by the City in this Work Order and attached Exhibit 1 (“Work”), which Work shall be subject to the terms and conditions of this Work Order and the Contract. 2. Term of Work Order. All Work requested by this Work Order shall be completed by December 31, 2022. 3. Compensation for Work Order. City agrees to pay the Consultant a fixed sum of $40,600.00 as full and complete payment for the Work requested by this Work Order. 4. Consultant Representative. Consultant has designated ___________________ to manage the Work Order subject to the supervision of Consultant’s representative. ISSUED BY CITY OF PRIOR LAKE ___________________________________ City Manager RECEIVED AND ACCEPTED BY CONSULTANT _____________________________________ By:_________________________ Its:_________________________ Page 2 of 2 Exhibit 1 – Scope of Work Order G:\Group Data\WATER RESOURCES\WR Proposal Folder\Prior Lake\LTR PROP-pyoung-20210604-2022PondMaintenance.docx 701 XENIA AVENUE S | SUITE 300 | MINNEAPOLIS, MN | 55416 | 763.541.4800 | WSBENG.COM June 4, 2021 Mr. Pete Young Water Resources Engineer City of Prior Lake 4646 Dakota Street SE Prior Lake, MN 55372 Re: 2022 Pond Maintenance Project City of Prior Lake, MN Dear Mr. Young: Attached for your review and approval is our proposed scope of services, fee, and schedule for providing professional engineering services to complete pond inspections, pond review memos, design, specification, permitting, bidding documents, and construction management for the 2022 Pond Maintenance Project. We look forward to working with you on the 2022 Pond Maintenance Project. If you are in agreement with this proposal, please sign where indicated below and return one copy. The necessary contract documents will then be provided. WSB will start work upon receip t of a signed contract. Please do not hesitate to contact Jake at 763 -231-4861 with any questions. Sincerely, WSB Jake Newhall, PE Earth Evans, PE Water Resources Project Manager Director of Water Resources Attachment ACCEPTED BY: City of Prior Lake, MN Name Title Date Mr. Pete Young June 4, 2021 Page 2 G:\Group Data\WATER RESOURCES\WR Proposal Folder\Prior Lake\LTR PROP-pyoung-20210604-2022PondMaintenance.docx SCOPE OF ENGINEERING SERVICES FOR 2022 POND MAINTENANCE PROJECT CITY OF PRIOR LAKE, MN SCOPE OF ENGINEERING SERVICES Task 1 – Project Management ($4,000) Project management will be performed throughout the course of the project. The following subtasks are included as part of Project Management: 1.1 Attend project update meetings with City staff. This will include developing the agenda, preparing handouts and graphics, and attending the meeting. 1.2 Work with project team to coordinate project deliverables, schedule, and budget. Deliverables: Two (2) meetings. One meeting with City Staff to discuss draft plans and one to discuss final plans for pond cleanout project. Task 2 – Pond Surveys ($8,500) This task consists of completing 21 pond surveys. This includes the 20 ponds identified for maintenance (14) and inspection (6) in the recent pond assessment report as well as pond 197. Findings from the inspections will be used in developing the pond review memos and maintenance recommendations. SWAMP will be updated to reflect the survey results. Deliverables: Bathymetric maps for each pond survey and updated SWAMP. Task 3 – Pond Review Memos and Recommendations ($3,000) This task includes completing 3-5 pond review memos. This will include memos for ponds 177 and 178 and up to three others based on survey results. The memos will include a comprehensive review of each pond and outfall and the associated drainage area. A cost-benefit analysis will be completed for each pond to determine the “best bang for the buck” maintenance activities. Recommendations for each basin will be provided. Deliverables: 3-5 pond review memos. Task 4 – Sediment Testing ($1,500) This task includes sediment sampling and analysis to determine the appropriate sediment disposal methods (consistent with the MPCA’s Managing Stormwater Sediment: Best Management Practice Guidance) for three ponds: Ponds 177 and 178 and another pond if it will be included in the 2022 maintenance project. Deliverables: Sediment Testing Spreadsheet. This task does not include lab fees. The fees will be passed on to the City and are anticipated to be approximately $300 per sample. Task 5 – Permit Coordination ($3,000) This task consists of coordinating and obtaining the required permits for the proposed pond/outfall maintenance activities. It is anticipated that US Army Corps of Engineers permitting will be required based on experience with similar projects. WSB will coordinate the necessary Wetland Conservation Act (WCA) no-loss applications. 5.1 US Army Corps of Engineers approval for the excavated ponds. Mr. Pete Young June 4, 2021 Page 3 G:\Group Data\WATER RESOURCES\WR Proposal Folder\Prior Lake\LTR PROP-pyoung-20210604-2022PondMaintenance.docx 5.2 WCA no-loss applications. Deliverables: Necessary permitting documentation for the US Army Corps of Engineers and WCA. This task does not include any necessary permit application fees; these will be pa ssed on to the City if applicable. Task 6 – Construction Documents ($9,800) This task consists of completing construction plans, specifications , and bidding documents for all recommended pond maintenance activities for three ponds: Ponds 177 and 178 and other pond as identified by the pond surveys and review memos. Plans will be developed using previously collected pond survey/inspection data. Plans are anticipated to include cover sheet, details, grading plan, restoration /erosion control, and site access/traffic control. One site visit per pond is anticipated during final design to confirm construction access and other constructability details. In addition, an updated cost estimate will be developed to verify consistency between the proposed improve ments and the City’s budget. This scope assumes answering questions during the bid process to help facilitate the understanding of construction expectations. It is important to note that this task does not include negotiating site access with property owners and obtaining temporary easements or right-of- entry; however, we can assist with this as needed. 6.1 Prepare draft construction plans, specifications, and updated cost estimate 6.2 Finalize construction plans, specifications and bidding documents based on feedback from City staff. Deliverables: Draft Plans, Final Plans, Specifications, and Bid Documents. Task 7 – Construction Management ($10,800) Construction management will be performed throughout the course of the construction schedule for the pond maintenance work. This will include attending weekly progress meetings throughout the project, and other necessary construction coordination. This task will include part-time observation (approximately 10-15 hours per week). This will include inspection of all critical construction components as well as regular check -ins with the contractor and the City. This scope of services also assumes WSB will complete all necessary construction staking and survey work. 7.1 Attend pre-construction meeting and weekly construction meetings. 7.2 Part-time construction observation. 7.3 Review and approve pay vouchers. 7.4 Construction Staking Deliverables: Construction Meetings, Construction Observation, and Construction Staking. TOTAL ESTIMATED ENGINEERING FEE Mr. Pete Young June 4, 2021 Page 4 G:\Group Data\WATER RESOURCES\WR Proposal Folder\Prior Lake\LTR PROP-pyoung-20210604-2022PondMaintenance.docx The scope of services outlined in this proposal will be billed hourly, based on our current hourly rates. We are proposing to complete the tasks outlined above for the 20 22 Pond Maintenance Project for a not-to-exceed fee of $40,600.00. TIME SCHEDULE Based on the current project schedule, WSB proposes to complete tasks 1-6 prior to October of 2021 to allow for bidding to occur in November of 2021 and construction in December/January/February. DRAINAGE BASIN #1 BOT. = 919.00 NWL = 923.00 HWL = 924.30 CB-1 CB-2 INSTALL SILT FENCE 5 2 . 4 9 4 9 . 8 1 4 5 . 9 8 44.8447. 7 0 51 . 6 9 5 8 . 3 755.9556.435 6 . 4 7 52 . 7 0 51.9049.6845.61 44.23 43.73 44.3647.31 60" Ø OUT. STR. HYD. HYD. 45° BEND (2)28.504' OVERFLOW WEIR ELEV. = 924.50 EOF OVERFLOW ROUTE WO WO INSTALL 412 SQ.YD. CAT. 3 EROSION CONTROL BLANKET WO WO WO WO WO LOWO 55 . 9 4 FE INV. = 921.95 FE-1 FE INV. = 922.50 55.91956. 1 5 955. 2 1 954. 9 7 953. 3 4 953. 1 0 PEDESTRIAN CURB RAMPS 956. 5 8 955. 6 4 953 . 7 8 954. 5 2 954. 2 8 954. 9 5 DRAIN TILE 943. 0 5 CB-3 CS CS CS CS CS CS CS CS CS55.72FE INV. = 920.00 DESIGN (ASB) 930 ELEVATION 930.5 ELEVATION NEW RELOCATED 15' WIDE SWALE (HATCHED). SEE DESCRIPTION REVISED GRADING CONTOURS ADDITIONAL 15' D&U EASEMENT (SEE DESCRIPTION ) REVISED GRADING CONTOURS VACATE EXISTING 20' D&U EASEMENT VACATE EXISTING 20' D&U EASEMENT (SHADED) FILL 34 CU YD 2% SWALE NEW EASEMENT LINE NEW EASEMENT LINE POOLFILL 147 CU YD 15' ADDITIONAL D&U EASEMENT (SEE DESCRIPTION) REMOME STORM STRUCTURE AND PIPING CUT 335 C.Y. PROPOSED 4' RET. WALL FILL 63 CU YD AVERAGE BUFFER WIDTH FOR "LOW" CATEGORY WETLAND IS 25 FEET WETLAND BUFFER REQUIREMENT LOW Average Buffer Width 25' Minimum Buffer Width 25' Minimum No Grade Zone 25' Foundation setback from wetland 35' 922.40 924.34 15" RCP 919.86 15" RCP EASEMENT THAT LIES BELOW ELEVATION 930.5 AND OUTSIDE OF THE NEW PROPOSED SWALES AS SHOWN ON THE PLAN: Description of public drainage and utility easement over, under, and across those parts of Lots 2, 3, 4, 5, 6, 7, and 8, Block 1, of Cardinal Overlook Addition, Scott County, Minnesota, according to the recorded plat thereof. Said easement lies southerly and westerly of a line within Lots 2-5, and easterly and southerly of a line within Lots 6, 7, and 8. Said line is described as follows: Commencing at the northwest corner of said Lot 2; thence S 00°20'48” E, assumed bearing, along the west line of said Lot 2 a distance of 72.13 feet to the beginning of the line to be described; thence N 36°14'40” E a distance of 20.27 feet; thence S 44°53'23” E a distance of 13.59 feet; thence S 9°09'39” E a distance of 34.17 feet; thence S 15°04'19” E a distance of 14.00 feet; thence S 61°10'14” E a distance of 16.93 feet; thence S 23°14'08” E a distance of 30.76 feet; thence S 21°16'01” E a distance of 45.74 feet; thence S 83°27'14” E a distance of 44.87 feet; thence S 43°08'23” E a distance of 82.40 feet; thence S 72°24'48” E a distance of 48.63 feet; thence N 89°14'42” E a distance of 10.24 feet; thence N 87°44'17” E a distance of 27.97 feet; thence S 69°05'10” E a distance of 17.27 feet; thence N 79°35'08” E a distance of 90.08 feet; thence N 39°26'21” E a distance of 25.70 feet; thence N 43°55'44” E a distance of 8.31 feet; thence S 75°42'25” E a distance of 21.46 feet; thence N 29°17'09” E a distance of 73.24 feet; thence N 1°13'45” E a distance of 86.65 feet; thence N 24°49'17” E a distance of 20.81 feet; thence N 2°08'28” W a distance of 36.39 feet; thence N 14°03'48” W a distance of 35.18 feet; thence N 34°45'52” W a distance of 24.07 feet; thence N 60°01'54” E a distance of 9.01 feet; thence S 49°50'10” E a distance of 54.26 feet; thence S 65°07'14” E a distance of 10.36 feet; thence S 18°59'51” E a distance of 34.08 feet to the east line of said Lot 7 distant 31.29 feet from the southeast corner of said Lot 7, and said line there terminating. Summary: Prior Lake, Minnesota; General Obligation Primary Credit Analyst: Charles Grabowski, Chicago + 1 (312) 233 7041; Charles.Grabowski@spglobal.com Secondary Contact: David H Smith, Chicago + 1 (312) 233 7029; david.smith@spglobal.com Table Of Contents Rating Action Stable Outlook Credit Opinion Related Research WWW.STANDARDANDPOORS.COM/RATINGSDIRECT JUNE 10, 2021 1 Summary: Prior Lake, Minnesota; General Obligation Credit Profile US$6.995 mil GO rfdg bnds ser 2021B due 12/15/2029 Long Term Rating AA+/Stable New US$6.24 mil GO bnds ser 2021A due 12/15/2031 Long Term Rating AA+/Stable New Prior Lake GO Long Term Rating AA+/Stable Affirmed Prior Lake GO Long Term Rating AA+/Stable Affirmed Rating Action S&P Global Ratings assigned its 'AA+' long-term rating to Prior Lake, Minn.'s $6.24 million series 2021A general obligation (GO) bonds and its $6.995 million 2021B GO refunding bonds. At the same time, we affirmed our 'AA+' long-term rating on the city's GO debt outstanding. The outlook on all ratings is stable. The bonds are secured by Prior Lake's GO unlimited property tax pledge. Debt service on the 2021A bonds is also payable from special assessments, but we rate to the GO pledge, which we view as the stronger security. Other GO debt of the city that we rate is secured by additional revenue pledges, but we rate these bonds to the GO pledge because we consider the GO pledge to be the stronger security. The 2021A bonds will be used to finance street reconstruction and improvements, and to refund, on a current basis, outstanding maturities of the city's 2011B GO bonds. The series 2021B bonds will be used to refund, on a current basis, outstanding maturities of the city's 2012A and 2014A GO bonds. Credit overview Prior Lake is located about 24 miles southwest of the Twin Cities, which supports its very strong economy. Financially, the city has reported consistently positive operating results in the general fund and across total governmental funds, leading to increases in available reserve levels. While the city plans to slightly draw down these available reserves in fiscal 2021, we expect them to remain very strong. However, we consider the city's overall debt burden to be fairly large, and a credit weakness. While the city plans to issue additional new-money debt in the coming years, we do not expect this issuance to further deteriorate the city's debt profile. The rating further reflects our view of the city's: • Very strong economy, with access to a broad and diverse metropolitan statistical area (MSA); • Very strong management, with strong financial policies and practices under our Financial Management Assessment (FMA) methodology; • Strong budgetary performance, with operating results that we expect could weaken in the near term relative to fiscal WWW.STANDARDANDPOORS.COM/RATINGSDIRECT JUNE 10, 2021 2 2020, which closed with operating surpluses in the general fund and at the total governmental fund level; • Very strong budgetary flexibility, with an available fund balance in fiscal 2020 of 89% of operating expenditures; • Very strong liquidity, with total government available cash at 130.2% of total governmental fund expenditures and 6.4x governmental debt service, and access to external liquidity we consider strong; • Weak debt and contingent liability profile, with debt service carrying charges at 20.3% of expenditures and net direct debt that is 154.9% of total governmental fund revenue, but rapid amortization, with 97.0% of debt scheduled to be retired in 10 years; and • Strong institutional framework score. Environmental, social, and governance (ESG) factors We have analyzed the city's ESG risks and determined that all are in line with our view of the sector standard. We note that the city could be susceptible to occasional flooding. However, we believe this risk is mitigated by the city's flood response policy and maintenance of very high reserve levels. Stable Outlook Upside scenario We could raise the rating if debt levels moderate and economic metrics improve, in line with higher-rated peers. Downside scenario We could lower the rating if the city experiences a budgetary imbalance, leading to a material weakening in budgetary flexibility. Credit Opinion Very strong economy The city, with an estimated population of 26,164, is located in Scott County in the Minneapolis-St. Paul-Bloomington, MN-WI MSA, which we consider to be broad and diverse. The city has a projected per capita effective buying income of 142% of the national level and per capita market value of $158,652. Overall, the city's market value grew by 7.5% over the past year, to $4.2 billion in 2020. The county unemployment rate was 2.7% in 2019, but the COVID-19 pandemic resulted in the 2020 average unemployment rate increasing to 5.9%. Major employers in the city include the Shakopee Mdewakanton Sioux Community (4,500 employees), which operates the Mystic Lake Casino; the local school district (1,195); and childcare provider Playworks (175). Market values have increased steadily during the past few years and estimates provide for additional increases in net tax capacity going forward. About 89% of the tax base is residential, which has provided the city a stable source of tax base growth in recent years. The city's top 10 taxpayers represent 5% of its tax base, which we consider very diverse. Going forward, management expects robust growth, both residentially and commercially. Based on this growth, we expect the local economy to remain very strong. WWW.STANDARDANDPOORS.COM/RATINGSDIRECT JUNE 10, 2021 3 Summary: Prior Lake, Minnesota; General Obligation Very strong management We view the city's management as very strong, with strong financial policies and practices under our FMA methodology, indicating financial practices are strong, well-embedded, and likely sustainable. Highlights of the city's management policies and practices include: • Use of two years of historical data, outside data sources, and line-item estimates when developing the budget; • Budget-to-actual results and investment holdings are reported to council quarterly; • A current-plus-10-year long-term financial plan, although council typically focuses on the upcoming five years; • A 10-year capital improvement plan that is updated regularly; • A formal investment policy, with investment holdings reported to council quarterly; • Debt management policy, which includes limitations on the issuance and amortization of debt and requires the city to maintain a debt management study, which forecasts future borrowing plans; and • Formal reserve policy of maintaining general fund reserves at a minimum of 40% to 50% of expenditures. Strong budgetary performance The city had operating surpluses of 16% of expenditures in the general fund and 6.6% across all governmental funds in fiscal 2020. While we expect Prior Lake to have at least balanced operating results going forward, we do not expect results to be as favorable as they had been in 2020. Our analysis of the city's budgetary performance reflects adjustments made for recurring transfers, one-time expenditures, the spending of bond proceeds, and adjusted debt service costs paid by water enterprise fund transfers. General fund performance and total governmental fund performance have been positive in recent years on an adjusted basis. In fiscal 2020, the city outperformed its final budget, which was structured with a $201,250 deficit. Driving this result was better-than-expected building permit revenue, increased state aid, and operating grants, as well as lower expenditures associated with decreased personnel costs, and operating supply cost savings across departments. Major general fund revenue sources in fiscal 2020 include property taxes (54.1%), intergovernmental revenue (24.8%), charges for services (6.6%), and licenses and permits (5.5%). Additionally, the city received just under $2 million in federal Coronavirus Aid, Relief, and Economic Security (CARES) Act funding in fiscal 2020. The city's fiscal 2021 budget calls for a slight deficit in the general fund after net transfers. Historically, year-end results have outperformed budgeted figures, and management reports that revenues are tracking above budgeted. Finally, the city expects to receive approximately $3.1 million in further stimulus funding in fiscal 2021. Very strong budgetary flexibility In fiscal 2020, the city had an available fund balance of 89% of operating expenditures, or $12.4 million. We expect the available fund balance to remain above 30% of expenditures for the current and next fiscal years, which we view as a positive credit factor. The available fund balance includes $10.0 million (71.8% of expenditures) in the general fund and $2.4 million (17% of expenditures) that is outside the general fund but legally available for operations with council approval. These reserves outside of the general fund include balances in the city's revolving equipment, revolving park equipment, and facility management funds. Based on our expectation that the city will maintain strong budgetary WWW.STANDARDANDPOORS.COM/RATINGSDIRECT JUNE 10, 2021 4 Summary: Prior Lake, Minnesota; General Obligation performance during the next few years, we expect budgetary flexibility to remain very strong. Very strong liquidity In fiscal 2020, the city had total government available cash equal to 152.9% of total governmental fund expenditures and 7.5x governmental debt service. In our view, the city has strong access to external liquidity, if necessary. After adjusting restricted amounts, the city had approximately $35.9 million in available cash and investments in 2020 that were held primarily in money market funds, U.S. agency securities, certificates of deposit, and other investments that we do not consider aggressive. The city has strong access to external liquidity, in our opinion, because of its history of issuing GO debt over the past two decades. The city has a 2014 private lease-purchase agreement with approximately $1.3 million currently outstanding. Events of default are standard under the agreement and debt acceleration, in an event of default, is limited to the amounts owed in the current fiscal year, with a maximum amount of approximately $300,000. We therefore do not consider the lease-purchase agreement to be a contingent liability risk, and expect the city's liquidity to remain very strong. Weak debt and contingent liability profile Total governmental fund debt service is 20.3% of total governmental fund expenditures and net direct debt is 154.9% of total governmental fund revenue. Approximately 97.0% of the direct debt is scheduled to be repaid within 10 years, which is, in our view, a positive credit factor. The city expects to issue $9.7 million in additional debt within the next two years for capital improvements. We do not expect that these additional debt plans will weaken the city's existing debt profile. Prior Lake's combined required pension and actual other postemployment benefit (OPEB) contributions totaled 5.3% of total governmental fund expenditures in 2020. The city made its full required pension contribution in 2020. We do not believe that pension liabilities represent a medium-term credit pressure, as contributions are only a modest share of the budget, and we believe the city has the capacity to absorb higher costs without pressuring operations. Prior Lake participates in two multiple-employer, defined-benefit pension plans that have seen recent improvements in funded status, though plan statutory contributions have regularly fallen short of actuarial recommendations. Along with certain plan-specific actuarial assumptions and methods, this introduces some long-term risk of funding volatility and cost acceleration. The city participates in the following plans: • Minnesota General Employees Retirement Fund (GERF): 79.1% funded (as of June 30, 2020), with a city proportionate share of the plan's net pension liability of $4.3 million. • Minnesota Police and Fire Fund (PEPFF): 87.2% funded (June 30, 2020), with a proportionate share of $3.4 million. • A single-employer, defined-benefit OPEB plan: 0% funded, with a net OPEB liability of $865,000. Total contributions to GERF and PEPFF were 89% and 94%, respectively, of our minimum funding progress metric and were slightly above static funding in both cases. Annual contributions are based on a statutory formula that has typically produced contributions lower than the actuarially determined contribution for each plan. In our view, this WWW.STANDARDANDPOORS.COM/RATINGSDIRECT JUNE 10, 2021 5 Summary: Prior Lake, Minnesota; General Obligation increases the risk of underfunding over time if the state legislature does not make adjustments to offset future funding shortfalls. Other key risks include a 7.5% investment rate-of-return assumption (for both plans) that indicates some exposure to cost acceleration as a result of market volatility, and an amortization method that significantly defers contributions through a lengthy, closed 30-year amortization period based on a level 3.25% payroll growth assumption. Regardless, costs remain only a modest share of total spending, and we believe they are unlikely to pressure the city's medium-term operational health. Strong institutional framework The institutional framework score for Minnesota cities with populations greater than 2,500 is strong. Related Research • Through The ESG Lens 2.0: A Deeper Dive Into U.S. Public Finance Credit Factors, April 28, 2020 Ratings Detail (As Of June 10, 2021) Prior Lake GO bnds Long Term Rating AA+/Stable Affirmed Prior Lake ICR Long Term Rating AA+/Stable Affirmed Prior Lake GO Long Term Rating AA+/Stable Affirmed Certain terms used in this report, particularly certain adjectives used to express our view on rating relevant factors, have specific meanings ascribed to them in our criteria, and should therefore be read in conjunction with such criteria. Please see Ratings Criteria at www.standardandpoors.com for further information. Complete ratings information is available to subscribers of RatingsDirect at www.capitaliq.com. All ratings affected by this rating action can be found on S&P Global Ratings' public website at www.standardandpoors.com. Use the Ratings search box located in the left column. WWW.STANDARDANDPOORS.COM/RATINGSDIRECT JUNE 10, 2021 6 Summary: Prior Lake, Minnesota; General Obligation WWW.STANDARDANDPOORS.COM/RATINGSDIRECT JUNE 10, 2021 7 STANDARD & POOR’S, S&P and RATINGSDIRECT are registered trademarks of Standard & Poor’s Financial Services LLC. S&P may receive compensation for its ratings and certain analyses, normally from issuers or underwriters of securities or from obligors. S&P reserves the right to disseminate its opinions and analyses. S&P's public ratings and analyses are made available on its Web sites, www.standardandpoors.com (free of charge), and www.ratingsdirect.com (subscription), and may be distributed through other means, including via S&P publications and third-party redistributors. Additional information about our ratings fees is available at www.standardandpoors.com/usratingsfees. S&P keeps certain activities of its business units separate from each other in order to preserve the independence and objectivity of their respective activities. As a result, certain business units of S&P may have information that is not available to other S&P business units. S&P has established policies and procedures to maintain the confidentiality of certain non-public information received in connection with each analytical process. To the extent that regulatory authorities allow a rating agency to acknowledge in one jurisdiction a rating issued in another jurisdiction for certain regulatory purposes, S&P reserves the right to assign, withdraw or suspend such acknowledgment at any time and in its sole discretion. S&P Parties disclaim any duty whatsoever arising out of the assignment, withdrawal or suspension of an acknowledgment as well as any liability for any damage alleged to have been suffered on account thereof. Credit-related and other analyses, including ratings, and statements in the Content are statements of opinion as of the date they are expressed and not statements of fact. S&P’s opinions, analyses and rating acknowledgment decisions (described below) are not recommendations to purchase, hold, or sell any securities or to make any investment decisions, and do not address the suitability of any security. S&P assumes no obligation to update the Content following publication in any form or format. The Content should not be relied on and is not a substitute for the skill, judgment and experience of the user, its management, employees, advisors and/or clients when making investment and other business decisions. S&P does not act as a fiduciary or an investment advisor except where registered as such. While S&P has obtained information from sources it believes to be reliable, S&P does not perform an audit and undertakes no duty of due diligence or independent verification of any information it receives. Rating- related publications may be published for a variety of reasons that are not necessarily dependent on action by rating committees, including, but not limited to, the publication of a periodic update on a credit rating and related analyses. No content (including ratings, credit-related analyses and data, valuations, model, software or other application or output therefrom) or any part thereof (Content) may be modified, reverse engineered, reproduced or distributed in any form by any means, or stored in a database or retrieval system, without the prior written permission of Standard & Poor’s Financial Services LLC or its affiliates (collectively, S&P). The Content shall not be used for any unlawful or unauthorized purposes. S&P and any third-party providers, as well as their directors, officers, shareholders, employees or agents (collectively S&P Parties) do not guarantee the accuracy, completeness, timeliness or availability of the Content. S&P Parties are not responsible for any errors or omissions (negligent or otherwise), regardless of the cause, for the results obtained from the use of the Content, or for the security or maintenance of any data input by the user. The Content is provided on an “as is” basis. S&P PARTIES DISCLAIM ANY AND ALL EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, ANY WARRANTIES OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE OR USE, FREEDOM FROM BUGS, SOFTWARE ERRORS OR DEFECTS, THAT THE CONTENT’S FUNCTIONING WILL BE UNINTERRUPTED OR THAT THE CONTENT WILL OPERATE WITH ANY SOFTWARE OR HARDWARE CONFIGURATION. In no event shall S&P Parties be liable to any party for any direct, indirect, incidental, exemplary, compensatory, punitive, special or consequential damages, costs, expenses, legal fees, or losses (including, without limitation, lost income or lost profits and opportunity costs or losses caused by negligence) in connection with any use of the Content even if advised of the possibility of such damages. Copyright © 2021 by Standard & Poor’s Financial Services LLC. All rights reserved.