Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
July 16, 2024
F "n,, Shakopee City Council July 16, 2024 7:00 PM City Hall, 485 Gorman St. Vision: Shakopee is a place where people want to be! A distinctive river town, with a multitude of business, cultural and recreational opportunities in a safe, welcoming and attractive environment for residents and visitors. Mission: Our mission is to deliver high quality services essential to maintaining a safe and sustainable community. We commit to doing this cost-effectively, with integrity and transparency. Key strategies: 1. Financial stability 2. Enhancing community strengths 3. Effective public services 4. Communication Mayor Matt Lehman presiding 1. Ro11 Ca11 2. Pledge of Allegiance 3. Approval of Agenda 4. Consent Business - (All items listed in this section are anticipated to be routine. After a discussion by the Mayor there will be an opportunity for members of the Council to remove any items from the consent agenda for individual discussion. Those items removed will be considered following the Public hearing portion of the agenda. Items remaining on the Consent Agenda will not be discussed and will be approved in one motion.) A. Administration *4. A.1. *City Council Minutes *4. A.2. *Approve a Temporary Liquor License for Joe Schleper Stadium Fund *4. A.3. *Approve 3.2 On Sale, Wine and Sunday Liquor Licenses for Tommy's Malt Shop *4. A.4. *Approval of Settlement Agreement with RJM *4. A.5. *Minnesota Department of Safety's DWI/Traffic Safety Officer Program Grant Application B. Engineering *4. B.1. *Approve Professional Engineering Consulting Pool Page 1 of 120 *4. B.2. *Approve Consent to Improvements with Xcel Energy for Wood Duck Trail Improvements *4. B.3. *Approve Parking Restrictions along Hentges Way C. Fire *4. C.1. *Furniture for Fire Station 1 Remodel D. Planning and Development *4. D.1. *Ordinance Adding language to City Code reference to allow for automatic updating for Building Codes *4. D.2. *Award Bids for Jackson Commons Park Development E. Police *4. E.1. *Surplus Property 5. RECOGNITION OF INVOLVED RESIDENTS BY CITY COUNCIL- Provides an opportunity for the public to address the Council on items which are not on the agenda. Comments should not be more than five minutes in length. The Mayor may adjust that time limit based upon the number of persons seeking to comment. This comment period may not be used to make personal attacks, to air personality grievances, to make political endorsements or for political campaign purposes. Council Members will not enter into a dialogue with citizens, and questions from Council will be for clarification only. This period will not be used to problem solve issues or to react to the comments made, but rather for informational purposes only. 6. Business removed from consent will be discussed at this time 7. General Business A. Administration 7. A.1. Monthly Financial Review - June 2024 B. Parks and Recreation 7. B.1. Acceptance of Donations and Sponsorship Funds 8. Reports B.A. City Bill List 8.B. Liaison and Administration 9. Other Business 10. Adjournment to Tuesday, August 6, 2024 at 7 p.m. Page 2 of 120 *4.A.1. Shakopee City Council July 16, 2024 FROM: Lori J. Hensen, City Clerk TO: Mayor and Council Members Subject: City Council minutes from July 2, 2024. Policy/Action Requested: Approve the minutes of July 2, 2024. Recommendation: Approve the minutes of July 2, 2024. Discussion: Budget Impact: ATTACHMENTS: a July 2, 2024 Page 3 of 120 Shakopee City Council Minutes July 2, 2024 7:00 PM City Hall, 485 Gorman St. Mayor Matt Lehman presiding 1. Roll Call Present: Mayor Matt Lehman, Council Members Jay Whiting, Angelica Contreras, Jim DuLaney, Jesse Lara Staff Present: City Administrator Bill Reynolds, Assistant City Administrator Chelsea Petersen, City Attorney Jim Thomson, City Engineer Alex Jordan, Finance Director Nate Reinhardt, City Clerk Lori Hensen, Planning/Development Director Michael Kerski, Fire Chief Mike Nelson, Park/Recreation Director Kelsi McNutt, Public Works Director Bill Egan, Police Chief Jeff Tate 2. Pledge of Allegiance 3. Approval of Agenda Reynolds added 3.A. A moment of silence for Mark Pink, 3.B. Shakopee of Excellence Award, 3.C. Rep. Tabke, and remove 4.E.2. from the agenda. Council Member Jesse Lara made a motion to approve the modified agenda, second by Council Member Angelica Contreras and the motion passed. 5-0 4. Consent Business - (All items listed in this section are anticipated to be routine. After a discussion by the Mayor there will be an opportunity for members of the Council to remove any items from the consent agenda for individual discussion. Those items removed will be considered following the Public hearing portion of the agenda. Items remaining on the Consent Agenda will not be discussed and will be approved in one motion.) Lehman removed 4.A.2. for further discussion. Council Member Jay Whiting made a motion to approve the modified consent agenda, second by Council Member Angelica Contreras and the motion passed. 5-0 A. Administration *4. A.1. *City Council Minutes Page 4 of 420 Approve the minutes of June 18, 2024. *4. A.2. *2024 Budget Amendments Council Member Jay Whiting made a motion to approve 2024 budget amendments in accordance with the attached document titled "2024 Proposed Budget Amendments"., second by Council Member Angelica Contreras and the motion passed. 5-0 *4. A.3. *Minnesota Department of Public Safety's Pathways to Policing Program Grant Award Amendment Adopt Resolution R2024-101, accepting the Minnesota Department of Public Safety's (MN DPS) Pathways to Policing (PTP) program grant award and authonzmg the City Administrator to execute the necessary contracts, agreements, and/or amendments to existing contracts and agreements applicable to accepting this award. B. Engineering *4. B.1. *Approve Change Order for Sandventure Watermain Improvements Approve Change Order for Sandventure Watermain Improvements in the amount of $198,009.56. *4. B.2. *Approve a Partial Release of Escrow and Payment Agreement for Southbridge 3rd Addition Approve a Partial Release of Escrow and Payment Agreement for Lot 8, Block 33, Southbridge 3rd Addition. *4. B.3. *Award a Contract for the Downtown ADA, Lighting and Tree Rehab Proj ect Adopt Resolution R2024-099, accepting bids and awarding a contract in the amount of $901,284.70 to Pember Companies, Inc., for the Downtown ADA, Lighting and Tree Rehab Improvement Project. C. Fire *4. C.1. *Scott County Fire Service and Equipment Mutual Aid Agreement Approve a modification to clarify language, terminology, and response expectations in the Scott County Fire Service and Equipment Mutual Aid Agreement. *4. C.2. *Hire and Promote Three Full -Time Fire Captains Approve the hiring of Tim Nordstrom and Justen Riley and the promotion of Rob Indrebo to the position of Fire Captain at Pay Grade 180, Step 6 ($100,984). D. Parks and Recreation Page S of 420 *4. D.1. 2024-2025 SYHA Concession Agreement To approve the 2024-2025 Concession Agreement with the Shakopee Youth Hockey Association. D.2. Scott County Work Experience Program Contract Approve the Scott County Work Experience Program Worksite contract. E. Planning and Development *4. E.1. *Registered Land Survey (RLS) — Culver's Restaurant Adopt Resolution R2024-100,approving the requested RLS for property located at the southeast corner of 12th Avenue East and Canterbury Road. *4. E.2. *Ordinance Adding language to City Code reference to allow for automatic updating for Building Codes Item removed from agenda. 5. RECOGNITION OF INVOLVED RESIDENTS BY CITY COUNCIL - Provides an opportunity for the public to address the Council on items which are not on the agenda. Comments should not be more than five minutes in length. The Mayor may adjust that time limit based upon the number of persons seeking to comment. This comment period may not be used to make personal attacks, to air personality grievances, to make political endorsements or for political campaign purposes. Council Members will not enter into a dialogue with citizens, and questions from Council will be for clarification only. This period will not be used to problem solve issues or to react to the comments made, but rather for informational purposes only. 6. Business removed from consent will be discussed at this time See item 4.A.2. 7. Recess for Economic Development Authority Meeting Council Member Jesse Lara made a motion to recess to EDA, second by Council Member Jim DuLaney and the motion passed. 5-0 8. Reconvene 9. General Business A. Police Page 8 of 420 9. A.1. Shakopee Mdewakanton Intergovernmental Aid Agreement Renewal Council Member Jay Whiting made a motion to renew Intergovernmental Aid Agreement, second by Council Member Angelica Contreras and the motion passed. 5-0 10. Reports 10. A. City Bill List Informational only 10. B. Liaison and Administration 11. Other Business 12. Adjournment to Tuesday, July 16, 2024 at 7 p.m. Council Member Jesse Lara made a motion to adjourn to Tuesday, July 16, 2024, at 7:00 pm, second by Council Member Jim DuLaney and the motion passed. 5-0 Page df of 420 *4.A.2. Shakopee City Council July 16, 2024 FROM: Heidi Emerson, Deputy City Clerk TO: Mayor and Council Members Subject: Approve a Temporary Liquor License for the Joe Schleper Stadium Fund Men's State Amateur Baseball Tournament. Policy/Action Requested: Approve a temporary liquor license for the Joe Schleper Stadium Fund Men's State Amateur Baseball Tournament event being held August 16 - August 18, 2024, at Joe Schleper Stadium. Recommendation: Approve the above requested motion. Discussion: Joe Schleper Stadium Fund has submitted an application for a temporary liquor license for the Men's State Amateur Baseball Tournament being held August 16 - August 18, 2024, at Joe Schleper Stadium. Joe Schleper Stadium Fund currently has a 3.2 Beer license, but the temporary liquor license will allow them to serve strong beer and liquor at the event. The application is in order and the fees have been paid. Budget Impact: Page 8 of 120 *4.A.3. Shakopee City Council July 16, 2024 FROM: Heidi Emerson, Deputy City Clerk TO: Mayor and Council Members Subject: Approve 3.2 On -Sale, Wine and Sunday Liquor Licenses for Tommy's Malt Shop Policy/Action Requested: Approve 3.2 on -sale, wine and Sunday liquor licenses for Tommy's Malt Shop located at 1101 Adams Street South. Recommendation: Approve the above motion. Discussion: Staff has received applications for 3.2 on -sale, Wine and Sunday liquor licenses for Tommy's Malt Shop, located at 1101 Adams Street South. The applications are in order and the fees have been paid. All inspections will be required to be approved before the license will be issued. The Police Department has conducted a background investigation and found nothing that would prohibit issuance of the license. Budget Impact: Page 9 of 120 *4.A.4. Shakopee City Council July 16, 2024 FROM: William H. Reynolds, City Administrator TO: Mayor and Council Members Subject: Settlement Agreement and Release with RJM Policy/Action Requested: Approve Settlement Agreement and Release. Recommendation: Approval. Discussion: RJM was removed from the SandVenture project in January 2024 after multiple perfoiiiiance issues. However, RJM had conducted work and expended sums on the project and should be compensated for those efforts and expenditures. This agreement between the city and RJM will finalize those payments and will finalize our relationship. Budget Impact: The $270,000 payment for services performed to date of separation by RJM will come from the SandVenture Construction account. ATTACHMENTS: o Settlement Agreement and Release with RJM Page 10 of 120 SETTLEMENT AGREEMENT AND RELEASE This SETTLEMENT AGREEMENT AND RELEASE ("Settlement Agreement") is made and entered into as of the 15th day of July, 2024, among and between the City of Shakopee ("City") and RJM Construction, LLC ("RJM") (collectively, "the Parties"). RECITALS A. The City and RJM have a dispute ("Dispute") regarding payment for services RJM performed for the City relating to the Sandventure Park Redevelopment project ("Project"). B. The City and RJM mediated the Dispute on June 5, 2024. After the mediation session was concluded, the mediator recommended a settlement proposal to the Parties. The City and RJM desire to enter into this agreement accepting the settlement proposal recommended by the mediator. C. The City and RJM are mutually desirous of resolving the Dispute and any other outstanding claims between the Parties relating to the Project pursuant to the terms of this Settlement Agreement. NOW, THEREFORE, in consideration of the mutual promises and undertakings contained in this Settlement Agreement, the City and RJM agree as follows: AGREEMENT 1. Mediated Settlement.The Parties acknowledge and agree that they have been advised by their counsel, and the mediator, that this is a binding agreement relating to settlement of claims as reached through the process of mediation. The Parties further acknowledge that, pursuant to the requirements of the Minnesota Civil Mediation Act, they have been advised that: a. the mediator, Paul Rocheford, has no duty to protect either of their interests or to provide them with any information about their legal rights; b. signing a mediated settlement agreement may adversely affect their legal rights; c. the Parties may, and in fact have, consulted with an attorney before signing this Agreement in order that they may be certain of their rights; d. this is a mediated settlement reached pursuant to the provisions and requirements of the Minnesota Civil Mediation Act and case law interpreting the same; e. the Parties understand and acknowledge that it is a binding and conclusive resolution pursuant to the terms of this Agreement; and f. the Parties have reached final agreement with the assistance of the mediator. 2. Payment. On or before July 31, 2024, the City will pay RJM $270,000.00 for all services performed by RJM for the City relating to or arising out of the Project. This payment is in addition to all previous payments made by the City to RJM. 1 SH155-501-962856.v1 Page 11 of 120 3. Release of Claims. The Parties, for and on behalf of themselves, their officers, directors, shareholders, insurers, agents, representatives, attorneys and their successors, subrogees and assigns, release, acquit, and forever discharge each other, and their respective officers, directors, shareholders, managers, partners, employees, agents, representatives, and attorneys, and their respective successors, subrogees and assigns from any and all causes of action, claims, damages, debts, demands, expenses, judgments, liabilities, or losses, whether known or unknown, liquidated or unliquidated, fixed, contingent, direct or indirect, legal or equitable, and whether sounding in tort, contract, equity, or otherwise, in any way arising out of or relating to services performed by RJM relating in any manner to the Project. 4. Non -disparagement. The City and RJM agree to use reasonable and good faith efforts to ensure that they will not engage in any vilification of the other party. The City and its representatives and RJM and its representatives shall refrain from making any false, negative, or disparaging statements, express or implied, whether orally or in writing, to any person whatsoever, about each other or about each other's directors, officers, elected officials, or employees. Provided, however, that nothing in this Agreement shall prohibit either party from disclosing information that is required to be disclosed in compliance with applicable laws or regulations or by order of a court or other regulatory body of competent jurisdiction. 5. Further Assurances. If any additional instruments are necessary or desirable to accomplish the purpose of this Settlement Agreement, such additional instruments will be promptly executed and delivered upon request. 6. Attorneys' Fees, Costs and Expenses. The Parties waive any claim against each other for attorneys' fees, costs, and expenses to the extent not otherwise provided for in this Settlement Agreement. It is the intent of the Parties that each Party shall bear their own attorneys' fees, costs, and expenses. 7. Representations and Warranties of the Parties. Each party to this Settlement Agreement warrants and represents to each of the other party as follows: a. The parties to this Settlement Agreement have received independent legal advice from attorneys of their own choosing with respect to the advisability of executing this Settlement Agreement, and prior to the execution of this Settlement Agreement by each party, such party's attorneys reviewed this Settlement Agreement at length and made all desired changes. b. Except as expressly stated in this Settlement Agreement, no party to this Settlement Agreement has made any statement or representation to any other party to this Settlement Agreement regarding any fact relied upon by such other party in entering into this Settlement Agreement, and each party specifically does not rely upon any statement, representation, or promise of the other party in executing this Settlement Agreement, except as expressly stated in this Settlement Agreement. There are no other agreements or understanding between the parties, except as stated in this Settlement Agreement. 2 Page 12 of 120 c. Each party to this Settlement Agreement, together with its attorneys, has made such investigation of the facts pertaining to this Settlement Agreement, and of all other matters pertaining thereto, as it deems necessary. d. The terms of this Settlement Agreement are contractual, not a mere recital, and this Settlement Agreement is the result of negotiations between the parties to this Settlement Agreement, each of which has participated in the drafting of this Settlement Agreement through their respective attorneys. e. This Settlement Agreement has been carefully read by, and its contents are known and understood by, and it is signed freely by each person executing this Settlement Agreement. f. Each party to this Settlement Agreement has the power and authority to enter into and perform this Settlement Agreement, and the execution and performance of this Settlement Agreement has been duly authorized by all requisite corporate or other appropriate organizational action. g. Each party to this Settlement Agreement agrees that such party will not take any action that would interfere with the performance of this Settlement Agreement by the other parties or that would adversely affect any of the rights provided for in this Settlement Agreement. 8. Integration. This Settlement Agreement represents a single, integrated, written contract expressing the entire agreement of the parties hereto with respect to the subject matter hereof. No covenants, agreements, representations, or warranties of any kind whatsoever have been made by any party to this Settlement Agreement, except as expressly set forth in this=Settlement Agreement. All prior discussions and negotiations have been and are merged into, and are superseded by, this Settlement Agreement. This Settlement Agreement may not be supplemented, changed, or modified orally and may be modified only by written agreement executed by each of the parties. The Recitals of the parties, as set forth above, constitute an integral part of this Settlement Agreement. 9. No Admission of Liability. The Parties agree and acknowledge that this settlement is a compromise of disputed claims and that each Party expressly denies any and all liability in response to the claims asserted by the other or any violation of any law, contractual obligation or other agreement existing between the Parties. 10.Severability. If any part of this Agreement shall be determined to be void and unenforceable, the remainder of this Agreement shall remain in full force and effect. 11. Governing Law; Venue. This Settlement Agreement shall be construed in accordance with, and governed by, the internal laws of the State of Minnesota, without regard to any choice of law rules. 12. Construction. The terms of this Settlement Agreement shall be construed in an evenhanded manner as between the parties. If it is determined that there is a lack of clarity or ambiguity as regards to any of the language of this Settlement Agreement, the issue of the meaning of such language shall be resolved in a manner consistent with the relevant terms of the=Settlement Agreement and without regard to authorship. 3 Page 13 of 120 13. Execution in Counterparts and Electronic Signatures. This Settlement Agreement may be executed and delivered in two or more counterparts, including electronic counterparts, each of which, when so delivered, shall be an original; but such counterparts shall together constitute but one and the same instrument and agreement. This Settlement Agreement shall be deemed to be executed upon the last day any such counterpart is executed. The parties have caused this Settlement Agreement to be executed by their duly authorized representatives as of the date set forth above. City of Shakopee By Its Mayor By Its City Administrator 4 RJM Construction, LLC By Its Page 14 of 120 *4.A.5. Shakopee City Council July 16, 2024 FROM: Andrea Harrell, Grants/Special Projects Coordinator TO: Mayor and Council Members Subject: Minnesota Department of Safety's DWI/Traffic Safety Officer Program Grant Application Policy/Action Requested: Adopt Resolution R2024-104, approving an application to the Minnesota Department of Public Safety's (MN DP S) DWI/Traffic Safety Officer (DWI/TSO) program grant. Recommendation: Adopt Resolution R2024-104. Discussion: The MN DP S's DWI/TSO program awards funding to law enforcement agencies to hire an officer to work during peak nights and times when data indicates impaired driving will most likely occur. While primarily seeking to detect and interdict impaired drivers, the DWI/TS Officer will also focus on the dangerous driving behaviors of speeding, distracted driving, and occupant protection. The Shakopee Police Department was awarded this grant in 2022 and 2023, and is applying to continue receiving funding. The previous years' funding allowed the Shakopee PD to hire a DWI/TS Officer, but funding will end in September 2024. Data is currently and will continue to be collected to analyze the effectiveness of the program. The funding has been and will be utilized to provide the officer's salary, benefits, and overtime relating to duties performed within the scope of this grant. Budget Impact: A 0% match is required. However, as a commitment to the program, grant administration costs, vehicle mileage costs, and/or agency expenses incurred will be used as a match. ATTACHMENTS: Resolution R2024-104 Page 15 of 120 a Resolution R2023-075 Award Page 16 of 120 RESOLUTION R2024-104 A RESOLUTION OF THE CITY OF SHAKOPEE, MINNESOTA APPROVING THE CITY TO SUBMIT MINNESOTA DEPARTMENT OF PUBLIC SAFETY'S DWI/TRAFFIC SAFETY OFFICER PROGRAM GRANT APPLICATION WHEREAS, the City of Shakopee supports the application to the Minnesota Department of Public Safety's DWI/Traffic Safety (TS) Officer program grant. WHEREAS, the application is to obtain funding to continue the employment of the DWI/TS Officer position for one year, and WHEREAS, the City of Shakopee recognizes a 0% match is required. However, vehicle mileage costs, and/or agency expenses will be incurred and provided as a match. NOW, THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF SHAKOPEE, MINNESOTA AS FOLLOWS: if the City of Shakopee is awarded a grant by MN Department of Safety, the City of Shakopee agrees to accept the grant award and may enter into an agreement with MN Department of Safety for the above -referenced project. The City of Shakopee will comply with all applicable laws, requirements, and regulations as stated in the grant agreement. Adopted in the regular session of the City Council of the City of Shakopee, Minnesota, held this 16th day of July 2024. Prepared by: City of Shakopee 485 Gorman Street Shakopee, MN 55379 Matt Lehman, Mayor of the City of Shakopee ATTEST: Lori Hensen City Clerk Page 17 of 120 RESOLUTION R2023-075 A RESOLUTION OF THE CITY OF SHAKOPEE, MINNESOTA APPROVING THE MINNESOTA DEPARTMENT OF PUBLIC SAFETY'S DWI/TRAFFIC SAFETY OFFICER GRANT AWARD AGREEMENT WHEREAS, the City of Shakopee applied to the Minnesota Department of Public Safety's DWI/Traffic Safety Officer grant, previously approved via Resolution R2023-065 on the 6`h day of June 2023, and WHEREAS, the grant award is to provide funding to employ a police officer to work during peak nights and times when data indicates impaired driving will most likely occur, and WHEREAS, the City of Shakopee was awarded the DWI/Traffic Safety Officer grant for $126,806.24, and WHEREAS, the City of Shakopee recognized a 0% match is required, but will provide any administration, vehicle mileage, and/or agency expenses incurred as a match. NOW, THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF SHAKOPEE, MINNESOTA AS FOLLOWS: the City of Shakopee recognizes it has been awarded a grant by the Minnesota Department of Public Safety and agrees to accept the grant award and grant agreement for the above -referenced project. The City of Shakopee will comply with all applicable laws, requirements, and regulations as stated in the grant agreement. Adopted in the regular session of the City Council of the City of Shakopee, Minnesota, held this 5th day of July 2023. Prepared by: City of Shakopee 485 Gorman Street Shakopee, MN 55379 Matt Lehman, Mayor of the City of Shakopee ATTEST: ti Lori Henserl'/° City Clerk Page 18 of 120 *4.B.1. Shakopee City Council July 16, 2024 FROM: Alex Jordan, City Engineer TO: Mayor and Council Members Subject: Professional Engineering Consulting Pool Policy/Action Requested: Adopt Resolution R2024-102, Approving the Professional Engineering Consulting Pool for 2024, 2025, 2026 and 2027. Recommendation: Adopt Resolution R2024-102. Discussion: At its December 1, 2020 meeting, the City Council approved a three-year professional engineering consulting pool for 2021 through 2023 consisting of 27 different firms. The preapproved consulting pool list was used to streamline the selection process and to assist staff in obtaining consulting services in areas where special expertise is required or when workload is such that it cannot be accommodated in a timely fashion by in-house staff. The current consulting pool expired on June 30, 2024. Statements of qualifications (SOQs) were solicited and received on May 31, 2024 from qualifying firms. The City desires to establish a pool of firms whose combined and overlapping areas of expertise and abilities will allow staff to draw upon their services in a cost-effective manner without becoming overly dependent on any one firm. The City received SOQs from 33 firms. For the 2024 through 2027 period, the firms listed in the attached resolution are being recommended to be included in the professional engineering consulting pool. These firms were selected after a thorough review of all SOQs by staff in the Engineering, Public Works, Planning and Development and Parks and Recreation Departments. All firms have the technical expertise and capacity to assist in delivering professional services. Overall, this combination of consulting firms represents sufficient expertise to accommodate the recurring engineering, architectural, planning and Page 19 of 120 design needs of the City in an efficient and cost-effective manner. The recommended professional engineering consulting pool shall be effective from July 16, 2024 through June 30, 2027. One the pool is established, selected consultants must enter into a Master Services Agreement prior to providing services, which will be brought forth to the City Council for consideration at the August 7th meeting. Budget Impact: None. ATTACHMENTS: a Resolution R2024-102 Page 20 of 120 RESOLUTION R2024-102 A RESOLUTION OF THE CITY OF SHAKOPEE, MINNESOTA APPROVING THE PROFESSIONAL ENGINEERING CONSULTING POOL FOR 2024, 2025, 2026 AND 2027 WHEREAS, City staff solicited Statements of Qualifications (SOQs) from qualifying firms to establish a pool of firms whose combined and overlapping areas of expertise and abilities would allow staff to draw upon their services to accommodate the recurring engineering and technical needs of the City in an efficient and cost-effective manner; and WHEREAS, 33 firms submitted SOQs and fee schedules for inclusion in the 2024-2027 consulting pool; and WHEREAS, firms will be selected in the specific field or practice as outlined below on a project by project basis and whose expertise will serve and fit the City's needs most suitably; and WHEREAS, the City is now prepared to proceed with the following firms after a thorough review of all SOQs: A. General Municipal Engineering 1. Kimley-Horn & Associates, Inc. 2. Stantec Consulting Services, Inc. 3. WSB & Associates, Inc. B. Transportation Engineering 1. Alliant Engineering 2. Bolton and Menk, Inc. 3. SRF Consulting Group, Inc. 4. Stonebrooke Engineering 5. Transportation Collaborative & Consultants (TC2) C. Surface Water and Natural Resources 1. Advanced Engineering and Environmental Services (AE2S) 2. Emmons & Olivier Resources, Inc. (EOR) 3. Kimley-Horn & Associates, Inc. 4. Moore Engineering, Inc. 5. WSB & Associates, Inc. D. Geotechnical and Environmental Services 1. Barr Engineering Co. 2. Braun Intertec Corporation 3. WSB & Associates, Inc Page 21 of 120 E. Municipal Utilities 1. Advanced Engineering and Environmental Services (AE2S) 2. Bolton and Menk, Inc. 3. Short Elliott Hendrickson Inc. (SEH) 4. Stantec Consulting Services, Inc. 5. TKDA F. Land Surveying 1. Alliant Engineering 2. Bolton and Menk, Inc. 3. Hansen Thorp Pellinen Olson Inc. (HTPO) 4. ISG 5. Stonebrook Engineering G. Structural 1. Kimley-Horn & Associates, Inc. 2. SRF Consulting Group, Inc 3. Stantec Consulting Services, Inc. H. Architectural Services Supporting Public Works and Parks 1. Collaborative Design Group, Inc. 2. Gensler 3. Oertel Architects 4. RSP Architects I. Communications 1. Advanced Engineering and Environmental Services (AE2S) 2. In Control, Inc. 3. Kimley-Horn & Associates, Inc. J. Geographical Information System (GIS) 1. Kimley-Horn & Associates, Inc. 2. Stantec Consulting Services, Inc. 3. WSB & Associates, Inc. K. Electrical/Mechanical Engineering 1. Advanced Engineering and Environmental Services (AE2S) 2. Barr Engineering Co 3. Design Tree Engineering + Land Surveying 4. Short Elliott Hendrickson Inc. (SEH) L. Relocation/Benefit Analysis/Land Rights/Easement Acquisition 1. Evergreen Land Services Co 2. Henning Professional Services, Inc. 3. Integra Realty Resources 4. WSB & Associates, Inc. Page 22 of 120 M. Archeological/Cultural Resources and National Historic Preservation 1. 106 Group 2. Barr Engineering Co 3. Blondo Consulting N. Landscape Design and Parks Planning 1. Damon Farber 2. Hansen Thorp Pellinen Olson Inc. (HTPO) 3. ISG 4. Mend Collaborative WHEREAS, consultants shall enter into a Master Services Agreement prior to providing services for the City. NOW, THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF SHAKOPEE, MINNESOTA AS FOLLOWS: the aforementioned and listed consulting firms have been preapproved for professional services in the respective categories, establishing the 2024-2027 Consulting Pool for the City of Shakopee. Adopted in regular session of the City Council of the City of Shakopee, Minnesota, held this 16th day of July 2024. Prepared by: City of Shakopee 485 Gorman Street Shakopee, MN 55379 Matt Lehman, Mayor of the City of Shakopee ATTEST: Lori Hensen City Clerk Page 23 of 120 *4.B.2. Shakopee City Council July 16, 2024 FROM: Alex Jordan, City Engineer TO: Mayor and Council Members Subject: Consent to Improvements with Northern States Power Company (Xcel Energy) for Wood Duck Trail Improvements with Arbor Bluff Development Policy/Action Requested: Approve the Consent to Improvements with Northern States Power Company (Xcel Energy) for Wood Duck Trail Improvements with Arbor Bluff Development. Recommendation: Approve the Consent to Improvements Discussion: Development of Arbor Bluffs includes the construction and extension of Wood Duck Trail south of the plat boundary, connecting to the existing roadway in the Maple Trail Estates neighborhood. Wood Duck Trail will be constructed within an existing easement owned by Northern States Power Company (NSP), also referred to as Xcel Energy. Xcel Energy requires the roadway owner to enter into a Consent to Improvements to allow permanent infrastructure to be located within the existing easement. The Consent permits the City to construct the improvements, but maintains Xcel Energy's rights for future use of the easement area. Wood Duck Trail will be constructed with a future phase of the Arbor Bluff development. Mass grading of the roadway in the easement area will occur in 2024. Budget Impact: None. ATTACHMENTS: Consent to Improvements Page 24 of 120 a Location Map Page 25 of 120 RETURN TO: Xcel Energy Siting & Land Rights, Seth Wight 414 Nicollet Mall, 06 Minneapolis, MN 55401 (RESERVED FOR RECORDING DATA) CONSENT TO IMPROVEMENTS Line No. 0844/0861 The City of Shakopee THIS CONSENT TO IMPROVEMENTS (this "Consent"), dated the day of , 2024, is made by and between The City of Shakopee, its successors, and assigns ("Requestor") and Northern States Power Company, a Minnesota Corporation, herein referred to as "Xcel Energy", having an office and place of business in the City of Minneapolis, County of Hennepin, State of Minnesota. WITNESSETH WHEREAS, Xcel Energy obtained certain rights to construct and maintain facilities for the distribution and transmission of electrical energy pursuant to the easement document dated November 1st, 1955 and recorded on June 29tn 1956 in Book 24 of Misc., pages 159, as Document No. 86402 (the "Easement") in, over and across the property legally described as follows: That part of the West Haalf Of The N.sr'.beast Quarter Of Sector 20, To w nship 115, Range 22, Scott County, r�linnesotsa, described as follow'�ss: Beginning at The northwest corner of said Northeast Quarter; thence South 8241S'48' East, assumed basis for bearings., along the north line of said Northeast Quarter, 59718 feet; thenrc Siir.rth 0'00 0O West, 1450 50 feet, thence North 87''16`48" Weast, 597.78 -feet to the West line- sf said N4orthi ast Quarter; thence North h,l 00"tF0' East, .along said west line, 1450.50. feet to the point u,.t beginning. The West, Half of the Northeast Quarter of Section 20,. Township 115, Range 1 „ Scott County.. Minnesota, less and except thetoll win Beginning at the northwest corner of said North..ast Quarter„ then e South 87 clean es 16 rxnirjtss 48 seconds East, assu ued ha,a ,ais for bearings, along the north lire of said N�yosrtheaist Quarter SQ`l_18 feet; thence South 0 degrees 00 rr nuuta,s: 00 _,eco ••ds Wes1460.50 feet.; thence North 87 degrees 16 rnrinoutes 48 seconds West .597.18 feet to the west lire of said Northeast Quarter;: thence North 0 degrees CO minutes 00.seconds East, along said west line, 1460 50 feet to tl-1e point of beginning. (the "Premises"). 1 of 4 Page 26 of 120 WHEREAS, Requestor holds certain easements rights for roadway and utility purposes upon the Premises. WHEREAS, Requestor has applied to Xcel Energy for permission to use a portion of the Easement for residential development purposes, hereinafter reffered to as (the "Easement Area"). The Easement Area affected by this Consent is shown on Exhibit "B", attached hereto. NOW THEREFORE, in consideration of the promises exchanged herein, the parties for themselves and their respective successors and assigns agree as follows: 1. Xcel Energy consents to Requestor's use of the Easement Area for the purposes described in Exhibit "A", attached hereto and made a part hereof, subject to Requestor's strict compliance with the terms set forth herein. 2. The Requestor acknowledges that it has inspected the Easement Area and determined it to be suitable for the uses described in Paragraph 1 above. Requestor agrees that it is not relying on any oral or written representation of Xcel Energy concerning the Easement Area (including but not limited to dimensions, soil conditions, environmental conditions, and municipal restrictions, or use by adjoining or third parties). 3. No future work shall be conducted on the Easement Area until Requestor has received written approval from Xcel Energy. As a condition for approval, Requestor shall submit detailed plans of the work and a description of work procedures. Xcel Energy's approval of any work or work procedures merely indicates its consent to the proposed activities and does not constitute a representation or warranty concerning the suitability, prudency, effectiveness, or propriety of the proposed activities. Furthermore, minor maintenance work does not require approval, but substantial changes in design or location must be reviewed and approved by Xcel Energy. 4. Prior to commencing work, Requestor shall designate a representative who will supervise the work, be present during all work, and be authorized to control and, if necessary, suspend the work. 5. Requester shall suspend roadwork upon Xcel Energy's reasonable request related to Xcel Energy's utilities within the Easement Area. If suspension is required due to Requestor's failure to strictly comply with the terms of this Consent, upon such suspension the parties shall consult in an effort to cure such noncompliance so that the Requestor may resume its activities. 6. Requestor shall not at any time use or store any pollutant or hazardous material within the Easement Area, and shall at all times maintain the Easement Area in a safe and lawful condition. 7. Requestor shall, at its sole cost and risk, obtain all permits, consents or approvals required for its occupancy and use of the Easement Area. Upon Xcel Energy's request, Requestor shall provide evidence reasonably satisfactory to Xcel Energy that all required consents or permits are in force for Requestor's use of the Easement Area. 8. As part of Xcel Energy's business operations, Xcel Energy shall have the right, at any time and without liability or compensation to Requestor, to use the Easement Area to install, use, repair, maintain, relocate or remove facilities that presently exist or may in the future be located within the Easement Area. 9. LIMITATION OF LIABILITY; INDEMNITY. Requestor shall indemnify, defend and hold Xcel Energy, its agents, employees, and affiliates harmless from any cost, liability, damage, loss, claim, action or proceeding whatsoever for injury to persons (including death) or damage to property which may arise from or be claimed to have arisen from Requestor's exercise of the rights granted in this Consent. The foregoing indemnication specifically excludes intentional or grossly negligent acts of Xcel Energy, its employees, agents and representatives. Requestor, on behalf of itself, its successors, assigns, and representatives, hereby releases Xcel Energy from any liability for damages incurred by Requestor, its successors, assigns, representatives, employees, agents, or those under its control arising from (1) Xcel Energy's use and improvement of the Easement Area for its business purposes, (2) the existing condition of the Easement Area, (3) Xcel Energy's future installations, (4) 2 of 4 Page 27 of 120 Xcel Energy's actions reasonably necessary to protect its property during emergency conditions, or (5) Xcel Energy's exercise of its rights to remove improvements, grading or other work installed within the Easement Area by or on behalf of Requestor without Xcel Energy's prior approval. 10. Unless otherwise provided for as part of the conditions for approval, throughout the time Requestor is conducting work on the Easement Area, Requestor shall insure that any contractor conducting said work shall maintain and provide evidence to Xcel Energy of insurance coverage at least equivalent to the following or Requestor shall provide, at Requestor's expense, the following coverage: a. Worker's Compensation at statutory limits with Employers Liability coverage of at least $100,000 limits if such party is at any time during the term of this Consent subject to the requirements of any applicable law governing worker's compensation. b. Comprehensive General Liability Coverage, (including blanket contractual liability) against claims for bodily injury, death and property damage, including environmental damage, arising out of such parry's operations, affording combined single limit protection of One Million Dollars ($1,000,000) with respect to personal injury or death and property damage, including environmental damage. All policies shall be endorsed to (1) name Xcel Energy its directors, officers, employees and affiliates as additional insured with respect to any and all bodily injury and/or property damage, and (2) to require thirty (30) days written notice be given to Xcel Energy prior to any cancellation or material changes in the policy. [The balance of the page is left intentionally blank] 3 of 4 Page 28 of 120 N WITNESS WHEREOF, the parties have caused this Consent to be executed on the date aforementioned. REQUESTOR: NORTHERN STATES POWER COMPANY, a Minnesota corporation Name: Name: STATE OF COUNTY OF ) ss. Peter D. Gitzen, Manager Siting & Land Rights Xcel Energy Services Inc. an Authorized Agent for Northern States Power Company The foregoing instrument was acknowledged before me this day of , 2024, by (Stamp) Notary Public My Commission Expires: STATE OF ) ) ss. COUNTY OF ) The foregoing instrument was acknowledged before me this day of , 2024, by Peter D. Gitzen, Manager, Siting and Land Rights, Xcel Energy Services, Inc., as an authorized agent for Northern States Power Company, a Minnesota corporation, on behalf of the corporation. (Stamp) Notary Public My Commission Expires: This Instrument Drafted By: Seth Wight, an employee of Xcel Energy, 414 Nicollet Mall, Minneapolis, MN 55401 4 of 4 Page 29 of 120 *4.B.3. Shakopee City Council July 16, 2024 FROM: Micah Heckman, Assistant City Engineer TO: Mayor and Council Members Subject: No Parking Zone along Hentges Way. Policy/Action Requested: Approve a no parking zone and installation of "No Parking" signs on Hentges Way west of the roundabout at Stagecoach Road. Recommendation: Approve the parking zone restriction. Discussion: Engineering staff received a request from the Police Department to add a no parking zone on Hentges Way. The Police Department mentioned that semi trucks queue up on both the north and south side of the road while waiting to access a local business. The shoulder along Hentges Way is not wide enough to accommodate semi parking, which causes the thru lanes to be restricted and impacts access to and from businesses along Hentges Way. After reviewing aerial images, roadway plans and photos collected by the Police Department, the Traffic Safety Committee determined that a no parking zone would help alleviate traffic issues along the roadway. An exhibit depicting the locations of the proposed signs is attached. Budget Impact: No parking signs will be manufactured and installed by the Public Works Department. Each sign costs $275 to manufacture and install for a total of $2,200 for eight signs. The project will be funded through Public Works Street Division operating budget. ATTACHMENTS: Parking Restriction - Hentges Way Page 31 of 120 1111111111111111111111 111110000 , 1111 1 °°111111111 [ 1,1111111 01,111, 01.1 001101 00110[1 11,1411'1' 111 11 ,11 ivv11010001101111,10.0 VIVI 1(011' 1.11.1.1.1.11111.11 1'4'111111111111' 1111A1',,vvi ',[ I v 1[1 111111 1 i 11111111„. 1.1'1 "',111,11111::„ 1 [ 1 1111 [111 1 • 0 °v;11,1111111111,111,1110 I,. , ,111111111 1111. 1, 001 111 11, °111 '1[['vvvvvivIIII.vvinviv,vv[110,* '1'1' v[41111'1 1,000 ,,, 1[11111 11111 11;110;111,2111111111111 0111111111111111111111111111111 1140 .11111111111 i111 , 01 .111111111V viv 001111, v111111111 11111111111101v 1,1 1111 III 111 1 000 0 V 1 0 111111 11111111111, 1,, 11111911111111001111000010000001111 11111' 011 „[IIIIIII[1[1[11111111111111111111111111111111111111 14111,40,11v11.1 111,1111[1 [[vIlvvv[v[400100,001011011011v[1111 [III 11v ,101vvri 0 11 11111 111' „, 11, 1 1 1 1 I 1 1 11 vl 1111 ,011 „vv. , • v,[[,[[[ 1 1,1 110!. 01 1 lit MI 0 °V0 Voilvolooloo, vivo 1000011111.01000000111411110101110 11 100010011moollirioloril.000,000000011....i.....10, i0.0' 'm11oo. .111111 111 IIIII I° 000.1114101111110 ,11 01001 1111101"1001000101v1po101l1o011o011l 011011101101110.1I I00I01I 0v0i010111.0,o011,o1.vv1o.11v1v.vv111.010.h1 1.1.11111.1100,101,011,110,111v.V 1I1110vV11 III1100011111v11v11111111v1v1..10101,1110.000.1010110.1011100010„1.10iI1„1I01I, 111111111 11011011100 11111011111111111000111111 111111111111110IR0ll1°vv0I 0o0o0v0v011011100v000.001000 v0v10o000o01„0o0l10v1v1010lv00II0II110II10II10Io000v00V1v10„0v0vv0v100„,0v010111 01100111'10110710111001011°10011110101111010,0111410101v011011100100011 1100010001 1 1101100011011011000.10100v101.010v1'1100°,'910?010111100111101[01111001011 010v1111v10110v0141001001001001111001100010111 0111/011101110111011)011111101110111.11 11114,v[111Av14111101111 001 4v vvoloy iv 4000 11 vvv 00000000000001IIIIIIIIII I III 0111 001111100.01 V11111111111111111111111111111111111111 00/11ri,',Arerr'friol„,. 10,01.1111,111111 11 v1111111111111111 1,11111111 III 1111 °11 V111110111 111[ 1,11111 111 l0000 olool00000l 00000000000pill„oolo llool,1111111111111 ,11,01000000000oloolool 00000000000000000000„o, loll..111111111,1,1,1,1,1, I.,[vvi 1011 010 011111[11 111111111111111111111111111111 [ 111111V1,,IVIVIV111111111111111111111111111111111111111111111111111111111111111111[1111111111111,11, 1111111 1111111111111111111111111111111111111 'v[V; 1111111111111111111111111111111111111111111111111111 11111111 ,111,001 11110.111, 111,111'1111111111111111111 1111111.111111011111111111111, 11 1 101.1.1 11, 1 0011111111 Ill 1....11111.1111.„11.0 011111111011 1, I 1111,111111111 111[V1111111 11111.011 1„jj• '11111[fil!:IiII[I,1[1:1[Ii[glio:11,1117010 vvv v1[1:11111:01';g1 °',[f";!',11',:)1'111111: °11.001000.00010011110101111101111111111 ,[1' ,vvv 01,11 I 1ovi1vvvvvvvv11001y 11111,111111, v1111I ./111 11110 1,1, 1 [, VI 0 V 0 ' 11000001 000 00000000 .,,?' 110.00000000000000 .1 00000000000001000000000000,,,0 iyy 11 yll ,im000,,,,,,,,,,,,orl000h000000000000000.gti.„,„oi„o? 1 ,,,,,,,,,,,,,/fi Ho 00000000000000000000000lfliolhoio,i000li 000pooll„ „............ 000111 . 1.,. " 00111,111,111,111,111,11,„„0,1,111.111.111,1„1„1„111,111,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,111,11,11,11,11,11 ..1..,.,,,,,,,,,,,,..000000000000.01. )101111 1,001,01,1,01111111111111111 '.,,, ................., u, 0, 1 IvvvvvolvvvvvvvvvvvvvvvvvvvIlvvvv ivvvvvvVIVvvvvvvvvvvvvvvvv0v0000kiv 01111111'00,0101011101110000011° VIv 1110, *4.C.1. Shakopee City Council July 16, 2024 FROM: Mike Nelson, Fire Chief TO: Mayor and Council Members Subject: Furniture for Fire Station 1 Remodel Policy/Action Requested: Approve the purchase of new office and conference room furniture for Fire Station 1. Recommendation: Approval as requested. Discussion: The Fire Station 1 remodel is nearing completion. The Fire Administration area will now include separate offices for all fire administration staff, an improved printing, supply, and collaboration area, and a separate conference room for staff meetings. The current office furniture has been in use since Fire Station 1 was built in 1998, and due to the redesigned office and collaboration spaces, much of the existing furniture configurations will not fit. Staff selected furniture to fit the current and future needs of the administration space. The furniture quote includes all necessary furniture for each workspace and office. The cost of the furniture is $57,795.61. Budget Impact: This request falls within the FF&E allowance of $60,000 listed in the cost summary as part of the award of bids approved by City Council on April 16, 2024. ATTACHMENTS: o Furniture Plan ▪ Furniture Quote Page 33 of 120 W U w CC r c � BREAK/COLLAB 02d 8-b89£-'. - 9-b8X' 0 1111111111111111111111 0 Z 0-J J J W H 00 d m 3231.TBT10.TZ2448 3232.TBT9.TZ2448 US.UB.ARO 2 0 0 3231.TBT10.TZ2448 3232.TBT9.TZ2448 .US.UB.ARO N 2 0 0 \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ 11111111111111111111111111111111111111111111111 u_ 0 8!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PL BREAK/COLLAB DED1 MOExHS'LS 1=I OES 9831 9E.HS'LS AS L8 !MI 09X M09.HS LS 1=1 09919 AS'LS www.henricksen.com .`)PC tur Orrin) Prepared For: CITY OF SHAKOPEE Deliver To: FIRE STATION 1 2700 VIERLING DR E SHAKOPEE, MN 55379 Quote No.: 24050577 Updated: 6/13/2024 Prepared By: L VOELKERS/ANDREWS (f Direct: 715.299.7141 A.ANDREWS@HENRICKSEN.COM 1111 IIIII mminmmmmmmmmmmmmmmmgmo 111 II II�JIIII III1J 11111111111111111111 III II ➢I11y111111 Ulf I➢IIIf IIIII 1111 1JiJ1111111II II II II111110II 1)1Ii1l J01 �i IIIIILI 111111111 I1 11 I101 1 6 HMG5 .N .E .CR .P7A 2 1 HSCER24LM Motivate 4-Leg Cafe Ht Stool No Arm Standard Nylon Glide Cherry Textured Charcoal Laminate End Table Round 24Dx22H $(L1STD) Grd L1 Standard Laminates .LAHP Handspun Pearl EH Fossil .LSW1 Skyline Walnut $(P1) P1 Paint Opts .P7A Textured Charcoal 3 2 HWH1SP West Hill Single Seat Lounge -Pillow Cushion .B Both Arms $(5) Grade 5 Uph .1045 Zippy -44 Deep Red .SM Square Metal P7A Textured Charcoal BREAK/COLLAB $244.64 $1,467.84 ANCILLARY BREAK/COLLAB $672.66 $672.66 ANCILLARY BREAK/COLLAB $1,512.71 $3,025.42 ANCILLARY 4 1 ATLADM-BMTGM3684B Admix Mtg Tbl Base 36x84 Bar Hgt BREAK/COLLAB $1,359.66 $1,359.66 ANCILLARY $(P1) P1 Paint Opts .P02 Flint .GLD Glides 5 1 ATLADM-TMRECL3684F Admix Mtg Top Rect 36x84 Lam Flat Edge BREAK/COLLAB $426.56 $426.56 ANCILLARY .X Non-FSC Wood $(L1STD) Grd L1 Standard Laminates .LAHP Handspun Pearl .EH Fossil .GN Grommet No 6 2 HIWMRA Ign 2.0 Mid -back ReActiv BREAK/COLLAB WS $428.90 $857.80 .Y1 Synchro-Tilt W Seat Slider .V AII-Adjustable Arm .S Black AII-Surface Caster .0S Charcoal $(1) Grade 1 Uph .CU Centurion Page 1 of 10 Page 37 of 120 t4/ Port NUSI� I���LstrI " ;00 T '111e gl 10 .NL .SB .T 7 2 HAT2-MID-L-BK Height Adjustable B BK B ack No Lumbar Standard Base Black Rectangular Mid -Hat Two Legs Finishes Black BREAK/COLLAB WS $382.58 $765.16 8 2 TK03036 Ter Stacking Panel Frame 30Hx36W BREAK/COLLAB WS $108.14 $216.28 9 2 TK03060 Ter Stacking Panel Frame 30Hx60W BREAK/COLLAB WS $121.22 $242.44 10 4 TKSK36 Ter 36W Segment Kit BREAK/COLLAB WS $8.54 $34.16 11 4 TKSK60 Ter 60W Segment Kit BREAK/COLLAB WS $10.41 $41.64 12 2 AJTRGH24 24" Cable Management Tray - Black Only BREAK/COLLAB WS $32.84 $65.68 .P Black 13 1 A871160 Pass-Thru Harness w/Power Block 60W BREAK/COLLAB WS $247.00 $247.00 .P Black 14 1 A871230 Power Harness 30W BREAK/COLLAB WS $101.19 $101.19 .P Black 15 2 A871260 Power Harness 60W BREAK/COLLAB WS $107.60 $215.20 .P Black 16 2 A873501 Ter/2.6/Align Duplex Receptacle Circuit 1 BREAK/COLLAB WS $16.82 $33.64 .E9 Flint 17 2 A873502 Ter/2.6/Align Duplex Receptacle Circuit 2 BREAK/COLLAB WS $16.82 $33.64 .E9 Flint 18 1 A876072 Base Infeed 6'Sealtight Cable BREAK/COLLAB WS $113.74 $113.74 .P Black 19 2 K62918OLG Involve 29.5Hx18D Open End Support Freestanding BREAK/COLLAB WS $213.87 $427.74 $(P1) P1 Paint Opts .P02 Flint 20 1 KOLGBRKLFT Involve 0-leg bracket for panels $(P1) P1 Paint Opts .P02 Flint BREAK/COLLAB WS $51.53 $51.53 Page 2 of 10 Page 38 of 120 t4/ Port NUS�� ����LstrI " ;00 T '111e gl 21 1 KOLGBRKRGT $(P1) .P02 22 1 CDG Involve 0- eg bracket for panels P1 Paint Opts Flint Gussets (1 Pr) $(P1) P1 Paint Opts .P02 Flint 23 2 CEP1129F Freestanding 11DX29-1/2H End Pnl Sup $(P1) Pl Paint Opts .P02 Flint 24 1 TKEP1129PL DNA Pnl Mnt LH 11Dx29-1/2H End Pnl Supt $(P1) P1 Paint Opts .P02 Flint BREAK/COLLAB WS BREAK/COLLAB WS $45.66 $51.53 $51.53 $45.66 BREAK/COLLAB WS $65.42 $130.84 BREAK/COLLAB WS $73.96 $73.96 25 1 TKEP1129PR DNA Pnl Mnt RH 11Dx29-1/2H End Pnl Supt BREAK/COLLAB WS $73.96 $73.96 $(P1) P1 Paint Opts .P02 Flint 26 1 TK05730WR Structural Raceway Pnl Fr -No Top Trim 57.5Hx30W BREAK/COLLAB WS $122.02 $122.02 $(P1) P1 Paint Opts .P02 Flint 27 2 TK05736WR Structural Raceway Pnl Fr -No Top Trim 57.5Hx36W BREAK/COLLAB WS $126.02 $252.04 $(P1) Pl Paint Opts .P02 Flint 28 3 TK05760WR Structural Raceway Pnl Fr -No Top Trim 57.5Hx60W BREAK/COLLAB WS $150.59 $451.77 $(P1) P1 Paint Opts .P02 Flint 29 1 TK330PTF Flat Top Trim 30W BREAK/COLLAB WS $16.02 $16.02 $(P1) P1 Paint Opts .P02 Flint 30 1 TK330SF S ExtendedStraightFlatConnKit 30H stack/segment BREAK/COLLAB WS $61.41 $61.41 $(P1) P1 Paint Opts .P02 Flint 31 2 TK336PTF Flat Top Trim 36W BREAK/COLLAB WS $17.89 $35.78 $(P1) P1 Paint Opts .P02 Flint 32 1 TK357EF E End Trim Flat ConnKit - 57.5"H base panel BREAK/COLLAB WS $39.25 $39.25 $(P1) P1 Paint Opts .P02 Flint 33 1 TK357TF T 3-way Flat Connector Kit - 57.5"H base panel BREAK/COLLAB WS $65.68 $65.68 Page 3 of 10 Page 39 of 120 t4/ Posit I I1111 estrI " ; 00 TO"111e gl $ P1 .P02 34 3 TK360PTF $(P1) .P02 35 2 TK387EF P1 Paint Opts Flint Flat Top Trim 60W P1 Paint Opts Flint E End Trim Flat ConnKit - 87.5"H base panel $(P1) P1 Paint Opts .P02 Flint 36 2 TK387LF L 90-degree Flat ConnKit - 87.5"H base panel $(P1) P1 Paint Opts .P02 Flint 37 2 TK43036GK Ter Glazed Tile Kit 30H x 36W $(P1) P1 Paint Opts .P02 Flint .0 Clear Glass 38 2 TK43060GK Ter Glazed Tile Kit 30H x 60W $(P1) P1 Paint Opts .P02 Flint .0 Clear Glass 39 2 TKG45730T Ter Tackable Acoustic Tile 57.5H x 30W $(A) Grd A FAB .BNRY Binary 02 Sand Dollar 40 4 TKG45736T Ter Tackable Acoustic Tile 57.5H x 36W $(A) Grd A Fab .BNRY Binary 02 Sand Dollar 41 6 TKG45760T Ter Tackable Acoustic Tile 57.5H x 60W $(A) Grd A Fab .BNRY Binary 02 Sand Dollar 42 2 T51860S 18Dx60W Rectangular W/S w/Flat Edge Groms $(L2STD) Grd L2 Standard Laminates .LSW1 Skyline Walnut .SW Skyline Walnut .P Plastic Grommet 43 2 AF5RS6030UD 60Wx30D (58Wx28D) Altitude Rect Worksurface .X Standard Wood $(L2STD) Grd L2 Standard Laminates .LSW1 Skyline Walnut .SW Skyline Walnut .GC Grommet Center P Oval Plastic BREAK/COLLAB WS $30.17 $90.51 BREAK/COLLAB WS $62.48 $124.96 BREAK/COLLAB WS $89.98 $179.96 BREAK/COLLAB WS $299.04 $598.08 BREAK/COLLAB WS $407.98 $815.96 BREAK/COLLAB WS $81.97 $163.94 BREAK/COLLAB WS $92.38 $369.52 BREAK/COLLAB WS $126.56 $759.36 BREAK/COLLAB WS $178.62 $357.24 BREAK/COLLAB WS $269.94 $539.88 Page 4 of 10 Page 40 of 120 44 2 YPPM211518BFM .S EL $(P1) .P02 $(P1) .P02 .L 45 8 HSLVTMR A ign Ped 21x15x18 BF MetFront Mobile Square Matte Silver P1 Paint Opts Flint P1 Paint Opts Flint Std Lock Solve Task Mid Back ReActiv Back YO Basic SynchroTilt .F Fixed Arm .H Hard Caster .OS Charcoal $(1) Grade 1 Uph .UR Contourett 10 Black .NL No Lumbar .SB Standard Base .T Black 46 1 AMPTP2 Structure 10' corded Pwr incl 3 Pwr/1 Extron CutOut .BLK Black BREAK/COLLAB WS $269.67 $539.34 CONF $334.33 $2,674.64 CONF $308.02 $308.02 47 1 AMPTWMCXBS Structure Wire Manager Cover for X Base Short CONF $46.00 $46.00 $(P1) P1 Paint Grade .P02 Flint 48 2 AMPTXL29G Structure X Base Large Seated Height with Glides CONF $355.12 $710.24 $(P1) P1 Paint Grade .P02 Flint 49 1 AMPTLF4896RE Structure 48" X 96" Rectangle Top Lam SqrEdge CONF $641.42 $641.42 .X Standard Wood $(L2STD) Grd L2 Standard Laminates .LSW1 Skyline Walnut .SW Skyline Walnut .C1 Large Center Cutout 50 4 3232.TBT9.TZ2448 Tensor - Base - For Rectangular Top Size 24" x 48" BF03 Black TH00 Standard Height (29") 51 4 3231.TBT10.TZ2448 GR2 TL15 Tensor - 24" x 48" Bridge Top Grade 2 Laminate Skyline Walnut 52 4 1191.SW19.US.UB.ARO Cora Guest Chair, without Arms FC1 Black Frame GL2 Performance Multi -Surface Glides No Moisture Barrier USU Single Upholstered No Ballistic Nylon Option FG2 Fabric/Vinyl Grade 2 STRIVE Strive Standard Color Selection EBONY Strive Ebony AC Fully Assembled in Carton DORMS $266.80 $1,067.20 DORMS DORMS $180.32 $721.28 $213.90 $855.60 Page 5 of 10 Page 41 of 120 t4/ Port U I� III �Lsi rI" ;00 T '11111,11 11e gl 53 4 HIWMRA .Y1 .V .S .0S $(1) .CU 10 .NL .SB .T Ign 2 0 Mid -back ReActiv Synchro-Tilt W Seat Slider AII-Adjustable Arm Black AII-Surface Caster Charcoal Grade 1 Uph Centurion Black No Lumbar Standard Base Black 54 4 AJTRGH24 24" Cable Management Tray - Black Only .P Black 55 1 AMPTXL29G Structure X Base Large Seated Height with Glides $(P1) P1 Paint Grade .P02 Flint 56 1 AMPTXM29G Structure X Base Med. Seated Height with Glides $(P1) P1 Paint Grade .P02 Flint 57 10 CDG Gussets (1 Pr) $(P1) P1 Paint Opts .P02 Flint 58 8 CEP1129F Freestanding 11DX29-1/2H End Pnl Sup $(P1) P1 Paint Opts .P02 Flint 59 4 CEP2429F Freestanding 24DX29-1/2H End Pnl Sup $(P1) P1 Paint Opts .P02 Flint 60 8 CSL2429F Freestanding 24Dx29-1/2H Sup Leg $(P1) P1 Paint Opts .P02 Flint 61 4 ELF830NS Ess Lat 30W 28H 2-12" Drws Sq Pull $(P1) P1 Paint Opts .P02 Flint .EL Matte Silver .OMT OMT Core to Ord key Alike 62 1 AMPTLF36RND Structure 36" Diameter Round Top Lam SqrEdge .X Standard Wood $(L2STD) Grd L2 Standard Laminates .LSW1 Skyline Walnut .SW Skyline Walnut 63 1 AMPTLF48RND Structure 48" Diameter Round Top Lam SqrEdge PO $428.90 $1,715.60 PO $32.84 $131.36 PO $344.45 $344.45 PO $257.60 $257.60 PO $45.66 $456.60 PO $65.42 $523.36 PO $70.49 $281.96 PO $60.88 $487.04 PO $452.38 $1,809.52 PO $233.31 $233.31 PO $335.25 $335.25 Page 6 of 10 Page 42 of 120 t4/ Port U I� III �Lsi rI" ;00 T '111e gl X $ L2STD) .LSW1 .SW 64 1 T524665 Standard Wood Grd L2 Standard Laminates Skyline Walnut Skyline Walnut Primary 24Dx66W Flat Eg Lam w/Grommets $(L2STD) Grd L2 Standard Laminates .LSW1 Skyline Walnut .SW Skyline Walnut .P Plastic Grommet 65 6 T52472S Primary 24Dx72W Flat Eg Lam w/Grommets $(L2STD) Grd L2 Standard Laminates .LSW1 Skyline Walnut .SW Skyline Walnut .P Plastic Grommet PO $217.34 $217.34 PO $220.01 $1,320.06 66 1 T524965 Primary 24Dx96W Flat Eg Lam w/Grommets PO $368.46 $368.46 $(L2STD) Grd L2 Standard Laminates .LSW1 Skyline Walnut .SW Skyline Walnut .P Plastic Grommet 67 1 LKFE3SLV Lock Core Kit Silver - 3 Cores 2 Keys PO $78.50 $78.50 $(KEYNUM) Key Number .SEQ/ Key Number Sequence Start 101 Key Number 101 .4 4 68 1 YPCP283018O Align 28x30x18 Open Bookshelf Plinth PO $398.52 $398.52 .BK Flush Plinth $(P1) P1 Paint Opts .P02 Flint $(P1) P1 Paint Opts .NA Match Case 69 2 WKWSRS7230 Approach Wksf Rectangular 72Wx30D PO $265.40 $530.80 .X Standard Wood $(L2STD) Grd L2 Standard Laminates .LSW1 Skyline Walnut SW Skyline Walnut .L Left P Plastic Grommet 70 2 WKWSRS7230 Approach Wksf Rectangular 72Wx30D .X Standard Wood $(L2STD) Grd L2 Standard Laminates .LSW1 Skyline Walnut SW Skyline Walnut .R Right P Plastic Grommet 71 4 YPPM211518BFM Align Ped 21x15x18 BF MetFront Mobile .S Square EL Matte Silver $(P1) P1 Paint Opts .P02 Flint $(P1) P1 Paint Opts .P02 Flint PO $265.40 $530.80 PO $272.61 $1,090.44 Page 7 of 10 Page 43 of 120 t4/ Port U I� III �Lsi rI" ;00 T '111e gl X 72 4 WKNT722424 .X $(L2STD) .LSW1 SW $(L2STD) .LSW1 SW .SP EL .OMT 73 4 E2-2 Omit Lock Approach Wardrobe 72H 24W 24D No Feet Standard Wood Grd L2 Standard Laminates Skyline Walnut Skyline Walnut Grd L2 Standard Laminates Skyline Walnut Skyline Walnut Square Matte Silver OMT Core to Ord key Alike E2 Dual E2 Finishes Finishes 104 Black 74 4 HAT2-MID-L-BK Height Adjustable B BK Rectangular Mid -Hat Two Legs Finishes Black PO $994.58 $3,978.32 PO $299.00 $1,196.00 PO $382.58 $1,530.32 75 9 1191.SW19.US.UB.ARO Cora Guest Chair, without Arms PO $213.90 $1,925.10 FC1 Black Frame GL2 Performance Multi -Surface Glides No Moisture Barrier USU Single Upholstered No Ballistic Nylon Option FG2 Fabric/Vinyl Grade 2 STRIVE Strive Standard Color Selection CRIMSON Crimson AC Fully Assembled in Carton 76 1 HIWMRA Ign 2.0 Mid -back ReActiv .Y1 Synchro-Tilt W Seat Slider .V All -Adjustable Arm .S Black AII-Surface Caster .OS Charcoal $(1) Grade 1 Uph .CU Centurion 10 Black .NL No Lumbar .SB Standard Base .T Black RECEPT $428.90 $428.90 77 5 HIWMRA Ign 2.0 Mid -back ReActiv WORK RM $428.90 $2,144.50 .Y1 Synchro-Tilt W Seat Slider .V All -Adjustable Arm .S Black AII-Surface Caster .OS Charcoal $(1) Grade 1 Uph .CU Centurion 10 Black .NL No Lumbar .SB Standard Base .T Black 78 5 HAT2-MID-L-BK Rectangular Mid -Hat Two Legs WORK RM $382.58 $1,912.90 Height Adjustable B BK Finishes Black Page 8 of 10 Page 44 of 120 II t4/ Port U �� ��Lsi rI" ;00 T '111e gl 79 5 80 5 AJTRGH24 .P 81 1 CDG Z5SC60 48W External Supt Channel for 60W W/S 24" Cable Management Tray - Black Only Black Gussets (1 Pr) $(P1) P1 Paint Opts .P02 Flint WORK RM WORK RM $32.84 $164.20 WORK RM $29.37 $146.85 $45.66 $45.66 82 1 CEP1129F Freestanding 11DX29-1/2H End Pnl Sup WORK RM $65.42 $65.42 $(P1) Pl Paint Opts .P02 Flint 83 1 T51860SN 18Dx60W Rectangular W/S w/Flat Edge No Groms WORK RM $178.62 $178.62 $(L2STD) Grd L2 Standard Laminates .LSW1 Skyline Walnut .SW Skyline Walnut 84 1 ELF83ONS Ess Lat 30W 28H 2-12" Drws Sq Pull WORK RM $444.80 $444.80 $(P1) P1 Paint Opts .P02 Flint .EL Matte Silver .STD Standard Random key 85 5 T53060S Primary 30Dx60W Flat Eg Lam w/Grommets $(L2STD) Grd L2 Standard Laminates .LSW1 Skyline Walnut .SW Skyline Walnut .P Plastic Grommet 86 5 YPPM211518BFM Align Ped 21x15x18 BF MetFront Mobile .S Square EL Matte Silver $(P1) P1 Paint Opts .P02 Flint $(P1) P1 Paint Opts .P02 Flint .L Std Lock WORK RM $212.53 $1,062.65 WORK RM $269.67 $1,348.35 87 1 DES/PM Design & Project Management Services Z $1,105.00 $1,105.00 88 1 INSTALL Installation Z $5,625.00 $5,625.00 GRAND TOTAL $57,795.61 Page 9 of 10 Page 45 of 120 II t4/ Port U I� I�LstrI " ;00 T ' J o III ��� (�il�i���l���f� Approved By: PLEASE REMIT WITH COPY OF YOUR PURCHASE ORDER Date: PO: All items are special order and cannot be changed, cancelled or returned once factory production runs have closed. Installation to occur during regular business hours unless otherwise specified. Site to be accessible by commercial vehicles, free of obstacles & debris and subject to inspection and approval by Henricksen PSG. Construction punchlist to be completed before furniture is delivered and installed Installation of modular electrical components to be performed by licensed electrician and not included in this proposal unless otherwise specified. Any existing furniture to be removed from areas designated to receive new furniture prior to delivery/installation of new furniture. Handling of existing furniture not included in this proposal unless otherwise specified. Page 10 of 10 Page 46 of 120 *4.D.1. Shakopee City Council July 16, 2024 FROM: Michael Kerski, Planning/Development Director TO: Mayor and Council Members Subject: This section shall always incorporate the most current edition of the state building code, excluding the optional appendix chapters. Policy/Action Requested: Adopt Ordinance 02024-008 amending 111.01 Building Code; Application, Permits, Fees, And The Like eliminating references to specific years and eliminating other non- essential language covered by other areas of city code per the direction of the city attorney. Recommendation: Approve Ordinance Discussion: The Minnesota Department of Labor and Industry has recommended that we update the City Code to reference the current codes and regulations adopted by the State of Minnesota, rather than specifying particular years. The State has reviewed city codes and discovered that many cities do not reference the most recent codes, making it challenging for cities and city clerks to continually amend their codes to remain compliant. Our staff agrees that this approach will simplify the code process and the city attorney has deleted other unnecessary references. Budget Impact: N/A ATTACHMENTS: o Ordinance 02024-008 Page 47 of 120 ORDINANCE 02024-008 AN ORDINANCE OF THE CITY OF SHAKOPEE, MINNESOTA, AMENDING CITY CODE SECTION 111.01 BUILDING CODE; APPLICATION, PERMITS, FEES, AND THE LIKE WHEREAS, the City of Shakopee seeks to keep its codes up to date and in line with the State of Minnesota requirements: and WHEREAS, the City of Shakopee must follow the State adopted codes and regulations for various codes; and WHEREAS, the State updates the codes on a regular basis and the city must adopt the same to remain in compliance; and WHEREAS, the State has recommended that the City Code be amended to reflect that the city codes are the latest versions of adopted State regulations; and WHEREAS, the City Council heard the matter at its meeting on July 16, 2024; and NOW, THEREFORE BE IT ORDAINED, by the City Council of the City of Shakopee, Minnesota as follows: Section 1. Section 111.01, Subdivision C of the Shakopee City Code is amended to read as follows: C. Building Codes. 1. The State Building Code, as adopted by the Commissioner of Administration pursuant to M.S. §§ 326B.101 to 326B.16, as they may be amended from time to time, including all of the amendments, rules, and regulations established, adopted, and published from time to time by the Department of Labor and Industry Construction Codes and Licensing is hereby adopted by reference with the exception of the optional chapters, unless specifically adopted in this section. 2. The State Building Code is hereby incorporated in this section as if fully set out herein: a. 2-04-5. Minnesota State Building Code (MSBC); b. Minn. Rules Ch. 1300, Administration of the State Building Code; c. Minn. Rules Ch. 1301, Building Official Certification; d. Minn. Rules Ch. 1302, State Building Code Construction Approvals; e. Minn. Rules Ch. 1303, State Provisions; f. Minn. Rules Ch. 1305, Adoption of the 2-04-2 International Building Code; Page 48 of 120 g. Minn. Rules Ch. 1306, Special Fire Protection Systems (subp. 2. existing and new buildings); h. Minn. Rules Ch. 1307, Elevators and Related Devices; i. Minn. Rules Ch. 1309, Adoption of the 2012 International Residential Code; j. Minn. Rules Ch. 1311, Adoption of the 2-04-2 Guidelines for the Rehabilitation of Existing Buildings; k. Minn. Rules Ch. 1315, Adoption of the 2-04-4 National Electrical Code; 1. Minn. Rules Ch. 1322, Adoption of the Residential Energy Code; m. Minn. Rules Ch. 1323, Adoption of the Commercial Energy Code; n. Minn. Rules Ch. 1325, Solar Energy Systems; o. Minn. Rules Ch. 1335, Floodproofing Regulations; p. Minn. Rules Ch. 1341, State Accessibility Code; q. Minn. Rules Ch. 1346, Adoption of the 2012 International Mechanical/Fuel Gas Code; r. Minn. Rules Ch. 1350 Manufactured Homes; s. Minn. Rules Ch. 1360, Pre -Fabricated Structures; t. Minn. Rules Ch. 1361, Industrialized/Modular Buildings; u. Minn. Rules Ch. 1370, Storm Shelters (Manufactured Home Parks); v. Minn. Rules Ch. 4715, State Plumbing Code; and w. Minn. Rules Ch. 1322, 1323, 7670,7672, 7674, 7676 and 7678, State Energy Code. x. This municipality may adopt by reference any or all of the following optional chapters of Minn. Rules Ch. 1306, Special Fire Protection System; and Minn. Rules Ch. 1335, Floodproofing regulations, Minn. Rules Ch. 1335.0600 to 1335.1200; and Passed in regular session of the City Council of the City of Shakopee on July 16, 2024. Mayor of the City of Shakopee Attest City Clerk Published in the New Prague Times on the day of 2024. Page 49 of 120 *4.D.2. Shakopee City Council July 16, 2024 FROM: Michael Kerski, Planning/Development Director TO: Mayor and Council Members Subject: Award of Bids for Jackson Commons Park Development. Policy/Action Requested: Approve award of bids as recommended by Kraus Anderson totalling $1,619,035 as outlined in the Contract Award Letter dated July 10, 2024. Recommendation: Award bids. Discussion: Kraus Anderson bid out the Jackson Commons Park plans in various packages. The estimate for the large scope of work that included Site clearing and grading, Asphalt paving, Concrete, Bike skills course and trails and Landscaping and irrigation was $2.1 million. We received many bids for all but one category, totalling $1,619,035 for all categories. The bid tabulation and recommendation from Kraus Anderson is attached. The remaining work will be the seeding of the prairie areas that will be completed by Scott County Soil and Water Conservation District with the city purchasing the seed. This is estimated to be under $150,000. The last item that will be bid out is a shelter for approximately $100,000 The Council has previously approved a contract with Kompan for the playground equipment (853,421.34) and with a tree removal company to clear the pond areas of invasive species or dead/dying trees ($100,000).. The total project cost for construction will be approximately $2,822,456 from Park Page 50 of 120 Dedication. Budget Impact: From Park Dedication Fees. ATTACHMENTS: Bid Tabulation o Award Letter Page 51 of 120 BID TABULATIONS Jackson Commons Park OWNER: City of Shakopee WS 31A: Site Clearing & Earthwork ARCHITECT: Confluence ce W 0 0 m Peterson Companies, LLC. 1, 2 BOND yes 0 0 O 0 00 Ln co EA Le W 0 0 OO Fehn Companies, Inc. N BOND yes 0 0 00 N O O ti crr ce W 0 0 Rachel Contracting, LLC. 1, 2 BOND yes O LC) rn O O 64 Ce W 0 0 CO Belair Sitework Services N N BOND yes 0 0 N O O co - O 1 6R BIDDER Minnesota Utilities & Excavating 1, 2 BOND yes $623,573.00 BIDDER S.M. Hentges and Sons, Inc. N BOND yes 0 0 0 O CO O O O 0 co 69 WS 32A, WS 32B ADDENDA REC'D. BID SECURITY RESP. CONTRACTOR 0 m W N 4 CO COMBINED BASE BID Page 52 of 120 BID TABULATIONS Jackson Commons Park OWNER: City of Shakopee WS 31A: Site Clearing & Earthwork ARCHITECT: Confluence ce W CI CI CO Le W CI CI CO ce W In CI CO Ce uJ 0 CI CO Urban Companies, LLC N BOND yes 0 O 0 0 0 O CO 7r - CV ER 00'000`900'ES WS 32F BIDDER U.S. SiteWork, Inc. 1, 2 BOND yes $947,849.00 BIDDER Frattalone Companies, Inc. N BOND yes $835,494.00 ADDENDA REC'D. BID SECURITY RESP. CONTRACTOR C CO LIJ N 4 CO COMBINED BASE BID Page 53 of 120 BID TABULATIONS Jackson Commons Park 0 0 N o, OWNER: City of Shakopee WS 32A: Asphalt Paving ARCHITECT: Confluence ce W CI CI CO Le W CI CI CO ce W 0 CI CO GMH Asphalt Corp. N BOND yes O O O O CO 64 Ce uJ CO Goodmanson Construction N BOND yes 0 O LC)0 O N 64 BIDDER S.M. Hentges and Sons, Inc. 1, 2 BOND yes 0 O O O O O LC) N EA BIDDER Minnesota Paving & Materials N BOND yes 0 O O O O N 6R ADDENDA REC'D. BID SECURITY RESP. CONTRACTOR C m W V) 4 CO COMBINED BASE BID Page 54 of 120 BID TABULATIONS Jackson Commons Park 0 0 N o, OWNER: City of Shakopee WS 32B: Concrete Paving ARCHITECT: Confluence ce W 0 0 CO O! W 0 CO Curb Masters Inc. N BOND yes 0 O ti O O LC) N co- O! W 0 CO Crosstown Masonry Incorporated N BOND yes $242,499.00 O! W 0 CI O] Ebert Construction N , BOND yes 0 O O O N N CO N 64 BIDDER Goodmanson Construction 1, 2 BOND yes $228,450.00 0 q 0 0 O N N in ER WS 32A BIDDER S.M. Hentges and Sons, Inc. N BOND yes O O O O O CO O 6R ADDENDA REC'D. BID SECURITY RESP. CONTRACTOR C m W V) 4 CO COMBINED BASE BID Page 55 of 120 BID TABULATIONS Jackson Commons Park OWNER: City of Shakopee WS 32E: Bike Skills Park and Optimized Trails ARCHITECT: Confluence Le W 0 0 CO Cd W 0 0 CO Ce W 0 0 CO Ce W 0 0 CO BIDDER BIDDER Pathfinder Trail Building N BOND yes $438,420.00 ADDENDA REC'D. BID SECURITY RESP. CONTRACTOR 0 CO W N 4 CO COMBINED BASE BID Page 56 of 120 BID TABULATIONS Jackson Commons Park 0 0 N o, OWNER: City of Shakopee WS 32F: Landscape Package ARCHITECT: Confluence ce W Ci CI CO Le W 0 CI CO ce W 0 CI CO Ce W 0 CI m Greenscape Landscaping and Irrigation (V BOND yes O O O O O n LC) CO E4 BIDDER Urban Companies, LLC 1, 2 BOND yes 0 O O O O n Ln Ln fA BIDDER Hoffman & McNamara Co. 1, 2 BOND yes $204,415.00 ADDENDA REC'D. BID SECURITY RESP. CONTRACTOR BASE BID COMBINED BASE BID Page 57 of 120 KRAUS-ANDERSON® July 10, 2024 Mr. Michael Kerski City of Shakopee 485 Gorman Street Shakopee, MN 55379 RE: Jackson Commons Park Contract Award Letter Dear Mr. Kerski: Kraus -Anderson Construction Company 501 South Eighth Street, Minneapolis, MN 55404 This letter is concerning the contract awards for the above referenced project that was bid on July 9, 2024. Kraus -Anderson has verified bidders and we submit the following lowest responsible bidders and their total bid amount: Work Scope Contractor, City, State Bid Amount WS 31-A Site Clearing & Earthwork S.M. Hentges and Sons, Inc. Jordan, MN Base Bid Total 31-A Contract $560.400.00 $560,400.00 WS Asphalt Paving MN Paving & Materials Base Bid $217,800.00 32-A Rogers, MN Total 32-A Contract $217,800.00 WS Concrete Paving S.M. Hentges and Sons, Inc. Base Bid $198,000.00 32-B Jordan, MN Total 32-B Contract $198,000.00 WS Bike Skills Park and Pathfinder Trail Building Base Bid $438,420.00 32-E Optimized Trails Afton, MN Total 32-E Contract $438,420.00 WS Landscape & Hoffman & McNamara Co. Base Bid $204,415.00 32-F Irrigation Hastings, MN Total 32-F Contract $204,415.00 Total Base Bid: $1,619,035.00 Contract Total: $1,619,035.00 Office 612-332-7281 I www.krausanderson.com I Fax 612-332-0217 Building enduring relationships and strong communities Page 58 of 120 We have enclosed the Bid Tabulation sheets that reflect the bids received. If you have any questions regarding this information, please do not hesitate to contact me at 651.233.7667. Very truly yours, KRAUS-ANDERSON® CONSTRUCTION COMPANY Molly Jutz Project Manager KRAUS-ANDERSON® BID TABULATIONS Jackson Commons Park OWNER: City of Shakopee WS 31A: Site Clearing & Earthwork ARCHITECT: Confluence ce W 0 0 m Peterson Companies, LLC. 1, 2 BOND yes 0 0 O 0 00 Ln co EA Le W 0 0 OO Fehn Companies, Inc. N BOND yes 0 0 00 N O O ti crr ce W 0 0 Rachel Contracting, LLC. 1, 2 BOND yes O LC) rn O O 64 Ce W 0 0 CO Belair Sitework Services N N BOND yes 0 0 N O O co - O 1 6R BIDDER Minnesota Utilities & Excavating 1, 2 BOND yes $623,573.00 BIDDER S.M. Hentges and Sons, Inc. N BOND yes 0 0 0 O CO O O O 0 co 69 WS 32A, WS 32B ADDENDA REC'D. BID SECURITY RESP. CONTRACTOR 0 m W N 4 CO COMBINED BASE BID Page 60 of 120 BID TABULATIONS Jackson Commons Park OWNER: City of Shakopee WS 31A: Site Clearing & Earthwork ARCHITECT: Confluence ce W CI CI CO Le W CI CI CO ce W In CI CO Ce uJ 0 CI CO Urban Companies, LLC N BOND yes 0 O 0 0 0 O CO 7r - CV ER 00'000`900'ES WS 32F BIDDER U.S. SiteWork, Inc. 1, 2 BOND yes $947,849.00 BIDDER Frattalone Companies, Inc. N BOND yes $835,494.00 ADDENDA REC'D. BID SECURITY RESP. CONTRACTOR C CO LIJ N 4 CO COMBINED BASE BID Page 61 of 120 BID TABULATIONS Jackson Commons Park 0 0 N o• OWNER: City of Shakopee WS 32A: Asphalt Paving ARCHITECT: Confluence ce W 0 0 CO Le W 0 0 CO ce W 0 0 CO GMH Asphalt Corp. N BOND yes O O O O CO 64 Ce uJ CO Goodmanson Construction N BOND yes 0 O LC)0 O N 64 BIDDER S.M. Hentges and Sons, Inc. 1, 2 BOND yes 0 O O O O O LC) N EA BIDDER Minnesota Paving & Materials N BOND yes 0 O O O O N 6R ADDENDA REC'D. BID SECURITY RESP. CONTRACTOR C m W N 4 CO COMBINED BASE BID Page 62 of 120 BID TABULATIONS Jackson Commons Park 0 0 N o, OWNER: City of Shakopee WS 32B: Concrete Paving ARCHITECT: Confluence ce W 0 0 CO O! W 0 CO Curb Masters Inc. N BOND yes 0 O ti O O LC) N co- O! W 0 CO Crosstown Masonry Incorporated N BOND yes $242,499.00 O! W 0 CI O] Ebert Construction N , BOND yes 0 O O O N N CO N 64 BIDDER Goodmanson Construction 1, 2 BOND yes $228,450.00 0 q 0 0 O N N in ER WS 32A BIDDER S.M. Hentges and Sons, Inc. N BOND yes O O O O O CO O 6R ADDENDA REC'D. BID SECURITY RESP. CONTRACTOR C m W V) 4 CO COMBINED BASE BID Page 63 of 120 BID TABULATIONS Jackson Commons Park OWNER: City of Shakopee WS 32E: Bike Skills Park and Optimized Trails ARCHITECT: Confluence Le W 0 0 CO Cd W 0 0 CO Ce W 0 0 CO Ce W 0 0 CO BIDDER BIDDER Pathfinder Trail Building N BOND yes $438,420.00 ADDENDA REC'D. BID SECURITY RESP. CONTRACTOR 0 CO W N 4 CO COMBINED BASE BID Page 64 of 120 BID TABULATIONS Jackson Commons Park 0 0 N o, OWNER: City of Shakopee WS 32F: Landscape Package ARCHITECT: Confluence ce W Ci CI CO Le W 0 CI CO ce W 0 CI CO Ce W 0 CI m Greenscape Landscaping and Irrigation (V BOND yes O O O O O n LC) CO E4 BIDDER Urban Companies, LLC 1, 2 BOND yes 0 O O O O n Ln Ln fA BIDDER Hoffman & McNamara Co. 1, 2 BOND yes $204,415.00 ADDENDA REC'D. BID SECURITY RESP. CONTRACTOR BASE BID COMBINED BASE BID Page 65 of 120 *4.E.1. Shakopee City Council July 16, 2024 FROM: Josh Davis, Sergeant TO: Mayor and Council Members Subject: Declare Forfeited Vehicle as Surplus Property Policy/Action Requested: Declare one forfeited vehicle as surplus property and authorize disposal. Recommendation: Approve policy/action as requested Discussion: The vehicle was obtained through forfeiture proceedings and are described as follows: 1. 2006 Jeep Grand Cherokee, VIN: 1J8HR58236C111444 The vehicles suitable for resale will be sold at auction and the proceeds, if any, will be distributed according to Minnesota State Statute. The vehicles unsuitable for resale will be junked. Budget Impact: None. Page 66 of 120 7.A.1. Shakopee City Council July 16, 2024 FROM: Nate Reinhardt, Finance Director TO: Mayor and Council Members Subject: Monthly Financial Review - June 2024 Policy/Action Requested: Review of June 2024 General Fund revenues/expenditures, and 2nd quarter investment report. Recommendation: Information only Discussion: General Fund - June 2024 (see attachment) The 2024 Budget column has been adjusted for budget amendments approved by City Council on July 2, 2024. Revenue variances (50% target) • Total revenues were at 54 percent of budgeted revenues, halfway through the year. • The 1st half property tax settlement (including special assessments) was received in June. • Licenses and permits are tracking ahead of budget targets as a result of building permit revenues through June. • Intergovernmental is currently below budget targets, this is typical as the majority of grant revenue is received in the fall. • Miscellaneous includes interest earnings on investments, which are tracking ahead of budget targets. Expenditure variances (50% target) • In total departmental expenditures are within the normal range and similar to last year's percentage through May. Page 67 of 120 • Finance department expenditures are currently exceeding budget targets as a result of payments for the County assessing contract and the annual audit. These payments occur in the first half of the year. It is anticipated the department will remain within the total annual budget allocation. • Planning and Development expenditures are currently exceeding budget targets as a result of the professional services related to the National Historic registry. The city received a grant of $77,500 from the Minnesota Historical Society towards the registry which covers a significant portion of the overall cost. • The Building Inspections department is currently ahead of budget targets, as a result of annual software costs paid in the 1st half. It is anticipated the department will be within the budget for the full year. Quarterly Investment Portfolio Report - Q2, 2024 (See attachment) Attached is the 2nd quarter investment portfolio report including a cover page that provides a comparison of investment results over the past five years. The report provided by Wells Fargo Securities encompasses all city investments. As required by the investment policy the report provides: • Total return performance measured against the the three year treasury (Page 6) • Weighted average yield (Page 3/Page 6) • A listing of individual securities held at the end of the reporting period listed by maturity date (Pages 17-20) • The carrying basis, the current calculated accredited basis and the current market value (Page 3) As a reminder, the city's investment policy is guided by the investment acronym SLY, which stands for Safety, Liquidity and Yield, and in that priority order. Safety of principal is the foremost objective of the investment program. Second, the investment portfolio needs to remain sufficiently liquid to meet day-to-day operational requirements. Lastly, attaining a market yield is the third goal of the investment policy. The first two priorities of safety and liquidity limit the ability of the portfolio to realize comparable private sector earning in those robust years. However, the policy also minimizes the changes of experiencing losses in the down years. Budget Impact: N/A ATTACHMENTS: June 2024 Monthly Financial Report Page 68 of 120 a Investment Narrative (6-30-24) a Investment Quarterly Report (6-30-24) Page 69 of 120 CITY OF SHAKOPEE Monthly Financial Report YTD June June YTD Budget June YTD 2024 2024 2024 Balance Percent 2023 Budget Actual Actual Remaining Used Actual 01000 - GENERAL FUND REVENUES: * - TAXES 22,569,800 11,519,174 11,605,457 10,964,343 51% 10,819,158 * - SPECIAL ASSESSMENTS 14,000 10,398 10,398 3,602 74% j mo 29,817 * - LICENSES AND PERMITS 3,491,450 553,640 2,564,259 927,191 73% 3,247,143 * - INTERGOVERNMENTAL 1,679,000 3,006 373,841 1,305,159 22% 46 326,905 * - CHARGES FOR SERVICES 8,113,350 1,016,139 4,613,552 3,499,798 57% 4,120,504 * - FINES AND FORFEITS 325,200 22,368 142,411 182,789 44% 158,840 * - MISCELLANEOUS 379,200 69,170 384,695 (5,495) 101% 411111 2,376,896 TOTAL REVENUES 36,572,000 13,193,895 19,694,614 16,877,386 54% 21,079,262 EXPENDITURES: 11 - MAYOR & COUNCIL (208,000) (8,305) (69,222) (138,778) 33% + (87,272) 12 - ADMINISTRATION (2,643,925) (286,348) (1,232,697) (1,411,228) 47% (1,083,173) 13 - CITY CLERK (567,500) (48,798) (275,652) (291,848) 49% (250,522) 15 - FINANCE (1,128,925) (93,830) (758,232) (370,693) 67% 46 (698,566) 17 - PLANNING AND DEVELOPMENT (731,900) (129,528) (471,920) (259,980) 64% 46 (243,872) 18 - FACILITIES (693,650) (58,527) (280,308) (413,342) 40% (321,043) 31 - POLICE DEPARTMENT (12,158,300) (1,540,225) (5,498,217) (6,660,083) 45% (5,066,840) 32 - FIRE (3,844,100) (330,129) (1,761,972) (2,082,128) 46% (1,495,710) 33 - INSPECTION-BLDG-PLMBG-HTG (1,811,400) (471,445) (1,263,469) (547,931) 70% 46 (1,018,501) 41 - ENGINEERING (1,490,850) (160,132) (630,770) (860,080) 42% (579,114) 42 - STREET MAINTENANCE (2,822,830) (509,120) (1,302,112) (1,520,718) 46% (1,229,922) 44 - FLEET (565,100) (53,851) (271,957) (293,143) 48% (217,012) 46 - PARK MAINTENANCE (3,455,170) (449,071) (1,637,755) (1,817,415) 47% (1,512,032) 67 - RECREATION (5,208,560) (549,053) (2,465,822) (2,742,738) 47% (2,277,139) 91 - UNALLOCATED (13,100) (410) (2,801) (10,299) 21% + (16,586) TOTAL EXPENDITURES (37,343,310) (4,688,773) (17,922,906) (19,420,404) 48% (16,097,304) OTHER FINANCING * - TRANSFERS IN 611,360 0 0 611,360 0% 0 * - TRANSFERS OUT 252,550 0 0 252,550 0% 0 OTHER FINANCING TOTAL 863,910 0 0 863,910 0% 0 FUND TOTAL (200,000) 8,505,123 1,771,708 (1,931,658) 3,939,393 Key + Varies more than 10% than budget positively 46 Varies more than 10% than budget negatively Within 10% of budget Page 70 of 120 City of Shakopee Investment Information June 30, 2024 Investments The City currently has a cash and investment balance of $100.9 million compared to a balance of $89.8 million one year ago (excludes unspent bond proceeds). The City's total investment gain for 2024 is $1,375,603 which is comprised of investment income in the amount of $1,295,931 and an unrealized gain of $79,672. This compares to an investment gain for 2023 of $1,226,377, which included investment income of $945,806 and an unrealized gain of $278,571. The City intends to hold all investments until they mature, however it's important to keep in mind that changes in market interest rates will impact unrealized gains/losses of the investment portfolio. Rising interest rates in 2021 and 2022 resulted in unrealized losses ("paper losses") over those years, while declining/flat 2020, 2023, 2024 rates led to unrealized gains. $2,000,000 $1,800,000 $1,600,000 $1,400,000 $1,200,000 1 000 000 $800,000 $600,000 $400,000 $200,000 WOO $- t�%%%%%1,„r. ...n uuuuu llmuulllluumo1 �Illl� Interest Earnings by Year 2020-2024 444 004 amu»nnu�n »»! ,mommm ............ mmmmolololol�V!&�1� oullry�'UIII�IV?Illumluunnnlulouounnnlulouounnnlul��lll��oomm, ullllnulit 1st Quarter 2nd Quarter 3rd Quarter 2020 IIIIIIIII 2021 ����������������� ot����������������� 2022 mnn,nl„m�tn„nnnnr 2023 ! , p,""»»»»»» 2024 OuniounX 4th Quarter ....................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................... $1,600,000 $1,200,000 $800,000 $400,000 $- .. $(400,000) $(800,000) $(1,200,000) $(1,600,000) $(2,000,000) $(2,400,000) $(2,800,000) $(3,200,000) $(3,600,000) $(4,000,000) $(4,400,000) Unrealized Gain (Loss) 2020 - 2024Ao 000 ........................................................................................................................................................................................................................................................................................................................................................................................................................................................ ,oAouuuuuuuuuuuuumu 6 �669v�vimv, ...................................................................................... uuuulll!�'11 1111Q1 uumouuumummi uuuuuuumu oumuoum aa.......................................................................... mmndmuluou MImom,nnmumumuo411111111111111\111 11111 ppppp muml1 olouuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuullmolouuuuouuuuuumouuuuuum MINI uuuuuuuumlouuuuuuuuuuuuuuuu IR llllllullu»u umloumloumlou nnoum �wNl» .�,m,n,1l`mlllnm .mm»m �1\ ������������������������������������������������ ulluuu� ���Ilml���llml���llml���llml������llml I11111111II al�mmotiSR°" 11(III �k, uuwvvvvvvvwnmgauuuuwaaapgnN„,„„„..................„„!„............................................................. nnvvum �lulumunumumumu, !n�l�. uuannluuannluuan �luuuuu�mumumumaonumumummnn NVuu Jr, 111u 110),a Nl I uuuuul.........,, ill'Ipll,' uum,,,,,,,uuuuuum 111111111111111111111111 ............................................................................................................................................................................................................................................................................................................................................................................................................ 1st Quarter mmin111111ultan„nn111111w 2020 ...00...2021 2nd Quarter 3rd Quarter 2022 mnnmm4um„n,2023 ,,,,,,,,,,e /gm2024 4th Quarter Page 71 of 120 0 • 71- 0 00 Analysis Date: 6/28/2024 Portfolio as of: 6/28/2024 Market Data as of: © 2024 Wells Fargo Bank, N.A. All rights reserved. Confidential Page 72 of 120 Table of Contents CO N CO Ol r-I N N N N N M CO Treasury, Agency, & SSA - Summary Money Market Sector - Summary Brokered CD - Summary Municipal - Summary MBS Fixed - Summary CMBS & SBA - Summary (Y) l0 N CO 0> N l0 0 r-I r-I N Portfolio Summary Cash Flow Report Historical Performance Duration Contribution Projected Call Report Credit Rating Monitor Positions by Sector Positions by Maturity Positions by Maturity - Scenario Analysis © 2024 Wells Fargo Bank, N.A. All rights reserved. Confidential. Page 73 of 120 Portfolio Analysis M Portfolio Su ary ■ 4 0 V N C } ■ •st O u)7r.-...I rl I� N 61 Cv) M N I- Lr 0 'Tt dry N N O O O Number of Positions r-I r-I r-I 0 0 0 fA a. a Book Value ($000) Mkt Value w/o Accrd ($000) Unrlzed Gain / Loss ($000) t6 s d OI C0 O. C M 0 d o v u 0 0 0 v c0 Q N U ■ N r-I Ol 0 M O N N r-I O m i() Book Yield Market Yield Wgt Avg Maturity Effective Duration Effective Convexity 4,N N 't r-I N CO I, N GI N N c6 Overnight Funds Principal Overnight Funds Interest Term Securities Principal Term Securities Interest Total Cash Flow . rNI • -I Ifl OM I . 1 ■ • • • ■ • r7 *Cash Flow Projections Chart -1 Year Cash flow does not include OM Cash Flow or Run Off Yield © 2024 Wells Fargo Bank, N.A. All rights reserved. Confidential. Page 74 of 120 Portfolio Analysis Cash Flo Projections +i.. CO L9 (9 d 00 M V d' CO r a)", dct O O 0 01 10 O N G5„ d 0 0 N N M M 10 CO L9 O M N 61 m tD 1n 61 rl O "Ln .7t Ln O in r m oo d o ▪ M N O r1 CO 1'. 0 L"33.: L4 O N ct tD 61 ri r-i ✓ i r-1 N N N N M M M ct 45,472,724 O 1` N O N L9 r M N r� ct M 1n O N 61 M N ri O 01 0 t9 d 0 M 61 (31 in in LD o ri LP f\ 61 0 6i d ui d N 10 O 61 6) La Ln d 61 d d d O1 M ri r 1n r1 r-1 d O 0 Ct M 61 N M ct r 00 61 O N M 1n Ct Ln in in in 1n Ln to 19 10 L9 rI N 61 M N ct CO r N Cr) ID CO 0 d Ln 6) r N L9 CO M Ol ct '1 LD CO CO O1 61 M N t9 : M r` N 10 N N 0 N N N Ln O d 61 O rl t9 0 61 M M ri dP® Ln 0 t9 ri CO 61 r-1 r I 61 61 Ln 1b ri N M tD t0 r CO CO O N rr r r rN rN Co O .fA 00*. ri N M O 6l Cr Lr) O ri M 67 LD in 61 in i9 d d O lfl O Ln oo r-i N d 6) Lh rl N Cif Ln r- 61 r M O 0 r d r-1 61 cr 61 r-I d N (.0d 01 CO in M aa�xl N r d O M ooLn M r-I 10 Lo ;� M Ln 6) r d O co N r 1 co O O in co in M Lo 61 10 0) r-I d rrid O N O N N 61 O O 't r1 r- I 0,4 X '1 N O r- m M 61 ct N O N 61 d 4 4 61 ri ci O O 0) r* Y 0) M O 61 O 61 O N 01 O M SS`}; 1n 61 O m LO N Ln in in Ln r` co rI O r O 0l d' in 0) O d ° m cr. 1n O O V m 61 M O oo N ri W m r- L9 N r CO N d ri O Lfl r in a) M m r-I d 61 L9 Lfl La `7 r- ri r-I co I`r O Ln do M N M N r-I M r'r) r-I 1n c � r-i N r-I N r-I ri r-i r-I ri N r-I M rl N r4 4.! O r-1 r-1 t9 Ln r N LO N r N r i d r-i O cn O O ct o 0 CO r-i r-I r-i 1r} O 10 N 0) cr Lr) ri N � l9 CO (.00') r-I 00 COr-1 O O Ct N O 61 r`` tD cr M N r-I 61 r-I M O O N NI 00 M N M CO . in 6d1 in rM-1 in in ct 111 cr O N N r-1 N N ri N N r-i 11) d r-i `0 0 0 0 Ct O M r-I r t9 000 t9 r r-1 d CO r, M r-i M o 0 0 01 ct • M r'n 0 0 lD O r 61 1n N O N N CO tD r-1 M rl CO 61 N M 61 CO CT 01 CO M (3) "- in M co co ct co L9 in in O 0) 61 61 N 10 M M 01 O CO O 1D O In ri t0 LC idN M N in O rl r ri Ct Ln N M r 0 r L9 N N N r-i N N ri N r-I r 1 N d cr 1- d cr 1n in Ln 1n N N N N N N N rV N N N ,= ) v cL v O < 1 CC16 eL CCra -, Q 1n 0 z 0 LT. G Q ri r ri 1`O t9 r-I M M M Ct ri Ln ri M 0 N r-I t9 LD 1n N N O d M N O M N N rl N M M co m tD 0 r cr co to cr N Ln co '-'1 d M r-I 0 0 • N • 6l - r-1 N 1ry LO � 00 CO CO CO 0 O L9 d 0 0 r--I N r-I o N r, ri N • ri ri ri rl r-1 r-i rl Cr 1n N O r` r1 CO 61 61 rl co Ln 0 6) 0) N 6) O1 N Ln M r) CO N 00 M 0 N N r-I N N O O N N 1d) LO N) LO Ln 19 N N M r-I 1 r-I ri ri N r-i ri N CO L9 d r- O 6l 0 N M d' CO 10 61 61 ct CO O 01 CO 1n r-1 O O N Ln 0 0 r-i 01 10 CO M 6l r-1 O 10 rl 61 O oD ct 61 O ri 0J Cr N r Ln ri Ln N 0 1n ri ri ri r-i ri ri ri r-1 r-1 ri r-1 9 Lf7 Ln 1n (D L9 N N N N N N N N N N j m 43) V O N • CG EL 1a 11 N 61 N ri 0 03 oo M 01 (D 61 O N d 0 r-1 O O O N O O 1S� r i r i N ri N 04 04 d d M M 66�Y, 1 r-1 O ct r r `t N O d 0 r-1 61 M rn O N N M 61 notD co 1D Cr) M l9 r: Lp ~ Lod d N O C0 0 �M1n5LnN0��01d N ri M r_ CO N L9 0 0 0 0 r 0 L9 r-1 I`• d d 0 d r N O r, r1 Ln N I`• 1`• 0) r-1 0 t9 0 I`` O re) rLD r`• ct cf M M ri N N M r-I r-1 N r-1 r-I r1 rl r-1 N r-1 ri r-I O M N Ln ri 03 N Ln N M d d 61 10 0 O M O N M O o- O r O ri ri ri ri ri ri r-I L9 1D LO 19 LD L0 N N N N N N (3) p„ > V Q 1n O Z O Nr N N N N C i0 d ra LL Q 011 m„„ �Y 01) © 2024 Wells Fargo Bank, N.A. All rights reserved. Confidential. Page 75 of 120 Portfolio Analysis Cash Flow Projections - Continue Ln 00 61 00 01 N M N (D CO N N on O co f` 't f`• co M 71- (0 LO M Ln Ol 0 ri rI Ln N N N 01 LC) 00 N Lfl 01 'St 0 in vt in O in on 00 ri N N N i" (O r-i O It r-I O O Ol r i (0 (D (.0 Ol St N N in Lf) on N in M O co N N N 71- r i N q' Ln Lf) rl O) co co N I- d O O O Lf) 00 (0 O Ln f'd dt `,t (O 7t (O N N Ln lD Ct N Ct'ar h M Ol N Ln GO (O L0 Lb co (D lD N O 00 (D 71' (D (D 4'`'Jf `•,t CO M 6i CO 71- Ln St r i 00 N Ln Sr O (0 CO CO N CO 00 st H O H M N M on N N 4 M; r, Ln O O 'Sr ri OO N M M 10 ' h W on 1- I` M rY 1- M 71 Ln (D (0 (O N 00 Lb O r-1 if T' N et Ln Ln Ln (0 (D N N N CO ( J O1 O O r-I r-I N V 71- Lb co co Lb Lb 0O 00 00 00 01 on O1 on O7 on on O1 61 al 01 01 O Q5'i4 01 0 0 0 0 0 0 0 Ln �t r-i 01 H CO H 0 M N Si" -1t in 0 (D (D N Ct co Ct Lf) Ln G 7rO O N Ln N O c0 rn M Ln 7t O O(0 N 00 7 N r-I M 01 0) O r-1 CO N r c0 r-i 0 if Ln (0 61 r-I H CO o in m o • if N M LC) Ln 0 r-1 GO N M r-1 M co M O O N 61 N d' Ln r-I r-i M •St N N •St M Ct r-I Cr) (O (M N r 0 M Lj N O 00 (I)(4 N O 00 (O N Lf) N fn Gt M �t Ln 00N N 00 Cr) L0 r 61 (D Ln o 71- M co LO N r-1 GO H Ln �t in GO 0 00 0 0 r 6l O r 00 lD 6_1 f`` N 0 • M M N r-i O O GOO r-i r- I N r-i r-I r-i r-i r- I r-1 N (0 r-i r-1 N 61 t 61 O M r N. Ln N 'Sr N 'Sr Ln 0 r N LO (0 r-i fh 01 N d' N r4 LI) h� 61 (D lO N Ol GO st 'Cr N 00 00 c0 co M N N N N N N N N N N d (n O Z 0 u_ d (0 N r-1 (D N N M O (D O N O 0) 0 Lf) Lfl N in M Ln CO N ri r` 00 c0 co O Ln 61 N (0 ri O r-T N r-1 r-1 10 N O c0 O O r-i r i M N M O)st N (..0 1 O 1fl O r-1 (0 on N r 1 r 1 f N r 1 hr N CO N M M co O M M r-1 N V tD 00 1-1 M r.,. r m r r 61 N Ln �t O (O • ,t O O N oC Ol O N (0 r-1 r-i r-i ▪ M ,1 M N co co M co N N ri CT) in ID M c r` N f` Ol (0 N OO 7-1 M V O Ol O 00 c0 1`, h • h (D N CO r 1 (0 M 61 Ln in M r 1 CO `Cr CO 0 'Sr OO 00 0 N. Lf) Ln CO 0 0 0 st N N (0 't N N Ln N Ln 7t N r-1 d' CO co M M (D N CO (D M CO N co co co 00 cO N pl 61 61 N c0 N N N N N N N N n'1 V N ▪ v d Ln O Z ▪ d o 104,543,319 104,610,160 105,177,593 0 CO N Ln r-I r-I GO L O Ct r-I M M [t N (D (9 LT 01 01 N (t CO f`N Cr) M O) 00 N 00 GO st N Ln (f) M N N N O N lD N an co (D LO N Ln 00 Lf) Ln (0 (.0 O in M in O Ln r N CO M M Ol (O N O cn 0O 1, O on in r,r-i r-i M in (31 (D r-I d: r-I M r-I in in .4 r-i r-I N Ct GO((O cc) N O O N Lb 1-00 O N O al z oci Ln (0 r.i CY • O O ^ �V co in Cr)01 N01 st (0 - sr r-i (.0 N (D 00 (D N N N r--i l0 (0 Lf) LS) 1- rN-I d' M 71- N O Ln 00 0 0 M S r 0 (D N 0 Ln 0 0 N r-i N N Ln (D N (0 0) St (D 0 1` r-i O r 01 O O O N O (0 c6 1` (0 M N Ln M 1, M M r-I Ct Ol Ol GO 01 0 0 0 0 0 61 N fV l'V N N M M M M a u o av v ^� n ° d Ln 0 z 0 c d © 2024 Wells Fargo Bank, N.A. All rights reserved. Confidential. Page 76 of 120 Portfolio Analysis ist.rical'erf.r ace O o a o a o a o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ( 0 0 0 0 0( 0 0 Lf7 lti V M M N N. M M .1 rl rl rl rl rl rl rl rl rl rl rl rl O 0 0 0 0 0 0 0 0 0 0 0 CO LD Lf1 LD M 0 .-I 61 01 0 0 rl O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o a 0 0 0 LC)O N 0 (0 N h 01 ID O N LO LO LO LD L(1 r l0 Ifl (0 LO lfl LO LO rmlll00000000000 N, 0 0 , l0 B O O M hLn h + + + + + + + + + + + + Q Q Q Q Q 4 Q Q Q Q Q 0 2 2 b 2 2 2 10 0 2 0 2 d Q d Q d Q d¢ d d d Q 61 (5) N lf/ LO 61 61 61 61 M M N rl rl rl rl rl rl rl rl rl N N N c1' la7 M M N Lr! M V M O O a?N N N N N N N N N M M N O h 01 0 03 61 r LP Lf1 61 01 V W LO CO N 0 0 7 N 61 CO N M 01 } V Ln Ln V 01 V N N O O 0 01 (0 0 61 01 r V (0 61 h` 0 07 ID M .-I M LC) 0 LD 61 h` Ln Ln V V Ln Ln 0 N 0 0 0 N 0 N cY CO M 0 r-I CO hN 61 N N cY 61 61 61 1 lD o h N CO 0 01 L(1 O N 01 Ln CO 1"-- CO 01 f OO 01 01 lD CON 61 ✓ N M N is, r-I' (A M W W M LD O 61 0 01 01 CO CO CO CO LO h LO 03 0 ,-I r1 0 r-I N LO (11 0 CO O 00 00 1`, rl N 00? rl rl rl M M N N N N N 01 0 CO V N ID LD M 01 CO L11 cY r-I 01 0 0 h1 Lf1 lD Lf) Lf1 N M M N r-I N 01 cY M M 01M N N N N r-I r-I NNNNNNNNNNNN 0..00..00..0 01 01 M 01 (0 M M M(0 M M M ID M N 01 ID M N 01 LD CO N 01 00.000.000.0 I11111\111\1\1\1\1\1\1\1\\\1\\1\\\\1\\1\\1\\1\\1\\0111111111111� �111111111111111111�11�11��1�1�111111111111111�1��1�1�1111111111111 1111111111111%1111111111111\I91\1111111111%%111�111111111�1�11�11 1• 1111111111111111111111\111\111\111111111111111111111111111111111\�1111111111 �• 11111111111111111`��111111111111111111111�1111111111111111I =111111111111\0111\11011\1111011111011111\11111110111101\1111111\011010��11111011 =III0\1101111111\0101010�1Q11111111111\111110100101111011111\1111110101 %%% l l\0\1101\1\1\1\\\0101010\\1\11\11\11\\1\1\10100101\11011111\1111010011 %�111111111111111111111111111\1\10110111111111111\0111110101110101\11 / 111111111111111111111111111111111111111111@111111111111111110\0\11111 • 11111111111111111010�10�10010101010011101111101001101111111\1111 000000111\111\11011\111011111011111\11111110111101\111111\1111111011110 11 • * Portfolio Allocation is a new addition to portfolio analysis. Data will be added over time. © 2024 Wells Fargo Bank, N.A. All rights reserved. Confidential. Page 77 of 120 Portfolio Analysis 1 Yiel / luration Canal rution ,-I O. O O. N rI N M rI O M r c0 0 N In LO O r-I N 0 O r-I Lf) r I r I O OD M N Lr) M r-I r1 kdrr�V co If-- N N O M r O O rry IL c Ll 0 o lfl in 0 N O M ,� n -I LO m N N N C oo M Lr ( 06 N VC N r` N mb o1 M O71- l0 co In coco co Ln ,—I LO 0 m N N LO M Ni-r-I r-I r-I r1 N N LLc,r-I O m rro M l0 ,-I-I N O ,H r-I lfl r lfl oC N r-1 i LO 71- r-I 00 • rCO re) 0Mj to N Ib 0")N [xi (NI Lf1 r� l M r-I r1 r1 r1 07 O O M N M of {n M co O N O M r-I rl rl 7-1 h CD CD Agency Pass Through Certificate of Deposit to i f1 mco V cn F- © 2024 Wells Fargo Bank, N.A. All rights reserved. Confidential. Page 78 of 120 Portfolio Analysis I' In N N LO 0 N o 7r 7r N LO 0 r'J rl 0 0 N ▪ N LO N rl 0 03 m 00 L.0 N N (9 0 N r-I I", 0) 0 0 z 00 z 0 _J w 2 < 0 • _J O 00 0 I-LI CC LJJ LL. 00 C C CU CU CD 01 < < LL rl rl Lnrl in to N N N N r--1 r--1 0 0 N N (ON N r--1 N 0.1 N 0) r,C0C) 0 0 0 0 0 0 0- C- O Ln 00 t.0 o N N N rl (ON. 0 0 rl z m rl rn 0 N N In N N r--I z 00 z 0 w 0 _J LLI 0 w LL © 2024 Wells Fargo Bank, N.A. All rights reserved. Confidential. Page 79 of 120 Portfolio Analysis ra 0 iJ eaea N N N N N N 1-1N O N rl l0 Ln V N V V O O O O O O 0' + + Q + Q Q Q Q Q Q M M M M M M M M M M M M M M M 01 M M M N N N N N N N N N N N N N N N NNNN N N N N N N N N N N N N N rl N O O O O O O O O O O O O O O O O O O 01 oD W W W W W W W W W W W W W W W W W O O O O O O O O O O O O O O O O O O O + + + + + + + + + + + + + + + + + + + Q Q Q Q Q a a a Q Q Q Q Q Q Q Q Q Q a a Q Q Q Q a a a Q Q Q Q Q Q Q Q a a a Cr V d' 0 r-1 Cr d' M M M M M M 00 M 0 M N N r-I 0 0 r-I 0 M N 0 N N N N N N N N ri N N N N N N N N N N N N N N ri N \ ri N (\I ri N N N N N l0 ;Si 01 01 01 10 I'h 'CO 00 M LD N d NN 01 lb IN. O N dJ V Ln W O I- s.M N L0 r-I IN lb O N \ O O rl O r-I N O O O N O r-I O ri 0 0 0 0 N 0 r-I r-I N r-I N r-I \ r1 l0 0 'MO- O M 0 M N r-I O r1 r1 O O s.O 0 0 CO l0 0 0 00 W 'Ca0 N W 0 M 0 L0 l0 O O 0 rl O O O rl rl rl rl rl rl rl O O O O O O O O O O O 0 O O O O O + + + Q + + + + + + + + + + + + + + + + + + + + + + + + + + a Q a I Q Q Q a Q Q a a Q a a a a Q a a < a a < < < Q Q a a a < Q a < Q a ¢ a Q Q a Q a Q Q Q a a a a a a a Q Q a Q Q Q a a C' Cl" V d' V 0 0 V M M M M M M M M 0 M N N r-I 0 0 r-I 0 M I1 0 N N N N LO 0 NNNNN N r I N f\I N N f`I N N N N N N N N ri N N ri N N r1 N N N N N ` r-I O l0 O 0 V t0 LD -CO.- CO 01 cy l0 N 0' N O L0 00 61 W N ri 'Co N i-i ri M M ..--co N CO N l0 LD \ 0 M N N 0 '4 r1 rl NH O O O N O N O r1 ri O O O N O r I N N r I N H . r-I N N l0 l0 V M V 0 00 V N r1 0 i-V ,-V 0 0 61 N. N. W 10 M N 'CO W W N M 'CO M L(1 LO t\0 01 ,( O O O 0 O r-I O O r-I r1 r-I r-I r-I r-I r 1 O O 0 O O O O O O O O 0 00 O O O O O N N2 2~ N rt ro N Q Q a Q Q Q Q Q Q Q Q Q Q COQ Q Q Q Q a Q Q Q Q COQ ¢ a Q Q Q Q Q Q O O O O O O M O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O N O O O O O O O O O O O O O O O O O O O O 0 00 O O O O O O O O O O O L0 O O O O O O O O O O O O O O O O O O O O O O O O O O O O LCi O O O O' Ln fV O O Ln O O 0 O Ln 0 0 O O O L0 O O O O' O' O O O O 0 O O O b N O O 0 0 lD N 0 0 M 0 0 L0 0 LO 0 0 0 0 0 L0 Ln 0 0 N O 0 0 0 0 L0 O O O O N 0 LD lO l0 r-I M lD Ih Ln to N L0 L0 d' L!1 0 0 00 CO CO 10 ri 40 Ln LI1 lD LD L0 0 LD 0 0 0 O N ri '4 '4 ri N ri ri rl ri rl V' lD r-I N 01 l0 r CY N 0 I1 CO M W m r-I 00 Ln 0 40 40 0 Ln Ln r LO M LO V' L0 MI 10 l0 L0 L0 N N m N N N N M N 01 N N rvl N N M N N t\9 N N M N N N N M N N N N N N N N O O N LO ra (0) H 0 rl O N 0 LI1 M co I1 0 N L0 I1 ri M 01 I1 M N O rl M r-I O N M r-I b r-I O N O N O O O r I N r I N N N ri N N N N N 0 r1 O r-I N N r1 M 'LB 'al- 01 m �-1 M M M N N O N N N 01 \ 0 0 N 00 01 W N Ol W V 10 l0 (0 00 f-I 0 b O 0 0 0 0 0 0 r-I r-I 0 r-I r-I 0 0 r1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O00 I1 M IN 0 0 0 N O 0CO N L4 l0 0 00 IN N 00 LO N 00 0 N rM1 lO M 0 0 01 O 10) N V V M 01 CO V ri Ln 7 V' d' r-1 N V' V N d' LD V d' L0 7 N d M V M I`` d O Lfl O V N O US TREASURY N/B FEDERAL HOME LOAN BANK FEDERAL FARM CREDIT BANK FEDERAL FARM CREDIT BANK US TREASURY N/B SAN FRANCISCO CA CITY & CNTY OREGON ST FEDERAL HOME LOAN BANK CANADIAN CNTY OK INDEP SCH DIS FEDERAL HOME LOAN BANK FEDERAL FARM CREDIT BANK FREDDIE MAC FEDERAL HOME LOAN BANK FEDERAL HOME LOAN BANK y, y, N l6 V T U L n n U n U U T U U N N W N N C C N j N N N Ul Ul hnn Q Q Q Q Q 9128286Z8 rl 109 3130B1NX1 194 3133ERDM0 125 3133EP6K6 166 91282CJW2 79773KBH6 133 68607LXQ5 3130B0X87 135537GZ5 3130AY6T8 O1 01 01 0 N 00 N i r 140 3133EPH81 157 3134H1FR9 208 3130AXQZ4 165 3130AXQK7 HENDERSON NV O_ 171 425201AZ3 FEDERAL HOME LOAN BANK FEDERAL FARM CREDIT BANK TENN VALLEY AUTHORITY FEDERAL FARM CREDIT BANK FREDDIE MAC FREDDIE MAC Z Z Z Z ZZZ Z Z Z Z Z Z Z CO m CO CO m CO m f- h f- h f- f- f- ❑ 0 0 0 ❑ ❑ ❑ W W W W W W W U U U U U U U 2 2 2 2 W W W W W ¢ a a a a a CC Q Q Q Q Q W W W W W W LL 2 2 J J J J J J W W W W W a Q Q Q a Q Q Cr CC CC CC CY CC CC Z Z Z Z Z uJ W W W W W W Z Z Z Z Z 0 0 0 0 0 0 0 a a a a a W W W W W W W W W W W W W W W W W W LL US TREASURY N/B US TREASURY N/B T >. T u T >, >, 3 T >. >. >. e. U U V V V V V V U U V U V 9 N N C C 0) lT Ul N N N N N Ul C Cl 01 01 01 N 01 N N W m D7 D7 m m an an m m 01 01 UI a¢ a a a a a a a a a a a a a a a a�� 3130AXEZ7 3133EPWP6 880591 E W 8 00 N a 182 3133EPKKO 3134GX588 3134GXXS8 LD CO M LO 181 31359MF17 3135G03U5 3135G05X7 01 l0O 138 31364FCB5 3136G4N74 205 3133EPBR5 108 3133EHWV1 3133EL410 3133ENTK6 3133ENWT3 3133ENXE5 3133ENZFO LD W co 7 LI1 O1 105 9128282A7 9128283V0 © 2024 Wells Fargo Bank, N.A. All rights reserved. Confidential. Page 80 of 120 Portfolio Analysis 0103 m M M M M M M M m 01 (+J m M m M M N N N N N N` N N ` N N N N N N `N `N N rl O O O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 CO 0 00 00 CO W W W 'Co- W W W W W W W W o0 o o O O O O O O O O O O O O O O O O + • + + + + + + + + + + + + + + + + + a a a a a a a Q a Q C a a a a a a a a a a a a Q a a Q a a a a a a a a NNN N (V NNNN 0 0 ii3 h ri 0 ON 0 N N N O O 0 ri rl r1 r-I a a a a a O1 M M 01 N N N 1.0 N 0 N N N N N r-I ri N N rl N N N rl N N N N N N N N N • (0 l0 O1 l0 l0 (0 LID 0 I: M N ri (0 0] 03 N N O ri O O N 0 rr-I N N M O O (D 10 M h ((1 10 O r1 l0 N 10 -CO: V ('0 -1 r1 r1 O 0 0 0 0 0 r1 0 0 r1 0 0 O 0 0 r-I ri a + a a a a a a a a¢¢ a a a a a a a a a a a a a a a d a a IN 01 01 01 01 0 0 0 (0 ri rl N N N M CO M M M M M 0 ri r1 N 10 N N N N N N N r-I ri ri ` ri rl ri N N N N N N N N N N N N N N N N N N N ((0 r-I (\I N N N N N N N N 03 rl M N N 03 OO (0 (0 (0 coV V V l9 W N (n N N M ri (0 l4 l0 W l0 O co h ((1 W ri (0 00 N 0 N O O N N N N N N NNNNN ri O N N 0 0 0 0 N 0 \ \ r1 \ N N 0 0 0 N O O N N N lft 01 l0 ri N (0 l0 l0 l0 N C h 10 N, 0 N N O ra (0 10 N lft 7 N N rl ri O r-I H rl ri 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ri r1 3 0 0 0 0 0 0 0 0 r-I . ri ri N (+1 M N rl (6 N 6 T a a a a a a a a a a a a¢ a a a a a a a a a a a a • a a a a a a a a 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o O o o O o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o O o o O o 0 0 0 0 o O o O o 0 0 0 0 0 O O O O O (0 Lei Lei O N 0 b O O O O 0 O b 0 O O 0 O O • 0 O 0 0 O O (0 ( O O (f1 O CO 0 N N (0 IN (0 (0 0 0 O O O 0 ri (0 0 0 10 Qt O) 0 rl O 0 O 0 0 1.0 (0 O N l0 rl dl N CC H N N (0 H 10 1.0 V' rl N 1.0 10 lO M lD N CO 19 V1 rl V N ((1 O O O (0 l0 O ri rl ri rl ri rl ri 0- 10 ' 10 (0 a 10 10 (0 Cr (0 l0 CO 10 (0 10 CO 10 (0 0 CO (0 (0 N GO 01 1.0 03 00 111 N 10 N 10 0 (0 N N N N N N` N N N N N N N N N N N N N M N N N N N N N N (0 N M N N N w N 10 O r1 i-1 O H \W r-I O lfl r1 OJ O r-I 10 (0 61 (fl ri N ri M r♦ (0 10 ri ra ri r1 (0 (0 'Cl.1 N ri H V ri M M M (0 M N M co r-I CO N CO M ri r1 N r1 0 r1 0 r1 0 r1 r1 0 O \ 0 O 0 N N O ON N m O O ri N N ((1 01 (0 ri N (0 oO O N N V 10 N 10 01 03 N N O O l0 W (0 (0 V (0 r O r1 O O ri r1 r1 rl co O O O O O O O ri O O O O O O O O O O ri r1 O O O 0 0 0 0 r1 r1 (0 M O CO M (0 M (0 (0 00 (0 0 (0 (0 co O O (n O O N (0 M (0 0 0 0 N (() CO CO (() (0 01 03 N 1p 10 10 lc) 03 r1 N N M 0 (0 N 03 (D 0 0 10 M 0 N N l0 r 01 ri 01 10 N. N N M rl 01 01 N N rl rl rl ri ri ri O O O O O rl O O V V M N l0 (n Ln N ri rl ul N M ri M US TREASURY N/B US TREASURY N/B US TREASURY N/B US TREASURY N/B US TREASURY N/B US TREASURY N/B US TREASURY N/B US TREASURY N/B US TREASURY N/B US TREASURY N/B US TREASURY N/B US TREASURY N/B US TREASURY N/B US TREASURY N/B US TREASURY N/B US TREASURY N/B US TREASURY N/B US TREASURY N/B SAN DIEGO CA CMNTY CLG DIST FEDERAL HOME LOAN BANK N E IA CMNTY CLG FEDERAL HOME LOAN BANK NEW YORK NY PORT AUTH OF NEW YORK & NEW JE PORT AUTH OF NEW YORK & NEW JE CALIFORNIA ST TAMPA BAY FL WTR REGL WTR SPLY FEDERAL HOME LOAN BANK SAN JOSE CA UNIF SCH DIST SANT FEDERAL HOME LOAN BANK FEDERAL HOME LOAN BANK FEDERAL HOME LOAN BANK FEDERAL HOME LOAN BANK UNIV OF WASHINGTON WA UNIV REV MISSISSIPPI ST FEDERAL HOME LOAN BANK rp C3 • .3 .Q Q O_ • .e = • Po e > > >rt h 9 9 N9.• N v N v eWNNN v NN NUN - - N fle - VNT a a g a g a a a a g a 123 912828V98 112 912828YG9 912828YM6 01 r a 03 N 0] N r-I O1 912828YU8 912828YY0 912828ZC7 912828ZT0 91282CAM3 M r1 N N N O '- N N M N h rl ri 91282CCT6 142 91282CBJ9 m ✓ N 0 N 01 O1 co 148 91282CBZ3 107 91282CCW9 91282CDB4 91282CGL9 CO 10 .1 00 91282CGP0 V ri 91282CGV7 01 103 797272QR5 184 3130AWJ27 152 664214P56 3130AVB84 158 64966QCE8 122 73358XDB5 73358XDC3 13063D2W7 M l0 V 03 ri ri 875124G52 134 3130ASGU7 160 798186P30 3130A56N4 199 3130A55M7 3130ARVZ1 0 128 3130ARJH5 91523NWV4 188 605581QQ3 119 3130APTE5 © 2024 Wells Fargo Bank, N.A. All rights reserved. Confidential. Page 81 of 120 Portfolio Analysis N N N N L l0 \O 01 0 N 0 1 0 V M -Ni N 0 0 0 0 Q Q Q a d Q Q a Q Q H d 01 0 O 01 0 a a -1 01 01 01 .-I -1 01 ri rl .-I 01 01 -1 ri 0 0 0 0 01 01 00 00 I� NNNNNINNNNN N N N N N N N N N N N N V' O LO O 0) Nl M M 01 h O LO LO d' V O ri LO O 8 N 01 V Ln 00 V' r ri M N r-I O N ri r-I 0 0 -01 N O 0 0 ri 0 N N ri N ri N O O O N 000 0 0 0 0 8 0 O 0 0 0 0 0 0 0 0 0 l0 0 0 0 0 0 0 0 O N O O 0 0 . ri O O O O O O O O O O O O O O O O O ri 0 0 O r-I O O O r-I Q d Q d + + + Q + ¢ + + H d H + + + + Q + Q a d + + 4 Q d Q ¢ Q H Q d ¢ ¢ ¢ d H ¢ H ¢ H Q ¢ Q a d d ¢ Q ¢ Q Q H ¢ ¢ ¢ d d ¢ H ¢ H Q H Q d ¢ Q 01 r1 N N 01 N N N 01 N 01 N N N N N N N N N f\I (`I 0) M M (5 0) 0 W O M L0 Ln o N 01 0 0 0 \ \ 01 N 0 00 I� r r r r L9 l4 V M 0') O O 0 0 0 0 0 0 0 0 0 ri 01 0 0 0 0 0 01 01 00 CO N N N N N N N 01 rl \ rl ri H O ri 01 « 1 r 01 Lfl 0 l9 00 V' h r-I 0 i-1 N . i-1 0 NO OON N N 0 01 N l0 M O 0) 0 l0 . O O . 0 0 0 0 - 0 0 0 -I N a rl N¢ ri N 0I ri -I a a a a aa a a a a a s a a a a a a a a a a o o 0 0 o O o 0 o O o o O o 0 0 o O O o O o O o O o 0 0 0 o O o o 0 0 o O o O o O o o O o 0 0 o O O o O o 0 o O o 0 0 o O o o o 0 0 o O o O o O o o O o 0 0 o O O o O o 0 o O o 0 0 o O o b Ln O Ln 0 O O N O Ln O b 0 O O O O O O O O Ln O b O LO' O O O O O M a O N O 03 O N. 0 0 00 N 0 0 N 0O 10 N l00 0 0 10 CO 0 0 0 ▪ 0 H N 0 ti N O 11 01 l0 10 LO l0 l0 10 l0 l0 01 l0 CO 10 CO LO 10 01 LO 0 l0 0 N. 0 1.0 . 1.0 01 V N m N N N N N N N N N N N N N N N N N N E.' PO (,:,,..1 N N PON PON N N 01 O 00 01 lO W CO ri 018 01 b N O N --1 --1V V ri ii to r, to ri i-i -I i01 N .i 0 MO ON 0 NON M O M �-1 M �-1 O O N N 0 0 i-1 0 �-1 0 0 O 0 o-1 0 0 61 N I� N 00 L\!1 V r-I �-i 10 to 01 0) (0) 10 V V' .-1 .-i N W CO N W b --1 �-I V' N CO N 0 r-I 0 . 0 0 0 . 0 0 0 O 0 0 0 0 0 . . 0 0 0 0 . 0 0 0 0 0 1 0o 0 �-1 N CO O CO l00 0 co to N 01 O O L0 b 10 LO LO N N 0 N 0 N 0 M Ln LD h r-i N ri .-I ri O O N O rl O LO rl ri rl ri O O r-i O LO O ri N N N N M M N LOS ANGELES CA BENSENVILLE IL WISCONSIN ST TRANSPRTN REVENUE ALTOONA PA AREA SCH DIST FEDERAL HOME LOAN BANK FEDERAL HOME LOAN BANK FEDERAL HOME LOAN BANK VIRGINIA ST RESOURCES AUTH INF FEDERAL HOME LOAN BANK OREGON EDU DISTS FULL FAITH & WILLIAMSTON MI CMNTY SCHS SCH FEDERAL HOME LOAN BANK NORTHSIDE TX INDEP SCH DIST FEDERAL HOME LOAN BANK TEXAS STA & M UNIV REVENUES SAN DIEGOCNTYCA REGLTRANSPR SAN DIEGO CNTY CA REGL TRANSPR FEDERAL HOME LOAN BANK FEDERAL HOME LOAN BANK CINNAMINSON TWP Ni LOS ANGELES CA CMNTY CLG DIST MAGNOLIA TX INDEP SCH DIST CALIFORNIA ST DEPT OF WTR RESO MASSACHUSETTS ST SCH BLDG AUTH OAK CREEK WI DOWNERS GROVE IL BIRMINGHAM AL WTRWKS BRD WTR R BAY AREA CA TOLL AUTH TOLL BRI FEDERAL HOME LOAN BANK DOWNTOWN SAVANNAH GA AUTH CALIFORNIA ST DEPT OF WTR RESO m To R R R R R R R CO d Q d !l T T T d T A a �, a T a fl_ !1 T T d d 0- Q Q Q it a Q e e c c v v v e v e c v e w c c N N e C e C m C C e e 162 544351PT0 190 082419F56 136 977123X94 178 021807M65 106 3130ANM64 3130ANFGO 3130ANAZ3 V a O1 V' 116 92818N5U8 3130AN7C8 156 68587FAY0 970294DD3 3130AM U F7 66702RZE5 3130ALU85 LO O CO rl ri 149 88213ARR8 797400MR6 O O1 147 797400MT2 3130ALAA2 3130AKY26 00 h N r 172513CN1 h l0 54438CYK2 ro Lfl 559686 W U 0 O CO 13067W RC8 01 576000ZG1 139 671137C62 180 2607415L8 091096NE3 co 191 072024W57 3130AERV4 10 a a e 'e M IJJ cr N r 10 L0 N 13067WPG1 © 2024 Wells Fargo Bank, N.A. All rights reserved. Confidential. Page 82 of 120 Portfolio Analysis 00 O O B d M 00 0 0 ri 0 Q W O r-1 O O Q + + + Q d Q Q Q Q Q Q l0 d' V r-I r--I r-I r--I r-I N «N 7 'A- . 0 r-I 0 0( r-I 00 W 0 ,1 0 0 O O O O O O O O O O O O O' L(1' Ci O' Q N LCI N t0 N N N r-I • 00 0 (0 NNNN M O r-I r1 -i w N rn m O r-I 0 0 N trr 00 w h N 00 M N N N d' NEW YORK CITY NY TRANSITIONAL a 159 64971WN89 FEDERAL HOME LOAN BANK FEDERAL HOME LOAN BANK FEDERAL HOME LOAN BANK >. T >. V U W N m m Q Q Q 3130A3GE8 3130A2UW4 313373B68 N O 0] N ri 03 FDIC -Insured brokered CDs are not included in the Credit Rating Monit © 2024 Wells Fargo Bank, N.A. All rights reserved. Confidential. Page 83 of 120 Portfolio Analysis 0 0 rJ 0 0 0 0 0 0 0 rj O O O O o 0 0 O 0 i o o O f i 0 0 r j 0 0 o cj o 0 O N ?� m 00. t V V N 0 0 0 0 0 0 O O O O O 0 O O j V jV 0 0 Y? 0 0 0�� 0 00000 0 0 0 0 0 m 1 Positions by Sector N V V t0 f 0? 0? 0? L0 0 0 N V V .+ V N m m O 0 00 t0 n N V 0. N O 0 0 0 0 0 0 0 0 o0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 N 0 0 N N N N N N N m 0 m ri 0 1 0 0 N N N n n n h m m h d d d .+ N N N N N N N CO N 01 n N n h'.: n M M V 0 N 0 0 0 00 O 0 r 0 0 01 01 iV";, ri 0 N V 6 6 in:0- nn, .o m M v m m o M .-, m ry m o o v O O o m T v o N m m v o w N o m m � c}, v ry 0 0 .. n o v v m M N N N N N N 0 0 N N 0 0 0 0 0 0 0 0 m N n 0 n l0 n N 0 h V M V V O n N 0 l0 n l0 0 O N 01 O O O O N N N N N N N N N N N N N N N N N N N N V V V V N V V N V V V C C C C C M V V V V l0 N V V N V V V .,. N N N N N N N N N N N n 01 CM M 01 O N 0 o 0 0" m o o 0 o nn,1 0 C N O Co)N O 0 O 0 0 0 O n 01 0 N C N 01 0 6 6 ri N n C C 0 6 0 N O N V o 0 N O V 0 N M N W V O l0 V N N h N N O O N N O M N O O M O N M N M O O O O O O M ti O V ti V N ti ti V C M C M C t0 C V V V 6 N V N V V V V N rnn 0m M m M 0 m a mrn vn 0 N o o a NO o N O 0-O0 m o 0 m T mO T Om m a rm rn rnM N m N NOo mN No, oh '0 o ., rn o, o m io O all .l O g N M o 0 0 0 0 0 o ^ o o N ,n m go o o 0 io o a� o 0 o m o m o o � o� o� o� rn� o 0 0� o� � o w w o .+ � o 0 0 0� io O o O O m 0 0 O O 0 0 0 l0 0 0 0 0 (V h 0 0 0� o 0 o a°i, � m m � o � 0 0 0 0 o CT"' o 0 0 0 0 o 0 0 0 0 o ro �0 �o 0 0 'CO o 01 m o 0 o rn M v w N o m ry o 0 0� v o o �o o m m o N _ o 0 0 o o M ,� M w h o ,� '4 o 0 0, o, m om o 0 0 0 0 o o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 d d ,� . o 0 0 v m o o m m o� o o m m o m N� o N o N o 0 o N N N N o o N N 0 0 N�� 0 0 0 0 O O O O O O O O O p p p O 0 0 0 0 0 0 0 0 0 0 0 p O O p O p O 0 0p 0 0 0 0 0 0 0p 0 0 0 0 0 0 0 0 O o O o o p O o O p p p O o 0 o O p o 0 0 0 0 o p O o p O p O o p o 0 0 0 0 o p o 0 0 o O p o 0 O O O O O 0 0 0 0 0 0 0 0 0 0 0 0 O O O 0 0 0 0 0 0 0 0 O O O O O O O O O O O 0 0 0 O O O O O O O O O p N O' p p O' p p p 0 0 N 0 0 0 0 O O O' O O' p O O p O p O O p 0 0 O' O O' O' O O' vi O O p 0 0 0 O 0: O p O p O p p p 0 0 0 0 0 0 0 0 0 N O p O O p O p O O p O n 0 0 0 N O M O O O O O N m .� i N .� N .� .� .� vt W W �O N m � n t0 lD � V N t0 t0 �O � vl t0 vl i0 vt ti t0 �0 t0 N E N E v E m m E E E m E E `w E w E E `w m E v v E m `m = = = m E `w - w E - - - - E > > E E E m m' m m' m m' m' m m m m' m m a m m' m m a m m' m m' m' m' m m a m m a a m m a m 0 0 a a N \ N N N N N n , 0 0 0 m m ry m m m 0 0 .� o 0 0 0 a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a" a" 0 a a a" a a. a a a a a a a a a a a a a a a a a. a" a a a a a a a a a a a a a a a a m m � 0 rn O O O O O O 0 o N 0 0 v .a .. N o 0 0 0 0 0 m o 0o o \ 0\ M 0 c2, 0\\\ O W 0 0,1 m N M m h N rn m O V N m N m ^ m i0 0 0 V 2 N r O N 2 2 M r W N M N N M ti N u01 2,2O 1'V O 0V 2 ONi N W 9 2 O, O r 2 ti 0 l0 h 2 N N W h O N Lc,N N 0 0 0 0 M O N M N M O O 0 0 O O 0 ri O V ri N 0 M I0 l0 0 t0 0 M 0 0 0uiV V V V V V .. hl;' 0 M M N N 0 0 M M M M n e o N ao 0 o 0 e a 0 0 e e o e 0 e a 0 e N e 0 30 e e 0 0 0 0 N M N N N �1 e e e e e e [0 O M O O o o o O N o o N N N tD c0 N O n t0 O N O 6 o O C 6 d 6 6 O l0 6 N O 6 O O O O O ti i-i O ti N O ti ti ti 0 0 0 0 0 0 0 0 0 0 0 0 ti 0 0 ti O ti 0 0 ti 0 0 0 0 0 0 N 0 0 0 0 0 .i C) 0 0 0 0 0 0 0 0 0 0 0 0 FEDERAL FARM CREDIT BANK Y Y Z Y Z a a 0 a m m mzzz m H a a 0 a 0 0 0 . o V V • K 0 0 _ _ S jai. ' LL O 0 0 0° 0 zz FEDERAL HOME LOAN BANK Y z Y Y Y Y Y a m a a a a m H m m ma ry m a D a a a a a 0 1 3 0 0 0 0 0 � V 0 W M 0 0 a 0 0 0 0 o z z w w w w z 00 o z w00QLoa00000 FEDERAL HOME LOAN BANK Y Y Z Y Z m a m � m � 0 0 0 0 V V O 0 a o a 0 10 0 000TTT Y Y m m Z Z O 0 O • 0 S S a 0 00 FEDERAL HOME LOAN BANK O Y m m 0 • 0 1,1 O 0 O 0 O S 0 a m m 00 FEDERAL HOME LOAN BANK z Y Y Z Y F ma m m a F ° ° a O 0 0 0 0 V V < 0 0 K 0 LL O O O LL x x x � m 0a a �• 00a 0a a 0 FEDERAL HOME LOAN BANK O • W 2 w W Y 0 N N W N X 7 a z t0 m l� t�0 > X N Q S ro m K Y pY ry W K > a' M 0 K 0 o X V O m N o o 0 0 x d Y 0 O' X z w z w a 3 N w x w w< o x L.,2 a x o w 0 a N a 0 0 a a m a 0 0 0 0 0 a a a 01 a a a 0 a a N a a a a = a m a a N a a N a m M o O M o M M N o 0 o M M o 0 0 0 0 o O o 0 o D o In In m m o 0 0 0 0 0 0 01/ 00 00 In o Nv Nv NI In In NI NI M M M M M M M M M M M M w M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M X X a In In In ZZZ >¢ m 3¢ m m n m M m M o .I ry m V N N n m N m m n m v m To v w o 0 0 ."+ �°-+' ry m r`n ov �o m m m m o 0 o m. n .N+ rrl m rn oc0i o 0 00 ti N V V V V V N �M(1 N N �O tp ea n N N N O O .i .i .i .i .i .i N N N Q",: W ti ti N N © 2024 Wells Fargo Bank, N.A. All rights reserved. Confidential. Page 84 of 120 Portfolio Analysis 0 0 ei= 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ti Positions by Sector 0 0 0 D o m N O iY:° n o N N N M M 04 0 0 0 Ni M 0 V t0 2 m O O 61 61 V N N 2 m O M N i-I i-1 i-i 0 0 a M O'. �n N O O O� m W t��55`` m m m m m w w w w w a O 0 M M 0 0 0 �n m m 0 m O m m m o o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 .1 .1 , -1 -1 .1 .+ .+ .+ N N N N M M V V V ul u1 t0 N �D ID n n n w dl dl O N O O O O .i O O O O O O O O O O O O O O O O 0 0 0 0 0 0 0 0 .i .i .i .i .i .i ti M 0 0 in n m 10 .. M M o m M m m ui v ry .. .. N o m ry v M N m m m 2 N ry M �o v m ui w 'n 10 10 0 0 t0 0 0 V N V 0 N C t60 N l0 6 N 6 N t0 O 01 10 01 '0 '0 ✓ V 11"' C ut ut Lc; l0 ul ul �n l0 ul ul ul ul ul ul ul ul ut 1() ul ul ul 6 6 ul ul ul N � M M 6 6 M M N N N ut tD ut vl ut ut V V V ✓ V m m o m i m M O� � 0 0 QI O N N �� � O O O y� q„ W O O O O m 0 0 0 0 0 M i4- o .m O O V �0 ,Zr"' 1 0 O O O V m o 0 0 0 0 10 n t0 0 N M M vY O -1 O M O N O N n vOi O N N N N N 10 O O (0 l0 10 0 M 01 .i m .i .i 0l C V 0 b N V C O ul O 6 O vl ut In ut vt ut vvt O O l0 O m 0 0 INn O ti VO 0C 0 r O O O 2 6O O g n n O n vvvC C 4 C 4 0 v6 O in O V N t0 O n O m `° 00 0 666m 000000" m m m o O o, o o, m o 0 0 o O o 0 0 w o of of m m TT m m � o ti O W O W 0 0, o O o 0 0 0 0 0 0 0 0 0 2 o 2 o o O o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O O O O O O O O O O O O O O m 0 0 0 0 0 0 0 0 0 0 0 01 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NNNNNNNNNNNNN 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 < M N N M N N 0 N N N< r-1 M M 0 N N 0 N M M N 0 N O N M O N 0 0 M N N N N N O V 0 N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N O O 0 0\\ O O O 19 10 O 0 O O O h 0 0 0 0 V 0 0 W 0 0 0 0 0 o a o 0 0 0 O 0 l 0 N 0 0 0 0 0 0� 00 0 0 0 1 0 0 0 0 N N 0 0 0 0 O O 1\n N 1 0 t\0 N 0 00 0 l0 O O O O i N 0 N 0 0 N N O O O O O OOO O O O O 8 O O O O 0 0 01 O n OriM M P e e v e 00 a 10 e O 0 0 0 0 0 0 0 0 CCCGCCCGCC C n l0 O N -1 O O O O O N N N N N N N N N N N N N N N N N 0 0 0 0 MV NV NV MV 0 0 Ill 'al 111 'al ti m m m m m m m m m m m m m m m m m m m' m m m m m' m' a m m m m m • m m m m m m m a m m m m m m O 0 0 0 O 0n 0 0 1 O 10 O m r0 O O O 0 O m 0 0 O O 0 0 0 0 0 0 0 10 O O M 0 0 NV 0 O 0 0 0 N N N N C M In 0 O O 6 O 10 n N O 0 n n n 0 t0 6 0 O 6 N O u1 ill ill ut ut � ut C V V � � O �fl O vl vl u) Ilt ul Ilt ut ut M itl Ifl .i Ifl itl O O vt vt vt [I C C C C O itl O O itl O V o eye e e o e e e e e a a e e a a a gggggggggPRPRPRPRPRPRgg. N N N N N N N N 00 4Y 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 © 2024 Wells Fargo Bank, N.A. All rights reserved. Confidential. Page 85 of 120 m If 0 0 0 0 b,: O O O 0 0 0 O O O O a a a a a a .i a s 0 N a N N 0 b; 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ti m m o 0 0 0 ry N r .+ ry ry ry ry ry ry ry N N m m m m rri m m m rn rn 00 v[0 ro 01 l 0 0 0 0 K(:00 m o .+ ry 00 n o0 m o ry m N o .+ m 0 0 m co m o0 O N ',I", m m N O M r 0 of r c0 c0 V m m 8 m m0 61 O N O1 m N o] 0 0 0 0 r O t0 O 0 4 0 10 uml ✓ V l0 ut V V V V V V V ul ul u1 C C C C V V V V ul V V V V V V rvi m0 0 o v o .+ 0 o o m m O O 70 O N 0 0 0 �n 0 .. 0 0 O O m m m io m m l0 l0 m N ro m �o v o r� n Lc; i-i O O O V V m M C C C C C V C V .i vl V V V V Ltl V V ▪ -1 O m O O O 2 m m m m a m mm m a m m m m m m 2.0 O O O O O O m N� O O m m o .+ m w CO m 0 .+ m m m m m o •.+ .+ (V hi hi hi hi hi rri m m M V V V N O 9 2 O W 2 O N 8 O a 0 8 r 0 8 8 V W W n m m o0i o o m tNn m h m m o ry m o0i my on] 6 6 6 6 f!!: N N ri O fV O .i .i V r+l O .i C C .i .i V .i .i .i V 1.6 V V 0 0 0 8. E. 0 0 0 0 0 0 0 8 8 0 0 0 0 0 0 8 0 0 0 0 8 0 0 0 0 0 8 0 0 0 0 +�t o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4ti;, o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 .- o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0, o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 00 0 0 0 0 0 0 00 00 0 0 0 00 00 00 0 0 00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 w O 0 V W of V 0 0 0 V 0 0 mV V �V NV � V V V V V V V V �V V mV mV mV V mV V mV �V V V V V V V V N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N v v v v v v v v v v v v v v v v v v v m m m m m m m m m m m Q N' m m m m m m m 2 m Q N' N' N' N' N' N' N' m' m�n o O o 8 8n m o 0 o u} ul o 0 0 0 0 0 0 0 .n o rn o m o m co m io m N io co N ro .� n v o n N v v ri d d O v v Sri v v m m rri a a a a a a a a .+ ui v v v v vi 80 m m m m 0 0 V V O W 10 m m m m m 0 0 V 8 O o m o0, m m m N '4 '0'0 N 0 o v m w 0 o N n m w m 0 M N rn ry of W W m m m m m m m m m m m m m m m m m m m m m m m m m m m m vi ui vi vi Q a a a a 0 a a 0 a a a 0 a Q Q O a 0 a 0 a 0 a 0 a 0 a a a a a a 0 0 0 a 0 0 a 0 0 0 0 0 0 a a 0 a a 0 a a N N t0 0 N 0 0 0 0 O O O O O O O O 0 0 0 0 0 O O O O O h 0 0 V 0 0 0 \V 1* 0 0 0 0 0 0 0 0 0 mm v 2 o 0 o cn o m .+ m O o o .. N m n o O r` 4 m .+ ui N �o fV O �-i (V fV C I(I • N N N 0 N N e v e ry N N 0 0 0 n N N N e e �° 0 ��":� N � o e 4 m a e 4 m 0 4 0 4 01 0 0 4 0° N 0 a 0 NNNN N N N N N N - «t O 0 Ift N N t0 r` O I� C M C O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 W' m 0 01 0] W% 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Positions by Sector © 2024 Wells Fargo Bank, N.A. All rights reserved. Confidential. Page 86 of 120 Portfolio Analysis o 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Positions by Sector M V u1 rv^'0 71 0 0 0 OJ tO t0 r N n O N o] ✓ V V V V V V V V V V V V 8 m m m °r' L(n) A m m m 1) C C V C N V vl V V V V V fV 0Y O M O M 1 0) r 0 t 1) 0 M m T C O m O 0 00 g m W W g 2 2 W W D) 001 O N � W O -I N 2 6Ni ti �'! . e W o 0 o m m ro W a p}' m et ro m m m m ro co w 04 C Ff+`- ut C ul ul ul ul ul ul V V V V V V V C C C C C V V�=' 0 o v m v o .. io m y ui M m ry N m 6 6 �o o N v v .. ro m n N 0 0 0 0 ri fV r-i O O V r-i V r-i of o o a m r�i .�i a rrvi � o a N M m a m Tm m m M M M M m O1 m m O m O O O Ol Ot g M m O col oo N oo O O to- ry n O of tor too .4, m m m 0 m m m m W m m 2 gi;; 61 NO 00 Qi � Oi Oi Oi of 0 Qi N W 6i V W 6i 6i rn rn rn rn rn rn rn m m m m m w m m N N M m M M N N M N N o m 0 o O O M N M N 0 T M V M v N N ti N N ti N N N N N N N N N r\\ N 0\\ 0 0 i0 0\ O N ro 0 W O 0 O O M N 0 N O O O O O O N N O h0i O 0� 00 00 o)\ 00 O 0 N l\(1 0\\ 0 i l0 O N M N N 0 0 1 N l0 N 0 0 i-1 i-1 i-1 -I O O .'1 .'1 i-1 O O O O O O O ti ti 0 0 ti O ti ti O ti ti O ti ti .i .i O .i O O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o o 0 0 0 0 0 0 0 0 0 0 OO O O 0i d d O M U1 O lfY O l0 M M 0 0 0 M N 0 W l0 V 00 ¢ m O E m m ¢ m m c - E - m Q m O O O M O O ti Q Q Q Q Q Q¢¢ w et 0, N N o 0 0 0 O O O O O ti 0 0 0 ti O M 0 W 0\ t0 0\ 0\\ 00 O\'0 O O O O O O 0 ti 0 0 0 0 O r 0 O O ul N O V N O O O N 0 0 0 N O lV �fl fV N N NLO N O N V O 0 0 0 0 0 0 0 0 0 0 0 S ¢ H O Z : N Q yy M Q d 0? 1 ii d m 'v r Mti O N O V N 0] N O l9 N r l0 ul V O Ot C N ut ti r O ti O N ul N N C l0 l0 M N l0 ul O o] r tp C l0 .y O N ul l0 O O �r C l0 M O l0 N O l0 l0 r r r r r OJ � N 91 Qi 0 0 0 0 0 0 n 0 0 0 00 0 N O 0 0 0 V m m m m m m o m m m m m m m m m m m m m m a a M � V a a a a a a a a a a Q" Q" a a a a a4 oM N N N N ry N 0 0 0 N O O \ \ \ c0 \ O \ \ \ O \ O 6i O N 0 (00 W O O \ \ \ \ 0 \ \ 0 0 0 00 O \ \ \ \ 0 \ O O O 0 '+ 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NNyy OJ O O O O 0--- I� O r N N N O OO rO r 0 0 N r O O N O 0 0 ti ti N ti 0 0 V O N1 N 0 N O N t0 t0 l0 O 00 t0 V t0 Q1 m m m m m m m m m m m m m m m m m m m m m m z z z z z z z z z z z z z z z z z z z z z z }} r}} r r r r r r r r r r}}} r r r} Ul U1 M M VI VI VI VI vl ✓1 ✓1 ✓1 ✓1 VI V1 U1 w w w w w w w w w w w w w w Q w w w w w w w H H H H o' o' o' H o: o: o: o: H C CC H H H H H H H H H H H H H H H H H H H H H H > > > > > > > > > > > > > > > > > > > > > > I �o v i°� mnMI nd H m i d�� d NiMnM u O rU m u}}m u u m u u u u m m u C N N N N N N N N N lD OJ 0 N N N 0] 0] W 0 c0 .y N N N N N N N N N N N Lfl r � M c0 t0 l0 ti 0 0 N C C C t0 © 2024 Wells Fargo Bank, N.A. All rights reserved. Confidential. Page 87 of 120 Portfolio Analysis ti 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o O o 0 0 0 0 0 0 0 o ci O O o 0 0 0 0 0 0 0 0 0 0 0 0 O 0 0 0 o iU 0 ri o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ci 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 T 0 4. 0 0 N N N N N N M M M M V V V V V V 1I 66 0 l0 h h h h W W W W W m W W m 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O 0 0 0 O 0 0 0 O O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0-- 1� Positions by Maturity O O o 0 0 0 r1 ti N N N N N N M M M M V V V V V vt U1 N v) N W N N 0 l9 h h h h h h W W W W W m m m m m m m m 0 0 0 0 0 W N m m1 1m0 N V V V N0 V V WM W m O Mh m M W m N V N W O O W 0 M .+ N V ut vuvlW W 0 «o N v0 v<N lM6 W m W lW Vo n 0 n m o m n N6 M m W LM 6 6 m 6 m m N N 6 N m m 31 N 01 0 0 N Ln u5 6 to V V W m 10 • 0 0 0 0 0 O O M N O O o 0 0 0 0 o O o cr. o M b 0 O O O O O m ri ri ri ri ri m m m m Imo V m O O 0 h 6.66 m o m m o V o m 10 o 1 ur W M m h W 0 V l0 M �'1 M V V N V O UI N 0 O n0 o m com m m ri p mm m m W w h o b 6 W O b m m m m ri 10N M O .M1 MW N N o m N, .W, Co' O Mo W O 0 O N V vt O N 6 In M .+ ui vi 6nl vi O O M In 6 O M 6 (V O M 1� .+ M M m m Nv rn m m mm M o 0 1O Ia n11 m N m ., � � NV � O O N h W m N m 0 0 0 W O m m m 0 0 m� N� m� r1 ri m m m m m m O 0 O O O N 0 h 0 0 W 0 W 0 0 0 10 0 0 0 0 m 0 V. 0 0 0 0 0 M 0 m O m 0 0 0 O 0 0 0 0 0 o m o 0 m o 0. 0 0. 0 0 o m 0 m 0 h o o m o 0 0 m 0 o m O W 000000 0000go o 000000oQ'OQ'O' o0000 o'00a' 0a; 0 0 o O o 0 0 0 0 0 o m o m m o 0 0 0 0 0 o m m o m o o m o 0 o m o o m O m nN M C1 of N m m m N O 6 0i m h b 0 � p N m m QS', m m m m O O o 0 W 0 0 0 ,, m O o 0 0 0 o O M O W Cr 0 o T. O O O O O W h 0 0 0 N O 0 0 h O O 0 O O 0 0 N V O O 10 O h O o 0 O m O 0 0 o W O O o 0 0 0 V h 0 0 0 0 (0 o 0 o o h 0(0 31 0 0 0 0 0 o a 0 m 0 ,`i o o(3 o o W O m 0 m 0 0 0 0 (0 0 N 0 0 m h 0 0 0 O 0 0 m N 0 0 0 0 0 h 0 0 0 N 0' 0 0 0 0 0 0 0 6' O N O N 0 0 N 0 0 Q' 0 0 ' 0 6; 0 0 0 o O m o o m o 0 0 0 0 0 o m O o 0 0 0 0 0 0 0 0 m O m m o 0 0 0 0 o m o m o m o o m 0 0 m 0 m O m V V V V m .� O ti M V V m V O N �-1 V O N N M V V V V N O N m M 0 V N O N O V N N N N �-i N N N N N N N N N N N N N �-i N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N W W W W 0 W �0 W h m W N 0 N 1 0 0 0 0 N v0i W h m W O u0i 00 0( 00 , 0 O M m \V r O O \\\\\\ t0 O\ 0(3 0 h 0 01 h 0 N N ., ., O N i-1 �-i N �-1 i-1 N N N N N O N O N -i N �-i 0 0 0 0 0, 1 ,-i O N i-i N N O N N N N M M O �'1 0 O N ,-i N N l0 W t0 W h r W W W 10 l0 m m m 0Y W l0 N i\-i l0 i0 N ti N N h N V W N W ti i0 100 W V 01 V r 10 0 0 0 0 N 0 l0 0 W N i0 0 0 0 o O o 0 0 0 0 0 0 0 0 0 0 0 �-1 r1 O O O 0 0 0 o 0 0 0 0 o1 O o 0 0 0 o 0 0 ,[3 3 0 0 0 0 0 0 ., o o of 0 :11 V N O O O O O O O O O O O O p O p 0 0 0 0 O 0 0 0 0 0 0 p O p O 0 0 p O 0 0 0 0 0 0 p O 0 0 0 O 0 0 p O 0 0 p O O p O O p p 0 0 0 0 0 0 v h p o o 0 0 0 0 0 0 0 0 0 o p a p o 0 o p o 0 0 0 0 0 o p o 0 0 0 0 0 o p o p o p o o p o o p p o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o 0 0 0 0 0 0 I� CO N N O O ill O O O ' O O 1I1 t0 h N m UI � O h O O n h r lD 10 lD O p b1 p N O V N O' O M N dJ N p O W 0 ift lD O O p th p O p M W p ui W p O CO N n O m �0 m N N V O M O 1I1 M M M MN V V O m V p V� V r V� O V Lfl V V p M N O N M V V a V O p V V a V V a ry O N V M O N E N N E N W E N N E N 0 o m m 0 m v w v w v m w v v v m m m v m v v m v v v v w v v v v m v m m v E m m m v w - E= E m m m m' m m a m m m m m m m m m m m m m m m m' m m m m m m' m m' m m' m' m m m m m a m m m m m m m m m m¢ m m .44.44 a a s a a a a a a ¢4 V V V V V V V V V V V V V V V V V V V V V V 0 0 0 0 0 LO O LO O N O N O N 0 N 0 N 0 0 0 N N 0 0 0 N N N NV N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N O W 0 01 0 (0 M W O1 0 h 0 0 ti W 0 0 ti 0 (0 0 ti ti r (1 1 r r 1 W .1 W W u1 h \ N N N M M M O N N O O o1 M M O O N N M N N N N N N O N N N N 0 0 N N\ O N 10 n W W W 0 01 O N 01 6Y 01 5 O O N N N N N \ 5-, N N N N M M M 5 V 5 V V 0 U1 l0 5 0 U1 m l0 l0 l0 l0 l0 0 0 0 0 0 0 0 0 0 0 0 0 0 10 10 N 0 10 �-1 ., o1 �-i 10 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 M V M N 03 V 10 V 0 V V m 0 r 0 W 0 m 0 0 0 M N N 'Ni N 0 ON N O 0 V M M v1 ` m l00 W0 0 V 0 0 0 W N N 0 O M M . O O O Lfl Lf1 N 6 Lai1f1 N LaiN O �-i V Ll) V N� N Ifl ri N Lei 0.L(1 O N 1(1 � V .� lt> Lai Lai N Lai O O M Lai Lai O M Lfl N O M 1l1 ri to N M N O N N N N W W V IV 0 0 10 0> 0 0 0> 0 0' 0 0 0 0 0 0 0 4 0 0 0 0 0 0 0 0 0 a 0 ti 0 0 o f o 0 0 0 4 0 0 ti> 0 0> 0 30 10 >° 0 0 0 0 10 e s" o> 0 0 3V O m N O 0 0 O O O O O O O O N O O O O N O 0 0 0 0 0 0 0 0 O O O O O N 0 0 O O 0 0 0 0 .,'. 6 O O O w Y MO Z ¢ Q ~ V Z z z ~ O F z � zo V rnmm?Naa z�O m Z Z Y cG m S Y m O Y V¢ Z m LL Y a S m m z v m 0 N w¢ O¢ N m0 LLL O O 4. LL z m z 01 V LL LL 03 V Q 33 m m>> 1 LL 3 V 10 LL m 10 M V V V V w 10 m N V 0 0 0 N W O N W h a Q h V m l0 O W N N N W l0 h u( Q V V W W W W O O O N V m m W W V h 10 h 0 -0 '0 W W N LO N M m f0 M V N L0 M W h N N O m m O V m flDhi!IH!DH >> QWV YLL l7InM _YW¢ XW C[¢ mON hl4N hN hW«t WVW tpN hNN mmN iov mNWmN M m O N M m N N l0 Z Y Q z m LL 1- 0 O Y W m ✓ Z Y Y a a MOD ZZ a a 00 C00 W O L S S • 0 K Z S m 0 LLL0 10 L� LL LL Z O Z a> a m w ' Q O w H V 33 a= 3V ., Y a Q Z S 10 m O V W N l0 o1 N V 0 i0 M M 0 M O N O O N W N V M M W O W V ', N V ., N t0 N 0 (0 N M N O m O h N N N N W N M V N o N o OJ W 10 t0 W l0 h W h W O M V M M M O �-1 W O m M m M l0 W O( M M 01 O N .M-1 31 N 10 0--1 W 03 pN ,-1 N N V (0 10 h al m OM ~ M M M M M M M M O N M V ll1 10 h W m 0 N M V N W h l0 h al m rl N N N N N N N m V V V V V V V V V V N (0 03 N 03 N 03 N © 2024 Wells Fargo Bank, N.A. All rights reserved. Confidential. Page 88 of 120 Portfolio Analysis NII O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o O o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o O' o ":. 0 0 0 0 0 0 0 o ti-I Co ., 0. o O 000000000000000000000000000000000000 9, 0000000000200000000000000 m w 1) 0 ed N N N (V N N (3 N (3 O (3 N N (V O O N N N N N N (3 N ▪ i-i N Cr! N M CO co M V V V V V V (0 0 0 0 0 l0 h h h 03 CO 0 CO 0 N 0 0 0 0 0 (•y 0 0 0 r, 10 0 N N N N N M M M M M M M V V '0F V l0 l0 l0 • 0 0 r-i i-1 i-1 r-i i-1 i-1 r-i i-i i-1 i-i i-1 i-i i-i i-i i-i r-i i-i r-i i-i r-i i-i r-i i-i i-1 i-i N N N N N �.: f,: N N N N N N N N N N N Cr N N N N N N N N N N N N N h+ N M M 0 0 N(O O O O 2 OMl N 2 8 V N V N 01 O ul N1 .0 m a 0 0 ., M N N h M 2 O .W, O (0N ., lNO O «N NO M M m M N (h 2 001 u 0 u6 3uvvuvuN 0 u(p 6 uu((1 vvt V V • vV V 1V u N V V V V V V V V 0 O l0 ., V M ., 0 0 0 0 (n (n (O O O O O O (n V h ., V 0 8 O O O T O O W.. O O 0 '+ O N ., (O O O1 h O V O h 0 V h N (0 N O V (O N N V h h h 0 N 61 O U) 10 0 0 W 31 h ((1 N O O 31 0 0 OO 6 N Ol 4t Ol N O O M M 0O .1 O 0 31 0 ul O W 0 h 0 lD Ol m 31 h N h lO O vi O vi vi O O O N V V V V O O V O O (n O O O V r+ M M .+ ., V .+ (n O O V V V V Fi.. Ul .+ O M O '+ '+ O V O N .+ .+ .+ O N ri V V . vi 240 Positions by Maturity N lJ N MM 2 O 0 O h M h O V (O Ltt CT O O M oV N 4. M mh W go" p W h O V O O M O V a M a 1V11 (1 M m 0 N-i iM-1 W Lrn1rn0m m mmmrn mmmmammmmm mmrnmm o o g m rn m rn a, m m m b m m m m m rn m rn of m m m 0 0 0 o m ry Q, 0 Q, m o 0 0 0 ,n O o O O O O M O M 0 O 0 03 m 0 0 0 0 M 0 0 0 0 0 0 0j N 0 0' 0 0 0 0 O N O O O o O M O M O O M O O 0 0 0 0 o M 0 0 0 0 o a, h m m h 0 m M o 00808 O O O O O p N N M O 0 0 0 O 0 0 0 0 0 0 00 0 O O O O O 0 0 m O O 0 O 0 0 0 0 0 m 0 •, V O V O ', O (0 N N N r, 10 O o V 0 0 M r, 0 M r, <f N N N N N N N N N N N N 0 31 0 N N 0 N fl 0 10 N 0 0 0 0 0 N 0 0 N 0 0 1 J1 O1 ,h, 10 01 ro o 0 ti ro ro (n N 0 O .+ O O O .+ O N N N O M O O O N O O O O ti O N 0 0 0 0 M N 0 W l0 O N 31 0 ti 0 0 0 0 N N 10 03 N l0 N 0 I0 0 M M N V M N (0 i(1 00 \ N l0 i0 O O O O O 10 O 10 O 10 .+ 10 .1 O O ti O 10 0 0 0 0 '31 0 0 0 0 0 .+ O O O '31 ., .+ O O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O o O o O o 0 0 0 0 o O o O O O o O O O O O O O M o 0 0 0 0 0 0 0 o O o 0 0 0 a 0 0 0 0 31 r 31 01 0 0 (1) o (n 01 10 [0 0 0 0 0 0 0 0 0 m 0 0 0i 0 p (0 V O MV V O 0 0 3 V V V V O O N O V N V V 0 O 3 N h O �-( V O V V (0 c0 N 1fl N N �f1 h l0 N N N N N (D M N N N h t0 �Il h N lO (O h N W N N �-i ,, E m v E E v v E, E m v E mV, w Ettt m ro m m m m m m m m m m 02 2 m m Q m m m 0 m m m m m m m m m m m m Q N N 31 0 1 � N 00 0 c0 O O O v a v N N N O M h O W O O O a a a a a a a a a a a a a a a a a v1 13 13 (0 ((1 0 N ((1 0 «l 0 ul N l0 t0 l0 (0 l0 (0 l0 (0 l0 (0 l0 (0 l0 l0 0Nl 0 0 ti 0 0 0 00M000V0l010000 \D0ON(lll Nl0ON0 h O O O 0 oO .M+ 0 0 0 0 0 0 0 0 O O 30 0 (0 O O O 0 O V 0 8 O 0 O N O O 0 h N «l O N O V h h h 0 «1 0 h 0 V 0 O 0 O O O h N O O 01 V Ol O N O ul (0 O M O N� V V V O O� 0 0 ut O O O V O V V .+ i-i M i-i ul O O 0 0„ o Nm 0 P m 0 a01i R w v0 m °N1 0 0 0 ' o'.' oN 0 0 O O O 0 0 0 0 o o o 0 o ," 0 0 O 0 0 0 0 0 0 0 0 rn rn m m m Oh o 0 O O O 0 V r, M 01 MNM N �-i N N 0 0 0 U1 0 0 0 0 0 0 I0 0 0 N O O O O o Op 0 0 0 0 p 0 0 0 0 O O O O o 0 0 0 0 p O 0 0 0 N O o O o o O o 0 0 0 0 0 0 0 0 ti vi vi O vi p O N O O O O O ui N 10 V V .i V p 0 0 0 V p ul O h o0 tD v E m t v E v E w CO CO on m m ro m m m m m m m m v v v N N N 0 N N O O O E m m a m m m m m O l0 l0 l0 l0 l0 l0 l0 t0 l0 )0 O O (O O O O O l0 O l0 0 h h h N N N\ N\ N\ N N N N N\ N N N N N N N N 0 0 N r, r, O r, ti N M O r, r, M M M 0 0 0 0 •, M �-i ., o 0 0 0 0 0 0 0 0 0 0 oO h W \W W 0 W N N N N 01 0 0 0 •, 0 0 10 i 0 0 0 0 N O N O O N O M (0(O O O O N N NN M, N N l0 O N O .1 .+ O N O (ll .1 O .1 N M M V V .1 N o o o 31 31 o a a g a 1 31 1 o 0 0 3 3 o 31 o o o o 3 31 o a 31 e\° 1 o o f o 10 o e o 0 0 31 31 o 31 31 31 3° o 31 31 0 0 0 0 31 03 o f 31 e o O O O O O 0 0 0 0 0 0 O O O O O O O O O 0 0 0 O O O O O O O O O O O 0 0 0 0 O O O x 0 w 0 V M n_ Z L,0 03 a1 Z Y Y Y 03 Y Y Y N Y a V a Q ¢ a Z' a a a 0 y Z w 3 m w m m m m m m H m a y -1 Z Y Z Z= (0 Z Z Z CL Z z ¢ O a¢ O O w LE w z Y z 0 O O V m O, a m F- Z a m m m m V Z m 0 m a a ro y z Z o V m V m z > LL x w a z° g m N ,~,l m z w g> y 000.0 Z Y z o m Q Ox ¢ z m O O m¢ O Z O m j u O z f- W m Q F_ Y O Z O O F- w v1 V a Z Z Z Q a V z Q Q a M m K z V Q a a vDI- ¢¢ Q ¢ x 30 01 z 0 U1 O m 10 m a z 0 a 3¢ G O Z 0. CL F- m W m Y Z K V O a Z °~ u1 J Fy- - z K z z~~ v 8 z F- O a Z aLL W 0)-a m W 1 W V u-,=mU W>>(` W W(0�1D3<W 0Uu1 m V W m d N (2O 8 K> O O 8 0. 2 x 9 8G z u 8 m a a y Q l7 d m h O m z m J O o Q Q m N> V a d o N N Q h Q Y o a x m Q z u N O O V 7 Z 0 O Y w¢ l� h h 10 Q N M h W h Q Q OO h 0 (0 O Q N N N M Q O N 01 30 Q O O M • 0 to 03 vl (n o ro m 01 01 m o o to 0 10 (11 m o m ro O V CO N 0 0 0 (0 h m m h M M M N N N 0 M M M M W 0 0 l0 h M N N M M M h N 0 N M N M h M N ., h N ., O 01 M m V O M M m m O M Ol O M M M h N N O M (!1 N h M M N M V 0 (0 h 0 0 0 N M V (!1 (0 h W m m m m m m m m a1 m al m m m m m ar M> V N LL h OO at d h N W M m OO (Il N W V m NM Q N OO X d O N Q N N N W lO O O O O O W r, OO O O N m CO N N N M M N M N W M N In O M W N N M O N M OO M N M Ol 61 M M m N M N 61 M NM O O O N N N N N © 2024 Wells Fargo Bank, N.A. All rights reserved. Confidential. Page 89 of 120 Portfolio Analysis ' Positions by Maturity Odd "1T N N -! ti ti .� ti .� ti .� ti .� ti .� N Ff: N N N ti O N N N .� N N D N N N O) N N N N, I 0 ru o 0 0 0 o ty;� 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ¢'o O o 0 0 0 0 0 0 0 0 0 0 0 o c,, 0 0 0 0 gi;o 0 0 0 fV (V iY". lV fV M n m m m m N N N N N N N N M M rt„ M M M M M M M M M M M M M M M M M ti„ t-V V V V V V V V V V V V V V V M m m m ram+) rri ri x�' M m a m O • 0• 1 V V m 0 m 0 0 f(f' O ti N M M 10 10 10 n n n m m 0l m 01 m i[k� O O O O �-) ti N N OF V V 10 t0 0) V V V V <f M N M N V V V ti O O 1D 0 O M m M M M m M m v v v a v v v m N 0) 1 M m o n 0 m v n - N mO m m m O m tim m m ti V W(0 W ED (0(0 n n(0 l00 n n( 4 O l0 O l0 0 m m co N a00 co V (4 l0 O(4(4 M l(0 W (4 M EO 01 a a a v a v a v a v a v a v a v a v v v v M v v a 1n v v 1D v v v v v v v v •o o!o M M M V V v V Vv N 10 o m 0 10 N 'o3 a 01 a 01 x+4: d v v 10 v 1n v 1n "' 1n m m 0 Tf O ti 0 M a V M 0 N 0 "s.Y' O V V N (4 10 10 10 N 0) 10 10 N N (4 10 m N, N . n .; m O m C01', 10 m 10 0 m V O 0) m O 0) N O O O M m M M 0) l0 '4 10 m m v v v v v v v .J v v r O Wco00) 0 V 10 m W of mo m m cro NW OM M m O O N ° O O m m y ti O O ,n m o^ 0 0 o 0 0 0) 0 0 0 o (0, 2 0 0 0 3) 0 0 0 0 0 0 10 n 1D m N r l0 N V (0 *,0,<r 10 V O 0 0 0 •-1 N O V '0 t0 N t0 V m O O N N O V m V o) < O V O m O (0 10 (0 O n 1O m 31 m O 10 N N m m n n m 10 (4' u) n M M M m m l0 V v v v ui d v v a .+ v v; N v v v v v v v v e�' v N v Di v; a v v v v N n) CO ..1 1)) n m N ro 00 m P., r1 m • v M ni =r ry 1xi v M O rnM am 00 rD1 m r1 .'1 M-N 'cc M coO r, vrMO O 2mm • o, rOm o, O 3 3 m O N armon ~ ti ti 0 0 0 0 o m o rn • m m o nm 0 9C m N O N O O O O N O N O 0 0 0 0 0 m 0 O O �- O m m n 0 O O M O o O m 1;, 0 0 o m 0 m M• 0 0' 0 0 0) o O 0' o a' 0 0 0 Cb-- 0 0 d N O 0 0 0 0 0 Oy O O 0J O O m m O m 0 0 O O O m m m� 0 O V M V N V lV N M M V N N N N N N N N N N N N O N o3 N i31 i-1 M O N 0 N M V V 0) N 0 ti N 0 O o3 0 0 0 0 0 0 o3 4 O 0 0 M V V ti V V ti ti ti V M N N N N N N N N N N N N N N N N N m M� i 0) •-i W O 10 M\ O\ N\ N\ l0 n 0 N i-1 \ i-1 10 N N N 0 0 0 0 0 0 N O (0 o1 0 .No1 O O o) O o) O O O O O O O O O O O O O O O 0 0 0 0 0 0 0 0 O O O O O O O O m 0 0 0 0 0 M' W ✓ O O (0 0 O V V N 10 1O n V'0 N N O 0 0 O ti N ) 0 O N O � m O V' 0 O O N h O O 0 O m O m m m o 0 0 0 V M M N M V M V M M V V M V N N N N N N N N N N N N N N N N N N N 0\ O O M N N 10 \ N O o i O 00 \ 0 0 i0 O N N N N O O O O O O N N O N N N N N �-i N 0 0 0 i\-1 O N N N W N ti 0 N 0 ti N 10 N ti 0 O O O O O O O V O 0 0 0 0 0 0 0 0 0 0 0 0 0 m 0 0 0 0 0 0 0 O O O O O O O n 0 0 0 0 0 0 0 O (0 0 0) 10 O m m 0 0 0 0 V "0 31 o N N W tn0 100 ON N M N 10D 1100 OM 1N0 N N a O O m ti m W O m O ,y n N O1 V O n O 0 N N 0 O � m W m y v m M M M M N N N N N N N O 01 0 M 0 m N O 0 0 m 8 i0 0 ,-1 r;1 O W E E N v m m m m m a, 0 w 0 v 0 0 a, 0 0 0 0 0 0 0 v 0 v 0 a, v a, m m v v m 0 m m v w E v a, v a, m E m m m 0 m m Q m ro m m m m m m m m CD m 00 m ro ro ro m m 00 ro m W m m ro m¢ 0 Q ro ro m m W a W 0 m= W m¢ 0 [D m ro 0 Q ro m a � N n n n N N\ N N N N m u) 4 03 i0 lV O 0 N l0 10 0 0 0 O W 10 N O fl O O m 0 tD m M N N m �I) m �JlS 4 V V M V N1 M f+l 1f1 l+l V W. U N N N a Q Q¢ Q Q Q Q Q a n n n n m m m m m m m m m m m m N N N N N N N N N N N N N N N N N NO O O 00 01 0 0\ \ O O O N N \V )\I) 10 0 0 ti (0 O O M O 4;.` O O O O O m CO 0 0 N 1t1 0 N 0 CO1 0 10 r-0 v) ry O n m 0 0 N 0 u) (0 n N N N �Q Q-i Q Q Q Q Q a m N m m m m \m m m m m m m mN mw 'a; 010 olnolo;-1\rool\r1N00 omNf NmN N\ N M N O O O N O M O O\ O "0 M\ O\ 10 1D 10 10 N m ro 0m ro 0 ti iV N �-1 N 10 10 1n m m O O O O O O O O O O(0 ti �0 O O O O O O O m N � O ri Q a m m m m m m m 0 0 0 ry N 10 N 0 N\ M iD 0 00m 0 o1 N N ti ti 10 O O 0 01 .( 03 00 O O O N W O O O O M 01 m tf1 O O O O 0 O 0 01 0 OO O N V O N M m -O i-i i-i i-i N N V V M T V 1l1 V M lt> N 1l) ri V N n M 4& V 0 0 0 0 0 0 0 0 0 a A a 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 �o3 o 0, 0 0 0 0 °s� 0 0 0 0 o e o 0 0 th o 6 0 0 0 0 0 0 � 0 0 O O O O O O O O O O tq: 0 0 0 0 0 O O O O O O 0 0 0 0 = O O O O O O O O O AA=" O m N n m m O M M M M M M J O N m M z m 1NO m< V 0 N N 00 LL V S Q m 0 a U v) 0 m m d¢ a n d V X (Y U m O V¢ 0(1 10 N LA— N N m 10 N O N M O N 0) m M N m O m O m N M i-1 M t0 N M O V N 1O m V n .1 ti 0 0 rn m 01 m n 10 M 1D M m n 0 0 M n m CO 0 m 10 m m 0 V 10 10 n m M M V V V V V V V V V m O ti N O m n O m l7 O � Q 2 N m W n S m m m v M o 0 1n M V L0 10 Ln N- L() Lf) 1I1 N to W to m m l0 'y M V = N N 10 N �3aN,MlzmaOv v) m O m v) W n n N 0 M m M N N m M M 1n N n ti 0 0 o3 ti n n N n M M rn M o o v i� V N 10 n m m O ti N 10 10 10 10 10 10 10 n n n z 1- a MIZRAHI TEFAHOT BANK/LA M N y1 S m m L y >aNNo�a�n Y V N N M N O N V m w u) O O m �O m n 1n m r-1 n o M �-1 M o m m 1D LD 1D M O N l0 In N l0 �-i m O lD N M M l0 V 1l) 10 n 00 m 0 N n n n n n n CO 00 CO © 2024 Wells Fargo Bank, N.A. All rights reserved. Confidential. Page 90 of 120 Portfolio Analysis Positions by Maturity a O m N m ,.P m N o V V wl;: 0 7 0 003 000O' rv00000 ,0000 10Og000000q'o0¢Oood0 O rV vi V iti In o n 5M w m N 0 N 01 tl' 01 N 0 0 0 ni 1n i0 N W N N N V V V V (4 Oo 10 00 N Ma 10 00 W 00 W 10 +4 O N 01 W m m 31 N Ln m n 03 n 0 n f4 M M v ia io io tD N O O .1 .1 N n O O V N V m 8 n m m ; W n iti M m N. v1 4 m of 6 01 vl 4, O O O O 0 65 O O O t0 m 01 4 3 h'" `1 31 01 O M- 16�vvvu�vv�vvuivm�uti�N*#u,u,�vvv8'vvr,�;ur u,�;rrt' iD N V .+ V ui V N O V V n � O lfl O m m m O m` o m � M h O tiC N M ,-i ui N rvi V V4 n N n Cis 5(�`: tON of O �-I m ui V m 95' m m ui m m m m m m m ti O m m m of .3 cd of; m m m m m 00, O W N 0' O 1' � N O M O N O O O 3 M N N 0 t*I" 0 0 0 0„ 0 0 0 0 0 0 H 0 0 0 0 0- 0 0 0 0 0 0 0 GH} O m O 3 O 10 O ut 10 W N M O M. V O l0 n 0 0J O 0 3n 0? M O 4 10 10 0 0 O M O' O N O O O O p� O 0 0 0 0 �., O 01 0 0 0 0 0 d 01 d 0 W n N N N M O O O O O V V 10 V V l0 M 0 m N m 0J of c0 of m m,10 m 0 N N N N N N N N 10 N o m 10 m is 0 N o 0 N 0 m 0+ 0 i 10 n a 0 v v 00 m 01 N O M 00 N O �0 N N O M N ,0 N O N N M O O O N O N\ N 10 61 03 01 .1 l0 N V l0 l0 W O 0 i-1 ill r1 \ N m .� N m ,1 l0 01 01 m ,-i 0 0 0 0 0 0 0 0 0 0 0 O ti �-1 O O O 0 i �-1 O �-1 ti 0 0 O O 0 0 0 .1 0 0 l0 O .N1 0 0 0 0 10 0 0 r_ o o o O o 0 O O 11 10 0 011 ul O N O 10 W n m N M c0 N O t0 N m N tD 1(1 V N 31 00 10 Q Q m E 00 t0 n l0,0O M O ti mo o (0 O O o 01 ,1 D o m Qj 4 0 O N ,1 ,1 l00 ti 0 (3 41 l00 a s a a" O O O O O O i-1 01 N N N N N N M M M M M V I(1 N N M M M M M M M M M M M M M M M M M M M E 0 O -I O O -1 -1 N ti N i -1 lD -1 \ i M i -1 01 O \ \ \ \ \ 0 .1 ,-1 O N m 0 0 0 0 O r1 0 0 N 0 0 O O O N O O O .1 0 0 0 0 0 0 \0 01 0 N N 0 01 00 00 0 61 N N 0 00 03 0 ,1 ti N 01 M N M N 0 0 ,1 N O O O .1 0 0 0 0 0 0 0 0 0 O O O O O O �-1 O O .1 .1 .1 O O O O M m M 0 0 0 t0 N G1;, O 10 0 0 00 O O M.. 0 00T,00 O N O O m 10 O N n h (0 O 10 v1 0 O O O L0 N 01 r1 -1 N N N 4.! 1:: N V M M V M M 4' M M M 4 M 0 h 4, 0 0 0 0 00 4 ✓ V , H O •1 O .1 0 0 0 0 0 4 N'. O 00 0 00 4 O O k O O O 4 O O $, 4 4 W,- 0 0 0 0 0 14 FEDERAL FARM CREDIT BANK N 10 nm 0] m 0 .1 N V m m m m m m m m Y Y Y a 00 m 03 CO z z o 00 O 0 10 Lal 0 m O v x v v • In Io n co m o `, m m m m o o N 111111 M M M m M m O N O o YY ZZ m m ZZ O 00 O • 0 x x 10 O 0 v n 0 m O O M M m m m N. ot'oo t o0 N.1 N N N N N N N © 2024 Wells Fargo Bank, N.A. All rights reserved. Confidential. Page 91 of 120 Portfolio Analysis 7.B.1. Shakopee City Council July 16, 2024 FROM: Alexandria Anderson, Community Engagement Coordinator TO: Mayor and Council Members Subject: Accept $1500 donation given from Sue Westegaard for the Women's Water Safety Course Policy/Action Requested: Accept $1500 donation given from Sue Westegaard for the Women's Water Safety Course Recommendation: Accept $1500 donation given from Sue Westegaard Discussion: The City has received a monetary donation from Sue Westegaard in the amount of $1500.00. Ms. Westegaard continued support of our Women's Water Safety program is given in memory of Ms. Westegaard's mother, Helen Halvorson. Women's Water Safety is aimed to serve our female population who are not able to take lessons at the Community Center due cultural barriers. In this program we aim to teach water safety skills like floating, getting their faces wet, orienting themselves in the water and what to do if they find themselves in a water emergency. We also want to teach them how to be safe and keep others safe around water and to also have fun. Budget Impact: The donation will go towards the continuation of the program and covers expenses. ATTACHMENTS: o Resolution R2024-103 Page 92 of 120 RESOLUTION R2024-103 A RESOLUTION OF THE CITY OF SHAKOPEE, MINNESOTA ACCEPTING A MONETARY DONATION FROM SUE WESTEGAARD WHEREAS, on November 6, 2002, the City Council adopted Resolution No. 5794, which established procedure relating to the receipt of gifts and donations by the City; and WHEREAS, Resolution No. 5794 specifies that donations of real property shall be accepted by resolution of the City Council, and shall require a two-thirds majority of the Council for acceptance; and WHEREAS, The City has received a monetary donation from Sue Westegaard in the amount of $1500.00. Ms. Westegaard continued support of our Women's Water Safety program is given in memory of Ms. Westegaard's mother, Helen Halvorson. Women's Water Safety is aimed to serve our female population who are not able to take lessons at the Community Center due cultural barriers. In this program we aim to teach water safety skills like floating, getting their faces wet, orienting themselves in the water and what to do if they find themselves in a water emergency. We also want to teach them how to be safe and keep others safe around water and to also have fun. The City of Shakopee appreciates the on -going generosity from Sue Westegaard, an active member of the Shakopee Community Center and participant in aquatic programming. The City's donation policy requires a 2/3 vote to accept cash donations over $1,000.00 and donations of real property. WHEREAS, such donation will be used to offset program costs of our Women's Water Safety Program for 2024. NOW, THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF SHAKOPEE, MINNESOTA, that the donation is gratefully accepted; and FURTHER, the donation shall be used for Women's Water Safety Program, which is consistent with the wishes of the donor. FURTHER, the City staff is directed to send a letter to the donor, acknowledging receipt of the gift and expressing the appreciation of the City Council. Adopted in regular session of the City Council of the City of Shakopee, Minnesota held this 16th day July, 2024. Matt Lehman Mayor of the City of Shakopee ATTEST: City Clerk Page 93 of 120 8.A. Shakopee City Council July 16, 2024 FROM: Nate Reinhardt, Finance Director TO: Mayor and Council Members Subject: City Bill List Policy/Action Requested: None Recommendation: Informational Only Discussion: These reports reflect the expenditures as recorded for 2024 activity. The following transactions are notable for this reporting cycle: • Bituminous Roadways: Estimate Voucher #1, 2024 Full Depth Pavement Reconstruction & Bituminous Pavement Rehabilitation. $1,784,734.03 • Max Steininger: Estimate Voucher #1, CSAH 101 and Shenandoah Drive. $261,752.49 • Pember Companies: Voucher #1, Southbridge Lift Station. $139,944.50 • 2024 1st Half TIF/Tax Abatements: KEB America, Inc; $20,715.50 Oatey Company (Cherne Abatement): $21,687.50 Shakopee Crossings Limited Partnership: TIF #21 PAYG 2024 1ST Half Tax Settlement $18,864.03 Included in the check list are various refunds, returns, and pass through. Page 94 of 120 Budget Impact: Operating and capital expenditures within the 2024 budget. ATTACHIVIENTS: o Council Check Summary • Council Check Register • Bill Transfer List Page 95 of 120 7/11/2024 13:35:09 CITY OF SHAKOPEE Council Check Summary e actual amount due to data sequencing and/or data selection. Payment amount may not r C O E c 0 E U CO I- Cn C) O O o o_ o o co O O C) I- O r I� r- C) CO O Cn O O O O O O Cn Cn CO N CO 0 Cn CO 1-- CO I- CO C) O O O CO O O V CO f- O (O (O (O 6) (0 OD I- V M V co V C) O V V N CO 6) CO CO N V 0 CO I. V I. N 6) O I, CO C) CO 6) co I- oD Cn M - lO N O) O co- (` 7 l!) 6) CO I- V I- N N N C) Cn 0 I- W N V GENERAL FUND Z 0 w (0 H g 2 Z 0_co W 0 O u) 0 j 0 Q H W U 2 (n D Z 0 W O Q Z Z U_> CO LLI O U w Q Q < U CC w (=i) ,II -Lc) N- lCO CS) 0 * x Tt 01 0 CO CO CO CO CO CO CO Q 0 0 0 0 0 0 u_ LL LL LL LL LL LL H H H H H H H O O O 0 r O O N CO 7 CO CO O O O CO CO 0 O O 6) 0 N N I- (` OD W CO CO CO CO CO 0 0 0 0 0 r Cn O C) 0 0 0 0 0 0 0 0 0 0 0 r C) CO CO CO CO 0 0 N N 'I' 'I' V V ,I- ,I- V V V V V I� (` N- N- N- N- co 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ECONOMIC DEVELOPMENT AUTHORITY RIVER CITY CENTRE PARK DEVELOPMENT CAPITAL IMPROVEMENT FUND KEB ABATEMENT CHERNE ABATEMENT SEWER FUND SURFACE WATER FUND EQUIPMENT I.S. FUND PARK ASSET I.S. FUND INFO TECH I.S. FUND BUILDING I.S. FUND INVESTMENT TRUST FUND 3,327,308.45 Page 96 of 120 Council Check Register 0 D Total Amount PROFESSIONAL SERVICES PERSONNEL - PAYROLL PROFESSIONAL SERVICES PERSONNEL - PAYROLL N N N N M M O O 00 00 N N FSA FEES- 06/24 90.00 OABG HSA FEES- 06/24 600.00 OABG O O O O CREDIT CARD FEES INSPECTION O O 00 O TEST TRANSACTION FEES 10.03 OCHASE PAYMENTECH O CREDIT CARD FEES RECREATION GLOBAL PAYMENT FEES- 05/24 4,297.26 OGLOBAL PAYMENTS INTEGRATED CREDIT CARD FEES SANDVENTURE POOL GLOBAL PAYMENT FEES- 05/24 24.31 OGLOBAL PAYMENTS INTEGRATED CREDIT CARD FEES ICE ARENA GLOBAL PAYMENT FEES- 05/24 2,430.89 OGLOBAL PAYMENTS INTEGRATED ADMINISTRATIVE CHARGES INSPECTION BLDG PERMIT - SURCHARGE PLUMBING PERMIT -SURCHARGE ELECTRIC PERMIT -SURCHARGE HEATING PERMIT -SURCHARGE W & 5 PERMIT -SURCHARGE FIRE PERMIT- SURCHARGE 0 0 0 0 0 0 ZZZZZZ CC CC CC CC CC CC ¢ ¢ ¢ ¢ Q Q w w w w w w V V V V V V H H H - H - H H J JJJJJ HHHHHH 7 7 7 7 7 7 O N M V 00 O O O O O O O O O O O N O M 00 00 M M M M M 01 0 01 01 01 01 O O O O O O O NSP SURCHG PMT- 05/24 NSP SURCHG PMT- 05/24 NSP SURCHG PMT- 05/24 NSP SURCHG PMT- 05/24 NSP SURCHG PMT- 05/24 NSP SURCHG PMT- 05/24 NSP SURCHG PMT- 05/24 0 0 0 0 0 0 0 J J J J J J J 0o 0] 00 00 00 00 00 CC CL CC CC CC CC CC 00 00 00 00 In In 00 7 7 7 7 7 7 7 • 0 0 0 0 0 0 Z Z Z Z Z Z Z (193.84) OMN DEPT OF LABOR & OMN DEPT OF LABOR & 180.19 OMN DEPT OF LABOR & 940.19 OMN DEPT OF LABOR & 455.10 OMN DEPT OF LABOR & 254.25 OMN DEPT OF LABOR & 235.18 OMN DEPT OF LABOR & SALES TAX PAYABLE GENERAL FUND SALES TAX PAYMENT- 05/24 13,762.00 OMNDOR- SALES TAX FUEL TAX PAYABLE GENERAL FUND SALES TAX PAYMENT- 05/24 21.00 OMNDOR- SALESTAX SALE OF DOCUMENTS CONCESSION STANDS v J W O a LT_ CAR/TRUCK WASHES CAR WASH CAR/TRUCK WASHES TRUCK WASH GENERAL ADMISSIONS SKATE SCHOOL ADMISSION ICE RENTAL - PRIME TAXABLE ROOM RENTALS OTHER RECREATION FEES Z Z Z Z Z ▪ Ce LU Ce V V V V V MEMBERSHIPS COMMUNITY CENTER GENERAL ADMISSIONS COMMUNITY CENTER ROOM RENTALS COMMUNITY CENTER OTHER RECREATION FEES COMMUNITY CENTER ROOM RENTALS PARK SERVICES PARK FACILITY RENTAL PARK SERVICES SALES TAX PAYABLE GENERAL FUND M O O 00 V CON VD ID CO O 00W W O O N C O O 00 C 0l ul W O O N N N N CO N N N c0 N N O O M M M M M 4 4 4 4 Lf1 N O N Lf1 Lf1 N N N N N N N N N N N O M M O O O O O O O O O O O O O O O O O O O O O O O O O O O SALES TAX PAYABLE- 06/24 2.00 OMNDOR- SALES TAX SALES TAX PAYABLE- 06/24 23.00 OMNDOR- SALES TAX SALES TAX PAYABLE- 06/24 3.00 OMNDOR- SALES TAX SALES TAX PAYABLE- 06/24 2.00 OMNDOR- SALES TAX SALES TAX PAYABLE- 06/24 207.00 OMNDOR- SALES TAX SALES TAX PAYABLE- 06/24 999.00 OMNDOR- SALES TAX SALES TAX PAYABLE- 06/24 3,414.00 OMNDOR- SALES TAX SALES TAX PAYABLE- 06/24 184.00 OMNDOR- SALES TAX SALES TAX PAYABLE- 06/24 3.00 OMNDOR- SALES TAX SALES TAX PAYABLE- 06/24 4,841.00 OMNDOR- SALES TAX SALES TAX PAYABLE- 06/24 2,180.00 OMNDOR- SALES TAX SALES TAX PAYABLE- 06/24 825.00 OMNDOR- SALES TAX SALES TAX PAYABLE- 06/24 19.00 OMNDOR- SALES TAX SALES TAX PAYABLE- 06/24 62.00 OMNDOR- SALES TAX SALES TAX PAYABLE- 06/24 19.00 OMNDOR- SALES TAX SALES TAX PAYABLE- 06/24 (12,783.00) OMNDOR- SALES TAX O FUEL TAX PAYABLE GENERAL FUND FUEL TAX PAYMENT- 05/24 373.48 OMNDOR-SPECIAL FUEL TAX m N 4- 0 bA tCS 0_ Page 97 of 120 Council Check Register 0 D Total Amount J J J W W W L L L LL LL LL 1- 00CC LU LL 0 FUEL TAXPAYABLE GENERAL FUND J J W W L L LL LL SEWER MANAGEMENT SWEEPING N N N N N N N N N 00 N N N N N O N N l.O l.O lO N t0 t0 O m N V N 0 m 0 O N N 0 0 0,— N N N N N N N N 0 0 0 0 0 0 O O O O O O FUEL TAX PAYAB FUEL TAX PAYAB FUEL TAX PAYAB FUEL TAX PAYAB FUEL TAX PAYAB FUEL TAX PAYAB w w w w w w LL LL LL LL LL LL Q Q Q Q Q Q w w w w w W 0_ 0_ 0_ 0_ 0_ 0_ 0 0 0 0 0 00 000000 0 0 0 0 0 0 zzzzzz 0 0 0 0 0 0 O O O O O O O 00 d O co 0i N 00 M N 0 BANK FEES- NSF FEE COMMUNITY CENTER ,JD 0 00 0 0 16.00 OMONEYMOVERS 0 Rr Ln uJ W Z INVESTMENT TRUST FUND rn oo O Ln O 0 ONB BANK FEES- 05/24 818.77 OOLD NATIONAL BANK CREDIT CARD FEES INSPECTION 0 O V 0 m 0 PAYA ACH PROCESSING FEE 05/24 14.50 OPAYA SERVICES CREDIT CARD FEES INSPECTION PAYA ACH PROCESSING FEES 06/24 708.81 OPAYA SERVICES INFORMATION TECH RENT(IS FUND) MAYOR & COUNCIL BUILDING RENT (IS FUND) MAYOR & COUNCIL INFORMATION TECH RENT(IS FUND) ADMINISTRATION EQUIPMENT RENT (IS FUND) ADMINISTRATION BUILDING RENT (IS FUND) ADMINISTRATION INFORMATION TECH RENT(IS FUND) PERSONNEL -PAYROLL INFORMATION TECH RENT(IS FUND) COMMUNICATIONS INFORMATION TECH RENT(IS FUND) INFORMATION TECHNOLOGY BUILDING RENT (IS FUND) INFORMATION TECHNOLOGY INFORMATION TECH RENT(IS FUND) TELECOMMUNCATION INFORMATION TECH RENT(IS FUND) BUILDING RENT (IS FUND) INFORMATION TECH RENT(IS FUND) BUILDING RENT (IS FUND) INFORMATION TECH RENT(IS FUND) BUILDING RENT (IS FUND) INFORMATION TECH RENT(IS FUND) EQUIPMENT RENT (IS FUND) BUILDING RENT (IS FUND) BUILDING RENT (IS FUND) INFORMATION TECH RENT(IS FUND) EQUIPMENT RENT (IS FUND) V V N V1 00 w w Z Z W W W } V V cc w w Z Z _I V V _I _IZ Z v v V m J J O O U U E i LL LL LL LL LL J W W Ln 0 Ln Ln 0 Ln Ln Ln 0 Ln Ln 0 00 0 Ln 0 Ln Ln o o Ln Ln V MV N M M V V VM V MV m N CO M N V V M M V V M M V ,9 V V V M M. V V V V V m Ln t0 t0 N NI s— N N N N N N N N m M 00 00 I. n 00 00 00 co M M 0 0 0 0 0 0 0 0 0 0 0 0 0 O O O o 0 o O 0 0 06/24 Information Technology I 06/24 Building and Park Asset 06/24 Information Technology I 06/24 Equipment ISF Rent Charg 06/24 Building and Park Asset 06/24 Information Technology I 06/24 Information Technology I 06/24 Information Technology I 06/24 Building and Park Asset 06/24 Information Technology I 06/24 Information Technology I 06/24 Building and Park Asset > 00 v o C Q L v @ C -D O @ E _ 0 0 o 5 c C N N N 0 0 O 0 06/24 Information Technology I 06/24 Building and Park Asset 06/24 Information Technology I 06/24 Equipment ISF Rent Charg 06/24 Building and Park Asset 06/24 Building and Park Asset 06/24 Information Technology I 06/24 Equipment ISF Rent Charg Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 H H H H H H H H H H H H H H H H H H H H H H Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q V V V V V V U U U V V V V V V V V V V U U U 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 J J J J J J J J J J J J J J J J J J J J J J J J —I —I —I —I —I —I —I —I —I —IJ —I —I —I —I —I —I —I —I —IQ Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q J J J J J J J J J J J J J J J J J J J J J J _ = _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 W W W W W W W W W W W W W W W W W W W W W W W W W W W W W W W W W W W W W W W W W W W w 0_ O_ 0_ 0_ 0_ 0_ 0 0_ 0 0_ 0_ 0_ 0 0 0_ 0_ 0_ 0_ 0_ 0_ 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 0) N N 0 N N N N N V7 V7 to 0 O 0 0 0 0 0 0 0 0 0 0 0 0 O O O 0 0 0 0 0 O ONOMMM O O O M O M r. M M I, O O O O O O O LO O M M M O O O M O M 0 M M M O O O O O O 00 Ln O 00 00 00 In O In M 00 00 M M L0 Ln Ln In In In In G N •• Ln Ln 0 0 N 00 N m N O 00 00 N N N N N N N N . N cr M N l0 Ns. N Cr, s.Ms. 0) 00 N N 00 N 00 N m N 4- 0 N bA Page 98 of 120 Council Check Register 0 D co 3 0 c Total Amount BUILDING RENT (IS FUND) w V 0 0 INFORMATION TECH RENT(IS FUND) CODE ENFORCEMENT INFORMATION TECH RENT(IS FUND) EQUIPMENT RENT (IS FUND) BUILDING RENT (IS FUND) w w w CC CL INFORMATION TECH RENT(IS FUND) INSPECTION EQUIPMENT RENT (IS FUND) INSPECTION BUILDING RENT (IS FUND) INSPECTION INFORMATION TECH RENT(IS FUND) ENGINEERING EQUIPMENT RENT (IS FUND) ENGINEERING BUILDING RENT (IS FUND) ENGINEERING INFORMATION TECH RENT(IS FUND) EQUIPMENT RENT (IS FUND) BUILDING RENT (IS FUND) INFORMATION TECH RENT(IS FUND) EQUIPMENT RENT (IS FUND) BUILDING RENT (IS FUND) INFORMATION TECH RENT(IS FUND) EQUIPMENT RENT (IS FUND) BUILDING RENT (IS FUND) PARK RENT (IS FUND) E- F- F- w w w uj Y Y Y Y w w w W W W ~i1 1/1 1/1 LL LL LL ▪ 0 0 aW a 1 EQUIPMENT RENT (IS FUND) RECREATION INFORMATION TECH RENT(IS FUND) SANDVENTURE POOL BUILDING RENT (IS FUND) SANDVENTURE POOL INFORMATION TECH RENT(IS FUND) EQUIPMENT RENT (IS FUND) BUILDING RENT (IS FUND) INFORMATION TECH RENT(IS FUND) COMMUNITY CENTER BUILDING RENT (IS FUND) COMMUNITY CENTER INFORMATION TECH RENT(IS FUND) EDA MANAGEMENT BUILDING RENT (IS FUND) EDA MANAGEMENT INFORMATION TECH RENT(IS FUND) SEWER MANAGEMENT BUILDING RENT (IS FUND) SEWER MANAGEMENT INFORMATION TECH RENT(IS FUND) SURFACE WATER MANAGEMENT BUILDING RENT (IS FUND) SURFACE WATER MANAGEMENT RENTS (INTERNAL CHARGES) EQUIPMENT 1.5. FUND RENTS (INTERNAL CHARGES) PARK ASSET I.S. FUND RENTS (INTERNAL CHARGES) INFO TECH I.S. FUND RENTS (INTERNAL CHARGES) BUILDING I.S. FUND O Ln Ln 311 O VI 3/1 O 00 311 O 00 00 O Ln Ln O V) L(1 O O V7 Ln O LO LO O Ln O L(1 O Ln O Ll1 O O O O O M • N M N M N M ▪ N M ▪ N M▪ N M V N • M • N M ▪ M ▪ M ▪ M M V co 00 00 00 N N N M M m H H H N N N V V V N N N N I", n • n n n n n • n • co 00 M 00 O O O M M M M M M M M d- `- d- d- d- d- O O O O O O O O O O O O n n n n o0 00 00 CO O O O O O O O O O O O O O O O O O O O O O O O O O O O O O N N I, r r r N N N N 06/24 Building and Park Asset >, >, 0A 00 O O o o C C L L V V v - C C O O n n3 E E `o `o w w _C C 7 N N 0 0 O O 06/24 Equipment ISF Rent Charg 06/24 Building and Park Asset nformation Technology I 06/24 Equipment ISF Rent Charg 06/24 Building and Park Asset nformation Technology I 06/24 Equipment ISF Rent Charg 06/24 Building and Park Asset nformation Technology I O 06/24 Equipment ISF Rent Charg 06/24 Building and Park Asset nformation Technology I 06/24 Equipment ISF Rent Charg 06/24 Building and Park Asset nformation Technology I 06/24 Equipment ISF Rent Charg 06/24 Building and Park Asset 06/24 Building and Park Asset 06/24 Equipment ISF Rent Charg 06/24 Information Technology I 06/24 Building and Park Asset 06/24 Information Technology I 06/24 Equipment ISF Rent Charg 06/24 Building and Park Asset 06/24 Information Technology I 06/24 Building and Park Asset 06/24 Information Technology I 06/24 Building and Park Asset 06/24 Information Technology I 06/24 Building and Park Asset 06/24 Information Technology I 06/24 Building and Park Asset bA L 00 0) V) C a 01 Y LL LL -0 +. C C 0 v E c a 0 0 W CO N N O LO 0 0 06/24 Information Technology I 06/24 Building and Park Asset Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 H H H H H H H H H H H H H H H H H H H H H H H H H H H H H H H H H H H H H H H a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a V V V V V V V V V V V V V V V V V V V V V V V V V V V V V V V V V V V V V V V O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ = _ _ _ H H H H H H F- F- F- F- F- H H H H H H H H H H F- F- F H H H H H H H H F- F- F- F H H H Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z z z z z Z Z Z Z Z Z Z Z z z z z Z Z Z Z O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 W W W W W W W W W W W W W W W W W W W W W W W W W W W W W W W W W W W W W W W W W W W W W W W W W W W W W W W W W W W W W W w W W W W W W W W W W W W W W W 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ = _ _ _ V/ V) O1 L/1 V) N VI VI )n VI (0 )n )n )n )n )n )n )n VI VI )n V VI )n )n )n )n )n 1n 1n VI VI M M (0 N N vl 3/1 O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O O O O O 0 0 0 0 0 O O 0 0 0 0 M M M 0 0 O M N M O O M 0. O M O co 0. 0 co co co M 0 O O O N N O 0 M I. O N _^ co M M O O O co 0 M O O M 0 O M O M 0 0 M O M M O O O O 0 0 O 0 M 0 O 0 M O M l0 00 M M O 00 00 M 00 L6 O 00 O O 06 L6 (0 M 00 00 M O O O O O l0 00 l0 O 00 Ln M _. Ln CO M 0 N N W 0 N Ln u1 lD 0 0 N CO M N 00 00 0 O O 00 ▪ O L L!1 O O N M - M LD I. N N 0 d- LED O 0 0 O N N 0 00 d- V1 00 0 l0 M 0 00 N (0 (0 O I� N O T M L!▪ 1 O I. 6 N N .- M N cos N M V1 . .- .- N O Lfl 7NI .n M CO. N M .- LO N N. � V 3- — — � M - Ln Ln O O ADMINISTRATION Lu v PREPAID OTHER N N L0 N M O N M 3,1 O 0 FUEL USAGE ALLOCATION- 06/24 42.89 OSHAKOPEE MONTHLY ALLOCATION POSTAGE ALLOC. 06/24 41.04 OSHAKOPEE MONTHLY ALLOCATION Ln POSTAGE ALLOC. 06/24 (678.31) OSHAKOPEE MONTHLY ALLOCATION Page 99 of 120 Council Check Register 0 7 0 3 0 c Total Amount EQUIPMENT REPAIR & MAINTENANCE LU 0 LL EQUIPMENT REPAIR & MAINTENANCE EQUIPMENT REPAIR & MAINTENANCE l7 V1 V1 Z w w U z H H w w w Z J J V V V ¢ ¢ 0 0 0 cc cc LL LL LL LL LL LL LL 0 0 LU 0 LL INSPECTION EQUIPMENT REPAIR & MAINTENANCE INSPECTION INSPECTION ENGINEER FEE - PUBLIC ENGINEERING w J 00 J w V1 w LL 0 LL ENGINEERING ENGINEERING EQUIPMENT REPAIR & MAINTENANCE 0 LU w w H w w in CC CC Lu H H J CAR/TRUCK WASHES CAR WASH CAR/TRUCK WASHES TRUCK WASH w V1 Vl VI VI VI VI VI VI VI VI Vl U H H H H H H H H H H H Z z z z z z z z z z z z Z J J J J J J J J J J J w D = = = = = = = 7 D D H 0 0 0 0 0V1 V1 V1 V1 V1 V1 _ Z Z Z Z Z Z Z Z Z Z Z O 0 0 0 0 0 0 0 0 0 0 U U U U U U U U U u u 06 z z z z z z z z z z z CC 00 00 0 0 00 00 00 V> 00 00 Q w w w w w w w w w w w 0_ 0 0 0 0 0 0 0 0 0 0 0 w CC '7 a a a 6 6 6 6 3 -7 u H z z z z z z z z z z z Z w CC CC CC CC Ct Ct IX CC CC CC CC w w Z w w w w w w w w w w w IDw w w w w w w w w w w 0 < J �j z z z z z z z z z Z Z w D w V) ON w 0 0 0 0 l7 l7 l7 17 l7 l7 l7 w LL L.LJ LL d ID 0 w w w w w w w w w w w LL Y Y CC CC a 0 RECREATION RECREATION PROGRAMS GENERAL FUND GENERAL FUND H Z w o, 2 > 00 z w > z H ce H in OH 0 uj 00 w O in0 0 O cc J z w z 0 z m < z J V w 0 O¢ O cc 2 o 7 LI � = a o V 0 c 0 0 H 0 0 0 0 0 0 M O O O O O O O 00 N N M V1 `7 M LL LL LL LL LL LL LL W cC 0 0 z u M M LL UUUUUUUU SAN21-001 MARAS/HANSON UTILITY SAN23-002 SOUTHBRIDGE LIFT REH SAN24-003 LIFT STATION #16 SEWER MANAGEMENT EQUIPMENT REPAIR & MAINTENANCE SEWER MANAGEMENT LU 0 LL V Z Lu Lu V) N N N 0 N 0 N N 0 N 0 N N N N O N N 0 N N O O N N N N N N N N N N N N O N M M N N M N V N V M N N M N N 00 00 N V N M N N'q N M M N N N N 00 N N N N M i0 N M N N N '0 '0 N N N M u1 V1 M M M M M M M M M M M N N N O 0 O O 4 V1 00 O M O 0 00 M 00 M V1 r 00 00 N N M M CO N N V V1 00 N N I� n O 0 01 N N M V V1 V 0000 00 V1 M 00 00 00 M M 01 01 M 7 7 7 ,..000 00 00 0 00 co 0 0 0 01 01 01 Cl 00 01 01 r. r. r. 0 0 0 0 O O O O O O O O O O O O O O O O O O O 0 H i0 0 0 0 0 0 0 0 0 0 k.0 I. n N POSTAGE ALLOC. 06/24 POSTAGE ALLOC. 06/24 FUEL USAGE ALLOCATION- 06/24 CAR/TRUCK WASHES- 06/24 FUEL USAGE ALLOCATION- 06/24 CAR/TRUCK WASHES- 06/24 POSTAGE ALLOC. 06/24 FUEL USAGE ALLOCATION- 06/24 CAR/TRUCK WASHES- 06/24 FUEL USAGE ALLOCATION- 06/24 CAR/TRUCK WASHES- 06/24 POSTAGE ALLOC. 06/24 INTERNAL CHARGES- 06/24 FUEL USAGE ALLOCATION- 06/24 POSTAGE ALLOC. 06/24 FUEL USAGE ALLOCATION- 06/24 CAR/TRUCK WASHES- 06/24 FUEL USAGE ALLOCATION- 06/24 CAR/TRUCK WASHES- 06/24 CAR/TRUCK WASHES- 06/24 FUEL USAGE ALLOCATION- 06/24 CAR/TRUCK WASHES- 06/24 FUEL USAGE ALLOCATION- 06/24 POSTAGE ALLOC. 06/24 FUEL USAGE ALLOCATION- 06/24 FUEL USAGE ALLOCATION- 06/24 NTERNAL CHARGES- 06/24 NTERNAL CHARGES- 06/24 NTERNAL CHARGES- 06/24 NTERNAL CHARGES- 06/24 NTERNAL CHARGES- 06/24 NTERNAL CHARGES- 06/24 NTERNAL CHARGES- 06/24 NTERNAL CHARGES- 06/24 NTERNAL CHARGES- 06/24 NTERNAL CHARGES- 06/24 NTERNAL CHARGES- 06/24 FUEL USAGE ALLOCATION- 06/24 CAR/TRUCK WASHES- 06/24 FUEL USAGE ALLOCATION- 06/24 Z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 H H H H H H H H H H H H H H H H H H H H H H H H H H H H H H H H H H H H H H H H V V U U u U V u u u u u u u u U U U u u u u u u u u U U U U u u u u u u u u u u 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J a a Q Q a a a a a a a a a 0 0 0 a a a a a a a a a a Q Q Q a a a a Q > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ = _ _ _ _ H H H H H H H H H H H H H H H H H H H H H H H H H H H H H H H H H H H H H H H H z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w 0_ 0 0 0 0 0 0 CL w w CL d d 0 0 0 d d d 0_ 0_ d 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ d 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ = _ _ _ _ V1 V1 V1 V1 V1 V1 V1 V1 VI VI Ul V) V1 V1 V1 V1 V1 V1 V1 V1 VI VI VI V) V1 V1 V1 V1 V1 V1 V1 V1 VI VI V1 V1 V1 V1 1/1 V1 O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O 00 M M 0 O 0 00 0 0 O 00 N. O 00 O V) 10 O O N 00 ,t 10 VC) O 00 0 l0 0 10 N N O M O O O M O 00cr, 00 O l0 O 01 O 0 O O O N M 00 N N N l0 N 01 00 O 0 01 N M 00 l0 4 00 N N O od l0 O N 01 00 O O N ( 00 N 0 l0 O O V7 0 V1 l0 Vl Vl M 4 l0 0 l0 N M N 00 N .— l0 N l0 0 01 ‘..0N M N V1 V1 N N N 'q N l0 .— N N V1 N 4 N N M N M ^ 00 N N N = N = = — l0 l0 01 H ri V1 ^ NI. CREDIT CARD FEES INSPECTION O Ln m M 0 US BANK MERCHANT FEES- 05/24 22,966.43 OUS BANK MERCHANT CONNECT Page 100 of 120 Council Check Register 0 D 0 rn 3 O c c Total Amount UNIFORMS/CLOTHING cc a N N BOOT REIMBURSEMENT 59.96 ALLEY, RYAN EQUIPMENT REPAIR & MAINTENANCE uJ w J a a w VcL 0 0_ a ARROW HARDWARE & PAINT SHAKOPE f0 W Vl O — Q • 0 O L uJ w J a a BUILDING REPAIRS & MAINTENANCE a a VI 0 w w J J 0_ a 0_ a SURFACE WATER MANAGEMENT SURFACE WATER MANAGEMENT N Ln N N O O O N M N N 0 0 O 0 N N M M 0 0 n n 0 0 Ns (1.60) ARROW HARDWARE & PAINT SHAKOPE 0 0 J LL ARROW HARDWARE & PAINT SHAKOPE UNIFORMS/CLOTHING UNIFORMS/CLOTHING w 0 w w w CC CC u_ u U- N N N M N N M 0 O O N N N M M M 0 0 0 ASPEN MILLS ASPEN MILLS ASPEN MILLS CO PAVEMENT PRESERVATION UJ w SEAL COAT 123,311.52 ASTECH CORP MINOR EQUIP (NOT CAPITALIZED) COMMUNICATIONS CAMERA EQUIPMENT 1,902.41 B&H PHOTO VIDEO MATERIALS SURFACE WATER MANAGEMENT BLACKTOP FOR CB'S 155.17 BITUMINOUS ROADWAYS INC IMPROVEMENTS/INFRASTRUCTURE CIF24-001 &24-011-013 PROJECTS MATERIALS SURFACE WATER MANAGEMENT ✓ I VI N ul • M O N N M&O PAY REQUEST#1 1,784,734.03 BITUMINOUS ROADWAYS INC BLACKTOP FOR CB REPAIR 393.84 BITUMINOUS ROADWAYS INC 1,785,127.87 ENGINEERING/DESIGN CONSULTANTS CIF23-016 TRAFFIC SIGNAL 5,240.73 BLONDO CONSULTING LLC ENGINEERING/DESIGN CONSULTANTS SAN24-003 LIFT STATION #16 427.50 BLONDO CONSULTING LLC BUILDING REPAIRS & MAINTENANCE BUILDING REPAIRS & MAINTENANCE BUILDING REPAIRS & MAINTENANCE w V J w w p CC CC d w U- N M M M 0 0 0 0 0 0 z z z 0 0 0 1,075.00 BOBS LAWN & LANDSCAPING , INC 600.00 BOBS LAWN & LANDSCAPING , INC 1,025.00 BOBS LAWN & LANDSCAPING , INC O O 0 ENGINEERING/DESIGN CONSULTANTS PR23-002 RIVERBANK STABILIZATI 32,440.50 BOLTON & MENK INC Page 101 of 120 Council Check Register 0 D a) 3 O c Total Amount CONFERENCE/SCHOOL/TRAINING-ALL LU LL rq N rn O 104.00 BREEGGEMANN, THOMAS 0 O O WELLNESS PROGRAM PERSONNEL - PAYROLL 0123.6471 WELLNESS 20.00 BUSKA, KELLY W J 0 0 0 0 INFO TECH I.S. FUND 2024 COMPUTER REPLACEMENT COMPUTER DOCKING STATIONS CDW GOVERNMENT INC MINOR EQUIP (NOT CAPITALIZED) INFO TECH I.S. FUND CRADLEPOINT CDW GOVERNMENT INC MINOR EQUIP (NOT CAPITALIZED) INFO TECH I.S. FUND COMPUTER WARRANTIES CDW GOVERNMENT INC 0 LO m 0 O O 00 O O oz.)00 N 00 N Lfl 00 L71 N IMPROVEMENTS/INFRASTRUCTURE BA22-015 SANDVENTURE RENOVATIO O N 00 O 6,835.00 CENTURY FENCE CO TELEPHONE INFORMATION TECHNOLOGY TELEPHONE TELEPHONE TELEPHONE TELEPHONE TELEPHONE TELEPHONE TELEPHONE TELEPHONE TELEPHONE TELEPHONE TELEPHONE TELEPHONE C[ C[ Ct W W W W H Q Q Q U U U U w H CC CC CC J J J J W WLu CC W CC CO m m 0 0 0 0 CC CC H J 0 J J J CI- CI- CI- CI- LT LT In U-0- TELEPHONE ICE ARENA TELEPHONE COMMUNITY CENTER TELEPHONE COMMUNITY CENTER TELEPHONE PARK SERVICES TELEPHONE PARK SERVICES TELEPHONE PARK SERVICES TELEPHONE PARK SERVICES PROFESSIONAL SERVICES INFO TECH I.S. FUND 2024 IT OPERTIONAL EXPENSES • d- • N 00 00 ▪ r) M M M M M 00 M M M M M ▪ M 00 N) M M M N CO Cr) M M M M M M Cr) Cr) Cr) Cr) Cr) CO CO M CO M M CO M U t0 N N N M Ln 00 Lf) Lf) 00 N 00 00 CO N N N V N 04 n n n n n n O M M M M M M LO 00 O O O O O O O O 0 O O O O O O O O O 0 O 04 feesFed Univ Service Fund surc 952-233-3852 Library 952-233-3853 Library B/U Fire 952-233-3854 Library Fire Pane 952-233-3838 Business Package 952-496-7682 Business Package 952-496-7682 Police not sure 0) ii a 0) 0 0) O 00 M co O 00 0 Ln 0 952-233-3838 Fire Station #2 f 952-233-3855 Fire #1 fire pane 952-233-3806 Streets 952-233-3806 Shop 952-233-3806 Parks 952-445-9010 Ice Arena fire Pa 952-233-3841,952-233-3844 Busi 952-233-3844 Com Ctr Fire Pane 952 233-3841 Youth Bldg 952-233-3841,952-233-3849 Busi 952-233-3849 Business Package 952-233-3849 Schleper Stadium F94-179-5004 network ACS 2 wir Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y ZZZZZZZZZZZZZZZZZZZZZ J J J J J J J J J J J J J J J J J J J J J } } } } } } } } } } } } } } } } } } } } } 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0 H H H H F- F- F- F- H H H H H H H H H H H H E- HHHHHHHHHHHHHHHHHHHH H Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z W W W W W W W W W W W W W W W W W W W W W U U U U U U U U U U U U U U U U U U U U U 0 00 I, I, I, Ln Ln co 04 04 0 0 0 0 0 00 Ln a-, 00 0 O O l0 l0 l0 N N CO l0 M 0l M M M O N l0 M N N 000 N 0 M M M N 4 O M M 04 0 0 Ln O O 00 M O L0 CO BUILDING REPAIRS & MAINTENANCE BUILDING REPAIRS & MAINTENANCE EQUIPMENT REPAIR & MAINTENANCE BUILDING REPAIRS & MAINTENANCE PROFESSIONAL SERVICES W J W W O Lu J < < LL LL LL 0 W L n 0) O LS) N N CO M N M CO O O m m 0 00 00 O O O O O CASE OF BULBS WASHER& DRYER POWER ADDED SK7042 HOIST REPAIR LIGHTING ITEMS BROKEN WIRE LIONS BATHROOM U U U U U Z Z Z Z Z U UUU 00 00 00 UUUUU W W W W W J J J J J W W W W W W W W W W UUUUU O 0 0 0 0 2 2 2 2 2 UUUUU o o rn r M 0 0 ✓ n ▪ LO 0, N l0 M N m N 4- 0 LO v bA Page 102 of 120 Council Check Register 0 D c 0 C Q w O c c Total Amount PROFESSIONAL SERVICES cc a N m HUBER WIRING 82.50 CHOICE ELECTRIC INC co N M w J a a N N O MEDICAL SUPPLIES 50.23 CINTAS CORP U U U U LU V V U U V Q Q Q Q Q Q Q Q Q Q Z Z Z Z Z Z Z Z Z Z H H H Z Z Z Z Z Z Z Z Z Z d S • dS dS dS dS dS dS dS 06 06 cC cC cC cC o c aaaaadaaaa in in in in w w w w w w CC CC cc cc cc cc cc cc cc cc H H H H H H H H H H Z Z Z Z Z Z Z Z Z Z w w w w w w w w w w a • a a a a a a a a a DDDDDDDDDD a a a a O' O' O' O' 0' w w w w w w w w w w w 1- 1- w w Y Y w w w w CC CC in in CC CC 1- 1- J J Q Q V1 V1 w w a a SEWER MANAGEMENT SEWER MANAGEMENT SURFACE WATER MANAGEMENT SURFACE WATER MANAGEMENT N N N N di- di- di- d • N N N N N N N N N N N O O O O O O O O N N N N 0 ▪ 0 0 0 0 ONNNN JT BG BE CS LL CR TS MR JT BG BE CS LL CR TS MR J J U U a a GHTSSBTMTKKWDBJSMFJF GH TS SB TM TK KW DB JS MF JF U1 m CO CC CC U U Y Y 0_ a a a a a a a a a CC CC CC CC CC K C< CC CC c O 0 0 0 0 0 0 0 0 0 Q ▪ ▪ Q ▪ Q Q Q Q ▪ Q Q ▪ Q Q Z Z Z Z Z Z Z Z Z Z U U U U U U U U U M V1 V1 O O O O1 N N M M cv co oo L!1 L!1 M M oo oo l0 l0 • W 00 00 c0 c H 4 4 N N co co N N N N co N DATALINES/INTERNET INFO TECH I.S. FUND 7806.6339 2024 IT OPERTIONAL EXPENSES HIGH SPEED LINE 86.90 COMCAST BUSINESS EQUIPMENT REPAIR & MAINTENANCE EQUIPMENT REPAIR & MAINTENANCE uJ w wCC Ct a 2 CYCLE OIL CONCRETE CUTTING & CORING INC 2 CYCLE OIL CONCRETE CUTTING & CORING INC o oo 00 o O O N co N N CONFERENCE/SCHOOL/TRAINING-ALL ADMINISTRATION N 0 LMC AWARD RECEPTION 158.30 COONS, ANDREW 0 WELLNESS PROGRAM PERSONNEL -PAYROLL 0123.6471 WELLNESS POP MACHINE 55.66 CUB FOODS SHAKOPEE GO Go CONFERENCE/SCHOOL/TRAINING-ALL uJ w N 3,000.00 CUSTOMIZED FIRE RESCUE TRAININ 00 w w J J a a a a COMMUNITY CENTER VACUUM BAGS DALCO-IMPERIAL DADE COMMUNITY CENTER CLEANING SUPPIES DALCO-IMPERIAL DADE 0 0 00 o O O o H O oLo co n 00 0 w w J J a a a a COMMUNITY CENTER N N O O N N O M N N 00 00 0 0 DALCO-IMPERIAL DADE CLEANING SUPPLIES DALCO-IMPERIAL DADE 00 0 M 't O N N V1 CO n WELLNESS PROGRAM PERSONNEL - PAYROLL 0123.6471 WELLNESS 20.00 DAVIS, JOSH Page 103 of 120 Council Check Register 0 D Total Amount O O w cc O RECREATION N CD O 236.10 DAXKO LLC DBA GROUPEX PRO WELLNESS PROGRAM PERSONNEL - PAYROLL 0123.6471 WELLNESS 80.00 DELANEY, WILLIAM O uJ w a SURFACE WATER MANAGEMENT WEED KILLER 3,700.24 DELTA FOREMOST w U- w LU a Lu w .17 STREET SWEEPINGS 3,305.47 DEM-CON LANDFILL INC DAMAGE DEPOSIT PARK SERVICES REFUND DAMAGE DEPOSIT 300.00 DICKMAN, KRISTA 0 0 O M UNIFORMS/CLOTHING SANDVENTURE POOL SV POLOS AND T SHIRTS 500.00 EDGE TEK HOCKEY LLC UNIFORMS/CLOTHING RECREATION PROGRAMS SUMMER REC STAFF SHIRTS 600.00 EDGE TEK HOCKEY LLC 0 O WELLNESS PROGRAM PERSONNEL - PAYROLL 0123.6471 WELLNESS 20.00 EGAN, ROGER O O w cc MAINT - FUEL SYSTEM EKOS APPLICATION 160.00 EKOS INC O CLEANING SERVICES RIVER CITY CENTRE 0 N M O M N RCC INTERIOR/EXTERIOR WINDOWS 3,088.69 EXCEL WINDOW CLEANING CO INC VISION PAYABLE PAYROLL CLEARING 628.54 EYEMED EQUIPMENT REPAIR & MAINTENANCE LU CC w EQUIPMENT REPAIR & MAINTENANCE O 0 V N N N N N M O O 0 00 0 00 351.86 FACTORY MOTOR PARTS INC 24.45 FACTORY MOTOR PARTS INC EQUIPMENT REPAIR & MAINTENANCE EQUIPMENT REPAIR & MAINTENANCE EQUIPMENT REPAIR & MAINTENANCE _v w J w w CC O u- 0 w w EQUIPMENT REPAIR & MAINTENANCE SURFACE WATER MANAGEMENT O O O O 00 00 0 N N N N O O O O N N M M M 0 n O O O 89.13 FACTORY MOTOR PARTS INC 89.13 FACTORY MOTOR PARTS INC 89.14 FACTORY MOTOR PARTS INC 89.13 FACTORY MOTOR PARTS INC 0 w a D 0 SURFACE WATER MANAGEMENT O 00 85.58 FASTENAL N 4- 0 00 v bA Page 104 of 120 Council Check Register 0 D rn Lu 3 M O c Total Amount DAMAGE DEPOSIT COMMUNITY CENTER REFUND DAMAGE DEPOSIT 300.00 FIELDSETH,JIM PROFESSIONAL SERVICES PARK SERVICES 450.00 FISHER, MARKA 0 O IMPROVEMENTS/INFRASTRUCTURE PR21-004 LIONS PARK RENOVATION SHADE STRUCTURES 31,624.40 FLAGSHIP RECREATION LLC BUILDING REPAIRS & MAINTENANCE ICE ARENA PEST CONTROL 109.00 FRANCIS ANIMAL & PEST CONTROL BUILDING REPAIRS & MAINTENANCE COMMUNITY CENTER PEST CONTROL 56.00 FRANCIS ANIMAL & PEST CONTROL 0 0 PROFESSIONAL SERVICES RECREATION PROGRAMS N JUNE FOOTCARE APPTS 240.00 GOODSEN, HEIDI 0 0 N Ln w J a a RECREATION PROGRAMS BASKETBALLS FOR PROGRAMMING 297.00 GOPHER SPORTS PROFESSIONAL SERVICES SEWER MANAGEMENT PROFESSIONAL SERVICES SURFACE WATER MANAGEMENT N N N N M M � O m GOPHER STATE ONE -CALL INC GOPHER STATE ONE -CALL INC 0 N M 0 0 0 N: NI 0/I- N L/l L!1 Y7 0 co BUILDING REPAIRS & MAINTENANCE COMMUNITY CENTER SHOWER VALVE 373.34 GRAINGER INC EQUIPMENT LEASES UNALLOCATED N rn 154.95 GREAT AMERICA FINANCIAL SERVIC DAMAGE DEPOSIT PARK SERVICES CO REFUND DAMAGE DEPOSIT 300.00 HAAS, SEAN UJ w J a a COMMUNITY CENTER 2,166.67 HAWKINS, INC DAMAGE DEPOSIT COMMUNITY CENTER REFUND DAMAGE DEPOSIT HELM, REBECCA DAMAGE DEPOSIT PARK SERVICES REFUND DAMAGE DEPOSIT HELM, REBECCA n o 0 co O O 6 o 0 O ▪ O O LP 0 0 0 J w D LL cc a O 0 SMALL ENGINE FUEL 77.99 HENNEN'S AUTO SERVICE CTR rn 0) 1- J w 1 LL w LL 22.75 HENNEN'S AUTO SERVICE CTR Council Check Register 0 D `o c Total Amount BUILDING REPAIRS & MAINTENANCE w LL 152.57 HUEBSCH CO U U U U U z ¢ ¢ ¢ ¢ z z z z z F- F- F- F- F- z z z z z CC CC CC CC CC a a a a a w w w w w CC CC CC CC CC l7 l7 l7 l7 l7 ZZZZZ Cl J J J J J CODDDDD CO m m in w V LL ICE ARENA COMMUNITY CENTER PARK SERVICES Ln Ln Ln L!] Ln m M M m M M V1 co N I� n n M O )O )O O O O O O V) V) HUEBSCH CO HUEBSCH CO RUGS/RAGS HUEBSCH CO RUGS/RAGS HUEBSCH CO HUEBSCH CO In N. C O co V N l0 M N W V cd M WELLNESS PROGRAM PERSONNEL - PAYROLL 0123.6471 WELLNESS 20.00 HUTSON,ANDY 0 w J a a D INFO TECH I.S. FUND 7806.6202 2024 IT OPERTIONAL EXPENSES SECURITY CARDS 203.40 I D E NT ISYS UJ w J a a D w V_ J 0 a TATTOOS FOR DEPARTMENT 718.00 IDENTITY LINKS EQUIPMENT REPAIR & MAINTENANCE TUBE GREASE IMPERIAL SUPPLIES LLC EQUIPMENT REPAIR & MAINTENANCE SK1048 PARTS IMPERIAL SUPPLIES LLC EQUIPMENT REPAIR & MAINTENANCE TUBE GREASE IMPERIAL SUPPLIES LLC 0O O1 ).O 0 O N-, (NI cci O W N� n 0 N 0 N M EQUIPMENT REPAIR & MAINTENANCE cc a PRESSURE WASHER TIPS 245.96 IMPERIAL SUPPLIES LLC CD N WELLNESS PROGRAM PERSONNEL -PAYROLL 0123.6471 WELLNESS 20.00 INDREBO, ROB V) VI V1 VI w w w w J J J J a a a a a a CL a DDDD c COMMUNITY CENTER COMMUNITY CENTER PARK SERVICES PARK SERVICES NNNN O O O O NNNN N N N n n N N Lri O O 0 0 0 0 INNOVATIVE OFFICE SOLUTIONS, L INNOVATIVE OFFICE SOLUTIONS, L INNOVATIVE OFFICE SOLUTIONS, L O O O V 0 l0 O o co v r N CO N INNOVATIVE OFFICE SOLUTIONS, L L/1 co UNIFORMS/CLOTHING w V J 0 LL N N O M O LARSON UNIFORM SHIRTS O 0 M WELLNESS PROGRAM PERSONNEL - PAYROLL 0123.6471 WELLNESS 70.00 JANKE, STEPHANIE 0 m N 4- 0 b0 Page 106 of 120 Council Check Register 0 D Total Amount BUILDING REPAIRS & MAINTENANCE PARK SERVICES SIMPLEX YEARLY 412.00 JOHNSON CONTROLS FIRE PROTECT! 0 WELLNESS PROGRAM PERSONNEL - PAYROLL 0123.6471 WELLNESS 20.00 JORDAN, ALEXANDER 0 0 ABATEMENT SETTLEMENT KEB ABATEMENT Ln N N LIl co 2024 1ST HALF SETTLEMENT 20,715.50 KEB AMERICA LLC 0 EQUIPMENT REPAIR & MAINTENANCE ce a JD MOWER FILTER 275.49 KIBBLE EQUIPMENT LLC v n ENGINEERING/DESIGN CONSULTANTS ENGINEERING 658.75 KIMLEY-HORN & ASSOCIATES INC ENGINEERING/DESIGN CONSULTANTS RVBP-COLBURN DR IMPR PROJ 3,731.25 KIMLEY-HORN &ASSOCIATES INC 0 O7 MEMBERSHIPS COMMUNITY CENTER REFUND MEMBERSHIP 234.92 KINSEL, RENEE rn N uJ w J a a w V_ J 0 a NB83 LIDAR 128.00 KUSTOM SIGNALS INC UNION DUES PAYABLE PAYROLL CLEARING J 0 CL LAW ENFORCEMENT LABOR SERVICES UNION DUES PAYABLE PAYROLL CLEARING SERGEANTS LAW ENFORCEMENT LABOR SERVICES 0 On 0 cci N D In 0 CO 0 M AWARDS & DAMAGES UJ w w cc 3,723.41 LEAGUE OF MN CITIES INSURANCE VI VI V) U1 VI w w w w w J J J J J a a a a a a a a CL a DDDDD c F w w F SURFACE WATER MANAGEMENT SURFACE WATER MANAGEMENT SURFACE WATER MANAGEMENT SURFACE WATER MANAGEMENT N N N N N O O O O O N N N N N O O O O O N N r N SIDEWALK SUPPLIES POLY FOR FLOODING POLY FOR FLOODING POLY FOR FLOODING POLY FOR FLOODING V V V V Z Z Z Z Z M w CC CC CC w w w w w CO CO CO M CO J J J J J Y Y Y Y Y Z Z Z Z Z J J J J J v N 00 w M aO ` a) n N 0 N N M M co rn M CO 0 SEWER MANAGEMENT SURFACE WATER MANAGEMENT N N O O N N O r M N N N N LOCATE FLAGS 365.61 LOCATORS & SUPPLIES INC LOCATE FLAGS 365.61 LOCATORS & SUPPLIES INC UNIFORMS/CLOTHING N d- BOOT REIMBURSEMENT 225.00 LOWY, CHARLES 0 10 WELLNESS PROGRAM PERSONNEL - PAYROLL 0123.6471 WELLNESS 20.00 MACKLIN, KAREN m N 4- 0 b0 Page 107 of 120 Council Check Register 0 D c 0 c Q w `0 c c Total Amount O DEFERRED REV - OTHER RECREATION rn N REFUND USER CREDIT 95.00 MAINS'L SERVICES 0 0 0 0 0 0 0 0 0 0 0 ZZZZZZZZZZZ _ _ _ _ _ _ _ _ _ _ _ Ln Ln Ln V) VI VI VI N VI J J J J J J J J J J J CO CO CO CO CO CO CO CO CO CO CO DDDDDDDDDDD d cL 0_ D_ 0_ 0 0 CL 0 d Z Z Z Z Z Z Z Z Z Z Z z z z z z z z z z z z CC CC CC CC CC CC CC CC CC CC CC a a a a a a a d a a a INFORMATION TECHNOLOGY INFORMATION TECHNOLOGY VI uJ w H w 1- 0 lJ w w W C[ v O CCCC J aF Q Li a LL in w d RECREATION SEWER MANAGEMENT SURFACE WATER MANAGEMENT O O O O O O O O O m M M CO CO M M M M M M m M M M M M M M M M M O O O O O O O O O O O N ▪ N ▪ CO N N ▪ N N M 01 M ▪ LO O N N O O O O O O O O O N N O 0 0 0 0 0 0 0 0 0 0 LIUUUULJUULJUU 0• I, Ln Ln O LO O Ln L Lf1 LO 0 M V N N Ln N Ln N N N N Lti 0 N O O Ln Ln O Ln Ln O N CO N N In 00 00 N 00 CO t 00 V ,- 00 In .q N IMPROVEMENTS/INFRASTRUCTURE CIF23-016 TRAFFIC SIGNAL L n O 261,752.49 MAX STEININGER INC v csi DAMAGE DEPOSIT PARK SERVICES REFUND DAMAGE DEPOSIT MCCULLEY, MICHELLE PARK FAC. RENT - NONTAX/EXEMPT PARK SERVICES REFUND DAMAGE DEPOSIT MCCULLEY, MICHELLE 0 0 0 0 O O O O In 0 o f0 PROFESSIONAL SERVICES RECREATION PROGRAMS O 0 O 0 AOA STILL WATER RIVER TRIP 2,389.00 MEDICINE LAKE TOURS 0 CO MET COUNCIL SEWER DISPOSAL CHG SEWER MANAGEMENT 218,977.51 METRO COUNCIL ENVIRO SERVICES BUILDING REPAIRS & MAINTENANCE L n 0 O QUARTERLY WORK. 289.59 METRO ELEVATOR INC BUILDING REPAIRS & MAINTENANCE ICE ARENA L n 0 0 0 0 240.12 METRO ELEVATOR INC EQUIPMENT REPAIR & MAINTENANCE F LU 0 O 0 CURB PLATE 95.00 MID COUNTY FABRICATING INC 0 0) EQUIPMENT REPAIR & MAINTENANCE 0 WELDING GAS 25.96 MINNEAPOLIS OXYGEN CO (0 UNION DUES PAYABLE PAYROLL CLEARING N N 0 0 1,969.00 MN TEAMSTERS #320 m N 4- 0 N b0 Page 108 of 120 Council Check Register 0 D O c m Total Amount WELLNESS PROGRAM PERSONNEL - PAYROLL 0123.6471 WELLNESS 20.00 MOE, AMANDA O WELLNESS PROGRAM PERSONNEL - PAYROLL 0123.6471 WELLNESS 20.00 MOORE, MASON O V V v v LLJ zz z z z z z z z z - - - - - z z z z z CC CC CC 0 CC a a a a a 0 CC CC cc cc H H H H H H H z z z z z z z w w w w w w w 2 0 a a a 2 2 0 0 a 2 a a a DDDDDDD a a O' O' d 0' CY 00 w w w w w w 0 0 0 0 a a a a a EQUIPMENT I.S. FUND PARK INTERNAL SERVICE EQUIPMENT I.S. FUND RECREATION INTERNAL SERVICE 0000000 '7 '7 )7 )7 )7 NNNNNN h O O L O O N N N N N O O L 00 00 00 0 CO 00 0 0 0 0 0 r SK1048 PARTS SK1048 DRIVE MOTOR SK1346 PARTS SK1050 PARTS STOCK PARTS SK1444 NEW MOWER SK1446 NEW WORK CART UULJUUUU Z Z Z Z Z Z Z DDDDDDD 00 00 00 00 00 00 00 H H CC CC CC CC CC VI VI VI VI VI VI V) ❑ ❑ ❑ ❑ ❑ ❑ ❑ 301.54 MT HHHHHH l0 00 0 0 N L!1 00 00 O O I� 00 0, 000 OM O N O V 00 �n co N n CLEANING SERVICES CLEANING SERVICES CLEANING SERVICES CLEANING SERVICES 0 0 0 NNNN CO M M CO LO CO W N m ' 0 0 0 0 MULTI -SERVICES, INC MULTI -SERVICES, INC MULTI -SERVICES, INC MULTI -SERVICES, INC O co O O co O O co O l0 M l0 O O O O 00 O 0 0 O Go CLEANING SERVICES COMMUNITY CENTER 0 M 0 0 0 CLEANING COMPANY 1,274.00 MULTI -SERVICES, INC w w w w w w w w w w w w V V V V V V V V V V V V z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z w w w w w w w w w w w w z z z z z z z z z z z z z z z z z z z z z z z z a a a a a a a¢¢¢ a a cc cc cc 0 0 0 0 0 0 0 0 cc Q a 0 0 0 0 0 0 a 0 Q Q a a a a a a a a a a a a w w w w w w w w w w w w CC CC CC CC CC CC CC CC CC CC z z z z z z z z z z z z z z z z z z z z z z z z w w w w w w w w w w w w a a a a a a a a a a a a DDDDDDDDDDDD 0' 00 00 00 0' 0' 0' 0' 00 00 00 0' w w w w w w w w w w w w w w HHHH V V w w w w J J w LU LU LU LUCC CC CC CC Y Y Y a s w VI VI VI VI a a a SEWER MANAGEMENT SURFACE WATER MANAGEMENT O 0 0 0 O O O O O O O 0 V V V V rJ N N N N N N N N N N N N N O O O M M M 0 LO 0 n n 0 0 0 0 0 0 0 0 0 0 M d- N 0O O 0 0 0 0 0 0 M V1 VI VI VI VI V1 V1 NE PARTS CO NE PARTS CO NE PARTS CO NE PARTS CO NE PARTS CO NE PARTS CO NE PARTS CO NE PARTS CO NE PARTS CO NE PARTS CO NE PARTS CO NE PARTS CO NAPA GENU NAPA GENU NAPA GENU 0 N 00 V1 D o m M N V NAPA GENU (4.20) NAPA GENU 18.15 NAPA GENU (17.64) NAPA GENU NAPA GENU 478.54 NAPA GENU (35.28) NAPA GENU NAPA GENU NAPA GENU In In 0n 0n M M EQUIPMENT REPAIR & MAINTENANCE EQUIPMENT REPAIR & MAINTENANCE EQUIPMENT REPAIR & MAINTENANCE w w w w CC CC CC l00 01 a i 0 0 NAPA GENUINE PARTS CO 0421.6240 0621.6240 0 O l0 O 00 00 VI VI NAPA GENUINE PARTS CO NAPA GENUINE PARTS CO 00 I, 0l o. o r- M 00 N 4 V l(1 N O M N 4- 0 m v b0 Page 109 of 120 Council Check Register 0 7 fD Total Amount O fO O WELLNESS PROGRAM PERSONNEL - PAYROLL WELLNESS WELLNESS PROGRAM PERSONNEL - PAYROLL WELLNESS N N O O M M N N 0 0 NASCENE, CARMELA NASCENE, CARMELA O O O O � O 0 LIFE PAYABLE PAYROLL CLEARING 00 M_ N 01 O 912.00 NCPERS GROUP LIFE INS WELLNESS PROGRAM PERSONNEL - PAYROLL 0123.6471 WELLNESS 74.50 NOBLE,MARK N BUILDING REPAIRS & MAINTENANCE RIVER CITY CENTRE L (1 CO O M SHUITE 265 AC REPAIR GROCERY 358.36 NORDIC SERVICES INC oi cc a 0621.6202 0 Lu O J 71.97 NORTH AMERICAN SAFETY 1- EQUIPMENT LEASES COMMUNITY CENTER 3,395.00 NORTHLAND CAPITAL EQUIPMENT LEASES 671.00 NORTHLAND CAPITAL 0 O O IMPROVEMENTS/INFRASTRUCTURE SAN21-001 MARAS/HANSON UTILITY L n O N 00 CO O 44,526.86 NORTHWEST ASPHALT INC m CO tO ABATEMENT SETTLEMENT CHERNE ABATEMENT L n N O 00 O 2024 1ST HALF SETTLEMENT 21,687.50 OATEY COMPANY 0 10 CO O N UNIFORMS/CLOTHING COMMUNITY CENTER N N O 0- 0 0 O GUARD SUITS 112.34 ORIGINAL WATERMEN WELLNESS PROGRAM PERSONNEL - PAYROLL 0123.6471 WELLNESS 20.00 OSTLIE, JOSEPH COMMUNITY CENTER N 0 N 0 0- 00 O O O U 627.86 OXYGEN SERVICE COMPANY (0 CO CO COMMUNITY CENTER N 0 N 0 0- 00 0 O O U 248.24 OXYGEN SERVICE COMPANY YOUTH ACTIVITIES RECREATION PROGRAMS REFUND ACTIVITY 55.00 PASTORINO, AMBER N m N 4- O N b0 Page 110 of 120 Council Check Register 0 D Total Amount WELLNESS PROGRAM PERSONNEL - PAYROLL WELLNESS r O M 20.00 PEARSON,JAMIE O O IMPROVEMENTS/INFRASTRUCTURE SAN23-002 SOUTHBRIDGE LIFT REH )0 00 N M 00 rn 00 139,944.50 PEMBER COMPANIES INC OTHER DEDUCTIONS PAYROLL CLEARING O N 00 O 470.32 PINK, ESTATE OF MARK N 0 r EQUIPMENT REPAIR & MAINTENANCE a O 00 O SK1067 TIRE 451.55 POMPS TIRE N 0, 00 w J a a D RECREATION 0 n 00 O 222.00 PRAHA DIST WATER TO YOU 0 N PROFESSIONAL SERVICES SNOW & SAND r m O PLOW TRUCK GPS 280.00 PRECISE MRM LLC 0 0 CO N EQUIPMENT REPAIR & MAINTENANCE uJ LLJ W LL SK1160 PARTS 33.75 QUALITY FORKLIFT SALES AND SER PROFESSIONAL SERVICES NATURAL RESOURCES r m 00 co co 3,077.00 RES GREAT LAKES PROFESSIONAL SERVICES COMMUNICATIONS PROFESSIONAL SERVICES N N N N m m O O 00 O N 00 O N WEBSITE REDESIGN 10,000.00 REVIZE LLC WEBSITE REDESIGN 43,900.00 REVIZE LLC WELLNESS PROGRAM PERSONNEL - PAYROLL 0123.6471 WELLNESS 20.00 REYNOLDS, WILLIAM H 0 0 PARK FAC. RENT - NONTAX/EXEMPT PARK SERVICES 00 O CO 00 00 O REFUND HUBER PARK SHELTER 100.00 ROSALES, RAQUEL 0 0 O EQUIPMENT REPAIR & MAINTENANCE LU CC LL SK1318 PARTS 1,448.06 ROSENBAUER MINNESOTA LLC WELLNESS PROGRAM PERSONNEL - PAYROLL 0123.6471 WELLNESS 20.00 ROSSOW, CHRISTIE 0 O EQUIPMENT REPAIR & MAINTENANCE w V J 0 SK1399 GLASS 263.75 SAFELITE AUTO GLASS N 0 N WELLNESS PROGRAM PERSONNEL - PAYROLL WELLNESS 20.00 SCHNECK,COREY PROFESSIONAL SERVICES 30.42 SCHNECK,COREY N 4- 0 b0 crs Council Check Register 0 D Total Amount 7 WELLNESS PROGRAM PERSONNEL - PAYROLL 0123.6471 WELLNESS 20.00 SCHNEIDER, MARK CONFERENCE/SCHOOL/TRAINING-ALL N M O 104.00 SCHWAESDALL, SAMUEL O O VI VI VI Ln Ln Ln Ln Ln U U U U U U U U CC CC CC CC>> CC CC uJ uJ uJ uJ uJ uJ LL LL V) V) V) V) V) V) 00 00 z z z z z z z z Z 0 0 0 0 0 0 0 0 VI VI VI VI V) V) V) V) V) V) VI Ln 00 00 00 uJ uJ uJ uJ uJ uJ LL LL 0 0 0 CC CC 0_ 0 0 0 0 0 CI_ EDA MANAGEMENT z 0 LL l7 H 2 2 z a Liv ujin O ce c7 Lz Q H j Z o w 2 in H m O w LL zz z zO w cc > a V) <7N H CC J O Q Z in v < < la) 00 w VV)) in h. CO CT, o # 4 s 'k s 'k l'k F- F- in in in 00 00 00 00 ❑ ❑ ❑ ❑ ❑ ❑ ❑ LL u u u u LL LL HH --- N 4 0 v Ln N 0O 0, O N N 00 N M V) lD 0, N W O Lu_ LPL LPL LPL LPL LPL LPL LPL HHH H H H H H 60.00 SCOTT CO TREASURER 30.00 SCOTT CO TREASURER 40.00 SCOTT CO TREASURER 30.00 SCOTT CO TREASURER 5,640.00 SCOTT CO TREASURER 40.00 SCOTT CO TREASURER 40.00 SCOTT CO TREASURER 160.00 SCOTT CO TREASURER O O 0 EQUIPMENT REPAIR & MAINTENANCE w LL SK1016 PARTS 392.68 SHAKOPEE CHEV INC CO M TIF DIST #21 SHAKOPEE CROSSING 4084.6624 2023 FINAL SETTLEMENT 2,506.73 SHAKOPEE CROSSINGS LIMITED PAR TIF DIST #21 SHAKOPEE CROSSING 4084.6624 2024 1ST HALF SETTLEMENT 16,357.30 SHAKOPEE CROSSINGS LIMITED PAR O 0 MATERIALS SURFACE WATER MANAGEMENT LP m SAND FOR FLOODING 663.36 SHAKOPEE GRAVEL INC O M M MATERIALS m a 201.00 SHAKOPEE MDEWAKANTON SIOUX COM CONCRETE FLOWER POTS 0 N PRINTING/PUBLISHING COMMUNITY CENTER PRINTING/PUBLISHING RECREATION PROGRAMS 00 m M M M 4 r n n 0 0 O O SCHOOL FLYER 184.50 SHAKOPEE PUBLIC SCHOOL DIST 72 SCHOOL FLYER 184.50 SHAKOPEE PUBLIC SCHOOL DIST 72 lJ _v U U L) 0 cc m 00 00 00 U cc U ' w' U U U w 0 w < w CD J J J W V) W V) V) W W W V) V) w w >- >- >- } J J Q Q Q Q V V V v v cc cc CC m J J J CO CO CO COLL LL J J J J 0 0 0 N 00 N d- LSD 00 N N N lD lD lD lD lD LD LID LID LD m M cn cn M M M M co 0 O 00 00 O 00 O N N N N 00 00 CO 00 CO 00 m m m O O O O O O O O O 102580002 N N N N CD CD 0 0 O O O O lD l0 lD LD LD W dl CO 00 CO CO N N l0 O O O O M M O 0\ 00 00 O 0\ 00 0) 0) }O O O O O O O O O UUUUUUUUU F H H H H H H H H 102580002 J J J J J J J J J DDDDDDDDD U lJ lJ O O O O V V J J J J J J J J J CO m CO CO CO CO CO CO CO 00 = 00 = 00 00 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ W W W W W W W W W OJ OJ OJ OJ OJ LJ LJ LJ LJ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0 0 0 0 0 0 0 0 0 V) V) V) V) V) V) V) V) V) 00 Ln 00 M O N 00 O O O O O O O O O 47 N n n La al L 00 O O 00 N M 00 M M m N 4- 0 l0 N crs b0 Page 112 of 120 Council Check Register 0 D ik U c 0 c Lao. w 0 c Total Amount U U J U U J U U U J U U U U U U U U U U U U U U U U U U U U U U U U U H H - U v U H 1- 1- ' ' U U U U U U U U U U U U U U U U U u U U U U U U U U ce _I _I _IQ < O _I _I _IQ Q Q Q w w 0 0 J J J J J J J J J J J J J J J J J J J J J J J J J J W W W V1 V1 W W W V) V) V) V) W W W W W W W W W W W W W W W W W W W W W W W W W W U U U J U U J J J J J J J J W W W W W W W W W W W 0_ • 0_ 0_ D_ D_ D_ 0_ LL LL LL LL LL LL LL LL LL LL LL INSPECTION HHHHHHHHHH w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w CC CC CC CC CC CC Ct CC CC CC Ct 0 00 0 00 00 00 00 0 VI VI H F-� H V V H H V V V VI VI VI VI V V V VI VI V V V N N N 0 CO N cV N V • LD LO 00 00 N N N N N IN N N N N N N N N N N N N N N N N N N N N O J J J O O 0 U J J lD J J J O O O O U J O U J O 0 0 0 U J O O O J O ID ID lD ID O O J O O O M m m m m m m m M co M m m m m m co co co m m co co co m m m M m m m m m m m m m in m m m m m m N N N N N N N N N N N M N N N N N N N N N N N N N N N N N N N N N N N N N M M M M M M M M M M M M M M M M M M M 7h 7h 7h 7 7h 7h 7 O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O 0 0 0 0 0 0 0 - 01 Lf1 O O1 01 01 O O O N O O O O O 0 O O V1 O O 0 LD O O LD O O O I� 00 0 Lr1 ▪ 01 O M M N M M M N 01 01 01 O 01 01 a1 O 01 01 01 01 01 01 102971002 102971003 102971002 O O 0 01 01 01 01 01 01 102971002 N M N M '� N M l0 N CO O O O O O O O O O O O O O O O O O O O O O O O O O N O O O O O O O O O O O O O O 0 0 0 0 0 0 0 O O O 0 0 0 0 0 0 0 1f1 O 00 M 01 N N 1fl N N if) N N N N N ID J J J J 0 0 0 d - n n 0 01 V) M M N V1 10 N 0 0 10 0 0 0 0 h N N N N M 71- 01 a1 Vl M 0 V) 10 0 00 0 M M ▪ in N • d' • cr 0 00 00 71- N N N 0 N N N M m ▪ Ln Ln 0 m m M M O 01 O O O O O O O O O O O O O O O m 111 M M M 00 M M M 01 01 01 01 Q1 01 01 O • 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 U U U J U U U U U U U U U U J (JU U U U J U J U U U J U J U U U U U U U U U U J U U U U H H H H H H H H J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J DM DDDDDDD777 U J U U U J U U U J U U U J U U U U U U U J U U U U U U J U U U U U U U U U U U U J U U J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J CO 01 01 m m m m m m CO 07 01 CO CO 01 m m m m m CO CO CO m 01 01 01 00 02 02 CO CO CO CO 00 CO 01 01 CO CO 02 02 CO CO 0 0 0 0 0 = 0 = 0 = 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ d d D_ D_ D D_ D_ 0_ 0_ 0_ 0_ 0_ D_ D_ D_ D_ D 0_ 0_ D D D D - D D - D_ D_ D_ D_ 0_ 0_ 0_ D w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w 0LJ w w w w w w w w w w w w w w w w w w w w 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ D_ D_ 0_ 0_ 0_ 0_ 0_ D_ D_ D_ D_ D_ D_ 0_ D_ D_ D_ D_ D_ D_ D_ D_ D_ D_ D_ 0_ D_ 0_ O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S V1 V1 V1 V1 V1 V1 V1 V) V) V) V) V1 Ut Ut V1 V1 V1 V1 V1 V) V) V) V) V) 1/1 V1 V1 V1 V1 V1 V1 V1 V) V) Ut V1 V) V1 u> V) V1 Lc) V1 V1 O M 0 0 0 01 CO CO M LD Ll1 1D 0 N CO 1D CO N 0 10 0 10 10 0 M N N N 00 0 V1 N M O 01 N 00 H OH L!1 O 01 O M 10 O O. N a1 H 00 N V1 Ln • 10 V1 Ln O ▪ CO M LII — O V N 01 Ul O O I� D LD • 01 . 01 01 lD Ll1 O 01 O M 4 00 , CO 01 O O M O M O 00 CO O I� lfl M 00 01 Lc; ▪ 0O 00 O CO 01 O O W 01 00 V1 ,0 01 V1 00 1 CO0O N N N 00 O co V1 • LD LI) M N .q 00 H N N N O 1.11 00 00 H l.l1 01 O V1 N V1 N M h m N 4- 0 N N b0 Page 113 of 120 Council Check Register 0 D 0 rn 3 0 B Total Amount UUUUUUUUUJUUUUUUUUUUUJU J UUUUUUUUU U U U U U U U U 0 U U U U U U U U U U U U U U H H H H H H CC U H U U U U U U U U U J J J J J J J J J J J J J J J J J J J J J J J Q Q Q Q Q Q uJ uJ 0 J Q w J J J J J J J J J W W W W W W W W W W W W W W W W W W W W W W W VI V1 VI W V1 W W W W W W W W W I— I— I— I— I— I— I— I— I— I— I— I— I— I— I— I— I— I— I— I— I— H F- F- H H H H H H H H W W W W W W W W W W W W W W W W W W W W W W W W W W W W W W W W CC CC CC CC CC CC CC CC CC CC CC CC CC CC CC CC CC CC CC CC CC CC CC W CC W CC CC CC W W W CC CC CC CC CC CC CC CC CC CC CC CC CC CC CC CC CC CC CC CC CC CC CC CC CC CC CC CC CC Ct TRUCK WASH TRUCK WASH TRUCK WASH Ct CC Ct CC CC CC CC Ct a0aaaaaaa N N N N N N N N N N N N N N N N N N N N N N N .q CO CO CO N V O N N N N N N N N N CO CO O CO CO O O O O O O O CO CO CO CO O O O O O O CO O CO CO CO CO O O CO CO CO O CO O CO CO CO CO CO O O CO m m m m cn cn m m M m m On m m cn cn 00 cn m on on m Cr fn m m m m m m m m m m m M CO) m m m M M CO On O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O CO O O O O O O O N N N N N N N (N N N N N N N N N N N N N N N N NNNNN N N N N V) V) V1 N N N N N N N N N O CO CO CO CO CO O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O V) LC)N CO d- 00 M N 00 V1 CD N CO O) CO 0-,d- O O O N O N M M O O O O O O O O O O O O O O O N N M M M d- d- d- d- d- V0 V0 O O O O O O O d O 0 O O O O O O O O O O O 0 0 0 0 0 0 0 0 0 O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 N N O 0 0 0 N 0 0 0 0 0 N 0 0 N N V V) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0) M M I� O O M M M M M M V0 00 00 d' O M d' V) V) V) V) V) V) V) V) V0 Vl V1 V) V) V) V) V) V) V) V) N 41 O1 O1 N N V) V0 On N 0) Cl Cl (7On 0 M M M V) 00 M M M M M M h') M M M M M M M M CO CO M M V0 V0 no d-M M V0 0 V0 V0 V0 V0 V1 O O NNNNIMM 6) 01 6) 01 01 0) 0) (It (It 6) 0) 0)% 6) 6) 0) 0) 6) 0) 0) 0) 0) 0) 0) M CT)CT)0, 0) 0) 0) 0) 0) o o O O O O O O O 0) 01 01 0) 0) 0) 0) 0) 0) 0) 0) 0) 0) 0) 0) 0) 0) 0) 0) 0) 0) 0) 0) 0) 0) 0) — 0) 0) 0) 0) 0) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J L) U v U J J J J J H H H H H H H H J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 UUUUUUUUUUUUUUUUUUU J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J CO m m m m m m m m CO m m CO CO m m m m m m CO CO CO m m m m 00 00 00 CO CO CO CO 00 CO m m CO CO 00 00 CO CO 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 0_ 0 0 0 0 0 0 CL o_ o_ CL 0_ d d 0 0 o_ o_ a CL CL CL CL o_ O_ O_ 0_ CL 0 0 0 CL CL CL CL CL O_ O_ 0_ 0_ 0 0 0 0_ w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w o_ o_ o_ o_ o_ o_ o_ o_ o_ o_ o_ 0_ 0_ o_ 0_ 0_ o_ o_ o_ o_ o_ o_ o_ o_ 0_ o_ 0_ o_ o_ 0_ 0_ o_ o_ o_ o_ o_ 0_ o_ 0_ 0_ o_ 0_ 0_ 0_ 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S V1 V0 V0 V0 V0 V1 V1 V) V) V1 V1 V1 V) V) V) V0 V0 V1 V1 V) V) VI VI V1 V0 V) V) V0 V1 V1 V1 V1 V) V1 V1 V1 V1 V1 V1 V1 V1 V1 V1 V1 O N O O CO CO O 0 00 N N V) O V) N O N V0 O O O O N 00 V) N CO N N O N N V) 0) (' M V) co h M CO M N O N V0 N N O CO 0) O O N N h V0 M CO dl O O O M O O O M N I� M M O N N LaN 6La00 O) O O Lc;V1 6O La 6 00 00 O V) CO N N LaO) M 0) T CO N V1 O V) V) O N m V) N N N `7 N N N N N CO N `7 6) V1 O V1 N O O V) M `7 N M O N N NOIN N N M 0) O m N 4- 0 00 N bA Page 114 of 120 Council Check Register 0 7 fD 0 rn n ro 3 0 LV Total Amount U U U U U U U U U U U U U U U U U U U U co co co co co co co co co co co co co co co co co co co co cc cc oc cc cc cc co co co co co co co co ct cc cc cc cc co co co co H H H H H H H H H H H H H H H H H H H H w w w w w w w w w w w w w w w w w w w w w w w w U U U U U U U U U U U U U U U U U U U U H 1— 1— 1— 1— 1— 1— 1— 1— 1— 1— 1— 1— 1— 1— 1— 1— 1— 1— 1— 1— 1— 1— 1— w w w w w w w w w w w w w w w w w w w w Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q a Q Q w w w w w w w w w w w w w w w w w w w w Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y YYYYY CC CC CC CC CC CC CC CC CC CC CC CC CC CC CC CC CC CC CC CC CC CC CC CC CC Ct CC CC CC Ct Ct CC Ct CC CC CC CC Ct w • w w w w w w w w w w w w 0 0 w w w w 0 0 w w 0 w w w w w w w w w w w 0_ w w w w w w w w N N N N N N N N N N N N N N N N N N N N V V `Cr `7V V V V V V V U U O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O m m m m m m m m m m m cn cn m m m cn cn m cn m cn CO fn m m m rc1 rc1 m m M M m M (0) M m M M M M CO In • O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O NNNNN N N N N N N NNNNNNOINNNN N NNNNNNN N N N N N N N N N N N N N N O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O 105669001 109690002 109690003 N O M cr Vl N O N O 0, N Cr O O O O O O O O O O O O ▪ N O N d- LN M 01 O cr ul O O N N N N M n N� M M M ,..0O O O O O O O O O O O O N NNNMMMM 0 O O - O - O O O 0 0 0 0 0 0 0 0 0 N N O Cr Cr M 01 O O 0 0 0 0 0 O O O 0 0 0 0 0 0 NO 0 0 0 0 0 0 0 0 0 0 0 0 0 0 00 O O n n N. O O O O O O O O O O O O O 00 Ln Ln Ln Ln Ln Ln Ln Ln Ln Ln Ln Ln Ln Ln 7r 7r 7r M Ln Ln ,so.- 00 Ln Ln Ln Ln Ln Ln Ln Ln Ln Ln Ln Ln Ln O M M M M M M M M M M M M M M N� O O O N N N Ln Ill ▪ cf OMMMMMCOMMMMMMM 01 01 01 01 01 01 01 01 61 61 01 01 01 01 01 01 0 0 0 0 0 0 0 0 CO CO 01 O 01 01 0) 0) 01 01 01 0) Cl Cl Cr) 01 01 0) 0) 01 01 01 01 01 01 01 01 01 01 01 01 01 01 01 01 01 01 01 01 01 01 0) Cr) (7) (7) Cr) O • 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 U U U U., U U U U U U U U U U U U U U U U U U v U U U U U U U U U U U U U U U U U U U U U H H H H H H H J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J JJJJJJJJJJJ CO m m m m m m m m CO m m CO CO m m m m m m CO CO CO m m m m 00 00 00 CO CO CO CO 00 CO m m CO CO 00 00 CO CO 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y O < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < Q < < < < < < < < < S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S Ln M V Ln Ln N V) VI el el Ln N Ln Ln Ln M Ln VI VI 10 M N Ln Ln N N M M Ln Ln Ln Ln Ln M to N N N M M to Ln Ln N M M 0 00 N N I' Na) 00 I. Ln O Cr) CO CO 0 • N n M L▪ O N Ln O 00 Ill Ln O N N N O 01 Ln 00 Ln 0 L() O O I� O O • al M N CO Ln N O O N O M M I� O 00 N Ln 00 N M N CO. V V V O O N Ln O M coN . lf1 O W O 66 01 600 CO LA O Ln 4 O 00 01 6 n n Ln CO O I� Ln Ln L!1 n n Lc) Lc) (xiO W LN n N N 01 N ('4 ▪ O O M O O N N M O 0 M O Ln M N � M N N N M N � Page 115 of 120 Council Check Register 0 7 fD 0 C Total Amount _U _U U _U U U U U _ E- E-cc - E cc cc cc H H H w w w w w w U U w= U H H w U H H w U H, U U U H LU Q Q Q uJ uJ uJ uJ uJ uJ 0 O O O O J J LU UJ OI— J Q Q UJ 0 J Q Q LU F J to w w w LU v1 00 00 00 to 00 to t~/1 00 00 00 00 w w 00 In w to to w to to w Y Y Y YYYYYYYY YYY 0_ 0 ¢w ¢w ¢w ¢w ¢w ¢w 0w 0w 0w 00 00 00 SANDVENTURE POOL SANDVENTURE POOL SANDVENTURE POOL SANDVENTURE POOL Q Q Q Q Z Z Z Z w w w w CC CC CC CC Q Q Q Q V V lJ CE ARENA 0 0 0 0 0 H H H H H Z Z Z Z Z w w w w w UUUUU H H H H Z Z Z Z Z DDDDD 0 0 0 0 0 uuuuu PARK SERVICES PARK SERVICES PARK SERVICES SEWER MANAGEMENT SEWER MANAGEMENT SEWER MANAGEMENT SEWER MANAGEMENT SEWER MANAGEMENT 4 4 4 LD O up up up t0 00 00 00 00 00 N N Lc) 00 N V to 07 N ND 00 N 7 l0 N N N V tD O U O O O tD tD tD tD tD 00 O O O O tD O O O tD t0 O O tD U tD tD O O O O t0 tD M m m m 00 00 00 00 m m no no m m m cn cn cn cn 00 m m m m m m m m m m 0 m m m M 0 O O O O O O O O O O O O O O N N N N m m m m 017i 71Ln Ln Ln N N N N N N N N N N N N N N 0. n n n n n n n n 0 n n n n n n n t0 t0 t0 to O O 0 to to •D •9 to L O O O O O to 0 0 00 L.0 t0 to to to to O t0 n n n n n O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O 0- 0 r r 0- M d 0 0 0 0 O O O 00 tD 00 00 M Lip M M 0. N N 70 01 01 O O O 01 01 01 134476005 0- 0 O O 0 0 O 0 V O O 00 0 Lfl M 00 0. M N N 01 01 O O 01 01 105669001 N N N m N N h O O O O O O O O O O O O O O O O O O N 0- 0 r O O O O O O O O O O O O O O O O 0 0 0 0 N N N 0 0 t0 tD t0 VD V V V V V .- Cr 00 Cr Cr 0. 0 0 O 0 0 0 O 0 0 N N N N N N N N N 0 0 O O 00 Rr 7r 7r M M M M M M M l0 M M • 7 L.()n 00 LLI1 M r 0 0 0 0 CO M 01 M 01 M M M M M 0 0 0 N M M M M 61 61 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 01 0 01 01 01 01 01 01 01 01 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U H H H H H H H H H H H H H H H H H H H H H H H H H H H H H H H H H H H H J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J U U U U U U U U U U U U U U U U U U U UUUUUUUUUUUUUUUUU J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J CO m m m m m 0] 0] 07 CO m m CO CO m m m m m m CO CO CO 00 0 0 0 00 00 00 CO CO CO CO 0 CO DDDDDDDDDDD = = = = = = = = = = = = = = = = = = = = = = = = 7 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0_ 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S M to to to to to to to to to to to to to to to to to to to to to M to to to to to to 0 to to M to to to 01 10 N 0 CO CO r, M O N M tD N CO 0 N Ln M 01 61 Ln 0- 01 0- N Ln O L!1 O M M In In In N `7 Ln r, to 01 01 N M Ln I, M N 01 M 01 a1 01 I, CO N M 01 N LP M In M 03 00 0. 0 M Ln O 10 L!1 CO M O O 01 Lf1 Ni01 0 CO 4 4 Ln M V1 00 N M `1- V1 N M 01 N l!1 0- 10 tD O lD lD 0. 00 01 0. 00 L 1 00 M m M 61 BUILDING REPAIRS & MAINTENANCE BUILDING REPAIRS & MAINTENANCE BUILDING REPAIRS & MAINTENANCE 0 0 0 0 00 D 00 a SURFACE WATER MANAGEMENT N Ln Ln Ln N O O N m m m N to to to to to NNNN M 0 10 to ID n O 0 0 O 0- PAINT FOR GRAFFITI QUARRY DOORS QUARRY DOORS PAINT FOR STORM BASINS 0 0 0 0 0 UUUUU J J J J J J J J J J Z Z Z Z Z 00 D 0 0 0 S S S S S to to to to to _ 0 00 0 61 0- M 01 1.11 01 O M 0 01 N Ln aS m N 4- 0 N N b0 Page 116 of 120 Council Check Register 0 7 fD c 0 c R Q w 0 C Total Amount 7 !r 7 co w J a a N N TRAFFIC PAINTING SUPPLIES 7.55 SHERWIN WILLIAMS CO O r MEMBERSHIPS COMMUNITY CENTER REFUND MEMBERSHIP 23.10 SIMAFRANCA, RYAN O 7 N PROFESSIONAL SERVICES w Lu N TRAFFIC PAINTING 35,646.00 SIR LINES -A LOT O 0 0 w J a a cc a IRRIGATION SUPPLIES AND REPAIR 282.25 SITEONE LANDSCAPE SUPPLY ,P1 CO CV WELLNESS PROGRAM PERSONNEL -PAYROLL 0123.6471 WELLNESS 20.00 SMITH, KAYLIN PRINTING/PUBLISH ING COMMUNICATIONS FIRE DEPT FOAM POSTERS 152.00 SPEEDPRO IMAGING ENGINEERING/DESIGN CONSULTANTS PR21-005 WINDERMERE BLUFF PARK INVOICE #20 2,817.38 SRF CONSULTING GROUP INC CO r O N WAGES - PART TIME/TEMP ENGINEERING INTERN SALARY 1,382.76 ST CLOUD STATE UNIVERSITY CO ti N co w z J 0 l7 GENERAL FUND w w w GENERAL FUND O 0 N �n �n O O 0 0 0 0 BULK UNLEADED 15,835.98 STAPLES OIL CO BULK DIESEL 6,698.75 STAPLES OIL CO ti N N DAMAGE DEPOSIT COMMUNITY CENTER co cD 0 REFUND DAMAGE DEPOSIT 300.00 SUBRAMANIAN, ARUNKUMAR 0 O PRINTING/PUBLISH ING w V z z z LL 2023 FINANCIAL SUMMARY 1,356.75 SUEL PRINTING CO PRINTING/PUBLISH ING PLANNING 432.00 SUEL PRINTING CO PRINTING/PUBLISH ING PR25-001 HIGHVIEW PARK AD FOR CONSTRUCTION BIDS 288.75 SUEL PRINTING CO 0 ti 0 DAMAGE DEPOSIT COMMUNITY CENTER 00 0 REFUND DAMAGE DEPOSIT 300.00 SUNNY,JYOTHI EQUIPMENT REPAIR & MAINTENANCE EQUIPMENT REPAIR & MAINTENANCE EQUIPMENT REPAIR & MAINTENANCE EQUIPMENT REPAIR & MAINTENANCE H H w w w w w CC CC CC CC LL 00 00 a O O O 0 NNNN N N N N O O O NNNN 0 0 0 0 0 SHOP SUPPLIES TERMINAL SUPPLY CO O m O co O M SHOP SUPPLIES 44.84 TERMINAL SUPPLY CO SHOP SUPPLIES TERMINAL SUPPLY CO 0 N TERMINAL SUPPLY CO 00 m O, co 00 N 4- 0 N N b0 Council Check Register 0 D Total Amount EQUIPMENT REPAIR & MAINTENANCE cc 0 EQUIPMENT REPAIR & MAINTENANCE SEWER MANAGEMENT EQUIPMENT REPAIR & MAINTENANCE SEWER MANAGEMENT EQUIPMENT REPAIR & MAINTENANCE SURFACE WATER MANAGEMENT O O 0 0 N N N N O O O v 00 00 N N N o N N N SHOP SUPPLIES TERMINAL SUPPLY CO SHOP SUPPLIES TERMINAL SUPPLY CO SHOP SUPPLIES TERMINAL SUPPLY CO SHOP SUPPLIES TERMINAL SUPPLY CO CO M 00 CO O1 CO 01 0 ▪ 0 00 WELLNESS PROGRAM PERSONNEL - PAYROLL 0123.6471 WELLNESS 20.00 TESTER, BENJAMIN O O EQUIPMENT REPAIR & MAINTENANCE SEWER MANAGEMENT SK1393 PARTS 153.85 TITAN MACHINERY PROFESSIONAL SERVICES oc 0 r M O 0 5,451.78 TREASURE ENTERPRISE, INC CO a 0) BUILDING REPAIRS & MAINTENANCE BUILDING REPAIRS & MAINTENANCE BUILDING REPAIRS & MAINTENANCE L 00 0 CO M M O O O W N 00 M 0 o O 2 0 0 l7 Z w W 2 0 LL Y H z cc 0 � z � � O w w Q TRUE MECHANICAL LLC TRUE MECHANICAL LLC TRUE MECHANICAL LLC O n 0 W J D 0 RECREATION PROGRAMS UNIFORMS/CLOTHING RECREATION PROGRAMS UNIFORMS/CLOTHING RECREATION PROGRAMS 00 N N O N N N O O O 00 00 0 N N N sso 0 0 0 0 T-BALL TEAM SHIRTS VALLEY SPORTS REC ASSISTANT APPAREL VALLEY SPORTS REC ASSISTANT HATSNISORS VALLEY SPORTS O L!1 O 01 00 N N 01 N 00 co N PROFESSIONAL SERVICES ADMINISTRATION VERIFIED CREDENTIALS LLC PROFESSIONAL SERVICES Lu V VERIFIED CREDENTIALS LLC PROFESSIONAL SERVICES COMMUNITY CENTER VERIFIED CREDENTIALS LLC PROFESSIONAL SERVICES RECREATION PROGRAMS VERIFIED CREDENTIALS LLC O O O O O O O O ▪ 0 m N 4- 0 N N N 00 L L L 00 L 00 00 b.0 w w w w w w w w w w w w w (D V V V V V V V V V V V V V > > > > > > > > > > > > > EC EC 00 00 00 0 0 0 0 00 w w w w w w w w w w w w w 00 00 V 0 00 1n 1n 00 00 00 J J J J J J J J J J J J J Z Z Z Z Z Z Z Z Z Z Z Z Z O 000000000000 V) V) VI V1 V1 VI VI V) V) VI VI VI VI 1n 1n V1 V1 1n 1n 1n 1n 1n V) VI 00 W W W W W W W W W W W W W O 0 0 0 0 0 0 0 0 0 0 0 0 00 00 0- 00 0 00 00 00 C C 00 00 00 W 0 0 0 a 0 0 0 0 0 0 0 W ADMINISTRATION INFORMATION TECHNOLOGY INSPECTION ENGINEERING H w H w w CC LLJ CC V1 00 ▪ W RECREATION SEWER MANAGEMENT SURFACE WATER MANAGEMENT N N N N N N N N r r r r N N N N N N N N N N N N N N MOIMMOIMMMMMMMM O O O O LD O LC) LC) O O O N N CO N M ▪ N V N N M m M M 00 Lor, N 0 0 0 0 0 0 0 0 0 0 o r r HHHHHHHHHH H H H w w w w w w w w w w w w w w w w w w w w w w w w w w J J J J J J J J J J J J J H H H H H H H H H H H H H ✓ V V V V V V V V V V V V w w w w w w w w w w w w w Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z O 000000000000 ✓ V V V V V V V V V V V V Z Z Z Z Z Z Z Z Z Z Z Z Z O 0 0 0 0 0 0 0 0 0 0 0 0 NO NONONNNNNNNNNN 0< 0< 0_ 0_ 0 0 0 0< 0 0 0 0 0 w w w w w w w w w w w w w > > > > > > > > > > > > > OO 0 0 L0 N L!1 00 N N 01 CO 00 W 00 N N co 00 T CO M N N CO N C CO (0 O 4 l0 N Lc;M N 00 L0 O M N O� M oo . In Page 118 of 120 Council Check Register 0 D `O c c c O E 16 O O W N w w w V Z z Z W JUNE 2024 MILEAGE WECKMAN, KIM CS) PROFESSIONAL SERVICES PARK SERVICES WESTWIND SWING BAND LLC 0 O CD MATERIALS SURFACE WATER MANAGEMENT BLACKTOP FOR CB REPAIR WM MUELLER & SONS MATERIALS SURFACE WATER MANAGEMENT BLACKTOP FOR CB REPAIR WM MUELLER & SONS 0 0 00 O N 00 0 N ENGINEERING/DESIGN CONSULTANTS CIF25-001 FD PAVEMENT RECON ENGINEERING/DESIGN CONSULTANTS SAN21-001 MARAS/HANSON N N CO m o co O co 0 0 WSB & ASSOC INC PROJECT CLOSEOUT WSB & ASSOC INC in V) V) Z Z Z Q Q F- J J J 777 0 0 z z z 0 0 0 V V V z z z 0 0 J E- VI VI VI F- a a a ¢ a J J J J J 77777 0 0 0 0 0 0 0 0 0 V V V V z z z z z L VI VI VI VI VI VI VI VI W W W — W W W W W 12I 12I CI CI CI CI CI C z z z z z z z z z W z z z z z CC CC uJ w w w W W W Z Z Z Z Z Z W W W ENGINEERING PR24-001 CH 78 UNDERPASS C I F24-001 &24-01 1-013 PROJECTS IMPROVEM STS23-005 WEINANDTACRES DRAIN uJ CC CC CC w w w w w Z Z Z Z Z 0 0 J 0 0 Z Z Z Z Z W W W W W SURFACE WATER MANAGEMENT SURFACE WATER MANAGEMENT SURFACE WATER MANAGEMENT SURFACE WATER MANAGEMENT SURFACE WATER MANAGEMENT NNNVINNNNN 0 m m m N m m m m in V V V V V V V 0 O Lfl 0 OM M M M M M O 0 0 0 I, r r n r PRIVATE DEVELOPMENT INSPECTION V V V V V V V V V Z Z Z Z Z Z Z Z Z WSB & ASSOC WSB & ASSOC WSB & ASSOC o o l(1 O � n W NLgi N ro 0 0 0 m N M WSB & ASSOC WSB & ASSOC WSB & ASSOC WSB & ASSOC WSB & ASSOC WSB & ASSOC 0 0 r, N 0 N CD WELLNESS PROGRAM PERSONNEL -PAYROLL 0123.6471 WELLNESS 20.00 WYCKOFF,JEFF 0 0 F- F- W W W W CC CC VI VI VI VI COMBINED ELEC CREDIT (37.29) XCEL ENERGY SIGNAL TRAFFIC LIGHT 101 XCEL ENERGY SEWER MANAGEMENT LIFT STATION XCEL ENERGY O m Z77- EQUIPMENT REPAIR & MAINTENANCE uJ W W tn LIFTING STRAP 79.98 ZACKS co A 1` EQUIPMENT REPAIR & MAINTENANCE SEWER MANAGEMENT N GUTTER BRUSH STOCK 3,520.00 ZARNOTH BRUSH WORKS INC 3,327,308.45 GRAND TOTAL m N 4- 0 m N N b0 Page 119 of 120 Funds transferred electronically July 3 - July 16, 2024 PAYROLL $493,459.26 FIT/FICA $138,822.64 STATE INCOME TAX $30,472.29 PERA $141,695.15 HEALTH CARE SAVINGS PLAN $21,316.87 HEALTH SAVINGS ACCT $14,717.77 NATIONWIDE DEF COMP $6,865.86 MISSION SQUARE $4,807.12 MSRS $5,416.51 JOHN HANCOCK $3,491.51 Tax Levy (MN Revenue) $0.00 Child Support $338.71 ALERUS $1,320.38 Medica $208,188.56 AFLAC $4,496.10 NIS $4,230.92 METLIFE $9,707.71 FSA-Health & Limited Purpose Total $1,089,347.36 Page 120 of 120