Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
_10 02 2023 City Council Agenda Packet
July 13, 2023 City of Prior Lake and Prior Lake Police Department Liam Duggan, Chief of Police 4649 Dakota Street SE Prior Lake, MN 55372 Sent via email to LDuggan@priorlakemn.gov On behalf of Berry Dunn McNeil & Parker, LLC (BerryDunn), we are pleased to submit this Letter of Engagement (LOE) as a formal proposal per our ongoing discussions. In the pages that follow, we offer our approach to conducting a key staffing study of the Prior Lake Police Department (PLPD), introduce our proposed team members, and outline our fees for this service. Thank you for the opportunity to provide you with this additional information. As the principal of BerryDunn’s Justice and Public Safety Practice, I am authorized to bind BerryDunn to the commitments made herein. Our proposal and price quote is valid for 90 days from the submission date of July 17, 2023. Should you have any questions regarding our services or wish to discuss your goals and objectives with us in more detail, please feel free to contact us. We look forward to learning more about how we can help the PLPD achieve its goals and objectives for this important initiative. Sincerely, Michele Weinzetl, Ed.D., Prosci® CCP Senior Manager t/f: 207-842-8120 e: mweinzetl@berrydunn.com Doug Rowe, PMP®, ITIL Principal t/f: 207-541-2330 e: drowe@berrydunn.com Professional Services Proposal – City of Prior Lake 1 Project Scope The need for police agencies to deliver high-quality professional police services is at an all-time high. Communities and government officials have significant, but reasonable expectations related to the efficient and effective use of the resources they have committed to the public- safety mission. In turn, police officials have a responsibility to monitor and examine operational processes to ensure they are optimally configured, and that they are consistent with contemporary police standards and industry best practices. BerryDunn understands that the City of Prior Lake, MN (City), and the Prior Lake Police Department (PLPD) are interested in a workload-based review of police department staffing, including a review of the patrol work schedule and the efficiency and effectiveness of the deployment of patrol personnel. The results of the project are intended to drive progressive change for the City, helping to ensure efficient staffing and overall functionality of police operations. In our experience, assessments of this nature help to deepen community trust, stakeholder confidence, operational best practices, productivity, and workforce satisfaction. Project Approach Overview BerryDunn has developed a Key Staffing and Operations Review process to assist police agencies in assessing their organizations from a critical vantage point. In collaboration with the PLPD, the BerryDunn team will conduct an examination of key staffing and procedural aspects, both with respect to the individual policing environment, and the overarching standards of the professional policing environment. Following the assessment, BerryDunn will produce a written report that will identify key findings, as well as any gaps in practice that might benefit from adjustment. Our work with the PLPD will entail the following: › A workload-based analysis on staffing levels for patrol o Separation of in-City and On-Reservation workloads › A workload-based analysis on staffing levels for investigations › A review of staffing of non-sworn positions and all other sworn positions › A review of response times, patrol zone layouts, and response efficiency › A review of targeted operational aspects of the department, assessed independently for the agency, and in comparison to prior police agencies studied, and industry best- practices: o Personnel allocations by rank and unit; o Staff diversity; o Hiring, recruiting, and attrition rates; o Serious crimes and crime clearance rates; o 21st Century Policing benchmarks; o Field technology use; o Examination of the patrol work schedule in relation to service needs and demands; and Professional Services Proposal – City of Prior Lake 2 o A report on possible patrol work schedule design changes. Due to the focused nature of this project, the analysis and results will be limited to the specific operational areas identified above. BerryDunn can optionally provide an expanded level of analysis, which would evaluate and analyze other organizational functions, including: › Organizational leadership and culture › Youth and other community engagement › Operational policies and procedures › Dispatch and communication services › Department training, equipment, and technology › Internal affairs and community accountability As discussed, we are happy to add various elements to the project scope based on the PLPD’s needs. Detailed Project Work Plan and Phases What follows is a brief outline of our work plan and the different phases of the efforts we will engage to complete the desired tasks for the PLPD, based on the identified scope. BerryDunn strives to be flexible when developing and executing an effective project plan. Accordingly, BerryDunn will work with the PLPD project team to make adjustments to this work plan, should the need arise. Our approach includes four phases. An overview of the four phases of our approach is illustrated in Figure 1. Figure 1: Four-Phased Project Approach PHASE 1: PHASE 2: PROJECT PLANNING AND INITIATION DATA COLLECTION AND ANALYSIS PHASE 3: PHASE 4: PREPARATION OF FINDINGS AND RECOMMENDATIONS PRESENTATION OF FINDINGS AND PATROL SCHEDULE REVIEW Phase 1 – Project Planning and Initiation Task 1.1: Conduct a preliminary planning meeting: BerryDunn will conduct an initial project planning meeting, in person, with the PLPD’s project team to review our proposed plan of services and schedule, clarify goals and objectives, identify known project constraints, and refine dates and/or tasks as appropriate. As part of this meeting, we will discuss our approach for managing communications between BerryDunn and the PLPD, as well as our approach to scope, risks, and resource management. Professional Services Proposal – City of Prior Lake 3 Based on these initial project planning discussions, we will draft a summary Project Work Plan and Schedule for distribution to key project team members detailing the scope of work, plan of strategy and approach, and project schedule with all major components. We will facilitate a teleconference with the PLPD to gain the project team’s approval of the Project Work Plan and Schedule, collecting any feedback for incorporation in the final version. Deliverable 1: Project Work Plan and Schedule Task 1.2: Provide ongoing project management. Throughout the project, BerryDunn’s project manager will maintain regular communications with the PLPD’s project manager and provide appropriate project updates in the following areas: › Status of project activities, including tasks and deliverables completed over the reporting period › Upcoming tasks and deliverables, including scheduled on-site work and the planned schedule for completion of activities › Decisions/actions pending › Risks or issues to be addressed with the PLPD that might impact the timing or scope of our services Phase 2 – Data Collection and Analysis Task 2.1: Collect and analyze data. To conduct a thorough project, BerryDunn will call upon the PLPD to produce and provide various documents and data—either through gathering or reorganizing current police department data or through the completion of worksheets and surveys that our team provides. BerryDunn anticipates receiving the following data from the PLPD: Worksheets Agency Information › Authorized personnel › CAD/RMS dataset › Investigations case, leave, and personnel data › Patrol leave data › Patrol unit data › Patrol watch shift hours › Technology scorecard › Training hours data › Agency budget › Organizational chart › Patrol schedule › Patrol district/sector map › Vision, goals, and objectives This list is not intended to be all-inclusive, and BerryDunn may request additional data to inform this project, as necessary. We recognize that the time expended to produce this data might be significant, depending upon where and how the data are stored and the ability to retrieve the data. We also anticipate that in some cases, the data requested might not exist. In addition, some of the requested data will need to be produced in a specific format, and it will need to include specific data elements in order to be useful. Where appropriate, BerryDunn will provide Professional Services Proposal – City of Prior Lake 4 guidance or other support on how the PLPD can compile the data to help ensure it is produced in a usable format and to improve the efficiency in retrieving and providing data for this study. Task 2.2: Issue Internal Worksheets and Surveys. In addition to gathering existing data from the agency, we will use several instruments to collect relevant data for management, operations, and staffing studies. For this project, BerryDunn will use the following worksheets and surveys: › 21st Century Policing Assessment Survey: Assesses the extent to which the department is engaging in contemporary policing practices, as outlined in the 21st Century Policing Task Force Report › Investigations Workload Worksheet and Survey: Quantifies various investigations duties and expectations and aids in calculating workload capacities for detectives › Patrol and Investigations Leave and Training Worksheets: Identifies the amount of available work time for officers assigned to these units › Patrol Workload Worksheet and Survey: Quantifies actual workloads through a real-time data collection instrument, which allows for validation against data collected from Computer Aided Dispatch (CAD) › Patrol Schedule Assessment Worksheet: Documents the consistency of the parameters of the patrol work schedule against best practices standards › Personnel, Patrol, and Investigations Staff Worksheets: Collects personnel data that identifies personnel deployment to different sections of the department › Recruiting Processes, Actions, and Survey: Outlines the recruiting and hiring efforts of the agency, including quantification of attrition rates › Technology Scorecard: Assesses the deployment and functionality of the hardware and software technology of the patrol fleet Task 2.3: Conduct individual interviews and internal group discussions. BerryDunn will schedule and conduct onsite interviews with key department leaders and functional personnel from various units. The purpose of these interviews is to assess goals, objectives, policies, procedures, practices, workload, problems, needs, and opportunities that characterize their operations. We will work with the PLPD to schedule, prepare for, and inform participants of the interviews prior to arriving on-site (as relevant). Phase 3 – Preparation of Findings and Recommendations Task 3.1: Develop Preliminary Findings and Recommendations Report. Our analysis of data collected in Phase 2 will focus on an assessment of organizational staffing and personnel distribution and assignments, and any other defined scope items. We will identify any gaps in practice or issues that require attention and develop preliminary findings and recommendations. These findings and recommendations will undergo an internal review by the BerryDunn team of SMEs and be revised, as needed, to address contemporary policing and best practices standards. We will provide this draft to the PLPD for review and comment. Professional Services Proposal – City of Prior Lake 5 Task 3.2: Develop recommendations regarding the patrol schedule. As an element of this project, BerryDunn will evaluate the layout, structure, effectiveness, and efficiency of the patrol schedule, against best practices standards and against available workload data. This review will result in 1 of 3 possible findings: › The patrol schedule is generally meeting operational objectives; › Making adjustments to certain schedule components within the current structure could contribute to greater effectiveness and efficiency; and › Several areas of patrol schedule effectiveness or efficiency are not being met, and it is likely that a full redesign of the schedule will be necessary to optimize effectiveness. Task 3.3: Develop recommendations regarding possible patrol schedule designs. Following the schedule assessment from Task 3.2, BerryDunn will engage a patrol schedule redesign process. For this process, BerryDunn will facilitate a collaborative process with the PLPD to accomplish the patrol schedule redesign. The process will involve several steps, including: › The creation of a committee to collaborate on this project › Onsite training for the committee on best practices schedule parameters and options › Collaborative development of three to four alternate schedule designs for consideration › A report that outlines each design, along with pros and cons and considerations for each model › The proposed schedule models should: » Help ensure there is compliance with scheduling parameters » Avoid schedules that involve different shift durations for different shifts » Help ensure flexibility to manage leave and other operational needs Following the redesign process, BerryDunn will provide the PLPD with a Patrol Schedule Redesign Report that outlines and finalizes our recommendations. (This report will ultimately become part of the full project report.) If necessary, BerryDunn will also provide assistance to the PLPD with the initial design and implementation of the new schedule. Deliverable 2: Patrol Schedule Redesign Report Deliverable 3: Preliminary Findings and Recommendations Report Phase 4 – Presentation of Findings and Patrol Schedule Review Task 4.1: Develop Final Findings and Recommendations Report. Upon receiving feedback from the PLPD regarding BerryDunn’s preliminary findings, we will develop the preliminary recommendations into a final report relating to project objectives. The final report will be delivered in Task 4.2. Task 4.2: Present Findings and Patrol Schedule Redesign Recommendations. Upon completion of the final report, BerryDunn will work with the PLPD to schedule and conduct an Professional Services Proposal – City of Prior Lake 6 on-site presentation of the findings and recommendations report, including any general recommendations concerning patrol schedule redesign. Deliverable 4: Final Findings and Recommendations Report and Presentation Proposed Project Team Members The BerryDunn team brings decades of executive law enforcement experience, augmented by many years of independent mentoring, executive training, research and publishing, and consulting experience. BerryDunn’s people are our differentiators. We hear this feedback repeatedly from our clients, whose repeated selection of our services is a testament to their satisfaction with our team members and work products. Below and on the following page, we introduce each project team member and describe their role on the project. Doug Rowe, ITIL, PMP® Principal Doug is principal of BerryDunn’s Justice and Public Safety Practice, bringing over 40 years of IT industry experience—20 of which have been spent working with justice and public safety agencies. Doug’s focus is on recommending actionable improvements for his clients. He has an in-depth understanding of the justice and public safety operating environment and leverages this knowledge to develop recommendations that align with operational goals and objectives. This experience includes work with police agencies, courts, sheriff’s offices, departments of corrections, and fire departments, among others. He has overseen nearly a dozen of BerryDunn’s project with police and law enforcement agencies nationwide. As project principal, Doug maintains overall responsibility for maintaining BerryDunn’s agreement with the PLPD. He reviews and approves all project deliverables to help ensure we meet the PLPD’s needs and our internal quality standards. When appropriate, Doug will also reach into BerryDunn’s bench of consultants and pull in specialized resources to meet project needs. Michele Weinzetl, Ed.D., Prosci® CCP Senior Manager / Project Manager Michele is a senior manager in BerryDunn’s Justice and Public Safety Practice, with over 35 years of public safety experience. Michele served over 27-years in policing, 17 of which were spent as chief of police for three Minnesota cities. Prior to BerryDunn, Michele worked for the International Association of Chiefs of Police (IACP), evaluating police departments’ operations, management, and staffing capabilities, and conducting technical assistance and strategic planning projects for agencies across the country—ranging from 50 to 2,000+ officers. She is the former president of the IACP Minnesota chapter and former instructor at St. Cloud State University in public safety leadership. Michele is an expert in 21st Century Policing and industry best practices and brings extensive experience instructing hundreds of police officers and police executives in the areas of supervision, leadership development, and a variety of policing skills. As project manager, Michele will serve as the primary point of contact with the PLPD and lead all day-to-day activities. She will maintain the Project Work Plan and Schedule and delegate to the BerryDunn team. Michele is the primary author on the PLPD’s final report. Professional Services Proposal – City of Prior Lake 7 The BerryDunn team brings decades of executive law enforcement experience, augmented by many years of independent mentoring, executive training, research and publishing, and consulting experience. BerryDunn’s people are our differentiators. We hear this feedback repeatedly from our clients, whose repeated selection of our services is a testament to their satisfaction with our team members and work products. Below and on the following page, we introduce each project team member and describe their role on the project. Melissa Vanlandingham Business Analyst Melissa is a consultant in BerryDunn’s Justice and Public Safety Practice and joins the firm after 15 years of experience with the Austin, Texas, Police Department. She began her career in dispatch and records maintenance for three years before advancing to analytics. As a crime analyst, Melissa compiled and analyzed Records Management System crime reports to understand potential causes of criminal activity, develop leads, and find links in crime by attributes specific to the crime. Each week, she organized data into crime types, call volume, response times, and call type allocation. Since 2015, Melissa has served as the Senior Criminal Intelligence Analyst in which she worked with qualitative and quantitative data for the purpose of analysis and intelligence gathering. She is an expert in translating data into meaningful outputs. As a business analyst, Melissa will support the project team as needed and provide valuable insight during her time as a dispatch operator. F. Heath Gorham Subject Matter Expert Heath is a senior consultant in BerryDunn’s Justice and Public Safety Practice and joins the firm after 14 years of experience with the Portland, Maine Police Department, where he ended his law enforcement career as the Interim Chief of Police. He trained and supervised the PPD’s current team of 158 sworn officers and 51 civilian employees who respond to over 83,000 calls for service annually. As Assistant Chief of Police, he implemented department programs, personnel management, and the latest mission technology across the spectrum of the PPD. Heath has hands-on experience as an FTO Instructor, Crime Reduction Sgt., and Hazardous Devices Unit Lt. He is known for managing complex incidents with exceptional leadership while collaborating with the community. As a subject matter expert, Heath will support Michele by co-facilitating group and individual interviews, group meetings, and community forums. He will offer his expertise during deliverable development to help ensure our recommendations align with best practices. Professional Services Proposal – City of Prior Lake 8 Project Fees In Table 1, BerryDunn presents our fees by project deliverable. We have developed our costs based on our detailed work plan, staffing and resource allocation, and the estimated level of effort from experience conducting similar projects in scope and size. Our firm fixed price for this project is $42,000. This includes all tasks and deliverables described above, and all other associated costs, including travel. BerryDunn anticipates 1 onsite trip for the initial project meeting and kickoff (see Task 1.1), a 1.5-day onsite trip for fact-finding (see Task 2.3), a half-day onsite visit for the patrol schedule redesign process (see Task 3.3), and a one-day onsite trip for presentation of the final report and findings (see Task 4.2). Table 1: Cost per Deliverable No. Deliverable Cost 1 Project Work Plan and Schedule $ 4,000 2 Patrol Schedule Redesign Report $12,000 3 Preliminary Findings and Recommendations Report $22,500 4 Final Findings and Recommendations Report and Presentation $ 3,500 Total $42,000 Project Timing Because of their comprehensive and complex nature, projects of this type require significant time to accomplish. Based on the prescribed scope and our experience, BerryDunn estimates that this project will take approximately four-five months to complete, from the point of engagement through the delivery of the final report. This estimate assumes the timely collection and return of the data requested as it relates to the scope of services. The timeline for delivery of our proposed deliverables is outlined below in Table 2. Table 2: Proposed Timeline by Deliverable and Actions Deliverables and Actions Estimated Timeline ACTION STEPS: Initial Teleconference and Schedule Discussion Month 1 Deliverable 1: Project Work Plan and Schedule Month 1 ACTION STEPS: Data Gathering; Interviews; Analysis Months 1-2 Deliverable 2: Conduct Patrol Schedule Redesign Process Months 2-3 ACTION STEPS: Develop Preliminary Findings and Recommendations Months 2-3 Deliverable 3: Preliminary Findings and Recommendations Report Month 3-4 ACTION STEPS: Develop Final Draft and Recommendations Month 4-5 Deliverable 4: Final Findings and Recommendations Report Month 4-5 ACTION STEPS: Onsite Presentation of Report and Findings Month 5 CHECK REGISTER FOR CITY OF PRIOR LAKE 1/9Page: 09/22/2023 10:23 AM User: mfonder DB: Prior Lake CHECK DATE FROM 09/09/2023 - 09/22/2023 AmountDescriptionVendor NameVendorCheckCheck Date Bank 1 General Bank 1,019.03 2023 Dental ClaimsDELTA DENTAL0002721310360(E)09/11/2023 2,745.10 Aug 2023 Merchant FeesINVOICE CLOUD0002809110361(E)09/11/2023 313.79 Aug 2023 Merchant Card FeesTRANSFIRST0002069310362(E)09/11/2023 9.22 Sep 2023 COBRA Vision PremiumsEYEMED0002791710363(E)09/12/2023 107,847.29 Sep 2023 Health Insurance PremiumsMEDICA0001332510364(E)09/12/2023 46.00 Filing Fee - Stormwater ManagementSCOTT COUNTY0001921210365(E)09/12/2023 2,400.00 Aug 2023 Animal Control4 PAWS ANIMAL CONTROL LLC0000679810345(A)09/15/2023 55.87 Chaplain Event RefreshmentsBENJAMIN ERICKSON0002743710346(A)09/15/2023 5,126.83 Aug 2023 General MattersCAMPBELL KNUTSON PA0002804310347(A)09/15/2023 529.50 Aug 2023 15370 Fish Pt Rd 494.75 Aug 2023 Litigation 6,151.08 8,650.00 15075 Fairlawn Shores Trl SE - Tree RemoCOLLINS TREE 0000367010348(A)09/15/2023 195.08 SocketCORE & MAIN0002732810349(A)09/15/2023 124.32 7109N Squad supplies EMERGENCY AUTOMOTIVE TECH INC0000548010350(A)09/15/2023 57.75 544 Magnetic Clip 182.07 2.52 Cable TiesFASTENAL COMPANY0000614010351(A)09/15/2023 260.00 Repair Sewer HoseFLEXIBLE PIPE TOOL CO0000666010352(A)09/15/2023 14,732.60 Water Treatment ChemicalsHAWKINS INC0000831210353(A)09/15/2023 500.00 Dial Up SupportHUMERATECH0002718410354(A)09/15/2023 474.38 Envelopes - MCINNOVATIVE OFFICE SOLUTIONS LLC0002714910355(A)09/15/2023 29.68 Fonder - Name Plate 504.06 135.00 Aug 2023 Yoga InstructorMARY MULLETT0002817210356(A)09/15/2023 297.66 Paper SuppliesNETWORK SERVICES COMPANY0001438110357(A)09/15/2023 196.82 Paper Supplies 79.50 Paper Supplies 573.98 341.92 E Coli TestingUC LABORATORY0002123510358(A)09/15/2023 277.20 E Coli Testing 619.12 65.00 Pest Control - FS #2XTREME PEST SOLUTIONS INC0002711610359(A)09/15/2023 6.00 Sep 2023 Electric BillSHAKOPEE PUBLIC UTILITIES0001938810366(E)09/15/2023 339.75 Reflective Sheeting3M0002686211280609/15/2023 100.74 UB refund for account: 10023950ALABAMA 2, LLCREFUND-UB11280709/15/2023 16.25 Program RefundALEXA WAGNERREFUND-REC11280809/15/2023 16.25 Program RefundALEXANDRA MINELLI-FENSTERMACHERREFUND-REC11280909/15/2023 32.50 Program RefundAMY HILLREFUND-REC11281009/15/2023 63.27 UB refund for account: 10095800ANDERSON JUDITHREFUND-UB11281109/15/2023 3,809.91 Sod Replacement ReimbursementANDY CARNEY0002844511281209/15/2023 16.25 Program RefundASHLEY MOOREREFUND-REC11281309/15/2023 494.67 UB refund for account: 30488802BISHOP MARKREFUND-UB11281409/15/2023 69.52 UB refund for account: 40562900BORIS DANIELREFUND-UB11281509/15/2023 16.25 Program RefundBRITTANY PEARSONREFUND-REC11281609/15/2023 16.25 Program RefundBROOKE EASTMANREFUND-REC11281709/15/2023 32.50 Program RefundCASSIE JACOBSONREFUND-REC11281809/15/2023 CHECK REGISTER FOR CITY OF PRIOR LAKE 2/9Page: 09/22/2023 10:23 AM User: mfonder DB: Prior Lake CHECK DATE FROM 09/09/2023 - 09/22/2023 AmountDescriptionVendor NameVendorCheckCheck Date 15.25 UB refund for account: 10204904CLARKE DANIELREFUND-UB11281909/15/2023 7,398.40 7137 Jeep hail damage repair COLLISION CENTER 10002821311282009/15/2023 597.48 Aug 2023 UB Billing CSG SYSTEMS INC0002750611282109/15/2023 500.00 Pursuit Refresher - Rozga and SnyderDAKOTA CTY TECH COLLEGE0000405011282209/15/2023 250.00 Pursuit Refresher - Hageman 750.00 16.25 Program RefundDAVE & GINA OLSONREFUND-REC11282309/15/2023 5,634.51 Street SweepingsDEM-CON LANDFILL LLC0000436011282409/15/2023 132.46 UB refund for account: 10023061DISTINCTIVE DESIGN BUILDREFUND-UB11282509/15/2023 2,680.00 Channel PostsEARL F ANDERSEN INC0000517511282609/15/2023 4,750.00 Camp InstructorECOELSA LLC0002830511282709/15/2023 765.00 Aug 2023 Fitness InstructorELEANOR ALLEN0002806011282809/15/2023 428.89 Ladder L-9280 BrontoEMERGENCY APPARATUS MAINT0000547511282909/15/2023 428.89 Engine 1 Repairs 857.78 14.40 UB refund for account: 20250800ESTATE OF KELLY BROOKSREFUND-UB11283009/15/2023 8.51 UB refund for account: 20023988ETERNITY HOMESREFUND-UB11283109/15/2023 1,895.00 Concrete Raising - Well House 8 & 9EXPERT CONCRETE RAISING 0002823711283209/15/2023 17,500.00 Water MetersFERGUSON WATERWORKS #25160000623111283309/15/2023 585.50 Water Meters 597.49 Pump 18,682.99 17.87 UB refund for account: 40632604GAFFNEY MIKEREFUND-UB11283409/15/2023 142.39 UB refund for account: 30008901GELHAR MIKEREFUND-UB11283509/15/2023 574.00 SCADA Control Repairs - WTFHAYES ELECTRIC INC0000831511283609/15/2023 674.14 Light Failure - Ponds Football 3,038.00 Emergency Exit & Egress Lighting - WTF 4,286.14 150.00 Landscape BouldersHERMAN'S LANDSCAPE SUPPLIES0000861711283709/15/2023 32.50 Program RefundJAIME DAHMESREFUND-REC11283809/15/2023 750.00 Aug 2023 Line Dance InstructorJANE BREEGGEMANN0002788611283909/15/2023 16.25 Program RefundJENNIFER DAGG BECKERREFUND-REC11284009/15/2023 450.00 Aug 2023 Zumba InstuctorJENNIFER MARTH0002812311284109/15/2023 142.50 Lawn Mowing - 4528 Colorado StreetJLS LAWN MAINTENANCE & SNOW REMOVAL0002839311284209/15/2023 173.11 UB refund for account: 10254902JOHNSON TIMREFUND-UB11284309/15/2023 33.75 UB refund for account: 10556200JONES GLORIA JREFUND-UB11284409/15/2023 32.50 Program RefundKATIE ENGSTROMREFUND-REC11284509/15/2023 32.50 Program RefundKATRINA BENNETTREFUND-REC11284609/15/2023 39.06 UB refund for account: 20486200KELLEY CATHYREFUND-UB11284709/15/2023 16.25 Program RefundKELLIE GHARWALREFUND-REC11284809/15/2023 391.79 UB refund for account: 20814303KELLY WOLTERREFUND-UB11284909/15/2023 5.89 UB refund for account: 30017105KINDSETH ELKANAHREFUND-UB11285009/15/2023 780.00 Neutralizer Media Replacement - MC, FS1,KLAMM MECHANICAL CONTRACTORS INC0002690411285109/15/2023 853.00 Condensor Motor Replacement - Well 6 9,147.00 Chiller Repair - CH 275.00 VFD Room Cooling Unit Repair - WTF 11,055.00 156.79 UB refund for account: 10051000KLUGHERZ JIM & JANELLREFUND-UB11285209/15/2023 405.49 UB refund for account: 40656602KONIAR SCOTTREFUND-UB11285309/15/2023 CHECK REGISTER FOR CITY OF PRIOR LAKE 3/9Page: 09/22/2023 10:23 AM User: mfonder DB: Prior Lake CHECK DATE FROM 09/09/2023 - 09/22/2023 AmountDescriptionVendor NameVendorCheckCheck Date 16.25 Program RefundKRIS SCHANDELMEIERREFUND-REC11285409/15/2023 7,570.00 Water Service Repair - 16535 Anna Trl SEKRUEGER EXCAVATING0001182811285509/15/2023 5,925.50 Water Service Riser Replacement - 3122 S 13,495.50 16.25 Program RefundLAURA BURKARTREFUND-REC11285609/15/2023 47.08 UB refund for account: 10658808MALLMANN JOANREFUND-UB11285709/15/2023 211.49 UB refund for account: 40751501MCCONNELL DEBRAREFUND-UB11285809/15/2023 16.25 Program RefundMEGAN COSTELLOREFUND-REC11285909/15/2023 16.25 Program RefundMEGAN DONLEYREFUND-REC11286009/15/2023 12,300.75 Aug 2023 SAC ChargesMETROPOLITAN COUNCIL-SAC0001340611286109/15/2023 160.00 2023 Water ExamsMN DEPT OF HEALTH0001361811286209/15/2023 390.00 Wolf - 2023 Wastewater TrainingMN POLLUTION CONTROL AGCY0001385011286309/15/2023 130.00 Stephes - Pump Workshop 520.00 1,200.00 Expo RegistrationMN RURAL WATER ASSOC0001367411286409/15/2023 1,325.00 2023 Water Refresher Course 2,525.00 196.18 UB refund for account: 10743002MN VALLEY REALTYREFUND-UB11286509/15/2023 71.00 Bullard RepairMUNICIPAL EMERGENCY SERVICES0001389711286609/15/2023 50.95 Aug 2023 Repair Parts - FDNAPA AUTO PARTS0001406011286709/15/2023 16.25 Program RefundNATALIE HALLORANREFUND-REC11286809/15/2023 825.00 Contract RenewalNORTHLAND BUSINESS SYSTEMS INC0001476011286909/15/2023 302.09 UB refund for account: 10448400PAUNA KRIS & KATHLEENREFUND-UB11287009/15/2023 23.94 UB refund for account: 40023833PEDERSON BRYCEREFUND-UB11287109/15/2023 533.60 UB refund for account: 20769901PETERS JOHN & TRICIAREFUND-UB11287209/15/2023 247.75 UB refund for account: 10131000PETRICH DALEREFUND-UB11287309/15/2023 1,574.00 Vinyl Binder LiftPHASE INTL0002844611287409/15/2023 50.74 UB refund for account: 40861001PRASAD DATTAREFUND-UB11287509/15/2023 3,744.00 Pickleball LessonsPRIOR LAKE PICKLEBALL CLUB0002821911287609/15/2023 5,950.79 CP 15 AnniversaryPROFESSIONAL FOOD SERVICE0002740711287709/15/2023 385.00 Rec ProgramREPTILE & AMPHIBIAN DISCOVERY ZOO0002691611287809/15/2023 2,320.50 Baseball, Soccer CampsREVOLUTIONARY SPORTS LLC0002785511287909/15/2023 16.25 Program RefundRICARDO VARGASREFUND-REC11288009/15/2023 400.00 CP SpeakerRICHARD JONCKOWSKI0002844911288109/15/2023 29.38 UB refund for account: 30341700ROOK JANETREFUND-UB11288209/15/2023 862.56 Aug 2023 Misc SuppliesSAM'S CLUB0001903611288309/15/2023 395.91 UB refund for account: 40692601SEMM CLINTONREFUND-UB11288409/15/2023 525.00 CP 15th AnniversarySHAMROCK GROUP0002844811288509/15/2023 437.50 Chalkfest ChalkSHAWN MCCANN0002786611288609/15/2023 16.25 Program RefundSHELBY GJELHAUGREFUND-REC11288709/15/2023 220.40 Paint - FSSHERWIN-WILLIAMS CO0001945611288809/15/2023 23.18 Adobe LicenseSHI INTERNATIONAL CORP0002797511288909/15/2023 355.42 UB refund for account: 40839701SLATES MICHAELREFUND-UB11289009/15/2023 230.08 UB refund for account: 30852901SLAUGHTER ROBYNREFUND-UB11289109/15/2023 78,931.70 Aug 2023 Water PurchasesSMSC0001938411289209/15/2023 157.34 UB refund for account: 20751103SPODEN NICHOLASREFUND-UB11289309/15/2023 16.25 Program RefundSTEPHANIE & GREG JANASKOREFUND-REC11289409/15/2023 16.25 Program RefundSTEPHANIE HULTINGREFUND-REC11289509/15/2023 1,740.92 Rifle SightSTREICHERS0001990011289609/15/2023 12.99 Embroidery/Alterations 159.98 Duty Hats 1,037.07 Heard - Initial Uniform CHECK REGISTER FOR CITY OF PRIOR LAKE 4/9Page: 09/22/2023 10:23 AM User: mfonder DB: Prior Lake CHECK DATE FROM 09/09/2023 - 09/22/2023 AmountDescriptionVendor NameVendorCheckCheck Date 905.10 Elasky - Initial Uniform 357.97 Uniform Pants and Shirt 265.00 Blanks 4,479.03 1,017.80 UB refund for account: 30897401THANNIKAPPURATHOOT EASONREFUND-UB11289709/15/2023 1,016.50 Pump AssemblyTRAQNOLOGY NORTH AMERICA0002844211289809/15/2023 38.81 UB refund for account: 10634601TROY GEORGE/NANCYREFUND-UB11289909/15/2023 2,325.00 Truck Vault - 1 DrawerTRUCKVAULT0002843811290009/15/2023 325.00 Aug 2023 Clear Law Enforcement PlusWEST PAYMENT CENTER0002342011290109/15/2023 104.50 UB refund for account: 10161000WOLF JAMES FREFUND-UB11290209/15/2023 391.79 UB refund for account: 20814303WOLTER DAVIDREFUND-UB11290309/15/2023 171.36 2023 Dental ClaimsDELTA DENTAL0002721310367(E)09/18/2023 297.26 Aug 2023 Fuel TaxMN DEPT OF REVENUE0001361210368(E)09/18/2023 7,597.00 Aug 2023 Sales Tax 7,894.26 62.00 Aug 2023 COBRA Admin FeesALERUS0000137510369(E)09/20/2023 1,264.68 Aug 2023 Admin FeesDELTA DENTAL0002721310395(E)09/21/2023 1,716.26 Sep 2023 Phone BillsNUVERA0001930410396(E)09/21/2023 175.00 472 Street Sweeper - Tow for RepairsALLEN'S SERVICE INC0000136010370(A)09/22/2023 4,408.60 Vactor and 459 TiresBAUER BUILT INC0000214510371(A)09/22/2023 790.40 546 Tires 5,199.00 2,000.00 4795 Rutledge St SE - Remove 4 AshCOLLINS TREE 0000367010372(A)09/22/2023 2,617.00 Sep 2023 Office 365COMPUTER INTEGRATION TECH0000376010373(A)09/22/2023 1,536.00 Oct 2023 CIT Managed Backup 4,153.00 115.00 MIleageDANIEL MEGER0001332410374(A)09/22/2023 3,052.00 Lift Station PartsELECTRIC PUMP0002312010375(A)09/22/2023 14.25 Cable TiesFASTENAL COMPANY0000614010376(A)09/22/2023 7,515.13 Water Treatment ChemicalsHAWKINS INC0000831210377(A)09/22/2023 180.00 MileageHEIDI SIMON0002818310378(A)09/22/2023 41.37 KeyboardINNOVATIVE OFFICE SOLUTIONS LLC0002714910379(A)09/22/2023 119.10 Heard, Elasky - Business Cards 160.47 150.00 Safety Boots 2023JEREMY COY0000391710380(A)09/22/2023 320.00 Aug 2023 PD Counseling ServicesLEAST SERVICES/COUNSELING LLC0002761310381(A)09/22/2023 834.05 784 Hose reel roller parts MACQUEEN EQUIPMENT INC0001305410382(A)09/22/2023 690.43 472 Lift arm assembly (584.52)472 Steering parts return 939.96 2,093.50 Aug 2023 Labor & EmploymentNILAN JOHNSON LEWIS0000812310383(A)09/22/2023 126.25 549 Step repair NOVAK COMPANIES0001490010384(A)09/22/2023 185.00 482 Trailer deck plate 311.25 171.14 RockPENTAGON MATERIALS INC0002742610385(A)09/22/2023 CHECK REGISTER FOR CITY OF PRIOR LAKE 5/9Page: 09/22/2023 10:23 AM User: mfonder DB: Prior Lake CHECK DATE FROM 09/09/2023 - 09/22/2023 AmountDescriptionVendor NameVendorCheckCheck Date 28.65 Warning Light Mounting PadRIGID HITCH INC0001847510386(A)09/22/2023 182.25 Pintle Hook 177.44 544 Hitch (182.25)Pintle Hook 206.09 54,694.66 Trail MaintenanceSCOTT COUNTY0001921210387(A)09/22/2023 150.00 Safety Boots 2023STEVEN KVAM0002794210388(A)09/22/2023 406.81 Communication CableTERMINAL SUPPLY COMPANY0002027010389(A)09/22/2023 12.67 Cast Iron CoverVIKING ELECTRIC SUPPLY0002263010390(A)09/22/2023 154.20 Emergency Lights 51.40 Emergency Lights 290.28 Emergency Lights 205.60 Emergency Lights 102.80 Emergency Lights 664.54 Parts 1,481.49 321.60 AsphaltWM MUELLER & SONS INC0002364510391(A)09/22/2023 289.23 Asphalt 1,348.79 Asphalt 1,959.62 298.10 R8544 A/C Repair WOLF MOTOR CO INC0002367510392(A)09/22/2023 8,993.86 Fuel island fill tube repair ZAHL-PETROLEUM MAINTENANCE CO0002612510393(A)09/22/2023 5.72 502FM Mower parts ZIEGLER INC0002650010394(A)09/22/2023 108.32 502 Cab door seal and mirror 297.58 502FM Mower parts 110.00 Couplings 156.85 502FM Mower parts 830.22 City Hall Generator Cooling System Flush 1,508.69 550.00 Appraisal - 4556 Colorado Street SEANNONI APPRAISALS LLC0002845211290409/22/2023 7,087.17 SCADA System EvaluationBARR ENGINEERING CO0000211311290509/22/2023 676.92 Aug 2023 Lawn Care - City HallBIRD'S LAWN CARE0002816411290609/22/2023 979.26 Aug 2023 Lawn Care - FS1&2 1,125.54 Aug 2023 Lawn Care - MC 328.49 Aug 2023 Lawn Care - Lib/Club Prior 1,125.54 Aug 2023 Lawn Care - WTF 676.92 Aug 2023 Lawn Care - PD 4,912.67 114.02 FS2 1st Aid SuppliesCINTAS CORPORATION0000350611290709/22/2023 92.80 Club Prior 1st Aid Supplies 101.95 FS1 1st Aid Supplies 66.41 Lakefront Pavilion 1st Aid Supplies 58.84 PD 1st Aid Supplies 157.64 Mtce Center 1st Aid Supplies 591.66 139,884.81 8503 John Deere 4066 Tractor Mower, SnowDEERE & COMPANY0001049611290809/22/2023 4,760.00 No Parking - TrailersEARL F ANDERSEN INC0000517511290909/22/2023 CHECK REGISTER FOR CITY OF PRIOR LAKE 6/9Page: 09/22/2023 10:23 AM User: mfonder DB: Prior Lake CHECK DATE FROM 09/09/2023 - 09/22/2023 AmountDescriptionVendor NameVendorCheckCheck Date 1,705.00 Blank Signs 6,465.00 2,500.00 22-0126 3449 Turner Drive SWETERNITY HOMESMISC-CD11291009/22/2023 2,250.00 Water MetersFERGUSON WATERWORKS #25160000623111291109/22/2023 2,839.81 Water Meters 471.71 Water Meters 5,561.52 540.00 FusesGRAINGER INC0002303011291209/22/2023 229.23 Cable Ties (57.34)Countersink Tool 711.89 170.00 Fountain Hills LandscapeHERMAN'S LANDSCAPE SUPPLIES0000861711291309/22/2023 170.00 Fountain Hills Landscape 170.00 Fountain Hills Landscape 170.00 Fountain Hills Landscape 680.00 90.00 Shelter Reservation RefundJEFF SHEFFIELDREFUND-REC11291409/22/2023 4,285.05 CSAH 21/Revere KIMLEY-HORN & ASSOCIATES INC0001137211291509/22/2023 34.55 CountersinkMCMASTER-CARR0002840511291609/22/2023 280.50 PartsMENARDS LUMBER CO0001331811291709/22/2023 193.98 Vacuum 542.21 Utility Cart & Supplies 125.84 Pavilion Mop & Tools 519.94 Deck Boards & Screws 55.92 Roof Leak Repair - CH 1,718.39 2,664.39 Concrete Plant InspectionsMN DEPT OF TRANSPORTATION0001382611291809/22/2023 5,000.00 23-1599 16489 Franklin Trl SEMN PAVERS, LLCMISC-CD11291909/22/2023 260.00 Pump Workshop- Doerr & TheisMN POLLUTION CONTROL AGCY0001385011292009/22/2023 55.00 Buhler - Wastewater Cert Exam 55.00 Spinler - Wastewater Cert Exam 55.00 Theis - Wastewater Cert Exam 55.00 Yungbauer - Wastewater Cert Exam 1,560.00 2023 Wastewater Training 2,040.00 19.92 LumberMONNENS SUPPLY INC0001390911292109/22/2023 2,328.04 Fuse & LampsMUSCO SPORTS LIGHTING LLC0001398911292209/22/2023 1,035.24 Aug 2023 Repair PartsNAPA AUTO PARTS0001406011292309/22/2023 2,250.00 Long Term Financial PlanningNORTHLAND SECURITIES INC0001477511292409/22/2023 68.25 Aug 2023 Interpreter ServicesOFFICE OF MN IT SERVICES0000439611292509/22/2023 110.00 Hart - Annual DuesOPTIMIST CLUB0001575011292609/22/2023 42.73 Misc ReimbursementsPETTY CASH0001630011292709/22/2023 2,334.81 Drawstring Backpacks - Nite toUnitePOSITIVE PROMOTIONS0001646511292809/22/2023 1,405.00 Raise Manhole - Northwood RdPRIOR LAKE BLACKTOP0001661011292909/22/2023 799.20 Rentals - CP 15th AnniversaryPRIOR LAKE RENTAL CENTER0001670011293009/22/2023 35.00 Propane 834.20 CHECK REGISTER FOR CITY OF PRIOR LAKE 7/9Page: 09/22/2023 10:23 AM User: mfonder DB: Prior Lake CHECK DATE FROM 09/09/2023 - 09/22/2023 AmountDescriptionVendor NameVendorCheckCheck Date 1,072.65 UB refund for account: 90024093SHERBURNE SLATERREFUND-UB11293109/22/2023 192.93 Garage Door Paint - PDSHERWIN-WILLIAMS CO0001945611293209/22/2023 88.32 Aug 2023 Legal NoticesSOUTHWEST NEWS MEDIA0001967611293309/22/2023 35,595.00 Ballistic Plates/HarnessesSTREICHERS0001990011293409/22/2023 577.90 Uniforms 68.99 Uniform 36,241.89 531.00 465 Tarp arm TOWMASTER0002065911293509/22/2023 241.42 465 Liquid Tank Connector 772.42 221.99 Balloons - FF Oath & ReceptionUS BANK0000210511293609/22/2023 2.57 Key 59.26 Gun Cleaning Supplies 92.16 Gun Cleaning Supplies 336.60 Holsters 200.00 Wedel - Confrence Registration 42.43 Meeting with AB, JW 68.29 KB, KC, JW Agenda Review 37.24 Dept Meeting - CM,JW 10.80 SCALE Service Delivery meeting 55.52 Shipping - Return 87.21 Fire Hose Nozzles 78.85 Air Freshners, Grease Gun, Relays 176.97 Spare Tire for holder Unit#513 31.48 Line Striper Strainers 23.98 Steering Wheel Cover 60.04 Post Pounder Rebuild Kit 434.22 Post Pounder Parts 384.79 Spraying Wand 250.00 Council Membership Dues 424.78 Bronze Plaque - Middle School Mural 10.19 FT FF Swearing In Reception 86.00 FT FF Swearing In Reception 60.50 Cookies - Employee Appreciation Lunch 31.73 Lunch - HR meeting w/Savage & Shakopee 54.99 Badge Supplies 26.10 Firefighter Reception Supplies 441.00 Jul 2023 Background Checks 302.50 Aug 2023 Background Checks 445.00 Duggan - Conference Registration 725.00 Lannon - Leadership Academy 1,558.40 Rifle Armor ID Panels 166.76 Drill Bits, Safety Headsets 1,920.00 Yard Markers 4.93 Greeting Card 150.00 Theis - Expo Registration 232.74 Electrolyte Drink Packets 190.00 Pesticide Recertification 105.82 Misc Supplies 35.50 Hard Candy - Front Desk 302.62 Misc Supplies 50.78 Water Filters 138.00 Battery Packs 80.00 Glue Sealant 68.55 Milwaukee Drill Bit/Driver Combo Set CHECK REGISTER FOR CITY OF PRIOR LAKE 8/9Page: 09/22/2023 10:23 AM User: mfonder DB: Prior Lake CHECK DATE FROM 09/09/2023 - 09/22/2023 AmountDescriptionVendor NameVendorCheckCheck Date 160.00 Milwaukee Ratchet 159.26 Backflow Preventers for WTF hose bib 1,285.70 Leveloggers 780.93 Bulbs 509.82 Bulbs 249.70 LED Bulbs 453.78 Plastic sheets - sump basket covers at W 109.41 PW Seasonal Staff Holiday cards 99.99 Boots DH51 125.95 Rain Pants 39.75 Training Dummy Rounds 64.02 SRT Med Bags & Wipes 91.53 SRT Gloves, Replacement Batteries 55.45 SRT Inner Belt TB60 250.00 Glock Armorer Training 699.00 Patrol Rifle Instructor Course 138.00 Shooting Targets 274.25 SRT Boots 130.00 Boots 250.00 Klekner - Conference Registration 135.00 Annual GAAP Update 80.76 Finance Dept Lunch 180.65 Finance Dept Lunch 172.00 City Council Worksession 100.00 IBRIS Training 84.99 Cake - Mager Farewell 21.96 Cake, Ice - Norcia Swearing In 96.63 Refrigerator 63.73 Shredder 21.99 Polo Shirt 71.24 Coffee 39.33 Name Plate 12.86 Wasp Spray 0.99 50GB iCloud Storage 368.28 Daytrippers - Family Aquatic Center 11.98 Ice - Meat & Greet 7.83 Camp Supplies 34.17 Chalkfest Supplies 47.94 Spray Chalk 381.68 Camp Ice Packs and Chalkfest Supplies 58.44 Chalkfest Supplies 362.07 Chalkfest Signs 14.21 Chalkfest ribbon stencil 14.98 ShipREC'd Camp Shirts 4.00 Parking 79.05 ShipREC'd Camp Supplies 610.81 Chalkfest prizes 16.11 ShipREC'd Camp Prizes 754.99 8/17 Trip 74.38 Art Contest Paint 583.54 8/14/2023 Trip Remaining Balance 98.65 Lakefront Park Summer Camp Storage 101.50 Extra Clothes for Rec Programs 141.33 Dinner - CP Speaker 15.98 CP 15th Anniversary 175.00 CP 15th Anniversary 425.20 CP 15th Anniversary 237.15 Meat & Greet Supplies 20.00 Roach - Cybersecurity Loss Control 31.47 APC Replacement Battery CHECK REGISTER FOR CITY OF PRIOR LAKE 9/9Page: 09/22/2023 10:23 AM User: mfonder DB: Prior Lake CHECK DATE FROM 09/09/2023 - 09/22/2023 AmountDescriptionVendor NameVendorCheckCheck Date 33.16 Domain Renewal 525.00 7 Firefighter Licenses 22.25 Misc Office Supplies 193.29 Misc Supplies 23.75 Non-oxy Fuel (335.63)Inventory & Deploy Software - Gov't Disc (18.99)Returned Bungee Cord - Event Sign (65.97)Return - Staff Shirts - NTU 22,322.56 1 TOTALS: 715,766.88 Total of 183 Disbursements: 0.00 Less 0 Void Checks: 715,766.88 Total of 183 Checks: City of Prior Lake Treasurers Report August 2023 Fund 8/1/2023 8/31/2023 Fund Type & Name No. Balance Receipts Disbursements Balance Business-Type Funds Water Fund 601 6,167,508.43$ 1,769,173.94$ 331,702.73$ 7,604,979.64$ Sewer Fund 604 3,836,957.53 831,048.26 258,459.76 4,409,546.03 Water Quality Fund 602 2,578,768.49 229,739.63 43,437.89 2,765,070.23 Total Business-Type Funds 12,583,234.45$ 2,829,961.83$ 633,600.38$ 14,779,595.90$ Governmental-Type Funds General Fund 101 12,149,253.75$ 702,026.64$ 1,446,891.16$ 11,404,389.23$ Special Revenue Funds Cable Franchise Fund 210 97,179.46$ 274.76$ -$ 97,454.22$ Capital Park Fund 225 1,758,969.95 9,223.77 4,036.44 1,764,157.28 Police Forfeiture Fund 235 141,808.53 400.94 - 142,209.47 EDA Special Revenue 240 407,344.85 5,230.24 10,980.04 401,595.05 Econ Dev Federal Revolving Loan Fund 250 138,168.79 390.65 - 138,559.44 Developer Agreement Fund 260 1,051,808.79 - 8,953.67 1,042,855.12 Total Special Revenue Funds 3,595,280.37$ 15,520.36$ 23,970.15$ 3,586,830.58$ Capital Project Funds TIF #1-3 413 140,523.01$ 397.30$ -$ 140,920.31$ TIF #5-1 416 11,916.07 33.69 - 11,949.76 TIF #6-1 417 535,318.39 1,513.52 - 536,831.91 TIF #1-5 419 50,749.80 143.49 - 50,893.29 Revolving Equipment Fund 410 969,169.11 2,594.01 51,687.02 920,076.10 Revolving Park Equipment Fund 430 1,766,476.67 4,986.88 2,656.11 1,768,807.44 Facilities Management Fund 440 1,463,123.65 4,094.45 14,950.00 1,452,268.10 Permanent Impr Revolving Fund 450 1,781,063.97 5,014.98 7,237.85 1,778,841.10 Construction Fund 501 8,184,418.29 2,552,837.72 2,872,721.09 7,864,534.92 Trunk Reserve Fund 502 5,922,259.09 27,123.37 - 5,949,382.46 Street Oversize Fund 503 372,004.32 1,051.77 - 373,056.09 Total Capital Project Funds 21,197,022.37$ 2,599,791.18$ 2,949,252.07$ 20,847,561.48$ Debt Service Funds 351 & 549- 576 $ 4,151,549.01 18,012.20$ -$ 4,169,561.21$ Agency Fund 801 567,337.50$ 48,850.00$ 37,112.50$ 579,075.00$ Total Governmental Type Funds 41,660,443.00$ 3,384,200.38$ 4,457,225.88$ 40,587,417.50$ Internal Service Funds 7xx 636,860.54$ 5,796.42$ -$ 642,656.96$ Total All Funds 54,880,537.99$ 6,219,958.63$ 5,090,826.26$ 56,009,670.36$ Investment Pool & Ratio as of 8/31/2023 92.29% 51,691,005.86$ 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. Federal ARPA Fiscal Recovery Fund – Special revenue fund created to track American Rescue Plan Act funds received by the City. 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 August 2023 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; Federal ARPA Recovery Funds Restricted for equipment and improvements Contractually obligated Capital Project Funds TIF #1-3 Restricted for tax increment Contractually obligated by tax increment agreements TIF #1-5 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 9/07/2023 DebtBook Quote City of Prior Lake, MN (EOSXE 7X 7) 4VMSV 0EOI 12 3727 Cathy Erickson *MRERGI (MVIGXSV GIVMGOWSR$TVMSVPEOIQRKS Z 92 79 2 Prepared By: (IFX&SSO %HEQ *IOMRM 'YWXSQIV 7YGGIWW 1EREKIV EHEQJ IOMRM$HIFXFSSOGSQ Notice Address: 43 &S \ 790 'LEVPSXXI 2' 2 2 Products & Services Description Qty Annual Fee Discount Total -QTPIQIRXEXMSR 'LEVKI 8MIV 2 8LMW VITVIWIRXW XLI GSWX SJ SYV 4VIQMYQ +%7&9 -QTPIQIRXEXMSR TVSGIWW JSV ]SYV SVKERM^EXMSR 7YFWGVMTXMSR 'LEVKI 8MIV 2 8LMW VITVIWIRXW XLI ERRYEP WYFWGVMTXMSR GLEVKI ]SYV SVKERM^EXMSR TE]W JSV EGGIWW XS XLI (IFX&SSO TPEXJSVQ 8LIVI EVI RS EHHMXMSREP GLEVKIW XLMW GSZIVW YRPMQMXIH YWIVW I\XIVREP WLEVMRK WYTTSVX ERH XVEMRMRK 2000 =IEV 3000 =IEV 2000 3000 0 =IEV 'SWX 0000 =IEV 'SWX 7YFWGVMTXMSR 'LEVKI 8MIV 2 8LMW VITVIWIRXW XLI ERRYEP WYFWGVMTXMSR GLEVKI ]SYV SVKERM^EXMSR TE]W JSV EGGIWW XS XLI (IFX&SSO TPEXJSVQ 8LIVI EVI RS EHHMXMSREP GLEVKIW XLMW GSZIVW YRPMQMXIH YWIVW I\XIVREP WLEVMRK WYTTSVX ERH XVEMRMRK 7YFWGVMTXMSR 'LEVKI 8MIV 2 8LMW VITVIWIRXW XLI ERRYEP WYFWGVMTXMSR GLEVKI ]SYV SVKERM^EXMSR TE]W JSV EGGIWW XS XLI (IFX&SSO TPEXJSVQ 8LIVI EVI RS EHHMXMSREP GLEVKIW XLMW GSZIVW YRPMQMXIH YWIVW I\XIVREP WLEVMRK WYTTSVX ERH XVEMRMRK 3000 =IEV 2 3000 =IEV 3 2000 000 000 =IEV 2 'SWX 2000 =IEV 3 'SWX Total 3 Year Renewal Cost: $33,000 1 City Project:A1123-000001 AT&T Site ID:10081745 SECOND AMENDMENT TO COMMUNICATION FACILITIES LEASE AGREEMENT This Second Amendment to Communication Facilities Lease Agreement (“Second Amendment”) is made and entered into this _______ day of ________________,2023 (“Effective Date”),by and between the City of Prior Lake,a Minnesota municipal corporation (hereinafter referred to as the “City”) and New Cingular Wireless PCS,LLC,a Delaware limited liability company (hereinafter referred to as “Communications Company”). RECITALS WHEREAS,the City and Communications Company entered into that certain Communication Facilities Lease Agreement dated May 1,2022 (“Original Agreement”)for space on the City’s Cedarwood Street Water Tower (“Water Tower”)and space adjacent to the Water Tower on City’s Property located at 5560 Cedarwood Street NE,Prior Lake,MN 55372 (“Property”)for the purpose of constructing, installing,removing,replacing,maintaining,and operating Antennae and Equipment,as defined in the Original Agreement;and WHEREAS,Communications Company modified and/or upgraded Communications Company’s Antennae and or Equipment pursuant to First Amendment to Communication Facilities Lease Agreement dated August 21,2023 (“Amendment 1”)(The Original Agreement and Amendment 1 are hereinafter jointly referred to as the “Agreement”);and WHEREAS,the City and Communications Company hereby seek to amend the terms of the Agreement to temporarily allow the use of unpermitted equipment. NOW,THEREFORE,in consideration of the foregoing recitals and for other good,valuable and fair consideration,the receipt and sufficiency of which is hereby acknowledged the parties agree as follows: 1.Consent of City.The City hereby consents to the Communications Company’s proposed temporary modification of the Communications Company’s Antennae and Equipment on the Water Tower pursuant the terms of the Second Amendment. 2.Definitions.All terms defined in the Agreement shall have the same definitions when used in this Second Amendment. 3.Permitted Equipment.The City hereby grants Communications Company the right and consents to Communications Company temporarily mounting the equipment depicted on Exhibit B-2 herein.Communications Company must provide a letter signed by a licensed Professional Engineer stating that the additional temporary equipment willl not impact the structural integrity of the Water Tower or the Communications Company’s mountings. 4.Term Length.The City hereby grants Communications Company the right and consents to Communications Company temporarily mounting the equipment depicted on Exhibit B-2 for a period not to exceed one (1)year from the Effective Date of the Second Amendment. 5.Fees and Expenses.Communications Company shall pay all of the City’s costs and expenses relating to Communications Company’s installation of the temporary equipment,as shown in 1 227735’I City Project:A1123-000001 AT&T Site ID:10081745 Exhibit B-2,or revised plans,if applicable,including all fees of City’s structural engineer and/or City’s Attorney. 6.Rent Increase.As additional consideration for the additional temporary equipment and other rights set forth in this Amendment,from the Effective Date to the removal and inspection of the temporary equipment,for each month the temporary equipment is mounted on the Water Tower,there will be a tee of tour hundred ($400)dollars.Partial months not to be prorated. Payment shall be due and payable within ninety (90)days after the notice of final inspection completion. 7.Terms and Conditions of Lease.All other terms,covenants,and conditions of the Agreement remain in full force and effect except as modified by this Second Amendment.rhe recitals set forth above are incorporated herein and made a part hereof as if they were set forth in the body hereof. 2 227735’I City Project:A1123-000001 AT&T Site ID:10081745 IN WITNESS HEREOF,the parties have executed this First Amendment as of the date first written above. CITY OF PRIOR LAKE Kirt Briggs,Mayor Jason Wedel,City Manager COMMUNICATIONS COMPANY: New Cingular Wireless PCS,LLC, a Delaware limited liability company By:,4z..ctr-f4..J Sac(c r--eC4-.er-- Its:JJt-1-t{JprL 2•r4 cAor 3 227735v1 City Project:A1123-000001 AT&T Site ID:10081745 EXHIBIT 8-2 (attached hereto) 4 227735 I Cambium Networks’TM Temporary microwave installation to be mounted to existing antenna frame/pipe. SE alpha sector on this tank (135 deg)with a 1cabled connection to AT&T’s shelter 60 GHz cnWave V3000 High-Gain Client Node -QUICK LOOK: •Supports 57 to 66 GHz •Up to 3.6 Gbps (1.8 Gbps DL and 1.8 Gbps UL).Channel bonding typically doubles capacity •Easy installation with auto beamforming •Low latency <1 ms •802,llay technology with Terragraph certification terragraph certified DESIGNED FOR LONG-RANGE,HIGH-CAPACITY AND HIGH-DENSITY DEPLOYMENTS Carnbium Networks’60 GHz cnWave solution provides easy, fast and cost-effective wireless gigabit connectivity for edge access and/or high-capacity backhaul for edge access sotutons at a significantly lowe TCO than fiber infrastructure Service provide’s and enterorises now have access to gigabit for busness and residential connectivily,backbaul for Wi-El access or LTE/5G srnal cell.Certified for Facebook Terragraph,cnWave solutions are highly efficient at handling high-density deployments in cities and suburban areas. V3000 is featured with a 44,5 dRi or 40.5 dBi high-gain antenna with beamforming.The Client Node (CN)can be used as ether a client in ?.VP configurations or an erd-ooirt in PTP configurations. CLOUD AND ON-PREMISES MANAGEMENT 60 GHz cnWave operates wtih Cambium Networks’ cnMaestrc management system.cnVaestro’is a cloudbased or on-premises software platform for secure,end-to-end network control.cnMaesfro wireless netwo’k manager simplifies device managemeni by offering fuN network visibility and zero-touch provisioning.View and perform a full suite of wireless network management functions in real time. Optimize system availability,maximize throughput and meet emerging needs of business and residential customers. cam biu m networks.com - -READV—” ©2021 cembum Networks.inc. Specifications 60 GHz cnWave V3000 Client Node Spectrum Performance Frequency 57 to 66 CHz in a single SKU Modulation &MCS-0 (BPSK)to MCS-12 (16-DAM)Range Coding Schemes Channel Width 2.16 GHz,4.32 GHZ* Latency <1 ms Carrier Bonding Up to 2 adjacent channels 6U5 dBm (with 44.5 dBi Antenna)Maximum EIRP 54.5 dsm (with 40.5 dRi Antenna)Mode of PMP Client or PTPOperation Antenna Interface Channel Access TDMAJTDD Ethernet 1 x 10011000/lOG BaseT with PoE In, Interface 1 x 100/1000 BaseT with 802.Sat PoE Out. 1 x SFP+1G and lOG Networking Gain 44.5 dBi or 40.5 dBi Type Integrated Beamforming +1-2°azimuth,t/.1°elevatonScanRange Beam Width 0.8° Powering ___________________________ Protocols lPv4,IPv6.Layer2 Bridge,Layer3 lPvG _________________________________________________ Supported Routing,Open/R mesh Passive PoE (42-57V)without AUX PoE OulTypeNetworkInusecnMaestro.HTTR HTTPS,SNMP v2c &v3Management Power 60W with AUX PoE Out in use, Consumption 30 W without AUX PoE Out in useMTU4,000 bytes VLAN*8021ad (QinO),80210 with 802.ip priority Physical QoS 4 Level DoS,DSCP and VLAN Tag Environmental 1P66/67 ____________________________________________________________ Temperature -40°C to 60°C (-40°F to 140°F) Security Mean Time Encryption 128-bit AES Between Failure >40 years Firmware Weight vaooo with 44.5 dBi dish security Sgred Firmware Images 47kg (10.3 lbs.)without clamp V3000 with 40.5 dBi dish 39kg (8.6 lbs.)wilhout clamp Dimensions V3000 with 44.5dBi dish H x W x D 421 x 347 x 349 mm (16.57 x 13.66 x 13.7 in V3000 with 40.SdBi dish 343 x 198 x 251 mm (13.5 x 18 x 9.9 in) Wind Survival 200 km/h (124 mi/h) Available in future release 2O21 canibiun rJcr.vrnks.nc.2 cambiumnetworks.com rzc ‘I ., nj!. -a 11111011 Cambium Networks DATA SHEET 60 GHz cnWave V3000 Client Node V3000 with 44.5 dBi Antenna C. 13 V3000 with 40.5 dBi Antenna L ©-2021 Cambium Networks Inc 3 cam bi urn networks.corn mbium Networks DATA SHEET 60 GHz cnWave V3000 Client Node Ordering Information C600500C024A 60GHz cnWave V3000 Client Node Radio Only C600500C025A 60GHz cnWave V3000 Client Node Radio Only -Israel Only C600SOODOD2A 60GHz cnWave V3000 Client Node Antenna Assembly,40,5 dEl,4 Pack C6005000003A 60 GHz cnwave V3000 Client Node Antenna Assembly,44.5 d6i,4 Pack N000045L002A Tilt Bracket Assembly C000000L125A cnWave Precision Mounting Bracket NOTE Power Supply Unit must be ordered separately. ABOUT CAMBIUM NETWORKS Cambium Networks empowers millions of people with wireless connectivity worldwide.Its wireless portfolio is used by commercial and government network operators as well as broadband service pioviders to connect people,places and things.With a single network architecture spanning fixed wireless and Wi-P.Cambium Networks enables operators to achieve maximum performance with minimal spectrum.End-to-end cloud management trans’orms networks into dynamic environments ta:evolve to meet changing needs with minimal ofrysical hur’a i-1erve,9tion.Camoium Networks enpowers a grow ng ecosystem of par:ne:s who des’gn ano delver gigabit w reless sciut ons that jus:work. cambiumnetworks.com 0)2021 cambium Neteorks.inc.4 3000 Coil Road Suite 360,Roiling Meadows,illinois 60008 USA