Loading...
HomeMy WebLinkAbout_05 14 2024 City Council Agenda Packet PERSONNEL PLAN 2025-2029 2025 – 2029 Personnel Plan / Page 2 INTRODUCTION Similar to how the City plans its infrastructure and equipment needs through the Capital Improvement Plan (CIP), this personnel plan is designed to address the staffing needs required to support the anticipated demand for city services as Prior Lake grows. The general fund budget is dominated by personnel costs (70.8% of the total budget in 2024) which explains why planning for personnel is critical for long-range planning forecasts. This plan projects the anticipated staffing requirements for the City of Prior Lake through 2029. It will be revisited annually to adapt to the evolving needs and expectations of the community. The objectives of the plan include: • Informing annual and long-range budget discussions and decisions; • Forecasting future demands for service; and • Identifying the resources required to perform current service levels in the future. This five-year document will be incorporated into the city’s long-range financial plan and will be updated each year to inform the annual budget process. Departments will be responsible for providing the metrics to justify the personnel requests and impact on current service levels during annual budget deliberations. This document focuses only on the need and rationale for each position request. The discussion on how the city will pay for these positions will be held through the annual budgeting process in consideration with other budget requests like the CIP. The City Council will determine the addition and timing of any new staff additions. BACKGROUND The personnel of the City of Prior Lake provide essential services to 27,855 (2022 Met Council population estimate) residents over approximately nineteen square miles. In addition, the residents of Spring Lake Township, the City of Credit River, and the Shakopee Mdewakanton Sioux Community (SMSC) receive public safety services from the City. Prior Lake has grown at a steady pace of about five hundred residents annually in one of the fastest growing counties in Minnesota. The Metropolitan Council forecasts Prior Lake’s population will grow to 37,600 residents by 2040. Cities do not grow solely in terms of population or households as the services -- infrastructure, parks, public safety, and technology, to name a few – that are required to accommodate such growth must expand as well. These services are supported by municipal employees together with the equipment, supplies and training necessary to execute their functions. The City of Prior Lake currently operates with 118.65 employees, including the addition of 12 new full-time firefighters in 2023. The majority (76%) of employees work Public Works, Police Department, and Fire Department, most of whom are considered essential employees. The city hires around fifty seasonal and temporary positions each year and employs 25 paid on-call firefighters. 2025 – 2029 Personnel Plan / Page 3 PERSONNEL NEEDS THROUGH 2029 Below is an overview of the projected staffing needs to maintain current service levels through 2029. Community Development and Finance have added positions in the past few years and should be adequately staffed for several years. Administration and Fire have identified a couple of key positions to round out those departments’ staffing needs into the future. To address supervisory span of control, Public Works proposes an additional position in 2025. On the following pages, each department is profiled with a summary of all current and proposed positions within the department and a rationale for each new FTE request. NOTE: The Police Department is in the process of a staffing/scheduling study with an external consultant. The findings of that study should be ready later this summer. The Police Department section of this report is to be determined and will be entered upon completion of the study. *Does not include potential staffing additions for the Police Department Department 2025 2026 2027 2028 2029 Administration (8) - 1 .62 - - Community Development (10.8) - - - - - Finance (6.8) .2 - - - - Fire (14) - 1 - - - Police (39.42) TBD TBD TBD TBD TBD Public Works (39.63) 1 - - 1 .37 Total New*: 1.2 2 .62 2 .37 Total City Headcount (118.65) 2025 – 2029 Personnel Plan / Page 4 DEPARTMENT PROFILES 2025 – 2029 Personnel Plan / Page 5 ADMINISTRATION *2026: Administrative Assistant. This will be a hybrid position that will support the Fire Department, City Manager, and staff the front desk of City Hall. By 2026, the full-time Fire Department will have been functioning for two full years, including implementing a fire safety inspection program for all commercial buildings and beefing up public education. Administrative support will be required to assist with scheduling inspections, follow-up paperwork, organizing education events, etc. The City Manager requires administrative support for the scheduling, correspondence, and other executive assistance. These duties used to fall to the combination HR support/executive assistant position which transitioned to full-time HR duties in 2022. As for City Hall, we anticipate transitioning the Deputy City Clerk away from reception area duties into full-time clerk duties because of increased elections administration mandates by the State and records management needs. The Administrative Assistant will greet customers, answer phones, check mail, and conduct front desk tasks so the Deputy City Clerk can focus full- time on clerk duties. *2027: Communications Specialist/Graphic Designer (.62 FTE). With the Prior Lake American going out of business combined with continued growth of the community, additional communications support is needed to effectively reach residents. Communicating with the public is a core city service, and as a local government, we are obligated to provide timely, relevant information to our citizens to ensure transparency and accountability. The time required to create videos, social media content, news, website updates, and other content is increasing. Additional support is needed to help manage the city’s website and to create graphics for all city communications mediums. Total FTEs in 2024 – 8 Administration 2025 2026 2027 2028 2029 City Manager 1 1 1 1 1 Assistant City Manager 1 1 1 1 1 City Clerk 1 1 1 1 1 Deputy City Clerk 1 1 1 1 1 HR Coordinator 1 1 1 1 1 Communications Manager 1 1 1 1 1 Communications Specialist - - .62* .62 .62 IT Manager 1 1 1 1 1 IT Specialist 1 1 1 1 1 Admin Assistant - 1* 1 1 1 TOTAL: 8 9 9.62 9.62 9.62 2025 – 2029 Personnel Plan / Page 6 COMMUNITY DEVELOPMENT Due to the addition of new FTEs in recent years, no new personnel additions are anticipated through 2029. A seasonal Development Services Assistant position was converted to a part-time (0.8 FTE) position in 2022. The financial impact was not significant for the part-time position as the City previously paid an hourly rate for seasonal assistance and wages and benefit costs associated with this position will be covered with building permit revenues. One full-time Building Inspector position was added in 2021 which was primarily funded for two years by a Building Official Training Grant Program grant received from the Minnesota Department of Labor and Industry. This new Building Inspector position was necessary due to the increased demand for inspections, plan review, and permit issuance. In addition to plan review and assisting customers at the counter, the city issues over 2,800 building permits and conducts 6,000+ building inspections per year. It is common during the busier times of year for each inspector to have over twenty inspections on their daily calendar. Current staffing levels should meet the demand for services for the foreseeable future. Total FTEs in 2024 – 10.8 Community Development 2025 2026 2027 2028 2029 Comm Development Director 1 1 1 1 1 Building Official 1 1 1 1 1 Building Inspector 3 3 3 3 3 Code Enforcement Officer 1 1 1 1 1 Planner 2 2 2 2 2 Development Services Assistant 2.8 2.8 2.8 2.8 2.8 TOTAL: 10.8 10.8 10.8 10.8 10.8 2025 – 2029 Personnel Plan / Page 7 FINANCE *2025: Assistant Finance Director (.2 FTE). This position was budgeted at .8 FTE in 2023. The Assistant Finance Director will transition to a full- time position in 2025. Total FTEs in 2023 – 6.8 Finance 2025 2026 2027 2028 2029 Finance Director 1 1 1 1 1 Asst Finance Director 1* 1 1 1 1 Sr Financial Analyst/Sr Accountant 1 1 1 1 1 Financial Analyst 1 1 1 1 1 Account Specialist 1 1 1 1 1 Utility Billing Clerk 2 2 2 2 2 TOTAL: 7 7 7 7 7 2025 – 2029 Personnel Plan / Page 8 FIRE *2026: Fire Marshal. One of the first initiatives full-time staff focused on was building a pre-plan and inspection program. Conducting the inventory and building a database of all commercial buildings in Prior Lake will likely take two years. To date, Fire Department personnel have begun the process of pre- planning and performing life safety inspections on over fifty commercial and multifamily properties. This is a significant task that requires dedicated on-going management. The proposed Fire Marshall will hold State certification; currently, the Fire Chief is the city’s Fire Marshal, but he does not hold the certification. The Fire Marshal will manage the pre-plan and fire inspection programs for multi-family, commercial, and educational properties in the Fire Department service area and will have the authority to enforce state law, local statute, and fire code violations. The Fire Marshal will also be tasked with creating a preliminary fire investigation program to better secure evidence and site preservation of fire scenes and to lead the follow-up required by the State Fire Marshal investigator. The Fire Marshal will develop and manage a training program for firefighters related to inspections, pre-planning, and investigations. *2026: Administrative Assistant. See Administration section on page 5. Total FTEs in 2024 - 14 Fire 2025 2026 2027 2028 2029 Fire Chief 1 1 1 1 1 Assistant Fire Chief 1 1 1 1 1 Fire Marshall - 1* 1 1 1 Full-time Fire Captain 3 3 3 3 3 Full-time Firefighter 9 9 9 9 9 TOTAL: 14 15 15 15 15 2025 – 2029 Personnel Plan / Page 9 POLICE The Prior Lake Police Department (PLPD) is unique in that it provides services to two communities - Prior Lake and the Shakopee Mdewakanton Sioux Community (SMSC). Significant resources have been added over the past few years to catch up with historic staffing shortages. PLPD is in a much better position to provide police services so the timing is right to assess staffing needs into the future. In 2024, the PLPD is working with the consulting firm BerryDunn on a data-driven analysis of staffing needs and an evaluation of current work processes. This analysis should be complete by late summer 2024. At that time, the personnel plan will be updated with the PLPD staffing needs and shared. Total FTEs in 2024 – 39.42 Police 2024 2025 2026 2027 2028 Police Chief 1 1 1 1 1 Commander 2 Sergeant 6 T T T T Patrol Officer/Investigator 24* B B B B Records Supervisor 1 D D D D Records Specialist 3.62 Community Service Officer .8 Evidence Room Technician 1 TOTAL: 39.42 2025 – 2029 Personnel Plan / Page 10 PUBLIC WORKS *2025: Public Works Supervisor. In 2022, the vacant Public Works Supervisor (Utilities) position was converted to a full-time Maintenance Worker position. This conversion was made after an unsuccessful internal and external recruitment for the supervisor position with the intention to focus on developing current team members into a future supervisor. With the multi-million dollars of planned and necessary utility maintenance projects over the next several years (sewer lining, SCADA upgrade, water treatment facility filter beds, etc.), positioning a team member to lead the management and delivery of these projects is critical. The addition of this position will allow these duties to be shifted away from the Assistant Public Works Director so he can focus more fully on the city-wide facility maintenance needs. As a utility position, this position has been planned for and will be funded from the city’s utility enterprise funds. *2028: Facilities Maintenance Manager. With the departure of the Maintenance Superintendent in 2023, and subsequent reclassification of this position to Assistant Public Works Director, combined with the city’s continuing demand for facility support, there is a need for additional resources and expertise focused on facility maintenance and capital facilities projects. Based on the current proposal to consider the addition of this position in 2028, adjustments to the long-range capital facility plan may be necessary, including large pending projects at City Hall and the Police Department. *2029: Recreation Programmer (0.37 FTE). In anticipation of a continued increase and demand for city recreation programs and activities, it is proposed to increase the current part-time to full-time. Total FTEs in 2024 – 39.63 Public Works 2025 2026 2027 2028 2029 PW Director/City Engineer 1 1 1 1 1 Assistant Public Works Director 1 1 1 1 1 Supervisor* 3* 3 3 3 3 Facility Maintenance Manager - - - 1* 1 Mechanics 3 3 3 3 3 Maintenance Worker/Operator 22 22 22 22 22 Facilities Maintenance 1 1 1 1 1 GIS Coordinator*** 1 1 1 1 1 PW Specialist 1 1 1 1 1 Asst City Engineer 1 1 1 1 1 Engineering Tech 2 2 2 2 2 Water Resource Engineer 1 1 1 1 1 Parks & Recreation Manager 1 1 1 1 1 Recreation Supervisor 1 1 1 1 1 Recreation Programmer 1.63 1.63 1.63 1.63 2* TOTAL: 40.63 40.63 40.63 41.63 42 2025 – 2029 Personnel Plan / Page 11 ATTACHMENT B: Org Chart CHECK REGISTER FOR CITY OF PRIOR LAKE 1/9Page: 05/06/2024 09:46 AM User: mfonder DB: Prior Lake CHECK DATE FROM 04/13/2024 - 05/03/2024 AmountDescriptionVendor NameVendorCheckCheck Date Bank 1 General Bank 6.00 Apr 2024 Electric BillSHAKOPEE PUBLIC UTILITIES0001938811123(E)04/15/2024 4,477.00 Crane InspectionALL TEST & INSPECTION INC0002795911124(A)04/18/2024 663.00 PM Maintenance on pressure washers AMERICAN PRESSURE INC0000158011125(A)04/18/2024 166.78 Injector 829.78 155.00 Mileage/Parking - Water SchoolBRAD DOERR0002811511126(A)04/18/2024 2,400.00 Remote Training - Building DeptBS&A SOFTWARE0002684111127(A)04/18/2024 1,379.94 Apr 2024 Carpet Cleaning - LibCOMMERCIAL STEAM TEAM0000372511128(A)04/18/2024 150.00 Safety Boots 2024DANIEL MEGER0001332411129(A)04/18/2024 211.50 Per Diem - AXON ConferenceDANIEL OLSON0002836811130(A)04/18/2024 30.71 9215 Squad supplies EMERGENCY AUTOMOTIVE TECH INC0000548011131(A)04/18/2024 91.96 9215 Squad supplies 97.44 9215 Squad supplies 220.11 100.00 Soil TestingFARMERS MILL & ELEVATOR INC0002763211132(A)04/18/2024 79.50 Wing bolts FASTENAL COMPANY0000614011133(A)04/18/2024 10,233.06 Water Treatment ChemicalsHAWKINS INC0000831211134(A)04/18/2024 2,658.75 Lakefront Park PlaygroundHOISINGTON KOEGLER GROUP INC0000873011135(A)04/18/2024 49.85 Candy - Front DeskINNOVATIVE OFFICE SOLUTIONS LLC0002714911136(A)04/18/2024 165.50 Per Diem - Laserfiche ConferenceJENNIFER BISEK0002714711137(A)04/18/2024 180.00 Mar 2024 PD Counseling ServicesLEAST SERVICES/COUNSELING LLC0002761311138(A)04/18/2024 1,808.62 Altair PartsMACQUEEN EQUIPMENT INC0001305411139(A)04/18/2024 83.91 472 Sweeper parts 54.44 472 Sweeper parts (45.52)Clamp 1,901.45 160.00 SCBA Exam/Quantitative Fit TestingMED-COMPASS INC0001330611140(A)04/18/2024 7,423.00 Color Copier - City HallMETRO SALES INCORPORATED0001338611141(A)04/18/2024 450.00 2024 Vactor Discharge Permit FeeMETROPOLITAN COUNCIL0001340011142(A)04/18/2024 500.00 2024 WTP Discharge Permit 950.00 1,383.79 Paper SuppliesNETWORK SERVICES COMPANY0001438111143(A)04/18/2024 982.00 Mar 2024 General Labor and Employment MaNILAN JOHNSON LEWIS0000812311144(A)04/18/2024 843.00 2024 LELS Health Insurance Arbitration 1,540.50 2024 AFSCME Health Insurance Mediation 3,365.50 211.50 Per Diem - AXON Conference PHILLIP ENGLIN0002854611145(A)04/18/2024 76.50 Support - PL Library Door ProgrammingPRO-TEC DESIGN INC0002742911146(A)04/18/2024 2,281.51 Repair - City Hall Cameras 4,158.68 HVAC Card Reader Additions 6,516.69 60.00 Dump ChargeWM MUELLER & SONS INC0002364511147(A)04/18/2024 174.84 Asphalt CHECK REGISTER FOR CITY OF PRIOR LAKE 2/9Page: 05/06/2024 09:46 AM User: mfonder DB: Prior Lake CHECK DATE FROM 04/13/2024 - 05/03/2024 AmountDescriptionVendor NameVendorCheckCheck Date 346.40 Asphalt 581.24 91.58 508 TailLamp AssemblyWOLF MOTOR CO INC0002367511148(A)04/18/2024 212.17 494 TailLamp Assembly 303.75 31.00 501 Wheel studs ZIEGLER INC0002650011149(A)04/18/2024 989.89 501BR broom diagnosis 9,127.18 501 Skidloader hydraulic system flush 10,148.07 52.00 Mar 2024 COBRA Admin FeesALERUS0000137511150(E)04/22/2024 1,847.20 Apr 2024 Phone BillsNUVERA0001930411151(E)04/22/2024 426.93 Mar 2024 Fuel TaxMN DEPT OF REVENUE0001361211152(E)04/19/2024 429.00 Mar 2024 Sales TaxMN DEPT OF REVENUE0001361211153(E)04/19/2024 16,698.44 Apr 2024 Electric BillsMN VALLEY ELECTRIC0001373811154(E)04/22/2024 3,790.76 Final Drainage ImprovementsBITUMINOUS ROADWAYS INC0000240011155(A)04/26/2024 792.00 IT SupportCOMPUTER INTEGRATION TECH0000376011156(A)04/26/2024 294.50 Aruba Switch Replacement 1,086.50 168.16 Lid PlugCORE & MAIN0002732811157(A)04/26/2024 5,032.00 457 Tommy GateCRYSTEEL TRUCK EQUIPMENT0000395511158(A)04/26/2024 385.00 US Flags & PartsDISPLAY SALES COMPANY0000449311159(A)04/26/2024 682.00 Flags 1,067.00 58.91 9215 Magnetic Mic ClipEMERGENCY AUTOMOTIVE TECH INC0000548011160(A)04/26/2024 58.72 Well 6 - Valve ReplacementFASTENAL COMPANY0000614011161(A)04/26/2024 4,850.85 Fire Hose/Ground Ladder TestingFIRE CATT0000645411162(A)04/26/2024 59.40 RootsawFLEXIBLE PIPE TOOL CO0000666011163(A)04/26/2024 355.50 Warthog Skid 414.90 1,395.00 Fire Pickup Truck DecalsGRAFIX SHOPPE0000761511164(A)04/26/2024 256.00 482 Trailer tires HART BROS TIRE CO0000823711165(A)04/26/2024 11,280.00 Ponds Park - Phase 2HOISINGTON KOEGLER GROUP INC0000873011166(A)04/26/2024 8.68 StaplerINNOVATIVE OFFICE SOLUTIONS LLC0002714911167(A)04/26/2024 252.25 #10 Envelopes 59.36 Name Plate - Zurbey/Watson 320.29 13,810.55 Class 5KRAEMER MINING & MATERIALS INC0000536511168(A)04/26/2024 159.49 519 Wing bolt LITTLE FALLS MACHINE INC0001270511169(A)04/26/2024 123.30 472 Hoses MACQUEEN EQUIPMENT INC0001305411170(A)04/26/2024 65.00 Calibration 188.30 109,085.90 Final Fish Pt Road Phase 1 TRN20-0000001MCNAMARA CONTRACTING INC0001328611171(A)04/26/2024 171,279.78 May 2024 Waste Water ServiceMETROPOLITAN COUNCIL0001340011172(A)04/26/2024 12,500.00 2023 YE AuditMMKR & CO0001374911173(A)04/26/2024 CHECK REGISTER FOR CITY OF PRIOR LAKE 3/9Page: 05/06/2024 09:46 AM User: mfonder DB: Prior Lake CHECK DATE FROM 04/13/2024 - 05/03/2024 AmountDescriptionVendor NameVendorCheckCheck Date 40.47 Toro Workman V-BeltMTI DISTRIBUTING INC0001395111174(A)04/26/2024 1,110.64 Irrigation Parts 125.59 504 Fuel Filter 215.23 537 Turn signal switch 36.70 537 Relay (1,248.71)Toro Returned Parts (45.77)Filter 234.15 1,198.48 Paper SuppliesNETWORK SERVICES COMPANY0001438111175(A)04/26/2024 290.00 Hi VIs VestsNORTH AMERICAN SAFETY0001457411176(A)04/26/2024 2,015.62 Hi Vis Shirts + Seasonal Shirts 1,606.25 Cotton/Poly Shirts + Ear Muffs 475.15 Rec Sweatshirts 457.60 Rec T-Shirts 4,844.62 400.00 Apr 2024 ROWay AppPERRILL0000650211177(A)04/26/2024 390.14 429 Hot box electric jack RIGID HITCH INC0001847511178(A)04/26/2024 152.63 452 Hitch 542.77 135.93 Air Freshener ULINE0002125011179(A)04/26/2024 481.92 Guardian Angel LightsWARNING LITES OF MINNESOTA0002319611180(A)04/26/2024 649.60 AsphaltWM MUELLER & SONS INC0002364511181(A)04/26/2024 480.80 Asphalt 1,130.40 206.33 Lamp AssemblyWOLF MOTOR CO INC0002367511182(A)04/26/2024 73.37 Brake Lining Kit 178.24 8312 Heater door motor 457.94 760.75 Springview MeadowsWSB & ASSOCIATES INC0002378011183(A)04/26/2024 7,581.00 General Engineering Support 941.75 Jeffers Pond - Outlot C - First Addition 89.50 Preserve at Jeffers Pond 1,511.00 Fish Point Road Phase III Intersection I 161.00 2023 SWPPP/MS4 249.00 Filter Evaluation 679.00 2024-2025 Pavement Management Project 2,551.00 2024-2025 Pavement Management Project 6,286.25 H&H Resiliency Study 7,888.75 Panama & 13 Water Quality Credit Retrofi 1,479.75 2040 Park System Plan Finalization 8,599.00 Estate Avenue, Lord's Street, and 150th 10,901.50 TH 13 Trail Connection Project 1,505.00 Water Resource Staff Augmentation 1,422.00 2023 Asset Management Consulting Service 2,293.00 2023-2024 Stormwater Pond Maintenance 413.00 2023-2024 MSAS System Updates 508.50 2023 XPSWMM Model Updates 237.00 Lords Street Bridge Rehab Project CHECK REGISTER FOR CITY OF PRIOR LAKE 4/9Page: 05/06/2024 09:46 AM User: mfonder DB: Prior Lake CHECK DATE FROM 04/13/2024 - 05/03/2024 AmountDescriptionVendor NameVendorCheckCheck Date 1,300.75 Culvers 5,963.25 Martindale Reclamation Project 63,321.75 476.77 FS1 Generator coolant leak ZIEGLER INC0002650011184(A)04/26/2024 536.73 501 Warranty Inspection 1,013.50 7,949.90 1st Qtr 2024 State SurchargeMN DEPT OF LABOR & INDUSTRY0001380111185(E)04/25/2024 404.00 Apr 2024 HSA Admin FeesALERUS0000137511186(E)04/26/2024 8,362.56 Apr 2024 Natural Gas BillsCENTERPOINT ENERGY0001357011187(E)04/29/2024 22,679.68 May 2024 Electric BillsXCEL ENERGY0001472011188(E)04/29/2024 6,452.40 May 2024 Dental PremiumsMETLIFE0002853311189(E)05/01/2024 4,595.50 Martindale/Henning/Hickory ReclamationBOLTON & MENK INC0000263711190(A)05/03/2024 200.00 Budgeting Training - GiesekeBS&A SOFTWARE0002684111191(A)05/03/2024 161.06 Mileage - TrainingCODY STEINHAUS0002749811192(A)05/03/2024 1,536.00 May 2024 CIT Managed BackupCOMPUTER INTEGRATION TECH0000376011193(A)05/03/2024 2,790.00 Apr 2024 Office 365 177.00 Black Cat6 Patch Cable 4,503.00 6,474.00 May 2024 CleaningCOVERALL0002757111194(A)05/03/2024 131.60 9215 Squad supplies EMERGENCY AUTOMOTIVE TECH INC0000548011195(A)05/03/2024 23.15 Flap discs FASTENAL COMPANY0000614011196(A)05/03/2024 175.50 Per Diem - Laserfiche - SimonHEIDI SIMON0002818311197(A)05/03/2024 29.68 Name Plate - SchwarzINNOVATIVE OFFICE SOLUTIONS LLC0002714911198(A)05/03/2024 81.38 Misc Office Supplies 111.06 109.21 Jan-Apr 2024 MileageKELSEY COY0001126211199(A)05/03/2024 238.20 784 Spray Wand CouplingsMACQUEEN EQUIPMENT INC0001305411200(A)05/03/2024 282.00 April 2024 Yoga InstructorMARY MULLETT0002817211201(A)05/03/2024 249,300.00 2024 Tax Assessment ContractSCOTT COUNTY0001921211202(A)05/03/2024 3,000.00 2024 Aerial Imagery 252,300.00 9,373.59 May 2024 Electric Bills #2XCEL ENERGY0001472011203(E)05/03/2024 19.30 Apr 2024 Merchant FeesAUTHORIZE.NET0002682111204(E)05/02/2024 169.96 Uniform - SteinhausASPEN MILLS0000189111395704/18/2024 77.87 City Hall 1st Aid SuppliesCINTAS CORPORATION0000350611395804/18/2024 2,110.63 Club Prior Senior CenterCNH ARCHITECTS0002852911395904/18/2024 157.78 Street SweepingsDEM-CON LANDFILL LLC0000436011396004/18/2024 31.78 UB refund for account: 10024129DISTINCTIVE DESIGNREFUND-UB11396104/18/2024 945.00 Spring Break Survival CampECOELSA LLC0002830511396204/18/2024 1,300.00 Annual ReportFACTOR3 DIGITAL LLC0002753911396304/18/2024 290.00 Fire Studio TrainingFASTSPRING0002815211396404/18/2024 4,781.49 12 Plug ValveFERGUSON WATERWORKS #25160000623111396504/18/2024 136.00 DirtHERMAN'S LANDSCAPE SUPPLIES0000861711396604/18/2024 136.00 Dirt 51.00 Mulch 323.00 3,937.50 PL Welcome BannersHOLIDAY OUTDOOR DECOR0002855911396704/18/2024 65.00 Refund - Community GardenJUDITH SULLIVANREFUND-REC11396804/18/2024 CHECK REGISTER FOR CITY OF PRIOR LAKE 5/9Page: 05/06/2024 09:46 AM User: mfonder DB: Prior Lake CHECK DATE FROM 04/13/2024 - 05/03/2024 AmountDescriptionVendor NameVendorCheckCheck Date 22.02 UB refund for account: 40654201KEARNS DIANEREFUND-UB11396904/18/2024 12.06 UB refund for account: 10555300KIRCHOFF RICHARDREFUND-UB11397004/18/2024 6,400.00 Q1 Heating Inspection & Preventative MaiKLAMM MECHANICAL CONTRACTORS INC0002690411397104/18/2024 34.84 UB refund for account: 40725902KLUG NICHOLASREFUND-UB11397204/18/2024 14,000.00 Refund Grading Escrow - Majestic DevelopLANDTITLEMISC-CD11397304/18/2024 68.48 535 Cabin FilterLANO EQUIPMENT INC0001225511397404/18/2024 68.48 535 Cabin Filter 136.96 1,500.00 P17-1154 4207 Quaker Trail NE - ROWLEADERSHIP INVESTMENT, INC.MISC-CD11397504/18/2024 120.51 UB refund for account: 10129102LUND JAMESREFUND-UB11397604/18/2024 1,105.00 Winter TruckingM-BOHNSACK TRUCKING & EXCAVATING0002852011397704/18/2024 73,457.87 Co-op Agreement - State Furnished MateriMN DEPT OF TRANSPORTATION0001382611397804/18/2024 48.00 LumberMONNENS SUPPLY INC0001390911397904/18/2024 35.35 UB refund for account: 30598901MWEBE MICHAELREFUND-UB11398004/18/2024 9.42 UB refund for account: 10598101PETRICKA JEANREFUND-UB11398104/18/2024 42.01 UB refund for account: 40872901PRABHU NITINREFUND-UB11398204/18/2024 119.97 1st Quarter 2024 Bottled WaterQUENCH USA INC0002831111398304/18/2024 500.00 Lakeside Big Bank Performance 5/8/24RONALD SIVEN0002856611398404/18/2024 12.46 UB refund for account: 10438700SCHLITZ JOHN & JACKIEREFUND-UB11398504/18/2024 28,129.33 1st Quarter 2024 Court FinesSCOTT COUNTY ATTORNEY0001923211398604/18/2024 1,240.00 Pond Mowing SignsSDDI SIGNS0002758511398704/18/2024 17,883.76 Engineering - Sewer Lining ProgramSEH INC0001933911398804/18/2024 1,430.80 Yard WasteSMSC0001938411398904/18/2024 511.35 Yard Waste 1,942.15 242.00 Apr 2024 Portable Toilets - Lakefront & SPECIALIZED SANITATION0001970311399004/18/2024 109.36 UB refund for account: 30358300SPITZMUELLER WOODROWREFUND-UB11399104/18/2024 19.99 Unform - B.EricksonSTREICHERS0001990011399204/18/2024 1,737.65 Apr 2024 Refuse & RecyclingSUBURBAN WASTE SERVICES0002852411399304/18/2024 238.86 UB refund for account: 20383602TACK RICHARDREFUND-UB11399404/18/2024 299.00 Training Drone Class JCUS BANK0000210511399504/18/2024 360.00 Simon - Clerks Institute - Year 2 121.28 3/12 Council Dinner 850.00 Wedel/Briggs Annual Conference 122.50 PE License Renewal 83.65 Support Services Recognition 1,074.83 Bearing Puller 299.00 1/2" Impact Wrench 60.04 Cooling System Adapter 4.99 Screwdrivers 256.05 Post Pounder Parts 232.90 Shop Radio 116.00 Training - McCabe/Wedel 149.95 2024 Safety Boots 90.96 Chip & Dip Day Supplies 372.00 2024 Subscription 49.00 Soap - City Hall 3,576.00 2024 Live Web Streaming & Hosting 1,197.00 Background Checks - Seasonals 14.95 ACA Reporting 49.00 ACA Reporting 59.78 ACA Reporting 212.00 Membership Dues - Englin 1,100.00 Chief's Conference - Duggan/Englin 720.00 2024 License Renewals CHECK REGISTER FOR CITY OF PRIOR LAKE 6/9Page: 05/06/2024 09:46 AM User: mfonder DB: Prior Lake CHECK DATE FROM 04/13/2024 - 05/03/2024 AmountDescriptionVendor NameVendorCheckCheck Date 34.25 Squad CORE Cords 447.06 Office/EE of the Year Awards 67.52 Soda - CONDAC meeting/Gum - EE Council 70.00 Work Zone Safety Overview 91.86 Well 7 Junction Box/Fitting 49.63 Misc PW Office Supplies 62.96 Misc PW Office Supplies/Computer Accesso 303.06 PW Quarterly Meeting 57.81 Manual Pneumatic Valve - Sign Shop 1,230.20 Blinds - IT/Rec Windows 375.82 APWA Spring Conference Lodging - Brotzle 1,241.98 2024 Spring Conference - BrotzlerMonseru 427.72 Cater CONDAC Meeting - Brotzler 44.35 Windshield Washer Fluid 48.74 Fire Extinguisher Bracket - Squad 7109 27.78 Cell Phone Case - Schaefer 80.46 Training Ear Plugs 1,498.00 Olson/Englin - Conference 0.99 50 GB iCloud Stoage 276.19 Airfare - AXON Conference - Englin 279.16 Airfare - AXON Conference - Olson 299.00 Non-Criminal Barricade Response - Rion G 395.00 Evidence Certification Course - Englin 390.00 Training - Recognizing Pre-Attack Indica 54.89 Training Instructor Polo BE44 243.44 SRT Gear - GK 19.90 Training Drone Study Guide JC42 97.95 Door Stops/Radio Clip 15.98 SRT Field Team Gear 699.98 Training - Floor Mats 322.32 Training Mats 13.95 PD - Shipping Fee 600.00 Training FXF Course JL63 299.00 Training Drone Class AB31 200.00 SRT Base Layer NG61 9.98 Airfare - Lannon/Grundei 353.54 SRT Pants - CO 111.99 Plain Clothes Holster 38.47 Drone Replacement Props 191.30 Training - Remote Pilot Course JC42 104.68 Office Supplies 170.73 Hotel - MAPET Conference - Burton 225.00 Annual Conference - Burton 200.00 2024 Membership Dues 123.39 Desktop Thermal Transfer Ribbons 269.95 Duty Boots - Steinhaus 356.48 Dremel Tools 283.98 Fire Station 1 Supplies 162.95 Flowers - J.Hafermann Funeral 0.99 50GB iCloud Storage 84.94 Lakefront Park Playground Feedback Poste 100.00 Wellness Expo Vendor Fee 455.00 CPRP Comp Certification Prep Kit 1,090.00 Phancy Face Painting 67.99 Teddy Grahams 40.01 Event Balloons 67.32 Webcams 126.78 Program Signs 26.87 Interview Panel Lunch 370.35 Prizes - 3.21 Fun! Event CHECK REGISTER FOR CITY OF PRIOR LAKE 7/9Page: 05/06/2024 09:46 AM User: mfonder DB: Prior Lake CHECK DATE FROM 04/13/2024 - 05/03/2024 AmountDescriptionVendor NameVendorCheckCheck Date 113.58 St Patrick's Day Party Supplies 18.54 Como Trip Gas 19.26 Bunny Yoga 66.87 Card Shufflers - CP 141.00 Dog Bones - CP Supplies 222.07 Table 71.71 Club Prior Supplies 292.94 Van Rental - Como Zoo Trip 147.53 Como Trip Lunch 167.96 Vizio 32"TV - PD 305.99 HP Color Laserjet Pro - M255DW Fire Stat 750.00 Aruba Access Points 70.32 PriorLake.com Renewal 398.20 Airfaire - Laserfiche Conference - Roach 76.94 Lumber - Entry Prop 187.46 Inspector I Textbook x 2 206.16 Key Tags/Glove Holders/Truck Bag 77.23 Non-Oxy Fuel - Boat/Skids 150.00 EMT Recertification x6 52.36 Dinner - Ness Last Day 156.66 Dinner - Ness Last Day (127.10)Refund - PD Reception Food - Charge Erro (59.49)Refund - Missed Discount (299.00)Refund - Drone Class 30,077.71 1,500.00 2024 DuesUS HWY 169 CORRIDOR COALITION0002684711399604/18/2024 118.65 UB refund for account: 30007301VLASAK PATRICKREFUND-UB11399704/18/2024 17.88 UB refund for account: 40607300WOLKE CONNIEREFUND-UB11399804/18/2024 50.00 Pest Control - Club Prior/LibXTREME PEST SOLUTIONS INC0002711611399904/18/2024 65.00 Pest Control - FS2 115.00 237.00 521 Hose reel motor repair A & B AUTO ELECTRIC INC0000101011400004/26/2024 5,000.00 P24-0327 16381 Marschall Rd - DemoALI MAE DRAKE & KYLE T DRAKEMISC-CD11400104/26/2024 139.87 Water FilterARAMARK REFRESHMENT SERVICES0000177211400204/26/2024 1,500.00 Tower St Water Tower Reconstruction EscrAT&T MOBILITYREFUND-MSC11400304/26/2024 21,663.00 VFD Replacement - Well 6AUTOMATIC SYSTEMS CO0000197511400404/26/2024 90.00 April 2024 Tai Chi ClassBARBARA HAUGER0002847711400504/26/2024 13,952.48 Mar 2024 Diesel & UnleadedBEAUDRY OIL & PROPANE0002851911400604/26/2024 710.77 Apr 2024 Lawn Care - City HallBIRD'S LAWN CARE0002816411400704/26/2024 1,028.22 Apr 2024 Lawn Care - FS1&2 1,181.81 Apr 2024 Lawn Care - MC 344.91 Apr 2024 Lawn Care - Lib/Club Prior 1,181.81 Apr 2024 Lawn Care - WTF 710.77 Apr 2024 Lawn Care - PD 242.66 Apr 2024 Lawn Care - Rotary Park 5,400.95 395.43 GFCI Replacement - FS1CAL-TEX ELECTRIC INC0000306811400804/26/2024 9,100.00 Fan Install - Mechanics Bay 125.00 Pole Repair 9,620.43 10,912.42 Fan InstallCAPTIVE-AIRE SYSTEMS0002855511400904/26/2024 8,915.48 Road SaltCARGILL INC0000312311401004/26/2024 1,300.00 16139 Northwood Rd NW P21-2202CHAVES PAUL MMISC-CD11401104/26/2024 CHECK REGISTER FOR CITY OF PRIOR LAKE 8/9Page: 05/06/2024 09:46 AM User: mfonder DB: Prior Lake CHECK DATE FROM 04/13/2024 - 05/03/2024 AmountDescriptionVendor NameVendorCheckCheck Date 835.00 Oneline Code Hosting/OrdBank SubscriptioCIVICPLUS LLC0002822411401204/26/2024 100.00 Blank Signs EARL F ANDERSEN INC0000517511401304/26/2024 48.00 471 Head bushing and pin ENVIRONMENTAL EQUIPMENT0000558411401404/26/2024 1,168.00 Squad TiresGOODYEAR COMMERCIAL TIRE0000751011401504/26/2024 480.00 Lime LS RepairsINTERSTATE POWERSYSTEMS INC0000975511401604/26/2024 1,993.34 Escrow Return - Water Tower ReconditioniISD #7190000986511401704/26/2024 292.50 Mar 2024 Employment and Labor MattersKENNEDY & GRAVEN, CHARTERED0002846811401804/26/2024 663.99 Claim #LMCGL000000346531LEAGUE MN CITIES INS TRUS0001243511401904/26/2024 58.13 StainMENARDS LUMBER CO0001331811402004/26/2024 149.93 Parts 208.06 145.63 McCrometer Well Flow Meter Repair PartsMID AMERICA METER INC0001345511402104/26/2024 95.84 472 Wiper BladesMIDWEST MACHINERY CO0002811311402204/26/2024 1,375.00 J.D. Modems 1,470.84 V7,949.90 1st Qtr 2024 State SurchargeMN DEPT OF LABOR & INDUSTRY0001380111402304/26/2024 2,774.46 1st Qtr 2024 UnemploymentMN UC FUND0001373411402404/26/2024 83.17 Mar 2024 Repair Parts - FDNAPA AUTO PARTS0001406011402504/26/2024 1,061.19 Mar 2024 Repair Parts 1,144.36 1,643.62 7109 Tracer lights NORTH CENTRAL0002853111402604/26/2024 350.00 CP PresentationPIONEER PHOTOGRAPHY & SERVICES INC0002852111402704/26/2024 4,569.00 Sewer Jetting - MCROTO-ROOTER0001869011402804/26/2024 237.50 Heated wiper blades RUXER FORD LINCOLN INC0002809811402904/26/2024 869.25 Music Performance LicenseSESAC0002857011403004/26/2024 39.48 PaintSHERWIN-WILLIAMS CO0001945611403104/26/2024 26.73 Paint 66.21 89.85 Pointed LathsSIWEK LUMBER & MILLWORK INC0001953811403204/26/2024 3,852.25 Channel Splitter & VFDSYCOM INC0001998511403304/26/2024 1,056.50 Freedom Contactor 4,908.75 87.98 Water Efficiency RebateTODD EBERLEREFUND-MSC11403404/26/2024 175.23 519 Radiator hoses and clamps TRUCK CENTER COMPANIES0002787811403504/26/2024 767.00 519 Radiator 50.00 519 Radiator Freight 992.23 246.62 FluorideUSA BLUEBOOK0002188211403604/26/2024 140.00 Nitrogen Tests 386.62 143.92 Ratchet StrapsZACKS INCORPORATED0002610011403704/26/2024 5,442.54 Apr 2024 DieselBEAUDRY OIL & PROPANE0002851911403805/03/2024 2,632.01 Apr 2024 Unleaded CHECK REGISTER FOR CITY OF PRIOR LAKE 9/9Page: 05/06/2024 09:46 AM User: mfonder DB: Prior Lake CHECK DATE FROM 04/13/2024 - 05/03/2024 AmountDescriptionVendor NameVendorCheckCheck Date 8,074.55 30,915.84 Road SaltCARGILL INC0000312311403905/03/2024 24.08 FS1 1st Aid SuppliesCINTAS CORPORATION0000350611404005/03/2024 288.49 Mtce Center 1st Aid Supplies 77.23 PD 1st Aid Supplies 33.62 FS2 1st Aid Supplies 38.74 Club Prior 1st Aid Supplies 24.60 Lakefront Pavilion 1st Aid Supplies 486.76 890.90 Asphalt MixCITY OF ST PAUL0000352111404105/03/2024 2,271.84 City Hall Reception RemodelCNH ARCHITECTS0002852911404205/03/2024 561.42 467 Tarp and rod CRYSTEEL MANUFACTURING INC0000398211404305/03/2024 75.00 Mailbox ReimbursementCYNTHIA & ALLEN HOPPEREF MAIL B11404405/03/2024 190.00 Diaphragm 4" Watts PRV - WTF DAKOTA SUPPLY GROUP0002801311404505/03/2024 705.00 Apr 2024 Fitness InstructorELEANOR ALLEN0002806011404605/03/2024 596.17 Ladder L9280 RepairEMERGENCY APPARATUS MAINT0000547511404705/03/2024 250.00 Kitchen Floor Repair - FS1FOUNDATION FLOOR COVERINGS0002826211404805/03/2024 225.00 Annual Membership Dues - SimonINT'L INSTITUTE OF MUNICIPAL CLERKS0002771211404905/03/2024 5,000.00 14756 Cove Ave SE P23-1962J S Stewart Companies IncMISC-CD11405005/03/2024 600.00 Apr 2024 Line Dance InstructorJANE BREEGGEMANN0002788611405105/03/2024 100.00 Water Efficiency RebateMAUREEN KOHLENBERGERREFUND-MSC11405205/03/2024 75.00 Mailbox Reimbursement - 2405 Stonecrest MEADOW VIEW ASSOCIATIONREF MAIL B11405305/03/2024 351.16 503 JD Link install MIDWEST MACHINERY CO0002811311405405/03/2024 250.00 Workshop - Good Mental Health in the WorNAMI Minnesota0002857111405505/03/2024 75.00 Mailbox Reimbursement NATALIE DARWITZREF MAIL B11405605/03/2024 67,366.59 #9 CSAH 21/Revere AvenuePARK CONSTRUCTION COMPANY0002838211405705/03/2024 100.00 Water Efficiency RebatePATRICE AKSAMITREFUND-MSC11405805/03/2024 3,000.00 2024 Annual LicensePLAN IT SOFTWARE LLC0002837811405905/03/2024 12.13 1st Qtr 2024 Bottled Water - Price AdjQUENCH USA INC0002831111406005/03/2024 90.00 Reservation RefundRUTH WESTMANREFUND-REC11406105/03/2024 75.00 Mailbox ReimbursementRYAN RUZEKREF MAIL B11406205/03/2024 255.00 Reservation SignsSDDI SIGNS0002758511406305/03/2024 1,984.00 Apr 2024 Portable ToiletsSPECIALIZED SANITATION0001970311406405/03/2024 72.68 Apr 2024 Legal NoticesSTAR TRIBUNE0001974411406505/03/2024 165.00 Badge - OlsonSTREICHERS0001990011406605/03/2024 79.99 Uniform - Englin 140.00 Alterations - Boser 1,722.00 Vest - Lewis 1,729.99 Uniforms - Steinhaus 3,836.98 369.50 Firearm PartsTHE MODERN SPORTSMAN0002841411406705/03/2024 7.41 519 Radiator elbow TRUCK CENTER COMPANIES0002787811406805/03/2024 75.00 Mailbox ReimbursementTYLER FRANKREF MAIL B11406905/03/2024 5,850.00 Spray-water Plumbing Repairs - WTF ReclaWW GOETSCH ASSOCIATES INC0002379511407005/03/2024 1 TOTALS: 1,245,112.32 Total of 195 Disbursements: 7,949.90 Less 1 Void Checks: 1,253,062.22 Total of 196 Checks: YTM @ Cost Cost Value Days to Maturity % of Portfolio 0-1 Month 4.083 9,627,932 1 19.43% 1-3 Months 1.801 1,363,229 46 2.70% 3-6 Months 2.062 2,692,925 141 5.46% 6-9 Months 2.263 2,836,143 233 5.64% 9-12 Months 1.178 1,842,981 324 3.71% 1-2 Years 2.346 8,539,123 607 16.95% 2-3 Years 2.045 8,118,746 912 16.48% 3-4 Years 3.655 5,724,642 1,287 11.92% 4-5 Years 4.596 6,965,509 1,654 14.29% 5-10 Years 4.640 1,580,085 1,953 3.42% Total / Average 3.111 49,291,314 744 100.00% CITY OF PRIOR LAKE, MINNESOTA Investment Portfolio - Diversification, by Maturity Range March 31, 2024 Description City of Prior Lake - Quarterly Investment Report Description CUSIP/Ticker Settlement Date YTM @ Cost Face Amount/Shares Cost Value Book Value Market Value Maturity Date Days To Maturity Accrued Interest % of Portfolio Cash - Northland Securities Cash CASH5845 2/3/2002 0.000 339,363.90 339,363.90 339,363.90 339,363.90 N/A 1 0.68 Morgan Stanley Cash CASH5089 12/31/2010 0.000 71,963.37 71,963.37 71,963.37 71,963.37 N/A 1 0.15 Oppenheimer Cash MM9905 12/27/2011 0.000 1,794,224.98 1,794,224.98 1,794,224.98 1,794,224.98 N/A 1 3.62 Sub Total / Average Cash 0.000 2,205,552.25 2,205,552.25 2,205,552.25 2,205,552.25 1 0.00 4.45 1st Security Bk of Wash 4.05 6/16/2026 33625CFL8 12/16/2022 4.050 249,000.00 249,000.00 249,000.00 245,078.25 6/16/2026 807 414.43 0.50 Ally Bk Sandy UT 3.4 8/4/2025 02007GXF5 8/4/2022 3.400 245,000.00 245,000.00 245,000.00 239,872.15 8/4/2025 491 1,278.03 0.49 Amerant Bank 4.65 9/8/2028 02357QCF2 9/8/2023 4.650 249,000.00 249,000.00 249,000.00 252,299.25 9/8/2028 1,622 729.60 0.50 AMERASIA BK FLUSHING NY 4 2/15/2029 02357PAG4 2/15/2024 4.000 248,000.00 248,000.00 248,000.00 244,728.88 2/15/2029 1,782 434.85 0.50 American Express Natl 3 5/4/2027 02589ACK6 4/30/2022 3.000 245,000.00 245,000.00 245,000.00 233,732.45 5/4/2027 1,129 2,980.27 0.49 Banc Calif Irvine 3.2 7/1/2024 05961SNS9 6/29/2022 3.200 245,000.00 245,000.00 245,000.00 243,625.55 7/1/2024 92 1,997.59 0.49 Bank Hapoalim 0.95 7/23/2026 06251A2Y5 7/23/2021 0.950 245,000.00 245,000.00 245,000.00 224,603.75 7/23/2026 844 433.62 0.49 Bank of Belleville 4 6/15/2027 06063PDD4 12/15/2022 4.000 249,000.00 249,000.00 249,000.00 244,752.06 6/15/2027 1,171 436.60 0.50 Bankers Bank West Denver CO 1.8 9/30/2024 06610T-EE-1 9/30/2019 1.800 245,000.00 245,000.00 245,000.00 240,739.45 9/30/2024 183 12.08 0.49 BankUnited Savings Miami 0.95 3/31/2026 066519QT9 3/31/2021 0.950 245,000.00 245,000.00 245,000.00 226,796.50 3/31/2026 730 0.00 0.49 BMW Bk 4.75 3/17/2028 055180AW83 3/17/2023 4.750 245,000.00 245,000.00 245,000.00 248,425.10 3/17/2028 1,447 446.37 0.49 BNY Mellon4.5 9/7/2028 05584CJJ6 9/7/2023 4.500 244,000.00 244,000.00 244,000.00 245,644.56 9/7/2028 1,621 721.97 0.49 Bridgewater Bk 4.8 3/29/2028 108622NK3 3/29/2023 4.800 245,000.00 245,000.00 245,000.00 249,160.10 3/29/2028 1,459 64.44 0.49 CalPrivate Bk La Jolla 4 9/23/2027-23 13135NAS9 9/28/2022 4.400 249,000.00 244,545.39 245,890.82 245,053.35 9/23/2027 1,271 221.33 0.50 Capital One Bk USA Natl 1.8 3/17/2025 14042TEM5 3/16/2022 1.800 245,000.00 245,000.00 245,000.00 237,338.85 3/17/2025 351 181.23 0.49 Capital One Nat'l Assn McLean 2.1 8/14/2024 14042RMW8 8/14/2019 2.100 247,000.00 247,000.00 247,000.00 243,961.90 8/14/2024 136 653.70 0.50 Celtic Bank 4.6 9/19/2028 15118RJ32 9/19/2023 4.600 249,000.00 249,000.00 249,000.00 251,828.64 9/19/2028 1,633 376.57 0.50 Central Fed Savings 4.5 9/14/2028 15347VAC5 9/14/2023 4.500 249,000.00 249,000.00 249,000.00 250,805.25 9/14/2028 1,628 521.88 0.50 CIBC Bank USA 4.5 5/25/2028 12547CBN7 5/25/2023 4.500 244,000.00 244,000.00 244,000.00 245,461.56 5/25/2028 1,516 3,820.44 0.49 Citizens Bk Batesville Ark 3.85 2/16/2029 173477BZ2 2/16/2024 3.850 248,000.00 248,000.00 248,000.00 243,092.08 2/16/2029 1,783 392.38 0.50 City Natl Bk Los Ang 4.9 11/24/2025 178180GS8 11/23/2022 4.900 245,000.00 245,000.00 245,000.00 244,958.35 11/24/2025 603 4,242.86 0.49 Customers Bk 4.95 10/27/2028 23204HPE2 10/27/2023 4.950 240,000.00 240,000.00 240,000.00 246,196.80 10/27/2028 1,671 5,077.48 0.48 Discover Bk 4.5 7/24/2028 2546736R2 7/26/2023 4.500 244,000.00 244,000.00 244,000.00 245,644.56 7/24/2028 1,576 1,955.34 0.49 Enerbank USA 0.55 9/25/2025 29278TRL6 9/25/2020 0.550 245,000.00 245,000.00 245,000.00 229,462.10 9/25/2025 543 22.15 0.49 Enterprise Bank & Trust 1.8 11/8/2024 29367SJQ8 11/8/2019 1.800 245,000.00 245,000.00 245,000.00 239,894.20 11/8/2024 222 277.89 0.49 Enterprise Bank Allison Park PA 1.8 9/27/2024 29367R-LA-2 9/27/2019 1.800 245,000.00 245,000.00 245,000.00 240,710.05 9/27/2024 180 48.33 0.49 Farmers BK 4.85 10/17/2028 30916PAA2 10/17/2023 4.850 248,000.00 248,000.00 248,000.00 254,413.28 10/17/2028 1,661 461.35 0.50 First Bank of the Lake 4.9 4/25/2028-24 31925YAE2 4/25/2023 4.900 248,000.00 248,000.00 248,000.00 248,074.40 4/25/2028 1,486 199.76 0.50 First Commercial Bank MS 0.3 3/31/2025 31984GFK0 3/7/2022 1.700 225,000.00 215,588.25 221,932.78 214,456.50 3/31/2025 365 1.85 0.45 First Finl Bk3.3 8/2/2027 32022RSG3 8/1/2022 3.300 245,000.00 245,000.00 245,000.00 235,658.15 8/2/2027 1,219 664.52 0.49 First National Bank/Dama 5 10/31/2028 32117BGJ1 10/31/2023 5.000 248,000.00 248,000.00 248,000.00 255,092.80 10/31/2028 1,675 1,019.18 0.50 First Natl Bank of Albany 1.6 2/28/2025 32117WAN2 2/28/2020 1.600 245,000.00 245,000.00 245,000.00 237,304.55 2/28/2025 334 32.22 0.49 First Natl Bk 4.75 10/30/2028 32110YH73 10/30/2023 4.750 245,000.00 245,000.00 245,000.00 249,461.45 10/30/2028 1,674 0.00 0.49 First Utd Bk4.4 8/8/2025 33742CCR6 2/8/2023 4.400 245,000.00 245,000.00 245,000.00 243,059.60 8/8/2025 495 679.29 0.49 Genoa Banking Company 4.95 10/31/2028 372348DH2 10/31/2023 4.950 243,000.00 243,000.00 243,000.00 249,322.86 10/31/2028 1,675 5,009.13 0.49 Goldman Sachs Bk 1 7/28/2026 38149MXK4 7/28/2021 1.000 245,000.00 245,000.00 245,000.00 224,397.95 7/28/2026 849 422.88 0.49 Legacy Bk & Tr Co 3.5 7/29/2027-22 52470QBK9 8/1/2022 3.500 245,000.00 245,000.00 245,000.00 237,204.10 7/29/2027 1,215 46.99 0.49 Live Oak Bkg Co 3.55 8/2/2027-23 538036WY6 8/2/2022 3.550 249,000.00 249,000.00 249,000.00 241,435.38 8/2/2027 1,219 702.32 0.50 Luana Savings Bank 0.2 5/7/2024 549104XH5 11/22/2021 0.699 240,000.00 237,081.60 239,879.62 238,663.20 5/7/2024 37 190.68 0.48 Manufacturers 4.9 12/9/2024 564759RJ9 12/7/2022 4.900 245,000.00 245,000.00 245,000.00 244,456.10 12/9/2024 253 3,782.40 0.49 Mauch Chunk Trust 4.35 2/28/2029 577234DA2 3/28/2024 4.350 249,000.00 249,000.00 249,000.00 249,600.09 2/28/2029 1,795 89.03 0.50 Medallion Bk Salt 4.4 7/31/2028 58404DSW2 7/31/2023 4.400 245,000.00 245,000.00 245,000.00 245,705.60 7/31/2028 1,583 0.00 0.49 Merrick Bk 4.85 11/6/2029 59013KXW1 11/6/2023 4.850 245,000.00 245,000.00 245,000.00 252,852.25 11/6/2029 2,046 813.87 0.49 Morgan Stanley Bank Step 11/28/2027 61765QP52 9/2/2021 1.004 249,000.00 249,000.00 249,000.00 220,499.46 11/28/2027 1,337 218.30 0.50 MORGAN STANLEY PRIVATE BK 5.05 11/8/2028 61768EE82 11/8/2023 5.050 243,000.00 243,000.00 243,000.00 250,365.33 11/8/2028 1,683 4,841.36 0.49 Oceanfirst Bk Natl 3.25 7/1/2024 67523TBE2 6/29/2022 3.250 245,000.00 245,000.00 245,000.00 243,657.40 7/1/2024 92 2,028.80 0.49 Old Dominion Natl Bk 4 1/29/2029 679585CL1 1/29/2024 4.000 249,000.00 249,000.00 249,000.00 245,775.45 1/29/2029 1,765 0.00 0.50 Ponce De Leon Fed Bk 3.5 9/15/2027 732329BD8 9/15/2022 3.500 245,000.00 245,000.00 245,000.00 237,167.35 9/15/2027 1,263 375.89 0.49 Preferred Bank LA Calif 1.95 8/30/2024 740367HR1 8/30/2019 1.950 249,000.00 249,000.00 249,000.00 245,511.51 8/30/2024 152 0.00 0.50 Sallie Mae Bank Utah 1.9 9/18/2024 7954504D4 9/18/2019 1.900 245,000.00 245,000.00 245,000.00 241,018.75 9/18/2024 171 165.79 0.49 Savibank 4.05 1/19/2027 80517LAC5 1/18/2023 4.050 249,000.00 249,000.00 249,000.00 244,943.79 1/19/2027 1,024 359.17 0.50 Schuyler Svgs Bk 4.35 7/27/2028 80832MAA5 7/27/2023 4.350 244,000.00 244,000.00 244,000.00 244,170.80 7/27/2028 1,579 1,861.08 0.49 Signature Bk New York 4.7 12/9/2024 82669GFM1 12/9/2022 4.700 240,000.00 240,000.00 240,000.00 239,049.60 12/9/2024 253 3,492.16 0.48 Southern First Bank NA 4.85 10/17/2028 84287PJB9 11/7/2023 4.850 244,000.00 244,000.00 244,000.00 250,060.96 10/17/2028 1,661 5,382.04 0.49 Synchrony Bank 0.9 8/6/2026 87165GD58 8/6/2021 0.900 248,000.00 248,000.00 248,000.00 227,549.92 8/6/2026 858 330.21 0.50 Texas Exchange Bk 0.45 8/21/2024 88241TJE1 8/21/2020 0.450 245,000.00 245,000.00 245,000.00 240,286.20 8/21/2024 143 30.21 0.49 Third Fed Sav & Ln 3.3 8/19/2027 88413QDN5 8/19/2022 3.300 245,000.00 245,000.00 245,000.00 235,655.70 8/19/2027 1,236 908.18 0.49 Toyota Finl Svgs Bk 0.95 7/15/2026 89235MLC3 7/15/2021 0.950 245,000.00 245,000.00 245,000.00 224,763.00 7/15/2026 836 484.63 0.49 Transportation Alliance Bk 4.8 9/9/2024 89388CGG7 12/9/2022 4.800 240,000.00 240,000.00 240,000.00 239,426.40 9/9/2024 162 694.36 0.48 UBS Bk USA 4.4 7/26/2028 90355GEX0 7/26/2023 4.400 245,000.00 245,000.00 245,000.00 245,695.80 7/26/2028 1,578 147.67 0.49 Uinta Bk Mtn 4.4 3/22/2028 903572FT7 3/22/2023 4.400 245,000.00 245,000.00 245,000.00 245,463.05 3/22/2028 1,452 265.81 0.49 Univest Bank & Trust 4.5 6/21/2028 91527PCD7 6/21/2023 4.500 249,000.00 249,000.00 249,000.00 256,691.61 6/21/2028 1,543 306.99 0.50 Valley Central 4 4/28/2028 91944RAZ1 4/28/2023 4.000 249,000.00 249,000.00 249,000.00 245,867.58 4/28/2028 1,489 81.86 0.50 Washington Federal 1.95 8/28/2024 938828BN9 8/28/2019 1.950 245,000.00 245,000.00 245,000.00 241,609.20 8/28/2024 150 39.27 0.49 Wells Fargo BK NA Sioux Falls 2.75 5/17/2024 949763-B6-2 6/11/2019 2.650 200,000.00 200,924.00 200,024.10 199,284.00 5/17/2024 47 210.96 0.40 Winter Hill Bank 3.5 8/26/2027-23 975875BH7 8/26/2022 3.500 245,000.00 245,000.00 245,000.00 237,157.55 8/26/2027 1,243 117.47 0.49 Sub Total / Average Certificate Of Deposit 3.420 16,152,000.00 16,136,139.24 16,145,727.32 15,926,694.41 1,032 64,199.11 32.59 FAMC 4.17 5/24/2029 31422XYY2 1/19/2024 4.580 325,000.00 318,724.25 318,955.73 315,900.00 5/24/2029 1,880 4,781.02 0.66 Sub Total / Average FAMC Bond 4.580 325,000.00 318,724.25 318,955.73 315,900.00 1,880 4,781.02 0.66 City of Prior Lake Portfolio Holdings Investment Portfolio - by Security Type As of 3/31/2024 Cash Certificate Of Deposit FAMC Bond FFCB Bond Federal Farm Cr Bks 4.86 12/22/2027-25 3133EPN92 12/22/2023 4.860 500,000.00 500,000.00 500,000.00 496,060.00 12/22/2027 1,361 6,657.53 1.01 FFCB 0.69 7/22/2025-21 3133ELX33 4/15/2021 0.750 600,000.00 598,488.00 599,536.41 568,116.00 7/22/2025 478 793.50 1.21 FFCB 0.72 10/27/2026-21 3133EMES7 6/18/2021 1.000 500,000.00 492,715.00 496,500.82 451,550.00 10/27/2026 940 1,540.00 1.01 FFCB 0.74 11/24/2026-21 3133EMHC9 4/14/2021 1.053 450,000.00 442,350.00 446,387.71 407,178.00 11/24/2026 968 1,174.75 0.91 FFCB 2.62 11/17/2025 3133EHJR5 9/24/2021 0.810 500,000.00 536,830.00 514,488.90 483,195.00 11/17/2025 596 4,876.11 1.01 FFCB 3.05 5/18/2029 3133ENXB1 1/19/2024 4.030 325,000.00 309,845.25 310,405.96 306,796.75 5/18/2029 1,874 3,662.12 0.66 FFCB 4.5 12/22/2025 3133EPQ81 12/29/2023 4.210 1,000,000.00 1,005,440.00 1,004,741.22 994,770.00 12/22/2025 631 12,375.00 2.02 Sub Total / Average FFCB Bond 2.524 3,875,000.00 3,885,668.25 3,872,061.02 3,707,665.75 880 31,079.01 7.82 FHLB 1 12/30/2026-21 3130ANY87 10/20/2021 1.205 500,000.00 494,850.00 497,274.33 451,380.00 12/30/2026 1,004 1,250.00 1.01 FHLB 1.25 11/10/2026-22 3130APLR4 11/10/2021 1.250 450,000.00 450,000.00 450,000.00 413,626.50 11/10/2026 954 2,203.12 0.91 FHLB 2.375 8/15/2029 3130AGVG7 2/12/2024 4.310 270,000.00 244,620.00 245,225.79 242,846.10 8/15/2029 1,963 819.37 0.54 FHLB 3 4/20/2026 3130ARGN5 12/29/2023 4.350 1,000,000.00 970,620.00 973,861.21 965,140.00 4/20/2026 750 13,416.67 2.02 FHLB Step 12/15/2025-21 3130AKJ72 4/13/2021 0.894 500,000.00 497,500.00 499,086.12 471,530.00 12/15/2025 624 1,177.78 1.01 FHLN 5159508 1.25 10/16/2026-21 3130ALW83 4/16/2021 1.250 216,666.67 216,666.67 216,666.67 199,095.00 10/16/2026 929 1,241.32 0.44 FHLN 5214149 Step 7/22/2026-21 3130AN4W7 7/22/2021 1.057 1,000,000.00 1,000,000.00 1,000,000.00 925,880.00 7/22/2026 843 2,300.00 2.02 Sub Total / Average FHLB Bond 2.147 3,936,666.67 3,874,256.67 3,882,114.12 3,669,497.60 906 22,408.26 7.94 FHLMC 0.5 12/9/2024 3134GWA71 9/9/2020 0.500 200,000.00 200,000.00 200,000.00 193,450.00 12/9/2024 253 311.11 0.40 Sub Total / Average FHLMC Bond 0.500 200,000.00 200,000.00 200,000.00 193,450.00 253 311.11 0.40 League of Minnesota Cities - 4M Fund LGIP LGIP5101M 11/30/2010 5.275 156,273.00 156,273.00 156,273.00 156,273.00 N/A 1 0.32 League of Minnesota Cities - 4M Plus Fund LGIP LGIP5101MP 11/30/2010 5.297 7,266,106.44 7,266,106.44 7,266,106.44 7,266,106.44 N/A 1 14.66 Sub Total / Average Local Government Investment Pool 5.297 7,422,379.44 7,422,379.44 7,422,379.44 7,422,379.44 1 0.00 14.98 Allen Park MI Public Sch Dist 2 11/2/2024 018033HR4 7/30/2020 0.751 290,000.00 305,140.90 292,101.82 284,777.10 11/2/2024 216 2,416.67 0.59 Cabot-Las Positas 1.287 8/1/2027 15722TJS1 4/28/2022 3.500 550,000.00 491,991.50 513,220.01 494,994.50 8/1/2027 1,218 1,179.75 1.11 Canadian Cnty Okla Indpt Sch Dist 2 11/1/2024 135537-GT-9 11/7/2019 2.000 285,000.00 285,000.00 285,000.00 279,388.35 11/1/2024 215 2,375.00 0.58 Cecil Cnty MD 1.05 11/1/2026 1498433N2 9/23/2021 0.970 500,000.00 501,985.00 501,005.80 456,060.00 11/1/2026 945 2,187.50 1.01 Central Cmnty Sch 2 3/1/2026 153135FJ2 3/4/2021 0.700 300,000.00 319,098.00 307,333.30 284,382.00 3/1/2026 700 500.00 0.61 El Paso TX ISD 0 8/15/2024 283770NS0 10/30/2020 0.700 500,000.00 486,925.00 498,706.66 490,585.00 8/15/2024 137 0.00 1.01 Enfield Conn Taxable 1.39 8/1/2027 292749UK2 4/6/2022 3.000 335,000.00 308,658.95 318,487.70 301,684.25 8/1/2027 1,218 776.08 0.68 Falmouth ME Taxable 3 10/15/2025 306783NF4 10/15/2021 0.800 340,000.00 369,386.20 351,324.05 330,514.00 10/15/2025 563 4,703.33 0.69 Federal Way Wash2.2 12/1/2024 314031-HH-1 12/11/2019 2.150 475,000.00 476,111.50 475,149.87 465,785.00 12/1/2024 245 3,483.33 0.96 Franklin Twp 1.623 2/1/2029 355064KL9 10/4/2023 5.350 250,000.00 207,310.00 211,234.76 219,120.00 2/1/2029 1,768 676.25 0.50 Goose Creek Tex 4.5 2/15/2027 382604Z25 11/3/2022 4.700 500,000.00 496,125.00 497,397.68 498,560.00 2/15/2027 1,051 2,875.00 1.01 Hawaii St GO Ref 2.802 10/1/2027-26 419792KL9 7/28/2022 3.350 100,000.00 97,413.00 98,250.25 94,632.00 10/1/2027 1,279 1,401.00 0.20 Hawaii St Taxable 1.033 8/1/2025 419792F92 10/12/2021 0.950 300,000.00 300,924.00 300,324.63 284,727.00 8/1/2025 488 516.50 0.61 Indiana Bond Bank 3.326 7/15/2025 45462TER9 3/26/2021 0.900 240,000.00 264,516.00 247,345.44 234,748.80 7/15/2025 471 1,685.17 0.48 Liberty Center Ohio 0 11/1/2025 530336DV5 8/18/2020 1.051 215,000.00 203,589.95 211,518.76 198,769.65 11/1/2025 580 0.00 0.43 Mankato Minn ISD 0.7 2/1/2025 563690RP3 10/22/2020 0.700 300,000.00 300,000.00 300,000.00 288,891.00 2/1/2025 307 350.00 0.61 Mason & Kitsap Cntys 1.583 12/1/2028 575181HB1 5/19/2023 4.150 445,000.00 389,032.35 397,802.37 388,164.60 12/1/2028 1,706 2,348.12 0.90 Massachusetts St 0.986 11/1/2026 57582RK96 6/30/2021 1.000 500,000.00 499,635.00 499,823.12 455,635.00 11/1/2026 945 2,054.17 1.01 Massachusetts St Dev 2.785 5/1/2024 57584FEM8 12/20/2019 1.920 240,000.00 248,647.20 240,168.17 239,421.60 5/1/2024 31 2,785.00 0.48 Milwaukee Cnty Wis 2 12/1/2026 6022453V2 11/23/2021 1.300 500,000.00 516,960.00 509,016.36 466,055.00 12/1/2026 975 3,333.33 1.01 Minnesota St 7 11/1/2028 604146GK0 11/8/2023 5.251 250,000.00 268,952.50 267,452.96 276,037.50 11/1/2028 1,676 6,951.39 0.50 New York NY 1.92 11/1/2029 64971XUUO 9/25/2023 5.150 275,000.00 228,998.00 232,877.94 238,548.75 11/1/2029 2,041 2,200.00 0.55 New York NY 3.7 8/1/2029-25 64966LYZ8 11/24/2023 5.100 250,000.00 232,897.50 233,951.48 239,565.00 8/1/2029 1,949 1,541.67 0.50 New York State TFA 4.2 11/1/2028-23 64971Q7N7 9/7/2023 4.850 250,000.00 242,657.50 243,461.20 246,312.50 11/1/2028 1,676 4,375.00 0.50 Northwest Local Sch District Hamilton & Butler 667712CG6 11/15/2019 2.169 370,000.00 389,010.60 372,527.18 365,319.50 12/1/2024 245 4,008.33 0.75 Oklahoma Cnty Okla Metro 2.65 6/1/2024 67869T-AD-7 7/15/2019 2.286 500,000.00 508,255.00 500,287.05 497,820.00 6/1/2024 62 4,416.67 1.01 Orono ME Taxable 5 11/1/2025 687085DR8 10/29/2020 1.000 330,000.00 394,287.30 350,386.35 329,749.20 11/1/2025 580 6,875.00 0.67 Pelican Rapids Minn 0.8 2/1/2025 705863HR2 12/17/2020 0.700 525,000.00 527,126.25 525,433.15 506,682.75 2/1/2025 307 700.00 1.06 Pennsylvania St Univ 1.645 9/1/2025 709235S48 12/6/2021 1.120 250,000.00 254,787.50 251,820.30 238,792.50 9/1/2025 519 342.71 0.50 Roanoke VA Taxable 2 2/1/2025 770078BD4 5/14/2020 1.250 300,000.00 310,266.00 301,828.11 292,413.00 2/1/2025 307 1,000.00 0.61 Springboro Ohio 5 12/1/2027 85023MAF2 7/12/2022 4.002 245,000.00 256,755.10 253,003.98 248,275.65 12/1/2027 1,340 4,083.33 0.49 St Louis Park Minn 4.5 2/1/2027 791740V34 9/7/2022 3.345 190,000.00 198,863.50 195,716.08 187,989.80 2/1/2027 1,037 1,425.00 0.38 Toledo Ohio City Sch 5 12/1/2027 889294RT3 9/28/2022 4.520 100,000.00 102,186.00 101,549.86 100,780.00 12/1/2027 1,340 1,666.67 0.20 Trussville AL 0.822 10/1/2025 898242ND0 8/25/2020 0.710 300,000.00 301,677.00 300,494.19 282,474.00 10/1/2025 549 1,233.00 0.61 Waukesha Wis 1.2 10/1/2027 943080UZ2 9/1/2022 3.660 375,000.00 332,557.50 345,752.18 333,937.50 10/1/2027 1,279 2,250.00 0.76 Wauwatosa WI 3 12/1/2024-22 9435042U3 10/28/2021 2.014 200,000.00 205,880.00 201,274.87 197,088.00 12/1/2024 245 2,000.00 0.40 Wicomico Cnty MD 2 12/1/2026 967546BA9 5/13/2022 3.450 380,000.00 356,975.80 366,501.15 354,293.00 12/1/2026 975 2,533.33 0.77 Winthrop Minn 2 2/1/2029-28 976367PN6 11/24/2023 5.100 225,000.00 193,556.25 195,679.03 196,719.75 2/1/2029 1,768 750.00 0.45 Wisconsin St Gen Fund 2.877 5/1/2024 977100EA0 12/2/2021 0.700 160,000.00 168,321.60 160,292.81 159,648.00 5/1/2024 31 1,918.00 0.32 Sub Total / Average Municipal Bond 2.343 12,640,000.00 12,542,460.45 12,455,500.62 12,049,341.25 812 85,916.30 25.51 T-Note 0.375 11/30/2025 91282CAZ4 9/24/2021 0.780 300,000.00 295,008.00 298,010.39 279,153.00 11/30/2025 609 375.00 0.61 T-Note 0.625 11/30/2027 91282CAY7 5/5/2022 3.040 500,000.00 438,535.00 459,556.94 437,815.00 11/30/2027 1,339 1,041.67 1.01 T-Note 2.5 2/28/2026 9128286F2 12/21/2023 4.220 1,000,000.00 964,310.91 968,816.66 960,780.00 2/28/2026 699 2,105.98 2.02 T-Note 4.625 3/15/2026 91282CGR6 12/21/2023 4.230 1,000,000.00 1,008,280.00 1,007,253.89 999,380.00 3/15/2026 714 2,010.87 2.02 Sub Total / Average Treasury Note 3.644 2,800,000.00 2,706,133.91 2,733,637.88 2,677,128.00 809 5,533.52 5.65 Total / Average 3.111 49,556,598.36 49,291,314.46 49,235,928.38 48,167,608.70 744 214,228.33 100 FHLMC Bond Local Government Investment Pool Municipal Bond Treasury Note FHLB Bond YTM @ Cost Cost Value Days to Maturity % of Portfolio Cash - 2,205,552 1 4.45% Certificate of Deposit 3.420 16,136,139 1,032 32.59% FAMC Bond 4.580 318,724 1,880 0.66% FFCB Bond 2.524 3,885,668 880 7.82% FHLB Bond 2.147 3,874,257 906 7.94% FHLMC Bond 0.500 200,000 253 0.40% LGIP 5.297 7,422,379 1 14.98% Municipal Bond 2.343 12,542,460 812 25.51% Treasury Note 3.644 2,706,134 809 5.65% Total / Average 3.111 49,291,314 744 100.00% CITY OF PRIOR LAKE, MINNESOTA Investment Portfolio - Diversification, by Security Type March 31, 2024 Description City of Prior Lake - Quarterly Investment Report Change from one 3/31/2023 6/30/2023 9/30/2023 12/31/2023 3/31/2024 year prior Market Value 12,699,977 20,061,417 18,176,651 14,734,627 9,627,932 (3,072,045) 1 1 1 1 1 0 4.31% 4.71% 4.89% 4.00% 4.08%-0.23% Fixed Income Assets 33,936,884 33,902,781 33,750,838 38,012,573 39,663,383 5,726,499 32,121,659 31,899,550 31,752,611 36,809,204 38,539,677 6,418,018 865 853 903 963 923 58 826 806 844 903 868 42 2.06% 2.16% 2.37% 2.78% 2.85%0.80% Total Portfolio Value 46,636,861 53,964,198 51,927,490 52,747,201 49,291,314 2,654,453 44,821,636 51,960,967 49,929,262 51,543,831 48,167,609 3,345,973 164,251 116,519 170,756 162,916 214,228 49,977 -1,815,225 -2,003,232 -1,998,228 -1,203,369 -1,123,706 691,519 630 536 587 695 744 114 601 506 549 652 699 98 2.67% 3.11% 3.25% 3.12% 3.09% 0.42% BENCHMARK 90 Day T-Bill 4.85% 5.43% 5.55% 5.40% 5.46% 0.61% 4.97%5.47%5.53%5.26%5.38%0.41% 4.94%5.40%5.46%4.79%5.03%0.09% Weighted Average Yield to Maturity @ Cost 6 Month Treasury 1 Year Treasury Cost Value Market Value Accrued Interest Unrealized Gain / Loss WAM (1) in Days WAM / Callable (1) in Days Weighted Average Yield to Maturity @ Cost CITY OF PRIOR LAKE, MINNESOTA Quarterly Investment Report March 31, 2024 Local Government Investment Pools / Money Market Quarterly WAM (1) in Days Weighted Average Yield to Maturity Cost Value Market Value WAM (1) in Days WAM / Callable (1) in Days City of Prior Lake - Quarterly Investment Report City of Prior Lake General Fund Summary - Comparison to Prior Year As of 3/31/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive (Negative)USED 3/31/2023 Positive (Negative) Revenues Taxes 14,047,266 14,047,266 - (14,047,266) 0%- - Licenses and Permits 617,238 617,238 313,463 (303,775) 51%100,892 212,571 Intergovernmental 3,348,632 3,348,632 1,029,594 (2,319,038) 31%902,296 127,298 Charges for Services 1,887,267 1,887,267 540,381 (1,346,886) 29%439,088 101,292 Fines and Forfeitures - - 20,505 20,505 n/a 557 19,948 Interest (losses) on investments 160,000 160,000 97,059 (62,941) 61%110,471 (13,412) Other 133,800 133,800 39,002 (94,798) 29%23,755 15,246 Transfers in 852,400 852,400 166,325 (686,075) 20%138,750 27,575 Total Revenues 21,046,603 21,046,603 2,206,328 (18,840,275) 10%1,715,809 490,519 Expenditures General Government 4,495,927 4,513,350 819,137 3,694,213 18%754,368 (64,769) Public Safety 10,828,082 10,911,499 1,955,269 8,956,230 18%1,661,536 (293,732) Public Works 2,847,321 2,937,321 478,090 2,459,231 16%515,438 37,348 Culture and Recreation 2,626,785 2,666,785 436,598 2,230,187 16%372,606 (63,992) Transfer to other funds 248,488 248,488 - 248,488 0%400,000 400,000 Total Expenditures 21,046,603 21,277,443 3,689,095 17,588,348 17%3,703,949 14,854 Net Change - (230,840) (1,482,767) (1,251,927) (1,988,140) COMPARATIVE City of Prior Lake General Fund Revenues As of 3/31/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 3/31/2023 Positive (Negative) Taxes 101 31010.00 Current Property Taxes - General Purpos 13,029,707 13,029,707 - (13,029,707) 0%- - 101 31020.00 Delinquent Property Taxes - General Purp - - - - n/a - - 101 31040.00 Fiscal Disparities 1,017,559 1,017,559 - (1,017,559) 0%- - Taxes 14,047,266 14,047,266 - (14,047,266) 0%- - Licenses and Permits 101 32100.00 Business Licenses 1,050 1,050 1,800 750 171%1,050 750 101 32110.00 Liquor Licenses 80,470 80,470 75 (80,395) 0%2,014 (1,939) 101 32120.00 Cannabis Fee - - 4,200 4,200 n/a - 4,200 101 32160.00 Refuse Haulers 5,000 5,000 - (5,000) 0%- - 101 32175.00 Public Private Gathering Permit - - 60 60 n/a 90 (30) 101 32180.00 Cigarette Licenses 2,295 2,295 2,295 - 100%2,295 - 101 32190.00 Community Event Application 5,000 5,000 1,930 (3,070) 39%1,980 (50) 101 32210.00 Building Permits 376,822 376,822 237,403 (139,419) 63%72,893 164,509 101 32215.00 Mechanical Permits 79,548 79,548 31,604 (47,945) 40%9,786 21,818 101 32230.00 Plumbing Permits 56,702 56,702 31,425 (25,278) 55%8,976 22,449 101 32231.00 Sewer/Water Inspection 4,916 4,916 818 (4,099) 17%763 55 101 32260.00 Burning Permits 4,000 4,000 1,400 3,000 35%840 560 101 32270.00 Short-term Rental Fee 1,435 1,435 455 (980) 32%205 250 Licenses and Permits 617,238 617,238 313,463 (303,775) 51%100,892 212,571 Intergovernmental 101 33416.01 State Aid - Police Train 30,000 30,000 - (30,000) 0%- - 101 33416.02 State Police Aid-Ins Prem 299,000 299,000 - (299,000) 0%- - 101 33417.00 State Aid - Fire Training 20,000 20,000 - (20,000) 0%- - 101 33418.00 State Road & Bridge Aid 467,000 467,000 246,635 (220,365) 53%227,207 19,429 101 33420.00 State Fire Aid-Ins. Prem.299,835 299,835 - (299,835) 0%- - 101 33422.11 State Aids/Grants - Operating Police 3,500 3,500 - (3,500) 0%- - 101 33620.00 Township Fire & Resc Aid 959,522 959,522 480,125 (479,397) 50%375,090 105,036 101 33621.00 Liaison Aid 69,775 69,775 - (69,775) 0%- - 101 33631.00 Payment in Lieu of Taxes 1,200,000 1,200,000 300,000 (900,000) 25%300,000 - 101 33700.23 Miscellaneous Grants - Capital Parks - - 2,834 2,834 n/a - 2,834 Intergovernmental 3,348,632 3,348,632 1,029,594 (2,319,038) 31%902,296 127,298 COMPARATIVE City of Prior Lake General Fund Revenues As of 3/31/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 3/31/2023 Positive (Negative) COMPARATIVE Charges for Services 101 31810.00 Franchise Taxes 559,000 559,000 - (559,000) 0%- - 101 34103.00 Zoning & Subdivision Fees 40,000 40,000 2,400 (37,600) 6%2,955 (555) 101 34104.00 Plan Check Fees 244,941 244,941 140,714 (104,227) 57%37,780 102,933 101 34105.00 Sale of Maps/Publications - Reports 500 500 10 (490) 2%20 (10) 101 34107.00 Assessment Searches - Reports 500 500 150 (350) 30%100 50 101 34108.00 Street Chip Seal Fee-New Development - - - - n/a 4,750 (4,750) 101 34109.00 Project Admin/Eng Fees 246,000 246,000 60,056 (185,944) 24%54,071 5,985 101 34203.00 Accident/Warrant Reports - Reports 200 200 50 (150) 25%317 (267) 101 34731.00 Adult League Fees 5,000 5,000 4,624 (376) 92%8,165 (3,541) 101 34732.00 Recreation Program Fees - Contracted 35,000 35,000 29,799 (5,201) 85%- 29,799 101 34735.00 Recreation Program Fees - Staff Run 65,000 65,000 64,406 (594) 99%70,076 (5,670) 101 34735.01 Recreation Program Fees - Club Prior 12,000 12,000 4,063 (7,937) 34%1,216 2,847 101 34760.01 Facility Rental - Regular 48,028 48,028 15,968 (32,060) 33%18,377 (2,409) 101 34760.87 Facility Rental - Lease 15,600 15,600 - (15,600) 0%- - 101 34761.00 Studio/Pavilion Rental 25,000 25,000 17,839 (7,161) 71%22,370 (4,531) 101 34762.00 Park Shelter Rental 20,000 20,000 4,182 (15,818) 21%66,669 (62,488) 101 34762.01 Boat Slip Rental 71,200 71,200 73,600 2,400 103%- 73,600 101 34765.01 Tower Leases - - 97,018 97,018 n/a 127,986 (30,967) 101 34765.87 Tower Leases - Lease 260,082 260,082 - (260,082) 0%- - 101 34780.00 Park Admission Fees 30,000 30,000 - (30,000) 0% - - 101 34783.00 City Contract Services 209,216 209,216 25,501 (183,715) 12%24,236 1,265 Charges for Services 1,887,267 1,887,267 540,381 (1,346,886) 29%439,088 101,292 Fines and Forfeitures 101 35101.00 County Court Fines - - 19,311 19,311 n/a - 19,311 101 35104.00 Prosecution Restitution - - 1,194 1,194 n/a 557 637 Fines and Forfeitures - - 20,505 20,505 n/a 557 19,948 Interest (losses) on investments 101 36210.00 Interest Earnings 180,000 180,000 94,008 (85,992) 52%72,756 21,252 101 36215.00 Amortization - Premium/Discount (20,000) (20,000) (12,219) 7,781 61%(6,156) (6,063) 101 36225.00 Unrealized Inv.Gain(Loss)- - 15,269 15,269 n/a 43,870 (28,601) Interest (losses) on investments 160,000 160,000 97,059 (62,941) 61%110,471 (13,412) Other Miscellaneous Revenues 101 36102.00 County Assess. Collection 4,000 4,000 - (4,000) 0%- - 101 36211.00 Developer Agreements 60,000 60,000 5,000 (55,000) 8%- 5,000 101 36212.00 Miscellaneous Revenue 69,800 69,800 22,037 (47,763) 32%20,789 1,248 101 36230.00 Contributions & Donations - - 70 70 n/a - 70 101 36230.11 Contributions - Shop with a Cop - - 250 250 n/a - 250 101 36230.13 Contributions and Donations - - 8,296 8,296 n/a 2,443 5,853 101 36230.33 Contributions - Charitable Gambling - - 2,000 2,000 n/a - 2,000 101 39102.00 Sale of Property - - 1,349 1,349 n/a 523 825 Other Miscellaneous Revenues 133,800 133,800 39,002 (94,798) 29%23,755 15,246 City of Prior Lake General Fund Revenues As of 3/31/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 3/31/2023 Positive (Negative) COMPARATIVE Other financing sources 101 39203.00 Transfer from Other Funds 852,400 852,400 166,325 (686,075) 20%138,750 27,575 Other financing sources 852,400 852,400 166,325 (686,075) 20%138,750 27,575 Total Revenues 21,046,603 21,046,603 2,206,328 (18,840,275) 10%1,715,809 490,519 City of Prior Lake General Fund Expenditures As of 3/31/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 3/31/2023 Positive (Negative) Function: General Government 41110.00 MAYOR & COUNCIL 83,227 83,227 19,629 63,598 24% 17,719 (1,910) 41130.00 ORDINANCE 5,000 5,000 463 4,537 9% 718 254 41320.00 ADMINISTRATION 393,124 393,124 98,891 294,233 25% 100,700 1,810 41330.00 BOARDS & COMMISSIONS 10,950 10,950 646 10,304 6% 1,184 538 41400.00 CITY CLERK 133,989 137,989 26,023 111,966 19% 25,161 (862) 41410.00 ELECTIONS 126,332 126,332 27,877 98,455 22% 457 (27,420) 41520.00 FINANCE 737,612 743,612 150,557 593,055 20% 119,514 (31,044) 41540.00 INTERNAL AUDITING 44,700 44,700 3,500 41,200 8% 4,500 1,000 41550.00 ASSESSING 258,575 258,575 755 257,820 0% - (755) 41610.00 LEGAL 267,214 267,214 39,957 227,257 15% 40,335 377 41820.00 HUMAN RESOURCES 364,352 364,352 68,686 295,666 19% 69,436 750 41830.00 COMMUNICATIONS 165,172 165,172 33,600 131,572 20% 32,875 (725) 41910.00 COMMUNITY DEVELOPMENT 397,650 397,650 48,276 349,374 12% 63,918 15,642 41920.00 INFORMATION TECHNOLOGY 605,413 612,836 146,313 466,523 24% 138,433 (7,880) 41940.00 FACILITIES - CITY HALL 902,617 902,617 153,963 748,654 17% 139,419 (14,545) Total - Function General Government 4,495,927 4,513,350 819,137 3,694,213 18% 754,368 (64,769) Function: Public Safety 42100.00 POLICE 7,165,532 7,228,932 1,317,087 5,911,845 18% 1,250,575 (66,512) 42200.00 FIRE 2,749,058 2,769,075 471,217 2,297,858 17% 242,262 (228,954) 42400.00 BUILDING INSPECTION 862,152 862,152 161,995 700,157 19% 162,967 971 42500.00 EMERGENCY MANAGEMENT 15,340 15,340 169 15,171 1% 932 763 42700.00 ANIMAL CONTROL 36,000 36,000 4,800 31,200 13% 4,800 - Total - Function Public Safety 10,828,082 10,911,499 1,955,269 8,956,230 18% 1,661,536 (293,732) Function: Public Works 43050.00 ENGINEERING 471,965 471,965 91,352 380,613 19% 74,675 (16,677) 43100.00 STREET 1,776,306 1,866,306 257,153 1,609,153 14% 321,155 64,002 43400.00 CENTRAL GARAGE 599,050 599,050 127,907 471,143 21% 119,234 (8,672) 43600.00 DEVELOPMENT PROJECTS - - 1,678 (1,678) n/a 374 (1,304) Total - Function Public Works 2,847,321 2,937,321 478,090 2,459,231 16% 515,438 37,348 Function: Culture and Recreation 45100.00 RECREATION 627,505 627,505 104,098 523,407 17% 79,718 (24,380) 45200.00 PARKS 1,966,606 2,006,606 326,226 1,680,380 16% 275,675 (50,551) 45500.00 LIBRARIES 32,674 32,674 6,274 26,400 19% 17,213 10,939 Total - Function Culture and Recreation 2,626,785 2,666,785 436,598 2,230,187 16% 372,606 (63,992) 80000.00 Transfer to Other Funds 248,488 248,488 - 248,488 0% 400,000 400,000 Total Expenditures 21,046,603 21,277,443 3,689,095 17,588,348 17%3,703,949 14,854 COMPARATIVE City of Prior Lake Expenditures- Personal Services Category Only (Payroll/Taxes/Benefits) As of 3/31/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 3/31/2023 Positive (Negative) GENERAL FUND Function: General Government 41110.00 MAYOR & COUNCIL 76,427 76,427 18,337 58,090 24% 15,766 (2,571) 41320.00 ADMINISTRATION 313,089 313,089 60,949 252,140 19% 58,466 (2,483) 41330.00 BOARDS & COMMISSIONS 10,550 10,550 646 9,904 6% 1,184 538 41400.00 CITY CLERK FUNCTIONS 130,660 130,660 25,456 105,204 19% 23,792 (1,664) 41410.00 ELECTIONS 112,832 112,832 23,658 89,174 21% - (23,658) 41520.00 FINANCE 704,542 704,542 135,205 569,337 19% 108,007 (27,197) 41820.00 HUMAN RESOURCES 316,502 316,502 60,629 255,873 19% 59,533 (1,096) 41830.00 COMMUNICATIONS 143,422 143,422 27,546 115,876 19% 25,849 (1,697) 41910.00 COMMUNITY DEVELOPMENT 348,850 348,850 46,766 302,084 13% 63,019 16,253 41920.00 INFORMATION TECHNOLOGY 256,283 256,283 50,332 205,951 20% 47,220 (3,112) 41940.00 FACILITIES - CITY HALL 101,693 101,693 20,311 81,382 20% 21,290 979 Total - Function General Government 2,514,850 2,514,850 469,836 2,045,014 19% 424,125 (45,710) Function: Public Safety 42100.00 POLICE 6,238,856 6,238,856 1,156,776 5,082,080 19% 1,069,893 (86,883) 42200.00 FIRE 2,354,931 2,354,931 381,621 1,973,310 16% 118,233 (263,388) 42400.00 BUILDING INSPECTION 830,502 830,502 156,224 674,278 19% 157,964 1,739 Total - Function Public Safety 9,424,289 9,424,289 1,694,622 7,729,667 18% 1,346,090 (348,532) Function: Public Works 43050.00 ENGINEERING 403,645 403,645 75,589 328,056 19% 70,853 (4,736) 43100.00 STREET 582,011 582,011 109,632 472,379 19% 117,968 8,337 43400.00 CENTRAL GARAGE 293,500 293,500 57,796 235,704 20% 57,618 (177) Total - Function Public Works 1,279,156 1,279,156 243,016 1,036,140 19% 246,440 3,424 Function: Culture and Recreation 45100.00 RECREATION 444,525 444,525 52,473 392,052 12% 47,477 (4,996) 45200.00 PARKS 1,253,181 1,253,181 208,572 1,044,609 17% 216,441 7,869 Total - Function Culture and Recreation 1,697,706 1,697,706 261,045 1,436,661 15% 263,918 2,873 General Fund Payroll Only Expenditures Total 14,916,001 14,916,001 2,668,519 12,247,482 18%2,280,573 (387,945) EDA FUND Function: Economic Development 46500.00 ECONOMIC DEVELOPMENT 163,834 163,834 24,067 139,767 15% 28,843 4,775 EDA Fund Payroll Only Expenditures Total 163,834 163,834 24,067 139,767 15%28,843 4,775 COMPARATIVE City of Prior Lake Expenditures- Personal Services Category Only (Payroll/Taxes/Benefits) As of 3/31/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 3/31/2023 Positive (Negative) COMPARATIVE WATER FUND Function: Water 41520.00 FINANCE 89,344 89,344 17,311 72,033 19% 16,536 (774) 49400.00 WATER 826,958 826,958 189,120 637,838 23% 202,356 13,236 Water Fund Payroll Only Expenditures Total 916,302 916,302 206,431 709,871 23%218,892 12,462 SEWER FUND Function: Sewer 41520.00 FINANCE 89,344 89,344 17,308 72,036 19% 16,533 (775) 49450.00 SEWER 869,044 869,044 139,550 729,494 16% 144,150 4,600 Sewer Fund Payroll Only Expenditures Total 958,388 958,388 156,857 801,531 16%160,682 3,825 STORM WATER FUND Function: Storm Water 49420.00 WATER QUALITY 370,250 370,250 47,125 323,125 13% 70,164 23,039 Storm Water Fund Payroll Only Expenditures Total 370,250 370,250 47,125 323,125 13%70,164 23,039 City-Wide Total Payroll Expenditures 17,324,775 17,324,775 3,102,999 14,221,776 18% 2,759,154 (343,844) City of Prior Lake Debt Service Funds As of 3/31/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 3/31/2023 Positive (Negative) Revenues Property Taxes Current Property Taxes 3,203,024 3,203,024 - (3,203,024) 0% - - Special Assessments City Assess. Collections - - 8,683 8,683 n/a 3,202 5,481 County Assess. Collection 640,649 640,649 - (640,649) 0% - - Interest (losses) on investments Interest Earnings 52,900 52,900 20,561 (32,339) 39% 16,743 3,818 Unrealized Inv.Gain(Loss) - - 2,214 2,214 n/a 10,343 (8,130) Other Financing Sources Transfer from Other Funds 1,010,990 1,010,990 - (1,010,990) 0% - - Total Revenues 4,907,563 4,907,563 31,457 (4,876,106) 1%30,288 1,169 Expenditures Debt Service Principal 4,202,801 4,202,801 - 4,202,801 0% - - Interest and Other 971,142 971,142 - 971,142 0% 4,500 4,500 Transfers to Other Funds 45,000 45,000 - 45,000 0% - - Total Expenditures 5,218,943 5,218,943 - 5,218,943 0%4,500 4,500 Net Change (311,380) (311,380) 31,457 25,788 COMPARATIVE City of Prior Lake Cable Fund As of 3/31/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 3/31/2023 Positive (Negative) Revenues Charges for Services 210-41340.00-34304.00 PEG Access Fees 17,100 17,100 - (17,100) 0% - - Interest (losses) on investments 210-41340.00-36210.00 Interest Earnings - - 906 906 n/a 632 274 210-41340.00-36225.00 Unrealized Inv. Gain (Loss) - - 99 99 n/a 391 (291) Total Revenues 17,100 17,100 1,005 (16,095) 6%1,022 (18) Expenditures Current Expenditures 210-41340.00-52400.20 Small Equipment - Technology 6,000 6,000 - 6,000 0% - - 210-41340.00-54020.00 Software Service Contract - - 3,576 (3,576) n/a 3,576 - Total Expenditures 6,000 6,000 3,576 2,424 60%3,576 - Net Change 11,100 11,100 (2,571) (2,554) COMPARATIVE City of Prior Lake Capital Park Fund As of 3/31/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 3/31/2023 Positive (Negative) Revenues Charges for Services 225-45200.00-34760.01 Facility Rental - Regular - - 6,000 6,000 n/a 6,000 - 225-45200.00-34760.87 Facility Rental - Lease 24,000 24,000 - (24,000) 0% - - 225-45200.00-34791.00 Dedication Fees 300,000 300,000 - (300,000) 0% 90,540 (90,540) Charges for Services 324,000 324,000 6,000 (318,000) 2% 96,540 (90,540) Interest (losses) on investments 225-00000.00-36210.00 Interest Earnings 30,600 30,600 14,519 (16,081) 47% 12,180 2,339 225-00000.00-36225.00 Unrealized Inv.Gain(Loss) - - 1,580 1,580 n/a 7,531 (5,950) Interest (losses) on investments 30,600 30,600 16,099 (14,501) 53% 19,711 (3,611) Contributions and donations 225-00000.00-36230.00 Contributions & Donations - - 2,300 2,300 n/a - 2,300 Contributions and donations - - 2,300 2,300 n/a - 2,300 Total Revenues 354,600 354,600 24,399 (330,201) 7%116,251 (91,851) Expenditures 225-45200.00-53100.80 Professional Services-General 5,000 5,000 5,000 - 100% 4,872 (128) 225-45200.00-55040.00-PRK23-000001 Projects - Property & ROW Acquisit'n - - 2,800 (2,800) n/a - (2,800) 225-45200.00-55050.00-TRN19-000004 Projects - Professional Services - - 9,255 (9,255) n/a 992 (8,263) 225-45200.00-55530.00 Infrastructure 300,000 300,000 - 300,000 0% 4,642 4,642 Total Expenditures 305,000 305,000 17,055 287,945 6%10,507 (6,548) Net Change 49,600 49,600 7,344 105,744 COMPARATIVE City of Prior Lake Revolving Equipment Fund As of 3/31/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 3/31/2023 Positive (Negative) Revenues Taxes 410-00000.00-31010.00 Current Property Taxes 800,000 800,000 - (800,000) 0%- - Taxes 800,000 800,000 - (800,000) 0%- - Interest (losses) on investments 410-00000.00-36210.00 Interest Earnings 14,500 14,500 6,859 (7,641) 47%6,142 717 410-00000.00-36225.00 Unrealized Inv.Gain(Loss)- - 1,662 1,662 n/a 3,655 (1,994) Interest (losses) on investments 14,500 14,500 8,521 (5,979) 59%9,798 (1,277) Sale of assets 410-00000.00-39102.00 Sale of Property - - 36,290 36,290 n/a - 36,290 Sale of assets - - 36,290 36,290 n/a - 36,290 Transfers in 410-00000.00-39203.00 Transfer from Other Funds - - 400,000 400,000 n/a 54,375 345,625 Transfers in - - 400,000 400,000 n/a 54,375 345,625 Total Revenues 814,500 814,500 444,811 (369,689) 55%64,173 380,638 COMPARATIVE City of Prior Lake Revolving Equipment Fund As of 3/31/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 3/31/2023 Positive (Negative) COMPARATIVE Public Safety Police 410-42100.00-55550.00 Vehicles 330,000 543,000 19,990 523,010 4%175,499 155,509 Fire 410-42200.00-55550.00 Vehicles - - 547,464 (547,464) n/a 20,373 (527,092) Building Inspection 410-42400.00-55550.00 Vehicles - 44,000 - - 0%- - Emergency Management 410-42500.00-55570.00 Machinery & Equipment 93,200 93,200 - - 0%- - Total Public Safety 423,200 680,200 567,454 (24,454) 83%195,872 (371,583) Public Works Street 410-43100.00-55550.00 Vehicles - - 66,544 (66,544) n/a - (66,544) 410-43100.00-55570.00 Machinery & Equipment 38,000 38,000 30,625 7,375 81%17,721 (12,904) Engineering 410-43050.00-55550.00 Vehicles 50,000 50,000 - - 0%- - Central Garage 410-43400.00-55550.00 Vehicles 25,000 25,000 - 25,000 0%- - Total Public Works 113,000 113,000 97,169 (34,169) 86%17,721 (79,448) Culture and Recreation/Parks 410-45200.00-55550.00 Vehicles - 347,500 140,574 206,926 40%797 (139,777) 410-45200.00-55570.00 Machinery and Equipment 328,000 328,000 96,603 231,397 29%235,759 139,156 Total Culture & Recreation 328,000 675,500 237,177 438,323 35%236,556 (621) Sewer 410-49450.00-55570.00 Machinery and Equipment - - - - n/a 1,615 1,615 Total Utility - - - - n/a 1,615 1,615 Total Expenditures 864,200 1,468,700 901,801 379,699 61%451,764 (450,037) Net Change (49,700) (654,200) (456,990) (387,591) City of Prior Lake Revolving Park Equipment Fund As of 3/31/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 3/31/2023 Positive (Negative) Revenues Taxes 430-00000.00-31010.00 Current Property Taxes 460,000 460,000 - (460,000) 0%- - Taxes 460,000 460,000 - (460,000) 0%- - Interest (losses) on investments 430-00000.00-36210.00 Interest Earnings 25,100 25,100 5,096 (20,004) 20%10,146 (5,050) 430-00000.00-36225.00 Unrealized Inv.Gain(Loss)- - 563 563 n/a 6,218 (5,655) Interest (losses) on investments 25,100 25,100 5,659 (19,441) 23%16,365 (10,705) Total Revenues 485,100 485,100 5,659 (479,441) 1%16,365 (10,705) Expenditures Culture and Recreation Dept 45200.00 - PARKS 430-45200.00-55020.00 Projects - Engineering - - - - n/a 42,750 42,750 430-45200.00-55530.00 Infrastructure 65,000 65,000 5,000 60,000 8%- (5,000) Total Culture & Recreation 65,000 65,000 5,000 60,000 8%42,750 37,750 Total Expenditures 65,000 65,000 5,000 60,000 8%42,750 37,750 Net Change 420,100 420,100 659 (26,385) COMPARATIVE City of Prior Lake Facilities Management Fund As of 3/31/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 3/31/2023 Positive (Negative) Revenues Taxes 440-00000.00-31010.00 Current Property Taxes 205,000 205,000 - (205,000) 0% - - Taxes 205,000 205,000 - (205,000) 0% - - Interest (losses) on investments 440-00000.00-36210.00 Interest Earnings 25,200 25,200 11,762 (13,438) 47% 9,874 1,887 440-00000.00-36225.00 Unrealized Inv.Gain(Loss) - - 1,539 1,539 n/a 6,147 (4,608) Interest (losses) on investments 25,200 25,200 13,301 (11,899) 53% 16,022 (2,721) Transfers in 440-00000.00-39203.00 Transfer from Other Funds 24,000 24,000 6,000 (18,000) 25% - 6,000 Transfers in 24,000 24,000 6,000 (18,000) 25% - 6,000 Debt Issued 440-00000.00-39310.00 G.O. Bond Proceeds 1,100,000 1,100,000 - (1,100,000) 0% - - Debt Issued 1,100,000 1,100,000 - (1,100,000) 0% - - Total Revenues 1,354,200 1,354,200 19,301 (1,334,899) 1%16,022 3,279 Expenditures Function: General Government 41940-55050.00 Projects Professional Svcs- FACILITIES - CITY HALL - - 15,176 (15,176) n/a 11,648 (3,528) 41940-55520.00 Building & Building Improvements-FACILITIES - CITY HALL 439,600 439,600 7,298 432,302 2% - (7,298) Total - Function General Government 439,600 439,600 22,474 417,126 5% 11,648 (10,826) Function: Public Safety 42100-55520.00 Building & Building Improvements-POLICE 81,000 181,000 17,964 163,036 10% - (17,964) 42200-55520.00 Building & Building Improvements-FIRE 178,600 178,600 6,090 172,510 3% 20,244 14,154 Total - Function Public Safety 259,600 359,600 24,054 335,546 7% 20,244 (3,810) Function: Public Works 43400.00 CENTRAL GARAGE 128,000 128,000 5,804 122,196 5% - (5,804) Total - Function Public Works 128,000 128,000 5,804 122,196 5% - (5,804) Function: Culture and Recreation 45200.00 PARKS 16,000 141,000 15,080 125,920 11% - (15,080) 45500.00 LIBRARIES 23,500 23,500 6,403 17,097 27% - (6,403) Total - Function Culture and Recreation 39,500 164,500 21,483 143,017 13% - (21,483) Total Expenditures 866,700 1,091,700 73,814 1,017,886 7%31,892 (41,923) Net Change 487,500 262,500 (54,514) (15,870) COMPARATIVE City of Prior Lake Permanent Improvement Revolving Fund As of 3/31/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 3/31/2023 Positive (Negative) Revenues Taxes 450-00000.00-31810.00 Franchise Taxes 1,080,000 1,080,000 - (1,080,000) 0%- - Taxes 1,080,000 1,080,000 - (1,080,000) 0%- - Special Assessments 450-00000.00-36101.00 City Assess. Collections - - 258 258 n/a 253 5 450-00000.00-36102.00 County Assess. Collection 580,666 580,666 - (580,666) 0%- - 580,666 580,666 258 (580,408) 0%253 5 Interest (losses) on investments 450-00000.00-36210.00 Interest Earnings 18,300 18,300 16,301 (1,999) 89%8,518 7,783 450-00000.00-36225.00 Unrealized Inv.Gain(Loss)- - 1,326 1,326 n/a 5,266 (3,940) Interest (losses) on investments 18,300 18,300 17,627 (673) 96%13,784 3,843 Transfers in 450-00000.00-39203.00 Transfer from Other Funds 1,850,000 1,850,000 - (1,850,000) 0%- - Transfers in 1,850,000 1,850,000 - (1,850,000) 0%- - Debt Issued 450-00000.00-39310.00 G.O. Bond Proceeds 1,696,200 1,696,200 - (1,696,200) 0%- - Debt Issued 1,696,200 1,696,200 - (1,696,200) 0%- - Total Revenues 5,225,166 5,225,166 17,885 (5,207,281) 0%14,037 3,848 Expenditures Function: Public Works 450-43100.00-55020.00-PIR24-000001 Projects - Engineering - - 61,733 (61,733) n/a 1,147 (60,586) 450-43100.00-55050.00-PIR24-000001 Projects - Professional Services - - 262 (262) n/a - (262) 450-43100.00-55530.00 Infrastructure 6,570,000 6,570,000 - (6,570,000) 0%- - Total - Function Public Works 6,570,000 6,570,000 61,995 (6,631,995) 1%1,147 (60,848) OTHER FINANCING USES Transfers out 450-80000.00-59203.00 Transfers to Other Funds 94,590 94,590 - 94,590 0%- - Total Expenditures 6,664,590 6,664,590 61,995 6,602,595 1%1,147 (60,848) Net Change (1,439,424) (1,439,424) (44,109) 12,890 COMPARATIVE City of Prior Lake Water Fund As of 3/31/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 3/31/2023 Positive (Negative) Revenues Operating Revenue Water Charges 601-49400.00-37100.00 Utility Receipts - Water 4,042,024 4,042,024 125,410 (3,916,614) 3%111,468 13,942 601-49400.00-37160.00 Penalties 20,000 20,000 1,908 (18,092) 10%1,136 772 4,062,024 4,062,024 127,318 (3,934,706) 3%112,604 14,714 Utility Base Fee 601-49400.00-37110.00 Utility Base Fee Revenue 1,374,903 1,374,903 78,806 (1,296,097) 6%71,483 7,323 1,374,903 1,374,903 78,806 (1,296,097) 6%71,483 7,323 Meter Sales 601-49400.00-37170.00 Water Meter Sales 79,825 79,825 15,506 (64,319) 19%10,034 5,473 601-49400.00-37175.00 Pressure Reducers 25,000 25,000 2,656 (22,344) 11%2,673 (17) 104,825 104,825 18,162 (86,663) 17%12,707 5,456 Total Operating Revenue 5,541,752 5,541,752 224,286 (5,317,466) 4%196,794 27,493 Non-Operating Revenue Interest (losses) on investments 601-00000.00-36210.00 Interest Earnings 117,300 117,300 70,507 (46,793) 60%48,073 22,435 601-00000.00-36225.00 Unrealized Inv.Gain(Loss)- - 6,033 6,033 n/a 27,674 (21,641) 117,300 117,300 76,540 (40,760) 65%75,746 794 Miscellaneous Revenues 601-00000.00-36212.00 Miscellaneous Revenue - - 15 15 n/a 10 5 - - 15 15 - 10 5 Total Non-Operating Revenue 117,300 117,300 76,555 (40,745) 65%75,756 799 Total Revenues 5,659,052 5,659,052 300,841 (5,358,211) 5%272,550 28,292 COMPARATIVE City of Prior Lake Water Fund As of 3/31/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 3/31/2023 Positive (Negative) COMPARATIVE Total Expenditures Personnel and current expenditures (excluding depreciation) 41520.00 Finance 124,805 124,805 25,795 99,010 21%20,975 (4,820) 49400.00 Water 2,911,360 2,911,360 469,324 (2,442,036) 16%526,033 56,709 3,036,165 3,036,165 495,118 2,541,047 16%547,008 51,890 Principal 601-49400.00-56010.00 Water 135,000 135,000 - 135,000 0%- - 135,000 135,000 - 135,000 0%- - Interest & other 601-49400.00-56110.00 Water 34,650 34,650 (1,540) 36,190 -4%(1,660) (120) 34,650 34,650 (1,540) 36,190 -4%(1,660) (120) Capital improvements 601-49400.00-55530.00 Infrastructure 75,000 75,000 190 74,811 0%465 276 601-49400.00-55570.00 Machinery and equipment 110,500 110,500 - 110,500 0%- - 185,500 185,500 190 185,311 0%465 276 Total Expenditures 3,391,315 3,391,315 493,768 2,897,547 545,813 52,045 Other Financing Sources Debt Issued 601-00000.00-39315.00 Projects - Bond Premium - - - - n/a 4,327 4,327 - - - - n/a 4,327 4,327 Total Other Financing Sources - - - - n/a 4,327 4,327 Other Financing Uses Transfers out 601-80000.00-59203.00 Transfers to other funds 2,713,650 2,713,650 134,750 2,578,900 5%82,938 (51,813) 2,713,650 2,713,650 134,750 2,578,900 5%82,938 (51,813) Total Other Financing Uses 2,713,650 2,713,650 134,750 2,578,900 5%82,938 (51,813) Total Revenues/ Other Financing Sources 5,659,052 5,659,052 300,841 (5,358,211) 5%276,877 32,619 Total Expenditures/Other Financing Uses 6,104,965 6,104,965 628,518 5,476,447 10%628,751 233 Net Change (445,913) (445,913) (327,676) 118,237 (351,873) 32,386 City of Prior Lake Sewer Fund As of 3/31/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 3/31/2023 Positive (Negative) Revenues Sewer Charges 604-49450.00-37102.00 Utility Receipts - Sewer 2,023,789 2,023,789 (97,882) (2,121,671) -5%(106,612) 8,729 604-49450.00-37104.00 Utility Recpt-Sewer MCES 2,106,431 2,106,431 288,109 (1,818,322) 14%292,036 (3,926) 604-49450.00-37160.00 Penalties - - 873 873 n/a 881 (8) 4,130,220 4,130,220 191,100 (3,939,120) 5%186,305 4,795 Capital Facility charges 604-49450.00-37110.00 Utility Base Fee Revenue 1,195,743 1,195,743 68,244 (1,127,499) 6%62,063 6,181 1,195,743 1,195,743 68,244 (1,127,499) 6%62,063 6,181 Total Operating Revenue 5,325,963 5,325,963 259,343 (5,066,620) 5%248,368 10,976 Non-Operating Revenue Interest (losses) on investments 604-00000.00-36210.00 Interest Earnings 70,000 70,000 35,246 (34,754) 50%28,367 6,879 604-00000.00-36225.00 Unrealized Inv.Gain(Loss)- - 1,626 1,626 n/a 14,987 (13,362) 70,000 70,000 36,872 (33,128) 53%43,355 (6,483) Total Non-Operating Revenue 70,000 70,000 36,872 (33,128) 53%43,355 (6,483) Total Revenue 5,395,963 5,395,963 296,215 (5,099,748) 5%291,722 4,493 COMPARATIVE City of Prior Lake Sewer Fund As of 3/31/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 3/31/2023 Positive (Negative) COMPARATIVE Total Expenditures Personnel and current expenditures (excluding depreciation) 41520.00 Finance 124,440 124,440 25,814 98,626 21%20,971 (4,843) 49450.00 Sewer 3,439,711 3,533,711 711,387 2,822,324 20%704,043 (7,343) 3,564,151 3,658,151 737,201 2,920,950 20%725,015 (12,186) Principal 604-49450.00-56010.00 Sewer 135,000 135,000 - 135,000 0%- - 135,000 135,000 - 135,000 0%- - Interest & other 604-49450.00-56110.00 Sewer 34,650 34,650 (1,540) 36,190 -4%(1,660) (120) 34,650 34,650 (1,540) 36,190 -4%(1,660) (120) Capital improvements 604-49450.00-55530.00 Infrastructure 1,500,000 1,500,000 10,996 1,489,004 1%- (10,996) 604-49450.00-55570.00 Machinery and equipment 440,000 440,000 6,402 433,598 1%28,261 21,859 1,940,000 1,940,000 17,398 1,922,602 1%28,261 10,863 Total Expenditures 5,673,801 5,767,801 753,059 5,014,742 751,615 (1,444) Other Financing Sources Debt Issued 604-00000.00-39315.00 Projects - Bond Premium - - - - n/a 4,327 4,327 - - - - n/a 4,327 4,327 Total Other Financing Sources - - - - n/a 4,327 4,327 Other Financing Uses 604-80000.00-59203.00 Transfers to other funds 247,000 247,000 134,250 112,750 54%82,688 (51,563) Total Other Financing Uses 247,000 247,000 134,250 112,750 54%82,688 (51,563) Total Revenues/ Other Financing Sources 5,395,963 5,395,963 296,215 (5,099,748) 5%296,050 8,820 Total Expenditures/Other Financing Uses 5,920,801 6,014,801 887,309 5,127,492 15%834,303 (53,006) Net Change (524,838) (618,838) (591,094) 27,744 (538,253) 61,827 City of Prior Lake Water Quality Fund As of 3/31/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 3/31/2023 Positive (Negative) Revenues Storm Water Charges 602-49420.00-37120.00 Storm Water Revenue 1,510,793 1,510,793 90,179 (1,420,614) 6%76,062 14,117 1,510,793 1,510,793 90,179 (1,420,614) 6%76,062 14,117 Water Charges 602-49420.00-37160.00 Penalties 4,000 4,000 256 (3,744) 6%253 3 4,000 4,000 256 (3,744) 6%253 3 Total Operating Revenue 1,514,793 1,514,793 90,436 (1,424,357) 6%76,315 14,121 Non-Operating Revenue Interest (losses) on investments 602-00000.00-36210.00 Interest Earnings 41,100 41,100 24,470 (16,630) 60%15,675 8,794 602-00000.00-36225.00 Unrealized Inv.Gain(Loss)- - 2,060 2,060 n/a 9,031 (6,971) 41,100 41,100 26,529 (14,571) 65%24,706 1,824 Miscellaneous Revenues 602-49420.00-33422.10 State Aids/Grants - Operating Grants - - 4,354 (4,354) n/a - (4,354) - - 4,354 (4,354) n/a - (4,354) Total Non-Operating Revenue 41,100 41,100 30,883 (18,924) 75%24,706 (2,530) Total Revenues 1,555,893 1,555,893 121,319 (1,443,281) 8%101,021 11,591 COMPARATIVE City of Prior Lake Water Quality Fund As of 3/31/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 3/31/2023 Positive (Negative) COMPARATIVE Total Expenditures Personnel and current expenditures (excluding depreciation) 49420.00 Water Quality 674,800 674,800 61,353 613,447 9%128,097 66,744 674,800 674,800 61,353 613,447 9%128,097 66,744 Capital improvements 602-49420.00-55050.00 Projects - Professional Services - - 8,912 (8,912) n/a - 602-49420.00-55530.00 Infrastructure 1,708,000 1,708,000 213,279 1,494,721 12%94,532 (118,747) 1,708,000 1,708,000 222,191 1,485,809 13%94,532 (118,747) Total Expenditures 2,382,800 2,382,800 283,544 2,099,256 12%222,629 (52,004) Other Financing Uses 602-80000.00-59203.00 Transfers to other funds 113,300 113,300 136,325 (23,025) 120%27,500 (108,825) Total Other Financing Uses 113,300 113,300 136,325 (23,025) 120%27,500 (108,825) Total Revenues/ Other Financing Sources 1,555,893 1,555,893 121,319 (1,443,281) 8%101,021 11,591 Total Expenditures/Other Financing Uses 2,496,100 2,496,100 419,869 2,076,231 17%250,129 (160,829) Net Change (940,207) (940,207) (298,551) 632,949 (149,108) (149,238) City of Prior Lake Economic Development Authority Special Revenue Fund As of 3/31/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 3/31/2023 Positive (Negative) Revenues Taxes 240-00000.00-31010.00 Current Property Taxes 364,000 364,000 - (364,000) 0% - - 240-00000.00-31040.00 Fiscal Disparities 26,000 26,000 - (26,000) 0% - - Taxes 390,000 390,000 - (390,000) 0% - - Charges for Services 240-46500.00-34760.02 Facility Rental - EDA 24,588 24,588 9,375 (15,213) 38% 8,196 1,179 Charges for Services 24,588 24,588 9,375 (15,213) 38% 8,196 1,179 Interest (losses) on investments 240-00000.00-36210.00 Interest Earnings 3,700 3,700 3,649 (51) 99% 1,972 1,678 240-00000.00-36225.00 Unrealized Inv.Gain(Loss) - - 716 716 n/a 1,132 (416) Interest (losses) on investments 3,700 3,700 4,365 665 118% 3,104 (1,262) Total Revenues 418,288 418,288 13,740 (404,548) 3%11,300 2,441 Expenditures Function: Economic Development 46500.00 ECONOMIC DEVELOPMENT 649,834 649,834 293,831 356,003 45% 50,259 (243,572) Total Expenditures 649,834 649,834 293,831 356,003 45%50,259 (243,572) Net Change (231,546) (231,546) (280,090) (38,959) COMPARATIVE S:\Council Reports\2024\0514\2024 Street Project - Change Order\20240423 Change Order No. 1.docx Page 1 Change Order No. 1 Date of Issuance: May 14, 2024 Effective Date: May 14, 2024 Owner: City of Prior Lake Owner's Contract No.: CP 2024-01 Contractor: McNamara Contracting Contractor’s Project No.: Engineer: WSB Engineer's Project No.: 022048-000 Project: 2024 Street Improvement Project Contract Name: NA The Contract is modified as follows upon execution of this Change Order: Description: The following work and line items shall be added to the contract to be completed in accordance with the contract documents. PART A - SIDEWALK Item Description Unit Qty Unit Price Total Price 1 Remove Concrete Walk SF 8825 $2.00 $17,650.00 2 6” Concrete Walk SF 8825 $14.35 $126,638.75 3 Turf Establishment SY 25 $21.00 $525.00 SUBTOTAL A $144,813.75 PART B – STORM SEWER IMPROVEMENTS Item Description Unit Qty Unit Price Total Price 1 Mobilization for Storm Sewer LS 1 $2,000.00 $2,000.00 2 Bituminous Removal SY 140 $15.50 $2,170.00 3 Curb Removal LF 25 $10.00 $250.00 4 Remove Storm Sewer LF 118 $15.50 $1,829.00 5 Connect to Storm Sewer EACH 2 $2,000.00 $4,000.00 6 Install 18” RCP Storm Sewer LF 118 $90.00 $10,620.00 7 Saw Cut Bit LF 240 $3.50 $840.00 8 Prep for Bit SY 140 $5.00 $700.00 9 Bit Patching (Base Course Only) SY 140 $21.00 $2,940.00 SUBTOTAL B $25,349.00 PART C – MISCELLANEOUS Item Description Unit Qty Unit Price Total Price 1 Valve box top section replacement EACH 2 $500.00 $1,000.00 2 Valve box top and mid section replacement EACH 2 $615.00 $1,230.00 3 Connect drain tile EACH 1 $800.00 $800.00 SUBTOTAL C $3,030.00 CHANGE ORDER GRAND TOTAL $173,192.75 Attachments: NA S:\Council Reports\2024\0514\2024 Street Project - Change Order\20240423 Change Order No. 1.docx Page 2 CHANGE IN CONTRACT PRICE CHANGE IN CONTRACT TIMES [note changes in Milestones if applicable] Original Contract Price: Original Contract Times: Substantial Completion: NA $ 4,449,242.78 Ready for Final Payment: days or dates [Increase] [Decrease] from previously approved Change Orders No. to No. : [Increase] [Decrease] from previously approved Change Orders No. to No. : Substantial Completion: NA $ NA Ready for Final Payment: days Contract Price prior to this Change Order: Contract Times prior to this Change Order: Substantial Completion: NA $ 4,449,242.78 Ready for Final Payment: days or dates Increase of this Change Order: [Increase] [Decrease] of this Change Order: Substantial Completion: NA $ 173,192.75 Ready for Final Payment: days or dates Contract Price incorporating this Change Order: Contract Times with all approved Change Orders: Substantial Completion: NA $ 4,622,435.53 Ready for Final Payment: days or dates RECOMMENDED: ACCEPTED: ACCEPTED: By: By: By: Engineer (if required) Owner (Authorized Signature) Contractor (Authorized Signature) Title: Title : Title : Date: Date : Date : Page 1 of 2 Public Works Consultant Pool Work Order TH13 Trail Segment 1 (CR42 to Oakland Beach Ave SE) (CP 2025-02) WSB & ASSOCIATES, INCORPORATED, dba WSB This work order (“Work Order”) is issued on this 14th day of May, 2024 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 in accordance with a schedule set by the City Engineer. 3. Compensation for Work Order. City agrees to pay the Consultant a fixed sum of $428,746 as full and complete payment for the Work requested by this Work Order. 4. Consultant Representative. Consultant has designated Monica Heil to manage the Work Order subject to the supervision of Consultant’s representative. ISSUED BY CITY OF PRIOR LAKE ___________________________________ Mayor ___________________________________ City Manager RECEIVED AND ACCEPTED BY WSB & ASSOCIATES, INC. _____________________________________ Signature ____________________________________ Title Page 2 of 2 Exhibit 1 – Scope of Work Order G:\.Clients All\Prior Lake\Proposals\2024 Segment No 1 TH 13 Trail\LTR PROP_Trunk Highway 13 Trail Segment 1 - Egan Drive to Oakland Beach Ave_.docx 1 7 8 E 9 T H S T R E E T | S U I T E 2 0 0 | S A I N T P A U L , M N | 5 5 1 0 1 | 6 5 1 . 2 8 6 . 8 4 5 0 | W S B E N G . C O M March 26th, 2024 Mr. Andy Brotzler, P.E. Director of Public Works/City Engineer City of Prior Lake 17073 Adelmann St. SE Prior Lake, MN 55372 Re: Proposal to Provide Professional Engineering Services Trunk Highway 13 Trail Connection Project – Egan Drive to Oakland Beach Ave. Dear Mr. Brotzler: WSB is pleased to provide you with our proposal for professional services for the preparation of construction documents and contract administration services for the Trunk Highway 13 Trail Connection. The proposed improvements include construction of a separated bituminous trail from Egan Drive to Oakland Beach Ave. The City has been awarded federal funding for the construction of the trail segment during the 2025 construction season. WSB has recently provided services to the City providing an alternatives analysis/decision matrix for two different trail alignments to connect the trail from Egan Drive to Oakland Beach Ave. This proposal assumes the barrier separated trail option with retaining wall adjacent to the lake is the preferred alternative alignment for the trail. Scope of Services Generally, the scope of services will include geotechnical evaluations, preparation of construction documents including plans and specifications, preparation of environmental documentation required for federal funds, bidding assistance, and contract construction administration services. For specifics on deliverables associated with each task, please review Exhibit C.1. Task 1.0: Geotechnical Exploration WSB will perform geotechnical exploration and evaluation to identify general soil information in the project corridor consisting of the following items: •Geotechnical Field Work and Evaluation Report •Access site with CME-55 truck mounted auger drill rig •Perform four (2) soil borings to depth of about 14.5 feet below grade – there is an assumed 2 borings near the highway. •If borings are extended due to unsuitable soils at termination depths (organics, fills, etc .), additional depth may be required at additional cost per foot. •We will utilize flashing lights, signage, and cones for traffic control and allow traffic to self- regulate around our work zone. •Samples retrieved during drilling will be returned to our laboratory where they will be reviewed, classified using the Unified Soil Classification System (USCS) and logged under the direction of a geotechnical engineer. •Select samples will be set aside for laboratory testing. We may perform routine laboratory tests on selected soil samples obtained from the exploration. •WSB will complete Gopher State One Call (GSOC) utility clearance to have public underground utilities marked. •Private utilities are the responsibility of the utility owner to mark, and WSB should be notified of any private underground utilities that are onsite. EXHIBIT 1 Mr. Andy Brotzler, P.E. March 26, 2024 Page 2 G:\.Clients All\Prior Lake\Proposals\2024 Segment No 1 TH 13 Trail\LTR PROP_Trunk Highway 13 Trail Segment 1 - Egan Drive to Oakland Beach Ave_.docx • Some damage could occur to greenspace areas from normal drilling mobilization and operations. Our proposed services do not include restoration of the site to pre- conditions. • Due to recent roadway improvements in the project corridor, no borings will be taken within the bituminous pavement surfaces. • Based on the proposed boring depths to depths (< 15 feet), MDH well sealing notification and fees will not be required. If the borings are extended to a depth of 15 feet or more, additional fees will be charged. • WSB will prepare a geotechnical report with discussion of subsurface soil and groundwater conditions and how they may affect the construction being proposed. Deliverables • Geotechnical report. Task 2.0: Right of Way Determination and Acquisition The right of way acquisition services will be provided in accordance with the Uniform Relocation Assistance and Real Property Acquisition Policies Act of 1970, as amended, and other applicable state and federal laws and rules. Project Management/Acquisition Agent • WSB will coordinate and complete all work tasks, establish, and monitor budgets, attend conference call meetings and be the point of contact for all correspondence with the City. Monthly parcel status reports will be provided, along with a detailed contact log for the impacted parcels upon completion of the acquisition. Communication will be maintained with the City throughout the process to quickly and efficiently resolve any issues or concerns that arise which, in turn, keeps the project on schedule. Pre-Acquisition Services • Early Notification Letters will be sent to the owners to introduce our staff and inform them of the upcoming project. We will include a contact information form so they can respond with the best contact numbers and times they are available to meet as well as the required Guidebook for Property Owners. • Field Title Reports will include an on-site visit with the owners, if they are available to meet. Our agent will view the parcel, discuss the project, gather ownership interests, and verify improvements that may be impacted by the project. Acquisition Services • Offer letters and supporting documents will be prepared and presented to the owners in person, if possible, or by Certified Mail if we are unable to meet them in person. Offer packets will include an offer letter, summary statement, landowner rights broch ure and the conveyance documents. • Negotiations will be conducted in good faith with the property owners to reach an agreement that is fair to the owner and the City as well. City staff will be contacted on any owner issues in an effort to resolve or minimize impacts. Upon settlement, easements will be obtained. If a settlement is reached that is higher than the offer, administrative settlements will be prepared and submitted to the City for approval. Upon Mr. Andy Brotzler, P.E. March 26, 2024 Page 3 G:\.Clients All\Prior Lake\Proposals\2024 Segment No 1 TH 13 Trail\LTR PROP_Trunk Highway 13 Trail Segment 1 - Egan Drive to Oakland Beach Ave_.docx completion, the original files will be delivered to the City. Negotiations will continue through the title and possession date. Valuation Services: • WSB will contract with Valbridge Property Advisors to conduct the appraisal reports. • WSB will contract with Foster Appraisals, Inc. to conduct the review appraisal report. Parcel Exhibits • WSB’s survey group will prepare parcel exhibits, legal descriptions, and stake easement areas. Right of Way Certificate Assistance: • WSB staff will provide documentation and assistance to the City to prepare for the file audit related to this project including preparing the ROW Certificate #1 for state audit. Deliverables • Ownership and Encumbrance reports • AutoCAD files with proposed easements/right of way • Tabulation for right of way process • Easement and right of way sketch and descriptions • Early notification letters • Valuation reports and reviews • Offer packages • Executed conveyance documents • Payment requests • Summary information for condemnation parcels • Right of Way Certificate #1 Task 3.0 Final Design, Plans, Topographic Survey and Specifications WSB will prepare construction documents (plans and specifications) accordance with the City's engineering requirements and trail design requirements as published within the 2019 Federal Highway Administration Bicycle and Pedestrian Planning, Program, and Project Development Manual and the Trail Planning, Design, and Development Guidelines as published by the Minnesota Department of Natural Resources. This process will also include performing utility coordination, securing necessary permits, and performing a QA/QC and constructability review. GSOC Coordination and Design Meeting WSB will coordinate and prepare a meeting agenda and minutes for the design utility coordination meeting as required by Minnesota Statute 216D. This meeting notice will be sent to all affected private utility owners located in the project limits. Our staff will perform a GSOC design request for private utility maps, field markings for the topographic survey Topographic Survey WSB will use topography survey to develop an existing conditions base map including survey points, line work and existing ground surface. Plans Mr. Andy Brotzler, P.E. March 26, 2024 Page 4 G:\.Clients All\Prior Lake\Proposals\2024 Segment No 1 TH 13 Trail\LTR PROP_Trunk Highway 13 Trail Segment 1 - Egan Drive to Oakland Beach Ave_.docx The plans will generally include the following sheets (or combined items on sheets) for the proposed improvements: • Title sheet • General Layout plan • Statement of Estimated Quantities • Construction Notes • Typical Sections • Standard Details • Construction Plans (removals, plan and profile, utility, traffic control, ADA) • Structural retaining wall drawings • Temporary and permanent erosion control plans • Cross Sections Project Manual WSB will prepare the Project Manual (city format) including • Advertisement for Bids • Instructions to Bidders • General and Supplemental Conditions • Agreements • Bonds • Cost Proposals • Special provisions • Any other documents as required by federal funds. Kick-Off Meeting WSB will coordinate and hold a kick-off meeting and a100%/pre-bid meeting review with City Staff prior to beginning design work on the project. Permits WSB will coordinate and obtain all permits necessary for construction. Current permits anticipated include WCA, MnDNR, USACE, MPCA construction stormwater general permit, a MnDOT ROW permit for the construction of the trail, and an erosion control permit from the Prior Lake Spring Lake Watershed District. QA/QC Plan Review WSB will conduct a comprehensive QA/QC plan review to ensure all applicable engineering standards and trail grant requirements are met as published in the Local Trail Connections Program manual. This review will also include a cursory review of the plans by an employee of WSB’s transportation group as it relates to MnDOT requirements for construction of improvements within the MnDOT Trunk Highway right of way. For purposes of this cost proposal, it is assumed that only a MnDOT right of way permit will be required. If a cooperative construction agreement is required as a part of this project, WSB will need to amend this scope of work to include more hours for coordination and review/signatures by MnDOT’s functional groups. Constructability Review WSB will perform a constructability review, in which a member of the WSB construction team will review the plans and specifications in their entirety for constructability to evaluate risks associated with construction and potential risk mitigation measures that can be implemented. Deliverables • Meeting agenda, meeting minutes, and summary memos for GSOC meeting. • Construction drawings (30%, 60%, 90%, and 100% design stages) Mr. Andy Brotzler, P.E. March 26, 2024 Page 5 G:\.Clients All\Prior Lake\Proposals\2024 Segment No 1 TH 13 Trail\LTR PROP_Trunk Highway 13 Trail Segment 1 - Egan Drive to Oakland Beach Ave_.docx • Draft and final project manual. • Meeting agenda, meeting minutes, and summary memos for design meetings. • Final executed permits. • QA/QC plan review checklist. Task 4.0: Categorical Exclusion Preparation Since the project has received federal funding, a programmatic Categorical Exclusion (CATEX) document is anticipated. As part of the document development, the WSB team will distribute early coordination letters with MnDOT and MnDNR to identify potential historic and archaeological resources as well as state and federal threatened and endangered species. Of particular interest to this project, which is likely to include some tree clearing – the northern long eared bat has been recently designated as endangered, which will result in changes in tree clearing activities. Along with the early coordination letters, the WSB team will complete a scan regarding the potential for contaminated materials through review of on-line databases. Using the information from the letters, database searches and information from the wetland delineation, a draft CATEX document will be prepared for review by the city and MnDOT. Revisions will be made based upon comments received and will be updated and submitted for signature. It is anticipated that coordination will be needed with MnDOT on the preparation of the CATEX due to the trail’s location/proximity to TH 13. Meeting time with MnDOT environmental staff is included in the hours for the development of the document. Attendance at regular project team meetings is also included. Should early coordination letters indicate the need for further investigations on particular resources (e.g., potential archaeological site), the WSB team will coordinate with the reviewing agencies and the city to understand additional work scope. Deliverables: • Draft CATEX for review • Final CATEX for signature and submittal Task 5.0: Final Cost Estimate WSB will prepare a final engineer’s opinion of probable construction cost based upon the final tabulated quantities and estimated unit costs for each pay item. Deliverables: • Engineer’s opinion of probable cost. Task 6.0: Project Bidding WSB will assist the City in establishing a bid opening time, date and location and prepare the necessary notices and publications for advertisement. During the bidding phase of the project, WSB staff will lead responses to plan holders that have pre-bid questions, clarifications, issue addenda (if necessary) and open the bids. WSB will prepare bid tabulations, bid summary and recommendation letter for consideration of awarding a contract. When the City awards the construction contract, WSB will assist in preparing and executing project contracts, bonds, and insurance with the selected contractor. Deliverables: • Notices and publications. • Summary of Q & A from bidding. • Bid tabulations. • Award recommendation letter. Mr. Andy Brotzler, P.E. March 26, 2024 Page 6 G:\.Clients All\Prior Lake\Proposals\2024 Segment No 1 TH 13 Trail\LTR PROP_Trunk Highway 13 Trail Segment 1 - Egan Drive to Oakland Beach Ave_.docx • Executed contracts, bonds, and insurance. Task 7.0: Construction Administration WSB will provide all services necessary to effectively administer the contract to ensure compliance with construction contract plans and specifications. This task generally includes on site construction survey, inspection and construction materials testing including: • General coordination, progress reports, invoices, and billing. • Quality control/quality assurance. • Preconstruction conference. • Daily inspection. • Construction survey and staking. • Site progress meetings. • Submittal and shop drawing reviews and approvals. • Responding to contractor requests for information and questions. • Tabulating in place material quantities and items of work and preparing construction pay applications for review by the contractor and the City. • Generating a punchlist of remaining contractual obligations and ensuring the completion of the items contained within the punchlist by the contractor. • Providing as-built construction drawings after construction completion. Deliverables: • Preconstruction agenda, meeting invites, and meeting minutes. • Site progress meeting agenda and minutes. • Approval submittals and shop drawings. • Daily inspection logs and weekly reports. • Draft and final contractor pay applications for City Council approval. • Project punchlists. • Project closeout documentation. For purposes of estimating on-site inspection effort, WSB has assumed 16 weeks of active construction inspection at 50 hours per week. Compensation Summary Our fees for the scope of services is proposed on an hourly basis, estimated as summarized below. The fee estimate is provided in a detailed format on the enclosed Estimated Project Fees Worksheet. ▪ Task 1: Geotechnical Exploration $8,591 ▪ Task 2: Right of Way Determination and Acquisition $18,676 ▪ Task 3: Final Design, Plans, and Specifications $156,998 ▪ Task 4: Categorical Exclusion Preparation $25,723 ▪ Task 5: Final Cost Estimate $8,142 ▪ Task 6: Project Bidding $8,855 ▪ Task 7: Construction Administration $178,361 Reimbursable Expenses Permit Fees • NPDES $400 • MnDNR $400 • MnDOT ROW $250 Mr. Andy Brotzler, P.E. March 26, 2024 Page 7 G:\.Clients All\Prior Lake\Proposals\2024 Segment No 1 TH 13 Trail\LTR PROP_Trunk Highway 13 Trail Segment 1 - Egan Drive to Oakland Beach Ave_.docx Materials Testing $14,000 Ownership and Encumbrance Reports $750 Appraisals – Valbridge $6,500 Appraisal Review – Foster Appraisals $1,100 Total Fee $428,746 Assumptions The following assumptions were made while preparing this proposal: • There are 3 parcels on this project with fee, permanent and/or temporary easement acquisitions. • Right of Way negotiations will continue until the title and possession date. Any services requested beyond that date would be billed at our standard hourly rates. • Eminent domain services include providing documentation to the County. If additional services are needed, the contract would be amended to include those services. • Assumes 16 weeks of active construction administration at 50 hours/week for construction inspection and materials testing. This is the level of effort assumed to be needed to perform construction observation during active construction hours along with completing all documentation and paperwork necessary for use of federal funds. Thank you for the opportunity to provide professional services to the City of Prior Lake for the Trunk Highway 13 Trail Connection Project. Feel free to contact me if you have any questions. Sincerely, WSB Monica Heil, P.E. Vice President of Municipal Services (952) 737-4675 MHeil@wsbeng.com Attachments cc: Nick Monserud, PE, City of Prior Lake Kelvin Howieson, WSB /pgs Senior Transportation Municipal Geotechnical Senior Structural Structural Transportation Right of Way Right of Way Right Quality Principal Project Contract Construction Project Project Engineering Project Geotechnical and Project Project Planning Sr.Transportation Transportation GIS Wetland Wetland Wetland Project QA/QC of Way Admin Water WR Manager Office 2-Person Total Manager Administrator Observer Engineer Engineer Technician Engineer Drill Rig Crew Engieer Engieer Lead Plannner Plannner Lead Support Delineator Manager Agent Agent Support Resources EIT QA/QC Survey Survey Crew Hours Fee Scope of Services Phase/Task Description Monica Heil Kelvin Howieson Marcus VanderBrug Shannon Heitmann Brad Caron Mark Osborn Jeremy Burke Stan Hill Jack Corkle Austin Hauf Daniil/Kaylynn Taylor Kaatz Alison Harwood Roxy Robertson Dustin Simonson Faye Gillespie Ben Barker Benton Johnson Amy Rein Laura Rescorla Garrett Nic Hentges 1.0 Geotechnical Evaluation 1.0.1 Project Management 1 1 237.00$ 1.0.2 Geotechnical Evaluation 39 8 47 8,354.00$ Soil borings (assumed 2 near roadway and 2 in wetland) Geotechnical report Deliverables: Geotechnical Report Subtotal 1 39 8 48 8,591.00$ 2.0 Right of Way Determination and Acquisition 2.0.1 Project Management 2 12 14 2,490.00$ 2.0.2 Pre-Acquisition Services 3 1 18 22 3,243.00$ Early notification letters Field title reports On site visit with property owners 2.0.3 Acquisition Serivces 3 1 4 741.00$ Offer letters and supporting documents Good faith negotiations 2.0.4 Valuation Services 3 30 33 4,674.00$ Appraisal reports (subconsultant) Appraisal report review (subconsultant) 2.0.5 Parcel Exhibits 24 12 36 6,816.00$ Preparation of sketch and legal description documents Staking of easement areas 2.0.6 Right of Way Certificate 1 2 1 4 712.00$ Preparation of Right of Way Certificate #1 for state audit Deliverables: Ownership and Encumbrance reports AutoCAD files with proposed easements/right of way Tabulation for right of way process Easement and right of way sketch and descriptions Early notification letters Valuation reports and reviews Offer packages Executed conveyance documents Payment requests Summary information for condemnation parcels Subtotal 3 23 2 49 24 12 113 18,676.00$ 3.0 Final Design, Plans, Topographic Survey and Specifications 3.0.0 Topographic Survey 7 24 31 7,113.00$ 3.0.1 Project Management 4 22 12 2 40 8,718.00$ 3.0.2 GSOC Coordination 4 8 12 2,356.00$ 3.0.3 GSOC Meeting 7 8 15 3,067.00$ 3.0.4 Plans 16 150 26 114 32 72 16 72 498 86,038.00$ Title Sheet General Layout Statement of Quantities/Notes Construction Details Standard Drawings Miscellaneous Details Construction Plans (removals, plan and profile, utility, traffic control, ADA) Structural Retaining Wall Plans and Details Stormwater Pollution and Prevention Plan (SWPPP) Cross Sections 3.0.5 Project Manual (city format)5 32 12 8 4 12 73 12,061.00$ 3.0.6 Design Meetings 14 16 2 4 2 2 40 7,784.00$ Design meeting 1 (Design kick-off)-$ 3.0.7 Constructability Review 6 24 44 74 11,600.00$ 3.0.8 QA/QC Plan Review 4 16 16 36 7,844.00$ 3.0.9 Permits 6 2 42 50 6,492.00$ 3.0.9 Wetland Delineation 5 2 22 29 3,925.00$ Deliverables: Meeting agenda, meeting minutes, and summary memos for GSOC meeting Construction drawings (30%, 60%, 90%, 100%) Draft and final project manual Meeting agenda, meeting minutes, and summary memos for design meetings Final executed permits, TEP meeting and wetland delineation QA/QC plan review checklist Subtotal 4 72 6 226 44 114 48 72 11 4 64 8 48 130 16 7 24 898 156,998.00$ 4.0 Categorical Exclusion Preparation 4.0.1 Project Management 5 10 15 3,555.00$ 4.0.2 Categorical Exclusion Preparation 10 30 104 14 158 22,168.00$ Early coordination letters with MnDOT and MnDNR Review of potential contaminated materials Coordination with MnDOT Attendance at project team meetings Deliverables: Draft CATEX for review Final CATEX for signature and submittal Subtotal 5 20 30 104 14 173 25,723.00$ 5.0 Final Cost Estimate 5.0.1 Project Management 3 4 4 11 2,191.00$ 5.0.2 Engineer's Opinion of Probable Cost 3 10 10 4 2 4 33 5,951.00$ Deliverables: Engineer's opinion of probable cost Subtotal 6 14 14 4 2 4 44 8,142.00$ 6.0 Project Bidding 6.0.1 Project Management 4 2 4 4 14 2,986.00$ 6.0.2 Project Bidding and Award 5 10 10 8 33 5,869.00$ Schedule bid opening time, date, and location Prepare notices and publications Answer questions during bid phase Prepare bid tabulations Prepare award recommendation Contracts, bonds, and insurance Deliverables: Notices and publications Summary of Q & A during bidding Bid tabulations Award recommendation Executed contracts, bonds, and insurance Subtotal 4 7 14 14 8 47 8,855.00$ 7.0 Construction Administration 7.0.1 Project Management 6 6 64 16 92 17,354.00$ General coordination Progress reports, invoices, and billing Labor compliance Quality control/quality assurance 7.0.2 On-Site Construction Survey, Inspection and Materials Testing 60 805 4 6 40 915 149,603.00$ Property Owner Coordination Meeting (assumed 1 meeting) Preconstruction Conference Daily Inspection Construction Staking Site Progress Meetings Submittals and Shop Drawings Contractor Questions/Answers Pay Applications 7.0.3 Final Close-out 30 12 10 10 62 11,404.00$ Project Closeout and As-Built Plans Punchlist Estimated Hours City of Prior Lake, MN Senior Transportation Municipal Geotechnical Senior Structural Structural Transportation Right of Way Right of Way Right Quality Principal Project Contract Construction Project Project Engineering Project Geotechnical and Project Project Planning Sr.Transportation Transportation GIS Wetland Wetland Wetland Project QA/QC of Way Admin Water WR Manager Office 2-Person Total Manager Administrator Observer Engineer Engineer Technician Engineer Drill Rig Crew Engieer Engieer Lead Plannner Plannner Lead Support Delineator Manager Agent Agent Support Resources EIT QA/QC Survey Survey Crew Hours Fee Estimated Hours Ensure that the project is completed consistent with approved plans and all required documents are filed. Deliverables: Preconstruction agenda, meeting invites, meeting minutes Site progress meeting agenda and minutes Approved submittals and shop drawings Daily inspection logs and weekly reports Draft and final contractor pay applications for Council approval Project punchlists Project closeout documentation report and as-built drawings Subtotal 6 6 154 817 10 10 4 16 6 40 1069 178,361.00$ Total 14 100 160 817 264 82 114 39 8 56 72 20 30 104 14 11 4 64 23 2 49 32 50 134 16 37 76 2392 405,346.00$ Grand Total Hours 14 100 160 817 264 82 114 39 8 56 72 20 30 104 14 11 4 64 23 2 49 32 50 134 16 37 76 2392 Hourly Rate 258.00$ 237.00$ 194.00$ 157.00$ 176.00$ 194.00$ 177.00$ 166.00$ 235.00$ 156.00$ 177.00$ 237.00$ 164.00$ 123.00$ 149.00$ 207.00$ 147.00$ 118.00$ 168.00$ 237.00$ 139.00$ 123.00$ 180.00$ 139.00$ 237.00$ 159.00$ 250.00$ Grand Total Direct Labor Costs 3,612.00$ 23,700.00$ 31,040.00$ 128,269.00$ 46,464.00$ 15,908.00$ 20,178.00$ 6,474.00$ 1,880.00$ 8,736.00$ 12,744.00$ 4,740.00$ 4,920.00$ 12,792.00$ 2,086.00$ 2,277.00$ 588.00$ 7,552.00$ 3,864.00$ 474.00$ 6,811.00$ 3,936.00$ 9,000.00$ 18,626.00$ 3,792.00$ 5,883.00$ 19,000.00$ 405,346.00$ Reimbursable Expenses - Permit Fees: NPDES 400.00$ MnDNR Permit 400.00$ MnDOT Right-of-Way 250.00$ Materials Testing 14,000.00$ Ownership and Encumbrance Reports 750.00$ Appraisals - Valbridge 6,500.00$ Appraisal Review - Foster Appraisals 1,100.00$ Subtotal Expenses 23,400.00$ Total Fee (Hourly estimated fee) 428,746.00$ Assumptions Assumes 3 parcels on this project with fee, permanent and/or temporary easement acquisitions. Right of Way negotiations will continue until the title and possession date. Any services requested beyond that date would be billed at our standard hourly rates shown above. Eminent domain services include providing documentation to the City. If additional services are needed, the contract would be amended to include those services. Assumes 16 weeks of active construction administration for 50 hours/week for construction inspection and materials testing. This is the level effort that is assumed to be needed to perform construction observation during active construction along with completing all paperwork and documentation necessary for use of Federal Funds. K: \ 0 2 0 1 2 7 - 0 0 0 \ A d m i n \ D o c s \ F Y 2 0 2 4 C o m m u n i t y P r o j e c t F u n d i n g A p p l i c a t i o n \ A t t a c h m e n t s \ A t t a c h m e n t A - P r o j e c t L o c a t i o n M a p Attachment A: Project Location Map Prior Lake, Minnesota March 2023 TH 13 Existing trail connection to middle schools Planned future trail segment along west side of TH 13 CSAH 42 / Egan Dr 160th St LOWER LOWER PRIOR LAKEPRIOR LAKE DOWNTOWN DOWNTOWN PRIOR LAKEPRIOR LAKE Existing Three Rivers Park District Big Woods Regional TrailCSA H 2 1 / Eagle C r e e k A v e Large commercial developments on north end of trail corridor Existing trail connection to high school 150th St LAKEFRONT LAKEFRONT PARKPARK PROPOSED TRAIL (CPF FUNDING REQUEST) EXISTING TRAIL PROPOSED TRAIL (FUTURE) Number of Permits Declared Value Number of Permits Declared Value Single Family Dwellings 7 $3,437,790.00 7 $3,169,373.00 Townhouses (# units)0 $0.00 0 $0.00 Multiple Units 0 $0.00 0 $0.00 New Commercial Industrial & Commercial 1 $1,500,000.00 0 $0.00 Residential 120 $2,788,652.36 101 $2,136,888.56 Industrial & Commercial 1 $316,000.00 2 $637,739.00 Mechanical & Plumbing 85 $0.00 42 $0.00 Mechanical (SF&TH)28 $0.00 28 $0.00 TOTALS 242 $8,042,442.36 180 $5,944,000.56 Number of Permits Declared Value Number of Permits Declared Value Single Family Dwellings 22 $10,470,645.00 21 $9,676,198.00 Townhouses (# units)0 $0.00 0 $0.00 Multiple Units 1 $28,733,056.00 0 $0.00 New Commercial Industrial & Commercial 1 $1,500,000.00 0 $0.00 Residential 280 $8,085,884.03 209 $3,697,595.61 Industrial & Commercial 6 $2,033,748.00 11 $703,739.00 Mechanical & Plumbing 306 $0.00 184 $0.00 Mechanical (SF & TH)88 $0.00 84 $0.00 TOTALS 704 $50,823,333.03 509 $14,077,532.61 Summary of Fees Collected APRIL 2024 APRIL 2023 YTD 2024 YTD 2023 General Fund $79,837.79 $76,471.09 $518,232.13 $206,669.37 Trunk Reserve Fund $14,490.00 $14,385.00 $457,470.00 $36,945.00 Water Storage Fund $0.00 $0.00 $0.00 Water and Sewer Fund $5,490.00 $7,070.00 $25,674.51 $20,330.00 Metro Council SAC $17,395.00 $17,395.00 $549,185.00 $44,730.00 State Surcharge $2,549.93 $2,335.54 $10,867.08 $6,244.10 Builders Fees and Deposits $16,700.00 $20,200.00 $59,800.00 $60,237.50 TOTAL $136,462.72 $137,856.63 $1,621,228.72 $375,155.97 Beverly Alexander Beverly Alexander, Development Services Assistant CITY OF PRIOR LAKE BUILDING PERMIT SUMMARY APRIL 1, 2024 - APRIL 30, 2024 New Residential APRIL 2024 APRIL 2023 2024 YEAR TO DATE 2023 YEAR TO DATE New Residential Additions and Alterations Additions and Alterations  Mechanical permits include but are not limited to furnaces, water heaters, softeners, and fireplaces. They are flat-rate permit fees.  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.